Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
4
5
A
B
C
D
Date
Modified:
3/
10/
2003
By:
Abt
Associates
Inc.
Data
Sources:
Compliance
cost
estimates;
Form
EIA­
861;
DUNS
database;
Section
316(
b)
Industry
Survey
Description:
Calculates
the
firm­
level
cost­
to­
revenue
ratios
for
the
preferred
option
and
the
waterbody/
capacity­
based
option
March
10,
2003
1
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
File
Info
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
12
3
4
56789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
A
B
NODA
Analysis
­
Preferred
Option
Number
Of
Firms
<
0.5%
=
COUNTIF('
Firm
Level
Data'!$
P$
3:$
P$
130,
A6)
0.5­
1%
=
COUNTIF('
Firm
Level
Data'!$
P$
3:$
P$
130,
A7)
1­
3%
=
COUNTIF('
Firm
Level
Data'!$
P$
3:$
P$
130,
A8)
>'=
3%
=
COUNTIF('
Firm
Level
Data'!$
P$
3:$
P$
130,
A9)
BC
Total
=
SUM(
B6:
B9)
MIN
=
MIN('
Firm
Level
Data'!
O3:
O130)
MAX
=
MAX('
Firm
Level
Data'!
O3:
O130)

Memo
Table
12
Entity
Type
Total
Number
of
Facilities
Private
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
A20,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Federal
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
A21,'
Firm
Level
Data'!$
G$
3:$
G$
130)
State
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
A22,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Sub­
Division
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
A23,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Municipal
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
A24,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Municipal
Mrkt
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
A25,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Cooperative
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
A26,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Total
'=
SUM(
B20:
B26)

Count
of
Unique
Entity
Compliance
Cost
to
Entity
Sales
Ratio
Range
Entity
Type
<
0.5%
Private
68
Federal
1
State
4
Sub­
Division
3
Municipal
15
Municipal
Mrkt
2
Cooperative
14
Grand
Total
107
Min
of
Total
Facility
Compliance
Costs
to
Entity
Sales
Ratio
Entity
Type
Total
Private
0.00%
Federal
0.16%
State
0.02%
Sub­
Division
0.11%
Municipal
0.04%
Municipal
Mrkt
0.06%
Cooperative
0.18%
Grand
Total
0.00%

March
10,
2003
2
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Summary
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
12
3
4
56789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
C
D
E
F
G
H
%
Proposal
%
=
B6/$
B$
11
104
=
D6/$
D$
11
=
B7/$
B$
11
12
=
D7/$
D$
11
=
B8/$
B$
11
10
=
D8/$
D$
11
=
B9/$
B$
11
3
=
D9/$
D$
11
2
=
D10/$
D$
11
=
B11/$
B$
11
131
=
D11/$
D$
11
0.002%
5.286%

Firm­
Level
Cost­
to­
Revenue
Measure
by
Entity
Type
for
the
Preferred
Option
Number
of
Firms
with
a
Ratio
of
Total
Number
of
Firms
<
0.5%
0.5­
1%
1
­
3%
>
3%
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
A20)
'=
B32
'=
C32
'=
D32
'=
E32
'=
B44
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
A21)
'=
B33
'=
C33
'=
D33
'=
E33
'=
B45
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
A22)
'=
B34
'=
C34
'=
D34
'=
E34
'=
B46
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
A23)
'=
B35
'=
C35
'=
D35
'=
E35
'=
B47
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
A24)
'=
B36
'=
C36
'=
D36
'=
E36
'=
B48
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
A25)
'=
B37
'=
C37
'=
D37
'=
E37
'=
B49
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
A26)
'=
B38
'=
C38
'=
D38
'=
E38
'=
B50
'=
SUM(
C20:
C26)
'=
SUM(
D20:
D26)
'=
SUM(
E20:
E26)
'=
SUM(
F20:
F26)
'=
SUM(
G20:
G26)
'=
MIN(
H20:
H26)

