The monthly consumption of baby diapers in a maternity clinic is shown in file WB7.xlsx. Consumption has been recorded for the last 24 month.

Open the MS Excel file WB7.xlsx.
Add a column with a na?ve forecast for periods 5 through 24.
Add a column to show the forecasting error for periods 5 through 24.
Calculate the MSE for the na?ve forecast.
Add a column with the simple average forecast for periods 5 through 24.
Add a column to show the forecasting error for periods 5 through 24 for the simple average method.
Calculate the MSE for the simple average forecast.
Add a column and enter the three-period moving average corresponding to periods 5 through 24.
Add a column to show the forecasting error for periods 5 through 24 corresponding to the three-period moving average method.
Calculate the MSE for the moving average forecast.
Compare the accuracy of the three models.
Estimate the demand for baby diapers in the clinic for period 25 for each of the models.
Submit the Excel file with your calculations, along with a Word file with your comments as Assignment E-10.

The monthly consumption of baby diapers in a maternity clinic is shown in file WB7.xlsx. Consumption has been recorded for the last 24 month.

Open the MS Excel file WB7.xlsx.
Add a column with a na?ve forecast for periods 5 through 24.
Add a column to show the forecasting error for periods 5 through 24.
Calculate the MSE for the na?ve forecast.
Add a column with the simple average forecast for periods 5 through 24.
Add a column to show the forecasting error for periods 5 through 24 for the simple average method.
Calculate the MSE for the simple average forecast.
Add a column and enter the three-period moving average corresponding to periods 5 through 24.
Add a column to show the forecasting error for periods 5 through 24 corresponding to the three-period moving average method.
Calculate the MSE for the moving average forecast.
Compare the accuracy of the three models.
Estimate the demand for baby diapers in the clinic for period 25 for each of the models.
Submit the Excel file with your calculations, along with a Word file with your comments as Assignment E-10.