Implementation of the Economic Order Quantity Method in a Web Based Spare Part Inventory Information System

Alvin Handoko; Muhammad Farman Andrijasa; Subhan Hartanto

Authors

Alvin Handoko Politeknik Negeri Samarinda
Muhammad Farman Andrijasa Politeknik Negeri Samarinda
Subhan Hartanto Politeknik Negeri Samarinda

Keywords:

Inventory System, Inventory Management, Economic Order Quantity, Laravel, Spare Parts Store

Abstract

Jaya Muncul Spare Parts Store still uses a manual recording system which often causes errors in stock management and delays in ordering. This study aims to design and build a web based inventory information system using the Economic Order Quantity (EOQ) method to assist in decision making for ordering spare parts. The system was developed with the Laravel framework and MySQL database using an Agile approach that allows an iterative development process. Blackbox testing results show that all functions run well, while the User Acceptance Test (UAT) obtained an average score of 89.97% in the “very good” category. The implementation of the EOQ method is proven to help make purchasing decisions, reducing the risk of stockouts and overstock. Integration of the Reorder Point (ROP) feature as a minimum notification, Safety Stock, and prediction of prices, demand, and stock of goods with Simple Moving Average (SMA). This system is considered effective as a tool to determine the number of purchases of goods at Toko Sparepart Jaya Muncul.

References

S. Wahyuni, “Penerapan Metode Economic Order Quantity (Eoq) Dalam Analisis Pengendalian Persediaan Semen Pada Pt. Panorama Ready Mix.,” Ekonomia, vol. 3, no. 2, pp. 255–260, 2014.

M. Clara and J. F. Andry, “Website Inventory Management Spare Part Industry Using Scrum Method,” Jurnal Teknoinfo, vol. 18, no. 1, pp. 267–276, 2024.

W. Emar, Z. A. Al-Omari, and S. Alharbi, “Analysis of inventory management of slow-moving spare parts by using ABC techniques and EOQ model-a case study,” Indonesian Journal of Electrical Engineering and Computer Science, vol. 23, no. 2, pp. 1159–1169, 2021, doi: 10.11591/ijeecs.v23.i2.pp1159-1169.

D. Kumar, “Determination of Inventory Turnover ratios and Cost savings by using Basic EOQ Model,” vol. 5, no. 9, pp. 80–92, 2015.

Anjali, T. Tyagi, A. Chauhan, S. K. Singh, A. Singh, and A. Goel, “Sustainable Production for Paper and Pulp Industry with Rice Straw Utilization Under Carbon Tax Policy,” Process Integration and Optimization for Sustainability, vol. 9, no. 4, pp. 1603–1620, Sep. 2025, doi: 10.1007/s41660-025-00526-7.

P. Yawara, N. Supattananon, P. Siwapornrak, and R. Akarrungruangkul, “Purchasing planning for pharmaceuticals inventory: a case study of drug warehouse in hospital,” Indonesian Journal of Electrical Engineering and Computer Science, vol. 31, no. 3, p. 1496, Sep. 2023, doi: 10.11591/ijeecs.v31.i3.pp1496-1506.

A. I. Ramdhani, Z. M. Subekti, and M. D. Suryadi, “Rancang Bangun Aplikasi Inventory Logistik Berbasis Website Menggunakan Metode Scrum,” J-SISKO TECH (Jurnal Teknologi Sistem Informasi dan Sistem Komputer TGD), vol. 5, no. 2, p. 161, Jul. 2022, doi: 10.53513/jsk.v5i2.5681.

A. Taufik, “Sistem Informasi Inventory (SITORY) Berbasis Web Dengan Metode Framwork For The Application System Thinking (FAST ),” JATISI (Jurnal Teknik Informatika dan Sistem Informasi), vol. 8, no. 2, pp. 859–869, Jun. 2021, doi: 10.35957/jatisi.v8i2.930.

S. Wijaya, I. Setiadi, and M. S. Ritonga, “Membangun Aplikasi Manajemen Inventaris Barang Berbasis Java Pada PT. Sinar Sejahtera,” Semnas Ristek (Seminar Nasional Riset dan Inovasi Teknologi), vol. 6, no. 1, Jan. 2022, doi: 10.30998/semnasristek.v6i1.5677.

J. Setiawan and H. Hartono, “APLIKASI INVENTORY BARANG BERBASIS WEB PADA PT TETAP PANAH MAS,” JBASE - Journal of Business and Audit Information Systems, vol. 5, no. 2, Aug. 2022, doi: 10.30813/jbase.v5i2.3780.

H. Gusdevi, W. L. Jaelani, M. Naseer, and R. Risandi, “PENGINTEGRASIAN API SHOPEE UNTUK SISTEM PENYESUAIAN STOK BARANG DENGAN METODE FIRST IN FIRST OUT (STUDI KASUS: PT. TKI),” Naratif : Jurnal Nasional Riset, Aplikasi dan Teknik Informatika, vol. 6, no. 1, pp. 64–71, Jul. 2024, doi: 10.53580/naratif.v6i1.284.

