1. Develop a forecast with a three-period moving average and a four-period moving average. Identify which method is better by comparing MAD, MSE and MAPE.

2. Develop a forecast with a three-period weighted moving average and suggest the optimum weights for each period by using excel solver.

3. Identify the trend component and seasonal components of the data set using the appropriate method.

4. Develop a budget for 2012 and 2013 by using a forecast for attendance by analyzing the forecasts you developed in Question1 to question 3. Justify the selection of the method.

5. Develop an action plan for the school by analyzing all the options.