Implementation Economic Order Quantity and Reorder Point Methods in Inventory Management Information Systems

  • Heribertus Ary Setyadi Universitas Bina Sarana Informatika, Indonesia
  • Budi Al Amin Universitas Bina Sarana Informatika, Indonesia
  • Pudji Widodo Universitas Bina Sarana Informatika, Indonesia
Keywords: Economic Order Quantity, Inventory, Management Information System, Reorder Point

Abstract

Inventory control is at the core of supply management to balance inventory needs and demand. With an inventory system, management can control stock of materials and goods, production process and sales transactions can even stop the production process if necessary. Sari Gamping building materials store that sells various building needs including building materials and tools. Data management of goods, transactions and inventory processing still uses conventional methods using Microsoft Office. The purpose of this research is to analyze the ongoing inventory management process to create an inventory management information system so that it can help the Sari Gamping store in controlling inventory. The Economic Order Quantity (EOQ) and reorder point methods were chosen to optimize inventory to avoid shortages or excess inventories, to fulfill customer orders, to achieve cost efficiency and to prevent problems that may occur. The developed system can manage data on goods, categories, suppliers, manage purchase and sales transactions and can generate information from EOQ calculations, safety stock and reorder points. From the results of testing the calculations of the two methods used with 15 samples of catylac paint variants, the average inventory cost saving in June 2023 was 65.33%.

Downloads

Download data is not yet available.

References

J. S. Pasaribu, “Development of a Web Based Inventory Information System,” Int. J. Eng. Sci. Inf. Technol., vol. 1, no. 2, pp. 24–31, 2021, doi: 10.52088/ijesty.v1i2.51.

J. Vasilev and T. Milkova, “Optimisation Models for Inventory Management with Limited Number of Stock Items,” Logistics, vol. 6, no. 3, p. 54, 2022, doi: 10.3390/logistics6030054.

W. S. Saputra, R. Ernawati, and W. A. Wulansari, “Analysis of Raw Material Inventory Control Using Economic Order Quantity (EOQ) Method at CV. XYZ,” Int. J. Comput. Inf. Syst., vol. 2, no. 3, pp. 118–124, 2021, doi: 10.29040/ijcis.v2i3.63.

S. P. Anantadjaya, I. M. Nawangwulan, M. Irhamsyah, and P. W. Carmelita, “Supply chain management, inventory management & financial performance: evidence from manufacturing firms,” Linguist. Cult. Rev., vol. 5, no. S1, pp. 781–794, 2021, doi: 10.21744/lingcure.v5ns1.1463.

S. Apriyanti and D. Y. Bernanda, “Inventory Information System Development to Improve Goods Data Collection Process,” J. Inf. Syst. Informatics, vol. 5, no. 3, pp. 860–873, 2023, doi: 10.51519/journalisi.v5i3.510.

A. F. Wijaya, R. Saputri, C. Rudianto, and A. D. Manuputty, “Designing of Information System for Stock Management using the FAST (FRAMEWORK FOR THE APPLICATIONS) Method,” J. Inf. Syst. Informatics, vol. 2, no. 1, pp. 79–88, 2020, doi: 10.33557/journalisi.v2i1.46.

Y. D. R. Montororing and M. Widyantoro, “Model of Inventory Planning Using Monte Carlo Simulation in Retail Supermarket With Consider To Competitors and Stimulus Strategies,” J. Appl. Eng. Technol. Sci., vol. 4, no. 1, pp. 342–350, 2022, doi: 10.37385/jaets.v4i1.1093.

A. J. Caicedo-Rolón, M. V. Davila Perez, and Palacios-Alvarado Wlamyr, “Inventory Management In Manufacturing Organizations,” J. Lang. Linguist. Stud., vol. 18, no. 4, pp. 995–1007, 2022.

