### Author: Abt Associates Inc.

Date Created: Date Modified: 3/11/2011 Purpose: This file calculates the total weekly cost of downtime and the total energy penatlty for each facility.

File Contents: Worksheet Contents Fac-level Downtime Cost Caclulates energy penalty for each facility Downtime Cost Calc Calculates cost of downtime for each facility Rates Calcualtes the AEO adjustment from 2007 elelctricty prices to 2009 prices

Input Files: External data used in calculations/analysis: AEO_2009.xls average_price_state.xls Man_Facility_Data.xls MN_Financial_Data.xls

The original version of this file contains, or is linked to a file that contains, confidential business information (CBI), or information that could be used to reveal CBI. As a result, the values for any variables determined by EPA to be CBI, or that could be used to reveal CBI, have been concealed.

### 1 2 3 4

SurveyIDTotal Weekly Cost of Downtime Total Weekly Cost of Downtime, Electricity

Only Cost/Revenue for Energy Penalty

### 1 2 3 4

SurveyIDTotal Weekly Cost of Downtime Total Weekly Cost of Downtime, Electricity

Only Cost/Revenue for Energy Penalty

### 1 2 3 4

SurveyIDTotal Weekly Cost of Downtime Total Weekly Cost of Downtime, Electricity

Only Cost/Revenue for Energy Penalty

### 1 2 3 4

SurveyIDTotal Weekly Cost of Downtime Total Weekly Cost of Downtime, Electricity

Only Cost/Revenue for Energy Penalty

# Cost of Downtime for the 316(b) Phase III Manufacturing Facilities

All dollar values are in 2009$

5 17 18

7 character ID Survey ID (Costs)Survey ID (Abt) State Total Facility Revenues Revenue from

Electricity Sales Material &

Product Costs Percent of Non-Electric Revenue Associated

with the Use of Cooling Water Directly Withdrawn from Surface Water Ques. 8(a) Ques. 8(b) Ques. 8(d) Ques. 1420 21 22 Survey Data Did facility generate electricity using clng wtr directly withdrawn from surface water by facility at any time during facility's FY 96, 97, or 98 (1=yes; 2=no) Cost of Fuel for Electricity Gross Electricity

Generation (KWh) Total Sales of

Electricity (KWh)Self-Generated Electricity Usage (KWh) Purchase price,

State average ($/kWh) Lost Non-Electric

Revenues Non-Electric

Costs Shed Lost Electric

Revenues Ques. 15c Ques. 17(b) Ques. 18(a) Ques. 18(b) 18(a) - 18(b)Min Elec Usage Floor: 25.0%

Cost of Downtime

Electric Costs Shed Cost of Replacement Electricity (2009) Total Annual Cost of Downtime Total Weekly Cost

of Downtime Total Annual Cost ofDowntimeElectricity Only Total Weekly Cost ofDowntimeElectricity Only Self Generated Electricity Replacement Cost Revenue/Cost

for Penalty7

character ID Survey ID (Costs)Survey ID (Abt) State Total Facility Revenues Revenue from

Electricity Sales Material &

Product Costs Percent of Non-Electric Revenue Associated

with the Use of Cooling Water Directly Withdrawn from Surface Water Ques. 8(a) Ques. 8(b) Ques. 8(d) Ques. 14Survey Data

Did facility generate electricity using clng wtr directly withdrawn from surface water by facility at any time during facility's FY 96, 97, or 98 (1=yes; 2=no) Cost of Fuel for Electricity Gross Electricity

Generation (KWh) Total Sales of

Electricity (KWh)Self-Generated Electricity Usage (KWh) Purchase price,

State average ($/kWh) Lost Non-Electric

Revenues Non-Electric

Costs Shed Lost Electric

Revenues Ques. 15c Ques. 17(b) Ques. 18(a) Ques. 18(b) 18(a) - 18(b)Cost of Downtime

Electric Costs Shed Cost of Replacement Electricity (2009) Total Annual Cost of Downtime Total Weekly Cost

