Question: Develop forecasts for periods 6 through 10 for the demand data in the below table, using a) a three period moving average (MA). b) a
Develop forecasts for periods 6 through 10 for the demand data in the below table, using
a) a three period moving average (MA).
b) a weighted moving average (WMA) using 0.5 for the most recent data, 0.3 for the period prior to the most recent data and 0.2 for the oldest data.
c) exponential smoothing with alpha = 0.4. Use a 5th period forecast of 105 as the starting point for the
exponential smoothing technique.
| Period | Actual | MA | WMA | Exp. Smoothing |
| 1 | 64 |
|
|
|
| 2 | 84 |
|
|
|
| 3 | 91 |
|
|
|
| 4 | 97 |
|
|
|
| 5 | 105 |
|
|
|
| 6 | 135 |
|
|
|
| 7 | 147 |
|
|
|
| 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
