Browse > Article
http://dx.doi.org/10.6109/jicce.2021.19.4.221

Early Warning System for Inventory Management using Prediction Model and EOQ Algorithm  

Majapahit, Sali Alas (Department of Informatics Engineering, Pasundan University)
Hwang, Mintae (Department of Information and Communication Engineering, Changwon National University)
Abstract
An early warning system was developed to help identify stock status as early as possible. For performance to improve, there needs to be a feature to predict the amount of stock that must be provided and a feature to estimate when to buy goods. This research was conducted to improve the inventory early warning system and optimize the Reminder Block's performance in minimum stock settings. The models used in this study are the single exponential smoothing (SES) method for prediction and the economic order quantity (EOQ) model for determining the quantity. The research was conducted by analyzing the Reminder Block in the early warning system, identifying data needs, and implementing the SES and EOQ mathematical models into the Reminder Block. This research proposes a new Reminder Block that has been added to the SES and EOQ models. It is hoped that this study will help in obtaining accurate information about the time and quantity of repurchases for efficient inventory management.
Keywords
Early warning system; Inventory management; Economic order quantity (EOQ); Prediction model; Single exponential smoothing (SES);
Citations & Related Records
연도 인용수 순위
  • Reference
1 B. Pujiarto, M. Hanafi, A. Setyawan, A. N. Imani, and E. R. Prasetya, "A data mining practical approach to inventory management and logistics optimization," International Journal of Infromatics and Information Systems, vol. 4, no. 2, pp. 112-122, 2021. DOI: 10.47738/ijiis.v4i2.109.   DOI
2 Y. Asri, "Resource inventory integrated web management system laboratory," Jurnal Ilmu Teknik Dan Komputer, vol. 2, no. 1, pp. 55-63, 2018.
3 Micah, E. E. Michael, Mohammed, K. Adekunle, Akinwunmi, and Adeboye, "Assessment of electronic inventory management systems and utilisation in the healthcare system in Abuja, FCT nigeria," Europan Journal of Business and Innovation Research, vol. 7, no. 6, pp. 1-17, 2019. DOI: 10.37745/ejbir.2013.   DOI
4 I. B. G. Anandita, "Sales forecasting system using single exponential smoothing", Jurnal Mantik, pp. 2552-2557, 2021.
5 F. Hafnika, D. A. Farmaciawaty, A. Adhiutama, and M. H. Basri, "Improvement of inventory control using continuous review policy in a local hospital at Bandung city, Indonesia," The Asian Journal of Technology Management (AJTM), vol. 9, no. 2, pp. 109-119, 2016. DOI: 10.12695/ajtm.2016.9.2.5.   DOI
6 R. Umniati, K. H. Titisari, and Y. Chomsatu, "The influence of current ratio, inventory turnover ratio, cash turnover and debt to equity ratio against the return on investment in the production of industrial companies listed on the stock exchange of Malaysia in 2016," Jurnal Manajemen danBisnis, vol. 3, no. 2, pp. 23-30, 2018, DOI: 10.23917/benefit.v3i1.6533   DOI
7 Setyowati, "Application of single exponential smoothing and double exponential smoothing methods in forecasting clothing sales," Thesis Article, Repository Library, Universitas Nusantara PGRI Kediri, 2017.
8 F. G. Beck, E. H. Grosse, and R. Tebmann, "An extension for dynamic lot-sizing heuristics," Production & Manufacturing Research, vol. 3, no. 1, pp. 20-35, 2015. DOI: 10.1080/21693277.2014.985390.   DOI
9 G. A. Sugianto, Arini, and S. U. Masruroh, "Aplikasi prediksi penjualan dan persediaan barang menggunakan metode SES dan EOQ (Studi Kasus: UD. Sumber Alam Stone)," JISKa, vol. 5, no. 1, pp. 14-22, 2020. DOI: 10.14421/jiska.2020.51-03.   DOI
10 F. Ramdhoni, "Early warning information system model design for vehicle spare parts inventory management," Thesis Article, Repository Library, Fakultas Teknik Universitas Pasundan Bandung, 2020.
11 D. Shenoy and R. Rosas, "Selective inventory control models," Problems & Solutions in Inventory Management, Springer Link, pp. 211-229, 2018. DOI:10.1007/978-3-319-65696-0_8.
12 J. Heizer and B. Render, "Operations Management, Sustainability and Supply Chain Management (11th ed.)," Pearson London, ISBN : 978-0-273-78707-5, 2015.
13 P. Fithri, A. Hasan, and F. M. Asri, "Analysis of inventory control by using economic order quantity model - A case study in PT semen padang," Jurnal Optimasi Sistem Industri, vol. 18, no. 2, pp. 116-124, 2019. DOI: 10.25077/josi.v18.n2.p116-124.2019.   DOI
14 F. Pakaja, A. Naba, and P. Purwanto, "Forecasting car sales using artificial neural networks and certainty factor," Jurnal EECCIS, vol. 6, no. 1, Jun. 2012, eISSN: 2460-8122.
15 Hidayat, "Application of the EOQ (Economic Order Quantity) method in determining chemical supplies in PT. Semen Indonesia," IJSEIT Journal, vol. 5, no. 1, pp. 226-230, 2020, DOI: 10.21107/ijseit.v5i1.8911.   DOI
16 S. K. Paul, "Determination of exponential smoothing constant to minimize mean square error and mean absolute deviation," Global Journal of Research in Engineering, vol. 11, no. 3, pp. 31-34, 2011, ISSN: 0975-5861.
17 A. M. Fuertes and E. Kalotychou, "Early warning systems for sovereign debt crises: the role of heterogeneity," Computational Statistics & Data Analysis, vol. 51, no. 2, pp. 1420-1441, 2006. DOI: 10.1016/j.csda.2006.08.023.   DOI