The URL can be used to link to this page

Home My WebLink About03.b. Review March 2019 Financial Statements and Investment Reports Page 1 of 42 Item 3.b. Av CENTRAL SAN April 23, 2019 TO: FINANCE COMMITTEE FROM: CHRIS THOMAS, FINANCE ADMINISTRATOR REVIEWED BY: PHILIP LEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION ANN SASAKI, DEPUTY GENERAL MANAGER ROGER S. BAILEY, GENERAL MANAGER SUBJECT: REVIEW MARCH 2019 FINANCIAL STATEMENTS AND INVESTMENT REPORTS Attached for review are the Financial Statements and Investment Reports as of the date shown above. Staff is creating several new reports related to areas of interest to the Board that will be added to this package in the coming months. The first such reports are at the end of this package in new section entitled "Dashboard Data". The first reports include pension and Other Post-Employment Benefits (OPEB)funding summary, Capital Improvement Budget (Cl B)transfers, and intra-year projected and actual cash and investment balances for Running Expense and Sewer Construction funds. Still pending is a commitments report for CI B expenditures that will aggregate the project-by-project commitments that have already been shown for the past month as projects are brought to the Engineering & Operations Committee for review. Comments on the new reports are invited. Strategic Plan re-In GOAL THREE: Be a Fiscally Sound and Effective Water Sector Utility Strategy 1 - Conduct long-range financial planning, Strategy 2- Manage costs ATTACHMENTS: 1. March 2019 Financial Statements and Investment Reports April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 67 of 156 P"MIRRRL(OTRA COSTA SANITARY DISTRICT April 10,2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS e,'I' FROM: AMAL LYON SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through period ending March 31,2019: YTD Fav/(Unfav) Variance O&M Revenues: Budgeted Actual Variance Explanation First installment received was higher than budgeted. Percentage received varies Total $37,267,920 $ 43,490,893 $ 6,222,973 annually. O&M Expenses: Total Labor Charges $39,176,118 $ 38,650,084 $ 526,034 Expenses are typically lower in the beginning of the year. Some positions budgeted for in July are filled later in the fiscal year resulting in savings. Chemicals 1,073,290 934,115 139,175 Chemicals are purchased sporadically throughout the year rather than monthly as is budgeted. The variance should be reduced by year-end. Utilities 2,847,989 2,901,914 (53 925) Higher than budget due to high PG&E bills Repairs&Maintenance 3,973,600 3,294,142 679,458 Lower due to budget spread over 12 months versus actual expense occurring sporadically throughout the year. Professional&Legal Services 633,909 517,775 116,134 Due to delay in legal and professional invoices. Outside Services 2,691,644 1,910,635 781,009 Mostly due to lower Technical Services than budgeted thus far in the fiscal year.Another main contributor is RSC Services/Xerox Corporation only paid through Oct.Various billing issues in Dispute. Other Expenses 2,318,297 1,863,294 455,003 BACWA expense lower than budget by$154k. However,additional BACWA expense may be incurred later in the fiscal year for Nutrient Studies. Public Agency Fees, Public information&Tech training expenses lower than budgeted thus far in the fiscal year. Unfunded Liabilities 11,067,338 11,349,161 (281,823) Variance due to UAAL vacancy. Budgeted vacancy is higher than actual vacancies thus far in the fiscal year. All Other 3,156,450 3,166,062 (9 612) Minor variances for multiple account categories. Total $66,938,635 $ 64,587,182 $ 2,351,453 April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 68 of 156 Page 2 of 41 J&V lics entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 001 - RUNNING EXPENSE(O&M) March 2019 Fiscal Period 9/2019 Report Generated on Apr 10, 2019 9:25:27 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% $14,800,000 $14,800,000 0.0% HHW $8,000 $8,464 5.8% $82,000 $74,564 -9.1% $929,000 $854,436 8.0% Other $243,664 $367,183 50.7% $3,027,676 $3,582,181 18.3% $4,123,000 $540,819 86.9% Sewer Service Charges $14,916 $13,295 -10.9% $34,158,244 $39,834,148 16.6% $67,073,732 $27,239,584 59.4% Total Revenue $266,580 $388,943 45.9% $37,267,920 $43,490,893 16.7% $86,925,732 $43,434,839 50.0% Page 3 of 41 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 -RUNNING EXPENSE(O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:27:11 AM $70,000,000.00 $66,938,635 Budget Actual $64,587,182 $60,000,000.00 $58,48 $51,37 411,026 $50,000,000.00 $44,52 ,586,006 $40,000,000.00 $37,537,572 $42,592,870 $35,666,108 $30,000,000.00 $30,229,184 $23,129,558 $28,064,083 $20,000,000.00 $21,657,968 $16,222,021 $14,989,002 $10,000,000.00 $8,838,210 $8,238,746 $0.00 Jul(1)2018 Aug(2)2018 Sep(3)2018 Oct(4)2018 Nov(5)2018 Dec(6)2018 Jan(7)2019 Feb(8)2019 Mar(9)2019 Fiscal Periods Page 4 of 41 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE(O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:27:11 AM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $2,964,217 $2,771,682 $192,535 6.5% $26,677,953 $26,210,221 $467,732 1.8% $35,571,037 73.7% EMPLOYEE BENEFITS $1,686,321 $1,759,793 ($73,472) -4.4% $15,482,889 $15,338,966 $143,923 0.9% $20,993,695 73.1% CAPITALIZED ADM OVERHEAD ($331,636) ($509,397) $177,761 -53.6% ($2,984,724) ($2,899,103) ($85,621) 2.9% ($3,979,723) 72.8% DIRECTOR FEES&EXPENSES $14,041 $12,300 $1,741 12.4% $126,369 $118,249 $8,120 6.4% $168,494 70.2% CHEMICALS $121,547 $190,349 ($68,802) -56.6% $1,073,290 $934,115 $139,175 13.0% $1,459,000 64.0% UTILITIES $345,206 $409,868 ($64,662) -18.7% $2,847,989 $2,901,914 ($53,925) -1.9% $4,142,550 70.1% REPAIRS&MAINTENANCE $427,431 $386,049 $41,382 9.7% $3,973,600 $3,294,142 $679,459 17.1% $5,414,644 60.8% HAULING&DISPOSAL $93,867 $90,029 $3,838 4.1% $696,803 $656,494 $40,309 5.8% $1,126,475 58.3% PROFESSIONAL&LEGAL SERV $72,101 $58,876 $13,225 18.3% $633,909 $517,776 $116,133 18.3% $845,300 61.3% OUTSIDE SERVICES $411,726 $334,422 $77,304 18.8% $2,691,644 $1,910,635 $781,009 29.0% $3,510,822 54.4% SELF-INSURANCE EXPENSE $0 $5 ($5) 0.0% $779,500 $779,505 ($5) 0.0% $779,500 100.0% MATERIALS&SUPPLIES $175,642 $233,071 ($57,429) -32.7% $1,553,778 $1,611,812 ($58,034) -3.7% $2,108,126 76.5% OTHER EXPENSES $132,134 $121,525 $10,609 8.0% $2,318,297 $1,863,294 $455,003 19.6% $2,777,258 67.1% UNFUNDED LIABILITIES $2,343,356 $2,317,584 $25,772 1.1% $11,067,338 $11,349,161 ($281,823) -2.5% $14,803,278 76.7% Total Expenses $8,455,953 $8,176,156 $279,797 3.3% $66,938,635 $64,587,182 $2,351,453 3.5% $89,720,456 72.0% Color Key: 0 to 10%over budget > 10%over budget M Page 5 of 41 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE (O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM $4,000,000 ❑Period Budget $25,000,000 ' ❑YTD Budget ❑Period Actual ❑ YTD Actual $20,000,000- $3,000,000- $15,000,000- $2,000,000- $10,000,000- $1,000,000- $5,000,000 15,000,000$2,000,000 $10,000,000$1,000,000 $5,000,000 LlLL� $0 $0 - I Po�� G°��°�� Q��c°e� S�P �� Po��`s\��°�c�`�``�� °��o �oQ�c Q J�Q S�P � Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $3,376,515 $3,279,296 $97,219 $20,790,498 $19,015,295 $1,775,203 ENGINEERING $1,369,715 $1,117,046 $252,669 $12,771,794 $12,348,226 $423,568 COLLECTION SYSTEM OPS. $1,162,280 $1,242,269 ($79,989) $10,357,021 $10,445,684 ($88,663) PLANT OPERATIONS $2,173,526 $2,173,565 ($39) $19,725,601 $19,799,577 ($73,976) PUMP STATIONS $244,538 $258,838 ($14,300) $2,141,976 $2,093,254 $48,722 RECYCLED WATER $129,379 $105,141 $24,238 $1,151,745 $885,145 $266,600 Totals $8,455,953 $8,176,156 $279,797 $66,938,635 $64,587,182 $2,351,453 Page 6 of 41 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM Department: ADMINISTRATION Categor;711k. Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % SALARIES&WAGES $611,365 $549,919 $61,446 10.1% $5,502,285 $5,086,995 $415,290 7.5% $7,336,515 69.3% EMPLOYEE BENEFITS $652,688 $743,416 ($90,728) -13.9% $6,180,192 $5,851,187 $329,005 5.3% $8,588,771 68.1% CAPITALIZED ADM OVERHEAD ($4,147) ($2,219) ($1,928) 46.5% ($37,323) ($23,555) ($13,768) 36.9% ($49,764) 47.3% DIRECTOR FEES&EXPENSES $14,041 $12,300 $1,741 12.4% $126,369 $118,249 $8,120 6.4% $168,494 70.2% UTILITIES $10,816 $20,272 ($9,456) -87.4% $97,344 $99,317 ($1,973) -2.0% $129,800 76.5% REPAIRS&MAINTENANCE $70,592 $25,930 $44,662 63.3% $860,548 $584,809 $275,739 32.0% $1,132,390 51.6% PROFESSIONAL&LEGAL SERV $55,771 $44,362 $11,409 20.5% $486,939 $408,084 $78,855 16.2% $649,300 62.8% OUTSIDE SERVICES $265,355 $183,278 $82,077 30.9% $1,280,029 $802,786 $477,243 37.3% $1,647,300 48.7% SELF-INSURANCE EXPENSE $0 $5 ($5) 0.0% $779,500 $779,505 ($5) 0.0% $779,500 100.0% MATERIALS&SUPPLIES $16,329 $21,257 ($4,928) -30.2% $146,961 $93,298 $53,663 36.5% $196,025 47.6% OTHER EXPENSES $57,336 $78,541 ($21,205) -37.0% $753,199 $627,405 $125,794 16.7% $960,040 65.4% UNFUNDED LIABILITIES $1,626,369 $1,602,235 $24,134 1.5% $4,614,455 $4,587,214 $27,241 0.6% $6,199,286 74.0% ADMINISTRATION Total Expenses $3,376,515 $3,279,296 $97,219 2.9% $20,790,498 $19,015,295 $1,775,203 8.5% $27,737,657 68.6% Color Key: 0 to 10%over budget > 10%over budget M Page 7 of 41 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM Department: ENGINEERING Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $833,166 $745,214 $87,952 10.6% $7,498,494 $7,473,700 $24,794 0.3% $9,998,042 74.8% EMPLOYEE BENEFITS $329,253 $311,618 $17,635 5.4% $2,963,277 $3,084,098 ($120,821) -4.1% $3,951,391 78.1% CAPITALIZED ADM OVERHEAD ($296,790) ($419,543) $122,753 -41.4% ($2,671,110) ($2,617,406) ($53,704) 2.0% ($3,561,499) 73.5% UTILITIES $14,432 $17,937 ($3,505) -24.3% $129,888 $139,760 ($9,872) -7.6% $173,200 80.7% REPAIRS&MAINTENANCE $14,281 $14,127 $154 1.1% $128,529 $63,256 $65,273 50.8% $171,400 36.9% HAULING&DISPOSAL $44,867 $37,630 $7,237 16.1% $255,803 $291,303 ($35,500) = $538,425 54.1% PROFESSIONAL&LEGAL SERV $14,248 $14,033 $215 1.5% $128,232 $87,041 $41,191 32.1% $171,000 50.9% OUTSIDE SERVICES $96,931 $94,614 $2,317 2.4% $979,321 $653,333 $325,988 33.3% $1,270,142 51.4% MATERIALS&SUPPLIES $32,915 $43,377 ($10,462) -31.8% $296,235 $238,766 $57,469 19.4% $395,050 60.4% OTHER EXPENSES $22,962 $9,504 $13,458 58.6% $692,075 $457,950 $234,125 33.8% $764,812 59.9% UNFUNDED LIABILITIES $263,450 $248,536 $14,914 5.7% $2,371,050 $2,476,427 ($105,377) -4.4% $3,161,443 78.3% ENGINEERING Total Expenses $1,369,715 $1,117,046 $252,669 18.4% $12,771,794 $12,348,226 $423,568 3.3% $17,033,406 72.5% Color Key: 0 to 10%over budget > 10%over budget M Page 8of41 ' Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM Department: COLLECTION SYSTEM OPS. Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $522,693 $545,607 ($22,914) -4.4% $4,704,237 $4,782,268 ($78,031) -1.7% $6,272,384 76.2% EMPLOYEE BENEFITS $255,254 $262,347 ($7,093) -2.8% $2,297,286 $2,345,055 ($47,769) -2.1% $3,063,394 76.6% CAPITALIZED ADM OVERHEAD ($2,676) ($2,978) $302 -11.3% ($24,084) ($28,361) $4,277 = ($32,120) 88.3% UTILITIES $12,115 $10,829 $1,286 10.6% $109,035 $107,997 $1,038 1.0% $145,400 74.3% REPAIRS&MAINTENANCE $122,873 $145,171 ($22,298) -18.1% $1,007,358 $878,994 $128,364 12.7% $1,474,504 59.6% HAULING&DISPOSAL $10,916 $3,970 $6,946 63.6% $98,244 $53,340 $44,904 45.7% $131,000 40.7% PROFESSIONAL&LEGAL SERV $625 $241 $384 61.5% $5,625 $1,732 $3,893 69.2% $7,500 23.1% OUTSIDE SERVICES $4,972 $2,468 $2,505 50.4% $44,748 $46,524 ($1,776) -4.0% $59,680 78.0% MATERIALS&SUPPLIES $63,074 $91,910 ($28,836) -45.7% $550,666 $642,340 ($91,674) = $756,951 84.9% OTHER EXPENSES $10,529 $11,743 ($1,214) -11.5% $106,761 $96,562 $10,199 9.6% $138,445 69.7% UNFUNDED LIABILITIES $161,905 $170,961 ($9,056) -5.6% $1,457,145 $1,519,234 ($62,089) -4.3% $1,942,922 78.2% COLLECTION SYSTEM OPS.Total $1,162,280 $1,242,269 ($79,989) -6.9% $10,357,021 $10,445,684 ($88,663) -0.9% $13,960,060 74.8% Expenses Color Key: 0 to 10%over budget > 10%over budget Page 9of41 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM Department: PLANT OPERATIONS Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $869,326 $810,479 $58,847 6.8% $7,823,934 $7,778,399 $45,535 0.6% $10,432,017 74.6% EMPLOYEE BENEFITS $380,506 $375,218 $5,288 1.4% $3,424,554 $3,494,400 ($69,846) -2.0% $4,566,639 76.5% CAPITALIZED ADM OVERHEAD ($28,023) ($84,657) $56,634 -202.1% ($252,207) ($229,781) ($22,426) 8.9% ($336,340) 68.3% CHEMICALS $93,715 $187,147 ($93,432) -99.7% $843,635 $806,859 $36,776 4.4% $1,125,000 71.7% UTILITIES $250,215 $288,219 ($38,004) -15.2% $2,031,103 $2,102,524 ($71,421) -3.5% $3,002,600 70.0% REPAIRS&MAINTENANCE $186,609 $162,368 $24,241 13.0% $1,679,481 $1,524,141 $155,340 9.2% $2,239,400 68.1% HAULING&DISPOSAL $37,351 $47,488 ($10,137) -27.1% $336,159 $303,949 $32,210 9.6% $448,250 67.8% PROFESSIONAL&LEGAL SERV $291 $241 $50 17.2% $2,619 $1,872 $747 28.5% $3,500 53.5% OUTSIDE SERVICES $19,912 $29,113 ($9,201) -46.2% $179,208 $256,055 ($76,847) $239,000 107.1% MATERIALS&SUPPLIES $58,871 $70,957 ($12,086) -20.5% $519,839 $611,708 ($91,869) $706,600 86.6% OTHER EXPENSES $35,534 $18,417 $17,117 48.2% $714,305 $637,085 $77,220 10.8% $844,615 75.4% UNFUNDED LIABILITIES $269,219 $268,576 $643 0.2% $2,422,971 $2,512,367 ($89,396) -3.7% $3,230,674 77.8% PLANT OPERATIONS Total Expenses $2,173,526 $2,173,565 ($39) 0.0% $19,725,601 $19,799,577 ($73,976) -0.4% $26,501,955 74.7% Color Key: 0 to 10%over budget > 10%over budget M Page 10 of 41 j&V ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM Department: PUMP STATIONS Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $80,539 $83,045 ($2,506) -3.1% $724,851 $760,360 ($35,509) -4.9% $966,479 78.7% EMPLOYEE BENEFITS $33,186 $40,339 ($7,153) -21.6% $298,674 $337,122 ($38,448) M $398,256 84.6% CAPITALIZED ADM OVERHEAD $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% CHEMICALS $20,833 $0 $20,833 100.0% $166,664 $61,841 $104,823 62.9% $250,000 24.7% UTILITIES $43,045 $61,218 ($18,173) -42.2% $349,372 $389,531 ($40,159) = $516,550 75.4% REPAIRS&MAINTENANCE $30,661 $38,454 ($7,793) -25.4% $275,949 $231,998 $43,951 15.9% $367,950 63.1% HAULING&DISPOSAL $733 $940 ($207) -28.3% $6,597 $7,902 ($1,305) ®.'. $8,800 89.8% OUTSIDE SERVICES $6,683 $600 $6,083 91.0% $60,147 $13,450 $46,697 77.6% $80,200 16.8% MATERIALS&SUPPLIES $3,466 $5,571 ($2,105) -60.7% $31,194 $18,557 $12,637 40.5% $41,600 44.6% OTHER EXPENSES $2,979 $1,396 $1,583 53.1% $26,811 $18,573 $8,238 30.7% $35,796 51.9% UNFUNDED LIABILITIES $22,413 $27,275 ($4,862) -21.7% $201,717 $253,920 ($52,203)= $268,953 94.4% PUMP STATIONS Total Expenses $244,538 $258,838 ($14,300) -5.8% $2,141,976 $2,093,254 $48,722 2.3% $2,934,584 71.3% Color Key: 0 to 10%over budget > 10%over budget M Page 11 of 41 ' Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM Department: RECYCLED WATER Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $47,128 $37,419 $9,709 20.6% $424,152 $328,498 $95,654 22.6% $565,600 58.1% EMPLOYEE BENEFITS $35,434 $26,854 $8,580 24.2% $318,906 $227,105 $91,801 28.8% $425,244 53.4% CHEMICALS $6,999 $3,201 $3,798 54.3% $62,991 $65,416 ($2,425) -3.8% $84,000 77.9% UTILITIES $14,583 $11,393 $3,190 21.9% $131,247 $62,785 $68,462 52.2% $175,000 35.9% REPAIRS&MAINTENANCE $2,415 $0 $2,415 100.0% $21,735 $10,944 $10,791 49.7% $29,000 37.7% PROFESSIONAL&LEGAL SERV $1,166 $0 $1,166 100.0% $10,494 $19,047 ($8,553) = $14,000 136.1% OUTSIDE SERVICES $17,873 $24,350 ($6,477) -36.2% $148,191 $138,487 $9,704 6.5% $214,500 64.6% MATERIALS&SUPPLIES $987 $0 $987 100.0% $8,883 $7,145 $1,738 19.6% $11,900 60.0% OTHER EXPENSES $2,794 $1,924 $870 31.2% $25,146 $25,719 ($573) -2.3% $33,550 76.7% RECYCLED WATER Total Expenses $129,379 $105,141 $24,238 18.7% $1,151,745 $885,145 $266,600 23.1% $1,552,794 57.0% Color Key: 0 to 10%over budget > 10%over budget M Page 12 of 41 CENTRAL CONTRA COSTA SANITARY DISTRICT RUNNING EXPENSE FUND TEMPORARY INVESTMENTS MARCH,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) $6,000,000 $8,000,000 ($2,000,000) $6,000,000 $6,031,210 23.08% $15,910 $205,120 $221,030 RE05 US Gov't FHLMC 08/31/18 03/04/19 0 2.266% 4,943,215 5,000,000 (5,000,000) 0.00% 921 55,864 56,785 RE07 FHLB FED AGENCY 12/24/18 03/22/19 0 2.424% 4,970,544 5,000,000 (5,000,000) 0.00% 7,029 22,426 29,456 RE08 FHLB FED AGENCY 12/24/18 03/21/19 0 2.448% 4,971,000 5,000,000 (5,000,000) 0.00% 6,667 22,333 29,000 RE09 FHLB FED AGENCY 12/24/18 7/22/19 112 2.558% 4,927,375 5,000,000 5,000,000 4,962,350 19.23% 10,721 23,171 33,892 RE10 FHLB FED AGENCY 12/24/18 7/23/19 113 2.558% 4,927,029 5,000,000 5,000,000 4,962,000 19.23% 10,721 23,171 33,892 RE11 FHLMC FED AGENCY 3/4/19 7/23/19 113 2.420% 4,952,608 5,000,000 5,000,000 4,962,000 19.23% 9,411 RE12 FHLB FED AGENCY 3/22/19 7/23/19 113 2.410% 4,958,829 5,000,000 5,000,000 4,962,000 19.23% 3,347 (3) $40,650,601 $33,000,000 ($7,000,000) $26,000,000 $25,879,560 100.00% 64,727 352,085 404,054 (2) 58,783 58,783 $64,727 $410,868 $462,837 NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of March,2019 was 2.44%. (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.4768%. (4) The market value of the portfolio on March,2019 was$25,879,560. (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. April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 79 of 156 Page 13 of 41 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) March 2019 Fiscal Period 9/2019 Summarized by Account Report Generated on Apr 10,2019 9:21:32 AM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $1,399,960 CASH ACCOUNTS/PAYROLL CLEARING $20,000 CASH ACCOUNTS/PETTY CASH $3,400 CASH ACCOUNTS/TEMPORARY INVESTMENTS $26,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 $33,128,906 DUE FROM/DUE FROM S/I $788,100 INVENTORY/SUPPLIES&MATERIAL INV $2,163,349 PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104 PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572 PREPAID ACCOUNTS/PREPAID EXPENSES $1,000,873 PREPAID ACCOUNTS/PREPAID INSURANCE $2,867 PREPAID ACCOUNTS/PREPAID RETIREMENT $5,681,093 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $127,990 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $413,063 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA $1,837 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $70,769 RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $12,419 RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $100,640 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $3,423 Current Assets $92,498,784 Net Property,Plant and Equipment CONTRIBUTED FIXED ASSETS/ACC DEPR-CONTRIB ASSETS ($61,491,489) CONTRIBUTED FIXED ASSETS/CONTRIBUTED SEWER LINES $159,795,333 FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $35,820,635 FIXED ASSETS/ACC DEPR-BUILDINGS ($14,154,661) FIXED ASSETS/ACC DEPR-FURN&EQUIP ($9,236,015) FIXED ASSETS/ACC DEPR-OUTFALL ($3,768,376) FIXED ASSETS/ACC DEPR-PUMPING STATIONS ($35,288,443) FIXED ASSETS/ACC DEPR-SEWAGE COL SYS ($73,525,809) FIXED ASSETS/ACC DEPR-TREATMENT PLANT ($228,809,775) FIXED ASSETS/ACC DEPR-VEHICLES ($5,217,732) FIXED ASSETS/ACCUM DEPRC-RECY WATER ($9,680,325) FIXED ASSETS/BUILDINGS $44,238,508 FIXED ASSETS/FURNITURE&EQUIPMENT $13,841,424 FIXED ASSETS/INTANGIBLE ASSETS $4,949,507 FIXED ASSETS/LAND $17,320,570 FIXED ASSETS/OUTFALL SEWERS $11,371,574 FIXED ASSETS/PUMPING STATIONS $57,327,020 FIXED ASSETS/RECY WATER INFRASTRUCTURE $20,292,366 FIXED ASSETS/SEWAGE COLLECTION FACIL $379,247,498 FIXED ASSETS/TREATMENT PLANT $341,675,108 FIXED ASSETS/VEHICLES $7,695,424 Net Property,Plant and Equipment $652,402,342 TOTAL ASSETS $744,901,126 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE $0 CURRENT LIABILITIES/ACCOUNTS PAYABLE ($741,528) CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($4,448,044) CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,198,082) Page 14 of 41 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) March 2019 Fiscal Period 9/2019 Summarized by Account Report Generated on Apr 10,2019 9:21:32 AM CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($16,701) CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($670) CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931) CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING ($7,583) CURRENT LIABILITIES/PERMIT CLEARING ($91) CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($41,080) CURRENT LIABILITIES/RETIREMENT CONTRIB W/H $2 CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $96,824 DEF.COMP.CONTRIB W/H/ICMA $0 DUE TO/DUE TO DEBT FUND ($3,528,591) DUE TO/DUE TO S/C ($23,610,448) DUE TO/DUE TO S/I ($783,408) LIABILITIES-LONG TERM/DEFERRED INFLOWS-GASB 68 ($28,076,634) LIABILITIES-LONG TERM/NET OPEB LIAB-GASB 75 ($46,350,454) LIABILITIES-LONG TERM/NET PENSION LIAB-GASB 68 ($63,806,000) LIABILITIES-LONG TERM/POST EMP.BENEFIT-PENSION $5,571,088 LIABILITIES/UNEARNED INTEREST ($153,617) MEDICAL LIABILITIES/DELTA DENTAL $478 MEDICAL LIABILITIES/DISABILITY INS $154 MEDICAL LIABILITIES/HEALTH NET $0 MEDICAL LIABILITIES/KAISER PERMANENTE $3,222 MEDICAL LIABILITIES/LIFE INS $30 MEDICAL LIABILITIES/OCCUPATIONAL HEALTH $3,136 MEDICAL LIABILITIES/POST EMP.BENEFIT-OPEB $395,700 PAYROLL TAXES WITHHELD/CALIFORNIA WITHHOLDING $368 PAYROLL TAXES WITHHELD FEDERAL WITHHOLDING $792 REIMBURSEMENT FEES ($54,466) Total Liabilities ($166,885,534) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE ($38,409,231) FUND EQUITY/CAPITAL COST SHARING ($115,056,482) FUND EQUITY/CONTRIBUTED SEWER LINES ($159,795,333) FUND EQUITY/EXPENDITURE SUMMARY $64,587,182 FUND EQUITY/GENERAL FIXED ASSET GROUP ($210,549,556) FUND EQUITY/STATE R FED CAPITAL GRANT ($75,301,279) YEAR TO DATE REVENUES/REVENUE SUMMARY ($43,490,893) Total Fund Equity ($578,015,592) TOTAL LIABILITIES AND FUND EQUITY ($744,901,126) Page 15 of 41 CENTRAL CONTRA COSTA SANITARY DISTRICT April 10, 2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS CO-- FROM: AMAL LYON W SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending March 31,2019: YTD YTD Fav/(Unfav) SIC Revenues: Budgeted Actual Variance Explanation SSC&Property tax revenue received from the County Total $ 24,446,229 $ 29,188,396 $ 4,742,167 was higher than budgeted. FY YTD FY S/C Expenses: Budget* Actual Remaining %Spent Total $ 52,287,827 $ 26,049,059 $ 26,238,768 49.82% Includes 17/18 carry-over($6,968,827) April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 82 of 156 Page 16 of 41 AIMILSentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 002-SEWER CONSTRUCTION (Capital) March 2019 Fiscal Period 9/2019 Report Generated on Apr 10, 2019 9:25:27 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% $7,150,000 $7,150,000 0.0% Other $625,581 $710,302 13.5% $10,483,229 $12,600,699 20.2% $20,813,000 $8,212,301 60.5% Sewer Service Charges $0 $5,536 0.0% $13,963,000 $16,587,697 18.8% $27,926,268 $11,338,571 59.4% Total Revenue $625,581 $715,839 14.4% $24,446,229 $29,188,396 19.4% $55,889,268 $26,700,872 52.2% Page 17 of 41 Sewer Fund (Capital) Spending FY 18-19 $35,000,000 $32,401,823 $29,197,153 $30,000,000 $23,890,698 $26,513,645 $25,000,000 $19,397,124 Page f 4 1 lo $26,049,059 $20,000,000 $23,808,150 $20,736,779 $15,000,000 $13,377,477 $18,379,941 $9,429,510 $14,503,936 $10,000,000 $11,543,304 $3,996,336 $5,000,000 $1,426,829 $8,485,345 $ $3,404,835 $1,600,939 July August September October November December January February Mnrrh Projected* Actual Columnl July August September October November December January February March Projected* $ 1,426,829 $ 3,996,336 $ 9,429,510 $ 13,377,477 $ 19,397,124 $ 23,890,698 $ 26,513,645 $ 29,197,153 $ 32,401,823 Actual 1,600,939 3,404,835 8,485,345 11,543,304 14,503,936 18,379,941 20,736,779 23,808,150 26,049,059 *Projected - Current year budget allocated by month based on historical spending in previous 2 years A-,-;I ')0 004n o .,,1 CIAIAAIr'C r-,.,....,...,;++-- rA--+;-- A-..-,+, r)-.,.I,,.+ 17).--- 0n _F -1 M2 Page 18 of 41 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 3/31/2019 PERIOD 9/2019 A )nnC -B DE ) 7EXPENDITURES (C+D+E) I (F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTEDPPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET SPENT IN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19Y 2018-19 FY 2018-19 FY 2018-19 TYPE CS Collection System $ 29,409,417 30,841,697 (1,432,280) 19,347,000 600,000 19,947,000 18,514,720 13,639,812 4,874,925 TYPE TP Treatment Plant 32,746,274 26,758,622 5,987,652 16,865,000 1,231,177 18,096,177 24,083,829 9,746,254 14,337,582 TYPE GI General Improvements 9,024,737 7,225,141 1,799,596 4,750,000 (1,208,677) 3,541,323 5,340,919 1,421,137 3,919,780 TYPE RW Recycled Water 2,382,894 1,769,035 613,859 2,857,000 - 2,857,000 3,470,859 1,241,856 2,229,002 CIB Contingency - - - 1,500,000 (622,500) 877,500 877,500 - 877,500 TOTAL DISTRICT 73,563,322 $ 66,594,495 $ 6,968,827 $ 45,319,000 $ 45,319,000 $ 52,287,827 $ 26,049,059 $ 26,238,789 Argil 7'3 7()10 Donidnr MKIAAI('G ('nmmif+cc KAccfinn Anonrin DnnIrG+_ Dorm S2r.of 1G.C. Page 19 of 41 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 3/31/2019 PERIOD 9/2019 A )nnn -B DE ) (C+D+E) I (F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 TYPE CS Collection S stem 5991 PH Sewer Renovation Phase 2 460,000 277,761 182,239 - - 182,239 - 182,239 ****6534 Harper Lane Area CAD - - - - 800,000 800,000 800,000 174,029 625,971 6602 South Jackson CAD 411,290 391,290 20,000 - - 20,000 - 20,000 6603 North Jackson CAD 400,000 - 400,000 - (123,443) (123,443) 276,557 31,372 245,185 ****6679 Coredell Drive CAD - - - - 123,443 123,443 123,443 54,906 68,537 **7367 Concord Main Metering Station - - - - 250,000 250,000 250,000 12,729 237,271 8249 CSO Dump Pad Modifications 60,000 - 60,000 - - 60,000 6,853 53,147 *8412 PH Grayson Creek Trunk 15,100,000 15,061,359 38,641 - - 38,641 179,070 (140,429) 8419 Collection System Planning LT 885,000 884,387 613 100,000 100,000 100,613 79,588 21,025 *8430 Lafayette Sewer Renovation Phase 11 4,319,000 4,289,317 29,683 - - 29,683 13,399 16,284 8433 S.Orinda Sewer Renovation Phase 6 1,962,127 3,066,717 (1,104,590) 2,758,873 2,758,873 1,654,283 1,539,090 115,193 8435 WC Sewer Renovation Phase 12 1,450,000 2,891,122 (1,441,122) 3,100,000 3,100,000 1,658,878 1,645,835 13,043 8436 Moraga/Crossroads PS Project 1,300,000 1,138,016 161,984 2,697,000 (250,000) 2,447,000 2,608,984 1,293,219 1,315,765 8441 CIPP Contract 17-20 300,000 80,247 219,753 100,000 100,000 319,753 171,503 148,250 8442 PS Equipment Piping Replacement PH2 36,000 - 36,000 25,000 25,000 61,000 - 61,000 8443 LG Diameter Pipe line Inspection 200,000 5,793 194,207 50,000 50,000 244,207 10,696 233,511 8444 Force Main Inspection Program 75,000 - 75,000 50,000 50,000 125,000 - 125,000 8445 N.Orinda Sewer Renovation 636,000 768,680 (132,680) 3,731,000 3,731,000 3,598,320 3,481,161 117,159 8446 Lafayette Sewer Renovation Phase 12 636,000 1,216,107 (580,107) 3,397,600 3,397,600 2,817,493 2,493,626 323,867 8447 Pump Station Security Improvement 131,000 - 131,000 25,000 25,000 156,000 - 156,000 8448 Manhole Modifications 400,000 375,370 24,630 300,000 300,000 324,630 131,170 193,460 8449 Collection System Modeling Support 100,000 56,761 43,239 100,000 100,000 143,239 44,180 99,059 8450 Development Sewerage Support 400,000 240,770 159,230 250,000 250,000 409,230 724,266 (315,036) 8451 C.S.Sewer Renovation 50,000 - 50,000 2,612,527 (2,200,000) 412,527 462,527 - 462,527 ***8452 Lafayette Sewer Ren. Ph. 13 - - - - 500,000 500,000 500,000 325,217 174,783 *8453 Willows Sewer Repair 98,000 98,000 - - - - - - ***8454 So.Orinda Sewer Ren. Ph.7 - - - - 500,000 500,000 500,000 503,486 (3,486) ***8455 W.C.Sewer Renov. Ph. 13 - - - - 500,000 500,000 500,000 512,626 (12,626) ***8456 Danville Sewer Ren. Ph.3 - - - - 500,000 500,000 500,000 211,791 288,209 8457 Pump Station Upgrades-Ph.2 - - - 50,000 50,000 50,000 - 50,000 Rounding 17 Total FY 2018-19 CS Amount $ 29,409,417 30,841,697 (1,432,280) 19,347,000 600,000 19,947,000 18,514,720 13,639,812 4,874,925 *Italic Projects open but not in CIB for 18/19 *** Not in 18/19 Budget. New projects opened in August 2018. Funds transferred from DP8451 Anril ')4 onto Rona In IZIKIA[\I('D r'-iff- nano+inn A,-In Dn,Lnf- Dnn AP of 9r,9 Page 20 of 41 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 3/31/2019 PERIOD 9/2019 A )nnn -B DE ) 7EXPENDITURES (C+D+E) I (F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTEDPPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET SPENT IN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19Y 2018-19 FY 2018-19 FY 2018-19 **** Not in 18/19 Budget. New projects opened in October 2018. Funds transferred from DP7353,7315,8451&6603 for CAD ** Not in 18/19 Budget. New projects opened in December 2018. Funds transferred from DP8436 TYPE TP Treatment Plant 7291 Pump&Blower Bldg.Seismic Upgrade 6,692,000 6,638,700 53,300 - - - 53,300 10,393 42,907 7292 Switchgear Refurbishment-Ph.2 770,000 433,911 336,089 200,000 - 200,000 536,089 32,688 503,401 7304 Instr&Controls PLC Upgrade 575,000 397,606 177,394 110,000 - 110,000 287,394 70,065 217,329 7315 Applied Research and Innovations 557,274 251,302 305,972 300,000 (300,000) - 305,972 39,032 266,940 7317 Plant Control System Network Upgrades 330,000 234,234 95,766 100,000 - 100,000 195,766 9,250 186,516 7320 Plant Energy Optimization 1,094,000 1,063,448 30,552 - - - 30,552 (58,880) 89,432 7322 Fire Protection System Ph.2 1,406,000 1,014,803 391,197 - - - 391,197 310,003 81,194 7326 Equipment Replacement FY 15-FY 24 1,166,000 748,217 417,783 250,000 - 250,000 667,783 778,008 (110,225) 7327 Headwork's Screening Upgrade 8,144,000 7,845,455 298,545 76,000 - 76,000 374,545 155,295 219,250 7328 Influent Pump Electrical improvements 100,000 757 99,243 510,000 - 510,000 609,243 176,512 432,731 7329 MHF Burner Upgrade 220,000 156,933 63,067 - - - 63,067 - 63,067 7330 Piping Renovation Phase 9 2,566,000 513,944 2,052,056 614,000 - 614,000 2,666,056 2,356,159 309,897 7339 T. Plant Control System 1/0 Replacement 470,000 605,231 (135,231) 900,000 - 900,000 764,769 92,644 672,125 7341 WC/Grayson Creek Levee Rehab 100,000 - 100,000 - - - 100,000 36,876 63,124 7348 Solids Handling Facility Improvements 4,975,000 4,516,007 458,993 5,715,000 - 5,715,000 6,173,993 2,344,896 3,829,097 7349 Aeration& Energy Upgrade 300,000 35,539 264,461 1,200,000 - 1,200,000 1,464,461 178,952 1,285,509 7351 Mechanical&Concrete Renovation 1,300,000 1,254,155 45,845 3,000,000 - 3,000,000 3,045,845 912,374 2,133,471 7352 UV Disinfection Upgrades - - - 500,000 - 500,000 500,000 134,507 365,493 7353 Outfall Improvements Ph.7 - - - 400,000 (300,000) 100,000 100,000 15,496 84,504 7354 TP Security Improvements 87,000 2,995 84,005 50,000 - 50,000 134,005 22,058 111,947 7355 Odor Control Upgrade Ph. 1 44,000 - 44,000 200,000 - 200,000 244,000 - 244,000 7357 Plant Wide Instrumentation Upgrade 100,000 27,288 72,712 190,000 - 190,000 262,712 50,570 212,142 7358 Innovation Bioenergy Demo 300,000 261,182 38,818 - - - 38,818 1,585 37,233 7359 Solids Conditioning Bldg. roof replacement 500,000 189,377 310,623 800,000 - 800,000 1,110,623 893,309 217,314 7360 Existing Plant Facility Drawing 100,000 83,040 16,960 100,000 - 100,000 116,960 41,684 75,276 7362 POB Seismic Upgrades 400,000 135,591 264,409 1,100,000 1,831,177 2,931,177 3,195,586 868,373 2,327,213 7363 Treatment Plant Planning 450,000 348,907 101,093 450,000 - 450,000 551,093 274,405 276,688 7364 TP Safety Enhancement Ph.5 - - - 100,000 - 100,000 100,000 - 100,000 Rounding 7 Total FY 2017-18 TP Amount $ 32,746,274 26,758,622 5,987,652 16,865,000 1,231,177 18,096,17 24,083,829 9,746,254 14,337,582 *Italic Projects open but not in CIB for 18/19 AnriI ')'2 7/11Q D�n11Inr GIAIAAI('1= (-i#.- 1%A o+inn An nr4n DonL f- Dono 527 of 9 FC. Page 21 of 41 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 3/31/2019 PERIOD 9/2019 A )nnn -B DE ) (C+D+E) I (F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 TYPE GI General Improvements 8207 General Security and Access $ 194,616 121,661 72,955 500,000 (559,641) (59,641) 13,314 13,313 1 8230 Capital Legal Services 158,665 132,070 26,595 20,000 - 20,000 46,595 10,191 36,404 8236 District Easements 208,047 164,616 43,431 50,000 - 50,000 93,431 49,497 43,934 8238 Asset Management 2,969,185 2,790,236 178,949 400,000 - 400,000 578,949 483,372 95,577 8240 IT Development 2,188,794 2,187,431 1,363 1,750,000 (450,000) 1,300,000 1,301,363 212,141 1,089,222 8243 Server Room Relocation 955,430 515,656 439,774 880,000 164,570 1,044,570 1,484,344 327,987 1,156,357 8247 Property&Building Improvements 400,000 178,767 221,233 300,000 (363,606) (63,606) 157,627 169,608 (11,981) 8248 Cyber Security 75,000 - 75,000 - - - 75,000 - 75,000 8516 District Equipment Acquisition 676,000 590,745 85,255 200,000 - 200,000 285,255 14,830 270,425 8517 Vehicle Replacement Program 1,199,000 603,959 595,041 650,000 - 650,000 1,245,041 140,200 1,104,841 9999 Capital Project Clearing(Accounting Use Only)** - (60,000) 60,000 - - - 60,000 (2) 60,002 Rounding (2) Total FY 2017-18 GI Amount 9,024,737 7,225,141 1,799,596 (1,208,677) 3,541,323 5,340,919 1,421,137 3,919,780 Ancil ` '4 onia P,I^JY GIKIA[\I(`D ('nmmiffoo r%Roofinn An nr4n D-Lof- Do 5252 of IrP Page 22 of 41 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 3/31/2019 PERIOD 9/2019 A )nnn -B DE ) (C+D+E) I (F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENT IN REMAINING BUDGET NO PROJECT TITLE PYS(THRU FYE 17-18) PYS(THRU FYE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 TYPE RW Recycled W 7306 Zone 1 Recycled Water 497,894 484,984 12,910 35,000 - 35,000 47,910 14,358 33,552 7346 Surge Analysis 16-17 155,000 3,125 151,875 50,000 - 50,000 201,875 109,516 92,359 7361 Filter Plant Improvments 330,000 162,293 167,707 2,457,000 - 2,457,000 2,624,707 892,327 1,732,380 7365 Recycle Water Clearwell Repairs 1,400,000 1,118,633 281,367 300,000 - 300,000 581,367 225,655 355,712 7366 ReW Distribution System Renov. Program - - - 15,000 - 15,000 15,000 - 15,000 Rounding (1) Total FY 2016-17 RW Amount $ 2,382,894 1,769,035 613,859 2,857,000 - 2,857,000 3,470,859 1,241,856 2,229,002 9990 CONTINGENCY-ALL PROGRAMS - - - 1,500,000 (622,500) 877,500 877,500 877,500 GRAND TOTAL $ 73,563,322 66,594,495 6,968,827 45,319,000 - 45,319,000 52,287,827 26,049,059 26,238,789 Anril 0a 7()10 Dnr iI- GINIAN I(`I= ('-iff- rkA o+inn An nr!o D-Lo+_ Dnn 520 of 11:,9 Page 23 of 41 FY 18-19 CAPITAL BUDGET TRANSFERS PERIOD ENDING:3/31/19 Position Paper Position Paper Memo to GM Position Paper Position Paper approved 10/4/19 item 2 11/15 Item 10 11/1 item 7 & 12/20 item 7 09/05/18 & Deputy GM &GM 12/12 GM 12/19 &GM 18/19 Contingency signature 1/08/19 PROD.# PROJECTS TOTAL Balance *8451 C.S.Sewer Renovation (2,000,000) (200,000) - - - (2,200,000) *8452 Lafayette Sewer Ren. Ph. 13 500,000 - 500,000 *8454 So. Orinda Sewer Ren. Ph. 7 500,000 - 500,000 *8455 W.C.Sewer Renov. Ph. 13 500,000 - - - 500,000 *8456 Danville Sewer Renov. Ph. 3 500,000 - - - - 500,000 6534 Harper Lane Area CAD(new Project) - 800,000 - - - 800,000 7353 Outfall Improvements (300,000) - - - (300,000) 7315 Applied Research (300,000) - - - (300,000) 7367 Concord Main Metering Station - 250,000 - - 250,000 8436 Moraga Crossroads Pump Station - (250,000) - - (250,000) 8243 Server Room Relocation Proj. - - 164,570 - 164,570 7362 POB Seismic Upgrades - - 1,831,177 - 1,831,177 8240 IT Technology Development - - (450,000) (450,000) 8247 Property& Building Improvements - - - (363,606) (363,606) 8207 General Security&Access - - - (559,641) - (559,641) 6679 Cordell Drive CAD - - - - 123,443 123,443 6603 North Jackson CAD - - - - (123,443) (123,443) 9990 Capital Projects-Contingency - - - (622,500) - (622,500) 877,500 0 * Not actual transfers. All part of one project split into individual projects for construction April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 90 of 156 Page 24 of 41 O&M PROJECTS- EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 03/31/19 01/06/00 OM043 - Naval Weapons Station Prior years Project expended Expenditure type through 17-18 Jul. '18 Aug. '18 Sept. '18 Oct. '18 Nov. '18 Dec. '18 Jan. '19 Feb. '19 Mar. '19 Apr. '19 May'19 Jun. '19 2018-19 YTD to date Salary& Benefits $ 17,293 $ - $ - $ - $ - $ - $ - $ - $ - $ 136 $ - $ - $ - $ 136 $ 17,429 Technical Services $ 75,169 - - - - - - - - - - - - - $ 75,169 Total $ 92,462 1 $ - $ - $ - $ - $ - $ - $ - $ - $ 136 $ - $ - $ - $ 136 $ 92,598 Page 25 of 42 OM080 - CoCo Farm (Kiewit Future Farm Proposal) Prior years Project expended Expenditure type through 17-18 Jul. '18 Aug. '18 Sept. '18 Oct. '18 Nov. '18 Dec. '18 Jan. '19 Feb. '19 Mar. '19 Apr. '19 May'19 Jun. '19 2018-19 YTD to date Salary& Benefits $ 206,827 $ 1,444 $ 225 $ - $ 403 $ 241 $ - $ - $ - $ 851 $ - $ - $ - $ 3,165 $ 209,992 Other Charges $ 74,996 - - - - 561 - - - - - - - - $ 74,996 Total $ 281,824 $ 1,444 $ 225 $ - $ 403 $ 802 $ - $ - $ - $ 851 $ - $ - $ - $ 3,165 $ 284,988 OM083 - Refinery Recycled Water Exchange Prior years Project expended Expenditure type through 17-18 Jul. '18 Aug. '18 Sept. '18 Oct. '18 Nov. '18 Dec. '18 Jan. '19 Feb. '19 Mar. '19 Apr. '19 May '19 Jun. '19 2018-19 YTD to date Salary& Benefits $ 23,648 $ 2,746 $ 1,540 $ 2,411 $ 2,324 $ 1,549 $ 4,069 $ 3,391 $ 6,368 $ 10,037 $ - $ - $ - $ 34,436 $ 58,084 other Charges $ - - - - - - - - - - $ - $ - Total $ 23,648 1 $ 2,746 $ 1,540 $ 2,411 $ 2,324 $ 1,549 $ 4,069 $ 3,391 $ 6,368 $ 10,037 $ - $ - $ - $ 34,4361 $ 58,084 n-._:i nn nnnn ri__..i_._ rIKI nninn_ n-- M--I,_a ri_-_ - _t A- Page 25 of 41 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS MARCH,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) $11,500,000 $13,500,000 ($2,000,000) $11,500,000 $11,559,820 23.23% $26,305.21 $153,355.94 $179,661.15 933 US Gov't Agency Dscnt 06/08/18 05/28/19 59 2.32 4,956,560 5,000,000 5,000,000 4,991,600 10.10% 3,804 29,692 33,496 936 Toyota Motor CP 09/06/18 03/04/19 0 2.43 3,952,267 4,000,000 (4,000,000) 0 0 0.00% 800 46,933 47,733 937 FHLB Fed Agency 09/06/18 03/06/19 0 2.30 4,943,689 5,000,000 (5,000,000) 0 0 0.00% 1,556 54,756 56,311 938 FHLMC FHLMC 12/06/18 6/03/19 63 2.57 4,937,847 5,000,000 5,000,000 4,978,850 10.10% 10,764 29,514 40,278 938A FHLB Fed Agency 12/21/18 3/20/19 0 2.45 4,970,333 5,000,000 (5,000,000) 0 0 0.00% 6,333 23,333 29,667 939 FHLB Fed Agency 12/21/18 04/02/19 1 2.48 4,965,646 5,000,000 5,000,000 4,999,650 10.10% 10,441 23,576 34,017 940 US Gov't T-Bill 12/21/18 06/20/19 80 2.52 4,938,284 5,000,000 5,000,000 4,973,750 10.10% 10,570 23,868 34,438 941 US Gov't T-Bill 2/28/19 8/29/19 150 2.49 3,950,860 4,000,000 4,000,000 3,960,720 8.08% 8,370 270 8,640 942 US Gov't T-Bill 3/4/19 8/29/19 150 2.50 3,951,742 4,000,000 4,000,000 3,960,720 8.08% 7,591 0 7,591 943 FHLMC Fed Agency 3/06/19 6/12/19 72 2.46 4,967,197 5,000,000 5,000,000 4,975,800 10.10% 8,703 0 8,703 944 T-Bill US Tbill 3/21/19 9/19/19 171 2.50 4,938,575 5,000,000 5,000,000 4,943,700 10.10% 3,713 0 3,713 0 0 (4) $62,973,000 $51,500,000 ($2,000,000) $49,500,000 $49,344,610 100.00% 98,950 385,299 484,248 (3) (5) 5,729 199,669 205,398 $104,679 $584,968 $689,646 NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of March 2019 was 2.440%. (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.4654%. (4) The market value of the portfolio on March 31,2019 was$49,344,610. 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. April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 92 of 156 Page 26 of 41 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:002-SEWER CONSTRUCTION(Capital) March 2019 Fiscal Period 9/2019 Summarized by Account Report Generated on Apr 10,2019 9:21:32 AM TOTAL ASSETS Current Assets CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003 CASH ACCOUNTS/CASH $1,407,511 CASH ACCOUNTS/TEMPORARY INVESTMENTS $49,500,000 DUE FROM/DUE FROM DEBT FUND $3,685,382 DUE FROM/DUE FROM RIE $23,610,448 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $68,601 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $102,584 RECEIVABLE ACCOUNTS/CAD RECEIVABLE $162,781 Current Assets $79,357,310 Net Property,Plant and Equipment FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $26,049,058 Net Property,Plant and Equipment $26,049,058 TOTAL ASSETS $105,406,368 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE $0 CURRENT LIABILITIES/ACCOUNTS PAYABLE ($73,585) CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($1,432,249) CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($290,149) DUE TO/DUE TO DEBT FUND ($67,318) DUE TO/DUE TO RIE ($33,128,906) LIABILITIES/UNEARNED INTEREST ($219,463) Total Liabilities ($35,211,670) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($26,049,058) FUND EQUITY/AVAILABLE FUND BALANCE ($41,006,302) FUND EQUITY/EXPENDITURE SUMMARY $26,049,058 YEAR TO DATE REVENUES/REVENUE SUMMARY ($29,188,396) Total Fund Equity ($70,194,697) TOTAL LIABILITIES AND FUND EQUITY ($105,406,368) Page 27 of 41 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE March 2019 Fiscal Period 9/2019 Report Generated on Apr 10, 2019 9:25:27 AM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $9,645 $14,921 54.7% $866,305 $907,319 4.7% $960,250 552,931 94.5% Total Revenue $866,305 $907,319 Page 28 of 41 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM $30,000 ❑Period Budget $1,000,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $25,000 $800,000- $20,000- $600,000- $15,000-,// 800,000$20,000 $600,000$15,000 ' $400,000- $10,000-1/ 400,000$10,000 ' $200,000- $5,000-// $0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $29,540 $14,122 $15,418 $835,860 $736,305 $99,555 Totals $29,540 $14,122 $15,418 $835,860 $736,305 $99,555 Page 29 of 41 j&V ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM Department: Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget INSURANCE&OTHER EXP $791 $956 ($165) -20.8% $577,119 $604,038 ($26,919) -4.7% $579,500 104.2% GENERAL&AUTO LIABILITY $28,749 $13,166 $15,583 54.2% $258,741 $132,267 $126,474 48.9% $345,000 38.3% EMP RELATED&POLLUTION $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% Total Expenses $29,540 $14,122 $15,418 52.2% $835,860 $736,305 $99,555 11.9% $924,500 79.6% Color Key: 0 to 10%over budget > 10%over budget M Page 30 of 41 CENTRAL CONTRA COSTA SANITARY DISTRICT SELF-INSURANCE FUND TEMPORARY INVESTMENTS MARCH,2019 INVESTMENTS (cents omitted) INTEREST INCOME DATE OF Days to ANNUAL CASH B.O.M. PURCHASE E.O.M. E.O.M %of CURRENT B.O.M. E.O.M. NO. ISSUER TYPE PURCHASE MATURITY Maturity YIELD OUTLAY FACE VALUE (MATURITY) FACE VALUE MKT VALUE Portfolio MONTH CUMULATIVE CUMULATIVE 519 State of Calif. LAW 10/99- ------- 1 (1) $7,200,000 $7,200,000 $0 $7,200,000 $7,237,452 100.00% $14,921 $101,979 $116,899 (3) $7,200,000 $7,200,000 $0 $7,200,000 $7,237,452 100.00% 14,921 101,979 116,899 (2) 5,943 5,943 $14,921 $107,921 $122,842 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of March,2019 was 2.440%. (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.440%. (4) The market value of the portfolio on March 31,2019 was$7,237,452. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 97 of 156 Page 31 of 41 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:003-SELF-INSURANCE March 2019 Fiscal Period 9/2019 Summarized by Account Report Generated on Apr 10,2019 9:21:32 AM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $99,215 CASH ACCOUNTS/TEMPORARY INVESTMENTS $7,200,000 DUE FROM/DUE FROM R/E $783,408 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $42,553 Current Assets $8,125,176 TOTAL ASSETS $8,125,176 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/ACCOUNTS PAYABLE ($3,784) CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($882,230) DUE TO/DUE TO R/E ($788,100) Total Liabilities ($1,674,114) Total Fund Equity FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000) FUND EQUITY/EXPENDITURE SUMMARY $736,305 FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,280,047) YEAR TO DATE REVENUES/REVENUE SUMMARY ($907,319) Total Fund Equity ($6,451,062) TOTAL LIABILITIES AND FUND EQUITY ($8,125,176) Page 32 of 41 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004-DEBT SERVICE March 2019 Fiscal Period 9/2019 Report Generated on Apr 10, 2019 9:25:27 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°% $3,528,591 $3,531,028 0.1% $3,611,037 580,009 97.8% Total Revenue 0.0% $3,528,591 $3,531,028 0.1% $3,611,037 Page 33 of 41 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM $5,000 ❑Period Budget $1,000,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $4,000 $800,000- $3,000- $600,000- $2,000- $400,000- $1,000- $200,000- $0- $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $4,742 $0 $4,742 $764,278 $868,491 ($104,213) Totals $4,742 $0 $4,742 $764,278 $868,491 ($104,213) Page 34 of 41 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004-DEBT SERVICE March 2019 Fiscal Period 09/2019 Report Generated on Apr 10, 2019 9:29:02 AM Department: Category Period Budget Period Actual Period Variance % YTD Budget YTID Actual YTD Variance % Annual % Budget INTEREST EXPENSE $4,742 $0 $4,742 100.0% $764,278 $868,491 ($104,213) $1,135,780 76.5% Total Expenses $4,742 $0 $4,742 100.0% $764,278 $868,491 ($104,213) -13.6% $1,135,780 76.5% Total Expenses $8,490,235 $8,190,278 $299,957 3.5% $68,538,773 $66,191,978 $2,346,795 3.4% $91,780,736 72.1% Color Key: 0 to 10%over budget > 10%over budget M Page 35 of 41 ' Central Contra Costa Sanitary District Protecting public health and the environment Balance Sheet Fund:004-DEBT SERVICE March 2019 Fiscal Period 9/2019 Summarized by Account Report Generated on Apr 10,2019 9:21:32 AM TOTAL ASSETS Current Assets DUE FROM/DUE FROM RIE $3,528,591 DUE FROM/DUE FROM S/C $67,318 L.T.DEBT ACCOUNTING/DEPOSIT W/TRUSTEE-RESERVE $0 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $99,384 Current Assets $3,695,292 TOTAL ASSETS $3,695,292 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities DUE TO/DUE TO S/C ($3,685,382) L.T.DEBT ACCOUNTING/BOND ACR INTEREST PAYABLE $0 L.T.DEBT ACCOUNTING/BONDS PAYABLE ($19,450,000) Total Liabilities ($23,135,382) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $24,673,496 FUND EQUITY/EXPENDITURE SUMMARY $868,491 LIABILITIES/DEFERRAL-BOND REFUNDING ($2,570,870) YEAR TO DATE REVENUES/REVENUE SUMMARY ($3,531,028) Total Fund Equity $19,440,090 TOTAL LIABILITIES AND FUND EQUITY ($3,695,292) Page 36 of 41 DASHBOARD DATA (SELECTED DATA ON MATTERS OF CONTINUING BOARD INTEREST) April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 103 of 156 Page 37 of 41 PENSION AND OPEB LIABILITY AND FUNDING STATUS Pension OPEB $160 100% $90 100% $140 90% $80 90% $120 80% $70 80% 70% $60 70% $100 60% $50 60% $80 50% 50% $60 40% $40 40% 30% $30 30% $40 20% $20 20% $20 10% $10 10% $0 0% $0 0% 2012 2013 2014 2015 2016 2017 2018 2019 2012 2013 2014 2015 2016 2017 2018 2019 �UAAL —Funded% �UAAL —Funded% Notes: * Pension: 2018 valuation is released summer of 2019. ** OPEB-Valuations projected liabilities less assets as of June 30 of that year *** Pension funded percentage excludes Section 115 Trust Assets (established in FY 2017-18). April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 104 of 156 Page 38 of 41 CIB TRANSFERS SINCE FY 2016=17 Cause for Transfers Past Three Years Total Original Project Budgets and Transfers #of (FY2016-17 to FY2018-19 to 3/31) transfers Past Three Years s �N016-17 to FY2018-19 to 3 f 31� $30r0oof000 5 $251000,000 3 $20rOW rW0 2 $15,000,000 1 $10,Oo0rao0 F.Cost exceeded initial budget o AW E.New project scope D.NewProject OOOr000 C.Developer/CAU or other cost neutral ■ c ■ o ■ � ■ v ■ a ■v = o m o 0 3 o 0.Cashflow accelerations A.Bundling Notes: *There were no additional project transfers from the initial transfer report presented at the January 15, 2019 Board workshop through March 31, 2019 April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 105 of 156 Page 39 of 41 CIB TRANSFERS-CU RRENT YEAR Cause for Transfers Total Original Project Budgets and Transfers Current Year Only-FY2018-19 to 3/31 Current Year Only-FY2018-19 to 3/31 #of transfers 8 7 6 53100c,acc 5 $2500,aCC 52,aa0,aaa 3 2 $15001000 1 �iXo,aaa F.Cost exceeded initial hud.;et o AW E.New project scope h D.New Project • _ X30 • � • � 300000 AW v v C.developer/CAD or Other cost neutral m m7 CL o z a h B.Ctl5il�illW JLL�ief ilJ[Jfl LL a A Bundling � o Notes: *There were no additional project transfers from the initial transfer report presented at the January 15, 2019 Board workshop through March 31, 2019 April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 106 of 156 Page 40 of 41 FY 2018-19 Running Expense Fund Total Cash & Investment Balances (Actuals through March 2019) $52.5 $50.0 $46.7 $43.7 $44.3 $40.3 $42.5 , $ao.2 $40.9 $40.0 _ $37.1 $33.9 $37.3 $31.5 $31.9 $30.0 $29.6 $25.6 $26 7 $za.z $21.9 $20.6 $20.5 $19.4 $20.0 $15.3 $13.5 $10.0 $0.0 e `p `a Je�`a �o MProjected Balance* MActual Balance Reserve Target at Year End** NOTES: * Projected balances were generated in June 2018 based on budgeted revenues and expenses for FY 2018-19 and applied to the actual balance at June 30,2018 **The Reserve Target at Year End is the minimum balance required at June 30,2019 to comply with the District Fiscal Reserve Policy April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 107 of 156 Page 41 of 41 FY 2018-19 Sewer Construction Fund Total Cash & Investment Balances (Actuals through March 2019) $60.0 $59.1 $54.0 $53.6 $54.9 $53.0 $51.3 $51.8 $50.9 $49.8 $50.0 $47.9 $44.1 $40.4 $40.0 $37.3 $36.4 $37.9 $34.3 $35.7 $31.6 $33.0 $32.4 $31.1 $30.0 $29.1$22.7 $30.0 $30.4 $20.0 $10.0 $0.0 MProjected Balance* MActual Balance Reserve Target at Year End** NOTES: * Projected balances were generated in June 2018 based on budgeted revenues and expenses for FY 2018-19 and applied to the actual balance at June 30,2018 **The Reserve Target at Year End is the minimum balance required at June 30,2019 to comply with the District Fiscal Reserve Policy April 23, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 108 of 156