Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
89
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
52
53
54
55
56
57
58
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
Categorical
GM
Non­
Cat.
G
M
#
of
MFJS
#
of
Non­
Cat.
Oily
Waste
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
1
Monroe
County
NY
90.0
35
18
0
2
3
12
0
0
=
SUM(
F3:
L3)
1
Monroe
County
Northwest
Qusdrent
NY
12.0
0
0
0
0
0
0
0
0
=
SUM(
F4:
L4)
2
Metro
Wastewater
Reclamation
District
CO
160.0
11,565
9
0
0
458
14
2
102
=
SUM(
F5:
L5)
3
Landis
Sewerage
Authority
NJ
5.6
0
0
0
0
0
0
0
0
0
4
Madison­
Chatham
Joint
Meeting
NJ
2.5
79
0
0
0
0
0
0
0
=
SUM(
F7:
L7)
5
Somerset
NJ
15.0
18
1
0
0
0
1
0
0
=
SUM(
F8:
L8)
6
Albany
County
Sewer
District
NY
19.0
14
0
0
0
0
0
0
0
=
SUM(
F9:
L9)
6
Albany
South
Plant
NY
20.0
2
0
0
0
0
0
0
0
=
SUM(
F10:
L10)
7
City
of
Niagra
Falls
NY
35.0
225
0
0
0
10
1
0
0
=
SUM(
F11:
L11)
8
Providence
Fields
Point
WWTP
RI
45.5
674
15
1
37
373
41
1
0
=
SUM(
F12:
L12)
8
Providence
Bucklin
Point
WWTF
RI
23.9
344
9
2
26
187
14
1
0
=
SUM(
F13:
L13)
9
Broward
County
FL
66.0
41
14
3
3
0
10
4
0
=
SUM(
F14:
L14)
10
City
of
Clearwater
(
Marshall
Street)
FL
6.5
2
2
1
2
6
2
0
5
=
SUM(
F15:
L15)
10
Clearwater
Northeast
FL
5.5
12
0
2
0
6
2
0
8
=
SUM(
F16:
L16)
10
Clearwater
East
FL
2.3
5
0
0
0
4
0
0
0
=
SUM(
F17:
L17)
11
NYC
Port
Richmond
NY
31.0
290
25
27
62
475
263
0
25
=
SUM(
F18:
L18)
11
NYC
Red
Hook
NY
30.0
11
NYC
Oakwood
Beach
NY
25.3
11
NYC
NTC
Rockaway
NY
20.0
11
NYC
East
NY
2.3
11
NYC
Newton
Creek
NY
216.0
11
NYC
Wards
Island
NY
184.0
11
NYC
North
River
NY
128.0
11
NYC
Hunts
Point
NY
118.0
11
NYC
Bowery
Bay
NY
108.0
11
NYC
Owls
Head
NY
101.0
11
NYC
Coney
Island
NY
93.0
11
NYC
Jamacia
NY
78.0
11
NYC
26th
Ward
NY
58.0
11
NYC
Tallman
Island
NY
54.0
12
MS
D
Little
Miami
OH
27.0
33
5
0
6
0
2
0
0
=
SUM(
F33:
L33)
12
Cincinnati
Muddy
Creek
OH
12.0
6
1
0
0
0
1
1
0
=
SUM(
F34:
L34)
12
Cincinnati
Sycamore
Creek
OH
3.0
7
2
0
0
0
0
0
0
=
SUM(
F35:
L35)
12
Cincinnati
Mill
Creek
OH
140.0
188
17
0
29
0
13
4
0
=
SUM(
F36:
L36)
13
Marshall
Municipal
Utilities
MO
3.7
3
0
0
0
0
0
0
0
=
SUM(
F37:
L37)
14
City
of
Hamilton
OH
21.0
121
0
0
0
8
3
0
1
=
SUM(
F38:
L38)
15
Racine
WI
30.9
50
8
6
7
1
15
0
1
=
SUM(
F39:
L39)
16
Jasper
Waterworks
&
Sewer
Board
AL
4.8
1
0
1
0
0
0
0
0
=
SUM(
F40:
L40)
17
Birmingham
Valley
Creek
AL
35.4
12
2
2
0
0
0
0
0
=
SUM(
F41:
L41)
17
Birmingham
Village
Creek
AL
33.5
15
3
0
0
0
0
0
0
=
SUM(
F42:
L42)
17
Birmingham
Five
Mile
Creek
AL
12.3
14
4
0
0
0
0
0
2
=
SUM(
F43:
L43)
17
Birmingham
Cahaba
River
AL
8.9
0
0
0
0
0
0
0
0
=
SUM(
F44:
L44)
17
Birmingham
Turkey
Creek
AL
4.2
0
0
0
0
0
0
0
0
=
SUM(
F45:
L45)
17
Birmingham
Trussville
AL
1.9
1
1
0
0
0
0
0
0
=
SUM(
F46:
L46)
17
Birmingham
Leeds
AL
0.9
1
1
0
0
0
0
0
0
=
SUM(
F47:
L47)
17
Birmingham
Prudes
Creek
AL
0.4
0
0
0
0
0
0
0
0
=
SUM(
F48:
L48)
17
Birmingham
Warrior
AL
0.1
0
0
0
0
0
0
0
0
=
SUM(
F49:
L49)
18
Little
Rock
Adams
Field
AR
18.0
4
2
0
0
0
0
0
0
=
SUM(
F50:
L50)
18
City
of
Little
Rock,
Wastewater
Utility
AR
14.0
8
5
0
1
0
0
0
0
=
SUM(
F51:
L51)
19
Fayetteville
AR
11.8
11
4
1
1
0
0
0
0
=
SUM(
F52:
L52)
20
LA
County
Joint
WPCP
CA
334.1
1896
47
17
11
0
231
13
0
=
SUM(
F53:
L53)
20
LA
Los
Coyotes
WRP
CA
34.4
216
10
0
0
0
42
0
0
=
SUM(
F54:
L54)
20
LA
Long
Beach
WRP
CA
18.8
28
1
0
0
0
4
0
0
=
SUM(
F55:
L55)
20
LA
Valencia
WRP
CA
11.2
54
1
0
3
0
9
0
0
=
SUM(
F56:
L56)
20
LA
Pomona
WRP
CA
10.7
77
1
0
0
0
5
0
0
=
SUM(
F57:
L57)
20
LA
Lancaster
WRP
CA
9.2
22
1
0
3
0
3
0
0
=
SUM(
F58:
L58)

February
14,
2003
1
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
89
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
52
53
54
55
56
57
58
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
Sampling
Costs
Management
Salary
Hrs
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
Implement
Yearly
Implement
Yearly
641
187
=
N3*
R3*(
1+
T3)
=
O3*
R3*(
1+
T3)
$
19.00
$
26.00
0.33
$
1,600.00
$
1,600.00
$
960.00
$
960.00
1,441
587
N/
A
N/
A
$
19.00
$
26.00
0.33
15,837
2,091
=
N5*
R5*(
1+
T5)
=
O5*
R5*(
1+
T5)
$
23.77
$
40.00
0.45
$
3,000,000.00
$
3,000,000.00
$
850,000.00
$
850,000.00
3,500
1,000
=
N6*
R6*(
1+
T6)
=
O6*
R6*(
1+
T6)
=
N7*
R7*(
1+
T7)
=
O7*
R7*(
1+
T7)
=
N8*
R8*(
1+
T8)
=
O8*
R8*(
1+
T8)
$
21.00
$
21.00
730
360
=
N9*
R9*(
1+
T9)
=
O9*
R9*(
1+
T9)
$
25.00
$
25.00
0.3
$
10,000.00
$
10,000.00
$
2,000.00
$
2,000.00
321
95
=
N11*
R11*(
1+
T11)
=
O11*
R11*(
1+
T11)
$
20.25
$
29.40
0.35
$
8,000.00
$
8,000.00
$
3,200.00
$
3,200.00
4
4
8,161
1,459
=
N12*
R12*(
1+
T12)
=
O12*
R12*(
1+
T12)
$
20.00
$
35.00
0.5
$
480,000.00
$
480,000.00
$
350,000.00
$
275,000.00
100
100
5,640
1,227
=
N14*
R14*(
1+
T14)
=
O14*
R14*(
1+
T14)
$
20.00
$
30.00
0.3
$
20,000.00
$
20,000.00
$
2,500.00
$
2,500.00
2,400
100
202
113
=
N15*
R15*(
1+
T15)
=
O15*
R15*(
1+
T15)
$
16.98
$
24.10
1.025
$
646.00
$
680.00
320
320
29,487
17,956
=
N18*
R18*(
1+
T18)
=
O18*
R18*(
1+
T18)
$
22.13
$
38.50
$
150,000.00
$
300,000.00
1,247
965
=
N33*
R33*(
1+
T33)
=
O33*
R33*(
1+
T33)
$
20.00
$
25.00
0.33
$
162,000.00
$
162,000.00
$
388,800.00
$
388,800.00
1,247
965
$
0
$
0
$
19.90
$
32.75
0.48
$
0.00
$
0.00
$
0.00
$
0.00
227
162
=
N38*
R38*(
1+
T38)
=
O38*
R38*(
1+
T38)
$
25.50
$
25.50
0.05
$
9,000.00
$
9,000.00
$
1,350.00
$
1,350.00
227
142
2,318
1,558
=
N39*
R39*(
1+
T39)
=
O39*
R39*(
1+
T39)
$
19.50
$
32.00
0.3
$
21,328.00
$
21,328.00
$
27,720.00
$
27,720.00
200
50
=
N40*
R40*(
1+
T40)
=
O40*
R40*(
1+
T40)
730
330
=
N41*
R41*(
1+
T41)
=
O41*
R41*(
1+
T41)
$
15.00
$
26.00
0.4
$
31,500.00
$
21,000.00
$
3,600.00
$
1,800.00
700
400
200
114
=
N50*
R50*(
1+
T50)
=
O50*
R50*(
1+
T50)
$
15.00
$
20.00
0
$
10,000.00
$
10,000.00
$
1,920.00
$
1,920.00
200
100
588
228
=
N52*
R52*(
1+
T52)
=
O52*
R52*(
1+
T52)
$
14.00
$
25.00
0.35
$
6,000.00
$
6,000.00
$
500.00
$
500.00
400
200
=
78*
521
=
521*
45
=
N53*
R53*(
1+
T53)
=
O53*
R53*(
1+
T53)
$
50.00
$
60.00
0.46
$
165,000.00
$
173,250.00
$
99,000.00
$
103,950.00
104
78
February
14,
2003
2
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
89
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
52
53
54
55
56
57
58
AA
AB
AC
AD
AE
AF
AG
AH
Management
Overhead
Costs
Total
Costs
Permitting
Costs
Per
Facility
Total
Costs
Per
Facility
Implement
Yearly
Implement
Yearly
Implement
Yearly
Implement
Yearly
=
Y3*
S3*(
1+
T3)
=
Z3*
S3*(
1+
T3)
=
P3+
U3+
W3+
AA3
=
Q3+
V3+
X3+
AB3
=
P3/
M3
=
Q3/
M3
=
AC3/
M3
=
AD3/
M3
=
Y5*
S5*(
1+
T5)
=
Z5*
S5*(
1+
T5)
=
P5+
U5+
W5+
AA5
=
Q5+
V5+
X5+
AB5
=
P5/
M5
=
Q5/
M5
=
AC5/
M5
=
AD5/
M5
=
Y6*
S6*(
1+
T6)
=
Z6*
S6*(
1+
T6)
=
P6+
U6+
W6+
AA6
=
Q6+
V6+
X6+
AB6
=
Y7*
S7*(
1+
T7)
=
Z7*
S7*(
1+
T7)
=
P7+
U7+
W7+
AA7
=
Q7+
V7+
X7+
AB7
=
Y8*
S8*(
1+
T8)
=
Z8*
S8*(
1+
T8)
=
P8+
U8+
W8+
AA8
=
Q8+
V8+
X8+
AB8
=
Y9*
S9*(
1+
T9)
=
Z9*
S9*(
1+
T9)
=
P9+
U9+
W9+
AA9
=
Q9+
V9+
X9+
AB9
=
Y11*
S11*(
1+
T11)
=
Z11*
S11*(
1+
T11)
=
P11+
U11+
W11+
AA11
=
Q11+
V11+
X11+
AB11
=
P11/
M11
=
Q11/
M11
=
AC11/
M11
=
AD11/
M11
=
Y12*
S12*(
1+
T12)
=
Z12*
S12*(
1+
T12)
=
P12+
U12+
W12+
AA12
=
Q12+
V12+
X12+
AB12
=
P12/
707
=
Q12/
707
=
AC12/
707
=
AD12/
707
=
Y14*
S14*(
1+
T14)
=
Z14*
S14*(
1+
T14)
=
P14+
U14+
W14+
AA14
=
Q14+
V14+
X14+
AB14
=
P14/
M14
=
Q14/
M14
=
AC14/
M14
=
AD14/
M14
=
Y15*
S15*(
1+
T15)
=
Z15*
S15*(
1+
T15)
=
P15+
U15+
W15+
AA15
=
Q15+
V15+
X15+
AB15
=
P15/
40
=
Q15/
40
=
AC15/
40
=
AD15/
40
=
Y16*
S16*(
1+
T16)
=
Z16*
S16*(
1+
T16)
=
P16+
U16+
W16+
AA16
=
Q16+
V16+
X16+
AB16
=
Y18*
S18*(
1+
T18)
=
Z18*
S18*(
1+
T18)
=
P18+
U18+
W18+
AA18
=
Q18+
V18+
X18+
AB18
=
P18/
M18
=
Q18/
M18
=
AC18/
M18
=
AD18/
M18
=
Y33*
S33*(
1+
T33)
=
Z33*
S33*(
1+
T33)
=
P33+
U33+
W33+
AA33
=
Q33+
V33+
X33+
AB33
=
P33/
81
=
Q33/
81
=
AC33/
81
=
AD33/
81
$
0.00
$
0.00
$
0.00
$
0.00
=
Y38*
S38*(
1+
T38)
=
Z38*
S38*(
1+
T38)
=
P38+
U38+
W38+
AA38
=
Q38+
V38+
X38+
AB38
=
P38/
M38
=
Q38/
M38
=
AC38/
M38
=
AD38/
M38
=
Y39*
S39*(
1+
T39)
=
Z39*
S39*(
1+
T39)
=
P39+
U39+
W39+
AA39
=
Q39+
V39+
X39+
AB39
=
P39/
M39
=
Q39/
M39
=
AC39/
M39
=
AD39/
M39
=
Y40*
S40*(
1+
T40)
=
Z40*
S40*(
1+
T40)
=
P40+
U40+
W40+
AA40
=
Q40+
V40+
X40+
AB40
=
Y41*
S41*(
1+
T41)
=
Z41*
S41*(
1+
T41)
=
P41+
U41+
W41+
AA41
=
Q41+
V41+
X41+
AB41
=
P41/
15
=
Q41/
15
=
AC41/
15
=
AD41/
15
=
Y50*
S50*(
1+
T50)
=
Z50*
S50*(
1+
T50)
=
P50+
U50+
W50+
AA50
=
Q50+
V50+
X50+
AB50
=
P50/
8
=
Q50/
8
=
AC50/
8
=
AD50/
8
=
Y52*
S52*(
1+
T52)
=
Z52*
S52*(
1+
T52)
=
P52+
U52+
W52+
AA52
=
Q52+
V52+
X52+
AB52
=
P52/
M52
=
Q52/
M52
=
AC52/
M52
=
AD52/
M52
=
Y53*
S53*(
1+
T53)
=
Z53*
S53*(
1+
T53)
=
P53+
U53+
W53+
AA53
=
Q53+
V53+
X53+
AB53
=
P53/
518
=
Q53/
518
=
AC53/
518
=
AD53/
518
February
14,
2003
3
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
Categorical
GM
Non­
Cat.
G
M
#
of
MFJS
#
of
Non­
Cat.
Oily
Waste
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
20
LA
Palmdale
WRP
CA
8.3
10
2
0
0
0
0
0
0
=
SUM(
F59:
L59)
20
LA
Whittier
Narrows
WRP
CA
7.6
246
9
0
2
0
36
2
0
=
SUM(
F60:
L60)
20
LA
Saugus
WRP
CA
5.5
13
0
1
1
0
0
0
0
=
SUM(
F61:
L61)
20
LA
San
Jose
Creek
WRP
CA
92.9
351
13
3
1
0
48
1
0
=
SUM(
F62:
L62)
21
South
San
Francisco
(
SBSA)
CA
20.3
38
16
8
0
0
5
0
0
=
SUM(
F63:
L63)
22
Chino
Basin
Municipal
Water
District
CA
NA
1200
1
1
0
0
2
0
0
=
SUM(
F64:
L64)
23
IEUA
Regional
Plant
#
1
CA
38.8
=
SUM(
F65:
L65)
23
Fontana
Carbon
Cayon
Water
Reclamation
CA
8.8
=
SUM(
F66:
L66)
23
Fontana
Regional
Plant
#
2
CA
3.9
=
SUM(
F67:
L67)
23
Fontana
Regional
Plant
#
4
CA
3.8
=
SUM(
F68:
L68)
24
City
of
Tacoma
WA
23.0
3387
0
12
2
35
5
2
12
=
SUM(
F69:
L69)
24
City
of
Tacoma,
Central
Treatment
Plant
WA
4.4
=
SUM(
F70:
L70)
25
Dallas
Water
Utilities
(
Central)
TX
155.5
129
24
12
0
0
5
0
0
=
SUM(
F71:
L71)
25
Dallas
Southside
WWTP
TX
87.0
=
SUM(
F72:
L72)
26
Blacksburg­
VPI
Sanitation
Authority
VA
5.2
2
2
0
0
0
0
0
0
=
SUM(
F73:
L73)
27
Virginia
Beach
VIP
VA
27.6
17
1
0
10
0
1
4
1
=
SUM(
F74:
L74)
27
Virginia
Beach
Atlantic
VA
27.5
16
1
0
3
0
0
3
9
=
SUM(
F75:
L75)
27
Virginia
Beach
Nansemond
VA
17.2
8
0
0
2
0
1
3
2
=
SUM(
F76:
L76)
27
Virginia
Beach
Chesapeake
­
Elizabeth
VA
16.9
7
0
0
2
1
0
2
2
=
SUM(
F77:
L77)
27
Virginia
Beach
Williamsburg
VA
14.0
12
2
0
3
0
2
4
1
=
SUM(
F78:
L78)
27
Virginia
Beach
James
River
VA
13.1
13
1
0
6
0
0
0
6
=
SUM(
F79:
L79)
27
Virginia
Beach
Boat
Harbor
VA
12.5
17
2
0
4
2
4
3
2
=
SUM(
F80:
L80)
27
Virginia
Beach
Army
Base
VA
11.4
4
0
0
1
0
0
2
1
=
SUM(
F81:
L81)
27
Virginia
Beach
York
River
VA
10.4
12
0
0
5
1
1
3
2
=
SUM(
F82:
L82)
28
Fox
Lake
Northwest
Regional
IL
6.1
3
2
1
1
0
3
0
0
=
SUM(
F83:
L83)
28
Fox
Lake
Tall
Oaks
IL
0.4
=
SUM(
F84:
L84)
29
Fox
River
WRD
South
Plant
IL
15.0
4
1
0
0
0
1
2
0
=
SUM(
F85:
L85)
29
Fox
River
WRD
North
Plant
IL
5.0
7
2
0
0
0
2
3
0
=
SUM(
F86:
L86)
29
Rox
River
WRD
West
Plant
IL
0.7
1
0
0
0
0
1
0
0
=
SUM(
F87:
L87)
30
Minneapolis­
St
Paul
Metropolitan
MN
203.9
463
21
1
15
1
88
4
0
=
SUM(
F88:
L88)
30
ST.
Paul
Seneca
WWTP
MN
34.5
=
SUM(
F89:
L89)
30
ST.
Paul
Blue
Lake
WWTP
MN
24.3
=
SUM(
F90:
L90)
30
St.
Paul
Empire
WWTP
MN
8.0
15
0
0
0
0
2
0
0
=
SUM(
F91:
L91)
30
ST.
Paul
Stillwater
WWTP
MN
3.1
=
SUM(
F92:
L92)
30
St.
Paul
Cottage
Grove
WWTP
MN
2.1
=
SUM(
F93:
L93)
30
St.
Paul
Hasting
WWTP
MN
1.8
=
SUM(
F94:
L94)
30
St.
Paul
Rosemount
MN
0.7
=
SUM(
F95:
L95)
31
City
of
Everett
WA
17.6
25
1
0
0
0
6
0
0
=
SUM(
F96:
L96)
32
Spokane
WA
40.0
9
3
4
0
40
4
0
5
=
SUM(
F97:
L97)
33
Unified
Sewerage
Agency
(
Durham)
OR
22.0
72
0
0
0
0
11
0
0
=
SUM(
F98:
L98)
33
USA
Rock
Creek
OR
29.9
55
0
0
0
0
12
0
0
=
SUM(
F99:
L99)
33
USA
Hillsboro
OR
4.6
13
0
0
0
0
3
0
0
=
SUM(
F100:
L100)
33
USA
Hillsboro
Forrest
Grove
OR
3.7
12
0
0
0
0
1
0
0
=
SUM(
F101:
L101)
34
Detroit
MI
620.0
2125
80
84
33
1328
134
25
322
=
SUM(
F102:
L102)
35
Kansas
City
Blue
River
MO
75.0
35
4
0
0
7
13
1
10
=
SUM(
F103:
L103)
35
Kansas
City
Birmingham
MO
20.0
4
1
0
0
1
0
0
2
=
SUM(
F104:
L104)
35
Kansas
City
Westside
MO
17.0
16
0
0
0
4
5
1
6
=
SUM(
F105:
L105)
35
Kansas
City
Todd
Creek
MO
1.4
2
2
0
0
0
0
0
0
=
SUM(
F106:
L106)
35
Kansas
City
Rocky
Branch
MO
0.7
=
SUM(
F107:
L107)
35
Kansas
CityFishing
River
MO
0.2
=
SUM(
F108:
L108)
35
KC
Northland
Mobile
Home
MO
0.1
=
SUM(
F109:
L109)
35
KC
Industrial
Park
MI
0.0
=
SUM(
F110:
L110)
36
Jacksonville
(
JEA)
FL
28.1
64
1
4
2
0
1
2
0
=
SUM(
F111:
L111)
36
Jacksonville
District
4
FL
11.8
7
2
1
0
0
0
1
0
=
SUM(
F112:
L112)
36
Jacksonville
District
3
FL
7.4
1
0
0
0
0
0
0
0
=
SUM(
F113:
L113)
36
Jacksonville
District
5
FL
5.6
1
1
0
0
0
0
0
0
=
SUM(
F114:
L114)
36
Jacksonville
District
2
FL
4.3
7
0
0
0
0
0
0
0
=
SUM(
F115:
L115)

