Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
A
B
C
Table
1
AMSA
ESTIMATED
AGGREGATE
COSTS
FOR
IMPLEMENTATION
OF
MP&
M
RULE
(
TABLE
7.11)
(
Based
on
38,500
Facilities)
Original
AMSA
Numbers
Pretreatment
Program
Activity
First
Year
Cost
Subsequent
Year
Cost
Industrial
User
Survey
$
50,533,076
$
0
MP&
M
Facility
Permitting
='
AMSA
Estimates'!
H13
='
AMSA
Estimates'!
L13
MP&
M
Facility
Oversight
(
less
permitting)
='
AMSA
Estimates'!
J13­'
AMSA
Estimates'!
H13
='
AMSA
Estimates'!
N13­'
AMSA
Estimates'!
L13
Total
Cost
=
SUM(
B7:
B9)
=
SUM(
C7:
C9)

Table
2
AMSA
ESTIMATED
NUMBER
OF
IUS
SUBJECT
TO
MP&
M
RULE
(
TABLE
7.6)
Original
AMSA
Numbers
Pretreatment
Program
Class
No.
of
PP
Aver.
No.
of
MP&
M
Facilities
Small
='
AMSA
Estimates'!
C9
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]<
10MGD'!$
M$
3:$
M$
17),
0)
Medium
='
AMSA
Estimates'!
C10
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]
10­
50MGD'!$
M$
3:$
M$
45),
0)
Large
='
AMSA
Estimates'!
C11
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]>
50MGD'!$
M$
3:$
M$
120),
0)
No
Program
='
AMSA
Estimates'!
C12
1
TOTAL
Table
3.
a
AMSA
ESTIMATED
COST
OF
CONDUCTING
INDUSTRIAL
SURVEYS
AT
POTWS
(
TABLE
7.7)
No.
of
POTWs
11,500
Aver.
No.
of
Facilities
99
Pre
Fac.
Time
1.2
Aver.
Time
=
B28*
B27
Total
Hours
=
B29*
B26
Cost
per
Hour
$
36.98
EPA
proposal
rate
Total
Cost
=
B30*
B31
Table
3.
b
AMSA
ESTIMATED
COST
OF
CONDUCTING
INDUSTRIAL
SURVEYS
AT
POTWS
(
TABLE
7.7)
No.
of
POTWs
=
B26
Hours
for
Application
Prep./
POTW
24
EPA
assumption
for
time
required
by
a
major
POTW
to
complete
NPDES
application
%
of
Appl.
For
Screening
10%
%
of
NPDES
application
burden
associated
with
screening
Aver.
Time/
POTW
=
B39*
B38
Total
Hours
=
B40*
B37
Cost
per
Hour
='
AD­
MP&
M12.
xls'!
Hourly_
rate_
2001
Sept.
2002
hourly
rate
from
BLS
($
31.89
­
similar
to
AMSA
survey
rate
of
$
31.86),
adjusted
to
$
2001
Total
Cost
=
B41*
B42
February
14,
2003
1
of
14
AMSA
Analysis­
formula.
xls
­
Memo
Tables
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
D
E
F
Corrected
Numbers
First
Year
Cost
Subsequent
Year
Cost
='
Memo
Tables'!
B32
$
0
='
AMSA
Estimates'!
H24
='
AMSA
Estimates'!
L24
='
AMSA
Estimates'!
J24­'
AMSA
Estimates'!
H24
='
AMSA
Estimates'!
N24­'
AMSA
Estimates'!
L24
=
SUM(
D7:
D9)
=
SUM(
E7:
E9)

Corrected
Numbers
Total
No.
of
MP&
M
Facilities
Aver.
No.
of
MP&
M
Facilities
Total
No.
of
MP&
M
Facilities
=
B17*
C17
=
ROUND(
AVERAGE('[
MPM­
COSTS­
EPA.
xls]<
10MGD'!$
AI$
3:$
AI$
17),
0)
=
B17*
E17
=
B18*
C18
=
ROUND(
AVERAGE('[
MPM­
COSTS­
EPA.
xls]
10­
50MGD'!$
AI$
3:$
AI$
45),
0)
=
B18*
E18
=
B19*
C19
=
ROUND(
AVERAGE('[
MPM­
COSTS­
EPA.
xls]>
50MGD'!$
AI$
3:$
AI$
120),
0)
=
B19*
E19
=
B20*
C20
1
=
B20*
E20
=
SUM(
D17:
D20)
=
SUM(
F17:
F20)

