What is the forecast requirement for next (i.e., eleventh) year using a two-year, three-year and four-year simple moving average? Compute the MSE for each of those three moving averages and compare your results. Year Forecast 1 17180 2 22003 3 20510 4 23278 5 25782 6 26995 7 27345 8 28019 9 28763 10 29125 11 Actual Requirement 17900 20680 19956 19354 18765 18567 19231 19768 20093 20999 Using the same data table, find the best single exponential smoothing model by evaluating the MSE, starting with an alpha of 0.15 and changing alpha in increments of 0.15. How does the best single exponential smoothing model compare with the best moving average model you found in