ABSTRACT
Hendro Hodianto (03320070016) SYSTEM OF SPARE-PART PROCURE TO PAY VALUE CHAIN IN BANGKIT KARYA COMPANY (xxii + 189 pages, 74 tables , 109 figures , 4 appendixes) Bangkit Karya is a company enganged in the field of construction services, especially in heavy equipment rental and delivery. There are problems in company’s system of spare-part procure to pay value chain in which the system has crucial weaknesses that cause company’s loss. The weaknesses are: activities in the system only reported to the company orally so that the company has no data of the activities, the time of payment is unstructured, and no computerized data of suppliers, spare-part inventory and company’s purchasing. These weaknesses made the system need to be repaired soon to prevent bigger company’s loss. So that development of the new spare-part procure to pay value chain system need to be done. The construction of the new procure to pay value chain system done after some of steps namely: problems identification, requirements analysis, design and system construction. The new system is constructed to overcome the weaknesses of the old system. In the new system in addition to the design of new procredurial, there is also the construction of software. This software is needed for supports the new system procedurial. The software itself will be used as the provider of spare-part inventory, purchasing and suppliers data. Besides of that the software will also be used for making, saving and printing the documents of the new system. The software are made using PHP language and mySQL database. The new system and the software contained on it will ease Bangkit Karya company to overcome the weaknesses of the old spare-part procure to pay value chain system.
References: 11 (1996-2007)
vi
ABSTRAK
Hendro Hodianto (03320070016) SISTEM PROCURE TO PAY VALUE CHAIN SPARE-PART DI PT. BANGKIT KARYA (xxii + 189 halaman , 74 tabel , 109 gambar , 4 lampiran) PT Bangkit Karya adalah perusahaan yang bergerak di bidang jasa konstruksi, khususnya persewaan dan pengiriman alat berat. Terdapat masalah pada sistem procure to pay value chain spare-part di PT. Bangkit Karya dimana sistem tersebut memiliki kelemahan-kelemahan yang merugikan perusahaan. Kelemahan-kelemahan tersebut adalah: laporan beberapa kegiatan di dalam sistem hanya dilakukan secara lisan sehingga perusahaan tidak memiliki data tertulis mengenai kegiatan-kegiatan di dalam sistem, proses pelunasan tagihan yang tidak teratur serta tidak adanya data supplier, purchasing dan inventory spare-part yang terkomputerisasi. Kelemahan-kelemahan ini perlu segera dibenahi sehingga kerugian yang diderita perusahaan tidak semakin besar. Untuk itu dibuat sistem procure to pay value chain spare-part usulan yang mampu menjawab permasalahan tersebut. Sistem procure to pay value chain spare-part usulan terbentuk setelah dilakukan beberapa tahap perancangan yaitu: identifikasi masalah, analisis kebutuhan, desain dan konstruksi sistem baru. Sistem usulan ini dirancang untuk mengatasi masalah-masalah yang terjadi pada sistem yang lama. Dalam sistem usulan, selain dilakukan perancangan prosedur, dilakukan juga perancangan piranti lunak yang berguna untuk mendukung prosedur di sistem usulan. Piranti lunak digunakan pada sistem yang baru untuk membuat, mencetak dan menyimpan data dokumen-dokumen. Selain itu piranti lunak juga menyediakan data inventory spare-part dan supplier yang terkomputerisasi. Piranti lunak dibuat menggunakan PHP dengan database mySQL. Sistem usulan dengan piranti lunak di dalamnya akan memudahkan PT. Bangkit Karya untuk mengatasi kelemahan sistem procure to pay value chain spare-part yang lama.
Referensi: 11 (1996-2007)
vii
KATA PENGANTAR Puji syukur kepada Tuhan Yang Maha Esa atas berkat dan kasih-Nya sehingga penulis dapat menyelesaikan Laporan Tugas Akhir ini tepat pada waktunya. Laporan Tugas Akhir ini disusun untuk memenuhi sebagian persyaratan untuk memperoleh gelar Sarjana Teknik Industri Strata Satu. Penelitian dan pembuatan Laporan Tugas Akhir dilakukan dengan tujuan untuk melakukan penerapan teori-teori yang telah didapatkan di bangku perkuliahan pada keadaan nyata di lapangan. Dalam proses penyelesaian laporan ini, penulis mendapatkan bantuan, bimbingan serta arahan dari banyak pihak, oleh karena itu, pada kesempatan ini penulis ingin mengucapkan terima kasih yang sedalam-dalamnya kepada: 1.
Tuhan Yesus Kristus untuk segala berkat, kekuatan, bantuan, hikmat dan pengertian yang telah diberikan sehingga penulis mampu menyelesaikan laporan ini dengan baik.
2.
Kedua orang-tua penulis, atas segala dukungan, doa dan kepercayaan yang diberikan selama proses penyelesaian Laporan Tugas Akhir ini.
3.
Ibu Linasani Hadi selaku dosen pembimbing Tugas Akhir yang telah memberikan banyak bimbingan, arahan, masukan dan tuntunan dari awal hingga akhir penyusunan laporan ini.
4.
Bapak Rudy Vernando Silalahi selaku dosen pembimbing Tugas Akhir yang telah memberikan banyak bimbingan, arahan dan tuntunan dari awal hingga akhir penyusunan laporan ini.
5.
Bapak Laurence selaku Koordinator Tugas Akhir sekaligus ketua jurusan Teknik Industri yang telah banyak memberikan bimbingan dalam pelaksanaan tugas akhir.
6.
Jessica Widjaja atas segala dukungan, doa, bantuan, serta kepercayaan yang diberikan dalam proses penyelesaian Laporan Tugas Akhir ini sehingga laporan ini dapat diselesaikan dengan baik.
7.
Sally dan Veronica atas saran-saran dukungan serta perhatian yang diberikan sehingga laporan ini dapat diselesaikan dengan baik.
viii
8.
Ricky Nugroho atas bantuan, saran dan dukungan yang diberikan selama penyelesaian laporan ini.
9.
Segenap staff dan karyawan PT. Bangkit Karya atas dukungan dan bantuan yang diberikan selama proses penyelesaian laporan ini.
10. Rekan-rekan mahasiswa untuk segala saran dan dukungannya. 11. Pihak-pihak lain yang telah memberikan kontribusi dalam penyelesaian laporan ini namun belum sempat tersebutkan.
Akhir kata, semoga laporan ini dapat membawa manfaat yang positif bagi kita semua.
Karawaci, 13 Desember 2011
Penulis
ix
DAFTAR ISI ABSTRACT ....................................................................................................... vi ABSTRAK ........................................................................................................ vii KATA PENGANTAR ...................................................................................... viii DAFTAR TABEL ............................................................................................ xvi DAFTAR GAMBAR ........................................................................................ xix BAB 1 PENDAHULUAN ................................................................................... 1 1.1
Latar Belakang....................................................................................... 1
1.2
Rumusan Masalah.................................................................................. 2
1.3
Tujuan Penelitian ................................................................................... 3
1.4
Pembatasan Masalah .............................................................................. 4
1.5
Sistematika Penulisan ............................................................................ 4
BAB 2 TINJAUAN PUSTAKA ........................................................................... 8 2.1
Perancangan Sistem Informasi ............................................................... 8
2.1.1
Sistem Informasi dan Sistem Bisnis ................................................ 8
2.1.2
Sistem Procure to Pay ................................................................... 10
2.1.3
System Development Life Cycle (SDLC) ..................................... 11
2.2
Analisis SIPOC .................................................................................... 18
2.3
Data Flow Diagram (DFD) .................................................................. 19
2.4
Database .............................................................................................. 21
2.5
Database Management System (DBMS) .............................................. 21
2.5.1
Data Definition ............................................................................. 21
2.5.2
Data Manipulation ........................................................................ 21
2.5.3
Optimization and Execution .......................................................... 22
2.5.4
Data security and integrity ............................................................ 22
2.5.5
Data Recovery and Concurrency ................................................... 22
2.5.6
Data Dictionary ............................................................................ 22
2.5.7
Perfomance ................................................................................... 23
x
2.6
PostgreSQL ......................................................................................... 23
2.7
Structured Query Language (SQL) ...................................................... 24
2.8
Entity-Relationship Diagram (ERD) .................................................... 24
2.9
PHP ..................................................................................................... 27
2.10 Cascading Style Sheets (CSS) .............................................................. 27 BAB 3 METODE PENELITIAN ....................................................................... 28 3.1
Proses-proses penelitian: ...................................................................... 28
3.1.1
Penelitian Pendahuluan ................................................................. 28
3.1.2
Penentuan Topik dan Perumusan Masalah .................................... 28
3.1.3
Identifikasi Masalah...................................................................... 29
3.1.4
Menentukan Tujuan Penelitian ...................................................... 29
3.1.5
Studi Pustaka ................................................................................ 29
3.1.6
Pengumpulan dan Analisis Data.................................................... 29
3.1.7
Membuat Procure to Pay Value Chain Spare-Part Usulan ............. 30
3.1.8
Perancangan Database dan Tampilan Piranti lunak ....................... 30
3.1.9
Membuat Piranti lunak .................................................................. 31
3.1.10
Analisis dan Pembahasan Piranti lunak ......................................... 31
3.1.11
Kesimpulan dan Saran .................................................................. 31
3.2
Diagram Metode Penelitian.................................................................. 32
BAB 4 PENGUMPULAN DAN ANALISIS DATA .......................................... 33 4.1
Data Umum Perusahaan ....................................................................... 33
4.1.1
Profil Perusahaan .......................................................................... 33
4.1.2
Sejarah Perusahaan ....................................................................... 34
4.1.3
Produk Perusahaan ....................................................................... 35
4.1.4
Struktur Organisasi ....................................................................... 40
4.2
Data Khusus Perusahaan ...................................................................... 43
4.2.1
Procure to Pay Value Chain Spare-Part di PT. Bangkit Karya ....... 43
4.2.2 Analisis Kelemahan Sistem Procure to Pay Value Chain Spare-Part Sekarang ..................................................................................................... 48 BAB 5 SISTEM PROCURE TO PAY VALUE CHAIN SPARE-PART USULAN 52 5.1
Tujuan Sistem Procure to Pay Value Chain Spare-Part Usulan ............. 52
xi
5.2 Perencanaan Perbaikan Sistem Procure To pay Value Chain Spare-Part di PT. Bangkit Karya ...................................................................................... 53 5.3
Procure to Pay Value Chain Spare-Part Usulan .................................... 58
5.4
Analisis SIPOC Procure to Pay Value Chain Perbaikan....................... 67
5.4.1
SIPOC Laporan Kerusakan Alat Berat .......................................... 67
5.4.2
SIPOC Ijin Keluar Mekanik .......................................................... 68
5.4.3
SIPOC Pembuatan Purchase Order (PO) ...................................... 69
5.4.4
SIPOC Konfirmasi Purchase Order (PO) ..................................... 71
5.4.5
SIPOC Pemesanan Spare-part ...................................................... 72
5.4.6
SIPOC Penerimaan Spare-part ..................................................... 73
5.4.7
SIPOC Pembayaran Spare-part..................................................... 74
5.4.8
SIPOC Penyerahan Spare-part Kepada Mekanik .......................... 75
5.4.9
SIPOC Proses Input Supplier ........................................................ 76
5.4.10
SIPOC Pengembalian Surat Perintah Jalan .................................... 77
5.4.11
SIPOC Pelunasan Tagihan ............................................................ 78
BAB 6 PERANCANGAN LAYOUT TAMPILAN DAN DATABASE PIRANTI LUNAK SISTEM PROCURE TO PAY VALUE CHAIN SPARE-PART DI PT. BANGKIT KARYA .......................................................................................... 80 6.1
Analisis Kebutuhan Piranti lunak ......................................................... 80
6.1.1 Analisis Fungsi Membuat, Menyimpan dan Menampilkan Formulir Laporan Kerusakan ..................................................................................... 81 6.1.2 Analisis Fungsi Membuat, Menyimpan dan Menampilkan Data Surat Perintah Jalan .................................................................................... 82 6.1.3
Analisis Fungsi Piranti lunak Sebagai Database Spare-Part ......... 82
6.1.4
Analisis Fungsi Piranti lunak Sebagai Database Supplier.............. 84
6.1.5 Analisis Fungsi Membuat, Menyimpan dan Menampilkan Data Purchase Order Spare-part ......................................................................... 84 6.1.6 Analisis Fungsi Membuat, Menyimpan dan Menampilkan Data Pernyataan Permintaan Spare-Part (PSP).................................................... 85 6.1.7 Analisis Fungsi Membuat, Menyimpan dan Menampilkan Data Pernyataan Penyerahan Spare-Part (PPS) ................................................... 85 6.1.8 Analisis Fungsi Membuat, menyimpan dan Menampilkan Data Pengeluaran Lain-Lain ................................................................................ 85
xii
6.2
Perancangan Layout dan Penjelasan Tampilan Piranti lunak ................ 86
6.2.1
Tampilan Log In ........................................................................... 87
6.2.2
Tampilan Menu Utama ................................................................. 88
6.2.3
Tampilan Input Laporan Kerusakan .............................................. 90
6.2.4
Tampilan Rekapitulasi Laporan Kerusakan ................................... 91
6.2.5
Tampilan Surat Perintah Jalan....................................................... 92
6.2.6
Tampilan Rekapitulasi Surat Perintah Jalan .................................. 93
6.2.7
Tampilan Pernyataan Permintaan Spare-Part (PSP) ...................... 94
6.2.8
Tampilan Rekapitulasi PSP ........................................................... 95
6.2.9
Tampilan Purchase Order.............................................................. 96
6.2.10
Tampilan Rekapitulasi Purchase Order ........................................ 97
6.2.11
Tampilan Pengeluaran Lain .......................................................... 98
6.2.12
Tampilan Rekapitulasi Pengajuan Pengeluaran ............................. 99
6.2.13
Tampilan Formulir Penerimaan Spare-Part................................. 100
6.2.14
Tampilan Rekapitulasi Penerimaan Spare-Part ........................... 101
6.2.15
Tampilan Inventory Spare-Part ................................................... 102
6.2.16
Tampilan Input Jenis Spare-Part................................................. 103
6.2.17
Tampilan Input Nama Spare-Part ............................................... 104
6.2.18
Tampilan Input Supplier ............................................................. 104
6.2.19
Tampilan daftar Supplier ............................................................ 106
6.2.20
Tampilan Pernyataan Penyerahan Spare-Part ............................. 107
6.2.21
Tampilan Rekapitulasi Pernyataan Penyerahan Spare-Part ......... 107
6.3
Database Piranti lunak ....................................................................... 109
6.3.1
Diagram Aliran Data................................................................... 109
6.3.2
Kamus Spesifikasi Proses ........................................................... 121
6.3.3
Diagram Hubunngan Entitas dalam Database ............................ 132
6.3.4
Detil Tabel Data ......................................................................... 135
BAB 7 PIRANTI LUNAK DAN PEMBAHASANNYA .................................. 146 7.1
Penjelasan Tampilan Piranti Lunak .................................................... 146
7.1.1
Penjelasan Tampilan Log In........................................................ 146
7.1.2
Penjelasan Tampilan Menu Utama .............................................. 147
xiii
7.1.3
Penjelasan Tampilan Surat Perintah Jalan ................................... 148
7.1.4
Penjelasan Tampilan Rekapitulasi Surat Perintah Jalan ............... 149
7.1.5
Penjelasan Tampilan Pernyataan Permintaan Spare-Part (PSP) .. 149
7.1.6 Penjelasan Tampilan Rekapitulasi Pernyataan Permintaan SparePart (PSP) ................................................................................................ 150 7.1.7
Penjelasan Tampilan Pengeluaran Lain-Lain ............................... 151
7.1.8
Penjelasan Tampilan Rekapitulasi Pengeluaran lain-lain ............. 152
7.1.9
Penjelasan Tampilan Formulir Penerimaan Spare-Part ............... 153
7.1.10
Penjelasan Tampilan Rekapitulasi Penerimaan Spare-Part .......... 154
7.1.11
Penjelasan Tampilan Inventory Spare-Part ................................. 155
7.1.12
Penjelasan Tampilan Input Jenis Spare-Part ............................... 155
7.1.13
Penjelasan Tampilan Input Supplier ............................................ 156
7.1.14
Penjelasan Tampilan Daftar Supplier .......................................... 157
7.1.15
Penjelasan Tampilan Input Nama Spare-Part .............................. 157
7.1.16
Penjelasan Tampilan Buat Laporan Kerusakan............................ 158
7.1.17
Penjelasan Tampilan Buat Pernyataan Penyerahan Spare-Part (PPS) 158
7.1.18
Penjelasan Rekapitulasi Pernyataan Penyerahan Spare-Part (PPS) 159
7.2 Petunjuk Penggunaan Piranti Lunak Procure to Pay Value Chain SparePart PT. Bangkit Karya ................................................................................ 160 7.2.1 Memasuki Piranti Lunak Procure to Pay Value Chain Spare-Part PT. Bangkit Karya .................................................................................... 160 7.2.2
Pembuatan Purchase Order ........................................................ 161
7.2.3
Pembuatan Pengeluaran Lain-Lain .............................................. 163
7.2.4
Melihat Rekapitulasi Purchase Order ......................................... 164
7.2.5
Melihat Rekapitulasi Pengeluaran Lain-Lain ............................... 165
7.2.6
Melakukan Penerimaan Spare-Part ............................................. 166
7.2.7
Melihat Rekapitulasi Penerimaan Spare-Part .............................. 168
7.2.8
Melihat Inventory Spare-Part ...................................................... 169
7.2.9
Memasukkan Jenis Spare-Part .................................................... 170
7.2.10
Memasukkan Nama Spare-Part .................................................. 170
xiv
7.2.11
Pembuatan Surat Perintah Jalan (SPJ) ......................................... 171
7.2.12
Melihat Rekapitulasi Surat Perintah Jalan (SPJ) .......................... 172
7.2.13
Pembuatan Pernyataan Permintaan Spare-Part (PSP).................. 173
7.2.14
Pembuatan Pernyataan Penyerahan Spare-Part (PPS) ................. 175
7.2.15
Melihat Rekapitulasi Pernyataan Permintaan Spare-Part (PSP) .. 177
7.2.16
Melihat Rekapitulasi Pernyataan Penyerahan Spare-Part (PPS) .. 178
7.2.17
Memasukkan Supplier Baru ........................................................ 179
7.2.18
Mencetak Laporan Kerusakan ..................................................... 180
7.2.19
Memasukkan Data Laporan Kerusakan ....................................... 180
7.2.20
Menambahkan Pengguna Baru .................................................... 181
BAB 8 KESIMPULAN DAN SARAN ............................................................ 183 8.1
Kesimpulan........................................................................................ 183
8.2
Saran ................................................................................................. 187
DAFTAR PUSTAKA ...................................................................................... 188 LAMPIRAN .................................................................................................... 189
xv
DAFTAR TABEL Tabel 2.1 Tahap Identifikasi Masalah ................................................................. 11 Tabel 2.2 Tahap Studi Kelayakan....................................................................... 12 Tabel 2.3 Tahap Analisis Sistem ........................................................................ 14 Tabel 2.4 Tahap Desain Sistem Baru .................................................................. 15 Tabel 2.5 Tahap Konstruksi ............................................................................... 16 Tabel 2.6 Tahap Konversi .................................................................................. 17 Tabel 2.7 Tahap Perawatan Sistem ..................................................................... 18 Tabel 2.8 Contoh SIPOC.................................................................................... 19 Tabel 2.9 Simbol ERD ....................................................................................... 26 Tabel 4.1 Deskripsi Pekerjaan PT. Bangkit Karya .............................................. 41 Tabel 5.1 Rincian Kebutuhan Sistem Procure to Pay Value Chain Spare-Part Usulan ............................................................................................................... 57 Tabel 5.2 Perbedaan Dokumentasi Pada Sistem Lama dan Sistem Usulan .......... 66 Tabel 5.3 Keterangan Istilah Perbedaan Dokumentasi Sistem Lama dan Sistem Usulan ............................................................................................................... 66 Tabel 5.4 SIPOC Pelaporan Kerusakan Alat Bera .............................................. 68 Tabel 5.5 SIPOC Ijin Keluar Mekanik ............................................................... 69 Tabel 5.6 SIPOC Pembuatan Purchase Order .................................................... 70 Tabel 5.7 SIPOC Konfirmasi Purchase Order.................................................... 72 Tabel 5.8 SIPOC Proses Pemesanan Spare-part ................................................. 73 Tabel 5.9 SIPOC Penerimaan Spare-part ........................................................... 74 Tabel 5.10 SIPOC Proses Pembayaran Spare-part ............................................. 75 Tabel 5.11 SIPOC Proses Penyerahan Spare-part .............................................. 76 Tabel 5.12 SIPOC Proses Penyerahan Spare-part .............................................. 76 Tabel 5.13 SIPOC Proses Pengembalian SPJ ..................................................... 78 Tabel 5.14 SIPOC Pelunasan Tagihan ................................................................ 79 Tabel 6.1 Proses Penyimpanan Data Purchase Order ....................................... 122 Tabel 6.2 Proses Penyimpanan Data Pengeluaran Lain ..................................... 122 Tabel 6.3 Proses Definisi Bulan dan Tahun Purchase Order ............................ 122
xvi
Tabel 6.4 Proses Penyusunan Rekapitulasi Data Purchase Order ..................... 123 Tabel 6.5 Proses Definisi Bulan dan Tahun Pengeluaran Lain .......................... 123 Tabel 6.6 Proses Penyusunan Rekapitulasi Data Pengeluaran Lain ................... 124 Tabel 6.7 Proses Mengambil Data dari Database Purchase Order ................... 124 Tabel 6.8 Proses Penyimpanan Penerimaan Spare-Part .................................... 125 Tabel 6.9 Proses Definisi Bulan dan Tahun Penerimaan Spare-Part ................. 125 Tabel 6.10 Proses Penyusunan Rekapitulasi Data Penerimaan Spare-Part ........ 126 Tabel 6.11 Proses Perhitungan Inventory Spare-Part........................................ 126 Tabel 6.12 Proses Update Data Inventory Spare-Part ....................................... 127 Tabel 6.13 Proses Penyimpanan Jenis Spare-Part ............................................ 127 Tabel 6.14 Proses Penyimpanan Nama Spare-Part ........................................... 127 Tabel 6.15 Proses Penyimpanan Data SPJ ........................................................ 128 Tabel 6.16 Proses Definisi Bulan dan Tahun SPJ ............................................. 128 Tabel 6.17 Proses Penyusunan Rekapitulasi Data SPJ ...................................... 128 Tabel 6.18 Proses Penyimpanan PSP................................................................ 129 Tabel 6.19 Proses Definisi Bulan dan Tahun PSP............................................. 129 Tabel 6.20 Proses Penyusunan Rekapitulasi Data PSP ..................................... 129 Tabel 6.21 Proses Penyimpanan Data PPS ....................................................... 130 Tabel 6.22 Proses Definisi Bulan dan Tahun PPS............................................. 130 Tabel 6.23 Proses Penyusunan Rekapitulasi Data PPS ..................................... 130 Tabel 6.24 Proses Penyimpanan Supplier Baru ................................................ 131 Tabel 6.25 Tabel Data “spj” ............................................................................. 136 Tabel 6.26 Tabel Data “spj_detail”................................................................... 136 Tabel 6.27 Tabel Data “supplier” ..................................................................... 137 Tabel 6.28 Tabel Data “user” ........................................................................... 137 Tabel 6.29 Tabel Data “other_expenses” .......................................................... 138 Tabel 6.30 Tabel Data “other_expenses” .......................................................... 139 Tabel 6.31 Tabel Data “pppsm” ....................................................................... 139 Tabel 6.32 Tabel Data “pppsm_detail” ............................................................. 140 Tabel 6.33Tabel Data “purchase_order” ........................................................... 140 Tabel 6.34 Tabel Data “purchase_order_detail” ............................................... 141
xvii
Tabel 6.35 Tabel Data “sparepart” ................................................................... 142 Tabel 6.36 Tabel Data “sparepart_in” .............................................................. 142 Tabel 6.37 Tabel Data “sparepart_in_detail” .................................................... 143 Tabel 6.38 Tabel Data “sparepart_type” ........................................................... 144 Tabel 6.39 Tabel Data “pppsm_request” .......................................................... 144 Tabel 6.40 Tabel Data “pppsm_request_detail” ................................................ 145
xviii
DAFTAR GAMBAR Gambar 2.1 Simbol Terminator .......................................................................... 20 Gambar 2.2 Simbol Proses ................................................................................. 20 Gambar 2.3 Simbol Aliran Data ......................................................................... 20 Gambar 2.4 Contoh Hubungan Antar Entitas ..................................................... 26 Gambar 2.5 Contoh Coding PHP ....................................................................... 27 Gambar 3.1 Diagram Alir Proses Penulisan dan Penyelesaian Laporan Tugas Akhir ................................................................................................................. 32 Gambar 4.1 Excavator Kobelco SK-200............................................................. 36 Gambar 4.2 Excavator Komatsu PC-200 ............................................................ 36 Gambar 4.3 Excavator Caterpillar 320D............................................................. 37 Gambar 4.5 Bulldozer D65PX ........................................................................... 38 Gambar 4.6 Vibro Bomag BW212D .................................................................. 38 Gambar 4.7 Self-Loader 1 .................................................................................. 39 Gambar 4.8 Self-Loader 2 .................................................................................. 39 Gambar 4.9 Struktur Organisasi PT.Bangkit Karya ............................................ 40 Gambar 4.10 Diagram Alir Procure to Pay Value Chain Spare-Part Sekarang Alternatif 1 ........................................................................................................ 46 Gambar 4.11 Diagram Alir Procure to Pay Value Chain Sekarang Alternatif 2 ... 47 Gambar 5.1 Diagram Alir Sistem Procure to Pay Value Chain Spare-part Usulan Alternatif 1 ........................................................................................................ 62 Gambar 5.2 Diagram Alir Sistem Procure to Pay Value Chain Spare-part Usulan Alternatif 2 ........................................................................................................ 63 Gambar 5.3 Diagram Alir Proses Pelunasan Tagihan Spare-Part ........................ 64 Gambar 6.1 Rancangan Layout Login ................................................................ 87 Gambar 6.2 Rancangan Layout Main Menu ....................................................... 88 Gambar 6.3 Rancangan Layout Full Menu ......................................................... 89 Gambar 6.4 Rancangan Layout Formulir Laporan Kerusakan............................. 90 Gambar 6.5 Rancangan Layout Rekapitulasi Laporan Kerusakan ....................... 91 Gambar 6.6 Rancangan Layout Surat Perintah Jalan ........................................... 92 Gambar 6.7 Rancangan Layout Rekapitulasi Surat Perintah Jalan ...................... 93
xix
Gambar 6.8 Rancangan Layout PSP ................................................................... 94 Gambar 6.9 Rancangan Layout Rekapitulasi PSP ............................................... 95 Gambar 6.10 Rancangan Layout Purchase Order ............................................... 96 Gambar 6.11 Rancangan Layout Rekapitulasi Purchase Order .......................... 97 Gambar 6.12 Rancangan Layout Pengajuan Pengeluaran.................................... 98 Gambar 6.13 Rancangan Layout Rekapitulasi Pengajuan Pengeluaran ............... 99 Gambar 6.14 Rancangan Layout Penerimaan Spare-part .................................. 100 Gambar 6.15 Rancangan Layout Rekapitulasi Penerimaan Spare-Part ............. 101 Gambar 6.16 Rancangan Layout Inventory Spare-Part ..................................... 102 Gambar 6.17 Rancangan Layout Input Jenis Spare-Part ................................... 103 Gambar 6.18 Rancangan Layout Input Nama Spare-Part ................................. 104 Gambar 6.19 Rancangan Layout Input Supplier ............................................... 105 Gambar 6.20 Rancangan Layout Rekapitulasi Supplier .................................... 106 Gambar 6.21 Rancangan Layout PPS ............................................................... 107 Gambar 6.22 Rancangan Layout Rekap PPS ................................................... 108 Gambar 6.23 Diagram Aliran Data Pembuatan P.O .......................................... 110 Gambar 6.24 Diagram Aliran Data Pembuatan Pengeluaran Lain ..................... 111 Gambar 6.25 Diagram Aliran Data Cetak Rekap PO ........................................ 111 Gambar 6.26 Diagram Aliran Data Cetak Rekap Pengeluaran Lain .................. 112 Gambar 6.27 Diagram Aliran Data Pembuatan Penerimaan Spare-Part ............ 113 Gambar 6.28 Diagram Aliran Data Cetak Rekap Penerimaan Spare-Part .......... 114 Gambar 6.29 Diagram Aliran Data Perhitungan Inventory Spare-Part ............. 115 Gambar 6.30 Diagram Aliran Data Input Jenis Spare-Part ............................... 115 Gambar 6.31 Diagram Aliran Data Input Nama Spare-Part ............................. 116 Gambar 6.32 Diagram Aliran Data SPJ ............................................................ 116 Gambar 6.33 Diagram Aliran Data Cetak Rekap SPJ ....................................... 117 Gambar 6.34 Diagram Aliran Pembuatan PSP.................................................. 118 Gambar 6.35 Diagram Aliran Data Pembuatan PPS ......................................... 119 Gambar 6.36 Diagram Aliran Data Cetak Rekap PSP....................................... 119 Gambar 6.37 Diagram Aliran Data Cetak Rekap PPS....................................... 120 Gambar 6.38 Diagram Aliran Data Pembuatan Laporan Kerusakan.................. 121
xx
Gambar 6.39 Diagram Aliran Data Proses Input Supplier ................................. 121 Gambar 6.40 Entity Relationship Diagram Database Piranti lunak. .................. 132 Gambar 7.1 Tampilan Login ............................................................................ 147 Gambar 7.2 Tampilan Menu Utama ................................................................. 148 Gambar 7.3 Tampilan Menu Utama 2 .............................................................. 148 Gambar 7.4 Tampilan Surat Perintah Jalan ....................................................... 149 Gambar 7.5 Tampilan Rekapitulasi Surat Perintah Jalan .................................. 149 Gambar 7.6 Tampilan Pernyataan Permintaan Spare-Part ................................ 150 Gambar 7.7 Tampilan Rekapitulasi PSP ........................................................... 151 Gambar 7.8 Tampilan Pengeluaran lain-lain ..................................................... 152 Gambar 7.9 Tampilan Rekapitulasi Pengeluaran lain-lain ................................ 153 Gambar 7.10 Tampilan Formulir Penerimaan Spare-Part ................................. 154 Gambar 7.11 Tampilan Rekapitulasi Penerimaan Spare-Part ........................... 155 Gambar 7.12 Tampilan Inventory Spare-Part ................................................... 155 Gambar 7.13 Tampilan Input Jenis Spare-Part ................................................. 156 Gambar 7.14 Tampilan Input Supplier ............................................................. 156 Gambar 7.15 Tampilan Daftar Supplier ............................................................ 157 Gambar 7.16 Tampilan Input Nama Spare-Part ............................................... 157 Gambar 7.17 Tampilan Buat Laporan Kerusakan ............................................. 158 Gambar 7.18 Tampilan Buat Pernyataan Penyerahan Spare-Part (PPS) ........... 159 Gambar 7.19 Tampilan Rekapitulasi Pernyataan Penyerahan Spare-Part (PPS) 160 Gambar 7.20 Tampilan Login........................................................................... 161 Gambar 7.21 Menu Utama ............................................................................... 161 Gambar 7.22 Contoh Purchase Order .............................................................. 162 Gambar 7.23 Daftar Purchase Order................................................................ 162 Gambar 7.24 Contoh Pengeluaran Lain ............................................................ 164 Gambar 7.25 Daftar Pengeluaran Lain ............................................................. 164 Gambar 7.26 Rekapitulasi Purchase Order ...................................................... 165 Gambar 7.27 Rekapitulasi Pengeluaran Lain .................................................... 166 Gambar 7.28 Contoh Penerimaan Spare-Part.................................................... 167 Gambar 7.29 Daftar Penerimaan Spare-Part .................................................... 167
xxi
Gambar 7.30 Rekap Penerimaan Spare-Part .................................................... 168 Gambar 7.31 Tampilan Inventory Spare-Part ................................................... 169 Gambar 7.32 Tampilan Input Jenis Spare-Part ................................................. 170 Gambar 7.33 Tampilan Input Nama Spare-Part ............................................... 171 Gambar 7.34 Contoh Tampilan SPJ ................................................................. 172 Gambar 7.35 Tampilan Daftar SPJ ................................................................... 172 Gambar 7.36 Tampilan Rekapitulasi SPJ.......................................................... 173 Gambar 7.37 Contoh PSP ................................................................................ 175 Gambar 7.38 Tampilan Daftar PSP .................................................................. 175 Gambar 7.39 Contoh PPS ................................................................................ 176 Gambar 7.40 Tampilan Daftar PPS .................................................................. 176 Gambar 7.41 Tampilan Rekapitulasi PSP ......................................................... 177 Gambar 7.42 Tampilan Rekapitulasi PPS ......................................................... 178 Gambar 7.43 Tampilan Input Supplier ............................................................. 179 Gambar 7.44 Tampilan Input Laporan Kerusakan ............................................ 181 Gambar 7.45 Tampilan Daftar Laporan Kerusakan .......................................... 181 Gambar 7.46 Tampilan Input Pengguna Baru ................................................... 182 Gambar 8.1 Diagram Alir Sistem Procure to Pay Value Chain Sparepart Usulan 1 ...................................................................................................................... 184 Gambar 8.2 Diagram Alir Sistem Procure to Pay Value Chain Sparepart Usulan 2 ...................................................................................................................... 185 Gambar 8.3 Diagram Alir Proses Pelunasan Tagihan ....................................... 186
xxii
