Author: Abt Associates Inc.

Date Created: Date Modified: 3/11/2011

Purpose: This file calculates the average capacity utlization for all analyzed manufacturing industries over several years. This information is used to calculate the regulatory impact on manufacturing facilities.

File Contents: Worksheet Contents Average Calc Calculates average capacity utilization for all in-scope manufacturing industries Food Reads in capacity utlization and value of shipments over several years for the food industry Chemicals Reads in capacity utlization over several years for the chemicals industry Paper Reads in capacity utlization and value of shipments over several years for the paper industry Petroleum Reads in capacity utlization over several years for the petroleum industry

Aluminum Reads in capacity utlization and value of shipments over several years for the aluminum industry

Steel Reads in capacity utlization and value of shipments over several years for the steel industry Other Reads in capacity utlization and value of shipments over several years for other industries

Input Files: External data used in calculations/analysis:

Steel Profile Table.xls Petroleum Profile Tables.xls Paper Profile Tables.xls Food & Bev Profile Tables.xls Chemicals Profile Tables.xls Aluminum Profile Table.xls Other Industries CapUt.xls

### Range Start1999

Range End2008 Food 78.77 Chemicals75.78 Paper 88.64 Petroleum103.78 Aluminum81.91 Steel 79.64 Other Industries 21221 101.65 2123 98.44 3133 132.63 3211 101.98 331419 91.00 3322 110.95 3329 90.08 3364 83.58 3391 89.162 3 2 4 Capacity Utilization Value of Shipments (millions 2008$)

Food ManufacturingBeverage & Tobaco Manufacturing Food ManufacturingBeverage & Tobaco Manufacturing Year 311 312 311 312 1990 84.7 83.5 $429,573.7 $69,721.6 84.5 1991 84.5 80.6 $414,440.7 $70,538.6 83.9 1992 83.7 79.4 $433,298.0 $71,969.5 83.1 1993 84.3 71.6 $440,033.0 $70,787.4 82.5 1994 83.9 80.1 $443,022.1 $72,818.3 83.3 1995 84.5 82.9 $453,497.5 $74,845.7 84.2 1996 81.0 85.5 $456,782.8 $78,050.8 81.7 1997 81.2 84.5 $540,827.1 $78,091.9 81.6 1998 82.0 82.4 $543,445.9 $79,120.0 82.0 1999 80.0 74.7 $532,596.1 $77,042.9 79.4 2000 79.4 75.4 $532,533.9 $77,309.1 78.9 2001 78.3 75.3 $539,363.4 $77,945.5 77.9 2002 79.4 68.6 $536,214.4 $76,516.1 78.0 2003 79.8 72.3 $561,760.0 $80,588.8 78.9 2004 79.4 73.6 $572,695.6 $83,721.1 78.7 2005 80.8 76.5 $578,994.7 $87,596.5 80.2 2006 80.3 75.2 $563,082.9 $86,457.4 79.6 2007 81.7 74.8 $599,489.7 $89,395.6 80.8 2008 81.1 69.7 #N/A #N/A 75.4 2009 #N/A #N/A #N/A #N/A #N/A Weighted Average Capacity Utilization

### 2 Capacity Utilization Chemical Manufacturing 

### Year 325 1990 83.2 1991 81.1 1992 79.7 1993 78.8 1994 79.7 1995 79.9 1996 79.8 1997 81.3 1998 79.0 1999 77.3 2000 75.4 2001 71.1 2002 74.2 2003 74.0 2004 76.3 2005 77.5 2006 78.8 2007 79.0 2008 74.3 2009 77.12 3 4 2 4 6 Capacity Utilization Value of Shipments (Millions 2008$)

Pulp Mills (SIC to NAICS)Paper Mills

(SIC to NAICS)Paperboard Mills

(SIC to NAICS)Pulp Mills (SIC

to NAICS)Paper Mills

(SIC to NAICS)Paperboard Mills

