Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
MuniMPCT_
Final.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Tests
Impact
Measure
Description
Summary
B
N
Large
Sample
weighted
number
of
large
municipality
facilities
Summary
C
N
=
SUMIF(
test_
summ!$
G$
5:$
G$
158,
Summary!
D$
2&
Summary!$
A4,
test_
summ!$
S$
5:$
S$
158)

%
Percent
of
large
municipality
facilities
Summary
D
N
=
C4/
C$
8
Small
Sample
weighted
number
of
small
municipality
facilities
Summary
E
N
=
SUMIF(
test_
summ!$
G$
5:$
G$
158,
Summary!
F$
2&
Summary!$
A4,
test_
summ!$
S$
5:$
S$
158)

%
Percent
of
small
municipality
facilities
Summary
F
N
=
E4/
E$
8
Total
Total
number
of
sample
weighted
municipality
facilities
Summary
G
N
=
SUM(
D4,
F4)

%
Percent
of
all
municipality
facilities
Summary
H
N
=
G4/
G$
8
SITE_
ID
Survey
ID
Test_
Summ
A
N
MUNI_
ID
Municipality
ID
Test_
Summ
B
Y
=
LEFT(
A6,5)
Final
Rule
­
Oily
Waste
Directs
(
Option
1):
Cost
of
Service
Test
Is
cost
service
greater
than
1%
in
Option
1?
1=
yes;
0=
no
Test_
Summ
C
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,4,0)

Final
Rule
­
Oily
Waste
Directs
(
Option
1):
HH
Afford
Is
household
affordability
greater
than
1%
in
Option
1?
1=
yes;
0=
no
Test_
Summ
D
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,10,0)

Final
Rule
­
Oily
Waste
Directs
(
Option
1):
Muni
Debt
Is
their
municipality
debt
greater
than
25%
in
Option
1?
1=
yes;
0=
no
Test_
Summ
E
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,16,0)