February
14,
2003
4
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
Sampling
Costs
Management
Salary
Hrs
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
Implement
Yearly
Implement
Yearly
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
1,100
260
=
N63*
R63*(
1+
T63)
=
O63*
R63*(
1+
T63)
$
28.49
$
39.07
0.47
$
142,000.00
$
142,000.00
$
20,300.00
$
20,300.00
180
105
101
38
=
N64*
R64*(
1+
T64)
=
O64*
R64*(
1+
T64)
$
14.00
$
24.00
0.4
$
1,200.00
$
4,800.00
$
480.00
$
1,920.00
80
20
$
0
$
0
$
50.00
$
75.00
0.5
=
N66*
R66*(
1+
T66)
=
O66*
R66*(
1+
T66)
=
N67*
R67*(
1+
T67)
=
O67*
R67*(
1+
T67)
=
N68*
R68*(
1+
T68)
=
O68*
R68*(
1+
T68)
239
179
=
N69*
R69*(
1+
T69)
=
O69*
R69*(
1+
T69)
$
25.00
$
39.00
0.23
$
54,400.00
$
54,400.00
$
4,216.00
$
4,216.00
239
179
2,060
1,115
=
N71*
R71*(
1+
T71)
=
O71*
R71*(
1+
T71)
$
18.00
$
21.00
0.2
$
130,000.00
$
130,000.00
$
40,000.00
$
40,000.00
250
50
=
N73*
R73*(
1+
T73)
=
O73*
R73*(
1+
T73)
1,457
1,015
=
N74*
R74*(
1+
T74)
=
O74*
R74*(
1+
T74)
$
15.40
$
29.73
0.6331
$
284,188.00
$
294,912.00
$
79,977.00
$
82,995.00
544
360
=
N83*
R83*(
1+
T83)
=
O83*
R83*(
1+
T83)
$
17.50
$
25.00
0.30
415
280
=
N85*
R85*(
1+
T85)
=
O85*
R85*(
1+
T85)
$
22.61
$
25.78
1
$
30,000.00
$
30,000.00
$
17,000.00
$
17,000.00
60
45
2,625
763
=
N88*
R88*(
1+
T88)
=
O88*
R88*(
1+
T88)
$
25.09
$
33.80
0.59
$
27,000.00
$
22,000.00
$
110,000.00
$
85,000.00
200
100
248
212
=
N96*
R96*(
1+
T96)
=
O96*
R96*(
1+
T96)
$
27.45
$
34.59
0.29
$
8,400.00
$
16,800.00
$
6,600.00
$
13,200.00
60
20
3,100
1,110
=
N97*
R97*(
1+
T97)
=
O97*
R97*(
1+
T97)
$
20.00
$
30.00
0.68
$
100,000.00
$
75,000.00
$
100,000.00
$
100,000.00
2,000
1,000
980
240
=
N98*
R98*(
1+
T98)
=
O98*
R98*(
1+
T98)
$
23.00
$
30.00
0.38
$
10,000.00
$
7,000.00
$
20,000.00
$
10,000.00
400
400
78,260
23,190
=
N102*
R102*(
1+
T102)
=
O102*
R102*(
1+
T102)
$
870,000.00
$
87,000.00
$
2,100,000.00
$
1,050,000.00
4,750
1,380
=
N103*
S103*(
1+
T103)
=
O103*
S103*(
1+
T103)
$
12.50
$
23.00
0.36
$
33,170.00
$
33,170.00
$
14,000.00
$
1,000.00
4,750
1,380
790
680
=
N104*
R103*(
1+
T104)
=
O104*
R103*(
1+
T104)

1,280
480
=
N111*
R111*(
1+
T111)
=
O111*
R111*(
1+
T111)
$
20.00
$
40.00
0.5
$
15,000.00
$
5,000.00
$
10,000.00
$
5,000.00
480
120
February
14,
2003
5
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
AA
AB
AC
AD
AE
AF
AG
AH
Management
Overhead
Costs
Total
Costs
Permitting
Costs
Per
Facility
Total
Costs
Per
Facility
Implement
Yearly
Implement
Yearly
Implement
Yearly
Implement
Yearly
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
=
Y63*
S63*(
1+
T63)
=
Z63*
S63*(
1+
T63)
=
P63+
U63+
W63+
AA63
=
Q63+
V63+
X63+
AB63
=
P63/
M63
=
Q63/
M63
=
AC63/
M63
=
AD63/
M63
=
Y64*
S64*(
1+
T64)
=
Z64*
S64*(
1+
T64)
=
P64+
U64+
W64+
AA64
=
Q64+
V64+
X64+
AB64
=
P64/
M64
=
Q64/
M64
=
AC64/
M64
=
AD64/
M64
=
Y69*
S69*(
1+
T69)
=
Z69*
S69*(
1+
T69)
=
P69+
U69+
W69+
AA69
=
Q69+
V69+
X69+
AB69
=
P69/
M69
=
Q69/
M69
=
AC69/
M69
=
AD69/
M69
=
Y71*
S71*(
1+
T71)
=
Z71*
S71*(
1+
T71)
=
P71+
U71+
W71+
AA71
=
Q71+
V71+
X71+
AB71
=
P71/
M71
=
Q71/
M71
=
AC71/
M71
=
AD71/
M71
=
Y73*
S73*(
1+
T73)
=
Z73*
S73*(
1+
T73)
=
P73+
U73+
W73+
AA73
=
Q73+
V73+
X73+
AB73
=
Y74*
S74*(
1+
T74)
=
Z74*
S74*(
1+
T74)
=
P74+
U74+
W74+
AA74
=
Q74+
V74+
X74+
AB74
=
P74/
106
=
Q74/
106
=
AC74/
106
=
AD74/
106
=
Y83*
S83*(
1+
T83)
=
Z83*
S83*(
1+
T83)
$
0.00
$
0.00
=
Y85*
S85*(
1+
T85)
=
Z85*
S85*(
1+
T85)
=
P85+
U85+
W85+
AA85
=
Q85+
V85+
X85+
AB85
=
P85/
12
=
Q85/
12
=
AC85/
12
=
AD85/
12
=
Y88*
S88*(
1+
T88)
=
Z88*
S88*(
1+
T88)
=
P88+
U88+
W88+
AA88
=
Q88+
V88+
X88+
AB88
=
P88/
132
=
Q88/
132
=
AC88/
132
=
AD88/
132
=
Y96*
S96*(
1+
T96)
=
Z96*
S96*(
1+
T96)
=
P96+
U96+
W96+
AA96
=
Q96+
V96+
X96+
AB96
=
P96/
M96
=
Q96/
M96
=
AC96/
M96
=
AD96/
M96
=
Y97*
S97*(
1+
T97)
=
Z97*
S97*(
1+
T97)
=
P97+
U97+
W97+
AA97
=
Q97+
V97+
X97+
AB97
=
P97/
M97
=
Q97/
M97
=
AC97/
M97
=
AD97/
M97
=
Y98*
S98*(
1+
T98)
=
Z98*
S98*(
1+
T98)
=
P98+
U98+
W98+
AA98
=
Q98+
V98+
X98+
AB98
=
P98/
27
=
Q98/
27
=
AC98/
27
=
AD98/
27
$
5,650,000.00
$
816,000.00
=
P102+
U102+
W102+
AA102
=
Q102+
V102+
X102+
AB102
=
AC102/
M102
=
AD102/
M102
=
Y103*
S103*(
1+
T103)
=
Z103*
S103*(
1+
T103)
=
P103+
U103+
W103+
AA103+
P104
=
Q103+
V103+
X103+
AB103+
Q104
=
P103/
57
=
Q103/
57
=
AC103/
57
=
AD103/
57
=
Y111*
S111*(
1+
T111)
=
Z111*
S111*(
1+
T111)
=
P111+
U111+
W111+
AA111
=
Q111+
V111+
X111+
AB111
=
P111/
15
=
Q111/
15
=
AC111/
15
=
AD111/
15
February
14,
2003
6
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
Categorical
GM
Non­
Cat.
G
M
#
of
MFJS
#
of
Non­
Cat.
Oily
Waste
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
37
City
of
Independence
MO
9.8
400
0
0
0
0
4
1
2
=
SUM(
F116:
L116)
38
Greenville
Utilities
NC
9.8
33
3
0
5
0
3
5
0
=
SUM(
F117:
L117)
39
City
of
Weatherford
TX
2.4
31
0
0
0
28
3
0
0
=
SUM(
F118:
L118)
40
New
Orleans
East
Bank
LA
95.2
1
1
0
0
0
0
0
0
=
SUM(
F119:
L119)
40
New
Orleans
West
Bank
LA
8.8
0
0
0
0
0
0
0
0
=
SUM(
F120:
L120)
41
City
of
Jamestown
NY
7.0
30
12
1
0
10
2
0
5
=
SUM(
F121:
L121)
42
Regional
Water
Reclamation
Facility­
Medford
OR
15.0
285
4
4
17
45
1
0
33
=
SUM(
F122:
L122)
43
Phoneix
­
91st
Ace.
AZ
139.0
120
23
10
0
7
33
6
19
=
SUM(
F123:
L123)
43
Phoenix
AZ
54.5
57
12
1
0
3
13
5
11
=
SUM(
F124:
L124)
44
Madison
WI
42.0
150
20
0
0
5
1
0
0
=
SUM(
F125:
L125)
45
City
of
Tampa
FL
50.0
80
4
12
0
30
7
0
5
=
SUM(
F126:
L126)
46
District
of
Columbia
DC
318.0
10,000
19
2
0
260
21
5
5
=
SUM(
F127:
L127)
47
City
of
Geneva
NY
2.5
1
0
0
0
1
0
0
0
=
SUM(
F128:
L128)
48
Raleigh
Neuse
River
NC
35.1
28
13
0
0
0
2
0
0
=
SUM(
F129:
L129)
49
Bosie
West
Bosie
WWTP
ID
13.4
830
2
5
0
0
2
0
0
=
SUM(
F130:
L130)
49
Boise,
Lander
Street
WWTP
ID
13.2
410
1
5
0
3
2
0
0
=
SUM(
F131:
L131)
50
Northampton
Publicly
Owned
Treatment
Works
MA
4.5
10
0
0
2
45
0
0
4
=
SUM(
F132:
L132)
51
North
Charleston
SC
15.0
38
1
0
0
0
1
3
0
=
SUM(
F133:
L133)
52
OCSD
WWTP
#
2
CA
151.0
442
229
90
19
0
273
0
0
=
SUM(
F134:
L134)
52
Orange
County
Reclam
Plant
#
1
CA
90.0
53
NORSD
Southerly
WWTP
OH
106.7
581
33
17
113
0
56
30
0
=
SUM(
F136:
L136)
53
NORSD
Westerly
WWTP
OH
32.7
148
12
5
30
0
20
7
0
=
SUM(
F137:
L137)
53
NORSD
Easterly
WWTP
OH
108.0
220
11
16
47
0
38
12
0
=
SUM(
F138:
L138)
54
Akron
WPC
OH
72.0
55
4
0
0
5
19
0
1
=
SUM(
F139:
L139)
55
Battle
Creek
MI
11.5
28
2
0
2
0
0
0
0
=
SUM(
F140:
L140)
56
Atlanta
RM
Clayton
GA
90.0
8
0
7
40
5
5
60
=
SUM(
F141:
L141)
56
Atlanta
South
River
GA
40.0
=
SUM(
F142:
L142)
56
Atlanta
Utoy
Creek
GA
30.0
=
SUM(
F143:
L143)
57
MWRDGC­
Stickney
IL
780.0
941
38
20
20
0
95
768
0
=
SUM(
F144:
L144)/
3
57
MWRDGC­
Calumet
IL
265.0
193
4
16
8
0
4
161
0
=
SUM(
F145:
L145)/
3
57
MWRDGC­
Northside
IL
268.0
396
21
1
1
0
38
335
0
=
SUM(
F146:
L146)/
3
57
MWRDGC­
Kirie
IL
37.0
193
10
5
5
0
32
141
0
=
SUM(
F147:
L147)/
3
57
MWRDGC­
Egan
IL
26.0
50
4
1
0
0
3
42
0
=
SUM(
F148:
L148)/
3
57
MWRDGC­
Hanover
Park
IL
9.0
22
1
0
3
0
0
18
0
=
SUM(
F149:
L149)/
3
57
MWRDGC­
Lemont
IL
2.0
3
0
0
0
0
0
3
0
=
SUM(
F150:
L150)/
3
58
MWRA­
Boston­
Deer
Island
MA
601.4
1473
10
0
0
0
55
1
0
=
SUM(
F151:
L151)
58
MWRA­
Boston­
Clinton
MA
3.4
17
1
0
0
0
2
0
0
=
SUM(
F152:
L152)
59
Philadelphia­
Northeast
PA
196.0
88
12
0
2
0
33
1
0
=
SUM(
F153:
L153)
59
Philadelphia­
Southwest
PA
196.0
31
4
0
1
0
8
1
0
=
SUM(
F154:
L154)
59
Philadelphia­
Southeast
PA
93.0
16
1
0
0
0
4
1
0
=
SUM(
F155:
L155)
60
Nashville­
Central
TN
85.0
30
7
2
2
0
13
0
0
=
SUM(
F156:
L156)
60
Nashville­
Whites
Creek
TN
25.0
4
1
0
0
0
1
0
0
=
SUM(
F157:
L157)
60
Nashville­
Dry
Creek
TN
14.0
8
1
0
1
0
5
0
0
=
SUM(
F158:
L158)
61
Elyria
Wastewater
Pollution
Control
OH
8.7
57
4
0
0
0
2
0
0
62
Johnson
County
Blue
Ridge
#
1
KA
2.08
62
Johnson
County
Mill
Creek
KA
7.92
62
Johnson
County
Mission
Township
KA
7.1
62
Johnson
County
Turkey
Creek
KA
6.86
62
Johnson
County
Little
Bull
Creek
#
2
KA
0.315
62
Johnson
County
Tomahawk
KA
4.55
62
Johnson
County
Little
Bull
Creek
#
1
KA
62
Johnson
County
Blue
Ridge
#
4
KA
63
Wayne
County
MI
50
463
7
2
13
0
11
6
0
=
SUM(
F168:
L168)
64
City
of
Titusville
FL
1.4
2
1
0
0
0
1
1
0
=
SUM(
F169:
L169)
65
City
of
Dayton
OH
52.12
44
23
4
5
20
25
1
15
=
SUM(
F170:
L170)
66
Hillsborough
County
Dak
Mabry
FL
4.13
1
0
0
0
0
0
0
0
=
SUM(
F171:
L171)
66
Hillsborough
County
Eagiles
FL
0.102
0
0
0
0
0
0
0
0
=
SUM(
F172:
L172)

