2020 Water Rate Study Preliminary Findings
August 17, 2020
2020 Water Rate Study Preliminary Findings August 17, 2020 Agenda - - PowerPoint PPT Presentation
2020 Water Rate Study Preliminary Findings August 17, 2020 Agenda 1. Overview of water rate setting a. The rate setting process b. Legal requirements c. Committee participation 2. Current water rates 3. Survey 4. Financial Plan
August 17, 2020
2
1. Overview of water rate setting a. The rate setting process b. Legal requirements c. Committee participation 2. Current water rates 3. Survey 4. Financial Plan Scenarios 5. Rate Structure a. Current Rates b. Cost-of-Service Analysis c. Proposed Rates d. Bill Impacts 6. Water Shortage Rates 7. Project Schedule
Compares the revenues of each utility to its expenses to determine the overall level of annual rate adjustments to meet financial
Equitably allocates the revenue requirements between the various customer classes of service
Design rates for each class of service to meet the revenue needs of the utility, along with any
Revenue Requirements Cost-of-Service Rate Design
3
4
another purpose
the parcel
majority protest. Does not require a voting process (unlike taxes).
5
6
7
For fiscal year beginning July 1, 2020 (as of July 2020)
WAB General Fund $10,485,000 LAIF $1,928,000 Filter Replacement Fund $690,000
Total Unrestricted: $13,103,000
Facility Fees (Capital Only) $480,000 OPEB Trust Fund $1,765,000
Total Reserves: $15,348,000
FY2020/21 Budget
8 Retail Rate Revenue $12,129,000 Non-Rate Revenue Aerojet – Firm Capacity* $1,400,000 GSWC – Treatment & Delivery $1,173,000 Interest Earnings $57,000 Other Operating Revenue $127,000 Capital Facility Fees $68,000 Transfer In $170,450 Total: $15,124,450
* Revenue expires in FY 2022/23
9
FY2020/21 Budget
10
Adminstrative
$4,219,000
Production
$2,774,000
Distribution
$1,933,000
Debt Service
$2,540,000
Transfers for pensions/OPEB liabilities
$600,000
Total Budget: $12,066,000
Replacement of aging infrastructure
11
$8M for filter replacement
Average cash-funded capital = $2M Average cash-funded capital = $5.7M
Replacement of aging infrastructure
12
FY2020/21 FY2021/22 FY2022/23 FY2023/24 FY2024/25 FY2025/26 FY2026/27 FY2027/28 FY2028/29 FY2029/30 FY2030/31
Production $0 $1,150,000 $1,225,000 $1,560,000 $1,375,000 $820,000 $525,000 $705,000 $655,000 $380,000 $190,000 Distribution $1,053,063 $4,060,424 $2,609,986 $3,382,172 $1,943,210 $3,057,630 $2,849,878 $4,614,947 $4,440,541 $3,651,376 $1,986,216 Adminstrative Services $138,902 $1,094,043 $297,469 $256,056 $259,373 $290,432 $268,423 $385,056 $308,840 $273,585 $1,282,020 Contingency Budget $0 $0 $413,246 $519,823 $357,758 $416,806 $364,330 $570,500 $540,438 $430,496 $345,824 Total Operating Expenses $1,191,965 $6,304,467 $4,545,701 $5,718,050 $3,935,341 $4,584,868 $4,007,632 $6,275,503 $5,944,819 $4,735,457 $3,804,059
13
The following are established & proposed District reserve policies. In addition to protecting the District against unforeseen circumstances, these policies also contribute towards the District’s credit rating.
Reserve* Purpose and Policies Target Level Current Level
MINIMUM RESERVES Operating Reserve Purpose: Provide sufficient funds for working capital, cash flow, and funds for continued operation in the event of unplanned operating and maintenance expenditures. Minimum Reserve: 33% of budgeted O&M costs less debt service $3.8M $3.8M Rate Stabilization Purpose: provide safeguard to ensure that District meets the debt service coverage requirements Minimum Reserve: None Policy: Surplus net revenues may be deposited into the Rate Stabilization Reserve Fund $520K $520K Subtotal: $4.3M $4.3M TARGET RESERVES Filter Replacement Purpose: Smooths the annual cost of replacing filters Proposed Policy: Set aside $0K to $600K annually NA $670K Water Treatment Plant Replacement Purpose: Smooths the annual cost of replacing equipment, facilities, and structures at the WTP Proposed Target: Combine with Capital Replacement Reserve, see below $4.0M $5.3M Capital Replacement Purpose: Supports District’s ability to support “Pay As You Go” (cash) funding of capital program Proposed Target: 10-year average Pay-Go capital budget spending Subtotal: $4.0M $6.0M UNRESTRICTED RESERVES General Fund Purpose: Cash in excess of target reserves $0 $3.3M Total: $8.3M $13.6M * This list does not include the existing OPEB and CalPERS reserves (currently at $1.8M combined) since these reserves are restricted and are based
(annual contributions of $753 thousand) 14 Compounded rate increases after 5 years: 65%
FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031
Proposed Revenue Increases: 10.5%
10.5% 10.5% 10.5% 10.5% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0%
Debt Coverage Ratio:
3.18 2.53 2.99 3.55 3.53 4.09 4.48 4.62 4.75 4.90 5.53 5.33 Net Debt Proceeds: $20.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M
$0 $10 $20
MILLIONS Cash Reserves (excluding Filter Reserve) Ending Fund Balance Target Reserves $0 $5 $10 $15 $20 $25 $30 $35 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031
Total Revenue / Expenses ($M)
Non-Rate Revenue Existing Rate Revenue Additional Rate Revenue Operating Expenses Debt Filter Reserve Expense Cash Capital Reserve Funded Capital
Expenses
Revenues
(annual contributions of $600 thousand) debt if the filters fail after 10 years) 15 Compounded rate increases after 5 years: 57%
FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031
Proposed Revenue Increases:
9.5% 9.5% 9.5% 9.5% 9.5% 5.0% 5.0% 3.0% 3.0% 3.0% 3.0%
Debt Coverage Ratio:
3.18 2.50 2.92 3.41 3.31 3.78 4.19 4.48 4.69 4.83 4.97 5.25 Net Debt Proceeds: $20.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M
$0 $10 $20
MILLIONS Cash Reserves (excluding Filter Reserve) Ending Fund Balance Target Reserves $0 $5 $10 $15 $20 $25 $30 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031
Total Revenue / Expenses ($M)
Non-Rate Revenue Existing Rate Revenue Additional Rate Revenue Operating Expenses Debt Filter Reserve Expense Cash Capital Reserve Funded Capital
Expenses
Revenues
16 Compounded rate increases after 5 years: 47%
FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031
Proposed Revenue Increases:
8.0% 8.0% 8.0% 8.0% 8.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0%
Debt Coverage Ratio:
3.18 2.47 2.80 3.21 3.01 3.35 3.61 3.72 3.82 3.94 3.26 3.42 Net Debt Proceeds: $20.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $0.0M $8.2M $0.0M
$0 $10 $20
MILLIONS Cash Reserves (excluding Filter Reserve) Ending Fund Balance Target Reserves $0 $5 $10 $15 $20 $25 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031
Total Revenue / Expenses ($M)
Non-Rate Revenue Existing Rate Revenue Additional Rate Revenue Operating Expenses Debt Filter Reserve Expense Cash Capital Reserve Funded Capital
Expenses
Revenues
1. Increase in capital spending
2. Loss of Aerojet revenue
3. Lack of rebound in water usage
4. Inflation
needed even without the above factors 17 (approximately 25% rate increase) (approximately 11% rate increase) (approximately 9% rate increase) (approximately 16% rate increase over 5 years)
18
Single Family accounts with 1” meters and 11 CCF of monthly usage (average)
19
Water Usage Rate: $1.54 per HCF (748 gallons) Bimonthly Service Charge: 3/4“ meter $57.16 1” meter $87.37 1.5” meter $162.90 2” meter $253.50 3” meter $464.93 4” meter $766.98 6” meter $1,522.10 42% of revenue 58% of revenue Water Shortage Surcharge Rate apply in the event of a drought
FY 20-21 Water Rate Revenue Requirement Administrative Services 3,703,800 $ 4 1 = Customer cost Board Expenses 151,500 $ 1 2 = Capacity cost Water Conserv./Outreach 247,900 $ 1 3 = Commodity cost Billing/Customer Service 116,200 $ 1 4= Half capacity / half commodity Production 1,397,600 $ 3 Power/Chemicals 1,376,400 $ 3 Distribution 1,933,000 $ 4 OPEB & CalPERS Liability 600,000 $ 2 Debt Service 2,540,000 $ 2 Average PayGo Capital 5,953,500 $ 2 Total Expenses 18,019,900 $ Change in Fund Balance (2,066,900) $ 2 GSWC Revenue (2,333,300) $ 2 Other Revenue (579,700) $ 2 Total Revenue Requirement 13,040,000 $ Proposed Current Per Account 515,600 $ Per Meter Equivalent 6,932,000 $ Per Water usage 5,592,400 $ 42.9% 41.6% 13,040,000 $ Revenue Profile 57.1% 58.4%
20
Significantly higher than during 2015 study
21
Current Proposed @ 9.5% increases Water Usage Rates
Change All Customer Types $1.54 $1.73 per CCF 12.6%
Bimonthly Service Charge
3/4" meter $57.16 $57.33 per meter 0.3% 1" meter $87.37 $90.69 per meter 3.8% 1 1/2" meter $162.90 $174.11 per meter 6.9% 2" meter $253.50 $274.21 per meter 8.2% 3" meter $464.93 $507.78 per meter 9.2% 4" meter $766.98 $841.45 per meter 9.7% 6" meter $1,522.10 $1,675.63 per meter 10.1% 8" meter $2,428.23 $2,676.64 per meter 10.2% Condominium Living Units $57.16 $57.33 per living unit 0.3% Multi-Family Living Units w/ Separate Meter $57.16 $57.33 per living unit 0.3% Bimonthly Private Fire Service Charges $41.81 $45.78 per inch of diameter 9.5%
22
Meter
Current Proposed Size (CCF) Bill Bill* $ %
Single Family Low Use 1" 16 112.01 $
118.45 $ 6.44 $ 6%
Median Use 1" 35 141.27 $
151.41 $ 10.14 $ 7%
High Use 1" 85 218.27 $
238.15 $ 19.88 $ 9%
Very High Use 1" 150 318.37 $
350.91 $ 32.54 $ 10%
Condomium Unit 1" 16 81.80 $
85.09 $ 3.29 $ 4%
Duplex 1" 35 168.22 $
175.38 $ 7.16 $ 4%
Fourplex 1" 60 321.04 $
333.41 $ 12.37 $ 4%
Apartment 1 1/2" 200 470.90 $
521.07 $ 50.17 $ 11%
Apartment 2" 400 778.90 $
868.03 $ 89.13 $ 11%
Apartment 4" 800 1,394.90 $
1,561.95 $ 167.05 $ 12%
Retail Business 1" 35 141.27 $
151.41 $ 10.14 $ 7%
Retail Business 2" 200 561.50 $
621.17 $ 59.67 $ 11%
School 4" 800 1,998.98 $
2,229.29 $ 230.31 $ 12%
Institutional (multiple)** 500 1,364.37 $
1,506.51 $ 142.14 $ 10%
Irrigation 2" 400 869.50 $
968.13 $ 98.63 $ 11%
* For Year 1 @ 9.5% rate revenue increases ** Assumes two 2" meters and one 1" meter
Change
23
Normal Supply (1) Stage 1 Stage 2 Stage 3 Stage 4 Stage 5 Stage 6 Use Reduction Goals --> None
0% to 10% 10% to 20% 20% to 30% 30% to 40% 40% to 50% > 50%
Assumed Actual Water Use Reduction -->
5% 15% 25% 35% 45% 55%
Water Shortage Charge (2) --> 0% 5% 15% 20% 25% 30%
Reduced Water Sales Revenue (262,000) $ (785,000) $ (1,308,000) $ (1,831,000) $ (2,354,000) $ (2,878,000) $ Reduced Power and Chemical Costs 10,000 $ 30,000 $ 50,000 $ 71,000 $ 91,000 $ 111,000 $ Increased Conservation Program Costs (4,000) $ (12,000) $ (20,000) $ (28,000) $ (36,000) $ (43,000) $ Increased Water Purchase Costs
(2,450,000) $ (2,425,500) $ (2,940,000) $ (3,185,000) $
(256,000) $ (767,000) $ (3,728,000) $ (4,213,500) $ (5,239,000) $ (5,995,000) $ Multi-Pronged Corrective Strategy Reduction in Capital Spending
357,240 $ 3,036,540 $ 3,334,240 $ 4,286,880 $ 5,060,900 $ Increase in Revenue from Surcharges (2)
222,000 $ 589,000 $ 680,000 $ 720,000 $ 706,000 $ Total Corrective Actions
579,240 $ 3,625,540 $ 4,014,240 $ 5,006,880 $ 5,766,900 $ Surplus/(Deficit) Due to Shortage (3)
(256,000) $ (187,760) $ (102,460) $ (199,260) $ (232,120) $ (228,100) $ Notes: (1) The FY 20-21 budget and related revenue and expense estimates were assumed to be a normal water supply year. (2) Water shortage charges would apply only to the water usage rate (3) To be absorbed by District reserves
24
Committee Meetings Meeting #1 - July 15 Meeting #2 - August 4 Meeting #3 – Sept. 8
Project Kickoff & Data Collection 10-Year Business Plan Water Rate Study Committee Workshops Board Meetings Reports & Deliverables Oct Nov Dec Jan Feb 2020 2021 June July Aug Sep
June 24: Kickoff Meeting January 1 2021: New Rates Effective Rate Committee Workshops July: Business Planning Workshop August: Rate Structure Workshop Early September Submit Adminstrative Draft December 14: 218 Public Hearing Late September Submit Draft Report & 218 Notification October Submit Final Report & Model August 17 - Preliminary Recommendations to Board September 21 Final recommendation to Board 218 Notification Period
25
26
Water metering
Water rates
15-year rate increase history
ADOPTED
PREVIOUSLY PROJECTED 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 5% 2% 2% 0%
4.3%
3% 18% 0% 0% 0% 12% 0% 5% 5% 5% 5% 12% 12% 10% 10% 10%
Financial sufficiency and sustainability Legal compliance Minimize rate increases Equitability Affordability Revenue stability / predictability Conservation Support high quality water
27
FY2021/22 FY2022/23 FY2023/24 FY2024/25 FY2025/26 FY2026/27 FY2027/28 FY2028/29 FY2029/30 FY2030/31
Production
1 Existing Well/Pump Replacement
$150,000
2 New Wells - share w/ SSWD and 1 new well
$750,000 $750,000 SWTP
3 Membrane Replacement
$150,000 $150,000 $75,000 $75,000 $675,000 $225,000 $335,000 $180,000 $180,000 $90,000
4 SCADA Improvement w/ PLC Upgrade
$500,000
5 6 Block Skid Replacement (2nd)
$200,000
6 Breaker Replacement (Multiple)
$100,000
7 48 Block Replacement or Upgrade
$300,000 $300,000
8 Filter (90 Block) replacement
$0 Reservior Storage & Well Pumps
9 Dewey BP station - pump replacement, A/C, electrical
$200,000
10 Dewey Tank Rehab & Painting
$250,000
11 Willow Park Well Pump Replacement
$150,000
12 GW Study - additional wells and treatment
$150,000 Water Production General
13 Vehicles - 2 vehicles in 10 years
$45,000 $45,000
14 Building A/C - control froom
$45,000
15 Compressor Replacement - last of 3
$100,000
16 Furniture & Carpet - BWTP
$45,000
17 300 hp RW Pumps (3)
$100,000 $100,000 $100,000
16 Chemical Tank Rehab
$75,000
18 Chemical Feed Pumps
$25,000
19 Security Upgrade
$100,000
20 Instrumentation Upgrade
$45,000 $50,000
21 Generator Replacement or Upgrade
$300,000
22 Electrical Transfer Gear Replacement
$1,000,000 Techinical Services & Reports
23 SCADA Upgrade Study
$75,000
24 BWTP Intake Capacity Study (Ranney)
$400,000 Total Operating Expenses $1,150,000 $1,225,000 $1,560,000 $1,375,000 $820,000 $525,000 $705,000 $655,000 $380,000 $190,000
Detailed Capital Spending – Distribution Vehicles and Equipment
Asset Description Current Age Purchase Cost Current Miles/Hours 21/22 22/23 23/24 24/25 25/26 26/27 27/28 28/29 29/30 30/31 Dodge 3500 Flatbed, Welding and Cutting 19 $30,573 27,106 75,000 Ford F-150 Pickup, Superintendent 18 $21,301 63,865 34,000 Ford F-150 Pickup, Mounted Sign Board 13 $15,610 76,113 35,000 Ford F-550 Service Truck, Utility 4 $63,000 26,711 70,000 Ford F-550 Service Truck, Utility 4 $63,000 28,040 70,000 Ford F-550 Service Truck, Utility 3 $64,000 18,542 70,000 Ford F-150 Pickup, On-Call 2 $26,500 11,761 35,000 New Holland Ford Yard Loader 18 37,588 $ 1,316 70,000 John Deere 310SE Backhoe 20 65,450 $ 3,569 John Deere 410G Backhoe 14 65,457 $ 3,273 140,000 John Deere 410G Backhoe 13 66,627 $ 2,932 150,000 Ditch Witch 1230 Trencher w/1 Axle Trailer 24 8,584 $ N/A 9,500 Tow Master 2 Axle Trailer 16 6,590 $ N/A 12,000 Ditch Witch 800 gal Vacuum Excavator 3 32,167 $ 626 65,000 Vac-Tron 500 gal Vacuum Excavator 1 45,835 $ 25 70,000 Valve Exercising Trailer TBD TBD TBD 70,000 Target Pac-IV Concrete Saw 26 3,473 $ N/A 7,000 Wacker Compactor BS62Y 25 2,300 $ N/A 5,500 Bomeg Compactor 20 2,464 $ N/A 5,500 Wacker Compactor BS600 24 2,654 $ N/A 5,500 Millermatic Vintage Welder 24 2,584 $ N/A 5,000 Miller Bobcat 225NT Welder/Generator 23 2,840 $ 175 10,000 7,000 Light Tower Trailer 18 5,632 $ N/A 7,500 Pierce Arrow Tool 17 2,500 $ N/A 3,000 3,200 Pipe Locator 18 4,200 $ N/A 5,000 5,000 5,000 Pipe Tapping Machine 22 2,500 $ N/A 5,000 Pipe Tapping Machine Air Operator 20 4,500 $ N/A 5,200
Detailed Capital Spending – In-House Services
Asset Description 21/22 22/23 23/24 24/25 25/26 26/27 27/28 28/29 29/30 30/31 Cost 2010 Service Line Replacements 302,000 303,400 309,600 312,600 315,900 319,100 328,500 331,800 338,400 341,800 3,203,100 $ Main Line Valve Replacements 85,300 86,200 88,400 89,600 90,200 101,600 105,300 106,200 108,800 110,300 971,900 $ Fire Hydrant Replacements 68,200 69,500 70,800 72,200 73,600 75,000 76,400 77,800 79,300 80,800 743,600 $ Impacts from Sac County Projects 125,000 125,000 125,000 125,000 125,000 125,000 125,000 125,000 125,000 125,000 1,250,000 $
Detailed Capital Spending – 10-Year Priority Mainline Replacement Project Bundles
Engineering Construction Yearly Project Priority Permit/Inspect Management Environmental Contingency Project Bundle Year Project Name Material/Labor 15% 15% 15% 10% Cost Total Glenbrook/Mauer 571,088 85,663 85,663
57,109 $ 799,523 $ Wintun Dr/Grant (California to Lani) 476,560 71,484 71,484
47,656 $ 667,184 $ North Ave (FOB to Winsome) 324,128 48,619 48,619
32,413 $ 453,779 $ Clair Dr/Continental/San Juan 1,200,840 180,126 180,126 180,126 $ 120,084 $ 1,861,302 $ Claremont/Coda 124,564 207,606 $ 332,170 $ Barbara Way/Nesscliff Way 497,616 74,642 74,642
49,762 $ 696,662 $ Landis and California Intersection 346,248 51,937 51,937
34,625 $ 484,747 $ Claremont/Coda 1,660,848 124,564 249,127 207,606 $ 166,085 $ 2,408,230 $ Vale/Almond/Casa Nuestras/Peggy 1,351,728 202,759 202,759 202,759 $ 135,173 $ 2,095,178 $ Wilkins/Kiernan 1,018,976 152,846 152,846 152,846 $ 101,898 $ 1,579,413 $ Ross Ave/Delaware Ave/Casita/Calif 1,501,248 225,187 225,187 225,187 $ 150,125 $ 2,326,934 $ Hillgrove/Holeton/Verla/Sizemore 1,347,024 202,054 202,054 202,054 $ 134,702 $ 2,087,887 $ Panay Ct/Topp 1,020,938 153,141 153,141 153,141 $ 102,094 $ 1,582,454 $ Homewood/Halsted, Calumet/De John/Vonda/Home 1,893,920 284,088 284,088 284,088 $ 189,392 $ 2,935,576 $ Candace/Hunter 909,440 136,416 136,416
90,944 $ 1,273,216 $ Mapel/Marshall/Prospect/Lakeview 2,478,560 371,784 371,784 371,784 $ 247,856.00 $ 3,841,768 $ FY 23/24 $ 1,181,410 $ 2,193,472 FY 22/23 FY 21/22 1,920,486 $ FY 24/25 $ 2,408,230 FY 25/26 $ 2,095,178 FY 26/27 3,906,347 $ FY 30/31 $ 3,841,768 FY 27/28 3,670,341 $ FY 28/29 2,935,576 $ FY 29/30 $ 1,273,216
Administrative Services Facility Improvements - Office $0 $1,047,543 $104,000 $45,000 $45,000 $49,000 $10,000 $115,000 $25,000 Information Technology $138,902 $46,500 $180,469 $183,138 $178,706 $171,432 $186,169 $195,475 $206,858 $194,124 $200,000 Billing $13,000 $70,000 $72,254 $74,581 $76,982 $79,461 $82,020 Public Information/Water Efficiency $27,918 $35,667 $1,000,000 Total Adminstrative Services Spending $1,094,043 $297,469 $256,056 $259,373 $290,432 $268,423 $385,056 $308,840 $273,585 $1,282,020