Year Forecast Actual Requirement 1 15010 17090 2 22045 22930 3 20580 19210 4 25620 24100...

Transcribed Image Text:

Year Forecast Actual Requirement 1 15010 17090 2 22045 22930 3 20580 19210 4 25620 24100 5 25070 23800 6 26090 21010 7 27030 22530 8 28010 17960 9 28005 17995 10 11 29333 19021 (1) What is the forecast requirement for next (ie., eleventh) year using a two-year and three-year simple moving average? Compute the MSE for each of those two moving averages and compare your results. (2) Using the same data table, find the best single exponential smoothing model by evaluating the MSE, starting with an alpha of 0.10 and changing alpha in increments of 0.10. How does the best single exponential smoothing model compare with the best moving average model you found in (1)? (3) If the DBS operations manager asked for your advice as to whether it is better to use regressionbased forecasting models or time-series forecasting models, what would your advice be and why? Year Forecast Actual Requirement 1 15010 17090 2 22045 22930 3 20580 19210 4 25620 24100 5 25070 23800 6 26090 21010 7 27030 22530 8 28010 17960 9 28005 17995 10 11 29333 19021 (1) What is the forecast requirement for next (ie., eleventh) year using a two-year and three-year simple moving average? Compute the MSE for each of those two moving averages and compare your results. (2) Using the same data table, find the best single exponential smoothing model by evaluating the MSE, starting with an alpha of 0.10 and changing alpha in increments of 0.10. How does the best single exponential smoothing model compare with the best moving average model you found in (1)? (3) If the DBS operations manager asked for your advice as to whether it is better to use regressionbased forecasting models or time-series forecasting models, what would your advice be and why?