sistem informasi stok barang pada gudang … · dan memberikan dukungannya di sela-sela...
TRANSCRIPT
SISTEM INFORMASI STOK BARANG PADA GUDANG
MENGGUNAKAN QR-CODE PADA SUPPLY CHAIN MANEGEMENT
(SCM) BERBASIS ANDROID
TUGAS AKHIR
Diajukan Untuk Memenuhi
Persyaratan Guna Meraih Gelar Sarjana Strata I
Teknik Informatika Universitas Muhammadiyah Malang
NADYA RIFKA
201110370311392
JURUSAN TEKNIK INFORMATIKA
FAKULTAS TEKNIK
UNIVERSITAS MUHAMMADIYAH MALANG
2016
i
ii
iii
iv
LEMBAR PERSEMBAHAN
1. Keluarga Tercinta saya, Bapak Drs Hadi Alzagladi, Ibunda Tercinta
Munira Bin Syeh Abubakar, Adik Tercinta Fakhri Muhammad yang merupakan sumber semangat saya beserta Keluarga Besar yang tak henti-hentikan memberikan dukungannya.
2. Pak Ilyas Nuryasin, S.Kom., M.Kom dan Pak Zamah Sari, S.T., M.T selaku dosen Pembimbing satu dan dua yang selalu membimbing hingga penulisan tugas akhir ini selesai beserta jajaran Kepala Jurusan,Sekertaris Jurusan, Dosen, Staff dan TU Teknik Informatika Universitas Muhammadiyah Malang.
3. Teman-Teman Seperjuang Informatika kelas H dan seluruh mahasisawa/i
Informatika 2011 yang selalu mendorong untuk menyelesaikan penulisan tugas akhir ini. Aditya Putra selaku Pacar yang selalu membantu, menemani, memotivasi dan memberikan dukungannya di sela-sela kesibukannya sebagai mahasiswa tingkat akhir. The Kandang’s yang selalu memberikan supportnya Nunu, Anti, Puput, Avhy M, Avhy S, Nina, Ocha terimakasih waktu 3 tahunnya.
4. Pihak-pihak lain yang terlibat dan telah membantu dalam penulisan skripsi
ini yang penulis tidak dapat sebutkan satu persatu.
vii
KATA PENGANTAR
Dengan memanjatkan puji dan syukur kehadirat Allah SWT atas limpahan
rahmat serta karunia-Nya sehingga penulis dapat menyelesaikan Tugas Akhir
dengan judul “SISTEM INFORMASI STOK BARANG PADA GUDANG
MENGGUNAKAN QR-CODE PADA SUPPLY CHAIN MANAGEMENT
(SCM) BERBASIS ANDROID” Penulis menyadari bahwa masih banyak kekurangan dan keterbatasan
dalam penulisan Tugas Akhir ini. Untuk itu, penulis sangat mengharapkan saran
yang membangun agar tulisan ini dapat berguna untuk pengembangan ilmu
pengetahuan kedepannya.
Malang, Januari 2016
Penulis
Nadya Rifka
NIM: 201110370311392
viii
DAFTAR ISI
Lembar Persetujuan ........................................................................................ i
Lembar Pengesahan ........................................................................................ ii
Lembar Pernyataan ......................................................................................... iii
Lembar Persembahan ...................................................................................... iv
Abstrak ........................................................................................................... v
Abstract .......................................................................................................... vi
Kata Pengantar ............................................................................................... vii
Daftar Isi ......................................................................................................... viii
Daftar Gambar ................................................................................................ xi
Daftar Tabel .................................................................................................... xiii
BAB I PENDAHULUAN
1.1 Latar Belakang Masalah ............................................................................ 1
1.2 Rumusan Masalah ..................................................................................... 2
1.3 Tujuan Penelitian ...................................................................................... 2
1.4 Batasan Masalah ....................................................................................... 2
1.5 Metode Penelitian ..................................................................................... 2
1.6 Sistematika Penulisan ................................................................................ 4
BAB II PEMBAHASAN ............................................................................... 5
2.1 Supply Chain Management ....................................................................... 5
2.1.1 Pengertian Supply Chain Management ................................................... 5
2.1.2 Pengertian Supply Chain Management Menurut Para Ahli ..................... 5
2.1.3 Komponen dari Supply Chain Management............................................ 5
2.1.4 Tujuan Supply Chain Management ......................................................... 6
2.1.5 Keuntungan Supply Chain Management ................................................. 6
2.1.6 Proses Supply Chain Management ......................................................... 7
ix
2.2 E-Supply Chain Management .................................................................... 9
2.2.1 Pengertian e-Supply Chain Management ................................................ 9
2.2.2 Prinsip Dasar Perancangan e-Supply Management ................................. 9
2.2.3 Kunci Sukses e-Supply Chain Management............................................ 10
2.2.4 Elemen dan unsur infrastruktur e-Supply Chain Management ................. 11
2.3 Pengertian Sistem ...................................................................................... 11
2.4 Konsep Dasar Informasi ............................................................................ 13
2.4.1 Pengertian Informasi. ............................................................................. 13
2.4.2 Kualitas Informasi .................................................................................. 13
2.4.3 Pengertian Pendataan ............................................................................. 14
2.5 Konssep Persediaan Barang....................................................................... 14
2.5.1 Pengertian Persediaan Barang ................................................................ 14
2.5.2 Fungsi Persediaan .................................................................................. 15
2.5.3 Maksud dan Tujuan Persediaan .............................................................. 16
2.6 QR Code ................................................................................................... 16
2.7 Barcode ..................................................................................................... 18
2.7.1 Cara Membaca Barcode ......................................................................... 19
2.8 Data Base .................................................................................................. 20
2.8.1 Komponen Sistem Data Base ................................................................. 20
2.9 Entity Relationship Diagram (ERD) .......................................................... 21
2.10 Data Base MySQL .................................................................................. 22
BAB III ANALISIS DAN PERANCANGAN SISTEM ............................... 25
3.1 Analisis Kebutuhan ................................................................................... 25
3.1.1 Proses Bisnis Sistem Saat Ini .................................................................. 25
3.1.2 Identifikasi Masalah ............................................................................... 26
3.1.3 Deskripsi Umum Sistem ......................................................................... 26
3.1.4 Pengguna User ....................................................................................... 26
3.1.5 Kebutuhan Fungsional ............................................................................ 27
3.2 Perancangan Sistem .................................................................................. 28
3.2.1 Data Flow Diagram (DFD) ..................................................................... 28
3.2.2 Data Flow Diagram Level 2 ................................................................... 29
x
3.3 Perancangan Data Base ............................................................................. 30
3.3.1 Conseptual Data Modeling (CDM) ......................................................... 30
3.3.2 Phisical Data Modeling .......................................................................... 31
3.4 Perancangan Interface ............................................................................... 35
3.4.1 Halaman Log In ..................................................................................... 36
3.4.2 Perancangan Interface Admin Gudang.................................................... 36
3.4.3 Perancangan Interface Admin Penjualan................................................. 39
3.4.4 Perancangan Interface Admin Pembelian ............................................... 42
BAB IV IMPLEMENTASI DAN PENGUJIAN .......................................... 45
4.1 Pengguna Aplikasi Pada Sistem. ............................................................... 45
4.1.1 Penjualan ............................................................................................... 45
4.1.2 Pembelian .............................................................................................. 45
4.1.3 Gudang .................................................................................................. 45
4.2 Implementasi Sistem ................................................................................. 45
4.2.1 Implementasi Halaman Aplikasi Web ..................................................... 46
4.2.2 Implementasi Halaman Divisi Pembelian ............................................... 47
4.2.3 Implementasi Halaman Gudang .............................................................. 55
4.2.4 Implementasi Halaman Divisi Penjualan ................................................ 66
BAB V PENUTUP ........................................................................................ 93
5.1 Kesimpulan ............................................................................................... 93
5.2 Saran ......................................................................................................... 93
Daftar Pustaka ................................................................................................ 94
xi
DAFTAR GAMBAR
Gambar 2.1 Contoh QR Code ............................................................................ 17
Gambar 2.2 Contoh Barcode .............................................................................. 19
Gambar 2.3 Contoh Relasi One To One ............................................................. 22
Gambar 2.4 Contoh Relasi One To Many ........................................................... 22
Gambar 2.5 Contoh Relasi Many To Many ........................................................ 22
Gambar 3.1 Sistem Informasi Stok Persediaan. .................................................. 25
Gambar 3.2 Diagram Konteks (DFD Level 1) .................................................... 29
Gambar 3.3 Data Flow Diagram Level 1 ............................................................ 29
Gambar 3.4 Conceptual Data Modeling ............................................................. 30
Gambar 3.5 Phisical Data Modeling ................................................................... 31
Gambar 3.6 Layout Halaman Login ................................................................... 36
Gambar 3.7 Layout Halaman Utama/Beranda .................................................... 17
Gambar 3.8 Layout Halaman Daftar Barang....................................................... 37
Gambar 3.9 Layout Halaman Daftar Persediaan ................................................ 38
Gambar 3.10 Layout Halaman Daftar Permintaan ............................................. 38
Gambar 3.11 Layout Beranda............................................................................. 38
Gambar 3.12 Laporan Penjualan ........................................................................ 40
Gambar 3.13 Permintaan .................................................................................... 41
Gambar 3.14 Layout Halaman Persediaan .......................................................... 42
Gambar 3.15 Layout Halaman Daftar Pembelian ............................................... 43
Gambar 3.16 Layout Halaman Daftar Permintaan .............................................. 44
Gambar 4.1 Tampilan Form Login ..................................................................... 46
Gambar 4.2 Halaman Utama Pembelian ............................................................. 47
Gambar 4.3 Halaman Daftar Permintaan Barang ................................................ 50
Gambar 4.4 Halaman Laporan Pembelian .......................................................... 52
Gambar 4.5 Halaman Cetak Laporan Pembelian ................................................ 52
Gambar 4.6 Halaman Laporan Persediaan .......................................................... 54
Gambar 4.7 Halaman Cetak Laporan Persediaan ................................................ 54
Gambar 4.8 Halaman Utama Gudang ................................................................. 56
Gambar 4.9 Halaman Daftar Permintaan Barang ................................................ 57
Gambar 4.10 Halaman Daftar Permintaan Barang .............................................. 59
xii
Gambar 4.11 Halaman Pembelian ..................................................................... 61
Gambar 4.12 Halaman Laporan Persediaan ........................................................ 62
Gambar 4.13 Halaman Cetak Laporan Persediaan .............................................. 63
Gambar 4.14 Halaman Laporan Pembelian ........................................................ 64
Gambar 4.15 Halaman Cetak Laporan Pembelian .............................................. 65
Gambar 4.16 Halaman Utama Penjualan ............................................................ 66
Gambar 4.17 Halaman Daftar Persediaan Stok Kritis ......................................... 68
Gambar 4.18 Form Permintaan Produk .............................................................. 70
Gambar 4.19 Halaman Daftar Permintaan Produk .............................................. 72
Gambar 4.20 Halaman Daftar Permintaan Pembelian ........................................ 74
Gambar 4.21 Halaman Jenis Produk ................................................................... 75
Gambar 4.22 Halaman Formn Input Jenis Produk .............................................. 76
Gambar 4.23 Halaman Form Edit Jenis Produk ................................................. 77
Gambar 4.24 Halaman Notifikasi Delete Jenis Produk ...................................... 78
Gambar 4.25 Halaman Produk .......................................................................... 79
Gambar 4.26 Halaman Form Input Produk ......................................................... 80
Gambar 4.27 Halaman Form Edit Produk........................................................... 81
Gambar 4.28 Halaman Notifikasi Delete Produk ................................................ 82
Gambar 4.29 Halaman Laporan Persediaan ........................................................ 83
Gambar 4.30 Halaman Cetak laporan Persediaan ............................................... 83
Gambar 4.31 Halaman Aplikasin Barcode Scanner ............................................ 85
Gambar 4.32 Halaman Scanner QR-Code .......................................................... 86
xiii
DAFTAR TABEL
Tabel 3. 1 Kebutuhan Fungsional ....................................................................... 28
Tabel 3. 2 Admin ............................................................................................... 32
Tabel 3. 3 Bahan ................................................................................................ 32
Tabel 3. 4 Persediaan barang .............................................................................. 33
Tabel 3. 5 Permintaan Pembelian ......................... Error! Bookmark not defined.
Tabel 3. 6 Permintaan Penjualan ........................................................................ 34
Tabel 3. 7 Pengeluaran ....................................................................................... 34
Tabel 3. 8 Pengeluaran ....................................... Error! Bookmark not defined.5
Tabel 4. 1 Pengujian Sistem Pembelian .............................................................. 86
Tabel 4. 2 Pengujian Sistem Manajemen Persediaan .......................................... 92
Tabel 4. 3 Pengujian Sistem Pembelian ............................................................. 94
1
DAFTAR PUSTAKA
[1] Agus, M., 2001, Manajemen Database dengan Microsoft Visual Basic Versi
6.0, Cetakan ke-3, Penerbit PT Elex Media Komputindo, Jakarta
[2] Drebin, A.R, 1999, Advance Accounting (Akuntansi Keuangan Lanjutan),
Alih bahasa oleh Freddy Saragih, Marianus Sinaga, Suryadi Saat, Edisi 5,
Cetakan ke-8, Penerbit Erlangga
[3] Kadir, A., 2003, Pengenalan Sistem Informasi, Edisi 1, Penerbit Andi,
Yogyakarta
[4] Kendall, K.E. dan J.E. Kendall, 2003, Analisis dan Perancangan Sistem,
Alih bahasa oleh Thamir Abdul Hafedh Al-Hamdany, Jilid 1 dan Jilid 2,
Edisi ke-5, PT Prenhallindo, Jakarta
[5] Mcleod Jr, R., G.Schell, 2004, Sistem Informasi Manajemen, Alih bahasa
oleh Hendra Teguh, Edisi 8, PT Indeks, Jakarta
[6] Mulyadi, 2001, Sistem Akuntansi, Edisi ke-3, Penerbit Salemba Empat,
Yogyakarta
[7] O’Brien, J.A., 2005, Pengantar Sistem Informasi, Edisi 12, Penerbit
Salemba Empat
[8] Skousen, K.F, Stice E.K dan J.D Stice, 2004, Akuntansi Intermediate, Edisi
15, Buku 1, Penerbit Salemba Empat
[9] Sutabri, T., 2004, Analisa Sistem Informasi, Edisi 1, Penerbit Andi,
Yogyakarta
[10] Sutanta, E., 2003, Sistem Informasi Manajemen, Edisi 1, Cetakan I,
Penerbit Graha Ilmu, Yogyakarta