February
14,
2003
2
of
14
AMSA
Analysis­
formula.
xls
­
Memo
Tables
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
A
B
C
D
E
F
AMSA
Estimates
Implementation
Year
Subsequent
Years
Total
Cost
#
Facilities
Cost/
Facility
Total
Cost
Screening­
Facilities
not
in
PP
='
Memo
Tables'!
B32
='
Memo
Tables'!
B26*'
Memo
Tables'!
B27
=
C5/
D5
$
0
Facilities
in
PP
Permitting
(
incl.
screening)
='
AMSA
Estimates'!$
H$
24
='
AMSA
Estimates'!$
E$
24
=
C7/
D7
='
AMSA
Estimates'!$
L$
24
Analysis
=
D8*
E8
='
AMSA
Estimates'!$
E$
24
='[
MPM­
COSTS­
EPA.
xls]
All'!$
U$
181
=
G8*
H8
Sampling
=
D9*
E9
='
AMSA
Estimates'!$
E$
24
='[
MPM­
COSTS­
EPA.
xls]
All'!$
W$
181
=
G9*
H9
Oversight
='
AMSA
Estimates'!$
J$
24­
C7­
C8­
C9
='
AMSA
Estimates'!$
E$
24
=
C10/
D10
='
AMSA
Estimates'!$
N$
24­
F7­
F8­
F9
Total
Cost­
Facilities
in
PP
=
SUM(
C7:
C10)
=
SUM(
E7:
E10)
=
SUM(
F7:
F10)
Cost
without
Oversight
=
C11­
C10
=
E11­
E10
=
F11­
F10
Oversight
as
%
of
Other
Costs
=
E10/
SUM(
E7:
E9)
Total
Cost
Rule
=
C5+
C11
=
F5+
F11
EPA
Estimates
(
per
Permit)
EPA
Proposal
Estimates
($
1999)
EPA
Final
Estimates
($
2001)
Corrected
Hourly
Burden
Initial
Year
(
Average)
Subsequent
Years
Initial
Year
(
Average)
Subsequent
Years
Low
Permitting
='
EPA
Estimates'!
F18
='
EPA
Estimates'!
O18
='
EPA
Estimates'!
J18
='
EPA
Estimates'!
P18
Sampling&
Analysis
='
EPA
Estimates'!
F19
='
EPA
Estimates'!
O19
='
EPA
Estimates'!
J19
='
EPA
Estimates'!
P19
Oversight
='
EPA
Estimates'!
F20
='
EPA
Estimates'!
O20
$
0
$
0
Total
=
SUM(
C22:
C24)
=
SUM(
D22:
D24)
=
SUM(
E22:
E24)
=
SUM(
F22:
F24)
Medium
Permitting
='
EPA
Estimates'!
F23
='
EPA
Estimates'!
O23
='
EPA
Estimates'!
J23
='
EPA
Estimates'!
P23
Sampling&
Analysis
='
EPA
Estimates'!
F24
='
EPA
Estimates'!
O24
='
EPA
Estimates'!
J24
='
EPA
Estimates'!
P24
Oversight
='
EPA
Estimates'!
F25
='
EPA
Estimates'!
O25
$
0
$
0
Total
=
SUM(
C27:
C29)
=
SUM(
D27:
D29)
=
SUM(
E27:
E29)
=
SUM(
F27:
F29)
High
Permitting
='
EPA
Estimates'!
F28
='
EPA
Estimates'!
O28
='
EPA
Estimates'!
J28
='
EPA
Estimates'!
P28
Sampling&
Analysis
='
EPA
Estimates'!
F29
='
EPA
Estimates'!
O29
='
EPA
Estimates'!
J29
='
EPA
Estimates'!
P29
Oversight
='
EPA
Estimates'!
F30
='
EPA
Estimates'!
O30
$
0
$
0
Total
=
SUM(
C32:
C34)
=
SUM(
D32:
D34)
=
SUM(
E32:
E34)
=
SUM(
F32:
F34)
Average
Permitting
='
EPA
Estimates'!
F33
='
EPA
Estimates'!
O33
=
AVERAGE(
E22,
E27,
E32)
=
AVERAGE(
F22,
F27,
F32)
Sampling&
Analysis
='
EPA
Estimates'!
F34
='
EPA
Estimates'!
O34
=
AVERAGE(
E23,
E28,
E33)
=
AVERAGE(
F23,
F28,
F33)
Oversight
='
EPA
Estimates'!
F35
='
EPA
Estimates'!
O35
=
AVERAGE(
E24,
E29,
E34)
=
AVERAGE(
F24,
F29,
F34)
Total
=
SUM(
C37:
C39)
=
SUM(
D37:
D39)
=
SUM(
E37:
E39)
=
SUM(
F37:
F39)

