Loading...
HomeMy WebLinkAbout03.b. Review April 2019 Financial Statements and Investment Reports Page 1 of 43 Item 3.b. CENTRAL SAN May 21, 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 APRIL 2019 FINANCIAL STATEMENTS AND INVESTMENT REPORTS Attached for review are the Financial Statements and Investment Reports as of the date shown above. Strategic Plan Tie-In GOAL THREE: Be a Fiscally Sound and Effective Water Sector Utility Strategy 2- Manage costs ATTACHMENTS: 1. April 2019 Financial Statements and Investment Reports May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 48 of 399 PLQTRAL ( QTR4ZTA SANITARY DISTRICT May 9,2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS GT FROM: AMAL LYON SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through period ending April 30, 2019 YTD Fav/(Unfav) Variance O&M Revenues: Budgeted Actual Variance Explanation First installment received was higher than budgeted. Percentage received varies Total $68,555,500 $ 70,600,398 $2,044,898 annually. O&M Expenses: Total Labor Charges $43,495,020 $ 42,873,659 $ 621,361 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,194,837 1,053,028 141,809 Chemicals are purchased sporadically throughout the year rather than monthly as is budgeted. The variance should be reduced by year-end. Utilities 3,193,195 3,265,311 (72,116) Higher than budget due to high PG&E bills Repairs&Maintenance 4,421,031 3,621,235 799,796 Lower due to budget spread over 12 months versus actual expense occurring sporadically throughout the year. Professional&Legal Services 703,510 549,565 153,945 Due to delay in legal and professional invoices. Outside Services 2,957,370 2,163,768 793,602 Mainly due to Technical Services expense being lower than budgeted thus far in the fiscal year. Other Expenses 2,450,431 1,963,308 487,123 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 12,510,694 11,733,676 777,018 Variance due to UAAL vacancy. Budgeted vacancy is lower than actual vacancies thus far in the fiscal year. This variance should be reduced by year-end All Other 3,478,000 3,436,256 41,744 Minor variances for multiple account categories. Total $74,404,088 $ 70,659,806 $3,744,282 May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 49 of 399 Page 2 of 42 J&V lics entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 001 - RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 2:00:10 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $0 $0 0.0% $0 $0 0.0% $14,800,000 $14,800,000 0.0% HHW $8,000 $4,703 -41.2% $90,000 $79,268 -11.9% $929,000 $849,732 8.5% Other $366,664 $575,792 57.0% $3,394,340 $4,157,973 22.5% $4,123,000 ($34,973) 100.8% Sewer Service Charges $30,912,916 $26,529,010 -14.2% $65,071,160 $66,363,158 2.0% $67,073,732 $710,574 98.9% Total Revenue $31,287,580 $27,109,505 -13.4% $68,555,500 $70,600,398 3.0% $86,925,732 $16,325,334 81.2% Page 3 of 42 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE (O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9,2019 1:55:05 PM $80,000,000.00 —Budget —Actual $70,000,000.00 404,088 $66,9359,806 $60,000,000.00 $58,48 64,587,182 $51,37 411,026 $50,000,000.00 $44,52 ,586,006 $40,000,000.00 42,592,870 $30,000,000.00 $30,22 666,108 $23,12 064,083 $20,000,000.00 $16, 222 989,00 $10,000,000.00 $8,838 $8,238,746 $0.00 Jul(1)2018 Aug(2)2018 Sep(3)2018 Oct(4)2018 Nov(5)2018 Dec(6)2018 Jan(7)2019 Feb(8)2019 Mar(9)2019 Apr(10)2019 Fiscal Periods Page 4 of 42 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:55:05 PM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $2,964,217 $2,921,048 $43,169 1.5% $29,642,170 $29,131,269 $510,901 1.7% $35,571,037 81.9% EMPLOYEE BENEFITS $1,686,321 $1,681,012 $5,309 0.3% $17,169,210 $17,019,977 $149,233 0.9% $20,993,695 81.1% CAPITALIZED ADM OVERHEAD ($331,636) ($378,484) $46,848 -14.1% ($3,316,360) ($3,277,587) ($38,773) 1.2% ($3,979,723) 82.4% DIRECTOR FEES&EXPENSES $14,041 $11,179 $2,862 20.4% $140,410 $129,428 $10,982 7.8% $168,494 76.8% CHEMICALS $121,547 $118,913 $2,634 2.2% $1,194,837 $1,053,028 $141,809 11.9% $1,459,000 72.2% UTILITIES $345,206 $363,396 ($18,190) -5.3% $3,193,195 $3,265,311 ($72,116) -2.3% $4,142,550 78.8% REPAIRS&MAINTENANCE $447,431 $327,093 $120,338 26.9% $4,421,031 $3,621,235 $799,796 18.1% $5,414,644 66.9% HAULING&DISPOSAL $131,867 $85,505 $46,362 35.2% $828,670 $741,999 $86,671 10.5% $1,126,475 65.9% PROFESSIONAL&LEGAL SERV $69,601 $31,789 $37,812 54.3% $703,510 $549,565 $153,945 21.9% $845,300 65.0% OUTSIDE SERVICES $265,726 $253,134 $12,592 4.7% $2,957,370 $2,163,768 $793,602 26.8% $3,510,822 61.6% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $779,500 $779,505 ($5) 0.0% $779,500 100.0% MATERIALS&SUPPLIES $175,642 $173,509 $2,133 1.2% $1,729,420 $1,785,322 ($55,902) -3.2% $2,108,126 84.7% OTHER EXPENSES $132,134 $100,014 $32,120 24.3% $2,450,431 $1,963,308 $487,123 19.9% $2,777,258 70.7% UNFUNDED LIABILITIES $1,443,356 $384,517 $1,058,839 73.4% $12,510,694 $11,733,679 $777,015 6.2% $14,803,278 79.3% Total Expenses $7,465,453 $6,072,624 $1,392,829 18.7% $74,404,088 $70,659,806 $3,744,282 5.0% $89,720,456 78.8% Color Key: 0 to 10%over budget > 10%over budget M Page 5 of 42 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE (O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM $2,500,000 ❑Period Budget $25,000,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $2,000,000 $20,000,000- $1,500,000- $15,000,000 $1,000,000 $10,000,000- $500,000- $5,000,000 $o �G� oo���G�\ Q���°e�Q��e 5�p��o �p� Po��05'\ o��`��` o�\oQ���oQ� Period Budget Period Actual Period Variance YTD Budget YTD Actual Y]$3,744,282 e ADMINISTRATION $2,348,015 $1,065,574 $1,282,441 $23,138,513 $20,080,869 4 ENGINEERING $1,407,715 $1,320,231 $87,484 $14,179,509 $13,668,45752 COLLECTION SYSTEM OPS. $1,162,280 $1,154,458 $7,822 $11,519,301 $11,600,1432) PLANT OPERATIONS $2,173,526 $2,203,753 ($30,227) $21,899,127 $22,003,331 4) PUMP STATIONS $244,538 $241,308 $3,230 $2,386,514 $2,334,56252 RECYCLED WATER $129,379 $87,300 $42,079 $1,281,124 $972,44480 Totals $7,465,453 $6,072,624 $1,392,829 $74,404,088 $70,659,806 2 Page 6 of 42 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM Department: ADMINISTRATION or- Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual Budget SALARIES&WAGES $611,365 $553,136 $58,229 9.5% $6,113,650 $5,640,131 $473,519 7.7% $7,336,515 76.9% EMPLOYEE BENEFITS $652,688 $603,376 $49,312 7.6% $6,832,880 $6,454,563 $378,317 5.5% $8,588,771 75.2% CAPITALIZED ADM OVERHEAD ($4,147) ($870) ($3,277) 79.0% ($41,470) ($24,425) ($17,045) 41.1% ($49,764) 49.1% DIRECTOR FEES&EXPENSES $14,041 $11,179 $2,862 20.4% $140,410 $129,428 $10,982 7.8% $168,494 76.8% UTILITIES $10,816 $13,212 ($2,396) -22.2% $108,160 $112,530 ($4,370) -4.0% $129,800 86.7% REPAIRS&MAINTENANCE $90,592 $21,835 $68,757 75.9% $951,140 $606,644 $344,496 36.2% $1,132,390 53.6% PROFESSIONAL&LEGAL SERV $53,271 $29,000 $24,272 45.6% $540,210 $437,084 $103,126 19.1% $649,300 67.3% OUTSIDE SERVICES $119,355 $140,138 ($20,783) -17.4% $1,399,384 $942,924 $456,460 32.6% $1,647,300 57.2% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $779,500 $779,505 ($5) 0.0% $779,500 100.0% MATERIALS&SUPPLIES $16,329 $12,059 $4,270 26.2% $163,290 $105,357 $57,933 35.5% $196,025 53.7% OTHER EXPENSES $57,336 $54,120 $3,216 5.6% $810,535 $681,526 $129,009 15.9% $960,040 71.0% UNFUNDED LIABILITIES $726,369 ($371,612) $1,097,981 151.2% $5,340,824 $4,215,602 $1,125,222 21.1% $6,199,286 68.0% ADMINISTRATION Total Expenses $2,348,015 $1,065,574 $1,282,441 54.6% $23,138,513 $20,080,869 $3,057,644 13.2% $27,737,657 72.4% Color Key: 0 to 10%over budget > 10%over budget M Page 7 of 42 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM Department: ENGINEERING Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $833,166 $869,458 ($36,292) -4.4% $8,331,660 $8,343,158 ($11,498) -0.1% $9,998,042 83.4% EMPLOYEE BENEFITS $329,253 $355,965 ($26,712) -8.1% $3,292,530 $3,440,063 ($147,533) -4.5% $3,951,391 87.1% CAPITALIZED ADM OVERHEAD ($296,790) ($350,842) $54,052 -18.2% ($2,967,900) ($2,968,248) $348 0.0% ($3,561,499) 83.3% UTILITIES $14,432 $14,037 $395 2.7% $144,320 $153,797 ($9,477) -6.6% $173,200 88.8% REPAIRS&MAINTENANCE $14,281 $10,179 $4,102 28.7% $142,810 $73,435 $69,375 48.6% $171,400 42.8% HAULING&DISPOSAL $82,867 $47,414 $35,453 42.8% $338,670 $338,717 ($47) 0.0% $538,425 62.9% PROFESSIONAL&LEGAL SERV $14,248 $2,671 $11,577 81.3% $142,480 $89,712 $52,769 37.0% $171,000 52.5% OUTSIDE SERVICES $96,931 $39,299 $57,632 59.5% $1,076,252 $692,633 $383,619 35.6% $1,270,142 54.5% MATERIALS&SUPPLIES $32,915 $38,065 ($5,150) -15.6% $329,150 $276,831 $52,319 15.9% $395,050 70.1% OTHER EXPENSES $22,962 $14,899 $8,063 35.1% $715,037 $472,849 $242,188 33.9% $764,812 61.8% UNFUNDED LIABILITIES $263,450 $279,084 ($15,634) -5.9% $2,634,500 $2,755,511 ($121,011) -4.6% $3,161,443 87.2% ENGINEERING Total Expenses $1,407,715 $1,320,231 $87,484 6.2% $14,179,509 $13,668,457 $511,052 3.6% $17,033,406 80.2% Color Key: 0 to 10%over budget > 10%over budget M Page 8of42 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM Department: COLLECTION SYSTEM OPS. Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $522,693 $534,634 ($11,941) -2.3% $5,226,930 $5,316,902 ($89,972) -1.7% $6,272,384 84.8% EMPLOYEE BENEFITS $255,254 $261,213 ($5,959) -2.3% $2,552,540 $2,606,267 ($53,727) -2.1% $3,063,394 85.1% CAPITALIZED ADM OVERHEAD ($2,676) $0 ($2,676) 100.0% ($26,760) ($28,361) $1,601 -6.0% ($32,120) 88.3% UTILITIES $12,115 $13,431 ($1,316) -10.9% $121,150 $121,428 ($278) -0.2% $145,400 83.5% REPAIRS&MAINTENANCE $122,873 $101,393 $21,480 17.5% $1,130,231 $980,387 $149,844 13.3% $1,474,504 66.5% HAULING&DISPOSAL $10,916 $6,137 $4,779 43.8% $109,160 $59,477 $49,683 45.5% $131,000 45.4% PROFESSIONAL&LEGAL SERV $625 $59 $566 90.5% $6,250 $1,791 $4,459 71.3% $7,500 23.9% OUTSIDE SERVICES $4,972 $9,683 ($4,711) -94.8% $49,720 $56,207 ($6,487) 1'. $59,680 94.2% MATERIALS&SUPPLIES $63,074 $48,348 $14,726 23.3% $613,740 $690,687 ($76,947) $756,951 91.2% OTHER EXPENSES $10,529 $11,208 ($679) -6.4% $117,290 $107,770 $9,520 8.1% $138,445 77.8% UNFUNDED LIABILITIES $161,905 $168,353 ($6,448) -4.0% $1,619,050 $1,687,587 ($68,537) -4.2% $1,942,922 86.9% COLLECTION SYSTEM OPS.Total $1,162,280 $1,154,458 $7,822 0.7% $11,519,301 $11,600,143 ($80,842) -0.7% $13,960,060 83.1% Expenses Color Key: 0 to 10%over budget > 10%over budget Page 9of42 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM Department: PLANT OPERATIONS Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $869,326 $845,407 $23,919 2.8% $8,693,260 $8,623,806 $69,454 0.8% $10,432,017 82.7% EMPLOYEE BENEFITS $380,506 $394,571 ($14,065) -3.7% $3,805,060 $3,888,971 ($83,911) -2.2% $4,566,639 85.2% CAPITALIZED ADM OVERHEAD ($28,023) ($26,772) ($1,251) 4.5% ($280,230) ($256,553) ($23,677) 8.4% ($336,340) 76.3% CHEMICALS $93,715 $115,809 ($22,094) -23.6% $937,350 $922,668 $14,682 1.6% $1,125,000 82.0% UTILITIES $250,215 $255,609 ($5,394) -2.2% $2,281,318 $2,358,133 ($76,815) -3.4% $3,002,600 78.5% REPAIRS&MAINTENANCE $186,609 $182,872 $3,737 2.0% $1,866,090 $1,707,013 $159,077 8.5% $2,239,400 76.2% HAULING&DISPOSAL $37,351 $30,958 $6,393 17.1% $373,510 $334,907 $38,603 10.3% $448,250 74.7% PROFESSIONAL&LEGAL SERV $291 $59 $232 79.6% $2,910 $1,932 $978 33.6% $3,500 55.2% OUTSIDE SERVICES $19,912 $32,266 ($12,354) -62.0% $199,120 $288,321 ($89,201) $239,000 120.6% MATERIALS&SUPPLIES $58,871 $73,972 ($15,101) -25.7% $578,710 $685,679 ($106,969) $706,600 97.0% OTHER EXPENSES $35,534 $17,583 $17,951 50.5% $749,839 $654,668 $95,171 12.7% $844,615 77.5% UNFUNDED LIABILITIES $269,219 $281,419 ($12,200) -4.5% $2,692,190 $2,793,786 ($101,596) -3.8% $3,230,674 86.5% PLANT OPERATIONS Total Expenses $2,173,526 $2,203,753 ($30,227) -1.4% $21,899,127 $22,003,331 ($104,204) -0.5% $26,501,955 83.0% Color Key: 0 to 10%over budget > 10%over budget M Page 10 of 42 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) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM Department: PUMP STATIONS Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $80,539 $82,194 ($1,655) -2.1% $805,390 $842,554 ($37,164) -4.6% $966,479 87.2% EMPLOYEE BENEFITS $33,186 $40,256 ($7,070) -21.3% $331,860 $377,379 ($45,519) M $398,256 94.8% CAPITALIZED ADM OVERHEAD $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% CHEMICALS $20,833 $0 $20,833 100.0% $187,497 $61,841 $125,656 67.0% $250,000 24.7% UTILITIES $43,045 $48,655 ($5,610) -13.0% $392,417 $438,186 ($45,769) = $516,550 84.8% REPAIRS&MAINTENANCE $30,661 $10,813 $19,848 64.7% $306,610 $242,811 $63,799 20.8% $367,950 66.0% HAULING&DISPOSAL $733 $996 ($263) -35.8% $7,330 $8,898 ($1,568) = $8,800 101.1% OUTSIDE SERVICES $6,683 $28,746 ($22,063) -330.1% $66,830 $42,196 $24,634 36.9% $80,200 52.6% MATERIALS&SUPPLIES $3,466 $1,055 $2,411 69.5% $34,660 $19,612 $15,048 43.4% $41,600 47.1% OTHER EXPENSES $2,979 $1,320 $1,659 55.7% $29,790 $19,892 $9,898 33.2% $35,796 55.6% UNFUNDED LIABILITIES $22,413 $27,273 ($4,860) -21.7% $224,130 $281,193 ($57,063) = $268,953 104.6% PUMP STATIONS Total Expenses $244,538 $241,308 $3,230 1.3% $2,386,514 $2,334,562 $51,952 2.2% $2,934,584 79.6% Color Key: 0 to 10%over budget > 10%over budget M Page 11 of 42 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM Department: RECYCLED WATER Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $47,128 $36,219 $10,909 23.1% $471,280 $364,717 $106,563 22.6% $565,600 64.5% EMPLOYEE BENEFITS $35,434 $25,630 $9,804 27.7% $354,340 $252,735 $101,605 28.7% $425,244 59.4% CHEMICALS $6,999 $3,104 $3,895 55.7% $69,990 $68,520 $1,470 2.1% $84,000 81.6% UTILITIES $14,583 $18,452 ($3,869) -26.5% $145,830 $81,237 $64,593 44.3% $175,000 46.4% REPAIRS&MAINTENANCE $2,415 $0 $2,415 100.0% $24,150 $10,944 $13,206 54.7% $29,000 37.7% PROFESSIONAL&LEGAL SERV $1,166 $0 $1,166 100.0% $11,660 $19,047 ($7,387) = $14,000 136.1% OUTSIDE SERVICES $17,873 $3,001 $14,872 83.2% $166,064 $141,488 $24,576 14.8% $214,500 66.0% MATERIALS&SUPPLIES $987 $10 $977 99.0% $9,870 $7,155 $2,715 27.5% $11,900 60.1% OTHER EXPENSES $2,794 $883 $1,911 68.4% $27,940 $26,603 $1,337 4.8% $33,550 79.3% RECYCLED WATER Total Expenses $129,379 $87,300 $42,079 32.5% $1,281,124 $972,444 $308,680 24.1% $1,552,794 62.6% Color Key: 0 to 10%over budget > 10%over budget M Page 12 of 42 CENTRAL CONTRA COSTA SANITARY DISTRICT RUNNING EXPENSE FUND TEMPORARY INVESTMENTS April,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) $26,000,000 $6,000,000 $20,000,000 $26,000,000 $26,144,105 56.52% $20,137 $221,030 $241,167 RE09 FHLB FED AGENCY 12/24/18 7/22/19 82 2.558% 4,927,375 5,000,000 5,000,000 4,972,550 10.87% 10,375 33,892 44,267 RE10 FHLB FED AGENCY 12/24/18 7/23/19 83 2.558% 4,927,029 5,000,000 5,000,000 4,972,200 10.87% 10,375 33,892 44,267 RE11 FHLMC FED AGENCY 3/4/19 7/23/19 83 2.443% 4,952,608 5,000,000 5,000,000 4,972,200 10.87% 10,083 9,411 19,494 RE12 FHLB FED AGENCY 3/22/19 7/23/19 83 2.410% 4,958,829 5,000,000 5,000,000 4,972,200 10.87% 10,042 3,347 13,389 (3) $45,765,842 $26,000,000 $20,000,000 $46,000,000 $46,033,255 100.00% 61,012 301,572 362,584 (2) 4,715 174,024 178,739 $65,727 475,596 541,323 NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of April,2019 was 2.45%. (2) The face value indicates the value of the investment if held until maturity,which is the usual District Practice. (3) The weighted average yield of the total Running Expense portfolio is 2.4684%. (4) The market value of the portfolio on April,2019 was$46,033,255. (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. May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 60 of 399 Page 13 of 42 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Summarized by Account Report Generated on May 9,2019 1:53:03 PM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $3,759,956 CASH ACCOUNTS/PAYROLL CLEARING $40,909 CASH ACCOUNTS/PETTY CASH $3,400 CASH ACCOUNTS/TEMPORARY INVESTMENTS $46,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 $52,360,239 DUE FROM/DUE FROM S/I $789,056 INVENTORY/SUPPLIES&MATERIAL INV $2,175,934 PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104 PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572 PREPAID ACCOUNTS/PREPAID EXPENSES $996,535 PREPAID ACCOUNTS/PREPAID INSURANCE $1,911 PREPAID ACCOUNTS/PREPAID RETIREMENT $4,234,454 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $109,270 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $270,804 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA $1,837 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $20,137 RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $11,387 RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $100,640 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $3,382 Current Assets $132,459,946 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 $784,862,288 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($4,165) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($2,428,249) CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($4,402,038) CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,214,671) Page 14 of 42 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) April 2019 Fiscal Period 10/2019 Summarized by Account Report Generated on May 9,2019 1:53:03 PM CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($24,488) CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($702) CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931) CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING ($7,579) CURRENT LIABILITIES/PERMIT CLEARING ($611) CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($41,080) CURRENT LIABILITIES/RETIREMENT CONTRIB W/H $2 CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $56,333 DEF.COMP.CONTRIB W/H/ICMA $0 DUE TO/DUE TO DEBT FUND ($3,528,591) DUE TO/DUE TO S/C ($41,992,463) DUE TO/DUE TO S/I ($783,408) LIABILITIES-LONG TERM/DEFERRED INFLOWS-GASB 68 ($28,076,634) LIABILITIES-LONG TERM/NET OPEB LIAB-GASB 75 ($46,350,454) LIABILITIES-LONG TERM/NET PENSION LIAB-GASB 68 ($63,806,000) LIABILITIES-LONG TERM/POST EMP.BENEFIT-PENSION $7,102,024 LIABILITIES/UNEARNED INTEREST ($112,742) MEDICAL LIABILITIES/DELTA DENTAL $551 MEDICAL LIABILITIES/DISABILITY INS $282 MEDICAL LIABILITIES/HEALTH NET $1,488 MEDICAL LIABILITIES/KAISER PERMANENTE $4,833 MEDICAL LIABILITIES/LIFE INS $87 MEDICAL LIABILITIES/OCCUPATIONAL HEALTH $2,094 MEDICAL LIABILITIES/POST EMP.BENEFIT-OPEB $0 PAYROLL TAXES WITHHELD/CALIFORNIA WITHHOLDING $368 PAYROLL TAXES WITHHELD FEDERAL WITHHOLDING $0 PAYROLL TAXES WITHHELD/MEDICARE WITHHOLDING ($1,838) REIMBURSEMENT FEES ($62,237) Total Liabilities ($185,809,816) 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 $70,659,806 FUND EQUITY/GENERAL FIXED ASSET GROUP ($210,549,556) FUND EQUITY/STATE&FED CAPITAL GRANT ($75,301,279) YEAR TO DATE REVENUES/REVENUE SUMMARY ($70,600,398) Total Fund Equity ($599,052,473) TOTAL LIABILITIES AND FUND EQUITY ($784,862,288) Page 15 of 42 CENTRAL CONTRA COSTA SANITARY DISTRICT May 9, 2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS &el FROM: AMAL LYON SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending April 30, 2019: YTD YTD Fav/(Unfav) S/C Revenues: Budgeted Actual Variance Explanation Property tax revenue received from the County was Total $ 44,196,810 $48,600,064 $ 4,403,254 higher than budgeted. FY YTD FY S/C Expenses: Budget* Actual Remaining % Spent Total $ 52,287,827 $29,617,412 $ 22,670,415 56.64% Includes 17/18 carry-over($6,968,827) May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 63 of 399 Page 16 of 42 AIMILSentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 002-SEWER CONSTRUCTION (Capital) April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 2:00:10 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Concord $0 $0 0.0% $0 $0 0.0% $7,150,000 $7,150,000 0.0% Other $6,625,581 $8,364,177 26.2% $17,108,810 $20,964,876 22.5% $20,813,000 ($151,876) 100.7% Sewer Service Charges $13,125,000 $11,047,491 -15.8% $27,088,000 $27,635,189 2.0% $27,926,268 $291,079 99.0% Total Revenue $19,750,581 $19,411,669 -1.7% $44,196,810 $48,600,064 10.0% $55,889,268 $7,289,204 87.0% Page 17 of 42 Sewer Fund (Capital) Spending FY 18-19 $40,000,000 $36,284,660 $35,000,000 $32,401,82 $29,197,153 $30,000,000 $23,890,698 $26,513,645 $29,617,412 $25,000,000 $19,397,124 $26,049,0 " $20,000,000 $23,808,150 $13,377,477 �1101379,"941 $20,736,779 $15,000,000 O $9,429,510 $14,503,936 $10,000,000 $3,996,336 $11,543,304 $5,000,000 $1,426,829 $8,485,345 $_ $3,404,835 July $1,600,939 August September October November December January February March Projected* Actual Columnl July August September October November December January February March April 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 $ 36,284,660 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 29,617,412 *Projected -Current year budget allocated by month based on historical spending in previous 2 years R A_.. n nnAn 1'l__...I_._ r 1 n l A K A__i1.__. A_._._J_ -__1__1 ___._ 11 _fn Page 18 of 42 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 4/30/2019 PERIOD 10/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 1,080,000 20,427,000 18,994,720 14,215,910 4,778,811 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 12,238,381 11,845,457 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,781,862 3,559,058 TYPE RW Recycled Water 2,382,894 1,769,035 613,859 2,857,000 - 2,857,000 3,470,859 1,381,259 2,089,594 CIB Contingency - - - 1,500,000 (1,102,500) 397,500 397,500 - 397,500 TOTAL DISTRICT 73,563,322 $ 66,594,495 $ 6,968,827 $ 45,319,000 $ - $ 45,319,000 $ 52,287,827 $ 29,617,412 $ 22,670,420 KAnit 71 OA Q DcniiInr MKIAnlrr: rnmmi++oc NAcc+inn Ancnrin Dnt,L,C+- Dnno AA of`200 Page 19 of 42 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 4/30/2019 PERIOD 10/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 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 53,313 223,244 ****6679 Coredell Drive CAD - - - - 123,443 123,443 123,443 54,906 68,537 **7367 Concord Main Metering Station - - - - 250,000 250,000 250,000 15,580 234,420 8249 CSO Dump Pad Modifications 60,000 - 60,000 - - 60,000 9,702 50,298 *8412 PH Grayson Creek Trunk 15,100,000 15,061,359 38,641 - - 38,641 194,439 (155,798) 8419 Collection System Planning LT 885,000 884,387 613 100,000 100,000 100,613 88,785 11,828 *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,577,593 76,690 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,652,066 6,812 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,461,189 1,147,795 8441 CIPP Contract 17-20 300,000 80,247 219,753 100,000 100,000 319,753 186,861 132,892 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 11,787 232,420 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,509,759 88,561 8446 Lafayette Sewer Renovation Phase 12 636,000 1,216,107 (580,107) 3,397,600 3,397,600 2,817,493 2,495,599 321,894 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 49,988 93,251 8450 Development Sewerage Support 400,000 240,770 159,230 250,000 480,000 730,000 889,230 830,823 58,407 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 362,043 137,957 *8453 Willows Sewer Repair 98,000 98,000 - - - - - - ***8454 So.Orinda Sewer Ren. Ph.7 - - - - 500,000 500,000 500,000 532,348 (32,348) ***8455 W.C.Sewer Renov. Ph. 13 - - - - 500,000 500,000 500,000 542,145 (42,145) ***8456 Danville Sewer Ren. Ph.3 - - - - 500,000 500,000 500,000 268,386 231,614 8457 Pump Station Upgrades-Ph.2 - - - 50,000 1 50,000 50,000 1 - 50,000 Rounding 1 Total FY 2018-19 CS Amount $ 29,409,417 30,841,697 (1,432,280) 19,347,000 1,080,000 20,427,000 18,994,720 14,215,910 4,778,811 *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 hAov )1 )oia Ron d- MKIAKI('G ('nmmiffoo NA-+i- Ano Ir D-L-+- Dino 97 of QQQ Page 20 of 42 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 4/30/2019 PERIOD 10/2019 A 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 39,361 496,728 7304 Instr&Controls PLC Upgrade 575,000 397,606 177,394 110,000 - 110,000 287,394 72,899 214,495 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,656 186,110 7320 Plant Energy Optimization 1,094,000 1,063,448 30,552 - - - 30,552 (58,867) 89,419 7322 Fire Protection System Ph.2 1,406,000 1,014,803 391,197 - - - 391,197 316,528 74,669 7326 Equipment Replacement FY 15-FY 24 1,166,000 748,217 417,783 250,000 - 250,000 667,783 784,378 (116,595) 7327 Headwork's Screening Upgrade 8,144,000 7,845,455 298,545 76,000 - 76,000 374,545 156,924 217,621 7328 Influent Pump Electrical improvements 100,000 757 99,243 510,000 - 510,000 609,243 252,885 356,358 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,543,781 122,275 7339 T. Plant Control System 1/0 Replacement 470,000 605,231 (135,231) 900,000 - 900,000 764,769 471,217 293,552 7341 WC/Grayson Creek Levee Rehab 100,000 - 100,000 - - - 100,000 58,110 41,890 7348 Solids Handling Facility Improvements 4,975,000 4,516,007 458,993 5,715,000 - 5,715,000 6,173,993 3,288,164 2,885,829 7349 Aeration& Energy Upgrade 300,000 35,539 264,461 1,200,000 - 1,200,000 1,464,461 375,132 1,089,329 7351 Mechanical&Concrete Renovation 1,300,000 1,254,155 45,845 3,000,000 - 3,000,000 3,045,845 1,226,296 1,819,549 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 18,993 81,007 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 8,823 29,995 7359 Solids Conditioning Bldg. roof replacement 500,000 189,377 310,623 800,000 - 800,000 1,110,623 898,083 212,540 7360 Existing Plant Facility Drawing 100,000 83,040 16,960 100,000 - 100,000 116,960 56,623 60,337 7362 POB Seismic Upgrades 400,000 135,591 264,409 1,100,000 1,831,177 2,931,177 3,195,586 1,160,439 2,035,147 7363 Treatment Plant Planning 450,000 348,907 101,093 450,000 - 450,000 551,093 302,396 248,697 7364 TP Safety Enhancement Ph.5 - - - 100,000 - 100,000 100,000 - 100,000 Rounding I I 9 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 12,238,381 11,845,457 *Italic Projects open but not in CIB for 18/19 RAw 7I 0010 Dcn.dnr GIAIAAIr`G r`nmmi+too KA--+i­ An An D-L-+- Don. PA of 4QQ Page 21 of 42 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 4/30/2019 PERIOD 10/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 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,291 36,304 8236 District Easements 208,047 164,616 43,431 50,000 - 50,000 93,431 50,259 43,172 8238 Asset Management 2,969,185 2,790,236 178,949 400,000 - 400,000 578,949 519,737 59,212 8240 IT Development 2,188,794 2,187,431 1,363 1,750,000 (450,000) 1,300,000 1,301,363 218,280 1,083,083 8243 Server Room Relocation 955,430 515,656 439,774 880,000 164,570 1,044,570 1,484,344 561,030 923,314 8247 Property&Building Improvements 400,000 178,767 221,233 300,000 (363,606) (63,606) 157,627 170,722 (13,095) 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 97,791 187,464 8517 Vehicle Replacement Program 1,199,000 603,959 595,041 650,000 - 650,000 1,245,041 140,441 1,104,600 9999 Capital Project Clearing(Accounting Use Only)** - (60,000) 60,000 - - - 60,000 (2) 60,002 Rounding 1 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,781,862 3,559,058 Un-01 7119 Q Dcni dnr�IAI AKV'P (`nmmi+too NAcc+inn 4ncnr+n Dnnlrc+- Dnn FQ of'2QQ Page 22 of 42 PROGRAM/GM1851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 4/30/2019 PERIOD 10/2019 A 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 15,293 32,617 7346 Surge Analysis 16-17 155,000 3,125 151,875 50,000 - 50,000 201,875 136,277 65,598 7361 Filter Plant Improvments 330,000 162,293 167,707 2,457,000 - 2,457,000 2,624,707 1,000,245 1,624,462 7365 Recycle Water Clearwell Repairs 1,400,000 1,118,633 281,367 300,000 - 300,000 581,367 229,444 351,923 7366 ReW Distribution System Renov. Program - - - 15,000 - 15,000 15,000 - 15,000 Rounding I I I I I 1 (6) Total FY 2016-17 RW Amount $ 2,382,894 1,769,035 613,859 2,857,000 - 2,857,000 3,470,859 1,381,259 2,089,594 9990 CONTINGENCY-ALL PROGRAMS - - - 1,500,000 (1,102,500) 397,500 397,500 397,500 GRAND TOTAL $ 73,563,322 66,594,495 6,968,827 45,319,000 - 45,319,000 52,287,827 29,617,412 22,670,420 KAw `)1 0010 Qn-l- MNIAnI(' ('nmmi#foo KAoofi- A-An D-L-+- D-n- 7n of QQQ Page 23 of 42 FY 18-19 CAPITAL BUDGET TRANSFERS PERIOD ENDING:3/31/19 Position Paper Position Memo to GM Position Paper Position Paper approved 10/4/19 item 2 11/15 Item 10 11/1 item 7 & Paper 12/20 Deputy GM 09/05/18 & Deputy GM &GM 12/12 GM 12/19 item 7 &GM signature 04/19 18/19 Contingency signature 1/08/19 PROJ.# 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) 8450 Development Sewerage - - - - - 480,000 480,000 9990 Capital Projects-Contingency - - - (622,500) - (480,000) (1,102,500) 397,500 tal - - * Not actual transfers. All part of one project split into individual projects for construction May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 71 of 399 Page 24 of 42 O&M PROJECTS- EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 04/30/19 10/2019 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 43 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. 118 Nov. '18 Dec. '18 Jan. '19 Feb. '19 Mar. '19 Apr. '19 May'19 Jun. '19 2018-19 YTD to date Salary& Benefits $ 23,648 $ 2,746 $ 1,540 $ 2,411 $ 2,324 $ 1,549 $ 4,069 $ 3,391 $ 6,368 $ 10,037 $ 11,975 $ - $ - $ 46,411 $ 70,059 other Charges $ - - - - - - - - - - $ - $ - Total $ 23,648 1 $ 2,746 $ 1,540 $ 2,411 $ 2,324 $ 1,549 $ 4,069 $ 3,391 $ 6,368 $ 10,037 $ 11,975 $ - $ - $ 46,4111 $ 70,059 nn_.. nn nnnn M-- rine n K nn__i:.__ n__._r_ M__i._i M___ - -X- Page 25 of 42 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS April,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) $28,500,000 $11,500,000 $17,000,000 $28,500,000 $28,657,961 42.86% $30,004 $179,661 $209,665 933 US Gov't Agency Dscnt 06/08/18 05/28/19 29 2.32 4,956,560 5,000,000 5,000,000 4,996,250 7.52% 3,681 33,496 37,178 938 FHLMC FHLMC 12/06/18 6/03/19 33 2.57 4,937,847 5,000,000 5,000,000 4,988,950 7.52% 10,417 40,278 50,694 939 FHLB Fed Agency 12/21/18 04/02/19 0 2.48 4,965,646 5,000,000 (5,000,000) 0 0 0.00% 337 34,017 34,354 940 US Gov't T-Bill 12/21/18 06/20/19 110 2.52 4,938,284 5,000,000 5,000,000 4,983,450 7.52% 10,229 34,438 44,667 941 US Gov't T-Bill 2/28/19 8/29/19 120 2.49 3,950,860 4,000,000 4,000,000 3,968,520 6.02% 8,100 8,640 16,740 942 US Gov't T-Bill 3/4/19 8/29/19 120 2.50 3,951,742 4,000,000 4,000,000 3,968,520 6.02% 8,133 7,591 15,724 943 FHLMC Fed Agency 3/06/19 6/12/19 42 2.46 4,967,197 5,000,000 5,000,000 4,985,950 7.52% 10,042 8,703 18,744 944 T-Bill US Tbill 3/21/19 9/19/19 141 2.50 4,938,575 5,000,000 5,000,000 4,953,450 7.52% 10,125 3,713 13,838 945 FHLB Agency Gov 4/3/19 10/1/19 153 2.44 4,940,169 5,000,000 5,000,000 4,949,000 7.52% 9,256 0 9,256 (4) $71,046,881 $49,500,000 $17,000,000 $66,500,000 $66,452,051 100.00% 100,324 350,537 450,861 (3) (5) 5,095 339,109 344,204 $105,419 $689.646 $795,065 NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of April 2019 was 2.45%. (2) The face value indicates the value of the investment if held until maturity, which is the usual District practice. (3) The weighted average yield of the total Sewer Construction portfolio is 2.4641%. (4) The market value of the portfolio on April 30,2019 was$66,452,051. 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. May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 73 of 399 Page 26 of 42 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:002-SEWER CONSTRUCTION(Capital) April 2019 Fiscal Period 10/2019 Summarized by Account Report Generated on May 9,2019 1:53:03 PM TOTAL ASSETS Current Assets CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003 CASH ACCOUNTS/CASH $1,699,519 CASH ACCOUNTS/TEMPORARY INVESTMENTS $66,500,000 DUE FROM/DUE FROM DEBT FUND $3,685,382 DUE FROM/DUE FROM RIE $41,992,463 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $64,815 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $58,650 RECEIVABLE ACCOUNTS/CAD RECEIVABLE $162,781 Current Assets $114,983,612 Net Property,Plant and Equipment FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $29,617,411 Net Property,Plant and Equipment $29,617,411 TOTAL ASSETS $144,601,023 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($286) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,019,670) CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($1,115,253) CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($222,917) DUE TO/DUE TO DEBT FUND ($67,318) DUE TO/DUE TO RIE ($52,360,239) LIABILITIES/UNEARNED INTEREST ($208,974) Total Liabilities ($54,994,657) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($29,617,411) FUND EQUITY/AVAILABLE FUND BALANCE ($41,006,302) FUND EQUITY/EXPENDITURE SUMMARY $29,617,411 YEAR TO DATE REVENUES/REVENUE SUMMARY ($48,600,064) Total Fund Equity ($89,606,366) TOTAL LIABILITIES AND FUND EQUITY ($144,601,023) Page 27 of 42 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 2:00:10 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $9,645 $17,167 78.0% $875,950 $924,486 5.5°% $960,250 $35,764 96.3% Total Revenue 78.0% $875,950 $924,486 $960,250 Page 28 of 42 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM $50,000 ❑Period Budget $1,000,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $40,000 $800,000- $30,000- $600,000- $20,000-/-- 600,000 $20,000 $400,000- $10,000- $200,000- $0- $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $29,540 $49,849 ($20,309) $865,400 $786,154 $79,246 Totals $29,540 $49,849 ($20,309) $865,400 $786,154 $79,246 Page 29 of 42 j&V ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM 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,910 $604,994 ($27,084) -4.7% $579,500 104.4% GENERAL&AUTO LIABILITY $28,749 $48,893 ($20,144) -70.1% $287,490 $181,160 $106,330 37.0% $345,000 52.5% EMP RELATED&POLLUTION $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% Total Expenses $29,540 $49,849 ($20,309) -68.8% $865,400 $786,154 $79,246 9.2% $924,500 85.0% Color Key: 0 to 10%over budget > 10%over budget M Page 30 of 42 CENTRAL CONTRA COSTA SANITARY DISTRICT SELF-INSURANCE FUND TEMPORARY INVESTMENTS APRIL,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,239,906 100.00% $14,499 $116,899 $131,398 (3) $7,200,000 $7,200,000 $0 $7,200,000 $7,239,906 100.00% 14,499 116,899 131,398 (2) 2,654 5,943 8,596 $17,152 $122,842 $139,994 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of April,2019 was 2.450%. (2) The face value indicates the value of the investment if held until maturity,which is the usual District Practice. (3) The weighted average yield of the total Self-Insurance portfolio is 2.450%. (4) The market value of the portfolio on April 30,2019 was$7,239,906. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 78 of 399 Page 31 of 42 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:003-SELF-INSURANCE April 2019 Fiscal Period 10/2019 Summarized by Account Report Generated on May 9,2019 1:53:03 PM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $107,403 CASH ACCOUNTS/TEMPORARY INVESTMENTS $7,200,000 DUE FROM/DUE FROM R/E $783,408 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $14,499 Current Assets $8,105,310 TOTAL ASSETS $8,105,310 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/ACCOUNTS PAYABLE ($15,644) CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($882,230) DUE TO/DUE TO R/E ($789,056) Total Liabilities ($1,686,930) Total Fund Equity FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000) FUND EQUITY/EXPENDITURE SUMMARY $786,154 FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,280,047) YEAR TO DATE REVENUES/REVENUE SUMMARY ($924,486) Total Fund Equity ($6,418,380) TOTAL LIABILITIES AND FUND EQUITY ($8,105,310) Page 32 of 42 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004-DEBT SERVICE April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 2:00:10 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $0 $0 0.0°% $3,528,591 $3,531,028 0.1°% $3,611,037 $80,009 97.8% Total Revenue 0.0% $3,528,591 $3,531,028 0.1% $3,611,037 Page 33 of 42 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM $1 ❑Period Budget $1,000,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $800,000- $0- $600,000- $0- $400,000- ($0)- $200,000- ($1)- 800,000$0 $600,000$0 $400,000($0) $200,000($1) $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $0 $0 $0 $764,278 $868,491 ($104,213) Totals $0 $0 $0 $764,278 $868,491 ($104,213) Page 34 of 42 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004-DEBT SERVICE April 2019 Fiscal Period 10/2019 Report Generated on May 9, 2019 1:56:51 PM Department: Category Period Budget Period Actual Period Variance % YTD Budget YTID Actual YTD Variance % Annual % Budget INTEREST EXPENSE $0 $0 $0 0.0% $764,278 $868,491 ($104,213) $1,135,780 76.5% Total Expenses $0 $0 $0 0.0% $764,278 $868,491 ($104,213) -13.6% $1,135,780 76.5% Total Expenses $7,494,993 $6,122,473 $1,372,520 18.3% $76,033,766 $72,314,451 $3,719,315 4.9% $91,780,736 78.8% Color Key: 0 to 10%over budget > 10%over budget M Page 35 of 42 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:004-DEBT SERVICE April 2019 Fiscal Period 10/2019 Summarized by Account Report Generated on May 9,2019 1:53:03 PM TOTAL ASSETS Current Assets DUE FROM/DUE FROM RIE $3,528,591 DUE FROM/DUE FROM S/C $67,318 L.T.DEBT ACCOUNTING/DEPOSIT W/TRUSTEE-RESERVE $0 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $99,384 Current Assets $3,695,292 TOTAL ASSETS $3,695,292 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities DUE TO/DUE TO S/C ($3,685,382) L.T.DEBT ACCOUNTING/BOND ACR INTEREST PAYABLE $0 L.T.DEBT ACCOUNTING/BONDS PAYABLE ($19,450,000) Total Liabilities ($23,135,382) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $24,673,496 FUND EQUITY/EXPENDITURE SUMMARY $868,491 LIABILITIES/DEFERRAL-BOND REFUNDING ($2,570,870) YEAR TO DATE REVENUES/REVENUE SUMMARY ($3,531,028) Total Fund Equity $19,440,090 TOTAL LIABILITIES AND FUND EQUITY ($3,695,292) Page 36 of 42 DASHBOARD DATA (SELECTED DATA ON MATTERS OF CONTINUING BOARD INTEREST) May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 84 of 399 Page 37 of 42 PENSION AND OPEB LIABILITY AND FUNDING STATUS Pension Million $160 100% Million $90 100% $140 90% $80 90% $120 80% $70 80% 70% $60 70% $100 60% 60% $50 $80 50% 50% $40 $60 40% 40% 30% $30 30% $40 20% $20 20% $20 10% $10 10% $0 0% $0 0% ,LO 16;,",, LOti ,Lti�,titi� ,Lti�,0�ti ,Oti ,O`0,O`0,Otil 10ti00 ,LO iIIIIIIIIIIIIIIIIIIl UAAL Funded% iIIIIIIIIIIIIIIIIIiI.1AAL 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). May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 85 of 399 Page 38 of 42 CIB TRANSFERS SINCE FY 2016=17 Cause for Transfers Total Original Project Budgets and Transfers #of transfers 8 $30,000,000 7 6 $25,000,000 5 $20,000,000 4 3 $15,000,000 2 $10,000,000 1 0 $5,000,000 F.Cost exceeded initial budget ■A.Bundling ■B.Cashflow accelerations ■C.Developer/CAD or E.New project scope other cost neutral D. New Project C. Developer/CAD or other cost neutral B.Cashflow accelerations D.New Project ■ E.New project scope ■F.Cost exceeded $- A. Bundling initial budget ,1 ,kr, �J a� �t Notes: There was one transfer since the last report. $480,000 from Contingency to Project 8450, Development Sewerage. This is classified as C. Develop/CAD or other cost neutral project May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 86 of 399 Page 39 of 42 CIB TRANSFERS=CURRENT YEAR Cause for Transfers Total Original Project Budgets and Transfers #of transfers $3,000,000 $2,500,000 $2,000,000 1 $1,500,000 0 � $1,000,000 ■ °�° ■ o ■ `o ■ v ■ n ■ v c a Q o v v 7 3 d V N 7 Q U Q ° $500,000 F.Cost exceeded initial budget v o fl o +71 3 > u d 3 u ' g c ° o r z LL E.New project scope N u o w D.New Project U C.Developer/CAD or other cost neutral m f B.Cashflow accelerations $ A. Bundling a t� Notes: There was one transfer since the last report. $480,000 from Contingency to Project 8450, Development Sewerage. This is classified as C. Develop/CAD or other cost neutral project May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 87 of 399 Page 40 of 42 FY 2018-19 Running Expense Fund Total Cash & Investment Balances (Actuals through April 2019) $52.5 $49.8 $50.0 $46.7 $40 $42.5 $43.7 $44.3 .3 $40.2 $40.9 $40.0 $37.4 - $37.1 $33.9 $37.3 $31.5 $31.9 $30.0 $29.6 $25.6 $26 7 $24.2 $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 May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 88 of 399 Page 41 of 42 FY 2018-19 Sewer Construction Fund Total Cash & Investment Balances (Actuals through April 2019) $70.0 $68.2 $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 $37.9 $34.3 $36.4 $35.7 $31.6 $33.0 $32.4 $31.1 $30.0 $29.J$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 May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 89 of 399 Page 42 of 42 Sewer Construction Budget, Commitments and Capacity $120 $120 $ in millions $100 — — — — $100 1 do � 1 $80 *01 $80 i 1 � 1 $60 1 120.6 1 151.3 $60 1 � 1 $40 i $40 13.2 24.7 42.9 $20 45.5 45.5 $20 $0 - _ -___` ~ $0 18/19 19/20 20/21 21/22 22/23 Fiscal Year ®Approved and Projected Budget per FY Additional contractual capacity with approved rate adjustments 1====1 Remaining contractual capacity with existing rates Committed already(contracted) Sewer Construction funding capacity from Existing Rates Sewer Construction funding capacity with approved 4 year adjustments and planned borrowing *Future years amounts may differ to the extent of reserve drawdowns. May 21, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 90 of 399