Utilizing ROP in a Mobile Based Warehouse Management System for Small Retail Businesses

  • Winni Setiawati Universitas Tarumanagara, Indonesia
  • Jap Tji Beng Universitas Tarumanagara, Indonesia
  • Tony Tony Universitas Tarumanagara, Indonesia
DOI: 10.63158/journalisi.v7i4.1326
Keywords: warehouse management system, reorder point, v-shaped model, qr code

Abstract

ABC Store, a wholesale sock retailer, operates through both physical and online platforms. With increasing online sales, the company has experienced frequent stockouts due to inefficient manual inventory processes. This study aims to address these challenges by developing a mobile-based Warehouse Management System (WMS) integrated with a Reorder Point (ROP) calculation. The system was developed using the V-Shaped model, which involved requirement gathering through interviews and warehouse observations. The application was built using the lightweight Flutter framework and an SQLite local database, with testing including white-box, black-box, and User Acceptance Testing (UAT). Additionally, QR code scanning was implemented to improve document tracking and inventory management. The results indicate that the system functions as expected, with the ROP calculation effectively supporting restocking decisions and minimizing stockouts. This study contributes to the field by demonstrating the practical application of integrating simplified ROP calculation into a mobile-based WMS, highlighting its potential to improve warehouse operations for small businesses with limited infrastructure. The approach offers a scalable solution for managing inventory efficiently and cost-effectively, especially in small-scale retail settings.

Downloads

Download data is not yet available.

References

Z. U. Rizqi and A. Khairunisa, “Integration of Deterministic and Probabilistic Inventory Methods to Optimize the Balance Between Overstock and Stockout,” in IOP Conference Series: Materials Science and Engineering, Institute of Physics Publishing, Jan. 2020, pp. 1–6. doi: 10.1088/1757-899X/722/1/012060.

D. Minashkina and A. Happonen, “Warehouse Management Systems for Social and Environmental Sustainability: A Systematic Literature Review and Bibliometric Analysis,” Logistics, vol. 7, no. 3, Sep. 2023, doi: 10.3390/logistics7030040.

E. Damayanti, A. Asfar, F. Jama, and Suhermi, “Penggunaan Smartphone dan Perilaku Sosial pada Remaja,” Window of Nursing Journal, vol. 5, no. 1, pp. 48–54, 2024, doi: 10.33096/won.v5i1.698.

F. R. Ferdiansyah and R. Sofian, “Implementasi Teknologi QR Code dan Location Based Service pada Presensi Mobile Flutter,” Jurnal Ilmiah Intech : Information Technology Journal of UMUS, vol. 5, no. 2, pp. 85–97, 2023, doi: 10.46772/intech.v5i2.1032.

M. van Geest, B. Tekinerdogan, and C. Catal, “Design of a Reference Architecture for Developing Smart Warehouses in Industry 4.0,” Comput Ind, vol. 124, Jan. 2021, doi: 10.1016/j.compind.2020.103343.

A. Immadisetty, “Real-Time Inventory Management: Reducing Stockouts and Overstocks in Retail,” Journal of Recent Trends in Computer Science and Engineering (JRTCSE), vol. 13, no. 1, pp. 77–88, Feb. 2025, doi: 10.70589/JRTCSE.2025.13.1.10.

A. Farooq, A. B. N. Abbey, and E. C. Onukwulu, “Inventory Optimization and Sustainability in Retail: A Conceptual Approach to Data-Driven Resource Management,” International Journal of Multidisciplinary Research and Growth Evaluation, vol. 5, no. 6, pp. 1356–1363, 2024, doi: 10.54660/.ijmrge.2024.5.6.1356-1363.

I. K. Wairooy, I. Dillwyn, K. P. Yonathan, and A. Lay, “Development of Mobile QR Warehouse Management Apllication Based on Flutter and Firebase,” Engineering, MAthematics and Computer Science Journal (EMACS), vol. 6, no. 1, pp. 39–44, Jan. 2024, doi: 10.21512/emacsjournal.v6i1.10921.

W. Antonius, D. Arisandi, and J. P. Novario, “Pembuatan Sistem Pencatatan Transaksi dan Inventori Berbasis Web Pada Toko Besi Irdawanti,” Jurnal Ilmu Komputer dan Sistem Informasi, vol. 13, no. 1, pp. 1–6, 2025, doi: 10.24912/jiksi.v13i1.32880.

Lukas, R. A. Praptiwi, A. T. Priandika, Suaidah, and D. Alita, “Implementasi REST API pada Manajemen Stok Barang Berbasis Aplikasi Web (Studi Kasus: PT Jon Kuliner Indonesia),” Jurnal Teknik Komputer, vol. 3, no. 1, pp. 19–24, 2024, doi: 10.14710/jtk.v3i1.46234.

I. K. Dewi and R. Nur Shofa, “Development of Warehouse Management System to Manage Warehouse Operations,” Journal of Applied Information Systems and Informatics, vol. 1, no. 1, pp. 15–23, Nov. 2023, doi: 10.37058/jaisi.v1i1.8991.

N. Afrizal, J. Minardi, and D. Mahendra, “Safety Stock and Reorder Point System for RF Media Stock Optimization,” Scientific Journal of Informatics, vol. 12, no. 2, pp. 339–348, Jul. 2025, doi: 10.15294/sji.v12i2.22232.

N. Natesh Kumar, “The Supply Chain Maze: The Struggles of Small and Medium Enterprises and Ways to Navigate the Challenges,” International Journal of Supply Chain Management, vol. 14, no. 2, pp. 33–45, Apr. 2025, doi: 10.59160/ijscm.v14i2.6304.

