Midwest Airlines Employee Data and Analysis
Midwest Airlines
  1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009
Traffic Indicies  
Stage Length in Miles (for SLA purposes)                691               731               707               737               770               778               780               782               802               879               879               885               944               946               632
Seats Per Departure (for SDA purposes)                79                77                80                82                86                88                91                93               100               109               106               104               104               105                89
Price Per Gallon of Fuel  $          0.54  $          0.65  $          0.62  $          0.44  $          0.50  $          0.89  $          0.82  $          0.71  $          0.88  $          1.16  $          1.71  $          1.99  $          1.84  $          3.16  $          1.73
Airborne Hours / Block Hours 86% 86% 86% 86% 84% 85% 88% 89% 88% 87% 87% 87% 88% 81% 27%
Outsourcing Indicies  
Maintenance $'s Outsourced 34.1% 40.7% 38.7% 42.7% 55.3% 44.5% 37.2% 28.7% 21.1% 31.2% 53.1% 55.1% 69.7% 39.4% 5.3%
Other Outsourcing as % of  Total Exp. (ex-Fuel) 12.0% 10.5% 8.7% 8.1% 7.2% 8.6% 8.7% 9.1% 11.0% 10.3% 10.9% 12.0% 12.8% 8.6% 10.9%
Transport Related Expense (000)  $           734  $           118  $           108  $             83  $           139  $           120  $           158  $           209  $           405  $           281  $           342  $           894  $      62,496  $     181,186  $     162,334
Productivity Measures (unadjusted)  
Block Hours Per Employee Per Month
Pilots & Co-Pilots (note: Includes Flight Engineers where applicable)              66.6              51.2              54.7                 -                47.9              47.7              54.5              45.5              46.6              48.2              52.2              56.2              55.3              43.7              25.9
Flight Attendants (note: Avg Crew = 1 FA per 50 seats)              34.0              32.7              36.6                 -                38.0              32.1              41.4              38.8              41.2              44.5              47.2              50.2              48.2              41.5              20.3
Maintenance              34.2              36.3              33.3                 -                23.2              15.8              16.3              16.8              24.1              22.6              47.5              53.6              52.4              41.1              55.2
Passenger, Cargo and Aircraft Handling               8.7               9.0               8.2                 -                 9.3              11.7              11.4              11.0               9.4               8.8              11.2              15.3               8.5               9.9                 -  
Other              23.2              24.1              21.9                 -                25.5              13.6              15.6              15.7              22.5              26.7              37.0              34.7              31.1              27.2         1,656.1
Total               3.7               3.7               3.5                 -                 3.4               3.1               3.3               3.2               3.4               3.4               4.4               5.2               4.0               3.8               5.4
ASMs Per Employee (000)
Pilots & Co-Pilots       11,625.4         8,881.4         9,505.6                 -           8,881.0         9,031.4       10,886.3         9,428.5       10,452.6       11,899.1       12,799.0       13,400.1       13,391.7       10,286.3         4,396.8
Flight Attendants         7,511.0         7,401.1         7,977.9                 -           8,227.6         6,885.7         9,133.4         8,664.0         9,241.6       10,124.1       10,858.8       11,564.5       11,186.9         9,353.3         3,902.9
Maintenance       11,929.3       12,568.0       11,574.2                 -           8,602.7         5,992.6         6,518.6         6,968.9       10,787.4       11,173.6       23,252.6       25,582.0       25,363.9       19,365.3       18,759.8
Passenger, Cargo and Aircraft Handling         3,042.0         3,117.5         2,838.4                 -           3,435.2         4,440.2         4,547.4         4,573.0         4,227.7         4,332.1         5,476.3         7,298.6         4,104.4         4,645.1                 -  
Other         8,111.9         8,361.1         7,598.0                 -           9,436.0         5,150.4         6,229.7         6,502.4       10,070.6       13,183.2       18,127.5       16,553.1       15,038.2       12,810.0      562,793.6
Total         1,302.8         1,266.4         1,203.6                 -           1,245.7         1,155.1         1,321.3         1,315.4         1,545.0         1,690.5         2,157.0         2,467.2         1,919.1         1,774.1         1,833.2
Employees Per Aircraft
Pilots & Co-Pilots (Crews)               4.0               5.6               5.1                 -                 5.7               5.4               4.3               5.0               4.8               5.4               5.4               5.3               5.5               6.4              48.2
Flight Attendants (Crews)               7.8               8.7               7.7                 -                 7.2               8.0               5.7               5.8               5.5               5.9               6.0               5.9               6.4               6.7              61.4
Maintenance (Inhouse)               7.7               7.9               8.4                 -                11.8              16.3              14.4              13.5               9.4              11.5               6.0               5.5               5.9               6.8              22.6
Passenger, Cargo and Aircraft Handling (Inhouse)              30.3              31.8              34.3                 -                29.5              22.0              20.7              20.5              24.0              29.7              25.4              19.4              36.2              28.3                 -  
Other (Inhouse)              11.4              11.8              12.8                 -                10.7              19.0              15.1              14.4              10.1               9.8               7.7               8.6               9.9              10.3               0.8
Total              70.7              78.2              80.9                 -                81.3              84.6              71.2              71.3              65.6              76.1              64.4              57.4              77.4              74.0            231.3
Passengers Per Employee
Pilots & Co-Pilots            9,060            6,738            7,130                 -              6,495            6,259            7,416            6,440            7,347            7,715            9,256          10,302            9,854            7,496            5,032
Flight Attendants            5,854            5,615            5,984                 -              6,017            4,772            6,222            5,918            6,496            6,564            7,853            8,891            8,232            6,816            4,467
Maintenance            9,297            9,534            8,682                 -              6,291            4,153            4,441            4,760            7,582            7,245          16,815          19,667          18,664          14,111          21,471
Passenger, Cargo and Aircraft Handling            2,371            2,365            2,129                 -              2,512            3,077            3,098            3,124            2,972            2,809            3,960            5,611            3,020            3,385                 -  
Other            6,322            6,343            5,699                 -              6,901            3,570            4,244            4,442            7,079            8,548          13,109          12,726          11,066            9,335        644,143
Total            1,015               961               903                 -                 911               801               900               899            1,086            1,096            1,560            1,897            1,412            1,293            2,098
Productivity Measures Revenue  
Passenger Revenue Per Employee (000)
Pilots & Co-Pilots  $     1,306.8  $     1,063.0  $     1,160.8  $             -    $     1,065.6  $     1,077.6  $     1,168.7  $        898.5  $        896.9  $        906.4  $     1,073.0  $     1,301.1  $     1,283.4  $     1,040.6  $        152.1
Flight Attendants  $        844.3  $        885.8  $        974.2  $             -    $        987.2  $        821.6  $        980.5  $        825.7  $        793.0  $        771.2  $        910.3  $     1,122.9  $     1,072.1  $        946.2  $        135.0
Maintenance  $     1,341.0  $     1,504.2  $     1,413.4  $             -    $     1,032.2  $        715.0  $        699.8  $        664.1  $        925.7  $        851.1  $     1,949.3  $     2,483.9  $     2,430.7  $     1,959.1  $        649.0
Passenger, Cargo and Aircraft Handling  $        341.9  $        373.1  $        346.6  $             -    $        412.2  $        529.8  $        488.2  $        435.8  $        362.8  $        330.0  $        459.1  $        708.7  $        393.3  $        469.9  $             -  
Other  $        911.8  $     1,000.7  $        927.8  $             -    $     1,132.1  $        614.5  $        668.8  $        619.7  $        864.2  $     1,004.2  $     1,519.7  $     1,607.3  $     1,441.2  $     1,295.9  $    19,470.8
Total  $        146.4  $        151.6  $        147.0  $             -    $        149.5  $        137.8  $        141.8  $        125.4  $        132.6  $        128.8  $        180.8  $        239.6  $        183.9  $        179.5  $          63.4
Salary and Benefits  
Average Salary
Management and All Other  $      36,836  $      50,755  $      49,437  $             -    $      46,433  $      30,430  $      38,052  $      36,822  $      48,982  $      58,620  $      60,809  $      60,165  $      59,500  $      63,296  $     483,091
Pilots & Co-Pilots  $      85,197  $      72,677  $      83,059  $             -    $      74,548  $      94,373  $     125,002  $     104,213  $     115,512  $     107,474  $     101,895  $      93,052  $      88,785  $      85,591  $      15,424
Flight Attendants  $      25,032  $      25,957  $      29,436  $             -    $      30,956  $      27,805  $      38,454  $      34,681  $      32,311  $      28,869  $      31,871  $      33,080  $      30,774  $      28,507  $        5,363
Maintenance  $      33,084  $      29,060  $      35,254  $             -    $      28,831  $      26,303  $      40,428  $      44,871  $      55,650  $      46,262  $      55,026  $      46,521  $      38,807  $      30,813  $        9,301
Passenger, Cargo and Aircraft Handling  $      23,557  $      25,474  $      25,070  $             -    $      29,397  $      41,135  $      36,331  $      33,604  $      28,071  $      24,130  $      26,229  $      31,106  $      17,964  $      22,717  $             -  
Total  $      34,111  $      37,182  $      38,870  $             -    $      39,307  $      40,157  $      48,785  $      46,493  $      49,342  $      45,264  $      47,828  $      49,303  $      37,782  $      42,068  $      24,080
Other Compensation Per Employee (All Employees)
Benefits, Pensions and Payroll Taxes
Pilots & Co-Pilots  $      12,480  $      11,511  $      14,452  $             -    $      12,620  $      17,888  $      25,024  $      20,704  $      24,688  $      24,966  $      21,988  $      16,958  $      17,769  $      18,840  $        3,508
All Others  $        3,076  $        4,166  $        3,964  $             -    $        7,180  $        7,992  $      10,496  $        9,265  $      10,047  $        9,785  $        9,791  $      13,256  $      10,006  $        9,521  $      12,645
Total  $        4,130  $        5,214  $        5,292  $             -    $        7,943  $        9,258  $      12,259  $      10,861  $      12,211  $      11,942  $      11,847  $      13,938  $      11,119  $      11,129  $        8,835
Personnel
Pilots & Co-Pilots  $        3,438  $        3,757  $        4,288  $             -    $        4,338  $        4,852  $        7,064  $        5,100  $        4,297  $        4,069  $        5,470  $        8,249  $        8,863  $        6,923  $        1,074
Flight Attendents  $        8,717  $      11,650  $      11,764  $             -    $      10,949  $        9,402  $      12,066  $      10,549  $        9,765  $        8,775  $        7,310  $        8,765  $        9,688  $        7,916  $        1,331
Payroll Taxes
Pilots & Co-Pilots  $        8,692  $        6,241  $        5,910  $             -    $        6,778  $        7,463  $        9,018  $        8,161  $        9,020  $        8,532  $        8,426  $        8,597  $        8,338  $        8,004  $        1,677
All Others  $        2,610  $        2,539  $        2,501  $             -    $        1,375  $              0  $             (0)  $            (93)  $             -    $             -    $             -    $              5  $             (0)  $             (0)  $             -  
Raw Data  
Number of Months 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12
Number of Days 365 366 365 365 365 366 365 365 365 366 365 365 365 365 365
P10- Employee Count Data  
Sum of General Management                23                44                67                 167                75                79                73                45                46                56                39                41                60                19
Sum of Pilots and Co-Pilots               157               225               235                 340               353               297               340               290               308               347               378               411               401               640
Sum of Other Flight Personnel                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Passenger and General Services               243               270               280                 367               463               354               370               328               362               409               438               492               441               721
Sum of Maintenance               153               159               193                 351               532               496               460               281               328               191               198               217               213               150
Sum of AC Handling 1                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Aircraft Handling               184                66                77                 212                  8                47                77                82                83                36                32                52                31                 -  
Sum of Aircraft Control                22                20                19                  47                44                38                40                35                36                41                43                57                 -                   -  
Sum of Passenger Handling               372               533               663                 585               525               590               551               570               698               698               593            1,201               833                 -  
Sum of Cargo Handling                22                22                28                  35               141                36                33                30                29                36                26                31                24                 -  
Sum of Trainees and Instructors                17                22                25                  15                55                42                34                37                37                22                45                46                27                  4
Sum of Stats                95                96               113                 125               110                85                90                86                74                65                86               106                92                  1
Sum of Traffic Solicitors                33                30                34                  42               106                94                94                51                46                33                31                31                30                 -  
Sum of Other                80                91               122                 138               348               298               275               127               121               125               144               183               173                 -  
Sum of Transport Related                 -                   -                   -                     -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Total            1,401            1,578            1,856            2,424            2,760            2,447            2,437            1,962            2,168            2,059            2,053            2,868            2,325            1,535
P6- Objective Grouping Operating Expense Data  
Sum of Salaries-General Management Personnel (000)  $        3,837  $        7,359  $        9,851  $      15,260  $      11,913  $        9,069  $        9,911  $        9,236  $        7,587  $      10,147  $        9,285  $        9,496  $        9,336  $        8,565  $        4,306
Sum of Salaries-Flight Personnel (000)  $      19,459  $      23,361  $      27,761  $      31,271  $      36,707  $      46,187  $      50,738  $      48,264  $      44,097  $      43,553  $      48,393  $      49,663  $      51,632  $      46,894  $      13,739
Sum of Salaries-Maintenance Labor (000)  $        5,062  $        4,621  $        6,804  $        8,071  $      10,120  $      13,993  $      20,053  $      20,641  $      15,638  $      15,174  $      10,510  $        9,211  $        8,421  $        6,563  $        1,395
Sum of Salaries-Aircraft And Traffic Handling Personnel (000)  $      14,134  $      16,329  $      19,730  $      23,099  $      25,840  $      29,535  $      25,832  $      23,556  $      20,127  $      20,414  $      21,272  $      21,587  $      24,090  $      20,173  $      10,234
Sum of Salaries-Other Personnel (000)  $        5,299  $        7,005  $        7,995  $        9,164  $      10,700  $      12,050  $      12,844  $      11,606  $        9,361  $        8,846  $        9,019  $      11,261  $      14,881  $      15,614  $        7,289
Sum of Salaries-Total (000)  $      47,790  $      58,674  $      72,142  $      86,865  $      95,279  $     110,834  $     119,377  $     113,303  $      96,809  $      98,133  $      98,478  $     101,218  $     108,359  $      97,809  $      36,962
Sum of Related Fringe Benefits-Personnel Expense (000)  $        2,658  $        3,991  $        4,301  $        4,725  $        5,493  $        6,066  $        6,369  $        5,637  $        4,449  $        4,430  $        4,888  $        6,957  $        8,409  $        6,267  $        1,648
Sum of Related Fringe Benefits-Employee Benefits And Pensions (000)  $        5,786  $        8,227  $        9,822  $      11,392  $      19,253  $      25,552  $      29,998  $      26,468  $      23,958  $      25,890  $      24,392  $      28,614  $      31,888  $      25,874  $      13,562
Sum of Related Fringe Benefits-Payroll Taxes (000)  $        4,611  $        4,839  $        5,443  $        7,570  $        5,171  $        2,635  $        2,678  $        2,579  $        2,616  $        2,628  $        2,924  $        3,258  $        3,427  $        3,210  $        1,073
Sum of Related Fringe Benefits-Total (000)  $      13,055  $      17,057  $      19,566  $      23,687  $      29,917  $      34,253  $      39,045  $      34,684  $      31,023  $      32,948  $      32,204  $      38,829  $      43,724  $      32,973  $      16,283
Sum of Total Salaries And Related Fringe Benefits (000)  $      60,845  $      75,730  $      91,708  $     110,552  $     125,197  $     145,086  $     158,423  $     147,987  $     127,832  $     131,081  $     130,682  $     140,047  $     152,083  $     130,782  $      53,245
Sum of Services Purchased-Advertising And Other Promotions (000)  $        7,414  $        6,586  $        6,495  $        6,716  $        7,500  $        9,052  $        8,872  $        9,657  $        8,924  $      10,531  $      10,985  $      11,382  $      11,129  $      10,786  $        6,013
Sum of Services Purchased-Communication (000)  $        2,070  $        2,252  $        3,045  $        3,460  $        3,704  $        3,624  $        3,800  $        3,217  $        2,982  $        3,050  $        3,988  $        4,215  $        4,389  $        4,400  $        2,829
Sum of Services Purchased-Insurance (000)  $        2,386  $        2,865  $        2,799  $        2,263  $        2,090  $        2,082  $        2,638  $        6,561  $        4,794  $        4,818  $        4,965  $        5,555  $        4,748  $        2,618  $        1,136
Sum of Services Purchased-Outside Flight Equipment Maintenance (000)  $        6,431  $        9,084  $      12,142  $      18,399  $      27,207  $      25,028  $      19,977  $      10,225  $        5,645  $      10,464  $      18,743  $      18,065  $      29,637  $      12,800  $           661
Sum of Services Purchased-Traffic Commissions -Passenger (000)  $      16,520  $      21,956  $      27,665  $      26,500  $      26,844  $      22,321  $      20,150  $      15,327  $        9,375  $        8,660  $      11,718  $      15,882  $      18,161  $      15,619  $        4,102
Sum of Services Purchased-Traffic Commissions-Cargo (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Sum of Services Purchased-Other Services (000)  $      20,573  $      21,303  $      20,208  $      21,536  $      22,166  $      29,080  $      30,713  $      28,866  $      30,526  $      30,694  $      36,359  $      45,276  $      61,977  $      74,740  $      32,846
Sum of Services Purchased-Total (000)  $      55,395  $      64,045  $      72,354  $      78,874  $      89,512  $      91,186  $      86,150  $      73,852  $      62,247  $      68,217  $      86,758  $     100,375  $     130,041  $     120,963  $      47,587
Sum of Transport Related Expense (000) 734.02 117.91 108.01 83.45 139.28 120.05 157.98 208.62 405.35 280.69 342.19 893.62 62496.46 181185.64 162334.12
Sum of Total Operating Expense (000)  $     198,960  $     239,157  $     271,893  $     298,772  $     347,045  $     414,011  $     418,617  $     375,677  $     338,189  $     381,348  $     477,156  $     568,202  $     675,513  $  1,110,860  $     333,204
T1 & T2- Traffic Data  
Sum of RPMs 1.17E+09 1.26E+09 1.42E+09 1.63E+09 1.97E+09 1.98E+09 1.97E+09 1.97E+09 1.99E+09 2.38E+09 3.15E+09 3.84E+09 4.23E+09 3.13E+09 2.20E+09
Sum of ASMs 1.83E+09 2.00E+09 2.23E+09 2.51E+09 3.02E+09 3.19E+09 3.23E+09 3.21E+09 3.03E+09 3.66E+09 4.44E+09 5.07E+09 5.50E+09 4.12E+09 2.81E+09
Sum of Miles 2.31E+07 2.61E+07 2.80E+07 3.08E+07 3.53E+07 3.61E+07 3.57E+07 3.46E+07 3.04E+07 3.38E+07 4.17E+07 4.89E+07 5.28E+07 3.95E+07 3.18E+07
Sum of Depts          33,446          35,678          39,590          41,826          45,824          46,451          45,782          44,248          37,883          38,423          47,465          55,225          55,905          41,700          50,318
Sum of Airborne Hours          54,102          59,304          66,503          72,660          82,416          85,400          85,287          82,362          71,098          77,366          94,985        111,143        119,534          85,182          26,603
Sum of Block Hours          62,757          69,177          77,174          84,380          97,736        101,027          97,183          92,878          81,145          89,094        108,783        127,416        136,459        105,096          99,364
Sum of AC Days            7,235            7,388            8,370            8,915          10,878          11,938          12,547          12,476          10,919          10,425          11,677          13,050          13,523          11,463            2,422
Sum of Gallons 5.12E+07 5.61E+07 6.32E+07 7.26E+07 8.07E+07 8.47E+07 8.23E+07 8.14E+07 6.80E+07 7.09E+07 8.34E+07 9.62E+07 1.04E+08 7.67E+07 1.80E+07
Sum of Passengers      1,422,405      1,515,953      1,675,633      1,896,606      2,208,196      2,209,568      2,202,652      2,189,711      2,130,669      2,376,304      3,211,717      3,894,069      4,049,994      3,005,711      3,220,715
P12- Profit and Loss Statement  
Sum of Pax Rev (000) -2.05E+05 -2.39E+05 -2.73E+05 -3.12E+05 -3.62E+05 -3.80E+05 -3.47E+05 -3.06E+05 -2.60E+05 -2.79E+05 -3.72E+05 -4.92E+05 -5.27E+05 -4.17E+05 -9.74E+04
Sum of Charter Pax (000)  $       (3,744)  $       (5,955)  $       (7,142)  $       (5,122)  $       (4,800)  $       (5,971)  $       (7,208)  $     (11,858)  $     (15,534)  $     (18,079)  $     (12,841)  $     (14,495)  $     (13,734)  $     (17,723)  $            (71)
Sum of Transport Related Rev (000)  $       (7,002)  $     (10,443)  $     (14,471)  $     (17,533)  $     (21,418)  $     (17,769)  $     (21,548)  $     (27,106)  $     (29,540)  $     (29,768)  $     (34,922)  $     (38,512)  $    (100,656)  $    (187,160)  $    (177,360)
Sum of Cargo Rev (000)  $       (2,995)  $       (3,272)  $       (3,574)  $       (3,895)  $       (4,231)  $       (3,852)  $       (2,916)  $       (2,689)  $       (2,521)  $       (2,517)  $       (3,430)  $       (4,339)  $       (4,388)  $       (7,006)  $     (15,830)
Sum of Total Rev (000) -2.29E+05 -2.71E+05 -3.10E+05 -3.51E+05 -4.06E+05 -4.25E+05 -3.95E+05 -3.59E+05 -3.19E+05 -3.43E+05 -4.39E+05 -5.72E+05 -6.73E+05 -6.53E+05 -3.02E+05
P52- Functional Grouping Operating Expense Data  
Sum of Pilots And Copilots (000)  $      13,376  $      16,352  $      19,519  $      21,731  $      25,346  $      33,314  $      37,125  $      35,432  $      33,498  $      33,102  $      35,202  $      34,659  $      36,491  $      34,322  $        9,872
Sum of Other Flight Personnel (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $           156  $           515  $             -    $             -    $             -  
Sum of Trainees And Instructors (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $           769  $        1,773  $        2,703  $        2,755  $           985
Sum of Personnel Expenses (000)  $           540  $           845  $        1,008  $        1,150  $        1,475  $        1,713  $        2,098  $        1,734  $        1,246  $        1,253  $        1,898  $        3,118  $        3,643  $        2,776  $           688
Sum of Employee Benefits And Pensions (000)  $        1,959  $        2,590  $        3,396  $        3,276  $        4,291  $        6,314  $        7,432  $        7,039  $        7,160  $        7,690  $        7,630  $        6,410  $        7,303  $        7,555  $        2,245
Sum of Taxes-Payroll (000)  $        1,365  $        1,404  $        1,389  $        2,128  $        2,305  $        2,635  $        2,678  $        2,775  $        2,616  $        2,628  $        2,924  $        3,250  $        3,427  $        3,210  $        1,073
Sum of Total Flight Equipment Maintenance (Memo) (000)  $      18,851  $      22,343  $      31,387  $      43,124  $      49,188  $      56,239  $      53,656  $      35,605  $      26,750  $      33,538  $      35,283  $      32,805  $      42,518  $      32,465  $      12,539
Sum of Flying Operations-Aircraft Fuels (000)  $      27,650  $      36,291  $      38,913  $      32,265  $      40,538  $      75,217  $      67,222  $      58,003  $      59,539  $      82,469  $     142,736  $     191,130  $     191,621  $     242,538  $      31,227