A retail store records customer demand during each sales period. The data has been collected in th 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. Open spreadsheet 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. 3. Choose the correct graph for the three-period moving average forecast. The correct graph is A. B. The correct graph is A. B. C. D. 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. 6. Choose the correct graph for the four-period moving average forecast. The correct graph is Number B 10 v 0 fi B D m F G H K L M Use we are now ing average 3 Demand Forecast Error Error^2 Formulas N/A INA Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 #NA 92 91 86 87 97 93 87 91 94 94 90 94 #NA #N/A #NA #N/A #N/A #N/A #N/A #N/A #NA #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 priod forecast: MSE WN/A Use the area below to oving average 4 Demand Forecast Error Error2 Time Period 1 2 92 91 RA 2 Demand Forecast Error Error2 Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 92 91 86 87 97 93 87 91 94 94 90 94 F #N/A #N/A UNA #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 #NA #NA N/A Next period forecast: WNIA MSE NA Which moving average is best? WNIA