HomeMy WebLinkAbout03.b. Review August 2019 Financial Statements and Investment Reports Page 1 of 36
Item 3.b.
,0f,rTCj ON SAN
FA
September 24, 2019
TO: FINANCE COMMITTEE
FROM: CHRIS THOMAS, FINANCE ADMINISTRATOR
KEVIN MIZUNO, FINANCE MANAGER
REVIEWED BY: PHILIP LEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION
ANN SASAKI, DEPUTY GENERAL MANAGER
ROGER S. BAILEY, GENERAL MANAGER
SUBJECT: REVIEW AUGUST 2019 FINANCIAL STATEMENTS AND INVESTMENT
REPORTS
Attached for review are the Financial Statements and Investment Reports for the month of August 2019.
The attached monthly budget-to-actual reports exclude Operations and Maintenance (O&M)fund detail by
division as this information is generated and monitored internally.
Although early in the fiscal year, the August 2019 budgetary results for the O&M, Sewer Construction,
Self-I nsurance, and Debt Service funds suggest current year activities-to-date are generally on target.
While early in the year, O&M Fund savings of$1.98 million, including salary/benefit cost savings of $0.5
million, are favorable and point towards the likelihood of savings for the year as a whole. Staff will continue
to monitor the budget closely throughout the fiscal year and bring any matters requiring budgetary direction
and action to the Board at a later date as necessary.
The slides in the Dashboard Data section of the report have been updated based on feedback received at
the August 28, 2019 Finance Committee meeting.
Strategic Plan re-In
GOAL THREE: Be a Fiscally Sound and Effective Water Sector Utility
Strategy 2- Manage costs
ATTACHMENTS:
1. August 2019 Financial Statements and Investment Reports
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 46 of 128
Page 1 of 35
CENTRAL CONTRA COSTA.SANITARY DISTRICT
September 11, 2019
TO: THE BOARD OF DIR S
VIA: KEVIN MIZUNO
FROM: CHRIS THOMAS
SUBJECT: O&M Variance Analysis
The following are brief year-to-date variance explanations through period ending August 31,2019
YTD
Total FY YTD YTD Fav/(Unfav)
O&M Revenues: Budget Budgeted Actual Variance Explanation
Budget is spread evenly throughout the year for SSC-Direct, however actual activity
Total $ 89,560,370 $ 1,027,790 $ 790,004 $ (237,786) occurs sporadically every month.
O&M Expenses:
Total Labor Charges $ 52;789,084 $ 8,685,342 $ 8,179,320 $ 506,022 Some positions budgeted for in July are filled later in the fiscal year resulting in savings.
Chemicals 1,620,000 269,994 184,876 85,118 Chemical consumption lower than budgeted.
Utilities 4,209,350 701,546 496,833 204,713 Lower due to delay in invoices.
Repairs&Maintenance 5,242,867 873,766 620,106 253,660 Budget is spread evenly throughout the year, however actual activity occurs sporadically
every month. Variance should be minimal by year end.
Professional&Legal Services 874,300 145,700 14,564 131,136 Lower due to delay in invoices.
Outside Services 3,639,547 638,184 343,378 294,806 Lower due to delay in invoices.
Materials&Supplies 2,152,127 358,598 300,124 58,474 No significant variances.
Other Expenses 2,464,834 217,680 88,882 128,798 Budget is spread evenly throughout the year, however actual activity occurs sporadically
every month. Variance should be minimal by year end.
Unfunded Liabilities 12,436,841 2,072,766 1,856,092 216,674 Variance due to vacancy projections spread evenly throughout the year,however actual
staffing terminations and additions occurs sporadically during the year
All Other 2,155,825 1,046,790 945,445 101,345 Minor variances for multiple account categories.
Total $ 87,584,775 $ 15,010,366 $ 13,029,620 $ 1,980,746
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 47 of 128
Page 2 of 35
Zy11 Central Contra Costa Sanitary District
Protecting public health and the environment
Revenue Report MTD
Fund: 001 - RUNNING EXPENSE(O&M)
August 2019 Fiscal Period 2/2020
Report Generated on Sep 11, 2019 10:39:28 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 $3,769 -52.9% $16,000 $9,704 -39.3% $968,000 $958,296 1.0%
Other $378,729 $254,427 -32.8% $793,458 $670,055 -15.6% $4,931,500 $4,261,445 13.6%
Sewer Service Charges $109,166 $32,546 -70.2% $218,332 $155,911 -28.6% $69,090,870 $68,934,959 0.2%
Total Revenue $495,895 $290,742 -41.4% $1,027,790 $790,004 -23.1% $89,560,370 $88,770,366 0.9%
Page 3 of 35
Atyts entral Contra Costa Sanitary District
Protecting public health and the environment
Expense Report - District Summary MTD
Fund: 001 -RUNNING EXPENSE(O&M)
August 2019 Fiscal Period 02/2020
Report Generated on Sep 11, 2019 10:41:57 AM
$16,000,000.00 —Budget
Actual
$14,000,000.00 $15,010,366
$12,000,000.00 $13,029,620
$10,000,000.00-
$8,000,000.00
$7,943,704
$6,000,000.00 $6,553,088
$4,000,000.00
$2,000,000.00
$0.00
Jul(1)2019 Aug(2)2019
Fiscal Periods
Page 4 of 35
A001' Central Contra Costa Sanitary District
Protecting public health and the environment
Expense Report - District Summary MTD
Fund: 001 - RUNNING EXPENSE(O&M)
August 2019 Fiscal Period 02/2020
Report Generated on Sep 11, 2019 10:41:57 AM
Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual %
Budget
SALARIES&WAGES $3,152,929 $2,974,955 $177,974 5.6% $6,305,858 $5,977,370 $328,488 5.2% $38,060,443 15.7%
EMPLOYEE BENEFITS $1,560,433 $1,398,713 $161,720 10.4% $3,120,866 $3,029,703 $91,163 2.9% $19,177,010 15.8%
CAPITALIZED ADM OVERHEAD ($370,691) ($445,173) $74,482 -20.1% ($741,382) ($827,745) $86,363 = ($4,448,369) 18.6%
DIRECTOR FEES&EXPENSES $12,053 $13,993 ($1,940) -16.1% $24,106 $24,528 ($422) -1.7% $144,650 17.0%
CHEMICALS $134,997 $162,666 ($27,669) -20.5% $269,994 $184,875 $85,119 31.5% $1,620,000 11.4%
UTILITIES $350,773 $455,269 ($104,496) -29.8% $701,546 $496,834 $204,712 29.2% $4,209,350 11.8%
REPAIRS&MAINTENANCE $436,883 $486,391 ($49,508) -11.3% $873,766 $620,104 $253,662 29.0% $5,242,867 11.8%
HAULING&DISPOSAL $98,842 $86,381 $12,461 12.6% $197,684 $95,915 $101,769 51.5% $1,186,175 8.1%
PROFESSIONAL&LEGAL SERV $72,850 $13,512 $59,338 81.5% $145,700 $14,564 $131,136 90.0% $874,300 1.7%
OUTSIDE SERVICES $269,092 $121,890 $147,202 54.7% $638,184 $343,378 $294,806 46.2% $3,639,547 9.4%
SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $825,000 $825,000 $0 0.0% $825,000 100.0%
MATERIALS&SUPPLIES $179,299 $223,972 ($44,673) -24.9% $358,598 $300,122 $58,476 16.3% $2,152,127 13.9%
OTHER EXPENSES $132,819 $61,095 $71,724 54.0% $217,680 $88,880 $128,800 59.2% $2,464,834 3.6%
UNFUNDED LIABILITIES $1,036,383 $922,868 $113,515 11.0% $2,072,766 $1,856,092 $216,674 10.5% $12,436,841 14.9%
Total Expenses $7,066,662 $6,476,532 $590,130 8.4% $15,010,366 $13,029,620 $1,980,746 13.2% $87,584,775 14.9%
Color Key: 0 to 10%over budget > 10%over budget M
Page 5 of 35
ZVO' Central Contra Costa Sanitary District
Protecting public health and the environment
Expense Report - By Department MTD
Fund: 001 - RUNNING EXPENSE (O&M)
August 2019 Fiscal Period 02/2020
Report Generated on Sep 11, 2019 10:43:14 AM
$2,500,000 ❑Period Budget $5,000,000 ' ❑YTD Budget
❑Period Actual ❑ YTD Actual
7M 7�
$2,000,000 $4,000,000
$1,500,000 $3,000,000-
$1,000,000- $2,000,000-
$500,000- $1,000,000
$o
$0
�G� G°���°�\ Q��c°e� S�P1�� `5����°�c`����G°���°��° �0 Q Jae S �
Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance
ADMINISTRATION $1,823,649 $1,495,695 $327,954 $4,514,340 $3,904,533 $609,808
ENGINEERING $1,354,963 $1,112,706 $242,257 $2,709,926 $2,293,185 $416,741
COLLECTION SYSTEM OPS. $1,222,796 $1,244,336 ($21,540) $2,470,592 $2,243,405 $227,187
PLANT OPERATIONS $2,291,829 $2,271,195 $20,634 $4,568,658 $3,949,334 $619,324
PUMP STATIONS $241,210 $244,581 ($3,371) $482,420 $412,628 $69,792
RECYCLED WATER $132,215 $108,019 $24,196 $264,430 $226,535 $37,895
Totals $7,066,662 $6,476,532 $590,130 $15,010,366 $13,029,620 $1,980,746
Page 6 of 35
CENTRAL CONTRA COSTA SANITARY DISTRICT
RUNNING EXPENSE FUND
TEMPORARY INVESTMENTS
AUGUST,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 10/99- ------- 1 (1) $12,000,000 $12,000,000 $12,000,000 $12,084,955 100.00% $23,859 $29,721 $53,580
(3) $12,000,000 $12,000,000 $0 $12,000,000 $12,084,955 100.00% 23,859 29,721 53,580
(2) (4)
29,629 29,629
$23,859 $59,350 $83,209
NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund.
The yield as of August,2019 was 2.341%.
(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.341%.
(4) The market value of the portfolio on August,2019 was$12,084,955.
(5) The District has sufficient funds available combined with secured SSC and Property Tax received in December and April to cover
six months of cash flow needs.
COMPLIANCE STATEMENT:
All investments comply with the District's internal investment policy approved by the Board of Directors.
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 52 of 128
Page 7 of 35
' Central Contra Costa sanitary District
Protecting public health and the environment
Balance Sheet
Fund:001-RUNNING EXPENSE(O&M)
August 2019 Fiscal Period 2/2020
Summarized by Account
Report Generated on Sep 11,2019 10:37:36 AM
TOTAL ASSETS
Current Assets
CASH ACCOUNTS/CASH $5,601,174
CASH ACCOUNTS/PAYROLL CLEARING $20,000
CASH ACCOUNTS/PETTY CASH $3,400
CASH ACCOUNTS/TEMPORARY INVESTMENTS $12,000,000
DEFERRED OUTFLOWS/DEFERRED OUTFLOWS-GASB 68 $21,503,021
DEFERRED OUTFLOWS/DEFERRED OUTFLOWS-GASB 75 $30,400
DUE FROM/DUE FROM S/C $1,876,634
DUE FROM/DUE FROM S/I $825,000
INVENTORY/SUPPLIES&MATERIAL INV $2,179,127
PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104
PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572
PREPAID ACCOUNTS/PREPAID EXPENSES $13,918
PREPAID ACCOUNTS/PREPAID INSURANCE $456,492
PREPAID ACCOUNTS/PREPAID RETIREMENT $15,313,192
RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $2,469
RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $16,389,858
RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA ($4,027)
RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $53,580
RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $14,943
RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $101,362
RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $2,120
Current Assets $76,429,339
Net Property,Plant and Equipment
CONTRIBUTED FIXED ASSETS/ACC DEPR-CONTRIB ASSETS ($63,652,332)
CONTRIBUTED FIXED ASSETS/CONTRIBUTED SEWER LINES $162,344,781
FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $45,917,681
FIXED ASSETS/ACC DEPR-BUILDINGS ($15,427,731)
FIXED ASSETS/ACC DEPR-ENTERPR SOFTWARE ($168,283)
FIXED ASSETS/ACC DEPR-FURN&EQUIP ($10,415,521)
FIXED ASSETS/ACC DEPR-OUTFALL ($3,919,770)
FIXED ASSETS/ACC DEPR-PUMPING STATIONS ($37,309,198)
FIXED ASSETS/ACC DEPR-SEWAGE COL SYS ($78,758,161)
FIXED ASSETS/ACC DEPR-TREATMENT PLANT ($235,704,155)
FIXED ASSETS/ACC DEPR-VEHICLES ($5,296,931)
FIXED ASSETS/ACCUM DEPRC-RECY WATER ($10,355,662)
FIXED ASSETS/BUILDINGS $44,379,479
FIXED ASSETS/ENTERPRISE SOFTWARE $3,365,658
FIXED ASSETS/FURNITURE&EQUIPMENT $14,579,938
FIXED ASSETS/INTANGIBLE ASSETS $4,949,507
FIXED ASSETS/LAND $17,320,570
FIXED ASSETS/OUTFALL SEWERS $11,371,574
FIXED ASSETS/PUMPING STATIONS $57,327,020
FIXED ASSETS/RECY WATER INFRASTRUCTURE $20,292,366
FIXED ASSETS/SEWAGE COLLECTION FACIL $394,084,852
FIXED ASSETS/TREATMENT PLANT $354,976,293
FIXED ASSETS/VEHICLES $7,490,960
Net Property,Plant and Equipment $677,392,935
TOTAL ASSETS $753,822,274
TOTAL LIABILITIES AND FUND EQUITY
Total Liabilities
ACCOUNTS PAYABLE/SALES TAX PAYABLE ($6,801)
CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,673,840)
Page 8 of 35
' Central Contra Costa sanitary District
Protecting public health and the environment
Balance Sheet
Fund:001-RUNNING EXPENSE(O&M)
August 2019 Fiscal Period 2/2020
Summarized by Account
Report Generated on Sep 11,2019 10:37:36 AM
CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($5,047,603)
CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,258,104)
CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($45,941)
CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($1,562)
CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931)
CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING ($5,558)
CURRENT LIABILITIES/PERMIT CLEARING ($1,329)
CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($42,080)
CURRENT LIABILITIES/RETIREMENT CONTRIB W/H $26,889
CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $737,571
DEF.COMP.CONTRIB W/H/ICMA 4571401A ($39,128)
DEF.COMP.CONTRIB W/H/ICMA TIER III HRA $39,128
DUE TO/DUE TO S/C ($65,474)
DUE TO/DUE TO S/I ($825,000)
LIABILITIES-LONG TERM/DEFERRED INFLOWS-GASB 68 ($28,076,634)
LIABILITIES-LONG TERM/NET OPEB LIAB-GASB 75 ($46,350,454)
LIABILITIES-LONG TERM/NET PENSION LIAB-GASB 68 ($63,806,000)
LIABILITIES-LONG TERM/POST EMP.BENEFIT-PENSION $8,420,816
LIABILITIES/UNEARNED INTEREST $0
MEDICAL LIABILITIES/CALPERS MEDICAL ($3,995)
MEDICAL LIABILITIES/DELTA DENTAL $133
MEDICAL LIABILITIES/DISABILITY INS $195
MEDICAL LIABILITIES/HEALTH NET $823,222
MEDICAL LIABILITIES/KAISER PERMANENTE ($337,108)
MEDICAL LIABILITIES/LIFE INS ($1,451)
MEDICAL LIABILITIES/OCCUPATIONAL HEALTH ($2,035)
MEDICAL LIABILITIES/VSP VISION CARE ($37)
REIMBURSEMENT FEES ($71,318)
Total Liabilities ($137,753,426)
Total Fund Equity
FUND EQUITY/AVAILABLE FUND BALANCE ($42,245,414)
FUND EQUITY/CAPITAL COST SHARING ($123,029,998)
FUND EQUITY/CONTRIBUTED SEWER LINES ($162,344,781)
FUND EQUITY/EXPENDITURE SUMMARY $13,029,620
FUND EQUITY/GENERAL FIXED ASSET GROUP ($225,386,993)
FUND EQUITY/STATE&FED CAPITAL GRANT ($75,301,279)
YEAR TO DATE REVENUES/REVENUE SUMMARY ($790,004)
Total Fund Equity ($616,068,848)
TOTAL LIABILITIES AND FUND EQUITY ($753,822,274)
Page 9 of 35
CENTRAL CONTRA COSTA SANITARY DISTRICT
September 11,2019
TO: THE BOARD OF DI RS
VIA: KEVIN MIZUNO cod
FROM: CHRIS THOMAS
SUBJECT: Sewer Construction Variance Analysis
The following are brief year-to-date variance explanations through period ending August 31,2019:
YTD
Total FY YTD YTD Favl(Unfav)
SIC Revenues: Budget Budgeted Actual Variance Explanation
Facilities Capacity Fees, Interest income received was
Total $ 65,598,130 $ 1,204,826 $ 1,264,427 $ 59,601 higher than budgeted.
Total FY YTD YTD YTD
S/C Expenses: Budget" Budgeted Actual Remaining %S ent
Total $ 74,669,521 $ 4,934,581 $ 4,282.657 $ 651,924 86.79%
Includes 18119 carry-over($8,493,521)
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 55 of 128
Page 10 of 35
A001' Central Contra Costa Sanitary District
Protecting public health and the environment
Revenue Report MTD
Fund: 002-SEWER CONSTRUCTION (Capital)
August 2019 Fiscal Period 2/2020
Report Generated on Sep 11, 2019 10:39:28 AM
Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev
Concord $0 $0 0.0% $0 $0 0.0% $11,630,000 $11,630,000 0.0°%
Other $602,413 $416,812 -30.8% $1,204,826 $1,191,729 -1.1% $21,749,000 $20,557,271 5.5%
Sewer Service Charges $0 $15,175 0.0% $0 $72,698 0.0% $32,219,130 $32,146,432 0.2°%
Total Revenue $602,413 $431,987 -28.3% $1,204,826 $1,264,427 4.9% $65,598,130 $64,333,703 1.9%
Page 11 of 35
Sewer Fund (Capital) Spending FY
$6,000,000 19-20
$4,934,581
$5,000,000
$4,000,000 — $4,282,657
$3,000,000
$2,000,000
$1,627,894
$1,000,000
July August
Projected* Actual
Columnl July August
Projected* $ 2,066,477 $ 4,934,581
Actual 1,627,894 4,282,657
*Projected -Current year budget allocated by month based on historical spending in previous 2 years
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 57 of 128
Page 12 of 35
PROGRAM/GM385L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:8/30/2019 PERIOD 2/2020
F(D+E) G(C+D+E)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROD BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET
NO PROJECT TITLE PYS(THRU HE 18-19) PYS(THRU HE 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 1,858,837 24,613,347
TYPE TP Treatment Plant 44,592,999 39,917,024 4,675,975 28,631,000 - 28,631,000 33,306,975 1,532,153 31,774,825
TYPE GI General Improvements 8,695,483 5,883,070 2,812,413 5,369,000 30,000 5,399,000 8,211,413 603,277 7,608,135
TYPE RW Recycled Water 5,239,894 3,377,926 1,861,968 4,152,000 - 4,152,000 6,013,968 288,390 5,725,580
CIB Contingency - - - 895,000 (230,000) 665,000 665,000 - 665,000
TOTAL DIM 75,161,793 66,668,272 $ 8,493,521 66,176,00 $ 66,176,0 74,669,521 4,282,657 70,386,887
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 58 of 128
Page 13 of 35
PROGRAM/GM385L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:8/30/2019 PERIOD 2/2020
F(D+E) G(C+D+E)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROD 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 S st
5991 PH Sewer Renovation Phase 2 460,000 277,771 182,229 - - 182,229 - 182,229
6534 Harper Lane Area CAD 800,000 412,260 387,740 387,740 387,740
*6602 South Jackson CAD 411,290 391,290 20,000 - - 20,000 15,191 4,809
*6603 North Jackson CAD 276,557 53,313 223,244 - - 223,244 - 223,244
6679 Coredell Drive CAD 123,443 54,906 68,537 - - 68,537 - 68,537
*7367 Concord Main Metering Station 250,000 245,826 4,174 - - 4,174 3,675 499
8419 Collection System Planning LT 985,000 984,958 42 200,000 200,000 200,042 24,965 175,077
8436 Moraga/Crossroads PS Project 3,747,000 3,218,526 528,474 4,600,000 4,600,000 5,128,474 91,205 5,037,269
8441 CIPP Contract 17-20 400,000 275,923 124,077 200,000 200,000 324,077 2,563 321,514
8442 PS Equipment Piping Replacement PH2 61,000 - 61,000 103,000 103,000 164,000 - 164,000
8443 LG Diameter Pipe line Inspection 250,000 18,484 231,516 515,000 515,000 746,516 - 746,516
8444 Force Main Inspection Program 125,000 - 125,000 - - 125,000 125,000
*8446 Lafayette Sewer Renovation Phase 12 4,033,600 3,715,186 318,414 - - 318,414 26,917 291,497
8447 Pump Station Security Improvement 156,000 - 156,000 51,000 51,000 207,000 - 207,000
8448 Manhole Modifications 712,000 860,375 (148,375) 309,000 309,000 160,625 - 160,625
8449 Collection System Modeling Support 200,000 130,135 69,865 103,000 103,000 172,865 4,716 168,149
8450 Development Sewerage Support 1,130,000 1,309,893 (179,893) 900,000 900,000 720,107 180,136 539,971
8451 C.S.Sewer Renovation 62,527 - 62,527 4,473,000 4,473,000 4,535,527 - 4,535,527
8452 Lafayette Sewer Ren.Ph.13 500,000 1,561,461 (1,061,461) 3,817,000 3,817,000 2,755,539 566,803 2,188,736
8454 So.Orinda Sewer Ren.Ph.7 500,000 860,185 (360,185) 3,637,000 3,637,000 3,276,815 313,754 2,963,061
8455 W.C.Sewer Renov.Ph.13 500,000 2,604,854 (2,104,854) 3,621,000 3,621,000 1,516,146 351,241 1,164,905
8456 Danville Sewer Ren.Ph.3 500,000 381,637 118,363 4,100,000 4,100,000 4,218,363 9,245 4,209,118
8457 Pump Station Upgrades-Ph.2 50,000 - 50,000 500,000 500,000 550,000 - 550,000
*8458 Martinez Sewer Renov.Ph.6 100,000 11,405 88,595 - - 88,595 58,305 30,290
*8459 Lafayette Sewer Renov.Ph.14 100,000 24,336 75,664 - - 75,664 72,676 2,988
*8460 WC Sewer Renov.Ph.14 100,000 53,907 46,093 46,093 55,827 (9,734)
*8461 So.Orinda Sewer Ren.Ph.8 100,000 43,621 56,379 - - 56,379 81,618 (25,239)
**8462 S.R.Pump Station Flow Diversion - - - - 200,000 200,000 200,000 - 200,000
Rounding i i 19
'total FY 2019-20 CS Amount 6,633, 17,490,252 (856,835) 27,129,000 200,000 27,329,000 26,472,165 1,858,837 24,613,347
*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
TYPV'W4reatment Pla
*6172 SludgeBlending Tank Repair 776,000 - 776,000 - - 776,000 246 775,754
7292 Switchgear Refurbishment-Ph.2 684,548 473,274 211,274 200,000 200,000 411,274 2,329 408,945
7304 Instr&Controls PLC Upgrade 500,000 470,528 29,472 - - 29,472 22 29,450
7315 Applied Research and Innovations 557,274 290,336 266,938 300,000 300,000 566,938 - 566,938
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 59 of 128
Page 14 of 35
PROGRAM/GM385L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:8/30/2019 PERIOD 2/2020
F(D+E) G(C+D+E)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROD BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET
NO PROJECT TITLE PYS(THRU HE 18-19) PYS(THRU HE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20
7317 Plant Control System Network Upgrades 765,000 281,461 483,539 120,000 120,000 603,539 195,432 408,107
*7320 Plant Energy Optimization 1,094,000 1,004,604 89,396 - - 89,396 22 89,374
7322 Fire Protection System Ph.2 1,406,000 1,340,832 65,168 - - 65,168 2,658 62,510
*7326 Equipment Replacement FY 15-FY 24 1,629,000 1,628,975 25 - - 25 67,796 (67,771)
7327 Headwork's Screening Upgrade 8,305,000 8,304,264 736 - - 736 14,934 (14,198)
7328 Influent Pump Electrical improvements 610,000 431,527 178,473 800,000 800,000 978,473 23,410 955,063
7330 Piping Renovation Phase 9 3,180,000 3,127,343 52,657 - - 52,657 5,715 46,942
7339 T.Plant Control System 1/0 Replacement 1,370,000 1,286,269 83,731 1,100,000 1,100,000 1,183,731 6,175 1,177,556
7341 WC/Grayson Creek Levee Rehab 100,000 76,528 23,472 200,000 200,000 223,472 44,165 179,307
7348 Solids Handling Facility Improvements 9,914,000 9,243,507 670,493 6,550,000 6,550,000 7,220,493 175,674 7,044,819
7349 Aeration&Energy Upgrade 1,500,000 749,790 750,210 3,500,000 3,500,000 4,250,210 93,623 4,156,587
7351 Mechanical&Concrete Renovation 5,044,000 5,534,806 (490,806) 6,400,000 6,400,000 5,909,194 315,603 5,593,591
7352 UV Disinfection Upgrades 500,000 294,751 205,249 600,000 600,000 805,249 17,219 788,030
7353 Outfall Improvements Ph.7 100,000 54,551 45,449 500,000 500,000 545,449 14,994 530,455
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 60 of 128
Page 15 of 35
PROGRAM/GM385L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:8/30/2019 PERIOD 2/2020
F(D+E) G(C+D+E)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROI BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET
NO PROJECT TITLE PYS(THRU HE 18-19) PYS(THRU HE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20
7354 TP Security Improvements 137,000 41,951 95,049 718,000 718,000 813,049 378 812,671
7355 Odor Control Upgrade Ph.1 - - - - - - - -
7357 Plant Wide Instrumentation Upgrade 290,000 77,858 212,142 450,000 450,000 662,142 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 11,785 130,000
7362 POB Seismic Upgrades 3,331,177 2,850,440 480,737 2,793,000 2,793,000 3,273,737 442,128 2,831,609
7363 Treatment Plant Planning 900,000 719,153 180,847 500,000 500,000 680,847 96,153 584,694
7364 TP Safety Enhancement Ph.5 100,000 10,000 90,000 600,000 600,000 690,000 246 689,754
7369 Piping Renovation-Phase 10 - - - 750,000 750,000 750,000 - 750,000
7370 Annual Infrastructure Replacement - - - 2,200,000 2,200,000 2,200,000 - 2,200,000
7371 Condition Assessment of Buried Pipelines - - - 250,000 250,000 250,000 - 250,000
Rounding 3
Total FY 2017-18 TP Amou $ 44,592,999 39,917,024 4,675,975 28,631,000 - 28,631,000 33,306,975 1,532,153 31,774,825
*Italic Projects open but not in CIB for 19/20
Heral IffMIU.C"'ClUb '11111
8207 General Security and Access $ 134,977 134,975 2 150,000 150,000 150,002 - 150,002
8230 Capital Legal Services 178,665 142,411 36,254 20,000 20,000 56,254 - 56,254
8236 District Easements 258,047 224,799 33,248 75,000 75,000 108,248 6,106 102,142
8240 IT Development 2,738,794 2,456,461 282,333 500,000 500,000 782,333 20,855 761,478
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 61 of 128
Page 16 of 35
PROGRAM/GM385L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING
CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING:8/30/2019 PERIOD 2/2020
F(D+E) G(C+D+E)
PROJECT TOTAL TOTAL FY 2019-20 BUDGET ADJUSTED APPROVED TOTAL TOTAL
PROD BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET
NO PROJECT TITLE PYS(THRU HE 18-19) PYS(THRU HE 18-19) CARRY-FORWARD BUDGET FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20 FY 2019-20
8243 Server Room Relocation 2,000,000 1,351,513 648,487 - - 648,487 26,558 621,929
8249 CSO Dump Pad Modifications 60,000 12,409 47,591 - - 47,591 1,291 46,300
8250 ERP Replacement 600,000 - 600,000 3,105,000 3,105,000 3,705,000 37,993 3,667,007
8251 Capital improvement program&Budget Improvement - - 350,000 350,000 350,000 27,977 322,023
**8252 POB E.V.Charging Station - - - - 30,000 30,000 30,000 - 30,000
8516 District Equipment Acquisition 876,000 798,811 77,189 100,000 100,000 177,189 - 177,189
8517 Vehicle Replacement Program 1,849,000 821,691 1,027,309 1,069,000 1,069,000 2,096,309 482,047 1,614,262
9999 Capital Project Clearing(Accounting Use Only)** - (60,000) 60,000 - - 60,000 450 59,550
Rounding (1)
tal FY 2017-18 GI Amou 8,695,483 5,883,070 2,812,413 8,211,413 603,277 7,608,135
Not in 19/20 Budget. New projects opened in July 2019. Funds transferred from Contingency 9990
TYPE RW Recycled Water
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 62 of 128
Page 17 of 35
A I B C D N O
1 FY 19-20 CAPITAL BUDGET TRANSFERS
2 PERIOD ENDING:8/31/19
position paper
GM Memo
06/20/19&GM
08/22/19
memo
19/20 Contingency
3 PROJ.# 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
8
9
10
11
12
38
39
40
41
42 9990 Capital Projects-Contingency (30,000) (200,000.00) (230,000) 665,000
43
46
47 Total - 665,000
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 63 of 128
Page 18 of 35
O&M PROJECTS-EXPENDITURE LIST ACCOUNTING
PERIOD ENDING: 08/31/19 2/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 - - - - - - - - - - - 1,938 $ 77,106
Total $ 92,598 $ 1,938 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 1,938 $ 94,535
OM080 -CoCo Farm(Kiewit Future Farm Proposal)
Prior years Project expended
Expenditure type I 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 $ 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 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 16,001 $ 100,071
other Charges $ - - - - - - - - - - - $ -
Total $ 84,070 $ 8,921 $ 7,080 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 16,001 $ 100,071
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 64 of 128
Page 19 of 35
CENTRAL CONTRA COSTA SANITARY DISTRICT
SEWER CONSTRUCTION FUND
TEMPORARY INVESTMENTS
AUGUST,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) $17,000,000 $25,000,000 ($12,000,000) $17,000,000 $17,120,352 40.48% $43,549 $54,880 $98,429
4,000,000
941 US Gov't T-Bill 2/28/19 8/29/19 0 2.49 4,000,000 (4,000,000) 0.00% $7,560 8,370 $15,930
942 US Gov't T-Bill 3/4/19 8/29/19 0 2.50 4,000,000 (4,000,000) 0.00% $7,591 8,404 $15,996
944 T-Bill US Tbill 3/21/19 9/19/19 18 2.50 4,938,575 5,000,000 5,000,000 4,986,550 11.90% $10,463 10,463 $20,925
945 FHLB Agency Gov 4/3/19 10/1/19 30 2.44 4,940,169 5,000,000 5,000,000 4,982,200 11.90% $10,247 10,247 $20,494
946 FHLMC Fed Agency 5/28/19 11/12/19 72 2.37 4,946,100 5,000,000 5,000,000 4,970,250 11.90% $9,946 9,946 $19,892
947 FHLB FHLB Note 6/13/19 12/11/19 101 2.20 4,946,077 5,000,000 5,000,000 4,962,400 11.90% $9,235 9,793 $19,028
948 FHLB Govt/FHLB 6/21/19 11/18/19 78 2.02 4,957,917 5,000,000 5,000,000 4,968,500 11.90% $8,697 8,921 $17,618
4,000,000
(4) $41,728,838 $58,000,000 ($20,000,000) $42,000,000 $41,990,252 100.00% $107,288 121,024 $228,312
(3) (5)
$0
$107,288 121,024 $228.312
NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund.
The yield as of August 2019 was 2.341%.
(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.366%.
(4) The market value of the portfolio on August 31,2019 was$41,990,252.
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.
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 65 of 128
Page 20 of 35
' Central Contra Costa sanitary District
Protecting public health and the environment
Balance Sheet
Fund:002-SEWER CONSTRUCTION(Capital)
August 2019 Fiscal Period 2/2020
Summarized by Account
Report Generated on Sep 11,2019 10:37:36 AM
TOTAL ASSETS
Current Assets
CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003
CASH ACCOUNTS/CASH $5,036,790
CASH ACCOUNTS/TEMPORARY INVESTMENTS $42,000,000
DUE FROM/DUE FROM DEBT FUND $2,560,570
DUE FROM/DUE FROM RIE $65,474
RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $8,048,684
RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $98,429
RECEIVABLE ACCOUNTS/CAD RECEIVABLE $394,662
Current Assets $59,024,612
Net Property,Plant and Equipment
FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS 54,282,682
Net Property,Plant and Equipment $4,282,682
TOTAL ASSETS $63,307,295
TOTAL LIABILITIES AND FUND EQUITY
Total Liabilities
ACCOUNTS PAYABLE/SALES TAX PAYABLE ($1,293)
CURRENT LIABILITIES/ACCOUNTS PAYABLE ($537,782)
CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($963,150)
CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($158,036)
DUE TO/DUE TO R/E ($1,876,634)
LIABILITIES/UNEARNED INTEREST ($91,065)
Total Liabilities ($3,627,959)
Total Fund Equity
EXPENDITURE SUMMARY/TRANSFER TO CIP ($4,282,682)
FUND EQUITY/AVAILABLE FUND BALANCE ($58,414,909)
FUND EQUITY/EXPENDITURE SUMMARY $4,282,682
YEAR TO DATE REVENUES/REVENUE SUMMARY ($1,264,427)
Total Fund Equity ($59,679,335)
TOTAL LIABILITIES AND FUND EQUITY ($63,307,295)
Page 21 of 35
ANLs entral Contra Costa Sanitary District
Protecting public health and the environment
Revenue Report MTD
Fund: 003-SELF-INSURANCE
August 2019 Fiscal Period 2/2020
Report Generated on Sep 11, 2019 10:39:28 AM
Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev
Other $772,991 $16,443 -97.9% $858,482 $871,974 1.6°% $1,025,900 $153,926 85.0%
Total Revenue $772,991 $16,443 -97.9% $858,482 $871,974 1.6% $1,025,900 $153,926 85.0%
Page 22 of 35
ACV ts entral Contra Costa Sanitary District
Protecting public health and the environment
Expense Report - By Department MTD
Fund: 003-SELF-INSURANCE
August 2019 Fiscal Period 02/2020
Report Generated on Sep 11, 2019 10:43:14 AM
$80,000 ❑Period Budget $400,000 ❑ YTD Budget
❑Period Actual ❑ YTD Actual
$60,000-/-- $300,000-
$40,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
$76,972 $19,482 $57,490 $303,944 $251,917 $52,027
Totals $76,972 $19,482 $57,490 $303,944 $251,917 $52,027
Page 23 of 35
CENTRAL CONTRA COSTA SANITARY DISTRICT
SELF-INSURANCE FUND
TEMPORARY INVESTMENTS
AUGUST,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,948,849 100.00% $13,719 $13,707 $27,426
(3) $6,900,000 $6,900,000 $0 $6,900,000 $6,948,849 100.00% 13,719 13,707 27,426
(2) (4)
$13,719 $13,707 $27,426
NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund.
The yield as of August,2019 was 2.341%.
(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.341%.
(4) The market value of the portfolio on August 31,2019 was$6,948,848,87.
COMPLIANCE STATEMENT:
All investments comply with the District's internal investment policy approved by the Board of Directors.
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 69 of 128
Page 24 of 35
' Central Contra Costa sanitary District
Protecting public health and the environment
Balance Sheet
Fund:003-SELF-INSURANCE
August 201 9
Fiscal Period 2/2020
Summarized by Account
Report Generated on Sep 11,2019 10:37:36 AM
TOTAL ASSETS
Current Assets
CASH ACCOUNTS/CASH $1,042,520
CASH ACCOUNTS/TEMPORARY INVESTMENTS $6,900,000
DUE FROM/DUE FROM R/E $825,000
RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $27,426
Current Assets $8,794,946
TOTAL ASSETS $8,794,946
TOTAL LIABILITIES AND FUND EQUITY
Total Liabilities
CURRENT LIABILITIES/ACCOUNTS PAYABLE ($13,070)
CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($1,157,797)
DUE TO/DUE TO R/E ($825,000)
Total Liabilities ($1,995,867)
Total Fund Equity
FUND EQUITY/AVAILABLE FUND BALANCE $202,052
FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000)
FUND EQUITY/EXPENDITURE SUMMARY $251,917
FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,381,074)
YEAR TO DATE REVENUES/REVENUE SUMMARY ($871,974)
Total Fund Equity ($6,799,079)
TOTAL LIABILITIES AND FUND EQUITY ($8,794,946)
Page 25 of 35
A001' Central Contra Costa Sanitary District
Protecting public health and the environment
Revenue Report MTD
Fund: 004-DEBT SERVICE
August 2019 Fiscal Period 2/2020
Report Generated on Sep 11, 2019 10:39:28 AM
Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev
Other $0 $0 0.0% $0 $0 0.0% $2,982,415 $2,982,415 0.0°%
Total Revenue $0 0.0% $2,982,415 $2,982,415 0.0%
Page 26 of 35
ACV Ls entral Contra Costa Sanitary District
Protecting public health and the environment
Expense Report - By Department MTD
Fund: 004- DEBT SERVICE
August 2019 Fiscal Period 02/2020
Report Generated on Sep 11, 2019 10:43:14 AM
$500,000 ❑Period Budget $500,000" ❑YTD Budget
❑Period Actual ❑ YTD Actual
$400,000 $400,000-
$300,000-,'
400,000$300,000 ' $300,000-
$200,000- $200,000-
$100,000-1
200,000$100,000 ' $100,000
$0-
0 $0
Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance
$69,784 $432,757 ($362,973) $139,568 $432,757 ($293,189)
Totals $69,784 $432,757 ($362,973) $139,568 $432,757 ($293,189)
Page 27 of 35
' Central Contra Costa sanitary District
Protecting public health and the environment
Balance Sheet
Fund:004-DEBT SERVICE
August 2019 Fiscal Period 2/2020
Summarized by Account
Report Generated on Sep 11,2019 10:37:36 AM
TOTAL ASSETS
Current Assets
L.T.DEBT ACCOUNTING/REVENUE BOND RESERVE CASH ($52)
Current Assets ($52)
TOTAL ASSETS ($52)
TOTAL LIABILITIES AND FUND EQUITY
Total Liabilities
DUE TO/DUE TO S/C ($2,560,570)
L.T.DEBT ACCOUNTING/BOND ACR INTEREST PAYABLE ($288,505)
L.T.DEBT ACCOUNTING/BONDS PAYABLE ($17,305,000)
Total Liabilities ($20,154,075)
Total Fund Equity
FUND EQUITY/AVAILABLE FUND BALANCE $22,078,000
FUND EQUITY/EXPENDITURE SUMMARY $432,757
LIABILITIES/DEFERRAL-BOND REFUNDING ($2,356,631)
Total Fund Equity $20,154,126
TOTAL LIABILITIES AND FUND EQUITY $52
Page 28 of 35
DASHBOARD DATA
(SELECTED DATA ON MATTERS
OF CONTINUING BOARD INTEREST)
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 74 of 128
Page 29 of 3
ENSION AND OPEB
LIABILITY AND FUNDING STATUS
Pension OPEB
Million $160 100% Million $90 100%
$140 —
90% $80 90%
80% $70 — 80%
$120 70%
70% $60
$100 60/o 0 $50 60%
50%
$80 50% $40
40
$60 40% $30 30%
30% $20 20%
$40 $10 10%
$20 20%10% $0 0%
c*4 m � u7 k.D r- oo
$0 0% 0 0 0 0 0 0 r_1 v
N N N N N N N
liiiiiiiiiiiiiiiiiiiUAAL Funded% UAAL Funded%
Notes:
* Pension:2018 valuation is to be released in October 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 2019 OPEB figure is market value of OPEB assets/Jan 2019 actuarial accrued liability
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 75 of 128
Page 30 of 29MPONENTS OF THE PENSION UAAL
$74 MILLION AS OF 2017
Assumption Change
U J
=5 Q
_0 a
o +,
U
Ui Additional UAAL Prepayment
Subsequent Actuarial Losses I
J
QRestart of Amortization
41
s
b,p Discount Rate from 7.75%to 7.25%
N
(B
v Depooling Implementation
L
O
U Actuarial Losses from 2008
ca
(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 are available to further reduce UAAL indicated above.
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 76 of 128
Page 31 f3PASIONUAAL PROJECTION
Anticipated UAAL with Schedule Amortization (Blue)
and with Additional UAAL Payments to Pension Prefunding Trust to Date and at $1.25 million
prospectively (Red)
$80
millions
$60
$40
$20
o 8
$ d
($20)
($40) 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027
■Unfunded Liability $74 $67 $61 $53 $45 $34 $28 $21 $13 $4 ($6)
B Net with Pension prefunding Trust 74 62 52 43 33 20 13 5 (4) (14) (25)
■%Change from 2017 with standard 18 year amortization by -9% -8% -10% -12% -14% -8% -9% -11% -12% -13%
layer
■%Change from 2017 with additional contributions to 0 0 0 0 0 0 0 0 0 0
Pension Prefunding Trust
17/0 13/0 12/0 14/0 16/0 11/0 10% 12/0 -14/0 15/0
Notes:
• 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
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 77 of 128
Page (U [F TRANSFERS-CURRENT YEAR
#of transfers Cause for Transfers Total Original Project Budgets Compared to
Transfers
3
2 $250,000
1
$200,000
0
$150,000
■ m ■ o ■ o v ■ a ■ v
_ o @ o °
o a v $100,000
c i u
CO v ° 3 v v
� v v c
v
a o CL z °
3 > o 0 3 0
° 0 N N
s 6 z $50,000
u o LL
� � F.Cost exceeded initial budget
E. New project scope
C° s D.New Project
f s C. Developer/CAD or other cost neutral
AW B.Cashflow accelerations
$ ~ A.Bundling/Unbundling
Notes:
There was one transfer in August 2019; a movement of$200,000 from contingency for a new project: S.R. Pump Station Flow Diversion (8462)
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 78 of 128
PaccglRoTFMNSFERS SINCE FY 2016=1 7
Total Original Project Budgets Compared to Transfers
#of
transfers Cause for Transfers - - - -
............
$60,000,000 ...........
16
14 $50,000,000 `
12
$40,000,000
10
8
lrr..
$30,000,000
6 -------
4 $20,000,000
2
0 $10,000,000 F.Cost exceeded initial budget
E.New project scope
D.New Project
C.Developer/CAD or other cost neutral
B.Cashflow accelerations
■ m ■ ■ `o ■ y ■ a ■
A.Bundling/Unbundling
9 o m g
a] m v o Z c 0« \� �5 5
_ 0
16
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 79 of 128
Page 34 of 35
FY 2019-20 Running Expense Fund Total Cash & Investment Balances
(Actuals through August 2019)
$60.0
$53.7
$50.0 - S47.2
$48.6 $49.8
$43.4
$40.9
$40.0 $37.3 $38.2
$38.4
$33.8 $32.9
$30.0 $29.0
$24.6 $24.2 $24.0
$20.0 $17.6 $18.9
$10.0
$0.0
41 Z e�
N P�� �eQ O 00 4,11P
�04
el Fe
=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
***The actual balance is lower than projected due to Concord annual bill ($15.2M) being received the first week of September
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 80 of 128
Page 35 of 35
FY 2019-20 Sewer Construction Fund Total Cash & Investment Balances
(Actuals through August 2019)
$70.0
$62.5
�`
$61.6
$60.0 $56.3 $58.3 $56.1
$52.3 $51.9 $52.6 $54.0 $52.1
$50.0 $49.8 $47.0 $48.1
$47.6
$43.2
$40.0 $39.2
$30.0 $32.0
$30.4
$20.0
$10.0
$0.0
yelp �e��
Oe >a lea �
MProjected 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
***The actual balance is lower than projected due to Concord annual bill ($8.01VI) being received the first week of September
September 24, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 81 of 128