of Downtime Total Annual Cost ofDowntimeElectricity Only Total Weekly Cost ofDowntimeElectricity Only Self Generated Electricity Replacement Cost Revenue/Cost

for Penalty7

character ID Survey ID (Costs)Survey ID (Abt) State Total Facility Revenues Revenue from

Electricity Sales Material &

Product Costs Percent of Non-Electric Revenue Associated

with the Use of Cooling Water Directly Withdrawn from Surface Water Ques. 8(a) Ques. 8(b) Ques. 8(d) Ques. 14Survey Data

Did facility generate electricity using clng wtr directly withdrawn from surface water by facility at any time during facility's FY 96, 97, or 98 (1=yes; 2=no) Cost of Fuel for Electricity Gross Electricity

Generation (KWh) Total Sales of

Electricity (KWh)Self-Generated Electricity Usage (KWh) Purchase price,

State average ($/kWh) Lost Non-Electric

Revenues Non-Electric

Costs Shed Lost Electric

Revenues Ques. 15c Ques. 17(b) Ques. 18(a) Ques. 18(b) 18(a) - 18(b)Cost of Downtime

Electric Costs Shed Cost of Replacement Electricity (2009) Total Annual Cost of Downtime Total Weekly Cost

of Downtime Total Annual Cost ofDowntimeElectricity Only Total Weekly Cost ofDowntimeElectricity Only Self Generated Electricity Replacement Cost Revenue/Cost

for Penalty7

character ID Survey ID (Costs)Survey ID (Abt) State Total Facility Revenues Revenue from

Electricity Sales Material &

Product Costs Percent of Non-Electric Revenue Associated

with the Use of Cooling Water Directly Withdrawn from Surface Water Ques. 8(a) Ques. 8(b) Ques. 8(d) Ques. 14Survey Data

Did facility generate electricity using clng wtr directly withdrawn from surface water by facility at any time during facility's FY 96, 97, or 98 (1=yes; 2=no) Cost of Fuel for Electricity Gross Electricity

Generation (KWh) Total Sales of

Electricity (KWh)Self-Generated Electricity Usage (KWh) Purchase price,

State average ($/kWh) Lost Non-Electric

Revenues Non-Electric

Costs Shed Lost Electric

Revenues Ques. 15c Ques. 17(b) Ques. 18(a) Ques. 18(b) 18(a) - 18(b)Cost of Downtime

Electric Costs Shed Cost of Replacement Electricity (2009) Total Annual Cost of Downtime Total Weekly Cost

of Downtime Total Annual Cost ofDowntimeElectricity Only Total Weekly Cost ofDowntimeElectricity Only Self Generated Electricity Replacement Cost Revenue/Cost

for Penalty7

character ID Survey ID (Costs)Survey ID (Abt) State Total Facility Revenues Revenue from

Electricity Sales Material &

Product Costs Percent of Non-Electric Revenue Associated

with the Use of Cooling Water Directly Withdrawn from Surface Water Ques. 8(a) Ques. 8(b) Ques. 8(d) Ques. 14Survey Data

Did facility generate electricity using clng wtr directly withdrawn from surface water by facility at any time during facility's FY 96, 97, or 98 (1=yes; 2=no) Cost of Fuel for Electricity Gross Electricity

Generation (KWh) Total Sales of

Electricity (KWh)Self-Generated Electricity Usage (KWh) Purchase price,

State average ($/kWh) Lost Non-Electric

Revenues Non-Electric

Costs Shed Lost Electric

Revenues Ques. 15c Ques. 17(b) Ques. 18(a) Ques. 18(b) 18(a) - 18(b)Cost of Downtime

Electric Costs Shed Cost of Replacement Electricity (2009) Total Annual Cost of Downtime Total Weekly Cost

of Downtime Total Annual Cost ofDowntimeElectricity Only Total Weekly Cost ofDowntimeElectricity Only Self Generated Electricity Replacement Cost Revenue/Cost

for Penalty7

character ID Survey ID (Costs)Survey ID (Abt) State Total Facility Revenues Revenue from

Electricity Sales Material &

