The URL can be used to link to this page

Home My WebLink About03.b. Review September 2019 Financial Statements and Investment Reports Page 1 of 38 Item 3.b. ,0f,rTCJ ON SAN FA October 22, 2019 TO: FINANCE COMMITTEE FROM: CHRIS THOMAS, FINANCE ADMINISTRATOR KEVIN MIZUNO, FINANCE MANAGER REVIEWED BY: PHILIP LEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION ANN SASAKI, DEPUTY GENERAL MANAGER ROGER S. BAILEY, GENERAL MANAGER SUBJECT: REVIEW SEPTEMBER 2019 FINANCIAL STATEMENTS AND INVESTMENT REPORTS Attached for review are the Financial Statements and Investment Reports for the month of September 2019. The attached monthly budget-to-actual reports exclude Operations and Maintenance (O&M)fund detail by division as this information is generated and monitored internally. With the first quarter of Fiscal Year (FY) 2019-20 completed through September 30, budgetary results for the O&M, Sewer Construction, Self-I nsurance, and Debt Service funds suggest current year activities-to- date continue to be on target in the aggregate. The O&M Fund expenditure results are favorable, with spending at approximately 22% of total adopted FY 2019-20 budget to date. Limited O&M Fund revenues were scheduled for collection, or actually collected, in the July-September period. The Sewer Construction Fund has spent$9,740,422, or 13.0% of the total adopted budget for FY 2019- 20. Although this figure falls short of 22.5% full year budget anticipated for this period, the pace of several capital projects typically picks up throughout the year, and is expected to accelerate most notably for the large Solids Handling Facility Improvements (District Project (DP) 7348), Mechanical and Concrete Renovations (DP 7351), Moraga/Crossroads Pump Station (DP 8436), and Enterprise Resource Planning Replacement (DP 8250) capital projects. The Pension funding charts in the Financial Dashboard section have been updated to reflect the availability of the 2018 CCCERA pension valuation. The Unfunded Actuarial Accrued Liability (UAAL) at$74 million is unchanged from the prior year versus an expected decrease of about$6 million based on the scheduled amortization of UAAL over 18 years. This is due to a new layer added to the UAAL of about$6 million due to actuarial losses and assumption changes, which exactly offset the expected amortization. The actuarial losses are due to the market decline as of December 31, 2018 that resulted in a return below the expected 7%. The equity markets rebounded in 2019, so this may be a short-term issue. Staff will provide the CCCERA valuation at the November 26, 2019 Finance Committee meeting. October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 63 of 168 Page 2 of 38 Strategic Plan Tie-In GOAL THREE: Be a Fiscally Sound and Effective Water Sector Utility Strategy 2- Manage costs ATTACHMENTS: 1. September 2019 Financial Statements and Investment Reports October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 64 of 168 Page 1 of 36 CENTRAL CONTRA COSTA SANITARY DISTRICT October 8,2019 TO: THE BOARD OF ORS VIA: KEVIN MIZUN FROM: CHRIS THOMAS SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through period ending September 30,2019 YTD Total FY YTD YTD Fav/(Unfav) O&M Revenues: Budget Budgeted Actual Variance Explanation Budget is spread evenly throughout the year for SSC-Direct, however actual activity Total $ 89,560,370 $ 1,430,485 $ 1,334,080 $ [96,405L occurs sporadically every month. O&M Expenses: Total Labor Charges $ 52,789,084 $ 13,028,013 $ 12,259,513 $ 768,500 Some positions budgeted for in July are filled later in the fiscal year resulting in savings. Chemicals 1,620,000 404,991 292,432 112,559 Chemical consumption lower than budgeted. Utilities 4,209,350 1,052,319 873,328 178,991 Lower due to delay in invoices. Repairs&Maintenance 5,242,867 1,310,649 995,818 314,831 Budget is spread evenly throughout the year, however actual activity occurs sporadically every month. Variance should be minimal by year end. Professional&Legal Services 874,300 218,550 50,197 168,353 Lower mostly due to lower Legal expenses thus far in the fiscal year. Outside Services 3,639,547 912,876 454,965 457,911 Mainly due to Operating Supplies expenses being lower than budgeted thus far in the fiscal year. Materials&Supplies 2,152,127 537,897 446,151 91,746 No significant variances. Other Expenses 2,464,834 384,582 171,996 212,586 Budget is spread evenly throughout the year, however actual activity occurs sporadically every month. Variance should be minimal by year end. Unfunded Liabilities 12,436,841 3,109,149 2,759,842 349,307 Variance due to vacancy projections spread evenly throughout the year,however actual staffing terminations and additions occurs sporadically during the year. All Other 2,155,825 .1,117,685 1,005,067 112,618 Minor variances for multiple account categories. Total $ 87584,775 $ 22,076,711 $ 19,309,309 $ 2,767,402 October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 65 of 168 Page 2 of 36 A001' Central Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 001 - RUNNING EXPENSE(O&M) September 2019 Fiscal Period 3/2020 Report Generated on Oct 8, 2019 7:54:50 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $0 $0 0.0% $0 ($45,667) 0.0% $14,570,000 $14,615,667 -0.3% HHW $8,000 $4,046 -49.4% $24,000 $13,750 -42.7% $968,000 $954,250 1.4% Other $385,529 $493,450 28.0% $1,178,987 $1,163,505 -1.3% $4,931,500 $3,767,995 23.6% Sewer Service Charges $9,166 $46,579 408.2% $227,498 $202,491 -11.0% $69,090,870 $68,888,379 0.3% Total Revenue $402,695 $544,076 35.1% $1,430,485 $1,334,080 -6.7% $89,560,370 $88,226,291 1.5% Page 3 of 36 Atyts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 -RUNNING EXPENSE(O&M) September 2019 Fiscal Period 03/2020 Report Generated on Oct 8, 2019 7:54:06 AM $25,000,000.00 —Budget Actual $22-076,711 $20,000,000.00- $19,309,309 $15,000,000.00 $15,010,366 $13,029,620 $10,000,000.00- $7,943,704 $5,000,000.00 $6,553,088 $0.00 Jul(1)2019 Aug(2)2019 Sep(3)2019 Fiscal Periods Page 4 of 36 A001' Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE(O&M) September 2019 Fiscal Period 0312020 Report Generated on Oct 8, 2019 7:54:06 AM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $3,152,929 $2,958,693 $194,236 6.2% $9,458,787 $8,936,063 $522,724 5.5% $38,060,443 23.5% EMPLOYEE BENEFITS $1,560,433 $1,532,527 $27,906 1.8% $4,681,299 $4,562,230 $119,069 2.5% $19,177,010 23.8% CAPITALIZED ADM OVERHEAD ($370,691) ($411,035) $40,344 10.9% ($1,112,073) ($1,238,780) $126,707 11.4% ($4,448,369) 27.8% DIRECTOR FEES&EXPENSES $12,053 $14,052 ($1,999) -16.6% $36,159 $38,580 ($2,421) -6.7% $144,650 26.7% CHEMICALS $134,997 $107,557 $27,440 20.3% $404,991 $292,432 $112,559 27.8% $1,620,000 18.1% UTILITIES $350,773 $376,493 ($25,720) -7.3% $1,052,319 $873,328 $178,991 17.0% $4,209,350 20.7% REPAIRS&MAINTENANCE $436,883 $375,714 $61,169 14.0% $1,310,649 $995,818 $314,831 24.0% $5,242,867 19.0% HAULING&DISPOSAL $58,842 $45,572 $13,270 22.6% $256,526 $141,487 $115,039 44.8% $1,186,175 11.9% PROFESSIONAL&LEGAL SERV $72,850 $35,633 $37,217 51.1% $218,550 $50,197 $168,353 77.0% $874,300 5.7% OUTSIDE SERVICES $274,692 $111,586 $163,106 59.4% $912,876 $454,965 $457,911 50.2% $3,639,547 12.5% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $825,000 $825,000 $0 0.0% $825,000 100.0% MATERIALS&SUPPLIES $179,299 $146,029 $33,270 18.6% $537,897 $446,151 $91,746 17.1% $2,152,127 20.7% OTHER EXPENSES $166,902 $83,116 $83,786 50.2% $384,582 $171,996 $212,586 55.3% $2,464,834 7.0% UNFUNDED LIABILITIES $1,036,383 $903,750 $132,633 12.8% $3,109,149 $2,759,842 $349,307 11.2% $12,436,841 22.2% Total Expenses $7,066,345 $6,279,689 $786,656 11.1% $22,076,711 $19,309,309 $2,767,402 12.5% $87,584,775 22.0% Color Key: 0 to 10%over budget > 10%over budget M Page 5 of 36 ACV Ls entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE (O&M) September 2019 Fiscal Period 03/2020 Report Generated on Oct 8, 2019 7:52:49 AM $2,500,000 ❑Period Budget $8,000,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $2,000,000 $6,000,000 $1,500,000 $4,000,000- $1,000,000- $2,000,000- $500,000- $0-LL 4,000,000$1,000,000 $2,000,000$500,000$0 $0LL� LLJ —L� m �`�\ \� Q��c°e� S�P �p�. � �° °P�Q Jae S�P1�p� . IN Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $1,829,249 $1,613,941 $215,308 $6,343,589 $5,518,473 $825,116 ENGINEERING $1,314,963 $1,147,844 $167,119 $4,024,889 $3,441,030 $583,859 COLLECTION SYSTEM OPS. $1,222,796 $1,090,501 $132,295 $3,693,388 $3,333,906 $359,482 PLANT OPERATIONS $2,325,912 $2,053,211 $272,701 $6,894,570 $6,002,546 $892,024 PUMP STATIONS $241,210 $274,737 ($33,527) $723,630 $687,365 $36,265 RECYCLED WATER $132,215 $99,454 $32,761 $396,645 $325,989 $70,656 Totals $7,066,345 $6,279,689 $786,656 $22,076,711 $19,309,309 $2,767,402 Page 6 of 36 CENTRAL CONTRA COSTA SANITARY DISTRICT RUNNING EXPENSE FUND TEMPORARY INVESTMENTS SEPTEMBER,2019 INVESTMENTS (cents omitted) INTEREST INCOME DATE OF Days to ANNUAL CASH B.O.M. PURCHASE E.O.M. E.O.M %of CURRENT B.O.M. E.O.M. NO. ISSUER TYPE PURCHASE MATURITY Maturity YIELD OUTLAY FACE VALUE(MATURITY) FACE VALUE MKT VALUE Portfolio MONTH CUMULATIVE CUMULATIVE 519 State of Calif. LAW 10/99- ....... 1 (1) $17,000,000 $12,000,000 $5,000,000 $17,000,000 $17,137,774 68.00% $26,664.38 $53,580.00 $80,244.38 RE13 US Gov't FHLB 9/18/2019 3/20/2020 172 1.899% 3,962,178 0 4,000,000 4,000,000 3,964,840 16.00% 2,672.22 0.00 2,672.22 RE14 US Gov't FHLB 9/18/2019 3/18/2020 170 1.909% 3,962,387 0 4,000,000 4,000,000 3,965,240 16.00% 2,686.67 0.00 2,686.67 (3) $24,924,564 $12,000,000 $13,000,000 $25,000,000 $25,067,854 100.00% $32,023.27 $53,580.00 $85,603.27 (2) 29,629.16 29,629.16 $32,023.27 $83,209.16 $115,232.43 NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of September,2019 was 2.290%. (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 2.290%. The weighted average maturity is.15 years. (4) The market value of the portfolio on September,2019 was$17,137,734. (5) The District has sufficient funds available combined with secured SSC and Property Tax received in December and April to cover six months of cash flow needs. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 70 of 168 Page 7 of 36 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) September 2019 Fiscal Period 3/2020 Summarized by Account Report Generated on Oct 8,2019 7:49:23 AM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $3,181,721 CASH ACCOUNTS/PAYROLL CLEARING $20,000 CASH ACCOUNTS/PETTY CASH $3,400 CASH ACCOUNTS/TEMPORARY INVESTMENTS $25,000,000 DEFERRED OUTFLOWS/DEFERRED OUTFLOWS-GASB 68 $21,503,021 DEFERRED OUTFLOWS/DEFERRED OUTFLOWS-GASB 75 $30,400 DUE FROM/DUE FROM S/C $2,820,893 DUE FROM/DUE FROM S/I $939,042 INVENTORY/SUPPLIES&MATERIAL INV $2,211,595 PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104 PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572 PREPAID ACCOUNTS/PREPAID EXPENSES $13,918 PREPAID ACCOUNTS/PREPAID INSURANCE $342,450 PREPAID ACCOUNTS/PREPAID RETIREMENT $13,884,646 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $2,469 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $350,150 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA ($3,527) RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $80,245 RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $13,871 RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $101,362 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $1,949 Current Assets $70,544,281 Net Property,Plant and Equipment CONTRIBUTED FIXED ASSETS/ACC DEPR-CONTRIB ASSETS ($63,652,332) CONTRIBUTED FIXED ASSETS/CONTRIBUTED SEWER LINES $162,344,781 FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $45,917,681 FIXED ASSETS/ACC DEPR-BUILDINGS ($15,427,731) FIXED ASSETS/ACC DEPR-ENTERPR SOFTWARE ($168,283) FIXED ASSETS/ACC DEPR-FURN&EQUIP ($10,415,521) FIXED ASSETS/ACC DEPR-OUTFALL ($3,919,770) FIXED ASSETS/ACC DEPR-PUMPING STATIONS ($37,309,198) FIXED ASSETS/ACC DEPR-SEWAGE COL SYS ($78,758,161) FIXED ASSETS/ACC DEPR-TREATMENT PLANT ($235,704,155) FIXED ASSETS/ACC DEPR-VEHICLES ($5,296,931) FIXED ASSETS/ACCUM DEPRC-RECY WATER ($10,355,662) FIXED ASSETS/BUILDINGS $44,379,479 FIXED ASSETS/ENTERPRISE SOFTWARE $3,365,658 FIXED ASSETS/FURNITURE&EQUIPMENT $14,579,938 FIXED ASSETS/INTANGIBLE ASSETS $4,949,507 FIXED ASSETS/LAND $17,320,570 FIXED ASSETS/OUTFALL SEWERS $11,371,574 FIXED ASSETS/PUMPING STATIONS $57,327,020 FIXED ASSETS/RECY WATER INFRASTRUCTURE $20,292,366 FIXED ASSETS/SEWAGE COLLECTION FACIL $394,084,852 FIXED ASSETS/TREATMENT PLANT $354,976,293 FIXED ASSETS/VEHICLES $7,490,960 Net Property,Plant and Equipment $677,392,935 TOTAL ASSETS $747,937,216 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($6,801) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,493,310) Page 8 of 36 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) September 2019 Fiscal Period 3/2020 Summarized by Account Report Generated on Oct 8,2019 7:49:23 AM CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($5,031,552) CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,267,073) CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($46,924) CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($1,341) CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931) CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING ($5,562) CURRENT LIABILITIES/PERMIT CLEARING ($20,212) CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($44,080) CURRENT LIABILITIES/RETIREMENT CONTRIB W/H $32,533 CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $676,510 DEF.COMP.CONTRIB W/H/ICMA 4571401A ($58,905) DEF.COMP.CONTRIB W/H/ICMA TIER III HRA $58,905 DUE TO/DUE TO S/C ($85,351) DUE TO/DUE TO Sit ($825,000) LIABILITIES-LONG TERM/DEFERRED INFLOWS-GASB 68 ($28,076,634) LIABILITIES-LONG TERM/NET OPEB LIAB-GASB 75 ($46,350,454) LIABILITIES-LONG TERM/NET PENSION LIAB-GASB 68 ($63,806,000) LIABILITIES-LONG TERM/POST EMP.BENEFIT-PENSION $8,522,191 LIABILITIES/UNEARNED INTEREST ($70,077) MEDICAL LIABILITIES/CALIPERS MEDICAL ($5,458) MEDICAL LIABILITIES/DELTA DENTAL $321 MEDICAL LIABILITIES/DISABILITY INS $6,723 MEDICAL LIABILITIES/HEALTH NET $823,222 MEDICAL LIABILITIES/KAISER PERMANENTE ($337,108) MEDICAL LIABILITIES/LIFE INS $4,929 MEDICAL LIABILITIES/OCCUPATIONAL HEALTH ($3,062) MEDICAL LIABILITIES/VSP VISION CARE ($13) REIMBURSEMENT FEES ($54,466) Total Liabilities ($137,603,981) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE ($42,245,414) FUND EQUITY/CAPITAL COST SHARING ($123,029,998) FUND EQUITY/CONTRIBUTED SEWER LINES ($162,344,781) FUND EQUITY/EXPENDITURE SUMMARY $19,309,309 FUND EQUITY/GENERAL FIXED ASSET GROUP ($225,386,993) FUND EQUITY/STATE&FED CAPITAL GRANT ($75,301,279) YEAR TO DATE REVENUES/REVENUE SUMMARY ($1,334,080) Total Fund Equity ($610,333,235) TOTAL LIABILITIES AND FUND EQUITY ($747,937,216) Page 9 of 36 CENTRAL CONTRA COSTA SANITARY DISTRICT October 8,2019 TO: THE BOARD OF DIRGQTORS VIA: KEVIN MIZUNO FROM: CHRIS THOMAS SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending September 30,2019: YTD Total FY YTD YTD Fav/(Unfav) S/C Revenues: Budget Budgeted Actual Variance Explanation Facilities Capacity Fees, Interest income received was Total $ 65,598,130 $ 1,807;239 $ 2,550,374 $ 743,135 higher than budgeted. Total FY YTD YTD YTD SIC Expenses: Budget" Budgeted Actual Remaining %Spent Total $ 74,669,521 $ 11,789,041 $ 9,740,422 $ 2,048,619 82.62% Includes 18119 carry-over($8,493,521) October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 73 of 168 Page 10 of 36 A001' Central Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 002-SEWER CONSTRUCTION (Capital) September 2019 Fiscal Period 3/2020 Report Generated on Oct 8, 2019 7:54:50 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $0 $0 0.0% $0 $0 0.0% $11,630,000 $11,630,000 0.0% Other $602,413 $1,264,229 109.9% $1,807,239 $2,455,958 35.9% $21,749,000 $19,293,042 11.3% Sewer Service Charges $0 $21,719 0.0% $0 $94,416 0.0% $32,219,130 $32,124,714 0.3% Total Revenue $602,413 $1,285,947 113.5% $1,807,239 $2,550,374 41.1% $65,598,130 $63,047,756 3.9% Page 11 of 36 Sewer Fund (Capital) Spending FY 19-20 $14,000,000 $11,789,041 $12,000,000 $10,000,000 — $8,000,000 $9,740,422 $6,000,000 $4,934 1 $4,000,000 — $4,282,657 $2,000,000 $1,627,894 July August September Projected* Actual Columnl July August September Projected* $ 2,066,477 $ 4,934,581 $ 11,789,041 Actual 1,627,894 4,282,657 9,740,422 *Projected -Current year budget allocated by month based on historical spending in previous 2 years October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 75 of 168 Page 12 of 36 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:9/30/2019 PERIOD 3/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 TYPE CS Collection System $ 16,633,417 17,490,252 (856,835) 27,129,000 200,000 27,329,000 26,472,165 4,416,982 22,055,187 TYPE TP Treatment Plant 44,592,999 39,917,024 4,675,975 28,631,000 200,000 28,831,000 33,506,975 3,199,869 30,307,128 TYPE GI General Improvements 8,695,483 5,883,070 2,812,413 5,369,000 30,000 5,399,000 8,211,413 1,474,073 6,737,339 TYPE RW Recycled Water 5,239,894 3,377,926 1,861,968 4,152,000 - 4,152,000 6,013,968 649,498 5,364,483 CIB Contingency - - - 895,000 (430,000) 465,000 465,000 - 465,000 TOTAL DISTRICT $ 75,161,793 $ 66,668,272 $ 8,493,521 $ $ 66,176,000 $ 74,669,521 $ 9,740,422 $ 64,929,137 October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 76 of 168 Page 13 of 36 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:9/30/2019 PERIOD 3/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 TYPE CS Collection Sys 5991 PH Sewer Renovation Phase 2 460,000 277,771 182,229 - - 182,229 - 182,229 6534 Harper Lane Area CAD 800,000 412,260 387,740 - - 387,740 211,008 176,732 *6602 South Jackson CAD 411,290 391,290 20,000 - - 20,000 15,191 4,809 *6603 North Jackson CAD 276,557 53,313 223,244 - - 223,244 11,176 212,068 6679 Coredell Drive CAD 123,443 54,906 68,537 - - 68,537 19,105 49,432 *7367 Concord Main Metering Station 250,000 245,826 4,174 - - 4,174 (209,255) 213,429 8419 Collection System Planning LT 985,000 984,958 42 200,000 200,000 200,042 39,591 160,451 8436 Moraga/Crossroads PS Project 3,747,000 3,218,526 528,474 4,600,000 4,600,000 5,128,474 535,710 4,592,764 8441 CIPP Contract 17-20 400,000 275,923 124,077 200,000 200,000 324,077 2,563 321,514 8442 PS Equipment Piping Replacement PH2 61,000 - 61,000 103,000 103,000 164,000 - 164,000 8443 LG Diameter Pipe line Inspection 250,000 18,484 231,516 515,000 515,000 746,516 - 746,516 8444 Force Main Inspection Program 125,000 - 125,000 - - 125,000 - 125,000 *8446 Lafayette Sewer Renovation Phase 12 4,033,600 3,715,186 318,414 - - 318,414 27,100 291,314 8447 Pump Station Security Improvement 156,000 - 156,000 51,000 51,000 207,000 - 207,000 8448 Manhole Modifications 712,000 860,375 (148,375) 309,000 309,000 160,625 4,540 156,085 8449 Collection System Modeling Support 200,000 130,135 69,865 103,000 103,000 172,865 5,504 167,361 8450 Development Sewerage Support 1,130,000 1,309,893 (179,893) 900,000 900,000 720,107 259,911 460,196 8451 C.S.Sewer Renovation 62,527 - 62,527 4,473,000 (2,000,000) 2,473,000 2,535,527 - 2,535,527 8452 Lafayette Sewer Ren.Ph.13 500,000 1,561,461 (1,061,461) 3,817,000 3,817,000 2,755,539 1,177,391 1,578,148 8454 So.Orinda Sewer Ren.Ph.7 500,000 860,185 (360,185) 3,637,000 3,637,000 3,276,815 1,040,813 2,236,002 8455 W.C.Sewer Renov.Ph.13 500,000 2,604,854 (2,104,854) 3,621,000 3,621,000 1,516,146 812,564 703,582 8456 Danville Sewer Ren.Ph.3 500,000 381,637 118,363 4,100,000 4,100,000 4,218,363 37,476 4,180,887 8457 Pump Station Upgrades-Ph.2 50,000 - 50,000 500,000 500,000 550,000 25,820 524,180 *8458 Martinez Sewer Renov.Ph.6 100,000 11,405 88,595 - 500,000 500,000 588,595 87,162 501,433 *8459 Lafayette Sewer Renov.Ph.14 100,000 24,336 75,664 - 500,000 500,000 575,664 89,690 485,974 *8460 WC Sewer Renov.Ph.14 100,000 53,907 46,093 - 500,000 500,000 546,093 81,779 464,314 *8461 So.Orinda Sewer Ren.Ph.8 100,000 43,621 56,379 - 500,000 500,000 556,379 142,143 414,236 **8462 S.R.Pump Station Flow Diversion - - - - 200,000 200,000 200,000 - 200,000 Rounding 4 otalFY 2019-20 CS Amoun $ 16,633,417 17,490,252 (856,835) 27,129,000 27,329,000 *Italic Projects open but not in CIB for 19/20 Not in 19/20 Budget. New projects opened in Aug.2019. Funds transferred from Contingency 9990 October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 77 of 168 Page 14 of 36 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:9/30/2019 PERIOD 3/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 *6172 Sludge Blending Tank Repair 776,000 - 776,000 - - 776,000 1,333 774,667 7292 Switchgear Refurbishment-Ph.2 684,548 473,274 211,274 200,000 200,000 411,274 2,851 408,423 7304 Instr&Controls PLC Upgrade 500,000 470,528 29,472 - - 29,472 34 29,438 7315 Applied Research and Innovations 557,274 290,336 266,938 300,000 300,000 566,938 - 566,938 7317 Plant Control System Network Upgrades 765,000 281,461 483,539 120,000 120,000 603,539 198,612 404,927 *7320 Plant Energy Optimization 1,094,000 1,004,604 89,396 - - 89,396 257 89,139 7322 Fire Protection System Ph.2 1,406,000 1,340,832 65,168 - - 65,168 3,336 61,832 *7326 Equipment Replacement FY 15-FY 14 1,629,000 1,628,975 25 - - 25 96,354 (96,329) 7327 Headwork's Screening Upgrade 8,305,000 8,304,264 736 - - 736 15,870 (15,134) 7328 Influent Pump Electrical improvements 610,000 431,527 178,473 800,000 800,000 978,473 55,047 923,426 7330 Piping Renovation Phase 9 3,180,000 3,127,343 52,657 - - 52,657 21,714 30,943 7339 T.Plant Control System I/O Replacement 1,370,000 1,286,269 83,731 1,100,000 1,100,000 1,183,731 6,947 1,176,784 7341 WC/Grayson Creek Levee Rehab 100,000 76,528 23,472 200,000 200,000 223,472 45,069 178,403 7348 Solids Handling Facility Improvements 9,914,000 9,243,507 670,493 6,550,000 6,550,000 7,220,493 319,459 6,901,034 7349 Aeration&Energy Upgrade 1,500,000 749,790 750,210 3,500,000 3,500,000 4,250,210 392,610 3,857,600 7351 Mechanical&Concrete Renovation 5,044,000 5,534,806 (490,806) 6,400,000 6,400,000 5,909,194 486,753 5,422,441 7352 UV Disinfection Upgrades 500,000 294,751 205,249 600,000 600,000 805,249 18,631 786,618 7353 Outfall Improvements Ph.7 100,000 54,551 45,449 500,000 500,000 545,449 49,962 495,487 7354 TP Security Improvements 137,000 41,951 95,049 718,000 718,000 813,049 378 812,671 7355 Odor Control Upgrade Ph.1 - - - - - - - - 7357 Plant Wide Instrumentation Upgrade 290,000 77,858 212,142 450,000 450,000 662,142 1,006 661,136 *7358 Innovation Bioenergy Demo 300,000 270,796 29,204 - - 29,204 - 29,204 7359 Solids Conditioning Bldg.roof replacement 1,300,000 1,195,265 104,735 - - 104,735 440 104,295 7360 Existing Plant Facility Drawing 200,000 158,215 41,785 100,000 100,000 141,785 18,520 123,265 7362 POB Seismic Upgrades 3,331,177 2,850,440 480,737 2,793,000 2,793,000 3,273,737 1,250,286 2,023,451 7363 Treatment Plant Planning 900,000 719,153 180,847 500,000 500,000 680,847 131,386 549,461 7364 TP Safety Enhancement Ph.5 100,000 10,000 90,000 600,000 600,000 690,000 1,029 688,971 7369 Piping Renovation-Phase 30 - - - 750,000 750,000 750,000 - 750,000 7370 Annual Infrastructure Replacement - - - 2,200,000 2,200,000 2,200,000 81,985 2,118,015 7371 Condition Assessment of Buried Pipelines - - - 250,000 250,000 250,000 - 250,000 **7373 Fire Protection System Ph.3 - - - - 200,000 200,000 200,000 - 200,000 Rounding 22 Total FY 2019-20 TP Amoun MEL 44,592,999 39,917,024 4,675,975 199,869 30,307,J. 8 *Italic Projects open but not in CIB for 19/20 Not in 19/20 Budget. New projects opened in Sept.2019. Funds transferred from Contingency 9990 October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 78 of 168 Page 15 of 36 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:9/30/2019 PERIOD 3/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 TYPE GI General Im roveme 8207 General Security and Access $ 134,977 134,975 2 150,000 150,000 150,002 250 149,752 8230 Capital Legal Services 178,665 142,411 36,254 20,000 20,000 56,254 - 56,254 8236 District Easements 258,047 224,799 33,248 75,000 75,000 108,248 8,385 99,863 8240 IT Development 2,738,794 2,456,461 282,333 500,000 500,000 782,333 25,693 756,640 8243 Server Room Relocation 2,000,000 1,351,513 648,487 - - 648,487 133,091 515,396 8249 CSO Dump Pad Modifications 60,000 12,409 47,591 - - 47,591 46,941 650 8250 ERP Replacement 600,000 - 600,000 3,105,000 3,105,000 3,705,000 201,050 3,503,950 8251 Capital improvement program&Budget Improvement - - - 350,000 350,000 350,000 49,969 300,031 **8252 POB E.V.Charging Station - - - - 30,000 30,000 30,000 334 29,666 8516 District Equipment Acquisition 876,000 798,811 77,189 100,000 100,000 177,189 - 177,189 8517 Vehicle Replacement Program 1,849,000 821,691 1,027,309 1,069,000 1,069,000 2,096,309 1,007,910 1,088,399 9999 Capital Project Clearing(Accounting Use Only)** - (60,000)1 60,000 1 - - 1 60,000 450 1 59,550 Rounding (1) al FY 2019-20 GI Amount $ 8,695,483 5,883,070 2,812,413 5,369,000 30,000 5,399,000 8,211,413 1,474,073 6,737,33 Not in 19/20 Budget. New projects opened in July 2019. Funds transferred from Contingency 9990 October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 79 of 168 Page 16 of 36 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:9/30/2019 PERIOD 3/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 TYPE RW Recycled W 7306 Zone 1 Recycled Water 532,894 508,654 24,240 100,000 - 100,000 124,240 14,604 109,636 7346 ReW Distribution Sys Surge Analysis 205,000 152,921 52,079 - - - 52,079 6,605 45,474 7361 Filter Plant Improvments 2,537,000 1,343,105 1,193,895 3,452,000 - 3,452,000 4,645,895 531,281 4,114,614 7365 Recycle Water Clearwell Repairs 1,700,000 1,364,144 335,856 - - - 335,856 83,276 252,580 7366 ReW Distribution System Renov.Program 15,000 - 15,000 500,000 - 500,000 515,000 - 515,000 7368 Water Exchange Project 250,000 9,102 240,898 100,000 - 100,000 340,898 13,732 327,166 Rounding 13 tal FY 2019-20 RW Amount 5,239,894 3,377,926 1,861,968 4,152,000 4,152,000 6,013,968 649,498 5,364,483 9990 CONTINGENCY-ALL PROGRAMS - - - 895,000 (430,000) 465,000 465,000 465,000 GRAND TOTAL $ 75,161,793 66,668,272 8,493,521 66,176,000 - 66,176,000 74,669,521 9,740,422 64,929,137 October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 80 of 168 Page 17 of 36 A I B C D E F N O 1 FY 19-20 CAPITAL BUDGET TRANSFERS 2 PERIOD ENDING:9/30/19 position paper 06/20/19&GM GM Memo GM Memo GM Memo 08/22/19 09/24/19 09/27/19 memo 19/20 Contingency 3 PROD.# PROJECTS TOTAL Balance 4 5 **8252 POB E.V. Charging Station 30,000 30,000 6 **8462 SR Pump station Flow Diversion 200,000 200,000 7 **7373 Fire Protection System Ph. 3 200,000 200,000 8 *8451 C.S.Sewer Renovation (2,000,000) (2,000,000) 9 *8458 Martinez Sewer Ren. Ph. 6 500,000 500,000 10 *8459 Lafayette Sewer Ren. Ph. 14 500,000 500,000 11 *8460 W.C.Sewer Renov. Ph. 14 500,000 500,000 12 *8461 So. Orinda Sewer Ren. Ph.8 500,000 500,000 38 39 40 41 42 9990 Capital Projects-Contingency (30,000) (200,000) (200,000) - (430,000) 465,000 43 46 47 - 65 ** New project-not in 19/20 Budget 66 * Not actual transfers. All part of one project split into individual projects for construction October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 81 of 168 Page 18 of 36 O&M PROJECTS-EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 09/30/19 3/2020 OM043- Naval Weapons Station Prior years Project expended Expenditure type through 18-19 1 Jul.'19 Aug.'19 Sept.'19 Oct.'19 Nov.'19 Dec.'19 Jan.'20 Feb.'20 Mar.'20 Apr.'20 May'20 Jun.'20 2019-20 YTD to date Salary&Benefits $ 17,429 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 17,429 Technical Services $ 75,169 1,938 - 6,255 - - - - - - - - - 8,193 $ 83,361 Total $ 92,598 $ 1,938 $ - $ 6,255 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 8,193.1$ 100,790 OM080 -CoCo Farm(Kiewit Future Farm Proposal) Prior years Project expended Expenditure type I through 18-19 Jul.'19 Aug.'19 Sept.'19 Oct.'19 Nov.'19 Dec.'19 Jan.'20 Feb.'20 Mar.'20 Apr.'20 May'20 Jun.'20 2019-20 YTD to date Salary&Benefits $ 210,665 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 210,665 Other Charges $ 74,996 - - - - - - - - - - - - - $ 74,996 Total $ 285,661 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 285,661 OM083- Refinery Recycled Water Exchange Prior years Project expended Expenditure type through 18-19 Jul.'19 Aug.'19 Sept.'19 Oct.'19 Nov.'19 Dec.'19 Jan.'20 Feb.'20 Mar.'20 Apr.'20 May'20 Jun.'20 2019-20 YTD to date Salary&Benefits $ 84,070 $ 8,921 $ 7,080 $ 5,452 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 21,453 $ 105,522 other Charges $ - - - - - - - - - - - $ - Total $ 84,070 $ 8,921 $ 7,080 $ 5,452 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 21,453 $ 105,522 October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 82 of 168 Page 19 of 36 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS SEPTEMBER,2019 INVESTMENTS (cents omitted) INTEREST INCOME DATE OF Days to ANNUAL CASH B.O.M. PURCHASE E.O.M. E.O.M. %of CURRENT B.O.M. E.O.M. NO. ISSUER TYPE PURCHASE MATURITY Maturity YIELD OUTLAY FACE VALUE (MATURITY) FACE VALUE MKT VALUE Portfolio MONTH CUMULATIVE CUMULATIVE 519 State of Calif. LAIF 8/86-2/90 ---- 1 (1) $22,000,000 $17,000,000 $5,000,000 $22,000,000 $22,058,641 42.31% $35,761.64 $98,428.96 $134,190.60 944 T-Bill US Tbill 3/21/19 9/19/19 0 2.50 4,938,575 5,000,000 (5,000,000) 0 0 0.00% 6,075.00 20,925.00 27,000.00 945 FHLB Agency Gov 4/3/19 10/1/19 1 2.44 4,940,169 5,000,000 5,000,000 4,999,750 9.62% 9,916.67 20,494.44 30,411.11 946 FHLMC Fed Agency 5/28/19 11/12/19 43 2.37 4,946,100 5,000,000 5,000,000 4,988,750 9.62% 9,625.00 19,891.66 29,516.66 947 FHLB FHLB Note 6/13/19 12/11/19 72 2.20 4,946,077 5,000,000 5,000,000 4,981,200 9.62% 8,937.50 19,028.33 27,965.83 948 FHLB Govt/FHLB 6/21/19 11/18/19 49 2.02 4,957,917 5,000,000 5,000,000 4,987,200 9.62% 8,416.67 17,618.20 26,034.87 949 FHLB Fed Agency 9/18/19 03/20/20 172 1.90 4,952,722 0 5,000,000 5,000,000 4,956,050 9.62% 3,340.28 0.00 3,340.28 950 FHLB Fed Agency 9/18/19 03/18/20 170 1.91 4,952,983 0 5,000,000 5,000,000 4,956,550 9.62% 3,358.33 0.00 3,358.33 0 (4) $56.634.543 $42.000.000 $0 $52,000,000 $51.928.141 100.00% $85,431.09 $196,386.59 $281,817.68 (3) (5) 31,925.55 31,925.55 $85.431.09 $228.312.14 $313.743.23 NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The yield as of September 2019 was 2.290%. (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 2.317%. The weighted average maturity is.13 years. (4) The market value of the portfolio on September 30,2019 was$51,928,141. GASB 31 requires adjusting investments to market value. The District will adjust annually,but report market values monthly. (5) The District has sufficient funds available combined with secured SSC and Property Tax received in December and April to cover six months of cash flow needs. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 83 of 168 Page 20 of 36 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:002-SEWER CONSTRUCTION(Capital) September 2019 Fiscal Period 3/2020 Summarized by Account Report Generated on Oct 8,2019 7:49:23 AM TOTAL ASSETS Current Assets CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003 CASH ACCOUNTS/CASH $445,562 CASH ACCOUNTS/TEMPORARY INVESTMENTS $52,000,000 DUE FROM/DUE FROM DEBT FUND $2,560,570 DUE FROM/DUE FROM RIE $85,351 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $64,245 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $134,191 RECEIVABLE ACCOUNTS/CAD RECEIVABLE $394,662 Current Assets $56,504,584 Net Property,Plant and Equipment FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS 59,740,440 Net Property,Plant and Equipment $9,740,440 TOTAL ASSETS $66,245,024 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($1,293) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,472,736) CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($691,093) CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($158,036) DUE TO/DUE TO R/E ($2,820,893) LIABILITIES/UNEARNED INTEREST ($135,690) Total Liabilities ($5,279,742) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($9,740,440) FUND EQUITY/AVAILABLE FUND BALANCE ($58,414,909) FUND EQUITY/EXPENDITURE SUMMARY $9,740,440 YEAR TO DATE REVENUES/REVENUE SUMMARY ($2,550,374) Total Fund Equity ($60,965,283) TOTAL LIABILITIES AND FUND EQUITY ($66,245,024) Page 21 of 36 A001' Central Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE September 2019 Fiscal Period 3/2020 Report Generated on Oct 8, 2019 7:54:50 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $16,741 $12,987 -22.4% $875,223 $884,961 1.1% $1,025,900 $140,939 86.3% Total Revenue $16,741 $12,987 -22.4% $875,223 $884,961 $1,025,900 $140,939 86.3% Page 22 of 36 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE September 2019 Fiscal Period 03/2020 Report Generated on Oct 8, 2019 7:52:49 AM $140,000 ❑Period Budget $400,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $120,000 $ $100,000 300,000 $80,000 $200,000 $60,000 $40,000 $100,000 $20,000 $0 $0 L�= 1-1 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $76,972 $121,877 ($44,905) $380,916 $373,794 $7,122 Totals $76,972 $121,877 ($44,905) $380,916 $373,794 $7,122 Page 23 of 36 CENTRAL CONTRA COSTA SANITARY DISTRICT SELF-INSURANCE FUND TEMPORARY INVESTMENTS SEPTEMBER,2019 INVESTMENTS (cents omitted) INTEREST INCOME DATE OF Days to ANNUAL CASH B.O.M. PURCHASE E.O.M. E.O.M %of CURRENT B.O.M. E.O.M. NO. ISSUER TYPE PURCHASE MATURITY Maturity YIELD OUTLAY FACE VALUE (MATURITY) FACE VALUE MKT VALUE Portfolio MONTH CUMULATIVE CUMULATIVE 519 State of Calif. LAW 10/99- ------- 1 (1) $6,900,000 $6,900,000 $6,900,000 $6,955,904 100.00% $12,987.12 $27,425.85 $40,412.97 (3) $6,900,000 $6,900,000 $0 $6,900,000 $6,955,904 100.00% $12,987.12 $27,425.85 $40,412.97 (2) (4) $0.00 $12,987.12 $27,425.85 $40,412.97 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of September,2019 was 2.290%. (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 2.290°/x. (4) The market value of the portfolio on September 30,2019 was$6,955,904. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 87 of 168 Page 24 of 36 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:003-SELF-INSURANCE September 2019 Fiscal Period 3/2020 Summarized by Account Report Generated on Oct 8,2019 7:49:23 AM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $1,022,265 CASH ACCOUNTS/TEMPORARY INVESTMENTS $6,900,000 DUE FROM/DUE FROM R/E $825,000 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $40,413 Current Assets $8,787,678 TOTAL ASSETS $8,787,678 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/ACCOUNTS PAYABLE ($650) CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($1,157,797) DUE TO/DUE TO R/E ($939,042) Total Liabilities ($2,097,489) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $202,052 FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000) FUND EQUITY/EXPENDITURE SUMMARY $373,794 FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,381,074) YEAR TO DATE REVENUES/REVENUE SUMMARY ($884,961) Total Fund Equity ($6,690,189) TOTAL LIABILITIES AND FUND EQUITY ($8,787,678) Page 25 of 36 AOO Ls entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004- DEBT SERVICE September 2019 Fiscal Period 3/2020 Report Generated on Oct 8, 2019 7:54:50 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $0 $0 0.0% $0 $0 0.0% $2,982,415 $2,982,415 0.0°% Total Revenue $0 0.0% $2,982,415 $2,982,415 0.0% Page 26 of 36 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE September 2019 Fiscal Period 03/2020 Report Generated on Oct 8, 2019 7:52:49 AM $80,000 ❑Period Budget $500,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $400,000- $60,000-/ $300,000- $40,000-'-- $200,000- $20,000- $100,000- $0- 300,000$40,000 $200,000$20,000 $100,000$0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $69,784 $0 $69,784 $209,352 $432,757 ($223,405) Totals $69,784 $0 $69,784 $209,352 $432,757 ($223,405) Page 27 of 36 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:004-DEBT SERVICE September 2019 Fiscal Period 3/2020 Summarized by Account Report Generated on Oct 8,2019 7:49:23 AM TOTAL ASSETS Current Assets L.T.DEBT ACCOUNTING/REVENUE BOND RESERVE CASH ($52) Current Assets ($52) TOTAL ASSETS ($52) TOTAL LIABILITIES AND FUND EQUITY Total Liabilities DUE TO/DUE TO S/C ($2,560,570) L.T.DEBT ACCOUNTING/BOND ACR INTEREST PAYABLE ($288,505) L.T.DEBT ACCOUNTING/BONDS PAYABLE ($17,305,000) Total Liabilities ($20,154,075) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $22,078,000 FUND EQUITY/EXPENDITURE SUMMARY $432,757 LIABILITIES/DEFERRAL-BOND REFUNDING ($2,356,631) Total Fund Equity $20,154,126 TOTAL LIABILITIES AND FUND EQUITY $52 Page 28 of 36 DASHBOARD DATA (SELECTED DATA ON MATTERS OF CONTINUING BOARD INTEREST) October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 92 of 168 Page 29 of 36 PENSION AND OPEB LIABILITY AND FUNDING STATUS Pension OPEB Million $160 100% Million $90 100% $140 90% $80 90% 80% $70 80% $120 70% $60 70% $100 60/0 $50 60% 50% $80 50% $40 40% $60 40% $30 30% 30% $20 20% $40 0 $10 10% $20 20/o 10% $0 0% N rn Ln ,o I- oo $0 0% O O O O O O O 1 N N N N N N N Q1 ,LOQ ,y0� ,LOQ ,y0� ,LO, ,LOQ ,LOQ ,LOQ O o N N UAAL Funded% UAAL Funded% Notes: * Pension:2018 figure is based on CCCERA valuation presented 10/9/2019 to CCCERA Board. ** OPEB-Valuations projected liabilities less assets as of June 30 of that year *** Pension funded percentage excludes Section 115 Trust Assets(established in FY 2017-18). ****June 2019 OPEB figure is market value of OPEB assets/Jan 2019 actuarial accrued liability October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 93 of 168 Page 30 of 36 COMPONENTS OF THE PENSION URAL $74 MILLION AS OF 2018 CCCERA VALUATION ($74 MILLION IS UNCHANGED FROM 2017) Assumption Change U J Q a L1 014 forward) L � 0 a U M LL Additional UAAL Prepayment to CCCERA Subsequent Actuarial Losses J a a t Restart of Amortization t10 N vDiscount Rate from 7.75%to 7.25% L U N ■i O Depooling Implementation U M LL Actuarial Losses from 2008-2012 $(30,000,000) $(20,000,000) $(10,000,000) $ $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 Notes: • Pension Pre-Funding Trust assets of$8.4 million (with another$1.25 million pending) are available to further reduce UAAL indicated above. October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 94 of 168 Page 31 of 36 PENSION UAAL PROJECTION Anticipated UAAL with Schedule Amortization (Blue) and with Additional UAAL Payments to Pension Prefunding Trust to Date and at $1.25 million prospectively (Red) millions $80 $60 $40 $20 $0 rrn 1 LJ_lJ ($20) ($40) 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 ■Unfunded Liability(2018 Valuation) $74 $66 $59 $50 $40 $34 $27 $19 $10 $0 O Net UAAL(2018 Valuation) 69 58 49 38 26 18 11 2 (8) (19) with Pension prefunding Trust offset Notes: • Based on 2018 CCCERA Valuation. • Chart shows scheduled amortization of UAAL(over 18 years for each annual layer of historic UAAL),assuming no additional UAAL is generated. • Second bar shows UAAL offset by Pension Prefunding Trust balance,with continuing$1.25 million discretionary contributions through 2023. October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 95 of 168 Page 32 of 36 PROJECTED UAAL WITH PENSION PREFUNDING TRUST: PROGRESS IN ABOUT $6.4 MILLION BEHIND SCHEDULE DUE TO NEW 2018 LAYER ADDED TO UAAL 80 $ in Millions 60 40 20 X. � �-LH - HI (20) (40) 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 0 Net UAAL(2018 Valuation) with Pension prefunding Trust offset 69 58 49 38 26 18 11 2 (8) (19) F Net UAAL(2017 Valuation) $62 $52 $43 $33 $20 $13 $5 ($4) ($14) ($25) with Pension prefunding Trust offset Notes: • An additional$6.4 million was added to the UAAL due to actuarial loss($5.3 million)and assumption changes($1.1 million)in the CCCERA valuation for 2018 presented to the CCCERA Board on 10/9/2019. • The CCCERA UAAL remained essentially constant at$74 million as of the 2017 and 2018 valuations. The above chart shows the current outlook for reducing UAAL based on the 2018 valuation versus the outlook as of the 2017 valuation. The CCCERA UUAL has also been reduced by the actual& projected Pension Prefunding Trust balance. October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 96 of 168 Page 33 of 36 CIB TRANSFERS=CURRENT YEAR #of transfers Cause for Transfers Total Original Project Budgets Compared to Transfers 5 $2,000,000 4 $1,800,000 3 $1,600,000 2 $1,400,000 1 $1,200,000 0 $1,000,000 $800,000 ■ W no ■ c ■ o u ■ a ■ v c o p a O o O v a1 V j CL ub�D m ' a s 3 v v $600,000 Q N a) C C u a v o QU Op z Q O ns 3 > d 3 U .'- 0 0 � z LL E $400,000 o s F.Cost exceeded initial budget w E.New project scope C6 $200,000 D.New Project ~ C.Developer/CAD or other cost neutral B.Cashflow accelerations $ s A.Bundling/Unbundling ao ak0z O�� act <1 Al Notes: There were 5 transfers in September 2019;four were project unbundlings(8458 Martinez Sewer Renovation Ph.6......8459 Lafayette Sewer Renovation Ph. 14.....8460 WC Sewer Renovation Phase 14.....8461 S.Orinda Sewer Renovation Ph.8,and one was a new project: DP7373 Fire Protection System Ph.3) October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 97 of 168 Page 34 of 36 CIB TRANSFERS SINCE FY 2016=17 #of Cause for Transfers Total Original Project Budgets Compared to Transfers transfers 16 $60,000,000 14 12 $50,000,000 10 $40,000,000 8 6 $30,000,000 4 2 $20,000,000 0 ,$10,000,000 F.Cost exceeded initial budget E.New project scope D.New Project ■ m ■ o ■ o ■ v ■ a ■v C.Developer/CAD or other cost neutral - _ �— ° g v B.Cashflow accelerations xm v v A.Bundling/Unbundling o u o o m v p u:« \ > 3 LL u October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 98 of 168 Page 35 of 36 FY 2019-20 Running Expense Fund Total Cash & Investment Balances (Actuals through September 2019) $60.0 $53.7 $50.0 - S47.2 $48.6 $49.8 $43.4 $40.9 $40.0 $37.3 $38.2 $38.4 $33.8 $32.9 $30.0 $29.0 $28.2 $24.6 $24.2 $24.0 $20.0 $17.6 $18.9 $10.0 $0.0 41 ��J �y� Z, e� e� e� �� t3 00 4,11P N �eQ 4 �04 el Fe =Projected Balance* MActual Balance Reserve Target at Year End** NOTES: * Projected balances were generated in June 2019 based on budgeted revenues and expenses for FY 2019-20 and applied to the actual balance at Jun 30,2019 **The Reserve Target at Year End is the minimum balance required at June 30, 2020 to comply with the District Policy October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 99 of 168 Page 36 of 36 FY 2019-20 Sewer Construction Fund Total Cash & Investment Balances (Actuals through September 2019) $70.0 $62.5 �` $61.6 +'60'0 $52.4$56.3 $58.3 $52.3 $51.9 $52.6 $54.0 $52.1 $50.0 $49.8 $47.0 $48.1 $56.1 $47.6 $43.2 $40.0 $39.2 $30.0 $32.0 $30.4 $20.0 $10.0 $0.0 e� e > Pte$ � �e�� ce4p� MProjected Balance* MActual Balance —Reserve Target at Year End** NOTES: * Projected balances were generated in June 2019 based on budgeted revenues and expenses for FY 2019-20 and applied to the actual balance at Jun 30,2019 **The Reserve Target at Year End is the minimum balance required at June 30, 2020 to comply with the District Policy October 22, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 100 of 168