City of Roseville
<br />Water Rate Analysis
<br />2020
<br />Mixe
<br />Personnel Services
<br />Supplies & Maintenance
<br />Other Charges (net of water purchase)
<br />Less Depreciation
<br />Capital Outlay
<br />Total
<br />Single -Family Residential (b)
<br />Multi -Family and Non -Residential
<br />5/8" Meter or 3/4" Meter
<br />1.0" Meter
<br />1.5" Meter
<br />2.0" Meter
<br />3.0" Meter
<br />4.0" Meter
<br />6.0" Meter
<br />Total # of Customers
<br />Attachment B Updated 811619
<br />2020
<br />$ 698,280
<br />162,200
<br />1,026,000
<br />(350,000)
<br />988,800 "Switched to 5-Year CIP amortization in 2019 to better approximate actual cash flow needs
<br />Amount to to recover from BASE rates
<br />Current
<br />Proposed
<br />Current
<br />Proposed
<br /># of
<br />Avg.
<br />Base Fee
<br />% Increase
<br />Base Fee
<br />Fee per
<br />Usage Fee
<br />Fee per
<br />% Increase
<br />Usage Fee
<br />Customers
<br />Usage a
<br />Base Fee
<br />Revenue
<br />Base Fee
<br />decrease
<br />Revenue
<br />1,000 gals.
<br />Revenue
<br />1,000 gals.
<br />decrease
<br />Revenue
<br />9,455
<br />12.45
<br />58.60
<br />554,063
<br />62.10
<br />5.97%
<br />587,156
<br />2.25
<br />264,932
<br />2.30
<br />2.22%
<br />270,820
<br />60
<br />40.63
<br />58.60
<br />3,516
<br />62.10
<br />5.97%
<br />3,726
<br />2.95
<br />7,191
<br />3.00
<br />1.69%
<br />7,313
<br />350
<br />124.36
<br />73.25
<br />25,638
<br />77.65
<br />6.01%
<br />27,178
<br />2.95
<br />128,400
<br />3.00
<br />1.69%
<br />130,577
<br />101
<br />281.04
<br />117.00
<br />11,817
<br />124.00
<br />5.98%
<br />12,524
<br />2.95
<br />83,737
<br />3.00
<br />1.69%
<br />85,157
<br />68
<br />345.79
<br />219.80
<br />14,946
<br />233.00
<br />6.01%
<br />15,844
<br />2.95
<br />69,366
<br />3.00
<br />1.69%
<br />70,542
<br />28
<br />505.63
<br />439.45
<br />12,305
<br />465.80
<br />6.00%
<br />13,042
<br />2.95
<br />41,765
<br />3.00
<br />1.69%
<br />42,473
<br />1
<br />289.00
<br />878.90
<br />879
<br />931.65
<br />6.00%
<br />932
<br />2.95
<br />853
<br />3.00
<br />1.69%
<br />867
<br />1
<br />399.25
<br />1,757.90
<br />1,758
<br />1,863.35
<br />6.00%
<br />1,863
<br />2.95
<br />1,178
<br />3.00
<br />1.69%
<br />1,198
<br />10,064
<br />624,921
<br />662,264
<br />597,423
<br />608,945
<br />Total Annual Revenue 2,499,685
<br />(a) Usage is in thousands of gallons, based on average YEAR -Round usage
<br />(b) As of 11/14/16; 29 households were receiving the discount
<br />2,649,058 2,389,690 2,435,781
<br />Total Costs to Recoup Total Costs to Recoup
<br />Revenue over (under) Costs 123,778 Revenue over (under) Costs 187,181
<br />Total Annual Revenue 2,649,058
<br />Amount Needed for Operations 1,536,480
<br />Amount Available for Capital =Amount to Use on CIP Funding Projections
<br />Allowance
<br />Estimated
<br />For
<br />Estimated
<br />St. Paul
<br />Roseville
<br />Roseville
<br />Consumption
<br />Blended
<br />Unaccounted
<br />Gallons
<br />Estimated
<br />2020 St. Paul Base Rate
<br />Cu Ft Rate
<br />Cu Ft Rate *
<br />Gal. Rate
<br />%
<br />Rate
<br />Water 5%
<br />(1000's)
<br />Cost
<br />Base Rate
<br />0.540
<br />0.567
<br />648,000
<br />Water Rate: Winter
<br />2.917
<br />1.750
<br />1.309
<br />45.0%
<br />0.589
<br />0.619
<br />540,000
<br />706,941
<br />Water Rate: Summer
<br />3.017
<br />1.810
<br />1.354
<br />55.0%
<br />0.745
<br />0.782
<br />660,000
<br />893,660
<br />* Per Amendment #2 to the Contract with
<br />SPRWS,
<br />1.874
<br />1.968
<br />1,200,000
<br />�F amount to recover from USAGE rates
<br />
|