VII.3. 2018-2022 Equipment Replacement Plan; Bishop (CR2017-142)
December 5, 2017 Council Report 2017-142
2018-2022 EQUIPMENT REPLACEMENT PLAN
Proposed Action
Staff recommends adoption of the following motion: Move to adopt the 2018-2022 Equipment Replacement
Plan.
Overview
The equipment replacement plan is a detailed summary of the next five years of a twenty-year replacement
schedule, for equipment of the City of Hopkins. General and Special Revenue (except Arts Center) fund
equipment items are placed in the Equipment Replacement Fund budget which derives its revenues from
service charges to the General and Special Revenue funds, equipment sales and interest earnings. The Arts
Center and Enterprise fund equipment in the plan is placed in the individual fund budgets, in the year in
which the equipment is to be purchased.
Approval of the 2018-2021 allows staff to begin preparation for their purchase. Items that fall under the
Minnesota Statutes Uniform Bidding/Contracting Laws will require further approval by the council before
their purchase.
Staff is recommending adoption of the plan.
Primary Issues to Consider
• What changes have occurred in the equipment replacement plan since last year?
Supporting Information
• 2018-2022 ERP Power Point slides
• 2018-2022 Equipment Replacement Plan
______________________________________
Nick Bishop, CPA
Finance Director
Financial Impact: $ as provided in plan Budgeted: Y/N X N Source: Various
Related Documents (CIP, ERP, etc.): __ERP_________ Notes: ____________________
11/30/2017
1
2018 – 2022 Equipment
Replacement Plan
December 5th, 2017
Overview
5 year plan, updated annually
Approval authorizes purchases in 2018
Remaining four years are estimated
replacement for information and planning
Would be authorized in subsequent years
11/30/2017
2
Funding Sources
User Department Charges
Increasing by 10% in 2018
Total charges of $489,742 primarily in General
Fund
Equipment Certificates
Issued $1.9 million in 2016
Will issue $590K in 2018
Uses of Funds in 2018
Police ‐ $456K
Includes: patrol vehicles, sergeant vehicle, tactical and
computer equipment
Public Work Department, $509K
Includes: forklift, dump trucks and utility work machine
Information Technology, $97K
Includes: computers, servers and network equipment
11/30/2017
3
Working Capital Projection
Projected balance of $44,156 at end of 2018
Projected balance of $66,520 at end of 2022
Includes a new tax levy in 2019‐2022
City of HopkinsEquipment Replacement Fund (602)Rate Change9% 9% 10% 9% 9% 9% 6%ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET2016 2017 2018 2019 2020 2021 2022Working Capital Begin Year(373,504) 1,172,861 271,121 60,156 81,370 69,991 222,271 Revenues from charges 408,459 445,220 489,742 533,819 581,863 634,231 672,284 Tax Levy250,000 250,000 250,000 250,000 Transfer in Debt Service Fund1,896,571 - - - - - - Interest earnings 6,294 3,000 3,000 3,000 3,000 3,000 3,000 Other revenues (sale of assets) 60,424 30,000 30,000 35,000 35,000 35,000 35,000 Enterpirse contribution to software upgrade 57,508 - - - - - - Equipment Certificates (Bonds) - - 590,000 - - - - Interfund Loan - 610,000 - - - - - Total Revenues 2,429,256 1,088,220 1,112,742 821,819 869,863 922,231 960,284 Expenditures (excludes Leases & Depr.) 268,755 76,544 78,840 81,206 83,642 86,151 88,735 Fire Truck Financing Pymnts (2009-2018) 53,782 54,217 54,217 - - - - Capital Outlay - Equipment 560,354 1,859,200 990,650 594,400 672,600 523,800 1,014,600 Repayment of Interfund Loan - - 200,000 125,000 125,000 160,000 - Total Expenses 882,891 1,989,961 1,323,707 800,606 881,242 769,951 1,103,335 Working Capital Ending Balance 1,172,861 271,121 60,156 81,370 69,991 222,271 79,220 (Unrestricted Net Position)
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY YEAR
2018 2022thru
Project Name Department Project #Priority Project Cost
2018
01-ERP-1112Art Center Surveillance System 1 47,000Comm Svcs - Arts Center
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0012Core Network Switch n/a 17,000Comm Svcs - IT
01-ERP-0013Wi-Fi and Cellular n/a 6,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0106Aerial Truck n/a 54,217Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 147,000Police
01-ERP-0201Sergeant's Vehicle n/a 49,000Police
01-ERP-0203PSO - Utility 4x4 n/a 55,000Police
01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 55,000Police
01-ERP-0217Taser Replacement n/a 35,000Police
01-ERP-0219PD - Video Data Server n/a 115,000Police
01-ERP-07104X4 3/4 Ton Truck n/a 36,000Public Works: Bldg/Equip Serv
01-ERP-0715PW - Forklift 2 25,000Public Works: Bldg/Equip Serv
01-ERP-0816Toolcat n/a 63,300Public Works: Parks/Forestry
01-ERP-03024x2 1 Ton Dump Truck n/a 54,600Public Works: Streets/Traffic
01-ERP-0306Tandem Dump Truck (2)n/a 235,000Public Works: Streets/Traffic
01-ERP-0803Swap Loader n/a 95,000Refuse
1,163,117Total for 2018
2019
01-ERP-0036Activity Center Sound System Replacement 3 15,000Comm Svcs - Activity Center
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0016Fortimail Hardware Appliance n/a 10,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0109Extrication Tool (2)n/a 27,400Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 98,000Police
01-ERP-0212Squad Car Camera Systems n/a 65,000Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0220Mobile Data Computers n/a 65,000Police
01-ERP-0311Sweeper n/a 230,000Public Works: Streets/Traffic
594,400Total for 2019
2020
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0013Wi-Fi and Cellular n/a 6,000Comm Svcs - IT
01-ERP-0014Distribution Network Switches n/a 50,000Comm Svcs - IT
01-ERP-0015Backup Server n/a 66,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0008Document Management Scanner (2)n/a 11,300Community Services
Thursday, November 30, 2017
Project Name Department Project #Priority Project Cost
01-ERP-0200Marked Patrol Vehicles (7)n/a 107,400Police
01-ERP-0218Building Video Server n/a 20,000Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0221Records Management System n/a 150,000Police
01-ERP-08014x4 3/4Ton Trucks (2)n/a 85,200Public Works: Parks/Forestry
01-ERP-0810Large Turf Mower n/a 92,700Public Works: Parks/Forestry
672,600Total for 2020
2021
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0200Marked Patrol Vehicles (7)n/a 161,100Police
01-ERP-0202PSO / Parking Enforcement Vehicle n/a 53,700Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0305Single Axle Dump Truck (2)n/a 225,000Public Works: Streets/Traffic
01-ERP-0900Refuse Truck (RAP-R) (2)n/a 270,300Refuse
794,100Total for 2021
2022
01-ERP-1101Art Center Carpet Extractor n/a 5,200Comm Svcs - Arts 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 30,000Comm Svcs - IT
01-ERP-0009Network Infrastructure Upgrade n/a 23,400Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 25,000Comm Svcs - IT
01-ERP-0105Quick Attack Pumper/Rescue (Rescue 8)n/a 314,500Fire
01-ERP-0109Extrication Tool (2)n/a 30,000Fire
01-ERP-0401HRA Copier n/a 16,500HRA
01-ERP-0200Marked Patrol Vehicles (7)n/a 107,400Police
01-ERP-0203PSO - Utility 4x4 n/a 72,100Police
01-ERP-0217Taser Replacement n/a 32,000Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0222Body Worn Cameras n/a 160,000Police
01-ERP-0804Log Truck n/a 163,600Public Works: Parks/Forestry
01-ERP-03031 Ton Dump Truck (2)n/a 53,400Public Works: Streets/Traffic
01-ERP-0309Skid Loader (2)n/a 50,000Public Works: Streets/Traffic
01-ERP-0555Generator (2)n/a 43,000Sewer
1,174,600Total for 2022
GRAND TOTAL 4,398,817
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
DEPARTMENT SUMMARY
2018 2022thru
Total20182019202020212022Department
Comm Svcs - Activity Center 15,00015,000
Comm Svcs - Arts Center 65,70047,000 18,700
Comm Svcs - IT 554,40097,000 84,000 196,000 74,000 103,400
Community Services 11,30011,300
Fire 426,11754,217 27,400 344,500
HRA 16,50016,500
Police 1,587,700456,000 238,000 287,400 224,800 381,500
Public Works: Bldg/Equip Serv 61,00061,000
Public Works: Parks/Forestry 404,80063,300 177,900 163,600
Public Works: Streets/Traffic 848,000289,600 230,000 225,000 103,400
Refuse 365,30095,000 270,300
Sewer 43,00043,000
1,163,117 594,400 672,600 794,100 1,174,600 4,398,817TOTAL
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY DEPARTMENT
2018 2022thru
Total20182019202020212022DepartmentProject #Priority
Comm Svcs - Activity Center
01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3
15,00015,000Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
01-ERP-1101 5,2005,200Art Center Carpet Extractor n/a
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1112 47,00047,000Art Center Surveillance System 1
65,70047,000 18,700Comm Svcs - Arts Center Total
Comm Svcs - IT
01-ERP-0003 113,00022,000 22,000 22,000 22,000 25,000CH - Network Server n/a
01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computersn/a
01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a
01-ERP-0012 17,00017,000Core Network Switch n/a
01-ERP-0013 12,0006,000 6,000Wi-Fi and Cellular n/a
01-ERP-0014 50,00050,000Distribution Network Switches n/a
01-ERP-0015 66,00066,000Backup Server n/a
01-ERP-0016 10,00010,000Fortimail Hardware Appliance n/a
01-ERP-0211 113,00022,000 22,000 22,000 22,000 25,000PD - Network Server n/a
554,40097,000 84,000 196,000 74,000 103,400Comm Svcs - IT Total
Community Services
01-ERP-0008 11,30011,300Document Management Scanner (2)n/a
11,30011,300Community Services Total
Fire
01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a
01-ERP-0106 54,21754,217Aerial Truck n/a
01-ERP-0109 57,40027,400 30,000Extrication Tool (2)n/a
426,11754,217 27,400 344,500Fire Total
HRA
01-ERP-0401 16,50016,500HRA Copier n/a
16,50016,500HRA Total
Police
01-ERP-0200 620,900147,000 98,000 107,400 161,100 107,400Marked Patrol Vehicles (7)n/a
01-ERP-0201 49,00049,000Sergeant's Vehicle n/a
01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 127,10055,000 72,100PSO - Utility 4x4 n/a
Thursday, November 30, 2017
Total20182019202020212022DepartmentProject #Priority
01-ERP-0212 65,00065,000Squad Car Camera Systems n/a
01-ERP-0214 55,00055,000Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0217 67,00035,000 32,000Taser Replacement n/a
01-ERP-0218 20,00020,000Building Video Server n/a
01-ERP-0219 155,000115,000 10,000 10,000 10,000 10,000PD - Video Data Server n/a
01-ERP-0220 65,00065,000Mobile Data Computers n/a
01-ERP-0221 150,000150,000Records Management System n/a
01-ERP-0222 160,000160,000Body Worn Cameras n/a
1,587,700456,000 238,000 287,400 224,800 381,500Police Total
Public Works: Bldg/Equip Serv
01-ERP-0710 36,00036,0004X4 3/4 Ton Truck n/a
01-ERP-0715 25,00025,000PW - Forklift 2
61,00061,000Public Works: Bldg/Equip Serv Total
Public Works: Parks/Forestry
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a
01-ERP-0804 163,600163,600Log Truck n/a
01-ERP-0810 92,70092,700Large Turf Mower n/a
01-ERP-0816 63,30063,300Toolcatn/a
404,80063,300 177,900 163,600Public Works: Parks/Forestry Total
Public Works: Streets/Traffic
01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a
01-ERP-0303 53,40053,4001 Ton Dump Truck (2)n/a
01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a
01-ERP-0306 235,000235,000Tandem Dump Truck (2)n/a
01-ERP-0309 50,00050,000Skid Loader (2)n/a
01-ERP-0311 230,000230,000Sweepern/a
848,000289,600 230,000 225,000 103,400Public Works: Streets/Traffic Total
Refuse
01-ERP-0803 95,00095,000Swap Loader n/a
01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a
365,30095,000 270,300Refuse Total
Sewer
01-ERP-0555 43,00043,000Generator (2)n/a
43,00043,000Sewer Total
GRAND TOTAL 4,398,8171,163,117 594,400 672,600 794,100 1,174,600
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
FUNDING SOURCE SUMMARY
2018 thru 2022
TotalSource20182019202020212022
AC - Arts Center Fund 65,70047,000 18,700
Bonds/Lease 54,21754,217
Equipment Replacement Fund 3,796,050990,650 594,400 672,600 523,800 1,014,600
HRA - Housing and Redevelopment Authority 16,50016,500
RF - Refuse Fund 423,35071,250 270,300 81,800
SF - Sanitary Sewer Fund 43,00043,000
1,163,117 594,400 672,600 794,100 1,174,600 4,398,817GRAND TOTAL
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY FUNDING SOURCE
2018 2022thru
TotalSourceProject #Priority 2018 2019 2020 2021 2022
AC - Arts Center Fund
01-ERP-1101 5,2005,200Art Center Carpet Extractor n/a
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1112 47,00047,000Art Center Surveillance System 1
65,70047,000 18,700AC - Arts Center Fund Total
Bonds/Lease
01-ERP-0106 54,21754,217Aerial Truck n/a
54,21754,217Bonds/Lease Total
Equipment Replacement Fund
01-ERP-0003 113,00022,000 22,000 22,000 22,000 25,000CH - Network Server n/a
01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computersn/a
01-ERP-0008 11,30011,300Document Management Scanner (2)n/a
01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a
01-ERP-0012 17,00017,000Core Network Switch n/a
01-ERP-0013 12,0006,000 6,000Wi-Fi and Cellular n/a
01-ERP-0014 50,00050,000Distribution Network Switches n/a
01-ERP-0015 66,00066,000Backup Server n/a
01-ERP-0016 10,00010,000Fortimail Hardware Appliance n/a
01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3
01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a
01-ERP-0109 57,40027,400 30,000Extrication Tool (2)n/a
01-ERP-0200 620,900147,000 98,000 107,400 161,100 107,400Marked Patrol Vehicles (7)n/a
01-ERP-0201 49,00049,000Sergeant's Vehicle n/a
01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 127,10055,000 72,100PSO - Utility 4x4 n/a
01-ERP-0211 113,00022,000 22,000 22,000 22,000 25,000PD - Network Server n/a
01-ERP-0212 65,00065,000Squad Car Camera Systems n/a
01-ERP-0214 55,00055,000Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0217 67,00035,000 32,000Taser Replacement n/a
01-ERP-0218 20,00020,000Building Video Server n/a
01-ERP-0219 155,000115,000 10,000 10,000 10,000 10,000PD - Video Data Server n/a
01-ERP-0220 65,00065,000Mobile Data Computers n/a
01-ERP-0221 150,000150,000Records Management System n/a
01-ERP-0222 160,000160,000Body Worn Cameras n/a
01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a
01-ERP-0303 53,40053,4001 Ton Dump Truck (2)n/a
01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a
01-ERP-0306 235,000235,000Tandem Dump Truck (2)n/a
01-ERP-0309 50,00050,000Skid Loader (2)n/a
01-ERP-0311 230,000230,000Sweepern/a
Thursday, November 30, 2017
TotalSourceProject #Priority 2018 2019 2020 2021 2022
01-ERP-0710 36,00036,0004X4 3/4 Ton Truck n/a
01-ERP-0715 25,00025,000PW - Forklift 2
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a
01-ERP-0803 23,75023,750Swap Loader n/a
01-ERP-0804 81,80081,800Log Truck n/a
01-ERP-0810 92,70092,700Large Turf Mower n/a
01-ERP-0816 63,30063,300Toolcatn/a
3,796,050990,650 594,400 672,600 523,800 1,014,600Equipment Replacement Fund Total
HRA - Housing and Redevelopment A
01-ERP-0401 16,50016,500HRA Copier n/a
16,50016,500HRA - Housing and Redevelopment
Authority Total
RF - Refuse Fund
01-ERP-0803 71,25071,250Swap Loader n/a
01-ERP-0804 81,80081,800Log Truck n/a
01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a
423,35071,250 270,300 81,800RF - Refuse Fund Total
SF - Sanitary Sewer Fund
01-ERP-0555 43,00043,000Generator (2)n/a
43,00043,000SF - Sanitary Sewer Fund Total
4,398,8171,163,117 594,400 672,600 794,100 1,174,600GRAND TOTAL
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Activity Ctr Director
2018 2022thru Department Comm Svcs - Activity Center
Description
Replace and enhance the sound system in the Raspberry, Conference, Computer Nook, Harmony Hill, Lounge/Dining, and Office areas.
Project #01-ERP-0036
Priority 3 Important
Justification
The present sound system in many of these areas are the original system installed in 1980. It was primarily used as a paging system. We will
replace and enhance the sound system to allow better hearing for our participants as well as easier use of amplification devises for speakers,
presenters, and instructors in these areas.
Budget Impact/Other
Useful Life 25 yearsProject Name Activity Center Sound System Replacement Category Equipment
Type Equipment
Future
Total Project Cost:$15,000
Total20182019202020212022Expenditures
15,00015,000Equipment
15,000 15,000Total
Total20182019202020212022Funding Sources
15,00015,000Equipment Replacement Fund
15,000 15,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Arts Center Director
2018 2022thru Department Comm Svcs - Arts Center
Description
The carpet extractor is used at the Arts Center and occasionally in other city facilities. The equipment is used to clean carpets on a regular basis
between annual contractual cleanings, to remove spots and stains, and to pick up spills. Including carpet wand and long hose for ease of use, as
well as low moisture capabilities.
Project #01-ERP-1101
Priority n/a
Justification
The current equipment is over 12 years old and very corroded from the dirt, water and cleaning chemicals. With regular touch up cleaning and
removal of stains in the Arts Center carpet with this extractor, the need to pay contractual cleaners to deep clean the carpet is reduced to once or
twice annually.
Budget Impact/Other
Variance from 20 year plan - Increase cost from $3,300 to $3,900.
Estimate salvage/resale value on replace item: $
Useful Life 10 yearsProject Name Art Center Carpet Extractor Category Equipment
Type Equipment
Future
Total Project Cost:$16,100
Total20182019202020212022Expenditures
5,2005,200Equipment
5,200 5,200Total
Total20182019202020212022Funding Sources
5,2005,200AC - Arts Center Fund
5,200 5,200Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Arts Center Director
2018 2022thru Department Comm Svcs - Arts Center
Description
Install a projector in a ceiling mount. Wire speakers into the ceiling. Wire input for computer on front wall. Add two microphones. Mount
supporting hardware in rack that fits into closet.
Originally scheduled for the Community Room this project was moved to the Jaycee Studio as they found a greater need for this equipment in that
room.
Project #01-ERP-1105
Priority n/a
Justification
An increasing number of users of this room require media support. Current means of providing this include the use of an oversized A/V cart, cords
stretch across the floor and a large speaker on a stick. We can streamline the appearance and functionality by making these appropriate changes.
These changes also address safety concerns. They will help attract safety concerns. They will help attract and retain rental customers as well as
appropriately support our own activities.
Budget Impact/Other
Move this item from 2014 to 2015.
Useful Life 7 yearsProject Name Art Center Jaycee Studio Audio Visual Category Equipment
Type Equipment
Future
Total Project Cost:$41,100
Total20182019202020212022Expenditures
13,50013,500Equipment
13,500 13,500Total
Total20182019202020212022Funding Sources
13,50013,500AC - Arts Center Fund
13,500 13,500Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Arts Center Director
2018 2022thru Department Comm Svcs - Arts Center
Description
18 Interior cameras and 2 exterior cameras
1 Network video recorded with 30 days of storage
1 Network switch and power over Ethernet for cameras
Cabling, installation, and programming of the cameras
Estimated Cost $47,000
2020-2025: Annual software maintenance and potential maintenance in 2-5 years of $3,000
2027-2029: More extensive upgrades (may include replacing some components, but no full replacement) $5,000-$6,000.
Project #01-ERP-1112
Priority 1 Urgent
Justification
The current surveillance system is no longer functional. The cameras are of poor quality and when needed, make it impossible to identify anyone.
There are areas of the builiding that are not covered by camera or severly affected by street traffic. We have no security at the back of the building.
Because of the nature of events and art work in the building, it is important to have a system that can capture activities in the building to ensure
safety of guests and staff. It is also very important given the limited staff we have on duty. Staff may need to be away from the lobby in order to
clean or set up for an event.
We have not had a lot of problems, but have had minor vandalism to the building, theft of guests belonings and few circumstances of art theft.
Budget Impact/Other
Useful Life 5 yearsProject Name Art Center Surveillance System Category Buildings: Arts Center
Type Equipment
Future
Total Project Cost:$56,000
Total20182019202020212022Expenditures
47,00047,000Equipment
47,000 47,000Total
Total20182019202020212022Funding Sources
47,00047,000AC - Arts Center Fund
47,000 47,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact IT Director
2018 2022thru Department Comm Svcs - IT
Description
The network server is the hub of the network. New computers are faster and more reliable.
Project #01-ERP-0003
Priority n/a
Justification
Networking allows user to share information that is stored in a single location, the network server. This is more efficient because the information
does not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every
user is working with the same data.
Budget Impact/Other
Variance from 20 year plan - Increase from 8,000 to 15,000. Software licensing has become more expensive. We are paying half of our server
budget to required software and 8,000 isn't enough anymore.
2016 - Variance from 20 year plan - We were using a 4 year old server design for our servers that is not meeting current standards for speed of data
access. Our new hardware design costs aprroximately 7,000 more than the old standard that was insufficent.
2017 - Changes reflect anticipated need for increased storage.
Useful Life 1 yearProject Name CH - Network Server Category Equipment
Type Equipment
Future
Total Project Cost:$626,000
Total20182019202020212022Expenditures
113,00022,000 22,000 22,000 22,000 25,000Equipment
22,000 22,000 22,000 22,000 25,000 113,000Total
Total20182019202020212022Funding Sources
113,00022,000 22,000 22,000 22,000 25,000Equipment Replacement Fund
22,000 22,000 22,000 22,000 25,000 113,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Finance Director/IT
2018 2022thru Department Comm Svcs - IT
Description
Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one
fund.
Project #01-ERP-0006
Priority n/a
Justification
Tools enabling staff to perform job responsibilities efficiently and effectively.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
2017 - Increase in expenditure a result of supporting more computers than when the original allotment was put in place.
Useful Life 3-5 yearsProject Name Computers Category Equipment
Type Equipment
Future
Total Project Cost:$1,050,000
Total20182019202020212022Expenditures
150,00030,000 30,000 30,000 30,000 30,000Equipment
30,000 30,000 30,000 30,000 30,000 150,000Total
Total20182019202020212022Funding Sources
150,00030,000 30,000 30,000 30,000 30,000Equipment Replacement Fund
30,000 30,000 30,000 30,000 30,000 150,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Finance Director/IT
2018 2022thru Department Comm Svcs - IT
Description
Install new and additional network wiring and equipment.
Project #01-ERP-0009
Priority n/a
Justification
Improve capacity, coverage and reliability. Installation will coincide with office space update.
Budget Impact/Other
Variance from 20 year plan - new item to replace substandard network wiring.
Estimate salvage/resale value on replaced item: $
Useful Life 15 yearsProject Name Network Infrastructure Upgrade Category Equipment
Type Equipment
Future
Total Project Cost:$38,400
Total20182019202020212022Expenditures
23,40023,400Equipment
23,400 23,400Total
Total20182019202020212022Funding Sources
23,40023,400Equipment Replacement Fund
23,400 23,400Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Finance Director/IT
2018 2022thru Department Comm Svcs - IT
Description
Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates
fiber optic network connection to fire department.
2 - Cisco 3560E-24PD managed switch - $3,000 each
2 - Cisco X2-10GB-LR fiber optic transceiver - $1200 each
cost listed is for equipment only and does not include tax, shipping and other related costs
Project #01-ERP-0012
Priority n/a
Justification
Current two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in significant network outage
that was immediately noticed by many employees.
Budget Impact/Other
Variance from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside the budget for city hall
server network budget as the "Lisa" service is scheduled for replacement due to end of life, out of PCI compliance and obsolete.
2015 - change amount from $12,000 to $17,000 - more expensive than originally thought based on 2015 replacement.
Estimate salvage/resale value on replace item: - $-0-
Useful Life 6 yearsProject Name Core Network Switch Category Equipment
Type Equipment
Future
Total Project Cost:$71,000
Total20182019202020212022Expenditures
17,00017,000Equipment
17,000 17,000Total
Total20182019202020212022Funding Sources
17,00017,000Equipment Replacement Fund
17,000 17,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact IT Director
2018 2022thru Department Comm Svcs - IT
Description
With technology trending towards an explosion of mobile devices we need to be able to manage, secure and provide connectivity to current and
future devices
Project #01-ERP-0013
Priority n/a
Justification
We have cellular dead spots in buildings that can be fixed with inexpensive cell bosing technology. The number of mobile devices owned by the
city is increasing every year. Our current internal Wi-Fi infrastructure has been put to together with technology that was never designed for the
enterprise. As the Wi-Fi infrastructure is increasing the system isn't staying stable enough to meet demands. Just about every city building now
has a business need for Wi-Fi. Our current mobile device management infrastructure needs updating to handle the influx of city data on employee
owned devices, CJIS protected data, need for content filtering, as well as maintain the security of current devices.
Budget Impact/Other
2016 - New ERP item
Useful Life 5-7 yearsProject Name Wi-Fi and Cellular Category Equipment
Type Equipment
Future
Total Project Cost:$18,000
Total20182019202020212022Expenditures
12,0006,000 6,000Equipment
6,000 6,000 12,000Total
Total20182019202020212022Funding Sources
12,0006,000 6,000Equipment Replacement Fund
6,000 6,000 12,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact IT Director
2018 2022thru Department Comm Svcs - IT
Description
We have 25 distribution network switches in our enterprise environment along with fiber optic transceivers and direct attach sfp cables to connect
them. Distribution switches connect to the core switches and bring the data to the actual endpoints such as desktops, servers, telephones, and
copiers.
Project #01-ERP-0014
Priority n/a
Justification
Replacement of these switches with current technology is vital to the function of the network as well as the safety of the data being passed through
the switch.
Budget Impact/Other
2016 - New item in ERP
Useful Life 5 yearsProject Name Distribution Network Switches Category Equipment
Type Equipment
Future
Total Project Cost:$107,000
Total20182019202020212022Expenditures
50,00050,000Equipment
50,000 50,000Total
Total20182019202020212022Funding Sources
50,00050,000Equipment Replacement Fund
50,000 50,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact IT Director
2018 2022thru Department Comm Svcs - IT
Description
Group of Dell servers to run Dell Rapid Recovery software to backup city computers and servers, along with Windows and VMWare licsensing
required to run the servers.
Project #01-ERP-0015
Priority n/a
Justification
Backup servers are essential to keep the electronic data for the city safe. We have overgrown our current system and are not able to backup
everything that needs to be backed up in a timely manor. Additinally restores on the curent system take hours to days. If we needed to restore a
critical server from backup, we would be looking at an unacceptable amount of downtime.
Budget Impact/Other
Useful Life 3 yearsProject Name Backup Server Category Equipment
Type Equipment
Future
Total Project Cost:$132,000
Total20182019202020212022Expenditures
66,00066,000Equipment
66,000 66,000Total
Total20182019202020212022Funding Sources
66,00066,000Equipment Replacement Fund
66,000 66,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact IT Director
2018 2022thru Department Comm Svcs - IT
Description
Hardware appliance to act as another layer of security to filter out malicious links, messages and attachments. This device will also provide a future
capability for email archiving if it is required or desired by the city.
Project #01-ERP-0016
Priority n/a
Justification
The number one vector malicious actors use to penetrate enterprise networks is email. Once a user clicks on a link, runs a program, or opens an
attachment, the threat actor has already penetrated the border defenses. Cutting down on the amount of malicious emails that make their way to the
end user is a key method of keeping the network safe from threats such as ransomware and other dangerous cyber attacks.
Budget Impact/Other
Useful Life 5 yearsProject Name Fortimail Hardware Appliance Category Equipment
Type Equipment
Future
Total Project Cost:$10,000
Total20182019202020212022Expenditures
10,00010,000Equipment
10,000 10,000Total
Total20182019202020212022Funding Sources
10,00010,000Equipment Replacement Fund
10,000 10,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact IT Director
2018 2022thru Department Comm Svcs - IT
Description
Computer servers store information and system programs for Police Department.
One server @ $22,000 for system upgrades
Project #01-ERP-0211
Priority n/a
Justification
Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used
for data storage.
Budget Impact/Other
Variance from 20 year plan - Increase from 8,500 to 15,000. Software licensing has become more expensive. We are paying half our server
budget for required software and 8,500 isn't enough anymore.
2016 Variance from 20 year plan - We were using a 4 year old server design for our servers that is not meeting current standards for speed of data
access. Our new hardware design costs aprroximately 7,000 more than the old standard that was insufficent.
Useful Life 3 yearsProject Name PD - Network Server Category Equipment
Type Equipment
Future
Total Project Cost:$631,000
Total20182019202020212022Expenditures
113,00022,000 22,000 22,000 22,000 25,000Equipment
22,000 22,000 22,000 22,000 25,000 113,000Total
Total20182019202020212022Funding Sources
113,00022,000 22,000 22,000 22,000 25,000Equipment Replacement Fund
22,000 22,000 22,000 22,000 25,000 113,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact City Clerk
2018 2022thru Department Community Services
Description
Large document (11” x17”) scanner for document management and retention as well as general administrative use.
Purchased two scanners in 2012 at a cost of $10,315 - 1 at scanner station, 1 in City Clerk's office
Current equipment: Canon DR 7550C
Project #01-ERP-0008
Priority n/a
Justification
Scanners are needed for converting paper copies to electronic data to reduce storage space.
Budget Impact/Other
Variance from 20 year plan - Two scanners purchased in 2012 and will be replaced every four years.
Estimate salvage/resale value on replaced item: $500-$1,000
Useful Life 4 yearsProject Name Document Management Scanner (2)Category Equipment
Type Equipment
Future
Total Project Cost:$87,600
Total20182019202020212022Expenditures
11,30011,300Equipment
11,300 11,300Total
Total20182019202020212022Funding Sources
11,30011,300Equipment Replacement Fund
11,300 11,300Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Fire Chief
2018 2022thru Department Fire
Description
Quick attack pumper/rescue.
Current vehicle: 1995 Rescue (#108)
Project #01-ERP-0105
Priority n/a
Justification
Would replace Rescue 8 (lite rescue) and use as a utility vehicle. This truck could be used for daytime and nighttime medicals and small fires.
This will reduce having all personnel respond to small fires. It will also let us drop one engine in 2022 but still keep ISO rating.
Budget Impact/Other
Variance from 20 year plan - Useful life change to 10 years.
Estimate salvage/resale value on replaced item $
Useful Life 10 yearsProject Name Quick Attack Pumper/Rescue (Rescue 8)Category Vehicles
Type Equipment
Future
Total Project Cost:$737,100
Total20182019202020212022Expenditures
314,500314,500Equipment
314,500 314,500Total
Total20182019202020212022Funding Sources
314,500314,500Equipment Replacement Fund
314,500 314,500Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Fire Chief
2018 2022thru Department Fire
Description
One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on
2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23.
Current vehicle: 2008 Pierce Arrow XT Aerial Ladder (#109)
Project #01-ERP-0106
Priority n/a
Justification
Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using $445,427.08 in ERP cash and
a 10-year capital lease of $425,000. At the end of the lease term payments (P&I) will total $542,170. Total costs of aerial including cash payments
equals $987,597.
Budget Impact/Other
Variance from 20 year plan - .Lease payments on financing added to the plan.
Estimate salvage/resale value on replaced item: $
Useful Life 20 yearsProject Name Aerial Truck Category Vehicles
Type Equipment
Future
Total Project Cost:$2,559,597
Total20182019202020212022Expenditures
54,21754,217Equipment
54,217 54,217Total
Total20182019202020212022Funding Sources
54,21754,217Bonds/Lease
54,217 54,217Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Fire Chief
2018 2022thru Department Fire
Description
Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram.
Project #01-ERP-0109
Priority n/a
Justification
All vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool will be added to the purchase of the
quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost.
Budget Impact/Other
Variance from 20 year plan - move back from 2015 to 2019.
Estimate salvage/resale value on replaced item: $1,000
Purchased: 2007
Useful Life 10 yearsProject Name Extrication Tool (2)Category Equipment
Type Equipment
Future
Total Project Cost:$177,200
Total20182019202020212022Expenditures
57,40027,400 30,000Equipment
27,400 30,000 57,400Total
Total20182019202020212022Funding Sources
57,40027,400 30,000Equipment Replacement Fund
27,400 30,000 57,400Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Finance Director
2018 2022thru Department HRA
Description
Color copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks.
Current equipment: Imagistics ZB35
Project #01-ERP-0401
Priority n/a
Justification
Daily use to make copies of correspondence, forms and rental documents. Periodically produce documents such as resident newsletters and
marketing. Machine will duplex, sort, collate and staple copies.
Budget Impact/Other
Variance from 20 year plan - New item.
Estimate salvage/resale value on replace item: $ - 0 -
Useful Life 8 yearsProject Name HRA Copier Category Equipment
Type Equipment
Future
Total Project Cost:$50,400
Total20182019202020212022Expenditures
16,50016,500Equipment
16,500 16,500Total
Total20182019202020212022Funding Sources
16,50016,500HRA - Housing and
Redevelopment Authority
16,500 16,500Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief
2018 2022thru Department Police
Description
Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
Fleet consists of 7 patrol vehicles - all marked
Current Vehicles: (1) 2013 Ford Utility, (1) 2014 Ford Utility, (3) 2015 Ford Utility, (2) 2016 Ford Utility
Project #01-ERP-0200
Priority n/a
Justification
Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for
routine and emergency operations. Vehicles contain secure seating for prisoner transport.
Budget Impact/Other
Variance from 20 year plan - cost modified due to new models of squads which need to be re-outfitted for all equipment.
Estimate salvage/resale value on replaced item: $4,000 each
Useful Life 3 yearsProject Name Marked Patrol Vehicles (7)Category Vehicles
Type Equipment
Future
Total Project Cost:$3,382,600
Total20182019202020212022Expenditures
620,900147,000 98,000 107,400 161,100 107,400Vehicles
147,000 98,000 107,400 161,100 107,400 620,900Total
Total20182019202020212022Funding Sources
620,900147,000 98,000 107,400 161,100 107,400Equipment Replacement Fund
147,000 98,000 107,400 161,100 107,400 620,900Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief
2018 2022thru Department Police
Description
Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
4 year rotation.
Current vehicle: 2014 Ford Utility
Project #01-ERP-0201
Priority n/a
Justification
Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for
routine and emergency operations. Vehicles contain secure seating for prisoner transport.
Budget Impact/Other
Variance from 20 year plan - cost modified due to new model of car which will require all new equipment.
Estimate salvage/resale value on replaced item: $3,500 each
Useful Life 4 yearsProject Name Sergeant's Vehicle Category Vehicles
Type Equipment
Future
Total Project Cost:$400,600
Total20182019202020212022Expenditures
49,00049,000Vehicles
49,000 49,000Total
Total20182019202020212022Funding Sources
49,00049,000Equipment Replacement Fund
49,000 49,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief
2018 2022thru Department Police
Description
Marked patrol vehicle used by PSO Evidence Tech / Parking Enforcement Officer to respond to calls for service, enforce parking laws, and
perform duties associated with evidentiary processes.
Current Vehicle: (1) 2016 Ford Utility
Project #01-ERP-0202
Priority n/a
Justification
Use by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown area.
Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for
routine and emergency operations. Vehicles contain secure seating for prisoner transport.
Budget Impact/Other
Variance from 20 year plan - vehicle was increasd to account for the outfitting and radio
Estimate salvage/resale value on replaced item: $1,500
2016 - Change in replacement schedule due to full time use of vehicle and change of position responsibilities. Next replacement scheduled for
2021 from 2026
Useful Life 5 yearsProject Name PSO / Parking Enforcement Vehicle Category Vehicles
Type Equipment
Future
Total Project Cost:$168,900
Total20182019202020212022Expenditures
53,70053,700Vehicles
53,700 53,700Total
Total20182019202020212022Funding Sources
53,70053,700Equipment Replacement Fund
53,700 53,700Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief
2018 2022thru Department Police
Description
Four wheel drive marked patrol vehicle used by PSOs to respond to calls for service, handle animal complaints, and perform other duties associated
with department operations.
Current vehicle: 2014 Ford F150 (#212)
Project #01-ERP-0203
Priority n/a
Justification
Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals, prisoners and equipment. The 4 wheel
drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme snow conditions.
Budget Impact/Other
Estimate salvage/resale value on replaced item: $5,000
2016 - Variance from 20 year plan - Change in replacement schedule due to full time use of vehicle. Changing useful life from 6 years to 4 years
Useful Life 4 yearsProject Name PSO - Utility 4x4 Category Vehicles
Type Equipment
Future
Total Project Cost:$328,300
Total20182019202020212022Expenditures
127,10055,000 72,100Vehicles
55,000 72,100 127,100Total
Total20182019202020212022Funding Sources
127,10055,000 72,100Equipment Replacement Fund
55,000 72,100 127,100Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief
2018 2022thru Department Police
Description
Squad car camera systems are used to document events inside and outside of the patrol vehicles. The cameras utilize a forward facing camera and a
prisoner transport area camaera.
Current equipment: 11 digital cameras from DATA 911.
Video is downloaded into the police department server for evidentiary purposes.
Project #01-ERP-0212
Priority n/a
Justification
Computers: Limited life of 5 years - replacement necessary.
The police vehicle cameras are a necessary component of the patrol vehicles. Evidentiary information is collected from the cameras and often used
in court. Cameras also provide a snapshot of an officers interaction with the public so we are able to maintain transparency and public trust with
our operations.
Budget Impact/Other
Variance from 20 year plan - ERP - Move back one year to 2014. All working - no problems.
Estimate salvage/resale value on replaced item: $-0-
In 2014 the Police Dept. has the opportunity to purchase a combined mobile data computer/digital camera component for a total cost of $148,000.
Originally the total of the cameras and computers together totaled $116,100 with the computers scheduled for 2014 and the cameras scheduled for
2015. The cameras are being pulled forward to 2014.
2016 - Variance from 20 year plan - Change in replacement year to accurately reflect life expectancy in relation to when the cameras were
purchased. Change in budgeted amount to reflect past and anticipated costs.
Useful Life 5 yearsProject Name Squad Car Camera Systems Category Equipment
Type Equipment
Future
Total Project Cost:$557,500
Total20182019202020212022Expenditures
65,00065,000Equipment
65,000 65,000Total
Total20182019202020212022Funding Sources
65,00065,000Equipment Replacement Fund
65,000 65,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief
2018 2022thru Department Police
Description
12 Tactical Ballistical Vests worn by members of the Hopkins Police Department SWAT (Special Weapons and Tactics) team. These vests offer a
higher level of protection for officers involved in high risk situations; this protection offers a higher level of ballistic protection compared to regular
duty vests. SWAT team members also require ballistic helmets on the same rotational cycle. Equipment breakdown: 12 vests @ $3,700 =
$44,400. 12 ballistic helmets @ $515 = $6,180. New protective shield = $3,000.
Project #01-ERP-0214
Priority 3 Important
Justification
Variance - Change in vendor equipment pricing and SWAT team staffing levels. Current price is reflective of a twelve person (fully staffed)
SWAT team with current vendor pricing.
Budget Impact/Other
2018 - 20,000 increase to reflect current staffing levels and needs.
Useful Life 5 yearsProject Name Tactical Ballistic Vests / Helmets - SWAT Category Equipment
Type Equipment
Future
Total Project Cost:$233,200
Total20182019202020212022Expenditures
55,00055,000Equipment
55,000 55,000Total
Total20182019202020212022Funding Sources
55,00055,000Equipment Replacement Fund
55,000 55,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Captain
2018 2022thru Department Police
Description
Tasers can prevent officers and the public from injuries.Taser technology continues to develop and are worn/ carried 24/7. Tasers have a useful life
expectancy of approximately 5 years.
Project #01-ERP-0217
Priority n/a
Justification
Tasers are a crtical tool for Law Enforcement for control purposes during use of force encounters.
Budget Impact/Other
12- X2 Tasers
Total overall cost each Taser in 2018 = $2870.00 (+ shipping/tax)
Useful Life 4 yearsProject Name Taser Replacement Category Equipment
Type Equipment
Future
Total Project Cost:$158,600
Total20182019202020212022Expenditures
67,00035,000 32,000Equipment
35,000 32,000 67,000Total
Total20182019202020212022Funding Sources
67,00035,000 32,000Equipment Replacement Fund
35,000 32,000 67,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief/IT
2018 2022thru Department Police
Description
Building Video Server hardware and associated software is used to store video recorded by the cameras in and around the police department
including interview rooms as well as booking. We record approximately 6 TB of video every 2-3 weeks. Large amounts of storage are required for
30 days of archival storage on the server itself.
Project #01-ERP-0218
Priority n/a
Justification
Maintenance agreement with software vendor needs to be renewed every three years. Computer hardware should be refreshed around the same
time to minimize drive failure and take advantage of new storage technology.
Budget Impact/Other
Variance from 20 year plan - Change in replacement schedule and estimated cost. Current equipment was purchased with DTF funding. Beginning
in 2020 it will be funded with ERP funds.
Estimate salvage/resale value on replaced item: $-0-
Useful Life 4 yearsProject Name Building Video Server Category Equipment
Type Equipment
Future
Total Project Cost:$88,000
Total20182019202020212022Expenditures
20,00020,000Equipment
20,000 20,000Total
Total20182019202020212022Funding Sources
20,00020,000Equipment Replacement Fund
20,000 20,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief
2018 2022thru Department Police
Description
The police department video server is used to store evidentiary video and audio data. Rules pertaining to criminal procedure, and laws regarding
data privacy and retention place requirements on the Police Department to store and manage the data for varying lengths of time.
The current data storage solution was designed for squad car video only and is near capacity. The storage solution is also not currently designed to
efficiently back up data and is potentially subject to data loss from environmental factors such as drive failure and unsuited fire suppression systems.
Project #01-ERP-0219
Priority n/a
Justification
The server is needed to maintain evidentiary squad car video and audio based upon State of Minnesota statutes and rules for varying lengths of
time. The current storage solution is near capacity and is not being backed up in a manner suitably protecting it from loss. The current storage
solution will not facilitate data storage of body worn camera video data and data retention.
A properly designed and implemented video data storage server will protect data from potential loss and corruption. Maintenance of the video data
storage server will have yearly associated costs that need to be accounted for.
Budget Impact/Other
Cost of video data storgae server: $115,000.00
Cost of yearly maintenance for video data storgae server: $10,000.00/year
Useful Life 5 yearsProject Name PD - Video Data Server Category Equipment
Type Equipment
Future
Total Project Cost:$165,000
Total20182019202020212022Expenditures
155,000115,000 10,000 10,000 10,000 10,000Equipment
115,000 10,000 10,000 10,000 10,000 155,000Total
Total20182019202020212022Funding Sources
155,000115,000 10,000 10,000 10,000 10,000Equipment Replacement Fund
115,000 10,000 10,000 10,000 10,000 155,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief/IT
2018 2022thru Department Police
Description
Mobile Data Computers are used in the squad cars to receive calls for service from dispatch, query information from criminal justice databases, and
facilitate communication between squad cars.
Current equipment: 11 - Data 911 Computers purchased in 2014
Project #01-ERP-0220
Priority n/a
Justification
Mobile Data Computers have a limited life expectancy. The computers facilitate the basic response to emergency calls for service to which police
officers respond. Vital information is forwarded to officers via the mobile data computers. Officers complete investigative reports, issue traffic
related warnings and citations, and process arrest incidents from the mobile data computers.
As technology evolves the officers must be able to access information using up to date computers that can process the large amount of data and
applications. Mobile data computers are currently used to host the squad car video camera system and have the potential to be integrated with a
possible body worn camera.
Budget Impact/Other
2016 - Variance from 20 year plan - Change in replacement year to accurately reflect life expectancy in relation to when the computers were
purchased. Change in budgeted amount to reflect past and anticipated costs.
Useful Life 5 yearsProject Name Mobile Data Computers Category Equipment
Type Equipment
Future
Total Project Cost:$290,000
Total20182019202020212022Expenditures
65,00065,000Equipment
65,000 65,000Total
Total20182019202020212022Funding Sources
65,00065,000Equipment Replacement Fund
65,000 65,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief/IT
2018 2022thru Department Police
Description
LETG - Records Management System was purchased at the end of 2012. This maintains all police records and reports. Zurcher Technologies
acquired LETG in 2016 unexpectedly. We anticipate LETG will not be supported by 2020.
Project #01-ERP-0221
Priority n/a
Justification
A new RMS system may be needed by 2020 as the current system will likely not be supported by the new company.
Budget Impact/Other
Current cost to maintain system is $26,989 anually.
Useful LifeProject Name Records Management System Category Equipment
Type Equipment
Future
Total Project Cost:$150,000
Total20182019202020212022Expenditures
150,000150,000Equipment
150,000 150,000Total
Total20182019202020212022Funding Sources
150,000150,000Equipment Replacement Fund
150,000 150,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Police Chief
2018 2022thru Department Police
Description
Body worn cameras (BWC) are cameras worn on the person of a police officer to capture the actions of individuals and the situations encountered
by police officers. The BWCs offer video data and evidence that cannot be captured by traditional squad car video systems.
The State of Minnesota recently passed legislation regarding the use of BWCs and the video data associated with their use.
The use of BWCs by police officers is an emergeing documentation tool in law enforcement, and considered directly associated with transparency
and positive community relations.
Project #01-ERP-0222
Priority n/a
Justification
There are a number of costs associated with the implementation of a BWC program. The State of Minnesota set forth specific data privacy and
retention guidelines in the legislation that must be followed. The legislation mandates the performance of duties that are not currently performed
by members of the Police Department staff and may require the hiring of additional staff to perform the mandated duties.
Initial inquiries into BWC platforms indicate the best practice will be the acquistion of one BWC per officer in contact with the public as a core
function of their job duties, which for the Police Department would result in the purchase of 30 BWCs.
BWC manufacturers require license fees per device and ongoing warranty and maintenace fees. Computer software to manage the video data has
additional associated costs, not including staff salary / compensation to perform needed duties.
Budget Impact/Other
Useful Life 5 yearsProject Name Body Worn Cameras Category Equipment
Type Equipment
Future
Total Project Cost:$160,000
Total20182019202020212022Expenditures
160,000160,000Equipment
160,000 160,000Total
Total20182019202020212022Funding Sources
160,000160,000Equipment Replacement Fund
160,000 160,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Bldg/Equip Ser
Description
Pickup used by various divisions of Public Works.
Project #01-ERP-0710
Priority n/a
Justification
Light hauling and transportation for supervisors. Maintenance garage service vehicle.
Budget Impact/Other
Variance from 20 year plan - move up from 2009 to 2008 - Fire Dept. has requested to acquire surplus pickup for its use by daytime responders.
Estimated useful life reduced from 10 to 8 years.
Estimate salvage/resale value on replaced item: $1,500
Useful Life 8 yearsProject Name 4X4 3/4 Ton Truck Category Vehicles
Type Equipment
Future
Total Project Cost:$101,400
Total20182019202020212022Expenditures
36,00036,000Vehicles
36,000 36,000Total
Total20182019202020212022Funding Sources
36,00036,000Equipment Replacement Fund
36,000 36,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact
2018 2022thru Department Public Works: Bldg/Equip Ser
Description
Used for unloading deliveries and moving palletized materials to messanine.
Project #01-ERP-0715
Priority 2 Very Important
Justification
Currentl we use a skidloader with forms. For safety reasons the forklift is the preferred method for handling pallets on/off a delivery truck and for
material in and around our facilities. The facilities that would benefit are PW, Fire and the Ice Arena.
Budget Impact/Other
New Item
Useful Life 15 yearsProject Name PW - Forklift Category Unassigned
Type Unassigned
Future
Total Project Cost:$25,000
Total20182019202020212022Expenditures
25,00025,000Equipment
25,000 25,000Total
Total20182019202020212022Funding Sources
25,00025,000Equipment Replacement Fund
25,000 25,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Parks/Forestry
Description
Trucks used by Parks Division of Public Works.
Current vehicles: 2012 Ford F350 4X4 (#801) & 2012 Ford F350 4X4 (#802)
Project #01-ERP-0801
Priority n/a
Justification
Snow plowing, hauling, transportation. Units are heavily used.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
Useful Life 8 yearsProject Name 4x4 3/4Ton Trucks (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$313,800
Total20182019202020212022Expenditures
85,20085,200Vehicles
85,200 85,200Total
Total20182019202020212022Funding Sources
85,20085,200Equipment Replacement Fund
85,200 85,200Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Parks/Forestry
Description
Truck is used for hauling brush and logs in the Forestry department.
Current vehicle: 2007 International LP4600 Log Truck (#811)
Project #01-ERP-0804
Priority n/a
Justification
Budget Impact/Other
Variance from 20 year plan - 50% Equipment Replacement/50% Refuse - increase amount to $105,000 to reflect actual cost.
Estimated useful life reduced from 20 to 15 years.
Useful Life 15 yearsProject Name Log Truck Category Vehicles
Type Equipment
Future
Total Project Cost:$268,600
Total20182019202020212022Expenditures
163,600163,600Vehicles
163,600 163,600Total
Total20182019202020212022Funding Sources
81,80081,800Equipment Replacement Fund
81,80081,800RF - Refuse Fund
163,600 163,600Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Parks/Forestry
Description
Large turf mower (11' cutting width) used by Parks Division of Public Works.
Current equipment: 2010 Toro Groundmaster (#825)
Project #01-ERP-0810
Priority n/a
Justification
Required to efficiently mow large parks.
Budget Impact/Other
Variance from 20 year plan - move from 2011 to 2010 due to poor condition of existing mower. Estimated useful life reduced from 10 to 8 years.
Estimate salvage/resale value on replaced item: $3,500
Useful Life 8 yearsProject Name Large Turf Mower Category Equipment
Type Equipment
Future
Total Project Cost:$332,300
Total20182019202020212022Expenditures
92,70092,700Equipment
92,700 92,700Total
Total20182019202020212022Funding Sources
92,70092,700Equipment Replacement Fund
92,700 92,700Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Parks/Forestry
Description
Use by Public Works for snow removal, skating rinks, sweeping, ballfield maintenance and transportation of people and materials.
Current vehicle: 2010 Bobcat (#815)
Project #01-ERP-0816
Priority n/a
Justification
New machine.
Budget Impact/Other
Variance from 20 year plan - New item which replaces one tractor.
Estimate salvage/resale value on replaced item: $
Useful Life 8 yearsProject Name Toolcat Category Equipment
Type Equipment
Future
Total Project Cost:$295,100
Total20182019202020212022Expenditures
63,30063,300Equipment
63,300 63,300Total
Total20182019202020212022Funding Sources
63,30063,300Equipment Replacement Fund
63,300 63,300Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Streets/Traffic
Description
Truck used in the Street Division of Public Works.
Current vehicle: 2006 Ford F350 Pickup (#307)
Project #01-ERP-0302
Priority n/a
Justification
Light hauling, snow removal and transportation.
Budget Impact/Other
Estimated useful life reduced from 12 to 10 years.
Estimate salvage/resale value on replaced item: $3,500
Useful Life 10 yearsProject Name 4x2 1 Ton Dump Truck Category Equipment
Type Equipment
Future
Total Project Cost:$162,900
Total20182019202020212022Expenditures
54,60054,600Equipment
54,600 54,600Total
Total20182019202020212022Funding Sources
54,60054,600Equipment Replacement Fund
54,600 54,600Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Streets/Traffic
Description
Truck is used in the Street Division of Public Works.
Current vehicles: 2000 Ford F450 (#304) & 2011 Ford F350 (#308)
Project #01-ERP-0303
Priority n/a
Justification
Vehicle used by various departments for street and park maintenance and light hauling.
Budget Impact/Other
Variance from 20 year plan - move back from 2009 to 2010.
Estimated useful life reduced from 12 to 8 years.
Estimate salvage/resale value on replaced item: $3,500
Useful Life 8 yearsProject Name 1 Ton Dump Truck (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$281,600
Total20182019202020212022Expenditures
53,40053,400Vehicles
53,400 53,400Total
Total20182019202020212022Funding Sources
53,40053,400Equipment Replacement Fund
53,400 53,400Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Streets/Traffic
Description
Single axle dump truck used by various division of Public Works.
Current vehicles: 2005 Freightliner M2 106 (#312) and 2011 Freightliner MZ-1068 (#311)
Project #01-ERP-0305
Priority n/a
Justification
Vehicle used for heavy hauling, snow plowing and sanding.
Moved single axel dump truck due in 2018 to a tandem axel dump truck in 2018. Done to increase snow hauling and other material hauling
capacity.
Budget Impact/Other
Variance from 20 year plan - Move 1 truck from single axle to tandem axel to increase hauling capacity for snow and road materials.
Estimate salvage/resale value on replaced item: $4,500 each
We will then have 2 single axel (change from 3) dump trucks and 2 (change from 1) tandem axel dump trucks.
Estimated useful life reduced from 17 to 15 years.
Useful Life 15 yearsProject Name Single Axle Dump Truck (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$643,000
Total20182019202020212022Expenditures
225,000225,000Vehicles
225,000 225,000Total
Total20182019202020212022Funding Sources
225,000225,000Equipment Replacement Fund
225,000 225,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Streets/Traffic
Description
Dump truck used in Streets Division of Public Works.
Current vehicles: 1998 Ford LT8500 Tandem (#314)
Project #01-ERP-0306
Priority n/a
Justification
Trucks used for heavy hauling, snow plowing and sanding.
To increase snow and other material hauling capacity. Moved from a single axel dump truck in 2018 to a tandem axel truck in 2018.
Budget Impact/Other
Variance from 20 year plan - Moved 1 single axel dump truck due in 2018 to a tandem axel dump truck due in 2018.
Estimate salvage/resale value on replaced item: $-0-
2016-Increased estimated replacement costs by $50,000 each year
Estimated useful life reduced from 17 to 15 years.
Useful Life 15 yearsProject Name Tandem Dump Truck (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$1,062,000
Total20182019202020212022Expenditures
235,000235,000Vehicles
235,000 235,000Total
Total20182019202020212022Funding Sources
235,000235,000Equipment Replacement Fund
235,000 235,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Streets/Traffic
Description
Loading trucks, landscape work, snow removal, material handling.
Current equipment: 2004 Bobcat S-1851R Skid Loader (#324) & 2011 Bobcat S650 Skid-Steer Loader (#325)
Project #01-ERP-0309
Priority n/a
Justification
Budget Impact/Other
Variance from 20 year plan - move back from 2010 to 2011.
Estimate salvage/resale value on replaced item: $
Useful Life 12 yearsProject Name Skid Loader (2)Category Equipment
Type Equipment
Future
Total Project Cost:$258,900
Total20182019202020212022Expenditures
50,00050,000Equipment
50,000 50,000Total
Total20182019202020212022Funding Sources
50,00050,000Equipment Replacement Fund
50,000 50,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Public Works: Streets/Traffic
Description
Street sweeper used by Streets Division for sweeping streets and parking lots.
Current equipment: 2001 Elgin Pelican SE (#327)
Project #01-ERP-0311
Priority n/a
Justification
Street sweeping, event clean-up, spring sand removal.
Budget Impact/Other
Variance from 20 year plan - Move from 2021 to 2019
Estimate salvage/resale value on replaced item: $12,000
Useful Life 15 yearsProject Name Sweeper Category Equipment
Type Equipment
Future
Total Project Cost:$345,300
Total20182019202020212022Expenditures
230,000230,000Equipment
230,000 230,000Total
Total20182019202020212022Funding Sources
230,000230,000Equipment Replacement Fund
230,000 230,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Refuse
Description
Dumpster swap loader refuse truck used to haul bulk pick-up items, refuse from parks and downtown, scrap metal and hauling waster and snow.
Utilized by Refuse for hauling dumpsters and Forestry for chipping trees.
Cost shared Refuse and Eqiupment Replacement Fund as follows:
75% Refuse
25% ER Fund (Parks/Forrestry)
Current equipment: 1993 International LP4700 (#810)
Project #01-ERP-0803
Priority n/a
Justification
Needed for waste and snow hauling.
Budget Impact/Other
Estimated useful life reduced from 20 to 15 years.
Useful Life 15 yearsProject Name Swap Loader Category Equipment
Type Equipment
Future
Total Project Cost:$346,000
Total20182019202020212022Expenditures
95,00095,000Equipment
95,000 95,000Total
Total20182019202020212022Funding Sources
23,75023,750Equipment Replacement Fund
71,25071,250RF - Refuse Fund
95,000 95,000Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Refuse
Description
Refuse truck used by Refuse Utility Division of Public Works.
Current vehicle: 2005 Peterbilt Rapid Rail (#901) & 2011 Freightliner Rapid Rail (#900)
Project #01-ERP-0900
Priority n/a
Justification
Residential waste pick up.
Budget Impact/Other
Variance from 20 year plan - increase cost to reflect actual
Estimate salvage/resale value on replaced item: $18,000
Useful Life 10 yearsProject Name Refuse Truck (RAP-R) (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$1,462,600
Total20182019202020212022Expenditures
270,300270,300Vehicles
270,300 270,300Total
Total20182019202020212022Funding Sources
270,300270,300RF - Refuse Fund
270,300 270,300Total
Thursday, November 30, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP Contact Public Works Director
2018 2022thru Department Sewer
Description
Portable generator used by Water/Sewer Divisions of Public Works.
2016 - Increase cost from 26k to 36k due to updated information
Current equipment: 1997 Kohler Generator, 2008 Caterpillar C15 (#537)
Project #01-ERP-0555
Priority n/a
Justification
Emergency back up generator for lift stations and pumps, off site power for lights and welding.
Budget Impact/Other
Estimated useful life reduced from 25 to 20 years.
Estimate salvage/resale value on replaced item: $2,500
Useful Life 20 yearsProject Name Generator (2)Category Equipment
Type Equipment
Future
Total Project Cost:$79,000
Total20182019202020212022Expenditures
43,00043,000Equipment
43,000 43,000Total
Total20182019202020212022Funding Sources
43,00043,000SF - Sanitary Sewer Fund
43,000 43,000Total
Thursday, November 30, 2017