Implementasi Aplikasi Inventory Management Berbasis Google Appsheet untuk Pengendalian Persediaan: Studi KasusPada PLN UP3 Surakarta
DOI:
https://doi.org/10.51903/e-bisnis.v19i1.3479Keywords:
Inventory Management; Google AppSheet; SDLC; Inventory control; Information systemAbstract
The rapid development of information technology requires organizations to manage inventory data more efficiently and accurately in order to support operational activities and decision making. PLN UP3 Surakarta still performs manual reconciliation between inventory data in the Systems, Applications, and Products in Data Processing (SAP) system and physical stock in the warehouse. This condition may cause information delays, data inconsistencies, and increased workload for warehouse staff. Therefore, a supporting system is needed to present inventory data in a simpler and more accessible form. This study aims to implement a Google AppSheet-based inventory control application as a supporting system for inventory control at PLN UP3 Surakarta.
The research method used is the System Development Life Cycle (SDLC), which consists of planning, requirements analysis, system design, implementation, and testing. The application utilizes Google Spreadsheet as a database to store and manage inventory data, which is then displayed through a simple and mobile-accessible interface.
The results indicate that the developed application is able to accelerate data searching, improve the accuracy of reconciliation between SAP data and physical inventory, and support more effective inventory monitoring and control. In addition, the application facilitates warehouse staff in accessing inventory information anytime and anywhere. Therefore, the implementation of a Google AppSheet-based inventory control application can improve the efficiency and effectiveness of inventory management
References
BUMN, K. (t.thn.). Diambil kembali dari https://bumn.go.id/
DeLone, W. H., & McLean, E. R. (2003). The DeLone and McLean model of information systems success: A ten-year update. Journal of Management Information Systems, 9-10.
Forrester. (2021). The Total Economic Impact™ of Google AppSheet. Diambil kembali dari Forrester Consulting.
Gartner. (2024). Market guide for low-code application platforms. Diambil kembali dari Gartner, Inc.
Google. (2023). Diambil kembali dari Google Cloud: https://developers.google.com/appsheet
Hall, J. A. (2016 ). Accounting Information Systems. Boston: Cengage Learning.
Handoko, T. H. (2012). Manajemen (2nd ed.). BPFE Yogyakarta.
Heizer, J. &. (2017). Operations management: Sustainability and supply chain management (12th ed.). Pearson Education.
Hsu, P.-F. Y.-J. (2015). Assessing ERP post-implementation success at the individual level: Revisiting the DeLone and McLean model of IS success. Computers in Human Behavior, 282–291. doi:https://doi.org/10.1016/j.chb.2014.12.052
Laudon, K. C. (2020). Management information systems: Managing the digital firm (16th ed.). Pearson Education.
Monk, E. &. (2013). Concepts in enterprise resource planning (4th ed.). Cengage Learning.
Mulyadi. (2016). Sistem Informasi Akuntansi (4 ed.). Jakarta: Salemba Empat.
Petter, S., DeLone, W. H., & McLean, E. R. (2008). Measuring information systems success: Models, dimensions, measures, and interrelationships. European Journal of Information Systems, 236–263. doi:https://doi.org/10.1057/ejis.2008.15
Romadhon, A., & Sarwono, A. E. (2023). Pemanfaatan Sistem Informasi Berbasis Digital untuk Peningkatan Efektivitas Kerja Organisasi. Jurnal Ilmiah akuntansi dan Teknologi Informasi, 110-120.
Romney, M. B. (2018). Accounting Information Systems (14th ed.). Harlow: Pearson Education.
Santosa, A., Sarwono, A. E., & Saptantinah, D. (2024). Analisis Sistem Informasi Akuntansi dala Mendukung Efektvitas Pengendalian Internal Perusahaan. Jurnal Ekonomi dan Sistem Informasi, 45-55.
Slack, N. B.-J. (2019). Operations management (9th ed.). Pearson Education.
Yasmin, F. &. (2023). Efektivitas penggunaan sistem informasi dalam meningkatkan efisiensi kerja organisasi. Jurnal Akuntansi dan Sistem Informasi, 25–36.
