Compute grocery stores weekly demand forecast.
A chain of grocery stores had the following weekly demand (cases) for a particular brand of laundry soap: Dem = Demand
|
Week
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
Dem
|
31
|
22
|
33
|
26
|
21
|
29
|
25
|
22
|
20
|
26
|
- Develop three also four period moving average forecasts also compute MSA for every. Which provides better forecast? Illustrate what would be the forecast for week 11?
- Develop an exponential smoothing forecast with smoothing constants α =0.1 also 0.3. Illustrate what would be the forecast for week 11?
- Compute the tracking signal for every of the forecasts in part (a) also (b). Is there any evidence of bias?
- Might a different model provide better results?