The URL can be used to link to this page

Home My WebLink About04.c. Receive Quarterly Financial Review for quarter ended December 31, 2021Page 1 of 34 Item 4.c. F--1-448�411C-S0 February 22, 2022 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 QUARTERLY FINANCIAL REVIEW FOR QUARTER ENDED DECEMBER 31, 2021 Attached is the Quarterly Financial Review for the second quarter of Fiscal Year (FY) 2021-22 ending December 31, 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 - December 31, 2021 February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 92 of 202 Quarterly Financial Review CENTRAL SAN J' i i� i •_�� Ili ■A Ended December 31, 2021 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 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 February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 94 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 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 Sewer Construction Fund Cashflow Forecast...........................................................................................................................................................................26 StaffingTrends.......................................................................................................................................................................................................................................27 Cost per Million Gallons of Wastewater Treated.....................................................................................................................................................................28 CapitalSpending Trend......................................................................................................................................................................................................................29 Milesof Pipeline Constructed/Renovated..................................................................................................................................................................................30 February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 95 of 202 Ogn CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 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 second quarter of FY 2021-22 ended December 31, 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 second quarter show total expenditures are $36.3 million, which is approximately $2.8 million (7.3%) under the projected year-to-date budget. This favorable expense variance is smaller than the favorable year-to-date budget variance reported in the second quarter of the prior year of 12.7% and is largely attributable to lower than projected year-to-date spending in the purchased professional, technical and other 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.2%, with the budget assuming 3.0%. The largest individual expense category budgetary variance is in the purchased professional, technical and other services category, which is reporting a favorable variance of approximately $1.1 million. In the aggregate, the 0&M Fund is reporting a modest favorable revenue variance of approximately $1.1 million, which is approximately 2.0% above total estimated year-to-date revenues. The primary driver for this overall revenue variance is sewer service charges received from the county and the direct bills being higher than anticipated through the second 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 second quarter show total capital project expenditures of $33.9 million, or 50.7% of the total estimated year-to-date budget of $66.8 million developed using historical spending trends over the past three years. 11Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 96 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 1 -Executive Summary While the Sewer Construction fund's FY 2021-22 adopted budget was $108.0 million, when including roll-over capital project appropriations from the prior year of $37.9 million the total adjusted budget for FY 2021-22 is $145.9 million. After factoring in the roll-over, the year-to-date capital spending rate is 23.3% of total approved expenditures. The adopted FY 2021-22 capital improvement budget assumed the large Solids Handling Project would proceed as planned. However, the transition to using digesters for solids handling as opposed to continuing the existing incineration methodology, approved by the Board in the Fall of 2021, will have significant impacts to project scope and timeline, not reflected in the adopted FY 2021-22 capital improvement budget. Currently, staff projects this change will result in a reduction to FY 2021-22 capital spending by approximately $20 million. The bulk of the FY 2021-22 year-to-date capital spending budget variance is in the Treatment Plant program (85.1%) followed by the Collection System program (63.9%), attributable to various project as shown in pages 15 through 17 of this report. On the revenue side, the Sewer Construction Fund is currently reporting revenues of $12.8 million, reflecting a favorable year- to-date variance of $0.1 million (1.1.%). This modest favorable revenue variance, largely in line with year-to-date budget projections is mostly attributable to secured property tax revenues, offset to a large extent by a negative revenue variance in facilities capacity fees which are estimated evenly on a straight-line basis across the fiscal year due to their interim receipt timing being difficult to predict. It is projected that the property tax will continue to remain slightly higher than budget closing the fiscal year approximately 2.0% ($0.4 million) over budget. Investment Portfolio Highlights In accordance with Section 53646 of the California Government Code as well as Central San's Investment Policy, the Finance Division is required to submit an investment report to the General Manager and Board of Directors at least quarterly. The investments held by Central San for the quarter ended December 31, 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. 2 1 P a g e February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 97 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 1 -Executive Summary Through the second quarter of FY 2021-22, the 0&M Fund has generated Investment Income of $22,621 which is below the year-to-date revenue estimate of $42,000 by 46.1%. The Sewer Construction Fund is reporting Investment Income of $43,910 (includes CAD/AVAD interest), coming in well below the year-to-date revenue estimate of $1S9,S00 by 72.S%. These unfavorable variances are directly attributable to interest rates on permitted investments continuing to report historically low yields through the first half of the fiscal year as well as a significant portion of Sewer Construction Fund reserves being temporarily used to assist with the payoff of the pension plan's unfunded actuarial accrued liability (UAAL) with CCCERA financing a short-term interfund borrowing to the 0&M fund in June 2021. The proceeds from the issuance of the June 2021 Certificates of Participation of $S8.0 million have been reimbursed from the debt service fund to the sewer construction fund as eligible capital expenditures are incurred. As of December 31, 2021, Central San continues to hold the bulk of its investment portfolio, or $60.2 million, in the Local Agency Investment Fund (LAIF) state investment pool, under the maximum amount permitted to be held in the pool of $7S million. With signs in early 2022 indicating a gradual increase in interest rates, staff has begun researching investment alternatives such as short-term United States Treasury Bills, corporate notes, and short- term fixed income instruments as well as developing an investment maturity ladder in order to diversify its portfolio and take advantage of rising interest rates expected for the remainder of the fiscal year. While staff does intend to explore investment alternatives, it is stressed that given the restricted nature of municipal investing, additional efforts are not expected to yield significant results to Central San's bottom line, with the 0&M investment earnings contributing less than 0.02% to total budgeted revenues for FY 2021-22. Central San's investment portfolio is in compliance with the Board's adopted policy regarding investments as of the quarter ended December 31, 2021. Furthermore, as a statement of compliance, Central San is expected to meet expenditure requirements for the next six (6) months from a combination of maturing investments and FY 2021-22 budgeted revenues. 3 1 P a g e February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 98 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 $ 55,250,683 $ 56,360,973 1,110,290 2.0% $ 116,681,763 48.3% Sewer Construction 12,665,235 12,800,056 134,821 1.1% 32,243,421 39.7% Self Insurance 1,613,919 1,584,434 (29,485) -1.8% 1,651,419 95.9% Debt Service 7,090,082 6,985,671 (104,411) -1.5% 12,891,059 54.2% Total $ 76,619,919 $ 77,731,134 $ 1,111,215 $ 163,467,662 Fund Expenses 0&M $ 39,170,836 $ 36,322,289 2,848,546 7.3% $ 79,520,131 45.7% Sewer Construction 66,843,128 33,936,069 32,907,059 49.2% 145,896,673 23.3% Self Insurance 617,500 893,126 (275,626) -44.6% 1,285,000 69.5% Debt Service 372,948 126,516 246,432 66.1% 2,441,059 5.2% Total $ 107,004,412 $ 71,278,000 $ 35,726,412 $ 229,142,863 YTD Budget -to -Actual Revenues by Fund $fi0p00,000 M000— $40,000,000 $30,000,000 Szo,000,00o r I 8lopoo,o00 L 0&M sewer CansWRion selflnsUr DeMService Fund •YTD •YTD Budges Actual 4 1 P a g e $)0,000.000 $fi0,000,000 $50,000,000 840,000,000 $30,000,000 Szo,o"o00 $10,000,OOo $- 0&h1 YTD Budget -to -Actual Expenses by Fund Sewer ConsVURion Selflnsurance DeM Service Fund •YTD •Y D Budget Actual February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 99 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 ($1 Variance ("/o) Budget Realized (%) Operating Revenues: Sewer Service Charge Revenue $ 53,366,824 $ 54,483,346 $ 1,116,521 2.1% $ 53,406,983 $ 54,678,785 $ 1,271,802 2.4% $ 96,331,829 56.8% Sewage Treatment Cost Sharing - - - - (47,960) (47,960) 15,445,534 -0.3% Miscellaneous Service Charge 239,250 280,755 41,505 17.3% 478,500 489,996 11,496 2.4% 2,078,000 23.6% Non -Operating Revenues: Permit and Inspection Fees 473,600 498,286 24,686 5.2% 947,200 900,443 (46,757) -4.9% 1,894,400 47.5% Other Non Operating Income 188,000 116,409 (71,591) -38.1% 376,000 317,087 (58,913) -15.7% 752,000 42.2% Investment Income 25,500 12,546 (12,954) -50.8% 42,000 22,621 (19,379) -46.1% 180,000 12.6% Total Revenue $ 54,293,174 $ 55,391,341 $ 1,098,167 2.0% $ 55,250,683 $ 56,360,973 $ 1,110,290 2.0% $ 116,681,763 48.3% Year -to -Date Revenues by Source $60,000,000 $50,000,000 $40,000,000 •' $30,000,000 $20,000,000 $10,000,000 Sgro6er Service Charge Revenue Sewage Treatment Cost Miscellaneous Service Charge Permit and Inspection Fees Other Non Operating Income Investment Income $(10,000,000) ' Sharing Revenue Source Category ■ YTD ■ YTD Budget Actual 5 1 P a g e February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 100 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Revenues by Source - Detail Level QTD Category Budget Sewer Service Charge Revenue Budget -to -Actual Financial Report Quarter Ending December 31, 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 Sewer Service Charge Counter $ 55,776 $ 76,099 $ 20,322 36.4% $ 111,552 $ 233,385 $ 121,832 109.2% $ 223,105 104.6% Sewer Service Charge County 52,365,535 52,638,139 272,604 0.5% 52,365,535 52,638,139 272,604 0.5% 95,210,064 55.3% Sewer Service Charge Direct 961,131 1,769,108 807,977 84.1% 961,131 1,769,108 807,977 84.1% 961,131 184.1% Sewer Service Charge Prior (15,618) - 15,618 -100.0% (31,236) 38,153 69,388 -222.1% (62,471) -61.1% Sewage Treatment Cost Sharing - - - - (47,960) (47,960) 15,445,534 -0.3% Miscellaneous Service Charges Septic Tank Dumping 9,500 8,256 (1,244) -13.1% 19,000 21,288 2,288 12.0% 38,000 56.0% Sales 250 - (250) -100.0% 500 - (500) -100.0% 1,000 0.0% Other Service Charges - 156 156 - 156 156 240,000 0.1% Recycled Water 108,000 116,417 8,417 7.8% 216,000 300,847 84,847 39.3% 432,000 69.6% Satellite Water Recycling - - - - - - - Stormwater Program 97,500 121,813 24,313 24.9% 195,000 121,813 (73,187) -37.5% 390,000 31.2% Household Hazardous Waste 24,000 34,113 10,113 42.1% 48,000 45,893 (2,107) -4.4% 977,000 4.7% Permit & Inspection Fees Permit/Application Fees 135,000 128,870 (6,130) -4.5% 270,000 245,528 (24,472) -9.1% 540,000 45.5% Overtime Inspection 3,600 3,805 205 5.7% 7,200 4,870 (2,330) -32.4% 14,400 33.8% Side Sewer Inspection 292,500 311,858 19,358 6.6% 585,000 594,516 9,516 1.6% 1,170,000 50.8% Industrial Permit Fees 26,250 39,363 13,113 50.0% 52,500 39,363 (13,137) -25.0% 105,000 37.5% New Industry Permit Fees 3,750 1,736 (2,014) -53.7% 7,500 3,512 (3,988) -53.2% 15,000 23.4% Annexation Charges 12,500 12,654 154 1.2% 25,000 12,654 (12,346) -49.4% 50,000 25.3% Other Non -Operating Income MVSD P2 Program 6,250 6,591 341 5.5% 12,500 6,591 (5,909) -47.3% 25,000 26.4% Pretreatment Program Fine 500 2,000 1,500 300.0% 1,000 2,000 1,000 100.0% 2,000 100.0% Rebates to District - - - - - - - Lease Rental Income 178,750 127,504 (51,246) -28.7% 357,500 308,460 (49,040) -13.7% 715,000 43.1% Miscellaneous Income 2,500 (26,473) (28,973) -1158.9% 5,000 (10,542) (15,542) -310.8% 10,000 -105.4% Right of Way Fees - 6,787 6,787 - 10,579 10,579 - Contractual Assessment Dist - - - - - - - Investment Income 25,500 12,546 (12,954) -50.8% 42,000 22,621 (19,379) -46.1% 180,000 12.6% Total Revenues $ 54,293,174 $ 55,391,341 $ 1,098,167 2.0% $ 55,250,683 $ 56,360,973 $ 1,110,290 2.0% $ 116,681,763 48.3% 6 1 P a g e February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 101 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 ($) (0/0) Budget Actual Variance ($) (0/0) Budget (%) Salaries & Wages $ 10,522,970 $ 10,237,636 $ 285,334 2.7% $ 19,670,203 $ 18,761,547 $ 908,656 4.6% $ 39,711,391 47.2% Employee Benefits 3,015,236 3,048,554 (33,318) -1.1% 5,996,230 6,018,708 (22,478) -0.4% 12,688,724 47.4% Unfunded Liability Costs 642,665 954,733 (312,068) -48.6% 1,283,143 1,328,895 (45,752) -3.6% 2,566,845 51.8% Purchased Property Services 1,480,960 1,744,296 (263,336) -17.8% 2,961,920 2,796,333 165,587 5.6% 5,926,840 47.2% Other Purchased Services 2,107,730 976,563 1,131,167 53.7% 3,608,770 1,583,422 2,025,348 56.1% 6,934,841 22.8% Supplies & Materials 2,550,508 2,522,516 27,993 1.1% 5,090,017 5,175,038 (85,021) -1.7% 10,512,734 49.2% Other Expenses 285,989 200,049 85,940 30.1% 560,553 658,346 (97,793) -17.4% 1,178,756 55.9% Total Expenses $ 20,606,058 $ 19,684,346 $ 921,712 4.5% $ 39,170,836 $ 36,322,289 $ 2,848,546 7.3% $ 79,520,131 45.7% Year -to -Date Expenses by Type $20,000,000 $10,000,000 i916P 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 February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 102 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 $ 9,696,276 $ 9,568,495 $ 127,781 1.3% $ 18,015,830 $ 17,638,012 $ 377,818 2.1% $ 36,384,957 48.5% Temporary Pay 330,074 - 330,074 100.0% 692,186 - 692,186 100.0% 1,345,210 0.0% Premium Pay 808,058 653,146 154,912 19.2% 1,585,062 1,095,323 489,739 30.9% 3,174,574 34.5% Board Fees 13,663 16,280 (2,617) -19.2% 27,325 28,490 (1,165) -4.3% 54,650 52.1% Other (325,100) (285) (324,815) 99.9% (650,200) (278) (649,922) 100.0% (1,248,000) 0.0% Total Salaries & Wages 10,522,970 10,237,636 285,334 2.7% 19,670,203 18,761,547 908,656 4.6% 39,711,391 47.2% Employee Benefits Insurance Premiums 1,858,796 1,836,552 22,244 1.2% 3,689,002 3,614,747 74,255 2.0% 7,825,569 46.2% Employer Taxes 155,996 166,616 (10,620) -6.8% 292,455 308,843 (16,388) -5.6% 589,461 52.4% Employer Retirement Contributions 1,884,759 1,943,974 (59,215) -3.1% 3,594,663 3,643,268 (48,605) -1.4% 7,449,694 48.9% OPEB Contributions 515,000 547,500 (32,500) -6.3% 1,030,000 1,104,611 (74,611) -7.2% 2,060,000 53.6% Benefit Adjustments (1,399,316) (1,446,088) 46,772 -3.3% (2,609,890) (2,652,761) 42,871 -1.6% (5,236,000) 50.7% Total Employee Benefits 3,015,236 3,048,554 (33,318) -1.1% 5,996,230 6,018,708 (22,478) -0.4% 12,688,724 47.4% Unfunded Liability Costs Pension 327,665 14,735 312,930 95.5% 653,143 73,897 579,246 88.7% 1,306,845 5.7% OPEB 315,000 939,998 (624,998) -198.4% 630,000 1,254,998 (624,998) -99.2% 1,260,000 99.6% Total Unfunded Liability Costs 642,665 954,733 (312,068) -48.6% 1,283,143 1,328,895 (45,752) -3.6% 2,566,845 51.8% Purchased Property Services Repairs & Maintenance 927,070 896,026 31,044 3.3% 1,854,140 1,631,638 222,502 12.0% 3,711,280 44.0% Hauling & Disposal 264,250 572,632 (308,382) -116.7% 528,500 659,834 (131,334) -24.9% 1,057,000 62.4% Security 115,375 85,979 29,396 25.5% 230,750 179,052 51,698 22.4% 461,500 38.8% Rentals 61,962 70,456 (8,493) -13.7% 123,925 118,855 5,070 4.1% 247,850 48.0% Cleaning 110,802 119,202 (8,399) -7.6% 221,605 206,954 14,651 6.6% 443,210 46.7% Construction 1,500 1,500 100.0% 3,000 3,000 100.0% 6,000 0.0% Total Purchased Property Services 1,480,960 1,744,296 (263,336) -17.8% 2,961,920 2,796,333 165,587 5.6% 5,926,840 47.2% (Continued on page 9) 8 1 P a g e February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 103 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 3 - Operations & Maintenance Fund Expenses by Type - Detail (Continued) QTD QTD QTD QTD Variance YTD YTD YTD YTD Annual Category Budget Actual Variance ($) (%) Budget Actual Variance ($) Variance (%) Budget % Used Purchased Professional, Technical & Other Services Professional Services 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 253,781 162,292 91,489 36.1% 390,172 294,283 95,888 24.6% 925,180 31.8% 902,544 489,008 413,536 45.8% 1,805,088 731,650 1,073,438 59.5% 3,722,176 19.7% 951,405 325,263 626,142 65.8% 1,413,510 557,489 856,021 60.6% 2,287,485 24.4% 2,107,730 976,563 1,131,167 53.7% 3,608,770 1,583,422 2,025,348 56.1% 6,934,841 22.8% 1,203,337 1,408,482 (205,144) -17.0% 2,406,675 2,783,122 (376,447) -15.6% 4,988,350 55.8% 381,500 438,898 (57,398) -15.0% 763,000 918,377 (155,377) -20.4% 1,682,000 54.6% 965,671 675,137 290,534 30.1% 1,920,342 1,473,539 446,803 23.3% 3,842,384 38.3% 2,550,508 2,522,516 27,993 1.1% 5,090,017 5,175,038 (85,021) -1.7% 10,512,734 49.2% - - - 0.0% - - - 0.0% - 0.0% 146,350 87,158 59,192 40.4% 275,826 472,185 (196,360) -71.2% 583,251 81.0% 122,444 48,802 73,642 60.1% 252,337 95,998 156,340 62.0% 540,225 17.8% 17,195 64,089 (46,894) -272.7% 32,390 90,163 (57,773) -178.4% 55,280 163.1% 285,989 200,049 85,940 30.1% 560,553 658,346 (97,793) -17.4% 1,178,756 55.9% $ 20,606,058 $ 19,684,346 $ 921,712 4.5% $ 39,170,836 $ 36,322,289 $ 2,848,546 7.3% $ 79,520,131 45.7% February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 104 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 $ 621,270 $ 573,815 $ 47,455 7.6% $ 1,155,204 $ 1,059,275 $ 95,929 8.3% $ 2,454,169 43.2% Administration 5,045,317 5,253,574 (208,257) -4.1% 9,748,593 9,279,092 469,501 4.8% 19,901,049 46.6% Engineering and Technical Services 3,835,039 3,433,805 401,235 10.5% 7,353,597 5,928,785 1,424,812 19.4% 14,880,026 39.8% Operations 10,883,595 10,176,691 706,904 6.5% 20,471,767 19,138,747 1,333,020 6.5% 40,674,136 47.1% Recycled Water Program 220,838 246,462 (25,625) -11.6% 441,675 916,391 (474,716) -107.5% 1,610,750 56.9% Total Expenses $ 20,606,OS8 $ 19,684,346 $ 921,712 4.5% $ 39,170,836 $ 36,322,289 $ 2,848,546 7.3% $ 79,520,131 45.7% Year -to -Date Expenses by Department $30,000,000 $20,000,000 $10,000,000 Executive Governance Administration Engineering and Technical Operations Recycled Water Program Services ■ YTD ■ YTD Budget Actual 101Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 105 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 $ 286,366 $ 354,859 $ (68,493) -23.9% $ 526,556 $ 594,119 $ (67,562) -12.8% $ 1,171,228 50.7% Office of the Secretary of the District 226,985 155,907 71,078 31.3% 412,809 322,685 90,124 21.8% 846,215 38.1% Board of Directors 107,919 63,048 44,871 41.6% 215,838 142,471 73,367 34.0% 436,726 32.6% Administration Office of the Director of Finance and Administration 154,697 155,123 (426) -0.3% 294,008 290,594 3,413 1.2% 616,754 47.1% Finance Division 435,470 411,456 24,014 5.5% 811,602 763,073 48,529 6.0% 1,807,021 42.2% Human Resources Division 2,009,793 2,405,788 (395,995) -19.7% 3,944,706 3,910,133 34,573 0.9% 7,999,453 48.9% Purchasing Division 463,043 473,450 (10,407) -2.2% 859,175 875,199 (16,024) -1.9% 1,748,276 50.1% Risk Management Program 278,816 200,429 78,388 28.1% 541,599 391,697 149,901 27.7% 1,074,459 36.5% Public Info/Comm. Services & Intergov Relations Division 499,451 444,132 55,319 11.1% 961,183 829,794 131,389 13.7% 1,932,181 42.9% Information Technology Division 1,204,047 1,163,196 40,851 3.4% 2,336,320 2,218,601 117,720 5.0% 4,722,904 47.0% Engineering & Technical Services Office of the Director of Engineering & Technical Services 230,835 227,839 2,996 1.3% 435,812 269,663 166,149 38.1% 905,205 29.8% Planning & Developmental Services 1,541,481 1,329,411 212,070 13.8% 2,941,483 2,440,137 501,346 17.0% 5,891,208 41.4% Capital Projects Division (14,267) (361,663) 347,396 -2435.0% 1,391 (648,2S7) 649,648 46697.2% 26,686 -2429.2% Environmental & Regulatory Compliance 2,076,991 2,238,217 (161,227) -7.8% 3,974,911 3,867,242 107,669 2.7% 8,056,928 48.0% Operations Office of the Director of Operations 155,706 148,965 6,741 4.3% 296,198 319,368 (23,170) -7.8% 612,429 52.1% Collection System Operations Division 3,329,890 3,443,496 (113,606) -3.4% 6,351,908 6,311,468 40,440 0.6% 12,865,365 49.1% Treatment Plant Operations Division 3,596,020 3,388,836 207,184 5.8% 6,473,367 6,298,464 174,903 2.7% 12,350,601 51.0% Treatment Plant Maintenance Division 3,801,979 3,195,394 606,585 16.0% 7,350,294 6,209,447 1,140,847 15.5% 14,845,741 41.8% Recycled Water Recycled Water - General 40,825 13,016 27,809 68.1% 81,650 74,135 7,515 9.2% 163,300 45.4% Treatment Plant 17,375 128,684 (111,309) -640.6% 34,750 459,314 (424,564) -1221.8% 685,400 67.0% Distribution System 69,163 57,903 11,259 16.3% 138,325 151,100 (12,775) -9.2% 388,150 38.9% Residential Fill Station 67,600 46,859 20,741 30.7% 135,200 231,842 (96,642) -71.S% 270,400 85.7% Satellite Water Facility 25,875 - 25,875 100.0% 51,750 - 51,750 100.0% 103,500 0.0% Total Expenses $ 20,606,058 $ 19,684,346 $ 921,712 4.5% $ 39,170,836 $ 36,322,289 $ 2,848,546 7.3% $ 79,520,131 45.7% 111Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 106 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 $ S,S60,568 $ S,6SO,67S $ 90,107 1.6% $ S,S64,843 $ 5,660,SO4 $ 95,661 1.7% $ 10,035,739 56.4% Other Capital Revenues S,4S8,742 5,736,498 277,756 5.1% 7,100,392 7,139,SS2 39,160 0.6% 22,207,682 32.1% Total Revenue $ 11,019,310 $ 11,387,173 $ 367,863 3.3% $ 12,665,235 $ 12,800,056 $ 134,821 1.1% $ 32,243,421 39.7% Year -to -Date Revenues by Source $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Sewer Service Charges Other Capital Revenues Revenue Source Category ■ YTD ■ YTD Budget Actual 121Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 107 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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,773 $ (164) -2.8% $ 11,875 $ 11,643 $ (232) -2.0% $ 23,750 49.0% County Allocated 5,453,979 5,461,352 7,373 0.1% 5,453,979 5,461,352 7,373 0.1% 9,916,325 55.1% Direct Billed 102,314 183,550 81,236 79.4% 102,314 183,550 81,236 79.4% 102,314 179.4% Prior Year Adjustment (1,663) - 1,663 -100.0% (3,325) 3,959 7,284 -219.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 - Concorc Overtime Inspection Plan Review Main Lines Inspection Fees Other Agency Reimbursement - Miscellaneous Income Contractual Assessment District Total Revenues 131Page 1,449,750 1,661,466 211,716 14.6% 2,899,500 2,469,060 (430,440) -14.8% 5,799,000 42.6% 37,750 24,574 (13,176) -34.9% 75,500 69,910 (5,590) -7.4% 151,000 46.3% 24,500 32,791 8,291 33.8% 49,000 32,791 (16,209) -33.1% 98,000 33.5% 3,817,092 3,797,122 (19,970) -0.5% 3,817,092 4,251,044 433,952 11.4% 6,940,168 61.3% 79,750 43,655 (36,095) -45.3% 159,500 43,910 (115,590) -72.5% 319,000 13.8% - - - - - 8,700,914 0.0% 2,000 550 (1,451) -72.5% 4,000 4,309 309 7.7% 8,000 53.9% 30,250 43,355 13,105 43.3% 60,500 51,445 (9,055) -15.0% 121,000 42.5% 17,250 129,767 112,517 652.3% 34,500 145,315 110,815 321.2% 69,000 210.6% - 11,050 11,050 - 11,050 11,050 - 400 - (400) -100.0% 800 68,136 67,336 8417.0% 1,600 4258.5% (7,831.20) (7,831) (7,417) (7,417) $ 11,019,310 $ 11,387,173 $ 367,863 3.3% $ 12,665,235 $ 12,800,056 $ 134,821 1.1% $ 32,243,421 39.7% February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 108 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 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 Carryforward to Adopted Budget 1 Adjusted 1 Approved Actual Remaining Budgets Actuals FY 2021.22 Budget Adjustments Budget Expenditures Expenditures Budget Collection System (CS) $ 60,S27,138 48,91S,427 11,611,711 39,79S,000 39,79S,000 S1,406,711 18,S82,270 32,824,441 Treatment Plant (TP) 63,431,961 41,480,537 21,951,424 45,230,000 45,230,000 67,181,424 10,023,066 57,158,358 General Improvements (GI) 1S,799,S06 14,7S4,8S3 1,044,6S3 3,830,000 150,000 3,980,000 S,024,6S3 989,26S 4,035,388 Recycled Water (RW) 16,986,894 13,713,009 3,273,88S 16,600,000 16,600,000 19,873,88S 4,341,469 1S,S32,416 CIB Contingency - 2,500,000 (150,000) 2,350,000 2,350,000 2,350,000 Total $ 156,745,499 $ 118,863,826 $ 37,881,673 $ 107,955,000 $ - $ 107,955,000 $ 145,836,673 $ 33,936,069 $ 111,900,604 Capital Improvement Budget Quarterly Results by Program $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 ' $10,000,000 Collection Treatment Plant General Recycled Water CIB Contingency System (CS) (TP) Improvements (RW) (GI) Program ■ Approved Expenditures ■ Actual Expenditures 141Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 109 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 4 - Sewer Construction Fund Capital Expenditures Detail (by Project) A B C A-B D E F +E G C+D+E H I G-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 I Adjusted Approved I Actual Remaining Budge s Actuals FY 2020.21 Budget Adjustments Bud et Expenditures Expenditures Budget TYPE CS Collection System PH Sewer Renovation Phase 2 960,000 282,762 677,238 500,000 - 500,000 1,177,238 6,537 1,170,701 5991 *6534 Harper Lane Area CAD 660,370 648,370 12,000 - - - 12,000 12,000 - 7367 Concord Main Metering Station 250,000 852,844 (602,844) - - - (602,844) 119 (602,963) 8419 Collection System Planning LT 1,385,000 1,277,077 107,923 200,000 - 200,000 307,923 67,990 239,933 8436 Moraga/ Crossroads PS Project 22,807,000 20,399,420 2,407,580 12,644,000 - 12,644,000 15,051,580 10,638,047 4,413,533 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 43,538 1,583,253 8444 Force Main Inspection Program 625,000 15,525 609,475 500,000 - 500,000 1,109,475 2,607 1,106,868 8447 Pump Station Security Improvement 282,000 - 282,000 75,000 - 75,000 357,000 - 357,000 8448 Manhole Modifications 1,607,925 1,359,075 248,850 400,000 - 400,000 648,850 37,104 611,746 8449 Collection System Modeling Support 423,000 156,147 266,853 120,000 - 120,000 386,853 19,479 367,374 8450 Development Sewerage Support 3,132,316 3,137,328 (5,012) 900,000 - 900,000 894,988 432,710 462,278 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 626,327 2,987,309 8458 Martinez Sewer Renov. Ph. 6 4,470,000 4,249,701 220,299 - - - 220,299 149,337 70,962 8459 Lafayette Sewer Renov. Ph. 14 4,200,000 3,853,736 346,264 - - - 346,264 185,144 161,120 8460 WC Sewer Renov. Ph. 14 5,173,000 4,881,605 291,395 - - - 291,395 263,599 27,796 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,880,271 (589,934) 8463 No. Orinda Sewer Renov. PH. 8 500,000 472,342 27,658 4,600,000 - 4,600,000 4,627,658 899,613 3,728,045 8464 Martinez Sewer Renov. Ph. 7 500,000 296,826 203,174 2,000,000 - 2,000,000 2,203,174 111,303 2,091,871 8465 WC Sewer Renov. Ph.15 500,000 527,035 (27,035) 4,900,000 - 4,900,000 4,872,965 1,289,581 3,583,384 8466 Danville Sewer Ren. Ph.4 500,000 202,056 297,944 1,000,000 - 1,000,000 1,297,944 129,810 1,168,134 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 21,661 646,860 **100021 Cordel Drive West CAD - - - - 167,060 167,060 167,060 143,510 23,550 **100023 Walnut Creek Sewer Renovation Ph. 16 - - - - 500,000 500,000 500,000 225,400 274,600 **100024 South Orinda Sewer Renovation Ph. 9 - - - - 500,000 500,000 500,000 116,954 383,046 **100025 Lafayette Sewer Renov. Ph. 15 - - - - 500,000 500,000 500,000 73,378 426,622 **100026 Pacheco Boulevard Sewer Renovation - - - - 250,000 250,000 250,000 8,697 241,303 TBD Collection System Master Plan 2021 Update - - - 750,000 - 750,000 750,000 - 750,000 Rounding Total CS Program $ 60,527,138 48,915,427 11,611,711 39,795,000 39,795,000 51,406,711 18,582,270 32,824,441 * Substantially complete FY 20/21 ** Not in 21/22 Budget. New projects. Funds transferred from other projects or Contingency 151Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 110 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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-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 I Adjusted Approved I Actual Remaining Budge s Actuals FY 2020.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 6,762 212,504 7315 Applied Research and Innovations 1,357,274 476,040 881,234 300,000 - 300,000 1,181,234 366,029 815,205 7328 Influent Pump Electrical improvements 4,910,000 3,588,503 1,321,497 3,250,000 - 3,250,000 4,571,497 3,235,063 1,336,434 7339 T. Plant Control System I/O Replacement 3,470,000 3,115,113 354,887 - - - 354,887 13,603 341,284 7341 WC/Grayson Creek Levee Rehab 550,000 137,840 412,160 500,000 - 500,000 912,160 96,173 815,987 7348 Solids Handling Facility Improvements 17,118,687 15,688,482 1,430,205 21,000,000 - 21,000,000 22,430,205 753,369 21,676,836 7349 Aeration & Energy Upgrade 5,600,000 4,228,795 1,371,205 250,000 - 250,000 1,621,205 99,870 1,521,335 7352 UV Disinfection Upgrades 1,350,000 757,400 592,600 - - - 592,600 285,571 307,029 7353 Outfall Improvements Ph. 7 5,920,000 5,665,520 254,480 - - - 254,480 91,670 162,810 7354 TP Security Improvements 1,255,000 191,152 1,063,848 445,000 - 445,000 1,508,848 715 1,508,133 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 199,430 536,597 7364 TP Safety Enhancement Ph. 5 1,180,000 1,147,459 32,541 - - - 32,541 10,334 22,207 7369 Piping Renovation - Phase 10 3,250,000 667,413 2,582,587 2,200,000 - 2,200,000 4,782,587 78,604 4,703,983 7370 Annual Infrastructure Replacement 2,350,000 1,186,034 1,163,966 1,255,000 - 1,255,000 2,418,966 397,313 2,021,653 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 162,518 717,619 7375 Contractor Staging Improvements 3,500,000 623,407 2,876,593 - - - 2,876,593 2,455,778 420,815 100001 UPCAA Urgent Projects FY 2020-25 600,000 157,502 442,498 600,000 - 600,000 1,042,498 10,646 1,031,852 100008 Laboratory Roof & Seismic upgrades 500,000 - 500,000 450,000 - 450,000 950,000 604 949,396 100009 Hearth Replacement 500,000 - 500,000 - - - 500,000 26,138 473,862 100010 Air Condiditioning & Lighting Renovation 750,000 266 749,734 500,000 - 500,000 1,249,734 22 1,249,712 100011 Plant Electrical Replacement & Rehabilitation 400,000 7,916 392,084 200,000 - 200,000 592,084 69,236 522,848 100012 UV Disinfection Replacement 500,000 193,232 306,768 2,000,000 - 2,000,000 2,306,768 467,203 1,839,565 100013 UV Hydraulic Improvements 480,000 5,480 474,520 - - - 474,520 822 473,698 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 745,085 7,488,087 100018 Outfall Monitoring Improvements 100,000 13,214 86,786 510,000 - 510,000 596,786 89,614 507,172 100019 Aeration Basins Diffuer Replacement and Seismic 1 200,000 15,097 184,903 2,100,000 - 2,100,000 2,284,903 408,686 1,876,217 **100022 Wet Weather Basin Improvements 200,000 178,085 21,915 500,000 - 500,000 521,915 1,947 519,968 TBD TP Safety Enhancemetns - Ph. 6 - - - 200,000 - 200,000 200,000 - 200,000 Rounding Total TP Program $ 63,431,961 $ 41,480,537 $ 21,951,424 $ 45,230,000 $ $ 4S,230,000 $ 67,181,424 $ 10,023,066 $ 57,158,358 * Substantially complete FY 20/21 ** Not in 20/21 Budget New projects. Funds transferred from other projects or Contingency 161Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 111 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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-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 I Carryforward to I Adopted Budget Adjusted Approved Actual Remaining Budgets Actuals FY 2020-21 Budget Adjustments Budget Expenditures Expenditures Budget TYPE GI General Improvements 8230 Capital Legal Services 208,665 199,064 9,601 20,000 - 20,000 29,601 14,481 15,120 8236 District Easements 408,047 256,934 151,113 75,000 - 75,000 226,113 23,923 202,190 8240 IT Development 3,738,794 3,723,005 15,789 750,000 - 750,000 765,789 159,869 605,920 8250 ERP Replacement 5,030,000 5,189,106 (159,106) 300,000 50,000 350,000 190,894 137,877 53,017 8251 Capital improvement program & Budget Improven 490,000 124,024 365,976 100,000 - 100,000 465,976 3,444 462,532 8252 PUB 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,699 485,880 100003 Property Repairs & Improvements 300,000 156,418 143,582 150,000 - 150,000 293,582 45,538 248,044 100004 BOB Exterior Repairs 350,000 24,107 325,893 50,000 - 50,000 375,893 67,790 308,103 *100027 Furnishings Replacement - - - - 100,000 100,000 100,000 100,000 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) - - - - - - - 1,149 (1,149) Rounding Total GI Program $ 15,799,506 14,754,853 1,044,653 3,830,000 150,000 3,980,000 5,024,653 989,265 4,035,388 * Not in 20121 Budget. New projects. Funds transferred from other projects or Contingency TYPE RW Recycled Water 7306 Zone 1 Recycled Water 732,894 631,427 101,467 - - - 101,467 34,885 66,582 7361 Filter Plant & Clearwell Improvements Ph.1A 14,989,000 12,823,576 2,165,424 16,000,000 - 16,000,000 18,165,424 4,248,135 13,917,289 7366 ReW Distribution System Renov. Program 515,000 115,869 399,131 200,000 - 200,000 599,131 53,473 545,658 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 Total RW Program $ 16,986,894 13,713,009 3,273,885 16,600,000 16,600,000 19,873,885 4,341,469 15,532,416 9990 CONTINGENCY -ALL PROGRAMS 2,500,000 (150,000) 2,350,000 2,350,000 2,350,000 GRAND TOTAL $ 156,745,499 118,863,826 37,881,673 107,955,000 107,955,000 145,836,673 33,936,069 111,900,604 171Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 112 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section S - Self Insurance Fund Revenues by Source Annual QTD YTD Budget QTD QTD QTD Revenue YTD YTD YTD Revenue Annual Realized Category Budget Actual Variance ($) (%) Budget Actual Variance ($) (%) Budget (%) Sewer Service Charge County $ 1,576,419 $ 1,576,419 $ 0.0% $ 1,576,419 $ 1,576,419 $ 0.0% $ 1,576,419 Subrogation Recoveries - - - - - Insurance Recoveries (HHW) 6,250 - (6,250) -100.0% 12,500 - (12,500) -100.0% 25,000 0.0% Investment Income 12,500 3,953 (8,547) -68.4% 25,000 8,015 (16,985) -67.9% 50,000 16.0% Total Revenues $ 1,595,169 $ 1,580,372 $ (14,797) -0.9% $ 1,613,919 $ 1,584,434 $ (29,485) -1.8% $ 1,651,419 95.9% Year -to -Date Revenues by Source $1,600,000 $1,400,000 $1,200,000 $1,000,000'� $800,000 $600,000 1 $200,000� Sewer Service Charge County Subrogation Recoveries Insurance Recoveries (HHW) Investment Income Revenue Source Category ■ YTD ■ YTD Budget Actual 181Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 113 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Expenses by Type QTD Category Budget Professional Services $ 25,000 Technical Services 12,500 Insurance & Risk Management 542,500 Total Expenses $ 580,000 191Page Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section S - Self Insurance Fund Annual QTD YTD Budget QTD QTD Variance YTD YTD YTD Variance Annual Realized Actual Variance ($] (%) Budget Actual Variance ($) (%) Budget (%) $ 88,614 $ (63,614) -254.5% $ 50,000 $ 1 00,746 $ (70,746) -141.5% $ 140,000 86.2% 96,771 (84,271) -674.2% 25,000 96,771 (71,771) -287.1% 60,000 161.3% 493,800 48,700 9.0% 542,500 675,609 (133,109) -24.5% 1,085,000 62.3% $ 679,185 $ (99,185) -17.1% $ 617,500 $ 893,126 $ (275,626) -44.6% $ 1,285,000 143.9% Year -to -Date Expenses by Type $700,000 $600,000 $500,000 $400,000 $300,000,.''� $200,000 $100,000 MAN Professional Services Technical Services Expense Category ■YTD ■ YTD Budget Actual Insurance & Risk Management February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 114 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 $ 7,090,082 $ 6,985,671 $ (104,411) -1.5% $ 7,090,082 $ 6,985,671 $ (104,411) -1.5% $ 12,891,059 Investment Income - - Total Revenues $ 7,090,082 $ 6,985,671 $ (104,411) -1.5% $ 7,090,082 $ 6,985,671 $ (104,411) -1.50/. $ 12,891,059 54.2% Year -to -Date Revenues by Source $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Tax Revenue Investment Income ■ YTD ■ YTD Budget Actual 201Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 115 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 6 - Debt Service Fund Expenses by Type Annual QTD YTD Budget QTD QTD QTD Variance Variance YTD YTD YTD Variance Annual Variance Category Budget Actual ($) (%) Budget Actual Variance ($) (%) Estimate (%) Professional Services $ $ $ $ - $ 2,200 $ (2,200) $ - Interest Expense 372,948 124,316 248,632 66.7% 2,441,059 1963.6% Total Expenses $ $ $ $ 372,948 $ 126,516 $ 246,432 66.1% $ 2,441,059 5.2% $400,000 $350,000 $300,000 $250,000 $200,000 $1S0,000 $100,000 $50,000 211Page Year -to -Date Expenses by Type Professional Services Interest Expense ■ YTD ■ YTD Budget Actual February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 116 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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) $ 15,100,000 $ 11,100,000 $ 4,000,000 $ 15,100,000 $ 15,084,655 100.00% $ 10,114 $ 20,455 (3) $ 1S,100,000 $ 11,100,000 $ 4,000,000 $ 15,100,000 $ 15,084,65S 100.00% 10,114 20,455 (2) (4) (8) $ 10,114 $ 20,455 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Notes (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of December, 2021 was 0.212%. (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.212%. As the District is a voluntary participant in the County Treasury Pool, this calculation excludes investments purchased after the 15th day of the month, which is the cut-off for month -end reporting by Contra Costa County. (4) The market value of the portfolio on December 31, 2021 was $15,084,655. 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, $8,960,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 fallowing month's report. 221Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 117 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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) $ 38,000,000 $ 1,000,000 $ 37,000,000 $ 38,000,000 $ 37,961,383 100.00% $ 10,874 $ 11,421 (3) $ 38,000. 000 $ 1000,00D $ 37,000. 000 $ 38,000. 000 $ 37,961, 883 100.000/9 10,874 11,421 (2) (4) (8) 97 $ 00,874 7i 11,518 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Notes: (1) Annual Yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of December, 2021 was 0.212%. (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.212%. 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 Countv. (4) The market value of the portfolio on December 31, 2021 was $37,961,383. GASB 31 requires adjusting investments to market value. The District will adjust annually, but report market values monthly. (5) All investments held by the Sewer Construction Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)] (6) Sufficient liquidity and anticipated revenues are available for Central San to meet budgeted expenditures of the Sewer Construction fund for the next six (6) months [California Government Code §53646(b)(3)] (7) Of the total investments held in the Sewer Construction Fund, $1,000,000 is restricted for the Rate Stabilization Reserve Account. (8) Amount represents investment income from prior period investments. 231Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 118 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 7 - Quarterly Investment Portfolios Self Insurance Fund QTD YTD Purchase Maturity Days to Annual Cash BOQ Purchase EOQ EOQ %of Investment Investment No Issuer Type Date Date Maturity Yield Outlay Face Value (Maturity) Face Value Market Value Portfolio Income Income 519 State of Calif. LAW 10/99- n/a n/a (1) $ 7,100,000 $ 7,600,000 $ (500,000) $ 7,100,000 $ 7,092,785 100.00% $ 4,200 $ 8,352 (3) $ 7,100,000 $ 7,600,000 $ (500,000) $ 7,100,000 $ 7,092,785 100.00% 4,200 8,352 (2) (4) (7) $ 4,200 $ 8,352 Legend: EOQ = End of quarter BOQ = Beginning of quarter YTD = Year to Date Notes: (1) Annual yield of Local Agency Investment Fund (LAIF) varies with the composition of the Fund. The estimated yield as of December, 2021 was 0.212%. (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.212%. (4) The market value of the portfolio on December, 2021 was $7,092,785. (5) All investments held by the Self Insurance Fund comply with Central San's investment policy approved by the Board of Directors [California Government Code §53646(b)(2)] (6) Sufficient liquidity and anticipated revenues are available for Central Santo meet budgeted expenditures of the Self Insurance fund for the next six (6) months [California Government Code §53646(b)(3)] (7) Amount represents interest income from prior period investments. 241Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 119 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT O&M Fund Cashflow Forecast $80.0 $70.0 $60.0 $50.0 $40.0 $30.0 $20.0 $10.0 $0.0 Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 8 - Financial Performance Metric Charts FY 2021-22 Running Expense Fund Total Cash & Investment Balances (Actuals through December 2021) $71.0 June'21 July August September October November December January February March M Projected Balance* M Actual Balance —Reserve Target at Year End** $67.7 April May June 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 February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 120 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT IA Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 8 - Financial Performance Metric Charts Sewer Construction Fund Cashflow Forecast $80.0 $70.0 $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 M Projected Balance* MActual Balance —Reserve Target at Year End** NOTES: * Projected balances were generated in July 2021 based on budgeted revenues and expenses for FY 2021-22 and applied to the actual balance at June 30, 2021 ** The Reserve Target at Year End is the minimum balance required at June 30, 2022 to comply with the District Policy 261Page FY 2021-22 Sewer Construction Fund Total Cash & Investment Balances (Actuals through December 2021) `$74.9 F $60.5 $s6.3 $6- <ca o $57.1 $56.9 $56.7 $63.4 7.8 $48.8 $47.s $4L2 $41.z $41.8 $54.0 May June February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 121 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 8 - Financial Performance Metric Charts Staffing Trends 300 5.2% vacancy Rate 295 290 16 F 285 w a� 280 275 270 265 277 276 w 260 255 250 12/31/18 12/31/19 12/31/20 12/31/21 Quarter Ended ■ Filled Positions (FTEs) ■ Vacancies (FTEs) 271Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 122 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 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 $ 3, 994 $ 3, 715 $3,907 12/31/18 12/31/19 12/31/20 First Quarter of Fiscal Year $ 2, 744 12/31/21 February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 123 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 8 - Financial Performance Metric Charts Capital Spending Trend $160 $145.9M $140 $120 $111.3M r-, o $100 $80 - $60 $40 $33.9M $20 l�� P��S� Se��e�,oei Oc�obet �o`�e�be� Oece�roe� 1a°Jai 4eo{``at`J �a.�c`t` PQY, �a9 1.�oe Projected (100% spend) Actual 76% Target 291Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 124 of 202 CENTRAL CONTRA COSTA SANITARY DISTRICT Budget -to -Actual Financial Report Quarter Ending December 31, 2021 Section 8 - Financial Performance Metric Charts Miles of Pipeline Constructed / Renovated 4.0 3.5 0 3.0 U y 2.5 0 2.0 1.8 2.0 1.7 a. a. 0 1.5 1.0 1.0 1.0 0.5 0.50 0.0 a I30 �ti1 1tiI31Iti1 �131Iti� 6I1P Quarter Ending ■ Actual Construction ■ Target ("S-Curve" of 6 mi. FY 21-22 Budget Projection) 301Page February 22, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 125 of 202