Predicting Demand in a Bottled Water Supply Chain Using Classical Time Series Forecasting Models

In this paper, various classical time series forecasting methods were compared to determine the forecasting method with the highest accuracy in predicting demand of the 50cl product of a bottled water supply chain. The classical time series forecasting methods compared are the moving average, weighted moving average, exponential smoothing, adjusted exponential smoothing, linear trend line, Holt’s model, and Winter’s model. These methods were evaluated to determine the method with the least Mean Absolute Deviation (MAD) value and hence the highest forecasting accuracy. From the results, the weighted moving average forecasting method had the lowest MAD value of 1,987, making it the forecasting method with the highest accuracy for predicting the 50cl bottled water demand. While the exponential smoothing forecasting method had the highest MAD value of 2,483, making it the forecasting method with the least accuracy for predicting the 50cl bottled water demand. This research provides a procedure for aiding supply chain analysts in implementing demand forecasting using classical time series forecasting models.

Keywords:

APA Referencing Format

Wofuru-Nyenke, O. K. (2025). Predicting Demand in a Bottled Water Supply Chain Using Classical Time Series Forecasting Models. International Journal of Applied Mathematics, Simulations and Optimisation (IJAMSO), 1(1), 1-22.

1. Adamuthe, A.C., Gage, R.A., & Thampi, G.T. (2015). Forecasting cloud computing using double exponential smoothing methods. 2015 International Conference on Advanced Computing and Communication Systems, 1 – 5.
2. Billah, B., King, M.L., Snyder, R.D., & Koehler, A.B. (2006). Exponential smoothing model selection for forecasting. International Journal of Forecasting, 22(2), 239 – 247.
3. Brownlee, J. (2018). Deep Learning for Time Series Forecasting: Predict the Future with MLPs, CNNs and LSTMs in Python. 1st ed., Independently Published.
4. Chopra, S. & Meindl, P. (2016). Supply Chain Management: Strategy, Planning, and Operation. 6th ed., London, LDN: Pearson Education Ltd.
5. Ekhosuehi, N., Dickson, E.A.O., & Omorogbe, A. (2016). On forecast performance using a class of weighted moving average processes for time series. Journal of Natural Sciences Research, 6(13), 2224 – 3186.
6. George, M.L., Rowlands, D., Price, M. & Maxey, J. (2005). The Lean Six Sigma Pocket Toolbook: A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity. New York, NY: McGraw-Hill.
7. Grubb, H., & Mason, A. (2001). Long lead-time forecasting of UK air passengers by Holt–Winters methods with damped trend. International Journal of Forecasting, 17(1), 71 – 82.
8. Mateia, N.A. (2013). Simple Moving Average vs Linear Regression Forecast. Journal Annals Economy Series, 16, 83 – 88.
9. Montgomery, D.C., Runger, G.C. & Hubele, N.F. (2011). Engineering Statistics. 5th ed., New Jersey, NJ: John Wiley & Sons, Inc.
10. Nakade, K., & Aniyama, Y. (2019). Bullwhip effect of weighted moving average forecast under stochastic lead time. IFAC-PapersOnLine, 52(13), 1277-1282.
11. Rendon-Sanchez, J.F., & de Menezes, L.M. (2019). Structural combination of seasonal exponential smoothing forecasts applied to load forecasting. European Journal of Operational Research, 275(3), 916 – 924.
12. Russel, R.S. & Taylor, B.W. (2011). Operations Management. 7th ed., New Jersey, NJ: John Wiley & Sons, Inc.
13. Segura, J.V., & Vercher, E. (2001). A spreadsheet modeling approach to the Holt–Winters optimal forecasting. European Journal of Operational Research, 131(2), 375 – 388.
14. Shih, S.H. & Tsokos, C.P. (2008). A Weighted Moving Average Process for Forecasting. Journal of Modern Applied Statistical Methods, 7(1), 187 – 197.
15. Wofuru-Nyenke, O.K. (2021). Value Stream Mapping: A Tool for Waste Reduction. International Journal of Innovative Research & Development, 10(6), 13 – 20.
16. Wofuru-Nyenke, O.K., Briggs, T.A., & Aikhuele, D.O. (2022). Advancements in Sustainable Manufacturing Supply Chain Modelling: a Review. Process Integration and Optimization for Sustainability, 1 – 25.
17. Wofuru-Nyenke, O.K., Nkoi, B., & Oparadike, F.E. (2019). Waste and Cost Reduction for a Water Bottling Process Using Lean Six Sigma. European Journal of Engineering and Technology Research, 4(12), 71 – 77.
18. Yu, J., Kim, S.B., Bai, J., & Han, S.W. (2020). Comparative Study on Exponentially Weighted Moving Average Approaches for the Self-Starting Forecasting. Applied Sciences, 10(20), 1 – 18.