Loading...
HomeMy WebLinkAbout05. Receive quarterly Financial Review for the quarter ending September 30, 2024Page 1 of 38 Item 5. 110ENTRAL SAN December 5, 2024 FROM: BRENNAN ROGERS, ACCOUNTING SUPERVISOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIPLEIBER, DEPUTYGM -ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE QUARTERLY FINANCIAL REVIEW FOR THE QUARTER ENDING SEPTEMBER 30, 2024 Attached is the Quarterly Financial Review for the first quarter of Fiscal Year (FY) 2024-25 ending September 30, 2024 (unaudited). The Executive Summary (Section 1) of the attached report includes an analysis of financial results and the investment portfolios for the quarter. Strategic Plan Tie -In GOAL FOUR: Governance and Fiscal Responsibility Strategy 1 - Promote and uphold ethical behavior, openness, and accessibility, Strategy 3 - Maintain financial stability and sustainability ATTACHMENTS: 1. Quarterly Financial Review for the quarter ended September 30, 2024 December 5, 2024 Regular Board Meeting Agenda Packet - Page 25 of 274 Quarterly Financial Review No ROT -7U8" Few 4 --7 2.1 ML MW 11kow- 1�4jt 102� ------ 1OU7 Attachment 1 F, 71. CENTRAL SAN r toQuarter Ended September 30, 2024 AlIM�CENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Table of Contents Section1- Executive Summary................................................................................................................................................................................................1 Section 2 - Financial Results Summary by Fund................................................................................................................................................................5 Section 3 - Operations & Maintenance Fund Revenues Revenuesby Source - Summary........................................................................................................................................................................................................6 Revenuesby Source - Detail...............................................................................................................................................................................................................7 Expenses Expensesby Type - Summary............................................................................................................................................................................................................8 Expensesby Type - Detail....................................................................................................................................................................................................................9 Expenses by Organizational Unit - Summary (Department).............................................................................................................................................10 Expenses by Organizational Unit - Detail (Division).............................................................................................................................................................11 Section 4 - Sewer Construction Fund Revenues Revenuesby Source - Summary.....................................................................................................................................................................................................12 Revenuesby Source - Detail............................................................................................................................................................................................................13 Expenses ExpensesSummary (by Program).................................................................................................................................................................................................14 ExpensesDetail (by Project)............................................................................................................................................................................................................15 Capital Budget Transfers (by Project by Month).....................................................................................................................................................................19 Section 5 - Self Insurance Fund Revenuesby Source.............................................................................................................................................................................................................................20 December 5, 2024 Regular Board Meeting Agenda Packet - Page 27 of 274 A11M�CENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Table of Contents Expensesby Type.................................................................................................................................................................................................................................21 Section 6 - Debt Service Fund Revenuesby Source.............................................................................................................................................................................................................................22 Expensesby Type.................................................................................................................................................................................................................................23 Section 7 - Investment Portfolio Reports Operations& Maintenance Fund....................................................................................................................................................................................................24 SewerConstruction Fund..................................................................................................................................................................................................................25 Self -Insurance Fund.............................................................................................................................................................................................................................26 Section 8 -Financial Performance Metrics 0&M Fund Cashflow Forecast.........................................................................................................................................................................................................27 Sewer Construction Fund Cashflow Forecast...........................................................................................................................................................................28 StaffingTrends.......................................................................................................................................................................................................................................29 Cost per Million Gallons of Wastewater Treated.....................................................................................................................................................................30 CapitalSpending Trends....................................................................................................................................................................................................................31 Milesof Pipeline Constructed/Renovated..................................................................................................................................................................................34 December 5, 2024 Regular Board Meeting Agenda Packet - Page 28 of 274 A11M�CENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 1 -Executive Summary Quarterly Financial Highlights Included in this consolidated report are quarterly budget -to -actual financial results as well as the investment portfolio reports for the first quarter of FY 2024-25 ended September 30, 2024. The underlying reports present unaudited quarterly results for the Running Expense (0&M), Sewer Construction, Self -Insurance, and Debt Service Funds. Operating & Maintenance Fund 0&M Fund results through September 30, 2024 show total expenditures of $22.0 million, approximately $2.9 million (11.7%) less than the FY 2024-25 budget. This favorable expense variance is largely attributable to lower than projected year-to-date spending in the supplies and materials, salaries and wages, and purchased property services expenditure line categories. The largest year-to-date favorable budgetary variance currently resides in the supplies and materials category at approximately $1.1 million (29.3%) mainly driven by timing issues attributable to several supplier 1st quarter billings in the utilities and fuel categories being received and processed after the quarter's end. Salaries and wages reported a year-to-date favorable variance of approximately $0.7 million mainly due a higher than budgeted vacancy rate (6.7% as of September 30, 2024 versus budgeted 3.0%) and incurring less overtime and temporary staffing support costs than projected through the 1st quarter. Lastly, purchased property services has a year-to-date favorable budgetary variance of $0.6 million (27.2%) attributable to lower than projected spending on general repairs and maintenance, household hazardous waste disposal costs falling short of anticipated rebounds in participation rates, and lower than anticipated software support costs through the 1st quarter. In the aggregate, the 0&M fund's revenues are in line with budget projections. More information on revenue variance trends will be known when the Central San receives its sewer service charges, which comprise the bulk of revenues, in December, April and June. 11Page December 5, 2024 Regular Board Meeting Agenda Packet - Page 29 of 274 A11M�CENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 1 -Executive Summary Sewer Construction Fund Sewer Construction Fund results for the fiscal year to date show total capital project expenditures of $18.5 million, or 22.8% of the total adopted budget of $80.7 million. The Sewer Construction Fund's FY 2024-25 adopted budget of $80.7 million plus the inclusion of carryforward capital project appropriations from the prior year of $50.3 million brings the total adjusted budget for FY 2024-25 to $131.0 million. After accounting for budgetary carryforwards, year to date results show a favorable variance to budget of $3.9 million (17.4%) and a usage of 14.1% of the amended annual budget. The significant budgetary carryforward was, at least initially, primarily caused by two factors: (1) ripple effects from global supply -chain difficulties caused by international responses to the COVID-19 pandemic and thereafter the Russia -Ukraine conflict delaying multi -year projects, and (2) postponements to the large debt -financed Solids Handling Facilities Improvement Project as Central San weighed alternatives to continuing with long-standing incineration methods. Over the past few budgets Central San has taken measures to reduce this carryforward, which has proven to be partially effective, as carryforward fell from $78.8 million in the prior year to $50.3 million in the current year. The overall favorable year-to-date expenditure variance of $3.9 million is comprised of favorable variances in the collection program ($10M), contingency program ($1.0M), general improvements ($0.8M), and recycled water ($0.3M), partially offset by a temporary interim unfavorable variance in the treatment program ($1.2M). Notable projects with year-to-date favorable spending variances in the collection program include Pump Stations Upgrades Ph.2 ($0.6M), Buchanan Lift Stations Abandonment & Sewer ($0.5M), and Martinez Urgent Force Main Replacement ($0.4M). Delays in the delivery of equipment due to changing regulations have stalled progress on the Pump Stations project but are expected to resolve in the coming months. Both the Buchanan and Martinez Urgent Force projects have been delayed due permitting issues. The Martinez Urgent Force permitting issues have since been resolved and with the recommencement of construction activities, is expected to progress on track for the remainder of the fiscal year. Expenditure details by project are shown in pages 15-18 of this report. The Sewer Construction Fund reported revenues of $2.7 million (excluding SRF loan proceeds), a favorable variance of $0.2 million from year-to-date budgeted revenues of $2.5 million (excluding SRF loan proceeds). The favorable variance is primarily attributable to favorable variances in investment income of $0.5 million partially offset by unfavorable variances in 2 1 P a g e December 5, 2024 Regular Board Meeting Agenda Packet - Page 30 of 274 A11M�CENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 1 -Executive Summary capacity fees of $0.3 million. Investment income came in higher than budgeted due to higher than anticipated investment balances and slightly elevated fixed income investment yields during the fiscal year to date. Investment Portfolio Highlights In accordance with Section 53646 of the California Government Code as well as Central San's Investment Policy, the Finance Division is required to submit an investment report to the General Manager and Board of Directors at least quarterly. The investments held by Central San for the quarter ended September 30, 2024 are presented in separate Investment Portfolio Reports for each fund on pages 24-26 of this consolidated report. Pursuant to the Investment Policy and state law, the Investment Portfolio Report presents the following information: type of investment, issuer, date of maturity, par (or face) and dollar amount invested on all securities, as well as the current market value as of the date of the report. Through the first quarter of FY 2024-25, the 0&M Fund investment portfolio generated approximately $0.2 million in investment income, 70.8% higher than budgetary estimates. The Sewer Construction Fund portfolio reported investment income of $1.6 million, outpacing budgetary estimates of approximately $1.1 million by 41.8%. As expected, the Federal Reserve Bank lowered its target rate range by 50 basis points to 4.75% - 5.00%. The effects of this decision have materialized in lower investment yields across shorter term US Treasury Securities since the September 18th announcement but have yet to influence the interest income accruing to Central San. The bulk of securities comprising the Central San's portfolio were purchased, either directly through its investment custodian or indirectly via the Local Agency Investment Fund (LAIF), in a higher interest rate environment. The weighted average yield for directly held US Treasury securities (which comprise 75.9% of investment balances as of September 30, 2024) in the first quarter was 5.12%. This yield is buoyed by Treasuries purchased in early 2024, while recent purchases (post rate cut) have seen yields below 5%. Actual investment income is more likely to converge with budgeted estimates later in the fiscal year, when investment maturities are reinvested in the lower rate environment. Central San invests its remaining balances (24.1%) in LAIF, which allocates its investments amongst the following security types as of September 30, 2024: US Treasuries (55.5%), US Agency Notes (25.7%), CDs and Bank Notes (8.8%), Commercial Paper (6.1%), and other investments (3.9%). The published apportionment rate, total returns on investment less fees and 3 1 P a g e December 5, 2024 Regular Board Meeting Agenda Packet - Page 31 of 274 A11M�CENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 1 -Executive Summary expenses, for the quarter ended was 4.71% with an average investment yield of 4.58% as of September 30, 2024. Central San's investment balance in LAIF has fallen in the first quarter as it draws on LAIF to meet its liquidity needs until the receipt of large inflows in December; $53.6 million as of June 30, 2024 as compared to $34.1 million as of September 30, 2024. As of September 30, 2024, Central San was holding about 24.1% of its investment portfolio, or $34.1 million, in LAIF, under the maximum amount permitted by state guidelines ($75.0 million). Central San investments in US Treasuries had a maximum maturity horizon of four months, compliant with a maximum maturity limit of five years. Central San's investment portfolio is compliant with the Board's adopted policy regarding investments as of the quarter ended September 30, 2024. Furthermore, as a statement of compliance, Central San is expected to meet expenditure requirements for the next six (6) months from a combination of maturing investments and budgeted revenues. 4 1 P a g e December 5, 2024 Regular Board Meeting Agenda Packet - Page 32 of 274 CENTRAL 5AN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 2 -Financial Results Summary by Fund YTD Category Budget Fund Revenues 0&M $ 1,251,712 Sewer Construction* 2,512,289 Self Insurance 118,531 Debt Service - Total $ 3,882,531 $ 4,668,637 $ 786,106 Fund Expenses YTD Actual $ 1,251,255 2,664,811 752,571 YTD Annual YTD Variance Annual Budget Variance ($) (%) Budget Realized (%) (457) 152,522 634,041 0&M $ 24,921,121 $ 22,012,845 $ 2,908,277 Sewer Construction** 22,349,722 18,468,027 3,881,694 Self Insurance 1,846,375 1,689,383 156,992 Debt Service 7,525,219 7,410,375 114,844 Total $ 56,642,437 $ 49,580,630 $ 7,061,807 *Budgeted capital revenue excludes non -revenue debt proceeds of $39 million presented in budget book. **Includes carryforward of $50.3 million in addition to $80.7 million approved expenditures for FY24-25 0.0% $ 98,178,729 6.1% 82,786,306 534.9% 2,333,088 8,815,875 $ 192,113,998 11.7% $ 95,987,159 17.4% 131,032,228 8.5% 2,420,500 1.5% 8,815,875 $ 238,255,762 YTD Budget -to -Actual Revenues by Fund YTD Budget -to -Actual Expenses by Fund s�saronw s��uJ.uou 520.04aam stsAonwl4 s[.swnao S [.DRJ.000 Swu.uw 5140W,1100 Sn00.0.404 .. MM s o�M1[ Sn..r [uµ,Wy[Lgq' SM1lfl���..�.• QrN Sen' P@N Sn.vr Son.V�[�on" Sr]floav!:ii:e Fund Furv7 .4YU .I-W sY@ .tt0 1.3% 3.2% 32.3% 0.0% 22.9% 14.1% 69.8% 84.1% December 5, 2024 Regular Board Meeting Agenda Packet - Page 33 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 3 - Operations & Maintenance Fund Revenues by Source - Summary Level QTD YTD Annual QTD QTD QTD Variance YTD YTD YTD Variance Annual Budget Category Budget Actual Variance ($] % Budget Actual Variance ($) % Budget Realized(%) Operating Revenues: Sewer Service Charge Revenue $ 45,462 $ 95,808 $ 50,346 110.7% $ 45,462 $ 95,808 $ 50,346 110.7% $ 73,532,729 0.1% Sewage Treatment Cost Sharing - - - - - - 18,800,000 0.0% Miscellaneous Service Charge 417,500 213,009 (204,491) -49.0% 417,500 213,009 (204,491) -49.0% 2,356,000 9.0% Non -Operating Revenues: Permit and Inspection Fees 457,000 510,196 53,196 11.6% 457,000 510,196 53,196 11.6% 1,828,000 27.9% Other Non Operating Income 242,750 280,214 37,464 15.4% 242,750 280,214 37,464 15.4% 1,009,000 27.8% Investment Income 89,000 152,029 63,029 70.8% 89,000 152,029 63,029 70.8% 653,000 23.3% Total Revenue $ 1,251,712 $ 1,251,255 $ (457) 0.0% $ 1,251,712 $ 1,251,255 $ (457) 0.0% $ 98,178,729 1.3% Year -to -Date Revenues by Source $600.000 $500,000 $400,000 $300.000 V00.000 $100,000 mo A�� rim Sewer Service charge Revenue Sewage Treatment Cost Sharing Miscellaneous Service Charge Permit and Inspection Fees Other Not Operating Income ■ YTD ■ YTD Budget Actuai Investment hxome December 5, 2024 Regular Board Meeting Agenda Packet - Page 34 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 3 - Operations & Maintenance Fund Revenues by Source - Detail Level Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) % Budget Actual Variance ($) (%) Budget Sewer Service Charge Revenue Sewer Service Charge Counter $ 53,039 $ 99,775 $ 46,737 88.1% $ 53,039 $ 99,775 $ 46,737 88.1% $ 212,154 47.0% Sewer Service Charge County - - - - 72,048,255 0.0% Sewer Service Charge Direct - - 1,302,628 0.0% Sewer Service Charge Prior (7,577) (3,967) 3,610 -47.6% (7,577) (3,967) 3,610 -47.6% (30,308) 13.1% Sewage Treatment Cost Sharing - - - - - - 18,800,000 0.0% Miscellaneous Service Charges Septic Tank Dumping 11,250 24,758 13,508 120.1% 11,250 24,758 13,508 120.1% 45,000 55.0% Sales 250 - (250) -100.0% 250 - (250) -100.0% 1,000 0.0% Other Service Charges - 2,076 2,076 - 2,076 2,076 190,000 1.1% Recycled Water 132,500 168,535 36,035 27.2% 132,500 168,535 36,035 27.2% 530,000 31.8% Satellite Water Recycling - - - - - - - Stormwater Program - - - - 496,000 0.0% Household Hazardous Waste 273,500 17,640 (255,860) -93.6% 273,500 17,640 (255,860) -93.6% 1,094,000 1.6% Permit & Inspection Fees Permit/Application Fees 137,500 130,200 (7,300) -5.3% 137,500 130,200 (7,300) -5.3% 550,000 23.7% Overtime Inspection 2,500 1,128 (1,372) -54.9% 2,500 1,128 (1,372) -54.9% 10,000 11.3% Side Sewer Inspection 275,000 331,801 56,801 20.7% 275,000 331,801 56,801 20.7% 1,100,000 30.2% Industrial Permit Fees 30,750 38,802 8,052 26.2% 30,750 38,802 8,052 26.2% 123,000 31.5% New Industry Permit Fees 5,000 2,858 (2,142) -42.8% 5,000 2,858 (2,142) -42.8% 20,000 14.3% Annexation Charges 6,250 5,407 (843) -13.5% 6,250 5,407 (843) -13.5% 25,000 21.6% Other Non -Operating Income MVSD P2 Program - - - - - 38,000 0.0% Pretreatment Program Fine 500 - (500) -100.0% 500 - (500) -100.0% 2,000 0.0% Lease Rental Income 220,000 253,392 33,392 15.2% 220,000 253,392 33,392 15.2% 880,000 28.8% Miscellaneous Income 8,000 21,362 13,362 167.0% 8,000 21,362 13,362 167.0% 32,000 66.8% Right of Way Fees 3,000 5,460 2,460 82.0% 3,000 5,460 2,460 82.0% 12,000 45.5% Reimbursements 11,250 - (11,250) -100.0% 11,250 - (11,250) -100.0% 45,000 0.0% Investment Income 89,000 152,029 63,029 70.8% 89,000 152,029 63,029 70.8% 653,000 23.3% Total Revenues $ 1,251,712 $ 1,251,255 $ (457) 0.0% $ 1,251,712 $ 1,251,255 $ (457) 0.0% $ 98,178,729 1.3% December 5, 2024 Regular Board Meeting Agenda Packet - Page 35 of 274 iCENTRAL 5AN 5019 IMHOFF PLACE, MAQTINEP. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Type - Summary Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) % Budget Actual Variance ($) % Budget % Salaries & Wages $ 12,872,740 $ 12,122,946 $ 749,794 5.8% $ 12,872,740 $ 12,122,946 $ 749,794 5.8% $ 47,486,627 25.5% Employee Benefits 3,663,672 3,513,090 150,582 4.1% 3,663,672 3,513,090 150,582 4.1% 14,921,532 23.5% Unfunded Liability Costs 146,320 152,921 (6,601) -4.5% 146,320 152,921 (6,601) -4.5% 597,404 25.6% Purchased Property Services 2,167,790 1,577,414 590,376 27.2% 2,167,790 1,577,414 590,376 27.2% 8,266,110 19.1% Other Purchased Services 1,761,001 1,386,911 374,091 21.2% 1,761,001 1,386,911 374,091 21.2% 8,086,042 17.2% Supplies & Materials 3,899,184 2,755,828 1,143,356 29.3% 3,899,184 2,755,828 1,143,356 29.3% 14,967,135 18.4% Other Expenses 410,415 503,735 (93,321) -22.7% 410,415 503,735 (93,321) -22.7% 1,662,309 30.3% Total Expenses $ 24,921,121 $ 22,012,845 $ 2,908,277 11.7% $ 24,921,121 $ 22,012,845 $ 2,908,277 11.7% $ 95,987,159 22.9% $15,000,000 $10,000,000 $5,000,000 Year -to -Date Expenses by Type Salaries & Wages Flnpinyee Re..ne.flts Unfunded Liability Purchased Property Other Purchased Costs Services Services YTD YTD Budget Actual Supplies & Materials Other Expenses 8 1 P a 6eecember 5, 2024 Regular Board Meeting Agenda Packet - Page 36 of 274 iCENTRAL 5AN 5019 IMHOFF PLACE, MAQTINEP. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 3 - Operations & Maintenance Fund Category QTD Budget QTD Actual Expenses by Type - Detail QTD QTD Variance YTD Variance ($) (%) Budget YTD Actual YTD Variance ($] YTD Variance (%) Annual Budget Annual Budget Realized (%) Salaries & Wages FTE Regular Pay $ 11,275,383 $ 10,685,434 $ 589,950 5.2% $ 11,275,383 $ 10,685,434 $ 589,950 5.2% $ 42,607,794 25.1% Temporary Pay 1,116,870 709,171 407,699 36.5% 1,116,870 709,171 407,699 36.5% 3,020,016 23.5% Premium Pay 828,087 705,306 122,781 14.8% 828,087 705,306 122,781 14.8% 3,249,217 21.7% Board Fees 16,650 13,800 2,850 17.1% 16,650 13,800 2,850 17.1% 66,600 20.7% Other (364,250) 9,236 (373,486) 102.5% (364,250) 9,236 (373,486) 102.5% (1,457,000) -0.6% Total Salaries & Wages 12,872,740 12,122,946 749,794 5.8% 12,872,740 12,122,946 749,794 5.8% 47,486,627 25.5% Employee Benefits Insurance Premiums 2,394,882 2,188,174 206,708 8.6% 2,394,882 2,188,174 206,708 8.6% 9,849,740 22.2% Employer Taxes 189,854 203,832 (13,978) -7.4% 189,854 203,832 (13,978) -7.4% 702,192 29.0% Employer Retirement Contributions 2,501,708 2,099,737 401,971 16.1% 2,501,708 2,099,737 401,971 16.1% 9,420,835 22.3% OPEB Contributions 471,250 471,250 0.0% 471,250 471,250 0.0% 1,885,000 25.0% Benefit Adjustments (1,894,022) (1,449,904) (444,118) 23.4% (1,894,022) (1,449,904) (444,118) 23.4% (6,936,235) 20.9% Total Employee Benefits 3,663,672 3,513,090 150,582 4.1% 3,663,672 3,513,090 150,582 4.1% 14,921,532 23.5% Unfunded Liability Costs Pension 90,070 96,671 (6,601) -7.3% 90,070 96,671 (6,601) -7.3% 372,404 26.0% OPEB 56,250 56,250 (0) 0.0% 56,250 56,250 (0) 0.0% 225,000 25.0% Total Unfunded Liability Costs 146,320 152,921 (6,601) -4.5% 146,320 152,921 (6,601) -4.S% S97,404 25.6%, Purchased Property Services Repairs & Maintenance 1,428,340 1,156,370 271,970 19.0% 1,428,340 1,156,370 271,970 19.0% 5,308,310 21.8% Hauling & Disposal 328,725 68,641 260,084 79.1% 328,725 68,641 260,084 79.1% 1,314,900 5.2% Security 186,863 172,332 14,530 7.8% 186,863 172,332 14,530 7.8% 747,450 23.1% Rentals 79,025 79,972 (947) -1.2% 79,025 79,972 (947) -1.2% 316,100 25.3% Cleaning 144,213 100,099 44,114 30.6% 144,213 100,099 44,114 30.6% 576,850 17.4% Construction 625 625 100.0% 625 625 100.0% 2,500 0.0% Total Purchased Property Services 2,167,790 1,577,414 590,376 27.2% 2,167,790 1,577,414 590,376 27.2% 8,266,110 19.1% Other Purchased Services Professional Services 415,363 460,878 (45,515) -11.0% 415,363 460,878 (45,515) -11.0% 1,725,977 26.7% Technical Services 662,945 305,197 357,748 54.0% 662,945 305,197 357,748 54.0% 2,658,280 11.5% Other Purchased Services 682,693 620,836 61,857 9.1% 682,693 620,836 61,857 9.1% 3,701,785 16.8% Total Other Purchased Services 1,761,001 1,386,911 374,091 21.2% 1,761,001 1,386,911 374,091 21.2% 8,066,042 17.2% Supplies & Materials Utilities & Fuel 2,204,350 1,487,244 717,106 32.5% 2,204,350 1,487,244 717,106 32.5% 8,817,400 16.9% Chemicals 820,000 619,952 200,048 24.4% 820,000 619,952 200,048 24.4% 3,280,000 18.9% General Supplies 874,834 648,633 226,201 25.9% 874,834 648,633 226,201 25.9% 2,869,735 22.6% Total Supplies & Materials 3,899,184 2,755,828 1,143,356 29.3% 3,899,184 2,755,828 1,143,356 29.3% 14,967,13S 18.4%, Other Expenses Memberships 147,551 411,465 (263,914) -178.9% 147,551 411,465 (263,914) -178.9% 623,255 66.0% Training & Meetings 222,289 85,182 137,106 61.7% 222,289 85,182 137,106 61.7% 868,754 9.8% Miscellaneous Other 40,575 7,088 33,487 82.5% 40,575 7,088 33,487 82.5% 170,300 4.2% Total Other Expenses 410,415 503,735 (93,321) -22.7% 410,415 503,735 (93,321) -22.7% 1,662,309 30.3% Total Expenses $ 24,921,121 $ 22,012,845 $ 2,908,277 11.7% $ 24,921,121 $ 22,012,84S $ 2,908,277 11.7% $ 95,987,159 22.9% 9 I P a6ecember 5, 2024 Regular Board Meeting Agenda Packet - Page 37 of 274 iCENTRAL 5AN 5019 IMHOFF PLACE, MAQTINEP. CA 94553-4392 QTD Category Budget Department Executive Governance $ 846,659 Administration 5,974,205 Engineering and Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Summary (by Department) Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Variance Annual Realized Actual Variance ($] (%) Budget Actual Variance ($) (%) Budget $ 645,988 $ 200,671 23.7% $ 846,659 $ 645,988 $ 200,671 23.7% $ 3,951,510 16.3% 5,329,932 644,273 10.8% 5,974,205 5,329,932 644,273 10.8% 22,454,528 23.7% Technical Services 4,055,095 4,195,740 (140,645) -3.5% 4,055,095 4,195,740 (140,645) -3.5% 15,595,650 26.9% Operations 13,470,431 11,444,710 2,025,721 15.0% 13,470,431 11,444,710 2,025,721 15.0% 51,851,982 22.1% Recycled Water Program 574,732 396,474 178,258 31.0% 574,732 396,474 178,258 31.0% 2,133,490 18.6% Total Expenses $ 24,921,121 $ 22,012,845 $ 2,908,277 11.7% $ 24,921,121 $ 22,012,845 $ 2,908,277 11.7% $ 95,987,159 22.9% S14,000.D00 $12,00D,ODO S10,000,DDO $8,000,000 $6,000,000 $4,000,000 $2,000,000 Year -to -Date Expenses by Department Executive GavernAAce Administration Engineering and Technical Services ■ YTD a YTD Budget Actual Operatlans Recycled MAP r P rog ram 101Page December 5, 2024 Regular Board Meeting Agenda Packet - Page 38 of 274 iCENTRAL 5AN 5019 IMHOFF PLACE, MAQTINEP. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Detail (by Division) QTD Organizational Unit Budget Executive Governance Office of the General Manager $ 478,155 $ Office of the Secretary of the District 290,510 Board of Directors 77,994 Administration Office of the Director of Finance and Administration 200,201 Finance Division 913,031 Human Resources Division 1,538,601 Purchasing Division 258,406 Risk Management Program 449,060 Public Info/Comm. Services & Intergov Relations Division 613,847 Information Technology Division 2,001,059 Engineering & Technical Services Office of the Director of Engineering & Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Variance Annual Realized Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) 282,894 $ 195,262 40.8% $ 478,155 $ 282,894 $ 195,262 40.8% $ 1,882,901 15.0% 313,046 (22,536) -7.8% 290,510 313,046 (22,536) -7.8% 1,727,191 18.1% 50,049 27,945 35.8% 77,994 50,049 27,945 35.8% 341,417 14.7% 221,901 (21,700) -10.8% 200,201 221,901 (21,700) -10.8% 767,541 28.9% 781,525 131,505 14.4% 913,031 781,525 131,505 14.4% 3,615,073 21.6% 1,357,656 180,945 11.8% 1,538,601 1,357,656 180,945 11.8% 6,014,379 22.6% 254,496 3,910 1.5% 258,406 254,496 3,910 1.5% 989,345 25.7% 365,955 83,105 18.5% 449,060 365,955 83,105 18.5% 1,745,299 21.0% 468,937 144,910 23.6% 613,847 468,937 144,910 23.6% 2,546,290 18.4% 1,879,463 121,597 6.1% 2,001,059 1,879,463 121,597 6.1% 6,776,601 27.7% Technical Services 63,485 54,666 8,818 Planning & Developmental Services 1,613,040 1,726,334 (113,295) Capital Projects Division (132,765) (182,757) 49,993 Environmental & Regulatory Compliance 2,511,335 2,597,496 (86,161) Operations Office of the Director of Operations 339,786 259,668 80,118 Collection System Operations Division 4,831,533 4,599,473 232,059 Treatment Plant Operations Division 4,541,867 3,367,269 1,174,599 Treatment Plant Maintenance Division 3,272,893 2,781,616 491,277 Operations Optimization Division 484,351 436,684 47,667 Recycled Water Recycled Water - General 59,725 36,708 23,017 Treatment Plant 289,625 239,467 50,158 Distribution System 110,425 94,425 16,000 Residential Fill Station 114,957 25,875 89,082 Total Expenses $ 24,921,121 $ 22,012,845 $ 2,908,277 13.9% 63,485 54,666 8,818 -7.0% 1,613,040 1,726,334 (113,295) -37.7% (132,765) (182,757) 49,993 -3.4% 2,511,335 2,597,496 (86,161) 23.6% 339,786 259,668 80,118 4.8% 4,831,533 4,599,473 232,059 25.9% 4,541,867 3,367,269 1,174,599 15.0% 3,272,893 2,781,616 491,277 9.8% 484,351 436,684 47,667 38.5% 59,725 36,708 23,017 17.3% 289,625 239,467 50,158 14.5% 110,425 94,425 16,000 77.5% 114,957 25,875 89,082 11.7% $ 24,921,121 $ 22,012,845 $ 2,908,277 13.9% 386,466 14.1% -7.0% 5,981,049 28.9% -37.7% (444,468) 41.1% -3.4% 9,672,604 26.9% 23.6% 1,286,966 20.2% 4.8% 18,715,786 24.6% 25.9% 17,755,940 19.0% 15.0% 12,385,099 22.5% 9.8% 1,708,191 25.6% 38.5% 238,900 15.4% 17.3% 1,158,500 20.7% 14.5% 441,700 21.4% 77.5% 294,390 8.8% 11.7% $ 95,987,159 22.9% 111Page December 5, 2024 Regular Board Meeting Agenda Packet - Page 39 of 274 ENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 4 - Sewer Construction Fund Revenues by Source - Summary Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($] (%) Budget Actual Variance ($] (%) Budget (%) Sewer Service Charges $ 29,539 $ 59,724 $ 30,186 102.2% $ 29,539 $ 59,724 $ 30,186 102.2% $ 45,918,306 0.1% Other Capital Revenues 2,482,750 2,605,086 122,336 4.9% 2,482,750 2,605,086 122,336 4.9% 36,868,000 7.1% Total Revenue* $ 2,S12,289 $ 2,664,811 $ 152,522 6.1% $ 2,512,289 $ 2,664,811 $ 152,S22 6.1% $ 82,786,306 3.2% *Excludes non -revenue SRF debt proceeds of $39 million presented in budget book. $3.000,000 $1,500,000 $2,000,000 $ I,500.00Q $1,000,000 $500,000 Year -to -Date Revenues by Source Sewer Service Charges Other Capital Revenues r YTD ■ Y rD Budget Actual 121 December 5, 2024 Regular Board Meeting Agenda Packet - Page 40 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 4 - Sewer Construction Fund Revenues by Source - Detail Annual QTD YTD Budget QTD QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%] Budget (%] Sewer Service Charges (SSC) Over -the -Counter $ 34,462 $ 62,198 $ 27,736 80.5% $ 34,462 $ 62,198 $ 27,736 80.5% $ 137,846 45.1% County Allocated - - - - - - 44,953,780 0.0% Direct Billed - - 846,372 0.0% Prior Year Adjustment (4,923) (2,473) 2,450 -49.8% (4,923) (2,473) 2,450 -49.8% (19,692) 12.6% Other Capital Revenues Facilities Capacity Fees - Gravity Zone 1,250,000 969,557 (280,443) -22.4% 1,250,000 969,557 (280,443) -22.4% 5,000,000 19.4% Capacity Use Charge 12,500 - (12,500) -100.0% 12,500 (12,500) -100.0% 50,000 0.0% Secured Property Tax - - 15,166,000 0.0% Unsecured Property Tax - - - - 730,000 0.0% Alhambra Valley Assessment D - 8,578 8,578 - 8,578 8,578 - Investment Income 1,126,000 1,596,537 470,537 41.8% 1,126,000 1,596,537 470,537 41.8% 4,785,000 33.4% Other Government Revenue - Concord - - - - - - 10,760,000 0.0% Overtime Inspection 1,500 2,150 650 43.3% 1,500 2,150 650 43.3% 6,000 35.8% Plan Review 17,500 24,998 7,498 42.8% 17,500 24,998 7,498 42.8% 70,000 35.7% Main Lines Inspection Fees 75,000 3,267 (71,733) -95.6% 75,000 3,267 (71,733) -95.6% 300,000 1.1% Miscellaneous Income 250 - (250) -100.0% 250 - (250) -100.0% 1,000 0.00/0 Total Revenues* $ 2,512,289 $ 2,664,811 $ 152,522 6.1% $ 2,512,289 $ 2,664,811 $ 152,522 6.1% $ 82,786,306 3.2% * Exlcudes non -revenue SRF debt proceeds of $39 million presented in budget book December , 2024 Regular Board Meeting Agenda Packet - Page 41 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MARTINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Summary (by Program) Cumulative Cumulative Total Project FY 2024-2025 FY 2024-2025 FY 2024-2O2S FY 2024-2025 FY 2024-2025 FY 2024-2O2S Program Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual I Remaining I Budgets Actuals FY 2024-25 Budget Adjustments Budget Expenditures Expenditures Budget Collection System (CS) $ 86,299,256 $ 55,454,942 $ 30,844,314 $ 23,327,000 $ 1,200,000 $ 24,527,000 $ 55,371,314 $ 5,110,074 $ 50,261,239 Treatment Plant (TP) 120,410,332 107,169,219 13,241,113 46,900,000 (250,000) 46,650,000 59,891,113 12,074,175 47,816,938 General Improvements (GI) 16,899,000 13,255,376 3,643,624 5,235,OOO 250,000 5,485,000 9,128,624 1,091,842 8,036,782 Recycled Water (RW) 43,687,000 41,095,823 2,591,177 250,000 250,000 2,841,177 191,936 2,649,241 CIB Contingency - - - 5,000,000 (1,200,000) 3,800,000 3,800,000 - 3,800,000 Total $ 267,295,588 $ 216,975,360 $ 50,320,228 $ 80,712,000 $ $ 80,712,000 $ 131,032,228 $ 18,468,027 $ 112,564,200 Capital Improvement Budget Quarterly Results by Program $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 Collection System (CS) Treatment Plant (TP) General Improvements (GI) Recycled Water (RW) Program ■ Budgeted YTD Expenditures ■ Actual YTD Expenditures December e2024 Regular Board Meeting Agenda Packet - Page 42 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project) A B C (A-B) D E F (D+E) G (C+D+E) H I (G-H) Cumulative Cumulative Total Project FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 Prior Year Prior Year I Carryforwardto I Adopted Budget I Adjusted I Approved I Actual Remaining Budgets Actuals FY 2024-25 I Budget Adjustments Budget Expenditures Ex enditures Budget TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 $ 8,252,000 $ 7,952,531 $ 299,469 $ - $ - $ - $ 299,469 $ 201,206 $ 98,263 8443 LG Diameter Pipe line Inspection 1,295,000 727,469 567,531 400,000 1,797,000 2,197,000 2,764,531 19,337 2,745,194 8444 Force Main Inspection Program 625,000 27,736 597,264 - (597,000) (597,000) 264 999 (735) 8447 Pump Station Security Improvement 521,000 1,472 519,528 100,000 - 100,000 619,528 - 619,528 8450 Development Sewerage Support 5,886,316 5,725,566 160,750 927,000 - 927,000 1,087,750 213,360 874,390 8457 Pump Station Upgrades - Ph. 2 24,650,000 18,937,201 5,712,799 4,500,000 - 4,500,000 10,212,799 2,170,128 8,042,670 100006 Contractual Assessment District Project Financing 532,940 - 532,940 100,000 (493,356) (393,356) 139,584 - 139,584 100007 39-Inch Main Trunk No. 1 Renovation 1,000,000 258,409 741,591 1,500,000 - 1,500,000 2,241,591 36,665 2,204,926 100017 S. Ramon Pump Station Electrical Upgrades 1,913,000 1,912,672 328 - - - 328 4,155 (3,826) 100023 Walnut Creek Sewer Renovation, Ph. 16 6,379,000 6,484,383 (105,383) - - - (105,383) (183,494) 78,111 100024 South Orinda Sewer Renovations, Ph. 9 750,000 753,988 (3,988) - - - (3,988) 3,920 (7,908) 100025 Lafayette Sewer Renovations, Ph. 15 750,000 639,880 110,120 - - - 110,120 85,152 24,968 100028 Sewer System Infrastructure Plan 1,600,000 545,051 1,054,949 - - - 1,054,949 140,015 914,934 100037 Orinda-Moraga Pump Station Architectural Improv. 450,000 53,320 396,680 - - - 396,680 - 396,680 100039 Collection System Sewer Renovation Ph-2 9,353,000 183,063 9,169,937 10,400,000 (950,000) 9,450,000 18,619,937 37,925 18,582,012 100041 Buchanan Lift Stations Abandonment & Sewer 1,050,000 463,951 586,049 2,000,000 - 2,000,000 2,586,049 135,349 2,450,700 100042 Pump Sation Upgrades, Phase 2B 5,700,000 1,962,026 3,737,974 2,500,000 - 2,500,000 6,237,974 184,374 6,053,600 100044 Collection System Modeling Support 245,000 19,244 225,756 - - - 225,756 41,186 184,570 100049 Dowtown Walnut Creek Sewer Renovation -Locust 6,335,000 5,552,082 782,918 - - - 782,918 (195,589) 978,507 100050 CCTAA-Line Relocation 1,100,000 513,503 586,497 - - - 586,497 182,096 404,401 100052 No. Orinda Sewer Renovations, Ph.9 650,000 638,392 11,608 - - - 11,608 59,940 (48,332) 100059 Collection System Planning 2023+ 200,000 110,442 89,558 - - - 89,558 25,728 63,829 100060 Pump Station Equipment & Piping Replacement 2023+ 200,000 18,563 181,437 - - - 181,437 - 181,437 100061 Maintenance Access Cover Modifications 2023+ 400,000 271,300 128,700 300,000 - 300,000 428,700 15,120 413,580 100065 Tappan Terrace Sewer Renovation 650,000 329,640 320,360 - - - 320,360 161,553 158,807 100066 Martinez Urgent Force Main Replacement 3,962,000 766,733 3,195,267 - - - 3,195,267 1,430,070 1,765,198 100068 Pleasant Hill Sewer Renovations Ph. 3 650,000 255,753 394,247 - - - 394,247 220,208 174,039 100070 Cedar Lane Sewer Renovations 600,000 18,480 581,520 600,000 - 600,000 1,181,520 38,137 1,143,383 100072 Lake Cascade Sewer Renovation 600,000 332,092 267,908 - - - 267,908 5,457 262,450 100075 Pleasant Hill Sewer Renovations, Ph. 4 - - - 250,000 250,000 250,000 61,580 188,420 100076 Walnut Creek Sewer Renovations, Ph. 17 - - - - 250,000 250,000 250,000 8,496 241,504 100077 Lafayette Sewer Renovations, Ph. 16 - - - - 250,000 250,000 250,000 6,998 243,002 100081 Willow Drive CAD - - - 211,570 211,570 211,570 - 211,570 100082 Charles Hill Rd., CAD - - - - 281,786 281,786 281,786 - 281,786 100083 Storm Damage Repair 200,000 200,000 200,000 200,000 Total CS Program $ 86,299,256 $ 55,454,942 $ 30,844,314 $ 23,327,000 $ 1,200,000 $ 24,527,000 $ 55,371,314 $ 5,110,074 $ 50,261,239 December , 2024 Regular Board Meeting Agenda Packet - Page 43 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C (A-B) D E F (D+E) G (C+D+E) H I (G-H) Cumulative Cumulative Total Project FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY2O24-25 Budget Adjustments Bud et Expenditures Ex enditures Budget TYPE TP Treatment Plant 7315 Applied Research and Innovations $ 2,157,274 $ 1,672,630 $ 484,644 $ - $ (479,083) $ (479,083) $ 5,561 $ 5,561 $ (0) 7341 WC/Grayson Creek Levee Rehab 2,350,000 1,286,533 1,063,467 - - - 1,063,467 49,922 1,013,545 7348 Solids Handling Facility Improvements 41,518,687 50,787,238 (9,268,551) 39,000,000 - 39,000,000 29,731,449 8,946,750 20,784,699 7349 Aeration & Energy Upgrade 4,850,000 4,591,332 258,668 - - - 258,668 1,160 257,508 7357 Plant Wide Instrumentation Upgrade 521,000 431,703 89,297 - - - 89,297 - 89,297 7369 Piping Renovation - Phase 10 5,645,000 6,002,469 (357,469) - - - (357,469) (121,060) (236,409) 7370 Annual Infrastructure Replacement 4,105,000 4,367,336 (262,336) 200,000 - 200,000 (62,336) 132,321 (194,657) 7373 Fire Protection System Ph. 3 1,100,000 1,103,407 (3,407) - - - (3,407) 1,404 (4,811) 100001 UPCCAA Urgent Projects FY2020-25 1,200,000 817,389 382,611 200,000 - 200,000 582,611 40,982 541,629 100010 Air Conditioning and Lighting Renovation 450,000 521,878 (71,878) - - - (71,878) 48,626 (120,504) 100011 Plant Electrical Replacement and Rehabilitation 1,058,371 533,824 524,547 - - - 524,547 7,488 517,059 100012 UV Disinfection Replacement 5,500,000 2,722,934 2,777,066 500,000 - 500,000 3,277,066 45,467 3,231,599 100014 MRC Building Modifications & Maintenance Shops Imp 1,400,000 398,420 1,001,580 800,000 - 800,000 1,801,580 41,701 1,759,879 100015 Electric Blower Improvements 14,095,000 14,302,177 (207,177) - - - (207,177) (592,016) 384,839 100019 Aeration Basins Diffuser Replc. Ph. 1 13,480,000 8,292,002 5,187,998 1,500,000 - 1,500,000 6,687,998 2,084,480 4,603,519 100022 Wet Weather Basin Improvements 1,900,000 760,925 1,139,075 200,000 - 200,000 1,339,075 47,796 1,291,279 100030 Solids Handling Facility Improv. Ph. 2 2,800,000 1,939,609 860,391 - - - 860,391 90,457 769,934 100032 Steam Renovations, Ph. 1 7,000,000 1,956,328 5,043,672 - - - 5,043,672 299,740 4,743,932 100034 Treatment Plant Safety Enhancement Program 100,000 161,047 (61,047) - - - (61,047) - (61,047) 100040 Electrical Infrastructure Sub55 1,000,000 144,335 855,665 500,000 500,000 1,355,665 45,552 1,310,113 100045 Fire Protection System Phase 4 860,000 727 859,273 - - - 859,273 73,051 786,222 100046 Controls System Upgrades FY 22-26 400,000 66,937 333,063 100,000 - 100,000 433,063 3,180 429,882 100047 Secondary Clarifier and Channel Improvements 1,500,000 249,164 1,250,836 500,000 - 500,000 1,750,836 313,591 1,437,246 100048 Warehouse Seismic Upgrades 500,000 2,717 497,283 500,000 - 500,000 997,283 - 997,283 100051 RAS Piping Renovations 2,020,000 1,976,440 43,560 - - - 43,560 141,597 (98,037) 100054 Aeration Unit 1 Steam Turbine Overhaul 700,000 1,079,008 (379,008) - - - (379,008) - (379,008) 100055 Process Optimization and Efficiency 500,000 383,287 116,713 500,000 - 500,000 616,713 73,786 542,926 100057 Plant Control System 1/0 Replacement Ph3. 3 P&B Bldg 600,000 304,367 295,633 400,000 - 400,000 695,633 89,750 605,883 100058 Treatment Plant Planning 2023 + 250,000 259,674 (9,674) - 229,083 229,083 219,409 60,340 159,069 100069 Odor Control Facilities Improvements 450,000 40,714 409,286 1,000,000 - 1,000,000 1,409,286 62,889 1,346,397 100073 Piping Renovation Phase 11 200,000 10,421 189,579 300,000 - 300,000 489,579 75,080 414,499 100074 Central Chilled Water Plant 200,000 2,246 197,755 400,000 - 400,000 597,755 232 597,522 100078 Nutrient Management 300,000 300,000 300,000 4,347 295,653 Total TP Program $ 120,410,332 $ 107,169,219 $ 13,241,113 $ 46,900,000 $ (250,000) $ 46,650,000 $ 59,891,113 $ 12,074,175 $ 47,816,938 December , 2024 Regular Board Meeting Agenda Packet - Page 44 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C (A-B) D E F (D+E) G (C+D+E) H 1 (G-H) Cumulative Cumulative Total Project FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 I FY 2024-2025 Prior Year Prior Year Carryforward to I Adopted Budget Adjusted I Approved I Actual Remaining Budgets Actuals FY2024-25 Budget Adjustments Budget Expenditures Extienditures Bud et TYPE GI General Improvements 8251 Capital improvement program & Budget Improvement $ 590,000 $ 648,899 $ (58,899) $ 100,000 $ - $ 100,000 $ 41,101 $ 13,714 $ 27,387 8252 FOR E.V. Charging Station 1,290,000 682,202 607,798 1,000,000 1,000,000 1,607,798 70,043 1,537,755 8516 District Equipment Acquisition 2,076,000 1,969,652 106,348 - - - 106,348 68,124 38,224 8517 Vehicle Replacement Program 7,018,000 5,256,552 1,761,448 1,200,000 - 1,200,000 2,961,448 238,720 2,722,728 100003 Property Repairs & Improvements 1,300,000 1,425,566 (125,566) - - (125,566) 287,588 (413,154) 100004 HOB Exterior Repairs 400,000 291,102 108,898 - - - 108,898 - 108,898 100027 Furnishings Replacement 100,000 103,681 (3,681) (3,681) 41,879 (45,560) 100029 Solar Project on Lagiss 600,000 524,502 75,498 - - - 75,498 3,581 71,917 100031 Community Dev. System Replacement 800,000 690,159 109,841 360,000 360,000 469,841 (59,262) 529,103 100033 Security Improvements (FY2021-25) 400,000 223,984 176,016 600,000 - 600,000 776,016 5,924 770,091 100035 Technology Strategic Plan 800,000 466,237 333,763 - - 333,763 38,255 295,507 100056 Net2ero Study 200,000 145,435 54,565 250,000 - 250,000 304,565 - 304,565 100063 IT Development FY 2023+ 900,000 654,300 245,700 550,000 550,000 795,700 214,424 581,276 100064 Capital Legal Services 2023+ 25,000 42,431 (17,431) 75,000 - 75,000 57,569 35,635 21,935 100067 POD Parking Lot Improvements 200,000 114,475 85,525 150,000 150,000 235,525 102,770 132,755 100071 Long Term Wet Weather Resiliency 200,000 16,199 183,801 250,000 250,000 500,000 683,801 26,866 656,935 100079 MVSD Feasibility Study - - - 400,000 - 400,000 400,000 3,580 396,420 100080 Equipment Acquisition FY 2024+ 300,000 - 300,000 300,000 300,000 Total GI Program $ 16,899,000 $ 13,255,376 $ 3,643,624 $ 5,235,000 $ 250,000 $ 5,485,000 $ 9,128,624 $ 1,091,842 $ 8,036,782 171Pa e December, 2024 Regular Board Meeting Agenda Packet - Page 45 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C (A-B) D E F (D+E) G (C+D+E) H I (G-H) Cumulative Cumulative Total Project I FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 FY 2024-2025 I FY 2024-2025 Prior Year Prior Year Carryforward to I Adopted I Budget Adjusted I Approved I Actual Remaining Budgets Actuals FY2024-25 Budget Adjustments Budget Expenditures Ex enditures Budget TYPE RW Recycled Water 7361 Filter Plant & Clearwell Improvements Ph. 1A $ 40,389,000 $ 40,346,182 $ 42,818 $ $ $ $ 42,818 $ 144,950 $ (102,132) 7366 ReW Distribution System Renov. Program 745,000 28S,908 459,092 459,092 18,441 440,651 7368 Water Exchange Project 400,000 142,137 257,863 - - - 257,863 - 257,863 100002 Filter Plant & Clearwell Improvements Ph. 1B 1,950,000 184,510 1,765,490 250,000 250,000 2,015,490 6,652 2,008,838 100036 Zone 1 Recycled Water 2021 203,000 137,087 65,913 - - 65,913 21,892 44,021 Rounding - - - - - - - - Total RW Program $ 43,687,000 $ 41,095,823 $ 2,591,177 $ 250,000 $ $ 250,000 $ 2,841,177 $ 191,936 $ 2,649,241 9990 CONTINGENCY -ALL PROGRAMS $ - $ $ $ S,000,000 $ (1,200,000) $ 3,800,000 $ 3,800,000 $ $ 3,800,000 9990 CONTINGENCY BAL TRANS - CLOSE OUTS $ - $ - $ - $ - $ GRAND TOTAL $ 267,295,S88 $ 216,975,360 $ 50,320,228 $ 80,712,000 $ $ 80,712,000 $ 131,032,228 $ 18,468,027 $ 112,564,200 181Pa e December, 2024 Regular Board Meeting Agenda Packet - Page 46 of 274 ENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 4 - Sewer Construction Fund Capital Budget Transfers (by Project by Month) PROJ. # PROJECTS Jul-24 Au -24 Se -24 Q1 24/25 Contingency Balance $ 5,000,000 100075 Pleasant Hill Sewer Renovations, Ph. 4 $ 250,000 $ - $ - $ 250,000 - 100076 Walnut Creek Sewer Renovations, Ph. 17 250,000 - - 250,000 - 100077 Lafayette Sewer Renovations, Ph. 16 250,000 - - 250,000 - 100039 Collection System Sewer Renovation Ph. 2 (750,000) - (200,000) (950,000) - 8443 Large Diameter Pipeline Inspection Program - 1,797,000 - 1,797,000 - 8444 Force Main Inspection Program - (597,000) - (597,000) - 7315 Applied Research and Innovations - - (479,083) (479,083) - 100058 Treatment Plant Planning 2 0 2 3 + - - 229,083 229,083 - 100071 Long -Term Wet Weather Resiliency - - 250,000 250,000 - 100083 Storm Damage Repair - - 200,000 200,000 - 100006 Contractual Assessement District Proj Financing - - (493,356) (493,356) - 100081 Willow Drive CAD - - 211,570 211,570 - 100082 Charles Hill Rd. CAD - - 281,786 281,786 - 9990 Current year Contingency - (1,200,000) - (1,200,000) 3,800,000 Total $ - 1 $ - 1 $ - 1 $ $ 3,800,000 D4&-h%er,,5V2024 Regular Board Meeting Agenda Packet - Page 47 of 274 CENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 5 - Self Insurance Fund Revenues by Source Annual QTD YTD Budget QTD QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) Sewer Service Charge $ - $ $ $ - $ $ $ 1,858,965 0.0% Insurance Recoveries 6,250 (6,250) -100.0% 6,250 (6,250) -100.0% 25,000 0.0% Subrogation Recoveries - 647,293 647,293 - 647,293 647,293 - Investment Income 112,281 105,278 (7,003) -6.2% 112,281 105,278 (7,003) -6.2% 449,123 23.4% Total Revenues $ 118,531 $ 752,571 $ 634,041 534.9% $ 118,531 $ 752,571 $ 634,041 534.9% $ 2,333,088 32.3% S700,000 $600,000 $7,00.000 $400.000 $300,000 S200,000 5100.ODU it Year -to -Date Revenues by Source Sewer Service Charge Insurance Recoveries (FiHW) Suhrogatinn Recoveries investment Income e YTD m YTD Rudget Actual 201Pa e December, 2024 Regular Board Meeting Agenda Packet - Page 48 of 274 CENTRAL 5AN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 5 - Self Insurance Fund Expenses by Type Annual QTD YTD Budget QTD QTD Variance Variance YTD YTD YTD Variance Variance Annual Realized Category QTD Budget Actual ($) (%) Budget Actual ($) (%) Budget (%) Professional Services $ 91,250 $ 25,149 $ 66,101 72.4% $ 91,250 $ 25,149 $ 66,101 72.4% $ 365,000 6.9% Technical Services 13,750 - 13,750 100.0% 13,750 - 13,750 100.0% 55,000 0.0% Insurance & Risk Management 1,741,375 1,664,234 77,141 4.4% 1,741,375 1,664,234 77,141 4.4% 2,000,500 83.2% Total Expenses $ 1,846,375 $ 1,689,383 $ 156,992 8.5% $ 1,846,375 $ 1,689,383 $ 156,992 8.5% $2,420,500 69.8% Year -to -Date Expenses by Type 000 $1,800, 000 $1,600, 000 $1,400, 000 $1,200, 000 $1,000, 000 $800,000 $600,000 $400,000 $200,000 Professional Services Technical Services Insurance & Risk Management Expense Category ■ YTD ■ YTD Budget Actual 211Pa e December, 2024 Regular Board Meeting Agenda Packet - Page 49 of 274 ENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Revenues by Source QTD Category Budget Tax Revenue $ Investment Income Total Revenues $ Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 6 - Debt Service Fund Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Revenue Annual Realized Actual Variance ($) (%) Budget Actual Variance ($) (%) Estimate (%) $ $ $ $ $ $ 8,815,875 0.0% Year -to -Date Revenues by Source $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 Tax Revenue YTD YTD Budget Actual $ 8,815,875 0.00/0 221 December 5, 2024 Regular Board Meeting Agenda Packet - Page 50 of 274 CENTRAL 5AN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 6 - Debt Service Fund Expenses by Type Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Estimate (%) Professional Services $ 1,500 $ - $ 1,500 100.0% $ 1,500 $ - $ 1,500 100.0% $ 6,000 0.0% Principal Payment Expense 7,095,000 7,095,000 - 0.0% 7,095,000 7,095,000 - 0.0% 7,095,000 100.0% Interest Expense 428,719 315,375 113,344 26.4% 428,719 315,375 113,344 26.4% 1,714,875 18.4% Total Expenses $ 7,525,219 $ 7,410,375 $ 114,844 1.5% $ 7,525,219 $ 7,410,375 $ 114,844 1.5% $ 8,815,875 84.1% Year -to -Date Expenses by Type $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Professional Services Principal Payment Expense Interest Expense ■ YTD ■ YTD Budget Actual 231Pa e December, 2024 Regular Board Meeting Agenda Packet - Page 51 of 274 CENTRAL 5AN 5019 IMHOFF PLACE, MARTINE2- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 7 - Quarterly Investment Portfolios Operating & Maintenance Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of QTD Investment YTD Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif. LAIF n/a n/a n/a (1) $ 19,000,000 $ 26,000,000 $ (7,000,000) $ 19,000,000 $ 19,039,161 100.00% $ 125,932 $ 125,932 RE27 UST Notes US Treasury 04/30/24 7/30/24 0 5.374% 3:947:119 4,000,000 (4,000,000) 0.00% 16,852 16,852 (3) $ 22,947,119 $ 30,000,000 $ (11,000,000) $ 19,000,000 $ 19,039,161 100.00% 142,784 142,784 (2) (4) (5) 9,245 9,245 $ 152,029 $ 152,029 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date References: (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of September 2024 was 4.58%. (2) The face value indicates the value of the investment if held until maturity, which is the usual District Practice. (3) The weighted average yield of the total Running Expense portfolio is 4.58%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut-off for month -end reporting by Contra Costa County. (41 The market value of the portfolio on September 30, 2024 was $19,039,161. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values quarterly. (5) Amount represents interest income from prior period investments. Notes: (A) All investments held by the Running Expense Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Running Expense fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Running Expense Fund, $9,660,000 is restricted for the Rate Stabilization Fund Account December'5e2024 Regular Board Meeting Agenda Packet - Page 52 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MARTINE2- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 7 - Quarterly Investment Portfolios Sewer Construction Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of QTD Investment YTD Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif. LAIF n/a n/a n/a (1) $ 6500,000 $ 17,500,000 $ (11,000,000) $ 6,500,000 $ 6,571,256 5.70% $ 122,478 $ 122,478 961 US T Bill US Treasury 01/21/22 01/15/25 107 1.26% 2:490,505 2,500,000 - 2,500,000 2,475,300 2.19% $ 801 $ 801 988 US Treasury US Treasury 04/25/24 07/25/24 0 5.38% 19,738,000 20,000,000 (20,000,000) - - 0.00% $ 69,867 $ 69,867 989 US Treasury US Treasury 04/30/24 07/30/24 0 5.37% 14,801,696 15,000,000 (15,000,000) - - 0.00% $ 63,196 $ 63,196 990 US Treasury US Treasury 06/17/24 09/12/24 0 5.38% 49,367,075 50,000,000 (50,000,000) - - 0.00% $ 531,075 $ 531,075 991 US Treasury US Treasury 06/25/24 09/12/24 0 5.35% 31,601,877 32,000,000 (32,000,000) - - 0.00% $ 370,347 $ 370,347 992 US Treasury US Treasury 07/26/24 10/24/24 24 5.29% 9,871,250 10,000,000 - 10,000,000 9,969,900 8.77% $ 95,847 $ 95,847 993 US Treasury US Treasury 07/31/24 10/29/24 29 5.27% 14,807,700 15,000,000 - 15,000,000 14,944,800 13.16% $ 132,473 $ 132,473 994 US Treasury US Treasury 09/13/24 12/05/24 66 4.91% 49,447,819 50,000,000 - 50,000,000 49,591,500 43.86% $ 119,750 $ 119,750 995 US Treasury US Treasury 09/20/24 12/19/24 80 4.69% 29,656,875 30,000,000 30,000,000 29,703,300 26.32% $ 41,938 $ 41,938 (3) $ 228,282,798 $ 242,000,000 $ (128,000,000) $ 114,000,000 $ 113,256,056 100.00% 1,547,772 1,547,772 (2) (4) (5) 48,765 48,765 $ 1.596,537 $ 1.596.537 Legend: EOQ - End of quarter BOQ = Beginning of quarter YTD = Year to Date References: (1) Annual Yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of September 2024 was 4.58%. (2) The face value indicates the value of the investment if held until maturity, which is the usual District practice. (3) The weighted average yield of the total Sewer Construction portfolio is 4.99%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut-off for month -end reporting by Contra Costa Countv. (4) The market value of the portfolio on September 30, 2024 was $113,256,056. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values monthly. (5) Amount represents investment income from prior period investments. Notes: (A) All investments held by the Sewer Construction Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Sewer Construction fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Sewer Construction Fund, $1,000,000 is restricted for the Rate Stabilization Reserve Account. December'5e2024 Regular Board Meeting Agenda Packet - Page 53 of 274 CENTRAL 5AN 5019 IMHOFF PLACE, MARTINE2- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 7 - Quarterly Investment Portfolios Self -Insurance Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of QTD Investment YTD Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif. LAIF n/a n/a n/a (1) $ 8,600,000 $ 10,100,000 $ (1,500,000) $ 8,600,000 $ 8,694,278 100.00% $ 100,891 $ 100,891 (3) $ 8,600,000 $ 10,100,000 $ (1,500,000) $ 8,600,000 $ 8,694,278 100.00% 100,891 100,891 (2) (4) (5) 4,372 3,672 $ 105,263 $ 304,563 Legend: EOQ = End of quarter BOQ - Beginning of quarter YTD = Year to Date References: (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of September 2024 was 4.58%. (2) The face value indicates the value of the investment if held until maturity, which is the usual District Practice. (3) The weighted average yield of the total Self -Insurance portfolio is 4.58%. (4) The market value of the portfolio on September 30, 2024 was $8,694,278. (5) Amount represents interest income from prior period investments. Notes: (A) All investments held by the Self Insurance Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Self Insurance fund for the next six (6) months [California Government Code §53646(b)(3)]. December'5e2024 Regular Board Meeting Agenda Packet - Page 54 of 274 ENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 8 - Financial Performance Metric Charts 0&M Fund Cash & Investments (C&I) to Working Capital Reserve Trend $60.0 $50.0 $42.1 . $42.1 $40.0 Imm M ■ $37.8 ■ ■ ■ ■ ■ $30.0 $20.0 $10.0 $0.0 June '24 July August September October November December January February March April May June Projected C&I Balance* IIIIIIIIIIIIActual C&I Balance Working Capital Reserve Target at Year End** *Projected C&I balances were generated in July 2024 based on budgeted revenues and expenses for FY 2024-25 and applied to the actual balance as of June 30, 2024. (Note: C&I is not "working capital", which incorporates other current assets minus current liabilities as covered in Central San's Fiscal Reserve's Board Policy - BP 017) **The reserve target at year end reflects "working capital" as defined by Central San's Fiscal Reserves policy. In addition to unrestricted cash and investments, working capital reserve targets includes other current assets, and is calculated net of current liabilities. Fiscal year end results are expected to be compliant with reserve requirements. 271Paae Decembert, 2024 Regular Board Meeting Agenda Packet - Page 55 of 274 ENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cash & Investments (C&I) to Working Capital Reserve Trend $180.0 $170.0 $160.0 $147.1 $150.0 $140.0 $130.0 $119.7 $120.0 $110.0 $100.0 $90.0 $80.0 $70.0 $60.0 $50.0 $40.0 $30.0 $20.0 $10.0 $0.0 June '24 July August September October November December January February March April May Projected C&I Balance* IIIIIIIIIIIIActual C&I Balance Working Capital Reserve Target at Year End** June $53.6 *Projected C&I balances were generated in July 2024 based on budgeted revenues and expenses for FY 2024-25 and applied to the actual balance as of June 30, 2024. (Note: C&I is not "working capital", which incorporates other current assets minus current liabilities as covered in Central San's Fiscal Reserve's Board Policy - BP 017) **The reserve target at year end reflects "working capital" as defined by Central San's Fiscal Reserves policy. In addition to unrestricted cash and investments, working capital reserve targets includes other current assets, and is calculated net of current liabilities. Fiscal year end results are expected to be compliant with reserve requirements. 281Paae Decembert, 2024 Regular Board Meeting Agenda Packet - Page 56 of 274 CENTRAL 5AN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 8 - Financial Performance Metric Charts Staffing Trends 310 7.0% 6.70/o 305 300 6.5 % 295 20 6.0% 290 7 285 5.9% 17 5.8% 5.8% 5.5% c7 280 1171 a, H 275 5.0% w 270 281 283 265 277 273 4.5% 260 255 4.0 % 9/30/21 9/30/22 9/30/23 9/30/24 Quarter Ended 6-4 Filled Positions (FTEs) a Vacancies (FTEs) Vacancy Rate 291Page December 5, 2024 Regular Board Meeting Agenda Packet - Page 57 of 274 CENTRAL 5AN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated $4,500 $4.000 $3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 301Page Historical Quarterly O&M Cost per Million Gallons Treated $4,247 $3,314 $4,023 $3,766 9/30/21 9/30/22 9/30/23 9/30/24 Quarter Ended December 5, 2024 Regular Board Meeting Agenda Packet - Page 58 of 274 ENTRAL SAN 5019 IMHOFF PLACE, MAIJINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Total Sewer Construction Fund Budget to Actual spending Trend FY 24-25 Sewer ConstrurLion Fund [in millinns] S140 $131.0 $120 rl � L r r $117.9 r r $100 rr r►r' V30 ! R $50 wrrr — �1 rxr $40 ~r_ _ $i2.3 r $20 r r $20.1 Sias s- 1u]y August Or[nhPr N11-31-1 ]7ecemher January Fe.I ­ry Man-h April Max Inns +Budget—+—Target(90%oFBudget) fAcruals 311Page December 5, 2024 Regular Board Meeting Agenda Packet - Page 59 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 $60 $m $40 $30 $20 $10 i(10) Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Collection System Program Budget to Actual Spending Trend Collection System Program (in millions) $55.4 $49.9 july August September October November December January Cebmary March April May Iuue f Pudget --0-- Target C90% of [iudget] 0 Actual 321Page December 5, 2024 Regular Board Meeting Agenda Packet - Page 60 of 274 CENTRAL SAN 5019 IMHOFF PLACE, MAIJINE2. CA 94553-4392 $70 $G0 $50 S40 $30 $20 $1❑ Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Treatment Program Budget to Actual Spending Trend FY 24-25 Treatment Program (in millions) St©.9 ~ $ 9.8 [illy August SellielilllY.l' 01:I11EW.r November nel.V.1111W. lawary rehnimry Mamh f budget - s-- Target C90%of Budget} 0 Actual 331Page $59.9 r $53.9 April May ]line December 5, 2024 Regular Board Meeting Agenda Packet - Page 61 of 274 iCENTRAL SAN 5019 IMHOFF PLACE, MAIJINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2024 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed / Renovated 2.5 4.5 4.2. 4.0 2.0 2.0 2.0 3.5 1.8 1.7 1.6 3.0 c. — ° 2.5 C a a 1.0 1-4 1.4 0 �r 0.9 1.5 0.6 0.6 0.5 1.0 0.5 0.5 0.1 0.0 0.0 al3olz� �z1�11�3 3l`�tilz� 6�.�01�'� �}�olz�` Quarter Ending Actual Construction [miles] Target [miles] - FY'24 &'25 Budget Pro)ecdons -Cumulative Gap (mites) - FY'24 onward 341Page December 5, 2024 Regular Board Meeting Agenda Packet - Page 62 of 274