HomeMy WebLinkAbout10/20/2022 - Water Commission - AGENDA - Regular Meeting
WATER COMMISSION
REGULAR MEETING AGENDA
October 20, 2022 5:30PM – 7:30PM
Online via Zoom or in person at 222 LaPorte Ave, Colorado River Community Room
10/20/2022 Agenda Page 1
This hybrid Water Commission meeting will be available online via Zoom, by phone, or in
person in the Colorado Room of 222 LaPorte Ave. The meeting will be available to join
beginning at 5:00 p.m. Participants should join at least 15 minutes prior to the 5:30 p.m. start
time.
ONLINE PUBLIC PARTICIPATION:
You will need an internet connection on a laptop, computer, or smartphone, and may join the
meeting through Zoom at https://zoom.us/j/97277170269 Webinar ID: 972 7717 0269 (Using
earphones with a microphone will greatly improve your audio). Keep yourself on muted status.
For public comments, the Chairperson will ask participants to click the “Raise Hand” button to
indicate you would like to speak at that time. Staff will moderate the Zoom session to ensure all
participants have an opportunity to comment.
PUBLIC PARTICIPATION BY PHONE:
Please dial +1 346 248 7799 and enter Webinar ID 972 7717 0269. Keep yourself on muted
status.
For public comments, when the Chair asks participants to click the “Raise Hand” button if they
wish to speak, phone participants will need to press *9 to do this. Staff will be moderating the
Zoom session to ensure all participants have an opportunity to address the Water Commission.
When you are called, press *6 to unmute yourself.
PUBLIC PARTICIPATION IN PERSON:
To participate in person, individuals should come to the Colorado River Community Room of
222 LaPorte Ave and be prepared to follow strict social distancing guidelines. There may be
needs to limit the number of individuals in the meeting room, and thus staging for individuals to
speak may need to occur in the lobby or outside (weather permitting).
Individuals who wish to speak will line up along the northern wall, maintaining physical
distancing. The chairperson will call upon each participant to speak.
(Continued on next page)
WATER COMMISSION
REGULAR MEETING AGENDA
October 20, 2022, 5:30PM – 7:30PM
Online via Zoom or in person at 222 LaPorte Ave, Colorado River Community Room
10/20/2022 Agenda Page 2
1. CALL TO ORDER
2. ROLL CALL
3. AGENDA REVIEW
4. COMMUNITY PARTICIPATION (3 MINUTES PER INDIVIDUAL)
5. APPROVAL OF MINUTES: AUGUST 18, 2022
6. UNFINISHED BUSINESS
NONE
(Continued on next page)
Documents to Share: Any document or presentation a member of the public wishes to
provide to the Water Commission for its consideration must be emailed to JSong@fcgov.com
at least 24 hours before the meeting.
Provide Comments via Email: Individuals who are uncomfortable or unable to access the
Zoom platform or participate by phone are encouraged to participate by emailing comments
to JSong@fcgov.com at least 24 hours prior to the meeting. If your comments are specific to
any of the discussion items on the agenda, please indicate that in the subject line of your
email. Staff will ensure your comments are provided to the Water Commission.
Documents to Share: If residents wish to share a document or presentation, Staff Liaison
Jason Graham’s administrative professional needs to receive those materials via the above
email address at least 24 hours before the meeting.
Individuals uncomfortable or unable to access the Zoom platform or unable to participate by
phone are encouraged to participate by emailing general public comments you may have to
JSong@fcgov.com. The Interim Staff Liaison’s administrative professional will ensure the
Water Commission receives your comments. If you have specific comments on any of the
discussion items scheduled, please make that clear in the subject line of the email and send
24 hours prior to the meeting.
WATER COMMISSION
REGULAR MEETING AGENDA
October 20, 2022, 5:30PM – 7:30PM
Online via Zoom or in person at 222 LaPorte Ave, Colorado River Community Room
10/20/2022 Agenda Page 3
7. NEW BUSINESS
a. Staff Reports
Financial Monthly Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
Memo: 2022 Summer Water Quality Update – Upper Cache la Poudre
Watershed (meeting packet only)
Director of Water Quarterly Update (20 minutes)
Jason Graham, Water Utilities Director
b. Regular Items
2023 Utility Rates and Fees
(Discussion and Action: 30 minutes)
Lance Smith, Financial Planning & Analysis Director
Income-Qualified Assistance Program Feedback
(Discussion and Action: 40 minutes)
Shannon Ash, Affordability Programs Manager
Heather Young, Community Engagement Manager
Allotment Management Program Update and Extension
(Discussion and Action: 20 minutes)
Katie Collins, Water Conservation Specialist
8. COMMISSIONER REPORTS
(Committees, Event attendance, etc.)
9. OTHER BUSINESS
(Commissioner concerns, Announcements)
a. Discuss Work Plan
10. ADJOURNMENT
City of Fort Collins Utilities WATER COMMISSION
2022 Agenda Planning Calendar
Subject to Frequent Change
Updated 10/12/2022 3:45 PM
Meeting
Dates Agenda Topics/Action
Work Plan
Alignment
Meeting Materials are due
2 p.m. Wednesday the week before the meeting
January 20
‐‐Meeting materials deadline: 2 p.m. Wed Jan 12
‐‐Welcome to new Water Commissioners Rick Kahn and Jordan Radin
Staff Reports
Financial Monthly Report (none this month due to year‐end process)
Water Resources Monthly Report (meeting packet only)
Memo: 2021 Fall Water Quality Update – Upper Cache la Poudre
Watershed (meeting packet only)
Halligan Water Supply Project Briefing Book (meeting packet only)
Beneficial Use of Water Treatment Residuals (WTRs) in Stormwater
Treatment (20min)(Basil Hamdan)
Other Business
Approve 2021 Annual Report
Discussion of Elections of New Officers
Deadlines
Jan 31: Annual Report due to City Clerk (completed)
If applicable, schedule Periodic Review for upcoming meeting to
meet July deadline (City Clerk’s Office will remind boards annually if
being reviewed)
February 3
(Work Session)
‐‐Meeting materials deadline: 2 p.m. Wed Jan 26
Cancelled
February 17
‐‐Meeting materials deadline: 2 p.m. Wed Feb 9
Staff Reports
Financial Monthly Report (2021 Year‐End Report)(meeting packet only)
Water Resources Monthly Report (meeting packet only)
Halligan Water Supply Project: Year in Review Update (meeting packet
only; staff available for questions)(Eileen Dornfest)
E. Coli Study and Recommendations (30min)(Susan Strong)
Regular Items
Floodplain Additions and Substantial Improvement Code Change
(40min)(Marsha Hilmes‐Robinson)(Ken Sampley)
Other Business
New Officer Elections
Onboarding Overview
March 17
‐‐Meeting materials deadline: 2 p.m. Wed March 9
Staff Reports
Monthly Financial Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
Meeting
Dates Agenda Topics/Action
Work Plan
Alignment
Meeting Materials are due
2 p.m. Wednesday the week before the meeting
Utilities Executive Director Update – Introducing Kendall Minor (30min)
Other Business
Poudre Headwaters Project – Use of Rotenone to Reestablish Native
Greenback Cutthroat Trout
April 7
(Work Session)
‐‐Meeting materials deadline: 2 p.m. Wed March 30
Nutrient Regulations and Impacts on City’s Wastewater Treatment Plants
(Jason Graham)(confirmed)
New Water Director Introduction (Jason Graham)
April 21
‐‐Meeting materials deadline: 2 p.m. Wed April 13
Staff Reports
Monthly Financial Report (meeting packet only)
Water Resources Monthly Report (10min)(Donnie Dustin)(Michael Neale)
2021 Water Conservation Annual Report (confirmed)(Mariel
Miller)(25min)
o Each year, the Water Conservation Manager presents a
summary of the previous year’s programs, projects, and results.
Presentation may include highlights of the upcoming year’s
projects and priorities
Regular Items
Intergovernmental Agreement for Platte River Power Authority Technical
Support Services (25min)(Theresa Connor)
Graywater Ordinance (35min)(Mariel Miller)(Marcus Coldiron)
MDMS Off‐Cycle Appropriation Request (22min)(Adam Bromley)
Utilities
Customer
Satisfaction
Survey (every
two years: 2019,
2021, 2023,
etc.)(next year)
May 19
‐‐Meeting materials deadline: 2 p.m. Wed May 11
Staff Reports
Financial Monthly Report (meeting packet only)
Water Resource Monthly Report (meeting packet only)
US Forest Service Poudre Headwaters Project (40min)(Richard Thorp)
Director of Water Update (Jason Graham)(tentative)
Other Business
Water Commission and Council Priorities
Deadline
Periodic Review due, if applicable (City Clerk will contact Staff
Liaison)
June 2
(Work Session)
‐‐Meeting materials deadline: 2 p.m. Wed May 25
Drake Water Reclamation Facility Tour
June 16
‐‐Meeting materials deadline: 2 p.m. Wed June 8
Staff Reports
Financial Monthly Report (meeting packet only)
Meeting
Dates Agenda Topics/Action
Work Plan
Alignment
Meeting Materials are due
2 p.m. Wednesday the week before the meeting
Water Resources Monthly Report (meeting packet only)
Regular Items
Halligan Update (Theresa Connor)(40min)
Other Business
Water Commission and Council Priorities Discussion
July 21
‐‐Meeting materials deadline: 2 p.m. Wed July 13
Staff Reports
Financial Monthly Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
Memo: 2022 Spring Water Quality Update – Upper Cache la Poudre
Watershed (meeting packet only)
Memo: Floodplain Management Public Information Committee Annual
Report (meeting packet only)
Public Hearing
Floodplain Variance for Advanced Energy (Marsha Hilmes‐Robinson)
August 4
(Work Session)
‐‐Meeting materials deadline: 2 p.m. Wed July 27
Cancelled
August 18
‐‐Meeting materials deadline: 2 p.m. Wed Aug 10
Staff Reports
Financial Monthly Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
1041 Regulations Update (Kelly Smith)(30min)
2022 Budget Update (Lance Smith, Jason Graham)(30min)
September 29
(SPECIAL MEETING
rescheduled from
Sept 15 Regular
Meeting)
‐‐Meeting materials deadline: 2 p.m. Wed Sept 21
Meeting Cancelled
Public Hearing
Floodplain Variance Hearing for Powerhouse 2 (RESCINDED)
Deadline Schedule completing 2023 Work Plan to meet Nov 30 deadline
October 6
(Work Session)
‐‐Meeting materials deadline: 2 p.m. Wed Sept 28
Staff Reports
Financial Monthly Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
Memo: Testing FC Utilities Drinking Water for PFAS (meeting packet only)
Halligan Water Supply Project Quarterly Update (tentative)
Meeting
Dates Agenda Topics/Action
Work Plan
Alignment
Meeting Materials are due
2 p.m. Wednesday the week before the meeting
October 20
‐‐Meeting materials deadline: 2 p.m. Wed Oct 12
Staff Reports
Financial Monthly Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
Memo: 2022 Summer Water Quality Update – Upper Cache la Poudre
Watershed (meeting packet only)
Director of Water Quarterly Update (20 min)
Regular Items
2023 Utility Rates and Fees (Lance Smith)(30 min)
Income‐Qualified Assistance Program Feedback (Shannon Ash)(40 min)
Allotment Management Program Update and Extension (Katie
Collins)(20min)
Other Business
Discuss 2022 Work Plan draft
Deadlines
Nov 30: Work Plan due
Schedule Annual Report to meet Jan 31 deadline
November 17
‐‐Meeting materials deadline: 2 p.m. Wed Nov 9
Staff Reports
Monthly Financial Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
Halligan Water Supply Project Quarterly Report (meeting packet only)
Regular Items
1041 Regulations Update (tentative)(Kelly Smith)
Other Business
Approval of 2023 Water Commission Work Plan
December 1
(Work Session)
‐‐Meeting materials deadline: 2 p.m. Wed Nov 23
December 15
‐‐Meeting materials deadline: 2 p.m. Wed Dec 7
Staff Reports
Financial Monthly Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
Director of Water Quarterly Update (20 min)
Regular Items
Fort Collins Urban Lakes Water Quality Management Policy (Richard
Thorp)(30min)
Other Business
Draft 2022 Water Board Annual Report
Meeting
Dates Agenda Topics/Action
Work Plan
Alignment
Meeting Materials are due
2 p.m. Wednesday the week before the meeting
January 19, 2023
‐‐Meeting materials deadline: 2 p.m. Wed Jan 11
Staff Reports
Financial Monthly Report (meeting packet only)
Water Resources Monthly Report (meeting packet only)
Memo: 2022 Fall Water Quality Update – Upper Cache la Poudre
Watershed (meeting packet only)
Future Agenda Items not yet scheduled
xxxxxxxxxxxx
Work Session Topics
Aquifer storage and recovery
Poudre River watersheds, post‐fire recovery
Halligan Reservoir, mitigation planning and responses to EIS comments
Floodplain variance overview
Status of vulnerability study and its implementation
Nutrient regulations and impacts on City’s wastewater treatment plants
Landscaping standards and raw water demand
Water budget approach to rates
DRAFT MINUTES WATER COMMISSION
REGULAR MEETING
August 18, 2022, 5:30-7:30 p.m.
Hybrid in person at 222 LaPorte Ave and online via Zoom
08/18/2022 – DRAFT MINUTES Page 1
1. CALL TO ORDER
5:31 p.m.
2. ROLL CALL
Commissioners Present: Jason Tarry (Chairperson), Greg Steed (Vice Chairperson),
John Primsky, Jordan Radin, Paul Herman, Rick Kahn, Tyler Eldridge, Randy Kenyon
Commissioners Absent - Excused: Ken Bruxvoort
Staff Members Present: Jason Graham, Lance Smith, Kelly Smith, John Song, Kendall
Minor
Members of the Public: None
3. AGENDA REVIEW
Chairperson Jason Tarry briefly summarized items on the agenda
4. COMMUNITY PARTICIPATION
None
5. APPROVAL OF MINUTES
CHAIRPERSON TARRY ASKED FOR COMMENTS AND REVISIONS ON THE JULY 21
MINUTES.
Commissioner Radin moved to approve the July 21 minutes.
Commissioner Herman seconded the motion.
Vote on the motion: it passed unanimously, 8-0
6. NEW BUSINESS
a. Staff Reports
(Attachments available upon request)
i. Financial Monthly Report
(meeting packet only)
DRAFT MINUTES WATER COMMISSION
REGULAR MEETING
08/18/2022 – DRAFT MINUTES Page 2
ii. Water Resources Monthly Report
(meeting packet only)
Discussion Highlights
There are no potential water restrictions as there has been a lot of rainfall
lately. The City did have to shut down the Poudre River source due to a leak
from a 27” raw water line this week. There is a 24” line that could be used if
the leak isn’t fixed soon. A Commissioner commented that there seemed to
be high turbidity in the river, but Staff Liaison Jason Graham responded that it
was not enough to shut down the source completely.
iii. 1041 Regulations Update
Senior Environmental Planner Kelly Smith provided an update on the 1041
Regulations for the City of Fort Collins, which allow local governments to
regulate areas and activities of state interest. It gives local governments
permitting authority over development projects even when the project has
statewide impacts. A local government must designate the areas or activities
of state interest and adopt guidelines pursuant to state statutory procedures
and limitations.
Discussion Highlights
A Commissioner asked what projects the regulations would apply to, to which
Ms. Smith clarified that it would apply to all projects within the City’s growth
management area (GMA). Another Commissioner inquired how many
projects this would capture. Ms. Smith responded that previous plans had
gone through the Site Plan Advisory Review (SPAR) process, through which
they did some analysis of past projects, and there had been about three or
four in the last ten years that would’ve been subject to the 1041 Regulations.
Another Commissioner inquired if projects outside of the City limits that would
affect water quality and availability in the City would fall under the regulations,
to which Ms. Smith responded that it would not as there has to be a specific
infrastructure within the City to serve as a nexus to these regulations.
Another Commissioner asked what the precipice had been to adopt 1041
Regulations to City codes, especially as many of the entities she’d listed that
had adopted the regulations were mostly counties. Ms. Smith responded that
it came down to a couple water projects that came through SPAR in the past
about which the public expressed frustration regarding the City’s role, and so
City Council initiated this so that it could be better involved in future City
projects. The Commissioner followed up with how Ms. Smith’s position is
DRAFT MINUTES WATER COMMISSION
REGULAR MEETING
08/18/2022 – DRAFT MINUTES Page 3
funded; she responded that she’s funded through general funding. This was
an inherited project that was not in the Council Work Plan, and so they had to
request additional funding of $50K for engagement efforts and technical
expertise from an attorney with experience writing these types of regulations.
The Commissioner asked for clarification for how many staff members are
involved; she responded that it was just her, as well as the land use attorney.
A Commissioner inquired if there’s any funding planned for staff in the future
to review projects through the 1041 Regulations. Ms. Smith said that there
have been conversations, but there may be just two projects a year to review
at most. The Commissioner commented that there is already the Northern
Integrated Supply Project (NISP) in the coming year that will need to be
reviewed, to which Ms. Smith reiterated that there will need to be
conversations about funding the review process, as well as conceiving
processes to put in place, as the regulations could have an opportunity to
grow through new designations of activities and areas. A Commissioner
commented that other water supplying entities within the GMA may run into
hurdles or issues due to the regulations, but Ms. Smith clarified that existing
and maintenance projects would not be subject to review, as well as
stormwater projects, as only domestic water and wastewater projects are
defined to be subject to review. Staff Liaison Jason Graham added that Ms.
Smith has done a great job engaging stakeholders to inform them of the new
regulations. Another Commissioner wondered if the Planning and Zoning
Commission is the only entity that is equipped to interpret these regulations.
Ms. Smith responded that City staff will compile research, consult technical
experts, and work with outside agencies to make an informed
recommendation to the Planning and Zoning Commission, which would then
make a recommendation to City Council, who would be the ultimate decision
maker regardless of Commission and staff recommendations. A
Commissioner clarified that it would be up to the applicant’s expense to fund
any consultants. Another Commissioner wondered whether the initial
application review for anything water-related shouldn’t come to the Water
Commission—such as projects related to water conservation, groundwater,
water quality—to which Ms. Smith answered she’d look into the charter and
what the Water Commission is able to review, and whether the process can
be changed to include Water Commission recommendations. Another
Commissioner inquired about public engagement. Ms. Smith responded that
there are neighborhood meetings, public notification processes prior and after
decisions, the formal public hearings, as well as public comments at the
Planning & Zoning Commission meetings. The Commission expressed that
they would like to hear another update in October on changes and how to be
funded.
DRAFT MINUTES WATER COMMISSION
REGULAR MEETING
08/18/2022 – DRAFT MINUTES Page 4
iv. 2022 Budget Update
Financial Planning and Analysis Director Lance Smith presented to provide a
mid-year update on the current year financial performance of each utility, as
well as to present the revenue forecasts and budget offers for the 2023-24
budget cycle.
Discussion Highlights
A Commissioner asked clarification whether underspent budget that carries
into the next year has an adverse effect on future budgeting and needs to be
re-allocated. Mr. Smith responded that it does not. A Commissioner inquired
about predictions regarding Utility rate adjustments. Mr. Smith responded that
there’s a self-imposed ceiling of a 5% increase, but inflation has been a big
factor as of late, and he will return in October to request a recommendation
for rate increases to take to Council. A Commissioner inquired whether the
$16M budget offer for the Halligan Project is to buy permitted easements, fee
titles, condemned properties, etc. Mr. Smith responded that permitting efforts
run about $1M a year. Another Commissioner asked about the budget plan
for staff for Halligan. Director of Water Utilities Jason Graham responded that
there is an offer for a permit coordinator, derived from a conversion from what
we have now up to a full-time position, but the project manager and
coordinator positions are not included in the $16M budget request, but rather
their own offers. He clarified that these are just proposals, and decisions
need to go to City Council first. The Commissioner further inquired whether
the $16M budget would support necessary consultations, to which Mr.
Graham responded that it would definitely help fund consultant fees. A
Commissioner would like to see a breakdown of the Halligan budget request
to have better insight, and Mr. Smith mentioned that much of the information
is in the offer narrative, though it may not be all-inclusive. Mr. Graham added
that they are currently planning to rebuild the team better going forward by
resourcing, prioritizing, and funding it differently than before, and to raise the
level of importance of shared commitment. Utilities Executive Director
Kendall Minor added that they are looking for better longevity and
consistency, and to achieve that, they currently have a request for proposal
(RFP) for staffing consultants just for Halligan to avoid burnouts, with
additional consulting dollars in the Executive Director budget if needed.
Ultimately, they can’t start building until 2026 until the permitting and land
acquisitions are complete, but the City will need to submit its estimates in the
next two weeks to the Army Corps of Engineers. Mr. Smith added that if the
$16M is not enough, they will need to submit a midcycle appropriation. A
Commissioner inquired about the reserves to gain perspective and would like
to see a completed analysis. Mr. Smith responded he’d come back in
October with a reserve analysis, and continued by explaining that there were
DRAFT MINUTES WATER COMMISSION
REGULAR MEETING
08/18/2022 – DRAFT MINUTES Page 5
84M in the water fund reserve at the end of last year, a lot of which is
appropriated to projects such as the Halligan Project, leaving about 41M in
the reserves not appropriated to any projects. A Commissioner asked if
there’s a prioritization list for the budget offers. Mr. Smith responded that the
Budget Lead Team draws the line, but nothing can be claimed for certain until
the City Manager’s recommendations are released in two weeks. A
Commissioner inquired about the meaning of a 0.2 full-time employee (FTE),
to which Mr. Graham responded that it may mean that different departments
or divisions fund a FTE. Another Commissioner asked about keeping up with
the market regarding FTE compensation. Mr. Smith responded that the BLT
is looking at the reality of that, but ultimately, it will be up to the City
Manager’s recommendation and City Council’s decision. Mr. Minor added
that in regard to market analysis to invest in existing staff, they’re anticipating
a substantial 4.5-8% salary increase that’s baked into the offer to remain
competitive, to which Council seems very supportive. Mr. Graham added that
recruitment has been challenging as of late, which is why they’d like to see
the appropriate adjustments made. Another Commissioner inquired about the
Wastewater fund and the concern around the 4% rate increase, to which Mr.
Smith responded that the concern centers around burdening rate payers at a
time if the economy may enter a recession. Another Commissioner inquired if
there’s funding for per- and polyfluoroalkyl substances (PFAS) and whether
there’s a need. Mr. Graham responded that there currently is not funding, as
there is not a lot of treatment needs just yet, just investigation that’s being
absorbed by the current budget. Mr. Minor responded that there is high
importance around it, and so are ready to respond when the need arises.
7. COMMISSIONER REPORTS
Commissioner Kahn met with City staff from Water and Natural Areas regarding the
recreational aspect of the Halligan Dam.
Typically the chairperson adopts the Work Plan as put forth by the previous
chairperson, and Chairperson Tarry would like spend a Work Session to talk about
priorities prior to the transition in order to give more guidance.
Meadow Springs Ranch tour.
8. OTHER BUSINESS
None
DRAFT MINUTES WATER COMMISSION
REGULAR MEETING
08/18/2022 – DRAFT MINUTES Page 6
9. ADJOURNMENT
7:48 p.m.
These minutes will be approved by the Water Commission on September 15, 2022.
YTD Variance Report ($1,000's)Category501 - L&P 502 - Water 503 - Wastewater 504 - Stormwater 605 - CS&AOperating Revenue7,741 1,821(30)(79)0Operating Expense(72)4,7804056251,825Development Fees/PIFs/Contributions4,789(472)105152N/AOther Revenues**215158118125271Payments and Transfers(17)(111)(99)(79)(0)Debt Service0000Capital Expense (inc Minor Capital)*6,9914,3984,3103,11841Positive variance indicates higher than expected revenues and lower than expected expensesCurrent Month Variance ReportCategory501 - L&P502 - Water503 - Wastewater 504 - Stormwater 605 - CS&AOperating Revenue1,571451(11)(5)0Operating Expense(344)1,667(196)52169Development Fees/PIFs/Contributions(200)(99)2168 N/AOther Revenues**13461444251Payments and Transfers(0)(176)(101)(99)(0)Debt Service0000Capital Expense (inc Minor Capital)*1,3214408873631Positive variance indicates higher than expected revenues and lower than expected expenses*Actual expenditures not a variance**Does not include unrealized gain/loss on value2
$112.1$25.0$17.6$13.5$13.1107.5523.5717.9613.6913.29$115.3$25.4$17.9$13.6$13.3$0.0
$20.0
$40.0
$60.0
$80.0
$100.0
$120.0
$140.0
Light & Power Water Wastewater Stormwater CS&A
Operating Revenues ($M)
2021 YTD Actual
2022 YTD Budget
2022 YTD Actual
$4.4$1.6$0.9$1.1$2.13 $1.16 $0.29 $0.40 $6.9$0.7$0.4$0.5$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
$7.0
$8.0
Light & Power Water Wastewater Stormwater
PIF / Development Fee Revenues ($M)
2021 YTD Actual
2022 YTD Budget
2022 YTD Actual
3
$1.11 $2.40 $1.10 $0.00 $1.97 $1.58 $0.06 $2.31 $0.0
$1.0
$2.0
$3.0
Interest Revenue Financing Sources Other Misc
Non-operating Revenues ($M)*
2021 YTD Actual
2022 YTD Budget
2022 YTD Actual
*excludes unrealized gain/loss on value
$95.2$16.4$10.0$5.5$11.7$100.80 $21.84 $11.34 $6.57 $13.78 $100.9$17.1$10.9$5.9$11.7$0.0
$20.0
$40.0
$60.0
$80.0
$100.0
$120.0
$140.0
Light & Power Water Wastewater Stormwater CS&A
Operating Expenses ($M)
2021 YTD Actual
2022 YTD Budget
2022 YTD Actual
$3.3$5.1$2.7$3.3$2.2$3.5$3.6$2.3$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
Light & Power Water Wastewater Stormwater
Capital Expenses ($M)
2021 YTD Actual
2022 YTD Actual
4
FINANCIAL MONTHLY REPORT UTILITIES SERVICES - SUMMARY AS OF SEPTEMBER 30, 2022 ISSUED OCTOBER 2022 5
Utility Services2022 Revenue$ in thousandsPercent of Year: 75%Actual 2022Over/(Under) BudgetBudget 2022Actual 2022Over/(Under) BudgetInc/(Dec) 2021% Bud Recvd 2022% Current Act vs. Prior ActElectric Charges for Services*15,6041,571 107,546 115,2877,741 3,23382% 103%Water Charges for Services*4,455451 23,570 25,3911,821 40582% 102%Wastewater Charges for Services*2,122(11) 17,957 17,928(30) 32375% 102%Stormwater Charges for Services*1,516(5) 13,693 13,614(79) 14074% 101%Customer Srv & Admin Fund Charges1,476(1) 13,288 13,281(7) 19575% 101%Interest Revenue294187 1,101 1,575474 470114% 142%Other Miscellaneous325145 1,965 2,378413 (76)85% 97%Development Fees/PIFs/Contributions279(210) 3,982 8,5554,574 495148% 106%TOTAL BEFORE UNREALIZED GAINS/LOSSES26,0722,126 183,103 198,009 14,907 5,18582% 103%Unrealized Invst. Gains/Losses(2,926)(2,926)0 (12,058) (12,058) (11,013)0% 1153%GRAND TOTAL23,145(800) 183,103 185,9512,848 (5,827)77% 97%SeptemberYear to DateYTD Variance Analysis:Electric Charges for Services:Residential Revenues are 14.2%, or $5,980, over budget and and Commercial Revenues are 5.6%, or $1,872, over budget. Industrial Revenues are 1.8%, or $469, under budget.Water Charges for Services:Residential Water Sales are 5.2%, or $676, over budget, Commercial/Industrial Water Sales are 8.8%, or $616, over budget, Raw Water Surcharges are are 811%, or 524, over budget, and District Water Sales are 22%, or $305, over budget, offset by Other Water sales, which are 42.6%, or $386, under budget.Wastewater Charges for Services:Commercial/Industrial Revenues are 3.9%, or $180, under budget offset slightly by Residential Revenues are 0.8%, or $93, over budget.Stormwater Charges for Services:Non-Single Family Residential Revenues are 0.9%, or $65, under budget, followed by Single Family Revenues at 0.2%, or $14, under budget. Other Miscellaneous:CS&A $262, Wastewater $47, Light and Power $41, Stormwater $34, and Water $12. Development Fees/PIFs/Contributions:Light & Power $4,789 (there are several large construction projects driving the over budget amount), Stormwater $152, Wastewater $105, and Water ($952).Unrealized Investment Gains/Losses:Water ($4,703), Light and Power ($2,864), Wastewater ($2,514), Stormwater ($1,786), and CS&A ($190).6
Utility Services2022 Department Expense$ in thousandsPercent of Year: 75%Actual 2022(Over)/Under BudgetBudget 2022Actual 2022(Over)/Under Budget(Inc)/Dec 2021Actual + PO's 2022% Annual Budget Spent & EncumberedLight & Power Fund4,019 (402) 31,033 31,040(7) (1,838) 34,13378%Purchase Power8,690 (454) 72,376 74,574 (2,198) (4,527) 102,920109%Stormwater Fund80252 7,572 6,723848 (698) 7,65963%Utility CS&A Fund1,291189 13,781 11,714 2,068 (15) 12,76766%Wastewater Fund1,462 (174) 12,261 11,940321 (1,174) 12,69464%Water Fund1,943 1,815 23,153 17,920 5,233 (900) 23,11871%TOTAL18,207 1,026 160,176 153,911 6,265 (9,152) 193,29187%SeptemberYear to DateYTD Variance Analysis:Light & Power-Energy Services $2,154 (Energy Services Program is under budget $1,441 (Consulting $717, Rebates & Incentives $557, mostly due to the timing of payments to vendors/partners and the pace of participation in programs). Community Renewables is under budget $528 mostly due to Conservation Incentives and the delayed timing of solar installations. Demand Response is under budget by $186 mostly for Consulting Services due to the timing of vendor payments.) Offset by System Addition/Replacement ($2,148) (Utility Supplies ($1,566), these supplies are for new construction and system capacity upgrades; Personnel is also over budget $407, there are several large projects under construction.) Purchase Power-Purchase Power-Tariff 1 ($2,198) (weather and actual demand (COVID event changes) for the year are key factors on the spend in Tariff 1 from PRPA, also the percentage of intermittent energy billed is higher than prior years, and that cost per kWh is twice the dispatchable energy cost). CS&A -IT $912 (Personnel $391 (vacancies), Software Maintenance & Support Services $240 (awaiting to pay $47 (Utilities portion) of DirSec invoice for Checkpoint Firewall; some invoices passed to Utilities through server team at inconsistent times ($54 for Redhat/Linux, $21 for Zerto); bought $31 less Maximo licenses than planned -haven't needed as many, yet; 2022 budget developed using the same budget assumptions as 2021; under budget by YE), Computer Hardware - Capital $165 (BFO offer 3.10 Migration off of Exadata - paying quarterly, budget distributed in Jan.; unsure if remaining will be used, potentially ~$140 underspend by YE (year-end)), Computer Software $81 (mostly encumbered for Mythics Oracle Database Appliance $61, should be paid in Q4), Conference & Travel $26 (some virtual rather than in person and some not being held; under budget ~$15-20 by YE), Consulting $187, Computer Hardware $12, offset by Other Professional & Tech. ($40) (outsourcing Sr Oracle DBA - overspend to be offset in Personnel and some in Consulting, ~$90 over by YE)), Minor Capital $243 (Vehicles/Equipment (IT $142, Locates $63, and Support Services $26), Customer Accounts $167 (Personnel $128 and Consulting $32), Finance & Asset Mgmnt $150 (Personnel $81 (vacancy), Consulting/Financial Consulting $47), and Executive Director's Office $147 (Consulting $191, Software Maintenance & Support $211, and Other Contingency $75 (related to OASIS and ancillary costs), offset by Motor Vehicles & Accessories ($45), Personnel ($286) (Interim Executive Director's time charged here and Water Director's time being charged here), and Meals - Business, Non Travel ($12).Water-Water Treatment $2,555 (Contract Payment to Gov't $2,103 (for Cameron Peak Fire - Watershed payments) and multiple other smaller underspends and overspends), Water Resources $1,424 (Water Assessments $876 (2 large invoices ($639 and $257) paid in Oct rather than Sept and budget for Ridgen distributed in Feb.,while invoicing happens after YE, will book in Dec), Consulting $237 (project delays due to vacancies (e.g. modeling effort), some underway; underspend by YE, and some will be carried forward), Personnel $211 (vacancies), and Other Prof. & Tech. $39 (primarily for NISP outreach BFO offer #1.63 - on hold due to NISP Record of Decision delay)), and Water Engineering $447 (Consulting Services $279 (Large Valve Maintenance work, all but $73 encumbered), and Personnel $124 (vacancies)).7
Utility Services2022 Expense Type$ in thousandsPercent of Year: 75%Actual 2022(Over)/Under BudgetBudget 2022Actual 2022(Over)/Under Budget(Inc)/Dec 2021Actual + PO's 2022% Annual Budget Spent & EncumberedPersonnel Costs3,084119 29,993 28,6001,393 (1,079) 28,60068%Purchased Prof & Tech Services1,366124 9,179 4,7024,477 (359) 10,86474%Purchased Property Services582 1,149 8,547 6,5322,015 628 7,08263%Other Purchased Services3,31024 27,697 27,543154 (1,512) 27,63675%Supplies9,762(813) 78,230 82,209 (3,979) (5,709) 111,154109%Capital Outlay72248 4,071 2,9971,075 (1,648) 4,97580%Other30176 2,188 1,0581,130 70 2,71049%Debt & Other Uses00270 2700 457 2708%TOTAL18,207 1,026 160,176 153,9116,265 (9,152) 193,29187%SeptemberYear to DateYTD Variance Analysis: Personnel:CS&A $672, Water $586, Stormwater $285, Wastewater $167, (primarily due to vacancies and turnover); and Light and Power ($318) (due to several projects in system additions).Purchased Prof & Tech Services-Water $3,114 (Contract Payment to Gov't $2,103 (payments to Greeley: Cameron Peak Fire - Watershed), and Consulting in Engineering $277 (primarily Large Valve Maintenance work), Water Resources $234 (project delays due to vacancies (e.g. modeling effort), some underway; underspend by YE), and Water Conservation $157), Light & Power $588 (Consulting - due to delay in payments to partners and participation of incentive programs), offset by Legal Services ($410) (OASIS/Open Int'l lawsuit), Wastewater $231 (Consulting $261 (primarily DWRF Utility Mapping), offset by Legal Services ($96) (OASIS/Open Int'l lawsuit), Stormwater $393 (Consulting in Engineering $312 (primarily BFO offer 4.16 Poudre River Flow Consolidation Study) and Disposal of Hazardous Material $144 (haven't received billed for HHW, yet), offset by Legal Services ($101)(OASIS/Open Int'l lawsuit)), and CS&A $152 (Consulting $265, Education & Training $26, Legal Services $26, , and other smaller underspends, offset by Banking Services ($119), Contractual Labor ($64), Other Professional & Technical ($48), Security Services ($33).Purchased Property Services -Water $1,213 (Water Assessment Services $889 (2 large invoices ($639 and $257) paid in Oct rather than Sept), Street & Bridge Maintenance Services $116, Maintenance Contracts $103, Electricity $55, and other smaller underspends, offset by Traffic Control Services ($26), and Natural Gas ($25)), CS&A $558 (Software Maintenance/Support $465, Building Maintenance $90, offset by Janitorial Services ($42)), Light & Power $246(Hardware/Software Maint & Support $242 - due to the timing of payments to vendors/partners).Supplies-Light & Power ($4,019) (Purchased Power ($2,198) - largest portion over budget is variable based on weather, demand, and cost mix of intermittent and dispatchable energy) Utility Supplies ($1,530 - for new construction and system capacity upgrades; there are several large projects under construction), CS&A $123 (Computer Hardware/Software $107).Other - Light & Power ($986) (Rebates & Incentives ($934), due to delayed timing of solar installations and participation in programs). 8
Utility ServicesNon Lapsing Expenses9/30/2022Year to Date ActualLife to Date ActualLife to Date Budget PO's CommittedAvailable Remaining115 - New Capacity-Duct Banks - - 915,338 - 915,338 117 - Substation Cap Proj 154,270 1,562,763 4,658,721 144,072 2,951,886 118 - New Capacity - Circuits - 1,063,462 3,635,236 - 2,571,774 119 - Dist. System Impr. & Replace 1,377,498 4,208,100 10,382,241 3,263,807 2,910,334 120 - Operational Technology - 2,252,982 3,180,000 81,165 845,854 130 - SW Enclave Sys Purchases - 44,238 1,262,000 - 1,217,761 133 - Underground Conversion 276,041 279,051 1,715,359 220,103 1,216,205 304 - Service Center-L&P Parent 91,410 2,287,615 3,463,907 205,889 970,403 Art in Public Places35,299 799,558 1,191,689 18,264 373,867 CIS Upgrade/Repl - L&P Parent(377,825) 2,988,101 3,680,771 620,431 72,240 CMMS–Maintenance Management31,156 1,055,980 1,598,249 90,201 452,067 Project<$1M655,159 828,828 2,705,992 703,315 1,173,849 Substation Cap Prj - Parent- - 1,200,245 - 1,200,245 Light & Power Fund Total2,243,010 17,370,678 39,589,747 5,347,246 16,871,824 100 - Util Ser Cntr Add/Remodel 14,866 46,861 109,400 1,534 61,005 103 - SW Basin Improvements 1,458,557 10,442,630 13,738,718 1,254,001 2,042,087 2018-Mail Crk; Palmer-Passway24,260 1,545,162 2,808,900 56,739 1,206,999 226 - Spring Crk Basin Improv - 116,667 119,550 - 2,883 236 - SW Master Planning 165,986 1,069,205 1,538,205 14,533 454,467 237 - Flood Mapping/Stream Gagin - 515,346 550,918 - 35,572 238 - SW Developer Repays 43,891 43,891 792,416 - 748,526 CIS Upgrd/Repl - Stmwtr Parent(161,904) 1,305,055 1,610,338 271,440 33,843 CMMS–Maintenance Management17,392 1,086,387 1,204,879 70,568 47,924 Project<$1M(252,291) 1,637,795 2,904,420 110,285 1,156,340 2017-Remington St Storm Sewer45,355 3,202,583 3,258,200 8,999 46,618 2017-MagnoliaPreDsn-OakDsnCnst476,081 1,912,025 2,920,000 826,654 181,321 141 - Cured in Place Pipe 303,131 383,704 900,000 88,892 427,404 139 - Stream Rehabilitation Program 136,926 310,796 3,100,000 124,674 2,664,530 140 - Poudre Levee Program 50,694 512,114 2,479,700 524,312 1,443,274 2019 - N Mason Area Drainage36,503 564,997 3,267,800 461,236 2,241,567 Stormwater Fund Total2,359,447 24,695,217 41,303,445 3,813,868 12,794,360 9
Year to Date ActualLife to Date ActualLife to Date Budget PO's CommittedAvailable Remaining102 - DWRF CIP Summary 3,401 4,458,927 4,705,000 130,905 115,168 2017-Dewatering Improvements4,174 4,076,204 4,270,000 11,900 181,896 2017-Sludge Strain Press- 1,414,330 1,520,000 - 105,670 2018-Digester Lid 61224,242 1,797,033 2,100,000 243,302 59,665 2018-Sidestream Treatment152,165 5,025,452 5,400,000 17,473 357,074 2019-DWRF Carbon Add Phase 1(32,429) 1,582,815 2,200,000 230,303 386,883 212 - WW Collection Sys Replcmnt 2,348,434 4,326,301 8,784,416 1,227,388 3,230,727 214 - WW Svc Ctr Improvements 14,866 46,861 109,400 1,534 61,005 216 - Sludge Disposal Improv - - 365,746 - 365,746 220 - MWRF Improvements - - 11,254 - 11,254 221 - Wtr Reclam Replcmnt Prgm 34,265 1,399,677 4,687,910 104,495 3,183,738 Art in Public Places22,614 525,057 1,164,344 - 639,287 CIS Upgrd/Repl - Wstwtr Parent(183,518) 1,445,002 1,782,874 300,566 37,306 CMMS–Maintenance Management29,263 1,244,422 1,628,165 354,722 29,021 Project<$1M140,173 1,848,013 6,567,054 315,437 4,403,604 2021-DWRF NPT Clarifier Replac349,142 579,948 6,200,000 2,089,069 3,530,983 245 - WW DWRF HVAC - - 400,000 - 400,000 244 - WW Dev Repays 631,723 631,723 750,000 - 118,277 Collection Sys Replace Pgm- - 1,420,000 - 1,420,000 Wastewater Fund Total3,538,516 30,401,765 54,066,164 5,027,093 18,637,306 101 - Water Meter Replace & Rehab 531,161 1,231,534 2,619,871 - 1,388,338 105 - High Park Fire - 45,000 342,688 - 297,688 196 - Distribution Sys Replcmnts 1,293,314 2,368,085 6,615,460 1,801,941 2,445,435 198 - Wtr Svc Ctr Improvements 29,732 93,723 166,900 3,069 70,109 2017-Undergrnd Elec Pow Supply- (0) 1,300,000 - 1,300,000 2017-Water Quality Lab Rehab- 712,553 2,600,000 - 1,887,447 2018-AB Cathodic Protection49,039 2,191,173 2,280,000 16,769 72,059 206 - Water Supply Development - 128,492 1,127,901 - 999,410 210 - Treatment Facility Improv - - - - - 211 - Water Prod Replcmnt Prgm 354,669 1,211,749 3,666,812 1,110,271 1,344,792 301 - Watershed Protection - 74,500 352,887 33,688 244,699 313 - Wtr Cathodic Protection - - 6,337 - 6,337 Art in Public Places17,803 786,576 1,552,694 11,632 754,486 CIS Upgrade/Repl - Wtr Parent(248,251) 2,003,929 2,473,018 416,897 52,192 10
Year to Date ActualLife to Date ActualLife to Date Budget PO's CommittedAvailable RemainingCMMS–Maintenance Management65,316 1,749,670 2,193,914 438,016 6,228 Halligan Res Enlargement Proj1,028,564 28,979,400 37,377,446 3,240,003 5,158,044 Project<$1M6,800 910,944 2,844,453 175,862 1,757,647 2019-Enviro Learn Center Dam206,984 845,044 2,964,795 155,355 1,964,395 2021-27-Inch Poudre Canyon Wtr183,081 334,283 3,200,000 451,431 2,414,286 242 - Water Quality Lab Inst Repl 38,771 38,771 230,000 - 191,229 Water Fund Total3,556,984 43,705,425 73,915,177 7,854,933 22,354,819 11
FINANCIAL MONTHLY REPORT LIGHT AND POWER FUND AS OF SEPTEMBER 30, 2022 ISSUED OCTOBER 2022 12
Light and PowerRevenuein thousandsPercent of Year 75.0%SeptemberYear to DateActualOver/ (Under)BudgetActualOver/ (Under) Inc/(Dec)% Bud Recvd % Act Recvd2022 2022 Bud 2022 2022 2022 Bud202120222021Residential Elec Services$ 6,544 * $ 1,152 $ 42,199 $ 48,179 $ 5,980(A)$ 526 88%80%Commercial Elec Services4,906 * 369 33,608 35,480 1,872(B)1,861 80%80%Industrial Charges for Services3,255 * (31) 25,446 24,977 (469)(C)655 74%77%Green Energy Program16(8)207126(80)12 37%84%PILOTs88389 6,086 6,524438180 82%79%Operating Revenue15,604 1,571 107,546 115,287 7,7413,233 82%79%Interest Revenue7151213387174138 143%103%Development Fees/PIFs/Contributions111 (200) 2,133 6,922 4,789(D)2,490 237%105%Financing Sources424204242381223%Other Misc11641828827(1)(539) 76%45%Total Lapsing Revenue**15,944 1,505 110,720 123,465 12,7455,361 85%80%Non-lapsing Revenue261285285TOTAL**$ 16,205$ 123,750$ 5,646Variance Analysis:(A)(B)(C)(D)***Commercial Revenues are 5.6% over budget and are 5.5% higher than YTD 2021.September billed revenue is for August and early September.Note: Electric rate increase of 2.0% for 2022, as budgeted.Industrial Revenues are 1.8% under budget but are 2.7% higher than YTD 2021.Residential Revenues are 14.2% over budget and are 1.1% higher than YTD 2021.Development/PIF fees are 224.5% over budget and are 56.2% higher than YTD 2021. There were four large construction projects (billed over $100K) added in Q1, five in Q2, one in July, and two in August, these developments keep us over budget year-to-date.Excludes transfers, unrealized gain/loss on value, and EPIC loans.13
Light and Power Fund2022 Department ExpenseIn thousandsPercent of Year 75.0%Excludes depreciation and transfersSeptemberYear to DateActual(Over)/ UnderYTD Budget Actual(Over)/ Under (Inc)/DecActual + PO's% Bud Spent & Committed2022 2022 Bud 20222022 2022 Bud 20212022by PO'sPurchase Power -Tariff 1 PRPA$ 8,690 $ (454) $ 72,376 $ 74,574 $ (2,198)(A)$ (4,527) $ 102,920109%Purchase Pwr - Community Renewables250(98)1,556 1,759 (204)(268) 1,75985%L&P Operations952567,984 7,721263(511) 7,82471%Energy Services3061935,170 3,016 2,154(B)218 5,51274%PILOTs883(41)6,453 6,524(70)(C)(180) 6,52477%Admin Services - CS&A62405,612 5,6120(77) 5,61275%Other Payments & Transfers172(0)1,648 1,664(17)(356) 1,66468%Subtotal Operating Expense$ 11,875 $ (344) $ 100,798 $ 100,870 $ (72) $ (5,699) $ 131,81499%Debt Service0$ 0$ 000130 #DIV/0!System Addition/Replacement834 $ (513) $ 2,611 4,759 (2,148)(D)(693) 5,391106%Total Lapsing$ 12,709 $ (856) $ 103,409 $ 105,629 $ (2,220) $ (6,380) $ 137,20599%Non-lapsing Expenses4872,2321,043TOTAL$ 13,196$ 107,861$ (5,337)Variance Analysis:(A)(B)(C)(D)Purchase Power is over budget by $2,198. There was a 2.8% expected impact on the wholesale purchase power rate increase in 2022. Weather and actual demand (COVID event changes) for the year are key factors on the spend from PRPA. Also, the percentage of intermittent energy billed is higher than prior years, and that cost per kWh is twice the dispatchable energy cost. The coincident peak occurred on September 6th at 6pm.PILOTs are 6% of electric revenues that are paid to the General Fund.Energy Services is under budget by $2,154 due to the following: Energy Services Program $1,441 (Consulting $717, Rebates & Incentives $557, mostly due to the timing of payments to vendors/partners and the pace of participation in programs). Community Renewables is under budget $528 mostly due to Conservation Incentives and the delayed timing of solar installations. Demand Response is under budget by $186 mostly for Consulting Services due to the timing of vendor payments. System Additions & Replacements over budget by $2,148 due to the following: Utility Supplies which are over budget $1,566, these supplies are for new construction and system capacity upgrades; there are several large projects under construction. Personnel is also over budget $407, Legal Services over by $405 for the OASIS/Open International litigation, offset by Vehicles which is under budget $287.14
Light & Power Fund Capital Projects2022YTDLTDOpen 9/30/2022 %and GrantsLTD9/30/2022 9/30/2022 Enc/ReqAvail Budget BudgetExpense Expense 9/30/2022 Balance Remain5010090000 CMMS–Maintenance Management$1,598,249$31,156 $1,055,980 $90,201 $452,067 28.3%5010100000 Art in Public Places$959,918$23,809 $554,736 $20,080 $385,103 40.1%5010260000 Demand Response Tech Upgrade$871,000$471,008 $471,008 $347,935 $52,057 6.0%5010300000 CIS Upgrade/Repl - L&P Parent$3,680,771 ($377,825) $2,988,101 $620,431 $72,240 2.0%5010300001 2021-Data Mgmt Prgm+Analy Plat$312,675$0$22,593$0 $290,082 92.8%5010010000 Substation Cap Prj - Parent$1,200,245$0$0$0 $1,200,245 100.0%5010010123 Substation Improvements$1,862,000$8,350 $1,077,881 $144,072 $640,047 34.4%5010012733 Design SCO Remodel & Upgrade$10,000$0$3,895$0$6,105 61.1%5010012768 Timberline Oil Containment$15,000$0$7,941$0$7,059 47.1%5010012780 2019 Harmony Sub Cap Bank$45,000$0$35,515$0$9,485 21.1%5010012815 2020 DixsonSubRTU-RelayUpgrade$150,000$0 $104,377$0 $45,623 30.4%5010013691 2022 eSCADA$75,000$10,377$10,377$0 $64,623 86.2%5010013695 2022 Richards Lake Subs Gravel$117,721$117,770 $117,770$0($49) 0.0%5010013707 2022 Substation Transformers$2,234,000$0$0$0 $2,234,000 100.0%Substations Project Summary$5,708,966$136,497 $1,357,756 $144,072 $4,207,138 73.7%5010020000 Service Center - L&P Parent$20,500$0$0$0 $20,500 100.0%5010022802 2019-SCO Design Rmdl & Upgrade$2,620,000$31,444 $2,215,042 $199,752 $205,206 7.8%5010022829 2020 700 Wood St Front Entry$70,000$59,966$61,166 $6,137$2,697 3.9%5010023557 2021 PFA & FCU Training Center$165,000$0$11,408$0 $153,593 93.1%5010023697 2022-USC Bckup Powr, Dual Feed$181,650$0$0 $87,500 $94,150 51.8%5010023698 2022 - Disaster Recovery Site$406,757$0$0$0 $406,757 100.0%Service Center/UAB Summary$3,463,907$91,410 $2,287,615 $293,389 $882,903 25.5%5010040000 System Purchases$1,127,000$0$0$0 $1,127,000 100.0%5010042822 2020 Soldier Canyon Pump Annex$135,000$0$44,238$0 $90,762 67.2%SW Annexation Summary$1,262,000$0$44,238$0 $1,217,761 96.5%5010050000 New Capacity-Circuits$1,355,636$0$0$0 $1,355,636 100.0%5010052762 Water Treatment Facility Annex$1,300,000$0 $1,063,462$0 $236,538 18.2%5010053617 2021 Drake Dixon Tie CKT phse1$152,400$35,518$35,518 $11,983 $104,899 68.8%5010053679 2022 Drake Dixon Tie CKT phse2$259,600$0$0$0 $259,600 100.0%5010053699 2022 CKT 322 - Timberline$720,000$0$0$0 $720,000 100.0%New Capacity-Circuits Summary$3,787,636$35,518 $1,098,980 $11,983 $2,676,672 70.7%5010080000 New Capacity-Duct Banks$915,338$0$0$0 $915,338 100.0%New Capacity-Duct Banks Summary$915,338$0$0$0 $915,338 100.0%15
Light & Power Fund Capital Projects2022YTDLTDOpen 9/30/2022 %and GrantsLTD9/30/2022 9/30/2022 Enc/ReqAvail Budget BudgetExpense Expense 9/30/2022 Balance Remain5016010000 Distribution Conversions$533,859$0$0$0 $533,859 100.0%5016012823 2021 Tefft Acres OH to UG Conv$324,000$1,556$1,556$0 $322,444 99.5%5016013552 2021 OH to UG - Mountain Vista$125,000$90,303$93,313$0 $31,687 25.3%5016013536 2022 Hyline Dr OH to UG Conv$97,500$1,750$1,750 $31,500 $64,250 65.9%5016013547 2022 Kyle-Lynn-Vivian OH to UG$425,000$314$314 $188,603 $236,083 55.5%5016013550 2022 OH to UG - Willox Ln$50,000$15,389$15,389$0 $34,611 69.2%Underground Conversion Summary$1,555,359$109,313 $112,323 $220,103 $1,222,933 78.6%5010120000 Dist. System Impr. & Replace.$476,126$0$0$0 $476,126 100.0%5010122797 2019 CICR1 - Woodwest$170,000$61,425 $112,962$0 $57,038 33.6%5010122809 2019 Cable Prirty#4 Stonehenge$231,250$16,944$86,487$0 $144,763 62.6%5010122810 2019 Cable Prirty#7 Village E.$242,000$73,306 $165,380$0 $76,620 31.7%5010122816 2021 Cable Priority #3-Skyview$200,500$0$0$0 $200,500 100.0%5010122817 2020 Cable priorty 5 Guard Anx$317,000$41,103 $165,184$0 $151,816 47.9%5010122830 2021 Priority #10 - Southmoor$245,500$121,249 $121,249$0 $124,251 50.6%5010123243 2019 CR1-Transformers Woodwest$16,500$7,623$8,961$0$7,539 45.7%5010123249 2019 CR4-Transfrmrs Stonehenge$23,000$0$2,255$0 $20,745 90.2%5010123250 2019 Transformers Village East$22,500$0$971$0 $21,529 95.7%5010123255 2020 CR5 Transformrs Guard Anx$31,500$1,082$1,082$0 $30,418 96.6%5010123538 2021 Cable Rpl Non-Work Ord$100,000$0$35,688$0 $64,312 64.3%5010123539 2021 Cable Rpl - Connexion$200,000$0 $136,472$0 $63,528 31.8%5010123542 2021 CR10-Transform Southmoor$22,000$3,248$3,248$0 $18,752 85.2%5010123649 2022 Cable Rpl Non-Work Order$100,000$2,119$2,119$0 $97,881 97.9%5010123650 2022 Cable Rpl - Connexion$100,000$17,591$17,591$0 $82,409 82.4%Dist. System Impr. & Replace Summary$2,497,876$345,691 $859,648$0 $1,638,228 65.6%5010130000 Operational Technology$780,000$0$0$0 $780,000 100.0%5010132718 Operational Technology$2,400,000$0 $2,252,982 $81,165 $65,854 2.7%Operational Technology Summary$3,180,000$0 $2,252,982 $81,165 $845,854 26.6%5010140000 Transformers - Parent$0$0$0$0$05010143525 2021 Transformer Purchases New$720,000$74,070 $666,503 $48,610$4,887 0.7%5010143602 2021 Addtl Transformer Purch$1,260,000$263,262 $442,121 $816,445$1,435 0.1%5010143647 2022 Transformer Purchases New$792,811$0$0 $788,914$3,897 0.5%5010143706 2022 Addtl Transformer Purch$1,432,000$0$0 $1,379,522 $52,478 3.7%Transformers Summary$4,204,811$337,332 $1,108,624 $3,033,491 $62,697 1.5%5010150000 Streetlights - Parent$0$0$0$0$05010153526 2021 Streetlight Replacements$702,000$7,045 $700,730$0$1,270 0.2%5010153648 2022 Streetlight Replacements$996,000$596,572 $596,572$0 $399,428 40.1%Streetlights Summary$1,698,000$603,617 $1,297,302$0 $400,698 23.6%16
Light & Power Fund Capital Projects2022YTDLTDOpen 9/30/2022 %and GrantsLTD9/30/2022 9/30/2022 Enc/ReqAvail Budget BudgetExpense Expense 9/30/2022 Balance Remain5010160000 Distribution Automation-Parent$150,000$0$0$0 $150,000 100.0%5010163601 2021 Drake-Dixon 624 Switchg$160,000$157,164 $157,164$0$2,836 1.8%Distribution Automation Summary$310,000$157,164 $157,164$0 $152,836 49.3%5010170000 System Relocations - Parent$223,376$0$0$0 $223,376 100.0%5010173573 2021 Tenny Alley Improvement$6,560$0$6,560$0$0 0.0%5010173603 2021 Lemay Ave Overpass$247,394$38,142 $247,394$0$0 0.0%System Relocations Summary$477,329$38,142 $253,953$0 $223,376 46.8%5010250000 Advanced Meter Infrastructure$0$0$0$0$05010253656 2022 AMI Equip & Tech Upgrade$842,700$0$0 $218,333 $624,367 74.1%Advanced Meter Infrastructure Summ$842,700$0$0 $218,333 $624,367 74.1%L & P Projects less grants$37,326,535 $2,002,834 $15,923,003 $5,081,182 $16,322,350 43.7%5019200010 2020 NACC Resilience Hub$425,000$19,203$35,737 $355,989 $33,275 7.8%5019200011 2022 CO Util Data Acceler Grnt$100,000$0$0 $98,500$1,500 1.5%5019200100 Payment Assistance Fund$473,941$164,948 $195,113$0 $278,828 58.8%5019xxxxx Grants & Donations Summary$998,941$184,151 $230,850 $454,489 $313,603 31.4%Total L&P Projects/Grants$38,325,476 $2,186,985 $16,153,852 $5,535,671 $16,635,953 43.4%KeySummary includes parent and childrenStand alone projectParent for Budget Only - No Direct Charges17
FINANCIAL MONTHLY REPORT WATER FUND AS OF SEPTEMBER 30, 2022 ISSUED OCTOBER 2022 18
WaterRevenuein thousandsPercent of Year 75.0%SeptemberYear to DateActualOver/ (Under)BudgetActualOver/ (Under) Inc/(Dec)% Bud Recvd % Act Recvd2022 2022 Bud 2022 2022 2022 Bud202120222021Residential Water Sales$ 2,063 * $ (28) $ 12,906 $ 13,582 $ 676(A)$ 114 81%77%Com/Indl Water Sales1,329 * 48 7,022 7,639616(B)358 81%78%Raw Water Surcharge409 * 38565589524(C)247 118%60%District Water Sales254 * (11) 1,378 1,684305(D)(332) 89%62%Other Water Sales181 * 56906521 (386)(E)(41) 56%72%PILOTs2190 1,293 1,3778459 81%77%Operating Revenue4,455 451 23,570 25,391 1,821405 82%75%Interest Revenue11468470613143159 103%108%Development Fees/PIFs/Contributions28 (99) 1,163691 (472)(F)(952) 44%13%Financing Sources000332 2%2%Other Misc8(6)13314612(148) 57%30%Total Lapsing Revenue**4,605 414 25,336 26,843 1,507(534) 80%67%Non-lapsing Revenue000TOTAL**$ 4,605$ 26,843$ (534)Variance Analysis:(A)(B)(C)(D)(E)(F)***Raw Water Surcharges are 811% over budget and 72% more than YTD 2021.Residential Water Sales are 5.2% over budget and 0.8% more than YTD 2021.Note: No Water rate increase for 2022.Commercial/Industrial Water sales are 8.8% over budget and 4.9% more than YTD 2021.September billed revenue is for August and early September.Excludes transfers and unrealized gain/loss on value.Plant Investment Fees ($373), Water Rights ($108), offset by Development Review Charges $10.District Water sales are 22.2% over budget and 16.5% less than YTD 2021.Irrigation Sales ($408) (water supply didn't yield as much due to fire impacts, so rented out less water, under budget ~$500 by YE) offset by Standpipe Sales $22.19
Water Fund2022 Department ExpenseIn thousands`Percent of Year 75.0%Excludes depreciation and transfersSeptemberYear to DateActual(Over)/ UnderYTD Bdgt Actual(Over)/ Under (Inc)/DecActual + PO'sSpent & Committed20222022 Bud20222022 2022 Bud 20212022by PO'sWater Treatment$ 450 $ 789$ 7,268 $ 4,713 $ 2,555(A)$ (862) $ 8,00183%Water Resources459422,8971,473 1,424(B)1,033 $ 1,66147%Water Quality Lab771581679224(60) $ 89476%Subtotal WR&T$ 573 $ 1,747$ 10,981 $ 6,978 $ 4,003 $ 112 $ 10,55674%Transmission & Distribution240362,2402,1439722 $ 2,17167%Water Meters O&M5775945049058 $ 53259%Engineering549912465447(C)(141) $ 68760%Subtotal WEFS351523,7463,112634(61) $ 3,39064%Water Conservation73451,004666339(81) $ 85860%PILOTs219(0)1,2931,377(84)(59) $ 1,37781%Admin Services - CS&A36403,2803,2800(94) $ 3,28075%Other Payments & Transfers331(176)1,5371,649 (111)(D)(502) $ 1,90666%Subtotal Operating Expenses$ 1,911 $ 1,667$ 21,842 $ 17,0620$ 4,780 $ (686) $ 21,36771%Debt Service000000$ 00%Minor Capital321491,311858453(E)(214) $ 1,62974%Total Lapsing$ 1,943$ 1,815$ 23,153$ 17,920$ 5,233$ (900)$ 22,99671%Non-lapsing Expenses4073,5401,521TOTAL$ 2,351$ 21,460$ 620Variance Analysis:(A)(B)(C)(D)(E)Water Assessment Services $876 (2 large invoices ($639 and $257) paid in Oct rather than Sept and $26 of budget for Rigden distributed in Feb, while invoicing happens after YE, will book in Dec), Consulting Services $237 (project delays due to vacancies (e.g. modeling effort), some underway; underspend by YE, and some will be carried forward via PO carryforward), Personnel $211 (vacancies), and Other Professional & Technical $39 (primarily for NISP outreach BFO offer #1.63 - on hold due to delay in Record of Decision for NISP).Legal Services ($118) (related to OASIS/Open International lawsuit, over budget by YE).Contract Payment to Gov't/Other $2,103 (PO carryforward for payments to Greeley: Cameron Peak Fire - Watershed; specifics and funding sources being worked out (to maximize cost matching and have the most impact); potentially some underspend by YE (year-end)), Consulting $69, Project Management Services $54 (estimated Fort Collins' portion of PM to manage post-fire recovery efforts - is used as needed; potentially some underspend by YE), Electricity $53 (weren't running all four treatment trains earlier this year, due to lower demand), Construction Services $67 ($20 underspend from PO carryforward related to the Poudre intake and channel realignment, likely under ~$20+ by YE), Personnel $62, Maintenance Contracts $41, Other Professional & Technical $25, Chemicals $18, Testing Services $13 (Big Thompson Watershed Forum dissolved and trying to reforming an entity to provide those services; potential underspend by YE), Lab Supplies $15, Paint Supplies $14, Water Assessment Services $12, Software Maint. $10, and Contractual Labor $10, offset by Electrical Parts ($23) (unexpected switchgear issue, YE spend TBD), and Natural Gas ($24) (likely due to colder than expected weather this past winter, potentially over budget by YE), Other Supplies ($17), and Tools & Related Supplies ($10).Consulting Services $279 (primarily Large Valve Maintenance work - all but $73 encumbered, likely to spend 1/2 of encumbrance this year and will carry forward 1/2 into next year; under budget by YE), Personnel $124 (vacancies and potentially more time being charged capital than budgeted in allocations out), and Other Professional & Technical $17 (used as needed, likely underspend by YE).Consulting $203, Construction Contracts $99, Other Capital Outlay $66, Other Equipment $60, Mechanical & Heavy Equipment $52, Security Equipment $43, Building Maintenance Services $23, Water Filter Material $20, and Motor Vehicles $14, offset by Construction Services ($72), Computer Hardware- Capital ($48) (budget distributed 1/12 for Water Meter Test Bench, flat by YE), Building Improvements ($31), Machinery & Equipment Parts ($17).20
Water Fund Capital Projects2022YTD LTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5020100000 Art in Public Places$1,246,819$793$462,024$12,842$771,953 61.9%5020100001 2017-Water Quality Lab Rehab$2,600,000$0$712,553$0$1,887,447 72.6%5020100003 2017-Undergrnd Elec Pow Supply$1,300,000$0$0$0$1,300,000 100.0%5020100007 2018-AB Cathodic Protection$2,280,000 $49,039 $2,191,173$39,769$49,059 2.2%5020100010 2019-Enviro Learn Center Dam$2,964,795 $206,882$844,942$155,355$1,964,497 66.3%5020100011 2019-New Pollution/Water Lab$500,000$4,700$202,308$56,639$241,053 48.2%5020100015 2022 – AMI Equip&Tech Upgrade$389,300$0$0$100,867$288,433 74.1%5020100016 2021-27-Inch Poudre Canyon Wtr$3,200,000 $183,081$334,283$451,431$2,414,286 75.4%5020100019 2021-North Mason Waterline$100,000$0$24,025$5$75,970 76.0%5020200000 CMMS–Maintenance Management$2,193,914 $65,316 $1,749,670$438,016$6,228 0.3%5020300000 CIS Upgrade/Repl - Wtr Parent$2,473,018 ($248,251) $2,003,929$416,897$52,192 2.1%5020300001 2021-Data Mgmt Prgm+Analy Plat$210,078$0$15,175$0$194,903 92.8%5020440023 2020-700 Wood St Front Entry$35,000 $29,732$29,732$3,069$2,199 6.3%5020440024 2022-USC Bckup Powr, Dual Feed$51,900$0$0$25,000$26,900 51.8%5020130000 Operational Technology$530,000$0$0$0$530,000 100.0%5020130001 2021-WTF SCADA Op Tech Replace$500,000 $56,692$295,807$20,225$183,968 36.8%Operational Technology Summary$1,030,000 $56,692$295,807$20,225$713,968 69.3%5020400900 PARENT-Cathodic Protection$6,337$0$0$0$6,337 100.0%Cathodic Protection Summary$6,337$0$0$0$6,337 100.0%5020440000 PARENT-Service Cntr Improvm't$10,250$0$0$0$10,250 100.0%5020440022 2019-Warehouse Fire Sprinkler$69,750$0$63,991$0$5,759 8.3%Service Center Improvements Summary$80,000$0$63,991$0$16,009 20.0%5020810000 PARENT-Water Supply Developm't$927,901$0$0$0$927,901 100.0%5020810002 NISP$200,000$0$128,492$0$71,508 35.8%Water Supply Development Summary$1,127,901$0$128,492$0$999,410 88.6%5020820000 PARENT-Watershed Protection$244,699$0$0$0$244,699 100.0%5020820004 2019-Fire Mitig Elkhorn Creek$54,500$0$54,500$0$0 0.0%5020820006 2020-Fire Mitig South Fork$17,250$0$0$17,250$0 0.0%5020820007 2020-Fire Mitig Cedar Park$20,000$0$20,000$0$0 0.0%5020820008 2022 - South Fork Restoration$16,438$0$0$16,438$0 0.0%Watershed Protection Summary$352,887$0$74,500$33,688$244,699 69.3%5020850302 Halligan Res Enlargement Proj$42,311,446 $1,028,304 $28,979,140 $3,300,003 $10,032,303 23.7%21
Water Fund Capital Projects2022YTD LTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5026311000 PARENT-Water Prod Replcmt Prgm$949,377$0$0$0$949,377 100.0%5026310069 2017-Lab Info Manag Sys Repla$134,650$0$133,291$1,359($0) 0.0%5026310081 2020-Foothills Tank Drain$432,785$27$286,453$2,487$143,845 33.2%5026310083 2021-WTF Filters 1&2 Rehab$700,000 $179,415$616,777$21,839$61,384 8.8%5026310085 2022-WTF Filters 5, 6, 8 Rehab$1,450,000 $175,227$175,227 $1,084,586$190,187 13.1%5026310300 Source of Supply - Budget Only$0$0$0$0$0Water Production Replcmnt Summary$3,666,812 $354,669 $1,211,749 $1,110,271$1,344,792 36.7%5026410000 PARENT-Distribut'n Sys Replcmt$218,348$0$0$0$218,348 100.0%Distribution Sys Replac Summary$218,348$0$0$0$218,348 100.0%5026411000 Distribution Sys Replac$255,000$0$0$0$255,000 100.0%5026411001 2021 - Mathews St WMR$450,000 $32,796$34,143$414,000$1,856 0.4%5026411002 2021 - Washington Ave WMR$380,000 $27,030$28,377$29,195$322,428 84.8%5026411003 2021 - Grant Ave WMR$335,000 $27,484$28,831$29,195$276,974 82.7%5026411004 2021 - Mack St WMR$450,000 $33,303$34,650$411,207$4,143 0.9%5026411005 2022-Area 1-Sherwood&Whitcomb$130,000$0$0$0$130,000 100.0%Distribution Sys Replac Pgm Summary$2,000,000 $120,614$126,002$883,597$990,401 49.5%5026422000 PARENT-Wtr Meter Replacement$1,052,897$0$0$0$1,052,897 100.0%5026422022 2022-Water Meter Repl & Rehab$850,000 $510,608$510,608$0$339,392 39.9%Meter Replacement & Rehab Summary$1,902,897 $510,608$510,608$0$1,392,290 73.2%5026440000 Galvanized Service Repl$0$0$0$0$05026440002 2022 - SWAP Implementation$1,209,034 $163,689$163,689$858,427$186,918 15.5%Galvanized Service Repl Summary$1,209,034 $163,689$163,689$858,427$186,918 15.5%5026450000 PARENT-Distro Small Projects$456,727$0$0$0$456,727 100.0%5026450039 2021-2400 Blk Brookwood WMR$300,000$6,963$211,536$0$88,464 29.5%5026450040 2021-800 Blk Tyler St WMR$195,000$1,121$191,447$0$3,553 1.8%5026450041 2021-300 to 600 Blk E Pitkin$550,000 $422,799$466,871$39,691$43,438 7.9%5026450042 2021-4300 Blk Michaud$25,460$673$25,460$0$0.00 0.0%5026450043 2021-2900 Blk Benthaven$100,000 $85,600$161,029$0($61,029) -61.0%5026450044 2021-Timberline@ Sweetwatr WMR$80,000 $66,526$72,082$0$7,918 9.9%5026450045 2022-900 to 1000 Blk Main St$260,000 $289,118$289,118$0($29,118) -11.2%5026450046 2022-1400 Blk Mulberrry WMR$110,000 $70,694$70,694$0$39,306 35.7%5026450047 2022-1200-1300 Blk Westward Dr$300,000$1,950$1,950$0$298,050 99.4%5026450048 2022 - 5100 Blk Sawgrass Ct$160,000$783$783$0$159,217 99.5%5026450049 2022-1300 Lakewood 1200 Delmar$260,000$650$650$0$259,350 99.8%Distro Small Projects Summary$2,797,188 $946,876 $1,491,621$39,691$1,265,876 45.3%22
Water Fund Capital Projects2022YTD LTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5026510000 PARENT-Water Qual Cap Replace$180,000$0$0$0$180,000 100.0%5026510001 2021 - Labware Washer – WQL$50,000 $38,771$38,771$0$11,229 22.5%Water Qual Cap Replace Summary$230,000 $38,771$38,771$0$191,229 83.1%Water Capital Projects less Grants$76,477,674 $3,511,516 $41,654,183 $7,945,793 $26,877,698 35.1%5029352000 CWCB Water Plan Grant$70,000$0$83,368$6,633($20,000) -28.6%5029352001 WaterSmart Grant - BOR FY19$70,000$2,100$56,756$12,878$367 0.5%5029352002 WaterSmart Grant - BOR FY21$0$0$0$0$0Total Water Capital Projects & Grants$76,617,674 $3,513,616 $41,794,307 $7,965,303 $26,858,065 35.1%KeySummary includes parent and childrenParent for Budget Only - No Direct ChargesProjects to be closed 12-31-22 are not included23
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022Shares - 6.0 113.2 1.5 13.5 132.0 6.0 57.0 330.6 73.8 - - - - City Certificates- - - 300.1 17.5 1.9 1.7 2.5 - - - 36.6 4.0 - Credit Accounts28.8 61.6 150.5 432.6 171.5 145.6 92.9 158.5 140.6 1.1 17.8 2.8 17.8 - Josh Ames13.1 - 17.2 14.1 116.0 77.6 428.1 51.7 117.6 - 72.6 94.1 72.6 38.1 Cash in-lieu43.7 68.2 65.2 66.6 149.0 339.0 400.3 482.1 1,159.6 19.1 172.8 9.2 172.8 4.2 Total RWR (AF)85.5 135.8 346.1 814.8 467.5 696.1 929.0 751.6 1,748.3 94.0 263.2 142.6 267.2 42.4 2022JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDECYTDShares0.00.00.00.00.00.00.00.00.00.0City Certificates0.00.00.00.00.00.00.00.00.00.0Credit Accounts0.00.00.00.00.00.00.00.00.00.0Josh Ames0.00.00.00.05.60.00.032.50.038.1Cash in-lieu1.90.10.40.90.30.50.10.00.04.2Total RWR (AF)1.9 0.1 0.4 0.9 5.9 0.5 0.1 32.6 0.0 0.0 0.0 0.0 42.4Cash in lieu -dollars$127,049$8,208$28,022$59,086$21,942$35,266$7,453$2,643$90$289,758Raw Water Requirements - 200.0 400.0 600.0 800.0 1,000.0 1,200.0 1,400.0 1,600.0 1,800.0 2,000.02009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022Cash in-lieuJosh AmesCreditAccountsCityCertificates24
FINANCIAL MONTHLY REPORT WASTEWATER FUND AS OF SEPTEMBER 30, 2022 ISSUED OCTOBER 2022 25
WastewaterRevenuein thousandsPercent of Year 75.0%SeptemberYear to DateActualOver/ (Under)BudgetActualOver/ (Under) Inc/(Dec)% Bud Recvd % Act Recvd2022 2022 Bud 2022 2022 2022 Bud202120222021Residential WW Sales$ 1,318 * $ 8 $ 11,820 $ 11,913 $ 93(A)$ (75) 76%74%Com/Indl WW Sales617 * (30) 4,658 4,478 (180)(B)358 72%80%District WW Sales34 * (1)318308(10)(0) 72%75%Other WW Sales35 * 1414722779(C)24 113%81%PILOTs118(2) 1,013 1,002(11)17 74%76%Operating Revenue2,122 (11) 17,957 17,928(30)323 75%76%Interest Revenue61362613276689 101%112%Development Fees/PIFs/Contributions3621289394105(D)(475) 53%26%Financing Sources44044(21)Other Misc447512247(E)30 98%81%Total Lapsing Revenue**2,22753 18,583 18,776193(54) 75%73%Non-lapsing Revenue000TOTAL**$ 2,227$ 18,776$ (54)Variance Analysis:Note: No Wastewater rate increase for 2022.(A)(B)(C)(D)(E)Lab Services $31, and Bad Debt Recovery $19, offset by Ranch Income ($9).***Residential sales are 0.8% over budget and 0.6% less than YTD 2021.Septage Treatment Charge $79.Commercial/Industrial sales are 3.9% under budget and 8.7% more than YTD 2021. due to decreased water consumption for some of the larger customers driven by weather variations and Excludes transfers and unrealized gain/loss on value.Plant Investment Fees $96.September billed revenue is for August and early September.26
Wastewater Fund2022 Department ExpenseIn thousandsPercent of Year 75.0%Excludes depreciation and transfersSeptemberYear to DateActual(Over)/ UnderYTD Bdgt Actual(Over)/ Under YTD (Inc)/DecActual + PO's% Bud Spent & Committed2022 2022 Bud20222022 2022 Bud 20212022by PO'sWater Reclamation & Biosolids $ 551 $ (64)$ 4,426 $ 4,235$ 191(A)$ (254) $ 4,40570%Pollution Control Lab94(1)86681947(B)(9)88871%Subtotal WR&T645(66)5,292 5,054238(263)5,29370%Trunk & Collection191(45)1,270 1,24624(C)(174)1,24670%Engineering4813760530230(D)(216)72574%Subtotal WEFS239(32)2,031 1,776255(390)1,97172%PILOTs11821,013 1,00211(17)1,00274%Admin Services - CS&A214(0)1,926 1,926(0)(28)1,92675%Other Payments & Transfers205 (101)1,074 1,172(99)(E)(249)1,22255%Subtotal Operating Expenses$ 1,420 $ (196)$ 11,336 $ 10,931$ 405 $ (947) $ 11,41469%Debt Service002592590$ 3325912%Minor Capital4222666750(84)(F)$ (260)1,16991%Total Lapsing$ 1,462 $ (174)$ 12,261 $ 11,940$ 321 $ (1,174) $ 12,84242%Non-lapsing Expenses8453,560(884)TOTAL$ 2,308$ 15,500$ (2,058)Variance Analysis:(A)(B)(C)(D)(E)(F)Consulting $102 (vacancy and waiting on purchasing strategy; likely underspend by YE), Machinery & Equipment Parts $67 and Electrical Parts $30 (vacancies and supply chain delays causing delays in some replacements, ~$15 in expenses coming, as well), Personnel $79 (vacancies), Conference & Travel $21 (vacancies and coverage as well as savings due to virtual rather than in person), Contractual Labor $17 (used as needed and haven't had staff to manage), Water $16, Land Maintenance Services $12 (shortage of contractors), Communication Supplies $12 (might be some requisitions coming - some spent out of minor cap), Dues & Subscriptions $10 (invoice timing, close to budget by year-end (YE)), offset by Electricity ($67) (higher rates, budget kept flat since 2019 despite annual rate increases, and don't have what we need to meet process needs and be energy efficient with blowers at MWRF; over budget by YE), Chemicals ($69) (use depends on treatment levels and processes; some things weren't budgeted adequately (e.g. carbon); will be over budget by YE), Natural Gas ($23) (budget reduced expecting savings due to digestor pumps, heat exchanger, and cogen - latter two are not online; cogen not complete due to parts and staff resources; over budget by YE), and Lab Supplies ($10).Personnel $32, and many small underspends offset by Maintenance Contracts ($14).Personnel $39 (vacancies), Solid Waste Services $40 (budget increased by $30 in 2022 due to anticipated tipping fee increases and sending less to landfill than expected by reusing and recycling on site), offset by Health and Safety Supplies ($23) (over budget ~$25+ by YE), Tools & Related Supplies ($18) (over budget ~$15+ by YE), and Other Supplies ($16) (over budget ~$15+ by YE).Legal Services ($101) (related to OASIS/Open International lawsuit, over budget by YE).Consulting $157 and Construction Services $19 (primarily DWRF Utility Mapping - $155 encumbered; will spend some this year and carry some forward), and Personnel $17 (vacancies, offset by a PM position that was repurposed to WRB Engineer working on replacement and minor capital projects, but HBU not moved thus allocation out applied at status quo, will persist into '23-'24), and Other Professional & Technical $16 (used as needed, likely underspend by YE).Trunk & Collection ($347) (budget for dump truck purchase from PO carryforward distributed in Dec, will correct then, except for ~$8 due to purchasing a larger excavator than usual for safety reasons, over $8 by YE), Water Reclamation & Biosolids $231 (Vehicles/Equipment $269, Building Improvements $41, offset by Other Capital Outlay ($47)). 27
Wastewater Fund Capital Projects2022YTDLTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5030100000 Art in Public Places1,015,315$ 12,125$ 365,002$ -$ 650,313$ 64.1%5030100001 2017-Dewatering Improvements4,270,000$ 4,174$ 4,076,204$ 11,900$ 181,896$ 4.3%5030100003 2017-Sludge Strain Press1,520,000$ -$ 1,414,330$ -$ 105,670$ 7.0%5030100006 2018-Digester Lid 6122,100,000$ 24,242$ 1,797,033$ 243,302$ 59,665$ 2.8%5030100007 2018-Sidestream Treatment5,400,000$ 152,165$ 5,025,452$ 17,473$ 357,074$ 6.6%5030100008 2018-City Park WWM Replace200,000$ -$ 197,803$ 1,760$ 437$ 0.2%5030100009 2019-SW Drake Levee51,500$ -$ 50,347$ 34$ 1,120$ 2.2%5030100011 2019-New Pollution/Water Lab500,000$ 4,700$ 203,693$ 56,639$ 239,668$ 47.9%5030100012 2019-DWRF Carbon Add Phase 12,200,000$ (32,429)$ 1,582,815$ 230,303$ 386,883$ 17.6%5030100013 2019-Polution Contr Lab Repair225,000$ 8,933$ 21,729$ -$ 203,271$ 90.3%5030100014 2019-Maple & Pearl WWMR587,000$ -$ 513,115$ 51,799$ 22,085$ 3.8%5030100015 2019-North College WW Improv917,000$ 25$ 692,822$ -$ 224,178$ 24.4%5030100016 2019-21" Stover SMR Spring Crk650,000$ -$ 516,061$ -$ 133,939$ 20.6%5030100017 2020-DWRF Headworks Project800,000$ 32,170$ 37,040$ 1$ 762,959$ 95.4%5030100019 2021-DWRF NPT Clarifier Replac6,200,000$ 349,142$ 579,948$ 2,089,069$ 3,530,983$ 57.0%5030100020 2021-MSR Vehicle Storage Facil300,000$ -$ 8,010$ 7,387$ 284,603$ 94.9%5030100021 2020-DWRF Dewatering HVAC Repl656,000$ 57,043$ 59,164$ 90,406$ 506,430$ 77.2%5030100022 2021-North Mason Sewer Main100,000$ 37,918$ 51,338$ 37,425$ 11,237$ 11.2%5030100023 2022 – MWRF UV Sys Replacement500,000$ 15,774$ 15,774$ 5,370$ 478,856$ 95.8%5030200000 CMMS–Maintenance Management1,628,165$ 29,263$ 1,244,422$ 354,722$ 29,021$ 1.8%5030300000 CIS Upgrd/Repl - Wstwtr Parent1,782,874$ (183,518)$ 1,445,002$ 300,566$ 37,306$ 2.1%5030300001 2021-Data Mgmt Prgm+Analy Plat151,452$ -$ 10,939$ -$ 140,513$ 92.8%5030440023 2020-700 Wood St Front Entry17,500$ 14,866$ 14,866$ 1,534$ 1,100$ 6.3%5030440024 2022-USC Bckup Powr, Dual Feed51,900$ -$ -$ 25,000$ 26,900$ 51.8%5030130000 Operational Technology92,500$ -$ -$ -$ 92,500$ 100.0%5030130001 2021-WRB SCADA HMI Client Repl7,500$ -$ 7,500$ -$ -$ 0.0%Operational Technology Summary100,000$ -$ 7,500$ -$ 92,500$ 92.5%5030350000 PARENT-DWRF Improvement CIP552,820$ -$ -$ -$ 552,820$ 100.0%5030350005 2015-Bio Gas to CoGen$4,705,000$3,401$4,458,927$130,905$115,1682.4%DWRF Improvements Summary5,257,820$ 3,401$ 4,458,927$ 130,905$ 667,988$ 12.7%5030361000 PARENT-Sludge Disp'l Improvm't71,905$ -$ -$ -$ 71,905$ 100.0%5030361001 MSR Land Purchase293,842$ -$ -$ -$ 293,842$ 100.0%Sludge Disposal Improvements365,746$ -$ -$ -$ 365,746$ 100.0%5030373600 PARENT-MWRF Improvements11,254$ -$ -$ -$ 11,254$ 100.0%MWRF Improvements Summary11,254$ -$ -$ -$ 11,254$ 100.0%5030373800 DWRF HVAC Improvements318,434$ -$ -$ -$ 318,434$ 100.0%5030373801 2022-DWRF Admin Bldg HVAC Repl81,566$ -$ -$ -$ 81,566$ 100.0%DWRF HVAC Improvements Summary400,000$ -$ -$ -$ 400,000$ 100.0%28
Wastewater Fund Capital Projects2022YTDLTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5030440000 PARENT-Serv Center Improvemnts5,125$ -$ -$ -$ 5,125$ 100.0%5030440022 2019-Warehouse Fire Sprinkler34,875$ -$ 31,995$ -$ 2,880$ 8.3%Service Center/UAB Imp Summary40,000$ -$ 31,995$ -$ 8,005$ 20.0%5030453000 Developer Repayments-$ -$ -$ -$ -$ 5030453001 2022-Northfield WW Dev Repay750,000$ 631,723$ 631,723$ -$ 118,277$ 15.8%Developer Repays Summary750,000$ 631,723$ 631,723$ -$ 118,277$ 15.8%5036311000 PARENT-Water Recl Replcmt Prgm2,788,570$ -$ -$ -$ 2,788,570$ 100.0%5036311018 2017-Lab Info Manag Sys Repla134,650$ -$ 133,291$ 1,359$ -$ 0.0%5036311021 2018-NPT Blower Building HVAC370,000$ 7,109$ 360,039$ -$ 9,961$ 2.7%5036311025 2019–DWRF PLCD12 Replacement60,000$ 11,574$ 23,196$ 35,914$ 890$ 1.5%5036311028 2019–DWRF HVT/SSB1213 Repl390,000$ -$ 384,350$ -$ 5,650$ 1.4%5036311029 2020-DWRF Digestor 611 Lid Rep490,000$ 15,581$ 473,567$ 31,195$ (14,762)$ -3.0%5036311031 2021 - WRB HVAC Replacement25,235$ -$ 25,235$ -$ -$ 0.0%5036311032 2022-NPT Mixed Liq. Retrn VFDs100,000$ -$ -$ 36,027$ 63,973$ 64.0%5036311033 2022-Heat Exchanger Redundancy150,000$ -$ -$ -$ 150,000$ 100.0%Water Reclam Replacement Summary4,508,455$ 34,265$ 1,399,677$ 104,495$ 3,004,283$ 66.6%5036410000 PARENT-Collec System Replcmt138,928$ -$ -$ -$ 138,928$ 100.0%5036410139 2021-700-800 Laporte AlleyWWMR510,000$ 27,333$ 28,680$ 26,949$ 454,371$ 89.1%Collection Sys Replace Summary648,928$ 27,333$ 28,680$ 26,949$ 593,299$ 91.4%5036411000 Collection Sys Replace Pgm1,420,000$ -$ -$ -$ 1,420,000$ 100.0%5036411001 2021-City Park Area Sewer Repl2,900,000$ 1,679,158$ 1,834,906$ 894,568$ 170,526$ 5.9%5036411002 2021-900-1000 LaporteAlleyWWMR350,000$ 24,640$ 25,987$ 305,870$ 18,143$ 5.2%5036411003 2022-Area 1-Meldrum & Loomis80,000$ -$ -$ -$ 80,000$ 100.0%Collection Sys Replace Pgm Summary4,750,000$ 1,703,798$ 1,860,893$ 1,200,438$ 1,688,669$ 35.6%5036450000 PARENT-Collect Small Projects964,071$ -$ -$ -$ 964,071$ 100.0%5036450025 2020-1200 Blk Hoffman Mill Rd220,000$ -$ 19,114$ -$ 200,886$ 91.3%5036450028 2020-Pearl St Sewer Repl150,000$ -$ 125,684$ -$ 24,316$ 16.2%5036450029 2020-Oakwood Dr Sewer Rep35,000$ -$ 29,638$ -$ 5,362$ 15.3%5036450030 2021-200 Blk N Whitcomb WWMR100,000$ -$ 37,505$ -$ 62,495$ 62.5%5036450034 2021-300 Blk Gordon Alley WWMR300,000$ 22,566$ 266,334$ -$ 33,666$ 11.2%5036450035 2022-1200 Blk Fairview WWMR220,000$ 196,267$ 196,267$ -$ 23,733$ 10.8%5036450036 2022-900 Blk Woodford160,000$ -$ -$ -$ 160,000$ 100.0%5036450037 2022-500 Blk Stover Alley330,000$ -$ -$ -$ 330,000$ 100.0%5036450038 2022-500 Blk Smith Alley340,000$ -$ -$ -$ 340,000$ 100.0%5036450039 2022-Lynnwood & Lake300,000$ 154,130$ 154,130$ -$ 145,870$ 48.6%5036450040 2022-1900 Blk Springfield200,000$ 85,741$ 85,741$ -$ 114,259$ 57.1%5036450041 2022-1300 to 1500 Blk Bryan250,000$ 451$ 451$ -$ 249,549$ 99.8%5036450042 2022-1500BlkBrentwood+Culdesac125,000$ -$ -$ -$ 125,000$ 100.0%Collect Small Projects Summary3,694,071$ 459,156$ 914,865$ -$ 2,779,206$ 75.2%29
Wastewater Fund Capital Projects2022YTDLTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5036490000 PARENT-Cured In Place Pipe762,211$ -$ -$ -$ 762,211$ 100.0%5036490004 2020-Spring Creek WW CIPP687,797$ -$ 642,736$ -$ 45,061$ 6.6%5036490005 2021 - Cured in Place Pipe560,000$ -$ 28,574$ -$ 531,426$ 94.9%Cured In Place Pipe Summary2,010,008$ -$ 671,310$ -$ 1,338,698$ 66.6%5036510000 PARENT-Polu Control Cap Repla179,455$ -$ -$ -$ 179,455$ 100.0%Polu Control Cap Repla Summary179,455$ -$ -$ -$ 179,455$ 100.0%.Total Wastewater Projects54,539,444$ 3,402,048$ 29,944,258$ 5,053,254$ 19,541,932$ 35.8%KeySummary includes parent and childrenStand alone projectParent for Budget Only - No Direct ChargesProjects to be closed 12-31-22 are not included.30
FINANCIAL MONTHLY REPORT STORMWATER FUND AS OF SEPTEMBER 30, 2022 ISSUED OCTOBER 2022 31
StormwaterRevenuein thousandsPercent of Year 75.0%SeptemberYear to DateActualOver/ (Under)BudgetActualOver/ (Under) Inc/(Dec)% Bud Recvd % Act Recvd2022 2022 Bud 2022 2022 2022 Bud202120222021Single Family Residential SW Services$ 681 * $ (2) $ 6,134 $ 6,121 $ (14)(A)$ 57 75%75%Non-single Family SW Services835 * (4) 7,559 7,494(65)(B)83 74%76%Operating Revenue1,516(5) 13,693 13,614(79)140 74%76%Interest Revenue43291452278277 124%119%Development Fees/PIFs/Contributions10468397548152(C)(543) 96%39%Financing Sources101001010(17)Other Misc3303434(D)7100%Total Lapsing Revenue**1,677 105 14,235 14,433198(336) 76%73%Non-lapsing Revenue000TOTAL**$ 1,677$ 14,433$ (336)Variance Analysis:Note: No Stormwater rate increase for 2022.(A)(B)(C)(D)***Stormwater Development Fee $69, Erosion Control Development Inspection $44, Development Review Charges $26, and Infrastructure Development Inspection $13.Non-Single Family fees are 0.9% under budget and 1.1% greater than 2021.Single Family Residential fees are 0.2% under budget and 0.9% greater than 2021.Excludes transfers and unrealized gain/loss on value.September billed revenue is for August and early September.Floodplain Permits $15, Bad Debt Recovery $6, Other Misc $6, and Insurance Recovery $4.32
Stormwater Fund2022 Department ExpenseIn thousandsPercent of Year 75.0%Excludes depreciation and transfersSeptemberYear to DateActual(Over)/ UnderBudget Actual(Over)/ Under (Inc)/Dec Actual + PO's% Bud Spent & Committed2022 2022 Bud 2022 2022 2022 Bud 2021 2022 by PO'sDrainage and Detention$ 254 $ (77) $ 1,549 $ 1,619 $ (70)(A)$ (195)$ 1,74180%Engineering9341 1,570 1,001569(B)(31)1,20258%Stormwater Quality Programs33186 499293206(18)42568%Admin Services - CS&A255(0) 2,293 2,293(0)(24)2,29375%Other Payments & Transfers167(99) 657736(79)(C)(185)78638%Subtotal Operating Expenses $ 802 $ 52 $ 6,567 $ 5,942$ 625 $ (454)$ 6,44664%Debt Service0011110412111%Minor Capital00 993770223(D)(656)1,20398%Total Lapsing$ 802 $ 52 $ 7,572 $ 6,723$ 848 $ (698)$ 7,66063%Non-lapsing Expenses3632,348980TOTAL$ 1,165$ 9,071$ 282Variance Analysis:(A)(B)(C)(D)Mowing Services $49 (not all invoices paid, yet, expecting to be flat by year-end (YE)), Personnel $33 (vacancies and turnover), Vehicle Repair $40 (reactionary - newer equipment holding up well), Consulting $17 (BFO Offer 1.65 Dirt Recycling & Management Study, working with Streets leadership transition on this, not sure of YE spend), Solid Waste Services $14 (sending less to the landfill, budget also increased by $50 in 2022 due to tipping fee increases), offset by Street & Bridge Maintenance ($54) (~$60 for CMO directive for Glenmoor pond work, remaining due to higher than expected concrete costs fro reactionary repairs, over budget ~$50 by YE), Land Maintenance Services ($46) (reactionary to necessary needs, over budget ~$50 by YE), Leased Equipment Rental Services ($41) (reactionary to necessary repairs, over budget ~$50 by YE), Health & Safety Supplies ($29) (were told to buy AED and OSHA 10 Hour within existing budgets, over budget ~$30+ by YE), and Sewer Pipe & Accessories ($26) (reactionary to necessary repairs, over budget ~$50 by YE).Consulting $278 (primarily BFO offer 4.16 Poudre River Flow Consolidation Study, expecting to complete and use most of the budget by YE (year-end)), Personnel $233 (primarily vacancies, under budget by YE), Other Professional & Technical $18 (used as needed, likely underspend by YE), and Conference & Travel $13 (due to vacancies, underspend by YE).Vehicles/Equipment (all but $24K of 2022 budget encumbered - awaiting delivery of 2 vehicles).Legal Services ($101) (related to OASIS/Open International lawsuit, over budget by YE).33
Stormwater Fund Capital Projects2022YTDLTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5040100000 Art in Public Places$523,142$3,000$186,415 $5,464$331,264 63%5040100003 2017-Remington St Storm Sewer$3,258,200$45,355$3,202,583 $8,999$46,6181%5040100004 2017-MagnoliaPreDsn-OakDsnCnst$2,920,000$476,081$1,912,025 $826,654$181,3216%5040100007 2018-Mail Crk; Palmer-Passway$2,808,900$24,260$1,545,162 $56,739$1,206,999 43%5040100008 2019-Timberline Levee @Nix Imp$123,300$0$105,767 $16,264$1,2691%5040100010 2019 - N Mason Area Drainage$3,267,800$36,503$564,997 $461,236$2,241,567 69%5040100011 2019-Flood Warning Sys Upgrade$200,000$8,283$157,980 $20,861$21,159 11%5040100013 2020-NECCO A4 Lateral - Lemay$950,000($430,785)$850,065$0$99,935 11%5040100016 2021-Boxelder Watershed Dams$200,000$0$0$0$200,000 100%5040100018 2021-Glenmoor Pond Enhancemnts$250,000$155,583$168,340 $67,696$13,9646%5040300000 CIS Upgrd/Repl - Stmwtr Parent$1,610,338($161,904)$1,305,055 $271,440$33,8432%5040300001 2021-Data Mgmt Prgm+Analy Plat$136,795$0$9,884$0$126,911 93%5040440012 Oxbow Levee Improvements$1,507,955$130$1,057,390 $331,366$119,1998%5040440017 2016-Spr Creek/College Realign$370,000$0$9,271$0$360,729 97%5040440034 Spring Creek Rehab @ Edora$1,801,000$16,496$1,661,811 $36,523$102,6666%5040440041 2017-Castlerock SW Remediation$1,892,000$240,541$650,938 $732,255$508,808 27%5040440042 2017-Drake Levee @ DWRF Imp$71,500$0$65,655$34$5,8118%5040452306 Boxelder Authority$3,090,000$0$2,999,583$0$90,4173%5040452724 2022-USC Bckup Powr, Dual Feed$51,900$0$0 $25,000$26,900 52%5040452725 2020-700 Wood St Front Entry$17,500$14,866$14,866 $1,534$1,1006%5040453300 CMMS–Maintenance Management$1,204,879$17,392$1,086,387 $70,568$47,9244%5040440000 Stormwater Basin Improvements$207,847$0$0$0$207,847 100%5040440002 2013 Stream Best Mgmt Practice$72,359$0$69,159$0$3,2004%5040440021 2016-Maximo CMMS Project$90,000$0$90,000$0$00%5040440040 2017-Avocet Drake LLC #2 Repl$25,000$0$24,958$0$420%5040440044 2018-CLP Bank@Riverbend Ponds$140,000$0$112,546 $14,439$13,0149%5040440045 2017 - 400 to 500 Blk Pitkin$595,000$369,085$551,340 $50,723($7,063) -1%5040440047 2018-Maple St SW Improv$101,809$0$101,809$0$00%5040440058 2019-CLP Bank at Homestead NA$195,000$0$190,144 $2,848$2,0081%5040440059 2019 - Magnolia & Shields$350,000$4,087$313,236$0$36,764 11%5040440060 2019 - Brewer & Sitka$415,000$5,335$387,262 $20,229$7,5092%5040440064 2019-200 Blk Parker St SWMR$280,000$2,665$279,286$266$4480%5040440065 2019-2400 Blk S Lemay Outfall$450,000$648$448,853$0$1,1470%5040440066 2019-Spring Creek @ Robertson$117,000$0$111,041 $4,538$1,4211%5040440070 2020-Laporte Bore Arthur Ditch$60,000$0$56,308$0$3,6926%5040440071 2020-400 and 500 Blk Laporte$70,000$0$60,543$0$9,457 14%34
Stormwater Fund Capital Projects2022YTDLTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5040440075 2020-100 to 300 Blk Pitkin$520,000$356,822$370,094 $41,715$108,191 21%5040440076 2020-1000 Blk Main St SW$270,000$177,983$287,804 $12,822($30,626) -11%5040440077 2020-200 to 300 Blk Laporte$25,000$0$23,000$0$2,0008%5040440079 2021-Garfield at Green SW Impr$76,406$0$76,406$0$00%5040440080 2021 - Windsor Ct SW Impr$180,000$5,110$29,919 $9,047$141,034 78%5040440081 2021 - Oak and Peterson$64,023$20,369$64,023$0$00%5040440082 2021 - Stuart and Stover$480,000$156,786$170,933 $116,234$192,833 40%5040440083 2022-Boxelder Culvert @Kechter$45,000$42,319$42,319$0$2,6816%5040440084 2022-SMP Inlets & Headwalls$100,000$60,182$60,182$0$39,818 40%SW Basin Improvement Summary $4,929,444 $1,201,390$3,921,164 $272,862$735,418 15%5040451600 Spring Creek Basin Improvement$445$0$0$0$445 100%5040451648 Spring Ck Rehab @ Riverside$119,105$0$116,667$0$2,4382%Spring Creek Basin Summary$119,550$0$116,667$0$2,8832%5040452710 Utility Service Center Phase 2$5,125$0$0$0$5,125 100%5040452723 2019-Warehouse Fire Sprinkler$34,875$0$31,995$0$2,8808%Utility Service Cente/UAB Summary$40,000$0$31,995$0$8,005 20%5040452800 Master Planning$451,560$0$0$0$451,560 100%5040452818 2015 West Vine MP Update$556,040$23,542$540,088 $13,458$2,4940%5040452828 2019-Foothills Basin MP Update$181,100$30,865$181,148$24($72)0%5040452829 2020-Canal Imprtn Selected Pln$180,965$40,423$180,961($0)$40%5040452831 2021-Dry Crk Selected Pln Updt$92,600$47,774$91,606$514$4801%5040452832 2021-Spring Creek MP Hydrology$75,940$23,382$75,402$538$00%Master Planning Summary$1,538,205$165,986$1,069,205 $14,533$454,467 30%5040452900 Flood Mapping/Stream Gaging$550,918$0$515,346$0$35,5726%Flood Mapping/Stream Gaging Summary$550,918$0$515,346$0$35,5726%5040453000 Developer Repays$748,526$0$0$0$748,526 100%5040453016 2022-Boxelder Creek@Gateway DR$43,891$43,891$43,891$0$00%Developer Repays Summary$792,416$43,891$43,891$0$748,526 94%5040453400 SW Land Acquisition$375,000$0$0$0$375,000 100%Land Acquisition Summary$375,000$0$0$0$375,000 100%5040453500 Stream Rehabilitation Program$0$0$0$0$05040453501 2021-Mail Creek@Two Creeks NA$3,100,000$136,926$310,796 $124,674$2,664,530 86%Stream Rehab Program Summary$3,100,000$136,926$310,796 $124,674$2,664,530 86%35
Stormwater Fund Capital Projects2022YTDLTDOpen9/30/2022%LTD9/30/20229/30/2022Enc/ReqAvailBudget BudgetExpenseExpense9/30/2022BalanceRemain5040453600 Poudre Levee Program$818,700$0$0$0$818,700 100%5040453601 2021-CLP Fldpln@Prospect Ponds$400,000$7,067$331,036$0$68,965 17%5040453602 2021-Drake Levee Recertificat$600,000$41,605$179,056 $348,345$72,599 12%5040453603 2022-Drake Levee Culvert$661,000$2,023$2,023 $175,967$483,010 73%Poudre Levee Program Summary$2,479,700$50,694$512,114 $524,312$1,443,274 58%5046491000 Cured in Place Pipe$0$0$0$0$05046491001 2021-Cured In Place Pipe$450,000$303,131$383,704 $56,362$9,9342%5046491002 2022-Cured In Place Pipe$450,000$0$0 $32,530$417,470 93%Cured In Place Pipe Summary$900,000$303,131$383,704 $88,892$427,404 47%Total Stormwater Projects$41,080,443 $2,347,818$24,459,054 $3,957,906$12,663,483 31%KeySummary includes parent and childrenParent for Budget Only - No Direct ChargesProjects to be closed 12-31-22 are not included.36
FINANCIAL MONTHLY REPORT CUSTOMER SERVICE AND ADMINISTRATION FUND AS OF SEPTEMBER 30, 2022 ISSUED OCTOBER 2022 37
Customer Service and Admin FundRevenuein thousandsPercent of Year 75.0%SeptemberYear to DateActualOver/ (Under)BudgetActualOver/ (Under) Inc/(Dec)% Bud Recvd % Act Recvd2022 2022 Bud 2022 2022 2022 Bud202120222021Admin Charges L&P *624 $ 0 $ 5,612 $ 5,612$ 0$ 77 75%82%Admin Charges Water *364(0) 3,280 3,280(0)94 75%83%Admin Charges WW *2140 1,926 1,926028 75%81%Admin Charges SW *2550 2,293 2,293024 75%81%Admin Charges BB *19(1)178170(7)(A)(27) 75%68%Operating Revenue1,476(1) 13,288 13,281(7)195 75%82%Interest Revenue53112197 140%135%Other Misc & Contributions13848929 1,190262(B)546 100%115%Total Lapsing Revenue**1,61850 14,228 14,492264749 77%84%Non-lapsing Revenue000TOTAL**$ 1,618$ 14,492$ 749Variance Analysis:(A)(B)***Budget distributed as three-year average, while actuals are 1/12; will be flat by year-end.Red Tag Charges (a.k.a. late fees) $196, Reconnect Charges $51, Non-Sufficient Funds Charges $48, PDP Subdivision & Zoning $24, Meter Reading-Manual $16, offset by Utility Locate Fees ($60) (2022 budget distributed evenly throughout the year, will be billed January 2023 and accrued to 2022), and Transfer Service Charges ($18).Excludes transfers and unrealized gain/loss on value.Customer Service & Admin Fund Charges are paid by the Enterprise Funds. The CS&A revenue is an expense in the Enterprise Funds. It does not represent additional revenues from the Utilities customers.38
Utilities Customer Service & Administrative (CS&A) Fund2022 Department ExpenseIn thousandsPercent of Year 75.0%Excludes depreciation and transfersSeptemberYear to DateActual(Over)/ UnderYTD BdgtActual(Over)/ Under (Inc)/Dec Actual + PO's% Bud Spent & Committed2022 2022 Bud202220222022 Bud 20212022by PO'sCustomer Connections Dept Customer Service$ 271$ 942,583$ 2,52064$ (15)$ 2,84375% Communications & Marketing68 1075367083(81)$ 68966% Customer Accounts409477310167(A)105$ 34550% Community Engagement109(10)909791118(79)$ 79161% Workforce Culture/Env Projects(0)0312(1)$ 134%Subtotal Customer Connections$ 487 $ 104$ 4,726$ 4,292$ 434 $ (70)$ 4,66969%L&P Managed Operations Meter Reading0 0 0 (0)0101$ (0) #DIV/0! Locating Operations159(64)1,0611,0441716$ 1,10878% Grounds Maintenance27(2)244247(3)(49)$ 24772%Subtotal L&P Managed Operations $ 186 $ (66)$ 1,305$ 1,291$ 14$ 69$ 1,35577%Safety, Security & Wellness9(0)786710(7)$ 6756%Executive Director's Office117151,1501,003147(B)(76)$ 1,49386%Finance & Asset Mgmnt120241,3191,169150(C)(14)$ 1,16963%IT226803,2482,336912(D)168$ 2,51460%Environmental Regulatory Affairs66568656212454$ 57359%Support Services65685682333(215)$ 84265%Graffiti Abatement (Streets)000000$ 0Admin Services - General Fund14(0)129129(0)(2)$ 12975%Minor Capital12028441243(E)77$ 16842%Total Lapsing$ 1,291 $ 189$ 13,781$ 11,714 $ 2,068 $ (15) $ 12,97967%Non-lapsing Expenses000TOTAL$ 1,291$ 11,714$ (15)Variance Analysis:(A)(B)(C)(D)(E)Personnel $128, Consulting $32, Marketing Services $16, and City & Community Programs $12, offset by Other Professional & Technical ($31).Personnel $391 (vacancies, under budget by YE), Software Maintenance & Support Services $240 (awaiting to pay $47 (Utilities portion) of DirSec invoice for Checkpoint Firewall; some invoices passed to Utilities through server team at inconsistent times ($54 for Redhat/Linux, $21 for Zerto); bought $31 less Maximo licenses than planned - haven't needed as many, yet; $8 in underspend on AMI headend system - costs increased less than budget assumption; 2022 budget was developed using the same budget assumptions as 2021, resulting in an estimated $80 in inadvertant overbudgeting - reduced budget in 2023-24; under budget ~$120 by YE), Computer Hardware - Capital $165 (BFO offer 3.10 Migration off of Exadata - paying quarterly, budget distributed in Jan.; unsure if remaining will be used, potentially ~$140 underspend by YE), Computer Software $81 (mostly encumbered for Mythics Oracle Database Appliance $61, should be paid in Q4), Conference & Travel $26 (some virtual rather than in person and some not being held; ~$13 expenditures coming in Q4, under budget ~$15-20 by YE), Consulting $18, Computer Hardware $12, offset by Other Professional & Technical ($40) (outsourcing Sr Oracle DBA - overspend to be offset in Personnel and some in Consulting; will be ~$90 over budget by YE).Vehicles/Equipment (IT $142, Locates $63, Support Services $26, and Grounds Maintenance $12).Personnel $81 (vacancy), Consulting Services $32, and Financial Consulting Services $15.Consulting $191, Software Maintenance & Support $211, Other Contingency $75, and Legal Services $17 (related to OASIS and ancillary costs), offset by Motor Vehicles & Accessories ($45), Personnel ($286) (Interim Executive Director's time charged here and Water Director's time being charged here), and Meals - Business, Non Travel ($12).39
FINANCIAL MONTHLY REPORT SUPPLEMENTAL DATA AS OF SEPTEMBER 30, 2022 ISSUED OCTOBER 2022 40
Utilities Overtime Report - September 2022ActualBudgetBudgetActualActualYTD (Over)% ChangeALL UTILITIESYTD 9-30-20212021YTD 9-30-2022Sep-22YTD 9-30-2022Under Budget YTDAll Utilities Overtime526,224$ 573,800$ 414,078$ 78,013$ 591,655$ (177,577)$ 12%All Utilities Regular Salary - Class., Hrly, Cont.21,462,979$ 33,161,317$ 24,743,161$ 2,387,572$ 22,073,575$ 2,669,586$ 3%% Overtime to Regular Salaries2.45%1.73%1.67%3.27%2.68%-6.65%9%- - - - - ActualBudgetBudgetActualActualYTD (Over)% ChangeLIGHT & POWERYTD 9-30-20212021YTD 9-30-2022Sep-22YTD 9-30-2022Under Budget YTDLight & Power Overtime279,468$ 269,000$ 175,893$ 37,490$ 339,346$ (163,453)$ 21%L&P Regular Salary - Class., Hrly, Cont.6,155,306$ 10,201,086$ 7,406,521$ 727,332$ 6,560,783$ 845,738$ 7%% Overtime to Regular Salaries4.54%2.64%2.37%5.15%5.17%-19.33%14%L&P By Business UnitAdmin & General Operations-$ 500$ 199$ -$ 957$ (758)$ Electric Field Services O&M136,715$ 200,000$ 117,236$ 26,963$ 199,876$ (82,640)$ 46%Material Control - Standards593$ 500$ 406$ -$ 357$ 49$ -40%Electric Meter O&M10,422$ 1,000$ 2,768$ 1,174$ 9,982$ (7,214)$ -4%Elec. Substations O&M4,971$ 7,000$ 12,580$ -$ 13,321$ (741)$ 168%Smart Grid & System Operation68,865$ 60,000$ 42,704$ 5,217$ 55,099$ (12,395)$ -20%Subtotal L&P Operations221,566$ 269,000$ 175,893$ 33,354$ 279,591$ (103,698)$ 26%System Additions & Replacements32,104$ -$ -$ 3,935$ 45,769$ (45,769)$ 43%Capital Projects25,798$ -$ -$ 201$ 13,986$ (13,986)$ -46%Total L&P OT279,468$ 269,000$ 175,893$ 37,490$ 339,346$ (163,453)$ 21%- - - - - - - ActualBudgetBudgetActualActualYTD (Over)% ChangeWATERYTD 9-30-20212021YTD 9-30-2022Sep-22YTD 9-30-2022Under Budget YTDWater Overtime104,352$ 142,500$ 91,482$ 18,692$ 124,832$ (33,350)$ 20%Wtr Regular Salary - Class., Hrly, Cont.4,891,162$ 7,142,949$ 5,442,587$ 457,427$ 4,803,595$ 638,992$ -2%% Overtime to Regular Salaries2.13%1.99%1.68%4.09%2.60%-5.22%22%Water By Business UnitWater Conservation Programs136$ -$ -$ -$ 589$ (589)$ 331%WT Facility Administration-$ 500$ 378$ -$ -$ 378$ Water Treatment/SOS29,641$ 43,000$ 26,383$ 4,626$ 36,221$ (9,838)$ 22%Transmis & Distrib Maintenance61,780$ 95,000$ 61,455$ 12,683$ 74,065$ (12,610)$ 20%Metering-Operations & Maint542$ 4,000$ 3,266$ 137$ 457$ 2,809$ -16%Water Engineering6,856$ -$ -$ 889$ 6,238$ (6,238)$ -9%Water Quality-Operations74$ -$ -$ -$ -$ -$ -100%Capital Projects5,322$ -$ -$ 356$ 7,262$ (7,262)$ 36%Total Water OT104,352$ 142,500$ 91,482$ 18,692$ 124,832$ (33,350)$ 20%- - - - - - 41
ActualBudgetBudgetActualActualYTD (Over)% ChangeWASTEWATERYTD 9-30-20212021YTD 9-30-2022Sep-22YTD 9-30-2022Under Budget YTDWastewater Overtime32,006$ 104,800$ 54,724$ 8,658$ 60,068$ (5,344)$ 88%WW Regular Salary - Class., Hrly, Cont.3,241,134$ 4,783,275$ 3,589,363$ 382,516$ 3,381,003$ 208,360$ 4%% Overtime to Regular Salaries0.99%2.19%1.52%2.26%1.78%-2.56%80%Wastewater By Business UnitWater Reclamation12,963$ 79,800$ 34,815$ 1,577$ 17,173$ 17,642$ 32%Trunk/Collection 12,281$ 25,000$ 19,909$ 5,723$ 33,225$ (13,316)$ 171%Wastewater Engineering3,651$ -$ -$ 420$ 3,648$ (3,648)$ 0%Capital Projects3,112$ -$ -$ 938$ 6,022$ (6,022)$ 93%Total Wastewater OT32,006$ 104,800$ 54,724$ 8,658$ 60,068$ (5,344)$ 88%- - - - - - - ActualBudgetBudgetActualActualYTD (Over)% ChangeSTORMWATERYTD 9-30-20212021YTD 9-30-2022Sep-22YTD 9-30-2022Under Budget YTDStormwater Overtime44,861$ 30,000$ 48,124$ 8,196$ 31,594$ 16,530$ -30%SW Regular Salary - Class., Hrly, Cont.1,748,097$ 2,631,650$ 2,026,554$ 210,042$ 1,737,160$ 289,394$ -1%% Overtime to Regular Salaries2.57%1.14%2.37%3.90%1.82%5.71%-29%Stormwater By Business UnitHousehold Hazardous Waste-$ -$ 25,000$ 4,186$ 4,186$ 20,814$ Drainage & Detention18,418$ 30,000$ 23,124$ 2,521$ 10,194$ 12,930$ -45%Stormwater Engineering2,308$ -$ -$ -$ 1,562$ (1,562)$ -32%SW Env Reg Affairs-$ -$ -$ -$ 1,443$ (1,443)$ Capital Projects24,134$ -$ -$ 1,489$ 14,208$ (14,208)$ -41%Total Stormwater OT44,861$ 30,000$ 48,124$ 8,196$ 31,594$ 16,530$ -30%- - - - - - - ActualBudgetBudgetActualActualYTD (Over)% ChangeCS&AYTD 9-30-20212021YTD 9-30-2022Sep-22YTD 9-30-2022Under Budget YTDCS&A Overtime65,537$ 27,500$ 43,855$ 4,979$ 35,817$ 8,038$ -45%CS&A Regular Salary - Class., Hrly, Cont.5,427,280$ 8,402,357$ 6,278,136$ 610,254$ 5,591,033$ 687,103$ 3%% Overtime to Regular Salaries1.21%0.33%0.70%0.82%0.64%1.17%-47%CS&A By Business UnitCustomer Service24,163$ 2,000$ 14,408$ 521$ 5,499$ 8,909$ -77%Communications & Marketing516$ -$ 1,815$ 36$ 185$ 1,630$ -64%Customer Connections-$ -$ -$ -$ 238$ (238)$ Community Engagement239$ -$ 2,000$ 1,011$ 1,686$ 314$ 605%Executive Director's Office448$ 2,000$ 1,492$ -$ 3,368$ (1,876)$ 651%Strategic Financial Planning48$ 500$ 428$ -$ -$ 428$ -100%Locating Operations39,144$ 18,000$ 20,370$ 3,412$ 24,589$ (4,219)$ -37%Envirnmntal Regulatory Affairs-$ -$ -$ -$ 42$ (42)$ Grounds Maintenance979$ 5,000$ 3,342$ -$ 210$ 3,132$ -79%Total CS&A OT65,537$ 27,500$ 43,855$ 4,979$ 35,817$ 8,038$ -45%42
$- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecUtilities Overtime2020202120222022 Budget $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecLight & Power Overtime2020202120222022 Budget $- $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecWater Overtime2020202120222022 Budget $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecWastewater Overtime2020202120222022 Budget $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecStormwater Overtime2020202120222022 Budget $- $20,000 $40,000 $60,000 $80,000 $100,000 $120,000Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecCS&A Overtime2020202120222022 Budget43
Utilities
electric · stormwater · wastewater · water
700 Wood Street
PO Box 580
Fort Collins, CO 80522
970.212.2900
V/TDD: 711
utilities@fcgov.com
fcgov.com/utilities
M E M O R A N D U M
DATE: October 12, 2022
TO: Water Commission
FROM: Michael Neale, MSc, Water Resources Engineer
RE: September 2022 Water Resources Division Staff Report
Purpose
This memorandum is intended to update the Water Commission on water resource conditions for
the City of Fort Collins Water Utility (Water Utility) over the month of September and provide
updated outlook information. For additional information, please refer to the City’s website:
https://www.fcgov.com/utilities/water-status
Water Resources Summary
Supply and Demand Projections for the remainder of WY2022
• Water Supply – During the month of September, water supply consisted of 54% from
Horsetooth Reservoir, and 46% from the Poudre River, including 10% of total supply
diverted via the Pleasant Valley Pipeline.
• Water Demand – Demands within the Water Utility service area for the month of September
were slightly below projected. Please refer to the attached graphs and tables.
• Water demand for September was 96% of the projected demand.
• Water demand for calendar year is 97% of the projected demand.
Weather: https://climate.colostate.edu/
Measured at the Fort Collins weather station 053005 along with average normals from 1991-2020:
• Mean daily high temperature recorded for the month: 82.3 oF.
• 30-year average daily high temperature for the month is: 77 oF.
• Total recorded monthly precipitation: 1.22 inches.
• 30-year average precipitation for the month: 1.43 inches.
Reservoir Storage: As of October 1st, and presented in the Northern District Storage and Delivery
Report:
• Colorado-Big Thompson project reservoirs (Granby, Carter, and Horsetooth): 81% full.
• Horsetooth Reservoir: 60% full.
• Joe Wright Reservoir: 75% full (115% of average for the month based on 14 years of data).
Cache la Poudre River flow: Graphical data for the Poudre River is available on-line at:
• Cache La Poudre River at the Canyon Mouth
https://dwr.state.co.us/Tools/Stations/CLAFTCCO?params=DISCHRG
• Cache La Poudre River at Fort Collins
https://dwr.state.co.us/Tools/Stations/CLAFORCO?params=DISCHRG
Drought Monitors:
• Larimer County and Colorado https://climate.colostate.edu/drought_info.html
Most of Larimer County is under no drought conditions. Eastern end of the County and most
of the state is experiencing abnormally dry conditions.
• Colorado and the USA https://droughtmonitor.unl.edu/
The Colorado River basin remains in a drought.
Climate Outlook: https://www.cpc.ncep.noaa.gov/
National Oceanic and Atmospheric Administration (NOAA) climate outlooks for the northern Front
Range and northern mountains, over the next three months:
• Equal chances of above or below normal precipitation
• Likely above normal temperature.
Other Water Supply Considerations:
• Water Resources Division is attentive of Colorado River drought management policy and
maintains communication with Northern Water on potential impacts to our supplies from the
Colorado-Big Thompson project in 2023 and beyond.
City of Fort Collins Utilities
Treated Water Monthly Summary
2022
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year to
Date
WTF Water Supply (MG)
From Poudre 161.6 0.0 190.8 293.2 122.3 288.4 431.0 335.7 466.1 2,289.2
From Horsetooth 289.9 433.3 306.1 297.1 696.5 785.3 756.4 856.4 549.4 4,970.4
Total Raw Water 451.5 433.3 496.8 590.3 818.8 1,073.8 1,187.3 1,192.1 1,015.6 7,259.5
Demands (MG)
WTF Production 436.0 415.4 468.3 557.2 780.5 1,025.9 1,134.5 1,143.8 974.0 6,935.5
Change in Storage -1.6 -1.0 4.0 4.7 -0.2 0.5 0.7 0.8 -2.2 5.5
Demand on WTF 437.6 416.4 464.4 552.5 780.7 1,025.4 1,133.8 1,143.0 976.3 6,930.0
From Soldier Canyon 21.8 7.1 14.4 48.7 174.5 307.9 348.5 321.7 263.9 1,508.5
To Soldier Canyon 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
To FC-Lov/NWCWD -39.6 -33.2 -48.4 -96.0 -235.9 -407.7 -469.8 -456.3 -379.4 -2,166.2
For City 419.8 390.3 430.4 505.3 719.3 925.6 1,012.4 1,008.4 860.8 6,272.3
Daily Deliveries to City (MG)
Max During Month 14.8 15.7 14.8 24.3 29.7 35.7 37.4 35.9 35.3 37.4
Min During Month 12.1 13.4 12.7 13.9 18.2 21.9 25.8 27.7 21.5 12.1
Avg During Month 13.5 13.9 13.9 16.8 23.2 30.9 32.7 32.5 28.7 22.9
Monthly Deliveries (Ac-Ft)
Projected 1,369 1,247 1,392 1,551 1,961 2,959 3,329 3,251 2,760 1,685 1,338 1,339 24,181
Actual 1,288 1,198 1,321 1,551 2,208 2,841 3,107 3,095 2,642 19,249
Ratio 94%96%95%100%113%96%93%95%96%80%
Year to Date Deliveries (Ac-Ft)
Projected 1,369 2,616 4,008 5,559 7,520 10,479 13,808 17,058 19,819 21,503 22,842 24,181 24,181
Actual 1,288 2,486 3,807 5,358 7,565 10,406 13,513 16,607 19,249 19,249
Ratio 94%95%95%96%101%99%98%97%97%80%
C-BT Project Storage
Lake Granby Storage in Lake Granby decreased 13,507 acre-feet last month
Horsetooth Reservoir Storage in Horsetooth Reservoir decreased 9,987 acre-feet last month
Carter Lake Storage in Carter Lake decreased 14,349 acre-feet last month
October 1, 2022
481,123
74,787
94,459
154,729
Total Storage
Granby Carter Horsetooth Empty
0
100,000
200,000
300,000
400,000
500,000
600,000
700,000
800,000
Acre‐FeetOctober 1 Total Storage
481,123
55,010
Acre‐Feet
8240
8250
8260
8270
8280
8290
Nov‐17Feb‐18May‐18Aug‐18Nov‐18Feb‐19May‐19Aug‐19Nov‐19Feb‐20May‐20Aug‐20Nov‐20Feb‐21May‐21Aug‐21Nov‐21Feb‐22May‐22Aug‐22Elevation (ft)94,459
62,276
Acre‐Feet
5360
5380
5400
5420
5440
Nov‐17Feb‐18May‐18Aug‐18Nov‐18Feb‐19May‐19Aug‐19Nov‐19Feb‐20May‐20Aug‐20Nov‐20Feb‐21May‐21Aug‐21Nov‐21Feb‐22May‐22Aug‐22Elevation (ft)74,787
37,443
Acre‐Feet
5660
5680
5700
5720
5740
5760
5780
Nov‐17Feb‐18May‐18Aug‐18Nov‐18Feb‐19May‐19Aug‐19Nov‐19Feb‐20May‐20Aug‐20Nov‐20Feb‐21May‐21Aug‐21Nov‐21Feb‐22May‐22Aug‐22Elevation (ft)
C-BT Project Allocated Water
C-BT Active Storage
C-BT Delivery Obligations
Notes:
October 1, 2022
1) Quota set at 80%
2) Carryover - Entites certified 54,014 Acre-Feet of Carryover for WY2022.
for Carryover so that adequate supplies are set aside to fulfill all potential obligations.
3) Regional Pool - Additional water acrued to the Regional Pool on April 30, 2022. There is 19,547 Acre-Feet in the
Regional Pool for WY 2022.
137%, Project Reserves
40%, Certified Quota
0%, Collateral
1%, Carryover
2%, Replacement and
Contracts
5%, Windy Gap 53%,
Empty
Project Reserves
Regional Pool
Certified Quota
Collateral
Carryover
Replacement and Contracts
Windy Gap
Empty
% number represents equivalent quota
0 50,000 100,000 150,000 200,000 250,000 300,000
Acre-Feet
Quota
Delivered Remaining
0 10,000 20,000 30,000 40,000 50,000 60,000
Acre-Feet
Carryover
Delivered Remaining Max Potential
0 1,000 2,000 3,000 4,000
Acre-Feet
Replacement
Delivered Remaining
0 5,000 10,000 15,000 20,000
Acre-Feet
Regional Pool
Delivered Remaining Unallocated
C-BT Project Deliveries
October 1, 2022
Deliveries by Area Deliveries by Use
0
50,000
100,000
150,000
200,000
250,000
300,000
2016 2017 2018 2019 2020 2021 2022Acre-FeetAdams Tunnel
Total YTD
0 50,000 100,000 150,000 200,000 250,000
2016
2017
2018
2019
2020
2021
2022
Acre-Feet
C-BT Project Deliveries
Includes Quota, Carryover, Regional Pool and Noncharge
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
40%
41%
19%
September
Carter
Horsetooth
Other 45%
45%
10%
Water Year
Carter
Horsetooth
Other
0
50,000
100,000
150,000
200,000
250,000
2016 2017 2018 2019 2020 2021 2022Acre-FeetHorsetooth Carter Other
62%
38%
September
Agriculture
M&I 41%59%
Water Year
Agriculture
M&I
0
50,000
100,000
150,000
200,000
250,000
2016 2017 2018 2019 2020 2021 2022Acre-FeetAgriculture M&I
Utilities
electric · stormwater · wastewater · water
700 Wood Street
PO Box 580
Fort Collins, CO 80522
970.221.6700
970.221.6619 – fax
970.224.6003 – TDD
utilities@fcgov.com
fcgov.com/utilities
M E M O R A N D U M
DATE: September 29, 2022
TO: Mayor Arndt and Councilmembers
FROM: Jared Heath, Senior Watershed Specialist
THROUGH: Kelly DiMartino, City Manager
Kendall Minor, Utilities Executive Director
RE: 2022 Summer Water Quality Update – Upper Cache la Poudre Watershed
Bottom Line:
The Upper Cache la Poudre (CLP) Watershed Collaborative Water Quality Monitoring Program
is a partnership between the cities of Fort Collins, Greeley, Thornton, and Soldier Canyon
Drinking Water Authority. The goal of this shared monitoring effort is to assist the participants
in meeting current and future drinking water treatment goals by reporting current water quality
conditions and trends within the Upper CLP watershed. The attached water quality update
provides a summary of temperature, snowpack, streamflow, and water quality conditions
monitored in the Upper CLP watershed during the 2022 spring season.
Background:
The seasonal water quality updates are designed to inform the Upper CLP Watershed
Collaborative Monitoring Program partners, their customers, and other community stakeholders
about the condition of our source watershed and the quality of the raw CLP River drinking water
supply. This seasonal reporting effort began in 2015 to provide a succinct and timely summary
of current-year conditions in the Upper CLP Watershed. Seasonal updates are published for the
spring, summer, and fall seasons. In depth water quality reporting is done through annual and
five-year technical reports. Water quality reports and seasonal updates are made publicly
available on the Fort Collins Utilities website, fcgov.com /source-water-monitoring.
Summer 2022 Highlights:
Summer water quality monitoring captures water quality conditions during peak snowmelt runoff
and the receding streamflow that follows through the summer monsoon season. Water quality
conditions vary with changes in elevation, hydrologic and weather conditions, and other potential
watershed impacts. The Upper CLP watershed experienced above average air temperatures and
near average precipitation over the summer 2022 season. Air temperature was 2.6 degrees
Fahrenheit warmer than average and ranked as the ninth warmest summer on record.
Precipitation measured near average over the summer season and drought conditions improved
across much of the Upper CLP watershed. Streamflow in the Poudre River near the canyon
DocuSign Envelope ID: C00B4783-6870-497F-B165-A7AE2B496343
mouth measured below average over the duration of the summer season; however, peak
streamflow measured well above average. Water quality indicators measured at key long-term
monitoring sites along the CLP River were within the range of values observed over the baseline
period of record (2008 – 2012) suggesting normal water quality conditions over the summer
season. In several instances, precipitation events over the Cameron Peak burn scar severely
impacted water quality and required the water treatment plant to shut down their Poudre River
raw water intake for an extended period. Real-time water quality meters installed upstream of
the City’s Poudre River raw water intake detected these events and provided staff with early
warning to effectively respond and minimize impacts to the City’s drinking water quality.
CC: Jason Graham, Director of Water Utilities
Jill Oropeza, Water Quality Services Director, Utilities
Richard Thorp, Watershed Program Manager, Utilities
Water Commission
DocuSign Envelope ID: C00B4783-6870-497F-B165-A7AE2B496343
Upper Cache la Poudre Watershed Collaborative Monitoring Program
SUMMER 2022 WATER QUALITY UPDATE
Source Water Monitoring
The Upper Cache la Poudre (CLP) Watershed Collaborative Water Quality Monitoring
Program was established in 2008 between the City of Fort Collins, the City of Greeley, and
Soldier Canyon Water Authority, to help meet present and future drinking water treatment
goals. The City of Thornton was added as a full partner in 2022.
Water quality monitoring of our raw, CLP River drinking water supply is conducted from
April through November. Monitoring sites are strategically located throughout the Upper CLP
watershed. Water quality data provide valuable information about the health of our source
watershed and quality of our raw water supply.
The Summer 2022 Water Quality Update provides a seasonal summary of watershed
conditions in the Upper CLP watershed by highlighting weather, drought, streamflow, and
water quality conditions over the summer season (June – August).
Water quality begins to stabilize following peak snowmelt runoff and routine monitoring
is reduced to monthly sampling. Routine water quality monitoring results are reported
for six key monitoring sites located throughout the Upper Cache la Poudre watershed,
which capture water quality conditions above and below major tributaries and near raw
water supply intake structures (Figure 1). Present water quality conditions are compared to
baseline water quality data, collected over the period of 2008 to 2012.
Figure 1 – Upper Cache la Poudre
Watershed Collaborative Monitoring
Program water quality sampling
sites and real-time water quality
instrument locations.
JWC - Joe Wright Creek above the
confluence with the Poudre River
PJW - Poudre River above the
confluence with Joe Wright Creek
PBR - Poudre River below Rustic
PSF - Poudre River below the
confluence with the Little South Fork
PNF - Poudre River above the
confluence with the North Fork at
the City of Fort Collins’ Intake
PBD - Poudre River below the
confluence with the North Fork at
the Bellvue Diversion
DocuSign Envelope ID: C00B4783-6870-497F-B165-A7AE2B496343
2
Temperature
Air temperature measured at the Joe Wright Snowpack Telemetry (SNOTEL) station over the 2022 summer season was 2.0°F warmer than
the long-term average and ranked as the ninth warmest summer on record (out of 33 years). Monthly mean air temperature was above
average in all summer months and the month of July ranked as the second warmest July on record (Table 1).
Temperature
2022
(ºF)
Average
(ºF)
Departure
(ºF)2022 Rank
June 49.0 47.1 +1.9 12th (H)
July 55.0 52.5 +2.5 2nd (H)
August 52.0 50.5 +1.5 8th (H)
Summer 52.0 50.0 +2.0 9th (H)
Precipitation
Precipitation measured at the Joe Wright SNOTEL over the 2022 summer season was near average and ranked as the 19th driest summer
on record (out of 44 years). Precipitation was below average in June, near average in July, and slightly above average in August (Table 2).
Drought conditions continued to improve throughout much of Upper CLP watershed due to near average precipitation measured in July
and August. The intensity of drought conditions improved from abnormally and moderately dry conditions to mostly non-existent drought
conditions (Figure 2).
Total Precipitation
2022
(inches)
Average
(inches)
% of
Average 2022 Rank
June 1.7 2.2 76%20th (D)
July 2.1 2.1 99%21st (D)
August 2.4 2.2 108%18th (W)
Summer 6.2 6.6 94%19th (D)
Table 1 – Monthly mean air temperatures measured at Joe
Wright SNOTEL over the summer months of 2022 compared to
the long-term average (1991 – 2020).
Note: H = hottest and C = coldest
Table 2 – Monthly accumulated precipitation totals measured
at the Joe Wright SNOTEL over the 2022 summer season
compared to the long-term average (1991 – 2020).
Note: W = wettest and D = driest
Figure 2 – Drought conditions for the state of Colorado as monitored by the United States Drought Monitor on May 31, 2022 (left) and Aug. 30, 2022
(right). Map source: droughtmonitor.unl.edu
DocuSign Envelope ID: C00B4783-6870-497F-B165-A7AE2B496343
3
Streamflow Conditions
Streamflow at the Cache la Poudre River near the Canyon Mouth stream gage measured 139,319 acre-feet of water over the summer
season, which was 82% of the long-term average (calculated over the 1881 – 2021 measurement period). Peak streamflow was observed
June 12 and measured 2,630 cubic-feet per second – 132% of average. The timing of the 2022 peak was one day later than the long-
term average peak streamflow date. Streamflow quickly receded following peak streamflow and by the end of the summer season was
approaching baseflow (low flow) conditions. The total amount of water measured below average in all summer months, most notably in
June and July (Figure 3).
Figure 3 –
Streamflow
conditions on the
Poudre River over
the 2022 spring
season (left) and
monthly total
water volume
measured over
the summer
season (right).Water Quality Indicators
The Upper CLP Collaborative Water Quality Monitoring Program uses several key water quality indicators, including pH, conductivity,
temperature, and turbidity, which act as surrogates for other parameters (Table 3). These indicators provide a snapshot of water quality
conditions and are useful for identifying trends or changes in water quality. Significant changes in these water quality indicators may
provide an early warning of potential water pollution.
Water Quality Indicator Explanation
Temperature
Water temperature influences other water quality parameters and is a
major driver of biological activity and algal growth in rivers, including
certain phytoplankton species that produce the taste and odor
compounds, geosmin and 2-methlyisoborneol.
pH
pH is an important water quality parameter to monitor, because
it influences the solubility and biological availability of chemical
constituents, including nutrients and heavy metals. pH near 7 is
considered neutral, with more acidic conditions occurring below 7 and
more basic, or alkaline, conditions occurring above 7.
Specific Conductivity
Conductivity is an index of dissolved ionic solids in water. Conductivity
is used as a general measure of water quality. Significant increases in
conductivity can be used as an indicator of increased pollution.
Turbidity
Turbidity is monitored to track changes in water clarity. Clarity
is influenced by the presence of algae and/or suspended solids
introduced to surface waters through various land use activities,
including runoff and erosion, urban stormwater runoff and drainage
from agricultural lands. For water treatment, turbidity is an important
indicator of the amount of suspended material that is available
to harbor pollutants, such as heavy metals, bacteria, pathogens,
nutrients and organic matter.
Table 3 – Water quality
indicators measured as
part of the Upper Cache
la Poudre Collaborative
Water Quality Monitoring
Program.
DocuSign Envelope ID: C00B4783-6870-497F-B165-A7AE2B496343
4
Summer monitoring captures water quality conditions during the Poudre River’s highest flow levels (peak streamflow) and when flow levels
gradually decrease in the months following peak streamflow. Water quality conditions generally stabilize during this time of year. Water
quality indicators that were once diluted by high streamflow begin to concentrate as streamflow recedes. In general, water temperature
and specific conductivity increase, while turbidity and pH levels decrease. The summer season also marks the beginning of the summer
monsoon, which can lead to increased frequency and intensity of rain events. An active monsoon season, in combination with a post-fire
landscape, can lead to flash flooding, debris flows, and severe impacts to water quality.
Joe Wright Creek Canyon Mouth
Nearly all water quality indicators at key sites along the CLP River
were within the baseline range of values over the 2022 summer
season (Figure 4). Water temperature was normal in Joe Wright Creek
(JWC) and in the CLP River above Joe Wright Creek (PJW) – normal is
defined as the median value over the baseline period of record. Water
temperature was warmer than normal at all other key monitoring sites
and increased from Joe Wright Creek (JWC) downstream to the City of
Greeley’s diversion (PBD). pH levels were more alkaline than normal and
consistent across monitoring locations. pH in the CLP at the City of Fort
Collins’ diversion (PNF) was slightly higher than any value observed over
the baseline. Specific conductivity values were higher than normal at all
key sites, except in Joe Wright Creek (JWC) where values were normal.
Specific conductivity levels were consistent across monitoring locations;
however, higher values were measured near the City of Greeley’s
diversion (PBD). The higher values at this monitoring location are likely
associated with contributions from the North Fork CLP River (NFG),
which joins the Mainstem CLP River between the cities of Fort Collins’
and Greeley’s diversions (PNF and PBD, respectively). Turbidity levels
were near normal from Joe Wright Creek (JWC) downstream to the CLP
River below Rustic (PBR) and slightly higher than normal from the CLP
River below the South Fork (PSF) downstream to the City of Greeley’s
diversion (PBD).Sydney Phillips-Grace, a Water Quality Technician with the City of
Greeley, gathering data with a water quality meter from the North
Fork below Seaman Reservoir (NFG).
Figure 4– Water quality
indicator data collected
at key monitoring
sites over the 2022
summer monitoring
season (June, July, and
August) compared to
baseline (2008 - 2012)
summer water quality
conditions.
Summer
2022
Median
Maximum
Median
Minimum
Graphic Explanation
Baseline data
range based
on long-term
data record
2008-2012
DocuSign Envelope ID: C00B4783-6870-497F-B165-A7AE2B496343
5
Post-Cameron Peak Wildfire Water Quality Impacts
Water quality monitoring instruments were installed at two locations upstream of the Poudre supply intake facility in early April. The
Poudre at Indian Meadows site is located one mile downstream of the Town of Rustic and the Manners Bridge site is located approximately
one mile upstream of the City’s raw water intake (Figure 1). The Water Quality Alert System provides water treatment operations near real-
time water quality data to quickly respond to changes in Poudre River water quality that result from runoff from the Cameron Peak burn
area or other upstream events.
High-intensity precipitation events driven by the summer monsoon continued to cause several post-fire erosion, sedimentation, and
flooding events on the Poudre River over the summer season. The Manners Bridge Water Quality Alert System measured several storm
events. Many of these events impacted water quality and required water treatment plants to shut down their raw water intakes on the
Poudre River for an extended period.
The response in post-storm event turbidity was variable depending on the location, magnitude, and extent of rainfall across the Cameron
Peak burn scar. The figure below (Figure 5) displays daily average turbidity (calculated from 15-minute readings) in the Poudre River
with maximum turbidity levels ranging from less than 100 nephelometric turbidity units (NTU) to 400 NTU (Figure 5). Some storm events
resulted in instantaneous turbidity levels near 1,000 NTU. In comparison, pre-storm turbidity levels during the summer season were around
5 NTU. The duration of high turbidity events was short-lived in 2022. On average, water quality impacts lasted for less than 24 hours
following many of the storm events.
FCGOV.COM/WATER-QUALITY
Learn More
Figure 5 – Turbidity measured in the Poudre River at the Manners Bridge real-time water quality instrument during the month of May.
DocuSign Envelope ID: C00B4783-6870-497F-B165-A7AE2B496343
Utilities Income-Qualified
Assistance Program
10-20-2022
Pilot Wrap-Up/Discussion About Program Adoption
Heather Young, Sr. Community Engagement Manager
Shannon Ash, Utilities Affordability Program Manager
2The Utilities Affordability Programs Team
3Why We’re Here Today
•Seeking Council approval to make the Income-Qualified Assistance Program (IQAP) an
adopted program (Yes and adopt ordinance or no)
•Follow up on existing program structure
August:
Internal Utilities Communication
September/October:
Boards and Commissions Communication
October 20:
Council Finance Committee
November 1:
Council presentation
2022 Timeline
4Strategic Alignment
•Neighborhood Livability and Social Health (NLSH) 1.3:
•Improve accessibility of City and community programs to low-and moderate-income
residents and increase participation in services to eligible income-qualified residents.
•Our Climate Future
•Big Move 7 –Healthy Affordable Housing: Everyone has healthy stable housing they
can afford
•Big Move 12 –100% Renewable Energy: Everyone in the community receives
affordable and reliable 100% renewable electricity, including from local sources
Background
6IQAP History
2013-2018:
Low-income program discussions; request from Council to explore further
2018:
IQAP launches as a pilot program
2021:
Pilot set to expire, Council approves pilot extension until 12/31/22
2022:
Decide on IQAP program
7
Payment Assistance Efficient Home Efficient Practices Lower Utility Costs
How We Help Income-Qualified Customers Reduce Utility Costs
Utilities Affordability Programs
8Payment Assistance
Medical
Assistance
Program
(Discounted
Rate)
Income-Qualified Assistance Program
~23% rate reduction
Customers are approved through the Low-income Energy Assistance Program
(LEAP)
Customers are automatically enrolled/renewed in IQAP based on LEAP
approval
Customers must be at 60% State Median Income or belowPayment
Assistance
9Median Income Explained
Number in Household Income Limit
1 $33,109
2 $43,297
3 $53,484
4 $63,672
5 $73,860
6 $84,047
Number in Household Income Limit
1 $45,120
2 $51,540
3 $57,960
4 $64,380
5 $69,540
6 $74,700
Colorado State Median Income (60%) -2022 Area Median Income -Larimer County (60%) -2022
According to the 2020 Census, 16%of Fort Collins residents live in poverty.
https://www.census.gov/quickfacts/fortcollinscitycolorado
10Income-Qualified Assistance Program Impact
•Assumes a 10% increase in program participation for 2023 and a 15% increase in 2024.
•Estimated total reach is 10,000 households using a city-wide poverty rate of ~16%, based on 2021 Census Bureau data combined with
controlling for the student population in Fort Collins (City Rebates Eval Report, 2019).
•There are currently nearly 70,000 households in our electric service area.
755 759
1727
1900
2185
0
500
1000
1500
2000
2500
2020 Participation 2021 Participation 2022 Participation 2023 Estimate 2024 Estimate
Number of Participants for IQAP
Outreach
•Engagement
•Monthly Utilities Insights newsletter
•Customer surveys
•Direct customer engagement at events and
through targeted outreach
•Participation in efficiency programs
•Outreach
•Increased outreach for the 2022-2023 LEAP
season. Events planned at the following:
-La Familia
-CSU (staff and off-campus students)
-Northside Aztlan Community Center
-Senior Center
-CARE Housing
11
Program Update
13Auto-enroll
•In 2021, we removed the IQAP application. Now, customers enroll in LEAP and staff enrolls them
in IQAP.
•Enrollment has increased 128%
•One less application for customers to fill out
•87% of auto-enroll customers are satisfied or very satisfied in the ease of auto-enrollment
•Less staff time to process
759
1727
0
200
400
600
800
1000
1200
1400
1600
1800
2000
2021 2022
Average IQAP Participation
14IQAP Impact
Energy Use Analysis
•Energy use from auto enroll IQAP participants initially increased by 2.9% on average (220 kWh/year)
•This increase likely reflects that households are no longer as concerned about paying their energy bills
choosing to keep their homes at a more comfortable temperature
•By year 3 of enrollment, both IQAP and non-IQAP participants had similar energy use
(20)
(10)
-
10
20
30
40
50
60
Dec-16 Apr-17 Aug-17 Dec-17 Apr-18 Aug-18 Dec-18 Apr-19 Aug-19 Dec-19 Mar-20 Jul-20 Nov-20 Mar-21 Jul-21 Nov-21 Mar-22 Jul-22 Nov-22
IQAP Participant Monthly kWh DifferenceCOVIDIQAP starts
15IQAP Impact
"The IQAP program is an integral and essential part of our lives. Being on a fixed income is difficult and this
program makes it easier to continue to live in this beautiful city we have called home for many decades. We
use the money we save each month to buy essentials such as food, insurance, fuel, clothing, shoes. We do
not waste it or spend it frivolously. Thank you for offering the IQAP."
Customer Survey
Every year, participants in IQAP are offered an opportunity to complete a program survey. Participants are asked
questions such as, “What has been the biggest benefit of receiving the IQAP utility bill discount?” And “Is there
anything you would like to change about the Income-Qualified Assistance Program?”
Benefit responses included:
•increased quality of life
•being able to save money for other expenses
•decreased stress with paying bills
•being educated on ways to conserve energy
•budgeting on a fixed income
When asked about changes they would like to see to the program, a larger discount was listed
repeatedly.
16Rate Reduction
•In 2021, Council requested that we evaluate whether a 23% rate reduction is still sufficient
•Methodology: Aim for low-income customers to spend a similar percentage on
utilities as someone who makes 100% of area median income
•Takes LEAP benefit and gas bills into consideration
•Recommendation: Increase rate reduction to 25% moving forward, evaluate every 3-5 years
Why? Since 2018, Utility bills have increased
more than income has increased.
17Annual Financial Impact
*Based on 1727 enrolled participants. Prior projections estimated that 2,000 customers would be
enrolled during the pilot phase. Total cost is nominal (0.3% of $138M), would minimally impact other
Utilities customers.
23% rate reduction
(current)
25% rate reduction
(proposed)
Average annual discount/customer $220.50 $240
Average annual Utility cost*$392,000 $415,000
With a 25% rate reduction, customers would save an average of $20/month on their Utilities bill.
Group Outcome
Energy Board –June 25, Sept. 8 Supportive of this program
Affordable Housing Board –Oct. 6 Supportive of this program
Senior Advisory Board –Oct.12
Council Finance Committee –Oct. 20
Water Commission –Oct. 20
18Boards, Commissions and Committee Feedback
Question for Discussion
20Why Utilities Rate Reductions Are Needed
•Income disparity and energy inequity exists in our community, largely driven by race, ethnicity
and low-quality housing
•“High energy burdens and energy insecurity are well-documented and pervasive national
issues. Even in 2017, a time of economic prosperity, well over one-quarter of all U.S.
households experienced a high energy burden.” (1)
•Utility costs continue to increase at a faster rate than income, locally and nationally
•Some customers are on a fixed income, especially seniors
•Inflation means people have less to spend on basic needs like utilities
•Without access to heating, cooling, and water unpaid utility bills can have dire health
impacts
•“It’s higher prices. It’s heat waves and increasing needs for energy.” (2)
•Additional factors
•Energy costs increase as we work towards carbon neutrality
•Climate change = hotter temps = more energy use
1) https://www.aceee.org/energy-burden
2) https://www.bloomberg.com/news/articles/2022-08-23/can-t-pay-utility-bills-20-million-us-homes-behind-on-payments-facing-shutoffs
21Why Utilities Rate Reductions Are Needed
•Supporting low-income customers and providing energy equity aligns with the policies of Fort
Collins Utilities and the City of Fort Collins
•As a municipal utility provider, we aim to offer equitable service to all customers, yet a
significant portion of our customers are not receiving equitable service
•Utilities serve a unique role where we provide foundational services to community
members and, by offering these services at a reduced rate, we can ease some of the
burden of this disparity
22Summary
•Adopting the Income-Qualified Assistance Program:
•Aligns with existing priorities
•Invests in our community -the total financial cost is small compared to the customer
and community impact.
•Would have minimal impact to future rate increases, given current and projected
participation numbers and a 25% rate reduction
•Is a responsible use of rate payer dollars because IQAP builds on existing benefits
through LEAP, leveraging this partnership to help share the cost
•Future updates on the impact of this program would be included in rates and fees updates
23Question for Senior Advisory Board
•Is the Water Commission supportive of the Income-Qualified Assistance Program becoming
an adopted Utility program?
THANK YOU!
25Utilities Affordability Programs
One-Time Payment Assistance
•Payment Assistance Fund
•Utilities Pandemic Assistance
•Neighbor to Neighbor Funding
Reduced Rates
•Income-Qualified Assistance Program
•Medical Assistance Program
•Digital Equity Rate
Retrofit Programs
•Larimer County Conservation Corps Water and Energy Program
•Colorado Affordable Residential Energy
Outreach
•Utilities Insights Newsletter
•Direct customer engagement
•Outreach to agencies
26Payment Assistance Fund
•Can receive funding once per season (Oct. 1 –Sept. 30)
•Bills must be past due
•80% of Area Median Income
•Energy Outreach Colorado matches funds 1:1
•Contact partner agencies to receive funding:
•Neighbor to Neighbor –970-484-7498
•Catholic Charities –970-484-5010
•La Familia/The Family Center –970-221-1615
•Discover Goodwill –1-888-775-5327
•CSU (students and staff only) –970-491-8051
Payment
Assistance
Fund
(One-Time
Assistance)
One-Time Payment
Assistance
•Payment Assistance
Fund
Funding source Where to apply Customers
served
Number of
customers
served
(2020/2021)
Amount
distributed
(2020/2021)
Average
per
customer
Utilities
funds
remaining
Utilities Pandemic
Assistance Fort Collins Utilities Residential and
commercial 647 $296,386 $458 $466,712
Consolidated
Appropriations Act
Neighbor to Neighbor Residential,
income-qualified,
renters
898 $261,734 $291 ?
Payment
Assistance Fund –
Energy Outreach
Colorado
La Familia
Neighbor to Neighbor
Catholic Charities
Discover Goodwill
CSU
Residential,
income-qualified 1,443 $562,380 $390 $333,961
CARES Act Fort Collins Utilities Residential and
commercial 1,423 $575,910 $405 $0
Total 3,528 $1.4 million $405.71 $1.1
million
27Financial Assistance During Covid
28Reduced Rate Programs
Medical
Assistance
Program
(Discounted
Rate)
Income-Qualified
Assistance
Program
Medical
Assistance
Program
Digital Equity Rate
Launched in 2018 with
Time -of-Day electric rates
Launched in 2012 Launched with Connexion
~23% rate reduction ~23% rate reduction $19.95/month rate
Qualifications:
•Approved through the
Low-income Energy
Assistance Program
(LEAP)
•Automatically
enrolled/renewed in
IQAP based on LEAP
approval
•60% State Median
Income
Qualifications:
•Medically necessary
electric equipment or
air conditioning
•Physician certification
•60% Area Median
Income
Qualifications:
•60% Area Median
Income
Reduced Rates
•Income-Qualified
Assistance Program
•Medical Assistance
Program
•Digital Equity Rate
29Equipment Repair/Replacement and Efficiency Programs
LCCC Water
and Energy
Program
(Basic Retrofits)
Retrofit Programs
Larimer County
Conservation Corps Water
and Energy Program
Colorado Affordable
Residential Energy
Basic inspection of home,
appliances, windows, toilets and
heating/cooling system
Comprehensive upgrades
available for air sealing,
insulation, HVAC, windows and
appliances
Install efficiency measures Assessment and efficiency
measures installed
Partnership with Larimer County,
Loveland utilities
Partnership with Energy Outreach
Colorado, Xcel Energy, Platte
River Power Authority
Annual program targets:
•350 assessments
•175,000 kWh
•1.9M gal water
Annual program targets:
•40 upgrades
•15,000 kWh
30Get FoCo App
31Charter Requirement and IQAP Purpose
Charter Article XII, Sec. 6:
All net operating revenues of the city’s utilities shall be held within the
respective utility’s fund and may be expended only for renewals,
replacements, extraordinary repairs, extensions, improvements,
enlargements and betterments to such utility, or other specific utility
purpose determine by the Council to be beneficial to the ratepayers
of said utility.
32Arrears Analysis
Process Step Cost
Send disconnect notice (Printing and mailing)$0.60
Actual disconnect $6.06
Collect payment $5.15
Reconnect service once payment is made $6.06
Send customers to collections $6.06
Total cost $23.93
•When a customer is not disconnected the Utility saves ~$24/avoided disconnect in printing, mailing,
and staff costs
33LIHWAP
Low-Income Household Water Assistance Program (LIHWAP) provides funds to assist low-
income households with water and wastewater bills.
•The City of Fort Collins is not able to participate in this program due to our current
billing system.
•Funds are required to only be applied to the water portion of the customer’s bill and
our current system does not allow payments to be separated per service.
•A new billing system is in the RFP process and will hopefully include the ability to
apply payments to specific utility services.
Colorado’s LIHWAP, which began in November 2021, is a temporary, emergency program
managed and operated at a state level by the Colorado Department of Public Health, where the
state is responsible for processing benefit payments to water service providers. Colorado’s
LIHWAP provides a one-time benefit payment for a maximum benefit amount of $2,000. To
determine the benefit level, Colorado will consider the amount past due to continue service or the
total amount to be paid to the water service vendor to re-establish water service by bringing the
household debt balance to zero.
•Enrollment in IQAP provides a year-round discounted rate on water and wastewater.
34LEAP and EBT Cards
The Low-income Energy Assistance Program (LEAP) program works to keep communities warm
during the winter (November through April) by providing assistance for heating costs, equipment
repair and/or replacement of inoperable heating tools. While the program is not intended to pay
the entire cost of home heating, it aims to help alleviate some of the burdens that come with
Colorado's colder months.
•The City of Fort Collins billing system does not allow for payments to be applied to
specific portions of a customer’s bill.
•Customers receive an EBT card in the mail for the benefit amount, withdraw the
money from the card, and apply it to their bill.
•Customer Care and Technology is requesting to implement a system that would allow
EBT cards to be processed as a form of payment.
35IQAP Customers
36Mobile Home Park Support
For most mobile home parks in Fort Collins, the property manager/owner is the utilities customer
for water utilities such as stormwater, wastewater, and drinking water, and the resident is the
customer for electric utilities. In this case, a park will receive a bill from the utility company for the
water services, which they may choose to then re-bill to residents or include these utilities as a
part of the monthly rent. Residents that are electric customers will receive their own separate
electricity bill from their provider.
If residents are charged individually for water, the following rules apply: Each month, property
managers must provide water billing information for the entire mobile home park’s monthly water
bill, amount owed to the utility provider, and amount paid by park management. Property
managers must also provide the formula used to calculate the amount each mobile home
resident owes for water. No additional administrative fees for water utility billing are allowed.
If water is included in the rent as an amenity, there are currently no rules regarding transparency
of water billing.
We are exploring a rebate program to assist residents with the water portion of their bill.
37Utilities Pandemic Assistance
Residential Commercial
839 customers 21 customers
$324,658.21 total funding spent $35,471.90 total funding spent
$386.96 -average per customer $1,689.14 -average per customer
Fort Collins Utilities received $469,000 from Platte River Power Authority and $381,550 from the American
Rescue Plan Act (ARPA) to directly support our customers in need as a result of the pandemic.
As of September 1, 2022, the following has been allocated:
A new program is being developed to reach property managers that will be able to apply for these funds to
cover inactive accounts that have been unpaid.
38Utilities Finance Structure
•Utilities sets rates and fees for each Utility to cover the cost of service (electric, water,
wastewater)
•Funding is set aside for operating and maintenance expenses.
•Instead of a rate cost, IQAP falls under operating and maintenance expenses.
Utilities
electric · stormwater · wastewater · water
222 Laporte Ave.
PO Box 580
Fort Collins, CO 80522-0580
970.212.2900
V/TDD: 711
utilities@fcgov.com
fcgov.com/utilities
DATE: October 20, 2022
TO: Fort Collins Water Commission
FROM: Katie Collins, Utilities Water Conservation Specialist
RE: Allotment Management Program Extension
Bottom Line: Since 2020, the Allotment Management Program (“AMP”) has served
commercial customers with undersized allotments by waiving some or all Excess Water Use
(“EWU”) surcharges accrued while implementing a project proposed to save water. By current
code, AMP is scheduled to stop accepting applications after December 31, 2022. The purpose of
this memo is to update the Water Commission on the Allotment Management Program and
request a recommendation to the City Council to extend the program by four years.
Background: Allotments and associated Excess Water Use surcharges incentivize customers to
track water use and reduce water need on a property. Customers may take advantage of a variety
of water conservation tools, incentives, and rebates to track and reduce use to get annual water
use under the allotment.
Ordinance 05, 2019 gives discretion to the Utilities Executive Director to provide qualified
customers a temporary exemption from EWU surcharges. The ordinance and supporting
Allotment Management Program create a solution for a specific group of customers that were
highly impacted by changes to the Water Supply Requirements in 2017. 2020 was the first year
in which waivers were issued to AMP participants. The intent of an AMP waiver is to free up
money otherwise spent on EWU surcharges to implement more costly outdoor water
conservation and efficiency projects. The group of customers eligible for an EWU waiver
through AMP must meet the following qualifications:
1) The allotment assigned to the water tap is insufficient for the minimum landscape
irrigation need1.
2) A plan provided by the applicant details the reduction of irrigation water use on the
property through a water conservation project.
Waivers may waive all or part of excess water use surcharges charged to an account for up to
three years. The length of the waiver issued is based on the type of water conservation project.
Waiver percentages based on type of waiver are shown in Table 1.
1 Need is determined by a Landscape Water Budget provided by Water Conservation, which includes the plant’s
water needs, irrigated area of the property, irrigation equipment type and weather data.
Table 1. Percent waiver issued for type of waiver
Year One Year Two Year Three
One-year waiver 100% None None
Two-year waiver 100% 50% None
Three-year waiver 100% 66% 33%
EWU Impact and AMP Participation to Date:
Over one-third of the 1,800 accounts assigned allotments have exceeded their allotments in the
life of the account. About 350 accounts have exceeded in the last three years. It is likely that of
those 350, there’s a portion of accounts that have allotments undersized for the landscape area,
however it is unknown exactly how many customers are AMP-eligible. Customers who outreach
to Utilities staff for solutions for accounts that exceed an allotment are evaluated for AMP
eligibility with a Landscape Water Budget through the Water Conservation department.
To date, 26 premises owned by 19 customers have been issued AMP EWU waivers. Projects
completed between 2020 and 2021 spanned over 900,000 square feet and have shown actual
water savings over 9 million gallons (equivalent to the annual average water use of 106 homes).
Results for projects completed in 2022 have not yet been evaluated.
The AMP waiver impact to revenue has been less than what was projected in 2018. At the onset
of this program staff estimated a revenue impact of more than 30% of total EWU revenue.
Through 2021, AMP waivers have not exceeded 15% of total EWU revenue (Table 2.).
Table 2. Percent total EWU revenue waived
Waivers issued (count
of premises)
Surcharges
waived
Percent of total EWU
revenue waived
2020 13 $96,969.51 15%
2021 9 $87,350.38 9%
2022 4 $5,704.11
(YTD)
-
Per Ordinance 05, 2019 the AMP application is scheduled to close Dec. 31, 2022. Staff
recommends extending the AMP application to Dec. 31, 2026, for the following reasons:
· AMP provides support to customers who would otherwise continue to be highly impacted
by EWU surcharges (2022: $16.67 per 1,000 gallons), especially those who cannot
manage a landscape without exceeding their annual allotment.
· The waiver of EWU fees, for HOAs and others who benefit from AMP, make outdoor
water conservation and efficiency projects financially feasible (i.e. paying EWU fees and
project costs in any given year are often cost prohibitive).
· The projects result in long-term water savings, which benefits the Utility and the
community.
· Demonstrated success of current program, which has helped 19 customers save millions
of gallons of water and provides an option to mitigate fee impacts without risking
landscape health.
Requested Action: Staff requests the Water Commission consider the proposed program
extension and make a recommendation to City Council for its consideration at 1st reading,
currently scheduled for November 15, 2022.
Example motion language:
Motion to recommend the City Council approve an ordinance to extend the Allotment
Management Program by three years.
CC: Jason Graham, Director of Water, Utilities
Gretchen Stanford, Utilities Deputy Director, Customer Connections
Eric Potyondy, Assistant City Attorney
Lance Smith, Direct FP&A, Utility Financial Operations
Mariel Miller, Water Conservation Manager