Review CIP and ERP CITY OF HOPKINS
Memorandum
To: Honorable Mayor and Council Members
Mike Mornson, City Manager
From: Nick Bishop, Finance Director
Date: November 9, 2021
Subject: Review 2022 – 2026 Capital Improvement & Equipment Replacement
Plans
_____________________________________________________________________
PURPOSE
To provide input and guidance for the 2022 – 2026 Capital Improvement & Equipment
Replacement Plans.
INFORMATION
Pages two through six provide a summary of the Park Improvement Fund, Capital
Improvement Fund, Permanent Improvement Revolving Fund, Equipment Replacement
fund and Pavilion requests for 2022. Projected cash flows are based on amounts in the
recommended levy presented on November 9, 2021.
Five year summary information for the Capital Improvement Plan is on pages 7 to
16 and for the Equipment Replacement Plan on pages 17 to 27.
Finance Department
2
Park Improvement Fund
The main sources of revenue for park improvements are franchise fees and park
dedication fees. Annually, the City receives approximately $305,000 in gas and electric
franchise fees used for the purposes of park improvements. Park dedication fees are
received from developers as land is platted for development. They can provide a
significant source of revenue for the fund, but are also uncertain and outside the direct
control of the City. Their use is limited to acquisition, development or improvement
activities. The City has received $279,000 of park dedication fees in 2021. There are no
park dedication fees included in 2022 or 2023 projections.
In 2022, the Park Improvement Fund has projected revenues of $305,474 and
projected expenditures of $285,200. The projected expenditures include capital
projects and debt service payments for Cottageville Park. They do not include debt
service payments for Burnes Park. The fund is projected to increase its fund balance by
$20,274 and end 2021 with a fund balance of $322,574.
There are no changes to this fund since the October 10, 2021 work session.
2022 2023
Beginning Fund Balance 302,300 322,574
Revenues & Other Financing Sources
Franchise Fees 305,022 305,022
Park Dedication Fees - -
Interest Earnings 452 473
Total Revenue & Other Financing Sources 305,474 305,495
Expenditures & Other Financing Uses
Current Expenditures 7,000 7,000
Capital Projects
Shady Oak Beach Improvements 8,200 3,300
Central Park Picnic Shelters Rehab 60,000 -
Central Park East Play Equipment Replacement 100,000 -
Improve Courts at Oakes and Cottageville Park - 190,000
Debt Service Transfers
Cottageville Park Bonds 110,000 110,000
Burnes Park Bonds - -
Total Expenditures and Other Financing Sources 285,200 310,300
Increase (Decrease) in Fund Balance 20,274 (4,805)
Projected Ending Fund Balance 322,574 317,769
Park Improvement Fund - Projected Cash Flows
3
Capital Improvement Fund
This fund accounts for capital improvements at the Activity Center, City Hall/Police
Station, Fire Station and Public Work Building. Its two funding sources are franchise
fees from gas and electric utilities and a property tax levy.
In 2022, the Capital Improvement Fund has projected revenues of $553,572 and
projected expenditures of $466,400. The projected expenditures include debt service
transfers for the City Hall renovation project, Activity Center projects and replacement of
Fire Station boilers. The fund is projected to increase its fund balance by $87,172 and
end 2022 with a fund balance of $294,354.
The Activity Center-Facility Improvement project has been delayed by one year and the
levy reduced by $10,000 since the August 10, 2021 work session.
2022 2023
Beginning Fund Balance 207,182 294,354
Revenues & Other Financing Sources
Tax Levy 190,000 200,000
Franchise Fees 361,500 361,500
Interest Earnings 2,072 2,943
Total Revenue & Other Financing Sources 553,572 564,443
Expenditures & Other Financing Uses
Current Expenditures
Capital Projects
Activity Center - Facility Improvements - 10,000
Activity Center - Gym Acoustic Panels 15,000 -
Activity Center - Replace Carpeting 18,200 -
Activity Center - Recover Chairs 10,000 -
Activity Center - Painting Common Area 18,200 -
Fire Station - Replace Boilers 45,000 -
Activity Center - Raspberry Room Roof Replacement - 80,000
Activity Center - Lower Roof Replacement - 80,000
907 Mainstreet (HHS) Windows & Front/Back Doors - 55,000
Debt Service Transfers - City Hall 360,000 360,000
Total Expenditures and Other Financing Sources 466,400 585,000
Increase (Decrease) in Fund Balance 87,172 (20,557)
Projected Ending Fund Balance 294,354 273,797
Capital Improvement Fund - Projected Cash Flows
4
Permanent Improvement Revolving Fund
The Permanent Improvement Revolving Fund is used to account for street
improvements, which can include streets, walkways, trails, traffic signs, traffic signals,
vehicular parking and street lighting. The primary funding sources are debt and special
assessments. Previous projects have received grants or funding from other
governmental entities.
In, 2022, the Permanent Improvement Revolving Fund is projected to receive
$1,945,000 of bond proceeds. The major expenditures of the fund are 6th Ave South/7th
Ave South street reconstruction project, a mill and overlay project on 2nd Ave S and a
portion of trunk water main rehabilitation project. All the underlying utilities are replaced
during each street reconstruction project and related costs and bond proceeds are
recorded in those funds.
The fund also includes proposed street lighting upgrades on Feltl Court in 2022 for
$110,000. The project cannot be funded through bonds or special assessments. The
2022 recommended levy includes available tax levies for Equipment Replacement or
Capital Improvements that could be reallocated to this purpose.
There are no changes to this fund since the October 10, 2021 work session
2022 2023
Beginning Fund Balance 673,155 571,226
Revenues & Other Financing Sources
Special Assessments (Prepaid)100,000 210,000
Interest Earnings 8,071 6,051
Bond Proceeds 1,945,000 3,480,000
Total Revenue & Other Financing Sources 2,053,071 3,696,051
Expenditures & Other Financing Uses
Current Expenditures
Capital Projects
6th Ave South/7th Ave South 1,150,000 -
West Central Avenues - 3,220,000
Trunk Water Main Rehabilitation 450,000 -
Pedestrian & Bicycle Access Improvements 25,000 25,000
Street Rehabilitation (Mill & Overlay)400,000 425,000
Street Sign Management 20,000 20,000
Street Lighting Upgrades 110,000 190,000
Central Business District Lighting Upgrades - 100,000
Total Expenditures and Other Financing Sources 2,155,000 3,980,000
Increase (Decrease) in Fund Balance (101,929) (283,949)
Projected Ending Fund Balance 571,226 287,277
Permanent Improvement Revolving - Projected Cash Flows
5
Equipment Replacement Fund
This fund accounts for the purchase of machinery and equipment. The two sources of
revenue are a tax levy and equipment charges. Equipment charges are billed to
various City departments and are over 99% in the General Fund. Equipment
replacement has also been accomplished through the issuance of equipment
certificates (debt).
In 2022, the Equipment Replacement Fund has projected revenues of $1,756,540,
including debt proceeds of $996,000. The projected expenditures are $1,620,477.
Major purchases proposed for 2022 include a Quick Attack Pumper Fire Truck
($771,000) and Single Axle Dump Truck ($225,000). The fund is projected to increase
its net position by $136,063 and end 2022 with a net position of $920,691.
The levy has been reduced by 175,000 since the August 10, 2021 work session.
2022 2023
Beginning Fund Balance 784,628 920,691
Revenues & Other Financing Sources
Tax Levy 75,000 250,000
Equipment Charges 669,755 709,941
Sale of Equipment 15,000 35,000
Interest Earnings 785 1,175
Equipment Certificates (Bonds)996,000 -
Total Revenue & Other Financing Sources 1,756,540 996,116
Expenditures & Other Financing Uses
Current Expenditures 35,248 35,600
Capital Projects
Community Services - Activity Center 37,000 12,000
Community Services - Information Technology 225,729 333,085
Fire Vehicles & Equipment 787,000 105,000
Police Vehicles & Equipment 207,100 595,912
Public Works: Parks/Forestry - 199,000
Public Works: Streets/Traffic 328,400 83,500
Total Expenditures and Other Financing Sources 1,620,477 1,364,097
Increase (Decrease) in Fund Balance 136,063 (367,981)
Projected Ending Fund Balance 920,691 552,710
Equipment Replacement Fund - Projected Cash Flows
6
Pavilion Requests
The Pavilion Fund includes two requests for 2022. The first request is to replace and
upgrade the current sound system and audio visual capabilities. The upgrade would
allow for inside arena announcing, lobby music and outside rink music simultaneously.
Pavilion staff is currently looking for outside funding assistance. The total cost of the
project is estimated to be $70,000.
The second request is to replace 60 high bay lighting fixtures with more energy efficient
LED fixtures. The new LED lighting is more energy efficient and needs less
maintenance. The cost of the project is estimated to be $18,000.
The 2022 draft levy includes available tax levies for Equipment Replacement or Capital
Improvements that could be reallocated to this purpose.
There are no changes to the pavilion requests since the August 10, 2021 work session.
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
PROJECTS BY YEAR
2022 2026thru
Project Name Department Project #Priority Project Cost
2022
19-CIP-AC048Activity Center - Gym Acoustical Panels n/a 15,000Comm Svcs - Activity Center
21-CIP-AC049Activity Center - Replace Carpeting in Common Area 2 18,200Comm Svcs - Activity Center
21-CIP-AC050Activity Center - Recover Chairs 2 10,000Comm Svcs - Activity Center
21-CIP-AC051Activity Center - Painting Common Areas 2 18,200Comm Svcs - Activity Center
14-CIP-AR003Arts Center - Paint Theatre 2 24,086Comm Svcs - Arts Center
19-CIP-AR002Arts Center - Outdoor Signage/lighting 2 10,000Comm Svcs - Arts Center
19-CIP-AR003Arts Center - Tile Flooring 1 18,000Comm Svcs - Arts Center
19-CIP-AR005Arts Center - Key Card Exterior & Interior Access 2 20,000Comm Svcs - Arts Center
19-CIP-AR006Arts Center - Fire Panel 2 30,000Comm Svcs - Arts Center
21-CIP-AR002Arts Center - Green Room & West Hallway Carpeting 2 16,010Comm Svcs - Arts Center
21-CIP-AR003Arts Center - Replace JC Studio Flooring 1 18,095Comm Svcs - Arts Center
08-CIP-FD123Fire Station - Replace Boilers n/a 45,000Fire
19-CIP-PV331Pavilion - Arena Lighting Replacement 2 18,000Pavilion
19-CIP-PV332Pavilion - Pav/Cent Park Sound System 2 70,000Pavilion
20-CIP-P071Central Park Picnic Shelters Rehab n/a 60,000Public Works: Parks
20-CIP-P072Central Park East Play Equipment Replacement n/a 100,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 2,375,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
16-CIP-S041Street Rehabilitation Improvements n/a 400,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
20-CIP-S002City Street Lighting Upgrades n/a 110,000Public Works: Streets/Traffic
01-CIP-U002Storm Drainage System Maintenance - Alley Repairs n/a 25,000Public Works: Utilities
18-CIP-U016Sewer Lining 2 52,500Public Works: Utilities
19-CIP-U017Trunk Water Main Rehabilitation 2 3,955,000Public Works: Utilities
16-CIP-R003Shady Oak Beach Improvements 3 25,000Recreation
7,478,091Total for 2022
2023
08-CIP-AC024Activity Center - Raspberry Room Roof Replacement n/a 80,000Comm Svcs - Activity Center
09-CIP-AC031Activity Center - Lower Roof Replacement n/a 80,000Comm Svcs - Activity Center
19-CIP-AC045Activity Center - Facility Improvements n/a 10,000Comm Svcs - Activity Center
19-CIP-AR002Arts Center - Outdoor Signage/lighting 2 25,000Comm Svcs - Arts Center
19-CIP-AR007Arts Center - Roof Replacement 2 150,000Comm Svcs - Arts Center
19-CIP-PV330Pavilion - Indoor Turf System Replacement 2 95,000Pavilion
21-CIP-B101907 Mainstreet (HHS) Windows & Front/Back Door 5 55,000Public Works: Bldg/Equip Serv
13-CIP-P044Improve Courts at Oakes Park and Cottageville Park n/a 190,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 6,493,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
16-CIP-S041Street Rehabilitation Improvements n/a 425,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
20-CIP-S001Central Business District Lighting Upgrades n/a 100,000Public Works: Streets/Traffic
20-CIP-S002City Street Lighting Upgrades n/a 190,000Public Works: Streets/Traffic
01-CIP-U002Storm Drainage System Maintenance - Alley Repairs n/a 26,000Public Works: Utilities
18-CIP-U016Sewer Lining 2 55,000Public Works: Utilities
Wednesday, November 3, 2021
7DRAFT
Project Name Department Project #Priority Project Cost
16-CIP-R003Shady Oak Beach Improvements 3 10,000Recreation
8,029,000Total for 2023
2024
19-CIP-AC045Activity Center - Facility Improvements n/a 175,000Comm Svcs - Activity Center
19-CIP-AR002Arts Center - Outdoor Signage/lighting 2 10,000Comm Svcs - Arts Center
08-CIP-B121Fire Station: Replace 25 Ton AHU n/a 82,000Fire
20-CIP-PV334Pavilion - Arena Exit Door Replacement 3 105,000Pavilion
21-CIP-P073Repair Valley Park Basketball Court n/a 70,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 7,542,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
16-CIP-S041Street Rehabilitation Improvements n/a 450,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
20-CIP-S001Central Business District Lighting Upgrades n/a 40,000Public Works: Streets/Traffic
20-CIP-S002City Street Lighting Upgrades n/a 200,000Public Works: Streets/Traffic
01-CIP-U002Storm Drainage System Maintenance - Alley Repairs n/a 27,000Public Works: Utilities
18-CIP-U016Sewer Lining 2 60,000Public Works: Utilities
16-CIP-R003Shady Oak Beach Improvements 3 10,000Recreation
8,816,000Total for 2024
2025
08-CIP-CH011City Hall- Site Landscaping Improvement n/a 100,000City Hall Administration
20-CIP-PV333Pavilion - Mezzanine Flooring Replacement 3 90,000Pavilion
08-CIP-PD215City Hall Police Station Rooftop n/a 240,000Police
08-CIP-B023Public Works - Replace Overhead Doors n/a 90,000Public Works: Bldg/Equip Serv
21-CIP-P074Repair Burnes Park Tennis Courts n/a 130,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 7,552,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 100,000Public Works: Streets/Traffic
16-CIP-S041Street Rehabilitation Improvements n/a 475,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
20-CIP-S002City Street Lighting Upgrades n/a 90,000Public Works: Streets/Traffic
01-CIP-U002Storm Drainage System Maintenance - Alley Repairs n/a 28,000Public Works: Utilities
18-CIP-U016Sewer Lining 2 65,000Public Works: Utilities
16-CIP-R003Shady Oak Beach Improvements 3 10,000Recreation
8,990,000Total for 2025
2026
09-CIP-CH032Council Chambers HVAC Unit n/a 15,000City Hall Administration
16-CIP-AC034Activity Ctr - Lounge/Comptr/Lib - Tables & Chairs n/a 23,500Comm Svcs - Activity Center
21-CIP-P075Repair Play Courts-Interlachen, Elmo & Park Valley n/a 120,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 7,567,000Public Works: Streets/Traffic
01-CIP-S104County Road 3 n/a 2,300,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
16-CIP-S041Street Rehabilitation Improvements n/a 500,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
20-CIP-S002City Street Lighting Upgrades n/a 225,000Public Works: Streets/Traffic
20-CIP-S005Minnetonka Mills/5th St N Signal Replacement 5 600,000Public Works: Streets/Traffic
01-CIP-U002Storm Drainage System Maintenance - Alley Repairs n/a 29,000Public Works: Utilities
18-CIP-U016Sewer Lining 2 75,000Public Works: Utilities
16-CIP-R003Shady Oak Beach Improvements 3 10,000Recreation
11,509,500Total for 2026
Wednesday, November 3, 2021
8DRAFT
Project Name Department Project #Priority Project Cost
GRAND TOTAL 44,822,591
Wednesday, November 3, 2021
9DRAFT
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
DEPARTMENT SUMMARY
2022 2026thru
Total20222023202420252026Department
City Hall Administration 115,000100,000 15,000
Comm Svcs - Activity Center 429,90061,400 170,000 175,000 23,500
Comm Svcs - Arts Center 321,191136,191 175,000 10,000
Fire 127,00045,000 82,000
Pavilion 378,00088,000 95,000 105,000 90,000
Police 240,000240,000
Public Works: Bldg/Equip Serv 145,00055,000 90,000
Public Works: Parks 670,000160,000 190,000 70,000 130,000 120,000
Public Works: Streets/Traffic 37,934,0002,930,000 7,253,000 8,277,000 8,237,000 11,237,000
Public Works: Utilities 4,397,5004,032,500 81,000 87,000 93,000 104,000
Recreation 65,00025,000 10,000 10,000 10,000 10,000
7,478,091 8,029,000 8,816,000 8,990,000 11,509,500 44,822,591TOTAL
Wednesday, November 3, 202110DRAFT
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
PROJECTS BY DEPARTMENT
2022 2026thru
Total20222023202420252026DepartmentProject #Priority
City Hall Administration
08-CIP-CH011 100,000100,000City Hall- Site Landscaping Improvement n/a
09-CIP-CH032 15,00015,000Council Chambers HVAC Unit n/a
115,000100,000 15,000City Hall Administration Total
Comm Svcs - Activity Center
08-CIP-AC024 80,00080,000Activity Center - Raspberry Room Roof Replacement n/a
09-CIP-AC031 80,00080,000Activity Center - Lower Roof Replacement n/a
16-CIP-AC034 23,50023,500Activity Ctr - Lounge/Comptr/Lib - Tables & Chairs n/a
19-CIP-AC045 185,00010,000 175,000Activity Center - Facility Improvements n/a
19-CIP-AC048 15,00015,000Activity Center - Gym Acoustical Panels n/a
21-CIP-AC049 18,20018,200Activity Center - Replace Carpeting in Common Area 2
21-CIP-AC050 10,00010,000Activity Center - Recover Chairs 2
21-CIP-AC051 18,20018,200Activity Center - Painting Common Areas 2
429,90061,400 170,000 175,000 23,500Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
14-CIP-AR003 24,08624,086Arts Center - Paint Theatre 2
19-CIP-AR002 45,00010,000 25,000 10,000Arts Center - Outdoor Signage/lighting 2
19-CIP-AR003 18,00018,000Arts Center - Tile Flooring 1
19-CIP-AR005 20,00020,000Arts Center - Key Card Exterior & Interior Access 2
19-CIP-AR006 30,00030,000Arts Center - Fire Panel 2
19-CIP-AR007 150,000150,000Arts Center - Roof Replacement 2
21-CIP-AR002 16,01016,010Arts Center - Green Room & West Hallway Carpeting 2
21-CIP-AR003 18,09518,095Arts Center - Replace JC Studio Flooring 1
321,191136,191 175,000 10,000Comm Svcs - Arts Center Total
Fire
08-CIP-B121 82,00082,000Fire Station: Replace 25 Ton AHU n/a
08-CIP-FD123 45,00045,000Fire Station - Replace Boilers n/a
127,00045,000 82,000Fire Total
Pavilion
19-CIP-PV330 95,00095,000Pavilion - Indoor Turf System Replacement 2
19-CIP-PV331 18,00018,000Pavilion - Arena Lighting Replacement 2
19-CIP-PV332 70,00070,000Pavilion - Pav/Cent Park Sound System 2
20-CIP-PV333 90,00090,000Pavilion - Mezzanine Flooring Replacement 3
20-CIP-PV334 105,000105,000Pavilion - Arena Exit Door Replacement 3
378,00088,000 95,000 105,000 90,000Pavilion Total
Police
08-CIP-PD215 240,000240,000City Hall Police Station Rooftop n/a
Wednesday, November 3, 202111DRAFT
Total20222023202420252026DepartmentProject #Priority
240,000240,000Police Total
Public Works: Bldg/Equip Serv
08-CIP-B023 90,00090,000Public Works - Replace Overhead Doors n/a
21-CIP-B101 55,00055,000907 Mainstreet (HHS) Windows & Front/Back Door 5
145,00055,000 90,000Public Works: Bldg/Equip Serv Total
Public Works: Parks
13-CIP-P044 190,000190,000Improve Courts at Oakes Park and Cottageville Park n/a
20-CIP-P071 60,00060,000Central Park Picnic Shelters Rehab n/a
20-CIP-P072 100,000100,000Central Park East Play Equipment Replacement n/a
21-CIP-P073 70,00070,000Repair Valley Park Basketball Court n/a
21-CIP-P074 130,000130,000Repair Burnes Park Tennis Courts n/a
21-CIP-P075 120,000120,000Repair Play Courts-Interlachen, Elmo & Park Valley n/a
670,000160,000 190,000 70,000 130,000 120,000Public Works: Parks Total
Public Works: Streets/Traffic
01-CIP-S101 31,529,0002,375,000 6,493,000 7,542,000 7,552,000 7,567,000Residential Street Improvements and Utilities n/a
01-CIP-S104 2,300,0002,300,000County Road 3 n/a
13-CIP-S040 200,00025,000 25,000 25,000 100,000 25,000Pedestrian & Bicycle Access Improvements n/a
16-CIP-S041 2,250,000400,000 425,000 450,000 475,000 500,000Street Rehabilitation Improvements n/a
16-CIP-S042 100,00020,000 20,000 20,000 20,000 20,000Street Sign Management n/a
20-CIP-S001 140,000100,000 40,000Central Business District Lighting Upgrades n/a
20-CIP-S002 815,000110,000 190,000 200,000 90,000 225,000City Street Lighting Upgrades n/a
20-CIP-S005 600,000600,000Minnetonka Mills/5th St N Signal Replacement 5
37,934,0002,930,000 7,253,000 8,277,000 8,237,000 11,237,000Public Works: Streets/Traffic Total
Public Works: Utilities
01-CIP-U002 135,00025,000 26,000 27,000 28,000 29,000Storm Drainage System Maintenance - Alley Repairs n/a
18-CIP-U016 307,50052,500 55,000 60,000 65,000 75,000Sewer Lining 2
19-CIP-U017 3,955,0003,955,000Trunk Water Main Rehabilitation 2
4,397,5004,032,500 81,000 87,000 93,000 104,000Public Works: Utilities Total
Recreation
16-CIP-R003 65,00025,000 10,000 10,000 10,000 10,000Shady Oak Beach Improvements 3
65,00025,000 10,000 10,000 10,000 10,000Recreation Total
GRAND TOTAL 44,822,5917,478,091 8,029,000 8,816,000 8,990,000 11,509,500
Wednesday, November 3, 202112DRAFT
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
FUNDING SOURCE SUMMARY
2022 thru 2026
TotalSource20222023202420252026
AC - Arts Center Fund 321,191136,191 175,000 10,000
CI - Capital Improvement Fund 984,900106,400 225,000 257,000 358,000 38,500
GU - Other Governmental Units 1,643,60016,800 6,700 6,700 6,700 1,606,700
MS - Municipal State Aid Streets 700,000700,000
PA - Pavilion Fund 378,00088,000 95,000 105,000 90,000
PDF- Park Dedication Fund 691,400168,200 193,300 73,300 133,300 123,300
PI - PIR/General Obligation Bonds 16,055,0001,655,000 2,930,000 3,620,000 3,580,000 4,270,000
RF - Refuse Fund 18,00018,000
SA - Special Assessment 4,568,000500,000 1,050,000 1,006,000 1,006,000 1,006,000
SF - Sanitary Sewer Fund 7,164,500947,500 1,418,000 1,587,000 1,610,000 1,602,000
SU - Storm Sewer Fund 2,828,000410,000 506,000 627,000 646,000 639,000
WF - Water Fund 9,470,0003,450,000 1,430,000 1,524,000 1,542,000 1,524,000
7,478,091 8,029,000 8,816,000 8,990,000 11,509,500 44,822,591GRAND TOTAL
Wednesday, November 3, 2021
13DRAFT
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
PROJECTS BY FUNDING SOURCE
2022 2026thru
TotalSourceProject #Priority 2022 2023 2024 2025 2026
AC - Arts Center Fund
14-CIP-AR003 24,08624,086Arts Center - Paint Theatre 2
19-CIP-AR002 45,00010,000 25,000 10,000Arts Center - Outdoor Signage/lighting 2
19-CIP-AR003 18,00018,000Arts Center - Tile Flooring 1
19-CIP-AR005 20,00020,000Arts Center - Key Card Exterior & Interior Access 2
19-CIP-AR006 30,00030,000Arts Center - Fire Panel 2
19-CIP-AR007 150,000150,000Arts Center - Roof Replacement 2
21-CIP-AR002 16,01016,010Arts Center - Green Room & West Hallway Carpeting 2
21-CIP-AR003 18,09518,095Arts Center - Replace JC Studio Flooring 1
321,191136,191 175,000 10,000AC - Arts Center Fund Total
CI - Capital Improvement Fund
08-CIP-AC024 80,00080,000Activity Center - Raspberry Room Roof Replacement n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
08-CIP-B121 82,00082,000Fire Station: Replace 25 Ton AHU n/a
08-CIP-CH011 100,000100,000City Hall- Site Landscaping Improvement n/a
08-CIP-FD123 45,00045,000Fire Station - Replace Boilers n/a
08-CIP-PD215 240,000240,000City Hall Police Station Rooftop n/a
09-CIP-AC031 80,00080,000Activity Center - Lower Roof Replacement n/a
09-CIP-CH032 15,00015,000Council Chambers HVAC Unit n/a
16-CIP-AC034 23,50023,500Activity Ctr - Lounge/Comptr/Lib - Tables & Chairs n/a
19-CIP-AC045 185,00010,000 175,000Activity Center - Facility Improvements n/a
19-CIP-AC048 15,00015,000Activity Center - Gym Acoustical Panels n/a
21-CIP-AC049 18,20018,200Activity Center - Replace Carpeting in Common Area 2
21-CIP-AC050 10,00010,000Activity Center - Recover Chairs 2
21-CIP-AC051 18,20018,200Activity Center - Painting Common Areas 2
21-CIP-B101 55,00055,000907 Mainstreet (HHS) Windows & Front/Back Door 5
984,900106,400 225,000 257,000 358,000 38,500CI - Capital Improvement Fund Total
GU - Other Governmental Units
01-CIP-S104 1,600,0001,600,000County Road 3 n/a
16-CIP-R003 43,60016,800 6,700 6,700 6,700 6,700Shady Oak Beach Improvements 3
1,643,60016,800 6,700 6,700 6,700 1,606,700GU - Other Governmental Units Total
MS - Municipal State Aid Streets
01-CIP-S104 700,000700,000County Road 3 n/a
700,000700,000MS - Municipal State Aid Streets Total
PA - Pavilion Fund
19-CIP-PV330 95,00095,000Pavilion - Indoor Turf System Replacement 2
Wednesday, November 3, 2021
14DRAFT
TotalSourceProject #Priority 2022 2023 2024 2025 2026
19-CIP-PV331 18,00018,000Pavilion - Arena Lighting Replacement 2
19-CIP-PV332 70,00070,000Pavilion - Pav/Cent Park Sound System 2
20-CIP-PV333 90,00090,000Pavilion - Mezzanine Flooring Replacement 3
20-CIP-PV334 105,000105,000Pavilion - Arena Exit Door Replacement 3
378,00088,000 95,000 105,000 90,000PA - Pavilion Fund Total
PDF- Park Dedication Fund
13-CIP-P044 190,000190,000Improve Courts at Oakes Park and Cottageville Park n/a
16-CIP-R003 21,4008,200 3,300 3,300 3,300 3,300Shady Oak Beach Improvements 3
20-CIP-P071 60,00060,000Central Park Picnic Shelters Rehab n/a
20-CIP-P072 100,000100,000Central Park East Play Equipment Replacement n/a
21-CIP-P073 70,00070,000Repair Valley Park Basketball Court n/a
21-CIP-P074 130,000130,000Repair Burnes Park Tennis Courts n/a
21-CIP-P075 120,000120,000Repair Play Courts-Interlachen, Elmo & Park Valley n/a
691,400168,200 193,300 73,300 133,300 123,300PDF- Park Dedication Fund Total
PI - PIR/General Obligation Bonds
01-CIP-S101 11,510,000650,000 2,170,000 2,885,000 2,895,000 2,910,000Residential Street Improvements and Utilities n/a
13-CIP-S040 200,00025,000 25,000 25,000 100,000 25,000Pedestrian & Bicycle Access Improvements n/a
16-CIP-S041 2,250,000400,000 425,000 450,000 475,000 500,000Street Rehabilitation Improvements n/a
16-CIP-S042 100,00020,000 20,000 20,000 20,000 20,000Street Sign Management n/a
19-CIP-U017 450,000450,000Trunk Water Main Rehabilitation 2
20-CIP-S001 140,000100,000 40,000Central Business District Lighting Upgrades n/a
20-CIP-S002 815,000110,000 190,000 200,000 90,000 225,000City Street Lighting Upgrades n/a
20-CIP-S005 590,000590,000Minnetonka Mills/5th St N Signal Replacement 5
16,055,0001,655,000 2,930,000 3,620,000 3,580,000 4,270,000PI - PIR/General Obligation Bonds Total
RF - Refuse Fund
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
18,00018,000RF - Refuse Fund Total
SA - Special Assessment
01-CIP-S101 4,568,000500,000 1,050,000 1,006,000 1,006,000 1,006,000Residential Street Improvements and Utilities n/a
4,568,000500,000 1,050,000 1,006,000 1,006,000 1,006,000SA - Special Assessment Total
SF - Sanitary Sewer Fund
01-CIP-S101 6,444,000500,000 1,363,000 1,527,000 1,527,000 1,527,000Residential Street Improvements and Utilities n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
18-CIP-U016 307,50052,500 55,000 60,000 65,000 75,000Sewer Lining 2
19-CIP-U017 395,000395,000Trunk Water Main Rehabilitation 2
7,164,500947,500 1,418,000 1,587,000 1,610,000 1,602,000SF - Sanitary Sewer Fund Total
SU - Storm Sewer Fund
01-CIP-S101 2,505,000225,000 480,000 600,000 600,000 600,000Residential Street Improvements and Utilities n/a
01-CIP-U002 135,00025,000 26,000 27,000 28,000 29,000Storm Drainage System Maintenance - Alley Repairs n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
Wednesday, November 3, 2021
15DRAFT
TotalSourceProject #Priority 2022 2023 2024 2025 2026
19-CIP-U017 160,000160,000Trunk Water Main Rehabilitation 2
20-CIP-S005 10,00010,000Minnetonka Mills/5th St N Signal Replacement 5
2,828,000410,000 506,000 627,000 646,000 639,000SU - Storm Sewer Fund Total
WF - Water Fund
01-CIP-S101 6,502,000500,000 1,430,000 1,524,000 1,524,000 1,524,000Residential Street Improvements and Utilities n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
19-CIP-U017 2,950,0002,950,000Trunk Water Main Rehabilitation 2
9,470,0003,450,000 1,430,000 1,524,000 1,542,000 1,524,000WF - Water Fund Total
44,822,5917,478,091 8,029,000 8,816,000 8,990,000 11,509,500GRAND TOTAL
Wednesday, November 3, 2021
16DRAFT
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY YEAR
2022 2026thru
Project Name Department Project #Priority Project Cost
2022
01-ERP-0038Activity Center - Kitchen Storage 5 17,000Comm Svcs - Activity Center
01-ERP-0042Activity Center - Replace Sanitizer/Heat Booster 2 20,000Comm Svcs - Activity Center
01-ERP-1105Art Center Jaycee Studio Audio Visual n/a 13,500Comm Svcs - Arts Center
01-ERP-0003CH - Network Server n/a 25,000Comm Svcs - IT
01-ERP-0006Computers n/a 34,729Comm Svcs - IT
01-ERP-0009Network Infrastructure Upgrade n/a 0Comm Svcs - IT
01-ERP-0017IT - Office 365 n/a 44,000Comm Svcs - IT
01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT
01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 42,000Comm Svcs - IT
01-ERP-0024IT - Sandbox Security Appliance n/a 45,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 25,000Comm Svcs - IT
01-ERP-0105Quick Attack Pumper/Rescue (Rescue 8)n/a 771,000Fire
01-ERP-0126Fire - Fire Helmets n/a 16,000Fire
01-ERP-0401HRA Copier n/a 16,500HRA
01-ERP-0200Marked Patrol Vehicles (7)n/a 110,000Police
01-ERP-0203PSO - Utility 4x4 n/a 72,100Police
01-ERP-0227Police Equipment n/a 25,000Police
01-ERP-03031 Ton Dump Truck (2)n/a 53,400Public Works: Streets/Traffic
01-ERP-0305Single Axle Dump Truck (2)n/a 225,000Public Works: Streets/Traffic
01-ERP-0309Skid Loader (2)n/a 50,000Public Works: Streets/Traffic
01-ERP-0555Generator (2)n/a 43,000Sewer
01-ERP-0560Sewer Televising Camera and Van 1 180,000Sewer
1,838,229Total for 2022
2023
01-ERP-0038Activity Center - Kitchen Storage 5 12,000Comm Svcs - Activity Center
01-ERP-0003CH - Network Server n/a 26,250Comm Svcs - IT
01-ERP-0004Telephone System n/a 89,600Comm Svcs - IT
01-ERP-0006Computers n/a 36,465Comm Svcs - IT
01-ERP-0015Backup Server n/a 72,120Comm Svcs - IT
01-ERP-0017IT - Office 365 n/a 44,000Comm Svcs - IT
01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT
01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 42,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 26,250Comm Svcs - IT
01-ERP-0109Extrication Tool (1)n/a 32,000Fire
01-ERP-0127Fire - Lucus Device n/a 18,000Fire
01-ERP-0131Fire - Station Alerting System n/a 55,000Fire
01-ERP-04004x4 3/4 Ton Truck n/a 41,100HRA
01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police
01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 76,512Police
01-ERP-0215Police - Portable Radios n/a 290,000Police
01-ERP-0217Taser Replacement n/a 90,000Police
01-ERP-0218Building Video Server n/a 22,000Police
01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry
Wednesday, November 3, 2021
17DRAFT
Project Name Department Project #Priority Project Cost
01-ERP-0804Log Truck n/a 163,600Public Works: Parks/Forestry
01-ERP-03004x4 1/2 Ton Pickup with Plow n/a 28,900Public Works: Streets/Traffic
01-ERP-03041 Ton Traffic Boom Truck n/a 136,400Public Works: Streets/Traffic
1,464,997Total for 2023
2024
01-ERP-1107Art Center Theater Projection Screen 2 6,700Comm Svcs - Arts Center
01-ERP-0003CH - Network Server n/a 27,037Comm Svcs - IT
01-ERP-0006Computers n/a 37,559Comm Svcs - IT
01-ERP-0012Core Network Switch n/a 20,000Comm Svcs - IT
01-ERP-0017IT - Office 365 n/a 45,320Comm Svcs - IT
01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT
01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 63,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 27,038Comm Svcs - IT
01-ERP-1003Pavilion - Floor Scrubber n/a 11,600Pavilion
01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police
01-ERP-0212Squad Car Camera Systems/ Body Worn Camera n/a 160,000Police
01-ERP-0220Squad Computers n/a 90,000Police
01-ERP-0221Records Management System n/a 150,000Police
01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry
01-ERP-03031 Ton Dump Truck (2)n/a 49,500Public Works: Streets/Traffic
01-ERP-0308Front End Loaders (2)n/a 268,600Public Works: Streets/Traffic
1,093,754Total for 2024
2025
01-ERP-1109Art Center Floor Scrubber n/a 10,800Comm Svcs - Arts Center
01-ERP-0003CH - Network Server n/a 27,849Comm Svcs - IT
01-ERP-0005Financial Software - Various Depts.n/a 315,000Comm Svcs - IT
01-ERP-0006Computers n/a 38,686Comm Svcs - IT
01-ERP-0014Distribution Network Switches n/a 57,000Comm Svcs - IT
01-ERP-0017IT - Office 365 n/a 46,680Comm Svcs - IT
01-ERP-0020IT - Patching Automation Software 1 10,300Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 27,849Comm Svcs - IT
01-ERP-0052Electronic Inspections Processing 2 16,231Community Services
01-ERP-0108Self Contained Breathing Apparatus (SCBA) (45)n/a 250,000Fire
01-ERP-0112Thermal Imaging Camera (2)n/a 16,180Fire
01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 386,000Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police
01-ERP-0201Sergeant's Vehicle n/a 64,154Police
01-ERP-0227Police Equipment n/a 25,000Police
01-ERP-0900Refuse Truck (RAP-R) (2)n/a 275,200Refuse
1,684,329Total for 2025
2026
01-ERP-0035Activity Center - Floor Scrubber n/a 6,700Comm Svcs - Activity Center
01-ERP-1102Art Center Kitchen Catering Equipment n/a 7,100Comm Svcs - Arts Center
01-ERP-0003CH - Network Server n/a 28,684Comm Svcs - IT
01-ERP-0006Computers n/a 39,847Comm Svcs - IT
01-ERP-0015Backup Server n/a 78,808Comm Svcs - IT
01-ERP-0017IT - Office 365 n/a 48,080Comm Svcs - IT
01-ERP-0020IT - Patching Automation Software 1 10,609Comm Svcs - IT
01-ERP-0024IT - Sandbox Security Appliance n/a 45,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 28,684Comm Svcs - IT
01-ERP-0113Emergency Preparedness Sirens n/a 38,500Fire
Wednesday, November 3, 2021
18DRAFT
Project Name Department Project #Priority Project Cost
01-ERP-0131Fire - Station Alerting System n/a 75,000Fire
01-ERP-1000Pavilion Ice Resurfacer n/a 165,000Pavilion
01-ERP-1001Pavilion - Electric Ice Edger n/a 8,900Pavilion
01-ERP-1002Pavilion Arena Scoreboard n/a 12,000Pavilion
01-ERP-0200Marked Patrol Vehicles (7)n/a 128,000Police
01-ERP-0202PSO / Parking Enforcement Vehicle n/a 60,000Police
01-ERP-0203PSO - Utility 4x4 n/a 86,100Police
01-ERP-0218Building Video Server n/a 17,000Police
01-ERP-07104X4 3/4 Ton Truck n/a 42,100Public Works: Bldg/Equip Serv
01-ERP-0808Riding Mowers (2)1 17,700Public Works: Parks/Forestry
01-ERP-0816Toolcat n/a 80,200Public Works: Parks/Forestry
01-ERP-0317Sign Machine (Traffic)n/a 18,100Public Works: Streets/Traffic
01-ERP-05513/4 Ton Utility Truck n/a 45,200Sewer
01-ERP-05013/4 Ton Utility Truck n/a 46,900Water
1,134,212Total for 2026
GRAND TOTAL 7,215,521
Wednesday, November 3, 2021
19DRAFT
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
DEPARTMENT SUMMARY
2022 2026thru
Total20222023202420252026Department
Comm Svcs - Activity Center 55,70037,000 12,000 6,700
Comm Svcs - Arts Center 38,10013,500 6,700 10,800 7,100
Comm Svcs - IT 1,605,444225,729 346,685 229,954 523,364 279,712
Community Services 16,23116,231
Fire 1,657,680787,000 105,000 652,180 113,500
HRA 57,60016,500 41,100
Pavilion 197,50011,600 185,900
Police 1,818,066207,100 595,912 517,400 206,554 291,100
Public Works: Bldg/Equip Serv 42,10042,100
Public Works: Parks/Forestry 306,900199,000 10,000 97,900
Public Works: Streets/Traffic 829,900328,400 165,300 318,100 18,100
Refuse 275,200275,200
Sewer 268,200223,000 45,200
Water 46,90046,900
1,838,229 1,464,997 1,093,754 1,684,329 1,134,212 7,215,521TOTAL
Wednesday, November 3, 202120DRAFT
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY DEPARTMENT
2022 2026thru
Total20222023202420252026DepartmentProject #Priority
Comm Svcs - Activity Center
01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a
01-ERP-0038 29,00017,000 12,000Activity Center - Kitchen Storage 5
01-ERP-0042 20,00020,000Activity Center - Replace Sanitizer/Heat Booster 2
55,70037,000 12,000 6,700Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
01-ERP-1102 7,1007,100Art Center Kitchen Catering Equipment n/a
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2
01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a
38,10013,500 6,700 10,800 7,100Comm Svcs - Arts Center Total
Comm Svcs - IT
01-ERP-0003 134,82025,000 26,250 27,037 27,849 28,684CH - Network Server n/a
01-ERP-0004 89,60089,600Telephone System n/a
01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a
01-ERP-0006 187,28634,729 36,465 37,559 38,686 39,847Computersn/a
01-ERP-0009 00Network Infrastructure Upgrade n/a
01-ERP-0012 20,00020,000Core Network Switch n/a
01-ERP-0014 57,00057,000Distribution Network Switches n/a
01-ERP-0015 150,92872,120 78,808Backup Server n/a
01-ERP-0017 228,08044,000 44,000 45,320 46,680 48,080IT - Office 365 n/a
01-ERP-0020 50,90910,000 10,000 10,000 10,300 10,609IT - Patching Automation Software 1
01-ERP-0022 147,00042,000 42,000 63,000IT - Windows 10 Enterprise Upgrade n/a
01-ERP-0024 90,00045,000 45,000IT - Sandbox Security Appliance n/a
01-ERP-0211 134,82125,000 26,250 27,038 27,849 28,684PD - Network Server n/a
1,605,444225,729 346,685 229,954 523,364 279,712Comm Svcs - IT Total
Community Services
01-ERP-0052 16,23116,231Electronic Inspections Processing 2
16,23116,231Community Services Total
Fire
01-ERP-0105 771,000771,000Quick Attack Pumper/Rescue (Rescue 8)n/a
01-ERP-0108 250,000250,000Self Contained Breathing Apparatus (SCBA) (45)n/a
01-ERP-0109 32,00032,000Extrication Tool (1)n/a
01-ERP-0112 16,18016,180Thermal Imaging Camera (2)n/a
01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a
01-ERP-0125 386,000386,000Fire Radios - Portable and Mobile Devices n/a
01-ERP-0126 16,00016,000Fire - Fire Helmets n/a
01-ERP-0127 18,00018,000Fire - Lucus Device n/a
01-ERP-0131 130,00055,000 75,000Fire - Station Alerting System n/a
Wednesday, November 3, 202121DRAFT
Total20222023202420252026DepartmentProject #Priority
1,657,680787,000 105,000 652,180 113,500Fire Total
HRA
01-ERP-0400 41,10041,1004x4 3/4 Ton Truck n/a
01-ERP-0401 16,50016,500HRA Copier n/a
57,60016,500 41,100HRA Total
Pavilion
01-ERP-1000 165,000165,000Pavilion Ice Resurfacer n/a
01-ERP-1001 8,9008,900Pavilion - Electric Ice Edger n/a
01-ERP-1002 12,00012,000Pavilion Arena Scoreboard n/a
01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a
197,50011,600 185,900Pavilion Total
Police
01-ERP-0200 590,200110,000 117,400 117,400 117,400 128,000Marked Patrol Vehicles (7)n/a
01-ERP-0201 64,15464,154Sergeant's Vehicle n/a
01-ERP-0202 60,00060,000PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 158,20072,100 86,100PSO - Utility 4x4 n/a
01-ERP-0212 160,000160,000Squad Car Camera Systems/ Body Worn Camera n/a
01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0215 290,000290,000Police - Portable Radios n/a
01-ERP-0217 90,00090,000Taser Replacement n/a
01-ERP-0218 39,00022,000 17,000Building Video Server n/a
01-ERP-0220 90,00090,000Squad Computers n/a
01-ERP-0221 150,000150,000Records Management System n/a
01-ERP-0227 50,00025,000 25,000Police Equipment n/a
1,818,066207,100 595,912 517,400 206,554 291,100Police Total
Public Works: Bldg/Equip Serv
01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a
42,10042,100Public Works: Bldg/Equip Serv Total
Public Works: Parks/Forestry
01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a
01-ERP-0804 163,600163,600Log Truck n/a
01-ERP-0808 17,70017,700Riding Mowers (2)1
01-ERP-0814 10,00010,000Trailer Flatbed n/a
01-ERP-0816 80,20080,200Toolcatn/a
306,900199,000 10,000 97,900Public Works: Parks/Forestry Total
Public Works: Streets/Traffic
01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a
01-ERP-0303 102,90053,400 49,5001 Ton Dump Truck (2)n/a
01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a
01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a
01-ERP-0308 268,600268,600Front End Loaders (2)n/a
01-ERP-0309 50,00050,000Skid Loader (2)n/a
01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a
829,900328,400 165,300 318,100 18,100Public Works: Streets/Traffic Total
Wednesday, November 3, 202122DRAFT
Total20222023202420252026DepartmentProject #Priority
Refuse
01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a
275,200275,200Refuse Total
Sewer
01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a
01-ERP-0555 43,00043,000Generator (2)n/a
01-ERP-0560 180,000180,000Sewer Televising Camera and Van 1
268,200223,000 45,200Sewer Total
Water
01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a
46,90046,900Water Total
GRAND TOTAL 7,215,5211,838,229 1,464,997 1,093,754 1,684,329 1,134,212
Wednesday, November 3, 202123DRAFT
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
FUNDING SOURCE SUMMARY
2022 thru 2026
TotalSource20222023202420252026
AC - Arts Center Fund 38,10013,500 6,700 10,800 7,100
Equipment Replacement Fund 6,228,6211,585,229 1,328,497 1,067,454 1,398,329 849,112
HRA - Housing and Redevelopment Authority 57,60016,500 41,100
PA - Pavilion Fund 197,50011,600 185,900
PKG - Parking Fund 8,0008,000
RF - Refuse Fund 357,00081,800 275,200
SF - Sanitary Sewer Fund 275,000223,000 6,800 45,200
WF - Water Fund 53,7006,800 46,900
1,838,229 1,464,997 1,093,754 1,684,329 1,134,212 7,215,521GRAND TOTAL
Wednesday, November 3, 2021
24DRAFT
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY FUNDING SOURCE
2022 2026thru
TotalSourceProject #Priority 2022 2023 2024 2025 2026
AC - Arts Center Fund
01-ERP-1102 7,1007,100Art Center Kitchen Catering Equipment n/a
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2
01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a
38,10013,500 6,700 10,800 7,100AC - Arts Center Fund Total
Equipment Replacement Fund
01-ERP-0003 134,82025,000 26,250 27,037 27,849 28,684CH - Network Server n/a
01-ERP-0004 76,00076,000Telephone System n/a
01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a
01-ERP-0006 187,28634,729 36,465 37,559 38,686 39,847Computersn/a
01-ERP-0009 00Network Infrastructure Upgrade n/a
01-ERP-0012 20,00020,000Core Network Switch n/a
01-ERP-0014 57,00057,000Distribution Network Switches n/a
01-ERP-0015 150,92872,120 78,808Backup Server n/a
01-ERP-0017 228,08044,000 44,000 45,320 46,680 48,080IT - Office 365 n/a
01-ERP-0020 50,90910,000 10,000 10,000 10,300 10,609IT - Patching Automation Software 1
01-ERP-0022 147,00042,000 42,000 63,000IT - Windows 10 Enterprise Upgrade n/a
01-ERP-0024 90,00045,000 45,000IT - Sandbox Security Appliance n/a
01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a
01-ERP-0038 29,00017,000 12,000Activity Center - Kitchen Storage 5
01-ERP-0042 20,00020,000Activity Center - Replace Sanitizer/Heat Booster 2
01-ERP-0052 16,23116,231Electronic Inspections Processing 2
01-ERP-0105 771,000771,000Quick Attack Pumper/Rescue (Rescue 8)n/a
01-ERP-0108 250,000250,000Self Contained Breathing Apparatus (SCBA) (45)n/a
01-ERP-0109 32,00032,000Extrication Tool (1)n/a
01-ERP-0112 16,18016,180Thermal Imaging Camera (2)n/a
01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a
01-ERP-0125 386,000386,000Fire Radios - Portable and Mobile Devices n/a
01-ERP-0126 16,00016,000Fire - Fire Helmets n/a
01-ERP-0127 18,00018,000Fire - Lucus Device n/a
01-ERP-0131 130,00055,000 75,000Fire - Station Alerting System n/a
01-ERP-0200 590,200110,000 117,400 117,400 117,400 128,000Marked Patrol Vehicles (7)n/a
01-ERP-0201 64,15464,154Sergeant's Vehicle n/a
01-ERP-0202 60,00060,000PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 158,20072,100 86,100PSO - Utility 4x4 n/a
01-ERP-0211 134,82125,000 26,250 27,038 27,849 28,684PD - Network Server n/a
01-ERP-0212 152,000152,000Squad Car Camera Systems/ Body Worn Camera n/a
01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0215 290,000290,000Police - Portable Radios n/a
01-ERP-0217 90,00090,000Taser Replacement n/a
01-ERP-0218 39,00022,000 17,000Building Video Server n/a
01-ERP-0220 90,00090,000Squad Computers n/a
Wednesday, November 3, 2021
25DRAFT
TotalSourceProject #Priority 2022 2023 2024 2025 2026
01-ERP-0221 150,000150,000Records Management System n/a
01-ERP-0227 50,00025,000 25,000Police Equipment n/a
01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a
01-ERP-0303 102,90053,400 49,5001 Ton Dump Truck (2)n/a
01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a
01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a
01-ERP-0308 268,600268,600Front End Loaders (2)n/a
01-ERP-0309 50,00050,000Skid Loader (2)n/a
01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a
01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a
01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a
01-ERP-0804 81,80081,800Log Truck n/a
01-ERP-0808 17,70017,700Riding Mowers (2)1
01-ERP-0814 10,00010,000Trailer Flatbed n/a
01-ERP-0816 80,20080,200Toolcatn/a
6,228,6211,585,229 1,328,497 1,067,454 1,398,329 849,112Equipment Replacement Fund Total
HRA - Housing and Redevelopment A
01-ERP-0400 41,10041,1004x4 3/4 Ton Truck n/a
01-ERP-0401 16,50016,500HRA Copier n/a
57,60016,500 41,100HRA - Housing and Redevelopment
Authority Total
PA - Pavilion Fund
01-ERP-1000 165,000165,000Pavilion Ice Resurfacer n/a
01-ERP-1001 8,9008,900Pavilion - Electric Ice Edger n/a
01-ERP-1002 12,00012,000Pavilion Arena Scoreboard n/a
01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a
197,50011,600 185,900PA - Pavilion Fund Total
PKG - Parking Fund
01-ERP-0212 8,0008,000Squad Car Camera Systems/ Body Worn Camera n/a
8,0008,000PKG - Parking Fund Total
RF - Refuse Fund
01-ERP-0804 81,80081,800Log Truck n/a
01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a
357,00081,800 275,200RF - Refuse Fund Total
SF - Sanitary Sewer Fund
01-ERP-0004 6,8006,800Telephone System n/a
01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a
01-ERP-0555 43,00043,000Generator (2)n/a
01-ERP-0560 180,000180,000Sewer Televising Camera and Van 1
275,000223,000 6,800 45,200SF - Sanitary Sewer Fund Total
WF - Water Fund
Wednesday, November 3, 2021
26DRAFT
TotalSourceProject #Priority 2022 2023 2024 2025 2026
01-ERP-0004 6,8006,800Telephone System n/a
01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a
53,7006,800 46,900WF - Water Fund Total
7,215,5211,838,229 1,464,997 1,093,754 1,684,329 1,134,212GRAND TOTAL
Wednesday, November 3, 2021
27DRAFT
2022 –2026 Equipment
Replacement & Capital
Improvement Plans
November 9, 2021
Equipment Replacement Fund
Funding Sources -$1.76 million
User Department Charges
$669,755 in 2022, a 6% increase
o 99.88% in General Fund
o 0.06% in Economic Development and Communications Funds
$250,000 Tax Levy in 2022
Reduced by $175,000
Equipment Certificates (bond proceeds) of $996K
in 2022
Equipment Replacement Fund
2022 projects total $1,620,477
Fire -$787,000
Streets/Traffic -$328,400
Information Technology -$225,729
Police -$207,100
Activity Center -$37,000
Equipment Replacement Fund
Bond Proceeds of $996,000
Quick Attack Pumper Fire Truck -$771,000
Single Axle Dump Truck -$225,000
Equipment Replacement Fund
Projecting a $136,063,063 increase to fund
balance
Ending balance in Equipment Replacement
Fund of $920,691
Capital Improvement Plan
Funds Supported by Tax Levy
Arts Center
Capital Improvement
Park Dedication
Permanent Improvement
Revolving
Pavilion
Directly Funded
Water
Sanitary Sewer
Storm Sewer
Refuse
Capital Improvement Fund
Funding Sources
Tax Levy, $190,000 in 2022
Reduced by $10,000
Franchise Fees, $361,500 in 2022
Bond Proceeds, none planned
Capital Improvement Fund
$106,400 of projects in 2022
Activity Center & Fire Station
Reduced by $10,000
Bond Payments of $360,000
City Hall
Projected to increase fund balance by $87,172
Permanent Improvement
Funding Sources
Bond Proceeds, $1.945 Million in 2022
Paid by tax levy & special assessments
Bond issuance will also include amounts for Water,
Sewer & Storm Sewer Fund
Prepaid Special Assessments of $100,000
Permanent Improvement
Previously included projects
6th Ave South/7th Ave South -$1.15 million
Trunk Water Main -$450K
May not actually need support from this fund
Pedestrian & Bicycle Access, Street Rehabilitation
and Sign Management -$445K
Permanent Improvement
Previously proposed, but not funded
City Street Lighting Upgrade -$110,000
Feltl Court
Current lighting is an end of useful life and not efficient
Reallocate equipment replacement or capital
improvement levies
Pavilion Fund
2022 Requests
Replace and Upgrade Sound System -$70,000
Replace 60 high bay lighting fixtures with LED
fixtures -$18,000
Reallocate equipment replacement or capital
improvement levies
Next Steps –2022 Budget
Meeting Date Meeting
Type
Subject Details
November 16 Regular
Meeting
Approve CIP and ERP
December 6
(Monday)
Special
Meeting
Truth in Taxation Hearing -Overview of 2022 Budget and Tax
Levy
-Public Comment
December 7 Regular
Meeting
Approve Final Budget and
Tax Levy
December 21 Regular
Meeting
Approve Final Budget and
Tax Levy
-Last scheduled meeting to approve