The URL can be used to link to this page

Home My WebLink AboutMemo - Mail Packet - 9/22/2020 - Memorandum From John Phelan Re: Utilities Covid-19 Dashboard Utilities electric · stormwater · wastewater · water 222 Laporte Avenue PO Box 580 Fort Collins, CO 80522 970.212.2900 utilities@fcgov.com fcgov.com/utilities M E M O R A N D U M DATE: September 15, 2020 TO: Mayor Troxell and Councilmembers FROM: John Phelan, Energy Services Senior Manager THROUGH: Darin Atteberry, City Manager Theresa Connor, Interim Utilities Executive Director RE: Utilities COVID-19 Dashboard The purpose of this memo is to provide an update regarding ongoing efforts to document the COVID-19 pandemic impact on the community through the lens of Fort Collins Utilities. Bottom line Utilities has established a data “dashboard” which helps to represent the impact of the COVID-19 pandemic on the community and the Utilities organization. The initiative has established an ongoing set of metrics intended to support awareness and decision-making for Utilities Senior Staff, the City Manager’s Office and City Council. This dashboard is available at fcgov.com/utilities/covid-19 Key takeaways (data from March 26 through August 31) • Total electricity use (-5%) and peak demand (-3%) trending near expected values • Residential use was higher by 5% in the last week • Small / medium commercial trending higher but remains 6.5% lower in the last week • Large commercial use relatively flat and remains 5% lower in the last week • Industrial commercial use highly variable; lower by ~14% in the last week • Accounts eligible for disconnect up ~ 74%, trending downwards • Community treated water up ~ 7.5% and wastewater down ~ 10% • Single-family home water use up by ~12% • Multi-family home water use down by ~9% • Small and medium business water use down by ~5% Community electricity use and potential account disconnects are also reported monthly in the City’s Recovery Dashboard. Attachments: Utilities COVID-19 Dashboard September 15, 2020 Cc: Gretchen Stanford, Interim Deputy Director, Customer Connections Tim McCollough, Deputy Director, Light & Power Operations Lance Smith, Deputy Director, Financial Planning & Administration Liesel Hans, Interim Deputy Director, Water Resources & Treatment Mark Kempton, Interim Deputy Director, Water Resources & Treatment DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 9/15/2020 9/15/2020 9/16/2020 September 15, 2020 Utilities Covid Dashboard Update DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Monthly Summary Metrics 2 Metric Included Community electricity use ✓ Community peak demand ✓ Residential electricity use ✓ Small/Med commercial electricity use ✓ Large commercial electricity use ✓ Industrial commercial electricity use ✓ Daily treated water ✓ Single-family home water use ✓ Multi-family home water use ✓ Small & medium commercial water use ✓ Daily wastewater influent flow ✓ Eligible disconnects for non-payment ✓ Key takeaways (March 26 through August 31) •Total electricity use (-5%) and peak demand (-3%) trending near expected values •Residential use was higher by 5% in the last week •Small / medium commercial trending higher but remains 6.5% lower in the last week •Large commercial use relatively flat and remains 5% lower in the last week •Industrial commercial use highly variable; lower by ~14% in the last week •Accounts eligible for disconnect up ~ 74%, trending downwards •Community treated water up ~ 7.5% and wastewater down ~ 10% •Single-family home water use up by ~12% •Multi-family home water use down by ~9% •Small and medium business water use down by ~5% •Reports available on Utilities website at https://www.fcgov.com/utilities/covid-19 Notes •New this week -Data through August 31 -Next monthly report in October Metrics indicating impacts to resource use and customer service due to Covid19 DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Community electricity use 3 Notes: •Total use lower by ~5% from March 26 to August 31 •The data shows that use is trending back towards expected levels. The last seven days use was ~1% higher than the expected value. Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Community Peak Demand 4 Notes: •Peak demand averaged lower by ~3% from March 26 to August 31 •The data shows that peak demand is trending back towards expected levels. The last seven days use was ~3.3% higher than the expected value. Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Residential electricity use 5 Notes: •Residential electricity use higher by ~3% from March 26 to August 31 •The data shows that residential use is trending higher compared to expected levels. The last seven days use was ~5.1% higher than the expected value. Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Small/medium commercial electricity use 6 Notes: •Small/medium commercial use lower by ~12% from March 26 to August 31 •The data shows that use is trending back towards expected levels. The last seven days use was ~6.5% lower than the expected value. •Includes E200 and E250 rate classes (aka GS and GS25) Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Large commercial electricity use 7 Notes: •Large commercial use lower by ~13% from March 26 to August 31 •The data shows that use is trending back towards expected levels. The last seven days use was ~4.7% lower than the expected value. •Includes E300 rate class (aka GS50) Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Industrial commercial electricity use 8 Notes: •Industrial commercial use variable and lower by ~6% from March 26 to August 31 •The data shows that use is highly variable. The last seven days use was ~14% lower than the expected value. •Usage variability due to process related changes with causes unknown •Includes E400 and E600 rate classes (aka GS750 and Substation) Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Community treated water demand 9 Notes: •Treated water demand was higher by ~ 7.5% compared to the average for 2018/19 Data Notes: Does not include transfers to other water districts DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Single-Family Homes daily water use 10 Notes: •Daily water use was higher by ~ 12% from March 26 to August 31 compared to 2019 •Data is not weather normalized •Includes single family and duplex homes Data Notes: Data is not weather normalized DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Multi-family homes daily water use 11 Notes: •Daily water use was lower by ~ 9% from March 26 to August 31 compared to 2019 •Includes multi-family properties •Data is not weather normalized Data Notes: Data is not weather normalized DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Small & medium commercial daily water use 12 Notes: •Daily water use was lower by ~ 5% from March 26 to August 31 compared to 2019 •The data shows that use is trending back towards typical levels •Data is not weather normalized •Includes smaller water tap sizes (3/4’’ to 2”) Data Notes: Data not weather normalized. Irrigation only taps excluded. DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Community wastewater influent flow 13 Notes: •Wastewater influent flow was lower by ~ 10% lower compared to the 2018/19 average Data Notes: includes both Drake and Mulberry treatment plants DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Non-payment Disconnect Information 14 Notes: •March 26 to August 31 -~ 74% increase over 2019 average -Number of accounts has been trending slowly downward since a peak in May •Eligible values show the number of customers who would have received a disconnect notice •Disconnect notices will resume in September for customers with outstanding balances over $1000 •Customers may apply for CARES act funding to pay account balances in October Data Notes: Data collected daily Monday through Friday each week DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Next steps Monthly data and metric updates •Shifting to monthly reporting frequency •Reports available on Utilities website (https://www.fcgov.com/utilities/covid-19) Thanks to many staff who have contributed to this effort! •Core team: John Phelan, Coy Althoff, Michael Authier, Joe King, Jonathon Care, Crystal Shafii •IT: Joe King, Doug Burkes, Matt Sheetz, Anthony Sanchez •Energy Services: John Phelan, Michael Authier, Pablo Bauleo •Customer Care & Technology: Lori Clements, Jenne Loffer, Tracy Brann, Blake Schlup •Finance: Jonathon Care, Randy Reuscher •Water: Josh Monsrud, Gudi Kokoszka, Kent Peterson, Jason Graham, Abbye Neel •Senior staff: Theresa Connor, Lisa Rosintoski, Lance Smith, Tim McCollough, Liesel Hans, Mark Kempton 15 DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1 Data and Analysis Notes Electricity use by sector analysis notes: •Staff is investigating some apparent data anomalies in the industrial (E-400/GS-750) rate class •2019 data (Jan-Dec) is used as the baseline with linear or parabolic weather normalization •Weather normalization is split into weekday and weekend day types •Premises in each rate class grouped based on classification in Q1 2020 •Uncertainty in the estimated usage is about 3% after systematic corrections •Residential analysis does not account for vacant dwellings which may be impacted calculated averages Water use by sector analysis notes: •Single-family sector also includes duplex home types •Small and medium commercial sector includes tap sizes from ¾ to 2 inches •Larger and industrial sector not charted; usage appears to not be impacted by covid19 •Irrigation only water taps excluded •Comparison is to similar period in 2019 •No weather normalization included Thanks to the core data analysis team who have made these results possible! •Jonathon Care, Pablo Bauleo, Michael Authier, Joe King, Abbye Neel, John Phelan 16 DocuSign Envelope ID: 2CDC7031-8B44-410A-B4F0-AF6EBAA7BAE1