The URL can be used to link to this page

Home My WebLink About03.c Receive Quarterly Financial Review for Quarter Ending March 31. 2024Page 1 of 40 Item 3.c. F__1_448�411C_S0 May 21, 2024 TO: FINANCE COMMITTEE FROM: CHRISTOPHER THOMAS, ACCOUNTING SUPERVISOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIPLEIBER, DEPUTYGM -ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE QUARTERLY FINANCIAL REVIEW FOR QUARTER ENDING MARCH 31, 2024 Attached is the Quarterly Financial Review for the third quarter of Fiscal Year (FY) 2023-24 ending March 31, 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 March 31, 2024 May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 91 of 190 Quarterly Financial Review CENTRAL SAN _ n ArJ - _ i zi I er Ended March 31, 2024 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending March 31, 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 CapitalBudget Transfers (by Project by Month).....................................................................................................................................................................21 Section 5 - Self Insurance Fund Revenuesby Source.............................................................................................................................................................................................................................22 May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 93 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Table of Contents Expensesby Type.................................................................................................................................................................................................................................23 Section 6 - Debt Service Fund Revenuesby Source.............................................................................................................................................................................................................................24 Expensesby Type.................................................................................................................................................................................................................................25 Section 7 - Investment Portfolio Reports Operations& Maintenance Fund....................................................................................................................................................................................................26 SewerConstruction Fund..................................................................................................................................................................................................................27 Self -Insurance Fund.............................................................................................................................................................................................................................28 Section 8 -Financial Performance Metrics 0&M Fund Cashflow Forecast.........................................................................................................................................................................................................29 Sewer Construction Fund Cashflow Forecast...........................................................................................................................................................................30 StaffingTrends....................................................................................................................................................................................................................................... 31 Cost per Million Gallons of Wastewater Treated.....................................................................................................................................................................32 CapitalSpending Trends....................................................................................................................................................................................................................33 Milesof Pipeline Constructed/Renovated..................................................................................................................................................................................36 May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 94 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending March 31, 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 third quarter of FY 2023-24 ended March 31, 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 for the third quarter show total expenditures of $63.5 million, which is approximately $5.0 million (7.3%) under the FY 2023-24 budget. This favorable expense variance is largely attributable to lower than projected year-to-date spending in the other purchased services, salaries & wages, and supplies & materials expenditure line categories. The largest year-to-date favorable budgetary variance is with other purchased services at $1.8 million (33.5%) attributable to lower than projected spending in the Administrative, Engineering, and Operations departments for various professional and technical services through the third quarter of the year. The second largest year-to-date favorable budgetary variance was salaries & wages at approximately $1.8 million (5.1%) mainly due a higher than budgeted vacancy rate (6.4% as of March 31, 2024) and incurring less overtime and temporary staffing support costs than projected through the third quarter. In the aggregate, the 0&M Fund is reporting a minor unfavorable revenue variance of $0.5 million, which is approximately 1.3% below total estimated year-to-date revenues. The primary driver for this overall revenue variance is sewer service charges, which is projected to catch up later in the fiscal year. Sewer Construction Fund Sewer Construction Fund results for the third quarter show total capital project expenditures of $53.3 million, or 74.9% of the total adopted budget of $71.2 million. While the Sewer Construction Fund's FY 2023-24 adopted budget was $71.2 million, when including carryforward capital project appropriations from the prior year of $78.8 million the total adjusted budget for FY 2023-24 is $150.0 million. The significant budgetary carryforward was, at least initially, primarily caused by two factors: 11Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 95 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 1 -Executive Summary (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 35.5% of the amended capital budget for FY 2023-24. The bulk of the FY 2023-24 capital spending budget variance by spend amount is in the Collection System program, followed by the Treatment Plant program, attributable to various projects as shown in pages 15 through 20 of this report. Regarding revenue performance, the Sewer Construction Fund is currently reporting revenues of $39.8 million, falling short of the year-to-date budget amount of $41.6 million by $1.7 million (4.1%). The variance is mostly driven by secured property tax revenue coming in under budget, which is simply a timing issue due to the county tax allocation schedule. This is considered a temporary negative variance and is expected to be minimized later in the fiscal year after the April and June allocations are received. 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 March 31, 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. Through the third quarter of FY 2023-24, the 0&M Fund investment portfolio has generated just under $0.6 million in investment income, which is 6.1% above interim budgetary estimates. The Sewer Construction Fund portfolio is reporting investment income of $4.5 million, which is well over the year-to-date revenue estimate of approximately $1.6 million by 177.3%. After Central San's FY 2023-24 budget was finalized, the Fed 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 through the third quarter. 2 1 P a g e May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 96 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 1 -Executive Summary 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.22% in the third 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 turn, has helped drastically increase 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 March 31, 2024, Central San was holding about 23.1% of its investment portfolio, or $37.1 million, in LAIF state investment pool, under the maximum amount permitted to be held in the pool ($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 budgeted 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 March 31, 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 May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 97 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 2 -Financial Results Summary by Fund YTD Category Budget Fund Revenues 0&M Sewer Construction Self Insurance Debt Service Total Fund Expenses 0&M Sewer Construction Self Insurance Debt Service Total YTD Actual Annual YTD Budget YTD Variance Annual Realized Variance ($) (%) Budget (%) $ 40,111,931 $ 39,606,844 $ (505,088) -1.3% $ 89,722,943 44.1% 41,554,953 39,848,871 (1,706,082) -4.1% 93,126,163 42.8% 1,913,977 1,958,069 44,092 2.3% 2,017,052 97.1% 9,160,142 9,152,600 (7,542) -0.1% 9,160,142 99.9% $ 92,741,003 $ 90,566,384 $ (2,174,619) $ 194,026,300 $ 68,539,296 $ 63,529,670 $ 5,009,627 7.3% $ 90,946,671 69.9% 91,155,914 53,331,091 37,824,823 41.5% 150,021,461 35.5% 2,120,000 2,421,469 (301,469) -14.2% 2,660,000 91.0% 9,160,142 8,414,597 745,545 8.1% 9,160,142 91.9% $ 170,975,353 $ 127,696,827 $ 43,278,525 $ 252,788,274 YTD Budget -to -Actual Revenues by Fund $50,000,000 $45,000,000 $40,000,000 $35,000,000 ' $30,000,000 $25,000,000 $20,000,000 $15,000,000 8,000,000 $5 85,000,000 0&M SewerSelflnsura Debt Service Fund •YTD •YTD Badges A-1 4 1 P a g e YTD Budget -to -Actual Expenses by Fund $)0,000000 +' $60,000o00 $5o.mlo00 $40,000o00 $30,000000 r $20,000o00 $10,000,000 ,r o&M s—conttruai- Selflnsu'a Debt Service Fund •YTD •YTD Budg. Actual May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 98 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 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 $ 41,989 $ (339,662) $ (381,651) -908.9% $ 36,869,782 $ 36,111,217 $ (758,566) -2.1% $ 66,051,443 54.7% Sewage Treatment Cost Sharing - - - (54,241) (54,241) 17,900,000 -0.3% Miscellaneous Service Charge 259,008 194,218 (64,790) -25.0% 672,024 685,155 13,131 2.0% 2,200,000 31.1% Non -Operating Revenues: Permit and Inspection Fees 456,875 443,700 (13,175) -2.9% 1,370,625 1,450,158 79,533 5.8% 1,827,500 79.4% Other Non Operating Income 221,000 340,878 119,878 54.2% 655,500 837,435 181,935 27.8% 884,000 94.7% Investment Income 221,000 293,150 72,150 32.6% 544,000 577,120 33,120 6.1% 860,000 67.1% Total Revenue $ 1,199,872 $ 932,284 $ (267,588) -22.3% $ 40,111,931 $ 39,606,844 $ (505,088) -1.3% $ 89,722,943 44.1% 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 Investment Income ■ YTD ■ YTD Budget Actual 5 1 P a g e May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 99 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Revenues by Source - Detail Level Category QTD Budget Sewer Service Charge Revenue Sewer Service Charge Counter $ 48,987 $ Sewer Service Charge County - Sewer Service Charge Direct Sewer Service Charge Prior (6,998) Sewage Treatment Cost Sharing - Miscellaneous Service Charges Septic Tank Dumping 11,250 Sales 250 Other Service Charges - Recycled Water 128,750 Satellite Water Recycling - Stormwater Program 105,000 Household Hazardous Waste 13,758 Permit & Inspection Fees Permit/Application Fees 125,000 Overtime Inspection 2,375 Side Sewer Inspection 290,000 Industrial Permit Fees 28,750 New Industry Permit Fees 4,500 Annexation Charges 6,250 Other Non -Operating Income Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 3 - Operations & Maintenance Fund Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Variance Annual Realized Actual Variance ($) % Budget Actual Variance ($) (%) Budget 26,783 $ (22,204) -45.3% $ 146,961 $ 213,241 $ 66,280 45.1% $ 195,949 108.8% - 35,615,153 34,699,884 (915,269) -2.6% 64,754,824 53.6% (361,549) (361,549) 1,128,663 1,212,483 83,820 7.4% 1,128,663 107.4% (4,895) 2,103 -30.0% (20,995) (14,391) 6,603 -31.5% (27,993) 51.4% - - - (54,241) (54,241) 17,900,000 -0.3% 15,502 4,252 37.8% 33,750 32,406 (1,344) -4.0% 45,000 72.0% - (250) -100.0% 750 20 (730) -97.3% 1,000 2.0% 7,861 7,861 - 9,096 9,096 210,000 4.3% 37,391 (91,359) -71.0% 386,250 341,839 (44,411) -11.5% 515,000 66.4% 115,928 10,928 10.4% 210,000 243,845 33,845 16.1% 420,000 58.1% 17,536 3,778 27.5% 41,274 57,949 16,675 40.4% 1,009,000 5.7% 41,889 (83,111) -66.5% 375,000 480,313 105,313 28.1% 500,000 96.1% 1,446 (929) -39.1% 7,125 5,338 (1,787) -25.1% 9,500 56.2% 322,825 32,825 11.3% 870,000 836,099 (33,901) -3.9% 1,160,000 72.1% 71,857 43,107 149.9% 86,250 109,766 23,516 27.3% 115,000 95.4% 952 (3,548) -78.8% 13,500 6,486 (7,014) -52.0% 18,000 36.0% 4,731 (1,519) -24.3% 18,750 12,156 (6,594) -35.2% 25,000 48.6% MVSD P2 Program 7,500 8,183 683 9.1% 15,000 23,660 8,660 57.7% 30,000 78.9% Pretreatment Program Fine 500 - (500) -100.0% 1,500 - (1,500) -100.0% 2,000 0.0% Lease Rental Income 205,500 313,387 107,887 52.5% 616,500 687,896 71,396 11.6% 822,000 83.7% Miscellaneous Income 7,500 1,495 (6,005) -80.1% 22,500 94,111 71,611 318.3% 30,000 313.7% Right of Way Fees - 5,610 5,610 - 11,865 11,865 - Reimbursements - 12,203 12,203 - 19,903 19,903 - Investment Income 221,000 293,150 72,150 32.6% 544,000 577,120 33,120 6.1% 860,000 67.1% Total Revenues $ 1,199,872 $ 932,284 $ (267,588) -22.3% $ 40,111,931 $ 39,606,844 $ (505,088) -1.3% $ 89,722,943 44.1% 6 1 P a g e May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 100 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 3 - Operations & Maintenance Fund Expenses by Type - Summary Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance [$) % Budget (%) Salaries & Wages $ 11,869,218 $ 11,363,168 $ 506,050 4.3% $ 34,392,312 $ 32,636,529 $ 1,755,783 5.1% $ 45,144,569 72.3% Employee Benefits 3,610,345 3,630,396 (20,050) -0.6% 10,168,339 10,324,309 (155,970) -1.5% 13,654,823 75.6% Unfunded Liability Costs 426,373 425,521 852 0.2% 775,931 774,289 1,642 0.2% 1,200,503 64.5% Purchased Property Services 1,655,752 1,649,311 6,441 0.4% 5,752,721 5,685,455 67,267 1.2% 7,697,774 73.9% Other Purchased Services 1,852,441 792,414 1,060,027 57.2% 5,428,953 3,612,412 1,816,541 33.5% 7,246,295 49.9% Supplies & Materials 3,543,198 3,127,385 415,813 11.7% 10,735,794 9,469,615 1,266,179 11.8% 14,298,822 66.2% Other Expenses 425,750 219,267 206,483 48.5% 1,285,245 1,027,060 258,185 20.1% 1,703,885 60.3% Total Expenses $ 23,383,079 $ 21,207,462 $ 2,175,617 9.3% $ 68,539,296 $ 63,529,670 $ 5,009,627 7.3% $ 90,946,671 69.9% $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 7 1 P a g e Salaries & Wages Employee Benefits Year -to -Date Expenses by Type Unfunded Liability Purchased Property Other Purchased Supplies & Materials Other Expenses Costs Services Services ■ YTD ■ YTD Budget Actual May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 101 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 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 ($) (%) Budget Actual Variance ($) (%) Budget (%] Salaries & Wages FTE Regular Pay $ 11,023,284 $ 10,313,880 $ 709,405 6.4% $ 31,364,713 $ 29,490,570 $ 1,874,143 6.0% $ 41,187,208 71.6% Temporary Pay 324,180 411,681 (87,502) -27.0% 1,481,602 1,178,998 302,603 20.4% 1,913,093 61.6% Premium Pay 853,854 615,232 238,622 27.9% 2,542,297 1,905,733 636,564 25.0% 3,372,669 56.5% Board Fees 16,650 11,400 5,250 31.5% 49,950 37,000 12,950 25.9% 66,600 55.6% Other (348,750) 10,975 (359,725) 103.1% (1,046,250) 24,227 (1,070,477) 102.3% (1,395,000) -1.7% Total Salaries & Wages 11,869,218 11,363,168 506,050 4.3% 34,392,312 32,636,529 1,755,783 5.1% 45,144,569 72.3% Employee Benefits Insurance Premiums 2,293,015 2,171,314 121,702 5.3% 6,621,359 6,107,826 513,533 7.8% 8,885,919 68.7% Employer Taxes 173,317 184,066 (10,749) -6.2% 502,583 542,960 (40,377) -8.0% 660,013 82.3% Employer Retirement Contributions 2,330,168 2,277,486 52,682 2.3% 6,424,028 6,302,100 121,927 1.9% 8,490,640 74.2% OPEB Contributions 470,000 470,000 0.0% 1,410,000 1,410,000 0.0% 1,880,000 75.0% Benefit Adjustments (1,656,156) (1,472,471) (183,685) 11.1% (4,789,631) (4,038,577) (751,054) 15.7% (6,261,749) 64.5% Total Employee Benefits 3,610,345 3,630,396 (20,050) -0.6% 10,168,339 10,324,309 (155,970) -1.5% 13,654,823 75.6% Unfunded Liability Costs Pension 16,123 390,271 (374,148) -2320.6% 45,181 668,539 (623,358) -1379.7% 59,503 1123.5% OPEB 410,250 35,250 375,000 91.4% 730,750 105,750 625,000 85.5% 1,141,000 9.3% Total Unfunded Liability Costs 426,373 425,521 852 0.2% 775,931 774,289 1,642 0.2% 1,200,503 64.5% Purchased Property Services Repairs & Maintenance 998,215 1,108,345 (110,130) -11.0% 3,782,309 3,859,118 (76,809) -2.0% 5,070,924 76.1% Hauling & Disposal 304,575 187,359 117,216 38.5% 913,725 673,355 240,370 26.3% 1,218,300 55.3% Security 183,650 177,387 6,263 3.4% 550,950 507,242 43,708 7.9% 734,600 69.1% Rentals 38,175 72,500 (34,325) -89.9% 112,325 265,093 (152,768) -136.0% 149,400 177.4% Cleaning 130,763 103,719 27,043 20.7% 392,288 378,937 13,351 3.4% 523,050 72.4% Construction 375 375 100.0% 1,125 1,710 (585) -52.0% 1,500 114.0% Total Purchased Property Services 1,655,752 1,649,311 6,441 0.4% 5,752,721 5,685,455 67,267 1.2% 7,697,774 73.9% (Continued on page 9) 8 1 P a g e May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 102 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued) QTD QTD Category Budget Actual 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 Annual QTD YTD Budget QTD Variance YTD YTD YTD Variance Annual Realized Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) 391,398 180,910 210,487 53.8% 1,167,137 545,228 621,909 53.3% 1,557,534 35.0% 767,719 373,428 394,291 51.4% 2,362,757 1,293,359 1,069,398 45.3% 3,160,776 40.9% 693,325 238,076 455,249 65.7% 1,899,060 1,773,826 125,234 6.6% 2,527,985 70.2% 1,852,441 792,414 1,060,027 57.2% 5,428,953 3,612,412 1,816,541 33.5% 7,246,295 49.9% 2,074,966 2,166,115 (91,150) -4.4% 6,224,897 5,942,902 281,995 4.5% 8,299,862 71.6% 740,000 475,014 264,986 35.8% 2,220,000 1,986,321 233,679 10.5% 2,960,000 67.1% 728,233 486,256 241,977 33.2% 2,290,898 1,540,392 750,505 32.8% 3,038,960 50.7% 3,543,198 3,127,385 415,813 11.7% 10,735,794 9,469,615 1,266,179 11.8% 14,298,822 66.2% 188,134 39,706 148,428 78.9% 577,806 537,651 40,155 6.9% 761,830 70.6% 189,806 129,730 60,077 31.7% 558,008 321,169 236,839 42.4% 744,313 43.1% 47,811 49,832 (2,021) -4.2% 149,432 168,240 (18,809) -12.6% 197,742 85.1% 425,750 219,267 206,483 48.5% 1,285,245 1,027,060 258,185 20.1% 1,703,885 60.3% $ 23,383,079 $ 21,207,462 $ 2,175,617 9.3% $ 68,539,296 $ 63,529,670 $ 5,009,627 7.3% $ 90,946,671 69.9% May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 103 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 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 (%) Department Executive Governance $ 824,336 $ 492,225 $ 332,111 40.3% $ 2,418,528 $ 1,432,438 $ 986,091 40.8% $ 3,169,121 45.2% Administration 5,697,573 4,822,885 874,688 15.4% 16,257,785 14,455,100 1,802,685 11.1% 21,906,201 66.0% Engineering and Technical Services 3,952,900 3,314,471 638,429 16.2% 11,494,662 10,170,226 1,324,437 11.5% 15,257,107 66.7% Operations 12,451,551 12,231,683 219,868 1.8% 36,938,797 36,283,806 654,991 1.8% 48,689,437 74.5% Recycled Water Program 456,718 346,197 110,520 24.2% 1,429,524 1,188,100 241,424 16.9% 1,924,804 61.7% Total Expenses $ 23,383,079 $ 21,207,462 $ 2,175,617 9.3% $ 68,539,296 $ 63,529,670 $ 5,009,627 7.3% $ 90,946,671 69.9% Year -to -Date Expenses by Department $40,000,000 $30,000,000 $20,000,000 $10,000,000 Executive Governance Administration Engineering and Technical Services ■ YTD ■ YTD Budget Actual 101Page Operations Recycled Water Program May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 104 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Detail (by Division) Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Organizational Unit Budget Actual Variance ($) (%) Budget Actual Variance [$) No) Budget [%) Executive Governance Office of the General Manager $ 501,275 $ 262,725 $ 238,549 47.6% $ 1,407,994 $ 756,639 $ 651,354 46.3% $ 1,852,510 40.8% Office of the Secretary of the District 227,976 180,850 47,126 20.7% 727,809 543,189 184,620 25.4% 938,800 57.9% Board of Directors 95,086 48,650 46,435 48.8% 282,725 132,609 150,116 53.1% 377,811 35.1% Administration Office of the Director of Finance and Administration 188,572 178,799 9,773 5.2% 518,511 488,783 29,728 5.7% 688,243 71.0% Finance Division 751,093 553,307 197,786 26.3% 1,876,046 1,508,269 367,778 19.6% 2,415,433 62.4% Human Resources Division 1,883,838 1,629,262 254,576 13.5% 5,090,430 4,358,569 731,862 14.4% 6,930,837 62.9% Purchasing Division 493,151 397,209 95,942 19.5% 1,435,239 1,275,610 159,629 11.1% 1,887,015 67.6% Risk Management Program 387,774 325,115 62,659 16.2% 1,141,583 1,026,744 114,840 10.1% 1,514,204 67.8% Public Info/Comm. Services & Intergov Relations Division 518,439 429,316 89,124 17.2% 1,582,464 1,393,705 188,759 11.9% 2,176,322 64.0% Information Technology Division 1,474,706 1,309,877 164,829 11.2% 4,613,510 4,403,420 210,090 4.6% 6,294,147 70.0% Engineering & Technical Services Office of the Director of Engineering & Technical Services 260,917 72,872 188,045 72.1% 728,594 201,353 527,240 72.4% 1,003,642 20.1% Planning & Developmental Services 1,376,994 1,197,552 179,442 13.0% 4,091,115 3,808,696 282,419 6.9% 5,385,263 70.7% Capital Projects Division (97,267) 72,351 (169,618) 174.4% (350,023) (14,023) (336,000) 96.0% (423,339) 3.3% Environmental & Regulatory Compliance 2,412,256 1,971,696 440,559 18.3% 7,024,977 6,174,199 850,777 12.1% 9,291,541 66.4% Operations Office of the Director of Operations 258,761 252,188 6,572 2.5% 747,116 623,753 123,363 16.5% 989,020 63.1% Collection System Operations Division 3,777,632 3,644,445 133,187 3.5% 10,886,991 10,863,695 23,297 0.2% 14,391,917 75.5% Treatment Plant Operations Division 4,276,474 4,141,832 134,642 3.1% 12,541,784 12,715,779 (173,995) -1.4% 16,610,137 76.6% Treatment Plant Maintenance Division 3,657,130 3,832,269 (175,139) -4.8% 11,423,923 11,098,669 325,254 2.8% 14,892,814 74.5% Operations Optimization Division 481,555 360,949 120,606 25.0% 1,338,982 981,911 357,071 26.7% 1,805,549 54.4% Recycled Water Recycled Water - General 47,175 20,425 26,750 56.7% 141,525 61,275 80,250 56.7% 188,700 32.5% Treatment Plant 247,650 195,200 52,450 21.2% 742,950 735,363 7,587 1.0% 1,012,200 72.6% Distribution System 98,118 78,222 19,895 20.3% 294,353 234,412 59,940 20.4% 392,470 59.7% Residential Fill Station 38,350 31,925 6,425 16.8% 174,421 95,775 78,646 45.1% 229,734 41.7% Satellite Water Facility 25,425 20,425 5,000 19.7% 76,275 61,275 15,000 19.7% 101,700 60.3% Total Expenses $ 23,383,079 $ 21,207,462 $ 2,175,617 9.3% $ 68,539,296 $ 63,529,670 $ 5,009,627 7.3% $ 90,946,671 69.9% 111Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 105 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 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 $ 33,011 $ (258,722) $ (291,733) -883.7% $ 28,064,203 $ 27,464,088 $ (600,115) -2.1% $ 50,251,805 54.7% Other Capital Revenues 2,277,250 1,677,408 (599,842) -26.3% 13,490,750 12,384,783 (1,105,967) -8.2% 42,874,358 28.9% Total Revenue $ 2,310,261 $ 1,418,686 $ (891,575) -38.6% $ 41,554,953 $ 39,848,871 $ (1,706,082) -4.1% $ 93,126,163 42.8% Year -to -Date Revenues by Source $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Sewer Service Other Capital Grant Revenue Capacity Fees Other State Revolving Tax Revenue Permit and Other Non Investment Charges Revenues Government Fund Loan Inspection Fees Operating Income Revenue Income Revenue Source Category ■ YTD ■ YTD Budget Actual 121Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 106 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 4 - Sewer Construction Fund Revenues by Source - Detail Annual QTD YTD Budget QTD QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($] (%] Budget Actual Variance ($] (%] Budget (%] Sewer Service Charges (SSC) Over -the -Counter $ 38,513 $ 19,982 $ (18,531) -48.1% $ 115,538 $ 161,820 $ 46,282 40.1% $ 154,051 105.0% County Allocated - - 27,077,833 26,391,461 (686,372) -2.5% 49,232,424 53.6% Direct Billed (274,981) (274,981) 887,337 921,753 34,416 3.9% 887,337 103.9% Prior Year Adjustment (5,502) (3,723) 1,778 -32.3% (16,505) (10,946) 5,560 -33.7% (22,007) 49.7% 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 1,017,500 794,355 (223,145) -21.9% 3,052,500 3,341,433 288,933 9.5% 4,070,000 82.1% 26,250 - (26,250) -100.0% 78,750 159,362 80,612 102.4% 105,000 151.8% 12,500 (12,500) -100.0% 37,500 47,044 9,544 25.5% 50,000 94.1% - (946,116) (946,116) 7,380,000 2,790,654 (4,589,346) -62.2% 13,933,358 20.0% - - - 500,000 718,849 218,849 43.8% 500,000 143.8% 622,000 1,705,636 1,083,636 174.2% 1,645,000 4,561,639 2,916,639 177.3% 2,250,000 202.7% - - - - - - 7,570,000 0.0% 500,000 - (500,000) -100.0% 500,000 580,591 80,591 16.1% 14,000,000 4.1% 1,500 3,156 1,656 110.4% 4,500 3,552 (949) -21.1% 6,000 59.2% 22,250 39,638 17,388 78.1% 66,750 77,742 10,992 16.5% 89,000 87.4% 75,000 17,768 (57,233) -76.3% 225,000 40,386 (184,614) -82.1% 300,000 13.5% - 69,507 69,507 - 69,507 69,507 - 250 - (250) -100.0% 750 9,174 8,424 1123.1% 1,000 917.4% (6,534) (6,534) (15,148) (15,148) $ 2,310,261 $ 1,418,686 $ (891,575) -38.6% $ 41,554,953 $ 39,848,871 $ (1,706,082) -4.1% $ 93,126,163 42.8% May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 107 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Summary (by Program) A B C (A-B) D E F (D+E) G (C+D+E) H 1 (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 Carryforwardto Adopted Budget Adjusted Approved Actual Remaining 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 $ 138,095 $ 35,872,095 $ 65,992,095 $ 24,679,410 $ 41,312,685 Treatment Plant (TP) 109,981,332 71,268,710 38,712,622 31,300,000 (8,895,000) 22,405,000 61,117,622 22,683,355 38,434,267 General Improvements (GI) 18,854,000 14,607,819 4,246,181 3,350,000 106,137 3,456,137 7,702,318 2,903,273 4,799,045 Recycled Water (RW) 42,869,000 37,128,342 5,740,658 818,000 - 818,000 6,558,658 3,065,053 3,493,605 CIB Contingency - - - - 8,195,000 8,195,000 8,195,000 - 8,195,000 Contingency Bal. Trans. - Close Outs 455,768 455,768 455,768 455,768 Total $ 268,099,482 $ 189,280,021 $ 78,819,461 $ 71,202,000 $ - $ 71,202,000 $ 150,021,461 $ 53,331,091 $ 96,690,370 $70,000,000 $60,000,000 $50,000,000 $40,000,000 " $30,000,000 $20,000,000 $10,000,000 141Page Capital Improvement Budget Quarterly Results by Program Collection System (CS) Treatment Plant (TP) General Improvements (GI) Recycled Water (RW) Program ■ Approved Expenditures ■ Actual Expenditures May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 108 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project) A B C A-B D E F +E G (C+D+El 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 Actual Remaining I Budgets Actuals FY 2023-34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 $ 8,252,000 $ 850,216 $ 7,401,784 $ $ $ $ 7,401,784 $ 5,170,896 $ 2,230,888 *8436 Moraga/ Crossroads PS Project 35,451,000 35,218,893 232,107 232,107 38,502 193,605 8443 LG Diameter Pipe line Inspection 795,000 519,075 275,925 500,000 500,000 775,925 176,603 599,322 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,698 1,170 519,528 *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 667,447 344,654 8457 Pump Station Upgrades - Ph. 2 14,650,000 7,967,271 6,682,729 10,000,000 10,000,000 16,682,729 8,850,624 7,832,105 8464 Martinez Sewer Renov. Ph. 7 4,581,000 3,130,124 1,450,876 - - 1,450,876 1,286,373 164,503 *8466 Danville Sewer Ren. Ph. 4 5,202,000 5,028,420 173,580 - - 173,580 112,965 60,615 100006 Contractual Assessment District Proj Financing 432,940 35,857 397,083 100,000 100,000 497,083 (35,857) 532,940 100007 Large Diameter Priping Renovation Program 500,000 37,572 462,428 500,000 500,000 962,428 116,888 845,540 100017 SR Pump Station Electrical Upgrades 1,913,000 648,542 1,264,458 1,264,458 1,041,813 222,645 100023 Walnut Creek Sewer Renovation Ph. 16 6,379,000 4,923,785 1,455,215 1,455,215 1,341,679 113,536 100024 South Orinda Sewer Renovation Ph. 9 500,000 736,330 (236,330) (236,330) 16,297 (252,627) 100025 Lafayette Sewer Renov. Ph. 15 500,000 547,451 (47,451) (47,451) 60,226 (107,677) 100028 Collection System Master Plan 2021 Update 1,600,000 296,128 1,303,872 1,303,872 166,900 1,136,972 100037 Orinda Moraga PS Architectual Improvements 1,450,000 41,952 1,408,048 (1,000,000) (1,000,000) 408,048 11,368 396,680 100038 San Pablo Watershed Improvements 200,000 43,502 156,498 - - 156,498 19,027 137,471 100039 Collection System Sewer Renovation Ph. 2 2,950,000 69,907 2,880,093 18,500,000 (11,297,000) 7,203,000 10,083,093 45,638 10,037,455 100041 Buchanan Lift Station Replacements & Improvements 200,000 133,151 66,849 850,000 850,000 916,849 240,794 676,055 100042 Pump Station Upgrades, Phase 2B 3,200,000 125,802 3,074,198 2,500,000 2,500,000 5,574,198 1,759,759 3,814,439 100044 Collection System Modeling Support FY 22+ 120,000 617 119,383 125,000 125,000 244,383 3,705 240,678 100049 Downtown Walnut Creek Sewer Renovations, Ph. 1 500,000 258,352 241,648 - 5,835,000 5,835,000 6,076,648 1,817,828 4,258,820 100050 CCTAA-Line Relocation 200,000 12,918 187,082 900,000 900,000 1,087,082 198,405 888,677 100052 No. Otinda Sewer Renovations, Ph. 9 500,000 225,068 274,932 - - 274,932 334,095 (59,163) 100053 Houston Ct Area CAD 252,894 216,648 36,246 (36,246) (36,246) - - 151Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 109 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C A-B D E F fD+El 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 I Budget I Adjusted 1 Approved Actual Remaining 1 Budgets Actuals FY2023.34 Budget Adjustments Budget Expenditures Expenditures Budget 100059 Collection System Planning 2023+ 200,000 200,000 200,000 88,179 111,821 100060 Pumping Station Equipment& Piping Replacement202' 200,000 200,000 200,000 740 199,260 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 6S0,000 650,000 229,662 420,338 **100066 Martinez Urgent Force Main Replacement 3,962,000 3,962,000 3,962,000 474,086 3,487,914 **100068 Pleasant Hill Sewer Renovation Ph.3 500,000 500,000 500,000 152,560 347,440 **100070 Cedar Lane Sewer Renovations 600,000 600,000 600,000 2,566 597,434 **100072 Lake Cascade Sewer Renovation 600,000 600,000 600,000 5,149 594,851 Rounding Total CS Program $ 96,39S,150 $ 66,275,150 $ 30,120,000 $ 35,734,000 $ 138,095 $ 35,872,095 $ 65,992,095 $ 24,679,410 $ 41,312,685 * Projects open but not in CIB for 23/24 ** New project Not in 23/24 Budget Funds transferred from other projects or Contingency 161Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 110 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 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-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 Carryforwardto I Adopted Budget I Adjusted Approved I Actual Remaining I Budgets Actuals FY 2023-34 Budget Adjustments Budge 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 $ 63,199 $ 501,693 7328 Influent Pump Electrical improvements 10,886,000 10,981,304 (95,304) - - - (95,304) 193,811 (289,115) 7341 WC/Grayson Creek Levee Rehab 2,150,000 913,162 1,236,838 200,000 200,000 1,436,838 302,102 1,134,736 7348 Solids Handling Facility Improvements 27,518,687 23,944,964 3,573,723 14,000,000 14,000,000 17,573,723 10,811,740 6,761,983 ***7349 Aeration & Energy Upgrade 5,850,000 4,538,248 1,311,752 - (1,000,000) (1,000,000) 311,752 16,060 295,692 7357 Plant Wide Instrumentation Upgrade 521,000 193,577 327,423 - - - 327,423 206,493 120,930 7369 Piping Renovation - Phase 10 5,4S0,000 3,588,846 1,861,154 - - 1,861,154 868,050 993,104 7370 Annual Infrastructure Replacement 3,605,000 2,593,784 1,011,216 500,000 500,000 1,511,216 1,691,080 (179,864) 7373 Fire Protection System Ph. 3 1,100,000 1,065,155 34,845 - - - 34,845 35,738 (893) ***100001 UPCAA Urgent Projects FY 2020-25 1,300,000 288,710 1,011,290 400,000 (500,000) (100,000) 911,290 276,534 634,756 100008 Laboratory Roof & Seismic upgrades 1,450,000 1,309,661 140,339 - 235,000 235,000 37S,339 378,600 (3,261) 100009 Hearth Replacement 500,000 291,003 208,997 - - - 208,997 251,377 (42,380) 100010 Air Condiditioning & Lighting Renovation 250,000 185,944 64,056 200,000 - 200,000 264,056 251,926 12,130 100011 Plant Electrical Replacement & Rehabilitation 808,371 317,259 491,112 250,000 - 250,000 741,112 45,785 695,327 100012 UV Disinfection Replacement 6,000,000 1,608,375 4,391,625 1,500,000 (2,000,000) (500,000) 3,891,625 358,807 3,532,818 *100013 UV Hydraulic Improvements 480,000 6,603 473,397 - (480,000) (480,000) (6,603) (6,603) - 100014 MRC Building Modifications 800,000 308,034 491,966 600,000 - 600,000 1,091,966 44,683 1,047,283 100015 Electric Blower Improvements 13,395,000 11,683,853 1,711,147 - - - 1,711,147 1,611,126 100,021 100019 Aeration Basins Diffuer Replacement and Seismic Upg 7,480,000 2,403,362 5,076,638 6,000,000 6,000,000 11,076,638 1,078,282 9,998,356 100022 Wet Weather Basin Improvements 1,300,000 538,477 761,523 600,000 600,000 1,361,523 161,558 1,199,965 ***100030 Solids Handling Facility Improvements Ph. 2 5,700,000 1,605,220 4,094,780 - (2,900,000) (2,900,000) 1,194,780 282,573 912,207 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 700,560 5,317,365 100034 TP Safety Enhancement Program - - - 300,000 (200,000) 100,000 100,000 119,583 (19,583) 100040 Electrical Infrasturcture Sub 90 500,000 500,000 500,000 500,000 1,000,000 114,037 885,963 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 31,979 342,328 ***100047 Secondary Clarifier Improvments - Phase 1 2,000,000 - 2,000,000 500,000 (1,000,000) (500,000) 1,500,000 114,953 1,385,047 100048 Warehouse Seismic Upgrades 500,000 500,000 - 500,000 2,1S6 497,844 171Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 111 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C A-B D E F +E G (C+D+El 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 1 Actual Remaining I Budgets Actuals FY 2023-34 Budget Adjustments Budget Expenditures Expenditures Budget 100051 RAS Piping Renovations 2,020,000 302,170 1,717,830 - - - 1,717,830 1,219,350 498,480 100054 Aeration Unit 1 Steam Turbine Overhaul 200,000 542 199,458 500,000 500,000 699,458 872,024 (172,566) 100055 Process Optimization and Efficiency 200,000 307 199,693 300,000 - 300,000 499,693 165,991 333,702 100057 Plant Control System I/O Replacement - Phase 3 - - - 600,000 600,000 600,000 187,054 412,946 100058 Treatment Plant Planning2023+ - - - 250,000 - 250,000 250,000 204,604 45,396 **100067 POB Parking Lot Improvements - 200,000 200,000 200,000 27,414 172,586 **100069 Odor Control Facilities Improvements 450,000 450,000 450,000 - 450,000 Rounding Total TP Program $ 109,981,332 $ 71,268,710 $ 38,712,622 $ 31,300,000 $ (8,895,000) $ 22,405,000 $ 61,117,622 $ 22,683,355 $ 38,434,267 * Projects open but not in CIB for 23/24 ** New project Not in 23/24 Budget Funds transferred from other projects or Contingency *** Project budget adjustments to reduce FY 2023-24 budget and fund contingency 181Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 112 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C A-B D E F +E G (C+D+El 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 1 Actual Remaining I Budgets Actuals FY 2023-34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE GI General Improvements *8250 ERP Replacement $ 5,380,000 $ 5,350,990 $ 29,010 $ - $ - $ - $ 29,010 $ 9,626 $ 19,384 8251 Capital improvement program & Budget Improvement 590,000 520,092 69,908 69,908 116,333 (46,425) 8252 POB E.V. Charging Station 640,000 90,570 549,430 650,000 - 650,000 1,199,430 373,304 826,126 *8253 COVID-19 Response 275,000 198,723 76,277 - (54,909) (54,909) 21,368 21,368 - 8516 District Equipment Acquisition 1,726,000 1,672,577 53,423 250,000 100,000 350,000 403,423 225,632 177,791 8517 Vehicle Replacement Program 6,018,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 342,861 427,783 100004 HOB Exterior Repairs 400,000 291,102 108,898 - - 108,898 - 108,898 100027 Furnishings Replacement 100,000 19,271 80,729 - - - 80,729 12,867 67,862 100029 Solar Project onLagiss 600,000 517,740 82,260 - - 82,260 4,108 78,152 100031 Community Dev. System Replacement 600,000 288,888 311,112 200,000 - 200,000 511,112 321,814 189,298 100033 Security Improvements FY 2021-25 300,000 155,718 144,282 100,000 100,000 244,282 60,559 183,723 100035 Technology Strategic Plan 800,000 336,701 463,299 - - - 463,299 314 462,985 100043 Easement AcquisitionFY2022-31 75,000 8,486 66,514 75,000 (138,954) (63,954) 2,560 2,560 - 100056 NetZero Study 200,000 69,756 130,244 - - - 130,244 65,169 65,075 100063 It Development2023+ - - - 900,000 900,000 900,000 614,985 285,015 100064 Capital Legal Service 2023+ - - - 25,000 - 25,000 25,000 21,972 3,028 ***100071 Long Term Wet Weather Resiliency - - 200,000 200,000 200,000 - 200,000 **9999 Capital Project Clearing (Accounting Use Only) - 11,101 (11,101) - - - (11,101) - (11,101) Rounding Total GI Program $ 18,854,000 $ 14,607,819 $ 4,246,181 $ 3,350,000 $ 106,137 $ 3,456,137 $ 7,702,318 $ 2,903,273 $ 4,799,045 * Projects open but not in CIB for 23/24 ** Not in 23/24 Budget Funds transferred from other projects or Contingency *** New project Not in 23/24 Budget Funds transferred from other projects or Contingency 191Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 113 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C A-B D E F +E G (C+D+El 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 1 Actual Remaining I Budgets Actuals FY 2023-34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE RW Recycled Water 7361 Filter Plant & Clearwell Improvements Ph. 1A $ 40,389,000 $ 36,677,028 $ 3,711,972 $ - $ - $ - $ 3,711,972 $ 2,823,463 $ 888,509 7366 ReW Distribution System Renov. Program 530,000 221,750 308,250 215,000 215,000 523,250 49,451 473,799 7368 Water Exchange Project 400,000 142,137 257,863 - - - 257,863 - 257,863 100002 Filter Plant & Clearwell Improvements Ph. 1B 1,450,000 41,853 1,408,147 500,000 500,000 1,908,147 139,089 1,769,058 100036 Zone 1 Recycled Water 2021 100,000 45,574 54,426 103,000 103,000 157,426 53,052 104,374 Rounding Total RW Program $ 42,869,000 $ 37,128,342 $ 5,740,658 $ 818,000 $ $ 818,000 $ 6,558,658 $ 3,065,054 $ 3,493,604 9990 CONTINGENCY -ALL PROGRAMS $ $ $ $ $ 8,195,000 $ 81195,000 $ 8,195,000 $ 8,195,000 9990 CONTINGENCY BAL TRANS - CLOSE OUTS $ $ $ $ $ 455,768 $ 455,768 $ 455,768 $ 455,768 GRAND TOTAL $ 268,099,482 $ 189,280,021 $ 78,819,461 $ 71,202,000 $ $ 71,202,000 $ 150,021,461 $ 53,331,091 $ 96,690,370 201Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 114 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 4 - Sewer Construction Fund Capital Budget Transfers (by Project) FY 2023-24 Total FY 2023- Contingency Project No. Project Description Q1 Q2 Q3 Q4 24Activity Balance FY 2023-24 Adopted Budget Balance $ 5,000,000 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 Martinez Urgent Force Main Replacement 200,000 3,762,000 - - 3,962,000 - *100050 CCTAA-Line Relocation 900,000 - 900,000 100034 TP Safety Enhancement Program (200,000) (200,000) 100067 POB Parking Lot Improvements 200,000 - - - 200,000 - 100039 Collection System Sewer Renovation Ph. 2 (5,835,000) (4,262,000) (1,200,000) - (11,297,000) - 100049 Downtown Walnut Creek Sewer Renovations, Ph. 1 5,835,000 - - - 5,835,000 - 100068 Pleasant Hill Sewer Renovation Ph. 3 - 500,000 - - 500,000 - *100008 Laboratory Roof & Seismic Upgrades 235,000 235,000 *100069 Odor 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 Research 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) - 8516 District Equipment Ecquisition - - 100,000 - 100,000 - **8449 Collection System Modeling Support - - (225,659) - (225,659) - **100053 Houston Ct Area CAD - - (36,246) - (36,246) - **8253 COVID-19 Response - - (54,909) - (54,909) - **100043 Easement Acquisition FY2022-31 38954 9990 Current year Contingency 1,750,000 685,000 5,63840 000 3,19 000 **9990 Contingency transfers to from due to closeouts 455,768 455,768 1 455,768 GRAND TOTAL $ $ $ $ $ - $ 8,650,768 * Contingency Projects In FY23-24, the following projects' budgets were reduced to fund contingency: 7349 Aeration & Energy Upgrade $ (1,000,000) 100001 UPCAA Urgent Projects FY 2020-25 (500,000) 100030 Solids Handling Facility Improvements Ph. 2 (2,500,000) 100047 Secondary Clarifier Improvments - Phase 1 (1,000,000) TOTAL $ (5,000,000) 211Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 115 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section S - 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 0.0% Subrogation Recoveries - 4,300 4,300 - 4,300 4,300 - Investment Income 79,075 107,764 28,689 36.3% 237,225 277,017 39,792 16.8% 316,300 87.6% Total Revenues $ 79,075 $ 112,064 $ 32,989 41.7% $ 1,913,977 $ 1,958,069 $ 44,092 2.3% $ 2,017,052 97.1% 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 221Page Investment Income May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 116 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section S - 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 $ 381,036 $ (287,286) -306.4% $ 781,2S0 $ 752,956 $ 28,29S 3.6% $ 875,000 86.1% Technical Services 13,750 - 13,7S0 100.0% 41,2S0 3,065 38,18S 92.6% 55,000 S.6% Insurance & Risk Management 432,500 5,739 426,761 98.7% 1,297,500 1,665,449 (367,949) -28.4% 1,730,000 96.3% Total Expenses $ 540,000 $ 386,775 $ 153,22S 28.4% $ 2,120,000 $ 2,421,469 $ (301,469) -14.2% $ 2,660,000 91.0% 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 231Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 117 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 6 - Debt Service Fund Revenues by Source QTD YTD QTD QTD QTD Variance YTD YTD YTD Revenue Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (°/a) _ Tax Revenue $ 8,208,017 $ 946,116 $ (7,261,901) -88.5% $ 9,160,142 $ 9,152,600 $ (7,542) -0.1% $ 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 241Page Annual Budget nnual Realized timate (%) 9,160,142 99.9% May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 118 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 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 946,125 (573,453) -153.9% 2,064,142 1,318,797 745,345 36.1% 2,064,142 156.5% Total Expenses $ 7,462,672 $ 946,125 $ 6,516,547 87.3% $ 9,160,142 $ 8,414,597 $ 745,545 8.1% $ 9,160,142 91.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 251Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 119 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 7 - Quarterly Investment Portfolios Operating & Maintenance Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of QTD Investment YTD Investment No Issuer Type Date Date Maturity Yield Outlay, Face Value (Mamrityl Face Value Market Value Portfolio Income Income 519 State of Calif. LAW n/a n/a n/a (1) $ 19,500,000 $ 30,500,000 $ (11,000,000) $ 19,500,000 $ 19,386,730 92.86% $ 229,763 $ 471,901 RE22 UST Notes US Treasury 5/19/2022 4/30/24 30 2.661% 1,495,430 1,500,000 - 1,500,000 1,496,535 7.14% 337 1,017 RE26 FHLB US Agency 12/22/2023 3/19/24 0 5.344% 4,936,567 5,000,000 (5,000,000) 0.00% 56,225 63,433 (3) $ 25,931,996 $ 37,000,000 $ (16,000,000) $ 21,000,000 $ 20,883,265 100.00% 286,325 536,352 L) h) (5) 6,149 41,239 $ 292,473 $ 577,591 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date References: (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of March 2024 was 4.22%. (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.11%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut-off for month -end reporting by Contra Costa County. (4) The market value of the portfolio on March 31, 2024 was $20,883,265. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values quarterly. (5) Amount represents interest income from prior period investments. Notes: (A) All investments held by the Running Expense Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central Santo meet budgeted expenditures of the Running Expense fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Running Expense Fund, $6,460,000 is restricted for the Rate Stab0i ation Fund Account. 261Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 120 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 7 - Quarterly Investment Portfolios Sewer Construction Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of QTD Investment YTD Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif. LAIF n/a n/a n/a (1) $ 7,500,000 $ 17,500,000 $ (10,000,000) $ 7,500,000 $ 7,456,435 5.79% $ 107,668 $ 465,150 961 US T Bill US Treasury 1/21/2022 1/15/2025 290 1.26% 2,490,039 2,500,000 - 2,500,000 2,423,400 1.93% 793 2,395 964 UST Notes US Treasury 5/19/2022 4/30/2024 30 2.66% 2,492,383 2,500,000 - 2,500,000 2,494,225 1.93% 561 1,696 979 US Treasury US Treasury 10/27/2023 1/25/2024 0 5.45% 24,688,438 25,000,000 (25,000,000) - - 0.00% 83,083 311,563 980 US Treasury US Treasury 12/1/2023 2/29/2024 0 5.39% 8,388,756 8,500,000 (8,500,000) - - 0.00% 72,926 111,244 981 US Treasury US Treasury 12/15/2023 3/14/2024 0 5.37% 29,608,875 30,000,000 (30,000,000) - - 0.00% 317,246 391,125 982 US Treasury US Treasury 12/15/2023 3/14/2024 0 5.37% 23,687,100 24,000,000 (24,000,000) - - 0.00% 253,797 312,900 983 FHLB DISC US Agency 12/22/2023 3/19/2024 0 5.34% 35,543,280 36,000,000 (36,000,000) - - 0.00% 404,820 456,720 984 US Treasury US Treasury 1/26/2024 4/25/2024 25 5.36% 24,675,000 - 25,000,000 25,000,000 24,912,500 19.31% 238,333 238,333 985 US Treasury US Treasury 3/1/2024 5/30/2024 60 5.37% 5,921,775 - 6,000,000 6,000,000 5,948,280 4.63% 26,944 26,944 986 US Treasury US Treasury 3/15/2024 6/13/2024 74 5.39% 49,346,250 - 50,000,000 50,000,000 49,471,000 38.61% 123,486 123,486 987 US Treasury US Treasury 3/20/2024 6/18/2024 79 5.36% 35,531,550 36,000,000 36,000,000 35,595,360 27.80% 62,460 62,460 (3) $ 249.673.446 $ 146.000.000 $ (16,500,0001 $ 129.500.000 $ 128.301.199 100.00% 1,692,117 2,504,016 (2) (4) (5) 10,098 2,030,810 $ 1.702,215 $ 4.534.826 Legend: EOQ = End of quarter BOQ - Beginning of quarter YTD = Year to Date References: (1) Annual Yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of March 2024 was 4.22%. (2) The face value indicates the value of the investment if held until maturity, which is the usual District practice. (3) The weighted average yield of the total Sewer Construction portfolio is 5.10%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut-off for month -end reporting by Contra Costa County. (4) The market value of the portfolio on March 31, 2024 was $128301,199. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values monthly. 15) Amount represents investment income from prior period investments. Notes: (A) All investments held by the Sewer Construction Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central Santo meet budgeted expenditures of the Sewer Construction fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Sewer Construction Fund, $1,000,000 is restricted for the Rate Stabilization Reserve Account 271Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 121 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 7 - Quarterly Investment Portfolios Self Insurance Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of QTD Investment YTD Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity] Face Value Market Value Portfolio Income Income 519 State of Calif. LAIF n/a n/a n/a (1) $ 10,100,000 $ 10,100,000 $ $ 10,100,000 $ 10,041,332 100.00% $ 103,596 $ 266,074 (3) $ 10,100,000 $ 10,100,000 $ $ 10,100,000 $ 10,041,332 100.00% 103,596 266,074 (2) (4) (5) 3,855 10,943 $ 107,451 $ 277,017 Legend: EOQ = End of quarter BOQ - Beginning of quarter YTD = Year to Date References: (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of March 2024 was 4.22%. (2) The face value indicates the value of the investment if held until maturity, which is the usual District Practice. (3) The weighted average yield of the total Self -Insurance portfolio is 4.22%. (4) The market value of the portfolio on March 31, 2024 was $10,041,332. (5) Amount represents interest income from prior period investments. Notes: (A) All investments held by the Self Insurance Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Self Insurance fund for the next six (6) months [California Government Code §53646(b)(3)]. 281Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 122 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT O&M Fund Cashflow Forecast $50.0 $45.0 $40.0 $35.0 $30.0 $29. $25.0 $20.0 $15.0 $10.0 $5.0 $0.0 $37.6 $32.8 June '23 Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 8 - Financial Performance Metric Charts FY 2023-24 Running Expense Fund Total Cash & Investment Balances (Actuals through March 2024) $21.0 $20.e July $43.9 ON August September October November December January February March = Projected Balance* =Actual Balance —Reserve Target at Year End** April NOTES: * Projected balances were generated in July 2023 based on budgeted revenues and expenses for FY 2023-24 and applied to the actual balance at June 30, 2023. ** The Reserve Target at Year End is the minimum balance required at June 30, 2024 to comply with the District Policy . 291Page May June May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 123 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast $160.0 $140.0 $120.0 $100.0 $80.0 $60.0 $40.0 $20.0 $0.0 $138.0� FY 2023-24 Sewer Construction Fund Total Cash & Investment Balances (Actuals through March 2024) $151.5 $142.9 June'23 July August September October November December January February March April May June M Projected Balance* MActual Balance —Reserve Target at Year End** NOTES: * Projected balances were generated in July 2023 based on budgeted revenues and expenses for FY 2023-24 and applied to the actual balance at June 30, 2023. ** The Reserve Target at Year End is the minimum balance required at June 30, 2024 to comply with the District Policy. 301Page PEI May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 124 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 8 - Financial Performance Metric Charts Staffing Trends 300 8.5% 295 I 7.9% 8.0% 290 19 7.5% 285 14 - 17 ua F 7.0% w v y 280 23 6.5% 275 — 6.4% � o 6.0 /o 270 5.8% H 5.5% ri 265 279 -- 4.8% 277 5.0% 260 268 255 4.5% 250 4.0% 3/31/21 3/31/22 3/31/23 3/31/24 Quarter Ended Filled Positions (FTEs) Vacancies (FTEs) Vacancy Rate 311Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 125 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 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 321Page Historical Quarterly 0&M Costper Million Gallons Treated $3,238 $3,241 $2,090 $2,891 3/31/21 3/31/22 3/31/23 3/31/24 Quarter Ended May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 126 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Total Sewer Construction Fund $1 SO $140 $1.30 $120 $110 $100 $90 $80 $70 $60 $50 $40 $30 $20 $10 Budget to Actual Spending Trend Sewer Construction Fund (in millions) $150.38 I i� $128.81 rr�I r r err �A I $85.53 r All I r � + +Ar+ I r+ 553.31 �r + r+ r++ r July August September October November December January =ebruary March April May June (Budget Target (90% of Budget) --C—Actual —0—Projected 331Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 127 of 190 Ogn CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Collection System Program Budget to Actual Spending Trend Collection System Program (ir millions) $70 $65 - $66.25� $60 5.55 550 $38.76� $59.63 $45 $40 $35 __ -----�-$34.88 - - $20--- $15 - $10 --- 45 July August September October Noven-ber Deceriber January February March April May June f Budget T3-get {90% of Budget] +Actual ex - • - Projected 341Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 128 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Treatment Program Budget to Actual Spending Trend Treatment Program (in millions) $7n $4,; . . $60 . $sn M17 $45 $4n-- $35 $30 r� $31.5s �} ' —$39.7&— $25 $�n $22.69 $15 .1111y A11gu5i Srpmmher nfTnhl!r NnVI!mhrr I1ew.mher January i-Phruary Marrh April May Imp --*— 6udrrel.-- •-- Tarlre I. 90 of 6mtre L] 0 AcLual — • — Pr oiecLed 351Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 129 of 190 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2024 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed / Renovated 2.5 2.0 2.0 1.8 1.7 1.6 c 1.5 0 v a� 0 W a. El. 1.0 0 0.6 .6 0.5 0.0 a Igo Iti3 1tiI31Iti� 3I31I�'� 6Ig0Iti� Quarter Ending ■ Actual Construction ■ Target ("S-Curve" of 6 mi. FY 23-24 Budget Projection) 361Page May 21, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 130 of 190