U. Masripah and R. Setiawan, “Penerapan Extreme Programming (XP) Sistem Inventory Kontrol Pada Gudang Hizam Sandal,” Jurnal Algoritma, vol. 22, no. 2, Nov. 2025, doi: 10.33364/algoritma/v.22-2.1838.

T. A. D. P. Subianto, J. Wiratama, and F. A. Halim, “The Development of web-based Cashier and Inventory Information Systems using Prototyping Model on Micro, Small, and Medium Enterprise (MSMEs) in Indonesia,” JOINS (Journal of Information System), vol. 8, no. 1, pp. 80–89, Jun. 2023, doi: 10.33633/joins.v8i1.7983.

I. A. Ramadhani and A. Asrul, “Development of Interactive Learning Media Based on Articulate Storyline to Improve Student’ Science Literacy,” Lectura : Jurnal Pendidikan, vol. 15, no. 2, pp. 533–545, Aug. 2024, doi: 10.31849/lectura.v15i2.20974.

P. Leonardo and J. Wiratama, “Empowering Efficiency: A Web-Based Inventory and Sales Information System for Drinking Water Distributors through Rapid Application Development,” Journal of Information Systems and Informatics, vol. 5, no. 2, pp. 742–757, May 2023, doi: 10.51519/journalisi.v5i2.498.

M. Ahied, L. K. Muharrami, A. Fikriyah, and I. Rosidi, “Improving Studentsâ€TM Scientific Literacy through Distance Learning with Augmented Reality-Based Multimedia Amid the Covid-19 Pandemic,” Jurnal Pendidikan IPA Indonesia, vol. 9, no. 4, pp. 499–511, Dec. 2020, doi: 10.15294/jpii.v9i4.26123.

A. Firdaus, C. A. Swastyastu, and R. N. T. Shanty, “Development of a Web-Based Spare Parts Inventory System Using the First-In, First-Out Method and Acceptance Analysis Based on the Unified Theory of Acceptance and Use of Technology,” Journal of Information Technology and Cyber Security, vol. 3, no. 2, pp. 114–127, Oct. 2025, doi: 10.30996/jitcs.13042.

R. D. Lufika, “The Design of Product Inventory Strategy with System Thinking and Economic Order Quantity Method Approach (Case Study: PT. Y),” J. Phys. Conf. Ser., vol. 1569, no. 2, p. 022099, Jul. 2020, doi: 10.1088/1742-6596/1569/2/022099.

J. Vazquez Hernandez and M. D. Elizondo Rojas, “Improving spare parts (MRO) inventory management policies after COVID-19 pandemic: a Lean Six Sigma 4.0 project,” The TQM Journal, vol. 36, no. 6, pp. 1627–1650, Jun. 2024, doi: 10.1108/TQM-08-2023-0245.

F. Nurprihatin, G. D. Rembulan, and Y. D. Pratama, “Comparing Probabilistic Economic Order Quantity and Periodic Order Quantity Model Performance Under Lumpy Demand Environment,” Management and Production Engineering Review, pp. 16–25, Dec. 2022, doi: 10.24425/mper.2022.142391.

A. A. Istiningrum, L. M. Munandar, and _ Sono, “Reducing Spare Part Inventory Cost with Shortage Elimination through Probabilistic Economic Order Quantity,” KINERJA, vol. 25, no. 2, pp. 179–191, Sep. 2021, doi: 10.24002/kinerja.v25i2.4371.

W. Emar, Z. A. Al-Omari, and S. Alharbi, “Analysis of inventory management of slow-moving spare parts by using ABC techniques and EOQ model-a case study,” Indonesian Journal of Electrical Engineering and Computer Science, vol. 23, no. 2, p. 1159, Aug. 2021, doi: 10.11591/ijeecs.v23.i2.pp1159-1169.

S. Zhang, K. Huang, and Y. Yuan, “Spare Parts Inventory Management: A Literature Review,” Sustainability, vol. 13, no. 5, p. 2460, Feb. 2021, doi: 10.3390/su13052460.

I. Ivan and R. S. Oetama, “Inventory Management System Using Economic Order Quantity And Reorder Point,” G-Tech: Jurnal Teknologi Terapan, vol. 8, no. 4, pp. 2168–2177, Oct. 2024, doi: 10.70609/gtech.v8i4.4780.

K. Rehmani, A. Naseem, Y. Ahmad, M. Z. Mirza, and T. H. Syed, “Development of a hybrid framework for inventory leanness in Technical Services Organizations,” PLoS One, vol. 16, no. 2, p. e0247144, Feb. 2021, doi: 10.1371/journal.pone.0247144.