Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
04.b. Receive Quarterly Financial Review - quarter ended June 30, 2022
Page 1 of 34 Item 4.b. CENTRAL SAN September 27, 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 JUNE 30, 2022 Attached is the Quarterly Financial Reviewfor the fourth quarter of Fiscal Year (FY) 2021-22 ending June 30, 2022. The Executive Summary (Section 1) of the attached report includes an analysis of financial results and the investment portfolios for the quarter. GOAL FOUR: Governance and Fiscal Responsibility Strategy 1 - Promote and uphold ethical behavior, openness, and accessibility, Strategy 3- Maintain financial stability and sustainability ATTACHMENTS: 1. Quarterly Financial Review for the Quarter Ended June 30, 2022 September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 123 of 171 . . uarterFinancial _s CENTRAL SAN Review rw AM i Im �I ISI, -- September 27, 2022 Regular FINANCE Committee Meeting Agenda124 , !Ended June 30, 2022 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Table of Contents Section1 -Executive Summary................................................................................................................................................................................................1 Section 2 -Financial Results Summary by Fund................................................................................................................................................................4 Section 3 - Operations&Maintenance Fund Revenues Revenuesby Source- Summary........................................................................................................................................................................................................5 Revenuesby Source- Detail...............................................................................................................................................................................................................6 Expenses Expensesby Type-Summary............................................................................................................................................................................................................7 Expensesby Type- Detail....................................................................................................................................................................................................................8 Expenses by Organizational Unit- Summary(Department) .............................................................................................................................................10 Expenses by Organizational Unit- Detail (Division).............................................................................................................................................................11 Section 4-Sewer Construction Fund Revenues Revenuesby Source- Summary.....................................................................................................................................................................................................12 Revenuesby Source- Detail............................................................................................................................................................................................................13 Expenses ExpensesSummary(by Program).................................................................................................................................................................................................14 ExpensesDetail (by Project)............................................................................................................................................................................................................15 Section 5 -Self Insurance Fund Revenuesby Source.............................................................................................................................................................................................................................18 Expensesby Type.................................................................................................................................................................................................................................19 September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 125 of 171 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Table of Contents Section 6-Debt Service Fund Revenuesby Source.............................................................................................................................................................................................................................20 Expensesby Type.................................................................................................................................................................................................................................21 Section 7-Investment Portfolio Reports Operations&Maintenance Fund....................................................................................................................................................................................................22 SewerConstruction Fund..................................................................................................................................................................................................................23 SelfInsurance Fund.............................................................................................................................................................................................................................24 Section 8-Financial Performance Metrics 0&M Fund Cashflow Forecast.........................................................................................................................................................................................................25 Sewer Construction Fund Cashflow Forecast...........................................................................................................................................................................26 StaffingTrends.......................................................................................................................................................................................................................................27 Cost per Million Gallons of Wastewater Treated.....................................................................................................................................................................28 CapitalSpending Trend......................................................................................................................................................................................................................29 Milesof Pipeline Constructed/Renovated..................................................................................................................................................................................30 September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 126 of 171 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 1 -Executive Summary Quarterly Financial Highlights Included in this consolidated report are quarterly budget-to-actual financial results as well as the investment portfolio reports for the fourth quarter of FY 2021-22 ended June 30, 2022. The underlying reports present unaudited quarterly results for the Running Expense (0&M), Sewer Construction, Self-Insurance, and Debt Service funds. Operating&Maintenance Fund 0&M Fund results for the fourth quarter show total expenditures are $76.9 million, which is approximately $2.6 million (3.2%) under the projected FY 2021-22 budget. This favorable expense variance, largely attributable to lower than projected annual spending in the other purchased services category, is smaller than the favorable annual budget variance reported in the fourth quarter of the prior year of 4.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$3.3 million (47.1%). In the aggregate, the 0&M Fund is reporting an annual favorable revenue variance of approximately $4.7 million, which is approximately 4.0% above total estimated annual 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 fourth quarter show total capital project expenditures of $73.6 million, or 68.2% of the total adopted budget of $108.0 million. While the Sewer Construction fund's FY 2021-22 adopted budget was $108.0 million, when including roll-over capital project appropriations from the prior year of$37.9 million the total adjusted budget for FY 2021-22 is $145.8 million. After factoring in the roll-over, the year-to-date capital spending rate is 50.5% 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 reconsideration of this project to 11Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 127 of 171 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 1 -Executive Summary include a wider range of alternatives (including potentially digestion) for solids handling 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 (57.0%) followed by the Collection System program (19.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 $32.2 million, almost precisely the adopted budget amount. Upon examining the details one can see that a large favorable variance in secured property tax revenues largely offsets the negative revenue variances in facilities capacity fees and the annual capital cost sharing reimbursement from the City of Concord. Investment Portfolio Highlights In accordance with Section 53646 of the California Government Code as well as Central San's Investment Policy, the Finance Division is required to submit an investment report to the General Manager and Board of Directors at least quarterly. The investments held by Central San for the quarter ended June 30, 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 fourth quarter of FY 2021-22, the 0&M Fund investment portfolio has generated $106,621 of income which is below the year-to-date revenue estimate of$180,000 by 40.8%. The Sewer Construction Fund portfolio is reporting $186,622 of income, coming in well under the year-to-date revenue estimate of $319,000 by 41.5%. 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 0&M fund at the onset of FY 2021-22. The proceeds from the issuance of the June 2021 Certificates of Participation of$58.0 2 1 P a g e September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 128 of 171 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 1 -Executive Summary 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, by 50 basis points in May 2022, and then by an additional 75 basis points in June 2022 historically low rates in the first half of the year have taken their toll. As of June 30, 2022, Central San continues to hold the bulk of its investment portfolio, or $64.0 million, in the Local Agency Investment Fund (LAIF) state investment pool, under the maximum amount permitted to be held in the pool of $75 million. As interest rates continue to rise during FY 2022-23 staff has been implementing a more diverse portfolio which now includes more U.S. Treasury Bills and Federal Agency Notes, with maturity dates ranging from 6 to 36 months. While staff does intend to continue exploring investment alternatives, it is stressed that given the restricted nature of municipal investing, additional efforts are not expected to yield significant results to Central San's bottom line, with the 0&M investment earnings contributing less than 0.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 June 30, 2022. Furthermore, as a statement of compliance, Central San is expected to meet expenditure requirements for the next six (6) months from a combination of maturing investments and budgeted revenues. 3 1 P a g e September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 129 of 171 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 2 -Financial Results Summary by Fund Annual YTD Budget YTD YTD YTD Variance Annual Realized Category Budget Actual Variance($) (%) Budget (%) Fund Revenues 0&M $ 116,681,763 $ 121,395,876 4,714,113 4.0% $ 116,681,763 104.0% Sewer Construction 32,243,421 32,229,752 (13,669) 0.0% 32,243,421 100.0% Self Insurance 1,651,419 1,632,998 (18,421) -1.1% 1,651,419 98.9% Debt Service 12,891,059 12,517,658 (373,401) -2.9% 12,891,059 97.1% Total $ 163,467,662 $ 167,776,283 $ 4,308,621 $ 163,467,662 Fund Expenses 0&M $ 79,520,131 $ 76,946,792 2,573,339 3.2% $ 79,520,131 96.8% Sewer Construction 107,955,000 73,636,093 34,318,907 31.8% 107,955,000 68.2% Self Insurance 1,285,000 1,640,304 (355,304) -27.7% 1,285,000 127.7% Debt Service 12,891,059 12,403,716 487,343 3.8% 12,891,059 96.2% Total $ 201,651,190 $ 164,626,905 $ 37,024,285 $ 201,651,190 YTD Budget-to-Actual Revenues by Fund YTD Budget-to-Actual Expenses by Fund Efio,000,000 8601000,000 $50,000,000 $]0,000,000 $90,000,000 $fi0,000,ow $50,000,000 E3o,0o0,000 840,000,000 $20,000,000 $30,008000 E10,000,000 $20,000.000 810,000,000 ' — $- E- - 0&M Sewer Co rtstruRion SWI....... Deb[Service O&M Debt Service Fund Fund •YTD •YTD •YTD •YTD BUdgC Actual Budgx Accaal 4Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 130 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 3 - Operations & Maintenance Fund Revenues by Source - Summary Level Annual QTD QTD QTD QTD Variance YTD YTD YTD YTD Annual Budget Category Budget Actual Variance($] (%) Budget Actual Variance($) Variance(%) Budget Realized(%] Operating Revenues: Sewer Service Charge Revenue $ 42,884,687 $ 44,385,432 $ 1,500,744 3.5% $ 96,331,829 $ 99,104,227 $ 2,772,398 2.9% $ 96,331,829 102.9% Sewage Treatment Cost Sharing 15,445,534 16,134,761 689,227 4.5% 15,445,534 16,086,801 641,267 4.2% 15,445,534 104.2% Miscellaneous Service Charge 1,360,250 1,498,382 138,132 10.2% 2,078,000 2,130,957 52,957 2.5% 2,078,000 102.5% Non-Operating Revenues: Permit and Inspection Fees 473,600 563,932 90,332 19.1% 1,894,400 2,048,087 153,687 8.1% 1,894,400 108.1% Other Non Operating Income 188,000 210,953 22,953 12.2% 752,000 1,882,761 1,130,761 150.4% 752,000 250.4% Investment Income 87,000 92,486 5,486 6.3% 180,000 143,043 (36,957) -20.5% 180,000 79.5% Total Revenue $ 60,439,071 $ 62,885,945 $ 2,446,874 4.0% $ 116,681,763 $ 121,395,876 $ 4,714,113 4.0% $ 116,681,763 104.0% Year-to-Date Revenues by Source $100,000,000 $90,000,000 _ $80,000,000 $70,000,000 ,. $60,000,000 _ $50,000,000 $49,000,000 $30,000,000 $20,000,000 $10,000,000 Sewer Service Charge Revenue Sewage Treatment Cost Miscellaneous Service Charge Permit and Inspection Fees Other Non Operating Income Investment Income Sharing Revenue Source Category ■YTD ■YTD Budget Actual 5 � Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 131 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 3 - Operations & Maintenance Fund Revenues by Source - Detail Level Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance($) (%) Budget Actual Variance($) (%) Budget (%) Sewer Service Charge Revenue Sewer Service Charge Counter $ 55,776 $ 121,743 $ 65,967 118.3% $ 223,105 $ 394,151 $ 171,046 76.7% $ 223,105 176.7% Sewer Service Charge County 42,844,529 44,235,609 1,391,080 3.2% 95,210,064 96,871,581 1,661,517 1.7% 95,210,064 101.7% Sewer Service Charge Direct - 28,079 28,079 961,131 1,800,342 839,211 87.3% 961,131 187.3% Sewer Service Charge Prior (15,618) - 15,618 -100.0% (62,471) 38,153 100,624 -161.1% (62,471) -61.1% Sewage Treatment Cost Sharing 15,445,534 16,134,761 689,227 4.5% 15,445,534 16,086,801 641,267 4.2% 15,445,534 104.2% Miscellaneous Service Charges Septic Tank Dumping 9,500 15,492 5,992 63.1% 38,000 46,078 8,078 21.3% 38,000 121.3% Sales 250 - (250) -100.0% 1,000 - (1,000) -100.0% 1,000 0.0% Other Service Charges 240,000 162,523 (77,477) -32.3% 240,000 165,226 (74,774) -31.2% 240,000 68.8% Recycled Water 108,000 231,993 123,993 114.8% 432,000 545,048 113,048 26.2% 432,000 126.2% Satellite Water Recycling - - - - - - - Stormwater Program 97,500 203,242 105,742 108.5% 390,000 416,305 26,305 6.7% 390,000 106.7% Household Hazardous Waste 905,000 885,132 (19,868) -2.2% 977,000 958,300 (18,700) -1.9% 977,000 98.1% Permit&Inspection Fees Permit/Application Fees 135,000 151,609 16,609 12.3% 540,000 576,918 36,918 6.8% 540,000 106.8% Overtime Inspection 3,600 732 (2,869) -79.7% 14,400 9,018 (5,382) -37.4% 14,400 62.6% Side Sewer Inspection 292,500 370,007 77,507 26.5% 1,170,000 1,298,371 128,371 11.0% 1,170,000 111.0% Industrial Permit Fees 26,250 16,015 (10,235) -39.0% 105,000 102,005 (2,995) -2.9% 105,000 97.1% New Industry Permit Fees 3,750 2,056 (1,694) -45.2% 15,000 10,956 (4,044) -27.0% 15,000 73.0% Annexation Charges 12,500 15,984 3,484 27.9% 50,000 43,290 (6,710) -13.4% 50,000 86.6% Other Non-Operating Income MVSD P2 Program 6,250 13,649 7,399 118.4% 25,000 26,062 1,062 4.2% 25,000 104.2% Pretreatment Program Fine 500 - (500) -100.0% 2,000 2,000 (0) 0.0% 2,000 100.0% Rebates to District - - - - - - - Lease Rental Income 178,750 118,900 (59,850) -33.5% 715,000 712,795 (2,205) -0.3% 715,000 99.7% Miscellaneous Income 2,500 61,794 59,294 2371.7% 10,000 118,620 108,620 1086.2% 10,000 1186.2% Right of Way Fees - 10,112 10,112 - 20,691 20,691 - Reimbursements 6,417 6,417 6,417 6,417 Contractual Assessment Dist - - - - State Grants - 81 81 - 996,177 996,177 - Investment Income 87,000 92,486 5,486 6.3% 180,000 143,043 (36,957) -20.5% 180,000 79.5% Total Revenues $ 60,439,071 $ 62,885,945 $ 2,446,874 4.0% $ 116,681,763 $ 121,395,876 $ 4,714,113 4.0% $ 116,681,763 104.0% 6 1 P a g e September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 132 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Type - Summary QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Category Budget Actual Variance($) (%) Budget Actual Variance($) (%) Budget (%) Salaries&Wages $ 10,887,248 $ 11,966,148 $ (1,078,900) -9.9% $ 39,711,391 $ 39,742,679 $ (31,287) -0.1% $ 39,711,391 100.1% Employee Benefits 3,461,781 3,900,198 (438,417) -12.7% 12,688,724 13,186,374 (497,651) -3.9% 12,688,724 103.9% Unfunded Liability Costs 643,084 642,759 325 0.1% 2,566,845 2,609,044 (42,198) -1.6% 2,566,845 101.6% Purchased Property Services 1,483,960 1,578,695 (94,735) -6.4% 5,926,840 5,704,687 222,153 3.7% 5,926,840 96.3% Other Purchased Services 1,684,591 886,930 797,661 47.4% 6,934,841 3,666,997 3,267,844 47.1% 6,934,841 52.9% Supplies&Materials 2,888,208 3,068,941 (180,733) -6.3% 10,512,734 10,972,307 (459,573) -4.4% 10,512,734 104.4% Other Expenses 309,939 220,841 89,098 28.7% 1,178,756 1,064,704 114,052 9.7% 1,178,756 90.3% Total Expenses $ 21,358,811 $ 22,264,513 $ (905,701) -4.2% $ 79,520,131 $ 76,946,792 $ 2,573,339 3.2% $ 79,520,131 96.8% Year-to-Date Expenses by Type $40,000,000 $30,000,000 $20,000,000 $10,000,000 $_ Salaries&Wages Employee Benefits Unfunded Liability Purchased Property Other Purchased Supplies&Materials Other Expenses Costs Services Services Department ■YTD ■ YTD Budget Actual 7Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 133 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail QTD QTD QTD QTD Variance YTD YTD YTD YTD Annual Category Budget Actual Variance($) (%] Budget Actual Variance($] Variance(%) Budget %Used Salaries&Wages FTE Regular Pay $ 9,961,336 $ 9,719,737 $ 241,599 2.4% $ 36,384,957 $ 35,793,370 $ 591,588 1.6% $ 36,384,957 98.4% Temporary Pay 370,103 293,332 76,772 20.7% 1,345,210 293,332 1,051,878 78.2% 1,345,210 21.8% Premium Pay 814,846 1,931,580 (1,116,734) -137.0% 3,174,574 3,586,312 (411,738) -13.0% 3,174,574 113.0% Board Fees 13,663 15,677 (2,014) -14.7% 54,650 53,787 864 1.6% 54,650 98.4% Other (272,700) 5,823 (278,523) 102.1% (1,248,000) 15,879 (1,263,879) 101.3% (1,248,000) -1.3% Total Salaries&Wages 10,887,248 11,966,148 (1,078,900) -9.9% 39,711,391 39,742,679 (31,287) -0.1% 39,711,391 100.1% Employee Benefits Insurance Premiums 2,085,745 2,271,349 (185,603) -8.9% 7,825,569 7,816,235 9,334 0.1% 7,825,569 99.9% Employer Taxes 160,416 168,790 (8,374) -5.2% 589,461 627,879 (38,419) -6.5% 589,461 106.5% Employer Retirement Contributions 2,091,837 2,129,992 (38,155) -1.8% 7,449,694 7,591,797 (142,103) -1.9% 7,449,694 101.9% OPEB Contributions 515,000 407,889 107,111 20.8% 2,060,000 2,060,000 (0) 0.0% 2,060,000 100.0% Benefit Adjustments (1,391,217) (1,077,821) (313,396) 22.5% (5,236,000) (4,909,537) (326,463) 6.2% (5,236,000) 93.8% Total Employee Benefits 3,461,781 3,900,198 (438,417) -12.7% 12,688,724 13,186,374 (497,651) -3.9% 12,688,724 103.9% Unfunded Liability Costs Pension (921,916) 15,258 (937,174) 101.7% 56,845 99,044 (42,198) -74.2% 56,845 174.2% OPEB 1,565,000 627,501 937,499 59.9% 2,510,000 2,510,000 0.0% 2,510,000 100.0% Total Unfunded Liability Costs 643,084 642,759 325 0.1% 2,566,845 2,609,044 (42,198) -1.6% 2,566,845 101.6% Purchased Property Services Repairs&Maintenance 930,070 1,401,735 (471,665) -50.7% 3,711,280 3,681,782 29,498 0.8% 3,711,280 99.2% Hauling&Disposal 264,250 (174,774) 439,024 166.1% 1,057,000 887,302 169,698 16.1% 1,057,000 83.9% Security 115,375 131,414 (16,039) -13.9% 461,500 398,299 63,201 13.7% 461,500 86.3% Rentals 61,962 89,453 (27,491) -44.4% 247,850 281,101 (33,251) -13.4% 247,850 113.4% Cleaning 110,802 130,867 (20,065) -18.1% 443,210 456,203 (12,993) -2.9% 443,210 102.9% Construction 1,500 1,500 100.0% 6,000 6,000 100.0% 6,000 0.0% Total Purchased Property Services 1,483,960 1,578,695 (94,735) -6.4% 5,926,840 5,704,687 222,153 3.7% 5,926,840 96.3% (Continued on page 9) 8 1 P a g e September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 134 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued) QTD QTD QTD QTD Variance YTD YTD YTD YTD Annual Category Budget Actual Variance($) (%) Budget Actual Variance($) Variance(%) Budget %Used Purchased Professional,Technical& Other Services Professional Services 278,307 237,009 41,297 14.8% 925,180 616,596 308,584 33.4% 925,180 66.6% Technical Services 1,014,544 462,358 552,186 54.4% 3,722,176 1,626,920 2,095,256 56.3% 3,722,176 43.7°/% Other Purchased Services 391,740 187,563 204,177 52.1% 2,287,485 1,423,481 864,004 37.8% 2,287,485 62.2% Total Purchased Professional, Technical&Other Services 1,684,591 886,930 797,661 47.4% 6,934,841 3,666,997 3,267,844 47.1% 6,934,841 52.9% Supplies&Materials Utilities&Fuel 1,378,337 2,004,944 (626,607) -45.5% 4,988,350 6,524,065 (1,535,715) -30.8% 4,988,350 130.8% Chemicals 537,500 503,425 34,075 6.3% 1,682,000 1,820,345 (138,345) -8.2% 1,682,000 108.2% General Supplies 972,371 560,572 411,799 42.3% 3,842,384 2,627,898 1,214,486 31.6% 3,842,384 68.4% Total Supplies&Materials 2,888,208 3,068,941 (180,733) -6.3% 10,512,734 10,972,307 (459,573) -4.4% 10,512,734 104.4% Other Expenses Memberships 154,050 20,274 133,776 86.8% 583,251 516,852 66,399 11.4% 583,251 88.6% Training&Meetings 144,194 100,420 43,773 30.4% 540,225 258,178 282,047 52.2% 540,225 47.8% Miscellaneous Other 11,695 100,147 (88,452) -756.3% 55,280 289,675 (234,395) -424.0% 55,280 524.0% Total Other Expenses 309,939 220,841 89,098 28.7% 1,178,756 1,064,704 114,052 9.7% 1,178,756 90.3% Total Expenses $ 21,358,811 $ 22,264,513 $ (905,701) -4.2% $ 79,520,131 $ 76,946,792 $ 2,573,339 3.2% $ 79,520,131 96.8% 9 1 P a g e September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 135 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit- Summary (by Department) QTD YTD QTD QTD QTD Variance YTD YTD YTD Variance Annual Category Budget Actual Variance($] (%] Budget Actual Variance($) (%) Budget %Used Department Executive Governance $ 705,577 $ 479,477 $ 226,100 32.0% $ 2,454,169 $ 1,956,727 $ 497,442 20.3% $ 2,454,169 79.7% Administration 5,135,816 6,373,063 (1,237,248) -24.1% 19,901,049 20,436,147 (535,098) -2.7% 19,901,049 102.7% Engineering and Technical Services 3,960,629 3,413,062 547,567 13.8% 14,880,026 12,731,591 2,148,435 14.4% 14,880,026 85.6% Operations 10,608,552 11,665,302 (1,056,750) -10.0% 40,674,136 40,685,828 (11,692) 0.0% 40,674,136 100.0% Recycled Water Program 948,238 333,608 614,629 64.8% 1,610,750 1,136,499 474,252 29.4% 1,610,750 70.6% Total Expenses $ 21,358,811 $ 22,264,513 $ (905,701) -4.2% $ 79,520,131 $ 76,946,792 $ 2,573,339 3.2% $ 79,520,131 96.8% Year-to-Date Expenses by Department $50,000,000 $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 10 � Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 136 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 3 - Operations & Maintenance Fund Expenses by Organizational Unit- Detail (by Division) QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Variance Annual Realized Organizational Unit Budget Actual Variance($) (%) Budget Actual Variance[$) (%) Budget [%) Executive Governance Office of the General Manager $ 358,923 $ 249,775 $ 109,148 30.4% $ 1,171,228 $ 1,081,046 $ 90,181 7.7% $ 1,171,228 92.3% Office of the Secretary of the District 236,210 183,186 53,023 22.4% 846,215 644,841 201,375 23.8% 846,215 76.2% Board of Directors 110,444 46,516 63,928 57.9% 436,726 230,840 205,886 47.1°/% 436,726 52.9% Administration Office of the Director of Finance and Administration 173,039 195,206 (22,168) -12.8% 616,754 632,672 (15,918) -2.6% 616,754 102.6% Finance Division 449,381 542,047 (92,666) -20.6% 1,807,021 1,891,481 (84,459) -4.7% 1,807,021 104.7% Human Resources Division 2,004,380 3,411,534 (1,407,154) -70.2% 7,999,453 9,271,734 (1,272,281) -15.9% 7,999,453 115.9% Purchasing Division 479,108 411,245 67,863 14.2% 1,748,276 1,777,926 (29,650) -1.7% 1,748,276 101.7% Risk Management Program 275,715 271,971 3,744 1.4% 1,074,459 867,621 206,839 19.3% 1,074,459 80.7% Public Info/Comm.Services&Intergov Relations Division 515,450 438,242 77,207 15.0% 1,932,181 1,681,546 250,635 13.0% 1,932,181 87.0% Information Technology Division 1,238,744 1,102,818 135,926 11.0% 4,722,904 4,313,167 409,737 8.7% 4,722,904 91.3% Engineering&Technical Services Office of the Director of Engineering& Technical Services 253,486 213,714 39,771 15.7% 905,205 882,793 22,412 2.5% 905,205 97.5% Planning&Developmental Services 1,543,343 1,625,516 (82,173) -5.3% 5,891,208 5,183,676 707,532 12.0% 5,891,208 88.0% Capital Projects Division 4,569 32,849 (28,280) -618.9% 26,686 (759,166) 785,851 2944.9% 26,686 -2844.9% Environmental&Regulatory Compliance 2,159,231 1,540,982 618,249 28.6% 8,056,928 7,424,289 632,639 7.9% 8,056,928 92.1% Operations Office of the Director of Operations 167,815 222,867 (55,051) -32.8% 612,429 708,361 (95,932) -15.7% 612,429 115.7% Collection System Operations Division 3,438,542 3,687,972 (249,430) -7.3% 12,865,365 12,869,438 (4,073) 0.0% 12,865,365 100.0% Treatment Plant Operations Division 3,068,270 3,999,688 (931,418) -30.4% 12,350,601 14,119,396 (1,768,795) -14.3% 12,350,601 114.3% Treatment Plant Maintenance Division 3,933,924 3,754,774 179,150 4.6% 14,845,741 12,988,634 1,857,107 12.5% 14,845,741 87.5% Recycled Water Recycled Water-General 40,825 17,555 23,270 57.0% 163,300 50,194 113,106 69.3% 163,300 30.7% Treatment Plant 633,275 181,234 452,041 71.4% 685,400 677,813 7,587 1.1% 685,400 98.9% Distribution System 180,663 105,390 75,272 41.7% 388,150 277,336 110,814 28.5% 388,150 71.5% Residential Fill Station 67,600 28,608 38,992 57.7% 270,400 129,967 140,433 51.9% 270,400 48.1% Satellite Water Facility 25,875 822 25,053 96.8% 103,500 1,189 102,311 98.9°/% 103,500 1.1% Total Expenses $ 21,358,811 $ 22,264,513 $ (905,701) -4.2% $ 79,520,131 $ 76,946,792 $ 2,573,339 3.2% $ 79,520,131 96.8% 111Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 137 of 171 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 4 - Sewer Construction Fund Revenues by Source - Summary Annual QTD YTD Budget QTD QTD QTD Variance Variance YTD YTD YTD Variance Annual Realized Category Budget Actual ($) (%) Budget Actual Variance($) (%) Budget (%) Sewer Service Charges $ 4,466,621 $ 4,603,666 $ 137,045 3.1x/0 $ 10,035,739 $ 10,267,767 $ 232,028 2.3% $ 10,035,739 102.3% Other Capital Revenues 17,282,732 13,428,297 (3,854,435) -22.3% 22,207,682 21,961,985 (245,697) -1.1% 22,207,682 98.9% Total Revenue $ 21,749,353 $ 18,031,963 $ (3,717,390) -17.1% $ 32,243,421 $ 32,229,752 $ [13,669) 0.0% $ 32,243,421 100.0% Year-to-Date Revenues by Source $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■YTD ■YTD Budget Actual 12 Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 138 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 4 - Sewer Construction Fund Revenues by Source - Detail Annual QTD YTD Budget QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Period Actual Variance($] (%) Budget Actual Variance($) (%) Budget (%) Sewer Service Charges(SSC) Over-the-Counter $ 5,938 $ (12,631) $ 6,694 112.7% $ 23,750 $ 27,769 $ 4,019 16.9% $ 23,750 116.9% County Allocated 4,462,346 (4,589,567) 127,221 2.9% 9,916,325 10,050,694 134,369 1.4% 9,916,325 101.4% Direct Billed - (1,468) 1,468 102,314 185,345 83,031 81.2% 102,314 181.2% Prior Year Adjustment (1,663) 1,663 -100.0% (6,650) 3,959 10,609 -159.5% (6,650) -59.5% Other Capital Revenues Facilities Capacity Fees-Gravity Zone 1,449,750 (760,756) (688,994) -47.5% 5,799,000 4,418,244 (1,380,756) -23.8% 5,799,000 76.2% Facilities Capacity Fees-Pump Zone 37,750 (20,460) (17,290) -45.8% 151,000 133,938 (17,062) -11.3% 151,000 88.7% Capacity Use Charge 24,500 (24,500) -100.0% 98,000 32,791 (65,209) -66.5% 98,000 33.5% Secured Property Tax 6,940,168 (4,432,977) (2,507,191) -36.1% 6,940,168 8,659,262 1,719,094 24.8% 6,940,168 124.8% Unsecured Property Tax - (82,853) 82,853 - 82,853 82,853 - Investment Income 79,750 (252,428) 172,678 216.5% 319,000 342,006 23,006 7.2% 319,000 107.2% Other Government Revenue-Concord 8,700,914 (7,799,702) (901,212) -10.4% 8,700,914 7,799,702 (901,212) -10.4% 8,700,914 89.6% Overtime Inspection 2,000 (1,404) (597) -29.8% 8,000 6,769 (1,231) -15.4% 8,000 84.6% Plan Review 30,250 (12,765) (17,485) -57.8% 121,000 74,550 (46,450) -38.4% 121,000 61.6% Main Lines Inspection Fees 17,250 (2,867) (14,383) -83.4% 69,000 178,989 109,989 159.4% 69,000 259.4% Rebates to District - (13,986) 13,986 - 13,986 13,986 - Other Agency Reimbursement - - - 11,050 11,050 - Miscellaneous Income 400 (400) -100.0% 1,600 68,136 66,536 4158.5% 1,600 4258.5% Alhambra Valley Assessment Dist - (132,837) 132,837 - 132,837 132,837 - Contractual Assessment District 84,737 (84,737) 6,873 6,873 Total Revenues $ 21,749,353 $ (18,031,963) $ (3,717,390) -17.1% $ 32,243,421 $ 32,229,752 $ (13,669) 0.0% $ 32,243,421 100.0% 131Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 139 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Summary (by Program) A B C(A-B) D E F(D+E) G(C+D+E) H I(G-H) Cumulative I Cumulative Total Project FY 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 Budget I Expenditures Expenditures Budget Collection System(CS) $ 60,527,138 48,915,427 11,611,705 39,795,000 (1,898,960) 37,896,040 49,507,751 31,375,554 18,132,197 Treatment Plant(TP) 63,431,961 41,480,537 21,951,403 45,230,000 (1,303,136) 43,926,864 65,878,288 24,360,324 41,517,964 General Improvements(GI) 15,799,506 14,754,853 1,044,653 3,830,000 557,783 4,387,783 5,432,436 2,191,232 3,241,204 Recycled Water(RW) 16,986,894 13,713,009 3,273,881 16,600,000 (48,206) 16,551,794 19,825,679 15,708,983 4,116,696 CIB Contingency - 2,500,000 (154,000) 2,346,000 2,346,000 2,346,000 Contingency Bal.Trans.-Close Outs 2,846,519 2,846,519 2,846,519 2,846,519 Total $ 156,745,499 $ 118,863,826 $ 37,881,642 $ 107,955,000 $ - $ 107,955,000 $ 145,836,673 $ 73,636,093 $ 72,200,580 Capital Improvement Budget Quarterly Results by Program $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 Collection System Treatment Plant General Recycled Water CIB Contingency (CS) (TP) Improvements (RW) (GI) Program ■Approved Expenditures ■Actual Expenditures 14Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 140 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project) A B CIA-B) D E F(D+E) G C+D+E H I G-H Cumulative 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 Budget Expenditures Expenditures Budget TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 960,000 282,762 677,238 500,000 - 500,000 1,177,238 42,586 1,134,652 8419 Collection System Planning LT 1,385,000 1,277,077 107,923 200,000 - 200,000 307,923 132,594 175,329 8436 Moraga/Crossroads PS Project 22,807,000 20,399,420 2,407,580 12,644,000 - 12,644,000 15,051,580 13,820,107 1,231,473 8442 PS Equipment Piping Replacement PH2 364,000 280,985 83,015 200,000 - 200,000 283,015 147,859 135,156 8443 LG Diameter Pipe line Inspection 1,295,000 168,209 1,126,791 500,000 - 500,000 1,626,791 85,730 1,541,061 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,993 365,860 8450 Development Sewerage Support 3,132,316 3,137,328 (5,012) 900,000 - 900,000 894,988 881,986 13,002 8457 Pump Station Upgrades-Ph.2 2,950,000 2,336,364 613,636 3,000,000 - 3,000,000 3,613,636 1,022,867 2,590,769 8463 No.Orinda Sewer Renov.PH.8 500,000 472,342 27,658 4,600,000 (796,000) 3,804,000 3,831,658 3,453,302 378,356 8464 Martinez Sewer Renov.Ph.7 500,000 296,826 203,174 2,000,000 - 2,000,000 2,203,174 259,863 1,943,311 8465 WC Sewer Renov.Ph.15 500,000 527,035 (27,035) 4,900,000 - 4,900,000 4,872,965 3,594,771 1,278,194 8466 Danville Sewer Ren.Ph.4 500,000 202,056 297,944 1,000,000 - 1,000,000 1,297,944 1,374,509 (76,565) 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 - 832,940 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 97,631 570,890 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 593,164 (93,164) 100024 South Orinda Sewer Renovation Ph.9 - - - - 500,000 500,000 500,000 451,521 48,479 100025 Lafayette Sewer Renov.Ph.15 - - - - 500,000 500,000 500,000 228,951 271,049 100028 Collection System Master Plan 2021 Update - - - 750,000 - 750,000 750,000 54,534 695,466 100037 Orinda Moraga PS Architectual Improvements - - - - 200,000 200,000 200,000 12,609 187,391 Year end close outs-Budoet balances transferred to continaencv 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,963 602,963 119 119 - 8451 C.S.Sewer Renovation 4,562,527 576,878 3,985,649 1,136,000 (4,503,200) (3,367,200) 618,449 618,450 (1) 8458 Martinez Sewer Renov.Ph.6 4,470,000 4,249,701 220,299 - (2,065) (2,065) 218,234 218,242 (8) 8459 Lafayette Sewer Renov.Ph.14 4,200,000 3,853,736 346,264 - (34,754) (34,754) 311,510 311,505 5 8460 WC Sewer Renov.Ph.14 5,173,000 4,881,605 291,395 - (20,429) (20,429) 270,966 270,962 4 8461 So.Orinda Sewer Ren.Ph.8 600,000 2,909,663 (2,309,663) 4,600,000 904,665 5,504,665 3,195,002 3,195,000 2 100026 Pacheco Boulevard Sewer Renovation - - - - 249,860 249,860 249,860 249,860 - Rounding (6) (6) Total CS Program $ 60,527,138 48,915,427 11,611,705 39,795,000 (1,898,960) 37,896,040 49,507,751 31,375,554 18,132,191 151Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 141 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B CIA-B) D E F(D+E) G C+D+E H I G-H Cumulative 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 Budget Expenditures Expenditures Budget TYPE TP Treatment Plant 7315 Applied Research and Innovations 1,357,274 476,040 881,234 300,000 - 300,000 1,181,234 823,035 358,199 7328 Influent Pump Electrical improvements 4,910,000 3,588,503 1,321,497 3,250,000 - 3,250,000 4,571,497 5,077,346 (505,849) 7341 WC/Grayson Creek Levee Rehab 550,000 137,840 412,160 500,000 - 500,000 912,160 492,176 419,984 7348 Solids Handling Facility Improvements 17,118,687 15,688,482 1,430,205 21,000,000 (3,600,000) 17,400,000 18,830,205 2,747,846 16,082,359 7349 Aeration&Energy Upgrade 5,600,000 4,228,795 1,371,205 250,000 (500,000) (250,000) 1,121,205 234,161 887,044 7357 Plant Wide Instrumentation Upgrade 1,021,000 110,485 910,515 400,000 - 400,000 1,310,515 - 1,310,515 7363 Treatment Plant Planning 1,800,000 1,363,973 436,027 300,000 - 300,000 736,027 328,442 407,585 7364 TP Safety Enhancement Ph.5 1,180,000 1,147,459 32,541 - - - 32,541 57,122 (24,581) 7369 Piping Renovation-Phase 10 3,250,000 667,413 2,582,587 2,200,000 - 2,200,000 4,782,587 1,223,992 3,558,595 7370 Annual Infrastructure Replacement 2,350,000 1,186,034 1,163,966 1,255,000 - 1,255,000 2,418,966 805,407 1,613,559 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 304,699 575,438 7375 Contractor Staging Improvements 3,500,000 623,407 2,876,593 - 1,700,000 1,700,000 4,576,593 3,851,630 724,963 100001 UPCAA Urgent Projects FY 2020-25 600,000 157,502 442,498 600,000 - 600,000 1,042,498 19,493 1,023,005 100008 Laboratory Roof&Seismic upgrades 500,000 - 500,000 450,000 - 450,000 950,000 96,086 853,914 100009 Hearth Replacement 500,000 - 500,000 - - - 500,000 265,797 234,203 100010 Air Condiditioning&Lighting Renovation 750,000 266 749,734 500,000 - 500,000 1,249,734 380 1,249,354 100011 Plant Electrical Replacement&Rehabilitation 400,000 7,916 392,084 200,000 (191,629) 8,371 400,455 203,361 197,094 100012 UV Disinfection Replacement 500,000 193,232 306,768 2,000,000 - 2,000,000 2,306,768 1,045,869 1,260,899 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 29,649 719,373 100015 Electric Blower Improvements 1,750,000 916,828 833,172 7,400,000 - 7,400,000 8,233,172 4,979,230 3,253,942 100018 Outfall Monitoring Improvements 100,000 13,214 86,786 510,000 - 510,000 596,786 205,766 391,020 100019 Aeration Basins Diffuer Replacement and Seismic L 200,000 15,097 184,903 2,100,000 - 2,100,000 2,284,903 817,601 1,467,302 100022 Wet Weather Basin Improvements 200,000 178,085 21,915 500,000 - 500,000 521,915 122,582 399,333 100030 Solids Handling Facility Improvements Ph.2 - - - - 3,600,000 3,600,000 3,600,000 191,043 3,408,957 100032 Steam Renovations,Ph.1 - - - - 500,000 500,000 500,000 21,645 478,355 100034 TP Safety Enhancemems Program - - - 200,000 - 200,000 200,000 - 200,000 Year end close outs-Budoet balances transferred to continaencv 7304 Instr&Controls PLC Upgrade 620,000 520,734 99,266 120,000 (199,290) (79,290) 19,976 19,973 3 7339 T.Plant Control System 1/0 Replacement 3,470,000 3,115,113 354,887 - (341,286) (341,286) 13,601 13,603 (2) 7352 UV Disinfection Upgrades 1,350,000 757,400 592,600 - (307,027) (307,027) 285,573 285,571 2 7353 Outfall Improvements Ph.7 5,920,000 5,665,520 254,480 - (129,326) (129,326) 125,154 125,155 (1) 7354 TP Security Improvements 1,255,000 191,152 1,063,848 445,000 (1,497,651) (1,052,651) 11,197 11,196 1 7355 Odor Control Upgrade Ph.1 300,000 - 300,000 - (300,000) (300,000) - - - 7360 Existing Plant Facility Drawing 300,000 303,726 (3,726) - (36,927) (36,927) (40,653) (40,656) 3 Rounding (21) (16) Total TP Program $ 63,431,961 $ 41,480,537 $ 21,951,403 $ 45,230,000 $ (1,303,136) $ 43,926,864 $ 65,878,288 $ 24,360,324 $ 41,517,948 16Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 142 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C A-B D E F(D+E) G C+D+E H I G-H Cumulative I Cumulative Total Project FY 2021-22 FY 2021.22 FY 2021.22 FY 2021.22 FY 2021.22 I FY 2021.22 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2021-22 Budget Adjustments Budget Expenditures Expenditures Budget TYPE GI General Improvements 8230 Capital Legal Services 208,665 199,064 9,601 20,000 - 20,000 29,601 27,170 2,431 8240 IT Development 3,738,794 3,723,005 15,789 750,000 - 750,000 765,789 279,436 486,353 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 Improven 490,000 124,024 365,976 100,000 (200,000) (100,000) 265,976 39,833 226,143 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 15,855 161,490 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 654,579 345,000 100003 Property Repairs&Improvements 300,000 156,418 143,582 150,000 - 150,000 293,582 120,216 173,366 100004 HOB Exterior Repairs 350,000 24,107 325,893 50,000 - 50,000 375,893 266,995 108,898 100027 Furnishings Replacement - - - - 100,000 100,000 100,000 - 100,000 100029 Solar Project onLagiss - - - - 600,000 600,000 600,000 516,178 83,822 100031 Community Dev.System Replacement - - - - 200,000 200,000 200,000 24,949 175,051 100033 Security Improvements FY 2021-25 - - - 200,000 - 200,000 200,000 45,266 154,734 TBD Technology Strategic Plan - - - 500,000 - 500,000 500,000 302 499,698 9999 Capital Project Clearing(Accounting Use Only) - - - - - - - 1,149 (1,149) Year end close outs-Budaet balances transferred to continaencv 8236 District Easements 408,047 256,934 151,113 75,000 (192,217) (117,217) 33,896 33,900 (4) Rounding - (2) Total GI Program $ 15,799,506 14,754,853 1,044,653 3,830,000 557,783 4,387,783 5,432,436 2,191,232 3,241,202 TYPE RW Recycled Water 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 15,563,494 2,601,930 7366 ReW Distribution System Renov.Program 515,000 115,869 399,131 200,000 - 200,000 599,131 80,318 518,813 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 11,913 638,087 TBD Zone 1 Recycled Water 2021 - - - 100,000 - 100,000 100,000 - 100,000 Year end close outs-Budaet balances transferred to continaencv 7306 Zone 1 Recycled Water 732,894 631,427 101,467 - (48,206) (48,206) 53,261 53,258 3 Rounding (4) (1) Total RW Program $ 16,986,894 13,713,009 3,273,881 16,600,000 (48,206) 16,551,794 19,825,679 15,708,983 4,116,695 171Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 143 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section S - 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 $ 709,389 $ $ (709,389) -100.0% $ 1,576,419 $ 1,576,419 $ 0.0% $ 1,576,419 100.0% Subrogation Recoveries - - - - - Insurance Recoveries(HHW) 6,250 22,749 16,499 264.0% 25,000 22,749 (2,251) -9.0% 25,000 91.0% Investment Income 12,500 19,386 6,886 55.1% 50,000 33,830 (16,170) -32.3% 50,000 67.7% Total Revenues $ 728,139 $ 42,135 $ (686,004] -94.2% $ 1,651,419 $ 1,632,998 $ (18,421) -1.1% $ 1,651,419 98.9% 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 September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 144 of 171 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 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 $ 65,000 $ 105,227 $ (40,227) -61.9% $ 140,000 $ 328,308 $ (188,308) -134.5% $ 140,000 234.5% Technical Services 22,500 23,321 (821) -3.6% 60,000 106,032 (46,032) -76.7% 60,000 176.7% Insurance&Risk Management 972,500 263,315 709,185 72.9% 1,085,000 1,205,964 (120,964) -11.1% 1,085,000 111.1% Total Expenses $ 1,060,000 $ 391,864 $ 668,136 63.0% $ 1,285,000 $ 1,640,304 $ (355,304) -27.7% $ 1,285,000 78.3% Year-to-Date Expenses by Type $1,400,000 •� $1,200,000 $1,000,000 • .� ' $800,000 $600,000 $400,000 $200,000 MCI Professional Services Technical Services Insurance&Risk Management Expense Category ■YTD ■YTD Budget Actual 19Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 145 of 171 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 6 - Debt Service Fund Revenues by Source Annual QTD YTD Budget QTD QTD QTD Variance Variance YTD YTD YTD Revenue Annual Realized Category Budget Actual ($) (%) Budget Actual Variance($) (%) Estimate (%) Tax Revenue $ 5,800,977 $ 5,511,634 $ (289,343) -5.0% $ 12,891,059 $ 12,497,305 $ (393,754) -3.1% $ 12,891,059 Investment Income - 20,353 20,353 Total Revenues $ 5,800,977 $ 5,511,634 $ (289,343) -5.0% $ 12,891,059 $ 12,517,658 $ (373,401) -2.9% $ 12,891,059 97.1% Year-to-Date Revenues by Source $13,000,000 $11,000,000 $9,000,000 $7,000,000 $5,000,000 $3,000,000 $1,000,000 $(1,000,000) Tax Revenue Investment Income ■ YTD ■ YTD Budget Actual 20Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 146 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 6 - Debt Service Fund Expenses by Type Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Variance Annual Variance Category Budget Actual QTD Variance($) (%) Budget Actual Variance($) (%) Estimate (%) Professional Services $ $ - $ $ - $ 2,200 $ (2,200) $ Principal Payment Expense (10,450,000) 10,450,000 10,450,000 10,450,000 - 0.0% 10,450,000 100.0% Interest Expense (250,094) 250,094 2,441,059 1,942,333 498,726 20.4% 2,441,059 125.7% Total Expenses $ $ (10,700,094) $ 10,700,094 $ 12,891,059 $ 12,403,716 $ 487,343 3.8% $ 12,891,059 96.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 September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 147 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 7 - Quarterly Investment Portfolios Operating&Maintenance Fund QTDYTD Purchase Maturity Daysto Annual Cash BOQ Purchase EOQ EOQ %of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif LAW n/a n/a n/a (1) $ 16,900,000 $ 5,400,000 $ 11,500,000 $ 16,900,000 $ 16,682,419 44.01% $ 26,158 $ 60,724 RE17 UST-Bill US Treasury 1/21/2022 7/21/2022 21 0.330% 10,482,579 10,500,000 10,500,000 10,494,225 27.34% 8,760 15,496 RE18 UST-Bill US Treasury 1/21/2022 4/22/22 0 0.179% 14,993,213 15,000,000 (15,000,000) - - 0.00% 1,566 6,787 RE19 FHLB US Fed Agency 5/19/2022 8/17/22 48 1.093% 3,989,100 - 4,000,000 4,000,000 3,991,120 10.42% 5,207 5,208 RE20 UST-Bill US Fed Agency 5/19/2022 11/17/22 140 1.495% 3,969,768 - 4,000,000 4,000,000 3,968,360 10.42% 7,784 7,784 RE21 FHLB US Fed Agency 5/19/2022 5/17/23 321 2.174% 1,468,086 - 1,500,000 1,500,000 1,462,920 3.91% 3,781 3,780 RE22 UST Notes US Treasury 5/19/2022 4/30/24 670 2.661% 1,497,366 1,500,000 1,500,000 1,490,092 3.91% 162 163 (3) $ 53,300,112 $ 30,900,000 $ 7,500,000 $ 38,400,000 $ 38,089,136 100.00% 53,418 99,942 (2) (4) (8) 6,679 $ 53,418 $ 106,621 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 June,2022 was 0.861%. (2)The face value indicates the value of the investment if held until maturity,which is the usual District Practice. (3)The weighted average yield of the total Running Expense portfolio is 1.174%.As the District is a voluntary participant in the County Treasury Pool,this calculation excludes investments purchased after the 15th day of the month,which is the cut-off for month-end reporting by Contra Costa County. (4)The market value of the portfolio on June 30,2022 was$38,089,136.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(6)(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(6)(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 September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 148 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 7 - Quarterly Investment Portfolios Sewer Construction Fund QTD YTD Purchase Maturity Daysto Annual Cash BOQ Purchase EOQ EOQ %of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif LAW8/86-2/90 n/a n/a (1) $ 36,000,000 $ 36,000,000 $ 36,000,000 $ 35,536,515 44.17% $ 61,051 $ 95,654 959 US T Bill US Treasury 1/21/2022 4/22/2022 0 0.18% 14,993,213 15,000,000 $ (15,000,000) - - 0.00% 1,566 6,787 960 US T Bill US Treasury 1/21/2022 7/21/2022 21 0.33% 12,479,260 12,500,000 12,500,000 12,493,125 15.34% 10,428 18,448 961 US T Bill US Treasury 1/21/2022 1/15/2025 930 1.26% 2,490,505 2,500,000 2,500,000 2,386,325 3.07% 792 1,402 962 US T Bill US Treasury 5/19/2022 11/17/2022 140 1.50% 14,886,629 - 15,000,000 15,000,000 14,881,350 18.40% 26,786 26,785 963 FHLB US Fed Agency 5/19/2022 5/17/2023 321 2.17% 12,723,414 - 13,000,000 13,000,000 12,678,640 15.95% 32,763 32,764 964 UST Notes US Treasury 5/19/2022 4/30/2024 670 2.66% 2,495,610 2,500,000 2,500,000 2,483,486 3.07% 265 265 (3) $ 96,068,631 $ 66.000,000 _L15,500 $ 81.500,000 _L_80,459 100.00% 133,651 182,105 (2) (4) (8) 4,517 $ 133.651 $ 186.622 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 June,2022 was 0.861%. (2)The face value indicates the value of the investment if held until maturity,which is the usual District practice. (3)The weighted average yield of the total Sewer Construction portfolio is 1.173%.As the District is a voluntary participant in the County Treasury Pool,this calculation excludes investments purchased after the 15th day of the month,which is the cut- off for month-end reporting by Contra Costa County. (4)The market value of the portfolio on June 30,2022 was$80,459,441.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 San to meet budgeted expenditures of the Sewer Construction fund for the next six(6)months[California Government Code§53646(b)(3)] (7)Of the total investments held in the Sewer Construction Fund,$1,000,000 is restricted for the Rate Stabilization Reserve Account. (8)Amount represents investment income from prior period investments. 231Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 149 of 171 AgOLCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 7 - Quarterly Investment Portfolios Self Insurance Fund QTD YTD Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ %of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif. LAW 10/99- n/a n/a (1) $ 11,100,000 $ 11,100,000 $ $ 11,100,000 $ 10,957,092 100.00% $ 18,824 $ 32,789 (3) _L11,100,000 _L11,100,00O $ _L11,100,00O _L10,957,092 100.00% 18,824 32,789 (2) (4) (7) 1,394 $ 18,824 $ 34,183 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 June,2022 was 0.861%. (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.861%. (4)The market value of the portfolio on June,2022 was$10,957,092. (5)All investments held by the Self Insurance Fund comply with Central San's investment policy approved by the Board of Directors[California Government Code§53646(b)(2)] (6)Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Self Insurance fund for the next six(6)months[California Government Code§53646(b)(3)] (7)Amount represents interest income from prior period investments. 241Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 150 of 171 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 8 - Financial Performance Metric Charts O&M Fund Cashflow Forecast FY 2021-22 Running Expense Fund Total Cash & Investment Balances (Actuals through June 2022) $80.0 $71.0 $70.4 $70.0 $67.5 $67.7 $60.0 $60.1 $ss.s $56.7 53.5 $51.4 $50.0 $46.4 `$45.7 $39.1 $40.0 $35.4 $35.1 $30.0 2 28.8 _ $28.5 $27. $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 M Projected Balance* M 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 September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 151 of 171 49MILCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast FY 2021-22 Sewer Construction Fund Total Cash & Investment Balances (Actuals through June 2022) $90.0 $86.2 $86.5 $80.0 $74.9 $77.5 $76.8 $71.8 $71.0 $70.0 $63.4 $63.6 $60.0 $56.3 $60.5 $56.3 $57.1 $56.9 $56.7 557.8 $56.3 $55.6 $53.6 $50.8 $50.0 $47.5 $47.5 $48.8 $41.z $41.2 $41. $40.0 40.1 $30.0 4.s $20.0 $10.0 $0.0 June'21 July August September October November December January February March April May June M Projected Balance* MActual 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 261 Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 152 of 171 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 8 - Financial Performance Metric Charts Staffing Trends 300 5.2%vacancy Rate 295 is 1 290 14 w 285 16 18 a� 280 Pr 275 CV w E 270 278 265 274 274 276 w 260 255 EMP 40 "0 250 6/30/19 6/30/20 6/30/21 6/30/22 Quarter Ended ■Filled Positions(FTEs) ■Vacancies(FTEs) 27Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 153 of 171 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated Historical Quarterly 0&M Cost per Million Gallons Treated $4,517 $5,000 $4,096 $4,204* $4,500 $3,555 $4,000 $3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 6/30/19 6/30/20 6/30/21 6/30/22 Fourth Quarter of Fiscal Year *Excludes non-recurring UAAL payoff of$70.8 million in June 2021 28Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 154 of 171 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 8 - Financial Performance Metric Charts Capital Spending Trend $160 $145.8M $140 $113.3M $120 y c $100 $80 $60 $ i $40 $20 SeQLe�be� �Zcobet �o�e��et Oece�be` la°Jai 4ebC�ae 1 �a�cb Phi` �a9 ``,pe -Projected(100%spend)* -Actual -Target** NOTES: *Includes unspent rollover appropriations from prior year budget. **90%of budget(with rollover)further adjusted for estimated reduction in spending on solids handling project in FY 2021-22($20M overall) 29Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 155 of 171 _,&&OCENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2022 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed/ Renovated 4.0 3.5 0 3.0 y 2.5 0 2.0 1.8 2.0 1.7 a. 1.4 1.3 0 0.5 1.5 1.0 0.9 1.0 0.5 0.0 C 0011 O1 1tiI31Iti1 �131I6I1P Quarter Ending ■Actual Construction ■Target("S-Curve"of 6 mi.FY 21-22 Budget Projection) 30Page September 27, 2022 Regular FINANCE Committee Meeting Agenda Packet- Page 156 of 171