IMPACT OF THE GOOGLE WORKSPACE-BASED INFORMATION SYSTEM FRAMEWORK ON WAREHOUSE MANAGEMENT EFFICIENCY AT PT ROCHE INDONESIA
DOI:
https://doi.org/10.32477/semnas.v4i1.1295Keywords:
Google Workspace, Information System Quality, Low-Code WMS, Real-time Monitoring, Reverse Logistics, Warehouse Efficiency.Abstract
The management of non-standard assets, such as used instruments requiring 'refurbish' or 'destroy' evaluation, presents significant complexity for modern warehouse operations, often lacking the integrated, real-time monitoring systems necessary for timely strategic decision-making. This study addresses this problem by developing and evaluating an agile, cost-effective Warehouse Management System (WMS) framework based on the Google Workspace ecosystem (Google Sheets, Apps Script, Looker Studio). The primary objective is to evaluate the system's effectiveness and to describe the influence of key Information System quality factors—Data Transparency, System Integration, and Real-time Monitoring on Warehouse Performance in a real-world case. This research employed a descriptive case study approach with a total sampling technique involving 100% of the warehouse unit personnel (N=3) at PT Roche Indonesia, alongside an analysis of historical records (110 records from 2023–2024). The study utilizes a comparative analysis between the legacy spreadsheet method and the proposed automated framework. The system's low-code integration, powered by Google Apps Script, proved highly functional in ensuring data consistency. Quantitative results from the user perception survey revealed a high level of satisfaction with an overall average score of 4.82 out of 5.00. Specifically, the system achieved perfect scores in Warehouse Performance (Mean=5.00), followed by strong results in Data Transparency (Mean=4.89) and System Integration (Mean=4.89), while Real-time Monitoring scored 4.67. Furthermore, the implementation successfully eliminated data redundancy (0% duplication rate) compared to the manual legacy system. These findings confirm that the low-code framework significantly enhances operational efficiency and strategic decision-making. This research contributes to the literature by demonstrating the viability and high impact of a low-cost, low-code WMS framework for complex reverse logistics environments.
References
Chen, L., & Liu, M. (2023). Digital transformation in warehouse management: A systematic review of Industry 4.0 applications. International Journal of Production Research, 61(8), 2456–2478.
Chen, L., & Zhang, M. (2014). Real-time information processing in supply chain management: A comprehensive framework. Journal of Business Research, 67(4), 235–248.
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, 19(4), 9–30.
Dewi, S. P., & Kusuma, A. B. (2024). Implementasi sistem informasi berbasis cloud untuk optimalisasi manajemen inventaris. Jurnal Teknik Industri Indonesia, 15(2), 145–158.
Frazelle, E. (2002). World-Class Warehousing and Material Handling. McGraw-Hill Professional.
Hair, J. F., Hult, G. T. M., Ringle, C. M., & Sarstedt, M. (2022). A Primer on Partial Least Squares Structural Equation Modeling (PLS-SEM) (3rd ed.). Sage Publications.
Kumar, S., Singh, R., & Patel, A. (2024). Smart warehouse management systems: Integration of IoT and AI technologies. Journal of Manufacturing Systems, 72, 234–249.
Prabowo, H., & Sari, D. K. (2023). Analisis kinerja sistem gudang menggunakan pendekatan kuantitatif: Studi kasus industri manufaktur. Indonesian Journal of Industrial Engineering, 8(1), 67–82.
Prajogo, D., & Olhager, J. (2012). Supply chain integration and performance: The effects of long-term relationships, information technology and sharing, and logistics integration. International Journal of Production Economics, 135(1), 514–522.
Rahman, A., & Sutanto, J. (2024). Google Workspace implementation for enterprise resource planning: A case study approach. International Journal of Information Technology, 16(4), 1823–1838.
Richards, G. (2018). Warehouse Management: A Complete Guide to Improving Efficiency and Minimizing Costs in the Modern Warehouse (3rd ed.). Kogan Page.
Sarstedt, M., Ringle, C. M., & Hair, J. F. (2021). Partial least squares structural equation modeling. In Handbook of Market Research (pp. 587–632).
Venkatesh, V., Morris, M. G., Davis, G. B., & Davis, F. D. (2003). User acceptance of information technology: Toward a unified view. MIS Quarterly, 27(3), 425–478.
Zhang, Y., Wang, H., & Li, J. (2022). Performance improvement of inventory management system processes by automated warehouse management system. Computers & Industrial Engineering, 165, Article 107943.
Chen, L., & Wu, P. (2022). Implementing real-time monitoring systems for enhanced warehouse decision-making. IEEE Transactions on Engineering Management, 71(3), 405-418.
Ganeshan, V. (2021). The role of information transparency in reverse logistics performance. International Journal of Production Economics, 240, 108250.
Smith, J., & Jones, A. (2023). Low-code application platforms in supply chain management: A case study of operational flexibility. Journal of Operations and Logistics, 30(2), 112–129.
