Assignment(Compability Mode - Word Search Layout References Mailings Review View Help ab AaBb AaBbce Aabel AmBel Aabbel Aa EmTeaching Heading 2 THending Normal Strong Xx-A She Q2. Total 50 points) Support you (or your group) are the manager of a company trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecasts for ench given forecasting method and then choose the best one to do the forecast for the future Actual Meth Demand 1 2 3 63 65 68 0 72 55 Calculate the simple 3-month moving average forecast for periode 1-6 (5 points) Calculate the weighted 3-month moving average using weights of 0.50 0.30. and 0.20 for period 4-6. (5 points) Calculate the exponential moothing forecast for periods 2-6 ring an initial forecast (F) 62, and an of 0.30. (10 points) Calculate the double exponential moothing forecast for periods 3-6 using an initial trend forecast (T) of 2.0, and initial exponential smoothing forecast (S.) of 60 of 0.30 ud a of 0.30 (15 points) Calculate the Mean Absolute Deviation (MAD) for the forecasts made by each technique in periodi 1-6. Which forecasting method do you prefer? Using your preferred technique forecast the demand for the following 2 months (months 7-8) (15 points) o E a