CR 11-064 (2012 - 2016 Equipment Replacement Plan)•
June 30, 2011
Proposed Action
-4ca
City of Hopkins
Council Report 2011-064
2012-2016 EQUIPMENT REPLACEMENT PLAN
Staff recommends adoption of the following motion: Move to adopt the 2012-2016 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 2012-2016 allows staff to incorporate the 2012 ERP items into the 2012 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
• 2012-2016 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:
City of Hopkins
EQUIPMENT REPLACEMENT PLAN
AL S,
rj
-�-----
2012-2016
I
•
r
•
City of q%kins
1010 !first Street South • Hopky: xs, MN 55343-7573 • Phone: 952-935-8474 • fax• 952-935-1834
Web address: uruw.hopkjnsmn.com
DATE: June 2011
TO: Honorable Mayor and Members of the City Council
FROM: Jim Genellie, Acting/Assistant City Manager
SUBJECT: 2012-2016 EQUIPMENT REPLACEMENT PLAN
With this letter, I respectfully submit the 2012-2016 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 Community to Enhance the Quality of Life
Inspire 0 Educate 4 Involve • Communicate 4
EQUIPMENT REPLACEMENT PLAN
2012-2016
TABLE OF CONTENTS
Paqe
City Manager's Message
Table of Contents 2
Introduction
Background and Summary of Changes from 2011 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 101
Equipment and Building Inventory
Vehicle and Equipment Inventory 107
Building Inventory 111
2
•
•
•
INTRODUCTION
0
0
EQUIPMENT REPLACEMENT PLAN 2012-2016 0
BACKGROUND AND SUMMARY OF CHANGES FROM 2011 PLAN
Back 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
$827,500.
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%. 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 2011 with a 3% increase and continuing forward with increases
from 5-7% over the next 5 years.
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 will be discussed at length during 2011-2012 leading
up to the preparation of the 2013 ERP in the summer of 2012. In the 2012-2016 ERP we have
plans for a 5% increase in rates for 2012, 6% for 2013 and 7% for 2014-2016. In addition
approximately 5 pieces of equipment will be purchased on a capital lease option allowing us to
level the expenditures over 10 years and smooth out the funding needs. Copiers that formerly
were purchased are now being leased over a 5 year period and have been removed from the ERP.
The lease payments are now included in departmental budgets.
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
4
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 2011 Plan
Highlights of changes from last year's equipment replacement plan for the years 2012-2016:
Activity Center: Copier due in 2013 for purchase was changed to a lease and will be
budgeted in this department within the General Fund.
Arts Center: The cost of the carpet extractor scheduled for 2012 has changed from
$3,300 to $3,900.
Video Camera Updates — added in 2012 at a cost of $3,200
City Hall: Network Core Switch was added in 2012 at a cost of $12,000. This
item provides the backbone on which all network communication is
built. The current device is obsolete and no longer supported by the
manufacturer.
Community Services: Engineering copier/scanner lease of $10,000 has been moved to the
General Fund, Engineering Dept.
Election equipment of $50,000 was added in 2013 as Hennepin
County has scheduled replacement of all county wide ballot scanners
and ballot boxes, Hopkins has 9.
Fire: The Quick Attack Pumper at a cost of $234,000 was moved from 2012
to 2022.
Workout dumbbells scheduled for 2012 at a cost of $5,000 were
moved to 2014
HRA: There were no changes to HRA items in this CIP.
Pavilion: There were no changes to Pavilion items in this CIP.
Parking: Added Mobile Date Computer in 2013 at a cost of $5,700
Police: Mobile Data Cameras scheduled for 2012 at a cost of $62,700 moved
to 2013.
In 2013, added LOGIS Computer System of $200,000 to allow our
department to communicate our information with other Police
Departments and provide for emergency redundancy between
departments.
5
The cost of the Digital Squad Car Cameras scheduled for 2014 were
increased by $10,800 to $53,400.
The cost of the Police Services Liaison vehicle scheduled for 2015 was
increased by $3,000 to $25,000
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 15
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.
Parks/Forestry
The '/z ton pickup originally scheduled for replacement in 2011 was
moved back to 2012 and now moved again to 2013 as its condition
warranted extension of its life.
The 3/ ton pickup originally scheduled for replacement in 2011 was
moved back to 2012 and now moved again to 2013 as its condition
warranted extension of its life . The life of this truck was extended
from 10 to 14 years. 0
Riding Mower originally scheduled for replacement in 2011 was
moved back to 2013 as its condition warranted extension of its life. In
addition another riding lawn mower scheduled for 2013 was pushed
back to 2014.
Trusksteer originally scheduled for replacement in 2011 was moved
back to 2013 as its condition warranted extension of its life.
A Grass Seed Applicator was added in 2012 at a cost of $7,400. The
previous overseeder was sold two years ago due to it's poor condition
and was not in the ERP for replacement.
Streets/Traffic
The tandem dump truck (item 01 -ERP -306) originally scheduled for
replacement in 2013 at a cost of $142,400 was deleted and a single
axel dump truck was added in 2012 at a cost of $127,400. This
changes the trucks to 1 tandem (previously 2) and 3 single axel dump
trucks (previously 2).
The cost of the one ton traffic boom truck scheduled for 2012 was
increased by $7,500 to $82,500. is
9
In 2012 an asphalt hot mix box was added at a cost of $15,500. We
currently do not have a hot mix box and this will allow the hot mix
that is picked up in the morning to stay pliable throughout the day as
the mix is used and minimize hot mix waste.
The roller used for asphalt repair was moved from 2012 to 2014. The
cost of this equipment totals $45,900.
Refuse
There were no changes to refuse department items in this CIP.
Water
There were no changes to water department items in this CIP.
Sewer
There were no changes to sewer department items in this CIP.
•
0
CASH FLOW STATEMENT
•
C
•
lampact on General Fund
Rate Change
Working Capital Begin Year
Revenues from charges
Transfer In - Pavilion - Capital Lease
Transfer In - Pavilion - Hockey Loan
Interest earnings
Other revenues (sale of assets)
Lease Financing
Total Revenues
Expenditures (excludes Depr.) (1)
Fire Truck Financing Pymnts (2009-2018)
Finance 6 items - annual finance cost
Eliminate 2 copiers in 2013 and lease
Capital Outlay - Equipment
Working Capital Ending Balance
Cash balance
EQUIPMENT REPLACEMENT FUND (602) 06/30/2011
(1) Expenditures included copier and engineering scanner lease up until 2011.
Beginning in 2011 for the copiers and 2012 for the scanners the responsible fund and department budgets for the lease
0
•
9
14,591
18,830
23,288
24,916
26,662
2%
3%
5%
6%
7%
7%
7%
ACTUAL
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
2010
2011
2012
2013
2014
2015
2016
1,161,011
921,830
919,117
1,110,595
505,553
305,089
156,044
292,867
301,653
316,736
335,740
359,242
384,388
411,296
20,000
20,000
20,000
15,609
3,143
3,143
3,143
3,143
3,142
6,719
9,293
9,266
11,180
5,130
3,125
1,635
13,760
25,000
25,000
25,000
30,000
30,000
30,000
600,000
336,489
359,089
974,144
390,672
397,514
417,514
442,931
24,743
25,485
18,250
18,798
19,361
19,942
20,541
53,891
54,217
54,217
54,217
54,217
54,217
54,217
77,000
77,000
77,000
77,000
(35,000)
497,036
282,100
710,200
880,700
447,400
415,400
415,200
575,670
361,802
782,667
995,714
597,978
566,559
566,957
921,830
919,117
1,110,595
505,553
305,089
156,044
32,018
929,273
916,560
1,118,038
512,996
312,532
163,487
39,461
(1) Expenditures included copier and engineering scanner lease up until 2011.
Beginning in 2011 for the copiers and 2012 for the scanners the responsible fund and department budgets for the lease
0
•
9
Fa') Q) �_
7 cn Q
C C (0
> Q U
W c
� � L
O
o H
❑ ■ ❑
O O O
O O O
O O O
O O O
O LO
04 N
CD
N
O
N
V
0
N
M
O
N
N
O
N
C)
N
0
0
N
rn
O
O
N
W
O
cli
O
O
O
N
C)
O
O
N
LIDO
O
N
V
O
O
N
M
O
O
N
N
O
O
N
O
O
N
O
O
O
N
O
O
O
O
O
0
•
•
•
FIVE-YEAR
PROJECT SUMMARIES
w
City of Hopkins, MN
EQUIPMENT IMPRO FEMENT PLAN
2012 tllrt, 2016
PROJECTS BY YEAR
Project Name
Department
Project #
PrioritN'
Project Cost
2012
Art Center Carpet Extractor
Arts Center
01 -ERP -7707
n/a
3,900
Art Center Video Camera Updates
Arts Center
01 -ERP -1103
n/a
3,200
Network Server
City Hall Administration
01 -ERP -0003
n/a
8,000
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
Core Network Switch
City Hall Administration
01 -ERP -0072
n/a
10,000
City Hall Main Copy Machine - Konica Copier
Community Services
01 -ERP -0007
n/a
0
Document Management Scanner (3)
Community Services
07 -ERP -0008
n/a
6,500
Aerial Truck
Fire
07 -ERP -0706
n/a
54,217
Extrication Tool (2)
Fire
07 -ERP -0709
n/a
22,300
Workout Equipment - Treadmill
Fire
07 -ERP -0118
n/a
5,000
Marked Patrol Vehicles (6)
Police
07 -ERP -0200
n/a
69,200
Police Administrative Vehicles (2)
Police
07 -ERP -0204
n/a
28,800
Network Server (3)
Police
07 -ERP -0211
n/a
8,500
Radios - Portable and Mobile Devices
Police
07 -ERP -0275
n/a
15,000
911 Phone System (Viper Phone)
Police
07 -ERP -0276
n/a
0
Engineering Printer/Scanner
Public Works: Engineering
01 -ERP -0701
n/a
0
44 3/4Ton Trucks (2)
Public Works: Parks/Forestry
01 -ERP -0801
n/a
67,400
Grass Seed Applicator (Overseeder)
Public Works: Parks/Forestry
01 -ERP -0877
n/a
7,400
1 Ton Dump Truck (2)
Public Works: Streets/Traffic
07 -ERP -0303
n/a
34,700
1 Ton Traffic Boom Truck
Public Works: Streets/Traffic
01 -ERP -0304
n/a
82,500
Single Axle Dump Truck (3)
Public Works: Streets/Traffic
01 -ERP -0305
n/a
127,400
Front End Loaders (2)
Public Works: Streets/Traffic
07 -ERP -0308
n/a
172,000
Asphalt Hot Mix Heating Box
Public Works: Streets/Traffic
01 -ERP -0378
n/a
15,500
Total for 2012
771,517
2013
Activity Center Copy Machine
Activity Center
01 -ERP -0030
n/a
0
Art Center Kitchen Catering Equipment
Arts Center
01 -ERP -7702
n/a
5,000
Network Server
City Hall Administration
07 -ERP -0003
n/a
8,000
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
City Hall Main Copy Machine - Konica Copier
Community Services
01 -ERP -0007
n/a
0
City Hall Small Copy Machine - Ricoh Copier
Community Services
07 -ERP -0002
n/a
0
Document Management Scanner (3)
Community Services
07 -ERP -0008
n/a
6,500
Election Equipment
Community Services
07 -ERP -0011
n/a
50,000
Aerial Truck
Fire
07 -ERP -0706
n/a
54,217
Thermal Imaging Camera (2)
Fire
07 -ERP -0772
n/a
11,500
Marked Patrol Vehicles (6)
Police
07 -ERP -0200
n/a
71,200
Police Administrative Vehicles (2)
Police
07 -ERP -0204
n/a
29,600
LOGIS Computer System
Police
07 -ERP -0208
n/a
200,000
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Mobile Data Computers
Police
07 -ERP -0272
n/a
62,700
Tactical Ballistic Vests
Police
07 -ERP -0274
n/a
23,200 •
Radios - Portable and Mobile Devices
Police
07 -ERP -0275
n/a
15,000
Engineering Van
Public Works: Engineering
01 -ERP -0700
n/a
21,500
Ehursda ' Am, 30. 1011
12
Project Name Department Project # Priority Project Cost
Engineering Printer/Scanner
Public Works: Engineering
07 -ERP -0707
n/a
0
112 Ton Pickup Truck
Public Works: Parks/Forestry
01 -ERP -0800
n/a
26,400
3/4 Ton Utility Truck
Public Works: Parks/Forestry
07 -ERP -0802
n/a
32,200
Trucksters (3)
Public Works: Parks/Forestry
07 -ERP -0807
n/a
19,800
Riding Mowers (3)
Public Works: Parks/Forestry
07 -ERP -0808
n/a
22,800
Brush Chipper
Public Works: Parks/Forestry
07 -ERP -0813
n/a
25,700
4X4 3/4 Ton Truck with Plow
Public Works: Streets/Traffic
01 -ERP -0301
n/a
30,400
Sweeper
Public Works: Streets/Traffic
01 -ERP -0311
n/a
156,400
Backhoe Loader
Water
01 -ERP -0502
n/a
134,800
Total for 2013
1,045,417
2014
Network Server
City Hall Administration
01 -ERP -0003
n/a
8,000
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
City Hall Main Copy Machine - Konica Copier
Community Services
07 -ERP -0001
n/a
0
Document Management Scanner (3)
Community Services
01 -ERP -0008
n/a
6,500
Aerial Truck
Fire
07 -ERP -0106
n/a
54,217
Automated External Defibrillator (2)
Fire
01 -ERP -0720
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
Ice Resurfacer
Pavilion
07 -ERP -7000
n/a
180,000
Electric Ice Edger
Pavilion
07 -ERP -7001
n/a
5,000
Marked Patrol Vehicles (6)
Police
01 -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 -0210
n/a
36,900
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Digital Squad Car Cameras
Police
01 -ERP -0213
n/a
53,400
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
15,000
Engineering Printer/Scanner
Public Works: Engineering
07 -ERP -0701
n/a
0
Riding Mowers (3)
Public Works: Parks/Forestry
07 -ERP -0808
n/a
30,600
Roller
Public Works: Streets/Traffic
07 -ERP -0312
n/a
45,900
Asphalt Paver
Public Works: Streets/Traffic
01 -ERP -0314
n/a
48,800
Refuse Truck (Rear -L)
Refuse
01 -ERP -0901
n/a
101,600
44 3/4 Ton Truck
Sewer
07 -ERP -0550
n/a
35,700
Total for 2014
836,917
20�
Network Server
City Hall Administration
01 -ERP -0003
n/a
8,000
Telephone System
City Hall Administration
01 -ERP -0004
n/a
89,600
Computers
City Hall Administration
07 -ERP -0006
n/a
30,000
City Hall Main Copy Machine - Konica Copier
Community Services
01 -ERP -0007
n/a
0
Document Management Scanner (3)
Community Services
01 -ERP -0008
n/a
6,500
Duty Chief Vehicle
Fire
01 -ERP -0103
n/a
37,000
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Workout Equipment - Eliptical
Fire
01 -ERP -0776
n/a
5,800
Workout Equipment - Summit Trainer
Fire
01 -ERP -0777
n/a
5,800
Workout Equipment - Weight Lifting
Fire
01 -ERP -0179
n/a
5,800
44 3/4 Ton Truck
HRA
07 -ERP -0400
n/a
32,400
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
75,600
Sergeant's Vehicle
Police
01 -ERP -0207
n/a
37,800
Police Administrative Vehicles (2)
Police
07 -ERP -0204
n/a
31,400
Police Services Liaison Vehicle
Police
07 -ERP -0206
n/a
25,000
Network Server (3)
Police
07 -ERP -0277
n/a
8,500
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
15,000
l'hursday. June 30, 2011
13
Project Name Department Project # Priority Project Cost
Engineering Printer/Scanner
Public Works: Engineering
07 -ERP -0707
n/a
0
4x4 3/4 Ton Pickup with Plow
Public Works: Streets/Traffic
07 -ERP -0300
n/a
33,600
Sign Machine (Traffic)
Public Works: Streets/Traffic
01 -ERP -0377
n/a
13,400 •
Refuse Truck (RAP -R) (2)
Refuse
07 -ERP -0900
n/a
204,800
Public Works Copy Machine
Water
07 -ERP -0506
n/a
14,200
Total for 2015
734,417
20�
Network Server
City Hall Administration
07 -ERP -0003
n/a
8,000
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
City Hall Main Copy Machine - Konica Copier
Community Services
07 -ERP -0001
n/a
0
Document Management Scanner (3)
Community Services
01 -ERP -0008
n/a
6,500
Fire Utility Vehicle (Pick Up Truck)
Fire
01 -ERP -0705a
n/a
35,000
Aerial Truck
Fire
01 -ERP -0706
n/a
54,217
Floor Scrubber
Fire
07 -ERP -0714
n/a
10,400
Floor Sweeper
Fire
07 -ERP -0115
n/a
3,900
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
07 -ERP -0204
n/a
32,400
H.E.A.T. 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 -0271
n/a
8,500
Radios - Portable and Mobile Devices
Police
07 -ERP -0275
n/a
15,000
Engineering Printer/Scanner
Public Works: Engineering
01 -ERP -0701
n/a
0
Tractor
Public Works: Parks/Forestry
01 -ERP -0806
n/a
49,300
Slope Mower
Public Works: Parks/Forestry
07 -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 -0375
n/a
102,300
3/4 Ton Utility Truck
Sewer
07 -ERP -0557
n/a
33,600
Total for 2016
620,817
GRAND TOTAL
4,009,085
1hur iaY. Jim(, 30. 2011
14
City of Hopkins, MN
• EQUIPMENT IMPROVEMENT PLAN
2012 thru 2016
•
DEPARTMENT SUMMARY
Department
2012
2013
2014
2015
2016
Total
Activity Center
0
0
Arts Center
7,100
5,000
12,100
City Hall Administration
48,000
38,000
38,000
127,600
38,000
289,600
Community Services
6,500
56,500
6,500
6,500
6,500
82,500
Fire
81,517
65,717
66,417
108,617
103,517
425,785
HRA
13,000
32,400
45,400
Pavilion
185,000
185,000
Police
121,500
410,200
265,400
193,300
213,000
1,203,400
Public Works: Engineering
0
21,500
0
0
0
21,500
Public Works: Parks/Forestry
74,800
126,900
30,600
82,000
314,300
Public Works: Streets/Traffic
432,100
186,800
94,700
47,000
144,200
904,800
Refuse
101,600
204,800
306,400
Sewer
35,700
33,600
69,300
Water
134,800
14,200
149,000
TOTAL 771,517 1,045,417 836,917 734,417 620,817 4,009,085
15 Thursday, June 30, 2011
City of Hopkins, MN
EQUIPMENT IMPROFF.AJENT PLAN
2012 11111, 2016
PROJECTS BY DEPARTMENT
Department
Project#
PrioritN
2012
2013
2014
2015
2016
Total
Activity Center
Activity Center Copy Machine
07 -ERP -0030
n/a
0
0
Activity Center Total
0
0
Arts Center
Art Center Carpet Extractor
07 -ERP -1107
n/a
3,900
3,900
Art Center Kitchen Catering Equipment
O1 -ERP -7702
n/a
5,000
5,000
Art Center Video Camera Updates
07 -ERP -7103
n/a
3,200
3,200
Arts Center Total
7,100
5,000
12,100
City Hall Administration
Network Server
07 -ERP -0003
n/a
8,000
8,000
8,000
8,000
8,000
40,000
Telephone System
07 -ERP -0004
n/a
89,600
89,600
Computers
07 -ERP -0006
n/a
30,000
30,000
30,000
30,000
30,000
750,000
Core Network Switch
01 -ERP -0072
n/a
10,000
10,000
City Hall Administration Total
48,000
38,000
38,000
127,600
38,000
289,600
Community Services
City Hall Main Copy Machine - Konica Copier
01 -ERP -0001
n/a
0
0
0
0
0
0
City Hall Small Copy Machine - Ricoh Copier
07 -ERP -0002
n/a
0
0
Document Management Scanner (3)
07 -ERP -0008
n/a
6,500
6,500
6,500
6,500
6,500
32,500
Election Equipment
07 -ERP -0077
n/a
50,000
50,000
Community Services Total
6,500
56,500
6,500
6,500
6,500
82,500
Fire A
Duty Chief Vehicle
07 -ERP -0703
n/a
37,000
37,000
Fire Utility Vehicle (Pick Up Truck)
01 -ERP -0705a
n/a
35,000
35,000
Aerial Truck
01 -ERP -0706
n/a
54,217
54,217
54,217
54,217
54,217
277,085
Extrication Tool (2)
07 -ERP -0709
n/a
22,300
22,300
Thermal Imaging Camera (2)
07 -ERP -0772
n/a
11,500
77,500
Floor Scrubber
07 -ERP -0774
n/a
10,400
70,400
Floor Sweeper
01 -ERP -0175
n/a
3,900
3,900
Workout Equipment - Eliptical
07 -ERP -0776
n/a
5,800
5,800
Workout Equipment - Summit Trainer
07 -ERP -0777
n/a
5,800
5,800
Workout Equipment - Treadmill
07 -ERP -0178
n/a
5,000
5,000
Workout Equipment - Weight Lifting
07 -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 -0722
n/a
5,000
5,000
Fire Total
81,517
65,717
66,417
108,617
103,517
425,785
16
Thurcdur,
June 30, 2011
Department Project# Priority 2012 2013 2014 2015 2016 Total
IHRA
32,400
73,000
13,000 32,400
45,400
180,000
5,000
180,000
5,000
44 3/4 Ton Truck
01 -ERP -0400
n/a
HRA Copier
01 -ERP -0401
n/a
HRA Total
0 0
21,500
(Pavilion
27,200
27,200
Ice Resurfacer
07 -ERP -1000
n/a
Electric Ice Edger
01 -ERP -1001
n/a
Pavilion Total
29,600
30,500
Police
32,400
152,700
Marked Patrol Vehicles (6)
01 -ERP -0200
n/a
Sergeants Vehicle
01 -ERP -0201
n/a
Parking Enforcement Vehicle (Parking Fund)
01 -ERP -0202
n/a
Utility 44 (unit 212)
07 -ERP -0203
n/a
Police Administrative Vehicles (2)
01 -ERP -0204
n/a
H.E.A.T. Vehicle
01 -ERP -0205
n/a
Police Services Liaison Vehicle
07 -ERP -0206
n/a
LOGIS Computer System
01 -ERP -0208
n/a
Copy Machine - Police Dept
07 -ERP -0209
n/a
Logging Recorder
01 -ERP -0210
n/a
Network Server (3)
07 -ERP -0211
n/a
Mobile Data Computers
01 -ERP -0212
n/a
•Digital Squad Car Cameras
01 -ERP -0213
n/a
Tactical Ballistic Vests
07 -ERP -0274
n/a
Radios - Portable and Mobile Devices
01 -ERP -0215
n/a
911 Phone System (Viper Phone)
01 -ERP -0216
n/a
Police Total
23,200
Public Works: Engineering
23,200
Engineering Van
07 -ERP -0700
n/a
Engineering Printer/Scanner
01 -ERP -0701
n/a
Public Works: Engineering Total
Public Works: Parks/Forestry
0
1/2 Ton Pickup Truck
07 -ERP -0800
n/a
44 3/4Ton Trucks (2)
07 -ERP -0801
n/a
3/4 Ton Utility Truck
07 -ERP -0802
n/a
Tractor
01 -ERP -0806
n/a
Trucksters (3)
01 -ERP -0807
n/a
Riding Mowers (3)
01 -ERP -0808
n/a
Slope Mower
01 -ERP -0809
n/a
Brush Chipper
07 -ERP -0813
n/a
Grass Seed Applicator (Overseeder)
07 -ERP -0817
n/a
Public Works: Parks/Forestry Total
OPublic Works: Streets/Traffic
44 314 Ton Pickup with Plow
01 -ERP -0300
n/a
4X4 3/4 Ton Truck with Plow
07 -ERP -0307
n/a
32,400
13,000
32,400
73,000
13,000 32,400
45,400
180,000
5,000
180,000
5,000
185,000
185,000
69,200
71,200
73,400
75,600
77,800
367,200
0
0
0 0
37,800
0
37,800
0
0 0
21,500
27,200
27,200
26,400
47,700
47,700
28,800
29,600
30,500
31,400
32,400
152,700
49,300
30,000
30,000
19,800
25,000
25,000
30,600
200,000
53,400
200,000
32,700
32,700
25,700
22,100
22,100
25,700
7,400
36,900
36,900
8,500
8,500
8,500
8,500
8,500
42,500
62,700
62,700
53,400
53,400
23,200
23,200
15,000
15,000
15,000
15,000
15,000
75,000
0
0
121,500
410,200
265,400
193,300
213,000
1,203,400
33,600
30,400
33,600
30,400
17 7hurerlay. June 30. 2011
21,500
21,500
0
0
0
0 0
0
0
21,500
0
0 0
21,500
26,400
26,400
67,400
67,400
32,200
32,200
49,300
49,300
19,800
19,800
22,800
30,600
53,400
32,700
32,700
25,700
25,700
7,400
7,400
74,800
126,900
30,600
82,000
314,300
33,600
30,400
33,600
30,400
17 7hurerlay. June 30. 2011
Department
Project#
Prioritc
2012
2013
2014
2015
2016
Total
1 Ton Dump Truck (2)
07-ERP-0303
n/a
34,700
34,700
1 Ton Traffic Boom Truck
07-ERP-0304
n/a
82,500
82,500
Single Axle Dump Truck (3)
07-ERP-0305
n/a
127,400
127,400
Front End Loaders (2)
07-ERP-0308
n/a
172,000
772,000
Skid Loader (2)
01-ERP-0309
n/a
41,900
41,900
Sweeper
07-ERP-0311
n/a
156,400
756,400
Roller
01-ERP-0312
n/a
45,900
45,900
Asphalt Paver
07-ERP-0374
n/a
48,800
48,800
Snow Blower
07-ERP-0375
n/a
102,300
702,300
Sign Machine (Traffic)
07-ERP-0377
n/a
13,400
13,400
Asphalt Hot Mix Heating Box
01-ERP-0318
n/a
15,500
15,500
Public Works: Streets/Traffic Total
432,100
186,800
94,700
47,000
144,200
904,800
Refuse
Refuse Truck (RAP-R) (2)
01-ERP-0900
n/a
204,800
204,800
Refuse Truck (Rear-L)
07-ERP-0907
n/a
101,600
101,600
Refuse Total
101,600
204,800
306,400
Sewer
I
44 3/4 Ton Truck
07-ERP-0550
n/a
35,700
35,700
3/4 Ton Utility Truck
01-ERP-0557
n/a
33,600
33,600
Sewer Total
35,700
33,600
69,300
Water
jl
•
Backhoe Loader
07-ERP 0502
n/a
134,800
734,800
Public Works Copy Machine
07-ERP-0506
n/a
14,200
14,200
Water Total
134,800
14,200
149,000
GRAND TOTAL
771,517
1,045,417
836,917
734,417
620,817
4,009,085
18
1111ir dal. Junr 30, 3U17
•
City of Hopkins, MN
EQUIPMENT IMPROVEMENT PLAN
i 2012 auu 2016
U
•
FUNDING SOURCE SUMMARY
Source
2012
2013
2014
2015
2016
Total
AC - Arts Center Fund
7,100
5,000
12,100
Bonds/Lease
54,217
54,217
54,217
54,217
54,217
271,085
Equipment Replacement Fund
710,200
845,700
447,400
415,200
533,000
2,951,500
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
76,100
WF - Water Fund
134,800
21,000
155,800
GRAND TOTAL 771,517 1,045,417 836,917 734,417 620,817 4,009,065
19
Thursday, June 30, 2011
City of Hopkins, MN
EO 1PR0FEMENT PLAN
2012 thru 2016
PROJECTS BY FUNDING SOURCE
Source Project# Priorit.N 2012 2013 2014 2015 2016 Total
AC - Arts Center Fund 1
Art Center Carpet Extractor
01 -ERP -7707
n/a
3,900
3,900
Art Center Kitchen Catering Equipment
07 -ERP -7702
n/a
5,000
5,000
Art Center Video Camera Updates
01 -ERP -1103
n/a
3,200
3,200
AC - Arts Center Fund Total
7,100
5,000
12,100
Bonds/Lease
Aerial Truck
07 -ERP -0706
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
City Hall Main Copy Machine - Konica Copier
07 -ERP -0007
n/a
0
0
0
0
0
0
City Hall Small Copy Machine - Ricoh Copier
07 -ERP -0002
n/a
0
0
Network Server
07 -ERP -0003
n/a
8,000
8,000
8,000
8,000
8,000
40,00010
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
750,000
Document Management Scanner (3)
O1 -ERP 0008
n/a
6,500
6,500
6,500
6,500
6,500
32,500
Election Equipment
O1 ERP -0017
n/a
50,000
50,000
Core Network Switch
07 -ERP -0012
n/a
10,000
10,000
Activity Center Copy Machine
07 -ERP -0030
n/a
0
0
Duty Chief Vehicle
07 -ERP -0703
n/a
37,000
37,000
Fire Utility Vehicle (Pick Up Truck)
01 -ERP -0705a
n/a
35,000
35,000
Extrication Tool (2)
07 -ERP -0709
n/a
22,300
22,300
Thermal Imaging Camera (2)
07 -ERP -0772
n/a
11,500
71,500
Floor Scrubber
07 -ERP -0114
n/a
10,400
70,400
Floor Sweeper
07 -ERP -0775
n/a
3,900
3,900
Workout Equipment - Eliptical
01 -ERP -0776
n/a
5,800
5,800
Workout Equipment - SummitTrainer
07 -ERP -0117
n/a
5,800
5,800
Workout Equipment - Treadmill
07 -ERP -0118
n/a
5,000
5,000
Workout Equipment- Weight Lifting
07 -ERP -0179
n/a
5,800
5,800
Automated External Defibrillator (2)
01 -ERP -0720
n/a
7,200
7,200
Workout Equipment - Dumb Bells
07 -ERP -0722
n/a
5,000
5,000
Marked Patrol Vehicles (6)
07 -ERP -0200
n/a
69,200
71,200
73,400
75,600
77,800
367,200
Sergeants 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)
07 -ERP -0203
n/a
47,700
47,700
Police Administrative Vehicles (2)
07 -ERP -0204
n/a
28,800
29,600
30,500
31,400
32,400
752,700
H.E.A.T. Vehicle
07 -ERP -0205
n/a
30,000
30,000
Police Services Liaison Vehicle
07 -ERP -0206
n/a
25,000
25,000
LOGIS Computer System
07 -ERP -0208
n/a
200,000
200,0000
Copy Machine - Police Dept
07 -ERP -0209
n/a
22,100
22,700
Logging Recorder
01 -ERP -0270
n/a
36,900
36,900
Hirci dm
-lun, 311. 2011
20
Source Project# Priority 2012 2013 2014 201.5 2016 Total
Network Server (3)
01 -ERP -0211
n/a
8,500
8,500
8,500
8,500
8,500
42,500
Mobile Data Computers
01 -ERP -0212
n/a
57,000
57,000
Digital Squad Car Cameras
01 -ERP -0213
n/a
53,400
53,400
Tactical Ballistic Vests
01 -ERP -0214
n/a
23,200
23,200
Radios - Portable and Mobile Devices
01 -ERP -0215
n/a
15,000
15,000
15,000
15,000
15,000
75,000
911 Phone System (Viper Phone)
01 -ERP -0216
n/a
0
0
44 3/4 Ton Pickup with Plow
01 -ERP -0300
n/a
33,600
33,600
4X4 3/4 Ton Truck with Plow
01 -ERP -0301
n/a
30,400
30,400
1 Ton Dump Truck (2)
01 -ERP -0303
n/a
34,700
34,700
1 Ton Traffic Boom Truck
01 -ERP -0304
n/a
82,500
82,500
Single Axle Dump Truck (3)
01 -ERP -0305
n/a
127,400
127,400
Front End Loaders (2)
01 -ERP -0308
n/a
172,000
172,000
Skid Loader (2)
01 -ERP -0309
n/a
41,900
41,900
Sweeper
01 -ERP -0311
n/a
156,400
156,400
Roller
01 -ERP -0312
n/a
45,900
45,900
Asphalt Paver
01 -ERP -0314
n/a
48,800
48,800
Snow Blower
01 -ERP -0315
n/a
102,300
102,300
Sign Machine (Traffic)
01 -ERP -0317
n/a
13,400
13,400
Asphalt Hot Mix Heating Box
01 -ERP -0318
n/a
15,500
15,500
Engineering Van
01 -ERP -0700
n/a
21,500
21,500
Engineering Printer/Scanner
01 -ERP -0701
n/a
0
0
0
0
0
0
1/2 Ton Pickup Truck
01 -ERP -0800
n/a
26,400
26,400
4x4 3/4Ton Trucks (2)
01 -ERP -0801
n/a
67,400
67,400
3/4 Ton Utility Truck
01 -ERP -0802
n/a
32,200
32,200
Tractor
01 -ERP -0806
n/a
49,300
49,300
Trucksters (3)
01 -ERP -0807
n/a
19,800
19,800
Mowers (3)
01 -ERP -0808
n/a
22,800
30,600
53,400
•Riding
Slope Mower
01 -ERP -0809
n/a
32,700
32,700
Brush Chipper
01 -ERP -0813
n/a
25,700
25,700
Grass Seed Applicator (Overseeder)
01 -ERP -0817
n/a
7,400
7,400
Equipment Replacement Fund Total
710,200
845,700
447,400
415,200
533,000
2,951,500
HRA - Housing and Redevelopment A
4x4 314 Ton Truck
01 -ERP -0400
n/a
32,400
32,400
HRA Copier
01 -ERP -0401
n/a
13,000
13,000
HRA - Housing and Redevelopment
13,000
32,400
45,400
Authority Total
PA - Pavilion Fund
Ice Resurfacer
01 -ERP -1000
n/a
180,000
180,000
Electric Ice Edger
01 -ERP -1001
n/a
5,000
5,000
PA - Pavilion Fund Total
185,000
185,000
PKG - Parking Fund
Mobile Data Computers
01 -ERP -0212
n/a
5,700
5,700
PKG - Parking Fund Total
5,700
5,700
_ RF - Refuse Fund
Refuse Truck (RAP -R) (2)
01 -ERP -0900
n/a
204,800
204,800
Thursday, June 30, 2011
21
Source Project# PrioritN 2012 2013 2014 2015 2016 Total
Refuse Truck (Rear -L)
07 -ERP -0907
n/a
101,600
707,600
RF - Refuse Fund Total
101,600
204,800
306,400
SF - Sanitary Sewer Fund
Telephone System
01 -ERP -0004
n/a
6,800
6,800
44 3/4 Ton Truck
01 -ERP -0550
n/a
35,700
35,700
3/4 Ton Utility Truck
01 -ERP -0557
n/a
33,600
33,600
SF - Sanitary Sewer Fund Total
35,700
6,800 33,600
76,100
WF - Water Fund
Telephone System
07 -ERP -0004
n/a
6,800
6,800
Backhoe Loader
07 -ERP -0502
n/a
134,800
734,800
Public Works Copy Machine
01 -ERP -0506
n/a
14,200
14,200
WF - Water Fund Total
134,800
21,000
155,800
GRAND TOTAL 771,517 1,045,417 836,917 734,417 620,817 4,009,085
lhur�d«r..hir�� ,ll. 'UIl
`PA
•
0
•
:7
EQUIPMENT REQUESTS
23
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
1pp,r.ojj
ect # 01 -ERP -0001
ect Name City Hall Main Copy Machine - Konica Copier
2012 ,i„„ 2016
Type Equipment Department Comnwnity Ser6ces
Useful Life 5 years Contact City Clerk
Category Equipment Priorit.N n a
Future
Description Total Project ( ost• $107,200
Copy machine to service needs of all departments located at City Hall.
1. Variety of copying tasks.
2. High volume product copier.
Note: equipment is leased. - 2011 Konica Minolta bizhub C652DS
--- lease in being charged to General Fund Inventory - NOT the ERP and allocated to City Hall Departments.
Intention is to either renew the lease after 5 years or replace copier with another one on a 5 year lease.
Justification
Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports.
council reports and updates, city code revisions, various department reports, and hearing and information notices.
Machine will duplex, sort, collate and staple copies.
Variance from 20 year plan - copier was to be replaced in 2011 but instead it is leased and expensed to the General
Fund.
Estimate salvage/resale value on replaced item: $-0-
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
—107,-20-01 Equipment 0 0 0 0 0 0
Total Total 0 0 0 0 0 0 Total
Prior Funding Sources
F--10-7-,2-0-01 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
0 0 0 0 0
0 0 0 0 0
24
•
Total Future
0 0
0 Total
1hnrvdw Juu< 31), '011
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0002
Project Name City Hall Small Copy Machine - Ricoh Copier
Type Equipment
Useful Life 5 years
Category Equipment
Future
Description
2012 thru 2016
Department Community Services
Contact City Clerk
Priority n/a
Total Project Cost: $43,200
Coyy machine to service needs of all departments located at City Hall.
1, Variety of copying tasks.
2. High volume product copier.
Note: This is a Ricoh color copier.
2006 Ricoh 5560G W
Justification
Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports,
council reports and updates, city code revisions, various department reports, and hearing and information notices.
Machine will duplex, sort, collate and staple copies.
Budget Impact/Other
Variance from 20 year plan - Cost reduced $6,900 due to pricing reductions. Move back to 2013.
Estimate salvage/resale value on replaced item: $2,500
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
7-43,-20-01 Equipment 0 0
Total Total 0 0 Total
Prior Funding Sources 2012
F--43-,2-0-01 Equipment Replacement Fund
Total Total
•
2013 2014 2015 2016 Total Future
0 0
0 0 Total
Thursday, June 30, 2011
25
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0003
Project Name Network Server
Type Equipment
Useful Life t year
Category Equipment
Future
Description
2012 au, 2016
Department City Hall Administration
Contact Finance Director'IT
Priorit.N TI a
Total Project Cost: $233,000
The network server is the hub of the network. New computers are faster and more reliable.
Justification
Networking allows user to share information that is stored in a single location, the network server. This is more
,fficient because the information does not have to be stored on many different computers. It also makes for better
tccuracy because as the information changes or is updated, every user is working with the same data.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
Prior
Expenditures
2012
2013
2014
2015
2016
Total
Future
73,000
Equipment
8,000
8,000
8,000
8,000
8,000
40,000
120,000
Total
Total 8,000
8,000
8,000
8,000
8,000
40,000
Total
Prior
73,000
Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 8,000 8,000 8,000 8,000 8,000 40,000 7 120,000
Total 8,000 8,000 8,000 8,000 8,000 40,000 Total
26
1h111 wl<n. J1111r in, 'n
EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016
City of Hopkins, MN
Project # 01 -ERP -0004
Project Name Telephone System
Type Equipment Department City Hall Administration
Useful Life 8 years Contact IT Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $349,900
Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions
served by this system. Also includes software for the PBX and voice mail systems.
Justification
Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information
services (snow line, etc.)
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: $
Prior Expenditures 2012 2013 2014
2015 2016
Total
Future
60,000 Equipment
89,600
89,600
200,300
Total Total
89,600
89,600
Total
Prior
60,000
Total
Funding Sources
Equipment Replacement Fund
SF - Sanitary Sewer Fund
WF - Water Fund
2012 2013 2014 2015 2016
76,000
6,800
6,800
Total
Future
76,000
200,300
6,800
Total
6,800
Total 89,600 89,600
27
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0006
Project Namc Computers
2012 2016
Type Equipment Department City Hall Administration
Useful Life 3-5 years Contact Finance Director IT
Category Equipment Priori(% n a
Future
Description I 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
Tools enabling staff to perform job responsibilities efficiently and effectively.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
Prior Expenditures 2012
2013 2014 2015
330,000 Equipment 30,000 30,000 30,000 30,000
Total Total 30,000 30,000 30,000 30,000
n
LJ
2016
Total
Future
30,000
150,000F---4-50—,0700
2015
30,000
150,000
Total
Prior
Funding Sources
2012
2013
2014
2015
2016
Total
Future
330,000
Equipment Replacement Fund
30,000
30,000
30,000
30,000
30,000
150,000
450,000
Total
Total
30,000
30,000
30,000
30,000
30,000
150,000
Total
L J
llnir,dur..lnnr 30. ?Illl
28
EQUIPMENT IMPROVEMENT PLAN 2012 ,n,,, 2016
City of Hopkins, MN
Project # 01 -ERP -0008
Project Name Document Management Scanner (3)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Description
Department Community Services
Contact City Clerk
Priority n/a
Total Project Cost: $156,000
Large document (11" x17') scanner for document management and retention as well as general administrative use.
Three scanners each replaced every three years.
One replaced in 2009, 2012, 2015....... — note we did not replace one in 2009; unit was repaired to extend the life.
One replaced in 2010, 2013, 2016.........
One replaced in 2011, 2014, 2017 .............
additional small scanner was added to the scanning station in 2009. This scanner previously was used by the
-ctions secretary. This scanner does not handle 11" x 17" paper so can not do all documents.
will be evaluated each vear for replacement. If scanners are
their life will be extended.
Justification
We have been getting up to three Tree Trust volunteers to work on scanning and the small scanner only handles
iocuments up to 8'/2" x 14". We would like to replace this scanner with a large document scanner to fully utilize our
Budget Impact/Other
Variance from 20 year plan - item scheduled for 2009 was not replaced. Unit was repaired to extend its life. One
additional scanner was added to the replacement shedule in 2010.
Estimate salvage/resale value on replaced item: $500-$1,000
Prior
Expenditures
2012
2013
2014
2015
2016
Total
Future
26,0001
Equipment
6,500
6,500
6,500
6,500
6,500
32,500
97,500
Total
Total 6,500
6,500
6,500
6,500
6,500
32,500
Total
Prior
Funding Sources
2012
2013
2014
2015
2016
Total
Future
L 26,000 Equipment Replacement Fund
Total Total
•
6,500 6,500 6,500 6,500 6,500 32,500 1 97,500
6,500 6,500 6,500 6,500 6,500 32,500 Total
29
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0011
Project Name Election Equipment
2012 ,i„„ 2016
Type Equipment Department Community Services
Useful Life 10 years ('ontact City Clerk
Category Equipment Priorit.N n a
Future
Description I I otal Project Cost: $117,200
Zeplace election M-100 ballot scanners and ballot boxes. - 9 machines total.
Justification I
k11 Hennepin County equipment is being replaced in 2013.
Budget Impact/Other
Variance from 20 year plan - New item.
Estimate salvage/resale value on replaced item: $-0-
C]
Expenditures 2012
2013 2014
2015 2016 Total
Future
Equipment
50,000
50,000
67,200
Total
50,000
50,000
Total
Funding Sources 2012 2013 2014 2015 2016
Equipment Replacement Fund 50,000
Total
50,000
30
Total
Future
50,000
67,200
50,000
Total
11110 �lur..Iunr 311. '011
EQUIPMENT IMPROVEMENT PLAN 2012,/,,.,/ 2016
City of Hopkins, MN
Project # 01 -ERP -0012
Project Name Core Network Switch
Type Equipment Department City Hall Administration
Useful Life 6 years Contact Finance Director/IT
Category Equipment Priority n/a
Future
Description
Total Project Cost: $53,300
Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network
communication is built and facilitates fibr optic network connection to fire department.
2 - Cisco 3560E-24PD managed switch - $3,000 each
2 - Cisco X2-IOGB-LR fiber optic transceiver - $1200 each
cost listed is forequipment onl and does not include tax, shipping and other related costs
Justification
two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in
Int network outage that was immediately noticed by many employees.
Variance from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside
the budget for city hall server network budget as the "Lisa" service is scheduled for replacement due to end of life, out
of PCI compliance and obsolete.
Estimate salvaize/resale value on replace item: - $-0-
•
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 10,000 10,000 43,300
Total 10,000 10,000 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 10,000 10,000 43,300
Total 10,000 10.000 1 Total
KE
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0030
Project Name Activity Center Copy Machine
2012aw„2016
Type Equipment Department Activity Center
Useful Life 7 years Contact Facilities Director
Category Equipment Priori(, n a
Future
Description Total Project Cost: $0
-opy machine used by staff for daily operations of the Hopkins Activity Center.
lCurrent equipment: Ricoh 2228C
Justification
Copy flyers, letters, forms, informational items, etc.
•
Budget hnpact/Other I 1
Variance from 20 year plan - None
Estimate salvage/resale value on replaced item:
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 0 0 0
Total 0 0 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 0 0
Total 0 0 Total
•
7hurvlm —how 30, 2011
32
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERR -0103
Project Name Duty Chief Vehicle
Type Equipment
Useful Life 5 years
Category Vehicles
Future
Description
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $254,200
2012 17 u 2016
marked passenger vehicle for use by the Duty Chief and Assistant Chiefs in transporting required equipment,
Ference materials and personnel for emergency response, and routine Fire Department business.
Curent vehicles: 2010 Chevrolet Tahoe (Chief)
2006 Dodge Durango (Asst. Chief)
Chevrolet Impala (Asst. Chief) to be replaced with 2015 SUV
Justification
Used 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 fire 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.
Budget Impact/Other
Variance from 20 year plan - Add 2 vehicles and change life to 15 years.
Estimate salvage/resale value on replaced item: $4,000
Prior
64,500
Total
Prior
64,500
Total
•
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 37,000 37,000 152,700
Total 37,000 37,000 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 37,000 37,000 152,700
Total 37,000 37,000 Total
33
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
-oject # 01 -ERP -0105a
*oject Name Fire Utility Vehicle (Pick Up Truck)
Type Equipment Department Fire
Useful Life 5 years Contact Firc Chief
Category Vehicles Priorit.N n a
Future
Description I Total Project Cost: $177,100
A pickup truck on a 4 wheel drive chassis.
Current vehicle: Lumina - used by Fire Inspector
Justification I
2012 ,i„„ 2016
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
nation. This vehicle would be used to haul equipment and personnel to and from the scene and can be used for people
;o go to schools.
Budget Impact/Other
Variance from 20 year plan - Change from 10 year life to 5 years.
Estimate of salvage/resale value on replace item - $
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 35,000 35,000 142,100
Total 35,000 35,000 Total
Funding Sources 2012 2013 2014 2015 2016
Equipment Replacement Fund
Total
35,000
35,000
0
Total
Future
35,000
142,100
35,000
Total
7hurcdur. J��nr ±tl. 3Ul J
34
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0106
Project Name Aerial Truck
Type Equipment
Useful Life 20 years
Category Vehicles
Future
Description
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $2,559,597
2012 rhi-t, 2016
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
Justification
Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using
$445,427.08 in ERP cash and a 10 -year capital lease of $425,000. At the end of the lease term payments (P&I) will
total $542,170. Total costs of aerial including cash payments equals $987,597.
Budget Impact/Other
Variance from 20 year plan - .Lease payments on financing added to the plan.
Estimate salvage/resale value on replaced item: $
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
F__60_8_,_0_7_8J Equipment 54,217 54,217 54,217 54,217 54,217 271,085 17680,434
Total Total 54,217 54,217 54,217 54,217 54,217 271,085 Total
Prior Funding Sources
2012
2013
2014
2015
2016
Total
Future
608,078 Bonds/Lease
54,217
54,217
54,217
54,217
54,217
271,085
1,680,434
Total
Total 54,217
54,217
54,217
54,217
54,217
271,085
Total
•
35
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0109
Project Name Extrication Tool (2)
Type Equipment
Useful Life 10 years
Category Equipment
Future
Departinew Firc
Contact Firc Chief
Priorit.N n a
2012 awn 2016
Description I Totarl Project Cost: $136,900
Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram.
•
Justification
X111 vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool wil be
idded to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost.
Budget Impact/Other
Variance from 20 year plan - move back from 2015 to 2019.
Estimate salvage/resale value on replaced item: $1,000
Purchased: 2007
Prior Expenditures 2012 2013 2014 2015 2016
20,300 Equipment 22,300
Total Total 22,300
Prior Funding Sources
20,300 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
22,300
22,300
36
Total
Future
22,300
94,300
22,300
Total
Total
Future
22,300
94,300
22,300
Total
l hur dw —1 um 30, 2011
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0112
Project Name Thermal Imaging, Camera (2)
Type Equipment
Useful Life 10 years
Category Equipment
Future
Description
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $72,200
2012 thru 2016
sed by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and
;at may be hidden allowing for faster extinguishment.
61I17.'ji►.IIIIy]
Justification
camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was
-d with donation money.
Budget Impact/Other
Variance from 20 year plan - department owns 2 cameras. Previously one one was included in the replacement plan.
This will add to the replacement schedule the camera purchased from the Fire Dept budget in 2003.
Estimate salvase/resale value on rei)alced item: $-0-
Prior Expenditures 2012
2013 2014
2015 2016 Total
Future
15,000 Equipment
11,500
11,50045,
700
Total Total
11,500
11,500
Total
Prior
15,000
Total
•
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 11,500 11,500 45,700
Total 11,500 11,500 Total
37
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Epp-r-ojj
ect # 01 -ERP -0114
ect Name Floor Scrubber
Type Equipment
Useful Life 12 years
Category Equipment
Future
Department Fite
Contact Fire Chid
Priority n a
2012 rh t, 2016
Description rotal Project Cost: $25,200
Floor scrubber to keep apparatus floors clean.
Justification
Scrubber is used to keep apparatus floors clean so that floor will last longer.
Budget hnpact/Other
Variance from 20 year plan -
Estimate salvage/resale value on replaced item: S
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 10,400 10,400 F 14,800
Total 10,400 10,400 Total
Funding Sources 2012 2013 2014 201.5 2016 Total Future
Equipment Replacement Fund 10,400 10,400 14,800
Total
38
10,400 10,400 Total
71111' dur. Junc° 31i
9
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0115
Project Name Floor Sweeper
Type Equipment
Useful Life 12 years
Category Equipment
Future
Description
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $9,400
2012 ai n„ 2016
Sweeper that is used to clean apparatus floor prior to using scurbber.
Justification
Sweeper is used to pick up debris before using scrubber. Sweeper uses less time to sweep floor.
Budget hnpact/Other
Variance from 20 year plan - new item
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013
2014 2015 2016
Total
Future
Equipment
3,900
3,900
7,500
Total
3,900
3,900
Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 3,900 3,900 5,500
Total 3,900 3,900 Total
Thursday, June 30, 2011
39
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0116
Project Name Workout Equipment - Elliptical
Type Equipment
Useful Life 6 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priorit.N n a
2012 2016
Description I Total Project Cost: $20,300
Workout equipment used in Fire Department workout room. One eliptical machine replaced on a 6 year cycle, one
;very 3 years.
Justification I
Chis equipment is available to all City employees for health and wellness.
Budget hnpact/Other
Variance from 20 year plan - had two eliptical machines in the ERP. One was 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: $
Expenditures 2012 2013
2014 2015 2016
Total
Future
Equipment
5,800
5,8007--1-4,-5700
14,500
Total
5,800
5,800
Total
Funding Sources 2012
2013 2014 2015 2016
Total
Future
Equipment Replacement Fund
5,800
5,800
14,500
Total
5,800
5,800
Total
1hursdur. Jum 30. 2011
40
0
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0117
Project Name workout Equipment - Summit Trainer
Type Equipment
Useful Life 5 years
Category Equipment
Future
Description
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $34,300
Workout equipment used in Fire Department workout room.
One summit trainer replaced on a 5 year cycle.
Current equipment : 2010 Summit Trainer
2012 thru 2016
Justification
This equipment is available to all City employees for health and wellness.
Variance from 20 year plan - replaces stairmaster.
Estimate salvage/resale value on replaced item: $
Prior Expenditures 2012
2013 2014 2015 2016
Total
Future
F-75—,00-01 Equipment
5,800
5,800
23,500
Total Total
5,800
5,800
Total
Prior Funding Sources 2012
2013 2014 2015 2016
Total
Future
5,000 Equipment Replacement Fund
5,800
5,800
23,500
Total Total
5,800
5,800
Total
L
41
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project# 01 -ERP -0118
Project Name Workout Equipment - Treadmill
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n a
Description I Total Project Cost: $25.300
Workout equipment used in the Fire Department workout room.
Dne treadmill replaced on a 5 year cycle.
2012 ,tt, tt 2016
I Justification
This equipment is available to all City employees for health and wellness.
Budget Impact/Other I
Variance from 20 year plan - move back one year from 2011 to 2012.
Estimate salvage/resale value on replaced item: S
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 5,000 5,000 20,300
Total 5,000 5,000 Total
•
Funding Sources
2012 2013
2014 2015 2016 Total
Future
Equipment Replacement Fund
5,000
5,000
20,300
Total
5,000
5,000
Total
lhmsrlur. Junr 311. 'U/ /
42
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
•
Project # 01 -ERP -0119
Project Name Workout Equipment - Weight Lifting
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Description ( Total Project Cost: $29,300
Smith machine - weight lifting machine.
2012 airu 2016
Justification
,or use by Police, Fire, Public Works, City staff to keep in shape to perform job duties and stay healthy. Current
nachine will be 7 years old in 2012. Suggested replacement is every 5 years.
ariance from 20 year plan - move back from 2011 to 2015
stimate salvage/resale value on replaced items: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 5,800 5,800 23,500
Total 5,800 5,800 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 5,800 5,800 23,500
Total 5,800 5,800 Total
43
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0120
Project Name Automated External Defibrillator (2)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priorio n a
2012 an, 2016
Description I Total Project ( ost: $49,100
)efibrillator is used to help get someones heart restarted during a cardiac arrest.
)wn 2 - both are replaced at one time due to changing technology.
Current equipment: 2010 - 4 AEDs
2010 ERP had 2 AEDs schedule for replacement at $6,000. Four were purchased.
Justification
With changes in technology, the AED's should be replaced every four years.
-ost - $3,000 per unit
Budget bnpact/Other
Variance from 20 year plan - adjustment from 3 years to 4 years.
Estimate salvage/resale value on replaced item: $
•
Prior
Expenditures 2012
2013 2014 2015
2016 Total
Future
.F---6,-00-0-1
Equipment
7,200
7,200
35,900
Total
Total
7,200
7,200
Total
Prior
Funding Sources 2012 2013
2014 2015
2016 Total
Future
6,000
Equipment Replacement Fund
7,200
7,200
35,900
Total
Total
7,200
7,200
Total
Tluu:cdur..lun� 40, 11111
44
0
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0122
Project Name workout Equipment - Dumb Bells
Type Equipment
Useful Life 10 years
Category Equipment
Future
Description
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $11,700
Workout equipment used in Fire Department workout room.
9
Justification
2012 thru 2016
1t dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead
plaint. This purchase would update our dumb bells to the current type fitness bells.
Budget hnpact/Other
Variance from 20 year plan - Move back from 2012 to 2014.
3stimate salvage/resale value on replaced item: $
Expenditures 2012
2013 2014 2015
2016 Total
Future
Equipment
5,000
5,000
6,700
Total
5,000
5,000
Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 5,000 5,000 6,700
Total 5,000 5,000 Total
45
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN 2012
City of Hopkins, MN
Project # 01 -ERP -0200
Project Name Marked Patrol Vehicles (6)
Type .Equipment
Useful Life 3 years
Category Vehicles
Future
Description
Departmew Police
('ontact Policc Chief
Priorio n a
Total Project ( ost: $2,495,500
2016
patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
consists of 6 patrol vehicles - 5 marked, 1 unmarked.
nt vehicles: (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria, (2) 2008 Ford Crown Victorias, (1)
Ford Crown Victoria
Justification
Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure
data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport.
Budget hnpact/Other
Variance from 20 year plan - Original replacement schedule was modified several years ago during the LGA cuts. The
)roposed purchase schedule is to realign the replacement of squads more evenly.
Estimate salvage/resale value on replaced item: $4,000 each
Prior Expenditures
2012
2013
2014
201.5
2016
Total
Future
637,700 Vehicles
69,200
71.200
73,400
75,600
77,800
367,200
1,490,600
Total
Total 69,200
71,200
73,400
75,600
77,800
367,200Total
75,600
Prior
Funding Sources
2012
2013
2014
2015
2016
Total
Future
637,700
Equipment Replacement Fund
69,200
71,200
73,400
75,600
77,800
367,200
1,490,600
Total
Total
69,200
71,200
73,400
75,600
77,800
367,200
Total
lhuculur. Jum ;U_ ?IJ//
46
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0201
Project Name Sergeant's Vehicle
Type Equipment
Useful Life 4 years
Category Vehicles
Future
Description
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $276,400
2012 thru 2016
Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
4 year rotation.
vehicle: 2011 Ford Crown Victoria
Justification
Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure
lata and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport.
ariance from 20 year plan - none.
stimate salvage/resale value on replaced item: $3,500 each
Prior Expenditures 2012
2013 2014 2015 2016
Total
Future
—33—,60-01 Vehicles
37,800
37,800205,000
37,800
Total Total
37,800
37,800
Total
Prior
Funding Sources 2012
2013 2014 2015 2016
Total
Future
33,600
Equipment Replacement Fund
37,800
37,800205,000
Total
Total
37,800
37,800
Total
:7
47
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0202
Project Name parking Enforcement Vehicle (Parking Fund)
Type Equipment
Useful Life 10 years
Category Vehicles
Future
Description
?arkinlz enforcement vehicle.
Current vehicle: 2006 Jeen Li
Deparuuent Police
Contact Policechicl
Priorih n a
Total Project Cost: $82,500
2012,i„„2016
Justification
Jse by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown area.
Variance from 20 year plan - amount allocated is not sufficient. Increase to $27,200.
Estimate salvage/resale value on replaced item: $1,500
r:
Prior Expenditures 2012
2013 2014 2015 2016
Total
Future
18,700 Vehicles
27,200
27,200
36,600
Total Total
27,200
27,200
Total
Prior
Funding Sources 2012
2013 2014 2015 2016
Total
Future
18,700
Equipment Replacement Fund
27,200
27,200
F 36,600
Total
Total
27,200
27,200
Total
I hm +drn'. Jane 30. 301 I
48
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0203
Project Name Utility 4x4 (unit 212)
Type Equipment
Useful Life 6 years
Category Vehicles
Future
Description
4 wheel drive uitility vehicle.
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $247,600
vehicle: 2008 Chevrolet Tahoe
2012 /in, 2016
Justification
Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals, prisoners and
;quipment. The 4 wheel drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme
;now conditions.
Budget Impact/Other
Variance from 20 year plan - none.
Estimate salvage/resale value on replaced item: $5,000
Prior Expenditures 2012
2013 2014 2015
2016 Total
Future
67,400 Vehicles
47,700
47,700
132,500
Total Total
47.700
47,700
Total
Prior
67,400
Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 47,700 47,700 132,500
Total 47.700 47,700 Total
49
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0204
Project Name Police Administrative Vehicles (2)
Type Equipment
Useful Life 2 years
Category Vehicles
Future
Department Police
Contact Police Chief
Priorit.N n a
Description I 'rotal Project Cost: $1,013,300
?olice administrative and detective vehicles.
Chiefs vehicle - even numbered years
Captain's vehicle - odd numbered years
vehicles: 2009 Chevrolet Impala. 2008 Ford Taurus
2012 //,-, 2016
Justification
Jnmarked vehicles, equipped with radios, siren and red grille liter 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
surveillance by uniform and plain clothes officers.
•
Budget Impact/Other I q
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: 54,000 each
Prior Expenditures
240,300 Vehicles
Total
2012 2013 2014 2015 2016 Total Future
28,800 29,600 30,500 31,400 32,400 152,700620,300
Total 28,800 29,600 30,500 31,400 32,400 152,700 Total
Prior
Funding Sources
2012
2013
2014
2015
2016
Total
Future
F-724-0,330-0-1
Equipment Replacement Fund
28,800
29,600
30,500
31,400
32,400
152,700
620,300
Total
Total
28,800
29,600
30,500
31,400
32,400
152,700
Total
lhurc�lur. June 30. 3011
50
•
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0205
Project Name H.E.A.T. Vehicle
Type Equipment
Useful Life 15 years
Category Vehicles
Future
Department Police
Contact Police Chief
Priority n/a
2012 2016
Description I Total Project Cost: $76,700
Unmarked van to transport police tactics team for high risk calls, training and mutual aid.
vehicle: 1998 Chevrolet Cube Van
Justification
'revious vehicle (15 years old) was a safety hazard and was replaced in 2005.
Budget Impact/Other
Variance from 20 year plan - extended life from 10 to 15 years
Estimate salvage/resale value on replaced item: $3,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 30,000 30,000 46,700
Total 30,000 30,000 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 30,000 30,000 46,700
Total 30,000 30,000 Total
51
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0206
Project Name Police Services Liaison Vehicle
Type Equipment
Useful Life 15 years
Category Vehicles
Future
Department Police
Contact Police Chief
Prioritc n a
2012 2016
Description I Total Project Cost: $63,900
Used by Police Services Liaison/JCPP Liaison for transport to schools, neighborhood meetings, training and public
.-elation events.
vehicle: 2001 Chrysler PT Cruiser
Justification
1001 PT Cruiser was leased to the Police Department for a nominal fee and detailing and wheels were also donated.
Che City purchased the vehicle from the leasor in 2005.
Budget Impact/Other
Variance from 20 year plan - extended life from 10 to 15 years. Amount allocated is not sufficient. Increase to $25,000.
?stimate salvage/resale value on replaced item: $1,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 25,000 25,000 38,900
Total 25,000 25,000 Total
•
Funding Sources 2012
2013 2014 2015 2016
Total
Future
Equipment Replacement Fund
25,000
25,000
38,900
Total
25,000
25,000
Total
lhursdur. June° 30. 201
52
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
•
Project # 01 -ERP -0208
Project Name LOGIS Computer System
Type Equipment
Useful Life 20 years
Category Equipment
Future
Description
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $200,000
2012 rhru 2016
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
Year 2 - $95,800 - this is maintenance and should be budgeted in Dept budget
about a 10% increase each subsequent year
'ear 2 through ?? Includes software/hardware support in addition to builing reserves for future
Justification
Fo store, retrieve and transfer required data to State and perform data entry, inquiries of local, state and national crime
LOGIS system will allow a greater sharing of data and records with 30+ communities for invesatigative purposes.
Budget Impact/Other
Variance from 20 year plan - Project was moved up from 2017 to allow greater ability to share information with other
agencies in the system and allows us the capability to potentially explore merging with another dispatch center.
Estimate salvage/resale value on replaced item: $-0-
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 200,000 200,000
Total 200,000 200,000
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 200,000 200,000
Total 200,000 200,000
53
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Epplrjj
ect # 01 -ERP -0209
ect Name Copy Machine - Police Dept
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n a
2012 ,i„„ 2016
Description I Total Project Cost: $161,600
?olice Department copy machine capable of producing double side copies and collating pages, color/BW, fax
tcapability and scan..
lCurrent equipment: 2006 Ricoh 2051 SP
Justification
Used to make duplicate copies of reports, letters, memos, etc., generated by police personnel, fax and scan..
Budget Impact/Other I q
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $1,000
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
49,800 Equipment 22,100 22,100 89,700
Total Total 22,100 22,100 Total
Prior Funding Sources 2012 2013 2014 2015
49,800 Equipment Replacement Fund
Total Total
54
2016
22,100
22,100
Total
Future
22,100
89,700
22,100
Total
Anrvdur. ,hin, 30 ?loll
C:
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0210
Project Name Logging Recorder
Type Equipment
Useful Life 7 years
Category Equipment
Future
Description
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $138,100
2012 /hru 2016
The police logging recorder is a device which records all telephone and radio transmissions produced/received by the
Police Department.
Current eauivment: 2005 Mercom lo22in2 recorder
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.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
•
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 36,900 36,900 101,200
Total 36,900 36,900 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 36,900 36,900 101,200
Total 36,900 36,900 Total
55
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project 4 01 -ERP -0211
Project Name Network Server (3)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Description
Department Police
Contact Police Chict' IT
Priorit,N n a
Total Project ( ost: $246,500
2012 r6ru 2016
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
knnual replacement cycle allows development of system storage program. Use of newer servers for heavy use
)rograms while older servers used for data storage.
Budget Impact/Other
Variance from 20 year plan - Cost stabilized at $8,500 per year.
Estimate salvage/resale value on replaced item - $
Is
Prior
Expenditures
2012
2013
2014
2015
2016
Total
Future
76,500
Equipment
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
Prior
76,500
Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 8,500 8,500 8,500 8,500 8,500 42,500 1 127,500
Total 8,500 8,500 8,500 8,500 8,500 42,500 Total
56
lhundur. Jui�30. ?l,l l
EQUIPMENT IMPROVEMENT PLAN 2012 rhru 2016
City of Hopkins, MN
Project # 01 -ERP -0212
Project Name Mobile Data Computers
Type Equipment
Useful Life 5 years
Category Equipment
Future
Description
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $297,800
Mobile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various
databases, communicate car to car.
Justification
Limited life of 5 years - replacement necessary.
Budget Impact/Other
Variance from 20 year plan - ERP - 10 mobile data computers ( includes 1 spare) includes docking stations.
Replacement of MDC's can be moved to 2013 due to experiencing minimal performance issues. Parking Fund (1)
MDC - $5.700
value on replaced item:
Prior Expenditures 2012
2013 2014
2015 2016 Total
Future
—47,-0-00-1 Equipment
62,700
62,700
188,100
Total Total
62,700
62.700
Total
Prior
Funding Sources 2012
2013 2014
2015 2016 Total
Future
47,000
Equipment Replacement Fund
57,000
57,000
F 188,100
Tata]
PKG - Parking Fund
5,700
5,700
Total
Total
C.
62,700
57
62,700
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0213
Project Name Digital Squad Car Cameras
Type Equipment Department Police
Useful Life 5 years Contact Police Chief
Category Equipment Priority n a
Future
2012 rhrtt 2016
Description I I otal Project Cost: $256,200
Digital video camera system in each marked patrol car - used to document events in and out of the patrol car. Images
downloaded to server for storage and retrieval.
Justification
Police Dept. currently has ten digital camera units installed and a dedicated server. The life expectancy of the cameras
is about five years. Current cameras were installed in September 2009.
Cost: 10 cameras @ $5,000 per unit plus tax - $53,430
1 server @ $15,000 (to be purchased from Police Network Server (01 -ERP -211)
annual allocation that carries forward.
Estimated cost $53,430. Cost could be lower if, at the time of replacement, a suitable product is available through a
State or Countv eauivment bid.
Budget Impact/Other
Variance from 20 year plan - Increase quantity to ten to cover all marked/unmarked patrol vehicles. Cost of cameras
remains at $5,000 each plus tax - $53,430.
Estimate salvage/resale value on replaced item: $
Prior Expenditures
F-42—,60-01 Equipment
Total
2012 2013 2014 2015 2016
53,400
Total 53,400
Total Future
53,400 160,200
53,400 Total
Prior
Funding Sources 2012
2013 2014 2015
2016 Total
Future
.F--4-2-,6-0-01
Equipment Replacement Fund
53,400
53,400
160,200
Total
Total
53,400
53,400
Total
Tlrt�c�dnr..lune 30. 2011
58
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0214
Project Name Tactical Ballistic Vests
Type Equipment
Useful Life 5 years
Category Equipment
Future
Description
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $137,500
2012 /hr„ 2016
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.
Justification
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
Variance from 20 year plan - Team membership has increased to 11.
Estimate salvage/resale value on replaced item: $
Prior Expenditures 2012
2013 2014
2015 2016 Total
Future
20,000 Equipment
23,200
23,200
94,300
Total Total
23,200
23,200
Total
Prior
20,000
Total
Funding Sources
Equipment Replacement Fund
Total
2012 2013 2014 2015 2016
23,200
23,200
-]
Total
Future
23,200
94,300
23,200
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0215
Project Name Radios - Portable and Mobile Devices
Type Equipment
Useful Life
Category Equipment
Future
Department Police
Contact Police Chief
Priorit.N n a
2012 2016
Description I rota] Project cost: $300,000
?ortable and mobile radios used by the police, fire and public works departments to allow these departments to
;ommunicate on one frequency. Police and fire use their radios on a daily/regular basis. The public works only uses
heirs in the event of an emergency.
?stimated Replacement Cost (based on 2009 cost)
Portable - $2,300
Mobile - $3,000
Police Fire PW Total
Portable 65 36 10 111
Mobile 17 9 0 26
Justification
Provides radios so that the police, fire and public works can communicate on a common radio frequency during an
emergency and multiple county interoperability.
Budget Impact/Other
Variance from 20 year plan - added replacement cost at S 15.000 per year fixed, starting in 2012. Do not expect all 132
radios to need replacing at one time.
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 15,000 15,000 15,000 15,000 15,000 75,000 225,000
Total 15,000 15,000 15,000 15,000 15,000 75,000 Total
Funding Sources
2012
2013
2014
2015
2016
Total
Future
Equipment Replacement Fund
15,000
15,000
15,000
15,000
15,000
75,000
225,000
Total
15,000
15,000
15,000
15,000
15,000
75,000
Total
/huredur-111n, 30, 0//
60
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0216
Project Name 911 Phone System (Viper Phone)
Type Equipment
Useful Life
Category Equipment
Future
Description
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $0
2012 thru 2016
tron Lifeline 100 IAP+ is an analog enhanced 911 phone system installed in 1986 and upgraded twice. There are
911 landlines, three 911 wireless and one 911 rollover line. This phone system receives and transfers 911 calls
displays landline location information or longitude/latitude information from cell phones. This system allows 911
to be transferred to other agencies as needed.
Current plans call for leasing of new Viper phone equipment.
60 month lease at $2,015 per month. No payoff or buyout at the end - we will own outright. Lease includes hardware,
software, Evergreen software support for term of lease and hardware maintenance for 1 year. Subsequent years
hardware maintenance will be provided by Qwest and funded by Police budget.
PD budget - current lease expense of $1,071.43 from expiring system plus funds from E-911 state funds to
the difference - aDDroximately $944.
Justification
The analog 911 phone system has never been in the ERP. The equipment was leased until November 2010 when
leasing options expired and the equipment was purchased for $1.00. The current service provider will not guarantee
part availability or maintenance service beyond our current maintenance agreement which ends in April 2012. They
will review contracts on a case by case basis. The equipment is discontinued and parts are no longer manufactured and
limited in availability. The 911 next generation phone technology is digital and internet based. The state of MN 911
service provider has already established this new technology and in 1-2 years all systems would need to be upgraded to
Budget Impact/Other
Variance from 20 year plan - Cost of the upgrade is estimated between $94,000 - $150,000 depending which option is
chosen. Plus monthly recurring maintenance charges and/or user fees if services are shared with another department.
$14,058 is already in the current budget for monthly lease/maintenance.
Estimated salvage/resale value on replaced item: -0-
Expenditures
Equipment
•
Total
2012 2013 2014 2015 2016 Total
61
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Funding Sources 2012
Equipment Replacement Fund
Total
2012 mn, 2016
2013 2014 2015 2016 Total
62
Thur'day../unr 30
•
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0300
Project Name 4x4 3/4 Ton Pickup with Plow
Type Equipment
Useful Life 10 years
Category Vehicles
Future
2012 2016
Department Public Works: Streets/Traffic
Contact Public Works Director
Priority n/a
Description I Total Project Cost: $103,800
?ickup used by various divisions of Public Works.
Current vehicle: 1997 Chevrolet 3/4 Ton 4X4
Justification
Light hauling and transportation for supervisors. Maintenance garage service vehicle.
Budget Impact/Other
Variance from 20 year plan - Increase expenditure to reflect actual cost. Change from 1/2 ton pickup to 3/4 ton 4x4
value on replaced item: $1
Prior Expenditures
F--2-5—,00-0-1 Vehicles
Total
2012 2013 2014 2015 2016 Total Future
33,600 33,600 1 45,200
Total 33,600 33,600 Total
Prior Funding Sources 2012
2013 2014 2015 2016
Total
Future
25,000 Equipment Replacement Fund
33,600
33,600
45,200
Total Total
33,600
33,600
Total
•
63
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0301
Project name 4X4 3/4 Ton Truck with Plow
2012 rJrrrr 2016
Type Equipment Dep:a-invent Public Works: Streets Traffic
Useful Life 8 years Contact Public Works Director
Category Vehicles Priorit,N n a
Future
Description I Total Project Cost: $141,700
3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers.
vehicle: 2006 Ford F250
Justification
�ight hauling, pulling trailers, transportation to and from job sites.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $1,500
is
Prior Expenditures 2012
2013 2014
2015 2016 Total
Future
24,000 Vehicles
30,400
30,400
87,300:
Total Total
30,400
30,400
Total
Prior
Funding Sources 2012
2013 2014
2015 2016 Total
Future
24,000 1
Equipment Replacement Fund
30,400
30,400
87,300
Total
Total
30,400
30,400
Total
11111r0al,June30_Z0ll
64
•
EQUIPMENT IMPROVEMENT PLAN 2012 th i, 2016
City of Hopkins, MN
Project # 01 -ERP -0303
Project Name 1 Ton Dump Truck (2)
Type Equipment Department Public Works: Streets/Traffic
Useful Life 12 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $205,500
Truck is used in the Street Division of Public Works.
Current vehicles: 2000 Ford F450 & 2011 Ford F350
Justification
Vehicle used by various departments for street and park maintenance and light hauling.
Budget hnpact/Other
Variance from 20 year plan - move back from 2009 to 2010.
Estimate salvage/resale value on replaced item: $3,500
Prior Expenditures
67,900 Vehicles
Total
2012 2013 2014 2015 2016
34,700
Total 34,700
Total
Future
34,700
102,900
34,700
Total
Prior Funding Sources
2012 2013
2014 2015 2016 Total
Future
67,900 Equipment Replacement Fund
34,700
34,700
102,900
Total Total
34,700
34,700
Total
•
65
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
EPPIrlij
ect # 01 -ERP -0304
ect Name 1 Ton Traffic Boom Truck
2012 aw, 2016
Type Equipment Department Public Works: Succts Traffic
Useful Life 17 years Contact Public Works Director
Category Vehicles Priority n a
Future
Description I Total Project Cost: $218.900
3oom truck used in Street and Traffic Divisions of Public Works.
lCurrent vehicle: 1995 Chevrolet 1 Ton Boom Truck
Justification
Vehicle used by Traffic Department for signal and light pole maintenance.
W -w
' N �A'�a
AMU
Budget Impact/Other 1 11
Variance from 20 year plan - Increase amount to reflect actual.
Estimate salvage/resale value on replaced item: $8,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 82,500 82,500 136,400
Total 82,500 82,500 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 82,500 82,500 136,400
Total 82,500 82,500 Total
0
1hnt "bil. Jinn 30. ?ul l
66
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0305
Project Name Single Axle Dump Truck (3)
Type Equipment
Useful Life 17 years
Category Vehicles
Future
2012 thru 2016
Department Public Works: Streets/Traffic
Contact Public Works Director
Priority n/a
Description I Total Project Cost: $674,100
Single axle dump truck used by various division of Public Works.
Current vehicles: 2001 Ford L7501 & 2004 Freightliner M2 106
Justification
Vehicle used for heavy hauling, snow plowing and sanding.
additional single axle truck in place of tandem truck from 01 -ERP -306.
Budget Impact/Other
Variance from 20 year plan - Move 1 truck from tandem (was in 101 -ERP -306) to single axle for 2012.
Estimate salvage/resale value on replaced item: $4,500 each
We would then have 3 single axel (chaene from 2) dump truck and 1 tandem axel dump truck.
Prior Expenditures
80700 Vehicles
Total
2012 2013 2014 2015 2016
127,400
Total 127,400
Total
Future
127,400
466,700
127,400
Total
Prior Funding Sources
2012 2013
2014 2015 2016 Total
Future
80,000 1 Equipment Replacement Fund
127,400
127,400
466,700
Total Total
127,400
127,400
Total
•
67
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0308
Project Name Front End Loaders (2)
Type Equipment
Useful Life 15-18 years
Category Equipment
Future
Description
Justification
2012 ,i„„ 2016
Department Public Works: Streets Traffic
Contact Public Works Director
Priorit,N n a
Total Project ( ost: $848,600
1991 Caterpillar 928E Loader & 2005 Caterpillar 938G
Budget Impact/Other
Variance from 20 year plan - None
Estimate salvage/resale value on replaced item: $
9
Prior
Expenditures
2012 2013
2014 2015 2016 Total
Future
—140-,-0001
Equipment
172,000
172,000
536,600
Total
Total
Total 172,000
172,000
Total
Prior
Funding Sources
2012 2013
2014 2015 2016 Total
Future
140,000
Equipment Replacement Fund
172,000
172,000
536,600
Total
Total
172,000
172,000
Total
7hnrc�hn..lum in, ?Ill l
68
EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016
City of Hopkins, MN
Project # 01 -ERP -0309
Project Name Skid Loader (2)
Type Equipment Department Public Works: Streets/Traffic.
Useful Life 12 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $187,600
Loading trucks, landscape work, snow removal, material handling.
Current eauinment: 1998 John Deere 8875 Skid Loader & 2004 Bobcat S-1851 R Skid Loader
Justification
Budget hnpact/Other
Variance from 20 year plan - move back from 2010 to 2011.
Estimate salvage/resale value on replaced item: $
Prior Expenditures
36,000 Equipment
Total
2012 2013 2014 2015 2016 Total Future
41,900 41,900 1 109,700
Total 41,900 41,900 Total
Prior Funding Sources 2012 2013
2014 2015 2016
Total
Future
36,000 Equipment Replacement Fund
41,900
41,900109,700
Total Total
41,900
41,900
Total
•
69
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
E,P,r.ojj
ect # 01 -ERP -0311
ect Name Sweeper
2012 air„ 2016
Type Equipment Dcp:u-imcnl Public Works: Streets Traffic
Useful Life 12 years Contact Public Works Director
Category Equipment Priorit, n a
Future
Description I 'total Project Cost: $494,700
Street sweeper used by Streets Division for sweeping streets and parking lots.
2001 Erin Pelican SE
Justification
Street sweeping, event clean-up, spring sand removal.
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $12,000
Prior Expenditures
1 —17,305-01 Equipment
Total
Total
2012 2013 2014 2015 2016
156,400
156,400
n
U
Total
Future
156,400
223,000
156,400
Total
Prior
Funding Sources 2012
2013 2014
2015 2016 Total
Future
115,300
Equipment Replacement Fund
156,400
156,400
223,000
Total
Total
156,400
156,400
Total
•
lhnrvdur.Jnn< 30,3011
70
EQUIPMENT IMPROVEMENT PLAN 2012 rhru 2016
City of Hopkins, MN
Project # 01 -ERP -0312
Project Name Roller
Type Equipment Department Public Works: Streets/Traffic
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $45,900
Used by Street Department for asphalt repair and resurfacing.
Current equipment: 1989 Ingersoll Rand Roller
Justification
Budget Impact/Other
Variance from 20 year plan - Move back from 2012 to 2014.
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 45,900 45,900
Total 45,900 45,900
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 45,900 45,900
Total
FJ
71
45,900
45,900
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0314
Project Name Asphalt Paver
2012 ,1„t, 2016
Type Equipment Department Public Works: Streets Traffic
Useful Life 20 years Contact Public Works Director
Category Equipment Priorit.N n a
Future
Description I Total Project ('ost: $48,800
ksphalt paver used by Streets Division of Public Works.
Current equipment: 1994 Caterpillar AD200B Paver
Justification
Paving streets and parking lots.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $500
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 48,800 48,800
Total
48,800
48,800
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 48,800 48,800
Total 48,800 48,800
1karsdur..how 30. 2011
72
•
EQUIPMENT IMPROVEMENT PLAN 2012 M ., 2016
City of Hopkins, MN
Project # 01 -ERP -0315
Project Name Snow Blower
Type Equipment Department Public Works: Streets/Traffic
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $102,300
Snow blower used by the Streets Division of Public Works.
(Current equipment: 1998 SnoGo WK800
Justification
Blowing and loading snow off Mainstreet into trucks.
•
Budget hupact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $4,500
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 102,300 102,300
Total 102,300 102,300
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 102,300 102,300
Total 102,300 102,300
Thursday, June 30, 2011
73
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0317
Project Name Sign Machine (Traffic)
Type Equipment
Useful Life 10 years
Category Equipment
Future
Description
2012 ,i„„ 2016
Department Public Works: StreetsTraffic
Contact Public Works Director
Priori[) n a
Total Project Cost: $31,500
used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city
2005 Sicncad Shun Makine S
Justification
Existing machine is not repairable and needs updating/
Budget Impact/Other
Variance from 20 year plan - new
E-stimate salvage/resale value on replaced item: S -0 -
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 13,400 13,400 18,100
Total 13,400 13,400 Total
L�
Funding Sources 2012
2013 2014 2015 2016
Total
Future
Equipment Replacement Fund
13,400
13,400
18,100
Total
13,400
13,400
Total
l7urcadm, ,how 30. I011
74
•
EQUIPMENT IMPROVEMENT PLAN 2012,/7,.,,2016
City of Hopkins, MN
Project # 01 -ERP -0318
Project Name Asphalt Hot Mix Heating Box
0
Type Equipment Department Public Works: Streets/Traffic
Useful Life 12 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $37,600
slide in truck mounted unit with built in heat source to heat up or keep heated asphalt mix when used in patching or
eet repair.
Justification
Currently hot mix asphalt is picked up at the mixing plant in the morning and used throughout the day for patching
operations, and as the mix cools it becomes unusable. The proposed "Hot Box" will keep the mix hot and pliable until
used up which minimizes waste. This hot box will also allow the crew to use hot mix during colder months of the year.
In addition, it will be used to heat up and make pliable patching material specifically formulated for winter use when
hot mix plants are not operating.
Budget Impact/Other
Variance from 20 year plan - New item.
Estimate salvage/resale value on replaced item: $-0-.
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 15,500 15,500 22,100
Total 15,500 15,500 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 15,500 15,500 22,100
Total 15,500 15,500 Total
75
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
EPP,r-oij
ect # 01 -ERP -0400
ect Name 4x4 3/4 Ton Truck
Type Equipment
Useful Life 8 years
Category Vehicles
Future
Department HRA
Contact Unassigned
Prioritc n a
2012 ,i„„ 2016
Description I Total Project Cost: $148,400
t wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snow plow.
lCurrent vehicle: 2007 Chevrolet Pickup
Justification
Transportation for Public Housing Superintendent and snow plowing at various HRA properties around the city.
Budget Impact/Other
•
Variance from 20 year plan - none '
Estimate salvage/resale value on replaced item: $1,800
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
22,800 Vehicles 32,400 32,400 93,200
Total Total 32,400 32,400 Total
Prior
Funding Sources 2012
2013 2014 2015 2016
Total
Future
22,800
HRA - Housing and Redevelop
32,400
32,400
93,200
Total
Total
32,400
32,400
Total
•
7hurvelav, June 30. 2077
76
EQUIPMENT IMPROVEMENT PLAN 2012 ihru 2016
City of Hopkins, MN
Project# 01 -ERP -0401
Project Name 11RA Copier
Type Equipment Department HRA
Useful Life 8 years Contact Finance Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $50,400
Color copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks.
Current equipment: Imnistics ZB35
Justification
Daily use to make copies of correspondence, forms and rental documents. Periodically produce documents such as
resident newsletters and marketing. Machine will duplex, sort, collate and staple copies.
Budget Impact/Other
Variance from 20 year plan - New item.
Estimate salvage/resale value on replace item: $ - 0 -
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 13,000 13,0 0F-75,405-01
Total 13,000 13,000 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
HRA - Housing and Redevelop 13,000 13,000 37,400
Total 13,000 13,000 Total
Aursday, June 30, 2011
77
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
EPPIr-01ject
ect # 01 -ERP -0502
Name Backhoe Loader
2012 air, 2016
Type Equipment Dcparuneut Water
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n a
Future
Description I Total Project Cost: $134,800
Jnit utilitzed by Water, Sewer and Street Divisions of Public Works for repair and installation of underground utilities.
lCurrent equipment: 1993 Caterpillar Backhoe 446
Justification
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 134,800 134,800
Total 134,800 134,800
Funding Sources 2012 2013 2014 2015 2016 Total
WF - Water Fund 134,800 134,800
Total 134,800 134,800
771111 "hn . hol, 311. M l
78
•
EQUIPMENT IMPROVEMENT PLAN 2012,/,/-,,,2016
City of Hopkins, MN
Project # 01 -ERP -0506
Project Name Public Works Copy Machine
Type Equipment Department Water
Useful Life 5 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $94,700
Copy machine to service needs of all division of Public Works.
uipment: 2005 Ricoh Aficio 2238C
Justification
\laking copies for various departments.
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $800
Prior Expenditures
22,800 Equipment
Total
Prior Funding Sources
22,800 WF - Water Fund
Total
•
2012 2013 2014 2015 2016 Total Future
14,200 14,200 57,700
Total 14,200 14,200 Total
2012 2013 2014 2015 2016 Total Future
14,200 14,200 57,700
Total 14,200 14,200 Total
79
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0550
Project Name 4x4 3/4 Ton Truck
2012 r!u a 2016
Type Equipment DepartineW scorer
Useful Life 10 years Contact Public Works Director
Category Vehicles Prioritc n a
Future
Description I Total Project Cost: $110,300
Cruck used by Water/Sewer Division of Public Works.
Current vehicle: 2004 Chevrolet Pic
Justification
Snow plowing, light hauling, pulling trailers, general purpose transportation.
(Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
•
Prior Expenditures 2012
2013 2014 2015
2016 Total
Future
7600 Vehicles
35,700
35,7007-74-8,700-1,
Total Total
35,700
35,700
Total
Prior Funding Sources
26,600 SF - Sanitary Sewer Fund
Total Total
2012 2013 2014 2015 2016
35,700
35,700
Total
Future
35,700
88,000 ,
35,700
Total
lhui "drn'. ,luny 30. 10! 1
U
EQUIPMENT IMPROVEMENT PLAN 2012 ,i„ t, 2016
City of Hopkins, MN
Project # 01 -ERP -0551
Project Name 3/4 Ton Utility Truck
Type Equipment Department Sewer
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $129,800
3/4 ton utility truck used by the Water/Sewer Division of Public Works.
Currrent vehicle: 2007 Chevrolet
Justification
Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling.
Budget hnpact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $2,500
Prior Expenditures
51,000 Vehicles
Total
2012 2013 2014 2015 2016 Total Future
33,600 33,600 45,200
Total 33,600 33,600 Total
Prior Funding Sources 2012
2013 2014 2015 2016
Total
Future
51,000 SF - Sanitary Sewer Fund
33,600
33,600
45,200
Total Total
33,600
33,600
Total
•
81
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0700
Project Name Engineering Van
2012 ,i 2016
Type Equipment DcparUnent Public Works: Engineering
Useful Life 10 years Contac) Public Works Director
Category Vehicles Prioritc n
Future
Description I 'total Project Cosa $66,400
Van used by Engineering Department for survey equipment and on job site work.
vehicle: 2000 Chevrolet Suburban
Justification
Transportation to and from job site, hauling of surveying and traffic counting equipment.
Budget Impactl0ther
Variance from 20 year plan - increase amount from 14,300 to 16,000 to reflect actual cost. Purchase used Suburban
'rom Hennepin Co. 2002 auction -price is $13,000 to $14,000 + $2,000 for equipment.
3stimate salvage/resale value on replaced item: $2,500
•
Prior Expenditures 2012
2013 2014
2015 2016 Total
Future
15000 Vehicles
21,500
21,500
28,900
Total Total
21,500
21,500
Total
Prior Funding Sources
16,000 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
21,500
21,500
82
Total
Future
21,500
F28,900
21,500
Total
11ml,dai. Ju„, M. 2011
EQUIPMENT IMPROVEMENT PLAN 2012 rhru 2016
City of Hopkins, MN
Project # 01 -ERP -0701
Project Name Engineering Printer/Scanner
Type Equipment Department Public Works: Engineering
Useful Life 5 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $54,560
?rinter/scanner - large format copier use in Engineering to copy blueprints, plans and large documents.
is leased.
in 2012 the lease has been moved to the GF
Justification
Large document copier/scanner for use in Engineering. Also scans documents for permanent storage.
Budget Impact/Other
Variance from 20 year plan - Decrease from 10,000 to 8,000 per lease charges.
Estimate salvage/resale value on replaced item: $-0-
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
54,560 Equipment 0 0 0 0 0 0 0
Total Total 0 0 0 0 0 0 Total
Prior Funding Sources 2012 2013 2014 2015 2016 Total Future
54,560 Equipment Replacement Fund 0 0 0 0 0 0
Total Total 0 0 0 0 0 0 Total
•
83
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
[PpIr-0j,
ect # 01 -ERP -0800
ect Name 1/2 Ton Pickup Truck
2012 2016
Type Equipment Department Public Works: Parks'Foresu),
Useful Life 10 years Contact Public Works Director
Category Vehicles Priorit,N n a
Future
Description I Total Project Cost: $61,800
?ickup used by Park Division of Public Works.
Current vehicle: 2001 Ford
Justification
ariance from 20 year plan - move back from 2012 to 2013
stimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 26,400 26,400 35,400
Total 26,400 26,400 Total
Funding Sources 2012 2013 2014 2015
Equipment Replacement Fund
Total
26,400
26,400
2016 Total Future
26,400 35,400
26,400 Total
lhrvrv�lur..hun iU, ZUl l
84
•
0
EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016
City of Hopkins, MN
Project # 01 -ERP -0801
Project Name 4x4 3/4Ton Trucks (2)
Type Equipment Department Public Works: Parks/Forestry
Useful Life 8 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $313,800
Crucks used by Parks Division of Public Works.
vehicles: 2004 Ford F350 4X4 & 2004 Ford F350 4X4
Justification
Snow plowing, hauling, transportation. Units are heavily used.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
Prior
53,200
Total
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 67,400 67,400 193,200
Total 67,400 67,400 Total
Prior Funding Sources
2012 2013
2014 2015 2016 Total
Future
53,200 Equipment Replacement Fund
67,400
67,400
193,200
Total Total
67,400
67,400
Total
t
85
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0802
Project Name 3/4 Ton Utility Truck
2012 ,hrvt 2016
Type Equipment Department Public Works: Parks Foresny
Useful Life 14 years Contact Public Works Director
Category Vehicles Priorit.N u a
Future
Description I Total Project ( ost: $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.
lCurrent vehicle: 1998 Dodge Ram 3500
Justification
Budget Impact/Other
Variance from 20 year plan - move back from 2012 to 2013.
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 32,200 32,200 48,700
Total 32,200 32,200 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund
Total
32,200 32,200 48,700
32,200 32,200 Total
86
1hursdur.,huu 30. 2011
11
•
EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016
City of Hopkins, MN
Project # 01 -ERP -0806
Project Name Tractor
Type Equipment Department Public Works: Parks/Forestry
Useful Life 30 years Contact Public Works Director
Category Equipment Priority n/a
Future
•
Description I Total Project Cost: $49,300
arm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration, plowing
ind grass seeding.
1984 Ford Tractor 2910 (#81
Justification
ariance from 20 year plan - Delete one tractor (2012) to be placed by ToolCat (2010). Move second tractor to 2016.
Aimate salvage/resale value on replaced item: $3,500
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 49,300 49,300
Total
49,300 49,300
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 49,300 49,300
Total 49,300 49,300
87
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0807
Project Name Trueksters (3)
2012 ,n, „ 2016
Type Equipment Department Public Works: Parks Forestry
Useful Life 15 years contact Public Works Director
Category Equipment Priority n
Future
Description I I mal Project cost: $114,700
Cruckster used by Parks Division of Public Works for ballfield and parks maintenance.
Current equipment: 1996 Toro Workman, 2004 Toro Workman 3200, 2004 Toro Workman 2110
Justification
?ark maintenance, ballfield grooming and weed spraying.
0
Budget Impact/Other I\
Variance from 20 year plan - Mov c from 2012 to 2013.
Estimate salvage/resale value on replaced item: $1,400 each
Prior
Expenditures 2012
2013 2014
2015 2016 Total
Future
7,900
Equipment
19,800
19,800F---65-,-0700
F 65,000
Total
Total
19,800
19,800
Total
Prior
Funding Sources 2012
2013 2014
2015 2016 Total
Future
29,900
Equipment Replacement Fund
19,800
19,800
F 65,000
Total
Total
19,800
19,800
Total
llrnr�sdal../Ifm 30. '0//
88
0
EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016
City of Hopkins, MN
Project # 01 -ERP -0808
Project Name Riding Mowers (3)
Type Equipment Department Public Works: Parks/Forestry
Useful Life 8 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $255,700
Riding mowers used by Parks Divison of Public Works.
Current eauinment: 1996 Toro Groundmaster 345, 2004 Toro Zero
Justification
Mowing city parks and right of ways.
Budget Impact/Other
Variance from 20 year plan - move from 2012to 2014. Changes in use.
Estimate salvage/resale value on replaced item: $600 each
Prior Expenditures
-49—,00-01 Equipment
Total
2006 Jacobson Rotary Mower
2012 2013 2014 2015 2016 Total Future
22,800 30,600 53,400 1 153,300
Total 22,800 30,600 53,400 Total
Prior
Funding Sources 2012
2013
2014 2015
2016 Total
Future
49,000 1
Equipment Replacement Fund
22,800
30,600
53,400
153,300
Total
Total
22,800
30,600
53,400
Total
•
89
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0809
Project Name Slope Mower
Type Equipment
Useful Life 15 years
Category Equipment
Future
Description
2012 rl„ rr 2016
Department Public Works: Parks Forestry
( ontact Public Works Director
Priority n a
I otal Project ( ost: $83,600
lurrent equipment: 2001 DEW EZE ATM72 Slope Mower
Justification
Budget Impact/Other
•
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: 51,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 32,700 32,700 50,900.,
Total 32,700 32,700 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 32,700 32,700 50,900
Total
i
32,700 32,700 Total
•
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0813
Project Name Brush Chipper
Type Equipment
Useful Life 20 years
Category Equipment
Future
2012 thru 2016
Department Public Works: Parks/Forestry
Contact Public Works Director
Priority n/a
Description I Total Project Cost: $25,700
Brush chipper used for Forestry and brush pick up operations of Public Works.
lCurrent equipment: 1993 Brush Bandit Chipper 250
Justification
•
ludget Impact/Other
ariance from 20 year plan - change to usable life to 20 years - move back from 2009 to 2013.
stimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 25,700 25,700
Total 25,700 25,700
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 25,700 25,700
Total 25,700 25,700
RE
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
EPPIrl-oil
ect # 01 -ERP -0817
ect Name Grass Seed Applicator (Overseeder)
2012 2016
Type Equipment Department Public Works: Parks'Foresty
Useful Life 20 years (bnlacl Public Works Director
Category Equipment Priorit,N n
Future
Description I ,1 otal Project Cost: $7,400
kttachment for overseeding existing turf areas.
Justification
werseeder was not part of ERP - old overseeder was sold two years ago due to poor condition.
Budget Impact/Other
Variance from 20 year plan - New item.
Estimate salvage/resale value on replace item: S -0 -
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 7,400 7,400
Total 7,400 7,400
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 7,400 7,400
Total 7,400
7,400
17unsrlur. June 3U. 2011
92
•
0
EQUIPMENT IMPROVEMENT PLAN 2012,/,,.,,2016
City of Hopkins, MN
Project 4 01 -ERP -0900
Project Name Refuse Truck (RAP -R) (2) €
Type Equipment Department Refuse
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $1,462,600
Refuse truck used by Refuse Utility Division of Public Works.
vehicle: 2005 Peterbilt
Justification
Residential waste pick up.
Rail & 2011
Variance from 20 year plan - increase cost to reflect actual
Estimate salvage/resale value on replaced item: $18,000
Prior Expenditures
349,100 Vehicles
Total
Prior Funding Sources
349,100 RF - Refuse Fund
Total
•
M
2012 2013 2014 2015 2016 Total Future
204,800 204,800 1 908,700
Total 204,800 204,800 Total
2012 2013 2014 2015 2016 Total Future
204,800 204,800 1 908,700
Total 204,800 204,800 Total
93
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
[PIr-0j,
ect # 01 -ERP -0901
ect Name Refuse Truck (Rear -L)
2012 ,i„„ 2016
�.J
Type Equipment Department Refuse
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n a
Future
Description total Project Cost: $238,200
Zefuse truck used by Refuse Utility Division of Public Works.
�urrent vehicle: 1996 Fre
Justification
Zesidential waste pick up.
liner FL70
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $9,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 101,600 101,600 136,600
Total 101,600 101,600 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
RF - Refuse Fund 101,600 101,600 136,600
Total 101,600 101,600 Total
•
77n�r��lnr..lunr 311. ?Ul I
94
EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016
City of Hopkins, MN
Project # 01 -ERP -1000
Project Name Ice Resurfacer
Type Equipment Department Pavilion
Useful Life 12 years Contact Facilities Director
Category Equipment Priority Wa
Future
Description
Total Project Cost: $496,600
Ice resurfacer used by the Pavilion for ice sheet maintenance.
2003 Olvmpia Ice Resurfacer
Justification
teplace existing propane fueled ice resurfacer with a electric driven ice resurfacer. Due to changes in the states statues
.or indoor air quality for ice arenas replacement with a propane fueled model would warrant the purchase and
nstallation of state approved air quality monitoring equipment. Additional costs that would accompany the monitoring
,quipment would be annual testing and recalibration fees. State statues also require annual licensing and lower emission
;tandards to be meet that if exceeded could possibly lead to possible facility closures and loss of revenue. With
;onsideration of the above factors the Pavilion would be exempt from the new statues if a electric ice resurfacer was
zsed in Dlace of propane ice resurfacer.
Variance from 20 year plan - Value increased to reflect actual replacement cost.
Estimate salvage/resale value on replaced item: $20,000
Prior
60,000
Total
Prior
60,000
Total
•
Expenditures
Equipment
Funding Sources
2012 2013 2014 2015 2016
180,000
Total 180,000
Total
Future
180,000
256,600
180,000
Total
2012 2013 2014 2015 2016 Total Future
PA - Pavilion Fund 180,000 180,000 256,600
Total 180,000 180,000 Total
95
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -1001
Project Name Electric Ice Edger
2012 ,i„„ 2016
Type Equipment Department Pavilion
Useful Life 10 years Contact Facilities Director
Category Equipment Prioritc ma
Future
Description I 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 that 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.
Budget Impact/Other
Vairance from 20 year plan - New item.
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment
Total
5,000
5,000
Funding Sources 2012 2013 2014 2015 2016
PA - Pavilion Fund 5,000
Total
5,000
5,000 6,700
5,000 Total
Total
Future
5,000
6,700
5,000
Total
Ihurcdui. Junr 30. ?Ol l
96
•
is
EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016
City of Hopkins, MN
Project# 01 -ERP -1101
Project Name Art Center Carpet Extractor
Type Equipment Department Arts Center
Useful Life 10 years Contact Arts Center Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $9,100
The carpet extractor is used at the Arts Center and occassionally in other city facilities. The equipment is used to clean
carpets on a regular basis between annual contractual cleanings, to remove spots and stains, and to pick up spills.
Includini? carpet wand and long hose for ease of use, as well as low moisture capabilities.
Justification
'he current equipment is over 12 years old and very corroded from the dirt, water and cleaning chemicals. With regular
)uch up cleaning and removal of stains in the Arts Center carpet with this extractor, the need to pay contractual
leaners to deep clean the carpet is reduced to once or twice annually.
Budget Impact/Other
Variance from 20 year plan - Increase cost from $3,300 to $3,900.
Estimate salvage/resale value on replace item: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 3,900 3,900 5,200
Total 3,900 3,900 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
AC - Arts Center Fund 3,900 3,900 5,200
Total 3,900 3,900 Total
97
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Ej
ect#01-ERP-1102
ect Name Art Center Kitchen Catering Equipment
2012 2016
Type Equipment Dcparunent Arts Center
Useful Life 12 years Contact Arts Center Director
Category Equipment Priorit.N n it
Future
Description I Total Project Cost: $12,100
Jnder counter freezer and refrigerator in catering kitchen.
Justification
These units are used for storing food for HCA events and for rental clients.
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-
0
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 5,000 5,000 7,100
Total
Funding Sources 2012 2013 2014 2015 2016
AC - Arts Center Fund
Total
5,000
5,000
98
5,000 Total
Total
Future
5,000
7,100
5,000
Total
1 hursdav 1unc 30. 3011
•
Pi
EQUIPMENT IMPROVEMENT PLAN 2012 m 2016
City of Hopkins, MN
Project# 01 -ERP -1103
Project Name Art Center Video Camera Updates
Type Equipment
Useful Life 5 years
Category Equipment
Future
Description
Department Arts Center
Contact Arts Center Director
Priority n/a
Total Project Cost: $16,200
Replace the front entry camera with a better resolution camera. Relocate existing to above the display cabinet in the
lobby. Add additional camera to the gallery, left of door to capture shot of faces of those exiting. Add a camera to the
back hallwav of the second floor.
Justification
There 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 camera in the back hallway may reduce tendency of youth to hang out in that area and
engage in inappropriate behavior.
Variance from 20 year plan - New item. I
Estimate salvage/resale value on replaced item: $-0-
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 3,200 3,200 13,000
51
Total 3,200 3,200 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
AC - Arts Center Fund 3,200 3,200 13,000
Total 3,200 3,200 Total
99
Thursday, June 30, 2011
TWENTY-YEAR
REPLACEMENT SCHEDULE
0
•
8 g g n 8 8 8 8
N
S S o o
o $ S N
x o � '^
8 p h
S O O O O vOi O O S O YC W `D
� e
S $ S 8 8 N a 8
8 8 o S 8 $ 8 S oc 8
m 06oN r
8 0 8 8 o S S S
m g$8 8 S 88 8 8
8 8 N g o 8 8 o S 8 8
N N
-
o
o $ S g S O
S
O O O O N N
N N N
.N.
w
U -
o
w
rz
d N
w
S 0 0 0o S r r $ S ry
e� Q S
14
� N
� K
N op p
O O O 8 8 8$ O S N N
N NNN
M
ZR
• F,,., F } $ V �m ."p. r7 �n '—�.' m L� X
F F 3 P
>'aa�m�
Q � C V j.y O N y yg5 z u Uh F 00 Vi Vi J y 1 L 1
E$° 3 3 3 3 0 3 w
ua uu�e> zauzu vyaw^w t-'wSv aaa ewua�wwv
"a i94
w w w w w www w w w w w w www w w w w w w w w w w w w w w w
•
� o6
e x
o
8 8 8
S S o o
ID
S
Y -
.15
-
0 0
_ o
N N
P P
O� O 00
T
C
8 8 8
e �
0 0
oc o"
o
Q Q
v o
N N N
cD
oc
8 8 8
N N
Q
0 8 8 8 8
O
v.
_
- o
a
a
P N O
1� O
O
N of
00 00
O
l r o
�0 3
c
c. r o.
8 $ 8
a
= 0 8
u
'J.
�-
N
Q _
_
9= E z
N
r
N N N N N N N N N
0qG ppC� Cq Ppb, {01C, ip�� fpX� R��j qR'a d d
N
G 1 4 G C Y C L L
d
G 6
C
•
•
•
0
8
�
S
O
O
h
O
O
S O
8
�
r
S O
r
O
O
O
N
N
O
O
N
8 gN�
� N
r
O S
y �O
O O
ADD
O
S 8 o
S 8 8
8
N
N tin M
�
G G CC O
N N N N
S
S S
8
a
8 8 F S
$
C
O
8
N
M
O m
8 T S
O TT
N R O
O
N
O
S
8 V
C
S O
O V
N O
Ci
V C
O
P
S S S
pp
O
S
M m n
..
n v W h
N
o
}
w
F w
F2" F2" A A
aE KA
6AF
N V V 0' u U J 0 0 0 0 0 O 00
F
.0 f�
Q
— v v en .ol Q F F F F H F F ti
0. v e e—— .� vim, ti h F 3 V. k`. y y h oC ti a h F h
M
aujwwwwujww wj
Ii
w w w w w w w w w w w w w w w w w w w w w
w
w w w w w w w w w w w w w w w w w w w
w
V
O O O O v. b vi
c O c
8 h
N N
N
�
C C
v01 v� v4Oi
r0
z x z z z z z
C o00 rOv
z x x z z a
z x
n
•
0
•
•
•
p7 b N Q 00 O
m h wMi V t�
�p p W 00 8r
P O O 8 8 b O O
P N Q N Q N Q
o og ss a 88
8 8 8 S 8 S S 8 S
M� p p Q N vNi pM W p Q
O S S S O O O 8 8 8
r P N r V ti O N
88 88 8 S 8 8 88
X88 88 &S 8 � 88
O0 1�
8 8
000 �r m voi g g g g
cT
8
a
8 8
W Q � O ri Vi O 00
o� o s 88
m O P. vQi v r Q O�
e
00 m b N P 0p `O Q ma
Qp �p N �O 00 O N
8 m v pm b Q8 VQ1
O Q S O S 000
N �O ff P N N yy G O�
o
10
8 Op p
8 p
8 0 0 Q O OOO`
z e�,
� o a
vice ww"oo < owwu�ayW
CY
C7 C7 T� Q '3 rwi,
04 �Fi1 L Ci .T. C! 7+ N 6' U U
8s� 8&888 �8 e
O jP O �88 � 8N N a0 N
e
I
•
EQUIPMENT AND BUILDING
INVENTORY
•
�J
Im
POLICE DEPARTMENT
200.
2010
CITY OF HOPKINS
CROWN VICTORIA
$30,000
• 201.
VEHICLE/EQUIPMENT INVENTORY
FORD
CROWN VICTORIA
28,100
202.
06/15/2011
FORD
CROWN VICTORIA
31,000
203.
2009
CURRENT
CROWN VICTORIA
28,160
205.
2011
REPLACEMENT
UNIT #
YEAR
MAKE
MODEL
COST
FIRE DEPARTMENT
29,000
207.
2010
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
104.
1991
PETERBILT
HEAVY RESCUE
190,000
106.
2004
FORD
CROWN VICTORIA
28,100
107.
1993
PETERBILT
PUMPER
225,000
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
206.
2007
FORD
CROWN VICTORIA
29,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
218.
2006
FORD
500
21,800
240.
1998
CHEV
P40 VAN
20,000
241.
2001
CHRYSLER
PT CRUISER
18,000
•
107
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2011
CURRENT
REPLACEMENT
UNIT # YEAR MAKE MODEL COST
STREET/TRAFFIC DIVISION
301.
1997
CHEV
302.
2006
FORD
304.
2000
FORD
305.
1997
FORD
307.
2006
FORD
308.
2011
FORD
309.
1995
CHEV
310.
1989
INTERNATIONAL
312.
2005
FREIGHTLINER
313.
2001
FORD
314.
1998
FORD
315.
1996
FORD
316.
1995
FORD
320.
1991
CATERPILLER
322.
2005
CATERPILLER
324.
2004
BOBCAT
325.
1998
JOHN DEERE
326.
1989
CATERPILLAR
327.
2001
ELGIN
330.
1989
INGERSOL/RAND
337.
1994
CATERPILLAR
342.
1991
TARGET
344.
1996
SNOGO
349.
1989
TRAIL -KING
350.
1993
TOWMASTER
351.
2004
TENNANT
PUBLIC WORKS - ADMINISTRATION
401. 2008 FORD
ENGINEERING DIVISION
3/4 TON
F250
F-450
1/2 TON
F350-1 TON DUMP
F350 - 2X4
1 TON TRK
SGLAX DUMP
SGLAX DUMP
L7501
LT 8500
L-8000
WATER TRK
LOADER 926E
LOADER 938G
SKID LOADER
SKID LOADER
140-G
PELICAN SE
ROLLER DD -25
BOX PAVER
CONCRETE SAW
WK 800
TK6V-1200
T14
SWEEPER 3640
CROWN VICTORIA
$21,000
26,500
34,000
18,300
27,400
20,300
28,000
70,000
98,000
72,000
86,000
85,000
81,000
90,000
157,800
30,000
24,000
82,000
105,000
23,000
18,000
2,400
58,000
3,000
4,000
10,000
$28,100
700. 2000 CHEV SUBURBAN $14,500
705. 2005 CHEV IMPALA 14,600
WIN
•
0
•
•
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2011
UNIT #
YEAR
MAKE
MODEL
CURRENT
REPLACEMENT
COST
BUILDING MAINTENANCE & EQUIPMENT SERVICES
701
1997
CHEV
C1500
$16,000
702
1992
CHEV
3/4 TON 4X4
16,000
703.
2002
CHEV
TAHOE
5,000
704.
2005
FORD
F250
24,000
PARKS/FORESTRY DIVISION
800.
803.
804.
805.
810.
811.
812.
815.
817.
818.
820.
821.
822.
823.
824.
825.
826.
828.
832.
833.
834.
836.
844.
845.
846.
HRA
411.
Is
2001
2004
2004
1998
1993
2006
2010
2010
1982
1996
2004
2004
2001
2006
1996
2010
2004
2001
1997
2004
1993
2010
1997
2001
FORD
FORD
FORD
DODGE
INTERNATIONAL
INTERNATIONAL
FREIGHTLINER
BOBCAT
FORD
TORO
TORO
TORO
TORO
JACOBSON
TORO
TORO
TORO
DEW EZE
VERMEER
BOBCAT
BRUSH BANDIT
RYAN
FELLING
REMACKEL
DRESSEN
2007 CHEV
RANGER4X4
F350
F350
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
ATM72
STUMP CTR 630A
SKID LOADER
CHIPPER 250
SOD CUTTER
TRAILER
TRAILER
8110
2500 HD
109
$18,000
23,000
23,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
4,000
5,000
2,000
$17,500
•
110
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2011
CURRENT
REPLACEMENT
UNIT #
YEAR
MAKE
MODEL
COST
WATER/SEWER
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
REFUSE
•
900.
2011
FREIGHTLINER
RAPID -RAIL M2
$201,000
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
•
110
CITY OF HOPKINS
BUILDING INVENTORY
June 2011
Location/Description Replacement Cost
City Hall
$3,400,900
1010 1st Street S.
Police Station
3,835,100
1010 1st Street S.
Fire Station
4,214,000
101 17th Avenue S.
Hopkins Activity Center
1,825,000
33 14th Avenue S.
Ice Arena/Pavilion
5,011,000
11000 Excelsior Boulevard
Arts Center
6,865,000
1111 Mainstreet
PW Admin/Garage
7,171,000
• 11100 Excelsior Boulevard
Moline Reservoir/Well #1
2,295,000
10421 Excelsor Boulevard
Blake Tower Reservoir
1,386,700
151 Tyler Avenue S.
Filtration Plant
3,372,000
1401 Elmo Park Service Road
Well #4 Workshop/Storage
649,400
1401 Elmo Park Service Road
Well #5
227,800
1205 Highway?
Well #6
303,800
801 Highway 7
Lift Station #2 - Drillane
65,000
619 Drillane Road
• Lift Station #3 - Lindee's
130,000
901 Cambridge Street N.E.
111
Location/Description
Replacement Cost
Lift Station #4 - LTL Meadowbrook
$95,000
244 Meadowbrook Road
Lift Station #5 - Big Meadowbrook
151,000
6601 Excelsior Blvd.
Lift Station #6 - Ronnie's
95,000
8546 Excelsior Avenue E.
Lift Station #7 - Valley
300,000
801 6th Avenue S.
Band Shell - Downtown Park
36,000
16 9th Avenue S.
Concession Stand - Maetzold Field
149,000
1215 1 st Street N.
Park Building -Beach - Lifeguards
160,800
5200 Shady Oak Road
Park Building -Beach -Concessions
152,000
5200 Shady Oak Road
Park Shelter - Office/Bathliouse
369,300
5200 Shady Oak Road
Park Shelter - Burnes
49,100
201 Park Lane
Park Building - Central
111,500
101 17th Avenue S.
Park Building - Harley
37,800
108 Jackson Avenue S.
Park Shelter - Interlachen
101,400
220 Homedale Avenue
Park Building - Oakes
43,100
301 Tyler Avenue N.
Park Building - Valley
50,600
800 7th Avenue S.
Parking Ramp 6,236,000
10th Avenue and Mainstreet
112
�J
Location/Description
Replacement Cost
• Depot Coffee House $469,000
9451 Excelsior Boulevard
r- I
Overpass Skate Park 7,500
100 Washington Avenue
Dow Towers (76 Units) HRA
22 5th Avenue S.
113
C