Question 5 Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following for at undefy what pricedure you would utilize a Calculate the simple three month moving average forecast for periods 4 to 12. Calculate the weighted three-month moving average using weights of 0.50, 0.30, and 0.20 for periods 4 to 12. c. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 4 to 12. Which forecasting method do you prefer? Month Actual Demand 62 65 Actual Demand Month 7 1 2 76 8 78 78 3 4 67 68 71 73 9 10 11 80 84 5 6 12 85 ** Arial 3 (120) : T. - 1E- MacBook Air BO GOD F4 73 F2 FI A & * 7 V 8 N99 % 5 # D A 6 7 @ P { 0