Old MathJax webview

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) 4000 Jan 1 February 2 2900 March 3 3800 April 4 4000 May 5 3600 June 6 5400 II July 7 4300 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. Demand Data: Month Period Demand (Number of passengers) 4000 Jan 1 February 2 2900 March 3 3800 April 4 4000 May 5 3600 June 6 5400 July 7 4300 August 8 5600 September 9 5700