Loading...
HomeMy WebLinkAbout05.D. Recycled Water AccountingITEM D RECYCLED WATER ACCOUNTING By Danea Gemmell, Division Manager — Planning and Development Sudhir Pardiwala - Raftelis Financial Consultants (RFC) Recycled Water Accounting: • Does tie Board want to continue to trac< Recyc ed Water Cost and Revenues separate y as a formal y ado Dted Budget? or • Esta D is 1 a Se arate Enterprise und for Recyc ed lik Water? RECYCLED WATER POLICY QUESTION ENTERPRISE FUND VS. FORMALLY ADOPTED DETAILED BUDGET Enterprise Fund • Potential loss of flexibility • Expectation of the separate fund: • Self Sufficient? • Proposition 218 concerns? Formally Adopted Detailed Budget • Existing recycled water infrastructure funded through EPA grant and is eligible wastewater cost • Separate recycled water accounting division formally started in FY 16-17: Board adopted RW Budget Tracking costs Tracking revenues • Future budget can show Concord revenues and value not charged for treatment plant use RECYCLED WATER PROGRAM BUDGET Budget Overview By Expense Category Account Description Salaries & Wages Empioyee Benefits Chemicals Utllmes Repairs & Maintenance Professional & Legal Services Outside Services Materials & Supplies Other Expenses Total FY2015-16 FY2015-16 Budget Projected So 50 50 so 5207,800 5189,000 $ /4,000 5160,000 50 56,800 5500 5120,000 56,400 $45,600 5810,100 Budget to FY 2016-17 Projected Budget Variance 5763,147 5477,148 $84,000 51 75,000 530,000 514,000 5202,500 55,900 550,024 51,801,719 Opefations Depa ent WcY Percent Variance 5555 347 267.3% 5288 148 1515% 510,000 13.5% 515,000 9.4% 523,200 341.2% 513,500 2700.0% 582,500 68.8% (5500) -7.8% 54,4)4 9.7% 5991,619 122.4% 5763,147 5477,148 0.0% 584,000 O!0% 5175,000 0.096 530,000 0.0% er Program Percent Variance 0.0% 514,000 0.0% 5202,500 0.0% 55,900 11096 550,024 0.096 51,801,719 0.096 RECYCLED WATER CONSUMPTION Actual Budgeted Projected Projected FY 2016 FY 2017 FY 2018 FY 2019 CCCSD Plant Industrial Use (million gallons) Zone 1 Former Potable (million gallons) Zone 1 Former Canal or Well (million gallons) Residential Fill (million gallons) Satellite Total Recycled Water Consumption (million gallons) CCCSD Plant Industrial Use (%) Zone 1 (%) Residential Fill (%) Satellite (%) Total 355 71 147 12 0 585 60.7% 37.2% 2.1% 0.0% 100.0% 355 73 151 6 0 585 60.7% 38.2% 1.0% 0.0% 100.0% 355 73 151 6 0 585 60.7% 38.2% 1.0% 0.0% 100.0% 355 73 151 6 0 585 60.7% 38.2% 1.0% 0.0%. 100.0% FY 2016-17 RECYCLED WATER TOTAL EXPENSES ALL SU B-PROG RAMS Salaries & Wages $763,147 Employee Benefits $477,148 Chemicals $84,000 Utilities $175,000 Repairs & Maintenance - Filter Plant $30,000 Professional & Legal Services $14,000 Outside Services $202,500 Materials & Supplies $5,900 Other Expenses $50,024 Debt Service (Interest on Debt Service) $9,363 TOTAL OPERATING EXPENSES $1,811,082 CAPITAL EXPENSES Treatment Plant and Program -wide Distribution Residential Fill Satellite TOTAL CAPITAL EXPENSE TOTAL O&M + CAPITAL+ DEBT INTEREST $462,185 $37,815 $500, 000 $2,311,082 FY 2016-17 RECYCLED WATER REVENUE AND EXPENSES Gross Concord Revenue/ Concord Credit for Adjusted Value Revenue Zone 1 ReW Revenue Expenses Change in Net Position CCCSD Plant Industrial Use Zone 1 Residential Fill Satellite Total $467,255* $219,885 $687,139 $496,345 $291,147 ($158,830) $628,662 $326,083* $153,451 $479,534 $234,575 $0 $234,575 $1,524,257 $664,482 ($158,830) $2,029,909 * value not charged FY 2016-17 Zone 1 Rec cled Water Rates Ado .ted June 2015 Zone 1 -Former Potable: $3.48 per 1000 gallons Zone 1 -Former Canal/ Well: $1.61 per 1000 gallons $687,139 $909,834 $479,534 $234,575 $2,311,082 ($281,173) ($326,083) ($607,256) FY 2016-17 RECYCLED WATER EXPENSE ALLOCATIONS BY CUSTOMER CLASS ALLOCATED O&M + CAPITAL CCCSD Plant Industrial Use Share Treatment Plant and Program -wide Total CCCSD Plant Industrial Use Share Zone 1 Share Treatment Plant and Program -wide Distribution Total Zone 1 Share Residential Fill Share Treatment Plant and Program -wide Residential Fill Total Residential Fill Share Sate!! ite Share Treatment Plant and Program -wide Satellite Total Satellite Share TOTAL O&M + CAPITAL $687,139 $687,139 $432,507 $477,227 $909,834 $11,614 $467,920 $479,534 $0 $234,575 $234,575 $2,311,082 0 RECYCLED WATER ZONE 1 CUSTOMERS CUSTOM ERS CONSUMPTION ■ Former Potable: $3.48 per 1000 gallons ▪ Former Canal/ Well: $1.61 per 1000 gallons [Updated Slide -11/10/161 2015 Account and Consumption data RATE COMPARISON FY16-17 Water Rates ($ per 1000 gallons) [New Slide - 11/10/16] CCCSD EBMUD EBMUD CCWD RW RW Potable Potable $3.48 $4.63 $5.94 $4.81 RW% 75% 59% 72% [New Slide - 11/10/16] STAFF RECOMMENDATIONS FOR ITEM D • Keep Formally Adopted Detailed Budget • Refine FY 2017-18 Budget to show all revenues and values not charged from recycled water • Explore phased Zone 1 rate structure to consolidate the two tiers