Show transcribed image text 100% (1 rating)3-period moving average forecast Ft 3 = (Ft Ft 1 Ft 2)/3 MSE = (1/N)*Σ(At-Ft)2 where N = 9 in this scenario. Q1) Forecast for period 13 = 90.33 (from below table) Q2) MSE = 27.26 (from below table) Month Dem…View the full answerTranscribed image text: Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places. 2. What is the MSE for the three-period moving average? Round your answer to two decimal places. 4. What is the forecast for the 13th period based on the four-period moving average? Round your answer to two decimal places. 5. What is the MSE for the four-period moving average? Round your answer to two decimal places. Moving Average Forecasting Periods in moving average Next period forecast: Time Period 1234567 8 9 10 11 12 13 3 Demand Forecast Error Error^2 MSE 88 85 80 81 92 83 85 84 87 89 85 97 Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A ▼ #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Use the area below to draw a line chart for the three-period moving average. Periods in moving average Next period forecast: 4 Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 Which moving average is best? Demand Forecast Error MSE 88 85 80 81 92 83 85 84 87 89 85 97 Error^2 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
