Implementation Economic Order Quantity and Reorder Point Methods in Inventory Management Information Systems
DOI:
https://doi.org/10.51519/journalisi.v6i1.647Keywords:
Economic Order Quantity, Inventory, Management Information System, Reorder PointAbstract
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
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.
Downloads
Published
Issue
Section
License
Authors Declaration
- The Authors certify that they have read, understood, and agreed to the Journal of Information Systems and Informatics (JournalISI) submission guidelines, policies, and submission declaration. The submission has been prepared using the provided template.
- The Authors certify that all authors have approved the publication of this manuscript and that there is no conflict of interest.
- The Authors confirm that the manuscript is their original work, has not received prior publication, is not under consideration for publication elsewhere, and has not been previously published.
- The Authors 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.
- The Authors confirm that the manuscript is not copied from or plagiarized from any other published work.
- The Authors declare that the manuscript will not be submitted for publication in any other journal or magazine until a decision is made by the journal editors.
- If the manuscript is finally accepted for publication, the Authors confirm that they will either proceed with publication immediately or withdraw the manuscript in accordance with the journal’s withdrawal policies.
- The Authors agree that, upon publication of the manuscript in this journal, they transfer copyright or assign exclusive rights to the publisher, including commercial rights
