Implementation Economic Order Quantity and Reorder Point Methods in Inventory Management Information Systems
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
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.
Abstract views: 1200 times
Download PDF: 707 times
Copyright (c) 2024 Journal of Information Systems and Informatics
This work is licensed under a Creative Commons Attribution 4.0 International License.
- 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.
- I certify that all authors have approved the publication of this and there is no conflict of interest.
- 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.
- 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.
- I confirm that the paper now submitted is not copied or plagiarized version of some other published work.
- 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.
- 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
- I Agree that the paper published by this journal, I transfer copyright or assign exclusive rights to the publisher (including commercial rights)
_1.png){kind=logo}
