Question 7 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. Quarter 1 2 3 4 5 6 7 8 9 10 Demand 208 212 214 222 236 223 240 244 250 267 a. Calculate the simple two-month moving average forecast for the next quarters 11- 12. I b. Calculate the weighted two-month moving average using weights of 0.45,0.30, and 0.25 for the same period. c. Calculate the single exponential smoothing forecast for the next quarters 11-12 using an initial forecast of 208 with an initial o of 0.20 and o of 0.45. d. Calculate the forecast value using the trend projection method for the next quarters 11-12. e. Calculate the MAD for each forecast by each technique in quarters period 3-10. Which forecasting method would you suggest to your manager