Author: SAIC, Tetra Tech, and Abt Associates Inc.

Date Created: 8/3/2010

Date Modified: 3/4/2011

Purpose: This file contains raw engineering costs for the IM Everywhere option (Option 1). (CBI)

File Contents:

Worksheet Contents

Notes Contains some information on how and when these costs were developed

NE11BRun Contains intake structure-level IM technology costs (engineering; raw)

Facilities_Level_Costs Sums intake structure-level costs reported in the NE11BRun worksheet to the level of the plant

Final_Costs Reads in plant-level costs from the Facilities_Level_Costs worksheet and organizes to be read into the CostControl.xls 

file

Input Files:

External data used in calculations/analysis:

PlantData.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.

FileInfo 1 of 60
1 2 3 4 5 6 7 8 9 10 11 12

EIA Plant IDFacility ID Weights

Costing 

Module

Downtime

(Net Weeks)

Capital 

Costs - IPM

Capital Costs - 

10-yr Life

Capital Costs - 

20-yr Life

Capital Costs - 

25-yr Life

Capital Costs - 

30-yr Life

CT Capital 

Costs - 30-yr 

Life

Net Total O&M Cost for 

Facility

Final_Costs 2 of 60
1 2

EIA Plant IDFacility ID

13 14 15 16 17 18 19 20 21 22 23

Net Fixed O&M Cost for 

Facility

Net Variable O&M Cost for 

Facility

Pilot 

Study 

Costs

Performance 

Standards

Impingemen

t Upgrade 

(yes=1)

Entrainmen

t Upgrade 

(yes=1)

Steam 

Plant Type

BL Rec? 

(yes=1)

DIF 

(MGD)

DIF 

Category

Total IM 

Capital

Final_Costs 3 of 60
EIA Plant IDFacility ID Weights

Costing 

Module

Downtime

(Net Weeks)

Capital 

Costs - IPM

Capital Costs - 

10-yr Life

Capital Costs - 

20-yr Life

Capital Costs - 

25-yr Life

Capital Costs - 

30-yr Life

CT Capital 

Costs - 30-yr 

Life

Net Total O&M Cost for 

Facility

Final_Costs 4 of 60
EIA Plant IDFacility ID

Net Fixed O&M Cost for 

Facility

Net Variable O&M Cost for 

Facility

Pilot 

Study 

Costs

Performance 

Standards

Impingemen

t Upgrade 

(yes=1)

Entrainmen

t Upgrade 

(yes=1)

Steam 

Plant Type

BL Rec? 

(yes=1)

DIF 

(MGD)

DIF 

Category

Total IM 

Capital

Final_Costs 5 of 60
EIA Plant IDFacility ID Weights

Costing 

Module

Downtime

(Net Weeks)

Capital 

Costs - IPM

Capital Costs - 

10-yr Life

Capital Costs - 

20-yr Life

Capital Costs - 

25-yr Life

Capital Costs - 

30-yr Life

CT Capital 

Costs - 30-yr 

Life

Net Total O&M Cost for 

Facility

Final_Costs 6 of 60
EIA Plant IDFacility ID

Net Fixed O&M Cost for 

Facility

Net Variable O&M Cost for 

Facility

Pilot 

Study 

Costs

Performance 

Standards

Impingemen

t Upgrade 

(yes=1)

Entrainmen

t Upgrade 

(yes=1)

Steam 

Plant Type

BL Rec? 

(yes=1)

DIF 

(MGD)

DIF 

Category

Total IM 

Capital

Final_Costs 7 of 60
EIA Plant IDFacility ID Weights

Costing 

Module

Downtime

(Net Weeks)

Capital 

Costs - IPM

Capital Costs - 

10-yr Life

Capital Costs - 

20-yr Life

Capital Costs - 

25-yr Life

Capital Costs - 

30-yr Life

CT Capital 

Costs - 30-yr 

Life

Net Total O&M Cost for 

Facility

Final_Costs 8 of 60
EIA Plant IDFacility ID

Net Fixed O&M Cost for 

Facility

Net Variable O&M Cost for 

Facility

Pilot 

Study 

Costs

Performance 

Standards

Impingemen

t Upgrade 

(yes=1)

Entrainmen

t Upgrade 

(yes=1)

Steam 

Plant Type

BL Rec? 

(yes=1)

DIF 

(MGD)

DIF 

Category

Total IM 

Capital

Final_Costs 9 of 60
EIA Plant IDFacility ID Weights

Costing 

Module

Downtime

(Net Weeks)

Capital 

Costs - IPM

Capital Costs - 

10-yr Life

Capital Costs - 

20-yr Life

Capital Costs - 

25-yr Life

Capital Costs - 

30-yr Life

CT Capital 

Costs - 30-yr 

Life

Net Total O&M Cost for 

Facility

Final_Costs 10 of 60
EIA Plant IDFacility ID

Net Fixed O&M Cost for 

Facility

Net Variable O&M Cost for 

Facility

Pilot 

Study 

Costs

Performance 

Standards

Impingemen

t Upgrade 

(yes=1)