February
14,
2003
3
of
14
AMSA
Analysis­
formula.
xls
­
Summary
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
G
H
#
Facilities
Cost/
Facility
$
0
='
AMSA
Estimates'!$
E$
24
=
F7/
G7
='
AMSA
Estimates'!$
E$
24
='[
MPM­
COSTS­
EPA.
xls]
All'!$
V$
181
='
AMSA
Estimates'!$
E$
24
='[
MPM­
COSTS­
EPA.
xls]
All'!$
X$
181
='
AMSA
Estimates'!$
E$
24
=
F10/
G10
=
SUM(
H7:
H10)
=
H11­
H10
=
H10/
SUM(
H7:
H9)

EPA
Final
Estimates
($
2001)
Hourly
Burden
and
Oversight
Initial
Year
(
Average)
Subsequent
Years
='
EPA
Estimates'!
J18
='
EPA
Estimates'!
P18
='
EPA
Estimates'!
J19
='
EPA
Estimates'!
P19
='
EPA
Estimates'!
J20
='
EPA
Estimates'!
P20
=
SUM(
G22:
G24)
=
SUM(
H22:
H24)

='
EPA
Estimates'!
J23
='
EPA
Estimates'!
P23
='
EPA
Estimates'!
J24
='
EPA
Estimates'!
P24
='
EPA
Estimates'!
J25
='
EPA
Estimates'!
P25
=
SUM(
G27:
G29)
=
SUM(
H27:
H29)

='
EPA
Estimates'!
J28
='
EPA
Estimates'!
P28
='
EPA
Estimates'!
J29
='
EPA
Estimates'!
P29
='
EPA
Estimates'!
J30
='
EPA
Estimates'!
P30
=
SUM(
G32:
G34)
=
SUM(
H32:
H34)

=
AVERAGE(
G22,
G27,
G32)
=
AVERAGE(
H22,
H27,
H32)
=
AVERAGE(
G23,
G28,
G33)
=
AVERAGE(
H23,
H28,
H33)
=
AVERAGE(
G24,
G29,
G34)
=
AVERAGE(
H24,
H29,
H34)
=
SUM(
G37:
G39)
=
SUM(
H37:
H39)

February
14,
2003
4
of
14
AMSA
Analysis­
formula.
xls
­
Summary
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
A
B
C
AMSA
Labor
Rates
Hourly
='[
MPM­
COSTS­
EPA.
xls]
All'!$
AJ$
179
Salary
(
Oversight)
='[
MPM­
COSTS­
EPA.
xls]
All'!$
AK$
179
AMSA
Analysis
Table
7.10
­
AMSA
Estimated
Administrative
Costs
Pretreatment
Program
Class
No.
of
PP
Small
975
Medium
375
Large
150
No
Program
11,500
TOTAL
=
SUM(
C9:
C12)

Corrected
AMSA
Analysis
Permitting
Costs
Pretreatment
Program
Class
No.
of
PP
Small
975
Medium
375
Large
150
No
Program
11,500
TOTAL
=
SUM(
C20:
C23)

EPA
Re­
Analysis
Permitting
Costs
Pretreatment
Program
Class
No.
of
PP
Small
975
Medium
375
Large
150
No
Program
11,500
TOTAL
=
SUM(
C31:
C34)

