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

Authors

  • Firdan Anugrah Jaya Universitas Pendidikan Indonesia
  • Amay Suherman Universitas Pendidikan Indoneisa
  • Aulia Zikri Rahman Universitas Pendidikan Indoneisa

DOI:

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

Keywords:

Warehouse management, Waterfall, Black Box Testing, Appsheet

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

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.

Downloads

Published

2025-06-30

Issue

Vol. 9 No. 1: April 2025

Section

Articles

License

Please find the rights and licenses in Jurnal Logistik Indonesia. By submitting the article/manuscript of the article, the author(s) agree with this policy. No specific document sign-off is required.

1. License
The non-commercial use of the article will be governed by the Creative Commons Attribution license as currently displayed on Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

2. Author(s)' Warranties
The author warrants that the article is original, written by stated author(s), has not been published before, contains no unlawful statements, does not infringe the rights of others, is subject to copyright that is vested exclusively in the author and free of any third party rights, and that any necessary written permissions to quote from other sources have been obtained by the author(s).

3. User Rights
Jurnal Logistik Indonesia spirit is to disseminate articles published are as free as possible. Under the Creative Commons license, Jurnal Logistik Indonesia permits users to copy, distribute, display, and perform the work for non-commercial purposes only. Users will also need to attribute authors and Jurnal Logistik Indonesia on distributing works in the journal and other media of publications.

4. Co-Authorship
If the article was jointly prepared by more than one author, any authors submitting the manuscript warrants that he/she has been authorized by all co-authors to be agreed on this copyright and license notice (agreement) on their behalf, and agrees to inform his/her co-authors of the terms of this policy. Jurnal Logistik Indonesia will not be held liable for anything that may arise due to the author(s) internal dispute. Jurnal Logistik Indonesia will only communicate with the corresponding author.

5. Miscellaneous
Jurnal Logistik Indonesia will publish the article (or have it published) in the journal if the article’s editorial process is successfully completed. Jurnal Logistik Indonesia editors may modify the article to a style of punctuation, spelling, capitalization, referencing and usage that deems appropriate. The author acknowledges that the article may be published so that it will be publicly accessible and such access will be free of charge for the readers as mentioned in point 3.

 

Every accepted manuscript should be accompanied by "Copyright Transfer Agreement" prior to the article publication.

 

 

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.