(SIC to NAICS) Year 199092.0 93.0 92.0 9356.5 64892.5 23873.5 92.7 199194.0 95.0 95.0 7722.2 60562.3 21753.6 94.9 199291.0 93.0 96.0 7741.6 58493.4 22860.9 93.6 199392.0 98.0 97.0 5928.3 56188.6 22379.0 97.3 199497.0 98.0 99.0 6543.6 59176.2 25083.3 98.2 199590.0 92.0 91.0 9198.1 72558.8 32584.3 91.6 199692.0 91.0 95.0 7180.8 63895.3 26427.6 92.2 199792.0 95.0 95.0 4185.7 61761.4 25793.4 94.9 199891.0 93.0 90.0 3970.1 60759.0 26561.7 92.0 199991.0 90.0 93.0 3892.6 61449.1 26633.1 90.9 200088.0 87.0 87.0 4529.0 62161.9 28542.3 87.0 200190.0 81.0 87.0 3870.1 55984.3 26163.5 83.2 200287.0 89.0 93.0 4147.1 54138.5 24490.4 90.1 200389.0 87.0 94.0 4473.4 50732.2 23353.0 89.2 200493.0 88.0 94.0 4578.6 51947.9 23536.1 90.0 200592.0 80.0 95.0 4377.3 54698.1 22574.1 84.8 200694.0 88.0 98.0 4464.7 53930.6 24373.1 91.3 200799.0 90.0 93.0 5134.0 50786.8 25892.5 91.5 200891.0 84.0 90.0 #N/A #N/A #N/A 88.3 2009#N/A #N/A #N/A #N/A #N/A #N/A #N/A Weighted Average Capacity Utilization

### 2 Capacity Utilization Petroleum Refining 

### Year1990 89.1 1991 89.1 1992 86.9 1993 85.8 1994 89.2 1995 91.1 1996 92.8 1997 94.6 1998 90.9 1999 97.6 2000 97.9 2001 98.1 2002 100.0 2003 97.2 2004 106.4 2005 109.9 2006 110.3 2007 110.2 2008 110.2 2009 109.42 3 4 5 Capacity Utilization

Alumina Refining Primary Aluminum Secondary Smelting and Alloying of AluminumAluminum Sheet, Plate, and Foil Year 313311 331312 331314 331315 1990 77.0 99.0 84.0 73.0 1991 74.0 99.0 83.0 80.0 1992 79.0 99.0 85.0 88.0 1993 80.0 84.0 88.0 81.0 1994 85.0 85.0 89.0 91.0 1995 78.0 88.0 87.0 86.0 1996 79.0 88.0 86.0 89.0 1997 83.0 87.0 87.0 89.0 1998 83.0 87.0 89.0 85.0 1999 71.0 86.0 85.0 89.0 2000 72.0 79.0 74.0 83.0 2001 84.0 64.0 74.0 75.0 2002 79.0 70.0 75.0 87.0 2003 76.0 72.0 75.0 86.0 2004 93.0 92.0 77.0 90.0 2005 91.0 84.0 79.0 86.0 2006 75.0 57.0 75.0 86.0 2007 86.0 84.0 83.0 2008 98.0 81.0 86.0 2009 67.0 80.0 71.0Year1990

1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2 4 6 8 Value of Shipments (Millions 2008$)

Alumina Refining Primary Aluminum Secondary Smelting and Alloying of AluminumAluminum Sheet, Plate, and Foil 313311 331312 331314 331315 $1,715.5 $10,548.4 $4,779.6 $16,678.4 82.9 $1,756.4 $8,982.5 $3,812.1 $15,609.8 85.7 $1,667.8 $8,284.5 $4,580.6 $15,083.0 90.1 $1,636.6 $7,158.2 $4,168.6 $13,390.7 82.9 $1,415.8 $7,566.4 $5,058.6 $14,338.7 88.7 $1,254.5 $8,871.0 $5,360.0 $18,458.1 86.4 $1,149.8 $7,735.1 $4,875.2 $16,481.0 87.9 $1,563.3 $7,982.3 $4,610.7 $17,579.3 87.9 $1,665.8 $7,878.6 $4,523.1 $16,557.0 86.0 $1,474.3 $7,264.2 $4,472.6 $16,020.5 86.7 $1,376.1 $7,376.4 $4,581.1 $15,683.0 80.0 $1,034.5 $6,408.6 $3,973.1 $13,763.5 72.4 $965.9 $6,397.3 $4,479.7 $13,097.4 80.2 $930.7 $5,207.1 $4,324.0 $13,131.3 80.5 $1,134.3 $5,732.1 $4,730.2 $14,735.0 88.2 $1,346.5 $5,265.8 $5,865.6 $16,465.5 84.5 $1,331.3 $6,482.7 $7,387.0 $18,415.6 77.6 $1,365.4 $6,798.5 $8,903.1 $19,055.9 80.7 #N/A #N/A #N/A #N/A 88.3 #N/A #N/A #N/A #N/A #N/A Weighted Average Capacity Utilization4 8 2 4 Capacity Utilization Value of Shipments (Millions 2008$)