Final
Rule
­
Oily
Waste
Directs
(
Option
1):
Pass/
Fail
Pass/
Fail
Status:
P=
pass
all
tests;
F­
CS=
fail
cost
of
service
test;
F­
HH=
fail
household
affordability
test;
F­
MD=
fail
municipality
debt
test
Test_
Summ
F
N
=
IF(
AND(
C6'=
0,
D6'=
0,
E6'=
0),"
P",
IF(
E6'=
1,"
F­
MD",
IF(
D6'=
1,"
F­
HH",
IF(
C6'=
1,"
F­
CS","
n/
a"))))

Final
Rule
­
Oily
Waste
Directs
(
Option
1):
Size+
Pass/
Fail
Municipality
Size
and
Pass/
Fail
Status
Test_
Summ
G
Y
=$
W6&
F6
Proposed/
NODA
(
Option
2):
Cost
of
Service
Test
Is
cost
service
greater
than
1%
in
Option
2?
1=
yes;
0=
no
Test_
Summ
H
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,5,0)

Proposed/
NODA
(
Option
2):
HH
Afford
Is
household
affordability
greater
than
1%
in
Option
2?
1=
yes;
0=
no
Test_
Summ
I
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,11,0)

Proposed/
NODA
(
Option
2):
Muni
Debt
Is
their
municipality
debt
greater
than
25%
in
Option
2?
1=
yes;
0=
no
Test_
Summ
J
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,17,0)

Proposed/
NODA
(
Option
2):
Pass/
Fail
Pass/
Fail
Status:
P=
pass
all
tests;
F­
CS=
fail
cost
of
service
test;
F­
HH=
fail
household
affordability
test;
F­
MD=
fail
municipality
debt
test
Test_
Summ
K
N
=
IF(
AND(
H6'=
0,
I6'=
0,
J6'=
0),"
P",
IF(
J6'=
1,"
F­
MD",
IF(
I6'=
1,"
F­
HH",
IF(
H6'=
1,"
F­
CS","
n/
a"))))

Proposed/
NODA
(
Option
2):
Size+
Pass/
Fail
Municipality
Size
and
Pass/
Fail
Status
Test_
Summ
L
Y
=$
W6&
K6
413
to
433
Upgrade
(
Option
3):
Cost
of
Service
Test
Is
cost
service
greater
than
1%
in
Option
3?
1=
yes;
0=
no
Test_
Summ
M
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,6,0)

413
to
433
Upgrade
(
Option
3):
HH
Afford
Is
household
affordability
greater
than
1%
in
Option
3?
1=
yes;
0=
no
Test_
Summ
N
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,12,0)

413
to
433
Upgrade
(
Option
3):
Muni
Debt
Is
their
municipality
debt
greater
than
25%
in
Option
3?
1=
yes;
0=
no
Test_
Summ
O
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,18,0)

413
to
433
Upgrade
(
Option
3):
Pass/
Fail
Pass/
Fail
Status:
P=
pass
all
tests;
F­
CS=
fail
cost
of
service
test;
F­
HH=
fail
household
affordability
test;
F­
MD=
fail
municipality
debt
test
Test_
Summ
P
N
=
IF(
AND(
M6'=
0,
N6'=
0,
O6'=
0),"
P",
IF(
O6'=
1,"
F­
MD",
IF(
N6'=
1,"
F­
HH",
IF(
M6'=
1,"
F­
CS","
n/
a"))))

413
to
433
Upgrade
(
Option
3):
Size+
Pass/
Fail
Municipality
Size
and
Pass/
Fail
Status
Test_
Summ
Q
Y
=$
W6&
P6
All
433
Upgrade
(
Option
4):
Cost
of
Service
Test
Is
cost
service
greater
than
1%
in
Option
4?
1=
yes;
0=
no
Test_
Summ
R
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,7,0)

All
433
Upgrade
(
Option
4):
HH
Afford
Is
household
affordability
greater
than
1%
in
Option
4?
1=
yes;
0=
no
Test_
Summ
S
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,13,0)

All
433
Upgrade
(
Option
4):
Muni
Debt
Is
their
municipality
debt
greater
than
25%
in
Option
4?
1=
yes;
0=
no
Test_
Summ
T
N
=
VLOOKUP($
A6,
Tests!$
A$
6:$
Y$
125,19,0)

February
14,
2003
1
of
28
MuniMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
MuniMPCT_
Final.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
All
433
Upgrade
(
Option
4):
Pass/
Fail
Pass/
Fail
Status:
P=
pass
all
tests;
F­
CS=
fail
cost
of
service
test;
F­
HH=
fail
household
affordability
test;
F­
MD=
fail
municipality
debt
test
Test_
Summ
U
N
=
IF(
AND(
R6'=
0,
S6'=
0,
T6'=
0),"
P",
IF(
T6'=
1,"
F­
MD",
IF(
S6'=
1,"
F­
HH",
IF(
R6'=
1,"
F­
CS","
n/
a"))))

All
433
Upgrade
(
Option
4):
Size+
Pass/
Fail
Municipality
Size
and
Pass/
Fail
Status
Test_
Summ
V
Y
=$
W6&
U6
Size
Municipality
Size
Test_
Summ
W
Y
=
VLOOKUP(
A6,
facdata,
10,0)
Weight
Sample
Weight
Test_
Summ
X
Y
=
VLOOKUP($
B6,
MuniData!$
A$
6:$
F$
60,6,0)
Direct/
Indirect
Discharger
Type:
D=
Direct;
I=
Indirect
Test_
Summ
Y
N
=
VLOOKUP(
A6,'[
Summary_
Final.
xls]
Data'!$
A$
6:$
G$
953,7,0)
Size&
Type
Municipality
Size
Test_
Summ
Z
Y
=
VLOOKUP(
A6,
FacData!$
A$
7:$
N$
127,14,0)
SID
Survey
ID
Tests
A
N
=
FacData!
A8
MUNI_
ID
Municipality
ID
Tests
B
Y
=
LEFT(
A7,5)
Fail
Cost
of
Service:
Opt
1
Is
cost
service
greater
than
1%
in
Option
1?
1=
yes;
0=
no
Tests
D
N
=
IF(
CostOfSvc!
I7>'=
0.01,1,0)

Fail
Cost
of
Service:
Opt
2
Is
cost
service
greater
than
1%
in
Option
2?
1=
yes;
0=
no
Tests
E
N
=
IF(
CostOfSvc!
J7>'=
0.01,1,0)

Fail
Cost
of
Service:
Opt
3
Is
cost
service
greater
than
1%
in
Option
3?
1=
yes;
0=
no
Tests
F
N
=
IF(
CostOfSvc!
K7>'=
0.01,1,0)

Fail
Cost
of
Service:
Opt
4
Is
cost
service
greater
than
1%
in
Option
4?
1=
yes;
0=
no
Tests
G
N
=
IF(
CostOfSvc!
L7>'=
0.01,1,0)

Fail
HH
Afford:
Baseline
Is
household
affordability
greater
than
1%
in
the
baseline?
1=
yes;
0=
no
Tests
I
N
=
IF(
VLOOKUP($
B7,'
HH
Afford'!$
A$
6:$
P$
59,
I$
1,0)>
0.01,1,0)

Fail
HH
Afford:
Opt
1
Is
household
affordability
greater
than
1%
Option
1?
1=
yes;
0=
no
Tests
J
=
IF(
AND($
I7<
1,(
VLOOKUP($
B7,'
HH
Afford'!$
A$
6:$
P$
59,
J$
1,0)>
0.01)),
1,0)

Fail
HH
Afford:
Opt
2
Is
household
affordability
greater
than
1%
Option
2?
1=
yes;
0=
no
Tests
K
N
=
IF(
AND($
I7<
1,(
VLOOKUP($
B7,'
HH
Afford'!$
A$
6:$
P$
59,
K$
1,0)>
0.01)),
1,0)

Fail
HH
Afford:
Opt
3
Is
household
affordability
greater
than
1%
Option
3?
1=
yes;
0=
no
Tests
L
=
IF(
AND($
I7<
1,(
VLOOKUP($
B7,'
HH
Afford'!$
A$
6:$
P$
59,
L$
1,0)>
0.01)),
1,0)

Fail
HH
Afford:
Opt
4
Is
household
affordability
greater
than
1%
Option
4?
1=
yes;
0=
no
Tests
M
N
=
IF(
AND($
I7<
1,(
VLOOKUP($
B7,'
HH
Afford'!$
A$
6:$
P$
59,
M$
1,0)>
0.01)),
1,0)

Fail
Muni
Debt:
Baseline
Is
their
municipality
debt
greater
than
25%
in
the
baseline?
1=
yes;
0=
no
Tests
O
N
=
IF(
VLOOKUP($
B7,
MuniDebt!$
A$
6:$
I$
59,
O$
1,0)>
0.25,1,0)

Fail
Muni
Debt:
Opt
1
Is
their
municipality
debt
greater
than
25%
in
Option
1?
1=
yes;
0=
no
P
=
IF(
AND($
O7<
1*(
VLOOKUP($
B7,
MuniDebt!$
A$
6:$
I$
59,
P$
1,0)>
0.25)),
1,0)

Fail
Muni
Debt:
Opt
2
Is
their
municipality
debt
greater
than
25%
in
Option
2?
1=
yes;
0=
no
Tests
Q
N
=
IF(
AND($
O7<
1*(
VLOOKUP($
B7,
MuniDebt!$
A$
6:$
I$
59,
Q$
1,0)>
0.25)),
1,0)

Fail
Muni
Debt:
Opt
3
Is
their
municipality
debt
greater
than
25%
in
Option
3?
1=
yes;
0=
no
R
=
IF(
AND($
O7<
1*(
VLOOKUP($
B7,
MuniDebt!$
A$
6:$
I$
59,
R$
1,0)>
0.25)),
1,0)

Fail
Muni
Debt:
Opt
4
Is
their
municipality
debt
greater
than
25%
in
Option
4?
1=
yes;
0=
no
Tests
S
N
=
IF(
AND($
O7<
1*(
VLOOKUP($
B7,
MuniDebt!$
A$
6:$
I$
59,
S$
1,0)>
0.25)),
1,0)

Joint
No
Pass:
Opt
1
Does
the
site
pass
any
of
the
three
tests
in
Option
1?
0=
yes,
1=
no
U
=
IF(
OR(
P7'=
0,
J7'=
0,
D7'=
0),
0,1)

Joint
No
Pass:
Opt
2
Does
the
site
pass
any
of
the
three
tests
in
Option
2?
0=
yes,
1=
no
Tests
V
N
=
IF(
OR(
Q7'=
0,
K7'=
0,
E7'=
0),
0,1)

Joint
No
Pass:
Opt
3
Does
the
site
pass
any
of
the
three
tests
in
Option
3?
0=
yes,
1=
no
W
=
IF(
OR(
R7'=
0,
L7'=
0,
F7'=
0),
0,1)

Joint
No
Pass:
Opt
4
Does
the
site
pass
any
of
the
three
tests
in
Option
4?
0=
yes,
1=
no
Tests
X
N
=
IF(
OR(
S7'=
0,
M7'=
0,
G7'=
0),
0,1)

SITE_
ID
Survey
ID
CostOfSvc
A
N
=
FacData!
A8
MUNI_
ID
Municipality
ID
CostOfSvc
B
Y
=
LEFT(
A7,5)
Total
Costs
&
Expenditures
Total
Costs
and
Expenditures
CostOfSvc
C
Y
=
FacData!
E8
1996
Annualized
Compliance
Cost:
Opt
1
1996
Annualized
Compliance
Cost
(
without
Interest):
Option
1
CostOfSvc
D
Y
=
Costs!
F8
1996
Annualized
Compliance
Cost:
Opt
2
1996
Annualized
Compliance
Cost
(
without
Interest):
Option
2
CostOfSvc
E
Y
=
Costs!
I8
1996
Annualized
Compliance
Cost:
Opt
3
1996
Annualized
Compliance
Cost
(
without
Interest):
Option
3
F
Y
=
Costs!
L8
February
14,
2003
2
of
28
MuniMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
MuniMPCT_
Final.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
1996
Annualized
Compliance
Cost:
Opt
4
1996
Annualized
Compliance
Cost
(
without
Interest):
Option
4
CostOfSvc
G
Y
=
Costs!
O8
Compliance
Cost
Share
of
Baseline
Cost
of
Service:
Opt
1
1996
Interest
Payments:
Option
1
CostOfSvc
I
Y
=
D7/$
C7
Compliance
Cost
Share
of
Baseline
Cost
of
Service:
Opt
2
1996
Interest
Payments:
Option
2
CostOfSvc
J
Y
=
E7/$
C7
Compliance
Cost
Share
of
Baseline
Cost
of
Service:
Opt
3
1996
Interest
Payments:
Option
3
CostOfSvc
K
Y
=
F7/$
C7
Compliance
Cost
Share
of
Baseline
Cost
of
Service:
Opt
4
1996
Interest
Payments:
Option
4
CostOfSvc
L
Y
=
G7/$
C7
MUNI_
ID
Municipality
ID
HH
Afford
A
N
=
MuniData!
A8
PC
BUDGET
Pollution
Control
Budget
HH
Afford
B
Y
=
MuniFin!
R8
Households
Number
of
Households
in
the
Municipality
HH
Afford
C
Y
=
MuniData!
L8
Per
Household
Post­
Compliance
Total
Cost:
Baseline
Per
Household
Post­
Compliance
Total
Cost:
Baseline
HH
Afford
D
Y
=$
B7/$
C7
Per
Household
Post­
Compliance
Total
Cost:
Opt
1
Per
Household
Post­
Compliance
Total
Cost:
Option
1
HH
Afford
E
Y
=(
SUMIF(
CostOfSvc!$
B$
7:$
B$
66,'
HH
Afford'!$
A7,
CostOfSvc!
D$
7:
D$
66)+$
B7)/$
C7
Per
Household
Post­
Compliance
Total
Cost:
Opt
2
Per
Household
Post­
Compliance
Total
Cost:
Option
2
HH
Afford
F
Y
=(
SUMIF(
CostOfSvc!$
B$
7:$
B$
66,'
HH
Afford'!$
A7,
CostOfSvc!
E$
7:
E$
66)+$
B7)/$
C7
Per
Household
Post­
Compliance
Total
Cost:
Opt
3
Per
Household
Post­
Compliance
Total
Cost:
Option
3
HH
Afford
G
Y
=(
SUMIF(
CostOfSvc!$
B$
7:$
B$
66,'
HH
Afford'!$
A7,
CostOfSvc!
F$
7:
F$
66)+$
B7)/$
C7
Per
Household
Post­
Compliance
Total
Cost:
Opt
4
Per
Household
Post­
Compliance
Total
Cost:
Option
4
HH
Afford
H
Y
=(
SUMIF(
CostOfSvc!$
B$
7:$
B$
66,'
HH
Afford'!$
A7,
CostOfSvc!
G$
7:
G$
66)+$
B7)/$
C7
Median
HH
Income
Median
Household
Income
in
the
Municipality
HH
Afford
J
Y
=
MuniData!
M8
Cost
Share
of
Median
Income:
Baseline
Cost
Share
of
Median
Income:
Baseline
HH
Afford
K
Y
=+
D7/$
J7
Cost
Share
of
Median
Income:
Opt
1
Cost
Share
of
Median
Income:
Option
1
HH
Afford
M
Y
=+
E7/$
J7
Cost
Share
of
Median
Income:
Opt
2
Cost
Share
of
Median
Income:
Option
2
HH
Afford
M
Y
=+
F7/$
J7
Cost
Share
of
Median
Income:
Opt
3
Cost
Share
of
Median
Income:
Option
3
HH
Afford
N
Y
=+
G7/$
J7
Cost
Share
of
Median
Income:
Opt
4
Cost
Share
of
Median
Income:
Option
4
HH
Afford
O
Y
=+
H7/$
J7
MUNI_
ID
Municipality
ID
MuniDebt
A
N
=
MuniData!
A8
Total
Cost
of
Debt
Service
Total
Cost
of
Debt
Service
MuniDebt
B
Y
=
MuniFin!
Q8
Total
Revenues
(
from
all
sources)
Total
Revenues
(
from
all
sources)
MuniDebt
C
Y
=
MuniFin!
B8
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Baseline
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Baseline
MuniDebt
D
Y
=$
B7/$
C7
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Opt
1
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Option
1
MuniDebt
E
Y
=(
SUMIF(
Costs!$
C$
7:$
C$
98,
MuniDebt!$
A7,
Costs!
F$
7:
F$
98)+$
B7)/$
C7
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Opt
2
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Option
2
MuniDebt
F
Y
=(
SUMIF(
Costs!$
C$
7:$
C$
98,
MuniDebt!$
A7,
Costs!
I$
7:
I$
98)+$
B7)/$
C7
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Opt
3
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Option
3
MuniDebt
G
Y
=(
SUMIF(
Costs!$
C$
7:$
C$
98,
MuniDebt!$
A7,
Costs!
L$
7:
L$
98)+$
B7)/$
C7
February
14,
2003
3
of
28
MuniMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
MuniMPCT_
Final.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Opt
4
Cost
of
Debt
Service
as
a
Percent
of
Revenue:
Option
4
MuniDebt
H
Y
=(
SUMIF(
Costs!$
C$
7:$
C$
98,
MuniDebt!$
A7,
Costs!
O$
7:
O$
98)+$
B7)/$
C7
MUNI_
ID
Municipality
ID
MuniData
A
N
SHORT
NAME
Name
of
Municipality
MuniData
B
Y
ID
+
00
Municipality
ID
followed
by
"
00"
MuniData
C
Y
=
CONCATENATE(
A8,"
00")
SOURCE
Type
of
Municipality
(
e.
g.,
city,
county,
transit)
MuniData
D
Y
=
VLOOKUP($
A8,[
MUN_
WGT1.
xls]
MUNIWGTS!$
B$
1:$
H$
151,3,
FALSE)

STATE
State
MuniData
E
Y
=
VLOOKUP($
A8,[
MUN_
WGT1.
xls]
MUNIWGTS!$
B$
1:$
H$
151,4,
FALSE)
WEIGHT
Sample
Weight
MuniData
F
Y
=
VLOOKUP($
A8,[
MUN_
WGT1.
xls]
MUNIWGTS!$
B$
1:$
H$
151,5,
FALSE)
REG
Region
MuniData
G
Y
=
VLOOKUP($
A8,[
MUN_
WGT1.
xls]
MUNIWGTS!$
B$
1:$
H$
151,6,
FALSE)
POP
Population
Range
MuniData
H
Y
=
VLOOKUP($
A8,[
MUN_
WGT1.
xls]
MUNIWGTS!$
B$
1:$
H$
151,7,
FALSE)
EMPS(
1996)
Number
of
Employees
MuniData
I
Y
YEAR
Year
of
Most
Recent
Demographic
Data
MuniData
J
Y
POPULATION
Population
MuniData
K
Y
#
HSHOLDS
Number
of
Households
in
the
Municipality
MuniData
L
Y
MED
HH
INC
($)
Median
Household
Income
in
the
Municipality
MuniData
M
Y
AERO
Do
you
own
and
operate
at
least
one
aerospace
site?
1=
yes;
0=
no
MuniData
T
Y
AIR
Do
you
own
and
operate
at
least
one
aircraft
site?
1=
yes;
0=
no
MuniData
U
Y
BUS
Do
you
own
and
operate
at
least
one
bus
&
truck
site?
1=
yes;
0=
no
MuniData
V
Y
ELEC
Do
you
own
and
operate
at
least
one
electronic
equipment
site?
1=
yes;
0=
no
MuniData
W
Y
HARD
Do
you
own
and
operate
at
least
one
hardware
site?
1=
yes;
0=
no
MuniData
X
Y
HOUSE
Do
you
own
and
operate
at
least
one
household
equipment
site?
1=
yes;
0=
no
MuniData
Y
Y
INSTR
Do
you
own
and
operate
at
least
one
instruments
site?
1=
yes;
0=
no
MuniData
Z
Y
MOB
Do
you
own
and
operate
at
least
one
mobile
industrial
equipment
site?
1=
yes;
0=
no
MuniData
AA
Y
MOTOR
Do
you
own
and
operate
at
least
one
motor
vehicles
site?
1=
yes;
0=
no
MuniData
AB
Y
OFF
Do
you
own
and
operate
at
least
one
office
machines
site?
1=
yes;
0=
no
MuniData
AC
Y
ORDN
Do
you
own
and
operate
at
least
one
ordnance
site?
1=
yes;
0=
no
MuniData
AD
Y
OTH
Do
you
own
and
operate
at
least
one
other
metal
products
site?
1=
yes;
0=
no
MuniData
AE
Y
PREC
Do
you
own
and
operate
at
least
one
precious
metals
and
jewelry
site?
1=
yes;
0=
no
MuniData
AF
Y
PRINT
Do
you
own
and
operate
at
least
one
printed
circuit
boards
site?
1=
yes;
0=
no
MuniData
AG
Y
RAIL
Do
you
own
and
operate
at
least
one
railroad
site?
1=
yes;
0=
no
MuniData
AH
Y
SHIPS
Do
you
own
and
operate
at
least
one
ships
&
boats
site?
1=
yes;
0=
no
MuniData
AI
Y
STAT
Do
you
own
and
operate
at
least
one
stationary
industrial
equipment
site?
1=
yes;
0=
no
MuniData
AJ
Y
MUNI_
ID
Municipality
ID
MuniFin
A
N
TOTAL
REVENUES,
1996$
TOTAL
REVENUES,
1996$
MuniFin
B
Y
PROPERTY
REVENUE,
1996$
Tax
Revenue
from
Property
(
Real
and
Other),
1996$
MuniFin
C
Y
February
14,
2003
4
of
28
MuniMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
MuniMPCT_
Final.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
PROP
REV
RESIDENTIAL,
1996$
Tax
Revenue
from
Residential
Property,
1996$
MuniFin
D
Y
PROP
REV
COMMERICAL,
1996$
Tax
Revenue
from
Commercial
Property,
1996$
MuniFin
E
Y
GRANT
REVENUES,
1996$
Revenues
from
Grants,
1996$
MuniFin
F
Y
OTHER
REVENUES,
1996$
Other
Revenues
(
includes
fees,
fines,
service
charges,
interest,
rental
income,
excise
taxes
and
all
other
municipal
revenues
other
than
property
taxes
and
grants),
1996$
MuniFin
G
Y
OTHER
REV
HOUSEHOLDS,
1996$
Other
Revenues
from
Households,
1996$
MuniFin
H
Y
OTHER
REV
COMMERICIAL,
1996$
Other
Revenues
from
Businesses,
1996$
MuniFin
I
Y
OTHER
REV
INDETERMINATE,
1996$
Other
Revenues,
Intermediate
Origin,
1996$
MuniFin
J
Y
MARKET
VALUE
TAXABLE
PROPERTY,
1996$
Full
Market
Value
of
Taxable
Property,
1996$
MuniFin
K
Y
MARKET
VALUE
RESIDENTIAL,
1996$
Full
Market
Value
of
Taxable
Residential
Property,
1996$
MuniFin
L
Y
MARKET
VALUE
COMMERCIAL,
1996$
Full
Market
Value
of
Taxable
Commercial
Property,
1996$
MuniFin
M
Y
TAX
COLLECTION
RATE
(%),
1996$
Property
Tax
Collection
Rate
(
ratio
of
property
taxes
collected
to
property
taxes
levied),
1996$
MuniFin
N
Y
CASH
RESERVES,
1996$
Cash
Reserves,
1996$
MuniFin
O
Y
TOTAL
DEBT,
1996$
Total
Debt,
all
types,
1996$
MuniFin
P
Y
COST
OF
DEBT
SERVICE,
1996$
Cost
of
Debt
Service
(
include
both
interest
and
repayment
of
principal),
1996$
MuniFin
Q
Y
ANNUAL
POLLUTION
CONTROL
BUDGET,
1996$
Annual
Budget
for
Current
Pollution
Control,
1996$
MuniFin
R
Y
FINANCED
BY
TAX
REVS,
1996$
Annual
Budget
for
Current
Pollution
Control:
Amount
Financed
by
Tax
Revenues,
1996$
MuniFin
S
Y
FINANCED
BY
FEE
REVS,
1996$
Annual
Budget
for
Current
Pollution
Control:
Amount
Financed
by
Fee
Revenues,
1996$
MuniFin
T
Y
FINANCED
BY
OTHER,
1996$
Annual
Budget
for
Current
Pollution
Control:
Amount
Financed
by
All
Other
Sources
including
Grants,
1996$
MuniFin
U
Y
RESIDENTIAL
FEES
RESIDENTIAL
FEES
MuniFin
V
Y
=
SUMIF(
FacData!$
C$
8:$
C$
269,
MuniFin!
A8,
FacData!$
I$
8:$
I$
269)
NON­
RESIDENTIAL
FEES
NON­
RESIDENTIAL
FEES
MuniFin
W
Y
=
SUMIF(
FacData!$
C$
8:$
C$
269,
MuniFin!$
A8,
FacData!$
H$
8:$
H$
269)
SITE_
ID
Survey
ID
FacData
A
N
SITE
NAME
Site
Name
FacData
B
Y
MUNI_
ID
Municipality
ID
FacData
C
Y
=
LEFT(
A8,5)
FACILITY
SECTOR
Facility
Sector
FacData
D
Y
=
VLOOKUP(
A8,'[
RevbySct_
Final.
xls]
Summary'!$
A$
3:$
BM$
923,10,0)
TOTAL
COSTS
&
EXPENDITURES,
1996$
Total
FY
1996
Costs
and
Expenditures
including
operating,
overhead
and
debt
service
costs
and
expenses,
1996$
FacData
E
Y
DEBT
SERVICE,
1996$
Debt
Service
(
including
interest
and
repayment
of
capital),
1996$
FacData
F
Y
GENERAL
FUNDS,
1996$
General
Funds,
1996$
FacData
G
Y
FEES
FROM
SITE
ACTIVITIES,
1996$
Fees
for
Activities
Performed
by
This
Site,
1996$
FacData
H
Y
FEES
FROM
RESIDENTIAL
PAYERS,
1996$
Of
Fees
for
Activities
Performed
by
This
Site,
Amount
from
Residential
Fee
Payers,
If
Known,
1996$
FacData
I
Y
February
14,
2003
5
of
28
MuniMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
MuniMPCT_
Final.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
ENTITY
SIZE
Is
the
municipality
small
(
population
of
50,000
or
less)?
FacData
J
Y
=
IF(
VLOOKUP(
C8,
munidata,
11,0)<'=
50000,"
Small",
IF(
VLOOKUP(
C8,
munidata,
11,0)>
50000,"
Large","
Unknown"))
WEIGHT
Sample
Weight
FacData
K
Y
=
VLOOKUP(
A8,'[
Summary_
Final.
xls]
Data'!$
A$
6:$
DO$
990,5,0)
GOV'T
TYPE
Government
Type:
M
=
Municipal
Government;
C
=
County
Government;
S
=
State
Government;
R
=
Regional
Government
Authority
FacData
L
Y
SIZE&
TYPE
Municipality
Size
&
Gov't
Type
FacData
M
Y
=
J8&
L8
SITE_
ID
Survey
ID
Costs
A
N
=
FacData!
A8
MUNI_
ID
Municipality
ID
Costs
C
Y
=
LEFT(
A8,5)
Option
1
(
OW
Directs):
CapCst1
Option
1
Capital
Costs,
1996$
Costs
D
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
D$
1,0)

Option
1
(
OW
Directs):
AnnCst1
Option
1
Annual
Costs,
1996$
Costs
E
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
E$
1,0)

Option
1
(
OW
Directs):
CC1_
96
Annualized
Option
1
Costs,
1996$
Costs
F
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
F$
1,0)

Option
2
(
Proposed/
NODA):
CapCst2
Option
2
Capital
Costs,
1996$
Costs
G
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
G$
1,0)

Option
2
(
Proposed/
NODA):
AnnCst2
Option
2
Annual
Costs,
1996$
Costs
H
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
H$
1,0)

Option
2
(
Proposed/
NODA):
CC2_
96
Annualized
Option
2
Costs,
1996$
Costs
I
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
I$
1,0)

Option
3
(
Directs
+
413):
CapCst3
Option
3
Capital
Costs,
1996$
Costs
J
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
J$
1,0)

Option
3
(
Directs
+
413):
AnnCst3
Option
3
Annual
Costs,
1996$
Costs
K
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
K$
1,0)

