- Question 3 Transcontinental Airlines Maintains A Computerized Forecasting System To Forecast The Number Of Customers In 1 (137.81 KiB) Viewed 22 times
Question 3 Transcontinental Airlines maintains a computerized forecasting system to forecast the number of customers in each fare class who will fly on each flight in order to allocate the available reservations to fare classes properly. For example, consider economy-class customers flying in midweek on the noon flight from New York to Los Angeles. The following table shows the average number of such passengers during each month of the year just completed. The table also shows the seasonal factor that has been assigned to each month based on historical data. Show all formulas and calculations. Month Average Seasonal Month Number Factor Average Seasonal Number Factor 68 71 January February March April May June 66 72 0,9 0,88 0,91 0,93 0,96 1,09 July 94 August 96 September 80 October 73 November 84 December 89 1,17 1,15 0,97 0,91 1,05 1,08 77 85 a. After considering seasonal effects, compare the MAD values for the last-value method, the averaging method, the moving average method (based on the most recent three months), and the exponential smoothing method (with an initial estimate of 80 and a smoothing constant of 0.2 when they are applied retrospectively to the past year. (15 Marks) b. Use the forecasting method with the smallest MAD value to forecast the average number of these passengers flying in January of the new year. (2 Marks)