Entrainmen

t Upgrade 

(yes=1)

Steam 

Plant Type

BL Rec? 

(yes=1)

DIF 

(MGD)

DIF 

Category

Total IM 

Capital

Final_Costs 11 of 60
EIA Plant IDFacility ID Weights

Costing 

Module

Downtime

(Net Weeks)

Capital 

Costs - IPM

Capital Costs - 

10-yr Life

Capital Costs - 

20-yr Life

Capital Costs - 

25-yr Life

Capital Costs - 

30-yr Life

CT Capital 

Costs - 30-yr 

Life

Net Total O&M Cost for 

Facility

Final_Costs 12 of 60
EIA Plant IDFacility ID

Net Fixed O&M Cost for 

Facility

Net Variable O&M Cost for 

Facility

Pilot 

Study 

Costs

Performance 

Standards

Impingemen

t Upgrade 

(yes=1)

Entrainmen

t Upgrade 

(yes=1)

Steam 

Plant Type

BL Rec? 

(yes=1)

DIF 

(MGD)

DIF 

Category

Total IM 

Capital

Final_Costs 13 of 60
EIA Plant IDFacility ID Weights

Costing 

Module

Downtime

(Net Weeks)

Capital 

Costs - IPM

Capital Costs - 

10-yr Life

Capital Costs - 

20-yr Life

Capital Costs - 

25-yr Life

Capital Costs - 

30-yr Life

CT Capital 

Costs - 30-yr 

Life

Net Total O&M Cost for 

Facility

Final_Costs 14 of 60
EIA Plant IDFacility ID

Net Fixed O&M Cost for 

Facility

Net Variable O&M Cost for 

Facility

Pilot 

Study 

Costs

Performance 

Standards

Impingemen

t Upgrade 

(yes=1)

Entrainmen

t Upgrade 

(yes=1)

Steam 

Plant Type

BL Rec? 

(yes=1)

DIF 

(MGD)

DIF 

Category

Total IM 

Capital

Final_Costs 15 of 60
1 2 3 4 5 6 7 8 9 10 11 12 13 14

EIA Plant ID

Facility 

ID

Num of Intake 

Structures w/o 

Recirculating 

System Weights

Costing 

Module

Downtim

e (Net 

Weeks)

Baseline 

O&M

Gross 

Module O&M

Capital 

Costs - IPM

Capital 

Costs - 

10 - yr 

Life

Capital Costs - 20-

yr Life

Capital Costs 

- 25-yr Life

Capital Costs 

- 30-yr Life

CT Capital 

Costs - 30-yr 

Life

Facility_Level_Costs 16 of 60
1 2

EIA Plant ID

Facility 

ID

15 16 17 18 19 20 21 22 23

Compliance 

Net Annual 

O&M

Fixed 

Baseline O&M

Fixed 

Compliance 

O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performance 

Standards

Impingement 

Upgrade 

(Yes=1)

Entrainmen

t Upgrade 

(Yes=1)

Facility_Level_Costs 17 of 60
EIA Plant ID

Facility 

ID

Num of Intake 

Structures w/o 

Recirculating 

System Weights

Costing 

Module

Downtim

e (Net 

Weeks)

Baseline 

O&M

Gross 

Module O&M

Capital 

Costs - IPM

Capital 

Costs - 

10 - yr 

Life

Capital Costs - 20-

yr Life

Capital Costs 

- 25-yr Life

Capital Costs 

- 30-yr Life

CT Capital 

Costs - 30-yr 

Life

Facility_Level_Costs 18 of 60
EIA Plant ID

Facility 

ID

Compliance 

Net Annual 

O&M

Fixed 

Baseline O&M

Fixed 

Compliance 

O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performance 

Standards

Impingement 

Upgrade 

(Yes=1)

Entrainmen

t Upgrade 

(Yes=1)

Facility_Level_Costs 19 of 60
EIA Plant ID

Facility 

ID

Num of Intake 

Structures w/o 

Recirculating 

System Weights

Costing 

Module

Downtim

e (Net 

Weeks)

Baseline 

O&M

Gross 

Module O&M

Capital 

Costs - IPM

Capital 

Costs - 

10 - yr 

Life

Capital Costs - 20-

yr Life

Capital Costs 

- 25-yr Life

Capital Costs 

- 30-yr Life

CT Capital 

Costs - 30-yr 

Life

Facility_Level_Costs 20 of 60
EIA Plant ID

Facility 

ID

Compliance 

Net Annual 

O&M

Fixed 

Baseline O&M

Fixed 

Compliance 

O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performance 

Standards

Impingement 

Upgrade 

(Yes=1)

Entrainmen

t Upgrade 

(Yes=1)

Facility_Level_Costs 21 of 60
EIA Plant ID

Facility 

ID

Num of Intake 

Structures w/o 

Recirculating 

System Weights

Costing 

Module

Downtim

e (Net 

Weeks)

Baseline 

O&M

Gross 

Module O&M

Capital 

Costs - IPM

Capital 

Costs - 

10 - yr 

Life

Capital Costs - 20-

yr Life

