Question: Calculate three forecasts using the following data. For periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 ( F
- Calculate three forecasts using the following data.
- For periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 72.0 and an alpha of 0.4.
- Calculate the three-period moving-average forecast for periods 4 through 10.
- Calculate the weighted moving average for periods 4 through 10, using weights of .65 .25, and .10, with 0.65 applied to the most recent data.
| Month | Demand |
| 1 | 55 |
| 2 | 61 |
| 3 | 71 |
| 4 | 77 |
| 5 | 88 |
| 6 | 100 |
| 7 | 109 |
| 8 | 122 |
| 9 | 126 |
| 10 | 126 |
- Calculate forecasting errors.
- Calculate the mean absolute deviation (MAD) for each forecasting procedure above.
- Calculate the cumulative sum of forecast error (CFE) for each forecasting procedure above.
- Which forecasting procedure would you select? Why?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
