Dynamic Sewer Rate Model
Current Accounts and Revenue Distribution
Hazen
OU ial Tate Ce ECHO Ee
a| | RateClassiD 100%
Servicelype C¥_Period
Al Vv All
RateClassiD
All
Account
RateClassiD First RateName Number of Est Annual Usage Annual Revenue
Accounts
(hase)
R | 0625-inch 23,009 131021 $5,642,476
1c |0625-nch 2,006 307,937 $997,447
3C | inh 344 130,106 $633,066
5C | 15inch 317 236,964 $2,162,247
x | 75-inch 264 65,042 $212.99
aR |075-inch 195 39,539 $140,775
6 | inch 194 253,366 $2,846,106
BOR | Well Users 108 6741 $27,120
1RA | 0625-inch 106 10,140 $4716
3R |1-inch 87 27,583 155,008
sR |1.5-inch 83 38.848 $339,415
7c |3einch 28 224,932 $1,164,014
6 {inch 5 27,532 $178913
7R | inch 9 54118 $361,981
BIC | Well Users 9 461 $1,854
SRA | 15-inch 8 7,820 $64,582
aC |dinch 6 83933 $588,537
% | G:inch 4 116475 $528,149
10C | Bench 1 18,389 $111,992
2k | 075-inch 1 155 $621
aR 1.25-inch 1 6 $2167
Total 0.625-inch 26,749 2,961,262 $16,094,183
Class Season
immer
Al s a me
Winter |
OEE eRe e Dele
@i0C
@1C
OR
@1RA
e2C
O2R
O2RA
Usage
63C 0%
¥
Percent of Revenue by Rate Class ID by Year
RateClassID
@10C
1c
OR
@1RA
1 ke
O2R
@2RA
Annual Total User Charges
2020
Rate Model includes:
¢ Inventory of current accounts by Rate class.
¢ Annual percent usage by Rate class.
¢ Annual percent revenue by Rate class.
¢ Projection of Expenses, including cash and
Capital Improvement Plan debt service.
¢ Breakdown of Operation and Maintenance
costs by expense category and distribution.
¢ Real-time rate change selection.
¢ Impact of rate change to fund balance over
time.
¢ Comparison of rate change impact to EPA
Affordability Index.
