Estimated past 12 months Sewer Trend
Late %
based on # Acct
Prev 12 Mo Sewer customer TaxRolled in
Customer Type Sewer Fee Calculation Qty of Accts % of Acct Avg Amt Per Acct Revenue % of Sewer Revenue Subtotals Type 2021 Category & Consumption based
Commercial - Sewer Only Sewer Charge 0.9% $1,262 $2,969,170 11.2% Based on consumption Category & Consumption based
Commercial - Water & Sewer Sewer Charge 4.5% $2,663,441 10.1% Based on consumption Category, Consumption number of
Government - Sewer Only students based Sewer Charge 14 0.1% $1,426 $239,495 0.9% Based on consumption Category, Consumption number of
Government - Water & Sewer students based Sewer Charge 180 0.8% $370,615 1.4% 81% Based on consumption Flat Fee with consideration for 1,274
Residential - Sewer Only number of housing units 9,279 42.9% $9,006,532 34.1% 30% (13.7%) Flat Fee with consideration for
Residential - Water & Sewer number of housing units 10,968 50.7% $11,147,229 42.2% 29% Flat fee Grand Total 21,628 $26,396,482|
100.0% 100.0% 100%
% of Acct % of Sewer Revenue
Government-
Commercial - Water & _Sewer Only, 0.9%
- Sewer, 4.5%
Commercial - Commercial -
Government - Sewer Government - Water
Sewer Only, 0.9% Sewer Only,
Only, 0.1% & Sewer, 1.4%
Government - Water & 11.2%
Sewer, 0.8%
Commercial -
• Commercial - Sewer Only Water & Sewer, •Commercial - Sewer Only • Commercial - Water & Sewer 10.1% • Commercial - Water & Sewer Government - Sewer Only Residential - Water &
Government - Sewer Only
Sewer, 42.2%
• Government - Water & Sewer I Government - Water & Sewer Residential - Sewer Only • Residential - Sewer Only
Residential - Water & Residential - Sewer Residential - Water & Sewer Residential - Water & Sewer Sewer, 50.7% Residential - Sewer
Only, 42.9% Only, 34.1%
Observations & comments
Even if all accounts are tax rolled, billing still needs to occur in the sytem to show AR balance, recongnize revenue and unearned revenue.
Current Account holder can be tenant and/or property owner. Additional account with property owner's information needs to be created OR each account needs to be updated with property owner.
Current tax roll is collected arrears as delingency. Future tax roll needs to be in advance as tax roll submitted at the beginning of FY will not be fully collected by RWS until full payment is received by the county in Nov and April.
About 1,200 of 21,600 account may have to pay delinquent tax roll and advanced tax roll in the first year of the roll out.