A Cognitive Warehouse Inventory System: Progressive Web App with Economic Order Quantity Optimization, Predictive Analytics, and Multi-Tenant Architecture
DOI:
https://doi.org/10.35194/mji.v18i1.6499Keywords:
Early Warning System , Economic Order Quantity , Inventory Management , Predictive Analytics, Multi-Tenant ArchitectureAbstract
In many small and medium enterprises, inventory systems still function primarily as transaction-recording tools and provide limited support for anticipatory replenishment. This study introduces the Cognitive Inventory Management System (CIMS), a progressive web application that integrates mobile stock validation, tenant-isolated data management, machine-learning-driven demand forecasting, and economic order quantity (EOQ) ordering logic. Guided by design science principles, CIMS was evaluated over six months using anonymized primary operational inventory records from Indonesia, covering 35 warehouses, 2,184 stock-keeping units (SKUs), and 186,420 inventory transactions. A pre-post comparison was supplemented with a matched-pair robustness check, a paired t-test, a Wilcoxon signed-rank test, bootstrap confidence intervals, and multiple sensitivity analyses to assess the stability of the findings. Compared with the previous reorder-point practice, the system reduced monthly stockouts by 24.7%, decreased days sales of inventory by 31.2%, and shortened order-to-delivery cycles by 18.5%. Random Forest achieved lower mean absolute percentage error (MAPE) than naive, moving-average, and autoregressive integrated moving average (ARIMA) benchmarks, while the alert mechanism generated stockout warnings 7.3 days in advance on average. The main contribution is an empirically validated architecture that connects interpretable inventory rules with tenant-specific predictive signals in resource-constrained operational settings. The results also indicate that the fully integrated workflow outperforms separate use of forecasting, validation, or EOQ-based rules.
References
[1] D. Ivanov, A. Dolgui, and B. Sokolov, “The impact of digital technology and Industry 4.0 on the ripple effect and supply chain risk analytics”, International Journal of Production Research, vol. 57, no. 3, pp. 829–846, 2019.
[2] S. Fosso Wamba and M. M. Queiroz, “Blockchain in the operations and supply chain management: Benefits, challenges and future research opportunities”, International Journal of Information Management, vol. 52, art. no. 102064, 2020.
[3] S. Malavolta, G. Procaccianti, P. Noorland, and P. Vukmirovic, “Assessing the impact of service workers on the energy efficiency of progressive web apps”, in Proc. IEEE/ACM 7th International Conference on Mobile Software Engineering and Systems, 2020, pp. 35–45.
[4] A. A. Taleizadeh, “Lot-sizing model with advance payment pricing and disruption in supply under planned partial backordering”, International Transactions in Operational Research, vol. 26, no. 4, pp. 1375–1397, 2019.
[5] S. A. Shah, M. A. Babar, and M. Ali, “A systematic review of scheduling approaches on multi-tenancy cloud platforms”, Information and Software Technology, vol. 132, art. no. 106478, 2021.
[6] M. Khan, M. Y. Jaber, A. Guiffrida, and S. Zolfaghari, “A review of the extensions of a modified economic order quantity model for imperfect quality items”, International Journal of Production Economics, vol. 230, art. no. 107789, 2020.
[7] A. A. Amer and S. H. A. Rahman, “A systematic review of machine learning approaches in inventory control optimization”, Supply Chain Analytics, vol. 15, art. no. 100367, 2025.
[8] H. Seyedan and F. Mafakheri, “Predictive big data analytics for supply chain demand forecasting: Methods, applications, and research opportunities”, Journal of Big Data, vol. 7, art. no. 53, 2020.
[9] S. Punia, K. Nikolopoulos, S. P. Singh, J. K. Madaan, and K. Litsiou, “Deep learning with long short-term memory networks and random forests for demand forecasting in multi-channel retail”, International Journal of Production Research, vol. 58, no. 16, pp. 4964–4979, 2020.
[10] S. Makridakis, E. Spiliotis, and V. Assimakopoulos, “M5 accuracy competition: Results, findings, and conclusions”, International Journal of Forecasting, vol. 38, no. 4, pp. 1346–1364, 2022.
[11] R. Fildes, S. Ma, and S. Kolassa, “Retail forecasting: Research and practice”, International Journal of Forecasting, vol. 38, no. 4, pp. 1283–1318, 2022.
[12] V. V. G. Neto, R. C. P. Teixeira, and S. G. Costa, “A systematic literature review of machine learning methods applied to demand forecasting”, Computers & Industrial Engineering, vol. 175, art. no. 108852, 2023.
[13] M. Beardsley, “Multi-tenant data isolation with PostgreSQL row level security”, AWS Database Blog, 2020.
[14] A. Belhadi, S. Kamble, C. J. C. Jabbour, A. Gunasekaran, N. O. Ndubisi, and M. Venkatesh, “Manufacturing and service supply chain resilience to the COVID-19 outbreak: Lessons learned from the automobile and airline industries”, Technological Forecasting and Social Change, vol. 163, art. no. 120447, 2021.
[15] F. Petropoulos et al., “Forecasting: Theory and practice”, International Journal of Forecasting, vol. 38, no. 3, pp. 705–871, 2022.
[16] S. A. Baryannis, S. Validi, S. Dani, and G. Antoniou, “Artificial intelligence in supply chain management: A systematic literature review of empirical studies and research directions”, Computers in Industry, vol. 162, art. no. 104132, 2024.
[17] N. Joseph, P. Erastus, and M. H. Derrouiche, “Machine learning in supply chain management: A systematic literature review and future research agenda”, International Journal of Production Research, vol. 63, no. 16, pp. 1–29, 2025.
[18] J. vom Brocke, A. Hevner, and A. Maedche, “Introduction to design science research”, in Design Science Research. Cases, Cham: Springer, 2020, pp. 1–13.
[19] J. vom Brocke, R. Winter, A. Hevner, and A. Maedche, “Special issue editorial–accumulation and evolution of design knowledge in design science research”, Journal of the Association for Information Systems, vol. 21, no. 3, pp. 520–544, 2020.
[20] W. R. Shadish, T. D. Cook, and D. T. Campbell, Experimental and Quasi-Experimental Designs for Generalized Causal Inference. Boston, MA, USA: Houghton Mifflin, 2002.
[21] B. Efron and R. J. Tibshirani, An Introduction to the Bootstrap. New York, NY, USA: Chapman & Hall, 1993.
[22] S. Sutono and A. P. Pamungkas, “Penerapan metode eksperimen semu pada sistem informasi persediaan dan penjualan obat di apotek berbasis web-base”, Media Jurnal Informatika, vol. 12, no. 2, pp. 44–50, 2020, doi: 10.35194/mji.v12i2.1225.
[23] Anonymous participating warehouse operations, “Anonymized operational inventory transaction records for CIMS evaluation in Indonesia”, private operational dataset, 2025. Access restricted by confidentiality agreement; aggregate indicators are reported in this manuscript.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Rizza Muhammad Arief, Syaiful Arifin
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
