2017-2021 Equipment Replacement Plan (ERP)CITY OF HOPKINS
MEMORANDUM
Date: July 14, 2016
To: Mayor & City Council
From: Christine Harkess, Finance Director
Subject: 2017-2021 Equipment Replacement Plan (ERP)
Overview
Enclosed is the first draft of the 2017-2021 ERP. The demands on the ERP continue to increase
as technology advances and new demands are placed on our departments. The ERP was
originally established to provide funding for items $10,000 or greater and when the General Fund
was challenged financially several years ago some items were slipped into the ERP. This year we
removed any item under $10,000 and put those items into the respective funds operating budgets.
In addition all lease payments were also moved to the operating budgets. If an item is leased it no
longer is a capital acquisition and doesn’t fit the definition of an ERP item.
Each year the departments are asked to assess the equipment planned for replacement, evaluate
the estimated cost and life expectancy of the equipment with the intent to prolong equipment life
expectancy when practical and to refurbishing equipment instead of replacing it.
As the way we operate changes so do the demands on the ERP and as you will note from the cash
flow statements. We have a bond sale proposed for items purchased in 2016-2017 and will be
proceeding with that process. As part of the update to the Financial Management Plan we will
again be assessing this fund and making adjustments to ensure its financial stability.
Included in this packet are the following –
1. Summary of changes in the 2017-2021 ERP
2. Cash flow statements
3. Project reports summarized by year, department and funding source for the years 2017-2021
Individual equipment sheets providing a description of the equipment, justification, and funding
source are not included but can be provided if you are interested in reviewing them. Please let me
know if you’d like to review the individual equipment sheets and I will email them to you. There
are a total of 53 individual equipment sheets.
The presentation on Tuesday will be put up on the SMART board for ease of discussion. There
are a lot of components and this will ensure we are all at the same point for the discussion and
will allow staff to highlight items of interest easier.
ERP Goals
Maintain the integrity, reliability and safety of city equipment.
Provide funding for replacement of current equipment as needed.
Forecast funding needs and tax implications to assure strong long-term financial stability.
FINANCE DEPARTMENT
EQUIPMENT REPLACEMENT PLAN 2017-2021
Summary of Changes from 2016 Plan
Highlights of changes from last year’s equipment replacement plan for the years 2017-2021:
CS - Activity Center: Sound system replacement was added in 2019 at a cost of $15,000.
CS - Arts Center: Two items totaling $9,400 were removed from the ERP and put in the
operational budget.
CS - IT: Network servers for city hall and the police department originally
budgeted at $15,000 per year each were increased to $22,000 as
technology demands increase.
A backup server for city computers essential to keeping electronic data
safe for the city was added in 2017 and 2020 at a cost of $66,000 for
each year.
Community Services: No changes
Fire: Leased vehicle cost of $32,707 per year was moved to the General
Fund Fire Dept operations budget along with the cost to outfit those
vehicles.
Workout equipment totaling $24,200 over 4 years was removed from
the ERP and into the operations budget for the respective years.
Automated external defibrillators (2) totaling $7,800 in 2018 were
removed from the ERP and will be put in the operations budget for
2018.
A washer & dryer for the turnout gear totaling $13,000 in 2018 was
removed from the ERP and will be put into the operations budget for
2018.
The Tele-squirt fire truck scheduled for replacement in 2017 at a cost
of $650,000 has been increased to $900,000 to reflect the actual cost
of replacement.
HRA No changes.
Pavilion: No changes
Parking: No changes.
Police: Leased vehicles for the chief, captain and DTF were removed from the
ERP along with the cost to outfit those vehicles and moved to the
Police operations budget. Total cost eliminated was $297,370 over the
next five years.
The cost of the marked squad cars has been evaluated and the cost
updated to reflect the prices on the state contracts. Cost for the
vehicles has increased by $49,000 from 2017-2020 over the same
period in the prior year’s ERP.
The sergeant’s vehicle originally scheduled for 2019 was moved up to
2018 and the cost reduced by $1,600.
The PSO vehicle originally scheduled for 2020 was moved up to 2018
and the cost reduced by $5,400.
Tactical ballistic vests for the SWAT Team scheduled for 2018 also
now incorporates helmets and the cost was increased by $8,100.
PD squad video server scheduled for 2019 at a cost of $15,000 has
been removed and replaced with a PD video data server in 2018 to
2020. Cost in 2018 will be $115,000 and $10,000 per year thereafter.
Mobile data computers were added in 2019 at a cost of $65,000.
The records management system originally in as Data 911 in 2020 for
$50,000 has been renamed to appropriately describe the equipment
needed and the cost increased to $150,000.
Body worn cameras have been added for the years 2018 to 2021. Cost
in 2018 is $115,000 and $15,000 per year thereafter.
Public Works: Engineering
No changes
Building/Equipment Services
A high pressure vehicle washer scheduled for 2020 at a cost of $8,300
has been removed and is part of the PW garage upgrade project.
Parks/Forestry
Trucksters originally scheduled for 2019 were moved to 2017 with no
change in cost.
The cost of the stump cutter originally scheduled for 2017 has
increased from $21,200 to $45,000 to reflect replacement cost.
The cost of the trailer flatbed scheduled for 2020 has increased in cost
from $2,200 to $10,000 to reflect replacement cost.
Streets/Traffic
Tandem dump trucks scheduled for replacement in 2017 and 2018
have increased in cost from $173,200 and $180,000 to $225,000 and
$235,000 a total impact of $106,800 over the two years. Cost
increased to better reflect replacement cost.
The asphalt paver originally in for 2018 at a cost of $48,800 has been
moved to 2017 at a cost of $118,000.
A snow blower has been added for 2017 at a cost of $160,000. This
item was originally scheduled for 2014, did not get purchased and did
not get put back in the ERP.
A asphalt hot mix heating box and trailer has been added in 2017 at a
cost of $15,000. Current box sits on the back of a truck is too small
and sits too high to be handled easily. Plans are to move to a hot box
on a trailer to provide greater efficiency and safety to employees.
Refuse
No changes
Sewer
A generator originally scheduled for 2017 at a cost of $26,400 has
increased in cost to $36,000.
A Jet Vactor has been moved from 2020 to 2017 and the cost
increased by $110,000 to reflect replacement cost.
SCADA upgrade has been added in 2017 at a cost to the sewer fund of
$160,000. Our current SCADA system is outdated and an upgrade is
needed for the system to continue to work with the PLC software and
radio parts.
Water
¾ ton Utility truck originally scheduled for 2016 was moved back to
2017. Current vehicle is a 2006 Chev Pick-up.
Water treatment plant equipment used to convert chlorine gas to liquid
sodium hypochlorite has been added at cost of $100,000. Chlorine gas
is extremely dangerous and corrosive. Liquid bleach is easy to contain
and work with.
EQ
U
I
P
M
E
N
T
R
E
P
L
A
C
E
ME
N
T
F
U
N
D
(
6
0
2
)
7/
1
1
/
2
0
1
6
Ra
t
e
C
h
a
n
g e
9%
9
%
9
%
9
%
9
%
6
%
6
%
BU
D
G
E
T
B
U
D
G
E
T
B
U
D
G
E
T
B
U
D
G
E
T
B
U
D
G
E
T
B
U
D
G
E
T
B
U
D
G
E
T
20
1
5
2
0
1
6
2
0
1
7
2
0
1
8
2
0
1
9
2
0
2
0
2
0
2
1
Wo
r
k
i
n
g
C
a
p
i
t
a
l
B
e
g
i
n
Y
e
a
r
53
8
,
5
1
4
(
3
7
3
,
5
0
4
)
9
4
0
,
7
2
3
(
5
7
1
,
0
1
7
)
(
4
2
3
,
4
0
2
)
(
1
6
6
,
2
6
7
)
4
1
,
0
6
0
Re
v
e
n
u
e
s
f
r
o
m
c
h
a
r
g es
3
7
6
,
8
8
4
4
0
8
,
4
5
9
4
4
5
,
2
2
0
4
8
5
,
2
9
0
5
2
8
,
9
6
6
5
6
0
,
7
0
4
5
9
4
,
3
4
6
Ta
x
L
e
v
y
p
e
r
F
M
P
36
0
,
7
0
8
4
3
7
,
5
4
9
4
9
3
,
2
4
0
3
2
6
,
7
1
3
Tr
a
n
s
f
e
r
i
n
G
e
n
e
r
a
l
F
u
n
d
Tr
a
n
s
f
e
r
I
n
-
P
a
v
i
l
i
o
n
-
H
o
c
k
e
y
L
o
a
n
Fe
d
e
r
a
l
&
S
t
a
t
e
G
r
a
n
t
s
2
3
7
,
1
2
0
Fi
r
e
T
r
u
c
k
L
e
a
s
e
In
t
e
r
e
s
t
e
a
r
n
i
n
g
s
5
,
9
8
2
3
,
0
0
0
3
,
0
0
0
3
,
0
0
0
3
,
0
0
0
3
,
0
0
0
3
,
0
0
0
N et
I
n
c
r
(
D
e
c
r
)
i
n
F
V
o
f
I
n
v
e
s
t
m
e
n
t
s
Ot
h
e
r
r
e
v
e
n
u
e
s
(
s
a
l
e
o
f
a
s
s
e
t
s
)
2
7
,
5
3
5
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
5
,
0
0
0
3
5
,
0
0
0
3
5
,
0
0
0
Eq
u
i
p
m
e
n
t
C
e
r
t
i
f
i
c
a
t
e
s
(
B
o
n
d
s
)
1
,
8
0
0
,
0
0
0
5
7
5
,
0
0
0
Tr
a
n
s
f
e
r
s
I
n
(
M
i
s
c
)
To
t
a
l
R
e
v
e
n
u
e
s
6
4
7
,
5
2
1
2
,
2
4
1
,
4
5
9
4
7
8
,
2
2
0
1
,
4
5
3
,
9
9
8
1
,
0
0
4
,
5
1
5
1
,
0
9
1
,
9
4
4
9
5
9
,
0
5
9
Ex
p
e
n
d
i
t
u
r
e
s
(
e
x
c
l
u
d
e
s
L
e
a
s
e
s
&
D
e
p
r
.
)
7
2
,
1
5
0
7
4
,
3
1
5
7
6
,
5
4
4
7
8
,
8
4
1
8
1
,
2
0
6
8
3
,
6
4
2
8
6
,
1
5
1
Fi
r
e
T
r
u
c
k
F
i
n
a
n
c
i
n
g
P
y
m
n
t
s
(
2
0
0
9
-
2
0
1
8
)
5
3
,
8
0
3
5
4
,
2
1
7
5
4
,
2
1
7
5
4
,
2
1
7
Ca
p
i
t
a
l
O
u
t
l
a
y
-
E
q
u
i
p
m
e
n
t
1
,
4
3
3
,
5
8
6
7
9
8
,
7
0
0
1
,
8
5
9
,
2
0
0
1
,
0
4
9
,
9
5
0
5
4
2
,
8
0
0
6
7
7
,
6
0
0
4
4
5
,
9
0
0
Tr
a
n
s
f
e
r
O
u
t
To
t
a
l
E
x
p
e
n
s
e
s
1
,
5
5
9
,
5
3
9
9
2
7
,
2
3
1
1
,
9
8
9
,
9
6
1
1
,
3
0
6
,
3
8
2
7
4
7
,
3
8
1
8
8
4
,
6
1
7
6
5
5
,
4
2
6
Wo
r
k
i
n
g
C
a
p
i
t
a
l
E
n
d
i
n
g
B
a
l
a
n
c
e
(
3
7
3
,
5
0
4
)
9
4
0
,
7
2
3
(
5
7
1
,
0
1
7
)
(
4
2
3
,
4
0
2
)
(
1
6
6
,
2
6
7
)
4
1
,
0
6
0
3
4
4
,
6
9
3
(c
a
s
h
+
r
e
c
e
i
v
a
b
l
e
s
-
p
a
y
a
b
l
e
s
)
1,
1
6
4
,
6
7
5
20
1
6
E
R
P
I
t
e
m
s
L
e
s
s
i
t
e
m
s
p
u
r
c
h
a
s
e
d
i
n
2
0
1
5
(1
0
,
0
0
0
)
D
o
c
u
m
e
n
t
M
a
n
a
g
e
m
e
n
t
-
o
u
t
o
f
E
R
P
(2
9
4
,
0
7
5
)
F
D
M
o
b
i
l
e
&
P
o
r
t
a
b
l
e
R
a
d
i
o
'
s
(4
1
,
9
0
0
)
S
k
i
d
L
o
a
d
e
r
(2
0
,
0
0
0
)
R
i
d
i
n
g
M
o
w
e
r
79
8
,
7
0
0
To
t
a
l
It
e
m
s
l
e
s
s
t
h
a
n
$
1
0
,
0
0
0
a
n
d
l
e
a
s
e
d
v
e
h
i
c
l
e
s
5
,
0
8
0
,
7
5
5
1
,
9
5
2
,
0
1
7
1
,
1
5
5
,
6
5
7
6
3
9
,
1
8
7
7
8
0
,
1
4
7
5
5
3
,
7
4
7
mo
v
e
d
t
o
G
e
n
e
r
a
l
F
u
n
d
Fi
r
e
L
e
a
s
e
d
V
e
h
i
c
l
e
s
(
1
3
0
,
7
3
5
)
(
2
6
,
1
4
7
)
(
2
6
,
1
4
7
)
(
2
6
,
1
4
7
)
(
2
6
,
1
4
7
)
(
2
6
,
1
4
7
)
Fi
r
e
L
e
a
s
e
d
V
e
h
i
c
l
e
s
-
o
u
t
f
i
t
t
i
n
g
(
3
0
,
0
0
0
)
(
5
,
0
0
0
)
(
1
5
,
0
0
0
)
(
1
0
,
0
0
0
)
Wo
r
k
o
u
t
E
q
u
p
m
e
n
t
-
E
l
l
i
p
t
i
ca
l
(
6
,
7
0
0
)
(6
,
7
0
0
)
Wo
r
k
o
u
t
E
q
u
p
m
e
n
t
-
T
r
e
a
d
m
i
l
l
#1
(
6
,
7
0
0
)
(
6
,
7
0
0
)
Wo
r
k
o
u
t
E
q
u
p
m
e
n
t
-
Tr
e
a
d
m
i
l
l
#2
(
5
,
8
0
0
)
(
5
,
8
0
0
)
Wo
r
k
o
u
t
E
q
u
p
m
e
n
t
-
W
e
i
g
h
t
L
i
f
t
i
n
g
(
6
,
7
0
0
)
(
6
,
7
0
0
)
Wo
r
k
o
u
t
E
q
u
p
m
e
n
t
-
D
u
m
b
B
e
l
l
s
(
5
,
0
0
0
)
(
5
,
0
0
0
)
Au
t
o
m
a
t
e
d
E
x
t
e
r
n
a
l
D
e
f
i
b
r
i
l
l
a
to
r
(
7
,
8
0
0
)
(
7
,
8
0
0
)
Fi
r
e
-
W
a
s
h
i
n
g
M
a
c
h
i
n
e
(
8
,
5
0
0
)
(
8
,
5
0
0
)
Fi
r
e
-
D
r
y
e
r
(
4
,
5
0
0
)
(
4
,
5
0
0
)
Po
l
i
c
e
-
A
d
m
i
n
V
e
h
i
c
l
e
L
e
a
s
e
d
(
1
4
6
,
1
8
0
)
(
2
5
,
9
4
0
)
(
2
7
,
8
8
0
)
(
2
9
,
3
6
0
)
(
3
1
,
0
0
0
)
(
3
2
,
0
0
0
)
Po
l
i
c
e
-
A
d
m
i
n
V
e
h
i
c
l
e
L
e
a
s
e
d
-
O
u
t
f
i
t
(
2
5
,
0
0
0
)
(
5
,
0
0
0
)
(
5
,
0
0
0
)
(
5
,
0
0
0
)
(
5
,
0
0
0
)
(
5
,
0
0
0
)
Po
l
i
c
e
-
D
T
F
V
e
h
i
c
l
e
-
L
e
a
s
e
d
(
6
7
,
6
9
0
)
(
1
1
,
9
3
0
)
(
1
3
,
3
8
0
)
(
1
3
,
3
8
0
)
(
1
4
,
5
0
0
)
(
1
4
,
5
0
0
)
Po
l
i
c
e
-
D
T
F
V
e
h
i
c
l
e
-
L
e
a
s
e
d
-
o
u
t
f
i
t
(
1
0
,
0
0
0
)
(
5
,
0
0
0
)
(
5
,
0
0
0
)
Po
l
i
c
e
-
A
d
m
i
n
V
e
h
i
c
l
e
F
l
o
a
t
e
r
L
e
a
s
e
d
(
3
8
,
5
0
0
)
(
7
,
5
0
0
)
(
7
,
5
0
0
)
(
7
,
5
0
0
)
(
7
,
5
0
0
)
(
8
,
5
0
0
)
Po
l
i
c
e
-
A
d
m
i
n
V
e
h
i
c
l
e
F
l
o
a
t
e
r
L
e
a
s
e
d
-
o
u
t
f
i
t
(
1
0
,
0
0
0
)
(
5
,
0
0
0
)
(
5
,
0
0
0
)
PW
-
T
i
r
e
C
h
a
n
g
e
r
(
5
,
5
0
0
)
(
5
,
5
0
0
)
To
t
a
l
I
t
e
m
s
m
o
v
e
d
t
o
G
e
n
e
r
a
l
F
u
n
d
B
u
d
g
e
t
(
5
1
5
,
3
0
5
)
(
1
0
2
,
8
1
7
)
(
1
0
5
,
7
0
7
)
(
9
6
,
3
8
7
)
(
1
0
2
,
5
4
7
)
(
1
0
7
,
8
4
7
)
Ne
t
E
R
P
F
u
n
d
e
d
I
t
e
m
s
4
,
5
6
5
,
4
5
0
1
,
8
4
9
,
2
0
0
1
,
0
4
9
,
9
5
0
5
4
2
,
8
0
0
6
7
7
,
6
0
0
4
4
5
,
9
0
0
01
-
E
R
P
-
0
7
1
4
M
i
s
c
l
a
s
s
i
f
i
e
d
1
0
,
0
0
0
P
W
-
T
r
u
c
k
S
c
a
n
K
i
t
(
w
a
s
l
a
b
e
l
e
d
a
s
C
I
P
)
1,
8
5
9
,
2
0
0
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
PROJECTS BY YEAR
2017 2021thru
Project Name Department Project # Priority Project Cost
2017
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,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-0100Tele-Squirt (Engine 2)n/a 900,000Fire
01-ERP-0106Aerial Truck n/a 54,217Fire
01-ERP-0112Thermal Imaging Camera (2)n/a 12,900Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 98,000Police
01-ERP-0223Squad Car Wireless Solution n/a 12,000Police
01-ERP-0714PW - Truck Scan Kit 1 10,000Public Works: Bldg/Equip Serv
01-ERP-0807Trucksters (3)n/a 34,200Public Works: Parks/Forestry
01-ERP-0812Stump Cutter n/a 45,000Public Works: Parks/Forestry
01-ERP-0815Skid Loader n/a 32,000Public Works: Parks/Forestry
01-ERP-0306Tandem Dump Truck (2)n/a 225,000Public Works: Streets/Traffic
01-ERP-0312PW - Roller n/a 45,900Public Works: Streets/Traffic
01-ERP-0313Striper n/a 11,200Public Works: Streets/Traffic
01-ERP-0314PW - Asphalt Paver n/a 118,000Public Works: Streets/Traffic
01-ERP-0315Snow Blower n/a 160,000Public Works: Streets/Traffic
01-ERP-0318Asphalt Hot Mix Heating Box - Trailer n/a 15,000Public Works: Streets/Traffic
01-ERP-0901Refuse Truck (Rear-L)n/a 101,600Refuse
01-ERP-0552Jet Vactor n/a 425,000Sewer
01-ERP-0555Generator (2)n/a 36,000Sewer
01-ERP-0559SCADA Upgrade 1 160,000Sewer
01-ERP-05003/4 Ton Truck n/a 32,000Water
01-ERP-0509Water Treatment Plant 1 100,000Water
2,768,017Total for 2017
2018
01-ERP-1104Art Center Theater Projector n/a 17,100Comm 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 n/a 35,000Police
01-ERP-0217Taser Replacement n/a 29,000Police
01-ERP-0219PD - Video Data Server n/a 115,000Police
01-ERP-0222Body Worn Cameras n/a 115,000Police
01-ERP-07104X4 1/2 Ton Truck n/a 31,300Public Works: Bldg/Equip Serv
01-ERP-0816Toolcat n/a 63,300Public Works: Parks/Forestry
Wednesday, July 13, 2016
Project Name Department Project # Priority Project Cost
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,192,517Total 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-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-0218Building Video Server n/a 17,000Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0220Mobile Data Computers n/a 65,000Police
01-ERP-0222Body Worn Cameras n/a 15,000Police
01-ERP-0311Sweeper n/a 156,400Public Works: Streets/Traffic
542,800Total 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
01-ERP-0200Marked Patrol Vehicles (7)n/a 107,400Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0221Records Management System n/a 150,000Police
01-ERP-0222Body Worn Cameras n/a 15,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
01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry
677,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-0222Body Worn Cameras n/a 15,000Police
01-ERP-0305Single Axle Dump Truck (2)n/a 132,100Public Works: Streets/Traffic
01-ERP-0900Refuse Truck (RAP-R) (2)n/a 270,300Refuse
716,200Total for 2021
GRAND TOTAL 5,897,134
Wednesday, July 13, 2016
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
PROJECTS BY DEPARTMENT
2017 2021thru
Total2017 2018 2019 2020 2021Department Project# 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-1104 17,10017,100Art Center Theater Projector n/a
17,10017,100Comm Svcs - Arts Center Total
Comm Svcs - IT
01-ERP-0003 110,00022,000 22,000 22,000 22,000 22,000CH - Network Server n/a
01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computers 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 132,00066,000 66,000Backup Server n/a
01-ERP-0211 110,00022,000 22,000 22,000 22,000 22,000PD - Network Server n/a
581,000140,000 97,000 74,000 196,000 74,000Comm Svcs - IT Total
Community Services
01-ERP-0008 11,30011,300Document Management Scanner (2) n/a
11,30011,300Community Services Total
Fire
01-ERP-0100 900,000900,000Tele-Squirt (Engine 2) n/a
01-ERP-0106 108,43454,217 54,217Aerial Truck n/a
01-ERP-0109 27,40027,400Extrication Tool (2) n/a
01-ERP-0112 12,90012,900Thermal Imaging Camera (2) n/a
1,048,734967,117 54,217 27,400Fire Total
Police
01-ERP-0200 611,50098,000 147,000 98,000 107,400 161,100Marked 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 55,00055,000PSO - Utility 4x4 n/a
01-ERP-0212 65,00065,000Squad Car Camera Systems n/a
01-ERP-0214 35,00035,000Tactical Ballistic Vests / Helmets - SWAT n/a
01-ERP-0217 29,00029,000Taser Replacement n/a
01-ERP-0218 17,00017,000Building Video Server n/a
01-ERP-0219 145,000115,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,000115,000 15,000 15,000 15,000Body Worn Cameras n/a
Wednesday, July 13, 2016
Total2017 2018 2019 2020 2021Department Project# Priority
01-ERP-0223 12,00012,000Squad Car Wireless Solution n/a
1,447,200110,000 545,000 270,000 282,400 239,800Police Total
Public Works: Bldg/Equip Serv
01-ERP-0710 31,30031,3004X4 1/2 Ton Truck n/a
01-ERP-0714 10,00010,000PW - Truck Scan Kit 1
41,30010,000 31,300Public Works: Bldg/Equip Serv Total
Public Works: Parks/Forestry
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2) n/a
01-ERP-0807 34,20034,200Trucksters (3) n/a
01-ERP-0810 92,70092,700Large Turf Mower n/a
01-ERP-0812 45,00045,000Stump Cutter n/a
01-ERP-0814 10,00010,000Trailer Flatbed n/a
01-ERP-0815 32,00032,000Skid Loader n/a
01-ERP-0816 63,30063,300Toolcat n/a
362,400111,200 63,300 187,900Public Works: Parks/Forestry Total
Public Works: Streets/Traffic
01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a
01-ERP-0305 132,100132,100Single Axle Dump Truck (2) n/a
01-ERP-0306 460,000225,000 235,000Tandem Dump Truck (2) n/a
01-ERP-0311 156,400156,400Sweeper n/a
01-ERP-0312 45,90045,900PW - Roller n/a
01-ERP-0313 11,20011,200Striper n/a
01-ERP-0314 118,000118,000PW - Asphalt Paver n/a
01-ERP-0315 160,000160,000Snow Blower n/a
01-ERP-0318 15,00015,000Asphalt Hot Mix Heating Box - Trailer n/a
1,153,200575,100 289,600 156,400 132,100Public 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
01-ERP-0901 101,600101,600Refuse Truck (Rear-L) n/a
466,900101,600 95,000 270,300Refuse Total
Sewer
01-ERP-0552 425,000425,000Jet Vactor n/a
01-ERP-0555 36,00036,000Generator (2) n/a
01-ERP-0559 160,000160,000SCADA Upgrade 1
621,000621,000Sewer Total
Water
01-ERP-0500 32,00032,0003/4 Ton Truck n/a
01-ERP-0509 100,000100,000Water Treatment Plant 1
132,000132,000Water Total
GRAND TOTAL 5,897,1342,768,017 1,192,517 542,800 677,600 716,200
Wednesday, July 13, 2016
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
PROJECTS BY FUNDING SOURCE
2017 2021thru
TotalSourceProject# Priority 2017 2018 2019 2020 2021
AC - Arts Center Fund
01-ERP-1104 17,10017,100Art Center Theater Projector n/a
17,10017,100AC - Arts Center Fund Total
Bonds/Lease
01-ERP-0106 108,43454,217 54,217Aerial Truck n/a
108,43454,217 54,217Bonds/Lease Total
Equipment Replacement Fund
01-ERP-0003 110,00022,000 22,000 22,000 22,000 22,000CH - Network Server n/a
01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computers n/a
01-ERP-0008 11,30011,300Document Management Scanner (2) 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 132,00066,000 66,000Backup Server n/a
01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3
01-ERP-0100 900,000900,000Tele-Squirt (Engine 2) n/a
01-ERP-0109 27,40027,400Extrication Tool (2) n/a
01-ERP-0112 12,90012,900Thermal Imaging Camera (2) n/a
01-ERP-0200 611,50098,000 147,000 98,000 107,400 161,100Marked 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 55,00055,000PSO - Utility 4x4 n/a
01-ERP-0211 110,00022,000 22,000 22,000 22,000 22,000PD - Network Server n/a
01-ERP-0212 65,00065,000Squad Car Camera Systems n/a
01-ERP-0214 35,00035,000Tactical Ballistic Vests / Helmets - SWAT n/a
01-ERP-0217 29,00029,000Taser Replacement n/a
01-ERP-0218 17,00017,000Building Video Server n/a
01-ERP-0219 145,000115,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,000115,000 15,000 15,000 15,000Body Worn Cameras n/a
01-ERP-0223 12,00012,000Squad Car Wireless Solution n/a
01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a
01-ERP-0305 132,100132,100Single Axle Dump Truck (2) n/a
01-ERP-0306 460,000225,000 235,000Tandem Dump Truck (2) n/a
01-ERP-0311 156,400156,400Sweeper n/a
01-ERP-0312 45,90045,900PW - Roller n/a
01-ERP-0313 11,20011,200Striper n/a
01-ERP-0314 118,000118,000PW - Asphalt Paver n/a
01-ERP-0315 160,000160,000Snow Blower n/a
Wednesday, July 13, 2016
TotalSourceProject# Priority 2017 2018 2019 2020 2021
01-ERP-0318 15,00015,000Asphalt Hot Mix Heating Box - Trailer n/a
01-ERP-0710 31,30031,3004X4 1/2 Ton Truck n/a
01-ERP-0714 10,00010,000PW - Truck Scan Kit 1
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2) n/a
01-ERP-0803 23,75023,750Swap Loader n/a
01-ERP-0807 34,20034,200Trucksters (3) n/a
01-ERP-0810 92,70092,700Large Turf Mower n/a
01-ERP-0812 45,00045,000Stump Cutter n/a
01-ERP-0814 10,00010,000Trailer Flatbed n/a
01-ERP-0815 32,00032,000Skid Loader n/a
01-ERP-0816 63,30063,300Toolcat n/a
4,575,4501,859,200 1,049,950 542,800 677,600 445,900Equipment Replacement Fund Total
RF - Refuse Fund
01-ERP-0803 71,25071,250Swap Loader n/a
01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2) n/a
01-ERP-0901 101,600101,600Refuse Truck (Rear-L) n/a
443,150101,600 71,250 270,300RF - Refuse Fund Total
SF - Sanitary Sewer Fund
01-ERP-0552 425,000425,000Jet Vactor n/a
01-ERP-0555 36,00036,000Generator (2) n/a
01-ERP-0559 70,00070,000SCADA Upgrade 1
531,000531,000SF - Sanitary Sewer Fund Total
WF - Water Fund
01-ERP-0500 32,00032,0003/4 Ton Truck n/a
01-ERP-0509 100,000100,000Water Treatment Plant 1
01-ERP-0559 90,00090,000SCADA Upgrade 1
222,000222,000WF - Water Fund Total
5,897,1342,768,017 1,192,517 542,800 677,600 716,200GRAND TOTAL
Wednesday, July 13, 2016