The URL can be used to link to this page

Home My WebLink AboutMemo - Mail Packet - 10/27/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: October 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 (-2%) trending near expected values • Residential use was lower by 1% in the last week • Small / medium commercial remains 8% lower in the last week • Large commercial remains 8% lower in the last week • Industrial commercial use highly variable; lower by ~16% in the last week • Accounts eligible were up significantly. Customers may now apply for CARES act funding to help pay account balances (3,768 postcards were sent this week) • Community treated water up ~ 6% and wastewater down ~ 10% • Single-family home water use up by ~5% • Multi-family home water use down by ~12% • Small and medium business water use down by ~10% Community electricity use and potential account disconnects are also reported monthly in the City’s Recovery Dashboard. Attachments: Utilities COVID-19 Dashboard October 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: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF 10/14/2020 10/18/2020 10/19/2020 October 15, 2020 Utilities Covid Dashboard Update DocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF 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 September 30) •Total electricity use (-5%) and peak demand (-2%) trending near expected values •Residential use was lower by 1% in the last week •Small / medium commercial remains 8% lower in the last week •Large commercial remains 8% lower in the last week •Industrial commercial use highly variable; lower by ~16% in the last week •Accounts eligible were up significantly. Customers may now apply for CARES act funding to help pay account balances (3,768 postcards were sent this week) •Community treated water up ~ 6% and wastewater down ~ 10% •Single-family home water use up by ~5% •Multi-family home water use down by ~12% •Small and medium business water use down by ~10% •Reports available on Utilities website at https://www.fcgov.com/utilities/covid-19 Notes •New this week -Data through September 30 -Next monthly report in November Metrics indicating impacts to resource use and customer service due to Covid19 DocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Community electricity use 3 Notes: •Total use lower by ~5% from March 26 to September 30 •The data shows that use is trending back towards expected levels. The last seven days use was ~3% 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: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Community Peak Demand 4 Notes: •Peak demand averaged lower by ~2% from March 26 to September 30 •The data shows that peak demand is trending back towards expected levels. The last seven days use was within ~1% of the expected value. Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Residential electricity use 5 Notes: •Residential electricity use higher by ~3% from March 26 to September 30 •The data shows that residential use is trending higher compared to expected levels. The last seven days use was ~1% 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: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Small/medium commercial electricity use 6 Notes: •Small/medium commercial use lower by ~12% from March 26 to September 30 •The data shows that use remains lower than expected levels. The last seven days use was ~8% 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: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Large commercial electricity use 7 Notes: •Large commercial use lower by ~12% from March 26 to September 30 •The data shows that use remains lower than expected levels. The last seven days use was ~8% 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: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Industrial commercial electricity use 8 Notes: •Industrial commercial use variable and lower by ~7% from March 26 to September 30 •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: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Community treated water demand 9 Notes: •Treated water demand from March 26 to September 30 was higher by ~ 6% compared to 2019 Data Notes: Does not include transfers to other water districts DocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Single-Family Homes daily water use 10 Notes: •Daily water use was higher by ~ 5% from March 26 to September 30 compared to 2019 •Data is not weather normalized •Includes single family and duplex homes Data Notes: Data is not weather normalized DocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Multi-family homes daily water use 11 Notes: •Daily water use was lower by ~ 12% from March 26 to September 30 compared to 2019 •Includes multi-family properties •Data is not weather normalized Data Notes: Data is not weather normalized DocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Small & medium commercial daily water use 12 Notes: •Daily water use was lower by ~ 11% from March 26 to September 30 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: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF 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: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Non-payment Disconnect Information 14 Notes: •Weekly average data from March 26 to September 30 •The final entry is an early October monthly total. Due to an error, daily September data is not available. •The total number of accounts had been trending slowly downward since a peak in May, even though mailing of disconnect notices was suspended •Due to peak season for property move ins and outs, September shows a significant increase. •Customers with past-due accounts received letters urging payment assistance twice in recent months. •Customers may now apply for CARES act funding to help pay account balances (3,768 postcards were sent this week) •Disconnect notices will resume in November for past-due accounts, with disconnections beginning approximately 10 days later. Data Notes: Data collected daily Monday through Friday each week DocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Next steps Monthly data and metric updates •Reports available on Utilities website (https://www.fcgov.com/utilities/covid-19) Thanks to many staff who have contributed to this effort! •Ongoing team: John Phelan, Michael Authier, Joe King, Jonathon Care, Pablo Bauleo, Abbye Neel •Senior staff: Theresa Connor, Lisa Rosintoski, Lance Smith, Tim McCollough, Liesel Hans, Mark Kempton 15 DocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF Data and Analysis Notes Electricity use by sector analysis notes: •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 16 DocuSign Envelope ID: 4FA5F6F0-B6EA-4812-BE5E-7B61ED6D2EFF