Option
3
(
Directs
+
413):
CC3_
96
Annualized
Option
3
Costs,
1996$
Costs
L
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
L$
1,0)

Option
4
(
Directs
+
413
+
Local
Limits):
CapCst4
Option
4
Capital
Costs,
1996$
Costs
M
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
M$
1,0)

Option
4
(
Directs
+
413
+
Local
Limits):
AnnCst4
Option
4
Annual
Costs,
1996$
Costs
N
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
N$
1,0)

Option
4
(
Directs
+
413
+
Local
Limits):
CC4_
96
Annualized
Option
4
Costs,
1996$
Costs
O
Y
=
VLOOKUP($
A8,'[
CompCost_
Final.
xls]
1996'!$
A$
7:$
S$
1392,
O$
1,0)

1996
Social
Cost:
Option
1
1996
Social
Cost:
the
basic
option
Costs
S
Y
=
E8+(
D8*
AMORT_
O)
1996
Social
Cost:
Option
2
1996
Social
Cost:
the
sand
filter
option
Costs
T
Y
=
H8+(
G8*
AMORT_
O)
1996
Social
Cost:
Option
3
1996
Social
Cost:
NODA
option
Costs
U
Y
=
K8+(
J8*
AMORT_
O)
1996
Social
Cost:
Option
4
NODA
option
labor
cost
for
operating
and
maintenance
of
capital
equipment
Costs
V
Y
=
N8+(
M8*
AMORT_
O)

