VII.2. Adoption of the 2024-2028 Equipment Replacement Plan; Bishop
CITY OF HOPKINS
City Council Report 2023-127
To: Honorable Mayor and Council Members
Mike Mornson, City Manager
From: Nick Bishop, Finance Director
Date: November 21, 2023
Subject: 2024-2028 Equipment Replacement Plan
_____________________________________________________________________
RECOMMENDED ACTION
MOTION TO adopt the 2024-2028 Equipment Replacement Plan.
OVERVIEW
The equipment replacement plan (ERP) is a detailed summary of the next five years
projected equipment purchases. General and Special Revenue (except Arts Center)
fund equipment items are placed in the Equipment Replacement Fund Budget which
derives its revenue from services charges to benefitting funds, tax levy, equipment sales
and interest earnings. The Arts Center and Enterprise Funds equipment in the plan is
placed in the individual fund budgets, in the year in which they are to be purchased.
Approval of the motion allows staff to begin preparation for their purchases scheduled in
2024. Items that fall under the Minnesota Statutes Uniform Bidding/Contracting laws will
require further approval before their purchase. Years 2025-2028 serve as a long-range
plan and purchases are not authorized by approving the plan.
SUPPORTING INFORMATION
• Overview of Equipment Replacement Fund
• 2024-2028 Equipment Replacement Plan Summary
Finance Department
Equipment Replacement Fund
This fund accounts for the purchase of machinery and equipment. The two main
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 2024, the Equipment Replacement Fund has projected revenues of $1,158,669,
including a tax levy of $360,000. The projected expenditures are $1,475,750. The most
significant purchase proposed for 2024 is a Police Records Management System for
$500,000. The Police Department is looking for a partner agency to join and reduce
costs.
The fund is projected to decrease its net position by $317,081 and end 2024 with a net
position of $796,187
2024 2025
Beginning Fund Balance 1,113,268 796,187
Revenues & Other Financing Sources
Tax Levy 360,000 250,000
Equipment Charges 752,536 797,688
Sale of Equipment 35,000 35,000
Interest Earnings 11,133 7,962
Equipment Certificates (Bonds)- 136,400
Transfer In - -
Total Revenue & Other Financing Sources 1,158,669 1,227,050
Expenditures & Other Financing Uses
Current Expenditures 35,956 36,316
Capital Projects
Community Services - Activity Center -
Community Services - Information Technology 255,954 666,324
Community Services - Inspections - 16,231
Fire Vehicles & Equipment - 893,600
Police Vehicles & Equipment 391,640 244,140
Police Records Management System 500,000 -
Public Works: Parks/Forestry 92,000 -
Public Works: Streets/Traffic 200,200 136,400
Total Expenditures and Other Financing Sources 1,475,750 1,993,011
Increase (Decrease) in Fund Balance (317,081) (765,961)
Projected Ending Fund Balance 796,187 30,226
Equipment Replacement Fund - Projected Cash Flows
.
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
DEPARTMENT SUMMARY
2024 2028thru
Total20242025202620272028Department
Comm Svcs - Activity Center 6,7006,700
Comm Svcs - Arts Center 24,30013,500 10,800
Comm Svcs - IT 1,735,084255,954 666,324 364,588 235,549 212,669
Community Services 30,53116,231 14,300
Fire 5,774,600893,600 45,000 3,245,500 1,590,500
Pavilion 197,90024,000 173,900
Police 2,139,397891,640 244,140 301,640 336,640 365,337
Public Works: Bldg/Equip Serv 74,14360,000 14,143
Public Works: Parks/Forestry 641,809172,200 469,609
Public Works: Streets/Traffic 842,60060,000 136,400 306,500 339,700
Refuse 275,200275,200
Sewer 88,20043,000 45,200
Water 82,90082,900
1,482,794 2,269,395 1,030,728 4,138,332 2,992,115 11,913,364TOTAL
Wednesday, November 15, 2023
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY DEPARTMENT
2024 2028thru
Total20242025202620272028DepartmentProject #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-0003 143,54627,037 27,849 28,684 29,545 30,431CH - Network Server n/a
01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a
01-ERP-0006 199,40737,559 38,686 39,847 41,042 42,273Computersn/a
01-ERP-0009 70,00070,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 78,80878,808Backup Server n/a
01-ERP-0017 240,61045,320 46,680 48,080 49,522 51,008IT - Office 365 n/a
01-ERP-0020 167,25536,000 40,000 40,000 40,000 11,255IT - Patching Automation Software 1
01-ERP-0021 10,92710,927IT - Laptops for Mobile Computer Lab n/a
01-ERP-0022 243,98463,000 43,260 44,558 45,895 47,271IT - Windows 10 Enterprise Upgrade n/a
01-ERP-0024 45,00045,000IT - Sandbox Security Appliance n/a
01-ERP-0211 143,54727,038 27,849 28,684 29,545 30,431PD - Network Server n/a
1,735,084255,954 666,324 364,588 235,549 212,669Comm Svcs - IT Total
Community Services
01-ERP-0008 14,30014,300Document Management Scanner (2)n/a
01-ERP-0052 16,23116,231Electronic Inspections Processing 2
30,53116,231 14,300Community Services Total
Fire
01-ERP-0100 1,700,0001,700,000Ladder #7 n/a
01-ERP-0101 1,500,0001,500,000Fire Pumper (Engine 3)n/a
01-ERP-0106 1,572,0001,572,000Aerial Truck n/a
01-ERP-0108 400,000400,000Self Contained Breathing Apparatus (SCBA) (45)n/a
01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a
01-ERP-0113 45,00045,000Emergency Preparedness Sirens n/a
01-ERP-0114 25,50025,500Floor Scrubber n/a
01-ERP-0125 475,000475,000Fire Radios - Portable and Mobile Devices n/a
01-ERP-0127 18,50018,500Fire - Lucus Device n/a
5,774,600893,600 45,000 3,245,500 1,590,500Fire Total
Wednesday, November 15, 2023
Total20242025202620272028DepartmentProject #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-1003 14,00014,000Pavilion - Floor Scrubber n/a
01-ERP-1004 10,00010,000Pavilion - Scissor Lift 3
197,90024,000 173,900Pavilion Total
Police
01-ERP-0200 740,000140,000 145,000 150,000 150,000 155,000Marked Patrol Vehicles (7)n/a
01-ERP-0201 72,50072,500Sergeant's Vehicle n/a
01-ERP-0202 75,00075,000PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 180,00085,000 95,000PSO - Utility 4x4 n/a
01-ERP-0212 133,20026,640 26,640 26,640 26,640 26,640Squad Car Camera Systems n/a
01-ERP-0214 88,69788,697Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0217 160,000160,000Taser Replacement n/a
01-ERP-0218 25,00025,000Building Video Server n/a
01-ERP-0220 90,00090,000Squad Computers n/a
01-ERP-0221 500,000500,000Records Management System n/a
01-ERP-0227 25,00025,000Police Equipment n/a
01-ERP-0228 50,00050,000Administrative Vehicles n/a
2,139,397891,640 244,140 301,640 336,640 365,337Police Total
Public Works: Bldg/Equip Serv
01-ERP-0710 50,00050,0004X4 3/4 Ton Truck - Electric n/a
01-ERP-0714 14,14314,143PW - Truck Scan Kit 1
01-ERP-0716 10,00010,000Scissor Lift n/a
74,14360,000 14,143Public Works: Bldg/Equip Serv Total
Public Works: Parks/Forestry
01-ERP-0801 108,000108,0004x4 3/4Ton Trucks (2)n/a
01-ERP-0807 27,00027,000Trucksters (3)4
01-ERP-0808 55,00055,000Riding Mowers (2)1
01-ERP-0810 121,609121,609Large Turf Mower n/a
01-ERP-0814 10,00010,000Trailer Flatbed 5
01-ERP-0816 80,20080,200Toolcatn/a
01-ERP-0818 240,000240,000Forestry Boom/Chipper Box Truck n/a
641,809172,200 469,609Public Works: Parks/Forestry Total
Public Works: Streets/Traffic
01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a
01-ERP-0303 60,00060,0001 Ton Dump Truck (2)n/a
01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a
01-ERP-0308 268,000268,000Front End Loaders (2)n/a
01-ERP-0309 59,70059,700Skid Loader (2)n/a
01-ERP-0319 210,000210,000Regenerative Air Sweeper n/a
01-ERP-0323 30,00030,000Trailer3
01-ERP-0324 40,00040,000Riding Floor Sweeper 3
842,60060,000 136,400 306,500 339,700Public Works: Streets/Traffic Total
Refuse
01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a
Wednesday, November 15, 2023
Total20242025202620272028DepartmentProject #Priority
275,200275,200Refuse Total
Sewer
01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a
01-ERP-0555 43,00043,000Generator (2)2
88,20043,000 45,200Sewer Total
Water
01-ERP-0500 36,00036,0003/4 Ton Truck n/a
01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a
82,90082,900Water Total
GRAND TOTAL 11,913,3641,482,794 2,269,395 1,030,728 4,138,332 2,992,115
Wednesday, November 15, 2023
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
FUNDING SOURCE SUMMARY
2024 thru 2028
TotalSource20242025202620272028
AC - Arts Center Fund 24,30013,500 10,800
Equipment Replacement Fund 11,244,8641,439,794 1,956,695 717,928 4,138,332 2,992,115
PA - Pavilion Fund 197,90024,000 173,900
RF - Refuse Fund 275,200275,200
SF - Sanitary Sewer Fund 88,20043,000 45,200
WF - Water Fund 82,90082,900
1,482,794 2,269,395 1,030,728 4,138,332 2,992,115 11,913,364GRAND TOTAL
Wednesday, November 15, 2023
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY FUNDING SOURCE
2024 2028thru
TotalSourceProject #Priority 2024 2025 2026 2027 2028
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 143,54627,037 27,849 28,684 29,545 30,431CH - Network Server n/a
01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a
01-ERP-0006 199,40737,559 38,686 39,847 41,042 42,273Computersn/a
01-ERP-0008 14,30014,300Document Management Scanner (2)n/a
01-ERP-0009 70,00070,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 78,80878,808Backup Server n/a
01-ERP-0017 240,61045,320 46,680 48,080 49,522 51,008IT - Office 365 n/a
01-ERP-0020 167,25536,000 40,000 40,000 40,000 11,255IT - Patching Automation Software 1
01-ERP-0021 10,92710,927IT - Laptops for Mobile Computer Lab n/a
01-ERP-0022 243,98463,000 43,260 44,558 45,895 47,271IT - 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,700,0001,700,000Ladder #7 n/a
01-ERP-0101 1,500,0001,500,000Fire Pumper (Engine 3)n/a
01-ERP-0106 1,572,0001,572,000Aerial Truck n/a
01-ERP-0108 400,000400,000Self Contained Breathing Apparatus (SCBA) (45)n/a
01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a
01-ERP-0113 45,00045,000Emergency Preparedness Sirens n/a
01-ERP-0114 25,50025,500Floor Scrubber n/a
01-ERP-0125 475,000475,000Fire Radios - Portable and Mobile Devices n/a
01-ERP-0127 18,50018,500Fire - Lucus Device n/a
01-ERP-0200 740,000140,000 145,000 150,000 150,000 155,000Marked Patrol Vehicles (7)n/a
01-ERP-0201 72,50072,500Sergeant's Vehicle n/a
01-ERP-0202 75,00075,000PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 180,00085,000 95,000PSO - Utility 4x4 n/a
01-ERP-0211 143,54727,038 27,849 28,684 29,545 30,431PD - Network Server n/a
01-ERP-0212 133,20026,640 26,640 26,640 26,640 26,640Squad Car Camera Systems n/a
01-ERP-0214 88,69788,697Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0217 160,000160,000Taser Replacement n/a
01-ERP-0218 25,00025,000Building Video Server n/a
01-ERP-0220 90,00090,000Squad Computers n/a
01-ERP-0221 500,000500,000Records Management System n/a
01-ERP-0227 25,00025,000Police Equipment n/a
01-ERP-0228 50,00050,000Administrative Vehicles n/a
01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a
Wednesday, November 15, 2023
TotalSourceProject #Priority 2024 2025 2026 2027 2028
01-ERP-0303 60,00060,0001 Ton Dump Truck (2)n/a
01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a
01-ERP-0308 268,000268,000Front End Loaders (2)n/a
01-ERP-0309 59,70059,700Skid Loader (2)n/a
01-ERP-0319 210,000210,000Regenerative Air Sweeper n/a
01-ERP-0323 30,00030,000Trailer3
01-ERP-0324 40,00040,000Riding Floor Sweeper 3
01-ERP-0710 50,00050,0004X4 3/4 Ton Truck - Electric n/a
01-ERP-0714 14,14314,143PW - Truck Scan Kit 1
01-ERP-0716 10,00010,000Scissor Lift n/a
01-ERP-0801 108,000108,0004x4 3/4Ton Trucks (2)n/a
01-ERP-0807 27,00027,000Trucksters (3)4
01-ERP-0808 55,00055,000Riding Mowers (2)1
01-ERP-0810 121,609121,609Large Turf Mower n/a
01-ERP-0814 10,00010,000Trailer Flatbed 5
01-ERP-0816 80,20080,200Toolcatn/a
01-ERP-0818 240,000240,000Forestry Boom/Chipper Box Truck n/a
11,244,8641,439,794 1,956,695 717,928 4,138,332 2,992,115Equipment 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-1003 14,00014,000Pavilion - Floor Scrubber n/a
01-ERP-1004 10,00010,000Pavilion - Scissor Lift 3
197,90024,000 173,900PA - Pavilion Fund Total
RF - Refuse Fund
01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a
275,200275,200RF - Refuse Fund Total
SF - Sanitary Sewer Fund
01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a
01-ERP-0555 43,00043,000Generator (2)2
88,20043,000 45,200SF - Sanitary Sewer Fund Total
WF - Water Fund
01-ERP-0500 36,00036,0003/4 Ton Truck n/a
01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a
82,90082,900WF - Water Fund Total
11,913,3641,482,794 2,269,395 1,030,728 4,138,332 2,992,115GRAND TOTAL
Wednesday, November 15, 2023