February
14,
2003
5
of
14
AMSA
Analysis­
formula.
xls
­
AMSA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
D
E
F
G
H
=
C3/
C2
Implementation
Year
Aver.
No.
of
MP&
M
Facilities
Total
No.
of
MP&
M
Facilities
Implementation
Cost/
Permit
Total
Implementation
Cost
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]<
10MGD'!$
M$
3:$
M$
17),
0)
10,527
$
649.32
=
G9*$
E9
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]
10­
50MGD'!$
M$
3:$
M$
45),
0)
=
C10*
D10
$
974.60
=
G10*$
E10
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]>
50MGD'!$
M$
3:$
M$
120),
0)
=
C11*
D11
$
1,634.17
=
G11*$
E11
1
=
C12*
D12
$
649.42
=
G12*$
E12
=
SUM(
E9:
E12)
$
37,702,435
=
SUM(
H9:
H12)

Implementation
Year
Aver.
No.
of
MP&
M
Facilities
Total
No.
of
MP&
M
Facilities
Implementation
Cost/
Permit
Total
Implementation
Cost
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]<
10MGD'!$
M$
3:$
M$
17),
0)
10,725
$
649.32
=
G20*$
E20
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]
10­
50MGD'!$
M$
3:$
M$
45),
0)
=
C21*
D21
$
974.60
=
G21*$
E21
=
ROUND(
AVERAGE('[
MPM­
COSTS.
xls]>
50MGD'!$
M$
3:$
M$
120),
0)
=
C22*
D22
$
1,634.17
=
G22*$
E22
1
=
C23*
D23
$
649.42
=
G23*$
E23
=
SUM(
E20:
E23)
=
SUM(
H20:
H23)

Implementation
Year
Aver.
No.
of
MP&
M
Facilities
Total
No.
of
MP&
M
Facilities
Total
No.
of
Permitted
Facilities
Implementation
Cost/
Permit
Total
Implementation
Cost
=
ROUND(
AVERAGE('[
MPM­
COSTS­
EPA.
xls]<
10MGD'!$
AI$
3:$
AI$
17),
0)
=
C31*
D31
=
E31*'
EPA
Estimates'!$
C$
7
$
649.32
=
G31*$
F31
=
ROUND(
AVERAGE('[
MPM­
COSTS­
EPA.
xls]
10­
50MGD'!$
AI$
3:$
AI$
45),
0)
=
C32*
D32
=
E32*'
EPA
Estimates'!$
C$
7
$
974.60
=
G32*$
F32
=
ROUND(
AVERAGE('[
MPM­
COSTS­
EPA.
xls]>
50MGD'!$
AI$
3:$
AI$
120),
0)
=
C33*
D33
=
E33*'
EPA
Estimates'!$
C$
7
$
1,634.17
=
G33*$
F33
1
=
C34*
D34
=
E34*'
EPA
Estimates'!$
C$
7
$
649.42
=
G34*$
F34
=
SUM(
E31:
E34)
=
SUM(
F31:
F34)
=
SUM(
H31:
H34)

February
14,
2003
6
of
14
AMSA
Analysis­
formula.
xls
­
AMSA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
I
J
K
L
M
N
O
P
Implementation
Year
Subsequent
Years
FTE
for
Implementation
Oversight
Cost/
Permit
Total
Oversight
Cost
Implementation
Cost/
Permit
Total
Implementation
Cost
Oversight
Cost/
Permit
Total
Oversight
Cost
Impl.
Year
=
2712.52
=
I9*$
E9
$
377.82
=
K9*$
E9
=
2002.8
=
M9*$
E9
=(
H9/'
Memo
Tables'!$
B$
31)/
2000
=
3104.95
=
I10*$
E10
$
524.58
=
K10*$
E10
=
2503.37
=
M10*$
E10
=(
H10/'
Memo
Tables'!$
B$
31)/
2000
=
4357.7
=
I11*$
E11
$
969.62
=
K11*$
E11
=
3218.96
=
M11*$
E11
=(
H11/'
Memo
Tables'!$
B$
31)/
2000
=
2712.52
=
I12*$
E12
$
377.82
=
K12*$
E12
=
2002.8
=
M12*$
E12
=(
H12/'
Memo
Tables'!$
B$
31)/
2000
=
SUM(
J9:
J12)
=
SUM(
L9:
L12)
=
SUM(
N9:
N12)
=
SUM(
P9:
P12)

