The URL can be used to link to this page

Home My WebLink About04.b. Review February 2019 Financial Statements and Investment Reports Page 1 of 37 Item 4.b. CENTRAL SAN March 26, 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 FEBRUARY2019 FINANCIAL STATEMENTS AND INVESTMENT REPORTS Attached for review are the Financial Statements and Investment Reports as of the date shown above. Operations and Maintenance (O&M) revenues are expected to be much closer to budget with the receipt of the second installment of Sewer Service Charge (SSC) in April; most of the favorable variance seen thus far is due primarily to a timing issue. Overall, SSC (allocated to both O&M and Sewer Construction) is expected to be $96.4 million versus the $95.1 million budgeted, a favorable variance of $1.3 million that will be allocated between O&M and Sewer Construction in an approximately 70%/30% split (as assumed in the Fiscal Year(FY) 2018-19 Budget). Thus, O&M revenues are expected to be about$900,000 above budget. The favorable variance has already been assumed in the rate model used as the basis for the proposed FY 2019-20 rate adjustment. Full-year O&M expenditures are also anticipated to be much closer to budget than the $2.07 million year- to-date variance seen through February. This assessment is based on the agency-wide current year projection undertaken as part of the FY 2019-20 Budget preparation process. Sewer Construction revenues are expected to be higher than budget due to the favorable SSC revenues noted above ($0.4 million) as well as about $1 million in net favorable variance from ad valorem revenue by year end. The spending outlook for sewer construction is still pending but, as is typical in recent years, the pace has been slower than planned, with spending $5.4 million lower than planned, and the expectation that spending will pick-up in the remaining months of the fiscal year. Debt Service (interest expense) expenditures are shown as over budget. This is due to the GASB 65 requirement to expense issuance costs (of approximately$250,000) in the year incurred. Actual interest expenses are below the budgeted amount due to the September 2018 refinancing. Strategic Plan Tie-In GOAL THREE:Be a Fiscally Sound and Effective Water Sector Utility Strategy 2- Manage costs March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 50 of 94 Page 2 of 37 ATTACHMENTS: 1. February 2019 Financial Statements and Investment Reports March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 51 of 94 J?2gQCj IGC3&SANITARY DISTRICT March 8,2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS C,-T-- FROM: AMAL LYON a95�1 SUBJECT: O&M Variance Analysis The following are brief year-to-date variance explanations through period ending February 28,2019: YTD YTD Fav/(Unfav) O&M Revenues: Budgeted Actual Variance Explanation First installment received was higher than budgeted. Percentage received varies Total $ 37,001,340 $ 43,101,950 $ 6,100,610 annually. O&M Expenses: Total Labor Charges $ 34,857,216 $ 34,628,006 $ 229,210 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 951,743 743,767 207,976 Chemicals are purchased sporadically throughout the year rather than monthly as is budgeted. The variance should be reduced by year-end. Utilities 2,502,783 2,492,046 10,737 Minor Variance Repairs&Maintenance 3,546,169 2,908,092 638,077 Lower due to budget spread over 12 months versus actual expense occurring sporadically throughout the year. Professional&Legal Services 561,808 458,899 102,909 Due to delay in legal and professional invoices. Outside Services 2,279,918 1,576,213 703,705 Mostly due to lower Technical Services than budgeted thus far in the fiscal year. Another main contributor is RSC Services/Xerox Corporation only paid through Oct.Various billing issues in Dispute. Other Expenses 2,188,163 1,741,769 446,394 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 8,723,982 9,031,577 (307,595) Variance due to UAAL vacancy. Budgeted vacancy is higher than actual vacancies thus far in the fiscal year. All Other 2,872,900 2,830,656 42,244 Minor variances for multiple account categories. Total $ 58,484,682 $ 56,411,025 $ 2,073,657 March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 52 of 94 Page 2 of 35 J&V lics entral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 001 - RUNNING EXPENSE(O&M) February 2019 Fiscal Period 8/2019 Report Generated on Mar 8, 2019 1:18:20 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 $8,267 3.3% $74,000 $66,100 -10.7% $929,000 $862,900 7.1% Other $400,664 $600,749 49.9% $2,784,012 $3,214,998 15.5% $4,123,000 $908,002 78.0% Sewer Service Charges $14,916 $13,164 -11.7% $34,143,328 $39,820,852 16.6% $67,073,732 $27,252,880 59.4% Total Revenue $423,580 $622,180 46.9% $37,001,340 $43,101,950 16.5% $86,925,732 $43,823,782 49.6% Page 3 of 35 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - District Summary MTD Fund: 001 - RUNNING EXPENSE (O&M) February 2019 Fiscal Period 0812019 Report Generated on Mar 8, 2019 1:30:18 PM $60,000,000.00 $58,482,682 Budget Actual $5 $56,411,026 1,37 $50,000,000.00- ,586,006 $44,52 $40,000,000.00 $37,53 592,870 ,666,108 $30,000,000.00 $30,2 ,064,083 $23,12 $20,000,000.00 $16,22 989,002 $10,000,000.00 $8,83 $8,238,746 $0.00- 11 Jul(1)2018 Aug(2)2018 Sep(3)2018 Oct(4)2018 Nov(5)2018 Dec(6)2018 Jan(7)2019 Feb(8)2019 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) February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:30:18 PM Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $2,964,217 $3,005,722 ($41,505) -1.4% $23,713,736 $23,438,539 $275,197 1.2% $35,571,037 65.9% EMPLOYEE BENEFITS $1,686,321 $1,706,540 ($20,219) -1.2% $13,796,568 $13,579,173 $217,395 1.6% $20,993,695 64.7% CAPITALIZED ADM OVERHEAD ($331,636) ($334,735) $3,099 -0.9% ($2,653,088) ($2,389,706) ($263,382) 9.9% ($3,979,723) 60.0% DIRECTOR FEES&EXPENSES $14,041 $13,646 $395 2.8% $112,328 $105,950 $6,378 5.7% $168,494 62.9% CHEMICALS $121,547 $23,294 $98,253 80.8% $951,743 $743,767 $207,976 21.9% $1,459,000 51.0% UTILITIES $345,206 $449,710 ($104,504) -30.3% $2,502,783 $2,492,046 $10,737 0.4% $4,142,550 60.2% REPAIRS&MAINTENANCE $427,431 $221,064 $206,367 48.3% $3,546,169 $2,908,092 $638,077 18.0% $5,414,644 53.7% HAULING&DISPOSAL $93,867 $57,956 $35,911 38.3% $602,936 $566,465 $36,471 6.0% $1,126,475 50.3% PROFESSIONAL&LEGAL SERV $69,601 $62,625 $6,976 10.0% $561,808 $458,899 $102,909 18.3% $845,300 54.3% OUTSIDE SERVICES $265,726 $204,046 $61,680 23.2% $2,279,918 $1,576,213 $703,705 30.9% $3,510,822 44.9% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $779,500 $779,500 $0 0.0% $779,500 100.0% MATERIALS&SUPPLIES $175,642 $123,579 $52,063 29.6% $1,378,136 $1,378,741 ($605) 0.0% $2,108,126 65.4% OTHER EXPENSES $378,551 $327,122 $51,429 13.6% $2,186,163 $1,741,769 $444,394 20.3% $2,777,258 62.7% UNFUNDED LIABILITIES $893,356 $964,450 ($71,094) -8.0% $8,723,982 $9,031,577 ($307,595) -3.5% $14,803,278 61.0% Total Expenses $7,103,870 $6,825,020 $278,850 3.9% $58,482,682 $56,411,026 $2,071,656 3.5% $89,720,456 62.9% 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) February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM $2,500,000 ❑Period Budget $20,000,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $2,000,000 $15,000,000 $1,500,000 $10,000,000 $1,000,000 $5,000,000 $500,000- $0- $0 500,000$0 $0 °e� S�Pov �\s��o �`�\Go �\o ��0Q�Q��Q 5yovlp '� Q � Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance ADMINISTRATION $2,028,015 $1,744,920 $283,095 $17,413,983 $15,736,000 $1,677,983 ENGINEERING $1,366,132 $1,348,251 $17,881 $11,402,079 $11,231,180 $170,899 COLLECTION SYSTEM OPS. $1,162,280 $1,187,696 ($25,416) $9,194,741 $9,203,415 ($8,674) PLANT OPERATIONS $2,173,526 $2,221,879 ($48,353) $17,552,075 $17,626,012 ($73,937) PUMP STATIONS $244,538 $226,543 $17,995 $1,897,438 $1,834,416 $63,022 RECYCLED WATER $129,379 $95,730 $33,649 $1,022,366 $780,003 $242,363 Totals $7,103,870 $6,825,020 $278,850 $58,482,682 $56,411,026 $2,071,656 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) February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM Department: ADMINISTRATION Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $611,365 $600,728 $10,637 1.7% $4,890,920 $4,537,076 $353,844 7.2% $7,336,515 61.8% EMPLOYEE BENEFITS $652,688 $608,824 $43,864 6.7% $5,527,504 $5,107,770 $419,734 7.6% $8,588,771 59.5% CAPITALIZED ADM OVERHEAD ($4,147) ($3,178) ($969) 23.4% ($33,176) ($21,336) ($11,840) 35.7% ($49,764) 42.9% DIRECTOR FEES&EXPENSES $14,041 $13,646 $395 2.8% $112,328 $105,950 $6,378 5.7% $168,494 62.9% UTILITIES $10,816 $4,962 $5,854 54.1% $86,528 $79,046 $7,482 8.6% $129,800 60.9% REPAIRS&MAINTENANCE $70,592 ($73,942) $144,534 204.7% $789,956 $558,879 $231,077 29.3% $1,132,390 49.4% PROFESSIONAL&LEGAL SERV $53,271 $50,784 $2,487 4.7% $431,168 $363,723 $67,445 15.6% $649,300 56.0% OUTSIDE SERVICES $119,355 $78,585 $40,770 34.2% $1,014,674 $619,508 $395,166 38.9% $1,647,300 37.6% SELF-INSURANCE EXPENSE $0 $0 $0 0.0% $779,500 $779,500 $0 0.0% $779,500 100.0% MATERIALS&SUPPLIES $16,329 ($438) $16,767 102.7% $130,632 $72,041 $58,591 44.9% $196,025 36.8% OTHER EXPENSES $307,336 $277,064 $30,272 9.8% $695,863 $548,864 $146,999 21.1% $960,040 57.2% UNFUNDED LIABILITIES $176,369 $187,885 ($11,516) -6.5% $2,988,086 $2,984,978 $3,108 0.1% $6,199,286 48.2% ADMINISTRATION Total Expenses $2,028,015 $1,744,920 $283,095 14.0% $17,413,983 $15,736,000 $1,677,983 9.6% $27,737,657 56.7% 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) February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM Department: ENGINEERING Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $833,166 $838,716 ($5,550) -0.7% $6,665,328 $6,728,487 ($63,159) -0.9% $9,998,042 67.3% EMPLOYEE BENEFITS $329,253 $358,240 ($28,987) -8.8% $2,634,024 $2,772,479 ($138,455) -5.3% $3,951,391 70.2% CAPITALIZED ADM OVERHEAD ($296,790) ($310,470) $13,680 -4.6% ($2,374,320) ($2,197,863) ($176,457) 7.4% ($3,561,499) 61.7% UTILITIES $14,432 $20,806 ($6,374) -44.2% $115,456 $121,823 ($6,367) -5.5% $173,200 70.3% REPAIRS&MAINTENANCE $14,281 $3,699 $10,582 74.1% $114,248 $49,129 $65,119 57.0% $171,400 28.7% HAULING&DISPOSAL $44,867 $25,031 $19,836 44.2% $210,936 $253,673 ($42,737) = $538,425 47.1% PROFESSIONAL&LEGAL SERV $14,248 $11,208 $3,040 21.3% $113,984 $73,008 $40,976 35.9% $171,000 42.7% OUTSIDE SERVICES $96,931 $64,830 $32,101 33.1% $882,390 $558,719 $323,671 36.7% $1,270,142 44.0% MATERIALS&SUPPLIES $32,915 $27,325 $5,590 17.0% $263,320 $195,389 $67,931 25.8% $395,050 49.5% OTHER EXPENSES $19,379 $24,963 ($5,584) -28.8% $669,113 $448,446 $220,667 33.0% $764,812 58.6% UNFUNDED LIABILITIES $263,450 $283,903 ($20,453) -7.8% $2,107,600 $2,227,890 ($120,290) -5.7% $3,161,443 70.5% ENGINEERING Total Expenses $1,366,132 $1,348,251 $17,881 1.3% $11,402,079 $11,231,180 $170,899 1.5% $17,033,406 65.9% 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) February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM Department: COLLECTION SYSTEM OPS. Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $522,693 $547,728 ($25,035) -4.8% $4,181,544 $4,236,662 ($55,118) -1.3% $6,272,384 67.5% EMPLOYEE BENEFITS $255,254 $268,662 ($13,408) -5.3% $2,042,032 $2,082,707 ($40,675) -2.0% $3,063,394 68.0% CAPITALIZED ADM OVERHEAD ($2,676) ($323) ($2,353) 87.9% ($21,408) ($25,384) $3,976 = ($32,120) 79.0% UTILITIES $12,115 $7,871 $4,244 35.0% $96,920 $97,168 ($248) -0.3% $145,400 66.8% REPAIRS&MAINTENANCE $122,873 $114,617 $8,256 6.7% $884,485 $733,823 $150,662 17.0% $1,474,504 49.8% HAULING&DISPOSAL $10,916 $9,798 $1,118 10.2% $87,328 $49,369 $37,959 43.5% $131,000 37.7% PROFESSIONAL&LEGAL SERV $625 $248 $377 60.2% $5,000 $1,491 $3,509 70.2% $7,500 19.9% OUTSIDE SERVICES $4,972 $15,672 ($10,700) -215.2% $39,776 $44,057 ($4,281) 1 $59,680 73.8% MATERIALS&SUPPLIES $63,074 $45,208 $17,866 28.3% $487,592 $550,430 ($62,838) $756,951 72.7% OTHER EXPENSES $10,529 $6,248 $4,281 40.7% $96,232 $84,819 $11,413 11.9% $138,445 61.3% UNFUNDED LIABILITIES $161,905 $171,966 ($10,061) -6.2% $1,295,240 $1,348,273 ($53,033) -4.1% $1,942,922 69.4% COLLECTION SYSTEM OPS.Total $1,162,280 $1,187,696 ($25,416) -2.2% $9,194,741 $9,203,415 ($8,674) -0.1% $13,960,060 65.9% 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) February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM Department: PLANT OPERATIONS Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $869,326 $897,452 ($28,126) -3.2% $6,954,608 $6,967,920 ($13,312) -0.2% $10,432,017 66.8% EMPLOYEE BENEFITS $380,506 $404,414 ($23,908) -6.3% $3,044,048 $3,119,182 ($75,134) -2.5% $4,566,639 68.3% CAPITALIZED ADM OVERHEAD ($28,023) ($20,764) ($7,259) 25.9% ($224,184) ($145,124) ($79,060) 35.3% ($336,340) 43.1% CHEMICALS $93,715 $20,304 $73,411 78.3% $749,920 $619,711 $130,209 17.4% $1,125,000 55.1% UTILITIES $250,215 $344,835 ($94,620) -37.8% $1,780,888 $1,814,306 ($33,418) -1.9% $3,002,600 60.4% REPAIRS&MAINTENANCE $186,609 $167,969 $18,640 10.0% $1,492,872 $1,361,773 $131,099 8.8% $2,239,400 60.8% HAULING&DISPOSAL $37,351 $22,392 $14,959 40.0% $298,808 $256,461 $42,347 14.2% $448,250 57.2% PROFESSIONAL&LEGAL SERV $291 $248 $43 14.6% $2,328 $1,631 $697 29.9% $3,500 46.6% OUTSIDE SERVICES $19,912 $35,978 ($16,066) -80.7% $159,296 $226,942 ($67,646) $239,000 95.0% MATERIALS&SUPPLIES $58,871 $51,014 $7,857 13.3% $460,968 $540,751 ($79,783) $706,600 76.5% OTHER EXPENSES $35,534 $8,857 $26,677 75.1% $678,771 $618,668 $60,103 8.9% $844,615 73.2% UNFUNDED LIABILITIES $269,219 $289,180 ($19,961) -7.4% $2,153,752 $2,243,791 ($90,039) -4.2% $3,230,674 69.5% PLANT OPERATIONS Total Expenses $2,173,526 $2,221,879 ($48,353) -2.2% $17,552,075 $17,626,012 ($73,937) -0.4% $26,501,955 66.5% 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) February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM Department: PUMP STATIONS Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $80,539 $86,427 ($5,888) -7.3% $644,312 $677,316 ($33,004) -5.1% $966,479 70.1% EMPLOYEE BENEFITS $33,186 $41,779 ($8,593) -25.9% $265,488 $296,783 ($31,295) = $398,256 74.5% CAPITALIZED ADM OVERHEAD $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% CHEMICALS $20,833 $0 $20,833 100.0% $145,831 $61,841 $83,990 57.6% $250,000 24.7% UTILITIES $43,045 $51,496 ($8,451) -19.6% $306,327 $328,313 ($21,986) -7.2% $516,550 63.6% REPAIRS&MAINTENANCE $30,661 $8,722 $21,939 71.6% $245,288 $193,544 $51,744 21.1% $367,950 52.6% HAULING&DISPOSAL $733 $735 ($2) -0.3% $5,864 $6,962 ($1,098) = $8,800 79.1% OUTSIDE SERVICES $6,683 $3,780 $2,903 43.4% $53,464 $12,850 $40,614 76.0% $80,200 16.0% MATERIALS&SUPPLIES $3,466 $470 $2,996 86.4% $27,728 $12,985 $14,743 53.2% $41,600 31.2% OTHER EXPENSES $2,979 $1,619 $1,360 45.7% $23,832 $17,177 $6,655 27.9% $35,796 48.0% UNFUNDED LIABILITIES $22,413 $31,516 ($9,103) -40.6% $179,304 $226,646 ($47,342) = $268,953 84.3% PUMP STATIONS Total Expenses $244,538 $226,543 $17,995 7.4% $1,897,438 $1,834,416 $63,022 3.3% $2,934,584 62.5% 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) February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM Department: RECYCLED WATER Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget SALARIES&WAGES $47,128 $34,672 $12,456 26.4% $377,024 $291,078 $85,946 22.8% $565,600 51.5% EMPLOYEE BENEFITS $35,434 $24,621 $10,813 30.5% $283,472 $200,251 $83,221 29.4% $425,244 47.1% CHEMICALS $6,999 $2,990 $4,009 57.3% $55,992 $62,214 ($6,222) = $84,000 74.1% UTILITIES $14,583 $19,740 ($5,157) -35.4% $116,664 $51,392 $65,272 55.9% $175,000 29.4% REPAIRS&MAINTENANCE $2,415 $0 $2,415 100.0% $19,320 $10,944 $8,376 43.4% $29,000 37.7% PROFESSIONAL&LEGAL SERV $1,166 $136 $1,030 88.3% $9,328 $19,047 ($9,719) = $14,000 136.1% OUTSIDE SERVICES $17,873 $5,201 $12,673 70.9% $130,318 $114,137 $16,181 12.4% $214,500 53.2% MATERIALS&SUPPLIES $987 $0 $987 100.0% $7,896 $7,145 $751 9.5% $11,900 60.0% OTHER EXPENSES $2,794 $8,370 ($5,576) -199.6% $22,352 $23,796 ($1,444) -6.5% $33,550 70.9% RECYCLED WATER Total Expenses $129,379 $95,730 $33,649 26.0% $1,022,366 $780,003 $242,363 23.7% $1,552,794 50.2% 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 FEBRUARY,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) 8,000,000 $14,000,000 (6,000,000) 8,000,000 8,038,168 24.24% 22,917.81 182,202.07 205,119.88 RE05 US Gov't FHLMC 08/31/18 03/04/19 5 2.266% 4,943,215 5,000,000 5,000,000 5,000,000 15.15% 8,594.44 47,269.44 55,863.88 RE07 FHLB FED AGENCY 12/24/18 03/22/19 24 2.424% 4,970,544 5,000,000 5,000,000 4,993,050 15.15% 9,372.22 13,054.17 22,426.39 RE08 FHLB FED AGENCY 12/24/18 03/21/19 20 2.448% 4,971,000 5,000,000 5,000,000 4,993,400 15.15% 9,333.33 13,000.00 22,333.33 RE09 FHLB FED AGENCY 12/24/18 7/22/19 143 2.558% 4,927,375 5,000,000 5,000,000 4,950,950 15.15% 9,683.33 13,487.50 23,170.83 RE10 FHLB FED AGENCY 12/24/18 7/23/19 144 2.558% 4,927,029 5,000,000 5,000,000 4,950,600 15.15% 9,683.33 13,487.50 23,170.83 (3) 32,739,164 39,000,000 (6,000,000) 33,000,000 32,926,168 100.00% 69,584.46 282,500.68 352,085.14 (2) 58,783.18 58,783.18 69,584.46 341,283.86 410,868.32 NOTE:(1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of February,2019 was 2.39%. (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.4361%. (4) The market value of the portfolio on February,2019 was$32,926,168. (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. March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 63 of 94 Page 13 of 35 ' Central Contra Costa sanitary District Balance Sheet Fund:001-RUNNING EXPENSE(O&M) February 2019 Fiscal Period 8/2019 Summarized by Account Report Generated on Mar 8,2019 1:26:47 PM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $891,070 CASH ACCOUNTS/PAYROLL CLEARING $20,000 CASH ACCOUNTS/PETTY CASH $3,400 CASH ACCOUNTS/TEMPORARY INVESTMENTS $33,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 $31,932,321 DUE FROM/DUE FROM S/I $787,145 INVENTORY/SUPPLIES&MATERIAL INV $2,159,623 PREPAID ACCOUNTS/PREPAID CAFETERIA PLAN $46,104 PREPAID ACCOUNTS/PREPAID COMMUTER PLAN $572 PREPAID ACCOUNTS/PREPAID EXPENSES $1,006,109 PREPAID ACCOUNTS/PREPAID INSURANCE $3,822 PREPAID ACCOUNTS/PREPAID RETIREMENT $8,608,639 RECEIVABLE ACCOUNTS/A/R-SSC DIRECT BILL $129,668 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $421,512 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE-COBRA $1,837 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $54,859 RECEIVABLE ACCOUNTS/COMPUTER PURCHASE PROGRAM $11,599 RECEIVABLE ACCOUNTS/DEPOSITS TO BANK ESCROW $100,640 RECEIVABLE ACCOUNTS/OVERTIME INSPECTION A/R $1,879 Current Assets $100,714,219 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 $753,116,560 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($16,281) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($624,838) CURRENT LIABILITIES/ACCRUED COMPENSATED ABS. ($4,448,044) CURRENT LIABILITIES/ACCRUED WAGES PAYABLE ($1,198,082) Page 14 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:001-RUNNING EXPENSE(O&M) February 2019 Fiscal Period 8/2019 Summarized by Account Report Generated on Mar 8,2019 1:26:47 PM CURRENT LIABILITIES/CAFETERIA PLAN PAYABLE ($17,684) CURRENT LIABILITIES/COMMUTER PLAN PAYABLE ($698) CURRENT LIABILITIES/MISC DEPOSITS/LIABILITIES ($139,931) CURRENT LIABILITIES/OTHER PAYROLL WITHHOLDING ($7,596) CURRENT LIABILITIES/PERMIT CLEARING ($91) CURRENT LIABILITIES/REFUNDABLE DEPOSITS ($41,080) CURRENT LIABILITIES/RETIREMENT CONTRIB W/H ($1,484,072) CURRENT LIABILITIES/WORKERS'COMP INS PAYABLE $131,687 DEF.COMP.CONTRIB W/H/ICMA $0 DUE TO/DUE TO DEBT FUND ($3,528,591) DUE TO/DUE TO S/C ($23,603,765) 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 $6,578,807 LIABILITIES/UNEARNED INTEREST ($113,871) MEDICAL LIABILITIES/DELTA DENTAL $349 MEDICAL LIABILITIES/DISABILITY INS $482 MEDICAL LIABILITIES/HEALTH NET $4,316 MEDICAL LIABILITIES/KAISER PERMANENTE $137 MEDICAL LIABILITIES/LIFE INS $27 MEDICAL LIABILITIES/OCCUPATIONAL HEALTH $1,068 MEDICAL LIABILITIES/POST EMP.BENEFIT-OPEB $263,800 PAYROLL TAXES WITHHELD/CALIFORNIA WITHHOLDING $368 PAYROLL TAXES WITHHELD FEDERAL WITHHOLDING $792 REIMBURSEMENT FEES ($54,466) Total Liabilities ($167,313,755) 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 $56,411,026 FUND EQUITY/GENERAL FIXED ASSET GROUP ($210,549,556) FUND EQUITY/STATE R FED CAPITAL GRANT ($75,301,279) YEAR TO DATE REVENUES/REVENUE SUMMARY ($43,101,950) Total Fund Equity ($585,802,805) TOTAL LIABILITIES AND FUND EQUITY ($753,116,560) Page 15 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT March 8, 2019 TO: THE BOARD OF DIRECTORS VIA: CHRIS THOMAS SOT' FROM: AMAL LYON 4 SUBJECT: Sewer Construction Variance Analysis The following are brief year-to-date variance explanations through period ending February 28,2019: YTD YTD Fav/(Unfav) S/C Revenues: Budgeted Actual Variance Explanation SSC& Property tax revenue received from the County Total $ 23,820,648 $28,472,557 $ 4,651,909 was higher than budgeted. FY YTD FY S/C Expenses: Budget" Actual Remaining %Spent Total $ 52,287,827 $23,808,150 $ 28,479,677 45.53% Includes 17/18 carry-over($6.968.827) March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 66 of 94 Page 16 of 35 AIMILSentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 002-SEWER CONSTRUCTION (Capital) February 2019 Fiscal Period 8/2019 Report Generated on Mar 8, 2019 1:18:20 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 $625,581 $765,401 22.4% $9,857,648 $11,890,396 20.6% $20,813,000 $8,922,604 57.1% Sewer Service Charges $0 $5,482 0.0% $13,963,000 $16,582,161 18.8% $27,926,268 $11,344,107 59.4% Total Revenue $625,581 $770,883 23.2% $23,820,648 $28,472,557 19.5% $55,889,268 $27,416,711 50.9% Page 17 of 35 Sewer Fund(Capital)Spending FY 18-19 $35,000,000 $29,197,153 $30,000,000 $23,890,698 $26,513,645 $25,000,000 $19,397,124 $23,808,150 $20,000,000 — $20,736,779 $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,0001.426.829 $8,485,345 $_ $ $1,600,939 3,404,835 July August September October November December January February —Projected* —Actual Columnl ugust September lOctober lNovember IDecember lianuary IFebruary 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 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 *Projected-Current year budget allocated by month based on historical spending in previous 2 years March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 68 of 94 Page 18 of 35 PROGRAM/GM1851.4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 2/28/2019 PERIOD 8/2019 A C(A-B) D E F(D+E) G(C+D+E) I(F-G) PROJECT TOTAL TOTAL FY 2018-19 BUDGET ADJUSTED APPROVED TOTAL TOTAL PROD 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 12,592,168 5,922,565 TYPE TP Treatment Plant 32,746,274 26,758,622 5,987,652 16,865,000 1,231,177 18,096,177 24,083,829 9,225,677 14,858,156 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,191,164 4,149,753 TYPE RW Recycled Water 2,382,894 1,769,035 613,859 2,857,000 2,857,000 3,470,859 799,141 2,671,722 CIB Contingency - - 1,500,000 (622,500) 877,500 877,500 - 877,500 TOTAL DISTRICT EL$ 73,563,322 $ ,827 $ 45,319,000 M,150 $ 28,479,696 N:\Accounting\GMTEMPI\Financials and Closing\2019 Financials\Capital Project report-FY 18 19.xlsx Feb 19 March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 69 of 94 Page 19 of 35 PROGRAM/GM185L4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 2/28/2019 PERIOD 8/2019 A C(A-B) D E F(D+E) G(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 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 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 59,129 740,871 6602 South Jackson CAD 411,290 391,290 20,000 - 20,000 - 20,000 6603 North Jackson CAD 400,000 - 400,000 (123,443) (123,443) 276,557 31,372 245,185 ****6679 Coredell Drive CAD - 123,443 123,443 123,443 (13,277) 136,720 **7367 Concord Main Metering Station - 250,000 250,000 250,000 5,526 244,474 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 179,070 (140,429) 8419 Collection System Planning LT 885,000 884,387 613 100,000 100,000 100,613 73,666 26,947 *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,519,540 134,743 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,641,977 16,901 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,131,272 1,477,712 8441 CIPP Contract 17-20 300,000 80,247 219,753 100,000 100,000 319,753 162,277 157,476 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 9,388 234,819 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,456,525 141,795 8446 Lafayette Sewer Renovation Phase 12 636,000 1,216,107 (580,107) 3,397,600 3,397,600 2,817,493 2,487,342 330,151 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 40,175 103,064 8450 Development Sewerage Support 400,000 240,770 159,230 250,000 250,000 409,230 320,632 88,598 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 296,667 203,333 *8453 Willows Sewer Repair 98,000 98,000 - - - - ***8454 So.Orinda Sewer Ren.Ph.7 - 500,000 500,000 500,000 428,466 71,534 ***8455 W.C.Sewer Renov.Ph.13 500,000 500,000 500,000 484,654 15,346 ***8456 Danville Sewer Ren.Ph.3 - - 500,000 500,000 500,000 147,568 352,432 8457 Pump Station Upgrades-Ph.2 - 50,000 50,000 50,000 - 50,000 Rounding 13 otal FY 2018-19 CS Amount 29,409,4 30,841,697 (1,432,280 19,347,000 600,000 19,947,000 18,514,720 12,592,168 5,92 , *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 N:\Accounting\GMTEMPI\Financials and Closing\2019 Financials\Capital Project report-FY 18 19.xlsx Feb 19 March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 70 of 94 Page 20 of 35 PROGRAM/GM1851.4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 2/28/2019 PERIOD 8/2019 A C(A-B) D E F(D+E) G(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 I PYS(THRU FYE 17-18)1 PYS(THRU FYE 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 ILPE TP Treatment PI 7291 Pump&Blower Bldg.Seismic Upgrade 6,692,000 6,638,700 53,300 - 53,300 10,393 42,907 7292 Switchgear Refurbishment-Ph.2 770,000 433,911 336,089 200,000 200,000 536,089 32,688 503,401 7304 Instr&Controls PLC Upgrade 575,000 397,606 177,394 110,000 110,000 287,394 70,056 217,338 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,228 186,538 7320 Plant Energy Optimization 1,094,000 1,063,448 30,552 - 30,552 (59,251) 89,803 7322 Fire Protection System Ph.2 1,406,000 1,014,803 391,197 - 391,197 307,996 83,201 7326 Equipment Replacement FY 15-FY 24 1,166,000 748,217 417,783 250,000 250,000 667,783 766,687 (98,904) 7327 Headwork's Screening Upgrade 8,144,000 7,845,455 298,545 76,000 76,000 374,545 118,982 255,563 7328 Influent Pump Electrical improvements 100,000 757 99,243 510,000 510,000 609,243 166,548 442,695 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,262,605 403,451 7339 T.Plant Control System I/O Replacement 470,000 605,231 (135,231) 900,000 900,000 764,769 72,972 691,797 7341 WC/Grayson Creek Levee Rehab 100,000 - 100,000 - 100,000 28,602 71,398 7348 Solids Handling Facility Improvements 4,975,000 4,516,007 458,993 5,715,000 5,715,000 6,173,993 2,230,063 3,943,930 7349 Aeration&Energy Upgrade 300,000 35,539 264,461 1,200,000 1,200,000 1,464,461 161,951 1,302,510 7351 Mechanical&Concrete Renovation 1,300,000 1,254,155 45,845 3,000,000 3,000,000 3,045,845 844,122 2,201,723 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,813 112,192 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 36,734 225,978 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 889,007 221,616 7360 Existing Plant Facility Drawing 100,000 83,040 16,960 100,000 - 100,000 116,960 31,723 85,237 7362 POB Seismic Upgrades 400,000 135,591 264,409 1,100,000 1,831,177 2,931,177 3,195,586 780,511 2,415,075 7363 Treatment Plant Planning 450,000 348,907 101,093 450,000 - 450,000 551,093 253,212 297,881 7364 TP Safety Enhancement Ph.5 - - - 100,000 - 100,000 100,000 - 100,000 Rounding 4 otal FY 2017-18 TP Amount 32,746,274 8,622 5,987,652 16,865,000 1,231,177 18,096,177-"Illff 24,083,829 9,225,677 14,858,156 *Italic Projects open but not in CIB for 18/19 N:\Accounting\GMTEMPI\Financials and Closing\2019 Financials\Capital Project report-FY 18 19.xlsx Feb 19 March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 71 of 94 Page 21 of 35 PROGRAM/GM1851.4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 2/28/2019 PERIOD 8/2019 A C(A-B) D E F(D+E) G(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 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 PE GI General Improvement 8207 General Security and Access $ 194,616 121,661 72,955 500,000 (559,641) (59,641) 13,314 13,313 1 8230 Capital Legal Services 158,665 132,070 26,595 20,000 20,000 46,595 10,191 36,404 8236 District Easements 208,047 164,616 43,431 50,000 50,000 93,431 47,855 45,576 8238 Asset Management 2,969,185 2,790,236 178,949 400,000 400,000 578,949 414,576 164,373 8240 IT Development 2,188,794 2,187,431 1,363 1,750,000 (450,000) 1,300,000 1,301,363 187,794 1,113,569 8243 Server Room Relocation 955,430 515,656 439,774 880,000 164,570 1,044,570 1,484,344 300,847 1,183,497 8247 Property&Building Improvements 400,000 178,767 221,233 300,000 (363,606) (63,606) 157,627 154,060 3,567 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,700 1,197,341 9999 Capital Project Clearing(Accounting Use Only)** - (60,000) 60,000 - 60,000 (2) 60,002 Rounding (2) otal FY 2017-18 GI Amoun 9,024,737 1,7 4,750,000 ) 3,541,323 5,340,919 1,1 4,149,-/W N:\Accounting\GMTEMPI\Financials and Closing\2019 Financials\Capital Project report-FY 18 19.xlsx Feb 19 March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 72 of 94 Page 22 of 35 PROGRAM/GM1851.4-Modified in Excel CAPITAL IMPROVEMENT BUDGET REPORT ACCOUNTING CENTRAL CONTRA COSTA SANITARY DISTRICT PERIOD ENDING: 2/28/2019 PERIOD 8/2019 A C(A-B) D E F(D+E) G(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 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 RW Recycled Wat 7306 Zone 1 Recycled Water 497,894 484,984 12,910 35,000 - 35,000 47,910 9,772 38,138 7346 Surge Analysis 16-17 155,000 3,125 151,875 50,000 50,000 201,875 105,272 96,603 7361 Filter Plant Improvments 330,000 162,293 167,707 2,457,000 2,457,000 2,624,707 558,299 2,066,408 7365 Recycle Water Clearwell Repairs 1,400,000 1,118,633 281,367 300,000 300,000 581,367 125,798 455,569 7366 ReW Distribution System Renov.Program - - 15,000 15,000 15,000 - 15,000 Rounding 4 otal FY 2016-17 RW Amount $ 2,382,894 1,769,035 613,859 2,857,000 2,857,000 3,470,859 799,141 2,EL70 9990 CONTINGENCY-ALL PROGRAMS - - - 1,500,000 (622,500) 877,500 877,500 877,500 RAND TOTAL $ 73,563,322 66,594,495 6,968,827 45,319,000 45,319,000 52,287,827 23,808,150 28,479,696 N:\Accounting\GMTEMPI\Financials and Closing\2019 Financials\Capital Project report-FY 18 19.xlsx Feb 19 March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 73 of 94 Page 23 of 35 FY 18-19 CAPITAL BUDGET TRANSFERS PERIOD ENDING:2/28/19 Position Paper Position Paper Memo to GM Position Paper Position Paper approved 10/4/19 item 2 11/15 Item 10 11/1 item 7 & 12/20 item 7 09/05/18 &Depaty GM &GM 12/12 GM 12/19 1&GM 18/19 Contingency 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 Pro'. - - - 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 Tota * Not actual transfers. All part of one project split into individual projects for construction March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 74 of 94 Page 24 of 35 O&M PROJECTS- EXPENDITURE LIST ACCOUNTING PERIOD ENDING: 02/28/19 PERIOD 07/2019 OM043 - Naval Weapons Station Prior years Project expended Expenditure type through 17-18 1 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 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 92,462 OM080 - CoCo Farm(Kiewit Future Farm Proposal) Prior years Project expended Expenditure type I through 17-18 1 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 $ 3,391 $ 6,368 $ - $ - $ - $ - $ 24,399 $ 48,047 other Charges $ - - - - - - - - - - $ - $ - Total $ 23,648 $ 2,746 $ 1,540 $ 2,411 $ 2,324 $ 1,549 $ 4,069 $ 3,391 $ 6,368 $ $ $ $ $ 24,399 $ 48,047 N:\Accounting\GMTEMPI\Financials and Closing\2019 Financials\O&M Projects Activity YTD 18 19.xlsx March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 75 of 94 Page 25 of 35 CENTRAL CONTRA COSTA SANITARY DISTRICT SEWER CONSTRUCTION FUND TEMPORARY INVESTMENTS FEBRUARY,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) $13,500,000 $13,500,000 $13,500,000 $13,564,408 26.21°% $24,751.23 $128,604.71 $153,355.94 933 US Gov't Agency Dscnt 06/08/18 05/28/19 90 2.32 4,956,560 5,000,000 5,000,000 4,986,550 9.71% $3,435.95 $26,256.37 $29,692.32 935 US Gov't Treasury Bill 08/31/18 02/28/19 0 2.56 3,955,756 4,000,000 (4,000,000) 0 0 0.00°% $6,600.00 $37,644.44 $44,244.44 936 Toyota Motor CP 09/06/18 03/04/19 5 2.43 3,952,267 4,000,000 4,000,000 3,998,920 7.77% $7,466.67 $39,466.68 $46,933.35 937 FHLB Fed Agency 09/06/18 03/06/19 7 2.30 4,943,689 5,000,000 5,000,000 4,998,350 9.71°% $8,711.11 $46,044.43 $54,755.54 938 FHLMC FHLMC 12/06/18 6/03/19 94 2.57 4,937,847 5,000,000 5,000,000 4,968,150 9.71% $9,722.22 $19,791.67 $29,513.89 938A FHLB Fed Agency 12/21/18 3/20/19 19 2.45 4,970,333 5,000,000 5,000,000 4,993,700 9.71°% $9,333.33 $14,000.00 $23,333.33 939 FHLB Fed Agency 12/21/18 04/02/19 32 2.48 4,965,646 5,000,000 5,000,000 4,989,300 9.71% $9,430.56 $14,145.83 $23,576.39 940 US Gov't T-Bill 12/21/18 06/20/19 111 2.52 4,938,284 5,000,000 5,000,000 4,963,050 9.71°% $9,547.22 $14,320.83 $23,868.05 941 US Gov't T-Bill 2/28/19 8/29/19 181 2.49 3,950,860 0 4,000,000 4,000,000 3,950,880 7.77°% $270.00 $0.00 $270.00 (4) $55,071,241 $51,500,000 $0 $51,500,000 $51,413,308 100.00°% $89,268.29 $340,274.96 $429,543.25 (3) (5) $149,695.19 $149,695.19 $89,268.29 $489,970.15 $579,238.44 NOTE: (1) Annual Yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of February 2019 was 2.390%. (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.4348%. (4) The market value of the portfolio on February 28,2019 was$51,413,308. 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. March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 76 of 94 Page 26 of 35 ' Central Contra Costa sanitary District Protecting public health and the environment Balance Sheet Fund:002-SEWER CONSTRUCTION(Capital) February 2019 Fiscal Period 8/2019 Summarized by Account Report Generated on Mar 8,2019 1:26:47 PM TOTAL ASSETS Current Assets CAD RECEIVABLE/AVAD-ALHAMBRA VLY AR $820,003 CASH ACCOUNTS/CASH $266,283 CASH ACCOUNTS/TEMPORARY INVESTMENTS $51,500,000 DUE FROM/DUE FROM DEBT FUND $3,685,382 DUE FROM/DUE FROM RIE $23,603,765 RECEIVABLE ACCOUNTS/ACCOUNTS RECEIVABLE $60,483 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $70,550 RECEIVABLE ACCOUNTS/CAD RECEIVABLE $162,781 Current Assets $80,169,246 Net Property,Plant and Equipment FIXED ASSETS-C.I.P./CONSTRUCTION IN PROGRESS $23,808,112 Net Property,Plant and Equipment $23,808,112 TOTAL ASSETS $103,977,358 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities ACCOUNTS PAYABLE/SALES TAX PAYABLE ($13,396) CURRENT LIABILITIES/ACCOUNTS PAYABLE ($613,629) CURRENT LIABILITIES/PROJECT RETENTION PAYABLE ($1,414,065) CURRENT LIABILITIES/REFUNDABLE CONST BONDS ($308,149) DUE TO/DUE TO DEBT FUND ($67,318) DUE TO/DUE TO RIE ($31,932,321) LIABILITIES/UNEARNED INTEREST ($149,622) Total Liabilities ($34,498,500) Total Fund Equity EXPENDITURE SUMMARY/TRANSFER TO CIP ($23,808,112) FUND EQUITY/AVAILABLE FUND BALANCE ($41,006,302) FUND EQUITY/EXPENDITURE SUMMARY $23,808,112 YEAR TO DATE REVENUES/REVENUE SUMMARY ($28,472,557) Total Fund Equity ($69,478,859) TOTAL LIABILITIES AND FUND EQUITY ($103,977,358) Page 27 of 35 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 003-SELF-INSURANCE February 2019 Fiscal Period 8/2019 Report Generated on Mar 8, 2019 1:18:20 PM Category MTD Estimate MTD Actual MTD%Rev YTD Estimate YTD Actual YTD%Rev Annual Estimate Unrealized Balance Annual%Rev Other $9,645 $13,349 38.4% $856,660 $892,398 4.2% $960,250 567,852 92.9% Total Revenue $856,660 $892,398 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 February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM $30,000 ❑Period Budget $1,000,000 ❑ YTD Budget ❑Period Actual ❑ YTD Actual $25,000 $800,000- $20,000- $600,000- $15,000- $400,000- $10,000-, 800,000$20,000 $600,000$15,000 $400,000$10,000 $200,000- $5,000-1 $0 $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $29,540 $10,944 $18,596 $806,320 $722,183 $84,137 Totals $29,540 $10,944 $18,596 $806,320 $722,183 $84,137 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 February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM Department: Category Period Budget Period Actual Period Variance % YTD Budget YTD Actual YTD Variance % Annual % Budget INSURANCE&OTHER EXP $791 $9,427 ($8,636) -1,091.8% $576,328 $603,082 ($26,754) -4.6% $579,500 104.1% GENERAL&AUTO LIABILITY $28,749 $1,516 $27,233 94.7% $229,992 $119,101 $110,891 48.2% $345,000 34.5% EMP RELATED&POLLUTION $0 $0 $0 0.0% $0 $0 $0 0.0% $0 0.0% Total Expenses $29,540 $10,944 $18,596 63.0% $806,320 $722,183 $84,137 10.4% $924,500 78.1% 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 FEBRUARY,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 7,200,000 7,234,351 100.00% 13,200.66 88,777.98 101,978.64 (3) 7,200,000 7,200,000 7,200,000 7,234,351 100.00% 13,200.66 88,777.98 101,978.64 (2) 5,942.55 5,942.55 13,200.66 94,720.53 107,921.19 NOTE: (1) Annual yield of Local Agency Investment Fund(LAIF)varies with the composition of the Fund. The estimated yield as of February,2019 was 2.390%. (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.39%. (4) The market value of the portfolio on January 31,2019 was$7,231,635. COMPLIANCE STATEMENT: All investments comply with the District's internal investment policy approved by the Board of Directors. March 26, 2019 Regular FINANCE Committee Meeting Agenda Packet- Page 81 of 94 Page 31 of 35 ' Central Contra Costa sanitary District Balance Sheet Fund:003-SELF-INSURANCE February 2019 Fiscal Period 8/2019 Summarized by Account Report Generated on Mar 8,2019 1:26:47 PM TOTAL ASSETS Current Assets CASH ACCOUNTS/CASH $110,380 CASH ACCOUNTS/TEMPORARY INVESTMENTS $7,200,000 DUE FROM/DUE FROM R/E $783,408 RECEIVABLE ACCOUNTS/ACCRUED INTEREST A/R $27,632 Current Assets $8,121,420 TOTAL ASSETS $8,121,420 TOTAL LIABILITIES AND FUND EQUITY Total Liabilities CURRENT LIABILITIES/ACCOUNTS PAYABLE ($1,782) CURRENT LIABILITIES/GASB10 ACTUARIAL RESERVE ($882,230) DUE TO/DUE TO R/E ($787,145) Total Liabilities ($1,671,157) Total Fund Equity FUND EQUITY/EMPLOYMENT/POLLUTION RISK ($5,000,000) FUND EQUITY/EXPENDITURE SUMMARY $722,183 FUND EQUITY/INS PREMS/CLAIMS/LAWSUITS ($1,280,047) YEAR TO DATE REVENUES/REVENUE SUMMARY ($892,398) Total Fund Equity ($6,450,263) TOTAL LIABILITIES AND FUND EQUITY ($8,121,420) Page 32 of 35 AwLcentral Contra Costa Sanitary District Protecting public health and the environment Revenue Report MTD Fund: 004-DEBT SERVICE February 2019 Fiscal Period 8/2019 Report Generated on Mar 8, 2019 1:18:20 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 580,009 97.8% Total Revenue 0.0% $3,528,591 $3,531,028 0.1% $3,611,037 Page 33 of 35 ACV Central Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004- DEBT SERVICE February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM $600,000 ❑Period Budget $1,000,000 ❑YTD Budget ❑Period Actual ❑ YTD Actual $500,000 ' $800,000 $400,000 ' $600,000 $300,000 ' $400,000- $200,000-/ _ $200,000- $100,000-,/ $0- $0 Period Budget Period Actual Period Variance YTD Budget YTD Actual YTD Variance $557,252 $403,907 $153,345 $759,536 $868,491 ($108,955) Totals $557,252 $403,907 $153,345 $759,536 $868,491 ($108,955) Page 34 of 35 ZwLcentral Contra Costa Sanitary District Protecting public health and the environment Expense Report - By Department MTD Fund: 004-DEBT SERVICE February 2019 Fiscal Period 08/2019 Report Generated on Mar 8, 2019 1:33:04 PM Department: Category Period Budget Period Actual Period Variance % YTD Budget YTID Actual YTD Variance % Annual % Budget INTEREST EXPENSE $557,252 $403,907 $153,345 27.5% $759,536 $868,491 ($108,955) $1,135,780 76.5% Total Expenses $557,252 $403,907 $153,345 27.5% $759,536 $868,491 ($108,955) -14.3% $1,135,780 76.5% Total Expenses $7,690,662 $7,239,870 $450,792 5.9% $60,048,538 $58,001,700 $2,046,838 3.4% $91,780,736 63.2% Color Key: 0 to 10%over budget > 10%over budget M Page 35 of 35 ' Central Contra Costa Sanitary District Balance Sheet Fund:004-DEBT SERVICE February 2019 Fiscal Period 8/2019 Summarized by Account Report Generated on Mar 8,2019 1:26:47 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)