Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
05.a. Receive quarterly financial review for quarter ending March 31, 2022
Page 1 of 34 Item 5.b. CENTRAL SAN Y-109-ITMEN ME May 24, 2022 TO: FINANCE COMMITTEE 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 MARCH 31, 2022 Attached is the Quarterly Financial Reviewfor the third quarter of Fiscal Year (FY) 2021-22 ending March, 2022. The Executive Summary (Section 1) of the attached report includes an analysis of financial results and the investment portfolios for the quarter. GOAL THREE: Fiscal Responsibility Strategy 1—Maintain financial stability and sustainability, Strategy 2—Ensure integrity and transparency in financial management ATTACHMENTS: 1. Quarterly Financial Report- March 31, 2022 May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 105 of 172 . . uarterFinancial _s CENTRAL SAN Review rw AM i _ ImYT�► ._ f W w- umarter Ended March 31 , 2022 c.CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 107 of 172 c.CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 SewerConstruction Fund Cashflow Forecast...........................................................................................................................................................................26 StaffingTrends.......................................................................................................................................................................................................................................27 Cost per Million Gallons of Wastewater Treated.....................................................................................................................................................................28 CapitalSpending Trend......................................................................................................................................................................................................................29 Milesof Pipeline Constructed/Renovated..................................................................................................................................................................................30 May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 108 of 172 c.CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 third quarter of FY 2021-22 ended March 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 third quarter show total expenditures are $54.7 million, which is approximately $3.5 million (6.0%) under the projected year-to-date budget. This favorable expense variance, largely attributable to lower than projected year- to-date spending in the purchased professional, technical and other services, and salaries & wages expense categories is smaller than the favorable year-to-date budget variance reported in the third quarter of the prior year of 13.1%. Savings realized in the salaries &wages category is largely the result of the full-time employee vacancy rate being higher than normal through the third quarter at approximately 7.9%, with the budget assuming 3.0%. The largest individual expense category budgetary variance is in the purchased professional, technical and other services category, which is reporting a favorable variance of approximately$2.5 million. In the aggregate, the 0&M Fund is reporting a favorable revenue variance of approximately $2.3 million, which is approximately 4.0% above total estimated year-to-date revenues. The primary driver for this overall revenue variance is sewer service charges received from the county along with $1.0 million in unbudgeted COVID-19 relief funds received from the State of California,which are included in the other non-operating income. Sewer Construction Fund Sewer Construction Fund results for the third quarter show total capital project expenditures of$47.8 million, or 64.1% of the total estimated year-to-date budget of $74.6 million developed using historical spending trends over the past three years. While the Sewer Construction fund's FY 2021-22 adopted budget was $108.0 million, when including roll-over capital project 11Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 109 of 172 c.CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 1 -Executive Summary appropriations from the prior year of$37.9 million the total adjusted budget for FY 2021-22 is $145.9 million. After factoring in the roll-over, the year-to-date capital spending rate is 32.8% of total approved expenditures. The adopted FY 2021-22 capital improvement budget assumed the large Solids Handling Project would proceed as planned with authorized spending of $18.8 million this year. However, the transition to using digesters for solids handling as opposed to continuing the existing incineration methodology, approved by the Board in the Fall of 2021, will have significant impacts to project scope and timeline, not reflected in the adopted FY 2021-22 capital improvement budget. Currently, staff projects this change will result in a reduction to FY 2021-22 capital spending by approximately $20 million. The bulk of the FY 2021-22 year-to-date capital spending budget variance is in the Treatment Plant program (78.5%) followed by the Collection System program (55.0%), attributable to various project as shown in pages 15 through 17 of this report. On the revenue side, the Sewer Construction Fund is currently reporting revenues of $14.2 million, reflecting a modest unfavorable year-to-date variance of$0.1 million (0.8%). This slight unfavorable revenue variance, largely in line with year- to-date budget projections is mostly attributable to secured property tax revenues, offset to a large extent by a negative revenue variance in facilities capacity fees which are estimated evenly on a straight-line basis across the fiscal year due to their interim receipt timing being difficult to predict. It is projected that property taxes will continue to remain slightly higher than budget closing the fiscal year approximately 2.0% ($0.4 million) over 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 March 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 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 third quarter of FY 2021-22, the 0&M Fund has generated Investment Income of $50,557 which is below the year-to-date revenue estimate of$93,000 by 45.6%. The Sewer Construction Fund is reporting Investment Income of$89,578 2 1 P a g e May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 110 of 172 c.CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 1 -Executive Summary (includes CAD/AVAD interest), coming in well below the year-to-date revenue estimate of $239,250 by 62.6%. These unfavorable variances are directly attributable to interest rates on permitted investments having historically low yields through the first half of the fiscal year as well as a significant portion of Sewer Construction Fund reserves being temporarily used to assist with the payoff of the pension plan's unfunded actuarial accrued liability (UAAL) with CCCERA financing a short- term interfund borrowing to the C&M fund in June 2021. The proceeds from the issuance of the June 2021 Certificates of Participation of$58.0 million have now been fully reimbursed from the debt service fund to the sewer construction fund for eligible capital expenditures incurred. Despite the Fed increasing interest rates by 25 basis points in March 2022 then an additional 50 basis points in May 2022, historically low rates in the first half of the year have taken their toll. As of March 31, 2022, Central San continues to hold the bulk of its investment portfolio, or $52.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 million. As interest rates continue to rise during 2022 staff has been researching investment alternatives such as short-term United States Treasury Bills, corporate notes, and short-term fixed income instruments. An investment strategy has been developed with a maturity ladder in order to diversify the District's portfolio and take advantage of rising interest rates expected for the remainder of the fiscal year. While staff does intend to explore 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.02% to total budgeted revenues for FY 2021-22. Central San's investment portfolio is in compliance with the Board's adopted policy regarding investments as of the quarter ended March 31, 2021. 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 FY 2021-22 budgeted revenues. 3 1 P a g e May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 111 of 172 iCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ-CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 $ 56,242,691 $ 58,509,931 2,267,240 4.0% $ 116,681,763 50.1% Sewer Construction 14,311,160 14,197,788 (113,372) -0.8% 32,243,421 44.0% Self Insurance 1,632,669 1,590,863 (41,806) -2.6% 1,651,419 96.3% Debt Service 7,090,082 7,006,024 (84,058) -1.2% 12,891,059 54.3% Total $ 79,276,602 $ 81,304,606 $ 2,028,004 $ 163,467,662 Fund Expenses 0&M $ 58,161,320 $ 54,682,279 3,479,040 6.0% $ 79,520,131 68.8% Sewer Construction 74,607,861 47,823,700 26,784,161 35.9% 145,896,673 32.8% Self Insurance 926,250 1,248,440 (322,190) -34.8% 1,285,000 97.2% Debt Service 12,891,059 12,653,810 237,249 1.8% 12,891,059 98.2% Total $ 146,586,490 $ 116,408,229 $ 30,178,260 $ 239,592,863 YTD Budget-to-Actual Revenues by Fund YTD Budget-to-Actual Expenses by Fund $60,000,000 $'!0,000,000 $50,000,000 WARM ano,aa0,000 s50,000,000 $30,000,000 $40,000,000 330,000,000 32oAoa,000 $20,000,000 $10,000,000 $10.000,000 0&M Sewer DOrisWRlOn Self lnsurarice DeM Service D5M Scwcr Cortso-uttion Selllnsurar¢e peM Service Fund Fund •YTD •VTp •YTD •YTD Mgx 1-1 Budget 1-1 4Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 112 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 $ 40,158 $ 40,010 $ (148) -0.4% $ 53,447,141 $ 54,718,795 $ 1,271,654 2.4% $ 96,331,829 56.8% Sewage Treatment Cost Sharing - - - - (47,960) (47,960) 15,445,534 -0.3% Miscellaneous Service Charge 239,250 142,579 (96,671) -40.4% 717,750 632,575 (85,175) -11.9% 2,078,000 30.4% Non-Operating Revenues: Permit and Inspection Fees 473,600 583,712 110,112 23.2% 1,420,800 1,484,155 63,355 4.5% 1,894,400 78.3% Other Non Operating Income 188,000 1,354,721 1,166,721 620.6% 564,000 1,671,808 1,107,808 196.4% 752,000 222.3% Investment Income 51,000 27,937 (23,063) -45.2% 93,000 50,557 (42,443) -45.6% 180,000 28.1% Total Revenue $ 992,008 $ 2,148,958 $ 1,156,950 116.6% $ 56,242,691 $ 58,509,931 $ 2,267,240 4.0% $ 116,681,763 50.1% Year-to-Date Revenues by Source $60,000,000 " $50,000,000 $40,000,000 $30,000,000 fir,,• $20,000,000 .,�;. $10,0001000 ' 4*er Service Charge Revenue Sewage Treatment Cost Miscellaneous Service Charge Permit and Inspection Fees Other Non Operating Income Investment Income Sharing $(10,000,000) Revenue Source Category ■YTD ■YTD Budget Actual 5 � Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 113 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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($) (%) Budget Actual Variance($) (%) Budget Sewer Service Charge Revenue Sewer Service Charge Counter $ 55,776 $ 39,023 $ (16,753) -30.0% $ 167,329 $ 272,408 $ 105,079 62.8% $ 223,105 122.1% Sewer Service Charge County - (2,167) (2,167) 52,365,535 52,635,972 270,437 0.5% 95,210,064 55.3% Sewer Service Charge Direct 3,154 3,154 961,131 1,772,263 811,132 84.4% 961,131 184.4% Sewer Service Charge Prior (15,618) - 15,618 -100.0% (46,853) 38,153 85,006 -181.4% (62,471) -61.1% Sewage Treatment Cost Sharing - - - - (47,960) (47,960) 15,445,534 -0.3% Miscellaneous Service Charges Septic Tank Dumping 9,500 9,298 (202) -2.1% 28,500 30,586 2,086 7.3% 38,000 80.5% Sales 250 - (250) -100.0% 750 - (750) -100.0% 1,000 0.0% Other Service Charges - 2,546 2,546 - 2,703 2,703 240,000 1.1% Recycled Water 108,000 12,209 (95,791) -88.7% 324,000 313,055 (10,945) -3.4% 432,000 72.5% Satellite Water Recycling - - - - - Stormwater Program 97,500 91,250 (6,250) -6.4% 292,500 213,063 (79,437) -27.2% 390,000 54.6% Household Hazardous Waste 24,000 27,276 3,276 13.6% 72,000 73,168 1,168 1.6% 977,000 7.5% Permit&Inspection Fees Permit/Application Fees 135,000 179,781 44,781 33.2% 405,000 425,309 20,309 5.0% 540,000 78.8% Overtime Inspection 3,600 3,416 (184) -5.1% 10,800 8,286 (2,514) -23.3% 14,400 57.5% Side Sewer Inspection 292,500 333,848 41,348 14.1% 877,500 928,364 50,864 5.8% 1,170,000 79.3% Industrial Permit Fees 26,250 46,627 20,377 77.6% 78,750 85,990 7,240 9.2% 105,000 81.9% New Industry Permit Fees 3,750 5,388 1,638 43.7% 11,250 8,900 (2,350) -20.9% 15,000 59.3% Annexation Charges 12,500 14,652 2,152 17.2% 37,500 27,306 (10,194) -27.2% 50,000 54.6% Other Non-Operating Income MVSD P2 Program 6,250 5,822 (428) -6.8% 18,750 12,413 (6,337) -33.8% 25,000 49.7% Pretreatment Program Fine 500 - (500) -100.0% 1,500 2,000 500 33.3% 2,000 100.0% Rebates to District - - - - - - - Lease Rental Income 178,750 285,435 106,685 59.7% 536,250 593,894 57,644 10.7% 715,000 83.1% Miscellaneous Income 2,500 67,368 64,868 2594.7% 7,500 56,826 49,326 657.7% 10,000 568.3% Right of Way Fees - - - - 10,579 10,579 - Contractual Assessment Dist - - - - State Grants - 996,096 996,096 - 996,096 996,096 - Investment Income 51,000 27,937 (23,063) -45.2% 93,000 50,557 (42,443) -45.6% 180,000 28.1% Total Revenues $ 992,008 $ 2,148,958 $ 1,156,950 116.6% $ 56,242,691 $ 58,509,931 $ 2,267,240 4.0% $ 116,681,763 50.1% 6 1 P a g e May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 114 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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,153,940 $ 9,014,983 $ 138,957 1.5% $ 28,824,143 $ 27,776,530 $ 1,047,613 3.6% $ 39,711,391 69.9% Employee Benefits 3,230,712 3,267,467 (36,755) -1.1% 9,226,942 9,286,176 (59,234) -0.6% 12,688,724 73.2% Unfunded Liability Costs 640,618 637,390 3,229 0.5% 1,923,762 1,966,285 (42,523) -2.2% 2,566,845 76.6% Purchased Property Services 1,480,960 1,329,659 151,301 10.2% 4,442,880 4,125,992 316,888 7.1% 5,926,840 69.6% Other Purchased Services 1,641,480 1,196,645 444,835 27.1% 5,250,250 2,780,067 2,470,183 47.0% 6,934,841 40.1% Supplies&Materials 2,534,508 2,728,328 (193,819) -7.6% 7,624,525 7,903,366 (278,841) -3.7% 10,512,734 75.2% Other Expenses 308,264 185,517 122,747 39.8% 868,817 843,863 24,954 2.9% 1,178,756 71.6% Total Expenses $ 18,990,484 $ 18,359,990 $ 630,494 T3% $ 58,161,320 $ 54,682,279 $ 3,479,040 6.0% $ 79,520,131 68.8% Year-to-Date Expenses by Type $30,000,000 $20,000,000 $10,000,000 I&P Salaries&Wages Employee Benefits Unfunded Liability Purchased Property Other Purchased Supplies&Materials Other Expenses Costs Services Services Department ■YTD ■YTD Budget Actual 7Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 115 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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,407,791 $ 8,435,621 $ (27,830) -0.3% $ 26,423,621 $ 26,073,633 $ 349,988 1.3% $ 36,384,957 71.7% Temporary Pay 282,921 - 282,921 100.0% 975,107 - 975,107 100.0% 1,345,210 0.0% Premium Pay 774,666 559,409 215,257 27.8% 2,359,728 1,654,732 704,996 29.9% 3,174,574 52.1% Board Fees 13,663 9,620 4,043 29.6% 40,988 38,110 2,878 7.0% 54,650 69.7% Other (325,100) 10,334 (335,434) 103.2% (975,300) 10,056 (985,356) 101.0% (1,248,000) -0.8% Total Salaries&Wages 9,153,940 9,014,983 138,957 1.5% 28,824,143 27,776,530 1,047,613 3.6% 39,711,391 69.9% Employee Benefits Insurance Premiums 2,050,822 1,930,140 120,682 5.9% 5,739,824 5,544,887 194,937 3.4% 7,825,569 70.9% Employer Taxes 136,589 150,246 (13,657) -10.0% 429,045 459,089 (30,045) -7.0% 589,461 77.9% Employer Retirement Contributions 1,763,194 1,818,537 (55,343) -3.1% 5,357,857 5,461,805 (103,948) -1.9% 7,449,694 73.3% OPEB Contributions 515,000 547,500 (32,500) -6.3% 1,545,000 1,652,111 (107,111) -6.9% 2,060,000 80.2% Benefit Adjustments (1,234,893) (1,178,956) (55,937) 4.5% (3,844,783) (3,831,717) (13,067) 0.3% (5,236,000) 73.2% Total Employee Benefits 3,230,712 3,267,467 (36,755) -1.1% 9,226,942 9,286,176 (59,234) -0.6% 12,688,724 73.2% Unfunded Liability Costs Pension 325,618 9,889 315,730 97.0% 978,762 83,786 894,976 91.4% 1,306,845 6.4% OPEB 315,000 627,501 (312,501) -99.2% 945,000 1,882,499 (937,499) -99.2% 1,260,000 149.4% Total Unfunded Liability Costs 640,618 637,390 3,229 0.5% 1,923,762 1,966,285 (42,523) -2.2% 2,566,845 76.6% Purchased Property Services Repairs&Maintenance 927,070 648,409 278,661 30.1% 2,781,210 2,280,047 501,163 18.0% 3,711,280 61.4% Hauling&Disposal 264,250 402,242 (137,992) -52.2% 792,750 1,062,076 (269,326) -34.0% 1,057,000 100.5% Security 115,375 87,833 27,542 23.9% 346,125 266,885 79,240 22.9% 461,500 57.8% Rentals 61,962 72,793 (10,830) -17.5% 185,887 191,648 (5,760) -3.1% 247,850 77.3% Cleaning 110,802 118,383 (7,580) -6.8% 332,407 325,336 7,071 2.1% 443,210 73.4% Construction 1,500 1,500 100.0% 4,500 4,500 100.0% 6,000 0.0% Total Purchased Property Services 1,480,960 1,329,659 151,301 10.2% 4,442,880 4,125,992 316,888 7.1% 5,926,840 69.6% (Continued on page 9) 8 1 P a g e May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 116 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 256,702 85,304 171,398 66.8% 646,873 379,587 267,286 41.3% 925,180 41.0% Technical Services 902,544 432,912 469,632 52.0% 2,707,632 1,164,562 1,543,070 57.0% 3,722,176 31.3% Other Purchased Services 482,235 678,429 (196,194) -40.7% 1,895,745 1,235,918 659,827 34.8% 2,287,485 54.0% Total Purchased Professional, Technical&Other Services 1,641,480 1,196,645 444,835 27.1% 5,250,250 2,780,067 2,470,183 47.0% 6,934,841 40.1% Supplies&Materials Utilities&Fuel 1,203,337 1,735,998 (532,661) -44.3% 3,610,012 4,519,121 (909,108) -25.2% 4,988,350 90.6% Chemicals 381,500 398,543 (17,043) -4.5% 1,144,500 1,316,920 (172,420) -15.1% 1,682,000 78.3% General Supplies 949,671 593,787 355,884 37.5% 2,870,013 2,067,326 802,687 28.0% 3,842,384 53.8% Total Supplies&Materials 2,534,508 2,728,328 (193,819) -7.6% 7,624,525 7,903,366 (278,841) -3.7% 10,512,734 75.2% Other Expenses Insurance&Risk Management - - - 0.0% - - - 0.0% - 0.0% Memberships 153,375 24,393 128,982 84.1% 429,201 496,578 (67,377) -15.7% 583,251 85.1% Training&Meetings 143,694 61,760 81,934 57.0% 396,031 157,757 238,274 60.2% 540,225 29.2% Miscellaneous Other 11,195 99,365 (88,170) -787.6% 43,585 189,527 (145,942) -334.8% 55,280 342.8% Total Other Expenses 308,264 185,517 122,747 39.8% 868,817 843,863 24,954 2.9% 1,178,756 71.6% Total Expenses $ 18,990,484 $ 18,359,990 $ 630,494 3.3% $ 58,161,320 $ 54,682,279 $ 3,479,040 6.0% $ 79,520,131 68.8% 9 1 P a g e May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 117 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 $ 593,389 $ 417,975 $ 175,414 29.6% $ 1,748,592 $ 1,477,250 $ 271,343 15.5% $ 2,454,169 60.2% Administration 5,016,640 4,783,992 232,649 4.6% 14,765,233 14,063,084 702,150 4.8% 19,901,049 70.7% Engineering and Technical Services 3,565,800 3,389,745 176,056 4.9% 10,919,397 9,318,529 1,600,868 14.7% 14,880,026 62.6% Operations 9,593,817 9,881,780 (287,963) -3.0% 30,065,584 29,020,527 1,045,058 3.5% 40,674,136 71.3% Recycled Water Program 220,838 (113,501) 334,339 151.4% 662,513 802,890 (140,378) -21.2% 1,610,750 49.8% Total Expenses $ 18,990,484 $ 18,359,990 $ 630,494 3.3% $ 58,161,320 $ 54,682,279 $ 3,479,040 6.0% $ 79,520,131 68.8% Year-to-Date Expenses by Department $40,000,000 $30,000,000 $20,000,000 $10,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services ■YTD ■YTD Budget Actual 10Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 118 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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($) NO Budget Actual Variance($) (%) Budget (%) Executive Governance Office of the General Manager $ 285,748 $ 237,153 $ 48,595 17.0% $ 812,305 $ 831,272 $ (18,967) -2.3% $ 1,171,228 71.0% Office of the Secretary of the District 197,197 138,970 58,227 29.5% 610,006 461,654 148,351 24.3% 846,215 54.6% Board of Directors 110,444 41,853 68,591 62.1% 326,282 184,324 141,958 43.5% 436,726 42.2% Administration Office of the Director of Finance and Administration 149,708 146,871 2,837 1.9% 443,716 437,466 6,250 1.4% 616,754 70.9% Finance Division 546,038 586,360 (40,322) -7.4% 1,357,640 1,349,433 8,207 0.6% 1,807,021 74.7% Human Resources Division 2,050,367 1,950,068 100,300 4.9% 5,995,074 5,860,201 134,873 2.2% 7,999,453 73.3% Purchasing Division 409,994 491,482 (81,488) -19.9% 1,269,168 1,366,681 (97,513) -7.7% 1,748,276 78.2% Risk Management Program 257,146 203,952 53,193 20.7% 798,745 595,650 203,095 25.4% 1,074,459 55.4% Public Info/Comm.Services&Intergov Relations Division 455,548 413,510 42,039 9.2% 1,416,732 1,243,304 173,428 12.2% 1,932,181 64.3% Information Technology Division 1,147,839 991,749 156,090 13.6% 3,484,160 3,210,349 273,810 7.9% 4,722,904 68.0% Engineering&Technical Services Office of the Director of Engineering& Technical Services 215,907 399,416 (183,508) -85.0% 651,719 669,078 (17,359) -2.7% 905,205 73.9% Planning&Developmental Services 1,406,381 1,118,022 288,359 20.5% 4,347,865 3,558,159 789,705 18.2% 5,891,208 60.4% Capital Projects Division 20,725 (143,758) 164,483 793.6% 22,116 (792,015) 814,131 3681.1% 26,686 -2967.9% Environmental&Regulatory Compliance 1,922,786 2,016,065 (93,278) -4.9% 5,897,697 5,883,306 14,391 0.2% 8,056,928 73.0% Operations Office of the Director of Operations 148,416 166,126 (17,710) -11.9% 444,614 485,494 (40,880) -9.2% 612,429 79.3% Collection System Operations Division 3,074,915 2,869,997 204,917 6.7% 9,426,823 9,181,465 245,357 2.6% 12,865,365 71.4% Treatment Plant Operations Division 2,808,964 3,821,244 (1,012,280) -36.0% 9,282,331 10,119,708 (837,377) -9.0% 12,350,601 81.9% Treatment Plant Maintenance Division 3,561,523 3,024,412 537,110 15.1% 10,911,817 9,233,860 1,677,957 15.4% 14,845,741 62.2% Recycled Water Recycled Water-General 40,825 (41,495) 82,320 201.6% 122,475 32,640 89,835 73.3% 163,300 20.0% Treatment Plant 17,375 37,265 (19,890) -114.5% 52,125 496,579 (444,454) -852.7% 685,400 72.5% Distribution System 69,163 20,845 48,317 69.9% 207,488 171,945 35,542 17.1% 388,150 44.3% Residential Fill Station 67,600 (130,483) 198,083 293.0% 202,800 101,359 101,441 50.0% 270,400 37.5% Satellite Water Facility 25,875 367 25,508 98.6% 77,625 367 77,258 99.5% 103,500 0.4% Total Expenses $ 18,990,484 $ 18,359,990 $ 630,494 3.3% $ 58,161,320 $ 54,682,279 $ 3,479,040 6.0% $ 79,520,131 68.8% 111Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 119 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 $ 4,275 $ 3,597 $ (678) -15.9% $ 5,569,118 $ 5,664,101 $ 94,983 1.7% $ 10,035,739 56.4% Other Capital Revenues 1,641,650 1,394,135 (247,515) -15.1% 8,742,042 8,533,688 (208,355) -2.4% 22,207,682 38.4% Total Revenue $ 1,645,925 $ 1,397,732 $ (248,193) -15.1% $ 14,311,160 $ 14,197,788 $ (113,372) -0.8% $ 32,243,421 44.0% 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 Sewer Service Charges Other Capital Revenues Revenue Source Category ■YTD ■YTD Budget Actual 12Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 120 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 $ 5,938 $ 3,495 $ (2,443) -41.1% $ 17,813 $ 15,138 $ (2,675) -15.0% $ 23,750 63.7% County Allocated - (225) (225) 5,453,979 5,461,127 7,148 0.1% 9,916,325 55.1% Direct Billed 327 327 102,314 183,877 81,563 79.7% 102,314 179.7% Prior Year Adjustment (1,663) - 1,663 -100.0% (4,988) 3,959 8,946 -179.4% (6,650) -59.5% Other Capital Revenues Facilities Capacity Fees-Gravity Zone 1,449,750 1,188,428 (261,322) -18.0% 4,349,250 3,657,488 (691,762) -15.9% 5,799,000 63.1% Facilities Capacity Fees-Pump Zone 37,750 43,567 5,817 15.4% 113,250 113,478 228 0.2% 151,000 75.2% Capacity Use Charge 24,500 - (24,500) -100.0% 73,500 32,791 (40,709) -55.4% 98,000 33.5% Secured Property Tax - (24,759) (24,759) 3,817,092 4,226,285 409,192 10.7% 6,940,168 60.9% Investment Income 79,750 45,668 (34,082) -42.7% 239,250 89,578 (149,672) -62.6% 319,000 28.1% Other Government Revenue-Concord - - - - - - 8,700,914 0.0% Overtime Inspection 2,000 1,057 (943) -47.2% 6,000 5,366 (634) -10.6% 8,000 67.1% Plan Review 30,250 10,340 (19,910) -65.8% 90,750 61,785 (28,965) -31.9% 121,000 51.1% Main Lines Inspection Fees 17,250 30,807 13,557 78.6% 51,750 176,122 124,372 240.3% 69,000 255.2% Other Agency Reimbursement- - - - - 11,050 11,050 - Miscellaneous Income 400 - (400) -100.0% 1,200 68,136 66,936 5578.0% 1,600 4258.5% Contractual Assessment District 99,027.00 99,027 91,610 91,610 Total Revenues $ 1,645,925 $ 1,397,732 $ (248,193) -15.1% $ 14,311,160 $ 14,197,788 $ (113,372) -0.8% $ 32,243,421 44.0% 131Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 121 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 1(G-H) Cumulative I Cumulative Total Project I FY 2021-22 1 FY 2021-22 1 FY 2021-22 FY 2021-22 FY 2021-22 1 FY 2021-22 Prior Year Prior Year Carryforward to Adopted Budget Adjusted ApprovedActual Remaining Budgets Actuals FY 2021-22 Budget Adjustments Budget Expenditures Expenditures Budget Collection System(CS) $ 60,527,138 48,915,427 11,611,711 39,795,000 39,795,000 51,406,711 23,121,847 28,284,864 Treatment Plant(TP) 63,431,961 41,480,537 21,951,424 45,230,000 - 45,230,000 67,181,424 14,444,463 52,736,961 General Improvements(GI) 15,799,506 14,754,853 1,044,653 3,830,000 750,000 4,580,000 5,624,653 1,242,101 4,382,552 Recycled Water(RW) 16,986,894 13,713,009 3,273,885 16,600,000 - 16,600,000 19,873,885 9,015,289 10,858,596 CIB Contingency 2,500,000 (750,000) 1,750,000 1,750,000 1,750,000 Total $ 156,745,499 $ 118,863,826 $ 37,881,673 $ 107,955,000 $ $ 107,955,000 $ 145,836,673 $ 47,823,700 $ 98,012,973 Capital Improvement Budget Quarterly Results by Program $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $_ Collection Treatment Plant General Recycled Water CIB Contingency System(CS) (TP) Improvements (RW) (GI) Program ■Approved Expenditures ■Actual Expenditures 14Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 122 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ-CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project) A B C A-B D E F +E G C+D+E H I G Cumulative Cumulative Total Project FY 2021-22 FY 2021-22 FY 2021-22 FY 2021-22 FY 2021-22 FY 2021-22 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2021-22 Budget Adjustments Bud et Expenditures E enditures Budget TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 960,000 282,762 677,238 500,000 - 500,000 1,177,238 16,471 1,160,767 *6534 Harper Lane Area CAD 660,370 648,370 12,000 - - - 12,000 12,000 - 7367 Concord Main Metering Station 250,000 852,844 (602,844) - - - (602,844) 119 (602,963) 8419 Collection System Planning LT 1,385,000 1,277,077 107,923 200,000 - 200,000 307,923 93,078 214,845 8436 Moraga/Crossroads PS Project 22,807,000 20,399,420 2,407,580 12,644,000 - 12,644,000 15,051,580 11,747,906 3,303,674 8442 PS Equipment Piping Replacement PH2 364,000 280,985 83,015 200,000 - 200,000 283,015 - 283,015 8443 LG Diameter Pipe line Inspection 1,295,000 168,209 1,126,791 500,000 - 500,000 1,626,791 59,321 1,567,470 8444 Force Main Inspection Program 625,000 15,525 609,475 500,000 - 500,000 1,109,475 2,607 1,106,868 8447 Pump Station Security Improvement 282,000 - 282,000 75,000 - 75,000 357,000 302 356,698 8448 Manhole Modifications 1,607,925 1,359,075 248,850 400,000 - 400,000 648,850 76,008 572,842 8449 Collection System Modeling Support 423,000 156,147 266,853 120,000 - 120,000 386,853 20,561 366,292 8450 Development Sewerage Support 3,132,316 3,137,328 (5,012) 900,000 - 900,000 894,988 593,541 301,447 8451 C.S.Sewer Renovation 4,562,527 576,878 3,985,649 1,136,000 (1,750,000) (614,000) 3,371,649 198,461 3,173,188 8457 Pump Station Upgrades-Ph.2 2,950,000 2,336,364 613,636 3,000,000 - 3,000,000 3,613,636 698,163 2,915,473 8458 Martinez Sewer Renov.Ph.6 4,470,000 4,249,701 220,299 - - - 220,299 217,996 2,303 8459 Lafayette Sewer Renov.Ph.14 4,200,000 3,853,736 346,264 - - - 346,264 258,776 87,488 8460 WC Sewer Renov.Ph.14 5,173,000 4,881,605 291,395 - - - 291,395 279,918 11,477 8461 So.Orinda Sewer Ren.Ph.8 600,000 2,909,663 (2,309,663) 4,600,000 - 4,600,000 2,290,337 3,175,466 (885,129) 8463 No.Orinda Sewer Renov.PH.8 500,000 472,342 27,658 4,600,000 - 4,600,000 4,627,658 1,709,635 2,918,023 8464 Martinez Sewer Renov.Ph.7 500,000 296,826 203,174 2,000,000 - 2,000,000 2,203,174 159,522 2,043,652 8465 WC Sewer Renov.Ph.15 500,000 527,035 (27,035) 4,900,000 - 4,900,000 4,872,965 2,285,326 2,587,639 8466 Danville Sewer Ren.Ph.4 500,000 202,056 297,944 1,000,000 - 1,000,000 1,297,944 179,509 1,118,435 100005 Cured-In-Place Pipe Contract FY 2020-25 600,000 - 600,000 250,000 - 250,000 850,000 - 850,000 100006 Contractual Assessment District Proj Financing 500,000 - 500,000 500,000 (167,060) 332,940 832,940 67,194 765,746 100007 Large Diameter Priping Renovation Program 1,500,000 - 1,500,000 500,000 - 500,000 2,000,000 302 1,999,698 100017 SR Pump Station Electrical Upgrades 180,000 31,479 148,521 520,000 - 520,000 668,521 56,290 612,231 **100021 Cordel Drive West CAD - - - - 167,060 167,060 167,060 144,620 22,440 **100023 Walnut Creek Sewer Renovation Ph.16 - - - - 500,000 500,000 500,000 416,834 83,166 **100024 South Orinda Sewer Renovation Ph.9 - - - - 500,000 500,000 500,000 281,305 218,695 **100025 Lafayette Sewer Renov.Ph.15 - - - - 500,000 500,000 500,000 113,336 386,664 **100026 Pacheco Boulevard Sewer Renovation - - - - 250,000 250,000 250,000 249,860 140 TBD Collection System Master Plan 2021 Update - - - 750,000 - 750,000 750,000 7,420 742,580 Rounding Total CS Program $ 60,527,138 48,915,427 11,611,711 39,795,000 39,795,000 51,406,711 23,121,847 28,284,864 * Substantially complete FY 20/21 ** Not in 21/22 Budget.New projects.Funds transferred from other projects or Contingency 151Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 123 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C A-B D E F +E G C+D+E H I G- Cumulative Cumulative Total Project FY 2021-22 FY 2021-22 FY 2021-22 FY 2021-22 FY 2021-22 FY 2021-22 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2021-22 Budget Adjustments Bud et Expenditures E enditures Budget TYPE TP Treatment Plant 7304 Instr&Controls PLC Upgrade 620,000 520,734 99,266 120,000 - 120,000 219,266 8,613 210,653 7315 Applied Research and Innovations 1,357,274 476,040 881,234 300,000 - 300,000 1,181,234 645,603 535,631 7328 Influent Pump Electrical improvements 4,910,000 3,588,503 1,321,497 3,250,000 - 3,250,000 4,571,497 3,569,107 1,002,390 7339 T.Plant Control System 1/0 Replacement 3,470,000 3,115,113 354,887 - - - 354,887 13,603 341,284 7341 WC/Grayson Creek Levee Rehab 550,000 137,840 412,160 500,000 - 500,000 912,160 142,789 769,371 7348 Solids Handling FacilityImprovements 17,118,687 15,688,482 1,430,205 21,000,000 (3,600,000) 17,400,000 18,830,205 1,347,652 17,482,553 7349 Aeration&Energy Upgrade 5,600,000 4,228,795 1,371,205 250,000 (500,000) (250,000) 1,121,205 139,731 981,474 7352 UV Disinfection Upgrades 1,350,000 757,400 592,600 - - - 592,600 285,571 307,029 7353 Outfall Improvements Ph.7 5,920,000 5,665,520 254,480 - - - 254,480 110,498 143,982 7354 TP Security Improvements 1,255,000 191,152 1,063,848 445,000 (1,508,371) (1,063,371) 477 11,196 (10,719) 7355 Odor Control Upgrade Ph.1 300,000 - 300,000 - - - 300,000 - 300,000 7357 Plant Wide Instrumentation Upgrade 1,021,000 110,485 910,515 400,000 - 400,000 1,310,515 - 1,310,515 *7360 Existing Plant Facility Drawing 300,000 303,726 (3,726) - - - (3,726) (49,978) 46,252 7363 Treatment Plant Planning 1,800,000 1,363,973 436,027 300,000 - 300,000 736,027 302,612 433,415 7364 TP Safety Enhancement Ph.5 1,180,000 1,147,459 32,541 - - - 32,541 14,148 18,393 7369 Piping Renovation-Phase 10 3,250,000 667,413 2,582,587 2,200,000 - 2,200,000 4,782,587 489,315 4,293,272 7370 Annual Infrastructure Replacement 2,350,000 1,186,034 1,163,966 1,255,000 - 1,255,000 2,418,966 644,436 1,774,530 7371 Condition Assessment of Buried Pipelines 500,000 - 500,000 - - - 500,000 - 500,000 7373 Fire Protection System Ph.3 650,000 219,863 430,137 450,000 - 450,000 880,137 185,905 694,232 7375 Contractor Staging Improvements 3,500,000 623,407 2,876,593 - 1,508,371 1,508,371 4,384,964 3,549,380 835,584 100001 UPCAA Urgent Projects FY 2020-25 600,000 157,502 442,498 600,000 - 600,000 1,042,498 10,948 1,031,550 100008 Laboratory Roof&Seismic upgrades 500,000 - 500,000 450,000 - 450,000 950,000 17,983 932,017 100009 Hearth Replacement 500,000 - 500,000 - - - 500,000 30,581 469,419 100010 Air Condiditioning&Lighting Renovation 750,000 266 749,734 500,000 - 500,000 1,249,734 22 1,249,712 100011 Plant Electrical Replacement&Rehabilitation 400,000 7,916 392,084 200,000 - 200,000 592,084 69,279 522,805 100012 UV Disinfection Replacement 500,000 193,232 306,768 2,000,000 - 2,000,000 2,306,768 654,300 1,652,468 100013 UV Hydraulic Improvements 480,000 5,480 474,520 - - - 474,520 1,124 473,396 100014 MRC Building Modifications 450,000 978 449,022 300,000 - 300,000 749,022 843 748,179 100015 Electric Blower Improvements 1,750,000 916,828 833,172 7,400,000 - 7,400,000 8,233,172 1,418,214 6,814,958 100018 Outfall Monitoring Improvements 100,000 13,214 86,786 510,000 - 510,000 596,786 120,986 475,800 100019 Aeration Basins Diffuer Replacement and Seismic L 200,000 15,097 184,903 2,100,000 - 2,100,000 2,284,903 660,229 1,624,674 **100022 Wet Weather Basin Improvements 200,000 178,085 21,915 500,000 - 500,000 521,915 35,308 486,607 **100030 Solids Handling Facility Improvements Ph.2 - - - - 3,600,000 3,600,000 3,600,000 14,465 3,585,535 **100032 Steam Renovations,Ph.1 - - - - 500,000 500,000 500,000 - 500,000 TBD TP Safety Enhancemetns-Ph.6 - - - 200,000 - 200,000 200,000 - 200,000 Rounding Total TP Program $ 63,431,961 $ 41,480,537 $ 21,951,424 $ 45,230,000 $ $ 45,230,000 $ 67,181,424 $ 14,444,463 $ 52,736,961 * Substantially complete FY 20/21 ** Not in 20/21 Budget.New projects.Funds transferred from other projects or Contingency 16Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 124 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ-CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C A-B D E F +E G C+D+E H I G Cumulative I Cumulative Total Project FY 2021-22 FY 2021-22 FY 2021-22 1 FY 2021-22 FY 2021-22 FY 2021-22 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2021-22 Budget Adjustments Bud et Expenditures Expenditures Budget TYPE GI General Improvements 8230 Capital Legal Services 208,665 199,064 9,601 20,000 - 20,000 29,601 21,080 8,521 8236 District Easements 408,047 256,934 151,113 75,000 - 75,000 226,113 25,407 200,706 8240 IT Development 3,738,794 3,723,005 15,789 750,000 - 750,000 765,789 172,113 593,676 8250 ERP Replacement 5,030,000 5,189,106 (159,106) 300,000 50,000 350,000 190,894 137,877 53,017 8251 Capital improvement program&Budget Improvers 490,000 124,024 365,976 100,000 (200,000) (100,000) 265,976 4,071 261,905 8252 POB E.V.Charging Station 30,000 21,749 8,251 460,000 - 460,000 468,251 - 468,251 8253 COVID-19 Response 200,000 97,655 102,345 75,000 - 75,000 177,345 604 176,741 8516 District Equipment Acquisition 1,226,000 1,244,370 (18,370) 250,000 - 250,000 231,630 27,527 204,103 8517 Vehicle Replacement Program 3,818,000 3,718,421 99,579 900,000 - 900,000 999,579 558,857 440,722 100003 Property Repairs&Improvements 300,000 156,418 143,582 150,000 - 150,000 293,582 100,695 192,887 100004 HOB Exterior Repairs 350,000 24,107 325,893 50,000 - 50,000 375,893 187,875 188,018 *100027 Furnishings Replacement - - - - 100,000 100,000 100,000 - 100,000 *100029 Solar Project on Lagiss - - - - 600,000 600,000 600,000 - 600,000 *100031 Community Dev.System Replacement - - - - 200,000 200,000 200,000 4,846 195,154 100033 Security Improvements FY 2021-25 - - - 200,000 - 200,000 200,000 - 200,000 TBD Technology Strategic Plan - - - 500,000 - 500,000 500,000 - 500,000 9999 Capital Project Clearing(Accounting Use Only) - - - - - - - 1,149 (1,149) Rounding Total GI Program $ 15,799,506 14,754,853 1,044,653 3,830,000 750,000 4,580,000 5,624,653 1,242,101 4,382,552 * Not in 20/21 Budget New projects.Funds transferred from other projects or Contingency TYPE RW Recycled Water 7306 Zone 1 Recycled Water 732,894 631,427 101,467 - - - 101,467 44,043 57,424 7361 Filter Plant&Clearwell Improvements Ph.1A 14,989,000 12,823,576 2,165,424 16,000,000 - 16,000,000 18,165,424 8,895,330 9,270,094 7366 ReW Distribution System Renov.Program 515,000 115,869 399,131 200,000 - 200,000 599,131 70,940 528,191 7368 Water Exchange Project 350,000 142,137 207,863 50,000 - 50,000 257,863 - 257,863 100002 Filter Plant&Clearwell Improvements Ph.1B 400,000 - 400,000 250,000 - 250,000 650,000 4,976 645,024 TBD Zone 1 Recycled Water 2021 - - - 100,000 - 100,000 100,000 - 100,000 Rounding Total RW Program $ 16,986,894 13,713,009 3,273,885 16,600,000 16,600,000 19,873,885 9,015,289 10,858,596 171Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 125 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 County $ $ $ $ 1,576,419 $ 1,576,419 $ 0.0% $ 1,576,419 100.0% Subrogation Recoveries - - Insurance Recoveries(HHW) 6,250 (6,250) -100.0% 18,750 - (18,750) -100.0% 25,000 0.0% Investment Income 12,500 6,428 (6,072) -48.6% 37,500 14,444 (23,056) -61.5% 50,000 28.9% Total Revenues $ 18,750 $ 6,428 $__(I 2,3 2 2 -65.7% $ 1,632,669 $ 1,590,863 $ (41,806) -2.6% $ 1,651,419 96.3% Year-to-Date Revenues by Source $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 Sewer Service Charge County Subrogation Recoveries Insurance Recoveries(HHW) Investment Income Revenue Source Category ■YTD ■ YTD Budget Actual 18Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 126 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 5 - Self Insurance Fund Expenses by Type Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance($) (%) Budget Actual Variance($) (%) Budget (%) Professional Services $ 25,000 $ 102,335 $ (77,335) -309.3% $ 75,000 $ 223,081 $ (148,081) -197.4% $ 140,000 159.3% Technical Services 12,500 (14,060) 26,560 212.5% 37,500 82,710 (45,210) -120.6% 60,000 137.9% Insurance&Risk Management 271,250 267,039 4,211 1.6% 813,750 942,649 (128,899) -15.8% 1,085,000 86.9% Total Expenses $308,750 $ 355,314 $ (46,564) -15.1% $ 926,250 $ 1,248,440 $ (322,190) -34.8% $ 1,285,000 102.9% Year-to-Date Expenses by Type $1,000,000 $900,000 $600,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 MAW Professional Services Technical Services Insurance&Risk Management Expense Category ■YTD ■YTD Budget Actual 19Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 127 of 172 iCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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,090,082 $ 6,985,671 $ (104,411) -1.5% $ 12,891,059 Investment Income 20,353 20,353 - 20,353 20,353 - Total Revenues $ $ 20,353 $ 20,353 $ 7,090,082 $ 7,006,024 $ (84,058) -1.2% $ 12,891,059 54.3% 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 May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 128 of 172 c.CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 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 $ - $ - $ $ - $ 2,200 $ (2,200) $ Principal Payment Expense 8,645,000 10,450,000 (1,805,000) -20.9% 10,450,000 10,450,000 - 0.0% 10,450,000 100.0% Interest Expense 2,068,111 2,068,111 (0) 0.0% 2,441,059 2,192,427 248,632 10.2% 2,441,059 111.3% Total Expenses $ 10,713,111 $ 12,527,294 $ (1,814,183) -16.9% $ 12,891,059 $ 12,653,810 $ 237,249 1.8% $ 12,891,059 98.2% 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 May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 129 of 172 ,AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 7 - Quarterly Investment Portfolios Operating&Maintenance 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 n/a n/a n/a (1) $ 5,400,000 $ 15,100,000 $ (9,700,000) $ 5,400,000 $ 5,366,534 17.48% $ 15,218 $ 34,565 RE17 US T-Bill US Treasury 1/21/2022 7/21/2022 112 0.330% 10,482,579 - 10,500,000 10,500,000 10,478,475 33.98% 6,738 6,738 RE18 US T-Bill US Treasury 1/21/2022 4/22/22 22 0.179% 14,993,213 15,000,000 15,000,000 14,998,500 48.54% 5,221 5,221 (3) $ 30,875,792 $ 15,100,000 $ 15,800,000 $ 30,900,000 $ 30,843,509 100.00% 27,176 46,523 (2) (4) (8) 12,388 $ 27,176 $ 58,911 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 March,2022 was 0.350%. (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 0.260%.As the District is a voluntary participant in the County Treasury Pool,this calculation excludes investments purchased after the 15th day of the month,which is the cut-off for month-end reporting by Contra Costa County. (4)The market value of the portfolio on March 31,2022 was$30,843,509.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. Italicized investments matured over the weekend. The reinvestment,transacted on Monday,will be included in the following month's report. 221Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 130 of 172 ,AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 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) $ 36,000,000 $ 38,000,000 $ (2,000,000) $ 36,000,000 $ 35,776,895 54.55% $ 23,875 $ 34,602 959 US T Bill US Treasury 1/21/2022 4/22/2022 22 0.18%% 14,993,213 - 15,000,000 15,000,000 14,998,500 22.73% 5,221 5,221 960 US T Bill US Treasury 1/21/2022 7/21/2022 112 0.33% 12,479,260 - 12,500,000 12,500,000 12,479,407 18.94% 8,021 8,021 961 US T Bill US Treasury 1/21/2022 1/15/2025 1021 1.26%% 2,490,505 2,500,000 2,500,000 2,409,575 3.79% 610 610 (3) _L65.162 _$1q000.000 _L1q&00 _L66&00.000 $ 65.664.377 100.00% 37,727 48,454 (2) (4) (8) 10,417 $ 37.727 $ 58.871 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 March,2022 was 0.35%. (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 0.342%.As the District is a voluntary participant in the County Treasury Pool,this calculation excludes investments purchased after the 15th day of the month,which is the cut- off for month-end reporting by Contra Costa County. (4)The market value of the portfolio on March 31,2022 was$65,664,377.GASB 31 requires adjusting investments to market value.The District will adjust annually,but report market values monthly. (5)All investments held by the Sewer Construction Fund comply with Central San's investment policy approved by the Board of Directors[California Government Code§53646(b)(2)] (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)] (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 May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 131 of 172 ,AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 7 - Quarterly Investment Portfolios Self Insurance Fund QTD YTD Purchase Maturity Daysto Annual Cash BOQ Purchase EOQ EOQ %of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif. LAW 10/99- n/a n/a (1) $ 11,100,000 $ 7,100,000 $ 4,000,000 $ 11,100,000 $ 11,031,209 100.00% $ 6,012 $ 13,965 (3) $ 11,100,000 $ 7,100,000 $ 4,000,000 $ 11,100,000 $ 11,031,209 100.00% 6,012 13,965 (2) (4) (7) 4,484 $ 6,012 $ 18,449 Legend: EOQ=End of quarter BO =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 March,2022 was 0.35%. (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 0.35%. (4)The market value of the portfolio on March,2022 was$11,031,209. (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 May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 132 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 8 - Financial Performance Metric Charts O&M Fund Cashflow Forecast FY 2021-22 Running Expense Fund Total Cash & Investment Balances (Actuals through March 2022) $80.0 $71.0 $70.0 $67.5 $67.7 $60.0 $5 $60.1 $ $55.5 56.7 $51.4 $50.0 $46.4 $39.1 131.4 $40.0 $ , $33 / 5.4 $35.1 $30.0 $28..a S28.e sm. 111 $23.9 $23.9 $23.9 r$23.3 $20.0 $10.0 $0.0 June'21 July August September October November December January February March April May June =Projected Balance* =Actual Balance Reserve Target at Year End** NOTES:*Projected balances were generated in July 2021 based on budgeted revenues and expenses for FY 2021-22 and applied to the actual balance at June 30,2021 **The Reserve Target at Year End is the minimum balance required at June 30,2022 to comply with the District Policy 251Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 133 of 172 iCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast FY 2021-22 Sewer Construction Fund Total Cash & Investment Balances (Actuals through March 2022) $80.0 $77.5 $74.9 $71.5 $71.0 $70.0 $63 $63.6 4 $60.5 7 $57 $60.0 $56.3 $56.3 $57.1 $56.9 $56. .5 $56.3 $55.6 553.6 $50.8 $50.0 $ az5 $48 8 $41.2 5a1.2 $41 s $40.0 ao.1 $30.0 $z4s $20.0 $10.0 $0.0 June'21 July August September October November December January February March April May June MProjected Balance* 111111111MActual Balance —Reserve Target at Year End** NOTES:*Projected balances were generated in July 2021 based on budgeted revenues and expenses for FY 2021-22 and applied to the actual balance at June 30,2021 **The Reserve Target at Year End is the minimum balance required at June 30,2022 to comply with the District Policy 261Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 134 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 8 - Financial Performance Metric Charts Staffing Trends 300 7.9%vacancy Rate 295 290 14 V) 0� 285 18 w a� 280 Cz 275 w E 270 E 265 277 279 � 275 w 260 255 mi 250 3/31/19 3/31/20 3/31/21 3/31/22 Quarter Ended ■Filled Positions(FTEs) ■Vacancies(FTEs) 27Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 135 of 172 'AM'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated Historical Quarterly 0&M Cost per Million Gallons Treated $4,000 $3,163 $3,230 $3,241 $3,500 $2,541 $3,000 $2,500 $2,000 $1,500 $1,000 $500 3/31/19 3/31/20 3/31/21 3/31/22 Third Quarter of Fiscal Year 28Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 136 of 172 'AM'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 8 - Financial Performance Metric Charts Capital Spending Trend $160 $145.9M $140 $120 $111.3M o $100 $80 - - $60 - - $40 - - $47.8M $20 NIS, Projected(100%spend) Actual Target 29Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 137 of 172 'AMI'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-:392 Budget-to-Actual Financial Report Quarter Ending March 31, 2022 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed/ Renovated 4.0 3.5 7z 3.0 ` U N 2.5 0 2.0 U 1.8 2.0 1.7 p. a 1.3 a 1.5 ti 1.0 0.9 1.0 0.5 0.5 0.0 a Ig0I11 1tiI31Iti1 3I31I�� b Igo I�L Quarter Ending ■Actual Construction ■Target("S-Curve"of 6 mi.FY 21-22 Budget Projection) 30Page May 24, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 138 of 172