Product Costs Percent of Non-Electric Revenue Associated

with the Use of Cooling Water Directly Withdrawn from Surface Water Ques. 8(a) Ques. 8(b) Ques. 8(d) Ques. 14Survey Data

Did facility generate electricity using clng wtr directly withdrawn from surface water by facility at any time during facility's FY 96, 97, or 98 (1=yes; 2=no) Cost of Fuel for Electricity Gross Electricity

Generation (KWh) Total Sales of

Electricity (KWh)Self-Generated Electricity Usage (KWh) Purchase price,

State average ($/kWh) Lost Non-Electric

Revenues Non-Electric

Costs Shed Lost Electric

Revenues Ques. 15c Ques. 17(b) Ques. 18(a) Ques. 18(b) 18(a) - 18(b)Cost of Downtime

Electric Costs Shed Cost of Replacement Electricity (2009) Total Annual Cost of Downtime Total Weekly Cost

of Downtime Total Annual Cost ofDowntimeElectricity Only Total Weekly Cost ofDowntimeElectricity Only Self Generated Electricity Replacement Cost Revenue/Cost

for Penalty7

character ID Survey ID (Costs)Survey ID (Abt) State Total Facility Revenues Revenue from

Electricity Sales Material &

Product Costs Percent of Non-Electric Revenue Associated

with the Use of Cooling Water Directly Withdrawn from Surface Water Ques. 8(a) Ques. 8(b) Ques. 8(d) Ques. 14Survey Data

Did facility generate electricity using clng wtr directly withdrawn from surface water by facility at any time during facility's FY 96, 97, or 98 (1=yes; 2=no) Cost of Fuel for Electricity Gross Electricity

Generation (KWh) Total Sales of

Electricity (KWh)Self-Generated Electricity Usage (KWh) Purchase price,

State average ($/kWh) Lost Non-Electric

Revenues Non-Electric

Costs Shed Lost Electric

Revenues Ques. 15c Ques. 17(b) Ques. 18(a) Ques. 18(b) 18(a) - 18(b)Cost of Downtime

Electric Costs Shed Cost of Replacement Electricity (2009) Total Annual Cost of Downtime Total Weekly Cost

of Downtime Total Annual Cost ofDowntimeElectricity Only Total Weekly Cost ofDowntimeElectricity Only Self Generated Electricity Replacement Cost Revenue/Cost

for Penalty

### AEO Adjustment from

2007 to 2009

1.0591

State 2007 Industrial Prices

(cents/kWh) 2007 Industrial Prices (cents/kWh) as of 2009 AK 12.63 13.38 AL 5.27 5.58 AR 5.25 5.56 AZ 6.05 6.41 CA 9.98 10.57 CO 5.97 6.32 CT 12.92 13.68 DC 9.32 9.87 DE 8.93 9.46 FL 7.76 8.22 GA 5.53 5.86 HI 18.38 19.47 IA 4.74 5.02 ID 3.87 4.10 IL 6.61 7.00 IN 4.89 5.18 KS 5.13 5.43 KY 4.47 4.73 LA 6.77 7.17 MA 13.03 13.80 MD 9.41 9.97 ME 14.11 14.94 MI 6.47 6.85 MN 5.69 6.03 MO 4.76 5.04 MS 5.75 6.09 MT 5.16 5.46 NC 5.47 5.79 ND 5.24 5.55 NE 4.78 5.06 NH 12.27 13.00 NJ 10.08 10.68 NM 5.60 5.93 NV 8.28 8.77 NY 8.71 9.22 OH 5.76 6.10 OK 5.41 5.73 OR 5.06 5.36 PA 6.87 7.28 RI 12.04 12.75 SC 4.83 5.12 SD 5.09 5.39 TN 5.19 5.50 TX 7.79 8.25 UT 4.52 4.79 VA 5.07 5.37 VT 8.92 9.45 WA 4.57 4.84 WI 6.16 6.52 WV 3.95 4.18 WY 4.10 4.34 VI 18.38 19.47 US-TOTAL 6.39 6.77