The URL can be used to link to this page

Home My WebLink About03.c. Receive Quarterly Financial Review for Quarter Ending December 31, 2023Page 1 of 40 Item 3.c. F__1_448�411C_S0 February 27, 2024 TO: FINANCE COMMITTEE FROM: CHRISTOPHER THOMAS, ACCOUNTING SUPERVISOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIP LEIBER, DEPUTYGENERAL MANAGER -ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE QUARTERLY FINANCIAL REVIEW FOR QUARTER ENDING DECEMBER 31, 2023 Attached is the Quarterly Financial Review for the second quarter of Fiscal Year (FY) 2023-24 ending December 31, 2023 (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 3 - Maintain financial stability and sustainability ATTACHMENTS: 1. Quarterly Financial Review for the Quarter Ended December 31, 2023 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 88 of 196 Quarterly Financial Review CENTRAL SAN J' i i� i •_�� Ili ■A E.. �: � �,• Ended December 31, 2023 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 90 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 91 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 second quarter of FY 2023-24 ended December 31, 2023. 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 second quarter show total expenditures of $42.3 million, which is approximately $2.8 million (6.3%) 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, supplies & materials, and other purchased services expenditure line categories. The largest year-to-date favorable budgetary variance is with Salaries & Wages at $1.2 million (5.5%) attributable to a higher than budgeted vacancy rate (6.4% as of December 31, 2023) and incurring less overtime as well as temporary staffing support costs than projected through the second quarter of the year. The second largest year-to-date favorable budgetary variance was Supplies & Materials at approximately $0.9 million (11.8%) mainly due to general supplies and utilities & fuel costs in the treatment plan maintenance and collection system operations divisions coming in lower than budgeted through the second quarter. In the aggregate, the 0&M Fund is reporting a minor unfavorable revenue variance of $0.2 million, which is approximately 0.6% 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 second quarter show total capital project expenditures of $34.8 million, or 48.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 11Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 92 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 1 -Executive Summary FY 2023-24 is $150.0 million. The significant budgetary carryforward was primarily caused by two factors: (1) continued ripple effects from the global supply -chain difficulties that caused by international responses to the COVID-19 pandemic as well as 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 the alternatives to continuing with long-standing incineration methods. After factoring in the carryforward, the year-to-date capital spending rate is 23.2% 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 Treatment Plant program, followed by the Collection System program, which is 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 $38.4 million, falling just short of the year-to-date budget amount of $39.7 million by $1.3 million (-3.3%). The variance is mostly driven by secured property tax coming in under budget, which is normal due to the county allocation schedule. This deficit is expected be minimized later in the fiscal year after the April and June collections 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 December 31, 2023 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 second quarter of FY 2023-24, the 0&M Fund investment portfolio has generated just under $0.3 million in investment income, which is in line with interim budgetary estimates. The Sewer Construction Fund portfolio is reporting investment income of $2.8 million, which is well over the year-to-date revenue estimate of approximately $1.0 million by 179.2%. 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 has persisted through the second 2 1 P a g e February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 93 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 1 -Executive Summary quarter. During FY 2023-24, the Finance Division has continued to diversify the investment portfolio outside of LAIF, which reported a quarterly apportionment rate of 3.93% in the second 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 December 31, 2023, Central San was holding about 30.1% of its investment portfolio, or $58.1 million, in the Local Agency Investment Fund (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 0.9% 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 should help increase overall returns. Central San's investment portfolio is compliant with the Board's adopted policy regarding investments as of the quarter ended December 31, 2023. 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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 94 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 (%) $ 38,912,060 $ 38,674,559 $ (237,500) -0.6% $ 89,722,943 43.1% 39,744,692 38,430,185 (1,314,507) -3.3% 93,126,163 41.3% 1,834,902 1,846,005 11,103 0.6% 2,017,052 91.5% 8,208,017 8,206,484 (1,533) 0.0% 9,160,142 89.6% $ 88,699,671 $ 87,157,234 $ (1,542,437) $ 194,026,300 $ 45,156,217 $ 42,322,207 $ 2,834,010 6.3% $ 90,946,671 46.5% 58,472,949 34,820,420 23,652,529 40.5% 150,021,461 23.2% 1,580,000 2,034,694 (454,694) -28.8% 2,660,000 76.5% 8,214,017 7,468,472 745,545 9.1% 9,160,142 81.5% $ 113,423,184 $ 86,645,794 $ 26,777,389 $ 252,788,274 YTD Budget -to -Actual Revenues by Fund $a0,000,000 $35,000,000 $30,000,000 / $25,000,000,r $20,000,000'f�/' $15,000,000 ^ $,000,000 $5�. $S.DBD,BDB $__ O&M SewerSelflnsura Debt Service Fund •YTD •YTD Badges A-1 4 1 P a g e YTD Budget -to -Actual Expenses by Fund $45,00 DW $<o,000,DW ,F/n $35,000, 000 $30,000,000 $25,000,000 $20,000,000 $15,OOg000 r F YS.000,OOO .i o&M s—c.—i- s0flnsu'a Debt Service Fund •YTD •YTD Budg. Actual February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 95 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 3 - Operations & Maintenance Fund Revenues by Source - Summary Level QTD YTD Annual QTD QTD QTD Variance YTD YTD YTD Variance Annual Budget Category Budget Actual Variance ($) % Budget Actual Variance ($) (%) Budget Realized (%) Operating Revenues: Sewer Service Charge Revenue $ 36,785,805 $ 36,410,601 $ (375,204) -1.0% $ 36,827,794 $ 36,450,878 $ (376,915) -1.0% $ 66,051,443 55.2% Sewage Treatment Cost Sharing - (54,241) (54,241) - (54,241) (54,241) 17,900,000 -0.3% Miscellaneous Service Charge 259,008 275,634 16,626 6.4% 413,016 490,937 77,921 18.9% 2,200,000 22.3% Non -Operating Revenues: Permit and Inspection Fees 456,875 536,156 79,281 17.4% 913,750 1,006,458 92,708 10.1% 1,827,500 55.1% Other Non Operating Income 221,000 276,075 55,075 24.9% 434,500 496,557 62,057 14.3% 884,000 56.2% Investment Income 188,000 143,565 (44,435) -23.6% 323,000 283,970 (39,030) -12.1% 860,000 33.0% Total Revenue $ 37,910,688 $ 37,587,790 $ (322,898) -0.9% $ 38,912,060 $ 38,674,559 $ (237,500) -0.6% $ 89,722,943 43.1% Year -to -Date Revenues by Source $31,000,000 $21,000,000 $11,000,000 $1,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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 96 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 3 - Operations & Maintenance Fund Revenues by Source - Detail Level Category QTD Budget QTD Actual QTD Variance ($) QTD Variance % YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized Sewer Service Charge Revenue Sewer Service Charge Counter $ 48,987 $ 146,181 $ 97,194 198.4% $ 97,974 $ 186,458 $ 88,484 90.3% $ 195,949 95.2% Sewer Service Charge County 35,615,153 34,699,884 (915,269) -2.6% 35,615,153 34,699,884 (915,269) -2.6% 64,754,824 53.6% Sewer Service Charge Direct 1,128,663 1,574,032 445,369 39.5% 1,128,663 1,574,032 445,369 39.5% 1,128,663 139.5% Sewer Service Charge Prior (6,998) (9,496) (2,498) 35.7% (13,997) (9,496) 4,501 -32.2% (27,993) 33.9% Sewage Treatment Cost Sharing - (54,241) (54,241) - (54,241) (54,241) 17,900,000 -0.3% Miscellaneous Service Charges Septic Tank Dumping 11,250 8,278 (2,972) -26.4% 22,500 16,904 (5,596) -24.9% 45,000 37.6% Sales 250 20 (230) -92.0% 500 20 (480) -96.0% 1,000 2.0% Other Service Charges - 3,812 3,812 - 1,235 1,235 210,000 0.6% Recycled Water 128,750 113,020 (15,730) -12.2% 257,500 304,448 46,948 18.2% 515,000 59.1% Satellite Water Recycling - - - - - - - Stormwater Program 105,000 127,917 22,917 21.8% 105,000 127,917 22,917 21.8% 420,000 30.5% Household Hazardous Waste 13,758 22,587 8,829 64.2% 27,516 40,412 12,896 46.9% 1,009,000 4.0% Permit & Inspection Fees Permit/Application Fees 125,000 225,721 100,721 80.6% 250,000 438,424 188,424 75.4% 500,000 87.7% Main Lines Inspection Fees - - - - - - - Overtime Inspection 2,375 1,846 (530) -22.3% 4,750 3,893 (858) -18.1% 9,500 41.0% Side Sewer Inspection 290,000 263,676 (26,324) -9.1% 580,000 513,274 (66,726) -11.5% 1,160,000 44.2% Industrial Permit Fees 28,750 37,909 9,159 31.9% 57,500 37,909 (19,591) -34.1% 115,000 33.0% New Industry Permit Fees 4,500 3,630 (870) -19.3% 9,000 5,534 (3,466) -38.5% 18,000 30.7% Annexation Charges 6,250 3,375 (2,875) -46.0% 12,500 7,425 (5,075) -40.6% 25,000 29.7% Other Non -Operating Income MVSD P2 Program 7,500 9,010 1,510 20.1% 7,500 15,477 7,977 106.4% 30,000 51.6% Pretreatment Program Fine 500 - (500) -100.0% 1,000 - (1,000) -100.0% 2,000 0.0% Lease Rental Income 205,500 224,326 18,826 9.2% 411,000 374,509 (36,491) -8.9% 822,000 45.6% Miscellaneous Income 7,500 42,163 34,663 462.2% 15,000 92,616 77,616 517.4% 30,000 308.7% Right of Way Fees - 2,502 2,502 - 6,255 6,255 - Reimbursements - (1,925) (1,925) - 7,700 7,700 - Investment Income 188,000 143,565 (44,435) -23.6% 323,000 283,970 (39,030) -12.1% 860,000 33.0% Total Revenues $ 37,910,688 $ 37,587,790 $ (322,898) -0.9% $ 38,912,060 $ 38,674,559 $ (237,500) -0.6% $ 89,722,943 43.1% 6 1 P a g e February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 97 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 10,306,000 $ 9,921,372 $ 384,629 3.7% $ 22,523,094 $ 21,273,361 $ 1,249,733 5.5% $ 45,144,569 47.1% Employee Benefits 3,152,922 3,268,941 (116,019) -3.7% 6,557,994 6,693,914 (135,920) -2.1% 13,654,823 49.0% Unfunded Liability Costs 298,547 298,204 343 0.1% 349,558 348,768 790 0.2% 1,200,503 29.1% Purchased Property Services 1,749,734 2,249,013 (499,278) -28.5% 4,096,969 4,036,144 60,825 1.5% 7,697,774 52.4% Other Purchased Services 1,734,509 1,416,306 318,203 18.3% 3,576,512 2,819,998 756,514 21.2% 7,246,295 38.9% Supplies & Materials 3,543,198 3,125,884 417,314 11.8% 7,192,596 6,342,230 850,366 11.8% 14,298,822 44.4% Other Expenses 459,845 346,337 113,509 24.7% 859,495 807,793 51,702 6.0% 1,703,885 47.4% Total Expenses $ 21,244,757 $ 20,626,056 $ 618,701 2.9% $ 45,156,217 $ 42,322,207 $ 2,834,010 6.3% $ 90,946,671 46.5% Year -to -Date Expenses by Type $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 M 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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 98 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 9,449,971 $ 8,900,669 $ 549,302 5.8% $ 20,341,429 $ 19,176,690 $ 1,164,739 5.7% $ 41,187,208 46.6% Temporary Pay 364,336 312,483 51,853 14.2% 1,157,422 767,317 390,105 33.7% 1,913,093 40.1% Premium Pay 823,794 688,752 135,042 16.4% 1,688,443 1,290,501 397,942 23.6% 3,372,669 38.3% Board Fees 16,650 9,800 6,850 41.1% 33,300 25,600 7,700 23.1% 66,600 38.4% Other (348,750) 9,668 (358,418) 102.8% (697,500) 13,253 (710,753) 101.9% (1,395,000) -1.0% Total Salaries & Wages 10,306,000 9,921,372 384,629 3.7% 22,523,094 21,273,361 1,249,733 5.5% 45,144,569 47.1% Employee Benefits Insurance Premiums 2,146,574 1,965,983 180,591 8.4% 4,328,343 3,936,512 391,831 9.1% 8,885,919 44.3% Employer Taxes 151,049 166,630 (15,581) -10.3% 329,266 358,894 (29,628) -9.0% 660,013 54.4% Employer Retirement Contributions 1,836,381 1,789,861 46,520 2.5% 4,093,859 4,024,614 69,245 1.7% 8,490,640 47.4% OPEB Contributions 470,000 470,000 - 0.0% 940,000 940,000 - 0.0% 1,880,000 50.0% Benefit Adjustments (1,451,082) (1,123,533) (327,549) 22.6% (3,133,475) (2,566,106) (567,369) 18.1% (6,261,749) 41.0% Total Employee Benefits 3,152,922 3,268,941 (116,019) -3.7% 6,557,994 6,693,914 (135,920) -2.1% 13,654,823 49.0% Unfunded Liability Costs Pension 13,297 262,954 (249,657) -1877.5% 29,058 278,268 (249,210) -857.6% 59,503 467.7% OPEB 285,250 35,250 250,000 87.6% 320,500 70,500 250,000 78.0% 1,141,000 6.2% Total Unfunded Liability Costs 298,547 299,204 343 0.1% 349,558 348,768 790 0.2% 1,200,503 29.1% Purchased Property Services Repairs & Maintenance 1,093,297 1,542,581 (449,285) -41.1% 2,784,094 2,750,772 33,322 1.2% 5,070,924 54.2% Hauling & Disposal 304,575 299,609 4,966 1.6% 609,150 485,996 123,154 20.2% 1,218,300 39.9% Security 183,650 164,666 18,984 10.3% 367,300 329,855 37,445 10.2% 734,600 44.9% Rentals 37,075 101,898 (64,823) -174.8% 74,150 192,593 (118,443) -159.7% 149,400 128.9% Cleaning 130,763 138,549 (7,786) -6.0% 261,525 275,217 (13,692) -5.2% 523,050 52.6% Construction 375 1,710 (1,335) -356.0% 750 1,710 (960) -128.0% 1,500 114.0% Total Purchased Property Services 1,749,734 2,249,013 (499,278) -28.5% 4,096,969 4,036,144 60,825 1.5% 7,697,774 52.4% (Continued on page 9) 8 1 P a g e February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 99 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 (%) 377,566 158,393 219,173 58.0% 775,739 364,318 411,421 53.0% 1,557,534 23.4% 764,019 483,203 280,816 36.8% 1,595,038 919,930 675,108 42.3% 3,160,776 29.1% 592,925 774,711 (181,786) -30.7% 1,205,735 1,535,750 (330,015) -27.4% 2,527,985 60.7% 1,734,509 1,416,306 318,203 18.3% 3,576,512 2,819,998 756,514 21.2% 7,246,295 38.9% 2,074,966 1,843,481 231,485 11.2% 4,149,931 3,776,786 373,145 9.0% 8,299,862 45.5% 740,000 705,627 34,373 4.6% 1,480,000 1,511,307 (31,307) -2.1% 2,960,000 51.1% 728,233 576,776 151,457 20.8% 1,562,665 1,054,137 508,528 32.5% 3,038,960 34.7% 3,543,198 3,125,884 417,314 11.8% 7,192,596 6,342,230 850,366 11.8% 14,298,822 44.4% 228,329 148,676 79,653 34.9% 389,673 497,946 (108,273) -27.8% 761,830 65.4% 177,706 110,913 66,794 37.6% 368,201 191,439 176,763 48.0% 744,313 25.7% 53,811 86,748 (32,937) -61.2% 101,621 118,408 (16,787) -16.5% 197,742 59.9% 459,845 346,337 113,509 24.7% 859,495 807,793 51,702 6.0% 1,703,885 47.4% $ 21,244,757 $ 20,626,056 $ 618,701 2.9% $ 45,156,217 $ 42,322,207 $ 2,834,010 6.3% $ 90,946,671 46.5% February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 100 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 739,004 $ 438,255 $ 300,749 40.7% $ 1,594,192 $ 940,212 $ 653,980 41.0% $ 3,169,121 29.7% Administration 5,162,451 4,629,284 533,166 10.3% 10,560,211 9,632,215 927,997 8.8% 21,906,201 44.0% Engineering and Technical Services 3,542,596 3,323,780 218,817 6.2% 7,541,762 6,855,755 686,007 9.1% 15,257,107 44.9% Operations 11,343,988 11,841,476 (497,488) -4.4% 24,487,245 24,052,123 435,122 1.8% 48,689,437 49.4% Recycled Water Program 456,718 393,260 63,457 13.9% 972,806 841,903 130,903 13.5% 1,924,804 43.7% Total Expenses $ 21,244,757 $ 20,626,056 $ 618,701 2.9% $ 45,156,217 $ 42,322,207 $ 2,834,010 6.3% $ 90,946,671 46.5% Year -to -Date Expenses by Department $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services ■ YTD ■ YTD Budget Actual 101Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 101 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 444,808 $ 260,263 $ 184,544 41.5% $ 906,719 $ 493,914 $ 412,805 45.5% $ 1,852,510 26.7% Office of the Secretary of the District 200,377 146,480 53,897 26.9% 499,834 362,340 137,494 27.S% 938,800 38.6% Board of Directors 93,820 31,511 62,308 66.4% 187,639 83,959 103,680 55.3% 377,811 22.2% Administration Office of the Director of Finance and Administration 151,765 144,566 7,199 4.7% 329,939 309,984 19,955 6.0% 688,243 45.0% Finance Division 518,354 429,721 88,633 17.1% 1,124,953 954,961 169,992 15.1% 2,415,433 39.5% Human Resources Division 1,684,329 1,466,117 218,211 13.0% 3,206,592 2,729,306 477,286 14.9% 6,930,837 39.4% Purchasing Division 434,421 401,381 33,040 7.6% 942,089 878,402 63,687 6.8% 1,887,015 46.5% Risk Management Program 366,882 324,971 41,911 11.4% 753,809 701,629 52,181 6.9% 1,514,204 46.3% Public Info/Comm. Services & Intergov Relations Division 539,460 408,704 130,756 24.2% 1,064,025 964,390 99,636 9.4% 2,176,322 44.3% Information Technology Division 1,467,240 1,453,824 13,416 0.9% 3,138,804 3,093,543 45,261 1.4% 6,294,147 49.1% Engineering & Technical Services Office of the Director of Engineering & Technical Services 214,078 67,929 146,149 68.3% 467,677 128,482 339,195 72.5% 1,003,642 12.8% Planning & Developmental Services 1,241,436 1,310,900 (69,465) -5.6% 2,714,121 2,611,144 102,977 3.8% 5,385,263 48.5% Capital Projects Division (98,228) 100,492 (198,720) 202.3% (252,757) (86,374) (166,383) 65.8% (423,339) 20.4% Environmental & Regulatory Compliance 2,185,311 1,844,459 340,852 15.6% 4,612,721 4,202,503 410,218 8.9% 9,291,541 45.2% Operations Office of the Director of Operations 227,883 216,829 11,054 4.9% 488,356 371,564 116,791 23.9% 989,020 37.6% Collection System Operations Division 3,382,111 3,429,306 (47,195) -1.4% 7,109,360 7,219,250 (109,890) -1.S% 14,391,917 50.2% Treatment Plant Operations Division 4,011,170 4,142,781 (131,610) -3.3% 8,265,310 8,573,947 (308,637) -3.7% 16,610,137 51.6% Treatment Plant Maintenance Division 3,328,682 3,795,007 (466,325) -14.0% 7,766,793 7,266,400 500,393 6.4% 14,892,814 48.8% Operations Optimization Division 394,141 257,553 136,588 34.7% 857,427 620,962 236,465 27.6% 1,805,549 34.4% Recycled Water Recycled Water - General 47,175 20,425 26,750 56.7% 94,350 40,850 53,500 56.7% 188,700 21.6% Treatment Plant 247,650 240,221 7,429 3.0% 495,300 540,163 (44,863) -9.1% 1,012,200 53.4% Distribution System 98,118 80,265 17,853 18.2% 196,235 156,190 40,045 20.4% 392,470 39.8% Residential Fill Station 38,350 31,925 6,425 16.8% 136,071 63,850 72,221 S3.1% 229,734 27.8% Satellite Water Facility 25,425 20,425 5,000 19.7% 50,850 40,850 10,000 19.7% 101,700 40.2% Total Expenses $ 21,244,757 $ 20,626,056 $ 618,701 2.9% $ 45,156,217 $ 42,322,207 $ 2,834,010 6.3% $ 90,946,671 46.5% 111Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 102 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 27,998,181 $ 27,692,153 $ (306,028) -1.1% $ 28,031,192 $ 27,722,811 $ (308,381) -1.1% $ 50,251,805 55.2% Other Capital Revenues 10,081,250 8,210,252 (1,870,998) -18.6% 11,713,500 10,707,374 (1,006,126) -8.6% 42,874,358 25.0% Total Revenue $ 38,079,431 $ 35,902,404 $ (2,177,027] -5.7% $ 39,744,692 $ 38,430,185 $ (1,314,507) -3.3% $ 93,126,163 41.3% $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 121Page Year -to -Date Revenues by Source Sewer Service Charges Revenue Source Category ■ YTD ■ YTD Budget Actual Other Capital Revenues February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 103 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 111,180 $ 72,667 188.7% $ 77,025 $ 141,838 $ 64,812 84.1% $ 154,051 92.1% County Allocated 27,077,833 26,391,461 (686,372) -2.5% 27,077,833 26,391,461 (686,372) -2.5% 49,232,424 53.6% Direct Billed 887,337 1,196,734 309,397 34.9% 887,337 1,196,734 309,397 34.9% 887,337 134.9% Prior Year Adjustment (5,502) (7,222) (1,720) 31.3% (11,004) (7,222) 3,781 -34.4% (22,007) 32.8% 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 1,506,271 488,771 48.0 % 26,250 159,362 133,112 507.1% 12,500 47,044 34,544 276.4% 7,380,000 3,736,770 (3,643,230) -49.4% 500,000 718,849 218,849 43.8% 546,000 1,484,363 938,363 171.9% 500,000 580,591 80,591 16.1% 1,500 347 (1,154) -76.9% 22,250 19,426 (2,824) -12.7% 75,000 8,768 (66,232) -88.3% 2,035,000 2,547,079 512,079 25.2% 4,070,000 62.6% 52,500 159,362 106,862 203.5% 105,000 151.8% 25,000 47,044 22,044 88.2% 50,000 94.1% 7,380,000 3,736,770 (3,643,230) -49.4% 13,933,358 26.8% 500,000 718,849 218,849 43.8% 500,000 143.8% 1,023,000 2,856,003 1,833,003 179.2% 2,250,000 126.9% - - - 7,570,000 0.0% 500,000 580,591 80,591 16.1% 14,000,000 4.1% 3,000 396 (2,604) -86.8% 6,000 6.6% 44,500 38,104 (6,396) -14.4% 89,000 42.8% 150,000 22,618 (127,382) -84.9% 300,000 7.5% 250 7,682 7,432 2972.7% 500 9,174 8,674 1734.7% 1,000 917.4% (59,220) (59,220) (8,615) (8,615) $ 38,079,431 $ 35,902,404 $ (2,177,027) -5.7% $ 39,744,692 $ 38,430,185 $ (1,314,507) -3.3% $ 93,126,163 41.3% February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 104 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 4 - Sewer Construction Fund Capital Expenditures Summary (by Program) Collection System (CS) Treatment Plant (TP) General Improvements (GI) Recycled Water (RW) CIB Contingency Total 141Page A B C A-B D E F D+E G C+D+E H I G-H Cumulative Cumulative Total Project FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 FY 2023-2024 Prior Year Prior Year I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Bud ets Actuals FY 2023-34 Budget Adjustments Budget Expenditures Ex enditures Budget $ 96,395,150 $ 66,275,150 $ 30,120,000 $ 35,734,000 $ 1,750,000 $ 37,484,000 $ 67,604,000 $ 15,613,585 $ 51,990,415 109,981,332 71,268,710 38,712,622 31,300,000 (4,315,000) 26,985,000 65,697,622 14,789,229 50,908,393 18,854,000 14,607,819 4,246,181 3,350,000 3,350,000 7,596,181 1,986,713 5,609,468 42,869,000 37,128,342 5,740,658 818,000 - 818,000 6,558,658 2,430,893 4,127,765 2,565,000 2,565,000 2,565,000 2,565,000 $ 268,099,482 $ 189,280,021 $ 78,819,461 $ 71,202,000 $ $ 71,202,000 $ 150,021,461 $ 34,820,420 $ 115,201,041 5y0.uw,uuo 550,01M,00D $Mkow,ow $30,VW,ow sluuuu,uuu S Capital ImprovemenL BudgeL Quarterly Results by Program CIMw I im- SYA em [l:SI EW Tr 1n .nl PI-1 (TP) Cp. r ml 1i npmw III, r lH(Cr) PrugraaI 0Anp-1 Expendilurn ■An ual F.]-i Ili wrev -dam Rwyrinl WaLe (BWI February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 105 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 3,096,971 $ 4,304,813 *8436 Moraga/ Crossroads PS Project 35,451,000 35,218,893 232,107 232,107 2,837 229,270 8443 LG Diameter Pipe line Inspection 795,000 519,075 275,925 500,000 - 500,000 775,925 162,748 613,177 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 - - 237,684 12,025 225,659 8450 Development Sewerage Support 4,959,316 4,874,215 85,101 927,000 927,000 1,012,101 436,322 575,779 8457 Pump Station Upgrades - Ph. 2 14,650,000 7,967,271 6,682,729 10,000,000 - 10,000,000 16,682,729 4,973,733 11,708,996 8464 Martinez Sewer Renov. Ph. 7 4,581,000 3,130,124 1,450,876 - - - 1,450,876 1,042,381 408,495 *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 96,751 865,677 100017 SR Pump Station Electrical Upgrades 1,913,000 648,542 1,264,458 - - - 1,264,458 1,017,772 246,686 100023 Walnut Creek Sewer Renovation Ph. 16 6,379,000 4,923,785 1,455,215 - - - 1,455,215 1,278,892 176,323 100024 South Orinda Sewer Renovation Ph. 9 500,000 736,330 (236,330) (236,330) 12,417 (248,747) 100025 Lafayette Sewer Renov. Ph. 15 500,000 547,451 (47,451) (47,451) 45,997 (93,448) 100028 Collection System Master Plan 2021 Update 1,600,000 296,128 1,303,872 1,303,872 97,387 1,206,485 100037 Orinda Moraga PS Architectual Improvements 1,450,000 41,952 1,408,048 1,408,048 11,368 1,396,680 100038 San Pablo Watershed Improvements 200,000 43,502 156,498 - - - 156,498 19,027 137,471 100039 Collection System Sewere Renovation Ph. 2 2,950,000 69,907 2,880,093 18,500,000 (10,097,000) 8,403,000 11,283,093 16,560 11,266,533 100041 Buchanan Lift Station Replacements & Improvements 200,000 133,151 66,849 850,000 850,000 916,849 143,870 772,979 100042 Pump Station Upgrades, Phase 2B 3,200,000 125,802 3,074,198 2,500,000 2,500,000 5,574,198 1,596,260 3,977,938 100044 Collection System Modeling Support FY22+ 120,000 617 119,383 125,000 - 125,000 244,383 - 244,383 100049 Dowtown Walnut Creek Sewer Renovations, Ph. 1 500,000 258,352 241,648 - 5,835,000 5,835,000 6,076,648 540,875 5,535,773 100050 Caltrans A -Line Relocation 200,000 12,918 187,082 900,000 900,000 1,087,082 64,530 1,022,552 100052 No. Orinda Sewer Renovations, Ph. 9 500,000 225,068 274,932 - - 274,932 215,508 59,424 100053 Houston Ct Area CAD 252,894 216,648 36,246 36,246 - 36,246 151Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 106 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 49,515 150,485 100060 Pumping Station Equipment & Piping Replacement 2022 200,000 200,000 200,000 740 199,260 100061 Maintenance Access Cover Modifications2023+ 400,000 400,000 400,000 - 400,000 100062 Pumping Station SCADA & PLC Upgrades 350,000 - 350,000 350,000 - 350,000 **100065 Tappan Terrace Sewer Renovation 650,000 650,000 650,000 221,288 428,712 **100066 Martinez Urgent Force Main Replacement 3,962,000 3,962,000 3,962,000 330,050 3,631,950 **100068 Pleasant Hill Sewer Renovation Ph. 3 - - 500,000 500,000 500,000 49,483 450,517 Rounding Total CS Program $ 96,395,150 $ 66,275,150 $ 30,120,000 $ 35,734,000 $ 1,750,000 $ 37,484,000 $ 67,604,000 $ 15,613,585 $ 51,990,415 * Projects open but not in CIB for 23/24 ** New project Not in 23/24 Budget Funds transferred from other projects or Contingency 161Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 107 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ - $ 400,000 $ 764,892 $ 37,438 $ 727,454 7328 Influent Pump Electrical improvements 10,886,000 10,981,304 (95,304) - - (95,304) 190,819 (286,123) 7341 WC/Grayson Creek Levee Rehab 2,150,000 913,162 1,236,838 200,000 - 200,000 1,436,838 150,559 1,286,279 7348 Solids Handling Facility Improvements 27,518,687 23,944,964 3,573,723 14,000,000 14,000,000 17,573,723 7,475,789 10,097,934 ***7349 Aeration & Energy Upgrade 5,850,000 4,538,248 1,311,752 - (1,000,000) (1,000,000) 311,752 7,183 304,569 7357 Plant Wide Instrumentation Upgrade 521,000 193,577 327,423 327,423 118,647 208,776 7369 Piping Renovation - Phase 10 5,450,000 3,588,846 1,861,154 - - - 1,861,154 621,789 1,239,365 7370 Annual Infrastructure Replacement 3,605,000 2,593,784 1,011,216 500,000 500,000 1,511,216 1,598,585 (87,369) 7373 Fire Protection System Ph. 3 1,100,000 1,065,155 34,845 - - - 34,845 28,921 5,924 ***100001 UPCAA Urgent Projects FY 2020-25 1,300,000 288,710 1,011,290 400,000 (500,000) (100,000) 911,290 185,463 725,827 100008 Laboratory Roof & Seismic upgrades 1,450,000 1,309,661 140,339 - 235,000 235,000 375,339 301,985 73,354 100009 Hearth Replacement 500,000 291,003 208,997 - - - 208,997 130 208,867 100010 Air Condiditioning & Lighting Renovation 250,000 185,944 64,056 200,000 200,000 264,056 172,901 91,155 100011 Plant Electrical Replacement&Rehabilitation 808,371 317,259 491,112 250,000 - 250,000 741,112 13,856 727,256 100012 UV Disinfection Replacement 6,000,000 1,608,375 4,391,625 1,500,000 480,000 1,980,000 6,371,625 22,213 6,349,412 *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 18,414 1,073,552 100015 Electric Blower Improvements 13,395,000 11,683,853 1,711,147 - - - 1,711,147 1,348,802 362,345 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 381,247 10,695,391 100022 Wet Weather Basin Improvements 1,300,000 538,477 761,523 600,000 - 600,000 1,361,523 138,359 1,223,164 ***100030 Solids Handling Facility Improvements Ph. 2 5,700,000 1,605,220 4,094,780 - (2,500,000) (2,500,000) 1,594,780 261,617 1,333,163 100032 Steam Renovations, Ph. 1 5,000,000 982,075 4,017,925 3,500,000 - 3,500,000 7,517,925 457,652 7,060,273 100034 TP Safety Enhancemems Program - - - 300,000 (200,000) 100,000 100,000 111,672 (11,672) 100040 Electrical lnfrasturctureSub 90 500,000 500,000 500,000 500,000 1,000,000 93,023 906,977 100045 Fire Protection System Ph.4 860,000 - 860,000 - - - 860,000 184 859,816 100046 Control System Upgrades 200,000 25,693 174,307 200,000 200,000 374,307 27,214 347,093 ***100047 Secondary Clarifier Improvments - Phase 1 2,000,000 - 2,000,000 500,000 (1,000,000) (500,000) 1,500,000 37,028 1,462,972 100048 Warehouse Seismic Upgrades 500,000 500,000 - 500,000 - 500,000 171Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 108 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 291,985 1,425,845 100054 Aeration Unit 1 Steam Turbine Overhaul 200,000 S42 199,458 500,000 500,000 699,458 382,551 316,907 100055 Process Optimization and Efficiency 200,000 307 199,693 300,000 - 300,000 499,693 93,649 406,044 100057 Plant Control System 1/0 Replacement- Phase 3 _ - 600,000 600,000 600,000 102,287 497,713 100058 Treatment Plant Planning2023+ - 250,000 - 250,000 250,000 113,485 136,515 **100067 POB Parking Lot Improvements - - - - 200,000 200,000 200,000 10,385 189,615 **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 $ (4,315,000) $ 26,985,000 $ 65,697,622 $ 14,789,229 $ 50,908,393 * 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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 109 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 88,229 (18,321) 8252 POB E.V. Charging Station 640,000 90,570 549,430 650,000 - 650,000 1,199,430 206,444 992,986 *8253 COVID-19 Response 275,000 198,723 76,277 - - 76,277 21,368 54,909 8516 District Equipment Acquisition 1,726,000 1,672,577 53,423 250,000 250,000 303,423 43,492 259,931 8517 Vehicle Replacement Program 6,018,000 4,546,748 1,471,252 1,000,000 - 1,000,000 2,471,252 701,840 1,769,412 100003 Property Repairs & Improvements 1,150,000 529,356 620,644 150,000 150,000 770,644 - 770,644 100004 HOB Exterior Repairs 400,000 291,102 108,898 - - - 108,898 248,424 (139,526) 100027 Furnishings Replacement 100,000 19,271 80,729 80,729 - 80,729 100029 Solar Project onLagiss 600,000 517,740 82,260 - - - 82,260 5,185 77,075 100031 Community Dev. System Replacement 600,000 288,888 311,112 200,000 200,000 511,112 1,709 509,403 100033 Security Improvements FY2021-25 300,000 155,718 144,282 100,000 - 100,000 244,282 186,495 57,787 100035 Technology Strategic Plan 800,000 336,701 463,299 - - 463,299 39,986 423,313 100043 Easement Acquisition FY 2022-31 75,000 8,486 66,514 75,000 75,000 141,514 314 141,200 100056 Net2ero Study 200,000 69,756 130,244 - - - 130,244 2,560 127,684 100063 It Development2023+ - - - 900,000 900,000 900,000 54,886 845,114 100064 Capital Legal Service 2023+ - - - 25,000 - 25,000 25,000 357,543 (332,543) **9999 Capital Project Clearing (Accounting Use Only) 11,101 (11,101) - - (11,101) 18,612 (29,713) Rounding Total GI Program $ 18,854,000 $ 14,607,819 $ 4,246,181 $ 3,350,000 $ $ 3,350,000 $ 7,596,181 $ 1,986,713 $ 5,609,468 * Projects open but not in CIB for 23/24 ** Not in 23/24 Budget Funds transferred from other projects or Contingency 191Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 110 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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,276,871 $ 1,435,101 7366 ReW Distribution System Renov. Program 530,000 221,750 308,250 215,000 - 215,000 523,250 38,702 484,548 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 91,100 1,817,047 100036 Zone 1 Recycled Water 2021 100,000 45,574 54,426 103,000 - 103,000 157,426 24,220 133,206 Rounding Total RW Program $ 42,869,000 $ 37,128,342 $ 5,740,658 $ 818,000 $ $ 818,000 $ 6,558,658 $ 2,430,893 $ 4,127,765 9990 CONTINGENCY -ALL PROGRAMS $ $ $ $ $ 2,565,000 $ 2,565,000 $ 2,565,000 $ 2,565,000 GRAND TOTAL $ 268,099,482 $ 189,280,021 $ 78,819,461 $ 71,202,000 $ $ 71,202,000 $ 150,021,461 $ 34,820,420 $ 115,201,041 201Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 111 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 4 - Sewer Construction Fund Capital Budget Transfers (by Project) Total FY FY 2023-24 2023-24 Contingency Pro'ectNo. Project Description Q1 Q2 Q3 Q4 Activity Balance FY 2023-24 Adopted Budget Balance $ 5,000,000 100012 UV Disinfection Replacement $ 480,000 $ $ $ $ 480,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 200,000 *100050 CCTAA-Line Relocation 900,000 900,000 100034 TP Safety Enhancement Program (200,000) (200,000) 100067 PO Parking Lot Improvements 200,000 200,000 100039 Collection System Sewer Renovation Ph. 2 (5,835,000) (500,000) (6,335,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 9990 Current Vear Contingency 1,750,000 685,000 2,435,000 2,565,000 **9990 1 Contingency transfers to from due to closeouts - GRAND TOTAL $ - $ - $ $ $ - $ 2,565,000 * Contingency Projects 211Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 112 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 1,676,752 $ 0.0% $ 1,676,752 100.0% Insurance Recoveries (HHW) - - - - 24,000 0.0% Investment Income 79,075 87,386 8,311 10.5% 158,150 169,253 11,103 7.0% 316,300 53.5% Total Revenues $ 1,755,827 $ 1,764,138 $ 8,311 0.5% $ 1,834,902 $ 1,846,005 $ 11,103 0.6% $ 2,017,052 91.5% Year -to -Date Revenues by Source $2,000,000 $1,500,000 $1,000,000 $500,000 Sewer Service Charge Insurance Recoveries (HHW) Investment Income Revenue Source Category ■ YTD ■ YTD Budget Actual 221Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 113 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 593,750 $ 205,605 $ 388,146 65.4% $ 687,500 $ 371,919 $ 315,581 4S.9% $ 875,000 42.S% Technical Services 13,750 3,065 10,685 77.7% 27,500 3,065 24,43S 88.9% 55,000 S.6% Insurance & Risk Management 432,500 246,507 185,993 43.0% 865,000 1,659,710 (794,710) -91.9% 1,730,000 95.9% Total Expenses $ 1,040,000 $ 45S,177 $ S84,824 56.2% $ 1,S80,000 $ 2,034,694 $ (4S4,694) -28.8% $ 2,660,000 76.5% 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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 114 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 8,206,484 $ (1,533) 0.0% $ 8,208,017 $ 8,206,484 $ (1,533) 0.0% $ Year -to -Date Revenues by Source $10,000,000 $8,000,000 $6,000,000 $4, 000, 000 $2, 000, 000 Tax Revenue ■ YTD ■ YTD Budget Actual 241Page Annual Budget nnual Realized timate (%) 9,160,142 89.6% February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 115 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 $ 2,500 $ 3,500 58.3% $ 6,000 $ 5,800 $ 200 3.3% $ 6,000 96.7% Principal Payment Expense 7,090,000 7,090,000 - 0.0% 7,090,000 7,090,000 - 0.0% 7,090,000 100.0% Interest Expense 372,672 372,672 0.0% 1,118,017 372,672 745,345 66.7% 2,064,142 553.9% Total Expenses $ 7,468,672 $ 7,465,172 $ 3,500 0.0% $ 8,214,017 $ 7,468,472 $ 745,545 9.1% $ 9,160,142 81.5% Year -to -Date Expenses by Type $8,000,000 $6,000,000 $4,000,000 $2,000,000 IEW Professional Services Principal Payment Expense Interest Expense ■ YTD ■ YTD Budget Actual 251Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 116 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 Outlav Face Value (Maturitvl Face Value Market Value Portfolio Income Income 519 State of Calif. LAIF n/a n/a n/a (1) $ 30,500,000 $ 17,500,000 $ 13,000,000 $ 30,500,000 $ 30,303,065 82.43% $ 132,038 $ 242,138 RE22 UST Notes US Treasury 5/19/2022 4/30/24 121 2.661% 1,495,430 1,500,000 - 1,500,000 1,486,290 4.05% 340 681 RE26 FHLB US Agency 12/22/2023 3/19/24 79 5.344% 4,936,567 5,000,000 5,000,000 4,941,900 13.51% 7,208 7,208 (3) $ 36,931,996 $ 19,000,000 $ 18,000,000 $ 37,000,000 $ 36,731,256 100.00% 139,587 250,027 (2) (4) (5) 4608 35,090 $ 144,195 $ 285,117 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 December 2023 was 3.93%. (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 3.87%. 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 December 31, 2023 was $36,731,256. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values quarterly. (5) Amount represents interest income from prior period investments. Notes: (A) All investments held by the Running Expense Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Running Expense fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Running Expense Fund, $6,460,000 is restricted for the Rate Stabilization Fund Account 261Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 117 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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) $ 17,500,000 $ 21,500,000 $ (4,000,000) $ 17,500,000 $ 17,387,005 11.99% $ 171,163 $ 357,482 961 US T Bill US Treasury 1/21/2022 1/15/2025 381 1.26% 2,490,039 2,500,000 - 2,500,000 2,408,500 1.71% 801 1,603 964 UST Notes US Treasury 5/19/2022 4/30/2024 121 2.66% 2,492,383 2,500,000 - 2,500,000 2,477:150 1.71% 567 1,135 974 US Treasury US Treasury 7/26/2023 10/24/2023 0 SAO% 29,606,625 30,000,000 (30,000,000) - - 0.00% 104,900 393,375 975 US TREASURY US TREASURY 8/21/2023 11/16/2023 0 5.43% 3,949,018 4,000,000 (4,000,000) - - 0.00% 26,956 50,982 976 FHLB FHLB 9/1/2023 11/29/2023 0 SA2% 8,389,047 81500,000 (8,500,000) - - 0.00% 73,553 110,953 977 US TREASURY US TREASURY 9/15/2023 12/14/2023 0 5.45% 9,667,750 10,000,000 (10,000,000) - - 0.00% 108,739 132,250 978 US TREASURY US TREASURY 9/29/2023 12/14/2023 0 SA3% 43,509,547 44,000,000 (44,000,000) - - 0.00% 477,547 490,453 979 US Treasury US Treasury 10/27/2023 1/25/2024 25 5.45% 24,688,438 - 25,000,000 25,000,000 24,915,750 17.12% 228,479 228,479 980 US Treasury US Treasury 12/1/2023 2/29/2024 60 5.39% 8,388,756 - 8,500,000 8,500,000 8,427,920 5.82% 38,317 38,317 981 US Treasury US Treasury 12/15/2023 3/14/2024 74 5.37% 29,608,875 - 30,000,000 30,000,000 29,688,600 20.55% 73,879 73,879 982 US Treasury US Treasury 12/15/2023 3/14/2024 74 5.37% 23,687,100 - 24,000,000 24,000,000 23,750,680 16.44% 59,103 59,103 983 FHLB DISC US Agency 12/22/2023 3/19/2024 79 5.34% 35,543,280 36,000,000 36,000,000 35,581,680 24.66% 51,900 51,900 (3) $ 239.720.857 S 123,000,000 $ 23 000 000 $ 146,000,000 S 144.637.485 100.00% 1,415,905 1,989,912 (5) 7,773 842,699 $ 1,423,678 $ 2,832,611 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 December 2023 was 3.93%. (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.01%. 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 December 31, 2023 was $144,637,485. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values monthly. (1) Amount represents investment income from prior period investments. Notes: (A) All investments held by the Sewer Construction Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Sewer Construction fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Sewer Construction Fund, $1,000,000 is restricted for the Rate Stabilization Reserve Account 271Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 118 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 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 (Mamrityl Face Value Market Value Portfolio Income Income 519 State of Calif. LAIF n/a n/a n/a (1) $ 10,100,000 $ 8,600,000 $ 1,500,000 $ 10,100,000 $ 10,034,786 100.00% $ 84,283 $ 162,478 (3) $ 10,100,000 $ 8,600,000 $ 1,500,000 $ 10,100,000 $ 10,034,786 100.00% 84283 162,478 (2) (4) (5) 3,416 7,088 $ 87,699 $ 169,566 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 December 2023 was 3.93%. (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 3.93%. (4) The market value of the portfolio on December 31, 2023 was $10,034,786. (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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 119 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT O&M Fund Cashflow Forecast $50.0 $45.0 $40.0 $35.0 $30.0 $29.z $25.0 $20.0 $15.0 $10.0 $5.0 $0.0 Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 8 - Financial Performance Metric Charts FY 2023-24 Running Expense Fund Total Cash & Investment Balances (Actuals through December 2023) $43.9 $37.6 $32.8 June'23 July August September October November December January February March April May June = Projected Balance* = Actual 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 . 291Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 120 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast FY 2023-24 Sewer Construction Fund Total Cash & Investment Balances (Actuals through December 2023) $160.0 $140.0 138.0 $135.0 $120.0 $100.0 $80.0 s.s $60.0 $40.0 $43.2 $20.0 $0.0 June'23 July $115.0 $120.0 $114.5 $110.0 August September October November December January February March M Projected Balance* MActual Balance Reserve Target at Year End** $125.0 $115.0 $100.0 $43.2 April May June 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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 121 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Staffing Trends 300 295 WE 285 w F w y 280 c in 275 a' w E 270 i~ w 265 260 255 250 311Page Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 8 - Financial Performance Metric Charts 12/31/20 12/31/21 12/31/22 12/31/23 Quarter Ended Filled Positions (FTEs) Vacancies (FTEs) Vacancy Rate 6.5% 6.4% 6.0% 5.5% 5.0% 4.5% 4.0% February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 122 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated $5,000 $4,900 $4,000 $3,600 $3,000 $ 2,500 $2,000 $1,500 $1,000 SSW 3- 12J31/20 321Page Historical Quarterly O&M Cost per Million Gallons Treated $3,907 12/31/21 Quarter Ended 12/31/22 $3,927 12�31�23 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 123 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Total Sewer Construction Fund FY 2023-24 Budget to Actual Spending Trend Sewer Construction Fund (in millions) $160 $150 $110 — $130 $150.02 $i,u — $110 Sloo $90 $80 $58.47 $70 $bd Ssn -- $30 520 " r ~~ $34.82 - S- — — July August September October November December January February March April May June f Budget* Target (90% of Budget)** Actual *Total budget equal to adopted budget {$71.2M) plus unspent carryforward approp,lations from the prio•year ($60.3M), less $18.51V in carryforward directed to reserves per Board,adooted FY 23-24 CIB. **Target equ31 to 90%of budget, excluding unused contingenty. 331Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 124 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Collection System Program Budget to Actual Spending Trend Collection System Program (in millions) $70 $65 $60 $67.60 $55 $50 $45 $40 $25.88 $35 $30 $25 $23.30 $20 �- - $15 - $15.61 $10 - — July August September October November December January February Marcie April May June # Budget Target (90%of 3udget) Actual 341Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 125 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 8 - Financial Performance Metric Charts Capital Spending Trend - Treatment Program Budget to Actual Spending Trend Treatment Program (in millions) $70 — $65 $60 $65.70 $55 $50 $45 $40 $35 $21.87 $30 $25 - $20 a $19.69 $15 $14.80 $10 - July August September October November December January February March April May June tBudget Target (90%of Budget) Actual 351Page February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 126 of 196 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2023 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed / Renovated 2.5 2.0 2.0 1.8 1.7 c 1.5 0 v 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 February 27, 2024 Regular FINANCE Committee Meeting Agenda Packet - Page 127 of 196