0.5­
1%
1­
3%
>'=
3%
Grand
Total
1
1
70
1
4
1
4
6
9
2
32
2
1
15
8
11
2
128
Max
of
Total
Facility
Compliance
Costs
to
Entity
Sales
Ratio
Entity
Type
Total
Private
1.07%
Federal
0.16%
State
0.32%
Sub­
Division
1.32%
Municipal
7.36%
Municipal
Mrkt
0.44%
Cooperative
0.69%
Grand
Total
7.36%
Proposal
data
is
from
Docket
W­
00­
32,
DCN
4­
3033
sheet
"
Summary"

Minimum
Ratio
March
10,
2003
3
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Summary
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
12
3
4
56789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
I
'=
E44
'=
E45
'=
E46
'=
E47
'=
E48
'=
E49
'=
E50
'=
MAX(
I20:
I26)
Maximum
Ratio
March
10,
2003
4
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Summary
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
12
3
4
56789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
J
K
L
M
NODA
Analysis
­
Waterbody/
Capacity­
Based
Option
Number
of
Firms
<
0.5%
=
COUNTIF('
Firm
Level
Data'!$
S$
3:$
S$
130,
L6)
0.5­
1%
=
COUNTIF('
Firm
Level
Data'!$
S$
3:$
S$
130,
L7)
1­
3%
=
COUNTIF('
Firm
Level
Data'!$
S$
3:$
S$
130,
L8)
>'=
3%
=
COUNTIF('
Firm
Level
Data'!$
S$
3:$
S$
130,
L9)
BC
Total
=
SUM(
M6:
M9)
MIN
=
MIN('
Firm
Level
Data'!
R3:
R130)
MAX
'=
MAX('
Firm
Level
Data'!
R3:
R130)

Memo
Table
13
Firm­
Level
Cost­
to­
Revenue
Measure
by
Entity
Type
for
Waterbody/
Entity
Type
Total
Number
of
Facilities
Private
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
L20,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Federal
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
L21,'
Firm
Level
Data'!$
G$
3:$
G$
130)
State
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
L22,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Sub­
Division
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
L23,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Municipal
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
L24,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Municipal
Mrkt
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
L25,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Cooperative
'=
SUMIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
L26,'
Firm
Level
Data'!$
G$
3:$
G$
130)
Total
'=
SUM(
M20:
M26)

Count
of
Entity
Type
Compliance
Cost
to
Entity
Sales
Ratio
Range2
Entity
Type
<
0.5%
Private
58
Federal
1
State
3
Sub­
Division
3
Municipal
14
Municipal
Mrkt
2
Cooperative
14
Grand
Total
95
Min
of
Total
Facility
Compliance
Costs
to
Entity
Sales
Ratio2
Entity
Type
Total
Private
0.00%
Federal
0.16%
State
0.02%
Sub­
Division
0.11%
Municipal
0.04%
Municipal
Mrkt
0.06%
Cooperative
0.18%
Grand
Total
0.00%

March
10,
2003
5
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Summary
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
12
3
4
56789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
N
O
P
Q
R
S
%
Proposal
%
=
M6/$
B$
11
108
=
O6/$
O$
11
=
M7/$
B$
11
12
=
O7/$
O$
11
=
M8/$
B$
11
6
=
O8/$
O$
11
=
M9/$
B$
11
3
=
O9/$
O$
11
2
=
O10/$
O$
11
=
M11/$
B$
11
131
=
O11/$
O$
11
0.001%
5.442%

