Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
05.b. Receive Fiscal Year 2021-22 Quarterly Financial Review Report through the quarter ended September 30, 2021
Page 1 of 34 Item 5.b. F--1-448�411C-S0 November 22, 2021 TO: FINANCE COMMITTEE FROM: CHRISTOPHER THOMAS, ACCOUNTING SUPERVISOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIPLEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION ROGER S. BAILEY, GENERAL MANAGER SUBJECT: RECEIVE FISCAL YEAR (FY) 2021-22 QUARTERLY FINANCIAL REVIEW REPORT THROUGH THE QUARTER ENDED SEPTEMBER 30, 2021 Attached is the Quarterly Financial Review for the first quarter of FY 2021-22 ending September 30, 2021. The Executive Summary (Section 1) of the attached report includes an analysis of financial results and the investment portfolios for the quarter. Strategic Plan Tie -In GOAL THREE: Fiscal Responsibility Strategy 1— Maintain financial stability and sustainability, , Strategy 2 — Ensure integrity and transparency in financial management ATTACHMENTS: 1. Quarterly Financial Report - September 30, 2021 November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 102 of 167 Quarterly Financial Review CENTRAL SAN _ n - ArJ - _ i zi I r Ended September 30, 2021 910ENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Table of Contents Section1- Executive Summary................................................................................................................................................................................................1 Section 2 - Financial Results Summary by Fund................................................................................................................................................................4 Section 3 - Operations & Maintenance Fund Revenues RevenuesSource - Summary..............................................................................................................................................................................................................5 RevenuesSource - 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 November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 104 of 167 g`10ENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 105 of 167 g`10ENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 1 -Executive Summary Quarterly Financial Highlights Included in this consolidated report are quarterly budget -to -actual financial results as well as the investment portfolio reports for the first quarter of FY 2021-22 ended September 30, 2021. The underlying reports present unaudited quarterly results for the Running Expense (0&M), Sewer Construction, Self -Insurance, and Debt Service funds. Operating & Maintenance Fund 0&M Fund results for the first quarter show total expenditures are $16.6 million, which is approximately $1.9 million (10.4%) under the projected year-to-date budget. This favorable expense variance is smaller than the favorable year-to-date budget variance reported in the first quarter of the prior year of 18.9% and is largely attributable to lower than projected year-to-date spending in the purchased property services, other purchased services, and salaries & wages expense categories. Savings realized in the salaries & wages category is largely the result of the full-time employee vacancy rate being higher than normal through the first quarter at approximately 5.9%, with the budget assuming 3.0%. The largest individual expense category budgetary variance is in other purchased services, which is reporting a favorable variance of approximately $0.9 million. In the aggregate, the 0&M Fund is reporting a modest favorable revenue variance of less than $0.1 million, which is approximately 1.3% above total estimated year-to-date revenues. The primary driver for this overall revenue variance is sewer service charges received from the front counter being higher than anticipated through the first quarter. Non -operating revenues are also in line with the budget showing a negative year-to-date estimated budget variance of under $0.1 million mostly due to permit and inspection fees, which tend to accelerate later in the fiscal year. Sewer Construction Fund Sewer Construction Fund results for the first quarter show total capital project expenditures of $12.6 million, or 46.2% of the total estimated year-to-date budget of $23.5 million developed using historical spending trends over the past three years. This results in a year-to-date capital spending rate of 53.8%. While the Sewer Construction fund's FY 2021-22 adopted budget was 11Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 106 of 167 g`10ENTRAL 5AN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 1 -Executive Summary $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.9 million. The adopted budget amount assumed the Solids Handling Project was proceeding; as a new direction will be taken on that, spending for the overall capital improvement budget will be less in FY 2021-22. The bulk of the FY 2021-22 year-to-date capital spending budget variance is in the Collection System program (57.5%) followed by the Treatment Plant program (28.3%), attributable to various project as shown in pages 15 through 18 of this report. On the revenue side, the Sewer Construction Fund is currently reporting revenues of $1.4 million, reflecting an unfavorable year-to-date variance of $0.2 million (14.2%). This minimal unfavorable revenue variance is mostly attributable to facilities capacity fees which are estimated on a straight-line basis across the fiscal year due to their interim receipt timing being difficult to predict. It is projected that the facilities capacity fees negative variance will largely contract by the close of the fiscal year. Investment Portfolio Highlights In accordance with Section 53646 of the California Government Code as well as Central San's Investment Policy, the Finance Division is required to submit an investment report to the General Manager and Board of Directors at least quarterly. The investments held by Central San for the quarter ended September 30, 2021 are presented in separate Investment Portfolio Reports for each fund on pages 22-24 of this consolidated report. Pursuant to the Investment Policy and state law, the Investment Portfolio Report presents the following information: type of investment, issuer, date of maturity, par (or face) and dollar amount invested on all securities, as well as the current market value as of the date of the report. Through the first quarter of FY 2021-22, the 0&M Fund has generated Investment Income of $10,075 which is below the year- to-date revenue estimate of $16,500 by 38.9%. The Sewer Construction Fund is reporting Investment Income of $255 (includes CAD/AVAD interest), coming in well below the year-to-date revenue estimate of $79,750 by 99.7%. This variance is directly related to the Sewer Construction Fund's reserves being used in June 2021 to assist with the prepayment of the UAAL payoff to CCCERA through a short-term interfund borrowing (to the 0&M fund). The proceeds from the issuance of the June 2021 Certificates of Participation of $58.0 million will also be reimbursed from the debt service fund to the sewer construction fund as eligible capital expenditures are incurred during FY 2021-22. As of September 30, 2021, Central San continues to hold 2 1 P a g e November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 107 of 167 g`10ENTRAL SAN 5019 IMHOFF PLACE, MAUINEL. CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 1 -Executive Summary the bulk of its investment portfolio, or $19.7 million, in Local Agency Investment Fund (LAIF) state investment pool, well below the maximum amount permitted to be held in the pool of $75 million. The remaining investments were held in short- term United States Treasury Bills yielding far less than LAIF given the current market environment for short-term fixed income instruments permissible for investment by Central San's investment policy and state law. Central San's investment portfolio is in compliance with the Board's adopted policy regarding investments as of the quarter ended September 30, 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 November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 108 of 167 10ENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 2 -Financial Results Summary by Fund YTD Category Budget Fund Revenues YTD Actual Annual YTD Budget YTD Variance Annual Realized Variance ($) (%) Budget (%) 0&M $ 957,508 $ 969,632 12,123 1.3% $ 116,681,763 0.8% Sewer Construction 1,645,925 1,412,883 (233,042) -14.2% 32,243,421 4.4% Self Insurance 18,750 4,063 (14,687) -78.3% 1,651,419 0.2% Debt Service - - 12,891,059 0.0% Total $ 2,622,183 $ 2,386,577 $ (235,606) $ 163,467,662 Fund Expenses 0&M $ 18,564,777 $ 16,637,943 1,926,834 10.4% $ 79,520,131 20.9% Sewer Construction 23,510,563 12,639,108 10,871,455 46.2% 145,896,673 8.7% Self Insurance 75,000 213,941 (138,941) -185.3% 1,285,000 16.6% Debt Service 2,177,948 126,516 2,051,432 94.2% 12,891,059 1.0% Total $ 44,328,288 $ 29,617,508 $ 14,710,780 $ 239,592,863 YTD Budget -to -Actual Revenues by Fund Sz,aoo,0o0 ' $L750,000 woopoo •' $L250,000 $L0001000 " $7H,000 r ssao,000 $2 ,000 it s oam sew.�consRuttm� seumn�a�ce oectse.nce Fund •Y D •Y D Budget Acwal 4 1 P a g e YTD Budget -to -Actual Expenses by Fund $25,000,000 $20,000,000 $010oo00 sio,000,000 Ss,Ooo,000 g- oear sewe�consm�mo� seumn�aMe Debt se.nce Fund •YTD •YTD Budg. 1-1 November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 109 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 $ 195,439 $ 155,281 386.7% $ 40,158 $ 195,439 $ 155,281 386.7% $ 96,331,829 0.2% Sewage Treatment Cost Sharing - (47,960) (47,960) - (47,960) (47,960) 15,445,534 -0.3% Miscellaneous Service Charge 239,250 209,241 (30,009) -12.5% 239,250 209,241 (30,009) -12.5% 2,078,000 10.1% Non -Operating Revenues: Permit and Inspection Fees 473,600 402,158 (71,442) -15.1% 473,600 402,158 (71,442) -15.1% 1,894,400 21.2% Other Non Operating Income 188,000 200,678 12,678 6.7% 188,000 200,678 12,678 6.7% 752,000 26.7% Investment Income 16,500 10,075 (6,425) -38.9% 16,500 10,075 (6,425) -38.9% 180,000 5.6% Total Revenue $ 957,508 $ 969,632 $ 12,123 1.3% $ 957,508 $ 969,632 $ 12,123 1.3% $ 116,681,763 0.8% Year -to -Date Revenues by Source $500,000 _ $400,000 $300,000 $200,000 $100,000 MM $_ Sewer Service Charge Revenue Sewage Treatment Cost Miscellaneous Service Charge Permit and Inspection Fees Other Non Operating Income Investment Income Sharing $(100,000) Revenue Source Category ■YTD ■ YTD Budget Actual 5 1 P a g e November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 110 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Revenues by Source - Detail Level Category QTD Budget Sewer Service Charge Revenue Sewer Service Charge Counter $ 55,776 $ Sewer Service Charge County - Sewer Service Charge Direct Sewer Service Charge Prior (15,618) Sewage Treatment Cost Sharing - Miscellaneous Service Charges Septic Tank Dumping 9,500 Sales 250 Other Service Charges - Recycled Water 108,000 Satellite Water Recycling - Stormwater Program 97,500 Household Hazardous Waste 24,000 Permit & Inspection Fees Permit/Application Fees 135,000 Overtime Inspection 3,600 Side Sewer Inspection 292,500 Industrial Permit Fees 26,250 New Industry Permit Fees 3,750 Annexation Charges 12,500 Other Non -Operating Income Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 3 - Operations & Maintenance Fund Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Variance Annual Realized Actual Variance ($) (%) Budget Actual Variance ($) % Budget 157,286 $ 101,510 182.0% $ 55,776 $ 157,286 $ 101,510 182.0% $ 223,105 70.5% - - - - - 95,210,064 0.0% - - - - 961,131 0.0% 38,153 53,771 -344.3% (15,618) 38,153 53,771 -344.3% (62,471) -61.1% (47,960) (47,960) - (47,960) (47,960) 15,445,534 -0.3% 13,032 3,532 37.2% 9,500 13,032 3,532 37.2% 38,000 34.3% - (250) -100.0% 250 - (250) -100.0% 1,000 0.0% - - - - - 240,000 0.0% 184,429 76,429 70.8% 108,000 184,429 76,429 70.8% 432,000 42.7% - (97,500) -100.0% 97,500 - (97,500) -100.0% 390,000 0.0% 11,780 (12,220) -50.9% 24,000 11,780 (12,220) -50.9% 977,000 1.2% 116,658 (18,342) -13.6% 135,000 116,658 (18,342) -13.6% 540,000 21.6% 1,066 (2,534) -70.4% 3,600 1,066 (2,534) -70.4% 14,400 7.4% 282,658 (9,842) -3.4% 292,500 282,658 (9,842) -3.4% 1,170,000 24.2% - (26,250) -100.0% 26,250 - (26,250) -100.0% 105,000 0.0% 1,776 (1,974) -52.6% 3,750 1,776 (1,974) -52.6% 15,000 11.8% - (12,500) -100.0% 12,500 - (12,500) -100.0% 50,000 0.0% MVSD P2 Program 6,250 (6,250) -100.0% 6,250 (6,250) -100.0% 25,000 0.0% Pretreatment Program Fine 500 (500) -100.0% 500 (500) -100.0% 2,000 0.0% Rebates to District - - - - - - - Lease Rental Income 178,750 180,956 2,206 1.2% 178,750 180,956 2,206 1.2% 715,000 25.3% Miscellaneous Income 2,500 15,931 13,431 537.2% 2,500 15,931 13,431 537.2% 10,000 159.3% Right of Way Fees - 3,792 3,792 - 3,792 3,792 - Contractual Assessment Dist - - - - - - - Investment Income 16,500 10,075 (6,425) -38.9% 16,500 10,075 (6,425) -38.9% 180,000 5.6% Total Revenues $ 957,508 $ 969,632 $ 12,123 1.3% $ 957,508 $ 969,632 $ 12,123 1.3% $ 116,681,763 0.80/0 6 1 P a g e November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 111 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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,147,233 $ 8,523,911 $ 623,322 6.8% $ 9,147,233 $ 8,523,911 $ 623,322 6.8% $ 39,711,391 21.5% Employee Benefits 2,980,994 2,970,154 10,840 0.4% 2,980,994 2,970,154 10,840 0.4% 12,688,724 23.4% Unfunded Liability Costs 640,478 374,163 266,315 41.6% 640,478 374,163 266,315 41.6% 2,566,845 14.6% Purchased Property Services 1,480,960 1,052,037 428,923 29.0% 1,480,960 1,052,037 428,923 29.0% 5,926,840 17.8% Other Purchased Services 1,501,040 606,859 894,181 59.6% 1,501,040 606,859 894,181 59.6% 6,934,841 8.8% Supplies & Materials 2,539,508 2,652,523 (113,014) -4.5% 2,539,508 2,652,523 (113,014) -4.5% 10,512,734 25.2% Other Expenses 274,564 458,297 (183,733) -66.9% 274,564 458,297 (183,733) -66.9% 1,178,756 38.9% Total Expenses $ 18,564,777 $ 16,637,943 $ 1,926,834 10.4% $ 18,564,777 $ 16,637,943 $ 1,926,834 10.4% $ 79,520,131 20.9% Year -to -Date Expenses by Type $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 7 1 P a g e November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 112 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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,319,554 $ 8,069,517 $ 250,037 3.0% $ 8,319,554 $ 8,069,517 $ 250,037 3.0% $ 36,384,957 22.2% Temporary Pay 362,112 - 362,112 100.0% 362,112 - 362,112 100.0% 1,345,210 0.0% Premium Pay 777,004 442,177 334,828 43.1% 777,004 442,177 334,828 43.1% 3,174,574 13.9% Board Fees 13,663 12,210 1,453 10.6% 13,663 12,210 1,453 10.6% 54,650 22.3% Other (325,100) 7 (325,107) 100.0% (325,100) 7 (325,107) 100.0% (1,248,000) 0.0% Total Salaries & Wages 9,147,233 8,523,911 623,322 6.8% 9,147,233 8,523,911 623,322 6.8% 39,711,391 21.5% Employee Benefits Insurance Premiums 1,830,206 1,778,194 52,012 2.8% 1,830,206 1,778,194 52,012 2.8% 7,825,569 22.7% Employer Taxes 136,460 142,227 (5,768) -4.2% 136,460 142,227 (5,768) -4.2% 589,461 24.1% Employer Retirement Contributions 1,709,904 1,699,294 10,609 0.6% 1,709,904 1,699,294 10,609 0.6% 7,449,694 22.8% OPEB Contributions 515,000 557,111 (42,111) -8.2% 515,000 557,111 (42,111) -8.2% 2,060,000 27.0% Benefit Adjustments (1,210,574) (1,206,673) (3,902) 0.3% (1,210,574) (1,206,673) (3,902) 0.3% (5,236,000) 23.0% Total Employee Benefits 2,980,994 2,970,154 10,840 0.4% 2,980,994 2,970,154 10,840 0.4% 12,688,724 23.4% Unfunded Liability Costs Pension 325,478 59,163 266,315 81.8% 325,478 59,163 266,315 81.8% 1,306,845 4.5% OPEB 315,000 315,000 0.0% 315,000 315,000 0.0% 1,260,000 25.0% Total Unfunded Liability Costs 640,478 374,163 266,315 41.6% 640,478 374,163 266,315 41.6% 2,566,845 14.6% Purchased Property Services Repairs & Maintenance 927,070 735,612 191,458 20.7% 927,070 735,612 191,458 20.7% 3,711,280 19.8% Hauling & Disposal 264,250 87,201 177,049 67.0% 264,250 87,201 177,049 67.0% 1,057,000 8.2% Security 115,375 93,073 22,302 19.3% 115,375 93,073 22,302 19.3% 461,500 20.2% Rentals 61,962 48,399 13,564 21.9% 61,962 48,399 13,564 21.9% 247,850 19.5% Cleaning 110,802 87,752 23,051 20.8% 110,802 87,752 23,051 20.8% 443,210 19.8% Construction 1,500 1,500 100.0% 1,500 1,500 100.0% 6,000 0.0% Total Purchased Property Services 1,480,960 1,052,037 428,923 29.0% 1,480,960 1,052,037 428,923 29.0% 5,926,840 17.8% (Continued on page 9) 8 1 P a g e November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet -Page 113 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Expenses by Type - Detail (Continued) QTD QTD Category Budget Actual Purchased Professional, Technical & Other Services Professional Services Technical Services Other Purchased Services Total Purchased Professional, Technical & Other Services Supplies & Materials Utilities & Fuel Chemicals General Supplies Total Supplies & Materials Other Expenses Insurance & Risk Management Memberships Training & Meetings Miscellaneous Other Total Other Expenses Total Expenses 9 1 P a g e Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 3 - Operations & Maintenance Fund QTD QTD Variance YTD YTD YTD YTD Annual Variance ($) (%) Budget Actual Variance ($) Variance (%) Budget % Used 136,391 131,991 4,400 3.2% 136,391 131,991 4,400 3.2% 925,180 14.3% 902,544 244,555 657,989 72.9% 902,544 244,555 657,989 72.9% 3,722,176 6.6% 462,105 230,313 231,792 50.2% 462,105 230,313 231,792 50.2% 2,287,485 10.10/0 1,501,040 606,859 894,181 59.6% 1,501,040 606,859 894,181 59.6% 6,934,841 8.8% 1,203,337 1,374,641 (171,303) -14.2% 1,203,337 1,374,641 (171,303) -14.2% 4,988,350 27.6% 381,500 479,480 (97,980) -25.7% 381,500 479,480 (97,980) -25.7% 1,682,000 28.5% 954,671 798,402 156,269 16.4% 954,671 798,402 156,269 16.4% 3,842,384 20.8% 2,S39,S08 2,652,523 (113,014) -4.5% 2,539,508 2,652,523 (113,014) -4.5% 10,512,734 25.2% - - - 0.0% - - - 0.0% - 0.0% 129,475 385,027 (255,552) -197.4% 129,475 385,027 (255,552) -197.4% 583,251 66.0% 129,894 47,196 82,698 63.7% 129,894 47,196 82,698 63.7% 540,225 8.7% 15,195 26,073 (10,878) -71.6% 15,195 26,073 (10,878) -71.6% 55,280 47.2% 274,564 458,297 (183,733) -66.9% 274,564 458,297 (183,733) -66.9% 1,178,756 38.9% $ 18,564,777 $ 16,637,943 $ 1,926,834 10.4% $ 18,564,777 $ 16,637,943 $ 1,926,834 10.4% $ 79,520,131 20.9% November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 114 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 $ 533,934 $ 485,460 $ 48,474 9.1% $ 533,934 $ 485,460 $ 48,474 9.1% $ 2,454,169 19.8% Administration 4,703,276 4,025,518 677,758 14.4% 4,703,276 4,025,518 677,758 14.4% 19,901,049 20.2% Engineering and Technical Services 3,518,557 2,494,980 1,023,577 29.1% 3,518,557 2,494,980 1,023,577 29.1% 14,880,026 16.8% Operations 9,588,173 8,962,056 626,117 6.5% 9,588,173 8,962,056 626,117 6.5% 40,674,136 22.0% Recycled Water Program 220,838 669,929 (449,091) -203.4% 220,838 669,929 (449,091) -203.4% 1,610,750 41.6% Total Expenses $ 18,564,777 $ 16,637,943 $ 1,926,834 10.4% $ 18,564,777 $ 16,637,943 $ 1,926,834 10.4% $ 79,520,131 20.9% Year -to -Date Expenses by Department $10,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services ■ YTD ■ YTD Budget Actual 101Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet -Page 115 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 $ 240,191 $ 239,260 $ 931 0.4% $ 240,191 $ 239,260 $ 931 0.4% $ 1,171,228 20.4% Office of the Secretary of the District 185,824 166,777 19,046 10.2% 185,824 166,777 19,046 10.2% 846,215 19.7% Board of Directors 107,919 79,423 28,497 26.4% 107,919 79,423 28,497 26.4% 436,726 18.2% Administration Office of the Director of Finance and Administration 139,311 13S,472 3,840 2.8% 139,311 135,472 3,840 2.8% 616,7S4 22.0% Finance Division 376,131 351,617 24,514 6.5% 376,131 351,617 24,514 6.5% 1,807,021 19.5% Human Resources Division 1,934,913 1,504,345 430,569 22.3% 1,934,913 1,504,345 430,569 22.3% 7,999,453 18.8% Purchasing Division 396,132 401,749 (5,617) -1.4% 396,132 401,749 (5,617) -1.4% 1,748,276 23.0% Risk Management Program 262,783 191,269 71,514 27.2% 262,783 191,269 71,514 27.2% 1,074,459 17.8% Public Info/Comm. Services & Intergov Relations Division 461,733 385,662 76,070 16.5% 461,733 385,662 76,070 16.5% 1,932,181 20.0% Information Technology Division 1,132,273 1,055,404 76,869 6.8% 1,132,273 1,055,404 76,869 6.8% 4,722,904 22.3% Engineering & Technical Services Office of the Director of Engineering & Technical Services 204,977 41,823 163,153 79.6% 204,977 41,823 163,153 79.6% 905,205 4.6% Planning & Developmental Services 1,400,002 1,110,726 289,276 20.7% 1,400,002 1,110,726 289,276 20.7% 5,891,208 18.9% Capital Projects Division 15,658 (286,594) 302,252 1930.3% 15,658 (286,594) 302,252 1930.3% 26,686 -1074.0% Environmental & Regulatory Compliance 1,897,920 1,629,024 268,896 14.2% 1,897,920 1,629,024 268,896 14.2% 8,056,928 20.2% Operations Office of the Director of Operations 140,492 170,403 (29,911) -21.3% 140,492 170,403 (29,911) -21.3% 612,429 27.8% Collection System Operations Division 3,022,018 2,867,972 154,046 5.1% 3,022,018 2,867,972 154,046 5.1% 12,865,365 22.3% Treatment Plant Operations Division 2,877,347 2,909,628 (32,280) -1.1% 2,877,347 2,909,628 (32,280) -1.1% 12,350,601 23.6% Treatment Plant Maintenance Division 3,548,315 3,014,053 534,262 15.1% 3,548,315 3,014,053 534,262 15.1% 14,845,741 20.3% Recycled Water RecycledWater- General 40,825 61,118 (20,293) -49.7% 40,825 61,118 (20,293) -49.7% 163,300 37.4% Treatment Plant 17,375 330,630 (313,255) -1802.9% 17,375 330,630 (313,255) -1802.9% 685,400 48.2% Distribution System 69,163 93,197 (24,035) -34.8% 69,163 93,197 (24,035) -34.8% 388,150 24.0% Residential Fill Station 67,600 184,984 (117,384) -173.6% 67,600 184,984 (117,384) -173.6% 270,400 68.4% Satellite Water Facility 25,875 - 25,875 100.0% 25,87S - 25,875 100.0% 103,500 0.0% Total Expenses $ 18,564,777 $ 16,637,943 $ 1,926,834 10.4% $ 18,564,777 $ 16,637,943 $ 1,926,834 10.4% $ 79,520,131 20.9% 111Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 116 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 $ 9,829 $ 5,554 129.9% $ 4,275 $ 9,829 $ 5,554 129.9% $ 10,035,739 0.1% Other Capital Revenues 1,641,650 1,403,054 (238,596) -14.5% 1,641,650 1,403,054 (238,596) -14.5% 22,207,682 6.3% Total Revenue $ 1,64S,925 $ 1,412,883 $ (233,042) -14.2% $ 1,645,92S $ 1,412,883 $ (233,042) -14.2% $ 32,243,421 4.4% Year -to -Date Revenues by Source $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■ YTD ■ YTD Budget Actual 121Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 117 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 $ 5,870 $ (67) -1.1% $ 5,938 $ 5,870 $ (67) -1.1% $ 23,750 24.7% County Allocated - - - - - - 9,916,325 0.0% Direct Billed - - - 102,314 0.0% Prior Year Adjustment (1,663) 3,959 5,621-338.1% (1,663) 3,959 5,621-338.1% (6,650) -59.5% Other Capital Revenues Facilities Capacity Fees - Gravity Zone Facilities Capacity Fees - Pump Zone Capacity Use Charge Secured Property Tax Investment Income Other Government Revenue - Concord Overtime Inspection Plan Review Main Lines Inspection Fees Miscellaneous Income Contractual Assessment District Total Revenues 131Page 1,449,750 807,594 (642,156) -44.3% 1,449,750 807,594 (642,156) -44.3% 5,799,000 13.9% 37,750 45,336 7,586 20.1% 37,750 45,336 7,586 20.1% 151,000 30.0% 24,500 - (24,500) -100.0% 24,500 - (24,500) -100.0% 98,000 0.0% - 453,922 453,922 - 453,922 453,922 6,940,168 6.5% 79,750 255 (79,495) -99.7% 79,750 255 (79,495) -99.7% 319,000 0.1% - - - - - - 8,700,914 0.0% 2,000 3,759 1,759 88.0% 2,000 3,759 1,759 88.0% 8,000 47.0% 30,250 8,090 (22,160) -73.3% 30,250 8,090 (22,160) -73.3% 121,000 6.7% 17,250 15,547 (1,703) -9.9% 17,250 15,547 (1,703) -9.9% 69,000 22.5% 400 68,136 67,736 16934.0% 400 68,136 67,736 16934.0% 1,600 4258.5% 414.04 414 414 414 $ 1,645,925 $ 1,412,883 $ (233,042) -14.2% $ 1,645,925 $ 1,412,883 $ (233,042) -14.2% $ 32,243,421 4.4% November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 118 of 167 10ENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 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 I Carryforwardto Adopted Budget 1 Adjusted Approved 1 Actual Remaining Budgets Actuals FY 2021-22 Budget Adjustments Budget Expenditures Expenditures Budget Collection System (CS) $ 60,527,138 48,915,427 11,611,704 39,795,000 39,795,000 51,406,711 7,271,668 44,135,043 Treatment Plant (TP) 63,431,961 41,480,537 21,951,398 45,230,000 45,230,000 67,181,424 3,576,164 63,605,260 General Improvements (GI) 15,799,506 14,694,853 1,104,648 3,830,000 3,830,000 4,934,653 712,378 4,222,275 Recycled Water (RW) 16,986,894 13,713,009 3,273,881 16,600,000 16,600,000 19,873,885 1,078,898 18,794,987 CIB Contingency - - - 2,500,000 2,500,000 2,500,000 - 2,500,000 Total $ 156,745,499 $ 118,803,826 $ 37,941,631 $ 107,955,000 $ $ 107,955,000 $ 145,896,673 $ 12,639,108 $ 133,257,565 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 f $10,000,000 '+ Collection Treatment Plant General Recycled Water CIB Contingency System (CS) (TP) Improvements (RW) (GI) Program ■ Approved Expenditures ■ Actual Expenditures 141Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 119 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project) A B C A-B D E F D+E G C+D+E H 1 G- Cumulative Cumulative Total Project FY 2020-21 FY 2020-21 FY 2020-21 FY 2020-21 FY 2020-21 FY 2020-21 Prior Year Prior Year I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY2O2O-21 Budget Adjustments Bud et 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 - 1,177,238 *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) - (602,844) 8419 Collection System Planning LT 1,385,000 1,277,077 107,923 200,000 - 200,000 307,923 28,074 279,849 8436 Moraga/ Crossroads PS Project 22,807,000 20,399,420 2,407,580 12,644,000 - 12,644,000 15,051,580 3,640,517 11,411,063 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 19,290 1,607,501 8444 Force Main Inspection Program 625,000 15,525 609,475 500,000 - 500,000 1,109,475 2,174 1,107,301 8447 Pump Station Security Improvement 282,000 - 282,000 75,000 - 75,000 357,000 - 357,000 8448 Manhole Modifications 1,607,925 1,359,075 248,850 400,000 - 400,000 648,850 - 648,850 8449 Collection System Modeling Support 423,000 156,147 266,853 120,000 - 120,000 386,853 8,901 377,952 8450 Development Sewerage Support 3,132,316 3,137,328 (5,012) 900,000 - 900,000 894,988 216,593 678,395 8451 C. S. Sewer Renovation 4,562,527 576,878 3,985,649 1,136,000 (1,750,000) (614,000) 3,371,649 197,554 3,174,095 8457 Pump Station Upgrades - Ph. 2 2,950,000 2,336,364 613,636 3,000,000 - 3,000,000 3,613,636 161,734 3,451,902 8458 Martinez Sewer Renov. Ph. 6 4,470,000 4,249,701 220,299 - - - 220,299 98,738 121,561 8459 Lafayette Sewer Renov. Ph. 14 4,200,000 3,853,736 346,264 - - - 346,264 60,525 285,739 8460 WC Sewer Renov. Ph. 14 5,173,000 4,881,605 291,395 - - - 291,395 129,879 161,516 8461 So. Orinda Sewer Ren. Ph. 8 600,000 2,909,663 (2,309,663) 4,600,000 - 4,600,000 2,290,337 2,099,626 190,711 8463 No. Orinda Sewer Renov. PH. 8 500,000 472,342 27,658 4,600,000 - 4,600,000 4,627,658 151,377 4,476,281 8464 Martinez Sewer Renov. Ph. 7 500,000 296,826 203,174 2,000,000 - 2,000,000 2,203,174 80,039 2,123,135 8465 WC Sewer Renov. Ph. 15 500,000 527,035 (27,035) 4,900,000 - 4,900,000 4,872,965 220,311 4,652,654 8466 Danville Sewer Ren. Ph. 4 500,000 202,056 297,944 1,000,000 - 1,000,000 1,297,944 97,967 1,199,977 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 - 2,000,000 100017 SR Pump Station Electrical Upgrades 180,000 31,479 148,521 520,000 - 520,000 668,521 14,673 653,848 **100021 Cordel Drive West CAD - - - - 167,060 167,060 167,060 - 167,060 **100023 Walnut Creek Sewer Renovation Ph. 16 - - - - 500,000 500,000 500,000 11,517 488,483 **100024 South Orinda Sewer Renovation Ph. 9 - - - - 500,000 500,000 500,000 6,937 493,063 **100025 Lafayette Sewer Renov. Ph.15 - - - - 500,000 500,000 500,000 9,905 490,095 **100026 Pacheco Boulevard Sewer Renovation - - - 250,000 250,000 250,000 3,336 246,664 TBD Collection System Master Plan 2021 Update - - - 750,000 - 750,000 750,000 - 750,000 Rounding (7) Total CS Program $ 60,527,138 48,915,427 11,611,704 39,795,000 39,795,000 51,406,711 7,271,668 44,135,043 * Substantially complete FY 20/21 ** Not in 21/22 Budget. New projects. Funds transferred from other projects or Contingency 151Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 120 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project), Continued A B C A-B D E F D+E G C+D+E H 1 G- Cumulative Cumulative Total Project FY 2020-21 FY 2020-21 FY 2020-21 FY 2020-21 FY 2020-21 FY 2020-21 Prior Year Prior Year I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY2020-21 Budget Adjustments Bud et Expenditures Expenditures Budget TYPE TP Treatment Plant 7304 Instr & Controls PLC Upgrade 620,000 520,734 99,266 120,000 - 120,000 219,266 3,040 216,226 7315 Applied Research and Innovations 1,357,274 476,040 881,234 300,000 - 300,000 1,181,234 30,540 1,150,694 7328 Influent Pump Electrical improvements 4,910,000 3,588,503 1,321,497 3,250,000 - 3,250,000 4,571,497 1,549,396 3,022,101 7339 T. Plant Control System I/O Replacement 3,470,000 3,115,113 354,887 - - - 354,887 3,825 351,062 7341 WC/Grayson Creek Levee Rehab 550,000 137,840 412,160 500,000 - 500,000 912,160 25,699 886,461 7348 Solids Handling Facility Improvements 17,118,687 15,688,482 1,430,205 21,000,000 - 21,000,000 22,430,205 334,963 22,095,242 7349 Aeration & Energy Upgrade 5,600,000 4,228,795 1,371,205 250,000 - 250,000 1,621,205 46,207 1,574,998 7352 UV Disinfection Upgrades 1,350,000 757,400 592,600 - - - 592,600 158,527 434,073 7353 Outfall Improvements Ph. 7 5,920,000 5,665,520 254,480 - - - 254,480 42,687 211,793 7354 TP Security Improvements 1,255,000 191,152 1,063,848 445,000 - 445,000 1,508,848 - 1,508,848 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 79,072 656,955 7364 TP Safety Enhancement Ph. 5 1,180,000 1,147,459 32,541 - - - 32,541 (61,516) 94,057 7369 Piping Renovation - Phase 10 3,250,000 667,413 2,582,587 2,200,000 - 2,200,000 4,782,587 40,980 4,741,607 7370 Annual Infrastructure Replacement 2,350,000 1,186,034 1,163,966 1,255,000 - 1,255,000 2,418,966 41,986 2,376,980 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 69,684 810,453 7375 Contractor Staging Improvements 3,500,000 623,407 2,876,593 - - - 2,876,593 768,412 2,108,181 100001 UPCAA Urgent Projects FY 2020-25 600,000 157,502 442,498 600,000 - 600,000 1,042,498 78 1,042,420 100008 Laboratory Roof & Seismic upgrades 500,000 - 500,000 450,000 - 450,000 950,000 - 950,000 100009 Hearth Replacement 500,000 - 500,000 - - - 500,000 14,993 485,007 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 22 592,062 100012 UV Disinfection Replacement 500,000 193,232 306,768 2,000,000 - 2,000,000 2,306,768 171,833 2,134,935 100013 UV Hydraulic Improvements 480,000 5,480 474,520 - - - 474,520 216 474,304 100014 MRC Building Modifications 450,000 978 449,022 300,000 - 300,000 749,022 238 748,784 100015 Electric Blower Improvements 1,750,000 916,828 833,172 7,400,000 - 7,400,000 8,233,172 69,989 8,163,183 100018 Outfall Monitoring Improvements 100,000 13,214 86,786 510,000 - 510,000 596,786 49,200 547,586 100019 Aeration Basins Diffuer Replacement and Seismic L 200,000 15,097 184,903 2,100,000 - 2,100,000 2,284,903 186,048 2,098,855 **100022 Wet Weather Basin Improvements 200,000 178,085 21,915 500,000 - 500,000 521,915 - 521,915 TBD TP Safety Enhancemetns - Ph. 6 - - - 200,000 - 200,000 200,000 - 200,000 Rounding (26) (26) Total TP Program $ 63,431,961 $ 41,480,537 $ 21,951,398 $ 45,230,000 $ $ 45,230,000 $ 67,181,424 $ 3,576,164 $ 63,605,234 * Substantially complete FY 20/21 ** Not in 20/21 Budget. New projects. Funds transferred from other projects or Contingency 161Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 121 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINEZ, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 2020.21 FY ZOZO-21 FY 2020.21 FY 2020-21 FY 2020.21 FY 20ZO-21 Prior Year Prior Year I Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2020-21 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 5,962 23,639 8236 District Easements 408,047 256,934 151,113 75,000 - 75,000 226,113 20,168 205,945 8240 IT Development 3,738,794 3,723,005 15,789 750,000 - 750,000 765,789 113,008 652,781 8250 ERP Replacement 5,030,000 5,189,106 (159,106) 300,000 - 300,000 140,894 (11,204) 152,098 8251 Capital improvement program & Budget Improvers 490,000 124,024 365,976 100,000 - 100,000 465,976 3,444 462,532 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 - 177,345 8516 District Equipment Acquisition 1,226,000 1,244,370 (18,370) 250,000 - 250,000 231,630 21,495 210,135 8517 Vehicle Replacement Program 3,818,000 3,718,421 99,579 900,000 - 900,000 999,579 513,333 486,246 100003 Property Repairs & Improvements 300,000 156,418 143,582 150,000 - 150,000 293,582 17,109 276,473 100004 HOB Exterior Repairs 350,000 24,107 325,893 50,000 - 50,000 375,893 27,915 347,978 TBD 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) - (60,000) 60,000 - - - 60,000 1,149 58,851 Rounding - (5) (5) Total GI Program $ 15,799,506 14,694,853 1,104,648 3,830,000 3,830,000 4,934,653 712,378 4,222,270 TYPE RW Recycled Water 7306 Zone 1 Recycled Water 732,894 631,427 101,467 - - - 101,467 20,228 81,239 7361 Filter Plant & Clearwell Improvements Ph. lA 14,989,000 12,823,576 2,165,424 16,000,000 - 16,000,000 18,165,424 1,038,078 17,127,346 7366 ReW Distribution System Renov. Program 515,000 115,869 399,131 200,000 - 200,000 599,131 15,615 583,516 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 Technology Strategic Plan - - - 100,000 - 100,000 100,000 - 100,000 Rounding (4) (1) Total RW Program $ 16,986,894 13,713,009 3,273,881 16,600,000 16,600,000 19,873,885 1,078,898 18,794,986 9990 CONTINGENCY -ALL PROGRAMS 2,500,000 - 2,500,000 2,500,000 2,500,000 GRAND TOTAL $ 156,745,499 118,803,826 37,941,631 107,955,000 107,955,000 145,896,673 12,639,108 133,257,533 171Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 122 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 5 - Self Insurance Fund Revenues by Source Annual QTD QTD YTD Budget QTD QTD Variance Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual ($) (%) Budget Actual Variance ($] (%) Budget (%) Sewer Service Charge County $ $ $ $ $ $ $ 1,576,419 Subrogation Recoveries - Insurance Recoveries (HHW) 6,250 (6,250) -100.0% 6,250 (6,250) -100.0% 25,000 0.0% Investment Income 12,500 4,063 (8,437) -67.5% 12,500 4,063 (8,437) -67.5% 50,000 8.1% Total Revenues $ 18,750 $ 4,063 $ (14,687) -78.3% $ 18,750 $ 4,063 $ (14,687) -78.3% $ 1,651,419 0.2% $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 181Page Year -to -Date Revenues by Source Subrogation Recoveries Contribution From 0&M Insurance Recoveries (HHW) Revenue Source Category ■ YTD ■ YTD Budget Actual Investment Income November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 123 of 167 10ENTRAL 5AN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 $ 32,132 $ (7,132) -28.5% $ 25,000 $ 32,132 $ (7,132) -28.5% $ 140,000 23.0% Technical Services 12,500 - 12,500 100.0% 12,500 - 12,500 100.0% 60,000 0.0% Insurance & Risk Management 37,500 181,809 (144,309) -384.8% 37,500 181,809 (144,309) -384.8% 1,085,000 16.8% Total Expenses $ 7S,000 $ 213,941 $ (138,941) -185.3% $ 75,000 $ 213,941 $ (138,941) -185.3% $ 1,28S,000 600.6% $200,000 $180,000 $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 191Page Year -to -Date Expenses by Type Professional Services Technical Services Insurance & Risk Management Expense Category ■YTD ■ YTD Budget Actual November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 124 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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 $ $ $ $ $ $ $ 12,891,059 Investment Income - Total Revenues $ $ $ $ $ $ $ 12,891,059 0.0% $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 201Page Year -to -Date Revenues by Source Tax Revenue Investment Income ■ YTD ■ YTD Budget Actual November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 125 of 167 'dryt'CENTRAL 5AN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 6 - Debt Service Fund Expenses by Type Annual QTD YTD Budget QTD QTD QTD Variance Variance YTD YTD YTD Revenue Annual Realized Category Budget Actual ($) (%) Budget Actual Variance ($) (%) Estimate (%) Professional Services $ - $ 2,200 $ (2,200) $ - $ 21200 $ (2,200) $ Interest Expense 372,948 124,316 248,632 66.7% 372,948 124,316 248,632 66.7% 2,441,OS9 1963.6% Total Expenses $ 372,948 $ 126,516 $ 246,432 66.1% $ 372,948 $ 126,516 $ 246,432 66.1% $ 2,441,059 5.2% Year -to -Date Expenses by Type $400,000 $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 Professional Services Interest Expense ■ YTD ■ YTD Budget Actual 211Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 126 of 167 'dryt'CENTRAL $AN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 7 - Quarterly Investment Portfolios Operating & Maintenance 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 LAIF n/a n/a n/a (1) $ 11,100,000 $ 21,100,000 $ (10,000,000) $ 11,100,000 $ 11,109,451 100.00% $ 10,907 $ 10,907 (3) $ 11,100,000 $ 21,100,000 $ (10,000,000) $ 11,100,000 $ 11,109,451 100.00% 10,907 10,907 (2) (4) (8) $ 10,907 $ 10,907 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Notes (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of September, 2021 was 0.210%. (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.210%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut-off for month -end reporting by Contra Costa County. (4) The market value of the portfolio on September 30, 2021 was $11,109,451. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values quarterly. (5) All investments held by the Running Expense Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)] (6) Sufficient liquidity and anticipated revenues are available for Central Santo meet budgeted expenditures of the Running Expense fund for the next six (6) months [California Government Code §53646(b)(3)] (7) Of the total investments held in the Running Expense Fund, $3,760,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 he included in the following month's report 221Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 127 of 167 'dryt'CENTRAL $AN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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. LAIF 8/86-2/90 n/a n/a (1) $ 1000000 $ 25,300,000 $ - $ 1,000,000 $ 1,000,851 100.00% $ 547 $ 547 958 US T Bill US Treasury Bill 4/9/2021 7/15/2021 n/a 0.010 24:999:326 25,000,000 (25,000,000) 0.00 % 97 97 (3) $ 25.999.326 $ 50.300.000 $ f25.000.0001 $ 1.000.000 $ 1.000.851 100.00% 644 644 (2) (4) (8) $ 644 $ 644 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Notes: (1) Annual Yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of September, 2021 was 0.210%. (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.210%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut- off for month -end reporting by Contra Costa County. (4) The market value of the portfolio on September 30, 2021 was $1,000,851. 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. 231Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 128 of 167 'dryt'CENTRAL $AN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 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) $ 7,600,000 $ 7,600,000 $ $ 7,600,000 $ 7,606,471 100.00% $ 4,152 $ 4,152 (3) $ 7,600,000 $ 7,600,000 $ $ 7,600,000 $ 7,606,471 100.00% 4,152 4,152 (2) (4) (7) $ 4,152 $ 4,152 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Notes: (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of September, 2021 was 0.210%. (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.210%. (4) The market value of the portfolio on September, 2021 was $7,606,471. (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 November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 129 of 167 10ENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94SS3-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 8 - Financial Performance Metric Charts O&M Fund Cashflow Forecast FY 2021-22 Running Expense Fund Total Cash & Investment Balances (Actuals through September 2021) $70.0 $67.5 $673 $60.0 $50.0 $40.0 $30.0 $20.0 $10.0 $0.0 June'21 July August September October November December January February March April May June = Projected Balance* I= 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 November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 130 of 167 10ENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast $90.0 $80.0 $70.0 $60.0 $50.0 $40.0 $30.0 $20.0 $10.0 $0.0 FY 2021-22 Sewer Construction Fund Total Cash & Investment Balances (Actuals through September 2021) $71s June'21 July $56.3 $60.5 $56.3 $57.1 $56.7 $55.6 � $50-8 2 $41.2 August September October November December January February March mProjected Balance* MActual Balance •—Reserve Target at Year End** M April 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 1>® May $54.0 June November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 131 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 8 - Financial Performance Metric Charts Staffing Trends 300 5.9% vacancy Rate 295 290 w 285 7 a� 280 Cz 275 w270 265 273 271 273 260 255 250 9/30/18 9/30/19 9/30/20 9/30/21 Quarter Ended ■ Filled Positions (FTEs) ■ Vacancies (FTEs) 271Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 132 of 167 10ENTRAL 5AN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated $5,000 $4,500 $4,000 $3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 281Page Historical Quarterly 0&M Cost per Million Gallons Treated $4,142 9/30/18 $ 3,413 $ 3,449 $ 3, 3 74 November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 133 of 167 'dryt'CENTRAL SAN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 8 - Financial Performance Metric Charts Capital Spending Trend $160 $145.9M $140 $120 x .3M o $100 $80 $60 I $2 3.5 M $40 - $21.2M $20 $12.6M $- O&obeC be{ "Deco" Projected (100% spend) Actual 90% Target 291Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 134 of 167 'dryt'CENTRAL 5AN 5019 IMHOFF PLACE, MARTINET, CA 94553-4392 Budget -to -Actual Financial Report Quarter Ending September 30, 2021 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed / Renovated 4.0 3.5 ,z 3.0 ` UU N 2.5 a 2.0 U 1.8 E 2.0 1.7 p. a. a 1.5 y 1.0 1.0 0.5 0.5 0 0.0 a Ig0I1,1 1tiI31Iti1 � Ig1�1''L 6I30�titi Quarter Ending ■ Actual Construction ■ Target ("S-Curve" of 6 mi. FY 21-22 Budget Projection) 301Page November 22, 2021 Regular FINANCE Committee Meeting Agenda Packet - Page 135 of 167