 |
|
~ Water and Sewer Fees as a Result of Lot Reduction ~
Spread Sheet - Page "D" (Current Conditions - No Lot Reductions)
|
|
(1) Build Rate:
|
|
40
|
Lots/year
|
|
(6) Vac. Lot Fees
|
|
71
|
$/Lot
|
|
|
|
(2) Reduction Rate
|
|
28
|
Lots/year
|
|
(7) Current SFRs
|
|
1307
|
|
|
|
|
(3) Occupancy
|
|
1.09
|
SFRs/Lot
|
|
(8) Current Total Lots
|
|
6043
|
|
|
|
|
(4) "Buildable" Lots
|
|
5000
|
|
|
(9) Current Op. Budget
|
|
1,017,280
|
$
|
|
|
|
(5) Reduction Efficiency
|
|
80
|
%
|
|
(10) r:c
|
|
0.7
|
|
|
|
|
|
|
|
|
|
(11) Inflation
|
|
2.0
|
%/year
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(a)
|
(b)
|
(c)
|
(d)
|
(e)
|
(f)
|
(g)
|
(h)
|
(i)
|
(j)
|
(k)
|
|
|
Total
|
|
Dev.
|
Total
|
Buildable
|
Vacant
|
Vac. Lot
|
Vac. Lot
|
Res.
|
Residential
|
|
Year
|
Budget
|
SFRs
|
Lots
|
Lots
|
Lots
|
Lots
|
Fees
|
Income
|
Income
|
Fees/SFR
|
|
|
($)
|
|
|
|
|
|
($/lot)
|
($)
|
($)
|
($/Month)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2000
|
1,017,280
|
1307
|
1199
|
6043
|
5000
|
4844
|
71.00
|
343,918
|
673,362
|
42.93
|
|
2001
|
1,042,731
|
1351
|
1239
|
6015
|
4978
|
4776
|
69.61
|
332,441
|
710,290
|
43.83
|
|
2002
|
1,068,183
|
1394
|
1279
|
5987
|
4955
|
4708
|
68.24
|
321,282
|
746,901
|
44.64
|
|
2003
|
1,093,634
|
1438
|
1319
|
5959
|
4933
|
4640
|
66.90
|
310,433
|
783,201
|
45.39
|
|
2004
|
1,119,086
|
1481
|
1359
|
5931
|
4910
|
4572
|
65.59
|
299,886
|
819,200
|
46.08
|
|
2005
|
1,144,537
|
1525
|
1399
|
5903
|
4888
|
4504
|
64.31
|
289,633
|
854,904
|
46.72
|
|
2006
|
1,169,989
|
1569
|
1439
|
5875
|
4866
|
4436
|
63.05
|
279,667
|
890,322
|
47.30
|
|
2007
|
1,195,440
|
1612
|
1479
|
5847
|
4843
|
4368
|
61.81
|
269,980
|
925,460
|
47.84
|
|
2008
|
1,220,892
|
1656
|
1519
|
5819
|
4821
|
4300
|
60.60
|
260,566
|
960,326
|
48.33
|
|
2009
|
1,246,343
|
1699
|
1559
|
5791
|
4798
|
4232
|
59.41
|
251,417
|
994,927
|
48.79
|
|
2010
|
1,271,795
|
1743
|
1599
|
5763
|
4776
|
4164
|
58.24
|
242,526
|
1,029,268
|
49.21
|
|
2011
|
1,297,246
|
1787
|
1639
|
5735
|
4754
|
4096
|
57.10
|
233,888
|
1,063,358
|
49.60
|
|
2012
|
1,322,697
|
1830
|
1679
|
5707
|
4731
|
4028
|
55.98
|
225,495
|
1,097,203
|
49.96
|
|
2013
|
1,348,149
|
1874
|
1719
|
5679
|
4709
|
3960
|
54.89
|
217,341
|
1,130,808
|
50.29
|
|
2014
|
1,373,600
|
1917
|
1759
|
5651
|
4686
|
3892
|
53.81
|
209,421
|
1,164,180
|
50.60
|
|
2015
|
1,399,052
|
1961
|
1799
|
5623
|
4664
|
3824
|
52.75
|
201,727
|
1,197,325
|
50.88
|
|
2016
|
1,424,503
|
2005
|
1839
|
5595
|
4642
|
3756
|
51.72
|
194,255
|
1,230,249
|
51.14
|
|
2017
|
1,449,955
|
2048
|
1879
|
5567
|
4619
|
3688
|
50.71
|
186,998
|
1,262,957
|
51.38
|
|
2018
|
1,475,406
|
2092
|
1919
|
5539
|
4597
|
3620
|
49.71
|
179,951
|
1,295,455
|
51.61
|
|
2019
|
1,500,858
|
2135
|
1959
|
5511
|
4574
|
3552
|
48.74
|
173,108
|
1,327,749
|
51.82
|
|
2020
|
1,526,309
|
2179
|
1999
|
5483
|
4552
|
3484
|
47.78
|
166,465
|
1,359,844
|
52.01
|
|
2021
|
1,551,761
|
2223
|
2039
|
5455
|
4530
|
3416
|
46.84
|
160,016
|
1,391,745
|
52.18
|
|
2022
|
1,577,212
|
2266
|
2079
|
5427
|
4507
|
3348
|
45.93
|
153,755
|
1,423,457
|
52.34
|
|
2023
|
1,602,664
|
2310
|
2119
|
5399
|
4485
|
3280
|
45.03
|
147,679
|
1,454,985
|
52.49
|
|
2024
|
1,628,115
|
2353
|
2159
|
5371
|
4462
|
3212
|
44.14
|
141,781
|
1,486,334
|
52.63
|
|
2025
|
1,653,566
|
2397
|
2199
|
5343
|
4440
|
3144
|
43.28
|
136,058
|
1,517,508
|
52.76
|
|
2026
|
1,679,018
|
2441
|
2239
|
5315
|
4418
|
3076
|
42.43
|
130,505
|
1,548,512
|
52.87
|
|
2027
|
1,704,469
|
2484
|
2279
|
5287
|
4395
|
3008
|
41.60
|
125,118
|
1,579,351
|
52.98
|
|
2028
|
1,729,921
|
2528
|
2319
|
5259
|
4373
|
2940
|
40.78
|
119,892
|
1,610,029
|
53.08
|
|
2029
|
1,755,372
|
2571
|
2359
|
5231
|
4350
|
2872
|
39.98
|
114,822
|
1,640,550
|
53.17
|
|
2030
|
1,780,824
|
2615
|
2399
|
5203
|
4328
|
2804
|
39.20
|
109,905
|
1,670,919
|
53.25
|
|
2031
|
1,806,275
|
2659
|
2439
|
5175
|
4306
|
2736
|
38.43
|
105,137
|
1,701,138
|
53.32
|
|
2032
|
1,831,727
|
2702
|
2479
|
5147
|
4283
|
2668
|
37.67
|
100,514
|
1,731,213
|
53.39
|
|
2033
|
1,857,178
|
2746
|
2519
|
5119
|
4261
|
2600
|
36.94
|
96,031
|
1,761,147
|
53.45
|
|
2034
|
1,882,630
|
2789
|
2559
|
5091
|
4238
|
2532
|
36.21
|
91,686
|
1,790,944
|
53.50
|
|
2035
|
1,908,081
|
2833
|
2599
|
5063
|
4216
|
2464
|
35.50
|
87,474
|
1,820,607
|
53.55
|
|
2036
|
1,933,532
|
2877
|
2639
|
5035
|
4194
|
2396
|
34.81
|
83,392
|
1,850,141
|
53.60
|
|
2037
|
1,958,984
|
2920
|
2679
|
5007
|
4171
|
2328
|
34.12
|
79,436
|
1,879,548
|
53.64
|
|
2038
|
1,984,435
|
2964
|
2719
|
4979
|
4149
|
2260
|
33.45
|
75,604
|
1,908,831
|
53.67
|
|
2039
|
2,009,887
|
3007
|
2759
|
4951
|
4126
|
2192
|
32.80
|
71,891
|
1,937,996
|
53.70
|
|
2040
|
2,035,338
|
3051
|
2799
|
4923
|
4104
|
2124
|
32.16
|
68,295
|
1,967,043
|
53.73
|
|
2041
|
2,060,790
|
3095
|
2839
|
4895
|
4082
|
2056
|
31.52
|
64,812
|
1,995,978
|
53.75
|
|
2042
|
2,086,241
|
3138
|
2879
|
4867
|
4059
|
1988
|
30.91
|
61,440
|
2,024,801
|
53.77
|
|
2043
|
2,111,693
|
3182
|
2919
|
4839
|
4037
|
1920
|
30.30
|
58,175
|
2,053,518
|
53.78
|
|
2044
|
2,137,144
|
3225
|
2959
|
4811
|
4014
|
1852
|
29.71
|
55,014
|
2,082,130
|
53.80
|
|
2045
|
2,162,596
|
3269
|
2999
|
4783
|
3992
|
1784
|
29.12
|
51,955
|
2,110,641
|
53.80
|
|
2046
|
2,188,047
|
3313
|
3039
|
4755
|
3970
|
1716
|
28.55
|
48,994
|
2,139,053
|
53.81
|
|
2047
|
2,213,499
|
3356
|
3079
|
4727
|
3947
|
1648
|
27.99
|
46,130
|
2,167,368
|
53.82
|
|
2048
|
2,238,950
|
3400
|
3119
|
4699
|
3925
|
1580
|
27.44
|
43,360
|
2,195,590
|
53.82
|
|
2049
|
2,264,401
|
3443
|
3159
|
4671
|
3902
|
1512
|
26.91
|
40,680
|
2,223,722
|
53.82
|
|
2050
|
2,289,853
|
3487
|
3199
|
4643
|
3880
|
1444
|
26.38
|
38,088
|
2,251,765
|
53.81
|
|
2051
|
2,315,304
|
3531
|
3239
|
4615
|
3858
|
1376
|
25.86
|
35,583
|
2,279,721
|
53.81
|
|
2052
|
2,340,756
|
3574
|
3279
|
4587
|
3835
|
1308
|
25.35
|
33,161
|
2,307,595
|
53.80
|
|
2053
|
2,366,207
|
3618
|
3319
|
4559
|
3813
|
1240
|
24.86
|
30,821
|
2,335,387
|
53.79
|
|
2054
|
2,391,659
|
3661
|
3359
|
4531
|
3790
|
1172
|
24.37
|
28,559
|
2,363,100
|
53.78
|
|
2055
|
2,417,110
|
3705
|
3399
|
4503
|
3768
|
1104
|
23.89
|
26,375
|
2,390,736
|
53.77
|
|
2056
|
2,442,562
|
3749
|
3439
|
4475
|
3746
|
1036
|
23.42
|
24,265
|
2,418,297
|
53.76
|
|
2057
|
2,468,013
|
3792
|
3479
|
4447
|
3723
|
968
|
22.96
|
22,227
|
2,445,786
|
53.75
|
|
2058
|
2,493,465
|
3836
|
3519
|
4419
|
3701
|
900
|
22.51
|
20,261
|
2,473,204
|
53.73
|
|
2059
|
2,518,916
|
3879
|
3559
|
4391
|
3678
|
832
|
22.07
|
18,362
|
2,500,554
|
53.71
|
|
2060
|
2,544,367
|
3923
|
3599
|
4363
|
3656
|
764
|
21.64
|
16,531
|
2,527,837
|
53.70
|
|
2061
|
2,569,819
|
3967
|
3639
|
4335
|
3634
|
696
|
21.22
|
14,764
|
2,555,055
|
53.68
|
|
2062
|
2,595,270
|
4010
|
3679
|
4307
|
3611
|
628
|
20.80
|
13,060
|
2,582,210
|
53.66
|
|
2063
|
2,620,722
|
4054
|
3719
|
4279
|
3589
|
560
|
20.39
|
11,418
|
2,609,304
|
53.64
|
|
2064
|
2,646,173
|
4097
|
3759
|
4251
|
3566
|
492
|
19.99
|
9,834
|
2,636,339
|
53.62
|
|
2065
|
2,671,625
|
4141
|
3799
|
4223
|
3544
|
424
|
19.60
|
8,309
|
2,663,316
|
53.60
|
|
2066
|
2,697,076
|
4185
|
3839
|
4195
|
3522
|
356
|
19.22
|
6,839
|
2,690,237
|
53.57
|
|
2067
|
2,722,528
|
4228
|
3879
|
4167
|
3499
|
288
|
18.84
|
5,424
|
2,717,104
|
53.55
|
|
2068
|
2,747,979
|
4272
|
3919
|
4139
|
3477
|
220
|
18.47
|
4,062
|
2,743,917
|
53.53
|
|
2069
|
2,773,431
|
4315
|
3959
|
4111
|
3454
|
152
|
18.11
|
2,751
|
2,770,680
|
53.50
|
|
2070
|
2,798,882
|
4359
|
3999
|
4083
|
3432
|
84
|
17.75
|
1,490
|
2,797,392
|
53.48
|
|
2071
|
2,824,334
|
4403
|
4039
|
4055
|
3410
|
16
|
17.40
|
277
|
2,824,057
|
53.45
|
|
2072
|
2,849,785
|
4446
|
4079
|
4027
|
3387
|
-52
|
17.06
|
-889
|
2,850,674
|
53.43
|
|
2073
|
2,875,236
|
4490
|
4119
|
3999
|
3365
|
-120
|
16.73
|
-2,009
|
2,877,245
|
53.40
|
|
2074
|
2,900,688
|
4533
|
4159
|
3971
|
3342
|
-188
|
16.40
|
-3,085
|
2,903,772
|
53.38
|
|
2075
|
2,926,139
|
4577
|
4199
|
3943
|
3320
|
-256
|
16.08
|
-4,117
|
2,930,257
|
53.35
|
|
2076
|
2,951,591
|
4621
|
4239
|
3915
|
3298
|
-324
|
15.76
|
-5,109
|
2,956,699
|
53.32
|
|
2077
|
2,977,042
|
4664
|
4279
|
3887
|
3275
|
-392
|
15.45
|
-6,059
|
2,983,102
|
53.30
|
|
2078
|
3,002,494
|
4708
|
4319
|
3859
|
3253
|
-460
|
15.15
|
-6,971
|
3,009,465
|
53.27
|
|
2079
|
3,027,945
|
4751
|
4359
|
3831
|
3230
|
-528
|
14.85
|
-7,844
|
3,035,789
|
53.24
|
|
2080
|
3,053,397
|
4795
|
4399
|
3803
|
3208
|
-596
|
14.56
|
-8,681
|
3,062,077
|
53.22
|
|
2081
|
3,078,848
|
4839
|
4439
|
3775
|
3186
|
-664
|
14.28
|
-9,481
|
3,088,329
|
53.19
|
|
2082
|
3,104,300
|
4882
|
4479
|
3747
|
3163
|
-732
|
14.00
|
-10,247
|
3,114,547
|
53.16
|
|
2083
|
3,129,751
|
4926
|
4519
|
3719
|
3141
|
-800
|
13.72
|
-10,979
|
3,140,730
|
53.13
|
|
2084
|
3,155,202
|
4969
|
4559
|
3691
|
3118
|
-868
|
13.45
|
-11,679
|
3,166,881
|
53.11
|
|
2085
|
3,180,654
|
5013
|
4599
|
3663
|
3096
|
-936
|
13.19
|
-12,347
|
3,193,001
|
53.08
|
|
2086
|
3,206,105
|
5057
|
4639
|
3635
|
3074
|
-1004
|
12.93
|
-12,984
|
3,219,090
|
53.05
|
|
2087
|
3,231,557
|
5100
|
4679
|
3607
|
3051
|
-1072
|
12.68
|
-13,592
|
3,245,149
|
53.02
|
|
2088
|
3,257,008
|
5144
|
4719
|
3579
|
3029
|
-1140
|
12.43
|
-14,170
|
3,271,179
|
53.00
|
|
2089
|
3,282,460
|
5187
|
4759
|
3551
|
3006
|
-1208
|
12.19
|
-14,721
|
3,297,181
|
52.97
|
|
2090
|
3,307,911
|
5231
|
4799
|
3523
|
2984
|
-1276
|
11.95
|
-15,245
|
3,323,156
|
52.94
|
|
2091
|
3,333,363
|
5275
|
4839
|
3495
|
2962
|
-1344
|
11.71
|
-15,742
|
3,349,105
|
52.91
|
|
2092
|
3,358,814
|
5318
|
4879
|
3467
|
2939
|
-1412
|
11.48
|
-16,214
|
3,375,029
|
52.88
|
|
2093
|
3,384,266
|
5362
|
4919
|
3439
|
2917
|
-1480
|
11.26
|
-16,662
|
3,400,928
|
52.86
|
|
2094
|
3,409,717
|
5405
|
4959
|
3411
|
2894
|
-1548
|
11.04
|
-17,086
|
3,426,803
|
52.83
|
|
2095
|
3,435,169
|
5449
|
4999
|
3383
|
2872
|
-1616
|
10.82
|
-17,487
|
3,452,655
|
52.80
|
|
 |
