IIARD International Institute of Academic Research and Development

International Journal of Engineering and Modern Technology (IJEMT )

E-ISSN 2504-8848
P-ISSN 2695-2149
VOL. 8 NO. 5 2022
DOI: https://doi.org/10.56201/ijemt.v8.no5.2022.pg101.108

---

Forecasting Model Accuracy Assessment in a Bottled Water Supply Chain

Ovundah King Wofuru-Nyenke

---

Abstract

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:

Demand Forecasting, Moving Average, Exponential Smoothing, Mean Absolute Percent Deviation, Tracking Signal.

---

References:

Chopra, S. & Meindl, P. (2016). Supply Chain Management: Strategy, Planning, and
Operation. 6th ed., London, LDN: Pearson Education Ltd.

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.

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.

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.

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.

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.

Rossi, B., & Sekhposyan, T. (2011). Understanding models’ forecasting performance.
Journal of Econometrics, 164(1), 158–172.

Russel, R.S. & Taylor, B.W. (2011). Operations Management. 7 th ed., New Jersey, NJ: John
Wiley & Sons, Inc.

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.

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.

Wofuru-Nyenke, O. K. (2021). Value Stream Mapping: A Tool for Waste Reduction.
International Journal of Innovative Research & Development, 10(6), 13 – 20.

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.

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.

DOWNLOAD PDF

---

Back