Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
04.f. Receive quarterly financial reivew for quarter ending December 31, 2022
Page 1 of 34 Item 41 CENTRAL SAN Y-109-ITMEN ME February 21, 2023 TO: FINANCE COMMITTEE FROM: KEVIN MIZUNO, FINANCE MANAGER CHRISTOPHER THOMAS, ACCOUNTING SUPERVISOR REVIEWED BY: PHILIP LEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE QUARTERLY FINANCIAL REVIEW FOR QUARTER ENDING DECEMBER 31, 2022 Attached is the Quarterly Financial Review for the first quarter of Fiscal Year(FY) 2022-23 ending December 31, 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. Presentation February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 136 of 198 . . uarterFinancial _s CENTRAL SAN Review rw AM i Im �I ISI, -- � , El_iJL�• 1 -- .`. _ � ®i,��,� � �� �j�� � .� 1. ,lei �� � _ February 21, 2023 Regular FINANCE Committee Meeting Agenda PacketEnded December 31 , 2022 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 138 of 198 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 139 of 198 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 second quarter of FY 2022-23 ended December 31, 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$40.1 million, which is approximately $2.2 million (5.3%) under the projected year-to-date FY 2022-23 budget. This favorable expense variance, largely attributable to lower than projected year-to-date spending in the other purchased services, purchased property services, and supplies and materials categories, is smaller than the favorable annual budget variance reported in the first quarter of the prior year of 6.8%. 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$1.8 million (47.3%). In the aggregate, the 0&M Fund is reporting a favorable revenue variance of approximately $0.9 million, which is approximately 3.1% 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$25.7 million, or 28.2% of the total adopted budget of $91.0 million. While the Sewer Construction fund's FY 2022-23 adopted budget was $91.0 million, when including carryforward capital project appropriations from the prior year of$67.0 million the total adjusted budget for FY 2022-23 is $158.0 million. The significant budgetary rollover was primarily caused by two factors: (1) continued global supply-chain difficulties that caused by international responses to the COVID-19 pandemic as well as the Russia-Ukraine conflict, and (2) postponements to the large debt-financed Solids Handling Facilities Improvement Project as Central San 11Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 140 of 198 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 1 -Executive Summary weighed the alternatives to continuing with long-standing incineration methods. After factoring in the carryforward,the year- to-date capital spending rate is 16.3% of total approved expenditures. The bulk of the FY 2022-23 year-to-date capital spending budget variance by spend amount is in the Treatment Plant program, followed by the Collection System program, which is attributable to various projects as shown in pages 15 through 17 of this report. Central San weighed the impacts of the aforementioned two major issues on its 10-year long-term Capital Improvement Plan as presented to the Board in the January 12, 2023 rates workshop. Primary outcomes of this were a reduction to the anticipated FY 2023-24 capital improvement budget (CIB) as well as a planned reduction in the FY 2022-23 capital spend carryforward. Following a thorough analysis of capital project statuses, engineering staff anticipate a reduction in the FY 2022-23 carryforward by approximately $28.9 million. Rather than these unspent project appropriations carrying forward into the FY 2023-24 CIB, this amount will roll into Sewer Construction fund reserves to finance anticipated needs in future years as projected in the 10-year financial plan (FY 2024-25 and onward). On the revenue side, the Sewer Construction Fund is currently reporting revenues of $62.3 million, in excess of the year-to- date budget amount of$57.9 million by $4.4 million (7.6%). The bulk of this variance is attributable to facilities capacity fees, which reported a favorable variance of $2.9 million, already $1.0 million above the total annual budget for this line item. Another noteworthy development this quarter was Central San receiving $13.8 million in State Revolving Fund (SRF) Loan Proceeds for work completed on the Solids Handling Project in previous fiscal years. This is the first allocation of SRF funds Central San has received, with an additional $28.2 million projected to be received by the close of the fiscal year per the adopted budget. Investment Portfolio Highlights In accordance with Section 53646 of the California Government Code as well as Central San's Investment Policy, the Finance Division is required to submit an investment report to the General Manager and Board of Directors at least quarterly. The investments held by Central San for the quarter ended December 31, 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 2 1 P a g e February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 141 of 198 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 1 -Executive Summary 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 $203,267 of income which is above the year-to-date revenue estimate of $129,000 by 57.6%. The Sewer Construction Fund portfolio is reporting $603,825 of income, also well over the year-to-date revenue estimate of$95,681 by 531.1%. Both of these significant budgetary variances are attributable to several Fed interest rate hikes in 2022 to attempt to curb inflation, the extent of which were unknown and unanticipated when the FY 2022-23 budget was developed. During FY 2022-23 the Finance Division has recently made diversification of the investment portfolio outside of LAIF a top priority which has led to the acquisition of more U.S. Treasury Bills and Federal Agency securities, which in turn has helped drastically increase the weighted average yield of the portfolio thus far in FY 2022-23. As of December 31, 2022, Central San continues to hold about 40% of its investment portfolio, or $66.5 million, in the Local Agency Investment Fund (LAIF) state investment pool, under the maximum amount permitted to be held in the pool of$75.0 million. The Fed has continued its trend of aggressive normalization away from historically low interest rates that started in calendar year 2022. In this quarter, the Fed issued a 75-point and a 50-point rate hike, resulting in a target rate of 4.5 - 4.75% as of the quarters end, which does not include an additional rate hike of 25-points approved in January 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. Central San's diversified portfolio, which includes U.S. Treasury Bills and Federal Agency Notes with maturity dates ranging from 6 to 36 months, continues to benefit from these interest rate hikes. While staff does intend to continue exploring investment alternatives, it is stressed that given the restricted nature of municipal investing, additional efforts may not yield significant results to Central San's bottom line, with the 0&M investment earnings contributing less than 0.2% to total budgeted revenues for FY 2022-23. Central San's investment portfolio is in compliance with the Board's adopted policy regarding investments as of the quarter ended December 31, 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 February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 142 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 27,864,607 $ 28,736,504 $ 871,897 3.1% $ 69,762,907 41.2% Sewer Construction 57,898,023 62,275,585 4,377,562 7.6% 128,787,570 48.4% Self Insurance 1,666,801 1,741,586 74,785 4.5% 1,734,501 100.4% Debt Service 7,288,557 7,380,966 92,408 1.3% 13,251,922 55.7% Total $ 94,717,988 $ 100,134,641 $ 5,416,653 $ 213,536,900 Fund Expenses 0&M $ 42,372,015 $ 40,136,758 $ 2,235,257 5.3% $ 85,019,046 47.2% Sewer Construction 68,569,003 25,683,080 42,885,923 62.5% 157,985,157 16.3% Self Insurance 1,085,000 1,521,952 (436,952) -40.3% 2,170,000 70.1% Debt Service 12,132,655 11,216,268 916,387 7.6% 13,251,922 84.6% Total $ 124,158,673 $ 78,558,058 $ 45,600,615 $ 258,426,125 YTD Budget-to-Actual Revenues by Fund YTD Budget-to-Actual Expenses by Fund $70,000,000 $45,000,000 $60,000,000 $40,000,000 $50,000,000 $35,000,000 $40,000,000 $30,000,000 $25,000,000 $30,000,000 $20,000,000 $20,000,000 $15,000,000 i $10,000,000 $10.000,000 $5,000,000 0&M Sevrer Construction Self-u— Debt Service 0&M Sewer Cortstruaion Selflnsurance Debt Service Fund Fund Budget Actual Budges Actual 4Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 143 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 26,293,298 $ 26,605,405 $ 312,107 1.2% $ 26,306,975 $ 26,780,263 $ 473,288 1.8% $ 47,162,407 56.8% Sewage Treatment Cost Sharing - (51,459) (51,459) (53,384) (51,459) 1,925 -3.6% 17,600,000 -0.3% Miscellaneous Service Charge 206,461 253,173 46,712 22.6% 336,212 443,726 107,515 32.0% 2,159,000 20.6% Non-Operating Revenues: Permit and Inspection Fees 419,434 498,092 78,659 18.8% 822,615 899,396 76,781 9.3% 1,799,500 50.0% Other Non Operating Income 150,714 206,859 56,145 37.3% 323,190 443,069 119,879 37.1% 780,000 56.8% Investment Income 66,000 140,481 74,481 112.8% 129,000 221,509 92,509 71.7% 262,000 84.5% Total Revenue $ 27,135,906 $ 27,652,551 $ 516,644 1.9% $ 27,864,607 $ 28,736,504 $ 871,897 3.1% $ 69,762,907 41.2% Year-to-Date Revenues by Source $27,000,000 ' $22,000,000 $17,000,000 $12,000,000 $7,000,000 „r $2,000,000 -sewer Service Charge Revenue Sewage Treatment Cost Miscellaneous Service Charge Permit and Inspection Fees Other Non Operating Income Investment Income $(3,000,000) Sharing Revenue Source Category ■YTD ■YTD Budget Actual 5 � Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 144 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 108,591 $ 87,716 420.2% $ 41,750 $ 347,244 $ 305,494 731.7% $ 83,500 415.9% Sewer Service Charge County 25,456,540 25,657,644 201,104 0.8% 25,456,540 25,597,257 140,717 0.6% 46,284,619 55.3% Sewer Service Charge Direct 823,081 838,842 15,761 1.9% 823,081 838,842 15,761 1.9% 823,081 101.9% Sewer Service Charge Prior (7,198) 329 7,527 -104.6% (14,397) (3,080) 11,316 -78.6% (28,793) 10.7% Sewage Treatment Cost Sharing - (51,459) (51,459) (53,384) (51,459) 1,925 -3.6% 17,600,000 -0.3% Miscellaneous Service Charges Septic Tank Dumping 8,270 7,610 (660) -8.0% 27,733 22,058 (5,676) -20.5% 40,000 55.1% Sales - 290 290 91 600 509 560.0% 1,000 60.0% Other Service Charges - 10,508 10,508 20,729 10,508 (10,221) -49.3% 210,000 5.0% Recycled Water 139,041 112,540 (26,501) -19.1% 221,683 279,713 58,030 26.2% 445,000 62.9% Satellite Water Recycling - - - - - - - Stormwater Program 51,025 114,843 63,818 125.1% 51,025 114,843 63,818 125.1% 415,000 27.7% Household Hazardous Waste 8,125 7,382 (743) -9.1% 14,950 16,005 1,055 7.1% 1,048,000 1.5% Permit&Inspection Fees Permit/Application Fees 106,973 166,119 59,146 55.3% 215,222 287,970 72,748 33.8% 480,000 60.0% Overtime Inspection 3,522 90 (3,432) -97.5% 4,307 1,042 (3,265) -75.8% 9,500 11.0% Side Sewer Inspection 271,031 277,608 6,577 2.4% 556,055 547,384 (8,671) -1.6% 1,160,000 47.2% Industrial Permit Fees 32,085 35,549 3,464 10.8% 32,085 35,549 3,464 10.8% 110,000 32.3% New Industry Permit Fees 2,605 13,960 11,355 436.0% 8,130 17,237 9,107 112.0% 15,000 114.9% Annexation Charges 3,218 4,767 1,549 48.1% 6,817 10,215 3,398 49.8% 25,000 40.9% Other Non-Operating Income MVSD P2 Program 3,177 6,750 3,573 112.4% 3,177 6,750 3,573 112.4% 28,000 24.1% Pretreatment Program Fine 500 - (500) -100.0% 1,000 18,000 17,000 1700.0% 2,000 900.0% Lease Rental Income 131,897 143,769 11,872 9.0% 302,312 318,432 16,119 5.3% 740,000 43.0% Miscellaneous Income 15,139 41,786 26,647 176.0% 16,701 73,170 56,470 338.1% 10,000 731.7% Right of Way Fees - 4,029 4,029 - 6,567 6,567 - Reimbursements - 10,525 10,525 - 20,150 20,150 - Investment Income 66,000 140,481 74,481 112.8% 129,000 221,509 92,509 71.7% 262,000 84.5% Total Revenues $ 27,135,906 $ 27,652,551 $ 516,644 1.9% $ 27,864,607 $ 28,736,504 $ 871,897 3.1% $ 69,762,907 41.2% 6 1 P a g e February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 145 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 9,777,562 $ 9,491,065 $ 286,497 2.9% $ 21,133,320 $ 20,501,554 $ 631,766 3.0% $ 42,748,849 48.0% Employee Benefits 2,845,955 3,174,305 (328,350) -11.5% 5,917,596 6,633,606 (716,010) -12.1% 12,312,215 53.9% Unfunded Liability Costs 343,646 843,326 (499,679) -145.4% 689,496 1,189,383 (499,887) -72.5% 1,379,784 86.2% Purchased Property Services 1,554,350 1,398,979 155,371 10.0% 3,740,650 3,081,437 659,213 17.6% 6,850,450 45.0% Other Purchased Services 2,194,400 1,040,758 1,153,642 52.6% 3,871,217 2,039,793 1,831,424 47.3% 7,893,758 25.8% Supplies&Materials 3,042,750 3,152,345 (109,595) -3.6% 6,320,501 5,926,664 393,837 6.2% 12,406,002 47.8% Other Expenses 352,952 280,774 72,178 20.4% 699,235 764,320 (65,086) -9.3% 1,427,990 53.5% Total Expenses $ 20,111,616 $ 19,381,552 $ 730,064 3.60/. $ 42,372,015 $ 40,136,758 $ 2,235,257 5.3% $ 85,019,046 47.2% Year-to-Date Expenses by Type $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Salaries&Wages Employee Benefits Unfunded Liability Purchased Property Other Purchased Supplies&Materials Other Expenses Costs Services Services Department ■YTD ■ YTD Budget Actual 7Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 146 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 8,925,484 $ 8,437,194 $ 488,290 5.5% $ 19,267,086 $ 18,382,338 $ 884,748 4.6% $ 39,048,125 47.1% Temporary Pay 390,826 330,603 60,223 15.4% 927,122 761,462 165,660 17.9% 1,818,405 41.9% Premium Pay 773,852 710,428 63,424 8.2% 1,564,312 1,329,095 235,217 15.0% 3,132,718 42.4% Board Fees 16,650 11,400 5,250 31.5% 33,300 25,200 8,100 24.3% 66,600 37.8% Other (329,250) 1,440 (330,690) 100.4% (658,500) 3,459 (661,959) 100.5% (1,317,000) -0.3% Total Salaries&Wages 9,777,562 9,491,065 286,497 2.9% 21,133,320 20,501,554 631,766 3.0% 42,748,849 48.0% Employee Benefits Insurance Premiums 1,984,021 1,928,994 55,026 2.8% 4,003,331 3,832,548 170,784 4.3% 8,187,170 46.8% Employer Taxes 145,630 149,080 (3,450) -2.4% 313,937 322,014 (8,076) -2.6% 634,803 50.7% Employer Retirement Contributions 1,655,516 1,665,055 (9,538) -0.6% 3,718,290 3,776,474 (58,184) -1.6% 7,760,922 48.7% OPEB Contributions 502,750 502,750 0 0.0% 1,005,500 1,005,500 0 0.0% 2,011,000 50.0% Benefit Adjustments (1,441,962) (1,071,943) (370,019) 25.7% (3,123,463) (2,303,298) (820,165) 26.3% (6,281,681) 36.7% Total Employee Benefits 2,845,955 3,173,936 (327,982) -11.5% 5,917,596 6,633,237 (715,641) -12.1% 12,312,215 53.9% Unfunded Liability Costs Pension 13,646 13,326 321 2.4% 29,496 29,383 113 0.4% 59,784 49.1% OPEB 330,000 830,000 (500,000) -151.5% 660,000 1,160,000 (500,000) -75.8% 1,320,000 87.9% Total Unfunded Liability Costs 343,646 843,326 (499,679) -145.4% 689,496 1,189,383 (499,887) -72.5% 1,379,784 86.2% Purchased Property Services Repairs&Maintenance 871,455 850,692 20,763 2.4% 2,374,860 2,043,620 331,240 13.9% 4,117,770 49.6% Hauling&Disposal 341,675 179,412 162,263 47.5% 683,350 361,957 321,393 47.0% 1,366,700 26.5% Security 157,400 143,597 13,803 8.8% 314,800 270,880 43,920 14.0% 629,600 43.0% Rentals 60,100 95,871 (35,771) -59.5% 120,200 151,322 (31,122) -25.9% 241,500 62.7% Cleaning 123,720 128,657 (4,937) -4.0% 247,440 252,909 (5,469) -2.2% 494,880 51.1% Construction 750 (750) 750 (750) Total Purchased Property Services 1,554,350 1,398,979 155,371 10.0% 3,740,650 3,081,437 659,213 17.6% 6,850,450 45.0% (Continued on page 9) 8 1 P a g e February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 147 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 324,580 75,523 249,056 76.7% 639,159 223,956 415,203 65.0% 1,218,318 18.4% Technical Services 968,922 310,862 658,060 67.9% 1,995,210 568,585 1,426,625 71.5% 3,914,195 14.5% Other Purchased Services 900,898 654,373 246,525 27.4% 1,236,848 1,247,252 (10,404) -0.8% 2,761,245 45.2% Total Purchased Professional, Technical&Other Services 2,194,400 1,040,758 1,153,642 52.6% 3,871,217 2,039,793 1,831,424 47.3% 7,893,758 25.8% Supplies&Materials Utilities&Fuel 1,527,100 1,826,123 (299,023) -19.6% 3,054,200 3,614,377 (560,177) -18.3% 6,108,400 59.2% Chemicals 586,500 567,720 18,780 3.2% 1,173,000 1,136,711 36,289 3.1% 2,346,000 48.5°/% General Supplies 929,150 758,502 170,648 18.4% 2,093,301 1,175,576 917,725 43.8% 3,951,602 29.7% Total Supplies&Materials 3,042,750 3,152,345 (109,595) -3.6% 6,320,501 5,926,664 393,837 6.2% 12,406,002 47.8% Other Expenses Memberships 152,096 123,145 28,952 19.0% 284,423 487,662 (203,240) -71.5% 578,615 84.3% Training&Meetings 154,294 100,528 53,766 34.8% 321,687 180,883 140,805 43.8% 663,125 27.3% Miscellaneous Other 46,563 57,102 (10,540) -22.6% 93,125 95,775 (2,650) -2.8% 186,250 51.4% Total Other Expenses 352,952 280,774 72,178 20.4% 699,235 764,320 (65,086) -9.3% 1,427,990 53.5% Total Expenses $ 20,111,616 $ 19,381,184 $ 730,433 3.6% $ 42,372,015 $ 40,136,389 $ 2,235,626 5.3% $ 85,019,046 47.2% 9 1 P a g e February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 148 of 198 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 554,171 $ 447,139 $ 107,032 19.3% $ 1,210,936 $ 966,963 $ 243,973 20.1% $ 2,778,212 34.8% Administration 4,796,516 4,711,959 84,556 1.8% 9,999,171 9,688,561 310,611 3.1% 20,283,342 47.8% Engineering and Technical Services 3,539,478 3,338,141 201,337 5.7% 7,489,108 7,413,616 75,492 1.0% 15,208,366 48.7% Operations 10,791,345 10,608,994 182,351 1.7% 22,788,809 21,450,890 1,337,919 5.9% 45,051,909 47.6% Recycled Water Program 430,107 275,319 154,788 36.0% 883,991 616,728 267,263 30.2% 1,697,217 36.3% Total Expenses $ 20,111,616 $ 19,381,552 $ 730,064 3.6% $ 42,372,015 $ 40,136,758 $ 2,235,257 5.3% $ 85,019,046 47.2% Year-to-Date Expenses by Department $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services YTD YTD Budget Actual 10 � Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 149 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 248,422 $ 248,504 $ (83) 0.0% $ 516,462 $ 487,917 $ 28,545 5.5% $ 1,070,246 45.6% Office of the Secretary of the District 193,929 162,080 31,849 16.4% 470,833 381,032 89,801 19.1% 1,242,671 30.7% Board of Directors 111,820 36,555 75,265 67.3% 223,641 98,014 125,627 56.2°/% 465,295 21.1% Administration Office of the Director of Finance and Administration 143,185 123,100 20,085 14.0% 310,046 269,416 40,630 13.1% 649,271 41.5% Finance Division 446,099 445,866 233 0.1% 915,183 922,783 (7,600) -0.8% 2,008,642 45.9% Human Resources Division 1,742,126 2,079,921 (337,795) -19.4% 3,559,555 3,689,911 (130,356) -3.7% 7,131,543 51.7% Purchasing Division 427,567 416,359 11,207 2.6% 923,203 841,620 81,583 8.8% 1,861,104 45.2% Risk Management Program 309,276 287,390 21,886 7.1% 634,524 659,043 (24,519) -3.9% 1,274,845 51.7% Public Info/Comm.Services&Intergov Relations Division 550,530 386,567 163,963 29.8% 1,004,865 810,720 194,145 19.3% 2,155,358 37.6% Information Technology Division 1,177,733 972,756 204,977 17.4% 2,651,795 2,495,066 156,728 5.9% 5,202,579 48.0% Engineering&Technical Services Office of the Director of Engineering& Technical Services 194,559 123,960 70,599 36.3% 427,656 341,880 85,777 20.1% 890,095 38.4% Planning&Developmental Services 1,438,945 1,406,103 32,843 2.3% 3,100,696 2,982,310 118,386 3.8% 6,241,012 47.8% Capital Projects Division (191,602) 15,785 (207,387) 108.2% (440,249) 74,767 (515,016) 117.0% (831,774) -9.0% Environmental&Regulatory Compliance 2,097,576 1,792,293 305,283 14.6% 4,401,005 4,014,659 386,346 8.8% 8,909,033 45.1% Operations Office of the Director of Operations 283,778 218,592 65,186 23.0% 607,408 436,347 171,062 28.2% 1,232,151 35.4% Collection System Operations Division 3,174,312 3,070,081 104,231 3.3% 6,674,349 6,413,542 260,806 3.9% 13,480,048 47.6% Treatment Plant Operations Division 3,882,788 3,864,599 18,189 0.5% 7,517,874 7,966,553 (448,679) -6.0% 14,871,590 53.6% Treatment Plant Maintenance Division 3,450,468 3,455,723 (5,256) -0.2% 7,989,178 6,634,448 1,354,731 17.0% 15,468,121 42.9% Recycled Water Recycled Water-General 46,705 24,138 22,566 48.3% 93,409 50,801 42,608 45.6% 186,818 27.2% Treatment Plant 200,850 164,674 36,177 18.0% 401,700 345,782 55,918 13.9% 803,400 43.0% Distribution System 96,450 59,427 37,023 38.4% 192,900 127,265 65,635 34.0% 385,800 33.0% Residential Fill Station 61,152 27,081 34,072 55.7% 146,082 92,726 53,356 36.5% 221,399 41.9% Satellite Water Facility 24,950 - 24,950 100.0% 49,900 154 49,746 99.7% 99,800 0.2% Total Expenses $ 20,111,616 $ 19,381,552 $ 730,064 3.6% $ 42,372,015 $ 40,136,758 $ 2,235,257 5.3% $ 85,019,046 47.2% 111 Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 150 of 198 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 36,702,827 $ 37,020,813 $ 317,985 0.9% $ 36,654,293 $ 37,018,901 $ 364,607 1.0% $ 65,832,492 56.2% Other Capital Revenues 20,431,872 20,927,738 495,866 2.4% 21,243,729 25,256,685 4,012,955 18.9% 62,955,078 40.1% Total Revenue $ 57,134,700 $ 57,948,551 $ 813,851 1.4% $ 57,898,023 $ 62,275,585 $ 4,377,562 7.6% $128,787,570 48.4% Year-to-Date Revenues by Source $40,000,000 $30,000,000 $20,000,000 $10,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■YTD ■YTD Budget Actual 12 Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 151 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 31,986 $ 116,507 $ 84,521 264.2% $ (16,548) $ 121,136 $ 137,684 -832.0% $ 119,500 101.4% County Allocated 35,516,954 35,734,419 217,465 0.6% 35,516,954 35,728,227 211,273 0.6% 64,576,280 55.3% Direct Billed 1,177,919 1,170,841 (7,078) -0.6% 1,177,919 1,170,841 (7,078) -0.6% 1,177,919 99.4% Prior Year Adjustment (24,032) (954) 23,078 -96.0% (24,032) (1,303) 22,728 -94.6% (41,207) 3.2% Other Capital Revenues Facilities Capacity Fees-Gravity Zone 1,954,529 1,643,806 (310,723) -15.9% 2,525,080 5,433,878 2,908,798 115.2% 4,445,000 122.2% Facilities Capacity Fees-Pump Zone 22,501 331,367 308,866 1372.6% 51,989 343,015 291,026 559.8% 134,000 256.0% Capacity Use Charge 55,565 35,746 (19,819) -35.7% 57,000 35,746 (21,254) -37.3% 57,000 62.7% Secured Property Tax 4,200,000 4,088,317 (111,683) -2.7% 4,200,000 4,088,317 (111,683) -2.7% 7,932,078 51.5% Unsecured Property Tax 100,000 558,134 458,134 458.1% 200,000 558,134 358,134 179.1% 400,000 139.5% Investment Income 54,063 411,033 356,970 660.3% 95,681 665,132 569,451 595.2% 140,000 475.1% Other Government Revenue-Concord - - - - - - 7,500,000 0.0% State Revolving Fund Loan Proceeds 14,000,000 13,825,787 (174,213) -1.2% 14,000,000 13,825,787 (174,213) -1.2% 42,000,000 32.9% Overtime Inspection 844 - (844) -100.0% 4,074 319 (3,755) -92.2% 8,000 4.0% Plan Review 22,126 15,798 (6,328) -28.6% 46,452 47,421 969 2.1% 89,000 53.3% Main Lines Inspection Fees 21,994 21,134 (860) -3.9% 62,953 240,145 177,191 281.5% 249,000 96.4% Rebates to District - - - - - - - Other Agency Reimbursement - - - - - - - Miscellaneous Income 250 2,106 1,856 742.4% 500 2,106 1,606 321.2% 1,000 210.6% Alhambra Valley Assessment District - (2,746) (2,746) - 35,369 35,369 - Contractual Assessment District - (2,744) (2,744) - (18,684) (18,684) - Total Revenues $ 57,134,700 $ 57,948,551 $ 813,851 1.4% $ 57,898,023 $ 62,275,585 $ 4,377,562 7.6% $128,787,570 48.4% 131Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 152 of 198 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 600,000 37,450,000 55,582,192 7,009,237 48,572,955 Treatment Plant(TP) 96,390,332 54,872,388 41,517,944 39,981,000 300,000 40,281,000 81,798,944 13,957,222 67,841,722 General Improvements(GI) 19,896,459 16,655,259 3,241,200 3,795,000 - 3,795,000 7,037,349 993,076 6,044,273 Recycled Water(RW) 32,854,000 28,737,307 4,116,693 8,715,000 8,715,000 12,831,693 3,723,545 9,108,148 CIB Contingency - - - 1,635,000 (900,000) 735,000 735,000 - 735,000 Total $ 224,715,032 $ 157,707,003 $ 67,008,029 $ 90,976,000 $ - $ 90,976,000 $ 157,985,178 $ 25,683,080 $ 132,302,098 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 $20,000,000 .04' $10,000,000 -MFw Collection System Treatment Plant General Recycled Water CIB Contingency (CS) (TP) Improvements (RW) (GI) Program ■Approved Expenditures ■Actual Expenditures 14Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 153 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 218,586 4,656,066 8419 Collection System Planning LT 1,585,000 1,409,671 175,329 200,000 - 200,000 375,329 62,897 312,432 8436 Moraga/Crossroads PS Project 35,451,000 34,219,528 1,231,472 - - - 1,231,472 819,010 412,462 8442 PS Equipment Piping ReplacementPH2 564,000 428,844 135,156 206,000 - 206,000 341,156 16,927 324,229 8443 LG Diameter Pipe line Inspection 1,795,000 253,940 1,541,060 - - - 1,541,060 164,861 1,376,199 8444 Force Main Inspection Program 1,125,000 18,132 1,106,868 - - - 1,106,868 6,998 1,099,870 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 24,000 948,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 451,209 488,793 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 254,030 14,036,739 8463 No.Orinda Sewer Renov.PH.8 4,304,000 3,925,644 378,356 - - - 378,356 364,744 13,612 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 106,441 3,917,870 8465 WC Sewer Renov.Ph.15 5,400,000 4,121,806 1,278,194 - - - 1,278,194 401,469 876,725 8466 Danville Sewer Ren.Ph.4 1,500,000 1,576,565 (76,565) 3,702,000 - 3,702,000 3,625,435 2,161,925 1,463,510 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 210,463 1,573,427 *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) 1,136,981 (1,230,145) 100024 South Orinda Sewer Renovation Ph.9 500,000 451,521 48,479 - - - 48,479 195,854 (147,375) 100025 Lafayette Sewer Renov.Ph.15 500,000 228,951 271,049 - - - 271,049 137,836 133,213 100028 Collection System Master Plan 2021 Update 750,000 54,534 695,466 850,000 - 850,000 1,545,466 76,162 1,469,304 100037 Orinda Moraga PS Architectual Improvements 200,000 12,609 187,391 1,250,000 - 1,250,000 1,437,391 18,654 1,418,737 **100038 San Pablo Watershed Improvements - - - - 200,000 200,000 200,000 40,785 159,215 100039 Collection System Sewere Renovation Ph.2 - - - 9,410,000 (81,000) 9,329,000 9,329,000 52,100 9,276,900 **100041 Buchanan Lift Station Replacements&Improvemei - - - - 200,000 200,000 200,000 5,031 194,969 **100042 Pump Station Upgrades,Phase 2B - - - - 200,000 200,000 200,000 32,421 167,579 100044 Collection System Modeling Support FY 22+ - - - 120,000 - 120,000 120,000 - 120,000 **100049 Dowtown Walnut Creek Sewer Renovations,Ph.1 - - - - 500,000 500,000 500,000 8,061 491,939 **100050 Caltrans A-Line Relocation - - - - 200,000 200,000 200,000 729 199,271 Rounding Total CS Program $ 75,574,241 57,442,049 18,132,192 36,850,000 600,000 37,450,000 55,582,192 7,009,237 48,572,955 * Projects open but not in CIB for 22/23 ** Not in 22/23 Budget New projects.Funds transferred from other projects or Contingency 151Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 154 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 121,609 536,590 7328 Influent Pump Electrical improvements 8,160,000 8,665,855 (505,855) 1,426,000 - 1,426,000 920,145 1,436,240 (516,095) 7341 WC/Grayson Creek Levee Rehab 1,050,000 630,015 419,985 1,500,000 - 1,500,000 1,919,985 20,238 1,899,747 7348 Solids Handling Facility Improvements 34,518,687 18,436,325 16,082,362 5,000,000 - 5,000,000 21,082,362 3,047,035 18,035,327 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 92,691 514,895 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 414,308 3,144,286 7370 Annual Infrastructure Replacement 3,605,000 1,991,444 1,613,556 1,000,000 - 1,000,000 2,613,556 370,515 2,243,041 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 253,723 321,713 7375 Contractor Staging Improvements 5,200,000 4,475,037 724,963 - 300,000 300,000 1,024,963 1,030,499 (5,536) 100001 UPCAA Urgent Projects FY 2020-25 1,200,000 176,995 1,023,005 600,000 - 600,000 1,623,005 42,638 1,580,367 100008 Laboratory Roof&Seismic upgrades 950,000 96,086 853,914 500,000 - 500,000 1,353,914 1,115,951 237,963 100009 Hearth Replacement 500,000 265,797 234,203 - - - 234,203 12,704 221,499 100010 Air Condiditioning&Lighting Renovation 1,250,000 646 1,249,354 - - - 1,249,354 101,488 1,147,866 100011 Plant Electrical Replacement&Rehabilitation 408,371 211,278 197,093 400,000 - 400,000 597,093 36,731 560,362 100012 UV Disinfection Replacement 2,500,000 1,239,101 1,260,899 3,500,000 - 3,500,000 4,760,899 347,639 4,413,260 *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 67,751 1,401,621 100015 Electric Blower Improvements 9,150,000 5,896,057 3,253,943 4,245,000 - 4,245,000 7,498,943 2,925,938 4,573,005 100018 Outfall Monitoring Improvements 610,000 218,980 391,020 - - - 391,020 621,659 (230,639) 100019 Aeration Basins Diffuer Replacementand Seismic 2,300,000 832,698 1,467,302 7,500,000 (300,000) 7,200,000 8,667,302 661,935 8,005,367 100022 Wet Weather Basin Improvements 700,000 300,667 399,333 600,000 - 600,000 999,333 44,226 955,107 100030 Solids Handling Facility Improvements Ph.2 3,600,000 191,043 3,408,957 3,100,000 - 3,100,000 6,508,957 793,998 5,714,959 100032 Steam Renovations,Ph.1 500,000 21,645 478,355 4,500,000 - 4,500,000 4,978,355 306,348 4,672,007 100034 TP Safety Enhancemeths 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 Ph.4 - - - 860,000 - 860,000 860,000 - 860,000 100046 Control System Upgrades - _ - 200,000 - 200,000 200,000 11,608 188,392 100047 Secondary Clarifier Improvments-Phase 1 - _ - 2,000,000 - 2,000,000 2,000,000 - 2,000,000 100048 Warehouse Seismic Upgrades - - - 500,000 - 500,000 500,000 - 500,000 **100051 RAS Piping Renovations - - - - 300,000 300,000 300,000 1,764 298,236 Rounding Total TP Program $ 96,390,332 $ 54,872,388 $ 41,517,944 $ 39,981,000 $ 300,000 $ 40,281,000 $ 81,798,944 $ 13,957,222 $ 67,841,722 * Projects open but not in CIB for F22/23 ** Not in 22/23 Budget New projects. Funds transferred from other projects or Contingency 161Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 155 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C(A-Bl 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 Cl General Improvements 8230 Capital Legal Services 228,665 226,234 2,431 20,000 - 20,000 22,431 10,616 11,815 8240 IT Development 4,488,794 4,002,443 486,351 500,000 500,000 986,351 86,169 900,182 8250 ERP Replacement 5,380,000 5,326,990 53,010 - - - 53,010 - 53,010 8251 Capital improvement program&Budget Improver 390,000 163,856 226,144 200,000 - 200,000 426,144 55,361 370,783 8252 POB E.V.Charging Station 490,000 21,749 468,251 150,000 150,000 618,251 924 617,327 8253 COVID-19 Response 275,000 113,510 161,490 - - - 161,490 69,219 92,271 8516 District Equipment Acquisition 1,476,000 1,271,897 204,103 250,000 250,000 454,103 205,416 248,687 8517 Vehicle Replacement Program 4,718,000 4,373,000 345,000 900,000 900,000 1,245,000 56,396 1,188,604 100003 Property Repairs&Improvements 450,000 276,634 173,366 700,000 - 700,000 873,366 109,409 763,957 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 onLagiss 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 149,400 425,651 100033 Security Improvements FY 2021-25 200,000 45,266 154,734 100,000 - 100,000 254,734 34,757 219,977 100035 Technology Strategic Plan 500,000 302 499,698 500,000 500,000 999,698 197,157 802,541 100043 Easement Acquisition FY 2022-31 - - - 75,000 75,000 75,000 5,589 69,411 9999 Capital Project Clearing(Accounting Use Only) - 1,149 (1,149) - - - - 11,101 (11,101) Rounding Total GI Program $ 19,896,459 16,655,259 3,241,200 3,795,000 3,795,000 7,037,349 993,076 6,044,273 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 3,708,298 6,493,632 7366 ReW Distribution System Renov.Program 715,000 196,187 518,813 215,000 - 215,000 733,813 7,722 726,091 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 6,074 193,926 Rounding Total RW Program $ 32,854,000 28,737,307 4,116,693 8,715,000 8,715,000 12,831,693 3,723,545 9,108,148 9990 CONTINGENCY-ALL PROGRAMS 1,635,000 (900,000) 735,000 735,000 735,000 GRAND TOTAL $ 224,715,032 157,707,003 67,008,029 90,976,000 90,976,000 157,985,178 25,683,080 132,302,098 171Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 156 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 1,662,101 $ 0.0% $ 1,662,101 $ 1,662,101 $ 0.0% $ 1,662,101 100.0% Insurance Recoveries(HHW) - - - - 25,000 0.0% Investment Income 2,350 47,003 44,653 1900.1% 4,700 79,485 74,785 1591.2% 47,400 167.7% Total Revenues $ 1,664,451 $ 1,709,104 $ 44,653 2.7% $ 1,666,801 $ 1,741,586 $ 74,785 4.5% $ 1,734,501 100.4% Year-to-Date Revenues by Source $2,000,000 $1,500,000 $1,000,000 $500,000 Sewer Service Charge Insurance Recoveries(HHW) Investment Income Revenue Source Category ■YTD ■ YTD Budget Actual 18Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 157 of 198 AMILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section S - 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 $ 189,720 $ (95,970) -102.4% $ 187,500 $ 253,422 $ (65,922) -35.2% $ 375,000 67.6% Technical Services 15,000 7,617 7,383 49.2% 30,000 7,617 22,383 74.6% 60,000 12.7% Insurance&Risk Management 433,750 18,336 415,414 95.8% 867,500 1,260,913 (393,413) -45.4% 1,735,000 72.7% Total Expenses $ 542,500 $ 215,674 $ 326,826 60.2% $ 1,085,000 $ 1,521,952 $ (436,952) -40.3% $ 2,170,000 70.1% 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 February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 158 of 198 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 7,288,557 $ 7,380,966 $ 92,408 1.3% $ 7,288,557 $ 7,380,966 $ 92,408 1.3% $ 13,251,922 Investment Income - - - - Total Revenues $ 7,288,557 $ 7,380,966 $ 92,408 1.3% $ 7,288,557 $ 7,380,966 $ 92,408 1.3% $ 13,251,922 55.7% Year-to-Date Revenues by Source $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Tax Revenue Investment Income ■ YTD ■ YTD Budget Actual 20Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 159 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 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 $ 5,800 $ (5,175) -828.0% $ 1,250 $ 5,800 $ (4,550) -364.0% $ 2,500 232.0% Principal Payment Expense - 10,750,000 10,750,000 - 0.0% 10,750,000 100.0% Interest Expense - - 1,381,405 460,468 920,937 66.7% 2,499,422 542.8% Total Expenses $ 625 $ 5,800 $ (5,175) -828.0% $ 12,132,655 $ 11,216,268 $ 916,387 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 February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 160 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 7 - Quarterly Investment Portfolios Operating&Maintenance Fund QTD Purchase Maturity Daysto Annual Cash BOQ Purchase EOQ EOQ %of 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. LAW n/a n/a n/a (1) $ 27,900,000 $ 10,900,000 $ 17,000,000 $ 27,900,000 $ 27,380,760 69.92% $ 97,340 $ 146,974 RE20 US T-Bill US Fed Agency 5/19/2022 11/17/22 0 1.495% 3,969,768 4,000,000 (4,000,000) - - 0.00% 7,807 23,089 RE21 FHLB US Fed Agency 5/19/2022 5/17/23 137 2.174% 1,468,086 1,500,000 - 1,500,000 1,475,310 3.76% 8,088 16,177 RE22 UST Notes US Treasury 5/19/2022 4/30/24 486 2.661% 1,497,366 1,500,000 - 1,500,000 1,459,707 3.76% 340 681 RE23 FHLB DISC US Agency 12/27/2022 6/23/23 174 4.783% 4,886,031 - 5,000,000 5,000,000 4,893,900 12.53% 3,201 3,201 RE24 FHLB DISC US Agency 12/27/2022 3/15/23 74 4.525% 3,961,693 4,000,000 4,000,000 3,965,800 10.03% 2,458 2,458 (3) $ 43,682,944 $ 17,900,000 $ 22,000,000 $ 39,900,000 $ 39,175,477 100.00% 119,235 192,580 (2) (4) (8) 10,687 $ 119,235 $ 203,267 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 December,2022 was 2.17%. (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 2.190%.As the District is a voluntary participant in the County Treasury Pool,this calculation excludes investments purchased after the 15th day of the month,which is the cut-off for month-end reporting by Contra Costa County. (4)The market value of the portfolio on December 31,2022 was$39,175,477.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 Santo 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 February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 161 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 7 - Quarterly Investment Portfolios Sewer Construction Fund QTD Purchase Maturity Daysto Annual Cash BOQ Purchase EOQ EOQ %of 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 LAW 8/86-2/90 n/a n/a (1) $ 28,500,000 $ 23,000,000 $ 5,500,000 $ 28,500,000 $ 27,969,594 24.89% $ 125,362 $ 220,633 961 US T Bill US Treasury 1/21/2022 1/15/2025 746 1.26% 2,490,505 2,500,000 - 2,500,000 2,340,925 2.18% 801 1,603 962 US T Bill US Treasury 5/19/2022 11/17/2022 0 1.50% 14,886,629 15,000,000 (15,000,000) - - 0.00% 29,277 86,585 963 FHLB US Fed Agency 5/19/2022 5/17/2023 137 2.17% 12,723,414 13,000,000 - 13,000,000 12,786,020 11.35% 70,099 140,198 964 UST Notes US Treasury 5/19/2022 4/30/2024 486 2.66% 2,495,610 2,500,000 - 2,500,000 2,432,846 2.18% 567 1,135 965 FHLB US Fed Agency 8/12/2022 8/11/2023 223 3.28% 4,840,244 5,000,000 - 5,000,000 4,865,000 4.37% 40,378 61,883 966 US T Bill US Treasury 11/23/2022 2/21/2023 52 4.20% 12,866,750 - 13,000,000 13,000,000 12,926,420 11.35% 57,742 57,742 967 FHLB Disc US Agency 12/29/2022 3/29/2023 88 4.51% 19,780,000 - 20,000,000 20,000,000 19,795,400 17.47% 7,333 7,333 968 FHLB Disc US Agency 12/29/2022 6/28/2023 179 4.77% 29,306,922 30,000,000 30,000,000 29,344,800 26.20% 11,487 11,487 (3) $127,890,074 $ 61,000,000 $ 53,500,000 $114,500,000 $112,461,005 100.00% 343,047 588,600 (2) (4) (8) 15,225 $ 343,047 $ 603,825 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 December,2022 was 2.17%. (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 2.372%.As the District is a voluntary participant in the County Treasury Pool,this calculation excludes investments purchased after the 15th day of the month,which is the cut-off for month-end reporting by Contra Costa County. (4)The market value of the portfolio on December 31,2022 was$112,461,005.GASB 31 requires adjusting investments to market value.The District will adjust annually,but report market values monthly. (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 Santo meet budgeted expenditures of the Sewer Construction fund for the next six(6)months[California Government Code§53646(b)(3)] 231Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 162 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 7 - Quarterly Investment Portfolios Self Insurance Fund QTD Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ %of 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 10/99- n/a n/a (1] $ 10,100,000 $ 9,100,000 $ 1,000,000 $ 10,100,000 $ 9,912,032 100.00% $ 45,663 $ 76,186 (3) $ 10,100,000 $ 9,100,000 $ 1,000,000 $ 10,100,000 $ 9,912,032 100.00% 45,663 76,186 (2) (4) (7) $ 45,663 $ 76,186 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 December 2022 was 2.17%. (2)The face value indicates the value of the investment if held until maturity,which is the usual District Practice. (3)The weighted average yield of the total Self-Insurance portfolio is 2.17%. (4)The market value of the portfolio on Decmeber 31,2022 was$9,912,032. (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 Santo 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 February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 163 of 198 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 8 - Financial Performance Metric Charts O&M Fund Cashflow Forecast FY 2022-23 Running Expense Fund Total Cash & Investment Balances (Actuals through Dec 2022) $70.0 $60.0 $51.4 $50.0 $4s.7 $45.— $48.6 _ 4 $40.0 — $38.0 $377 $39.3 $40.9 $37.6 $3 . $31.6 $32.7 $29.0 $28.0 $29.1 $28.2 $29.2 $30.0 $25 $20.0$20.0 $10.0 — I I 1 1 $0.0 – ,�'ti tJ �J o �0 0 M Projected Balance* =Actual Balance Reserve Target at Year End** NOTES:* Projected balances were generated in July 2022 based on budgeted revenues and expenses for FY 2022-23 and applied to the actual balance at June 30,2022 **The Reserve Target at Year End is the minimum balance required at June 30,2023 to comply with the District Policy 251Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 164 of 198 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast FY 2022-23 Sewer Construction Fund Total Cash & Investment Balances (Actuals through Dec 2022) 6 $120.0 119.8 $100.0 $86.5 $91.4 ae� $84.8 $80.0 $75.0 $79.3 $72.8 $78.3 $70.0 $65.0 $65.9 $64.7 $68.0 $64.3 $60.0 $43 $40.0 $41.8 $20.0 $24.5 $0.0 — ,titi to Oe Q 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 261Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 165 of 198 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 8 - Financial Performance Metric Charts Staffing Trends 300 4.8%vacanc Rate 295 290 w 285 16 171 280 275 a' 270 281 280 265 277 276 w 260 255 mi 250 12/31/19 12/31/20 12/31/21 12/31/22 Quarter Ended ■Filled Positions(FTEs) ■Vacancies(FTEs) 27Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 166 of 198 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated Historical Quarterly O&M Cost per Million Gallons Treated $5,000 $3,907 $4,500 $3,715 $3,620 $4,000 $3,500 $2,744 $3,000 $2,500 $2,000 $1,500 $1,000 $500 12/31/19 12/31/20 12/31/21 12/31/22 Second Quarter of Fiscal Year 28Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 167 of 198 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 8 - Financial Performance Metric Charts Capital Spending Trend $180 $160 – $158.OM $140 $120 0 $100 / – c $80 — — 7 – $116.2M $60 – $40 – $20 $25.7M �`J9 Pof°5� Se��etooet oc�opet �o�e�oet 9ece�be� l��at9 4e11. 0"as9 VA —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) 29Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 168 of 198 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending December 31, 2022 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed/ Renovated 4.0 3.5 3.0 a� V L 2.5 0 2.0 2.0 1.7 1.8 .7� o. n. 0 1.5 1.0 1.0 0.5 0.5 0.5 0 0.0 al3oltiti 1�1311titi 3�311ti3 6�3olti3 Quarter Ending ■Actual Construction ■Target("S-Curve"of 6 mi.FY 22-23 Budget Projection) 30Page February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 169 of 198