Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
03.b. Review December 2018 Financial Statements and Investment Reports
Page 1 of 36 Item 3.b. ,0f,rTCj ON SAN FA January 28, 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 DECEMBER 2018 FINANCIAL STATEMENTS AND INVESTMENT REPORTS Attached for review are the Financial Statements and Investment Reports as of the date shown above. The Committee's recommendation regarding Board receipt of these reports will be announced at the January 31, 2019 Board meeting. O&M spending, with savings of$1.9 million through December, is anticipated to continue to be below budget by year end. Also favorable is that O&M revenues are running ahead of plan. Capital spending at $18.4 million is running behind scheduled spending of $23.9 million. Sewer construction revenues are also running $3 million ahead of expectations due to stronger SSC and property tax received from the County. Staff note that purchases of individual investments in corporate securities have been suspended pending additional work by staff on the issue of reliance on ratings assigned by the nationally recognized statistical rating agencies such as Moody's, and Standard & Poors in light of rapid downgrades such as PG&E. Only one corporate instrument remains at this time, Toyota Motor, which matures in early March 2019. Staff have demonstrated one tool for monitoring corporate credit, and are likely to review and potentially implement other tools before recommencing any corporate debt purchases. Strategic Plan Tie-In GOAL THREE: Be a Fiscally Sound and Effective Water Sector Utility Strategy 2- Manage costs ATTACHMENTS: 1. December 2018 Financial Statements and Investment Reports January 28, 2019 Special FINANCE Committee Meeting Agenda Packet- Page 81 of 126 P2PaW*(8 f1R3GSTA SANITARY DISTRICT January 10, 2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS C5 1 FROM: AMAL LYON SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through period ending December, 2018: YTD YTD Fav/(Unfav) O&M Revenues: Budgeted Actual Variance Explanation First installment received was higher than budgeted. Percentage received Total $36,208,680 $40,423,896 $4,215,216 varies annually. O&M Expenses: Expenses are typically lower in the beginning of the year. Some positions Total Labor Charges $26,219,412 $25,815,209 $ 404,203 budgeted for in July are filled later in the fiscal year resulting in savings. Chemicals 708,649 668,305 40,344 Chemicals are purchased as needed but budgeted for evenly. Utilities 1,812,371 1,721,537 90,834 Positive variance due to delay in PG&E invoices. Repairs&Maintenance 2,691,307 2,243,248 448,059 Lower due to budget spread over 12 months versus actual expense occurring sporadically throughout the year. Professional&Legal Services 422,606 295,712 126,894 Due to delay in legal invoices. Outside Services 1,748,466 1,142,203 606,263 Mostly due to lower Technical Services than budgeted thus far in the fiscal year. Other Expenses 1,679,061 1,313,785 365,276 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 6,937,270 7,084,843 (147,573) Variance due to UAAL vacancy. Budgeted vacancy is higher than actual vacancies thus far in the fiscal year. All Other 2,305,800 2,308,028 (2,228) Minor variances for multiple account categories. Total $44,524,942 $42,592,870 $1,932,072 January 28, 2019 Special FINANCE Committee Meeting Agenda Packet- Page 82 of 126 Page 2 of 35 j&W lics entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 001 - RUNNING EXPENSE(O&M) December 2018 Fiscal Period 6/2019 Report Generated on Jan 10, 2019 12:58:58 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 $5,822 -27.2% $58,000 $54,538 -6.0% $929,000 $874,462 5.9% Other $431,564 $316,142 -26.7% $2,037,184 $2,078,522 2.0% $4,123,000 $2,044,478 50.4% Sewer Service Charges $32,884,916 $37,068,776 12.7% $34,113,496 $38,290,836 12.2% $67,073,732 $28,782,896 57.1% Total Revenue $33,324,480 $37,390,739 12.2% $36,208,680 $40,423,896 11.6% $86,925,732 $46,501,836 46.5% Page 3 of 35 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 -RUNNING EXPENSE(O&M) December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:00:34 PM $45,000,000.00 —Budget 524,942 —Actual $40,000,000.00 592,870 $35,000,000.00 5 2 ,666,108 $30,000,000.00 3 ,229,184 $28,064,083 $25,000,000.00 / $23,12 $20,000,000.00 $21,657,968 $16,222 $15,000,000.00 $14,989,002 $10,000,000.00 $8 83 $8,238,746 $5,000,000.00 $0.00 Jul(1)2018 Aug(2)2018 Sep(3)2018 Oct(4)2018 Nov(5)2018 Dec(6)2018 Fiscal Periods Page 4 of 35 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE(O&M) December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:00:34 PM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $2,964,217 $2,964,977 ($760) 0.0% $17,785,302 $17,415,138 $370,164 2.1% $35,571,037 49.0% EMPLOYEE BENEFITS $1,737,321 $1,792,448 ($55,127) -3.2% $10,423,926 $10,169,601 $254,325 2.4% $20,993,695 48.4% CAPITALIZED ADM OVERHEAD ($331,636) ($305,535) ($26,101) 7.9% ($1,989,816) ($1,769,530) ($220,286) 11.1% ($3,979,723) 44.5% DIRECTOR FEES&EXPENSES $14,041 $10,636 $3,405 24.3% $84,246 $79,628 $4,618 5.5% $168,494 47.3% CHEMICALS $121,547 $144,386 ($22,839) -18.8% $708,649 $668,305 $40,344 5.7% $1,459,000 45.8% UTILITIES $345,206 $318,930 $26,276 7.6% $1,812,371 $1,721,537 $90,834 5.0% $4,142,550 41.6% REPAIRS&MAINTENANCE $507,431 $410,833 $96,598 19.0% $2,691,307 $2,243,248 $448,059 16.6% $5,414,644 41.4% HAULING&DISPOSAL $93,867 $101,702 ($7,835) -8.3% $415,202 $355,127 $60,075 14.5% $1,126,475 31.5% PROFESSIONAL&LEGAL SERV $72,101 $43,942 $28,159 39.1% $422,606 $295,712 $126,894 30.0% $845,300 35.0% OUTSIDE SERVICES $265,726 $255,213 $10,513 4.0% $1,748,466 $1,142,203 $606,263 34.7% $3,510,822 32.5% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $779,500 $779,500 $0 0.0% $779,500 100.0% MATERIALS&SUPPLIES $175,642 $184,853 ($9,211) -5.2% $1,026,852 $1,093,772 ($66,920) -6.5% $2,108,126 51.9% OTHER EXPENSES $128,551 $68,071 $60,480 47.0% $1,679,061 $1,313,785 $365,276 21.8% $2,777,258 47.3% UNFUNDED LIABILITIES $893,356 $936,303 ($42,947) -4.8% $6,937,270 $7,084,843 ($147,573) -2.1% $14,803,278 47.9% Total Expenses $6,987,370 $6,926,761 $60,609 0.9% $44,524,942 $42,592,870 $1,932,072 4.3% $89,720,456 47.5% Color Key: 0 to 10%over budget > 10%over budget M Page 5 of 35 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE (O&M) December 2018 Fiscal Period 06/2019 Report Generated on Jan 14, 2019 8:27:04 AM $2,500,000 ❑Period Budget $14,000,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $12,000,000- $2,000,000- $10,000,000- $1,500,000- 12,000,000$2,000,000 $10,000,000$1,500,000 $8,000,000 $1,000,000 $6,000,000 $4,000,000 $500,000- $2,000,000 $o $0 °e� 5�pp� s��� `��`� o�\o '�oQ� � Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $1,911,515 $1,836,561 $74,954 $13,607,953 $12,278,851 $1,329,102 ENGINEERING $1,366,132 $1,374,625 ($8,493) $8,669,815 $8,339,877 $329,938 COLLECTION SYSTEM OPS. $1,162,280 $1,136,245 $26,035 $6,870,181 $6,900,600 ($30,419) PLANT OPERATIONS $2,173,526 $2,239,845 ($66,319) $13,205,023 $13,137,148 $67,875 PUMP STATIONS $244,538 $208,214 $36,324 $1,408,362 $1,366,635 $41,727 RECYCLED WATER $129,379 $131,271 ($1,892) $763,608 $569,759 $193,849 Totals $6,987,370 $6,926,761 $60,609 $44,524,942 $42,592,870 $1,932,072 Page 6 of 35 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM Department: ADMINISTRATION Category____m1_. =ME Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual A Budget SALARIES&WAGES $611,365 $568,519 $42,846 7.0% $3,668,190 $3,346,479 $321,711 8.8% $7,336,515 45.6% EMPLOYEE BENEFITS $703,688 $773,578 ($69,890) -9.9% $4,222,128 $3,913,286 $308,842 7.3% $8,588,771 45.6% CAPITALIZED ADM OVERHEAD ($4,147) ($3,337) ($810) 19.5% ($24,882) ($16,853) ($8,029) 32.3% ($49,764) 33.9% DIRECTOR FEES&EXPENSES $14,041 $10,636 $3,405 24.3% $84,246 $79,628 $4,618 5.5% $168,494 47.3% UTILITIES $10,816 $17,017 ($6,201) -57.3% $64,896 $59,489 $5,407 8.3% $129,800 45.8% REPAIRS&MAINTENANCE $150,592 $193,442 ($42,850) -28.5% $648,772 $514,875 $133,897 20.6% $1,132,390 45.5% PROFESSIONAL&LEGAL SERV $55,771 $19,023 $36,748 65.9% $324,626 $242,017 $82,609 25.4% $649,300 37.3% OUTSIDE SERVICES $119,355 $46,700 $72,655 60.9% $775,964 $443,297 $332,667 42.9% $1,647,300 26.9% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $779,500 $779,500 $0 0.0% $779,500 100.0% MATERIALS&SUPPLIES $16,329 $9,418 $6,911 42.3% $97,974 $71,255 $26,719 27.3% $196,025 36.3% OTHER EXPENSES $57,336 $21,243 $36,093 62.9% $331,191 $226,473 $104,719 31.6% $960,040 23.6% UNFUNDED LIABILITIES $176,369 $180,323 ($3,954) -2.2% $2,635,348 $2,619,405 $15,944 0.6% $6,199,286 42.3% ADMINISTRATION Total Expenses $1,911,515 $1,836,561 $74,954 3.9% $13,607,953 $12,278,851 $1,329,102 9.8% $27,737,657 44.3% Color Key: 0 to 10%over budget > 10%over budget M Page 7 of 35 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM Department: ENGINEERING Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $833,166 $851,278 ($18,112) -2.2% $4,998,996 $5,016,863 ($17,867) -0.4% $9,998,042 50.2% EMPLOYEE BENEFITS $329,253 $329,944 ($691) -0.2% $1,975,518 $2,038,082 ($62,564) -3.2% $3,951,391 51.6% CAPITALIZED ADM OVERHEAD ($296,790) ($273,770) ($23,020) 7.8% ($1,780,740) ($1,625,046) ($155,694) 8.7% ($3,561,499) 45.6% UTILITIES $14,432 $14,414 $18 0.1% $86,592 $85,342 $1,250 1.4% $173,200 49.3% REPAIRS&MAINTENANCE $14,281 $13,975 $306 2.1% $85,686 $41,270 $44,416 51.8% $171,400 24.1% HAULING&DISPOSAL $44,867 $48,465 ($3,598) -8.0% $121,202 $120,408 $794 0.7% $538,425 22.4% PROFESSIONAL&LEGAL SERV $14,248 $13,224 $1,024 7.2% $85,488 $37,098 $48,390 56.6% $171,000 21.7% OUTSIDE SERVICES $96,931 $77,095 $19,836 20.5% $688,528 $442,934 $245,594 35.7% $1,270,142 34.9% MATERIALS&SUPPLIES $32,915 $24,133 $8,782 26.7% $197,490 $131,934 $65,556 33.2% $395,050 33.4% OTHER EXPENSES $19,379 $3,521 $15,858 81.8% $630,355 $407,460 $222,895 35.4% $764,812 53.3% UNFUNDED LIABILITIES $263,450 $272,346 ($8,896) -3.4% $1,580,700 $1,643,532 ($62,832) -4.0% $3,161,443 52.0% ENGINEERING Total Expenses $1,366,132 $1,374,625 ($8,493) -0.6% $8,669,815 $8,339,877 $329,938 3.8% $17,033,406 49.0% Color Key: 0 to 10%over budget > 10%over budget M Page 8 of 35 ' Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM Department: COLLECTION SYSTEM OPS. Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $522,693 $538,851 ($16,158) -3.1% $3,136,158 $3,159,732 ($23,574) -0.8% $6,272,384 50.4% EMPLOYEE BENEFITS $255,254 $261,297 ($6,043) -2.4% $1,531,524 $1,543,924 ($12,400) -0.8% $3,063,394 50.4% CAPITALIZED ADM OVERHEAD ($2,676) ($1,658) ($1,018) 38.0% ($16,056) ($24,308) $8,252 = ($32,120) 75.7% UTILITIES $12,115 $23,199 ($11,084) -91.5% $72,690 $76,712 ($4,022) -5.5% $145,400 52.8% REPAIRS&MAINTENANCE $122,873 $34,295 $88,578 72.1% $638,739 $570,310 $68,429 10.7% $1,474,504 38.7% HAULING&DISPOSAL $10,916 $3,962 $6,954 63.7% $65,496 $35,462 $30,034 45.9% $131,000 27.1% PROFESSIONAL&LEGAL SERV $625 $248 $377 60.2% $3,750 $745 $3,005 80.1% $7,500 9.9% OUTSIDE SERVICES $4,972 $618 $4,355 87.6% $29,832 $25,599 $4,233 14.2% $59,680 42.9% MATERIALS&SUPPLIES $63,074 $95,307 ($32,233) -51.1% $361,444 $444,809 ($83,365) = $756,951 58.8% OTHER EXPENSES $10,529 $6,250 $4,279 40.6% $75,174 $66,761 $8,413 11.2% $138,445 48.2% UNFUNDED LIABILITIES $161,905 $173,876 ($11,971) -7.4% $971,430 $1,000,854 ($29,424) -3.0% $1,942,922 51.5% COLLECTION SYSTEM OPS.Total $1,162,280 $1,136,245 $26,035 2.2% $6,870,181 $6,900,600 ($30,419) -0.4% $13,960,060 49.4% Expenses Color Key: 0 to 10%over budget > 10%over budget Page 9 of 35 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM Department: PLANT OPERATIONS Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $869,326 $886,077 ($16,751) -1.9% $5,215,956 $5,162,836 $53,120 1.0% $10,432,017 49.5% EMPLOYEE BENEFITS $380,506 $371,790 $8,716 2.3% $2,283,036 $2,304,701 ($21,665) -0.9% $4,566,639 50.5% CAPITALIZED ADM OVERHEAD ($28,023) ($26,769) ($1,254) 4.5% ($168,138) ($103,323) ($64,815) 38.5% ($336,340) 30.7% CHEMICALS $93,715 $134,660 ($40,945) -43.7% $562,490 $550,345 $12,145 2.2% $1,125,000 48.9% UTILITIES $250,215 $217,215 $33,000 13.2% $1,280,458 $1,237,606 $42,852 3.3% $3,002,600 41.2% REPAIRS&MAINTENANCE $186,609 $164,040 $22,569 12.1% $1,119,654 $952,869 $166,785 14.9% $2,239,400 42.6% HAULING&DISPOSAL $37,351 $48,387 ($11,036) -29.5% $224,106 $194,099 $30,007 13.4% $448,250 43.3% PROFESSIONAL&LEGAL SERV $291 $389 ($98) -33.7% $1,746 $886 $860 49.3% $3,500 25.3% OUTSIDE SERVICES $19,912 $83,051 ($63,139) -317.1% $119,472 $165,001 ($45,529) $239,000 69.0% MATERIALS&SUPPLIES $58,871 $55,428 $3,443 5.8% $343,226 $427,501 ($84,275) $706,600 60.5% OTHER EXPENSES $35,534 $24,366 $11,168 31.4% $607,703 $587,726 $19,977 3.3% $844,615 69.6% UNFUNDED LIABILITIES $269,219 $281,211 ($11,992) -4.5% $1,615,314 $1,656,902 ($41,588) -2.6% $3,230,674 51.3% PLANT OPERATIONS Total Expenses $2,173,526 $2,239,845 ($66,319) -3.1% $13,205,023 $13,137,148 $67,875 0.5% $26,501,955 49.6% Color Key: 0 to 10%over budget > 10%over budget M Page 10 of 35 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) December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM Department: PUMP STATIONS Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $80,539 $86,865 ($6,326) -7.9% $483,234 $503,772 ($20,538) -4.3% $966,479 52.1% EMPLOYEE BENEFITS $33,186 $33,744 ($558) -1.7% $199,116 $215,416 ($16,300) -8.2% $398,256 54.1% CAPITALIZED ADM OVERHEAD $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% CHEMICALS $20,833 $3,445 $17,388 83.5% $104,165 $61,841 $42,324 40.6% $250,000 24.7% UTILITIES $43,045 $43,572 ($527) -1.2% $220,237 $233,011 ($12,774) -5.8% $516,550 45.1% REPAIRS&MAINTENANCE $30,661 $5,081 $25,580 83.4% $183,966 $152,980 $30,986 16.8% $367,950 41.6% HAULING&DISPOSAL $733 $888 ($155) -21.2% $4,398 $5,158 ($760) = $8,800 58.6% OUTSIDE SERVICES $6,683 $1,775 $4,908 73.4% $40,098 $6,525 $33,573 83.7% $80,200 8.1% MATERIALS&SUPPLIES $3,466 $567 $2,899 83.6% $20,796 $11,129 $9,667 46.5% $41,600 26.8% OTHER EXPENSES $2,979 $3,729 ($750) -25.2% $17,874 $12,654 $5,220 29.2% $35,796 35.4% UNFUNDED LIABILITIES $22,413 $28,547 ($6,134) -27.4% $134,478 $164,149 ($29,671) M $268,953 61.0% PUMP STATIONS Total Expenses $244,538 $208,214 $36,324 14.9% $1,408,362 $1,366,635 $41,727 3.0% $2,934,584 46.6% Color Key: 0 to 10%over budget > 10%over budget M Page 11 of 35 ' Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 001 - RUNNING EXPENSE(O&M) December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM Department: RECYCLED WATER Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $47,128 $33,388 $13,740 29.2% $282,768 $225,457 $57,311 20.3% $565,600 39.9% EMPLOYEE BENEFITS $35,434 $22,096 $13,338 37.6% $212,604 $154,192 $58,412 27.5% $425,244 36.3% CHEMICALS $6,999 $6,282 $717 10.2% $41,994 $56,119 ($14,125) M $84,000 66.8% UTILITIES $14,583 $3,513 $11,070 75.9% $87,498 $29,377 $58,121 66.4% $175,000 16.8% REPAIRS&MAINTENANCE $2,415 $0 $2,415 100.0% $14,490 $10,944 $3,546 24.5% $29,000 37.7% PROFESSIONAL&LEGAL SERV $1,166 $11,058 ($9,892) -848.4% $6,996 $14,966 ($7,970) ®". $14,000 106.9% OUTSIDE SERVICES $17,873 $45,974 ($28,101) -157.2% $94,572 $58,847 $35,725 37.8% $214,500 27.4% MATERIALS&SUPPLIES $987 $0 $987 100.0% $5,922 $7,145 ($1,223) = $11,900 60.0% OTHER EXPENSES $2,794 $8,961 ($6,167) -220.7% $16,764 $12,712 $4,052 24.2% $33,550 37.9% RECYCLED WATER Total Expenses $129,379 $131,271 ($1,892) -1.5% $763,608 $569,759 $193,849 25.4% $1,552,794 36.7% Color Key: 0 to 10%over budget > 10%over budget M Page 12 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT RUNNING EXPENSE FUND TEMPORARY INVESTMENTS DECEMBER,2018 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) $16,500,000 $2,000,000 $14,500,000 $16,500,000 $16,556,000 39.76% $15,690 $134,571 $150,261 RE05 US Gov't FHLMC 08/31/18 03/04/19 64 2.266% 4,943,215 5,000,000 5,000,000 5,000,000 12.05% 9,515.28 28,238.88 37,754.16 RE06 US Gov't FHLB 08/31/18 12/04/18 0 2.120% 4,972,556 5,000,000 (5,000,000) 0 0 0.00% 866.67 26,577.78 27,444.45 RE07 FHLB FED AGENCY 12/24/18 03/22/19 80 2.424% 4,970,544 5,000,000 5,000,000 4,973,450 12.05% 2,677.78 0.00 2,677.78 RE08 FHLB FED AGENCY 12/24/18 03/21/19 79 2.448% 4,971,000 5,000,000 5,000,000 4,973,800 12.05% 2,666.67 0.00 2,666.67 RE09 FHLB FED AGENCY 12/24/18 7/22/19 202 2.558% 4,927,375 5,000,000 5,000,000 4,930,750 12.05% 2,766.67 0.00 2,766.67 RE10 FHLB FED AGENCY 12/24/18 7/23/19 203 2.558% 4,927,029 5,000,000 5,000,000 4,930,400 12.05% 2,766.67 0.00 2,766.67 (3) $46,211,719 $12,000,000 $29,500,000 $41,500,000 $41,364,400 100.00% 36,950.15 189,387.50 226,337.65 (2) 9,505.48 17,531.67 27,037.15 $46,456 $206,919 $253,375 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of December,2018 was 2.30%. (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.2913%. (4) The market value of the portfolio on December 31,2018 was$41,364,400. (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 January 28, 2019 Special FINANCE Committee Meeting Agenda Packet- Page 93 of 126 Page 13 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) December 2018 Fiscal Period 6/2019 Summarized by Account Report Generated on Jan 10,2019 12:54:27 PM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $2,819,667 CASH ACCOUNTS/PAYROLL CLEARING $20,000 CASH ACCOUNTS/PETTY CASH $3,400 CASH ACCOUNTS/TEMPORARY INVESTMENTS $41,500,000 DEFERRED OUTFLOWS/DEFERRED OUTFLOWS-GASB 68 $21,503,021 DEFERRED OUTFLOWS/DEFERRED OUTFLOWS-GASB 75 $30,400 DUE FROM/DUE FROM S/C $29,485,067 DUE FROM/DUE FROM S/I $779,500 INVENTORY/SUPPLIES&MATERIAL INV $2,112,083 PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104 PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572 PREPAID ACCOUNTS/PREPAID EXPENSES $986,432 PREPAID ACCOUNTS/PREPAID INSURANCE $11,467 PREPAID ACCOUNTS/PREPAID RETIREMENT $11,557,471 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $776,558 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $168,613 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA $1,837 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $48,551 RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $9,632 RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $100,640 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $2,263 Current Assets $111,963,277 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 $764,365,619 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($15,319) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($217,440) CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($4,526,293) CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,194,333) Page 14 of 35 ' Central Contra Costa Sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) December 2018 Fiscal Period 6/2019 Summarized by Account Report Generated on Jan 10,2019 12:54:27 PM CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($54,520) CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($784) CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931) CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING ($9,616) CURRENT LIABILITIES/PERMIT CLEARING ($91) CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($41,080) CURRENT LIABILITIES/RETIREMENT CONTRIB W/H ($1,781,524) CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $209,151 DEF.COMP.CONTRIB W/H/ICMA $0 DUE TO/DUE TO DEBT FUND ($3,528,591) DUE TO/DUE TO S/C ($22,582,820) 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,743,053 LIABILITIES/UNEARNED INTEREST ($212,204) MEDICAL LIABILITIES/DELTA DENTAL $220 MEDICAL LIABILITIES/DISABILITY INS $73 MEDICAL LIABILITIES/HEALTH NET $0 MEDICAL LIABILITIES/KAISER PERMANENTE ($806) MEDICAL LIABILITIES/LIFE INS ($28) MEDICAL LIABILITIES/OCCUPATIONAL HEALTH ($26) MEDICAL LIABILITIES/POST EMP.BENEFIT-OPEB $0 PAYROLL TAXES WITHHELD/CALIFORNIA WITHHOLDING $368 PAYROLL TAXES WITHHELD/FEDERAL WITHHOLDING $792 REIMBURSEMENT FEES ($54,466) Total Liabilities ($167,422,712) 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 $42,592,870 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 ($40,423,896) Total Fund Equity ($596,942,908) TOTAL LIABILITIES AND FUND EQUITY ($764,365,619) Page 15 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT January 10,2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS C� FROM: AMAL LYON SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending December 31,2018: YTD YTD Fav/(Unfav) S/C Revenues: Budgeted Actual Variance Explanation SSC& Property tax revenue received from the County Total $ 22,569,486 $25,565,998 $ 2,996,512 was higher than budgeted. FY YTD FY S/C Expenses: Budget* Actual Remaining %Spent Total $ 52,287,827 $ 18,379,941 $ 33,907,886 35.15% Includes 17/18 carry-over($6,968,627 January 28, 2019 Special FINANCE Committee Meeting Agenda Packet- Page 96 of 126 Page 16 of 35 AIMILSentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 002-SEWER CONSTRUCTION (Capital) December 2018 Fiscal Period 6/2019 Report Generated on Jan 10, 2019 12:58:58 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 $5,078,581 $6,551,498 29.0% $8,606,486 $9,620,983 11.8% $20,813,000 $11,192,017 46.2% Sewer Service Charges $13,463,000 $15,436,572 14.7% $13,963,000 $15,945,015 14.2% $27,926,268 $11,981,253 57.1% Total Revenue $18,541,581 $21,988,070 18.6% $22,569,486 $25,565,998 13.3% $55,889,268 $30,323,270 45.7% Page 17 of 35 Sewer Fund (Capital)Spending FY 18-19 $30,000,000 $23,890,698 $25,000,000 $19,397,124 $20,000,000 $15,000,000 $13,377,477 $18,379,941 $14,503,936 $10,000,000 $9,429,510 $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 -Projected* -Actual Columnl July August September October November December Projected* $ 1,426,829 $ 3,996,336 $ 9,429,510 $ 13,377,477 $ 19,397,124 $ 23,890,698 Actual 1,600,939 3,404,835 8,485,345 11,543,304 14,503,936 18,379,941 *Projected-Current year budget allocated by month based on historical spending in previous 2 years Inniinni 7S2 ')OIQ Cncrinl f=1nIAN(`f= r nmmittcc lkticcfinn Ancntln Ported- Pnnc Qq of 1W, Page 18 of 35 PROGRAM/GM3851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2018 PERIOD 6/2019 F(D+E) (C+D+E) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN 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 System $ 29,409,417 30,841,697 (1,432,280) 19,347,000 600,000 19,947,000 18,514,720 11,065,038 7,449,689 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 5,679,329 18,404,511 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 834,245 4,506,671 TYPE RW Recycled Water 2,382,894 1,769,035 613,859 2,857,000 - 2,857,000 3,470,859 801,329 2,669,530 CIB Contingency - - - 1,500,000 (622,500) 877,500 877,500 - 877,500 TAL DISTRICT $ 73,563,322 $ 66,594,495 $ 6,968,827 $ 45,319,000 $ 45,319,000 $ 52,287,827 $ 18,379,941 $ Inniinry 7S2 7f11Q CnarinI FIKIANF (nmmittcc h A a a inn AncnrJa Parrl<ct- Panc Q of 19R Page 19 of 35 PROGRAM/GM3851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2018 PERIOD 6/2019 F(D+E) (C+D+E) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN 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 E CS Collection 5 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 23,972 776,028 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 25,362 251,195 ****6679 Coredell Drive CAD - - 123,443 123,443 123,443 - 123,443 **7367 Concord Main Metering Station - - - - 250,000 250,000 250,000 1,854 248,146 8249 CSO Dump Pad Modifications 60,000 - 60,000 - 60,000 5,000 55,000 *8412 PH Grayson Creek Trunk 15,100,000 15,061,359 38,641 - - 38,641 176,131 (137,490) 8419 Collection System Planning LT 885,000 884,387 613 100,000 100,000 100,613 59,730 40,883 *8430 Lafayette Sewer Renovation Phase 11 4,319,000 4,289,317 29,683 - - 29,683 8,449 21,234 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,498,499 155,784 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,600,824 58,054 8436 Moraga/Crossroads PS Project 1,300,000 1,138,016 161,984 2,697,000 (250,000) 2,447,000 2,608,984 640,178 1,968,806 8441 CIPP Contract 17-20 300,000 80,247 219,753 100,000 100,000 319,753 119,239 200,514 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 6,766 237,441 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,429,815 168,505 8446 Lafayette Sewer Renovation Phase 12 636,000 1,216,107 (580,107) 3,397,600 3,397,600 2,817,493 2,462,682 354,811 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 111,800 212,830 8449 Collection System Modeling Support 100,000 56,761 43,239 100,000 100,000 143,239 24,465 118,774 8450 Development Sewerage Support 400,000 240,770 159,230 250,000 250,000 409,230 131,551 277,679 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 163,388 336,612 *8453 Willows Sewer Repair 98,000 98,000 - - - - - - ***8454 So.Orinda Sewer Ren.Ph.7 - - 500,000 500,000 500,000 199,532 300,468 ***8455 W.C.Sewer Renov.Ph.13 - - - - 500,000 500,000 500,000 282,024 217,976 ***8456 Danville Sewer Ren.Ph.3 500,000 j 500,000 500,000 93,777 406,223 8457 Pump Station Upgrades-Ph.2 - - - 50,000 50,000 50,000 - 50,000 Rounding 7 otal FY 2018-19 CS Amount 29,409,417 30,841,697 (1,432,280) 19,347,000 600,000 19,947,00 18,514,720 11,065,038 *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 Inniinry 7J2 7r11Q Cncr-inI FII\1AN1(`F (nmmiffnn RAccfinn Anar)An Parrl<cf- Panc inn of 17R Page 20 of 35 PROGRAM/GM3851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2018 PERIOD 6/2019 F(D+E) (C+D+E) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU HE 17-18) PYS(THRU HE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 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 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 31,863 504,226 7304 Instr&Controls PLC Upgrade 575,000 397,606 177,394 110,000 110,000 287,394 4,928 282,466 7315 Applied Research and Innovations 557,274 251,302 305,972 300,000 (300,000) - 305,972 5,282 300,690 7317 Plant Control System Network Upgrades 330,000 234,234 95,766 100,000 100,000 195,766 466 195,300 7320 Plant Energy Optimization 1,094,000 1,063,448 30,552 - - - 30,552 (59,609) 90,161 7322 Fire Protection System Ph.2 1,406,000 1,014,803 391,197 - - 391,197 271,232 119,965 7326 Equipment Replacement FY 15-FY 24 1,166,000 748,217 417,783 250,000 - 250,000 667,783 246,646 421,137 7327 Headwork's Screening Upgrade 8,144,000 7,845,455 298,545 76,000 76,000 374,545 309,779 64,766 7328 Influent Pump Electrical improvements 100,000 757 99,243 510,000 - 510,000 609,243 162,085 447,158 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 1,538,483 1,127,573 7339 T.Plant Control System 1/0 Replacement 470,000 605,231 (135,231) 900,000 900,000 764,769 60,792 703,977 7341 WC/Grayson Creek Levee Rehab 100,000 - 100,000 - - - 100,000 20,845 79,155 7348 Solids Handling Facility Improvements 4,975,000 4,516,007 458,993 5,715,000 5,715,000 6,173,993 846,547 5,327,446 7349 Aeration&Energy Upgrade 300,000 35,539 264,461 1,200,000 - 1,200,000 1,464,461 124,103 1,340,358 7351 Mechanical&Concrete Renovation 1,300,000 1,254,155 45,845 3,000,000 3,000,000 3,045,845 747,399 2,298,446 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 21,327 112,678 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 1,234 261,478 7358 Innovation Bioenergy Demo 300,000 261,182 38,818 - - 38,818 - 38,818 7359 Solids Conditioning Bldg.roof replacement 500,000 189,377 310,623 800,000 - 800,000 1,110,623 849,751 260,872 7360 Existing Plant Facility Drawing 100,000 83,040 16,960 100,000 - 100,000 116,960 25,623 91,337 7362 POB Seismic Upgrades 400,000 135,591 264,409 1,100,000 1,831,177 2,931,177 3,195,586 111,416 3,084,170 7363 Treatment Plant Planning 450,000 348,907 101,093 450,000 - 450,000 551,093 198,741 352,352 7364 TP Safety Enhancement Ph.5 - - - 100,000 - 100,000 100,000 - 100,000 Rounding 11 otal FY 2017-18 TP Amount $ 32,746,274 26,758,622 5,987,652 16,865,000 1,231,177 18,096,17 5,679,329 18,404,511 *Italic Projects open but not in CIB for 18/19 Inniinry 7J2 )(1 IQ CncrinI FI1\1AN('F (nmmittcc 1%Aaofinn AncnrJa Parrl<ct- Pann 'I n1 of 19R Page 21 of 35 PROGRAM/GM3851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2018 PERIOD 6/2019 F(D+E) (C+D+E) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN REMAINING BUDGET NO PROJECT TITLE PYS(THRU HE 17-18) PYS(THRU HE 17-18) CARRY-FORWARD BUDGET FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 FY 2018-19 rallm rovem 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 2,993 43,602 8236 District Easements 208,047 164,616 43,431 50,000 50,000 93,431 43,453 49,978 8238 Asset Management 2,969,185 2,790,236 178,949 400,000 - 400,000 578,949 327,402 251,547 8240 IT Development 2,188,794 2,187,431 1,363 1,750,000 (450,000) 1,300,000 1,301,363 66,101 1,235,262 8243 Server Room Relocation 955,430 515,656 439,774 880,000 164,570 1,044,570 1,484,344 174,855 1,309,489 8247 Property&Building Improvements 400,000 178,767 221,233 300,000 (363,606) (63,606) 157,627 144,278 13,349 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 47,022 1,198,019 9999 Capital Project Clearing(Accounting Use Only)** - (60,000) 60,000 - - 60,000 (2) 60,002 Rounding (3) tai FY 2017-18 GI Amount 08,677) 3,541,323 5,340,919 Inniinry 7J2 7(11Q Cncr-inl FII\IANI(`F (nmmiffcc hAccfinn Ancnrla Parrl<cf- Panc 1117 of 17R Page 22 of 35 PROGRAM/GM3851-4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 12/31/2018 PERIOD 6/2019 F(D+E) (C+D+E) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROJ BUDGETS EXPENDITURES PROJECT APPROVED ADJUSTMENTS BUDGET EXPENDITURES SPENTIN 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 7306 Zone 1 Recycled Water 497,894 484,984 12,910 35,000 - 35,000 47,910 7,902 40,008 7346 Surge Analysis 16-17 155,000 3,125 151,875 50,000 - 50,000 201,875 61,775 140,100 7361 Filter Plantlmprovments 330,000 162,293 167,707 2,457,000 2,457,000 2,624,707 354,931 2,269,776 7365 Recycle Water Clearwell Repairs 1,400,000 1,118,633 281,367 300,000 - 300,000 581,367 376,721 204,646 7366 ReW Distribution System Renov.Program - - - 15,000 15,000 15,000 - 15,000 Rounding Total FY 2016-17 RW Amount 2,382,894 1,769,035 613,859 2,857,000 2,857,000 3,470,859 2,669,530 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 18,379,941 33,907,901 Inniinry 7J2 7f11Q Cncr-inI FI1\1ANF (r%mmiffnn BAccfinn AncnAn Parl<cf- Pnnc InR of 17R Page 23 of 35 FY 18-19 CAPITAL BUDGET TRANSFERS PERIOD ENDING:12/31/18 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 Total 17 * Not actural transfers. All part of one project split into individual projects for construction Inn iinry 9S2 9r)IQ CncrrinI FI KIANI(`F (r%mmiffcc hAccfinn Ananr4n Par-leaf- Panc InA of 19R Page 24 of 35 O&M PROJECTS- EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 12/31/18 PERIOD 06/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 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 17,293 Technical Services $ 75,169 - - - - - - - - - - - - - $ 75,169 Total $ 92,462 1 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 92,462 Page 25 of 36 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 $ - $ - $ - $ - $ - $ - $ - $ 2,314 $ 209,141 Other Charges $ 74,996 - - - - 561 - - - - - - - - $ 74,996 Total $ 281,824 $ 1,444 $ 225 $ - $ 403 $ 802 $ - $ - $ - $ - $ - $ - $ - $ 2,314 $ 284,137 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 $ - $ - $ - $ - $ - $ - $ 14,640 $ 38,288 other Charges $ - - - - - - - - - - $ - $ - Total $ 23,648 1 $ 2,746 $ 1,540 $ 2,411 $ 2,324 $ 1,549 $ 4,069 $ - $ - $ - $ - $ - $ - $ 14,6401 $ 38,288 i_._.._._.. nn nnnn n___:_I rIni n K nn__a:.__ n-- -_I- 1'1__._ - _2 nnc Page 25 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS DECEMBER,2018 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) $14,500,000 $4,500,000 $10,000,000 $14,500,000 $14,549,212 27.62% $17,738 $82,255 $99,994 932 US Gov't Agency Dscnt 06/08/18 12/05/18 0 2.09 4,949,000 5,000,000 (5,000,000) 0 0 0.00% 1,133 43,350 44,483 933 US Gov't Agency Dscnt 06/08/18 05/28/19 149 2.32 4,956,560 5,000,000 5,000,000 4,975,600 9.52% 3,783 18,670 22,452 934 General Electric Comm Paper 08/31/18 12/03/18 0 2.24 1,988,354 2,000,000 (2,000,000) 0 0.00% 2,935 8,711 11,646 935 US Gov't Treasury Bill 08/31/18 02/28/19 59 2.56 3,955,756 4,000,000 4,000,000 3,984,920 7.62% 7,578 22,489 30,067 936 Toyota Motor CP 09/06/18 03/04/19 64 2.43 3,952,267 4,000,000 4,000,000 3,983,242 7.62% 8,267 22,933 31,200 937 FHLB Fed Agency 09/06/18 03/06/19 66 2.30 4,943,689 5,000,000 5,000,000 5,000,000 9.52% 9,644 26,756 36,400 938 FHLMC FHLMC 12/06/18 6/03/19 153 2.57 4,937,847 5,000,000 5,000,000 4,947,850 9.52% 9,028 9,028 938A FHLB Fed Agency 12/21/18 3/20/19 78 2.45 4,970,333 5,000,000 5,000,000 4,974,100 9.52% 3,667 3,667 939 FHLB Fed Agency 12/21/18 04/02/19 91 2.48 4,965,646 5,000,000 5,000,000 4,969,500 9.52% 3,705 3,705 940 US Gov't T-Bill 12/21/18 06/20/19 170 2.52 4,938,284 5,000,000 5,000,000 4,942,650 9.52% 3,751 - 3,751 (4) $59,057,736 $29,500,000 $23,000,000 $52,500,000 $52,327,074 100.00% 71,228 225,163 296,392 (3) (5) 4,969 44,611 49,580 $76,197 $269,774 $345,971 NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of December 2018 was 2.30%. (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.3793%. (4) The market value of the portfolio on December 31,2018 was$52,327,074. 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. January 28, 2019 Special FINANCE Committee Meeting Agenda Packet- Page 106 of 126 Page 26 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:002-SEWER CONSTRUCTION(Capital) December 2018 Fiscal Period 6/2019 Summarized by Account Report Generated on Jan 10,2019 12:54:27 PM TOTAL ASSETS Current Assets CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003 CASH ACCOUNTS/CASH $1,482,277 CASH ACCOUNTS/TEMPORARY INVESTMENTS $52,500,000 DUE FROM/DUE FROM DEBT FUND $3,281,476 DUE FROM/DUE FROM RIE $22,582,820 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $72,569 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $39,190 RECEIVABLE ACCOUNTS/CAD RECEIVABLE $162,781 Current Assets $80,941,115 Net Property,Plant and Equipment FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $18,379,900 Net Property,Plant and Equipment $18,379,900 TOTAL ASSETS $99,321,015 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($12,661) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,107,289) CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($1,487,037) CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($355,237) DUE TO/DUE TO DEBT FUND ($64,881) DUE TO/DUE TO RIE ($29,485,067) LIABILITIES/UNEARNED INTEREST ($236,543) Total Liabilities ($32,748,715) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($18,379,900) FUND EQUITY/AVAILABLE FUND BALANCE ($41,006,302) FUND EQUITY/EXPENDITURE SUMMARY $18,379,900 YEAR TO DATE REVENUES/REVENUE SUMMARY ($25,565,998) Total Fund Equity ($66,572,300) TOTAL LIABILITIES AND FUND EQUITY ($99,321,015) Page 27 of 35 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE December 2018 Fiscal Period 6/2019 Report Generated on Jan 10, 2019 12:58:58 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $9,645 $14,065 45.8% $837,370 $861,244 2.9% $960,250 $99,006 89.7% Total Revenue $14,065 45.8% $837,370 $861,244 2.9% $960,250 Page 28 of 35 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM $50,000 ❑Period Budget $800,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $40,000-'- $600,000- $30,000-// 40,000 ' $600,000$30,000 $400,000- $20,000-" 400,000$20,000 ' $200,000- $10,000- $0- 200,000$10,000$0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $29,540 $45,315 ($15,775) $747,240 $690,213 $57,027 Totals $29,540 $45,315 ($15,775) $747,240 $690,213 $57,027 Page 29 of 35 j&V ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 003-SELF-INSURANCE December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM Department: Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget INSURANCE&OTHER EXP $791 $3,414 ($2,623) -331.7% $574,746 $590,071 ($15,325) -2.7% $579,500 101.8% GENERAL&AUTO LIABILITY $28,749 $41,901 ($13,152) -45.7% $172,494 $100,143 $72,351 41.9% $345,000 29.0% EMP RELATED&POLLUTION $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% Total Expenses $29,540 $45,315 ($15,775) -53.4% $747,240 $690,213 $57,027 7.6% $924,500 74.7% Color Key: 0 to 10%over budget > 10%over budget M Page 30 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT SELF-INSURANCE FUND TEMPORARY INVESTMENTS DECEMBER,2018 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 $7,200,000 $7,224,436 100.00% $14,065 $60,282 $74,346 (3) 7,200,000 7,200,000 7,200,000 7,224,436 100.00% 14,065 60,282 74,346 (2) 2,569 - 2,569 $16,633 $60,282 $76,915 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of December,2018 was 2.30%. (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.30%. (4) The market value of the portfolio on December 31,2018 was$7,224,436. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. January 28, 2019 Special FINANCE Committee Meeting Agenda Packet- Page 111 of 126 Page 31 of 35 ' Central Contra Costa sanitary District Balance Sheet Fund:003-SELF-INSURANCE December 2018 Fiscal Period 6/2019 Summarized by Account Report Generated on Jan 10,2019 12:54:27 PM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $89,230 CASH ACCOUNTS/TEMPORARY INVESTMENTS $7,200,000 DUE FROM/DUE FROM R/E $783,408 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $40,170 Current Assets $8,112,808 TOTAL ASSETS $8,112,808 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/ACCOUNTS PAYABLE $0 CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($882,230) DUE TO/DUE TO R/E ($779,500) Total Liabilities ($1,661,730) Total Fund Equity FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000) FUND EQUITY/EXPENDITURE SUMMARY $690,213 FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,280,047) YEAR TO DATE REVENUES/REVENUE SUMMARY ($861,244) Total Fund Equity ($6,451,078) TOTAL LIABILITIES AND FUND EQUITY ($8,112,808) Page 32 of 35 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004-DEBT SERVICE December 2018 Fiscal Period 6/2019 Report Generated on Jan 10, 2019 12:58:58 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $3,528,591 $3,528,591 0.0°% $3,528,591 $3,528,591 0.0°% $3,611,037 $82,446 97.7% Total Revenue $3,528,591 $3,528,591 0.0% $3,528,591 $3,528,591 0.0% $3,611,037 Page 33 of 35 ACV ts entral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM $� ❑Period Budget $500,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $400,000- $0 $300,000- $0- $200,000- ($0)- $100,000- $0- Period 300,000$0 $200,000($0) $100,000$0Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $0 $0 $0 $202,284 $464,585 ($262,301) Totals $0 $0 $0 $202,284 $464,585 ($262,301) Page 34 of 35 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004-DEBT SERVICE December 2018 Fiscal Period 06/2019 Report Generated on Jan 10, 2019 1:02:01 PM Department: Category Period Budget Period Actual Period Variance % YTD Budget YTID Actual YTD Variance % Annual % Budget INTEREST EXPENSE $0 $0 $0 0.0% $202,284 $464,585 ($262,301) $1,135,780 40.9% Total Expenses $0 $0 $0 0.0% $202,284 $464,585 ($262,301) -129.7% $1,135,780 40.9% Total Expenses $7,016,910 $6,972,076 $44,834 0.6% $45,474,466 $43,747,668 $1,726,798 3.8% $91,780,736 47.7% Color Key: 0 to 10%over budget > 10%over budget M Page 35 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:004-DEBT SERVICE December 2018 Fiscal Period 6/2019 Summarized by Account Report Generated on Jan 10,2019 12:54:27 PM TOTAL ASSETS Current Assets DUE FROM/DUE FROM RIE $3,528,591 DUE FROM/DUE FROM S/C $64,881 L.T.DEBT ACCOUNTING/DEPOSIT W/TRUSTEE-RESERVE $0 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $99,384 Current Assets $3,692,856 TOTAL ASSETS $3,692,856 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities DUE TO/DUE TO S/C ($3,281,476) L.T.DEBT ACCOUNTING/BOND ACR INTEREST PAYABLE $0 L.T.DEBT ACCOUNTING/BONDS PAYABLE ($19,450,000) Total Liabilities ($22,731,476) Total Fund Equity FUND EQUITY/AVAILABLE FUND BALANCE $24,673,496 FUND EQUITY/EXPENDITURE SUMMARY $464,585 LIABILITIES/DEFERRAL-BOND REFUNDING ($2,570,870) YEAR TO DATE REVENUES/REVENUE SUMMARY ($3,528,591) Total Fund Equity $19,038,620 TOTAL LIABILITIES AND FUND EQUITY ($3,692,856)