2001
Annualized
Compliance
Cost:
Option
1
NODA
option
annual
labor
cost
for
installation
of
capital
equipment
Costs
W
Y
=
F8*(
CCI01/
CCI96)

2001
Annualized
Compliance
Cost:
Option
2
NODA
option
annual
labor
cost
for
manufacturing
of
capital
equipment
Costs
X
Y
=
I8*(
CCI01/
CCI96)

2001
Annualized
Compliance
Cost:
Option
3
NODA
option
one
time
labor
cost
for
installation
of
capital
equipment
Costs
Y
Y
=
L8*(
CCI01/
CCI96)

2001
Annualized
Compliance
Cost:
Option
4
NODA
option
one
time
labor
cost
for
manufacturing
of
capital
equipment
Costs
Z
Y
=
O8*(
CCI01/
CCI96)

February
14,
2003
6
of
28
MuniMPCT_
Final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Constants
and
Other
Numeric
Values
blue
numbers
are
exogenous
RATE_
D
0.07
discount
rate
for
amortization
RATE_
O
0.07
OMB
discount
rate
for
social
opportunity
cost
PERIOD
15
Number
of
years
amortized
AMORT_
D
0.109794625
Amortization
factor,
15
years
AMORT_
O
0.109794625
Amortization
factor,
15
years,
OMB
rate
CCI96
5620
Construction
Cost
Index
­
Annual
Average
(
http://
enr.
construction.
com/
cost/
costcci.
asp)
CCI97
5825
Construction
Cost
Index
­
Annual
Average
(
http://
enr.
construction.
com/
cost/
costcci.
asp)
CCI98
5920
Construction
Cost
Index
­
Annual
Average
(
http://
enr.
construction.
com/
cost/
costcci.
asp)
CCI99
6060
Construction
Cost
Index
­
Annual
Average
(
http://
enr.
construction.
com/
cost/
costcci.
asp)
CCI00
6221
Construction
Cost
Index
­
Annual
Average
(
http://
enr.
construction.
com/
cost/
costcci.
asp)
CCI01
6342
Construction
Cost
Index
­
Annual
Average
(
http://
enr.
construction.
com/
cost/
costcci.
asp)

