Easy Air has put in place some very difficult or “stretch” goals for the upcoming year, as the table recreated from the chapter indicates.

REQUIRED:

a. Using the data above, as recreated for you in the Easy Air template titled DB 2.2, calculate the absolute (for example, actual size) of change in performance expected.

b. Now use your results from (a) to calculate the percentage change. Remember to use 20x6 as the denominator in your Excel equation. Turn in your completed worksheets and also answer the following two questions.

c. Do you think all of these planned results are attainable? Specifically, which ones do you think they can meet and which look di cult if not impossible to attain?

d. For those you feel are di cult to attain, please explain why you feel this way.

Transcribed Image Text:

Performance Indicator 20x7 Plan 20x6 Actuals Total fights flown 3,932,764 3,575,240 Total passengers flown 410,706.410 373,369,464 Total revenue seat miles flown in thousands) 62,566,454 54,405,612 Averoge miles per passenger flight 270 265 Total operating revenue (in thousands) $10,419,762.8 $9,303,359.7 Total operating expenses in thousands) $9,877,932.3 $8,899,038.1 Operating profit Gn thousands) $541,830.5 $404,321.6 Average revenue per revenue seat mile flown $0.167 $O.171 Averoge expense per revenue seat mile flown $0.158 $0.164 Averoge profit per revenue seat mile flown $0.009 $0.007 Averoge revenue per flight $2,649.48 $2,602.16 Averoge expense per flight $2,511.70 $2,489.07 Average profit per flight $137.77 $113.09 Averoge lood factor C% seats filed per flght) 85.70% 85.6% Averoge on-time performance rating 95% 8.5% Number of boggoge dlaims 187,650 250,200 Number of customer complaints 228,060 380,100 Number of ground/gate delays 2,280 3,800 Number of canceled flights 1,069 1,425