The URL can be used to link to this page

Home My WebLink About05. Receive Quarterly Financial Review for quarter ending March 31, 2023Page 1 of 34 June 1, 2023 Item 5. LCENTRAL SAN 10010 jw�112 1 111 1 J] An FROM: CHRISTOPHER THOMAS, ACCOUNTING SUPERVISOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIP LEI BER, DEPUTY GENERAL MANAGER, ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE QUARTERLY FINANCIAL REVIEW FOR QUARTER ENDING MARCH 31, 2023 Attached is the Quarterly Financial Review for the first quarter of Fiscal Year (FY) 2022-23 ending March 31, 2023. The Executive Summary (Section 1) of the attached report includes an analysis of financial results and the investment portfolios for the quarter. Strategic Plan Tie -In GOAL FOUR: Governance and Fiscal Responsibility Strategy 1 - Promote and uphold ethical behavior, openness, and accessibility, Strategy 3 - Maintain financial stability and sustainability ATTACHMENTS: 1. Quarterly Financial Review for the Quarter Ended March 31, 2023 June 1, 2023 Regular Board Meeting Agenda Packet - Page 23 of 165 Quarterly Financial Review CENTRAL SAN _ n ArJ - _ i zi, I _ y I Quarter Ended March 31, 2023 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Table of Contents Section1- Executive Summary................................................................................................................................................................................................1 Section 2 - Financial Results Summary by Fund................................................................................................................................................................4 Revenuesby Source - Summary.....................................................................................................................................................................................................12 Section 3 - Operations & Maintenance Fund Revenuesby Source - Detail............................................................................................................................................................................................................13 Revenues Expenses 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 Section 5 - Self Insurance Fund Revenuesby Source.............................................................................................................................................................................................................................18 Expensesby Type.................................................................................................................................................................................................................................19 June 1, 2023 Regular Board Meeting Agenda Packet - Page 25 of 165 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Table of Contents Section 6 - Debt Service Fund Revenuesby Source.............................................................................................................................................................................................................................20 Expensesby Type.................................................................................................................................................................................................................................21 Section 7 - Investment Portfolio Reports Operations& Maintenance Fund....................................................................................................................................................................................................22 SewerConstruction Fund..................................................................................................................................................................................................................23 SelfInsurance Fund.............................................................................................................................................................................................................................24 Section 8 -Financial Performance Metrics 0&M Fund Cashflow Forecast.........................................................................................................................................................................................................25 Sewer Construction Fund Cashflow Forecast...........................................................................................................................................................................26 StaffingTrends.......................................................................................................................................................................................................................................27 Cost per Million Gallons of Wastewater Treated.....................................................................................................................................................................28 CapitalSpending Trend......................................................................................................................................................................................................................29 Milesof Pipeline Constructed/Renovated..................................................................................................................................................................................30 June 1, 2023 Regular Board Meeting Agenda Packet - Page 26 of 165 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 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 third quarter of FY 2022-23 ended March 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 third quarter show total expenditures of $61.3 million, which is approximately $3.1 million (4.8%) under the projected year-to-date FY 2022-23 budget. This favorable expense variance, largely attributable to lower than projected year-to-date spending in the other purchased services, purchased property services, and other expenses categories, is smaller than the favorable annual budget variance reported in the third quarter of the prior year of 6.0%. As noted previously, the largest individual expense category budgetary variance is in the other purchased services category, which is reporting a favorable variance of approximately $2.8 million (47.9%). In the aggregate, the 0&M Fund is reporting a favorable revenue variance of approximately $1.1 million, which is approximately 3.9% above total estimated year-to-date revenues. The primary driver for this overall revenue variance is sewer service charges received at the front counter directly from customers. Sewer Construction Fund Sewer Construction Fund results for the third quarter show total capital project expenditures of $38.2 million, or 42.0% of the total adopted budget of $91.0 million. While the Sewer Construction Fund's FY 2022-23 adopted budget was $91.0 million, when including carryforward capital project appropriations from the prior year of $67.0 million the total adjusted budget for FY 2022-23 is $158.0 million. The significant budgetary rollover was primarily caused by two factors: (1) continued global supply -chain difficulties that caused by international responses to the COVID-19 pandemic as well as the Russia -Ukraine conflict, and (2) postponements to the large debt-financed Solids Handling Facilities Improvement Project as Central San 11Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 27 of 165 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 1 -Executive Summary weighed the alternatives to continuing with long-standing incineration methods. After factoring in the carryforward, the year- to-date capital spending rate is 24.2% of total approved expenditures. The bulk of the FY 2022-23 year-to-date 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 17 of this report. Central San weighed the impacts of the aforementioned two major issues on its 10 -year long-term Capital Improvement Plan as presented to the Board in the January 12, 2023 rates workshop. Primary outcomes of this were a reduction to the anticipated FY 2023-24 capital improvement budget (CIB) as well as a planned reduction in the FY 2022-23 capital spend carryforward. Following a thorough analysis of capital project statuses, engineering staff anticipate a reduction in the FY 2022-23 carryforward by approximately $28.9 million. Rather than these unspent project appropriations carrying forward into the FY 2023-24 CIB, this amount will roll into Sewer Construction Fund reserves to finance anticipated needs in future years as projected in the 10 -year financial plan (FY 2024-25 and onward). On the revenue side, the Sewer Construction Fund is currently reporting revenues of $63.9 million, in excess of the year-to- date budget amount of $59.3 million by $4.6 million (7.7%). The bulk of this variance is attributable to facilities capacity fees, which reported a favorable variance of $2.4 million, already surpassing the $4.4 million total annual budget for this line item. Another noteworthy development this quarter was the investment portfolio for the Sewer Construction Fund receiving over $900 thousand in investment income due to the continued rise in interest rates, further discussed below. Investment Portfolio Highlights In accordance with Section 53646 of the California Government Code as well as Central San's Investment Policy, the Finance Division is required to submit an investment report to the General Manager and Board of Directors at least quarterly. The investments held by Central San for the quarter ended March 31, 2023 are presented in separate Investment Portfolio Reports for each fund on pages 22-24 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. 2 1 P a g e June 1, 2023 Regular Board Meeting Agenda Packet - Page 28 of 165 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 1 -Executive Summary Through the third quarter of FY 2022-23, the 0&M Fund investment portfolio has generated $452,631 of income which is above the year-to-date revenue estimate of $199,000 by 127.5%. The Sewer Construction Fund portfolio is reporting $1.6 million of income, also well over the year-to-date revenue estimate of $119,375 by 1226.6%. Both of these significant budgetary variances are attributable to several Fed interest rate hikes in 2022 to attempt to curb inflation, the extent of which were unknown and unanticipated when the FY 2022-23 budget was developed. During FY 2022-23 the Finance Division has recently made diversification of the investment portfolio outside of LAIF a top priority which 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 the portfolio thus far in FY 2022-23. As of March 31, 2023, Central San continues to hold about 36.1% of its investment portfolio, or $50.5 million, in the Local Agency Investment Fund (LAIF) state investment pool, under the maximum amount permitted to be held in the pool of $75.0 million. The Fed has continued its trend of aggressive normalization away from historically low interest rates that started in the calendar year 2022. In this quarter, the Fed issued two 25 -point rate hikes, resulting in a target rate of 4.75 - 5.00% as of the quarter's end. The Fed's rate increases have the goal of reducing inflation by cooling consumer demand and spending, which conversely runs the risk of slowing the economy down too fast into a recession. Central San's diversified portfolio, which includes U.S. Treasury Bills and Federal Agency Notes with maturity dates ranging from 6 to 36 months, continues to benefit from these interest rate hikes. 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 significant results to Central San's bottom line, with the 0&M investment earnings contributing less than 0.2% to total budgeted revenues for FY 2022-23. Central San's investment portfolio is in compliance with the Board's adopted policy regarding investments as of the quarter ended March 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 June 1, 2023 Regular Board Meeting Agenda Packet - Page 29 of 165 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 2 -Financial Results Summary by Fund Category YTD Budget Fund Revenues $ 69,762,907 0&M $ 28,814,178 Sewer Construction 59,324,987 Self Insurance 1,669,151 Debt Service 7,288,557 Total $ 97,096,872 Fund Expenses 0&M Sewer Construction Self Insurance Debt Service Total YTD Actual Annual YTD Budget YTD Variance Annual Realized Variance ($) (%) Budget (%) $ 29,948,577 $ 1,134,400 3.9% $ 69,762,907 42.9% 63,895,605 4,570,618 7.7% 128,787,570 49.6% 1,808,788 139,637 8.4% 1,734,501 104.3% 7,380,966 92,408 1.3% 13,251,922 55.7% $ 103,033,936 $ 5,937,063 13,251,922 $ 213,536,900 $ 182,376,668 $ 64,414,123 $ 61,347,980 $ 3,066,143 4.8% $ 85,019,046 72.2% 103,083,748 38,190,346 64,893,402 63.0% 157,985,178 24.2% 1,627,500 1,632,162 (4,662) -0.3% 2,170,000 75.2% 13,251,297 12,334,268 917,029 6.9% 13,251,922 93.1% $ 182,376,668 $ 113,504,756 $ 68,871,912 0&M $ 258,426,146 Debt Service YTD Budget -to -Actual Revenues by Fund $70,000,000 $bo,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 810,000,000 $ 0&M Sewer Lotsscruaion Selflnsura— Debts- Fund •YTD •YTD Budget Act -1 4 1 P a g e June 1, 2023 Regular Board Meeting Agenda Packet - Page 30 of 165 YTD Budget -to -Actual Expenses by Fund $m,o00,000 $6D,000,000 $50,000,000 $40,OOD,,OOD $30,000,000 $20,000,000 $10,000,000 E - 0&M s—construttion Selllnsurance Debt Service Fund •YTD •YTD Budg. Actual AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 3 - Operations & Maintenance Fund Revenues by Source - Summary Level Non -Operating Revenues: $27,000,000 QTD r� YTD Annual Permit and Inspection Fees QTD QTD QTD Variance YTD YTD YTD Variance Annual Budget Category Budget Actual Variance ($] % Budget Actual Variance ($) (%] Budget Realized (%] Operating Revenues: 70,000 231,121 161,121 230.2% 199,000 452,631 253,631 127.5% 262,000 172.8% Sewer Service Charge Revenue $ 13,677 $ 14,588 $ 911 6.7% $ 26,320,651 $ 26,794,850 $ 474,199 1.8% $ 47,162,407 56.8% Sewage Treatment Cost Sharing - - - (53,384) (51,459) 1,925 -3.6% 17,600,000 -0.3% Miscellaneous Service Charge 172,706 225,568 52,862 30.6% 508,917 669,294 160,377 31.5% 2,159,000 31.0% Non -Operating Revenues: $27,000,000 r� $22,000,000 Permit and Inspection Fees 523,302 363,244 (160,058) -30.6% 1,345,917 1,262,640 (83,277) -6.2% 1,799,500 70.2% Other Non Operating Income 169,886 377,552 207,666 122.2% 493,076 820,621 327,545 66.4% 780,000 105.2% Investment Income 70,000 231,121 161,121 230.2% 199,000 452,631 253,631 127.5% 262,000 172.8% Total Revenue $ 949,570 $ 1,212,073 $ 262,503 27.6% $ 28,814,178 $ 29,948,577 $ 1,134,400 3.9% $ 69,762,907 42.9% Year -to -Date Revenues by Source $(3,000,000) „SCwer 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 June 1, 2023 Regular Board Meeting Agenda Packet - Page 31 of 165 $27,000,000 r� $22,000,000 $17,000,000 rr� $12,000,000 rre $7,000,000 $2,000,000 $(3,000,000) „SCwer 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 June 1, 2023 Regular Board Meeting Agenda Packet - Page 31 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Revenues by Source - Detail Level Category QTD Budget Sewer Service Charge Revenue 437 Sewer Service Charge Counter $ 20,875 $ Sewer Service Charge County - Sewer Service Charge Direct 28,000 Sewer Service Charge Prior (7,198) Sewage Treatment Cost Sharing - Miscellaneous Service Charges YTD Septic Tank Dumping 2,339 Sales - Other Service Charges 268 Recycled Water 30,693 Satellite Water Recycling - Stormwater Program 105,549 Household Hazardous Waste 33,855 Permit & Inspection Fees Actual Permit/Application Fees 141,579 Overtime Inspection 4,023 Side Sewer Inspection 314,303 Industrial Permit Fees 51,136 New Industry Permit Fees 2,413 Annexation Charges 9,848 Other Non -Operating Income Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 3 - Operations & Maintenance Fund MVSD P2 Program 9,309 9,746 437 4.7% 12,486 16,496 4,010 Annual 28,000 58.9% QTD 500 - (500) YTD 1,500 Budget QTD QTD Variance YTD YTD YTD Variance Annual Realized Actual Variance ($) % Budget Actual Variance ($) (%) Budget 53,293 176,226 -143.4% (106,233) 126,463 232,696 -219.0% 10,000 1264.6% Right of Way Fees 12,555 $ (8,320) -39.9% $ 62,625 $ 359,799 $ 297,174 474.5% $ 83,500 430.9% - - - 25,456,540 25,597,257 140,717 0.6% 46,284,619 55.3% 2,693 2,693 823,081 841,534 18,453 2.2% 823,081 102.2% (660) 6,539 -90.8% (21,595) (3,740) 17,855 -82.7% (28,793) 13.0% - - $ 29,948,577 (53,384) (51,459) 1,925 -3.6% 17,600,000 -0.3% 25,543 23,204 992.0% 30,072 47,600 17,528 58.3% 40,000 119.0% 120 120 91 720 629 692.0% 1,000 72.0% 12,804 12,536 4668.9% 20,998 23,312 2,314 11.0% 210,000 11.1% 43,322 12,628 41.1% 252,377 323,035 70,658 28.0% 445,000 72.6% 107,570 2,021 1.9% 156,575 222,413 65,838 42.0% 415,000 53.6% 36,209 2,354 7.0% 48,805 52,214 3,409 7.0% 1,048,000 5.0% 166,205 24,626 17.4% 356,801 454,175 97,374 27.3% 480,000 94.6% 13,982 9,959 247.6% 8,330 15,023 6,694 80.4% 9,500 158.1% 120,411 (193,892) -61.7% 870,358 667,795 (202,563) -23.3% 1,160,000 57.6% 49,470 (1,666) -3.3% 83,221 85,019 1,798 2.2% 110,000 77.3% 6,366 3,953 163.8% 10,543 23,603 13,060 123.9% 15,000 157.4% 6,810 (3,038) -30.8% 16,665 17,025 360 2.2% 25,000 68.1% MVSD P2 Program 9,309 9,746 437 4.7% 12,486 16,496 4,010 32.1% 28,000 58.9% Pretreatment Program Fine 500 - (500) -100.0% 1,500 18,000 16,500 1100.0% 2,000 900.0% Lease Rental Income 283,010 304,590 21,580 7.6% 585,323 623,022 37,699 6.4% 740,000 84.2% Miscellaneous Income (122,933) 53,293 176,226 -143.4% (106,233) 126,463 232,696 -219.0% 10,000 1264.6% Right of Way Fees 3,222 3,222 9,789 9,789 - Reimbursements - 6,702 6,702 - 26,852 26,852 - Investment Income 70,000 231,121 161,121 230.2% 199,000 452,631 253,631 127.5% 262,000 172.8% Total Revenues $ 949,570 $ 1,212,073 $ 262,503 27.6% $ 28,814,178 $ 29,948,577 $ 1,134,400 3.9% $ 69,762,907 42.9% 6 1 P a g e June 1, 2023 Regular Board Meeting Agenda Packet - Page 32 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 3 - Operations & Maintenance Fund Expenses by Type - Summary 7 1 P a g e June 1, 2023 Regular Board Meeting Agenda Packet - Page 33 of 165 Year -to -Date Expenses by Type QTD $35,000,000 YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) Salaries & Wages $ 11,379,731 $ 11,068,179 $ 311,553 2.7% $ 32,513,051 $ 31,569,732 $ 943,319 2.9% $ 42,748,849 73.8% Employee Benefits 3,259,074 3,591,912 (332,837) -10.2% 9,176,671 10,225,518 (1,048,847) -11.4% 12,312,215 83.1% Unfunded Liability Costs 346,029 595,788 (249,759) -72.2% 1,035,525 1,785,171 (749,646) -72.4% 1,379,784 129.4% Purchased Property Services 1,554,350 1,353,423 200,927 12.9% 5,295,000 4,434,860 860,140 16.2% 6,850,450 64.7% Other Purchased Services 2,081,470 1,063,171 1,018,299 48.9% 5,952,688 3,102,965 2,849,723 47.9% 7,893,758 39.3% Supplies & Materials 3,042,750 3,358,175 (315,424) -10.4% 9,363,251 9,284,839 78,413 0.8% 12,406,002 74.8% Other Expenses 378,702 180,576 198,127 52.3% 1,077,937 944,896 133,041 12.3% 1,427,990 66.2% Total Expenses $ 22,042,108 $ 21,211,222 $ 830,885 3.8% $ 64,414,123 $ 61,347,980 $ 3,066,143 4.8% $ 85,019,046 72.2% 7 1 P a g e June 1, 2023 Regular Board Meeting Agenda Packet - Page 33 of 165 Year -to -Date Expenses by Type $35,000,000 $30,000,000 , $25,000,000 $20,000,000 $15,000,000 , $10,000,000 $5,000,000 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 June 1, 2023 Regular Board Meeting Agenda Packet - Page 33 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued on page 9) 8 1 P a g e June 1, 2023 Regular Board Meeting Agenda Packet - Page 34 of 165 QTD, YTD QTD QTD QTD Variance YTD YTD YTD Variance Annual Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget % Used Salaries & Wages FTE Regular Pay $ 10,456,770 $ 10,015,333 $ 441,437 4.2% $ 29,723,856 $ 28,397,671 $ 1,326,186 4.5% $ 39,048,125 72.7% Temporary Pay 444,656 378,814 65,842 14.8% 1,371,778 1,140,276 231,502 16.9% 1,818,405 62.7% Premium Pay 790,905 652,003 138,902 17.6% 2,355,216 1,981,098 374,118 15.9% 3,132,718 63.2% Board Fees 16,650 13,600 3,050 18.3% 49,950 38,800 11,150 22.3% 66,600 58.3% Other (329,250) 8,428 (337,678) 102.6% (987,750) 11,887 (999,637) 101.2% (1,317,000) -0.9% Total Salaries & Wages 11,379,731 11,068,179 311,553 2.7% 32,513,051 31,569,732 943,319 2.9% 42,748,849 73.8% Employee Benefits Insurance Premiums 2,102,783 2,005,801 96,982 4.6% 6,106,114 5,838,349 267,765 4.4% 8,187,170 71.3% Employer Taxes 168,646 213,293 (44,646) -26.5% 482,583 535,306 (52,723) -10.9% 634,803 84.3% Employer Retirement Contributions 2,140,914 2,189,089 (48,174) -2.3% 5,859,205 5,965,563 (106,358) -1.8% 7,760,922 76.9% OPEB Contributions 502,750 502,750 0 0.0% 1,508,250 1,508,250 0 0.0% 2,011,000 75.0% Other Benefits - (369) 369 0.0% - - 0.0% - 0.0% Benefit Adjustments (1,656,019) (1,318,652) (337,367) 20.4% (4,779,481) (3,621,950) (1,157,531) 24.2% (6,281,681) 57.7% Total Employee Benefits 3,259,074 3,591,912 (332,837) -10.2% 9,176,671 10,225,518 (1,048,847) -11.4% 12,312,215 83.1% Unfunded Liability Costs Pension 16,029 15,788 241 1.5% 45,525 45,171 354 0.8% 59,784 75.6% OPEB 330,000 580,000 (250,000) -75.8% 990,000 1,740,000 (750,000) -75.8% 1,320,000 131.8% Total Unfunded Liability Costs 346,029 595,788 (249,759) -72.2% 1,035,525 1,785,171 (749,646) -72.4% 1,379,784 129.4% Purchased Property Services Repairs & Maintenance 871,455 833,987 37,468 4.3% 3,246,315 2,877,607 368,708 11.4% 4,117,770 69.9% Hauling & Disposal 341,675 183,100 158,575 46.4% 1,025,025 545,057 479,968 46.8% 1,366,700 39.9% Security 157,400 131,693 25,707 16.3% 472,200 402,572 69,628 14.7% 629,600 63.9% Rentals 60,100 68,704 (8,604) -14.3% 180,300 220,026 (39,726) -22.0% 241,500 91.1% Cleaning 123,720 135,939 (12,219) -9.9% 371,160 388,848 (17,688) -4.8% 494,880 78.6% Construction - - - 750 (750) - Total Purchased Property Services 1,554,350 1,353,423 200,927 12.9% 5,295,000 4,434,860 860,140 16.2% 6,850,450 64.7% (Continued on page 9) 8 1 P a g e June 1, 2023 Regular Board Meeting Agenda Packet - Page 34 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued) QTD YTD QTD QTD QTD Variance YTD YTD YTD Variance Annual Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget % Used Purchased Professional, Technical & Other Services Professional Services Technical Services Other Purchased Services Total Purchased Professional, Technical & Other 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 294,580 315,463 (20,884) -7.1% 933,739 539,419 394,319 42.2% 1,218,318 44.3% 969,992 362,831 607,161 62.6% 2,965,202 931,417 2,033,786 68.6% 3,914,195 23.8% 816,898 384,877 432,022 52.9% 2,053,747 1,632,129 421,618 20.5% 2,761,245 59.1% 2,081,470 1,063,171 1,018,299 48.9% 5,952,688 3,102,965 2,849,723 47.9% 7,893,758 39.3% 1,527,100 2,180,838 (653,738) -42.8% 4,581,300 5,795,215 (1,213,915) -26.5% 6,108,400 94.9% 586,500 536,765 49,735 8.5% 1,759,500 1,673,476 86,024 4.9% 2,346,000 71.3% 929,150 640,572 288,579 31.1% 3,022,451 1,816,148 1,206,303 39.9% 3,951,602 46.0% 3,042,750 3,358,175 (315,424) -10.4% 9,363,251 9,284,839 78,413 0.8% 12,406,002 74.8% 158,246 52,760 105,487 66.7% 442,669 540,422 (97,753) -22.1% 578,615 93.4% 173,894 92,743 81,151 46.7% 495,581 273,626 221,955 44.8% 663,125 41.3% 46,563 35,073 11,490 24.7% 139,688 130,848 8,839 6.3% 186,250 70.3% 378,702 180,576 198,127 52.3% 1,077,937 944,896 133,041 12.3% 1,427,990 66.2% $ 22,042,108 $ 21,211,222 $ 830,885 3.80/. $ 64,414,123 $ 61,347,980 $ 3,066,143 4.8% $ 85,019,046 72.20/. June 1, 2023 Regular Board Meeting Agenda Packet - Page 35 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Summary (by Department) Year -to -Date Expenses by Department $35,000,000 $30,000,000 $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 June 1, 2023 Regular Board Meeting Agenda Packet - Page 36 of 165 QTD YTD QTD QTD QTD Variance YTD YTD YTD Variance Annual Category Budget Actual Variance ($] (%] Budget Actual Variance ($) (%) Budget % Used Department Executive Governance $ 1,007,029 $ 534,872 $ 472,157 46.9% $ 2,217,965 $ 1,501,835 $ 716,130 32.3% $ 2,778,212 54.1% Administration 5,251,758 4,871,629 380,128 7.2% 15,250,929 14,560,190 690,739 4.5% 20,283,342 71.8% Engineering and Technical Services 4,028,845 3,797,981 230,864 5.7% 11,517,953 11,211,598 306,356 2.7% 15,208,366 73.7% Operations 11,356,072 11,751,413 (395,342) -3.5% 34,144,881 33,202,303 942,577 2.8% 45,051,909 73.7% Recycled Water Program 398,405 255,326 143,078 35.9% 1,282,395 872,054 410,341 32.0% 1,697,217 51.4% Total Expenses $ 22,042,108 $ 21,211,222 $ 830,885 3.8% $ 64,414,123 $ 61,347,980 $ 3,066,143 4.8% $ 85,019,046 72.2% Year -to -Date Expenses by Department $35,000,000 $30,000,000 $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 June 1, 2023 Regular Board Meeting Agenda Packet - Page 36 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Detail (by Division) 111Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 37 of 165 QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Organizational Unit Budget Actual Variance ($) [%) Budget Actual Variance [$) M Budget [%) Executive Governance Office of the General Manager $ 308,514 $ 262,055 $ 46,460 15.1% $ 824,977 $ 749,972 $ 75,004 9.1% $ 1,070,246 70.1% Office of the Secretary of the District 569,688 225,185 344,503 60.5% 1,040,520 606,217 434,304 41.7% 1,242,671 48.8% Board of Directors 128,827 47,632 81,195 63.0% 352,468 145,646 206,821 58.7°/% 465,295 31.3% Administration Office of the Director of Finance and Administration 178,600 139,220 39,380 22.0% 488,646 408,636 80,010 16.4% 649,271 62.9% Finance Division 634,096 463,533 170,564 26.9% 1,549,280 1,386,316 162,964 10.5°/% 2,008,642 69.0% Human Resources Division 1,814,017 1,868,946 (54,928) -3.0% 5,373,573 5,558,857 (185,285) -3.4% 7,131,543 77.9% Purchasing Division 489,554 433,132 56,422 11.5% 1,412,757 1,274,752 138,005 9.8% 1,861,104 68.5% Risk Management Program 325,999 257,317 68,681 21.1% 960,523 916,361 44,162 4.6% 1,274,845 71.9% Public Info/Comm. Services & Intergov Relations Division 504,765 606,737 (101,972) -20.2% 1,509,630 1,417,457 92,173 6.1% 2,155,358 65.8% Information Technology Division 1,304,726 1,102,745 201,981 15.5% 3,956,521 3,597,811 358,710 9.1% 5,202,579 69.2% Engineering & Technical Services Office of the Director of Engineering & Technical Services 245,175 131,639 113,536 46.3% 672,831 473,519 199,312 29.6% 890,095 53.2% Planning & Developmental Services 1,670,934 1,574,013 96,922 5.8% 4,771,631 4,556,323 215,308 4.5% 6,241,012 73.0% Capital Projects Division (219,643) (73,244) (146,399) 66.7% (659,893) 1,523 (661,415) 100.2% (831,774) -0.2% Environmental & Regulatory Compliance 2,332,379 2,165,574 166,805 7.2% 6,733,384 6,180,233 553,151 8.2% 8,909,033 69.4% Operations Office of the Director of Operations 322,571 121,652 200,919 62.3% 929,980 557,999 371,980 40.0% 1,232,151 45.3% Collection System Operations Division 3,533,877 3,512,345 21,532 0.6% 10,208,226 9,925,887 282,339 2.8% 13,480,048 73.6% Treatment Plant Operations Division 3,656,755 4,474,544 (817,789) -22.4% 11,174,628 12,441,097 (1,266,468) -11.3% 14,871,590 83.7% Treatment Plant Maintenance Division 3,842,868 3,642,872 199,996 5.2% 11,832,047 10,277,320 1,554,726 13.1% 15,468,121 66.4% Recycled Water Recycled Water - General 46,705 24,967 21,737 46.5% 140,114 75,768 64,345 45.9% 186,818 40.6% Treatment Plant 200,850 144,264 56,586 28.2% 602,550 490,046 112,504 18.7°/% 803,400 61.0% Distribution System 96,450 68,859 27,591 28.6% 289,350 196,125 93,225 32.2% 385,800 50.8% Residential Fill Station 29,450 17,235 12,215 41.5% 175,532 109,961 65,570 37.4% 221,399 49.7% Satellite Water Facility 24,950 - 24,950 100.0% 74,850 154 74,696 99.8°/% 99,800 0.2% Total Expenses $ 22,042,108 $ 21,211,222 $ 830,885 3.8% $ 64,414,123 $ 61,347,980 $ 3,066,143 4.8% $ 85,019,046 72.2% 111Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 37 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 4 - Sewer Construction Fund Revenues by Source - Summary Year -to -Date Revenues by Source $40,000,000 $30,000,000 $20,000,000 $10,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■ YTD ■ YTD Budget Actual 121Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 38 of 165 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) ("/o) Budget (%) Sewer Service Charges $ 118,873 $ 20,361 $ (98,512) -82.9% $ 36,773,166 $ 37,039,261 $ 266,095 0.7% $ 65,832,492 56.3% Other Capital Revenues 1,308,092 1,599,659 291,567 22.3% 22,551,821 26,856,343 4,304,522 19.1% 62,955,078 42.7% Total Revenue $ 1,426,964 $ 1,620,019 $ 193,055 13.5% $ 59,324,987 $ 63,895,605 $ 4,570,618 7.7% $ 128,787,570 49.6% Year -to -Date Revenues by Source $40,000,000 $30,000,000 $20,000,000 $10,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■ YTD ■ YTD Budget Actual 121Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 38 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 4 - Sewer Construction Fund Revenues by Source - Detail 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,042,010 519,789 (522,220) -50.1% 3,567,090 47,563 30,449 (17,114) -36.0% 99,551 Annual 461 461 57,000 57,000 QTD - - 7,932,078 YTD 100,000 Budget (100,000) QTD QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) Sewer Service Charges (SSC) 64,525 2,014 (62,511) -96.9% 127,478 242,159 114,680 90.0% 249,000 97.3% Over -the -Counter $ 136,048 $ 17,523 $ (118,525) -87.1% $ 119,500 $ 138,659 $ 19,159 16.0% $ 119,500 116.0% County Allocated - - - 35,516,954 35,728,227 211,273 0.6% 64,576,280 55.3% Direct Billed 3,758 3,758 1,177,919 1,174,600 (3,319) -0.3% 1,177,919 99.7% Prior Year Adjustment (17,175) (921) 16,255 -94.6% (41,207) (2,224) 38,983 -94.6% (41,207) 5.4% 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,042,010 519,789 (522,220) -50.1% 3,567,090 47,563 30,449 (17,114) -36.0% 99,551 - 461 461 57,000 57,000 - - - 7,932,078 4,200,000 100,000 - (100,000) -100.0% 300,000 23,693 918,479 894,786 3776.5% 119,375 - - - 7,500,000 14,000,000 2,638 16,170 13,532 512.9% 6,712 27,413 12,827 (14,586) -53.2% 73,865 64,525 2,014 (62,511) -96.9% 127,478 5,953,667 2,386,578 66.9% 4,445,000 133.9% 373,463 273,912 275.1% 134,000 278.7% 36,207 (20,793) -36.5% 57,000 63.5% 4,088,317 (111,683) -2.7% 7,932,078 51.5% 558,134 258,134 86.0% 400,000 139.5% 1,583,611 1,464,237 1226.6% 140,000 1131.2% - - 7,500,000 0.0% 13,825,787 (174,213) -1.2% 42,000,000 32.9% 16,489 9,777 145.7% 8,000 206.1% 60,248 (13,617) -18.4% 89,000 67.7% 242,159 114,680 90.0% 249,000 97.3% 250 1,636 1,386 554.4% 750 3,742 2,992 398.9% 1,000 374.2% - 24,131 24,131 - 59,500 59,500 - - 73,703 73,703 - 55,019 55,019 - $ 1,426,964 $ 1,620,019 $ 193,055 13.5% $ 59,324,987 $ 63,895,605 $ 4,570,618 7.7% $ 128,787,570 49.6% June 1, 2023 Regular Board Meeting Agenda Packet - Page 39 of 165 _,&&OCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 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 141 Page A B C (A -B) D E F (D+E) G (C+D+E) H I (G -H) Cumulative Cumulative Total Project FY 2022-2023 FY 2022-23 FY 2022-23 FY 2022-23 FY 2022-23 FY 2022-23 Prior Year Prior Year I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2022.23 Budget Adjustments Budget Expenditures Expenditures Budget $ 75,574,241 $ 57,442,049 $ 18,132,192 $ 36,850,000 $ 600,000 $ 37,450,000 $ 55,582,192 $ 13,049,223 $ 42,532,969 96,390,332 54,872,388 41,517,944 39,981,000 300,000 40,281,000 81,798,944 18,095,420 63,703,524 19,896,459 16,655,259 3,241,200 3,795,000 - 3,795,000 7,037,349 1,984,279 5,053,070 32,854,000 28,737,307 4,116,693 8,715,000 8,715,000 12,831,693 5,061,424 7,770,269 - - - 1,635,000 (900,000) 735,000 735,000 - 735,000 $ 224,715,032 $ 157,707,003 $ 67,008,029 $ 90,976,000 $ - $ 90,976,000 $ 157,985,178 $ 38,190,346 $ 119,794,832 Capital Improvement Budget Quarterly Results by Program $901000,000 $80,000,000 $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 ' $10,000,000 Collection System Treatment Plant (CS) (TP) General Recycled Water CIB Contingency Improvements (RW) (GI) Program ■ Approved Expenditures ■ Actual Expenditures June 1, 2023 Regular Board Meeting Agenda Packet - Page 40 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project) A B C (A -B) D E F D+E G C+D+E H 1 G - Cumulative Cumulative Total Project FY 2022-2023 FY 2022-23 FY 2022-23 FY 2022-23 FY 2022-23 FY 2022-23 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining -Rudgets Actuals FY 2022-23 Budge Adjustments Budget Expenditure Expenditures Budget TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 $ 1,460,000 $ 325,348 $ 1,134,652 $ 3,740,000 $ - $ 3,740,000 $ 4,874,652 $ 373,083 $ 4,501,569 8419 Collection System Planning LT 1,585,000 1,409,671 175,329 200,000 - 200,000 375,329 94,381 280,948 8436 Moraga/ Crossroads PS Project 35,451,000 34,219,528 1,231,472 - - - 1,231,472 924,338 307,134 8442 PS Equipment Piping Replacement PH2 564,000 428,844 135,156 206,000 - 206,000 341,156 28,166 312,990 8443 LG Diameter Pipe line Inspection 1,795,000 253,940 1,541,060 - - - 1,541,060 220,237 1,320,823 8444 Force Main Inspection Program 1,125,000 18,132 1,106,868 - - - 1,106,868 9,604 1,097,264 8447 Pump Station Security Improvement 357,000 302 356,698 82,000 - 82,000 438,698 - 438,698 8448 Manhole Modifications 2,007,925 1,435,083 572,842 400,000 - 400,000 972,842 140,970 831,872 *8449 Collection System Modeling Support 543,000 177,141 365,859 - - - 365,859 37,941 327,918 8450 Development Sewerage Support 4,032,316 4,019,314 13,002 927,000 - 927,000 940,002 660,071 279,931 8457 Pump Station Upgrades - Ph. 2 5,950,000 3,359,231 2,590,769 11,900,000 (200,000) 11,700,000 14,290,769 2,408,558 11,882,211 8463 No. Orinda Sewer Renov. PH. 8 4,304,000 3,925,644 378,356 - - - 378,356 406,456 (28,100) 8464 Martinez Sewer Renov. Ph. 7 2,500,000 556,689 1,943,311 2,500,000 (419,000) 2,081,000 4,024,311 684,699 3,339,612 8465 WC Sewer Renov. Ph. 15 5,400,000 4,121,806 1,278,194 - - - 1,278,194 542,172 736,022 8466 Danville Sewer Ren. Ph.4 1,500,000 1,576,565 (76,565) 3,702,000 - 3,702,000 3,625,435 3,295,790 329,645 100005 Cured -In -Place Pipe Contract FY 2020-25 850,000 - 850,000 250,000 - 250,000 1,100,000 - 1,100,000 100006 Contractual Assessment District Proj Financing 832,940 - 832,940 100,000 (252,894) (152,894) 680,046 35,857 644,189 100007 Large Diameter Priping Renovation Program 2,000,000 302 1,999,698 - - - 1,999,698 5,293 1,994,405 100017 SR Pump Station Electrical Upgrades 700,000 129,110 570,890 1,213,000 - 1,213,000 1,783,890 371,019 1,412,871 *100021 Cordel Drive West CAD 167,060 144,620 22,440 - - - 22,440 - 22,440 100023 Walnut Creek Sewer Renovation Ph. 16 500,000 593,164 (93,164) - 5,879,000 5,879,000 5,785,836 1,842,976 3,942,860 100024 South Orinda Sewer Renovation Ph. 9 500,000 451,521 48,479 - - - 48,479 263,209 (214,730) 100025 Lafayette Sewer Renov. Ph. 15 500,000 228,951 271,049 - - - 271,049 234,838 36,211 100028 Collection System Master Plan 2021 Update 750,000 54,534 695,466 850,000 - 850,000 1,545,466 117,155 1,428,311 100037 Orinda Moraga PS Architectual Improvements 200,000 12,609 187,391 1,250,000 - 1,250,000 1,437,391 20,355 1,417,036 **100038 San Pablo Watershed Improvements - - - - 200,000 200,000 200,000 41,634 158,366 100039 Collection System Sewere Renovation Ph. 2 - - - 9,410,000 (6,460,000) 2,950,000 2,950,000 56,960 2,893,040 **100041 Buchanan Lift Station Replacements & Improvemei - - - - 200,000 200,000 200,000 53,295 146,705 **100042 Pump Station Upgrades, Phase 2B - - - - 200,000 200,000 200,000 66,559 133,441 100044 Collection System Modeling Support FY 22+ - - - 120,000 - 120,000 120,000 - 120,000 **100049 Dowtown Walnut Creek Sewer Renovations, Ph. 1 - - - - 500,000 500,000 500,000 64,140 435,860 **100050 Caltrans A -Line Relocation - - - - 200,000 200,000 200,000 1,458 198,542 **100052 No. Orinda Sewer Renovations, Ph. 9 - - - - 500,000 500,000 500,000 48,009 451,991 **100053 Houston Ct. Area CAD - - - - 252,894 252,894 252,894 - 252,894 Rounding Total CS Program $ 75,574,241 $ 57,442,049 $ 18,132,192 $ 36,850,000 $ 600,000 $ 37,450,000 $ 55,582,192 $ 13,049,223 $ 42,532,969 * Projects open but not in CIE for 22/23 ** Not in 22/23 Budget. New projects. Funds transferred from other projects or Contingency 151Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 41 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C (A -B) D E F D+E G C+D+E H I G - Cumulative Cumulative Total Project FY 2022-2023 FY 2022-23 FY 2022-23 FY 2022-23 FY 2022-23 FY 2022-23 Prior Year Prior Year I Carryforward to Adopted Budget I Adjusted Approved 1 Actual Remaining Budgets Actuals FY 2022-23 Bud et Adjustments Budget Expenditures Expenditures Budget TYPE TP Treatment Plant 7315 Applied Research and Innovations $ 1,657,274 $ 1,299,075 $ 358,199 $ 300,000 $ - $ 300,000 $ 658,199 $ 211,815 $ 446,384 7328 Influent Pump Electrical improvements 8,160,000 8,665,855 (505,855) 1,426,000 - 1,426,000 920,145 1,703,592 (783,447) 7341 WC/Grayson Creek Levee Rehab 1,050,000 630,015 419,985 1,500,000 - 1,500,000 1,919,985 70,881 1,849,104 7348 Solids Handling Facility Improvements 34,518,687 18,436,325 16,082,362 5,000,000 - 5,000,000 21,082,362 3,613,001 17,469,361 7349 Aeration & Energy Upgrade 5,350,000 4,462,963 887,037 500,000 - 500,000 1,387,037 62,950 1,324,087 7357 Plant Wide Instrumentation Upgrade 1,421,000 110,484 1,310,516 - - - 1,310,516 46,121 1,264,395 7363 Treatment Plant Planning 2,100,000 1,692,414 407,586 200,000 - 200,000 607,586 154,335 453,251 7364 TP Safety Enhancement Ph. 5 1,180,000 1,204,582 (24,582) - - - (24,582) 16,016 (40,598) 7369 Piping Renovation - Phase 10 5,450,000 1,891,406 3,558,594 - - - 3,558,594 679,408 2,879,186 7370 Annual Infrastructure Replacement 3,605,000 1,991,444 1,613,556 1,000,000 (200,000) 800,000 2,413,556 460,103 1,953,453 7371 Condition Assessment of Buried Pipelines 500,000 - 500,000 - - - 500,000 - 500,000 7373 Fire Protection System Ph. 3 1,100,000 524,564 575,436 - - - 575,436 451,634 123,802 7375 Contractor Staging Improvements 5,200,000 4,475,037 724,963 - 300,000 300,000 1,024,963 1,125,875 (100,912) 100001 UPCAA Urgent Projects FY 2020-25 1,200,000 176,995 1,023,005 600,000 - 600,000 1,623,005 49,402 1,573,603 100008 Laboratory Roof & Seismic upgrades 950,000 96,086 853,914 500,000 - 500,000 1,353,914 1,183,665 170,249 100009 Hearth Replacement 500,000 265,797 234,203 - - - 234,203 25,206 208,997 100010 Air Condiditioning & Lighting Renovation 1,250,000 646 1,249,354 - - - 1,249,354 145,390 1,103,964 100011 Plant Electrical Replacement & Rehabilitation 408,371 211,278 197,093 400,000 - 400,000 597,093 41,782 555,311 100012 UV Disinfection Replacement 2,500,000 1,239,101 1,260,899 3,500,000 - 3,500,000 4,760,899 362,528 4,398,371 *100013 UV Hydraulic Improvements 480,000 6,603 473,397 - - - 473,397 - 473,397 100014 MRC Building Modifications 750,000 30,628 719,372 750,000 - 750,000 1,469,372 155,061 1,314,311 100015 Electric Blower Improvements 9,150,000 5,896,057 3,253,943 4,245,000 - 4,245,000 7,498,943 3,803,799 3,695,144 100018 Outfall Monitoring Improvements 610,000 218,980 391,020 - - - 391,020 631,219 (240,199) 100019 Aeration Basins Diffuer Replacement and Seismic t 2,300,000 832,698 1,467,302 7,500,000 (300,000) 7,200,000 8,667,302 1,189,563 7,477,739 100022 Wet Weather Basin Improvements 700,000 300,667 399,333 600,000 - 600,000 999,333 84,662 914,671 100030 Solids Handling Facility Improvements Ph.2 3,600,000 191,043 3,408,957 3,100,000 - 3,100,000 6,508,957 1,117,178 5,391,779 100032 Steam Renovations, Ph. 1 500,000 21,645 478,355 4,500,000 - 4,500,000 4,978,355 494,160 4,484,195 100034 TP Safety Enhancemetns Program 200,000 - 200,000 300,000 - 300,000 500,000 - 500,000 100040 Electrical Infrasturcture Sub 90 - - - 500,000 - 500,000 500,000 - 500,000 100045 Fire Protection System PhA - - - 860,000 - 860,000 860,000 - 860,000 100046 Control System Upgrades - - - 200,000 - 200,000 200,000 16,788 183,212 100047 Secondary Clarifier Improvments - Phase 1 - - - 2,000,000 - 2,000,000 2,000,000 - 2,000,000 100048 Warehouse Seismic Upgrades - - - 500,000 - 500,000 500,000 - 500,000 **100051 RAS Piping Renovations - - - - 300,000 300,000 300,000 199,286 100,714 **100054 Aeration Unit 1 Steam Turbine Overhaul - - - - 200,000 200,000 200,000 - 200,000 Rounding Total TP Program $ 96,390,332 $ 54,872,388 $ 41,517,944 $ 39,981,000 $ 300,000 $ 40,281,000 $ 81,798,944 $ 18,095,420 $ 63,703,524 * Projects open but not in CIB for F22/23 ** Not in 22/23 Budget New projects. Funds transferred from other projects or Contingency 161Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 42 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C (A -B) D E F D+E G C+D+E H I G -H Cumulative Cumulative Total Project FY 2022-2023 FY 2022-23 FY 2022-23 FY 2022-23 FY 2022-23 FY 2022-23 Prior Year Prior Year I Carryforward to Adopted Budget I Adjusted Approved 1 Actual Remaining Budgets Actuals FY 2022-23 Budge Adjustments Budget Expenditures Expenditures Budget TYPE GI General Improvements 8230 Capital Legal Services $ 228,665 $ 226,234 $ 2,431 $ 20,000 $ - $ 20,000 $ 22,431 $ 17,992 $ 4,439 8240 IT Development 4,488,794 4,002,443 486,351 500,000 - 500,000 986,351 735,582 250,769 8250 ERP Replacement 5,380,000 5,326,990 53,010 - - - 53,010 - 53,010 8251 Capital improvement program & Budget Improvers 390,000 163,856 226,144 200,000 - 200,000 426,144 191,398 234,746 8252 POB E.V. Charging Station 490,000 21,749 468,251 150,000 - 150,000 618,251 5,390 612,861 8253 COVID-19 Response 275,000 113,510 161,490 - - - 161,490 71,930 89,560 8516 District Equipment Acquisition 1,476,000 1,271,897 204,103 250,000 - 250,000 454,103 205,416 248,687 8517 Vehicle Replacement Program 4,718,000 4,373,000 345,000 900,000 - 900,000 1,245,000 79,693 1,165,307 100003 Property Repairs & Improvements 450,000 276,634 173,366 700,000 - 700,000 873,366 124,739 748,627 100004 HOB Exterior Repairs 400,000 291,102 108,898 - - - 108,898 - 108,898 100027 Furnishings Replacement 100,000 - 100,000 - - - 100,000 - 100,000 100029 Solar Project on Lagiss 600,000 516,178 83,822 - - - 83,822 1,562 82,260 100031 Community Dev. System Replacement 200,000 24,949 175,051 400,000 - 400,000 575,051 220,226 354,825 100033 Security Improvements FY 2021-25 200,000 45,266 154,734 100,000 - 100,000 254,734 73,611 181,123 100035 Technology Strategic Plan 500,000 302 499,698 500,000 - 500,000 999,698 240,050 759,648 100043 Easement Acquisition FY 2022-31 - - - 75,000 - 75,000 75,000 5,589 69,411 9999 Capital Project Clearing (Accounting Use Only) - 1,149 (1,149) - - - - 11,101 (11,101) Rounding Total GI Program $ 19,896,459 $ 16,655,259 $ 3,241,200 $ 3,795,000 $ $ 3,795,000 $ 7,037,349 $ 1,984,279 $ 5,053,070 TYPE RW Recycled Water 7361 Filter Plant & Clearwell Improvements Ph. 1A $ 30,989,000 $ 28,387,070 $ 2,601,930 $ 7,600,000 $ - $ 7,600,000 $ 10,201,930 $ 5,010,358 $ 5,191,572 7366 ReW Distribution System Renov. Program 715,000 196,187 518,813 215,000 - 215,000 733,813 15,718 718,095 7368 Water Exchange Project 400,000 142,137 257,863 - - - 257,863 - 257,863 100002 Filter Plant & Clearwell Improvements Ph. 1B 650,000 11,913 638,087 800,000 - 800,000 1,438,087 1,759 1,436,328 100036 Zone 1 Recycled Water 2021 100,000 - 100,000 100,000 - 100,000 200,000 33,589 166,411 Rounding Total RW Program $ 32,854,000 $ 28,737,307 $ 4,116,693 $ 8,715,000 $ $ 8,715,000 $ 12,831,693 $ 5,061,424 $ 7,770,269 9990 CONTINGENCY -ALL PROGRAMS $ $ $ $ 1,635,000 $ (900,000) $ 735,000 $ 735,000 $ 735,000 GRAND TOTAL $ 224,715,032 $ 157,707,003 $ 67,008,029 $ 90,976,000 $ $ 90,976,000 $ 157,985,178 $ 38,190,346 $ 119,794,832 171Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 43 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 5 - Self Insurance Fund Revenues by Source 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 181Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 44 of 165 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,662,101 $ 1,662,101 $ 0.0% $ 1,662,101 100.0% Insurance Recoveries (HHW) - - 25,000 0.0% Investment Income 2,350 67,203 64,853 2759.7% 7,050 146,687 139,637 1980.7% 47,400 309.5% Total Revenues $ 2,350 $ 67,203 $ 64,853 2759.7% $ 1,669,151 $ 1,808,788 $ 139,637 8.4% $ 1,734,501 104.3% 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 181Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 44 of 165 MICENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section S - Self Insurance Fund Expenses by Type 191 Page Year -to -Date Expenses by Type $1,400,000 •�� $1,200,000 i $1,000,000 • .��' $800,000 $600,000 $400,000 '•� $200,000 Professional Services Technical Services Insurance & Risk Management Expense Category ■YTD ■ YTD Budget Actual June 1, 2023 Regular Board Meeting Agenda Packet - Page 45 of 165 Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Variance Annual Realized Category QTD Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) Professional Services $ 93,750 $ 62,664 $ 31,086 33.2% $ 281,250 $ 316,086 $ (34,836) -12.4% $ 375,000 84.3% Technical Services 15,000 21,826 (6,826) -45.5% 45,000 29,444 15,556 34.6% 60,000 49.1% Insurance & Risk Management 433,750 25,720 408,030 94.1% 1,301,250 1,286,632 14,618 1.1% 1,735,000 74.2% Total Expenses $ S42,SOO $ 110,210 $ 432,290 79.7% $ 1,627,500 $ 1,632,162 $ (4,662) -0.3% $ 2,170,000 75.2% 191 Page Year -to -Date Expenses by Type $1,400,000 •�� $1,200,000 i $1,000,000 • .��' $800,000 $600,000 $400,000 '•� $200,000 Professional Services Technical Services Insurance & Risk Management Expense Category ■YTD ■ YTD Budget Actual June 1, 2023 Regular Board Meeting Agenda Packet - Page 45 of 165 &O10ENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 6 - Debt Service Fund Revenues by Source Year -to -Date Revenues by Source $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Tax Revenue Investment Income ■ YTD ■ YTD Budget Actual 201 Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 46 of 165 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Estimate (%) Tax Revenue $ $ $ $ 7,288,557 $ 7,380,966 $ 92,408 1.3% $ 13,251,922 55.7% Investment Income - - Total Revenues $ $ $ $ 7,288,557 $ 7,380,966 $ 92,408 1.30/. $ 13,251,922 55.7% Year -to -Date Revenues by Source $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Tax Revenue Investment Income ■ YTD ■ YTD Budget Actual 201 Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 46 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 6 - Debt Service Fund Expenses by Type Year -to -Date Expenses by Type $11,000,000 $9,000,000 $7,000,000 — $5,000,000 — $3,000,000 $1,000,000 — $(1,000,000) Professional Services Principal Payment Expense Interest Expense ■ YTD ■ YTD Budget Actual 211Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 47 of 165 Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Variance Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Estimate (%) Professional Services $ 625 $ $ 625 100.0% $ 1,875 $ 5,800 $ (3,925) -209.3% $ 2,500 232.0% Principal Payment Expense - - 10,750,000 10,750,000 - 0.0% 10,750,000 100.0% Interest Expense 1,118,017 1,117,999 18 0.0% 2,499,422 1,578,468 920,954 36.8% 2,499,422 158.3% Total Expenses $ 1,118,642 $ 1,117,999 $ 643 0.1% $ 13,251,297 $ 12,334,268 $ 917,029 6.9% $ 13,251,922 93.1% Year -to -Date Expenses by Type $11,000,000 $9,000,000 $7,000,000 — $5,000,000 — $3,000,000 $1,000,000 — $(1,000,000) Professional Services Principal Payment Expense Interest Expense ■ YTD ■ YTD Budget Actual 211Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 47 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 7 - Quarterly Investment Portfolios Operating & Maintenance Fund Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Reference! (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of March 2023 was 2.83%. (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.173%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut-off for month-end reporting by Contra Costa County. (4) The market value of the portfolio on March 31, 2023 was $24,607,012. 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. 221Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 48 of 165 QTD YTD Purchase Maturity Daysto Annual Cash BOQ Purchase EOQ EOQ % of Investment 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) $ 16,900,000 $ 27,900,000 $ (11,000,000) $ 16,900,000 $ 16,699,283 67.87% $ 143,632 $ 290,606 RE21 FHLB US Fed Agency 5/19/2022 5/17/23 47 2.174% 1,468,086 1,500,000 - 1,500,000 1,491,675 6.02% 7,912 24,089 RE22 UST Notes US Treasury 5/19/2022 4/30/24 396 2.661% 1,497,366 1,500,000 - 1,500,000 1,468,554 6.02% 334 1,014 RE23 FHLB DISC US Agency 12/27/2022 6/23/23 84 4.783% 4,886,031 5,000,000 - 5,000,000 4,947,500 20.08% 57,626 60,826 RE24 FHLB DISC US Agency 12/27/2022 3/15/23 0 4.525% 3,961,693 4,000,000 (4,000,000) 0.00% 35,884 38,339 (3) $ 28,713,176 $ 39,900,000 $ (15,000,000) $ 24,900,000 $ 24,607,012 100.00% 245,388 414,874 (2) (4) (5) 28,165 38,852 $ 273,553 $ 453,726 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Reference! (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of March 2023 was 2.83%. (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.173%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut-off for month-end reporting by Contra Costa County. (4) The market value of the portfolio on March 31, 2023 was $24,607,012. 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. 221Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 48 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 7 - Quarterly Investment Portfolios Sewer Construction Fund Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date QTD YTD Investment Investment Income Income 160,601 $ 381,234 784 Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio 519 State of Calif. LAW n/a n/a n/a (1) $ 23,500,000 $ 28,500,000 $ (5,000,000) $ 23,500,000 $ 23,220,896 22.38% 961 US T Bill US Treasury 1/21/2022 1/15/2025 656 1.26% 2,490,505 2,500,000 - 2,500,000 2,368,175 2.38% 963 FHLB US Fed Agency 5/19/2022 5/17/2023 47 2.17% 12,723,414 13,000,000 - 13,000,000 12,927,850 12.38% 964 UST Notes US Treasury 5/19/2022 4/30/2024 396 2.66% 2,495,610 2,500,000 - 2,500,000 2,447,590 2.38% 965 FHLB US Fed Agency 8/12/2022 8/11/2023 133 3.28% 4,840,244 5,000,000 - 5,000,000 4,915,750 4.76% 966 US T Bill US Treasury 11/23/2022 2/21/2023 0 4.20% 12,866,750 13,000,000 (13,000,000) - - 0.00% 967 FHLB Disc US Agency 12/29/2022 3/29/2023 0 4.51% 19,780,000 20,000,000 (20,000,000) - - 0.00% 968 FHLB Disc US Agency 12/29/2022 6/28/2023 89 4.77% 29,306,922 30,000,000 - 30,000,000 29,665,500 28.57% 969 FHLB Disc US Agency 2/27/2023 8/24/2023 146 5.10% 8,293,644 - 8,500,000 8,500,000 8,342,580 8.10% 970 UST Bill US Treasury 3/31/2023 9/28/2023 181 4.87% 19,529,400 20,000,000 20,000,000 19,534,800 19.05% (3) $135.826.489 _L114_500 $ (9.500.0001 $105.000.000 $ 103.423.141 100.00% (2) (4) Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date QTD YTD Investment Investment Income Income 160,601 $ 381,234 784 2,387 68,574 208,773 555 1,690 39,501 101,383 143,952 133,250 262,926 220,000 261,858 356,112 4,919 38,257 - 2,600 943,670 1,445,686 (5) 92,993 108,218 $ 1.036.663 $ 1.553.904 Reference: (1) Annual Yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of March 2023 was 2.83%. (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 3.769%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut- off for month-end reporting by Contra Costa County. (4) The market value of the portfolio on March 31, 2023 was $103,423,141. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values monthly. (5) Amount represents investment 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 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. 231Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 49 of 165 AgOLCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 7 - Quarterly Investment Portfolios Self Insurance Fund QTD YTD Purchase Maturity Daysto Annual Cash BOQ Purchase EOQ EOQ %of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif LAIF ,/a .5n/a (1) $ 10,100,000 $ 10,100,000 $ $ 10,100,000 $ 9,980,045 100.00% $ 65,335 $ 141,520 (3) $ 10,100,000 $ 10,100,000 $ $ 10,100,000 $ 9,980,045 100.00% 65,335 141,520 (2) (4) (5) 2,068 2,068 $ 67,403 $ 143,588 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Reference! (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of March 2023 was 2.83%. (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 2.63%. (4) The market value of the portfolio on March 31, 2023 was $9,980,045. (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(6)(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)]. 241Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 50 of 165 _,&&OCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 O&M Fund Cashflow Forecast $70.0 $60.0 $51.4 $50.0 $40.0 $30.0 $20.0 $10.0 $0.0 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 8 - Financial Performance Metric Charts FY 2022-23 Running Expense Fund Total Cash & Investment Balances (Actuals through Mar 2023) June '22 July August September October November December January February March April May June M Projected Balance* M Actual Balance —Reserve Target at Year End** NOTES: * Projected balances were generated in July 2022 based on budgeted revenues and expenses for FY 2022-23 and applied to the actual balance at June 30, 2022. ** The Reserve Target at Year End is the minimum balance required at June 30, 2023 to comply with the District Policy . 251Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 51 of 165 &O10ENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast $120.0 $100.0 $80.0 $60.0 $40.0 $20.0 $0.0 FY 2022-23 Sewer Construction Fund Total Cash & Investment Balances (Actuals through Mar 2023) June '22 July August September October November December January February March April May June M Projected Balance* =Actual Balance —Reserve Target at Year End** NOTES: * Projected balances were generated in July 2022 based on budgeted revenues and expenses for FY 2022-23 and applied to the actual balance at June 30, 2022. ** The Reserve Target at Year End is the minimum balance required at June 30, 2023 to comply with the District Policy. 261Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 52 of 165 _,&&OCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 8 - Financial Performance Metric Charts Staffing Trends 300 5.8% Vacanc Rate 295 290 14 H 285 w V) 280 275 w cu 270 F265 279 277 w 260 b6d 255 250 3/31/20 3/31/21 3/31/22 3/31/23 Quarter Ended ■ Filled Positions (FTEs) ■ Vacancies (FTEs) 271Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 53 of 165 _,&&OCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated $5,000 $4,500 $4,000 $3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 281Page Historical Quarterly 0&M Cost per Million Gallons Treated $3,163 $3,230 $2,744 $2,090 3/31/20 3/31/21 3/31/22 3/31/23 Quarter Ended June 1, 2023 Regular Board Meeting Agenda Packet - Page 54 of 165 AMILCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 8 - Financial Performance Metric Charts Capital Spending Trend $180 $160 $158.0M $140 $120 0 $100 c $80 $ 116.2M $60 — — $40 — $38.2M — $20 — �� off` St bet bet bet bet a a� {cb i� � a9 ire 1 P Se��e� ��o C�o�efi` Oeee� lap.. �ebto �a p.Q � —Projected (100% spend)* —Actual —Target** NOTES: *Includes unspent rollover appropriations from prior year budget. **90% of total authorized spending (reduced by $28.9M per updated mid -year projections). 291Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 55 of 165 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending March 31, 2023 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed / Renovated 4.0 3.5 ,z 3.0 U L h 2.5 0 2.0 1.8 2.0 1.7 0 1.3 a. 0 1.5 1.0 CU 1.0 0.5 0.5 0.5 0.0 � Ig0 ��'� 1tiI31Iti� 3I31��3 6I30I�'3 Quarter Ending ■ Actual Construction ■ Target ("S -Curve" of 6 mi. FY 22-23 Budget Projection) 301Page June 1, 2023 Regular Board Meeting Agenda Packet - Page 56 of 165