## 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 601 2 3 4 5 6 7 8 9 10 11 12

EIA Plant ID

Facility ID Weights Costing Module Downtime

(Net Week

s) Capital Costs - IPMCapital 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 601 2

EIA Plant ID

Facility 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 TypeBL Rec?

(yes=1) DIF

(MGD) DIF

Category Total IM

Capital

Final_Costs 3 of 60EIA Plant ID Facility ID Weights Costing Module Downtime

(Net Week

s) Capital Costs - IPMCapital 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 60EIA Plant ID Facility 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 TypeBL Rec?

(yes=1) DIF

(MGD) DIF

Category Total IM

Capital

Final_Costs 5 of 60EIA Plant ID Facility ID Weights Costing Module Downtime

(Net Week

s) Capital Costs - IPMCapital 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 60EIA Plant ID Facility 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 TypeBL Rec?

(yes=1) DIF

(MGD) DIF

Category Total IM

Capital

Final_Costs 7 of 60EIA Plant ID Facility ID Weights Costing Module Downtime

(Net Week

s) Capital Costs - IPMCapital 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 60EIA Plant ID Facility 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 TypeBL Rec?

(yes=1) DIF

(MGD) DIF

Category Total IM

Capital

Final_Costs 9 of 60EIA Plant ID Facility ID Weights Costing Module Downtime

(Net Week

s) Capital Costs - IPMCapital 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 60EIA Plant ID Facility 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 TypeBL Rec?

(yes=1) DIF

(MGD) DIF

Category Total IM

Capital

Final_Costs 11 of 60EIA Plant ID Facility ID Weights Costing Module Downtime

(Net Week

s) Capital Costs - IPMCapital 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 60EIA Plant ID Facility 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 TypeBL Rec?

(yes=1) DIF

(MGD) DIF

Category Total IM

Capital

Final_Costs 13 of 60EIA Plant ID Facility ID Weights Costing Module Downtime

(Net Week

s) Capital Costs - IPMCapital 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 60EIA Plant ID Facility 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 TypeBL Rec?

(yes=1) DIF

(MGD) DIF

Category Total IM

Capital

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

EIA Plant IDFacility

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 601 2

EIA Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 60EIA

Plant IDFacility

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 - A ssigned "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 - A ssigned "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 StandardsImpingemen

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 - A ssigned "I Only" Requirements for All Facilities with DIF >10

Facility ID Facility/Inta

ke ID 

### 25

DIF (MGD) Group



### NE11BRun 32 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 35 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 38 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 41 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 44 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 47 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 50 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 53 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 56 of 60Facility 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 60Facility ID Facility/Inta ke ID Fixed Compliance O&M Pilot Study Factor Pilot Study

Costs - Initial Calc Pilot Study

Costs Performanc

e StandardsImpingemen

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 60Facility ID Facility/Inta ke ID DIF (MGD)

Group



### NE11BRun 59 of 60

### Notes 60 of 60