Implementation of Supply Chain Management for Mineral Water Inventory Management at Putri Store

Rahmadina Rahmadina; Novica Irawati; Rohminatin Rohminatin

doi:10.55537/j-ibm.v6i1.1697

Authors

Rahmadina Rahmadina Universitas Royal
Novica Irawati Universitas Royal
Rohminatin Rohminatin Universitas Royal

DOI:

https://doi.org/10.55537/j-ibm.v6i1.1697

Keywords:

supply chain management, mineral water, Fertilizer Inventory Expenditure, information system, web

Abstract

Putri Store is a retail business that sells mineral water products with relatively high customer demand. However, its inventory management is still conducted manually, causing inaccurate stock records, delays in reordering, and frequent stockouts. Based on observations from August to October 2025, 26 stockout incidents were found across several mineral water products. This study aims to design and implement a web-based Supply Chain Management (SCM) system to improve inventory management effectiveness at Putri Store. The system was developed using the Waterfall method, consisting of requirements analysis, system design, implementation, testing, and evaluation. The system design used Unified Modeling Language (UML) and Entity Relationship Diagram (ERD), while implementation was carried out using PHP and MySQL. System testing was conducted using the Black Box Testing method on the main modules, including login, inventory management, supplier management, ordering, and reporting. The results showed that all system functions operated according to user requirements, achieving a 100% success rate. The developed system supports real-time inventory monitoring, integrates supplier data with the ordering process, and automatically generates inventory reports. Its implementation reduced stock search time from 10–15 minutes to 1–2 minutes and report generation time from 20–30 minutes to less than 5 minutes. User satisfaction reached 93.2%, with an average score of 4.66 out of 5. Therefore, the web-based SCM system effectively improves inventory accuracy, accelerates decision-making, and reduces stockout risks at Putri Store.

Downloads

Download data is not yet available.

References

Abdillah, J., & Saputra, R. (2025). Analisis dan perancangan Supply Chain Management (SCM) pada Toko Am Jaya menggunakan bahasa pemrograman PHP dan MYSQL. Ekasakti Jurnal Penelitian dan Pengabdian, 5(2), 306–321. https://doi.org/10.31933/ejpp.v5i2.1316

Aisyah, N., & Ramadhan, A. (2024). Penerapan supply chain management untuk menyelaraskan koordinasi supplier dan efektivitas pengadaan barang. Jurnal Sistem Informasi Dan Manajemen, 12(1), 45–56. https://doi.org/10.37600/jsim.v12i1.1234

Amanda, A. Z., & Nandra. (2024). Perancangan sistem informasi manajemen persediaan barang berbasis web dengan metode Just-in-Time (JIT). JEKIN: Jurnal Teknik Informatika, 5(2), 214–223. https://doi.org/10.58794/jekin.v5i2.1414

Chopra, S., & Meindl, P. (2019). Supply chain management: Strategy, planning, and operation (7th ed.). Pearson Education.

Heizer, J., & Render, B. (2014). Principles of operations management (9th ed.). Pearson Education.

Heizer, J., Render, B., & Munson, C. (2017). Operations management: Sustainability and supply chain management (12th ed.). Pearson Education.

Hermanto, B., Ardiansyah, Prabowo, R., & Wijaya, A. (2023). Pengembangan sistem manajemen inventori berbasis web untuk PT Ling Komputer Indonesia. Jurnal Pepadun, 4(1), 89–98. https://doi.org/10.23960/pepadun.v4i1.146

Hidayat, R., & Putra, A. (2022). Digitalisasi pengelolaan stok untuk meminimalkan ketidaksesuaian data inventori manual. Jurnal Teknologi Dan Sistem Informasi, 9(2), 112–121. https://doi.org/10.31284/j.jtsi.2022.v9i2.3214

Ivanov, D., Dolgui, A., & Sokolov, B. (2019). The impact of digital technology and Industry 4.0 on the ripple effect and supply chain risk analytics. International Journal of Production Research, 57(3), 829–846. https://doi.org/10.1080/00207543.2018.1488086

Kache, F., & Seuring, S. (2017). Challenges and opportunities of digital information at the intersection of Big Data Analytics and Supply Chain Management. International Journal of Operations & Production Management, 37(1), 10–36. https://doi.org/10.1108/IJOPM-02-2015-0078

Krishna, C. R. P., Rohman, M. Z., & Cahyono, B. (2024). Implementasi web inventory tracking dan monitoring untuk PT Sucofindo Cabang Samarinda. JATI EMAS (Jurnal Aplikasi Teknik dan Pengabdian Masyarakat), 8(4), 123–130.

Maysaroh, M., Sembiring, M. A., & Sudarmin. (2024). Applying supply chain management in a web-based drug inventory system. Information Technology Engineering Journals, 10(2), 143–152. https://doi.org/10.24235/itej.v10i2.262

Nasution, H., & Prasetyo, E. (2021). Analisis sistem monitoring stok berbasis web untuk meningkatkan akurasi data persediaan ritel. Jurnal Sains Dan Teknologi, 10(3), 301–310. https://doi.org/10.23887/jstundiksha.v10i3.34561

Novilasari, T. A. (2023). Penerapan sistem informasi inventori barang berbasis web pada gudang Rumah Sakit Bhakti Asih Tangerang. Jurnal Sistem Informasi, 13(2), 77–86. https://doi.org/10.51998/jsi.v13i2.541

Nugroho, M. A., & Hermawan, A. (2025). Pengembangan sistem informasi manajemen stok barang berbasis web untuk meningkatkan akurasi pengelolaan inventaris. Bulletin of Computer Science Research, 6(1), 142–152. https://doi.org/10.47065/bulletincsr.v6i1.853

Pramesti, R. D., & Rahim, R. (2023). Perancangan sistem informasi stock barang berbasis web pada CV Muti Indofood Lestari. REMIK: Riset dan E-Jurnal Manajemen Informatika Komputer, 7(3), 1702–1711. https://doi.org/10.33395/remik.v7i3.12837

Siregar, Y. G. (2025). Sistem informasi Supply Chain Management distribusi barang berbasis web pada PT. KAI Divre 1 Sumut. Jurnal Informatika dan Teknik Elektro Terapan, 13(3S1). https://doi.org/10.23960/jitet.v13i3S1.8013

Stevenson, W. J. (2018). Operations management (13th ed.). McGraw-Hill Education.