CR 2012-090 (2013 - 2017 ERP)August 21, 2012 14a
Council Report 2012-090
City of Kopkim
2013-2017 EQUIPMENT REPLACEMENT PLAN
Proposed Action
Staff recommends adoption of the following motion: Move to adopt the 2013-2017 Equipment Replacement
Plan.
Overview
The equipment replacement plan is a detailed summary of the next five years of a twenty-year replacement
schedule, for equipment of the City of Hopkins. General and Special Revenue fund equipment items are
placed in the Equipment Replacement Fund budget which derives its revenues from service charges to the
General and Special Revenue funds, equipment sales and interest earnings. The Enterprise fund equipment
in the plan is placed in the individual enterprise fund budgets, in the year in which the equipment is to be
purchased.
Approval of the 2013-2017 allows staff to incorporate the 2013 ERP items into the 2013 budgets and begin
preparation for their purchase. Items that fall under the Minnesota Statutes Uniform Bidding/Contracting
Laws will require further approval by the council before their purchase.
Staff is recommending adoption of the plan.
Primary Issues to Consider
• Should the annual service charges to the general and special revenue funds be adjusted?
• What changes have occurred in the equipment replacement plan since last year?
Supporting Information
• 2013-2017 ERP Power Point slides
• 2013-2017 Equipment Replacement Plan
Christine M. Harkess, CPA, CGFM
Finance Director
Financial Impact: $ as provided in plan Budgeted: Y/N X N Source: Various
Related Documents (CIP, ERP, etc.): ERP Notes:
ERP Background
• The city has established an equipment replacement
Elan that is reviewed and adjusted on an annual
asis.
• Theurpose of the plan was to smooth out the
funding of large pieces of equipment. This allowed
the City to avoidbonding for purchases thereby
saving interest costs.
• The purchase of the ladder truck in 2oo8 was the
first time a piece of equipment needed to be
financed. This truck will be paid off in 2o18.
• Equipment certificates are being sold this year to
fund equipment needs in 2013 and 2014.
Funding Equipment Replacement
The cost of equipment is allocated back to the
user departments based on life expectancy and
cost of the equipment.
z. A o% increase to the charge is planned for 2013.
Increases in the charge are planned for future
years.
ERP Future
Revenues in the Equipment Replacement fund are
derived from charges to city departments that use the
equipment - mainly the General Fund.
Cash flow projections are updated annually to ensure
adequate funds for scheduled replacements.
Funding challenges are foreseen in the future and
alternative options have been explored.
• Equipment Certificates for some 2013 & 2014 purchases
2
! Revenue, Capital Expenditures
and Cash Variances
(IN TW)uSnNOS)
1400
1200
i
1000
8L)o
G00
400
200
0
2010 2011 2012
i
I
II
kl Rr VFf I ue
Y(a1)1[al f XJ)"int
Cash
(
I I
2013 2014 2015 2016 2011
2013 ERP
• For 2013 the city is planning on replacing or
upgrading six vehicles and four pieces of
equipment.
• All vehicles and equipment are reviewed annually
and useful lives adjusted while maintaining the
integrity, reliability and safety of the vehicles,
equipment and employees.
• Purchases are made based upon the condition of
the equipment, not simply on the ERP Schedule.
I
City Hall Equipment
Annually the city replaces a portion of its obsolete
computers with newer technology.
• This includes both computers and servers in all city
departments
Fire Equipment
The fire department annually assess its fleet and adjusts
the useful lives of the equipment accordingly.
2oo8 Aerial Ladder Lease Payment
• io year lease at $54,217 annually
Items scheduled for replacement
• Thermal imaging camera
0
Police Equipment
Scheduled for replacement are
• One admin vehicle - unmarked
• Two squad cars
• Records manages
• Tactical ballistic,
• Tasers - 8
f
Public Works — Streets
One 4x4 3/4 ton truck with plow
• Regenerative sweeper
s -f ■■ NO. MG i
POW G�
I
Public Works —Parks/Forestry
• 1/2 ton pickup truck
• Truckster
• Brush Chipper
Arts Center
Catering kitchen equipment
Theater projector
R
Conclusion
• The Equipment Replacement Plan is a valuable tool
used to assess, plan and fund future equipment needs
of the City.
• In the past by annually evaluating equipment and
adjusting useful lives where practical, the city has been
able to maintain the reserves in this fund to cover
equipment.
• Beginning in 2013 and again in2017 this becomes a
challenge.
• Equipment certificates are being sold to finance some
of the equipment needs in2013-2014.
7
City of Hopkin
EQUIPMENT REPLACEMENT PLAN
2013-2017
F
City of q1opkins
1010 first Street South • Hopkins, � 55343-7573 • Phone: 952-935-8474 • fax.• 952-935-1834
Web address: u,,unv.hopkinsmn.corn
DATE: August 2012
TO: Honorable Mayor and Members of the City Council
FROM: Mike Mornson, City Manager
SUBJECT: 2013-2017 EQUIPMENT REPLACEMENT PLAN
With this letter, I respectfully submit the 2013-2017 Equipment Replacement Plan. This
five-year planning document represents the combined efforts of city staff and the City
Council.
The Equipment Replacement Plan is a five-year forecast of equipment replacement needs
in the City of Hopkins. It is intended to alert the Council and citizens of equipment
replacement needs that are needed to maintain the efficiency of city services and the
safety of city staff. The first year of the plan becomes the adopted budget, however the
equipment is again re-evaluated before final approval is given for the purchase. The
remaining four years represents estimated replacement needs and the related funding.
The Equipment Replacement Plan does not include proposed capital projects. A
document relating specifically to capital project needs has been developed into a separate
document.
The Equipment Replacement Plan is intended to serve as a planning tool and is therefore
structured to present a meaningful, long-range perspective of the city's equipment needs
over the next 20 years. At the same time sufficient details on individual pieces of
equipment scheduled for replacement is provided to enable those who review the
information to make informed decisions of the city's equipment needs over the next several
years.
Please use the information provided to assist in the understanding of the city's equipment
needs as they relate to the delivery of service to the citizens of Hopkins.
This document was developed by the Finance Department with the assistance of all city
departments. I wish to especially thank all those involved in the development of the
Equipment Replacement Plan, and especially Steve Stadler, Public Works Director, Mike
Reynolds, Police Chief, Connie Kurtz, Police Administrative Services Director, Dale
Specken, Fire Chief, Christine Harkess, Finance Director and Deb Dahlheimer, Sr.
Finance Clerk for their hard work and dedication.
Partnering with the Comnu rtity to Enhance the Quafity of Life
• lm.pire • Educate • Involve •Communicate •
1
EQUIPMENT REPLACEMENT PLAN
2013-2017
It0T7me] X016i i1:1aIK
Paqe
City Manager's Message
Table of Contents 2
Introduction
Background and Summary of Changes from 2012 Plan 4
Cash Flow Statements
Equipment Replacement Fund 9
Chart - Revenues, Expenditures & Working Capital 10
Five -Year Project Summaries
Projects by Year
12
Department Summary
15
Projects by Department
16
Funding Source Summary
19
Projects by Funding Source
20
Equipment Requests
Individual Equipment Request Details 24
Twenty Year Replacement Schedule
Twenty Year Replacement Schedule by Department 95
Equipment and Building Inventory
Vehicle and Equipment Inventory
Building Inventory
E
101
105
INTRODUCTION
EQUIPMENT REPLACEMENT PLAN 2013-2017
BACKGROUND AND SUMMARY OF CHANGES FROM 2012 PLAN
Backy,round
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
$ 845,400.
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. 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. Originally a 6 % increase was
planned for 2013, however due to budget constraints of the General Fund that absorbs the
majority of the charges at 99% of rates charged, we eliminated the increase scheduled for 2013.
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 61 % 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 2013 ERP. As discussed above we eliminated the rate increase for
2013, changed the scheduled increased for 2014-2017 to 9% each year and plan to sell
Equipment Certificates to fund some of the equipment needs scheduled for 2013 and 2014. This
will allow us to replace aging equipment and spread the payments over 10 years. While we have
the option to place the debt service requirements on the tax levy we have opted to included them
in the annual operating expenses of the Equipment Replacement Fund. If at any time the rates
are not adequate we do have the option of putting a portion or all of the debt service needs on the
tax levy. Currently it is not our intention to do so.
4
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 2012 Plan
Highlights of changes from last year's equipment replacement plan for the years 2013-2017:
Activity Center: There are no changes to Activity Center items in this ERP.
Arts Center: A theater projector was added in 2013 for $6,000. This unit will have
higher lumens and HDMI connectivity and will allow the unit to be
controlled from the control booth.
A community room audio visual unit was added in 2014 for $11,000.
This will be mounted from the ceiling and available for those renting
this space.
City Hall: Document scanners (3) were budgeted at $6,500 per year on a three
year rotation. The number was reduced to two and put on a five year
replacement schedule starting in 2015 at a cost of $11,300 for two.
Community Services: There are no changes to Community Services items in this ERP.
Fire: The air compressor was moved up from 2017 to 2016 at a cost of
524,900. The current unit is showing its age.
In 2016 self-contained breathing apparatus (SOBA) (45) was added to
the ERP at a cost of $250,000. The current units will have met their
mandated life expectancy and will need to be replaced. The Fire
Department was working on a grant for the SOBA"s, however that did
not work out so the item was added to the ERP. Staff is working on
purchasing these through a multi -jurisdictional agency that will
provide us with some savings over the amount budgeted in the ERP.
HRA There are no changes to HRA items in this ERP.
Pavilion: The ice resurfacer and edger were moved from 2014 to 2013 as these
items are being financed with the Equipment Certificates that are
being sold in 2012.
5
Parking: There are no changes to the Parking Dept. items in this ERP.
Police: Mobile Data Cameras scheduled for 2013 at a cost of $57,000 moved
to 2014.
Prior to 2013 the Taser's were not included in the ERP. They were
added in 2013 at a cost of $18,600 with a four year life to be replaced
again in 2017.
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
The engineering vehicle originally scheduled for 2013 was moved
back to 2014 and the cost reduced from $21,500 to $2,000. The police
Tahoe will be transferred to Engineering and there is minimal cost to
refurbish the vehicle for non -police use.
Parks/Forestry
After an analysis of the riding mowers the two riding mowers
scheduled for 2013 and 2014 were moved to 2014 and 2015 and the
cost on the one scheduled for 2014 was reduced from $22,800 to
$11,000 to purchase a zero turn mower rather than a Groundsmaster
and the one scheduled for 2015 was reduced from $30,600 to $20,000
eliminating one mower and accounting for the Groundsmaster. The
third mower was removed from the plan.
Streets/Traffic
After evaluation of the two 4x4 3/ ton pickup trucks in the ERP the
following changes were made:
A 4x4 3/ ton pickup with plow (ERP -0300) totaling $33,600
was moved from 2015 to 2013 and the cost reduced to $21,500.
A 4x4 3/ ton pickup with plow (ERP -0301) totaling $30,400
was moved from 2013 to 2015.
Due to new equipment in that is available in street sweeping the
following changes were made to the street sweeper replacement
program:
A mechanical sweeper scheduled for replacement in 2013 at a
cost of $156,400 was moved back to 2021 and will be replaced
every 20 years. This sweeper requires two people to operate,
6
one to drive the sweeper and one to drive a truck that the
material collected is dumped into for disposal. In addition this
sweeper needs water to wet the material that is picked up.
A regenerative sweeper was added in 2013 at a cost of
S 185,000 on a 20 -year replacement. This sweeper is a vacuum
type sweeper and is a more efficient machine in that it can be
used by a single person and uses no water.
Refuse
There are no changes to refuse department items in this ERP.
Water
There are no changes to water department items in this ERP.
Sewer
There are no changes to sewer department items in this ERP.
N
CASH FLOW STATEMENT
EQUIPMENT REPLACEMENT FUND (602)
(17/27/21112
Impact on General Fund
0
28,938
35,160
38,323
41,773
Rate Change
3°(,
5%
U°%,
8%
9010
9%
9%
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
2011
2012
2013
2014
2015
2016
2017
Working Capital Begin Year
921,831
890.189
1,364.161
898.102
668,938
515,342
45,149
Revenues from charges
302,012
317,113
317,113
342,482
373,305
406,902
443,524
Transfer in General Fund
50.000
511,000
50,000
Transfer In - Pavilion - Capital Lease
20.1100
20.000
15.609
Transfer In - Pavilion - Hockey Loan
3.143
3.143
3,143
3.142
Interest earnings
6.662
9.021
13.760
9J00
6,808
5.272
570
Other revenues (sale of assets)
42.343
199.462
25.000
30.000
30,000
30,000
30,000
Equipment Certificates (Bonds)
804.400
1,000,000
Total Revenues
374,160
1,353,138
374,625
434,723
460,113
492,175
1,474,094
Expenditures (excludes Depr.) (1)
23.995
18,250
18.798
19,361
19,942
20,541
21,157
Fire Truck Financing Pymnts (2009-2018)
53,874
54,217
54.217
54.217
54.217
54,217
54,217
Adj - Fire Quick Attach Pumper
245.000
Capital Outlay - Equipment
327,933
561,700
7113,31111
497,500
447,500
796,400
414,001
2012 Equip Certificate Pymnts (IOyr 3
64,370
92,810
92,050
91,210
95,290
Total Expenses
405,802
879,167
840,684
663,888
613,709
962,367
584,664
Working Capital Ending Balance
890,189
1,364,161
898,102
668,938
515,342
45,149
934,579
Actual/Estimated Cash balances
902,064
1,376,036
909,977
680,812
527,216
57,024
946,454
9
1,800,000
1,600,000
1,400,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
ERP - Revenues, Expenses and Working Capital
■ Total Revenues
■ Total Expenses
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
10
FIVE-YEAR
PROJECT SUMMARIES
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2013 thru 2017
PROJECTS BY YEAR
Project Name Department Project # Priority Project Cost
20�
Art Center Kitchen Catering Equipment
Arts Center
O1 -ERP -1102
n/a
5,000
Art Center Theater Projector
Arts Center
07 -ERP -7104
n/a
6,000
Network Server
City Hall Administration
01 -ERP -0003
n/a
8,000
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
Election Equipment
Community Services
01 -ERP -0011
n/a
50,000
Aerial Truck
Fire
07 -ERP -0106
n/a
54,217
Thermal Imaging Camera (2)
Fire
07 -ERP -0112
n/a
11,500
Ice Resurfacer
Pavilion
07 -ERP -1000
n/a
180,000
Electric Ice Edger
Pavilion
07 -ERP -7007
n/a
5,000
Marked Patrol Vehicles (6)
Police
07 -ERP -0200
n/a
71,200
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
29,600
LOG IS Computer System
Police
01 -ERP -0208
n/a
200,000
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Tactical Ballistic Vests
Police
01 -ERP -0214
n/a
23,200
Taser Replacement
Police
01 -ERP -0277
3
18,600
112 Ton Pickup Truck
Public Works: Parks/Forestry
07 -ERP -0800
n/a
26,400
Trucksters (3)
Public Works: Parks/Forestry
01 -ERP -0807
n/a
19,800
Brush Chipper
Public Works: Parks/Forestry
01 -ERP -0813
n/a
25,700
44 3/4 Ton Pickup with Plow
Public Works: Streets/Traffic
01 -ERP -0300
n/a
21,500
Regenerative Air Sweeper
Public Works: Streets/Traffic
07 -ERP -0379
n/a
185,000
Backhoe Loader
Water
07 -ERP -0502
n/a
75,000
Total for 2013 1,054,217
20�
Art Center Community Room Audio Visual
Arts Center
07 -ERP -1105
n/a
11,000
Network Server
City Hall Administration
01 -ERP -0003
n/a
8,000
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Automated External Defibrillator (2)
Fire
01 -ERP -0120
n/a
7,200
Workout Equipment - Dumb Bells
Fire
01 -ERP -0722
n/a
5,000
HRA Copier
HRA
07 -ERP -0401
n/a
13,000
Marked Patrol Vehicles (6)
Police
07 -ERP -0200
n/a
73,400
Utility 44 (unit 212)
Police
07 -ERP -0203
n/a
47,700
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
30,500
Logging Recorder
Police
07 -ERP -0270
n/a
36,900
Network Server (3)
Police
07 -ERP -0211
n/a
8,500
Mobile Data Computers
Police
07 -ERP -0212
n/a
62,700
Digital Squad Car Cameras
Police
07 -ERP -0273
n/a
53,400
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
Riding Mowers (2)
Public Works: Parks/Forestry
07 -ERP -0808
n/a
11,000
Roller
Public Works: Streets/Traffic
01 -ERP -0372
n/a
45,900
Asphalt Paver
Public Works: Streets/Traffic
01 -ERP -0314
n/a
48,800
Refuse Truck (Rear -L)
Refuse
07 -ERP -0901
n/a
101,600
lVedni sduv. Auguq 15. 20/2
12
Project Name Uepartntent Project # PrioritN Project Cost
44 3/4 Ton Truck Sewer 01 -ERP -0550 n/a 35,700
Total for 2014 718,717
20�
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
01 -ERP -0006
n/a
30,000
Document Management Scanner (2)
Community Services
01 -ERP -0008
n/a
11,300
Duty Chief Vehicle
Fire
01 -ERP -0103
n/a
37,000
Aerial Truck
Fire
01 -ERP -0706
n/a
54,217
Workout Equipment - Eliptical
Fire
07 -ERP -0116
n/a
5,800
Workout Equipment - Summit Trainer
Fire
01 -ERP -0117
n/a
5,800
Workout Equipment - Weight Lifting
Fire
01 -ERP -0719
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
75,600
Sergeant's Vehicle
Police
07 -ERP -0207
n/a
37,800
Police Administrative Vehicles (2)
Police
07 -ERP -0204
n/a
31,400
Police Services Liaison Vehicle
Police
01 -ERP -0206
n/a
25,000
Network Server (3)
Police
07 -ERP -0211
n/a
8,500
Riding Mowers (2)
Public Works: Parks/Forestry
07 -ERP -0808
n/a
20,000
4X4 3/4 Ton Truck with Plow
Public Works: Streets/Traffic
07 -ERP -0307
n/a
30,400
Sign Machine (Traffic)
Public Works: Streets/Traffic
07 -ERP -0317
n/a
13,400
Refuse Truck (RAP -R) (2)
Refuse
07 -ERP -0900
n/a
204,800
Total for 201; 726,817
2016
Network Server
City Hall Administration
01 -ERP -0003
n/a
8,000
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
Fire Utility Vehicle (Pick Up Truck)
Fire
01 -ERP -0705a
n/a
35,000
Aerial Truck
Fire
07 -ERP -0706
n/a
54,217
Air Compressor
Fire
01 -FRP -0107
n/a
34,900
Self Contained Breathing Apparatus (45)
Fire
01 -ERP -0108
n/a
250,000
Floor Scrubber
Fire
01 -ERP -0114
n/a
14,300
Marked Patrol Vehicles (6)
Police
07 -ERP -0200
n/a
77,800
Parking Enforcement Vehicle (Parking Fund)
Police
07 -ERP -0202
n/a
27,200
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
32,400
SWAT Vehicle
Police
07 -ERP -0205
n/a
30,000
Copy Machine - Police Dept
Police
01 -ERP -0209
n/a
22,100
Network Server (3)
Police
07 -ERP -0211
n/a
8,500
Tractor
Public Works: Parks/Forestry
07 -ERP -0806
n/a
49,300
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
Snow Blower
Public Works: Streets/Traffic
07 -ERP -0315
n/a
102,300
3/4 Ton Utility Truck
Sewer
01 -ERP -0557
n/a
33,600
Total for 2016 884,217
2017
Refrigerator/Freezer
Activity Center
01 -ERP -0031
n/a
1
Art Center Video Camera Updates
Arts Center
01 -ERP -1103
n/a
3,700
Network Server
City Hall Administration
07 -ERP -0003
n/a
8,000
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
Aerial Truck
Fire
01 -ERP -0706
n/a
54,217
Thermal Imaging Camera (2)
Fire
07 -ERP -0112
n/a
12,900
Workout Equipment - Treadmill
Fire
07 -ERP -0118
n/a
5,800
11ClIm i'Im, -111"ll't l?. _'01
13
Project Name Department Project # Priority Project Cost
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
80,200
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
33,300
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Taser Replacement
Police
01 -ERP -0217
3
20,900
Stump Cutter
Public Works: Parks/Forestry
01 -ERP -0812
n/a
21,200
Skid Loader
Public Works: Parks/Forestry
01 -ERP -0815
n/a
32,000
Water Truck
Public Works: Streets/Traffic
01 -ERP -0307
n/a
150,000
Striper
Public Works: Streets/Traffic
01 -ERP -0313
n/a
11,200
Generator (2)
Sewer
01 -ERP -0555
n/a
26,400
1/2 Ton Truck
Water
01 -ERP -0500
n/a
26,800
3/4 Ton Utility Truck
Water
01 -ERP -0501
n/a
34,900
Total for 2017
GRAND TOTAL
14
560,018
3,943,986
Wednesday, August 15, 2012
City of Hopkins, MN
EOLIPAIENT RF_PLAC'EILIENT PLAN
2013 thru 2017
DEPARTMENT SUMMARY
Department
2013
2014
2015
2016
2017
Total
Activity Center
1
1
Arts Center
11,000
11,000
3,700
25,700
City Hall Administration
38,000
38,000
127,600
38,000
38,000
279,600
Community Services
50,000
11,300
61,300
Fire
65,717
66,417
108,617
388,417
72,917
702,085
HRA
13,000
32,400
45,400
Pavilion
185,000
185,000
Police
351,100
313,100
178,300
198,000
142,900
1,183,400
Public Works: Engineering
2,000
2,000
Public Works: Parks/Forestry
71,900
43,200
20,000
82,000
53,200
270,300
Public Works: Streets/Traffic
206,500
94,700
43,800
144,200
161,200
650,400
Refuse
101,600
204,800
306,400
Sewer
35,700
33,600
26,400
95,700
Water
75,000
61,700
136,700
TOT.%L 1,054,217 718,717 726,817
884,217 560,018 3,943,986
15 ffrdursdai' 0, _'lil
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2013 thru 2017
PROJECTS BY DEPARTMENT
Department Project# Priority 2013 2014 2015 2016 2017 Total
Activity Center
Refrigerator/Freezer 01 -ERP -0031 n/a 1 1
Activity Center Total 1
Arts Center -�
Art Center Kitchen Catering Equipment
01 -ERP -1102
n/a
5,000
5,000
Art Center Video Camera Updates
01 -ERP -1103
n/a
3,700
3,700
Art Center Theater Projector
01 -ERP -1104
n/a
6,000
6,000
Art Center Community Room Audio Visual
01 -ERP -1705
n/a
11,000
11,000
Arts Center Total
11,000
11,000
3,700
25,700
City Hall Administration
Network Server
01 -ERP -0003
n/a
8,000
8,000
8,000
8,000
8,000
40,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
City Hall Administration Total
38,000
38,000
127,600
38,000
38,000
279,600
Community Services
Document Management Scanner (2)
01 -ERP -0008
n/a
11,300
11,300
Election Equipment
07 -ERP -0011
n/a
50,000
50,000
Community Services Total
50,000
11,300
61,300
Fire
Duty Chief Vehicle
01 -ERP -0103
n/a
37,000
37,000
Fire Utility Vehicle (Pick Up Truck)
07 -ERP -0705a
n/a
35,000
35,000
Aerial Truck
01 -ERP -0106
n/a
54,217
54,217
54,217
54,217
54,217
271,085
Air Compressor
07 -ERP -0107
n/a
34,900
34,900
Self Contained Breathing Apparatus (45)
07 -ERP -0708
n/a
250,000
250,000
Thermal Imaging Camera (2)
01 -ERP -0112
n/a
11,500
12,900
24,400
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 - Summit Trainer
07 -ERP -0117
n/a
5,800
5,800
Workout Equipment - Treadmill
01 -ERP -0778
n/a
5,800
5,800
Workout Equipment - Weight Lifting
01 -ERP -0119
n/a
5,800
5,800
Automated External Defibrillator (2)
07 -ERP -0720
n/a
7,200
7,200
Workout Equipment - Dumb Bells
07 -ERP -0122
n/a
5,000
5,000
Fire Total
IHRA
44 3/4 Ton Truck 01 -ERP -0400 n/a
HRA Copier 07 -ERP -0401 n/a
65,717 66,417 108,617 388,417 72,917 702,085
32,400 32,400
13,000 73,000
16 Wednesdav, August 15, 2012
Department Project# Priority 2013 2014 2015 2016 2017 Total
HRA Total
Pavilion
Ice Resurfacer 07 -ERP -1000 n/a 180,000
Electric Ice Edger 01 -ERP -7007 n/a 5,000
Pavilion Total 185,000
Police
13,000 32,400 45,400
Marked Patrol Vehicles (6)
07 -ERP -0200
n/a
71,200 73,400 75,600
77,800 80,200
Sergeants Vehicle
01 -ERP -0201
n/a
37,800
01 -ERP -0270
Parking Enforcement Vehicle (Parking Fund)
01 -ERP -0202
n/a
01 -ERP -0271
27,200
Utility 44 (unit 212)
01 -ERP -0203
n/a
47,700
07 -ERP -0313
Police Administrative Vehicles (2)
01 -ERP -0204
n/a
29,600 30,500 31,400
32,400 33,300
SWAT Vehicle
01 -ERP -0205
n/a
Taser Replacement
30,000
Police Services Liaison Vehicle
07 -ERP -0206
n/a
25,000
LOGIS Computer System
07 -ERP -0208
n/a
200,000
Copy Machine - Police Dept
01 -ERP -0209
n/a
1,183,400
Logging Recorder
01 -ERP -0270
n/a
n/a
Network Server (3)
01 -ERP -0271
n/a
8,500
Mobile Data Computers
01 -ERP -0272
n/a
07 -ERP -0313
Digital Squad Car Cameras
07 -ERP -0213
n/a
2,000
Tactical Ballistic Vests
07 -ERP -0274
n/a
23,200
Taser Replacement
07 -ERP -0217
3
18,600
22,100
36,900
8.500 8,500 8,500 8,500
62,700
53,400
20,900
180,000
5.000
185,000
378,200
37,800
27,200
47,700
757,200
30,000
25,000
200,000
22,100
36,900
42,500
62,700
53,400
23,200
39,500
Police Total
351,100
313,100 178,300
198,000
142,900
1,183,400
Public Works: Engineering I
Water Truck
01 -ERP -0307
n/a
Skid Loader (2)
01 -ERP -0309
n/a
Roller
Engineering Van
01 -ERP -0700
n/a
07 -ERP -0313
2,000
Asphalt Paver
07 -ERP -0374
2,000
Public Works: Engineering Total
07 -ERP -0375
n/a
Sign Machine (Traffic)
2,000
n/a
Regenerative Air Sweeper
2,000
Public Works: Parks/Forestry
1/2 Ton Pickup Truck
01 -ERP -0800
n/a
26,400
26,400
3/4 Ton Utility Truck
01 -ERP -0802
n/a
32,200
32,200
Tractor
07 -ERP -0806
n/a
49,300
49,300
Trucksters (3)
07 -ERP -0807
n/a
19,800
19,800
Riding Mowers (2)
01 -ERP -0808
n/a
11,000 20,000
37,000
Slope Mower
01 -ERP -0809
n/a
32,700
32,700
Stump Cutter
01 -ERP -0872
n/a
21,200
27,200
Brush Chipper
01 -ERP -0873
n/a
25,700
25,700
Skid Loader
07 -ERP -0815
n/a
32,000
32,000
Public Works: Parks/Forestry Total
71,900
43,200 20,000
82,000
53,200
270,300
Public Works: Streets/Traffic
44 3/4 Ton Pickup with Plow
07 -ERP -0300
n/a 21,500
4X4 3/4 Ton Truck with Plow
01 -ERP -0307
n/a
Water Truck
01 -ERP -0307
n/a
Skid Loader (2)
01 -ERP -0309
n/a
Roller
07 -ERP -0372
n/a
Striper
07 -ERP -0313
n/a
Asphalt Paver
07 -ERP -0374
n/a
Snow Blower
07 -ERP -0375
n/a
Sign Machine (Traffic)
07 -ERP -0317
n/a
Regenerative Air Sweeper
07 -ERP -0319
n/a 185,000
27,500
30,400 30,400
150,000 750,000
41,900 41,900
45.900 45,900
11,200 11,200
48,800 48,800
102,300 702,300
13,400 73,400
185,000
17 11 c hwvdur. , lugucf 15. 2012
Department Project# Priority 2013 2014 2015 2016 2017 Total
Public Works: Streets/Traffic Total
206,500
94,700
43,800
144,200
161,200
650,400
Refuse
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
101,600
204,800
306,400
Sewer
44 3/4 Ton Truck
01 -ERP -0550
n/a
35,700
35,700
3/4 Ton Utility Truck
01 -ERP -0551
n/a
33,600
33,600
Generator (2)
01 -ERP -0555
n/a
26,400
26,400
Sewer Total
35,700
33,600
26,400
95,700
Water
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
Backhoe Loader
01 -ERP -0502
n/a
75,000
75,000
Water Total
75,000
61,700
136,700
GRAND TOTAL
1,054,217
718,717
726,817
884,217
560,018
3,943,986
18 11'ednesdav, August 15. 2012
If c,hicv. ay. , bou w l?. 21112
19
City of Hopkins, MN
EOUIPl1ENT REPI_AC'EMENT PLAN
2013 ,iffL, 2017
FUNDING SOURCE SUMMARY
Source
2013 2014 201.5
2016
2017
Total
AC - Arts Center Fund
11,000 11,000
3,700
25,700
Bonds/Lease
54,217 54,217 54,217
54,217
54,217
277,085
Equipment Replacement Fund
729,000 497,500 421,800
796,400
414,001
2,858,707
HRA - Housing and Redevelopment Authority
13,000 32,400
45,400
PA - Pavilion Fund
185,000
185,000
PKG - Parking Fund
5,700
5,700
RF - Refuse Fund
101,600 204,800
306,400
SF - Sanitary Sewer Fund
35,700 6,800
33.600
26.400
102,500
WF - Water Fund
75,000 6,800
61.700
743,500
GR:k1D TOTAL
1,054,217 718,717 726,817
884,217
560,018
3,943,986
If c,hicv. ay. , bou w l?. 21112
19
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2013 thru 2017
PROJECTS BY FUNDING SOURCE
Source Pro.iect# Priority 2013 2014 2015 2016 2017 Total
AC - Arts Center Fund
Art Center Kitchen Catering Equipment
01 -ERP -1102
n/a
5,000
5,000
Art Center Video Camera Updates
01 -ERP -1103
n/a
3,700
3,700
Art Center Theater Projector
07 -ERP -7704
n/a
6,000
6,000
Art Center Community Room Audio Visual
01 -ERP -7705
n/a
11,000
77,000
AC - Arts Center Fund Total
11,000
11,000
3,700
25,700
Bonds/Lease
Aerial Truck
01 -ERP -0106
n/a
54,217
54,217
54,217
54,217
54,217
271,085
Bonds/Lease Total
54,217
54,217
54,217
54,217
54,217
271,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
Computers
01 -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
11,300
11,300
Election Equipment
01 -ERP -0011
n/a
50,000
50,000
Refrigerator/Freezer
01 -ERP -0031
n/a
1
1
Duty Chief Vehicle
01 -ERP -0703
n/a
37,000
37,000
Fire Utility Vehicle (Pick Up Truck)
07 -ERP -0105a
n/a
35,000
35,000
Air Compressor
01 -ERP -0707
n/a
34,900
34,900
Self Contained Breathing Apparatus (45)
01 -ERP -0708
n/a
250,000
250,000
Thermal Imaging Camera (2)
01 -ERP -0712
n/a
11,500
12,900
24,400
Floor Scrubber
01 -ERP -0114
n/a
14,300
74,300
Workout Equipment - Eliptical
01 -ERP -0116
n/a
5,800
5,800
Workout Equipment - SummitTrainer
01 -ERP -0777
n/a
5,800
5,800
Workout Equipment - Treadmill
01 -ERP -0718
n/a
5,800
5,800
Workout Equipment - Weight Lifting
07 -ERP -0119
n/a
5,800
5,800
Automated External Defibrillator (2)
01 -ERP -0120
n/a
7,200
7,200
Workout Equipment - Dumb Bells
01 -ERP -0122
n/a
5,000
5,000
Marked Patrol Vehicles (6)
01 -ERP -0200
n/a
71,200
73,400
75,600
77,800
80,200
378,200
Sergeant's Vehicle
01 -ERP -0207
n/a
37,800
37,800
Parking Enforcement Vehicle (Parking Fund)
01 -ERP -0202
n/a
27,200
27,200
Utility 44 (unit 212)
01 -ERP -0203
n/a
47,700
47,700
Police Administrative Vehicles (2)
01 -ERP -0204
n/a
29,600
30,500
31,400
32,400
33,300
157,200
SWAT Vehicle
07 -ERP -0205
n/a
30,000
30,000
Police Services Liaison Vehicle
01 -ERP -0206
n/a
25,000
25,000
LOGIS Computer System
01 -ERP -0208
n/a
200,000
200,000
Copy Machine - Police Dept
01 -ERP -0209
n/a
22,100
22,100
Logging Recorder
01 -ERP -0210
n/a
36,900
36,900
Network Server (3)
01 -ERP -0211
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
Wednesdav, August 15. 20/2
20
Source Project# Priovil.N
2013
2014
2015
2016 2017
Total
Digital Squad Car Cameras
01-ERP-0273
n/a
53,400
53,400
Tactical Ballistic Vests
01-ERP-0214
n/a
23,200
23,200
Taser Replacement
01-ERP-0217
3
18,600
20,900
39,500
44 3/4 Ton Pickup with Plow
01-ERP-0300
n/a
21,500
21,500
4X4 3/4 Ton Truck with Plow
07-ERP-0301
n/a
30,400
30,400
Water Truck
07-ERP-0307
n/a
150,000
150,000
Skid Loader (2)
01-ERP-0309
n/a
41,900
41,900
Roller
07-ERP-0372
n/a
45,900
45,900
Striper
01-ERP-0373
n/a
11,200
11,200
Asphalt Paver
01-ERP-0374
n/a
48,800
48,800
Snow Blower
01-ERP-0315
n/a
102,300
102,300
Sign Machine (Traffic)
07-ERP-0317
n/a
13,400
13,400
Regenerative Air Sweeper
07-ERP-0319
n/a
185,000
185,000
Engineering Van
01-ERP-0700
n/a
2,000
2,000
1/2 Ton Pickup Truck
07-ERP-0800
n/a
26,400
26,400
3/4 Ton Utility Truck
07-ERP-0802
n/a
32,200
32,200
Tractor
07-ERP-0806
n/a
49,300
49,300
Trucksters (3)
01-ERP-0807
n/a
19,800
19,800
Riding Mowers (2)
01-ERP-0808
n/a
11,000
20,000
31,000
Slope Mower
07-ERP-0809
n/a
32,700
32,700
Stump Cutter
01-ERP-0812
n/a
21,200
21,200
Brush Chipper
01-ERP-0813
n/a
25,700
25,700
Skid Loader
01-ERP-0815
n/a
32,000
32,000
Equipment Replacement Fund Total
729,000
497,500
421,800
796,400 414,001
2,858,701
!IIRA - Housing and Redevelopment A
44 314 Ton Truck
07-ERP-0400
n/a
32,400
32,400
HRA Copier
07-ERP-0401
n/a
13,000
13,000
HRA - Housing and Redevelopment
13,000
32,400
45,400
Authority Total
PA - Pavilion Fund
IceResurfacer
07-ERP-7000
n/a
180,000
180,000
Electric Ice Edger
07-ERP-7007
n/a
5,000
5,000
PA - Pavilion Fund Total
185,000
185,000
jPKG - Parking Fund
Mobile Data Computers
07-ERP-0272
n/a
5,700
5,700
PKG - Parking Fund Total
5,700
5,700
RF - Refuse Fund
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
RF - Refuse Fund Total
101,600
204,800
306,400
SF - Sanitary Sewer Fund
Telephone System
07-ERP-0004
n/a
6,800
6,800
44 3/4 Ton Truck
07-ERP-0550
n/a
35,700
35,700
11 elur.
I11,gucl /5. '01
21
Source Project# Priority 2013 2014
2015
2016 2017
Total
3/4 Ton Utility Truck
01 -ERP -0551
n/a
33,600
33,600
Generator (2)
01 -ERP -0555
n/a
26,400
26,400
SF - Sanitary Sewer Fund Total
35,700
6,800
33,600 26,400
102,500
WF - Water Fund
Telephone System
01 -ERP -00 4
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
Backhoe Loader
01 -ERP -0502
n/a 75,000
75,000
WF - NVatcr Fund Total
75,000
6,800
61,700
143,50D
GRAND TOTAL 1,054,217 718,717 726,817 884,217 560,018 3,943,986
Wednesday, August 15, 2012
22
EQUIPMENT REQUESTS
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0003
Project Name Network Server
Future
Department City Hall Administration
Contact Finance Director/IT
Type
Equipment
Useful Life
1 year
Category
Equipment
Priority
n/a
Description I
Total Project Cost: $233,000
['he network server is the hub of the network. New computers are faster and more reliable.
Justification
4etworking allows user to share information that is stored in a single location, the network server. This is more efficient because the information
loes not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every
tser is working with the same data.
Prior
Expenditures
2013
2014
2015
2016
2017
Total
Future
F --8-1-,O-0-01
Equipment
8,000
8,000
8,000
8,000
8,000
40,000
112,000
Total
Prior
Total
Funding Sources
8,000
2013
8,000
2014
8,000
2015
8,000
2016
8,000
2017
40,000
Total
Total
Future
—81-,0-0-01
Equipment Replacement Fund
8,000
8,000
8,000
8,000
8,000
40,000
112,000
Total
Total
8,000
8,000
8,000
8,000
8,000
40,000
'Total
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
24
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 dire, 2017
City of Hopkins, MN
Project # 01 -ERP -0004
Project Name Telephone System
Future
Department
City Hall Adminisu-ation
Contact
IT Director
Type
Equipment
Useful Life
8 years
Category
Equipment
Priority
n'a
Description
Total Project Cost: $349,900
ncludes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions ser%ed by this system. Also
ncludes software for the PBX and \ oice mail s\ stems.
Justification
vlaking, receiving and routing telephone calls, storing \ oice mail messages, and providing telephone based information ser\ iccs (snow line etc.)
Prior Expenditures 2013
2014 2015 2016
2017 Total
Future
7-6-0,00-0-1 Equipment
89,600
89,600
200,300
Total Total
89,600
89,600
Total
Prior
Funding Sources 2013
2014 2015 2016
2017 Total
Future
F-76-0—.00-01
Equipment Replacement Fund
76,000
76,000
200,300
Total
SF - Sanitary Sewer Fund
6,800
6,800
Total
WF - Water Fund
6800
6,800
Total
89,600
89,600
Budget Impact/Other
Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015.
Estimate salvage/resale value on replaced item: $
25
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0006
Project Name Computers
Future
Department City Hall Administration
Contact Finance Director/IT
Type Equipment
Useful Life 3-5 years
Category Equipment
Priority n/a
Description Total Project Cost: $930,000
Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one
fund.
Justification
Fools enabling staff to perform job responsibilities efficiently and effectively.
Prior Expenditures
2013
2014
2015
2016
2017
Total
Future
F--36-0-,O-O-01 Equipment
30,000
30,000
30,000
30,000
30,000
150,000420,000
30,000
Total
Total 30,000
30,000
30,000
30,000
30,000
150,000
Total
Prior
Funding Sources
2013
2014
2015
2016
2017
Total
Future
360,000
Equipment Replacement Fund
30,000
30,000
30,000
30,000
30,000
150,000
420,000
Total
Total
30,000
30,000
30,000
30,000
30,000
150,000
Total
Budget Impact/Other
Variance from 20 year plan - none
3stimate salvage/resale value on replaced item: $-0-
26
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 /h, it 2017
City of Hopkins, MN
Project # 01 -ERP -0008
Project Name Document Management Scanner (2)
Future
Deparonew Community Services
(ontacl CityClcrk
1) pe
Equipment
t seful Life
3 years
CaIego ry
Equipment
Priorily
n
Description folal Proiccl Cost: $109,200
Large document (11" x17") scanner for document management and retention as well as general administrative use.
Two scanners replaced every three years. purchased t\+o scanners in 2012 at a cost of $10,315 - Look to replace in three years.
Scanners will be evaluated every three years for replacement. If scanners are \corking properly their life xvill be extended.
Justification
C LIITCIIt scanners were repaired mane times and are beyond end of life per IT. Excess time AA as spent by IT keeping the scanners working.
Prior Expenditures
23,300 Equipment
Total
2013 2014 2015 2016 2017 Total Future
11,300 11,300 74,600
Total 11,300 11,300 Total
Prior Funding Sources
F--23–,-30-01 Equipment Replacement Fund
Total Total
2013 2014 2015 2016 2017
11,300
11,300
Total
Future
11,300
74,600
11,300
Total
from 20 year plan - Two new scanners purchased in 2012 and will be replaced every three years. Previously scanners had been repaired.
salvage/resale value on replaced item: $500-$1,000
Il, la, vdm% August 15, 2012
27
EQUIPMENT REPLACEMENT PLAN 2013 ih?zt 2017
City of Hopkins, MN
Project # 01 -ERP -0011
Project Name Election Equipment
Future
Description
Replace election M-100 ballot scanners and ballot boxes. - 9 machines total.
Justification
k11 Hennepin County equipment is being replaced in 2013.
Department Community Services
Contact City Clerk
Type Equipment
Useful Life 10 years
Category Equipment
Priority n/a
Total Project Cost: $117,200
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 50,000 50,000 77,200
Total 50,000 50,000 Total
Funding Sources
2013 2014
2015 2016 2017 Total
Future
Equipment Replacement Fund
50,000
50,000
67,200
Total
50,000
50,000
Total
ariance from 20 year plan - New item.
stimate salvage/resale value on replaced item: $-0-
28
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 di tt 2017
City of Hopkins, MN
Project # 01 -ERP -0031
Project Name Refrigerator/Freezer
Future
Description
Commerical, stainless steel refrigerator and freezer.
Department Activity Center
Contact Facilities Director
1.% pe Equipment
l seful Life 30 years
Calcgor� Equipment
Prioritc n,a
Total Project Cost: $10,501
Justification
Cooling/freezing needed for programs or by use of the participants and their activities. Present unit was here when activity center opened in
1980. This unit was part of the old South Jr. High cafeteria kitchen. The unit continues to have problems due to the age of the unit.
Prior Expenditures
10,500 Equipment
Total
2013 2014 2015 2016 2017 Total
1 1
Total 1 1
Prior Funding Sources 2013 2014 2015 2016 2017 Total
10,500 Equipment Replacement Fund 1 1
Total Total 1 1
Variance from 20 year plan - Delayed indetinetly. \N,'ill use and repair as necessary.
Estimate salvage/resale value on replaced item: $-0-
tf Cdlli �dm. , 0 —'lel—'
29
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0103
Project Name Duty Chief Vehicle
Future
Department Fire
Contact Fire Chief
Type
Equipment
Useful Life
5 years
Category
Vehicles
Priority
n/a
Description Total Project Cost: $254,200
A marked passenger vehicle for use by the Duty Chief and Assistant Chiefs in transporting required equipment, reference materials and personnel
for emergency response, and routine Fire Department business.
vehicles: 2010 Chevrolet Tahoe (#110) (Chief)
2006 Dodge Durango (#100) (Asst. Chief)
2003 Chevrolet Imnala (#101) (Asst. Chief) to be replaced with 201
Justification
Jsed by the Fire Chief and Asst. Chiefs when responding to fires and other emergencies. Used for official business in and out of the city and for
ire fighter travel on official Fire Department business.
Eventually 3 SUV's - replaced every 5 years with 15 year life. New - chief, cycle down to Asst. Chief 1 and Asst. Chief 2.
Prior Expenditures
64,500 Vehicles
Total
2013 2014 2015 2016 2017 Total Future
37,000 37,000 152,700
Total 37,000 37,000 Total
Prior Funding Sources 2013
2014 2015 2016
2017 Total
Future
64,500 Equipment Replacement Fund
37,000
37,000
1527700
Total Total
37,000
37,000
Total
ariance from 20 year plan - Add 2 vehicles and change life to 15 years.
stimate salvage/resale value on replaced item: $4,000
Wednesday, August 15, 2012
30
EQUIPMENT REPLACEMENT PLAN 2013 diru 2017
City of Hopkins, MN
Project # 01 -ERP -0105a
Project Name Fire Utility Vehicle (Pick Up Truck)
Future
Description
4 pickup truck on a 4 wheel drive chassis.
Department
Fire
Contact
Fire Chief
"cpe
Equipment
t'seful Life
5 years
Category
Vehicles
Priorit.
n/a
Total Project Cost: $177,100
Current ychicle: 1998 Chevrolet Lumina (#106) - used by Firc Inspector
Justification
With getting rid of our light rescue, we will be losing a way to haul equipment back and forth from the fire scene to the station. This vehicle would
be used to haul equipment and personnel to and from the scene and can be used for people to go to schools.
Expenditures 2013 2014 2015 2016 2017 Total Future
Vehicles 35,000 35,000 142,100
Total 35,000 35,000 Total
Funding Sources 2013
2014 2015 2016 2017
Total
Future
Equipment Replacement Fund
35,000
35,000
142,100
Total
35,000
35,000
Total
Budget Impact/Other
Variance from 20 year plan - Change from 10 year life to 5 years.
Estimate of salvage/resale value on replace item - $
31
It,(Im'nlur..15. 2111_'
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0106
Project Name Aerial Truck
Future
Department Fire
Contact Fire Chief
Type
Equipment
Useful Life
20 years
Category
Vehicles
Priority
n/a
Description I
Total Project Cost: $2,559,597
One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on
2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23.
Current vehicle: 2008 Pierce Arrow XT Aerial Ladder (#1
Justification
Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using $445,427.08 in ERP cash and
a 10 -year capital lease of $425,000. At the end of the lease term payments (P&I) will total $542,170. Total costs of aerial including cash
payments equals $987,597.
Prior
Expenditures
2013
2014
2015
2016
2017
Total
Future
662,295
Equipment
54,217
54,217
54,217
54,217
54,217
271,085
1,626,217
Total
Prior
Funding Sources
Total 54,217
2013
54,217
2014
54,217
2015
54,217
2016
54,217
2017
271,085
Total
Total
Future
662,295
Bonds/Lease
54,217
54,217
54,217
54,217
54,217
271,085
1,626,217
Total
Total 54,217
54,217
54,217
54,217
54,217
271,085
Total
Budget Impact/Other
Variance from 20 year plan - .Lease payments on financing added to the plan.
Estimate salvage/resale value on replaced item: $
Wednesday, August 15, 2012
32
EQUIPMENT REPLACEMENT PLAN 2013 r/„ t, 2017
City of Hopkins, MN
Project # 01 -ERP -0107
Project Name Air Compressor
Future
Description
Justification
Department Fire
Contact Fire Chief
I'.% pe Equipment
t seful Life 15 years
Calcgor� Equipment
Priorio n%a
Total Project Cost: $89,300
Expenditures 2013
2014 2015 2016 2017
Total
Future
Equipment
34,900
34,900
54,400
Total
34,900
34,900
Total
Funding Sources 2013
2014 2015 2016 2017
Total
Future
Equipment Replacement Fund
34,900
34,900
54,400
Total
34,900
34,900
Total
Budget Impact/Other
Variance from 20 year plan - nus% c back to 2017
Estimate salvage/resale value on replaced item - S
Purchased: 1996
33
If CtInesdu.c.. fu,gmvl 15. 2012
EQUIPMENT REPLACEMENT PLAN 2013 1hru 2017
City of Hopkins, MN
Project # 01 -ERP -0108
Project Name Self Contained Breathing Apparatus (45)
Future
Description
3reathing apparatus for interior firefighting for firefighters.
Department Fire
Contact Fire Chief
Type Equipment
Useful Life 10 years
Category Equipment
Priority n/a
Total Project Cost: $752,000
Justification
The breathing apparatus was taken out of the ERP in 2006 because we thought we were getting a grant. Grant was not successful. The SCBA's
(45) need to be replaced because they are at the end of their life and cannot be hydro tested any longer.
Prior Expenditures
166,000 Equipment
Total
2013 2014 2015 2016 2017
250,000
Total 250,000
Total
Future
250,000
336,000
250,000
Total
Prior Funding Sources 2013
2014 2015 2016 2017
Total
Future
166,000 Equipment Replacement Fund
250,000
250,000
336,000
Total Total
250,000
250,000
Total
Budget Impact/Other
Variance from 20 year plan - New item.
Estimate salvage/resale value on replaced item: $
34
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 diri, 2017
City of Hopkins, MN
Project # 01 -ERP -0112
Project Name Thermal Imaging Camera (2)
Future
Departnu•nt Fire
Contact Fire Chief
'I ape Equipment
I whil Life 10 years
( ategorc Equipment
Prioritc n.a
Dotal Project Cost: $72,200
Used by our fire companies to locate \ ictims trapped in a smoke tilled building. It helps us determine where fire and heat may be hidden allowing
for faster extinguishment.
Note: purchased 2003 & 2007
Justification
Current camera is ten years old and has been through many hot tires and needs to be replaced. Current camera was purchased with donation
Prior Expenditures
15,000 Equipment
Total
2013 2014 2015 2016 2017 Total Future
11,500 _ 12,900 24,400 32,800
Total 11,500 12,900 24,400 'Dotal
Prior
Funding Sources
2013 2014
2015 2016 2017
Total
Future
15,000
Equipment Replacement Fund
11,500
12,900
24,400
32,800
Total
Total
11,500
12,900
24,400
1'oUtl
Budget Impact/Other
Jariance from 20 year plan - departmmtit owns 2 cameras. PrcX iously one one "as included in the replacement plan. This will add to the
eplacement schedule the camera purchased from the Fire Dept budget in 2003.
?stimate salvage/resale value on repalced item: $-0-
I1rdlwdm. .lui yt l?. 012
35
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0114
Project Name Floor Scrubber
Future
Description
-loor scrubber to keep apparatus floors clean.
Current equipment: 2004 Tennant 5400
Justification
Scrubber is used to keep apparatus floors clean so that floor will last longer.
Department
Fire
Contact
Fire Chief
Type
Equipment
Useful Life
12 years
Category
Equipment
Priority
n/a
Total Project Cost: $34,600
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 14,300 14,300 20,300
Total 14,300 14,300 Total
Funding Sources 2013
2014 2015 2016 2017
Total
Future
Equipment Replacement Fund
14,300
14,300
20,300
Total
14,300
14,300
Total
Budget Impact/Other
Variance from 20 year plan - Eliminate sweeper and add $ to scrubber as scrubber is used more.
Estimate salvage/resale value on replaced item: $
Wednesday, August 15, 2012
36
EQUIPMENT REPLACEMENT PLAN 2013 /hru 2017
Department Fire
City of Hopkins, MN Contact FireChien
Project # 01 -ERP -0116 I'> pe Equipment
t seful Life 6 years
Project Name workout - Equipment Eli tical
P (atexon Equipment
Future Priorih n/a
Description
total Project Cost: $20,300
Workout equipment used in Fire Department workout room. One clipticnl machine replaced on a 6 year cycle, one every 3 years.
Justification
Fhis equipment is available to all City employees for health and v%clIncss.
Expenditures
Equipment
Total
Funding Sources
Equipment Replacement Fund
Total
2013 2014
2013 2014
2015 2016 2017
5,800
5,800
2015 2016 2017
5,800
5,800
Total Future
5,800
14,500
5,800
Total
Total
Future
5,800
14,500
5,800
Total
Budget Impact/Other
Variance from 20 year plan -had tsso clipticnl machines in the ERP. Otic vvas replaced along with the stairmaster with a summit trainer. The
remaining eliptical is scheduled for replacement in 2015.
Estimate salvage/resale value on replaced item: $
II rdn, "J,n. 0. _'lil_'
37
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0117
Project Name workout Equipment - Summit Trainer
Future
Description
Workout equipment used in Fire Department workout room.
One summit trainer replaced on a 5 year cycle.
lCurrent equipment : 2010 Summit Traincr
Justification
This equipment is available to all City employees for health and wellness.
Department
Fire
Contact
Fire Chief
Type
Equipment
Useful Life
5 years
Category
Equipment
Priority
n/a
Total Project Cost: $34,300
Prior
Expenditures 2013 2014
2015 2016
2017 Total
Future
5,000
Equipment
5,800
5,800F----23,-5700
Total
Prior
Total
Funding Sources 2013 2014
5,800
2015 2016
5,800
2017 Total
Total
Future
5,000
Equipment Replacement Fund
5,800
5,800
23,500
Total
Total
5,800
5,800
Total
Budget Impact/Other
✓ariance from 20 year plan - replaces stairmaster.
3stimate salvage/resale value on replaced item: $
38
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 diri, 2017
City of Hopkins, MN
Project # 01 -ERP -0118
Project Name workout Equipment - Treadmill
Future
Description
Norkout equipment used in the Fire Department workout room.
)ne treadmill replaced on a 5 year cycle.
Justification
Chis equipment is available to all City employees for health and wellncss.
Department Fite
Contact Fire Chief
I.N pe
Equipment
I seful Life
5 years
Catcgon
Equipment
Priorith
n/a
total Project Cost: $25,300
Prior
Expenditures 2013
2014 2015 2016 2017
Total
Future
5,000
Equipment
5,800
5,800
14,500
Total
Total
5,800
5,800
Total
Prior
Funding Sources 2013
2014 2015 2016 2017
Total
Future
.F ----5—,O-00-1
Equipment Replacement Fund
5,800
5,800
14,500
Total
Total
5,800
5,800
Total
Budget Impact/Other
Variance from 20 year plan - mov'e back one year from 2() 11 to 2012.
Estimate salvage/resale value on replaced item: $
39
11 cdm vda r.:1 qL us! /5. 21112
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0119
Project Name Workout Equipment - Weight Lifting
Future
machine - weight lifting machine.
Department Fire
Contact Fire Chief
Type
Equipment
Useful Life
5 years
Category
Equipment
Priority
n/a
Total Project Cost: $29,300
use by Police, Fire, Public Works, City staff to keep in shape to perform job duties and stay healthy. Current machine will be 7 years old in
2. Suggested replacement is every 5 years.
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 5,800 5,800 23,500
Total 5,800 5,800 Total
Sources 2013 2014 2015 2016 2017 Total Future
Replacement Fund 5,800 5,800 23,500
Total 5,800 5,800 Total
Variance from 20 year plan - move back from 2011 to 2015
Estimate salvage/resale value on replaced items: $
40
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 lett a 2017
City of Hopkins, MN
Project # 01 -ERP -0120
Project Name Automated External Defibrillator (2)
Future
Description
Defibrillator is used to help get someones heart restarted during a cardiac arrest.
Own 2 - both are replaced at one time due to changing technology.
went equipment: 2010 - 4 AEDs
10 ERP had 2 AEDs schedule for replacement at $6,000. Four were purchased.
Justification
Alith changes in technology, the AED's should be replaced every four years.
"ost - $3,000 per unit
Departmenl Fire
(ontact Fire Chief
1.\ pe
Equipment
I seful Life
3 years
CaIego ry
Equipment
Priorit.N
n/a
Total Project Cost: $49,100
Prior
Expenditures 2013
2014 2015
2016 2017 Total
Future
F--6—,0-0-01
Equipment
7,200
7,200
35,900
Total
Total
7,200
7,200
Total
Prior
Funding Sources 2013
2014 2015
2016 2017 Total
Future
6,000
Equipment Replacement Fund
7,200
7,200
35,900
Total
Total
7,200
7,200
Total
Budget Impact/Other
Variance from 20 year plan - adjustment t}om 3 years to 4 years.
Estimate salvage/resale value on replaced item: $
41
11'cdncg1( r..lu qw 15. 20/3
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0122
Project Name workout Equipment - Dumb Bells
Future
Description
Norkout equipment used in Fire Department workout room.
Department Fire
Contact Fire Chief
Type Equipment
Useful Life 10 years
Category Equipment
Priority n/a
Total Project Cost: $11,700
Justification
'urrent dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead based plaint. This purchase
vould update our dumb bells to the current type fitness bells.
Expenditures 2013
2014 2015
2016 2017 Total
Future
Equipment
5,000
5,0006,700
Total
5,000
5,000
'rota)
Funding Sources 2013 2014 2015 2016 2017 Total Future
Equipment Replacement Fund 5,000 5,000 6,700
Total 5,000 5,000 Total
Budget Impact/Other
Variance from 20 year plan - Move back from 2012 to 2014.
Estimate salvage/resale value on replaced item: $
42
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 ihn, 2017
City of Hopkins, MN
Project # 01 -ERP -0200
Project Name Marked Patrol Vehicles (6)
Future
Department Police
Contact Police Chief
TN pe
Equipment
I seful Lite
3 years
Category
Vehicles
Priorih
wa
Description
Total Project Cost: $2,620,100
vlarked patrol vehicles used by patrol officers to respond to calls, enforce traffic law's and perfonn general patrol duties.
consists of 6 patrol vehicles - 5 marked, I unmarked.
vehicles: (3) 2011 Ford Crown Victorias, (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria
Justification
Set up and marking of police vehicles must conform to Minnesota lay\ and POST standards. Vehicles contain secure data and radio equipment for
routine and emergency operations. Vehicles contain secure seating for prisoner transport.
Prior Expenditures
—70-6,-90-0-1 Vehicles
Total
2013 2014 2015 2016 2017 Total Future
71,200 73,400 75,600 77,800 80,200 378,200 7535,000
Total 71,200 73,400 75,600 77,800 80,200 378,200 Total
Prior
Funding Sources
2013
2014
2015
2016
2017
Total
Future
706,900
Equipment Replacement Fund
71,200
73,400
75,600
77,800
80,200
378,200
1,535,000
Total
Total
71,200
73,400
75,600
77,800
80,200
378,200
Total
Budget Impact/Other
Variance from 20 year plan - Original replacement schedule was modified se%cral years ago during the LGA cuts. The proposed purchase schedule
is to realign the replacement of squads more c\ cnly.
Estimate salvage/resale value on replaced item: $4,000 each
It rdncsdn,r, .1ugim 15. 31112
43
EQUIPMENT REPLACEMENT PLAN 2013 Mrit 2017
City of Hopkins, MN
Project # 01 -ERP -0201
Project Name Sergeant's Vehicle
Future
Department
Police
Contact
Police Chief
Type
Equipment
Useful Life
4 years
Category
Vehicles
Priority
n/a
Description I
Total Project Cost: $276,400
Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
4 year rotation.
�urrent vehicle: 2011 Ford Crown Victoria
Justification
;et up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for
'outine and emergency operations. Vehicles contain secure seating for prisoner transport.
Prior Expenditures
33,600 Vehicles
Total
2013 2014 2015 2016 2017
37,800
Total 37,800
Total Future
37,800 205,000
37,800 "I'otal
Prior Funding Sources 2013
2014 2015 2016
2017 Total
Future
F--3-3—,6-0-01 Equipment Replacement Fund
37,800
37,800
205,000
Total Total
37,800
37,800
Total
ariance from 20 year plan - none.
3timate salvage/resale value on replaced item: $3,500 each
44
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 lhrlt 2017
City of Hopkins, MN
Project # 01 -ERP -0202
Project Name Parking Enforcement Vehicle (Parking Fund)
Future
Description
'arkinQ enforcement vehicle.
DeparlUucnt
Police
Contact
Police Chief
Tape
Equipment
I %eful Life
10 years
C:Ucgorn
Vehicles
Priorilc
n/a
Total Project Cost: $82,500
Current vehicle: 2006 Jeep Liberty (#211)
Justification
Use by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown arca.
Prior
Expenditures 2013
2014 2015 2016 2017
Total
Future
18,70(1
Vehicles
27,200
27,200
F 36,600
Total
Total
27,200
27,200
Total
Prior
Funding Sources 2013
2014 2015 2016 2017
Total
Future
18,700 1
Equipment Replacement Fund
27,200
27,200
36,600
Total
Total
27,200
27,200
Total
Budget Impact/Other
✓ariance from 20 year plan - amount allocated is not sufficient. Increase to $27 200.
?stimate salvage/resale value on replaced item: $1.500
P'rdnesdaY.. higim 15. 1013
45
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0203
Project Name Utility 4x4 (unit 212)
Future
Description
I wheel drive uitility vehicle.
Department Police
Contact Police Chief
Type
Equipment
Useful Life
6 years
Category
Vehicles
Priority
n/a
Total Project Cost: $333,700
lC'urrent vehicle: 2008 Chevrolet Tahoe (#212)
Justification
Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals, prisoners and equipment. The 4 wheel
drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme snow conditions.
Prior Expenditures 2013
2014 2015
2016 2017 Total
Future
67,400 Vehicles
47,700
47,700
218,600
Total Total
47,700
47,700
Total
Prior Funding Sources 2013
2014 2015
2016 2017 Total
Future
67,400 Equipment Replacement Fund
47,700
47,700
218,600
Total Total
47,700
47,700
Total
Budget Impact/Other
Variance from 20 year plan - none.
Estimate salvage/resale value on replaced item: $5,000
46
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 lath 2017
City of Hopkins, MN
Project # 01 -ERP -0204
Project Name Police Administrative Vehicles (2)
Future
Description
Police administrative and detective \ chicles.
Replace Chiefs vehicle - even numbered years
Replace Captain's vehicle - odd numbered years
Department Police
Contact Police Chid
1'1% pe
Equipment
I seful Life
2 years
('alegory
Vehicles
Priority
nia
Total Project Cost: $1,065,300
lCurrent vehicles: 2013 Ford Taurus, 2011 Ford Taurus (#216)
Justification
Unmarked vehicles, equipped with radios, siren and rcd grille lites used by chief and captain. Staff use is for two years. Vehicles are then rotated
down to detectives and are kept for an additional 3-4 years. Vehicles are also used for sur\cillance by uniform and plain clothes officers.
Prior Expenditures
2013
2014
2015
2016
2017
Total
Future
269700 Vehicles
29,600
30,500
31,400
32,400
33,300
157,200
639,000
Total
Total 29,600
30,500
31,400
32,400
33,300
157,200
Total
Prior
Funding Sources
2013
2014
2015
2016
2017
Total
Future
F--269—,10-01
Equipment Replacement Fund
29,600
30,500
31,400
32,400
33,300
157,200
639,000
Total
Total
29,600
30,500
31,400
32,400
33,300
157,200
Total
Budget Impact/Other
✓ariance from 20 year plan - none
3stimate salvage/resale value on replaced item: $4,000 each
47
11'edmwsdu.r. Auguvl 15. 2012
EQUIPMENT REPLACEMENT PLAN 2013 1hni 2017
City of Hopkins, MN
Project # 01 -ERP -0205
Project Name SWAT Vehicle
Future
Description ,
Jnmarked van to transport police tactics team for high risk calls, training and mutual aid.
MAT - Special Weapons And Tatics
Current vehicle: 1998 Chevrolet Cube Van (#240)
Justification 71
Previous vehicle (15 years old) was a safety hazard and was replaced in 2005.
Department
Police
Contact
Police Chief
Type
Equipment
Useful Life
15 years
Category
Vehicles
Priority
n/a
Total Project Cost: $76,700
Expenditures 2013 2014 2015 2016 2017 Total Future
Vehicles 30,000 30,000 F 46,700
Total 30,000 30,000 Total
Funding Sources 2013
2014 2015 2016 2017
Total
Future
Equipment Replacement Fund
30,000
30,000
47,700
Total
30,000
30,000
Total
from 20 year plan - extended life from 10 to 15 years
salvage/resale value on replaced item: $3,000
48
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 do it 2017
City of Hopkins, MN
Project # 01 -ERP -0206
Project Name Police Services Liaison Vehicle
Future
Deparuucnt Police
Contact Police Chief
Type
Equipment
I seful Life
15 years
Category
Vehicles
Priorit%
Wa
Description Total Project Cost: $63,900
Used by Police Services Liaison,JCPP Liaison for transport to schools. neighborhood meetings, training and public relations events.
vehicle: 2001 Chrysler PT Cruiscr (#241)
Justification
!001 PT Cruiser was leased to the Police Department for a nominal fee and detailing and wheels vrerc also donated. The City purchased the
iehicle from the leasor in 2005.
Expenditures 2013 2014 2015 2016 2017 Total Future
Vehicles 25,000 25,000 F 38,900
Total 25,000 25,000 Total
Funding Sources 2013
2014 2015 2016
2017 "Total
Future
Equipment Replacement Fund
25,000
25,000
38,900
Total
25,000
25,000
Total
Budget Impact/Other
Variance from 20 year plan - extended lite from 10 to 15 years. Amount allocated is not sufticient. Increase to $25,000.
Estimate salvage/resale value on replaced item: $1.000
11 ,//1, i..lu,n'i l?. _'(1/'
49
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0208
Project Name LOGIS Computer System
Future
Description
Department Police
Contact Police Chief
Type
Equipment
Useful Life
20 years
Category
Equipment
Priority
n/a
Total Project Cost: $200,000
Computer system for records management and retention of Police Department in addition to computer aided dispatch (CAD) and mobile data
computer in squads.
Looking at the LOGIS RMS/CAD/Mobile system.
Computer system and maintenance -
Year 1 - $200,000 est to include software, licenses, implementation and training, data conversion, and network connectivity.
Year 2 - $95,800 - this is maintenance and should be budgeted in Dept budget
about a 10% increase each subsequent year
Year 2 throueh ?? Includes software/hardware sunnort in addition to builine reserves for future unerades
Justification
ro store, retrieve and transfer required data to State and perform data entry, inquiries of local, state and national crime databases.
Me LOGIS system will allow a greater sharing of data and records with 30+ communities for invesatigative purposes.
Expenditures 2013 2014 2015 2016 2017 'Total
Equipment 200,000 200,000
Total 200,000 200,000
Funding Sources 2013 2014 2015 2016 2017 Total
Equipment Replacement Fund 200,000 200,000
Total 200,000 200,000
ce from 20 year plan - Project was moved up from 2017 to allow greater ability to share information with other agencies in the system and
us the capability to potentially explore merging with another dispatch center.
to salvage/resale value on replaced item: $-0-
Wednesday, August 15, 2012
50
EQUIPMENT REPLACEMENT PLAN 2013 th a 2017
City of Hopkins, MN
Project # 01 -ERP -0209
Project Name Copy Machine - Police Dept
Future
Department Police
Contact Police Chief
"1'. pe
Equipment
1 sclul Life
5 years
Category
Equipment
Priorio
wa
CIpt10II
I ocal Project ('ost: $161,600
Department copy machine capable of producing double side copies and collating pages, color 13W, fax acapability and scan..
2011 Ricoh RMP C6501
Justification
Jsed to make duplicate copies of reports, letters, memos, etc., generated by police personnel, fax and scan..
Prior
Expenditures 2013
2014 2015 2016 2017
Total
Future
F---4-9—,80-01
Equipment
22,100
22,100
89,700
Total
Total
22,100
22,100
Total
Prior
Funding Sources 2013
2014 2015 2016 2017
Total
Future
49,800
Equipment Replacement Fund
22,100
22,100
89,700
Total
Total
22,100
22,100
Total
Budget Impact/Other
Jariance from 20 year plan - none
stimate salvage/resale value on replaced item: $1,000
51
If I , /j. ?U/?
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Department Police
Contact Police Chief
Project # 01 -ERP -0210 Type Equipment
Useful Life 7 years
Project Name Logging Recorder Category Equipment
p ment
� �
Future Priority n/a
Total Project Cost: $138,100
police logging recorder is a device which records all telephone and radio transmissions produced/received by the Police Department.
Current equipment: 2005 Mercom logging recorder system
Justification
Records all incoming/outgoing phone calls from the dispatch center and all radio transmissions from police, fire and interop radio talkgroups.
Equipment is necessary in case questions arise as to how calls for service or events were handled or dispatched.
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 36,900 36,900 101,200
Total 36,900 36,900 Total
Funding Sources 2013 2014 2015 2016 2017 Total Future
Replacement Fund 36,900 36,900 101,200
Total 36,900 36,900 Total
Budget Impact/Other
Variance from 20 year plan - none
3stimate salvage/resale value on replaced item: $-0-
52
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 1it1 tt 2017
City of Hopkins, MN
Project # 01 -ERP -0211
Project Name Network Server (3)
Future
Department Police
('outact Police Chief IT
-1-.% pe
Equipment
I seful Life
3 years
Category
Equipment
Priorits
n/a
Description Total Project Cost: $255,000
Computer servers store information and system programs.
One server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01 -ERP -213)
Justification
Annual replacement cycle allows development of system storage program. l.'sc of newer servers for heavy use programs while older servers used
for data storage.
Prior
Expenditures
2013
2014
2015
2016
2017
Total
Future
85,000
Equipment
8,500
8,500
8,500
8,500
8,500
42,500
127,500
Total
Total
Total 8,500
8,500
8,500
8,500
8,500
42,500
Total
Prior
Funding Sources
2013
2014
2015
2016
2017
Total
l, uture
85,000
Equipment Replacement Fund
8,500
8,500
8,500
8,500
8,500
42,500
127,500
Total
Total
8,500
8,500
8,500
8,500
8,500
42,500
Total
Budget Impact/Other
Variance from 20 year plan - Cost stabilized at `}:8,500 per \ ear.
Estimate salvage/resale value on replaced item - $
53
li rdn( sdal. Jmwuv l5 -'0/2
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0212
Project Name Mobile Data Computers
Future
Department
Police
Contact
Police Chief
Type
Equipment
Useful Life
5 years
Category
Equipment
Priority
n/a
escription771 Total Project Cost: $297,800
7bile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various databases, communicate car
car.
I I - 2007 Panasonic Lav T
Justification
_imited life of 5 years - replacement necessary.
Prior Expenditures
47,000 Equipment
Total
2013 2014 2015 2016 2017 Total Future
62,700 62,700 188,100
Total 62,700 62,700 Total
Prior Funding Sources 2013 2014 2015 2016 2017 Total Future
47,000 Equipment Replacement Fund 57,000 57,000 188,100
T..t.t PKG - Parking Fund 5,700 5,700 Tnta]
Total 62,700 62,700 - -
Budget Impact/Other
Variance from 20 year plan - ERP - Move back one year to 2014. All working - no problems.
Estimate salvage/resale value on replaced item: $-0-
Wednesday, August 15, 2012
54
EQUIPMENT REPLACEMENT PLAN 2013 ihru 2017
City of Hopkins, MN
Project # 01 -ERP -0213
Project Name Digital Squad Car Cameras
Future
Deparunew Police
Contact Police Chien
1) pe
Equipment
Useful life
5 years
Calegory
Equipment
Priorih
Wa
Description
Total Project Cost: $256,200
7igital video camera system in cath marked patrol car - used to document events in and out of the patrol car. httages downloaded to server for
;tora¢e and retrieval.
2009ICOP Model 20/20-W LIVE
Justification
'olive Dept. currently has ten digital camera units installed and a dedicated ser\'er. The life expectancy of the cameras is about five years. Current
;ameras were installed in September 2009.
�ost: 10 cameras @ $5,000 per unit plus tax - $53.430
1 server @ $15,000 (to be purchased from Police Network Scrvcr (01 -ERP -21 I )
annual allocation that carries forward.
stimated cost $53,430. Cost could be lower if, at the time of replacement, a suitable product is available through a State or County equipment
Prior
Expenditures 2013
2014 2015
2016 2017 Total
Future
42,600
Equipment
53,400
53,400
160,200
Total
Total
53,400
53,400
Total
Prior
Funding Sources 2013
2014 2015
2016 2017 Total
Future
42,600
Equipment Replacement Fund
53,400
53,400
160,200
Total
Total
53,400
53,400
Total
Budget Impact/Other
Variance from 20 year plan - Increase quantity to ten to cover all markedunnwrked patrol vchicles. Cost of cameras remains at $5,000 each plus
tax - $53,430.
Estimate salvage/resale value on replaced item:
II < dntdue.. higim 15, 21112
55
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0214
Project Name Tactical Ballistic Vests
Future
Department Police
Contact Police Chief
Type
Equipment
Useful Life
5 years
Category
Equipment
Priority
n/a
Total Project Cost: $137,500
Tactical ballistic vests worn by members of the Hopkins Police Department High-risk Entry and Assault Team (HEAT). These vests offer a higher
level of protection against weapon assault than the regular duty ballistic vest.
equipment: 11 - 2008 Titan Tactical Ballistic Vests
Federal and State grant monies have been available through the Ballistic Vest Program over the past several years. These grants only pay a portion
of the total cost of the vest, leaving the Police Department to pay the balance. There is no guarantee that these grants will be available in the future.
Warranty on the current vests expires in 2013.
Cost: 11 vests
Prior Expenditures 2013 2014 2015 2016 2017 Total Future
20,000 Equipment 23,200 23,200 94,300
Total Total 23,200 23,200 Total
Prior Funding Sources
2013 2014
2015 2016 2017 Total
Future
20,000 1 Equipment Replacement Fund
23,200
23,200
94,300
Total Total
23,200
23,200
Total
ariance from 20 year plan - Team membership has increased to 11.
stimate salvage/resale value on replaced item: $
56
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 to tt 2017
City of Hopkins, MN
Project # 01 -ERP -0217
Project Name Taser Replacement
Future
Department Police
Contact Police Captain
"1'ype
Equipment
I sefid Life
4 year's
Categoo
Equipment
Priorit.N
3 Important
Description
Total Project Cost: $119,300
[he police department will need to replace all of its X26 Tasers (ECD) Electronic Control Devices including all software and HD Camera systems
ind transition to the new X2 Tascrs.
Justification
rhe current Tasers will need to be replaced due to the age and use of the equipment.
Expenditures
2013 2014
2015 2016 2017
Total
Future
Equipment
18,600 _
20,900
39,500
79,800
Total
Total 18,600
20,900
39,500
Total
Funding Sources
2013 2014
201.5 2016 2017
Total
Future
Equipment Replacement Fund
18,600
20,900
39,500
79,800
Total
18,600
20,900
39,500
Total
Budget Impact/Other
Using the numbers obtained from Tasers Bob Lo%cring, the cost breaks down as sho%N n bclo\�
8 X2 Tasers
$7,600.00
8 HD Cams
$3,999.60
8 4yr Warranty/X2
$2,399.92
8 4yr Warranty/Cam
$1,199.96
6 Blade Tech Holsters
$ 359.70
56 Cartridges
$1,621.20
Download Kit
$ 14.95
Shipping
$ 120.00
Total
$17,315.33 (plus tax)
w/Tax est $18,575
57
11 -hi, day. Ix,Qtwl 15. 2012
EQUIPMENT REPLACEMENT PLAN 2013 Mm 2017
City of Hopkins, MN
Project # 01 -ERP -0300
Project Name 4x4 3/4 Ton Pickup with Plow
Future
Description
Pickup used by various divisions of Public Works.
Current vehicle: 1997 Chevrolet 3/4 Ton
Justification
Light hauling and transportation for supervisors. Maintenance garage service vehicle.
Department Public Works: Streets/Traffic
Contact Public Works Director
Type
Equipment
Useful Life
10 years
Category
Vehicles
Priority
n/a
Total Project Cost: $75,400
Prior Expenditures
2013 2014
2015 2016 2017 Total
Future
F-72-5,00-0-1 Vehicles
21,500
21,500
28,900
Total
Total 21,500
21,500
Total
Prior
Funding Sources
2013 2014
2015 2016 2017 Total
Future
25,000
Equipment Replacement Fund
21,500
21,500
F 28,900
Total
Total
21,500
21,500
Total
Budget Impact/Other
Variance from 20 year plan - Move up from 2015 to 2013. Replace with 1/2 ton 4x4 pickup. Reduce amount from 33,600 to 21,500..
Estimate salvage/resale value on replaced item: $1,500
Wednesday, August 15, 2012
58
EQUIPMENT REPLACEMENT PLAN 2013 ilirn 2017
City of Hopkins, MN
Project # 01 -ERP -0301
Project Name 4X4 3/4 Ton Truck with Plow
Future
Description
3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers.
lCurrent vehicle: 2006 Ford F250 (#302)
Justification
Light hauling, pulling trailers, transportation to and from job sites.
Prior Expenditures
F-72-4,50-01 Vehicles
Total
Department
Public Works: Streets'Tral7ic
Contact
Public Works Director
T) pe
Equipment
useful Life
8 years
('a1egor3
Vehicles
Priorit.N
n
Total Project ( ost: $141,700
2013 2014 2015 2016 2017
30,400
Total 30,400
Total
Future
30,400
87,300
30,400
Total
Prior
Funding Sources 2013
2014 2015 2016
2017 Total
Future
F-727,70-01
Equipment Replacement Fund
30,400
30,400
87,300
Total
Total
30,400
30,400
'Total
Budget Impact/Other
dariance from 20 year plan - Unit in good condition - more out 2 years.
Estimate salvage/resale value on replaced item: $1,500
59
Hi'dni'eclur. lt(i!ml l5. '01'
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0307
Project Name water Truck
Future
Description
Water truck used in Streets and Parks Division of Public Works.
JCurrent vehicle: 1995 Ford Water Truck (#316)
Justification
Used for street flushing, watering trees and plants, rink flooding and standby fire protection.
Department Public Works: Streets/Traffic
Contact Public Works Director
Type
Equipment
Useful Life
22 years
Category
Vehicles
Priority
n/a
Total Project Cost: $195,000
Prior Expenditures 2013 2014 2015 2016 2017 Total
45,000 Vehicles 150,000 150,000
Total Total 150,000 150,000
Prior Funding Sources 2013 2014 2015 2016 2017 Total
F-74-5—,00-01 Equipment Replacement Fund 150,000 150,000
Total Total 150,000 150,000
ariance from 20 year plan - replace tanker only in 2010 - replace tanker, cab & chassis in 2017, tanker only again in 2032 and entire vehicle in
)39. Change to a 22 year life.
stimate salvage/resale value on replaced item: $8,500
Wednesday, August 15, 2012
60
EQUIPMENT REPLACEMENT PLAN 2013 Mri, 2017
City of Hopkins, MN
Project # 01 -ERP -0309
Project Name Skid Loader (2)
Future
Loading trucks, landscape work, snoxN removal. material handling.
Department
Public Works: Streets Traffic
Contact
Public Works Director
ype
Equipment
I wful Lire
12 years
Category
Equipment
Priorh.N
n'a
Total Project Cost: $187,600
Current equipment: 2004 Bobcat S-1851 R Skid Loadcr 0324) & 2011 Bobcat S650 Skid -Steer Loadcr (#325)
Justification
Prior Expenditures
F-73-6,00-0-1 Equipment
Total
2013 2014 2015 2016 2017 Total Future
41,900 41,900 109,700
Total 41,900 41,900 Total
Prior
Funding Sources 2013
2014 2015 2016 2017
Total
Future
36,000
Equipment Replacement Fund
41,900
41,900109,700
Total
Total
41,900
41,900
Total
Budget Impact/Other
Jariance from 20 year plan - mox°c back from 2010 to 2011.
Estimate salvage/resale value on replaced item: $
a
IfethicsilaY. Augucl 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0312
Project Name Roller
Future
Used by Street Department for asphalt repair and resurfacing.
Current eauinment: 1989
Justification
Rand
Department Public Works: Streets/Traffic
Contact Public Works Director
Type Equipment
Useful Life 20 years
Category Equipment
Priority n/a
Total Project Cost: $45,900
Expenditures 2013 2014 2015 2016 2017 Total
Equipment 45,900 45,900
Total 45,900 45,900
Funding Sources 2013 2014 2015 2016 2017 Total
Equipment Replacement Fund 45,900 45,900
Total 45,900 45,900
ariance from 20 year plan - Move back from 2012 to 2014.
stimate salvage/resale value on replaced item: $
62
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 Ii,l it 2017
City of Hopkins, MN
Project # 01 -ERP -0313
Project Name Striper
Future
Description
eine striper.
1993 Line Striper A1990 (#352)
Justification
Department Public Works: Streets Traffic
Contact Public Works Director
Type Equipment
t whil Life 12 years
Categorc Equipment
Priority ria
Total Project Cost: $27,200
Expenditures 2013
2014 2015 2016 2017
Total
Future
Equipment
11,200
11,20016,000
F 16,000
Total
11,200
11,200
Total
Funding Sources 2013
2014 2015 2016 2017
Total
Future
Equipment Replacement Fund
11,200
11,200
F 16,000
Total
11,200
11,200
Total
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
63
Ilul�a��hn. liwu,[ l�. 1n1'
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0314
Project Name Asphalt Paver
Future
Description
ksphalt paver used by Streets Division of Public Works.
urrent equipment: 1994
Justification
Paving streets and parking lots.
illar AD200B Paver
Department Public Works: Streets/Traffic
Contact Public Works Director
Type Equipment
Useful Life 20 years
Category Equipment
Priority n/a
Total Project Cost: $48,800
Expenditures 2013 2014 2015 2016 2017 Total
Equipment 48,800 48,800
Total 48,800 48,800
Funding Sources 2013 2014 2015 2016 2017 Total
Equipment Replacement Fund 48,800 48,800
Total 48,800 48,800
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $500
64
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 th tt 2017
City of Hopkins, MN
Project # 01 -ERP -0315
Project Name Snow Blower
Future
Description
Snow blower used by the Streets Di\ision of Public Work,.
1996 SnoGo WK800 (#344
Justification
3lowing and loading snow off Mainstrect into trucks.
Department Public Works: Streets%Traffic
Contact Public Works Director
Type Equipment
t seful Life 20 year's
( ategor� Equipment
Priorits wa
Total Project Cost: $102,300
Expenditures 2013 2014 2015 2016 2017 Total
Equipment 102,300 102,300
Total 102,300 102,300
Funding Sources 2013 2014 2015 2016 2017 "Total
Equipment Replacement Fund 102,300 102,300
Total 102,300 102,300
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $4,500
MW
It( (/11( V11111. iu,ll1w 15, ?lll
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0317
Project Name Sign Machine (Traffic)
Future
Department
Public Works: Streets/Traffic
Contact
Public Works Director
Type
Equipment
Useful Life
10 years
Category
Equipment
Priority
n/a
Description Total Project Cost: $31,500
dahcine used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city use.
2005 Signcad Sign Making System (#353)
Justification
3xisting machine is not repairable and needs updating/
Expenditures
Equipment
2013 2014 2015 2016 2017
13,400
Total 13,400
Total Future
13,400 18,100
13,400 Total
Funding Sources 2013 2014 2015 2016 2017 Total Future
Equipment Replacement Fund 13,400 13,400 F 18,100
Total 13,400 13,400 Total
Budget Impact/Other
Variance from 20 year plan - new
Estimate salvage/resale value on replaced item: $-0-
66
Wednesday, August 15, 2011
EQUIPMENT REPLACEMENT PLAN 2013 thrit 2017
City of Hopkins, MN
Project # 01 -ERP -0319
Project Name Regenerative Air Sweeper
Future
Department Public Works: Streels'Traffic
Contact Public Works Director
l}pe
Equipment
I seful Life
20 years
( ategorc
Equipment
Priorit.
n it
Description
Molal Project Cost: $185,0011
phe City currently utilizes an Elgin Pclican Mechanical Sokeeper (01 -ERP -31 I ). This type of sweeper is for heavy spring sweeps and is labor
ntensive due to the need for a water truck and dump truck to assist during its use. The proposed sweeper is a \ acuum type sweeper that
.,generates its air to vacuum up dirt and debris. The vacuum is effective in its ability to pick up even the smallest of dirt without the use of pre -
,vetting . It is also a truck type unit so it can be used by one operator to drive to a dump site to empty the sweepings without the need of a separate
Jump truck.
Justification
rhe existing sweeper that was due for replacement in 2013 for $156.400 will be num ed out to 2021 and scheduled e\ crV m cnt\ \curs. The new
nachine will also be a 20 year machine and budgeted at $185,000. The reduced usage by having two machines will allow us to keep both for a
onger time and allow us more flexibility on different types of sweeping and reduce the labor needed to perform this duty.
Expenditures
2013 2014
2015 2016 2017 Total
Equipment
185.000
185,000
Total
Funding Sources
185,000
2013 2014
185,000
2015 2016 2017 Total
Equipment Replacement Fund
185,000
185,000
Total
185,000
185,000
Budget Impact/Other I
Variance from 20 year plan - New item.
Estimate salvage/resale value one replaced item: $
67
Ilr<hn'dm. lrt,n't 15'01,
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0400
Project Name 4x4 3/4 Ton Truck
Future
Department HRA
Contact Unassigned
Type
Equipment
Useful Life
8 years
Category
Vehicles
Priority
n/a
Description Total Project Cost: $148,400
1 wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snowplow.
Current vehicle: 2007 Chevrolet
Justification
for Public Housing Superintendent and snow plowing at various HRA properties around the city.
Prior Expenditures 2013 2014
2015 2016
2017 Total
Future
F-72-2,50-01 Vehicles
32,400
32,400
F 93,200
Total Total
32,400
32,400
Total
Prior Funding Sources 2013
2014 2015 2016
2017 Total
Future
22,800 HRA - Housing and Redevelop
32,400
32,400
93,200
Total Total
32,400
32,400
Total
Budget hnpact/Other
Jariance from 20 year plan - none
?stimate salvage/resale value on replaced item: $1,800
68
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 Ihru 2017
City of Hopkins, MN
Project # 01 -ERP -0401
Project Name HRA Copier
Future
Deparlinent HRA
( ontael Finance Director
1) pe
Equipment
I setul Life
8 years
CaIegor�
Equipment
Priorits
n a
Description
Dotal Project Cost: $50,400
�olor copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks.
istics ZB35
Justification
daily use to make copies of correspondence, forms and rental documents. Periodically produce documents such as resident newsletters and
narketing. Machine will duplex, sort, collate and staple copies.
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 13,000 13,000 F 37,400
Total 13,000 13,000 Total
Funding Sources 2013 2014 2015 2016 2017 Total Future
HRA - Housing and Redevelop 13,000 13,000 37,400
Total 13,000 13,000 Total
Budget Impact/Other
Jariance from 20 year plan - New item.
3stimate salvage/resale value on replace item: $ - 0 -
69
It ,//I, da I. lii"'u,I IS, _'01 ,
EQUIPMENT REPLACEMENT PLAN 2013 Mm 2017
City of Hopkins, MN
Project # 01 -ERP -0500
Project Name 1/2 Ton Truck
Future
Description
Frucks used by Water Department.
Current vehicle: 2007 Chevrolet
Justification
Prior Expenditures
20,500 Vehicles
Total
Prior Funding Sources
20,500 WF - Water Fund
Total
Department
Water
Contact
Public Works Director
Type
Equipment
Useful Life
10 years
Category
Vehicles
Priority n/a
Total Project Cost: $83,300
2013 2014 2015 2016 2017
26,800
Total 26,800
Total
from 20 year plan - none
salvage/resale value on replaced item: $
2013 2014 2015 2016 2017
70
26,800
26,800
Total Future
26,800
7 36,000
26,800
Total
Total
Future
26,800
36,000
26,800
Total
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 rhe a 2017
City of Hopkins, MN
Project # 01 -ERP -0501
Project Name 3/4 Ton Utility Truck
Future
Department
Water
Contact
Public Works Director
Type
Equipment
1 whil Life
10 years
< atekon
Vehicles
Priority
n a
Description I
Total Project Cost: $81,800
3/4 ton utility truck used by the Water Dig inion of Public Works.
Current vehicle: 2006 Chevrolet Pickup
Justification
Transportation to and from job site;, box carries tools used by personnel torjob site repairs and light hauling
Expenditures 2013 2014 2015 2016 2017 Total Future
Vehicles 34,900 34,900 46,900
Total 34,900 34,900 Total
Funding Sources 2013 2014 2015 2016 2017
WF - Water Fund
Total
Budget Impact/Other
✓ariance from 20 year plan - none
Estimate salvage/resale value on replaced item: $2,500
71
34,900
34,900
Total
Future
34,900
46,900
34,900
Total
IG(hircda}..lu,iii w /5. Z0/2
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0502
Project Name Backhoe Loader
Future
Department Water
Contact Public Works Director
Type Equipment
Useful Life 20 years
Category Equipment
Priority n/a
Description Total Project Cost: $75,000
Jnit utilitzed by Water, Sewer and Street Divisions of Public Works for repair and installation of underground utilities.
equipment: 1993 Caterpillar Backhoe 446 (#533)
Justification
Expenditures 2013 2014 2015 2016 2017 Total
Equipment 75,000 75,000
Total 75,000 75,000
Funding Sources 2013 2014 2015 2016 2017 Total
WF - Water Fund 75,000 75,000
Total 75,000 75,000
Budget Impact/Other
Variance from 20 year plan - Replace with smaller unit. Reduce price to $75,000.
Estimate salvage/resale value on replaced item: $
Wednesday, August 15, 2012
72
EQUIPMENT REPLACEMENT PLAN 2013 thin 2017
City of Hopkins, MN
Project # 01 -ERP -0550
Project Name 4x4 3/4 Toll Truck
Future
Description
truck used by Water/Sewer Division of Public Works.
Current vehicle: 2004 Chevrolet Pickun 0501
Justification
Snow plowing, light hauling, pulling trailers, gencral purpose transportation.
Deparhnent Sewer
Conwel Public Works Director
1'.% pe Equipment
useful Life 10 years
Catcgor� Vehicles
Prioritc n,a
Tonal Project Cost: $110,300
Prior Expenditures 2013
2014 2015
2016 2017 Total
Future
26,600 Vehicles
35,700
35,700
48,000
Total Total
35,700
35,700
Total
Prior
Funding Sources 2013
2014 2015
2016 2017 Total
Future
26,600
SF - Sanitary Sewer Fund
35,700
35,700
48,000
Total
Total
35,700
35,700
Total
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
73
It(-dnrs(/ur..bwusl IS, 2012
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0551
Project Name 3/4 Ton Utility Truck
Future
Description
I/4 ton utility truck used by the Water/Sewer Division of Public Works.
vehicle:
Justification
Department Sewer
Contact Public Works Director
Type Equipment
Useful Life 10 years
Category Vehicles
Priority n/a
Total Project Cost: $129,800
to and from job sites, box carries tools used by personnel for job site repairs and light hauling.
Prior Expenditures
51,000 Vehicles
Total
2013 2014 2015 2016 2017 Total Future
33,600 33,600 45,200
Total 33,600 33,600 Total
Prior
Funding Sources 2013
2014 2015 2016 2017
Total
Future
51,000
SF - Sanitary Sewer Fund
33,600
33,600
45,200
Total
Total
33,600
33,600
Total
Budget Impact/Other
✓ariance from 20 year plan - none
3stimate salvage/resale value on replaced item: $2,500
74
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 iat it 2017
City of Hopkins, MN
Project # 01 -ERP -0555
Project Name Generator (2)
Future
Description
'ortable generator used by Water Scwcr Di6sions of Public Works.
1997 Kohler Generator, 2008 Caterpillar C 15 1#537
Justification
Emergency back up generator for lift stations and pumps, off site power for lights and welding.
Depart[new
Se'we'r
Contact
Public Works Director
T.N pc
Equipment
I seful Life
25 years
C'alegory
Equipment
Priorio
n a
Total Project Cost: $49,400
Expenditures 2013
2014 2015 2016 2017
Total
Future
Equipment
26,400
26,400
F 23,000
Total
26,400
26,400
Total
Funding Sources 2013
2014 2015 2016 2017
Total
Future
SF - Sanitary Sewer Fund
26,400
26,400
F 23,000
Total
26,400
26,400
Total
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $2.500
M1
lirdncday. Iu,Luc� /5. ?ell?
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0700
Project Name Engineering Van
Future
Description
✓an used by Engineering Department for survey equipment and on job site work.
Suburban
Justification
Fransportation to and from job site, hauling of surveying and traffic counting equipment.
Prior Expenditures
F-716—,0-0301 Vehicles
Total
Department
Public Works: Engineering
Contact
Public Works Director
Type
Equipment
Useful Life
10 years
Category
Vehicles
Priority
n/a
Total Project Cost: $46,900
2013 2014 2015 2016 2017 Total Future
2,000 2,000 F 28,900
Total 2,000 2,000 Total
Prior Funding Sources
16,000 Equipment Replacement Fund
Total Total
2013 2014 2015 2016 2017
2,000
2,000
Budget Impact/Other
Variance from 20 year plan - Replace with surplus Police Tahoe in 2014. Leave $2,000 for modifications..
Estimate salvage/resale value on replaced item: $2,500
76
Total
Future
2,000
28,900
2,000
Total
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 11 t, 2017
City of Hopkins, MN
Project # 01 -ERP -0800
Project Name 1/2 Ton Pickup Truck
Future
Description
'ickup used by Park Division of Public Works.
�urrent vehicle: 2001 Ford Rangcr (i 1800
Justification
Department
Public Works: Parks 'Forestry
(bnlacl
Public Works Director
1'.�pc
Equipment
Fsetul lire
10 years
Category
Vehicles
Priorih
ma
Total Project Cost: $61,800
Expenditures
2013 2014
2015 2016 2017 Total
Future
Vehicles
26,400
26,400
35,400
Total
Funding Sources
26,400
2013 2014
26,400
2015 2016 2017 Total
Total
Future
Equipment Replacement Fund
26,400
26,400
35,400
Total
26,400
26,400
Total
Budget Impact/Other
dariance from 20 year plan - mox c back from 2012 to 2013
Estimate salvage/resale value on replaced item: $
77
It ((hw�dur.. ltiwccl 15. 1012
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0802
Project Name 3/4 Ton Utility Truck
Future
Department Public Works: Parks/Forestry
Contact Public Works Director
Type
Equipment
Useful Life
14 years
Category
Vehicles
Priority
n/a
Description I
Total Project Cost: $80,900
3/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city.
urrent vehicle: 1998
Justification
Ram 3500
Expenditures 2013 2014 2015 2016 2017 Total Future
Vehicles 32,200 32,200 48,700
Total 32,200 32,200 Total
Funding Sources 2013 2014 2015 2016 2017 Total Future
Equipment Replacement Fund 32,200 32,200 F 48,700
Total 32.200 32,200 Total
Budget Impact/Other
Variance from 20 year plan - move back from 2013 to 2014.
Estimate salvage/resale value on replaced item: $
78
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 thn, 2017
City of Hopkins, MN
Project # 01 -ERP -0806
Project Name Tractor
Future
Department
Public Works: Parks'Foresty
Contact
Public Works Director
Type
Equipment
t seful Life
30 years
Catekor�
Equipment
Priorit.
n'a
Description
1'01,11 Projecl Cost: $49,300
arm type tractors with cab used with various attachments. Ice rink svvrceping, flail mower, fertilizing, aeration, plowing and grass seeding.
Current equipment: 1984 Ford Tractor 2910 0816)
Justification
Expenditures 2013 2014 2015 2016 2017 Total
Equipment 49,300 49,300
Total 49,300 49,300
Funding Sources 2013 2014 2015 2016 2017 Total
Equipment Replacement Fund 49,300 49,300
Total 49,300 49,300
Budget Impact/Other
Variance from 20 year plan - Delete one tractor (2012) to be placed by ToolCat (2010). Mope second tractor to 2016.
Estimate salvage/resale value on replaced item: $3.500
li'rdr evilay. Ingim 15, 3013
79
EQUIPMENT REPLACEMENT PLAN 2013 Mm 2017
City of Hopkins, MN
Project # 01 -ERP -0807
Project Name Trucksters (3)
Future
Department
Public Works: Parks/Forestry
Contact
Public Works Director
Type
Equipment
Useful Life
15 years
Category
Equipment
Priority
n/a
Description I
Total Project Cost: $114,700
Truckster used by Parks Division of Public Works for ballfield and parks maintenance.
Currcm equipment: 1996 Toro Workman (#818),2004 Toro Workman 3200(#820),2004 Toro Workman 2110 #821
Justification
Park maintenance, ballfield grooming and weed spraying.
Prior Expenditures
7-2-9,9-00-1 Equipment
Total
2013 2014 2015 2016 2017 Total Future
19,800 19,800 65,000
Total 19,800 19,800 Total
Prior
Funding Sources
2013 2014
2015 2016 2017 Total
Future
29,900
Equipment Replacement Fund
19,800
19,80065,000
Total
Total
19,800
19,800
Total
Budget Impact/Other
Variance from 20 year plan - Move from 2012 to 2013.
3stimate salvage/resale value on replaced item: $1,400 each
80
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 Ing a 2017
City of Hopkins, MN
Project # 01 -ERP -0808
Project Name Riding Mowers (2)
Future
Description
Riding mowers used by Parks Divison of Public Works.
ipment: 2004 Toro Zero Turn (#826). 2006 Jacobson Rotary Mower (#;23)
Justification
Aowing city parks and right of ways.
Department Public Works: Parks Forestry
Contact Public Works Director
rype
Equipment
Gseful Life
8 years
C'ategor�
Equipment
Prioritc
n
'Total Project Cost: $169,000
Prior
Expenditures 2013
2014
2015 2016
2017 Total
Future
49,000
Equipment
11,000
20,000
31,000
89,000
Total
Total
11,000
20,000
31,000
Total
Prior
Funding Sources 2013
2014
2015 2016
2017 Total
Future
49,000 I
Equipment Replacement Fund
11,000
20,000
31,000
89,000
Total
Total
11,000
20,000
31,000
Total
ariance from 20 year plan - move back from 2013 to 2014 and reduce to 11.000. Move back from 2014 to 2015 and reduce to 20,000. Delete
to mower from plan.
;timate salvage/resale value on replaced item: $600 each
H'rdnrsdur.: tugust 15. 2012
81
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0809
Project Name Slope Mower
Future
Description
2001 DEW EZE ATM72 Slope Mower
Justification
Department Public Works: Parks/Forestry
Contact Public Works Director
Type
Equipment
Useful Life
15 years
Category
Equipment
Priority
n/a
Total Project Cost: $83,600
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 32,700 32,700 F 50,900
Total 32,700 32,700 Total
Funding Sources 2013
2014 2015 2016 2017
Total
Future
Equipment Replacement Fund
32,700
32,700
50,900
Total
32,700
32,700
Total
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $1,000
82
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 [nett 2017
City of Hopkins, MN
Project # 01 -ERP -0812
Project Name Stump Cutter
Future
Description
Stump cutter used by Parks Division of Public Works.
[Current equipment: 1997 Venneer Stump Cutter (#832)
Justification
Chipping out stumps of trees removed from city property.
Department
Public Works: Parksforestiy
Contact
Public Works Director
Tope
Equipment
tseful Life
20 years
Category
Equipment
Prioritc
n%a
"Iota[ Project Cost: $21,200
Expenditures 2013 2014 2015 2016 2017 Total
Equipment 21,200 21,200
Total 21,200 21,200
Funding Sources 2013 2014 2015 2016 2017 Total
Equipment Replacement Fund 21,200 21,200
Total 21,200 21,200
from 20 year plan - extend to 20 years to reflect actual.
salvage/resale value on replaced item: $1,800
83
11-1n, daY.:lu,��n�t 15. 31113
EQUIPMENT REPLACEMENT PLAN 2013 rhru 2017
City of Hopkins, MN
Project # 01 -ERP -0813
Project Name Brush Chipper
Future
Brush chipper used for Forestry and brush pick up operations of Public Works.
Current eauinment: 1993 Brush Bandit
Justification
250
Department Public Works: Parks/Forestry
Contact Public Works Director
Type Equipment
Useful Life 20 years
Category Equipment
Priority n/a
Total Project Cost: $25,700
Expenditures
2013 2014
2015 2016 2017 Total
Equipment
25,700
25,700
Total
Funding Sources
25,700
2013 2014
25,700
2015 2016 2017 Total
Equipment Replacement Fund
25,700
25,700
Total
25,700
25,700
Budget Impact/Other
Jariance from 20 year plan - Was moved back from 2013 to 2015, however recent developments show that the chipper is not performing well and
gill need to be replaced in 2013 so it was returned to the 2013 position.
,-stimate salvage/resale value on replaced item: $0
Wednesday, August 15, 2012
84
EQUIPMENT REPLACEMENT PLAN 2013 llu ii 2017
City of Hopkins, MN
Project # 01 -ERP -0815
Project Name Skid Loader
Future
Description
Current equipr
Justification
2004 Bobcat 463 ( 4833
D IL11-1 uMill
Public Works: Parks Foresty
cnntact
Public Works Director
1.% pe
Equipment
I wful Life
12 years
('ate„or�
Equipment
Priorits n a
Tolal Project Cost: $77,600
Expenditures 2013
2014 2015 2016 2017
'Total
Future
Equipment
32,000
32,000
45,800
Total
32,000
32,000
Total
Funding Sources 2013
2014 2015 2016 2017
Total
Future
Equipment Replacement Fund
32,000
32,0007--4-5—,6700
Total
32,000
32,000
Total
Budget Impact/Other
Jariance from 20 year plan - new item in 2004.
:stimate salvage/resale value on replaced item: $
Il'i d)rs,1m% . iqi�usv 15. 2012
85
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -0900
Project Name Refuse Truck (RAP -R) (2)
Future
Description
tefuse truck used by Refuse Utility Division of Public Works.
Curent vehicle: 2005 Peterbilt
Justification
Residential waste pick up.
Prior Expenditures
349,100 1 Vehicles
Total
Prior Funding Sources
349,100 RF - Refuse Fund
Total
Rail (#901) & 2011
Rail
Department
Refuse
Contact
Public Works Director
Type
Equipment
Useful Life
10 years
Category
Vehicles
Priority
n/a
Total Project Cost: $1,462,600
2013 2014 2015 2016
2017 Total
Future
204,800
204,800
908,700
Total 204,800
204,800
Total
2013 2014 2015 2016
2017 Total
Future
204,800 204,800 908,700
Total 204,800 204,800 Total
from 20 year plan - increase cost to reflect actual
salvage/resale value on replaced item: $18,000
86
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 ihrii 2017
City of Hopkins, MN
Project # 01 -ERP -0901
Project Narne Refuse Truck (Rear -L)
Future
Description
Zefuse truck used by Refuse Utility Dig inion of Public Works.
Current vehicle: 1996 Freightliner FL70 (#903)
Justification
Residential waste pick up.
Department
Refuse
Contact
Public Works Director
1.% pe
Fquipment
t sel'ul Life
10 years
('Mvgor>
vehicles
Priorit,
n'a
Total Project ('ost: $238,200
Expenditures 2013 2014 2015 2016 2017 Total Future
Vehicles 101,600 101,600 136,600
Total 101,600 101,600 lbtal
Funding Sources 2013 2014 2015 2016 2017 Total Future
RF - Refuse Fund 101,600 101,600 136,600
Total 101,600 101,600 'Total
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $9.000
87
11''edn' sday..11,v, cl 15. ?OL'
EQUIPMENT REPLACEMENT PLAN 2013 rhru 2017
City of Hopkins, MN
Project # 01 -ERP -1000
Project Name Ice Resurfacer
Future
Description
Ice resurfacer used by the Pavilion for ice sheet maintenance.
urrent eauinment: 2003 Olvmnia Ice Resurfacer
Department Pavilion
Contact Facilities Director
Type Equipment
Useful Life 12 years
Category Equipment
Priority n/a
Total Project Cost: $496,600
Justification
Replace existing propane fueled ice resurfacer with a electric driven ice resurfacer. Due to changes in the states statues for indoor air quality for ice
arenas replacement with a propane fueled model would warrant the purchase and installation of state approved air quality monitoring equipment.
Additional costs that would accompany the monitoring equipment would be annual testing and recalibration fees. State statues also require annual
licensing and lower emission standards to be meet that if exceeded could possibly lead to possible facility closures and loss of revenue. With
consideration of the above factors the Pavilion would be exempt from the new statues if a electric ice resurfacer was used in place of propane ice
resurfacer.
Prior Expenditures 2013 2014 2015 2016 2017 Total Future
F-760—,00-01 Equipment 180,000 180,000 256,600
Total Total 180,000 180,000 Total
Prior
60,000
Total
Funding Sources 2013 2014 2015 2016 2017 Total Future
PA - Pavilion Fund 180,000 180,000 256,600
Total 180,000 180,000 Total
Variance from 20 year plan - Value increased to reflect actual replacement cost.
Estimate salvage/resale value on replaced item: $20,000
Wednesday, August 15, 2012
88
EQUIPMENT REPLACEMENT PLAN 2013 thru 2017
City of Hopkins, MN
Project # 01 -ERP -1001
Project Name Electric Ice Edger
Future
Department Pavilion
('ontact Facilities Director
Type Equipment
I seful Life 10 years
Category Equipment
Prioritc n'a
Description
Total Project Cost: $11,700
Electric ice edger used for ice maintenance of the Pavilion's ice sheet. An edger is used to shave the ice next to the boards to remove ice buildup
:hat the ice resurface cannot reach.
Justification
For the Pavilion to be exempt from the changing state statutes for air quality in ice arenas, the gas fueled edger must be replaced with an electric
model.
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 5,000 5,000 6,700
Total 5,000 5,000 Total
Funding Sources 2013 2014 2015 2016 2017 Total Future
PA - Pavilion Fund 5,000 5,000 6,700
Total 5,000 5,000 Total
Budget Impact/Other
Vairance from 20 year plan - Ncw item.
Estimate salvage/resale value on replaced item: $
89
It ("Im ,drrr..ingw1 15. ?ttl_'
EQUIPMENT REPLACEMENT PLAN 2013 rhru 2017
City of Hopkins, MN
Project # 01 -ERP -1102
Project Name Art Center Kitchen Catering Equipment
Future
Description I
Jnder counter freezer and refrigerator in catering kitchen.
Justification
these units are used for storing food for HCA events and for rental clients.
Department
Arts Center
Contact
Arts Center Director
Type
Equipment
Useful Life
12 years
Category
Equipment
Priority
n/a
Total Project Cost: $12,100
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 5,000 5,000 7,100
Total 5,000 5,000 Total
Funding Sources 2013 2014 2015 2016 2017 Total Future
AC - Arts Center Fund 5,000 5,000 7,100
Total 5,000 5,000 Total
Budget Impact/Other
Variance from 20 year plan - New item. Current pricing $2049 refrigerator, $2207 freezer plus delivery.
Estimate salvage/resale value on replaced item: $-0-
Wednesday, August 15, 2012
90
EQUIPMENT REPLACEMENT PLAN 2013 /hru 2017
City of Hopkins, MN
Project # 01 -ERP -1103
Project Name Art Center Video Camera Updates
Future
Department ArtsCenter
Contact Arts Center Director
Tppe
Equipment
t scful Life
5 years
Cmm,ory
Equipment
Prioritc
n a
Description
focal Project Cost: $22,000
Replace the front entry camera with a better resolution camera. Relocate existing to abo%re the display cabinet in the lobby. Add additional camera
:o the gallery, left of door to capture shot of faccs of those exiting. Add a camera to the back hallway of the second floor.
Justification
(here was an item taken from a display case in 2011 and existing cameras did not provide clear angle and view of the culprit. Also, addition of a
;amera in the back hallway may reduce tendency of youth to hang out in that area and engage in inappropriate behavior.
Prior
Expenditures 2013 2014
2015 2016 2017
Total
Future
3,200
Equipment
3,700
3,700
F 15,100
Total
Total
3,700
3,700
Total
Prior Funding Sources 2013 2014
2015 2016 2017
Total
Future
3,200 AC - Arts Center Fund
3,700
3,700
15,100
Total Total
3,700
3,700
Total
Budget Impact/Other
Variance from 20 year plan - New item.
Estimate salvage/resale value on replaced item: $-0-
9E
II dII,'Jur. lri('ini l?. _'ul
EQUIPMENT REPLACEMENT PLAN 2013 th it 2017
City of Hopkins, MN
Project # 01 -ERP -1104
Project Name Art Center Theater Projector
Future
Department Arts Center
Contact Arts Center Director
Type
Equipment
Useful Life
5 years
Category
Equipment
Priority
n/a
Total Project Cost: $30,400
ilace the projector currently in the theater with a projector that has higher lumens and HDMI connectivity. Rewire it so it can be operated from
control booth.
Justification
The current projector in the theater is a 3000 lumen projector. It is used for rental events and for showing pre -concert advertisements. When
house lights are at half, the image is inadequate. Replacing it with a 4500 higher lumen projector improves the image in partial light conditions
such as when the audience is being seated. In addition, it needs to have a HDMI input, which the existing unit does not offer. Rewiring it allows it
to be turned on and off without being in line of site -- currently someone has to be sitting in the audience to power it off. Existing theater projector
could be utilized for rental events until completely obsolete.
Expenditures
Equipment
Funding Sources
2013 2014 2015 2016 2017 Total Future
6,000 6,000 24,400
Total 6,000 6,000 Total
2013 2014 2015 2016 2017
AC - Arts Center Fund 6,000
Total 6,000
from 20 year plan - New item: $3500 projector, $2500 installation (T&M estimate)
salvage/resale value on replaced item: $
92
Total
Future
6,000
F 24,400
6,000
Total
Wednesday, August 15, 2012
EQUIPMENT REPLACEMENT PLAN 2013 dint 2017
City of Hopkins, MN
Project # 01 -ERP -1105
Project Name Art Center Community Room Audio Visual
Future
Department Ails Center
Contact Arts Center Director
pe
Equipment
I seful Life
7 years
Category
Equipment
Priority
n'a
Description
Total Project Cost: $41,100
Install a projector in a ceiling mount. Wire speakers into the ceiling. Wire input for computer on front wall. Utilize existing manual screen. Add
two microphones. Mount equipment in rack in closet.
Justification
�urrent operations require the use of an A, V cart, several cords across the floor and a large unattractive speaker on a stick. By incorporating the
)rojector into a ceiling mount and speakers into the ceiling, we \v ill be able to present a much more streamlined appearance and functionality for
groups making presentations in the room. This will enhance the experience of current rental clients and help us acquire new ones. It will keep the
k/V safely off the floor and reduce cords and set up time.
Expenditures 2013 2014 2015 2016 2017 Total Future
Equipment 11,000 11,000 30o0
Total 11,000 11.000 Total
Funding Sources 2013 2014 2015 2016 2017 Total Future
AC - Arts Center Fund 11,000 11,00030,100
Total 11,000 11,000 Total
Budget Impact/Other
Variance from 20 year plan: New item
Estimate salvage/resale value on replaced item: $
0191
It''hi,'viol, (q,nvl l?. _'0/ ,
TWENTY-YEAR
REPLACEMENT SCHEDULE
94
I5 -Aug -12
EQUIPMENT REPLACEMENT SCHEDULE
5305,900
INFLATION FACTOR 3.0
REPL
EQUIPMENT /VEHICLES YRS
2013 2014 1015 2016 2017 2018 2019
2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
2032
17RP-00.1 N I'I rade
1
ACTIVITY CENTER
8,000
8,1)0(1
8,000
ERP -030 Copy Machine (to be leased)
8,000
8,000
8,000
ERP -031 Refrigerator/Freezer 30
1
8,000
9,000
SUBTOTAL
I
8,000
8,000
ARTS CENTER
8.000
8.000
8.000
ERP -1100 Copy Machine (leased)
8
ERP -I 101 Carpet Extractor 10
_
7,000
FRI'-I In_ Kitchen ('meting Fquipmenl 12
5 00u
FR11-1I0: "idco Camem Updates 5
3,700
4,300 5,000
5,800
FRI'-I W4 1"heater PiQlector 5
6,000 7,000
8,100 0,300
ERP -I 105 C'ommmtit7 Room A/V 7
11,000
13,500 16,600
-
30.000
11,000 11.000 3.700 TWO
13.500 Moo 8.100 7,100 5,000 25.900
12.800
CITIIIALL ADMIN
17RP-00.1 N I'I rade
1
8,000
8,000
8,1)0(1
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
9,000
8,000
8,000
8,000
8,000
8,000
8.000
8.000
8.000
FRP-004 Phone System
8
76,000
76,000
93,500
HRP -00o Computers
-
30.000
30,000
311,000
30,000
30,000
30,000
30.000
30,000
30,000
30,000
30,000
3(1.000
30,,0110
30,000
30,1100
30,000
30,000
30,000
30,000
310,0(10
FRP-009 Network Infrastructure Upgradr
15
23,400
ERP -012 Cote Nehvork Switch
6
12.000
14,300
17,000
FQ1'IPNIENT SU 1TOTAL
38.000
38.000
114,000
38.000
38.000
50,000
38,000
38.000
98.000
61.400
114,000
52.300
38.000
38.000
38,11110
39,000
38.(1(10
>5,000
131,500
38.000
CONIMCNFIA SF.RN'ICES
I Rl'-001 Main ('op- llcascdI
FRP-002 Small Copier (to be leased)
FRP-008 Document Munn Scanner (2)
11.700
1 3,000
11.400
14.700
16,000
17500
ERP -010 flection Booths
20
FRP-01 I Elecuon ISgmpmen
10
50,000
67,20(1
F.QI'111A11'NT St TITOTAI.
50,000
I1.3(10
13.000
13400
67.200
14,700
16,000
17500
FIRE
ERP -10(1 'fele-Squirt F--2
10
470.900
633.000
ERP -101 Fire Pumper E-3
20
722,400
ERP -103 Duty Chief Vehicle
5
37,000
44,100
51,100
57,500
ERP -105 Quick Attack Pumper/Rescue 1
10
314,500
422.600
FRP-105a Utility Vehicle
5
35,000
40,000
47,000
54.500
ERP -106 Aerial Truck 1.9
20
54,217
54?17
54,217
54,217
54,217
54,217
1,572,000
VF1IICI.ES SUBTOTAL
54,217
54,217
(11,217
99.217
54.217
525.117
44,100
40.o w
314.500
51,100
769,400
2,205,000
575(10
54.500
422.600
ERP -107 An Compressor
15
34,900
54,400
ERP. 109 Breathing Apparatus (45)
10
25000
336,000
ERP -109 Extrication Tool (2)
10
27,400
30,000
36,900
HRP -110 Copp Machine (to be leased)
ERP -I 12 Thermal Imagine Camera (2)
10
11,500
12,900
15,400
17,400
1'RP-1 13 l'met gency Preparedness Siren
20
38"500
ERNI 14 Floor Scrubber
12
14,300
20,300
ERP -I I(, Workout Equip - Eliptical
6
5.800
6,700
7,800
ERP -I 17 Workout Equip - Summit Traim
5
5,800
6,700
7,800
9,000
ERP -118 Workout Equip - Treadmill
-
5,800
6,700
7.800
ERP -119 Workout Equip- Weight Liftim,
5
5,800
6,700
7,800
9,000
ERP -120 Defibidlator(2)
4
7,200
7,800
8600
9,300
10.200
FRP- 122 Workout Equip - Dumb Bells
10
5.000
6,700
ERP -215 Radios -Portable & Mobile
198,500
FQUIPMENT SUBTOTAL
11,500
12.200
17,400
299,200
18,700
206,300
27,400
13,400
6.700
45.300
15,400
6,700
15,600
383,800
33,000
20,300
36.000
28,200
54.400
95
P.W. ENGINEERING
ERP -700 Engineering Van 10 2,000
ERP -701 Printer/Scanner (leased)
2,000
96
28,900
28,900
REPL
EQUIPMENT /VEHICLES YRS
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
POLICE
ERP -200 Squad #1 #202
3
36,700
40,100
43,800
47,900
52,300
57,000
62,300
ERP -200 Squad#2 9209
3
36,700
40,100
43,800
47,900
52,300
57,000
62,300
ERP -200 Squad #3 9200
3
35,600
38,900
42,500
46,500
50,800
55,500
60,600
ERP -200 Squad #4 #203
3
37,800
41,200
45,100
49,200
53,900
58,900
ERP -200 Squad #5 #207
1
35,600
38,900
42,500
46,500
50,800
55,500
60,600
ERP -200 Squad #6 #205
3
37,800
41,200
45,100
49,200
53,900
58,900
ERP -201 Sergeant Vehicle #206
4
37,800
42,500
47,900
53,900
60,700
ERP -202 Parking Vehicle #211
10
27,200
36,600
ERP -203 Utility 4x4 #212
6
47,700
60,400
72,100
86,100
ERP -204 Admin Car #
2
30,500
32,400
34,300
36,400
38,700
41,100
43,600
46,300
49,000
52,000
ERP -204 Admin Car #216
2
29,600
31,400
33,300
35,400
37,500
39,800
42,200
44,800
47,500
50,400
ERP -205 HEAT Vehicle #240
15
30,000
46,700
ERP -206 Police Services Liaison vehicle
15
25,000
38,900
VEHICLES SUBTOTAL
100,800
151,600
169,800
167,400
113,500
116,700
162,900
184,400
127,700
131,700
183,500
139,500
143,800
256,900
206,500
157,300
161,500
205,700
279,000
262,700
ERP -208 Computer System
20
200,000
ERP -209 Copy Machine
5
22,100
25,600
29,700
34,400
ERP -210 Log Recorder
7
36,900
45,400
55,800
ERP -211 Network Server (3)
3
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
8,500
ERP -212 Mobile Data Computers
5
62,700
62,700
62,700
62,700
ERP -213 Digital Squad Car Cameras
5
53,400
53,400
53,400
53,400
ERP -214 Tactical Ballistic Vests (9)
5
23,200
26,900
31,200
36,200
ERP -215 Radios -Portable & Mobile
363,500
ERP -216 911 Phone System (Viper)
ERP -217 Taser Replacement
4
18,600
20,900
23,500
26,500
29,900
EQUIPMENT SUBTOTAL
250,300
161,500
8,500
30,600
29,400
398,900
124,600
8,500
103,000
8,500
39,700
124,600
35,000
38,200
8,500
100,500
154,400
8,500
42,900
8,500
P.W. ADMIN
ERP -215 Radios -Portable & Mobile
38,000
P.W. BLDG./EOUIPMENT SVCS
ERP -710 1/2 Ton Truck
10
31,300
42,100
ERP -711 Vehicle Washer
12
8,300
31,300
8,300
42,100
P.W. ENGINEERING
ERP -700 Engineering Van 10 2,000
ERP -701 Printer/Scanner (leased)
2,000
96
28,900
28,900
REPL
EQUIPMENT/VEHICLES YRS
2013
2014
2015
2016
201-
2018
2019
21120
2021
2022
2023
2024
2025
2026 2027 2028
2029
2030
2031 2032
P.W. PARKS & FORESTRY
ERP -800 1/2 Ton Truck
10
26,400
35,400
ERP -801 4x4 3/4 Ton Truck
8
42,600
54,000
ERP -801 4x4 3/4 Ton Truck
R
42,600
54,000
ERP -802 3/4 Ton Utility Truck
10
32,200
48,700
ERP -804 Log Truck (50°i w/Refuse)
15
81,800
ERP -805 Aerial Lift
20
228,900
ERP -806 Tractor
30
4111111,
ERP -807 Truckster(#818)
15
19,800
30,800
ERP -807 Tnrckster (-920)
IS
23,000
ERP -807 Truckster(4921)
15
11,200
IIRP-808 Riding Mower 0'923)
9
20.000
25.300
32.100
ERP -808 Riding Mowcr (4926)
9
11,000
13,900
17,700
FRP-90 Slope Mowat 092S)
IS
32,700
50.900
ERP -810 Large Turf Mower (H825)
10
92,700
124,600
ERP -81I Turf Sweeper
IS
19,000
ERP -812 Stump Cutter
20
21,200
ERP -813 Bnish Clipper
20
25,700
ERP -814 Trailer Flathed
I5
2200
ERP -915 Skid Loader
12
32000
45,600
ERP -816 Toolcat
8
63,300
80,200
ERP -917 Grass Secd Applicator
20
VEHR LFS Sl1BrOTAL
71,900
4+,200
20,000
81j)()()
53,200
81,300
34,200
180,100
95,700
60,700
8112110 187,500
45,600
371200
93,000
P.R. STREE I'SfFRAFFIC
FRP-300 4,4 ; 4 Ton Muck Plow
10
-1501)
28.9110
ERP -301 4,4 3 4 Ton'rit ck Plow
8
30,400
38.500
49.800
FRP-r02 4,2 1 [,,,,D ip Muck
12
14.600
77.900
ERP -303 I Ton Dump Truck
12
49,500
ERP -303 I Fort Dump 1'nick
12
53,400
ERP -304 I Ton Boom Truck
17
136,400
ERP -305 Sin_le Axle Dump Iuck
17
112100
ERP -305 Single Axle Dump Truck
17
124,000
FRP-305 Single Axle Dump Truck
17
210,600
ERP -30(, Tandem Dump Truck
17
173,200
FRP-31)7 AXater Dock
22
150,000
ERP -308 Front End Loader
15
268,000
ERP -308 Front End Loader
18
268,600
ERP -309 Skid Loader
12
41,900
59,700
ERP -309 Skid Loader
12
50 000
ERP -310 Grader
20
167.300
ERP-, I I Sweeper
12
156,400
ERP -312 Roller
20
45,900
ERP -313 SOiper
12
11,200
16,000
ERP -314 Paver
20
48,800
ERP -315 Snow Blower
20
102,300
ERP -316 Trailer
20
ERP -517 Sign Machine
10
13.400
1 8. 100
ERP -318 Asphalt Hot Mix Heating Box
12
22,100
ERP -319 Regenerative Air Sweeper
20
185000
VEHICLES SUBTOTAL
206,5011
94,700
43,800
144,200
161,200
351,800
288,500
103.400
336,000
71,600
195,400
268,000 59,700
363,000
77,800
48.800
97
REPL
EQUIPMENT /VEHICLES YRS 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
HRA
ERP400 4x4 3/4 Ton Truck
8
32,400
4 1, 1 uu
52,100
ERP -401 Copier
8
13,000
1(1500
20,900
SUBTOTAL
13,000
32,400
I��_<uu
41 o
20,900 52,100
WATER
ERP -500 1./2 Ton Truck
10
26,800
36,000
ERP -501 3/4 Ton Utility Truck
10
34,900
46,900
ERP -502 Backhoe
20
75,000
ERP -503 Air Compressor
20
41,700
ERP -506 Copy Machine (to be leased)
ERP -507 Telephone System
8
6,800
6,800
8,600
SUBTOTAL
75,000
6,800
61,700
6,800
82,900 41,700
8,600
SEWER
ERP -550 4x4 3/4 Ton Truck
10
35,700
48,000
ERP -551 3/4 Ton Utility Truck
10
33,600
45,200
ERP -552 Jet Vactor
20
180,800
ERP -555 Generator
25
26,400
ERP -555 Generator
25
23,000
ERP -557 Telephone System
8
6,800
6,800
8,600
SUBTOTAL
35,700
6,800
33,600 26,400
180,800 23,000
6,800 48,000
45,200
8,600
REFUSE
ERP -900 Refuse Truck (RAP -R) 10
ERP -900 Refuse Truck (RAP -R) 10
ERP -901 Refuse Truck (Rear -L) 10
ERP -803 Swap Loader 20
ERP -804 Log Truck (50°/ w/Forestry) 20
SUBTOTAL
STORM SEWER
204,800
101,600
101,600 204,800
270,300
81,800
270,300 81,800
275,200
136,600
136,600 275,200
PAVILION
ERP -1000 Ice Resurfacer 12 180,000 256,600
ERP -1001 Electric Ice Edger 12 5,000 6,700
SUBTOTAL 180,000 5,000 6,700 256,600
98
363,200
144,800
144,800 363,200
REPL
EQUIPMENT /VEHICLES YRS
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027 2028
2029
2030
2031
2032
TOTALS
2013
2014
2015
2016
2017
2018
2019
2020
2011
2022
2023
2024
2025
2026
2027 2028
2029
2030
2031
2032
GENERAL FUND-VEHICLES/EQUIP
433,417
345,717
324,817
482,817
382,117
1,106,217
197,100
408,600
456,800
645,300
580,200
240,000
380,300
1,106,500
474,500 2,651,600
570,100
712,200
465,300
685,300
GENERAL FUND-OTHER EQUIP
349,800
211,700
151,200
367,800
86,101
706,200
190,000
68,200
161,100
115,200
236,300
198,300
88,600
460,000
95,500 158,800
229,300
109,200
228,800
46,500
HRA
13,000
32,400
16,500
41,100
20,900
52,100
ARTS CENTER
11,000
11,000
3,700
7,000
13,500
9,500
8,100
7,100
5,000 25,900
12,800
WATER
75,000
6,800
61,700
6,800
82,900 41,700
8,600
SEWER
35,700
6,800
33,600
26,400
180,800
23,000
6,800
48,000
45,200
8,600
REFUSE
101,600
204,800
270,300
81,800
136,600
275,200
144,800
363,200
STORM SEWER
PAVILION
180,000
5,000
6,700
256,600
GI VFR;AI. FI AU 1OI,4L
78;,217
5 57,4 17
476,017
850,617
468,218
1,812,417
387,100
476,8110
617,900
760,100
816,5110
438,31111
468,900
1,566,500
570,000 2,810,400
799400
821,400
694,100
731,800
IIRA TOTAL
13,000
32,400
16,500
41,100
20,900
52,100
ARTS CENTER Ft 'ND TOTAL
11,000
1 1,000
3,700
7,000
13,500
9,500
8,100
7,100
5 000 25,000
12.800
UTILFFY FI INDS TOTAL
255,000
142,300
218,400
33,600
88,100
180,800
270,300
104,800
13,600
191,300
531,800
45,200
82,900 41,700
144,800
380,400
1,049,217
723,717
726,817
884.217
560,018
1,819,417
387,100
657,600
901,700
891,300
879,300
629,600
1,007,800
1,611,700
657,900 2,878,000
799,400
987.100
1,126,600
744.600
61 NVRAL FUND tiALVAGF
35,000
15,000
40.000
40.000
40,000
40,000
411.0110
40,000
40,000
40,000
40.000
40.000
40,000
40.000
40,000 40,000
40,000
40,000
411000
40.000
NE I GENERAL FI IND
748,217
522,417
436,017
810,617
428,218
1,772,417
347,100
436,800
577,900
720,500
776,500
398,300
428,900
1,526,500
530,000 2,770,400
759,400
781,400
654,100
691800
20 y"EAR AVERAGES
Total
Average
ACTIVITY CENTER ADMINISTRATION
I
('ITY HALL ADMINISTRATION
1072"200
53"600
CO\IVIUNITY SF.RVICFS
203,100
10,200
FIR] PVI IP\IFNF
4.%'_7.502
24L400
FIRE: ADAIINIS IRA "LION
1.252400
62.600
POLICI. FQI'IP\II'N I
1.422,000
171.100
POLICE ADMINISTRATION
1684,600
84,200
PI "BLIC \VORKS ADMINISTRATION
38000
1000
BLDG /EQUIPMENT SERVICES EQITIPMENT
81,700
4.100
I:N(',INFI'RING I?Ql"1PAIF:NT
30,MIu
1,500
PARKSTORESTRY EQUIPMENT
1,489,800
74,500
STRITT E.QI'IPMF.NT
2804 400
140,200
GENERAL FUND VEHICLE EQUIPMENT
a#"tiBB 8
632,900
GENERAL FUND OTHER EQUIPMENT
4,250,301
212,500
GENERAL FUND TOTAL
845,400
HRA
176,000
8,800
ARTS ('ENTER Fl IND
114,600
5.700
WATER I ITILITY Fl IND
283,500
14,200
SI'.AA4'.R 1 TILITV' Fl IND
414,900
20,700
REFUSE IJTII,ITY FIJND
1,578,300
78,900
STORM SI:W]:R U l ILII') FUND
PAVILION FUND
448,300
22,400
UTILITY VEHICLES/EQUIPMENT
3,015,600
150,800
99
EQUIPMENT AND BUILDING
INVENTORY
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2012
UNIT #
YEAR
MAKE
MODEL
CURRENT
REPLACEMENT
COST
FIRE DEPARTMENT
2008
FORD
CROWN VICTORIA
100
2006
DODGE
DURANGO
$28,300
101
2003
CHEV
IMPALA
24,900
102.
1989
FORD L9000
TELE -SQUIRT
240,000
103.
2006
PETERBILT
PUMPER
403,300
108.
1995
CHEV
4X4 LITE RESCUE
25,000
109
2008
PIERCE
AERO XT
845,000
110
2010
CHEVROLET
TAHOE
30,000
115.
1952
MACK
PUMPER
4,000
POLICE DEPARTMENT
200.
2010
FORD
CROWN VICTORIA
$30,000
201.
2008
FORD
CROWN VICTORIA
28,100
202.
2011
FORD
CROWN VICTORIA
31,000
203.
2009
FORD
CROWN VICTORIA
28,160
205.
2011
FORD
CROWN VICTORIA
31,000
207.
2010
FORD
CROWN VICTORIA
30,000
209.
2011
FORD
CROWN VICTORIA
31,000
211.
2006
JEEP
LIBERTY
18,800
212.
2008
CHEV
TAHOE
36,000
213.
2010
CHEV
IMPALA
26,000
214.
2007
DODGE
CHARGER
28,000
215.
2009
CHEV
IMPALA
25,000
216.
2011
FORD
TAURUS
30,000
217.
2008
FORD
TAURUS
22,000
219.
2013
FORD
TAURUS
27,500
240.
1998
CHEV
P40 VAN
20,000
241.
2001
CHRYSLER
PT CRUISER
18,000
In
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2012
CURRENT
REPLACEMENT
UNIT # YEAR MAKE MODEL COST
STREET/TRAFFIC DIVISION
301.
1997
CHEV
3/4 TON
$21,000
302.
2006
FORD
F250
26,500
304.
2000
FORD
F-450
34,000
305.
1997
FORD
1/2 TON
18,300
307.
2006
FORD
F350-1 TON DUMP
27,400
308.
2011
FORD
F350 - 2X4
20,300
309.
2012
FORD
F450
30,300
310.
1989
INTERNATIONAL
SGLAX DUMP
70,000
311.
2011
FREIGHTLINER
M2106V
79,400
312.
2005
FREIGHTLINER
SGLAX DUMP
98,000
313.
2001
FORD
L7501
72,000
314.
1998
FORD
LT 8500
86,000
315.
1996
FORD
L-8000
85,000
316.
1995
FORD
WATER TRK
81,000
320.
1991
CATERPILLER
LOADER 926E
90,000
322.
2005
CATERPILLER
LOADER 938G
157,800
324.
2004
BOBCAT
SKID LOADER
30,000
325.
2011
BOBCAT
SKID STEER LOADER
38,400
326.
1989
CATERPILLAR
140-G
82,000
327.
2001
ELGIN
PELICAN SE
105,000
330.
1989
INGERSOL/RAND
ROLLER DD -25
23,000
337.
1994
CATERPILLAR
BOX PAVER
18,000
342.
1991
TARGET
CONCRETE SAW
2,400
344.
1996
SNOGO
WK 800
58,000
349.
1989
TRAIL -KING
TK6V-1200
3,000
350.
1993
TOWMASTER
T14
4,000
351.
2004
TENNANT
SWEEPER 3640
10,000
PUBLIC WORKS - ADMINISTRATION
401. 2008 FORD CROWN VICTORIA $28,100
ENGINEERING DIVISION
700. 2000 CHEV SUBURBAN $14,500
705. 2005 CHEV IMPALA 14,600
102
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2012
CURRENT
REPLACEMENT
UNIT # YEAR MAKE MODEL COST
BUILDING MAINTENANCE & EQUIPMENT SERVICES
701
1997
CHEV
01500
$16,000
702
2004
FORD
F350
23,000
703.
2002
CHEV
TAHOE
5,000
704.
2005
FORD
F250
24,000
PARKS/FORESTRY DIVISION
800.
801.
802.
803.
804.
805.
810.
811.
812.
815.
817.
818.
820.
821.
822.
823.
824.
825.
826.
828.
832.
833.
834.
836.
842.
844.
845.
846.
847.
2001
2012
2012
2004
1996
1998
1993
2006
2010
2010
1982
1996
2004
2004
2001
2006
1996
2010
2004
2001
1997
2004
1993
2011
2010
1997
2001
2011
FORD
FORD
FORD
FORD
CHEV
DODGE
INTERNATIONAL
INTERNATIONAL
FREIGHTLINER
BOBCAT
FORD
TORO
TORO
TORO
TORO
JACOBSON
TORO
TORO
TORO
DEW EZE
VERMEER
BOBCAT
BRUSH BANDIT
RYAN
P.J.
FELLING
REMACKEL
DRESSEN
SPARKS
RANGER4X4
F350 4X4
F350 4X4
F350
3/4T 4X4
RAM 3500
LP 4700
LP 4600 LOG TRUCK
AERIAL LIFT
TOOLCAT
TRACTOR 2610
TRUCKSTER
WORKMAN 3200
WORKMAN 2110
325-D MOWER
MOWER
GROUND MASTER
4100D MOWER
Z587L
ATM 72
STUMP CTR 630A
SKID LOADER
CHIPPER 250
SOD CUTTER
TRAILER
TRAILER
TRAILER
8110
TILT TRAILER
103
$18,000
24,100
24,100
23,000
16,000
24,000
50,000
45,000
130,000
50,000
22,000
13,000
15,000
7,900
18,000
10,000
16,000
53,000
8,900
21,000
15,400
22,000
14,000
2,000
5,300
4,000
5,000
2,000
5,300
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2012
CURRENT
REPLACEMENT
UNIT # YEAR MAKE MODEL COST
HRA
411. 2007 CHEV
WATER/SEWER
2500 HD
$17,500
500.
2007
CHEV
PICKUP
$22,000
501.
2004
CHEV
4X4 3/4 T SILVERADO
19,000
502.
1999
DODGE
DAKOTA 4X4
18,000
505.
2007
CHEV
CC25753
24,000
506.
2006
CHEV
SILVERADO
20,700
530.
2001
STERLING
VAC -CON
180,000
533.
1993
CATERPILLAR
LDR-BKHOE-446
50,000
534.
1997
KOHLER
GENERATOR/TRL
11,000
535.
1992
KOHLER
GENERATOR/TRL
10,000
536.
1989
FLEXIBLE
RODDING MACHINE
25,000
537.
2010
GENERATOR
C15
130,000
540.
2008
LEROI
AIR COMPRESSOR
12,000
542.
1994
WACKER
TAMPER
4,000
I "I D1 lc"
900.
2011
FREIGHTLINER
RAPID -RAIL M2
$211,800
901.
2005
PETERBILT
320
162,000
903.
1995
FREIGHTLINER
FL -70
54,000
PAVILION
801. 1996 CHEV 4X4 TRK $19,100
809. 2003 OLYMPIA ICE RESURFACER 85,000
104
Location/Descript ion
City Hall
1010 1st Street S.
Police Station
1010 1st Street S.
Fire Station
101 17th Avenue S.
Hopkins Activity Center
33 14th Avenue S.
Ice Arena/Pavilion
11000 Excelsior Boulevard
Arts Center
1111 Mainstreet
PW Admin/Garage
11100 Excelsior Boulevard
Moline Reservoir/Well #1
10421 Excelsor Boulevard
Blake Tower Reservoir
151 Tyler Avenue S.
Filtration Plant
1401 Elmo Park Service Road
Well #4 Workshop/Storage
1401 Elmo Park Service Road
Well #5
1205 Highway?
Well #6
801 Highway 7
Lift Station #2 - Drillane
619 Drillane Road
Lift Station #3 - Lindee's
901 Cambridge Street N.E.
CITY OF HOPKINS
BUILDING INVENTORY
June 2012
105
Replacement Cost
$3,491,100
3,936,800
4,322,850
1,872,315
5,141,585
7,042,635
7,354,065
2,357,175
1,421,368
3,466,700
235,245
313,645
66,825
133,450
Location/Descrintion Replacement Cost
Lift Station #4 - LTL Meadowbrook
$97,725
244 Meadowbrook Road
Lift Station #5 - Big Meadowbrook
155,125
6601 Excelsior Blvd.
Lift Station #6 - Ronnie's
97,725
8546 Excelsior Avenue E.
Lift Station #7 - Valley
308,900
801 6th Avenue S.
Band Shell - Downtown Park
36,900
16 9th Avenue S.
Concession Stand - Maetzold Field
152,885
1215 1 st Street N.
Park Building -Beach - Lifeguards
164,970
5200 Shady Oak Road
Park Building -Beach -Concessions
155,880
5200 Shady Oak Road
Park Shelter - Office/Bathhouse
378,608
5200 Shady Oak Road
Park Shelter - Burnes
50,388
201 Park Lane
Park Building - Central
114,363
101 17th Avenue S.
Park Building - Harley
38,745
108 Jackson Avenue S.
Park Shelter - Interlachen
61,926
220 Homedale Avenue
Park Building - Oakes
44,178
301 Tyler Avenue N.
Park Building - Valley
51,941
800 7th Avenue S.
Parking Ramp 6,391,900
10th Avenue and Mainstreet
106
Location/Description Replacement Cost
Depot Coffee House $481,475
9451 Excelsior Boulevard
Overpass Skate Park 7,703
100 Washington Avenue
Dow Towers (76 Units) HRA
22 5th Avenue S.
107