February
14,
2003
7
of
28
MuniMPCT_
Final.
xls
­
Values
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Tests
Large
%
Small
%
Total
%
Final
Rule
­
Oily
Waste
Directs
(
Option
1)
P
Pass
all
three
tests
1,801
98.8%
1,822
92.9%
3,623
95.7%
F­
MD
Fail
Government
Debt
Test
0
0.0%
0
0.0%
0
0.0%
F­
HH
Fail
Taxpayers
Test
0
0.0%
0
0.0%
0
0.0%
F­
CS
Fail
Cost
of
Service
22
1.2%
140
7.1%
162
4.3%
Total
1,823
100%
1,962
100%
3,785
100%
Proposed/
NODA
(
Option
2)
P
Pass
all
three
tests
1,672
91.7%
1,822
92.9%
3,494
92.3%
F­
MD
Fail
Government
Debt
Test
0
0.0%
0
0.0%
0
0.0%
F­
HH
Fail
Taxpayers
Test
0
0.0%
0
0.0%
0
0.0%
F­
CS
Fail
Cost
of
Service
151
8.3%
140
7.1%
291
7.7%
Total
1,823
100%
1,962
100%
3,785
100%
413
to
433
Upgrade
(
Option
3)
P
Pass
all
three
tests
1,801
98.8%
1,822
92.9%
3,623
95.7%
F­
MD
Fail
Government
Debt
Test
0
0.0%
0
0.0%
0
0.0%
F­
HH
Fail
Taxpayers
Test
0
0.0%
0
0.0%
0
0.0%
F­
CS
Fail
Cost
of
Service
22
1.2%
140
7.1%
162
4.3%
Total
1,823
100%
1,962
100%
3,785
100%
All
433
Upgrade
(
Option
4)
P
Pass
all
three
tests
1,791
98.2%
1,822
92.9%
3,613
95.4%
F­
MD
Fail
Government
Debt
Test
0
0.0%
0
0.0%
0
0.0%
F­
HH
Fail
Taxpayers
Test
0
0.0%
0
0.0%
0
0.0%
F­
CS
Fail
Cost
of
Service
32
1.8%
140
7.1%
172
4.6%
Total
1,823
100%
1,962
100%
3,785
100%

