Question: Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (
Calculate the following forecasts using the data below.
- For periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.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 .70, .20, and .10, with 0.70 applied to the most recent data
- Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure would you select? Why?
| Month | Demand |
| 1 | 45 |
| 2 | 48 |
| 3 | 43 |
| 4 | 48 |
| 5 | 49 |
| 6 | 54 |
| 7 | 47 |
| 8 | 50 |
| 9 | 46 |
| 10 | 47 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
