Record for the Final Section 316(b) Existing Facilities Rule

The FileInfo worksheet contains the list of files that make up a "mock" cost and economic impact analysis model (these files should be saved to a single folder in 

order to run the model). The purpose of this "mock" model is to provide users with an opportunity to get an idea of how the actual model works. Please note, 

however, that in order to (1) avoid disclosing CBI information and (2) simplify the model to make it easier for users to input information and see how the model 

works, EPA had to make slight changes to the original cost and economic impact model. Throughout this model, GN1: Electric Generator 1 is a hypothetical 

facility with 18642: Tennessee Valley Authority as a hypothetical immediate parent and UP1: Ultimate Parent 1 as a hypothetical ultimate parent . The 

information provided for these three entities in the first row in each spreadsheet with facility-specific information (blue row) is meant to be an example to 

demonstrate how the formulas and the model in general are working. Before running the model, please update links to all linked files.

This model consists of three sets of files:

- Support Files that Generate Non-Facility Specific Information include information that is not facility specific, such as tax rates and indexes used to adjust dollar 

values. This is non-CBI information that is used throughout the cost and economic impact model.

- Support Files that Generate Baseline Facility-Specific Information include files with baseline information for regulated facilities, such as capacity, generation, 

and revenue, and information on ultimate parents. This information provides a baseline, against which the impact of regulatory requirements is measured. These 

files do not generate cost and economic impact analysis results. In one of these files, DTCosts_newIPM.xlsx, a user can input facility-specific average variable cost 

of generation per MWh to see how this information reads through the model. Enter this information in the purple worksheet in the purple-on-yellow cells. 

- Analysis Files include files that generate cost and economic impact analysis results. In three of these files, PlantData.xlsx, FirmInfo.xlsx, and CostControl.xlsx

user can input facility- and entity-specific information to see how this information reads through the model. Enter information in purple worksheets in the 

EPA-HQ-OW-2008-0667-DRAFT-3925 FileInfo 1
Record for the Final Section 316(b) Existing Facilities Rule

Contents

Input 

Data? Notes

y Specific Information

Contains adjustment factors based on Annual Energy Outlook 2012 (AEO2012). AEObased adjustment factors are used to bring revenue values to a given year.

No Does not produce analysis results. 

Contains adjustment factors based on Construction Cost Index (CCI). CCI-based 

adjustment factors are used to bring compliance technology costs to a given year.

No Does not produce analysis results. 

Contains adjustment factors based on Employment Cost Index (ECI). These adjustment 

factors are used to bring administrative cost values to a given year and state these values 

in dollars of that year.

No Does not produce analysis results. 

Contains adjustment factors based on GDP Deflator. Used to restate dollar values in the 

analysis dollar year (2011).

No Does not produce analysis results. 

Contains total tax rate (total tax = state tax + federal tax - state tax * federal tax). Used 

for estimation of after-tax compliance costs.

No Does not produce analysis results. 

Contains supplemental tables to the Annual Energy Outlook 2012. Electricity demand and 

prices by consumer type group are used for the electricity rate analysis and household 

impact analysis.

No Does not produce analysis results. 

Calculates hourly labor rates for administrative costs. No Does not produce analysis results. Used to generate facility-level administrative 

costs in the ICRCosts.xlsx file.

cility-Specific Information

Determines which 316(b) plants will retire all of their steam capacity between 2012 and 

2021.

No Does not produce analysis results. Use for demonstration purposes only.

Contains calculations of electricity prices and percent of total generated electricity sold 

based on EIA data. These estimates are used for calculation of facility-level revenue.

No Does not produce analysis results. Use for demonstration purposes only.

Determines the size of each entity owning in-scope facilities, develops entity-level 

weights, and weighted compliance costs for the entity-level cost-to-revenue and RFA 

analyses. (CBI)

No Does not produce analysis results. Use for demonstration purposes only.

Calculates total and steam electricity generation for each regulated facility using EIA 

database.

No Does not produce analysis results. Use for demonstration purposes only.

Estimates facility-level revenue. No Does not produce analysis results. Use for demonstration purposes only.

Determines facility type, total and steam capacity for in-scope facilities based on IPM and 

EIA data.

No Does not produce analysis results. Use for demonstration purposes only.

Generates weekly facility-level costs of downtime to regulated facilities (i.e., not to 

society).

