Demand Forecasting and Budget Planning for Automotive Supply Chain




ARIMA, Holt-Winters, LSTM


Over the past 20 years, there have been significant changes in the supply chain business. One of the most significant changes has been the development of supply chain management systems. It is now essential to use cutting-edge technologies to maintain competitiveness in a highly dynamic environment. Restocking inventories is one of a supplier’s main survival strategies and knowing what expenses to expect in the next month aids in better decision-making. This study aims to solve the three most common industry problems in Supply Chain – Inventory Management, Budget Fore-casting, and Cost vs Benefit of every supplier. The selection of the best forecasting model is still a major problem in much research in literature. In this context, this article aims to compare the performances of Auto-Regressive Integrated Moving Average (ARIMA), Holt-Winters (HW), and Long Short-Term Memory (LSTM) models for the prediction of a time series formed by the dataset of Supply Chain products. As performance measures, metric analysis of the Root Mean Square Error (RMSE) is used. The main concentration is on the Automotive Business Unit with the top 3 products under this segment and the country United States being in focus. All three models, ARIMA, HW, and LSTM obtained better results regarding the performance metrics.


Download data is not yet available.
<br data-mce-bogus="1"> <br data-mce-bogus="1">


J. Wisner, K. Tan, and G. Leong, Principles of supply chain management: a balanced approach. Cengage Learning, 2014.

Z. Aman, L. Ezzine, and J. Fattah, “Forecasting of demand using ARIMA model,” Int. J. Eng. Bus. Manag., 2018, doi: DOI:

D. Lu, Fundamentals of supply chain management. bookboon, 2011.

M. Baker and S. Hart, The Marketing Book, 7th Editio. Routledge, 2016. DOI:

C. Singh, “Demand forecasting with Machine Learning,” thinkdeeply, 2021.

H. Stadtler, Supply Chain Management — An Overview. Springer-Verlag Berlin Heidelberg, 2008. DOI:

W. Pewdum, T. Rujirayanyong, and V. Sooksatra, “Forecasting final budget and duration of highway construction projects,” Emerald, p. 14, 2009. DOI:

R. McNown and H. Baghestani, “Forecasting the federal budget with time-series models,” Wiley, vol. 11, no. 2, pp. 127–139, 1992. DOI:


A. Dotis-Georgiou, “An introduction to time series forecasting,” InfoWorld, 2021.

S. Sridevi, S. Rajaram, and G. Mahalakshmi, “A survey on forecasting of time series data,” IEEE, 2016, [Online]. Available: DOI:

P. Kalekar, “Time series Forecasting using Holt-Winters Exponential Smoothing,” p. 13, 2004, [Online]. Available:

D. Calitoiu and R. Ueno, “Forecasting Attrition from the Canadian Armed Forces using Multivariate LSTM,” ICMLA, pp. 753–758, 2020, doi: 10.1109/ICMLA51294.2020.00123. DOI:

L. Zhang and V. K. Reddy Chimmula, “Time series forecasting of COVID-19 transmission in Canada using LSTM networks,” Elsevier, 2020, doi: DOI:

C. Ayo, A. O. Adewumi, and A. Ariyo, “Stock Price Prediction Using the ARIMA Model,” AMSS 16th Int. Conf. Comput. Model. Simul., pp. 106–112, 2014, doi: 10.1109/UKSim.2014.67. DOI:

G. Reinsel, G. Jenkins, and G. Box, Time Series Analysis: Forecasting and Control, 4th Edition, 4th Edition. John Wiley & Sons, Inc., 2013.

Ghosh, H., Tusher, M.A., Rahat, I.S., Khasim, S., Mohanty, S.N. (2023). Water Quality Assessment Through Predictive Machine Learning. In: Intelligent Computing and Networking. IC-ICN 2023. Lecture Notes in Networks and Systems, vol 699. Springer, Singapore. DOI:

Alenezi, F.; Armghan, A.; Mohanty, S.N.; Jhaveri, R.H.; Tiwari, P. Block-Greedy and CNN Based Underwater Image Dehazing for Novel Depth Estimation and Optimal Ambient Light. Water 2021, 13, 3470. DOI:

G. P. Rout and S. N. Mohanty, "A Hybrid Approach for Network Intrusion Detection," 2015 Fifth International Conference on Communication Systems and Network Technologies, Gwalior, India, 2015, pp. 614-617, doi: 10.1109/CSNT.2015.76. DOI:




How to Cite

A. Limbare and R. Agarwal, “Demand Forecasting and Budget Planning for Automotive Supply Chain”, EAI Endorsed Trans IoT, vol. 10, Nov. 2023.