February
14,
2003
7
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
Sampling
Costs
Management
Salary
Hrs
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
Implement
Yearly
Implement
Yearly
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
180
54
=
N116*
R116*(
1+
T116)
=
O116*
R116*(
1+
T116)
$
15.77
$
37.40
0.36
$
3,764.00
$
3,764.00
$
363.00
$
363.00
300
75
872
567
=
N117*
R117*(
1+
T117)
=
O117*
R117*(
1+
T117)
$
19.00
$
25.00
0.40
$
10,000.00
$
10,000.00
$
5,000.00
$
5,000.00
480
160
1,085
1,085
=
N118*
R118*(
1+
T118)
=
O118*
R118*(
1+
T118)
$
14.00
$
20.00
0.39
$
21,824.00
$
21,824.00
$
3,720.00
$
3,720.00
868
434
368
448
=
N119*
R119*(
1+
T119)
=
O119*
R119*(
1+
T119)
$
13.89
$
28.00
0.5
$
36.00
$
48.00
$
350.00
$
500.00
36
48
470
40
=
N121*
R121*(
1+
T121)
=
O121*
R121*(
1+
T121)
$
16.00
$
25.00
0.50
$
20,000.00
$
20,000.00
7,200
4,600
=
N122*
R122*(
1+
T122)
=
O122*
R122*(
1+
T122)
$
24.00
$
30.00
0.15
$
150,000.00
$
150,000.00
$
80,000.00
$
80,000.00
700
700
6,794
4,220
=
N123*
R123*(
1+
T123)
=
O123*
R123*(
1+
T123)
$
19.50
$
35.50
0.78
$
412,814.00
$
427,032.00
$
92,083.00
$
96,159.00
260
250
430
93
=
N125*
R125*(
1+
T125)
=
O125*
R125*(
1+
T125)
$
18.00
$
23.00
0.75
$
15,000.00
$
3,000.00
$
2,500.00
$
2,500.00
450
150
840
820
=
N126*
R126*(
1+
T126)
=
O126*
R126*(
1+
T126)
$
21.00
$
34.00
0.15
$
28,000.00
$
28,000.00
$
8,000.00
$
8,000.00
250
200
$
10,000
$
1,000
NA
NA
NA
$
50,000.00
$
50,000.00
$
20,000.00
$
20,000.00
NA
NA
28
22
=
N128*
R128*(
1+
T128)
=
O128*
R128*(
1+
T128)
$
20.00
$
30.00
0.50
$
2,000.00
$
2,000.00
$
232.00
$
232.00
29
14
=
N129*
R129*(
1+
T129)
=
O129*
R129*(
1+
T129)
$
13.00
$
23.06
780
780
80
50
=
N130*
R130*(
1+
T130)
=
O130*
R130*(
1+
T130)
$
16.00
$
19.00
0.825
80
50
407
116
=
N132*
R132*(
1+
T132)
=
O132*
R132*(
1+
T132)
$
18.00
0.60
$
15,300.00
$
15,900.00
$
1,836.00
$
1,872.00
165
110
=
N133*
R133*(
1+
T133)
=
O133*
R133*(
1+
T133)
$
18.00
$
30.00
0.1
$
5,000.00
$
2,000.00
$
1,500.00
$
1,500.00
2
1
28,330
10,730
=
N134*
R134*(
1+
T134)
=
O134*
R134*(
1+
T134)
$
30.00
$
42.00
0.33
$
200,000.00
$
100,000.00
$
135,000.00
$
68,000.00
16,482
7,914
=
N136*
R136*(
1+
T136)
=
O136*
R136*(
1+
T136)
$
21.00
$
28.00
0.5
$
179,037.00
$
84,037.00
$
115,824.00
$
120,456.00
1,440
1,440
464
104
=
N139*
R139*(
1+
T139)
=
O139*
R139*(
1+
T139)
$
19.73
$
27.05
0.5
=
1800*
29
=
1800*
29
=
720*
29
=
720*
29
84
72
159
132
=
N140*
R140*(
1+
T140)
=
O140*
R140*(
1+
T140)
$
19.25
$
23.00
$
4,020.00
$
4,020.00
$
1,800.00
$
1,800.00
100
100
24,000
8,000
=
N141*
R141*(
1+
T141)
=
O141*
R141*(
1+
T141)
$
15.00
$
24.00
0.4
$
285,000.00
$
295,000.00
$
80,000.00
$
83,000.00
7,440
7,440
22,833
10,036
=
N144*
R144*(
T144)
=
O144*
R144*(
T144)
$
20.16
$
35.35
1.0817
$
1,030,900.00
$
1,030,900.00
$
95,160.00
$
95,160.00
1,500
750
9,435
9,435
$
25.05
$
31.19
0.804
$
68,325.18
$
68,325.18
$
120,060.00
$
129,720.00
202
202
411
258
=
N153*
R153*(
T153)
=
O153*
R153*(
T153)
$
22.00
$
32.00
4.52
=
562*
68
=
562*
68
=
372*
68
=
372*
68
40
40
=
53*
33
=
37*
33
=
N156*
R156*(
1+
T156)
=
O156*
R156*(
1+
T156)
$
19.50
$
24.50
0.5
$
153,000.00
$
153,000.00
$
40,800.00
$
40,800.00
135
60
578
190
=
N168*
R168*(
1+
T168)
=
O168*
R168*(
1+
T168)
$
22.00
$
30.00
2.75
=
M168*
650
=
M168*
650
=
M168*
100
=
M168*
100
400
100
2112
2112
=
N169*
R169*(
1+
T169)
=
O169*
R169*(
1+
T169)
$
15.27
$
21.62
1.42
$
19,500.00
$
19,500.00
$
12,223.00
$
12,223.00
400
400
6071
5861
=
N170*
R170*(
1+
T170)
=
O170*
R170*(
1+
T170)
$
20.00
$
25.00
0.25
$
55,800.00
$
55,800.00
$
41,850.00
$
41,850.00
663
313
$
20.00
$
33.00
0.04
February
14,
2003
8
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
AA
AB
AC
AD
AE
AF
AG
AH
Management
Overhead
Costs
Total
Costs
Permitting
Costs
Per
Facility
Total
Costs
Per
Facility
Implement
Yearly
Implement
Yearly
Implement
Yearly
Implement
Yearly
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
=
Y116*
S116*(
1+
T116)
=
Z116*
S116*(
1+
T116)
=
P116+
U116+
W116+
AA116
=
Q116+
V116+
X116+
AB116
=
P116/
M116
=
Q116/
M116
=
AC116/
M116
=
AD116/
M116
=
Y117*
S117*(
1+
T117)
=
Z117*
S117*(
1+
T117)
=
P117+
U117+
W117+
AA117
=
Q117+
V117+
X117+
AB117
=
P117/
M117
=
Q117/
M117
=
AC117/
M117
=
AD117/
M117
=
Y118*
S118*(
1+
T118)
=
Z118*
S118*(
1+
T118)
=
P118+
U118+
W118+
AA118
=
Q118+
V118+
X118+
AB118
=
P118/
M118
=
Q118/
M118
=
AC118/
M118
=
AD118/
M118
=
Y119*
S119*(
1+
T119)
=
Z119*
S119*(
1+
T119)
=
P119+
U119+
W119+
AA119
=
Q119+
V119+
X119+
AB119
=
P119/
M119
=
Q119/
M119
=
AC119/
M119
=
AD119/
M119
=
Y121*
S121*(
1+
T121)
=
Z121*
S121*(
1+
T121)
=
P121+
U121+
W121+
AA121
=
Q121+
V121+
X121+
AB121
=
P121/
M121
=
Q121/
M121
=
AC121/
M121
=
AD121/
M121
=
Y122*
S122*(
1+
T122)
=
Z122*
S122*(
1+
T122)
=
P122+
U122+
W122+
AA122
=
Q122+
V122+
X122+
AB122
=
P122/
M122
=
Q122/
M122
=
AC122/
M122
=
AD122/
M122
=
Y123*
S123*(
1+
T123)
=
Z123*
S123*(
1+
T123)
=
P123+
U123+
W123+
AA123
=
Q123+
V123+
X123+
AB123
=
P123/
143
=
Q123/
143
=
AC123/
143
=
AD123/
143
=
Y125*
S125*(
1+
T125)
=
Z125*
S125*(
1+
T125)
=
P125+
U125+
W125+
AA125
=
Q125+
V125+
X125+
AB125
=
P125/
M125
=
Q125/
M125
=
AC125/
M125
=
AD125/
M125
=
Y126*
S126*(
1+
T126)
=
Z126*
S126*(
1+
T126)
=
P126+
U126+
W126+
AA126
=
Q126+
V126+
X126+
AB126
=
P126/
M126
=
Q126/
M126
=
AC126/
M126
=
AD126/
M126
$
25,000.00
$
25,000.00
=
P127+
U127+
W127+
AA127
=
Q127+
V127+
X127+
AB127
=
P127/
M127
=
Q127/
M127
=
AC127/
M127
=
AD127/
M127
=
Y128*
S128*(
1+
T128)
=
Z128*
S128*(
1+
T128)
=
P128+
U128+
W128+
AA128
=
Q128+
V128+
X128+
AB128
=
P128/
M128
=
Q128/
M128
=
AC128/
M128
=
AD128/
M128
=
Y129*
S129*(
1+
T129)
=
Z129*
S129*(
1+
T129)
=
P129+
U129+
W129+
AA129
=
Q129+
V129+
X129+
AB129
=
AC129/
M129
=
AD129/
M129
=
Y130*
S130*(
1+
T130)
=
Z130*
S130*(
1+
T130)
=
P130+
U130+
W130+
AA130
=
Q130+
V130+
X130+
AB130
=
P130/
20
=
Q130/
20
=
AC130/
20
=
AD130/
20
=
Y132*
S132*(
1+
T132)
=
Z132*
S132*(
1+
T132)
=
P132+
U132+
W132+
AA132
=
Q132+
V132+
X132+
AB132
=
P132/
M132
=
Q132/
M132
=
AC132/
M132
=
AD132/
M132
=
Y133*
S133*(
1+
T133)
=
Z133*
S133*(
1+
T133)
=
P133+
U133+
W133+
AA133
=
Q133+
V133+
X133+
AB133
=
P133/
M133
=
Q133/
M133
=
AC133/
M133
=
AD133/
M133
$
50,000.00
$
25,000.00
=
P134+
U134+
W134+
AA134
=
Q134+
V134+
X134+
AB134
=
P134/
M134
=
Q134/
M134
=
AC134/
M134
=
AD134/
M134
=
Y136*
S136*(
1+
T136)
=
Z136*
S136*(
1+
T136)
=
P136+
U136+
W136+
AA136
=
Q136+
V136+
X136+
AB136
=
P136/
547
=
Q136/
547
=
AC136/
547
=
AD136/
547
=
Y139*
S139*(
1+
T139)
=
Z139*
S139*(
1+
T139)
=
P139+
U139+
W139+
AA139
=
Q139+
V139+
X139+
AB139
=
P139/
M139
=
Q139/
M139
=
AC139/
M139
=
AD139/
M139
=
Y140*
S140*(
1+
T140)
=
Z140*
S140*(
1+
T140)
=
P140+
U140+
W140+
AA140
=
Q140+
V140+
X140+
AB140
=
P140/
M140
=
Q140/
M140
=
AC140/
M140
=
AD140/
M140
=
Y141*
S141*(
1+
T141)
=
Z141*
S141*(
1+
T141)
=
P141+
U141+
W141+
AA141
=
Q141+
V141+
X141+
AB141
=
P141/
M141
=
Q141/
M141
=
AC141/
M141
=
AD141/
M141
=
Y144*
S144*(
T144)
=
Z144*
S144*(
T144)
=
P144+
U144+
W144+
AA144
=
Q144+
V144+
X144+
AB144
=
P144/
599
=
Q144/
599
=
AC144/
599
=
AD144/
599
=
Y151*
S151*(
1+
T151)
=
Z151*
S151*(
1+
T151)
=
P151+
U151+
W151+
AA151
=
Q151+
V151+
X151+
AB151
=
AC151/
69
=
AD151/
69
=
Y153*
S153*(
T153)
=
Z153*
S153*(
T153)
=
P153+
U153+
W153+
AA153
=
Q153+
V153+
X153+
AB153
=
P153/
68
=
Q153/
68
=
AC153/
68
=
AD153/
68
=
Y156*
S156*(
1+
T156)
=
Z156*
S156*(
1+
T156)
=
P156+
U156+
W156+
AA156
=
Q156+
V156+
X156+
AB156
=
P156/
33
=
Q156/
33
=
AC156/
33
=
AD156/
33
=
Y168*
S168*(
1+
T168)
=
Z168*
S168*(
1+
T168)
=
P168+
U168+
W168+
AA168
=
Q168+
V168+
X168+
AB168
=
P168/
33
=
Q168/
33
=
AC168/
33
=
AD168/
33
=
Y169*
S169*(
1+
T169)
=
Z169*
S169*(
1+
T169)
=
P169+
U169+
W169+
AA169
=
Q169+
V169+
X169+
AB169
=
P169/
33
=
Q169/
33
=
AC169/
33
=
AD169/
33
=
Y170*
S170*(
1+
T170)
=
Z170*
S170*(
1+
T170)
=
P170+
U170+
W170+
AA170
=
Q170+
V170+
X170+
AB170
=
P170/
33
=
Q170/
33
=
AC170/
33
=
AD170/
33
February
14,
2003
9
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
Categorical
GM
Non­
Cat.
G
M
#
of
MFJS
#
of
Non­
Cat.
Oily
Waste
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
173
174
175
176
177
178
66
Hillsborough
County
Falkenburg
Road
FL
5.13
6
0
0
0
0
0
0
0
=
SUM(
F173:
L173)
66
Hillsborough
County
Northwest
Regional
FL
4
1
0
0
0
0
0
0
0
=
SUM(
F174:
L174)
66
Hillsborough
County
River
Oaks
FL
5.81
10
1
0
1
0
2
0
0
=
SUM(
F175:
L175)
66
Hillsborough
County
South
County
FL
2.74
0
0
0
0
0
0
0
0
=
SUM(
F176:
L176)
66
Hillsborough
County
Valvico
FL
3.24
3
0
0
0
0
0
0
0
=
SUM(
F177:
L177)
66
Hillsborough
County
Van
Dyke
FL
0.66
0
0
0
0
0
0
0
0
=
SUM(
F178:
L178)

