Document ID: EPA-HQ-OW-2008-0055-0464
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2008-12-29T05:00Z

Project: Vessels Distributional Impact Analysis

Filename	Creation Date/

Author	Inputs	Outputs	Purpose/Comments

*New Inputs_with NAICS 213111_11.25.08.xls	11.25.08/

Matt LaPenta	-Cost Elements from cost analysis

-Number of vessels by vessel class and NAICS is determined from the
Vessel database

-the number of firms by NAICS and the low, high, and average revenue for
each NAICS and revenue range is from Census/SBA.

-the average number of vessels per firm is from the Vessel database 
None.	See  xls file descriptions for descriptions of the sheets.

*Distribution Analysis Inputs NEW infile.xls	11.21.08/

Matt LaPenta	*New Inputs_with NAICS 213111_11.21.08.xls	*New Inputs_with
NAICS 213111_11.21.08.xls

“Infile” sheet	Costs by vessel class.

*Distribution Analysis Inputs NEW NAICSnum.xls	11.21.08/

Matt LaPenta	*New Inputs_with NAICS 213111_11.21.08.xls	*New Inputs_with
NAICS 213111_11.21.08.xls

“NAICSnum” sheet	Number of vessels by revenue size category.

*Distribution Analysis Inputs NEW NAICSthresh.xls	11.21.08/

Matt LaPenta	*New Inputs_with NAICS 213111_11.21.08.xls	*New Inputs_with
NAICS 213111_11.21.08.xls

“NAICSthresh” sheet	Revenue thresholds data.

*Distribution Analysis Inputs NEW NAICSWEIGHTS.xls	11.21.08/

Matt LaPenta	*New Inputs_with NAICS 213111_11.21.08.xls	*New Inputs_with
NAICS 213111_11.21.08.xls

“NAICSWEIGHTS” sheet	Number of vessels by NAICS and vessel type.

**DistAnal11samp21NOV1_v1.sas	02.08.08/

Matt LaPenta	*Distribution Analysis Inputs NEW infile.xls

*Distribution Analysis Inputs NEW NAICSnum.xls

*Distribution Analysis Inputs NEW NAICSthresh.xls

*Distribution Analysis Inputs NEW NAICSWEIGHTS.xls
***DAO11_Highthresholds_DF.xls

***DAO11_Highthresholds_DP.xls

***DAO11_Highthresholds_FF.xls

***DAO11_Highthresholds_IF.xls

***DAO11_Highthresholds_IP.xls

***DAO11_Highthresholds_MC.xls

***DAO11_Highthresholds_NS.xls

***DAO11_Highthresholds_OT.xls

***DAO11_Highthresholds_PH.xls

***DAO11_Highthresholds_SS.xls

***DAO11_Lowthresholds_DF.xls

***DAO11_Lowthresholds_DP.xls

***DAO11_Lowthresholds_FF.xls

***DAO11_Lowthresholds_IF.xls

***DAO11_Lowthresholds_IP.xls

***DAO11_Lowthresholds_MC.xls

***DAO11_Lowthresholds_NS.xls

***DAO11_Lowthresholds_OT.xls

***DAO11_Lowthresholds_PH.xls

***DAO11_Lowthresholds_SS.xls

***Dist11_High_DF.xls

***Dist11_High_DP.xls

***Dist11_High_FF.xls

***Dist11_High_IF.xls

***Dist11_High_IP.xls

***Dist11_High_MC.xls

***Dist11_High_NS.xls

***Dist11_High_OT.xls

***Dist11_High_PH.xls

***Dist11_High_SS.xls

***Dist11_Low_DF.xls

***Dist11_Low_DP.xls

***Dist11_Low_FF.xls

***Dist11_Low_IF.xls

***Dist11_Low_IP.xls

***Dist11_Low_MC.xls

***Dist11_Low_NS.xls

***Dist11_Low_OT.xls

