The URL can be used to link to this page

Home My WebLink About06. Receive July 2019 Financial Statements and Investment Reports Page 1 of 36 Item 6. ,jjlk CENTRAL SAN CENTRAL CONTRA COSTA SANITARY DISTRICT September 5, 2019 TO: HONORABLE BOARD OF DIRECTORS FROM: CHRISTOPHER 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: RECEIVE JULY2019 FINANCIAL STATEMENTS AND INVESTMENT REPORTS Attached for review are the Financial Statements and Investment Reports for the month of July 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. Although early in the fiscal year, J my 2019 budgetary results for the O&M, Sewer Construction, Self Insurance, and Debt Service funds suggest current year activities to date are generally on target with no noteworthy or alarming unfavorable budgetary variances identified at this time. Staff will continue to monitor the budget closely throughout the fiscal year and bring any matters requiring budgetary direction and action to the Board at a later date as necessary. Receipt of the July 2019 Financial Statements is recommended by the Finance Committee. Strategic Plan re-In GOAL THREE: Be a Fiscally Sound and Effective Water Sector Utility Strategy 2- Manage costs ATTACHMENTS: 1. July 2019 Financial Statements and Investment Reports September 5, 2019 Regular Board Meeting Agenda Packet- Page 57 of 201 Pale 1 of 35 CENT CONTRA COSTA SANITARY DISTRICT August 19,2019 TO: THE BOARD OF DIRECT VIA: KEVIN MIZUNO W, FROM: CHRIS THOMAS C-7 SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through period ending July 31,2019 YTD Total FY YTD YTD Fav/(Unfav) O&M Revenues: Budget Budgeted Actual Variance Explanation Total $ 89,560,370 $ 531,895 $ 499,262 $ (32,633) No significant variance O&M Expenses: Total Labor Charges $ 52,789,084 $ 4,342,671 $ 4,250,833 $ 91,838 Some positions budgeted for in July are filled later in the fiscal year resulting in savings. Chemicals 1,620,000 134,997 22,210 112,787 Chemical consumption lower than budgeted. Utilities 4,209,350 350,773 41,565 309,208 Lower due to delay in invoices. Repairs&Maintenance 5,242,867 436,883 133,713 303,170 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 72,850 1,052 71,798 Lower due to delay in invoices. Outside Services 3,639,547 369,092 221,488 147,604 Lower due to delay in invoices. Materials&Supplies 2,152,127 179,299 76,149 103,150 Budget is spread evenly throughout the year, however actual activity occurs sporadically every month. Variance should be minimal by year end. Other Expenses 2,464,834 84,861 27,786 57,075 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 1,036,383 933,224 103,159 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 935,895 845,068 90,827 Minor variances for multiple account categories. Total $ 87,584,775 $ 7,943,704 $ 6,553,088 $ 1,390,616. September 5, 2019 Regular Board Meeting Agenda Packet- Page 58 of 201 Page 2 of 35 j&W lics entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 001 - RUNNING EXPENSE(O&M) July 2019 Fiscal Period 1/2020 Report Generated on Aug 19, 2019 8:14:05 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $0 ($45,667) 0.0% $0 ($45,667) 0.0% $14,570,000 $14,615,667 -0.3% HHW $8,000 $5,935 -25.8% $8,000 $5,935 -25.8% $968,000 $962,065 0.6% Other $414,729 $415,628 0.2% $414,729 $415,628 0.2% $4,931,500 $4,515,872 8.4% Sewer Service Charges $109,166 $123,366 13.0% $109,166 $123,366 13.0% $69,090,870 $68,967,504 0.2% Total Revenue $531,895 $499,262 -6.1% $531,895 $499,262 -6.1% $89,560,370 $89,061,108 0.6% Page 3 of 35 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 -RUNNING EXPENSE(O&M) July 2019 Fiscal Period 01/2020 Report Generated on Aug 19, 2019 8:12:50 AM $8,000,000.00 Budget $7,943,704 Actual $7,000,000.00 $6,553,088 $6,000,000.00 $5,000,000.00 $4,000,000.00 $3,000,000.00 $2,000,000.00 $1,000,000.00 $0.00 Jul(1)2019 Fiscal Periods Page 4 of 35 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE(O&M) July 2019 Fiscal Period 01/2020 Report Generated on Aug 19, 2019 8:12:50 AM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $3,152,929 $3,002,415 $150,514 4.8% $3,152,929 $3,002,415 $150,514 4.8% $38,060,443 7.9% EMPLOYEE BENEFITS $1,560,433 $1,630,990 ($70,557) -4.5% $1,560,433 $1,630,990 ($70,557) -4.5% $19,177,010 8.5% CAPITALIZED ADM OVERHEAD ($370,691) ($382,572) $11,881 -3.2% ($370,691) ($382,572) $11,881 -3.2% ($4,448,369) 8.6% DIRECTOR FEES&EXPENSES $12,053 $10,534 $1,519 12.6% $12,053 $10,534 $1,519 12.6% $144,650 7.3% CHEMICALS $134,997 $22,210 $112,787 83.5% $134,997 $22,210 $112,787 83.5% $1,620,000 1.4% UTILITIES $350,773 $41,565 $309,208 88.2% $350,773 $41,565 $309,208 88.2% $4,209,350 1.0% REPAIRS&MAINTENANCE $436,883 $133,713 $303,170 69.4% $436,883 $133,713 $303,170 69.4% $5,242,867 2.6% HAULING&DISPOSAL $98,842 $9,534 $89,308 90.4% $98,842 $9,534 $89,308 90.4% $1,186,175 0.8% PROFESSIONAL&LEGAL SERV $72,850 $1,052 $71,798 98.6% $72,850 $1,052 $71,798 98.6% $874,300 0.1% OUTSIDE SERVICES $369,092 $221,488 $147,604 40.0% $369,092 $221,488 $147,604 40.0% $3,639,547 6.1% SELF-INSURANCE EXPENSE $825,000 $825,000 $0 0.0% $825,000 $825,000 $0 0.0% $825,000 100.0% MATERIALS&SUPPLIES $179,299 $76,149 $103,150 57.5% $179,299 $76,149 $103,150 57.5% $2,152,127 3.5% OTHER EXPENSES $84,861 $27,786 $57,075 67.3% $84,861 $27,786 $57,075 67.3% $2,464,834 1.1% UNFUNDED LIABILITIES $1,036,383 $933,224 $103,159 10.0% $1,036,383 $933,224 $103,159 10.0% $12,436,841 7.5% Total Expenses $7,943,704 $6,553,088 $1,390,616 17.5% $7,943,704 $6,553,088 $1,390,616 17.5% $87,584,775 7.5% Color Key: 0 to 10%over budget > 10%over budget M Page 5 of 35 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE (O&M) July 2019 Fiscal Period 01/2020 Report Generated on Aug 19, 2019 8:15:04 AM $3,000,000 ❑Period Budget $3,000,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $2,500,000 $2,500,000- $2,000,000 $2,000,000- $1,500,000- $1,500,000- $1,000,000- $1,000,000- $500,000- $500,000 $0 $0 LL ?-k�G� `�\G° �\ ° Q��c e�Q��e S�P��° �� Pa `5�� G°��°��° Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $2,690,691 $2,408,837 $281,854 $2,690,691 $2,408,837 $281,854 ENGINEERING $1,354,963 $1,180,479 $174,484 $1,354,963 $1,180,479 $174,484 COLLECTION SYSTEM OPS. $1,247,796 $999,070 $248,726 $1,247,796 $999,070 $248,726 PLANT OPERATIONS $2,276,829 $1,678,140 $598,689 $2,276,829 $1,678,140 $598,689 PUMP STATIONS $241,210 $168,048 $73,162 $241,210 $168,048 $73,162 RECYCLED WATER $132,215 $118,516 $13,699 $132,215 $118,516 $13,699 Totals $7,943,704 $6,553,088 $1,390,616 $7,943,704 $6,553,088 $1,390,616 Page 6 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT RUNNING EXPENSE FUND TEMPORARY INVESTMENTS July,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) $12,000,000 $15,000,000 ($3,000,000) $12,000,000 $12,020,541 100.00% $29,721 $0 $29,721 RE09 FHLB FED AGENCY 12/24/18 7/22/19 0 2.558% 5,000,000 (5,000,000) 0.00% 7,263 7,263 RE10 FHLB FED AGENCY 12/24/18 7/23/19 0 2.558% 5,000,000 (5,000,000) 0.00% 7,608 7,608 RE11 FHLMC FED AGENCY 3/4/19 7/23/19 0 2.443% 5,000,000 (5,000,000) 0.00% 7,394 7,394 RE12 FHLB FED AGENCY 3/22/19 7/23/19 0 2.410% 5,000,000 (5,000,000) 0.00% 7,364 7,364 (3) $12,000,000 $35,000,000 ($23,000,000) $12,000,000 $12,020,541 100.00% 59,350 59,350 (2) $59,350 $0 $59,350 NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The yield as of July,2019 was 2.379%. (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.4437%. (4) The market value of the portfolio on July,2019 wa!$12,020,541. (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 September 5, 2019 Regular Board Meeting Agenda Packet- Page 63 of 201 Page 7 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) July 2019 Fiscal Period 1/2020 Summarized by Account Report Generated on Aug 19,2019 8:06:06 AM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $12,187,455 CASH ACCOUNTS/PAYROLL CLEARING $20,000 CASH ACCOUNTS/PETTY CASH $3,400 CASH ACCOUNTS/TEMPORARY INVESTMENTS $12,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 $866,183 INVENTORY/SUPPLIES&MATERIAL INV $2,147,077 PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104 PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572 PREPAID ACCOUNTS/PREPAID EXPENSES $13,918 PREPAID ACCOUNTS/PREPAID INSURANCE $456,492 PREPAID ACCOUNTS/PREPAID RETIREMENT $16,798,678 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $2,469 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $16,515,972 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA ($4,095) RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $29,721 RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $14,726 RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $101,362 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $1,026 Current Assets $82,734,480 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 $760,127,415 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($6,801) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,865,673) CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($5,047,603) Page 8 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) July 2019 Fiscal Period 1/2020 Summarized by Account Report Generated on Aug 19,2019 8:06:06 AM CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,258,104) CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($36,085) CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($1,266) CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931) CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING ($1,664) CURRENT LIABILITIES/PERMIT CLEARING ($1,329) CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($42,080) CURRENT LIABILITIES/RETIREMENT CONTRIB W/H $3 CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $800,416 DEF.COMP.CONTRIB W/H/ICMA 457/401A ($19,382) DEF.COMP.CONTRIB W/H/ICMA TIER III HRA $19,499 DUE TO/DUE TO S/C ($54,873) DUE TO/DUE TO S/I ($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,420,816 LIABILITIES/UNEARNED INTEREST $0 MEDICAL LIABILITIES/CALPERS MEDICAL $480,155 MEDICAL LIABILITIES/DELTA DENTAL $117 MEDICAL LIABILITIES/DISABILITY INS $6,620 MEDICAL LIABILITIES/HEALTH NET $335,765 MEDICAL LIABILITIES/KAISER PERMANENTE ($337,108) MEDICAL LIABILITIES/LIFE INS $6,147 MEDICAL LIABILITIES/OCCUPATIONAL HEALTH ($1,001) MEDICAL LIABILITIES/VSP VISION CARE ($11) REIMBURSEMENT FEES ($71,318) Total Liabilities ($137,872,777) 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 $6,553,088 FUND EQUITY/GENERAL FIXED ASSET GROUP ($225,386,993) FUND EQUITY/STATE R FED CAPITAL GRANT ($75,301,279) YEAR TO DATE REVENUES/REVENUE SUMMARY ($499,262) Total Fund Equity ($622,254,638) TOTAL LIABILITIES AND FUND EQUITY ($760,127,415) Page 9 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT August 19,2019 TO: THE BOARD OF DIRPeTQRS VIA: KEVIN MIZUNO FROM: CHRIS THOMAS SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending July 31,2019: YTD Total FY YTD YTD Fav/(Unfav) SIC Revenues: Budget Budgeted Actual Variance Explanation Facilities Capacity Fees, Interest income received was Total $ 65,598,130 $ 602,413 $ 832,440 $ 230,027 higher than budgeted. Total FY YTD YTD YTD S/C Expenses: Budget" Budgeted Actual Remaining %Spent Total $ 74,669,521 $ 2,066,477 $ 1,627,894 $ 438,583 78.78% ' Includes 18119 carry-over($8,493,521) September 5, 2019 Regular Board Meeting Agenda Packet- Page 66 of 201 Page 10 of 35 AWLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 002-SEWER CONSTRUCTION (Capital) July 2019 Fiscal Period 1/2020 Report Generated on Aug 19, 2019 8:14:05 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 $774,917 28.6% $602,413 $774,917 28.6% $21,749,000 $20,974,083 3.6% Sewer Service Charges $0 $57,523 0.0% $0 $57,523 0.0% $32,219,130 $32,161,607 0.2% Total Revenue $602,413 $832,440 38.2% $602,413 $832,440 38.2% $65,598,130 $64,765,690 1.3% Page 11 of 35 Sewer Fund (Capital) Spending FY 19-20 $2,500,000 $2,066,477 $2,000,000 $1,500,000 $1,627,894 $1,000,000 $500,000 July -Projected* -Actual Columnl July Projected* $ 2,066,477 Actual 1,627,894 *Projected-Current year budget allocated by month based on historical spending in previous 2 years September 5, 2019 Regular Board Meeting Agenda Packet- Page 68 of 201 Page 12 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:7/31/2019 PERIOD 1/2020 (A-B) D E G(C+D+E) H I(F-G) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN 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 - 27,129,000 26,272,165 455,064 25,817,128 TYPE TP Treatment Plant 44,592,999 39,917,024 4,675,975 28,631,000 - 28,631,000 33,306,975 578,999 32,727,971 TYPE GI General Improvements 8,695,483 5,883,070 2,812,413 5,369,000 30,000 5,399,000 8,211,413 519,320 7,692,088 TYPE RW Recycled Water 5,239,894 3,377,926 1,861,968 4,152,000 - 4,152,000 6,013,968 74,511 5,939,476 CIB Contingency - - 895,000 (30,000) 865,000 865,000 - 865,000 AL DISTRICT $ 75,161,793 $ 66,668,272 $ 8,493,521 $ 66,176,000 $ $ 66,176,000 r 1,627,894 $ 73,041,66 N:\Accounting\GMTEMPI\Financials and Closing\2020 Financials\Capital Project report-FY 19 20.xlsx July 19 September 5, 2019 Regular Board Meeting Agenda Packet- Page 69 of 201 Page 13 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:7/31/2019 PERIOD 1/2020 (A-B) D E G(C+D+E) H I(F-G) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN 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 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 387,740 *6602 South Jackson CAD 411,290 391,290 20,000 - - 20,000 - 20,000 *6603 North Jackson CAD 276,557 53,313 223,244 223,244 223,244 6679 Coredell Drive CAD 123,443 54,906 68,537 - - 68,537 - 68,537 *7367 Concord Main Metering Station 250,000 245,826 4,174 4,174 1,797 2,377 8419 Collection System Planning LT 985,000 984,958 42 200,000 200,000 200,042 11,600 188,442 8436 Moraga/Crossroads PS Project 3,747,000 3,218,526 528,474 4,600,000 4,600,000 5,128,474 36,542 5,091,932 8441 CIPP Contract 17-20 400,000 275,923 124,077 200,000 200,000 324,077 1,175 322,902 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 12,036 306,378 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 - 160,625 8449 Collection System Modeling Support 200,000 130,135 69,865 103,000 103,000 172,865 2,359 170,506 8450 Development Sewerage Support 1,130,000 1,309,893 (179,893) 900,000 900,000 720,107 79,586 640,521 8451 C.S.Sewer Renovation 62,527 - 62,527 4,473,000 4,473,000 4,535,527 - 4,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 64,904 2,690,635 8454 So.Orinda Sewer Ren.Ph.7 500,000 860,185 (360,185) 3,637,000 3,637,000 3,276,815 26,128 3,250,687 8455 W.C.Sewer Renov.Ph.13 500,000 2,604,854 (2,104,854) 3,621,000 3,621,000 1,516,146 69,180 1,446,966 8456 Danville Sewer Ren.Ph.3 500,000 381,637 118,363 4,100,000 4,100,000 4,218,363 7,891 4,210,472 8457 Pump Station Upgrades-Ph.2 50,000 - 50,000 500,000 500,000 550,000 - 550,000 *8458 Martinez Sewer Renov.Ph.6 100,000 11,405 88,595 - 88,595 29,352 59,243 *8459 Lafayette Sewer Renov.Ph.14 100,000 24,336 75,664 - - 75,664 41,464 34,200 *8460 WC Sewer Renov.Ph.14 100,000 53,907 46,093 46,093 32,632 13,461 *8461 So.Orinda Sewer Ren.Ph.8 100,000 43,621 56,379 - - 56,379 38,418 17,961 Rounding 27 lftal FY 2019-20 CS Amount 16,633,417 17,490,252 (856,835) 27,129,000 27,129,000 26,272,165 455,064 25,817,1 *Italic Projects open but not in CIB for 19/20 TYPE TP Treatment Pla *6172 Sludge Blending Tank Repair 776,000 - 776,000 - - 776,000 246 775,754 7292 Switchgear Refurbishment-Ph.2 684,548 473,274 211,274 200,000 200,000 411,274 - 411,274 7304 Instr&Controls PLC Upgrade 500,000 470,528 29,472 - 29,472 11 29,461 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 85,135 518,404 *7320 Plant Energy Optimization 1,094,000 1,004,604 89,396 - - 89,396 11 89,385 *7322 Fire Protection System Ph.2 1,406,000 1,340,832 65,168 65,168 2,268 62,900 *7326 Equipment Replacement FY 15-FY 24 1,629,000 1,628,975 25 - - 25 59,852 (59,827) N:\Accounting\GMTEMPI\Financials and Closing\2020 Financials\Capital Project report-FY 19 2O.xlsx July 19 September 5, 2019 Regular Board Meeting Agenda Packet- Page 70 of 201 Page 14 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:7/31/2019 PERIOD 1/2020 (A-B) D E G(C+D+E) H I(F-G) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN 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 7327 Headwork's Screening Upgrade 8,305,000 8,304,264 736 - - 736 5,440 (4,704) 7328 Influent Pump Electrical improvements 610,000 431,527 178,473 800,000 800,000 978,473 12,515 965,958 7330 Piping Renovation Phase 9 3,180,000 3,127,343 52,657 - - 52,657 2,937 49,720 7339 T.Plant Control System 1/0 Replacement 1,370,000 1,286,269 83,731 1,100,000 11100,000 1,183,731 81 1,183,650 7341 WC/Grayson Creek Levee Rehab 100,000 76,528 23,472 200,000 200,000 223,472 41,280 182,192 7348 Solids Handling Facility Improvements 9,914,000 9,243,507 670,493 6,550,000 6,550,000 7,220,493 80,353 7,140,140 7349 Aeration&Energy Upgrade 1,500,000 749,790 750,210 3,500,000 3,500,000 4,250,210 51,720 4,198,490 7351 Mechanical&Concrete Renovation 5,044,000 5,534,806 (490,806) 6,400,000 6,400,000 5,909,194 140,017 5,769,177 7352 UV Disinfection Upgrades 500,000 294,751 205,249 600,000 600,000 805,249 6,175 799,074 7353 1 Outfall Improvements Ph.7 100,000 1 54,551 1 45,449 1 500,000 1 1 500,000 545,449 1 7,652 1 537,797 N:\Accounting\GMTEMPI\Financials and Closing\2020 Financials\Capital Project report-FY 19 2O.xlsx July 19 September 5, 2019 Regular Board Meeting Agenda Packet- Page 71 of 201 Page 15 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:7/31/2019 PERIOD 1/2020 (A-B) D E G(C+D+E) H I(F-G) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN 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 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 - 662,142 *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 - 104,735 7360 Existing Plant Facility Drawing 200,000 158,215 41,785 100,000 100,000 141,785 4,411 137,374 7362 POB Seismic Upgrades 3,331,177 2,850,440 480,737 2,793,000 2,793,000 3,273,737 40,341 3,233,396 7363 Treatment Plant Planning 900,000 719,153 180,847 500,000 500,000 680,847 37,930 642,917 7364 TP Safety Enhancement Ph.5 100,000 10,000 90,000 600,000 600,000 690,000 246 689,754 7369 Piping Renovation-Phase 10 - 750,000 750,000 750,000 - 750,000 7370 Annual Infrastructure Replacement - - - 2,200,000 2,200,000 2,200,000 - 2,200,000 7371 Condition Assessment of Buried Pipelines - 250,000 250,000 250,000 250,000 Rounding (5) tal FY 2017-18 TP Amount 39,917,024 4 28,631,000 28,631,00 *Italic Projects open but not in CIB for 19/20 TYPE GI General Improvements 8207 General Security and Access $ 134,977 134,975 2 150,000 150,000 150,002 - 150,002 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 3,187 105,061 8240 IT Development 2,738,794 2,456,461 282,333 500,000 500,000 782,333 10,451 771,882 N:\Accounting\GMTEMPI\Financials and Closing\2020 Financials\Capital Project report-FY 19 2O.xlsx July 19 September 5, 2019 Regular Board Meeting Agenda Packet- Page 72 of 201 Page 16 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:7/31/2019 PERIOD 1/2020 (A-B) D E G(C+D+E) H I(F-G) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN 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 8243 Server Room Relocation 2,000,000 1,351,513 648,487 - - 648,487 14,496 633,991 8249 CSO Dump Pad Modifications 60,000 12,409 47,591 - 47,591 189 47,402 8250 ERP Replacement 600,000 - 600,000 3,105,000 3,105,000 3,705,000 8,500 3,696,500 8251 Capital improvement program&Budget Improvement - 350,000 350,000 350,000 - 350,000 **8252 POB E.V.Charging Station - - - - 30,000 30,000 30,000 - 30,000 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 482,047 1,614,262 9999 Capital Project Clearing(Accounting Use Only)** - (60,000) 60,000 - 60,000 450 59,550 Rounding (5) tal FY 2017-18 GI Amo 8,695,483 5,369,000 30,000 5,39 9,320 7,692,088 Not in 19/20 Budget. New projects opened in July 2019. Funds transferred fr Contigency 9990 TYPE RW Recycled Water N:\Accounting\GMTEMPI\Financials and Closing\2020 Financials\Capital Project report-FY 19 2O.xlsx July 19 September 5, 2019 Regular Board Meeting Agenda Packet- Page 73 of 201 Page 17 of 35 FY 19-20 CAPITAL BUDGET TRANSFERS PERIOD ENDING:7/31/19 position paper 06/20/19&GM memo 19/20 Contingency PROD.# PROJECTS TOTAL Balance 8252 POB E.V.Charging Station 30,000 30,000 9990 Capital Projects-Contingency (30,000) (30,000) 865,000 Total 865,0 September 5, 2019 Regular Board Meeting Agenda Packet- Page 74 of 201 Page 18 of 35 O&M PROJECTS- EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 07/31/19 1/2020 0M043 - 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 - - - - - - - - - - - 1,938 $ 77,106 Total $ 92,598 $ 1,938 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 1,9381$ 94,535 0M080 - CoCo Farm(Kiewit Future Farm Proposal) Prior years Project expended Expenditure type I through 18-19 1 Jul.'19 Aug.'19 Sept.'19 Oct.119 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 0M083 - Refinery Recycled Water Exchange 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 $ 84,070 $ 8,921 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 84,070 other Charges $ - - - - - - - - - - $ - $ - Total $ 84,070 1$ 8,921 $ $ $ $ $ $ $ $ $ $ $ $ $ 84,070 N:\Accounting\GMTEMPI\Financials and Closing\2020 Financials\O&M Projects Activity YTD 19 20.xlsx September 5, 2019 Regular Board Meeting Agenda Packet- Page 75 of 201 Page 19 of 35 Page 20 of 36 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS July, 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) $25,000,000 $29,500,000 ($4,500,000) $25,000,000 $25,042,795 43.10% $54,880 $0 $54,880 941 US Gov't T-Bill 2/28/19 8/29/19 28 2.49 3,950,860 4,000,000 4,000,000 3,994,000 6.90% 8,370 0 8,370 942 US Gov't T-Bill 3/4/19 8/29/19 28 2.50 3,951,742 4,000,000 4,000,000 3,994,000 6.90% 8,404 0 8,404 944 T-Bill US Tbill 3/21/19 9/19/19 49 2.50 4,938,575 5,000,000 5,000,000 4,986,550 8.62% 10,463 0 10,463 945 FHLB Agency Gov 4/3/19 10/1/19 61 2.44 4,940,169 5,000,000 5,000,000 4,982,200 8.62% 10,247 0 10,247 946 FHLMC Fed Agency 5/28/19 11/12/19 103 2.37 4,946,100 5,000,000 5,000,000 4,970,250 8.62% 9,946 0 9,946 947 FHLB FHLB Note 6/13/19 12/11/19 153 2.20 4,946,077 5,000,000 5,000,000 4,962,400 8.62% 9,793 0 9,793 948 FHLB Govt/FHLB 6/21/19 11/18/19 122 2.02 4,957,917 5,000,000 5,000,000 4,968,500 8.62% 8,921 0 8,921 (4) $57,631,440 $62,500,000 ($4,500,000) $58,000,000 $57,900,695 100.00% 121,024 0 121,024 (3), (6) (5) 0 $121,024 $0 $121,024 NOTE: (1) Annual Yield of Local Agency Investment Fund (LAIF)varies with the composition of the Fund. The yield as of July 2019 was 2.379%. (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.3792%. (4) The market value of the portfolio on July 31, 2019 was$57,900,695. 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. (6) There was an adjustment made to reduce the investment balance on the District's general ledger for year end in the amount of$8.5M. This was to reimburse the Running Expense Fund for Sewer Construction payroll related expenses that were paid out of the RE Fund's bank account throughout the year. The transfer will be made with the County Treasurer during August 2019. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. September 5, 2019 Regular Board Meeting Agenda Packet- Page 76 of 201 Page 20 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:002-SEWER CONSTRUCTION(Capital) July 2019 Fiscal Period 1/2020 Summarized by Account Report Generated on Aug 19,2019 8:06:06 AM TOTAL ASSETS Current Assets CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003 CASH ACCOUNTS/CASH $2,372,786 CASH ACCOUNTS/TEMPORARY INVESTMENTS $49,500,000 DUE FROM/DUE FROM R/E $54,873 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $8,038,468 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $54,880 RECEIVABLE ACCOUNTS/CAD RECEIVABLE $394,662 Current Assets $61,235,671 Net Property,Plant and Equipment FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $1,627,881 Net Property,Plant and Equipment $1,627,881 TOTAL ASSETS $62,863,552 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($1,293) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,519,478) CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($903,660) CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($170,786) DUE TO/DUE TO R/E ($866,183) LIABILITIES/UNEARNED INTEREST ($154,804) Total Liabilities ($3,616,204) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($1,627,881) FUND EQUITY/AVAILABLE FUND BALANCE ($58,414,909) FUND EQUITY/EXPENDITURE SUMMARY $1,627,881 YEAR TO DATE REVENUES/REVENUE SUMMARY ($832,440) Total Fund Equity ($59,247,349) TOTAL LIABILITIES AND FUND EQUITY ($62,863,552) Page 21 of 35 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE July 2019 Fiscal Period 1/2020 Report Generated on Aug 19, 2019 8:14:05 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $85,491 $855,531 900.7% $85,491 $855,531 900.7% $1,025,900 $170,369 83.4% Total Revenue $85,491 $855,531 900.7% $85,491 $855,531 900.7% $1,025,900 $170,369 83.4% Page 22 of 35 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE July 2019 Fiscal Period 01/2020 Report Generated on Aug 19, 2019 8:15:04 AM $250,000 ❑Period Budget $250,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $200,000 $200,000- $150,000-' 200,000$150,000 ' $150,000- $100,000- $100,000- $50,000- $50,000- $0- 50,000$0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $226,972 $232,434 ($5,462) $226,972 $232,434 ($5,462) Totals $226,972 $232,434 ($5,462) $226,972 $232,434 ($5,462) Page 23 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT SELF-INSURANCE FUND TEMPORARY INVESTMENTS July,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) $7,200,000 $7,200,000 ($300,000) $6,900,000 $6,911,811 100.00% $13,707 $0 $13,707 (3) $7,200,000 $7,200,000 ($300,000) $6,900,000 $6,911,811 100.00% 13,707 - 13,707 (2) $13,707 $0 $13,707 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The yield as of July,2019 was 2.379%. (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.379%. (4) The market value of the portfolio on July 31,2019 was$6,911,811. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. September 5, 2019 Regular Board Meeting Agenda Packet- Page 80 of 201 Page 24 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:003-SELF-INSURANCE July 2019 Fiscal Period 1/2020 Summarized by Account Report Generated on Aug 19,2019 8:06:06 AM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $222,454 CASH ACCOUNTS/TEMPORARY INVESTMENTS $6,900,000 DUE FROM/DUE FROM R/E $825,000 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $13,707 Current Assets $7,961,161 TOTAL ASSETS $7,961,161 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,246) CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($1,157,797) Total Liabilities ($1,159,043) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $202,052 FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000) FUND EQUITY/EXPENDITURE SUMMARY $232,434 FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,381,074) YEAR TO DATE REVENUES/REVENUE SUMMARY ($855,531) Total Fund Equity ($6,802,118) TOTAL LIABILITIES AND FUND EQUITY ($7,961,161) Page 25 of 35 jorM' Central Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004-DEBT SERVICE July 2019 Fiscal Period 1/2020 Report Generated on Aug 19, 2019 8:14:05 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 35 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE July 2019 Fiscal Period 01/2020 Report Generated on Aug 19, 2019 8:15:04 AM $80,000 ❑Period Budget $80,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $60,000 $60,000- $40,000-'-- 60,000 $40,000 $40,000- $20,000- $20,000- $0- $0 �� ■ Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $69,784 $0 $69,784 $69,784 $0 $69,784 Totals $69,784 $0 $69,784 $69,784 $0 $69,784 Page 27 of 35 ' Central Contra Costa Sanitary District Protecting public health and the environment Balance Sheet Fund:004-DEBT SERVICE July 2019 Fiscal Period 112020 Summarized by Account Report Generated on Aug 19,2019 8:06:06 AM TOTAL ASSETS Current Assets L.T.DEBT ACCOUNTING/REVENUE BOND RESERVE CASH $17,135 Current Assets $17,135 TOTAL ASSETS $17,135 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities L.T.DEBT ACCOUNTING/BOND ACR INTEREST PAYABLE ($288,505) L.T.DEBT ACCOUNTING/BONDS PAYABLE ($19,450,000) Total Liabilities ($19,738,505) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $22,078,000 LIABILITIES/DEFERRAL-BOND REFUNDING ($2,356,631) Total Fund Equity $19,721,369 TOTAL LIABILITIES AND FUND EQUITY ($17,135) Page 28 of 35 DASHBOARD DATA (SELECTED DATA ON MATTERS OF CONTINUING BOARD INTEREST) September 5, 2019 Regular Board Meeting Agenda Packet- Page 85 of 201 Page 29 of 35 PENSION AND OPEB LIABILITY AND FUNDING STATUS Pension OPEB Million $160 100% Million $90 100% $140 90% $80 90% $120 80% $70 80% 70% $60 70% $100 60% 60% $50 $80 50% 50% $40 $60 40% 40% 30% $30 30% $40 20% $20 20% $20 10% $10 10% $0 0% $0 0% ,LO 16;,",, LOti ,Lti�,titi� ,Lti�,0�ti ,Oti ,O`0,O`0,Otil 10ti00 ,LO iiiiiiiiiiiiiiiiiiii UAAL Funded% iiiiiiiiiiiiiiiiiiill.IAAL Funded% Notes: * Pension:2018 valuation is released summer of 2019. ** 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). September 5, 2019 Regular Board Meeting Agenda Packet- Page 86 of 201 Page 30 of 35 WHAT CAUSED THE PENSION URAL? Total LlAAL of$74 Million as of 2017 Al l Other Sources Restart of km ortization in 2007 Qisrount Rate from 7-75%to 7.25% Qepooling Implementation Actuarial ses from 2008 -Sw -$40 -$20 So S20 S-- $60 Millions Notes: * Pension:2018 valuation is released summer of 2019. ** 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). September 5, 2019 Regular Board Meeting Agenda Packet- Page 87 of 201 Page 31 of 35 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 $70 $60 $50 $40 $30 $20 $10 $0 II ■ ■ ($10) 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 ■Unfunded Liability $74 $67 $61 $53 $45 $34 $28 $21 $13 $4 ($6) 11 Unfunded Liability inclusive of Pension Prefunding $71 $62 $53 $43 $33 $21 $13 $4 $0 $0 $0 Trust •Change from 2017(Standard 18 yr by annual 9% 8% 10% -12% 14% -8% 9% 11% 12% -13% layer amortization) •Change from 2017(with additional -13% -13% -13% -15% -17% -11% -13% -5% contributions) Notes: • Chart shows scheduled amortization (over 18 years for each annual layer of historic UAAL),assuming no additional UAAL is generated. • Second bar shows potential further reductions in UAAL given additional discretionary contributions by Central San towards Pension Prefunding Trust September 5, 2019 Regular Board Meeting Agenda Packet- Page 88 of 201 Page 32 of 35 CIB TRANSFERS=CURRENT YEAR #of transfers Cause for Transfers Total Original Project Budgets and Transfers z $30,000 $25,000 1 $20,000 0 $15,000 ■ t ■ o ■ `o ■ v ■ a ■ v p o 0 a v $10 ,000 3 N V X CO a aiv c v w Q j u p ' z `^ m 0 p Q o a, 0 3 v o t z LL $5,000 + F.Cost exceeded initial budget " ° w E.New project scope U m � -dew C. New Project C.Developer/CAD or other cost neutral s B.Cashflow accelerations $- AW A.Bundling/Unbundling O��ao ak0z 'act Notes: There was one transfer in July 2019;the establishment of the HOB EV Charging Station Project. September 5, 2019 Regular Board Meeting Agenda Packet- Page 89 of 201 Page 33 of 35 CIB TRANSFERS SINCE FY 2016=17 Cause for Transfers Total Original Project Budgets and Transfers #of 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 v E.New project scope D.New Protect Y x C. Developer/CAD or other cost neutral c 3 v m a ac a � d 0V Z o B.Cashflow accelerations 3 3 LL $ A.Bundling/Unbundling 0 or v w Z 0o w a 15 .� �� me Notes: There was one transfer in July 2019;the establishment of the HOB EV Charging Station Project,for a total of 42 transfers since FY 2016-17 September 5, 2019 Regular Board Meeting Agenda Packet- Page 90 of 201 Page 34 of 35 FY 2019-20 Running Expense Fund Total Cash & Investment Balances (Actuals through July 2019) $60.0 $59.3 $53.7 $49.8 $50.0 $47.2 $48.6 - $43.4 $40.9 $40,0 $37.3 - $38.2 $38.4 $33.8 $32.9 $30.0 $29.0 $24.6 $24.2 $24.0 $20.0 $18.9 $10.0 $0.0 > yep O #o Projected Balance* Actual 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 September 5, 2019 Regular Board Meeting Agenda Packet- Page 91 of 201 Page 35 of 35 FY 2019-20 Sewer Construction Fund Total Cash & Investment Balances (Actuals through July 2019) $70.0 $62.5 $61.6 $60.0 $56.3 $58.3 56.1 $52.3 $51.9 $52.6 $54.0 $52.1 $50.0 $49.8 47.6 $48.1 $43.2 $40.0 $39.2 $30.0 _ $32.0 $30.4 $20.0 $10.0 $0.0 �o MProjected Balance* MActual Balance t 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 September 5, 2019 Regular Board Meeting Agenda Packet- Page 92 of 201