Implementation
Year
Subsequent
Years
FTE
for
Implementation
Oversight
Cost/
Permit
Total
Oversight
Cost
Implementation
Cost/
Permit
Total
Implementation
Cost
Oversight
Cost/
Permit
Total
Oversight
Cost
Impl.
Year
=
2712.52
=
I20*$
E20
$
377.82
=
K20*$
E20
=
2002.8
=
M20*$
E20
=(
H20/'
Memo
Tables'!$
B$
31)/
2000
=
3104.95
=
I21*$
E21
$
524.58
=
K21*$
E21
=
2503.37
=
M21*$
E21
=(
H21/'
Memo
Tables'!$
B$
31)/
2000
=
4357.7
=
I22*$
E22
$
969.62
=
K22*$
E22
=
3218.96
=
M22*$
E22
=(
H22/'
Memo
Tables'!$
B$
31)/
2000
=
2712.52
=
I23*$
E23
$
377.82
=
K23*$
E23
=
2002.8
=
M23*$
E23
=(
H23/'
Memo
Tables'!$
B$
31)/
2000
=
SUM(
J20:
J23)
=
SUM(
L20:
L23)
=
SUM(
N20:
N23)
=
SUM(
P20:
P23)

Implementation
Year
Subsequent
Years
Total
Cost/
Permit
Total
Permitting
Cost
Implementation
Cost/
Permit
Total
Implementation
Cost
Total
Cost/
Permit
Total
Permitting
Cost
=
2712.52
=
I31*$
F31
$
377.82
=
K31*$
F31
=
2002.8
=
M31*$
F31
=
3104.95
=
I32*$
F32
$
524.58
=
K32*$
F32
=
2503.37
=
M32*$
F32
=
4357.7
=
I33*$
F33
$
969.62
=
K33*$
F33
=
3218.96
=
M33*$
F33
=
2712.52
=
I34*$
F34
$
377.82
=
K34*$
F34
=
2002.8
=
M34*$
F34
=
SUM(
J31:
J34)
=
SUM(
L31:
L34)
=
SUM(
N31:
N34)

February
14,
2003
7
of
14
AMSA
Analysis­
formula.
xls
­
AMSA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
Q
FTE
for
Implementation
Subs.
Years
=(
L9/'
Memo
Tables'!$
B$
31)/
2000
=(
L10/'
Memo
Tables'!$
B$
31)/
2000
=(
L11/'
Memo
Tables'!$
B$
31)/
2000
=(
L12/'
Memo
Tables'!$
B$
31)/
2000
=
SUM(
Q9:
Q12)

FTE
for
Implementation
Subs.
Years
=(
L20/'
Memo
Tables'!$
B$
31)/
2000
=(
L21/'
Memo
Tables'!$
B$
31)/
2000
=(
L22/'
Memo
Tables'!$
B$
31)/
2000
=(
L23/'
Memo
Tables'!$
B$
31)/
2000
=
SUM(
Q20:
Q23)

February
14,
2003
8
of
14
AMSA
Analysis­
formula.
xls
­
AMSA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
A
B
C
EPA
Estimated
No.
of
Indirect
Dischargers
All
Water
Discharging
MP&
M
Facilities
57,947
Operating
in
the
Baseline
54,333
Regulated
Under
the
Proposed
Rule
5,186
Operating
under
the
Proposed
Rule
(
Requiring
Permit)
4,944
Percent
of
Facilities
Operating
in
the
Baseline
that
are
Regulated
=
C6/
C4
Wage
Rate
Wage
Rate
1999
='[
AD­
MP&
M7A.
xls]
Inputs
&
Assumptions'!$
B$
5
Wage
Rate
2001
='
AD­
MP&
M12.
xls'!
Hourly_
rate_
2001
EPA
Permitting
Costs
(
per
Permit)
of
Proposed
MP&
M
Rule
New
concentration­
based
permit
Low
Permitting
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
B$
19*
Wage_
Rate_
1999)­
C19
Sampling&
Analysis
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
B$
11*
Wage_
Rate_
1999
Oversight
$
0
Total
=
SUM(
C18:
C20)
Medium
Permitting
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
B$
19*
Wage_
Rate_
1999)­
C24
Sampling&
Analysis
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
B$
11*
Wage_
Rate_
1999
Oversight
$
0
Total
=
SUM(
C23:
C25)
High
Permitting
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
B$
19*
Wage_
Rate_
1999)­
C29
Sampling&
Analysis
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
B$
11*
Wage_
Rate_
1999
Oversight
$
0
Total
=
SUM(
C28:
C30)
Average
Permitting
=
AVERAGE(
C18,
C23,
C28)
Sampling&
Analysis
=
AVERAGE(
C19,
C24,
C29)
Oversight
=
AVERAGE(
C20,
C25,
C30)
Total
=
SUM(
C33:
C35)

