Forecasting Using Moving Average and Exponential Smoothing

Use the data in the Excel file to do the following:

1. Develop spreadsheet models for forecasting attendance using single moving average and single exponential smoothing.
2. Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing.

Instructions:

Write your answer in a Microsoft Excel document. Include the data set.

Criteria:

1. Forecasting model using single moving average,

2. Forecasting model using single exponential smoothing,

3. The best number of moving average periods,

4. The best smoothing constant for exponential smoothing