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

SurveyID

Total Weekly Cost of 

Downtime

Total Weekly Cost of Downtime, 

Electricity Only

Cost/Revenue for 

Energy Penalty
1 2 3 4

SurveyID

Total Weekly Cost of 

Downtime

Total Weekly Cost of Downtime, 

Electricity Only

Cost/Revenue for 

Energy Penalty
1 2 3 4

SurveyID

Total Weekly Cost of 

Downtime

Total Weekly Cost of Downtime, 

Electricity Only

Cost/Revenue for 

Energy Penalty
1 2 3 4

SurveyID

Total 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. 14
20 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 of 

DowntimeElectricity Only

Total Weekly Cost of 

DowntimeElectricity Only

Self Generated 

Electricity 

Replacement 

Cost

Revenue/Cost 

for Penalty
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. 14
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)
Cost of Downtime

Electric Costs Shed

Cost of Replacement 

Electricity (2009)

Total Annual Cost 

of Downtime

Total Weekly Cost 

of Downtime

Total Annual Cost of 

DowntimeElectricity Only

Total Weekly Cost of 

DowntimeElectricity Only

Self Generated 

Electricity 

Replacement 

Cost

Revenue/Cost 

for Penalty
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. 14
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)
Cost of Downtime

Electric Costs Shed

Cost of Replacement 

Electricity (2009)

Total Annual Cost 

of Downtime

Total Weekly Cost 

of Downtime

Total Annual Cost of 

DowntimeElectricity Only

Total Weekly Cost of 

DowntimeElectricity Only

Self Generated 

Electricity 

Replacement 

Cost

Revenue/Cost 

for Penalty
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. 14
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)
Cost of Downtime

Electric Costs Shed

Cost of Replacement 

Electricity (2009)

Total Annual Cost 

of Downtime

Total Weekly Cost 

of Downtime

Total Annual Cost of 

DowntimeElectricity Only

Total Weekly Cost of 

DowntimeElectricity Only

Self Generated 

Electricity 

Replacement 

Cost

Revenue/Cost 

for Penalty
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. 14
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)
Cost of Downtime

Electric Costs Shed

Cost of Replacement 

Electricity (2009)

Total Annual Cost 

of Downtime

Total Weekly Cost 

of Downtime

Total Annual Cost of 

DowntimeElectricity Only

Total Weekly Cost of 

DowntimeElectricity Only

Self Generated 

Electricity 

Replacement 

Cost

Revenue/Cost 

for Penalty
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. 14
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)
Cost of Downtime

Electric Costs Shed

Cost of Replacement 

Electricity (2009)

Total Annual Cost 

of Downtime

Total Weekly Cost 

of Downtime

Total Annual Cost of 

DowntimeElectricity Only

Total Weekly Cost of 

DowntimeElectricity Only

Self Generated 

Electricity 

Replacement 

Cost

Revenue/Cost 

for Penalty
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. 14
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)
Cost of Downtime

Electric Costs Shed

Cost of Replacement 

Electricity (2009)

Total Annual Cost 

of Downtime

Total Weekly Cost 

of Downtime

Total Annual Cost of 

DowntimeElectricity Only

Total Weekly Cost of 

DowntimeElectricity 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