Question

Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 120.0 and an alpha of 0.3. Second, calculate the three-period moving-average forecast for periods 4 through 10. Third, calculate the weighted moving average for periods 4 through 10, using weights of .60, .30, and .10. Calculate the mean absolute deviation (MAD) and the cumulative sum of forecast error (CFE) for each forecasting procedure. Which forecasting procedure would you select? Why?


Month Demand
1 120
2 115
3 125
4 119
5 127
6 114
7 120
8 124
9 116
10 137

Answer

This answer is hidden. It contains 270 characters.