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 quarterly financial review (unaudited) for Quarter Ended June 30, 2021
Page 1 of 35 Item 5.b. CENTRAL SAN September 28, 2021 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 (UNAUDITED) FOR QUARTER ENDED JUNE 30, 2021 Attached is the Quarterly Financial Review for the fourth quarter of Fiscal Year 2020-21 ending June 30, 2021. The Executive Summary (Section 1) of the attached report includes an analysis of financial results and the investment portfolios for the quarter. While this reports the year-end results for FY 2020-21, it is an un-audited draft, which is subject to change pending the conclusion of the audit expected in November or December 2021. Any significant changes to the figures presented in this report will be summarized when the annual pre-audit year-end variances report is presented to the Finance Committee, expected to occur in October or November 2021. 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- June 30, 2021 September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 123 of 170 . . uarterFinancial _s CENTRAL SAN Review ( Unaudmite rw i _- - IPA _ i �� Um. i _ u 1 J 11 -- -7- . Igo 4 i September 28, 2021 Regular FINANCE Committee Meeting Agenda124 , nded June 30, 2021 910ENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Table of Contents Section1 - Executive Summary................................................................................................................................................................................................1 Section2 - 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.............................................................................................................................................................................................................................19 Expensesby Type.................................................................................................................................................................................................................................20 September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 125 of 170 910ENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Table of Contents Section 6 - Debt Service Fund Revenuesby Source.............................................................................................................................................................................................................................21 Expensesby Type.................................................................................................................................................................................................................................22 Section 7 -Investment Portfolio Reports Operations &Maintenance Fund....................................................................................................................................................................................................23 SewerConstruction Fund..................................................................................................................................................................................................................24 SelfInsurance Fund.............................................................................................................................................................................................................................25 Section 8 -Financial Performance Metrics 0&M Fund Cashflow Forecast.........................................................................................................................................................................................................26 Sewer Construction Fund Cashflow Forecast...........................................................................................................................................................................27 StaffingTrends.......................................................................................................................................................................................................................................28 Costper Million Gallons of Wastewater Treated.....................................................................................................................................................................29 CapitalSpending Trend......................................................................................................................................................................................................................30 Milesof Pipeline Constructed/Renovated..................................................................................................................................................................................31 September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 126 of 170 910ENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 1 -Executive Summary Quarterly Financial Highlights Included in this consolidated report are quarterly budget-to-actual financial reports as well as the investment portfolio reports for the fourth quarter of FY 2020-21 ended June 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 fourth quarter show total expenditures are $153.7 million, which is approximately $7.7 million (4.8%) under the annual budget, as amended. This favorable expense variance is larger in total dollars but smaller in proportion of total the budget than the favorable year-to-date budget variance reported in the prior year for the same through the fourth quarter of FY 2019-20 of$5.9 million (6.7%). This variance has also decreased substantially compared to the 13.1% variance reported in the prior quarter ending March 31, 2021, largely due to the $70.8 million payment to the Contra Costa County Employees' Retirement Association (CCCERA) in June 2021 to eliminate the Central San's outstanding unfunded actuarially accrued liability (UAAL) balance attributable to pension obligations. In connection with the UAAL pay-off, Central San's Board authorized an amendment to the 0&M fund budget, increasing total appropriation by $70.8 million. While the full-time employee vacancy rate of approximately 4.8% has remained consistent with the prior quarter, it is still well over the assumed vacancy factor in the FY 2020-21 budget of 2.0% which has been a leading driver in the $2.5 (6.2%) million favorable variance in salaries and wages. The second largest budgetary variance is in the professional, technical, and other services category, reporting a favorable variance of approximately $2.2 million. The bulk of these savings (59%) was attributable to budgetary savings in the Communications and Intergovernmental Affairs, Planning & Development, and Collection System Operations divisions. In the aggregate, the 0&M Fund is reporting total revenues of$92.6 million, which results in a significant favorable revenue variance of approximately $27.2 million (41.6%) above total estimated revenues of the FY 2020-21 adopted budget. The primary driver for this overall revenue variance is Board-approved redirection of April and June sewer service charges (SSC) initially budgeted in the Sewer Construction Fund to the 0&M fund totaling approximately $27.0 million. This allocation of 11Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 127 of 170 910ENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 1 -Executive Summary additional SSC to the 0&M fund was necessary to finance the $78.0 million UAAL payoff payment made to CCCERA, as described previously. Furthermore, additional allocations of SSC from the Sewer Construction Fund to the 0&M Fund have been approved by the Board in FY 2021-22 to reimburse the remaining balance of the June 2021 UAAL payoff. Non-operating revenues, which had a positive year-to-date estimated budget variance of$0.3 million in the aggregate last quarter, are now reporting a favorable variance of approximately$0.1 million. Sewer Construction Fund Sewer Construction Fund results for the fourth quarter show total capital project expenditures of $70.4 million, or 80.0% of the total adopted budget of$88.0 million. When including roll-over capital project appropriations from the prior year of$21.0 million, the capital spending rate is 64.9% of total FY 2020-21 Board authorized appropriations of$108.6 million. The bulk of the capital spending budget variance is in the Treatment Plant program (55%) followed by the Collection System program (30%) 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 $64.0 million, reflecting a large unfavorable year-to-date variance of$31.0 million (32.6%). As noted previously, this unfavorable revenue variance is directly related to the pension UAAL payoff in June 2021, where sewer service charges originally budgeted in the Sewer Construction Fund were redirected to the 0&M Fund. To offset the reduction in sewer service charge revenue in the Sewer Construction Fund, Central San issued $58.0 million in Certificates of Participation, used to finance a portion of the FY 2020-21 as well as FY 2021-22 capital program. Additionally, lower than anticipated capital spending in FY 2020-21 paired with a lower than projected sewer flow rate of 32.3% contributed to the annual reimbursement from the City of Concord for eligible capital outlays being$5.2 million lower than budgeted. 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 on June 30, 2021 are presented in separate Investment Portfolio Reports for each fund on 2 1 P a g e September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 128 of 170 910ENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ.CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 1 -Executive Summary pages 23-25 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 2020-21, the 0&M Fund has generated Investment Income of$143,256, which is below the annual revenue estimate of $190,000 by 24.6%. The Sewer Construction Fund is reporting Investment Income of $245,740 (includes CAD/AVAD interest), coming in below the annual revenue estimate of $293,500 by 16.3%. As of June 30, 2021, Central San continues to hold the bulk of its investment portfolio, or $29.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 are 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 June 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 2020-21 budgeted revenues. 3 1 P a g e September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 129 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 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 $ 65,432,162 $ 92,619,274 27,187,112 41.6% $ 65,432,162 141.6% Sewer Construction 94,952,902 63,957,923 (30,994,979) -32.6% 94,952,902 67.4% Self Insurance 582,050 629,075 47,025 8.1% 582,050 108.1% Debt Service 2,517,605 2,522,405 4,800 0.2% 2,517,605 100.2% Total $ 163,484,719 $ 159,728,677 $ (3,756,042) $ 163,484,719 Fund Expenses 0&M $ 161,466,338 $ 153,743,636 7,722,702 4.8% $ 161,466,338 95.2% Sewer Construction 108,595,766 70,440,196 38,155,570 35.1% 108,595,766 64.9% Self Insurance 1,153,500 1,395,142 (241,642) -20.9% 1,153,500 120.9% Debt Service 777,605 782,405 (4,800) -0.6% 777,605 100.6% Total $ 271,993,209 $ 226,361,378 $ 45,631,831 $ 271,993,209 YTD Budget-to-Actual Revenues by Fund YTD Budget-to-Actual Expenses by Fund $10010W,000 yam, Mpoo,OW 5160,000,000 dry $00,o00,OW +� 5140,000,000 • $70,000,OW $1zo,000", F $60poo,OW Eloo,000,000 $5o,000,o00 $40,000,oaa nr f SBo,000,DW +1 $30,000,000 •/Jj' 560,000,OW $20,000,000 ^ $40,000,OW $lo,000,o00 p� $20,000,oW y g-✓ g ✓� 0&M sewer fnnso-ucrion Self Insurance Debt Service 0&M Sewer Cens[ruRiou Self lnsurarce Debt F.d erviceFund Fund •BID •YTD •YID •YTD Dudgrt Actual budget Actual 4Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 130 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 $ 21,223,465 $ 48,561,004 $ 27,337,539 128.8% $ 44,527,762 $ 72,325,341 $ 27,797,579 62.4% $ 44,527,762 162.4% Sewage Treatment Cost Sharing 15,760,000 15,048,782 (711,218) -4.5% 15,760,000 15,002,567 (757,433) -4.8% 15,760,000 95.2% Miscellaneous Service Charge 1,352,693 1,639,507 286,814 21.2% 2,177,000 2,195,519 18,519 0.9% 2,177,000 100.9% Non-Operating Revenues: Permit and Inspection Fees 505,600 553,353 47,753 9.4% 2,022,400 2,176,156 153,756 7.6% 2,022,400 107.6% Other Non Operating Income 188,750 (23,110) (211,860) -112.2% 755,000 776,436 21,436 2.8% 755,000 102.8% Investment Income 47,500 16,439 (31,061) -65.4% 190,000 143,256 (46,744) -24.6% 190,000 75.4% Total Revenue $ 39,078,008 $ 65,795,975 $ 26,717,967 68.4% $ 65,432,162 $ 92,619,274 $ 27,187,112 41.6% $ 65,432,162 141.6% Year-to-Date Revenues by Source $80,000,000 $70,000,000 $60,000,000 $50,000,000 $40,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 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 131 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 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 $ 22,003 $ 75,862 $ 53,859 244.8% $ 88,000 $ 173,354 $ 85,354 97.0% $ 88,000 197.0% Sewer Service Charge County 21,211,362 48,522,688 27,311,326 128.8% 43,951,362 71,355,911 27,404,549 62.4% 43,951,362 162.4% Sewer Service Charge Direct - 20,532 20,532 528,000 860,579 332,579 63.0% 528,000 163.0% Sewer Service Charge Prior (9,900) (58,079) (48,179) 486.7% (39,600) (64,504) (24,904) 62.9% (39,600) 162.9% Sewage Treatment Cost Sharing 15,760,000 15,048,782 (711,218) -4.5% 15,760,000 15,002,567 (757,433) -4.8% 15,760,000 95.2% Miscellaneous Service Charges Septic Tank Dumping 12,500 10,865 (1,635) -13.1% 50,000 43,777 (6,223) -12.4% 50,000 87.6% Sales 250 500 250 100.0% 1,000 550 (450) -45.0% 1,000 55.0% Other Service Charges 47,500 104,885 57,385 120.8% 190,000 116,538 (73,462) -38.7% 190,000 61.3% Recycled Water 105,000 233,288 128,288 122.2% 420,000 538,943 118,943 28.3% 420,000 128.3% Satellite Water Recycling 15,500 25,756 10,256 66.2% 62,000 25,756 (36,244) -58.5% 62,000 41.5% Stormwater Program 195,000 258,497 63,497 32.6% 390,000 415,115 25,115 6.4% 390,000 106.4% Household Hazardous Waste 976,943 1,005,717 28,774 2.9% 1,064,000 1,054,840 (9,160) -0.9% 1,064,000 99.1% Permit&Inspection Fees Permit/Application Fees 150,000 160,348 10,348 6.9% 600,000 624,736 24,736 4.1% 600,000 104.1% Overtime Inspection 3,600 1,435 (2,165) -60.1% 14,400 11,647 (2,753) -19.1% 14,400 80.9% Side Sewer Inspection 292,500 332,137 39,637 13.6% 1,170,000 1,330,192 160,192 13.7% 1,170,000 113.7% Industrial Permit Fees 25,750 27,552 1,802 7.0% 103,000 113,175 10,175 9.9% 103,000 109.9% New Industry Permit Fees 3,750 2,137 (1,613) -43.0% 15,000 7,192 (7,808) -52.1% 15,000 47.9% Annexation Charges 30,000 29,744 (256) -0.9% 120,000 89,214 (30,786) -25.7% 120,000 74.3% Other Non-Operating Income MVSD P2 Program 6,000 11,496 5,496 91.6% 24,000 20,748 (3,252) -13.6% 24,000 86.4% Pretreatment Program Fine 500 - (500) -100.0% 2,000 - (2,000) -100.0% 2,000 0.0% Rebates to District - 302 302 - 302 302 - Lease Rental Income 179,750 155,247 (24,503) -13.6% 719,000 742,726 23,726 3.3% 719,000 103.3% Miscellaneous Income 2,500 (196,764) (199,264) -7970.6% 10,000 (16,928) (26,928) -269.3% 10,000 -169.3% Right of Way Fees - 6,609 6,609 - 29,589 29,589 - Investment Income 47,500 16,439 (31,061) -65.4% 190,000 143,256 (46,744) -24.6% 190,000 75.4% Total Revenues $ 39,078,008 $ 65,795,975 $ 26,717,967 68.4% $ 65,432,162 $ 92,619,274 $ 27,187,112 41.6% $ 65,432,162 141.6% 6 1 P a g e September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 132 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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,885,798 $ 10,700,926 $ (815,128) -8.2% $ 39,543,191 $ 37,072,780 $ 2,470,411 6.2% $ 39,543,191 93.8% Employee Benefits 2,886,293 2,825,294 60,999 2.1% 11,545,173 10,710,507 834,666 7.2% 11,545,173 92.8% Unfunded Liability Costs 74,756,754 75,252,103 (495,349) -0.7% 86,627,016 86,280,220 346,796 0.4% 86,627,016 99.6% Purchased Property Services 1,583,644 2,440,410 (856,766) -54.1% 6,334,577 5,883,526 451,051 7.1% 6,334,577 92.9% Other Purchased Services 1,576,369 1,038,848 537,521 34.1% 6,305,477 4,142,081 2,163,396 34.3% 6,305,477 65.7% Supplies&Materials 2,366,575 2,247,458 119,117 5.0% 9,466,300 8,475,993 990,307 10.5% 9,466,300 89.5% Other Expenses 298,651 70,772 227,879 76.3% 1,644,604 1,178,529 466,075 28.3% 1,644,604 71.7% Total Expenses $ 93,354,084 $ 94,575,811 $ (1,221,726) -1.3% $ 161,466,338 $ 153,743,636 $ 7,722,702 4.8% $ 161,466,338 95.2% Year-to-Date Expenses by Type $90,000,000 $80,000,000 $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 moor Salaries&Wages Employee Benefits Unfunded Liability Purchased Property Other Purchased Supplies&Materials Other Expenses Costs Services Services Department ■YTD ■YTD Budget Actual 7Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 133 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail QTD QTD QTD Variance YTD YTD YTD YTD Annual Category Budget Actual QTD Variance($) (%) Budget Actual Variance($) Variance(%) Budget %Used Salaries&Wages FTE Regular Pay $ 9,347,250 $ 9,879,432 $ (532,182) -5.7% $ 37,389,000 $ 34,818,572 $ 2,570,428 6.9% $ 37,389,000 93.1% Temporary Pay 76,493 - 76,493 100.0% 305,971 - 305,971 100.0% 305,971 0.0% Premium Pay 695,843 804,085 (108,242) -15.6% 2,783,370 2,196,285 587,085 21.1% 2,783,370 78.9% Board Fees 13,663 17,409 (3,746) -27.4% 54,650 57,924 (3,273) -6.0% 54,650 106.0% Other (247,450) (247,450) 100.0% (989,800) (989,800) 100.0% (989,800) 0.0% Total Salaries&Wages 9,885,798 10,700,926 (815,128) -8.2% 39,543,191 37,072,780 2,470,411 6.2% 39,543,191 93.8% Employee Benefits Leave Accruals - (5,644) 5,644 - - - - 0.0% Insurance Premiums 1,848,649 1,185,505 663,144 35.9% 7,394,596 6,351,490 1,043,106 14.1% 7,394,596 85.9% Employer Taxes 142,090 183,244 (41,154) -29.0% 568,359 595,742 (27,383) -4.8% 568,359 104.8% Employer Retirement Contributions 1,889,829 2,137,925 (248,097) -13.1% 7,559,314 6,987,540 571,774 7.6% 7,559,314 92.4% OPEB Contributions 410,250 562,761 (152,511) -37.2% 1,641,000 1,628,015 12,985 0.8% 1,641,000 99.2% Other Benefits 11,575 - 11,575 100.0% 46,300 - 46,300 100.0% 46,300 0.0% Benefit Adjustments (1,416,099) (1,238,496) (177,603) 12.5% (5,664,396) (4,852,280) (812,116) 14.3% (5,664,396) 85.7% Total Employee Benefits 2,886,293 2,825,294 60,999 2.1% 11,545,173 10,710,507 834,666 7.2% 11,545,173 92.8% Unfunded Liability Costs Pension 73,924,754 74,306,543 (381,789) -0.5% 83,299,016 83,800,989 (501,973) -0.6% 83,299,016 100.6% OPEB 925,250 945,560 (20,310) -2.2% 3,701,000 2,479,231 1,221,769 33.0% 3,701,000 67.0% UAAL Vacancy (93,250) (93,250) 100.0% (373,000) (373,000) 100.0% (373,000) 0.0% Total Unfunded Liability Costs 74,756,754 75,252,103 (495,349) -0.7% 86,627,016 86,280,220 346,796 0.4% 86,627,016 99.6% Purchased Property Services Repairs&Maintenance 1,022,600 1,147,489 (124,889) -12.2% 4,090,401 3,319,669 770,732 18.8% 4,090,401 81.2% Hauling&Disposal 253,606 936,440 (682,834) -269.2% 1,014,425 1,430,846 (416,421) -41.0% 1,014,425 141.0% Security 162,700 106,489 56,211 34.5% 650,800 374,036 276,764 42.5% 650,800 57.5% Rentals 47,675 115,763 (68,088) -142.8% 190,701 305,291 (114,590) -60.1% 190,701 160.1% Cleaning 97,062 134,229 (37,167) -38.3% 388,250 450,658 (62,408) -16.1°/% 388,250 116.1% Construction 3,025 (3,025) Total Purchased Property Services 1,583,644 2,440,410 (856,766) -54.1% 6,334,577 5,883,526 451,051 7.1% 6,334,577 92.9% (Continued on page 9) 8 1 P a g e September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 134 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued) QTD QTD QTD Variance YTD YTD YTD YTD Annual Category Budget Actual QTD Variance($) (%) Budget Actual Variance($) Variance(%) Budget %Used Purchased Professional,Technical& Other Services Professional Services 182,050 254,646 (72,596) -39.9% 728,200 825,544 (97,344) -13.4% 728,200 113.4% Technical Services 809,145 445,296 363,849 45.0% 3,236,580 1,347,203 1,889,377 58.4% 3,236,580 41.6% Other Purchased Services 585,174 338,906 246,268 42.1% 2,340,697 1,969,333 371,364 15.9% 2,340,697 84.1% Total Purchased Professional, Technical&Other Services 1,576,369 1,038,848 537,521 34.1% 6,305,477 4,142,081 2,163,396 34.3% 6,305,477 65.7% Supplies&Materials Utilities&Fuel 1,172,413 1,233,626 (61,213) -5.2% 4,689,650 4,449,539 240,111 5.1% 4,689,650 94.9% Chemicals 383,500 478,579 (95,079) -24.8% 1,534,000 1,727,050 (193,050) -12.6% 1,534,000 112.6% General Supplies 810,663 535,252 275,410 34.0% 3,242,650 2,299,403 943,247 29.1% 3,242,650 70.9% Total Supplies&Materials 2,366,575 2,247,458 119,117 S.0% 9,466,300 8,475,993 990,307 10.5% 9,466,300 89.5% Other Expenses Insurance&Risk Management - - - 0.0% 450,000 550,000 (100,000) -22.2% 450,000 122.2% Memberships 157,070 24,622 132,448 84.3% 628,279 503,607 124,672 19.8% 628,279 80.2% Training&Meetings 128,769 36,652 92,117 71.5% 515,075 98,523 416,552 80.9% 515,075 19.1% Miscellaneous Other 12,813 9,499 3,314 25.9% 51,250 26,400 24,850 48.5% 51,250 51.5% Total Other Expenses 298,651 70,772 227,879 76.3% 1,644,604 1,178,529 466,075 28.3% 1,644,604 71.7% Total Expenses $ 93,354,084 $ 94,S75,811 $ (1,221,726) -1.3% $ 161,466,338 $ 153,743,636 $ 7,722,702 4.8% $ 161,466,338 105.0% 9 1 P a g e September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 135 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 $ 766,097 $ 600,444 $ 165,652 21.6% $ 3,064,387 $ 2,701,585 $ 362,802 11.8% $ 3,064,387 88.2% Administration 76,208,591 77,373,119 (1,164,528) -1.5% 92,884,363 91,778,150 1,106,214 1.2% 92,884,363 98.8% Engineering and Technical Services 4,655,846 4,601,541 54,305 1.2% 18,623,383 15,218,868 3,404,515 18.3% 18,623,383 81.7% Operations 11,355,729 11,295,539 60,189 0.5% 45,422,914 42,007,324 3,415,590 7.5% 45,422,914 92.5% Recycled Water Program 367,823 705,167 (337,344) -91.7% 1,471,290 2,037,709 (566,419) -38.5% 1,471,290 138.5% Total Expenses $ 93,354,084 $ 94,575,811 $ (1,221,726) -1.3% $ 161,466,338 $ 153,743,636 $ 7,722,702 4.8% $ 161,466,338 95.2% Year-to-Date Expenses by Department $100,000,000 $90,000,000 $80,000,000 $70,000,000 $60,000,000 $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 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 136 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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($) (%) Budget Actual Variance($) (%) Budget (%) Executive Governance Office of the General Manager $ 375,395 $ 304,233 $ 71,162 19.0% $ 1,501,579 $ 915,313 $ 586,266 39.0% $ 1,501,579 61.0% Office of the Secretary of the District 249,695 238,208 11,487 4.6% 998,779 1,409,761 (410,982) -41.1% 998,779 141.1% Board of Directors 141,007 58,004 83,003 58.9% 564,029 376,511 187,518 33.2% 564,029 66.8% Administration Office of the Director of Finance and Administration 144,758 217,339 (72,581) -50.1% 579,032 676,634 (97,602) -16.9% 579,032 116.9% Finance Division 564,203 491,325 72,878 12.9% 2,256,811 1,884,569 372,241 16.5% 2,256,811 83.5% Human Resources Division 73,039,622 74,001,244 (961,622) -1.3% 79,758,488 79,836,768 (78,281) -0.1% 79,758,488 100.1% Purchasing Division 501,542 519,914 (18,372) -3.7% 2,006,169 1,607,713 398,456 19.9% 2,006,169 80.1% Risk Management Program 294,616 286,845 7,771 2.6% 1,628,463 1,504,444 124,019 7.6% 1,628,463 92.4% Public Info/Comm.Services&Intergov Relations Division 532,020 516,246 15,774 3.0% 2,128,081 1,835,412 292,669 13.8% 2,128,081 86.2% Information Technology Division 1,131,830 1,340,207 (208,377) -18.4% 4,527,320 4,432,609 94,711 2.1% 4,527,320 97.9% Engineering&Technical Services Office of the Director of Engineering& Technical Services 283,171 187,413 95,758 33.8% 1,132,683 652,931 479,752 42.4% 1,132,683 57.6% Division 1,861,941 1,643,987 217,955 11.7% 7,447,765 5,942,475 1,505,290 20.2% 7,447,765 79.8% Capital Projects Division 220,793 (92,131) 312,924 141.7% 883,170 (260,058) 1,143,228 129.4% 883,170 -29.4% Division 2,289,941 2,862,273 (572,332) -25.0% 9,159,765 8,883,520 276,245 3.0% 9,159,765 97.0% Operations Office of the Director of Operations 258,835 251,484 7,351 2.8% 1,035,340 467,139 568,201 54.9% 1,035,340 45.1% Collection System Operations Division 3,729,142 3,606,486 122,656 3.3% 14,916,566 13,666,685 1,249,881 8.4% 14,916,566 91.6% Treatment Plant Operations Division 3,452,883 3,481,613 (28,731) -0.8% 13,811,530 14,012,156 (200,626) -1.5% 13,811,530 101.5% Treatment Plant Maintenance Division 3,914,870 3,955,956 (41,086) -1.0% 15,659,478 13,861,344 1,798,134 11.5% 15,659,478 88.5% Recycled Water Recycled Water-General 40,925 65,435 (24,510) -59.9% 163,700 187,754 (24,054) -14.7% 163,700 114.7% Treatment Plant 176,975 363,709 (186,734) -105.5% 707,900 1,061,942 (354,042) -50.0% 707,900 150.0% Distribution System 78,588 106,456 (27,869) -35.5% 314,350 322,628 (8,278) -2.6% 314,350 102.6% Residential Fill Station 55,835 169,567 (113,732) -203.7% 223,340 460,310 (236,970) -106.1% 223,340 206.1% Satellite Water Facility 15,500 - 15,500 100.0% 62,000 5,074 56,926 91.8% 62,000 8.2% Total Expenses $ 93,354,084 $ 94,575,811 $ (1,221,726) -1.3% $ 161,466,338 $ 153,743,636 $ 7,722,702 4.8% $ 161,466,338 95.2% 11 � Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 137 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 $ 26,878,205 $ - $ (26,878,205) -100.0% $ 56,673,402 $ 30,156,394 $ (26,517,008) -46.8% $ 56,673,402 53.2% Other Capital Revenues 25,499,875 20,686,616 (4,813,260) -18.9% 38,279,500 33,801,530 (4,477,970) -11.7% 38,279,500 88.3% Total Revenue $ 52,378,080 $ 20,686,616 $ (31,691,465) -60.5% $ 94,952,902 $ 63,957,923 $ (30,994,979) -32.6% $ 94,952,902 67.4% Year-to-Date Revenues by Source $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■YTD ■YTD Budget Actual 12Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 138 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 $ 28,003 $ $ (28,003) -100.0% $ 112,000 $ 122,983 $ 10,983 9.8% $ 112,000 109.8% County Allocated 26,862,802 (26,862,802) -100.0% 55,939,802 29,060,466 (26,879,336) -48.1% 55,939,802 51.9% Direct Billed - - 672,000 981,123 309,123 46.0% 672,000 146.0% Prior Year Adjustment (12,600) 12,600 -100.0% (50,400) (8,178) 42,222 -83.8% (50,400) 16.2% Other Capital Revenues Facilities Capacity Fees-Gravity Zone 1,500,000 1,031,671 (468,329) -31.2% 6,000,000 5,223,516 (776,484) -12.9% 6,000,000 87.1% Facilities Capacity Fees-Pump Zone 65,500 56,489 (9,011) -13.8% 262,000 219,733 (42,267) -16.1% 262,000 83.9% Capacity Use Charge 25,500 - (25,500) -100.0% 102,000 57,067 (44,933) -44.1% 102,000 55.9% - - - 3,000 3,000 - Secured Property Tax 8,440,000 9,409,986 969,986 11.5% 15,940,000 17,697,471 1,757,471 11.0% 15,940,000 111.0% Investment Income 73,375 36,203 (37,172) -50.7% 293,500 245,740 (47,760) -16.3% 293,500 83.7% Other Government Revenue-Concord 15,300,000 10,064,155 (5,235,845) -34.2% 15,300,000 10,064,155 (5,235,845) -34.2% 15,300,000 65.8% Overtime Inspection 2,000 1,469 (532) -26.6% 8,000 9,120 1,120 14.0% 8,000 114.0% Plan Review 27,750 18,650 (9,100) -32.8% 111,000 109,672 (1,328) -1.2% 111,000 98.8% Main Lines Inspection Fees 65,500 70,882 5,382 8.2% 262,000 145,239 (116,761) -44.6% 262,000 55.4% Miscellaneous Income 250 - (250) -100.0% 1,000 1,124 124 12.4% 1,000 112.4% Contractual Assessment District - (5,890.00) (5,890) - 25,692.28 25,692 Total Revenues $ 52,378,080 $ 20,683,616 $ (31,694,465) -60.5% $ 94,952,902 $ 63,957,923 $ (30,994,979) -32.6% $ 94,952,902 67.4% 131Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 139 of 170 10ENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 I(G-H) Cumulative I Cumulative Total ProjectFY 2020-21 FY 2020-21 1 FY 2020-21 FY 2020-21 FY 2020-21 FY 2020-21 Prior Year Prior Year Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2020-21 Budget Adjustments Budget Expenditures Expenditures Budget Collection System(CS) $ 26,135,211 16,613,432 9,521,779 40,165,000 (879,221) 39,285,779 48,807,558 37,197,540 11,610,018 Treatment Plant(TP) 57,316,451 50,455,867 6,860,584 32,334,000 1,566,759 33,900,759 40,761,343 19,650,601 21,110,742 General Improvements(GI) 14,234,483 12,051,117 2,183,366 3,925,000 301,626 4,226,626 6,409,992 5,291,857 1,118,135 Recycled Water(RW) 9,186,894 7,180,857 2,006,037 9,500,000 67,602 9,567,602 11,573,639 8,300,198 3,273,441 CIB Contingency - - - 2,100,000 (1,056,766) 1,043,234 1,043,234 - 1,043,234 Total $ 106,873,039 $ 86,301,273 $ 20,571,766 $ 88,024,000 $ - $ 88,024,000 $ 108,595,766 $ 70,440,196 $ 38,155,570 Capital Improvement Budget Quarterly Results by Program $50,000,000 $45,000,000 $40,000,000 $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Collection Treatment Plant General Recycled Water CIB Contingency System(CS) (TP) Improvements (RW) (GI) Program ■Approved Expenditures ■Actual Expenditures 14Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 140 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 I G-H 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 Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2020-21 Budget Adjustments Budget Expenditures Expenditures Bud et TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 460,000 282,762 177,238 500,000 500,000 677,238 - 677,238 7367 Concord Main Metering Station 250,000 261,195 (11,195) - - (11,195) 591,649 (602,844) 8419 Collection System Planning LT 1,185,000 1,142,220 42,780 200,000 200,000 242,780 134,857 107,923 8436 Moraga/Crossroads PS Project 8,347,000 6,251,204 2,095,796 14,040,000 420,000 14,460,000 16,555,796 14,150,504 2,405,292 8442 PS Equipment Piping Replacement PH2 164,000 128,720 35,280 200,000 200,000 235,280 152,265 83,015 8443 LG Diameter Pipe line Inspection 765,000 86,282 678,718 530,000 530,000 1,208,718 81,927 1,126,791 8444 Force Main Inspection Program 125,000 2,791 122,209 500,000 500,000 622,209 12,734 609,475 8447 Pump Station Security Improvement 207,000 - 207,000 75,000 75,000 282,000 - 282,000 8448 Manhole Modifications 1,207,925 1,207,925 - 400,000 400,000 400,000 151,150 248,850 8449 Collection System Modeling Support 303,000 142,993 160,007 120,000 120,000 280,007 13,154 266,853 8450 Development Sewerage Support 2,232,316 2,233,146 (830) 900,000 900,000 899,170 904,182 (5,012) 8451 C.S.Sewer Renovation 535,527 - 535,527 4,027,000 4,027,000 4,562,527 576,878 3,985,649 8457 Pump Station Upgrades-Ph.2 550,000 406,950 143,050 2,400,000 2,400,000 2,543,050 1,929,414 613,636 8458 Martinez Sewer Renov.Ph.6 600,000 584,406 15,594 4,500,000 (630,000) 3,870,000 3,885,594 3,665,295 220,299 8459 Lafayette Sewer Renov.Ph.14 600,000 491,002 108,998 4,600,000 (1,000,000) 3,600,000 3,708,998 3,362,734 346,264 8460 WC Sewer Renov.Ph.14 600,000 726,465 (126,465) 4,573,000 4,573,000 4,446,535 4,155,140 291,395 8461 So.Orinda Sewer Ren.Ph.8 600,000 536,740 63,260 - - 63,260 2,372,330 (2,309,070) 8463 No.Orinda Sewer Renov.PH.8 500,000 - 500,000 - - 500,000 472,342 27,658 8464 Martinez Sewer Renov.Ph.7 500,000 - 500,000 - - 500,000 296,826 203,174 8465 WC Sewer Renov.Ph.15 500,000 - 500,000 - - 500,000 527,035 (27,035) 8466 Danville Sewer Ren.Ph.4 500,000 - 500,000 - - 500,000 202,056 297,944 100005 Cured-In-Place Pipe Contract FY 2020-25 - - - 600,000 600,000 600,000 - 600,000 100006 Contractual Assessment District Proj Financin; - - - 500,000 500,000 500,000 - 500,000 100007 Large Diameter Priping Renovation Program - - - 1,500,000 1,500,000 1,500,000 - 1,500,000 **100017 SR Pump Station Electrical Upgrades - - - - 180,000 180,000 180,000 31,479 148,521 Year end Substantially complete-balance transferred to contingency *6534 Harper Lane Area CAD 800,000 630,606 169,394 - (139,630) (139,630) 29,764 17,764 12,000 Year end close outs-balance transferred to contingency *6679 Coredell Drive CAD 123,443 74,406 49,037 - (49,037) (49,037) - - - 8456 Danville Sewer Ren.Ph.3 4,280,000 1,246,124 3,033,876 - (27,049) (27,049) 3,006,827 3,006,827 - 8462 SR Pumping Station Flow Diversion 200,000 177,495 22,505 - 2,089 2,089 24,594 24,592 2 **100020 EI Toyonal Sewer Relacement - - - - 364,406 364,406 364,406 364,406 - Rounding Total CS Program $ 26,135,211 16,613,432 9,521,779 40,165,000 (879,221) 39,285,779 48,807,558 37,197,540 11,610,018 151Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 141 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 I G-H 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 Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2020-21 Budget Adjustments Budget Expenditures Expenditures Budget TYPE TP Treatment Plant 7304 Instr&Controls PLC Upgrade 500,000 477,709 22,291 120,000 120,000 142,291 36,250 106,041 7315 Applied Research and Innovations 857,274 355,560 501,714 500,000 500,000 1,001,714 120,480 881,234 7328 Influent Pump Electrical improvements 1,410,000 1,532,562 (122,562) 3,500,000 3,500,000 3,377,438 2,920,941 456,497 7339 T.Plant Control System 1/0 Replacement 2,470,000 1,514,443 955,557 1,000,000 1,000,000 1,955,557 1,600,670 354,887 7341 WC/Grayson Creek Levee Rehab 300,000 285,097 14,903 250,000 250,000 264,903 (147,257) 412,160 7348 Solids Handling Facility Improvements 15,984,000 12,967,778 3,016,222 4,000,000 (2,865,313) 1,134,687 4,150,909 2,712,111 1,438,798 7349 Aeration&Energy Upgrade 5,000,000 2,740,289 2,259,711 2,550,000 (1,950,000) 600,000 2,859,711 1,488,506 1,371,205 7352 UV Disinfection Upgrades 1,100,000 716,324 383,676 250,000 250,000 633,676 33,418 600,258 7353 outfall Improvements Ph.7 920,000 611,317 308,683 5,100,000 (100,000) 5,000,000 5,308,683 5,054,035 254,648 7354 TP Security Improvements 705,000 192,270 512,730 550,000 550,000 1,062,730 (1,118) 1,063,848 7355 Odor Control Upgrade Ph.1 - - - 300,000 300,000 300,000 - 300,000 7357 Plant Wide Instrumentation Upgrade 740,000 110,485 629,515 281,000 281,000 910,515 - 910,515 "7360 Existing Plant Facility Drawing 300,000 206,738 93,262 - - 93,262 96,988 (3,726) 7363 Treatment Plant Planning 1,400,000 1,099,028 300,972 400,000 400,000 700,972 264,945 436,027 7364 TP Safety Enhancement Ph.5 1,180,000 41,095 1,138,905 - - 1,138,905 1,106,364 32,541 7369 Piping Renovation-Phase 10 750,000 47,578 702,422 2,500,000 2,500,000 3,202,422 619,835 2,582,587 7370 Annual Infrastructure Replacement 2,000,000 584,997 1,415,003 1,000,000 (650,000) 350,000 1,765,003 599,930 1,165,073 7371 Condition Assessment of Buried Pipelines 250,000 - 250,000 250,000 250,000 500,000 - 500,000 7373 Fire Protection System Ph.3 200,000 176,945 23,055 450,000 450,000 473,055 42,918 430,137 7375 Contractor Staging Improvements 150,000 16,086 133,914 2,550,000 800,000 3,350,000 3,483,914 607,321 2,876,593 100001 UPCAA Urgent Projects FY 2020-25 - - - 600,000 600,000 600,000 157,502 442,498 100008 Laboratory Roof&Seismic upgrades - - - 500,000 500,000 500,000 - 500,000 100009 Hearth Replacement - - - 500,000 500,000 500,000 - 500,000 100010 Air Condiditioning&Lighting Renovation - - - 750,000 750,000 750,000 266 749,734 100011 Plant Electrical Replacement&Rehabilitation - - - 400,000 400,000 400,000 7,916 392,084 100012 UV Disinfection Replacement - - - 500,000 500,000 500,000 193,232 306,768 100013 W Hydraulic Improvements - - - 480,000 480,000 480,000 5,480 474,520 161Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 142 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 Carryforward to Adopted Budget Adjusted Approved Actual Remaining Bud ets Actuals FY 2020-21 Budget Adjustments Budget Expenditures Expenditures Budget 100014 MRC Building Modifications - - - 450,000 450,000 450,000 978 449,022 **100015 Electric Blower Improvements - - - - 1,750,000 1,750,000 1,750,000 916,828 833,172 **100018 Outfall Monitoring Improvements - - - - 100,000 100,000 100,000 13,214 86,786 **100019 Aeration Basins Diffuer Replacement and Seisn - - - - 200,000 200,000 200,000 15,097 184,903 **100022 Wet Weather Basin Improvements - - - - 200,000 200,000 200,000 178,085 21,915 Year end close outs-balance transferred to contingency *6172 Sludge Blending Tank Repair 776,000 674,408 101,592 - (106,461) (106,461) (4,869) (4,870) 1 7317 Plant Control System Network Upgrades 885,000 869,250 15,750 - 31,458 31,458 47,208 47,209 (1) 7322 Fire Protection System Ph.2 1,406,000 1,406,958 (958) - 20,173 20,173 19,215 19,209 6 7362 POB Seismic Upgrades 6,589,177 6,718,706 (129,529) - 150,567 150,567 21,038 21,031 7 Year end close outs-balance transferred frm 7348 7376 Emergency Sludge Loadout Facility - 2,864,063 (2,864,063) - 2,865,313 2,865,313 1,250 1,251 (1) Year end close outs-Transler from Contingency&frm 7370 7351 Mechanical&Concrete Renovation 11,444,000 14,246,181 (2,802,181) 2,603,000 1,121,022 3,724,022 921,841 921,836 5 Rounding Total TP Program $ 57,316,451 $ 50,455,867 $ 6,860,584 $ 32,334,000 $ 1,566,759 $ 33,900,759 $ 40,761,343 $ 19,650,601 $ 21,110,742 *Italic Projects open but not inCIBfor20/21 TBD New Projects in FY 2020-21 TYPE GI General Improvements 8230 Capital Legal Services 198,665 170,061 28,604 10,000 10,000 38,604 28,970 9,634 8236 District Easements 333,047 242,165 90,882 75,000 75,000 165,882 14,769 151,113 8240 IT Development 3,238,794 2,940,850 297,944 500,000 500,000 797,944 771,053 26,891 8250 ERP Replacement 3,705,000 2,449,455 1,255,545 1,200,000 125,000 1,325,000 2,580,545 2,739,651 (159,106) 8251 Capital Imprvmt Program&Budget Imprvmt 350,000 97,048 252,952 140,000 140,000 392,952 26,976 365,976 *8252 POB E.V.Charging Station 30,000 21,749 8,251 - - 8,251 - 8,251 *8253 COVID-19 Response 200,000 - 200,000 - - 200,000 97,655 102,345 8516 District Equipment Acquisition 976,000 1,051,397 (75,397) 250,000 250,000 174,603 192,973 (18,370) 8517 Vehicle Replacement Program 2,918,000 2,514,262 403,738 900,000 900,000 1,303,738 1,201,812 101,926 100003 Property Repairs&Improvements - - - 300,000 300,000 300,000 156,418 143,582 100004 HOB Exterior Repairs - - - 350,000 350,000 350,000 24,107 325,893 9999 Cap.Proj.Clearing(Acctng.Use Only)** - (60,000) 60,000 - - 60,000 - 60,000 Year end close outs-balance transferred to contingency 8207 General Security and Access 284,977 192,360 92,617 200,000 (277,027) (77,027) 15,590 15,590 - 8243 Server Room Relocation 2,000,000 2,431,770 (431,770) - 453,653 453,653 21,883 21,883 - Rounding Total GI Program $ 14,234,483 12,051,117 2,183,366 3,925,000 301,626 4,226,626 6,409,992 5,291,857 1,118,135 *Italic Projects open but not in ClBfor 20121 TBD New Projects in FY 2020-21 171Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 143 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 I G-H 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 Carryforward to Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2020-21 Budget Adjustments Budget Expenditures Expenditures Budget TYPE RW Recycled Water 7306 Zone 1 Recycled Water 632,894 559,616 73,278 100,000 - 100,000 173,278 72,255 101,023 7361 Filter Plant&Clearwell Improvements Ph.1A 5,989,000 4,755,152 1,233,848 9,000,000 - 9,000,000 10,233,848 8,068,424 2,165,424 7366 ReW Distribution System Renov.Program 515,000 15,996 499,004 - - - 499,004 99,873 399,131 7368 Water Exchange Project 350,000 82,780 267,220 - - - 267,220 59,357 207,863 100002 Filter Plant&Clearwell Improvements Ph.16 - - - 400,000 - 400,000 400,000 - 400,000 Year end close outs-balance transferred to contingency 7365 Recycle Water Clearwell Repairs 1,700,000 1,767,313 (67,313) - 67,602 67,602 289 289 - RoundinQ Total RW Program $ 9,186,894 7,180,857 2,006,037 9,500,000 67,602 9,567,602 11,573,639 8,300,198 3,273,441 TBD New Projects in FY 2020-21 9990 CONTINGENCY-ALL PROGRAMS 2,100,000 (1,056,766) 1,043,234 1,043,234 1,043,234 GRAND TOTAL $ 106,873,039 86,301,273 20,571,766 88,024,000 - 88,024,000 108,595,766 70,440,196 38,155,570 18 � Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 144 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 (%) Subrogation Recoveries $ $ 8,300 $ 8,300 $ - $ 15,158 $ 15,158 $ - Contribution From 0&M - - 450,000 550,000 100,000 22.2% 450,000 122.2% Insurance Recoveries(HHV) 5,000 21,714 16,714 334.3% 20,000 21,714 1,714 8.6% 20,000 108.6% Investment Income 28,013 6,784 (21,228) -75.8% 112,050 42,203 (69,847) -62.3% 112,050 37.7% Total Revenues $ 33,013 $ 36,798 $ 3,786 11.5% $ 582,050 $ 629,075 $ 47,025 8.1% $ 694,100 90.6% Year-to-Date Revenues by Source $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 Subrogation Recoveries Contribution From 0&M Insurance Recoveries(HHW) Investment Income Revenue Source Category ■YTD ■YTD Budget Actual 19Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 145 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 $ 20,000 $ 67,315 $ (47,315) -236.6% $ 80,000 $ 184,358 $ (104,358) -130.4% $ 80,000 230.4% Technical Services 22,500 8,089 14,411 64.0% 90,000 16,281 73,719 81.9% 90,000 18.1% Cleaning - - - - 64,492 (64,492) - Insurance&Risk Management 245,875 925,010 (679,135) -276.2% 983,500 1,130,011 (146,511) -14.9% 983,500 114.9% Total Expenses $288,375 $ 1,000,414 $ (712,039) -246.9% $ 1,153,500 $ 1,395,142 $ (241,642) -20.9% $ 1,153,500 82.7% Year-to-Date Expenses by Type $1,200,000 $1,000,000 $800,000 $600,000 f $400,000 � $200,000 Mill Professional Services Technical Services Cleaning Insurance&Risk Management Expense Category ■YTD ■YPD Budget Actual 20Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 146 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 $ 1,132,922 $ (6,394) $ (1,139,316) -100.6% $ 2,517,605 $ 2,511,211 $ (6,394) -0.3% $ 2,517,605 Investment Income - 11,194 11,194 11,194 11,194 Total Revenues $ 1,132,922 $ 4,800 $ (1,128,122) -99.6% $ 2,517,605 $ 2,522,405 $ 4,800 0.2% $ 2,517,605 100.2% Year-to-Date Revenues by Source $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 Tax Revenue Investment Income ■ YTD ■ YTD Budget Actual 21Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 147 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 6 - Debt Service Fund Expenses by Type Annual QTD YTD Budget QTD QTD QTD Variance YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance($) (%) Budget Actual Variance($) (%) Estimate (%) Interest Expense $ 294,969 $ 34,392 $ (260,577) -88.3% $ 777,605 $ 542,226 $ (235,379) -30.3% $ 777,605 143.4% Other Debt Issuance Costs - 240,179 240,179 - 240,179 240,179 - Total Expenses $ 294,969 $ 274,571 $ (20,398) -6.9% $ 777,605 $ 782,405 $ 4,800 0.6% $ 777,605 100.6% Year-to-Date Expenses by Type $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 Interest Expense Other Debt Issuance Costs ■YTD ■YTD Budget Actual 22Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 148 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 7 - Quarterly Investment Portfolios Operating& Maintenance Fund QTD YTD Purchase Maturity Daysto Annual Cash BOQ Purchase EOQ EOQ %of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif LAIF n/a n/a n/a (1) $ 21,100,000 $ 36,100,000 $ (15,000,000) $ 21,100,000 $ 21,137,501 100.00% $ 16,123 $ 131,775 (3) $ 21,100,000 $ 36,100,000 $(15,000,000) $ 21,100,000 $ 21,137,501 100.00% 16,123 131,775 (2) (4) (8) 2,212 13,377 $ 18,335 $ 145,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 June,2021 was 0.260%. (2)The face value indicates the value of the investment if held until maturity,which is the usual District Practice. (3)The weighted average yield of the total Running Expense portfolio is 0.260%.As the District is a voluntary participant in the County Treasury Pool,this calculation excludes investments purchased after the 15th day of the month,which is the cut-off for month-end reporting by Contra Costa County. (4)The market value of the portfolio on June 30,2021 was$21,137,501.GASB 31 requires adjusting investments to market value.The District will adjust annually,but report market values quarterly. (5)All investments held by the Running Expense Fund comply with Central San's investment policy approved by the Board of Directors[California Government Code§53646(b)(2)] (6)Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Running Expense fund for the next six(6)months[California Government Code§53646(5)(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 be included in the following month's report. 231Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 149 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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) $ 1,000,000 $ 25,300,000 $ (24,300,000) $ 1,000,000 $ 1,001,777 3.85% $ 16,284 $ 149,735 956 US T Bill US Treasury Bill 1/7/2021 4/7/2021 0 0.081 24,994,944 25,000,000 (25,000,000) - - 0.00% 389 5,056 957 FHLB US Fed Agency 3/26/2021 6/18/2021 0 0.015 19,999,300 20,000,000 (20,000,000) - - 0.00% 50 700 958 US T Bill US Treasury Bill 4/9/2021 7/15/2021 75 0.010 24,999,326 25,000,000 25,000,000 24,999,326 96.15% 576 576 (3) _LI1293 _L10.300 $(44.300.0001 _L16,000.000 $ 26,001,103 100.00% 17,299 156,067 (2) (4) (8) 20,089 32,738 $ 37,388 $ 188.805 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,2021 was 0.260%. (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.123%.The weighted average maturity is.04 years.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,2021 was$26,001,104.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(6)(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(6)(3)] (7)Of the total investments held in the Sewer Construction Fund,$1,000,000 is restricted for the Rate Stabilization Reserve Account. 241Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 150 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 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 10799- n/a n/a (1) $ 7,600,000 $ 7,600,000 $ 7,600,000 $ 7,613,507 100.00% $ 5,807 $ 38,785 (3) $ 7,600,000 $ 7,600,000 $ $ 7,600,000 $ 7,613,507 100.00% 5,807 38,785 (2) (4) (7) 1,549 3,238 $ 7,356 $ 42,023 Legend: EOQ=End of quarter B 0 Q=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,2021 was 0.260%. (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.260%. (4)The market value of the portfolio on June,2021 was$7,613,507. (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(6)(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. 251Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 151 of 170 10ENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 8 - Financial Performance Metric Charts O&M Fund Cashflow Forecast FY 2020-21 Running Expense Fund Total Cash & Investment Balances (Actuals through June 2021) $70'0 $65.9 $61.2 $60.0 – $53.0 $49.8 $50.0 $46.0 $43.3 $42.2 $39.1 $38.4 $41.5 $40 0 $38.5 $38.5 38.7 37.8 r$37.5 $33.9 $34.8 $34.2, $29.3 $28.7 $31.7$29.6 $30.0 – $2s.o� $zs.l 2 $24.7 $25.0 $20.0 $10.0 $0.0 June '20 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 2020 based on budgeted revenues and expenses for FY 2020-21 and applied to the actual balance at June 30,2020 **The Reserve Target at Year End is the minimum balance required at June 30,2021 to comply with the District Policy 261Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 152 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast FY 2020-21 Sewer Construction Fund Total Cash & Investment Balances (Actuals through June 2021) $90.9 $90.0 $87.5 $87.0 $848 $80.0 $80.0 76.8 $79.1� $76.9 $76.0 $73.8 "73.1 $71.8 1$32.0 1.1 $70.4 $70.0 $68.1 $66.1 $68.6 66.0 $66.1 $60.3 $60.7 $60.0 $58.6 56.0 $52. $52.4 $53.9 $50.0 $40.0 .1 $30.0 $20.0 $10.0 $0.0 June'20 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 2020 based on budgeted revenues and expenses for FY 2020-21 and applied to the actual balance at June 30,2020 **The Reserve Target at Year End is the minimum balance required at June 30,2021 to comply with the District Policy 271 Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 153 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 8 - Financial Performance Metric Charts Staffing Trends 300 4.8%vacancy Rate 295 290 14 EZ. 2857 16 18 v 280 iz 275 w a) 270 278 265 273 274 274 260 255 mi 1`10 250 6/30/18 6/30/19 6/30/20 6/30/21 Quarter Ended ■Filled Positions(FTEs) ■Vacancies(FTEs) 28Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 154 of 170 'Ami'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 8 - Financial Performance Metric Charts Cost per Million Gallons of Wastewater Treated Historical Quarterly O&M Cost per Million Gallons Treated $5,000 $3,887 $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/18 6/30/19 6/30/20 6/30/21 Fourth Quarter of Fiscal Year *Excludes non-recurring URAL payoff of$70.8 million in]une 2021 29Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 155 of 170 10ENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 8 - Financial Performance Metric Charts Capital Spending Trend $120 $108.6 $100 $80 $97.7 0 $60 $70.4 $40 $20 - - �.�`j Pa�O`as� SeQtiect`be� � o06 Projected(100%spend) Actual 90%Target 301Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 156 of 170 'dryt'CENTRAL SAN 5019 IMHOFF PLACE,MARTINEZ,CA 94553-4392 Budget-to-Actual Financial Report Quarter Ending June 30, 2021 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed/ Renovated 4.0 3.4 3.5 d 3.0 2.5 2.2 N 2.5 � 2.0 1.8 2.0 1.7 o. w 0 1.5 iv 1.0 jO. 0.5 0.5 0.0 A Ig0�ti0 1'LI31I�'� 3Ig1�ti1 6I30Iti1 Quarter Ending ■Actual Construction ■Target("S-Curve"of 6 mi.FY 20-21 Budget Projection) 31Page September 28, 2021 Regular FINANCE Committee Meeting Agenda Packet- Page 157 of 170