Design of An AppSheet Based Inventory Management Information System for Warehouses Using the Waterfall Method

Firdan Anugrah Jaya; Amay Suherman; Aulia Zikri Rahman

doi:10.31334/logistik.v9i1.4627

Design of An AppSheet Based Inventory Management Information System for Warehouses Using the Waterfall Method

Firdan Anugrah Jaya, Amay Suherman, Aulia Zikri Rahman

Abstract

Accurate inventory recording is a crucial aspect of maintaining warehouse operational efficiency. XYZ Institution is a government agency that operates two distinct types of warehouses: the Central Supply Warehouse and the Environmental Chemical Warehouse. Historically, manual inventory recording in both warehouses has resulted in discrepancies between system data and actual field conditions, with an average data accuracy of only 67% in the Central Supply Warehouse and 44% in the Environmental Chemical Warehouse. This study aims to develop an inventory management application based on AppSheet using the Waterfall method, which includes the stages of design, implementation, and Black Box testing to verify the application's functionality. The application users consist of an admin, who acts as the warehouse supervisor, and end users, namely staff of the Central Supply Warehouse and the Environmental Chemical Warehouse, each with workflows tailored to their respective operational requirements. The test results indicate that the application successfully meets the designed system requirements and is ready for operational use. It is expected that the implementation of this application will serve as an initial step toward the broader digitalization of logistics systems within government institutions

Keywords

Warehouse management; Waterfall; Black Box Testing; Appsheet

Full Text:

PDF

References

E. Winata, A. Ayuningtyas, and I. G. N. A. W. Putra, “Pengembangan Aplikasi Manajemen Persediaan untuk Meningkatkan Efisiensi Operasional” Jurnal Teknologi dan Informasi, vol. 14, no. 1, pp. 36–49, Feb. 2024, doi: 10.34010/jati.v14i1.11412.

D. G. Saputri and I. K. Sriwana, “Analisis Kebutuhan Sistem Monitoring untuk Perbaikan Proses Bisnis dengan Soft System Methodology (SSM) pada UMKM Ibunmanis Coklat,” Journal of Technology and System Information, vol. 1, no. 3, p. 16, May 2024, doi: 10.47134/jtsi.v1i3.2578.

A. D. Y. Sari and S. Dewi, “Rancang Bangun Warehouse Management System (WMS) Berbasis Aplikasi Appsheet Pada PT ABC” Jurnal Teknik Mesin, Industri, Elektro dan Informatika, vol. 2, no. 4, pp. 250–263, Dec. 2023, doi: 10.55606/jtmei.v2i4.3051.

F. A. Ekoanindiyo and Y. A. Wedana, “Perencanaan Tata Letak Gudang Menggunakan Metode Shared Storage Di Pabrik Plastik Kota Semarang” semarang, Jan. 2012. [Online]. Available: www.digilib.petra.ac.id

D. Mourtzis, V. Samothrakis, V. Zogopoulos, and E. Vlachou, “Warehouse Design and Operation using Augmented Reality technology: A Papermaking Industry Case Study,” Procedia CIRP, vol. 79, pp. 574–579, 2019, doi: 10.1016/j.procir.2019.02.097.

M. R. Nurmatama and T. Haryati, “Optimalisasi Prosedur Stock Opname Dalam Audit Persediaan pada KAP XYZ,” Sustainable Business Accounting and Management Review, vol. 6, no. 3, pp. 1–14, Sep. 2024, doi: 10.61656/sbamr.v6i3.230.

A. Haslindah, M. Fadhli, Adrianto, And R. Mansyur, “Pengaruh Implementasi Warehouse Management System Terhadap Inventory Control Finish Good Berbasis Barcode Pt. Dharana Inti Boga ” Jul. 28, 2018. Doi: 10.31227/Osf.Io/Jh48f.

N. Petrovic, M. Radenkovic, and V. Nejkovic, “Data-Driven Mobile Applications Based on AppSheet as Support in COVID-19 Crisis” 2020.

D. Murdiani and M. Sobirin, “Perbandingan Metodologi Waterfall Dan Rad (Rapid Application Development) Dalam Pengembangan Sistem Informasi” Jurnal Informatika Teknologi dan Sains, vol. 4, no. 4, pp. 302–306, Nov. 2022, doi: 10.51401/jinteks.v4i4.2008.

V. A. Kurniyanti and D. Murdiani, “Perbandingan Model Waterfall Dengan Prototype Pada Pengembangan System Informasi Berbasis Website,” Jurnal Syntax Fusion, vol. 2, no. 08, pp. 669–675, Aug. 2022, doi: 10.54543/fusion.v2i08.210.

H. Suhendi and F. U. Ali, “Sistem Informasi Geografis Berbasis Web Untuk Pemetaan Jalan Dan Jembatan Di Kota Cirebon” Naratif : Jurnal Nasional Riset, Aplikasi dan Teknik Informatika, vol. 2, no. 1, pp. 6–15, Jul. 2020, doi: 10.53580/naratif.v2i1.77.

DOI: https://doi.org/10.31334/logistik.v9i1.4627