Scribd
Upload
47 views2 pages

Weekly Demand Forecast Errors

This document compares two different forecasting methods, MA 4 and MA 5, against actual demand data over a 35 week period. It provides the error, absolute error, error squared, and absolute error as a percentage of demand for each forecasting method. Summary statistics including the mean absolute deviation (MAD), mean squared error (MSE), and mean absolute percentage error (MAPE) are also calculated to evaluate the accuracy of each forecasting method.

Uploaded by

saleh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
47 views2 pages

Weekly Demand Forecast Errors

This document compares two different forecasting methods, MA 4 and MA 5, against actual demand data over a 35 week period. It provides the error, absolute error, error squared, and absolute error as a percentage of demand for each forecasting method. Summary statistics including the mean absolute deviation (MAD), mean squared error (MSE), and mean absolute percentage error (MAPE) are also calculated to evaluate the accuracy of each forecasting method.

Uploaded by

saleh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Week Actual MA 4 Error ABS Error Error ABS Error /

Demand forecast square Demand *100


(thousands)
20 63.3
21 62.5
22 67.8
23 66
24 67.2 64.9 -2.3 2.3 5.29 3.42
25 69.9 65.9 -4.03 4.03 16.2 5.77
26 65.6 67.7 2.13 2.13 4.52 3.25
27 71.1 67.2 -3.93 3.93 15.41 5.53
28 68.8 68.5 -0.35 0.35 0.12 0.51
29 68.4 68.9 0.45 0.45 0.2 0.66
30 70.3 68.5 -1.83 1.83 3.33 2.6
31 72.5 69.7 -2.85 2.85 8.12 3.93
32 66.7 70 3.3 3.3 10.89 4.95
33 68.3 69.5 1.18 1.18 1.38 1.73
34 67 69.5 2.45 2.45 6 3.66
35 68.6

Error Error Square ABS Error / Demand *1


Sum 24.8 71.46 36

MAD 2.25
MSE 6.5
MAPE 3.27

Week Actual MA 5 Error ABS Error Error ABS Error /


Demand forecast square Demand *100
(thousands
)
20 63.3
21 62.5
22 67.8
23 66
24 67.2 57 -12 12 144 26.66667
25 69.9 45 3 3 9 6.25
26 65.6 48 7 7 49 12.72727
27 71.1 55 -5 5 25 10
28 68.8 50 -8 8 64 19.04762
29 68.4 42 8 8 64 16
30 70.3 50 7 7 49 12.2807
31 72.5 57 -6 6 36 11.76471
32 66.7 51 3 3 9 5.555556
33 68.3 54 0 0 0 0
34 67 54 -3 3 9 5.882353
35 68.6 1 1 1 1.923077

You might also like