Design Of an Appsheet-Based Inventory Management System Using the RAD Method

Muhammad Naufal Hafidh Shidqi; Agus Setiawan; Wiku Larutama

doi:10.24014/jti.v11i2.38972

Design Of an Appsheet-Based Inventory Management System Using the RAD Method

Muhammad Naufal Hafidh Shidqi, Agus Setiawan, Wiku Larutama

Abstract

Competition in the manufacturing industry requires companies to improve operational effectiveness, particularly in inventory management. PT XYZ, which initially operated in the metal fabrication services sector, has expanded into manufacturing; however, during this transition, inventory was still recorded manually, leading to data discrepancies and operational issues. Observations from a stocktaking process conducted in June 2025 indicated that inventory accuracy was only 76%, resulting in delivery delays, inventory accumulation, and potential financial losses. This study aims to design and implement an AppSheet-based inventory management system to address these problems. The system was developed using the SDLC method with RAD approach, emphasizing rapid development and user involvement. The developed system includes features for recording incoming goods, outgoing goods, production output, and real-time stock monitoring. System functionality was verified through black-box testing, while system acceptance was evaluated using User Acceptance Testing and a user satisfaction survey. The results indicate that all system functions operated as expected and met user requirements, achieving an average user satisfaction score of 4,25. Although the evaluation of long-term improvements in inventory accuracy remains limited, the system is considered reliable and suitable for daily operational use. It is expected to improve the consistency of inventory data.

Keywords: Inventory Management System, AppSheet, RAD

Full Text:

PDF

References

R. R. Panigrahi, A. K. Shrivastava, And S. S. Nudurupati, “Impact Of Inventory Management On Sme Performance: A Systematic Review,” International Journal Of Productivity And Performance Management, Vol. 73, No. 9, Pp. 2901–2925, 2024.

M. A. Farah, I. H. Mohamud, M. A. Mohamed, And H. A. M. Jakuula, “Enhancing Business Efficiency Through Effective Inventory Management: A Systematic Literature Review,” Acta Tecnolog’Ia, Vol. 10, No. 4, Pp. 121–129, 2024.

R. Fitriana, L. Patabang, And M. S. A. Gunawan, “Pengendalian Persediaan Bahan Baku Kacang Kedelai Cap Bw 50 Kg Dengan Menggunakan Metode Economic Order Quantity (Eoq) Pada Usaha Tempe Asli Hb Samarinda,” Jurnal Eksis, Vol. 19, No. 1, Pp. 129–147, 2023.

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, 2024.

F. A. Jaya, A. Suherman, And A. Z. Rahman, “Design Of An Inventory Management Information System Based On Appsheet At The Warehouse Of Institution Xyz Using The Waterfall Method,” Jurnal Logistik Indonesia, Vol. 9, No. 1, Pp. 1–12, 2025.

S. Wynn, “The Financial Impact Of Manual Inventory Record Errors,” 2021.

A. P. Herawati, T. Budiman, A. Z. Sianipar, And B. S. Lumbantobing, “No-Code Technology In Designing A Web-Based Stock Recording Applications Using Appsheet,” Jurnal Teknologi Informatika Dan Komputer, Vol. 11, No. 2, Pp. 522–534, 2025.

B. Mubarokan And Z. H. Nisa’i, “Application Of The Appsheet Application To Develop An Inventorysystem For Goods At Msme Parabot Barokah,” Records Management System Journal, Vol. 4, No. 1, Pp. 35–41, 2025.

J. T. Rosliana And R. N. Jaga, “Development Of An Appsheet-Based Inventory Application Forstock Management Efficiency At Pt Unilever Indonesia,” Records Management System Journal, Vol. 4, No. 1, Pp. 14–24, 2025.

M. K. Hassan, M. H. Mohd Rusli, And N. A. Mohd Salleh, “Development Of An Order Processing System Using Google Sheets And Appsheet For A Malaysian Automotive Sme Factory Warehouse,” Journal Of Mechanical Engineering (Jmeche), Vol. 20, No. 3, Pp. 63–81, 2023.

L. Santoso And J. Amanullah, “Pengembangan Sistem Informasi Akademik Berbasis Website Menggunakan Metode Rapid Application Development (Rad),” Elkom: Jurnal Elektronika Dan Komputer, Vol. 15, No. 2, Pp. 250–259, 2022.

F. A. Purwanto, “Sistem Informasi Arsip Surat Dengan Metode Rapid Application Development (Rad),” Jurnal Mahasiswa Aplikasi Teknologi Komputer Dan Informasi (Jmapteksi), Vol. 3, No. 3, Pp. 84–88, 2023.

M. R. G. Qowindra And J. Wiratama, “The Development Of Enterprise Resource Planning (Erp) Using The Rapid Application Development (Rad) Method For The Garment Industry In Indonesia,” G-Tech: Jurnal Teknologi Terapan, Vol. 7, No. 2, Pp. 504–513, 2023.

M. D. Irawan, A. P. Utama, And Others, “Implementasi Rad (Rapid Application Development) Dan Uji Black Box Pada Administrasi E-Arsip,” Sudo Jurnal Teknik Informatika, Vol. 1, No. 2, Pp. 60–71, 2022.

V. R. Handayani, M. I. Saputri, E. Rahmawati, And C. Kesuma, “Penerapan Metode Prototype Dalam Perancangan Sistem Informasi Service Pada Bengkel Sido Motor Berbasis Website,” Informatics And Computer Engineering Journal, Vol. 4, No. 2, Pp. 39–47, 2024.

S. F. Ramadhan And H. Ma’sum, “Perancangan Sistem Laporan Kerja Digital Berbasis Web Di Dpmptsp Kota Bandung,” Jurnal Informatika Dan Teknik Elektro Terapan, Vol. 13, No. 2, 2025.

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, 2020.

I. A. Azimi And D. Rinjani, “Pengujian Black Box Testing Pada Multimedia Interaktif Berbasis Website Techedu,” Jurnal Education And Development, Vol. 12, No. 1, Pp. 43–45, 2024.

DOI: http://dx.doi.org/10.24014/jti.v11i2.38972