KATA PENGANTAR PENGA Puji syukur kehadirat Allah SWT yang telah memberikan nikmat dan karunia-Nya Nya sehingga penulis dapat menyelesaikan Proyek Akhir, yang penulis beri judul: “ Sistem Informasi Pembelian Dan Persediaan Barang ( Studi Kasus Kopegtel Divre III Bandung) ” maksud dan an tujuan dari penulisan Proyek Akhir ini adalah untuk memenuhi dan melengkapi salah satu syarat dalam ujian sidang Proyek Akhir program Diploma Tiga (D3) Komputer Akuntansi Politeknik Telkom. Dalam penyusunan Tugas Akhir ini penulis memperoleh bantuan, bimbingan mbingan dan pengarahan dari berbagai pihak. Oleh karena itu, dengan segenap kerendahan hati penulis mengucapkan terima kasih kepada Bapak Indra Firmansyah dan Ibu Magdalena Karismariyanti selaku pembimbing yang selalu memberi bantuan dan arahan. Dan tidak lupa terima kasih kepada Koperasi Pegawai Telkom Divre III Bandung selaku perusahaan yang telah memberikan kesempatan untuk penulis melakukan implementasi. Penulis menyadari bahwa dalam proyek akhir ini masih terdapat banyak kekurangan. Oleh karena itu, kritik kritik dan saran yang membangun sangat penulis harapkan demi perbaikan proyek akhir ini Semoga proyek akhir ini memberikan manfaat bagi semua pihak yang berkepentingan. Amin.
Bandung, 18 Oktober 2010
Penulis
v
DAFTAR ISI I. PERNYATAAN ................................................................................................ ................................ ............................................................. 3 KATA PENGANTAR ................................................................................................ ................................ ..................................................... v ABSTRAK ................................................................................................................................ ................................ ................................... vi ABSTRACT ................................................................................................................................ ................................ ................................ vii DAFTAR ISI .............................................................................................................................. ................................ .............................. viii DAFTAR GAMBAR ................................................................................................ ................................ ...................................................... x DAFTAR TABEL ................................................................................................ ................................ .......................................................... xi II.
PENDAHULUAN ................................................................................................ ................................ ................................................. 1
1.1
Latar Belakang ................................................................................................ ................................ ................................................. 1
1.2
Rumusan Masalah................................ ................................................................................................ ............................................ 2
1.3
Tujuan .............................................................................................................................. ................................ .............................. 2
1.4
Batasan Masalah ................................................................................................ ................................ .............................................. 3
1.5
Metodologi Penelitian ................................................................................................ .................................... 3
2
TINJAUAN PUSTAKA ................................................................................................ .......................................... 5
2.1
Pengertian Persediaan Barang................................................................ ......................................................... 5
2.2
Metode Fifo ................................................................................................ ................................ ..................................................... 6 1.
Biaya Pembelian Barang Dagang................................................................ .................................. 7
2.3
Website ................................................................................................ ................................ ............................................................ 7
2.4
PHP................................................................................................................................ ................................ ................................... 8
2.5
Database MySQL ................................................................................................ ................................ .............................................. 8
2.6
Entity Relationship Diagram ................................................................ ............................................................ 9
2.7
Data Flow Diagram (DFD) .............................................................................................. .............................. 10
ANALISIS KEBUTUHAN DAN PERANCANGAN ................................................................ .......................................... 14 3.1.3
Analisis Masukan dan Keluaran................................................................ Keluaran .................................. 18
3.2
Spesifikasi Kebutuhan Perangkat Keras (Hardware) ..................................................... ................................ 18
3.3
Kebutuhan Perangkat Lunak ................................................................ .......................................................... 19
viii
3.4
3.5
3.6
Analisis Penggunan ................................................................................................ ........................................ 19 3.4.1
Skema Relasi Antar Tabel ................................................................ ........................................... 21
3.4.2
Dekomposisi Tabel ................................................................ ..................................................... 22
Perancangan Sistem................................................................................................ Sistem ....................................... 25 3.5.1
Data Aliran Diagram Level 0 ................................................................ ....................................... 25
3.5.2
Data Aliran Diagram Level 1 ................................................................ ....................................... 26
3.5.3
Data Aliran Diagram Level 2 ................................................................ ....................................... 27
3.5.4
Kamus Data ................................................................................................ ................................ 30
3.5.5
Proses Spesifikasi ................................................................ ....................................................... 33
Struktur Menu ................................................................................................ ................................ ............................................... 38 3.6.1
Perancan Perancangan Menu Gudang ................................................................ ....................................... 38
3.6.2
Perancangan Menu Penjualan ................................................................ ................................... 38
3.6.3
Perancangan Menu Pembelian ................................................................ .................................. 38
3.6.4
Perancangan Menu Bendahara ................................................................ .................................. 39
3.6.5
Perancangan Antarmuka ................................................................ ............................................ 40
4.
IMPLEMENTASI DAN PENGUJIAN ................................................................ .................................................... 42
4.1
Implementasi ................................................................................................ ................................ ................................................. 42
4.2
4.1.1
Implementasi Antarmuka Sistem ............................................................... ............................... 42
4.1.2
Implementasi struktur table ................................................................ ...................................... 44
Pengujian ................................................................................................ ................................ ....................................................... 48 4.2.1
Pengujian Fungsionalitas................................................................ ............................................ 48
5.
PENUTUP ................................................................................................ ................................ ......................................................... 55
5.1
Kesimpulan ................................................................................................ ................................ .................................................... 55
5.2
Saran .............................................................................................................................. ................................ .............................. 55
REFERENSI................................................................................................................................ ................................ ................................ 56
ix
DAFTAR GAMBAR Gambar 2-1 1 Proses bisnis eksisting ................................................................................................ ........................................15 Gambar 2-2 2 Proses Bisnis Usulan ................................................................................................ ...........................................17 Gambar 3-3 3 Analisis Masukan dan Keluaran ................................................................ ..........................................................18 Gambar 3-4 Entity Relationship Diagram ................................................................ ...............................................................20 Gambar 3-5 5 Skema Relasi Antar Tabel ................................................................................................ ...................................21 Gambar 3-6 6 Data Aliran Diagram Level 0 ................................................................ ...............................................................25 Gambar 3-7 7 Diagram Aliran Data Level 1 ................................................................ ...............................................................26 Gambar 3-8 8 Diagram Aliran Data Level 2 Proses 1.0 ................................................................ ..............................................27 Gambar 3-9 9 Data Aliran Diagram Level 2 Proses 4.0 ................................................................ ..............................................28 Gambar 3-10 10 Perancangan menu gudang ................................................................ ..............................................................38 Gambar 3-11 11 Perancangan menu penjualan ................................................................ ..........................................................38 Gambar 3-12 12 Perancangan menu pembelian ................................................................ .........................................................39 Gambar 3-13 13 Perancangan menu bendahara ................................................................ ........................................................39 Gambar 3-14 Halaman Login ................................................................................................ ................................ ..................................................40 Gambar 3-15 Halaman Awal ................................................................................................ ................................ ...................................................41 Gambar 4-1 Log In ................................................................................................ ................................ ..................................................................42 Gambar 4-2 Halaman Awal ................................................................................................ ................................ .....................................................43 Gambar 5-3 3 Halaman lihat data barang ................................................................ .................................................................44
x
DAFTAR TABEL Table 3.1 Tabel Pelanggan ............................................................................. ............. 33 Table 3.2 Tabel Paket Wisata ................................................................ ........................................ 34 Table 3.3 Tabel Supplier ................................................................................ ................ 34 Table 3.4 Tabel Pemesanan ........................................................................... ........... 35 Table 3.5 Tabel Penerimaan ................................................................ .......................................... 36 Table 3.6 Tabel Pengeluaran ................................................................ ......................................... 36 Table 3.7 Tabel Memiliki............................................................................... ............... 37 Tabel 3.8 Spesifikasi proses Input_ pelanggan ............................................... ............... 50 Tabel 3.9 Spesifikasi proses update pelanggan ............................................. ............. 51 Tabel 3.10 Spesifikasi proses delet_ pelanggan ............................................. ............. 51 Tabel 3.11 Spesifikasi fikasi proses input barang .................................................... .................... 52 Tabel 3.12 Spesifikasi ikasi proses update barang ................................................. ................. 52 Tabel 3.13 Spesifikasi ikasi proses delete barang................................................... barang ................... 53 Tabel 3.14 Spesifikasi fikasi proses input pembelian .............................................. .............. 53 Tabel 3.15 Spesifikasi esifikasi proses update pembelian ........................................... ........... 54 Tabel 3.16 Spesifikasi esifikasi proses delete pembelian............................................. ............. 54 Tabel 3.17 Spesifikasi pesifikasi proses input kehilangan .............................................. .............. 55 Tabel 3.18 Spesifikasi proses input retur ....................................................... ....................... 55 Tabel 3.19 Spesifikasi proses ................................................................ ......................................... 56 Tabel 3.20 Spesifikasi proses cek_barang ...................................................... ...................... 57 Tabel 3.21 Spesifikasi proses pilih paket ........................................................ ........................ 57 Tabel 3.22 Spesifikasi proses catat pemesanan ............................................. ............. 58 Tabel 3.23 Spesifikasi proses laporan_pelanggan .......................................... ................................ 58 Tabel 3.24 Spesifikasi proses laporan_paket_wisata ..................................... ................................ 59
xi