February
14,
2003
10
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
Sampling
Costs
Management
Salary
Hrs
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
Implement
Yearly
Implement
Yearly
173
174
175
176
177
178
February
14,
2003
11
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
AA
AB
AC
AD
AE
AF
AG
AH
Management
Overhead
Costs
Total
Costs
Permitting
Costs
Per
Facility
Total
Costs
Per
Facility
Implement
Yearly
Implement
Yearly
Implement
Yearly
Implement
Yearly
173
174
175
176
177
178
February
14,
2003
12
of
32
MPM­
COSTS­
formula.
xls
­
All
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
89
10
11
12
13
14
15
16
17
18
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
#
of
MFJS
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
3
Landis
Sewerage
Authority
NJ
5.6
0
0
0
0
0
0
0
0
0
4
Madison­
Chatham
Joint
Meeting
NJ
2.5
79
0
0
0
0
0
0
0
=
SUM(
F4:
L4)
13
Marshall
Municipal
Utilities
MO
3.7
3
0
0
0
0
0
0
0
=
SUM(
F5:
L5)
16
Jasper
Waterworks
&
Sewer
Board
AL
4.8
1
0
1
0
0
0
0
0
=
SUM(
F6:
L6)
26
Blacksburg­
VPI
Sanitation
Authority
VA
5.2
2
2
0
0
0
0
0
0
=
SUM(
F7:
L7)
28
Fox
Lake
Northwest
Regional
IL
6.1
3
2
1
1
0
3
0
0
=
SUM(
F8:
L8)
28
Fox
Lake
Tall
Oaks
IL
0.4
=
SUM(
F9:
L9)
37
City
of
Independence
MO
9.8
400
0
0
0
0
4
1
2
=
SUM(
F10:
L10)
38
Greenville
Utilities
NC
9.8
33
3
0
5
0
3
5
0
=
SUM(
F11:
L11)
39
City
of
Weatherford
TX
2.4
31
0
0
0
28
3
0
0
=
SUM(
F12:
L12)
41
City
of
Jamestown
NY
7.0
30
12
1
0
10
2
0
5
=
SUM(
F13:
L13)
47
City
of
Geneva
NY
2.5
1
0
0
0
1
0
0
0
=
SUM(
F14:
L14)
50
Northampton
Publicly
Owned
Treatment
Works
MA
4.5
10
0
0
2
45
0
0
4
=
SUM(
F15:
L15)
61
Elyria
Wastewater
Pollution
Control
OH
8.7
57
4
0
0
0
2
0
0
64
City
of
Titusville
FL
1.4
2
1
0
0
0
1
1
0
=
SUM(
F17:
L17)
Categorical
GM
Non­
Cat.
G
M
#
of
Non­
Cat.
Oily
Waste
February
14,
2003
13
of
32
MPM­
COSTS­
formula.
xls
­
<
10MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
89
10
11
12
13
14
15
16
17
18
A
B
Survey
Agency
Number
3
Landis
Sewerage
Authority
4
Madison­
Chatham
Joint
Meeting
13
Marshall
Municipal
Utilities
16
Jasper
Waterworks
&
Sewer
Board
26
Blacksburg­
VPI
Sanitation
Authority
28
Fox
Lake
Northwest
Regional
28
Fox
Lake
Tall
Oaks
37
City
of
Independence
38
Greenville
Utilities
39
City
of
Weatherford
41
City
of
Jamestown
47
City
of
Geneva
50
Northampton
Publicly
Owned
Treatment
Works
61
Elyria
Wastewater
Pollution
Control
64
City
of
Titusville
N
O
P
Q
R
S
T
U
V
W
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
Implement
=
N3*
R3*(
1+
T3)
=
O3*
R3*(
1+
T3)
=
N4*
R4*(
1+
T4)
=
O4*
R4*(
1+
T4)
$
0
$
0
$
19.90
$
32.75
0.48
$
0.00
$
0.00
$
0.00
=
N6*
R6*(
1+
T6)
=
O6*
R6*(
1+
T6)
=
N7*
R7*(
1+
T7)
=
O7*
R7*(
1+
T7)
=
N8*
R8*(
1+
T8)
=
O8*
R8*(
1+
T8)
$
17.50
$
25.00
0.30
180
54
=
N10*
R10*(
1+
T10)
=
O10*
R10*(
1+
T10)
$
15.77
$
37.40
0.36
$
3,764.00
$
3,764.00
$
363.00
872
567
=
N11*
R11*(
1+
T11)
=
O11*
R11*(
1+
T11)
$
19.00
$
25.00
0.40
$
10,000.00
$
10,000.00
$
5,000.00
1,085
1,085
=
N12*
R12*(
1+
T12)
=
O12*
R12*(
1+
T12)
$
14.00
$
20.00
0.39
$
21,824.00
$
21,824.00
$
3,720.00
470
40
=
N13*
R13*(
1+
T13)
=
O13*
R13*(
1+
T13)
$
16.00
$
25.00
0.50
$
20,000.00
$
20,000.00
28
22
=
N14*
R14*(
1+
T14)
=
O14*
R14*(
1+
T14)
$
20.00
$
30.00
0.50
$
2,000.00
$
2,000.00
$
232.00
407
116
=
N15*
R15*(
1+
T15)
=
O15*
R15*(
1+
T15)
$
18.00
0.60
$
15,300.00
$
15,900.00
$
1,836.00
2112
2112
=
N17*
R17*(
1+
T17)
=
O17*
R17*(
1+
T17)
$
15.27
$
21.62
1.42
$
19,500.00
$
19,500.00
$
12,223.00
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
Sampling
Costs
February
14,
2003
14
of
32
MPM­
COSTS­
formula.
xls
­
<
10MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
89
10
11
12
13
14
15
16
17
18
A
B
Survey
Agency
Number
3
Landis
Sewerage
Authority
4
Madison­
Chatham
Joint
Meeting
13
Marshall
Municipal
Utilities
16
Jasper
Waterworks
&
Sewer
Board
26
Blacksburg­
VPI
Sanitation
Authority
28
Fox
Lake
Northwest
Regional
28
Fox
Lake
Tall
Oaks
37
City
of
Independence
38
Greenville
Utilities
39
City
of
Weatherford
41
City
of
Jamestown
47
City
of
Geneva
50
Northampton
Publicly
Owned
Treatment
Works
61
Elyria
Wastewater
Pollution
Control
64
City
of
Titusville
X
Y
Z
AA
AB
AC
AD
Yearly
Implement
Yearly
Implement
Yearly
Implement
Yearly
=
Y3*
S3*(
1+
T3)
=
Z3*
S3*(
1+
T3)
=
P3+
U3+
W3+
AA3
=
Q3+
V3+
X3+
AB3
=
Y4*
S4*(
1+
T4)
=
Z4*
S4*(
1+
T4)
=
P4+
U4+
W4+
AA4
=
Q4+
V4+
X4+
AB4
$
0.00
$
0.00
$
0.00
$
0.00
$
0.00
=
Y6*
S6*(
1+
T6)
=
Z6*
S6*(
1+
T6)
=
P6+
U6+
W6+
AA6
=
Q6+
V6+
X6+
AB6
=
Y7*
S7*(
1+
T7)
=
Z7*
S7*(
1+
T7)
=
P7+
U7+
W7+
AA7
=
Q7+
V7+
X7+
AB7
=
Y8*
S8*(
1+
T8)
=
Z8*
S8*(
1+
T8)
$
0.00
$
0.00
$
363.00
300
75
=
Y10*
S10*(
1+
T10)
=
Z10*
S10*(
1+
T10)
=
P10+
U10+
W10+
AA10
=
Q10+
V10+
X10+
AB10
$
5,000.00
480
160
=
Y11*
S11*(
1+
T11)
=
Z11*
S11*(
1+
T11)
=
P11+
U11+
W11+
AA11
=
Q11+
V11+
X11+
AB11
$
3,720.00
868
434
=
Y12*
S12*(
1+
T12)
=
Z12*
S12*(
1+
T12)
=
P12+
U12+
W12+
AA12
=
Q12+
V12+
X12+
AB12
=
Y13*
S13*(
1+
T13)
=
Z13*
S13*(
1+
T13)
=
P13+
U13+
W13+
AA13
=
Q13+
V13+
X13+
AB13
$
232.00
29
14
=
Y14*
S14*(
1+
T14)
=
Z14*
S14*(
1+
T14)
=
P14+
U14+
W14+
AA14
=
Q14+
V14+
X14+
AB14
$
1,872.00
=
Y15*
S15*(
1+
T15)
=
Z15*
S15*(
1+
T15)
=
P15+
U15+
W15+
AA15
=
Q15+
V15+
X15+
AB15
$
12,223.00
400
400
=
Y17*
S17*(
1+
T17)
=
Z17*
S17*(
1+
T17)
=
P17+
U17+
W17+
AA17
=
Q17+
V17+
X17+
AB17
Sampling
Costs
Management
Salary
Hrs
Management
Overhead
Costs
Total
Costs
February
14,
2003
15
of
32
MPM­
COSTS­
formula.
xls
­
<
10MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
89
10
11
12
13
14
15
16
17
18
A
B
Survey
Agency
Number
3
Landis
Sewerage
Authority
4
Madison­
Chatham
Joint
Meeting
13
Marshall
Municipal
Utilities
16
Jasper
Waterworks
&
Sewer
Board
26
Blacksburg­
VPI
Sanitation
Authority
28
Fox
Lake
Northwest
Regional
28
Fox
Lake
Tall
Oaks
37
City
of
Independence
38
Greenville
Utilities
39
City
of
Weatherford
41
City
of
Jamestown
47
City
of
Geneva
50
Northampton
Publicly
Owned
Treatment
Works
61
Elyria
Wastewater
Pollution
Control
64
City
of
Titusville
AE
AF
AG
AH
Implement
Yearly
Implement
Yearly
=
P10/
M10
=
Q10/
M10
=
AC10/
M10
=
AD10/
M10
=
P11/
M11
=
Q11/
M11
=
AC11/
M11
=
AD11/
M11
=
P12/
M12
=
Q12/
M12
=
AC12/
M12
=
AD12/
M12
=
P13/
M13
=
Q13/
M13
=
AC13/
M13
=
AD13/
M13
=
P14/
M14
=
Q14/
M14
=
AC14/
M14
=
AD14/
M14
=
P15/
M15
=
Q15/
M15
=
AC15/
M15
=
AD15/
M15
=
P17/
33
=
Q17/
33
=
AC17/
33
=
AD17/
33
=
AVERAGE(
AE3:
AE17)
=
AVERAGE(
AF3:
AF17)
=
AVERAGE(
AG3:
AG17)
=
AVERAGE(
AH3:
AH17)
Total
Costs
Per
Facility
Permitting
Costs
Per
Facility
February
14,
2003
16
of
32
MPM­
COSTS­
formula.
xls
­
<
10MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
45
6
789
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
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
#
of
MFJS
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
5
Somerset
NJ
15.0
18
1
0
0
0
1
0
0
=
SUM(
F3:
L3)
6
Albany
County
Sewer
District
NY
19.0
14
0
0
0
0
0
0
0
=
SUM(
F4:
L4)
6
Albany
South
Plant
NY
20.0
2
0
0
0
0
0
0
0
=
SUM(
F5:
L5)
7
City
of
Niagra
Falls
NY
35.0
225
0
0
0
10
1
0
0
=
SUM(
F6:
L6)
10
City
of
Clearwater
(
Marshall
Street)
FL
6.5
2
2
1
2
6
2
0
5
=
SUM(
F7:
L7)
10
Clearwater
Northeast
FL
5.5
12
0
2
0
6
2
0
8
=
SUM(
F8:
L8)
10
Clearwater
East
FL
2.3
5
0
0
0
4
0
0
0
=
SUM(
F9:
L9)
14
City
of
Hamilton
OH
21.0
121
0
0
0
8
3
0
1
=
SUM(
F10:
L10)
15
Racine
WI
30.9
50
8
6
7
1
15
0
1
=
SUM(
F11:
L11)
18
Little
Rock
Adams
Field
AR
18.0
4
2
0
0
0
0
0
0
=
SUM(
F12:
L12)
18
City
of
Little
Rock,
Wastewater
Utility
AR
14.0
8
5
0
1
0
0
0
0
=
SUM(
F13:
L13)
19
Fayetteville
AR
11.8
11
4
1
1
0
0
0
0
=
SUM(
F14:
L14)
21
South
San
Francisco
(
SBSA)
CA
20.3
38
16
8
0
0
5
0
0
=
SUM(
F15:
L15)
24
City
of
Tacoma
WA
23.0
3387
0
12
2
35
5
2
12
=
SUM(
F16:
L16)
24
City
of
Tacoma,
Central
Treatment
Plant
WA
4.4
=
SUM(
F17:
L17)
29
Fox
River
WRD
South
Plant
IL
15.0
4
1
0
0
0
1
2
0
=
SUM(
F18:
L18)
29
Fox
River
WRD
North
Plant
IL
5.0
7
2
0
0
0
2
3
0
=
SUM(
F19:
L19)
29
Rox
River
WRD
West
Plant
IL
0.7
1
0
0
0
0
1
0
0
=
SUM(
F20:
L20)
31
City
of
Everett
WA
17.6
25
1
0
0
0
6
0
0
=
SUM(
F21:
L21)
32
Spokane
WA
40.0
9
3
4
0
40
4
0
5
=
SUM(
F22:
L22)
42
Regional
Water
Reclamation
Facility­
Medford
OR
15.0
285
4
4
17
45
1
0
33
=
SUM(
F23:
L23)
44
Madison
WI
42.0
150
20
0
0
5
1
0
0
=
SUM(
F24:
L24)
48
Raleigh
Neuse
River
NC
35.1
28
13
0
0
0
2
0
0
=
SUM(
F25:
L25)
49
Bosie
West
Bosie
WWTP
ID
13.4
830
2
5
0
0
2
0
0
=
SUM(
F26:
L26)
49
Boise,
Lander
Street
WWTP
ID
13.2
410
1
5
0
3
2
0
0
=
SUM(
F27:
L27)
51
North
Charleston
SC
15.0
38
1
0
0
0
1
3
0
=
SUM(
F28:
L28)
55
Battle
Creek
MI
11.5
28
2
0
2
0
0
0
0
=
SUM(
F29:
L29)
62
Johnson
County
Blue
Ridge
#
1
KA
2.08
62
Johnson
County
Mill
Creek
KA
7.92
62
Johnson
County
Mission
Township
KA
7.1
62
Johnson
County
Turkey
Creek
KA
6.86
62
Johnson
County
Little
Bull
Creek
#
2
KA
0.315
62
Johnson
County
Tomahawk
KA
4.55
62
Johnson
County
Little
Bull
Creek
#
1
KA
62
Johnson
County
Blue
Ridge
#
4
KA
66
Hillsborough
County
Dak
Mabry
FL
4.13
1
0
0
0
0
0
0
0
=
SUM(
F38:
L38)
66
Hillsborough
County
Eagiles
FL
0.102
0
0
0
0
0
0
0
0
=
SUM(
F39:
L39)
66
Hillsborough
County
Falkenburg
Road
FL
5.13
6
0
0
0
0
0
0
0
=
SUM(
F40:
L40)
66
Hillsborough
County
Northwest
Regional
FL
4
1
0
0
0
0
0
0
0
=
SUM(
F41:
L41)
66
Hillsborough
County
River
Oaks
FL
5.81
10
1
0
1
0
2
0
0
=
SUM(
F42:
L42)
66
Hillsborough
County
South
County
FL
2.74
0
0
0
0
0
0
0
0
=
SUM(
F43:
L43)
66
Hillsborough
County
Valvico
FL
3.24
3
0
0
0
0
0
0
0
=
SUM(
F44:
L44)
66
Hillsborough
County
Van
Dyke
FL
0.66
0
0
0
0
0
0
0
0
=
SUM(
F45:
L45)
Categorical
GM
Non­
Cat.
G
M
#
of
Non­
Cat.
Oily
Waste
February
14,
2003
17
of
32
MPM­
COSTS­
formula.
xls
­
10­
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
45
6
789
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
A
B
Survey
Agency
Number
5
Somerset
6
Albany
County
Sewer
District
6
Albany
South
Plant
7
City
of
Niagra
Falls
10
City
of
Clearwater
(
Marshall
Street)
10
Clearwater
Northeast
10
Clearwater
East
14
City
of
Hamilton
15
Racine
18
Little
Rock
Adams
Field
18
City
of
Little
Rock,
Wastewater
Utility
19
Fayetteville
21
South
San
Francisco
(
SBSA)
24
City
of
Tacoma
24
City
of
Tacoma,
Central
Treatment
Plant
29
Fox
River
WRD
South
Plant
29
Fox
River
WRD
North
Plant
29
Rox
River
WRD
West
Plant
31
City
of
Everett
32
Spokane
42
Regional
Water
Reclamation
Facility­
Medford
44
Madison
48
Raleigh
Neuse
River
49
Bosie
West
Bosie
WWTP
49
Boise,
Lander
Street
WWTP
51
North
Charleston
55
Battle
Creek
62
Johnson
County
Blue
Ridge
#
1
62
Johnson
County
Mill
Creek
62
Johnson
County
Mission
Township
62
Johnson
County
Turkey
Creek
62
Johnson
County
Little
Bull
Creek
#
2
62
Johnson
County
Tomahawk
62
Johnson
County
Little
Bull
Creek
#
1
62
Johnson
County
Blue
Ridge
#
4
66
Hillsborough
County
Dak
Mabry
66
Hillsborough
County
Eagiles
66
Hillsborough
County
Falkenburg
Road
66
Hillsborough
County
Northwest
Regional
66
Hillsborough
County
River
Oaks
66
Hillsborough
County
South
County
66
Hillsborough
County
Valvico
66
Hillsborough
County
Van
Dyke
N
O
P
Q
R
S
T
U
V
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
=
N3*
R3*(
1+
T3)
=
O3*
R3*(
1+
T3)
$
21.00
$
21.00
730
360
=
N4*
R4*(
1+
T4)
=
O4*
R4*(
1+
T4)
$
25.00
$
25.00
0.3
$
10,000.00
$
10,000.00
321
95
=
N6*
R6*(
1+
T6)
=
O6*
R6*(
1+
T6)
$
20.25
$
29.40
0.35
$
8,000.00
$
8,000.00
202
113
=
N7*
R7*(
1+
T7)
=
O7*
R7*(
1+
T7)
$
16.98
$
24.10
1.025
227
162
=
N10*
R10*(
1+
T10)
=
O10*
R10*(
1+
T10)
$
25.50
$
25.50
0.05
$
9,000.00
$
9,000.00
2,318
1,558
=
N11*
R11*(
1+
T11)
=
O11*
R11*(
1+
T11)
$
19.50
$
32.00
0.3
$
21,328.00
$
21,328.00
200
114
=
N12*
R12*(
1+
T12)
=
O12*
R12*(
1+
T12)
$
15.00
$
20.00
0
$
10,000.00
$
10,000.00
588
228
=
N14*
R14*(
1+
T14)
=
O14*
R14*(
1+
T14)
$
14.00
$
25.00
0.35
$
6,000.00
$
6,000.00
1,100
260
=
N15*
R15*(
1+
T15)
=
O15*
R15*(
1+
T15)
$
28.49
$
39.07
0.47
$
142,000.00
$
142,000.00
239
179
=
N16*
R16*(
1+
T16)
=
O16*
R16*(
1+
T16)
$
25.00
$
39.00
0.23
$
54,400.00
$
54,400.00
415
280
=
N18*
R18*(
1+
T18)
=
O18*
R18*(
1+
T18)
$
22.61
$
25.78
1
$
30,000.00
$
30,000.00
248
212
=
N21*
R21*(
1+
T21)
=
O21*
R21*(
1+
T21)
$
27.45
$
34.59
0.29
$
8,400.00
$
16,800.00
3,100
1,110
=
N22*
R22*(
1+
T22)
=
O22*
R22*(
1+
T22)
$
20.00
$
30.00
0.68
$
100,000.00
$
75,000.00
7,200
4,600
=
N23*
R23*(
1+
T23)
=
O23*
R23*(
1+
T23)
$
24.00
$
30.00
0.15
$
150,000.00
$
150,000.00
430
93
=
N24*
R24*(
1+
T24)
=
O24*
R24*(
1+
T24)
$
18.00
$
23.00
0.75
$
15,000.00
$
3,000.00
=
N25*
R25*(
1+
T25)
=
O25*
R25*(
1+
T25)
$
13.00
$
23.06
80
50
=
N26*
R26*(
1+
T26)
=
O26*
R26*(
1+
T26)
$
16.00
$
19.00
0.825
165
110
=
N28*
R28*(
1+
T28)
=
O28*
R28*(
1+
T28)
$
18.00
$
30.00
0.1
$
5,000.00
$
2,000.00
159
132
=
N29*
R29*(
1+
T29)
=
O29*
R29*(
1+
T29)
$
19.25
$
23.00
$
4,020.00
$
4,020.00
$
20.00
$
33.00
0.04
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
February
14,
2003
18
of
32
MPM­
COSTS­
formula.
xls
­
10­
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
45
6
789
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
A
B
Survey
Agency
Number
5
Somerset
6
Albany
County
Sewer
District
6
Albany
South
Plant
7
City
of
Niagra
Falls
10
City
of
Clearwater
(
Marshall
Street)
10
Clearwater
Northeast
10
Clearwater
East
14
City
of
Hamilton
15
Racine
18
Little
Rock
Adams
Field
18
City
of
Little
Rock,
Wastewater
Utility
19
Fayetteville
21
South
San
Francisco
(
SBSA)
24
City
of
Tacoma
24
City
of
Tacoma,
Central
Treatment
Plant
29
Fox
River
WRD
South
Plant
29
Fox
River
WRD
North
Plant
29
Rox
River
WRD
West
Plant
31
City
of
Everett
32
Spokane
42
Regional
Water
Reclamation
Facility­
Medford
44
Madison
48
Raleigh
Neuse
River
49
Bosie
West
Bosie
WWTP
49
Boise,
Lander
Street
WWTP
51
North
Charleston
55
Battle
Creek
62
Johnson
County
Blue
Ridge
#
1
62
Johnson
County
Mill
Creek
62
Johnson
County
Mission
Township
62
Johnson
County
Turkey
Creek
62
Johnson
County
Little
Bull
Creek
#
2
62
Johnson
County
Tomahawk
62
Johnson
County
Little
Bull
Creek
#
1
62
Johnson
County
Blue
Ridge
#
4
66
Hillsborough
County
Dak
Mabry
66
Hillsborough
County
Eagiles
66
Hillsborough
County
Falkenburg
Road
66
Hillsborough
County
Northwest
Regional
66
Hillsborough
County
River
Oaks
66
Hillsborough
County
South
County
66
Hillsborough
County
Valvico
66
Hillsborough
County
Van
Dyke
W
X
Y
Z
AA
AB
AC
AD
Implement
Yearly
Implement
Yearly
Implement
Yearly
Implement
Yearly
=
Y3*
S3*(
1+
T3)
=
Z3*
S3*(
1+
T3)
=
P3+
U3+
W3+
AA3
=
Q3+
V3+
X3+
AB3
$
2,000.00
$
2,000.00
=
Y4*
S4*(
1+
T4)
=
Z4*
S4*(
1+
T4)
=
P4+
U4+
W4+
AA4
=
Q4+
V4+
X4+
AB4
$
3,200.00
$
3,200.00
4
4
=
Y6*
S6*(
1+
T6)
=
Z6*
S6*(
1+
T6)
=
P6+
U6+
W6+
AA6
=
Q6+
V6+
X6+
AB6
$
646.00
$
680.00
320
320
=
Y7*
S7*(
1+
T7)
=
Z7*
S7*(
1+
T7)
=
P7+
U7+
W7+
AA7
=
Q7+
V7+
X7+
AB7
=
Y8*
S8*(
1+
T8)
=
Z8*
S8*(
1+
T8)
=
P8+
U8+
W8+
AA8
=
Q8+
V8+
X8+
AB8
$
1,350.00
$
1,350.00
227
142
=
Y10*
S10*(
1+
T10)
=
Z10*
S10*(
1+
T10)
=
P10+
U10+
W10+
AA10
=
Q10+
V10+
X10+
AB10
$
27,720.00
$
27,720.00
200
50
=
Y11*
S11*(
1+
T11)
=
Z11*
S11*(
1+
T11)
=
P11+
U11+
W11+
AA11
=
Q11+
V11+
X11+
AB11
$
1,920.00
$
1,920.00
200
100
=
Y12*
S12*(
1+
T12)
=
Z12*
S12*(
1+
T12)
=
P12+
U12+
W12+
AA12
=
Q12+
V12+
X12+
AB12
$
500.00
$
500.00
400
200
=
Y14*
S14*(
1+
T14)
=
Z14*
S14*(
1+
T14)
=
P14+
U14+
W14+
AA14
=
Q14+
V14+
X14+
AB14
$
20,300.00
$
20,300.00
180
105
=
Y15*
S15*(
1+
T15)
=
Z15*
S15*(
1+
T15)
=
P15+
U15+
W15+
AA15
=
Q15+
V15+
X15+
AB15
$
4,216.00
$
4,216.00
239
179
=
Y16*
S16*(
1+
T16)
=
Z16*
S16*(
1+
T16)
=
P16+
U16+
W16+
AA16
=
Q16+
V16+
X16+
AB16
$
17,000.00
$
17,000.00
60
45
=
Y18*
S18*(
1+
T18)
=
Z18*
S18*(
1+
T18)
=
P18+
U18+
W18+
AA18
=
Q18+
V18+
X18+
AB18
$
6,600.00
$
13,200.00
60
20
=
Y21*
S21*(
1+
T21)
=
Z21*
S21*(
1+
T21)
=
P21+
U21+
W21+
AA21
=
Q21+
V21+
X21+
AB21
$
100,000.00
$
100,000.00
2,000
1,000
=
Y22*
S22*(
1+
T22)
=
Z22*
S22*(
1+
T22)
=
P22+
U22+
W22+
AA22
=
Q22+
V22+
X22+
AB22
$
80,000.00
$
80,000.00
700
700
=
Y23*
S23*(
1+
T23)
=
Z23*
S23*(
1+
T23)
=
P23+
U23+
W23+
AA23
=
Q23+
V23+
X23+
AB23
$
2,500.00
$
2,500.00
450
150
=
Y24*
S24*(
1+
T24)
=
Z24*
S24*(
1+
T24)
=
P24+
U24+
W24+
AA24
=
Q24+
V24+
X24+
AB24
780
780
=
Y25*
S25*(
1+
T25)
=
Z25*
S25*(
1+
T25)
=
P25+
U25+
W25+
AA25
=
Q25+
V25+
X25+
AB25
80
50
=
Y26*
S26*(
1+
T26)
=
Z26*
S26*(
1+
T26)
=
P26+
U26+
W26+
AA26
=
Q26+
V26+
X26+
AB26
$
1,500.00
$
1,500.00
2
1
=
Y28*
S28*(
1+
T28)
=
Z28*
S28*(
1+
T28)
=
P28+
U28+
W28+
AA28
=
Q28+
V28+
X28+
AB28
$
1,800.00
$
1,800.00
100
100
=
Y29*
S29*(
1+
T29)
=
Z29*
S29*(
1+
T29)
=
P29+
U29+
W29+
AA29
=
Q29+
V29+
X29+
AB29
Sampling
Costs
Management
Salary
Hrs
Management
Overhead
Costs
Total
Costs
February
14,
2003
19
of
32
MPM­
COSTS­
formula.
xls
­
10­
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
45
6
789
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
A
B
Survey
Agency
Number
5
Somerset
6
Albany
County
Sewer
District
6
Albany
South
Plant
7
City
of
Niagra
Falls
10
City
of
Clearwater
(
Marshall
Street)
10
Clearwater
Northeast
10
Clearwater
East
14
City
of
Hamilton
15
Racine
18
Little
Rock
Adams
Field
18
City
of
Little
Rock,
Wastewater
Utility
19
Fayetteville
21
South
San
Francisco
(
SBSA)
24
City
of
Tacoma
24
City
of
Tacoma,
Central
Treatment
Plant
29
Fox
River
WRD
South
Plant
29
Fox
River
WRD
North
Plant
29
Rox
River
WRD
West
Plant
31
City
of
Everett
32
Spokane
42
Regional
Water
Reclamation
Facility­
Medford
44
Madison
48
Raleigh
Neuse
River
49
Bosie
West
Bosie
WWTP
49
Boise,
Lander
Street
WWTP
51
North
Charleston
55
Battle
Creek
62
Johnson
County
Blue
Ridge
#
1
62
Johnson
County
Mill
Creek
62
Johnson
County
Mission
Township
62
Johnson
County
Turkey
Creek
62
Johnson
County
Little
Bull
Creek
#
2
62
Johnson
County
Tomahawk
62
Johnson
County
Little
Bull
Creek
#
1
62
Johnson
County
Blue
Ridge
#
4
66
Hillsborough
County
Dak
Mabry
66
Hillsborough
County
Eagiles
66
Hillsborough
County
Falkenburg
Road
66
Hillsborough
County
Northwest
Regional
66
Hillsborough
County
River
Oaks
66
Hillsborough
County
South
County
66
Hillsborough
County
Valvico
66
Hillsborough
County
Van
Dyke
AE
AF
AG
AH
Implement
Yearly
Implement
Yearly
=
P6/
M6
=
Q6/
M6
=
AC6/
M6
=
AD6/
M6
=
P7/
40
=
Q7/
40
=
AC7/
40
=
AD7/
40
=
P10/
M10
=
Q10/
M10
=
AC10/
M10
=
AD10/
M10
=
P11/
M11
=
Q11/
M11
=
AC11/
M11
=
AD11/
M11
=
P12/
8
=
Q12/
8
=
AC12/
8
=
AD12/
8
=
P14/
M14
=
Q14/
M14
=
AC14/
M14
=
AD14/
M14
=
P15/
M15
=
Q15/
M15
=
AC15/
M15
=
AD15/
M15
=
P16/
M16
=
Q16/
M16
=
AC16/
M16
=
AD16/
M16
=
P18/
12
=
Q18/
12
=
AC18/
12
=
AD18/
12
=
P21/
M21
=
Q21/
M21
=
AC21/
M21
=
AD21/
M21
=
P22/
M22
=
Q22/
M22
=
AC22/
M22
=
AD22/
M22
=
P23/
M23
=
Q23/
M23
=
AC23/
M23
=
AD23/
M23
=
P24/
M24
=
Q24/
M24
=
AC24/
M24
=
AD24/
M24
=
AC25/
M25
=
AD25/
M25
=
P26/
20
=
Q26/
20
=
AC26/
20
=
AD26/
20
=
P28/
M28
=
Q28/
M28
=
AC28/
M28
=
AD28/
M28
=
P29/
M29
=
Q29/
M29
=
AC29/
M29
=
AD29/
M29
=
AVERAGE(
AE3:
AE45)
=
AVERAGE(
AF3:
AF45)
=
AVERAGE(
AG3:
AG45)
=
AVERAGE(
AH3:
AH45)
Total
Costs
Per
Facility
Permitting
Costs
Per
Facility
February
14,
2003
20
of
32
MPM­
COSTS­
formula.
xls
­
10­
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
67
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
#
of
MFJS
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
1
Monroe
County
NY
90.0
35
18
0
2
3
12
0
0
=
SUM(
F3:
L3)
1
Monroe
County
Northwest
Qusdrent
NY
12.0
0
0
0
0
0
0
0
0
=
SUM(
F4:
L4)
2
Metro
Wastewater
Reclamation
District
CO
160.0
11,565
9
0
0
458
14
2
102
=
SUM(
F5:
L5)
8
Providence
Fields
Point
WWTP
RI
45.5
674
15
1
37
373
41
1
0
=
SUM(
F6:
L6)
8
Providence
Bucklin
Point
WWTF
RI
23.9
344
9
2
26
187
14
1
0
=
SUM(
F7:
L7)
9
Broward
County
FL
66.0
41
14
3
3
0
10
4
0
=
SUM(
F8:
L8)
11
NYC
Port
Richmond
NY
31.0
290
25
27
62
475
263
0
25
=
SUM(
F9:
L9)
11
NYC
Red
Hook
NY
30.0
11
NYC
Oakwood
Beach
NY
25.3
11
NYC
NTC
Rockaway
NY
20.0
11
NYC
East
NY
2.3
11
NYC
Newton
Creek
NY
216.0
11
NYC
Wards
Island
NY
184.0
11
NYC
North
River
NY
128.0
11
NYC
Hunts
Point
NY
118.0
11
NYC
Bowery
Bay
NY
108.0
11
NYC
Owls
Head
NY
101.0
11
NYC
Coney
Island
NY
93.0
11
NYC
Jamacia
NY
78.0
11
NYC
26th
Ward
NY
58.0
11
NYC
Tallman
Island
NY
54.0
12
MS
D
Little
Miami
OH
27.0
33
5
0
6
0
2
0
0
=
SUM(
F24:
L24)
12
Cincinnati
Muddy
Creek
OH
12.0
6
1
0
0
0
1
1
0
=
SUM(
F25:
L25)
12
Cincinnati
Sycamore
Creek
OH
3.0
7
2
0
0
0
0
0
0
=
SUM(
F26:
L26)
12
Cincinnati
Mill
Creek
OH
140.0
188
17
0
29
0
13
4
0
=
SUM(
F27:
L27)
17
Birmingham
Valley
Creek
AL
35.4
12
2
2
0
0
0
0
0
=
SUM(
F28:
L28)
17
Birmingham
Village
Creek
AL
33.5
15
3
0
0
0
0
0
0
=
SUM(
F29:
L29)
17
Birmingham
Five
Mile
Creek
AL
12.3
14
4
0
0
0
0
0
2
=
SUM(
F30:
L30)
17
Birmingham
Cahaba
River
AL
8.9
0
0
0
0
0
0
0
0
=
SUM(
F31:
L31)
17
Birmingham
Turkey
Creek
AL
4.2
0
0
0
0
0
0
0
0
=
SUM(
F32:
L32)
17
Birmingham
Trussville
AL
1.9
1
1
0
0
0
0
0
0
=
SUM(
F33:
L33)
17
Birmingham
Leeds
AL
0.9
1
1
0
0
0
0
0
0
=
SUM(
F34:
L34)
17
Birmingham
Prudes
Creek
AL
0.4
0
0
0
0
0
0
0
0
=
SUM(
F35:
L35)
17
Birmingham
Warrior
AL
0.1
0
0
0
0
0
0
0
0
=
SUM(
F36:
L36)
20
LA
County
Joint
WPCP
CA
334.1
1896
47
17
11
0
231
13
0
=
SUM(
F37:
L37)
20
LA
Los
Coyotes
WRP
CA
34.4
216
10
0
0
0
42
0
0
=
SUM(
F38:
L38)
20
LA
Long
Beach
WRP
CA
18.8
28
1
0
0
0
4
0
0
=
SUM(
F39:
L39)
20
LA
Valencia
WRP
CA
11.2
54
1
0
3
0
9
0
0
=
SUM(
F40:
L40)
20
LA
Pomona
WRP
CA
10.7
77
1
0
0
0
5
0
0
=
SUM(
F41:
L41)
20
LA
Lancaster
WRP
CA
9.2
22
1
0
3
0
3
0
0
=
SUM(
F42:
L42)
20
LA
Palmdale
WRP
CA
8.3
10
2
0
0
0
0
0
0
=
SUM(
F43:
L43)
20
LA
Whittier
Narrows
WRP
CA
7.6
246
9
0
2
0
36
2
0
=
SUM(
F44:
L44)
20
LA
Saugus
WRP
CA
5.5
13
0
1
1
0
0
0
0
=
SUM(
F45:
L45)
20
LA
San
Jose
Creek
WRP
CA
92.9
351
13
3
1
0
48
1
0
=
SUM(
F46:
L46)
22
Chino
Basin
Municipal
Water
District
CA
NA
1200
1
1
0
0
2
0
0
=
SUM(
F47:
L47)
23
IEUA
Regional
Plant
#
1
CA
38.8
=
SUM(
F48:
L48)
23
Fontana
Carbon
Cayon
Water
Reclamation
CA
8.8
=
SUM(
F49:
L49)
23
Fontana
Regional
Plant
#
2
CA
3.9
=
SUM(
F50:
L50)
23
Fontana
Regional
Plant
#
4
CA
3.8
=
SUM(
F51:
L51)
25
Dallas
Water
Utilities
(
Central)
TX
155.5
129
24
12
0
0
5
0
0
=
SUM(
F52:
L52)
25
Dallas
Southside
WWTP
TX
87.0
=
SUM(
F53:
L53)
27
Virginia
Beach
VIP
VA
27.6
17
1
0
10
0
1
4
1
=
SUM(
F54:
L54)
27
Virginia
Beach
Atlantic
VA
27.5
16
1
0
3
0
0
3
9
=
SUM(
F55:
L55)
27
Virginia
Beach
Nansemond
VA
17.2
8
0
0
2
0
1
3
2
=
SUM(
F56:
L56)
27
Virginia
Beach
Chesapeake
­
Elizabeth
VA
16.9
7
0
0
2
1
0
2
2
=
SUM(
F57:
L57)
27
Virginia
Beach
Williamsburg
VA
14.0
12
2
0
3
0
2
4
1
=
SUM(
F58:
L58)
Categorical
GM
Non­
Cat.
G
M
#
of
Non­
Cat.
Oily
Waste
February
14,
2003
21
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
67
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
Survey
Agency
Number
1
Monroe
County
1
Monroe
County
Northwest
Qusdrent
2
Metro
Wastewater
Reclamation
District
8
Providence
Fields
Point
WWTP
8
Providence
Bucklin
Point
WWTF
9
Broward
County
11
NYC
Port
Richmond
11
NYC
Red
Hook
11
NYC
Oakwood
Beach
11
NYC
NTC
Rockaway
11
NYC
East
11
NYC
Newton
Creek
11
NYC
Wards
Island
11
NYC
North
River
11
NYC
Hunts
Point
11
NYC
Bowery
Bay
11
NYC
Owls
Head
11
NYC
Coney
Island
11
NYC
Jamacia
11
NYC
26th
Ward
11
NYC
Tallman
Island
12
MS
D
Little
Miami
12
Cincinnati
Muddy
Creek
12
Cincinnati
Sycamore
Creek
12
Cincinnati
Mill
Creek
17
Birmingham
Valley
Creek
17
Birmingham
Village
Creek
17
Birmingham
Five
Mile
Creek
17
Birmingham
Cahaba
River
17
Birmingham
Turkey
Creek
17
Birmingham
Trussville
17
Birmingham
Leeds
17
Birmingham
Prudes
Creek
17
Birmingham
Warrior
20
LA
County
Joint
WPCP
20
LA
Los
Coyotes
WRP
20
LA
Long
Beach
WRP
20
LA
Valencia
WRP
20
LA
Pomona
WRP
20
LA
Lancaster
WRP
20
LA
Palmdale
WRP
20
LA
Whittier
Narrows
WRP
20
LA
Saugus
WRP
20
LA
San
Jose
Creek
WRP
22
Chino
Basin
Municipal
Water
District
23
IEUA
Regional
Plant
#
1
23
Fontana
Carbon
Cayon
Water
Reclamation
23
Fontana
Regional
Plant
#
2
23
Fontana
Regional
Plant
#
4
25
Dallas
Water
Utilities
(
Central)
25
Dallas
Southside
WWTP
27
Virginia
Beach
VIP
27
Virginia
Beach
Atlantic
27
Virginia
Beach
Nansemond
27
Virginia
Beach
Chesapeake
­
Elizabeth
27
Virginia
Beach
Williamsburg
N
O
P
Q
R
S
T
U
V
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
641
187
=
N3*
R3*(
1+
T3)
=
O3*
R3*(
1+
T3)
$
19.00
$
26.00
0.33
$
1,600.00
$
1,600.00
N/
A
N/
A
$
19.00
$
26.00
0.33
15,837
2,091
=
N5*
R5*(
1+
T5)
=
O5*
R5*(
1+
T5)
$
23.77
$
40.00
0.45
$
3,000,000.00
$
3,000,000.00
8,161
1,459
=
N6*
R6*(
1+
T6)
=
O6*
R6*(
1+
T6)
$
20.00
$
35.00
0.5
$
480,000.00
$
480,000.00
5,640
1,227
=
N8*
R8*(
1+
T8)
=
O8*
R8*(
1+
T8)
$
20.00
$
30.00
0.3
$
20,000.00
$
20,000.00
29,487
17,956
=
N9*
R9*(
1+
T9)
=
O9*
R9*(
1+
T9)
$
22.13
$
38.50
1,247
965
=
N24*
R24*(
1+
T24)
=
O24*
R24*(
1+
T24)
$
20.00
$
25.00
0.33
$
162,000.00
$
162,000.00
730
330
=
N28*
R28*(
1+
T28)
=
O28*
R28*(
1+
T28)
$
15.00
$
26.00
0.4
$
31,500.00
$
21,000.00
=
78*
521
=
521*
45
=
N37*
R37*(
1+
T37)
=
O37*
R37*(
1+
T37)
$
50.00
$
60.00
0.46
$
165,000.00
$
173,250.00
101
38
=
N47*
R47*(
1+
T47)
=
O47*
R47*(
1+
T47)
$
14.00
$
24.00
0.4
$
1,200.00
$
4,800.00
$
0
$
0
$
50.00
$
75.00
0.5
=
N49*
R49*(
1+
T49)
=
O49*
R49*(
1+
T49)
=
N50*
R50*(
1+
T50)
=
O50*
R50*(
1+
T50)
=
N51*
R51*(
1+
T51)
=
O51*
R51*(
1+
T51)
2,060
1,115
=
N52*
R52*(
1+
T52)
=
O52*
R52*(
1+
T52)
$
18.00
$
21.00
0.2
$
130,000.00
$
130,000.00
1,457
1,015
=
N54*
R54*(
1+
T54)
=
O54*
R54*(
1+
T54)
$
15.40
$
29.73
0.6331
$
284,188.00
$
294,912.00
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
February
14,
2003
22
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
67
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
Survey
Agency
Number
1
Monroe
County
1
Monroe
County
Northwest
Qusdrent
2
Metro
Wastewater
Reclamation
District
8
Providence
Fields
Point
WWTP
8
Providence
Bucklin
Point
WWTF
9
Broward
County
11
NYC
Port
Richmond
11
NYC
Red
Hook
11
NYC
Oakwood
Beach
11
NYC
NTC
Rockaway
11
NYC
East
11
NYC
Newton
Creek
11
NYC
Wards
Island
11
NYC
North
River
11
NYC
Hunts
Point
11
NYC
Bowery
Bay
11
NYC
Owls
Head
11
NYC
Coney
Island
11
NYC
Jamacia
11
NYC
26th
Ward
11
NYC
Tallman
Island
12
MS
D
Little
Miami
12
Cincinnati
Muddy
Creek
12
Cincinnati
Sycamore
Creek
12
Cincinnati
Mill
Creek
17
Birmingham
Valley
Creek
17
Birmingham
Village
Creek
17
Birmingham
Five
Mile
Creek
17
Birmingham
Cahaba
River
17
Birmingham
Turkey
Creek
17
Birmingham
Trussville
17
Birmingham
Leeds
17
Birmingham
Prudes
Creek
17
Birmingham
Warrior
20
LA
County
Joint
WPCP
20
LA
Los
Coyotes
WRP
20
LA
Long
Beach
WRP
20
LA
Valencia
WRP
20
LA
Pomona
WRP
20
LA
Lancaster
WRP
20
LA
Palmdale
WRP
20
LA
Whittier
Narrows
WRP
20
LA
Saugus
WRP
20
LA
San
Jose
Creek
WRP
22
Chino
Basin
Municipal
Water
District
23
IEUA
Regional
Plant
#
1
23
Fontana
Carbon
Cayon
Water
Reclamation
23
Fontana
Regional
Plant
#
2
23
Fontana
Regional
Plant
#
4
25
Dallas
Water
Utilities
(
Central)
25
Dallas
Southside
WWTP
27
Virginia
Beach
VIP
27
Virginia
Beach
Atlantic
27
Virginia
Beach
Nansemond
27
Virginia
Beach
Chesapeake
­
Elizabeth
27
Virginia
Beach
Williamsburg
W
X
Y
Z
AA
AB
AC
Implement
Yearly
Implement
Yearly
Implement
Yearly
Implement
$
960.00
$
960.00
1,441
587
=
Y3*
S3*(
1+
T3)
=
Z3*
S3*(
1+
T3)
=
P3+
U3+
W3+
AA3
$
850,000.00
$
850,000.00
3,500
1,000
=
Y5*
S5*(
1+
T5)
=
Z5*
S5*(
1+
T5)
=
P5+
U5+
W5+
AA5
$
350,000.00
$
275,000.00
100
100
=
Y6*
S6*(
1+
T6)
=
Z6*
S6*(
1+
T6)
=
P6+
U6+
W6+
AA6
$
2,500.00
$
2,500.00
2,400
100
=
Y8*
S8*(
1+
T8)
=
Z8*
S8*(
1+
T8)
=
P8+
U8+
W8+
AA8
$
150,000.00
$
300,000.00
=
Y9*
S9*(
1+
T9)
=
Z9*
S9*(
1+
T9)
=
P9+
U9+
W9+
AA9
$
388,800.00
$
388,800.00
1,247
965
=
Y24*
S24*(
1+
T24)
=
Z24*
S24*(
1+
T24)
=
P24+
U24+
W24+
AA24
$
3,600.00
$
1,800.00
700
400
=
Y28*
S28*(
1+
T28)
=
Z28*
S28*(
1+
T28)
=
P28+
U28+
W28+
AA28
$
99,000.00
$
103,950.00
104
78
=
Y37*
S37*(
1+
T37)
=
Z37*
S37*(
1+
T37)
=
P37+
U37+
W37+
AA37
$
480.00
$
1,920.00
80
20
=
Y47*
S47*(
1+
T47)
=
Z47*
S47*(
1+
T47)
=
P47+
U47+
W47+
AA47
$
40,000.00
$
40,000.00
250
50
=
Y52*
S52*(
1+
T52)
=
Z52*
S52*(
1+
T52)
=
P52+
U52+
W52+
AA52
$
79,977.00
$
82,995.00
544
360
=
Y54*
S54*(
1+
T54)
=
Z54*
S54*(
1+
T54)
=
P54+
U54+
W54+
AA54
Sampling
Costs
Management
Salary
Hrs
Management
Overhead
Costs
Total
Costs
February
14,
2003
23
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
34
5
67
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
Survey
Agency
Number
1
Monroe
County
1
Monroe
County
Northwest
Qusdrent
2
Metro
Wastewater
Reclamation
District
8
Providence
Fields
Point
WWTP
8
Providence
Bucklin
Point
WWTF
9
Broward
County
11
NYC
Port
Richmond
11
NYC
Red
Hook
11
NYC
Oakwood
Beach
11
NYC
NTC
Rockaway
11
NYC
East
11
NYC
Newton
Creek
11
NYC
Wards
Island
11
NYC
North
River
11
NYC
Hunts
Point
11
NYC
Bowery
Bay
11
NYC
Owls
Head
11
NYC
Coney
Island
11
NYC
Jamacia
11
NYC
26th
Ward
11
NYC
Tallman
Island
12
MS
D
Little
Miami
12
Cincinnati
Muddy
Creek
12
Cincinnati
Sycamore
Creek
12
Cincinnati
Mill
Creek
17
Birmingham
Valley
Creek
17
Birmingham
Village
Creek
17
Birmingham
Five
Mile
Creek
17
Birmingham
Cahaba
River
17
Birmingham
Turkey
Creek
17
Birmingham
Trussville
17
Birmingham
Leeds
17
Birmingham
Prudes
Creek
17
Birmingham
Warrior
20
LA
County
Joint
WPCP
20
LA
Los
Coyotes
WRP
20
LA
Long
Beach
WRP
20
LA
Valencia
WRP
20
LA
Pomona
WRP
20
LA
Lancaster
WRP
20
LA
Palmdale
WRP
20
LA
Whittier
Narrows
WRP
20
LA
Saugus
WRP
20
LA
San
Jose
Creek
WRP
22
Chino
Basin
Municipal
Water
District
23
IEUA
Regional
Plant
#
1
23
Fontana
Carbon
Cayon
Water
Reclamation
23
Fontana
Regional
Plant
#
2
23
Fontana
Regional
Plant
#
4
25
Dallas
Water
Utilities
(
Central)
25
Dallas
Southside
WWTP
27
Virginia
Beach
VIP
27
Virginia
Beach
Atlantic
27
Virginia
Beach
Nansemond
27
Virginia
Beach
Chesapeake
­
Elizabeth
27
Virginia
Beach
Williamsburg
AD
AE
AF
AG
AH
Yearly
Implement
Yearly
Implement
Yearly
=
Q3+
V3+
X3+
AB3
=
P3/
M3
=
Q3/
M3
=
AC3/
M3
=
AD3/
M3
=
Q5+
V5+
X5+
AB5
=
P5/
M5
=
Q5/
M5
=
AC5/
M5
=
AD5/
M5
=
Q6+
V6+
X6+
AB6
=
P6/
707
=
Q6/
707
=
AC6/
707
=
AD6/
707
=
Q8+
V8+
X8+
AB8
=
P8/
M8
=
Q8/
M8
=
AC8/
M8
=
AD8/
M8
=
Q9+
V9+
X9+
AB9
=
P9/
M9
=
Q9/
M9
=
AC9/
M9
=
AD9/
M9
=
Q24+
V24+
X24+
AB24
=
P24/
81
=
Q24/
81
=
AC24/
81
=
AD24/
81
=
Q28+
V28+
X28+
AB28
=
P28/
15
=
Q28/
15
=
AC28/
15
=
AD28/
15
=
Q37+
V37+
X37+
AB37
=
P37/
518
=
Q37/
518
=
AC37/
518
=
AD37/
518
=
Q47+
V47+
X47+
AB47
=
P47/
M47
=
Q47/
M47
=
AC47/
M47
=
AD47/
M47
=
Q52+
V52+
X52+
AB52
=
P52/
M52
=
Q52/
M52
=
AC52/
M52
=
AD52/
M52
=
Q54+
V54+
X54+
AB54
=
P54/
106
=
Q54/
106
=
AC54/
106
=
AD54/
106
Total
Costs
Per
Facility
Total
Costs
Permitting
Costs
Per
Facility
February
14,
2003
24
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
#
of
MFJS
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
Categorical
GM
Non­
Cat.
G
M
#
of
Non­
Cat.
Oily
Waste
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
27
Virginia
Beach
James
River
VA
13.1
13
1
0
6
0
0
0
6
=
SUM(
F59:
L59)
27
Virginia
Beach
Boat
Harbor
VA
12.5
17
2
0
4
2
4
3
2
=
SUM(
F60:
L60)
27
Virginia
Beach
Army
Base
VA
11.4
4
0
0
1
0
0
2
1
=
SUM(
F61:
L61)
27
Virginia
Beach
York
River
VA
10.4
12
0
0
5
1
1
3
2
=
SUM(
F62:
L62)
30
Minneapolis­
St
Paul
Metropolitan
MN
203.9
463
21
1
15
1
88
4
0
=
SUM(
F63:
L63)
30
ST.
Paul
Seneca
WWTP
MN
34.5
=
SUM(
F64:
L64)
30
ST.
Paul
Blue
Lake
WWTP
MN
24.3
=
SUM(
F65:
L65)
30
St.
Paul
Empire
WWTP
MN
8.0
15
0
0
0
0
2
0
0
=
SUM(
F66:
L66)
30
ST.
Paul
Stillwater
WWTP
MN
3.1
=
SUM(
F67:
L67)
30
St.
Paul
Cottage
Grove
WWTP
MN
2.1
=
SUM(
F68:
L68)
30
St.
Paul
Hasting
WWTP
MN
1.8
=
SUM(
F69:
L69)
30
St.
Paul
Rosemount
MN
0.7
=
SUM(
F70:
L70)
33
Unified
Sewerage
Agency
(
Durham)
OR
22.0
72
0
0
0
0
11
0
0
=
SUM(
F71:
L71)
33
USA
Rock
Creek
OR
29.9
55
0
0
0
0
12
0
0
=
SUM(
F72:
L72)
33
USA
Hillsboro
OR
4.6
13
0
0
0
0
3
0
0
=
SUM(
F73:
L73)
33
USA
Hillsboro
Forrest
Grove
OR
3.7
12
0
0
0
0
1
0
0
=
SUM(
F74:
L74)
34
Detroit
MI
620.0
2125
80
84
33
1328
134
25
322
=
SUM(
F75:
L75)
35
Kansas
City
Blue
River
MO
75.0
35
4
0
0
7
13
1
10
=
SUM(
F76:
L76)
35
Kansas
City
Birmingham
MO
20.0
4
1
0
0
1
0
0
2
=
SUM(
F77:
L77)
35
Kansas
City
Westside
MO
17.0
16
0
0
0
4
5
1
6
=
SUM(
F78:
L78)
35
Kansas
City
Todd
Creek
MO
1.4
2
2
0
0
0
0
0
0
=
SUM(
F79:
L79)
35
Kansas
City
Rocky
Branch
MO
0.7
=
SUM(
F80:
L80)
35
Kansas
CityFishing
River
MO
0.2
=
SUM(
F81:
L81)
35
KC
Northland
Mobile
Home
MO
0.1
=
SUM(
F82:
L82)
35
KC
Industrial
Park
MI
0.0
=
SUM(
F83:
L83)
36
Jacksonville
(
JEA)
FL
28.1
64
1
4
2
0
1
2
0
=
SUM(
F84:
L84)
36
Jacksonville
District
4
FL
11.8
7
2
1
0
0
0
1
0
=
SUM(
F85:
L85)
36
Jacksonville
District
3
FL
7.4
1
0
0
0
0
0
0
0
=
SUM(
F86:
L86)
36
Jacksonville
District
5
FL
5.6
1
1
0
0
0
0
0
0
=
SUM(
F87:
L87)
36
Jacksonville
District
2
FL
4.3
7
0
0
0
0
0
0
0
=
SUM(
F88:
L88)
40
New
Orleans
East
Bank
LA
95.2
1
1
0
0
0
0
0
0
=
SUM(
F89:
L89)
40
New
Orleans
West
Bank
LA
8.8
0
0
0
0
0
0
0
0
=
SUM(
F90:
L90)
43
Phoneix
­
91st
Ace.
AZ
139.0
120
23
10
0
7
33
6
19
=
SUM(
F91:
L91)
43
Phoenix
AZ
54.5
57
12
1
0
3
13
5
11
=
SUM(
F92:
L92)
45
City
of
Tampa
FL
50.0
80
4
12
0
30
7
0
5
=
SUM(
F93:
L93)
46
District
of
Columbia
DC
318.0
10,000
19
2
0
260
21
5
5
=
SUM(
F94:
L94)
52
OCSD
WWTP
#
2
CA
151.0
442
229
90
19
0
273
0
0
=
SUM(
F95:
L95)
52
Orange
County
Reclam
Plant
#
1
CA
90.0
53
NORSD
Southerly
WWTP
OH
106.7
581
33
17
113
0
56
30
0
=
SUM(
F97:
L97)
53
NORSD
Westerly
WWTP
OH
32.7
148
12
5
30
0
20
7
0
=
SUM(
F98:
L98)
53
NORSD
Easterly
WWTP
OH
108.0
220
11
16
47
0
38
12
0
=
SUM(
F99:
L99)
54
Akron
WPC
OH
72.0
55
4
0
0
5
19
0
1
=
SUM(
F100:
L100)
56
Atlanta
RM
Clayton
GA
90.0
8
0
7
40
5
5
60
=
SUM(
F101:
L101)
56
Atlanta
South
River
GA
40.0
=
SUM(
F102:
L102)
56
Atlanta
Utoy
Creek
GA
30.0
=
SUM(
F103:
L103)
57
MWRDGC­
Stickney
IL
780.0
941
38
20
20
0
95
768
0
=
SUM(
F104:
L104)/
3
57
MWRDGC­
Calumet
IL
265.0
193
4
16
8
0
4
161
0
=
SUM(
F105:
L105)/
3
57
MWRDGC­
Northside
IL
268.0
396
21
1
1
0
38
335
0
=
SUM(
F106:
L106)/
3
57
MWRDGC­
Kirie
IL
37.0
193
10
5
5
0
32
141
0
=
SUM(
F107:
L107)/
3
57
MWRDGC­
Egan
IL
26.0
50
4
1
0
0
3
42
0
=
SUM(
F108:
L108)/
3
57
MWRDGC­
Hanover
Park
IL
9.0
22
1
0
3
0
0
18
0
=
SUM(
F109:
L109)/
3
57
MWRDGC­
Lemont
IL
2.0
3
0
0
0
0
0
3
0
=
SUM(
F110:
L110)/
3
58
MWRA­
Boston­
Deer
Island
MA
601.4
1473
10
0
0
0
55
1
0
=
SUM(
F111:
L111)
58
MWRA­
Boston­
Clinton
MA
3.4
17
1
0
0
0
2
0
0
=
SUM(
F112:
L112)
59
Philadelphia­
Northeast
PA
196.0
88
12
0
2
0
33
1
0
=
SUM(
F113:
L113)
59
Philadelphia­
Southwest
PA
196.0
31
4
0
1
0
8
1
0
=
SUM(
F114:
L114)

