HomeMy WebLinkAbout03/25/2021 - Meeting Materials ■ ■ ■ ■
Public
SLC PUBLIC UTILITIES
Financial Review :
Financial Dashboard(February 28, 2021)
March 25, 2021
'., Public
utilities Financial Dashboard
As of February 28, 2021
Water Fund FY 21 Expense Detail
■ Personal Services
180,000,000 13.80%
160,000,000 I 2.35% ' O&M
140,000,000 / ■ Charges & Services
120,000,000
Debt Services
100,000,000
80,000,000 �22.67%■ Capital
Expenditures
po
60,000,000
r
40,000,000
20,000,000
0 59.03% 2.150
0
Revenues Expenses
February 28, 2021 Change from FY20 Percent of Budget
FY 19-20 ■ FY 20-21 ■ FY 21 Bud YTD FY 21 Bud Operating Revenues $62,131,917 $6,163,738 82.70%
Operating Expenses 43,758,649 3,549,059 59.24%
Capital Expenditures 66,534,451 26,043,253 77.48%
Amount Percent Time Total Expenses 110,293,100 29,592,312 69.05%
Remaining Remaining Remaining February 28, 2021 Change from FY20 Percent Change
2020 Bond Funds $71,858,825 92.99% 81.70% Available Cash $105,702,053 $69,731,138 193.85%
(included in cash) Accounts Receivable 2,417,250 690,680 40.00%
Public
�= -X Utilities
Financial Dashboard
t ;T
As of February 28, 2021
Sewer Fund FY21 Expense Detail
250,000,000 3.47% 0.50% 2.05%
\ -5.18% ■ Personal Services
200,000,000 ■ O&M
■ Charges & Services
150,000,000 Debt Service
■ Capital Expenditures
100,000,000
50,000,000
' 88.80%
0
Revenues Expenses February 28, 2021 Change from FY20 Percent of Budget
■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD FY 21 Bud Operating Revenues $34,113,935 $3,116,029 66.10%
Operating Expenses 11,949,002 499,013 52.14%
Capital Expenditures 176,236,855 57,606,963 99.56%
Amount Percent Time Total Expenses 188,185,857 58,105,976 94.13%
Remaining Remaining Remaining February 28, 2021 Change from FY20 Percent Change
2020 Bond Funds $64,090,515 60.25% 81.70% Available Cash $87,186,341 $49,118,313 129.03%
(Included in cash) Accounts Receivable 2,970,017 28,470 0.97%
'., Public
utilities Financial Dashboard
As of February 28, 2021
Stormwater FY21 Expense Detail
25,000,000
19.68%
20,000,000 51.88%
■ Personal Services
1.53%
15,000,000 ■ O&M
■ Charges & Services
10,000,000 Debt Services
I17.28% • Capital Expenditures
5,000,000
9.64%
0
Revenues Expenses February 28, 2021 Change from FY20 Percent of Budget
Operating Revenues $7,172,370 ($107,185) 71.72%
■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD FY 21 Bud Operating Expenses 3,980,940 (477,923) 47.04%
Capital Expenditures 5,367,529 (1,666,964) 43.58%
Amount Percent Time Total Expenses 9,348,469 (2,144,887) 44.99%
Remaining Remaining Remaining February 28, 2021 Change from FY20 Percent Change
2020 Bond Funds $12,297,025 84.51% 81.70% Available Cash $19,334,172 $13,756,370 246.63%
(Included in Cash) Accounts Receivable 869,288 120,071 16.03%
'., Public
utilities Financial Dashboard
As of February 28, 2021
Street Lighting FY21 Expense Detail
6,000,000 16 89% 6.62% 0.00%
■ Personal Services
5,000,000 ■ O&M
4.83% ■ Charges & Services
4,000,000 Debt Services
■ Capital Expenditures
3,000,000 60
2,000,000 44
71.66%
1,000,000
0 February 28, 2021 Change from FY20 Percent of Budget
Revenues Expenses Operating Revenues $2,683,989 ($88,748) 63.32%
■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD FY 21 Bud Operating Expenses 2,089,743 559,178 78.79%
Capital Expenditures 450,869 (80,654) 19.98%
Total Expenses 2,540,612 478,524 51.76%
February 28, 2021 Change from FY20 Percent Change
Available Cash $5,943,930 ($94,761) -1.57%
Accounts Receivable 214,575 (56,070) -20.72%
Public
Utilities Financial Dashboard
As of February 28, 2021
Total Public Utilities
February 28, 2021 Change from FY20 Percent of Budget
Operating Revenues $106,102,211 $9,083,834 75.26%
Operating Expenses $61,778,334 $4,129,327 57.25%
Capital Expenditures $248,589,704 $81,902,598 89.60%
Total Expenses $310,368,038 $86,031,925 80.54%
February 28, 2021 Change from FY20 Percent Change
Available Cash $218,166,496 $132,511,060 154.70%
Accounts Receivable $6,471,130 $783,151 13.77%
Delinquent Billings 3.93%
Amount Percent Remaining Time Remaining
2020 Bond Funds $148,246,364 74.80% 81.70%
(Included in Cash)
'., Public
,.e Utilities
Updates
Budget - FY2022
Submit budget to Mayor Mendenhall
Meet on April 5
Present to City Council — April 13 or April 20
Evaluating and prioritizing projects to develop
financing strategies
Consideration of timing of future revenue bond
issues
PUBLIC UTLITIES ANNUAL
2021 -22 FISCAL BUDGET
PROPOSAL
iFo
b
I I C
41,
j K .may
�- ' t � `V - jfn_C• ,:t'� t�~t •.L - - .+P sw r•yt .
ENTERPRISE FUNDS
SALT LAKE CITY DEPARTMENT OF PUBLIC UTILITIES RECOMMENDED BUDGET FOR
FISCAL YEAR 2022
Pub I i C
CITEUtIlITICS
Salt Lake City Department of Public Utilities (SLCDPU)
I recommend for approval, rates, operations, personnel changes and the capital
program as herein presented as the SLCDPUFY2022 Proposed Budget:
Laura Briefer,Director
Public Utilities Advisory Committee (PUAC)
The PUAC concurs with and supports the Salt Lake City Department of Public
Utilities FY 2022 Proposed Budget presentation:
Lynn Hemingway, Chair
Dated , 2022
Table of Contents
BUDGET SUMMARY FY 2022................................................................................................... 1
WATER UTILITY ENTERPRISE FUND.................................................................................. 5
WATER INFRASTRUCTURE BACKGROUND ............................................................................... 5
WATER UTILITY BUDGET HIGHLIGHTS FOR FY 2022............................................................. 5
SEWER UTILITY ENTERPRISE FUND..................................................................................9
SEWER INFRASTRUCTURE BACKGROUND................................................................................ 9
SEWER UTILITY BUDGET HIGHLIGHTS FOR FY 2022............................................................ 10
STORMWATER UTILITY ENTERPRISE FUND................................................................. 14
STORMWATER INFRASTRUCTURE BACKGROUND.................................................................. 14
STORMWATER UTILITY BUDGET HIGHLIGHTS FOR FY 2022............................................... 14
STREET LIGHTING UTILITY ENTERPRISE FUND......................................................... 17
STREET LIGHTING INFRASTRUCTURE BACKGROUND........................................................... 17
STREET LIGHTING UTILITY BUDGET HIGHLIGHTS FOR FY 2022........................................ 18
COMBINED UTILITIES-BUDGET SUMMARY AND CASH FLOW............................... 21
WATER UTILITY-BUDGET SUMMARY AND CASH FLOW.......................................... 27
SEWER UTILITY-BUDGET SUMMARY AND CASH FLOW.......................................... 43
STORMWATER UTILITY-BUDGET SUMMARY AND CASH FLOW........................... 55
STREET LIGHTING UTILITY-BUDGET SUMMARY AND CASH FLOW................... 61
APPENDIX A: RATE CHANGE COMPARISONS AND CUSTOMER IMPACTS...........65
APPENDIX B: SUPPLEMENTAL INFORMATION............................................................. 77
APPENDIX C: RATIONALE FOR NEW POSITIONS......................................................... 99
APPENDIX D: ALTERNATE WATER SCENARIO............................................................109
BUDGET SUMMARY FY 2022
Salt Lake City Department of Public Utilities (SLCDPU) is pleased to present its
recommended budget for fiscal year 2021-2022 (FY 2022). The FY 2022 budget includes
funding for operations, maintenance, and capital investments in the water, sewer,
stormwater, and street lighting utilities. The budget also reflects the enhancement of
operational programs to meet more stringent regulatory requirements for drinking water,
wastewater, and stormwater. SLCDPU operates each of its utilities as separate enterprise
funds.
Summary of Expenditures and Revenues
The total proposed FY 2022 budget is $420,480,027, a 4.29 % increase from the FY 2021
amended budget of$403,198,469. The FY 2021 adopted budget was adjusted for FY 2020
carryover encumbrances for open contracts and purchase orders. Those changes are
reflected in the amended budget amount. The proposed operating budget of$114,620,579
is $8,781,347 or 8.30% higher than the current year. The increase includes seventeen
proposed new employees, and a 3%increase to accommodate employee compensation and
benefit changes. Amounts paid to other departments for IMS charges, administrative
service fees, payment in lieu of taxes, and risk management is projected to increase by
$3,923,260. Operational costs also reflect an $494,337 increase to be paid to the
Metropolitan Water District of Salt Lake and Sandy(MWDSLS)pursuant to their projected
increased operational and capital needs.
The proposed capital budget for FY 2022 is $282,674,161. Debt service is anticipated to
be $23,185,287, including the cost of issuing new debt during the year. Total debt service
for FY 2022 is increasing due to the cost of issuing new debt.
Funding for capital projects in FY 2022 will be generated through rate revenue, the
issuance of revenue bonds, and a federal loan. Total bonding planned for FY 2022 is
$155,993,000. The timing of the planned issuance will be coordinated to meet cash flow
needs. SLCDPU plans to use a federal loan under the Water Infrastructure Finance and
Innovation Act (WIFIA) to finance $93,890,000 of the new water reclamation facility
(WRF) in FY 2022.
There are proposed rate increases for the water, sewer, and stormwater utilities. This
includes an 8% increase in water, an 18% increase in sewer, and a 10% increase in
stormwater rates. Appendix A includes a summary of expected customer rate impacts.
SLCDPU's total anticipated revenues for FY 2022 are $420,480,027, an increase of
$17,281,558. SLCDPU intends to transfer $784,760 to reserves from the remaining debt
funds.
1
Summary of Utilities Fund Budgets
Utility Funds
FY 2022 Operations Capital Debt Fund Totals
Water 78,375,791 44,222,835 4,766,929 127,365,555
Sewer 24,274,620 227,462,826 16,476,350 268,213,796
Storm 8,704,042 8,748,500 1,748,471 19,201,013
Street 3,266,126 2,240,000 193,537 5,699,663
Total $ 114,620,579 $ 282,674,161 $ 23,185,287 $ 420,480,027
Proposed Department of Public Utilities Expenditures for FY 2021-22
Major Expenditure Adopted Budget Amended Budget Proposed Budget Difference Percent
Categories 2020-2021 2020-2021 2021-2022 Change
Personal Services 41,961,790 42,360,790 45,645,184 3,284,394 7.75%
Materials and Supplies 7,605,558 7,622,463 7,735,360 112,897 1.48%
Charges for Services 56,271,884 58,791,491 61,240,035 2,448,544 4.16%
Debt Service 17,248,778 17,248,778 23,185,287 5,936,509 34.42%
Capital Outlay 4,769,726 4,874,507 6,167,835 1,293,328 26.53%
Capital I mprovements 234,455,413 272,300,440 276,506,326 4,205,886 1.54%
Total $ 362,313,149 $ 403,198,469 $ 420,480,027 $ 17,281,558 4.29%
Projected Department of Public Utilities Revenues for FY 2021-22
Revenue Adopted Budget Amended Budget Proposed Budget Difference Percent
2020-2021 2020-2021 2021-2022 Change
Operating Sales 135,312,126 135,312,126 158,309,402 22,997,276 17.00%
Interest 1,915,867 11915,867 728,700 (1,187,167) -61.97%
Permits 182,000 182,000 - (182,000) -100.00%
Interfund Charges 2,921,828 2,921,828 2,966,142 44,314 1.52%
Other Revenues 831,770 1,269,382 2,355,430 1,086,048 85.56%
Impact Fees 2,995,670 2,995,670 3,595,670 600,000 20.03%
Contributions 4,031,640 4,033,428 3,426,443 (606,985) -15.05%
Bond Proceeds 186,730,000 186,730,000 249,883,000 63,153,000 33.82%
From(To) Reserves 26,804,643 67,838,168 (784,760) (68,622,928) -101.16%
Total $ 361,725,544 $ 403,198,469 $ 420,480,027 $ 17,281,558 4.29%
Summary of Additional Proposed Positions
The proposed budget includes the addition of seventeen (17) new full time equivalent
(FTE)positions. These recommended positions are identified to assist SLCDPU in meeting
regulatory and programmatic requirements, increase in-house engineering capacity to
reduce our reliance on consultant engineers, convert hard to fill seasonal positions, and
supporting the economic and geographic growth within our service area. There are two
2
positions to highlight for the department that reflect new organizational functions within
SLCDPU. The first is a proposed Chief Strategy and Innovations Officer (CSIO). The
CSIO is proposed to help SLCDPU identify and secure strategic federal and state funding
opportunities for major infrastructure projects, assist the Director and department
leadership with federal, state, and local intergovernmental relationships, and provide
needed capacity for innovations such as the City's ERP, smart cities/street lighting, and
water resource initiatives. Given the identified funding needs and gaps associated with
aging infrastructure and the possible opportunities for infrastructure funding in the new
federal administration, SLCDPU will be tasking the CSIO with identifying and
implementing grants and low-interest loans to finance the projects to reduce the impact to
our ratepayers.
The second position to highlight reflects a new partnership with the Uinta-Wasatch-Cache
National Forest (UWCNF). SLCDPU and the UWCNF have a long-standing partnership
to manage the mountain watersheds that provide nearly 60% of the water supply to Salt
Lake City and its water service area. A major and growing challenge is the upkeep and
improvements of sanitary facilities in the watersheds due to significantly increased
recreation visitation. Degraded sanitary facilities present a risk to water quality in our
drinking water sources. The USFS is anticipating the receipt of federal Great American
Outdoors Act(GAOA) funding to conduct projects within the UWCNF. Through a future
agreement, the UWCNF will be allocating GAOA funds to SLCDPU to support the full
cost of a project manager (under Water Quality) for two years to design and manage the
construction of upgraded Forest Service-owned sanitary facilities within our watersheds.
This agreement benefits both the UWCNF,which has limitations on hiring new employees,
and SLCDPU which must maintain safe drinking water. It should be noted that the
utilization of this position will be dependent on the completion of an executed agreement
with the UWCNF.
SLCDPU currently has 447.50 FTEs and is proposing the following positions to meet
identified needs. Appendix C contains detailed cost-benefit information regarding the
additional engineering requests.
3
Proposed Personnel Adiustments FY 2021-2022
Administration Water Sewer Stormwater Street Lighting Total
CONSERVATION TECHNICIAN 1.00 - - - 1.00
CHIEF STRATEGYAND INNOVATIONS OFFICER 0.30 0.30 0.25 0.15 1.00
2.00
GIS and IT Systems
LOCATOR MANAGER 0.50 0.30 0.20 - 1.00
1.00
Water Quality
PROJECT MANAGER 1.00 - - 1.00
WATERSHED RANGER 1.00 1.00
LEAD AND COPPER SUPERVISOR 1.00 - 1.00
3.00
Maintenance
DRAINAGE MAINTENANCE WORKER II(LEAD) - 1.00 1.00
DRAINAGE MAINTENANCE WORKER III - 1.00 1.00
WASTE WATER LIFT STATION LEAD WORKER - 1.00 1.00
LANDSCAPE RESTORATION WKR 1.00 - - 1.00
IRRIGATION OPERATOR II 1.00 - - 1.00
5.00
Engineering
ENGINEER V Asset Management Coordinator 0.40 0.30 0.30 1.00
ENGINEER V Construction Management Coord. 0.40 0.30 0.30 1.00
ENGINEER IV IN-HOUSE DESIGN,CONST,ASSET MNG 0.40 0.30 0.30 1.00
ENGINEER IV IN-HOUSE DESIGN,CONST,ASSET MNG 0.40 0.30 0.30 1.00
ENGINEER IV IN-HOUSE DESIGN,CONST,ASSET MNG 0.40 0.30 0.30 1.00
ADMINISTRATIVE SECRETARY 1 0.50 0.25 0.25 - 1.00
6.00
Total New FTEs 9.30 3.35 4.20 0.15 17.00
4
Water Utility Enterprise Fund
Water Infrastructure Background
The Salt Lake City water system is one of the oldest and largest systems west of
the Mississippi River with over 1,125 miles of 12" or smaller distribution lines, and more
than 180 miles of large transmission mains for a total asset inventory of 1,305 miles of pipe
with over fifty pressure zones. The service area covers the Salt Lake City corporate
boundaries as well as the east side of the Salt Lake Valley to the mouth of Little
Cottonwood Canyona total of 141 square miles. This includes water supply to portions
of other incorporated cities such as Mill Creek, Cottonwood Heights, Holladay, and small
portions of Murray, Midvale, and South Salt Lake Cities.
SLCDPU's asset management program includes personnel and systems to assess the
condition of the large water transmission mains,distribution mains,treatment and pumping
plants, reservoirs, tanks, wells, canals, and other infrastructure to assure repair and
replacement is completed with minimal impact to the public.
Addressing aging water infrastructure through rehabilitation and replacement is a priority
and is the primary reason behind gradual rate increases planned for the next few years in
the water utility. For instance, each of SLCDPU's three water treatment plants were
originally constructed in the 1950's and have undergone numerous upgrades. Based on
recent condition assessments, SLCDPU is preparing a strategy to replace these treatment
plants in future years to ensure this critical infrastructure remains viable for the long term
protection of public health and can better withstand major seismic events. There is also a
continual need to repair and replace pipe segments to maintain water service and reduce
emergency repair costs and impacts to the public.
Water Utility Budget Highlights for FY 2022
Anticipated Revenues
The impacts of the COVID-19 pandemic over the last year continue to be evaluated. At
this time, revenues in the water utility appear to not have been impacted significantly,
although patterns of water use appear to have shifted slightly to reflect increased residential
use and decreased commercial use. Due to anticipated drought responses this year leading
to reduced water consumption, we are conservatively estimating revenues.
SLCDPU intends to issue revenue bonds of$26,146,000 in FY 2022 designated for water.
Additional bonding of$166,927,000 is anticipated from FY 2023 to FY 2026 meet water
utility capital project objectives.
The revenue budget is proposed to decrease by $35,267,065 or 21.69% from the FY 2021
budget. The proposed water utility budget for FY 2022 by major category is as follows:
5
Projected Water Revenues for FY 2021-22
Revenue
Adopted Budget Amended Budget Proposed Budget Difference Percent
2020-2021 2020-2021 2021-2022 Change
Operating Sales 71,013,328 71,013,328 85,462,346 14,449,018 20.35%
Interest 715,896 715,896 398,000 (317,896) -44.41%
Interfund Charges 2,921,828 2,921,828 2,966,142 44,314 1.52%
Other Revenues 611,270 900,176 1,836,730 936,554 104.04%
Impact Fees 1,184,670 1,184,670 1,784,670 600,000 50.65%
Contributions 1,975,640 1,975,640 1,953,620 (22,020) -1.11%
Bond Proceeds 42,235,000 42,235,000 26,146,000 (16,089,000)
From(To) Reserves 5,675,561 41,686,082 6,818,047 (34,868,035) -83.64%
Total $ 126,333,193 $ 162,632,620 $ 127,365,555 $ (35,267,065) -21.69%
Operating Sales: Revenue is expected to be 20.35%more than FY 2021 budgeted levels.
The proposed budget is based on modeling done on 10-year water sales. The forecast
anticipates a decrease in overall consumption from the average. FY 2021 actual sales
outpaced the amended budget for the year.
Interest Income: Interest earnings are expected to decrease as bond proceeds are spent
during the year.
Interfund Charges: The water utility is reimbursed by sewer, stormwater, street lighting,
refuse, and the Hive program for services related to billing. Related revenue is anticipated
to increase based on actual costs.
Impact Fees: Impact fees are budgeted to increase $600,000 for new development. The
FY 2022 budget is a conservative estimate based on historical and current trend
information.
Bond Proceeds: A bond issue of$26,146,000 is anticipated.
Reserve Funds: SLCDPU plans to use $6,818,047 of reserve funds to balance the capital
and operation needs. Budgeted use of reserve funds is $34,868,035 less than the FY 2021
amended budget or a decrease of 83.64%
Proposed Expenditures
The water utility's FY 2022 budget includes an increase of $1,686,755 in charges for
services and an increase of $2,497,506 in personal services. The increase in personal
services is attributed to the addition of 9.30 FTEs and a 3% increase to accommodate
employee compensation and benefit changes. The new FTEs requested will support the
SLCDPU's administration, water resources, maintenance, engineering, and water quality
divisions to meet regulatory requirements and support continued economic activity.
Metropolitan Water District of Salt Lake and Sandy (MWDSLS) is projecting to increase
the current price levels for water for FY 2022 without increases to operational or
assessment charges. A 3% increase is included in this budget. Pursuant to SLCDPU's
recent water supply and demand planning, the FY 2022 budget includes a scheduled
6
payment for the Central Utah Project Utah Lake System(ULS)petition for 3,100-acre feet
of new water resources. The MWDSLS payment for the ULS petition of$844,223 is passed
through to SLCDPU and is reflected in the SLCDPU FY 2022 proposed budget.
SLCDPU plans to invest $39,600,000 in capital improvements for water utility
infrastructure in FY 2022. The capital improvement program includes a prioritized balance
of needed improvements to treatment plants, water lines, meter replacements, pump
stations, wells, and other infrastructure. A portion of the water main replacements are
being performed in conjunction with the General Fund bonded street repair projects. In
FY 2021, the capital improvements budget was significantly reduced from earlier planned
investments due to anticipated impacts of the COVID-19 pandemic and the deferral of a
planned rate increase. SLCDPU is now resuming its plans for gradual rate increases and
significant investment into aging infrastructure this year.
The expenditure budget for the water utility is proposed to decrease$35,267,065 or 21.69%
from the FY 2021 amended budget. The proposed budget for FY 2022 by major category
is as follows:
Proposed Water Expenditures for FY 2021-22
Major Expenditure Adopted Budget Amended Budget Proposed Budget Di Percent
Difference
Categories 2020-2021 2020-2021 2021-2022 Change
Personal Services 25,518,196 25,774,546 28,272,052 2,497,506 9.69%
Materials and Supplies 4,789,775 4,806,680 4,839,903 33,223 0.69%
Charges for Services 41,493,558 43,577,081 45,263,836 1,686,755 3.87%
Debt Service 2,885,774 2,885,774 4,766,929 1,881,155 65.19%
Capital Outlay 3,715,890 3,820,671 4,622,835 802,164 21.00%
Capital Improvements 47,930,000 81,767,868 39,600,000 (42,167,868) -51.57%
Total $ 126,333,193 $ 162,632,620 $ 127,365,555 $ (35,267,065) -21.69%
Personal Services: Employee related costs are estimated to increase $2,497,506 or 9.69%.
The water utility budget anticipates an increase of 9.30 FTEs. The FY 2022 budget
includes a 3% increase to accommodate employee compensation and benefit changes.
Materials & Supplies: The increase in this category is less than 1%.
Charges for Services: The proposed budget for charges and services will increase
$1,686,755 or 3.87%. The increase can be attributed to a proposed increase in MWDSLS
rates of$494,337, increases in professional and consultants, and increased IMS costs.
Debt Service: In compliance with current bond issues and in anticipation of additional
debt,the budget for debt services is projected to increase by $1,881,155.
Capital Outlay: The proposed budget for capital outlay for FY 2022 includes $1,500,000
for watershed purchases, $250,000 for water right and company purchases, $250,000 for
water stock purchases, $150,000 for additional land purchases, $1,081,900 for 18 vehicles,
$965,475 for field equipment, $180,000 for treatment plant equipment, $101,600 for office
furniture and equipment, and$143,860 for other non-motive equipment.
7
Capital Improvements: The proposed capital improvement budget for FY 2022 is
$39,600,000. A detailed list of capital improvement projects is included in the cash flow
summaries for the water utility. A capital project summary by facility type is as follows:
Proposed Water Capital Improvement Program for
FY 2021-22
Type of Project Proposed Budget
2021-2022
Treatment Plants 7,350,000
Water Service Connections 5,450,000
Pumping Plant Upgrades 1,550,000
Reservoirs 4,000,000
Water Mains and Hydrants 18,019,000
Wells 1,630,000
Culverts, Flumes, and Bridges 1,533,000
Landscaping 68,000
Total 2021-2022 CIP $ 39,600,000
8
Sewer Utility Enterprise Fund
Sewer Infrastructure Background
The City's Water Reclamation Facility(WRF)was constructed in 1965 and has undergone
numerous upgrades since. Nutrient removal regulations adopted by the Utah Department
of Environmental Quality(UDEQ) in 2015 require a new sewage treatment process. After
much study, SLCDPU determined that the WRF has reached the end of its useful life and
adapting the 55- year old facility to meet the new nutrient removal requirements is not
feasible. A new WRF is currently under construction, to be completed in order to meet
UDEQ's nutrient compliance date of January 1, 2025. SLCDPU has been implementing
gradual rate increases and revenue bonding for the replacement of the WRF.
The sewer collection system (654 miles of pipeline, and several pump stations) is a very
challenging environment; hydrogen sulfide gases, sediment, roots and other factors affect
the competency of the collection lines. SLCDPU's asset management program includes
personnel and systems to assess the condition of the sewer collection system, pump
stations, and other infrastructure to assure repair and replacement is completed with
minimal impact to the public.More than 50%of the sewer collection system is greater than
85 years old.
SLCDPU is expanding capacity of the sewer collection system,in large part to meet growth
requirements related to the new State Correctional Facility,the Airport expansion,and new
development anticipated in the Northwest Quadrant of Salt Lake City.
9
Sewer Utility Budget Highlights for FY 2022
Total project costs for the WRY reconstruction are anticipated to be $711,653,000 when
the project is completed. Construction began in FY 2020. SLCDPU has expended
approximately $69.5 million to date on this project.
Current financing for the new WRF is anticipated to be accomplished using a combination
of revenue bonds, user rates, and a federal loan through the Water Infrastructure Finance
and Innovation Act(WIFIA). The loan will provide up to 49%of the cost of the new WRF.
The interest rate at loan closing in 2020 was extremely favorable at 1.34%. This is expected
to save SLCDPU's ratepayers more than$100 million over the life of the project compared
to revenue bonds.
Sewer Planned Debt
FY WIFIA Bonds Total
2019-2020 - 55,000,000 55,000,000
2020-2021 93,210,000 51,000,000 144,210,000
2021-2022 93,980,000 123,000,000 216,980,000
2022-2023 70,465,000 88,000,000 158,465,000
2023-2024 64,017,000 46,000,000 110,017,000
2024-2025 24,356,000 - 24,356,000
2025-2026 2,697,000 - 2,697,000
Total $ 348,725,000 $ 363,000,000 $ 711,725,000
Anticipated Revenues
A proposed 18%rate increase is anticipated to generate an additional $7,713,937 in sewer
fees. Proposed sales revenues are based on the best estimates available. The additional
revenue is required for the sewer utility to meet its capital and operations objectives. Rate
increases in future years are also anticipated at this time.
SLCDPU plans to issue bonds during FY 2022 with$123,687,000 designated for the sewer
utility. Additional bonded debt of$134,748,000 is anticipated from FY 2023 to FY 2025
to meet capital objectives, primarily the reconstruction of the WRF. It is anticipated that
WIFIA loan proceeds of$161,535,000 will be utilized during the same period. Debt will
be used in conjunction with rate increases to blend pay as you go and borrowing strategies.
The proposed debt is for a 30- year term creating intergenerational equity payback on the
new WRF facility. The City's professional financial advisors have been involved in the
process to measure debt service and ratios to comply with external rating agency standards.
SLCDPU intends to maintain its AAA rating to limit costs of borrowing.
10
The total revenue budget is expected to increase by $55,461,455 or 26.07% to
$268,213,796 from the FY 2021 amended budget. Bond issues and a federal loan are the
largest components of the increase. The proposed budget for FY 2022 by major category
is as follows:
Projected Sewer Revenues for FY 2021-22
Adopted Budget Amended Budget Proposed Budget Difference Percent
Revenue 2020-2021 2020-2021 2021-2022 Change
Operating Sales 50,321,000 50,321,000 58,034,937 7,713,937 15.33%
Interest 992,301 992,301 171,000 (821,301) -82.77%
Permits 182,000 182,000 267,500 85,500 46.98%
Other Revenues 134,000 247,942 154,500 (93,442) -37.69%
Bond/Note Proceeds 144,495,000 144,495,000 217,577,000 73,082,000 50.58%
Impact Fees 1,422,000 1,422,000 1,422,000 - 0.00%
Contribution 1,684,000 1,684,000 1,100,823 (583,177) -34.63%
From (To) Reserves 13,408,098 13,408,098 (10,513,964) (23,922,062) -178.42%
Total $ 212,638,399 $ 212,752,341 $ 268,213,796 $ 55,461,455 26.07%
Sewer service fees: Sewer service fees are expected to increase $7,713,937 or 15.33%.
SLCDPU assumes that due to the COVID-19 pandemic, revenue from sewer sales could
decrease. AWC information was utilized to determine a reasonably anticipated sales base,
and then applied the 18%rate increase. The proposed increase is approximately$6.32 per
month for the representative resident, assuming winter water use of eight CCF. Winter
water use of eight CCF is conservative as some of our residents use less than eight CCF
during the winter months. The additional revenue from rates is required for the sewer
utility to meet is capital and operations objectives while balancing debt.
Interest Income: Interest earnings are expected to decrease with the spending of capital
funds.
Permit Fees: Increased to reflect actual historical collections.
Other Revenues: Decreased to reflect estimate based on historical collections.
Impact Fees: No change is anticipated.
Bond/Note Proceeds: A bond issue of$123,687,000 is anticipated. The budget anticipates
utilizing $93,890,000 in WIFIA loan proceeds.
Contribution: Decreased to reflect updated collections information.
Reserve Funds: Unspent bond proceeds of$10,513,964 will added to reserves for use on
the WRF project.
Proposed Expenditures
The proposed sewer budget for FY 2022 includes $226,135,826 in planned projects. Of
this amount $189,320,826 is designated for the new WRF, $1,725,000 for the existing
WRF, and$35,090,000 for improvements to the sewer collections system. A portion of the
11
sewer collection line replacements are being performed in conjunction with the City's
general obligation bonded street repair projects.
The sewer utility's FY 2022 budget proposes an increase of$55,461,455 or 26.07% over
the FY 2021 amended budget. The proposed budget for FY 2022 by major category is as
follows:
Proposed Sewer Expenditures for FY 2021-22
Major Expenditure Adopted Budget 2020- Amended Budget Proposed Budget Difference Percent
Categories 2021 2020-2021 2021-2022 Change
Personal Services 12,590,497 12,698,997 12,799,959 100,962 0.80%
Materials and Supplies 2,579,981 2,579,981 2,656,055 76,074 2.95%
Charges for Services 7,746,203 7,751,645 8,818,606 1,066,961 13.76%
Debt Service 12,707,469 12,707,469 16,476,350 3,768,881 29.66%
Capital Outlay 671,836 671,836 1,327,000 655,164 97.52%
Capital Improvements 176,342,413 176,342,413 226,135,826 49,793,413 28.24%
Total $ 212,638,399 $ 212,752,341 $ 268,213,796 $ 55,461,455 26.07%
Personal Services: Employee related costs are estimated to increase $100,962 or .80%.
The sewer utility budget anticipates an increase of 3.35 FTEs. The FY 2022 budget
includes a 3%increase to accommodate employee compensation and benefit changes. The
amended budget for FY 2021 included a generous estimate for overtime. FY 2022 amounts
in this category have been updated.
Materials & Supplies: The sewer utility's budget for this category increases by $76,074.
The increase is attributed to additional chemical purchases.
Charges for Services: Increases in professional and contractual services, increases in IMS
charges for services, and increased sludge management fees represent the largest portion
of the budget increase in this category.
Debt Service: The annual debt service budget is expected to increase by $3,768,881 in
FY 2022. The increase is attributed to payments on existing debt and interest payments for
new debt.
Capital Outlaw The proposed capital outlay budget for FY 2022 includes $860,000 for
vehicles and trucks, $269,000 for field maintenance equipment, $185,000 for treatment
plant equipment, and $13,000 for other non-motive equipment.
Capital Improvements: The proposed capital improvement budget for FY 2022 is
$226,135,826, an increase of $49,793,413 over the current year amended budget. A
detailed list of capital improvement projects is included in the cash flow summary for the
sewer utility. A capital project summary by facility type is as follows:
12
Proposed Sewer Capital Improvement Program for FY 2021-22
Type of Project Proposed Budget
2021-2022
WRF 191,045,826
Collection System 32,405,000
Lift Stations 2,685,000
Northwest Oil Drain -
Total 2021-2022 CIP $ 226,135,826
13
Stormwater Utility Enterprise Fund
Stormwater Infrastructure Background
The City's stormwater system includes 350 miles of stormwater collection lines, 77 miles
of canals and drainage ditches, 32 miles of open channel creeks and rivers, culverts, 27 lift
stations, and 63 detention basins. These systems must be maintained to prevent flooding
and to meet the water quality requirements in the Municipal Separate Storm Sewer System
(MS4) permit. SLCDPU is also responsible for all city facilities meeting MS4
requirements.
A Drainage Master Plan was completed in 1993. The FY 2022 budget includes the
continuation of on update of the Drainage Master Plan to include water quality and climate
change issues, such as storm intensification, in addition to traditional conveyance.
Stormwater Utility Budget Highlights for FY 2022
Anticipated Revenues
A planned 10%rate increase was deferred in FY 2021 due to anticipated economic impacts
of the COVID-19 pandemic. SLCDPU is proposing a rate increase of 10% in FY 2022,
and plans increases between 10% and 15% in future years through FY 2026 in order to
maintain and rehabilitate infrastructure and meet more stringent water quality
requirements.
SLCDPU plans to issue bonds during FY 2022 with$6,160,000 designated for stormwater
utility needs. This amount is primarily associated with stormwater collection system
replacement in coordination with the City's streets bond.
The revenue budget is proposed to decrease by $3,192,015 or 14.25% from the FY 2021
amended budget. The proposed revenue budget for FY 2022 by major category is as
follows:
Projected Storm Revenues for FY 2021-22
Revenue Adopted Budget Amended Budget Proposed Budget Difference Percent
2020-2021 2020-2021 2021-2022 Change
Operating Sales 9,753,500 9,753,500 10,714,550 961,050 9.85%
Interest 199,670 199,670 119,200 (80,470) -40.30%
Other Revenues 52,000 86,764 64,000 (22,764) -26.24%
Impact Fees 389,000 389,000 389,000 0.00%
Contributions 352,000 352,000 352,000 - 0.00%
Bond Proceeds - - 6,160,000 6,160,000
From(To) Reserves 6,628,085 11,612,094 1,402,263 (10,209,831) -87.92%
Total $ 17,374,255 $ 22,393,028 $ 19,201,013 $ (3,192,015) -14.25%
14
Operating Sales: Revenue is expected to increase by approximately 10%.
Interest Income: Interest earnings are expected to decrease due to spending of bond
proceeds.
Other Revenues: FY 2021 amended budget includes one-time CARES funding.
Contributions: No change is anticipated.
Impact Fees: No change is anticipated.
Bond/Note Proceeds: A bond issue of$6,160,000 is anticipated.
Reserve Funds: Reserves of $1,402,263 will be utilized for stormwater system
improvements. These funds will come from the Series 2020 Bond proceeds.
Proposed Expenditures
The stormwater utility's FY 2022 budget proposes capitalizing $8,530,500 to renovate
portions of the stormwater collection system. The schedule for stormwater system
improvements has been adjusted to perform work in conjunction with the general
obligation bonded street repair projects. The FY 2022 capital improvements budget
includes continued funding for this cooperative work.
The expenditure budget for the stormwater utility is proposed to decrease $3,192,015 or
14.25%. The proposed budget for fiscal year FY 2022 by major category is as follows:
Proposed Storm Expenditures for FY 2021-22
Major Expenditure Adopted Budget Amended Budget Proposed Budget Difference Percent
Categories 2020-2021 2020-2021 2021-2022 Change
Personal Services 3,628,930 3,661,580 4,215,783 554,203 15.14%
Materials and Supplies 228,808 228,808 232,408 3,600 1.57%
Charges for Services 4,315,421 4,723,194 4,255,851 (467,343) -9.89%
Debt Service 1,463,701 1,463,701 1,748,471 284,770 19.46%
Capital Outlay 382,000 1,363,007 218,000 (1,145,007) -84.01%
Capital Improvements 7,943,000 10,952,739 8,530,500 (2,422,239) -22.12%
Total $ 17,961,860 $ 22,393,028 $ 19,201,013 $ (3,192,015) -14.25%
Personal Services: Employee related costs are estimated to increase $554,203 or 15.14%.
The stormwater utility budget anticipates an increase of 4.20 FTEs. The FY 2022 budget
includes a 3% increase to accommodate employee compensation and benefit changes.
Char,ges for Services: Studies and consultants are anticipated to decrease in FY 2022.
Debt Service: The budget increases by$284,770 of 19.46%for interest payments required
by the planned bond issue.
Capital Outlay: The proposed capital outlay budget for FY 2022 includes $209,000 for
vehicles and$9,000 for field maintenance equipment.
15
Capital Improvements: The proposed capital improvement budget for FY 2022 is
$8,530,500, a decrease of$2,422,239 from the FY 2021 amended budget. A detailed list
of capital improvement projects is provided in the cash flow summary for the stormwater
utility. The capital project summary by facility types are as follows:
Proposed Storm Capital Improvement Program for FY 2021-22
Type of Project Proposed Budget
2021-2022
Lines and Riparian Corridor Projects 7,612,500
Lift Stations 700,000
Landscaping 168,000
Detention Basins 50,000
Total 2021-2022 CIP $ 8,530,500
16
Street Litzhtiniz Utility Enterprise Fund
Street Lighting Infrastructure Background
SLCDPU has updated the City's 2006 Street Lighting Master Plan in order to focus on
community safety and aesthetic needs,particularly since updating lights and conversion of
streetlights to energy efficient bulbs has changed the character of lighting in some
neighborhoods.
In anticipation of the adoption of the updated master plan, SLCDPU anticipates revising
the street lighting cost of service and rate study, as well as preparing a programmatic and
systematic approach to implementation of the master plan.
Of the 15,662 lights that the City maintains, 8,796 lights or 56% are now considered to be
energy efficient. SLCDPU is in the seventh year of a ten-year plan to convert all the lights
to high energy efficiency lamps. The FY 2022 budget funds continuing conversion to high
efficiency lights. Ongoing conversions are anticipated in some neighborhoods once the
Street Lighting Master Plan is completed to provide better guidelines related to lighting
color and intensity.
17
Street Lighting Utility Budget Highlights for FY 2022
Anticipated Revenues
No rate changes are proposed in the FY 2022 budget. The base lighting rates were
established in 2013 at $3.73 per month for an average residential customer, or Equivalent
Residential Unit (ERU), and are expected to remain unchanged for this fiscal year. Rates
for enhanced tiers are Tier 1 $5.67, Tier 2 $15.94, and Tier 3 $43.82.
Continuation of the private lights program is proposed in the FY 2022 budget.The program
includes a$20,000 transfer from the General Fund and indicates the on-going desire of the
City to provide a matching support to reduce the capital costs to neighborhoods installing
private street lighting. SLCDPU administers this program.
The revenue budget is proposed to increase by $279,183 from the FY 2021 budget. The
proposed budget for FY 2022 by major category is as follows:
Projected Street Lighting Revenues for FY 2021-22
Revenue
Adopted Budget Amended Budget Proposed Budget Difference Percent
2020-2021 2020-2021 2021-2022 Change
Operating Sales 4,224,298 4,224,298 4,097,569 (126,729) -3.00%
Interest 8,000 8,000 40,500 32,500 406.25%
Other Revenues 34,500 34,500 32,700 (1,800) -5.22%
General Fund Contributions 20,000 21,788 20,000 (1,788) -8.21%
From (To) Reserves 1,092,899 1,131,894 1,508,894 377,000 33.31%
Total $ 5,379,697 $ 5,420,480 $ 5,699,663 $ 279,183 5.15%
Operating Sales: Rate changes are not proposed thus this category is expected to change
significantly. The FY 2022 budget is based on actual sales revenue from FY 2020.
Interest Income: Interest earnings budget was revised based on a review of historical and
current year earnings.
Other Revenues: The slight decrease is based on 5-year historical data.
General Fund Contributions: FY 2021 amended budget included CARES funding.
Reserve Funds: The FY 2021 budget anticipates using $1,508,894 from the utility's
reserve funds.
18
Proposed Expenditures
Street lighting capital improvements totaling $2,240,000 are planned in the FY 2022
budget. The Street Lighting Capital Program focuses on high efficiency and system
upgrades in neighborhood, arterial and collector streets.
The expenditure budget for the street lighting utility is proposed to increase $279,183 or
5.15% from the FY 2021 amended budget. The proposed budget for FY 2022 by major
category is as follows:
Proposed Street Lighting Expenditures for FY 2021-22
Major Expenditure Adopted Budget Amended Budget Proposed Budget Percent
Difference
Categories 2020-2021 2020-2021 2021-2022 Change
Personal Services 224,167 225,667 357,390 131,723 58.37%
Materials and Supplies 6,994 6,994 6,994 - 0.00%
Charges for Services 2,716,702 2,739,571 2,901,742 162,171 5.92%
Debt Service 191,834 191,834 193,537 1,703 0.89%
Capital Improvements 2,240,000 2,256,414 2,240,000 (16,414) -0.73%
Total $ 5,379,697 $ 5,420,480 $ 5,699,663 $ 279,183 5.15%
Personal Services: Employee related costs are estimated to increase $131,723 or 58.37%.
The street lighting utility budget anticipates an increased allocation of 1.15 FTE. The FY
2022 budget includes a 3% increase to accommodate employee compensation and benefit
changes.
Charges for Services: The proposed budget for charges and services increases $162,171
or 5.92% in FY 2022 with a budgeted increase in professional and contractual services.
Debt Service: In compliance with the outstanding Series 2017 Bond, budgeted debt
service payments will increase slightly from FY 2021.
Capital Equipment: No expenditures of capital equipment are planned.
Capital Improvements: The proposed capital improvement budget for FY 2022 is
$2,240,000, a decrease of$16,414 from the FY 2021 amended budget. A capital projects
summary by facility type is as follows for base lighting and all enhanced tiers:
Proposed Street Lighting Capital Improvement Program for FY 2021-22
Type of Project Proposed Budget 2021-
2022
System upgrades for high efficiency and uniformity-Base Tiers 1-3 2,240,000
Total 2021-2022 CIP $ 2,240,000.00
19
This page left intentionally blank.
20
Combined Utilities- Budllet Summary and Cash Flow
21
PUBLIC UTILITIES
WATER,SEWER,STORMWATER,AND STREET LIGHTING COMBINED BUDGET SUMMARY
FY 2022-2024
Combined Rote Increase Combined Rote Increase Combined Rote Increase
1R% 15% 130/,
AMENDED PROJECTED PROPOSED PROPOSED PROPOSED
ACTUAL BUDGET ACTUAL BUDGET BUDGET BUDGET
SOURCES 2019-20 2020-21 2020-21 2021-22 2022-23 2023-24
REVENUE&OTHER SOURCES
REVENUES
UTILITY SERVICE REVENUE $ 134,778,497 $ 133,792,106 $143,357,759 $ 158,309,402 $ 181,426,202 $ 204,479,572
INTEREST INCOME 1,867,054 1,915,867 1,933,000 728,700 562,830 733,800
OTHER REVENUES 4,615,608 5,109,649 5,109,649 5,237,231 5,237,231 5,237,231
TOTAL REVENUES $ 141,261,159 $ 140,817,622 $150,400,408 $ 164,275,333 $ 187,226,263 $ 210,450,603
OTHER SOURCES
GRANTS&OTHER RELATED REVENUES $ 8,083,450 $ 4,643,961 $ 4,643,961 3,434,284 $ 3,434,284 $ 3,434,284
SALE OF EQUIPMENT $ 300,109 $ 155,260 $ 155,260 56,500 $ 56,500 $ 56,500
IMPACT FEES 4,710,332 2,995,670 3,511,006 3,595,670 3,595,670 3,595,670
TRANSFERS FROM GENERAL FUND - 21,788 21,788 1 20,000 20,000 20,000
WIFIA LOAN 93,210,000 93,210,000 93,890,000 70,465,000 64,017,000
BOND PROCEEDS 93,520,000 197,939,471 155,993,000 130,726,000 108,603,000
NON BOND FINANCING - - - - -
SHORT-TERM FINANCING
COUNTY FLOOD CONTROL
OTHER SOURCES -
TOTAL OTHER SOURCES $ 13,093,891 $ 194,546,679 $299,481,486 $ 256,989,454 $ 208,297,454 $ 179,726,454
TOTAL REVENUE&OTHER SOURCES $ 154,355,050 $ 335,364,301 $449,881,894 $ 421,264,7W $ 395,523,717 $ 390,177,057
EXPENSES&OTHER USES
EXPENDITURES
PERSONNEL SERVICES $ 34,309,801 $ 42,360,790 $ 42,360,790 45,645,184 $ 47,188,269 $ 48,784,598
OPERATING&MAINTENANCE 4,939,908 7,622,463 7,622,463 7,735,360 7,890,067 8,047,870
TRAVEL&TRAINING 82,058 314,177 314,177 298,005 303,966 310,046
UTILITIES 2,823,062 5,101,677 5,101,677 5,172,058 5,275,499 5,381,009
TECHNICAL SERVICES 5,714,544 17,131,119 16,661,119 16,466,271 17,295,598 17,641,512
IMS SERVICES 2,549,270 2,503,000 2,503,000 4,332,073 4,418,715 4,507,090
PUBLIC SERVICES/STREET SWEEPING 819,605 819,605 819,605 819,605 835,997 852,717
FLEET MAINTENANCE 1,655,067 2,008,050 2,008,050 2,005,500 2,045,610 2,086,521
ADMINISTRATIVE SERVICE FEE 1,482,952 1,555,200 1,555,200 1,600,416 1,632,424 1,665,074
PAYMENT IN LIEU OF TAXES 1,126,697 1,393,358 1,393,358 1,413,775 1,442,051 1,470,892
RISK MANAGEMENT 748,481 1,913,500 1,913,500 1,949,300 1,988,286 2,028,051
TRANSFERS TO GENERAL FUND - 14,000 14,000 14,000 14,280 14,566
BILLING COST 1,684,523 1,502,571 1,502,571 1,618,882 1,651,259 1,684,284
NEW PLANT O&M COSTS - - - - 250,000 252,500
METRO.WATER PURCH&TREAT 15,668,662 16,474,663 16,474,663 16,969,000 17,308,380 17,654,548
METRO ASSESSMENT(CAPITAL) 7,021,892 7,866,115 7,866,115 7,866,115 7,866,115 7,866,115
OTHER CHARGES AND SERVICES (309,437) 355,410 355,410 715,035 729,335 743,926
TOTAL EXPENDITURES $ 80,317,085 $ 108,935,698 $108,465,698 114,620,579 $ 118,135,851 $ 120,991,319
OTHER USES
CAPITAL OUTLAY $ 6,219,965 $ 5,397,151 $ 5,397,151 $ 6,167,835 $ 5,539,81A $ 5,553,794
CAPITAL IMPROVEMENT BUDGET 99,066,592 327,916,537 325,125,792 276,506,326 242,547,052 253,697,248
COST OF DEBT ISSUANCE - 520,000 438,562 867,200 653,000 341,000
DEBT SERVICES 14,708,698 16,728,778 20,747,227 22,318,087 24,300,569 26,392,445
TOTAL OTHER USES $ 119,995,255 $ 350,562,466 $351,708,732 305,859,448 $ 273,040,435 $ 285,984,487
TOTAL EXPENSE&OTHER USES $ 200,312,340 $ 459,498,164 $460,174,430 $ 420,480,027 $ 391,176,286 $ 406,975,806
EXCESS REVENUE AND OTHER
SOURCES OVER(UNDER)USES $ (45,957,290) $ (124,133,863) $ (10,292,536) 784,760 $ 4,347,431 $ (16,798,749)
OPERATING CASH BALANCES
BEGINNING JULY 1 $ 99,940,872 $ 72,333,355 $ 72,333,355 1 62,040,819 $ 62,825,579 $ 67,173,010
RESTRICTED/DESIGNATED $ 18,349,773 $ - $ - $ - $ - $ -
ENDING JUNE 30 $ 72,333,355 $ (51,800,508) $ 62,040,819 $ 62,825,579 $ 67,173,010 $ 50,374,261
Cash Reserve Ratio 90% -48% 57% 55% 57% 42%
Cash reserve goal above 14%
PUBLIC UTILITIES
COMBINED WATER, SEWER, STORMWATER,AND STREET LIGHTING CASH FLOW
FY 2022 BUDGET AND FY 2023-2026 FORECAST
ACTUAL PROJECTED BUDGET BUDGET B BUDGET
YEAR YEAR YEAR YE YEAR YEA
201i�n�
REVENUE
WATER SALES $ 76,257,075 $ 79,304,690 $ 85,462,346 $ 98,266,900 $ 112,990,800 $ 129,903,500 $ 142,874,900
SEWER CHARGES 43,864,526 50,215000 58,034,937 66740,000 73,414,000 80,755,000 88,831,000
STORMWATER FEES 10,424,070 9,740:500 10,714,550 12:321,733 13,553,906 14,909,297 14,909,297
STREET LIGHTING FEES 4,232,826 4,097,569 4,097,569 4,097,569 4,520,866 5,155,812 5,579,109
TOTAL SERVICES FEES AND CHARGES $ 134,778,497 $ 143,357,759 $ 158,309,402 $ 181,426,202 $ 204,479,572 $ 230,723,609 $ 252,194,306
OTHER INCOME $ 4,615,608 $ 5,109,6490 5,237,231 $ 5,237,231 $ 5,237,231 $ 5,237,231 $ 5,237,231
INTEREST INCOME 1,867,054 1,933,000 728,700 562,830 733,800 598,100 448,300
TOTAL OPERATING INCOME $ 141,261,159 $ 150,400,408 $ 164,275,333 $ 187,226,263 $ 210,450,603 $ 236,558,940 $ 257,879,837
OPERATING EXPENDITURES b,
OPERATING EXPENDITURES $ (80,317,085) $ (108,465,698) $ (114,620,579) $ (118,135,851) $ (120,991,319) $ (123,927,064) $ (126,945,531)
NET INCOME EXCLUDING DEP. $ 60,944,074 $ 41,934,710 $ 49,654,754 $ 69,090,412 $ 89,459,284 $ 112,631,876 $ 130,934,306
OTHER INCOME&EXPENSE
WIFIA LOAN $ - $ 93270,000 93,890,000 $ 70,465,000 $ 64,077,000 $ 24,356,000 $ 2,697,000
NET BOND PROCEEDS 797:500,000 155,125,000 130,000,000 _ 708,000,000 38,000,000 24,000,.000
BIC Borrowed 439,471 868,000 726,000 603,000 212,000 134,000
BIC Paid - (438,562) (867,200) (726,000) (603,000) (212,000) (134,000)
IMPACT FEES 4,710,332 3,511,006 3,595,670 3,595,670 3,595,670 3,595,670 3,595,670
OTHER CONTRIBUTIONS 8,083,450 4,665,749 3,454,284 3,454,284 3,454,284 3,454,284 4,037,461
SALE OF EQUIPMENT 300,109 155,260 56,500 56,500 56,500 56,500 56,500
CAPITAL OUTLAY (3,449,785) (3,747,151) (4,517,835) (3,889,814) (3,903,794) (3,918,053) (3,932,597)
WATERSHED PURCHASES (2,770,180) (1,650,000) (1,650,000) (1,650,000) (1,650,000) (1,650,000) (1,650,000)
STATE LOAND DEBT SERVICE (6,375,000) (2,125,000)
SHORT TERM FINANCING DEBT SERVICE
DEBT SERVICE (8,333,698) (18,622,227) (18,235,087) (18,236,569) (18,310,445) (18,418,527) (18,415,120)
NEW DEBT SERVICE - (4,083,000) (5,991,000) (7,820,000) (12,888,000) (16,859,000)
OTHER INCOME&EXPENSE $ (7,834,772) $ 272,898,546 $ 227,636,332 $ 177,804,071 $ 147,439,215 $ 32,587,874 $ (6,470,086)
CAPITAL GENEARATION
GENERATED FOR CAPITAL $ �109,302 $ ,256 $ 277,291,086 $ 246,894,483 $ 236,898,499 $ MMIFA,220
CAPITAL IMPROVEMENTS
CAPITAL IMPROVEMENTS $ (99,066,592) $ (325,125,792) $ (276,506,326) $ (242,547,052) $ (253,697,248) $ (162,106,203) $ (105,972,000)
OPERATING CASH BALANCES
BEGINING CASH BALANCE $ 99,940,872 $ 72,333,355 $ 62,040,819 $ 62,825,579 $ 67,173,010 $ 50,374,261 $ 33,487,808
CASH INCREASE/(DECREASE) (45,957,290) (10,292,536) 784,760 4,347,431 (16,798,749) (16,886,453) 18,492,220
RESTRICTED/DESIGNATED 18,349,773 - - - - -
ENDING BALANCES ' 72,333,355 $ 62,040,819 $ 62,825,579 $ 67,173,010 $ 50,374,261 $ 33,487,808 $ 51,980,028
CASH RESERVE RATIO 90.1% 57.2% 54.8% 56.9% 41.6% 27.0% 40.9%
DEBT SERVICE COVERAGE 4.14 2.02 2.22 2.85 3.42 3.60 3.71
%CHANGE RESIDENTIAL UTILITY BILL" 3.8% 10.2% 14.3% 13.3% 1 3.5% 9.3%
DEBT SERVICE%OF GROSS OPERATING REVENUE 5.6% 12.3% 13.5% 12.9% 12.4% 13.2% 13.6%
RESIDENTIAL UTILITY BILL 70.25 72.93 80.38 91.89 104.10 118.17 129.16
Residential Utility Bill assumes annual water consumption of 255 ccf/12 months,4 ccf monthly of sewer,1 Stormwater ERU(.25 acres)monthly,and 1 Street Lighting ERU(75 feet)monthly.
23
I:\AcagEzcel\BUDGET\Badger 2022\Cash Flow Alternatives\SLCM 2022 DRAFT Cashflow Combined.xlsx
PUBLIC UTILITIES
FEES AND CHARGES PAID TO THE GENERAL FUND
FOR SERVICES RENDERED
OR COLLECTED BY CITY ORDINANCE
JUNE 30,2020 JUNE 30,2020 JUNE 30,2020 JUNE 30,2020 FY 2021/2022
11WACTUALS ACTUALS JUNE 30,2020 ACTUALS STREET ACTUALS FY 2020/2021 PROPOSED
DESCRIPTION OF SERVICES WATER SEWER ACTUALS STORM LIGHT TO-Ls- BUDGET j' BUDGET
ADMINISTRATIVE SERVICE FEES(GENERAL FUND) j
HUMAN RESOURCES $ 236,838 $ 170,406 $ 49,622 $ 2,493 $ 459,359 $ 481,740 j $ 495,756
CITY ATTORNEY 161,744 37,721 10,859 1,715 212039 222,370% 228,830
ACCOUNTING/FINANCE 160,854 95,464 25,311 7,660 289:289 303380% 312,200
PURCHASING&CONTRACTS 71,358 65,375 10,056 2,813 149,602 156:890% 161,450
CITY RECORDERS 67,996 20,944 11,894 3,254 104,088 109,160% 112,330
PROPERTY MANAGEMENT - - - - -
BUDGET AND POLICY 43,303 28,674 13,933 5,336 91,246 95,690% 98,470
NON-DISCRETIONARY IMS COSTS 43,609 22,698 11,822 1,156 79,285 83150% 85,570
CITY TREASURER'S
OFFICE(CASH MGT.) 55,175 15,875 13,916 11,454 96,420 101:120 j 104,060
MAYOR - - - - - -
COMMUNITY AFFAIRS 1,045 193 193 193 1,624 1,700 1,750
TOTAL ADMINISTRATIVE FEES $ 841,922 $ 457,350 $ 147,606 $ 36,074 $ 1,482,952 $ 1,555,200 $ 1,600,416
TAX OR FEE AUTHORIZED
PAYMENT IN LIEU-OF-TAXES (GENERAL FUND) $ 365,000 $ 661,263 $ 100,434 $ $ 1,126,697 $ 1,319,188 $ 1,413,775
FRANCHISE FEES (GENERAL FUND) 2,097,350 2,455,601 453,359 5,006,310 5,887,831 7,808,965
TOTAL TAX OR FEE AUTHORIZED $ 2,462,350 $ 3,1 16,864 $ 553,793 $ $ 6,133,007 $ 7,207,019 j $ 9,222,740
INTERNAL SERVICE FUND SERVICES
FLEET MGT.SERVICES $ 1005,504 $ 415,753 $ 233,808 $ $ 1,655,066 $ 2,008,050 // $ 2,005,500
CITY DATA PROCESSING (IMS) 1:463,176 611,351 472,952 1,791 2,549,270 2,503,000 4,332,073
TELEPHONE CHARGES - - - - - 2,000 2,000
RISK MGT.ADMININSTRATIVE FEES(GOV.IMMUNITY) 153,007 7,641 28,831 260 189,739 222,250 j 272,250
RISK MANAGEMENT PREMIUMS&CHARGES 799,517 45,793 39,910 885,220 1,690,750 j 1,676,550
TOTAL INTERNAL SERVICE FUND SERVICES $ 3,421,204 $ 1,080,539 $ 775,501 $ 2,051 $ 5,279,295 $ 6,426,050 j $ 8,288,373
SPECIAL
IATED CHARGES(INDIRECT BENEFIT)
ONESOLUTSONCMAINTENANCE(NETWORK FINANCIAL SYSTEM) $ - $ - $ - $ - $ - $ 14,000 j $ 14,000
STREET SWEEPING CY MOD CLEAN-UP
819,605 819,605 819,605 j 819,605
NEIGHBORHOOD
EMERGE
TOTAL SPECIAL ASSOCIATED CHARGES $ - $ - $ 819,605 $ - $ 819,605 $ 833,605 $ 833,605
TOTAL FEES,TAXES AND CHARGES $ 6,725,476 $ 4,654,752 $ 2,296,505 $ 38,125 $ 13,714,859 $ 16,021,874 j $ 19,945,134
24
Public Utilities Proposed Consulting Studies for FY 2021-2022
Division Cost Center Study or Project Description Lighting Water Sewer Storm Total
Administration 5100200 Special Consultant-Canal Loss Study 30,000 30,000
Administration 5103000 Special Consultant 12,000 12,000
Administration 5103300 Process Improvement split 50:50 with Development Review 50,000 50,000
Administration 5100200 Special Consultant NAWC and DNR Cloud Seeding 80,000 80,000
Administration 5100200 Special Consultant-University of Utah Climate Study 195,000 195,000
Administration 5103600 Artificial Turf Study-impacts to landscape plant water need.Partnership with L 20,000 20,000
Administration 5103600 Golf Course Turf Study.Partnership with USU and USDA. 25,000 1 25,000
Administration 4848000 Implementation plan,and Misc.Needs 90,000 90,000
Administration 4848000 Engagement 80,000 80,000
Administration 4848000 Rate Study 50,000 50,000
Administration 5100200 Special Consultant-Measurement and Device Study 50,000 50,000
Administration 5100200 Water Banking Opportunities Study 75,000 75,000
Administration 4848000 Smart Cities Plan-Contribution 40,000 40,000
Administration 5100200 Sustainability Opportunities Study for Public Utilities 50,000 50,000
Engineering 5101300 AMP for Storage Reservoirs 135,000 135,000
Engineering 5210400 Jacobs Program Support 300,000 300,000
Engineering 5310300 Storm Water Master Plan 700,000 700,000
Engineering 5310300 Jacobs Program Support 75,000 75,000
Engineering 5101300 Jacobs Program Support 300,000 300,000
Engineering 5101300 Well Siting Study 286,000 286,000
Finance 5310500 Energy Retro-Commissioning Study 35,000 1 35,000
Finance 5103200 Special Consultant 500,000 500,000
Finance 5211700 Energy Retro-Commissioning Study 1 55,000 55,000
Finance 5103200 Space Needs Assessment 75,000 75,000
Finance 5211700 Space Needs Assessment 37,500 37,500
Finance 5310500 Space Needs Assessment 37,500 37,500
GIS 5101600 Special Consultant 37,500 37,500
Maintenance 5100100 Material removal 60,000 60,000
Maintenance 5100300 Consultants-Wells 100,000 1 100,000
Maintenance 5100100 Geotech Consultants 50,000 50,000
Reclamation 5211300 Wasatch Front Water Quality Council(WFWQC) 150,000 150,000
Reclamation 5212400 Molybdenum Pollution Sewer Collection Investigation. 100,000 100,000
Reclamation 5211300 North West Drainage Canal Flow Study 100,000 100,000
Water Quality 5101800 Public Relations 10,000 10,000
Water Quality 5101800 Utah State University Canal Analysis 35,300 35,300
Water Quality 5101800 Water Quality Analysis-Various 70,000 70,000
Water Quality 5100600 Watershed Management Plan 50,000 1 50,000
Water Quality 5100600 Misc Needs 10,000 10,000
Water Quality 5100600 PR Keep it Pure Campaign-Continuous work 50,000 1 50,000
Water Quality 5310700 Various regulatory reports-permit compliance Stormwater 10,000 10,000
Water Quality 5100600 PMAA Remediation and Restoration Design 500,000 500,000
Water Quality 5310700 IWM-Plan and Planning Documents 137,000 137,000
Water Quality 5310700 SAW QA QC 10,000 10,000
Water Quality 5310700 IWM-Stakeholder Engagement 12,500 12,500
Water Quality 5101000 1 Lead&Copper Support 250,000 250,000
Water Quality 5100600 lWatershed Management Plan-Stakeholder and public engagement 30,000 30,000
260,000 1 3,135,800 1 742,500 1,017,000 5,155,300
25
This page left intentionally blank.
26
Water Utility-Budget Summary and Cash Flow
27
WATER UTILITY BUDGET SUMMARY
FY 2022-24
Rate Increase Rate Increase Rate Increase
8% 15% 15%
AMENDED PROJECTED MPROPOSED FORECAST FORECAST
ACTUAL BUDGET ACTUAL BUDGET BUDGET BUDGET
2019-20 2020-21 2020-21 2021-22 2022-23 2023-24
REVENUE&OTHER SOURCES
REVENUES
METERED SALES $ 76,257,075 $ 69,61 2,308 $ 79,304,690 $ 85,462,346 $ 98,266,900 $112,990,800
INTEREST INCOME 583,230 715,896 715,896 398,000 184,530 165,000
OTHER REVENUES 4,197,718 4,530,048 4,530,048 4,762,372 4,762,372 4,762,372
TOTAL REVENUES $ 81,038,023 $ 74,858,252 $ 84,550,634 $ 90,622,718 $103,213,802 $117,918,172
OTHER SOURCES
GRANTS&OTHER RELATED REVENUES $ 2,562,909 $ 2,533,356 $ 2,533,356 $ 1,953,620 $ 1,953,620 $ 1,953,620
IMPACT FEES 2,521,760 1,184,670 1,338,448 1,784,670 1,784,670 1,784,670
SALE OF EQUIPMENT 125,034 135,260 135,260 40,500 40,500 40,500
OTHER SOURCES - - - - - -
BOND PROCEEDS - 42,235,000 77,1 29,992 26,146,000 42,235,000 62,346,000
TOTAL OTHER SOURCES $ 5,209,703 $ 46,088,286 $ 81,1 37,056 $ 29,924,790 $ 46,013,790 $ 66,1 24,790
TOTAL REVENUE&SOURCES $ 86,247,726 $120,946,538 $165,687,690 $ 120,547,508 $149,227,592 $184,042,962
EXPENSES&OTHER USES
EXPENDITURES
PERSONNEL SERVICES $ 21,571,541 $ 25,774,546 $ 25,774,546 $ 28,272,052 $ 29,120,215 $ 29,993,822
OPERATING&MAINTENANCE 3,731,042 4,806,680 4,806,680 4,839,903 4,936,702 5,035,437
TRAVEL&TRAINING 46,251 179,100 179,100 180,800 184,417 188,106
UTILITIES 1,251,633 2,845,999 2,845,999 2,857,150 2,914,294 2,972,580
TECHNICAL SERVICES 2,493,855 11,117,403 11,117,403 10,908,535 11,626,706 11,859,240
IMS SERVICES 1,463,176 1,408,000 1,408,000 2,486,100 2,535,822 2,586,538
FLEET MAINTENANCE 1,005,504 1,250,500 1,250,500 1,250,500 1,275,510 1,301,020
ADMINISTRATIVE SERVICE FEE 841,922 867,200 867,200 893,216 911,080 929,302
PAYMENT IN LIEU OF TAXES 365,000 385,780 385,780 428,864 437,441 446,190
METRO.WATER PURCH&TREAT 15,668,662 16,474,663 16,474,663 16,969,000 17,308,380 17,654,548
METRO ASSESSMENT(CAPITAL) 7,021,892 7,866,1 15 7,866,1 15 7,866,115 7,866,1 15 7,866,115
RISK MANAGEMENT 626,046 1,444,950 1,444,950 1,481,750 1,511,385 1,541,613
TRANSFERS TO GENERAL FUND - 10,000 10,000 10,000 10,200 10,404
OTHER CHARGES AND SERVICES (556,896) (272,628) (272,628) (68,194) (69,558) (70,948)
TOTAL EXPENDITURES $ 55,529,628 $ 74,158,308 $ 74,158,308 $ 78,375,791 $ 80,568,709 $ 82,313,967
OTHER USES
CAPITAL OUTLAY $ 4,109,586 $ 3,820,671 $ 3,820,671 $ 4,622,835 $ 4,622,835 $ 4,622,835
CAPITAL IMPROVEMENT BUDGET 30,538,705 82,050,006 82,050,006 39,600,000 68,462,800 88,923,500
COST OF DEBT ISSUANCE - 235,000 129,992 146,000 162,000 84,000
DEBT SERVICES 1,138,500 2,650,774 4,870,922 4,620,929 5,920,053 7,991,385
TOTAL OTHER USES $ 35,786,791 $ 88,756,451 $ 90,871,591 $ 48,989,764 $ 79,167,688 $101,621,720
TOTAL EXPENSE&OTHER USES $ 91,316,419 $162,914,759 $165,029,899 $ 127,365,555 $159,736,397 $183,935,687
EXCESS REVENUE AND OTHER
SOURCES OVER(UNDER)USES ($5,068,693) ($41,968,221) $657,791 ($6,818,047) ($10,508,805) $107,275
OPERATING CASH BALANCES
BEGINNING JULY 1 $ 23,684,887 $ 28,197,285 $ 28,197,285 $ 28,855,076 $ 22,037,029 $ 11,528,224
RESTRICTED/DESIGNATED 9,581,091 $ - $ - $ - $ - $ -
AVAILABLE JUNE 30 $ 28,197,285 $ (13,770,936) $ 28,855,076 $ 22,037,029 $ 11,528,224 $ 11,635,499
Cash Reserve Ratio 51% -1 9% 39% 28% 14% 14%
28 Gash reserve goal above 14%
WATER UTILITY CASH FLOW
FY 2022 BUDGET/FY 2023-2026 FORECAST
BUDGET BUDGET BUDGE UD BUDG
YEAR YEAR YEA YEA YEA
2021-2022 2022-2023
REVENUE
WATER SALES $ 76,257,075 $ 79,304,690 �$ 85,462,346 $ 98,266,900 $ 112,990,800 $ 129,903,500 $ 142,874,900
OTHER INCOME 4,197,718 4,530,048 4,762,372 4,762,372 4,762,372 4,762,372 4,762,372
INTEREST INCOME 583,230 715,896 398,000 184,530 165,000 165,000 165,000
OPERATING INCOME $ 81,038,023 $ 84,550,634 $ 90,622,718 $ 103,213,802 $ 117,918,172 $ 134,830,872 $ 147,802,272
OPERATING EXPENDITURES
METROPOLITAN WATER ASSESSMENT $ (7,021,892) $ (7,866,1 15) $ (7,866,115) $ (7,866,1 15) $ (7,866,115) $ (7,866,1 15) $ (7,866,115)
METROPOLITAN WATER PURCHASES (15,668,662) (16,474,663)M (16,474,663) (16,804,156) (17,140,239) (17,483,044) (17,832,705)
OPERATING EXPENDITURES (32,839,074) (49,817,530) (54,035,013) (55,898,438) (57,307,613) (58,753,706) (60,237,715)
TOTAL OPERATING EXPENSES $ (55,529,628) $ (74,158,308) $ (78,375,791) $ (80,568,709) $ (82,313,967) $ (84,102,865) $ (85,936,535)
NET INCOME EXCLUDING DEP. $ 25,508,395 $ 10,392,326 $ 12,246,927 $ 22,645,093 $ 35,604,205 $ 50,728,007 $ 61,865,737
OTHER INCOME&EXPENSE
NET BOND PROCEEDS $ - $ 77,000,000 $ 26,000,000 $ 42,000,000 $ 62,000,000 $ 38,000,000 $ 24,000,000
BIC Borrowed 129,992 146,000 235,000 346,000 212,000 134,000
BIC Paid (129,992) (146,000) (235,000) (346,000) (212,000) (134,000)
SHORT TERM FINANCING - - - - - - -
IMPACT FEES 2,521,760 1,338,448 1,784,670 1,784,670 1,784,670 1,784,670 1,784,670
OTHER CONTRIBUTIONS 2,562,909 2,533,356 1,953,620 1,953,620 1,953,620 1,953,620 1,953,620
SALE OF EQUIPMENT 125,034 135,260 40,500 40,500 40,500 40,500 40,500
CAPITAL OUTLAY (1,339,406) (2,170,671) (2,972,835) (2,972,835) (2,972,835) (2,972,835) (2,972,835)
WATERSHED AND WATER RIGHTS PURCHASES (2,770,180) (1,650,000) (1,650,000) (1,650,000) (1,650,000) (1,650,000) (1,650,000)
DEBT SERVICE (1,138,500) (4,870,922) (3,944,929) (3,944,053) (3,997,385) (4,076,541) (4,076,541)
NEW DEBT SERVICE - (676,000) (1,903,000) (3,732,000) (5,676,000) (7,519,000)
OTHER INCOME&EXPENSE $ (38,383) $ 72,315,471 $ 20,535,026 $ 35,308,902 $ 53,426,570 $ 27,403,414 $ 11,560,414
CAPITAL GENERATION
GENERATED FOR CAPITAL $ 25,470,072 $ 82,707,797 $ 32,781,953 $ 57,953,995 $ 89,030,775 $ 78,737,427 $ 73,426,757
CAPITAL IMPROVEMENTS
CAPITAL IMPROVEMENTS $ (30,538,705) $ (82,050,006) $ (39,600,000) $ (68,462,800) $ (88,923,500) $ (77,588,600) $ (73,147,000)
OPERATING CASH BALANCES
BEGINING CASH BALANCE $ 23,684,887 $ 28,197,285 $ 28,855,076 $ 22,037,029 $ 11,528,224 $ 11,635,499 $ 12,178,320
CASH INCREASE/(DECREASE) (5,068,693) 657,791 (6,818,047) (10,508,805) 107,275 542,821 279,151
RESTRICTED/DESIGNATED 9,581,091 - - - - - -
ENDING CASH AVAILABLE $ 28,197,285 $ 28,855,076 $ 22,037,029 $ 11,528,224 $ 11,635,499 $ 12,178,320 $ 12,457,471
DEBT SERVICE COVERAGE 22.41 2.13 2.65 3.87 4.61 5.20 5.34
RATE CHANGE 5% AL 0% 8% 15% 15% 15% 10%
Cash Reserve Ratio(Total Cash) 51% 39% 28% 14% 14% 14% 14%
DEBT SERVICE%OF GROSS OPERATING REVENUE 1% 6% 5% 5% 6% 7% 80
MONTHLY RESIDENTIAL BILL(255 ccf annually/12 mos.) 46.41 46.41 50.15 57.68 66.34 76.30 83.93
29
51 2022 HYBRID 8%DRAFT C-hfl—Wate-1-
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
O O
z z
� F
CAP K w BUDGET
COSTCENTER PROJECT REQUEST PROJECT DESCRIPTION z YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q 2020-21
U
F
K
U
01301 513505272 2016-1233 WATER MAIN REPLACEMENT-900 SOUTH 5 5
013011 513505273 2016-0744 1300 EAST-WATER LINE 3 4 + 200,000 2,000,000
01301 513505312 2015-0431 CITY/COUNTY/STATE DRIVEN PROJECTS 5 5 250,000. 250,000 250,000 250,000 250,000
01301 2016-1264 NW QUADRANT(DEVELOPMENT)PIPE UPSIZE 5 5 1,400,000
01301 513600099 2017-2056 ENERGY EFFICIENCY/RENEWABLE ENERGY CAPITAL IMPROVEMENTS 5 5 1,500,000
01301 ROADWAY BOND WATERLINE PROJECT CONTINGENCY 250,000
01301 513505308 2015-0398 UPPER CONDUIT METER REPLACEMENT 4 5
01301 513600097 2017-2014 MOTORS AT WORK 4 4
01301 513505230 2015-0245 EAST INDIANA AVENUE(850 SOUTH)-REDWOOD RD TO SURPLUS 3 5
01301 513505332 CITY CREEK WATER MAIN VAULT REMOVAL
01301 AW IA RISK ASSESSMENT EMERGENCY MANAGEMENT PLAN
01301 514400106 2018-1081 STATE IPS RESOLUTIONS 4 4 20,000 150,000
01301 513505334 STATE"BETTERMENT"PROJECT,WATER LINE CROSSING 5600 WEST AT 1100 SOUTH
01301 STATE 1100 SOUTH,5600 WEST TO LEGACY VIEW(ABOUT 5700 W)
01301 513505398 2019-1179 0 SOUTH-REDWOOD ROAD TO 2700 WES 1,250,000
01301 700 WEST-1600 SOUTH TO 2100 SOUTH
01301 513505396 2019-1093 LOCAL STREET DISTRICT 1&7
01301 800 WEST-600 SOUTH TO 800 SOUTH 350,000
01301 "2019-1096
EAST- 1700 SOUTH TO 2100 SOUTH
013010 EAST-PARLEY'S TO CITY LIMIT
013010 EAST-W ILMINGTON TO PARLEYS CANYON
01301 5135SOUTH-900 WEST TO 900 EAST 2,500,000
01301 5135 WEST-900 SOUTH TO 2100 SOUTH 1,250,000 1,300,000
01301 513505411 2020-1033 LOCAL STREETS DISTRICT 3&6 1,000,000
01301 513505414 2020-1037 900 EAST- HOLLYWOOD TO 2700 SOUTH 500,000
01301 513505415 2020-1038 100 SOUTH-NORTH CAMPUS DRIVE TO 900 EAST 750,000
01301 1700 EAST-1700 SOUTH TO 2700 SOUTH
01301 LOCAL STREETS DISTRICTS 2&5
01301 200 SOUTH-400 WEST TO 900 EAST
01301 1100 EAST HIGHLAND,RAMONA TO WARNOCK 1,000,000
01301 LOCAL STREETS DISTRICT 4&7 200,000
01301 1100 EAST-900 SOUTH TO RAMONA 400,000 4,000,000
01301 300 NORTH-300 WEST TO 1000 WEST 1,500,000
01301 W TEMPLE-NORTH TEMPLE TO 400 SOUTH 800,000
01301 LOCAL STREETS 3&6 200,000
01301 VIRGINIA STREET-SOUTH TEMPLE TO 11TH AVE 100,000
01301 1300 EAST-2100 SOUTH TO 3000 SOUTH 700,000
01301 513505409 2018-1079 2100 SOUTH-700 EAST TO 1700 EAST 3 4 1,800,000
01301 LOCAL STREETS DISTRICT 1,4 &5 200,000
01301 GLADIOLA STREET-900 SOUTH TO CALIFORNIA 50,000
01301 300 WEST-400 SOUTH TO 900 SOUTH 2,000,000
01301 WAKARA WAY-FOOTHILL DRIVE TO CHIPETA WAY 150,000
$ 7,270,000 $ 3,400,000 $ 7,150,000 $ 4,200,000 $ 2,250,000 $ 250,000 $ 5,450,000
WATER MAIN MISCELLANEOUS PROJECTS
EMERGENCY REPAIRS 200,000 500,000 500,000 500,000 500,000 500,000
01301 514500020 2015-0491 REGULATOR REPLACEMENT 5 5 200,000 200,000 200,000 200,000 200,000 300,000
01301 513302118 2015-0493 NEW MAINLINE VALVES-COUNTY 5 5 135,000 135,000 135,000 135,000 135,000 138,000
01301 513505311 2015-0489 NEW WATER LINES-CONTRIBUTIONS BY DEVELOPERS 5 5 500,000 50,000 50,000 50,000 50,000 50,000
01301 513505310 2015-0490 FIRE HYDRANT REPLACEMENTS 5 5 400,000 250,000 250,000 250,000 250,000 400,000
01301 513505309 2015-0492 NEW MAINLINE VALVES-CITY 5 5 250,000 250,000 250,000 250,000 250,000 262,000
01301 513505304 2018-1002 UPPER CONUIT-LINE SYPHON 5 4
30
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
O O
z z
� F
CAP K BUDGET
COST CENTER PROJECT REQUEST PROJECT DESCRIPTION zz YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q 2020-21
U
F
K
U
01301 2015-0554 SOUTH TEMPLE 1000 W.(GADSBY LINE) 5 3
01301 513505198 2015-0237 GREGSON AVENUE-2465 EAST TO 2700 EAST 1 4 1 4 80,000
01301 513302089 2015-0238 2300 EAST-6200 SOUTH TO 6400 SOUTH 4 4 268,000
01301 513505202 2015-0246 420 N MAIN STREET-1"SERVICE REPLACEMENT-MAIN ST TO WALL ST 4 4 64,000
01301 513505125 2015-0260 WEST TEMPLE-500 SOUTH TO 800 SOUTH(EAST SIDE) 4 4 469,000
01301 513505127 2015-0262 1000 WEST11400 SOUTH WATER MAIN REPLACEMENT 4 4 560,000
01301 2017-2022 2880 SOUTH WATER MAIN REPLACEMENT 4 4 260,000
01301 513505197 2015-0236 800 SOUTH-1200 EAST TO 1220 EAST 3 5 134,000
01301 513302039 2015-0613 OAK CREEK DRIVE-8200 SOUTH TO END OF LINE 3 5 300,000
01301 513302045 2015-0616 MARDONNA WAY(3545 S)-SUNILAND DRIVE TO MILLSTREAM DRIVE 3 5 160,000 153,000
01301 513505128 2015-0620 WILTON WAY WATER MAIN REPLACEMENT 3 5 374,000
01301 513505129 2015-0621 1700 SOUTH-FOOTHILL TO WASATCH WATER MAIN REPLACEMENTS 3 5 257,000
01301 513505132 2015-0622 MILTON AVENUE(1595 SOUTH)-1100 EAST TO 1200 EAST 3 5 179,000
01301 2017-2066 2700 E DEAD-END CONNECTION 3 5 20,000
01301 2016-0738 RELOCATE 12"CIP MAIN FROM UNDER HOUSE(EAST BENCH SUCTION LINE 5 2 255,000
01301 513302090 2015-0239 COBBLECREST RD-6380 S TO 2300 E;HAUN AVE-2300 E TO COBBLECRES 4 3 411,000
01301 2015-0232 NORTH TEMPLE-1800 WEST TO REDWOOD ROAD 4 3 156,200
01301 513505155 2015-0241 WESTMINSTER AVENUE-LAURELHURST(2550 EAST)TO FOOTHILL BOULE 4 3 90,000
01301 513302038 2015-0258 BISCAYNE DR(2975 E)-BENGAL BLVD TO OAKVIEW CIR 4 3 158,000
01301 513505122 2015-0550 DUPONT AVE(1335 N)-AMERICAN BEAUTY DR TO 990 W 4 3 115,000
01301 2016-1228 REPLACE PRV'S-R11 AND R12 4 3 400,000
01301 513505205 2015-0249 SCOTT AVENUE-700 EAST TO SCOTT PARK LANE 3 4 105,000
01301 2015-0400 R37.MAYWOOD REGULATOR 3 4 150,000
01301 513505134 2015-0625 BRYAN AVENUE(1565 SOUTH)-900 EAST TO 1000 EAST 3 4 172,000
01301 2016-0889 CR1 PRV 3 4 225,000
01301 2016-0890 CR2 PRV 3 4 225,000
01301 2016-0891 HYDRANT 3300 SOUTH 750 EAST E3-5H 3 4 40,000
01301 2016-0901 PRV E3-R49 REPLACEMENT 3 4 220,000
01301 2016-0910 HIGHLAND DRIVE REGULATORS 3 4 1,300,000
01301 2016-0912 R73 REPLACEMENT 3 4 200,000
01301 2016-09131 CUP REGULATORS 3 4 300,000
01301 2016-0918 2300 EAST-CLAYBOURNE TO 3300 SOUTH 3 4 200,000
01301 2016-0934 PRV AT 17TH 3 4 210,000
01301 2016-1169 J STREET PIPELINE AND PRV REPLACEMENT 3 4 300,000
01301 2016-1273 NEW WATER MAIN-1000 EAST 3 4 300,000
01301 2017-2062 ROXBURY PRV C46-R66 3 4 150,000
01301 2017-2065 CAMILLE ST.DEAD-END CONNECTION 3 4 20,000
01301 2016-1283 SUICIDE ROCK RUNAROUND 2 5 25,000
01301 513302117 2017-2069 CAP STUB AT 6200 SOUTH HOLLADAY BOULEVARD 3 3
01301 513505124 2015-0619 BUCCANEER DRIVE WATER MAIN REPLACEMENT 3 3 151,000
01301 2016-0748 WATER VALVE REPLACEMENT PROJECT#3 2 4 100,000
01301 513505199 2015-0242 700 EAST-DRIGGS AVE(2370 S)TO WARNOCK AVE(2470 S) 1 5 257,000
01301 2015-0256 900 EAST HILLVIEW(4060 SOUTH)-REPLACE DIP MAIN UNDER SEWER 1 5 36,000
01301 2016-0756 300 WEST-700 S TO 800 S 1 5 175,000
01301 2016-0892 KEARNS LINE REPLACEMENT 3 3 8,000,000
01301 2016-0900 R48 VALVE 3 3 220,000
01301 2016-0906 6-INCH ON 9TH 3 3 450,000
01301 2016-0915 SMITHS CONNECTION 3 3 70,000
01301 2016-0916 COUNTRY CLUB PRV 3 3 250,000
01301 2016-0933 MAYWOOD 6-INCH 3 3 220,000
01301 2016-0936 16-INCH VALVE VAULT 3 3 65,000
01301 2016-1222 PRV REPLACEMENT-A8-14 3 3 200,000
01301 2016-1231 NEW PRV-R73 3 3 201000
31
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
O O
z z
� F
CAP K BUDGET
COST CENTER PROJECT REQUEST PROJECT DESCRIPTION zz YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q 2020-21
U a
F z
O
U U
51-01301-2720.10 MAINTENANCE&REPAIR SHOPS
01401 2015-0460 DISTRIBUTION AND ELECTRICAL BARN 4 4 850,000
CAMPUS 5 5 75,000,000
03201 512185 FUEL PUMP AWNINGS 5 0 250,000
$ - $ - $ - $ - $ - $ - $ 76,100,000
51-01301-2720.30 TREATMENT PLANTS
CITY CREEK
00701 512260079 2017-2043MILATMENT PLANT UPGRADES 5 5 600,000 1,750,00 3,980,000 3,980,000 3,980,000
00701 2019-1001109 CREEK WTP UPGRADES-PHASE 2 A 5 3 51,200,000
00701 512260081 2019-1136 SCADA SYSTEM UPGRADES 5 5 1,250,000 250,000
00701 512260083 2020-1010 CITY CREEK FILTER MEDIA REPLACEMENT 5 4 2,500,000
00701 512260082 2020-1024 GREY WATERLINE ALONG CREEKSIDE 4 5 50,000 50,000
00701 2020-1185 CCWTP RAILING REPLACEMENT&TOUR PATH IMPROVEMENTS 5 4 pr 250,000
$ 4,400,000 $ 2,050,0001$ 4,230,000 $ 3,980,000 $ 3,980,000 $ - $ 51,200,000
PARLEY'S
00801 512450068 PLANT DESIGN AND UPGRADES PKG 2 5 3/415 1,600,000 750,000 350,000 350,000
00801 512450069 2015-0594 BACK-UP WATER SUPPLY FOR HIGH PRESSURE TANK 5 3
00801 512450068 2015-0701 PLANT DESIGN AND UPGRADES PIG 3(FUlkRE 5 4
00801 5124532 REPLACEMENT OF CHEMICAL FEED PUMPS PARLEY'S CANYON
00801 5124526 2015-0455 INFLUENT CONTROL BOX 4 3
00801 512450066 2016-0867 ROOF REPLACEMENT 4 5
00801 512450067 2016-0874 REBUILD/REPLACE FLOC-SED BASIN VENTILATION SYSTEM 2 5
00801 2015-0450 PRECURSOR-TASTE AND ODOR CONTROL 3 3
00801 5124504 2015-0449 SLUDGE BEDS-PIPING AND VALVES 2 3
00801 2015-0197 ELECTRICAL CONDUITS/PAVING TO BLOW-OFF BOX/ASPHALT EAST A 3 3
00801 2015-0204 REPLACE FLOCCULATORS 4 4
00801 2017-2005 PROCESS UPGRADES(FROM SED BASIN PREDESIGN) 1 0
00801 2017-2006 VERTICAL FLOCCULATOR INSTALLATION 4 4 7,500,000
00801 512450076 2018-1037 PARLEYS DIVERSION SCREEN PROJECT 5 4 250,00 2,000,000
00801 2018-1095 PARLEYS FINISHED WATER RESERVOIR 3 0
00801 2018-1094 NEW PARLEYS WATER TREATMENT PLANT 5 4
00801 512450080 2019-1188 PARLEYS ACCESS CONTROL 500,000
00801 2020-1103 PWTP SANITARY SURVEY RELATED IMPROVEMENTS 5 5 30
00801 2020-1136 PWTP PRIORITY IMPROVEMENTS(PKG4) 5 5 3,500,000 3,500,000
00801 2020-1183 RAW WATER INTAKE/DISSIPATION 5 4 3,750,000 3,750,000
00801 2020-1179 CHEMICAL BUILDING 5 4 14,000,000
00801 2020-1181 ELECTRICAL&SCADA SYSTEM UPGRADES 5 4 10,000,000
00801 2020-11821 FILTER REHAB 4 4 15,000,000
00801 FILTER REBUILD,FINISHED WATER RESERVOIR&OPERATIONS BUILDING 4 4 75,000,000
00801 2020-1184 PWTP STILLING TOWER AND BASIN REBUILD 5 4 1,875,000
00801 2020-1180 CLARIFIER AND CLARIFIER PUMP STATION REBUILE 4 4 3,000,000
00801 2020-1189 PAC STORAGE AND FEED 1,500,000
00801 2020-1177 PWTP HYPO TANKS 1&2 IMPROVEMENTS 5 5
00801 2020-1187 PWTP HYPO TANKS 3&4 IMPROVEMENTS 5 4 100,000
00801 2020-1186 PWTP ROOFING PROJECT 2 4 1,000,000
$ 2,100,000 $ 1,300,0001$ 9,700,000 $ 7,600,000 $ - $ 1,000,000 $ 127,875,000
32
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
O O
z z
� F
CAP K BUDGET
COST CENTER PROJECT REQUEST PROJECT DESCRIPTION zz YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q 2020-21
U a
F z
O
U U
BIG COTTONWOOD
00901 51262759 2015-0186 SCADA MASTER PLAN/OPERATOR STATION UPGRADE IMPLEMENTATION
00901 512627471 2019-1002 BIG COTTONWOOD WTP REBUILD- DESIGN 5 4
00901 512627474 2020-1032 BIG COTTONWOOD WTP REBUILD-ALTERNATIVES ANALYSIS 4 4 550,000 250,000
00901 512627476 BIG COTTONWOOD WTP REBUILD CONSULTANT 5 4 2,200,000 7,000,000 7,000,000 5,000,000 5,000,000 4,600,000
00901 2020-1075 BIG COTTONWOOD WTP REBUILD PUBLIC ENGAGEMENT 5 4 300,000 300,000 300,000 300,000 300,000 600,000
00901 2020-1134 BIG COTTONWOOD WTP REBUILD CM/GC(PRE-CONSTRUCTION) 5 4 850,000 3,500,000
00901 2020-1135 BIG COTTONWOOD WTP REBUILD-CONSTRUCTION 5 4 36,000,000 36,000,000 36,000,000 72,000,000
00901 512627473 2018-10991 FILTER ASSESSMENT AND IMPROVEMENTS 5 4
00901 2015-0191 ASPHALT LOWER END OF BUILDING TO DRYING BEDS 3 0 200,000
00901 2018-1030 BIG COTTONWOOD SOLIDS SYSTEM UPGRADE 5 3 4,000,000
00901 2015-0188 FINISHED WATER FLOW METER AND SAMPLE POINT 5 4 1,030,000
00901 2020-1160 BCWTP SECURITY CONTROLS AND ACCESS IMPROVEMENTS 5 4 250,000
00901 2020-1104 BCWTP SANITARY SURVEY RELATED IMPROVEMENTS 5 5 150,000
$ 550,000 $ 4,000,000 $ 10,800,000 $ 43,300,000 $ 41,300,000 $ 41,300,000 $ 82,430,000
TOTAL TREATMENT PLANTS $ 7,050,000 $ 7,350,000 $ 24,730,000 $ 54,880,000 $ 45,280,000 $ 42,300,000 $ 261,505,000
51-01301-2720.35 PUMPING PLANTS AND PUMP HOUSES
01301 513416331 EAST BENCH PUMP STATION-FULL BACKUP POWER 5 5
01301 513416373 2019-1178 CANYON COVE ROOF REPLACEMENT 80,000
01301 513416371 2016-1174 5TH AVE AND U ST PUMP STATION BACKUP POWER 5 5
01301 513416364 2016-1282 BONNEVILLE AND EAST BENCH PUMP STATION-PUMP UPGRADES 5 5
01301 513416365 2015-0514 NORTH BENCH PUMP STATION ROOF 4 5
01301 513505271 2015-0378 UPLAND DR PROJECT 4 5
01301 513800033 2015-0555 3900 SOUTH BIRCH DRIVE VALVE VAULT 4 4
01301 513416359 2016-0888 3900 SOUTH PUMP STATION 4 4
3900 SOUTH PUMP STATION PHASE 2-3900 SOUTH PUMP STATION&
01301 EDWARDS DRIVE 4 4 4,000,000
3900 SOUTH PUMP STATION PHASE 3-SUPPLY AND HIGH PRESSURE
01301 PIPELINES 4 4 6,000,000
01301 3900 SOUTH PUMP STATION PHASE 4-PUMP STATION CONNECTIONS 4 4 1,500,000
01301 513416366 2015-0531 GOLDEN HILLS PUMP STATION 3 5 200,000
01301 513416367 2016-1208 5TH AND U PUMP STATION IMPROVEMENTS 4 4 1,300,000
01301 513416361 2015-0563 OAKHILLS PUMP STATION-MCC-VFD-PUMP UPGRADE 3 3 550,000
01301 2016-0937 ENSIGN DOWNS PS VFD 3 3 50,000
01301 513416336 2015-0428 MP 3.12 B-7800 SOUTH AUXILIARY POWER 3 3 305,000
01301 2016-1179 300 EAST PUMP STATION BACKUP POWER 3 3 700,000
01301 2016-1180 3300 SOUTH BOOSTER PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1181 KENTON DRIVE PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1183 VIRGINIA AND MILLCREEK PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1184 EASTWOOD PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1185 MILLCREEK PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1186 39TH AND BIRCH PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1187 CANYON COVE PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1188 7800 SOUTH PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1189 GOLDEN HILLS PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1190 CARRIGAN COVE PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-11731 NORTH BENCH PUMP STATION BACKUP POWER 1 3 1 3 1 1 1 1 400,000
33
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
z z
� F
CAP K BUDGET
COSTCENTER PROJECT REQUEST PROJECT DESCRIPTION zz YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q 2020-21
U
F
K
U
01301 2016-1175 UNIVERSITY PUMP STATION BACKUP POWER 3 3 1 400,000
01301 2016-1176 RESEARCH PARK PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1177 OAK HILLS PUMP STATION BACKUP POWER 3 3 500,000
01301 2016-1178 BONNEVILLE PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1191 3900 SOUTH BOOSTER PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1192 6200 SOUTH IRRIGATION PUMP STATION BACKUP POWER 3 3 500,000
01301 2016-1193 EMIGRATION PUMP STATION BACKUP POWER 3 3 400,000
01301 2016-1223 5TH AVE AND U ST PUMP STATION VFD'S 3 3 200,000
01301 2016-1224 ARLINGTON HILLS PUMP STATION VFD'S 3 3 200,000
01301 2016-12251 NORTH BENCH PUMP STATION VFD'S 3 3 200,000
01301 2016-1226 5TH AVE AND U ST PUMP STATION PIPING 3 3 200,000
01301 2017-2009 REPAIR AND LINE OF UNIVERSITY DRAIN LINE 2 3 10,000
01301 2015-0517 4500 SOUTH PUMP STATION BLACK TOP 1 3 25,000
01301 2015-0522 RECURRING PUMP STATION REPAIR FUND 3 0 200,000
01301 513416329 2015-0169 UV UPGRADE 6200 SOUTH PUMP STATION 1 2 300,000
01301 2016-1194 ENSIGN DOWNS PUMP STATION BACKUP POWER 3 0 400,000
01301 2015-0172 MP 3.8C-VICTORY ROAD-ENSIGN DOWNS PHASE II-PROPERTY PURCHA 4 0 500,000
01301 2015-0173 4500 SOUTH PUMP STATION(BACK UP) 5 0 1,500,000
$ 80,000 $ 1,550,00 $ 10,550,000 $ 3,600,000 $ 2,705,000 $ 1,200,000 $ 6,135,000
51-01301-2730.02 CULVERTS FLUMES&BRIDGES
01301 5129264 JSL CANAL CONDUIT REPLACEMENT-SUGARHOUSE 5 5 1,300,000
01301 513000045 2016-1166 SUGARHOUSE WELL SPLASH PAD 5 5 150,000
01301 512900272 2015-0432 VARIOUS CANAL IMPROVEMENTS 5 5 25,000 25,000 25,000 25,000
01301 512900273 2016-0737 IRRIGATION SCADA IMPROVEMENTS 5 5 20,000 20,000 20,000
01301 2016-0816 ROCKHOUSE DUMP-INTAKE IMPROVEMENT 5 4 78,500
01301 513000034 2016-0858 FLUME FROM DOUBLE BARRELS TO RAILROAD TRACKS 4 4 1,000,000 1,500,000
01301 5129246 2015-0158 REPLACE FLUME/AUTO DUMP AND JSL CANAL ENCLOSURE @ MILLCREEK 4 4 468,000
01301 512900274 2017-2076 HEADGATE REHABILITATION 18/19 4 4 20,000 20,000 20,000
01301 513000026 2015-0161 E JORDAN TOWER-IMPROVED ACCESS 3 5 150,000
01301 512900278 2016-1167 6200 SOUTH LIFT STATION WEIR PROTECTION 3 5 250,000
01301 5129231 2015-0152 JSL CANAL-1750 S EMIGRATION DIVERSION STRUCTURE REBUILD 4 3 50,000 290,000
01301 5129233 2015-0604 JSL 3800 S REHAB FLOOR AND LEAKAGE 3 4 18,000
01301 5129251 2015-0151 JSL ENCLOSURE FROM 1300 EAST TO MILLCREEK 3 3 997,000 997,000
01301 2015-0168 IMPROVEMENTS TO JSL DUMP AT 1-80 3 3
01301 5129235 2015-0606 JSL 4500 SOUTH TO OSAGE ORANGE DRIVE-CANAL BANK HYDRAULICS 3 3
01301 5129249 2015-0149 NEW IRRIGATION CONDUIT ON HARVARD AVENUE 4 0 50,000 402,000
01301 513000038 2016-0865 OIL SEPARATORS AND DRAINAGE SYSTEM FOR THE ARTESIAN SHOP 4 0 1,200,000 1,300,000
01301 2016-1165 LOW FLOW CHANNEL AT SPENCER'S POND(BIG COTTONWOOD CREEK) 4 0 300,000
01301 2016-1284 1100 EAST DIVERSION STRUCTURE AT WILLINGTON 4 0
01301 5129232 2015-0602 JSL CANAL-MODIFY BIG SPILL TO HANDLE TEMPORARY PUMP 2 2 82,000
01301 2016-1287 STUDY ON WELLS AT WALKER LANE AND FOUNTAIN BEAU 1 3 1,000,000
01301 2016-07491 J&SL DIVERSION STRUCTURE AT 2700 SOUTH 2 0
01301 2016-1286 3000 EAST WELL FOR WATER DELIVERIES 2 0 2,000,000
01301 5129242 2015-0153 PIPING DITCH ON JSL,OSAGE ORANGE AVENUE TO LINCOLN LANE 1 0
01301 2015-0160 DESPAIN IRRIGATION SYSTEM IMPROVEMENTS 3 3 17,000
01301 2015-0603 JSL CANAL/JORDAN RIVER STABILIZATION AT EAST JORDAN DUMP 4 4 406,000
01301 2018-1019 14600 SO.CANAL OVER FLOW STRUTURE 3 3 500,000
01301 2018-1080 3900SO STORM DRAIN OVER FLOW 2 4 300,000
01301 2018-1082 LITTLE TANNER PIPE PROJECT 2 0 50,000
01301 REHABILITATION/REPLACEMENT OF JSL IN CITY LIMITS 50,000 400,000
34
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
O O
z z
� F
CAP BUDGET
COSTCENTER PROJECT REQUEST PROJECT DESCRIPTION z YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q 2020-21
U
F
$ 1,375,000 $ 1,533,000 $ 1,615,000 $ 1,395,500 $ 1490,000 $ 1,397,000 $ 6,720,000
51-01301-2730.04 DEEP PUMP WELLS
01301 2019-1184 BRINTON SPRINGS WELL IMPROVEMENTS 5 4 405,000
01301 51322336 2015-0171 WELL TREATMENT PROJECT-1500 EAST WELL 5 4 425,000 100,000
01301 513223429 WELL SANITARY SURVEY DEFICIENCIES 800,000
01301 2019-1185 EDGEWOOD WELL IMPROVEMENTS 400,000
01301 2019-1186 ELLISON WELL IMPROVEMENTS 400,000
01301 2019-1187 FONTAIN BLEU WELL IMPROVEMENTS 400,000
01301 5132245 2015-0429 WELL ASSESSMENT AND UPGRADES 5 5 200,000 200,000 200,000
01301 5132270 2015-0430 WELL BUILDING STRUCTURE UPGRADES 5 5 100,000 100,000 100,000
01301 DESIGN FOR NEW WELL SOURCE 250,000
01301 5132268 2015-0213 MP3.4-4TH AVENUE WELL ELECTRICAL IMPROVEMENTS 5 5 3,000,000
01301 5132269 2015-0212 MP3.4-4TH AVENUE WELLBRICK TANK IMPROVEMENTS 5 5
01301 2016-0820 DYERS INN 4 4 550,000
01301 2017-2071 DYER'S INN WELL FLUSH LINE 4 4 100,000
01301 2016-0911 1300 E WELL CHLORINATION 3 4 400,000
01301 2015-0408 1300 EAST WELL FLUSH LINE 2 2 95,000
01301 5132255 2015-0571 ARTESIAN WELL 2 REHAB 4 0 250,000
01301 5132249 2015-0565 19TH AND 27TH SOUTH WELL-VFD 3 0 60,000
01301 5132246 2015-0570 TREATMENT OF PCE AT WELLS 3 0 12,000,000
01301 5132241 2015-0569 RED BUTTE 2 0 2,500,000
01301 513223419 MT OLIVET IRRIGRATION FEASIBLITY STUDY
01301 2018-1038 4TH AVENUE WELL INSPECTION 4 2
01301 2018-1091 VAN WINKLE PROPERTY FENCE 1 5 20,000
$ 3,000,000 $ 1,630,001$ 745,000 $ 1,520,000 $ 300,000 $ 300,000 $ 15,560,000
51-01301-2730.06 STORAGE RESERVOIRS
MOUNTAIN DELL DAM
01301 5134506 MOUNTAIN DELL RESERVOIR SEDIMENT SAMPLING AND BASIN PRE 5 4
2017-1290 DESIGN
01301 5134458 2015-0155 REHABILITATION OF MOUNTAIN DELL DAM 5 4 1,700,000
01301 5124512 2015-0209 REPLACE VALVES ON MT.DELL DAM 4 4 750,000 320,000
01301 5124509 2015-0451 STAIRS MT DELL DAM 2 3 75,000
01301 512700015 2018-1106 MOUNTAIN DELL DAM SPILLWAY REHABILITATION 5 4 600,000 500,000
01301 512700023 MOUNTAIN DELL DAM REHABILITATION-REVEGATATION OF DISTURBED 4 5 250,000
AREAS
01301 512700022 MOUNTAIN DELL DAM REHABILITATION-RESERVOIR WATER 5 4 100,000
MANAGEMENT
01301 REHABILITATION OF MOUNTAIN DELL DAM-LOWER DAM 5 4 500,000
WATERPROOFING
01301 REHABILITATION OF MOUNTAIN DELL DAM-CONCRETE REPAIRS AND 5 4 250,000 750,000
MONITORING
TOTAL MOUNTAIN DELL $ 2,450,000 $ 1,420,000 $ 675,000 $ 500,000 $ 750,000 $ - $ -
LITTLE DELL DAM
01301 5134510 PARLEY'S DIVERSION STRUCTURE-IMPROVE BOOM DEPLOYMENT 5 3
LOCATION
01301 512450071 2017-2094 NEW ACTUATORS FOR THE PARLEYS CREEK DIVERSION STRUCTURE 5 0
01301 5134468 2015-0607 LITTLE DELL RESTORE PARLEY'S DIVERSION EXTERIOR COATING 4 4 40,000
01301 5134478 2015-0164 LITTLE DELL DAM -INSTALL NEW DRAINS ON THE PORTAL 3 3 60,000 27,000
01301 2016-1278 SECURITY CAMERAS AT LITTLE DELL 3 3 50,000 50,000
01301 5134457 2015-0166 NEW STAFF GAGE AT LITTLE DELL DAM 3 3 175,000 153,000
35
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
z z
� F
CAP K BUDGET
COSTCENTER PROJECT REQUEST PROJECT DESCRIPTION zz YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q - 2020-21
U
F
K
U
01301 2018-1107 LITTLE DELL DAM RODENT ERADICATION 4 4 30,000
01301 2020-1007/8 LITTLE DELL PENSTOCK AND DIVERSION WINTERIZATION 4 4 150,000
01301 2018-1108 LITTLE DELL DAM STAFF GAUGE 3 0 175,000
01301 LITTLE DELL DAM-ADIT PIPE COATING REPAIRS 5 4 40,000 160,000
01301 LITTLE DELL DAM-PORTAL WALL REPAIRS 5 4 100,000
01301 LITTLE DELL MOWER 5 4
01301 LITTLE DELL DAM-LIGHTING UPGRADE 5 4
01301 LITTLE DELL DAM-INSTRUMENT HOUSE ACCESS IMPROVEMENT 5 4
01301 LITTLE DELL DAM-INTRUMENTATION TELEMETRY UPGRADE 5 3
01301 LITTLE DELL DAM-BULKHEAD GATE EVALUATION AND REPAIR 5 5 20,000
01301 LITTLE DELL DAM-NEW ENTRANCE SECURITY GATE 5 3 40,000
TOTAL LITTLE DELL $ - $ 60,000 $ 450,000 $ 325,000 $ - $ - $ 435,000
PARLEYS CANYON
01301 5134476 CHEVRON OIL SPILL PROTECTION PROJECT
01301 2015-0208 CONDUIT FROM DAM TO OLD ICB TO PLANT 2 2 20,000
01301 5134466 2015-0156 PARLEY'S CANYON HYDROPOWER PROJECT 1 0 1,100,000
01301 512700006 LITTLE DELL PENSTOCK:PHASE 2
01301 2018-1034 SPILL PROTECTION PROJECT-I-80 AT LAMB'S CANYON 5 0 240,000
01301 512700011 2018-1103 PARLEYS CANYON CONDUIT AND FIBER INSTALLATION 4 0 100,000
01301 5134467 2015-0154 MOUNTAIN DELL RESERVOIR-BYPASS PIPE LITTLE DELL TO PARLEY'S 5 0
TOTAL PARLEYS CANYON $ - - $ - $ - $ - $ - $ 1,460,000
RED PINE DAM
01301 5134455 2015-0167 RED PINE DAM REHABILITATION 5 4 20,000 100,000 1,000,000
TOTAL RED PINE DAM $ 20,000 - $ - $ 100,000 $ 1,000,000 $ - $ -
CECRETDAM
01301 512700005 2016-1272 CECRET DAM REHABILITATION-DESIGN 4 3 2,000,000 2,000,000
2018-1109 CECRET LAKE FLOW METER AND TELEMETRY 4 0 60,000
CECRET DAM REHABILITATION-OUTLET WORKS 4 4 50,000
TOTAL CECRET DAM $ - $ - $ - $ - $ 110,000 $ 2,000,000 $ 2,000,000
LAKE MARY DAM
01301 512700001 2017-2080 REABILITATION OF THE LAKE MARY GAUGE 3 5
01301 512700016 2018-1100 LAKE MARY DAM CREST REHABILITATION 5 5 90,000 100,000
01301 512700013 2018-1102 TWIN LAKE AND LAKE MARY OUTLET CHANNEL IMPROVEMENTS 5 5 50,000 100,000
01301 2018-1105 TWIN LAKES AND LAKE MARY LOG BOOMS 3 5 10,0001
TWIN LAKES DAM-GATE REPAIRS 1,000,000 500,000
TOTAL LAKE MARY DAM $ - $ 150,000 $ 1,000,000 $ 600,000 $ 100,000 $ - $ -
TWIN LAKES DAM
01301 512700002 2017-2082 REPAIRS TO TWIN LAKES DAM GAUGE 3 4
01301 2018-1101 TWIN LAKES DAM GAUGE RELOCATION 3 4 50,000 20,000
01301 512700012 2018-1104 TWIN LAKES DAM DRAIN CLEANOUT INSTALLATION 4 5 40,000
TWIN LAKES DAM-GATE REPAIRS 20,000
TOTAL TWIN LAKES $ - $ 20,0001$ - $ 50,000 $ 60,000 $ - $ -
RED BUTTE DAM
01301 512700003 2017-2079 REPAIRS AND IMPROVEMENTS TO RED BUTTTE DAM ROAD 3 4 20,000
TOTAL RED BUTTE DAM $ - $ - $ - $ - $ - $ - $ 20,000
TOTAL STORAGE RESERVOIRS $ 2,470,000 $ 1,650,000 $ 2,125,000 $ 1,575,000 $ 2,020,000 $ 2,000,000 $ 3,915,000
36
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
O O
z z
� F
CAP K BUDGET
COST CENTER PROJECT REQUEST PROJECT DESCRIPTION zz YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q 2020-21
U a
F z
O
U U
51-01301-2730.07 DISTRIBUTION RESERVOIRS
01301 513444163 2017-2060 NEFF'S TANK OVERFLOW DRAIN 5 5
01301 513444164 2017-2067 MARCUS RESERVOIR TANK UPGRADES 5 5 1,000,000
01301 513444161 2017-2074 EASTWOOD NORTH-INTERIOR COATING 5 5
01301 513444162 2015-0527 FERGUSON TANK UPGRADE 5 5
01301 513444166 2015-0573 AM-TANK AND RESERVOIR INSPECTIONS AND REPAIRS 5 5 100,000 100,00 100,000 100,000 100,000 100,000 100,000
01301 513444165 2015-0409 MOUNT OLYMPUS TANKS DRAIN/OVERFLOW STRUCTURE 5 4
01301 5134507 2016-1171 FORT DOUGLAS IMPROVEMENTS/EXPANSION 5 4 5,250,000
01301 513444159 2015-0174 MILITARY RESERVOIR REPAIR 5 3 11,020,000
01301 2015-0406 EMIGRATION TUNNEL POWER 4 4 pir45,000
01301 513444168 2017-2111 TANNER RESERVOIR ROOF REPLACEMENT/FULL REPLACEMENT 4 4 450,00 3,000,000
01301 513444715 2015-0719 DISTRIBUTION TANK AND RESERVOIR PAVING 4 4 80,000 80,000 80,000
01301 2016-0753 BASKIN OVERFLOW/DRAIN GOOSENECK BOX 4 4 100,000
01301 2017-2061 TETON TANKS SLOPE STABILIZATION 4 3 50,000
01301 513444174 2015-0525 PERRY HOLLOW TANK 2 5 400,001 570,000
01301 5134471 2015-0459 TANK PAINTING AND CORROSION CONTROL 3 3 100,000 100,000 100,000 100,000
01301 2016-0935 ENSIGN DOWNS OVERFLOW 3 3 150,000
01301 2015-0516 MOUNT OLYMPUS TANKS&PUMP STATION BLACKTOP 2 4 25,000
01301 2015-0499 RAINER TANK 2 2 280,000
01301 2016-0917 ENSIGN DOWNS LOWER RESERVOIR MODIFICATIONS 2 2 200,000
01301 2015-0520 NORTH BENCH TANK ROAD 1 3 45,000
01301 2015-0526 VICTORY ROAD 1 3 22,000
01301 2016-0754 CAPITOL HILLS TANKS-TRUCK ACCESS 3 0 200,000
01301 513444167 2017-2121 TELFORD RESERVOIR SAFETY IMPROVEMENTS 1 2
01301 2015-0528 NEFFS CANYON TANK 1 3 55,000
01301 2015-0529 EMIGRATION TANK UPGRADES 1 2 60,000
01301 2015-0530 TETON TANK UPGRADES 1 2 50,000 35,000
01301 2015-0458 MISCELLANEOUS REPAIRS 3 2 50,000
01301 2017-2010 COVE TANK STABILIZATION PROJECT 2 3 200,000
01301 2017-2012 TELFORD FENCE 3 0 30,000
01301 2017-2013 EAST BENCH TANKS DRAIN LINE GOOSENECK 1 3 25,000
01301 2017-2059 VICTORY ROAD TANK OVERFLOW DRAIN 4 4 50,000
01301 2017-2064 CARRIGAN COVE TANK POWER 2 3 50,000
01301 2017-2112 GRANITE OAKS/TELFORD RESERVOIR REPAIRS 3 3 50,000
01301 2017-2118 GRANITE OAKS ACCESS ROAD 1 4 100,000
01301 2018-1023 BASKIN RESERVOIR EFFLUENT PIPE 4 4 500,000
01301 513444172 2018-1024 BASKIN ROOF REPLACEMENT 5 5 50,000
01301 513444173 2018-1026 TANK AND RESERVOIR FALL PROTECTION SYSTEMS 5 0
01301 2018-1031 MILITARY RESERVOIR-JOINT SEALANT REPAIR 5 4 20,000
01301 2018-1032 MILITARY RESERVOIR-REPAIR INLET/OUTLET PIPE 5 4 50,000
01301 2018-1033 MILITARY RESERVOIR CONDITION ASSESSMENT 5 4 20,000
01301 513444179 2020-1094 MCINITIRE RESERVOIR ROOF DEFICIENCY STRUCTURAL ASSESSMENT 5 4 700,00 50,000
01301 2018-1092 FENCE 300 EAST GORDON LANE 1 4
01301 REBUILD MCINTIRE RESERVOIR 1 4 10,000,000
$ 5,400,000 $ 2,350,001$ 4,200,000 $ 620,000 $ 335,000 $ 100,000 $ 23,287,000
51-01301-2730.08 DISTRIBUTION MAINS&HYDRANTS
CITY,COUNTY,STATE AND MISC.DRIVEN PROJECTS
01301 513505425 2020-1066 2100 SOUTH-HIGHLAND TO YUMA 1,200,0001
37
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
O O
z z
� F
CAP K BUDGET
COST CENTER PROJECT REQUEST PROJECT DESCRIPTION zz YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER zi 2020-21
U
F z
O -16
U 1 O
01301 512800041 2019-1183 NEW PRV AT 3300 S HIGHLAND DR-E6-R51 200,000
01301 513900131 2019-1047 MARCUS RESERVOIR METER AND SERVICE TAP TO JVWCD 40,000
01301 514500019 2016-0961 4TH AND A PRV 4 5
01301 2016-0958 10TH AND B PRV 3 4 210,000
01301 2019-1190 BIG COTTONWOOD CONDUIT PIPE INSPECTION 300,000
01301 2016-0751 RECONNECTION OF 1700 SOUTH AND FOOTHILL UTILITIES 2 4 20,000
01301 2020-1031 UPPER CONDUIT REPAIR PROJECT 1,856,400 2,808,000 1,293,600 17,000,000
01301 513600098 2017-2072 SAMPLING TAPS 3 3 10,000
01301 2016-0923 SAM PARK INLET VAULT 3 3 35,000
01301 2016-0959 10TH AND E PRV 3 3 210,000
01301 2016-0960 8TH AND L PRV 3 3 210,000
01301 2016-0914 CONNECTIONS AT RR 4 0 440,000
01301 513600103 CORROSION CONTROL PROGRAM
01301 CORROSION PROGRAM RETROFITTING 80,000 80,000 80,000 100,000
01301 C12-R15 PRV REPLACEMENT 5 4 250,000
01301 514506 R19-0114 1000 EAST 500 SOUTH PRV
01301 513505206 STATE ST/NORTH TEMPLE RECONNECT MAIN 5 5 1,600,000 2,700,000
01301 2020-1003 TRANSMISSION LINE VALVE REPLACEMENT ALONG 500 S 4 4 210,000
$ 1,925,000 $ 4,243,000 $ 6,476,400 $ 4,483,000 $ 3,058,600 $ 1,750,000 $ 17,680,000
WATER MAIN REPLACEMENTS
01301 513505314 SMALL DIAMETER PIPE REPLACEMENT PROGRAM 5 5
01301 513505373 R19-0120 FY 19/20 WATER MAIN REPLACEMENT 500,000
01301 FY 20/21 WATER MAIN REPLACEMENT-covered in streets bond
01301 FY 21/22 WATER MAIN REPLACEMENT-covered in streets bond 5 4 2,300,0001
01301 FY 22/23 WATER MAIN REPLACEMENT-covered in streets bond
01301 FY 23/24 WATER MAIN REPLACEMENT 2,000,000
01301 FY 24/25 WATER MAIN REPLACEMENT 4,000,000
01301 FY 25/26 WATER MAIN REPLACEMENT I 7,000,000
01301 FY 26/27 WATER MAIN REPLACEMENT
01301 513302134 2019-1170 VINE STREET WATER MAIN REPLACEMENT 1,100,000
01301 513505203 2015-0247 600 WEST-600 NORTH TO RAILROAD CROSSING 5 4
01301 513505216 1000 NORTH-1500 WEST TO REDWOOD ROAD 4 5
01301 513302017 2015-0618 900 EAST AND 5600 SOUTH WATER MAIN REPLACEMENT 5 5 2,000,000
01301 513302116 2016-0739 MILLCREEK WAY WATER MAIN REPLACEMENT 5 5
01301 513505306 2017-2063 SCENIC DRIVE UPPER CONDUIT SLIPLINE PROJECT 5 5
01301 513505208 2015-0240 J STREET-SUNRISE AVENUE TO NORTHCREST DRIVE 5 4
01301 2016-0921 BACKFEED FOR UTAH STATE CAPITOL 5 4 60,000
01301 2016-1234 SHED AT EMIGRATION WELL 5 4
01301 513505151 2015-0543 700 SOUTH-300 WEST TO 700 WEST 5 4
01301 513505156 2015-0233 200 SOUTH-600 WEST TO JEREMY STREET 4 5
01301 513505193 2015-0235 BECK STREET-1805 NORTH TO 1180 NORTH 4 5 1,247,000
01301 513505207 2015-0252 3390 SOUTH-700 EAST TO RIVIERA DRIVE 4 5
01301 513504858 2015-0547 DULUTH AVE(1550 N)-900 W TO DEXTER,900 W-1500 N TO DULUTH 4 5 750,000 4
01301 513302138 2019-1109 OLYMPIC WAY&SOVEREIGN WAY 4 5 1,600,000
01301 513505130 2015-0549 FOOTHILL DRIVE-EMERSON AVE TO KENSINGTON AVE 4 5
01301 513302047 2015-0617 MILLSTREAM DRIVE(3580 S)-MARDONNA WAY TO EASTWOOD DRIVE 4 5 274,000
01301 513505133 2015-0624 1700 SOUTH-1000 EAST TO 1100 EAST 4 5 160,000
01301 2016-1230 17TH AND FOOTHILL TELEMETRY AND POWER 4 5 200,000
01301 2015-0255 REDWOOD ROAD-500 SOUTH TO 1050 SOUTH 4 5
01301 513505212 2015-0253 PLEASANT VALLEY LINE 4 5 653,000
01301 2015-02541 CITY CREEK HIGHLINE 1 4 1 5 1 1 1 1 460,000
38
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
(9
z z
� F
-.1116
CAP K BUDGET
COSTCENTER PROJECT REQUEST PROJECT DESCRIPTION zz YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q 2020-21
U
F
U
U
01301 2016-1232 NEW PRV-R74 3 3 200,000
01301 2016-1235 POWER AT EMIGRATION TUNNEL 3 3 100,000
01301 2015-0399 RESEARCH PARK UPGRADE 5 0 410,000
01301 2016-0919 INSERTA VALVES 5 0 50,000
01301 2017-1299 EDWARD DRIVE REGULATED IMPROVEMENTS 5 0 500,000
01301 2017-2068 INDIAN ROCK PRESSURE ZONE REDUNDANT FEED 5 0 250,000
01301 2017-2070 HIGHLAND DR WATER MAIN-6200 S TO DIAMOND HILLS LN 3 2 250,000
01301 513302046 2015-0615 SUNILAND DRIVE(3550 E)-MILLSTREAM LANE TO END OF SUNILAND CIRCI 3 2 150,000 149,000
01301 2015-0426 FORT UNION AND HIGHLAND AVE INTERSECTION 2 3 302,500
01301 2017-2011 900 EAST FROM VAN WINKLE TO 5600 SOUTH 2 3 100,000
01301 513505204 2015-0248 500 SOUTH-2130 WEST TO ORANGE STREET 4 0 315,000
01301 513302021 2015-0250 6200 SOUTH-2900 EAST TO 3000 EAST 4 0 350,000
01301 513302058 2015-0544 SHORT HILLS DR(3375 E)-8220 SOUTH TO 8315 SOUTH 4 0 55,000
01301 2015-0397 SUICIDE ROCK VAULT 2 2 100,000
01301 2016-0925 2700 E CONNECTION 2 2 60,000
01301 2015-0480 1700 EAST FROM FT UNION BLVD(6935 S)TO 7080 SOUTH 1 3 360,000
01301 513302059 2015-0548 3900 SOUTH-900 EAST TO 940 EAST 3 0 130,000
01301 2015-0586 PARLEY'S CANYON BLVD 1700 EAST TO 1800 EAST 3 0 181,000
01301 513505166 2015-0626 400 EAST-1497 SOUTH TO 1530 SOUTH 3 0 37,000
01301 513505167 2015-0627 1400 EAST-GILMER AVENUE TO YALE AVENUE 3 0 32,000
01301 2016-0957 MORRIS PUMP STATION 3 0 600,000
01301 2016-1168 KEARNS VALVE 3 0 30,000
01301 2015-0413 700 NORTH 8"AC 2 1 115,000
01301 2015-0641 LITTLE COTTONWOOD CREEK CEMENT CAP 4" 1 2 35,000
01301 2015-0407 2200 WEST WATER MAIN EXTENSION 1 0 255,000
01301 2019-1182 SOUTH TEMPLE WATER MAIN-1000 W TO JORDAN RIVER 5 5
01301 2018-1096 CHEYENNE STREET WATER LINE REPLACEMENT 3 4 50,000
01301 2016-0856 7000 SOUTH SAND TRAP AND SCREEN REMOVAL 5 5 50,000
01301 2018-1041 UPPER BOUNDARY SPRINGS EFFLUENT LINE REPLACEMENT FROM SPRIN( 4 5 500,000
01301 2017-2018 DULUTH AVE AND 900 WEST WATER MAIN REPLACEMENT 3 5
01301 2017-2110 DEVELOPER DRIVEN PROJECTS 4 4
01301 513505409 2018-1 2100 SOUTH,700 EAST TO 1300 EAST,WATER LINE REPLACEMENT 3 4
01301 2018-1089 EAST BENCH SUCTION LINE RELOCATION 4 2 96,400
01301 2019-1132 EAST PLACE WATER MAIN REPLACEMENT 85,000
01301 2019-1125 OLYMPUS DRIVE WATER MAIN REPLACEMENT 130,000
01301 2019-1111 1400 SOUTH WATER LINE 900-1000 WEST 120,000
01301 513505408 2020-1015 ST.MARY'S WAY WATER LINE REPLACEMENT 400,000
01301 513302131 2019-1137 1100 EAST 3900 SOUTH WATER MAIN REPLACEMENT 300,000
$ 3,634,000 $ 4,876,000 $ 1,371,400 $ 4,000,000 $ 4,000,000 $ 7,000,000 $ 26,585,700
MASTER PLAN PROJECTS
01301 513416337 2015-0629 MP3.16-NORTH BENCH PUMP STATION 5 5 150,000 1,500,000
01301 513505088 2015-0217 CITY CREEK TREATMENT LINE TO MORRIS RESERVOIR 5 4 5,500,000
01301 513302020 2015-0230 3RD EAST PHASE II-MARCUS TO ARTESIAN BASIN 4 4 6,000,000 5,500,00 3,500,000
01301 51360062 2015-0632 MP2.3-WASTEWATER REUSE 4 3 23,000,000
01301 513505116 2015-0633 MILLCREEK TREATMENT PLANT LINE-TANK TO WASATCH BLVD(24") 4 3 750,000
01301 513416327 2015-0218 MP 3.5B-16"PIPELINE ON NEWPORT WAY/NANTUCKET DRIVE 4 2 394,000
01301 513302063 2015-0224 MP 3.5A-12"PIPELINE ON HIGHLAND DR(6200 S HIGH ZONE) 3 3 317,000
01301 2015-0229 MP 3.17-8"LOOP AT 2200 W EST/2200 NORTH 5 0 948,000
01301 513505159 2015-0222 MP3.14-AUXILIARY POWER-GOLDEN HILLS 5 0 45,000
01301 513505168 CAPITOL HILL TO ENSIGN DOWNS PIPELINE 4 0 5,000,000
013011 513302062 2015-0219 MP3.9-NEW PUMP STATION-TETON TO MT.OLYMPUS/4500 SOUTH HIGH-1 4 1 0 1 695,000
39
WATER UTILITY CIP BUDGET
Five Year Projected Budget 2022-2026
z z
z Z
� F
CAP K w BUDGET
COSTCENTER PROJECT REQUEST PROJECT DESCRIPTION 0 YEAR 2021-22 2022-23 2023-24 2024-2025 2025-2026 DELAYED
NUMBER NUMBER Q != 2020-21
U
F
K
U
01301 513302061 2015-0220 MP3.66-12"PIPELINE ON BRIGHTON WAY 4 0 200,000
01301 513505117 2015-0221 MP3.5C-16"PIPELINE ON BENGAL BOULEVARD 4 0 1,134,000
01301 513505098 2015-0225 MP3.1A-EAST-WEST CONVEYANCE LINE-PARK RESERVOIR TO SUGARHC 4 0 4,500,000 55,000,000
01301 2015-0231 MP 3.8C-VICTORY ROAD-ENSIGN DOWNS PHASE II-IF 4 0 2,250,000
01301 5134493 2015-0634 MP3.1B-EAST WEST CONVEYANCE LINE-SUGARHOUSE PARK TO 900 WE: 4 0 5,000,000 10,000,000 10,000,000 25,000,000
01301 5134464 2015-0227 MP3.7-ADD THROTTLING CONTROL VALVE INTO WILSON RESERVOIR 3 0 150,000
01301 2015-0538 MP 3.12A-7800 SOUTH PRESSURE ZONE-4.3 MG RESERVOIR 2 0 3,000,000
01301 51360060 2015-0636 MP2.1-DEVELOP ADDITIONAL GROUND WATER SOURCES 2 0 18,000,000
01301 513505169 2015-0630 MP2.2-ADDITIONAL SURFACE WATER DEVELOPMENT 2 0 12,000,000
01301 51360061 2015-0635 MP3.1C-EAST WEST CONVEYANCE LINE-900 WEST TO 3400 WEST(PHASI 1 0 75,000,000
01301 2015-0631 MILLCREEK WATER TREATMENT FACILITY 1 0 80,000,000
01301 UPDATE WATER MASTER PLAN 400,000
01301 IMPACT FEE PLAN STUDY AND UPDATE
01301 FEASIBILITY ASSESSMENT FOR SLCDPU CAMPUS
$ 10,500,000 $ 5,500,00 $ 3,650,000 $ 6,500,000 $ 10,000,000 $ 10,000,000 $ 308,783,000
TOTAL DISTRIBUTION MAINS&HYDRANTS $ 23,329,000 $ 18,019,00 $ 18,647,800 $ 19,183,000 $ 19,308,600 $ 19,000,000 $ 358,498,700
2730.09 WATER SERVICE CONNECTIONS
01701 513900126 2015-0494 SERVICE LINE REPAIR/REPLACEMENTS 5 5 1.500.000 1,500,000 1,500,000 1,500,000 1,500,000 1,800,000
03301 513900125 2015-0495 NEW SERVICE CONNECTIONS 5 5 450,000 400,000 400,000 400,000 400,000 400,000
03301 450,001 450,000 450,000 450,000 450,000
02201 F 513900124 2015-0496 LARGE METER REPLACEMENTS 5 5 300,000 400,000 400,000 400,000 400,000 400,000
02601 513900123 2015-0498 METER REPLACEMENT PROGRAM 5 5 200,000 200,000 200,000 200,000 200,000 200,000
02601 513900122 2017-2126 AMI METER REPLACEMENT PROGRAM 1 0 2,700,000 2,500,000 2,700,000 2,700,000 2,700,000 3,100,000
1701 REVISED LEAD AND COPPER RULE COMPLIANCE 500,000 500,000 500,000
01701 513900132 2020-1034 REPLACE METER VAULT AND 4"METER W/BY-PASS 58,000
$ 5,208,000 $ 5,450,000 $ 5,650,000 $ 6,150,000 $ 6,150,000 $ 6,850,000 $ -
2730.20 LANDSCAPING
WATERSHED
00601 5122672 2017-1295 RECREATION AREA PICNIC TABLE REPLACEMENT 5 5
00601 5122673 2015-0670 ACCESSIBILITY UPGRADES TO WATERSHED RECREATION FACILITIES 5 0 200,000
00601 512627466 2017-2032 SILVER LAKE RESTROOM DEMOLISH AND REPLACE 5 5
00601 512627463 2017-1296 BIG COTTONWOOD CANYON PARK&RIDE RESTROOM REBUILD 5 5 500,000
00601 512300064 R19-0115 CITY CREEK ROADWAY ASPHALT 5 5 100,000
03201 51360014 2015-0519 WEST TEMPLE CAMPUS-CONSERVATION IMPROVEMENTS 2 4 100,000
00601 2018-1028 CITY CREEK CANYON ROAD RECONSTRUCTION 5 5 3,000,000
03201 514700005 2018-1110 SITE 30 PAVILION STRUCTURAL REVIEW 2 4
00601 CITY CREEK WATER SYSTEM TO SITES 23 THROUGH 30 500,000
900 SOUTH LANDSCAPING PROJECT-Cost share Stormwater 68,000 68,000
$ 68,000 $ 68,000 $ 200,000 $ - $ - $ - $ 4,200,000
TOTAL CAPITAL IMPROVEMENTS $ 47,980,000 $ 39,600,000 $ 68,462,800 $ 88,923,500 $ 77,588,600 $ 73,147,000 $ 755,920,700
-09,600,000 -68,462,800 -88,923,500 -77,588,600 -73,147,000 -755,920,700
40
WATER UTILITY CAPITAL PURCHASES
Projecter' " ' ' "021-22
Cost Center Object Code Asset Description Budget Year 2021-22
275010 AUTOMOBILES & TRUCKS Amount
5100201 1 4 ton 4X4 pickup with shell 33,000.00
1/4 ton truck, 4WD, extended cab, towing package, cap for bed, lightbar, electric
5100601 window locks, hitch, VHF radio and squawk box 34,000.00
5101001 4x4 Colorado truck - Lead & Copper - New 35,000.00
5101 301 Chevy or similar mid size 4 X 4 with bed cover and lights 35,000.00
5101401 Chevy 5500 flt bed vac combo replace valve machine vac. machine 130,000.00
5101601 1 4 ton 4x4 with back cover 34,000.00
5101701 1 4 ton pickup 4X4 Chevy Colorado 32,000.00
5101701 1 14SD Dump Truck 148,000.00
5101701 106HD with V&H bed 158,000.00
5101701 106HD with V&H bed 158,000.00
5102301 1 4 ton pickup Chevy Colorado 32,000.00
5102301 8-10 passenger van 38,000.00
5102401 1 ton pickup - walk in bed 46,000.00
5102501 1 ton - utility bed 41,500.00
5102601 1 4 ton 4X4 pickup Extended cab, light bar, cover 34,000.00
5102601 1 4 ton 4X4 pickup Extended cab, light bar, cover 34,000.00
5102801 1 4 ton 4X4 pickup Extended cab, light bar, cover 34,000.00
5103001 Ford Escape 25,400.00
$ 1,081,900.00
276030 TELEMETERING EQUIPMENT Amount
5100201 Hydrology Measurement System Replacement Rebuild 150,000.00
5101 501 Miscellaneous Water Telemetry Equipment 50,000.00
275030 FIELD MAINTENACE EQUIPMENT
5100101 CAT Backhoe replacement program 9,000.00
5100101 Trailmax Trailer for each machine 38,000.00
5100801 Boat for reservoir monitoring for algae, chemical application, etc. - New 50,000.00
5100801 Kubota Utility Vehicle 32,000.00
5100901 1 jKubota Utility Vehicle 1 32,000.00
41
5101 201 Green Climber LV 1400 Mower for Little Dell Dam Face 150,000.00
5101401 Skagg SVRII-36A-19FX - replacement for Dixie Chopper 9,550.00
5101401 EH Wach's Standard LX Diesel -Skid mount self contained valve O&M unit 95,925.00
5101701 Case Backhoe 91,000.00
5101701 Case 621 Loader 168,000.00
5101701 CAT Backhoe 9,000.00
5101701 CAT Backhoe replacement program - 8 units Backhoe 72,000.00
5101701 CAT Hammer Hoe 9,000.00
276090 OTHER NON-MOTIVE EQUIPMENT
5101600 Servers (SLCIPUAPP2, SLCIPUDB2, SLCIWATER, SLCISP2) 40,000.00
5101601 Lidar enabled drone components 10,000.00
5101601 Vac for Leak locator truck 12,000.00
5102601 Replacement handheld units - techonology no longer supported 81,860.00
276050 OFFICE FURNITURE AND EQUIPMENT
5101 601 Replacement of Large Scale Ricoh Scanner Copier 20,000.00
5101 601 Replacement of Sharp Copier/Scanner/Printer in Dispatch 6,600.00
5103201 Replacement - phone system continuation of project 75,000.00
276020 TREATMENT PLANT EQUIPMENT
5100701 Emergency equipment replacement (i.e. pumps, etc) 60,000.00
5100801 Plant equipment, emergency (ie: pumps, etc) 60,000.00
5100901 Emergency plant equipment (i.e. pumps) 60,000.00
271030 WATER RIGHTS & SUPPLY
5103301 Water rights and companies 250,000.00
5103301 Water stock 250,000.00
271010 LAND
5103301 Non-project and canals 150,000.00
5103301 Watershed Land 1,500,000.00
$ 3,540,935.00
Total $ 4,622,835.00
42
Sewer Utility-Budget Summary and Cash Flow
43
SEWER UTILITY BUDGET SUMMARY
FY 2022-24
Rafe Increase Rafe Increase
Rafe Increase 18% 18% 15%
AMENDED PROJECTED PROPOSED FORECAST FORECAST
ACTUAL BUDGET ACTUAL BUDGET BUDGET BUDGET
SOURCES 2019-20 2020-21 2020-21 2021-22 2022-23 2023-24
REVENUE&OTHER SOURCES
REVENUES r
METERED SALES $ 43,864,526 $ 50,215,000 $ 50,215,000 $ 58,034,937� 66,740,000 $ 73,414,000
,000 INTEREST INCOME 1,035,061 992,301 992,301 171 232,000 444,000
OTHER REVENUES 343,367 519,942 519,942 406,000 406,000 406,000
TOTAL REVENUES $ 45,242,954 $ 51,727,243 $ 51,727,243 $ 58,611,937 67,378,000 $ 74,264,000
OTHER SOURCES
IMPACT FEES $ 1,700,183 $ 1,422,000 $ 1,783,558 $ 1,422,000 1,422,000 $ 1,422,000
GRANTS&OTHER RELATED REVENUES 5,379,388 1,684,000 1,684,000 1,100,82 1,100,823 1,100,823
SALE OF EQUIPMENT 168,224 16,000 16,000 16,00 16,000 16,000
WIFIA LOAN 93,210,000 93,210,000 93,890,000 70,465,000 64,017,000
NON BOND FINANCING - - - 0 -
BOND PROCEEDS - 51,285,000 106,285,000 123,687,000 88,491,000 46,257,000
TOTAL OTHER SOURCES $ 7,247,795 $147,617,000 $202,978,558 �$ 220,115,823, 161,494,823 $ 112,812,823
TOTAL REVENUE&OTHER SOURCES $ 52,490,749 $ 199,344,243 $254,705,801 $ 278,727,760 228,872,823 $ 187,076,823
EXPENSES&OTHER USES
EXPENDITURES
PERSONNEL SERVICES $ 9,619,797 $ 12,698,997 $ 12,698,997 12,799,9594 13,31 1,956 $ 13,844,435
OPERATING&MAINTENANCE 947,769 2,579,981 2,579,981 2,656,055 2,709,175 2,763,357
TRAVEL&TRAINING 28,820 106,912 106,912 90,590 92,402 94,250
UTILITIES 484,153 1,001,180 1,001,180 1,039,0 1,059,871 1,081,067
TECHNICAL SERVICES 739,106 2,560,929 2,560,929 2,710,76 2,764,985 2,820,285
IMS SERVICES 611,351 640,000 640,000 1,040,53 1,061,344 1,082,571
FLEET MAINTENANCE 415,754 543,550 543,550 541,000 551,820 562,856
ADMINISTRATIVE SERVICE FEE 457,350 480,000 480,000 494,400 504,288 514,374
PAYMENT IN LIEU OF TAXES 661,263 809,149 809,149 851,386 868,414 885,782
BILLING COST 827,634 827,634 827,634 949,872 968,869 988,246
RISK MANAGEMENT 53,434 375,450 375,450 374,450 381,939 389,577
TRANSFERS TO GENERAL FUND - - - - - -
NEW PLANT O&M COSTS - - - 250,000 252,500
OTHER CHARGES AND SERVICES 286,086 567,794 567,794 726,511%j 741,045 755,865
TOTAL EXPENDITURES $ 15,132,517 $ 23,191,576 $ 23,191,576 24,274,62 25,266,108 $ 26,035,165
OTHER USES
CAPITAL OUTLAY $ 1,681,191 $ 1,194,480 $ 1,194,480 $ 1,327,000 698,979 $ 712,959
CAPITAL IMPROVEMENT BUDGET 63,108,908 231,676,372 231,676,372 226,135,826 166,619,252 157,103,748
COST OF DEBT ISSUANCE - 285,000 285,000 687,000 491,000 257,000
DEBT SERVICES 12,447,926 12,422,469 14,220,770 15,789,350 16,441,610 16,498,244
TOTAL OTHER USES $ 77,238,025 $245,578,321 $247,376,622 $ 243,939,176 184,250,841 $ 174,571,951
TOTAL EXPENSE&OTHER USES $ 92,370,542 $268,769,897 $270,568,198 $ 268,213,796 209,516,949 $200,607,1 16
EXCESS REVENUE AND OTHER
SOURCES OVER(UNDER)USES $ (39,879,793) $ (69,425,654) $ (15,862,397) $ 10,513,964 19,355,874 $ (13,530,293)
OPERATING CASH BALANCES
BEGINNING JULY 1 $ 63,159,779 $ 30,581,040 $ 30,581,040 $ 14,718,64 25,232,607 $ 44,588,481
RESTRICTED/DESIGNATED $ 7,301,054 $ - $ - $ - 0 $ -
AVAILABLE JUNE 30 $ 30,581,040 $ (38,844,614) $ 14,718,643 $ 25,232,607 44,588,481 $ 31,058,188
Cash Reserve Ratio 202% -167% 63% 104% 176% 119%
Cash reserve goal above 14%
44
SEWER UTILITY CASH FLOW
2022 BUDGET/ FY 2023-2026 FORECAST
CTUAL PROJECTED BUDGET BUDGET BUDGE
YEAR YEAR YEA YEAR
2021-2022 202 2023-2
REVENUE
SEWER SALES $ 43,864,526 $ 50,215,000 $ 58,034,937 66,740,000 73,414,000 $ 80,755,000 $ 88,831,000
OTHER INCOME 343,367 519,942 406,000 406,000 406,000 406,000 406,000
INTEREST INCOME 1,035,061 992,301 171,000 232,000 444,000 324,000 175,000
OPERATING INCOME $ 45,242,954 $ 51,727,243 58,611,937 67,378,000 74,264,000 $ 81,485,000 $ 89,412,000
OPERATING EXPENSES
NEW PLANT O&M COSTS $ - - (250,000) (252,500) $ (255,025) $ (257,575)
OPERATING EXPENSES (15,132,517) (23,191,576) (24,274,620) (25,016,108) (25,782,665) (26,575,209) (27,394,678)
TOTAL OPERATING EXPENSE $ (15,132,517) $ (23,191,576) $ (24,274,620) (25,266,108) (26,035,165) $ (26,830,234) $ (27,652,253)
NET INCOME EXCLUDING DEP. $ 30,110,437 $ 28,535,667 $ 34,337,317 42,111,892 48,228,835 $ 54,654,766 $ 61,759,747
OTHER INCOME&EXPENSE
IMPACT FEES $ 1,700,183 $ 1,783,558 1,422,000 1,422,000 1,422,000 $ 1,422,000 $ 1,422,000
WIFIA LOAN - 93,210,000 93,890,000 70,465,000 64,017,000 24,356,000 2,697,000
NET BOND PROCEEDS 106,000,000 123,000,000 88,000,000 46,000,000 - -
ISSUE COSTS(PROCEEDS) 285,000 687,000 491,000 257,000
ISSUE COSTS(EXP) - (285,000) (687,000) (491,000) (257,000) - -
OTHER CONTRIBUTIONS 5,379,388 1,684,000 1,100,823 1,100,823 1,100,823 1,100,823 1,684,000
SALE OF EQUIPMENT 168,224 16,000 16,000 16,000 16,000 16,000 16,000
CAPITAL OUTLAY (1,681,191) (1,194,480) (1,327,000) (698,979) (712,959) (727,218) (741,762)
STATE LOAN DEBT REPAYMENT (6,375,000) (2,125,000)
NEW DEBT SERVICE 00
(3,247,000) (3,897,000) (3,897,000) (6,871,000) (8,999,000)
DEBT SERVICE (6,072,926) (12,095,770) (12,542,350) (12,544,610) (12,601,244) (12,682,082) (12,679,577)
OTHER INCOME&EXPENSE $ (6,881,322) $ 187,278,308 $ 202,312,473 143,863,234 95,344,620 $ 6,614,523 $ (16,601,339)
CAPITAL GENERATION go
GENERATED FOR CAPITAL $ 23,229,175 $ 215,873,975 $ 236,649,790 785,975,726 143,573,455 $ 67,269,289 $ 45,758,408
CAPITAL IMPROVEMENTS
CAPITAL IMPROVEMENTS $ (63,708,908) $ (237,676,372) $ (226,135,826) (766,679,252) (757,703,748) $ (77,847,603) $ (26,455,000)
BEGINING CASH BALANCE $ 63,159,779 $ 30,581,040 $ 14,718,643 25,232,607 44,588,481 $ 31,058,188 $ 14,479,874
CASH INCREASE/(DECREASE) $ (39,879,793) $ (15,862,397) $ 10,513,964 19,355,874 (13,530,293) $ (16,578,314) $ 18,703,408
RESTRICTED/DESIGNATED $ 7,301,054 $ - $ - - - $ - $ -
ENDING BALANCE $ 30,581,040 $ 14,718,643 $ 25,232,607 44,588,481 31,058,188 $ 14,479,874 $ 33,183,282
Debt Service Coverage 2.42 2.01 2.17 2.56 2.92 2.80 2.85
RATE CHANGE 11115pr' 18% 18% 18% 15% 10% 10% 10%
Cash Reserve Ratio 154% 63% 104% 176% 119% 54% 120%
DEBT SERVICE%OF GROSS OPERATING REVENUE 13% 23% 27% 24% 22% 24% 24%
MONTHLY RESIDENTIAL UTILITY BILL AT 4 CCF 14.68 17.36 20.52 23.60 25.96 28.56 31.42
MONTHLY RESIDENTIAL UTILITY BILL AT 8 CCF 29.36 34.72 41.04 47.20 51.92 57.11 62.82
45
Farec—d far FY 2022 Budget
(FY 2019 A--1 Basis N.—I.Hoe Adi.—d 1.cash in CIP)
SEWER UTILITY BUDGET
Five Year Projected Budget 2022-2026
u z
z z
F F
CAP rc PAST
COST PROJECT REQUEST PROJECT DESCRIPTION j'_ z BUDGET 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 DELAYED
CENTER NUMBER NUMBER 0 YEAR
p 2020-21
z
0
2720.10 MAINTENANCE&REPAIR SHOPS-2720.10
2019-1041 LIFT STATION STORAGE FACILITY 5 0 200,000 600,000
NEW SLCDPU CAMPUS 5 5 8,000,000 8,000,000
0 200,000 600,000 8,000,000 01 0 8,000,000
2720.05 LIFT STATIONS-2720.05
LIFT STATION ASSET MANAGEMENT PROGRAM
10101 2019-1046 ANNUAL SYSTEM WIDE LIFT STATION SCOPING&ASSET MANAGEMENT PRIORITIZATION 2 1 500,000
LIFT STATION RENEWALIREPLACEMENT PROGRAM
10101 2020-1149 ANNUAL PUMP REPLACEMENT(VARIOUS) 5 5 25,000 25,001125,000 25,000 25.000 25,000 25.000
10101 524907101 2017-1301 5300 WEST LIFT STATION(SS17)CAPACITY IMPROVEMENTS 4 5 2,500,000 2,500,000
10101 2015-0264 SOUTH LIFT STATION(SS05) 3 3 460,000
10101 524907104 2015-0417 INDUSTRIAL LIFT STATION REHAB&PIPING UPGRADES(SS21) 4 5 1,500,000 60,000
10101 524907098 2015-0267 NEW ROSE PARK LIFT STATION REPLACEMENT(SS02) 4 5 360,000 40,000
10101 524907105 2015-0268 500 W LIFT STATION WET WELL IMPROVEMENTS(SS28) 4 5 350,000
10101 2015-0418 CENTENNIAL LIFT STATION WET WELL REHABILITATION(SS 19) 2 3 770,000
10101 2015-0271 CANNON LIFT STATION WET WELL IMPROVEMENTS 2 3 450,000
10101 2015-0270 WESTPOINTE LIFT STATION WET WELL IMPROVEMENTS(SS 33) 2 2 550,000
10101 524907100 2015-0272 900 NORTH LIFT STATION WET WELL IMPROVEMENTS 4 5 60,
10101 524907093 2017-2075 John Cannon Lift Station 4 0 2,000,000
10101 2017-2008 Billy Mitchell(SS16)Capacity Upgrades 3 5 250,000 2,000,000
10101 524907107 2020-1036 1700 NORTH LIFT STATION ELECTRICAL IMPROVEMENTS 4 5 300,000
10101 2020-1063 Amelia Earhart LS Rehab 3 2 550,000
10101 2020-1062 Concord LS Improvements 3 2 700,000
10101 2020-1060 California Place LS Improvements 3 3 300,000
10101 2020-1064 Morton Lift Station Rehabilitation 3 3 500,000
10101 2020-1061 West LS Improvements 3 2 pr 300,000
10101 2020-1070 North LS(SSO4)Rehabilitation 3 3 L 350,000
10101 2020-1078 600 N LS Rehab 3 3 350,000
10101 2020-1079 Nin Tech LS Rehabilitation 350,000
7,035,000 1p 2,685,00 275,000 2,025,000 25,000 25,000 25,000 6,130,000
2720.30 TREATMENTPLANTS
11201 524905347 2015-0640 FACILITY BUILDING PAINTING(CORROSION PROTECTION PROGRAM) 5 5 100,000 100,000 100,000 100,000 100.000 100,000
11201 524905338 2017-2093 INFLUENT SCREEN(S)REPLACE/RETROFIT 5 5 50,000
11201 524905336 EXISTING FACILITIES CONDITION ASSESSMENT/PRE-DESIGN 5
11201 525400075 SOUTH RAS SKIMMER RELOCATION 4
11201 52540066 WETLANDS RESTORATION PROJECT 4
11201 524905342 PROCESS CONTROL LAB ROOM 4
11201 2016-1275 WASHER COMPACTOR FOR PRIMARY SLUDGE 4 0
11201 525400074 2017-2088 SCADA INSTRUMENTATION CONTROL IMPROVEMENTS 5 5
11201 524905330 2015-0707 CHLORINE BUILDING ALARM SYSTEM 5
11201 524905283 R19-0167 SCADA PHASE III FOLLOW-UP SERVICES 5 5 490,000
11201 524905280 2015-0710 REPLACEMENT OF MCC2A AT THE PRE-SEDIMENTATION BUILDING-CONSTRUCTION 5
11201 52540053 2015-0708 ATMOSPHERIC MONITORING REPLACEMENT PROGRAM 5 5
11201 52540064 VFD REPLACEMENT 5
11201 52540052 2015-0500 TRICKLING FILTER REHABILITATION 5 5
11201 52540067 TRICKLIKNG FILTER PUMPS INSPECTION&RECONDITIONING
11201 524905345 2015-0502 CAPITAL ASSET REHABILITATION AND UPGRADES 5 5 2,000,000 11300.00 1,300,000 1,300,000 1,300,000 1,300,000
11201 2016-1133 REHAB OF VERTICAL TURBINE PUMPS 4 4 200,000 200,000
11201 524905344 2017-2089 HVAC REPLACEMENTS 3 3 25,000 25,000 25,000 25,000 25,000 25,000
11201 524905341 HVAC IMPROVEMENTS AT PRE-SEDIMENTATION
11201 2016-1281 COGEN ENGINE OVERHAUL 700,000
11201 524905352 2018-1052 SLC WRF HEADWORKS GATE REPLACEMENT 5 5
11201 524905355 2016-1160 UPGRADE EMERGENCY GENERATORS AT PUMP STATION 4 5 50,000
11201 524905365 2018-1072 SLC WRF INFLUENT PUMP MOTOR REBUILD 5 4 134,000
11201 524905366 2018-1071 SLC WRF INFLUENT PUMP REBUILD 5 4 625,000
11201 524905367 2018-1068 SLC WRF BIO GAS HEAT EXCHANGER 4 4
11201 524905363 2018-1066 SLC WRF PUMP PLANT EXTERIOR LIGHTING 4 5
11201 524905359 R19-0040 NEW WRF COMPUTERIZED MAINTENANCE MANAGEMENT SYSTEM 130,000
11201 524905370 2019-1143 SLCWRF MAIN PLANT PLC UPGRADES 50,000
46
SEWER UTILITY BUDGET
Five Year Projected Budget 2022-2026
0
z z
F z
CAP x PAST
COST PROJECT REQUEST PROJECT DESCRIPTION zi YEAR z BUDGET
CENTER NUMBER 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 DELAYED
NUMBER G
u o 2020-21
F z
o
O u
11201 524905358 R18-0065 INTEGRATION FOR VFD REPLACEMENTS
112011 524905356 R18-0066 SLC WRF WORK ORDER SYSTEM 80,000
112011 524905360 R19-0046 TEMPORARY DEWATERING 300,000 300,000
4,034,000 1,725,000 1,625,000 1,425,000 2.125,000 100.000 0 1,525,000
NEW WATER RECLAMATION FACILITY
11201 524905339 2017-2051 New WRF-CM/GC Services(CM/GC Preconstruction Services) 1,296,543
11201 525400068 2017-2050 New WRF-Professional Design Services(Design Services-AECOM) 9,599,769 8,250,904 4,704,793 4,619,487 2,694,700
11201 5 Program Management(Jacobs) 2,500,000 2,500,000 2,000,000 2,000,000 1,166,667
11201 524905337 2017-2052 New WRF-Water Renew Public Outreach(Public Engagement-WF&Co) 180,000 144,000 144,000 144,000 95,000
11201 524905362 2019-1054 New WRF-Visual Documentation Services for Constuciou(Project Documentation-MultiVista) 78,000 96,000 96,000 78,000 19,100
11201 524905368 2019-1131 Sall Lake City Water Reclamation Facility LEED Lend Commissioning Agent(Lead Commissioning-ETC) 11,000 22,000 62,667 45,333
11201 524905359 R19-0040 New WRF-Computerized Maintenance Management System(CMMS-NexGen) 70,453
11201 524905271 2017-2054 New WRF-Piloting and Demonstration Testing(BNR Demonstration Facility) 2,363,636 1,636,364
11201 524905271 Permitting 4,375,000 3,750,000
11201 524905271 Easements 200,000 1,200,000
11201 524905271 2015-0505 New WRF-Core-Design Build Reclamation Facility(Construction-Based off BODR) 107,992,865 164,943,91� 127,729,145 116,904,281 42,263,312
11201 524905271 Contingency 6,777,647 6,777,64 6,777,647 6,777,647 3,388,824
TOTAL NEW WATER RECLAMATION FACILITY 135,444,913 189,320,826 141,514,252 130,568,748 49,627,603
TOTAL WATER RECLAMATION FACILITY 139,478,913 191,045,826 143,139,252 131,993,748 51,752,603 100,000 0 1,525,000
2730.14 COLLECTION LINES
COLLECTION SYSTEM ASSET MANAGEMENT PROGRAM
10401 2020-1154 1200 WEST TRUNK LINE CONDITION ASSESSMENT/PROJECT PRE-DESIGN 5 2 600,000 600,000
10401 2015-0664 SIPHON INSPECTION PROJECT 3 3 200,000 200,000
10401 2015-0645 COLLECTION SYSTEM PROJECT DEVELOPMENT CAP SCORING 2 2 150,000 300,000
10401 2020-1155 BECK STREET TRUNK LINE CONDITION ASSESSMENT/PRE-DESIGN 5 2 600,000
10401 2020-1156 ORANGE STREET TRUNK LINE CONDITION ASSESSMENT/PROJECT PRE-DESIGN 4 4 1 430,000
10401 2019-1115 Wastewater Masterplan 5 4 1,200,000
150,000 0 0 430,000 200,000 1,200,000 1,100,000
FLOW MONITORINGII&I PROGRAM
10401 2015-0652 EAST SIDE INFLOW AND INFILTRATION STUDY 3 5 300,000
10401 2015-0651 ANNUAL HYDRAULIC MODEL CALIBRATION 4 2 150,000 150,000
10401 2017-2078 VARIOUS BASIN INFLOW TESTING 4 4 250,000
10401 2018-1029 BASIN 111&1 3 4 250,000
0 0 0 0 150,000 800,000 150,000
CITY,COUNTY,STATE AND MISC.DRIVEN PROJECTS
10401 2015-0484 ANNUAL MISC.PUBLIC SERVICES PROJECTS 5 5 200,000 200,000 200,000 200.000 200,000 200.000 200,000
10401 525002988 R20-0213 500 SOUTH FM DISCHARGE BIOTOWER 4 0 130,000 1,300,000
10401 2019-1127 ORANGE STREET LOCATION 4 BIOTOWER 4 0 240,000 2,600,000
10401 2019-1128 ORANGE STREET LOCATION 5 BIOTOWER 3 0 240,000 2,400,000
10401 525002864 2019-1057 W(1600 S TO 2100 S)I 5 5 190,312
10401 525002942 2019-1091 800 WEST 600 S to 800 S 5 5 1,200,000
10401 525002861 R19-0018 300 W(900 S TO 2100 S)Spot Repairs and Sewer Rehabilitation Project 5 5 2,500,000
10401 525002982 2019-1018 Roadway Bond 2021:900 East from Hollywood to 2700 South 5 5 350,000
10401 525002980 2019-1038 Roadway Bond 2021:100 S from 900 East to North Campus Drive 5 5 100,000
10401 525002985 2019-1066 1700 East 12-inch Sewer-1700 South to 2700 South Roadway 5 5 750,000 100,000
10401 525002979 2019-1072 CITY WIDE SEWER IMPROVEMENTS AND PRESERVATION 2020/2021 5 5 600.000
10401 2019-1068 200 SOUTH-400 WEST TO 900 EAST,PHASE 1 4 4 2,500,000 1,000,000
10401 2019-1073 CITY WIDE SEWER IMPROVEMENTS AND PRESERVATION 2021/2022 4 4 800,000
10401 2019-1071 1100 EAST TO HIGHLAND-ROMONA AVE TO WARNOCK AVENUE 4 4 300,000
10401 2019-1070 1100 EAST-900 SOUTH TO RAMONA AVE 5 5 1,200,000
10401 2019-1078 1300 EAST-2100 SOUTH TO CITY BOUNDARY 5 5 600,000
10401 2019-1074 CITY WIDE SEWER IMPROVEMENTS AND PRESERVATION 2022/2023 5 5 800,000
10401 2020-1106 VIRGINA STREET-SOUTH TEMPLE TO 11TH AVE 5 5 300,000
10401 2020-1107 300 NORTH-300 WEST TO 1000 WEST 5 5 800,000
10401 2019-1075 CITY WIDE SEWER IMPROVEMENTS AND PRESERVATION 2023/2024 5 4 600,000
10401 525002978 2019-1065 900 South-900 West to 300 West&West Temple to 900 East 5 5 700,000
10401 2019-1081 2100 SOUTH-700 EAST TO 1700 EAST 5 5 800,000
10401 2019-1174 CITY WIDE SEWER IMPROVEMENTS AND PRESERVATION 2024/2025 5 5 1,000,-
47
SEWER UTILITY BUDGET
Five Year Projected Budget 2022-2026
u �
z z
F F
CAP rc PAST
COST PROJECT REQUEST LSpotRoppairs
JECT DESCRIPTION j'_ z BUDGET 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 DELAYED
CENTER NUMBER NUMBER YEAR
2020-21
10401 525002865 R19-0016 City Wide StreJI. nts and Sewer Rehabilitation Project 5 5 500,000
10401 2020-1053 Sl Surplus Inspection Reporting 5 4 1 150.000 200,000
10401 2020-1059 Jordan River WQ Sewer SAE 4 0 I 25,000 350,000
10401 2020-1086 SR-186(400 S)--State Street to 1300 E Sewer Rehab(UDOT) 4 5 1 40,000 300,000
10401 2020-1097 Foothill Dr-2100 E to Stringham Sewer Rehab 4 5 350,000
10401 2020-1098 State Street--1700 S to 400 S Sewer Rehab 4 5 40,000 300,000
10401 2017-2109 Developer Driven Improvements 3 3 500,000
10401 2017-2016 630 South State Street East Side(Life on State) 4 5 150,000
10401 2020-1169 Sl Surplus Canal CarOfication Project 5 4 1,000,000 3,000,000
6,590,312 4,080,000 8,830,000 2,775,000 440,000 6,040,000 2,600,000 1,250,000
PIPE RENEWAL&REPLACEMENT PROGRAM
10401 2015-0486 1%PER YEAR SEWER REHABILITATION/SYSTEM RENEWAL 5 5 4,000,000 3,500,000 4,500,000 4,500,000 3,400,000
10401 2015-0722 TESORO SEWER TRUNK LINE REHABILITATION 5 4 600,000 6,000,000
10401 2016-0897 WEST TEMPLE FROM TRUMAN AVE TO 1300 S CIPP 5 4 4,500,000
10401 2016-0902 800 S AND 1100 E LATERAL CONNECTIONS AND UPSTREAM INFILTRATION 3 4 imh 350,000
10401 2015-0727 300 W-550 S TO 600 S 3 3 250,000
10401 2016-0895 ELGIN AVE SEWER REPLACEMENT 3 4 50,000 350.000
10401 2015-0318 700 SOUTH-3750 WEST TO IRON ROSE PLACE(3830 W) 4 4 650,000
10401 525002835 2016-0873 DOOLEY COURT 3 5 400,000 150,000
10401 525002851 R18-0027 1200 WEST TRUNK LINE REHABILITATION PROJECT 5 5 8,000,000 75,00 12,200,000 32,000,000
10401 2020-1009 BECK STREET TRUNK LINE REHABILITATION PROJECT 5 5 10,000,000 30,000,000
10401 525002918 2016-1040 CIPP SEWER ON 800 EAST FROM SOUTH TEMPLE TO 100 SOUTH 3 5 100,000
10401 525002881 2016-1041 CIPP SEWER ON 600 SOUTH FROM 500 EAST TO 600 EAST 3 5 50,000
10401 525002897 2016-1042 CIPP SEWER ON 600 SOUTH 600 EAST 3 5 50,000
10401 525002882 2016-1044 CIPP SEWER ON 300 WEST FROM ORCHARD PL TO 600 SOUTH 3 5 50,000
10401 525002907 2016-1047 CIPP SEWER ON EMERSON AVE BETWEEN 2200 EAST AND 2300 EAST 3 5 65,000
10401 525002914 2016-1048 CIPP SEWER ON ROOSEVELT AVE AND 2200 EAST 3 5 30,000
10401 525002911 2016-1058 CIPP SEWER ON DARW IN ST FROM GIRARD AVE TO ZANE AVE 3 5 50,000
10401 525002895 2016-1059 CIPP SEWER ON 1040 SOUTH BONNEVILLE DR 3 5 50,000
10401 525002887 2016-1077 CIPP SEWER ON 1100 EAST BETWEEN 100 SOUTH AND 200 SOUTH 3 5 60,000
10401 525002912 2016-1078 CIPP SEWER ON 200 SOUTH BETWEEN 900 EAST AND 1000 EAST 3 5 60,000
10401 525002899 2016-1081 CIPP SEWER ON 1000 EAST BETWEEN 200 SOUTH AND 300 SOUTH 3 5 40,000
10401 525002888 2016-1089 CIPP SEWER ALLEY WEST OF 600 E BETWEEN 800 SOUTH AND 900 SOUTH 3 5 200,000
10401 525002913 2016-1090 CIPP SEWER ON GRACE CT AND WILLIAMS AVE 3 5 36,000
10401 525002883 2016-1091 CIPP SEWER ON ALLEY EAST OF 300 EAST BETWEEN 800 SOUTH AND 900 SOUTH 3 5 36,000
10401 525002891 2016-1093 CIPP SEWER ON 1700 EAST AND PARLEYS CANYON BLVD 3 5 36,000
10401 525002904 2016-1094 CIPP SEWER ON FOURTH AVE FROM A STREET TO B STREET 3 5 36,000
10401 525002901 2016-1096 CIPP SEWER ON THIRD AVE FROM E STREET TO F STREET 3 5 85,000
10401 525002900 2016-1097 CIPP SEWER ON J STREET BETWEEN THIRD AVE AND FOURTH AVE 3 5 170,000
10401 525002910 2016-1098 CIPP SEWER ON SECOND AVE BETWEEN F STREET AND G STREET 3 5 150,000
10401 525002894 2016-1102 CIPP SEWER ON K STREET FROM SOUTH TEMPLE TO FIRST AVE 3 5 70,000
10401 525002884 2016-1100 CIPP SEWER ON E STREET BETWEEN FIRST AVE AND SECOND AVE 3 5 40,000
10401 525002893 2016-1103 CIPP SEWER ON 500 EAST BETWEEN SOUTH TEMPLE AND 100 SOUTH 3 5 105,000
10401 525002892 2016-1104 CIPP SEWER ON SLADE PL AND 500 EAST 3 5 32,000
10401 525002902 2016-1105 CIPP SEWER ON 300 SOUTH AND 300 EAST 3 5 642,000
10401 525002908 2016-1110 CIPP ON A STREET BETWEEN SOUTH TEMPLE AND FIRST AVE 3 5 65,000
10401 525002903 2016-1112 CIPP SEWER ON 200 EAST BETWEEN 200 SOUTH AND 300 SOUTH 3 5 60,000
10401 525002889 2016-1113 CIPP SEWER ON 200 EAST BETWEEN 300 SOUTH AND 400 SOUTH 3 5 200,000
10401 525002885 2016-1114 CIPP SEWER ON 200 WEST FROM 200 NORTH TO 300 NORTH 3 5 15,000
10401 525002905 2016-1116 CIPP SEWER ON WEST TEMPLE BETWEEN 200 SOUTH AND 300 SOUTH 3 5 60,000
10401 525002896 2016-1117 CIPP SEWER ON 200 SOUTH BETWEEN REGENT ST AND STATE ST 3 5 90,000
10401 525002886 2016-1118 CIPP SEWER ON 200 SOUTH BETWEEN WEST TEMPLE AND MAIN ST 3 5 40,000
10401 525002890 2016-1119 CIPP SEWER ON 400 SOUTH BETWEEN WEST TEMPLE AND MAIN ST 3 5 70,000
10401 525002909 2016-1120 CIPP SEWER ON 400 SOUTH BETWEEN MAIN ST AND CACTUS ST 3 5 50,000
10401 525002906 2016-1121 CIPP SEWER ON MENLO AVE AND 800 EAST 3 5 no,no
10401 525002981 2016-1125 CIPP SEWER ON 650 EAST SIXTEENTH AVE 3 5 8,000 80,000
10401 525002983 2016-1128 CIPP SEWER ON NORTHCREST DR BETWEEN I STREET AND ALOHA RD 3 5 5,000 50,000
10401 525002984 2016-1130 CIPP SEWER ON C STREET BETWEEN TENTH AVE AND ELEVENTH AVE 3 5 13,000 130,000
10401 525002943 2016-1141 CIPP SEWER ON J STREET BETWEEN EIGHTH AVE AND NINTH AVE 3 5 4,000 40,000
10401 525002944 2016-1143 CIPP SEWER ON A STREET FROM SIXTH AVE TO SEVENTH AVE 3 5 5,000 50,000
10401 525002945 2016-1146 CIPP SEWER AT 2930 EAST OQUIRRH DR 3 5 16,000 160,000
10401 525002946 2016-1147 CIPP SEWER ON 2725 EAST ST MARY'S WAY 3 5 28,000 280,000
10401 525002947 2016-1148 CIPP SEWER AT 3050 EAST SHERWOOD DR 3 5 5,000 50,000
10401 525002948 2016-1150 CIPP SEWER ON 1470 SOUTH CANTERBURY DR 3 5 5,000 50,000
10401 525002949 2016-1151 CIPP SEWER ON 1515 SOUTH DEVONSHIRE DR 3 5 6,500 65,000
48
SEWER UTILITY BUDGET
Five Year Projected Budget 2022-2026
u z
z z
F F
CAP rc PAST
COST PROJECT REQUEST PROJECT DESCRIPTION j'_ z BUDGET 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 DELAYED
CENTER NUMBER NUMBER 0 YEAR
p 2020-21
z
O
10401 2016-1159 CIPP SEWER FROM 1785 SOUTH FOOTHILL DR TO BLAINE AVE
10401 525002950 2016-1182 CIPP SEWER ON EMERSON AVE FROM 2300 EAST TO FOOTHILL 3 5 3,500 35,000
10401 525002951 2016-1170 CIPP SEWER BETWEEN 1811 SOUTH FOOTHILL AND 1845 SOUTH FOOTHILL DR 3 5 30,000 300,000
10401 525002952 2016-1243 CIPP SEWER ON 2100 SOUTH BETWEEN MCCLELLAND ST AND 1100 EAST 3 5 4,000 11111111111116 45,000
10401 525002953 2016-1196 CIPP SEWER FROM 2400 EAST KENSINGTON AVE TO 2440 EAST KENSINGTON AVE 3 5 8,00opw 80,000
10401 525002954 2016-1199 CIPP SEWER ON 800 EAST FROM PARKWAY AVE TO FAIRMONT CIR 3 5 25,000 230,000
10401 525002955 2016-1205 CIPP SEWER ON 600 WEST BETWEEN 100 SOUTH AND 200 SOUTH 3 5 7,000 60,000
10401 525002956 2016-1210 CIPP SEWER ON KENDEN DR AND SCENIC DR 3 5 3,500 35,000 _
10401 525002957 2016-1211 CIPP SEWER AT PARLEYS WAY AND MAYWOOD DR 3 5 4,500 45,000
10401 525002958 2016-1217 CIPP SEWER ON GARFIELD AVE FROM 2130 EAST GARFIELD TO CONNER ST 3 5 3,500 35,000
10401 525002960 2016-1220 CIPP SEWER ON HANNIBAL ST FROM W ILMINGTON AVE TO PARLEYS CANYON BL 3 5 10,000 100,000
10401 525002962 2016-1221 CIPP SEWER SUGAR HOUSE PARK(1630 E 2100 S) 3 5 30,000 300,000
10401 525002963 2016-1227 JW SEWER ON 900 EAST BETWEEN FAIRMONT CIR AND STRATFOR 3 5 7,000 70,000
10401 525002959 2016-1237 CIPP SEWER ON CLAYBOURNE AVE FROM 1300 EAST TO ALDEN ST 3 5 15,000 130,000
10401 525002964 2016-1238 CIPP SEWER ON 1000 EAST BETWEEN 2700 SOUTH AND 2800 SOUTH 3 5 70,000 70,000
10401 2016-1240 CIPP SEWER ON MCCLELLAND ST AT CRANDAL AVE 3 5 35,000
10401 525002967 2016-1254 CIPP SEWER 745 SOUTH GUARDSMAN WAY 3 5 5,000 50,000
10401 2015-0683 8TH AVE-FROM M ST TO L ST 3 4 22,000
10401 525002961 2016-0872 800 W 100 N TO 100 S BOTH SIDES 3 5 20,000 200,000
10401 525002969 2016-0907 600 W 300-400 N EAST SIDE 3 5 5,000 240,000
10401 2016-0963 CIPP SEWER LINE PROJECT FROM 1038 EAST NORTH BONNEVILLE DR TO 760 NORTH NORTHLAI 3 4 25,000
10401 2016-0836 2600 E BLAINE AVE TO FOOTHILL 2 5 100,000
10401 525002965 2016-0740 SOUTH TEMPLE FROM 1410 EAST TO 1380 EAST 3 5 6,000 40,000
10401 525002446 2016-0896 700 WEST FROM 250 NORTH TO 300 NORTH 4 5 25,000 250,000
10401 525002973 2016-0970 CIPP SEWER LINE FROM 300 WEST TO 260 WEST ON REED AVE 3 5 4,000 40,000
10401 525002966 2016-0971 CIPP SEWER LINE ON 200 WEST FROM 600 NORTH TO GIRARD AVE 3 5 4,000 40,000
10401 2016-0972 CIPP SEWER VIRGINIA ST FROM MH 22062 TO POPPERTON WAY 3 4 25,000
10401 525002974 2016-0973 CIPP SEWER ON SEVENTH AVE FROM H STREET TO I STREET 3 5 5,000 50,000
10401 525002972 2016-0975 CIPP SEWER IN INTERNATIONAL CENTER ON NEIL ARMSTRONG ROAD 3 5 12,000 120,000
10401 2016-0976 CIPP SEWER ON DONNER WAY AND DONNER CIRCLE 3 4 20,000
10401 2016-0978 CIPP SEWER ON OAK HILLS WAY 3 4 66,000
10401 2016-0984 CIPP SEWER ON WILTON WAY TO SHERWOOD DR 3 4 110,000
10401 525002968 2016-0985 CIPP SEWER ON ROXBURY ROAD 3 5 5,000 55,000
10401 525002970 2016-0986 CIPP SEWER ON APACHE CIRCLE 3 5 5,000 50,000
10401 2016-0996 CIPP SEWER 1700 SOUTH AND FOOTHILL DR 3 4 85,000
10401 525002971 2016-1000 CIPP SEWER ON 1700 SOUTH INDUSTRIAL ROAD 3 5 3,000 30,000
10401 525002976 2016-1022 CIPP SEWER ON BRYAN AVE FROM 1000 EAST TO 1100 EAST 3 5 8,000 80,000
10401 525002977 2016-1023 CIPP SEWER ON 1200 EAST FROM WOOD AVE TO MILTON AVE 3 5 20,000 200,000
10401 2016-1025 CIPP SEWER 1700 SOUTH 2100 EAST 3 4 50,000
10401 2016-1029 CIPP SEWER ON 1100 EAST FROM MICHIGAN AVE TO HERBERT AVE 3 5 90,000
10401 2016-1034 CIPP SEWER ON WHITLOCK AVE FROM HIGHLAND DR TO DOUGLAS ST 3 4 40,000
10401 2016-1037 CIPP SEWER ON HOLLYWOOD AVE BETWEEN 1800 EAST AND 1900 EAST 3 3 55,000
10401 2016-1043 CIPP SEWER ON 200 EAST AND 100 SOUTH 3 5 200,000
10401 2016-1045 CIPP SEWER ON WEST TEMPLE BETWEEN SOUTH TEMPLE AND 100 SOUTH 3 5 200,000
10401 2016-1046 CIPP SEWER ON 100 SOUTH STATE STREET 3 5 250,000
10401 2016-1060 CIPP SEWER ON 800 EAST FROM SIMPSON AVE TO WILMINGTON AVE 3 5 200,000
10401 2016-1061 CIPP SEWER ON THIRD AVE FROM O ST TO P ST 3 4 70,000
10401 2016-1074 CIPP SEWER ON SOUTH TEMPLE FROM P ST TO Q ST 3 5 900,000
10401 2016-1076 CIPP SEWER ON 900 EAST FROM SOUTH TEMPLE TO 100 SOUTH 3 4 40,000
10401 2016-1079 CIPP SEWER ON 200 SOUTH 1300 EAST TO UNIVERSITY 3 4 40,000
10401 2016-1082 CIPP SEWER ON LINDEN AVE AND 1000 EAST 3 5 40,000
10401 2016-1083 CIPP SEWER ON 900 EAST BETWEEN 300 SOUTH AND 400 SOUTH 3 4 400,000
10401 2016-1084 CIPP SEWER ON GILMER DR 3 4 80,000
10401 2016-1085 CIPP SEWER ON 1900 EAST FROM HERBERT AVE TO YALE AVE 3 5 60,000
10401 2016-1087 1700 SOUTH AND 1700 EAST SEWER REHAB 3 4 75,000
10401 2016-1088 CIPP SEWER ON FAYETTE AVE AND WEST TEMPLE 3 5 50,000
10401 2016-1109 CIPP SEWER ON ELY PL AND 700 EAST 3 5
10401 2016-1010 CIPP SEWER ON 1000 EAST FROM SOUTH TEMPLE TO 100 SOUTH 3 4 55,000
10401 2016-1111 CIPP SEWER ON 200 EAST FROM 250 SOUTH TO 300 SOUTH 3 5 200,000
10401 2016-1115 CIPP SEWER ON 200 NORTH BETWEEN WEST TEMPLE AND ALMOND ST 3 4 110,000
10401 2016-1122 CIPP SEWER ON EDGEHILL ROAD AND LITTLE VALLEY ROAD 3 5 35,000
10401 2016-1124 CIPP SEWER ON NORTHMONT WAY AND EIGHTEENTH AVE 3 5 60,000
10401 2016-1126 CIPP SEWER ON TERRACE HILLS DR BETWEEN NORTHCREST DR AND NORTH BONNEVILLE 3 5 90,000
10401 2016-1132 CIPP SEWER ON NINTH AVE BETWEEN K STREET AND L STREET 3 4 70,000
10401 2016-1140 CIPP SEWER ON DORCHESTER DR FROM BRAEW ICK RD TO SANDRUN RD 3 5 70,000
10401 2016-1142 CIPP SEWER ON B STREET FROM SIXTH AVE TO SEVENTH AVE 3 5 300,000
10401 2016-1145 CIPP SEWER ON DONNER WAY FROM THACKERAY PL TO SHAKESPEARE PL 3 5 40,000
49
SEWER UTILITY BUDGET
Five Year Projected Budget 2022-2026
u �
z z
F F
CAP rc PAST
COST PROJECT REQUEST PROJECT DESCRIPTION j'_ z BUDGET 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 DELAYED
CENTER NUMBER NUMBER YEAR
2020-21
10401 2016-1152 CIPP SEWER ON KENSINGTON AVE AND BEACON DR 3 4 100,000
10401 2016-1153 CIPP SEWER ON CANTERBURY DR FROM LANCASTER DR TO WILTON WAY 3 5 70,000
10401 2016-1156 CIPP SEWER ON UTE DR FROM INDIAN HILL CIRCLE TO EAGLE WAY 3 4 60,000
10401 2016-1157 CIPP SEWER ON COMANCHE DR AND EAGLE WAY 3 5 15,000
10401 2016-1158 CIPP SEWER ON WASATCH DR BETWEEN 1700 SOUTH AND SKYLINE DR 3 5 150,000
10401 2016-1172 CIPP SEWER FROM 1911 SOUTH FOOTHILL TO 1975 SOUTH FOOTHILL 3 4 19,000
10401 2016-1198 CIPP SEWER ON BLAINE AVE AND TEXAS ST 3 5 90,000
10401 2016-1207 CIPP SEWER ON INDUSTRIAL AVE AND 1700 SOUTH 3 5 15,000
10401 2016-1209 CIPP SEWER ON 2300 EAST BETWEEN CLUBHOUSE DR AND MAYWOOD DR 3 5 30,000
10401 2016-1212 CIPP SEWER FROM 2526 EAST COMMONWEALTH TO WYOMING ST 3 5 35,000
10401 2016-1213 CIPP SEWER ON 2000 EAST BETWEEN WILSON AVE AND DOWNINGTOWN AVE 3 5 60,000
10401 2016-1214 CIPP SEWER FROM 1838 EAST DOWNINGTOWN AVE TO 1800 EAST 3 5 70,000
10401 2016-1215 CIPP SEWER ON 2100 EAST FROM WILSON AVE TO DOWNINGTOWN AVE 3 4 25,000
10401 2016-1229 CIPP SEWER ON GLENMARE ST BETWEEN STRATFORD AVE AND 2700 SOUTH 3 5 19,000
10401 2016-1241 CIPP SEWER ON HUDSON AVE BETWEEN HIGHLAND DRIVE AND 1400 EAST 3 5 100,000
10401 2016-1242 CIPP SEWER ON SYLVAN AVE BETWEEN 1900 EAST AND 2000 EAST 3 4 40,000
10401 2016-1245 CIPP SEWER ON THIRD AVE AT CANYON ROAD 3 5 80,000
10401 2016-1246 CIPP SEWER ON STATE STREET BETWEEN 126 N AND 200 NORTH 3 4 100,000
10401 2016-1248 CIPP SEWER ON C STREET BETWEEN FIFTH AVE AND SIXTH AVE 3 5 180,000
10401 2016-1256 CIPP SEWER ON UNIVERSITY BLVD(500 S)FROM 1500 EAST TO GUARDSMAN WAY 3 4 70,000
10401 2015-0309 500 SOUTH-3415 WEST TO 3600 WEST 3 3 224,000
10401 2016-0821 ELGIN AVE 1000 E-950 E 2 4 250,000
10401 2016-0967 8-IN CIPP SEWER LINE FROM CAMBRIDGE WAY TO 1330 EAST PERRYS HOLLOW 3 4 80,000
10401 2016-0974 CIPP SEWER ON 1500 WEST FROM TALISMAN DR TO 895 NORTH 3 4 100,000
10401 2016-0977 CIPP SEWER BONNEVILLE DR 3 3 70,000
10401 2016-0982 CIPP SEWER AT ST MARY'S WAY AND OQUIRRH DRIVE 3 4 110,000
10401 2016-1006 CIPP SEWER ON 4TH AVE FROM VIRGINIA ST TO U ST 3 5 55,000
10401 2016-1007 CIPP SEWER ON FORT DOUGLAS CIRCLE 3 5 30,000
10401 2016-1053 CIPP SEWER ON KRISTIANNA CIR AND VIRGINIA ST 3 5 120,000
10401 2016-1054 CIPP SEWER ON ROUNDTOFT DR TO EAST CAPITOL BLVD 3 5 80,000
10401 2016-1062 CIPP SEWER ON SECOND AVE FROM L STREET TO M STREET 3 5 40,000
10401 2016-1127 CIPP SEWER ON 550 EAST NORTHHILLS DR 3 5 100,000
10401 2016-0969 CIPP SEWER LINE ON 300 WEST FROM 400 NORTH TO BISHOP PL. 3 4 25,000
10401 2016-1066 CIPP SEWER ON M STREET BETWEEN FIRST AND SECOND AVE 3 5 260,000
10401 2016-0870 Easement North of Oquirrh Dr 3 4 50,000
10401 2017-2021 800 South 1200 East 2 5 80,000
10401 2017-1302 LEARNED AVE 1034 TO 1000 WEST 3 5 100,000
10401 2017-2023 400 East 2100-1700 South 4 5 500,000
10401 525002922 2017-2040 1210 WEST PACIFIC AVE 3 5 200,000
10401 2017-2036 350 West 600 South North Side 4 5 150,000
10401 2017-2037 1000 East Logan Ave 3 5 110,000
10401 2017-2038 700 to 800 West 300 North North Side 3 5 300,000
10401 2017-2041 420 South 700 West 2 5 50,000
10401 2017-2047 994 South Oak Hills 3 4 150,000
10401 2017-2123 4200 West North Temple 5 5 60,000 500,000
10401 525002923 2018-1046 YALE AVE-100 E to 200 E 3 5 300,000 80,000
10401 525002925 2019-1061 1300 S-LAIRD DRIVE 3 5 250,000 50,000
10401 2018-1001 190 East Social Hall 1 5 250,000
10401 2018-1008 CIPP on South Temple Between A and B Street 3 5 25,000
10401 2018-1009 CIPP on Q street from 4th ave to South Temple Including side shots 3 5 400,000
10401 2018-1010 CIPP on 3rd ave from C Street to E Street 2 5 90,000
10401 2018-1011 CIPP on 100 south from 750-800 West 2 5 75,000
10401 2018-1012 Spot Repair on Wasatch Drive at 1758 South 3 5 25,000
10401 2018-1021 Foothill Drive 1300-1000 South 4 5 200,000
10401 2018-1022 500 South,Main Street to State Street 1 2 40,000
10401 2018-1027 945 West 200 South 2 5 350,000
10401 2018-1039 900 East 100-200 South East Side 2 4 65,000
10401 2018-1042 100 South 800-700 East south side 3 4 65,000
10401 2018-1086 18th Ave 630-724 East 2 5 800,000
10401 2018-1087 Laird Ave 1300-1100 East 2 4 120,000
10401 2018-1088 400 South State to main North Side with Side Street 3 5 120,000
10401 2018-1097 CIPP State St and 500 S to 200 E and 100 S 4 4 2,000,000
10401 2018-1111 North Temple(from Main to West Temple)Capacity Project 4 4 600,000
10401 2019-1017 Downington Ave and 2500 East 3 3 60,000
10401 2019-1051 Harvard Ave-Major St to Main St 4 5 150,000
10401 2019-1058 CIPP on M Street 1st-4th ave 3 4 500,000
10401 2019-1059 CIPP 800 West 500 to 600 North 3 5 500,000
50
SEWER UTILITY BUDGET
Five Year Projected Budget 2022-2026
u z
z z
F F
CAP rc PAST
COST PROJECT REQUEST PROJECT DESCRIPTION j'_ z BUDGET 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 DELAYED
CENTER NUMBER NUMBER 0 YEAR
p 2020-21
z
O
10401 2019-1063 200 S Sewer Realignment 4 3 250,000
10401 2019-1064 300 West-500 South to 2100 South Roadway 4 5 2,800,000
10401 2019-1069 400 S 1000 W Sewer Replacement 3 4 450,000
10401 2019-1104 280 South 300 West 3 5 120,000
10401 2019-1139 Fulton Sewer Extension 1 0 680,000
10401 2019-1156 Pioneer Side Sewer Relocation 4 3 300,000
10401 2019-1180 600 South-MH 21371-MH 03058 4 5 60,000
10401 2020-1174 Pipe Replacement 200 S 900 W 4 5 500,000
10401 2020-1045 900 E Main Extension 1 0 300,000
POINT REPAIR PROGRAM(VARIOUS LOCATIONSI
10401 525002690 2015-0477 POINT REPAIRS IN SUPPORT OF CIPP PROGRAM(VARIOUS LOCATIONS) 3 5 400,000 350,000 350,000 350,000 350.000 11000,000
TOTAL COLLECTION LINES 12,606,500 2,845,000 2,065,000 16,900,000 13,500,000 4,900,000 5,800,000 99,045,000
MANHOLE REHAB PROGRAM(VARIOUS LOCATIONS
I
MANHOLE REHAB PROGRAM(VARIOUS LOCATIONS) 5 5 500,000 500,000 500.000 11000,000
10401 525002875 2015-0478 FY 2019-2020 Manhole Rehab Program(Various Locations) 4 5 450,000
450,000 0 0 500,000 0 500,000 500,000 1,000,000
OTHERPROJECTS
10401 CONTRIBUTIONS BY DEVELOPERS 5 5 500,000 --m
ow 0,000 500,000 500.000 500,000 500.000
10401 2016-1267 COLLECTION SYSTEM PROJECTS GENERAL SUPPORT-TASK 2 5 0 1,500,000 600,000 300,000
10401 525002841 EWO 20392 PROGRAM MANAGEMENT SERVICES-TASK 1 2 0 350,000
10401 525003006 R-20-0277 01 W W-Construction Management Support Services 5 0 1 200,000
2,350,000 1,300,000 800,000 500,000 500,000 500,000 500,000 0
MASTER PLAN IMPLEMENTATION PROGRAM
10401 525002850 2016-0926 MP11-State Street 500 South Diversion Improvement 5 5 3,000,000
10401 2016-0950 MP13-BECK STREET TRUNK REPLACEMENT FROM 500 SOUTH AND STATE STREET TO 700 SOU 5 3 20,000,000
10401 525002878 R19-0079 1800 North Sewer Realignment,Phase 1-Inverted Siphon 5 5 200,000 8,100,00
10401 525002879 R19-0082 1800 North Sewer Realignment,Phase 2-Trunk Sewer 5 5 100,000 8,250,00 6,250,000
10401 525002915 R19-0084 1800 North Sewer Realignment,Phase 3-Rehabilitation 5 5 5,000,000
10401 525002631 2015-0280 ORANGE STREET-PHASE IV-INDIANA TO 1500 SOUTH 5 4 1,200,000 9,000,000
10401 52490787 2015-0269 MP12D-700 SOUTH LIFT STATION(SS 10) 5 4 70,000
10401 2016-0929 MP16-600 WEST AND 700 SOUTH TO 500 WEST AND 800 SOUTH 5 5 30,000 2,500,000
10401 2016-0931 MP17B-MAIN STREET FROM 800 SOUTH TO 900 SOUTH 5 5 30,000 1,750,000
10401 2016-0940 MP19-FOLSOM AVENUE FROM 500 WEST TO 1000 WEST 5 5 30,000 13,500,000
10401 2016-0941 MP20-700 WEST FROM 900 SOUTH TO 600 SOUTH 5 4 30,000 5,500,000
10401 2016-0942 MP21-100 SOUTH AND 300 WEST DIVERSION 5 4 360,000
10401 2015-0322 MP28-NORTH TEMPLE-AIRPORT TO ORANGE STREET 4 4 16,250,000
10401 2016-0949 MP26-SOUTH TEMPLE AND 400 WEST DIVERSION 4 4 40,000 250,000
10401 525002577 2016-0849 MP15-700 SOUTH INTERCEPTOR CAPACITY UPGRADE 4 4 3,000,000
10401 525002584 2016-0905 MP7-100 SOUTH 1200 EAST DIVERSION FOR CAPACITY 4 4 350,000 300,000
10401 2016-0943 MP22-PIONEER ROAD FROM CALIFORNIA AVENUE TO 1500 SOUTH 4 4 40,000 9,000,000
10401 2016-0947 MP24-400 SOUTH FROM 300 WEST TO 600 WEST 4 3 3,000,000
10401 2016-0953 MP31-600 SOUTH FROM 800 WEST TO 900 WEST 4 3 2,000,000
10401 2016-0952 MP30-200 EAST FROM 300 SOUTH TO 500 SOUTH 4 3 2,000,000
10401 2016-0946 MP23-Parallel 1000 West Trunk 4 3 25,000,000
10401 2016-1195 MP29-BECK STREET TRUCK REPLACEMENT FROM 200 SOUTH AND 300 WEST TO STATE STREE 4 3 16,000,000
10401 2016-0841 500 S.PUMP AND THIRD FORCE MAIN INSTALLATION 5 1 18,000,000
10401 2016-0954 MP32-700 WEST FROM 700 SOUTH TO 500 SOUTH(EAST SIDE OF I-15) 4 3 3,000,000
10401 525002876 2016-0955 MP33-1300 EAST FROM 400 SOUTH TO 500 SOUTH 5 3 450,000
10401 2015-0660 SATELLITE TREATMENT PLANT 5 0 405,500,000
10401 2016-0948 MP25-Centennial Lift Station Discharge 1 0 3,000,000
10401 2019-1123 700 S.PUMP AND THIRD FORCE MAIN INSTALLATION 5 2 20,000,000
10401 2019-1085 2300 E/WILMINGTON AVE/YUMA ST UPSIZING PROJECT 5 4 80,000 350,000 3,500,000
10401 525003004 2019-1086 EMERY STREET UPSIZING PROJECT 4 5 60,000 550,000
10401 2016-0842 MP12B&C-500 South Capacity Upgrades(3400 West to Orange Street) 5 4 500,000 1,500,000 15,000,000
10401 525002940 2019-1082 2100 S CAPACITY UPGRADE PROJECT 5 5 750,000 7,750,000
10401 2019-1105 SOUTH TEMPLE UPSIZING PROJECT 5 5 250,000 2,000,000
10401 2019-1116 Gladiola Street Capacity Project 2 0 4,000,000
10401 2019-1117 Amelia Earhart Dr/Jimmy Doolittle Rd Upsizing Project 3 3 2,000,000
10401 2019-1118 2100 S Upsizing Project 3 3 1,500,000
10401 2019-1119 California Ave Upsizing Project 3 3 660,000
10401 2019-1120 Soulh Temple/200 E Upsizing Project 3 3 60,000 600,000
51
SEWER UTILITY BUDGET
Five Year Projected Budget 2022-2026
u u
z z
F F
CAP w PAST
COST PROJECT REQUEST PROJECT DESCRIPTION zi YEAR z BUDGET
CENTER NUMBER 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 DELAYED
NUMBER G
u o 2020-21
F z
K 0
u u
10401 2019-1121 700 S Upsizing Project 3 2 2,000,000
10401 2019-1122 N Wall St Upsizing Projed 3 2 500,000
10401 2020-1044 MP8B—3230 West Capacity Upgrades
7,920,000 24,180,00 11,310,000 1,810,000 3,200,000 1 14,040,000 15,060,000 578,170,000
Total Collection System 37,101,812 35,090,000 23,480,000 25,110,000 26,095,000 26,355,000 26,485,000 694,845,000
Total S—r(Collections+WRF) 176,580,725 226,135,82 166,619,252 157,103,748 1 77,847,603 26,455,000 26,485,000 696,370,000
52
SEWER UTILITY CAPITAL PURCHASES
Proje - - ,121-22
Cost Center Object Code Asset Description Budget Year 2021-22
275010 Automobiles & Trucks Amount
5210601 Ford E450 Camera Truck 220,000.00
5210601 Freightliner 1 14 Vactor 605,000.00
5211201 Electric vehicle 35,000.00
$ 860,000.00
275030 FIELD MAINTENACE EQUIPMENT Amount
5210601 Sewer hose disinfectant 20,000.00
5210601 Vaporooter 30,000.00
5210601 Cement Mixer 5,000.00
5211201 Articulating boom lift 125,000.00
5211201 Skid steer 70,000.00
5211201 Skid steer - auger attachment 10,000.00
5210601 CAT Backhoe replacement program 9,000.00
$ 269,000.00
276090 OTHER NON-MOTIVE EQUIPMENT
5211401 Sewer Video Server (SLCISMV) - for videos and photos so very large capacity 13,000.00
276020 TREATMENT PLANT EQUIPMENT
5211201 Replacement valves for digester gas (methane) carbon media filter at Co-Gen 20,000.00
5211201 Aeration basin drainage pump 45,000.00
5211201 Replacement gas (methane) blower for Co-Gen Engine 120,000.00
$ 198,000.00
Total 1,327,000.00
53
This page left intentionally blank.
54
Stormwater Utility-Budget Summary and Cash Flow
55
STORMWATER UTILITY BUDGET SUMMARY
FY 2022-2024
Rate increase 10% Rate increase 15% Rate increase 10%
AMENDED PROJECTED PROPOSED FORECAST FORECAST
ACTUAL BUDGET ACTUAL BUDGET BUDGET BUDGET
2019-20 2020-21 2020-21 2021-22 2022-23 2023-24
REVENUE&OTHER SOURCES
REVENUES
METERED SALES $ 10,424,070 $ 9,740,500 $ 9,740,500 10,714,550 $ 12,321,733 $ 13,553,906
INTEREST INCOME 129,047 199,670 199,670 119,200 105,800 84,300
OTHER REVENUES 74,273 53,000 53,000 64,000 64,000 64,000
TOTAL REVENUES $ 10,627,390 $ 9,993,170 $ 9,993,170 $ 10,897,750 $ 12,491,533 $ 13,702,206
OTHER SOURCES
GRANTS&OTHER RELATED REVENUES $ 141,153 $ 398,764 $ 398,764 $ 352,000 $ 352,000
SALE OF EQUIPMENT 6,851 4,000 4,000
COUNTY FLOOD CONTROL - - - - -
IMPACT FEES 488,389 389,000 389,000 389,000 389,000 389,000
SHORT-TERM FINANCING - - - - - -
BOND PROCEEDS - - 14,524,479 6,160,000 -
TOTAL OTHER SOURCES $ 636,393 $ 791,764 $ 15,316,243 $ 6,901,000 $ 741,000 $ 741,000
TOTAL REVENUE&OTHER SOURCES $ 11,263,783 $ 10,784,934 $ 25,309,413 $ 17,798,7591 $ 13,232,533 $ 14,443,206
EXPENSES&OTHER USES
EXPENDITURES
PERSONNEL SERVICES $ 2,900,729 $ 3,661,580 $ 3,661,580 $ 4,215,783 $ 4,384,413 $ 4,559,788
OPERATING&MAINTENANCE 255,137 228,808 228,808 232,408 237,056 241,796
TRAVEL&TRAINING 4,033 25,165 25,165 23,615 24,087 24,568
UTILITIES 303,268 242,998 242,998 264,318 269,604 274,996
TECHNICAL SERVICES 462,758 1,859,672 1,389,672 1,019,263 1,039,648 1,060,441
PUBLIC SERVICES/STREET SWEEPING 819,605 819,605 819,605 819,605 835,997 852,717
IMS SERVICES 472,952 455,000 455,000 802,400 818,448 834,817
FLEET MAINTENANCE 233,809 214,000 214,000 214,000 218,280 222,645
ADMINISTRATIVE SERVICE FEE 147,606 160,000 160,000 164,800 168,096 171,458
PAYMENT IN LIEU OF TAXES 100,434 124,259 124,259 133,525 136,196 138,920
BILLING COST 856,889 674,937 674,937 669,010 682,390 696,038
RISK MANAGEMENT 68,741 92,100 92,100 92,100 93,942 95,820
TRANSFERS TO GENERAL FUND - 4,000 4,000 4,000 4,080 4,162
OTHER CHARGES AND SERVICES (42,858) 51,458 51,458 49,215 50,200 51,205
TOTAL EXPENDITURES $ 6,583,103 $ 8,613,582 $ 8,143,582 $ 8,704,042 $ 8,962,437 $ 9,229,371
OTHER USES
CAPITAL OUTLAY $ 429,188 $ 382,000 $ 382,000 $ 218,000 S 218,000 $ 218,000
CAPITAL IMPROVEMENT BUDGET 4,389,476 11,933,745 9,143,000 8,530,500 5,225,000 5,430,000
COST OF DEBT ISSUANCE - - 23,570 34,200 - -
DEBT SERVICES 1,018,835 1,463,701 1,463,701 1,714,271 1,745,321 1,709,254
TOTAL OTHER USES $ 5,837,499 $ 13,779,446 $ 11,012,271 $ 10,496,971 $ 7,188,321 $ 7,357,254
TOTAL EXPENSE&OTHER USES $ 12,420,602 $ 22,393,028 $ 19,155,853 $ 19,201,013 $ 16,150,758 $ 16,586,625
EXCESS REVENUE AND OTHER
SOURCES OVER(UNDER)USES $ (1,156,819) $ (11,608,094) $ 6,153,560 $ (1,402,263) $ (2,918,225) $ (2,143,419)
OPERATING CASH BALANCES
BEGINNING JULY 1 $ 7,815,254 $ 7,504,567 $ 7,504,567 $ 13,658,127 $ 12,255,864 $ 9,337,639
RESTRICTED/DESIGNATED $ 846,132 $ - $ - $ - $ - $ -
AVAILABLE JUNE 30 $ 7,504,567 $ (4,103,527) $ 13,658,127 $ 12,255,864 $ 9,337,639 $ 7,194,220
Cash Reserve Ratio 1 14% -48% 168% 141% 104% 78%
Cash reserve goal above 14%
56
STORMWATER UTILITY CASH FLOW
FY 2022 BUDGET / FY 2023-2026 FORECAST
ACTUAL PROJECTED BUDGET BUDGET BUDG BUDGET BUDGET
YEAR YEAR YEAR YEAR YEAR YEAR YEAR
2019-2020 2020-20 2021-2022 2022-2
�E&
REVENUE
STORMWATER CHARGES $ 10,424,070 $ 9,740,500 $ 10,714,550 $ 12,321,733 $ 13,553,906 $ 14,909,297 $ 14,909,297
OTHER INCOME 74,273 53,000 64,000 64,000 64,000 64,000 64,000
INTEREST INCOME 129,047 199,670 119,200 105,800 84,300 68,600 67,800
OPERATING INCOME $ 10,627,390 $ 9,993,170 $ 10,897,750 $ 12,491,533 $ 13,702,206 $ 15,041,897 $ 15,041,097
OPERATING EXPENDITURES
OPERATING EXPENDITURES $ (6,583,103) $ (8,143,582) $ (8,704,042) $ (8,962,437) $ (9,229,371) $ (9,505,151) $ (9,790,098)
NET INCOME EXCLUDING DEP. $ 4,044,287 $ 1,849,588 $ 2,193,708 $ 3,529,096 $ 4,472,835 $ 5,536,746 $ 5,250,999
OTHER INCOME&EXPENSE
IMPACT FEES $ 488,389 $ 389,000 $ 389,000 $ 389,000 $ 389,000 $ 389,000 $ 389,000
NET BOND PROCEEDS - 74,500,000 6,125,000 - - - -
COST OF ISSUANCE(PROCEEDS) 24,479 35,000
COST OF ISSUANCE(EXP.) - (23,570) (34,200) - - - -
OTHER CONTRIBUTIONS 141,153 398,764P(l
352,000 352,000 352,000 352,000 352,000
SALE OF EQUIPMENT 6,851 4,000 - - - - -
CAPITAL OUTLAY (429,188) (382,000) (218,000) (218,000) (218,000) (218,000) (218,000)
SHORT-TERM DEBT -
DEBT SERVICE(NEW) 60,000) (191,000) (191,000) (341,000) (341,000)
DEBT SERVICE $ (1,018,835) $ (1,463,701) $ (1,554,271) $ (1,554,321) $ (1,518,254) $ (1,466,376) $ (1,465,499)
OTHER INCOME&EXPENSE $ (811,630) $ 13,446,972 $ 4,934,529 $ (1,222,321) $ (1,186,254) $ (1,284,376) $ (1,283,499)
CAPITAL GENERATION
GENERATED FOR CAPITAL $ 3,232,657 $ 15,296,560 $ 7,128,237 $ 2,306,775 $ 3,286,581 $ 4,252,370 $ 3,967,500
CAPITAL IMPROVEMENTS
CAPITAL IMPROVEMENTS $ (4,389,476) $ (9,143,000) $ (8,530,500) $ (5,225,000) $ (5,430,000) $ (4,430,000) $ (4,130,000)
BEGINING CASH BALANCE $ 7,815,254 $ 7,504,567 $ 13,658,127 $ 12,255,864 $ 9,337,639 $ 7,194,220 $ 7,016,590
CASH INCREASE/(DECREASE) $ (1,156,819) $ 6,153,560 $ (1,402,263) $ (2,918,225) $ (2,143,419) $ (177,630) $ (162,500)
RESTRICTED/DESIGNATED $ 846,132 $ - $ - $ - $ - $ - $ -
ENDING CASH AVAILABLE $ 7,504,567 $ 13,658,127 $ 12,255,864 $ 9,337,639 $ 7,194,220 $ 7,016,590 $ 6,854,090
Cash Reserve Ratio 101% 168% 141% 104% 78% 74% 70%
DEBT SERVICE COVERAGE 3.97 1.26 1.28 2.06 2.62 3.34 2.91
RATE CHANGE 10% 0% 10% 15% 10% 10% 0%
Revenue 11,256,932 25,309,413 17,798,750 13,232,533 14,443,206 15,782,897 15,782,097
DEBT SERVICE %OF GROSS OPERATING REVENUE 10% 15% 16% 14% 12% 11% 12%
RESIDENTIAL BILL FOR 1 ERU(or.25 acre) 5.43 5.43 5.98 6.88 7.57 8.33 8.33
57
53 2022 DRAFT 2 Cashflow Storm.xlsx
STORMWATER CIP BUDGET
Five Year Projected Budget 2022-2026
C9 0
z z
� F
OBJECT -11116
COST CODE/ CAP REQUEST PROJECT DESCRIPTION z 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 DELAYED
CENTER PROJECT NUMBER 7
NUMBER ~
U O
F z
O
U
53-10301 2720.05 LIFT STATIONS
10301 2020-1121 VARIOUS PUMP STATIONS 5 5 50,000 100,000 100,000 100,000 100,000
10301 53471040 SWEDE TOWN LIFT STATION 3 0 700,000
10301 2020-1144 NORTHWEST DRAIN LIFT STATION RECONSTRUCTION 5 4 2,020,000
10301 2015-0140 OIL DRAIN LIFT STATION-GABION BASKETS RECONSTRUCTION 5 4 58,000
$ 50,000 $ 700,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 2,078,000
53-10301 2730.20 DETENTION BASINS
10301 2020-1122 VARIOUS DETENTION BASINS 1 1 1 50,000 50,000 50,000 50,000 50,000
10301 534720007 2019-1135 DETENTION BASIN 15 DEEPENING(700 NORTH 400 W DETENTION BASIN REHABIL 4 4 140,000
$ 140,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ -
53-10301 2730.12 COLLECTION MAINS
10301 2020-1123 VARIOUS COLLECTION MAINS 4 5 130, 130,000 130,000 130,000 130,000
10301 534701035 2019-1110 SOUTH TEMPLE-R STREET TO 800 EAST STORM DRAIN ASSESSMENT AND REHI 4 5 300,000 550,00
10301 534701047 2019-1124 FULTON AVE STORM DRAIN 4 5 125,000
10301 53470882 2017-2101 LEE DRAIN-PIPE OPEN CHANNEL WEST OF PIONEER ROAD 5 4 895,000 895,000
10301 53470974 ORANGE STREET STORM DRAIN-NORTH TEMPLE TO 1-80 5 0 500,000
10301 2015-0142 MIDDLE BRIGHTON RAILROAD CULVERT REHABILITATION 5 4 40,000 260,000
10301 2017-2034 RED BUTTE CREEK CULVERT AT 900 SOUTH-LINER 5 4 300,000
10301 534700998 2016-0746 ABANDONMENT OF STORMWATER DITCH FROM WARM SPRINGS ROAD TO THE 4 4 350,000 350,000
10301 534701029 2017-2098 PIPE REPLACEMENT AT 746 SOUTH ELIZABETH AND 750 S 1100 E 3 5 440,000
10301 2015-0131 REPAIR OUTLETS ON THE LEE DRAIN AT 4800 WEST 3 4 21,000 170,000
10301 53470970 2016-0853 DITCH BANK EROSION PROTECTION-600 NORTH 550 WEST 2 3 35,000 90,000
10301 534701000 2016-0750 1700 SOUTH STORM DRAIN,FROM 2100 EAST TO EMIGRATION CREEK 3 0 1,100,000 2,200,000
10301 53470994 CITY DRAIN CROSSING AT HUNTER STABLES 4 3 375,000
10301 53470988 7200 WEST AND NORTH TEMPLE CULVERT REPLACEMENT AND CANAL REHAB 4 4 1 250,000
$ 3,210,000 $ 4,221,000 $ 390,000 $ 430,000 $ 130,000 $ 130,000 $ 1,385,000
CITY,COUNTY,STATE AND MISC.DRIVEN PROJECTS
10301 53470979 PROGRAM MANAGEMENT TOOLS 5 5 150,000 160,000
10301 2020-1161 STORM DRAIN CITY/COUNTY/STATE PROJECTS 5 5 250,000 150,000 150,000 150,000 150,000 2,250,000
10301 534701051 2018-1017 SURPLUS CANAL ENCROACHMENT AND PERMITTING 5 5 50,000 50,0 50,000 50,000
10301 534700999 2015-0126 -210-CPMWTO 1700 SOUTH-PIPING OF OPEN DITCH k53
300,000
10301 534701028 2019-0118 900 SOUTH-900 WEST TO 300 WEST,WEST TEMPLE TO 900 EAST 200,000 1,122,500
10301 534701059 2019-1003 300 WEST-900 SOUTH TO 2100 SOUTH 11500,000
10301 534701060 2019-1006 900 EAST- HOLLYWOOD TO 2700 SOUTH 1,500,000
10301 534701057 2019-1007 100 SOUTH-NORTH CAMPUS DRIVE TO 900 EAST 275,000
10301 534701055 2020-1040 LOCAL STREETS DISTRICT FY21 100,000
10301 534701061 2019-1005 200 SOUTH-400 WEST TO 900 EAST 500,
10301 2020-1130 LOCAL STREETS DISTRICTS FY22 200,
10301 2019-1010 1100 EAST HIGHLAND,RAMONA TO WARNOCK 1,120,000
10301 2020-1131 1100 EAST-900 SOUTH TO RAMONA 765,000
10301 2020-1132 300 NORTH-300 WEST TO 1000 WEST 900,000
10301 2020-1133 LOCAL STREETS FY23 100,000
10301 2020-1137 VIRGINIA STREET-SOUTH TEMPLE TO11THAVE 1,200,000
10301 2020-1139 1300 EAST-2100 SOUTH TO 3000 SOUTH 1,500,000
10301 2020-1138 W TEMPLE-NORTH TEMPLE TO 400 SOUTH 250,000
10301 2020-1140 LOCAL STREETS FY24 100,000
10301 2020-1141 2100 SOUTH-700 EAST TO 1700 EAST 1,600,000
10301 2020-1142 1700 EAST-1700 SOUTH TO 2700 SOUTH 700,000
10301 2020-1143 LOCAL STWTS DISTRICT FY25 1 100,0001
$ 4,325,000 $ 2,172,500 $ 3,085,000 $ 3,250,000 $ 2,550,000 $ 2,250,000 $
PUBLIC UTILITY DEFINED PROJECTS
10301 2020-1125 VARIOUS PUBLIC UTILITY DEFINED PROJECTS 4 4 50,000 50,000 50,000 50,000 50,000
10301 2020-1162 CLEANOUT BOX REHABILITATION 4 5 100,000 100,000 100,000 100,0001 100,0001 100,000
58
STORMWATER CIP BUDGET
Five Year Projected Budget 2022-2026
(D 0
z z
� F
OBJECT
COST CODE/ CAP REQUEST PROJECT DESCRIPTION z 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 DELAYED
CENTER PROJECT NUMBER 7
NUMBER ~
U O
F z
O
U
10301 2016-1270 URBAN WETLAND TREATMENT FACILITY AT FAIRMONT PARK-PRE-DESIGN 3 0 20,000
10301 2016-0854 GREEN INFRASTRUCTURE AT HOOTEN BUILDING-ROOF DRAIN INFILTRATION 2 0 30,000
10301 53470973 2016-1086 STORMWATER QUALITY-DESIGN FOR MAJOR OUTFALLS 3 0 100,000
10301 2020-1164 STORMWATER QUALITY-RETROFITS 4 4 150,000 1691
100,000 100,000 100,000 100,000
10301 2020-1163 DITCH RECONSTRUCTION AND PHRAGMITE CONTROL 3 5 50 000 50,0 50,000 50,000 50,000 50,000
$ 450,000 $ 369,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ -
RIPARIAN CORRIDOR PROJECTS
10301 2020-1126 VARIOUS RIPARIAN CORRIDOR PROJECTS 175,000 200,000 250,000 250,000 250,000 250,000
10301 534700012 2020-1023 RIPARIAN CORRIDOR ASSESSMENT 75,000 50,000
10301 2015-0610 RED BUTTE AT 1300 EAST-RIPARIAN ENHANCEMENTS 4 0 650,000
$ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 650,000
LOCAL AREA PROJECTS(*WORK BY CITY CREWS)
10301 2020-1127 VARIOUS LOCAL AREA PROJECTS PROJECTS 5 5 100,000m 100,000 100,000 100,000 100,000 100,000
10301 534701006 2015-0439 AVENUE CROSSWALKS/SID VARIOUS STREETS-DIP STONE REPLACEMENT 3 4 50,000 50,000 50,000 50,000 50,000 50,000
10301 534701005 2015-0440 AVENUE CROSSWALKS AND ADA RAMPS 3 0 50,000 50,000 50,000 50,000 50,000 50,000
10301 534701004 2015-0438 CONTRIBUTIONS BY DEVELOPERS 3 0 400,000 400,000 400,000 400,000 400,000 400,000
$ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ -
MASTER PLAN PROJECTS
10301 VARIOUS MASTER PLAN PROJECTS 5 5 1 400,000 400,000 400,000 400,000
$ - $ - $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ -
TOTAL COLLECTION MAINS $ 8,835,000 $ 7,612,500 $ 5,025,000 $ 5,230,000 $ 4,230,000 $ 3,930,000 $ 2,035,000
2730.20 LANDSCAPING
10301 2020-1128 VARIOUS LANDSCAPING PROJECTS 50,000 50,000 50,000 50,000 50,000 50,000
10301 53470934 NORTHWEST OIL DRAIN 50,000
10200 2020-1043 900 SOUTH LANDSCAPING PROJECT 68,000 68,000
$ 118,000 $ 168,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $
TOTAL CAPITAL IMPROVEMENTS $ 9,143,000 $ 8,530,500 $ 5,225,000 1$ 5,430,000 $ 4,430,000 $ 4,130,000 $ 4,113,000
59
STORMWATER UTILITY CAPITAL PURCHASES
Proje - - -021-22
Cost Center Object Code Asset Description Budget Year 2021-22
275010 MOTIVE REPLACEMENT AUTOS & TRUCKS Amount
5310701 1 4 ton 4X4 with cover - new 34,000.00
5310301 Chevy or similar - new 35,000.00
5310201 Hydro vac 140,000.00
$ 209,000.00
275030 FIELD MAINTENACE EQUIPMENT Amount
5310201 CAT Backhoe replacement program 9,000.00
$ 9,000.00
Total $ 218,000.00
60
Street Lighting Utility-Budget Summary and Cash Flow
61
STREET LIGHTING UTILITY BUDGET SUMMARY
FY 2022-2024
AMENDED PROJECTED PROPOSED FORECAST FORECAST
ACTUAL BUDGET ACTUAL BUDGET BUDGET BUDGET
SOURCES 2019-20 2020-21 2020-21 2021-22 2022-23 2023-24
REVENUE&OTHER SOURCES
REVENUES
STREET LIGHTING FEES $ 4,232,826 $ 4,224,298 $ 4,097,569 $ 4,097,569 $ 4,097,569 $ 4,520,866
INTEREST INCOME 119,716 8,000 25,133 40,500 40,500 40,500
OTHER REVENUES 250 6,659 6,659 4,859 4,859 4,859
TOTAL REVENUES $ 4,352,792 $ 4,238,957 $ 4,129,361 $ 4,142,928 $ 4,142,928 $ 4,566,225
OTHER SOURCES
GRANTS&OTHER RELATED REVENUES $ - $ 27,841 $ 27,841 $ 27,841 $ 27,841 $ 27,841
TRANSFERS FROM GENERAL FUND - 21,788 21,788 20,000 20,000 20,000
IMPACT FEES - - - - -
BOND PROCEEDS - - - - - -
TOTAL OTHER SOURCES $ - $ 49,629 $ 49,629 $ 47,841 $ 47,841 $ 47,841
TOTAL REVENUE&SOURCES $ 4,352,792 $ 4,288,586 $ 4,178,990 $ 4,190,769 $ 4,190,769 $ 4,614,066
EXPENSES&OTHER USES
EXPENDITURES
PERSONNEL SERVICES $ 217,734 $ 225,667 $ 225,667 $ 357,390 $ 371,685 $ 386,553
OPERATING&MAINTENANCE 5,960 6,994 6,994 6,994 7,134 7,280
TRAVEL&TRAINING 2,954 3,000 3,000 3,000 3,060 3,122
UTILITIES 784,008 1,01 1,500 1,01 1,500 1,01 1,500 1,031,730 1,052,366
TECHNICAL SERVICES 2,018,825 1,593,115 1,593,115 1,827,704 1,864,259 1,901,546
IMS SERVICES 1,791 - - 3,040 3,101 3,164
FLEET MAINTENANCE - - - - - -
ADMINISTRATIVE SERVICE FEE 36,074 48,000 48,000 48,000 48,960 49,940
PAYMENT IN LIEU OF TAXES - 74,170 74,170 - - -
RISK MANAGEMENT 260 1,000 1,000 1,000 1,020 1,041
TRANSFERS TO GENERAL FUND - - - - - -
OTHER CHARGES AND SERVICES 4,231 8,786 8,786 7,498 7,648 7,804
TOTAL EXPENDITURES $ 3,071,837 $ 2,972,232 $ 2,972,232 $ 3,266,126 $ 3,338,597 $ 3,41 2,816
OTHER USES
CAPITAL OUTLAY $ - $ - $ - $ - $ - $ -
CAPITAL IMPROVEMENT BUDGET 1,029,503 2,256,414 2,256,414 2,240,000 2,240,000 2,240,000
DEBT SERVICES 103,437 191,834 191,834 193,537 193,585 193,562
TOTAL OTHER USES $ 1,132,940 $ 2,448,248 $ 2,448,248 $ 2,433,537 $ 2,433,585 $ 2,433,562
TOTAL EXPENSE&OTHER USES $ 4,204,777 $ 5,420,480 $ 5,420,480 $ 5,699,663 $ 5,772,182 $ 5,846,378
EXCESS REVENUE AND OTHER
SOURCES OVER(UNDER)USES $ 148,015 $ (1,131,894) $ (1,241,490) $ (1,508,894) $ (1,581,413) $ (1,232,312)
OPERATING CASH BALANCES
BEGINNING JULY 1 $ 5,280,952 $ 6,050,463 $ 6,050,463 $ 4,808,973 $ 3,300,079 $ 1,718,666
RESTRICTED/DESIGNATED $ 621,496 $ - $ - $ - $ - $ -
AVAILABLE JUNE 30 $ 6,050,463 $ 4,918,569 $ 4,808,973 $ 3,300,079 $ 1,718,666 $ 486,354
CASH RESERVE RATIO 197% 165% 162% 101% 51% 14%
Cash reserve goal above 14%
62
STREET LIGHTING UTILITY CASH FLOW
FY 2022 BUDGET / FY 2023-2026 FORECAST
ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET
YEAR YEAR YEAR YEAR YEAR YEAR YEAR
2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2026
REVENUE
STREET LIGHTING SALES $ 4,232,826 $ 4,097,569 $ 4,097,569 $ 4,097,569 $ 4,520,866 $ 5,155,812 $ 5,579,109
OTHER INCOME 250 6,659 4,859 4,859 4,859 4,859 4,859
INTEREST INCOME 119,716 25,133 40,500 40,500 40,500 40,500 40,500
OPERATING INCOME $ 4,352,792 $ 4,129,361 $ 4,142,928 $ 4,142,928 $ 4,566,225 $ 5,201,171 $ 5,624,468
OPERATING EXPENSES
OPERATING EXPENSES $ (3,071,837) $ (2,972,232) $ (3,266,126) $ (3,338,597) $ (3,412,816) $ (3,488,814) $ (3,566,645)
NET INCOME EXCLUDING DEP. $ 1,280,955 $ 1,157,129 $ 876,802 $ 804,331 $ 1,153,409 $ 1,712,357 $ 2,057,823
OTHER INCOME&EXPENSE
BOND PROCEEDS $ - $ - $ - $ - $ - $ - $ -
OTHER CONTRIBUTIONS - 49,629 47,841 47,841 47,841 47,841 47,841
CAPITAL OUTLAY - - - - - -
DEBT SERVICE (103,437) (191,834) (193,537) (193,585) (193,562) (193,528) (193,503)
OTHER INCOME&EXPENSE $ (103,437) $ (142,205) $ (145,696) $ (145,744) $ (145,721) $ (145,687) $ (145,662)
CAPITAL GENERATION
GENERATED FOR CAPITAL $ 1,777,578 $ 7,074,924 $ 731,106 $ 658,587 $ 1,007,688 $ 7,566,670 $ 1,972,167
CAPITAL IMPROVEMENTS
CAPITAL IMPROVEMENTS $ (7,029,503) $ (2,256,474) $ (2,240,000) $ (2,240,000) $ (2,240,000) $ (2,240,000) $ (2,240,000)
OPERATING CASH BALANCES
BEGINING CASH BALANCE $ 5,280,952 $ 6,050,463 $ 4,808,973 $ 3,300,079 $ 1,718,666 $ 486,354 $ (186,976)
CASH INCREASE/(DECREASE) 148,015 (1,241,490) (1,508,894) (1,581,413) (1,232,312) (673,330) (327,839)
RESTRICTED DESIGNATED 621,496 - - - -
ENDING BALANCE $ 6,050,463 $ 4,808,973 $ 3,300,079 $ 1,718,666 $ 486,354 $ 186,976 $ 514,815
Cash Reserve Ratio 176.7% 161.8% 101.0% 51.5% 14.3% -5.4% -14.4%
Debt Service Coverage 12.38 6.03 4.53 4.15 5.96 8.85 10.63
RATE CHANGE 0% 0% 0% 0% 10% 14% 8%
DEBT SERVICE %OF GROSS OP. REV. 2.4% 4.6% 4.7% 4.7% 4.2% 3.7% 3.4%
RESIDENTIAL BILL OF 1 ERU (or 75 ft) 3.73 3.73 3.73 3.73 4.23 4.98 5.48
63 Forecasted for FY 2022 Budget
48 2022 DRAFT Cashflow Street Lighting.xlsx
STREET LIGHTING UTIITY CIP BUDGET
Five Year Projected Budget 2022-2026
CURRENT
COST PROJECT BUDGET YEAR ESTIMATE FY 21-22 FY 22-23 FY 23-24 FY 24-2S FY 2S-26 FY 26-27 FY 27-28
CENTER NUMBER PROJECT DESCRIPTION 2019-20 BUDGETYEAR Projected Projected Projected Projected Projected Projected Projected
2020-21
48-48001 2730.80 Base Level Projects $ 1,700,000 $ 2,000,000 $ 1,900,000 $ 1,900,000 $ 1,900,000 $ 1,900,000 $ 1,900,000 $ 1,900,000 $ 1,900,000
Lighting Controls $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000
Master Plan Projects $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000
New SLCDPU Campus
48-48101 2730.80 TIER 1 Projects $ 5,000 $ 20,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000
48-48201 2730.80 TIER 2 Projects $ 5,000 $ 20,000 $ 40,000 1 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000
48-48301 2730.80 TIER 3 Projects $ 15,000 $ 200,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000
NUMBER OF PROJECTS 8 xx 6 6 6 6 6 6 6
TOTAL CAPITAL IMPROVEMENTS $ 1,725,000 $ 2,240,000 $ 2,240,000 $ 2,240,000 $ 2,240,000 $ 2,240,000 $ 2,240,000 $ 2,240,o00 $ 2,240,000
64
APPENDIX A: Rate Change Comparisons and Customer Impacts
65
Water Rate Chanme Comparisons
Comparison of Monthly Water Base Rate Options
for City Customers
Meter 2021 2022 Current to Proposed
Size Current Proposed
$
(inches) Rate Rate
3/4 9.28 10.03 0.75 8.08%
1 12.14 1 3.1 2 0.98 8.07%
1 1/2 19.29 20.84 1 .55 8.04%
2 27.88 30.12 2.24 8.03%
3 50.76 54.83 4.07 8.02%
4 76.50 82.62 6.12 8.00%
6 148.03 159.88 11 .85. 8.01
8 233.85 252.56 18.71 8.00%
10 605.76 654.23 48.47 8.00%
Comparison of Monthly Water Base Rate Options
for County Customers
Meter 2021 2022 Current to Proposed
Size Current Proposed $ %
(inches) Rate Rate
3/4 12.53 13.54 1 .01 8.08%
1 16.39 17.71 1 .32 8.07%
1 1/2 26.04 28.13 2.09 8.04%
2 37.64 40.66 3.02 8.03%
3 68.53 74.02 5.49 8.02%
4 103.28 111 .54 8.26 8.00%
6 199.84 215.84 16.00 8.01%
8 315.70 340.96 25.26 8.00%
10 817.78 883.21 65.431 8.00%
66
Comparison of Water Monthly Usage Rate Options
for City Residential Customers
2021 2022 Current to Proposed
Flat Rate or Current Rate Proposed
Block per ccf Rate per ccf
Winter Rate Structure (Noverrber - March)
Flat Rate 1 .37 1 .48 1 0.12 8.429/.
Summer Rate Structure ( April - October)
Block 1 1 .37 1 .48 0.12 8.42%
Block 2 1.87 2.02 0.15 8.08%
Block 3 2.59 2.81 0.22 8.35%
Block 4 1 2.76 1 2.99 1 0.23 8.27%
Comparison of Water Monthly Usage Rate Options
for County Residential Customers
2021 2021 Current to Proposed
Flat Rate or Current Rate Proposed
Block per ccf Rate per ccf $
Winter Rate Structure (Noverrber - March)
Flat Rate 1 .84 2.00 0.16 8.42%
Summer Rate Structure ( April - October)
Block 1 1 .84 2.00 0.16 8.42%
Block 2 2.52 2.73 0.20 8.08%
Block 3 3.50 3.79 0.29 8.35%
Block 4 3.73 4.04 0.31 8.27%
Rate Structure
Block Current
Flat Rate All Usage
Block 1 1 - 10 ccf
Block 2 1 1 - 30 ccf
Block 3 31 - 60 ccf
Block 4 >61 ccf
67
Comparison of Monthly Usage Rate Options
for City CII Customers
2021 2022 Current to Proposed
Flat Rate or Current Rate Proposed
Block per ccf Rate per ccf $
Winter Rate Structure (November- March)
Flat Rate 1 1.49 1 1.61 0.12 8.1
Summer Rate Structure ( April - October)
Block 1 1.49 1.61 0.12 8.1%
Block 2 2.04 2.21 0.17 8.3%
Block 3 2.84 3.07 0.23 8.1%
Block 4 3.01 3.26 0.25 8.3%
Comparison of Monthly Usage Rate Options
for County CII Customers
2021 2022 Current to Proposed
Flat Rate or Current Rate Proposed
Block per ccf Rate per ccf $
Winter Rate Structure (November- March)
Flat Rate 1 2.01 1 2.17 0.16 8.1%
Summer Rate Structure ( April -October)
Block 1 2.01 2.17 0.16 8.1%
Block 2 2.75 2.98 0.23 8.5%
Block 3 3.83 4.14 0.31 8.2%
Block 4 4.06 4.40 0.34 8.4%
Rate Structure
Block Current
Flat Rate All Usage
Block 1 0-AWC
Block 2 AWC-3000/o
Block 3 3000/o-6000/a
Block 4 >600%
C11= Commercial, Industrial,and Institutional
"AWC = Average Winter Consumption.
"AWC-3000/o" means usage greater than a
customer's AWC and less than or equal to
300% of the customer's AWC
68
Comparison of Water Monthly Usage Rate Options
for City Irrigation Customers
2021 2022 Current to Proposed
Flat Rate or Current Rate Proposed
Block per ccf Rate per ccf
Winter Rate Structure (November-March)
Flat Rate 1 1.80 1 1.94 1 0.14 8.00%
Summer Rate Structure( April-October)
Block 1 1.80 1.94 0.14 8.00%
Block 2 2.50 2.69 0.20 8.00%
Block 3 2.66 2.87 0.21 8.00%
Comparison of Water Monthly Usage Rate Options
for County Irrigation Customers
2021 2022 Current to Proposed
Flat Rate or Current Rate Proposed
Block per ccf Rate per ccf
Winter Rate Structure (November-March)
Flat Rate 1 2.42 1 2.62 1 0.191 8.00%
Summer Rate Structure( April-October)
Block 1 2.42 2.62 0.19 8.00%
Block 2 3.37 3.64 0.27 8.00%
Block 3 3.59 3.87 0.29 8.00%
Rate Structure
Block Current
Flat Rate All Usage
1 CCF-
Ta rg et
Block 1 1 Budget
Target
Budget up to
300%of
Target
Block 2 Budget
Over 300%
of Target
Block 3 Budget
*"Target budget"means the estimated amount of water consumed per
acre,as established by the Public Utilities Director or his/her designee
each year for customer based on factors including,but not limited to,
evapotranspiration,and considering efficient water practices.A different
target budget is established for each month of the irrigation season.
69
Proposed Water Rate Change Customer Impacts
Water Rate Change
Annual Impact on Select City Customers
2021 2022
Annual Meter Current $ %
Account Type Proposed Rate
Usage Size Rate Change Change
Residential
Minimum Use 72 ccf 3/4 210.00 226.92 16.92 8.06%
Residential Low
Use 96 ccf 3/4 242.88 262.44 19.56 8.05%
Residential
Medium Use 255 ccf 3/4 556.95 601.80 44.85 8.05%
Residential High
Use 838 ccf 1 2,016.94 2,182.24 165.30 8.20%
Industrial Use 96,476 ccf 2 155,257.60 167,877.40 12,619.80 8.13%
Commercial Use 1 1,597 ccf 2 18,227.45 19,701.73 1,474.28 8.09%
Water Rate Change
Monthly Impact on Select City Customers
2021 2022
Account Type Monthly Meter Current Proposed $ %
Usage Size Rate Rate Change Change
Residential
Minimum Use 6 ccf 3/4 17.50 18.91 1.41 8.06%
Residential Low
Use 8 ccf 3, 4 20.24 21.87 1.63 8.05%
Residential
Medium Use 21 ccf 3/4 46.41 50.15 3.74 8.05%
Residential High
Use 70 ccf 1 168.08 181.85 13.78 8.20%
Industrial Use 8,040 ccf 2 12,938.13 13,989.78 1,051.65 8.1 3%
Commercial Use 966 ccf 1 2 1,518.95 1,641.81 1 122.86 1 8.09%
70
Water Rate Change
Annual Impact on Select County Customers
2021 2022 11
Account Type Annual Meter Current Proposed $ %
Usage Size Rate Rate Change Change
Residential
Minimum Use 72 ccf 3/4 283.50 306.34 22.84 8.06%
Residential Low
Use 96 ccf 3/4 327.89 354.29 26.41 8.05%
Residential
Medium Use 255 ccf 3/4 751.88 812.43 60.55 8.05%
Residential High
Use 838 ccf 1 2,722.87 2,946.02 223.16 8.20%
Industrial Use 96,476 ccf 2 209,597.76 226,634.49 17,036.73 8.13%
Commercial Use I 1 1,597 ccf 1 2 1 24,607.06 1 26,597.34 1 1,990.28 1 8.09%
Water Rate Change
Monthly Impact on Select County Customers
2021 2022
Account Type Monthly Meter Current Proposed $ %
Usage Size Rate Rate Change Change
Residential
Minimum Use 6 ccf 3/4 2 3.63 25.53 1.90 8.06%
Residential Low
Use 8 ccf 3/4 27.32 29.52 2.20 8.05%
Residential
Medium Use 21 ccf 3/4 62.66 67.70 5.05 8.05%
Residential High
Use 70 ccf 1 226.91 245.50 18.60 8.20%
Industrial Use 8,040 ccf 2 17,466.48 18,886.21 1,419.73 8.13%
Commercial Use 966 ccf 1 2 1 2,050.59 1 2,21 6.44 1 165.86 1 8.09%
71
Sewer Rate Change Comparisons
Comparison of Monthly Sewer Class Rate Changes
Flow $ Per CCF
2021 2022 Current to Proposed
Class Current Rate Proposed $
Rate
1 2.70 3.19 0.49 18.1%
2 2.70 3.19 0.49 18.10/0
3 2.70 3.19 0.49 18.1%
4 2.70 3.19 0.49 18.1%
5 2.70 3.19 0.49 18.1%
6 1 2.701 3.191 0.49 18.1%
7 Special Rate by Customer
BOD $ Per CCF
2021 2022 Current to Proposed
Class Current Rate Proposed
$
Rate
1 0.95 1.12 0.17 17.9%
2 1.55 1.83 0.28 18.1%
3 2.55 3.01 0.46 18.0%
4 3.65 4.31 0.66 18.1%
5 4.58 5.40 0.82 17.9%
6 5.64 1 6.66 1.02 18.1%
7 Special Rate by Customer
TSS $ Per CCF
2021 2022 Current to Proposed
Class Current Rate Proposed
$
Rate
1 0.69 0.82 0.13 18.80/0
2 1.39 1.64 0.25 18.0%
3 2.37 2.80 0.43 18.1%
4 3.23 3.81 0.58 18.0%
5 1 4.201 4.96 0.76 8.10/0
6 5.09 1 6.00 0.91 1 17.9%
7 Special Rate by Customer
72
Total Sewer Rate Per CCF
2021 2022 Current to Proposed
Class Current Rate Proposed
Rate
1 4.34 5.13 0.79 1 8.2%
2 5.64 6.66 1.02 1 8.1%
3 7.62 9.00 1.38 1 8.1%
4 9.58 11 .31 1.73 18.1%
5 1 1.48 13.55 2.07 1 8.0%
6 13.43 15.85 2.42 1 8.0%
7 Special Rate by Customer
Class Structure
Block BOD Strength TSS Strength
mg/I mg/I
1 0-300 0-300
2 300-600 300-600
3 600-900 600-900
4 900-1200 900-1 200
5 1 200-1500 1200-1500
6 1 500-1 800 1500-1800
7 >1800 >1800
Current Minimum charge is 58.68. Proposed minimum charge is 510.26
73
Proposed Sewer Rate Change Customer Impacts
Sewer Rate Change
Annual Impact on Select City Customers
2021 2022
Annualized
Account Type Average Winter Current Rate Proposed Rate $ Changes % Change
Water Usage (CCF)
Residential Minimum Use 24 ccf 104.16 1 23.1 2 18.96 18.20%
Residential Low Use 48 ccf 208.32 246.24 37.92 18.20%
Residential Medium Use 96 ccf 416.64 492.48 75.84 18.20%
Residential High Use 180 ccf 781.20 923.40 142.20 18.20%
Industrial 2,4 24,168 ccf 277,448.64 327,476.40 50,027.76 1 8.03%
Commercial 2,1 408 ccf 5,479.44 6,466.80 987.36 1 8.02%
*Industrial & Commercial charges are calculated based on flow rate, BOD and TSS
Sewer Rate Change
Monthly Impact on Select City Customers
2021 2022
Annualized
Account Type Average Winter Current Rate Proposed Rate $ Changes % Change
Water Usage (CCF)
Residential Minimum Use 2 ccf 8.68 10.26 1.58 18.20%
Residential Low Use 4 ccf 17.36 20.52 3.16 18.20%
Residential Medium Use 8 ccf 34.72 41.04 6.32 18.20%
Residential High Use 15 ccf 65.10 76.95 11.85 18.20%
Industrial 2, 4 2,014 ccf 23,1 20.72 27,289.70 4,168.98 1 8.03%
Commercial 2,1 34 ccf 456.62 538.90 82.28 18.02%
*Industrial & Commercial charges are calculated based on flow rate, BOD and TSS
74
Stormwater Rate Change Comparisons
Comparison of Monthly Stormwater Rate Changes
2021 2022 Changes Current to
Pro osed
Account Type ERUs Current Rate Proposed $ %
Rate
Single and Duplex All ERU 5.43 5.98 0.55 10.1 3%
<.25 Acre
Single and Duplex
All ERU 7.60 8.36 0.76 10.00%
>.25 Acre
Triplex and Fourplex All ERU 10.87 11.96 1.09 10.03%
All other Parcels Per ERU 5.43 5.98 0.55 10.13%
*1 ERU = 1 residential property or 75 feet of street frontage for non-residential
properties
75
Proposed Stormwater Rate Change Customer Impacts
Stormwater Rate Change
Annual Impact on Select City Customers
2021 2022 Changes Current to
Proposed
Account Type ERUs Current Rate Proposed $
Rate
Residential less than
.25 Acre Any ERU 65.16 71.76 6.60 10.13%
Residential more than
.25 Acre Any ERU 91.20 100.32 9.12 10.00%
Industrial* 300 ERU 1,629.00 1,794.00 165.00 10.13%
Commercial 120 ERU 651.60 717.60 66.00 10.13%
Stormwater Rate Change
Monthly Impact on Select City Customers
2021 2022 Changes Current to
Pro osed
Account Type ERUs Current Rate Proposed $
Rate
Residential less than Any ERU 5.43 5.98 0.55 10.13%
.25 Acre
Residential more than
.25 Acre Any ERU 7.60 8.36 0.76 10.00%
Industrial 25 ERU 135.75 149.50 13.75 10.13%
Commercial 10 ERU 54.30 59.80 5.50 10.13%
76
APPENDIX B: Supplemental Information
77
Water Rates Compared With Nearby States
Comparison of AVERAGE
Recognizable Cities in Western States MONTHLY
RANKING City, State CHARGES
1 FLAGSTAFF,ARIZONA $130.84
2 BOISE,IDAHO $73.30
3 CHEYENNE,WYOMING $69.78
4 DENVER, COLORADO $58.61
5 RENO, NEVADA $51.14
6 LAS VEGAS, NEVADA $46.70
7 PHOENIX,ARIZONA $44.56
SALT LAKE CITY,UTAH (Proposed) 8% $40.17
8 SALT LAKE CITY,UTAH (Current) $37.17
9 HENDERSEN NEVADA $27.29
Cities compared with 7,480 gallons per month and 24,000 gallons summer usage
Based on eight months Winter and four months Summer usage
78
Sewer Rates Compared With Nearby States
COMPARISON OF AVERAGE
RECONIZABLE CITIES IN WESTERN STATES MONTHLY
RANKING City, State CHARGES
1 RENO, NV $49.53
2 BOISE, ID 46.72
3 (Proposed) 1
4 PHOENIX, AZ ** 39.50
5 LAS VEGAS, NV 38.90
6 SALT LAKE CITY 34.71
7 FLAGSTAFF, AZ 32.01
8 CHEYENNE, WY ** 30.82
9 DENVER, CO 28.96
10 IHENDERSONNV 1 25.78
Annual costs based on 12 months @ 5,984 gallons per month average winter water consumption
** includes Monthly base rate
79
Sewer Rates Compared With local Cities
ANNUAL
RANKING CITY OR DISTRICT NAME CHARGE *
1 CITY OF SOUTH SALT LAKE 646.27
SALT LAKE CITY (Proposed) 492.60
2 MAGNA CITY 416.19
3 WEST JORDAN CITY ** 411.21
4 KEARNS IMPROVEMENT DISTRICT ** 389.21
5 OGDEN CITY 386.40
6 MURRAY CITY ** 357.17
7 GRANGER- HUNTER IMPROVEMENT DISTRICT 342.75
8 MIDVALLEY IMPROVEMENT DISTRICT 332.09
9 SOUTH VALLEY SEWER DISTRICT 329.81
6 SALT LAKE CITY (Current) 311.65
11 TAYLORSVILLE-BENNION IMPROVEMENT DISTRICT ** 281.28
12 COTTONWOOD IMPROVEMENT DISTRICT 257.71
13 SANDY SUBURBAN IMPROVEMENT DISTRICT 246.81
14 MT OLYMPUS IMPROVEMENT DISTRICT 231.28
15 SOUTH DAVIS SEWER DISTRICT 189.86
* Annual cost based on 12 months @5,984 gallons per month average winter consumption. Flat rate based on monthly rate multiplied by
12.
** Includes monthly base rate'
80
Stormwater Rates Compared with local Cities
CURRENT
RANKING CITY NAME RATE
1 PLEASANT GROVE 14.41
2 PROVO 10.75
3 DRAPER CITY 9.00
4 OGDEN CITY 8.32
5 SOUTH JORDAN CITY 7.15
6 BOUNTIFUL CITY 7.00
7 MURRAY CITY 6.30
8 AMERICAN FORK 6.00
9 SANDY CITY 6.00
SALT LAKE CITY (PROPOSED) . .
10 WEST JORDAN CITY 5.86
11 SALT LAKE CITY (Current) 5.43
12 OREM 4.75
13 TAYLORSVILLE CITY 4.00
81
Public Utilities Department
Local Area Water Rate Comparison - November 2020
(Highest to Lowest Ranking)
YEARLY
MONTHLY MINIMUM RATE OVER MONTHLY WINTER @ SUMMER @ TOTAL TOTAL TAX
MINIMUM ALLOWANCE MINIMUM PER FLOURIDE 7,480 GAL 23,936 GAL WINTER SUMMER ON$200,000 TOTAL
RANKING CITY OR DISTRICT NAME CHARGE IN GALLONS ALLOWANCE GALLONS CHARGE PER MONTH PER MONTH CHARGES* CHARGES* PROPERTY CHARGES
1 PARK CITY-GRADUATED RATES(1) 52.07 0 6.49-10.94 1,000 110.31 286.28 882.5C 1145.12 2027.62
2 AMERICAN FORK-GRADUATED RATES(2) 16.49 3,000 3.59-5.06 1,000 33.65 115.80 26923 463.18 732.41
3 DRAPER CITY-GRADUATED RATES(3) 2025 0 2.05-3.71 1,000 39.08 97.00 312.65 388.01 700.66
4 OUTH JORDAN CITY-GRADUATED RATES(4) 30.00 0 2.00-2.50 1,000 45.33 84.09 362.64 336.36 699.00
5 WEST JORDAN CITY(11) 20.00 0 2.25-3.85 1,000 37.50 98.35 300.02 393.41 693.43
6 PLEASANT GROVE-GRADUATED RATES JD 22.94 5,000 2.78-5.81 1,000 29.83 109.06 238.68 436.23 674.91
SALT LAKE CITY-OUTSIDE OF ii i
7 OGDEN CITY-GRADUATED RATES(7) 22.55 0 1.90-2.91 1,000 38.26 88.28 306.05 353.12 659.18
8 RIVERTON CITY-GRADUATED RATES(5) 2.50 0 3.76-3.91 1,000 31.00 9534 24797 381.36 629.33
9 SALT LAKE CITY-OUTSIDE OF CITY 12.53 0 1.84-3.50 748 30.93 88.33 247.44 353.32 600.7
10 SANDY CITY-OUTSIDE OF CITY(8) 19.95 0 1.80-2.75 1,000 34.82 80.07 278.56 320.30 598.86
11 MAGNA-GRADUATED RATES(10) 18.10 6,000 2.08-2.65 1,000 1.02 22.20 57.91 177.59 231.64 207.29 616.52
KEARNS IMPROVEMENT DIST-GRADUATED RATES
12 9) 11.60 0 2.33-2.92 1,000 29.0 75.59 232.2 302.37 45.23 579.83
13 ANDY CITY-INSIDE OF CITY(12) 14.43 0 1.64-2.53 1,000 28.01 69.65 224.1 278.59 32.67 535.38
SALT LAKE CITY-INSIDE OF • •
14 SALT LAKE CITY-INSIDE OF CITY (13) 9.28 0 1.37-2.59 748 22.98 65.56 183.84 262.24 31.79 475.23
15 GRANGER-HUNTER IMPROVEMENT DISTRICT(14) 13.00 0 1.77-2.05 1,000 26.30 58.91 210.42 235.64 24.75 470.80
16 BOUNTIFUL CITY-RESIDENTIAL HIGH ELEVATION 23.57 5,000 1.98 1,000 28.48 61.06 227.84 244.25 472.10
17 CITY OF SOUTH SALT LAKE 19.00 5,000 2.25 1,000 2.00 26.58 63.61 212.64 254.42 467.06
18 PROVO 17.70 01.01-1.67 1,000 25.25 57.67 202.04 230.69 432.73
19 BOUNTIFUL CITY-RESIDENTIAL LOW ELEVATION 21.39 5,000 1.79 1,000 25.83 5529 20663 22114 427.78
20 JVWCD 3.00 0 1.85-2.74 1,000 16.84 57.90 13470 231.62 4026 406.58
21 OREM-GRADUATED RATES(17) 20.20 0 0.98-1.22 1,000 27.53 46.76 220.24 187.05 407.29
22 MURRAY CITY-GRADUATED RATES(16) 11.24 0 1.07-1.57 748 22.38 52.72 179.04 210.88 389.92
TAYLORSVILLE/BENNION IMPROVEMENT DISTRICT
23 15 9.00 0 1.43-1.87 1,000 20.35 51.12 162.78 204.48 6.16 373.42
82
Public Utilities Department
Local Area Water Rate Comparison - November 2020 Continued
(Highest to Lowest Ranking)
CALCULATION OF COMPARISONS
*BASED ON EIGHT MONTHS WINTER AND FOUR MONTHS SUMMER
(1)RATES ARE$6.49/THOUSAND FOR 0-5,000 GALLONS,$10.40/THOUSAND FOR 5,001-15,000 GALLONS,&$10.94/THOUSAND FOR 15,001-25,000 GALLONS
(2)RATES ARE$16.49 FOR 0-3,000 GALLONS,$3.59/THOUSAND FOR 3,001-6,000 GALLONS,$4.321THOUSAND FOR 6,000-9,000 GAL&$5.06/THOUSAND OVER 9,000 GALLONS
(3)RATES ARE$2.05/THOUSAND FOR 0-5,000 GALLONS,$3.46/THOUSAND FOR 5,001-20,000 GALLONS,&$3.711THOUSAND FOR 20,001-50,000 GALLONS
(4)RATES ARE$2.00/THOUSAND FOR 0-6,000 GALLONS,$2.25/THOUSAND FOR 6,001-17,000 GALLLONS&$2.50/THOUSAND FOR 17,001-42,000 GALLONS
(5)RATES ARE$3.76 FOR 0-5,000 GALLONS&$3.91/THOUSAND OVER 5,000 GALLONS
(6)RATES ARE$22.94 FOR 0-5,000 GALLONS,$2.78/THOUSAND FOR 5,001-10,000 GALLONS,$4.061THOUSAND FOR 10,001-15,000 GALLONS&$5.8VTHOUSAND OVER 15,000 GALLONS
(7)RATES ARE$1.90/THOUSAND FOR 0-6,000 GALLONS&$2.91/THOUSAND FOR 6,001-42,000 GALLONS
(8)RATES ARE$1.80/THOUSAND FOR 0-6,000 GALLONS&$2.75/THOUSAND FOR 6,001-40,000 GALLONS
(9)RATES ARE$2.33/THOUSAND FOR 0-10,000 GALLONS&$2.92/THOUSAND FOR 10,001-25,000 GALLONS
(10)RATES ARE$2.08/THOUSAND FOR 0-6,000 GALLONS,$2.33/THOUSAND FOR 6,001-18,000 GALLONS,&$2.651THOUSAND FOR 18,000-35,000 GALLONS
(11)RATES ARE$2.25/THOUSAND FOR 0-5,000 GALLONS,$3.651THOUSAND FOR 5,001-20,000 GALLONS,&$3.851THOUSAND FOR 20,001-50,000 GALLONS
(12)RATES ARE$1.64 FOR 0-6,000 GALLONS,$2.53/THOUSAND FOR 6,001-40,000 GALLONS
(13)INCLUDES METROPOLITAN WATER PROPERTY TAX
(14)RATES ARE$1.77/THOUSAND FOR 0-7,000 GALLONS,$1.901THOUSAND FOR 7,001-15,000 GALLONS&$2.05/THOUSAND FOR OVER 15,000 GALLONS
(15)RATES ARE$1.43/THOUSAND FOR 0-6,000 GALLONS&$1.87/THOUSAND FOR 6,001-25,000 GALLONS
(16)RATES ARE$1.07/HUNDRED FOR 0-8 HCF,$1.29/HUNDRED FOR 9-25 HCF&$1.57/HUNDRED FOR 26-49 HCF
(17)RATES ARE$.98/THOUSAND FOR 0-11,000 GALLONS,$1.22/THOUSAND FOR 11,001-34,000 GALLONS
83
AVERAGE MONTHLY BILL COMPARISON-WATER
RESIDENTIAL CLASS
SLC Rates Current-Other City Rates as of March 2020 (Average of 5,800 gallons a month)
Memphis,TN 1 .21
Phoenix,AZ $ 6.64
Dallas,TX 20.8
Salt Lake City,UT-Current $2 .63
Charlotte,NC $2 •90
Amarillo,TX 23.00
Salt Lake City,UT-Proposed 23.38
Arlington,TX $24. 4
Georgetown,TX $25. 5
Millwaukee,WI $2 .94
El Paso,TX $ 6.90
Albuquerque,NM $ 7.58
Louisville,KY $29.3
Fort Worth,TX $30. 4
Round Rock,TX $ 1.37
Cedar Park,TX $3 .56
Buda,TX $3 ,28
Oklahoma City,OK $ 2.55
Denver,CO 2.86
Tucson,AZ 34.24
Houston,TX M111111111111 $34.t2
Las Vegas,NV $35.1
San Antonio,TX $35. 2
Abilene,TX $3 .01
Pflugerville,TX $37•9
Lubbock,Tx $4 .11
Philadelphia,PA $40.2
Austin,TX $40.31
Atlanta,GA $ 1.14
Asheville,NC $41.58
Corpus Christi,TX $42.97
San Marcos,TX $49.1
Los Angeles,CA 49.5
Portland,OR $56.60
East Bay MUD/Oakland,CA $57
Kyle,TX 40. 6
Seattle,WA $63.17
San Diego,CA $65. 2
San Francisco,CA $74.80
$0 $10 $20 $30 84 $40 $50 $60 $70 $80
Average Monthly Bill Comparison -Wastewater Residential
SLC Rates Current-Other City Rates as of March 2018 (Average of 4,000 Gallons of Flow)
Memphis, TN $12.54
Milwaukee, WI $15. 3
Salt Lake City, UT- current - $17.23
Phoenix, AZ $ 7.61
Abliene, TX 418.20
El Paso, Tx $19.13
Amarillo, TX $19.43
Las Vegas, NV $19.76
Albuquerque, NM 16.32
Salt Lake City, UT- proposed $20.35
Oklahoma City, OK $17.61
San Antonio, TX $22.93
Philadelphia, PA $24.18
Los Angeles, CA $25.67
Dallas, TX 19.20
Round Rock, TX $z .83
Houston, TX $ 7.76
Fort Worth,TX $t7.92
Cedar Park,TX $29.68
Arlington, TX $30.82
Lubbock, TX $31.34
Kyle, TX $31.87
Georgetown, TX $32.00
Pfiugerville, TX $32.20
Asheville, NC $33.36
San Diego, CA $34.57
EB MUD/Oakland, CA $34.67
Corpus Christi,TX $39.10
Charlotte, INC $39.78
Austin, TX $40.48
San Marcos, TX $41.44
Tucson, AZ ir 1 $44.59
Louisville, KY $45.82
Portland, OR $59.73
Atlanta, GA $69.05
San Francisco, CA $70.82
Seattle, WA - $83.16
$0 $10 $20 $3085 $40 $50 $60 $70 $80 $90
Residential Water & Wastewater Bill
Percent of Median Household Income
(Austin Average Consumption & Flows as of March 2018 )
Phoenix,AZ 0.76%
Salt Lake City, UT-current 0.83%
Memphis,TN � 0 87% The percenta a of median household inc me was
Round Rock,TX 0.88 calculated by taking the results of each individual city's bill
Amarillo,TX 0.96% based on that city's rates and the usage of the Austin
Salt Lake City,UT-proposed M .98% average cons mption and flows. From those results,we
Georgetown,TX 0.99% divide the annual amount by the individu I city's 10 year
Pflugerville,TX 0.99% average medi n income.
Cedar Park,TX 1.10%
Alburquerque, NM 1.11% edian Income source:
Dallas,TX 1.13°
Buda,TX ' 1.16'°w^�w.deptof umbers.com/income/us/I
Arlington,TX 1.16%
Fort Worth,TX 1.18%
Las Vegas,NV 1.20%
El Paso,TX ------
Charlotte, NC EL 1 1.23%
Denver,Co 1.24%
Oklahoma City,OK 1.25%
Milwaukee,WI 1.25%
San Antonio,TX 1.39%
Kyle,TX 1.39%
Albiene,TX 1.39%
Houston,TX 1.46%
Austin,TX .47%
Los Angeles,CA 1.60%
San Diego,CA 1.62%
EB MUD/Oakland,CA 1.69%
Lubbock,TX 1 1.75%
San Francisco,CA 1.75%
Louisville, KY 1.76%
Corpus Christi,TX 1.77%
Philadelphia, PA 5 1.84%
Asheville, NC 1.87%
Portland,OR i 2.19%
Seattle,WA 2.24%
Tucson,AZ 2.31%
Atlanta,GA .47%
San Marcos,TX 3.02%
0.00% 0.50% 1.60% 1.50% 2.00% 2.50
Pubhc utofloKoMs
Operathg Revenue
$100
$90
$80
$70
$60
$50
� $40
$30
$20
$10
$0
10 ll 12 13 14 15 16 17 18 19 20 21 22
■WATER o SEWER �STORM STREETLIGHTS
I
WATER UTILITY
OPERATING COSTS
$90
❑Metro Assessment
,0 $80
~� $70 ❑Lieu of Tax Fee
$60 ❑City Admin. Fees
$50 ■Water Purchases
$40
❑O & M
$30
$20 ■Charges &
Services
$10 ■ Salaries
$0
N N N N N N N N N N N N N
O O O O O O O O O O O O O
89
SEWER UTILITY
OPERATING COSTS
$30
.� ■City Admin.Fees
$25
■Lieu of Tax Fee
$20
❑Payment for City
$1 5 Services
OO&M
$10
■Charges&Services
$5
■Salaries
$0
N N N N N N N N N N N N N
C O O O O O C O O O O O O
90
STORM WATER UTILITY
OPERATING COSTS
$10
❑Admistrative Service Fee
•� $9
$8 ■Payment for City Services
$7
■Payment in Lieu of Taxes
$6
5 ❑Street Sweeping
$4 ❑Operating&Maintenance
$3 supply
$2 ■Charges and Services
$1 ■Personnel Services
$0
N N N N N N N N N N N N N
O O O O O O O O O O O O O
91
STREET LIGHTING UTILITY
OPERATING COSTS
$3.5
0
$�.0 ■Administrative Service
Fee
$2.5 ❑Electrical Power
$2.0
❑Operating&Maintenance
$1.5
$1.0 ■Charges and Services
$0.5 ■Personal Services
$0.0
N N N N N N N N N N N N N
O C C O C O O O O O O O O
92
Public Utilities CIP Budget as a Percent of
Department Requested Budget
70.0%
60.0%
50.0%
Dept.
Average 44.0%
40.0%
30.0% -
20.0%
10.0%
66 6
0.0%
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
■Seriesl ■Series2 ❑Series3 ❑Series4
93
Public Utilities Proposed Debt Service Schedule and Metropolitan Water Assessment
N $50
.o $45 Bond
Series
2 $40 ❑2026
❑2025
$35 112024
$30 112023
❑2022
$25 ❑2021
$20 41 ❑2020 47 Z:rl 7- - 112017
$15 2012
$10 U2011
112010
$5 ❑2009
200s
$0 ❑METRO
20 21 22 23 24 25 26
Years
94
MILLION GALLONS DELIVERED BY YEAR
37,500
35,000
32,500
Budgeted
30,000
27,500
25,000
22,500
20,000
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
95
Figure 1 - Salt Lake City Conservation Trend
Documentation of Conservation Performance
Metropolitan Water District of Salt Lake&Sandy
350
State Conservation Goal
300 ° reduction by 2025)
ULS Conservation Goal
(12.5%reduction by 2020,
250
25%reduction by 2050)
c A
a
200
♦ • / Trend Line of Actual Conservation
L
150 `
Metered Per Capita Water Use
100
a,
50
0
0 5 10 15 20 25 30 35 40 45 50
Years Beyond 2000 Bench Mark
96
Proposed Personnel Adjustments FY 21/22
STREET
TOTAL WATER SEWER STORM WATER LIGHTING
Prior FY Ending FTE Balances by Fund 447.50 286.10 123.44 36.42 1.54
NEW POSITIONS REQUESTED FOR FY 21/22:
1) CONSERVATION TECHNICIAN 1.00 1.00
2) CHIEF STRATEGY AND INNOVATIONS OFFICER 1.00 0.30 0.30 0.25 0.15
3) LOCATOR MANAGER 1.00 0.50 0.30 0.20
4) PROJECT MANAGER 1.00 1.00
5) WATERSHED RANGER 1.00 1.00
6) LEAD AND COPPER SUPERVISOR 1.00 1.00
7) DRAINAGE MAINTENANCE LEAD WORKER 1.00 1.00
8) DRAINAGE MAINTENANCE WORKER III 1.00 1.00
9) WASTEWATER LIFT STATION LEAD WORKER 1.00 1.00
10) LANDSCAPE RESTORATION WORKER 1.00 1.00
11) IRRIGATION OPERATOR II 1.00 1.00
12) ENGINEER V 2.00 0.80 0.60 0.60
13) ENGINEER IV 3.00 1.20 0.90 0.90
14) ADMINISTRATIVE SECRETARY 1 1.00 0.50 0.25 0.25
New Full Time Employee's 17.00 9.30 3.35 4.20 0.15
TOTAL FTE'S WITH NEW POSITIONS ADDED 464.50 295.40 126.79 40.62 1.69
Changes made to Seasonal Employee's 6.00 5.50 0.25 0.25
Changes made to FTE'S 0.00 -2.24 0.76 0.45 1.03
r
Agency Totals for FY 2021/2022 470.50 298.66 127.80 2.72
97
Public Utilities Number of
Employees By Fun By Fisca Year
490
470
450
V)
W
>- 430
O
J
cd
G
W
410
390
370
350
92 93 94 95 96 97 98 99 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22
YEAR
Year 92 93 94 95 96 97 98 99 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22
Water&Sewer 377 372 368 365 372 380 376 377 373 372 372 370 369 364 363 363 360 360 360 362 363 365 367 369 372 373 377 388 401 410 427
Storm Water 16 18 21 28 28 31 30 29 29 29 28 28 27 27 27 27 27 27 28 28 28 29 29 29 30 31 32 33 35 36 41
Street Lighting I 1 1 3 3 3 3 2 2 2 2 3 2 3
o Ln m a m 0 a �O m Ln v N o o� .� rn .� n Ln ry
#Of Water N `° �° m c-I 0) 0) r, .--I tD 00 In �n V 9 c-I N r, Ln N Ln 'T m Ln 0 V O N 0 0 W
Ol m l0 N In c-I m r, N n N n rn m Ol 17 01 01 lD N m V V Vl 11 O Ln Ln lD
Connections ui 16 �D r, Ln 0 0 0 0 o N N 0 0 0 0 0 0 0 0 0 0 rj N N cW
co 00 00 co 00 00 rn 00 00 rn m 00 rn M rn rn M rn rn m rn rn rn rn rn rn rn rn rn rn rn
APPENDIX C: Rationale for New Positions
99
This page left intentionally blank.
100
MEMORANDUM
DEPARTMENT of PUBLIC UTILITIES
- ENGINEERING DIVISION
TO: Laura Briefer,Director of Public Utilities
Jesse Stewart,Deputy Director of Public Utilities
Lisa Tarufelli,Chief Finance Officer of Public Utilities
FROM: Jason Brown,P.E.,Engineering Administrator
DATE: March 15,2021
SUBJECT: Request for additional Engineering staff
This is an update to the original memorandum from 2017. We have been successful in obtaining a several
new employees the need is still great.
The objective of this memorandum is to provide a business case evaluation and recommendation for
additional staff for the Engineering group within Public Utilities. We present three justifications for
increasing the in-house staff FTE's for the Engineering group:
BACKGROUND
(1) The current and past CIP workload justifies more in-house staff.
As stated in previous staffing requests,in 1994 Hughes,Heiss&Associates conducted an audit of the
Engineering group. They recommended increasing the staff based on the CIP program funding at that
time and concluded that using Consultants to fill in the production gap was not"cost effective".
The total CIP program for water/sewer/drainage in 1994 when the audit was conducted was under$1oM.
Currently it is over$1ooM(excluding the NEW WRF)and the number of FTE's has remained basically
the same(Figure 1&Figure 2)with some increases in the last several years. The demands on the current
staff are increasing as public outreach,engagement and education are drawing away time that was
typically allocated for design,construction and asset management. We have been able to temper some of
these critical activities with advances in technologies but even with advances with technology,the
technology requires additional staff time.
(2)In-house staff is less expensive than using Consultants for the CIP workload.
The average cost of the existing Engineering staff including overhead(7.72%)and labor additive(56.36%)
is$51.68 per hour. The average hourly cost which will be charged by Consultants for project engineers
based on the most recent General Services SOQ's is approximately$160 per hour. Doing work with City
staff is approximately a third of the cost of using a Consultant. With new staff position being limited,we
have utilizing outside consultants for much of the additional inspection and design. This method of
allows staff to manage approximately 2 to 4 times the number of projects depending on complexity.
However,the costs to design and inspect the projects are generally 3 times more expensive because of
reasons stated above. Currently we have 37 projects being managed by consultants with an average cost
of approximately$58,000 and a total cost of$2,141,795. That translates into 28 DPU FTE or 8 consultant
employees.
(3)The projected future CIP workload already projected in the approved 5-year budget
justifies more in-house staff.
The CIP budget levels is projected to increase based on the current condition and criticality of the aging
infrastructure. As the Asset Management program continues to mature and evaluate the infrastructure
101
MEMORANDUM
Engineering staff for fiscal year 2022
we are constantly prioritizing,re-prioritizing and categorizing every pipe,pump,well,manhole,valve,lift
station,literally every asset that provides service to our customers. This systematic approach allows us to
make sure that we are being fiscally responsible and constantly allows us to evaluate our approach to
infrastructure replacement. We understand that capital funding is a limited resource and we want to
make sure we are spending it on the right project at the right time and the time place. We are faced with
an aging infrastructure,increasing demand,and increasing cost of work,Figures 3,4&5. We must
continually improve the condition of the infrastructure or we will continually be chasing breaks and the
level of service will decrease.
(4)Existing staff are jacks of all trades and masters of few.
We have phenomenal staff. All of them share the desire to provide the rate payers with the highest quality
services. They are responsible for evaluating and managing every aspect of a project from conception to
completion. The major phases of project delivery are Asset management,Design and Construction. Asset
Management is a systematic approach to inventory,evaluate criticality and determine condition of an
asset. The results of this process is a list of projects with consistent evaluation of both criticality and
condition. Design is the process of first developing a complete understanding of the project so a scope
and estimated budget can be developed. Once the scope and budget are completed and the project has
been awarded funding the project manager must further develop the scope,either with internal or
external resources,to be able to complete a project manual(specifications and drawings)for bidding.
After bidding the project manager is responsible,with the assistance of the inspection team,to make sure
the project is constructed in accordance with the defined project manual and fee. The project manager
has many different projects in all phases of delivery throughout the year.
RECOMMENDATION
We recommend that two new program level groups are created within Engineering based on the analysis
discuss above. Specifically,we are recommending the following changes to the staffing document as
outlined below. The changes that we are asking is for the creation of a Asset Management Program
Manager and a Construction Program Manager. One of the primary objectives of these two positions is to
relieve the burden of CM and AM from the existing staff so they can focus on the design phase of projects.
Asset Management Program
Every day our existing infrastructure gets a little older,Figure 3. Every year we have more projects than
we have the ability to fund. The AMP workgroup will bring focus to a process that is very important to the
development of the Capital Plan(CP). Within the first 6 months,the new AMP manager will review the
existing AM efforts,and develop staffing and resource needs for future consideration. They will also assist
in any current asset management efforts as well as make recommendations for the future asset
management efforts. Through the development of the future needs this program many require future
staffing.
This program will mainly be responsible to apply consistent asset management practices across
all four enterprise funds and develop the annual CP.
Construction Management Program
We propose forming a Construction Management group(CM)to support our Capital Improvement
Program(CIP). This group would reside in SLCDPU's Engineering group under management of the Chief
Engineer.This new workgroup would be initiated by approving a new full-time employee to lead and
develop this group. During the first 6 months this new manager would define the CM group including
determining staffing and resources needed to support the CIP,review and refine existing in-house
SALT LAKE CITY DEPARTMENT of PUBLIC UTILITIES
1530 SOUTH WEST TEMPLE STREET WWW.SLCGOV.COM
SALT LAKE CITY,UTAH 84115 2 TEL 801-483-6700
102
MEMORANDUM
Engineering staff for fiscal year 2022
construction management practices,mentor and support the existing construction efforts and evaluate
the most effective structure for this group.
This group would be primarily responsible for project delivery after projects have been awarded
for construction. This group would also provide constructability reviews prior to project being bid.
Project delivery would include on-going coordination with the project manager,construction
administration,public engagement and status updates to the administration.
CIPTrendline
$60
WAR....._.627L TE
SEWER......_31%
DRAMA E....177G
� 11 A5876 11 $51.08
3
V $46
E
a (•Total LIP
.4 V28. -Linear(Total CIP)
$24.38
D
$26 25empl yeas inth production engine;
$17 25 x$80klyear average minus 0%(vacationileave) —
6.27 $1.4 million in salaries
$1.4 million divided by 10%Project Engin ring cost
$16 1 of CIP con value
Required consultant help=$30 million CI COfISV11Cti n =
millin in consultant fees
$8
29% 1998 2000 2002 2004 200, 2010 2022 2814
Fiscal Year
Figure 1 - CIP Trend line- Historic
SALT LAKE CITY DEPARTMENT of PUBLIC UTILITIES
1530 SOUTH WEST TEMPLE STREET WWW.SLCGOV.COM
SALT LAKE CITY,UTAH 84115 3 TEL 801-483-6700
103
MEMORANDUM
Engineering staff for fiscal year 2022
CIP Trendline & FTE
300
(255.1)
250 Ilk
Dollars Bu geted 214.(3)
....�.......FTE (189 22)
200
o Linear(DoIlars 172.09
B dgeted
15 .99
c
a 150
V)
119.92
0
0
� (130.4
u
100
24.38 19.46 68.07 91.91
43. 34 9
27.8 50. 3
26 8 76 51.08 59.63�
50 2-5
27.5 2..8
�.._. .. ...... �` (41)
.... ..... ..... �...... ...... .... 36
.8 25 23 3 23 73 »23 27.72
16. 7 1 21 1 21 21 22 21 95
0
1998 2000 2002 2004 2006 2008 2010 2012 2014 2016 2018 2020 2022 2024
Fiscal Year
Figure 2 - CIP vs. Engineering group FTE staffing level
SALT LAKE CITY DEPARTMENT of PUBLIC UTILITIES
1530 SOUTH WEST TEMPLE STREET WWW.SLCGOV.COM
SALT LAKE CITY,UTAH 84115 4 TEL 801-483-6700
104
MEMORANDUM
Engineering staff for fiscal year 2022
LENGTH OF WATER PIPELINES IN SERVICE ON JUNE 30,2019
BY SIZE AND DECADE
Pipe Size Length of%Water main Placed in Senice(feet)
Length of
Age Water Main
Diameterinlaches Pre-1920 1920-1929 1930-1939 1940-1949 19-50-1959 1960-1%9 1970.1979 1980.1989 1990-1999 2000-20(o) 211]u 21)IS unknown (Feet)
1 - 114 - 530 - - 48 - - 99 941
1.5 - - - - 252 - - - - - - _'27 479
2 - 2,024 4,023 540 1,894 759 9 418 10 -4 10,751
3 13,2112 1,567 4369 67 1,819 450 - 817 22,778
4 104,499 23,311 61,795 68314 48,998 17,276 2,933 3,037 U94 2,269 346 9,365 350,417
6 773,734 215,465 145,497 341,940 461,297 362,054 359,435 170,768 123,683 12,656 3,00, 36,507 3,006,039
8 57,147 19,584 42,649 6,893 29,055 82,006 111,925 126,092 178,495 386,320 162,556 17,129 1,219,831
9 - - - - - - 918 - - 918
10 22,745 676 433 7.407 3,280 17,502 24,955 3,322 1,131 9,923 2,014 3,125 %,913
12 41,036 13,919 31,732 35.118 47,951 130,536 22405 133,578 134,742 241,175 137,654 17,422 1,239,90E
13 - 1,520 - 1xil
14 1,088 4 191 598 430 1,643 447 8 4,409
15 1,156 70 4,228 1,874 7,328
16 13,587 8 4,778 43,444 27,727 6,542 32,359 30,674 43,093 32,800 13,328 1,419 240.759
18 12,686 8,562 113 4,219 930 4,006 197 7,537 8,185 440 23,%3 70,83E
20 5,375 4,66E 4,159 10,625 33,754 8,423 15,608 3,589 2,707 18 1,643 9N%9
21 1,463 - 460 - 1,923
22 2,276 - 572 - - 2,84E
24 920 3,290 11 11 7,591 13,797 672 49,073 23,616 125 19 4,027 103,152
27 - - - - - - - 53 - - - 53
28 - 1,793 - 1,793
30 9,329 36,614 12,574 6,224 23,894 3,070 2,610 758 3,671 98,744
32 - 9,623 - 8 - 4,69E 14,329
548 36 3.917 15,740 61 21,799 251 11,03 47,769 10,241 3,855 89 8,490 149,362
42 - - - - - 21,%4 - 1,457 - - 22,821
48 2,233 7,870 2,544 22,731 1" 18,536 1346 - 3,936 59,394
54 - 3,232 2,383 - 5,615
64 791 - 791
66 1497 5,694 - 7,191
69 42.376 6 520 42,902
72 19,914 - I 19y14
Feet of Pipe 1,058,257 292,726 317,2% 576,929 700 981 734,717 784,776 681,111 5W 998 710,301 32?J20 135,816[6fz 230Alum of Pipe 200.43 55.44 60.09 109.27 132.76 139.15 148.63 129.00 110.61 13153 61.99 2,;.n ?.62Percent ofTotal 15.3% 4.2Ya 4.6% 8.4 10254 10.6�i 11.400 9.9�� 8.5�� 10.3oe 4.?00IOO.Ooo
Figure 3 -Age and length of Water pipe
Source:(18-19 SLCDPU Statistical report)
SALT LAKE CITY DEPARTMENT of PUBLIC UTILITIES
1530 SOUTH WEST TEMPLE STREET WWW.SLCGOV.COM
SALT LAKE CITY,UTAH 84115 5 TEL 801-483-6700
105
MEMORANDUM
Engineering staff for fiscal year 2022
Rater Main Breaks
70
60
So n
I
40
30
20
n n
10
0
e Sep Oct Nov Dec Jan Feb \!at Apr Ma' ;u
0-1016 17 ■?017 1S 020IS 19
NVater Main Breaks
Jlontb
Fiscal Year Jul AugSep Oct Nov Dec Jan Feb Mar Apr �Iav Jun Total
2016117 39 29 27 22 29 48 48 28 18 15 24 32 359
2017/113 39 46 1 40 25 35 56 33 23 13 23 30 33 396
2018 19 54 35 24 24 46 54 63 23 17 17 38 33 428
Figure 4- Number of breaks-Water pipe
Source:(18-19 SLCDPU Statistical report)
SALT LAKE CITY DEPARTMENT of PUBLIC UTILITIES
1530 SOUTH WEST TEMPLE STREET WWW.SLCGOV.COM
SALT LAKE CITY,UTAH 84115 6 TEL 801-483-6700
106
MEMORANDUM
Engineering staff for fiscal year 2022
SANITARY SEWER PIPE SUMMARY
BY SIZE AND DECADE
June 30,2019
Dunw i„i Pips Feet of Pipe P11red 6 Sonk Length of Pipe
UncheL� I390 I399 1900 1909 1910 I'd, 1920 1929 1930.1939 1940-1949 1950 1959 1960 1969 19-0 19-9 1930-1989 1990.1999 2000.2009 2010 2016 unknown (1ee0
4 - - - - - 102 517 249 61 9 933
6 H11 986 '8 213 3,256 33- 1.420 578 85 163 3,636
8 61.664 272,199 '71.525 140.124 155.' 186,810 212,3W 93.312 97.353 93.03 90,980 221.97'. 13333_ 11220 2,134526
to 12.447 20.605 '3,027 24.821 12914 7,3W 15.117 3.325 6.435 27.120 16.752 30.892 23,08� 2326 27630
12 7.622 10,160 49.030 20.518 10.233 7.470 19225 25.590 S2,115 19,834 60329 113.>14 28,12- 7.056 430"
14 - - 316 1.566 lim
15 $74 2324 13.'6 3,9'2 2800 4276 897> 21,124 12285 3028H 34,065 15.92 2175 1S3,6S7
18 709 15.001 4.336 2.917 6.643 18.362 4.961 17.260 13,573 6,76 3354 97PI
20 3,881 30 - - 13,80: 17,715
21 - 437 4,345 l m 4.739 5.924 3.921 1.911 13.901 4.616 4,449 329 231 - 46,693
24 3.166 4.535 2.462 349 7.911 30.054 1,046 11.649 15.601 5,46: 539 32,776
27 - - - - - - - Z019 - 5.35' 12 7,333
28 - Z405 2,405
30 1.523 4.663 3.631 7.610 1.779 1.265 4.753 25,224
33 6.409 6,409
34 1,884 1,834
36 1,206 5.873 793 5.190 746 8.176 8,925 30,909
38 - - - - 5,482 5,432
40 674 674
42 3.9 Y 3,806 Z318 832 9.870 3,314 26,046
44 15.359 15,359
48 1.6_ 201 3.300 206 16.977 22,304
54 1.386 - 3,977
60 9.:': 3,739 12,9 V
66 S,5 96 9,650
_ 3-rm _ _ - - _ - _ 3,706
1.1" 465 - 4.053 5,695
I61 li.981 16.145
Feet of Pipe 36.433 310,44 9 IM
191,4 210 794 261.44 15' 21425.3913 6341.11 26040- 46.60 262.958 101,47 3,465,51
\life+of Pipe 16.33 58.80 0
%
. 36.26 393 49. 2 8.72 49.32 S453 49.30 1912 656.35
6 2..9° '.6°i 29H 100.0YPerentof Toa 2.5°° 9.0% 5.5% 6.1% 7.5% 4.4
Figure 5 -Age and length of Sewer pipe
Source:(18-19 SLCDPU Statistical report)
SALT LAKE CITY DEPARTMENT of PUBLIC UTILITIES
1530 SOUTH WEST TEMPLE STREET WWW.SLCGOV.COM
SALT LAKE CITY,UTAH 84115 7 TEL 801-483-6700
107
This page left intentionally blank.
108
APPENDIX D: Alternate Water Scenario
109
This page left intentionally blank.
110
WATER UTILITY BUDGET SUMMARY
FY 2022-24
Rate Increase Rate Increase Rate Increase
10% 15% 15%
AMENDED PROJECTED MPROPOSED FORECAST FORECAST
ACTUAL BUDGET ACTUAL BUDGET BUDGET BUDGET
2019-20 2020-21 2020-21 2021-22 2022-23 2023-24
REVENUE&OTHER SOURCES
REVENUES
METERED SALES $ 76,257,075 $ 69,61 2,308 $ 79,304,690 $ 87,044,982 $100,086,900 $115,083,800
INTEREST INCOME 583,230 715,896 715,896 398,000 184,530 165,000
OTHER REVENUES 4,197,718 4,530,048 4,530,048 4,762,372 4,762,372 4,762,372
TOTAL REVENUES $ 81,038,023 $ 74,858,252 $ 84,550,634 $ 92,205,354 $105,033,802 $120,011,172
OTHER SOURCES
GRANTS&OTHER RELATED REVENUES $ 2,562,909 $ 2,533,356 $ 2,533,356 $ 1,953,620 $ 1,953,620 $ 1,953,620
IMPACT FEES 2,521,760 1,184,670 1,338,448 1,784,670 1,784,670 1,784,670
SALE OF EQUIPMENT 125,034 135,260 135,260 40,500 40,500 40,500
OTHER SOURCES - - - - - -
BOND PROCEEDS - 42,235,000 77,1 29,992 26,146,000 38,21 2,000 60,335,000
TOTAL OTHER SOURCES $ 5,209,703 $ 46,088,286 $ 81,1 37,056 $ 29,924,790 $ 41,990,790 $ 64,1 13,790
TOTAL REVENUE&SOURCES $ 86,247,726 $120,946,538 $165,687,690 $ 122,130,144 $147,024,592 $184,124,962
EXPENSES&OTHER USES
EXPENDITURES
PERSONNEL SERVICES $ 21,571,541 $ 25,774,546 $ 25,774,546 $ 28,272,052 $ 29,120,215 $ 29,993,822
OPERATING&MAINTENANCE 3,731,042 4,806,680 4,806,680 4,839,903 4,936,702 5,035,437
TRAVEL&TRAINING 46,251 179,100 179,100 180,800 184,417 188,106
UTILITIES 1,251,633 2,845,999 2,845,999 2,857,150 2,914,294 2,972,580
TECHNICAL SERVICES 2,493,855 11,117,403 11,117,403 10,908,535 11,626,706 11,859,240
IMS SERVICES 1,463,176 1,408,000 1,408,000 2,486,100 2,535,822 2,586,538
FLEET MAINTENANCE 1,005,504 1,250,500 1,250,500 1,250,500 1,275,510 1,301,020
ADMINISTRATIVE SERVICE FEE 841,922 867,200 867,200 893,216 911,080 929,302
PAYMENT IN LIEU OF TAXES 365,000 385,780 385,780 428,864 437,441 446,190
METRO.WATER PURCH&TREAT 15,668,662 16,474,663 16,474,663 16,969,000 17,308,380 17,654,548
METRO ASSESSMENT(CAPITAL) 7,021,892 7,866,1 15 7,866,1 15 7,866,115 7,866,1 15 7,866,115
RISK MANAGEMENT 626,046 1,444,950 1,444,950 1,481,750 1,511,385 1,541,613
TRANSFERS TO GENERAL FUND - 10,000 10,000 10,000 10,200 10,404
OTHER CHARGES AND SERVICES (556,896) (272,628) (272,628) (68,194) (69,558) (70,948)
TOTAL EXPENDITURES $ 55,529,628 $ 74,158,308 $ 74,158,308 $ 78,375,791 $ 80,568,709 $ 82,313,967
OTHER USES
CAPITAL OUTLAY $ 4,109,586 $ 3,820,671 $ 3,820,671 $ 4,622,835 $ 4,622,835 $ 4,622,835
CAPITAL IMPROVEMENT BUDGET 30,538,705 82,050,006 82,050,006 39,600,000 68,462,800 88,923,500
COST OF DEBT ISSUANCE - 235,000 129,992 146,000 162,000 84,000
DEBT SERVICES 1,1 38,500 2,650,774 4,870,922 4,620,929 5,793,053 7,803,385
TOTAL OTHER USES $ 35,786,791 $ 88,756,451 $ 90,871,591 $ 48,989,764 $ 79,040,688 $101,433,720
TOTAL EXPENSE&OTHER USES $ 91,316,419 $162,914,759 $165,029,899 $ 127,365,555 $159,609,397 $183,747,687
EXCESS REVENUE AND OTHER
SOURCES OVER(UNDER)USES ($5,068,693) ($41,968,221) $657,791 ($5,235,411) ($12,584,805) $377,275
OPERATING CASH BALANCES
BEGINNING JULY 1 $ 23,684,887 $ 28,197,285 $ 28,197,285 $ 28,855,076 $ 23,619,665 $ 11,034,860
RESTRICTED/DESIGNATED 9,581,091 $ - $ - $ - $ - $ -
AVAILABLE JUNE 30 $ 28,197,285 $ (13,770,936) $ 28,855,076 $ 23,619,665 $ 11,034,860 $ 11,412,135
Cash Reserve Ratio 51% -1 9% 39% 30% 14% 14%
ill Gash reserve goal above 14%
WATER UTILITY CASH FLOW
FY 2022 BUDGET/FY 2023-2026 FORECAST
ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET
YEAR YEAR YEAR YEAR YEAR YEAR YEAR
2019-2020 2020-2021 2021-2022 2022-2023 2023-20 2124 2025-202
REVENUE
WATER SALES $ 76,257,075 $ 79,304,690 $ 87,044,982 $100,086,900 $115,083,800 $132,310,400 $ 145,522,400
OTHER INCOME 4,197,718 4,530,048 4,762,372 4,762,372 4,762,372 4,762,372 4,762,372
INTEREST INCOME 583,230 715,896 398,000 184,530 165,000 165,000 165,000
OPERATING INCOME $ 81,038,023 $ 84,550,634 $ 92,205,354 $105,033,802 $120,011,172 $137,237,772 $ 150,449,772
OPERATING EXPENDITURES
METROPOLITAN WATER ASSESSMENT $ (7,021,892) $ (7,866,115) $ (7,866,115) $ (7,866,1 15) $ (7,866,1 15) $ (7,866,115) $ (7,866,1 15)
METROPOLITAN WATER PURCHASES (15,668,662) (16,474,663) (16,474,663) (16,804,156) (17,140,239) (17,483,044) (17,832,705)
OPERATING EXPENDITURES (32,839,074) (49,817,530) (54,035,013) (55,898,438) (57,307,613) (58,753,706) (60,237,715)
TOTAL OPERATING EXPENSES $ (55,529,628) $ (74,158,308) $ (78,375,791) $ (80,568,709) $ (82,313,967) $ (84,102,865) $ (85,936,535)
NET INCOME EXCLUDING DEP. $ 25,508,395 $ 10,392,326 $ 13,829,563 $ 24,465,093 $ 37,697,205 $ 53,134,907 $ 64,513,237
OTHER INCOME&EXPENSE
NET BOND PROCEEDS $ - $ 77,000,000 $ 26,000,000 $ 38,000,000 $ 60,000,000 $ 35,000,000 $ 21,000,000
BIC Borrowed 129,992 146,000 212,000 335,000 196,000 118,000
BIC Paid (129,992) (146,000) (212,000) (335,000) (196,000) (118,000)
SHORT TERM FINANCING - - - - - - -
IMPACT FEES 2,521,760 1,338,448 1,784,670 1,784,670 1,784,670 1,784,670 1,784,670
OTHER CONTRIBUTIONS 2,562,909 2,533,356 r
1,953,620 1,953,620 1,953,620 1,953,620 1,953,620
SALE OF EQUIPMENT 125,034 135,260 40,500 40,500 40,500 40,500 40,500
CAPITAL OUTLAY (1,339,406) (2,170,671) (2,972,835 (2,972,835) (2,972,835) (2,972,835) (2,972,835)
WATERSHED AND WATER RIGHTS PURCHASES (2,770,180) (1,650,000)F (1,650,000 (1,650,000) (1,650,000) (1,650,000) (1,650,000)
DEBT SERVICE (1,138,500) (4,870,922) (3,944,929 (3,944,053) (3,997,385) (4,076,541) (4,076,541)
NEW DEBT SERVICE - (676,000 (1,799,000) (3,555,000) (5,411,000) (7,064,000)
OTHER INCOME&EXPENSE $ (38,383) $ 72,315,471 $ 20,535,0261 $ 31,412,902 $ 51,603,570 $ 24,668,414 $ 9,015,414
CAPITAL GENERATION
GENERATED FOR CAPITAL $ 25,470,072 $ 82,707,797 $ 34,364,589 $ 55,877,995 $ 89,300,775 $ 77,803,321 $ 73,528,651
CAPITAL IMPROVEMENTS
CAPITAL IMPROVEMENTS $ (30,538,705) $ (82,050,006) $ (39,600,000) $(68,462,800) $(88,923,500) $(77,588,600) $ (73,747,000)
OPERATING CASH BALANCES
BEGINING CASH BALANCE $ 23,684,887 $ 28,197,285 $ 28,855,07 $ 23,619,665 $ 11,034,860 $ 11,412,135 $ 11,626,856
CASH INCREASE/(DECREASE) (5,068,693) 657,791 (5,235,411 (12,584,805) 377,275 214,721 381,651
RESTRICTED/DESIGNATED 9,581,091 - - - - -
ENDING CASH AVAILABLE $ 28,197,285 $ 28,855,076 $ 23,619,665 $ 11,034,860 $ 11,412,135 $ 11,626,856 $ 12,008,507
DEBT SERVICE COVERAGE 22.41 2.13 2.99 4.26 4.99 5.60 5.79
RATE CHANGE 5% 0% 10% 15% 15% 15% 10%
Cash Reserve Ratio(Total Cash) 51% 39% 30% 14% 14% 14% 14%
DEBT SERVICE%OF GROSS OPERATING REVENUE 1% 6% 5% 5% 6% 7% 7%
MONTHLY RESIDENTIAL BILL(255 ccf annually/1 2 mos.) 46.41 46.41 51.06,1 58.72 67.53 77.66 85.43
112 51 2022 HYBRID 10%DRAFT Corrected Cashflows Water.xlsx