Firm­
Level
Cost­
to­
Revenue
Measure
by
Entity
Type
for
Waterbody/
Capacity­
Based
Option
Number
of
Firms
with
a
Ratio
of
Total
Number
of
Firms
<
0.5%
0.5­
1%
1
­
3%
>
3%
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
L20)
'=
M32
'=
N32
'=
O32
'=
P32
'=
M44
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
L21)
'=
M33
'=
N33
'=
O33
'=
P33
'=
M45
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
L22)
'=
M34
'=
N34
'=
O34
'=
P34
'=
M46
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
L23)
'=
M35
'=
N35
'=
O35
'=
P35
'=
M47
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
L24)
'=
M36
'=
N36
'=
O36
'=
P36
'=
M48
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
L25)
'=
M37
'=
N37
'=
O37
'=
P37
'=
M49
'=
COUNTIF('
Firm
Level
Data'!$
F$
3:$
F$
130,
Summary!
L26)
'=
M38
'=
N38
'=
O38
'=
P38
'=
M50
'=
SUM(
N20:
N26)
'=
SUM(
O20:
O26)
'=
SUM(
P20:
P26)
'=
SUM(
Q20:
Q26)
'=
SUM(
R20:
R26)
'=
MIN(
S20:
S26)

0.5­
1%
1­
3%
>'=
3%
Grand
Total
7
5
70
1
1
4
1
4
7
9
2
32
2
1
15
16
15
2
128
Max
of
Total
Facility
Compliance
Costs
to
Entity
Sales
Ratio2
Entity
Type
Total
Private
2.20%
Federal
0.16%
State
0.63%
Sub­
Division
1.32%
Municipal
7.36%
Municipal
Mrkt
0.46%
Cooperative
0.71%
Grand
Total
7.36%
Minimum
Ratio
Proposal
data
is
from
Docket
W­
00­
32,
DCN
4­
3033
sheet
"
Summary"

March
10,
2003
6
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Summary
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
12
3
4
56789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
T
'=
P44
'=
P45
'=
P46
'=
P47
'=
P48
'=
P49
'=
P50
'=
MAX(
T20:
T26)
Maximum
Ratio
March
10,
2003
7
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Summary
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
A
B
C
D
Unique
Entity
Utility
Code
DUNS
NAME
DUNS
NUMBER
Alabama
Electric
Coop
Inc
=(
VLOOKUP(
A3,'
316(
b)
Facilities
­
Phase
II'!$
D$
3:$
E$
542,2,0))
Alabama
Electric
Cooperative
Inc
6900005
No
new
equations
through
row
130.
Values
can
be
found
in
P2
NODA
Firm
Level
Analysis­
N.
pdf
March
10,
2003
8
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
E
F
SIC
Code
­
D&
B
Entity
Type
=
IF(
ISNA((
VLOOKUP(
C3,'
DUNS
Pull'!$
D$
3:$
Q$
126,14,0))),"",
VLOOKUP(
C3,'
DUNS
Pull'!$
D$
3:$
Q$
126,14,0))
=
VLOOKUP($
A3,'
Unique
Entities'!$
B$
6:$
D$
133,3,0)

March
10,
2003
9
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
G
H
Number
of
Facilities
(
Weighted)
Entity
Sales
(
Source:
D&
B
Database,
$
2002)

=
SUMIF('
316(
b)
Facilities
­
Phase
II'!$
D$
3:$
D$
542,
A3,'
316(
b)
Facilities
­
Phase
II'!$
C$
3:$
C$
542)
=
IF(
ISNA(
VLOOKUP(
D3,'
DUNS
Pull'!$
B$
3:$
S$
128,18,0)),"",(
IF(((
VLOOKUP(
D3,'
DUNS
Pull'!$
B$
3:$
S$
128,18,
FALSE))<
1),"",(
VLOOKUP(
D3,'
DUNS
Pull'!$
B$
3:$
S$
128,18,0)))))
=
SUM(
G3:
G130)

March
10,
2003
10
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
I
J
861
Revenues
1997­
1999
Average
($
2002)
DQ
Data
(
Non­
Utilities)
($
2002)

=
IF(
ISNA(
VLOOKUP(
B3,'[
P2
NODA
861
Data.
xls]
Average
Revenues'!$
A$
3:$
J$
179,9,0)),"",
VLOOKUP(
B3,'[
P2
NODA
861
Data.
xls]
Average
Revenues'!$
A$
3:$
J$
179,9,0))
=
IF(
ISNA(
VLOOKUP(
A3,'
Noutility
Firm
Revenues
­
DQ'!$
C$
3:$
P$
15,14,0)),"",
VLOOKUP(
A3,'
Noutility
Firm
Revenues
­
DQ'!$
C$
3:$
P$
15,14,0))

