xi
DAFTAR ISI
HALAMAN JUDUL .................................................................................................. i HALAMAN PENGAKUAN KEASLIAN TA ......................................................... ii SURAT KETERANGAN PELAKSANAAN PERUSAHAAN .............................. iii HALAMAN PENGESAHAN PEMBIMBING ....................................................... iv HALAMAN PENGESAHAN PENGUJI ................................................................. v HALAMAN PERSEMBAHAN ................................................................................ vi HALAMAN MOTTO ................................................................................................ vii KATA PENGANTAR ................................................................................................. viii ABSTRAK .................................................................................................................. x DAFTAR ISI ............................................................................................................... xi DAFTAR TABEL ....................................................................................................... xiii DAFTAR GAMBAR .................................................................................................. xiv BAB I PENDAHULUAN........................................................................................... 1 1.1 Latar Belakang ............................................................................................... 1 1.2 Rumusan Masalah.......................................................................................... 3 1.3 Batasan Masalah ............................................................................................ 3 1.4 Tujuan Penelitian ........................................................................................... 4 1.5 Manfaat Penelitian ......................................................................................... 4 1.6 Sistematika Penulisan Tugas Akhir ............................................................... 4 BAB II KAJIAN LITERATUR ................................................................................ 6 2.1 Kajian Literatur Deduktif .............................................................................. 6 2.1.1 Manajemen Inventory ............................................................................. 6 2.1.1.1 Inventory ............................................................................................ 6 2.1.1.2 Manajemen Inventory ........................................................................ 8 2.1.2 Sistem Informasi Manajemen ................................................................. 12 2.1.2.1 Konsep Dasar Sistem ......................................................................... 12 2.1.2.2 Konsep Dasar Informasi .................................................................... 14 2.1.2.3 Konsep Dasar Manajemen ................................................................. 15 2.1.2.4 Konsep Dasar Sistem Informasi ........................................................ 16 2.1.2.5 Konsep Dasar Sistem Informasi Manajemen..................................... 18 2.1.3 Pengembangan Sistem Informasi ........................................................... 18 2.1.4 Alat Bantu Perancangan Sistem ............................................................. 21 2.1.4.1 Bagan Alir (Flowchart) ...................................................................... 21 2.1.4.2 Diagram Konteks (Context Diagram)................................................ 22 2.1.4.3 Data Flow Diagram (DFD) ............................................................... 23 2.1.4.4 Kamus Data (Data Dictionary).......................................................... 27 2.1.4.5 Entity Relationship Diagram (ERD).................................................. 27 2.1.4.6 Relasi Antar Tabel .............................................................................. 30 2.1 Kajian Literatur Induktif ................................................................................ 31
xii BAB III METODE PENELITIAN ........................................................................... 34 3.1 Objek Penelitian ............................................................................................ 34 3.2 Sumber Data .................................................................................................. 34 3.3 Metode Pengumpulan Data ........................................................................... 35 3.4 Perancangan Sistem ....................................................................................... 35 3.4.1 Analisis Sistem ....................................................................................... 35 3.4.1.1 Analisis Masalah ................................................................................ 36 3.4.1.2 Analisis Kebutuhan ............................................................................ 37 3.4.2 Desain Sistem ......................................................................................... 37 3.4.2.1 Desain Proses ..................................................................................... 38 3.4.2.2 Desain Basis Data (Database) ........................................................... 38 3.4.2.3 Desain Input ....................................................................................... 39 3.4.2.4 Desain Output .................................................................................... 40 3.5 Software yang Digunakan .............................................................................. 40 3.5.1 Software Visual Basic ............................................................................. 40 3.5.2 Software Microsoft Access ..................................................................... 41 3.6 Diagram Alir Penelitian ................................................................................. 42 BAB IV PENGUMPULAN DAN PENGOLAHAN DATA .................................... 43 4.1 Pengumpulan Data ......................................................................................... 43 4.1.1 Tinjauan Inventory UKM ....................................................................... 43 4.1.2 Proses Bisnis Inventory UKM ................................................................ 43 4.2 Pengolahan Data ............................................................................................ 45 4.2.1 Analisis Masalah .................................................................................... 45 4.2.2 Analisis Kebutuhan ................................................................................ 47 4.2.3 Desain Proses .......................................................................................... 49 4.2.3.1 Flowchart ........................................................................................... 49 4.2.3.2 Diagram Konteks ............................................................................... 53 4.2.3.3 Data Flow Diagram (DFD) ............................................................... 54 4.2.3.4 Kamus Data........................................................................................ 58 4.2.4 Desain Basis Data (Database) ................................................................ 60 4.2.4.1 Entity Relationship Diagram (ERD).................................................. 60 4.2.4.2 Relasi Antar Tabel .............................................................................. 63 4.2.5 Desain Input............................................................................................ 72 4.2.6 Desain Output ......................................................................................... 82 BAB V PEMBAHASAN ............................................................................................ 89 5.1 Manajemen Inventory .................................................................................... 89 5.2 Sistem Informasi Manajemen Inventory ........................................................ 89 5.3.1 Verifikasi ................................................................................................. 89 5.3.2 Validasi ................................................................................................... 94 BAB VI PENUTUP .................................................................................................... 100 6.1 Kesimpulan .................................................................................................... 100 6.2 Saran .............................................................................................................. 101 DAFTAR PUSTAKA
xiii
DAFTAR TABEL
Tabel 2.1 Simbol-simbol flowchart.............................................................................. 21 Tabel 2.2 Simbol-simbol kamus data ........................................................................... 27 Tabel 2.3 Perbandingan penelitian ............................................................................... 33 Tabel 4.1 Kamus data bahan baku ............................................................................... 58 Tabel 4.2 Kamus data barang jadi ................................................................................ 59 Tabel 4.3 Kamus data truk penjualan barang jadi ........................................................ 59 Tabel 4.4 Tabel pemesanan .......................................................................................... 64 Tabel 4.5 Tabel pembelian ........................................................................................... 64 Tabel 4.6 Tabel supplier ............................................................................................... 65 Tabel 4.7 Tabel pengeluaran bahan baku untuk produksi ............................................ 65 Tabel 4.8 Tabel bahan baku.......................................................................................... 66 Tabel 4.9 Tabel persediaan bahan baku ....................................................................... 66 Tabel 4.10 Tabel persediaan bahan baku detail............................................................ 67 Tabel 4.11 Tabel admin ................................................................................................ 67 Tabel 4.12 Tabel penjualan .......................................................................................... 68 Tabel 4.13 Tabel kedatangan barang jadi hasil produksi ............................................. 68 Tabel 4.14 Tabel barang jadi ........................................................................................ 69 Tabel 4.15 Tabel persediaan barang jadi ...................................................................... 69 Tabel 4.16 Tabel persediaan barang jadi detail ............................................................ 70 Tabel 5.1 Jumlah pengeluaran bahan baku kulit sapi untuk produksi selama satu bulan terakhir (30 hari) .......................................................................................................... 95 Tabel 5.2 Standart deviasi pengeluaran bahan baku kulit sapi untuk produksi selama satu bulan terakhir (30 hari) ......................................................................................... 97
xiv
DAFTAR GAMBAR
Gambar 2.1 Aliran material di gudang......................................................................... 9 Gambar 2.2 Grafik pengendalian persediaan dengan model P .................................... 11 Gambar 2.3 Elemen-elemen sistem ............................................................................. 13 Gambar 2.4 Blok sistem informasi yang berinteraksi.................................................. 17 Gambar 2.5 Siklus hidup tahap pengembangan sistem ............................................... 20 Gambar 2.6 Contoh diagram konteks .......................................................................... 23 Gambar 2.7 Simbol entitas luar ................................................................................... 24 Gambar 2.8 Simbol aliran data .................................................................................... 24 Gambar 2.9 Simbol proses ........................................................................................... 25 Gambar 2.10 Simbol penyimpanan data ...................................................................... 26 Gambar 2.11 Contoh data flow diagram (DFD) .......................................................... 26 Gambar 2.12 Simbol entitas......................................................................................... 28 Gambar 2.13 Simbol atribut......................................................................................... 28 Gambar 2.14 Simbol relasi .......................................................................................... 28 Gambar 2.15 Contoh entity relationship diagram (ERD) ........................................... 29 Gambar 2.16 Relasi ERD one to one ........................................................................... 29 Gambar 2.17 Relasi ERD one to many ........................................................................ 30 Gambar 2.18 Relasi ERD many to many ..................................................................... 30 Gambar 3.1 Diagram alir penelitian ............................................................................ 42 Gambar 4.1 Proses bisnis inventory ............................................................................. 44 Gambar 4.2 Fishbone diagram .................................................................................... 46 Gambar 4.3 Flowchart pemesanan bahan baku ........................................................... 50 Gambar 4.4 Flowchart pencatatan bahan baku ........................................................... 51 Gambar 4.5 Flowchart pencatatan barang jadi ............................................................ 52 Gambar 4.6 Diagram konteks ...................................................................................... 53 Gambar 4.7 Data flow diagram level 0 ....................................................................... 54 Gambar 4.8 Data flow diagram level 1 proses 1 ......................................................... 56 Gambar 4.9 Data flow diagram level 1 proses 2 ......................................................... 57 Gambar 4.10 Entity relationship diagram ................................................................... 61 Gambar 4.11 Kardinalitas ERD ................................................................................... 62 Gambar 4.12 Relasi antar tabel .................................................................................... 71 Gambar 4.13 Struktur menu utama .............................................................................. 72 Gambar 4.14 Rancangan form login ............................................................................ 73 Gambar 4.15 Rancangan form menu utama................................................................. 74 Gambar 4.16 Rancangan form input data admin ......................................................... 74 Gambar 4.17 Rancangan form input data supplier ...................................................... 75 Gambar 4.18 Rancangan form input data bahan baku ................................................. 76 Gambar 4.19 Rancangan form input data produk ........................................................ 77 Gambar 4.20 Rancangan form input data pembelian ................................................... 78 Gambar 4.21 Rancangan form input data pengeluaran bahan baku untuk produksi ... 79 Gambar 4.22 Rancangan form input data kedatangan produk hasil produksi ............. 80 Gambar 4.23 Rancangan form input data penjualan .................................................... 81 Gambar 4.24 Rancangan form data pemesanan bahan baku ....................................... 83 Gambar 4.25 Rancangan faktur penjualan ................................................................... 84
xv Gambar 4.26 Rancangan form laporan persediaan bahan baku ................................... 85 Gambar 4.27 Rancangan output laporan persediaan bahan baku ................................ 86 Gambar 4.28 Rancangan output laporan transaksi bahan baku ................................... 86 Gambar 4.29 Rancangan form laporan persediaan produk .......................................... 87 Gambar 4.30 Rancangan output laporan persediaan produk ....................................... 88 Gambar 4.31 Rancangan output laporan transaksi produk .......................................... 88 Gambar 5.1 Data pembelian bahan baku ..................................................................... 90 Gambar 5.2 Data pengeluaran bahan baku untuk produksi ......................................... 91 Gambar 5.3 Data stok persediaan bahan baku ............................................................. 91 Gambar 5.4 Data kedatangan produk hasil produksi ................................................... 92 Gambar 5.5 Data penjualan produk ............................................................................. 93 Gambar 5.6 Data stok persediaan produk .................................................................... 93 Gambar 5.7 Data pemesanan ....................................................................................... 95 Gambar 5.8 Data pemesanan perbandingan ................................................................ 99