Employee Data and Analysis
Northwest Airlines
  1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007
Traffic Indicies  
Stage Length in Miles (for SLA purposes)                846               862               882               899               905               914               928               921               915               925               961               978            1,003
Seats Per Departure (for SDA purposes)               183               186               188               188               188               189               184               179               176               176               178               179               184
Price Per Gallon of Fuel  $          0.56  $          0.67  $          0.65  $          0.54  $          0.54  $          0.83  $          0.79  $          0.70  $          0.81  $          1.18  $          1.69  $          2.03  $          2.05
Airborne Hours / Block Hours 84% 84% 84% 83% 83% 83% 83% 84% 84% 84% 84% 84% 83%
Outsourcing Indicies  
Maintenance $'s Outsourced 18.5% 22.1% 24.0% 26.6% 26.4% 24.4% 28.0% 27.5% 36.7% 34.9% 56.8% 72.0% 73.6%
Other Outsourcing as % of  Total Exp. (ex-Fuel) 9.7% 9.8% 10.5% 10.3% 11.0% 11.2% 10.4% 10.2% 10.7% 9.6% 11.1% 12.2% 14.0%
Transport Related Expense (000)  $     102,213  $     100,103  $     100,762  $      64,062  $      77,747  $     112,373  $     146,619  $     163,150  $     185,645  $  1,430,601  $  1,894,571  $  1,625,788  $  1,539,975
Productivity Measures (unadjusted)  
Block Hours Per Employee Per Month
Pilots & Co-Pilots (note: Includes Flight Engineers where applicable)              43.9              43.7              42.9              42.4              41.1              41.4              39.5              42.4              44.3              47.3              46.1              47.1              48.9
Flight Attendants (note: Avg Crew = 1 FA per 50 seats)              45.2              45.4              45.3              40.9              44.1              43.6              42.8              45.6              47.4              47.5              46.3              48.6              50.8
Maintenance              23.1              23.5              21.3              17.7              19.8              21.2              22.2              24.8              38.2              46.2              78.9            399.7            400.6
Passenger, Cargo and Aircraft Handling               6.0               5.9               6.0               5.4               5.8               5.9               5.9               6.3               6.5               7.0               7.6               8.2               8.8
Other              15.1              15.6              15.6              14.3              15.2              15.4              15.9              18.0              19.2              21.7              21.2              21.1              20.1
Total               2.5               2.5               2.5               2.2               2.4               2.4               2.4               2.6               2.8               3.0               3.2               3.5               3.6
ASMs Per Employee (000)
Pilots & Co-Pilots       17,881.4       18,105.4       17,967.8       17,752.7       17,103.2       17,309.3       16,150.2       16,910.6       17,425.1       18,516.9       18,401.5       18,917.7       19,882.6
Flight Attendants       10,070.4       10,104.4       10,068.6         9,071.8         9,741.2         9,627.7         9,511.2       10,124.8       10,600.6       10,596.4       10,374.2       10,892.9       11,235.8
Maintenance       18,850.3       19,442.0       17,829.3       14,799.2       16,491.4       17,690.9       18,105.2       19,772.5       30,032.8       36,155.8       62,955.7      321,034.0      325,624.9
Passenger, Cargo and Aircraft Handling         4,860.7         4,925.7         5,036.6         4,538.8         4,827.4         4,967.2         4,841.3         5,019.2         5,146.3         5,494.1         6,045.5         6,615.9         7,186.1
Other       12,273.9       12,936.3       13,024.8       11,956.6       12,633.2       12,886.1       13,001.5       14,373.1       15,108.1       16,962.1       16,949.2       16,926.6       16,327.5
Total         2,011.7         2,054.8         2,052.3         1,855.1         1,964.4         2,008.2         1,974.8         2,092.7         2,241.9         2,379.7         2,554.3         2,789.4         2,913.4
Employees Per Aircraft
Pilots & Co-Pilots (Crews)               6.6               6.6               6.8               6.3               7.0               7.1               7.0               6.2               6.0               5.7               5.9               6.1               5.9
Flight Attendants (Crews)               6.4               6.4               6.4               6.5               6.6               6.8               6.5               5.8               5.6               5.7               5.9               5.9               5.6
Maintenance (Inhouse)              12.6              12.3              13.7              15.0              14.6              13.9              12.5              10.7               6.9               5.8               3.5               0.7               0.7
Passenger, Cargo and Aircraft Handling (Inhouse)              48.7              48.7              48.3              48.9              49.8              49.6              46.8              42.0              40.3              38.4              36.2              34.7              32.4
Other (Inhouse)              19.3              18.6              18.7              18.6              19.0              19.1              17.4              14.7              13.7              12.4              12.9              13.6              14.3
Total            117.7            116.8            118.6            119.8            122.3            122.7            114.8            100.7              92.6              88.7              85.6              82.3              80.0
Passengers Per Employee
Pilots & Co-Pilots          10,069          10,153          10,117            9,811            9,406            9,518            8,582            9,365          10,167          11,219          11,319          12,114          12,382
Flight Attendants            5,671            5,666            5,669            5,014            5,358            5,294            5,054            5,607            6,185            6,420            6,381            6,975            6,997
Maintenance          10,615          10,902          10,039            8,179            9,070            9,728            9,620          10,950          17,524          21,907          38,724        205,572        202,781
Passenger, Cargo and Aircraft Handling            2,737            2,762            2,836            2,509            2,655            2,731            2,573            2,780            3,003            3,329            3,719            4,236            4,475
Other            6,912            7,254            7,334            6,608            6,948            7,086            6,909            7,960            8,815          10,277          10,425          10,839          10,168
Total            1,133            1,152            1,156            1,025            1,080            1,104            1,049            1,159            1,308            1,442            1,571            1,786            1,814
Productivity Measures Revenue  
Passenger Revenue Per Employee (000)
Pilots & Co-Pilots  $     1,583.1  $     1,655.7  $     1,613.1  $     1,458.5  $     1,475.0  $     1,592.3  $     1,346.6  $     1,401.0  $     1,490.0  $     1,706.2  $     1,769.4  $     1,997.6  $     2,141.2
Flight Attendants  $        891.6  $        924.1  $        903.9  $        745.3  $        840.1  $        885.6  $        793.1  $        838.8  $        906.4  $        976.4  $        997.5  $     1,150.2  $     1,210.0
Maintenance  $     1,668.9  $     1,778.0  $     1,600.7  $     1,215.9  $     1,422.2  $     1,627.4  $     1,509.7  $     1,638.1  $     2,568.0  $     3,331.4  $     6,053.4  $    33,899.1  $    35,067.0
Passenger, Cargo and Aircraft Handling  $        430.3  $        450.5  $        452.2  $        372.9  $        416.3  $        456.9  $        403.7  $        415.8  $        440.0  $        506.2  $        581.3  $        698.6  $        773.9
Other  $     1,086.7  $     1,183.0  $     1,169.3  $        982.3  $     1,089.5  $     1,185.4  $     1,084.1  $     1,190.8  $     1,291.8  $     1,562.9  $     1,629.7  $     1,787.3  $     1,758.3
Total  $        178.1  $        187.9  $        184.3  $        152.4  $        169.4  $        184.7  $        164.7  $        173.4  $        191.7  $        219.3  $        245.6  $        294.5  $        313.7
Salary and Benefits  
Average Salary
Management and All Other  $      51,393  $      51,312  $      53,960  $      54,076  $      56,951  $      61,520  $      65,383  $      66,896  $      75,283  $      82,489  $      77,119  $      69,640  $      93,824
Pilots & Co-Pilots  $     154,635  $     131,641  $     126,107  $     142,578  $     128,100  $     134,441  $     138,427  $     148,084  $     161,931  $     169,208  $     143,618  $     117,556  $     132,009
Flight Attendants  $      30,899  $      30,091  $      29,642  $      30,714  $      32,406  $      31,951  $      34,218  $      37,331  $      42,425  $      43,184  $      42,329  $      33,747  $      35,674
Maintenance  $      54,171  $      52,781  $      51,582  $      49,877  $      46,090  $      52,881  $      72,133  $      72,014  $      72,788  $      74,402  $      99,426  $      76,045  $      58,445
Passenger, Cargo and Aircraft Handling  $      41,418  $      39,219  $      38,983  $      40,851  $      39,928  $      42,158  $      44,215  $      45,603  $      49,523  $      49,755  $      48,759  $      42,288  $      43,310
Total  $      54,976  $      51,224  $      50,867  $      52,615  $      51,953  $      55,004  $      59,945  $      62,496  $      68,074  $      69,560  $      66,465  $      55,996  $      63,546
Other Compensation Per Employee (All Employees)
Benefits, Pensions and Payroll Taxes
Pilots & Co-Pilots  $      21,687  $      29,489  $      24,002  $      26,785  $      31,886  $      24,230  $      29,615  $      38,694  $      53,145  $      56,276  $      72,772  $      49,840  $      27,924
All Others  $        5,649  $        6,544  $        6,100  $        6,685  $        7,289  $        7,728  $      11,188  $      14,691  $      17,832  $      17,007  $      22,962  $      19,369  $      11,933
Total  $        7,454  $        9,148  $        8,145  $        8,785  $      10,115  $        9,643  $      13,441  $      17,662  $      22,375  $      22,054  $      29,876  $      23,862  $      14,276
Personnel
Pilots & Co-Pilots  $        9,504  $        9,771  $        9,925  $      10,834  $      10,510  $      11,247  $      10,339  $        9,913  $      10,210  $      10,582  $      10,581  $      11,410  $      12,302
Flight Attendents  $      13,767  $      13,956  $      13,815  $      13,786  $      14,796  $      15,780  $      14,735  $      13,294  $      14,097  $      14,000  $      14,873  $      16,480  $      18,123
Payroll Taxes
Pilots & Co-Pilots  $        5,931  $        5,848  $        6,443  $        7,242  $        6,782  $        7,205  $        7,526  $        7,780  $        8,906  $        9,122  $        8,687  $        8,628  $        7,524
All Others  $        2,957  $        3,024  $        3,244  $        3,085  $        3,309  $        3,541  $        3,876  $        4,052  $        4,454  $        4,981  $        4,902  $        4,226  $        3,934
Raw Data  
Number of Months 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
P10- Employee Count Data  
Sum of General Management                51                66                84                89                98                89                60                52                47                44                43                42                41
Sum of Pilots and Co-Pilots            4,903            5,193            5,407            5,151            5,822            5,981            6,103            5,534            5,112            4,942            4,995            4,531            4,340
Sum of Other Flight Personnel                 -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Passenger and General Services            8,706            9,305            9,649          10,080          10,222          10,753          10,363            9,243            8,403            8,636            8,860            7,869            7,680
Sum of Maintenance            4,651            4,836            5,449            6,179            6,038            5,852            5,444            4,733            2,966            2,531            1,460               267               265
Sum of AC Handling 1                 -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Aircraft Handling          13,158          13,738          14,042          14,726          15,121          15,501          15,336          14,275          13,151          12,504          11,270            9,461            8,507
Sum of Aircraft Control               243               345               349               335               349               361               370               343               320               311               299               280               281
Sum of Passenger Handling            3,628            4,003            3,934            4,125            4,154            3,936            3,629            3,158            2,976            2,937            2,720            2,375            2,393
Sum of Cargo Handling            1,008            1,002               964               961            1,003            1,044            1,024               869               862               904               915               840               827
Sum of Trainees and Instructors               309               348               440               421               415               433               382               338               310               283               274               264               301
Sum of Stats            3,526            3,504            3,553            3,662            3,695            3,751            3,595            3,072            2,774            2,381            2,513            2,240            2,287
Sum of Traffic Solicitors               390               383               377               386               380               358               334               287               285               280               258               243               244
Sum of Other            2,480            2,600            2,657            2,776            3,008            3,146            2,999            2,548            2,340            2,283            2,207            2,149            2,288
Sum of Transport Related               438               433               432               403               384               346               271               266               187               168               171               168               165
Sum of Total          43,581          45,756          47,337          49,294          50,689          51,551          49,910          44,718          39,733          38,454          35,985          30,729          29,619
P6- Objective Grouping Operating Expense Data  
Sum of Salaries-General Management Personnel (000)  $      24,946  $      27,434  $      36,017  $      34,424  $      49,332  $      61,368  $      30,717  $      39,668  $      52,913  $      57,871  $      52,107  $      39,450  $      80,795
Sum of Salaries-Flight Personnel (000)  $  1,027,183  $     963,612  $     967,882  $  1,044,016  $  1,077,056  $  1,147,666  $  1,199,419  $  1,164,550  $  1,184,284  $  1,209,161  $  1,092,408  $     798,201  $     846,898
Sum of Salaries-Maintenance Labor (000)  $     251,951  $     255,248  $     281,071  $     308,190  $     278,294  $     309,461  $     392,690  $     340,843  $     215,888  $     188,311  $     145,162  $      20,304  $      15,488
Sum of Salaries-Aircraft And Traffic Handling Personnel (000)  $     747,059  $     748,603  $     751,941  $     823,016  $     823,601  $     878,654  $     900,172  $     850,265  $     857,185  $     828,725  $     741,338  $     547,889  $     520,070
Sum of Salaries-Other Personnel (000)  $     344,778  $     348,888  $     371,003  $     383,960  $     405,140  $     438,363  $     468,875  $     399,372  $     394,496  $     390,785  $     369,425  $     316,132  $     418,911
Sum of Salaries-Total (000)  $  2,395,917  $  2,343,785  $  2,407,914  $  2,593,606  $  2,633,423  $  2,835,512  $  2,991,873  $  2,794,698  $  2,704,766  $  2,674,853  $  2,391,746  $  1,720,712  $  1,882,162
Sum of Related Fringe Benefits-Personnel Expense (000)  $     166,449  $     180,605  $     186,965  $     194,771  $     212,434  $     236,954  $     215,794  $     177,739  $     170,654  $     173,201  $     184,630  $     181,379  $     192,570
Sum of Related Fringe Benefits-Employee Benefits And Pensions (000)  $     324,831  $     418,597  $     385,555  $     433,063  $     512,694  $     497,081  $     670,846  $     789,795  $     889,028  $     848,054  $  1,075,090  $     733,256  $     422,848
Sum of Related Fringe Benefits-Payroll Taxes (000)  $     143,446  $     153,050  $     170,852  $     173,500  $     187,966  $     204,460  $     215,735  $     201,819  $     199,744  $     212,003  $     195,305  $     149,804  $     132,095
Sum of Related Fringe Benefits-Total (000)  $     634,726  $     752,252  $     743,372  $     801,334  $     913,094  $     938,495  $  1,102,375  $  1,169,353  $  1,259,426  $  1,233,258  $  1,455,025  $  1,064,439  $     747,513
Sum of Total Salaries And Related Fringe Benefits (000)  $  3,030,643  $  3,096,037  $  3,151,286  $  3,394,940  $  3,546,517  $  3,774,007  $  4,094,248  $  3,964,051  $  3,964,192  $  3,908,111  $  3,846,771  $  2,785,151  $  2,629,675
Sum of Services Purchased-Advertising And Other Promotions (000)  $     128,144  $     146,737  $     128,327  $     175,277  $     129,912  $     131,235  $     112,860  $      84,136  $      69,121  $     163,308  $      91,476  $      76,033  $      68,144
Sum of Services Purchased-Communication (000)  $     106,496  $     119,191  $     119,174  $     126,980  $     143,507  $     148,988  $     143,932  $     134,341  $     127,538  $     138,833  $     142,559  $     138,114  $     144,721
Sum of Services Purchased-Insurance (000)  $      49,008  $      55,261  $      46,244  $      31,762  $      22,228  $      23,398  $      37,807  $     112,339  $      78,390  $      73,231  $      65,991  $      61,858  $      51,479
Sum of Services Purchased-Outside Flight Equipment Maintenance (000)  $     146,886  $     212,936  $     246,864  $     320,102  $     279,472  $     273,139  $     337,110  $     296,020  $     297,525  $     260,742  $     519,009  $     646,678  $     666,427
Sum of Services Purchased-Traffic Commissions -Passenger (000)  $     784,481  $     817,776  $     803,713  $     643,165  $     673,801  $     591,416  $     443,239  $     309,618  $     241,999  $     270,100  $     276,344  $     269,752  $     267,747
Sum of Services Purchased-Traffic Commissions-Cargo (000)  $      31,622  $      31,057  $      32,175  $      24,666  $      29,610  $      37,715  $      24,780  $        5,672  $        1,205  $           519  $           384  $           443  $           281
Sum of Services Purchased-Other Services (000)  $     673,581  $     721,680  $     788,203  $     805,522  $     881,780  $     954,723  $     911,890  $     880,288  $     863,132  $     925,329  $  1,136,646  $  1,045,748  $  1,179,705
Sum of Services Purchased-Total (000)  $  1,920,218  $  2,104,638  $  2,164,700  $  2,127,474  $  2,160,310  $  2,160,614  $  2,011,618  $  1,821,112  $  1,678,508  $  1,831,970  $  2,232,339  $  2,238,496  $  2,378,504
Sum of Transport Related Expense (000) 102213 100103 100762 64062 77747 112373 146619 163150 185645 1430601 1894571 1625788 1539975
Sum of Total Operating Expense (000)  $  7,998,622  $  8,643,457  $  8,780,475  $  8,836,084  $  9,099,249  $10,293,107  $10,388,396  $  9,935,075  $  9,460,358  $11,699,605  $13,210,759  $11,773,257  $11,610,969
T1 & T2- Traffic Data  
Sum of RPMs 6.27E+10 6.87E+10 7.22E+10 6.68E+10 7.43E+10 7.93E+10 7.33E+10 7.21E+10 6.88E+10 7.34E+10 7.59E+10 7.27E+10 7.30E+10
Sum of ASMs 8.77E+10 9.40E+10 9.72E+10 9.14E+10 9.96E+10 1.04E+11 9.86E+10 9.36E+10 8.91E+10 9.15E+10 9.19E+10 8.57E+10 8.63E+10
Sum of Miles 4.79E+08 5.05E+08 5.16E+08 4.85E+08 5.29E+08 5.48E+08 5.37E+08 5.21E+08 5.06E+08 5.21E+08 5.16E+08 4.79E+08 4.70E+08
Sum of Depts        566,438        586,283        585,054        539,814        584,542        599,145        578,371        566,134        553,245        563,719        537,627        489,678        468,373
Sum of Airborne Hours      1,084,197      1,142,142      1,163,303      1,093,811      1,190,590      1,232,446      1,206,326      1,176,684      1,143,575      1,175,862      1,159,930      1,071,612      1,052,432
Sum of Block Hours      1,291,188      1,362,560      1,392,573      1,311,880      1,435,810      1,487,463      1,447,191      1,408,396      1,358,658      1,402,452      1,381,536      1,280,748      1,273,956
Sum of AC Days        135,106        143,382        145,691        150,243        151,282        153,784        158,721        162,116        156,681        158,749        153,460        136,254        135,170
Sum of Gallons 1.85E+09 1.95E+09 2.00E+09 1.88E+09 2.04E+09 2.11E+09 2.03E+09 1.90E+09 1.75E+09 1.77E+09 1.74E+09 1.59E+09 1.54E+09
Sum of Passengers    49,370,005    52,722,136    54,704,317    50,538,811    54,764,430    56,927,032    52,373,970    51,827,440    51,975,656    55,446,115    56,537,115    54,887,676    53,736,983
P12- Profit and Loss Statement  
Sum of Pax Rev (000) -7.76E+06 -8.60E+06 -8.72E+06 -7.51E+06 -8.59E+06 -9.52E+06 -8.22E+06 -7.75E+06 -7.62E+06 -8.43E+06 -8.84E+06 -9.05E+06 -9.29E+06
Sum of Charter Pax (000)  $     (15,726)  $     (12,899)  $     (23,165)  $     (21,756)  $     (29,222)  $     (37,207)  $     (48,522)  $     (38,213)  $     (88,510)  $     (34,377)  $     (40,277)  $     (34,792)  $     (35,883)
Sum of Transport Related Rev (000)  $    (259,382)  $    (259,814)  $    (308,523)  $    (400,265)  $    (366,188)  $    (365,408)  $    (410,375)  $    (432,828)  $    (511,585)  $ (1,742,485)  $ (2,193,989)  $ (2,090,967)  $ (2,200,860)
Sum of Cargo Rev (000)  $    (637,986)  $    (625,020)  $    (662,035)  $    (545,736)  $    (633,090)  $    (754,729)  $    (628,752)  $    (678,882)  $    (722,825)  $    (832,987)  $    (907,636)  $    (963,979)  $    (850,940)
Sum of Total Rev (000) -8.91E+06 -9.75E+06 -9.98E+06 -8.71E+06 -9.87E+06 -1.10E+07 -9.59E+06 -9.15E+06 -9.18E+06 -1.13E+07 -1.23E+07 -1.26E+07 -1.27E+07
P52- Functional Grouping Operating Expense Data  
Sum of Pilots And Copilots (000)  $     758,177  $     683,612  $     681,862  $     734,420  $     745,798  $     804,094  $     844,817  $     819,496  $     827,789  $     836,226  $     717,370  $     532,645  $     572,918
Sum of Other Flight Personnel (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Sum of Trainees And Instructors (000)  $      48,849  $      62,033  $      82,222  $      76,246  $      75,825  $      75,824  $      75,840  $      61,621  $      66,742  $      62,903  $      48,236  $      33,437  $      45,432
Sum of Personnel Expenses (000)  $      46,596  $      50,740  $      53,663  $      55,806  $      61,187  $      67,271  $      63,100  $      54,861  $      52,196  $      52,295  $      52,852  $      51,700  $      53,389
Sum of Employee Benefits And Pensions (000)  $     106,330  $     153,135  $     129,777  $     137,970  $     185,639  $     144,921  $     180,741  $     214,131  $     271,677  $     278,117  $     363,496  $     225,826  $     121,192
Sum of Taxes-Payroll (000)  $      29,078  $      30,371  $      34,837  $      37,301  $      39,487  $      43,092  $      45,933  $      43,052  $      45,526  $      45,079  $      43,394  $      39,095  $      32,653
Sum of Total Flight Equipment Maintenance (Memo) (000)  $     791,934  $     963,666  $  1,028,875  $  1,205,127  $  1,059,992  $  1,119,065  $  1,205,828  $  1,076,566  $     810,002  $     746,767  $     913,798  $     898,134  $     905,623
Sum of Flying Operations-Aircraft Fuels (000)  $  1,027,490  $  1,307,356  $  1,294,790  $  1,006,109  $  1,093,621  $  1,758,176  $  1,612,196  $  1,317,974  $  1,416,566  $  2,086,483  $  2,953,593  $  3,225,719  $  3,173,418