Question 2 - Forecasting (10 points] In a local travel agency, monthly sales of vacation packages are given as in the table below. The company asked you to suggest a forecasting technique that best suits their data. Month Sales MA WMA ES MA WMA ES Deviation Deviation Deviation 1 340 2 320 3 270 310 4 5 250 6 270 7 290 MAD MAPE a) [2 Points] Calculate forecast values for months 3 through 7 using a 2-months moving average. (Provide using the column MA in the table above and round to the nearest whole number) b) [2 points) Calculate forecast values for months 3 through 7 using a 2-months weighted moving average with weights 0.7 and 0.3, highest weight is for the most recent month. (Provide using the column WMA in the table above and round to the nearest whole number) c) [2 points) Calculate forecast values for months 2 through 7 using the exponential smoothing method with a smoothing constant of 0.3 and forecast of 150 units for month 1. (Provide using the column ES in the table above and round to the nearest whole number) d) 3 points) Calculate the Mean Absolute Deviation (MAD) and the Mean Absolute Percent Error (MAPE) for the three forecasting techniques based on months 3 through 7. (Provide using the last three columns and last two rows in the table above. Round MAD and MAPE to one decima place) e) [1 point] Which technique would you recommend to the travel agency and why