m
s
c
r
Municipal
Government
State
Government
County
Government
Regional
Governmental
Authority
Total
Large
Large
Governments
(
population>
50,000)
618
377
781
46
1,823
Small
Small
Governments
(
population
<=
50,000)
1,750
0
212
0
1,962
All
Governments
2,368
377
993
46
3,785
Sum
of
Weight
Direct/
Indirect
size
&
type
D
I
Grand
Total
Largec
23
758
781
Largem
26
592
618
Larger
46
46
Larges
129
248
377
Smallc
212
212
Smallm
280
1,470
1,750
Grand
Total
458
3,327
3,785
February
14,
2003
8
of
28
MuniMPCT_
Final.
xls
­
Summary
Record
for
the
Final
Metal
Product
and
Machinery
Rule
TEST
SUMMARY
Final
Rule
­
Oily
Waste
Directs
(
Option
1)
Proposed/
NODA
(
Option
2)
413
to
433
Upgrade
(
Option
3)
All
433
Upgrade
(
Option
4)

SITE_
ID
MUNI_
ID
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
4
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
17
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
18
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
23
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
30
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
39
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
40
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
93
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
98
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
104
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
117
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
123
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
134
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
139
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
152
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
167
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
171
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
205
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
213
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
218
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
258
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
272
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
277
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
278
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
292
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
311
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
318
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
341
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
346
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
347
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
348
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
360
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
362
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
368
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
379
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
385
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
391
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
394
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
397
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
405
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
427
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
437
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
465
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
467
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
478
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
483
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
485
1
0
0
F­
CS
1
0
0
F­
CS
1
0
0
F­
CS
1
0
0
F­
CS
491
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
499
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
508
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
February
14,
2003
9
of
28
MuniMPCT_
Final.
xls
­
test_
summ
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Size
Weight
Direct/
Indirect
Size&
Type
I
I
D
I
I
D
I
I
I
I
I
I
I
I
I
I
I
I
D
I
I
I
I
D
I
I
I
I
I
I
I
D
I
I
I
I
I
I
I
I
I
I
I
I
I
I
D
I
I
I
February
14,
2003
10
of
28
MuniMPCT_
Final.
xls
­
test_
summ
Record
for
the
Final
Metal
Product
and
Machinery
Rule
TEST
SUMMARY
Final
Rule
­
Oily
Waste
Directs
(
Option
1)
Proposed/
NODA
(
Option
2)
413
to
433
Upgrade
(
Option
3)
All
433
Upgrade
(
Option
4)

