Measuring Water and Sewer Service Affordability

Appendix 4: Data Tables


Metric Inputs and Results (Community Level)
 

Name Households Local MHI Local MHI
(20th
Percentile)
Annual
Water
Costs
EPA
Metric
Alt
Metric
Alt Metric
(20th
Percentile)
EPA to Alt
Difference
EPA to Alt
Difference
(20th
Percentile)
Bloomfield Hills 1296 $169,265 $62,100 $1,000.88 2 0.59 1.61 1.41 0.39
Grosse Pointe Shores
1125
$152,092 $64,056 $1,375.27 2.7 0.9 2.15 1.8 0.55
Huntington Woods
2424
$121,528 $75,695 $1,444.37 2.83 1.19 1.91 1.64 0.92
Bloomfield Township
16707
$118,317 $46,120 $1,287.12 2.48 1.09 2.79 1.39 -0.31
Birmingham
8935
$112,545 $48,932 $1,172.42 2.23 1.04 2.4 1.19 -0.17
Pleasant Ridge
1111
$107,656 $50,318 $1,260.84 2.51 1.17 2.51 1.34 0
Northville Township 11050 $106,288 $41,321 $1,294.16 2.58 1.22 3.13 1.36 -0.55
Grosse Pointe Park
4191
$101,484 $39,739 $668.40 1.35 0.66 1.68 0.69 -0.33
York Township
2432
$99,224 $56,758 No Data - - - - -
Grosse Ile Township
4164
$94,659 $41,139 $1,442.63 3.02 1.52 3.51 1.5 -0.49
West Bloomfield Township
24558
$93,729 $41,699 $969.85 1.94 1.03 2.33 0.91 -0.39
Grosse Pointe Woods
6079
$93,404 $42,309 $1,084.08 2.16 1.16 2.56 1 -0.4
Northville
1146
$90,938 $57,739 $1,277.12 2.58 1.4 2.21 1.18 0.37
Lathrup Village
1553
$90,875 $46,421 $1,345.19 2.5 1.48 2.9 1.02 -0.4
Macomb Township
28610
$89,954 $47,454 $882.53 1.73 0.98 1.86 0.75 -0.13
Troy
31247
$88,954 $38,112 $725.62 1.47 0.82 1.9 0.65 -0.43
Commerce Township
15618
$86,856 $40,433 No Data - - - - -
Orion Township
13294
$86,299 $38,634 $1,143.49 2.09 1.33 2.96 0.76 -0.87
Novi
22862
$86,193 $37,497 $871.16 1.71 1.01 2.32 0.7 -0.61
Canton Township 31785 $84,876 $39,813 $1,262.70 2.45 1.49 3.17 0.96 -0.72
Rochester Hills
28171
$83,507 $37,429 $1,002.76 1.97 1.2 2.68 0.77 -0.71
Washington Township
9923
$82,348 $34,921 $1,235.74 2.41 1.5 3.54 0.91 -1.13
Bruce Township
3140
$81,099 $36,413 $880.99 1.81 1.09 2.42 0.72 -0.61
Plymouth
4113
$78,254 $32,764 $1,132.90 2.18 1.45 3.46 0.73 -1.28
Plymouth Township
10840
$78,060 $36,058 $840.15 1.6 1.08 2.33 0.52 -0.73
Berkley
6528
$74,172 $36,724 $1,194.46 2.34 1.61 3.25 0.73 -0.91
Huron Township
5468
$72,206 $35,312 $1,228.93 2.37 1.7 3.48 0.67 -1.11
Farmington Hills
34726
$71,463 $30,575 $1,307.89 2.58 1.83 4.28 0.75 -1.7
Superior Township
4970
$71,413 $28,590 $538.32 1.07 0.75 1.88 0.32 -0.81
Livonia
37164
$71,063 $33,864 $825.15 1.64 1.16 2.44 0.48 -0.8
Pittsfield Township
13942
$70,463 $30,820 $954.63 1.89 1.35 3.1 0.54 -1.21
Brownstown Township
11077
$70,252 $28,795 $875.21 1.75 1.25 3.04 0.5 -1.29
Berlin Township
3411
$69,855 $32,451 No Data - - - - -
Chesterfield Township
16900
$69,248 $30,719 $907.32 1.73 1.31 2.95 0.42 -1.22
Augusta Township
2293
$68,542 $40,434 $1,537.34 3.01 2.24 3.8 0.77 -0.79
Royal Oak
28526
$68,504 $30,520 $1,400.01 2.57 2.04 4.59 0.53 -2.02
Greenwood Township
538
$67,794 $30,929 No Data - - - - -
Shelby Township
30034
$66,929 $31,813 $1,142.20 2.19 1.71 3.59 0.48 -1.4
Allen Park
10805
$65,848 $31,536 $888.82 1.74 1.35 2.82 0.39 -1.08
Sylvan Lake
799
$65,781 $32,837 $1,159.81 2.22 1.76 3.53 0.46 -1.31
Gaines Township
2561
$65,742 $30,518 $678.61 1.33 1.03 2.22 0.3 -0.89
Farmington
4659
$64,388 $29,935 $1,269.25 2.45 1.97 4.24 0.48 -1.79
Gibraltar
1791
$64,016 $27,458 $1,658.89 3.15 2.59 6.04 0.56 -2.89
Grand Blanc Township
14461
$63,501 $29,243 $1,313.08 2.75 2.07 4.49 0.68 -1.74
Flushing Township
3766
$62,019 $31,338 $1,360.96 2.8 2.19 4.34 0.61 -1.54
Lenox Township
3097
$61,382 $33,727 $1,762.86 3.27 2.87 5.23 0.4 -1.96
Clayton Township
2871
$60,762 $32,175 $1,077.17 2.11 1.77 3.35 0.34 -1.24
Sterling Heights
49754
$60,492 $26,625 $1,014.16 1.92 1.68 3.81 0.24 -1.89
Clawson
5564
$59,259 $28,345 $1,465.39 2.73 2.47 5.17 0.26 -2.44
Woodhaven
5124
$58,500 $26,801 No Data - - - - -
Mundy Township
5935
$57,939 $31,589 $930.63 1.9 1.61 2.95 0.29 -1.05
Harrison Township
11090
$57,673 $24,035 $983.57 1.82 1.71 4.09 0.11 -2.27
Flat Rock
3602
$57,500 $26,687 $658.94 1.29 1.15 2.47 0.14 -1.18
Trenton
7859
$56,888 $25,727 $492.80 0.97 0.87 1.92 0.1 -0.95
Ash Township
3006
$56,055 $24,645 No Data - - - - -
Rockwood
1326
$55,636 $31,034 No Data - - - - -
Sumpter Township
3516
$55,237 $23,938 $1,168.90 2.15 2.12 4.88 0.03 -2.73
Ferndale
9755
$55,159 $25,830 $1,230.97 2.41 2.23 4.77 0.18 -2.36
St. Clair Shores
26717
$54,590 $25,899 $1,331.59 2.55 2.44 5.14 0.11 -2.59
Van Buren Township
11172
$53,872 $28,197 $909.36 1.79 1.69 3.23 0.1 -1.44
Vienna Township
5039
$53,705 $27,620 $1,077.87 2.25 2.01 3.9 0.24 -1.65
Auburn Hills
8934
$53,686 $24,998 $1,127.09 2.24 2.1 4.51 0.14 -2.27
Riverview
5005
$53,502 $21,540 $1,165.75 2.31 2.18 5.41 0.13 -3.1
Burtchville Township
1628
$53,073 $18,900 No Data - - - - -
Fraser
6254
$52,865 $23,263 $1,415.09 2.61 2.68 6.08 -0.07 -3.47
Garden City
10292
$52,788 $24,111 $1,056.90 1.99 2 4.38 -0.01 -2.39
Utica
2255
$51,325 $20,250 No Data - - - - -
Southgate
12563
$51,138 $23,079 $605.32 1.17 1.18 2.62 -0.01 -1.45
Mayfield Township
3058
$50,948 $27,045 No Data - - - - -
Flushing
3410
$50,625 $24,324 $1,358.40 2.69 2.68 5.58 0.01 -2.89
Southfield
32572
$50,371 $20,941 $1,171.81 2.24 2.33 5.6 -0.09 -3.36
Redford Township
17957
$50,129 $23,734 $1,121.18 2.17 2.24 4.72 -0.07 -2.55
Davison Township
8373
$50,127 $24,487 $1,009.10 2.13 2.01 4.12 0.12 -1.99
Oak Park
11657
$49,811 $19,408 $1,338.08 2.49 2.69 6.89 -0.2 -4.4
Clinton Township
43415
$49,637 $21,892 $1,046.23 2.04 2.11 4.78 -0.07 -2.74
Harper Woods
5177
$49,306 $22,691 $747.23 1.45 1.52 3.29 -0.07 -1.84
Montrose Township
2120
$48,966 $26,232 $1,288.17 2.64 2.63 4.91 0.01 -2.27
Dearborn
31279
$48,421 $17,906 $929.04 1.77 1.92 5.19 -0.15 -3.42
Wixom
6103
$47,856 $20,635 $897.81 1.81 1.88 4.35 -0.07 -2.54
Ypsilanti Township
22516
$46,339 $20,673 $861.31 1.71 1.86 4.17 -0.15 -2.46
Dearborn Heights
20547
$45,929 $19,165 $1,264.66 2.44 2.75 6.6 -0.31 -4.16
Belleville
1605
$45,737 $20,452 $1,214.62 2.37 2.66 5.94 -0.29 -3.57
Westland
34188
$44,808 $20,793 $1,169.56 2.26 2.61 5.62 -0.35 -3.36
Romulus
8690
$44,727 $17,587 $873.93 1.71 1.95 4.97 -0.24 -3.26
Swartz Creek
2397
$44,525 $23,615 $1,428.99 2.97 3.21 6.05 -0.24 -3.08
Eastpointe
12323
$44,240 $17,765 $1,641.03 3.08 3.71 9.24 -0.63 -6.16
Warren
53225
$44,017 $20,111 $703.91 1.41 1.6 3.5 -0.19 -2.09
Burton
11581
$43,586 $17,533 $1,655.78 3.38 3.8 9.44 -0.42 -6.06
Keego Harbor
1414
$43,281 $20,377 No Data - - - - -
Madison Heights
13164
$43,158 $18,432 $670.18 1.3 1.55 3.64 -0.25 -2.34
Genesee Township
8240
$43,150 $21,273 $787.19 1.54 1.82 3.7 -0.28 -2.16
Roseville
19690
$42,036 $20,316 $1,055.52 1.97 2.51 5.2 -0.54 -3.23
Taylor
23825
$41,897 $17,824 $681.22 1.37 1.63 3.82 -0.26 -2.45
Lincoln Park
14265
$41,406 $17,168 $799.53 1.55 1.93 4.66 -0.38 -3.11
Flint Township
12837
$41,337 $19,481 $1,263.87 2.48 3.06 6.49 -0.58 -4.01
Wayne
6788
$40,973 $31,536 $1,338.14 2.64 3.27 4.24 -0.63 -1.6
Melvindale
3899
$36,870 $14,257 $1,418.35 2.69 3.85 9.95 -1.16 -7.26
Montrose
642
$36,176 $15,765 $1,520.50 3.09 4.2 9.64 -1.11 -6.55
Center Line
3650
$35,955 $14,504 $918.39 1.73 2.55 6.33 -0.82 -4.6
Mount Morris Township
8263
$33,819 $14,842 $1,299.37 2.69 3.84 8.75 -1.15 -6.06
Hazel Park 7115 $33,379 $14,947 $1,147.02 2.23 3.44 7.67 -1.21 -5.44
Ypsilanti
7987
$33,055 $12,484 $821.38 1.62 2.48 6.58 -0.86 -4.96
Lapeer 3561 $31,805 $31,786 $1,231.63 2.34 3.87 3.87 -1.53 -1.53
Imlay City
1333
$31,287 $18,929 $1,418.40 2.87 4.53 7.49 -1.66 -4.62
Inkster
9477
$31,285 $10,351 $1,230.58 2.29 3.93 11.89 -1.64 -9.6
Pontiac 23225 $30,152 $11,706 $1,412.52 2.81 4.68 12.07 -1.87 -9.26
Royal Oak Township 1063 $27,837 $11,500 $1,258.80 2.36 4.52 10.95 -2.16 -8.59
River Rouge
2825
$27,463 $9,435 $1,098.79 2.09 4 11.65 -1.91 -9.56
Ecorse
3527
$26,496 $11,525 $738.53 1.44 2.79 6.41 -1.35 -4.97
Detroit
256985
$26,249 $9,574 $1,246.51 2.35 4.75 13.02 -2.4 10.67
Flint
40046
$25,650 $9,897 $1,213.53 2.45 4.73 12.26 -2.28 -9.81
Hamtramck
6296
$23,609 $9,818 $1,333.36 2.5 5.65 13.58 -3.15 -11.08
Mount Morris 1183 $21,196 $10,574 $1,702.71 3.52 8.03 16.1 -4.51 -12.58

 

