The URL can be used to link to this page

Home My WebLink About04.b. Receive Fiscal Year 2017-18 Pre-Audit Year-End Financial Statement Summary Report and variance alternatives Page 1 of 6 Item 4.b. CENTRAL SAN BOARD OF DIRECTORS POSITION PAPER DRAFT MEETING DATE: AUGUST 21, 2018 SUBJECT: RECEIVE FISCAL YEAR 2017-18 PRE-AUDIT YEAR-END FINANCIAL STATEMENT SUMMARY REPORT AND VARIANCE ALTERNATIVES SUBMITTED BY: INITIATING DEPARTMENT: PHIL LEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION-FINANCE ADMINISTRATION REVIEWED BY: ANN SASAKI, DEPUTY GENERAL MANAGER ISSUE The Board of Directors approves the Operations and Maintenance (O&M), Capital Improvement (CIB), Self Insurance, and Debt Service budgets on an annual basis.At Fiscal Year(FY)end, staff reviews and compares the final revenues and expenditures, based on the pre-audit financial reports, to update the Board on the budget versus actual activity. BACKGROUND A public hearing was held on June 1, 2017, after which the Board adopted the FY 2017-18 budgets. The proposed revenue and estimated expenditures within the adopted FY 2017-18 budgets, actuals, variances, and year-end adjustments are summarized in Attachments 1 and 2.Attachment 1 summarizes the revenue and expense variances by Sub-Fund. It should be noted that the Sewer Construction Fund expenditures variance of$6.97 million is merely a timing issue; this amount has been added to the FY 2018-19 spending plan as acarry-forward. The amount of funds to be considered for allocation to various potential uses is therefore $11,814,606. Potential alternative uses for these funds are listed in Attachment 3. ALTERNATIVES/CONSIDERATIONS Absent specific Board action, the favorable variances would, through operation of the fiscal reserve policies and mechanics of the financial plan, be automatically applied to the Sewer Construction Fund. Alternatively, the Board may elect to direct a portion of the variance toward the pay-down of employee related liabilities. The FY 2018-19 budget provides for$2.5 million in funding as an additional payment towards either OPEB or pension related liabilities. That amount could for example be dedicated towards August 21, 2018 Regular FINANCE Committee Meeting Agenda Packet- Page 49 of 177 Page 2 of 6 the Pension prefunding trust, while a similar amount of the $11.8 million variance could be directed toward the GASB 45/Other Post Employment Benefits (OPEB)Trust. Staff have not made a particular recommendation at this time, pending the compilation of additional information on the funded status of Pension and O P E B plans. FINANCIAL IMPACTS Due to the FY 2017-18 favorable variances in the O&M and CI B Budgets, the District's beginning cash balances for FY 2018-19 are higher than projected. The variance of$11.8 million can be directed towards multiple potential uses as described in the Alternatives section. The financial impact is favorable to District ratepayers regardless of which option is chosen, as there will be decreased future upward pressure on the Sewer Service Charge. COMMITTEE RECOMMENDATION The Finance Committee reviewed this subject at its August 21, 2018 meeting and recommended receipt of the Pre-Audit Year-End (YE) Financial Statement Summary Report and the variance alternatives. RECOMMENDED BOARD ACTION Receive the FY 2017-18 Pre-Audit YE Financial Statement Summary Report and variance alternatives. Strategic Plan Tie-In GOAL THREE:Be a Fiscally Sound and Effective Water Sector Utility Strategy 1 - Conduct long-range financial planning, Strategy 2- Manage costs ATTACHMENTS: 1. Variance Summary 2. Variance Detail and Charts 3.Alternative Uses of Variances August 21, 2018 Regular FINANCE Committee Meeting Agenda Packet- Page 50 of 177 Page 3 of 6 ATTACHMENT 1 Pre-Audit-June 2018 Financial Statement Summary and Variance Overview Budget Actual FY 2017-18 FY 2017-18 Variance Favorable/Unfavorable Operations&Maintenance Revenues $94,658,700 $95,997,227 $1,338,527 F See Attachment 2 Expenses 89,713,587 84,841,385 (4,872,202) F See Attachment 2 Total $4,945,113 $11,155,842 $6,210,729 Sewer Construction Revenues $39,327,800 $44,850,100 $5,522,300 F Capacity$1.8M from Dry Creek Sr.Housing Proj. Expenses 46,477,628 39,504,606 (6,973,022) F Total ($7,149,828) $5,345,494 $12,495,322 District Totals(4 Funds) Revenues $138,782,682 $145,683,174 $6,900,492 F Favorable Expenses/Debt Principal 140,914,996 129,027,860 (11,887,136) F Favorable Total ($2,132,314) $16,655,314 $18,787,628 Variance Excluding Sewer Construction Expense Variance that becomes FY 2018-19 Carryforward: $11,814,606 August 21, 2018 Regular FINANCE Committee Meeting Agenda Packet- Page 51 of 177 Page 4 of 6 ATTACHMENT 2 Pre-Audit-June 2018 Financial Statement Summary Operations and Maintenance Variance Analysis ($000) +Favorable Budget Actual Variance % Explanation Implications for future budgeting Revenues SSC-County $ 73,981 $ 73,899 $ (81) 0% N/A-Variance is below 1% SSC-Direct 1,096 1,476 380 35% Higher than anticipated development Conservative assumptions for growth are used City of Concord 15,200 14,974 (226) -1% N/A-Variance is below 1% Permit/Application Fees 420 630 210 50% Higher than anticipated development Conservative assumptions for growth are used;but 3 year average will pick up higher FY 2017-18 and FY 2018-19 experience Side Sewer Inspection 1,080 1,230 150 14% Higher than anticipated development Conservative assumptions for growth are used;but 3 year average will pick up higher FY 2017-18 and FY 2018-19 experience Recycled Water 335 467 132 39% RE&SC combined variance$93k due to higher than FY 2018-19 budget was increased for RW and all anticipated usage;ReW O&M expenses exceeded revenue is assumed to stay in RE subfund revenue,thus no excess revenue was transferred over to SC Annexation Charges 75 204 129 172% Higher than anticipated development Conservative assumptions for growth are used;but 3 year average will pick up higher FY 2017-18 and FY 2018-19 experience All Other 2.472 3.117 645 26% Includes seatic/overtime insaections.industrial Total Revenues $ 94,659 $ 95,997 $ 1,339 1% Favorable variance Expenditures Salaries&Benefits $ 67,579 $ 66,362 $ 1,217 2% Comprised of$950k salaries(unfilled vacancies in Will provide somewhat higher vacancy factor in the excess of vacancy factor)and$900k benefits(largely FY 2018-19 budget than the 2%of salaries and 3% retirement and medical insurance),offset by$635k in of benefits used for FY 2017-18,and capital work capitalized admin OH due to less capital work than by each employee was reexamined budgeted Chemicals 1,482 1,025 457 31% The commodity price for Lime is less expensive than Reduced budget in FY 2018-19 to reflect current what was budgeted. Other Chemicals usage has been pricing and usage. reduced through more accurate pump control. Utilities 4,640 4,349 291 6% Contiuned decrease in natural and landfill gas prices Reduced budget in FY 2018-19 to reflect current versus commodity price increases projected by US pricing. Energy Information Administration(EIS)during budgeting process. Repairs&Maintenance 5,300 4,429 871 16% Expense for repair of Miner Rd in Orinda budgeted, but not incurred saving$300K. Additional savings from a delay in completion of CSO CCTV. Outside Services 3,453 2,325 1,128 33% Less spent on various Technical Services-including: At times,items are not needed due to changed (1)HR District-wide training postponed to FY19-20 circumstances or delays $175K;(2)Emergency radio service$50K;(3)Cost of Service Consultant$150K;(4)Treatment Plant Planning Support$92K;(5)SWRF Contracts$50K;(6)IT Consultants/Support$41K;(7)Air Source Testing �1171<-(R)Rervrlerl Water nnnnrtunities Stur]v_�1 nni< Other 7,260 6,351 909 13% $55K Public information savings $150K Internal audits budgeted in Professional Svcs, but actual expense incurred through payroll(Theresa Nidetz) $300K Nutrient Studies budgeted,but not incurred $150K savings from delay of BAAQMD Health Risk Assessment $43K Technical training&conferences savings $120K Professional reimbursement savings Total Expenses $ 89,714 $ 84,841 $ 4,873 5% Total under spent-Favorable Net $ 4,945 $ 11,156 $ 6,212 Favorable variance available for disposition August 21, 2018 Regular FINANCE Committee Meeting Agenda Packet- Page 52 of 177 N:\Accounting\GMTEMPI\Financials and Closing\2018 Financials\8-21 PP pre-audit 4funds and graph 08/15/18 Page 5 of 6 ATTACHMENT 2 Pre-Audit-June 2018 Financial Statement Summary Operations and Maintenance Variance Analysis ($000) FY 2017-18 O&M Revenue Variances $73,981 $80,000 $73,899 $70,000 $60,000 $50,000 $40,000 $30,000 15,200 $20,000 14,974 $10,000 1,096 1 420 ,080 335 204 3,117 1,476 630 1,230 467 75 2,472 SSC-County SSC-Direct City of Concord Permit/Application Fees Side Sewer Inspection Recycled Water Annexation Charges All Other ■Budget ■Actual FY 2017-18 O&M Expense Variances $80,000 $67,579 $70,000 $66,362 $60,000 $50,000 $40,000 $30,000 $20,000 4,640 5,300 7,260 $10,000 1,482 3,453 6,351 4,349 4,429 1,025 2,325 E M $_ Salaries&Benefits Chemicals Utilities Repairs&Maintenance Outside Services Other ■Budget ■Actual August 21, 2018 Regular FINANCE Committee Meeting Agenda Packet- Page 53 of 177 N:\Accounting\GMTEMPI\Financials and Closing\2018 Financials\8-21 PP pre-audit Munds and graph 08/15/18 Page 6 of 6 ATTACHMENT 3 Pre-Audit-June 2018 Financial Statement Summary Use of FY 2017-18 Budget Variances(O&M Revenues and Expenditures and Capital Revenues) # Item Description Alternatives 1 Further Bolster This is the default position. Without further action,the variances will be directed to(or $11,814,606 Sewer Construction retained by)the Sewer Construction sub-fund. Such monies will be in excess of the sub-fund reserve targeted reserve balance at the end of FY 2017-18,and would reduce any future year balance above level borrowing requirements that were otherwise anticipated for CIP needs. anticipated in Financial Plan and reduce future year's borrowing requirements 2 Pay down employee PFM previously advised Central San on the advantages of applying available funds towards TBD related liabilities employee related liabilities. Applying funds towards these liabilities can save Central San the assumed actuarial cost of these programs;for pension,this is 7.0%. Actual savings would depend on the actual market returns of the invested funds,but are targeted at the assumed actuarial return. Funds could be: a. Remitted directly to CCCERA. Not advised due to concerns about"superfunding"and once remitted the funds are not available to reduce future year's contributions. (Funding status at 12-31-16 valuation is 78.1%,and at 12-31-17 valuation is 81.1%excluding balance in Pension Prefunding Trust) b. Deposited in the GASB 45 OPEB Trust(Projected funding status at 7-1-17 is 47.5%,and in the mid-50s percentage range at 7-1-18. Funded ratio would be higher upon move to CalPERS health.) c. Deposited in the Section 115 Pension Prefunding Trust. With the current balance in the Pension Prefunding Trust,the Pension funding status rises from 81.1%to 82.4%. Total accounted for $11,814,606 Total available savings $11,814,606 Remaining $0 Additional Budgeted FY 2018-19 Funded for Pension or OPEB Trust $2,500,000 August 21, 2018 Regular FINANCE Committee Meeting Agenda Packet- Page 54 of 177