Perancangan Sistem Informasi Persediaan Berbasis Microsoft Access pada Mebel Al Bantani10

Abstract

Pengelolaan persediaan yang masih dilakukan secara manual berpotensi menimbulkan kesalahan pencatatan, ketidaksesuaian stok, dan keterlambatan penyusunan laporan. Penelitian ini bertujuan untuk menganalisis kondisi sistem persediaan, merancang, mengimplementasikan, dan mengevaluasi sistem informasi persediaan berbasis Microsoft Access pada Mebel Al Bantani10. Penelitian menggunakan metode System Development Life Cycle (SDLC) dengan model Waterfall. Data dikumpulkan melalui observasi, wawancara, dan dokumentasi. Hasil penelitian menunjukkan bahwa sistem yang dirancang mampu mengintegrasikan pencatatan barang masuk, barang keluar, pengendalian stok, dan penyusunan laporan persediaan secara terkomputerisasi. Implementasi sistem meningkatkan keakuratan data persediaan, mempercepat proses pengolahan data, serta mempermudah penyusunan laporan. Hasil evaluasi menggunakan Black Box Testing dan User Acceptance Testing (UAT) menunjukkan bahwa seluruh fungsi sistem berjalan sesuai dengan kebutuhan pengguna. Dengan demikian, sistem informasi persediaan berbasis Microsoft Access mampu mendukung pengelolaan persediaan yang lebih efektif, efisien, dan akurat pada Mebel Al Bantani10.

Manual inventory management is prone to recording errors, stock discrepancies, and delays in report preparation, highlighting the need for an effective inventory information system. This study aims to analyze the existing inventory system, design, implement, and evaluate a Microsoft Access-based inventory information system at Mebel Al Bantani10. The study employed the System Development Life Cycle (SDLC) using the Waterfall model. Data were collected through observation, interviews, and documentation. The results indicate that the previous inventory system was managed manually, resulting in recording errors and stock inconsistencies. The developed system integrates the recording of incoming and outgoing goods, inventory control, and inventory reporting into a computerized system. Its implementation improved inventory data accuracy, accelerated data processing, and simplified report preparation. Evaluation using Black Box Testing and User Acceptance Testing (UAT) showed that all system functions met user requirements. Therefore, the Microsoft Access-based inventory information system effectively supports more efficient, accurate, and reliable inventory management at Mebel Al Bantani10.