The URL can be used to link to this page

Home My WebLink About04. Receive December 2019 Financial Statements and authorize quarterly reports going forward Page 1 of 34 Item 4. CENTRAL SAN BOARD OF DIRECTORS vie . , Hill. , , . . POSITION PAPER MEETING DATE: FEBRUARY20, 2020 SUBJECT: RECEIVE THE DECEMBER 2019 FINANCIAL STATEMENTS AND INVESTMENT REPORTS AND AUTHORIZE REDUCTION IN THE FREQUENCYOF INTERIM FINANCIAL REPORTING FROM MONTHLYTO QUARTERLY PROSPECTIVELY SUBMITTED BY: INITIATING DEPARTMENT: CHRISTOPHER THOMAS, FINANCE ADMINISTRATION-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 ISSUE Receive December 2019 Financial Statements and Investment Reports and consider transitioning from monthly to quarterly interim financial reporting BACKGROUND Change to Prospective Frequency of Reporting At the January 28, 2020 Finance Committee meeting, Committee Members expressed interest in receiving the Financial Statements and Investment Reports packet on a quarterly rather than monthly basis prospectively. Staff is supportive of this concept as management is already conducting in-depth monthly budget-to-actual monitoring and as quarterly reporting is consistent with many of Central San's peer agencies (East Bay Municipal Utility District, Orange County Sanitation District, Union Sanitary District, Napa San, etc.). Should the frequency of interim financial reporting to the Board and Finance Committee be approved by the Board, the next full Financial Statements and Investment Reports packet will be produced for the third quarter of FY 2019-20 ending March 31, 2020. Commencing with the upcoming February 20, 2020 Regular Board Meeting Agenda Packet- Page 19 of 161 Page 2 of 34 third quarter report, staff also will make revisions to the report parameters to report"quarter-to-date," rather than "month-to-date" results to improve comparability and usefulness of the report to the Board, management, and public. Should any matters of financial and/or budgetary significance be identified by management at an interim non-quarterly period, this would be communicated to the Board separately. As Central San's current Investment Policy specifies monthly investment reporting, staff will continue to produce the investment reports on a monthly basis for now. Upon the next scheduled review of the investment policy, staff raise for consideration whether an amendment is warranted to change the frequency of investment reporting from monthly to quarterly, as quarterly reporting on investments is still in compliance with state law(California Government Code section 53646) as well as how many similar agencies report on this topic. Summary of Monthl'y Financial Results Attached for review are the Financial Statements and Investment Reports for December 2019. With the first half of Fiscal Year(FY)2019-20 now complete, budgetary results for the Operations and Maintenance (O&M), Sewer Construction, Self-Insurance, and Debt Service funds continue to reflect that activities-to- date are on target and under budget in the aggregate. The O&M Fund expenditure results are favorable at approximately 45.6% of the total FY 2019-20 budget, or 5.0% under the year-to-date budget target of 50.6°/x. O&M Fund revenues are also slightly above the year-to-date target by 2.3%, primarily attributable to favorable results for sewer service charges. With the close of December 2019, Central San has received its first installment of sewer service charges from the Contra Costa County Auditor-Controller's Office. As reflected by the modest positive revenue variance noted previously, this installment was largely on target with budgetary projections. The slightly favorable results for sewer service charges results mainly from higher flows from non-residential customers as well as development activity being slightly higher than projected in the FY 2019-20 budget. The Sewer Construction Fund has spent$27.3 million or 36.6% of total capital project appropriations for FY 2019-20, falling just short (3.5%)of the 40.1% capital project expenditure rate target through the first half of the fiscal year. The pace of several capital projects is projected to accelerate in the second half of the fiscal year following the District's expected and historical "s-curve" trend for capital projects. Most notably, significant progress on the following large capital projects is expected in the second half of the fiscal year: Solids Handling Facility Improvements (District Project(DP) 7348), Mechanical and Concrete Renovations (DP 7351), Moraga/Crossroads Pump Station (DP 8436), and Enterprise Resource Planning Replacement (DP 8250) capital projects. On the revenue side, the Sewer Construction Fund is reporting a positive year-to-date variance of 9.8%. This relatively large positive year-to-date revenue variance is predominantly attributable to facilities capacity fees generated from the large 200 apartment Avalon Bay development project in Pleasant Hill and other smaller developments coming in higher than projected in the FY 2019-20 budget. ALT ERNAT IVES/CONSIDERAT IONS The Board may wish not to transition to quarterly financial reporting. In this case financial reports would continue to be provided to the Finance Committee and Board for review and acceptance on a monthly basis. FINANCIAL IMPACTS There are no direct fiscal impacts from either the acceptance of the December 2019 Financial Statements and Investment Reports or from transitioning to quarterly financial reporting from monthly(status quo). February 20, 2020 Regular Board Meeting Agenda Packet- Page 20 of 161 Page 3 of 34 COMMITTEE RECOMMENDATION The Finance Committee met on February 18, 2020 and recommended the Board's acceptance of the December 2019 Financial Statements and Investment Reports. The Finance Committee also brought forth the concept of reducing the frequency of interim financial reporting to the Finance Committee and Board from monthly to quarterly and recommended the Board's approval of this change prospectively given the considerations outlined in the Background section. RECOMMENDED BOARD ACTION Receive the December 2019 Financial Statements and Investment Reports and authorize reduction in the frequency of interim financial reporting from monthly to quarterly prospectively. Strategic Plan Tie-In GOAL THREE:Be a Fiscally Sound and Effective Water Sector Utility Strategy 2- Manage costs ATTACHMENTS: 1. December 2019 Financial Statements and Investment Reports February 20, 2020 Regular Board Meeting Agenda Packet- Page 21 of 161 Page 1 of 31 CENTRAL CONTRA COSTA SANITARY DISTRICT January 15,2020 TO: THE BOARD OF DI CTORS VIA: KEVIN MIZUNO FROM: CHRIS THOMAS SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through December 31,2019 YTD Total FY YTD YTD Fav/(Unfav) O&M Revenues: Budget Budgeted Actual Variance Explanation Direct SSC higher than budgeted due to increased development and metered Total $ 89.560 370 $ 40 899.449 $ 41,849.877 $ 950,428 consumption. SSC County Higher than budgeted. O&M Expenses: Total Labor Charges $ 52,789,084 $ 26,056,026 $ 24,394,762 $ 1,661,264 Some positions budgeted for in July are filled later in the fiscal year resulting in savings, and charges of labor to capital projects higher than planned for in O&M budget. Unfunded Liabilities 12,436,841 6,218,298 5,929,126 289,172 Variance due to vacancy projections spread evenly throughout the year,however actual staffing termination`s and additions occurs sporadically during the year. Chemicals 1,620,000 809,982 717,549 92,433 No significant variances. Utilities 4,209,350 2,104,638 2,012,501 92,137 No significant variances. Repairs&Maintenance 5,242,867 2,701,298 2,168,470 532,828 Mainly due to Outside Repairs being lower than budgeted thus far in the fiscal year. Budget is spread evenly throughout the year,however actual activity occurs sporadically every month. Variance should be minimal by year end. Hauling&Disposal 1,186,175 583,052 310,549 272,503 Mainly due to hazardous waste disposal being lower than budgeted thus far in the fiscal year. Budget is spread out evenly throughout the year,however actual activity occurs sporadically every month. Professional&Legal Services 874,300 437,100 156,418 280,682 Lower mostly due to lower Legal expenses thus far in the fiscal year. Outside Services 3,639,547 1,861,269 1,019,714 841,555 Mainly due to technical services expenses being lower than budgeted thus far in the fiscal year. Materials&Supplies 2,152,127 1,075,969 1,013,563 62,406 No significant variances. Other Expenses 2,464,834 1,581,562 1,327,786 253,776 Mainly due to Public Information,BACWA expenses,&Outside Organization fees being lower than budgeted thus far in the fiscal year. Budget is spread evenly throughout the year,however actual activity occurs sporadically every month. All Other 969,650 897,318 898,604 (1,286) Minor variances for multiple account categories. Grand Total O&M Expenses $ 87.584,775 $ 44 326.512 $ 39 949.042 $ 4 3"470 February 20, 2020 Regular Board Meeting Agenda Packet- Page 22 of 161 Page 2 of 31 ``Central Contra Costa Sanitary District Revenue Report MTD Fund:001 -RUNNING EXPENSE(O&M) December 2019 Fiscal Period 6/2020 Report Generated on Jan 14,2020 10:33:17 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $0 $0 0.0°% $0 ($45,667) 0.0°% $14,570,000 $14,615,667 -0.3% HHW $8,000 $2,133 -73.3% $48,000 $41,103 -14.4% $968,000 $926,897 4.2% Other $379,329 $333,208 -12.2% $2,316,974 $2,351,168 1.5% $4,931,500 $2,580,332 47.7% Sewer Service Charges $37,288,645 $37,869,053 1.6% $38,534,475 $39,503,273 2.5% $69,090,870 $29,587,597 57.2°% Total Revenue $37,675,974 $38,204,394 1.4% $40,899,449 $41,849,877 2.3% $89,560,370 $47,710,493 46.7% February 20, 2020 Regular Board Meeting Agenda Packet- Page 23 of 161 Page 3 of 31 ACV Ls entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE (O&M) December 2019 Fiscal Period 06/2020 Report Generated on Jan 13, 2020 8:17:03 AM $45,000,000.00 —Budget ,326,512 —Actual $40,000,000.00 ,949,042 $35,000,000.00 251,685 ,362,529 $30,000,000.00- ,611,4 $25,000,000.00 493,756 - $20,000,000.00 _ 076,7 ,309,309 $15,000,000.00 ,01 ,029,620 $10,000,000.00 $7,943 $5,000,000.00 $6,553,088 $0.00- 11 Jul(1)2019 Aug(2)2019 Sep(3)2019 Oct(4)2019 Nov(5)2019 Dec(6)2019 Fiscal Periods Page 4 of 31 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE(O&M) December 2019 Fiscal Period 06/2020 Report Generated on Jan 13, 2020 8:17:03 AM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $3,152,929 $3,015,940 $136,989 4.3% $18,917,574 $17,974,847 $942,727 5.0% $38,060,443 47.2% EMPLOYEE BENEFITS $1,560,433 $1,485,047 $75,386 4.8% $9,362,598 $8,788,945 $573,653 6.1% $19,177,010 45.8% CAPITALIZED ADM OVERHEAD ($370,691) ($356,314) ($14,377) -3.9% ($2,224,146) ($2,369,028) $144,882 6.5% ($4,448,369) 53.3% DIRECTOR FEES&EXPENSES $12,053 $11,376 $677 5.6% $72,318 $73,604 ($1,286) -1.8% $144,650 50.9% CHEMICALS $134,997 $79,860 $55,137 40.8% $809,982 $717,549 $92,434 11.4% $1,620,000 44.3% UTILITIES $350,773 $319,676 $31,097 8.9% $2,104,638 $2,012,501 $92,137 4.4% $4,209,350 47.8% REPAIRS&MAINTENANCE $416,883 $397,066 $19,817 4.8% $2,701,298 $2,168,470 $532,828 19.7% $5,242,867 41.4% HAULING&DISPOSAL $108,842 $39,911 $68,931 63.3% $583,052 $310,549 $272,503 46.7% $1,186,175 26.2% PROFESSIONAL&LEGAL SERV $72,850 $68,222 $4,628 6.4% $437,100 $156,418 $280,682 64.2% $874,300 17.9% OUTSIDE SERVICES $282,642 $225,006 $57,636 20.4% $1,861,269 $1,019,714 $841,555 45.2% $3,639,547 28.0% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $825,000 $825,000 $0 0.0% $825,000 100.0% MATERIALS&SUPPLIES $179,474 $162,090 $17,384 9.7% $1,075,969 $1,013,563 $62,406 5.8% $2,152,127 47.1% OTHER EXPENSES $137,259 $86,608 $50,651 36.9% $1,581,562 $1,327,786 $253,776 16.0% $2,464,834 53.9% UNFUNDED LIABILITIES $1,036,383 $1,052,026 ($15,643) -1.5% $6,218,298 $5,929,126 $289,172 4.7% $12,436,841 47.7% Total Expenses $7,074,827 $6,586,514 $488,313 6.9% $44,326,512 $39,949,042 $4,377,470 9.9% $87,584,775 45.6% Color Key: 0 to 10%over budget > 10%over budget M Page 5 of 31 ZVO' Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE (O&M) December 2019 Fiscal Period 06/2020 Report Generated on Jan 13, 2020 8:19:24 AM $2,500,000 ❑Period Budget $15,000,000-' ❑YTD Budget 7h ❑Period Actual ❑ YTD Actual $2,000,000 $10,000,000- $1,500,000- $1,000,000- $5,000,000 10,000,000$1,500,000$1,000,000 $5,000,000 $500,000 ELLL$0 � $0 - oQ ��G� G°\�,�°�\ Q ��°� Q ��c°e Po�� G° Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $1,818,124 $1,603,822 $214,302 $11,931,111 $10,134,042 $1,797,069 ENGINEERING $1,364,963 $1,343,082 $21,881 $8,633,720 $7,617,030 $1,016,690 COLLECTION SYSTEM OPS. $1,222,796 $1,089,330 $133,466 $7,364,301 $6,752,392 $611,909 PLANT OPERATIONS $2,295,519 $2,179,616 $115,903 $14,147,830 $13,416,582 $731,248 PUMP STATIONS $241,210 $290,564 ($49,354) $1,447,260 $1,442,522 $4,738 RECYCLED WATER $132,215 $80,100 $52,116 $802,290 $586,474 $215,816 Totals $7,074,827 $6,586,514 $488,313 $44,326,512 $39,949,042 $4,377,470 Page 6of31 CENTRAL CONTRA COSTA SANITARY DISTRICT RUNNING EXPENSE FUND TEMPORARY INVESTMENTS DECEMBER,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) $23,100,000 $8,000,000 $15,100,000 $23,100,000 $23,271,047 51.22% $21,456.33 $129,444.38 $150,900.70 RE13 FHLB FED AGENCY 9/18/2019 3/20/2020 80 1.899% 3,962,178 4,000,000 4,000,000 3,972,491 8.87% 6,372.22 15,211.11 21,583.33 RE14 FHLB FED AGENCY 9/18/2019 3/18/2020 78 1.909% 3,962,387 4,000,000 4,000,000 3,986,840 8.87% 6,406.67 15,293.34 21,700.01 RE15 FHLB FED AGENCY 12/20/2019 3/6/2020 91 1.612% 13,952,688 14,000,000 14,000,000 13,961,220 31.04% 6,847.82 0.00 6,847.82 (3) $44,977,252 $16,000,000 $29,100,000 $45,100,000 $45,191,598 100.00% $41,083.04 $159,948.83 $201,031.86 (2) 33,358.26 33,358.26 $41,083.04 $193,307.09 $234,390.12 NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of December,2019 was 2.040%. (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 1.8015%. The weighted average maturity is.15 years. (4) The market value of the portfolio on December 31,2019 waE$45,191,598. (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 Director: February 20, 2020 Regular Board Meeting Agenda Packet- Page 27 of 161 Page 7of31 CENTRAL CONTRA COSTA SANITARY DISTRICT January14,2020 TO: THE BOARD OF D CTORS VIA: KEVIN MIZUNO Z FROM: CHRIS THOMAS SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through December 31,2019: YTD Total FY YTD YTD Fav/(Unfav) S/C Revenues: Budget Budgeted Actual Variance Explanation Facilities Capacity Fees higher than budgeted due to payments received from Avalon Bay new building-200 apartments and $ 65,598,130 $ 28,763,248 $ 31,601,922 $ 2,838,674 commercial development. SSC Higher than budgeted. Total $ 65,598,130 $ 28,763,248 $ 31,601,922 $ 2,838,674 Total FY YTD YTD YTD S/C Expenses: Budget* Budgeted Actual Remaining %Spent of Projected YTD Budget Total $ 74,669,521 $ 29.957,523 $ 27,320,984 $ 2,636,539 91.20% " Includes 18/19 carry-over($8,493,521) February 20, 2020 Regular Board Meeting Agenda Packet- Page 28 of 161 Page 8of31 �1Central Contra Costa Sanitary District Revenue Report MTD Fund:002-SEWER CONSTRUCTION(Capital) December 2019 Fiscal Period 6/2020 Report Generated on Jan 14,2020 10:33:17 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $0 $0 0.0% $0 $0 0.0% $11,630,000 $11,630,000 0.0% Other $7,592,997 $7,323,369 -3.6% $11,042,726 $13,182,507 19.4% $21,749,000 $8,566,493 60.6% Sewer Service Charges $17,020,522 $17,657,418 3.7% $17,720,522 $18,419,414 14.3% $32,219,130 $13,799,716 57.2% Total Revenue $24,613,519 $24,980,787 1.5% $28,763,248 $31,601,922 9.9% $65,598,130 $33,996,208 48.2% February 20, 2020 Regular Board Meeting Agenda Packet- Page 29 of 161 Page 9 of 31 Sewer Fund (Capital)Spending FY 19-20 $35,000,000 $29,957,523 $30,000,000 $23,961,059 $25,000,000 — $27,320,984 $22,921,092 $20,000,000 $16, $15,000,000 $11,789 $ $10,000,000 14,081,728 $4,934,581 $5,000,000 $9,740,422 — $4,282,657 $_ $1,627,894 July August September October November December —Projected* —Actual Columnl July August September October November December Projected* $ 2,066,477 $ 4,934,581 $ 11,789,041 $ 16,598,794 $ 23,961,059 $ 29,957,523 Actual 1,627,894 4,282,657 9,740,422 14,081,728 22,921,092 27,320,984 *Projected-Current year budget allocated by month based on historical spending in previous 2 years February 20, 2020 Regular Board Meeting Agenda Packet- Page 30 of 161 Page 10 of 31 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2019 PERIOD 6/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 TYPE CS Collection System $ 16,633,417 17,490,252 (856,835) 27,129,000 200,000 27,329,000 26,472,165 9,355,541 17,116,623 TYPE TP Treatment Plant 44,592,999 39,917,024 4,675,975 28,631,000 665,000 29,296,000 33,971,975 13,136,184 20,835,775 TYPE GI General Improvements 8,695,483 5,883,070 2,812,413 5,369,000 30,000 5,399,000 8,211,413 3,188,729 5,022,681 TYPE RW Recycled Water 5,239,894 3,377,926 1,861,968 4,152,000 - 4,152,000 6,013,968 1,640,530 4,373,457 CIB Contingency - - - 895,000 (895,000) - - - - TOTAL DISTRICT $ 75,161,793 $ 66,668,272 $ 8,493,521 $ 66,176,000 $ 74,669,521 $ 27,320,984 $ February 20, 2020 Regular Board Meeting Agenda Packet- Page 31 of 161 Page 11 of 31 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2019 PERIOD 6/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 TYPE CS Collection 5 st 5991 PH Sewer Renovation Phase 2 460,000 277,771 182,229 - - 182,229 5,000 177,229 6534 Harper Lane Area CAD 800,000 412,260 387,740 - - 387,740 208,038 179,702 *6602 South Jackson CAD 411,290 391,290 20,000 - - 20,000 15,191 4,809 *6603 North Jackson CAD 276,557 53,313 223,244 - - 223,244 184,309 38,935 6679 Coredell Drive CAD 123,443 54,906 68,537 - - 68,537 19,500 49,037 *7367 Concord Main Metering Station 250,000 245,826 4,174 - - 4,174 (83,286) 87,460 8419 Collection System Planning LT 985,000 984,958 42 200,000 200,000 200,042 79,319 120,723 8436 Moraga/Crossroads PS Project 3,747,000 3,218,526 528,474 4,600,000 4,600,000 5,128,474 845,750 4,282,724 8441 CIPP Contract 17-20 400,000 275,923 124,077 200,000 200,000 324,077 4,746 319,331 8442 PS Equipment Piping Replacement PH2 61,000 - 61,000 103,000 103,000 164,000 - 164,000 8443 LG Diameter Pipe line Inspection 250,000 18,484 231,516 515,000 515,000 746,516 435 746,081 8444 Force Main Inspection Program 125,000 - 125,000 - - 125,000 - 125,000 *8446 Lafayette Sewer Renovation Phase 12 4,033,600 3,715,186 318,414 - - 318,414 290,879 27,535 8447 Pump Station Security Improvement 156,000 - 156,000 51,000 51,000 207,000 - 207,000 8448 Manhole Modifications 712,000 860,375 (148,375) 309,000 309,000 160,625 80,140 80,485 8449 Collection System Modeling Support 200,000 130,135 69,865 103,000 103,000 172,865 7,862 165,003 8450 Development Sewerage Support 1,130,000 1,309,893 (179,893) 900,000 900,000 720,107 474,951 245,156 8451 C.S.Sewer Renovation 62,527 - 62,527 4,473,000 (2,000,000) 2,473,000 2,535,527 - 2,535,527 8452 Lafayette Sewer Ren.Ph.13 500,000 1,561,461 (1,061,461) 3,817,000 3,817,000 2,755,539 2,306,549 448,990 8454 So.Orinda Sewer Ren.Ph.7 500,000 860,185 (360,185) 3,637,000 3,637,000 3,276,815 2,609,366 667,449 8455 W.C.Sewer Renov.Ph.13 500,000 2,604,854 (2,104,854) 3,621,000 3,621,000 1,516,146 1,134,967 381,179 8456 Danville Sewer Ren.Ph.3 500,000 381,637 118,363 4,100,000 4,100,000 4,218,363 133,331 4,085,032 8457 Pump Station Upgrades-Ph.2 50,000 - 50,000 500,000 500,000 550,000 85,116 464,884 *8458 Martinez Sewer Renov.Ph.6 100,000 11,405 88,595 - 500,000 500,000 588,595 205,469 383,126 *8459 Lafayette Sewer Renov.Ph.14 100,000 24,336 75,664 - 500,000 500,000 575,664 147,032 428,632 *8460 WC Sewer Renov.Ph.14 100,000 53,907 46,093 - 500,000 500,000 546,093 312,187 233,906 *8461 So.Orinda Sewer Ren.Ph.8 100,000 43,621 56,379 - 500,000 500,000 556,379 288,690 267,689 **8462 S.R.Pump Station Flow Diversion - - - - 200,000 200,000 200,000 - 200,000 Rounding (1) otalFY 2019-20 CS Amoun $ 16,633,417 17,490,252 (856,835) 7,129,000 27,329,000 3 *Italic Projects open but not in CIB for 19/20 Not in 19/20 Budget. New projects opened in Aug.2019. Funds transferred from Contingency 9990 February 20, 2020 Regular Board Meeting Agenda Packet- Page 32 of 161 Page 12 of 31 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2019 PERIOD 6/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 *6172 Sludge Blending Tank Repair 776,000 - 776,000 - - 776,000 568,154 207,846 7292 Switchgear Refurbishment-Ph.2 684,548 473,274 211,274 200,000 200,000 411,274 21,556 389,718 7304 Instr&Controls PLC Upgrade 500,000 470,528 29,472 - - 29,472 2,228 27,244 7315 Applied Research and Innovations 557,274 290,336 266,938 300,000 300,000 566,938 - 566,938 7317 Plant Control System Network Upgrades 765,000 281,461 483,539 120,000 120,000 603,539 537,987 65,552 *7320 Plant Energy Optimization 1,094,000 1,004,604 89,396 - - 89,396 289 89,107 7322 Fire Protection System Ph.2 1,406,000 1,340,832 65,168 - - 65,168 28,142 37,026 *7326 Equipment Replacement FY 15-FY 14 1,629,000 1,628,975 25 - - 25 208,090 (208,065) 7327 Headwork's Screening Upgrade 8,305,000 8,304,264 736 - - 736 44,761 (44,025) 7328 Influent Pump Electrical improvements 610,000 431,527 178,473 800,000 800,000 978,473 322,651 655,822 7330 Piping Renovation Phase 9 3,180,000 3,127,343 52,657 - - 52,657 25,279 27,378 7339 T.Plant Control System I/O Replacement 1,370,000 1,286,269 83,731 1,100,000 1,100,000 1,183,731 153,001 1,030,730 7341 WC/Grayson Creek Levee Rehab 100,000 76,528 23,472 200,000 200,000 223,472 59,556 163,916 7348 Solids Handling Facility Improvements 9,914,000 9,243,507 670,493 6,550,000 6,550,000 7,220,493 1,837,225 5,383,268 7349 Aeration&Energy Upgrade 1,500,000 749,790 750,210 3,500,000 3,500,000 4,250,210 885,898 3,364,312 7351 Mechanical&Concrete Renovation 5,044,000 5,534,806 (490,806) 6,400,000 6,400,000 5,909,194 4,728,629 1,180,565 7352 UV Disinfection Upgrades 500,000 294,751 205,249 600,000 600,000 805,249 169,634 635,615 7353 Outfall Improvements Ph.7 100,000 54,551 45,449 500,000 500,000 545,449 187,181 358,268 7354 TP Security Improvements 137,000 41,951 95,049 718,000 718,000 813,049 25,368 787,681 7355 Odor Control Upgrade Ph.1 - - - - - - - - 7357 Plant Wide Instrumentation Upgrade 290,000 77,858 212,142 450,000 450,000 662,142 1,006 661,136 *7358 Innovation Bioenergy Demo 300,000 270,796 29,204 - - 29,204 - 29,204 7359 Solids Conditioning Bldg.roof replacement 1,300,000 1,195,265 104,735 - - 104,735 440 104,295 7360 Existing Plant Facility Drawing 200,000 158,215 41,785 100,000 100,000 141,785 19,852 121,933 7362 POB Seismic Upgrades 3,331,177 2,850,440 480,737 2,793,000 465,000 3,258,000 3,738,737 2,971,652 767,085 7363 Treatment Plant Planning 900,000 719,153 180,847 500,000 500,000 680,847 184,083 496,764 7364 TP Safety Enhancement Ph.5 100,000 10,000 90,000 600,000 600,000 690,000 12,532 677,468 7369 Piping Renovation-Phase 30 - - - 750,000 750,000 750,000 - 750,000 7370 Annual Infrastructure Replacement - - - 2,200,000 2,200,000 2,200,000 137,842 2,062,158 7371 Condition Assessment of Buried Pipelines - - - 250,000 250,000 250,000 - 250,000 **7373 Fire Protection System Ph.3 - - - - 200,000 200,000 200,000 3,148 196,852 Rounding (16) Total FY 2019-20 TP Amoun MEL 441,592,999 39,917,024 4,675,975 33,971,975 13,136,1841 75 *Italic Projects open but not in CIS for 19/20 Not in 19/20 Budget. New projects opened in Sept.2019. Funds transferred from Contingency 9990 February 20, 2020 Regular Board Meeting Agenda Packet- Page 33 of 161 Page 13 of 31 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2019 PERIOD 6/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 TYPE GI General Im roveme 8207 General Security and Access $ 134,977 134,975 2 150,000 150,000 150,002 11,869 138,133 8230 Capital Legal Services 178,665 142,411 36,254 20,000 20,000 56,254 11,917 44,337 8236 District Easements 258,047 224,799 33,248 75,000 75,000 108,248 12,727 95,521 8240 IT Development 2,738,794 2,456,461 282,333 500,000 500,000 782,333 154,739 627,594 8243 Server Room Relocation 2,000,000 1,351,513 648,487 - - 648,487 909,226 (260,739) 8249 CSO Dump Pad Modifications 60,000 12,409 47,591 - - 47,591 46,941 650 8250 ERP Replacement 600,000 - 600,000 3,105,000 3,105,000 3,705,000 874,289 2,830,711 8251 Capital improvement program&Budget Improvement - - - 350,000 350,000 350,000 97,048 252,952 **8252 POB E.V.Charging Station - - - - 30,000 30,000 30,000 20,544 9,456 8516 District Equipment Acquisition 876,000 798,811 77,189 100,000 100,000 177,189 33,915 143,274 8517 Vehicle Replacement Program 1,849,000 821,691 1,027,309 1,069,000 1,069,000 2,096,309 1,015,064 1,081,245 9999 Capital Project Clearing(Accounting Use Only)** - (60,000)1 60,000 1 - - 1 60,000 450 1 59,550 Rounding (3) al FY 2019-20 GI Amount $ 8,695,483 5,883,070 2,812,413 5,369,000 30,000 5,399,000 8,211,413 3,188,729 5,022,68 Not in 19/20 Budget. New projects opened in July 2019. Funds transferred from Contingency 9990 February 20, 2020 Regular Board Meeting Agenda Packet- Page 34 of 161 Page 14 of 31 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2019 PERIOD 6/2020 F(D+E) PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 18-19) PYS(THRU FYE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 TYPE RW Recycled W 7306 Zone 1 Recycled Water 532,894 508,654 24,240 100,000 - 100,000 124,240 25,883 98,357 7346 ReW Distribution Sys Surge Analysis 205,000 152,921 52,079 - - - 52,079 6,605 45,474 7361 Filter Plant Improvments 2,537,000 1,343,105 1,193,895 3,452,000 - 3,452,000 4,645,895 1,178,838 3,467,057 7365 Recycle Water Clearwell Repairs 1,700,000 1,364,144 335,856 - - - 335,856 396,286 (60,430) 7366 ReW Distribution System Renov.Program 15,000 - 15,000 500,000 - 500,000 515,000 - 515,000 7368 Water Exchange Project 250,000 9,102 240,898 100,000 - 100,000 340,898 32,918 307,980 Rounding 19 tal FY 2019-20 RW Amount 5,239,894 3,377,926 1,861,968 4,152,000 4,152,000 6,013,968 1,640,530 4,373,457 9990 CONTINGENCY-ALL PROGRAMS - - - 895,000 (895,000) - - - GRAND TOTAL $ 75,161,793 66,668,272 8,493,521 66,176,000 - 66,176,000 74,669,521 27,320,984 47,348,536 February 20, 2020 Regular Board Meeting Agenda Packet- Page 35 of 161 Page 15 of 31 A I B C D E F G N O 1 FY 19-20 CAPITAL BUDGET TRANSFERS 2 PERIOD ENDING: 12/31/19 position paper Position Paper GM Memo GM Memo GM Memo 06/20/19&GM 08/22/19 09/24/19 09/27/19 11/21/19 memo Item 11 19/20 Contingency 3 PROD.# PROJECTS TOTAL Balance 4 5 **8252 POB E.V. Charging Station 30,000 30,000 6 **8462 SR Pump station Flow Diversion 200,000 200,000 7 **7373 Fire Protection System Ph. 3 200,000 200,000 8 *8451 C.S.Sewer Renovation (2,000,000) (2,000,000) 9 *8458 Martinez Sewer Ren. Ph. 6 500,000 500,000 10 *8459 Lafayette Sewer Ren. Ph. 14 500,000 500,000 11 *8460 W.C.Sewer Renov. Ph. 14 500,000 500,000 12 *8461 So. Orinda Sewer Ren. Ph.8 500,000 500,000 38 7362 POB Seismic Upgrades 465,000 465,000 39 40 41 42 9990 Capital Projects-Contingency (30,000) (200,000) (200,000) - (465,000) (895,000) - 43 46 47 - 65 ** New project-not in 19/20 Budget 66 * Not actual transfers. All part of one project split into individual projects for construction February 20, 2020 Regular Board Meeting Agenda Packet- Page 36 of 161 Page 16 of 31 O&M PROJECTS-EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 12/31/19 6/2020 OM043- Naval Weapons Station Prior years Project expended Expenditure type through 18-19 1 Jul.'19 Aug.'19 Sept.'19 Oct.'19 Nov.'19 Dec.'19 Jan.'20 Feb.'20 Mar.'20 Apr.'20 May'20 Jun.'20 2019-20 YTD to date Salary&Benefits $ 17,429 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 17,429 Technical Services $ 75,169 1,938 - 6,255 3,259 - - - - - - - - 11,452 $ 86,620 Total $ 92,598 $ 1,938 $ - $ 6,255 $ 3,259 $ - $ - $ - $ - $ - $ - $ - $ - $ 11,452 $ 104,049 OM080 -CoCo Farm(Kiewit Future Farm Proposal) Prior years Project expended Expenditure type I through 18-19 Jul.'19 Aug.'19 Sept.'19 Oct.119 Nov.'19 Dec.'19 Jan.'20 Feb.'20 Mar.'20 Apr.'20 May'20 Jun.'20 2019-20 YTD to date Salary&Benefits $ 210,665 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 210,665 Other Charges $ 74,996 - - - - - - - - - - - - - $ 74,996 Total $ 285,661 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 285,661 OM083- Refinery Recycled Water Exchange Prior years Project expended Expenditure type through 18-19 Jul.'19 Aug.'19 Sept.'19 Oct.'19 Nov.'19 Dec.'19 Jan.'20 Feb.'20 Mar.'20 Apr.'20 May'20 Jun.'20 2019-20 YTD to date Salary&Benefits $ 84,070 $ 8,921 $ 7,080 $ 5,452 $ 2,319 $ 2,865 $ 2,592 $ - $ - $ - $ - $ - $ - $ 29,229 $ 113,299 other Charges $ - - - - - - - - - - - $ - Total $ 84,070 $ 8,921 $ 7,080 $ 5,452 $ 2,319 $ 2,865 $ 2,592 $ - $ - $ - $ - $ - $ - $ 29,229 $ 113,299 February 20, 2020 Regular Board Meeting Agenda Packet- Page 37 of 161 Page 17 of 31 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS DECEMBER,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) $35,000,000 $25,000,000 $10,000,000 $35,000,000 $35,259,162 58.33% $50,524.93 $215,077.17 $265,602.10 947 FHLB FHLB Note 6/13/19 12/11/19 0 2.20 4,946,077 5,000,000 (5,000,000) 0 0.00% 2,979.17 46,138.75 49,117.92 949 FHLB Fed Agency 9/18/19 03/20/20 80 1.90 4,952,722 5,000,000 5,000,000 4,965,613 8.33% 7,965.28 19,013.89 26,979.17 950 FHLB Fed Agency 9/18/19 03/18/20 78 1.91 4,952,983 5,000,000 5,000,000 4,983,550 8.33% 8,008.33 19,116.66 27,124.99 951 FHLB Fed Agency 12/23/19 3/20/20 79 1.62 14,941,883 0 15,000,000 15,000,000 14,980,775 25.00% 5,943.75 0.00 5,943.75 (4) $64,793,666 $40.000.000 $5.000.000 $60.000.000 $60,189.100 100.00% $75,421.46 $299,346.47 $374,767.93 (3) (5) 177,774.04 177,774.04 $75,421.46 $477,1120.5L__$ NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of December,2019 was 2.040%. (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.0289%. The weighted average maturity is.11 years. (4) The market value of the portfolio on December 31,2019 was$60,189,100. 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 February 20, 2020 Regular Board Meeting Agenda Packet- Page 38 of 161 Page 18 of 31 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE December 2019 Fiscal Period 6/2020 Report Generated on Jan 10, 2020 8:50:59 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $16,741 $11,865 -29.1% $925,446 $923,862 -0.2% $1,025,900 $102,038 90.1° Total Revenue -29.1% $925,446 $923,862 $102,038 Page 19 of 31 ACV Ls entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE December 2019 Fiscal Period 06/2020 Report Generated on Jan 13, 2020 8:19:24 AM $80,000 ❑Period Budget $800,000" ❑YTD Budget ❑Period Actual ❑ YTD Actual $60,000 $600,000- $40,000-' 600,000$40,000 ' $400,000 $20,000 $200,000- $0- $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $76,972 $66,386 $10,586 $611,832 $526,675 $85,157 Totals $76,972 $66,386 $10,586 $611,832 $526,675 $85,157 Page 20 of 31 CENTRAL CONTRA COSTA SANITARY DISTRICT SELF-INSURANCE FUND TEMPORARY INVESTMENTS DECEMBER,2019 INVESTMENTS (cents omitted) INTEREST INCOME DATE OF Days to ANNUAL CASH B.O.M. PURCHASE E.O.M. E.O.M %of CURRENT B.O.M. E.O.M. NO. ISSUER TYPE PURCHASE MATURITY Maturity YIELD OUTLAY FACE VALUE (MATURITY) FACE VALUE MKT VALUE Portfolio MONTH CUMULATIVE CUMULATIVE 519 State of Calif. LAW 10/99- ------- 1 (1) $6,900,000 $6,900,000 $6,900,000 $6,951,092 100.00% $11,954.96 $65,215.16 $77,170.12 (3) $6,900,000 $6,900,000 $0 $6,900,000 $6,951,092 100.00% $11,954.96 $65,215.16 $77,170.12 (2) (4) $2,351.27 $2,351.27 $11,954.96 $67,566.43 $79,521.39 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of December,2019 was 2.040%. (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.040°/x. (4) The market value of the portfolio on December 31,2019 was$6,951,092. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. February 20, 2020 Regular Board Meeting Agenda Packet- Page 41 of 161 Page 21 of 31 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004-DEBT SERVICE December 2019 Fiscal Period 6/2020 Report Generated on Jan 10, 2020 8:50:59 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $2,500,000 $2,982,415 19.3% $2,500,000 $2,982,415 19.3% $2,982,415 $0 100.0% Total Revenue $2,500,000 $2,982,415 19.3% $2,500,000 $2,982,415 100.0% Page 22 of 31 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE December 2019 Fiscal Period 06/2020 Report Generated on Jan 13, 2020 8:19:24 AM $80,000 ❑Period Budget $500,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $400,000- $60,000-/ $300,000 $40,000 $200,000 $20,000 $100,000 $0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $69,784 $0 $69,784 $418,704 $435,857 ($17,153) Totals $69,784 $0 $69,784 $418,704 $435,857 ($17,153) Page 23 of 31 DASHBOARD DATA (SELECTED DATA ON MATTERS OF CONTINUING BOARD INTEREST) February 20, 2020 Regular Board Meeting Agenda Packet- Page 44 of 161 Page 24 of 3 ENSIGN AND OPEB LIABILITY AND FUNDING STATUS Pension � . Million $160 100% Million $90 100% $140 90% $80 90% 80% $70 80% $120 70% $60 70% $100 60/o 0 $50 60% 50% $80 50% $40 40 $60 40% $30 30% 30% $20 20% $40 20% $10 0 10% 20 I $ 10% $0 0% $00% 0 0 0 0 0 0 0 N N N N N N N 1 ,LOQ ,LOQ ,LOQ ,LOQ ,LOQ ,LOQ ,LOQ ,LOQ O O N N llllllllllllllllllllllllliUAAL Funded% llllllllllllllllllllllllliUAAL Funded% Notes: * Pension:2018 figure is based on CCCERA valuation presented 10/9/2019 to CCCERA Board. ** OPEB-Valuations projected liabilities less assets as of June 30 of that year *** Pension funded percentage excludes Section 115 Trust Assets(established in FY 2017-18). ****June 2019 OPEB figure is market value of OPEB assets/Jan 2019 actuarial accrued liability February 20, 2020 Regular Board Meeting Agenda Packet- Page 45 of 161 Page 25 of 31 COMPONENTS OF THE PENSION URAL $74 MILLION AS OF 2018 CCCERA VALUATION ($74 MILLION IS UNCHANGED FROM 2017) Assumption Change U J � Q � Q v � L O S U M ILL Additional UAAL Prepayment to CCCERA Subsequent Actuarial Losses J Q Q W Restart of Amortization s c .N Discount Rate from 7.75%to 7.25% L U C N L O Depooling Implementation U fp LL Actuarial Losses from 2008-2012 $(30,000,000) $(20,000,000) $(10,000,000) $- $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 Notes: • Pension Pre-Funding Trust assets of$8.4 million (with another$1.25 million pending) are available Fg6r r },k4l. @qMJ [PRMWWF 1394.enda Packet- Page 46 of 161 Page 319 he 26 FTSNSION UAAL PROJECTION Anticipated UAAL with Scheduled Amortization (Blue) and with Additional UAAL Payments to Pension Prefunding Trust to Date and at $1.25 million prospectively (Green) millions $80 $60 $40 $20 $0 � � 1 a ($20) ($40) 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 ■Unfunded Liability(2018 Valuation) $74 $66 $59 $50 $40 $34 $27 $19 $10 $0 ■ Net UAAL(2018 Valuation) with Pension prefunding Trust offset 69 58 49 38 26 18 11 2 (8) (19) Notes: • Based on 2018 CCCERA Valuation. • Chart shows scheduled amortization of UAAL(over 18 years for each annual layer of historic UAAL),assuming no additional UAAL is generated. • Second bar shows UAAL offset by Pension Prefunding Trust balance,with continuing$1.25 million discretionary contributions through 2023 (at which point F68"�6°2'l1k"fr WAMI ��tr �� Qae 4�tb�ea '15 slntially 2025). Page 32 #Abe 27 of 31 PROJECTED UAAL WITH PENSION PREFUNDING TRUST: PROGRESS IS ABOUT $6.4 MILLION BEHIND SCHEDULE DUE TO NEW 2018 LAYER ADDED TO UAAL Ro $ in Millions 60 - 20 (20) (40) 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 ■ Net UAAL(2018 Valuation) with Pension prefunding Trust offset 69 58 49 38 26 18 11 2 (8) (19) ■ Net UAAL(2017 Valuation) $62 $52 $43 $33 $20 $13 $5 ($4) ($14) ($25) with Pension prefunding Trust offset Notes: • An additional$6.4 million was added to the UAAL due to actuarial loss($5.3 million)and assumption changes($1.1 million)in the CCCERA valuation for 2018 presented to the CCCERA Board on 10/9/2019. • The CCCERA UAAL remained essentially constant at$74 million as of the 2017 and 2018 valuations. The above chart shows the current outlook for reducing UAAL based on the 2018 valuation versus the outlook as of the 2017 valuation. The CCCERA UUAL has also been reduced by the actual& projected Pension Prefunding Trust balance. February 20, 2020 Regular Board Meeting Agenda Packet- Page 48 of 161 Page (ND TRANSFERS-CURRENT YEAR Cause for Transfers Total Original Project Budgets Compared to Transfers #of transfers $7,000,000 $6,000,000 $5,000,000 1 0 $4,000,000 ----------- $3,000,000 ------------- ■ ago ■ o ■ o v ■ o -� f 6 ■ v /„/. -o Q o N °' v Co a . 2 _ ------------- z 0 $2,000,000 3 v $ p 3 U .Y O N N LL .� J o Uj U °' $1,000,000 F.Cost exceeded initial budget E.New project scope D. New Project C.Developer/CAD or other cost neutral B.Cashflow accelerations $- A.Bundling/Unbundling Notes: There were no transfers in December 2019. Accordingly this data is unchanged from the November 2019 report. February 20, 2020 Regular Board Meeting Agenda Packet- Page 49 of 161 Pacc@PB oTFMNSFERS SINCE FY 2016=1 7 #of Cause for Transfers Total Original Project Budgets Compared to transfers Transfers $60,000,000 $50,000,000 $40,000,000 4 $30,000,000 2 0 $20,000,000 $10,000,000 ■ � ■ o ■ o ■ v ■ Q ■ v F.Cost exceeded initial budget - a ° v a E.New project scope o 2 °; ou - D.New Project m' v v 3 v v = C.Developer/CAD or other cost neutral o z ° B.Cashflow accelerations 3 > ° d 3 .° A.Bundling/Unbundling o N a, o t z �a s v o ui U co February 20, 2020 Regular Board Meeting Agenda Packet- Page 50 of 161 Page 30 of 31 FY 2019-20 Running Expense Fund Total Cash & Investment Balances (Actuals through December 2019) $60.0 $59.3 $53.7 $51.2 $49.8 $50.0 $47.2 $48.6 $43.4 $40.9 $40.0 $37.3 $38.2 $38.4 $33.8 $32.9 $30.0 $29.0 $28.2 $24.6 $24.2 $24.0 $23.7 $20.0 $17.6 $18.9 $18.2 $10.0 - $0.0 �e�` > y�Q o M Projected Balance* MActual Balance Reserve Target at Year End** NOTES: * Projected balances were generated in June 2019 based on budgeted revenues and expenses for FY 2019-20 and applied to the actual balance at Jun 30, 2019 **The Reserve Target at Year End is the minimum balance required at June 30, 2020 to comply with the District Policy February 20, 2020 Regular Board Meeting Agenda Packet- Page 51 of 161 Page 31 of 31 FY 2019-20 Sewer Construction Fund Total Cash & Investment Balances (Actuals through December 2019) $70.0 $67.5 abL.S $61.6 $60.0 $49.8 $56.3 $52.4 $50.7 $48.1 $56.1 $52.3 $51.9 $52.6 $54.0 $52.1 $550.0 $47.0$47.6 $43.2 $42.6 $40.0 $39.2 $30.0 $32.0 $30.4 $20.0 $10.0 $0.0 C:p �� M Projected Balance* MActual Balance Reserve Target at Year End** NOTES: * Projected balances were generated in June 2019 based on budgeted revenues and expenses for FY 2019-20 and applied to the actual balance at Jun 30, 2019 **The Reserve Target at Year End is the minimum balance required at June 30, 2020 to comply with the District Policy February 20, 2020 Regular Board Meeting Agenda Packet- Page 52 of 161