2015-2019 Equipment Replacement Plan (ERP)CITY OF HOPKINS FINANCE DEPARTMENT
MEMORANDUM
Date: June 10, 2014
To: Mayor & City Council
From: Christine Harkess, Finance Director
Subject: 2015-2019 Equipment Replacement Plan (ERP)
Overview
The City of Hopkins is beginning the process of establishing the 2015-2019 equipment
replacement plan. Every year the city council reviews with the city manager and staff, the
equipment planned for replacement for the next five years. The goal is to ensure the city's
priorities and objectives are being met and the funding sources are reasonable and available.
Departments were once again 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. In 2012 we sold equipment certificates for a six pieces of equipment which
helped the cash flow through 2015. Items in the 2016 ERP will cause the fund to head into a
negative position, therefore equipment certificates are proposed for items purchased in 2016-
2018. As part of the update to the Financial Management Plan we will be looking at this fund and
making adjustments to ensure its financial stability.
Included in this packet are the following —
1. Summary of changes in the 2015-2019 ERP
2. Cash flow statements
3. Project reports summarized by year, department and funding source for the years 2015-2019
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 70 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.
EQUIPMENT REPLACEMENT PLAN 2015-2019
Summary of Changes from 2014 Plan
Highlights of changes from last year's equipment replacement plan for the years 2015-2019:
Activity Center: Sound system/public address system for $8,900 was added in 2015.
The sound system is used throughout the facility and the current
equipment does not work due to equipment failure.
Tables for $12,200 were added for 2015. The Activity Center would
like to add 23 tables to add depth to the type of activities they can
accommodate.
Arts Center: Video camera updates for $3,700 were added in 2015. The Arts
Center would like to replace the front entry camera with a better
resolution camera for security purposes along with adding cameras to
other areas of the facility.
A new floor scrubber for $8,000 was added in 2015. The current floor
scrubber has reached its life expectancy and no longer performs
efficiently.
City Hall: Network server budget was increased by $7,000 to $15,000 due to the
cost of replacing servers.
Community Services: Document scanners previously in at $6,000 for 2017 and 2018 are now
it at $10,000 for 2016 and are on a 4 year replacement cycle.
Fire: The fire utility vehicle pickup used by the Fire Inspector was deleted.
Plans are to lease a pick-up truck
Two fire chief duty vehicles were added in 2015 and two were added
in 2017. Plans are to lease all four duty chief vehicles. Cost to outfit
each vehicle is also budget at $5,000 per vehicle in the year of the
leases. These vehicles are used by the Chief, Asst Chief's and Duty
Officer to respond to calls during their duty week to help assess what
is happening and setting up command and establishing command and
control. The Chief's vehicles are also used for travel to meetings and
Training outside the city
The duty chief vehicle schedule in 2016 was deleted due to the lease
proposal.
The Telesquirt fire truck scheduled for 2017 has an increased cost of
$79,100 for a total of $650,000. This vehicle will replace a 25 year
vehicle that is currently being used for response. This vehicle due to
its age is in need of replacement due to both age and on-going
maintenance costs
HRA No changes.
Pavilion: Scoreboard for $12,000 was added in 2016. The scoreboard is used
for hockey, soccer and lacrosse among other activities. The current
scoreboard is original to building and was purchased in 1990.
Parking: No changes.
Police: The leases for the chiefs, captains, DTF and school resource officer
cars was adjusted to actual. The original amount budgeted was an
estimate of the lease and once they department selected a vehicle
actual costs were known. The school resource officer car was
formerly the FOCUS car.
Digital squad cameras scheduled for 2015 at a cost of $53,400 and
mobile data computers scheduled for 2014 at a cost of $62,700 have
been combined into one unit. The total cost estimated at $116,100 is
now $148,500 and are requested for 2014. Due to changes in
equipment the Police Department feels this is a better option and will
save money in the long run.
The cost for the mobile radios for the new squads has been reduced to
only account for the purchased squads. Leased squad outfitting is in a
separate line item a savings of $16,400.
The cost of the SWAT vehicle was increased by $20,000 to $50,000
due the cost of the vehicle.
Portable radios for police and fire have been moved from 2018 to
2017. Cost remains at $534,400 and staff is researching options for
financing the acquisition of the radios.
Network server budget for the police was increased by $6,500 to
$15,000 due to the cost of replacing servers.
Building video server was added in 2015 with replacement scheduled
for 2019. The 2015 cost will come from DUI funds and in the future
from the ERP.
Public Works: The lives of the equipment are annually reviewed by the public works
department and over the past 10 years they have extended the lives of
the 1 -ton trucks from 8 to 12 years and the dump trucks from 13 to 17
years. Extending the lives of major equipment comes with the risk of
increased maintenance costs. When maintenance costs become
unmanageable the equipment will be put on the schedule for earlier
replacement.
En in�g
No changes
Buildin /g_Equipment Services
No changes
Parks/Forestry
Added a grass seed applicator (overseeder) at a cost of $11,500. This
item was previously in the ERP but not purchased and did not get
rescheduled.
Streets/Traffic
A sign machine scheduled for 2015 was pushed back to 2016.
A tandem dump truck originally scheduled for 2018 was pulled
forward to 2017. Cost remains the same.
Refuse
A rear loading refuse truck scheduled for replacement in 2015 at a cost
of $101,600 has been moved back to 2016.
Water
No changes
Sewer
No changes
EQUIPMENT REPLACEMENT FUND (602) 06/06/2014
2014 Original 761,488
'd - Arts Center Catering Equip 5,000
less - election equipment (50,000)
f police cars purchased in 2013 (77, 000) patrol (2) one outfitted in 2013 and one in 2014
police cars purchased in 2013 (35, 000) PSO - outfitted in 2014 for $14,625-71 ($47,000 total budget)
digital cameras/comptuers incr 85,800 originally in at $62, 700 for 2014 and $53,400 for 2015 ($116,100 total)
690,288 (71,200) Difference
Revised
Impact on General Fund
0
24,812
30,549
33,003
36,592
39,562
Rate Change
5%
0%
8%
9%
9%
9%
9%
6%
ACTUAL
ACTUAL
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
2012
2013
2014
2015
2016
2017
2018
2019
Working Capital Begin Year
890,189
1,084,439
726,160
384,854
280,144
(107,790)
58,785
(100,012)
Revenues from charges
316,784
320,157
345,770
376,889
410,809
447,782
488,082
517,367
Tax Levy per FMP
138,563
326,713
Transfer in General Fund
50,000
50,000
50,000
50,000
Transfer In - Pavilion - Capital Lease
20,000
15,609
Transfer In - Pavilion - Hockey Loan
3,143
3,143
3,068
Interest earnings
5,909
4,843
8,068
4,655
3,608
(271)
1,394
(194)
Net Incr (Deer) in FV of Investments
-
(7,689)
Other revenues (sale of assets)
47,834
29,020
30,000
30,000
30,000
30,000
30,000
35,000
Equipment Certificates (Bonds)
346,274
451,769
1,601,700
Transfers In (Mise)
-
23,580
Total Revenues
739,944
840,432
436,906
461,544
494,417
2,129,210
658,039
878,886
Expenditures (excludes Dept.)
15,802
32,726
33,708
34,719
35,761
36,833
37,938
39,077
Fire Truck Financing Pymnts (2009-2018)
53,858
53,841
54,217
54,217
54,217
54,217
54,217
Capital Outlay - Equipment
476,034
1,043,649
690,288
477,318
792,374
1,871,585
601,307
386,856
2012 Equip Certificate Pymnts (10yr 3%)
68,495
Total Expenses
545,694
1,198,711
778,212
566,254
882,351
1,962,635
816,837
549,308
Working Capital Ending Balance
1,084,439
726,160
384,854
280,144
(107,790)
58,785
(100,012)
229,566
(cash + receivables - payables)
ActuaUEsdinated Cash balances
1,098,353
806,821
465,514
360,805
(27,129)
139,446
(199351)
310,227
2014 Original 761,488
'd - Arts Center Catering Equip 5,000
less - election equipment (50,000)
f police cars purchased in 2013 (77, 000) patrol (2) one outfitted in 2013 and one in 2014
police cars purchased in 2013 (35, 000) PSO - outfitted in 2014 for $14,625-71 ($47,000 total budget)
digital cameras/comptuers incr 85,800 originally in at $62, 700 for 2014 and $53,400 for 2015 ($116,100 total)
690,288 (71,200) Difference
2012 Equipment Certificates
Listing of Equipment to Purchase
Items from 2012-2014
Item
Life
ERP #
Year
In ERP
Estimated
Cost
Actual
Cost
Fund
Quick Attach Pumper
10
01 -ERP -0105
2012
245,000
248,528
ERP
Single Axel Dump Truck
17
01 -ERP -0305
2012
127,400
145,288
ERP
Front End Loader
15
01 -ERP -0308
2012
172,000
170,669
ERP
Backhoe
20
01 -ERP -502
2013
75,000
2017
Water
One Ton Traffic Boom Truck
17
01 -ERP -304
2012/2013
2017
90,407
ERP
Regenerative Air Sweeper
12
01 -ERP -0311
2013
185,000
143,151
ERP
Total ERP
01 -ERP -0312
2016
45,900
804,400
798,043
20
Ice Resurfacer
12
01 -ERP -1001
2014
180,000
175,000
Pavilion
Grand Total
31,300
ERP
Skid Loader
984,400
01 -ERP -0815
2017
2017 Equipment Certificates
Listing of Equipment to Purchase
Items from 2016 -2018
Item
Life '
Proposed
ERP #
Year
In ERP
Estimated
Cost
Fund
Telesquirt Engine #2
10
01 -ERP -0100
2017
650,000
ERP
SCBA - Self Contained Breathing App
10
01 -ERP -0108
2016
250,000
ERP
4x2 1 Ton Dump Truck
12
01 -ERP -0302
2018
54,600
ERP
Single Axel Dump Truck
17
01 -ERP -0305
2018
124,000
ERP
Tandem Dump Truck
17
01 -ERP -0306
2017
173,200
ERP
Water Truck
22
01 -ERP -0307
2017
150,000
ERP
Skid Loader
12
01 -ERP -0309
2016
41,900
ERP
Roller
20
01 -ERP -0312
2016
45,900
ERP
Asphalt Paver
20
01 -ERP -0314
2016
48,800
ERP
4x4 1/2 Ton Truck
10
01 -ERP -0710
2018
31,300
ERP
Skid Loader
12
01 -ERP -0815
2017
32,000
ERP
Total
1,601,700
Working Capital Beginning Year
Revenues:
Operating Revenues
Refuse Collection
Recycling Rates
Bulk Collection
Yard Waste
Recycling rebates
Miscellaneous (penalties)
Grants
Gain on sale of assets
Interest
Net Incr (Decr) in FV of Inv
Total Revenues
Expenditures:
Operation Expense
Transfer Out
Capital Outlay (per ERP)
Capital Projects per CIP
Capital Lease (PW Facility)
Total Expenditures
Change in available funds
Inventory change
Working Capital Ending Year
Rate History
1989 $15.10
1991 $17.25
1995 $11.00-14.45 refuse
$2.25 recycling fee
2002 $2.75 recycle fee
2005 $13.20, 15.90, 17.25, refuse
2008 $3.25 recycling fee
2009 $15.85, 18.55, 21.25, refuse
2009 $3.50 recycling fee
2010 $3.75 recycling fee
2011 $16.85, $19.85, $23.15 refuse
2012 $4.00 recycling fee
2013 $16.85, $20.85, $24.30 refuse
2014 $4.25 recycling fee
2015 $18.85; $21.85; $25.15 refuse
2016 $4.50 recycling fee
2017 $19.85; $22.85; $26.15 refuse
2018 $4.75 recycling fee
2019 $20.85; $23.85; $27.15 refuse
2020 $5.00 recycling fee
REFUSE FUND - WORKING CAPITAL PROJECTION
Qb Oo 2014
Actual
Projected
Projected
Projected
Projected
Projected
Projected
2013
2014
2015
2016
2017
2018
2019
621,737
773,023
928,234
921,106
983,960
1,215,178
1,438,892
X 730,947
730,947 x
780,947
780,947 x
830,947
830,947
880,947
138,161 x
146,261
146,261 x
154,361
154,361 x
162,461
162,461
12,631
12,000
12,000
12,000
12,000
12,000
12,000
11,703
10,000
10,000
10,000
10,000
10,000
10,000
8,214
30,000
30,000
30,000
30,000
30,000
30,000
12,147
10,000
10,000
10,000
10,000
10,000
10,000
24,584
18,500
18,000
17,500
17,000
16,500
16,500
0
3,821
3,865
4,641
4,606
4,920
6,076
7,194
942,208
961,573
1,011,849
1,019,414
1,069,228
1,077,984
1,129,102
766,042
781,363
789,176
804,960
813,010
829,270
837,562
204,800
101,600
25,000
18,000
25,000
25,000
25,000
25,000
25,000
25,000
25,000
791,042
806,363
1,018,976
956,560
838,010
854,270
880,562
151,166
155,210
(7,127)
62,854
231,218
223,714
248,540
120
773,023
928,234
921,106
983,960
1,215,178
1,438,892
1,687,432
2018 - PW Garage Upgrade
2019 - PW - Replace Overhead Doors
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2015 thru 2019
PROJECTS BY YEAR
Project Name Department Project # Priority Project Cost
2015 1
Activity Center Sound System/Public Address System
Activity Center
01 -ERP -0032
n/a
8,800
Activity Center Tables
Activity Center
01 -ERP -0033
n/a
12,200
Art Center Video Camera Updates
Arts Center
O1 -ERP -1103
n/a
3,700
Art Center Community Room Audio Visual
Arts Center
01 -ERP -1105
n/a
11,000
Art Center Digital Information Sign
Arts Center
O1 -ERP -1106
2
2,000
Art Center Floor Scrubber
Arts Center
O1 -ERP -1109
n/a
8,000
Network Server
City Hall Administration
01 -ERP -0003
n/a
15,000
Telephone System
City Hall Administration
O1 -ERP -0004
n/a
89,600
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
Fire/Duty Chief & Utility Leased Vehicles (5)
Fire
O1 -ERP -0103a
n/a
19,606
Outfit Duty Chief Leased Vehicles (5)
Fire
01 -ERP -0103b
n/a
10,000
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Floor Scrubber
Fire
01 -ERP -0114
n/a
14,300
Workout Equipment - Eliptical
Fire
01 -ERP -0116
n/a
5,800
Workout Equipment - Treadmill #1
Fire
01 -ERP -0117
n/a
5,800
Workout Equipment - Weight Lifting
Fire
01 -ERP -0119
n/a
5,800
44 3/4 Ton Truck
HRA
01 -ERP -0400
n/a
32,400
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
90,000
Sergeant's Vehicle
Police
01 -ERP -0201
n/a
45,000
Police Administrative Vehicles (2)
Police
O1 -ERP -0204
n/a
11,923
Police Admin Cars - outfit leased vehicles
Police
O1 -ERP -0204a
n/a
5,000
Drug Task Force Vehicle
Police
O1 -ERP -0206
n/a
6,189
School Resource Officer Car
Police
01 -ERP -0210
n/a
6,000
School Resource Ofcr Car - outfit leased vehicle
Police
01 -ERP -0210a
n/a
5,000
Network Server (3)
Police
O1 -ERP -0211
n/a
15,000
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
12,300
Building Video Server
Police
O1 -ERP -218
n/a
17,000
Riding Mowers (2)
Public Works: Parks/Forestry
O1 -ERP -0808
n/a
11,000
Grass Seed Applicator (Overseeder)
Public Works: Parks/Forestry
01 -ERP -0817
n/a
11,500
4X4 3/4 Ton Truck with Plow
Public Works: Streets/Traffic
O1 -ERP -0301
n/a
30,400
Refuse Truck (RAP -R) (2)
Refuse
01 -ERP -0900
n/a
204,800
Total for 2015 799,335
20�
Network Server
City Hall Administration
01 -ERP -0003
n/a
15,000
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
Document Management Scanner (2)
Community Services
01 -ERP -0008
n/a
10,000
Fire/Duty Chief & Utility Leased Vehicles (5)
Fire
O1 -ERP -0103a
n/a
19,606
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Air Compressor
Fire
01 -ERP -0107
n/a
34,900
Self Contained Breathing Apparatus (SCBA) (45)
Fire
01 -ERP -0108
n/a
250,000
Pavilion Arena Scoreboard
Pavilion
O1 -ERP -1002
n/a
12,000
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
90,000
Parking Enforcement Vehicle (Parking Fund)
Police
01 -ERP -0202
n/a
27,200
Friday, June 06, 2014
Project Name Department Project # Priority Project Cost
Police Administrative Vehicles (2)
Police
O1 -ERP -0204
n/a
16,794
Police Admin Cars - outfit leased vehicles
Police
01 -ERP -0204a
n/a
5,000
SWAT Vehicle
Police
01 -ERP -0205
n/a
50,000
Drug Task Force Vehicle
Police
01 -ERP -0206
n/a
11,074
Drug Task Force Vehicle - outfit leased vehicle
Police
01 -ERP -0206a
n/a
5,000
School Resource Officer Car
Police
01 -ERP -0210
n/a
6,000
Network Server (3)
Police
01 -ERP -0211
n/a
15,000
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
4,100
Riding Mowers (2)
Public Works: Parks/Forestry
0l -ERP -0808
n/a
20,000
Slope Mower
Public Works: Parks/Forestry
01 -ERP -0809
n/a
32,700
Skid Loader (2)
Public Works: Streets/Traffic
01 -ERP -0309
n/a
41,900
Roller
Public Works: Streets/Traffic
01 -ERP -0312
n/a
45,900
Asphalt Paver
Public Works: Streets/Traffic
01 -ERP -0314
n/a
48,800
Sign Machine (Traffic)
Public Works: Streets/Traffic
01 -ERP -0317
n/a
13,400
Refuse Truck (Rear -L)
Refuse
O1 -ERP -0901
n/a
101,600
3/4 Ton Utility Truck
Sewer
01 -ERP -0551
n/a
33,600
Total for 2017 2,013,902
[2018--1
Art Center Theater Projector
Total for 2016
01 -ERP -1104
n/a
993,791
2017
City Hall Administration
01 -ERP -0003
n/a
15,000
Network Server
City Hall Administration
01 -ERP -0003
n/a
15,000
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
Tele -Squirt (Engine 2)
Fire
01 -ERP -0100
n/a
650,000
Fire/Duty Chief & Utility Leased Vehicles (5)
Fire
01 -ERP -0103a
n/a
32,707
Outfit Duty Chief Leased Vehicles (5)
Fire
01 -ERP -0103b
n/a
10,000
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Thermal Imaging Camera (2)
Fire
01 -ERP -0112
n/a
12,900
Workout Equipment - Treadmill #2
Fire
O1 -ERP -0118
n/a
5,800
Workout Equipment - Dumb Bells
Fire
01 -ERP -0122
n/a
5,000
Marked Patrol Vehicles (6)
Police
O1 -ERP -0200
n/a
98,000
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
21,999
Police Admin Cars - outfit leased vehicles
Police
01 -ERP -0204a
n/a
5,000
Drug Task Force Vehicle
Police
01 -ERP -0206
n/a
11,074
School Resource Officer Car
Police
01 -ERP -0210
n/a
11,205
School Resource Ofcr Car - outfit leased vehicle
Police
01 -ERP -0210a
n/a
5,000
Network Server (3)
Police
01 -ERP -0211
n/a
15,000
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
534,400
Taser Replacement
Police
01 -ERP -0217
3
20,900
Stump Cutter
Public Works: Parks/Forestry
O1 -ERP -0812
n/a
21,200
Skid Loader
Public Works: Parks/Forestry
O1 -ERP -0815
n/a
32,000
Tandem Dump Truck
Public Works: Streets/Traffic
O1 -ERP -0306
n/a
173,200
Water Truck
Public Works: Streets/Traffic
O1 -ERP -0307
n/a
150,000
Striper
Public Works: Streets/Traffic
O1 -ERP -0313
n/a
11,200
Generator (2)
Sewer
O1 -ERP -0555
n/a
26,400
1/2 Ton Truck
Water
O1 -ERP -0500
n/a
26,800
3/4 Ton Utility Truck
Water
O1 -ERP -0501
n/a
34,900
Total for 2017 2,013,902
[2018--1
Art Center Theater Projector
Arts Center
01 -ERP -1104
n/a
17,100
Network Server
City Hall Administration
01 -ERP -0003
n/a
15,000
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
Core Network Switch
City Hall Administration
01 -ERP -0012
n/a
12,000
Fire/Duty Chief & Utility Leased Vehicles (5)
Fire
01 -ERP -0103a
n/a
32,707
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Automated External Defibrillator (2)
Fire
01 -ERP -0120
n/a
7,800
Friday, June 06, 2014
Project Name Department Project # Priority Project Cost
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
98,000
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
22,655
Police Admin Cars - outfit leased vehicles
Police
01 -ERP -0204a
n/a
5,000
Drug Task Force Vehicle
Police
01 -ERP -0206
n/a
11,740
Drug Task Force Vehicle - outfit leased vehicle
Police
01 -ERP -0206a
n/a
5,000
School Resource Officer Car
Police
01 -ERP -0210
n/a
11,205
Network Server (3)
Police
01 -ERP -0211
n/a
15,000
Tactical Ballistic Vests
Police
01 -ERP -0214
n/a
26,900
4X41/2 Ton Truck
Public Works: Bldg/Equip Sery
01 -ERP -0710
n/a
31,300
Turf Sweeper
Public Works: Parks/Forestry
01 -ERP -0811
n/a
18,000
Toolcat
Public Works: Parks/Forestry
01 -ERP -0816
n/a
63,300
4x21 Ton Dump Truck
Public Works: Streets/Traffic
01 -ERP -0302
n/a
54,600
Single Axle Dump Truck (3)
Public Works: Streets/Traffic
O1 -ERP -0305
n/a
124,000
Total for 2019 386,856
GRAND TOTAL 4,849,408
Friday, June 06, 2014
Total for 2018
655,524
20�
Activity Center Refrigerator/Freezer
Activity Center
01 -ERP -0031
n/a
1
Network Server
City Hall Administration
O1 -ERP -0003
n/a
15,000
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
Fire/Duty Chief & Utility Leased Vehicles (5)
Fire
01 -ERP -0103a
n/a
32,707
Outfit Duty Chief Leased Vehicles (5)
Fire
01 -ERP -0103b
n/a
10,000
Extrication Tool (2)
Fire
Of -ERP -0109
n/a
27,400
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
98,000
Sergeant's Vehicle
Police
01 -ERP -0201
n/a
50,600
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
23,329
Police Admin Cars - outfit leased vehicles
Police
01 -ERP -0204a
n/a
5,000
Drug Task Force Vehicle
Police
01 -ERP -0206
n/a
11,740
School Resource Officer Car
Police
01 -ERP -0210
n/a
11,879
School Resource Ofcr Car - outfit leased vehicle
Police
01 -ERP -0210a
n/a
5,000
Network Server (3)
Police
01 -ERP -0211
n/a
15,000
Building Video Server
Police
O1 -ERP -218
n/a
17,000
Trucksters (3)
Public Works: Parks/Forestry
O1 -ERP -0807
n/a
34,200
Total for 2019 386,856
GRAND TOTAL 4,849,408
Friday, June 06, 2014
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2015 thru 2019
PROJECTS BY DEPARTMENT
Department Project# Priority 2015 2016 2017 2018 2019 Total
Activity Center i
Activity Center Refrigerator/Freezer
01 -ERP -0031
n/a
1
1
Activity Center Sound System/Public Address System
01 -ERP -0032
n/a
8,800
8,800
Activity Center Tables
01 -ERP -0033
n/a
12,200
12,200
Activity Center Total
21,000
1
21,001
Arts Center
Art Center Video Camera Updates
01 -ERP -1103
n/a
3,700
3,700
Art Center Theater Projector
01 -ERP -1104
n/a
17,100
17,100
Art Center Community Room Audio Visual
01 -ERP -1105
n/a
11,000
11,000
Art Center Digital Information Sign
O1 -ERP -1106
2
2,000
2,000
Art Center Floor Scrubber
O1 -ERP -1109
n/a
8,000
8,000
Arts Center Total
24,700
17,100
41,800
City Hall Administration
Network Server
01 -ERP -0003
n/a
15,000
15,000
15,000
15,000
15,000
75,000
Telephone System
01 -ERP -0004
n/a
89,600
89,600
Computers
01 -ERP -0006
n/a
30,000
30,000
30,000
30,000
30,000
150,000
Core Network Switch
01 -ERP -0012
n/a
12,000
12,000
City Hall Administration Total
134,600
45,000
45,000
57,000
45,000
326,600
Community Services
Document Management Scanner (2)
01 -ERP -0008
n/a
10,000
10,000
Community Services Total
10,000
10,000
Fire
Tele -Squirt (Engine 2)
01 -ERP -0100
n/a
650,000
650,000
Fire/Duty Chief & Utility Leased Vehicles (5)
01 -ERP -0103a
n/a
19,606
19,606
32,707
32,707
32,707
137,333
Outfit Duty Chief Leased Vehicles (5)
01 -ERP -01036
n/a
10,000
10,000
10,000
30,000
Aerial Truck
01 -ERP -0106
n/a
54,217
54,217
54,217
54,217
216,868
Air Compressor
01 -ERP -0107
n/a
34,900
34,900
Self Contained Breathing Apparatus (SCBA) (45)
01 -ERP -0108
n/a
250,000
250,000
Extrication Tool (2)
01 -ERP -0109
n/a
27,400
27,400
Thermal Imaging Camera (2)
Of -ERP -0112
n/a
12,900
12,900
Floor Scrubber
01 -ERP -0114
n/a
14,300
14,300
Workout Equipment - Eliptical
01 -ERP -0116
n/a
5,800
5,800
Workout Equipment - Treadmill #1
01 -ERP -0117
n/a
5,800
5,800
Workout Equipment - Treadmill #2
01 -ERP -0118
n/a
5,800
5,800
Workout Equipment - Weight Lifting
0PERP-0119
n/a
5,800
5,800
Automated External Defibrillator (2)
01 -ERP -0120
n/a
7,800
7,800
Workout Equipment - Dumb Bells
01 -ERP -0122
n/a
5,000
5,000
Friday, June 06, 2014
Department Project# Priority 2015 2016 2017 2018 2019 Total
Fire Total
01 -ERP -0807 n/a
�RA
01 -ERP -0808 n/a
44 3/4 Ton Truck
O1 -ERP -0400 n/a
HRA Total
01 -ERP -0811 n/a
Pavilion
01 -ERP -0812 n/a
Pavilion Arena Scoreboard
01 -ERP -1002 n/a
Pavilion Total
01 -ERP -0816 n/a
Police
01 -ERP -0817 n/a
Marked Patrol Vehicles (6)
O1 -ERP -0200 n/a
Sergeant's Vehicle
01 -ERP -0201 n/a
Parking Enforcement Vehicle (Parking Fund)
01 -ERP -0202 n/a
Police Administrative Vehicles (2)
O1 -ERP -0204 n/a
Police Admin Cars - outfit leased vehicles
O1 -ERP -0204a n/a
SWAT Vehicle
O1 -ERP -0205 n/a
Drug Task Force Vehicle
O1 -ERP -0206 n/a
Drug Task Force Vehicle - outfit leased vehicle
O1 -ERP -0206a n/a
School Resource Officer Car
O1 -ERP -0210 n/a
School Resource Ofcr Car - outfit leased vehicle
01 -ERP -0210a n/a
Network Server (3)
O1 -ERP -0211 n/a
Tactical Ballistic Vests
O1 -ERP -0214 n/a
Radios - Portable and Mobile Devices
01 -ERP -0215 n/a
Taser Replacement
01 -ERP -0217 3
Building Video Server
Of -ERP -218 n/a
Police Total
FIL-ublic Works: Bldg/Equip Sery
4X4 1/2 Ton Truck Of -ERP -0710 n/a
Public Works: Bldg/Equip Sery Total
Public Works: Parks/Forestry
Trucksters (3)
01 -ERP -0807 n/a
Riding Mowers (2)
01 -ERP -0808 n/a
Slope Mower
01 -ERP -0809 n/a
Turf Sweeper
01 -ERP -0811 n/a
Stump Cutter
01 -ERP -0812 n/a
Skid Loader
01 -ERP -0815 n/a
Toolcat
01 -ERP -0816 n/a
Grass Seed Applicator (Overseeder)
01 -ERP -0817 n/a
Public Works: Parks/Forestry Total
27,200
!Public Works: Streets/Traffic
16,794
4X4 3/4 Ton Truck with Plow
O1 -ERP -0301 n/a
4x21 Ton Dump Truck
O1 -ERP -0302 n/a
Single Axle Dump Truck (3)
O1 -ERP -0305 n/a
Tandem Dump Truck
O1 -ERP -0306 n/a
Water Truck
01 -ERP -0307 n/a
Skid Loader (2)
Of -ERP -0309 n/a
Roller
Of -ERP -0312 n/a
115,523 358,723 770,624 94,724 70,107 1,409,701
32,400 32,400
32,400 32,400
12,000 12,000
12,000 12,000
90,000
90,000
98,000
98,000
98,000
474,000
45,000
50,600
95,600
27,200
27,200
11,923
16,794
21,999
22,655
23,329
96,700
5,000
5,000
5,000
5,000
5,000
25,000
50,000
50,000
6,189
11,074
11,074
11,740
11,740
51,817
5,000
5,000
10,000
6,000
6,000
11,205
11,205
11,879
46,289
5,000
5,000
5,000
15,000
15,000
15,000
15,000
15,000
15,000
75,000
26,900
26,900
12,300
4,100
534,400
550,800
20,900
20,900
17,000
17,000
34,000
213,412
230,168
722,578
195,500
237,548
1,599,206
31,300
31,300
31,300
31,300
34,200
34,200
11,000
20,000
31,000
32,700
32,700
18,000
18,000
21,200
21,200
32,000
32,000
63,300
63,300
11,500
11,500
22,500
52,700
53,200
81,300
34,200
243,900
30,400 30,400
54,600 54,600
124,000 124,000
173,200 173,200
150,000 150,000
41,900 41,900
45,900 45,900
Friday, June 06, 2014
Department
Project#
Priority
2015
2016
2017
2018 2019 Total
Striper
01-ERP-0313
n/a
11,200
11,200
Asphalt Paver
01-ERP-0314
n/a
48,800
48,800
Sign Machine (Traffic)
01-ERP-0317
n/a
13,400
13,400
Public Works: Streets/Traffic Total
30,400
150,000
334,400
178,600 693,400
Refuse
i
Refuse Truck (RAP-R) (2)
01-ERP-0900
n/a
204,800
204,800
Refuse Truck (Rear-L)
01-ERP-0901
n/a
101,600
101,600
Refuse Total
204,800
101,600
306,400
;Sewer
- -- -
3/4 Ton Utility Truck
O1-ERP-0551
n/a
33,600
33,600
Generator (2)
01-ERP-0555
n/a
26,400
26,400
Sewer Total
33,600
26,400
60,000
Water
112 Ton Truck
01-ERP-0500
n/a
26,800
26,800
3/4 Ton Utility Truck
O1-ERP-0501
n/a
34,900
34,900
Water Total
61,700
61,700
GRAND TOTAL
799,335
993,791
2,013,902
655,524 386,856 4,849,408
Friday, June 06, 2014
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2015 thru 2019
PROJECTS BY FUNDING SOURCE
Source Project# Priority 2015 2016 2017 2018 2019 Total
AC - Arts Center Fund 1
Art Center Video Camera Updates
O1 -ERP -1103
n/a
3,700
3,700
Art Center Theater Projector
01 -ERP -1104
n/a
17,100
17,100
Art Center Community Room Audio Visual
O1 -ERP -1105
n/a
11,000
11,000
Art Center Digital Information Sign
01 -ERP -1106
2
2,000
2,000
Art Center Floor Scrubber
O1 -ERP -1109
n/a
8,000
8,000
AC - Arts Center Fund Total
24,700
17,100
41,800
Bonds/Lease
Aerial Truck
01 -ERP -0106
n/a
54,217
54,217
54,217
54,217
216,868
Bonds/Lease Total
54,217
54,217
54,217
54,217
216,888
(Drug Task Force Funds
Building Video Server
01 -ERP -218
n/a
17,000
17,000
Drug Task Force Funds Total
17,000
17,000
Equipment Replacement Fund
Network Server
01 -ERP -0003
n/a
15,000
15,000
15,000
15,000
15,000
75,000
Telephone System
01 -ERP -0004
n/a
76,000
76,000
Computers
O1 -ERP -0006
n/a
30,000
30,000
30,000
30,000
30,000
150,000
Document Management Scanner (2)
O1 -ERP -0008
n/a
10,000
10,000
Core Network Switch
O1 -ERP -0012
n/a
12,000
12,000
Activity Center Refrigerator/Freezer
O1 -ERP -0031
n/a
1
1
Activity Center Sound System/Public Address System
O1 -ERP -0032
n/a
8,800
8,800
Activity Center Tables
O1 -ERP -0033
n/a
12,200
12,200
Tele -Squirt (Engine 2)
01 -ERP -0100
n/a
650,000
650,000
Fire/Duty Chief & Utility Leased Vehicles (5)
O1 -ERP -0103a
n/a
19,606
19,606
32,707
32,707
32,707
137,333
Outfit Duty Chief Leased Vehicles (5)
01 -ERP -0103b
n/a
10,000
10,000
10,000
30,000
Air Compressor
01 -ERP -0107
n/a
34,900
34,900
Self Contained Breathing Apparatus (SCBA) (45)
O1 -ERP -0108
n/a
250,000
250,000
Extrication Tool (2)
01 -ERP -0109
n/a
27,400
27,400
Thermal Imaging Camera (2)
Of -ERP -0112
n/a
12,900
12,900
Floor Scrubber
01 -ERP -0114
n/a
14,300
14,300
Workout Equipment - Eliptical
O1 -ERP -0116
n/a
5,800
5,800
Workout Equipment - Treadmill #1
O1 -ERP -0117
n/a
5,800
5,800
Workout Equipment - Treadmill #2
01 -ERP -0118
n/a
5,800
5,800
Workout Equipment - Weight Lifting
Of -ERP -0119
n/a
5,800
5,800
Automated External Defibrillator (2)
01 -ERP -0120
n/a
7,800
7,800
Workout Equipment - Dumb Bells
01 -ERP -0122
n/a
5,000
5,000
Marked Patrol Vehicles (6)
01 -ERP -0200
n/a
90,000
90,000
98,000
98,000
98,000
474,000
Sergeant's Vehicle
01 -ERP -0201
n/a
45,000
50,600
95,600
Fridav, June 06, 2014
Source Project# Priority 2015 2016 2017 2018 2019 Total
Parking Enforcement Vehicle (Parking Fund)
O1 -ERP -0101
n/a
27,200
27,200
Police Administrative Vehicles (2)
O1 -ERP -0204
n/a
11,923
16,794
21,999
22,655
23,329
96,700
Police Admin Cars - outfit leased vehicles
O1 -ERP -0204a
n/a
5,000
5,000
5,000
5,000
5,000
25,000
SWAT Vehicle
O1 -ERP -0205
n/a
50,000
50,000
Drug Task Force Vehicle
O1 -ERP -0206
n/a
6,189
11,074
11,074
11,740
11,740
51,817
Drug Task Force Vehicle - outfit leased vehicle
O1 -ERP -0206a
n/a
5,000
5,000
10,000
School Resource Officer Car
01 -ERP -0210
n/a
6,000
6,000
11,205
11,205
11,879
46,289
School Resource Ofcr Car - outfit leased vehicle
01 -ERP -0210a
n/a
5,000
5,000
5,000
15,000
Network Server (3)
01 -ERP -0211
n/a
15,000
15,000
15,000
15,000
15,000
75,000
Tactical Ballistic Vests
01 -ERP -0114
n/a
26,900
26,900
Radios - Portable and Mobile Devices
01 -ERP -0215
n/a
12,300
4,100
534,400
550,800
Taser Replacement
01 -ERP -0217
3
20,900
20,900
4X4 3/4 Ton Truck with Plow
Of -ERP -0301
n/a
30,400
30,400
42 1 Ton Dump Truck
O1 -ERP -0302
n/a
54,600
54,600
Single Axle Dump Truck (3)
01 -ERP -0305
n/a
124,000
114,000
Tandem Dump Truck
01 -ERP -0306
n/a
173,200
173,200
Water Truck
O1 -ERP -0307
n/a
150,000
150,000
Skid Loader (2)
O1 -ERP -0309
n/a
41,900
41,900
Roller
Of -ERP -0312
n/a
45,900
45,900
Striper
01 -ERP -0313
n/a
11,200
11,200
Asphalt Paver
01 -ERP -0314
n/a
48,800
48,800
Sign Machine (Traffic)
O1 -ERP -0317
n/a
13,400
13,400
4X41/2 Ton Truck
O1 -ERP -0710
n/a
31,300
31,300
Trucksters (3)
01 -ERP -0807
n/a
34,200
34,200
Riding Mowers (2)
O1 -ERP -0808
n/a
11,000
20,000
31,000
Slope Mower
01 -ERP -0809
n/a
32,700
32,700
Turf Sweeper
01 -ERP -0811
n/a
18,000
18,000
Stump Cutter
01 -ERP -0812
n/a
21,200
21,200
Skid Loader
01 -ERP -0815
n/a
32,000
32,000
Toolcat
01 -ERP -0816
n/a
63,300
63,300
Grass Seed Applicator (Overseeder)
01 -ERP -0817
n/a
11,500
11,500
Building Video Server
01 -ERP -218
n/a
17,000
17,000
Equipment Replacement Fund Total
452,618
792,374
1,871,585
584,207
386,856
4,087,640
rHRA - Housing and Redevelopment A
44 314 Ton Truck
O1 -ERP -0400
n/a
32,400
32,400
HRA - Housing and Redevelopment
32,400
32,400
Authority Total
PA ---Pavilion Fund
Pavilion Arena Scoreboard
O1 -ERP -1002
n/a
12,000
12,000
PA - Pavilion Fund Total
12,000
12,000
IRF - Refuse Fund
Refuse Truck (RAP -R) (2)
01 -ERP -0900
n/a
204,800
204,800
Refuse Truck (Rear -L)
01 -ERP -0901
n/a
101,600
101,600
RF - Refuse Fund Total 204,800 101,600 306,400
SF - Sanitary Sewer Fund
Telephone System 01 -ERP -0004 n/a 6,800 6,800
Fridav, June 06. 2014
Source Project# Priority 2015 2016 2017 2018 2019 Total
3/4 Ton U6lityTruck
01 -ERP -0551
n/a
33,600
33,600
Generator (2)
O1 -ERP -0555
n/a
26,400
26,400
SF - Sanitary Sewer Fund Total
6,800
33,600 26,400
66,800
WF - Water Fund
Telephone System
0I -ERP -0004
n/a
6,800
6,800
1/2 Ton Truck
01 -ERP -0500
n/a
26,800
26,800
3/4 Ton Utility Truck
01 -ERP -0501
n/a
34,900
34,900
WF - Water Fund Total
6,800
61,700
68,500
GRAND TOTAL
799,335
993,791 2,013,902 655,524 386,856
4,849,408
Friday, June 06, 2014