The URL can be used to link to this page

Home My WebLink AboutMemo - Mail Packet - 4/28/2020 - Memorandum From Lisa Rosintoski And John Phelan Re: Utilities Covid-19 DashboardUtilities 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: April 23, 2020 TO: Mayor Troxell and Councilmembers FROM: Lisa Rosintoski, Deputy Director, Utilities Customer Connections John Phelan, Energy Services Senior Manager THROUGH: Darin Atteberry, City Manager Jeff Mihelich, Deputy City Manager Kevin R. Gertig, 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. The attached “dashboard” will be expanded in the following weeks as described below. Bottom line Utilities has established a data “dashboard” which can represent the impact of the COVID-19 pandemic on the community and the Utilities organization. The initiative has quickly established a limited set of data which will be followed by an ongoing and evolving set of metrics. It is intended to support awareness and decision-making for Utilities Senior Staff, the City Manager’s Office and City Council. This week includes the same set of metrics updated for data through April 18. The sector specific usage metrics are under quality assurance review for inclusion next week. Background Key characteristics:  Interim and final “dashboard” tools are expected to evolve over time as needed. The initial presentation platform is a weekly set of PowerPoint slides.  Data characteristics:  Hourly data, reporting daily results, updated weekly  Leverage existing sources where possible  Sources: Water Production, substation metering, Customer Information System, advanced metering datasets, NEW advanced metering data exports DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0 4/22/2020 4/22/2020 4/22/2020 4/22/2020 4/22/2020  Metric characteristics:  Responsive to short-term changes in usage or community financial capacity  Primary metrics based upon electricity and water usage by residential and commercial segments; hourly data to allow revenue estimation via rate models  Reflective of Utilities operations, actionable information, financial impacts and potential public interest  Ability to compare with past periods to analyze trends  Not intended to reveal detailed sub-segment changes (e.g. second level analysis for specific business sectors)  Phase 1 proposed metrics:  Usage  Residential electricity and water use (daily)  Small and large commercial electricity and water use (daily)  Community electricity use and peak demand (daily)  Water production demand (daily)  Wastewater influent flow (daily)  Customer Service  Scheduled and actual disconnects for non-payment  Schedule – some results may be available in advance of these dates  Core team established (April 1)  Review of draft plan by Utilities Senior Staff (April 8)  Identify data sources/locations, test new data extracts (week of April 13)  Preliminary charts and initial dashboard sent to Council (April 16)  Addition of sector data (week of April 20)  Weekly updates begin (April 23)  Consider revisions or Phase 2 metrics (TBD) 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 • Energy Services: John Phelan, Michael Authier, Pablo Bauleo • Customer Care & Technology: Lori Clements, Jenne Loffer, Tracy Brann • Finance: Jonathon Care, Randy Reuscher • Water: Josh Monsrud, Gudi Kokoszka, Kent Peterson, Jason Graham • Senior Staff: Kevin Gertig, Lisa Rosintoski, Lance Smith, Tim McCollough, Carol Webb, Theresa Connor Attachments  Utilities COVID-19 Dashboard April 23, 2020 Cc: Tim McCollough, Deputy Director, Light & Power Operations Lance Smith, Deputy Director, Financial Planning & Administration Carol Webb, Deputy Director, Water Resources & Treatment Theresa Connor, Deputy Director, Water Engineering & Field Services DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0 April 23, 2020 Utilities Covid Dashboard Update DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0 Summary Metrics indicating impacts to resource use and customer service due to Covid19 2 Metric Included Community electricity use  Community peak demand Residential electricity use Small commercial electricity use Large commercial electricity use Daily treated water  Residential water use Small commercial water use Large commercial water use Daily wastewater influent flow  Scheduled and actual disconnects for non-payment  Call volume Notes: • New information this week - Data through April 18 • Added information scheduled for next week - Electricity use by residential and commercial sectors DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0 Community electricity use 3 Notes: • Total use down 7% from March 16 to April 19 Data Notes: Expected values are weather adjusted from 2018 and 2019 data partial closure order DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0 Community treated water demand 4 Notes: • Treated water demand for 2020 was within 0.5% of the average for 2018/19 • Last week saw significant precipitation and colder temperatures Data Notes: Does not include transfers to other water districts DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0 Community wastewater influent flow 5 Notes: • Wastewater influent flow was 7% lower in 2020 compared to the 2018/19 average Data Notes: includes both Drake and Mulberry treatment plants DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0 Non-payment Disconnect Information 6 Notes: • Some March disconnects occurred before the revised policy (Mar 20) • Eligible values show the number of customers who would have received a disconnect notice • March data - 2112 scheduled - 37% increase over 2018/2019 average • April data - 61% increase over 2019 (some cycles higher and some normal) • Disconnect notices have been suspended but will likely resume soon Data Notes: April data pending two additional billing cycles DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0 Next steps Weekly data and metric updates • New information for next week (April 30) - Electricity use by sector - Data through April 25 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 • Energy Services: John Phelan, Michael Authier, Pablo Bauleo • Customer Care & Technology: Lori Clements, Jenne Loffer, Tracy Brann • Finance: Jonathon Care, Randy Reuscher • Water: Josh Monsrud, Gudi Kokoszka, Kent Peterson, Jason Graham • Senior staff: Kevin Gertig, Lisa Rosintoski, Lance Smith, Tim McCollough, Carol Webb, Theresa Connor 7 DocuSign Envelope ID: 7FDD1011-0048-4482-9462-E5B2FF507AD0