M. O. Tumbade, K. D. Hartomo, and H. D. Purnomo, “Pengembangan Perangkat Lunak Berbasis Website Menggunakan Kombinasi Metode Scrum Dan V-Model,” Jurnal Teknologi Informasi dan Ilmu Komputer, vol. 11, no. 3, pp. 447–460, Jul. 2024, doi: 10.25126/jtiik.938456.

F. Fonggo, J. T. Beng, and D. Arisandi, “Web-based canteen payment and ordering system,” in IOP Conference Series: Materials Science and Engineering, IOP Publishing Ltd, Dec. 2020. doi: 10.1088/1757-899X/1007/1/012159.

R. Rifnaldy and Tony, “Perancangan Aplikasi Media Informasi dan Pemesanan Berbasis Web untuk Coffee Shop Tempat Bercerita,” Jurnal Ilmu Komputer dan Sistem Informasi, vol. 11, no. 1, pp. 1–7, 2023, doi: 10.24912/jiksi.v11i1.24141.

A. Tewari and P. Singh, “Android App Development: A Review,” Journal of Management and Service Science, vol. 01, no. 006, pp. 1–6, 2021, doi: 10.54060/JMSS/001.02.006.

D. Wintana, D. Pribadi, and M. Y. Nurhadi, “Analisis Perbandingan Efektifitas White-Box Testing dan Black-Box Testing,” Jurnal Larik, vol. 2, no. 1, pp. 8–16, 2022, doi: 10.31294/larik.v2i1.1382.

N. A. Vanesha, R. Rizky, and A. Purwanto, “Comparison Between Usability and User Acceptance Testing on Educational Game Assessment,” Jurnal Sisfokom (Sistem Informasi dan Komputer), vol. 13, no. 2, pp. 210–215, Jun. 2024, doi: 10.32736/sisfokom.v13i2.2099.

E. B. Pranata and T. Tony, “Utilizing ORB Algorithm in Web-Based Sales Application,” Journal of Information Systems and Informatics, vol. 6, no. 1, pp. 378–398, Mar. 2024, doi: 10.51519/journalisi.v6i1.671.

P. N. Anggraini, K. Harianto, and H. Sutapa, “Implementation of Safety Stock in Cracker Inventory Control at PT Merpati Mas Nusantara 2022 - 2025 in Kabupaten Kediri,” Musytari, vol. 19, no. 10, pp. 1–11, 2025, doi: 10.8734/musytari.v1i2.365.

A. Almani and O. Alrwais, “The Role of Wireframes in Enhancing User Interface Design,” International Research Journal of Innovations in Engineering and Technology, vol. 08, no. 12, pp. 134–140, 2024, doi: 10.47001/irjiet/2024.812020.

B. S. Prakoso, A. F. N. Masruriyah, R. T. Prasetyo, Mardiah, S. B. Ardika, and Feriadi, “Optimizing a Warehouse Management System (WMS) for Small and Medium Enterprises (SMEs) using Odoo ERP,” in International Conference on Informatics, Multimedia, Cyber and Information System (ICIMCIS), IEEE, 2024, pp. 880–886. doi: 10.1109/ICIMCIS63449.2024.10957438.

S. A. Alsuhibany, “Innovative QR Code System for Tamper-Proof Generation and Fraud-Resistant Verification,” Sensors, vol. 25, no. 13, Jul. 2025, doi: 10.3390/s25133855.

K. P. Gaffney, D. R. Hipp, M. Prammer, D. Kennedy, L. Brasfield, and J. M. Patel, “SQLite: Past, Present, and Future,” in Proceedings of the VLDB Endowment, VLDB Endowment, 2022, pp. 3535–3547. doi: 10.14778/3554821.3554842.

D. Kengalagutti and Chethana, “Comparing Database Management Systems: MySQL, PostgreSQL, SQLite,” International Research Journal of Engineering and Technology, 2020.

Published
2025-12-10
Abstract views: 25 times
Download PDF: 17 times
How to Cite
Setiawati, W., Beng, J. T., & Tony, T. (2025). Utilizing ROP in a Mobile Based Warehouse Management System for Small Retail Businesses. Journal of Information Systems and Informatics, 7(4), 3626-3644. https://doi.org/10.63158/journalisi.v7i4.1326
Issue
Vol 7 No 4 (2025): December
Section
Articles

Copyright (c) 2025 Journal of Information Systems and Informatics

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

  1. I certify that I have read, understand and agreed to the Journal of Information Systems and Informatics (Journal-ISI) submission guidelines, policies and submission declaration. Submission already using the provided template.
  2. I certify that all authors have approved the publication of this and there is no conflict of interest.
  3. I confirm that the manuscript is the authors' original work and the manuscript has not received prior publication and is not under consideration for publication elsewhere and has not been previously published.
  4. I confirm that all authors listed on the title page have contributed significantly to the work, have read the manuscript, attest to the validity and legitimacy of the data and its interpretation, and agree to its submission.
  5. I confirm that the paper now submitted is not copied or plagiarized version of some other published work.
  6. I declare that I shall not submit the paper for publication in any other Journal or Magazine till the decision is made by journal editors.
  7. If the paper is finally accepted by the journal for publication, I confirm that I will either publish the paper immediately or withdraw it according to withdrawal policies
  8. I Agree that the paper published by this journal, I transfer copyright or assign exclusive rights to the publisher (including commercial rights)