Yes Does not produce analysis results. Input facility-level information in the 

Plant_VarCost worksheet.

Contains facility-level information that is used in the cost and economic impact analysis 

model. This information does not depend on a specific option. (CBI)

Yes Input facility-level information in Survey_Data and Plant_Data worksheets.

Contains information on ultimate owners of regulated facilities, including revenue, 

employment, NAICS code, and ownership type. Used for parent-level cost-to-revenue 

and RFA analyses. (CBI)

Yes Input information for ultimate parents in the ParentInfo worksheet.

This file contains the following: facility-level cost estimates for all cost options, facility 

sample weights, and compliance-year sets. This file specifies the specific option, sample 

weights, and compliance-year set to be analyzed. (CBI)

Yes Input facility-level information in ComplYrsUniv (choose technology-installation 

years from a drop-down menu, Rep&New (specify compliance costs, capacity, 

and other information for new units), and 1 (specify facility-level compliance 

Determ costs) worksheets. ines the administrative burden for regulated facilities, at the facility level, to 

comply with and for States and federal government to administer regulatory 

requirements. (CBI)

No Reads in data from other files to estimate facility-level administrative costs.

Generates facility-level and total private compliance costs. (CBI) No Reads in data from other files to estimate facility-level and total private 

compliance costs.

This file generates total costs for States and federal government to administer regulatory 

requirements using the private costs methodology. These costs are presented in Chapter 

3: Compliance Costs. (CBI)

No Reads in data from other files to estimate administrative costs for States and 

federal government.

Contains facility-level cost-to-revenue analysis for regulated facilities. Assumes that a 

facility assumes 100% of compliance costs.

No Reads in data from other files to calculate facility-level CTR.

Contains entity-level cost-to-revenue analysis and the RFA analysis. Both analyses 

assume zero cost pass through. (CBI)

No Reads in data from other files to calculate entity-level CTR.

Estimates electricity price increases across four consumer groups as the result of 

regulatory requirements. Calculations are based on the assumption of 100% cost passthrough.

No Reads in data from other files to calculate electricity price increases at the NERC 

and national levels. Because this is a market-level analysis, this file is for 

demonstration purposes only.

Contains households impact analysis. Calculations are based on the assumption of 100% 

cost pass-through.

No Reads in data from other files to calculate an average increase in annual cost per 

household at the NERC and national levels. Because this is a market-level 

analysis, this file is for demonstration purposes only.

Contains assessment of short-term reduction in capacity availability due to installation 

downtime. (CBI)

No Does not produce analysis results. Because this information is used to estimate 

total social costs (i.e., this is a market-level analysis), this file is for 

demonstration purposes only.

Calculates/estimates social cost of downtime based on the IPM results. (CBI) No Reads in data from other files. Because this is a market-level analysis, this file is 

for demonstration purposes only.

Calculates the total social costs of regulatory requirements, including costs to regulated 

facilities and costs to States and the federal government. (CBI)

No Reads in data from other files. Because this is a market-level analysis, this file is 

for demonstration purposes only. When opening this file, also open the following 

files: PlantData.xlsx, CostControl.xlsx, ICRCosts.xlsx, SocCostsDT.xlsx.

Generates social cost of carbon (SCC) values. No Reads in data from other files to calculate social cost of carbon. Because this is a 

market-level analysis, this file is for demonstration purposes only. When opening 

this file, also open the following files: PlantData.xlsx, CostControl.xlsx, 

ICRCosts.xlsx, SocCostsDT.xlsx, and SocCosts.xlsx.

EPA-HQ-OW-2008-0667-DRAFT-3925 FileDescription 1
Record for the Final Section 316(b) Existing Facilities Rule

Contents

Input 

Data? Notes

Calculates and presents information assessing the regulatory impacts in accordance with 

the Unfunded Mandates Reform Act (UMRA) (CBI)

No Reads in data from other files. Because this analysis is relevant only when 

conducted for the entire universe of analyzed facilities, this file is for 

demonstration purposes only. When opening this file, also open the following 

files: PlantData.xlsx, CostControl.xlsx, ICRCosts.xlsx, SocCostsDT.xlsx, and 

SocCosts.xlsx.

This file contains barrier-to-development analysis conducted for new capacity. No Reads in data from other files to assess barrier to development of new capacity.

EPA-HQ-OW-2008-0667-DRAFT-3925 FileDescription 2