Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
07. Receive Quarterly Financial Review for quarter ended June 30, 2024
Page 1 of 38 Item 7. 110ENTRAL SAN October 3, 2024 FROM: BRENNAN ROGERS, ACCOUNTING SUPERVISOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIP LEIBER, DEPUTYGM -ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE QUARTERLY FINANCIAL REVIEW FOR QUARTER ENDED JUNE 30, 2024 Attached is the Quarterly Financial Review for the fourth quarter of Fiscal Year (FY) 2023-24 ending June 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 June 30, 2024 October 3, 2024 Regular Board Meeting Agenda Packet - Page 36 of 108 Attachment Quarterly Financial S ReviewCENTRAL SAN I� - Row- Mom _ Wig_ 1 �+-�•_ r f i• : r E-4 - r I r.. �.�� bpi! wooJ�r� ■►,r s .� �� �^'�: � �[ ��`i►����-"' � .'� ��' may" t7,7. 7CH- M uarter Ended June 30, 2024 Z(�CENTRAL SAN 5019 IMHOFF PLACE. MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Table of Contents Section1- Executive Summary................................................................................................................................................................................................1 Section 2 - Financial Results Summary by Fund................................................................................................................................................................4 Section 3 - Operations & Maintenance Fund Revenues Revenuesby Source - Summary........................................................................................................................................................................................................5 Revenuesby Source - Detail...............................................................................................................................................................................................................6 Expenses Expensesby Type - Summary............................................................................................................................................................................................................7 Expensesby Type - Detail....................................................................................................................................................................................................................8 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 October 3, 2024 Regular Board Meeting Agenda Packet - Page 38 of 108 z(�CENTRAL SAN 5019 IMHOFF PLACE. MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 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 October 3, 2024 Regular Board Meeting Agenda Packet - Page 39 of 108 z(�CENTRAL SAN 5019 IMHOFF PLACE. MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 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 fourth quarter of FY 2023-24 ended June 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 June 30, 2024 show total expenditures of $85.5 million, which is approximately $5.5 million (6.0%) under the FY 2023-24 budget. This favorable expense variance is largely attributable to lower than projected year-to-date spending in the salaries & wages, other purchased services, and supplies & materials expenditure line categories. The largest year-to-date favorable budgetary variance was salaries & wages at approximately $2.3 million (5.1%) mainly due a higher than budgeted vacancy rate (6.4% as of June 30, 2024) and incurring less overtime and temporary staffing support costs than projected for the fiscal year. The second largest year-to-date favorable budgetary variance is with other purchased services at $2.3 million (31.1%) attributable to lower than projected spending in all departments for various professional and technical services throughout the fiscal year. In the aggregate, the 0&M Fund had a favorable revenue variance of $0.6 million, approximately 0.7% above total estimated year-to-date revenues. Numerous drivers contributed to the overall favorable revenue variance, salient among them being investment income, service counter charges, and permit and application fees. Sewer Construction Fund Sewer Construction Fund results for the fiscal year show total capital project expenditures of $92.4 million, or 129.8% of the total adopted budget of $71.2 million. While the Sewer Construction Fund's FY 2023-24 adopted budget was $71.2 million, the inclusion of carryforward capital project appropriations from the prior year of $78.8 million in the total adjusted budget for FY 2023-24 brings the total budget to $150.0 million. The significant budgetary carryforward was, at least initially, primarily 11Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 40 of 108 z(�CENTRAL SAN 5019 IMHOFF PLACE. MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 1 -Executive Summary 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. After factoring in the carryforward, the year-to-date capital spending rate is 61.6% of the amended capital budget for FY 2023-24. The bulk of the FY 2023-24 capital spending budget variance by spend amount is attributable to the Collection System program, followed by the Treatment Plant program. Variance details by project are shown in pages 15- 18 of this report. The Sewer Construction Fund reported revenues of $90.4 million, a favorable variance of $10.8 million from the budgeted revenues of $79.6million. The favorable variance is primarily attributable to investment income ($4.0M), Concord billings ($4.0M), and secured property tax revenue ($1.5M). Investment income came in higher than projected due to higher than anticipated average monthly investment balances fixed income investment yields during the fiscal year. The Concord capital bill included greater than anticipated billings for the city's respective portion of the solids handling project costs which will not be reimbursed through a state revolving fund loan. Secured property taxes also came in higher than projected reflecting property assessed value growth being greater than amounts conservatively assumed in the adopted FY 2023-24 budget (5.6% versus 3.0%). 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 June 30, 2024 are presented in separate Investment Portfolio Reports for each fund on pages 26-28 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. In FY 2023-24, the 0&M Fund investment portfolio generated approximately $1.1 million in investment income, which is 30.9% higher than budgetary estimates. The Sewer Construction Fund portfolio reported investment income of $6.3 million, 2 1 P a g e October 3, 2024 Regular Board Meeting Agenda Packet - Page 41 of 108 Z(�CENTRAL SAN 5019 IMHOFF PLACE. MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 1 -Executive Summary far outpacing budgetary estimates of approximately $2.3 million by 179.6%. After Central San's FY 2023-24 budget was finalized, the Federal Reserve Bank announced two additional interest rate hikes totaling 50 basis points, which increased the Fed target rate to a range of 5.25% to 5.50%, a rate that persisted throughout the fiscal year. During FY 2023-24, the Finance Division has continued to diversify the investment portfolio outside of the Local Agency Investment Fund (LAIF), which reported a quarterly apportionment rate of 4.55% in the fourth quarter. While the LAIF apportionment rate has steadily increased, this diversification effort has led to the acquisition of more U.S. Treasury Bills and Federal Agency securities, which in tandem has drastically increased the weighted average yield of Central San's investment portfolios over the past two fiscal years. While an environment of rising interest rates can be enticing for investment purposes, Central San's Finance Division continues to prioritize a prudent balance of safety, liquidity, and yield, carefully apportioning Central San's investment portfolio between highly liquid investment options such as LAIF with higher yielding but less liquid fixed income security alternatives. As of June 30, 2024, Central San was holding about 30.3% of its investment portfolio, or $53.6 million, in the LAIF state investment pool, under the maximum amount permitted by District policy ($75.0 million). As described previously, the Fed has continued its trend since 2022 of steadily increasing its target interest rate from near zero rates in an attempt to cool off spending growth and curb inflation. Central San's diversified portfolio, which includes U.S. Treasury Bills and Federal Agency Notes with remaining maturities ranging from three (3) to twelve (12) months, continues to benefit from these higher rates. While staff does intend to continue exploring investment alternatives, it is stressed that given the restricted nature of municipal investing, additional efforts may not yield significantly impactful results to Central San's bottom line, with C&M investment earnings comprising less than 1.0% to total revenues in FY 2023-24. However, Central San's transition to an in- house treasury structure accompanied by a more active investment approach in FY 2024-25 may help increase overall returns. Central San's investment portfolio is compliant with the Board's adopted policy regarding investments as of the quarter ended June 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. 3 1 P a g e October 3, 2024 Regular Board Meeting Agenda Packet - Page 42 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 $50,000,0W ' $45,000,000 $40,000,000 $35,000,000 $30,000,000 ' $25,000,000 ' $201000,000 ' $15,000,000 ' $10,000,000 ' 45,000,000 0&M 4 1 P a g e Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 2 -Financial Results Summary by Fund Annual YTD Budget YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget (%) Fund Revenues $ 90,946,671 $ 85,489,062 $ 5,457,609 6.0% $ 90,946,671 94.0% 0&M $ 89,722,943 $ 90,324,574 $ 601,631 0.7% $ 89,722,943 100.7% Sewer Construction* 79,626,163 90,445,557 10,819,394 13.6% 93,126,163 97.1% Self Insurance 2,017,052 2,086,484 69,432 3.4% 2,017,052 103.4% Debt Service 9,160,142 7,874,500 (1,285,643) -14.0% 9,160,142 86.0% Total $ 180,526,300 $ 190,731,114 $ 10,204,814 $ 194,026,300 Fund Expenses 0&M $ 90,946,671 $ 85,489,062 $ 5,457,609 6.0% $ 90,946,671 94.0% Sewer Construction 150,021,461 92,430,226 57,591,235 38.4% 150,021,461 61.6% Self Insurance 2,660,000 2,457,343 202,657 7.6% 2,660,000 92.4% Debt Service 9,160,142 7,868,700 1,291,443 14.1% 9,160,142 85.9% Total $ 252,788,274 $ 188,245,331 $ 64,542,943 $ 252,788,274 *Budgeted capital revenue excludes non -revenue debt proceeds of $14 million presented in budget book YTD Budget -to -Actual Revenues by Fund SewerC MtmRion Selflnsura Debt Service Fund • TD •YTD Budgct Actual October 3, 2024 Regular Board Meeting Agenda Packet - Page 43 of 108 YTD Budget -to -Actual Expenses by Fund / $70,000,000 $60,000,000 $50,000,000 $40,000,000 / $30,000,000 $20,000,000 $10,000,000 — — 0&M SewerSeBlnsun— Debt Service Fund D •YTD BudgR Actual CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund Revenues by Source - Summary Level Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized(%) Operating Revenues: Sewer Service Charge Revenue $ 29,181,661 $ 30,014,682 $ 833,021 2.9% $ 66,051,443 $ 66,125,898 $ 74,455 0.1% $ 66,051,443 100.1% Sewage Treatment Cost Sharing 17,900,000 17,882,586 (17,414) -0.1% 17,900,000 17,828,345 (71,655) -0.4% 17,900,000 99.6% Miscellaneous Service Charge 1,527,976 1,514,619 (13,357) -0.9% 2,200,000 2,199,774 (226) 0.0% 2,200,000 100.0°/% Non -Operating Revenues: Permit and Inspection Fees 456,875 502,541 45,666 10.0% 1,827,500 1,952,699 125,199 6.9% 1,827,500 106.9% Other Non Operating Income 228,500 254,920 26,420 11.6% 884,000 1,092,355 208,355 23.6% 884,000 123.6% Investment Income 316,000 548,382 232,382 73.5% 860,000 1,125,503 265,503 30.9% 860,000 130.9% Total Revenue $ 49,611,012 $ 50,717,730 $ 1,106,718 2.2% $ 89,722,943 $ 90,324,574 $ 601,631 0.7% $ 89,722,943 100.7% Year -to -Date Revenues by Source $40,000,000 $30,000,000 $20,000,000 $10,000,000 Sewer Service Charge Revenue Sewage Treatment Cost Sharing Miscellaneous Service Charge Permit and Inspection Fees Other Non Operating Income ■ YTD ■ YTD Budget Actual 5 1 P a g e October 3, 2024 Regular Board Meeting Agenda Packet - Page 44 of 108 Investment Income CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund Revenues by Source - Detail Level Permit & Inspection Fees Annual Permit/Application Fees 125,000 132,535 7,535 QTD 500,000 612,848 112,848 YTD 500,000 Budget Overtime Inspection QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) % Budget Actual Variance ($] % Budget 102.8% Sewer Service Charge Revenue 28,750 1,904 (26,846) -93.4% 115,000 111,670 (3,330) -2.9% 115,000 97.1% Sewer Service Charge Counter $ 48,988 $ 105,830 $ 56,842 116.0% $ 195,949 $ 319,071 $ 123,122 62.8% $ 195,949 162.8% Sewer Service Charge County 29,139,671 29,870,014 730,343 2.5% 64,754,824 64,569,898 (184,926) -0.3% 64,754,824 99.7% Sewer Service Charge Direct - 38,837 38,837 1,128,663 1,251,320 122,657 10.9% 1,128,663 110.9% Sewer Service Charge Prior (6,998) - 6,998 -100.0% (27,993) (14,391) 13,602 -48.6% (27,993) 51.4% Sewage Treatment Cost Sharing 17,900,000 17,882,586 (17,414) -0.1% 17,900,000 17,828,345 (71,655) -0.4% 17,900,000 99.6% Miscellaneous Service Charges 205,500 54,650 (150,850) -73.4% 822,000 742,546 (79,454) -9.7% 822,000 90.3% Septic Tank Dumping 11,250 14,656 3,406 30.3% 45,000 47,062 2,062 4.6% 45,000 104.6% Sales 250 - (250) -100.0% 1,000 20 (980) -98.0% 1,000 2.0% Other Service Charges 210,000 73,616 (136,384) -64.9% 210,000 82,712 (127,288) -60.6% 210,000 39.4% Recycled Water 128,750 207,551 78,801 61.2% 515,000 549,390 34,390 6.7% 515,000 106.7% Satellite Water Recycling - - - 2.2% $ - - - 0.7% $ - 100.7% Stormwater Program 210,000 218,356 8,356 4.0% 420,000 462,201 42,201 10.0% 420,000 110.0% Household Hazardous Waste 967,726 1,000,440 32,714 3.4% 1,009,000 1,058,389 49,389 4.9% 1,009,000 104.9% Permit & Inspection Fees Permit/Application Fees 125,000 132,535 7,535 6.0% 500,000 612,848 112,848 22.6% 500,000 122.6% Overtime Inspection 2,375 5,615 3,240 136.4% 9,500 10,953 1,453 15.3% 9,500 115.3% Side Sewer Inspection 290,000 356,688 66,688 23.0% 1,160,000 1,192,787 32,787 2.8% 1,160,000 102.8% Industrial Permit Fees 28,750 1,904 (26,846) -93.4% 115,000 111,670 (3,330) -2.9% 115,000 97.1% New Industry Permit Fees 4,500 1,598 (2,902) -64.5% 18,000 8,084 (9,916) -55.1% 18,000 44.9% Annexation Charges 6,250 3,375 (2,875) -46.0% 25,000 15,531 (9,469) -37.9% 25,000 62.1% Other Non -Operating Income MVSD P2 Program 15,000 13,356 (1,644) -11.0% 30,000 37,016 7,016 23.4% 30,000 123.4% Pretreatment Program Fine 500 - (500) -100.0% 2,000 - (2,000) -100.0% 2,000 0.0% Lease Rental Income 205,500 54,650 (150,850) -73.4% 822,000 742,546 (79,454) -9.7% 822,000 90.3% Miscellaneous Income 7,500 156,648 149,148 1988.6% 30,000 250,759 220,759 735.9% 30,000 835.9% Right of Way Fees - 7,430 7,430 - 19,295 19,295 - Reimbursements - 22,836 22,836 - 42,739 42,739 - Investment Income 316,000 548,382 232,382 73.5% 860,000 1,125,503 265,503 30.9% 860,000 130.9% Total Revenues $ 49,611,012 $ 50,717,730 $ 1,106,718 2.2% $ 89,722,943 $ 90,324,574 $ 601,631 0.7% $ 89,722,943 100.7% 7 1 P a g e October 3, 2024 Regular Board Meeting Agenda Packet - Page 45 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Type - Summary Year -to -Date Expenses by Type $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Ll ft i Salaries & Wages Employee Benefits Unfunded Liability Purchased Property Other Purchased Supplies & Materials Other Expenses Costs Services Services ■YTD ■ YTD Budget Actual 8 1 P a g e October 3, 2024 Regular Board Meeting Agenda Packet - Page 46 of 108 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance [$] (%) Budget Actual Variance ($) (%) Budget (%) Salaries & Wages $ 10,752,257 $ 10,209,778 S 542,480 5.0% $ 45,144,569 $ 42,846,307 S 2,298,262 5.1% $ 45,144,569 94.9% Employee Benefits 3,486,484 3,381,256 105,227 3.0% 13,654,823 13,705,566 (50,743) -0.4% 13,654,823 100.4% Unfunded Liability Costs 424,572 427,636 (3,064) -0.7% 1,200,503 1,201,925 (1,422) -0.1% 1,200,503 100.1% Purchased Property Services 1,945,052 1,885,753 59,300 3.0% 7,697,774 7,571,207 126,567 1.6% 7,697,774 98.4% Other Purchased Services 1,817,341 1,382,726 434,616 23.9% 7,246,295 4,995,138 2,251,157 31.1% 7,246,295 68.9% Supplies & Materials 3,563,028 4,462,089 (899,061) -25.2% 14,298,822 13,931,705 367,117 2.6% 14,298,822 97.4% Other Expenses 418,639 210,155 208,485 49.8% 1,703,885 1,237,215 466,670 27.4% 1,703,885 72.6% Total Expenses S 22,407,375 S 21,959,393 S 447,982 2.00A S 90,946,671 S 85,489,062 S 5,457,609 6.01)/o S 90,946,671 94.0% Year -to -Date Expenses by Type $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Ll ft i Salaries & Wages Employee Benefits Unfunded Liability Purchased Property Other Purchased Supplies & Materials Other Expenses Costs Services Services ■YTD ■ YTD Budget Actual 8 1 P a g e October 3, 2024 Regular Board Meeting Agenda Packet - Page 46 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued on page 10) 9 1 P a g e October 3, 2024 Regular Board Meeting Agenda Packet - Page 47 of 108 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance (5) (1/0) Budget Actual Variance {$] (OM Budget {%] Salaries & Wages FTE Regular Pay $ 9,822,494 $ 8,842,320 $ 980,174 10.0% $ 41,187,208 $ 38,332,890 $ 2,854,318 6.9% $ 41,187,208 93.1% Temporary Pay 431,491 481,821 050,330) -11.7% 1,913,093 1,660,820 252,273 13.2% 1,913,093 86.8°% Premium Pay 830,372 865,076 034,704] 4.2% 3,372,669 2,770,809 601,860 17.8% 3,372,669 82.2°% Board Fees 16,650 12,800 3,850 23.1% 66,600 49,800 16,800 25.2% 66,600 74.8°% Other (348,750] 7,760 (356,510) 102.2% (1,395,000) 31,988 (1,426,988) 102.3% {1,395,000] -2.3% Total Salaries & Wages 10,752,257 10,209,778 542,480 5.0% 45,144,569 42,846,307 2,298,262 5.1°% 45,144,569 94.9% Employee Benefits Insurance Premiums 2,264,560 L999,032 265,528 11.7% 8,885,919 8,106,857 779,061 8.8°% 8,885,919 91.2°% Employer Taxes 157,429 166,197 (8,767) -5.6% 660,013 709,157 (49,144] -7.4°% 660,013 107.4°% Employer Retirement Contributions 2,066,612 L977,554 89,058 4.3% 8,490,640 8,279,654 210,986 2.5% 8,490,640 97.5°% OPEBContibutions 470,000 470,000 - 0.0% 1,880,000 1,880,000 0.0°% 1,880,000 100.0°% Benefit Adjustments (1,472,118] (L231,526] (240592) 16.3% (6,261,749) (5,270,103] (991,645) 15.8% (6,261,749] 84.2°% Total Employee Benefits 3,486,484 3,381,256 105,227 3.0% 13,654,823 13,705,566 (50,743) -0.40% 13,654,823 100.4% Unfunded Lability Costs Pension 14,322 392,386 (378,064) -2639.7% 59,503 1,060,925 (1,001,422] -1683.0% 59,503 1783.0°% OPEB 410,250 35,250 375,000 91.4% 1,141,000 141,000 1,000,000 87.6% 1,141,000 12.4°% Total Unfunded Liability Costs 424,572 427,636 (3,064) -0.7% 1,200,503 1,201,925 (1,422) -0.1% 1,200,503 100.1% Purchased Property Services Repairs & Maintenance 1,288,615 L038,108 250,507 19.4% 5,070,924 4,897,226 173,698 3.4°% 5,070,924 96.6°% Hauling & Disposal 304,575 396,511 (91,936) -30.2% 1,218,300 1,069,867 148,433 12.2% 1,218,300 87.8°% Security 183,650 189,687 (6,037) -3.3% 734,600 696,929 37,671 5.1% 734,600 94.9°% Rentals 37,075 99,023 061,948] -167.1% 149,400 364,116 (214,716] -143.7% 149,400 243.7°% Cleaning 130,763 162,424 (31,661] -24.2% 523,050 541,360 (18,310) -3.5°% 523,050 103.5°% Construction 375 - 375 100.0% 1,500 1,710 {210] -14.0% 1,500 114.0°% Total Purchased Property Services 1,945,052 1,885,753 59,300 3.0% 7,697,774 7,571,207 126,567 1.6010 7,697,774 98.4% (Continued on page 10) 9 1 P a g e October 3, 2024 Regular Board Meeting Agenda Packet - Page 47 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued) Supplies & Materials Utilities & Fuel Chemicals General Supplies Total Supplies & Materials Other Expenses Memberships Training & Meetings Miscellaneous Other Total Other Expenses Total Expenses 101Page 2,074,966 2,920,381 0845,416] -40.7% 8,299,862 8,863,283 (563,421) -6.80A 8,299,862 106.80A 740,000 738,505 1,495 0.2% 2,960,000 2,724,827 235,173 7.9% 2,960,000 92.1% 748,063 803,203 (55,140) -7.4% 3,038,960 2,343,595 695,365 22.90A 3,038,960 77.10A 3,563,028 4,462,089 (899,061) -25.2% 14,298,822 13,931,705 367,117 2.6% 14,298,822 97.4% 184,024 84,339 99,685 54.2% 761,830 621,990 139,840 18A% 761,830 81.6% 186,305 197,165 (10,860) -5.8% 744,313 518,334 225,979 30A0A 744,313 69.60A 48,311 (71,349) 119,660 247.7% 197,742 96,891 100,851 51.O0A 197,742 49.O0A 418,639 210,155 208,485 49.8°/0 1,703,885 1,237,215 466,670 27.4/0 1,703,885 72.6%n S 22,407,375 S 21,959,393 $ 447,982 2.0% $ 90,946,671 S 85,489,062 $ 5,457,609 6.0% S 90,946,671 94.0%u October 3, 2024 Regular Board Meeting Agenda Packet - Page 48 of 108 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) [°/o] Budget Actual Variance (S) (q'n] Budget [�k] Other Purchased Services Professional Services 390,398 417,858 (27,461) -7.0% 1,557,534 963,086 594,448 36.2 OA 1,557,534 61.80A Technical Services 798,019 415,304 382,715 48.0% 3,160,776 1,7D8,663 1,452,113 45.9% 3,160,776 54.1% Other Purchased Services 628,925 549,563 79,362 12.6% 2,527,985 2,323,389 204,596 8.1% 2,527,985 91.9% Total Other Purchased Services 1,817,341 1,382,726 434,616 23.996 7,246,295 4,995,138 2,251,157 31.1/0 7,246,295 68.9%u Supplies & Materials Utilities & Fuel Chemicals General Supplies Total Supplies & Materials Other Expenses Memberships Training & Meetings Miscellaneous Other Total Other Expenses Total Expenses 101Page 2,074,966 2,920,381 0845,416] -40.7% 8,299,862 8,863,283 (563,421) -6.80A 8,299,862 106.80A 740,000 738,505 1,495 0.2% 2,960,000 2,724,827 235,173 7.9% 2,960,000 92.1% 748,063 803,203 (55,140) -7.4% 3,038,960 2,343,595 695,365 22.90A 3,038,960 77.10A 3,563,028 4,462,089 (899,061) -25.2% 14,298,822 13,931,705 367,117 2.6% 14,298,822 97.4% 184,024 84,339 99,685 54.2% 761,830 621,990 139,840 18A% 761,830 81.6% 186,305 197,165 (10,860) -5.8% 744,313 518,334 225,979 30A0A 744,313 69.60A 48,311 (71,349) 119,660 247.7% 197,742 96,891 100,851 51.O0A 197,742 49.O0A 418,639 210,155 208,485 49.8°/0 1,703,885 1,237,215 466,670 27.4/0 1,703,885 72.6%n S 22,407,375 S 21,959,393 $ 447,982 2.0% $ 90,946,671 S 85,489,062 $ 5,457,609 6.0% S 90,946,671 94.0%u October 3, 2024 Regular Board Meeting Agenda Packet - Page 48 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Summary (by Department) Year -to -Date Expenses by Department $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services ■ YTD ■ YTD Budget Actual 111Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 49 of 108 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($] (%] Budget (%) Department Executive Governance $ 750,593 $ 576,914 $ 173,678 23.1% $ 3,169,121 $ 2,009,352 $ 1,159,769 36.6% $ 3,169,121 63.4% Administration 5,648,417 5,492,793 155,623 2.8% 21,906,201 19,947,893 1,958,308 8.9% 21,906,201 91.1% Engineering and Technical Services 3,762,445 3,406,186 356,259 9.5% 15,257,107 13,576,412 1,680,696 11.0% 15,257,107 89.0% Operations 11,750,640 12,249,339 (498,699) -4.2% 48,689,437 48,533,145 156,292 0.3% 48,689,437 99.7% Recycled Water Program 495,281 234,161 261,120 52.7% 1,924,804 1,422,261 502,544 26.1% 1,924,804 73.9% Total Expenses $ 22,407,375 $ 21,959,393 $ 447,982 2.0% $ 90,946,671 $ 85,489,062 $ 5,457,609 6.0% $ 90,946,671 94.0% Year -to -Date Expenses by Department $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services ■ YTD ■ YTD Budget Actual 111Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 49 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Detail (by Division) QTD Oreanizational Unit Budeet Executive Governance 275,048 Office of the General Manager $ 444,516 $ Office of the Secretary of the District 210,991 Board of Directors 95,086 Administration 1,003,642 Office of the Director of Finance and QTD Administration 169,732 Finance Division 539,386 Human Resources Division 1,840,407 Purchasing Division 451,776 Risk Management Program 372,621 Public Info/Comm. Services & Intergov YTD Relations Division 593,858 Information Technology Division 1,680,637 Engineering & Technical Services Office of the Director of Engineering & Technical Services 275,048 141,687 133,361 48.5% 1,003,642 343,041 660,601 Annual 1,003,642 34.2% QTD 1,294,148 1,219,943 74,206 YTD 5,385,263 Budget QTD QTD Variance YTD YTD YTD Variance Annual Realized Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) 192,957 8.S% 9,291,541 8,247,807 1,043,734 11.2% 9,291,541 88.8% Operations 249,893 $ 194,623 43.8% $ 1,852,510 $ 1,006,532 $ 845,978 45.7% $ 1,852,510 54.3% 266,237 (55,246) -26.2% 938,800 809,426 129,374 13.8% 938,800 86.2% 60,785 34,301 36.1% 377,811 193,394 184,417 48.8% 377,811 51.2% 181,082 (11,350) -6.7% 688,243 669,865 18,378 2.7% 688,243 97.3% 630,512 (91,125) -16.9% 2,415,433 2,138,780 276,652 11.5% 2,415,433 88.5% 1,896,618 (56,211) -3.1% 6,930,837 6,255,187 675,650 9.7% 6,930,837 90.3% 432,868 18,908 4.2% 1,887,015 1,708,478 178,537 9.5% 1,887,015 90.5% 385,394 (12,773) -3.4% 1,514,204 1,412,138 102,067 6.7% 1,514,204 93.3% 573,931 19,927 3.4% 2,176,322 1,967,637 208,686 9.6% 2,176,322 90.4% 1,392,389 288,248 17.2% 6,294,147 5,795,809 498,338 7.9% 6,294,147 92.1% Technical Services 275,048 141,687 133,361 48.5% 1,003,642 343,041 660,601 65.8% 1,003,642 34.2% Planning & Developmental Services 1,294,148 1,219,943 74,206 5.7% 5,385,263 5,028,639 356,625 6.6% 5,385,263 93.4% Capital Projects Division (73,316) (29,052) (44,264) 60.4% (423,339) (43,075) (380,264) 89.8% (423,339) 10.2% Environmental & Regulatory Compliance 2,266,565 2,073,608 192,957 8.S% 9,291,541 8,247,807 1,043,734 11.2% 9,291,541 88.8% Operations Office of the Director of Operations 241,904 235,914 5,990 2.5% 989,020 859,666 129,354 13.1% 989,020 86.9% Collection System Operations Division 3,504,925 3,334,506 170,420 4.9% 14,391,917 14,198,200 193,716 1.3% 14,391,917 98.7% Treatment Plant Operations Division 4,068,353 4,370,437 (302,084) -7.4x/0 16,610,137 17,086,216 (476,079) -2.9% 16,610,137 102.9% Treatment Plant Maintenance Division 3,468,891 3,648,804 (179,914) -5.2% 14,892,814 14,747,473 145,341 1.0% 14,892,814 99.0% Operations Optimization Division 466,567 659,678 (193,111) -41.4% 1,805,549 1,641,589 163,960 9.1% 1,805,549 90.9% Recycled Water Recycled Water - General 47,175 34,038 13,137 27.8% 188,700 95,313 93,387 49.5°/% 188,700 50.5% Treatment Plant 269,250 215,462 53,788 20.0% 1,012,200 950,825 61,375 6.1% 1,012,200 93.9% Distribution System 98,118 (43,250) 141,367 144.1% 392,470 191,162 201,308 51.3% 392,470 48.7% Residential Fill Station 55,313 89,185 (33,872) -61.2% 229,734 184,960 44,774 19.5% 229,734 80.5% Satellite Water Facility 25,425 (61,275) 86,700 341.0% 101,700 (0) 101,700 100.0% 101,700 0.0% Total Expenses $ 22,407,375 $ 21,959,393 $ 447,982 2.0% $ 90,946,671 $ 85,489,062 $ 5,457,609 6.0% $ 90,946,671 94.0% 121Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 50 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 4 - Sewer Construction Fund Revenues by Source - Summary Year -to -Date Revenues by Source $30,000,000 $25,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■ YTD ■ YTD Budget Actual 131Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 51 of 108 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 $ 22,187,602 $ 22,810,180 $ 622,578 2.8% $ 50,251,805 $ 50,274,268 $ 22,463 0.0% $ 50,251,805 100.0% Other Capital Revenues 16,383,608 28,367,097 11,983,489 73.1°/% 29,374,358 40,171,288 10,796,930 36.8% 42,874,358 93.7% Total Revenue $ 38,571,210 $ 51,177,276 $ 12,606,066 32.7% $ 79,626,163 $ 90,445,557 $ 10,819,394 13.6% $ 93,126,163 97.1% Year -to -Date Revenues by Source $30,000,000 $25,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■ YTD ■ YTD Budget Actual 131Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 51 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 4 - Sewer Construction Fund Revenues by Source - Detail Facilities Capacity Fees - Gravity Zone 1,017,500 1,259,722 242,222 23.8% 4,070,000 4,601,155 531,155 13.1% 4,070,000 Annual Facilities Capacity Fees - Pump Zone 26,250 - (26,250) QTD 105,000 159,362 54,362 YTD 105,000 Budget Capacity Use Charge QTD QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%] Budget Actual Variance ($) (%] Budget (%) Sewer Service Charges (SSC) - 69,204 69,204 500,000 788,053 288,053 57.6% 500,000 157.6% Over -the -Counter $ 38,513 $ 78,177 $ 39,664 103.0% $ 154,051 $ 239,997 $ 85,946 55.8% $ 154,051 155.8% County Allocated 22,154,591 22,718,039 563,448 2.5% 49,232,424 49,109,500 (122,924) -0.2% 49,232,424 99.8% Direct Billed - 13,964 13,964 16.1% 887,337 935,717 48,380 5.5% 887,337 105.5% Prior Year Adjustment (5,502) - 5,502 -100.0% (22,007) (10,946) 11,061 -50.3% (22,007) 49.7% Other Capital Revenues Facilities Capacity Fees - Gravity Zone 1,017,500 1,259,722 242,222 23.8% 4,070,000 4,601,155 531,155 13.1% 4,070,000 113.1% Facilities Capacity Fees - Pump Zone 26,250 - (26,250) -100.0% 105,000 159,362 54,362 51.8% 105,000 151.8% Capacity Use Charge 12,500 185 (12,315) -98.5% 50,000 47,229 (2,771) -5.5% 50,000 94.5% Secured Property Tax 6,553,358 12,632,436 6,079,078 92.8% 13,933,358 15,423,090 1,489,732 10.7% 13,933,358 110.7% Unsecured Property Tax - 69,204 69,204 500,000 788,053 288,053 57.6% 500,000 157.6% Investment Income 605,000 1,728,775 1,123,775 185.7% 2,250,000 6,290,414 4,040,414 179.6% 2,250,000 279.6% Other Government Revenue - Concord 7,570,000 11,581,690 4,011,690 53.0% 7,570,000 11,581,690 4,011,690 53.0% 7,570,000 153.0% State Revolving Fund Loan Proceeds 500,000 580,591 80,591 16.1% 500,000 580,591 80,591 16.1% 14,000,000 4.1% Overtime Inspection 1,500 371 (1,129) -75.3% 6,000 3,923 (2,077) -34.6% 6,000 65.4% Plan Review 22,250 15,084 (7,166) -32.2% 89,000 92,826 3,826 4.3% 89,000 104.3% Main Lines Inspection Fees 75,000 24,756 (50,244) -67.0% 300,000 65,142 (234,858) -78.3% 300,000 21.7% Rebates to District - - - - - - - Other Agency Reimbursement - 436,054 436,054 - 505,561 505,561 - Miscellaneous Income 250 - (250) -100.0% 1,000 9,174 8,174 817.4% 1,000 917.4% Alhambra Valley Assessment District - - - - - - - Contractual Assessment District - 38,228 38,228 - 23,080 23,080 Total Revenues $ 38,571,210 $ 51,177,276 $ 12,606,066 32.7% $ 79,626,163 $ 90,445,557 $ 10,819,394 13.6% $ 93,126,163 97.1% 141Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 52 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Summary (by Program) Cumulative Cumulative Total Project FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 Prior Year Prior Year I Carryforward to Adopted Budget Adjusted Approved I Actual I Remaining I Budgets Actuals FY 2023-34 Budget Adjustments Budget Expenditures Expenditures Budget Collection System (CS) $ 96,395,150 $ 66,275,150 $ 30,120,000 $ 35,734,000 $ (120,508) $ 35,613,492 $ 65,733,492 $ 34,889,169 $ 30,844,323 Treatment Plant (TP) 109,981,332 71,268,710 38,712,622 31,300,000 (7,248,336) 24,051,664 62,764,286 49,437,638 13,326,648 General Improvements (GI) 18,854,000 14,607,819 4,246,181 3,350,000 97,854 3,447,854 7,694,035 4,135,938 3,558,097 Recycled Water (RW) 42,869,000 37,128,342 5,740,658 818,000 - 818,000 6,558,658 3,967,481 2,591,177 CIB Contingency - - - - 6,900,000 6,900,000 6,900,000 - 6,900,000 Contingency Bal. Trans. - Close Outs 370,990 370,990 370,990 370,990 Total $ 268,099,482 $ 189,280,021 $ 78,819,461 $ 71,202,000 $ - $ 71,202,000 $ 150,021,461 $ 92,430,226 $ 57,591,235 $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 151Page Capital Improvement Budget Quarterly Results by Program Collection System (CS) IL'l -�r Treatment Plant (TP) General Improvements (GI) Program ■ Approved Expenditures ■ Actual Expenditures October 3, 2024 Regular Board Meeting Agenda Packet - Page 53 of 108 Recycled Water (RW) CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 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 2023.2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023.2024 FY 2023-2024 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023-34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 3 8,252,000 S 850,216 3 7,401,764 S - 3 - S - S 7,401,764 3 7,102,315 S 299,469 '8436 Moragal Crossroads PS Project 35,451,000 35,218,893 232,107 - [47,571] 047,571) 164,536 184,536 - 8443 LG Diameter Pipe line Inspection 795,000 519,075 275,925 500,000 - 500,000 775,925 208,394 567,531 8444 Force Main Inspection Program 125,000 27,736 97,264 500,000 - 500,000 597,264 - 597,264 8447 Pump Station Security Improvement 439,000 302 438,698 82,000 - 82,000 520,696 1,170 519,526 '8449 Collection System Modeling Support 543,000 305,316 237,684 - (225,659) [225,659] 12,025 12,025 - 8450 Development Sewerage Support 4,959,316 4,874,215 85,101 927,000 - 927,000 1,012,101 851,349 160,752 8457 Pump Station Upgrades - Ph. 2 14,650,000 7,967,271 6,682,729 10,000,000 - 10,000,000 16,682,729 10,969,930 5,712,799 8464 Martinez Sewer Renov. Ph. 7 4,581,000 3,130,124 1,450,976 - (12,946) 012,946) 1,437,930 1,437,930 - *8466 Danville Sewer Ren Ph 4 5,202,000 5,028,420 173,580 - (60,615) 060,615] 112,965 112,965 - 100006 Contractual Assessment District Proj Financing 432,940 35,857 397,063 100,000 - 100,000 497,083 035,657] 532,940 100007 Large Diameter Priping Renovation Program 500,000 37,572 462,428 500,000 - 500,000 962,428 220,837 741,591 100017 SR Pump Station Electrical Upgrades 11913,000 648,542 1,264,456 - - - 1,264,456 1,264,129 329 100023 Walnut Creek sewer Renovation Ph 16 6,379,000 4,923,785 1,455,215 - - - 1,455,215 1,560,597 [105,382] 100024 South Orinda Sewer Renovation Ph. 9 500,000 736,330 (236,330) - 250,000 250,000 13,670 17,658 (3,988) 100025 Lafayette Sewer Renov. Ph 15 500,000 547,451 047,451] - 250,000 250,000 202,549 92,427 110,122 100028 Collection System Master Plan 2021 Update 11600,000 296,126 1,303,872 - - - 1,303,872 248,922 1,054,950 100037 Orinda Moraga PS Architectual Improvements 1,450,000 41,952 1,408,048 - C1,000,000] [1,000,000] 408,048 11,368 396,680 100038 San Pablo Watershed Improvements 200,000 43,502 156,498 - (137,471) (137,471) 19,027 19,027 - 100039 Collection System Sewer Renovation Ph. 2 2,950,000 69,907 2,880,093 18,500,000 (12,097,000) 6,403,000 9,283,093 113,156 9,169,937 100041 Buchanan Lift Station Replacements &Improvement£ 200,000 133,151 66,849 850,000 - 850,000 916,849 330,800 586,049 100042 Pump Station Upgrades, Phase 26 3,200,000 125,802 3,074,196 2,500,000 - 2,500,000 5,574,198 1,836,224 3,737,974 100044 Collection System Modeling Support FY 22+ 120,000 617 119,383 125,000 - 125,000 244,383 18,627 225,756 100049 Downtown Walnut Creek Server Renovations, Ph. 1 500,000 256,352 241,646 - 51835,000 5,835,000 6,076,648 5,293,729 782,919 100050 CCI'A A-line Relocation 200,000 12,918 187,082 - 900,000 900,000 1,087,082 500,584 586,498 100052 Na Orinda Sewer Renovations, Ph. 9 500,000 225,068 274,932 - 150,000 150,000 424,932 413,324 11,608 100053 Houston CL Area CAD 252,894 216,648 36,246 - (36,246) 036,246) - - - 100059 Collection System Planning 2023+ - - - 200,000 - 200,000 200,000 110,442 89,558 100060 Pumping Station Equipment & Piping Replacement 2 - - - 200,000 - 200,000 200,000 18,563 181,437 100061 Maintenance Access Cover Modifications 2023+ - - - 400,000 - 400,000 400,000 271,300 128,700 100062 Pumping Station SCADA & PLC Upgrades - - - 350,000 (350,000) - - - - **100065 Tappan Terrace Sewer Renovation - - - - 650,000 650,000 650,000 329,640 320,360 **100066 Martinez Urgent Force Main Replacement - - - - 3,962,000 3,962,000 3,962,000 766,733 3,195,267 "100068 Pleasant Hill Sewer Renovation Ph 3 - - - - 650,000 650,000 650,000 255,753 394,247 **100070 Cedar Lane Sewer Renovations - - - - 600,000 600,000 600,000 18,480 581,520 "100072 Lake Cascade Sewer Renovation - - - - 600,000 600,000 600,000 332,092 267,908 Rounding - - - - - - - - - Taw CSPrugram $ 96,395,150 S 66,275,150 $ 30,120.000 $ 35,734,000 $ (120,508) S 35,613,492 $ 65,733,492 $ 34,SB9,169 S 30,844,323 * Pro] ects open but not in CI6 For 2 3124 ** New project Not in 23124 Budget Funds transferred from other projects or ContingeneF 0161$er 3, 2024 Regular Board Meeting Agenda Packet - Page 54 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 4 - Sewer Construction Fund A B C (A -B) D E F +E G C+D+E H I G -H Cumulative Cumulative Total Project FY 2023.2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023.2024 FY 2023-2024 Prior Year Prior Year Carryforward to I Adopted Budget I Adjusted Approved I Actual Remaining I Budgets Actuals FY 2023-34 Budget Adjustments Bud et Expenditures Expenditures Budget TYPE TP Treatment Plant 7315 Applied Research and Innovations $ 1,957,274 $ 1,592,382 $ 364,892 $ 400,000 $ (200,000) $ 200,000 $ 564,892 $ 80,248 $ 484,644 7328 Influent Pump Electrical improvements 1018861000 10,981,304 (95,304) - 299,830 299,830 204,526 204,525 1 7341 WC/Grayson CreekLeveeRehab 2,150,000 913,162 1,236,838 200,000 - 200,000 1,436,838 373,370 1,063,468 7348 Solids Handling Facility Improvements 27,518,687 23,944,964 3,573,723 14,000,000 - 14,000,000 17,573,723 26,842,272 (9,268,549) -7349 Aeration & Energy Upgrade 5,850,000 4,538,248 1,311,752 - (1,000,000) 01,000,000) 311,752 53,084 259,669 7357 Plant Wide InstrtmientationUpgrade 521,000 193,577 327,423 - - - 327,423 238,125 89,298 7369 Piping Renovation - Phase 10 5,450,000 3,588,846 1,861,154 - 195,000 195,000 2,056,154 2,413,621 (357,467) 7370 Annual Infrastructure Replacement 3,605,000 2,593,784 1,011,216 500,000 - 500,000 1,511,216 1,773,551 (262,335) 7373 Fire Protection System Ph. 3 11100,000 1,065,155 34,845 - - - 34,845 38,251 (3,406) -100001 UPCAAUrgent PrajectsFY2020-25 1,300,000 288,710 1,011,290 400,000 (500,000) (100,000) 911,290 528,679 382,611 100008 LaboratoryRlef&Seismic; upgrades 1,450,000 1,309,661 140,339 - 244,454 244,454 384,793 384,793 - 100009 Hearth Replacement 500,000 291,003 208,997 - 42,380 42,380 251,377 251,377 - 100010 Air Cnndiditioning&LightingRenovation 250,000 185,944 64,056 200,000 - 200,000 264,056 335,934 (71,878) 100011 Plant Electrical Replacement & Rehabilitation 808,371 317,259 491,112 250,000 - 250,000 741,112 216,566 524,546 100012 UV Disinfection Replacement 61000,000 1,609,375 4,391,625 1,500,000 (2,000,000) (500,000) 3,891,625 1,114,559 2,777,066 *100013 UV Hydraulic Improvements 480,000 61603 473,397 - (480,000) (480,000) (6,603) (6,603) - 100014 MRC Building Modifications 8001000 308,034 491,966 600,000 - 600,000 1,091,966 90,387 1,001,579 100015 Electric Olawer Improvements 13,395,000 11,683,853 1,711,147 - 700,000 700,000 2,411,147 2,618,322 (207,175) 100019 AerationBamnsDiffuerReplacementandSeimmuUpj 7,480,000 2,403,362 5,076,638 6,000,000 - 6,000,000 11,076,639 5,888,640 5,187,998 100022 Wet Weather Basin Improvements 1,300,000 538,477 761,523 600,000 - 600,000 1,361,523 222,448 1,139,075 ***100030 Solids Handling Facility Improvements Ph. 2 5,700,000 1,605,220 4,094,780 - (2,900,000) 02,900,000) 1,194,780 334,389 860,391 100032 Steam Renavations, Ph- 1 5,000,000 982,075 4,017,925 31500,000 (1,500,000) 2,000,000 6,017,925 974,252 5,043,673 100034 TP Safety Enhancement Program - - - 300,000 (200,000) 100,000 100,000 161,047 (61,047) 100040 Electrical Infrasturcture Sub 90 500,000 - 500,000 500,000 - 500,000 11000,000 144,335 855,665 100045 Fire Protection System Ph.4 860,000 - 860,000 - - - 860,000 727 859,273 100046 Control System Upgrades 200,000 25,693 174,307 200,000 - 200,000 374,307 41,244 333,063 -100047 Secondary Clarifier Improsznents - Phase 1 2,000,000 - 2,000,000 500,000 (1,000,000) (500,000) 1,500,000 249,164 1,250,836 100048 Warehouse Seismic Upgrades 500,000 - 500,000 - - - 500,000 2,717 497,283 100051 RAS Piping Renovations 2,020,000 302,170 1,717,830 - - - 1,717,830 1,674,270 43,560 100054 Aeration Unit 1Ste-am Turbine Overhaul 200,000 542 1991458 500,000 - 500,000 6991458 1,078,467 (379,009) 100055 Process Optimization and Efficiency 200,000 307 199,693 300,000 - 300,000 499,693 382,980 116,713 100057 Plant Control System 110 Replacement - Phase 3 - - - 600,000 - 600,000 600,000 304,367 295,633 100058 'Treatment Plant Planning 2023+ - - - 250,000 - 250,000 250,000 259,674 (9,674) **100067 POB Parking Lot Improvements - - - - 200,000 200,000 200,000 114,475 85,525 **100069 Odor Control Facilities Improvements - - - - 450,000 450,000 450,000 40,714 409,296 **100073 Piping Renovations - Phase 11 - - - - 200,000 200,000 200,000 10,421 189,579 **100074 Central Chilled Water Plant - - - - 200,000 200,000 200,000 2,246 197,754 Rounding - - - - - - TotalTPProgram S 109,98L332 S 7L26B,710 S 38,712,622 S 31,300,000 S (7,246,336) S 24,06L664 S 62,764,286 S 49,137,638 S 13,326,646 * Projects open but not in CI B far 23124 '* New project Not in 23124 Budget Funds transferred from other projects or Contingency Project budget adjustments to reduce FY 2023-24 budget and fund contingency OM$er 3, 2024 Regular Board Meeting Agenda Packet - Page 55 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 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- CumulativeF=umulyative Total Project FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 Prior Yearear $ 5,3SO,000 $ Carryforward to Adopted Budget Adjusted Approved Actual Remaining Bud etsals 5251 FY 2023-34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE GI General Improvements *8250 ERP Replacement $ 5,3SO,000 $ 5,350,990 $ 29,010 $ - $ (19,384) $ (19,3&4) $ 9,626 $ 9,626 $ - 5251 Capital improvement program& Budget lmprovemer 590,000 520,092 69,905 - - - 69,908 128,806 058,898] 5252 POB EV. Charging Station 640,000 90,570 549,430 650,000 - 650,000 1,199,430 591,633 607,797 *8253 COVID-19 Response 275,000 195,723 76,277 - (54,909) (54,909) 21,368 21,368 - 9516 District Equipment Acquisition 1,726,000 1,672,577 53,423 250,000 100,000 350,000 403,423 297,075 106,345 5517 Vehicle Replacement Program 6,015,000 4,546,748 1,471,252 1,000,000 - 1,000,000 2,471,252 709,804 1,761,448 100003 Property Repairs &improvements 1,150,000 529,356 620,644 150,000 - 150,000 770,644 596,210 (125,566) 100004 HOB Exterior Repairs 400,000 291,102 108,698 - - - 106,696 - 106,696 100027 Furnishings Replacement 100,000 19,271 50,729 - - - 50,729 84,411 (3,652) 100029 Solar ProjectanLagiss 600,000 517,740 52,260 - - - 52,260 6,762 75,495 100031 Community Dev. System Replacement 600,000 29S,SSS 311,112 200,000 - 200,000 511,112 401,271 109,841 100033 Security Improvements FY 2021-25 300,000 155,716 144,82 100,000 - 100,000 244,262 68,267 176,015 100035 Technology Strategic Plan 500,000 336,701 463,299 - - - 463,299 129,536 333,763 100043 Easement Acquisition FY 2022-31 75,000 S,4S6 66,514 75,000 C13S,954] (63,954) 2,560 2,560 - 100056 NetZero Study 200,000 69,756 130,244 - - - 130,244 75,679 54,565 100063 It Development 2023+ - - - 900,000 - 900,000 900,000 654,300 245,700 100064 Capital Legal Sen -ice 2023+ - - - 25,000 - 25,000 25,000 42,431 (17,431) -100071 Long Term Wet Weather Resiliency - - - - 200,000 200,000 200,000 16,199 153,601 **9999 Capital Project Clearing (Accounting Use Only) - 11,101 (11,101) - 11,101 11,101 - - - Rounding - - - - - - - - - Total GI Program $ 18,654,000 $ 14,607,619 $ 4,246,161 S 3,350,000 $ 97,654 S 3,447,654 S 7,694,035 S 4,135,938 S 3,556,097 * Projects open but not in CIE for 2 3124 ** Not in 23124 Budget Funds transferred From other projects or Contingency New project Not in 23124 Budget Funds transferred from other projects or Contingency Oifi$er 3, 2024 Regular Board Meeting Agenda Packet - Page 56 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C (A -B) D E F +E G C+D+E H 1 G - Cumulative Cumulative Total Project FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 Prior Year Prior Year Carryforward to I Adopted Budget I Adjusted Approved I Actual Remaining I Budgets Actuals FY 2023-34 Budget Adjustments Bud et Expenditures Expenditures Budget TYPE RW Recycled Water 7361 Filter Plant & Clearwell Improvements Ph. 1A S 40,389,000 $ 36,677,02G $ 3,711,972 $ - $ - $ - S 3,711,972 $ 3,669,152 $ 42,820 7366 ReW Distribution SystemRenov. Program 530,000 221,750 308,250 215,000 - 215,000 523,250 64,159 459,091 7366 Water Exchange Project 400,000 142,137 257,863 - - - 257,663 - 257,863 100002 Filter Plant & Clearwell Improvements Ph. 16 1,450,000 41,853 1,408,147 500,000 - 500,000 1,906,147 142,657 1,765,490 100036 Zine 1 Recycled Water 2021 100,000 45,574 54,426 103,000 - 103,000 157,426 91,513 65,913 Rounding - - - - - - - - Total RW Program $ 42.969.000 $ 37.128.342 $ 5,740,658 $ 818,000 $ - $ 81:6,000 $ 6,558,658 $ 3.967.461 $ 2.591,177 9990 9990 CONTINGENCY -ALL PROGRAMS $ - $ - $ - $ - $ 6,900,000 $ 6,900,000 $ 6,900,000 $ - $ 6,900,000 CONTINGENCY BAL TRANS - CLOSEOUTS $ - $ - $ - $ - $ 370,990 $ 370,990 $ 370,990 $ - $ 370,990 GRAND TOTAL $ 268,099,482 $ 189,280,021 $ 78,819,461 $ 71,202,000 $ - $ 7L202,000 $ 150,02L461 $ 92,430,226 $ 57,59L235 O&%er 3, 2024 Regular Board Meeting Agenda Packet - Page 57 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 4 - Sewer Construction Fund Capital Budget Transfers (by Project) ' Contingency Projects FY2324 rJoseouU transferred to fvntingency VY 2023-24 Project No. Project Description Q1 Q2 Q3 Q4 Total FY2OZ3- Contingency Houston Ct. Area CAD [36,246] '6253 24 Activity Balance In M3-24, thefollowing projects'budgets were reduced to fund FY 2023-24 Adopted Budget Balance 100043 Easement Acquisition FY 2022-31 (138,954) 7349 Aeration &Energy Upgrade $ 5,1100,1100 100012 UV Disinfection Replacement $ 480,000 $ - $ (2,480,000) $ - $ (2,000,000) - 100013 UV Hydraulic Improvements (480,000) - - - (480,000) - •100065 Tappan Terrace Sewer Renovation 650,000 - - - 650,000 - •100066 Martina Urgent Force Main Replacement 200,000 3,752,000 - - 3,962,000 - •100050 CCPA A -Line Relocation 900,000 - - - 900,000 - 100034 TP Safety Erdiancement Program (200,000) - - - (266,000) - 100067 POO Parking Lot Improvements 200,000 - - - 200,000 - 100039 Collection System Sewer Renovation Ph. 2 (5,835,000) (4,262,000) (1,200,000) (800,000) (12,097,000) - 100049 Downtown Walnut Creek Sewer Renovations, Ph. 1 5,835,000 - - - 5,835,000 - 100068 Pleasant Hill Sewer Renovation Ph. 3 - 500,000 - 150,000 650,000 - •100006 Laboratory Roof& Seismic Upgrades - 235,000 - - 235,000 - '100069 ❑dor Control Facilities Improvements - 450,000 - - 450,000 - 100070 Cedar Lane Sewer Renovations - - 600,000 - 600,000 - 100071 Long Term Wet Weather Resiliency - - 200,000 - 200,000 - 7315 Applied Res earth and Innovations - - (200,000) - (200,000) - 100072 Lake Cascade Sewer Renovation - - 600,000 - 600,000 - 100030 Solids Handling Facility Improvements Ph. 2 - - (400,000) - (400,000) - 100032 Steam Renovations, Ph. 1 - - (1,500,000) - (1,500,000) - 100037 Orinda Moraga PS Architechtural Improvements - - (1,000,000) - (1,000,000) - 100062 Pumping Station SCADA & PLC Upgrades - - (350,000) - (350,000) - 9516 District Equipment Ecquisition - - 100,666 - 100,000 - 100073 Piping Renovations, Ph. 11 - - - 200,000 200,000 - 100074 Central Chilled Water Plant - - - 200,000 200,000 - 100015 Electric Elower Improvments - - - 700,000 700,000 - 7369 TP Piping Renovations, Ph. 10 - - - 195,000 195,000 - 100024 South Orinda Sewer Rmov. Ph. 9 - - - 250,000 250,000 - 100025 Lafayette Sewer Rm-. Ph. 15 - - - 250,000 250,000 - 100052 North Orin" Sewer Rm-. Ph. 9 150,000 150,000 9990 current Year Conti en 1,750,660 685,000 5,630,000 1,295,066 1,960,066 6,900,000 -9990 Contingency transfers to from du a to closeouts 455,768 84,777 370,990 370,990 GRAND TOTAL $ - $ - $ 455,768 S (84,777] S 370,990 S 7,270,990 ' Contingency Projects 024$er 3, 2024 Regular Board Meeting Agenda Packet - Page 58 of 108 FY2324 rJoseouU transferred to fvntingency '8449 Collection System Modeling Support $ (225,559) 100053 Houston Ct. Area CAD [36,246] '6253 COVID-19 Response [54,909] In M3-24, thefollowing projects'budgets were reduced to fund contingency: 100043 Easement Acquisition FY 2022-31 (138,954) 7349 Aeration &Energy Upgrade $ (1,000,000) 7328 Influent Pump Electrical Improvements 299,829 100001 UPCAA Urgent Proi ects FY 2020-25 (500,000) 8250 ERP RTia-ent (19,384] 100030 Solids Handling Facility Improvements Ph. 2 (2,500,000) 8436 8465 Pump Station Pump Starion Upgrades, Ph.l Martinez Sewer Renovations, Ph.7 [47,571] (12,946) 100047 Secondary Clarifier Improvments - Phase 1 (1,000,000) 5466 Danville Sewer Renovations, Ph 4 (50,515) TOTAL $ (5 OQQ,000) 100006 Laboratory Roof & Seismic Upgrades 9,454 100009 Hearth Replacements 42,380 100036 San Pablo Watershed Improvements (137,471) 9999 Capital Project Clearing (Acctg only) 11,101 TOTAL S (370,991) 024$er 3, 2024 Regular Board Meeting Agenda Packet - Page 58 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 5 - Self Insurance Fund Revenues by Source $2,000,000 $1,500,000 $1,000,000 $500,000 211Page Year -to -Date Revenues by Source Sewer Service Charge Insurance Recoveries (HHW) Subrogation Recoveries Revenue Source Category ■ YTD ■ YTD Budget Actual October 3, 2024 Regular Board Meeting Agenda Packet - Page 59 of 108 r Investment Income 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,676,752 $ 1,676,752 $ 0.0% $ 1,676,752 100.0% Insurance Recoveries (HHW) 24,000 14,195 (9,806) -40.9% 24,000 14,195 (9,806) -40.9% 24,000 59.1% Subrogation Recoveries - - - - 4,300 4,300 - Investment Income 79,075 114,221 35,146 44.4% 316,300 391,238 74,938 23.7% 316,300 123.7% Total Revenues $ 103,075 $ 128,416 $ 25,341 24.6% $ 2,017,052 $ 2,086,484 $ 69,432 3.4% $ 2,017,052 103.4% $2,000,000 $1,500,000 $1,000,000 $500,000 211Page Year -to -Date Revenues by Source Sewer Service Charge Insurance Recoveries (HHW) Subrogation Recoveries Revenue Source Category ■ YTD ■ YTD Budget Actual October 3, 2024 Regular Board Meeting Agenda Packet - Page 59 of 108 r Investment Income CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 5 - Self Insurance Fund Expenses by Type 221Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 60 of 108 Year -to -Date Expenses by Type $1,800,000 $1,600,000 $1,400,000 $1,200,000 Annual $800,000 $600,000 QTD $400,000 $200,000 YTD Budget Professional Services Technical Services Insurance & Risk Management QTD QTD Variance Variance YTD YTD YTD Variance Variance Annual Realized Category QTD Budget Actual ($) (%) Budget Actual ($) (%) Budget (%) Professional Services $ 93,750 $ 23,910 $ 69,840 74.5% $ 875,000 $ 776,866 $ 98,135 11.2% $ 875,000 88.8% Technical Services 13,750 6,929 6,821 49.6% 55,000 9,994 45,006 81.8% 55,000 18.2% Insurance & Risk Management 432,500 5,035 427,465 98.8% 1,730,000 1,670,484 59,516 3.4% 1,730,000 96.5% Total Expenses $ 540,000 $ 35,874 $ 504,126 93.4% $ 2,660,000 $ 2,457,343 $ 202,657 7.6% $ 2,660,000 92.4% 221Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 60 of 108 Year -to -Date Expenses by Type $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 221Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 60 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 6 - Debt Service Fund Revenues by Source 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 231Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 61 of 108 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Estimate (%) Tax Revenue $ 952,125 $ (1,278,101) $ (2,230,226) -234.2% $ 9,160,142 $ 7,874,500 $ (1,285,643) -14.0% $ 9,160,142 86.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 231Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 61 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 6 - Debt Service Fund Expenses by Type Year -to -Date Expenses by Type $8,000,000 $6,000,000 $4,000,000 $2,000,000 Eimw Professional Services Principal Payment Expense Interest Expense ■ YTD ■ YTD Budget Actual 241Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 62 of 108 Annual YTD Budget QTD QTD QTD QTD YTD YTD YTD Variance Annual Variance Category Budget Actual Variance ($) Variance (%) Budget Actual Variance ($) (%) Estimate (%) Professional Services $ - $ $ $ 6,000 $ 5,800 $ 200 3.3% $ 6,000 96.7% Principal Payment Expense 7,090,000 7,090,000 100.0% 7,090,000 7,090,000 - 0.0% 7,090,000 100.0% Interest Expense 372,672 (173,226) 545,898 146.5% 2,064,142 772,900 1,291,243 62.6% 2,064,142 267.1% Total Expenses $ 7,462,672 $ (173,226) $ 7,635,898 102.3% $ 9,160,142 $ 7,868,700 $ 1,291,443 14.1% $ 9,160,142 85.9% Year -to -Date Expenses by Type $8,000,000 $6,000,000 $4,000,000 $2,000,000 Eimw Professional Services Principal Payment Expense Interest Expense ■ YTD ■ YTD Budget Actual 241Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 62 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 7 - Quarterly Investment Portfolios Operating & Maintenance Fund 251Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 63 of 108 QTD YTD Purchase Maturity Days to Annual Cash BOQ Purchase EDQ EDQ %of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Face Valve (Matnrdy) Face Value MarketVal Portfolio Income Income 519 state cf. Cahf. LAO n/a n/a n/a (t) S 26,000,080 S 19,500,000 $ 6,508,000 S 26,000,800 S 25,904,217 86.67% $ 283,542 S 755,443 RE22 VST Notes us Treasury 5/19/2022 4/30/24 0 2.661% 1,495,430 1,500,000 (1,500,000) - - 0.00% 107 11125 RE27 VSTNotes lls Treasury 4/30/24 7/30/2024 30 5.344% 4,936567 - 4,000,006 4,000,000 3,983,080 13.33% 36,029 99,462 (3) $ 32,431.996 $ 21,000.000 $ 9X00.000 $ 30.000,000 S 29.887,297 100.00% 319,678 856,030 (2) (4) (5) 10,698 51,937 $ 330.376 $ 907.967 Legend: EOQ-End ofquarter 3DQ - eegimucig of quarter YTD = Year to Date Reference: [3) Annual yield of LocalAgency 1—tment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of Pune 2024 was 4,48%. [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.60%. As the District is a voluntary participant in the County Treasury Pool this calculation excludes investments purchased after the 15th day ofthe month, which is the cut -oft for month-end reporting by Contra Costa County. [4) The market value of the portfnho on funs 30, 2024 was 529,887,297. GASB 31 requires adjusting iuvestments to market value. The DLsLL will adjust aurmally, but nepurt uurrket values quarterly. [5) Amount represents interest income from prior period investments. Notes: [A) All investments held by the Running Expense Fund comply with Central 5an's investment policy approved by the Board of Directors [California Government Code §53646(h)(2)], [B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures fthe Running Expense fund for the next six (6) months [Californta Government Code §53646(6)[3]] [C) Df the total investments held m the Running Expense Fund, 59,660,000 is restricted for the Rate Stabilization Fund Account. 251Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 63 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 7 - Quarterly Investment Portfolios Sewer Construction Fund No Purchase Manaity Daysto Annual Cash BGQ Issuer Type bate Daze Maturity Yield Ondap Face Value Purchase (Maturity) EOQ Face Yalue EOQ Market Value 4fi Of Portfolio QTDYTTa lmestment ]¢come Investment I- 519 Stam of Calif. LAIF n/a n/a n%a (1) 1 17,500,000 $ 7,506,600 S 10,000,000 $ 17,500,000 $ 17,435,531 12.77% 149,090 $ 614,239 961 [IS T 661 US Treasury 1/21120xa 1/15/2025 199 1.26% 2,490,039 25061600 - 2,500,000 $ 2,444,950 1.92% 793 31188 964 FSC Notes US Treasury 5/19120Za 4/30/2024 0 2.66% 2.492,383 25061600 (2,500,000) - $ - O,DC% 179 1,674 984 IIS Treasury US Treasury 1/26120x4 4/25/2024 0 5.36% a4,G75400 25,066,600 (25,000,006) - $ - 0100% 86,667 325,600 985 IIS Treasury US Treasury 3/112024 5/313/21324 0 5.37% 5.921,775 6,006,600 (6,000,006) - $ - "()% SL281 78,225 986 IIS Tt' a 77 US Treasury 3/15/2024 6/13/2024 0 5.39% 49,346,250 50,006,600 (50,000,000) - $ - 000% 530,264 653,750 987 US Treasury US Treasury 3/20/20x4 6/18/ZO24 0 5.36% 35,531550 36,006,600 (36,000.000) - $ - OA04$ 4051990 463,450 988 IIS Treasury US Treasury 4/25/20x4 7/25/24x4 a5 5.40% 19,738,000 - 20,000.006 26,600,000 $ 19,930,400 14.60% 192,133 1921133 989 IIS Treasury US Treasury 4/30/2024 7/313/2024 30 5.37% 14,801,696 - 15,000.000 15,000.000 $ 14,936,550 10.95% 135,108 135,108 990 IIS Treasury US Treasury 6/17/2024 9/la/2924 74 5.38% 49,367,075 - 50,000.000 50,000.000 $ 45,470,000 3650% 10L850 101,B50 991 US Treasury US Treasury 6/25120a4 9/19/aOa4 81 5.35% 31,601,877 32.000.000 32,0001000 $ 31,629,440 23.36% 27,776 27,776 (3)5253,4!65,645 S129S00,000 S 7.504,000 5137,000.000 _L!15.B+6871 100.00% 116811130 2,661,595 (2) (4) (5) 5.240 3,614,605 118.41L344.40 $ 1.686.376 S 6.221201 Legead: EDQ =End of quarter BOQ = Beginning of quarter YTD = Year to Dam Befereree: (1) Annual Yield 4L-1 Agency lnvestent Fund CLAIF) vanes with the compcsitiomof the Fund. The estimated yield as ofjune 2024 was 44891& (2) The face value indicates the value of the i -Amen if Geld until mat—hy, which is the usual Di arict p—lice. (3) The —ghted average yield of the total Sev4er Constructs— portfolio is 5.20%. As the District is a voluntary participant in the County Treasury Pod. this calnilation excludes investments purd—ed after the 15th day of the month. which i5 the cut- off for month-end reimnina by Contra Costa County. (4) Thea—Imtvalue oftheportfolio onjune 30. 2024was SL35,B46,B71. GASB 3L requires adjmtinginvestments t—ketvalue. The Mi tictwill adjust --a markmvalues monthly. (5) Amount represents investment Inco ne from prior period investments Notes: (A) All investments held by the Se— Comtrunion Fund comply with Central San'si—tutent policy approved bythe Board ofDir t—[CAA—ia Government Cade §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central Sm to meet budgeted expenditum ofthe Sewer Co tructiom fund for the next six (6) months [California Government Cade §53646(b)(3)]. (C) Ofthe total investments held mthe Sewer Comtrunion Fund, S 1,000,000 isrestricmd for the Rate Stabilimtiom Reserve Account 261Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 64 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 7 - Quarterly Investment Portfolios Self -Insurance Fund 271Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 65 of 108 QTD YTD Purchase Maturity Days to Annual Cash BOQ Purchase EDQ EDQ 46 of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Fare Value (Maturity) Face Value Market Value Portfolio Income Income 519 State DlCalif. LAIF n/a (1) S 10,100,000 S 10,100,000 S - S 10,100,000 S 10,062,792 100.00% S 169,772 $ 375,845 (3) S 10,100,060 S 10,1001000 S - S 10,100,060 S 10,062,792 100.00% 109,772 375,845 (2) (4] [5) 4,450 15,393 $ 114,221 $ 391,238 Legend: EOQ=End ofquarter EDQ = Beginning cf quarter YTD - Year to Date Reference: (1) Annual yield of Local Agency 1—stment Fund (LAIF) varies with the -.position of the Fund. The estimated yield as of fume 2024 was 4A8%. (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 cf the total Self -Insurance portfolio is 446%. (4) The market value of the portfoho on June 30, 2024 was 510,062,792. [51 Amount represents interest income from prior period investments. Not— (A) All investments held by the Self [--a-. Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(6)[2]]. (B) SLffrcient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures ofthe Self Insurance fund for the nest six (6) months [Cabfumta Government Code §53646(6)[3]] 271Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 65 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 $50.0 $45.0 $40.0 $35.0 $30.0 $29. $25.0 $20.0 $15.0 $10.0 $5.0 $0.0 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts O&M Fund Cashflow Forecast & Results FY 2023-24 Running Expense Fund Total Cash & Investment Balances (Actuals through June 2024) $43.9 $40.1 . $3F&- June '23 $21.0 $25.9 $24.8 $20.8 $20.0 $19.6 $15.0 $14.6 $12.7 Ul July August September October November December January February March =Projected Balance* IIIIIIIIIIIIIIIIActual Balance —Reserve Target at Year End** $46.6 April May June $30.2 *Projected balances were generated in July 2023 based on budgeted revenues and expenses for FY 2023-24 and applied to the actual balance as of June 30, 3023. **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 for which projections and actuals are shown in the chart, working capital reserve targets includes other current assets, and is net of current liabilities. Once adjusted for these other factors, actual working capital reserves exceeded the target as of June 30, 2024. 281Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 66 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 $160.0 $140.0 $120.0 $100.0 $80.0 $60.0 $40.0 $20.0 $0.0 $138.0 $135.0 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast & Results FY 2023-24 Sewer Construction Fund Total Cash & Investment Balances (Actuals through June 2024) F $151.5 4.5 $100.0 $99.5 June '23 July August September October November December January February March April May June MProjected Balance* MActual Balance -Reserve Target at Year End** 8 *Projected balances were generated in July 2023 based on budgeted revenues and expenses for FY 2023-24 and applied to the actual balance as of June 30, 3023. **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 for which projections and actuals are shown in the chart, working capital reserve targets includes other current assets, and is net of current liabilities. 291Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 67 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Staffing Trends 301Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 68 of 108 300 6.5% 295 6.4% 290 6.0% 19 285 16 E— " i 280 �_ 5.5% °' 5.4% M 275 w E 270 5.2% 5.0% �= I w 265 278 4.8% 278 279 276 260 4.5% 255 250 — 4.0% 6/30/2021 6/30/2022 6/30/2023 6/30/24 Quarter Ended Filled Positions (FTEs) o Vacancies (FTEs) Vacancy Rate 301Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 68 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated $4,000 $3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 311Page Historical Quarterly 0&M Cost per Million Gallons Treated $4,204 $4,517 $3,188 $3,677 6/30/21 6/30/22 6/30/23 6/30/24 Quarter Ended October 3, 2024 Regular Board Meeting Agenda Packet - Page 69 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Total Sewer Construction Fund Budget to Actual Spending Trend Sewer Construction Fund (in millions) $150 Sfsx.i $140 $190 $129 30.8 r $110 r J r $100 $92.4 $90 r�r $80 r� ry $70 r� $60 r $50 �+ Y r $40 r r * r Y $30 r � rr $20 July August September October November December January February March April May June Budget —+— Target (90% of Budget) Actual 321Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 70 of 108 CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Collection System Program $70 $65 $60 $55 $50 $45 $40 $35 $3o $25 $20 $15 $10 $5 331Page Budget to Actual Spending Trend Collection System Program (in millions) July August September October November December January February W Budget - •Target (90% of Budget] Actual ex October 3, 2024 Regular Board Meeting Agenda Packet - Page 71 of 108 $67.96 March April May June CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Treatment Program 341Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 72 of 108 Budget to Actual Spending Trend Treatment Program (in millions) $70 $ 65 $62.69 $60 $55 `~ $56.42 $50 $45 $49.32 $40 - Ja - $35 _ - Air" $30 _ $25 - $20 - $15 $5$_ July August September October November December January February March April May June Budget -Target(90%ofBudget) Actual 341Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 72 of 108 -ZNCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed / Renovated 2.5 2.0 2.0 1.8 1.7 1.6 v � 1.5 0 U 0.9 a. 1.0 0 0.6 .6 0.5 0.5 0.0 a �''0 ��'3 1tiI31Iti� 3I31Iti°` 6130 ��� Quarter Ending ■ Actual Construction ■ Target ("S -Curve" of 6 mi. FY 23-24 Budget Projection) 351Page October 3, 2024 Regular Board Meeting Agenda Packet - Page 73 of 108