Moving Average Forecasting Use the area below to draw a line chart for the three-period moving average. Darinde in main ARA 3 Name Box Demand Forecast Error Error2 Formulas Time Period 1 2 3 4 5 6 6 7 8 9 10 11 12 13 92 89 84 85 94 84 92 84 87 96 92 96 #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 Next period forecast: MSE #N/A Use the area below to draw a line chart for the four-period moving average. Periods in moving average 4 Demand Forecast Error Error2 Time Period 1 2 3 4 5 6 7 92 89 84 85 94 84 92 84 87 96 92 96 8 9 10 11 12 13 #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 Next period forecast: MSE #N/A Which moving average is best? #N/A FALI U MLUVY, MUVITY Average A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop three-period and four-period moving average forecasts and answer the following questions. ppen spreadsheet kuestions 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 b. Choose the correct graph for the three-period moving average forecast. The correct graph is Three-Period Moving Avenge Forest 100 Observation Forecast 90 RS 0 Time Period 5 9 10 11 12 13 14 The Period Morning Average or 100 Observation Forecast 95 90 B 85 80 The Period 2 7 12 13 100 Observation Forecast Three-Period Moving Average Pomcast Avenge 95 90 RS The Period 3 9 10 11 13 Observation Forecast 100 The Period Morning Avenge Forecast 95 90 basta D 85 0 Time Period 7 8 9 10 11 12 13 14 4. What is the forecast for the 13th perlod 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. -? . 6. Choose the correct graph for the four-period moving average forecast. The correct graph is Three Period Moving Aveage Pornost 100 Observation Forecast 95 90 90 A 85 80 Time Perdud 1 4 7 S 10 11 12 13 14 Observation Forecast Three Period Moving Average Porceast 100 95 90 B. 8S 80 Time Period 1 2 3 4 5 7 8 9 10 11 12 13 14 Three Perled Moving Average Forecast 100 Observation Forecast 95 90 C. 85 80 Time Period 1 2 3 4 5 7 9 10 11 12 13 100 Observation Forecast Three Period Moving Avenge Forecast 95 90 A D 85 80 Time Period 1 2 3 4 5 7 3 9 10 11 12 13 14 7. Which forecast is the best based on the MSE value