Capital Costs 

- 25-yr Life

Capital Costs 

- 30-yr Life

CT Capital 

Costs - 30-yr 

Life

Facility_Level_Costs 22 of 60
EIA Plant ID

Facility 

ID

Compliance 

Net Annual 

O&M

Fixed 

Baseline O&M

Fixed 

Compliance 

O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performance 

Standards

Impingement 

Upgrade 

(Yes=1)

Entrainmen

t Upgrade 

(Yes=1)

Facility_Level_Costs 23 of 60
EIA Plant ID

Facility 

ID

Num of Intake 

Structures w/o 

Recirculating 

System Weights

Costing 

Module

Downtim

e (Net 

Weeks)

Baseline 

O&M

Gross 

Module O&M

Capital 

Costs - IPM

Capital 

Costs - 

10 - yr 

Life

Capital Costs - 20-

yr Life

Capital Costs 

- 25-yr Life

Capital Costs 

- 30-yr Life

CT Capital 

Costs - 30-yr 

Life

Facility_Level_Costs 24 of 60
EIA Plant ID

Facility 

ID

Compliance 

Net Annual 

O&M

Fixed 

Baseline O&M

Fixed 

Compliance 

O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performance 

Standards

Impingement 

Upgrade 

(Yes=1)

Entrainmen

t Upgrade 

(Yes=1)

Facility_Level_Costs 25 of 60
EIA Plant ID

Facility 

ID

Num of Intake 

Structures w/o 

Recirculating 

System Weights

Costing 

Module

Downtim

e (Net 

Weeks)

Baseline 

O&M

Gross 

Module O&M

Capital 

Costs - IPM

Capital 

Costs - 

10 - yr 

Life

Capital Costs - 20-

yr Life

Capital Costs 

- 25-yr Life

Capital Costs 

- 30-yr Life

CT Capital 

Costs - 30-yr 

Life

Facility_Level_Costs 26 of 60
EIA Plant ID

Facility 

ID

Compliance 

Net Annual 

O&M

Fixed 

Baseline O&M

Fixed 

Compliance 

O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performance 

Standards

Impingement 

Upgrade 

(Yes=1)

Entrainmen

t Upgrade 

(Yes=1)

Facility_Level_Costs 27 of 60
EIA Plant ID

Facility 

ID

Num of Intake 

Structures w/o 

Recirculating 

System Weights

Costing 

Module

Downtim

e (Net 

Weeks)

Baseline 

O&M

Gross 

Module O&M

Capital 

Costs - IPM

Capital 

Costs - 

10 - yr 

Life

Capital Costs - 20-

yr Life

Capital Costs 

- 25-yr Life

Capital Costs 

- 30-yr Life

CT Capital 

Costs - 30-yr 

Life

Facility_Level_Costs 28 of 60
EIA Plant ID

Facility 

ID

Compliance 

Net Annual 

O&M

Fixed 

Baseline O&M

Fixed 

Compliance 

O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performance 

Standards

Impingement 

Upgrade 

(Yes=1)

Entrainmen

t Upgrade 

(Yes=1)

Facility_Level_Costs 29 of 60
1 2 3 4 5 6 7 8 9 10 11 12

 Power Plant Compliance Costs - Assigned "I Only" Requirements for All Facilities with DIF >10

Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 30 of 60
1 2

 Power Plant Compliance Costs - Assigned "I Only" Requirements for All Facilities with DIF >10

Facility ID

Facility/Inta

ke ID

13 14 15 16 17 18 19 20 21 22 23 24

Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 31 of 60
1 2

 Power Plant Compliance Costs - Assigned "I Only" Requirements for All Facilities with DIF >10

Facility ID

Facility/Inta

ke ID

25

DIF (MGD) 

Group

NE11BRun 32 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 33 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 34 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 35 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 36 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 37 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 38 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 39 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 40 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 41 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 42 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 43 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 44 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 45 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 46 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 47 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 48 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 49 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 50 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 51 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 52 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 53 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 54 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 55 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 56 of 60
Facility ID

Facility/Inta

ke ID

Weighting 

Factor Waterbody

Primary 

Costing 

Module

Service Life 

(years)

Downtime 

Duration 

(net, weeks) Baseline O&M Gross Module O&M

Compliance Tech 

Capital Compliance Net Annual O&M

Fixed Baseline 

O&M

NE11BRun 57 of 60
Facility ID

Facility/Inta

ke ID Fixed Compliance O&M

Pilot Study 

Factor

Pilot Study 

Costs - Initial 

Calc

Pilot Study 

Costs

Performanc

e Standards

Impingemen

t Upgrade

Entrainment 

Upgrade

Larger 

Intake to 

Existing 

Screen 

Width Ratio* SUMIF

Design Flow 

for Traveling 

Screens (gpm)

New Design 

Flow for Other 

Technology* 

(gpm)

Performance 

Standards 

CCRS? (1=yes)

NE11BRun 58 of 60
Facility ID

Facility/Inta

ke ID

DIF (MGD) 

Group

NE11BRun 59 of 60
Notes 60 of 60