Artificial Neural Network Model For Optimization of Forecasting Material Inventory
English
DOI:
https://doi.org/10.22219/JTIUMM.Vol25.No2.173-188Keywords:
Artificial Neural Network, Backpropagation, Forecasting, Material Requirement Planning, Optimization, SimulationAbstract
The increasing competition in the fast-moving consumer goods (FMCG) industry leads to demand fluctuations, negatively impacting the accuracy of demand forecasts and determining optimal lot sizes in material inventory planning. Many companies struggle to adopt appropriate forecasting models, resulting in poor accuracy and higher material costs. This study aims to develop an integrated model for forecasting and material planning using simulation. The artificial neural network (ANN) method is proposed to improve forecasting accuracy, with performance evaluated through mean percentage error (MAPE), mean absolute deviation (MAD), and mean squared error (MSE). The forecast results are then applied to optimize material inventory using the economic order quantity (EOQ) model, considering warehouse capacity constraints. The EOQ model is applied to adjust lot sizes under time-varying demand. The findings highlight the importance of integrating forecasting with inventory planning to provide accurate demand predictions and optimal lot sizing, ultimately minimizing material costs in the FMCG industry. This research contributes to better decision-making in supply chain management by enhancing forecasting accuracy and inventory optimization.
Downloads
References
M. Alnahhal, D. Ahrens, and B. Salah, "Optimizing Inventory Replenishment for Seasonal Demand with Discrete Delivery Times," Applied Sciences, vol. 11, no. 23, p. 11210, 2021. https://doi.org/10.3390/app112311210
W. Xu and D.-P. Song, "Integrated Optimisation for Production Capacity, Raw Material Ordering and Production Planning Under Time and Quantity Uncertainties Based on Two Case Studies," Operational Research, vol. 22, no. 3, pp. 2343-2371, 2022. https://doi.org/10.1007/s12351-020-00609-y
S. Irfan and L. V. Dang, "An Artificial Neural Network for Production Planning Automation of Fast-Moving Consumer Goods," 2022. https://dx.doi.org/10.2139/ssrn.4075386
F. Petropoulos, X. Wang, and S. M. Disney, "The Inventory Performance of Forecasting Methods: Evidence from the M3 Competition Data," International Journal of Forecasting, vol. 35, no. 1, pp. 251-265, 2019. https://doi.org/10.1016/j.ijforecast.2018.01.004
Y. Ensafi, S. H. Amin, G. Zhang, and B. Shah, "Time-series Forecasting of Seasonal Items Sales Using Machine Learning–A Comparative Analysis," International Journal of Information Management Data Insights, vol. 2, no. 1, p. 100058, 2022. https://doi.org/10.1016/j.jjimei.2022.100058
C.-Y. Kao and H.-E. Chueh, "Deep Learning Based Purchase Forecasting for Food Producer‐Retailer Team Merchandising," Scientific Programming, vol. 2022, no. 1, p. 2857850, 2022. https://doi.org/10.1155/2022/2857850
U. Venkatadri, S. Wang, and A. Srinivasan, "A Model for Demand Planning in Supply Chains with Congestion Effects," Logistics, vol. 5, no. 1, p. 3, 2021. https://doi.org/10.3390/logistics5010003
H. Dittfeld, K. Scholten, and D. P. Van Donk, "Proactively and reactively managing risks through sales & operations planning," International Journal of Physical Distribution & Logistics Management, vol. 51, no. 6, pp. 566-584, 2021. https://doi.org/10.1108/IJPDLM-07-2019-0215
E. E. Kosasih and A. Brintrup, "Reinforcement Learning Provides a Flexible Approach for Realistic Supply Chain Safety Stock Optimisation," IFAC-PapersOnLine, vol. 55, no. 10, pp. 1539-1544, 2022. https://doi.org/10.1016/j.ifacol.2022.09.609
E. Bottani, P. Centobelli, M. Gallo, M. A. Kaviani, V. Jain, and T. Murino, "Modelling Wholesale Distribution Operations: an Artificial Intelligence Framework," Industrial Management & Data Systems, vol. 119, no. 4, pp. 698-718, 2019. https://doi.org/10.1108/IMDS-04-2018-0164
S. Teerasoponpong and A. Sopadang, "Decision Support System for Adaptive Sourcing and Inventory Management in small-and medium-sized enterprises," Robotics and Computer-Integrated Manufacturing, vol. 73, p. 102226, 2022. https://doi.org/10.1016/j.rcim.2021.102226
A. Laurent and D. Lemoine, "A Particle Swarm Optimization method based on cost modification heuristic for the Multi Level Lot Sizing Problem," IFAC-PapersOnLine, vol. 55, no. 10, pp. 1243-1248, 2022. https://doi.org/10.1016/j.ifacol.2022.09.560
A. Mubin, F. Syahril, and T. Y. Rosiani, "Sustainable EOQ Model with Multi Container Transportation Problems," Jurnal Teknik Industri, vol. 22, no. 2, pp. 236-244, 2021. https://doi.org/10.22219/JTIUMM.Vol22.No2.236-244
L. Budde, S. Liao, R. Haenggi, and T. Friedli, "Use of DES to Develop a Decision Support System for Lot Size Decision-Making in Manufacturing Companies," Production & Manufacturing Research, vol. 10, no. 1, pp. 494-518, 2022. https://doi.org/10.1080/21693277.2022.2092564
V. Bindewald, F. Dunke, and S. Nickel, "Comparison of Different Approaches to Multistage Lot Sizing with Uncertain Demand," International Transactions in Operational Research, vol. 30, no. 6, pp. 3771-3800, 2023. https://doi.org/10.1111/itor.13305
C. Çalışkan, "A Simple Derivation of the Optimal Solution for the EOQ Model for Deteriorating Items with Planned Backorders," Applied Mathematical Modelling, vol. 89, pp. 1373-1381, 2021. https://doi.org/10.1016/j.apm.2020.08.037
X. Wang, S. M. Disney, and B. Ponte, "On the Stationary Stochastic Response of an order-constrained inventory system," European Journal of Operational Research, vol. 304, no. 2, pp. 543-557, 2023. https://doi.org/10.1016/j.ejor.2022.04.020
A. Pooya, N. Fakhlaei, and A. Alizadeh-Zoeram, "Designing a dynamic model to evaluate lot-sizing policies in different scenarios of demand and lead times in order to reduce the nervousness of the MRP system," Journal of Industrial and Production Engineering, vol. 38, no. 2, pp. 122-136, 2021. https://doi.org/10.1080/21681015.2020.1858982
M. You, Y. Xiao, S. Zhang, S. Zhou, P. Yang, and X. Pan, "Modeling the capacitated multi-level lot-sizing problem under time-varying environments and a fix-and-optimize solution approach," Entropy, vol. 21, no. 4, p. 377, 2019. https://doi.org/10.3390/e21040377
D. Damand, Y. Lahrichi, and M. Barth, "A simulation-optimization approach to parameterize Demand-Driven Material Requirements Planning," IFAC-PapersOnLine, vol. 55, no. 10, pp. 263-268, 2022. https://doi.org/10.1016/j.ifacol.2022.09.626
R. Alfred et al., "Modelling and Forecasting Fresh Agro‐Food Commodity Consumption Per Capita in Malaysia Using Machine Learning," Mobile Information Systems, vol. 2022, no. 1, p. 6106557, 2022. https://doi.org/10.1155/2022/6106557
A. Forel and M. Grunow, "Dynamic stochastic lot sizing with forecast evolution in rolling‐horizon planning," Production and Operations Management, vol. 32, no. 2, pp. 449-468, 2023. https://doi.org/10.1111/poms.13881
Y. Tliche, A. Taghipour, and B. Canel-Depitre, "An improved forecasting approach to reduce inventory levels in decentralized supply chains," European Journal of Operational Research, vol. 287, no. 2, pp. 511-527, 2020. https://doi.org/10.1016/j.ejor.2020.04.044
M. Seyedan, F. Mafakheri, and C. Wang, "Order-up-to-level inventory optimization model using time-series demand forecasting with ensemble deep learning," Supply Chain Analytics, vol. 3, p. 100024, 2023. https://doi.org/10.1016/j.sca.2023.100024
L. A. San-José, J. Sicilia, M. González-de-la-Rosa, and J. Febles-Acosta, "Profit maximization in an inventory system with time-varying demand, partial backordering and discrete inventory cycle," Annals of Operations Research, vol. 316, no. 2, pp. 763-783, 2022. https://doi.org/10.1007/s10479-021-04161-6
Y. Zhou, H. Li, S. Hu, and X. Yu, "Two-stage supply chain inventory management based on system dynamics model for reducing bullwhip effect of sulfur product," Annals of Operations Research, vol. 337, no. Suppl 1, pp. 5-5, 2024. https://doi.org/10.1007/s10479-022-04815-z
N. F. Salehuddin, M. B. Omar, R. Ibrahim, and K. Bingi, "A neural network-based model for predicting Saybolt color of petroleum products," Sensors, vol. 22, no. 7, p. 2796, 2022. https://doi.org/10.3390/s22072796
A. Agustiandi, Y. M. K. Aritonang, and C. Rikardo, "Integrated inventory model for single vendor multi-buyer with a single item by considering warehouse and capital constraint," Jurnal Teknik Industri, vol. 22, no. 1, pp. 71-84, 2021. https://doi.org/10.22219/JTIUMM.Vol22.No1.71-84
A. Mitra, A. Jain, A. Kishore, and P. Kumar, "A comparative study of demand forecasting models for a multi-channel retail company: a novel hybrid machine learning approach," 2022, vol. 3, p. 58: Springer. https://doi.org/10.1007/s43069-022-00166-4
B. Souayeh and Z. Sabir, "Designing hyperbolic tangent sigmoid function for solving the Williamson nanofluid model," Fractal and Fractional, vol. 7, no. 5, p. 350, 2023. https://doi.org/10.3390/fractalfract7050350
N. B. Sushmi and D. Subbulekshmi, "Performance Analysis of FFBP‐LM‐ANN Based Hourly GHI Prediction Using Environmental Variables: A Case Study in Chennai," Mathematical Problems in Engineering, vol. 2022, no. 1, p. 1713657, 2022. https://doi.org/10.1155/2022/1713657
K.-L. Du, C.-S. Leung, W. H. Mow, and M. N. S. Swamy, "Perceptron: Learning, generalization, model selection, fault tolerance, and role in the deep learning era," Mathematics, vol. 10, no. 24, p. 4730, 2022. https://doi.org/10.3390/math10244730
X. Huang, H. Cao, and B. Jia, "Optimization of Levenberg Marquardt algorithm applied to non-linear systems," Processes, vol. 11, no. 6, p. 1794, 2023. https://doi.org/10.3390/pr11061794
A. M. Khan and M. Osińska, "Comparing forecasting accuracy of selected grey and time series models based on energy consumption in Brazil and India," Expert Systems with Applications, vol. 212, p. 118840, 2023. https://doi.org/10.1016/j.eswa.2022.118840
L. A. San-José, M. González-De-la-Rosa, J. Sicilia, and J. Febles-Acosta, "An inventory model for multiple items assuming time-varying demands and limited storage," Optimization Letters, vol. 16, no. 6, pp. 1935-1961, 2022. https://doi.org/10.1007/s11590-021-01815-z
D. M. Utama, S. Rubiyanti, and R. W. Wardana, "Optimization Multi-Item Lot Sizing Model involve Transportation and Capacity Constraint under Stochastic Demand using Aquila Optimizer," Jurnal Teknik Industri, vol. 24, no. 1, pp. 31-50, 2023. https://doi.org/10.22219/JTIUMM.Vol24.No1.31-50
D. Pal, A. K. Manna, I. Ali, P. Roy, and A. A. Shaikh, "A two-warehouse inventory model with credit policy and inflation effect," Decision Analytics Journal, vol. 10, p. 100406, 2024. https://doi.org/10.1016/j.dajour.2024.100406
A. K. Jain, S. Chouhan, R. K. Mishra, P. R. S. Choudhry, H. Saxena, and R. Bhardwaj, "Application of linear programming in small mechanical based industry for profit maximization," Materials Today: Proceedings, vol. 47, pp. 6701-6703, 2021. https://doi.org/10.1016/j.matpr.2021.05.117
A. Achergui, H. Allaoui, and T. Hsu, "Demand Driven MRP with supplier selection," IFAC-PapersOnLine, vol. 55, no. 10, pp. 257-262, 2022. https://doi.org/10.1016/j.ifacol.2022.09.398
R. Abbate, P. Manco, M. Caterino, M. Fera, and R. Macchiaroli, "Demand forecasting for delivery platforms by using neural network," IFAC-PapersOnLine, vol. 55, no. 10, pp. 607-612, 2022. https://doi.org/10.1016/j.ifacol.2022.09.465
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 Denny Suci Prastiya
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
