Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
04. Receive quarterly financial review for quarter ending September 30, 2022
Page 1 of 34 Item 4. CENTRALSAN jdf A- hom CENTRAL CONTRA COSTA SANITARY DISTRICT December 1, 2022 TO: HONORABLE BOARD OF DIRECTORS FROM: CHRISTOPHER THOMAS, ACCOUNTING SUPERVISOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIP LEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE QUARTERLY FINANCIAL REVIEW FOR QUARTER ENDING SEPTEMBER 30, 2022 Attached is the Quarterly Financial Review for the first quarter of Fiscal Year(FY) 2022-23 ending September 30, 2022. 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 Report September 2002 December 1, 2022 Regular Board Meeting Agenda Packet- Page 15 of 157 . . uarterFinancial _s CENTRAL SAN Review rw AM i _ IM I t . , uarter Ended September 30, 2022 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Table of Contents Section1 -Executive Summary................................................................................................................................................................................................1 Section 2 -Financial Results Summary by Fund................................................................................................................................................................4 Section 3 - Operations&Maintenance Fund Revenues Revenuesby Source- Summary........................................................................................................................................................................................................5 Revenuesby Source- Detail...............................................................................................................................................................................................................6 Expenses Expensesby Type-Summary............................................................................................................................................................................................................7 Expensesby Type- Detail....................................................................................................................................................................................................................8 Expenses by Organizational Unit- Summary(Department) .............................................................................................................................................10 Expenses by Organizational Unit- Detail (Division).............................................................................................................................................................11 Section 4-Sewer Construction Fund Revenues Revenuesby Source- Summary.....................................................................................................................................................................................................12 Revenuesby Source- Detail............................................................................................................................................................................................................13 Expenses ExpensesSummary(by Program).................................................................................................................................................................................................14 ExpensesDetail (by Project)............................................................................................................................................................................................................15 Section 5 -Self Insurance Fund Revenuesby Source.............................................................................................................................................................................................................................18 Expensesby Type.................................................................................................................................................................................................................................19 December 1, 2022 Regular Board Meeting Agenda Packet- Page 17 of 157 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 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 December 1, 2022 Regular Board Meeting Agenda Packet- Page 18 of 157 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 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 first quarter of FY 2022-23 ended September 30, 2022. 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 first quarter show total expenditures of$20.8 million, which is approximately $1.5 million (6.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 purchased property services, supplies and materials, and other purchased services categories, is smaller than the favorable annual budget variance reported in the first quarter of the prior year of 10.4%. 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$678 thousand (40.4%). In the aggregate, the 0&M Fund is reporting a favorable revenue variance of approximately $355 thousand, which is approximately 48.8% 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 first quarter show total capital project expenditures of $7.4 million, or 8.1% 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 roll-over 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 December 1, 2022 Regular Board Meeting Agenda Packet- Page 19 of 157 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 1 -Executive Summary weighed the alternatives to continuing with long-standing incineration methods. Central San will be weighing the impacts of these two issues on the long-term Capital Improvement Plan as it considers its forthcoming rate proposal. After factoring in the roll-over, the year-to-date capital spending rate is 4.7% 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, attributable to various projects as shown in pages 15 through 17 of this report. On the revenue side, the Sewer Construction Fund is currently reporting revenues of $4.3 million, significantly ahead of the year-to-date budget amount of $763 thousand. $3.2 million of this favorable variance is attributable to capacity fees, which are budgeted evenly each month but are hard to predict and are usually received sporadically throughout the year. 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 September 30, 2022 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. Through the first quarter of FY 2022-23, the 0&M Fund investment portfolio has generated $81,028 of income which is above the year-to-date revenue estimate of $63,000 by 28.6%. The Sewer Construction Fund portfolio is reporting $254,200 of income, coming in well over the year-to-date revenue estimate of$41,619 by 510.5%. The Finance Division has recently made diversification of the investment portfolio (beyond LAIF) a top priority which has led to purchasing more U.S. Treasury Bills and Federal Agency securities,which in turn has drastically increased weighted average yield so far in FY 2022-23. As of September 30, 2022, Central San continues to hold about half of its investment portfolio, or $43.0 million, in the Local Agency Investment Fund (LAIF) state investment pool, under the maximum amount permitted to be held in the pool of $75 2 1 P a g e December 1, 2022 Regular Board Meeting Agenda Packet- Page 20 of 157 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 1 -Executive Summary million. The Fed has continued its trend of aggressive normalization away from historically low interest rates that started in calendar year 2022. In this quarter, the Fed issued two 75-point rate hikes, resulting in a target rate of 3.0 - 3.25% as of the quarters end, which does not include an additional rate hike of 75-points approved in early November prior to the release of this report. 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. As interest rates continue to rise during FY 2022-23, as noted previously, staff has been implementing a more diverse portfolio which now includes more U.S. Treasury Bills and Federal Agency Notes, with maturity dates ranging from 6 to 36 months. While staff does intend to continue exploring investment alternatives, it is stressed that given the restricted nature of municipal investing, additional efforts are not expected to 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 September 30, 2022. 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 December 1, 2022 Regular Board Meeting Agenda Packet- Page 21 of 157 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 2 -Financial Results Summary by Fund Annual YTD Budget YTD YTD YTD Variance Annual Realized Category Budget Actual Variance($) (%) Budget (%) Fund Revenues 0&M $ 728,701 $ 1,083,954 $ 355,253 48.8% $ 69,762,907 1.6% Sewer Construction 763,323 4,327,034 3,563,711 466.9% 86,787,570 5.0% Self Insurance 2,350 32,482 30,132 1282.2% 1,734,501 1.9% Debt Service - - - 13,251,922 0.0% Total $ 1,494,374 $ 5,443,469 $ 3,949,095 $ 171,536,900 Fund Expenses 0&M $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 85,019,046 24.4% Sewer Construction 24,678,971 7,375,357 17,303,614 70.1% 157,985,157 4.7% Self Insurance 542,500 1,306,278 (763,778) -140.8% 2,170,000 60.2% Debt Service 12,132,030 11,210,468 921,562 7.6% 13,251,922 84.6% Total $ 59,613,900 $ 40,647,309 $ 18,966,591 $ 258,426,125 YTD Budget-to-Actual Revenues by Fund YTD Budget-to-Actual Expenses by Fund $5,000,000 $4,500,000 $25,000,000 $4,N01000 $3,500,000 $20,000,000 $3,000,000 $2,5001000 8151000,000 - $2,000,000 -L $1500100 � $io,000,000 ri,00B4Ooo $5,000,000 $500,000 11 L 411111111111111". $- E- - 0&M Sewer Construction Self lnsuranre Debt Service O&M Sewer Coru'trnRion Selflnsurance Debt Service Fund Fund •YTD •YTD •YTD •YTD BudgC Actual Budges Actual 4Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 22 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 3 - Operations & Maintenance Fund Revenues by Source - Summary Level Annual QTD QTD QTD QTD Variance YTD YTD YTD YTD Annual Budget Category Budget Actual Variance($] (%) Budget Actual Variance($) Variance(%) Budget Realized(%) Operating Revenues: Sewer Service Charge Revenue $ 13,677 $ 174,857 $ 161,181 1178.5% $ 13,677 $ 174,857 $ 161,181 1178.5% $ 47,162,407 0.4% Sewage Treatment Cost Sharing (53,384) - 53,384 -100.0% (53,384) - 53,384 -100.0% 17,600,000 0.0% Miscellaneous Service Charge 129,751 190,554 60,803 46.9% 129,751 190,554 60,803 46.9% 2,159,000 8.8% Non-Operating Revenues: Permit and Inspection Fees 403,182 401,304 (1,878) -0.5% 403,182 401,304 (1,878) -0.5% 1,799,500 22.3% Other Non Operating Income 172,477 236,210 63,734 37.0% 172,477 236,210 63,734 37.0% 780,000 30.3% Investment Income 63,000 81,028 18,028 28.6% 63,000 81,028 18,028 28.6% 262,000 30.9% Total Revenue $ 728,701 $ 1,083,954 $ 355,253 48.8% $ 728,701 $ 1,083,954 $ 355,253 48.8% $ 69,762,907 1.6% Year-to-Date Revenues by Source $500,000 $400,000 $300,000 $200,000 ' $100,000 Sewer Service Charge Revenue Sewage I matment Cost Miscellaneous Service Charge Permit and Inspection Fees Other Non Operating Income investment Income Sharing $(100,000) Revenue Source Category ■YTD ■YTD Budget Actual 5 � Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 23 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 3 - Operations & Maintenance Fund Revenues by Source - Detail Level Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance($) (°/o) Budget Actual Variance($) (%) Budget (%] Sewer Service Charge Revenue Sewer Service Charge Counter $ 20,875 $ 238,653 $ 217,778 1043.2% $ 20,875 $ 238,653 $ 217,778 1043.2% $ 83,500 285.8% Sewer Service Charge County - (60,387) (60,387) - (60,387) (60,387) 46,284,619 -0.1% Sewer Service Charge Direct - - 823,081 0.0% Sewer Service Charge Prior (7,198) (3,409) 3,789 -52.6% (7,198) (3,409) 3,789 -52.6% (28,793) 11.8% Sewage Treatment Cost Sharing (53,384) - 53,384 -100.0% (53,384) - 53,384 -100.0% 17,600,000 0.0% Miscellaneous Service Charges Septic Tank Dumping 19,463 14,448 (5,016) -25.8% 19,463 14,448 (5,016) -25.8% 40,000 36.1% Sales 91 310 219 241.0% 91 310 219 241.0% 1,000 31.0% Other Service Charges 20,729 - (20,729) -100.0% 20,729 - (20,729) -100.0% 210,000 0.0% Recycled Water 82,642 167,173 84,530 102.3% 82,642 167,173 84,530 102.3% 445,000 37.6% Satellite Water Recycling - - - - - - - Stormwater Program - - - - - - 415,000 0.0% Household Hazardous Waste 6,825 8,623 1,798 26.4% 6,825 8,623 1,798 26.4% 1,048,000 0.8% Permit&Inspection Fees Permit/Application Fees 108,248 121,851 13,603 12.6% 108,248 121,851 13,603 12.6% 480,000 25.4% Overtime Inspection 785 952 167 21.3% 785 952 167 21.3% 9,500 10.0% Side Sewer Inspection 285,024 269,776 (15,248) -5.3% 285,024 269,776 (15,248) -5.3% 1,160,000 23.3% Industrial Permit Fees - - - - 110,000 0.0% New Industry Permit Fees 5,525 3,277 (2,248) -40.7% 5,525 3,277 (2,248) -40.7% 15,000 21.8% Annexation Charges 3,599 5,448 1,849 51.4% 3,599 5,448 1,849 51.4% 25,000 21.8% Other Non-Operating Income MVSD P2 Program - - - - - - 28,000 0.0% Pretreatment Program Fine 500 18,000 17,500 3500.0% 500 18,000 17,500 3500.0% 2,000 900.0% Lease Rental Income 170,415 174,663 4,248 2.5% 170,415 174,663 4,248 2.5% 740,000 23.6% Miscellaneous Income 1,561 31,384 29,823 1910.1% 1,561 31,384 29,823 1910.1% 10,000 313.8% Right of Way Fees - 2,538 2,538 - 2,538 2,538 - Reimbursements - 9,625 9,625 - 9,625 9,625 - Investment Income 63,000 81,028 18,028 28.6% 63,000 81,028 18,028 28.6% 262,000 30.9% Total Revenues $ 728,701 $ 1,083,954 $ 355,253 48.8% $ 728,701 $ 1,083,954 $ 355,253 48.8% $ 69,762,907 1.6% 6 1 P a g e December 1, 2022 Regular Board Meeting Agenda Packet- Page 24 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Type - Summary QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance($) (%) Budget Actual Variance($) (%) Budget (%) Salaries&Wages $ 11,355,758 $ 11,010,489 $ 345,269 3.0% $ 11,355,758 $ 11,010,489 $ 345,269 3.0% $ 42,748,849 25.8% Employee Benefits 3,071,641 3,459,301 (387,660) -12.6% 3,071,641 3,459,301 (387,660) -12.6% 12,312,215 28.1% Unfunded Liability Costs 345,850 346,058 (208) -0.1% 345,850 346,058 (208) -0.1% 1,379,784 25.1% Purchased Property Services 2,186,300 1,682,458 503,842 23.0% 2,186,300 1,682,458 503,842 23.0% 6,850,450 24.6% Other Purchased Services 1,676,817 999,035 677,782 40.4% 1,676,817 999,035 677,782 40.4% 7,893,758 12.7% Supplies&Materials 3,277,750 2,774,318 503,432 15.4% 3,277,750 2,774,318 503,432 15.4% 12,406,002 22.4% Other Expenses 346,282 483,546 (137,264) -39.6% 346,282 483,546 (137,264) -39.6% 1,427,990 33.9% Total Expenses $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 85,019,046 24.4% Year-to-Date Expenses by Type $12,000,000 _ $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 Salaries&Wages Employee Benefits Unfunded Liability Purchased Property Other Purchased Supplies&Materials Other Expenses Costs Services Services Department ■YTD ■ YTD Budget Actual 7Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 25 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail QTD QTD QTD QTD Variance YTD YTD YTD YTD Annual Category Budget Actual Variance($) (%] Budget Actual Variance($] Variance(%) Budget %Used Salaries&Wages FTE Regular Pay $ 10,341,602 $ 9,945,144 $ 396,458 3.8% $ 10,341,602 $ 9,945,144 $ 396,458 3.8% $ 39,048,125 25.5% Temporary Pay 536,296 430,859 105,437 19.7% 536,296 430,859 105,437 19.7% 1,818,405 23.7% Premium Pay 790,459 618,667 171,792 21.7% 790,459 618,667 171,792 21.7% 3,132,718 19.7% Board Fees 16,650 13,800 2,850 17.1% 16,650 13,800 2,850 17.1% 66,600 20.7% Other (329,250) 2,019 (331,269) 100.6% (329,250) 2,019 (331,269) 100.6% (1,317,000) -0.2% Total Salaries&Wages 11,355,758 11,010,489 345,269 3.0% 11,355,758 11,010,489 345,269 3.0% 42,748,849 25.8% Employee Benefits Insurance Premiums 2,019,311 1,903,554 115,757 5.7% 2,019,311 1,903,554 115,757 5.7% 8,187,170 23.3% Employer Taxes 168,307 172,933 (4,626) -2.7% 168,307 172,933 (4,626) -2.7% 634,803 27.2% Employer Retirement Contributions 2,062,774 2,111,419 (48,645) -2.4% 2,062,774 2,111,419 (48,645) -2.4% 7,760,922 27.2% OPEB Contributions 502,750 502,750 0 0.0% 502,750 502,750 0 0.0% 2,011,000 25.0% Benefit Adjustments (1,681,500) (1,231,355) (450,145) 26.8% (1,681,500) (1,231,355) (450,145) 26.8% (6,281,681) 19.6% Total Employee Benefits 3,071,641 3,459,301 (387,660) -12.6% 3,071,641 3,459,301 (387,660) -12.6% 12,312,215 28.1% Unfunded Liability Costs Pension 15,850 16,058 (208) -1.3% 15,850 16,058 (208) -1.3% 59,784 26.9% OPEB 330,000 330,000 0.0% 330,000 330,000 0.0% 1,320,000 25.0% Total Unfunded Liability Costs 345,850 346,058 (208) -0.1% 345,850 346,058 (208) -0.1% 1,379,784 25.1% Purchased Property Services Repairs&Maintenance 1,503,405 1,192,928 310,477 20.7% 1,503,405 1,192,928 310,477 20.7% 4,117,770 29.0% Hauling&Disposal 341,675 182,545 159,130 46.6% 341,675 182,545 159,130 46.6% 1,366,700 13.4% Security 157,400 127,283 30,117 19.1% 157,400 127,283 30,117 19.1% 629,600 20.2% Rentals 60,100 55,450 4,650 7.7% 60,100 55,450 4,650 7.7% 241,500 23.0% Cleaning 123,720 124,252 (532) -0.4% 123,720 124,252 (532) -0.4% 494,880 25.1% Construction Total Purchased Property Services 2,186,300 1,682,458 503,842 23.0% 2,186,300 1,682,458 503,842 23.0% 6,850,450 24.6% (Continued on page 9) 8 1 P a g e December 1, 2022 Regular Board Meeting Agenda Packet- Page 26 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued) QTD QTD QTD QTD Variance YTD YTD YTD YTD Annual Category Budget Actual Variance($) (%) Budget Actual Variance($) Variance(%) Budget %Used Purchased Professional,Technical& Other Services Professional Services 314,580 148,433 166,147 52.8% 314,580 148,433 166,147 52.8% 1,218,318 12.2% Technical Services 1,026,287 257,723 768,565 74.9% 1,026,287 257,723 768,565 74.9% 3,914,195 6.6% Other Purchased Services 335,950 592,879 (256,929) -76.5% 335,950 592,879 (256,929) -76.5% 2,761,245 21.5% Total Purchased Professional, Technical&Other Services 1,676,817 999,035 677,782 40.4% 1,676,817 999,035 677,782 40.4% 7,893,758 12.7% Supplies&Materials Utilities&Fuel 1,527,100 1,788,254 (261,154) -17.1% 1,527,100 1,788,254 (261,154) -17.1% 6,108,400 29.3% Chemicals 586,500 568,990 17,510 3.0% 586,500 568,990 17,510 3.0% 2,346,000 24.3°/% General Supplies 1,164,150 417,074 747,077 64.2% 1,164,150 417,074 747,077 64.2% 3,951,602 10.6% Total Supplies&Materials 3,277,750 2,774,318 503,432 15.4% 3,277,750 2,774,318 503,432 15.4% 12,406,002 22.4% Other Expenses Memberships 132,326 364,518 (232,192) -175.5% 132,326 364,518 (232,192) -175.5% 578,615 63.0% Training&Meetings 167,394 80,355 87,038 52.0% 167,394 80,355 87,038 52.0% 663,125 12.1% Miscellaneous Other 46,563 38,673 7,890 16.9% 46,563 38,673 7,890 16.9% 186,250 20.8% Total Other Expenses 346,282 483,546 (137,264) -39.6% 346,282 483,546 (137,264) -39.6% 1,427,990 33.9% Total Expenses $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 85,019,046 24.4% 9 1 P a g e December 1, 2022 Regular Board Meeting Agenda Packet- Page 27 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit- Summary (by Department) QTD YTD QTD QTD QTD Variance YTD YTD YTD Variance Annual Category Budget Actual Variance($] (%] Budget Actual Variance($) (%) Budget %Used Department Executive Governance $ 656,765 $ 519,824 $ 136,940 20.9% $ 656,765 $ 519,824 $ 136,940 20.9% $ 2,778,212 18.7% Administration 5,202,656 4,976,602 226,054 4.3% 5,202,656 4,976,602 226,054 4.3% 20,283,342 24.5% Engineering and Technical Services 3,949,631 4,075,476 (125,845) -3.2% 3,949,631 4,075,476 (125,845) -3.2% 15,208,366 26.8% Operations 11,997,464 10,841,896 1,155,569 9.6% 11,997,464 10,841,896 1,155,569 9.6% 45,051,909 24.1% Recycled Water Program 453,884 341,408 112,475 24.8% 453,884 341,408 112,475 24.8% 1,697,217 20.1% Total Expenses $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 85,019,046 24.4% Year-to-Date Expenses by Department $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services ■YTD ■YTD Budget Actual 10 � Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 28 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit- Detail (by Division) 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 $ 268,041 $ 239,413 $ 28,627 10.7% $ 268,041 $ 239,413 $ 28,627 10.7% $ 1,070,246 22.4% Office of the Secretary of the District 276,904 218,952 57,952 20.9% 276,904 218,952 57,952 20.9% 1,242,671 17.6% Board of Directors 111,820 61,459 50,361 45.0% 111,820 61,459 50,361 45.0°/% 465,295 13.2% Administration Office of the Director of Finance and Administration 166,861 146,316 20,545 12.3% 166,861 146,316 20,545 12.3% 649,271 22.5% Finance Division 469,084 476,917 (7,833) -1.7% 469,084 476,917 (7,833) -1.7% 2,008,642 23.7% Human Resources Division 1,817,430 1,609,990 207,439 11.4% 1,817,430 1,609,990 207,439 11.4% 7,131,543 22.6% Purchasing Division 495,636 425,261 70,375 14.2% 495,636 425,261 70,375 14.2% 1,861,104 22.8% Risk Management Program 325,248 371,654 (46,405) -14.3% 325,248 371,654 (46,405) -14.3% 1,274,845 29.2% Public Info/Comm.Services&Intergov Relations Division 454,335 424,153 30,182 6.6% 454,335 424,153 30,182 6.6% 2,155,358 19.7% Information Technology Division 1,474,062 1,522,310 (48,249) -3.3% 1,474,062 1,522,310 (48,249) -3.3% 5,202,579 29.3% Engineering&Technical Services Office of the Director of Engineering& Technical Services 233,097 217,920 15,177 6.5% 233,097 217,920 15,177 6.5% 890,095 24.5% Planning&Developmental Services 1,661,751 1,576,208 85,543 5.1% 1,661,751 1,576,208 85,543 5.1% 6,241,012 25.3% Capital Projects Division (248,647) 58,982 (307,629) 123.7% (248,647) 58,982 (307,629) 123.7% (831,774) -7.1% Environmental&Regulatory Compliance 2,303,430 2,222,366 81,063 3.5% 2,303,430 2,222,366 81,063 3.5% 8,909,033 24.9% Operations Office of the Director of Operations 323,631 217,755 105,876 32.7% 323,631 217,755 105,876 32.7% 1,232,151 17.7% Collection System Operations Division 3,500,037 3,343,462 156,575 4.5% 3,500,037 3,343,462 156,575 4.5% 13,480,048 24.8% Treatment Plant Operations Division 3,635,086 4,101,954 (466,868) -12.8% 3,635,086 4,101,954 (466,868) -12.8°/% 14,871,590 27.6% Treatment Plant Maintenance Division 4,538,711 3,178,725 1,359,986 30.0% 4,538,711 3,178,725 1,359,986 30.0% 15,468,121 20.6% Recycled Water Recycled Water-General 46,705 26,663 20,042 42.9% 46,705 26,663 20,042 42.9% 186,818 14.3% Treatment Plant 200,850 181,108 19,742 9.8% 200,850 181,108 19,742 9.8% 803,400 22.5% Distribution System 96,450 67,838 28,612 29.7% 96,450 67,838 28,612 29.7% 385,800 17.6% Residential Fill Station 84,929 65,645 19,284 22.7% 84,929 65,645 19,284 22.7% 221,399 29.7% Satellite Water Facility 24,950 154 24,796 99.4% 24,950 154 24,796 99.4°/% 99,800 0.2% Total Expenses $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 22,260,399 $ 20,755,206 $ 1,505,193 6.8% $ 85,019,046 24.4% 111Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 29 of 157 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 4 - Sewer Construction Fund Revenues by Source - Summary Annual QTD YTD Budget QTD QTD QTD Variance Variance YTD YTD YTD Variance Annual Realized Category Budget Actual ($) (%) Budget Actual Variance($) (%) Budget (%) Sewer Service Charges $ (48,534) $ (1,912) $ 46,622 -96.1% $ (48,534) $ (1,912) $ 46,622 -96.1% $ 65,832,492 0.0% Other Capital Revenues 811,857 4,328,946 3,517,089 433.2% 811,857 4,328,946 3,517,089 433.2% 20,955,078 20.7% Total Revenue $ 763,323 $ 4,327,034 $ 3,563,711 466.9% $ 763,323 $ 4,327,034 $ 3,563,711 466.9% $ 86,787,570 5.0% Year-to-Date Revenues by Source $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $(500,000) Sewer Service Charges Other Capital Revenues Revenue Source Category ■YTD ■YTD Budget Actual 12 Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 30 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 4 - Sewer Construction Fund Revenues by Source - Detail Annual QTD YTD Budget QTD QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance($] (%) Budget Actual Variance($) (%) Budget (%) Sewer Service Charges(SSC) Over-the-Counter $ (48,534) $ 4,629 $ 53,163 -109.5% $ (48,534) $ 4,629 $ 53,163 -109.5% $ 119,500 3.9% County Allocated (6,192) (6,192) (6,192) (6,192) 64,576,280 0.0% Direct Billed - - - - 1,177,919 0.0% Prior Year Adjustment - (349) (349) - (349) (349) (41,207) 0.8% Other Capital Revenues Facilities Capacity Fees-Gravity Zone 570,551 3,790,073 3,219,521 564.3% 570,551 3,790,073 3,219,521 564.3% 4,445,000 85.3% Facilities Capacity Fees-Pump Zone 29,487 11,648 (17,839) -60.5% 29,487 11,648 (17,839) -60.5% 134,000 8.7% Capacity Use Charge 1,435 - (1,435) -100.0% 1,435 - (1,435) -100.0% 57,000 0.0% Secured Property Tax - - 7,932,078 0.0% Unsecured Property Tax 100,000 - (100,000) -100.0% 100,000 - (100,000) -100.0% 400,000 0.0% Investment Income 41,619 254,099 212,481 510.5% 41,619 254,099 212,481 510.5% 140,000 181.5% Other Government Revenue-Concord - - - - - - 7,500,000 0.0% Overtime Inspection 3,230 319 (2,911) -90.1% 3,230 319 (2,911) -90.1% 8,000 4.0% Plan Review 24,327 31,623 7,296 30.0% 24,327 31,623 7,296 30.0% 89,000 35.5% Main Lines Inspection Fees 40,959 219,010 178,051 434.7% 40,959 219,010 178,051 434.7% 249,000 88.0% Rebates to District - - - - - - - Other Agency Reimbursement - - - - - Miscellaneous Income 250 (250) -100.0% 250 - (250) -100.0% 1,000 0.0% Alhambra Valley Assessment District - 38,115.00 38,115 - 38,115 38,115 - Contractual Assessment District (15,940.21) (15,940) (15,940) (15,940) Total Revenues $ 763,323 $ 4,327,034 $ 3,563,711 466.9% $ 763,323 $ 4,327,034 $ 3,563,711 466.9% $ 86,787,570 5.00/0 131Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 31 of 157 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 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 I 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 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 400,000 37,250,000 55,382,192 3,116,002 52,266,190 Treatment Plant(TP) 96,390,332 54,872,388 41,517,944 39,981,000 300,000 40,281,000 81,798,923 3,690,912 78,108,011 General Improvements(GI) 19,896,459 16,655,259 3,241,200 3,795,000 - 3,795,000 7,037,349 161,930 6,875,419 Recycled Water(RW) 32,854,000 28,737,307 4,116,693 8,715,000 8,715,000 12,831,693 406,513 12,425,180 CIB Contingency - - - 1,635,000 (700,000) 935,000 935,000 - 935,000 Total $ 224,715,032 $ 157,707,003 $ 67,008,029 $ 90,976,000 $ - $ 90,976,000 $ 157,985,157 $ 7,375,357 $ 150,609,800 Capital Improvement Budget Quarterly Results by Program $90,000,000 $80,000,000 $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 -1" $20,000,000 .04' $10,000,000 ""4# Collection System Treatment Plant General Recycled Water CIB Contingency (CS) (TP) Improvements (RW) (GI) Program ■Approved Expenditures ■Actual Expenditures 14Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 32 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project) A B CIA-B) D E F D+E G C+D+E H I G-H Cumulative I 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 Budgets Actuals FY 2022-23 Budget Adjustments Bud et 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,740,000 4,874,652 78,259 4,796,393 8419 Collection System Planning LT 1,585,000 1,409,671 175,329 200,000 - 200,000 375,329 33,779 341,550 8436 Moraga/Crossroads PS Project 35,451,000 34,219,528 1,231,472 - - - 1,231,472 688,569 542,903 8442 PS Equipment Piping ReplacementPH2 564,000 428,844 135,156 206,000 - 206,000 341,156 - 341,156 8443 LG Diameter Pipe line Inspection 1,795,000 253,940 1,541,060 - - - 1,541,060 81,849 1,459,211 8444 Force Main Inspection Program 1,125,000 18,132 1,106,868 - - - 1,106,868 - 1,106,868 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 - 972,842 *8449 Collection System Modeling Support 543,000 177,141 365,859 - - - 365,859 5,206 360,653 8450 Development Sewerage Support 4,032,316 4,019,314 13,002 927,000 - 927,000 940,002 250,789 689,213 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 124,057 14,166,712 8463 No.Orinda Sewer Renov.PH.8 4,304,000 3,925,644 378,356 - - - 378,356 358,690 19,666 8464 Martinez Sewer Renov.Ph.7 2,500,000 556,689 1,943,311 2,500,000 - 2,500,000 4,443,311 64,563 4,378,748 8465 WC Sewer Renov.Ph.15 5,400,000 4,121,806 1,278,194 - - - 1,278,194 276,714 1,001,480 8466 Danville Sewer Ren.Ph.4 1,500,000 1,576,565 (76,565) 3,702,000 - 3,702,000 3,625,435 439,758 3,185,677 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 - 100,000 932,940 35,857 897,083 100007 Large Diameter Priping Renovation Program 2,000,000 302 1,999,698 - - - 1,999,698 - 1,999,698 100017 SR Pump Station Electrical Upgrades 700,000 129,110 570,890 1,213,000 - 1,213,000 1,783,890 111,579 1,672,311 *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) - - - (93,164) 340,621 (433,785) 100024 South Orinda Sewer Renovation Ph.9 500,000 451,521 48,479 - - - 48,479 96,375 (47,896) 100025 Lafayette Sewer Renov.Ph.15 500,000 228,951 271,049 - - - 271,049 70,732 200,317 100028 Collection System Master Plan 2021 Update 750,000 54,534 695,466 850,000 - 850,000 1,545,466 35,565 1,509,901 100037 Orinda Moraga PS Architectual Improvements 200,000 12,609 187,391 1,250,000 - 1,250,000 1,437,391 4,414 1,432,977 **100038 San Pablo Watershed Improvements - - - - 200,000 200,000 200,000 7,682 192,318 100039 Collection System Sewere Renovation Ph.2 - - - 9,410,000 - 9,410,000 9,410,000 9,897 9,400,103 **100041 Buchanan Lift Station Replacements&Improvemei - - - - 200,000 200,000 200,000 496 199,504 **100042 Pump Station Upgrades,Phase 2B - - - - 200,000 200,000 200,000 551 199,449 100044 Collection System Modeling Support FY 22+ - - - 120,000 - 120,000 120,000 - 120,000 Rounding Total CS Program $ 75,574,241 57,442,049 18,132,192 36,850,000 400,000 37,250,000 55,382,192 3,116,002 52,266,190 * Projects open but not in CIB for 22/23 ** Not in 22/23 Budget New projects.Funds transferred from other projects or Contingency 151Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 33 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B CIA-B) D E F D+E) G C+D+E H I G-H Cumulative I Cumulative Total Project FY 2022-2023 I 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 Budgets Actuals FY 2022.23 Budget Adjustments Budget Expenditures Expenditures Bud et TYPE TP Treatment Plant 7315 Applied Research and Innovations 1,657,274 1,299,075 358,199 300,000 - 300,000 658,199 47,776 610,423 7328 Influent Pump Electrical improvements 8,160,000 8,665,855 (505,855) 1,426,000 - 1,426,000 920,145 438,956 481,189 7341 WC/Grayson Creek Levee Rehab 1,050,000 630,015 419,985 1,500,000 - 1,500,000 1,919,985 10,281 1,909,704 7348 Solids Handling Facility Improvements 34,518,687 18,436,325 16,082,362 5,000,000 - 5,000,000 21,082,362 1,027,016 20,055,346 7349 Aeration&Energy Upgrade 5,350,000 4,462,963 887,037 500,000 - 500,000 1,387,037 61,970 1,325,067 7357 Plant Wide Instrumentation Upgrade 1,421,000 110,484 1,310,516 - - - 1,310,516 - 1,310,516 7363 Treatment Plant Planning 2,100,000 1,692,414 407,586 200,000 - 200,000 607,586 41,561 566,025 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 133,713 3,424,881 7370 Annual Infrastructure Replacement 3,605,000 1,991,444 1,613,556 1,000,000 - 1,000,000 2,613,556 109,930 2,503,626 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 28,815 546,621 7375 Contractor Staging Improvements 5,200,000 4,475,037 724,963 - 300,000 300,000 1,024,963 470,111 554,852 100001 UPCAA Urgent Projects FY 2020-25 1,200,000 176,995 1,023,005 600,000 - 600,000 1,623,005 27,085 1,595,920 100008 Laboratory Roof&Seismic upgrades 950,000 96,086 853,914 500,000 - 500,000 1,353,914 15,814 1,338,100 100009 Hearth Replacement 500,000 265,797 234,203 - - - 234,203 11,079 223,124 100010 Air Condiditioning&Lighting Renovation 1,250,000 646 1,249,354 - - - 1,249,354 43,570 1,205,784 100011 Plant Electrical Replacement&Rehabilitation 408,371 211,278 197,093 400,000 - 400,000 597,093 2,204 594,889 100012 UV Disinfection Replacement 2,500,000 1,239,101 1,260,899 3,500,000 - 3,500,000 4,760,899 221,860 4,539,039 *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 25,553 1,443,819 100015 Electric Blower Improvements 9,150,000 5,896,057 3,253,943 4,245,000 - 4,245,000 7,498,943 607,394 6,891,549 100018 Outfall Monitoring Improvements 610,000 218,980 391,020 - - - 391,020 91,777 299,243 100019 Aeration Basins Diffuer Replacement and Seismic l 2,300,000 832,698 1,467,302 7,500,000 - 7,500,000 8,967,302 59,947 8,907,355 100022 Wet Weather Basin Improvements 700,000 300,667 399,333 600,000 - 600,000 999,333 16,399 982,934 100030 Solids Handling Facility Improvements Ph.2 3,600,000 191,043 3,408,957 3,100,000 - 3,100,000 6,508,957 143,965 6,364,992 100032 Steam Renovations,Ph.1 500,000 21,645 478,355 4,500,000 - 4,500,000 4,978,355 35,668 4,942,687 100034 TP Safety Enhancemems 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 2,452 197,548 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 Rounding (21) (16) Total TP Program $ 96,390,332 $ 54,872,388 $ 41,517,944 $ 39,981,000 $ 300,000 $ 40,281,000 $ 81,798,923 $ 3,690,912 $ 78,108,016 * Projects open but not in CIB for F22/23 161Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 34 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 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 I 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 Budgets Actuals FY 2022-23 Bud et 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 8,180 14,251 8240 IT Development 4,488,794 4,002,443 486,351 500,000 - 500,000 986,351 - 986,351 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 8,386 417,758 8252 POB E.V.Charging Station 490,000 21,749 468,251 150,000 - 150,000 618,251 - 618,251 8253 COVID-19 Response 275,000 113,510 161,490 - - - 161,490 41,097 120,393 8516 District Equipment Acquisition 1,476,000 1,271,897 204,103 250,000 - 250,000 454,103 33,548 420,555 8517 Vehicle Replacement Program 4,718,000 4,373,000 345,000 900,000 - 900,000 1,245,000 - 1,245,000 100003 Property Repairs&Improvements 450,000 276,634 173,366 700,000 - 700,000 873,366 35,748 837,618 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 - 83,822 100031 Community Dev.System Replacement 200,000 24,949 175,051 400,000 - 400,000 575,051 17,431 557,620 100033 Security Improvements FY 2021-25 200,000 45,266 154,734 100,000 - 100,000 254,734 4,172 250,562 100035 Technology Strategic Plan 500,000 302 499,698 500,000 - 500,000 999,698 - 999,698 100043 Easement Acquisition FY 2022-31 - - - 75,000 - 75,000 75,000 2,267 72,733 9999 Capital Project Clearing(Accounting Use Only) - 1,149 (1,149) - - - - 11,101 (11,101) Rounding - (2) Total GI Program $ 19,896,459 16,655,259 3,241,200 3,795,000 3,795,000 7,037,349 161,930 6,875,417 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 402,743 9,799,187 7366 ReW Distribution System Renov.Program 715,000 196,187 518,813 215,000 - 215,000 733,813 2,319 731,494 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,451 1,436,636 100036 Zone 1 Recycled Water 2021 100,000 - 100,000 100,000 - 100,000 200,000 - 200,000 Rounding (1) Total RW Program $ 32,854,000 28,737,307 4,116,693 8,715,000 8,715,000 12,831,693 406,513 12,425,179 9990 CONTINGENCY-ALL PROGRAMS 1,635,000 (700,000) 935,000 935,000 935,000 GRAND TOTAL $ 224,715,032 157,707,003 67,008,029 90,976,000 90,976,000 157,985,157 7,375,357 150,609,802 171Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 35 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 5 - Self Insurance Fund Revenues by Source Annual QTD YTD Budget QTD QTD QTD Variance Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual ($) (%) Budget Actual Variance($) (%) Budget (%) Sewer Service Charge $ $ $ $ $ $ $ 1,662,101 0.0% Insurance Recoveries(HHW) 25,000 0.0% Investment Income 2,350 32,482 30,132 1282.2% 2,350 32,482 30,132 1282.2% 47,400 68.5% Total Revenues $ 2,350 $ 32,482 $ 30,132 1282.2% $ 2,350 $ 32,482 $ 30,132 1282.2% $ 1,734,501 1.9% Year-to-Date Revenues by Source $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 Sewer Service Charge Insurance Recoveries(HHW) Investment Income Revenue Source Category ■YTD ■ YTD Budget Actual 18Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 36 of 157 AMILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 5 - Self Insurance Fund Expenses by Type 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 $ 63,702 $ 30,048 32.1% $ 93,750 $ 63,702 $ 30,048 32.1% $ 375,000 17.0% Technical Services 15,000 - 15,000 100.0% 15,000 - 15,000 100.0% 60,000 0.0% Insurance&Risk Management 433,750 1,242,576 (808,826) -186.5% 433,750 1,242,576 (808,826) -186.5% 1,735,000 71.6% Total Expenses $ 542,500 $ 1,306,278 $ (763,778) -140.8% $ 542,500 $ 1,306,278 $ (763,778) -140.8% $ 2,170,000 60.2% 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 19Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 37 of 157 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 6 - Debt Service Fund Revenues by Source Annual QTD YTD Budget QTD QTD QTD Variance Variance YTD YTD YTD Revenue Annual Realized Category Budget Actual ($) (%) Budget Actual Variance($) (%) Estimate (%) Tax Revenue $ 5,800,977 $ 5,511,634 $ (289,343) -5.0% $ 12,891,059 $ 12,497,305 $ (393,754) -3.1% $ 12,891,059 Investment Income - 20,353 20,353 Total Revenues $ 5,800,977 $ 5,511,634 $ (289,343) -5.0% $ 12,891,059 $ 12,517,658 $ (373,401) -2.9% $ 12,891,059 97.1% Year-to-Date Revenues by Source $13,000,000 $11,000,000 $9,000,000 $7,000,000 $5,000,000 $3,000,000 $1,000,000 $(1,000,000) Tax Revenue Investment Income ■ YTD ■ YTD Budget Actual 20Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 38 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 6 - Debt Service Fund Expenses by Type Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Variance Annual Variance Category Budget Actual QTD Variance($) (%) Budget Actual Variance($) (%) Estimate (%) Professional Services $ 625 $ - $ 625 100.0% $ 625 $ - $ 625 100.0% $ 2,500 0.0% Principal Payment Expense 10,750,000 10,750,000 - 0.0% 10,750,000 10,750,000 - 0.0% 10,750,000 100.0% Interest Expense 1,381,405 460,468 920,937 66.7% 1,381,405 460,468 920,937 66.7% 2,499,422 542.8% Total Expenses $ 12,132,030 $ 11,210,468 $ 921,562 7.6% $ 12,132,030 $ 11,210,468 $ 921,562 7.6% $ 13,251,922 84.6% 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 21Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 39 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 7 - Quarterly Investment Portfolios Operating&Maintenance Fund QTDYTD 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) $ 10,900,000 $ 16,900,000 $ (6,000,000) $ 10,900,000 $ 10,768,463 60.89% $ 49,634 $ 49,634 RE17 UST-Bill US Treasury 1/21/2022 7/21/2022 0 0.330% 10,482,579 10,500,000 (10,500,000) $ - - 0.00% 1,925 $ 1,925 RE19 FHLB US Fed Agency 5/19/2022 8/17/22 0 1.093% 3,989,100 4,000,000 (4,000,000) $ - - 0.00% 5,692 $ 5,692 RE20 US T-Bill US Fed Agency 5/19/2022 11/17/22 48 1.495% 3,969,768 4,000,000 - $ 4,000,000 3,985,880 22.35% 15,282 $ 15,282 RE21 FHLB US Fed Agency 5/19/2022 5/17/23 229 2.174% 1,468,086 1,500,000 - $ 1,500,000 1,464,210 8.38% 8,088 $ 8,088 RE22 UST Notes US Treasury 5/19/2022 4/30/24 578 2.661% 1,497,366 1,500,000 $ 1,500,000 1,460,518 8.38% 340 $ 340 (3) $ 32,306,899 $ 38,400,000 $(20,500,000) $ 17,900,000 $ 17,679,071 100.00% 80,962 80,962 (2) (4) (8) 66 $ 80,962 $ 81,028 Legend: EOQ=End of quarter BOQ=Beginning of quarter YTD=Year to Date Notes (1)Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund.The estimated yield as of September,2022 was 1.52%. (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 1.665%.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 September 30,2022 was$17,679,071.GASB 31 requires adjusting investments to market value.The District will adjust annually,but report market values quarterly. (5)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)] (6)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)] (7)Of the total investments held in the Running Expense Fund,$6,460,000 is restricted for the Rate Stabilization Fund Account. (8)Amount represents interest income from prior period investments. 221Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 40 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 7 - Quarterly Investment Portfolios Sewer Construction 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 LAW 8/86-2/90 n/a n/a (1) $ 23,000,000 $ 36,000,000 $ (13,000,000) $ 23,000,000 $ 22,722,446 37.70% $ 95,271 $ 95,271 960 US T Bill US Treasury 1/21/2022 7/21/2022 0 0.33% 12,479,260 12,500,000 (12,500,000) - - 0.00% 2,292 2,292 961 US T Bill US Treasury 1/21/2022 1/15/2025 838 1.26% 2,490,505 2,500,000 - 2,500,000 2,329,600 4.10% 801 801 962 US T Bill US Treasury 5/19/2022 11/17/2022 48 1.50% 14,886,629 15,000,000 - 15,000,000 14,947,050 24.59% 57,308 57,308 963 FHLB US Fed Agency 5/19/2022 5/17/2023 229 2.17% 12,723,414 13,000,000 - 13,000,000 12,689,820 21.31% 70,099 70,099 964 UST Notes US Treasury 5/19/2022 4/30/2024 578 2.66% 2,495,610 2,500,000 - 2,500,000 2,434,197 4.10% 567 567 965 FHLB US Fed Agency 8/12/2022 8/11/2023 315 3.28% 4,840,244 5,000,000 5,000,000 4,835,500 8.20% 21,506 21,506 (3) $ 72,915,662 $ 81.500,000 _L[2 $ 61.000,000 _L_12258 100.00% 247,844 247,844 (2) (4) (8) 6,356 $ 247,844 $ 254,200 Legend: EOQ=End of quarter BOQ=Beginning of quarter YTD=Year to Date Notes: (1)Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund.The estimated yield as of September,2022 was 1.52%. (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 1.834%.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 September 30,2022 was$59,958,613.GASB 31 requires adjusting investments to market value.The District will adjust annually,but report market values monthly. (6)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)] (7)Of the total investments held in the Sewer Construction Fund,$1,000,000 is restricted for the Rate Stabilization Reserve Account. (8)Amount represents investment income from prior period investments. 231Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 41 of 157 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 7 - Quarterly Investment Portfolios Self Insurance Fund QTD YTD Purchase Maturity Days to 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. LAW 10/99- n/a n/a (1) $ 9,100,000 $ 11,100,000 $ (2,000,000) $ 9,100,000 $ 8,990,185 100.00% $ 30,523 $ 30,523 (3) $ 9,100,000 $ 11,100,000 $ (2,000,000) $ 9,100,000 $ 8,990,185 100.00% 30,523 30,523 (2) (4) (7) $ 30,523 $ 30,523 Legend: EOQ=End of quarter BOQ=Beginning of quarter YTD=Year to Date Notes: (1)Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund.The estimated yield as of September,2022 was 1.52%. (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 1.52%. (4)The market value of the portfolio on September,2022 was$8,990,185. (5)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)] (6)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)] (7)Amount represents interest income from prior period investments. 241Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 42 of 157 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 8 - Financial Performance Metric Charts O&M Fund Cashflow Forecast FY 2022-23 Running Expense Fund Total Cash & Investment Balances (Actuals through Sept 2022) $70.0 $60.0 $51.4 $50.0 $45.7 $45.4 $37.6 $40.0 $3 $38.01 $37.7 $39.3 34.3 $34.2 � X33.9 $31.6� $30.0 $29.0 $28.0 $28.2 $29.2 �s.s $20.0 $ $10.0 $0.0 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 December 1, 2022 Regular Board Meeting Agenda Packet- Page 43 of 157 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast FY 2022-23 Sewer Construction Fund Total Cash & Investment Balances (Actuals through Sept 2022) $120.0 $100.0 $93.8 591.4 $86.5 $87.1 581.8 $80.0 $79.3 $78.3 $78.8 �7 $75.0 $72.8 $70.0 $71.2 $65.0 $65.9 $643 $60,0 $57.2 $43. $41.8 $40.0 $20.0 $24.5 $0.0 June'22 July August September October November December January February March April May June IIIIIIIIIIIIProjected 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 December 1, 2022 Regular Board Meeting Agenda Packet- Page 44 of 157 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 8 - Financial Performance Metric Charts Staffing Trends 300 5.8%vacanc Rate 295 290 w 285 17 a� 280 275 CV E 270 265 277271 273 260 255 250 9/30/19 9/30/20 9/30/21 9/30/22 Quarter Ended ■Filled Positions(FTEs) ■Vacancies(FTEs) 27Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 45 of 157 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated Historical Quarterly 0&M Cost per Million Gallons Treated $5,000 $4,247 $4,500 $3,413 $3,449 $3,374 $4,000 $3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 9/30/19 9/30/20 9/30/21 9/30/22 First Quarter of Fiscal Year 28Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 46 of 157 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 8 - Financial Performance Metric Charts Capital Spending Trend $180 $160 $158.OM $140 $120 $142.2M 0 $100 c $80 — $60 $40 $20 — $7.4M o ooe< be< SeQ e 1�10 e Oe e 4e —Projected(100%spend)* —Actual —Target** NOTES: *Includes unspent rollover appropriations from prior year budget. **90%of budget,including rollover appropriations from prior years. 29Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 47 of 157 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending September 30, 2022 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed/ Renovated 4.0 3.5 0 3.0 y 2.5 0 2.0 1.8 2.0 1.7 a. a. 0 1.5 1.0 1.0 0.5 0.5 "I, I 1 - 0 0.0 Cl I30��'� 1`LI31Iti� 3131I�'3 blgO�0'� Quarter Ending ■Actual Construction ■Target("S-Curve"of 6 mi.FY 22-23 Budget Projection) 30Page December 1, 2022 Regular Board Meeting Agenda Packet- Page 48 of 157