Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
03.b. Receive Quarterly Financial Review for Quarter Ending June 30, 2023.
Page 1 of 38 Item 3.b. F__1_448�411C_S0 September 19, 2023 TO: FINANCE COMMITTEE FROM: CHRISTOPHER THOMAS, ACCOUNTING SUPERVISOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIP LEIBER, DEPUTYGENERAL MANAGER -ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE QUARTERLY FINANCIAL REVIEW FOR QUARTER ENDING JUNE 30, 2023 Attached is the Quarterly Financial Review for the fourth quarter of Fiscal Year (FY) 2022-23 ending June 30, 2023 (unaudited). The Executive Summary (Section 1) of the attached report includes an analysis of financial results and the investment portfolios for the quarter. Strategic Plan Tie -In GOAL FOUR: Governance and Fiscal Responsibility Strategy 3 - Maintain financial stability and sustainability ATTACHMENTS: 1. Quarterly Financial Review for the Quarter Ended June 30, 2023 September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 69 of 113 Quarterly Financial Review CENTRAL SAN _ n ArJ - _ i zi !_.� � jil L _ � , yam-.-- � -\ _� � � ,✓ � � I A l I �'fj� • - i J �' .. r�i i -140-111 Ended June 30, 2023 c.CENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Table of Contents Section1 - Executive Summary................................................................................................................................................................................................1 Section2 - Financial Results Summary by Fund................................................................................................................................................................4 Section 3 - Operations & Maintenance Fund Revenues Revenuesby Source - Summary........................................................................................................................................................................................................5 Revenuesby Source - Detail...............................................................................................................................................................................................................6 Expenses Expensesby Type - Summary............................................................................................................................................................................................................7 Expensesby Type - Detail....................................................................................................................................................................................................................8 Expenses by Organizational Unit - Summary (Department).............................................................................................................................................10 Expenses by Organizational Unit - Detail (Division).............................................................................................................................................................11 Section 4 - Sewer Construction Fund Revenues Revenuesby Source - Summary.....................................................................................................................................................................................................12 Revenuesby Source - Detail............................................................................................................................................................................................................13 Expenses ExpensesSummary (by Program).................................................................................................................................................................................................14 ExpensesDetail (by Project)............................................................................................................................................................................................................15 CapitalBudget Transfers (by Project by Month).....................................................................................................................................................................21 Section 5 - Self Insurance Fund Revenuesby Source.............................................................................................................................................................................................................................22 September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 71 of 113 c.CENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Table of Contents Expensesby Type.................................................................................................................................................................................................................................23 Section 6 - Debt Service Fund Revenuesby Source............................................................................................................................................................................................................................. 24 Expensesby Type................................................................................................................................................................................................................................. 25 Section 7 - Investment Portfolio Reports Operations& Maintenance Fund....................................................................................................................................................................................................26 SewerConstruction Fund..................................................................................................................................................................................................................27 Self -Insurance Fund.............................................................................................................................................................................................................................28 Section 8 -Financial Performance Metrics 0&M Fund Cashflow Forecast......................................................................................................................................................................................................... 29 Sewer Construction Fund Cashflow Forecast........................................................................................................................................................................... 30 StaffingTrends....................................................................................................................................................................................................................................... 31 Costper Million Gallons of Wastewater Treated..................................................................................................................................................................... 32 CapitalSpending Trend...................................................................................................................................................................................................................... 33 Milesof Pipeline Constructed/Renovated.................................................................................................................................................................................. 34 September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 72 of 113 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending June 30, 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 fourth quarter of FY 2022-23 ended June 30, 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 fourth quarter show total expenditures of $81.4 million, which is approximately $3.6 million (4.3%) under the FY 2022-23 budget. This favorable expense variance, largely attributable to lower than projected year-to-date spending in the other purchased services and salaries & wages categories, is slightly larger than the favorable annual budget variance reported in the fourth quarter of the prior year of 3.2%. The largest individual expense category budgetary variance is in the other purchased services category, which is reporting a favorable variance of approximately $3.4 million (43.6%). The largest individual negative budgetary variance was in the unfunded liability costs line item, reporting a negative variance of approximately -$1.0 million attributable to an additional OPEB trust contribution authorized by the Board in the Fall 2022 to be funded by FY 2021-22 budgetary variance which was not contained in the adopted FY 2022-23 budget. In the aggregate, the 0&M Fund is reporting a favorable revenue variance of approximately $2.2 million, which is approximately 3.1% above total estimated year-to-date revenues. The primary drivers for this overall revenue variance are sewer service charges and investment income. Sewer Construction Fund Sewer Construction Fund results for the fourth quarter show total capital project expenditures of $59.1 million, or 64.9% 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 ripple 11Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 73 of 113 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 1 -Executive Summary 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 37.4% of total approved expenditures. The bulk of the FY 2022-23 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. 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, the FY 2023-24 Board -adopted CIB authorized the reduction of $18.5 million in FY 2022-23 carryforward. 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 $114.4 million, in excess of the annual budget amount of $100.8 million by $13.6 million (13.5%). The variance is attributable to several income categories coming in over budget; sewer service charges ($1.3M), facilities capacity fees ($2.3M), secured property tax ($2.5M), investment income ($2.8M), other governmental revenue - Concord ($2.5), and state revolving fund loan proceeds ($1.6M). Most of these variances are attributable to new development in the service area, steady increase in property values, and climbing interest rates. Investment Portfolio Highlights In accordance with Section 53646 of the California Government Code as well as Central San's Investment Policy, the Finance Division is required to submit an investment report to the General Manager and Board of Directors at least quarterly. The investments held by Central San for the quarter ended June 30, 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 2 1 P a g e September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 74 of 113 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 1 -Executive Summary 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 fourth quarter of FY 2022-23, the 0&M Fund investment portfolio has generated $958,187 of income which is above the annual revenue estimate of $262,000 by 265.7%. The Sewer Construction Fund portfolio is reporting $2.9 million of income, also well over the annual revenue estimate of $140,000 by 2000.7%. Both of these significant budgetary variances are attributable to several Fed interest rate hikes in 2022 designed 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 in FY 2022-23. As of June 30, 2023, Central San was holding about 27.5% of its investment portfolio, or $45.6 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 another 25-point rate hike, resulting in a target rate of 5.00 - 5.25% 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 remaining maturities ranging from three (3) to nineteen (19) 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.4% 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 June 30, 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 September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 75 of 113 'AMI'CENTRAL $AN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 2 -Financial Results Summary by Fund YTD Category Budget YTD Actual Annual YTD Budget YTD Variance Annual Realized Variance ($) (%) Budget (%) Fund Revenues 0&M $ 69,762,907 $ 71,921,203 $ 2,158,296 3.1% $ 69,762,907 103.1% Sewer Construction 100,787,570 114,365,349 13,577,779 13.5% 100,787,570 113.5% Self Insurance 1,734,501 1,910,621 176,120 10.2% 1,734,501 110.2% Debt Service 13,251,922 11,905,088 (1,346,834) -10.2% 13,251,922 89.8% Total $ 185,536,900 $ 200,102,261 $ 14,565,361 $ 185,536,900 Fund Expenses 0&M $ 85,019,046 $ 81,395,192 $ 3,623,854 4.3% $ 85,019,046 95.7% Sewer Construction 157,985,178 59,097,479 98,887,699 62.6% 157,985,178 37.4% Self Insurance 2,170,000 1,961,374 208,626 9.6% 2,170,000 90.4% Debt Service 13,251,922 11,905,088 1,346,834 10.2% 13,251,922 89.8% Total $ 258,426,146 $ 154,359,133 $ 104,067,014 $ 258,426,146 $100,000,000 $90,000,000 $80,000,000 $20,000.000 $60,000,000 $5o,000,oao $40,000000 $30,000,000 $2o,000,oao $10,000.o00 Y- o$,td 4 1 P a g e YTD Budget -to -Actual Revenues by Fund Sewer Co�truaion Self Insurance Debt Service Fund •YTD •YTD Budget Actual YTD Budget -to -Actual Expenses by Fund $10,000,000 $120,000,000 $100.00m0,0o0 $eo,000,000 / $w o0o,000 $40,000,000 $20,0oo,000 0&M Sewer ConstruRlon Self Insurance Debt service dEW— F-d •YTD •YTD Budges Actual September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 76 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 3 - Operations & Maintenance Fund Revenues by Source - Summary Level QTD YTD Annual QTD QTD QTD Variance YTD YTD YTD Variance Annual Budget Category Budget Actual Variance ($) % Budget Actual Variance ($) % Budget Realized (%) Operating Revenues: Sewer Service Charge Revenue $ 20,841,756 $ 21,652,264 $ 810,508 3.9% $ 47,162,407 $ 48,447,114 $ 1,284,707 2.7% $ 47,162,407 102.7% Sewage Treatment Cost Sharing 17,653,384 17,700,461 47,077 0.3% 17,600,000 17,649,002 49,002 0.3% 17,600,000 100.3% Miscellaneous Service Charge 1,650,083 1,563,783 (86,300) -5.2% 2,159,000 2,233,077 74,077 3.4% 2,159,000 103.4% Non -Operating Revenues: Permit and Inspection Fees 453,583 443,552 (10,031) -2.2% 1,799,500 1,706,192 (93,308) -5.2% 1,799,500 94.8% Other Non Operating Income 286,924 107,010 (179,914) -62.7% 780,000 927,631 147,631 18.9% 780,000 118.9% Investment Income 63,000 505,556 442,556 702.5% 262,000 958,187 696,187 265.7% 262,000 365.7% Total Revenue $ 40,948,729 $ 41,972,625 $ 1,023,896 2.5% $ 69,762,907 $ 71,921,203 $ 2,158,296 3.1% $ 69,762,907 103.1% Year -to -Date Revenues by Source $50,000,000 $40,000,000 $30,000,000 •'` $10,000,000 Sewer Service Charge Revenue Sewage Treatment Cost Sharing Miscellaneous Service Charge Permit and Inspection Fees Other Non Operating Income Investment Income ■YTD ■ YTD Budget Actual 5 1 P a g e September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 77 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 3 - Operations & Maintenance Fund Revenues by Source - Detail Level Category QTD Budget QTD Actual QTD Variance ($] QTD Variance % YTD Budget YTD Actual YTD Variance ($) YTD Variance % Annual Budget Annual Budget Realized Sewer Service Charge Revenue Sewer Service Charge Counter $ 20,875 $ 47,128 $ 26,253 125.8% $ 83,500 $ 406,927 $ 323,427 387.3% $ 83,500 487.3% Sewer Service Charge County 20,828,079 21,605,571 777,492 3.7% 46,284,619 47,202,828 918,209 2.0% 46,284,619 102.0% Sewer Service Charge Direct - 31,095 31,095 823,081 872,629 49,548 6.0% 823,081 106.0% Sewer Service Charge Prior (7,198) (31,530) (24,332) 338.0% (28,793) (35,270) (6,477) 22.5% (28,793) 122.5% Sewage Treatment Cost Sharing 17,653,384 17,700,461 47,077 0.3% 17,600,000 17,649,002 49,002 0.3% 17,600,000 100.3% Miscellaneous Service Charges Septic Tank Dumping 9,928 16,666 6,738 67.9% 40,000 64,266 24,266 60.7% 40,000 160.7% Sales 909 128 (781) -86.0% 1,000 848 (152) -15.2% 1,000 84.8% Other Service Charges 189,002 240,357 51,355 27.2% 210,000 263,669 53,669 25.6% 210,000 125.6% Recycled Water 192,623 152,417 (40,207) -20.9% 445,000 475,452 30,452 6.8% 445,000 106.8% Satellite Water Recycling - - - - - - Stormwater Program 258,425 200,834 (57,591) -22.3% 415,000 423,247 8,247 2.0% 415,000 102.0% Household Hazardous Waste 999,195 953,382 (45,814) -4.6% 1,048,000 1,005,595 (42,405) -4.0% 1,048,000 96.0% Permit & Inspection Fees Permit/Application Fees 123,199 125,467 2,268 1.8% 480,000 579,642 99,642 20.8% 480,000 120.8% Main Lines Inspection Fees - 9,781 9,781 - 9,781 9,781 - Overtime Inspection 1,170 2,521 1,350 115.3% 9,500 17,544 8,044 84.7% 9,500 184.7% Side Sewer Inspection 289,642 282,115 (7,527) -2.6% 1,160,000 949,910 (210,090) -18.1% 1,160,000 81.9% Industrial Permit Fees 26,779 11,377 (15,402) -57.5% 110,000 96,396 (13,604) -12.4% 110,000 87.6% New Industry Permit Fees 4,457 4,119 (338) -7.6% 15,000 27,722 12,722 84.8% 15,000 184.8% Annexation Charges 8,335 8,172 (163) -2.0% 25,000 25,197 197 0.8% 25,000 100.8% Other Non -Operating Income MVSD P2 Program 15,514 6,588 (8,926) -57.5% 28,000 23,084 (4,916) -17.6% 28,000 82.4% Pretreatment Program Fine S00 - (500) -100.0% 2,000 18,000 16,000 800.0% 2,000 900.0% Lease Rental Income 154,677 66,075 (88,602) -57.3% 740,000 689,097 (50,903) -6.9% 740,000 93.1% Miscellaneous Income 116,233 11,249 (104,984) -90.3% 10,000 137,712 127,712 1277.1% 10,000 1377.1% Right of Way Fees - 3,807 3,807 - 13,596 13,596 - Reimbursements - 19,291 19,291 - 46,142 46,142 - Investment Income 63,000 505,556 442,556 702.5% 262,000 958,187 696,187 265.7% 262,000 365.7% Total Revenues $ 40,948,729 $ 41,972,625 $ 1,023,896 2.S% $ 69,762,907 $ 71,921,203 $ 2,158,296 3.1% $ 69,762,907 103.1% 6 1 P a g e September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 78 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 3 - Operations & Maintenance Fund Expenses by Type - Summary Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance [$) % Budget Actual Variance ($] % Budget Salaries & Wages $ 10,235,797 $ 8,865,043 $ 1,370,755 13.4% $ 42,748,849 $ 40,434,775 $ 2,314,074 5.4% $ 42,748,849 94.6% Employee Benefits 3,135,544 2,963,682 171,862 5.5% 12,312,215 13,189,199 (876,985) -7.1% 12,312,215 107.1% Unfunded Liability Costs 344,259 593,775 (249,516) -72.5% 1,379,784 2,378,946 (999,162) -72.4% 1,379,784 172.4% Purchased Property Services 1,555,450 2,261,081 (705,631) -45.4% 6,850,450 6,695,941 154,509 2.3% 6,850,450 97.7% Other Purchased Services 1,941,070 1,348,053 593,017 30.6% 7,893,758 4,451,018 3,442,740 43.6% 7,893,758 56.4% Supplies & Materials 3,042,750 3,739,771 (697,020) -22.9% 12,406,002 13,024,609 (618,607) -5.0% 12,406,002 105.0% Other Expenses 350,053 275,808 74,244 21.2% 1,427,990 1,220,704 207,286 14.5% 1,427,990 85.5% Total Expenses $ 20,604,923 $ 20,047,212 $ 557,712 2.7% $ 85,019,046 $ 81,39S,192 $ 3,623,854 4.3% $ 85,019,046 95.7% Year -to -Date Expenses by Type $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,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 September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 79 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (°/a) Budget Actual Variance ($) (%) Budget (%) Salaries & Wages FTE Regular Pay $ 9,324,269 $ 8,208,175 $ 1,116,094 12.0% $ 39,048,125 $ 36,605,846 $ 2,442,280 6.3% $ 39,048,125 93.7% Temporary Pay 446,626 344,270 102,357 22.9% 1,818,405 1,484,546 333,859 18.4% 1,818,405 81.6% Premium Pay 777,502 290,539 486,963 62.6% 3,132,718 2,271,637 861,082 27.5% 3,132,718 72.5% Board Fees 16,650 12,000 4,650 27.9% 66,600 50,800 15,800 23.7% 66,600 76.3% Other (329,250) 10,059 (339,309) 103.1% (1,317,000) 21,947 (1,338,947) 101.7% (1,317,000) -1.7% Total Salaries & Wages 10,235,797 8,865,043 1,370,755 13.4% 42,748,849 40,434,775 2,314,074 5.4% 42,748,849 94.6% Employee Benefits Insurance Premiums 2,081,056 1,717,302 363,754 17.5% 8,187,170 7,555,651 631,519 7.7% 8,187,170 92.3% Employer Taxes 152,220 161,647 (9,427) -6.2% 634,803 696,953 (62,150) -9.8% 634,803 109.8% Employer Retirement Contributions 1,901,717 1,807,436 94,281 5.0% 7,760,922 7,772,999 (12,077) -0.2% 7,760,922 100.2% OPEB Contributions 502,750 502,750 - 0.0% 2,011,000 2,011,000 0.0% 2,011,000 100.0% Benefit Adjustments (1,502,200) (1,225,453) (276,746) 18.4% (6,281,681) (4,847,403) (1,434,278) 22.8% (6,281,681) 77.2% Total Employee Benefits 3,135,544 2,963,682 171,862 S.5% 12,312,215 13,189,199 (876,985) -7.1% 12,312,215 107.1% Unfunded Liability Costs Pension 14,259 13,775 484 3.4% 59,784 58,946 838 1.4% 59,784 98.6% OPEB 330,000 580,000 (250,000) -75.8% 1,320,000 2,320,000 (1,000,000) -75.8% 1,320,000 175.8% Total Unfunded Liability Costs 344,2S9 593,77S (249,516) -72.5% 1,379,784 2,378,946 (999,162) -72.4% 1,379,784 172.4% Purchased Property Services Repairs & Maintenance 871,455 1,304,206 (432,751) -49.7% 4,117,770 4,181,813 (64,043) -1.6% 4,117,770 101.6% Hauling & Disposal 341,675 514,179 (172,504) -50.5% 1,366,700 1,059,236 307,464 22.5% 1,366,700 77.5% Security 157,400 182,314 (24,914) -15.8% 629,600 584,886 44,714 7.1% 629,600 92.9% Rentals 61,200 116,454 (55,254) -90.3% 241,500 336,480 (94,980) -39.3% 241,500 139.3% Cleaning 123,720 143,928 (20,208) -16.3% 494,880 532,776 (37,896) -7.7% 494,880 107.7% Construction - - 750 (750) - Total Purchased Property Services 1,555,450 2,261,081 (705,631) -45.4% 6,850,450 6,695,941 154,509 2.3% 6,850,450 97.7% (Continued on page 9) 8 1 P a g e September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 80 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued) Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($] (M Budget (%) Other Purchased Services Professional Services Technical Services Other Purchased Services Total Other Purchased Services Supplies & Materials Utilities & Fuel Chemicals General Supplies Total Supplies & Materials Other Expenses Memberships Training & Meetings Miscellaneous Other Total Other Expenses Total Expenses 9 1 P a g e 284,580 70,146 214,434 75.4% 1,218,318 609,565 608,753 50.0% 1,218,318 50.0% 948,992 710,192 238,800 25.2% 3,914,195 1,641,609 2,272,586 58.1% 3,914,195 41.9% 707,498 567,715 139,783 19.8% 2,761,245 2,199,844 561,401 20.3% 2,761,245 79.7% 1,941,070 1,348,053 593,017 30.6% 7,893,758 4,451,018 3,442,740 43.6% 7,893,758 56.4% 1,527,100 2,378,970 (851,870) -55.8% 6,108,400 8,174,185 (2,065,785) -33.8% 6,108,400 133.8% 586,500 501,565 84,935 14.5% 2,346,000 2,175,040 170,960 7.3% 2,346,000 92.7% 929,150 859,236 69,915 7.5% 3,951,602 2,675,384 1,276,218 32.3% 3,951,602 67.7% 3,042,750 3,739,771 (697,020) -22.9% 12,406,002 13,024,609 (618,607) -5.0% 12,406,002 105.0% 135,946 38,206 97,740 71.9% 578,615 578,628 (13) 0.0% 578,615 100.0% 167,544 161,759 5,784 3.5% 663,125 435,385 227,740 34.3% 663,125 65.7% 46,563 75,842 (29,280) -62.9% 186,250 206,690 (20,440) -11.0% 186,250 111.0% 350,053 275,808 74,244 21.2% 1,427,990 1,220,704 207,286 14.5% 1,427,990 85.5% $ 20,604,923 $ 20,047,212 $ 557,712 2.70/. $ 85,019,046 $ 81,395,192 $ 3,623,854 4.3% $ 85,019,046 95.7% September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 81 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Summary (by Department) Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget Department Executive Governance $ 560,247 $ 514,108 $ 46,139 8.2% $ 2,778,212 $ 2,015,943 $ 762,268 27.4% $ 2,778,212 72.6% Administration 5,032,413 4,567,210 465,203 9.2% 20,283,342 19,127,400 1,155,942 5.7% 20,283,342 94.3% Engineering and Technical Services 3,690,413 3,013,048 677,365 18.4% 15,208,366 14,224,645 983,721 6.5% 15,208,366 93.5% Operations 10,907,028 11,681,571 (774,542) -7.1% 45,051,909 44,883,874 168,035 0.4% 45,051,909 99.6% Recycled Water Program 414,822 271,275 143,547 34.6% 1,697,217 1,143,329 553,888 32.6% 1,697,217 67.4% Total Expenses $ 20,604,923 $ 20,047,212 $ 557,712 2.7% $ 85,019,046 $ 81,395,192 $ 3,623,854 4.3% $ 85,019,046 95.7% 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 Execudve Governance Administration Engineering and Technical op"'d.ns Recycled Water Program Services • YTD • YTD Budget Actual 101Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 82 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit - Detail (by Division) Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Organizational Unit Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) Executive Governance Office of the General Manager $ 245,269 $ 253,271 $ (8,002) -3.3% $ 1,070,246 $ 1,003,244 $ 67,002 6.3% $ 1,070,246 93.7% Office of the Secretary of the District 202,151 192,578 9,573 4.7% 1,242,671 798,794 443,877 35.7% 1,242,671 64.3% Board of Directors 112,827 68,259 44,568 39.5% 465,295 213,905 251,389 54.0% 465,295 46.0% Administration Office of the Director of Finance and Administration 160,625 111,524 49,100 30.6% 649,271 520,160 129,111 19.9% 649,271 80.1% Finance Division 459,362 578,856 (119,493) -26.0% 2,008,642 1,965,172 43,470 2.2% 2,008,642 97.8% Human Resources Division 1,757,971 1,705,394 52,577 3.0% 7,131,543 7,264,251 (132,708) -1.9% 7,131,543 101.9% Purchasing Division 448,348 368,632 79,716 17.8% 1,861,104 1,643,384 217,720 11.7% 1,861,104 88.3% Risk Management Program 314,322 319,634 (5,312) -1.7% 1,274,845 1,235,995 38,850 3.0% 1,274,845 97.0% Public Info/Comm. Services & Intergov Relations Division 645,728 514,181 131,547 20.4% 2,155,358 1,931,638 223,720 10.4% 2,155,358 89.6% Information Technology Division 1,246,058 968,989 277,069 22.2% 5,202,579 4,566,800 635,779 12.2% 5,202,579 87.8% Engineering & Technical Services Office of the Director of Engineering & Technical Services 217,264 28,892 188,372 86.7% 890,095 502,411 387,685 43.6% 890,095 56.4% Planning & Developmental Services 1,469,382 948,860 520,521 35.4% 6,241,012 5,505,183 735,829 11.8% 6,241,012 88.2% Capital Projects Division (171,882) (102,119) (69,763) 40.6% (831,774) (100,596) (731,178) 87.9% (831,774) 12.1% Environmental & Regulatory Compliance 2,175,649 2,137,414 38,234 1.8% 8,909,033 8,317,647 591,385 6.6% 8,909,033 93.4% Operations Office of the Director of Operations 302,171 95,589 206,582 68.4% 1,232,151 653,589 578,562 47.0% 1,232,151 53.0% Collection System Operations Division 3,271,822 3,417,028 (145,206) -4.4% 13,480,048 13,342,915 137,133 1.0% 13,480,048 99.0% Treatment Plant Operations Division 3,696,961 4,228,468 (531,507) -14.4% 14,871,590 16,669,565 (1,797,975) -12.1% 14,871,590 112.1% Treatment Plant Maintenance Division 3,636,074 3,940,486 (304,412) -8.4% 15,468,121 14,217,806 1,250,315 8.1% 15,468,121 91.9% Recycled Water RecycledWater- General 46,705 22,193 24,511 52.5% 186,818 97,962 88,856 47.6% 186,818 52.4% Treatment Plant 200,850 175,089 25,761 12.8% 803,400 665,135 138,265 17.2% 803,400 82.8% Distribution System 96,450 49,328 47,122 48.9% 385,800 245,453 140,347 36.4% 385,800 63.6% Residential Fill Station 45,867 24,665 21,203 46.2% 221,399 134,626 86,773 39.2% 221,399 60.8% Satellite Water Facility 24,950 - 24,950 100.0% 99,800 154 99,646 99.8% 99,800 0.2% Total Expenses $ 20,604,923 $ 20,047,212 $ 557,712 2.7% $ 85,019,046 $ 81,395,192 $ 3,623,854 4.3% $ 85,019,046 95.7"/o 111Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 83 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 4 - Sewer Construction Fund Revenues by Source - Summary Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) Sewer Service Charges $ 29,059,326 $ 30,187,896 $ 1,128,570 3.9% $ 65,832,492 $ 67,227,158 $ 1,394,666 2.1% $ 65,832,492 102.1% Other Capital Revenues 12,403,257 20,281,848 7,878,591 63.5% 34,955,078 47,138,191 12,183,113 34.9% 34,955,078 134.9% Total Revenue $ 41,462,583 $ 50,469,744 $ 9,007,161 21.7% $ 100,787,570 $ 114,365,349 $ 13,577,779 13.5% $ 100,787,570 113.5% Year -to -Date Revenues by Source t:.. . $70,000,000 . $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category • YTD • YTD Budget Acmal 121Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 84 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Revenues by Source - Detail QTD Category Budget Sewer Service Charges (SSC) Over -the -Counter $ County Allocated 29,059,326 Direct Billed - Prior Year Adjustment Other Capital Revenues Facilities Capacity Fees - Gravity Zone Facilities Capacity Fees - Pump Zone Capacity Use Charge Secured Property Tax Unsecured Property Tax Investment Income Other Government Revenue - Concord State Revolving Fund Loan Proceeds Overtime Inspection Plan Review Main Lines Inspection Fees Rebates to District Other Agency Reimbursement Miscellaneous Income Alhambra Valley Assessment District Contractual Assessment District Total Revenues 131Page Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 4 - Sewer Construction Fund Annual QTD YTD Budget QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) $ 61,421 $ 61,421 $ 119,500 $ 200,080 $ 80,580 67.4% $ 119,500 167.4% 30,156,697 1,097,371 3.8% 64,576,280 65,884,924 1,308,644 2.0% 64,576,280 102.0% 13,787 13,787 1,177,919 1,188,386 10,467 0.9% 1,177,919 100.9% (44,009) (44,009) (41,207) (46,233) (5,026) 12.2% (41,207) 112.2% 877,910 780,714 (97,197) -11.1% 4,445,000 6,734,381 2,289,381 51.5% 4,445,000 151.5% 34,449 21,301 (13,148) -38.2% 134,000 394,764 260,764 194.6% 134,000 294.6% - - - 57,000 36,207 (20,793) -36.5% 57,000 63.5% 3,732,078 6,315,079 2,583,001 69.2% 7,932,078 10,403,396 2,471,318 31.2% 7,932,078 131.2% 100,000 66,606 (33,394) -33.4% 400,000 624,740 224,740 56.2% 400,000 156.2% 20,625 1,357,327 1,336,701 6480.9% 140,000 2,940,938 2,800,938 2000.7% 140,000 2100.7% 7,500,000 9,956,648 2,456,648 32.8% 7,500,000 9,956,648 2,456,648 32.8% 7,500,000 132.8% - 1,762,919 1,762,919 14,000,000 15,588,706 1,588,706 11.3% 14,000,000 111.3% 1,288 2,685 1,396 108.4% 8,000 19,173 11,173 139.7% 8,000 239.7% 15,135 6,303 (8,832) -58.4% 89,000 66,551 (22,449) -25.2% 89,000 74.8% 121,522 8,392 (113,130) -93.1% 249,000 250,551 1,551 0.6% 249,000 100.6% 250 9 (241) -96.6% 1,000 3,751 2,751 275.1% 1,000 375.1% - 48,084 48,084 - 107,584 107,584 - (44,217) (44,217) - 10,802 10,802 - $ 41,462,583 $ 50,469,744 $ 9,007,161 21.7% $ 100,787,570 $ 114,365,349 $ 13,577,779 13.5% $ 100,787,570 113.5% September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 85 of 113 iCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 4 - Sewer Construction Fund Capital Expenditures Summary (by Program) A B C (A-B) D E F (D+E) G (C+D+E) H 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 1 Approved 1 Actual Remaining Budgets Actuals FY 2022-23 Budget Adjustments Budget Expenditures Expenditures Budget Collection System (CS) $ 75,574,241 $ 57,442,049 $ 18,132,192 $ 36,850,000 $ (3,208,975) $ 33,641,025 $ 51,773,217 $ 21,653,217 $ 30,120,000 Treatment Plant (TP) 96,390,332 54,872,388 41,517,944 39,981,000 (16,832,431) 23,148,569 64,666,513 25,953,891 38,712,622 General Improvements (GI) 19,896,459 16,655,259 3,241,200 3,795,000 308,168 4,103,168 7,345,517 3,099,336 4,246,181 Recycled Water (RW) 32,854,000 28,737,307 4,116,693 8,715,O00 1,300,000 10,015,000 14,131,693 8,391,035 5,740,658 CIB Contingency - - - 1,635,000 (3,804,894) (2,169,894) (2,169,894) - (2,169,894) Contingency Bal. Trans. - Close Outs 3,738,132 3,738,132 3,738,132 3,738,132 Budget Adj to Reduce Carryforward 18,500,000 18,500,000 18,500,000 18,500,000 Total $ 224,715,032 $ 157,707,003 $ 67,008,029 $ 90,976,000 $ - $ 90,976,000 $ 157,985,178 $ 59,097,479 $ 98,887,699 Capital Improvement Budget Quarterly Results by Program $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 Collection System (CS) Treatment Plant (TP) General Improvements Recycled Water (RW) (GI) Program ■ Approved Expenditures ■ Actual Expenditures 141Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 86 of 113 'AMI'CENTRAL $AN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 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 I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2022-23 Budget Adjustments Budget Expenditures Expenditures Budget TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 $ 1,460,000 $ 325,348 $ 1,134,652 $ 3,740,000 $ 3,052,000 $ 6,792,000 $ 7,926,652 $ 524,868 $ 7,401,784 8436 Moraga/ Crossroads PS Project 35,451,000 34,219,528 1,231,472 - - - 1,231,472 999,365 232,107 8443 LG Diameter Pipe line Inspection 1,795,000 253,940 1,541,060 (1,000,000) (1,000,000) 541,060 265,135 275,925 8444 Force Main Inspection Program 1,125,000 18,132 1,106,868 - (1,000,000) (1,000,000) 106,868 9,604 97,264 8447 Pump Station Security Improvement 357,000 302 356,698 82,000 - 82,000 438,698 - 438,698 *8449 Collection System Modeling Support 543,000 177,141 365,859 - - - 365,859 128,175 237,684 8450 Development Sewerage Support 4,032,316 4,019,314 13,002 927,000 - 927,000 940,002 854,901 85,101 8457 Pump Station Upgrades - Ph. 2 5,950,000 3,359,231 2,590,769 11,900,000 (3,200,000) 8,700,000 11,290,769 4,608,040 6,682,729 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 2,573,435 1,450,876 8466 Danville Sewer Ren. Ph. 4 1,500,000 1,576,565 (76,565) 3,702,000 3,702,000 3,625,435 3,451,855 173,580 100006 Contractual Assessment District Proj Financing 832,940 - 832,940 100,000 (500,000) (400,000) 432,940 35,857 397,083 100007 Large Diameter Priping Renovation Program 2,000,000 302 1,999,698 - (1,500,000) (1,500,000) 499,698 37,270 462,428 100017 SR Pump Station Electrical Upgrades 700,000 129,110 570,890 1,213,000 - 1,213,000 1,783,890 519,432 1,264,458 100023 Walnut Creek Sewer Renovation Ph.16 500,000 593,164 (93,164) - 5,879,000 5,879,000 5,785,836 4,330,621 1,455,215 100024 South Orinda Sewer Renovation Ph. 9 500,000 451,521 48,479 - - - 48,479 284,809 (236,330) 100025 Lafayette Sewer Renov. Ph.15 500,000 228,951 271,049 - - - 271,049 318,500 (47,451) 100028 Collection System Master Plan 2021 Update 750,000 54,534 695,466 850,000 850,000 1,545,466 241,594 1,303,872 100037 Orinda Moraga PS Architectual Improvements 200,000 12,609 187,391 1,250,000 - 1,250,000 1,437,391 29,343 1,408,048 **100038 San Pablo Watershed Improvements - - - - 200,000 200,000 200,000 43,502 156,498 100039 Collection System Sewere Renovation Ph. 2 - - - 9,410,000 (6,460,000) 2,950,000 2,950,000 69,907 2,880,093 **100041 Buchanan Lift Station Replacements & Improvement - - - - 200,000 200,000 200,000 133,151 66,849 **100042 Pump Station Upgrades, Phase 2B - - - - 3,200,000 3,200,000 3,200,000 125,802 3,074,198 100044 Collection System Modeling Support FY22+ - - - 120,000 - 120,000 120,000 617 119,383 **100049 Dowtown Walnut Creek Sewer Renovations, Ph.1 - 500,000 500,000 500,000 258,352 241,648 **100050 CaltransA-Line Relocation 200,000 200,000 200,000 12,918 187,082 **100052 No. Orinda Sewer Renovations, Ph.9 - - - - 500,000 500,000 500,000 225,068 274,932 **100053 Houston Ct. Area CAD - - - - 252,894 252,894 252,894 216,648 36,246 151Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 87 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 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 Cumulative7=umullaytiave Total Project FY2022-2023 FY2022-23 FY2022-23 FY2022-23 FY2022-23s FY2022-23 Prior YearPriorer Carryforward to Adopted Budget Adjusted Approved Actual Remaining Bud etsuals FY 2022-23 Budget Adjustments Budget Ex enditures Expenditure Budget TYPE CS Collection System Year end close outs - Budget balances transferred to contingency 8419 Collection System Planning LT $ 1,585,000 $ 1,409,671 $ 175,329 $ 200,000 $ (254,034) $ (54,034) $ 121,295 $ 121,295 $ - 8442 PS Equipment Piping Replacement PH2 564,000 428,844 135,156 206,000 (241,935) (35,935) 99,221 99,221 - 8448 Manhole Modifications 2,007,925 1,435,083 572,842 400,000 (788,972) (388,972) 183,870 183,870 8463 No. Orinda Sewer Renov. PH. 8 4,304,000 3,925,644 378,356 - 28,149 28,149 406,505 406,505 8465 WC Sewer Renov. Ph.15 5,400,000 4,121,806 1,278,194 - (734,637) (734,637) 543,557 543,557 100005 Cured -In -Place Pipe Contract FY 2020-25 850,000 - 850,000 250,000 (1,100,000) (850,000) - - *100021 Cordel Drive West CAD 167,060 144,620 22,440 - (22,440) (22,440) Rounding Total CS Program $ 75,574,241 $ 57,442,049 $ 18,132,192 $ 36,850,000 $ (3,208,975) $ 33,641,025 $ 51,773,217 $ 21,653,217 $ 30,120,000 * Projects open but not in CIB for 22/23 ** Not in 22/23 Budget. New projects. Funds transferred from other projects or Contingency 161Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 88 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 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 1 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 Carryforwardto Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2022-23 Budget 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 $ 293,307 $ 364,892 7328 Influent Pump Electrical improvements 8,160,000 8,665,855 (505,855) 1,426,000 1,300,000 2,726,000 2,220,145 2,315,449 (95,304) ***7341 WC/Grayson Creek Levee Rehab 1,050,000 630,015 419,985 1,500,000 (400,000) 1,100,000 1,519,985 283,147 1,236,838 ***7348 Solids Handling Facility Improvements 34,518,687 18,436,325 16,082,362 5,000,000 (12,000,000) (7,000,000) 9,082,362 5,508,639 3,573,723 7349 Aeration & Energy Upgrade 5,350,000 4,462,963 887,037 500,000 500,000 1,387,037 75,285 1,311,752 ***7357 Plant Wide Instrumentation Upgrade 1,421,000 110,484 1,310,516 - (900,000) (900,000) 410,516 83,093 327,423 7369 Piping Renovation - Phase 10 5,450,000 1,891,406 3,558,594 - 3,558,594 1,697,440 1,861,154 ***7370 Annual Infrastructure Replacement 3,605,000 1,991,444 1,613,556 1,000,000 (1,000,000) 1,613,556 602,340 1,011,216 7373 Fire Protection System Ph. 3 1,100,000 524,564 575,436 - - 575,436 540,591 34,845 ***100001 UPCAA Urgent Projects FY 2020-25 1,200,000 176,995 1,023,005 600,000 (500,000) 100,000 1,123,005 111,715 1,011,290 100008 Laboratory Roof & Seismic upgrades 950,000 96,086 853,914 500,000 500,000 1,353,914 1,213,575 140,339 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,000,000) (1,000,000) 249,354 185,298 64,056 100011 Plant Electrical Replacement & Rehabilitation 408,371 211,278 197,093 400,000 400,000 597,093 105,981 491,112 100012 UV Disinfection Replacement 2,500,000 1,239,101 1,260,899 3,500,000 3,500,000 4,760,899 369,274 4,391,625 *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 (700,000) 50,000 769,372 277,406 491,966 100015 Electric Blower Improvements 9,150,000 5,896,057 3,253,943 4,245,000 - 4,245,000 7,498,943 5,787,796 1,711,147 100019 Aeration Basins Diffuer Replacement and Seismic UPI 2,300,000 832,698 1,467,302 7,500,000 (2,320,000) 5,180,000 6,647,302 1,570,664 5,076,638 100022 Wet Weather Basin Improvements 700,000 300,667 399,333 600,000 600,000 999,333 237,810 761,523 ***100030 Solids Handling Facility Improvements Ph. 2 3,600,000 191,043 3,408,957 3,100,000 (1,000,000) 2,100,000 5,508,957 1,414,177 4,094,780 100032 Steam Renovations, Ph.1 500,000 21,645 478,355 4,500,000 4,500,000 4,978,355 960,430 4,017,925 ***100034 TP Safety Enhancemetns Program 200,000 - 200,000 300,000 (500,000) (200,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 25,693 174,307 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 171Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 89 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 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 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 I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2022-23 Budget Adjustments Budget Expenditures Expenditures Budget **100051 RAS Piping Renovations $ $ $ $ $ 2,020,000 $ 2,020,000 $ 2,020,000 $ 302,170 $ 1,717,830 **100054 Aeration Unit 1 Steam Turbine Overhaul - - - - 200,000 200,000 200,000 542 199,458 **100055 Process Optimization and Efficiency - - - - 200,000 200,000 200,000 307 199,693 Year end close outs - Budget balances transferred to contingency 7363 Treatment Plant Planning 2,100,000 1,692,414 407,586 200,000 (440,268) (240,268) 167,318 167,318 - 7364 TP Safety Enhancement Ph. 5 1,180,000 1,204,582 (24,582) - 40,598 40,598 16,016 16,016 7371 Condition Assessment of Buried Pipelines 500,000 - 500,000 - (500,000) (500,000) - - - 7375 Contractor Staging Improvements 5,200,000 4,475,037 724,963 419,665 419,665 1,144,628 1,144,628 100018 Outfall Monitoring Improvements 610,000 218,980 391,020 - 247,574 247,574 638,594 638,594 - Rounding Total TP Program $ 96,390,332 $ 54,872,388 $ 41,517,944 $ 39,981,000 $ (16,832,431) $ 23,148,569 $ 64,666,513 $ 25,953,891 $ 38,712,622 * Projects open but not in CIB for F22/23 ** Not in 22/23 Budget. New projects. Funds transferred from other projects or Contingency *** Project budget adjustments to reduce FY 2022-23 carryforward per FY 2023-24 Adopted Budget Book 181Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 90 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 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 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 I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2022-23 Budget Adjustments Budget Expenditures Expenditures Budget TYPE GI General Improvements 8250 ERP Replacement $ 5,380,000 $ 5,326,990 $ 53,010 $ - $ - $ - $ 53,010 $ 24,000 $ 29,010 8251 Capital improvement program & Budget Improvemer 390,000 163,856 226,144 200,000 - 200,000 426,144 356,236 69,908 8252 POB E.V. Charging Station 490,000 21,749 468,251 150,000 150,000 618,251 68,821 549,430 8253 COVID-19 Response 275,000 113,510 161,490 - - - 161,490 85,213 76,277 8516 District Equipment Acquisition 1,476,000 1,271,897 204,103 250,000 - 250,000 454,103 400,680 53,423 8517 Vehicle Replacement Program 4,718,000 4,373,000 345,000 900,000 400,000 1,300,000 1,645,000 173,748 1,471,252 100003 Property Repairs & Improvements 450,000 276,634 173,366 700,000 - 700,000 873,366 252,722 620,644 100004 HOB Exterior Repairs 400,000 291,102 108,898 - - - 108,898 - 108,898 100027 Furnishings Replacement 100,000 - 100,000 100,000 19,271 80,729 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 263,939 311,112 100033 Security Improvements FY 2021-25 200,000 45,266 154,734 100,000 100,000 254,734 110,452 144,282 **100035 Technology Strategic Plan 500,000 302 499,698 500,000 (200,000) 300,000 799,698 336,399 463,299 100043 Easement Acquisition FY 2022-31 - - - 75,000 - 75,000 75,000 8,486 66,514 *100056 NetZero Study - - 200,000 200,000 200,000 69,756 130,244 9999 Capital Project Clearing (Accounting Use Only) - 1,149 (1,149) - - - - 11,101 (11,101) Year end close outs - Budget balances transferred to contingency 8230 Capital Legal Services $ 228,665 $ 226,234 $ 2,431 $ 20,000 $ 7,518 $ 27,518 $ 29,949 $ 29,949 $ 8240 IT Development 4,488,794 4,002,443 486,351 500,000 (99,350) 400,650 887,001 887,001 - Rounding Total GI Program $ 19,896,459 $ 16,655,259 $ 3,241,200 $ 3,795,000 $ 308,168 $ 4,103,168 $ 7,345,517 $ 3,099,336 $ 4,246,181 * Not in 22/23 Budget New projects. Funds transferred from other projects or Contingency ** Project budget adjustments to reduce FY 2022-23 carryforward per FY 2023-24 Adopted Budget Book 191Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 91 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 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 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 I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2022-23 Budget Adjustments Budget Expenditures Expenditures Budget TYPE RW Recycled Water 7361 Filter Plant & Clearwell Improvements Ph. 1A $ 30,989,000 $ 28,387,070 $ 2,601,930 $ 7,600,000 $ 1,800,000 $ 9,400,000 $ 12,001,930 $ 8,289,958 $ 3,711,972 *7366 ReW Distribution System Renov. Program 715,000 196,187 518,813 215,000 (400,000) (185,000) 333,813 25,563 308,250 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 29,940 1,408,147 *100036 Zone 1 Recycled Water 2021 100,000 - 100,000 100,000 (100,000) - 100,000 45,574 54,426 Rounding Total RW Program $ 32,8S4,000 $ 28,737,307 $ 4,116,693 $ 8,715,000 $ 1,300,000 $ 10,015,000 $ 14,131,693 $ 8,391,035 $ 5,740,658 * Project budget adjustments to reduce FY 2022-23 carryforward per FY 2023-24 Adopted Budget Book 9990 CONTINGENCY - ALL PROGRAMS $ $ $ $ 1,635,000 $ (3,804,894) $ (2,169,894) $ (2,169,894) $ (2,169,894) 9990 CONTINGENCY BAL TRANS - CLOSE OUTS $ $ $ $ $ 3,738,132 $ 3,738,132 $ 3,738,132 $ 3,738,132 BUDGET AD) TO REDUCE CARRYFORWARD $ $ $ $ $ 18,500,000 $ 18,500,000 $ 18,500,000 $ 18,500,000 GRAND TOTAL $ 224,715,032 $ 157,707,003 $ 67,008,029 $ 90,976,000 $ $ 90,976,000 $ 1S7,985,178 $ 59,097,479 $ 98,887,699 201Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 92 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 4 - Sewer Construction Fund CAPITAL BUDGET TRANSFERS PERIOD ENDING: 6/30/2023 Project No. Project Description July 2022 Se tember 2022 October 2022 November 2022 lanuary2023 February2023 Alpri12023 Ma 2023 June 2023 Total FY 2022-23 Activity FY 2022-23 Contingency Balance FY 2022-23 Adopted Budget Balance $ 1,635,000 $ 1,635,000 7375 Contractor Staging Improvements 300,000 300,000 100038 San Pablo Watershed Improvements 200,000 200,000 *8457 Pump Station Upgrades Ph. 2 $ 200,000 3,000,000 3,200,000 100041 Buchanan Lift Station Replacements & Im rov 200,000 200,000 *100042 Pump Station Upgrades Ph. 2B 200,000 3,000,000 3,200,000 100039 Collection System Sewer Renovation Ph. 2 $ 500,000 $ 419,000 $ 500,000 $ 5,879,000 6,460,000 100049 Downtown Walnut Creek Sewer Renovation Ph.1 500,000 500,000 8464 Martinez Sewer Renovation Ph. 7 419,000 419,000 100050 Caltrans A -Line Relocation 200,000 200,000 -100019 Aeration Basins Diffuer Replacement and Seismic U 300,000 2,020,000 2,320,000 100051 RAS Piping Renovations 300,000 1,720,000 2,020,000 100052 1 No. Orinda Sewer Renovations, Ph. 9 500,000 500,000 100053 Houston Ct Area CAD 252,894 252,894 *100006 Contractual Assessment District Pro' Financing 252,894 247,106 500,000 7370 Annual Infrastructure Replacement 200,000 200,000 100054 Aeration Unit 1 Steam Turbine Overhaul 200,000 200,000 100023 Walnut Creek Sewer Renovation Ph. 16 5,879,000 5,879,000 100055 Process Optimization and Efficiency $ 200,000 200,000 100056 NetZero Stud $ 200,000 1 200,000 *7361 1 Filter Plant & Clearwell Improvements Ph. IA 1,800,000 1,800,000 *5991 PH Sewer Renovation Phase 2 3,052,000 3,052,000 *7328 Influent Pump Electrical Im rovments 1,300,000 1,300,000 *8443 LG Diameter Pipe line Inspection 1,000,000 1,000,000 A2,419.94 *8444 Force Main Inspection Program 1,000,000 1,000,000 *8517 Vehicle Replacement Program 400,000 400,000 *100007 Large Diameter Piping Renovation Program 1,500,000 1,500,000 9990 Current year Contingency 500,000 200,000 200,000 200,000 200,000 2,504,894 3,804,894 **9990 Conlin en transfers to from due to closeouts 3,738,132 1 3,738,132 3,738,132 GRAND TOTAL $ $ $ $ $ $ $ $ $ 3,738,132 $ 3,738,132 $ 1,568,238 * Budget transfers needed in June 2023 to correct FY 22-23 budget to date dollars as per FY 23-24 adopted budget. (Only $300K of June 2023 transfers for Project 100019 is related to this footnote) **Year end close outs -Budget balances transferred to contingency and used to fund other prolects 7363 Treatment Plant Planning (440,268) 7364 TP Safety Enhancement Ph. 5 40,598 7371 Condition Assessment of Buried Pipelines (500,000) 7375 Contractor Staging Improvements 119,665 8230 Capital Legal Services 7,518 8240 IT Development (99,350) 8419 Collection System Planning LT (254,034) 8442 PS Equipment Piping Replacement PH2 (241,935) 8448 Manhole Modifications (788,972) 8463 No. Orinda Sewer Reno, PH. 8 28,149 8465 WC Sewer Renov. Ph. 15 (734,637) 100005 Cured -In -Place Pipe Contract FY 2020-25 (1,100,000) 100018 Outfall Monitoring Improvements 247,574 100021 Cordell Drive West CAD (22,440) TOTAL _ $ (3,738,132) 211Page Budaet adjustments to reduce FY2022-23 carryforward per FY2023-24 Adopted Budget Book 7341 WC/Grayson Creek Levee Rehab (400,000) 7348 Solids Handling Facility Improvements (12,000,000) 7357 Plant Wide Instrumentation Upgrade (900,000) 7366 ReW Distribution System Renov. Program (400,000) 7370 Annual Infrastructure Replacement (800,000) 100001 UPCAA Urgent Projects FY 2020-25 (500,000) 100010 Air Conditioning & Lighting Renovation (1,000,000) 100014 MRC Building Modifications (700,000) 100030 Solids Handling Facility Improvements Ph. 2 (1,000,000) 100034 TP Safety Enhancement Program (500,000) 100035 Technology Strategic Plan (200,000) 100036 Zone 1 Recycled Water 2021 (100,000) TOTAL $ (18,500,000) September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 93 of 113 iCENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 5 - Self Insurance Fund Revenues by Source Annual QTD YTD Budget QTD QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) Sewer Service Charge $ - $ - $ $ 1,662,101 $ 1,662,101 $ 0.0% $ 1,662,101 100.0% Insurance Recoveries 25,000 23,878 (1,122) -4.5% 25,000 23,878 (1,122) -4.5% 25,000 95.5% Investment Income 40,350 77,955 37,605 93.2% 47,400 224,642 177,242 373.9% 47,400 473.9% Total Revenues $ 65,350 $ 101,832 $ 36,482 55.8% $ 1,734,501 $ 1,910,621 $ 176,120 10.2% $ 1,734,501 110.2% Year -to -Date Revenues by Source $Z000,000 $1,500,000 $1,000,000 $500,000 Sewer Service Charge Insurance Recoveries (HHW) Investment Income Revenue Source Category ■ YTD ■ YTD Budget Actual 221Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 94 of 113 'AMI'CENTRAL $AN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 5 - Self Insurance Fund Expenses by Type Annual QTD YTD YTD Budget QTD QTD Variance YTD YTD Variance Variance Annual Realized Category QTD Budget Actual Variance ($) %) Budget Actual ($) % Budget Professional Services $ 93,750 $ 102,399 $ (8,649) -9.2% $ 375,000 $ 418,485 $ (43,485) -11.6% $ 375,000 111.6% Technical Services 15,000 4,244 10,756 71.7% 60,000 33,688 26,312 43.9% 60,000 56.1% Insurance & Risk Management 433,750 222,568 211,182 48.7% 1,735,000 1,509,201 225,799 13.0% 1,735,000 87.0% Total Expenses $ 542,500 $ 329,212 $ 424,574 78.3% $ 2,170,000 $ 1,961,374 $ 208,626 9.6% $2,170,000 90.4% Year -to -Date Expenses by Type $1,eao,0on $1,sao,0ou $1,400,000 � $1,200,000 $1,000,000 $800,000 .00,000 $400,000 $zua,0oo s- ProfessionalService Technical Services Insurance& Risk Management Expense Category •YTD • YTD Budget Actual 231Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 95 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 6 - Debt Service Fund Revenues by Source Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Estimate (%) Tax Revenue $ 1,251,922 $ 4,524,123 $ 3,272,201 261.4% $ 13,251,922 $ 11,905,088 $ (1,346,834) -10.2% $ 13,251,922 89.8% Year -to -Date Revenues by Source $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 Tax Revenue ■ YTD ■ YTD Budget Actual 241Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 96 of 113 iCENTRAL 5AN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 6 - Debt Service Fund Expenses by Type 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% $ 2,500 $ 5,800 $ (3,300) -132.0% $ 2,500 232.0% Expense - - 10,750,000 10,750,000 - 0.0% 10,750,000 100.0% Interest Expense (429,179) 429,179 2,499,422 1,149,288 1,350,134 54.0% 2,499,422 217.5% Total Expenses $ 625 $ (429,179) $ 429,804 68768.7% $ 13,251,922 $ 11,905,088 $ 1,346,834 10.2% $ 13,251,922 89.8% $11,000,000 $9,000,000 $7,000,000 / $5,000,000 $3,000,000 $1,000,000 $(1,000,000) Professional Services 251Page Year -to -Date Expenses by Type Principal Payment Expense ■ YTD ■ YTD Budget Actual Interest Expense September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 97 of 113 ,AMI'CENTRAL $AN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 7 - Quarterly Investment Portfolios Operating & Maintenance Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of QTD Investment YTD Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif. LAIF n/a n/a n/a (1) $ 14,000,000 $ 16,900,000 $ (2,900,000) $ 14,000,000 $ 13,787,599 57.14% $ 136,247 $ 426,853 RE21 FHLB US Fed Agency 5/19/2022 5/17/23 0 2.174% 1,468,086 1,500,000 (1,500,000) - - 0.00% 4,045 28,134 RE22 UST Notes US Treasury 5/19/2022 4/30/24 305 2.661% 1,497,366 1,500,000 - 1,500,000 1,465,925 6.12% 337 1,351 RE23 FHLB DISC US Agency 12/27/2022 6/23/23 0 4.783% 4,886,031 5,000,000 (5,000,000) - - 0.00% 53,143 113,969 RE25 US Treasury US Treasury 4/24/2023 7/20/23 20 5.054% 8,892,881 9,000,000 9,000,000 8,978,670 36.73% 83,726 83,726 (3) $ 30,744,364 $ 24,900,000 $ (400,000) $ 24,500,000 $ 24,232,194 100.00% 277,498 654,033 (2) (4) (5) 6,471 83,662 $ 283,969 $ 737,695 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 June 2023 was 3.19%. (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.745%. 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 June 30, 2023 was $24,232,194. 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 Sans investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Running Expense fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Running Expense Fund, $6,460,000 is restricted for the Rate Stabilization Fund Account 261Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 98 of 113 ,AMI'CENTRAL $AN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 7 - Quarterly Investment Portfolios Sewer Construction Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ F.OQ % of QTD Investmentm YTD Investent 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) $ 21,500,000 $ 23,500,000 $ (2,000,000) $ 21,500,000 $ 21,173,813 16.35% $ 173,519 $ 554,753 961 US T Bill US Treasury 1/21/2022 1/15/2025 565 1.26% 2,490,505 2,500,000 - 2,500,000 2,350,675 1.90% 792 3,179 963 FHLB US Fed Agency 5/19/2022 5/17/2023 0 2.17% 12,723,414 13,000,000 (13,000,000) - - 0.00% 35,049 243,822 964 UST Notes US Treasury 5/19/2022 4/30/2024 305 2.66% 2,495,610 2,500,000 - 2,500,000 2,443,209 1.90% 561 2,251 965 FHLB US Fed Agency 8/12/2022 6/11/2023 42 3.28% 4,840,244 5,000,000 - 5,000,000 4,973,650 3.80% 39,940 141,323 968 FHLB Disc US Agency 12/29/2022 6/28/2023 0 4.77% 29,306,922 30,000,000 (30,000,000) - - 0.00% 336,966 693,078 969 FHLB Disc US Agency 2/27/2023 6/24/2023 55 5.10% 8,293,644 8,500,000 - 8,500,000 8,440,330 6.46% 105,496 143,753 970 UST Bill US Treasury 3/31/2023 9/28/2023 90 4.87% 19,529,400 20,000,000 - 20,000,000 19,627,684 15.21% 236,600 239,200 971 US Treasury US Treasury 4/24/2023 7/20/2023 20 5.05% 32,607,231 - 33,000,000 33,000,000 32,921,790 25.10% 306,992 306,992 972 US Treasury US Treasury 5/19/2023 8/17/2023 48 5.24% 10,366,125 - 10,500,000 10,500,000 10,432,170 7.98% 63,963 63,963 973 US Treasury US Treasury 6/29/2023 9/23/2023 90 5.33% 27,633,725 28,000,000 28,000,000 2777727796 21.29% 8,050 6,050 (3) $ 171,786,820 $ 105,000,000 $ 26.500.000 $ 131,500,000 $ 130.136,117 100.00% 1,307,923 2,400,364 (2) (4) (5) 7,638 469,106 $ 1,315,566 $ 2,869,470 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 June 2023 was 3.19%. (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 4.292%. 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 Countv. (4) The market value of the portfolio on June 30, 2023 was $130,136,117. 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 Sans investment policy approved by the Board of Directors [California Government Cade §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Sewer Construction fund for the next six (6) months [California Government Code §53646(b)(3)]. (C) Of the total investments held in the Sewer Construction Fund, $1,000,000 is restricted for the Rate Stabilization Reserve Account. 271Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 99 of 113 ,AMI'CENTRAL $AN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 7 - Quarterly Investment Portfolios Self Insurance Fund Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ % of QTD Investment YTD Investment No Issuer Type Date Date Maturity Yield Outlay Face ValueMaturity) ( Face Value Market Value Portfolio Income Income 519 State of Calif. LAW n/a n/a n/a (1) $ 10,100,000 $ 10,100,000 $ $ 10'100,000 $ 9,946,768 100.00% $ 75,703 $ 217,223 (3) $ 10,100,000 $ 101100,000 $ $ 10,100,000 $ 9,946,768 100.00% 75,703 217,223 (2) (4) (5) 6,231 8,299 $ B1,934 $ 225,522 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 June 2023 was 3.19%. (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.19%. (4) The market value of the portfolio on June 30, 2023 was $9,946,768. (5) Amount represents interest income from prior period investments. Notes: (A) All investments held by the Self Insurance Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)]. (B) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Self Insurance fund for the next six (6) months [California Government Code §53646(b)(3)]. 281Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet -Page 100 of 113 iCENTRAL 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 June 30, 2023 Section 8 - Financial Performance Metric Charts FY 2022-23 Running Expense Fund Total Cash & Investment Balances (Actuals through June 2023) i37.0 $28.2 $40.9 June'22 July August September October November December January February March April May M Projected Balance* MActual 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 . 291Page `$32.8 $29.2 June September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 101 of 113 c.CENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast $140.0 $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 June 2023) $93.8 $141.8 $138.8 $138.0 June'22 July August September October November December January February March April MProjected Balance* MActual 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. 301Page lid May June September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 102 of 113 'AM'CENTRAL 5AN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 8 - Financial Performance Metric Charts Staffing Trends 300 5.4% Vacanc Rate 295 290 14 H 285 15 w a� 280 275 cu 270 H 265 278 w 260 255 250 6/30/20 6/30/21 6/30/22 6/30/23 Quarter Ended ■ Filled Positions (FTEs) ■ Vacancies (FTEs) 311Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 103 of 113 'AM'CENTRAL 5AN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 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 321Page Historical Quarterly O&M Costper $4,096 $4,204 6/30/20 6/30/21 Quarter Ended Million Gallons Treated $4,517 $ 3,188 6/30/22 6/30/23 September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 104 of 113 'AMI'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 8 - Financial Performance Metric Charts Capital Spending Trend $180 $160 $158.0 M $140 $120 0 $100 $80 — $ 116.2M $60 — $59.1M $40 - $20 — - l�� PJ�as� tie�'beY OobeY ae��eY Ce�,peY a��aY� ebaY`i �aYC'O P.QY� �a9 lie Se4 �o �e 1 F —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). 331Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 105 of 113 'Ayt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ- CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending June 30, 2023 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed / Renovated 4.0 ` 3.5 3.0 U U N 2.5 a 2.0 0 U 1.8 c 2.0 1.7 1.5 a 1.3 a 1.5 ` 0 iv 1.0 0.5 0.5 0.5 0.0 ���'0��''L 1tiI31Iti� �I31�ti� 6I3olti'3 Quarter Ending ■ Actual Construction ■ Target ("S-Curve" of 6 mi. FY 22-23 Budget Projection) 341Page September 19, 2023 Regular FINANCE Committee Meeting Agenda Packet - Page 106 of 113