February
14,
2003
25
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
Survey
Agency
Number
1
Monroe
County
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
27
Virginia
Beach
James
River
27
Virginia
Beach
Boat
Harbor
27
Virginia
Beach
Army
Base
27
Virginia
Beach
York
River
30
Minneapolis­
St
Paul
Metropolitan
30
ST.
Paul
Seneca
WWTP
30
ST.
Paul
Blue
Lake
WWTP
30
St.
Paul
Empire
WWTP
30
ST.
Paul
Stillwater
WWTP
30
St.
Paul
Cottage
Grove
WWTP
30
St.
Paul
Hasting
WWTP
30
St.
Paul
Rosemount
33
Unified
Sewerage
Agency
(
Durham)
33
USA
Rock
Creek
33
USA
Hillsboro
33
USA
Hillsboro
Forrest
Grove
34
Detroit
35
Kansas
City
Blue
River
35
Kansas
City
Birmingham
35
Kansas
City
Westside
35
Kansas
City
Todd
Creek
35
Kansas
City
Rocky
Branch
35
Kansas
CityFishing
River
35
KC
Northland
Mobile
Home
35
KC
Industrial
Park
36
Jacksonville
(
JEA)
36
Jacksonville
District
4
36
Jacksonville
District
3
36
Jacksonville
District
5
36
Jacksonville
District
2
40
New
Orleans
East
Bank
40
New
Orleans
West
Bank
43
Phoneix
­
91st
Ace.
43
Phoenix
45
City
of
Tampa
46
District
of
Columbia
52
OCSD
WWTP
#
2
52
Orange
County
Reclam
Plant
#
1
53
NORSD
Southerly
WWTP
53
NORSD
Westerly
WWTP
53
NORSD
Easterly
WWTP
54
Akron
WPC
56
Atlanta
RM
Clayton
56
Atlanta
South
River
56
Atlanta
Utoy
Creek
57
MWRDGC­
Stickney
57
MWRDGC­
Calumet
57
MWRDGC­
Northside
57
MWRDGC­
Kirie
57
MWRDGC­
Egan
57
MWRDGC­
Hanover
Park
57
MWRDGC­
Lemont
58
MWRA­
Boston­
Deer
Island
58
MWRA­
Boston­
Clinton
59
Philadelphia­
Northeast
59
Philadelphia­
Southwest
N
O
P
Q
R
S
T
U
V
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
2,625
763
=
N63*
R63*(
1+
T63)
=
O63*
R63*(
1+
T63)
$
25.09
$
33.80
0.59
$
27,000.00
$
22,000.00
980
240
=
N71*
R71*(
1+
T71)
=
O71*
R71*(
1+
T71)
$
23.00
$
30.00
0.38
$
10,000.00
$
7,000.00
78,260
23,190
=
N75*
R75*(
1+
T75)
=
O75*
R75*(
1+
T75)
$
870,000.00
$
87,000.00
4,750
1,380
=
N76*
S76*(
1+
T76)
=
O76*
S76*(
1+
T76)
$
12.50
$
23.00
0.36
$
33,170.00
$
33,170.00
790
680
=
N77*
R76*(
1+
T77)
=
O77*
R76*(
1+
T77)

