The URL can be used to link to this page

Home My WebLink AboutMemo - Mail Packet - 6/23/2020 - Memorandum From 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: June 18, 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 yet 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 dashboard is available at fcgov.com/utilities/covid-19 Key takeaways (data from March 26 through June 13) • Total electricity use and peak demand trending towards expected values, lower by ~1-5% • Residential use within 2% of expected • Small / medium commercial use lower by ~ 11%, trending higher • Large commercial use lower by ~ 14%, trending higher • Industrial commercial use variable and lower by ~ 9 - 16% • Accounts eligible for disconnect up 64%, trending flat • Community treated water up ~ 6% and wastewater down ~ 7% • Single-family home water use up by ~21% • Multi-family home water use down by ~4% • Small and medium business water use down by ~5%, trending higher Several of these metrics are also anticipated to be included in the City’s Recovery Dashboard, which is under development. DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 6/17/2020 6/17/2020 6/18/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, 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 Neal • Senior Staff: Gretchen Stanford, Lance Smith, Tim McCollough, Carol Webb, Theresa Connor Attachments  Utilities COVID-19 Dashboard June 18, 2020 Cc: Gretchen Stanford, Interim 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: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 June 18, 2020 Utilities Covid Dashboard Update DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 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 June 13) • Total electricity use and peak demand trending towards expected values, lower by ~1-5% • Residential use within 2% of expected • Small / medium commercial use lower by ~ 11%, trending higher • Large commercial use lower by ~ 14%, trending higher • Industrial commercial use variable and lower by ~ 9 - 16% • Accounts eligible for disconnect up 64%, trending flat • Community treated water up ~ 6% and wastewater down ~ 7% • Single-family home water use up by ~21% • Multi-family home water use down by ~4% • Small and medium business water use down by ~5%, trending higher • Weekly reports available on Utilities website at https://www.fcgov.com/utilities/covid-19 Notes • New this week - Data through June 13 Metrics indicating impacts to resource use and customer service due to Covid19 DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Community electricity use 3 Notes: • Total use lower by ~8% from March 26 to June 13 • The data appears to show that use is trending back towards expected levels. The last week was ~5% lower. Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded line partial closure order DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Community Peak Demand 4 Notes: • Total peak demand rose to within 1% of expected levels in the last week Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded line partial closure order DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Residential electricity use 5 Notes: • Total use is very close to the expected values. There are daily variations higher and lower with an overall difference of approximately 2% from March 26 to June 13 Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded line partial closure order DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Small/medium commercial electricity use 6 Notes: • Total use lower by ~17% from March 26 to June 13 • The data appears to show that use is trending back towards expected levels. The last week was ~11% lower. • 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 line partial closure order DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Large commercial electricity use 7 Notes: • Total use lower by ~17% from March 26 to June 13 • The data appears to show that use is trending back towards expected levels. The last week was ~14% lower. • Includes E300 rate class (aka GS50) Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded line partial closure order DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Industrial commercial electricity use 8 Notes: • Industrial commercial use variable and lower by ~9% from March 26 to June 13 • Use appears to have dropped 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 line partial closure order DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Community treated water demand 9 Notes: • Treated water demand was higher by ~ 6% compared to the average for 2018/19 Data Notes: Does not include transfers to other water districts DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Single-Family Homes daily water use 10 Notes: • Daily water use was higher by ~ 21% from March 26 to June 13 compared to 2019 • Note that data is not weather normalized • Includes single family and duplex homes Data Notes: Data is not weather normalized DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Multi-family homes daily water use 11 Notes: • Daily water use was lower by ~ 4% from March 26 to June 13 compared to 2019 • Includes multi-family properties • Note that data is not weather normalized Data Notes: Data is not weather normalized DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Small & medium commercial daily water use 12 Notes: • Daily water use was lower by ~ 5% from March 26 to June 13 compared to 2019 • The data appears to show that use is trending back towards typical levels • Note that 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: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Community wastewater influent flow 13 Notes: • Wastewater influent flow was lower by ~ 7% lower compared to the 2018/19 average Data Notes: includes both Drake and Mulberry treatment plants DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Non-payment Disconnect Information 14 Notes: • March 26 to June 13 - 64% increase over 2019 average - Number of accounts has been stable 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: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 Next steps Weekly data and metric updates • New information for next week (June 25) - Data through June 20 - 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: Kevin Gertig, Lisa Rosintoski, Lance Smith, Tim McCollough, Carol Webb, Theresa Connor 15 DocuSign Envelope ID: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66 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: 223B67FA-3BA9-478D-A0AF-43ABA25CDA66