The URL can be used to link to this page

Home My WebLink About05. Receive June 2019 Financial Statements and Investment Reports Page 1 of 37 Item 5. ,ek 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 JUNE 2019 FINANCIAL STATEMENTS AND INVESTMENT REPORTS Attached for review are the Financial Statements and Investment Reports for the month of June 2019 reporting the unaudited results of the year then ended as well as for the month. As discussed previously with the Finance Committee and the Board, the monthly reports exclude Operations and Maintenance (O&M) detail by division as this information is generated and monitored internally. Fiscal Year(FY) 2018-19 O&M fund expenditures were below budget by approximately$4,377,670 (4.9%)while revenues were approximately$3,451,371 (4.0%) higher than estimated. An analysis of the O&M fund's large favorable budget variance reveals there are two matters that should be adjusted to arrive at the amount of funds that are truly available for disposition by the Board as part of the year-end closeout process. First, the $2,500,000 budgeted contribution made to Central San's Section 115 Pension Trust during FY 2018-19 is not permitted to be reflected as an expenditure in the financial reports due to prevailing accounting principles which treat the contribution as an asset on the balance sheet rather than an expense. Second, $561,816 of the positive variance noted in the Other Revenues category is derived from interest earnings in the Pension Trust, which is legally restricted for pension obligation purposes. After removing the impact of these two anomalies, the revised O&M fund favorable budget variance is still a healthy$4,767,225 (consisting of$1,877,670 in spending, and $2,889,555 in revenue), or 5.3% of the fund's FY 2018-19 appropriations. On the Sewer Construction fund side of the ledger, FY 2018-19 capital expenditures were under budget by$8,493,521 (16.2%), while revenues exceeded the budget by$5,010,455 (9.0%). The large revenue variance is primarily attributable to both capacity fees and ad valorem property tax revenues coming in higher than predicted. The fund's capital expenditure favorable variance reflects that 83.8% of the budgeted FY 2018-19 Sewer Construction funds were expended, even after including the FY 2017-18 carryover(unspent capital budget from the prior year). Consistent with regular practice, the Capital Projects Division Manager will be providing a presentation to the Board on the specifics of FY 2018-19 capital project results at a future meeting. September 5, 2019 Regular Board Meeting Agenda Packet- Page 20 of 201 Page 2 of 37 Overall, this is positive news for Central San, demonstrating that expenditures have been controlled within the confines of the budget and revenue projections were exceeded. Consistent with past practice, staff will be bringing a separate Position Paper to the Finance Committee and the Board at a later date to consider alternative courses of action (and a proposed recommendation)for disposition of the unrestricted District- wide FY 2018-19 favorable budget variance, which is estimated at$9,777,680 (consisting of$4,767,225 from O&M and $5,010,455 from Capital). It should be noted that the amounts discussed are pre-audit figures; audit-related adjustments are possible and may change the total variance amount. The Finance Committee has recommended this item for receipt by the Board. Strategic Plan Tie-In Tie-In GOAL THREE:Be a Fiscally Sound and Effective Water Sector Utility Strategy 2- Manage costs ATTACHMENTS: 1. June 2019 Financial Statements and Investment Reports September 5, 2019 Regular Board Meeting Agenda Packet- Page 21 of 201 Page 1 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT August 9,2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS FROM: AMAL LYON LG��e SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through period ending June 30, 2019 YTD YTD Fav/(Unfav) O&M Revenues: Budgeted Actual Variance Explanation First installment received was higher than budgeted. Percentage received varies Total $86,925,732 $ 90,377.103 $ 3,451,371 annually. O&M Expenses: Total Labor Charges $ 52,585,009 $ 52,282,252 $ 302,757 Some positions budgeted for in July are filled later in the fiscal year resulting in savings. Chemicals 1,459,000 1,352,857 106,143 Chemical consumption lower than budgeted. Utilities 4,142,550 4,369,863 (227,313) Higher than budget due to high PG&E bills. Repairs& Maintenance 5,414,644 4,724,751 689,893 Savings due to some of the budgeted repairs and maintenance work in the Plant Maintenance division did not materialize during the fiscal year. Professional&Legal Services 845,300 764,611 80,689 Lower mostly due to lower Legal expenses. Outside Services 3,510,822 2,512,152 998,670 Mainly due to Technical Services expense being lower than budgeted. Materials&Supplies 2,108,126 2,370,427 (262,301) More inventory supplies issued than anticipated for CSO&POD Departments. Other Expenses 2,777,258 2,211,061 566,197 BACWA expense lower than budget by$154k. Public Agency Fees, Public information &Tech training expenses lower than budgeted in the fiscal year. Unfunded Liabilities 14,803,278 12,789,113 2,014,165 Additional contributions budgeted for$2.5 million, however since amount was contributed into-Pension Trust,they are captured as asset on balance sheet. All Other 2,074,469 1,965,699 108,770 Minor variances for multiple account categories. Total $89720,456 $ 85 342.786 $ 4,377,670 September 5, 2019 Regular Board Meeting Agenda Packet- Page 22 of 201 Page 2 of 35 Aty lics entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 001 - RUNNING EXPENSE (O&M) June 2019 Fiscal Period 12/2019 Report Generated on Aug 9, 2019 11:34:00 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $14,800,000 $15,205,292 2.7% $14,800,000 $15,205,292 2.7% $14,800,000 ($405,292) 102.7% HHW $831,000 $821,861 -1.1% $929,000 $914,195 -1.6% $929,000 $14,805 98.4% Other $457,096 $929,650 103.4% $4,123,000 $5,600,709 35.8% $4,123,000 ($1,477,709) 135.8% Sewer Service Charges $1,987,656 $2,142,990 7.8% $67,073,732 $68,656,908 2.4% $67,073,732 ($1,583,176) 102.4% Total Revenue $18,075,752 $19,099,793 5.7% $86,925,732 $90,377,103 4.0% $86,925,732 ($3,457,371) 104.0% Page 3 of 35 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE (O&M) June 2019 Fiscal Period 12/2019 Report Generated on Aug 9, 2019 11:32:29 AM $90,000,000.00 —Budget 8 $ 20,456 _Actual $85 342,786 $80,000,000.00 �,40 35,766 $70,000,000.00 $66,93 $60,000,000.00 2 $ ,587,182$58,48 $51,37 6,411,026 $50,000,000.00 $44,52 586,006 $40,000,000.00 $30,000,000.00 $30,22 3 ,666,108 $23,12 064,083 $20,000,000.00 $ 657,968 16,22 , $10,000,000.00 8,83 989,002 $8,238,746 $0.00- 11 Jul(1)2018 Aug(2)2018 Sep(3)2018 Oct(4)2018 Nov(5)2018 Dec(6)2018 Jan(7)2019 Feb(8)2019 Mar(9)2019 Apr(10)2019 May(11)2019 Jun(12)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) June 2019 Fiscal Period 1212019 Report Generated on Aug 9, 2019 11:32:29 AM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $2,964,650 $3,071,193 ($106,543) -3.6% $35,571,037 $35,162,750 $408,287 1.1% $35,571,037 98.9% EMPLOYEE BENEFITS $2,138,164 $2,450,353 ($312,189) -14.6% $20,993,695 $21,131,649 ($137,954) -0.7% $20,993,695 100.7% CAPITALIZED ADM OVERHEAD ($331,727) ($377,699) $45,972 -13.9% ($3,979,723) ($4,012,147) $32,424 -0.8% ($3,979,723) 100.8% DIRECTOR FEES&EXPENSES $14,043 $13,557 $486 3.5% $168,494 $155,355 $13,139 7.8% $168,494 92.2% CHEMICALS $142,616 $222,746 ($80,130) -56.2% $1,459,000 $1,352,857 $106,143 7.3% $1,459,000 92.7% UTILITIES $604,149 $697,680 ($93,531) -15.5% $4,142,550 $4,369,863 ($227,313) -5.5% $4,142,550 105.5% REPAIRS&MAINTENANCE $546,182 $656,652 ($110,470) -20.2% $5,414,644 $4,724,751 $689,893 12.7% $5,414,644 87.3% HAULING&DISPOSAL $163,938 $178,172 ($14,234) -8.7% $1,126,475 $1,030,839 $95,636 8.5% $1,126,475 91.5% PROFESSIONAL&LEGAL SERV $72,189 $85,362 ($13,173) -18.2% $845,300 $764,611 $80,689 9.5% $845,300 90.5% OUTSIDE SERVICES $287,726 $233,789 $53,937 18.7% $3,510,822 $2,512,152 $998,670 28.4% $3,510,822 71.6% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $779,500 $779,505 ($5) 0.0% $779,500 100.0% MATERIALS&SUPPLIES $203,064 $350,563 ($147,499) -72.6% $2,108,126 $2,370,427 ($262,301) M $2,108,126 112.4% OTHER EXPENSES $174,693 $112,242 $62,451 35.7% $2,777,258 $2,211,061 $566,197 20.4% $2,777,258 79.6% UNFUNDED LIABILITIES $1,399,228 $312,411 $1,086,817 77.7% $14,803,278 $12,789,113 $2,014,165 13.6% $14,803,278 86.4% Total Expenses $8,378,915 $8,007,020 $371,895 4.4% $89,720,456 $85,342,786 $4,377,670 4.9% $89,720,456 95.1% 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) June 2019 Fiscal Period 12/2019 Report Generated on Aug 9, 2019 11:29:10 AM $3,000,000 ❑Period Budget $30,000,000-"' ❑YTD Budget ❑Period Actual ❑ YTD Actual $2,500,000 $25,000,000- $2,000,000- $20,000,000- $1,500,000- $15,000,000- $1,000,000- $10,000,000 $500,000 $5,000,000 $ Lfl L EL o � $0 �\ Q��c°e� S�Pov �`s�� c�`�``�� °,\N° �°Qrlvlp QJ�Q � Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $2,781,129 $2,625,331 $155,798 $27,737,657 $24,262,564 $3,475,093 ENGINEERING $1,444,182 $1,316,856 $127,326 $17,033,406 $16,334,241 $699,165 COLLECTION SYSTEM OPS. $1,278,479 $1,154,513 $123,966 $13,960,060 $13,977,517 ($17,457) PLANT OPERATIONS $2,429,302 $2,495,477 ($66,175) $26,501,955 $26,745,762 ($243,807) PUMP STATIONS $303,532 $281,359 $22,173 $2,934,584 $2,832,783 $101,801 RECYCLED WATER $142,291 $133,483 $8,808 $1,552,794 $1,189,918 $362,876 Totals $8,378,915 $8,007,020 $371,895 $89,720,456 $85,342,786 $4,377,670 Page 6 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT RUNNING EXPENSE FUND TEMPORARY INVESTMENTS June,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) $15,000,000 $21,000,000 ($6,000,000) $15,000,000 $15,102,743 42.86% $37,451 $292,583 $330,034 RE09 FHLB FED AGENCY 12/24/18 7/22/19 21 2.558% 4,927,375 5,000,000 5,000,000 4,993,600 14.29% 10,375 54,987 65,362 RE10 FHLB FED AGENCY 12/24/18 7/23/19 22 2.558% 4,927,029 5,000,000 5,000,000 4,993,300 14.29% 10,375 54,987 65,362 RE11 FHLMC FED AGENCY 3/4/19 7/23/19 22 2.443% 4,952,608 5,000,000 5,000,000 4,993,300 14.29% 10,083 29,914 39,997 RE12 FHLB FED AGENCY 3/22/19 7/23/19 22 2.410% 4,958,829 5,000,000 5,000,000 4,993,300 14.29% 10,042 23,765 33,807 (3) $34,765,842 $41,000,000 ($6,000,000) $35,000,000 $35,076,243 100.00% 78,326 456,237 534,563 (2) 178,739 178,739 $78,326 $634,976 $713,302 NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of June,2019 was 2.428%. (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.4647%. (4) The market value of the portfolio on June,2019 was$35,076,243. (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 27 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) June 2019 Fiscal Period 12/2019 Summarized by Account Report Generated on Aug 9,2019 11:27:10 AM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $12,154,982 CASH ACCOUNTS/PAYROLL CLEARING $20,000 CASH ACCOUNTS/PETTY CASH $3,400 CASH ACCOUNTS/TEMPORARY INVESTMENTS $35,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 $0 DUE FROM/DUE FROM S/I $0 INVENTORY/SUPPLIES&MATERIAL INV $2,185,998 PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104 PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572 PREPAID ACCOUNTS/PREPAID EXPENSES $13,918 PREPAID ACCOUNTS/PREPAID INSURANCE $90,184 PREPAID ACCOUNTS/PREPAID RETIREMENT $1,250,232 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $2,469 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $16,689,443 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA $1,032 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $0 RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $15,736 RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $101,362 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $3,382 Current Assets $89,112,234 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 $766,505,169 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($6,801) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,774,203) Page 8 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) June 2019 Fiscal Period 12/2019 Summarized by Account Report Generated on Aug 9,2019 11:27:10 AM CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($5,047,603) CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,258,104) CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($23,682) CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($848) CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931) CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING $0 CURRENT LIABILITIES/PERMIT CLEARING $0 CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($41,080) CURRENT LIABILITIES/RETIREMENT CONTRIB W/H $3 CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $0 DEF.COMP.CONTRIB W/H/ICMA 4571401A $0 DUE TO/DUE TO DEBT FUND $0 DUE TO/DUE TO S/C $0 DUE TO/DUE TO S/I $0 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 ($29,629) MEDICAL LIABILITIES/DELTA DENTAL $144 MEDICAL LIABILITIES/DISABILITY INS $186 MEDICAL LIABILITIES/HEALTH NET $335,765 MEDICAL LIABILITIES/KAISER PERMANENTE ($337,108) MEDICAL LIABILITIES/LIFE INS $2 MEDICAL LIABILITIES/OCCUPATIONAL HEALTH $30 MEDICAL LIABILITIES/POST EMP.BENEFIT-OPEB $0 PAYROLL TAXES WITHHELD/CALIFORNIA WITHHOLDING $0 PAYROLL TAXES WITHHELD FEDERAL WITHHOLDING $0 PAYROLL TAXES WITHHELD/MEDICARE WITHHOLDING $0 REIMBURSEMENT FEES ($61,574) Total Liabilities ($138,196,704) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE ($37,211,098) FUND EQUITY/CAPITAL COST SHARING ($123,029,998) FUND EQUITY/CONTRIBUTED SEWER LINES ($162,344,781) FUND EQUITY/EXPENDITURE SUMMARY $85,342,786 FUND EQUITY/GENERAL FIXED ASSET GROUP ($225,386,993) FUND EQUITY/STATE&FED CAPITAL GRANT ($75,301,279) YEAR TO DATE REVENUES/REVENUE SUMMARY ($90,377,103) Total Fund Equity ($628,308,465) TOTAL LIABILITIES AND FUND EQUITY ($766,505,169) Page 9 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT August 9,2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS Ci( FROM: AMAL LYON dy SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending June 30,2019: YTD YTD . Favl(Unfav) SIC Revenues: Budgeted Actual Variance Explanation Property Tax, Facilities Capacity Fees, Interest,and Total $ 55,889,268 $60,899,723 $ 5,010,455 Concord revenue received was higher than budgeted. FY YTD FY SIC Expenses: Budget" Actual Remaining %Spent Total $ 52,287,827 $43,794,306 $ 8,493,521 83.76% Includes 17118 carry-over($6,968,827) September 5, 2019 Regular Board Meeting Agenda Packet- Page 30 of 201 Page 10 of 35 Aty lics entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 002-SEWER CONSTRUCTION (Capital) June 2019 Fiscal Period 12/2019 Report Generated on Aug 9, 2019 11:34:00 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $7,150,000 $7,973,516 11.5% $7,150,000 $7,973,516 11.5% $7,150,000 ($823,516) 111.5% Other $3,078,609 $1,282,367 -58.3% $20,813,000 $24,337,582 16.9% $20,813,000 ($3,524,582) 116.9% Sewer Service Charges $838,268 $890,656 6.2% $27,926,268 $28,588,625 2.4% $27,926,268 ($662,357) 102.4% Total Revenue $11,066,877 $10,146,539 -8.3% $55,889,268 $60,899,723 9.0% $55,889,268 ($5,010,455) 109.0% Page 11 of 35 Sewer Fund(Capital)Spending FY 18-19 $60,000,000 $52,287,827 $50,000,000 $39,907,366 $40,000,000 $36,284,66�$321530,003 94,306 $29,197,153 $32,401,823 $30,000,000 $23,890,698 $26,513,695 $29,617,412 $19,397,124 $20,000,000 $13,377,477 $26,049,059 $9,429,510 $20,736,779 $23.808.150 $14,503,936 $18,379,941 $10,000,000 $3,996,336 $1,426,829 $11,543,304 $ $3404835 $8,485,345 July $1,600,939 August September October November December January February March April May June -Projected- -Actual July lAuguSt ASeptember lOctober INoyember IDecember IJanuary MIFebruary Imarch jApril Projected- $ 1,426,829 1$3,996,336 1$ 9,429,510 1$13,377,477 1$19,397,124 1$23,890,698 1$26,513,645 1$29,197,153 1$32,401,823 1$ 36,284,660 1$ 39,907,366 $52,287,827 Actual 1 1,600,939 1 3,404,835 1 8,485,345 1 11,543,304 1 14,503,936 1 18,379,941 1 20,736,779 1 23,808,150 1 26,049,059 1 29,617,412 1 32,530,003 1 43,794,306 *Projected-Current year budget allocated by month based on historical spending in previous 2 years September 5, 2019 Regular Board Meeting Agenda Packet- Page 32 of 201 Page 12 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:6/30/2019 PERIOD 12/2019 C(A-B) F(D+E) SG(C+D+E) I(F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECTTITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 201849 TYPE CS Collection System $ 29,409,417 30,841,697 (1,432,280) 19,347,000 1,133,419 20,480,419 19,048,139 19,857,390 (809,239) TYPE TP Treatment Plant 32,746,274 26,758,622 5,987,652 16,865,000 1,787,748 18,652,748 24,640,400 19,964,433 4,675,973 TYPE GI General Improvements 9,024,737 7,225,141 1,799,596 4,750,000 (1,421,167) 3,328,833 5,128,429 2,363,600 2,764,826 TYPE RW Recycled Water 2,382,894 1,769,035 613,859 2,857,000 - 2,857,000 3,470,859 1,608,883 1,861,968 CIB Contingency - - - 1,500,000 (1,500,000) - - - - Close outs-CIB transfer to/from Contingency - - TOTAL DISTRICT $ 73,563,322 $ 66,594,495 $ 6,968,827 $ 45,319,000 $ $ 45,319,000 $ 52,287,827 $ 43,794,306 $ 8,493,5 September 5, 2019 Regular Board Meeting Agenda Packet- Page 33 of 201 Page 13 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:6/30/2019 PERIOD 12/2019 ��N F(D+E) G(C+D+E) I(F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PRO) BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 TYPE CS Collection System 5991 PH Sewer Renovation Phase 2 460,000 277,761 182,239 - - 182,239 - 182,239 ****6534 Harper Lane Area CAD - - - - 800,000 800,000 800,000 412,260 387,740 6602 South Jackson CAD 411,290 391,290 20,000 - - 20,000 - 20,000 6603 North Jackson CAD 400,000 - 400,000 - (123,443) (123,443) 276,557 53,313 223,244 ****6679 Coredell Drive CAD - - - - 123,443 123,443 123,443 54,906 68,537 **7367 Concord Main Metering Station - - - - 250,000 250,000 250,000 245,826 4,174 8249 CSO Dump Pad Modifications 60,000 - 60,000 - - 60,000 12,409 47,591 8419 Collection System Planning LT 885,000 884,387 613 100,000 100,000 100,613 100,573 40 8436 Moraga/Crossroads PS Project 1,300,000 1,138,016 161,984 2,697,000 (250,000) 2,447,000 2,608,984 2,080,508 528,476 8441 CIPP Contract 17-20 300,000 80,247 219,753 100,000 100,000 319,753 195,676 124,077 8442 PS Equipment Piping Replacement PH2 36,000 - 36,000 25,000 25,000 61,000 - 61,000 8443 LG Diameter Pipe line Inspection 200,000 5,793 194,207 50,000 50,000 244,207 12,689 231,518 8444 Force Main Inspection Program 75,000 - 75,000 50,000 50,000 125,000 - 125,000 8446 Lafayette Sewer Renovation Phase 12 636,000 1,216,107 (580,107) 3,397,600 3,397,600 2,817,493 2,499,090 318,403 8447 Pump Station Security Improvement 131,000 - 131,000 25,000 25,000 156,000 - 156,000 8448 Manhole Modifications 400,000 375,370 24,630 300,000 12,000 312,000 336,630 485,005 (148,375) 8449 Collection System Modeling Support 100,000 56,761 43,239 100,000 100,000 143,239 73,374 69,865 8450 Development Sewerage Support 400,000 240,770 159,230 250,000 480,000 730,000 889,230 1,069,130 (179,900) 8451 C.S.Sewer Renovation 50,000 - 50,000 2,612,527 (2,600,000) 12,527 62,527 - 62,527 ***8452 Lafayette Sewer Ren.Ph.13 - - - - 500,000 500,000 500,000 1,561,461 (1,061,461) ***8454 So.Orinda Sewer Ren.Ph.7 - - - - 500,000 500,000 500,000 860,185 (360,185) ***8455 W.C.Sewer Renov.Ph.13 - - - - 500,000 500,000 500,000 2,604,854 (2,104,854) ***8456 Danville Sewer Ren.Ph.3 - - - - 500,000 500,000 500,000 381,637 118,363 8457 Pump Station Upgrades-Ph.2 - - - 50,000 50,000 50,000 - 50,000 ***8458 Martinez Sewer Renov.Ph.6 - - - - 100,000 100,000 100,000 11,405 88,595 ***8459 Lafayette Sewer Renov.Ph.14 - - - - 100,000 100,000 100,000 24,336 75,664 ***8460 WC Sewer Renov.Ph.14 - - - - 100,000 100,000 100,000 53,907 46,093 ***8461 So.Orinda Sewer Ren.Ph.8 - - - - 100,000 100,000 100,000 43,621 56,379 Year end close outs-balance transferred to continaaency *8412 PH Grayson Creek Trunk 15,100,000 15,061,359 38,641 - 163,187 163,187 201,828 201,823 5 *8430 Lafayette Sewer Renovation Phase 11 4,319,000 4,289,317 29,683 - (16,119) (16,119) 13,564 13,566 (2) 8433 S.Orinda Sewer Renovation Phase 6 1,962,127 3,066,717 (1,104,590) 2,758,873 (40,631) 2,718,242 1,613,652 1,613,657 (5) 8435 WC Sewer Renovation Phase 12 1,450,000 2,891,122 (1,441,122) 3,100,000 (2,633) 3,097,367 1,656,245 1,656,241 4 8445 N.Orinda Sewer Renovation 636,000 768,680 (132,680) 3,731,000 (62,385) 3,668,615 3,535,935 3,535,938 (3) *8453 Willows Sewer Repair 98,000 98,000 - - - - - - Rounding 12 Total FY 2018-19 CS AmountW9,409,43L!1111111 30,841,697 (1,432,280) 19,347,000 1,133,419 20,480,419 19,048,139 19,857,390 (809,2 *Italic Projects open but not in CIB for 18/19 * Not in 18/19 Budget. New projects opened in August 2018&May 2019. Funds transferred from DP8451 ** Not in 18/19 Budget. New projects opened in October 2018. Funds transferred from DP7353,7315,8451&6603 for CAD Not in 18/19 Budget. New projects opened in December 2018. Funds transferred from DP8436 September 5, 2019 Regular Board Meeting Agenda Packet- Page 34 of 201 Page 14 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:6/30/2019 PERIOD 12/2019 ��N F(D+E) G(C+D+E) I(F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 TYPE TP Treatment Pla **6172 Sludge Blending Tank Repair - - - - 776,000 776,000 776,000 - 776,000 7292 Switchgear Refurbishment-Ph.2 770,000 433,911 336,089 200,000 (285,452) (85,452) 250,637 39,361 211,276 7304 Instr&Controls PLC Upgrade 575,000 397,606 177,394 110,000 (185,000) (75,000) 102,394 72,921 29,473 7315 Applied Research and Innovations 557,274 251,302 305,972 300,000 (300,000) - 305,972 39,032 266,940 7317 Plant Control System Network Upgrades 330,000 234,234 95,766 100,000 335,000 435,000 530,766 47,228 483,538 7320 Plant Energy Optimization 1,094,000 1,063,448 30,552 - - - 30,552 (58,846) 89,398 7322 Fire Protection System Ph.2 1,406,000 1,014,803 391,197 - - - 391,197 326,033 65,164 7326 Equipment Replacement FY 15-FY 24 1,166,000 748,217 417,783 250,000 213,000 463,000 880,783 880,761 22 7327 Headwork's Screening Upgrade 8,144,000 7,845,455 298,545 76,000 85,000 161,000 459,545 458,805 740 7328 Influent Pump Electrical improvements 100,000 757 99,243 510,000 - 510,000 609,243 430,772 178,471 7330 Piping Renovation Phase 9 2,566,000 513,944 2,052,056 614,000 - 614,000 2,666,056 2,613,403 52,653 7339 T.Plant Control System 1/0 Replacement 470,000 605,231 (135,231) 900,000 - 900,000 764,769 681,036 83,733 7341 WC/Grayson Creek Levee Rehab 100,000 - 100,000 - - - 100,000 76,528 23,472 7348 Solids Handling Facility Improvements 4,975,000 4,516,007 458,993 5,715,000 (776,000) 4,939,000 5,397,993 4,727,501 670,492 7349 Aeration&Energy Upgrade 300,000 35,539 264,461 1,200,000 - 1,200,000 1,464,461 714,258 750,203 7351 Mechanical&Concrete Renovation 1,300,000 1,254,155 45,845 3,000,000 744,000 3,744,000 3,789,845 4,280,650 (490,805) 7352 UV Disinfection Upgrades - - - 500,000 - 500,000 500,000 294,751 205,249 7353 Outfall Improvements Ph.7 - - - 400,000 (300,000) 100,000 100,000 54,551 45,449 7354 TP Security Improvements 87,000 2,995 84,005 50,000 - 50,000 134,005 38,960 95,045 7355 Odor Control Upgrade Ph.1 44,000 - 44,000 200,000 (244,000) (44,000) - - - 7357 Plant Wide Instrumentation Upgrade 100,000 27,288 72,712 190,000 - 190,000 262,712 50,570 212,142 7358 Innovation Bioenergy Demo 300,000 261,182 38,818 - - - 38,818 9,614 29,204 7359 Solids Conditioning Bldg.roof replacement 500,000 189,377 310,623 800,000 - 800,000 1,110,623 1,005,882 104,741 7360 Existing Plant Facility Drawing 100,000 83,040 16,960 100,000 - 100,000 116,960 75,178 41,782 7362 POB Seismic Upgrades 400,000 135,591 264,409 1,100,000 1,831,177 2,931,177 3,195,586 2,714,844 480,742 7363 Treatment Plant Planning 450,000 348,907 101,093 450,000 - 450,000 551,093 370,247 180,846 7364 TP Safety Enhancement Ph.5 - - - 100,000 - 100,000 100,000 10,000 90,000 Year end close outs-balance transferred to continaaencv 7291 Pump&Blower Bldg.Seismic Upgrade 6,692,000 6,638,700 53,300 - (42,911) (42,911) 10,389 10,393 (4) 7329 MHF Burner Upgrade 220,000 156,933 63,067 - (63,066) (63,066) 1 - 1 Rounding 6 Total F 17-18 TP Amount 32,746,274 26,758,622 5,987,652 16,865,000 1,787,748 18,652,748 24,640,400 19,964,433 4,675,9731 "Italic Projects open but not in CIB for 18/19 Not in 18/19 Budget. New projects opened in June 2019. Funds transferred from DP7348 September 5, 2019 Regular Board Meeting Agenda Packet- Page 35 of 201 Page 15 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:6/30/2019 PERIOD 12/2019 ��N F(D+E) G(C+D+E) I(F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 TYPE GI General Improvements 8207 General Security and Access $ 194,616 121,661 72,955 500,000 (559,641) (59,641) 13,314 13,313 1 8230 Capital Legal Services 158,665 132,070 26,595 20,000 - 20,000 46,595 10,341 36,254 8236 District Easements 208,047 164,616 43,431 50,000 - 50,000 93,431 60,177 33,254 8240 IT Development 2,188,794 2,187,431 1,363 1,750,000 (1,200,000) 550,000 551,363 269,030 282,333 8243 Server Room Relocation 955,430 515,656 439,774 880,000 164,570 1,044,570 1,484,344 835,857 648,487 **8250 ERP Replacement - - - - 600,000 600,000 600,000 - 600,000 8516 District Equipment Acquisition 676,000 590,745 85,255 200,000 - 200,000 285,255 208,067 77,188 8517 Vehicle Replacement Program 1,199,000 603,959 595,041 650,000 - 650,000 1,245,041 217,732 1,027,309 9999 Capital Project Clearing(Accounting Use Only)** - (60,000) 60,000 - - - 60,000 (2) 60,002 Year end close outs-balance transferred to continaaency 8238 Asset Management 2,969,185 2,790,236 178,949 400,000 (3,531) 396,469 575,418 575,425 (7) 8247 Property&Building Improvements 400,000 178,767 221,233 300,000 (347,565) (47,565) 173,668 173,660 8 8248 Cyber Security 75,000 - 75,000 - (75,000) (75,000) - - - Rounding (3) TotalFY 2017-18 GI Amount $ 9,024,737 7,225,141 1,799,596 4,750,000 (1,421,167) 3,328,833 5,128,429 2,363,600 Not in 18/19 Budget. New projects opened in June 2019. Funds transferred from DP8240 September 5, 2019 Regular Board Meeting Agenda Packet- Page 36 of 201 Page 16 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:6/30/2019 PERIOD 12/2019 ��N F(D+E) G(C+D+E) I(F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 7306 Zone 1 Recycled Water 497,894 484,984 12,910 35,000 - 35,000 47,910 23,667 24,243 7346 Surge Analysis 16-17 155,000 3,125 151,875 50,000 - 50,000 201,875 149,796 52,079 7361 Filter Plant Improvments 330,000 162,293 167,707 2,457,000 (250,000) 2,207,000 2,374,707 1,180,809 1,193,898 7365 Recycle Water Clearwell Repairs 1,400,000 1,118,633 281,367 300,000 - 300,000 581,367 245,509 335,858 7366 ReW Distribution System Renov.Program - - - 15,000 - 15,000 15,000 - 15,000 ***7368 Water Exchange Project - - - - 250,000 250,000 250,000 9,102 240,898 Rounding (8) Total FY 2016-17 RW Amount $ 2,382,894 1,769,035 613,859 2,857,000 2,857,000 3,470,859 1,608,883 1,861, * Not in 18/19 Budget. New projects opened in May 2019. Funds transferred from DP7361 9990 CONTINGENCY-ALL PROGRAMS - - - 1,500,000 (1,500,000) - - - CONTINGENCY-FROM CLOSE OUTS - - GRAND TOTAL 5; 73,563,322 66,594,495 6,968,827 45,319,000 - 45,319,000 52,287,827 43,794,306 8,493,5 September 5, 2019 Regular Board Meeting Agenda Packet- Page 37 of 201 Page 17 of 35 FY 18-19 CAPITAL BUDGET TRANSFERS PERIOD ENDING:5/31/19 Position June'19 Position Position Paper Position Paper:5/2/19 Memo to GM Position Paper Position Paper Paper:6/20/19 item 4 Transfers from 10/4/19 item 2 Paper 12/20 Deputy GM item 11(7368) approved 11/15 Item 10 11/1 item 7 & &item 10,11/15/18 Contignecy due to &Deputy GM item 7 &GM signature 04/19 &GM 09/05/18 &GM 12/12 GM 12/19 item 10 02/21/19 item close outs signature 1/08/19 signature 18/19 Contingency PROJ.# PROJECTS (8451) 8&GM signature TOTAL Balance **6172 SLIDGE Blending Tank Repairs - - - - - 776,000 776,000 6534 Harper Lane Area CAD(new Project) 800,000 - 800,000 6603 North Jackson CAD - (123,443) (123,443) 6679 Cordell Drive CAD 123,443 123,443 7292 Switchgear Refurbuishment ph.2 - (100,000) (185,452) (285,452) 7304 PLC System Upgrade (185,000) (185,000) 7315 Applied Research (300,000) (300,000) 7317 Plant Control System Network upgrads 335,000 335,000 7326 Equipment Replacement - 213,000 213,000 7327 Headworks Screening Upgrades - 85,000 85,000 7351 Mechanical&Concrete Renovations 744,000 744,000 7353 Outfall Improvements (300,000) - (300,000) 7355 Odor Controll Upgrades Ph.1 (244,000) (244,000) 7348 Solids Handling Facility Improvements (776,000) (776,000) 7361 Filter Plant&Clearwell (250,000) (250,000) 7362 POB Seismic Upgrades - 1,831,177 1,831,177 7367 Concord Main Metering Station 250,000 - 250,000 8207 General Security&Access - (559,641) (559,641) 8240 IT Technology Development (450,000) (750,000) (1,200,000) 8243 Server Room Relocation Proj. 164,570 164,570 8247 Property&Building Improvements (363,606) 16,041 (347,565) 8412 PH Grayson Creek Trunk Sewer 163,187 163,187 8436 Moraga Crossroads Pump Station (250,000) (250,000) 8448 Manhole Modifications - - 12,000 12,000 8450 Development Sewerage 480,000 480,000 **7368 Water exchange Project - 250,000 250,000 **8250 ERP Replacement - 600,000 600,000 *8451 C.S.Sewer Renovation (2,000,000) (200,000) (400,000) - (2,600,000) *8452 Lafayette Sewer Ren.Ph.13 500,000 500,000 *8454 So.Orinda Sewer Ren.Ph.7 500,000 500,000 *8455 W.C.Sewer Renov.Ph.13 500,000 500,000 *8456 Danville Sewer Renov.Ph.3 500,000 - 500,000 *8458 Martinez Sewer Ren.Ph.6 100,000 100,000 *8459 Lafayette Sewer Ren.Ph.14 100,000 100,000 *8460 W.C.Sewer Renov.Ph.14 100,000 100,000 *8461 So.Orinda Sewer Ren.Ph.8 100,000 100,000 9990 Capital Projects-Contingency (622,500) (480,000) - (397,500) (1,500,000) - Capital Projects-transfer to contingency from close outs 306,276 Capital Projects-Contingency from project close outs (2,500) (303,776) (306,276) (306,276) Not actual transfers. All part of one project split into individual projects for construction ** New project-not in 18/19 Budget September 5, 2019 Regular Board Meeting Agenda Packet- Page 38 of 201 Page 18 of 35 O&M PROJECTS-EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 06/30/19 11/2019 OM043- Naval Weapons Station Prior years Project expended Expenditure type through 17-18 1 Jul.'18 Aug.'18 Sept.'18 Oct.'18 Nov.'18 Dec.'18 Jan.'19 Feb.'19 Mar.'19 Apr.'19 May'19 Jun.'19 2018-19 YTD to date Salary&Benefits $ 17,293 $ - $ - $ - $ - $ - $ - $ - $ - $ 136 $ - $ - $ - $ 136 $ 17,429 Technical Services $ 75,169 - - - - - - - - - - - - - $ 75,169 Total $ 92,462 $ - $ - $ - $ - $ - $ - $ - $ - $ 136 $ - $ - $ - $ 136 $ 92,598 OM080 -CoCo Farm(Kiewit Future Farm Proposal) Prior years Projectexpended Expenditure type through 17-18 Jul.'18 Aug.'18 Sept.'18 Oct.118 Nov.'18 Dec.'18 Jan.'19 Feb.'19 Mar.'19 Apr.'19 May'19 Jun.'19 2018-19 YTD to date Salary&Benefits $ 206,827 $ 1,444 $ 225 $ - $ 403 $ 241 $ - $ - $ - $ 851 $ - $ 463 $ 210 $ 3,838 $ 210,665 Other Charges $ 74,996 - - - - 561 - - - - - - - - $ 74,996 Total $ 281,824 $ 1,444 $ 225 $ - $ 403 $ 802 $ - $ - $ - $ 851 $ - $ 463 $ 210 $ 3,838 $ 285,661 OM083- Refinery Recycled Water Exchange Prior years Project expended Expenditure type through 17-18 Jul.'18 Aug.'18 Sept.'18 Oct.'18 Nov.'18 Dec.'18 Jan.'19 Feb.'19 Mar.'19 Apr.'19 May'19 Jun.'19 2018-19 YTD to date Salary&Benefits $ 23,648 $ 2,746 $ 1,540 $ 2,411 $ 2,324 $ 1,549 $ 4,069 $ 3,391 $ 6,368 $ 10,037 $ 11,975 $ 7,577 $ 6,433 $ 60,421 $ 84,070 other Charges $ - - - - - - - - - - $ - $ - Total $ 23,648 $ 2,746 $ 1,540 $ 2,411 $ 2,324 $ 1,549 $ 4,069 $ 3,391 $ 6,368 $ 10,037 $ 11,975 $ 7,577 $ 6,433 $ 60,421 $ 84,070 September 5, 2019 Regular Board Meeting Agenda Packet- Page 39 of 201 Page 19 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS June,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) $29,500,000 $27,500,000 $2,000,000 $29,500,000 $29,702,061 47.20% $61,731 $267,962 $329,693 938 FHLMC FHLMC 12/06/18 6/03/19 0 2.57 4,937,847 5,000,000 (5,000,000) 0 0 0.00% 694 61,458 62,153 940 US Gov't T-Bill 12/21/18 06/20/19 0 2.52 4,938,284 5,000,000 (5,000,000) 0 0 0.00% 6,478 55,238 61,716 941 US Gov't T-Bill 2/28/19 8/29/19 59 2.49 3,950,860 4,000,000 4,000,000 3,986,240 6.40% 8,100 25,110 33,210 942 US Gov't T-Bill 3/4/19 8/29/19 59 2.50 3,951,742 4,000,000 4,000,000 3,986,240 6.40% 8,133 24,129 32,262 943 FHLMC Fed Agency 3/06/19 6/12/19 0 2.46 4,967,197 5,000,000 (5,000,000) 0 0 0.00% 3,682 29,121 32,803 944 T-Bill US Tbill 3/21/19 9/19/19 80 2.50 4,938,575 5,000,000 5,000,000 4,976,900 8.00% 10,125 24,300 34,425 945 FHLB Agency Gov 4/3/19 10/1/19 92 2.44 4,940,169 5,000,000 5,000,000 4,972,800 8.00% 9,917 19,503 29,419 946 FHLMC Fed Agency 5/28/19 11/12/19 134 2.37 4,946,100 5,000,000 5,000,000 4,960,900 8.00% 9,625 1,283 10,908 947 FHLB FHLB Note 6/13/19 12/11/19 184 2.20 4,946,077 0 5,000,000 5,000,000 4,953,150 8.00% 4,805 0 4,805 948 FHLB Govt/FHLB 6/21/19 11/18/19 153 2.02 4,957,917 0 5,000,000 5,000,000 4,959,150 8.00% 2,582 0 2,582 (4) $76.974.769 $65.500.000 ($3.000.000) $62.500,000 $62.497.441 100.00% 125,873 508,104 633,976 (3),(6) (5) 34,375 424,778 459,153 $160.248 $932.882 $1.093.129 NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of June 2019 was 2.428%. (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.4280%. (4) The market value of the portfolio on June 30,2019 was$62,497,441. 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. 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 40 of 201 Page 20 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:002-SEWER CONSTRUCTION(Capital) June 2019 Fiscal Period 12/2019 Summarized by Account Report Generated on Aug 9,2019 11:27:10 AM TOTAL ASSETS Current Assets CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003 CASH ACCOUNTS/CASH $2,336,135 CASH ACCOUNTS/TEMPORARY INVESTMENTS $54,000,000 DUE FROM/DUE FROM DEBT FUND $0 DUE FROM/DUE FROM RIE $0 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $8,039,736 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $0 RECEIVABLE ACCOUNTS/CAD RECEIVABLE $394,662 Current Assets $65,590,536 Net Property,Plant and Equipment FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $0 Net Property,Plant and Equipment $0 TOTAL ASSETS $65,590,536 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($1,293) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($5,882,966) CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($899,635) CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($170,786) DUE TO/DUE TO DEBT FUND $0 DUE TO/DUE TO RIE $0 LIABILITIES/UNEARNED INTEREST ($220,948) Total Liabilities ($7,175,627) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($43,794,306) FUND EQUITY/AVAILABLE FUND BALANCE $2,484,815 FUND EQUITY/EXPENDITURE SUMMARY $43,794,306 YEAR TO DATE REVENUES/REVENUE SUMMARY ($60,899,723) Total Fund Equity ($58,414,909) TOTAL LIABILITIES AND FUND EQUITY ($65,590,536) Page 21 of 35 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE June 2019 Fiscal Period 12/2019 Report Generated on Aug 9, 2019 11:34:00 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $74,655 $97,033 30.0% $960,250 $1,036,330 7.9°% $960,250 ($76,080) 107.9% Total Revenue $74,655 $97,033 30.0% $960,250 $1,036,330 $960,250 ($76,080) 107.9% Page 22 of 35 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE June 2019 Fiscal Period 12/2019 Report Generated on Aug 9, 2019 11:29:10 AM $400,000 ❑Period Budget $1,200,000 ❑YTD Budget ❑Period Actual q YTD Actual $1,000,000- $300,000- $800,000- $200,000- 1,000,000$300,000 $800,000$200,000 $600,000- $400,000- $100,000- $200,000- $0- 600,000$400,000$100,000 $200,000$0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $29,560 $323,185 ($293,625) $924,500 $1,125,404 ($200,904) Totals $29,560 $323,185 ($293,625) $924,500 $1,125,404 ($200,904) Page 23 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT SELF-INSURANCE FUND TEMPORARY INVESTMENTS June,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 $0 $7,200,000 $7,249,317 100.00% $14,368 $146,380 $160,748 (3) $7,200,000 $7,200,000 $0 $7,200,000 $7,249,317 100.00% 14,368 146,380 160,748 (2) 8,596 8,596 $14,368 $154,976 $169,344 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of June,2019 was 2.428%. (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.4280%. (4) The market value of the portfolio on June 30,2019 was$7,249,317. 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 44 of 201 Page 24 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:003-SELF-INSURANCE June 2019 Fiscal Period 12/2019 Summarized by Account Report Generated on Aug 9,2019 11:27:10 AM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $183,481 CASH ACCOUNTS/TEMPORARY INVESTMENTS $7,200,000 DUE FROM/DUE FROM R/E $0 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $0 Current Assets $7,383,481 TOTAL ASSETS $7,383,481 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/ACCOUNTS PAYABLE ($46,662) CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($1,157,797) DUE TO/DUE TO R/E $0 Total Liabilities ($1,204,459) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $11,952 FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000) FUND EQUITY/EXPENDITURE SUMMARY $1,125,404 FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,280,047) YEAR TO DATE REVENUES/REVENUE SUMMARY ($1,036,330) Total Fund Equity ($6,179,021) TOTAL LIABILITIES AND FUND EQUITY ($7,383,481) Page 25 of 35 jorM' Central Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004-DEBT SERVICE June 2019 Fiscal Period 12/2019 Report Generated on Aug 9, 2019 11:34:00 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $82,446 ($26,023) -131.6% $3,611,037 $3,505,005 -2.9°% $3,611,037 $106,032 97.1° Total Revenue $82,446 ($26,023) -131.6% $3,611,037 $3,505,005 -2.9% $3,611,037 $106,032 Page 26 of 35 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE June 2019 Fiscal Period 12/2019 Report Generated on Aug 9, 2019 11:29:10 AM $400,000 ❑Period Budget $1,200,000 '� ❑YTD Budget ❑Period Actual ❑ YTD Actual $1,000,000 $300,000 ' $800,000 $200,000 ' $600,000- $400,000- $100,000- $200,000- $0- 600,000$400,000$100,000 $200,000$0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $371,502 $156,514 $214,988 $1,135,780 $1,025,005 $110,775 Totals $371,502 $156,514 $214,988 $1,135,780 $1,025,005 $110,775 Page 27 of 35 ' Central Contra Costa Sanitary District Protecting public health and the environment Balance Sheet Fund:004-DEBT SERVICE June 2019 Fiscal Period 12/2019 Summarized by Account Report Generated on Aug 9,2019 11:27:10 AM TOTAL ASSETS Current Assets DUE FROM/DUE FROM RIE $0 DUE FROM/DUE FROM S/C $0 L.T.DEBT ACCOUNTING/DEPOSIT W/TRUSTEE-RESERVE $0 L.T.DEBT ACCOUNTING/REVENUE BOND RESERVE CASH $17,135 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $0 Current Assets $17,135 TOTAL ASSETS $17,135 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities DUE TO/DUE TO S/C $0 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 $24,558,000 FUND EQUITY/EXPENDITURE SUMMARY $1,025,005 LIABILITIES/DEFERRAL-BOND REFUNDING ($2,356,631) YEAR TO DATE REVENUES/REVENUE SUMMARY ($3,505,005) 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 49 of 201 Page 29 of 35 PENSION AND OPEB LIABILITY AND FUNDING STATUS Pension 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% ,y'L e ,", ,y�o ,' ,l� �O tib` ", tiO til ti00 tiO If If llllllllllllllllllllllllliUAAL Funded% llllllllllllllllllllllllliUAAL 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 50 of 201 Page 30 of 35 WHAT CAUSED THE PENSION URAL? Total UAAL of$74 Million as of 2017 ill 011-e'Soil res Restart of Amortization in 2007 Diseo unt Rate from 7.75%to 7.25% De pooling Implementation Actuarial Losses from 2008 -550 -540 -S20 50 $2;: $40 560 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 51 of 201 Page 31 of 35PENSION 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 ■ , ($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) —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 Septsol �y%P !6 §cwdw Board Meeting Agenda Packet- Page 52 of 201 Page32QHB TRANSFERS SINCE FY 2016=1 7 Cause for Transfers Total Original Project Budgets and Transfers #of transfers --- $60,000,000 $50,000,000 $40,000,000 6 $30,000,000 J _ 4 2 $20,000,000 0 $10,000,000 F.Cost exceeded initial budget �'' m o o v a E.New project scope D. New Project — v a C. Developer/CAD or other cost neutral o .. a= 3 0 3 B.Cashflow accelerations A.Bundling/Unbundling a O�.ko apOe 5� Notes: There were 9 additional transfers in June 2019 for a total of 41 for the three years covered in this chart. September 5, 2019 Regular Board Meeting Agenda Packet- Page 53 of 201 Page 33 ofEMB TRANSFERS=CURRENT YEAR Cause for Transfers Total Original Project Budgets and Transfers #of transfers $18,000,000 — — — — — — — ....:....... $16,000,000 _ - - - - - - - - $14,000,000 $12,000,000 0 $10,000,000 $8,000,000 ■ ao ■ c ■ o ■ ■ a ■ v i o o g v $6,000,000 U u i N 7 Q u C n Z 2 a -- $4,000,000 o v v LL E F.Cost exceeded initial budget t v o w E.New project scope U $2,000,000 D. New Project m w C.Developer/CAD or other cost neutral B.Cashflow accelerations $- A.Bundling/Unbundling a iy Notes: There were 9 additional transfers in June 2019 for a total of 15 for the fiscal year. September 5, 2019 Regular Board Meeting Agenda Packet- Page 54 of 201 Page 34 of 35 FY 2018-19 Running Expense Fund Total Cash & Investment Balances (Actuals through June 2019) $52.5 $50.0 $49.8 $46.7 $47.2 $43.7 $44.3 $40.3 $42.5 42.0 $40. $40.0 - $29.6 $33.9 7.3 $25.6 $24.2 S37.a $4o.z $31.5 $31.9 $30.0 $26.7 $27.4 $21.9 $20.6 $20.5 i $19.4 $20.0 $15.3 $13.5 $10.0 $0.0 ,,`b ��J �y� e� �� 0, 0, a > yep Projected Balance* Actual Balance Reserve Target at Year End** NOTES: * Projected balances were generated in June 2018 based on budgeted revenues and expenses for FY 2018-19 and applied to the actual balance at June 30, 2018 **The Reserve Target at Year End is the minimum balance required at June 30, 2019 to comply with the District Fiscal Reserve Policy September 5, 2019 Regular Board Meeting Agenda Packet- Page 55 of 201 Page 35 of 35 FY 2018-19 Sewer Construction Fund Total Cash & Investment Balances (Actuals through June 2019) $70.0 $68.2 $67.5 $60.0 $59.1 $54.0 $53.6 $54.9 $56.3 $53.0 $51.3 $51.8 $50.9 $49. $50.0 $47.9 $44.1 $40,0 $40.4$37.3 $35.7$37.9 $34.3 $30.0 $29. $30 $36.4 i$22.7 $31.6 $33.0 $32.4 $31.1 .0 0.4 $20.0 $10.0 $0.0 , 0 elk e� e� ;k Je�� '41 a�a > �e� 4 o M Projected Balance* MActual Balance -Reserve Target at Year End** NOTES: * Projected balances were generated in June 2018 based on budgeted revenues and expenses for FY 2018-19 and applied to the actual balance at June 30, 2018 **The Reserve Target at Year End is the minimum balance required at June 30, 2019 to comply with the District Fiscal Reserve Policy September 5, 2019 Regular Board Meeting Agenda Packet- Page 56 of 201