1,280
480
=
N84*
R84*(
1+
T84)
=
O84*
R84*(
1+
T84)
$
20.00
$
40.00
0.5
$
15,000.00
$
5,000.00
368
448
=
N89*
R89*(
1+
T89)
=
O89*
R89*(
1+
T89)
$
13.89
$
28.00
0.5
$
36.00
$
48.00
6,794
4,220
=
N91*
R91*(
1+
T91)
=
O91*
R91*(
1+
T91)
$
19.50
$
35.50
0.78
$
412,814.00
$
427,032.00
840
820
=
N93*
R93*(
1+
T93)
=
O93*
R93*(
1+
T93)
$
21.00
$
34.00
0.15
$
28,000.00
$
28,000.00
$
10,000
$
1,000
NA
NA
NA
$
50,000.00
$
50,000.00
28,330
10,730
=
N95*
R95*(
1+
T95)
=
O95*
R95*(
1+
T95)
$
30.00
$
42.00
0.33
$
200,000.00
$
100,000.00
16,482
7,914
=
N97*
R97*(
1+
T97)
=
O97*
R97*(
1+
T97)
$
21.00
$
28.00
0.5
$
179,037.00
$
84,037.00
464
104
=
N100*
R100*(
1+
T100)
=
O100*
R100*(
1+
T100)
$
19.73
$
27.05
0.5
=
1800*
29
=
1800*
29
24,000
8,000
=
N101*
R101*(
1+
T101)
=
O101*
R101*(
1+
T101)
$
15.00
$
24.00
0.4
$
285,000.00
$
295,000.00
22,833
10,036
=
N104*
R104*(
T104)
=
O104*
R104*(
T104)
$
20.16
$
35.35
1.0817
$
1,030,900.00
$
1,030,900.00
9,435
9,435
$
25.05
$
31.19
0.804
$
68,325.18
$
68,325.18
411
258
=
N113*
R113*(
T113)
=
O113*
R113*(
T113)
$
22.00
$
32.00
4.52
=
562*
68
=
562*
68
February
14,
2003
26
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
Survey
Agency
Number
1
Monroe
County
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
27
Virginia
Beach
James
River
27
Virginia
Beach
Boat
Harbor
27
Virginia
Beach
Army
Base
27
Virginia
Beach
York
River
30
Minneapolis­
St
Paul
Metropolitan
30
ST.
Paul
Seneca
WWTP
30
ST.
Paul
Blue
Lake
WWTP
30
St.
Paul
Empire
WWTP
30
ST.
Paul
Stillwater
WWTP
30
St.
Paul
Cottage
Grove
WWTP
30
St.
Paul
Hasting
WWTP
30
St.
Paul
Rosemount
33
Unified
Sewerage
Agency
(
Durham)
33
USA
Rock
Creek
33
USA
Hillsboro
33
USA
Hillsboro
Forrest
Grove
34
Detroit
35
Kansas
City
Blue
River
35
Kansas
City
Birmingham
35
Kansas
City
Westside
35
Kansas
City
Todd
Creek
35
Kansas
City
Rocky
Branch
35
Kansas
CityFishing
River
35
KC
Northland
Mobile
Home
35
KC
Industrial
Park
36
Jacksonville
(
JEA)
36
Jacksonville
District
4
36
Jacksonville
District
3
36
Jacksonville
District
5
36
Jacksonville
District
2
40
New
Orleans
East
Bank
40
New
Orleans
West
Bank
43
Phoneix
­
91st
Ace.
43
Phoenix
45
City
of
Tampa
46
District
of
Columbia
52
OCSD
WWTP
#
2
52
Orange
County
Reclam
Plant
#
1
53
NORSD
Southerly
WWTP
53
NORSD
Westerly
WWTP
53
NORSD
Easterly
WWTP
54
Akron
WPC
56
Atlanta
RM
Clayton
56
Atlanta
South
River
56
Atlanta
Utoy
Creek
57
MWRDGC­
Stickney
57
MWRDGC­
Calumet
57
MWRDGC­
Northside
57
MWRDGC­
Kirie
57
MWRDGC­
Egan
57
MWRDGC­
Hanover
Park
57
MWRDGC­
Lemont
58
MWRA­
Boston­
Deer
Island
58
MWRA­
Boston­
Clinton
59
Philadelphia­
Northeast
59
Philadelphia­
Southwest
W
X
Y
Z
AA
AB
AC
Implement
Yearly
Implement
Yearly
Implement
Yearly
Implement
Sampling
Costs
Management
Salary
Hrs
Management
Overhead
Costs
Total
Costs
$
110,000.00
$
85,000.00
200
100
=
Y63*
S63*(
1+
T63)
=
Z63*
S63*(
1+
T63)
=
P63+
U63+
W63+
AA63
$
20,000.00
$
10,000.00
400
400
=
Y71*
S71*(
1+
T71)
=
Z71*
S71*(
1+
T71)
=
P71+
U71+
W71+
AA71
$
2,100,000.00
$
1,050,000.00
$
5,650,000.00
$
816,000.00
=
P75+
U75+
W75+
AA75
$
14,000.00
$
1,000.00
4,750
1,380
=
Y76*
S76*(
1+
T76)
=
Z76*
S76*(
1+
T76)
=
P76+
U76+
W76+
AA76+
P77
$
10,000.00
$
5,000.00
480
120
=
Y84*
S84*(
1+
T84)
=
Z84*
S84*(
1+
T84)
=
P84+
U84+
W84+
AA84
$
350.00
$
500.00
36
48
=
Y89*
S89*(
1+
T89)
=
Z89*
S89*(
1+
T89)
=
P89+
U89+
W89+
AA89
$
92,083.00
$
96,159.00
260
250
=
Y91*
S91*(
1+
T91)
=
Z91*
S91*(
1+
T91)
=
P91+
U91+
W91+
AA91
$
8,000.00
$
8,000.00
250
200
=
Y93*
S93*(
1+
T93)
=
Z93*
S93*(
1+
T93)
=
P93+
U93+
W93+
AA93
$
20,000.00
$
20,000.00
NA
NA
$
25,000.00
$
25,000.00
=
P94+
U94+
W94+
AA94
$
135,000.00
$
68,000.00
$
50,000.00
$
25,000.00
=
P95+
U95+
W95+
AA95
$
115,824.00
$
120,456.00
1,440
1,440
=
Y97*
S97*(
1+
T97)
=
Z97*
S97*(
1+
T97)
=
P97+
U97+
W97+
AA97
=
720*
29
=
720*
29
84
72
=
Y100*
S100*(
1+
T100)
=
Z100*
S100*(
1+
T100)
=
P100+
U100+
W100+
AA100
$
80,000.00
$
83,000.00
7,440
7,440
=
Y101*
S101*(
1+
T101)
=
Z101*
S101*(
1+
T101)
=
P101+
U101+
W101+
AA101
$
95,160.00
$
95,160.00
1,500
750
=
Y104*
S104*(
T104)
=
Z104*
S104*(
T104)
=
P104+
U104+
W104+
AA104
$
120,060.00
$
129,720.00
202
202
=
Y111*
S111*(
1+
T111)
=
Z111*
S111*(
1+
T111)
=
P111+
U111+
W111+
AA111
=
372*
68
=
372*
68
40
40
=
Y113*
S113*(
T113)
=
Z113*
S113*(
T113)
=
P113+
U113+
W113+
AA113
February
14,
2003
27
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
Survey
Agency
Number
1
Monroe
County
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
27
Virginia
Beach
James
River
27
Virginia
Beach
Boat
Harbor
27
Virginia
Beach
Army
Base
27
Virginia
Beach
York
River
30
Minneapolis­
St
Paul
Metropolitan
30
ST.
Paul
Seneca
WWTP
30
ST.
Paul
Blue
Lake
WWTP
30
St.
Paul
Empire
WWTP
30
ST.
Paul
Stillwater
WWTP
30
St.
Paul
Cottage
Grove
WWTP
30
St.
Paul
Hasting
WWTP
30
St.
Paul
Rosemount
33
Unified
Sewerage
Agency
(
Durham)
33
USA
Rock
Creek
33
USA
Hillsboro
33
USA
Hillsboro
Forrest
Grove
34
Detroit
35
Kansas
City
Blue
River
35
Kansas
City
Birmingham
35
Kansas
City
Westside
35
Kansas
City
Todd
Creek
35
Kansas
City
Rocky
Branch
35
Kansas
CityFishing
River
35
KC
Northland
Mobile
Home
35
KC
Industrial
Park
36
Jacksonville
(
JEA)
36
Jacksonville
District
4
36
Jacksonville
District
3
36
Jacksonville
District
5
36
Jacksonville
District
2
40
New
Orleans
East
Bank
40
New
Orleans
West
Bank
43
Phoneix
­
91st
Ace.
43
Phoenix
45
City
of
Tampa
46
District
of
Columbia
52
OCSD
WWTP
#
2
52
Orange
County
Reclam
Plant
#
1
53
NORSD
Southerly
WWTP
53
NORSD
Westerly
WWTP
53
NORSD
Easterly
WWTP
54
Akron
WPC
56
Atlanta
RM
Clayton
56
Atlanta
South
River
56
Atlanta
Utoy
Creek
57
MWRDGC­
Stickney
57
MWRDGC­
Calumet
57
MWRDGC­
Northside
57
MWRDGC­
Kirie
57
MWRDGC­
Egan
57
MWRDGC­
Hanover
Park
57
MWRDGC­
Lemont
58
MWRA­
Boston­
Deer
Island
58
MWRA­
Boston­
Clinton
59
Philadelphia­
Northeast
59
Philadelphia­
Southwest
AD
AE
AF
AG
AH
Yearly
Implement
Yearly
Implement
Yearly
Total
Costs
Per
Facility
Total
Costs
Permitting
Costs
Per
Facility
=
Q63+
V63+
X63+
AB63
=
P63/
132
=
Q63/
132
=
AC63/
132
=
AD63/
132
=
Q71+
V71+
X71+
AB71
=
P71/
27
=
Q71/
27
=
AC71/
27
=
AD71/
27
=
Q75+
V75+
X75+
AB75
=
AC75/
M75
=
AD75/
M75
=
Q76+
V76+
X76+
AB76+
Q77
=
P76/
57
=
Q76/
57
=
AC76/
57
=
AD76/
57
=
Q84+
V84+
X84+
AB84
=
P84/
15
=
Q84/
15
=
AC84/
15
=
AD84/
15
=
Q89+
V89+
X89+
AB89
=
P89/
M89
=
Q89/
M89
=
AC89/
M89
=
AD89/
M89
=
Q91+
V91+
X91+
AB91
=
P91/
143
=
Q91/
143
=
AC91/
143
=
AD91/
143
=
Q93+
V93+
X93+
AB93
=
P93/
M93
=
Q93/
M93
=
AC93/
M93
=
AD93/
M93
=
Q94+
V94+
X94+
AB94
=
P94/
M94
=
Q94/
M94
=
AC94/
M94
=
AD94/
M94
=
Q95+
V95+
X95+
AB95
=
P95/
M95
=
Q95/
M95
=
AC95/
M95
=
AD95/
M95
=
Q97+
V97+
X97+
AB97
=
P97/
547
=
Q97/
547
=
AC97/
547
=
AD97/
547
=
Q100+
V100+
X100+
AB100
=
P100/
M100
=
Q100/
M100
=
AC100/
M100
=
AD100/
M100
=
Q101+
V101+
X101+
AB101
=
P101/
M101
=
Q101/
M101
=
AC101/
M101
=
AD101/
M101
=
Q104+
V104+
X104+
AB104
=
P104/
599
=
Q104/
599
=
AC104/
599
=
AD104/
599
=
Q111+
V111+
X111+
AB111
=
AC111/
69
=
AD111/
69
=
Q113+
V113+
X113+
AB113
=
P113/
68
=
Q113/
68
=
AC113/
68
=
AD113/
68
February
14,
2003
28
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
C
D
E
F
G
H
I
J
K
L
M
Survey
Agency
State
Flow
No.
of
#
of
MFJS
Total
Number
(
mgd)
IU
433
Others
Regulated
Unregulated
Electroplating
Regulated
Unregulated
MP&
M
Sites
Categorical
GM
Non­
Cat.
G
M
#
of
Non­
Cat.
Oily
Waste
115
116
117
118
119
120
121
59
Philadelphia­
Southeast
PA
93.0
16
1
0
0
0
4
1
0
=
SUM(
F115:
L115)
60
Nashville­
Central
TN
85.0
30
7
2
2
0
13
0
0
=
SUM(
F116:
L116)
60
Nashville­
Whites
Creek
TN
25.0
4
1
0
0
0
1
0
0
=
SUM(
F117:
L117)
60
Nashville­
Dry
Creek
TN
14.0
8
1
0
1
0
5
0
0
=
SUM(
F118:
L118)
63
Wayne
County
MI
50
463
7
2
13
0
11
6
0
=
SUM(
F119:
L119)
65
City
of
Dayton
OH
52.12
44
23
4
5
20
25
1
15
=
SUM(
F120:
L120)

