The URL can be used to link to this page

Home My WebLink About03.b. Review May 2019 Financial Statements and Investment Reports Page 1 of 35 Item 3.b. CENTRAL SAN June 25, 2019 TO: FINANCE COMMITTEE FROM: CHRIS THOMAS, FINANCE ADMINISTRATOR REVIEWED BY: PHILIP LEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION ANN SASAKI, DEPUTY GENERAL MANAGER ROGER S. BAILEY GENERAL MANAGER SUBJECT: REVIEW MAY2019 FINANCIAL STATEMENTS AND INVESTMENT REPORTS Attached for review are the Financial Statements and Investment Reports as of the date shown above. Year-to-date Operations and Maintenance spending is below the budgeted amount by$4 million while revenues are $2.4 million higher than planned. The revenue variance includes sewer service charges of $1.4 million, permit/application fees of $0.2 million, side sewer inspection fees of $0.3 million, and other factors $0.5 million. Accordingly, the outlook is favorable to close-out the year with a favorable variance comparable to that seen in Fiscal Year 2017-18. Sewer Construction Revenues are $5.9 million above forecast, with Sewer Service Charge revenues higher by$0.6 million, capacity fees $2 million higher, ad valorem taxes $3 million higher, and other items comprising $0.3 million. As discussed with the Finance Committee and the Board, the report excludes Operations and Maintenance detail by division. This information is generated and monitored internally. Strategic Plan Tie-In GOAL THREE: Be a Fiscally Sound and Effective Water Sector Utility Strategy 2- Manage costs ATTACHMENTS: 1. May 2019 Financial Statements and Investment Reports June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 61 of 100 Page 1 of 34 CENTRAL CONTRA COSTA SANITARY DISTRICT June 11,2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS FROM: AMAL LYON SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through period ending May 31,2019 YTD Fav/(Unfav) Variance O&M Revenues: Budgeted Actual Variance Explanation First installment received was higher than budgeted. Percentage received varies Total $68 849,980 $ 71,277,310 $ 2,427,330 annually. O&M Expenses: Total Labor Charges $47,813,922 $ 47,138,404 $ 675,518 Expenses are typically lower in the beginning of the year. Some positions budgeted for in July are filled later in the fiscal year resulting in savings. Chemicals 1,316,384 1,130,111 186,273 Chemicals are purchased sporadically throughout the year rather than monthly as is budgeted. The variance should be reduced by year-end. Utilities 3,538,401 3,672,183 (133,782) Higher than budget due to high PG&E bills Repairs&Maintenance 4,868,462 4,068,098 800,364 Lower due to budget being spread over 12 months versus actual expenses occurring sporadically throughout the year. Some budgeted expenses have not yet occurred or are underspent. Professional&Legal Services 773,111 679,250 93,861 Lower mostly due to lower Legal expenses thus far in the fiscal year. Outside Services 3,223,096 2,278,363 944,733 Mainly due to Technical Services expense being lower than budgeted thus far in the fiscal vear. Other Expenses 2,602,565 2,098,819 503,746 BACWA expense lower than budget by$154k. However, additional BACWA expense may be incurred later in the fiscal year for Nutrient Studies. Public Agency Fees, Public information&Tech training expenses lower than budgeted thus far in the fiscal year. Unfunded Liabilities 13,404,050 12,476,702 927,348 Variance due to UAAL vacancy. Budgeted vacancy is lower than actual vacancies thus far in the fiscal year. This variance should be reduced by year-end All Other 3,801,550 3,793,836 7,714 Minor variances for multiple account categories. Total $81,341,541 $ 77,335,766 $ 4,005,775 June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 62 of 100 Page 2 of 34 j&W lics entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 001 - RUNNING EXPENSE(O&M) May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 2:23:43 PM 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% $14,800,000 $14,800,000 0.0% HHW $8,000 $13,066 63.3% $98,000 $92,334 -5.8% $929,000 $836,666 9.9% Other $271,564 $513,086 88.9% $3,665,904 $4,671,059 27.4% $4,123,000 ($548,059) 113.3% Sewer Service Charges $14,916 $150,760 910.7% $65,086,076 $66,513,917 2.2% $67,073,732 $559,815 99.2% Total Revenue $294,480 $676,912 129.9% $68,849,980 $71,277,310 3.5% $86,925,732 $15,648,422 82.0% Page 3 of 34 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE (O&M) May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 2:22:30 PM $90,000,000.00 —Budget —Actual $80,000,000.00 - ,341,541 35,766 $70,000,000.00 �,40$66,93 $60,000,000.00 587,182 $51,37 411,026 $50,000,000.00- $44,52 586,006 $40,000,000.00 592,870 $30,229 ,666,108 $30,000,000.00 $23,12 064,083 $20,000,000.00 $16,22 ' , $10,000,000.00 $8,838 989,002 $8,238,746 $0.00 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 Fiscal Periods Page 4 of 34 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 -RUNNING EXPENSE(O&M) May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 2:22:30 PM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $2,964,217 $2,960,288 $3,929 0.1% $32,606,387 $32,091,556 $514,831 1.6% $35,571,037 90.2% EMPLOYEE BENEFITS $1,686,321 $1,661,318 $25,003 1.5% $18,855,531 $18,681,296 $174,235 0.9% $20,993,695 89.0% CAPITALIZED ADM OVERHEAD ($331,636) ($356,861) $25,225 -7.6% ($3,647,996) ($3,634,448) ($13,548) 0.4% ($3,979,723) 91.3% DIRECTOR FEES&EXPENSES $14,041 $12,370 $1,671 11.9% $154,451 $141,798 $12,653 8.2% $168,494 84.2% CHEMICALS $121,547 $77,083 $44,464 36.6% $1,316,384 $1,130,111 $186,273 14.2% $1,459,000 77.5% UTILITIES $345,206 $406,872 ($61,666) -17.9% $3,538,401 $3,672,183 ($133,782) -3.8% $4,142,550 88.6% REPAIRS&MAINTENANCE $447,431 $446,864 $567 0.1% $4,868,462 $4,068,098 $800,364 16.4% $5,414,644 75.1% HAULING&DISPOSAL $133,867 $110,669 $23,198 17.3% $962,537 $852,668 $109,869 11.4% $1,126,475 75.7% PROFESSIONAL&LEGAL SERV $69,601 $129,685 ($60,084) -86.3% $773,111 $679,250 $93,861 12.1% $845,300 80.4% OUTSIDE SERVICES $265,726 $114,595 $151,131 56.9% $3,223,096 $2,278,363 $944,733 29.3% $3,510,822 64.9% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $779,500 $779,505 ($5) 0.0% $779,500 100.0% MATERIALS&SUPPLIES $175,642 $234,542 ($58,900) -33.5% $1,905,062 $2,019,864 ($114,802) -6.0% $2,108,126 95.8% OTHER EXPENSES $152,134 $135,511 $16,623 10.9% $2,602,565 $2,098,819 $503,746 19.4% $2,777,258 75.6% UNFUNDED LIABILITIES $893,356 $743,023 $150,333 16.8% $13,404,050 $12,476,702 $927,348 6.9% $14,803,278 84.3% Total Expenses $6,937,453 $6,675,960 $261,493 3.8% $81,341,541 $77,335,766 $4,005,775 4.9% $89,720,456 86.2% Color Key: 0 to 10%over budget > 10%over budget M Page 5 of 34 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE (O&M) May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 1:56:19 PM $2,500,000 ❑Period Budget $25,000,000 ' ❑YTD Budget ❑Period Actual ❑ YTD Actual $2,000,000 $20,000,000- $1,500,000- $15,000,000 Im $1,000,000 $10,000,000- $500,000- $5,000,000 $o � $0 M � Po�\'00, G\�� G�\ P��oQ� 5�p �p� ��S� �� G�\oQ��oQ� Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $1,818,015 $1,556,363 $261,652 $24,956,528 $21,637,233 $3,319,295 ENGINEERING $1,409,715 $1,348,928 $60,787 $15,589,224 $15,017,385 $571,839 COLLECTION SYSTEM OPS. $1,162,280 $1,222,861 ($60,581) $12,681,581 $12,823,004 ($141,423) PLANT OPERATIONS $2,173,526 $2,246,955 ($73,429) $24,072,653 $24,250,285 ($177,632) PUMP STATIONS $244,538 $216,862 $27,676 $2,631,052 $2,551,424 $79,628 RECYCLED WATER $129,379 $83,991 $45,388 $1,410,503 $1,056,435 $354,068 Totals $6,937,453 $6,675,960 $261,493 $81,341,541 $77,335,766 $4,005,775 Page 6 of 34 CENTRAL CONTRA COSTA SANITARY DISTRICT RUNNING EXPENSE FUND TEMPORARY INVESTMENTS May,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) $21,000,000 $26,000,000 ($5,000,000) $21,000,000 $21,109,343 51.22% $51,416 $241,167 $292,583 RE09 FHLB FED AGENCY 12/24/18 7/22/19 51 2.558% 4,927,375 5,000,000 5,000,000 4,984,100 12.20% 10,721 44,267 54,987 RE10 FHLB FED AGENCY 12/24/18 7/23/19 52 2.558% 4,927,029 5,000,000 5,000,000 4,983,750 12.20% 10,721 44,267 54,987 RE11 FHLMC FED AGENCY 3/4/19 7/23/19 52 2.443% 4,952,608 5,000,000 5,000,000 4,983,750 12.20% 10,419 19,494 29,914 RE12 FHLB FED AGENCY 3/22/19 7/23/19 52 2.410% 4,958,829 5,000,000 5,000,000 4,983,750 12.20% 10,376 13,389 23,765 (3) $40,765,842 $46,000,000 ($5,000,000) $41,000,000 $41,044,693 100.00% 93,654 362,584 456,238 (2) 178,739 178,739 $93,654 541,323 634,977 NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of May,2019 was 2.45%. (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.4706%. (4) The market value of the portfolio on May,2019 was$41,044,693. (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 June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 67 of 100 Page 7 of 34 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) May 2019 Fiscal Period 11/2019 Summarized by Account Report Generated on Jun 11,2019 2:24:42 PM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $956,068 CASH ACCOUNTS/PAYROLL CLEARING $20,000 CASH ACCOUNTS/PETTY CASH $3,400 CASH ACCOUNTS/TEMPORARY INVESTMENTS $41,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 $53,188,920 DUE FROM/DUE FROM S/I $790,011 INVENTORY/SUPPLIES&MATERIAL INV $2,155,283 PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104 PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572 PREPAID ACCOUNTS/PREPAID EXPENSES $988,611 PREPAID ACCOUNTS/PREPAID INSURANCE $2,825 PREPAID ACCOUNTS/PREPAID RETIREMENT $2,754,113 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $108,704 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $226,961 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA $1,837 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $71,553 RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $13,650 RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $100,640 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $3,462 Current Assets $123,966,134 Net Property,Plant and Equipment CONTRIBUTED FIXED ASSETS/ACC DEPR-CONTRIB ASSETS ($61,491,489) CONTRIBUTED FIXED ASSETS/CONTRIBUTED SEWER LINES $159,795,333 FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $35,820,635 FIXED ASSETS/ACC DEPR-BUILDINGS ($14,154,661) FIXED ASSETS/ACC DEPR-FURN&EQUIP ($9,236,015) FIXED ASSETS/ACC DEPR-OUTFALL ($3,768,376) FIXED ASSETS/ACC DEPR-PUMPING STATIONS ($35,288,443) FIXED ASSETS/ACC DEPR-SEWAGE COL SYS ($73,525,809) FIXED ASSETS/ACC DEPR-TREATMENT PLANT ($228,809,775) FIXED ASSETS/ACC DEPR-VEHICLES ($5,217,732) FIXED ASSETS/ACCUM DEPRC-RECY WATER ($9,680,325) FIXED ASSETS/BUILDINGS $44,238,508 FIXED ASSETS/FURNITURE&EQUIPMENT $13,841,424 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 $379,247,498 FIXED ASSETS/TREATMENT PLANT $341,675,108 FIXED ASSETS/VEHICLES $7,695,424 Net Property,Plant and Equipment $652,402,342 TOTAL ASSETS $776,368,476 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($4,165) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($670,757) CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($4,386,388) CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,193,763) Page 8 of 34 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) May 2019 Fiscal Period 11/2019 Summarized by Account Report Generated on Jun 11,2019 2:24:42 PM CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($25,493) CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($674) CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931) CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING ($7,575) CURRENT LIABILITIES/PERMIT CLEARING ($611) CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($41,080) CURRENT LIABILITIES/RETIREMENT CONTRIB W/H ($7,888) CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $16,238 DEF.COMP.CONTRIB W/H/ICMA $0 DUE TO/DUE TO DEBT FUND ($3,528,591) DUE TO/DUE TO S/C ($42,081,750) DUE TO/DUE TO S/I ($783,408) 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 $7,901,277 LIABILITIES/UNEARNED INTEREST ($70,504) MEDICAL LIABILITIES/DELTA DENTAL $569 MEDICAL LIABILITIES/DISABILITY INS $244 MEDICAL LIABILITIES/HEALTH NET $4,316 MEDICAL LIABILITIES/KAISER PERMANENTE $943 MEDICAL LIABILITIES/LIFE INS $39 MEDICAL LIABILITIES/OCCUPATIONAL HEALTH $1,064 MEDICAL LIABILITIES/POST EMP.BENEFIT-OPEB $0 PAYROLL TAXES WITHHELD/CALIFORNIA WITHHOLDING $0 PAYROLL TAXES WITHHELD FEDERAL WITHHOLDING $0 PAYROLL TAXES WITHHELD/MEDICARE WITHHOLDING ($1,838) REIMBURSEMENT FEES ($62,237) Total Liabilities ($183,315,051) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE ($38,409,231) FUND EQUITY/CAPITAL COST SHARING ($115,056,482) FUND EQUITY/CONTRIBUTED SEWER LINES ($159,795,333) FUND EQUITY/EXPENDITURE SUMMARY $77,335,766 FUND EQUITY/GENERAL FIXED ASSET GROUP ($210,549,556) FUND EQUITY/STATE&FED CAPITAL GRANT ($75,301,279) YEAR TO DATE REVENUES/REVENUE SUMMARY ($71,277,310) Total Fund Equity ($593,053,425) TOTAL LIABILITIES AND FUND EQUITY ($776,368,476) Page 9 of 34 CENTRAL CONTRA COSTA SANITARY DISTRICT June 11, 2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS FROM: AMAL LYON SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending May 31, 2019: YTD YTD Fav/(Unfav) S/C Revenues: Budgeted Actual Variance Explanation Property tax revenue received from the County was Total $ 44,822,391 $ 50,753,184 $ 5,930,793 higher than budgeted. FY YTD FY SIC Expenses: Budget* Actual Remaining % Spent Total $ 52,287,827 $ 32,530,003 $ 19,757,824 62.21% Includes 17118 carry-over($6,968,827) June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 70 of 100 Page 10 of 34 AWLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 002-SEWER CONSTRUCTION (Capital) May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 2:23:43 PM 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% $7,150,000 $7,150,000 0.0% Other $625,581 $2,090,339 234.1% $17,734,391 $23,055,214 30.0% $20,813,000 ($2,242,214) 110.8% Sewer Service Charges $0 $62,781 0.0% $27,088,000 $27,697,970 2.3% $27,926,268 $228,298 99.2% Total Revenue $625,581 $2,153,120 244.2% $44,822,391 $50,753,184 13.2% $55,889,268 $5,136,084 90.8% Page 11 of 34 Sewer Fund(Capital)Spending FY 18-19 $45,000,000 $39,907,366 $40,000,000 36,284,660 $35,000,000 $32,401,823 $30,000,000 $29,197,153 2,530,003 $23,890,698 $26,513,645 $29,617,412 $25,000,000 $19,397,124 $26,049,059 $20,000,000 $23,808,150 $13,377,477 $20,736,779 $15,000,000 $9,429,510 $18,379,941 $14,503,936 $10,000,000 $3,996,336 $11,543,304 $5,000,000 $1,426,829 $8,485,345 $ 939 $3,404,835 $1,600, July August September October November December January February March April May -Projected' Actual Columnl July August September I October November I December January IFebruary IMarch April May Projected* $ 1,426,829 $3,996,336 $ 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 Actual I 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 *Projected-Current year budget allocated by month based on historical spending in previous 2 years June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 72 of 100 Page 12 of 34 PROGRAM/GM1851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:5/31/2019 PERIOD 11/2019 C(A-B) F(D+E) (C+D+E) 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 HE 17-18) PYS(THRU HE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 TYPE CS Collection System $ 29,409,417 30,841,697 (1,432,280) 19,347,000 1,080,000 20,427,000 18,994,720 15,062,297 3,932,426 TYPE TP Treatment Plant 32,746,274 26,758,622 5,987,652 16,865,000 1,231,177 18,096,177 24,083,829 13,927,995 10,155,818 TYPE GI General Improvements 9,024,737 7,225,141 1,799,596 4,750,000 (1,208,677) 3,541,323 5,340,919 2,054,578 3,286,345 TYPE RW Recycled Water 2,382,894 1,769,035 613,859 2,857,000 - 2,857,000 3,470,859 1,485,133 1,985,725 CIB Contingency - - - 1,500,000 (1,102,500) 397,500 397,500 - 397,500 OTAL DISTRICT IF $ 73,563,322 $ 66,594,495 $ 6,968,827 $ 45,319,000 - $ 45,319,000 $ 52,287,827 $ 32,530,003 $ 19,757,814 June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 73 of 100 Page 13 of 34 PROGRAM/GM1851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:5/31/2019 PERIOD 11/2019 C(A-B) OFF 7 (C+D+E) 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 CS Collection S s 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 368,829 431,171 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 22,281 227,719 8249 CSO Dump Pad Modifications 60,000 - 60,000 - - 60,000 11,262 48,738 *8412 PH Grayson Creek Trunk 15,100,000 15,061,359 38,641 - - 38,641 201,823 (163,182) 8419 Collection System Planning LT 885,000 884,387 613 100,000 100,000 100,613 94,455 6,158 *8430 Lafayette Sewer Renovation Phase 11 4,319,000 4,289,317 29,683 - - 29,683 13,566 16,117 8433 S.Orinda Sewer Renovation Phase 6 1,962,127 3,066,717 (1,104,590) 2,758,873 2,758,873 1,654,283 1,612,844 41,439 8435 WC Sewer Renovation Phase 12 1,450,000 2,891,122 (1,441,122) 3,100,000 3,100,000 1,658,878 1,656,241 2,637 8436 Moraga/Crossroads PS Project 1,300,000 1,138,016 161,984 2,697,000 (250,000) 2,447,000 2,608,984 1,635,921 973,063 8441 CIPP Contract 17-20 300,000 80,247 219,753 100,000 100,000 319,753 193,332 126,421 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 8445 N.Orinda Sewer Renovation 636,000 768,680 (132,680) 3,731,000 3,731,000 3,598,320 3,535,375 62,945 8446 Lafayette Sewer Renovation Phase 12 636,000 1,216,107 (580,107) 3,397,600 3,397,600 2,817,493 2,498,083 319,410 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 300,000 324,630 131,170 193,460 8449 Collection System Modeling Support 100,000 56,761 43,239 100,000 100,000 143,239 59,834 83,405 8450 Development Sewerage Support 400,000 240,770 159,230 250,000 480,000 730,000 889,230 954,405 (65,175) 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 454,304 45,696 *8453 Willows Sewer Repair 98,000 98,000 - - - - - - ***8454 So.Orinda Sewer Ren.Ph.7 - - 500,000 500,000 500,000 559,945 (59,945) ***8455 W.C.Sewer Renov.Ph.13 - - - - 500,000 500,000 500,000 597,548 (97,548) ***8456 Danville Sewer Ren.Ph.3 - 500,000 500,000 500,000 316,958 183,042 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 2,197 97,803 ***8459 Lafayette Sewer Renov.Ph.14 - - - - 100,000 100,000 100,000 - 100,000 ***8460 WC Sewer Renov.Ph.14 100,000 100,000 100,000 19,295 80,705 ***8461 So.Orinda Sewer Ren.Ph.8 - - - - 100,000 100,000 100,000 1,721 98,279 Rounding 3 Total FY 2018-19 CS Amount (1,432,280) 19, ,080,000 20,427,000 MW 18,994,720 *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 June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 74 of 100 Page 14 of 34 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:5/31/2019 PERIOD 11/2019 C(A-B) OFF 7 (C+D+E) 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 ment PI 7291 Pump&Blower Bldg.Seismic Upgrade 6,692,000 6,638,700 53,300 - - - 53,300 10,393 42,907 7292 5witchgearRefurbishment-Ph.2 770,000 433,911 336,089 200,000 - 200,000 536,089 39,361 496,728 7304 Instr&Controls PLC Upgrade 575,000 397,606 177,394 110,000 110,000 287,394 72,910 214,484 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 100,000 195,766 10,283 185,483 7320 Plant Energy Optimization 1,094,000 1,063,448 30,552 - - - 30,552 (58,857) 89,409 7322 Fire Protection System Ph.2 1,406,000 1,014,803 391,197 - - 391,197 323,362 67,835 7326 Equipment Replacement FY 15-FY 24 1,166,000 748,217 417,783 250,000 - 250,000 667,783 786,126 (118,343) 7327 Headwork's Screening Upgrade 8,144,000 7,845,455 298,545 76,000 - 76,000 374,545 172,423 202,122 7328 Influent Pump Electrical improvements 100,000 757 99,243 510,000 - 510,000 609,243 275,212 334,031 7329 MHF Burner Upgrade 220,000 156,933 63,067 - - 63,067 - 63,067 7330 Piping Renovation Phase 9 2,566,000 513,944 2,052,056 614,000 - 614,000 2,666,056 2,560,859 105,197 7339 T.Plant Control System 1/0 Replacement 470,000 605,231 (135,231) 900,000 900,000 764,769 653,013 111,756 7341 WC/Grayson Creek Levee Rehab 100,000 - 100,000 - - - 100,000 72,452 27,548 7348 Solids Handling Facility Improvements 4,975,000 4,516,007 458,993 5,715,000 5,715,000 6,173,993 3,636,018 2,537,975 7349 Aeration&Energy Upgrade 300,000 35,539 264,461 1,200,000 - 1,200,000 1,464,461 473,631 990,830 7351 Mechanical&Concrete Renovation 1,300,000 1,254,155 45,845 3,000,000 3,000,000 3,045,845 1,432,499 1,613,346 7352 UV Disinfection Upgrades - - - 500,000 - 500,000 500,000 134,507 365,493 7353 Outfall Improvements Ph.7 - - - 400,000 (300,000) 100,000 100,000 35,569 64,431 7354 TP Security Improvements 87,000 2,995 84,005 50,000 - 50,000 134,005 22,058 111,947 7355 Odor Control Upgrade Ph.1 44,000 - 44,000 200,000 200,000 244,000 - 244,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,873 104,750 7360 Existing Plant Facility Drawing 100,000 83,040 16,960 100,000 - 100,000 116,960 66,037 50,923 7362 POB Seismic Upgrades 400,000 135,591 264,409 1,100,000 1,831,177 2,931,177 3,195,586 1,775,827 1,419,759 7363 Treatment Plant Planning 450,000 348,907 101,093 450,000 - 450,000 551,093 329,223 221,870 7364 TP Safety Enhancement Ph.5 - - - 100,000 - 100,000 100,000 - 100,000 Rounding (16) Total FY 2017-18 TP Amount $ 32,746,274 26,758,622 5,987,652 ,231,177 18,096,177 24,083,829 13,927,995 10,155,818 *Italic Projects open but not in CIB for 18/19 June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 75 of 100 Page 15 of 34 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:5/31/2019 PERIOD 11/2019 C(A-B) OFF 7 (C+D+E) 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 HE 17-18) PYS(THRU HE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 TYPE oralImprovements 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 56,463 36,968 8238 Asset Management 2,969,185 2,790,236 178,949 400,000 - 400,000 578,949 550,182 28,767 8240 IT Development 2,188,794 2,187,431 1,363 1,750,000 (450,000) 1,300,000 1,301,363 243,213 1,058,150 8243 Server Room Relocation 955,430 515,656 439,774 880,000 164,570 1,044,570 1,484,344 662,704 821,640 8247 Property&Building Improvements 400,000 178,767 221,233 300,000 (363,606) (63,606) 157,627 172,991 (15,364) 8248 Cyber Security 75,000 - 75,000 - - - 75,000 - 75,000 8516 District Equipment Acquisition 676,000 590,745 85,255 200,000 200,000 285,255 128,413 156,842 8517 Vehicle Replacement Program 1,199,000 603,959 595,041 650,000 - 650,000 1,245,041 216,960 1,028,081 9999 Capital Project Clearing(Accounting Use Only)** - (60,000) 60,000 - - 60,000 (2) 60,002 Rounding 4 otal FY 2017-18 GI Amount 208,677) 3,541,323 5,340,919 2,054,578 June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 76 of 100 Page 16 of 34 PROGRAM/GM1851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:5/31/2019 PERIOD 11/2019 C(A-B) OFF 7 (C+D+E) 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 Recycled Wate 7306 Zone 1 Recycled Water 497,894 484,984 12,910 35,000 - 35,000 47,910 23,186 24,724 7346 Surge Analysis 16-17 155,000 3,125 151,875 50,000 - 50,000 201,875 144,186 57,689 7361 Filter Plant Improvments 330,000 162,293 167,707 2,457,000 (250,000) 2,207,000 2,374,707 1,081,087 1,293,620 7365 Recycle Water Clearwell Repairs 1,400,000 1,118,633 281,367 300,000 - 300,000 581,367 236,674 344,693 7366 ReW Distribution System Renov.Program - - - 15,000 - 15,000 15,000 - 15,000 ***7368 Water Exchange Project - - - - 250,000 250,000 250,000 - 250,000 Rounding (1) Total FY 2016-17 RW Amount 2,382,894 1,769,035 613,859 2,857,000 2,857,000 3,470,859 1,485,133 1,985,725 *** Not in 18/19 Budget. New projects opened in May 2019. Funds transferred from DP7361 9990 CONTINGENCY-ALL PROGRAMS - - 1,500,000 (1,102,500) 397,500 397,500 397,500 GRAND TOTAL $ 73,563,322 66,594,495 6,968,827 45,319,000 - 45,319,000 52,287,827 32,530,003 19,757,814 June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 77 of 100 Page 17 of 34 FY 18-19 CAPITAL BUDGET TRANSFERS PERIOD ENDING:5/31/19 osi ion Memo to GM Position Paper Position Paper Position Paper Position Paper Paper:5/2/19 approved 10/4/19 item 2 11/15 Item 10 11/1 item 7 & 12/20 item 7 Deputy GM item 11(7368) 09/05/18 &Deputy GM &GM 12/12 GM 12/19 &GM signature 04/19 &GM 18/19 Contingency signature 1/08/19 signature PROJ.# PROJECTS IQArll TOTAL Balance *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 6534 Harper Lane Area CAD(new Project) - 800,000 - - 800,000 7315 Applied Research - (300,000) - - (300,000) 7353 Outfall Improvements - (300,000) - - (300,000) 7361 Filter Plant&Clearwell - - - (250,000) (250,000) 7367 Concord Main Metering Station - 250,000 - - 250,000 **7368 Water exchange Project - - - 250,000 250,000 8436 Moraga Crossroads Pump Station - (250,000) - - - (250,000) 8243 Server Room Relocation Proj. - 164,570 - - 164,570 7362 POB Seismic Upgrades - 1,831,177 - - 1,831,177 8207 General Security&Access - (559,641) - - (559,641) 8240 IT Technology Development - (450,000) (450,000) 8247 Property&Building Improvements - (363,606) (363,606) 6679 Cordell Drive CAD - 123,443 - 123,443 6603 North Jackson CAD - (123,443) - - (123,443) 8450 Development Sewerage - - 480,000 480,000 9990 Capital Projects-Contingency - (622,500) - (480,000) - (1,102,500) 397,500 Tota I * Not actual transfers. All part of one project split into individual projects for construction ** New project-not in 18/19 Budget June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 78 of 100 Page 18 of 34 O&M PROJECTS- EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 05/31/19 11/2019 0M043 - 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 $ - $ - $ - $ 1361$ 92,598 0M080 - CoCo Farm(Kiewit Future Farm Proposal) Prior years Project expended Expenditure type I 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 $ 206,827 $ 1,444 $ 225 $ - $ 403 $ 241 $ - $ - $ - $ 851 $ - $ 463 $ - $ 3,628 $ 210,455 Other Charges $ 74,996 - - - - 561 - - - - - - - - $ 74,996 Total $ 281,824 $ 1,444 $ 225 $ $ 403 $ 802 $ $ $ $ 851 $ $ 463 $ $ 3,628 $ 285,451 0M083 - 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 $ - $ 53,988 $ 77,636 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 $ $ 53,988 $ 77,636 N:\Accounting\GMTEMPI\Financials and Closing\2019 Financials\O&M Projects Activity YTD 18 19.xlsx June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 79 of 100 Page 19 of 34 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS May,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) $27,500,000 $28,500,000 ($1,000,000) $27,500,000 $27,643,187 41.98% $58,297 $209,665 $267,962 933 US Gov't Agency Dscnt 06/08/18 05/28/19 0 2.32 4,956,560 5,000,000 (5,000,000) 0 0 0.00% 3,313 37,178 40,491 938 FHLMC FHLMC 12/06/18 6/03/19 2 2.57 4,937,847 5,000,000 5,000,000 5,000,000 7.63% 10,764 50,694 61,458 940 US Gov't T-Bill 12/21/18 06/20/19 79 2.52 4,938,284 5,000,000 5,000,000 4,994,650 7.63% 10,570 44,667 55,238 941 US Gov't T-Bill 2/28/19 8/29/19 89 2.49 3,950,860 4,000,000 4,000,000 3,977,720 6.11% 8,370 16,740 25,110 942 US Gov't T-Bill 3/4/19 8/29/19 89 2.50 3,951,742 4,000,000 4,000,000 3,977,720 6.11% 8,404 15,724 24,129 943 FHLMC Fed Agency 3/06/19 6/12/19 11 2.46 4,967,197 5,000,000 5,000,000 4,997,100 7.63% 10,376 18,744 29,121 944 T-Bill US Tbill 3/21/19 9/19/19 110 2.50 4,938,575 5,000,000 5,000,000 4,965,500 7.63% 10,463 13,838 24,300 945 FHLB Agency Gov 4/3/19 10/1/19 122 2.44 4,940,169 5,000,000 5,000,000 4,961,000 7.63% 10,247 9,256 19,503 946 FHLMC Fed Agency 5/28/19 11/12/19 164 2.37 4,946,100 5,000,000 5,000,000 4,947,350 7.63% 1,283 (4) $70,027,335 $66,500,000 ($1,000,000) $65,500,000 $65,464,227 100.00% 132,088 416,507 547,311 (3) (5) 5,729 378,558 384,287 $137,817 $795,064 $931,598 NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of May 2019 was 2.45%. (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.4643%. (4) The market value of the portfolio on May 31,2019 was$65,464,227. GASB 31 requires adjusting investments to market value. The District will adjust annually,but report market values monthly. (5) The District has sufficient funds available combined with secured SSC and Property Tax received in December and April to cover six months of cash flow needs. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 80 of 100 Page 20 of 34 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:002-SEWER CONSTRUCTION(Capital) May 2019 Fiscal Period 11/2019 Summarized by Account Report Generated on Jun 11,2019 2:24:42 PM TOTAL ASSETS Current Assets CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003 CASH ACCOUNTS/CASH $2,021,255 CASH ACCOUNTS/TEMPORARY INVESTMENTS $65,500,000 DUE FROM/DUE FROM DEBT FUND $3,685,382 DUE FROM/DUE FROM RIE $42,081,750 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $64,675 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $122,676 RECEIVABLE ACCOUNTS/CAD RECEIVABLE $162,781 Current Assets $114,458,520 Net Property,Plant and Equipment FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $32,530,002 Net Property,Plant and Equipment $32,530,002 TOTAL ASSETS $146,988,522 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($286) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($473,530) CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($1,089,458) CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($220,442) DUE TO/DUE TO DEBT FUND ($67,318) DUE TO/DUE TO RIE ($53,188,920) LIABILITIES/UNEARNED INTEREST ($189,083) Total Liabilities ($55,229,037) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($32,530,002) FUND EQUITY/AVAILABLE FUND BALANCE ($41,006,302) FUND EQUITY/EXPENDITURE SUMMARY $32,530,002 YEAR TO DATE REVENUES/REVENUE SUMMARY ($50,753,184) Total Fund Equity ($91,759,486) TOTAL LIABILITIES AND FUND EQUITY ($146,988,522) Page 21 of 34 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 2:23:43 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $9,645 $14,811 53.6% $885,595 $939,297 6.1% $960,250 520,953 97.8% Total Revenue $885,595 $939,297 Page 22 of 34 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 1:56:19 PM $30,000 ❑Period Budget $1,000,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $25,000 $800,000- $20,000- $600,000- $15,000-,// 800,000$20,000 $600,000$15,000 ' $400,000- $10,000-1/ 400,000$10,000 ' $200,000- $5,000-// $0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $29,540 $16,066 $13,474 $894,940 $802,219 $92,721 Totals $29,540 $16,066 $13,474 $894,940 $802,219 $92,721 Page 23 of 34 CENTRAL CONTRA COSTA SANITARY DISTRICT SELF-INSURANCE FUND TEMPORARY INVESTMENTS MAY,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,237,489 100.00% $14,982 $131,398 $146,380 (3) $7,200,000 $7,200,000 $0 $7,200,000 $7,237,489 100.00% 14,982 131,398 146,380 (2) 8,596 8,596 $14,982 $139,994 $154,976 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of May,2019 was 2.450%. (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.450%. (4) The market value of the portfolio on May 31,2019 was$7,237,489. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 84 of 100 Page 24 of 34 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:003-SELF-INSURANCE May 2019 Fiscal Period 11/2019 Summarized by Account Report Generated on Jun 11,2019 2:24:42 PM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $86,366 CASH ACCOUNTS/TEMPORARY INVESTMENTS $7,200,000 DUE FROM/DUE FROM R/E $783,408 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $29,481 Current Assets $8,099,255 TOTAL ASSETS $8,099,255 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/ACCOUNTS PAYABLE ($9,888) CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($882,230) DUE TO/DUE TO R/E ($790,011) Total Liabilities ($1,682,129) Total Fund Equity FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000) FUND EQUITY/EXPENDITURE SUMMARY $802,219 FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,280,047) YEAR TO DATE REVENUES/REVENUE SUMMARY ($939,297) Total Fund Equity ($6,417,125) TOTAL LIABILITIES AND FUND EQUITY ($8,099,255) Page 25 of 34 jorM' Central Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004-DEBT SERVICE May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 2:23:43 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $0 $0 0.0°% $3,528,591 $3,531,028 0.1% $3,611,037 580,009 97.8% Total Revenue 0.0% $3,528,591 $3,531,028 0.1% $3,611,037 Page 26 of 34 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE May 2019 Fiscal Period 11/2019 Report Generated on Jun 11, 2019 1:56:19 PM $1 ❑Period Budget $1,000,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $800,000- $0- $600,000- $0- $400,000- ($0)- $200,000- ($1)- 800,000$0 $600,000$0 $400,000($0) $200,000($1) $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $0 $0 $0 $764,278 $868,491 ($104,213) Totals $0 $0 $0 $764,278 $868,491 ($104,213) Page 27 of 34 ' Central Contra Costa Sanitary District Protecting public health and the environment Balance Sheet Fund:004-DEBT SERVICE May 2019 Fiscal Period 11/2019 Summarized by Account Report Generated on Jun 11,2019 2:24:42 PM TOTAL ASSETS Current Assets DUE FROM/DUE FROM RIE $3,528,591 DUE FROM/DUE FROM S/C $67,318 L.T.DEBT ACCOUNTING/DEPOSIT W/TRUSTEE-RESERVE $0 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $99,384 Current Assets $3,695,292 TOTAL ASSETS $3,695,292 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities DUE TO/DUE TO S/C ($3,685,382) L.T.DEBT ACCOUNTING/BOND ACR INTEREST PAYABLE $0 L.T.DEBT ACCOUNTING/BONDS PAYABLE ($19,450,000) Total Liabilities ($23,135,382) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $24,673,496 FUND EQUITY/EXPENDITURE SUMMARY $868,491 LIABILITIES/DEFERRAL-BOND REFUNDING ($2,570,870) YEAR TO DATE REVENUES/REVENUE SUMMARY ($3,531,028) Total Fund Equity $19,440,090 TOTAL LIABILITIES AND FUND EQUITY ($3,695,292) Page 28 of 34 DASHBOARD DATA (SELECTED DATA ON MATTERS OF CONTINUING BOARD INTEREST) June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 89 of 100 Page 29 of 34 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% ,LO 16;,",, LOti ,Lti�,titi� ,Lti�,0�ti ,Oti ,O`0,O`0,Otil 10ti00 ,LO IIIIIIIIIIIIIIIIIIIIIIIIIi UAAL Funded% IIIIIIIIIIIIIIIIIIIIIIIIIiUAAL 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). June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 90 of 100 Page 30 of 34 CIB TRANSFERS SINCE FY 2016=17 Cause for Transfers Total Original Project Budgets and Transfers #of transfers 8 $30,000,000 7 6 $25,000,000 5 $20,000,000 4 3 $15,000,000 2 $10,000,000 1 0 $5,000,000 F.Cost exceeded initial budget ■A.Bundling ■B.Cashflow accelerations ■C.Developer/CAD or E.New project scope other cost neutral D. New Project C. Developer/CAD or other cost neutral B.Cashflow accelerations D.New Project ■ E.New project scope ■F.Cost exceeded $- A. Bundling initial budget ,1 ,kr, �J . Notes: There were no additional transfers in May 2019 (a transfer for$250,000 related to DP 7368-Water Exchange was recorded earlier). June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 91 of 100 Page 31 of 34 CIB TRANSFERS=CURRENT YEAR Cause for Transfers Total Original Project Budgets and Transfers #of transfers $3,000,000 $2,500,000 $2,000,000 1 $1,500,000 0 � $1,000,000 ■ °C° ■ O ■ O ■ ■ C. ■ N c a Q o v v 7 3 d V N 7 Q U Q ° $500,000 F.Cost exceeded initial budget v o fl o +71 3 > u d 3 u ' g c ° o r z LL E.New project scope N u o w D.New Project U C.Developer/CAD or other cost neutral m f B.Cashflow accelerations $ A. Bundling a t� Notes: There were no additional transfers in May 2019 (a transfer for$250,000 related to DP 7368-Water Exchange was recorded earlier). June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 92 of 100 Page 32 of 34 FY 2018-19 Running Expense Fund Total Cash & Investment Balances (Actuals through May 2019) $52.5 $49.8 $50.0 $46.7 $40 $43.7 $44.3 $40.2 $42.5 42.0 $40.9 .3 $40.0 $37.4 - $37.1 $33.9 $37.3 $25.6 $31.5 $31.9 $30.0 $29.6 7 $ 4.2 $21.9 $20.6 $20.5 $19.4 $20.0 $15.3 $13.5 $10.0 $0.0 yeti �� Jho e�.p c�°gyp e��p e�.p ��a tea �� Pit aJ NIP °� MProjected 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 *** Interfund activity to be reconciled at year end to transfer over cash that represents capital labor paid for out of R/E Cash Account June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 93 of 100 Page 33 of 34 FY 2018-19 Sewer Construction Fund Total Cash & Investment Balances (Actuals through May 2019) $70.0 $68.2 $67.5 $60.0 $59.1 $54.0 $53.6 $54.9 $53.0 $51.3 $51.8 $50.9 $49.8 $50.0 $47.9 $44.1 $40.4 $40.0 $37.3 $35.7 537.9 $34.3 $30.0 $36.4 $31.6 $33.0 $32.4 $31.1 $29.J$22.7 $30.0 $30.4 $20.0 $10.0 $0.0 �y4, met` �� Z %o O� F MProjected 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 *** Interfund activity to be reconciled at year end to transfer over cash that represents capital labor paid for out of R/E Cash Account June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 94 of 100 Page 34 of 34 Sewer Construction Budget, Commitments and Capacity $120 $120 $ in millions $100 — — — — $100 1 do � 1 $80 *01 $80 i 1 � 1 $60 1 120.6 1 151.3 $60 1 � 1 $40 i $40 13.2 24.7 42.9 $20 45.5 45.5 $20 $0 - _ -___` ~ $0 18/19 19/20 20/21 21/22 22/23 Fiscal Year ®Approved and Projected Budget per FY Additional contractual capacity with approved rate adjustments 1====1 Remaining contractual capacity with existing rates Committed already(contracted) Sewer Construction funding capacity from Existing Rates Sewer Construction funding capacity with approved 4 year adjustments and planned borrowing *Future years amounts may differ to the extent of reserve drawdowns. June 25, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 95 of 100