Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. - PLEASE show all work in Excel including formulas.

a. Calculate the simple three-month moving average forecast for periods 4-12.

b. Calculate the weighted three-month moving average using weights of 0.50, 0.30, and 0.20 for periods 4-12.

c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F1) of 61 and an "a" of 0.30.

e. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 4-12. Which forecasting method do you prefer?

Month 1 - Actual Demand 62

Month 2 - " " " 65

Month 3 - 67

Month 4 - 68

Month 5 - 71

Month 6 - 73

Month 7 - 76

Month 8 - 78

Month 9 - 78

Month 10 - 80

Month 11 - 84

Month 12 - 85