SITE_
ID
MUNI_
ID
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
521
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
535
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
541
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
553
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
554
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
557
0
0
0
P
1
0
0
F­
CS
0
0
0
P
1
0
0
F­
CS
558
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
565
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
569
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
571
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
573
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
581
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
582
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
588
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
602
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
646
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
647
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
657
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
672
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
686
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
689
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
691
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
692
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
736
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
743
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
744
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
770
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
783
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
794
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
801
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
803
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
810
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
826
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
827
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
828
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
833
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
845
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
868
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
877
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
878
1
0
0
F­
CS
1
0
0
F­
CS
1
0
0
F­
CS
1
0
0
F­
CS
882
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
890
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
892
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
893
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
895
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
896
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
898
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
900
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
902
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
904
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
February
14,
2003
11
of
28
MuniMPCT_
Final.
xls
­
test_
summ
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Size
Weight
Direct/
Indirect
Size&
Type
I
I
I
I
I
I
D
I
I
I
I
I
I
D
I
I
I
I
I
I
I
I
I
I
D
I
D
D
I
I
I
I
I
I
D
I
I
D
I
D
I
I
I
I
D
I
I
I
I
I
February
14,
2003
12
of
28
MuniMPCT_
Final.
xls
­
test_
summ
Record
for
the
Final
Metal
Product
and
Machinery
Rule
TEST
SUMMARY
Final
Rule
­
Oily
Waste
Directs
(
Option
1)
Proposed/
NODA
(
Option
2)
413
to
433
Upgrade
(
Option
3)
All
433
Upgrade
(
Option
4)

SITE_
ID
MUNI_
ID
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
Cost
of
Service
Test
HH
Afford
Muni
Debt
Pass/
Fail
Size+
Pass/
Fail
906
1
0
0
F­
CS
1
0
0
F­
CS
1
0
0
F­
CS
1
0
0
F­
CS
907
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
908
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
910
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
913
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
915
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
916
0
0
0
P
1
0
0
F­
CS
0
0
0
P
0
0
0
P
917
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
919
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
920
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
923
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
924
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
925
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
928
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
933
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
936
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
937
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
939
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
942
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
952
0
0
0
P
0
0
0
P
0
0
0
P
0
0
0
P
February
14,
2003
13
of
28
MuniMPCT_
Final.
xls
­
test_
summ
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Size
Weight
Direct/
Indirect
Size&
Type
D
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
February
14,
2003
14
of
28
MuniMPCT_
Final.
xls
­
test_
summ
Record
for
the
Final
Metal
Product
and
Machinery
Rule
11
12
13
14
15
4
5
6
7
8
0
0
0
0
Municipal
Facility
Compliance
Costs
1
=
Fail,
0
=
Pass
Fail
Cost
of
Service
Fail
HH
Afford
Fail
Muni
Debt
Joint
No
Pass=
1
SITE_
ID
MUNI_
ID
1
2
3
4
Base
1
2
3
4
Base
1
2
3
4
1
2
3
4
4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
17
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
18
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
23
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
30
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
39
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
40
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
93
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
98
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
104
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
117
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
123
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
134
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
139
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
152
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
167
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
171
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
205
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
213
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
218
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
258
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
272
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
277
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
278
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
292
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
311
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
318
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
341
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
346
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
347
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
348
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
360
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
362
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
368
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
379
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
385
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
391
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
394
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
397
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
405
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
427
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
437
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
465
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
467
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
478
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
483
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
485
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
491
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
499
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
508
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
521
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
535
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
541
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
553
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
February
14,
2003
15
of
28
MuniMPCT_
Final.
xls
­
Tests
Record
for
the
Final
Metal
Product
and
Machinery
Rule
11
12
13
14
15
4
5
6
7
8
0
0
0
0
Municipal
Facility
Compliance
Costs
1
=
Fail,
0
=
Pass
Fail
Cost
of
Service
Fail
HH
Afford
Fail
Muni
Debt
Joint
No
Pass=
1
SITE_
ID
MUNI_
ID
1
2
3
4
Base
1
2
3
4
Base
1
2
3
4
1
2
3
4
554
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
557
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
558
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
565
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
569
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
571
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
573
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
581
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
582
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
588
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
602
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
646
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
647
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
657
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
672
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
686
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
689
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
691
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
692
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
736
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
743
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
744
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
770
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
783
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
794
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
801
0
0
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
803
0
0
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
810
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
826
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
827
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
828
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
833
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
845
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
868
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
877
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
878
1
1
1
1
0
0
0
0
0
1
0
0
0
0
0
0
0
0
882
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
890
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
892
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
893
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
895
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
896
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
898
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
900
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
902
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
904
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
906
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
907
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
908
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
910
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
913
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
915
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
February
14,
2003
16
of
28
MuniMPCT_
Final.
xls
­
Tests
Record
for
the
Final
Metal
Product
and
Machinery
Rule
11
12
13
14
15
4
5
6
7
8
0
0
0
0
Municipal
Facility
Compliance
Costs
1
=
Fail,
0
=
Pass
Fail
Cost
of
Service
Fail
HH
Afford
Fail
Muni
Debt
Joint
No
Pass=
1
SITE_
ID
MUNI_
ID
1
2
3
4
Base
1
2
3
4
Base
1
2
3
4
1
2
3
4
916
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
917
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
919
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
920
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
923
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
924
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
925
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
928
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
933
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
936
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
937
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
939
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
942
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
952
0
0
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
February
14,
2003
17
of
28
MuniMPCT_
Final.
xls
­
Tests
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Municipal
Facility
Compliance
Costs
1996
Dollars,
Cost
Runs
8/
9
0
1
2
3
4
5
6
7
9
10
11
12
Total
Costs
1996
Annualized
Compliance
Cost
Compliance
Cost
Share
of
Baseline
Cost
of
Service
SITE_
ID
MUNI_
ID
&
Expenditures
Option
1
Option
2
Option
3
Option
4
Option
1
Option
2
Option
3
Option
4
691
368
672
657
467
346
139
40
205
292
167
826
17
123
117
362
272
845
318
573
478
557
391
689
803
801
30
554
258
405
508
218
483
571
569
104
277
647
565
341
521
794
394
18
348
171
744
581
878
23
311
379
877
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
18
of
28
MuniMPCT_
Final.
xls
­
CostOfSvc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Municipal
Facility
Compliance
Costs
1996
Dollars,
Cost
Runs
8/
9
0
1
2
3
4
5
6
7
9
10
11
12
Total
Costs
1996
Annualized
Compliance
Cost
Compliance
Cost
Share
of
Baseline
Cost
of
Service
SITE_
ID
MUNI_
ID
&
Expenditures
Option
1
Option
2
Option
3
Option
4
Option
1
Option
2
Option
3
Option
4
93
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
19
of
28
MuniMPCT_
Final.
xls
­
CostOfSvc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Household
Affordability
Test
Per
Household
Post­
Compliance
Total
Cost
Median
HH
Cost
Share
of
Median
Income
MUNI_
ID
PC
BUDGET
Households
Baseline
Option
1
Option
2
Option
3
Option
4
Income
Baseline
Option
1
Option
2
Option
3
Option
4
1
2
3
4
5
6
7
9
10
11
13
14
15
16
17
18
19
20
21
22
24
25
26
27
28
29
30
32
33
34
35
36
38
39
40
41
42
43
44
46
47
48
50
51
52
53
54
55
56
57
58
60
61
February
14,
2003
20
of
28
MuniMPCT_
Final.
xls
­
HH
Afford
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Municipal
Affordability
Test
Cost
of
Debt
Service
as
a
Percent
of
Revenue
MUNI_
ID
Baseline
Option
1
Option
2
Option
3
Option
4
1
2
3
4
5
6
7
9
10
11
13
14
15
16
17
18
19
20
21
22
24
25
26
27
28
29
30
32
33
34
35
36
38
39
40
41
42
43
44
46
47
48
50
51
52
53
54
55
56
57
58
60
61
Total
Cost
of
Debt
Service
Total
Revenues
(
from
all
sources)