February
14,
2003
9
of
14
AMSA
Analysis­
formula.
xls
­
EPA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
D
E
F
in
$
1999
(
used
at
proposal)
in
$
2001
(
used
for
adjusted
proposal)

INITIAL
YEAR
Original
New
mass­
based
permit
Upgrading
from
concentration
to
mass
Average
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
B$
35*
Wage_
Rate_
1999)­
D19
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
B$
51*
Wage_
Rate_
1999)­
E19
=
AVERAGE(
C18:
E18)
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
B$
27*
Wage_
Rate_
1999
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
B$
43*
Wage_
Rate_
1999
=
AVERAGE(
C19:
E19)
$
0
$
0
=
AVERAGE(
C20:
E20)
=
SUM(
D18:
D20)
=
SUM(
E18:
E20)
=
SUM(
F18:
F20)

=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
B$
35*
Wage_
Rate_
1999)­
D24
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
B$
51*
Wage_
Rate_
1999)­
E24
=
AVERAGE(
C23:
E23)
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
B$
27*
Wage_
Rate_
1999
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
B$
43*
Wage_
Rate_
1999
=
AVERAGE(
C24:
E24)
$
0
$
0
=
AVERAGE(
C25:
E25)
=
SUM(
D23:
D25)
=
SUM(
E23:
E25)
=
SUM(
F23:
F25)

=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
B$
35*
Wage_
Rate_
1999)­
D29
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
B$
51*
Wage_
Rate_
1999)­'
EPA
Estimates'!
E29
=
AVERAGE(
C28:
E28)
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
B$
27*
Wage_
Rate_
1999
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
B$
43*
Wage_
Rate_
1999
=
AVERAGE(
C29:
E29)
$
0
$
0
=
AVERAGE(
C30:
E30)
=
SUM(
D28:
D30)
=
SUM(
E28:
E30)
=
SUM(
F28:
F30)

=
AVERAGE(
D18,
D23,
D28)
=
AVERAGE(
E18,
E23,
E28)
=
AVERAGE(
F18,
F23,
F28)
=
AVERAGE(
D19,
D24,
D29)
=
AVERAGE(
E19,
E24,
E29)
=
AVERAGE(
C34:
E34)
=
AVERAGE(
D20,
D25,
D30)
=
AVERAGE(
E20,
E25,
E30)
=
AVERAGE(
C35:
E35)
=
SUM(
D33:
D35)
=
SUM(
E33:
E35)
=
SUM(
F33:
F35)

February
14,
2003
10
of
14
AMSA
Analysis­
formula.
xls
­
EPA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
G
H
INITIAL
YEAR
Updated
New
concentration­
based
permit
New
mass­
based
permit
=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
B$
19*
Wage_
Rate_
2001)­
G19
=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
B$
35*
Wage_
Rate_
2001)­
H19
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
B$
11*
Wage_
Rate_
2001
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
B$
27*
Wage_
Rate_
2001
=
SUM(
G18:
G19)*
Summary!$
E$
13
=
SUM(
H18:
H19)*
Summary!$
E$
13
=
SUM(
G18:
G20)
=
SUM(
H18:
H20)

=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
B$
19*
Wage_
Rate_
2001)­
G24
=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
B$
35*
Wage_
Rate_
2001)­
H24
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
B$
11*
Wage_
Rate_
2001
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
B$
27*
Wage_
Rate_
2001
=
SUM(
G23:
G24)*
Summary!$
E$
13
=
SUM(
H23:
H24)*
Summary!$
E$
13
=
SUM(
G23:
G25)
=
SUM(
H23:
H25)

