The URL can be used to link to this page

Home My WebLink AboutMemo - Mail Packet - 11/24/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: November 19, 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 (March 26 through October 31) • Total electricity use (-4%) and peak demand (-2%) trending near expected values • Residential use was higher by 1% • Small / medium commercial was lower by 13% • Large commercial was lower by 13% • Industrial commercial use was highly variable and lower by 8% • Accounts eligible for disconnect were up 43% comparted to 2019 average. Customers may now apply for CARES act funding to help pay account balances • Community treated water down ~ 3% and wastewater down ~ 9% • Single-family home water use up by ~3% • Multi-family home water use down by ~14% • Small and medium business water use down by ~12% • Outdoor water restrictions in effect from Oct 1 through Nov 10. Demand decreased by over 100 million gallons during this time frame Community electricity use and potential account disconnects are also reported monthly in the City’s Recovery Dashboard. Attachments: Utilities COVID-19 Dashboard November 17, 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: C3030141-03BC-4F27-A657-361179F3D967 11/18/2020 11/18/2020 11/19/2020 November 17, 2020 Utilities Covid Dashboard Update DocuSign Envelope ID: C3030141-03BC-4F27-A657-361179F3D967 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 October 31) •Total electricity use (-4%) and peak demand (-2%) trending near expected values •Residential use was higher by 1% •Small / medium commercial was lower by 13% •Large commercial was lower by 13% •Industrial commercial use was highly variable and lower by 8% •Accounts eligible for disconnect were up 43% comparted to 2019 average. Customers may now apply for CARES act funding to help pay account balances •Community treated water down ~ 3% and wastewater down ~ 9% •Single-family home water use up by ~3% •Multi-family home water use down by ~14% •Small and medium business water use down by ~12 % •Outdoor water restrictions in effect from Oct 1 through Nov 10. Demand decreased by over 100 million gallons during this time frame •Reports available at fcgov.com/utilities/covid-19 Notes •New this week -Data through October 31 -Next monthly report in December Metrics indicating impacts to resource use and customer service due to Covid19 DocuSign Envelope ID: C3030141-03BC-4F27-A657-361179F3D967 Community electricity use 3 Notes: •Total use lower by ~4% from March 26 to October 31 •The data shows that use is trending back towards expected levels. The last seven days use was ~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: C3030141-03BC-4F27-A657-361179F3D967 Community Peak Demand 4 Notes: •Peak demand averaged lower by ~2% from March 26 to October 31 •The data shows that peak demand is trending back towards expected levels. The last seven days use was ~4% 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: C3030141-03BC-4F27-A657-361179F3D967 Residential electricity use 5 Notes: •Residential electricity use higher by ~1% from March 26 to October 31 •The data model for expected use for the fall season is under review for update next month. Data Notes: Expected values are weather adjusted from 2019 data, uncertainty ±3% indicated by shaded linepartial closure orderDocuSign Envelope ID: C3030141-03BC-4F27-A657-361179F3D967 Small/medium commercial electricity use 6 Notes: •Small/medium commercial use lower by ~13% from March 26 to October 31 •The data model for expected use for the fall season is under review for update next month. •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: C3030141-03BC-4F27-A657-361179F3D967 Large commercial electricity use 7 Notes: •Large commercial use lower by ~13% from March 26 to October 31 •The data model for expected use for the fall season is under review for update next month. •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: C3030141-03BC-4F27-A657-361179F3D967 Industrial commercial electricity use 8 Notes: •Industrial commercial use variable and lower by ~8% from March 26 to October 31 •The data model for expected use for the fall season is under review for update next month. •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: C3030141-03BC-4F27-A657-361179F3D967 Community treated water demand 9 Notes: •Treated water demand from March 26 to October 31 was higher by ~ 3% compared to 2019 •Data is not weather normalized •Outdoor water restrictions in support of the Horsetooth Outlet Project from Oct 1 through Nov 10. Water use decreased 35% and reached the 15 million gallons daily target Data Notes: Does not include transfers to other water districts DocuSign Envelope ID: C3030141-03BC-4F27-A657-361179F3D967 Single-Family Homes daily water use 10 Notes: •Daily water use was higher by ~ 3% from March 26 to October 31 compared to 2019 •Data is not weather normalized •Outdoor water restrictions in support of the Horsetooth Outlet Project from Oct 1 through Nov 10. Water use decreased 35% and reached the 15 million gallons daily target •Includes single family and duplex homes Data Notes: Data is not weather normalized DocuSign Envelope ID: C3030141-03BC-4F27-A657-361179F3D967 Multi-family homes daily water use 11 Notes: •Daily water use was lower by ~ 14% from March 26 to October 31 compared to 2019 •Data is not weather normalized •Outdoor water restrictions in support of the Horsetooth Outlet Project from Oct 1 through Nov 10. Water use decreased 35% and reached the 15 million gallons daily target •Includes multi-family properties Data Notes: Data is not weather normalized DocuSign Envelope ID: C3030141-03BC-4F27-A657-361179F3D967 Small & medium commercial daily water use 12 Notes: •Daily water use was lower by ~ 12% from March 26 to October 31 compared to 2019 •Data is not weather normalized •Outdoor water restrictions in support of the Horsetooth Outlet Project from Oct 1 through Nov 10. Water use decreased 35% and reached the 15 million gallons daily target •Includes smaller water tap sizes (3/4’’ to 2”) Data Notes: Data not weather normalized. Irrigation only taps excluded. DocuSign Envelope ID: C3030141-03BC-4F27-A657-361179F3D967 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: C3030141-03BC-4F27-A657-361179F3D967 Non-payment Disconnect Information 14 Notes: •Weekly average data from March 26 to October 31 is 43% higher than the 2019 average (daily September data is not available) •The 2019 monthly average of past- due accounts has been revised to 2,000 after additional review •Customers with past-due accounts received multiple letters urging payment assistance in recent months •Customers may apply for CARES Act funding to pay outstanding account balances related to COVID-19 •Late and reconnection fees have been waived since April •Disconnect notices resumed in November for past-due accounts Data Notes: Data collected daily Monday through Friday each week DocuSign Envelope ID: C3030141-03BC-4F27-A657-361179F3D967 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: C3030141-03BC-4F27-A657-361179F3D967 Data and Analysis Notes Electricity use by sector analysis notes: •The data model for expected use for the fall season is under review for update next month. •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: C3030141-03BC-4F27-A657-361179F3D967