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 Start 1999

Range End 2008

Food 78.77

Chemicals 75.78

Paper 88.64

Petroleum 103.78

Aluminum 81.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.16
2 3 2 4

Capacity Utilization Value of Shipments (millions 2008$)

Food Manufacturing

Beverage & Tobaco 

Manufacturing Food Manufacturing

Beverage & 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.1
2 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

1990 92.0 93.0 92.0 9356.5 64892.5 23873.5 92.7

1991 94.0 95.0 95.0 7722.2 60562.3 21753.6 94.9

1992 91.0 93.0 96.0 7741.6 58493.4 22860.9 93.6

1993 92.0 98.0 97.0 5928.3 56188.6 22379.0 97.3

1994 97.0 98.0 99.0 6543.6 59176.2 25083.3 98.2

1995 90.0 92.0 91.0 9198.1 72558.8 32584.3 91.6

1996 92.0 91.0 95.0 7180.8 63895.3 26427.6 92.2

1997 92.0 95.0 95.0 4185.7 61761.4 25793.4 94.9

1998 91.0 93.0 90.0 3970.1 60759.0 26561.7 92.0

1999 91.0 90.0 93.0 3892.6 61449.1 26633.1 90.9

2000 88.0 87.0 87.0 4529.0 62161.9 28542.3 87.0

2001 90.0 81.0 87.0 3870.1 55984.3 26163.5 83.2

2002 87.0 89.0 93.0 4147.1 54138.5 24490.4 90.1

2003 89.0 87.0 94.0 4473.4 50732.2 23353.0 89.2

2004 93.0 88.0 94.0 4578.6 51947.9 23536.1 90.0

2005 92.0 80.0 95.0 4377.3 54698.1 22574.1 84.8

2006 94.0 88.0 98.0 4464.7 53930.6 24373.1 91.3

2007 99.0 90.0 93.0 5134.0 50786.8 25892.5 91.5

2008 91.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

Year

1990 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.4
2 3 4 5

Capacity Utilization

Alumina Refining Primary Aluminum

Secondary Smelting and 

Alloying of Aluminum

Aluminum 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.0
Year

1990

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 Aluminum

Aluminum 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 

Utilization
4 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 Average 

Capacity Utilization
Iron Ore Mining

Nonmetallic Mineral 

Mining and Quarrying

Textile 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

1990 107.16 79.13 156.26 95.23 104.49

1991 107.74 73.04 159.17 89.84 121.80

1992 106.06 76.40 175.74 92.55 78.74

1993 106.01 77.96 183.07 87.92 80.53

1994 110.39 82.79 188.94 93.24 92.59

1995 119.06 86.06 174.87 95.70 88.23

1996 117.98 87.57 168.21 97.59 91.85

1997 120.64 91.05 187.00 93.18 90.65

1998 119.68 95.49 179.86 101.01 96.99

1999 110.47 97.18 172.85 105.32 93.90

2000 119.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

2003 92.38 95.96 135.66 101.79 80.69

2004 103.79 102.26 129.19 100.30 89.35

2005 102.88 105.53 131.29 108.03 89.29

2006 100.12 108.20 108.27 109.95 99.11

2007 99.83 100.00 100.00 99.94 99.91

2008 101.10 86.91 77.29 91.21 116.88

2009 51.86 71.48 64.34 75.98 91.20
Year

1990

1991

1992

1993

1994

1995

1996

1997

1998

1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

2009

Cutlery and Handtool 

Manufacturing

Other Fabricated Metal 

Product Manufacturing

Aerospace Product and 

Parts Manufacturing

Medical 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