Forecasting Model Accuracy Assessment in a Bottled Water Supply Chain

This study presents an accuracy assessment of various classical time series forecasting methods to determine the most accurate forecasting method for 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. The Mean Absolute Percent Deviation (MAPD) value was determined for the various forecasting methods to find the forecasting method with the least MAPD and hence the highest forecasting accuracy. The tracking signal measure was also used to determine the forecasting models which were biased. The results showed that though the weighted moving average method began to underforecast demand in the final period, it had the lowest MAPD value of 2.25%, making it the forecasting method with the highest accuracy for predicting the 50cl bottled water demand. On the other hand, though the exponential smoothing forecasting method had the highest MAPD value of 3.43% and least accuracy for predicting the bottled water demand, its forecasts were consistently within the tracking signal control limits. This study will aid supply chain analysts in implementing accuracy assessment of classical time series forecasting models.

Keywords:

APA Referencing Format

Wofuru-Nyenke, O. K. (2025). Forecasting Model Accuracy Assessment in a Bottled Water Supply Chain. International Journal of Engineering Analysis and Computations (IJEAC), 1(1), 20-26.

1. Chopra, S. & Meindl, P. (2016). Supply Chain Management: Strategy, Planning, and Operation. 6th ed., London, LDN: Pearson Education Ltd.
2. Janvier-James, A. M. (2012). A new introduction to supply chains and supply chain management: Definitions and theories perspective. International Business Research, 5(1), 194-207.
3. Klimberg, R. K., Sillup, G. P., Boyle, K. J., & Tavva, V. (2010). Forecasting performance measures – what are their practical meaning? Advances in Business and Management Forecasting, 137–147.
4. Koutsandreas, D., Spiliotis, E., Petropoulos, F., & Assimakopoulos, V. (2022). On the selection of forecasting accuracy measures. Journal of the Operational Research Society, 73(5), 937-954.
5. Lummus, R. R., Krumwiede, D. W., & Vokurka, R. J. (2001). The relationship of logistics to supply chain management: developing a common industry definition. Industrial Management & Data Systems, 101(8), 426–432.
6. Mentzer, J. T., DeWitt, W., Keebler, J. S., Min, S., Nix, N. W., Smith, C. D., & Zacharia, Z. G. (2001). Defining supply chain management. Journal of Business logistics, 22(2), 1-25.
7. Rossi, B., & Sekhposyan, T. (2011). Understanding models’ forecasting performance. Journal of Econometrics, 164(1), 158–172.
8. Russel, R.S. & Taylor, B.W. (2011). Operations Management. 7th ed., New Jersey, NJ: John Wiley & Sons, Inc.
9. Stock, J.R., & Boyer, S.L. (2009). Developing a consensus definition of supply chain management: a qualitative study. International Journal of Physical Distribution & Logistics Management, 39(8), 690–711.
10. Wofuru-Nyenke, O., & Briggs, T. (2022). Predicting demand in a bottled water supply chain using classical time series forecasting models. Journal of Future Sustainability, 2(2), 65-80.
11. Wofuru-Nyenke, O. K. (2021). Value Stream Mapping: A Tool for Waste Reduction. International Journal of Innovative Research & Development, 10(6), 13 – 20.
12. 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.
13. 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.