## 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 sav ed 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 a ctu al 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 inpu t i nformation 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 linke d f iles. 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 regulator y r equirements 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**  **Support Files that Generate Non-Facility 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 com pliance 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 adm inistrative 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. **Support Files that Generate Baseline Facility-Specific Information** Determ ines which 316(b) plants will retire all of their steam capacity between 2012 and 2021. No Does not produce analysis results. Use for dem onstration 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 dem onstration purposes only.

Determ ines 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 dem onstration purposes only.

Calculates total and steam electricity generation for each regulated facility using EIA database. No Does not produce analysis results. Use for dem onstration purposes only. Estimates facility-level revenue. No Does not produce analysis results. Use for dem onstration purposes only. Determ ines facility type, total and steam capacity for in-scope facilities based on IPM and EIA data. No Does not produce analysis results. Use for dem onstration 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 mo del. 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, em ployment, 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 sam ple weights, and com

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

pliance-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 costs) worksheets. Determ ines the adm

inistrative burden for regulated facilities, at the facility level, to com ply 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 com pliance 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: Com pliance 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 ofregulatory 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 developm ent of new capacity.



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