Steel Mills Steel Products Steel Mills Steel Products Year 3311 3312 3311 3312 1990 85.0 82.4 $70,681.6 $22,041.6 84.4 1991 82.5 81.3 $60,740.6 $20,474.3 82.2 1992 83.0 81.8 $61,617.7 $20,782.7 82.7 1993 84.5 83.1 $63,635.5 $22,415.6 84.1 1994 85.5 84.3 $70,442.4 $23,934.0 85.2 1995 84.5 80.5 $74,183.3 $24,982.8 83.5 1996 83.5 79.9 $72,932.4 $23,921.0 82.6 1997 83.5 78.8 $74,869.4 $23,745.7 82.3 1998 77.5 74.7 $72,354.4 $23,874.0 76.8 1999 87.4 80.5 $66,481.3 $21,143.3 85.8 2000 72.7 70.6 $64,812.1 $21,413.5 72.2 2001 73.2 64.2 $55,560.4 $18,276.3 71.0 2002 82.6 71.2 $56,434.8 $17,762.8 79.9 2003 78.1 69.9 $56,572.6 $16,006.4 76.3 2004 87.5 75.7 $86,241.6 $19,534.9 85.3 2005 90.0 79.4 $89,164.3 $21,669.9 87.9 2006 84.0 75.6 $97,871.7 $20,548.6 82.5 2007 80.0 73.3 $105,701.1 $20,860.2 78.9 2008 78.5 74.9 #N/A #N/A 76.7 2009 54.5 51.1 #N/A #N/A #N/A Weighted A

verage Capacity UtilizationIron Ore Mining Nonmetallic Mineral Mining and QuarryingTextile and Fabric Finishing and Fabric Coating Mills Sawmills and Wood Preservation Primary Smelting and Refining of Nonferrous Metal (except Copper and Aluminum) Year 21221 2123 3133 3211 331419 1990107.16 79.13 156.26 95.23 104.49 1991107.74 73.04 159.17 89.84 121.80 1992106.06 76.40 175.74 92.55 78.74 1993106.01 77.96 183.07 87.92 80.53 1994110.39 82.79 188.94 93.24 92.59 1995119.06 86.06 174.87 95.70 88.23 1996117.98 87.57 168.21 97.59 91.85 1997120.64 91.05 187.00 93.18 90.65 1998119.68 95.49 179.86 101.01 96.99 1999110.47 97.18 172.85 105.32 93.90 2000119.74 97.12 170.62 104.61 84.28 2001 88.43 96.99 153.96 98.98 80.54 2002 97.78 94.22 147.15 99.70 76.02 200392.38 95.96 135.66 101.79 80.69 2004103.79 102.26 129.19 100.30 89.35 2005102.88 105.53 131.29 108.03 89.29 2006100.12 108.20 108.27 109.95 99.11 200799.83 100.00 100.00 99.94 99.91 2008101.10 86.91 77.29 91.21 116.88 200951.86 71.48 64.34 75.98 91.20Year1990

1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009Cutlery and Handtool Manufacturing Other Fabricated Metal Product ManufacturingAerospace Product and Parts ManufacturingMedical Equipment and Supplies Manufacturing 3322 3329 3364 3391 113.44 80.19 105.79 49.15 105.40 75.15 102.76 51.83 105.72 76.94 93.13 55.91 111.97 76.95 85.28 59.21 122.12 80.57 74.39 57.47 125.83 83.75 70.06 59.53 132.96 85.28 73.48 63.69 130.21 88.72 83.21 65.81 131.15 91.83 98.56 72.34 135.62 88.64 92.77 73.39 137.01 89.85 77.82 77.44 126.72 83.56 85.37 80.69 115.63 86.23 77.54 83.85 107.80 86.69 72.82 88.66 100.21 86.19 70.28 87.27 99.81 87.80 79.96 95.37 98.23 93.38 85.50 99.79 99.85 100.00 100.00 99.97 88.67 98.42 93.78 105.18 76.54 80.15 98.59 106.35