7. Problem - Forecast: Using the from the table below, Develop 3 different forecast models for Periods 4 through 9 a. Forecast # 1: Use 2 period moving average model forecast b. Forecast # 2: Use 3 period moving average model forecast c. Forecast # 3: Use Exponential Smoothing Forecasting model Calculate the MFE & MAD and APE for Periods 4 through 9 (n = 6) for all 3 Forecast. Show all your manual calculations and formulas on the last page. Demand Data: Month Period Demand Number of passengers) Jan 4000 February 2 2900 March 3 3800 April 4 4000 May 5 3600 June 6 5400 July 7 4300 August 8 5600 September 5700 a. 2-period moving average model forecast for Periods 4 through 9 Month Period Demand 2-period Forecast Absolute (APE) (passengers) forecast error deviation Absolute Percentage Error Jan February March April May June July August September Means: b. 3-period moving average model forecast for Periods 4 through 9 Month Period Demand 3-period Forecast Absolute (APE) (passengers) forecast error deviation Absolute Percentage Error JanAbsolute Percentage 0. Develop an Exponential Smoothing Forecasting model with 0'. = 0.35 for Periods 4 through 9. (n = 6) for the resulting forecast model. Assume your forecast for period 3 was 2800 (APE) Absolute Absolute Percentage Error 8. Compare all 3 forecast approaches and explain which model is the best alternative and why? Provide recommendations for the Airlines and explain how this forecast model can be integrated with the S&OP Process. Taking into consideration that the Airline Industry forecasted a 3.5% compound annual growth rate and Predicts 8.2 billion Air Travelers in 2037. Ianm.n+n-. ("l1 n D 41:11 rmrm