Water and Wastewater Costs (Community Level)

Customer Annual Water Annual Wastewater Annual Total
Allen Park $437.81 $451.02 $888.82
Almont $673.21 $949.97 $1,623.18
Ash Township - - -
Auburn Hills $607.59 $519.50 $1,127.09
Augusta Township $758.76 $778.58 $1,537.34
Belleville $587.96 $626.67 $1,214.62
Berkley $585.67 $608.79 $1,194.46
Berlin Township - - -
Beverly Hills $394.60 $792.10 $1,186.70
Bingham Farms $291.62 $285.78 $577.40
Birmingham $472.54 $699.88 $1,172.42
Bloomfield Hills $553.80 $447.08 $1,000.88
Bloomfield Township $572.31 $714.81 $1,287.12
Brownstown Township $490.32 $384.89 $875.21
Bruce Township $568.99 $312.00 $880.99
Burtchville Township - - -
Burton $1,045.62 $610.16 $1,655.78
Canton Township $593.87 $668.83 $1,262.70
Center Line $347.59 $570.80 $918.39
Chesterfield Township $368.00 $539.32 $907.32
Clawson $496.29 $969.10 $1,465.39
Clayton Township $538.58 $538.58 $1,077.17
Clinton Township $497.58 $548.65 $1,046.23
Commerce Township - - -
Davison Township $742.94 $266.16 $1,009.10
Dearborn $385.24 $543.80 $929.04
Dearborn Heights $565.44 $699.22 $1,264.66
Eastpointe $603.60 $1,037.43 $1,641.03
Ecorse $347.44 $391.09 $738.53
Farmington $572.85 $696.40 $1,269.25
Farmington Hills $679.16 $628.73 $1,307.89
Ferndale $615.49 $615.49 $1,230.97
Flat Rock $329.47 $329.47 $658.94
Flint $710.27 $503.26 $1,213.53
Flint Township $631.94 $631.94 $1,263.87
Flushing $722.44 $635.96 $1,358.40
Flushing Township $890.24 $470.72 $1,360.96
Fraser $439.85 $975.2 $1,415.09
Gaines Township $329.83 $348.78 $678.61
Garden City $399.68 $657.23 $1,056.90
Genesee Township $393.59 $393.59 $787.19
Gibraltar $662.24 $996.65 $1,658.89
Grand Blanc Township $936.22 $376.86 $1,313.08
Greenwood Township - - -
Grosse Ile Township $1,018.66 $423.96 $1,442.63
Grosse Pointe Park $400.80 $267.60 $668.40
Grosse Pointe Shores $687.64 $687.64 $1,375.27
Grosse Pointe Woods $595.44 $488.64 $1,084.08
Hamtramck $487.20 $846.16 $1,333.36
Harper Woods $353.96 $393.27 $747.23
Harrison Township $322.77 $660.81 $983.57
Hazel Park $542.51 $604.50 $1,147.02
Huntington Woods $722.19 $722.19 $1,444.37
Huron Township $548.16 $680.77 $1,228.93
Imlay City $854.40 $564.00 $1,418.40
Inkster $418.43 $812.15 $1,230.58
Keego Harbor - - -
Lapeer $495.97 $735.66 $1,231.63
Lathrup Village $441.37 $903.83 $1,345.19
Lenox Township $585.79 $1,177.08 $1,762.86
Lincoln Park $370.03 $429.49 $799.53
Livonia $439.00 $386.15 $825.15
Macomb Township $441.54 $440.99 $882.53
Madison Heights $318.62 $351.57 $670.18
Mayfield Township - - -
Melvindale $559.37 $858.98 $1,418.35
Montrose $925.40 $595.10 $1,520.50
Montrose Township $832.92 $455.24 $1,288.17
Mount Morris $1,144.80 $557.91 $1,702.71
Mount Morris Township $883.67 $415.70 $1,299.37
Mundy Township $582.03 $348.60 $930.63
New Haven $708.88 $652.87 $1,361.75
Northville $763.35 $513.77 $1,277.12
Northville Township $720.39 $573.77 $1,294.16
Novi $435.58 $435.58 $871.16
Oak Park $451.02 $887.06 $1,338.08
Orion Township $319.32 $824.17 $1,143.49
Pittsfield Township $505.39 $449.24 $954.63
Pleasant Ridge $683.82 $577.02 $1,260.84
Plymouth $502.62 $630.29 $1,132.90
Plymouth Township $336.06 $504.09 $840.15
Pontiac $769.02 $643.50 $1,412.52
Redford Township $509.39 $611.79 $1,121.18
River Rouge $446.43 $652.35 $1,098.79
Riverview $624.06 $541.69 $1,165.75
Rochester Hills $505.50 $497.26 $1,002.76
Rockwood - - -
Romeo $490.09 $724.84 $1,214.93
Romulus $428.16 $445.77 $873.93
Roseville $360.39 $695.12 $1,055.52
Royal Oak $412.18 $987.83 $1,400.01
Royal Oak Township $455.04 $803.76 $1,258.80
Shelby Township $488.13 $654.07 $1,142.20
South Rockwood $592.35 $680.48 $1,272.83
Southfield $486.25 $685.55 $1,171.81
Southgate $272.16 $333.16 $605.32
St. Clair Shores $572.92 $758.67 $1,331.59
Sterling Heights $390.20 $623.96 $1,014.16
Sumpter Township $346.40 $822.50 $1,168.90
Superior Township $297.12 $241.20 $538.32
Swartz Creek $985.92 $443.08 $1,428.99
Sylvan Lake $487.24 $672.57 $1,159.81
Taylor $390.16 $291.06 $681.22
Trenton $246.40 $246.40 $492.80
Troy $432.73 $292.89 $725.62
Utica - - -
Van Buren Township $457.56 $451.80 $909.36
Vienna Township $763.56 $314.31 $1,077.87
Walled Lake $652.29 $485.08 $1,137.37
Warren $401.50 $302.40 $703.91
Washington Township $601.90 $633.83 $1,235.74
Wayne $692.54 $645.60 $1,338.14
West Bloomfield Township $550.44 $419.41 $969.85
Westland $532.07 $637.50 $1,169.56
Wixom $523.23 $374.58 $897.81
Woodhaven - - -
York Township - - -
Ypsilanti $426.17 $395.21 $821.38
Ypsilanti Township $458.62 $402.70 $861.31
Detroit $463.76 $782.75 $1,246.51