Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
03.c. Receive Quarterly Financial Review for the fourth quarter of Fiscal Year (FY) 2023-24 ending June 30, 2024 (Unaudited)
Page 1 of 38 Item 3.c. F__1_448�411C_S0 September 17, 2024 TO: FINANCE COMMITTEE 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 FOURTH QUARTER OF FISCAL YEAR (FY) 2023-24 ENDING JUNE 30, 2024 (UNAUDITED) 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, June 30, 2024 September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 38 of 139 Quarterly Financial Review CENTRAL SAN _ n - ArJ - _ i zi I Ended June 30, 2024 =CD - , CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Table of Contents Section1 - Executive Summary................................................................................................................................................................................................1 Section2 - 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 CapitalBudget Transfers (by Project by Month).....................................................................................................................................................................19 Section 5 - Self Insurance Fund Revenuesby Source.............................................................................................................................................................................................................................20 September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 40 of 139 =CD 5019 IMHOFF PLACE, MARTINEZ, CA 9A553-A392 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 Costper Million Gallons of Wastewater Treated..................................................................................................................................................................... 30 CapitalSpending Trends.................................................................................................................................................................................................................... 31 Milesof Pipeline Constructed/Renovated.................................................................................................................................................................................. 34 September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 41 of 139 =CD 5019 IMHOFF PLACE, MARTINEZ, CA 9A553-A392 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 C&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 September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 42 of 139 =CD 5019 IMHOFF PLACE, MARTINEZ, CA 9A553-A392 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.OM), 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 September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 43 of 139 =CD 5019 IMHOFF PLACE, MARTINEZ, CA 9A553-A392 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 0&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 September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 44 of 139 =CD - , CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 2 -Financial Results Summary by Fund Category YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) Fund Revenues 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 $50,000,000 W1000,00 $01000,000 $35.000,000 - $30,000,000 $25,000,000 - $20.000,000 $151000,000 $10.000,000 85,000,Dao 8- 0&M Sewer ConstruRion Selflnsurance Debt Service Fund •YTD •YTD Budgce Actual 4 1 P a g e YTD Budget -to -Actual Expenses by Fund $70,000.000 $50000,000 $50,000,000 $40,000,000 $30,000,000 820,000,000 830,000,000 8 O&M Sewer Co-_ Selflnsurance Deb[Service Fund •YTD •YTD ftdget Aca�al September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 45 of 139 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 Investment Income September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 46 of 139 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 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 $ 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 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 - - - - - - - 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% 6 1 P a g e September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 47 of 139 .AMCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-439Z Budget -to -Actual Financial Report Quarter Ending June 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 ($] (0/0) Budget Actual Variance [$] (0/0) Budget (0/0) Salaries & Wages S 10,752,257 $ 10,209,778 S 542,480 5.0°% $ 45,144,569 $ 42,846,307 $ 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) -OA% 13,654,823 100A% Unfunded Liability Costs 424,572 427,636 (3,064) A.7% 1,2D0,503 1,201,925 (1,422) A.1°% 1,2D0,583 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 98A% 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 (B99,061) -25.2% 14,298,822 13,931,705 367,117 2.6% 14,298,822 97A% Other Expenses 413,639 210,155 203,485 49.8% 1,703,885 1,237,215 466,67D 27A% 1,703,885 72.6% Total Expenses $ 22,407,375 $ 21,959,393 5 447,982 2.00/0 $ 90,946,671 $ 85,489,062 5 5,457,609 6.0% $ 90,946,671 94 00% Year -to -Date Expenses by Type $35, 000,000 $30, 000,000 $25, 000,000 $20, 000,000 $15,000,000 $10,000,000 f 00 $5,000,000 r 00 Salaries & Wages Employee Benefits Unfunded Liability Purchased Property Other Purchased Supplies & Materials Other Expenses Costs Services Services YTD YTD Budget Actual 7 1 P a g e September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 48 of 139 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 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance (5) (1/0) Budget Actual Variance {$] (0/o) 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 C50,330] -11.7% 1,913,093 1,660,820 252,273 13.2% 1,913,093 8&8°% Premium Pay 830,372 865,076 C34,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,0001 -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] (240S92) 16.3% (6,261,749) (5,270,1031 (991,645) 15.8% (6,261,7491 84.2°% Total 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 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°% DPEB 410,250 35,250 375,000 91A% 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 19A% 5,070,924 4,897,226 173,698 3.4°% 5,070,924 9&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 C61,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.60/0 7,697,774 98.4°% (Continued on page 9) 8 1 P a g e September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 49 of 139 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Expenses by Type - Detail (Continued) Other Purchased Services Professional Services Technical Services Other Purchased Services Total Other Purchased Services Supplies & Materials Utilities & Fuel Chemicals General Supplies Total Supplies & Materials Other Expenses Memberships Training & Meetings Miscellaneous Other Total Other Expenses Total Expenses 9 1 P a g e Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund QTD QTD Budget ,actual Annual QTD YTD Budget QTD Variance YTD YTD YTD Variance Annual Realized Variance [$] (1/0) Budget Actual Variance {$] (0/0) Budget (1/0) 390,398 417,958 (27,461) -7.0% 1,557,534 963,086 594,448 36.20A 1,557,534 61.80A 798,019 415,304 382,715 48.0% 3,160,776 1,7D8,663 1,452,113 45.90A 3,160,776 54.10A 628,925 549,563 79,362 12.6% 2,527,985 2,323,389 204,596 8.10A 2,527,985 91.90A 1,917,341 1,392,726 434,616 23.9% 7,246,295 4,995,138 2,251,157 31.1% 7,246,295 68.9%u 2,074,966 2,920,381 (845,416) -40.7% 8,299,862 8,863,283 (563,421) -6.8% 8,299,862 106.8% 740,000 738,505 1,495 0.2% 2,960,000 2,724,827 235,173 7.90A 2,96D,D00 92.10A 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,029 4,462,089 (899,061)-25.2°/0 14,298,822 13,931,705 367,117 2.6% 14,298,822 97.4%u 184,024 84,339 99,685 54.2% 761,030 621,990 139,040 16A0A 761,830 81.60A 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.0% 197,742 49.0% 418,639 210,155 200,485 49.8% 1,703,895 1,237,215 466,670 27.4% 1,703,995 72.6%u S 22,407,375 $ 21,959,393 $ 4-47,982 2.0% $ 90,946,671 S 85,489,062 $ 5,457,609 6.0% $ 90.946,671 94.0%u September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 50 of 139 .AMCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-439Z Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Summary (by Department) Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($] (%] Budget °/a 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 — — iL $10,000,000 $5,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services ■ YTD ■ YTD Budget Actual 101Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 51 of 139 .AMCENTRAL 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 QTD QTD QTD Variance YTD Organizational Unit Budget Actual Variance ($) (%) Budget Executive Governance Annual YTD Budget YTD YTD Variance Annual Realized Actual Variance ($) (%) Budget (%) Office of the General Manager $ 444,516 $ 249,893 $ 194,623 43.8% $ 1,852,510 $ 1,006,532 $ 845,978 45.7% $ 1,852,510 54.3% Office of the Secretary of the District 210,991 266,237 (55,246) -26.2% 938,800 809,426 129,374 13.8% 938,800 86.2% Board of Directors 95,086 60,785 34,301 36.1% 377,811 193,394 184,417 48.8% 377,811 51.2% Administration Office of the Director of Finance and Administration 169,732 181,082 (11,350) -6.7% 688,243 669,865 18,378 2.7% 688,243 97.3% Finance Division 539,386 630,512 (91,125) -16.9% 2,415,433 2,138,780 276,652 11.5% 2,415,433 88.5% Human Resources Division 1,840,407 1,896,618 (56,211) -3.1% 6,930,837 6,255,187 675,650 9.7% 6,930,837 90.3% Purchasing Division 451,776 432,868 18,908 4.2% 1,887,015 1,708,478 178,537 9.S% 1,887,015 90.5% Risk Management Program 372,621 385,394 (12,773) -3.4% 1,514,204 1,412,138 102,067 6.7% 1,514,204 93.3% Public Info/Comm. Services & Intergov Relations Division 593,858 573,931 19,927 3.4% 2,176,322 1,967,637 208,686 9.6% 2,176,322 90.4% Information Technology Division 1,680,637 1,392,389 288,248 17.2% 6,294,147 5,795,809 498,338 7.9% 6,294,147 92.1% 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 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.5% 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.4% 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% 111Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 52 of 139 V-41-1-IC-S 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 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 27,786,506 11,402,898 69.6% 29,374,358 40,171,288 10,796,930 36.8% 42,874,358 93.7% Total Revenue $ 38,571,230 $ 50,596,685 $ 12,025,475 31.2% $ 79,626,163 $ 90,44S,SS7 $ 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 121Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 53 of 139 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Revenues by Source - Detail Sewer Service Charges (SSC) Over -the -Counter County Allocated Direct Billed Prior Year Adjustment Other Capital Revenues Facilities Capacity Fees - Gravity Zone Facilities Capacity Fees - Pump Zone Capacity Use Charge Secured Property Tax Unsecured Property Tax Investment Income Other Government Revenue - Concord State Revolving Fund Loan Proceeds Overtime Inspection Plan Review Main Lines Inspection Fees Rebates to District Other Agency Reimbursement Miscellaneous Income Alhambra Valley Assessment District Contractual Assessment District Total Revenues 131Page Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 4 - Sewer Construction Fund QTD QTD QTD QTD Revenue YTD Budget Actual Variance ($) (%) Budget $ 38,513 $ 78,177 $ 39,664 103.0% $ 154,051 22,154,591 22,718,039 563,448 2.5% 49,232,424 13,964 13,964 887,337 (5,S02) - 5,502 -100.0% (22,007) Annual YTD Budget YTD YTD Revenue Annual Realized Actual Variance ($) (%) Budget (%) $ 239,997 $ 85,946 55.8% $ 154,051 155.8% 49,109,500 (122,924) -0.2% 49,232,424 99.8% 935,717 48,380 5.5% 887,337 105.5% (10,946) 11,061 -50.3% (22,007) 49.7% 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% 26,250 - (26,250) -100.0% 105,000 159,362 54,362 51.8% 105,000 151.8% 12,500 185 (12,315) -98.5% 50,000 47,229 (2,771) -5.5% 50,000 94.5% 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% - 69,204 69,204 500,000 788,053 288,053 57.6% 500,000 157.6% 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% 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% 500,000 580,591 80,591 16.1% 500,000 580,591 80,591 16.1% 14,000,000 4.1% 1,500 371 (1,129) -75.3% 6,000 3,923 (2,077) -34.6% 6,000 65.4% 22,250 15,084 (7,166) -32.2% 89,000 92,826 3,826 4.3% 89,000 104.3% 75,000 24,756 (50,244) -67.0% 300,000 65,142 (234,858) -78.3% 300,000 21.7% - 436,054 436,054 - 505,561 505,561 250 - (250) -100.0% 1,000 9,174 8,174 817.4% 1,000 917.4% 38,228 38,228 23,080 23,080 $ 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% September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 54 of 139 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 I Adopted Budget Adjusted I Approved Actual Remaining Budgets Actuals FY 2023-34 1 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 Capital Improvement Budget Quarterly Results by Program $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 Collection System (CS) 141Page Treatment Plant(TP) General Improvements (GI) Recycled Water (RW) Program ■ Approved Expenditures ■ Actual Expenditures September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 55 of 139 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 +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 $ 8,252,000 $ 550,216 $ 7,401,764 $ - $ - $ - $ 7,401,7S4 $ 7,102,315 $ 299,469 *8436 Moragaf Crossroads PS Project 35,451,000 35,215,593 232,107 - [47,571) C47,571] 164,536 184,536 - 5443 LG Diameter Pipe line Inspection 795,000 519,075 275,925 500,000 - 500,000 775,925 205,394 567,531 8444 Force Main Inspection Program 125,000 27,736 97,26-4 500,000 - 500,000 597,264 - 597,264 5447 Pump Station Security ImproVrement 439,000 302 438,69E 52,000 - 52,000 520,69E 1,170 519,52E *6449 Collection System Modeling Support 543,000 305,316 237,664 - (225,659) (225,659) 12,025 12,025 - 8450 Development Sewerage Support 4,959,316 4,574,215 95,101 927,000 - 927,000 1,012,101 951,349 160,752 8457 Pump Station Upgrades - Ph 2 14,650,000 7,967,271 6,652,729 10,000,000 - 10,000,000 16,682,729 10,969,930 5,712,799 8464 Martinez Sewer Renov. Ph. 7 4,551,000 3,130,124 1,450,576 - (12,946) C12,946) 1,437,930 1,437,930 - *8466 Danville SewerRen. Ph.4 5,202,000 5,023,420 173,590 - (60,615) (60,615) 112,965 112,965 - 100006 Contractual Assessment District Proj Financing 432,940 35,957 397,093 100,000 - 100,000 497,OS3 C35,657] 532,940 100007 Large Diameter Priping Renovation Program 500,000 37,572 462,42E 500,000 - 500,000 962,42E 220,537 741,591 100017 SR Pump Station Electrical Upgrades 1,913,000 645,542 1,264,459 - - - 1,264,456 1,264,129 329 100023 Walnut Creek Sewer Renovation Ph. 16 6,379,000 4,923,795 1,455,215 - - - 1,455,215 1,560,597 (105,392) 100024 South Orinda Sewer Renovation Ph. 9 500,000 736,330 (236,330) - 250,000 250,000 13,670 17,659 (3,98S) 100025 Lafayette Sewer Renov. Ph. 15 500,000 547,451 (47,451) - 250,000 250,000 202,549 92,427 110,122 100026 Collection System Master Plan 2021 Update 11600,000 296,126 1,303,972 - - - 1,303,972 245,922 1,054,950 100037 Orinda Moraga PS Architectual Improvements 1,450,000 41,952 1,408,04E - C1,000,000] (1,000,000) 40S,04S 11,363 396,690 100036 San Pablo Watershed Improvements 200,000 43,502 156,49E - (137,471) (137,471) 19,027 19,027 - 100039 Collection System Sewer Renovation Ph. 2 2,950,000 69,907 2,990,093 16,500,000 C12,097,000] 6,403,000 9,253,093 113,156 9,169,937 100041 Buchanan Lift Station Replacements &Improvements 200,000 133,151 66,549 550,000 - 550,000 916,549 330,500 556,049 100042 Pump Station Upgrades, Phase 26 3,200,000 125,602 3,074,19E 2,500,000 - 2,500,000 5,574,199 1,936,224 3,737,974 100044 Collection System Modeling Support FY 22+ 120,000 617 119,393 125,000 - 125,000 244,353 15,627 225,756 100049 Downtown Walnut Creek Sewer Renovations, Ph. 1 500,000 259,352 241,646 - 5,535,000 51935,000 6,076,649 5,293,729 752,919 100050 CCI'A A -line Relocation 200,000 12,918 187,082 - 900,000 900,000 1,087,OS2 500,554 556,495 100052 No, Orinda Sewer Renovations, Ph. 9 500,000 225,066 274,932 - 150,000 150,000 424,932 413,324 11,60E 100053 Houston Ct Area CAD 252,594 216,64E 36,246 - (36,246) C36,246) - - - 100059 Collection System Planning 2 0 2 3 + - - - 200,000 - 200,000 200,000 110,442 69,555 100060 Pumping Station Equipment & Piping Replacement 2 - - - 200,000 - 200,000 200,000 19,563 181,437 100061 Maintenance Access Cover Modifications 2023+ - - - 400,000 - 400,000 400,000 271,300 125,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 -100069 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 19,4S0 561,520 -100072 Lake Cascade Sewer Renovation - - - - 600,000 600,000 600,000 332,092 267,908 Rounding - - - - - - - - - Tow CSProgram $ 96,395,150 S 66,275,150 $ 3%120,000 $ 35.734,000 S [120,508] $ 35,613A92 S 65,733,492 $ 34,889,169 S 30,844,323 * Projects open but not in CI 6 For 2 3 f 24 New pro] ect Not in 2 3124 Budget Funds transferred from other p rcj ects or Contingency S*4rRtx-g1e7, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 56 of 139 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 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,392 $ 36.4,992 $ 400,000 $ (200,000) $ 200,000 $ 564,892 $ 90,249 $ 484,644 7329 Influent Pump Electrical improvements 1018861000 10,991,304 (95,304) - 299,830 299,630 204,526 204,525 1 7341 WC/Grayson Creek Levee Rehab 2,150,000 913,162 1,236,838 200,000 - 200,000 1,436,838 373,370 1,063,469 7349 Solids Handling Facility Improvements 27,519,697 23,944,964 3,573,723 14,000,000 - 14,000,000 17,573,723 26,S42,272 (9,268,549) -7349 Aeration & Energy Upgrade 5,850,000 4,539,243 1,311,752 - (1,000,000) C1,000,000) 311,752 53,OS4 259,669 7357 Plant Wide Instrumentation Upgrade 521,000 193,577 327,423 - - - 327,423 239,125 89,298 7369 Piping Renovation - Phase 10 5,450,000 3,588,S46 1,961,154 - 195,000 195,000 2,056,154 2,413,621 (357,467) 7370 Annual Infrastructure Replacement 3,605,000 2,593,704 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 39,251 (3,406) -100001 UPCAA Urgent Praj ects FY 2020-25 1,300,000 299,710 1,011,290 400,000 (500,000) (100,000) 911,290 528,679 392,611 100008 Laboratory Roof&Seismic; upgrades 1,450,000 1,309,661 140,339 - 244,454 244,454 354,793 384,793 - 100009 Hearth Replacement 500,000 291,003 208,997 - 42,380 42,390 251,377 251,377 - 100010 Air Condiditioning&LightingRenovation 250,000 195,944 64,056 200,000 - 200,000 264,056 335,934 (71,979) 100011 Plant Electrical Replacement & Rehabilitation 909,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,991,625 1,114,559 2,777,066 *100013 UV Hydraulic improvements 480,000 6,603 473,397 - (480,000) [490,000) (6,603) (6,603) - 100014 MRC Building Modifications 8001000 309,034 491,966 600,000 - 600,000 1,091,966 90,397 1,001,579 100015 Electric Blower Improvements 13,395,000 11,683,853 1,711,147 - 700,000 700,000 2,411,147 2,618,322 (207,175) 100019 Aeration BasinsDifluerReplacement and SeismucUpl 7,490,000 2,403,362 5,076,638 6,000,000 - 6,000,000 11,076,639 5,888,640 5,167,999 100022 Wet Weather Basin Improvements 1,300,000 539,477 761,523 600,000 - 600,000 1,361,523 222,448 1,139,075 iq*100030 Solids Handling Facility Improvements Ph. 2 5,700,000 1,605,220 4,094,780 - (2,900,000) C2,900,000) 1,194,780 334,389 860,391 100032 Steam Renovations, Ph- 1 5,000,000 982,075 4,017,925 3,500,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 1,000,000 144,335 955,665 100045 Fire Protection System Ph.4 860,000 - 960,000 - - - 960,000 727 959,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) 11500,000 249,164 1,250,936 100048 Warehouse Seismic Upgrades 500,000 - 500,000 - - - 500,000 2,717 497,293 100051 RAS Piping Renovations 21020,000 302,170 1,717,830 - - - 1,717,930 1,674,270 43,560 100054 Aeration Unit 1 Steam Turbine Overhaul 200,000 542 199,458 500,000 - 500,000 699,458 1,078,467 (379,009) 100055 Process Optimization and Efficiency 200,000 307 199,693 300,000 - 300,000 499,693 392,990 116,713 100057 Plant Control System 1 f0 Replacement - Phase 3 - - - 600,000 - 600,000 600,000 304,367 295,633 100059 Treatment Plant Planning 2023+ - - - 250,000 - 250,000 250,000 259,674 (9,674) -100067 POE 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 7L268,710 $ 38,712,622 S 3L300,000 S (7,248,336) $ 24,05L664 S 62,764,286 S 49,437,638 S 13,326,648 * Projects open but not in CI B Far 23 f 24 New project Not in 23124 Budget Funds transferred from ether projects or Contingency *'* Project budget adjustments to reduce FY 2023-24 budget and fund contingency S�t4rRtx-g1E7, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 57 of 139 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 I G-H Cumulativer=mulyative Total Project FY 2023.2024 FY 2023.2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 Prior Yearer Carryforward to Adopted Budget Adjusted Approved Actual Remaining Bud etsals FY2023-34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE GI General Improvements *G250 ERP Replacement $ 5,330,000 $ 5,350,990 $ 29,010 $ - $ (19,3S4) $ C19,3 S4) $ 9,626 $ 9,626 $ - S251 Capital improvement program& Budget lmprovemer 590,000 520,092 69,90G - - - 69,906 126,606 C56,G96) 9252 PC EV. Charging Station 640,000 90,570 549,430 650,000 - 650,000 1,199,430 591,633 607,797 *6253 COVID-19 Response 275,000 196,723 76,277 - (54,909) (54,909) 21,36G 21,369 - 5516 District Equipment Acquisition 1,726,000 1,672,577 53,423 250,000 100,000 350,000 403,423 297,075 106,34G 9517 Vehicle Replacement Program 6,016,000 4,546,74G 1,471,252 1,000,000 - 1,000,000 2,471,252 709,G04 1,761,449 100003 Property Repairs&improvements 1,150,000 529,356 620,644 150,000 - 150,000 770,644 G96,210 (125,566) 100004 HOE ExteriorRepairs 400,000 291,102 l0G,G9G - - - 10G,G9G - l0G,G9G 100027 Furnishings Replacement 100,000 19,271 90,729 - - - 90,729 64,411 (3,692) 100029 Solar ProjectonLagiss 600,000 517,740 92,260 - - - 92,260 6,762 75,499 100031 CommunityDev.System Replacement 600,000 28G,GG8 311,1L2 200,000 - 200,000 511,112 401,271 109,841 100033 Security Improvements FY 2021-25 300,000 155,716 144,282 100,000 - 100,000 24-4,262 65,267 176,015 100035 Technology Strategic Plan 600,000 336,701 463,299 - - - 463,299 129,536 333,763 100043 Easement Acquisition FY 2022-31 75,000 614G6 66,514 75,000 C136,954) C63,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 10006-4 Capital Legal Son -ice 2 0 2 3 + - - - 25,000 - 25,000 25,000 42,431 (17,431) -100071 Long Term Wet Weather Resiliency - - - - 200,000 200,000 200,000 16,199 1G3,G01 -9999 Capital Project Clearing (Accounting Use Only) - 11,101 (11,101) - 11,101 11,101 - - - Rounding - - - - - - - - - Tow GI Program $ 18.854.000 $ 14,607,319 S 4,246,181 S 31350,000 $ 97,854 S 3,447,854 $ 7,694,035 5 4,135,938 $ 3155_13"7 * 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 S� rRtx-g1E7, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 58 of 139 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-H Cumulative Cumulative Total Project FY Z023-2024 FY 2023-Z024 FY 2023-20Z4 FY 2023-2024 FY ZOZ3-2024 FY 2023-ZOZ4 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023-34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE RW Recycled Water 7361 Filter Plant & Clearwell Improvements Ph- 1A S 40,399,000 $ 36,677,028 S 3,711,972 $ - S - S - $ 3,711,972 $ 3,669,152 $ 42,820 7366 ReW Distribution System Renov. Program 530,000 221,750 30G,250 215,000 - 215,000 523,250 64,159 459,091 736E Water Exchange Project 400,000 142,137 257,963 - - - 257,G63 - 257,G63 100002 Filter Plant & Clearwell Improvements Ph.1U 1,450,000 41,853 1,409,147 500,000 - 500,000 1,909,147 142,657 1,765,490 100036 Zone 1 Recycled Water 2021 LOO,000 45,574 54,426 L03,000 - L03,000 157,426 91,513 65,9 L3 Rounding - - - - - - - - Total RW Pragr•ana $ 42.869.000 $ 37.128.342 $ 5.740.658 $ 918,000 $ - $ 818.000 $ 6.558.658 $ 3.967,481 $ 2.591.177 9990 CONTINGENCY - ALL PROGRAMS $ - $ - $ - $ - $ 6.900.000 $ 6.900.000 $ 6.900.000 $ - $ 6.900.000 9990 CONTINGENCY UAL TRANS - CLOSE OUTS $ - $ - $ - $ - $ 370.990 $ 370.990 $ 370,990 $ - $ 370,990 GRAND 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 SM4rRtX-g1e7, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 59 of 139 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Project No. Project Description Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 4 - Sewer Construction Fund Capital Budget Transfers (by Project) FY 2023-24 Adapted Ru dget Balance FY 2023-24 Q1 Q2 Q3 Q4 TotalFY2023- Contingency 24Activity balance $ 5,000,000 100012 Ui Disinfection Replacement $ 480,000 $ - $ (2,490,000) $ - $ (2,000,0001 - 100013 UV Hydraulic Improvements (480,000) - - - (490,000] - -100055 Tappan Terrace Sewer Renovation 650,000 - - - 650,000 - *100056 Martinez Urgent Force Main Replacement 200,000 3,762,000 - - 3,962,000 - •100050 CCTA A -Line Relocation 900,000 - - - 900,000 - 100034 TP Safety Enhancement Program (200,000) - - - (200,000) - 100067 PC Parking Lot Improvements 200000 - - - 200,000 - 100039 Collection System Sewer Renovation Ph2 (5,835,000) (4,262,000] (1,200,000) (S00,000] (12,097,0001 - 100049 ❑owntown Walnut Creek Sewer Renovations, Ph1 5,835,000 - - - 5,935,000 - 100068 Pleasant Hill Sewer Renovation Ph. 3 - 500,CCC - 150,000 650,000 - -100005 Laboratory Roof& Seismic Upgrades - 235,000 - - 295,000 - -100059 ❑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 - - (200A00) - (200,000) - 100072 Lake Cascade Sewer Renovation - - 600,000 - 600,000 - 100030 Solids Handling Facility Improvements Ph. 2 - - (400,000) - (400,0001 - 100032 Steam Renovations, Ph. 1 - - (1,500,000) - (1,500,000) - 100037 Drinda M oragn PS Architechtural Improvements - - (1,000,000) - (1,000,000] - 100062 Pumping Station SCADA & PLC Upgrades - - (350,000) - (350,000] - 9516 ❑ istrict Equipment Ecquisitim - - 100,000 - 100,000 - 100073 Piping Renovations, Ph. 11 - - - 200,000 200,000 - 100074 Central Chilled Water Plant - - - 200,000 200,000 - 100015 Electric Slower lmprovments - - - 700,000 700,000 - 7369 TP Piping Renovations, Ph. 10 - - - 195,000 195,000 - 100024 South Drinda Sewer Renov. Ph. 9 - - - 250,000 250,000 - 100025 Lafayette Sewer Renov. Ph. 15 - - - 250,000 250,000 - 100052 North Orinda Sewer Renov. Ph. 9 150,000 150,000 9990 Current ye,ar Contingency 1,750,000 605,000 5,630,OOH 1,295,000 1,900,000 6, 900,000 + 9990 Conti en tran�'ers to from due to closeouts 455,768 84,77 370,990 370,990 GRAND TOTAL $ - $ - $ 455,765 $ (94,7771 $ 370,990 $ 7,270,990 ' Contingency Projects FY2324 cJoseouU trensferrrd to contingency '6449 Collection System Modeling Support $ (225,559) 100053 Houston Ct. Area CAD (36,246) 'S253 COVID-19 Response [54,909) In M3-24, thefollowing projects'hudgetswere reduced to fund contingency. 100043 Easement Acquisition FY 2022-31 (138, 954) 7349 Aeration & Energy Upgrade $ (1,000,000) 7329 Influent Pump Electrical Improvements 299,829 100001 UPCAA Urgent Proj ects FY 2020-25 (500,000) 8250 384) (47,571) 100030 Solids Handling Facility Improvements Ph. 2 (2,500,000) 8436 9465 Pump Station Pump Staton Upgrades, Ph.l Martinez Sewer Renovations, Ph.7 [47,571] (12,946) 100047 Secondary CLarifier Improvments - Phase 1 (1,000,000) S466 Danville Sewer Renovations, Ph 4 (50,515) TOTAL $ (5,DDD,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) S4ft4rRtx-g'IE7, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 60 of 139 V-41-1-IC-S 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 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,O17,0S2 $ 2,086,484 $ 69,432 3.4% $ 2,017,052 103.4% Year -to -Date Revenues by Source $2,000,000 $1,500,000 $1,000,000 $500,000 Sewer Service Charge Insurance Recoveries (HHW) Subrogation Recoveries Revenue Source Category ■ YTD ■ YTD Budget Actual 201Page r Investment Income September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 61 of 139 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 Annual QTD YTD Budget 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% SS,000 9,994 45,006 81.8% SS,000 18.2% Insurance & Risk Management 432,500 S,03S 427,465 98.8% 1,730,000 1,670,484 S9,S16 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% $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 / $800,000 $600,000 $400,000 1 • $200,000 / 211Page Year -to -Date Expenses by Type Professional Services Technical Services Insurance & Risk Management Expense Category ■YTD ■ YTD Budget Actual September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 62 of 139 =CD 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 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 "jo $6,000,000 $4,000,000 $2,000,000 Tax Revenue YTD YTD Budget Actual 221Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 63 of 139 V-41-1-IC-S 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 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 Professional Services Principal Payment Expense Interest Expense ■ YTD ■ YTD Budget Actual 231Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 64 of 139 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 QTD YTD Purchase Maturity Days to Annual Cash DGQ Purchase EDQ EDQ % of Investment Investment No Issuer Type Date Date Maturity Yield outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State Df. Calif. LAIN ¢/a n/a n/a (1] S 26,000,OD0 S 19,500,000 $ 6,500,000 $ 26,000,OOC S 25,904,217 86.67% S 283,542 S 755,443 RE22 UST Notes Us Treasury 5/19/2022 4/30/24 0 2.661% 1A95A30 11500,000 (1,500,000) - - 0.00% 107 1,125 RE27 UST Notes Us Treasury 4/30/24 7/30/2D24 30 5.344% 4,936,567 4,000,000 4,000,OOC 3,983,060 13.33% 36,029 99,462 C3] $ 32,431.996 $ 21,000.000 $ 9.D00.000 $ 30.000,000 $ 29.887,297 100.D0% 319,678 856,030 {2) {4) (3] 10,698 51,937 $ 310.376 $ 907.967 Legend EOQ=E¢dofquarter BDQ - Beginning of quarter YTD = Year to Date Reference Cl) Annual yield of LocalAgency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of June 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 of the total Running Expense portfolio is 4,60%. As the Distract is a voluntary partScapant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day ofthe month. which is the cut-off for month -end reporting by Contra Costa County. [4] The market value of the portfoho on Jun: 30, 2024 was $29,857,297. GA53 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 complyw th Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)[2]]. [8] Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures fthe Running Expense food for the next six (6) montbs [California Government Code §53646(b)(3]] [C] Df the total investments held to the Running Expense Fund, $9,660,D00 is resdicted for the Rate Stabilization Fund Account 241Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 65 of 139 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 Purel— Matinity Days 1. Annual Cast No ]suer Type Date Date Maturity Yield 6o1ay 519 Stain of Calif. LAIF n/a n/a W. (1) $ 1715001000 961 us T BUI re US Tasury 1/2112022 1/15/2025 199 1.26% 2,490A39 964 UST Notes US Treasury 5/19120aa 4f30/2024 0 2XIG% 2492,383 984 US Treasury US Treasury 1/26120a4 4/25/202A 0 5.36% a4,6751000 985 US Treasury US Treasury 3f1j20m 5f313/24a4 0 5.37% 5,921,775 986 US Treasury US Treasury 3/15120a4 6%13/2024 0 5.39% 49,346,250 987 US Treasury US Treasury 3/20120a4 6%18/2024 0 5.36% 35,531550 988 us Treasury US Treasury 4/25120a4 7f25/aO24 25 5.40% 1917381000 989 US Treasury US Treasury 4/30120a4 7f30/a0a4 30 5.37% 14,B011696 990 US Treasury US Treasury 6/17120a4 9%12/70a4 74 5.38% 49,367,075 99L US Treasury US Treasury 6/25120a4 9%19/2Oa4 B1 5.35% 31,601,877 qTD YTD BDQ Purchase E0Q EOQ %.f 1—st ent Investment Face Value (Marirrity) Fain Value M-k t Value Paotfolia 1 come Inrnn,a $ 7,500,000 = 10,000,000 $ 17,500,000 $ 17,435,531 12.77% 149.090 $ 614,239 2,500,000 - 2,500,000 $ 2,444,950 1.82% 793 3,188 2500,00D (2,500,000) - $ - 0.00% 179 1,874 25,000,00D (25.000.000) - $ - 0.00% 86,667 325,000 6,000,000 (6,000.000) - S - 0.00% 51,291 78,225 50,000,00D (50,000.000) - $ - D.U0% 530,264 653,750 36,000,000 (36,000.000) - $ - D.U0% 4U5,990 468y450 - 20,000.000 20,000,000 $ 19,930,400 1416096 19ZI33 192.133 - 15,000.000 15,000,000 S 11,936,550 10.9slh 135,103 135.108 - 50.000.000 50,0001000 $ 49,470,000 36.50% 101,850 101,B50 32.000.000 32,000,000 $ 91.629.440 23.36% 27,776 27,776 (3) $253.465.645 1129,500,000 $ 7.500,000 5137,006,000 S 135.346.871 100.00% 116811130 Z60LE95 () (4) (5) 5.243 3,619,606 118r411.344.00 $ L.686.376 S 6,221.241 Legend.- EOQ=Endofquarter 130Q = Beonningofgvarter YTD = Year to Date Ikeferenre: (1) Annual Yield of Local Agency Investment Fund [LAiF) varies with the composition of the Fund. The estimated yield as of]une 2024 was 4AG% (2) The face value indicates the value of the i mrent if held until maturity, which is the usual District practice, (3) The —ghted average yield ofthe total Sev ar Construrtion portfolio is 5.20%. As the District is a voluntary participant in the Carumy Treasury Pod, this calndation excludes invesmients pn,. based after the 15th day of the month. which m the cut- off for month -and reporting by Contra Costa County. (4) The marketvalue ofthe portfolio omjune 30. 2024was SL35,B4fi,B71. GASB 31 rem,;,ns adjustbrg investme�mmarket value. The bistric[wiR adjust annually, but report market values monthly. (5) Amount represents invert income Gam prior period investments Notes: (A) All investments held by the Seer Construction Fund comply with Central San'sin—t¢unt policy approved bythe Boni of Di We [Ca4fo¢nm Government Code§53646Cb)(2]]. (E) Sufficient liquidity and anticipated revenues are available For Central Santa meet budgeted expenditures ofthe Saucer Constmcd m fund for the n tx[ (6) months [California Government Code §53646(b)(3)]. (C) 0fthe tmA inwstmentsheld mthe Sewer Construction Fund. 51.000.000 is restricted for the Rate 5tabil=tiom Reserve Account. 251Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 66 of 139 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 QTD STD Purchase Maturity Daysto Annual Cash EOQ Purchase EOQ EDQ %of Investment Investment No ]suer Type Date Date Maturity Yield Outlay Face Value (Piaturih-) Fa ce Value Market Value Portfolio [.come [.come 519 State of Calif. LAIF n/a n/a n/a Cl) $ 10,100,000 $ 10,10D,VDD S - S 10,100,000 $ 10,062,792 100.00% $ 109,772 $ 375,345 C3) $ 10.100.DD0 S 10,100,000 S - $ 10.100,000 $ 10.062,7912 100.00% 109,772 375,645 (2) (4) (5) 4,450 15,393 $ 114.221 $ 391.238 Legend: EOQ=End ofquarter BDQ = Beginning of quarter YTD = Year to Date Reference (1] Annual yield of LocalAgency Im stment Fund (LAIF) varies xith the composition of the Fund. The estimated yield as of fuse 2024 was 4d-B%. (21 The face value indicates the value of the investment ifheld until maturity, which is the usual District Practice. (3] The weighted average yield ofthe total Self-insurance portfolio is 4,48%. (4] The market value of the portfolio on Tune 30, 2024 was $10,062,792. (5] Amount represents interest income from prior period investments. Notes: (A) All investments held by the Self Insurance Fund romplywith Central San's investment policy approved by the Board of Direct.. [California Government Code §536")(21]. (13) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures ofthe Self Insurance fund for the next six (6) months [California Government Code §536")(3]] 261Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 67 of 139 ,AMI'CENTRAL 5AN 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 f $40.1 June '23 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) $46.6 $43.S July August September October November December January February March April May June =Projected Balance* =Actual Balance Reserve Target at Year End** *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. 271Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 68 of 139 iCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 $160.0 $140.0 $120.0 $100.0 $80.0 $�s. $60.0 $40.0 $20.0 $0.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) $145 14.5 42.9 $135.6 ^^ $139.9 Z5.0 $115. I� $100.0 $995 June'23 July August September October November December January February March April May June M Projected Balance* MActual Balance Reserve Target at Year End** $47.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. 281Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 69 of 139 .AMCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-439Z Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Staffing Trends 300 6.5% 295 6.4% 290 6.0% 1 285 16 F 5 w y 280 _ 5.5% c aU 5.4% ro 275 w E 270 5.2% 5.0% F= 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 64 Filled Positions (FTEs) Vacancies (FTEs) tVacancy Rate 291Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 70 of 139 'JOCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-439Z 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 3 0 1 P a g e Historical Quarterly 0&M Cost per Million Gallons Treated $4,204 $4,517 $3,677 $3,188 6/30/21 6/30/22 6/30/23 6/30/24 Quarter Ended September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 71 of 139 =CD - , CENTRAL CONTRA COSTA SANITARY DISTRICT 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) SL;3 SL43 SL=3 SL=3 SLLO SL33 S90 $8❑ $70 _ $50 ---' . $40 .... $3❑ $20 $10 $- July August September actooe- November December January February f Budget Target {90% of Budget) Actual 311Page r' r $136.8 !' y $42.4 p March April May June September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 72 of 139 =CD - , CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending June 30, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Collection System Program Budget to Actual Spending Trend Collection System Program (in millions` $67.96 $70 $65 $50 $55 $61.16 $50 $45 $40 $34.89 $35 $30 $25 $20 $15 ------ $10 $5 5- July August September October November December January February March April May June Budget Target (90%of BuJget] Actual ex 321Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 73 of 139 =CD 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 Budget to Actual Spending Trend Treatment Program (in millions) $70 $65 $62.69 $60 $55 $56.42 $50 $45 •'$49.32 $40 $35 $30 -s- - $25 - $20 $10 $5 S- July August September October November December January February March April May June --0— Budget Target (90% of Budget) Actu al 331Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 74 of 139 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 a; b 0 1.5 c� 0.9 o. 1.0 � 0.6 0.6 0.5 0.5 0.0 a I30Iti3 1tiI31Iti� � I31Iti°` 6Ig0Iti� Quarter Ending ■ Actual Construction ■ Target ("S-Curve" of 6 mi. FY 23-24 Budget Projection) 341Page September 17, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 75 of 139