D. Gebisa, “The Impact of Information Sharing and Inventory Management Practices on Firms’ Performance in Supply Chain Practices,” Gadjah Mada Int. J. Bus., vol. 25, no. 2, pp. 199–225, 2023, doi: 10.22146/gamaijb.69616.

A. Rashid and R. Rasheed, “Mediation of Inventory Management in the Relationship Between Knowledge and Firm Performance,” SAGE Open, vol. 13, no. 2, pp. 1–11, 2023, doi: 10.1177/21582440231164593.

M. Z. A. Rikiti, E. Kusmayanto, and R. Kurniawati, “Design and Development of Help Patient Data Management Information System At Sinergi Atap Negeri Foundation Web-Based Using Codeigniter,” J. Appl. Eng. Technol. Sci., vol. 3, no. 2, pp. 235–245, 2022, doi: 10.37385/jaets.v3i2.792.

A. Imran, Haripuddin, Sanatang, and M. Hasan Z, “Development of Service Mail Management Information System As a Supporting System for Calculating Recapitulation of Remuneration Performance Points At Universitas Negeri Makassar,” J. Appl. Eng. Technol. Sci., vol. 4, no. 1, pp. 415–428, 2022, doi: 10.37385/jaets.v4i1.1331.

E. S. Soegoto and A. F. Palalungan, “Web Based Online Inventory Information System,” in IOP Conference Series: Materials Science and Engineering, 2020, pp. 1–6. doi: 10.1088/1757-899X/879/1/012125.

P. Yawara, N. Supattananon, P. Siwapornrak, and R. Akararungruangkul, “Purchasing planning for pharmaceuticals inventory : a case study of drug warehouse in hospital,” Indones. J. Electr. Eng. Comput. Sci., vol. 31, no. 3, pp. 1496–1506, 2023, doi: 10.11591/ijeecs.v31.i3.pp1496-1506.

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,” Indones. J. Electr. Eng. Comput. Sci., vol. 23, no. 2, pp. 1159–1169, 2021, doi: 10.11591/ijeecs.v23.i2.pp1159-1169.

A. Vania and H. Yolina, “Analysis Inventory Cost Jona Shop with EOQ Model,” Eng. Math. Comput. Sci. J., vol. 3, no. 1, pp. 21–25, 2021, doi: 10.21512/emacsjournal.v3i1.6847.

A. H. Nobil, A. H. A. Sedigh, and L. E. Cárdenas-Barrón, “Reorder point for the EOQ inventory model with imperfect quality items,” Ain Shams Eng. J., vol. 11, no. 4, pp. 1339–1343, 2020, doi: 10.1016/j.asej.2020.03.004.

B. Sugiarto and H. Haryanto, “Inventory Management System Design On Angel Collection,” in ConCEPt - Conference on Community Engagement Project, 2022, pp. 635–643.

R. H. Lubis, F. A. Nasution, and A. P. Juledi, “Design and Build Inventory System using EOQ and ROP Methods (Case Study: CV. Ziefa Karya),” Sinkron, vol. 7, no. 2, pp. 729–736, 2022, doi: 10.33395/sinkron.v7i2.11419.

F. Frieyadie and T. Setiyorini, “Implementation of Inventory Information System Design,” J. Ris. Inform., vol. 3, no. 2, pp. 187–194, 2021, doi: 10.34288/jri.v3i2.236.

M. Rumetna, E. E. Renny, and T. N. Lina, “Designing an Information System for Inventory Forecasting,” Int. J. Adv. Data Inf. Syst., vol. 1, no. 2, pp. 80–88, 2020, doi: 10.25008/ijadis.v1i2.187.

Published
2024-03-23
Abstract views: 228 times
Download PDF: 83 times
How to Cite
Setyadi, H., Al Amin, B., & Widodo, P. (2024). Implementation Economic Order Quantity and Reorder Point Methods in Inventory Management Information Systems. Journal of Information Systems and Informatics, 6(1), 103-117. https://doi.org/10.51519/journalisi.v6i1.647