Question: Develop forecasts for periods 7 through 10 for the demand data in the table below, using a) a three period weighted moving average using 0.6
Develop forecasts for periods 7 through 10 for the demand data in the table below, using
a) a three period weighted moving average using 0.6 (for oldest data), 0.3, and 0.1 (for most recent data).
b) exponential smoothing with alpha = 0.7. Use a 6th period forecast of 135 as the starting point for the
exponential smoothing technique.
c) Calculate MAD and indicate which one of these two forecasting approaches is better for this data. Provide comments regarding results.
| Period | Actual | WMA | Exp. Smoothing |
| 1 | 64 | ||
| 2 | 84 | ||
| 3 | 91 | ||
| 4 | 97 | ||
| 5 | 115 | ||
| 6 | 135 | ||
| 7 | 137 | ||
| 8 | 144 | ||
| 9 | 153 | ||
| 10 | 171 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