March
10,
2003
11
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
K
L
Manual
Data
Final
Entity
Sales
=
IF(
K3>
0,
K3,
IF(
AND(
H3'="",
I3'=""),
J3,
IF(
AND(
F3'="
Private",
H3<>""),
H3,
IF(
AND(
F3<>"
Priv
ate",
I3'=""),
H3,
I3))))

March
10,
2003
12
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
M
N
Revenue
Source
Total
Annualized
Facility
Compliance
Costs
by
Entity
=
IF(
L3'=
H3,"
D&
B",
IF(
L3'=
I3,"
EIA",
IF(
L3'=
J3,"
DQ",
IF(
L3'=
K3,"
Manual","
WRONG"))))
=
SUMIF('
316(
b)
Facilities
­
Phase
II'!$
D$
3:$
D$
542,
A3,'
316(
b)
Facilities
­
Phase
II'!$
H$
3:$
H$
542)
=
SUM(
N3:
N130)

March
10,
2003
13
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
O
P
NODA
Analysis
­
Preferred
Option
Total
Facility
Compliance
Costs
to
Entity
Sales
Ratio
Compliance
Cost
to
Entity
Sales
Ratio
Range
=
IF(
L3'="","",
IF(
N3'=
0,"",
N3/
L3))
=
IF(
O3'="","
BC",(
IF(
AND(
O3>'=
0.005,
O3<
0.01),"
0.5­
1%",
IF(
O3<
0.005,"
<
0.5%",
IF(
O3>'=
0.03,"
>'=
3%","
1­
3%")))))

March
10,
2003
14
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
Q
R
NODA
Analysis
­
WBC
Option
Total
Annualized
Facility
Compliance
Costs
by
Entity
Total
Facility
Compliance
Costs
to
Entity
Sales
Ratio
=
SUMIF('
316(
b)
Facilities
­
Phase
II'!$
D$
3:$
D$
542,
A3,'
316(
b)
Facilities
­
Phase
II'!$
J$
3:$
J$
542)
=
IF(
L3'="","",
IF(
Q3'=
0,"",
Q3/
L3))
=
SUM(
Q3:
Q130)

March
10,
2003
15
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
131
S
Analysis
­
WBC
Option
Compliance
Cost
to
Entity
Sales
Ratio
Range
=
IF(
R3'="","
BC",(
IF(
AND(
R3>'=
0.005,
R3<
0.01),"
0.5­
1%",
IF(
R3<
0.005,"
<
0.5%",
IF(
R3>'=
0.03,"
>'=
3%","
1­
3%")))))

March
10,
2003
16
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Firm
Level
Data
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
543
544
A
B
C
EIA
Plant
Code
Plant
Name
Weight
335
Huntington
Beach
=
VLOOKUP(
A3,'[
P2
NODA
Econ
Data.
xls]
General
Data'!$
A$
4:$
N$
543,3,0)
=
SUM(
C3:
C542)
No
new
equations
from
row
3
through
542.
Values
can
be
found
in
P2
NODA
Firm
Level
Analysis­
N.
pdf
March
10,
2003
17
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
316(
b)
Facilities
­
Phase
II
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
543
544
D
E
Final
Parent
Name
EIA
Utility
Code
(
1999)

=
VLOOKUP($
A3,'[
P2
NODA
Parent
Information
­
All.
xls]
Final
Parent
Info'!$
A$
2:$
F$
541,4,0)
17609
March
10,
2003
18
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
316(
b)
Facilities
­
Phase
II
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
543
544
F
G
NODA
Analysis
­
Preferred
Option
Final
Parent
Type
2008
Baseline
Closures
=
PROPER(
VLOOKUP($
A3,'[
P2
NODA
Parent
Information
­
All.
xls]
Final
Parent
Info'!$
A$
2:$
F$
541,6,0))
=
VLOOKUP($
A3,'[
P2
NODA
Analysis­
Preferred
Option.
xls]
National
Cost'!$
A$
7:$
BF$
546,58,0)

March
10,
2003
19
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
316(
b)
Facilities
­
Phase
II
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
543
544
H
I
NODA
Analysis
­
Preferred
Option
NODA
Analysis
­
Waterbody/
Capacity­
Based
Annualized
Facility
Compliance
Costs
(
post­
tax;
$
2002)
2008
Baseline
Closures
=
VLOOKUP($
A3,'[
P2
NODA
Analysis­
Preferred
Option.
xls]
Facility
Impact
Cost'!$
A$
7:$
AO$
546,41,0)
=
VLOOKUP($
A3,'[
P2
NODA
Analysis­
WBC
Option.
xls]
National
Cost'!$
A$
7:$
BF$
546,58,0)
=
SUM(
H3:
H542)

March
10,
2003
20
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
316(
b)
Facilities
­
Phase
II
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
543
544
J
K
L
Analysis
­
Waterbody/
Capacity­
Based
Option
Annualized
Facility
Compliance
Costs
(
post­
tax;
$
2002)
Firm
Revenues
=
VLOOKUP($
A3,'[
P2
NODA
Analysis­
WBC
Option.
xls]
Facility
Impact
Cost'!$
A$
7:$
AO$
546,41,0)
=
VLOOKUP($
D3,'
Firm
Level
Data'!$
A$
3:$
L$
130,12,0)
=
SUM(
J3:
J542)

March
10,
2003
21
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
316(
b)
Facilities
­
Phase
II
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
543
544
M
Firm
Revenues
Source
=
VLOOKUP($
D3,'
Firm
Level
Data'!$
A$
3:$
M$
130,13,0)

March
10,
2003
22
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
316(
b)
Facilities
­
Phase
II
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
4
5
6
135
A
B
C
D
Count
of
EIA
Utility
Code
(
1999)
Final
Parent
Name
Total
AES
Corporation
11
=
VLOOKUP(
B6,'
316(
b)
Facilities
­
Phase
II'!$
D$
3:$
F$
542,3,0)
No
new
equations
through
row
134.
Values
can
be
found
in
P2
NODA
Firm
Level
Analysis­
N.
pdf
March
10,
2003
23
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Unique
Entities
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
16
A
B
C
D
E
F
PLNTCODE
FLNAME
Final
Parent
Months
of
Revenue
Data
­
1996
Months
of
Revenue
Data
­
1997
Months
of
Revenue
Data
­
1998
10338
Maine
Energy
Recovery
Company
KTI,
Inc.
12
12
12
No
new
equations
through
row
15.
Values
can
be
found
in
P2
NODA
Firm
Level
Analysis­
N.
pdf
Data
is
from
Proposal
Docket
W­
00­
32,
DCN
4­
3034.
­­­
Note
that
the
revenues
have
been
converted
from
$
2001
at
proposal
to
$
2002
in
NODA.

March
10,
2003
24
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Noutility
Firm
Revenues
­
DQ
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
16
G
H
I
J
K
L
DQ
Revenues
1996
DQ
Revenues
1997
DQ
Revenues
1998
Revenues
1996
(
12
Months)
Revenues
1997
(
12
Months)
Revenues
1998
(
12
Months)

68,508,000
$
96,157,000
$
192,977,000
$
=
IF(
G3'=
0,"",
G3/
D3*
12)
=
IF(
H3'=
0,"",
H3/
E3*
12)
=
IF(
I3'=
0,"",
I3/
F3*
12)

March
10,
2003
25
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Noutility
Firm
Revenues
­
DQ
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
16
M
N
O
Revenues
1996
$
2002
Revenues
1997
$
2002
Revenues
1998
$
2002
=
IF(
J3'="","",
J3*
Elect_
PPI_
2002/
Rates!
Elect_
PPI_
1996)
=
IF(
K3'="","",
K3*
Elect_
PPI_
2002/
Rates!
Elect_
PPI_
1997)
=
IF(
L3'="","",
L3*
Elect_
PPI_
2002/
Rates!
Elect_
PPI_
1998)

March
10,
2003
26
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Noutility
Firm
Revenues
­
DQ
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
2
3
16
P
Average
Revenues
(
1996­
1998)
$
2002
=
AVERAGE(
M3:
O3)

March
10,
2003
27
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Noutility
Firm
Revenues
­
DQ
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
23
130
A
B
C
D
E
F
G
Source:
D&
B
Database,
Accessed
1­
18­
2002
DOMESTIC
ULTIMATE
BUSINESS
NAME
D­
U­
N­
S
NUMBER
DOMESTIC
ULTIMATE
DU
N­
S
NUMBER
DOMESTIC
ULTIMATE
BUSINESS
NAME
DOMESTIC
ULTIMATE
STATE
ABBREV
PHYSICAL
STREET
ADDRESS
PHYSICAL
CITY
AES
Corporation,
The
43857812
43857812
AES
Corporation,
The
VA
1001
19TH
ST
N
STE
2000
Arlington
No
equations
through
row
129.
Values
can
be
found
in
P2
NODA
Firm
Level
Analysis­
N.
pdf
March
10,
2003
28
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
DUNS
Pull
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
23
130
H
I
J
K
L
M
N
O
P
Q
($
2,001)

PHYSICAL
STATE
ABBREVIATION
PHYSICAL
ZIP
SALES
VOLUME
(
US$)
EMPLOYEES
HERE
EMPLOYEES
TOTAL
TREND
YEAR
EMPLOYEES
(
3YR)
TREND
YEAR
EMPLOYEES
(
5YR)
TREND
YEAR
SALES
(
3YR)
TREND
YEAR
SALES
(
5YR)
PRIMARY
4
DIGIT
SIC
CODE
VA
22209
6,691,000,000
$
70
26,606
6,000
575
835,000,000
$
532,700,000
$
4911
March
10,
2003
29
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
DUNS
Pull
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
1
23
130
R
S
PRIMARY
4
DIGIT
SIC
SALES
VOLUME
($
2002)

ELECTRIC
SERVICES
=
J3*(
Elect_
PPI_
2002/
Rates!
Elect_
PPI_
2001)

March
10,
2003
30
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
DUNS
Pull
Record
for
the
Section
316(
b)
Phase
II
Existing
Facilities
Notice
of
Data
Availability
12
3456789
10
11
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Electric
Power
PPI
obtained
from
the
BLS
website
http://
www.
bls.
gov/
ppi/
series
ID
WPU054
(
1/
28/
2003)
ANNUAL
AVG
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Elect
PPI
1995
130.8
127.6
128
128.3
126.4
130.2
135.3
136.6
136.5
133.7
131.4
127.6
127.7
Elect
PPI
1996
131.6
127.9
127.1
127.8
129.1
135
137.5
136
136.2
136.2
131.2
127.1
127.7
Elect
PPI
1997
130.8
128.3
128.1
128.2
127.3
129.7
135.1
135.9
134.7
136
130.1
127.9
128.3
Elect
PPI
1998
130
127.4
127.2
126.7
126.4
129.2
133.8
134.8
135.2
135.2
130.4
127.6
126.6
Elect
PPI
1999
128.9
126.1
125.5
125.5
125.2
127.4
131.6
133.9
133.9
134.1
129.5
127.5
126.5
Elect
PPI
2000
131.5
126.8
126.7
126.7
126.8
128.6
133.6
136.2
137.4
137.8
134.1
130.9
132.7
Elect
PPI
2001
141.1
136.4
136.4
136.5
135.1
136.2
148.4
149.5
148.9
148.2
143.8
137.3
136.9
Elect
PPI
2002
139.9
136.3
135.4
135.7
135.4
137.9
143.6
144.9
145
145.7
139.6
140.1
139.6
Red
indicates
Preliminary
Data
March
10,
2003
31
of
31
P2
NODA
Firm
Level
Analysis­
F.
xls
­
Rates