February
14,
2003
29
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
Survey
Agency
Number
1
Monroe
County
115
116
117
118
119
120
121
59
Philadelphia­
Southeast
60
Nashville­
Central
60
Nashville­
Whites
Creek
60
Nashville­
Dry
Creek
63
Wayne
County
65
City
of
Dayton
N
O
P
Q
R
S
T
U
V
Implement
Yearly
Implement
Yearly
Hourly
Salary
Overhead
factor
Implement
Yearly
Total
Permitting
­
Labor
Hrs
Permitting
­
Costs
Labor
Rate
Analytical
Costs
=
53*
33
=
37*
33
=
N116*
R116*(
1+
T116)
=
O116*
R116*(
1+
T116)
$
19.50
$
24.50
0.5
$
153,000.00
$
153,000.00
578
190
=
N119*
R119*(
1+
T119)
=
O119*
R119*(
1+
T119)
$
22.00
$
30.00
2.75
=
M119*
650
=
M119*
650
6071
5861
=
N120*
R120*(
1+
T120)
=
O120*
R120*(
1+
T120)
$
20.00
$
25.00
0.25
$
55,800.00
$
55,800.00
February
14,
2003
30
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
Survey
Agency
Number
1
Monroe
County
115
116
117
118
119
120
121
59
Philadelphia­
Southeast
60
Nashville­
Central
60
Nashville­
Whites
Creek
60
Nashville­
Dry
Creek
63
Wayne
County
65
City
of
Dayton
W
X
Y
Z
AA
AB
AC
Implement
Yearly
Implement
Yearly
Implement
Yearly
Implement
Sampling
Costs
Management
Salary
Hrs
Management
Overhead
Costs
Total
Costs
$
40,800.00
$
40,800.00
135
60
=
Y116*
S116*(
1+
T116)
=
Z116*
S116*(
1+
T116)
=
P116+
U116+
W116+
AA116
=
M119*
100
=
M119*
100
400
100
=
Y119*
S119*(
1+
T119)
=
Z119*
S119*(
1+
T119)
=
P119+
U119+
W119+
AA119
$
41,850.00
$
41,850.00
663
313
=
Y120*
S120*(
1+
T120)
=
Z120*
S120*(
1+
T120)
=
P120+
U120+
W120+
AA120
February
14,
2003
31
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
A
B
Survey
Agency
Number
1
Monroe
County
115
116
117
118
119
120
121
59
Philadelphia­
Southeast
60
Nashville­
Central
60
Nashville­
Whites
Creek
60
Nashville­
Dry
Creek
63
Wayne
County
65
City
of
Dayton
AD
AE
AF
AG
AH
Yearly
Implement
Yearly
Implement
Yearly
Total
Costs
Per
Facility
Total
Costs
Permitting
Costs
Per
Facility
=
Q116+
V116+
X116+
AB116
=
P116/
33
=
Q116/
33
=
AC116/
33
=
AD116/
33
=
Q119+
V119+
X119+
AB119
=
P119/
33
=
Q119/
33
=
AC119/
33
=
AD119/
33
=
Q120+
V120+
X120+
AB120
=
P120/
33
=
Q120/
33
=
AC120/
33
=
AD120/
33
=
AVERAGE(
AE3:
AE120)
=
AVERAGE(
AF3:
AF120)
=
AVERAGE(
AG3:
AG120)
=
AVERAGE(
AH3:
AH120)

February
14,
2003
32
of
32
MPM­
COSTS­
formula.
xls
­
>
50MGD
