11:08 Document (35) *** TABLE:3 22300 32000 4 1600 $ 2500 6 3500 7 3300 X 3200 to 4700 11 4100 12 400 13 a.. Calculate the forecast for the data using a four-year moving average b. Use the data to calculate the forecast for period 5 using a four-period weighted average moving average. The weights of 4, 3, 2, and I are assigned to the most recent second most recent, third most recent and the fourth most recent respectively c. Based on the data, calculate the forecast from period these using the exponential smoothing method. Assume the forecast for period two is 1600 and d. Use the data to estimate the linear trend forecast using the simple linear regression to calculate the trend line and the forecast for period 13 OR estimate the regression equation for period 13. NOTE!!! In this question, you are required to show all your calculations for each of the trendlines to enable you estimate or forecast the demand for period 13. 5 B1 U 11:08 Document (35) *** TABLE:3 22300 32000 4 1600 $ 2500 6 3500 7 3300 X 3200 to 4700 11 4100 12 400 13 a.. Calculate the forecast for the data using a four-year moving average b. Use the data to calculate the forecast for period 5 using a four-period weighted average moving average. The weights of 4, 3, 2, and I are assigned to the most recent second most recent, third most recent and the fourth most recent respectively c. Based on the data, calculate the forecast from period these using the exponential smoothing method. Assume the forecast for period two is 1600 and d. Use the data to estimate the linear trend forecast using the simple linear regression to calculate the trend line and the forecast for period 13 OR estimate the regression equation for period 13. NOTE!!! In this question, you are required to show all your calculations for each of the trendlines to enable you estimate or forecast the demand for period 13. 5 B1 U