Homework SoursePlease solve in Excel Weekly demands at Hot Pizza are as fol
Please solve in Excel
Weekly demands at Hot Pizza are as follows:
Week
1
2
3
4
5
6
7
8
9
10
11
12
Demand ($)
108
116
118
124
96
119
96
102
112
102
92
91
Estimate demand for the next four weeks using a four-week moving average as well as simple exponential smoothing with a = .01. Evaluate the MAD, MAPE, MSE, bias and TS in each case. Which of the two methods do you prefer? Why?
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Demand ($) | 108 | 116 | 118 | 124 | 96 | 119 | 96 | 102 | 112 | 102 | 92 | 91 |
Solution
