2014-2018 Equipment Replacement Plan (ERP)CITY OF HOPKINS FINANCE DEPARTMENT
MEMORANDUM
Date: July 16, 2013
To: Mayor & City Council
From: Christine Harkess, Finance Director
Subject: 2014-2018 Equipment Replacement Plan (ERP)
Overview
The City of Hopkins is beginning the process of establishing the 2014-2018 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. Heading into 2013 the fund had a serious cash flow issue which we
resolved by selling Equipment Certificates. This bond issue is backed by the levy authority of
the city and while the 2013 bond payment is paid with ERP fees this is not sustainable with the
current level of expenditures, therefore the bond requirements going forward will be part of the
debt levy.
Attachments
• Summary of changes in 2014-2018 ERP
• Cash flow statements
• Projects by Year
• Project by Department
• Projects by Funding Source
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 2014-2018
BACKGROUND AND SUMMARY OF CHANGES FROM 2013 PLAN
Background
The Equipment Replacement Plan is a twenty-year forecast and a five-year plan of equipment
needs in the City of Hopkins. It is intended to inform the Council and citizens of the major
equipment needs on the horizon. The first year of the plan becomes an adopted equipment
budget and relates to the operating budget of the equipment replacement fund, which is approved
on an annual basis. The remaining nineteen years represent an estimate of equipment needs and
funding capabilities of the City. Funding requirements vary from year to year. In order to
maintain a fairly consistent levy each year, the twenty-year schedule is projected with a 3%
inflation factor for operating expenses and a yearly average dollar capital expenditure of
$849,700.
The cash flow requirements to fund equipment needs in the equipment replacement fund, will
experience a roller coaster effect over the next 20 years given the projected equipment needs and
3% inflation rate. After reducing the intragovernmental charges by 50% in 2003 in response to
the LGA cuts, charges were increased 2% in 2004 and 9% in 2006 and were not increased again
until 2010 when they were raised by 2% and again by 5% in 2012. The rates were held flat for
2013. This has resulted in a steady decline in the working capital of the fund. In order to start
building cash reserves annual increases are built into the cash projections beginning in 2014 with
an 8% increase and continuing forward with increases of 9% over the next 4 years. The majority
of items purchased with ERP funds are used by departments within the General Fund which
accounts for the most of the operations of the city.
Intergovernmental charges are at 66% of what they were in 2002 and at the current rate structure
will not return to that level until 2021. In the last decade due to changes in technology and the
way we operate there is more equipment in the plan; however the rate has not increased to
accommodate the increase in equipment. Equipment that was purchased with grants such as
digital squad cameras, laptop computers in squad cars and fire vehicles, AED's, infrared cameras
and fitness equipment in the fire hall fitness room now are included in the ERP.
The long term viability of the fund remains questionable and will result in difficult decisions
regarding equipment and operations which were discussed at length during the period leading up
to the preparation of the 2014 ERP. As discussed above are scheduling an 8% rate increase for
2014, and 9% for 2015-2018 and plan to sell Equipment Certificates to fund some of the
equipment scheduled for 2016-2018. This will allow us to replace aging equipment and spread
the payments over 10 years. The required Equipment Certificate payment will be part of the
debt levy in the applicable year.
Each year staff re-evaluates the equipment needs and adjusts the schedule accordingly. Changes
to the plan are reflected in the document. Refurbishments, extended life expectancy and closer
cost estimates of replacements have been incorporated into the plan. The equipment replacement
charges in the general fund represent approximately 2.8% of total general fund expenditures.
The Equipment Replacement Plan's basic premise is scheduled replacement of present
equipment. A new item must, in the year proposed, be presented in the annual operating budget
with a stipulation that replacement will be necessary in the future. Flexibility of the Equipment
Replacement Plan is established through annual review and revision, if necessary.
Summary of Changes from 2013 Plan
Highlights of changes from last year's equipment replacement plan for the years 2014-2018:
Activity Center: There are no changes to Activity Center items in this ERP.
Arts Center: The Theater projector replaced at a cost of $15,000 was rescheduled
for 2018 at a cost of $17,100. The subsequent replacement had not
been previously scheduled.
The community room audio visual unit for $11,000 was moved from
2014 to 2015.
A theater projection screen was added in 2014 at a cost of $5,000.
This screen will replace the original retractable screen in the theater
with a wider format screen to mesh with current technology.
Theater presentation microphones were added in 2014 at a cost of
$6,000. Three lapel and three hand held microphones will be replaced
along with supporting transmitters, receivers, splitter kit and rack
mount kit.
A digital sign at a cost of $2,000 was added in 2015. This will be a
programmable and highly visible digital sign for information at the
information desk area.
City Hall: Financial software was added in 2014 at a cost of $250,000. The
current software company is not keeping up with security issues and
staff has become increasingly frustrated with the operation of the
current software.
Community Services: There are no changes to Community Services items in this ERP.
Fire: The fire utility vehicle used by the Fire Inspector and scheduled for
2016 at a cost of $35,000 was moved up to 2015 and the cost has been
increased to $40,000 to reflect actual replacement cost.
The duty chief vehicle schedule in 2015 was moved back to 2016.
The cost remains at $37,000.
The floor scrubber originally scheduled for 2016 was moved up to
2015.
The Telesquirt fire truck scheduled for 2018 has been moved up to
2017 as the truck is beginning to have structural issues. Cost remains
at $570,900.
The dumbbells for the fitness room scheduled to be replaced in 2014
have been moved back to 2017.
HRA There are no changes to HRA items in this ERP.
Pavilion: There are no changes to Pavilion items in this ERP.
Parking: There are no changes to the Parking Dept. items in this ERP.
Police: Marked squad cars that are replaced on a 3 -year schedule at $71,200
have been increased to $90,000. Two cars are replaced each year in a
three year cycle. The increase in cost is due to new models of police
vehicles. The current equipment does not fit in the new models so
new equipment needs to be purchased along with the cars.
The sergeant's vehicle scheduled for replacement in 2015 at $37,800
has been increased to $45,000 for the same reason the marked squad
car cost was increased.
The administrative vehicles for the police chief and captain will be
leased starting in 2014. The chief's car will be leased in 2014 and the
captain's in 2015. These vehicles were previously purchased on
alternate years. The vehicles will leased for 4 years. The second two
years of each lease will be used by the investigative sergeant (chief's
car) and a detective (captain's car). The ERP item reflects the lease
and a corresponding amount to outfit the vehicles estimated at $5,000
per vehicle.
The police services liaison vehicle scheduled for replacement in 2015
at a cost of $25,000 has been removed from the ERP as it is no longer
needed.
A Drug Task Force vehicle has been added in 2014 on a leased basis.
As part of the SW Metro DTF a vehicle is not provided to officers and
each department needs to supply one. This vehicle will be leased for
four years with the second two years of the lease going to a detective.
The ERP item reflects the lease and a corresponding amount to outfit
the vehicle estimated at $5,000.
A FOCUS (Focus On Crime Using Strategy) vehicle has been added in
2015 on a leased basis. This car will be used by the FOCUS officers
in the performance of their duties. This vehicle will be leased for four
years with the second two years of the lease going to a detective. The
ERP item reflects the lease and a corresponding amount to outfit the
vehicle estimated at $5,000.
A logging recorded used by dispatch and scheduled for replacement in
2014 at a cost of $36,900 has been removed from the ERP. With
dispatch moved to Hennepin County this item is no longer needed.
Digital cameras for squad cars originally scheduled for 2014 have
been moved back to 2015. The cost remains at $53,400.
Mobile radios for squad cars originally scheduled for replacement in
2018 have been moved up according to car replacement. The current
radios do not fit in the new model police cars so when new cars are
purchased new radios will also be purchased and installed. Three were
purchased in 2013, five will be purchased in 2014 and 2015 and three
in 2016. The portable radios and mobiles for the Fire Dept. remain
scheduled for 2018.
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.
Engineering
No changes
Parks/Forestry
A tractor scheduled for 2016 at a cost of $49,300 was moved up to
2014 at a cost of $52,000. This vehicle will be replaced with a tool cat
that has a blower and broom attachment. Cost was increased to reflect
actual replacement cost.
A trucksteer originally scheduled for 2013 was moved back to 2014.
The cost was reduced from $19,800 to $11,000 to reflect the purchase
of an electric style workman.
Riding mowers scheduled for 2014 and 2015 at a cost of $11,000 and
$20,000 were moved back to 2015 and 2016 at the same cost.
Streets/Traffic
A roller used by the street department for asphalt repair and
resurfacing and originally scheduled for 2014 was moved back to
2016. Cost remains at $45,900.
An asphalt paver used by the street department was moved from 2014
to 2016. The cost remains at $48,800.
A snow blower originally scheduled for replacement in 2016 at a cost
of $102,300 has been moved up to 2014 and the cost reduced to
$65,000 to reflect the purchase of a hydraulic powered blower.
Refuse
A rear loading refuse truck scheduled for replacement in 2014 at a cost
of $101,600 has been moved back to 2015.
Water
There are no changes to water department items in this ERP.
Sewer
The 4x4 3/ Ton Truck originally scheduled for replacement in 2014 at
a cost of $35,700 has been moved back to 2015 and the cost reduced to
$30,000.
EQUIPMENT REPLACEMENT FUND (602) 07/09/2013
Impact on General Fund
0
28,938
35,160
38,323
41,773
Rate Change
5%
0%
8%
9%
9%
9%
9%
ACTUAL
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
2012
2013
2014
2015
2016
2017
2018
Working Capital Begin Year
890,189
1,084,440
1,069,566
674,200
573,558
215,593
865,741
Revenues from charges
316,784
316,784
342,127
372,918
406,481
443,064
482,940
Transfer in General Fund
50,000
50,000
509000
Transfer In - Pavilion - Capital Lease
20,000
15,609
Transfer In - Pavilion - Hockey Loan
3,143
3,143
3,142
Federal & State Grants
Interest earnings
5,910
10,984
10,835
6,881
5,875
2,295
8,797
Other revenues (sale of assets)
47,834
25,000
30,000
30,000
30,000
30,000
30,000
Equipment Certificates (Bonds)
346,274
451,769
1,272,000
Total Revenues
739,944
823,289
436,104
459,799
492,355
1,747,359
521,736
Expenditures (excludes Depr.)
15,802
16,276
16,764
17,267
17,785
18,319
18,868
Fire Truck Financing Pymnts (2009-2018)
53,858
54,217
54,217
54,217
54,217
54,217
54,217
Capital Outlay - Equipment
476,034
703,300
760,488
488,958
778,318
1,024,676
1,246,448
2012 Equip Certificate Pymnts (10yr 3%)
64,370
Total Expenses
545,694
838,163
831,469
560,442
850,320
1,097,211
1,442,908
Working Capital Ending Balance
1,084,440
19069,566
674,200
573,558
215,593
865,741
(55,431)
Actual/Estimated Cash balances
1,098,353
1,083,479
688,114
587,471
229,507
879,654
(41,517)
Bond Memo
2012 Equip Certificate Pymnts (10yr 3%) 89,050 92,500 90,900 89,300 87,700
Tax Levy Requirements 64,370 97,965 96,285 94,605 92,925 96,495
2012 Equipment Certificates
ERP #
Year
In ERP
Estimated
Cost
Fund
12
Listing of Equipment to Purchase
2016
41,900
ERP
20
01 -ERP -01312
Items from 2012-2014
45,900
ERP
20
01 -ERP -0314
2016
48,800
ERP
10
Year
Estimated
570,900
Item
Life
ERP #
In ERP
Cost
Fund
Quick Attach Pumper
10
01 -ERP -0105
2012
245,000
ERP
Single Axel Dump Truck
17
01 -ERP -0305
2012
127,400
ERP
Front End Loader
15
01 -ERP -0308
2012
172,000
ERP
Backhoe
20
01 -ERP -502
2013
75,000
Water
Regenerative Air Sweeper
12
01 -ERP -0311
2013
185,000
ERP
Total ERP
804,400
Ice Resurfacer
12
01 -ERP -1001
2014
180,000
Pavilion
Grand Total
984,400
2017 Equipment Certificates
Listing of Equipment to Purchase
Items from 2017 -2018
Item
Skid Loader
Roller
Asphalt Paver
Telesquirt Engine #2
Water Truck
Skid Loader
4x2 1 Ton Dump Truck
Single Axel Dump Truck
Tandem Dump Truck
4x4 1/2 Ton Truck
Total
Life
ERP #
Year
In ERP
Estimated
Cost
Fund
12
01 -ERP -0309
2016
41,900
ERP
20
01 -ERP -01312
2016
45,900
ERP
20
01 -ERP -0314
2016
48,800
ERP
10
01 -ERP -0100
2017
570,900
ERP
22
01 -ERP -0307
2017
150,000
ERP
12
01 -ERP -0815
2017
32,000
ERP
12
01 -ERP -0302
2018
54,600
ERP
17
01 -ERP -0305
2018
124,000
ERP
17
01 -ERP -0306
2018
173,200
ERP
10
01 -ERP -0710
2018
31,300
ERP
ERP
REFUSE FUND - WORKING CAPITAL PROJECTION 07/05/2013
Actual
Projected
Projected
Projected
Projected
Projected
Projected
2012
2013
2014
2015
2016
2017
2018
Working Capital Beginning Year
531,787
627,351
748,108
860,763
708,765
853,210
1,039,311
Revenues:
Operating Revenues
Refuse Collection
705,912 x
738,786
738,786 x
788,786
788,786 x
838,786
838,786
Recycling Rates
x 138,097
138,097 x
146,197
146,197 x
154,297
154,297 x
162,397
Bulk Collection
13,328
12,000
12,000
12,000
12,000
12,000
12,000
Yard Waste
9,470
10,000
10,000
10,000
10,000
10,000
10,000
Recycling rebates
28,881
30,000
30,000
30,000
30,000
30,000
30,000
Miscellaneous (penalties)
11,599
10,000
10,000
10,000
10,000
10,000
10,000
Grants
17,795
19,000
18,500
18,000
17,500
17,000
16,500
Gain on sale of assets
0
Interest
3,945
3,137
3,741
4,304
3,544
4,266
5,197
Total Revenues
929,027
961,020
969,224
1,019,287
1,026,127
1,076,350
1,084,880
Expenditures:
Operation Expense
807,192
815,264
831,569
839,885
856,682
865,249
882,554
Transfer Out
Capital Outlay (per ERP)
306,400
Capital Projects per CIP
Capital Lease (PW Facility)
25,000
25,000
25,000
25,000
25,000
25,000
25,000
Total Expenditures
832,192
840,264
856,569
1,171,285
881,682
890,249
907,554
Change in available funds
96,835
120,756
112,655
(151,997)
144,445
186,100
177,326
Inventory change
(1,271)
Working Capital Ending Year
627,351
748,108
860,763
708,765
853,210
1,039,311
1,216,636
Rate History
1989 $15.10
1991 $17.25
x = year this rate
will be raised
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
Refuse accounts as of 7/2012
= 2,742
2012 $4.00 recycling fee
On average recycling accounts total 2700 per
month
2013 $16.85, $20.85, $24.30 refuse
Each $0.25
increase generates approximately $8,100 additional
revenue per year
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
City of Hopkins, MN
EQUIPMENT REPLA CEMENT PLAN
2014 thru 2018
PROJECTS BY YEAR
Project Name Department Project # Priority Project Cost
2014
Art Center Theater Projection Screen
Arts Center
01 -ERP -1107
2
5,000
Art Center Theater Presentation Microphones
Arts Center
01 -ERP -1108
1
6,000
Network Server
City Hall Administration
01 -ERP -0003
n/a
8,000
Financial Software - Various Depts
City Hall Administration
01 -ERP -0005
n/a
250,000
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
Election Equipment
Community Services
07 -ERP -0077
n/a
50,000
Aerial Truck
Fire
07 -ERP -0706
n/a
54,217
Automated External Defibrillator (2)
Fire
07 -ERP -0720
n/a
7,200
Workout Equipment - Dumb Bells
Fire
01 -ERP -0722
n/a
5,000
HRA Copier
HRA
01 -ERP -0407
n/a
13,000
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
90,000
PSO - Utility 44 (unit 212)
Police
07 -ERP -0203
n/a
47,700
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
4,694
Police Admin Cars - outfit leased vehicles
Police
07 -ERP -0204a
n/a
5,000
Drug Task Force Vehicle
Police
01 -ERP -0206
n/a
4,694
Drug Task Force Vehicle - outfit leased vehicle
Police
07 -ERP -0206a
n/a
5,000
Network Server (3)
Police
01 -ERP -0277
n/a
8,500
Mobile Data Computers
Police
01 -ERP -0272
n/a
62,700
Radios - Portable and Mobile Devices
Police
07 -ERP -0215
n/a
20,500
Engineering Van
Public Works: Engineering
07 -ERP -0700
n/a
2,000
3/4 Ton Utility Truck
Public Works: Parks/Forestry
07 -ERP -0802
n/a
32,200
Tractor
Public Works: Parks/Forestry
01 -ERP -0806
n/a
52,000
Trucksters (3)
Public Works: Parks/Forestry
01 -ERP -0807
n/a
11,000
Snow Blower
Public Works: Streets/Traffic
01 -ERP -0375
n/a
65,000
Total for 2014
839,405
20
Art Center Community Room Audio Visual
Arts Center
01 -ERP -1105
n/a
11,000
Arts Center - Digital Information Sign
Arts Center
07 -ERP -1106
2
2,000
Network Server
City Hall Administration
07 -ERP -0003
n/a
8,000
Telephone System
City Hall Administration
01 -ERP -0004
n/a
89,600
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
Fire Utility Vehicle (Pick Up Truck)
Fire
01 -ERP -0705a
n/a
40,000
Aerial Truck
Fire
07 -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 - Summit Trainer
Fire
07 -ERP -0117
n/a
5,800
Workout Equipment - Weight Lifting
Fire
07 -ERP -0119
n/a
5,800
44 3/4 Ton Truck
HRA
01 -ERP -0400
n/a
32,400
Marked Patrol Vehicles (6)
Police
07 -ERP -0200
n/a
90,000
Sergeant's Vehicle
Police
07 -ERP -0207
n/a
45,000
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
9,529
Police Admin Cars - outfit leased vehicles
Police
01 -ERP -0204a
n/a
5,000
Drug Task Force Vehicle
Police
01 -ERP -0206
n/a
4,694
Tuesday, Juh' 09, 2013
Project Name Department Project # Priority Project Cost
Focus Car
Police
01 -ERP -0270
n/a
4,835
Focus Car - outfit leased vehicle
Police
01 -ERP -0270a
n/a
5,000
Network Server (3)
Police
07 -ERP -0277
n/a
8,500
Digital Squad Car Cameras
Police
07 -ERP -0273
n/a
53,400
Radios - Portable and Mobile Devices
Police
01 -ERP -0275
n/a
20,500
Riding Mowers (2)
Public Works: Parks/Forestry
07 -ERP -0808
n/a
11,000
4X4 3/4 Ton Truck with Plow
Public Works: Streets/Traffic
07 -ERP -0301
n/a
30,400
Sign Machine (Traffic)
Public Works: Streets/Traffic
07 -ERP -0377
n/a
13,400
Refuse Truck (RAP -R) (2)
Refuse
07 -ERP -0900
n/a
204,800
Refuse Truck (Rear -L)
Refuse
07 -ERP -0907
n/a
101,600
44 3/4 Ton Truck
Sewer
07 -ERP -0550
n/a
30,000
Total for 2016 866,135
2017
Art Center Video Camera Updates
Total for 2015
07 -ERP -7103
n/a
936,575
20�
City Hall Administration
01 -ERP -0003
n/a
8,000
Network Server
City Hall Administration
07 -ERP -0003
n/a
8,000
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
Duty Chief Vehicle
Fire
07 -ERP -0703
n/a
37,000
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Air Compressor
Fire
07 -ERP -0707
n/a
34,900
Self Contained Breathing Apparatus (45)
Fire
01 -ERP -0108
n/a
250,000
Marked Patrol Vehicles (6)
Police
07 -ERP -0200
n/a
90,000
Parking Enforcement Vehicle (Parking Fund)
Police
01 -ERP -0202
n/a
27,200
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
14,509
Police Admin Cars - outfit leased vehicles
Police
07 -ERP -0204a
n/a
5,000
SWAT Vehicle
Police
01 -ERP -0205
n/a
30,000
Drug Task Force Vehicle
Police
07 -ERP -0206
n/a
9,674
Drug Task Force Vehicle - outfit leased vehicle
Police
07 -ERP -0206a
n/a
5,000
Copy Machine - Police Dept
Police
01 -ERP -0209
n/a
22,100
Focus Car
Police
07 -ERP -0270
n/a
4,835
Network Server (3)
Police
07 -ERP -0211
n/a
8,500
Radios - Portable and Mobile Devices
Police
07 -ERP -0215
n/a
12,300
Riding Mowers (2)
Public Works: Parks/Forestry
07 -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
07 -ERP -0309
n/a
41,900
Roller
Public Works: Streets/Traffic
07 -ERP -0312
n/a
45,900
Asphalt Paver
Public Works: Streets/Traffic
01 -ERP -0314
n/a
48,800
3/4 Ton Utility Truck
Sewer
01 -ERP -0557
n/a
33,600
Total for 2016 866,135
2017
Art Center Video Camera Updates
Arts Center
07 -ERP -7103
n/a
3,700
Network Server
City Hall Administration
01 -ERP -0003
n/a
8,000
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
Document Management Scanner (2)
Community Services
07 -ERP -0008
n/a
6,000
Tele -Squirt (Engine 2)
Fire
07 -ERP -0100
n/a
570,900
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Thermal Imaging Camera (2)
Fire
01 -ERP -0712
n/a
12,900
Workout Equipment - Treadmill
Fire
01 -ERP -0778
n/a
5,800
Marked Patrol Vehicles (6)
Police
07 -ERP -0200
n/a
98,000
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
19,638
Police Admin Cars - outfit leased vehicles
Police
01 -ERP -0204a
n/a
5,000
Drug Task Force Vehicle
Police
01 -ERP -0206
n/a
9,674
Focus Car
Police
07 -ERP -0210
n/a
9,964
Focus Car - outfit leased vehicle
Police
07 -ERP -0210a
n/a
5,000
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Tuesdav, Ju1v 09, 2013
Project Name Department Project # Priority, Project Cost
Taser Replacement
Police
01 -ERP -0217
3
20,900
Stump Cutter
Public Works: Parks/Forestry
07 -ERP -0812
n/a
21,200
Skid Loader
Public Works: Parks/Forestry
07 -ERP -0875
n/a
32,000
Water Truck
Public Works: Streets/Traffic
07 -ERP -0307
n/a
150,000
Striper
Public Works: Streets/Traffic
07 -ERP -0313
n/a
11,200
Generator (2)
Sewer
07 -ERP -0555
n/a
26,400
1/2 Ton Truck
Water
07 -ERP -0500
n/a
26,800
3/4 Ton Utility Truck
Water
01 -ERP -0507
n/a
34,900
2018
Art Center Theater Projector
Network Server
Computers
Core Network Switch
Document Management Scanner (2)
Aerial Truck
Automated External Defibrillator (2)
Marked Patrol Vehicles (6)
Police Administrative Vehicles (2)
Police Admin Cars - outfit leased vehicles
Drug Task Force Vehicle
Drug Task Force Vehicle - outfit leased vehicle
Focus Car
Network Server (3)
Tactical Ballistic Vests
Radios - Portable and Mobile Devices
4X4 1/2 Ton Truck
Turf Sweeper
Toolcat
42 1 Ton Dump Truck
Single Axle Dump Truck (3)
Tandem Dump Truck
GRAND TOTAL
Total for 2017
1,170,693
Arts Center
07 -ERP -7704
n/a
17,100
City Hall Administration
07 -ERP -0003
n/a
8,000
City Hall Administration
07 -ERP -0006
n/a
30,000
City Hall Administration
07 -ERP -0072
n/a
12,000
Community Services
07 -ERP -0008
n/a
6,000
Fire
07 -ERP -0706
n/a
54,217
Fire
01 -ERP -0720
n/a
7,800
Police
01 -ERP -0200
n/a
98,000
Police
01 -ERP -0204
n/a
20,224
Police
01 -ERP -0204a
n/a
5,000
Police
01 -ERP -0206
n/a
10,260
Police
07 -ERP -0206a
n/a
5,000
Police
01 -ERP -0210
n/a
9,964
Police
07 -ERP -0217
n/a
8,500
Police
07 -ERP -0274
n/a
26,900
Police
07 -ERP -0215
n/a
534,400
Public Works: Bldg/Equip Sery
01 -ERP -0770
n/a
31,300
Public Works: Parks/Forestry
01 -ERP -0871
n/a
18,000
Public Works: Parks/Forestry
07 -ERP -0876
n/a
63,300
Public Works: Streets/Traffic
07 -ERP -0302
n/a
54,600
Public Works: Streets/Traffic
07 -ERP -0305
n/a
124,000
Public Works: Streets/Traffic
07 -ERP -0306
n/a
173,200
Total for 2018
1,317,765
5,130,573
Tuesday, July 09, 2013
City of Hopkins, MN
EQUIPMENT REPLA CEMENT PLAN
2014 thru 2018
PROJECTS BY DEPARTMENT
Department Project# Priority 2014 2015 2016 2017 2018 Total
(Arts Center
Art Center Video Camera Updates
01 -ERP -7703
n/a
3,700
3,700
Art Center Theater Projector
01 -ERP -1104
n/a
17,100
77,100
Art Center Community Room Audio Visual
01 -ERP -1105
n/a
11,000
17,000
Arts Center- Digital Information Sign
01 -ERP -7706
2
2,000
2,000
Art Center Theater Projection Screen
01 -ERP -7707
2
5,000
5,000
Art Center Theater Presentation Microphones
01 -ERP -1708
1
6,000
6,000
Arts Center Total
11,000
13,000
3,700
17,100
44,800
City Hall Administration I
Network Server
07 -ERP -0003
n/a
8,000
8,000
8,000
8,000
8,000
40,000
Telephone System
07 -ERP -0004
n/a
89,600
89,600
Financial Software - Various Depts
07 -ERP -0005
n/a
250,000
250,000
Computers
07 -ERP -0006
n/a
30,000
30,000
30,000
30,000
30,000
750,000
Core Network Switch
01 -ERP -0012
n/a
12,000
72,000
City Hall Administration Total
288,000
127,600
38,000
38,000
50,000
541,600
Community Services
Document Management Scanner (2)
01 -ERP -0008
n/a
6,000
6,000
12,000
Election Equipment
01 -ERP -0011
n/a
50,000
50,000
Community Services Total
50,000
6,000
6,000
62,000
IFire
Tele -Squirt (Engine 2)
01 -ERP -0700
n/a
570,900
570,900
Duty Chief Vehicle
01 -ERP -0103
n/a
37,000
37,000
Fire Utility Vehicle (Pick Up Truck)
07 -ERP -0105a
n/a
40,000
40,000
Aerial Truck
07 -ERP -0706
n/a
54,217
54,217
54,217
54,217
54,217
271,085
Air Compressor
01 -ERP -0707
n/a
34,900
34,900
Self Contained Breathing Apparatus (45)
07 -ERP -0108
n/a
250,000
250,000
Thermal Imaging Camera (2)
07 -ERP -0172
n/a
12,900
12,900
Floor Scrubber
01 -ERP -0174
n/a
14,300
14,300
Workout Equipment - Eliptical
07 -ERP -0176
n/a
5,800
5,800
Workout Equipment - Summit Trainer
01 -ERP -0117
n/a
5,800
5,800
Workout Equipment - Treadmill
01 -ERP -0178
n/a
5,800
5,800
Workout Equipment - Weight Lifting
01 -ERP -0779
n/a
5,800
5,800
Automated External Defibrillator (2)
07 -ERP -0120
n/a
7,200
7,800
15,000
Workout Equipment - Dumb Bells
01 -ERP -0722
n/a
5,000
5,000
Fire Total
66,417
125,917
376,117
643,817
62,017
1,274,285
HRA
44 3/4 Ton Truck
07 -ERP -0400
n/a
32,400
32,400
HRA Copier
01 -ERP -0407
n/a
13,000
13,000
Tuesday.
Juh 09, 2013
Department Project# Priority 2014 2015 2016 2017 2018 Total
HRA Total 13,000 32,400 45,400
Police
Marked Patrol Vehicles (6)
07 -ERP -0200
n/a
90,000
90,000
90,000
98,000
98,000
466,000
Sergeant's Vehicle
01 -ERP -0201
n/a
45,000
45,000
Parking Enforcement Vehicle (Parking Fund)
01 -ERP -0202
n/a
27,200
31,300
27,200
PSO - Utility 44 (unit 212)
01 -ERP -0203
n/a
47,700
31,300
47,700
Police Administrative Vehicles (2)
01 -ERP -0204
n/a
4,694
9,529
14,509
19,638
20,224
68,594
Police Admin Cars - outfit leased vehicles
07 -ERP -0204a
n/a
5,000
5,000
5,000
5,000
5,000
25,000
SWAT Vehicle
07 -ERP -0205
n/a
2,000
30,000
30,000
Drug Task Force Vehicle
07 -ERP -0206
n/a
4,694
4,694
9,674
9,674
10,260
38,996
Drug Task Force Vehicle - outfit leased vehicle
07 -ERP -0206a
n/a
5,000
5,000
5,000
15,000
Copy Machine - Police Dept
07 -ERP -0209
n/a
52,000
22,100
22,100
Focus Car
07 -ERP -0270
n/a
11,000
4,835
4,835
9,964
9,964
29,598
Focus Car- outfit leased vehicle
01 -ERP -0270a
n/a
5,000
20,000
5,000
70,000
Network Server (3)
01 -ERP -0271
n/a
8,500
8,500
8,500
8,500
8,500
42,500
Mobile Data Computers
01 -ERP -0212
n/a
62,700
18,000
62,700
Digital Squad Car Cameras
07 -ERP -0213
n/a
53,400
21,200
53,400
Tactical Ballistic Vests
07 -ERP -0274
n/a
32,000
26,900
26,900
Radios - Portable and Mobile Devices
07 -ERP -0275
n/a
20,500
20,500
12,300
534,400
587,700
Taser Replacement
07 -ERP -0277
3
95,200
11,000
52,700
20,900
81,300
20,900
Police Total
248,788
246,458
229,118
176,676
718,248
1,619,288
(Public Works: Bldg/Equip Ser-,,
04 1/2 Ton Truck
07 -ERP -0710
n/a
31,300
37,300
Public Works: Bldg/Equip Sery Total
31,300
31,300
Public Works: Engineering
Engineering Van
07 -ERP -0700
n/a
2,000
2,000
Public Works: Engineering Total
2,000
2,000
Public Works: Parks/Forestry i
3/4 Ton Utility Truck
01 -ERP -0802
n/a
32,200
32,200
Tractor
01 -ERP -0806
n/a
52,000
52,000
Trucksters (3)
01 -ERP -0807
n/a
11,000
11,000
Riding Mowers (2)
01 -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 -0817
n/a
18,000
78,000
Stump Cutter
07 -ERP -0812
n/a
21,200
21,200
Skid Loader
07 -ERP -0875
n/a
32,000
32,000
Toolcat
01 -ERP -0876
n/a
63,300
63,300
Public Works: Parks/Forestry Total
95,200
11,000
52,700
53,200
81,300
293,400
�iublic Works: Streets/Traffic
4X4 3/4 Ton Truck with Plow
07 -ERP -0307
n/a
30,400
30,400
42 1 Ton Dump Truck
01 -ERP -0302
n/a
54,600
54,600
Single Axle Dump Truck (3)
01 -ERP -0305
n/a
124,000
724,000
Tandem Dump Truck
07 -ERP -0306
n/a
173,200
173,200
Water Truck
07 -ERP -0307
n/a
150,000
750,000
Skid Loader (2)
07 -ERP -0309
n/a
41,900
47,900
Roller
07 -ERP -0312
n/a
45,900
45,900
Striper
07 -ERP -0313
n/a
11,200
11,200
hiesdai. Juh 09, 2013
Department
Project#
Priority
2014
2015
2016
2017 2018
Total
Asphalt Paver
01 -ERP -0314
n/a
48,800
48,800
Snow Blower
07 -ERP -0315
n/a
65,000
65,000
Sign Machine (Traffic)
07 -ERP -0377
n/a
13,400
13,400
Public Works: Streets/Traffic Total
65,000
43,800
136,600
161,200 351,800
758,400
.Refuse
Refuse Truck (RAP -R) (2)
07 -ERP -0900
n/a
204,800
204,800
Refuse Truck (Rear -L)
07 -ERP -0907
n/a
101,600
701,600
Refuse Total
306,400
306,400
Sewer
44 3/4 Ton Truck
07 -ERP -0550
n/a
30,000
30,000
3/4 Ton Utility Truck
07 -ERP -0557
n/a
33,600
33,600
Generator (2)
07 -ERP -0555
n/a
26,400
26,400
Sewer Total
30,000
33,600
26,400
90,000
(Water
1/2 Ton Truck
07 -ERP -0500
n/a
26,800
26,800
3/4 Ton Utility Truck
01 -ERP -0507
n/a
34,900
34,900
Water Total
61,700
61,700
GRAND TOTAL
839,405
936,575
866,135
1,170,693 1,317,765
5,130,573
Tuesday. Juh09, 2013
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2014 thru 2018
PROJECTS BY FUNDING SOURCE
Source
Project# Priority
2014
2015
2016 2017
2018
Total
IAC - Arts Center Fund
171,085
(Equipment Replacement Fund
Art Center Video Camera Updates
07 -ERP -1103 n/a
3,700
01 -ERP -0003
3,700
Art Center Theater Projector
01 -ERP -1704 n/a
8,000
8,000
8,000
17,100
17,100
Art Center Community Room Audio Visual
O7 -ERP -1105 n/a
11,000
11,000
Art Center Theater Presentation Microphones
01 -ERP -1708 1
6,000
n/a
250,000
6,000
AC - Arts Center Fund Total
6,000
11,000
3,700
17,100
37,800
30,000
30,000
30,000
30,000
150,000
Document Management Scanner (2)
01 -ERP -0008
n/a
6,000
Bonds/Lease
Aerial Truck
07 -ERP -0706 n/a
54,217
54,217
54,217 54,217
54,217
277,085
Bonds/Lease Total
54,217
54,217
54,217
54,217
54,217
171,085
(Equipment Replacement Fund
Network Server
01 -ERP -0003
n/a
8,000
8,000
8,000
8,000
8,000
40,000
Telephone System
07 -ERP -0004
n/a
76,000
76,000
Financial Software - Various Depts
01 -ERP -0005
n/a
250,000
250,000
Computers
07 -ERP -0006
n/a
30,000
30,000
30,000
30,000
30,000
150,000
Document Management Scanner (2)
01 -ERP -0008
n/a
6,000
6,000
12,000
Election Equipment
01 -ERP -0077
n/a
50,000
50,000
Core Network Switch
07 -ERP -0072
n/a
12,000
72,000
Tele -Squirt (Engine 2)
07 -ERP -0100
n/a
570,900
570,900
Duty Chief Vehicle
01 -ERP -0103
n/a
37,000
37,000
Fire Utility Vehicle (Pick Up Truck)
07 -ERP -0105a
n/a
40,000
40,000
Air Compressor
07 -ERP -0707
n/a
34,900
34,900
Self Contained Breathing Apparatus (45)
07 -ERP -0708
n/a
250,000
250,000
Thermal Imaging Camera (2)
07 -ERP -0112
n/a
12,900
12,900
Floor Scrubber
07 -ERP -0774
n/a
14,300
14,300
Workout Equipment - Eliptical
07 -ERP -0116
n/a
5,800
5,800
Workout Equipment - Summit Trainer
07 -ERP -0117
n/a
5,800
5,800
Workout Equipment - Treadmill
07 -ERP -0178
n/a
5,800
5,800
Workout Equipment - Weight Lifting
07 -ERP -0719
n/a
5,800
5,800
Automated External Defibrillator (2)
07 -ERP -0120
n/a
7,200
7,800
15,000
Workout Equipment - Dumb Bells
07 -ERP -0122
n/a
5,000
5,000
Marked Patrol Vehicles (6)
01 -ERP -0200
n/a
90,000
90,000
90,000
98,000
98,000
466,000
Sergeant's Vehicle
01 -ERP -0207
n/a
45,000
45,000
Parking Enforcement Vehicle (Parking Fund)
07 -ERP -0202
n/a
27,200
27,200
PSO - Utility 4x4 (unit 212)
01 -ERP -0203
n/a
47,700
47,700
Police Administrative Vehicles (2)
01 -ERP -0204
n/a
4,694
9,529
14,509
19,638
20,224
68,594
Police Admin Cars - outfit leased vehicles
01 -ERP -0204a
n/a
5,000
5,000
5,000
5,000
5,000
25,000
SWAT Vehicle
01 -ERP -0205
n/a
30,000
30,000
Drug Task Force Vehicle
07 -ERP -0206
n/a
4,694
4,694
9,674
9,674
10,260
38,996
Drug Task Force Vehicle - outfit leased vehicle
07 -ERP -0206a
n/a
5,000
5,000
5,000
15,000
Copy Machine - Police Dept
07 -ERP -0209
n/a
22,100
22,700
Tuesdnr, Ah 09. 2013
Source Project# Priority 2014 2015 2016 2017 2018 Total
Focus Car
01 -ERP -0210
n/a
760,488
4,835
4,835
9,964
9,964
29,598
Focus Car - outfit leased vehicle
01 -ERP -0210a
n/a
4x4 3/4 Ton Truck
5,000
n/a
5,000
32,400
10,000
Network Server (3)
07 -ERP -0277
n/a
8,500
8,500
8,500
8,500
8,500
42,500
Mobile Data Computers
07 -ERP -0212
n/a
57,000
57,000
Digital Squad Car Cameras
07 -ERP -0213
n/a
53,400
Mobile Data Computers
01 -ERP -0212
53,400
Tactical Ballistic Vests
01 -ERP -0214
n/a
PKG - Parking Fund Total
5,700
26,900
26,900
Radios - Portable and Mobile Devices
01 -ERP -0215
n/a
20,500
20,500
12,300
Refuse Truck (RAP -R) (2)
534,400
587,700
Taser Replacement
07 -ERP -0277
3
Refuse Truck (Rear -L)
01 -ERP -0907
n/a
20,900
101,600
20,900
4X4 3/4 Ton Truck with Plow
07 -ERP -0301
n/a
30,400
306,400
30,400
42 1 Ton Dump Truck
07 -ERP -0302
n/a
54,600
54,600
Single Axle Dump Truck (3)
07 -ERP -0305
n/a
124,000
124,000
Tandem Dump Truck
07 -ERP -0306
n/a
173,200
773,200
Water Truck
07 -ERP -0307
n/a
150,000
750,000
Skid Loader (2)
01 -ERP -0309
n/a
41,900
41,900
Roller
07 -ERP -0372
n/a
45,900
45,900
Striper
07 -ERP -0313
n/a
11,200
71,200
Asphalt Paver
01 -ERP -0314
n/a
48,800
48,800
Snow Blower
01 -ERP -0315
n/a
65,000
65,000
Sign Machine (Traffic)
01 -ERP -0377
n/a
13,400
13,400
Engineering Van
07 -ERP -0700
n/a
2,000
2,000
4X41/2 Ton Truck
07 -ERP -0770
n/a
31,300
31,300
3/4 Ton Utility Truck
01 -ERP -0802
n/a
32,200
32,200
Tractor
07 -ERP -0806
n/a
52,000
52,000
Trucksters (3)
07 -ERP -0807
n/a
11,000
17,000
Riding Mowers (2)
07 -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
07 -ERP -0812
n/a
21,200
27,200
Skid Loader
01 -ERP -0815
n/a
32,000
32,000
Toolcat
07 -ERP -0876
n/a
63,300
63,300
Arts Center- Digital Information Sign
07 -ERP -1106
2
2,000
2,000
Art Center Theater Projection Screen
07 -ERP -1107
2
5,000
5,000
Equipment Replacement Fund Total
760,488
488,958 778,318 1,024,676 1,246,448
4,298,888
HRA - Housing and Redevelopment A
4x4 3/4 Ton Truck
07 -ERP -0400
n/a
32,400
32,400
HRA Copier
01 -ERP -0401
n/a
13,000
73,000
HRA - Housing and Redevelopment
13,000
32,400
45,400
Authority Total
PKG - Parking Fund
Mobile Data Computers
01 -ERP -0212
n/a
5,700
5,700
PKG - Parking Fund Total
5,700
5,700
IRF - Refuse Fund
Refuse Truck (RAP -R) (2)
01 -ERP -0900
n/a
204,800
204,800
Refuse Truck (Rear -L)
01 -ERP -0907
n/a
101,600
107,600
RF - Refuse Fund Total
306,400
306,400
SF - Sanitary Sewer Fund
Tues(hiv. ,1uh09. 2013
Source Project# PrioritN 2014 2015 2016 2017 2018 Total
Telephone System
01 -ERP -0004
n/a
6,800
6,800
44 3/4 Ton Truck
01 -ERP -0550
n/a
30,000
30,000
3/4 Ton Utility Truck
07 -ERP -0557
n/a
33,600
33,600
Generator (2)
01 -ERP -0555
n/a
26,400
26,400
SF - Sanitary Sewer Fund Total
36,800 33,600
26,400
96,800
INET - Water Fund
�
Telephone System
01 -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 839,405 936,575 866,135 1,170,693 1,317,765 5,130,573
Tuesday, Juh 09. 2013