The URL can be used to link to this page

Home My WebLink AboutMemo - Mail Packet - 8/4/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: July 30, 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 July 25) • Total electricity use and peak demand trending within 1% of expected values • Residential use trending higher by 9% in the last week • Small / medium commercial trending higher but remains 7% lower in the last week • Large commercial use trending higher but remains 6% lower in the last week • Industrial commercial use highly variable; lower by ~16% in the last week • Accounts eligible for disconnect up 70%, trending downwards • Community treated water up ~ 9% and wastewater down ~ 9% • Single-family home water use up by ~21% • Multi-family home water use down by ~5% • Small and medium business water use down by ~1% Community electricity use and potential account disconnects are also reported monthly in the City’s Recovery Dashboard. DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 7/29/2020 7/29/2020 7/30/2020 Background Key characteristics:  Data characteristics:  Hourly data, reporting daily results, updated weekly  Data sources: Water Production, substation metering, Customer Information System, advanced metering datasets, NEW advanced metering data exports  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  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) Thanks to many staff who have contributed to this effort: • Core team: John Phelan, Coy Althoff, Michael Authier, Joe King, J onathon 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 Neal • Senior Staff: Theresa Connor, Gretchen Stanford, Lance Smith, Tim McCollough, Carol Webb Attachments  Utilities COVID-19 Dashboard July 30, 2020 Cc: Gretchen Stanford, Interim Deputy Director, Customer Connections Lisa Rosintoski, Deputy Director, Customer Connections Tim McCollough, Deputy Director, Light & Power Operations Lance Smith, Deputy Director, Financial Planning & Administration Carol Webb, Deputy Director, Water Resources & Treatment DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 July 30, 2020 Utilities Covid Dashboard Update DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Weekly 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 July 25) •Total electricity use and peak demand trending within 1% of expected values •Residential use trending higher by 9% in the last week •Small / medium commercial trending higher but remains 7% lower in the last week •Large commercial use trending higher but remains 6% lower in the last week •Industrial commercial use highly variable; lower by ~16% in the last week •Accounts eligible for disconnect up 70%, trending downwards •Community treated water up ~ 9% and wastewater down ~ 9% •Single-family home water use up by ~21% •Multi-family home water use down by ~5% •Small and medium business water use down by ~1% •Weekly reports available on Utilities website at https://www.fcgov.com/utilities/covid-19 Notes •New this week -Data through July 25 Metrics indicating impacts to resource use and customer service due to Covid19 DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Community electricity use 3 Notes: •Total use lower by ~6% from March 26 to July 25 •The data shows that use is trending back towards expected levels. The last seven days use was ~0.2% lower than the expected value. Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Community Peak Demand 4 Notes: •Peak demand averaged lower by ~5% from March 26 to July 25 •The data shows that peak demand is trending back towards expected levels. The last seven days use was ~0.5% 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: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Residential electricity use 5 Notes: •Residential electricity use higher by ~4% from March 26 to July 25 •The data shows that peak demand is trending higher for residential use compared to expected levels. The last seven days use was ~9% 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: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Small/medium commercial electricity use 6 Notes: •Small/medium commercial use lower by ~14% from March 26 to July 25 •The data shows that use is trending back towards expected levels. The last seven days use was ~7% 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: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Large commercial electricity use 7 Notes: •Large commercial use lower by ~15% from March 26 to July 25 •The data shows that use is trending back towards expected levels. The last seven days use was ~6% 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: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Industrial commercial electricity use 8 Notes: •Industrial commercial use variable and lower by ~9% from March 26 to July 25 •The data shows that use is highly variable. The last seven days use was ~16% 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: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Community treated water demand 9 Notes: •Treated water demand was higher by ~ 8% compared to the average for 2018/19 Data Notes: Does not include transfers to other water districts DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Single-Family Homes daily water use 10 Notes: •Daily water use was higher by ~ 21% from March 26 to July 25 compared to 2019 •Data is not weather normalized •Includes single family and duplex homes Data Notes: Data is not weather normalized DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Multi-family homes daily water use 11 Notes: •Daily water use was lower by ~ 5% from March 26 to July 25 compared to 2019 •Includes multi-family properties •Data is not weather normalized Data Notes: Data is not weather normalized DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Small & medium commercial daily water use 12 Notes: •Daily water use was lower by ~ 1% from March 26 to July 25 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: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Community wastewater influent flow 13 Notes: •Wastewater influent flow was lower by ~ 9% lower compared to the 2018/19 average Data Notes: includes both Drake and Mulberry treatment plants DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Non-payment Disconnect Information 14 Notes: •March 26 to July 25 -70% increase over 2019 average -Number of accounts has been trending downward for several weeks •Eligible values show the number of customers who would have received a disconnect notice •Disconnect notices have been suspended but revised customer communications have resumed Data Notes: Data collected daily Monday through Friday each week DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 Next steps Weekly data and metric updates •New information for next week (August 7) -Data through August 1 -Weekly 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, Carol Webb 15 DocuSign Envelope ID: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6 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: E95AFDC1-7AF5-4946-B85A-A34DB7D44DC6