1 of 2 1. The total air carrier passenger traffic between two airports from 2000 to 2020 is given in Table 1. A new carrier began service in the first quarter of 2018 between the two airports and has been steadily increasing its share of the market, as shown in Table 2. Table 1: # of Passengers Table 2: % for the new airline Year Passengers Year Quarter Percentage 1999 465,000 of total 2004 528,000 passengers 2009 561.000 2018 1 quarter 1.12 2014 601,000 2nd quarter 2.02 2019 624,000 3rd quarter 3.25 4th quarter 7.00 2019 1 quarter 10.30 2nd quarter 11.75 3rd quarter 14.25 4th quarter | 17.02 2020 | 15 quarter | 17.95 2nd quarter 18.10 3rd quarter 18.60 4th quarter 18.70 a. Using time series analysis, determine the total market share which the new airline may hope to capture, assuming all services to remain the same. (Hint: use the percentage vs. month chart to estimate the percentage). b. Using the results of part "a" and econometric analysis, determine the total ne may expect to serve in 2025. (Hint: develop the linear relationship between the number of passengers in thousands) and the year). c. If an average load factor (occupancy) of 0.43 is required to cover costs and there are 19 trips (total for all airlines) per day with an average passenger capacity of 215, determine whether route is profitable to all airlines collectively in year 2020 and for the new airline if it offers 4 trips per day? 1 of 2 1. The total air carrier passenger traffic between two airports from 2000 to 2020 is given in Table 1. A new carrier began service in the first quarter of 2018 between the two airports and has been steadily increasing its share of the market, as shown in Table 2. Table 1: # of Passengers Table 2: % for the new airline Year Passengers Year Quarter Percentage 1999 465,000 of total 2004 528,000 passengers 2009 561.000 2018 1 quarter 1.12 2014 601,000 2nd quarter 2.02 2019 624,000 3rd quarter 3.25 4th quarter 7.00 2019 1 quarter 10.30 2nd quarter 11.75 3rd quarter 14.25 4th quarter | 17.02 2020 | 15 quarter | 17.95 2nd quarter 18.10 3rd quarter 18.60 4th quarter 18.70 a. Using time series analysis, determine the total market share which the new airline may hope to capture, assuming all services to remain the same. (Hint: use the percentage vs. month chart to estimate the percentage). b. Using the results of part "a" and econometric analysis, determine the total ne may expect to serve in 2025. (Hint: develop the linear relationship between the number of passengers in thousands) and the year). c. If an average load factor (occupancy) of 0.43 is required to cover costs and there are 19 trips (total for all airlines) per day with an average passenger capacity of 215, determine whether route is profitable to all airlines collectively in year 2020 and for the new airline if it offers 4 trips per day