HomeMy WebLinkAbout04.b. Review December 2019 Financial Statements and Investment ReportsItem 4.b.
J anuary 28, 2020
T O: F I NA NC E C O MMI T T E E
F RO M :C HR I S T HO MA S, F I NA NC E A D MI NI S T R ATO R
K E V I N MI Z UNO, F I NA NC E MA NA G E R
RE V IE WE D B Y:P HI L I P L E I B E R , D I R E C TO R O F F I NA NC E A ND A D MI NI S T R AT I O N
A NN S A S A K I , D E P UT Y G E NE R A L MA NA G E R
R O G E R S. B A I L E Y, G E NE R A L MA NA G E R
S UB J E C T: R E V I E W D E C E MB E R 2019 F I NA NC I A L S TAT E ME NT S A ND I NV E S T ME NT
R E P O RT S
Change to Prospective Frequency of Reporting
I n the prior C ommittee meeting, Committee Members expressed interest in receiving the F inancial
Statements and I nvestment Reports packet on a quarterly rather than monthly basis going f orward. S taff 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 C entral San's peer agencies (E ast B ay
Municipal Utility D istrict, Orange C ounty S anitation District, Union Sanitary District, Napa San, etc.).
Accordingly, the next full F inancial S tatements and I nvestment R eports packet will be produced for the
third quarter ending March 31, 2020. Commencing with the upcoming 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. However, as
C entral San's current I nvestment P olicy mandates monthly investment reporting, staff will continue to
produce the investment reports on a monthly basis. Upon the next scheduled review of the investment
policy, staf f will look into whether an amendment is warranted to change the f requency 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 Results
Attached f or review are the F inancial S tatements and I nvestment R eports for D ecember 2019. W ith the
first half of F iscal Year (F Y) 2019-20 now complete, budgetary results for the Operations and Maintenance
(O&M), S ewer Construction, Self -I nsurance, and Debt Service funds continue to reflect that activities-to-
date are on target and under budget in the aggregate.
T he O&M F und expenditure results are f avorable at approximately 45.6% of the total F Y 2019-20 budget,
or 5.0% under the year-to-date budget target of 50.6%. O&M F und revenues are also slightly above the
year-to-date target by 2.3%, primarily attributable to f avorable results f or sewer service charges. W ith the
close of December 2019, Central S an has received its f irst installment of sewer service charges from the
C ontra C osta C ounty Auditor-Controller's Of f ice. As reflected by the modest positive revenue variance
noted previously, this installment was largely on target with budgetary projections. T he slightly f avorable
results f or sewer service charges results mainly f rom higher flows f rom non-residential customers as well
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 81 of 124
Page 1 of 33
as development activity being slightly higher than projected in the F Y 2019-20 budget.
T he S ewer Construction F und has spent $27.3 million or 36.6% of total capital project appropriations for
F Y 2019-20, falling just short (3.5%) of the 40.1% capital project expenditure rate target through the first
half of the fiscal year. T he pace of several capital projects is projected to accelerate in the second half of
the f iscal year f ollowing the District's expected and historical "s-curve" trend f or capital projects. Most
notably, significant progress on the following large capital projects is expected in the second half of the
fiscal year: S olids Handling F acility I mprovements (District P roject (D P) 7348), Mechanical and Concrete
R enovations (D P 7351), Moraga/Crossroads Pump Station (D P 8436), and E nterprise R esource
Planning R eplacement (D P 8250) capital projects. On the revenue side, the S ewer Construction F und is
reporting a positive year-to-date variance of 9.8%. T his relatively large positive year-to-date revenue
variance is predominantly attributable to f acilities capacity fees generated from the large 200 apartment
Avalon Bay development project in P leasant Hill and other smaller developments coming in higher than
projected in the F Y 2019-20 budget.
Strategic Plan Tie-I n
G O A L TH R EE: Be a Fiscally Sound and Effective Water Sector Utility
Strategy 2 - Manage costs
AT TAC HM E NT S :
D escription
1. December 2019 F inancial Statements and I nvestment Reports
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 82 of 124
Page 2 of 33
CENTRAL CONTRA QOSTA SANITARY DISTRICT
January 15, 2020 ·
TO :
VIA:
FROM:
SUBJECT : O&M Variance Analisis
The following are brief year-to-date variance explanations through December 31, 2019
O & M Revenues:
Total FY
Budget
YTD
Budgeted
YTD
Actual
YTD
Fav/(Unfav)
Variance Explanation
Direct SSC higher than budgeted due to increased development and metered
Total $ ·89 ,560 ,370 .$ 40 .899 ,449 $ 41,849 ,877 $ 950 ,42 8 consumption. SSC County Higherthan budgeted. ·
0 & M Expenses:
Total Labor Charges
Unfunded Liabilities
Chemicals
Utilities
Repairs & Maintenance
Hauling & Disposal
Professional & Legal Services
Outside Services
Materials & Supplies
Other Expenses
All Other
Grand Total O&M Expenses
$ 52,789,084 $ 26,056,026 $ 24,394,762 $ 1,661,26.f
12,436,841 6,218,298 5,929,126 289,172
1,620 ,000 809 ,982 717 ,549 92,433
4,209,350 2, 104,638 2,012,501 92,137
5,242,867 2,701,298 2 ,168,470 532 ,828
1,186,175 583,052 310,549 272,503
874,300 437,100 156,418 280,682
3,639,547 1,861,269 1,019,714 841,555
2,152,127 1,075,969 1,013,563 62,406
2,464,834 1,581,562 1,327 ,786 253 ,776
969,650 897,318 898,604 (1,286)
s 87,584.775 s 44 ,326.512 s 39 ,949 .042 s 4 ,3n.470
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.
Variance due to vacancy projections spread evenly throughout the year, however actual
staffing terminations and additions occurs sporadically during the year.
No significant variances .
No significant variances.
Mainly due to Outside Repairs being lower than budgeted thus far in the fiscal year.
Budget is spread evenly througho.ut the year, however actual activity occurs sporadically
every month . Varianee should be minimal by year end .
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 .
Lower mostly due to lower Legal expenses thus far in the fiscal year.
Mainly due to technical services expenses being lower than budgeted thus far in the fiscal
. year.
No significant variances.
Mainly due to Public Information, BACWA expenses, & Outside Organization fees being
l0wer than budgeted thus far in the fiscal year . Budget is spread evenly throughout the
year, however actual activity occurs sporadically every month .
Minor variances for multiple account categories.
Page 1 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 83 of 124
Page 3 of 33
Category MTD Estimate MTD Actual MTD %Rev YTD Estimate YTD Actual YTD %Rev Annual EstimateUnrealized Balance Annual %RevConcord$0$00.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,8974.2%Other$379,329$333,208-12.2%$2,316,974 $2,351,1681.5%$4,931,500$2,580,33247.7%Sewer Service Charges$37,288,645 $37,869,0531.6%$38,534,475 $39,503,2732.5%$69,090,870$29,587,59757.2%Total Revenue$37,675,974 $38,204,3941.4%$40,899,449 $41,849,8772.3%$89,560,370$47,710,49346.7%Report Generated on Jan 14, 2020 10:33:17 AM Revenue Report MTDFund: 001 - RUNNING EXPENSE (O&M)December 2019 Fiscal Period 6/2020 Page 2 of 31January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 84 of 124 Page 4 of 33
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
$6,553,088
$13,029,620
$19,309,309
$26,493,756
$33,362,529
$39,949,042
$7,943,704
$15,010,366
$22,076,711
$29,611,473
$37,251,685
$44,326,512
$0.00
$5,000,000.00
$10,000,000.00
$15,000,000.00
$20,000,000.00
$25,000,000.00
$30,000,000.00
$35,000,000.00
$40,000,000.00
$45,000,000.00
Jul(1) 2019 Aug(2) 2019 Sep(3) 2019 Oct(4) 2019 Nov(5) 2019 Dec(6) 2019
Fiscal Periods
Budget
Actual
Page 3 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 85 of 124
Page 5 of 33
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
Page 4 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 86 of 124
Page 6 of 33
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
RECY
C
L
E
D
W...
PUMP
S
T
A
TI...
PLAN
T
O
P
E
R...
COLL
E
C
TI
O
N...
ENGI
N
E
E
RI
N...
ADMI
NI
S
T
R
A...
$2,500,000
$2,000,000
$1,500,000
$1,000,000
$500,000
$0
Period Budget
Period Actual
RECY
C
L
E
D
W...
PUMP
S
T
A
TI...
PLAN
T
O
P
E
R...
COLL
E
C
TI
O
N...
ENGI
N
E
E
RI
N...
ADMI
NI
S
T
R
A...
$15,000,000
$10,000,000
$5,000,000
$0
YTD Budget
YTD Actual
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 5 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 87 of 124
Page 7 of 33
CENTRAL CONTRA COSTA SANITARY DISTRICTRUNNING EXPENSE FUNDTEMPORARY INVESTMENTSDECEMBER, 2019 INVESTMENTS (cents omitted) INTEREST INCOME DATE OFDays 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 CUMULATIVE519 State of Calif. LAIF 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.70RE13 FHLB FED AGENCY 9/18/2019 3/20/2020 80 1.899% 3,962,178 4,000,0004,000,000 3,972,491 8.87% 6,372.22 15,211.11 21,583.33RE14 FHLB FED AGENCY 9/18/2019 3/18/2020 78 1.909% 3,962,387 4,000,0004,000,000 3,986,840 8.87% 6,406.67 15,293.34 21,700.01RE15 FHLB FED AGENCY 12/20/2019 3/6/2020 91 1.612% 13,952,68814,000,000 14,000,000 13,961,220 31.04% 6,847.820.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.12NOTE:(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 was$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 DirectorsPage 6 of 31January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 88 of 124 Page 8 of 33
CENTRAL CONTRA COSTA SANITARY DISTRICT
January 14, 2020
TO:
VIA:
FROM:
THE BOARD OF ~~RS
KEVIN MIZUNO ~
CHRIS THOMAS or--
SUBJECT: Sewer Construction Variance Analysis
The following are brief year-to-date variance explanations through December 31, 2019:
SIC Revenues:
Total FY
Budget
YTD
Budgeted
YTD
Actual
YTD
Fav/(Unfav)
Variance
Total
$ 65,598,130 $ 28,763,248 $ 31,601,922 $ 2,838,674
$ 65 ,598,130 $ 28,763,248 $ 31,601,922 $ 2,838,674
SIC Expenses:
Total
Total FY
Budget*
YTD
Budgeted
YTD
Actual
YTD
Remaining
$ 74,669,521 $ 29 ,957,523 $ 27,320,984 $ 2,636,539
• Includes 18/19 carry-over ($8,493,521)
Explanation
Facilities Capacity Fees higher than budgeted due to payments
received from Avalon Bay new building -200 apartments and
commercial development. SSC Higher than budgeted.
% Spent of Projected YTD Budget
91.20%
Page 7 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 89 of 124
Page 9 of 33
Category MTD Estimate MTD Actual MTD %RevYTD EstimateYTD ActualYTD %RevAnnual EstimateUnrealized Balance Annual %RevConcord$0$00.0%$0$00.0%$11,630,000$11,630,0000.0%Other$7,592,997 $7,323,369-3.6%$11,042,726$13,182,50719.4%$21,749,000$8,566,49360.6%Sewer Service Charges$17,020,522 $17,657,4183.7%$17,720,522$18,419,41414.3%$32,219,130$13,799,71657.2%Total Revenue$24,613,519 $24,980,7871.5%$28,763,248$31,601,9229.9%$65,598,130$33,996,20848.2%Report Generated on Jan 14, 2020 10:33:17 AM Revenue Report MTDFund: 002 - SEWER CONSTRUCTION (Capital)December 2019 Fiscal Period 6/2020 Page 8 of 31January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 90 of 124 Page 10 of 33
Column1 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
$4,934,581
$11,789,041
$16,598,794
$23,961,059
$29,957,523
$1,627,894 $4,282,657
$9,740,422
$14,081,728
$22,921,092
$27,320,984
$-
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
$30,000,000
$35,000,000
July August September October November December
Sewer Fund (Capital) Spending FY 19-20
Projected*Actual
Page 9 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 91 of 124
Page 11 of 33
PROGRAM /GM185L4 - Modified in Excel ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD 6/2020
A B C(A-B)D E F (D+E)G (C+D+E)H I (F-G)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN REMAINING BUDGET
NO PROJECT TITLE PYS (THRU FYE 18-19)PYS (THRU FYE 18-19)CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20
TYPE CS Collection System 16,633,417$ 17,490,252 (856,835) 27,129,000 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$ -$ 66,176,000$ 74,669,521$ 27,320,984$ 47,348,536$
CAPITAL IMPROVEMENT BUDGET REPORT
PERIOD ENDING: 12/31/2019
Page 10 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 92 of 124
Page 12 of 33
PROGRAM /GM185L4 - Modified in Excel ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD 6/2020
A B C(A-B)D E F (D+E)G (C+D+E)H I (F-G)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN REMAINING BUDGET
NO PROJECT TITLE PYS (THRU FYE 18-19)PYS (THRU FYE 18-19)CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20
CAPITAL IMPROVEMENT BUDGET REPORT
PERIOD ENDING: 12/31/2019
TYPE CS Collection System
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)
Total FY 2019-20 CS Amount 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
* 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
Page 11 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 93 of 124
Page 13 of 33
PROGRAM /GM185L4 - Modified in Excel ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD 6/2020
A B C(A-B)D E F (D+E)G (C+D+E)H I (F-G)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN REMAINING BUDGET
NO PROJECT TITLE PYS (THRU FYE 18-19)PYS (THRU FYE 18-19)CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20
CAPITAL IMPROVEMENT BUDGET REPORT
PERIOD ENDING: 12/31/2019
TYPE TP Treatment Plant
*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 24 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 10 - - - 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 Amount 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
* Italic Projects open but not in CIB for 19/20
**Not in 19/20 Budget. New projects opened in Sept. 2019. Funds transferred from Contingency 9990
Page 12 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 94 of 124
Page 14 of 33
PROGRAM /GM185L4 - Modified in Excel ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD 6/2020
A B C(A-B)D E F (D+E)G (C+D+E)H I (F-G)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN REMAINING BUDGET
NO PROJECT TITLE PYS (THRU FYE 18-19)PYS (THRU FYE 18-19)CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20
CAPITAL IMPROVEMENT BUDGET REPORT
PERIOD ENDING: 12/31/2019
TYPE GI General Improvements
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) 60,000 - - 60,000 450 59,550
-
Rounding (3)
Total 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,681
**Not in 19/20 Budget. New projects opened in July 2019. Funds transferred from Contingency 9990
Page 13 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 95 of 124
Page 15 of 33
PROGRAM /GM185L4 - Modified in Excel ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD 6/2020
A B C(A-B)D E F (D+E)G (C+D+E)H I (F-G)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN REMAINING BUDGET
NO PROJECT TITLE PYS (THRU FYE 18-19)PYS (THRU FYE 18-19)CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20
CAPITAL IMPROVEMENT BUDGET REPORT
PERIOD ENDING: 12/31/2019
TYPE RW Recycled Water
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
Total 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
Page 14 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 96 of 124
Page 16 of 33
1
2
3
4
5
6
7
8
9
10
11
12
38
39
40
41
42
43
46
47
65
66
A B C D E F G N O
FY 19-20 CAPITAL BUDGET TRANSFERS
PERIOD ENDING: 12/31/19
PROJ. #PROJECTS
position paper
06/20/19 & GM
memo
GM Memo
08/22/19
GM Memo
09/24/19
GM Memo
09/27/19
Position Paper
11/21/19
Item 11
TOTAL
19/20 Contingency
Balance
**8252 POB E.V. Charging Station 30,000 30,000
**8462 SR Pump station Flow Diversion 200,000 200,000
**7373 Fire Protection System Ph. 3 200,000 200,000
*8451 C.S. Sewer Renovation (2,000,000) (2,000,000)
*8458 Martinez Sewer Ren. Ph. 6 500,000 500,000
*8459 Lafayette Sewer Ren. Ph. 14 500,000 500,000
*8460 W.C. Sewer Renov. Ph. 14 500,000 500,000
*8461 So. Orinda Sewer Ren. Ph. 8 500,000 500,000
7362 POB Seismic Upgrades 465,000 465,000
9990 Capital Projects - Contingency (30,000) (200,000) (200,000) - (465,000) (895,000) -
Total - - - - - - -
**New project - not in 19/20 Budget
*Not actual transfers. All part of one project split into individual projects for construction
Page 15 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 97 of 124
Page 17 of 33
O&M PROJECTS - EXPENDITURE LIST ACCOUNTING
PERIOD ENDING:12/31/19 6/2020
OM043 - Naval Weapons Station
Expenditure type
Prior years
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
Project expended
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)
Expenditure type
Prior years
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
Project expended
to date
Salary & Benefits 210,665$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 210,665$
Other Charges 74,996$ - - - - - - - - - - - - - 74,996$
Total 285,661$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 285,661$
OM083 - Refinery Recycled Water Exchange
Expenditure type
Prior years
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
Project expended
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$
Page 16 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 98 of 124
Page 18 of 33
CENTRAL CONTRA COSTA SANITARY DISTRICTSEWER CONSTRUCTION FUNDTEMPORARY INVESTMENTSDECEMBER, 2019 INVESTMENTS (cents omitted) INTEREST INCOME DATE OF Days toANNUAL CASH B.O.M.PURCHASEE.O.M. E.O.M.% ofCURRENT B.O.M. E.O.M.NO. ISSUER TYPE PURCHASE MATURITY MaturityYIELD OUTLAY FACE VALUE(MATURITY)FACE VALUE MKT VALUEPortfolioMONTH CUMULATIVE CUMULATIVE519 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.10947 FHLB FHLB Note 6/13/19 12/11/19 0 2.20 4,946,077 5,000,000 (5,000,000)00.00% 2,979.17 46,138.75 49,117.92949 FHLBFed Agency 9/18/19 03/20/20 80 1.90 4,952,722 5,000,0005,000,000 4,965,613 8.33% 7,965.28 19,013.89 26,979.17950 FHLBFed Agency 9/18/19 03/18/20 78 1.91 4,952,983 5,000,0005,000,000 4,983,550 8.33% 8,008.33 19,116.66 27,124.99951 FHLBFed Agency 12/23/19 3/20/2079 1.62 14,941,8830 15,000,000 15,000,000 14,980,775 25.00% 5,943.750.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,120.51 $552,541.97 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 DirectorsPage 17 of 31January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 99 of 124 Page 19 of 33
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 $16,741 $11,865 -29.1%$925,446 $923,862 -0.2%$1,025,900 $102,038 90.1%
Page 18 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 100 of 124
Page 20 of 33
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
$60,000
$40,000
$20,000
$0
Period Budget
Period Actual
$800,000
$600,000
$400,000
$200,000
$0
YTD Budget
YTD Actual
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 19 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 101 of 124
Page 21 of 33
CENTRAL CONTRA COSTA SANITARY DISTRICTSELF-INSURANCE FUNDTEMPORARY INVESTMENTSDECEMBER, 2019 INVESTMENTS (cents omitted) INTEREST INCOME DATE OFDays toANNUALCASH B.O.M. PURCHASEE.O.M. E.O.M % ofCURRENTB.O.M. E.O.M.NO. ISSUERTYPE PURCHASEMATURITYMaturityYIELD OUTLAYFACE VALUE(MATURITY) FACE VALUEMKT VALUE Portfolio MONTH CUMULATIVE CUMULATIVE519 State of Calif. LAIF 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.39NOTE: (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%. (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.Page 20 of 31January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 102 of 124 Page 22 of 33
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 19.3%$2,982,415 $0 100.0%
Page 21 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 103 of 124
Page 23 of 33
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
$60,000
$40,000
$20,000
$0
Period Budget
Period Actual
$500,000
$400,000
$300,000
$200,000
$100,000
$0
YTD Budget
YTD Actual
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 22 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 104 of 124
Page 24 of 33
DASHBOARD DATA
(SELECTED DATA ON MATTERS
OF CONTINUING BOARD INTEREST)
Page 23 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 105 of 124
Page 25 of 33
PENSION AND OPEB
LIABILITY AND FUNDING STATUS
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
$0
$20
$40
$60
$80
$100
$120
$140
$160
Pension
UAAL Funded%
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
20122013201420152016201720182019 (Jan)2019 (Jun)OPEB
UAAL Funded%
Notes:
* Pension: 2018 figure is based on CCCERA valuation presented 10/9/2019 to CCCERA Board.
** OPEB-Valuations projected liabilities less assets as of June 30 of that year
*** Pension funded percentage excludes Section 115 Trust Assets (established in FY 2017-18).
**** June 2019 OPEB figure is market value of OPEB assets / Jan 2019 actuarial accrued liability
Million Million
Page 24 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 106 of 124
Page 26 of 33
Notes:
•Pension Pre-Funding Trust assets of $8.4 million (with another $1.25 million pending) are available
to further reduce UAAL indicated above.Factors increasing the UAALFactors reducing the UAAL $(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
Actuarial Losses from 2008-2012
Depooling Implementation
Discount Rate from 7.75% to 7.25%
Restart of Amortization
Subsequent Actuarial Losses
Additional UAAL Prepayment to CCCERA
Actuarial Gains (2014 forward)
Assumption Change
COMPONENTS OF THE PENSION UAAL
$74 MILLION AS OF 2018 CCCERA VALUATION
($74 MILLION IS UNCHANGED FROM 2017)
Page 25 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 107 of 124
Page 27 of 33
PENSION UAAL PROJECTION
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 t hrough 2023 (at which point
additional contributions are ceased as the UAAL is forecast to be retired by essentially 2025).
millions
Page 31 of 36
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)
($40)
($20)
$0
$20
$40
$60
$80
Anticipated UAAL with Scheduled Amortization (Blue)
and with Additional UAAL Payments to Pension Prefunding Trust to Date and at $1.25 million
prospectively (Green)
Page 26 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 108 of 124
Page 28 of 33
PROJECTED UAAL WITH PENSION PREFUNDING TRUST:
PROGRESS IS ABOUT $6.4 MILLION BEHIND SCHEDULE
DUE TO NEW 2018 LAYER ADDED TO UAAL
Notes:
•An additional $6.4 million was added to the UAAL due to actuarial loss ($5.3 million) and assumption changes ($1.1 million) i n 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 c urrent outlook for
reducing UAAL based on the 2018 valuation versus the outlook as of the 2017 valuation. The CCCERA UUAL has also been red uced by the actual &
projected Pension Prefunding Trust balance.
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)
with Pension prefunding Trust offset $62 $52 $43 $33 $20 $13 $5 ($4)($14)($25)
(40)
(20)
-
20
40
60
80
$in Millions
Page 32 of 36Page 27 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 109 of 124
Page 29 of 33
CIB TRANSFERS-CURRENT YEAR
# of transfers
Notes:
There were no transfers in December 2019. Accordingly this data is unchanged from the November 2019 report.
0
1
2
3
4
5
Cause for Transfers
A. Bundling/UnbundlingB. Cashflow accelerationsC. Developer/CAD orother cost neutralD. New Project E. New project scopeF. Cost exceededinitial budget A. Bundling/Unbundling
B. Cashflow accelerations
C. Developer/CAD or other cost neutral
D. New Project
E. New project scope
F. Cost exceeded initial budget
$-
$1,000,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
$6,000,000
$7,000,000
Total Original Project Budgets Compared to Transfers
Page 28 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 110 of 124
Page 30 of 33
CIB TRANSFERS SINCE FY 2016-17
# of
transfers
0
2
4
6
8
10
12
14
16
Cause for Transfers
A. Bundling/UnbundlingB. Cashflow accelerationsC. Developer/CAD orother cost neutralD. New Project E. New project scopeF. Cost exceededinitial budget A. Bundling/Unbundling
B. Cashflow accelerations
C. Developer/CAD or other cost neutral
D. New Project
E. New project scope
F. Cost exceeded initial budget
$-
$10,000,000
$20,000,000
$30,000,000
$40,000,000
$50,000,000
$60,000,000
Total Original Project Budgets Compared to
Transfers
Page 29 of 31
January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 111 of 124
Page 31 of 33
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 $40.9 $24.6 $33.8 $29.0 $24.0 $18.9 $48.6 $43.4 $38.2 $32.9 $59.3 $53.7 $49.8 $47.2 $24.2 $17.6 $28.2 $23.7 $18.2 $51.2 $37.3 $38.4 $0.0$10.0$20.0$30.0$40.0$50.0$60.0FY 2019‐20 Running Expense Fund Total Cash & Investment Balances(Actuals through December 2019)Projected Balance*Actual BalanceReserve Target at Year End**Page 30 of 31January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 112 of 124 Page 32 of 33
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 $49.8 $52.3 $52.6 $47.6 $43.2 $39.2 $61.6 $58.3 $54.0 $48.1 $62.5 $56.1 $52.1 $56.3 $51.9 $47.0 $52.4 $50.7 $42.6 $67.5 $30.4 $32.0 $0.0$10.0$20.0$30.0$40.0$50.0$60.0$70.0FY 2019‐20 Sewer Construction Fund Total Cash & Investment Balances(Actuals through December 2019)Projected Balance*Actual BalanceReserve Target at Year End**Page 31 of 31January 28, 2020 Regular FINANCE Committee Meeting Agenda Packet - Page 113 of 124 Page 33 of 33