Northwest Airlines Employee Data and Analysis
Northwest Airlines
  1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008
Traffic Indicies  
Stage Length in Miles (for SLA purposes)               846              862              882              899              905                914                928              921              915                925                961                978              1,003              1,085
Seats Per Departure (for SDA purposes)              183              186              188              188              188                189                184              179              176                176                178                179                184                191
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  $            3.61
Airborne Hours / Block Hours 84% 84% 84% 83% 83% 83% 83% 84% 84% 84% 84% 84% 83% 84%
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% 68.9%
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% 13.3%
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  $    2,399,362
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               44.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               50.9
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              366.5
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                 8.3
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               18.0
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                 3.3
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         19,436.1
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         11,571.6
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       317,480.7
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           7,187.8
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         15,569.7
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           2,899.7
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                 6.4
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                 5.7
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                 0.8
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               34.8
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               16.1
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               86.2
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            11,259
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              6,703
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          183,912
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              4,164
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              9,019
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              1,680
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  $       2,160.1
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  $       1,286.1
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  $     35,284.6
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  $          798.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  $       1,730.4
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  $          322.3
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  $      108,296
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  $      120,798
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  $        35,938
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  $        57,496
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  $        42,053
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  $        64,842
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  $        30,191
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  $        13,108
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  $        15,657
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  $        12,919
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  $        19,766
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  $          8,986
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  $          4,770
Raw Data  
Number of Months 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
P10- Employee Count Data  
Sum of General Management                51                66                84                89                98                  89                  60                52                47                  44                  43                  42                  41                  42
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              4,345
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              7,298
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                266
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              8,337
Sum of Aircraft Control              243              345              349              335              349                361                370              343              320                311                299                280                281                283
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              2,322
Sum of Cargo Handling            1,008            1,002              964              961            1,003              1,044              1,024              869              862                904                915                840                827                807
Sum of Trainees and Instructors              309              348              440              421              415                433                382              338              310                283                274                264                301                309
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              2,346
Sum of Traffic Solicitors              390              383              377              386              380                358                334              287              285                280                258                243                244                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              2,363
Sum of Transport Related              438              433              432              403              384                346                271              266              187                168                171                168                165                162
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            29,124
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  $      101,043
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  $      787,141
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  $        15,294
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  $      494,076
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  $      490,902
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  $    1,888,456
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  $      200,389
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  $      455,984
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  $      157,243
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  $      813,616
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  $    2,702,072
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  $        59,840
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  $      157,819
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  $        49,674
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  $      602,563
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  $      312,140
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  $             241
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  $    1,263,660
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  $    2,445,937
Sum of Transport Related Expense (000) 102213 100103 100762 64062 77747 112373 146619 163150 185645 1430601 1894571 1625788 1539975 2399362
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  $  14,636,223
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 7.16E+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 8.44E+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 4.43E+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          408,342
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          982,386
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       1,169,779
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          123,265
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 1.43E+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      48,920,621
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 -9.39E+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)  $     (139,594)
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)  $   (3,192,221)
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)  $     (855,588)
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 -1.41E+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  $      524,866
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  $        41,214
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  $        56,134
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  $      131,182
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  $        39,045
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  $      874,517
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  $    5,146,347