=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
B$
19*
Wage_
Rate_
2001)­
G29
=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
B$
35*
Wage_
Rate_
2001)­
H29
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
B$
11*
Wage_
Rate_
2001
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
B$
27*
Wage_
Rate_
2001
=
SUM(
G28:
G29)*
Summary!$
E$
13
=
SUM(
H28:
H29)*
Summary!$
E$
13
=
SUM(
G28:
G30)
=
SUM(
H28:
H30)

=
AVERAGE(
G18,
G23,
G28)
=
AVERAGE(
H18,
H23,
H28)
=
AVERAGE(
G19,
G24,
G29)
=
AVERAGE(
H19,
H24,
H29)
=
AVERAGE(
G20,
G25,
G30)
=
AVERAGE(
H20,
H25,
H30)
=
SUM(
G33:
G35)
=
SUM(
H33:
H35)

February
14,
2003
11
of
14
AMSA
Analysis­
formula.
xls
­
EPA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
I
J
K
ANNUAL
Original
Upgrading
from
concentration
to
mass
Average
All
Facilities
=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
B$
51*
Wage_
Rate_
2001)­
I19
=
AVERAGE(
G18:
I18)
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
C$
19*
Wage_
Rate_
1999)­
K19
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
B$
43*
Wage_
Rate_
2001
=
AVERAGE(
G19:
I19)
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
C$
11*
Wage_
Rate_
1999
=
SUM(
I18:
I19)*
Summary!$
E$
13
=
AVERAGE(
G20:
I20)
$
0
=
SUM(
I18:
I20)
=
SUM(
J18:
J20)
=
SUM(
K18:
K20)

=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
B$
51*
Wage_
Rate_
2001)­
I24
=
AVERAGE(
G23:
I23)
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
C$
19*
Wage_
Rate_
1999)­
K24
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
B$
43*
Wage_
Rate_
2001
=
AVERAGE(
G24:
I24)
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
C$
11*
Wage_
Rate_
1999
=
SUM(
I23:
I24)*
Summary!$
E$
13
=
AVERAGE(
G25:
I25)
$
0
=
SUM(
I23:
I25)
=
SUM(
J23:
J25)
=
SUM(
K23:
K25)

=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
B$
51*
Wage_
Rate_
2001)­'
EPA
Estimates'!
I29
=
AVERAGE(
G28:
I28)
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
C$
19*
Wage_
Rate_
1999)­
K29
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
B$
43*
Wage_
Rate_
2001
=
AVERAGE(
G29:
I29)
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
C$
11*
Wage_
Rate_
1999
=
SUM(
I28:
I29)*
Summary!$
E$
13
=
AVERAGE(
G30:
I30)
$
0
=
SUM(
I28:
I30)
=
SUM(
J28:
J30)
=
SUM(
K28:
K30)

=
AVERAGE(
I18,
I23,
I28)
=
AVERAGE(
J18,
J23,
J28)
=
AVERAGE(
K18,
K23,
K28)
=
AVERAGE(
I19,
I24,
I29)
=
AVERAGE(
G34:
I34)
=
AVERAGE(
K19,
K24,
K29)
=
AVERAGE(
I20,
I25,
I30)
=
AVERAGE(
G35:
I35)
=
AVERAGE(
K20,
K25,
K30)
=
SUM(
I33:
I35)
=
SUM(
J33:
J35)
=
SUM(
K33:
K35)

February
14,
2003
12
of
14
AMSA
Analysis­
formula.
xls
­
EPA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
L
M
ANNUAL
REPERMIT
Updated
Original
All
Facilities
All
Facilities
=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
C$
19*
Wage_
Rate_
2001)­
L19
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
D$
19*
Wage_
Rate_
1999)­
M19
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
C$
11*
Wage_
Rate_
2001
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Low'!$
D$
11*
Wage_
Rate_
1999
=
SUM(
L18:
L19)*
Summary!$
E$
13
$
0
=
SUM(
L18:
L20)
=
SUM(
M18:
M20)

