The URL can be used to link to this page

Home My WebLink About07. Receive Quarterly Financial Review for Quarter ending December 31, 2023Item 7. March 7, 2024 T O: HO NO R A B L E B O A R D O F D I R E C TO R S F RO M :C HR I S TO P HE R T HO MA S , A C C O UNT I NG S UP E RV I S O R K E V I N MI Z UNO, F I NA NC E MA NA G E R RE V IE WE D B Y:P HI L I P L E I B E R , D E P UT Y G E NE R A L MA NA G E R - A D MI NI S T R AT I O N R O G E R S. B A I L E Y, G E NE R A L MA NA G E R S UB J E C T: R E C E I V E Q UA RT E R LY F I NA NC I A L R E V I E W F O R Q UA RT E R E ND I NG D E C E MB E R 31, 2023 Attached is the Quarterly F inancial Review f or the second quarter of F iscal Year (F Y) 2023-24 ending D ecember 31, 2023 (unaudited). T he Executive Summary (Section 1) of the attached report includes an analysis of financial results and the investment portfolios f or the quarter. Strategic Plan Tie-I n G O A L FO U R : G overnance and Fiscal R esponsibility Strategy 1 - Promote and uphold ethical behavior, openness, and accessibility, Strategy 3 - Maintain financial stability and sustainability AT TAC HM E NT S : D escription 1. Quarterly F inancial Review f or the Quarter E nded December 31, 2023 March 7, 2024 Regular Board Meeting Agenda Packet - Page 23 of 306 Page 1 of 40 Orange County, California Orange County Sanitation DistrictFirst Quarter Financial Report Quarterly Financial Review For the Quarter Ended December 31, 2023March 7, 2024 Regular Board Meeting Agenda Packet - Page 24 of 306 Page 2 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Table of Contents Section 1 – Executive Summary ................................................................................................................................................................................................ 1 Section 2 – Financial Results Summary by Fund ................................................................................................................................................................ 4 Section 3 – Operations & Maintenance Fund Revenues Revenues by Source – Summary........................................................................................................................................................................................................ 5 Revenues by Source – Detail ............................................................................................................................................................................................................... 6 Expenses Expenses by Type – Summary ............................................................................................................................................................................................................ 7 Expenses by Type – Detail .................................................................................................................................................................................................................... 8 Expenses by Organizational Unit – Summary (Department) ............................................................................................................................................. 10 Expenses by Organizational Unit – Detail (Division) ............................................................................................................................................................. 11 Section 4 – Sewer Construction Fund Revenues Revenues by Source – Summary..................................................................................................................................................................................................... 12 Revenues by Source – Detail ............................................................................................................................................................................................................ 13 Expenses Expenses Summary (by Program) ................................................................................................................................................................................................. 14 Expenses Detail (by Project) ............................................................................................................................................................................................................ 15 Capital Budget Transfers (by Project by Month) ..................................................................................................................................................................... 21 Section 5 – Self Insurance Fund Revenues by Source ............................................................................................................................................................................................................................. 22 March 7, 2024 Regular Board Meeting Agenda Packet - Page 25 of 306 Page 3 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Table of Contents Expenses by Type ................................................................................................................................................................................................................................. 23 Section 6 – Debt Service Fund Revenues by Source ............................................................................................................................................................................................................................. 24 Expenses by Type ................................................................................................................................................................................................................................. 25 Section 7 – Investment Portfolio Reports Operations & Maintenance Fund .................................................................................................................................................................................................... 26 Sewer Construction Fund .................................................................................................................................................................................................................. 27 Self-Insurance Fund ............................................................................................................................................................................................................................. 28 Section 8 –Financial Performance Metrics O&M Fund Cashflow Forecast ......................................................................................................................................................................................................... 29 Sewer Construction Fund Cashflow Forecast ........................................................................................................................................................................... 30 Staffing Trends ....................................................................................................................................................................................................................................... 31 Cost per Million Gallons of Wastewater Treated ..................................................................................................................................................................... 32 Capital Spending Trends .................................................................................................................................................................................................................... 33 Miles of Pipeline Constructed/Renovated .................................................................................................................................................................................. 36 March 7, 2024 Regular Board Meeting Agenda Packet - Page 26 of 306 Page 4 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 1 –Executive Summary 1 | Page 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 (O&M), Sewer Construction, Self-Insurance, and Debt Service Funds. Operating & Maintenance Fund O&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 O&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 March 7, 2024 Regular Board Meeting Agenda Packet - Page 27 of 306 Page 5 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 1 –Executive Summary 2 | Page 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 O&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 March 7, 2024 Regular Board Meeting Agenda Packet - Page 28 of 306 Page 6 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 1 –Executive Summary 3 | Page 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 O&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. March 7, 2024 Regular Board Meeting Agenda Packet - Page 29 of 306 Page 7 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 2 –Financial Results Summary by Fund 4 | Page Category YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) Fund Revenues O&M 38,912,060$ 38,674,559$ (237,500)$ -0.6% 89,722,943$ 43.1% Sewer Construction 39,744,692 38,430,185 (1,314,507) -3.3% 93,126,163 41.3% Self Insurance 1,834,902 1,846,005 11,103 0.6% 2,017,052 91.5% Debt Service 8,208,017 8,206,484 (1,533) 0.0% 9,160,142 89.6% Total 88,699,671$ 87,157,234$ (1,542,437)$ 194,026,300$ Fund Expenses O&M 45,156,217$ 42,322,207$ 2,834,010$ 6.3% 90,946,671$ 46.5% Sewer Construction 58,472,949 34,820,420 23,652,529 40.5% 150,021,461 23.2% Self Insurance 1,580,000 2,034,694 (454,694) -28.8% 2,660,000 76.5% Debt Service 8,214,017 7,468,472 745,545 9.1% 9,160,142 81.5% Total 113,423,184$ 86,645,794$ 26,777,389$ 252,788,274$ $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,000,000 O&M Sewer Construction Self Insurance Debt Service Fund YTD Budget-to-Actual Revenues by Fund YTD Budget YTD Actual $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,000,000 $45,000,000 O&M Sewer Construction Self Insurance Debt Service Fund YTD Budget-to-Actual Expenses by Fund YTD Budget YTD Actual March 7, 2024 Regular Board Meeting Agenda Packet - Page 30 of 306 Page 8 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 3 – Operations & Maintenance Fund 5 | Page 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 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% $1,000,000 $11,000,000 $21,000,000 $31,000,000 Sewer Service Charge Revenue Sewage Treatment Cost Sharing Miscellaneous Service Charge Permit and Inspection Fees Other Non Opera ting Income Investment Income Year-to-Date Revenues by Source YTDBudget YTDActual March 7, 2024 Regular Board Meeting Agenda Packet - Page 31 of 306 Page 9 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 3 – Operations & Maintenance Fund 6 | Page 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% March 7, 2024 Regular Board Meeting Agenda Packet - Page 32 of 306 Page 10 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 3 – Operations & Maintenance Fund 7 | Page Expenses by Type – Summary Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) 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% $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Salaries & Wages Employee Benefits Unfunded Liability Costs Purchased Property Services Other Purchased Services Supplies & Materials Other Expenses Year-to-Date Expenses by Type YTD Budget YTD Actual March 7, 2024 Regular Board Meeting Agenda Packet - Page 33 of 306 Page 11 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 3 – Operations & Maintenance Fund 8 | Page Expenses by Type – Detail Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) 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 298,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) March 7, 2024 Regular Board Meeting Agenda Packet - Page 34 of 306 Page 12 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 3 – Operations & Maintenance Fund 9 | Page Expenses by Type – Detail (Continued) Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) Other Purchased Services Professional Services 377,566 158,393 219,173 58.0% 775,739 364,318 411,421 53.0% 1,557,534 23.4% Technical Services 764,019 483,203 280,816 36.8% 1,595,038 919,930 675,108 42.3% 3,160,776 29.1% Other Purchased Services 592,925 774,711 (181,786) -30.7% 1,205,735 1,535,750 (330,015) -27.4% 2,527,985 60.7% Total 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 Utilities & Fuel 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% Chemicals 740,000 705,627 34,373 4.6% 1,480,000 1,511,307 (31,307) -2.1% 2,960,000 51.1% General Supplies 728,233 576,776 151,457 20.8% 1,562,665 1,054,137 508,528 32.5% 3,038,960 34.7% Total 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 Memberships 228,329 148,676 79,653 34.9% 389,673 497,946 (108,273) -27.8% 761,830 65.4% Training & Meetings 177,706 110,913 66,794 37.6% 368,201 191,439 176,763 48.0% 744,313 25.7% Miscellaneous Other 53,811 86,748 (32,937) -61.2% 101,621 118,408 (16,787) -16.5% 197,742 59.9% Total 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% March 7, 2024 Regular Board Meeting Agenda Packet - Page 35 of 306 Page 13 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 3 – Operations & Maintenance Fund 10 | Page Expenses by Organizational Unit – Summary (by Department) Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) 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% $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Executive Governance Administration Engineering and Technical Services Operations Recycled Water Program Year-to-Date Expenses by Department YTD Budget YTD Actual March 7, 2024 Regular Board Meeting Agenda Packet - Page 36 of 306 Page 14 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 3 – Operations & Maintenance Fund 11 | Page Expenses by Organizational Unit – Detail (by Division) Organizational Unit QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) 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.5% 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.5% 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 53.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% March 7, 2024 Regular Board Meeting Agenda Packet - Page 37 of 306 Page 15 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 12 | Page Revenues by Source – Summary Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) 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% $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category Year-to-Date Revenues by Source YTD Budget YTD Actual March 7, 2024 Regular Board Meeting Agenda Packet - Page 38 of 306 Page 16 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 13 | Page Revenues by Source – Detail Category QTD Budget QTD Actual QTD Variance ($) QTD Revenue (%) YTD Budget YTD Actual YTD Variance ($) YTD Revenue (%) Annual Budget Annual Budget Realized (%) 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 1,017,500 1,506,271 488,771 48.0% 2,035,000 2,547,079 512,079 25.2% 4,070,000 62.6% Facilities Capacity Fees - Pump Zone 26,250 159,362 133,112 507.1% 52,500 159,362 106,862 203.5% 105,000 151.8% Capacity Use Charge 12,500 47,044 34,544 276.4% 25,000 47,044 22,044 88.2% 50,000 94.1% Secured Property Tax 7,380,000 3,736,770 (3,643,230) -49.4% 7,380,000 3,736,770 (3,643,230) -49.4% 13,933,358 26.8% Unsecured Property Tax 500,000 718,849 218,849 43.8% 500,000 718,849 218,849 43.8% 500,000 143.8% Investment Income 546,000 1,484,363 938,363 171.9% 1,023,000 2,856,003 1,833,003 179.2% 2,250,000 126.9% Other Government Revenue - Concord - - - - - - 7,570,000 0.0% State Revolving Fund Loan Proceeds 500,000 580,591 80,591 16.1% 500,000 580,591 80,591 16.1% 14,000,000 4.1% Overtime Inspection 1,500 347 (1,154) -76.9% 3,000 396 (2,604) -86.8% 6,000 6.6% Plan Review 22,250 19,426 (2,824) -12.7% 44,500 38,104 (6,396) -14.4% 89,000 42.8% Main Lines Inspection Fees 75,000 8,768 (66,232) -88.3% 150,000 22,618 (127,382) -84.9% 300,000 7.5% Rebates to District - - - - - - - Other Agency Reimbursement - - - - - - - Miscellaneous Income 250 7,682 7,432 2972.7% 500 9,174 8,674 1734.7% 1,000 917.4% Alhambra Valley Assessment District - - - - - - - Contractual Assessment District - (59,220) (59,220) - (8,615) (8,615) - Total Revenues 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% March 7, 2024 Regular Board Meeting Agenda Packet - Page 39 of 306 Page 17 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 14 | Page Capital Expenditures Summary (by Program) ABC (A‐B) D E F (D+E) G (C+D+E) H I (G‐H) Cumulative Cumulative Total Project FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023‐34 Budget Adjustments Budget Expenditures Expenditures Budget Collection System (CS) 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$ Treatment Plant (TP) 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 General Improvements (GI) 18,854,000 14,607,819 4,246,181 3,350,000 ‐ 3,350,000 7,596,181 1,986,713 5,609,468 Recycled Water (RW) 42,869,000 37,128,342 5,740,658 818,000 ‐ 818,000 6,558,658 2,430,893 4,127,765 CIB Contingency ‐ ‐ ‐ ‐ 2,565,000 2,565,000 2,565,000 ‐ 2,565,000 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$ March 7, 2024 Regular Board Meeting Agenda Packet - Page 40 of 306 Page 18 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 15 | Page Capital Expenditures Detail (by Project) ABC (A‐B) D E F (D+E) G (C+D+E) H I (G‐H) Cumulative Cumulative Total Project FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023‐34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 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 Ins pection 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 FY 22+ 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 March 7, 2024 Regular Board Meeting Agenda Packet - Page 41 of 306 Page 19 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 16 | Page Capital Expenditures Detail (by Project), Continued ABC (A‐B) D E F (D+E) G (C+D+E) H I (G‐H) Cumulative Cumulative Total Project FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023‐34 Budget Adjustments Budget Expenditures Expenditures Budget 100059 Collection System Planning 2023+ - - - 200,000 - 200,000 200,000 49,515 150,485 100060 Pumping Station Equipment & Piping Replacement 2023 - - - 200,000 - 200,000 200,000 740 199,260 100061 Maintenance Access Cover Modifications 2023+ - - - 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 March 7, 2024 Regular Board Meeting Agenda Packet - Page 42 of 306 Page 20 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 17 | Page Capital Expenditures Detail (by Project), Continued ABC (A‐B) D E F (D+E) G (C+D+E) H I (G‐H) Cumulative Cumulative Total Project FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023‐34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE 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 Enhancemetns Program - - - 300,000 (200,000) 100,000 100,000 111,672 (11,672) 100040 Electrical Infrasturcture Sub 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 March 7, 2024 Regular Board Meeting Agenda Packet - Page 43 of 306 Page 21 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 18 | Page Capital Expenditures Detail (by Project), Continued ABC (A‐B) D E F (D+E) G (C+D+E) H I (G‐H) Cumulative Cumulative Total Project FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023‐34 Budget Adjustments Budget Expenditures Expenditures Budget 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 542 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 I/O Replacement - Phase 3 - - - 600,000 - 600,000 600,000 102,287 497,713 100058 Treatment Plant Planning 2023+- - - 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 March 7, 2024 Regular Board Meeting Agenda Packet - Page 44 of 306 Page 22 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 19 | Page Capital Expenditures Detail (by Project), Continued ABC (A‐B) D E F (D+E) G (C+D+E) H I (G‐H) Cumulative Cumulative Total Project FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023‐34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE 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 on Lagiss 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 FY 2021-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 Ac quisition FY 2022-31 75,000 8,486 66,514 75,000 - 75,000 141,514 314 141,200 100056 NetZero Study 200,000 69,756 130,244 - - - 130,244 2,560 127,684 100063 It Development 2023+ - - - 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 March 7, 2024 Regular Board Meeting Agenda Packet - Page 45 of 306 Page 23 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 20 | Page Capital Expenditures Detail (by Project), Continued ABC (A‐B) D E F (D+E) G (C+D+E) H I (G‐H) Cumulative Cumulative Total Project FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 FY 2023‐2024 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2023‐34 Budget Adjustments Budget Expenditures Expenditures Budget TYPE 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$ March 7, 2024 Regular Board Meeting Agenda Packet - Page 46 of 306 Page 24 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 4 – Sewer Construction Fund 21 | Page Capital Budget Transfers (by Project) Project No. Project Description Q1 Q2 Q3 Q4 Total FY 2023‐24 Activity FY 2023‐24 Contingency 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 CCTA A-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) (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 year Contin gency (1,750,000) (685,000) ‐ ‐ (2,435,000) 2,565,000 **9990 Contingency transfers to / from due to closeouts ‐ ‐ GRAND TOTAL ‐$ ‐$ ‐$ ‐$ ‐$ 2,565,000$ * Contingency Projects March 7, 2024 Regular Board Meeting Agenda Packet - Page 47 of 306 Page 25 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 5 – Self Insurance Fund 22 | Page Revenues by Source Category QTD Budget QTD Actual QTD Variance ($) QTD Revenue (%) YTD Budget YTD Actual YTD Variance ($) YTD Revenue (%) Annual Budget Annual Budget Realized (%) 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% $- $500,000 $1,000,000 $1,500,000 $2,000,000 Sewer Service Charge Insurance Recoveries (HHW) Investment Income Revenue Source Category Year-to-Date Revenues by Source YTD Budget YTD Actual March 7, 2024 Regular Board Meeting Agenda Packet - Page 48 of 306 Page 26 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 5 – Self Insurance Fund 23 | Page Expenses by Type Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Budget Annual Budget Realized (%) Professional Services 593,750$ 205,605$ 388,146$ 65.4% 687,500$ 371,919$ 315,581$ 45.9% 875,000$ 42.5% Technical Services 13,750 3,065 10,685 77.7% 27,500 3,065 24,435 88.9% 55,000 5.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$ 455,177$ 584,824$ 56.2% 1,580,000$ 2,034,694$ (454,694)$ ‐28.8% 2,660,000$ 76.5% $- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 Professional Services Technical Services Insurance & Risk Management Expense Category Year-to-Date Expenses by Type YTD Budget YTD Actual March 7, 2024 Regular Board Meeting Agenda Packet - Page 49 of 306 Page 27 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 6 – Debt Service Fund 24 | Page Revenues by Source Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Revenue (%) Annual Estimate Annual Budget Realized (%) Tax Revenue 8,208,017$ 8,206,484$ (1,533)$ 0.0% 8,208,017$ 8,206,484$ (1,533)$ 0.0% 9,160,142$ 89.6% $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 Tax Revenue Year-to-Date Revenues by Source YTD Budget YTD Actual March 7, 2024 Regular Board Meeting Agenda Packet - Page 50 of 306 Page 28 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 6 – Debt Service Fund 25 | Page Expenses by Type Category QTD Budget QTD Actual QTD Variance ($) QTD Variance (%) YTD Budget YTD Actual YTD Variance ($) YTD Variance (%) Annual Estimate Annual Budget Variance (%) 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% $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 Professional Services Principal Payment Expense Interest Expense Year-to-Date Expenses by Type YTD Budget YTD Actual March 7, 2024 Regular Board Meeting Agenda Packet - Page 51 of 306 Page 29 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 7 – Quarterly Investment Portfolios 26 | Page Operating & Maintenance Fund No Issuer Type Purchase Date Maturity Date Days to Maturity Annual Yield Cash Outlay BOQ Face Value Purchase (Maturity) EOQ Face Value EOQ Market Value % of Portfolio QTD Investment Income YTD Investment 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) 4,608 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. (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. (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. March 7, 2024 Regular Board Meeting Agenda Packet - Page 52 of 306 Page 30 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 7 – Quarterly Investment Portfolios 27 | Page Sewer Construction Fund No Issuer Type Purchase Date Maturity Date Days to Maturity Annual Yield Cash Outlay BOQ Face Value Purchase (Maturity) EOQ Face Value EOQ Market Value % of Portfolio QTD Investment Income YTD Investment 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 5.40% 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 5.42% 8,389,047 8,500,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,867,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 5.43% 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,880 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$ 123,000,000$ 23,000,000$ 146,000,000$ 144,637,485$ 100.00%1,415,905 1,989,912 (2) (4) (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. (5) Amount represents investment income from prior period investments. Notes: (A) All investments held by the Sewer Construction Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Sewer Construction fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Sewer Construction Fund, $1,000,000 is restricted for the Rate Stabilization Reserve Account. (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. March 7, 2024 Regular Board Meeting Agenda Packet - Page 53 of 306 Page 31 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 7 – Quarterly Investment Portfolios 28 | Page Self Insurance Fund No Issuer Type Purchase Date Maturity Date Days to Maturity Annual Yield Cash Outlay BOQ Face Value Purchase (Maturity) EOQ Face Value EOQ Market Value % of Portfolio QTD Investment Income YTD Investment 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%84,283 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 comp ly 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)]. March 7, 2024 Regular Board Meeting Agenda Packet - Page 54 of 306 Page 32 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 8 – Financial Performance Metric Charts 29 | Page O&M Fund Cashflow Forecast 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 . $29.2 $21.0 $15.0 $25.9 $20.0 $18.0 $40.0 $35.3 $30.7 $25.7 $40.8 $35.6 $32.4 $32.8 $20.8 $14.6 $24.8 $19.6 $12.7 $43.9 $37.6 $37.9 $0.0 $5.0 $10.0 $15.0 $20.0 $25.0 $30.0 $35.0 $40.0 $45.0 $50.0 June '23 July August September October November December January Februa ry March April May June FY 2023‐24 Running Expense Fund Total Cash & Investment Balances (Actuals through December 2023) Projected Balance*Actual Balance Reserve Target at Year End** March 7, 2024 Regular Board Meeting Agenda Packet - Page 55 of 306 Page 33 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 8 – Financial Performance Metric Charts 30 | Page Sewer Construction Fund Cashflow Forecast 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. $78.8 $135.0 $130.0 $132.0 $120.0 $115.0 $145.0 $130.0 $120.0 $110.0 $125.0 $115.0 $100.0 $138.0 $133.0 $121.1 $126.1 $119.1 $114.5 $151.5 $43.2 $43.2 $0.0 $20.0 $40.0 $60.0 $80.0 $100.0 $120.0 $140.0 $160.0 June '23 July August September October November December January February March April May June FY 2023‐24 Sewer Construction Fund Total Cash & Investment Balances (Actuals through December 2023) Projected Balance*Actual Balance Reserve Target at Year End** March 7, 2024 Regular Board Meeting Agenda Packet - Page 56 of 306 Page 34 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 8 – Financial Performance Metric Charts 31 | Page Staffing Trends 277 276 280 279 16 15 14 19 5.5% 5.2% 4.8% 6.4% 4.0% 4.5% 5.0% 5.5% 6.0% 6.5% 250 255 260 265 270 275 280 285 290 295 300 12/31/20 12/31/21 12/31/22 12/31/23 Fu l l - T i m e E q u i v a l e n t s ( F T E s ) Quarter Ended Filled Positions (FTEs)Vacancies (FTEs)Vacancy Rate March 7, 2024 Regular Board Meeting Agenda Packet - Page 57 of 306 Page 35 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 8 – Financial Performance Metric Charts 32 | Page Cost per Million Gallons of Wastewater Treated March 7, 2024 Regular Board Meeting Agenda Packet - Page 58 of 306 Page 36 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 8 – Financial Performance Metric Charts 33 | Page Capital Spending Trend – Total Sewer Construction Fund March 7, 2024 Regular Board Meeting Agenda Packet - Page 59 of 306 Page 37 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 8 – Financial Performance Metric Charts 34 | Page Capital Spending Trend – Collection System Program March 7, 2024 Regular Board Meeting Agenda Packet - Page 60 of 306 Page 38 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 8 – Financial Performance Metric Charts 35 | Page Capital Spending Trend – Treatment Program March 7, 2024 Regular Board Meeting Agenda Packet - Page 61 of 306 Page 39 of 40 Budget‐to‐Actual Financial Report Quarter Ending December 31, 2023 Section 8 – Financial Performance Metric Charts 36 | Page Miles of Pipeline Constructed / Renovated 0.0 0.5 1.0 1.5 2.0 2.5 0.6 0.6 2.0 1.7 0.5 1.8 M i l e s o f P i p e l i n e C o n s t r u c t e d Quarter Ending Actual Construction Target ("S-Curve" of 6 mi. FY 23-24 Budget Projection) March 7, 2024 Regular Board Meeting Agenda Packet - Page 62 of 306 Page 40 of 40