Agenda 1. Overview of water rate setting a. The rate setting - - PDF document

SLIDE 1

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 1

2020 Water Rate Study Preliminary Findings

August 17, 2020 2

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 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

The Rate Setting Process

Compares the revenues of each utility to its expenses to determine the overall level of annual rate adjustments to meet financial

• bjectives

Equitably allocates the revenue requirements between the various customer classes of service

• n a proportionate basis

Design rates for each class of service to meet the revenue needs of the utility, along with any

• ther rate design goals and objectives

Revenue Requirements Cost-of-Service Rate Design

3

SLIDE 2

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 2

4

Legal Requirements for Setting Water Rates In California

• Proposition 218 (Article XIIID, Section 6 of California Constitution)
• Revenues shall not exceed funds required to provide service; nor used for

another purpose

• Amount shall not exceed the proportional cost of the service attributable to

the parcel

• Service must be actually used or immediately available
• Approval process includes 45-day notice, public hearing, and written

majority protest. Does not require a voting process (unlike taxes).

• Many court decisions have clarified requirements

5

Business Plan Model

6

Financial Plan

SLIDE 3

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 3

7

Estimated Cash Reserves

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

Revenue

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

Historic Water Production

SLIDE 4

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 4

Operating & Debt Service Expenses

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

Recent and Projected Capital Spending

Replacement of aging infrastructure

11 $8M for filter replacement

Average cash-funded capital = $2M Average cash-funded capital = $5.7M

Capital Spending

Replacement of aging infrastructure

12

Detailed Tables Available as Extra Slides

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

SLIDE 5

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 5

13

Reserves

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

• n actuarial assessments

Financial Forecast – #1 Cash finance the filter replacement in 10 years

(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

Financial Forecast – #2 Cash finance the filter replacement in 15 years

(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

SLIDE 6

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 6

Financial Forecast – #3 Debt finance the filter replacement

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

Reasons for Rate Increases

1. Increase in capital spending

• From $2M per year to $5.7M per year

2. Loss of Aerojet revenue

• $1.3M per year starting in FY23

3. Lack of rebound in water usage

• 20% lower than historic highs

4. Inflation

• Rate increases of 3% per year are

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

Survey of Rate at Regional Public Utilities

Single Family accounts with 1” meters and 11 CCF of monthly usage (average)

SLIDE 7

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 7

19

Current Water Rates

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

Cost of Service Analysis

Significantly higher than during 2015 study

Proposed Water Rates

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%

SLIDE 8

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 8

Bill Impacts for bimonthly bills

22

Meter

• Wtr. Use

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

Water Shortage Surcharge Rates

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%

• Est. Financial Impact from Water Shortage

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) $

• Est. Total Financial Deficit
• $

(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

Project Schedule and Next Steps

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

SLIDE 9

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 9

25

EXTRA SLIDES

26

Carmichael Water District

Water Rate History

 Water metering

• 1998 – WRSC recommended aggressive metering
• 2013 – Metering completed. All customers on metered water rates in 2015

 Water rates

• 1999 – Initial metered rate structure
• 2015 – Tiered consumption rates implemented
• 2017 – Uniform consumption rates implemented

 15-year rate increase history

• 2021-2024 – Projections from 2016 Business Plan Update (not adopted)

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%

Rate Study Objectives

Financial sufficiency and sustainability Legal compliance Minimize rate increases Equitability Affordability Revenue stability / predictability Conservation Support high quality water

27

SLIDE 10

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 10

Detailed Capital Spending - Production

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 $

SLIDE 11

2020 Carmichael Water Rate Study August 17, 2020 Board Meeting 11

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

Detailed Capital Spending – Administrative Services

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