=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
C$
19*
Wage_
Rate_
2001)­
L24
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
D$
19*
Wage_
Rate_
1999)­
M24
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
C$
11*
Wage_
Rate_
2001
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
Medium'!$
D$
11*
Wage_
Rate_
1999
=
SUM(
L23:
L24)*
Summary!$
E$
13
$
0
=
SUM(
L23:
L25)
=
SUM(
M23:
M25)

=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
C$
19*
Wage_
Rate_
2001)­
L29
=('[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
D$
19*
Wage_
Rate_
1999)­
M29
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
C$
11*
Wage_
Rate_
2001
='[
AD­
MP&
M7A.
xls]
Unit
Costs
­
High'!$
D$
11*
Wage_
Rate_
1999
=
SUM(
L28:
L29)*
Summary!$
E$
13
$
0
=
SUM(
L28:
L30)
=
SUM(
M28:
M30)

=
AVERAGE(
L18,
L23,
L28)
=
AVERAGE(
M18,
M23,
M28)
=
AVERAGE(
L19,
L24,
L29)
=
AVERAGE(
M19,
M24,
M29)
=
AVERAGE(
L20,
L25,
L30)
=
AVERAGE(
M20,
M25,
M30)
=
SUM(
L33:
L35)
=
SUM(
M33:
M35)

February
14,
2003
13
of
14
AMSA
Analysis­
formula.
xls
­
EPA
Estimates
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
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
N
O
P
REPERMIT
AVERAGE
SUBSEQUENT
Adj.
Proposal
Original
Adj.
Proposal
All
Facilities
All
Facilities
All
Facilities
=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
D$
19*
Wage_
Rate_
2001)­
N19
=((
4*
K18)+
M18)/
5
=((
4*
L18)+
N18)/
5
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Low'!$
D$
11*
Wage_
Rate_
2001
=((
4*
K19)+
M19)/
5
=((
4*
L19)+
N19)/
5
=
SUM(
N18:
N19)*
Summary!$
E$
13
=((
4*
K20)+
M20)/
5
=((
4*
L20)+
N20)/
5
=
SUM(
N18:
N20)
=
SUM(
O18:
O20)
=
SUM(
P18:
P20)

=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
D$
19*
Wage_
Rate_
2001)­
N24
=((
4*
K23)+
M23)/
5
=((
4*
L23)+
N23)/
5
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
Medium'!$
D$
11*
Wage_
Rate_
2001
=((
4*
K24)+
M24)/
5
=((
4*
L24)+
N24)/
5
=
SUM(
N23:
N24)*
Summary!$
E$
13
=((
4*
K25)+
M25)/
5
=((
4*
L25)+
N25)/
5
=
SUM(
N23:
N25)
=
SUM(
O23:
O25)
=
SUM(
P23:
P25)

=('[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
D$
19*
Wage_
Rate_
2001)­
N29
=((
4*
K28)+
M28)/
5
=((
4*
L28)+
N28)/
5
='[
AD­
MP&
M12.
xls]
Unit
Costs
­
High'!$
D$
11*
Wage_
Rate_
2001
=((
4*
K29)+
M29)/
5
=((
4*
L29)+
N29)/
5
=
SUM(
N28:
N29)*
Summary!$
E$
13
=((
4*
K30)+
M30)/
5
=((
4*
L30)+
N30)/
5
=
SUM(
N28:
N30)
=
SUM(
O28:
O30)
=
SUM(
P28:
P30)

=
AVERAGE(
N18,
N23,
N28)
=
AVERAGE(
O18,
O23,
O28)
=
AVERAGE(
P18,
P23,
P28)
=
AVERAGE(
N19,
N24,
N29)
=
AVERAGE(
O19,
O24,
O29)
=
AVERAGE(
P19,
P24,
P29)
=
AVERAGE(
N20,
N25,
N30)
=
AVERAGE(
O20,
O25,
O30)
=
AVERAGE(
P20,
P25,
P30)
=
SUM(
N33:
N35)
=
SUM(
O33:
O35)
=
SUM(
P33:
P35)

February
14,
2003
14
of
14
AMSA
Analysis­
formula.
xls
­
EPA
Estimates