***Dist11_Low_PH.xls

***Dist11_Low_SS.xls

	The program calculates the distribution of firm cost impacts by sector
and revenue bracket assuming 11 possible vessel costs per vessel class. 
The percentage of firms with impacts exceeding 1% and 3% of their
revenue is also calculated.  

Note: These are the abbreviations used for the NAICS:

DF 483111/483113

FF 11411

DP 483112/483114

IF 483211

IP 483212

SS 487210

PH 488310

MC 488320

NS 488330

OT 488390

**DistAnal101samp21NOV_v1.sas	02.08.08/

Matt LaPenta	*Distribution Analysis Inputs NEW infile.xls

*Distribution Analysis Inputs NEW NAICSnum.xls

*Distribution Analysis Inputs NEW NAICSthresh.xls

*Distribution Analysis Inputs NEW NAICSWEIGHTS.xls
****DAO101_Highthresholds_DP.xls

****Dist101_High_DP.xls

****DAO101_Lowthresholds_DP.xls

****Dist101_Low_DP.xls	The program calculates the distribution of firm
cost impacts by sector and revenue bracket assuming 101 possible vessel
costs per vessel class.  The percentage of firms with impacts exceeding
1% and 3% of their revenue is also calculated.  

**Distexact21NOV_v1.sas	02.08.08/

Matt LaPenta	*Distribution Analysis Inputs NEW infile.xls

*Distribution Analysis Inputs NEW NAICSnum.xls

*Distribution Analysis Inputs NEW NAICSthresh.xls

*Distribution Analysis Inputs NEW NAICSWEIGHTS.xls	*****OHighComm.xls

*****OHighUtility.xls

*****OLowComm.xls

*****OLowUtility.xls	There are 16 low-cost and 21 high-cost practices
required of vessels subject to the discharge rule.

For each individual practice there is a probability that an incremental
cost is incurred under a rule scenario.  This program calculates the
probability that incremental costs are incurred for each possible
combination of practices (assuming that the probability of incurring
incremental costs is independent across practices).  Data are exported
to excel that show, for each vessel type,  the practice combination, the
number of vessels for the practice combination, the probability of a
practice combination, the per-vessel cost of a practice combination, and
the total costs associated  with a practice combination;

******CF and PH Exact Results_11.21.08.xls	11.21.08/ Matt LaPenta &
Lauren Tikusis	Outputs from **Distexact21NOV_v1.sas	Outputs go into
******Distribution Analysis Output_11.21.08.xls	To organize the
percentage and number of firms with impacts exceeding 1% and 3% of their
revenue for the NAICS with one vessel class.

******Distribution Analysis Output_11.21.08.xls	11.21.08/ Matt LaPenta &
Lauren Tikusis	Outputs from **DistAnal11samp21NOV1_v1.sas  re: the
percentage of firms with impacts exceeding 1% and 3% of their revenue 
Outputs go into ****** Firm Analysis Results_11.21.08.xls	To organize
the percentage and number of firms with impacts exceeding 1% and 3% of
their revenue for the NAICS with more than one vessel class.

******Firm Analysis Results_11.21.08.xls	11.21.08/ Matt LaPenta & Lauren
Tikusis	Outputs from **DistAnal11samp21NOV1_v1.sas  re: distribution of
firm cost impacts by sector and revenue bracket	Tables/Graphs for report
To organize the results from ******Distribution Analysis
Output_11.21.08.xls and to organize the distribution of firm cost
impacts by sector and revenue bracket 

File Locations:

*\SAS Analysis.11.21.08\Inputs

**\SAS Analysis.11.21.08\Programs

***\SAS Analysis.11.21.08\Outputs\SAMP 11 11.21.08

****\SAS Analysis.11.21.08\Outputs\SAMP 101 11.21.08

*****\SAS Analysis.11.21.08\Outputs\Exact 11.21.08

******\SAS Analysis.11.21.08\Outputs