Question: Develop forecasts for periods 7 through 10 for the demand data in the table using a three period moving average, a weighted moving average using
Develop forecasts for periods 7 through 10 for the demand data in the table using a three period moving average, a weighted moving average using 0.6, 0.3, and 0.1, and exponential smoothing with alpha = 0.5. Use a 6th period forecast of 130 as the starting point for the exponential smoothing technique. You need to fill the table starting from period 7, and show the equation used and one calculation example for each of the three models.
| Period | Actual | MA n = 3 | 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
