5/16/2024
APPENDIX C: WATER RATE DESIGN
TABLE C-1
City of Rialto - 2024 Water and Wastewater Rate Study
Water Rate Design Calculations
898 Note 1: The existing rate structure is:
899 1 - 5 ccf/month $1.07 per cc f
900 6 - 30 ccf/month $1.69 per cc f
901 31 - 60 ccf/month $2.70 per cc f
902 61 or more ccf/month $3.32 per cc f
903
904
905 Monthly 1/1/2025 1/1/2026 1/1/2027 1/1/2028 1/1/2029 906 Minimum Charge Current Rate $ Change Rate $ Change Rate $ Change Rate $ Change Rate $ Change 907 Single Family Residences, Multiple Family Connections, Commercial, Landscape, and Industrial Service Customers 908 1/2 " & 5/8" meter $30.42 $34.53 $4.11 $39.51 $4.98 $42.46 $2.95 $45.63 $3.17 $49.03 $3.40 909 3/4" meter $30.42 $34.53 $4.11 $39.51 $4.98 $42.46 $2.95 $45.63 $3.17 $49.03 $3.40 910 1" meter $44.01 $53.03 $9.02 $60.68 $7.65 $65.21 $4.53 $70.07 $4.86 $75.30 $5.23 911 1 1/2" meter $53.04 $99.28 $46.24 $113.61 $14.32 $122.08 $8.48 $131.19 $9.11 $140.98 $9.79 912 2" meter $152.54 $154.79 $2.25 $177.12 $22.33 $190.33 $13.21 $204.53 $14.20 $219.79 $15.26 913 3" meter $324.45 $302.80 ($21.65) $346.48 $43.68 $372.33 $25.85 $400.10 $27.78 $429.95 $29.85 914 4" meter $550.59 $469.31 ($81.28) $537.01 $67.70 $577.07 $40.06 $620.12 $43.05 $666.38 $46.26 915 6" meter $1,138.62 $931.84 ($206.78) $1,066.26 $134.42 $1,145.81 $79.54 $1,231.28 $85.48 $1,323.14 $91.85 916 8" meter $1,636.17 $1,486.88 ($149.29) $1,701.37 $214.48 $1,828.29 $126.92 $1,964.68 $136.39 $2,111.24 $146.56 917
918 Monthly 1/1/2025 1/1/2026 1/1/2027 1/1/2028 1/1/2029 919 Minimum Charge Current Rate % Change Rate % Change Rate % Change Rate % Change Rate % Change 920 Single Family Residences, Multiple Family Connections, Commercial, Landscape, and Industrial Service Customers 921 1/2 " & 5/8" meter $30.42 $34.53 13.5% $39.51 14.4% $42.46 7.5% $45.63 7.5% $49.03 7.5% 922 3/4" meter $30.42 $34.53 13.5% $39.51 14.4% $42.46 7.5% $45.63 7.5% $49.03 7.5% 923 1" meter $44.01 $53.03 20.5% $60.68 14.4% $65.21 7.5% $70.07 7.5% $75.30 7.5% 924 1 1/2" meter $53.04 $99.28 87.2% $113.61 14.4% $122.08 7.5% $131.19 7.5% $140.98 7.5% 925 2" meter $152.54 $154.79 1.5% $177.12 14.4% $190.33 7.5% $204.53 7.5% $219.79 7.5% 926 3" meter $324.45 $302.80 -6.7% $346.48 14.4% $372.33 7.5% $400.10 7.5% $429.95 7.5% 927 4" meter $550.59 $469.31 -14.8% $537.01 14.4% $577.07 7.5% $620.12 7.5% $666.38 7.5% 928 6" meter $1,138.62 $931.84 -18.2% $1,066.26 14.4% $1,145.81 7.5% $1,231.28 7.5% $1,323.14 7.5% 929 8" meter $1,636.17 $1,486.88 -9.1% $1,701.37 14.4% $1,828.29 7.5% $1,964.68 7.5% $2,111.24 7.5% 930
05162024 2024 Updates Rialto Rate Model
C1WaterRateDesign
FG Solutions, LLC
Copyright 2024 All Rights Reserved
5/16/2024
APPENDIX C: WATER RATE DESIGN
TABLE C-1
City of Rialto - 2024 Water and Wastewater Rate Study
Water Rate Design Calculations
931
932 1/1/2025 1/1/2026 1/1/2027 1/1/2028 1/1/2029
933 Volume Charge, $/ccf Current Rate $ Change Rate $ Change Rate $ Change Rate $ Change Rate $ Change 934 All Customers Except those Noted Below
935 0 - 9 cc f $1.95 $2.20 $0.25 $2.36 $0.16 $2.54 $0.18 $2.73 $0.19 936 10 - 30 cc f $2.19 $2.47 $0.28 $2.66 $0.18 $2.85 $0.20 $3.07 $0.21 937 >31 cc f $3.19 $3.62 $0.42 $3.89 $0.27 $4.18 $0.29 $4.49 $0.31 938
939 Multiple Apartments
940 Over 49 Units and Mobile Homes $2.40 $2.35 ($0.05) $2.66 $0.30 $2.86 $0.20 $3.07 $0.21 $3.30 $0.23 941
942 Landscape
943 0 - 30 cc f $2.70 $2.19 ($0.51) $2.47 $0.28 $2.66 $0.18 $2.85 $0.20 $3.07 $0.21 944 >31 cc f $3.32 $3.19 ($0.13) $3.62 $0.42 $3.89 $0.27 $4.18 $0.29 $4.49 $0.31 945
946 1/1/2025 1/1/2026 1/1/2027 1/1/2028 1/1/2028
947 Volume Charge, $/cc
f Current Rate % Change Rate % Change Rate % Change Rate % Change Rate % Change 948 All Customers Except those Noted Below
949 0 - 9 cc f $1.95 $2.20 12.6% $2.36 7.5% $2.54 7.5% $2.73 7.5% 950 10 - 30 cc f $2.19 $2.47 12.8% $2.66 7.5% $2.85 7.5% $3.07 7.5% 951 >31 cc f $3.19 $3.62 13.3% $3.89 7.5% $4.18 7.5% $4.49 7.5% 952
953 Multiple Apartments
954 Over 49 Units and Mobile Homes $2.40 $2.35 -1.9% $2.66 12.9% $2.86 7.5% $3.07 7.5% $3.30 7.5% 955
956 Landscape
957 0 - 30 cc f $2.70 $2.19 -18.8% $2.47 12.8% $2.66 7.5% $2.85 7.5% $3.07 7.5% 958 >31 cc f $3.32 $3.19 -3.8% $3.62 13.3% $3.89 7.5% $4.18 7.5% $4.49 7.5% 05162024 2024 Updates Rialto Rate Model
C1WaterRateDesign
FG Solutions, LLC
Copyright 2024 All Rights Reserved
5/16/2024
2024 Water and Wastewater Rate Study – City of Rialto
1 05162024 RIALTO Water and Wastewater Rate Study Report Appendix D: Wastewater Cost of Service Analysis
APPENDIX D: WASTEWATER COST-OF-SERVICE ANALYSIS
City of Rialto - 2024 Water and Wastewater Rate Study
Wastewater Cost-of-Service Analysis Tables
TABLE D-1
Wastewater COSA - Functionalization Factors
System Function
Line Functionalization Direct Assign Direct Assign Math No. Factors Total Treatment Collection Customer Admin Commercial RNHC Check Notes 1 Direct: Treatment 100.0% 100.0% TRUE Direct: Treatment 2 Direct: Collection 100.0% 100.0% TRUE Direct: Collection 3 Direct: Customer 100.0% 100.0% TRUE Direct: Customer 4 Direct: Admin 100.0% 100.0% TRUE Direct: Admin
5 Direct: Commercial 100.0% 100.0% TRUE Direct: Commercial 6 Direct: RHNC 100.0% 100.0% TRUE Direct: RHNC
7 Direct: Master Plan 100.0% 50.0% 50.0% TRUE Direct: Master Plan 8 Net Plant: % (1) 100.0% 77.0% 23.0% 0.0% 0.0% 0.0% TRUE Net Plant 9 Capital Charge: % (2) 100.0% 39.3% 5.7% 0.0% 55.0% 0.0% TRUE Capital Charge 10 WIFIA/I-Bank Debt Service 100.0% 28.6% 65.5% 0. 0% 0.0% 0.0% 5.9% TRUE New Debt Service 11 W2 Wage $, Use to Define Labor Functionalization Factor $1,594,673 $536,238 $185,708 FALSE 12 Labor: % PLACEHOLDER (4) 100.0% 68.8% 23.1% 8.0% 0.0% 0.0% TRUE Labor 13 Electricity, Amount (5) $934,497 $890,301 $44,196 FALSE 14 Electricity, Percentage 100.0% 95.3% 4.7% 0.0% 0.0% 0.0% 0.0% TRUE Electricity 15 Indirect: Per Rate Revenue Requirement, P 100.00% 48.9% 12.1% 1.1% 38.0% 0.4% -0.5% FALSE Rate Revenue Requirement Notes for Tables D-1 through D-5
(1) Refer to Table COS-2
(2) Refer to Table COS-3
(3) Refer to Table COS-3
(4) Refer to Table COS-10
(5) Based on a review of SCE power bills from CY 2022. Data provided by Veolia via City staff.
TABLE D-2
Wastewater COSA - Functionalization of Wastewater System Plant System Function
Line Direct Assign
No. Total Treatment Collection Customer Admin Commercial 1 Total $92,186,291 $71,017,395 $21,168,896 $0 $0 $0
2 As Percent 100.00% 77.04% 22.96% 0.00% 0.00% 0.00%
Source: City of Rialto 2022 Fixed Asset Data
05162024 2024 Updates Rialto Rate Model D1-D8
FG Solutions, LLC
Copyright 2024 All Rights Reservved
Printed: 5/16/2024
APPENDIX D: WASTEWATER COST-OF-SERVICE ANALYSIS
City of Rialto - 2024 Water and Wastewater Rate Study
Wastewater Cost-of-Service Analysis Tables
TABLE D-3
Wastewater COSA - Functionalization of CIP by Percentage System Function
Line Direct Assign Direct Assign
No. Total Treatment Collection Customer Admin Commercial RHNC 1 Sycamore Sewer Upsize 1 (3) $5,000,000 100.0%
2 Acacia Sewer Upsize 1 $2,000,000 100.0%
3 Digester No. 1 Activation & Digester No. 2 $1,800,000 100.0% 4 Rialto Biosolids Project (4) $25,946,000 100.0%
5 Agua Mansa Lift Station Upgrades $2,000,000 100.0%
6 P5 SEC 1 & 2 Upgrades $500,000 100.0%
7 Ayala Lift Station Upgrade & Repair $2,000,000 100.0% 8 Rialto WWTP Electrical Upgrade for Micro g $8,800,000 100.0% 9 Rialto Habitat Nature Center $3,000,000 100.0%
TABLE D-4
Wastewater COSA - Functionalization of CIP by Dollar Amount System Function
Line Direct Assign Direct Assign
No. Total Treatment Collection Customer Admin Commercial RHNC 2 Sycamore Sewer Upsize 1 (3) $5,000,000 $0 $5,000,000 $0 $0 $0 $0 3 Acacia Sewer Upsize 1 $2,000,000 $2,000,000 $0 $0 $0 $0 $0 4 Digester No. 1 Activation & Digester No. 2 $1,800,000 $1,800,000 $0 $0 $0 $0 $0 5 Rialto Biosolids Project (4) $25,946,000 $0 $25,946,000 $0 $0 $0 $0 6 Agua Mansa Lift Station Upgrades $2,000,000 $2,000,000 $0 $0 $0 $0 $0 12 P5 SEC 1 & 2 Upgrades $500,000 $0 $500,000 $0 $0 $0 $0 16 Ayala Lift Station Upgrade & Repair $2,000,000 $0 $2,000,000 $0 $0 $0 $0 24 Rialto WWTP Electrical Upgrade for Micro
g $8,800,000 $8,800,000 $0 $0 $0 $0 $0
25 Rialto Habitat Nature Center $3,000,000 $0 $0 $0 $0 $0 $3,000,000 32 Total $51,046,000 $14,600,000 $33,446,000 $0 $0 $0 $3,000,000 As Percent 94% 29% 66% 0% 0% 0% 6%
05162024 2024 Updates Rialto Rate Model D1-D8
FG Solutions, LLC
Copyright 2024 All Rights Reservved
Printed: 5/16/2024
APPENDIX D: WASTEWATER COST-OF-SERVICE ANALYSIS
City of Rialto - 2024 Water and Wastewater Rate Study
Wastewater Cost-of-Service Analysis Tables
TABLE D-5
Wastewater COSA - Functionalization of Capital Charge
System Function
Line Component of Concession Funding
Total Capitalized
Amount (1) (2) Treatment Collection Customer Admin
Direct Assign
Commercial Total
1 Wastewater Capital Projects
2 S1 WWTP Improvements $26,768,554 100% 100%
3 S2 - S6 Sewer Main Replacement $31,230 100% 100%
4 S7 - WWTP FOG Modifications $0 100% 100%
5 SA - Manhole Rehabilitation $576,534 100% 100%
6 SB - Main Cleaning and Lining $0 100% 100%
7 SC - Studies $0 100% 100%
8 S1.1 - Digester 1 $384,020 100% 100%
9 S8 - Emergency Repairs at WWTP $305,662 100% 100%
10 Rate Stabilization Fund $26,097,000 100% 100% Direct Allocation to Administration 11 Lease Payment $25,000,000 100% 100% Direct Allocation to Administration 12 Refinance Existing Debt, as net plant $24,111,000 77.0% 23.0% 0.0% 0.0% 0.0% 100% As Net Plant 13 Trustee Reserves (3) $9,481,000 100% 100% Direct Allocation to Administration 14 Debt Service Reserves $4,236,000 77.0% 23.0% 0.0% 0.0% 0.0% 100% As Net Plant 15 Due Diligence/Transition Costs (4) $8,509,000 100% 100% Direct Allocation to Administration 16 Costs of Issuance (5) $7,933,000 39.3% 5.7% 0.0% 55.0% 0.0% 100% Weighted Average of All Other Items 17 Total $133,433,000 $52,411,914 $7,567,016 $0 $73,454,069 $0 18 As Percent 39.3% 5.7% 0.0% 55.0% 0.0%
Notes:
(1) Source: Staff report to March 12, 2012 Council Meeting, Table 2, except Capital Improvements, described in Note 2. (2) Capital Project funding per City's 2023 analysis of Facility Improvement Plan actual spending. FIP spending presented at 4/11/23 Council Meeting.
FIP spending is $35,000 lower than shown in the 2012 Staff Report. (3) Consists of Working Capital, Operating R&R account capitalization, and a reserve held by the Trustee. (4) Includes Technical, Due Diligence, and Commercial Development Costs, and Transition Costs (5) Includes development and financing costs of issuance, underwriter's discount 05162024 2024 Updates Rialto Rate Model D1-D8
FG Solutions, LLC
Copyright 2024 All Rights Reservved
Printed: 5/16/2024
APPENDIX D: WASTEWATER COST-OF-SERVICE ANALYSIS
City of Rialto - 2024 Water and Wastewater Rate Study
Wastewater Cost-of-Service Analysis Tables
TABLE D-6
Wastewater COSA - Functionalization of Rate Revenue Requirement Line System Function Table B-1
No. FY 24/25 Total Treatment Collection Customer Admin
Direct Assign
Commercial
Direct Assign
RHNC
Line No.
Reference
Functional-
ization Factor
1 Waterfall 1: Water Service Fee
2 Fixed Component $2,796,482 $2,154,321 $642,161 $0 $0 $0 $0 8 Net Plant 3 Routine R&R Component $287,097 $221,170 $65,927 $0 $0 $0 $0 8 Net Plant 4 Chemical Component $1,350,000 $1,350,000 $0 $0 $0 $0 $0 1 Direct: Treatment 5 Labor Component $4,037,000 $2,778,918 $934,462 $323,620 $0 $0 $0 12 Labor 6 Waterfall 1: Reimbursements
7 Insurance Reimbursement $1,038,000 $799,642 $238,358 $0 $0 $0 $0 8 Net Plant 8 Independent Engineer $118,000 $46,350 $6,692 $0 $64,958 $0 $0 9 Capital Charge 9 Maintenance $300,000 $231,110 $68,890 $0 $0 $0 $0 8 Net Plant 10 Waterfall 1: Retained RUA Expenses
11 Electricity $1,200,000 $1,143,247 $56,753 $0 $0 $0 $0 14 Electricity 12 Gas $104,000 $104,000 $0 $0 $0 $0 $0 1 Direct: Treatment 13 Contracted Services
14 City Contract (Transfer to General Fun $710,000 $0 $0 $0 $710,000 $0 $0 4 Direct: Admin 15 Biosolids $1,194,000 $1,194,000 $0 $0 $0 $0 $0 1 Direct: Treatment 16 City Reimbursement (680 Admin) $1,112,000 $0 $0 $0 $1,112,000 $0 $0 4 Direct: Admin 17 Consulting Services $500,000 $0 $0 $0 $500,000 $0 $0 4 Direct: Admin 1 8 C o n s u l t i n g S W R C B G r a n t B D P $ 0$ 0$ 0$ 0$ 0$ 0$ 0 4 D i r e c t : A d m i n 19 Consulting CEQA for Micro Grid $0 $0 $0 $0 $0 $0 $0 1 Direct: Treatment 2 0 C o n s u l t i n g A u d i t o r $ 0$ 0$ 0$ 0$ 0$ 0$ 0 4 D i r e c t : A d m i n 21 IT Services: Tyler and Paymentus $136,000 $0 $0 $0 $136,000 $0 $0 4 Direct: Admin 22 Other Services and Supplies
2 3 R i a l t o H a b i t a t N a t u r e C e n t e r O & M $ 0$ 0$ 0$ 0$ 0$ 0$ 0 4 D i r e c t : A d m i n 24 Other Retained Services $500,000 $0 $0 $0 $500,000 $0 $0 4 Direct: Admin 25 Inland Empire Brine Line Fees (SBVM
W $92,490 $92,490 $0 $0 $0 $0 $0 1 Direct: Treatment
26 Wastewater Services (Colton) $9,583 $0 $0 $0 $9,583 $0 $0 4 Direct: Admin 27 MIPP Services (Veolia) $134,000 $0 $0 $0 $0 $134,000 $0 5 Direct: Commercial 28 Waterfall 2: Annual Operating R&R Pmt $930,000 $0 $930,000 $0 $0 $0 $0 2 Direct: Collection 29 Waterfall 3: Capital Charges
30 Amount $12,682,000 $4,981,436 $719,199 $0 $6,981,365 $0 $0 9 Capital Charge 32 New Capital Charges 0 $0 $0 $0 $0 $0 $0 10 New Debt Service 33 Waterfall 4: RWS Water Reserve Account
D 456,159 $0 $0 $0 $456,159 $0 $0 4 Direct: Admin
34 Waterfall 5: RUA Lease Payment $1,600,000 $0 $0 $0 $1,600,000 $0 $0 4 Direct: Admin 05162024 2024 Updates Rialto Rate Model D1-D8
FG Solutions, LLC
Copyright 2024 All Rights Reservved
Printed: 5/16/2024
APPENDIX D: WASTEWATER COST-OF-SERVICE ANALYSIS
City of Rialto - 2024 Water and Wastewater Rate Study
Wastewater Cost-of-Service Analysis Tables
35 Less Non-Rate Revenues
3 6 F i n e s / F o r f e i t u r e s / P e n a l t i e s $ 0$ 0$ 0$ 0$ 0$ 0$ 0 4 D i r e c t : A d m i n 37 Rents and Concessions (Anaergia Lease) ($279,000) ($279,000) $0 $0 $0 $0 $0 1 Direct: Treatment 38 Trustee Interest Income ($269,500) $0 $0 $0 ($269,500) $0 $0 4 Direct: Admin 39 Delinquent Sewer Service Fees ( $15,315) $0 $0 $0 ($15,315) $0 $0 4 Direct: Admin 40 Grants $0 $0 $0 $0 $0 $0 $0 1 Direct: Treatment
41 Effluent Sale to IEUA ($144,375) $0 $0 $0 $0 $0 ($144,375) 6 Direct: RHNC 42 Less Interest Income on RUA Reserves ($269,642) $0 $0 $0 ($269,642) $0 $0 4 Direct: Admin 43 Plus Change Reserve Balances (1,080,987) ($528,481) ($130,623) ($11,542) ($410,711) ($4,779) $5,149 15 Rate Revenue Requirement 44 Total $29,227,992 $14,289,203 $3,531,819 $312,078 $11,104,897 $129,221 ($139,226) 45 46 Compare With Operating Statement $29,227,992
TABLE D-7
Wastewater COSA - Allocation of Rate Revenue Requirement TY FY 24/25 Total $
Line Total ($) Flow BOD TSS Customer Direct: CIII,CI V Flow BOD TSS Customer Direct: CIII,CI V 1 Treatment $14,289,203 4,763,068 4,763,068 4,763,068 0 0 33.3% 33.3% 33.3% 0.0% 0.0% 2 Collection $3,531,819 3,531,81 90000 100.0% 0.0% 0.0% 0.0% 0.0% 3 Customer $312,078000 312,078 0 0.0% 0.0% 0.0% 100.0% 0.0% 4 Administration $11,104,897 4,997,368 2,918,562 2,918,562 191,225 79,180 45.0% 26.3% 26.3% 1.7% 0.7% 5 Direct Assign: Commercial III and IV $129,2210000 129,221 0.0% 0.0% 0.0% 0.0% 100.0% 6 Direct Assign: RNHC ($139,226) (139,226) 0000 100.0% 0.0% 0.0% 0.0% 0.0% 7 Total Rate Revenue Requirement $29,227,992 $13,153,028 $7,681,630 $7,681,630 $503,303 $208,401 8 9 Adj. for Fontana Extraterritorial Revenue ($2,008,479) ($903,845) ($527,863) ($527,863) ($34,586) ($14,321) 10 Rate Rev. Req. from City Direct Customers $27,219,513 $12,249,183 $7,153,766 $7,153,766 $468,717 $194,080 11 12 Adjustment for Full Year Implementation $792,521 $356,646.29 $208,288.51 $208,288.51 $13,647.14 $5,650.82 13 Full Year Implementation Rev Req $28,012,035 $12,605,830 $7,362,055 $7,362,055 $482,365 $199,731 Methodology: Extraterritorial customers are not part of the City's billing data, and therefore the billing determinants (flow, BOD, TSS, number of customers) are not available from the City.
The extraterritorial revenue is subtracted so this table contains an allocated Rate Revenue Requirement from City direct customers. 05162024 2024 Updates Rialto Rate Model D1-D8
FG Solutions, LLC
Copyright 2024 All Rights Reservved
Printed: 5/16/2024
APPENDIX D: WASTEWATER COST-OF-SERVICE ANALYSIS
City of Rialto - 2024 Water and Wastewater Rate Study
Wastewater Cost-of-Service Analysis Tables
TABLE D-8
Wastewater COSA - Distribution of Rate Revenue Requirement FY 24/25 FY 24/25
Full Year Full Year
Direct: Implementatio nmplementation No. of Billing
Line Flow BOD TSS Customer C III, C I V Total ($) As Percent Determinants 1 Rate Revenue Requirement $12,605,830 $7,362,055 $7,362,055 $482,365 $199,731 $28,012,035 2U n i t s o f S e r v i c e 28,012,035 100.00%
3 Amount (1) 3,400,386 7,813,429 7,660,797 20,639 184,695 4 Units hcf Sewer Flow lbs lbs accounts C III, C IV hcf 5 Unit Cost-of-Service, $/unit
6 Unadjusted $3.71 $0.94 $0.96 $23.37 $1.08
7 8 Allocation to Customers
9 Residential 1.3X
10 Units of Service 12,872 34,203 34,203 138 0 .
1 1 P e r c e n t a g e o f S e r v i c e 0 %0 %0 %1 %0 % 12 Cost of Service $47,717 $32,227 $32,870 $3,221 $0 $116,035 0.41% 13 14 Residential, Combined SF and MFR
15 Units of Service 2,514,720 6,386,440 6,386,440 19,659 $0 16 Percentage of Service 74% 82% 83% 95% 0%
17 Cost of Service $9,322,508 $6,017,501 $6,137,393 $459,457 $0 $21,936,859 26,923 18 19 Commercial, Group II
20 Units of Service 599,336 561,121 561,121 539
21 Percentage of Service 18% 7% 7% 3% 0%
22 Cost of Service $2,221,844 $528,705 $539,239 $12,586 $0 $3,302,374 11.79% 599,336 23 24 Commercial, Group III
25 Units of Service 78,474 146,940 146,940 160 78,474
2 6 P e r c e n t a g e o f S e r v i c e 2 %2 %2 %1 % 4 2 % 27 Cost of Service $290,917 $138,452 $141,210 $3,728 $84,862 $659,169 2.35% 78,474 28 29 Commercial, Group IV
30 Units of Service 106,221 596,689 464,092 134 106,221 3 1 P e r c e n t a g e o f S e r v i c e 3 %8 %6 %1 % 5 8 % 32 Cost of Service $393,781 $562,219 $445,994 $3,140 $114,869 $1,520,002 5.43% 106,221 33 34 Schools, S1 and S4
35 Units of Service 21,216 17,214 13,242
36 Percentage of Service 0.6% 0.2% 0.2%
37 Cost of Service $78,650 $16,220 $12,725 $107,595 0.38% 38 39 Schools, S2
40 Units of Service 63,666 51,659 39,737
41 Percentage of Service 1.9% 0.7% 0.5%
05162024 2024 Updates Rialto Rate Model D1-D8
FG Solutions, LLC
Copyright 2024 All Rights Reservved
Printed: 5/16/2024
APPENDIX D: WASTEWATER COST-OF-SERVICE ANALYSIS
City of Rialto - 2024 Water and Wastewater Rate Study
Wastewater Cost-of-Service Analysis Tables
42 Cost of Service $236,020 $48,674 $38,188 $322,883 1.15% 43 44 Sewer - Commercial II X 1.3
45 Units of Service 565 529 529 4
46 Percentage of Service 0.0% 0.0% 0.0% 0.0%
47 Cost of Service $2,096 $499 $509 $93 $3,197 0.01%
48 49 Sewer - Commercial IV X 1.3
50 Units of Service 3,317 18,633 14,492 6
51 Percentage of Service 0.1% 0.2% 0.2% 0.0%
52 Cost of Service $12,297 $17,557 $13,927 $140 $43,921 0.16% 53 54 Total 3,400,386 7,813,429 7,660,797 20,639 184,695 05162024 2024 Updates Rialto Rate Model D1-D8
FG Solutions, LLC
Copyright 2024 All Rights Reservved
Printed: 5/16/2024
2024 Water and Wastewater Rate Study – City of Rialto
1 05162024 RIALTO Water and Wastewater Rate Study Report Appendix E: Wastewater Rate Design
APPENDIX E: WASTEWATER RATE DESIGN
TABLE E-1
City of Rialto - 2024 Water and Wastewater Rate Study
Wastewater Rate Design Calculations
1 1. Key Sewer Rate Design Assumptions
2 People per Household, Residential 3.86 https://www.census.gov/quickfacts/fact/table/rialtocitycalifornia/PST045222 3 Applicable to Single-Family Residential and Multi-Family Residential, 4 per policy direction from City staff 11/15/23
5 Per capita BOD, lb/d 0.17
6 Per capita TSS, lb/d 0.17
7 How Water Conservation Trends Are Challenging Wastewater Treatment Facility Design Standards - Integrated Water Services 8 https://www.climate-policy-watcher.org/wastewater-treatment-3/population-equivalent-or-unit-loading-factor.html; Ten States Standards (2013 Version 9 10
11 12 2. Compile CY 2022 Monthly Sewer Revenues
13 14 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 15 Rate Code Jan Feb Ma
r Apr May June July Aug Sept Oct Nov Dec Total
16 SC2 $318,807 $308,696 $314,688 $343,731 $335,986 $332,990 $378,446 $352,293 $347,744 $374,071 $336,790 $313,264 $4,057,506 17 SC3 $55,588 $48,547 $47,929 $54,648 $57,766 $49,356 $58,513 $48,244 $51,841 $60,773 $45,572 $45,876 $624,652 18 SC4 $86,898 $77,308 $74,444 $93,742 $86,821 $84,010 $105,730 $85,649 $97,867 $120,474 $91,197 $76,130 $1,080,270 19 SNB $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
20 SR1 $1,175,880 $1,179,411 $1,179,774 $1,178,888 $1,178,764 $1,179,278 $1,178,696 $1,181,211 $1,181,860 $1,182,964 $1,182,255 $1,182,303 $14,161,283 21 SR2 $11,140 $11,140 $11,140 $11,140 $11,140 $11,140 $11,140 $11,137 $11,148 $11,140 $11,140 $11,140 $133,682 22 SR3 $493,710 $493,444 $493,706 $493,728 $493,621 $493,480 $493,664 $493,664 $493,664 $493,695 $499,311 $495,211 $5,930,899 23 SR4 $124 $124 $174 $124 $187 $187 $187 $187 $187 $187 $187 $187 $2,040 24 SR5 $560 $560 $560 $560 $560 $560 $560 $560 $560 $560 $560 $560 $6,717 25 SR6 $1,351 $1,351 $1,351 $1,351 $1,351 $1,351 $1,351 $1,351 $1,351 $1,351 $1,351 $1,351 $16,209 26 SS1 $6,412 $6,412 $6,412 $6,412 $6,412 $6,412 $6,412 $6,412 $6,412 $6,412 $6,268 $6,308 $76,691 27 SS2 $21,699 $21,699 $21,699 $21,699 $21,699 $21,699 $21,699 $21,699 $21,699 $21,699 $21,699 $19,108 $257,794 28 SS4 $430 $430 $430 $430 $430 $430 $430 $430 $430 $430 $430 $328 $5,059 29 SX2 $427 $399 $391 $408 $401 $408 $435 $443 $383 $461 $419 $401 $4,976 30 SX4 $3,148 $3,280 $2,580 $3,399 $4,060 $4,323 $6,690 $4,138 $2,844 $3,743 $3,175 $2,474 $43,855 31 Total $2,176,173 $2,152,801 $2,155,275 $2,210,259 $2,199,196 $2,185,623 $2,263,950 $2,207,417 $2,217,989 $2,277,957 $2,200,351 $2,154,640 $26,401,632 32 33
34 Methodology/Source:
35 1. Use file Billing With Consumption July 2022 to Dec 2022, and Billing With Consumption Jan 2022 to Jun 2022; provided by Veolia (R Lee) on 6/16/23. 36 2. Pivot table:
37 rows: Bill Code
38 Columns: C_Year, C_Month, C_BillDesc, SumValue
s
39 Data: Sum of Y_Charge s
40 41
05162024 2024 Updates Rialto Rate Model
E1WWRateDesign
FG Solutions, LLC
Copyright 2024 All Rights Reservved
5/16/2024
APPENDIX E: WASTEWATER RATE DESIGN
42 3. CY 22 Number of Billing Determinants
43 44 CY 2022 Number of Billing Determinants Based on Revenues 45 Current Number o f Interim Data:
46 Rate CY 22 Sewe r Residential Avg CY 22 No. of Students 47 Rate Code Description Code Revenues Rate Units Flow, cc f Units Bills # of Accounts Pupil Months 48 Sewer - Residential SR1 14,161,283 $62.19 $/mo/unit 18,976 18,976 49 Sewer - Residential X 1.3 SR2 133,682 $80.84 $/mo/unit 138 138 50 Sewer - Residential Multi. SR3 5,930,899 $62.19 $/mo/unit 7,947 683 54 Sewer - Commercial I
I SC2 4,057,506 $6.77 $/cc f 599,336 6,462 539
55 Sewer - Commercial II I SC3 624,652 $7.96 $/cc f 78,474 1,914 160 56 Sewer - Commercial I V SC4 1,080,270 $10.17 $/cc f 106,221 1,612 134 57 Sewer - School - Elementar y SS1 76,691 $0.85 $/pupil 16 90,225 58 Sewer - School - Junior High SS2 257,794 $2.03 $/pupil 10 126,992 59 Sewer - School - High SS3 0
60 Sewer - School - Continuation SS4 5,059 $0.85 $/pupil 2 5,952 66 Sewer - Commercial II X 1. 3 SX2 4,976 $8.80 $/cc f 565 48 4 68 Sewer - Commercial IV X 1. 3 SX4 43,855 $13.22 $/cc f 3,317 72 6 74 Total 26,376,667
75 76 4. CY 22 Flow, BOD, and TSS for Each Rate Class
77 78 Calculated
79 BOD BOD and TSS TSS BOD TSS Flow,
80 mg/
L lb/pupil/day mg/L Flow, ccf/year lb/year lb/year gpd/student 81 Sewer - Residential SR1 N/A N/A 1,772,414 4,709,801 4,709,801 50 gpcd times 3.86 people per house 82 Sewer - Residential X 1.3 SR2 N/A N/A 12,872 34,203 34,203 50 gpcd times 3.86 people per house 83 Sewer - Residential Multi. SR3 N/A N/A 742,306 1,676,638 1,676,638 50 gpcd times 3.86 people per house 84 SR4 N/A N/A 0 00
85 SR5 N/A N/A 0 00
86 SR6 N/A N/A 0 00
87 Sewer - Commercial II SC2 150 150 599,336 561,121 561,121 Composite: industry standards and City's definition of customer class 88 Sewer - Commercial III SC3 300 300 78,474 146,940 146,940 Composite: industry standards and City's definition of customer class 89 Sewer - Commercial IV SC4 900 700 106,221 596,689 464,092 Composite: industry standards and City's definition of customer class 90 Sewer - School - Elementary SS1 130 0.009 100 19,903 16,149 12,422 11 www.pollutioncontrolsystem.com/Uploads/images/Pages/SEWAGE%20F 91 Sewer - School - Junior High SS2 130 0.021 100 63,666 51,659 39,737 25 elementary, continuation: gpcd for classrooms. No cafeteria or showers 92 Sewer - School - High SS3 130 0.021 130 0 25 jr high and high: classrooms, cafeteria, and showers 93 Sewer - School - Continuation SS4 130 0.009 100 1,313 1,065 819 11 180 days school per year 99 Sewer - Commercial II X 1. 3 SX2 150 150 565 529 529 100 Sewer - Commercial III X 1. 3 SX3 0
101 Sewer - Commercial IV X 1. 3 SX4 900 700 3,317 18,633 14,492 107 Total 3,400,386 7,813,429 7,660,797
108
109 Flow, mgd 6,968,463
110 Compare with DMRs 6.92 5,998,637 5,337,629
111
05162024 2024 Updates Rialto Rate Model
E1WWRateDesign
FG Solutions, LLC
Copyright 2024 All Rights Reservved
5/16/2024
APPENDIX E: WASTEWATER RATE DESIGN
112
113 5. Projected Number of Billing Determinants
114
115
116 Rate Jul-Dec Projected (1)
117 Rate Code Description Code 2022 FY 23/24 FY 24/25 FY 25/26 FY 26/27 FY 27/28 FY 28/29 118 Number of Customer Bills
119 Sewer - Residential SR1 18,976 19,071 19,166 19,262 19,358 19,455 19,552 120 Sewer - Residential X 1.3 SR2 138 138 139 140 141 142 143 121 Sewer - Residential Multi. SR3 7,947 7,987 8,027 8,067 8,107 8,148 8,189 122 Metered Water Consumption, ccf/yea
r
123 Sewer - Commercial I I SC2 599,336 602,333 605,345 608,372 611,414 614,471 617,543 124 Sewer - Commercial II I SC3 78,474 78,866 79,260 79,656 80,054 80,454 80,856 125 Sewer - Commercial I V SC4 106,221 106,752 107,286 107,822 108,361 108,903 109,448 126 Sewer - Commercial II X 1. 3 SX2 565 568 571 574 577 580 583 127 Sewer - Commercial III X 1. 3 SX3
128 Sewer - Commercial IV X 1. 3 SX4 3,317 3,334 3,351 3,368 3,385 3,402 3,419 129 Number of Pupils
130 Sewer - School - Elementar
y SS1 7,519 7,556 7,594 7,632 7,670 7,708 7,747
131 Sewer - School - Junior High SS2 10,583 10,636 10,689 10,742 10,796 10,850 10,904 132 Sewer - School - High SS3
133 Sewer - School - Continuation SS4 496 498 500 503 506 509 512 134
135
136
6. Projected Revenue Requirement Excluding Fontana Extraterritorial, Adjusted for Full Year Implementation 137
138 Projected (1)
139 FY 23/24 FY 24/25 FY 25/26 FY 26/27 FY 27/28 FY 28/29 140 Revenue, Existing Rates $26,080,285 $26,426,992 $26,524,381 $26,621,771 $26,719,160 $26,816,550 141
142 Revenue From Fully Implemented Rate Increase s $0 $1,708,000 $3,531,000 $5,476,000 $7,551,000 143 Less Portion Attributable to Fontana Extraterritorial $0 ($116,968) ($240,988) ($372,463) ($511,860) 144
145 Rate Increase Revenues, 6 Months Implementation $0 851,000 905,000 963,000 1,024,000 1,090,000 146 Less Portion Attributable to Fontana Extraterritorial $0 ($58,479) ($61,977) ($65,724) ($69,650) ($73,888) 147
148 Revenue Adjustment for Full Year Implementation $0 $851,000 $905,000 $963,000 $1,024,000 $1,090,000 149 Less Portion Attributable to Fontana Extraterritorial $0 ($58,479) ($61,977) ($65,724) ($69,650) ($73,888) 150
151 Revenue Requirement, Full Year Implementatio
n $26,080,285 $28,012,034 $29,801,459 $31,706,335 $33,731,398 $35,887,914 152 % Adjustment for Full-Year Implementation 0.00% 0.00% 0.00% 0.00% 0.00% 153 % Change over Prior Yea
r 7.407% 6.388% 6.392% 6.387% 6.393%
154
155 7. Revenue Requirement by Customer Class
156
157 Projected (1)
158 FY 23/24 FY 24/25 FY 25/26 FY 26/27 FY 27/28 FY 28/29 159 Partial Year Implementatio n
160 Sewer - Residential and Residential Multi $21,936,859 $23,338,199 $24,829,950 $26,415,823 $28,104,639 161 Sewer - Residential X 1.3 $116,035 $123,447 $131,338 $139,726 $148,659 162 Sewer - Commercial I I $3,302,374 $3,513,332 $3,737,900 $3,976,637 $4,230,871 163 Sewer - Commercial II I $659,169 $701,277 $746,102 $793,755 $844,501 164 Sewer - Commercial I V $1,520,002 $1,617,101 $1,720,464 $1,830,349 $1,947,367 165 Sewer - Commercial II X 1. 3 $3,197 $3,401 $3,619 $3,850 $4,096 166 Sewer - Commercial IV X 1. 3 $43,921 $46,727 $49,714 $52,889 $56,270 167 Sewer - School - Elementary and Continuin g $107,595 $114,468 $121,785 $129,563 $137,846 168 Sewer - School - Junior High and High $322,883 $343,508 $365,465 $388,807 $413,664 169 Total $28,012,035 $29,801,460 $31,706,335 $33,731,398 $35,887,914 170
05162024 2024 Updates Rialto Rate Model
E1WWRateDesign
FG Solutions, LLC
Copyright 2024 All Rights Reservved
5/16/2024
APPENDIX E: WASTEWATER RATE DESIGN
171 8. Cost of Service Based Rates column width 8 to print jpegs 172
173 Current FY 23/24 FY 24/25 FY 25/26 FY 26/27 FY 27/28 FY 27/28 174 Group I, $/month/unit
175 Residential SF and Multi-Famil
y $62.19 $62.19 $67.23 $71.16 $75.34 $79.75 $84.43
177
178 Non-Residential, $/cc
f
179 Group II - Commercia l $6.77 $6.77 $5.46 $5.77 $6.11 $6.47 $6.85 180 Group III - Commercia l $7.96 $7.96 $8.32 $8.80 $9.32 $9.87 $10.44 181 Group IV - Commercia l $10.17 $10.17 $14.17 $15.00 $15.88 $16.81 $17.79 182 Group VI - Commercia l $6.77 $6.77 $5.46 $5.77 $6.11 $6.47 $6.85 183 Commercial II X 1.3 $8.80 $8.80 $5.60 $5.93 $6.27 $6.64 $7.03 184 Commercial III X 1.
3 $10.35 $10.35 $10.81 $11.44 $12.12 $12.83 $13.58
185 Commercial IV X 1.3 $13.22 $13.22 $13.11 $13.87 $14.69 $15.55 $16.46 186
187 Schools: $/pupil/month
188 Elementary, Continuing, and Adult Education $0.85 $0.85 $1.18 $1.25 $1.32 $1.40 $1.48 189 Junior High and High $2.03 $2.03 $2.52 $2.66 $2.82 $2.99 $3.16 190
191
192
9. Back-Calculation of Rate Revenues, Cost-of-Service Rates 193
194 Current FY 23/24 FY 24/25 FY 25/26 FY 26/27 FY 27/28 FY 28/29 195 Group I, $/month/unit
196 Residential $20,192,844 $21,115,226 $22,692,385 $24,142,144 $25,685,266 $27,326,263 197 Residential X 1.3 $66,936 $58,017 $120,158 $127,833 $135,998 $144,685 198
199 Non-Residential, $/cc
f
200 Group II - Commercia l 4,077,794 3,700,280 3,416,110 3,634,399 3,866,613 4,113,695 201 Group III - Commercia l 627,773 645,039 681,869 725,441 771,792 821,111 202 Group IV - Commercia l 1,085,668 1,305,550 1,572,348 1,672,824 1,779,709 1,893,438 203 Commercial II X 1.3 4,999 4,111 3,308 3,519 3,744 3,983 204 Commercial IV X 1.3 44,079 44,112 45,435 48,338 51,426 54,712 205 Schools: $/pupil/month
206 Elementary and Continuing 82,151 98,619 118,636 126,223 134,295 142,891 207 Junior High and High 259,093 291,633 333,996 355,350 378,050 402,203 208 Total $26,441,337 $27,262,588 $28,984,246 $30,836,073 $32,806,893 $34,902,980 209
210 Compare with Revenue Requirement (Partial Year Implementation ) $26,080,285 $27,219,513 $28,958,436 $30,809,059 $32,777,047 $34,871,802 211 Delta $361,052 $43,075 $25,810 $27,014 $29,845 $31,178 212
213
214
215
10. Cost-of-Service Adjustments
216
217 10A. COS Adjustments: Residential 1.3X Rates are 1.3X Residential 218 Combined Revenue Requirement, Res and Res 1.3 X $22,052,894 $23,461,646 $24,961,288 $26,555,549 $28,253,298 219 Weighted Billing Determinants (Res + 1.3x Res1.3X) 27,374 27,511 27,648 27,788 27,927 220 Adjusted Residential Rate $67.14 $71.07 $75.23 $79.64 $84.31 221
222 10B. COS Adjustments: Commercial II 1.3X Rates are 1.3X Commercial I I De Minimus Change. No Calculation Performed
223
224 10C. COS Adjustments: Commercial IV 1.3X Rates are 1.3X Commercial I V
225 Combined Revenue Requirement, Comm IV and Comm IV 1.3 X $1,563,923 $1,663,828 $1,770,177 $1,883,238 $2,003,637 226 Weighted Billing Determinants (CommIV + 1.3x CommIV 1.3X ) 111,642 112,200 112,762 113,326 113,893 227 Adjusted Commercial IV Rate, $/cc f $14.01 $14.83 $15.70 $16.62 $17.59 228
22905162024 2024 Updates Rialto Rate Model
E1WWRateDesign
FG Solutions, LLC
Copyright 2024 All Rights Reservved
5/16/2024
APPENDIX E: WASTEWATER RATE DESIGN
230 10D. COS Adjustments: Gradual Commercial IV Rate Increase With Concurrent Adjustment to Commercial II Rate s 231
232 Extra Revenue Collected in Commercial II Rate s
233 Proposed Commercial II Rate s $6.77 $5.80 $6.10 $6.40 $6.70 $6.85 234 COS Commercial II Rat e $6.77 $5.46 $5.77 $6.11 $6.47 $6.85 235 Billing Determinants 605,345 608,372 611,414 614,471 617,543 236 Additional Revenue $208,627 $197,738 $175,150 $140,319 $0 237
238 Commercial IV Billing Determinants, ccf/yea
r 106,752 107,286 107,822 108,361 108,903 109,448
239
240 Decrease in Commercial IV Rates From COS Rate
s $1.94 $1.83 $1.62 $1.29 $0.00
241 Proposed Commercial IV Rate s $10.17 $12.06 $13.00 $14.08 $15.33 $17.59 242 Commercial IV COS Rate s $14.01 $14.83 $15.70 $16.62 $17.59 243 Increase in Commercial IV Rates from Prior Yea r $1.89 $0.93 $1.09 $1.25 $2.26 244
245 10E. COS Adjustments: Schools - Phase in Rates
246
247 Elementary and Continuing
248 COSA $0.85 $0.85 $1.18 $1.25 $1.32 $1.40 $1.48
249 Adjusted $0.00 $0.85 $1.00 $1.15 $1.25 $1.35 $1.48
250 Change In Revenues ($41,075) ($8,776) ($13,695) ($8,489) ($6,109) ($2,515) 251
252 Junior High and High
253 COSA $2.03 $2.03 $2.52 $2.66 $2.82 $2.99 $3.16
254 Adjusted $0.00 $2.03 $2.30 $2.60 $2.80 $2.99 $3.16
255 Change in Revenues ($129,546) ($13,933) ($18,181) ($5,560) ($1,367) $0 256
257
11. Proposed Rates
258
259 Current 1/1/2024 1/1/2025 1/1/2026 1/1/2027 1/1/2028 1/1/2029 260 Group I, $/month/unit
261 Residential SF and MF < or = 49 Unit
s $62.19 $62.19 $67.14 $71.07 $75.23 $79.64 $84.31
262 Residential X 1.3 $80.84 $80.84 $87.28 $92.39 $97.80 $103.53 $109.60 263
264 Non-Residential, $/cc
f
265 Group II - Commercia l $6.77 $6.77 $5.80 $6.10 $6.40 $6.70 $6.85 266 Group III - Commercia l $7.96 $7.96 $8.32 $8.80 $9.32 $9.87 $10.44 267 Group IV - Commercia l $10.17 $10.17 $12.06 $13.00 $14.08 $15.33 $17.59 268 Group VI - Commercia l $6.77 $6.77 $5.80 $6.10 $6.40 $6.70 $6.85 269 Commercial II X 1.3 $8.80 $8.80 $7.54 $7.93 $8.32 $8.71 $8.91 270 Commercial III X 1.
3 $10.35 $10.35 $10.81 $11.44 $12.12 $12.83 $13.58
271 Commercial IV X 1.3 $13.22 $13.22 $15.68 $16.90 $18.30 $19.93 $22.87 272 Commercial VI X 1.3 $8.80 $8.80 $7.54 $7.93 $8.32 $8.71 $8.91 273
274 Schools: $/pupil/month
275 Elementary, Continuing, and Adult Education $0.85 $0.85 $1.00 $1.15 $1.25 $1.35 $1.48 276 Junior High and High $2.03 $2.03 $2.30 $2.60 $2.80 $2.99 $3.16 277
314
05162024 2024 Updates Rialto Rate Model
E1WWRateDesign
FG Solutions, LLC
Copyright 2024 All Rights Reservved
5/16/2024
APPENDIX E: WASTEWATER RATE DESIGN
315 12. Back-Calculation of Rate Revenues, Proposed Rates 316
317 Current FY 23/24 FY 24/25 FY 25/26 FY 26/27 FY 27/28 FY 27/28 318 Group I, $/month/unit
319 Residential SF and Multi. $21,101,224 $22,662,847 $24,108,777 $25,649,260 $27,288,822 320 Residential X 1.3 $140,214 $150,925 $160,901 $171,534 $182,870 321
322 Non-Residential, $/cc
f
323 Group II - Commercia l 3,804,593 3,619,813 3,821,338 4,024,785 4,183,854 324 Group III - Commercia l 645,176 681,855 725,289 771,956 821,093 325 Group IV - Commercia l 1,192,484 1,351,010 1,467,208 1,601,419 1,801,514 326 Commercial II X 1.3 4,665 4,440 4,688 4,939 5,135
327 Commercial IV X 1.3 48,420 54,861 59,583 65,034 73,160 328 Schools: $/pupil/month
329 Elementary and Continuing 89,843 104,942 117,734 128,185 140,376 330 Junior High and High 277,700 315,815 349,790 376,684 402,203 331 Total, Excluding Fontana Extraterritorial $27,304,321 $28,946,508 $30,815,308 $32,793,795 $34,899,026 332
333 Compare with Revenue Requirement (Partial Year Implementation ) $27,161,034 $28,896,459 $30,743,335 $32,707,398 $34,797,914 334 Delta $143,287 $50,049 $71,973 $86,398 $101,113
05162024 2024 Updates Rialto Rate Model
E1WWRateDesign
FG Solutions, LLC
Copyright 2024 All Rights Reservved
5/16/2024