Please do 5c, and show how you did it with the formulas, thank you.

B C D E F H - J L K M N O Q R S T 1 Problem 5 2 3 points 3 4 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. Month 5 1 2 3 6 7 8 9 10 11 12 4 5 Actual Demand 62 65 67 68 71 73 76 78 78 80 84 85 13 14 6 7 8 9 10 11 12 15 16 17 18 19 20 21 22 23 24 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.5, 0.3, and 0.2 for periods 4-12. c) Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 4-12. Which forecasting method would be preferable