2023 – 2027 Capital Improvement & Equipment Replacement Plans; Bishop CITY OF HOPKINS
Memorandum
To: Honorable Mayor and Council Members
Mike Mornson, City Manager
From: Nick Bishop, Finance Director
Date: August 8, 2022
Subject: 2023 – 2027 Capital Improvement & Equipment Replacement Plans
_____________________________________________________________________
PURPOSE
To provide input and guidance for the 2023 – 2027 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, Pavilion requests for 2023 and General Fund Surplus. Projected cash flows are
based on amounts in the draft levy presented on July 12, 2022.
Five year summary information for the Capital Improvement Plan is on pages 9 to
17 and for the Equipment Replacement Plan on pages 18 to 28.
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 that can be used for any purpose. 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 $348,000 of park dedication fees in 2022.
In 2023, the Park Improvement Fund has projected revenues of $1,951,468 and
projected expenditures of $130,000. The fund is projected to increase its fund balance
by $1,821,468 and end 2023 with a fund balance of $2,668,245.
The City is currently in the process of developing a new Park System Master Plan,
establishing a 20-year vision for Hopkins parks, open and public spaces. The CIP will
be adjusted after completion of the plan.
2023 2024
Beginning Fund Balance 846,777 2,668,245
Revenues & Other Financing Sources
Franchise Fees 305,000 305,000
Park Dedication Fees 1,638,000 -
Interest Earnings 8,468 26,682
Total Revenue & Other Financing Sources 1,951,468 331,682
Expenditures & Other Financing Uses
Current Expenditures 15,000 15,000
Capital Projects
Shady Oak Beach Improvements 5,000 29,700
Central Park Picnic Shelters Rehab - 60,000
Central Park East Play Equipment Replacement - 100,000
Improve Courts at Oakes and Cottageville Park - 190,000
Repair Valley Park Basketball Court - 70,000
Debt Service Transfers
Cottageville Park Bonds 110,000 120,000
Burnes Park Bonds - -
Total Expenditures and Other Financing Sources 130,000 584,700
Increase (Decrease) in Fund Balance 1,821,468 (253,018)
Projected Ending Fund Balance
Restricted for Park Dedication Costs 2,146,273 2,067,736
Committed for Park Improvements & Maintenance 521,972 347,491
Total Projected Ending Fund Balance 2,668,245 2,415,227
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, Public Works Building and portions of the Arts Center (new for
2024). Its two funding sources are franchise fees from gas and electric utilities and a
property tax levy.
In 2023, the Capital Improvement Fund has projected revenues of $790,140 and
projected expenditures of $360,000. The fund is projected to increase its fund balance
by $430,140 and end 2023 with a fund balance of $529,169. The increase in fund
balance and transfer in of general fund surplus will allow for projects to be completed in
2024.
2023 2024
Beginning Fund Balance 99,029 529,169
Revenues & Other Financing Sources
Tax Levy - -
Franchise Fees 361,500 361,500
Interest Earnings 990 5,360
Transfer In 427,650 -
Total Revenue & Other Financing Sources 790,140 366,860
Expenditures & Other Financing Uses
Current Expenditures
Capital Projects
Activity Center - Raspberry Room Roof Replacement - 80,000
Activity Center - Lower Roof Replacement - 80,000
Activity Center - Tuckpointing & Repair of Brick - 120,000
Arts Center - Roof Replacement (50% of Cost)- 75,000
Fire Station - Replace 25 Ton AHU - 82,000
Debt Service Transfers - City Hall 360,000 360,000
Total Expenditures and Other Financing Sources 360,000 797,000
Increase (Decrease) in Fund Balance 430,140 (430,140)
Projected Ending Fund Balance 529,169 99,029
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, 2023, the Permanent Improvement Revolving Fund is projected to receive
$3,480,000 of bond proceeds. The major expenditures of the fund are the West Central
Avenues street reconstruction project and a mill and overlay projects on 11th Ave S and
Lot 700. 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 street lighting upgrades in the Central Business District and 11th
Ave S. The project cannot be funded through bonds or special assessments. In the
2023 Draft Levy the upgrades are funded with a transfer in of general fund surplus.
This proposal delays the start of the Central Avenues street reconstruction project by
one year to 2025. The process of evaluating the pavement condition of all city streets
will be completed in 2022 and results available before a decision needs to be made.
2023 2024
Beginning Fund Balance 410,167 909,269
Revenues & Other Financing Sources
Tax Levy - 240,000
Special Assessments (Prepaid)210,000 -
Interest Earnings 4,102 4,143
Bond Proceeds 3,975,000 -
Transfer In 290,000 -
Total Revenue & Other Financing Sources 4,479,102 244,143
Expenditures & Other Financing Uses
Capital Projects
West Central Avenues 3,220,000 -
Central Avenues (2025-2027)- -
Pedestrian & Bicycle Access Improvements 25,000 25,000
Street Rehabilitation (Mill & Overlay)425,000 450,000
Street Sign Management 20,000 20,000
Street Lighting Upgrades 190,000 40,000
Central Business District Lighting Upgrades 100,000 200,000
Total Expenditures and Other Financing Sources 3,980,000 735,000
Increase (Decrease) in Fund Balance 499,102 (490,857)
Projected Ending Fund Balance 909,269 418,412
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 2023, the Equipment Replacement Fund has projected revenues of $1,307,210,
including transfers in of $220,564. The projected expenditures are $1,763,945. Major
purchases proposed for 2022 include, portable radios ($290,000), police records
management system ($200,000) and a log truck ($163,600). The fund is projected to
decrease its net position by $429,735 and end 2023 with a net position of $560,917.
The fund will rebound and end 2024 with a fund balance of $990,652.
2023 2024
Beginning Fund Balance 990,652 560,917
Revenues & Other Financing Sources
Tax Levy 250,000 250,000
Equipment Charges 709,940 752,536
Sale of Equipment 35,000 35,000
Interest Earnings 9,906 5,609
Equipment Certificates (Bonds)81,800 318,100
Transfer In 220,564 -
Total Revenue & Other Financing Sources 1,307,210 1,361,245
Expenditures & Other Financing Uses
Current Expenditures 35,600 35,956
Capital Projects
Community Services - Activity Center - -
Community Services - Information Technology 416,085 255,954
Fire Vehicles & Equipment 156,000 -
Police Vehicles & Equipment 948,160 311,500
Public Works: Parks/Forestry 117,200 10,000
Public Works: Streets/Traffic 63,900 318,100
Total Expenditures and Other Financing Sources 1,736,945 931,510
Increase (Decrease) in Fund Balance (429,735) 429,735
Projected Ending Fund Balance 560,917 990,652
Equipment Replacement Fund - Projected Cash Flows
6
Pavilion Requests
The Pavilion Fund request is to replace the indoor turf system for $120,000. The
current turf was purchased in 1998 with an expected useful life of 15 years. It is
showing signs of wear and needs replacement.
.
The Pavilion Fund budget is currently being completed. The operating budget may not
be able to fund this projects. Staff is proposing using General Fund Surplus as a
funding source
General Fund Surplus
The City is projected to have a surplus in the general fund of $1,196,479 at the end of
2022. The ERP/CIP being proposed uses $1,058,214 of the surplus. A remaining
balance of $138,265 would be available for other initiatives including a Fire Department
Staffing Study. The City also has $400,000 of unallocated ARPA funds.
Fund/Use Amount
Capital Improvement Fund/2024 Projects $427,650
PIR Fund/Street Lighting $290,000
Equipment Replacement Fund $220,564
Pavilion/Indoor Turf System $120,000
August 8, 2022
City of Hopkins
2023 Budget Preparation Schedule for City Council
The following table outlines the tentative schedule for discussions on important aspects of the City’s Budget and American
Rescue Plan Act (ARPA) Spending Plan.
Meeting Date Meeting Type Subject Details
April-July N/A Internal Preparations -2021 Audit Ongoing
-Departments Prepare Budgets, Equipment
Replacement and Capital Improvement Schedules
July 12 Work Session Review 2023 Tax Levy and
General Fund Budget
-First Draft
August 8 Work Session
(Monday)
Review Capital Improvement
Plan (CIP) and Equipment
Replacement Plan (ERP)
-Equipment Replacement Fund
-Park Improvement
-Capital Improvement
-Permanent Improvement Fund (Street Projects)
August 15 Community
Event
Review 2023 Tax Levy and
General Fund Budget
-Presentation
-Question and Answer Session
September 6 Regular Meeting -Approve Preliminary Tax Levy
and General Fund Budget
-Approve CIP and ERP
-Preliminary Levy must be approved by
September 30
October 11 Work Session Review, Special Revenue
Fund Budgets, Enterprise
Fund Budgets, Activity Center
Budget and Utility Rates
-Water -Sewer
-Storm Sewer -Refuse
-Pavilion -Communications
-Chemical Assessment -Parking
-Economic Development -Depot
-Activity Center -Arts Center
7
August 8, 2022
City of Hopkins
2023 Budget Preparation Schedule for City Council
Meeting Date Meeting Type Subject Details
November 1 Regular Meeting Approve Utility Rates
November 30
Regular Meeting
(Wednesday)
Truth in Taxation Hearing -Overview of 2023 Budget and Tax Levy
-Public Comment
December 6 Regular Meeting Approve Final Budget & Tax
Levy
-Final Levy must be approved by December 28
8
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
PROJECTS BY YEAR
2023 2027thru
Project Name Department Project #Priority Project Cost
2023
19-CIP-AR002Arts Center - Outdoor Signage/lighting 2 25,000Comm Svcs - Arts Center
19-CIP-AR005Arts Center - Key Card Exterior & Interior Access 2 10,000Comm Svcs - Arts Center
19-CIP-PV330Pavilion - Indoor Turf System Replacement 2 120,000Pavilion
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
16-CIP-R003Shady Oak Beach Improvements 3 15,000Recreation
7,504,000Total for 2023
2024
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
22-CIP-AC052Activity Center - Tuckpointing & Repair of Brick 2 120,000Comm Svcs - Activity Center
19-CIP-AR002Arts Center - Outdoor Signage/lighting 2 10,000Comm Svcs - Arts Center
19-CIP-AR005Arts Center - Key Card Exterior & Interior Access 2 10,000Comm Svcs - Arts Center
19-CIP-AR007Arts Center - Roof Replacement 2 150,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
22-CIP-PV335Pavilion - Water Heater Replacement n/a 38,000Pavilion
13-CIP-P044Improve Courts at Oakes Park and Cottageville Park n/a 190,000Public Works: Parks
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
21-CIP-P073Repair Valley Park Basketball Court n/a 70,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 0Public 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 90,000Recreation
2,007,000Total for 2024
2025
19-CIP-AR005Arts Center - Key Card Exterior & Interior Access 2 10,000Comm Svcs - Arts Center
20-CIP-PV333Pavilion - Mezzanine Flooring Replacement 3 90,000Pavilion
08-CIP-PD215City Hall Police Station Rooftop n/a 240,000Police
Thursday, August 4, 2022
9
Project Name Department Project #Priority Project Cost
21-CIP-P074Repair Burnes Park Tennis Courts n/a 130,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 7,843,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 20,000Recreation
9,111,000Total for 2025
2026
09-CIP-CH032Council Chambers HVAC Unit n/a 15,000City Hall Administration
19-CIP-AR005Arts Center - Key Card Exterior & Interior Access 2 10,000Comm Svcs - Arts Center
08-CIP-B023Public Works - Replace Overhead Doors n/a 90,000Public Works: Bldg/Equip Serv
22-CIP-B102Undercarriage Wash System 3 70,000Public Works: Bldg/Equip Serv
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,854,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
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
9,043,000Total for 2026
2027
09-CIP-CH035City Hall AC Rooftop Units n/a 50,000City Hall Administration
14-CIP-AR003Arts Center - Paint Theatre 2 28,000Comm Svcs - Arts Center
19-CIP-AR005Arts Center - Key Card Exterior & Interior Access 2 10,000Comm Svcs - Arts Center
13-CIP-P049Burnes Park - Tennis Courts Reconstruction n/a 180,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 7,869,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 550,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
20-CIP-S002City Street Lighting Upgrades n/a 60,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 30,000Public Works: Utilities
18-CIP-U016Sewer Lining 2 75,000Public Works: Utilities
19-CIP-U017Trunk Water Main Rehabilitation 2 5,000,000Public Works: Utilities
16-CIP-R003Shady Oak Beach Improvements 3 10,000Recreation
16,807,000Total for 2027
GRAND TOTAL 44,472,000
Thursday, August 4, 2022
10
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
DEPARTMENT SUMMARY
2023 2027thru
Total20232024202520262027Department
City Hall Administration 65,00015,000 50,000
Comm Svcs - Activity Center 280,000280,000
Comm Svcs - Arts Center 263,00035,000 170,000 10,000 10,000 38,000
Fire 82,00082,000
Pavilion 353,000120,000 143,000 90,000
Police 240,000240,000
Public Works: Bldg/Equip Serv 160,000160,000
Public Works: Parks 850,000420,000 130,000 120,000 180,000
Public Works: Streets/Traffic 36,564,0007,253,000 735,000 8,528,000 8,624,000 11,424,000
Public Works: Utilities 5,470,00081,000 87,000 93,000 104,000 5,105,000
Recreation 145,00015,000 90,000 20,000 10,000 10,000
7,504,000 2,007,000 9,111,000 9,043,000 16,807,000 44,472,000TOTAL
Thursday, August 4, 202211
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
PROJECTS BY DEPARTMENT
2023 2027thru
Total20232024202520262027DepartmentProject #Priority
City Hall Administration
09-CIP-CH035 50,00050,000City Hall AC Rooftop Units n/a
09-CIP-CH032 15,00015,000Council Chambers HVAC Unit n/a
65,00015,000 50,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
22-CIP-AC052 120,000120,000Activity Center - Tuckpointing & Repair of Brick 2
280,000280,000Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
19-CIP-AR007 150,000150,000Arts Center - Roof Replacement 2
14-CIP-AR003 28,00028,000Arts Center - Paint Theatre 2
19-CIP-AR002 35,00025,000 10,000Arts Center - Outdoor Signage/lighting 2
19-CIP-AR005 50,00010,000 10,000 10,000 10,000 10,000Arts Center - Key Card Exterior & Interior Access 2
263,00035,000 170,000 10,000 10,000 38,000Comm Svcs - Arts Center Total
Fire
08-CIP-B121 82,00082,000Fire Station: Replace 25 Ton AHU n/a
82,00082,000Fire Total
Pavilion
20-CIP-PV333 90,00090,000Pavilion - Mezzanine Flooring Replacement 3
20-CIP-PV334 105,000105,000Pavilion - Arena Exit Door Replacement 3
22-CIP-PV335 38,00038,000Pavilion - Water Heater Replacement n/a
19-CIP-PV330 120,000120,000Pavilion - Indoor Turf System Replacement 2
353,000120,000 143,000 90,000Pavilion Total
Police
08-CIP-PD215 240,000240,000City Hall Police Station Rooftop n/a
240,000240,000Police Total
Public Works: Bldg/Equip Serv
08-CIP-B023 90,00090,000Public Works - Replace Overhead Doors n/a
22-CIP-B102 70,00070,000Undercarriage Wash System 3
160,000160,000Public Works: Bldg/Equip Serv Total
Public Works: Parks
13-CIP-P049 180,000180,000Burnes Park - Tennis Courts Reconstruction n/a
Thursday, August 4, 202212
Total20232024202520262027DepartmentProject #Priority
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
13-CIP-P044 190,000190,000Improve Courts at Oakes Park and Cottageville Park n/a
850,000420,000 130,000 120,000 180,000Public Works: Parks Total
Public Works: Streets/Traffic
13-CIP-S040 200,00025,000 25,000 100,000 25,000 25,000Pedestrian & Bicycle Access Improvements n/a
20-CIP-S005 600,000600,000Minnetonka Mills/5th St N Signal Replacement 5
20-CIP-S002 765,000190,000 200,000 90,000 225,000 60,000City Street Lighting Upgrades n/a
20-CIP-S001 140,000100,000 40,000Central Business District Lighting Upgrades n/a
16-CIP-S041 2,400,000425,000 450,000 475,000 500,000 550,000Street Rehabilitation Improvements n/a
01-CIP-S104 2,300,0002,300,000County Road 3 n/a
01-CIP-S101 30,059,0006,493,000 0 7,843,000 7,854,000 7,869,000Residential Street Improvements and Utilities n/a
16-CIP-S042 100,00020,000 20,000 20,000 20,000 20,000Street Sign Management n/a
36,564,0007,253,000 735,000 8,528,000 8,624,000 11,424,000Public Works: Streets/Traffic Total
Public Works: Utilities
01-CIP-U002 140,00026,000 27,000 28,000 29,000 30,000Storm Drainage System Maintenance - Alley Repairs n/a
18-CIP-U016 330,00055,000 60,000 65,000 75,000 75,000Sewer Lining 2
19-CIP-U017 5,000,0005,000,000Trunk Water Main Rehabilitation 2
5,470,00081,000 87,000 93,000 104,000 5,105,000Public Works: Utilities Total
Recreation
16-CIP-R003 145,00015,000 90,000 20,000 10,000 10,000Shady Oak Beach Improvements 3
145,00015,000 90,000 20,000 10,000 10,000Recreation Total
GRAND TOTAL 44,472,0007,504,000 2,007,000 9,111,000 9,043,000 16,807,000
Thursday, August 4, 202213
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
FUNDING SOURCE SUMMARY
2023 thru 2027
TotalSource20232024202520262027
AC - Arts Center Fund 188,00035,000 95,000 10,000 10,000 38,000
CI - Capital Improvement Fund 830,000437,000 240,000 103,000 50,000
GU - Other Governmental Units 1,697,10010,000 60,300 13,400 6,700 1,606,700
MS - Municipal State Aid Streets 700,000700,000
PA - Pavilion Fund 353,000120,000 143,000 90,000
PDF- Park Dedication Fund 897,9005,000 449,700 136,600 123,300 183,300
PI - PIR/General Obligation Bonds 15,402,0002,930,000 735,000 3,685,000 3,781,000 4,271,000
RF - Refuse Fund 18,00018,000
SA - Special Assessment 4,188,0001,050,000 0 1,046,000 1,046,000 1,046,000
SF - Sanitary Sewer Fund 6,475,0001,418,000 60,000 1,653,000 1,681,000 1,663,000
SU - Storm Sewer Fund 2,520,000506,000 27,000 652,000 671,000 664,000
WF - Water Fund 11,203,0001,430,000 0 1,585,000 1,603,000 6,585,000
7,504,000 2,007,000 9,111,000 9,043,000 16,807,000 44,472,000GRAND TOTAL
Thursday, August 4, 2022
14
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN - CIP
PROJECTS BY FUNDING SOURCE
2023 2027thru
TotalSourceProject #Priority 2023 2024 2025 2026 2027
AC - Arts Center Fund
14-CIP-AR003 28,00028,000Arts Center - Paint Theatre 2
19-CIP-AR002 35,00025,000 10,000Arts Center - Outdoor Signage/lighting 2
19-CIP-AR005 50,00010,000 10,000 10,000 10,000 10,000Arts Center - Key Card Exterior & Interior Access 2
19-CIP-AR007 75,00075,000Arts Center - Roof Replacement 2
188,00035,000 95,000 10,000 10,000 38,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-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
09-CIP-CH035 50,00050,000City Hall AC Rooftop Units n/a
19-CIP-AR007 75,00075,000Arts Center - Roof Replacement 2
22-CIP-AC052 120,000120,000Activity Center - Tuckpointing & Repair of Brick 2
22-CIP-B102 70,00070,000Undercarriage Wash System 3
830,000437,000 240,000 103,000 50,000CI - Capital Improvement Fund Total
GU - Other Governmental Units
01-CIP-S104 1,600,0001,600,000County Road 3 n/a
16-CIP-R003 97,10010,000 60,300 13,400 6,700 6,700Shady Oak Beach Improvements 3
1,697,10010,000 60,300 13,400 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 120,000120,000Pavilion - Indoor Turf System Replacement 2
20-CIP-PV333 90,00090,000Pavilion - Mezzanine Flooring Replacement 3
20-CIP-PV334 105,000105,000Pavilion - Arena Exit Door Replacement 3
22-CIP-PV335 38,00038,000Pavilion - Water Heater Replacement n/a
353,000120,000 143,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
Thursday, August 4, 2022
15
TotalSourceProject #Priority 2023 2024 2025 2026 2027
13-CIP-P049 180,000180,000Burnes Park - Tennis Courts Reconstruction n/a
16-CIP-R003 47,9005,000 29,700 6,600 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
897,9005,000 449,700 136,600 123,300 183,300PDF- Park Dedication Fund Total
PI - PIR/General Obligation Bonds
01-CIP-S101 11,207,0002,170,000 0 3,000,000 3,011,000 3,026,000Residential Street Improvements and Utilities n/a
13-CIP-S040 200,00025,000 25,000 100,000 25,000 25,000Pedestrian & Bicycle Access Improvements n/a
16-CIP-S041 2,400,000425,000 450,000 475,000 500,000 550,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 765,000190,000 200,000 90,000 225,000 60,000City Street Lighting Upgrades n/a
20-CIP-S005 590,000590,000Minnetonka Mills/5th St N Signal Replacement 5
15,402,0002,930,000 735,000 3,685,000 3,781,000 4,271,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,188,0001,050,000 0 1,046,000 1,046,000 1,046,000Residential Street Improvements and Utilities n/a
4,188,0001,050,000 0 1,046,000 1,046,000 1,046,000SA - Special Assessment Total
SF - Sanitary Sewer Fund
01-CIP-S101 6,127,0001,363,000 0 1,588,000 1,588,000 1,588,000Residential Street Improvements and Utilities n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
18-CIP-U016 330,00055,000 60,000 65,000 75,000 75,000Sewer Lining 2
6,475,0001,418,000 60,000 1,653,000 1,681,000 1,663,000SF - Sanitary Sewer Fund Total
SU - Storm Sewer Fund
01-CIP-S101 2,352,000480,000 0 624,000 624,000 624,000Residential Street Improvements and Utilities n/a
01-CIP-U002 140,00026,000 27,000 28,000 29,000 30,000Storm Drainage System Maintenance - Alley Repairs n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
20-CIP-S005 10,00010,000Minnetonka Mills/5th St N Signal Replacement 5
2,520,000506,000 27,000 652,000 671,000 664,000SU - Storm Sewer Fund Total
WF - Water Fund
01-CIP-S101 6,185,0001,430,000 0 1,585,000 1,585,000 1,585,000Residential Street Improvements and Utilities n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
19-CIP-U017 5,000,0005,000,000Trunk Water Main Rehabilitation 2
11,203,0001,430,000 0 1,585,000 1,603,000 6,585,000WF - Water Fund Total
Thursday, August 4, 2022
16
TotalSourceProject #Priority 2023 2024 2025 2026 2027
44,472,0007,504,000 2,007,000 9,111,000 9,043,000 16,807,000GRAND TOTAL
Thursday, August 4, 2022
17
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY YEAR
2023 2027thru
Project Name Department Project #Priority Project Cost
2023
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-0009Network Infrastructure Upgrade - Fiber n/a 60,000Comm 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 33,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 38,000Fire
01-ERP-0127Fire - Lucus Device n/a 18,000Fire
01-ERP-0131Fire - Station Alerting System n/a 100,000Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 120,000Police
01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 81,160Police
01-ERP-0215Police - Portable Radios n/a 290,000Police
01-ERP-0217Taser Replacement n/a 140,000Police
01-ERP-0218Building Video Server n/a 22,000Police
01-ERP-0221Records Management System n/a 200,000Police
01-ERP-0227Police Equipment n/a 25,000Police
01-ERP-0228Administrative Vehicles n/a 70,000Police
01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry
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-0322Streets/Parks Supervisor Vehicle 1 35,000Public Works: Streets/Traffic
01-ERP-0510Utilities Supervisor Vehicle n/a 35,000Water
1,831,745Total for 2023
2024
01-ERP-1105Art Center Jaycee Studio Audio Visual n/a 13,500Comm 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 36,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 120,000Police
01-ERP-0212Squad Car Camera Systems n/a 70,000Police
01-ERP-0220Squad Computers n/a 90,000Police
01-ERP-0228Administrative Vehicles n/a 35,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
Wednesday, August 3, 2022
18
Project Name Department Project #Priority Project Cost
01-ERP-0555Generator (2)n/a 43,000Sewer
967,154Total 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-0009Network Infrastructure Upgrade - Fiber n/a 70,000Comm 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 40,000Comm Svcs - IT
01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 43,260Comm 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 300,000Fire
01-ERP-0112Thermal Imaging Camera (2)n/a 18,600Fire
01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 455,000Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 120,000Police
01-ERP-0201Sergeant's Vehicle n/a 65,000Police
01-ERP-03041 Ton Traffic Boom Truck n/a 136,400Public Works: Streets/Traffic
01-ERP-0900Refuse Truck (RAP-R) (2)n/a 275,200Refuse
2,063,555Total for 2025
2026
01-ERP-0035Activity Center - Floor Scrubber n/a 6,700Comm Svcs - Activity 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 40,000Comm Svcs - IT
01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 44,558Comm 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
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 130,000Police
01-ERP-0202PSO / Parking Enforcement Vehicle n/a 65,000Police
01-ERP-0203PSO - Utility 4x4 n/a 86,100Police
01-ERP-0218Building Video Server n/a 25,000Police
01-ERP-0227Police Equipment n/a 25,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,166,061Total for 2026
2027
01-ERP-0003CH - Network Server n/a 29,545Comm Svcs - IT
01-ERP-0006Computers n/a 41,042Comm Svcs - IT
Wednesday, August 3, 2022
19
Project Name Department Project #Priority Project Cost
01-ERP-0017IT - Office 365 n/a 49,522Comm Svcs - IT
01-ERP-0020IT - Patching Automation Software 1 40,000Comm Svcs - IT
01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 45,895Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 29,545Comm Svcs - IT
01-ERP-0100Tele-Squirt (Engine 2)n/a 1,000,000Fire
01-ERP-0101Fire Pumper (Engine 3)n/a 900,000Fire
01-ERP-0112Thermal Imaging Camera (2)n/a 20,000Fire
01-ERP-0114Floor Scrubber n/a 20,300Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 130,000Police
01-ERP-0217Taser Replacement n/a 90,041Police
01-ERP-0714PW - Truck Scan Kit 1 14,143Public Works: Bldg/Equip Serv
01-ERP-0807Trucksters (3)n/a 17,140Public Works: Parks/Forestry
01-ERP-03014X4 3/4 Ton Truck with Plow n/a 38,500Public Works: Streets/Traffic
01-ERP-0308Front End Loaders (2)n/a 268,000Public Works: Streets/Traffic
01-ERP-05003/4 Ton Truck n/a 36,000Water
01-ERP-0509Water Treatment Plant 1 134,392Water
2,904,065Total for 2027
GRAND TOTAL 8,932,580
Wednesday, August 3, 2022
20
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
DEPARTMENT SUMMARY
2023 2027thru
Total20232024202520262027Department
Comm Svcs - Activity Center 6,7006,700
Comm Svcs - Arts Center 24,30013,500 10,800
Comm Svcs - IT 1,941,173429,685 255,954 666,324 353,661 235,549
Community Services 16,23116,231
Fire 2,908,400156,000 773,600 38,500 1,940,300
Pavilion 197,50011,600 185,900
Police 1,999,301948,160 315,000 185,000 331,100 220,041
Public Works: Bldg/Equip Serv 56,24342,100 14,143
Public Works: Parks/Forestry 324,040199,000 10,000 97,900 17,140
Public Works: Streets/Traffic 843,00063,900 318,100 136,400 18,100 306,500
Refuse 275,200275,200
Sewer 88,20043,000 45,200
Water 252,29235,000 46,900 170,392
1,831,745 967,154 2,063,555 1,166,061 2,904,065 8,932,580TOTAL
Wednesday, August 3, 202221
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY DEPARTMENT
2023 2027thru
Total20232024202520262027DepartmentProject #Priority
Comm Svcs - Activity Center
01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a
6,7006,700Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a
24,30013,500 10,800Comm Svcs - Arts Center Total
Comm Svcs - IT
01-ERP-0009 130,00060,000 70,000Network Infrastructure Upgrade - Fiber n/a
01-ERP-0024 45,00045,000IT - Sandbox Security Appliance n/a
01-ERP-0022 238,71342,000 63,000 43,260 44,558 45,895IT - Windows 10 Enterprise Upgrade n/a
01-ERP-0020 189,00033,000 36,000 40,000 40,000 40,000IT - Patching Automation Software 1
01-ERP-0017 233,60244,000 45,320 46,680 48,080 49,522IT - Office 365 n/a
01-ERP-0015 150,92872,120 78,808Backup Server n/a
01-ERP-0012 20,00020,000Core Network Switch n/a
01-ERP-0211 139,36626,250 27,038 27,849 28,684 29,545PD - Network Server n/a
01-ERP-0006 193,59936,465 37,559 38,686 39,847 41,042Computersn/a
01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a
01-ERP-0004 89,60089,600Telephone System n/a
01-ERP-0003 139,36526,250 27,037 27,849 28,684 29,545CH - Network Server n/a
01-ERP-0014 57,00057,000Distribution Network Switches n/a
1,941,173429,685 255,954 666,324 353,661 235,549Comm Svcs - IT Total
Community Services
01-ERP-0052 16,23116,231Electronic Inspections Processing 2
16,23116,231Community Services Total
Fire
01-ERP-0114 20,30020,300Floor Scrubber n/a
01-ERP-0131 100,000100,000Fire - Station Alerting System n/a
01-ERP-0100 1,000,0001,000,000Tele-Squirt (Engine 2)n/a
01-ERP-0125 455,000455,000Fire Radios - Portable and Mobile Devices n/a
01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a
01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a
01-ERP-0109 38,00038,000Extrication Tool (1)n/a
01-ERP-0108 300,000300,000Self Contained Breathing Apparatus (SCBA) (45)n/a
01-ERP-0101 900,000900,000Fire Pumper (Engine 3)n/a
01-ERP-0127 18,00018,000Fire - Lucus Device n/a
2,908,400156,000 773,600 38,500 1,940,300Fire Total
Wednesday, August 3, 202222
Total20232024202520262027DepartmentProject #Priority
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-0201 65,00065,000Sergeant's Vehicle n/a
01-ERP-0202 65,00065,000PSO / Parking Enforcement Vehicle n/a
01-ERP-0220 90,00090,000Squad Computers n/a
01-ERP-0200 620,000120,000 120,000 120,000 130,000 130,000Marked Patrol Vehicles (7)n/a
01-ERP-0228 105,00070,000 35,000Administrative Vehicles n/a
01-ERP-0221 200,000200,000Records Management System n/a
01-ERP-0218 47,00022,000 25,000Building Video Server n/a
01-ERP-0217 230,041140,000 90,041Taser Replacement n/a
01-ERP-0215 290,000290,000Police - Portable Radios n/a
01-ERP-0214 81,16081,160Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0212 70,00070,000Squad Car Camera Systems n/a
01-ERP-0203 86,10086,100PSO - Utility 4x4 n/a
01-ERP-0227 50,00025,000 25,000Police Equipment n/a
1,999,301948,160 315,000 185,000 331,100 220,041Police Total
Public Works: Bldg/Equip Serv
01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a
01-ERP-0714 14,14314,143PW - Truck Scan Kit 1
56,24342,100 14,143Public Works: Bldg/Equip Serv Total
Public Works: Parks/Forestry
01-ERP-0807 17,14017,140Trucksters (3)n/a
01-ERP-0808 17,70017,700Riding Mowers (2)1
01-ERP-0816 80,20080,200Toolcatn/a
01-ERP-0804 163,600163,600Log Truck n/a
01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a
01-ERP-0814 10,00010,000Trailer Flatbed n/a
324,040199,000 10,000 97,900 17,140Public Works: Parks/Forestry Total
Public Works: Streets/Traffic
01-ERP-0308 536,600268,600 268,000Front End Loaders (2)n/a
01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a
01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a
01-ERP-0303 49,50049,5001 Ton Dump Truck (2)n/a
01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a
01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a
01-ERP-0322 35,00035,000Streets/Parks Supervisor Vehicle 1
843,00063,900 318,100 136,400 18,100 306,500Public Works: Streets/Traffic Total
Refuse
01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a
275,200275,200Refuse Total
Wednesday, August 3, 202223
Total20232024202520262027DepartmentProject #Priority
Sewer
01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a
01-ERP-0555 43,00043,000Generator (2)n/a
88,20043,000 45,200Sewer Total
Water
01-ERP-0510 35,00035,000Utilities Supervisor Vehicle n/a
01-ERP-0500 36,00036,0003/4 Ton Truck n/a
01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a
01-ERP-0509 134,392134,392Water Treatment Plant 1
252,29235,000 46,900 170,392Water Total
GRAND TOTAL 8,932,5801,831,745 967,154 2,063,555 1,166,061 2,904,065
Wednesday, August 3, 202224
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
FUNDING SOURCE SUMMARY
2023 thru 2027
TotalSource20232024202520262027
AC - Arts Center Fund 24,30013,500 10,800
Equipment Replacement Fund 7,996,1881,701,345 895,554 1,777,555 888,061 2,733,673
PA - Pavilion Fund 197,50011,600 185,900
PKG - Parking Fund 3,5003,500
RF - Refuse Fund 357,00081,800 275,200
SF - Sanitary Sewer Fund 112,50024,300 43,000 45,200
WF - Water Fund 241,59224,300 46,900 170,392
1,831,745 967,154 2,063,555 1,166,061 2,904,065 8,932,580GRAND TOTAL
Wednesday, August 3, 2022
25
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY FUNDING SOURCE
2023 2027thru
TotalSourceProject #Priority 2023 2024 2025 2026 2027
AC - Arts Center Fund
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a
24,30013,500 10,800AC - Arts Center Fund Total
Equipment Replacement Fund
01-ERP-0003 139,36526,250 27,037 27,849 28,684 29,545CH - 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 193,59936,465 37,559 38,686 39,847 41,042Computersn/a
01-ERP-0009 130,00060,000 70,000Network Infrastructure Upgrade - Fiber 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 233,60244,000 45,320 46,680 48,080 49,522IT - Office 365 n/a
01-ERP-0020 189,00033,000 36,000 40,000 40,000 40,000IT - Patching Automation Software 1
01-ERP-0022 238,71342,000 63,000 43,260 44,558 45,895IT - Windows 10 Enterprise Upgrade n/a
01-ERP-0024 45,00045,000IT - Sandbox Security Appliance n/a
01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a
01-ERP-0052 16,23116,231Electronic Inspections Processing 2
01-ERP-0100 1,000,0001,000,000Tele-Squirt (Engine 2)n/a
01-ERP-0101 900,000900,000Fire Pumper (Engine 3)n/a
01-ERP-0108 300,000300,000Self Contained Breathing Apparatus (SCBA) (45)n/a
01-ERP-0109 38,00038,000Extrication Tool (1)n/a
01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a
01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a
01-ERP-0114 20,30020,300Floor Scrubber n/a
01-ERP-0125 455,000455,000Fire Radios - Portable and Mobile Devices n/a
01-ERP-0127 18,00018,000Fire - Lucus Device n/a
01-ERP-0131 100,000100,000Fire - Station Alerting System n/a
01-ERP-0200 620,000120,000 120,000 120,000 130,000 130,000Marked Patrol Vehicles (7)n/a
01-ERP-0201 65,00065,000Sergeant's Vehicle n/a
01-ERP-0202 65,00065,000PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 86,10086,100PSO - Utility 4x4 n/a
01-ERP-0211 139,36626,250 27,038 27,849 28,684 29,545PD - Network Server n/a
01-ERP-0212 66,50066,500Squad Car Camera Systems n/a
01-ERP-0214 81,16081,160Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0215 290,000290,000Police - Portable Radios n/a
01-ERP-0217 230,041140,000 90,041Taser Replacement n/a
01-ERP-0218 47,00022,000 25,000Building Video Server n/a
01-ERP-0220 90,00090,000Squad Computers n/a
01-ERP-0221 200,000200,000Records Management System n/a
01-ERP-0227 50,00025,000 25,000Police Equipment n/a
01-ERP-0228 105,00070,000 35,000Administrative Vehicles n/a
Wednesday, August 3, 2022
26
TotalSourceProject #Priority 2023 2024 2025 2026 2027
01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a
01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a
01-ERP-0303 49,50049,5001 Ton Dump Truck (2)n/a
01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a
01-ERP-0308 536,600268,600 268,000Front End Loaders (2)n/a
01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a
01-ERP-0322 35,00035,000Streets/Parks Supervisor Vehicle 1
01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a
01-ERP-0714 14,14314,143PW - Truck Scan Kit 1
01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a
01-ERP-0804 81,80081,800Log Truck n/a
01-ERP-0807 17,14017,140Trucksters (3)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
7,996,1881,701,345 895,554 1,777,555 888,061 2,733,673Equipment Replacement Fund 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 3,5003,500Squad Car Camera Systems n/a
3,5003,500PKG - 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-0510 17,50017,500Utilities Supervisor Vehicle n/a
01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a
01-ERP-0555 43,00043,000Generator (2)n/a
112,50024,300 43,000 45,200SF - Sanitary Sewer Fund Total
WF - Water Fund
01-ERP-0004 6,8006,800Telephone System n/a
01-ERP-0500 36,00036,0003/4 Ton Truck n/a
01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a
01-ERP-0509 134,392134,392Water Treatment Plant 1
01-ERP-0510 17,50017,500Utilities Supervisor Vehicle n/a
Wednesday, August 3, 2022
27
TotalSourceProject #Priority 2023 2024 2025 2026 2027
241,59224,300 46,900 170,392WF - Water Fund Total
8,932,5801,831,745 967,154 2,063,555 1,166,061 2,904,065GRAND TOTAL
Wednesday, August 3, 2022
28