February
14,
2003
21
of
28
MuniMPCT_
Final.
xls
­
MuniDebt
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
10
11
12
Municipality
Data
Except
Financials
(
see
MuniFin)

Sample
Weights
from
Helen
Jacobs
7/
26/
99
MUNI
DEMOGRAPHIC
DATA
MUNI_
ID
SHORT
NAME
ID
+
00
SOURCE
STATE
WEIGHT
REG
POP
EMPS(
1996)
YEAR
POPULATION
#
HSHOLDS
1
2
3
4
5
6
7
9
10
11
13
14
15
16
17
18
19
20
21
22
24
25
26
27
28
29
30
32
33
34
35
36
38
39
40
41
42
43
44
46
47
48
50
51
52
53
54
55
56
57
58
60
61
February
14,
2003
22
of
28
MuniMPCT_
Final.
xls
­
MuniData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
Municipality
Data
Except
Financials
(
see
MuniFin)

MUNI_
ID
SHORT
NAME
1
2
3
4
5
6
7
9
10
11
13
14
15
16
17
18
19
20
21
22
24
25
26
27
28
29
30
32
33
34
35
36
38
39
40
41
42
43
44
46
47
48
50
51
52
53
54
55
56
57
58
60
61
13
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
Municipality
Sector
Participation
Data
from
Survey
MED
HH
INC
($)
AERO
AIR
BUS
ELEC
HARD
HOUSE
INSTR
MOB
MOTOR
OFF
ORDN
OTH
PREC
PRINT
RAIL
SHIPS
STAT
February
14,
2003
23
of
28
MuniMPCT_
Final.
xls
­
MuniData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
4
5
6
7
8
9
10
11
12
13
Metal
Products
and
Machinery
Phase
II
Municipality
Survey
Financial
Data
Analysis
MUNICIPALITY
ECONOMIC
AND
FINANCIAL
DATA
FY1996
($
unless
otherwise
specificed)
TOTAL
REVENUES
PROPERTY
REVENUE
PROP
REV
RESIDENTIAL
PROP
REV
COMMERICAL
GRANT
REVENUES
OTHER
REVENUES
OTHER
REV
HOUSEHOLDS
OTHER
REV
COMMERICIAL
OTHER
REV
INDETERMINATE
MARKET
VALUE
TAXABLE
PROPERTY
MARKET
VALUE
RESIDENTIAL
MARKET
VALUE
COMMERCIAL
1
2
3
4
5
6
7
9
10
11
13
14
15
16
17
18
19
20
21
22
24
25
26
27
28
29
30
32
33
34
35
36
38
39
40
41
42
43
44
46
47
48
50
51
52
53
54
55
56
57
58
60
61
MUNI_
ID
February
14,
2003
24
of
28
MuniMPCT_
Final.
xls
­
MuniFin
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
Metal
Products
and
Machinery
Phase
II
Municipality
Survey
Financial
Data
Analysis
1
2
3
4
5
6
7
9
10
11
13
14
15
16
17
18
19
20
21
22
24
25
26
27
28
29
30
32
33
34
35
36
38
39
40
41
42
43
44
46
47
48
50
51
52
53
54
55
56
57
58
60
61
MUNI_
ID
14
15
16
17
18
19
20
21
22
23
TAX
COLLECTION
RATE
(%)
CASH
RESERVES
TOTAL
DEBT
COST
OF
DEBT
SERVICE
ANNUAL
POLLUTION
CONTROL
BUDGET
FINANCED
BY
TAX
REVS
FINANCED
BY
FEE
REVS
FINANCED
BY
OTHER
Residential
Non­
Residential
FEES
CURRENT
(
FY
1996)
POLLUTION
CONTROL
($)

February
14,
2003
25
of
28
MuniMPCT_
Final.
xls
­
MuniFin
Record
for
the
Final
Metal
Product
and
Machinery
Rule
Metal
Products
and
Machinery
Phase
II
Municipality
Survey
Financial
Data
Analysis
Facility
Level
Information
SITE_
ID
SITE
NAME
MUNI_
ID
FACILITY
SECTOR
TOTAL
COSTS
&
EXPENDITURES
DEBT
SERVICE
GENERAL
FUNDS
FEES
FROM
SITE
ACTIVITIES
FEES
FROM
RESIDENTIAL
PAYERS?
ENTITY
SIZE
WEIGHT
GOV'T
TYPE
SIZE&
TYPE
4
17
18
23
30
39
40
93
98
104
117
123
134
139
152
167
171
205
213
218
258
272
277
278
292
311
318
341
346
347
348
360
362
368
379
385
391
394
397
405
427
437
465
467
478
483
485
491
499
508
FACILITY
ECONOMIC
AND
FINANCIAL
DATA
FY1996
($
unless
otherwise
specificed)

Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
26
of
28
MuniMPCT_
Final.
xls
­
FacData
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
6
7
8
9
10
11
12
13
14
15
16
Municipal
Facility
Compliance
Costs
(
1996$)
Final
MP&
M
Rule
Option
1
(
OW
Directs)
Option
2
(
Proposed/
NODA)
Option
3
(
Directs
+
413)
Option
4
(
Directs
+
413
+
Local
Limits)
1996
Social
Cost
SITE_
ID
MUNI_
ID
CapCst1
AnnCst1
CC1_
96
CapCst2
AnnCst2
CC2_
96
CapCst3
AnnCst3
CC3_
96
CapCst4
AnnCst4
CC4_
96
Option
1
Option
2
Option
3
Option
4
4
17
18
23
30
39
40
93
98
104
117
123
134
139
152
167
171
205
213
218
258
272
277
278
292
311
318
341
346
347
348
360
362
368
379
385
391
394
397
405
427
437
465
467
478
483
485
491
499
508
521
535
541
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
27
of
28
MuniMPCT_
Final.
xls
­
Costs
Record
for
the
Final
Metal
Product
and
Machinery
Rule
2001
Annualized
Compliance
Cost
Option
1
Option
2
Option
3
Option
4
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
28
of
28
MuniMPCT_
Final.
xls
­
Costs
