2012 - 2016 ERPCity of Hopkins
EQUIPMENT REPLACEMENT PLAN
2012-2016
13200City of qfopkzns
1010 First Street South • Hopkh: w 55343-7573 * Pham:952-935-8474 • FaX. 952-935-1834
- Web address: www.hop(tinsmn.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.
Tartnering with the Community to Enhance the QuaCty of Life
• Inspire • Educate • Involve • Communicate. •
1
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
Building Inventory
K
107
111
INTRODUCTION
EQUIPMENT REPLACEMENT PLAN 2012-2016
BACKGROUND AND SUMMARY OF CHANGES FROM 2011 PLAN
Background
The Equipment Replacement Plan is a twenty-year forecast and a five-year plan of equipment
needs in the City of Hopkins. It is intended to inform the Council and citizens of the major
equipment needs on the horizon. The first year of the plan becomes an adopted equipment
budget and relates to the operating budget of the equipment replacement fund, which is approved
on an annual basis. The remaining nineteen years represent an estimate of equipment needs and
funding capabilities of the City. Funding requirements vary from year to year. In order to
maintain a fairly consistent levy each year, the twenty-year schedule is projected with a 3%
inflation factor for operating expenses and a yearly average dollar capital expenditure of
$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 Chances 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.
61
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 '/2 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/4 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.
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.
11
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.
rA
CASH FLOW STATEMENT
K
EQUIPMENT REPLACEMENT FUND (602)
06/30/2011
Impact on General Fund
14,591
18,830
23,288
24,916
26,662
Rate Change
2%
3%
5%
6%
7%
7%
7%
ACTUAL
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
2010
2011
2012
2013
2014
2015
2016
Working Capital Begin Year
1,161,011
921,830
919,117
1,110,595
505,553
305,089
156,044
Revenues from charges
292,867
301,653
316,736
335,740
359,242
384,388
411,296
Transfer In - Pavilion - Capital Lease
20,000
20,000
20,000
15,609
Transfer In - Pavilion - Hockey Loan
3,143
3,143
3,143
3,143
3,142
Interest earnings
6,719
9,293
9,266
11,180
5,130
3,125
1,635
Other revenues (sale of assets)
13,760
25,000
25,000
25,000
30,000
30,000
30,000
Lease Financing
600,000
Total Revenues
336,489
359,089
974,144
390,672
397,514
417,514
442,931
Expenditures (excludes Depr.) (1)
24,743
25,485
18,250
18,798
19,361
19,942
20,541
Fire Truck Financing Pymnts (2009-2018)
53,891
54,217
54,217
54,217
54,217
54,217
54,217
Finance 6 items - annual finance cost
77,000
77,000
77,000
77,000
Eliminate 2 copiers in 2013 and lease
(35,000)
Capital Outlay - Equipment
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
Working Capital Ending Balance
921,830
919,117
1,110,595
505,553
305,089
156,044
32,018
Cash balance
929,273
926,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
K
0
N
N
N
CO
C
>
N
C
C
Q
Co
C)o
Ln
�
W
a
CB
Y
O
0
N
O
N
N
O
_
N
O
U
�
o
L
O
O
N
W
O
N
006
O
N
=
4%
0
o
CL
N
W
O
O
O
O
N�
O
A
N
W
O
O
N
N
O
O
N
O
O
N
O
O
O
I
N
O
O O O
O
O
O O O
O
O
O O O
O
O
O O O
O
LO
O LO- O
LO
FIVE-YEAR
PROJECT SUMMARIES
"l
City of Hopkins, MN
EQUIPMENT IMPROVEMENT PLAN
2012 thm 2016
PROJECTS BY YEAR
Project Name
Department
Project #
Priority
Project Cost
2012
Art Center Carpet Extractor
Arts Center
01 -ERP -1101
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
01 -ERP -0006
n/a
30,000
Core Network Switch
City Hall Administration
01 -ERP -0012
n/a
10,000
City Hall Main Copy Machine - Konica Copier
Community Services
01 -ERP -0001
n/a
0
Document Management Scanner (3)
Community Services
01 -ERP -0008
n/a
6,500
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Extrication Tool (2)
Fire
01 -ERP -0109
n/a
22,300
Workout Equipment - Treadmill
Fire
01 -ERP -0118
n/a
5,000
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
69,200
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
28,800
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
15,000
911 Phone System (Viper Phone)
Police
01 -ERP -0216
n/a
0
Engineering Printer/Scanner
Public Works: Engineering
01 -ERP -0701
n/a
0
4x4 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 -0817
n/a
7,400
1 Ton Dump Truck (2)
Public Works: Streets/Traffic
01 -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
01 -ERP -0308
n/a
172,000
Asphalt Hot Mix Heating Box
Public Works: Streets/Traffic
01 -ERP -0318
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 -1102
n/a
5,000
Network Server
City Hall Administration
01 -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
01 -ERP -0001
n/a
0
City Hall Small Copy Machine - Ricoh Copier
Community Services
01 -ERP -0002
n/a
0
Document Management Scanner (3)
Community Services
01 -ERP -0008
n/a
6,500
Election Equipment
Community Services
01 -ERP -0011
n/a
50,000
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Thermal Imaging Camera (2)
Fire
01 -ERP -0112
n/a
11,500
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
71,200
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
29,600
LOG IS Computer System
Police
01 -ERP -0208
n/a
200,000
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Mobile Data Computers
Police
01 -ERP -0212
n/a
62,700
Tactical Ballistic Vests
Police
01 -ERP -0214
n/a
23,200
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
15,000
Engineering Van
Public Works: Engineering
01 -ERP -0700
n/a
21,500
Thursday, June 30, 2011
12
Project Name Department Project # Priority Project Cost
Engineering Printer/Scanner
Public Works: Engineering
01 -ERP -0701
n/a
0
1/2 Ton Pickup Truck
Public Works: Parks/Forestry
01 -ERP -0800
n/a
26,400
3/4 Ton Utility Truck
Public Works: Parks/Forestry
01 -ERP -0802
n/a
32,200
Trucksters (3)
Public Works: Parks/Forestry
01 -ERP -0807
n/a
19,800
Riding Mowers (3)
Public Works: Parks/Forestry
01 -ERP -0808
n/a
22,800
Brush Chipper
Public Works: Parks/Forestry
01 -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
01 -ERP -0006
n/a
30,000
City Hall Main Copy Machine - Konica Copier
Community Services
01 -ERP -0001
n/a
0
Document Management Scanner (3)
Community Services
01 -ERP -0008
n/a
6,500
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Automated External Defibrillator (2)
Fire
01 -ERP -0120
n/a
7,200
Workout Equipment - Dumb Bells
Fire
01 -ERP -0122
n/a
5,000
HRA Copier
HRA
01 -ERP -0401
n/a
13,000
Ice Resurfacer
Pavilion
01 -ERP -1000
n/a
180,000
Electric Ice Edger
Pavilion
01 -ERP -1001
n/a
5,000
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
73,400
Utility 4x4 (unit 212)
Police
01 -ERP -0203
n/a
47,700
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
30,500
Logging Recorder
Police
01 -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
01 -ERP -0701
n/a
0
Riding Mowers (3)
Public Works: Parks/Forestry
01 -ERP -0808
n/a
30,600
Roller
Public Works: Streets/Traffic
01 -ERP -0312
n/a
45,900
Asphalt Paver
Public Works: Streets/Traffic
01 -ERP -0314
n/a
48,800
Refuse Truck(Rear-L)
Refuse
01 -ERP -0901
n/a
101,600
44 3/4 Ton Truck
Sewer
01 -ERP -0550
n/a
35,700
Total for 2014
836,917
2015
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
01 -ERP -0006
n/a
30,000
City Hall Main Copy Machine - Konica Copier
Community Services
01 -ERP -0001
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 -0116
n/a
5,800
Workout Equipment - Summit Trainer
Fire
01 -ERP -0117
n/a
5,800
Workout Equipment - Weight Lifting
Fire
01 -ERP -0119
n/a
5,800
44 3/4 Ton Truck
HRA
01 -ERP -0400
n/a
32,400
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
75,600
Sergeant's Vehicle
Police
01 -ERP -0201
n/a
37,800
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
31,400
Police Services Liaison Vehicle
Police
01 -ERP -0206
n/a
25,000
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
15,000
Thursday, June 30, 2011
13
Project Name Department Project # Priority Project Cost
Engineering Printer/Scanner
Public Works: Engineering
01 -ERP -0701
n/a
0
44 3/4 Ton Pickup with Plow
Public Works: Streets/Traffic
01 -ERP -0300
n/a
33,600
Sign Machine (Traffic)
Public Works: Streets/Traffic
01 -ERP -0317
n/a
13,400
Refuse Truck (RAP -R) (2)
Refuse
01 -ERP -0900
n/a
204,800
Public Works Copy Machine
Water
01 -ERP -0506
n/a
14,200
Total for 2015
734,417
2016
Network Server
City Hall Administration
01 -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
01 -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 -0105a
n/a
35,000
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Floor Scrubber
Fire
01 -ERP -0114
n/a
10,400
Floor Sweeper
Fire
01 -ERP -0115
n/a
3,900
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
n/a
77,800
Parking Enforcement Vehicle (Parking Fund)
Police
01 -ERP -0202
n/a
27,200
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
32,400
H.E.A.T. Vehicle
Police
01 -ERP -0205
n/a
30,000
Copy Machine - Police Dept
Police
01 -ERP -0209
n/a
22,100
Network Server (3)
Police
01 -ERP -0211
n/a
8,500
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
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
01 -ERP -0809
n/a
32,700
Skid Loader (2)
Public Works: Streets/Traffic
01 -ERP -0309
n/a
41,900
Snow Blower
Public Works: Streets/Traffic
01 -ERP -0315
n/a
102,300
3/4 Ton Utility Truck
Sewer
01 -ERP -0551
n/a
33,600
Total for 2016
620,817
GRAND TOTAL
4,009,085
Thursday, June 30, 2011
14
City of Hopkins, MN
EQUIPMENT IMPROVEMENT PLAN
2012 thm 2016
DEPARTMENT SUMMARY
Department 2012 2013 2014 201.5 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 IMPROVEMENT PLAN
2012 thra 2016
PROJECTS BY DEPARTMENT
Department
Project#
Priority
2012
2013
2014
2015
2016
Total
Activity Center
Activity Center Copy Machine
01 -ERP -0030
n/a
0
0
Activity Center Total
0
0
Arts Center
Art Center Carpet Extractor
01 -ERP -1101
n/a
3,900
3,900
Art Center Kitchen Catering Equipment
01 -ERP -1102
n/a
5,000
5,000
Art Center Video Camera Updates
01 -ERP -1103
n/a
3,200
3,200
Arts Center Total
7,100
5,000
12,100
City Hall Administration
Network Server
01 -ERP -0003
n/a
8,000
8,000
8,000
8,000
8,000
40,000
Telephone System
01 -ERP -0004
n/a
89,600
89,600
Computers
01 -ERP -0006
n/a
30,000
30,000
30,000
30,000
30,000
150,000
Core Network Switch
01 -ERP -0012
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
01 -ERP -0002
n/a
0
0
Document Management Scanner (3)
01 -ERP -0008
n/a
6,500
6,500
6,500
6,500
6,500
32,500
Election Equipment
01 -ERP -0011
n/a
50,000
50,000
Community Services Total
6,500
56,500
6,500
6,500
6,500
82,500
Fire
Duty Chief Vehicle
01 -ERP -0103
n/a
37,000
37,000
Fire Utility Vehicle (Pick Up Truck)
01 -ERP -0105a
n/a
35,000
35,000
Aerial Truck
01 -ERP -0106
n/a
54,217
54,217
54,217
54,217
54,217
271,085
Extrication Tool (2)
01 -ERP -0109
n/a
22,300
22,300
Thermal Imaging Camera (2)
01 -ERP -0112
n/a
11,500
11,500
Floor Scrubber
01 -ERP -0114
n/a
10,400
10,400
Floor Sweeper
01 -ERP -0115
n/a
3,900
3,900
Workout Equipment - Eliptical
01 -ERP -0116
n/a
5,800
5,800
Workout Equipment - Summit Trainer
01 -ERP -0117
n/a
5,800
5,800
Workout Equipment - Treadmill
01 -ERP -0118
n/a
5,000
5,000
Workout Equipment - Weight Lifting
01 -ERP -0119
n/a
5,800
5,800
Automated External Defibrillator (2)
01 -ERP -0120
n/a
7,200
7,200
Workout Equipment - Dumb Bells
01 -ERP -0122
n/a
5,000
5,000
Fire Total
81,517
65,717
66,417
108,617
103,517
425,785
16
Thursday, June 30, 2011
Department Project# Priority 2012 2013 2014 2015 2016 Total
HRA
4x43/4 Ton Truck
01 -ERP -0400
n/a
32,400
32.400
HRA Copier
01 -ERP -0401
n/a
13,000
13.000
HRA Total
13,000
32,400
45,400
Pavilion
Ice Resurfacer
01 -ERP -1000
n/a
180,000
180,000
Electric Ice Edger
01 -ERP -1001
n/a
5,000
5,000
Pavilion Total
185,000
185,000
Police
Marked Patrol Vehicles (6)
01 -ERP -0200
n/a
69,200
71,200
73,400
75,600
77,800
367,200
Sergeant's Vehicle
01 -ERP -0201
n/a
37,800
37,800
Parking Enforcement Vehicle (Parking Fund)
01 -ERP -0202
n/a
27,200
27,200
Utility 44 (unit 212)
01 -ERP -0203
n/a
47,700
47,700
Police Administrative Vehicles (2)
01 -ERP -0204
n/a
28,800
29,600
30,500
31,400
32,400
152,700
H.E.A.T. Vehicle
01 -ERP -0205
n/a
30,000
30,000
Police Services Liaison Vehicle
01 -ERP -0206
n/a
25,000
25,000
LOG IS Computer System
01 -ERP -0208
n/a
200,000
200,000
Copy Machine - Police Dept
01 -ERP -0209
n/a
22,100
22,100
Logging Recorder
01 -ERP -0210
n/a
36,900
36,900
Network Server (3)
01 -ERP -0211
n/a
8,500
8,500
8,500
8,500
8,500
42,500
Mobile Data Computers
01 -ERP -0212
n/a
62,700
62,700
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
Police Total
121,500
410,200
265,400
193,300
213,000
1,203,400
Public Works: Engineering
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
Public Works: Engineering Total
0
21,500
0
0
0
21,500
Public Works: Parks/Forestry
1/2 Ton Pickup Truck
01 -ERP -0800
n/a
26,400
26,400
44 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
Riding Mowers (3)
01 -ERP -0808
n/a
22,800
30,600
53,400
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
Public Works: Parks/Forestry Total
74,800
126,900
30,600
82,000
314,300
Public Works: Streets/Traffic
4x43/4Ton 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
17 Thursday, June 30, 2011
Department
Project#
Priority
2012
2013
2014
2015
2016
Total
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
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)
01-ERP-0901
n/a
101,600
101,600
Refuse Total
101,600
204,800
306,400
Sewer
4x4 3/4 Ton Truck
01-ERP-0550
n/a
35,700
35,700
3/4 Ton Utility Truck
01-ERP-0551
n/a
33,600
33,600
Sewer Total
35,700
33,600
69,300
Water
Backhoe Loader
01-ERP-0502
n/a
134,800
134.800
Public Works Copy Machine
01-ERP-0506
n/a
14,200
14.200
Water Total
134,800
14,200
1491.000
GRAND TOTAL
771,517
1,045,417
836,917
734,417
620,817
41.009,085
18 Thursday, June 30, 2011
City of Hopkins, MN
EQUIPMENT IMPROVEMENT PLAN
2012 thm 2016
FUNDING SOURCE SUMMARY
Source 2012 2013 201.1
AC - Arts Center Fund
Bonds/Lease
Equipment Replacement Fund
HRA - Housing and Redevelopment Authority
PA - Pavilion Fund
PKG - Parking Fund
RF - Refuse Fund
SF - Sanitary Sewer Fund
WF - Water Fund
GRAND TOTAL
2015 2016 Total
7,100
5,000
12,100
54,217
54,217
54,217
54,217
54,217
271,085
710,200
845,700
447,400
415,200
533,000
2,951,500
13,000
32,400
45,400
185,000
185,000
5,700
5,700
101,600
204,800
306,400
35,700
6,800
33,600
76,100
134,800
21,000
155,800
771,517
1,045,417
836,917
734,417
620,617
4,009,065
I
Thursday, June 30, 2011
City of Hopkins, MN
EQUIPMENT IMPROVEMENT PLAN
2012 thm 2016
PROJECTS BY FUNDING SOURCE
Source Project# Prioritv 2012 2013 2014 2015 2016 Total
AC - Arts Center Fund
Art Center Carpet Extractor
01 -ERP -1101
n/a
3,900
3,900
Art Center Kitchen Catering Equipment
01 -ERP -1102
n/a
5,000
5,000
Art Center Video Camera Updates
01 -ERP -1103
n/a
3,200
3,200
AC - Arts Center Fund Total
7,100
5,000
12,100
Bonds/Lease
Aerial Truck
01 -ERP -0106
n/a
54,217
54,217
54,217
54,217
54,217
271,085
Bonds/Lease Total
54,217
54,217
54,217
54,217
54,217
271,085
Equipment Replacement Fund
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
01 -ERP -0002
n/a
0
0
Network Server
01 -ERP -0003
n/a
8,000
8,000
8,000
8,000
8,000
40,000
Telephone System
01 -ERP -0004
n/a
76,000
76,000
Computers
01 -ERP -0006
n/a
30,000
30,000
30,000
30,000
30,000
150,000
Document Management Scanner (3)
01 -ERP -0008
n/a
6,500
6,500
6,500
6,500
6,500
32,500
Election Equipment
01 -ERP -0011
n/a
50,000
50,000
Core Network Switch
01 -ERP -0012
n/a
10,000
10,000
Activity Center Copy Machine
01 -ERP -0030
n/a
0
0
Duty Chief Vehicle
01 -ERP -0103
n/a
37,000
37,000
Fire Utility Vehicle (Pick Up Truck)
01 -ERP -0105a
n/a
35,000
35,000
Extrication Tool (2)
01 -ERP -0109
n/a
22,300
22,300
Thermal Imaging Camera (2)
01 -ERP -0112
n/a
11,500
11,500
Floor Scrubber
01 -ERP -0114
n/a
10,400
10,400
Floor Sweeper
01 -ERP -0115
n/a
3,900
3,900
Workout Equipment - Eliptical
01 -ERP -0116
n/a
5,800
5,800
Workout Equipment - Summit Trainer
01 -ERP -0117
n/a
5,800
5,800
Workout Equipment - Treadmill
01 -ERP -0118
n/a
5,000
5,000
Workout Equipment - Weight Lifting
01 -ERP -0119
n/a
5,800
5,800
Automated External Defibrillator (2)
01 -ERP -0120
n/a
7,200
7,200
Workout Equipment - Dumb Bells
01 -ERP -0122
n/a
5,000
5,000
Marked Patrol Vehicles (6)
01 -ERP -0200
n/a
69,200
71,200
73,400
75,600
77,800
367,200
Sergeant's Vehicle
01 -ERP -0201
n/a
37,800
37,800
Parking Enforcement Vehicle (Parking Fund)
01 -ERP -0202
n/a
27,200
27,200
Utility 4x4 (unit 212)
01 -ERP -0203
n/a
47,700
47,700
Police Administrative Vehicles (2)
01 -ERP -0204
n/a
28,800
29,600
30,500
31,400
32,400
152,700
H.E.A.T. Vehicle
01 -ERP -0205
n/a
30,000
30,000
Police Services Liaison Vehicle
01 -ERP -0206
n/a
25,000
25,000
LOG IS Computer System
01 -ERP -0208
n/a
200,000
200,000
Copy Machine - Police Dept
01 -ERP -0209
n/a
22,100
22,100
Logging Recorder
01 -ERP -0210
n/a
36,900
36,900
Thursday, June 30, 2011
20
Source Project# Priority
2012
2013
2014
2015
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
4x43/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
Riding Mowers (3)
01 -ERP -0808
n/a
22,800
30,600
53,400
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
4x43/4 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# Priority
2012 2013
2014
2015
2016
Total
Refuse Truck (Rear -L)
01 -ERP -0901
n/a
101,600
101.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
4x43/4 Ton Truck
01 -ERP -0550
n/a
35,700
35,700
3/4 Ton Utility Truck
01 -ERP -0551
n/a
33,600
33,600
SF - Sanitary Sewer Fund Total
35,700
6,800
33,600
76,100
WF - Water Fund
Telephone System
01 -ERP -0004
n/a
6,800
6,800
Backhoe Loader
01 -ERP -0502
n/a
134,800
134,800
Public Works Copy Machine
01 -ERP -0506
n/a
14,200
14,200
WF - Water Fund Total
134,800
21,000
1551.800
GRAND TOTAL
771,517 1,045,417
836,917
734,417
620,817
41.0091.085
Thursday, June 30, 2011
22
EQUIPMENT REQUESTS
23
P. i -V E
City of Hopkins,it
Project 4 01 -ERP -0001
Project Name City Hall Main Copy Machine - Konica Copier
2012 thru 2016
Type Equipment Department Community Services
Useful Life 5 years Contact City Clerk
Category Equipment Priority n/a
Future
Description I Total Project Cost: $107,200
Copy machine to service needs of all departments located at City Hall.
1. Variety of copying tasks.
2. High volume product copier.
Jote: 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 I
)aily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports,
,ouncil reports and updates, city code revisions, various department reports, and hearing and information notices.
Vlachine will duplex, sort, collate and staple copies.
Budget Impact/Other
Variance from 20 year plan - copier was to be replaced in 2011 but instead it is leased and expensed to the General
Fund.
Estimate salva�Wresale value on replaced item: $-0-
Prior Expenditures
107,200 Equipment
Total
2012 2013 2014 2015 2016
0 0 0 0 0
Total 0 0 0 0 0
Total Future
0 D
0 Total
Prior Funding Sources 2012 2013 2014 2015 2016 Total Future
107,200 Equipment Replacement Fund 0 0 0 0 0 0
Total Total 0 0 0 0 0 0 Total
Thursday, June 30, 2011
24
DIPIF-PIT-EIVI-IT-V E
City of Hopkins,it
Project 4 01 -ERP -0002
Project Name City Hall Small Copy Machine - Ricoh Copier
2012 thru 2016
Type Equipment Department Community Services
Useful Life 5 years Contact City Clerk
Category Equipment Priority n/a
Future
Description I Total Project Cost: $43,200
Coyy machine to service needs of all departments located at Citi Hall.
1, Variety of copying tasks.
2. High volume product copier.
Note: This is a Ricoh color copier.
Current eauinment: 2006 Ricoh 5560GW
Justification
daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports,
,ouncil reports and updates, city code revisions, various department reports, and hearing and information notices.
Vlachine 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
43,200 Equipment
Total
Total
Prior Funding Sources
43,200 Equipment Replacement Fund
Total Total
2012 2013 2014 2015
0
0
2012 2013 2014 2015
0
0
Pki
2016 Total Future
0
0 Total
2016
Total Future
0
0 Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0003
Project Name Network Server
2012 thru 2016
Type Equipment Department City Hall Administration
Useful Life 1 year Contact Finance Director/IT
Category Equipment Priority n/a
Future
Description I Total Project Cost: $233,000
Che nets,-ork server is the hub of the network. New computers are faster and more reliable.
Justification
Jetworking 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
iccuracy because as the information changes or is updated, every user is working with the same data.
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
Prior Expenditures
73,000 Equipment
Total
2012 2013 2014 2015 2016 Total Future
8,000 8,000 8,000 8,000 8,000 40,000 120,000
Total 8,000 8,000 8,000 8,000 8,000 40,000 Total
Prior Funding Sources
2012
2013
2014
2015
2016
Total
Future
73,000 Equipment Replacement Fund
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
Thursday, June 30, 2011
W,
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
'rojeet 4 01 -ERP -0004
'''°jest Name Telephone System
2012 thm 2016
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
ncludes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions
;erved by this system. Also includes software for the PBX and voice mail systems.
Justification
vlaking, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information
;ervices (snow line, etc.)
Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015.
Estimate salvage/resale value on replaced item: $
Prior Expenditures
60,000 Equipment
Total
Prior Funding Sources
2012 2013 2014 2015 2016 Total Future
89,600 8900 200,300
Total 89,600 89,600 Total
60,000 Equipment Replacement Fund
Total 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
Thursday, June 30, 2011
27
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0006
Project Name Computers
2012 thm 2016
Type Equipment Department City Hall Administration
Useful Life 3-5 years Contact Finance Director/IT
Category Equipment Priority n/a
Future
Description I Total Project Cost: $930,000
'ersonal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from
ndividual departments to one fund.
Justification
Cools enabling staff to perform job responsibilities efficiently and effectively.
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
Prior Expenditures
330,000 Equipment
Total
2012 2013 2014 2015 2016 Total Future
30,000 30,000 30,000 30,000 30,000 150,000 450,000
Total 30,000 30,000 30,000 30,000 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
Thursday, June 30, 2011
28
2012 thru 2016
City of Hopkins,it
Project # 01 -ERP -0008
Project Name Document Management Scanner (3)
Type Equipment Department Community Services
Useful Life 3 years Contact City Clerk
Category Equipment Priority n/a
Future
Description I Total Project Cost: $156,000
-arge document (11" x17') scanner for document management and retention as well as general administrative use
Chree scanners each replaced every three years.
Jne replaced in 2009, 2012, 2015 ....... — note we did not replace one in 2009; unit was repaired to extend the life
Jne replaced in 2010, 2013, 2016.........
Jne replaced in 2011, 2014, 2017 .............
One additional small scanner was added to the scanning station in 2009. This scanner previously was used by the
Inspections secretary. This scanner does not handle 11" x 17" paper so can not do all documents.
Scanners will be evaluated each vear for reblacement. If scanners are working Droberly their life will be extended.
Justification
Ne have been getting up to three Tree Trust volunteers to work on scanning and the small scanner only handles
locuments up to 8'/2" x 14". We would like to replace this scanner with a large document scanner to fully utilize our
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,000 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
26,000 Equipment Replacement Fund
Total Total
2012 2013
6,500 6,500
6,500 6,500
P
2014 2015
6,500 6,500
6,500 6,500
2016
6,500
6,500
Total
Future
32,500
97,500
32,500
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0011
Project Name Election Equipment
2012 thm 2016
Type Equipment Department Community Services
UsefulLife 10 years Contact City Clerk
Category Equipment Priority n/a
Future
Description I Total Project Cost: $117,200
Zeplace election M-100 ballot scanners and ballot boxes. - 9 machines total.
Justification
k11 Hennepin County equipment is being replaced in 2013.
ariance from 20 year plan - New item.
stimate salvage/resale value on replaced item: $-0-
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 Total
Future
Equipment Replacement Fund
50,000
50,000
67,200
Tom
50,000
50,000
Total
Thursday, June 30, 2011
at
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0012
Project Name Core Network Switch
2012 thru 2016
Type Equipment Department City Hall Administration
Useful Life 6 years Contact Finance Director/IT
Category Equipment Priority n/a
Future
Description I Total Project Cost: $53,300
3rovides layer 3 IP presence for the network, core switching connectivity, backbone on which all network
,ommunication is built and facilitates fibr optic network connection to fire department.
- Cisco 3560E-24PD managed switch - $3,000 each
- Cisco X2- l OGB-LR fiber optic transceiver - $1200 each
cost listed is for eaUlDment onlv and does not include tax. shmDmQ and other related costs
Justification
,urrent two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in
significant network outage that was immediately noticed by many employees.
Budget Impact/Other
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 salvage/resale value on replace item: - $-0-
Expenditures
Equipment
2012 2013 2014 2015 2016
10,000
Total 10,000
Total
Future
10,000
43,300
10,000
Total
Funding Sources
2012 2013
2014 2015 2016 Total
Future
Equipment Replacement Fund
10,000
10,000
43,300
Tom
10,000
10,000
Total
Thursday, June 30, 2011
01
P. i -V E
City of Hopkins,it
Project # 01 -ERP -0030
Project Name Activity Center Copy Machine
2012 thru 2016
Type Equipment Department Activity Center
Useful Life 7 years Contact Facilities Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $0
"opy machine used by staff for daily operations of the Hopkins Activity Center.
lCurrent equipment: Ricoh 22280
Justification
Copy flyers, letters, forms, informational items, etc.
Budget Impact/Other
Variance from 20 year plan - None
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 0 0
Total 0 0 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 0 0
Total 0 0 Total
Thursday, June 30, 2011
KY
City of Hopkins,it
Project 4 01 -ERP -0103
Project Name Duty Chief Vehicle
Type Equipment
Useful Life 5 years
Category Vehicles
Future
Department Fire
Contact Fire Chief
Priority n/a
2012 thm 2016
Description I Total Project Cost: $254,200
k marked passenger vehicle for use by the Duty Chief and Assistant Chiefs in transporting required equipment,
-eference materials and personnel for emergency response, and routine Fire Department business.
vehicles: 2010 Chevrolet Tahoe (Chief)
2006 Dodge Durango (Asst. Chief)
Chevrolet Impala (Asst. Chief) to be replaced with 2015 SUV
Justification
7sed by the Fire Chief and Asst. Chiefs when responding to fires and other emergencies. Used for official business in
tnd 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
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 Expenditures
64,500 Vehicles
Total
2012 2013 2014 2015 2016 Total Future
37,000 37,000 152,700
Total 37,000 37,000 Total
Prior Funding Sources 2012
2013 2014 2015 2016
Total
Future
64,500 Equipment Replacement Fund
37,000
37,000
152,700
Total Total
37,000
37,000
Total
Thursday, June 30, 2011
33
DIPIF-PIT-EIVI-IT-V E
City of Hopkins,it
Project 4 01 -ERP -0105a
Project Name Fire Utility Vehicle (Pick Up Truck)
Type Equipment Department Fire
Useful Life 5 years Contact Fire Chief
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $177,100
k pickup truck on a 4 wheel drive chassis.
"urrent vehicle: Lumina - used by Fire Insbector
2012 thru 2016
Justification
Nith getting rid of our light rescue, we will be losing a way to haul equipment back and forth from the fire scene to the
station. This vehicle would be used to haul equipment and personnel to and from the scene and can be used for people
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
Tom 35,000 35,000 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
Equipment Replacement Fund 35,000 35,000 142,100
Total 35,000 35,000 Total
Thursday, June 30, 2011
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
Department Fire
Contact Fire Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $2,559,597
)ne hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease
)ayments due 2009-2018 on 2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and
)ctober 23.
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
otal $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
608,078 Equipment
Total
Prior Funding Sources
608,078 Bonds/Lease
Total
2012 2013 2014 201-5 2016 Total Future
54,217 54,217 54,217 54,217 54,217 271,085 1,680,434
Tom 54,217 54,217 54,217 54,217 54,217 271,085 Total
2012 2013 2014 2015 2016 Total Future
54,217 54,217 54,217 54,217 54,217 271,085 1,680,434
Tom 54,217 54,217 54,217 54,217 54,217 271,085 Total
m
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
Description
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $136,900
2012 thru 2016
rescue and extrication tool with spreader, cutters and hN draulic ram.
Justification
k11 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.
Variance from 20 year plan - move back from 2015 to 2019.
Estimate salvage/resale value on replaced item: $1,000
Purchased: 2007
Prior Expenditures
20,300 Equipment
Total
2012 2013 2014 2015 2016
22,300
Total 22,300
Total
Future
22,300
94,300
22,300
Total
Prior Funding Sources
2012 2013
2014 2015 2016 Total
Future
20,300 Equipment Replacement Fund
22,300
22,300
94,300
Total Total
22,300
22,300
Total
Thursday, June 30, 2011
Kb:
EQUIPMENT IMPROVEMENT FLAN
City of Hopkins, MN
Project # 01 -ERP -0112
Project Name Thermal Imaging Camera (2)
Type Equipment
Useful Life 10 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $72,200
Jsed by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and
seat may be hidden allowing for faster extinguishment.
ote: Durchased 2005 & 2007
Justification
/urrent camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was
)urchased 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 salvage/resale value on revalced item: $-0-
Prior Expenditures
15,000 Equipment
Total
2012 2013 2014 2015 2016 Total Future
11,500 11,500 45,700
Tom 11,500 11,500 Total
Prior Funding Sources 2012
2013 2014
2015 2016 Total
Future
15,000 Equipment Replacement Fund
11,500
11,500
45,700
Total Total
11,500
11,500
Total
Thursday, June 30, 2011
37
EQUIPMENT IlVIPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0114
Project Name Floor Scrubber
Type Equipment
rTseful Life 12 rears
Category Equipment
Future
Department Fire
Contact Fire Chief
Prioiitv n
Description Total Project Cost: $25,200
door scrubber to keep apparatus floors clean.
2012 thri, 2016
Justification
icrubber is used to keep apparatus floors clean so that floor will last longer.
Variance from 20 year plan -
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013 201.4 2015 2016 Total Future
Equipment 10,400 10,400 14,800
Tom 10,400 10,400 Total
Funding Sources 2012
2013 201.1 2015 2016
Total
Future
Equipment Replacement Fund
10,400
10,400
14,800
Tom
10,400
10,400
Total
TIvirsdav, bine 30, 2011
38
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0115
Project Name Floor Sweeper
Type Equipment
Useful Life 12 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $9,400
;weeper that is used to clean apparatus floor prior to using scurbber.
Justification
;weeper is used to pick up debris before using scrubber. Sweeper uses less time to sweep floor.
ariance from 20 year plan - new item
stimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 3,900 3,900 5,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
KR,
KV, E
City of Hopkins,it
Project # 01 -ERP -0116
Project Name Workout Equipment - Eliptical
Type Equipment
Useful Life 6 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $20,300
A7orkout equipment used in Fire Department workout room. One eliptical machine replaced on a 6 year cycle, one
;very 3 years.
Justification
Chis equipment is available to all City employees for health and wellness.
ariance from 20 year plan - had two eliptical machines in the ERP. One was replaced along with the stairmaster with
summit trainer. The remaining eliptical is scheduled for replacement in 2015.
stimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 5,800 5,800 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
Thursday, June 30, 2011
Clt
�• , l ;�•KV, TEn 1`i•
City of Hopkins,it
Project 4 01 -ERP -0117
Project Name Workout Equipment - Summit Trainer
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Description I Total Project Cost: $34,300
Norkout equipment used in Fire Department workout room.
)ne summit trainer replaced on a 5 year cycle.
2010 Summit Trainer
2012 thru 2016
Justification
Chis equipment is available to all City employees for health and wellness.
Budget Impact/Other
Variance from 20 year plan - replaces stairmaster.
Estimate salvage/resale value on replaced item: $
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
5,000 Equipment 5,800 5,800 23,500
Total Total 5,800 5,800 Total
Prior Funding Sources
5,000 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
Ell
5,800
5,800
Total
Future
5,800
23,500
5,800
Total
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
2012 thru 2016
Description Total Project Cost: $25,300
Workout equipment used in the Fire Department workout room.
One treadmill replaced on a 5 year cycle.
Justification
This equipment is available to all City employees for health and wellness.
ariance from 20 year plan -move back one year from 2011 to 2012.
stimate salvage/resale value on replaced item: $
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
Thursday, June 30, 2011
Ey
DIPIF-PIT-EIVI-IT-V E
City of Hopkins,it
Project 4 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 I Total Project Cost: $29,300
smith machine - weight lifting machine.
2012 thru 2016
Justification
for use by Police, Fire, Public Works, City staff to keep in shape to perforin 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
Thursday, June 30, 2011
43
EQUIPMENT IMPROVEMENT FLAN
City of Hopkins, MN
Project 4 01 -ERP -0120
Project Name Automated External Defibrillator (2)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Description
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $49,100
2012 thru 2016
inllator is used to help get someones heart restarted during a cardiac arrest.
2 - both are replaced at one time due to changing technology.
rrent equipment: 2010 - 4 AEDs
10 ERP had 2 AEDs schedule for replacement at $6,000. Four were
Justification
With changes in technology, the AED's should be replaced every four years.
"ost - $3,000 per unit
Budget Impact/Other
Variance from 20 year plan - adjustment from 3 years to 4 years.
Estimate salvage/resale value on replaced item: $
Prior Expenditures
6,000 Equipment
Total
1
2012 2013 2014 2015 2016 Total Future
7,200 7,200 35,900
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
Thursday, June 30, 2011
44
EQUIPMENT IMPROVEMENT FLAN
City of Hopkins, MN
Project # 01 -ERP -0122
Project Name Workout Equipment - Dumb Bells
Type Equipment
Useful Life 10 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Description I Total Project Cost: $11,700
A7orkout equipment used in Fire Department workout room.
2012 thru 2016
Justification
'urrent dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead
)ased plaint. This purchase would update our dumb bells to the current type fitness bells.
ariance from 20 year plan - Move back from 2012 to 2014.
stimate 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
Tom
5,000
5,000
Total
Thursday, June 30, 2011
W
City of Hopkins,it
Project 4 01 -ERP -0200
Project Name Marked Patrol Vehicles (6)
Type Equipment
Useful Life 3 years
Category Vehicles
Future
Department Police
Contact Police Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $2,495,500
vlarked 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.
xrent vehicles: (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria, (2) 2008 Ford Crown Victorias, (1)
07 Ford Crown Victoria
Justification
;et 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.
Budget Impact/Other
Variance from 20 year plan - Original replacement schedule was modified several years ago during the LGA cuts. The
proposed purchase schedule is to realign the replacement of squads more evenly.
Estimate salvage/resale value on replaced item: $4,000 each
Prior Expenditures
637,700 Vehicles
Total
2012 2013
69,200 71,200
Tom 69,200 71,200
2014
2015
73,400
75,600
73,400
75,600
2016
77,800
77,800
Total
Future
367,200
1, 490,600
367,200
Total
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
Thursday, June 30, 2011
Cf:
City of Hopkins,it
Project 4 01 -ERP -0201
Project Name Sergeant's Vehicle
Type Equipment
Useful Life 4 years
Category Vehicles
Future
Department Police
Contact Police Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $276,400
vlarked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perforin general patrol duties.
1 year rotation.
lCurrent vehicle: 2011 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 Impact/Other
Variance from 20 year plan - none.
Estimate salvage/resale value on replaced item: $3,500 each
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
33,600 Vehicles 37,800 37,800 205,000
Total Total 37,800 37,800 Total
Prior Funding Sources
33,600 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
47
37,800
37,800
Total
Future
37,800
205,000
37,800
Total
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
?arkin, enforcement vehicle.
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $82,500
2012 thru 2016
lCurrent vehicle: 2006 Jeep Liberty
Justification
Use by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown area.
Budget Impact/Other
Variance from 20 year plan - amount allocated is not sufficient. Increase to $27,200.
Estimate salvage/resale value on replaced item: $1,500
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
36,600
Total Total
27,200
27,200
Total
Thursday, June 30, 2011
48
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project 4 01 -ERP -0203
Project Name Utility 4x4 (unit 212)
Type Equipment Department Police
Useful Life 6 years Contact Police Chief
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $247,600
1 wheel drive uitility vehicle.
Current vehicle: 2008 Chevrolet Tahoe
2012 thm 2016
Justification
Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals, prisoners and
equipment. The 4 wheel drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme
snow conditions.
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 Funding Sources
67,400 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016 Total Future
47,700 47,700 132,500
47,700 47,700 Total
Thursday, June 30, 2011
2012 thru 2016
City of Hopkins,it
Project # 01 -ERP -0204
Project Name Police Administrative Vehicles (2)
Type Equipment Department Police
Useful Life 2 years Contact Police Chief
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $1,013,300
'olice administrative and detective vehicles.
Zeplace Chiefs vehicle - even numbered years
Zeplace Captain's vehicle - odd numbered years
Current vehicles: 2009 Chevrolet Impala, 2008 Ford Taunus
Justification
Future
Unmarked vehicles, equipped with radios, siren and red grille lites used by chief and captain. Staff use is for two years.
Vehicles are then rotated down to detectives and are kept for an additional 3-4 years. Vehicles are also used for
surveillance by uniform and plain clothes officers.
Budget Impact/Other
152,700
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $4,000 each
Prior Expenditures 2012 2013 2014 2015
2016 Total Future
240,300 Vehicles 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
Prior Funding Sources
240,300 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
28,800 29,600 30,500 31,400 32,400
28,800 29,600 30,500 31,400 32,400
6
Total
Future
152,700
620,300
152,700
Total
Thursday, June 30, 2011
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 thm 2016
Description I Total Project Cost: $76,700
Jnmarked van to transport police tactics team for high risk calls, training and mutual aid.
lCurrent vehicle: 1998 Chevrolet Cube Van
Justification
Previous 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 I
Estimate salvage/resale value on replaced item: $3,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 30,000 30,000 46,700
Tom 30,000 30,000 Total
Funding Sources 2012 2013 2014 2015 2016
Equipment Replacement Fund
Total
611
30,000
30,000
Total
Future
30,000
46,700
30,000
Total
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
Priority n/a
2012 thru 2016
Description I Total Project Cost: $63,900
7sed by Police Services Liaison/JCPP Liaison for transport to schools, neighborhood meetings, training and public
-elations events.
lCurrent vehicle: 2001 Chrysler PT Cruiser
Justification
2001 PT Cruiser was leased to the Police Department for a nominal fee and detailing and wheels were also donated.
The 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.
3stimate salvage/resale value on replaced item: $1,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 25,000 25,000 38,900
Tom 25,000 25,000 Total
Funding Sources 2012 2013 2014 2015 2016
Equipment Replacement Fund
Total
6YA
25,000
25,000
Total
Future
25,000
38,900
25,000
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016
City of Hopkins, MN
Project # 01 -ERP -0208
Project Name LOGIS Computer System
Type Equipment Department Police
Useful Life 20 years Contact Police Chief
Category Equipment Priority n/a
Future
Description Total Project Cost: $200,000
Computer system for records management and retention of Police Department in addition to computer aided dispatch
(CAD) and mobile data computer in squads.
Looking at the LOGIS RMS/CAD/Mobile system.
Computer system and maintenance -
Year 1 - $200,000 est to include software, licenses, implementation and training, data conversion, and network
connectivity.
Year 2 - $95,800 - this is maintenance and should be budgeted in Dept budget
about a 10% increase each subsequent year
Year 2 through ?? Includes software/hardware support in addition to builing reserves for future upgrades
Justification
To store, retrieve and transfer required data to State and perform data entry, inquiries of local, state and national crime
databases.
The 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
Funding Sources 2012
200,000
2013 2014
200,000
2015 2016 Total
Equipment Replacement Fund
200,000
200,000
Total
200,000
200,000
Thursday, June 30, 2011
53
City of Hopkins,it
Project 4 01 -ERP -0209
Project Name Copy Machine - Police Dept
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $161,600
'olice Department copy machine capable of producing double side copies and collating pages, color/BW, fax
icabability and scan..
2006 Ricoh 2051 SP
Justification
7sed to make duplicate copies of reports, letters, memos, etc., generated by police personnel, fax and scan..
Budget Impact/Other
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 2016
Total
Future
49,800 Equipment Replacement Fund
22,100
22,100
89,700
Total Total
22,100
22,100
Total
Thursday, June 30, 2011
54
City of Hopkins,it
Project # 01 -ERP -0210
Project Name Logging Recorder
Type Equipment
Useful Life 7 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $138,100
Che police logging recorder is a device which records all telephone and radio transmissions produced/received by the
3olice Department.
2005 Mercom losminu recorder
Justification
Zecords all incoming/outgoing phone calls from the dispatch center and all radio transmissions from police, fire and
nterop radio talkgroups. Equipment is necessary in case questions arise as to how calls for service or events were
landled 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
Tom 36,900 36,900 Total
Funding Sources 2012 2013 2014 2015 2016
Equipment Replacement Fund
Total
61
36,900
36,900
Total
Future
36,900
101,200
36,900
Total
Thursday, June 30, 2011
City of Hopkins,it
Project 4 01 -ERP -0211
Project Name Network Server (3)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Department Police
Contact Police Chief/IT
Priority n/a
2012 thru 2016
Description Total Project Cost: $246,500
omputer servers store information and system programs.
)ne 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.
Variance from 20 year plan - Cost stabilized at $8,500 per year.
Estimate salvage/resale value on replaced item - $
Prior Expenditures
76,500 Equipment
Total
2012 2013 2014 2015 2016 Total Future
8,500 8,500 8,500 8,500 8,500 42,500 127,500
Total 8,500 8,500 8,500 8,500 8,500 42,500 Total
Prior Funding Sources
2012
2013
2014
2015
2016
Total
Future
76,500 Equipment Replacement Fund
8,500
8,500
8,500
8,500
8,500
42,500
127,500
Total Total
8,500
8,500
8,500
8,500
8,500
42,500
Total
Thursday, June 30, 2011
6'S:
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0212
Project Name Mobile Data Computers
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n/a
2012 thru 2016
Description I Total Project Cost: $297,800
vlobile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various
latabases. communicate car to car.
Justification
-imited life of 5 years - replacement necessary.
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
Estimate salvage/resale value on replaced item: $-0-
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
47,000 Equipment
Total
62,700 62,700 188,100
Total 62,700 62,700 Total
Prior Funding Sources
47,000 Equipment Replacement Fund
Total PKG - Parking Fund
Total
2012 2013 2014 2015 2016
57,000
5,700
62,700
57
Total Future
57,000 188,100
5,700 Total
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 thru 2016
Description I Total Project Cost: $256,200
)igital video camera system in each marked patrol car - used to document events in and out of the patrol car. Images
lownloaded 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 equipment bid.
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 2012
2013 2014 2015
2016 Total
Future
42,600 Equipment
53,400
53,400
160,200
Total Total
53,400
53,400
Total
Prior Funding Sources
42,600 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
53,400
53,400
58
Total
Future
53,400
160,200
53,400
Total
Thursday, June 30, 2011
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
Department Police
Contact Police Chief
Priority n/a
2012 thm 2016
Description I Total Project Cost: $137,500
Cactical 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
20,000 Equipment
Total
2012 2013 2014 201-5 2016
23,200
Total 23,200
Total
Future
23,200
94,300
23,200
Total
Prior Funding Sources 2012
2013 2014
2015 2016 Total
Future
20,000 Equipment Replacement Fund
23,200
23,200
94,300
Total Total
23,200
23,200
Total
Thursday, June 30, 2011
6R
P. i -V E
City of Hopkins,it
Project # 01 -ERP -0215
Project Name Radios - Portable and Mobile Devices
Type Equipment Department Police
Useful Life Contact Police Chief
Category Equipment Priority n/a
Future
Description I Total Project Cost: $300,000
2012 thru 2016
Portable and mobile radios used by the police, fire and public works departments to allow these departments to
communicate on one frequency. Police and fire use their radios on a daily/regular basis. The public works only uses
theirs in the event of an emergency.
Estimated 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.
ariance from 20 year plan - added replacement cost at $15,000 per year fixed, starting in 2012. Do not expect all 132
adios to need replacing at one time.
stimate 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
Tom 15,000 15,000 15,000 15,000 15,000 75,000 Total
Funding Sources 2012 2013 2014 2015 2016
Equipment Replacement Fund
Total
15,000 15,000 15,000 15,000 15,000
15,000 15,000 15,000 15,000 15,000
� i�
Total
Future
75,000
225,000
75,000
Total
Thursday, June 30, 2011
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.
rrent plans call for leasing of new Viper phone equipment.
month lease at $2,015 per month. No payoff or buyout at the end - we will own outright. Lease includes hardware,
tware, Evergreen software support for term of lease and hardware maintenance for 1 year. Subsequent years
dware 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 - approximately $944.
Justification
analog 911 phone system has never been in the ERP. The equipment was leased until November 2010 when
ng options expired and the equipment was purchased for $1.00. The current service provider will not guarantee
availability or maintenance service beyond our current maintenance agreement which ends in April 2012. They
review contracts on a case by case basis. The equipment is discontinued and parts are no longer manufactured and
ed in availability. The 911 next generation phone technology is digital and internet based. The state of MN 911
.ce 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 salvaee/resale value on reblaced item: -0-
Expenditures 2012 2013 2014 201.5 2016 Total
Equipment 0 0
Total 0 0
Thursday, June 30, 2011
City of Hopkins, MN
Funding Sources 2012 2013
Equipment Replacement Fund
lm
2012 thru 2016
2014 2015 2016 Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0300
Project Name 4x4 3/4 Ton Pickup with Plow
2012 thm 2016
Type Equipment Department Public Works: Streets/Traffic
UsefulLife 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $103,800
?ickup used by various divisions of Public Works.
lCurrent 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
pickup.
Estimate salva�Wresale value on replaced item: $1,500
Prior Expenditures
25,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
25,000 Equipment Replacement Fund
33,600
33,600
45,200
Total Total
33,600
33,600
Total
Thursday, June 30, 2011
63
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project 4 01 -ERP -0301
Project Name 4X4 3/4 Ton Truck with Plow
2012 thru 2016
Type Equipment Department Public Works: Streets/Traffic
Useful Life 8 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description Total Project Cost: $141,700
3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers.
lCurrent vehicle: 2006 Ford F250
Justification
Light hauling, pulling trailers, transportation to and from job sites.
Budget Impact/Other
(Variance from 20 year plan - none I
Estimate salvage/resale value on replaced item: $1,500
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
24,000 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
30,400
30,400
64
Total
Future
30,400
87,300
30,400
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0303
Project Name 1 Ton Dump Truck (2)
2012 thru 2016
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
Cruck 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 Impact/Other
(Variance from 20 year plan - move back from 2009 to 2010. I
Estimate salvage/resale value on replaced item: $3,500
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
67,900 Vehicles 34,700 34,700 102,900
Total Total 34,700 34,700 Total
Prior Funding Sources
67,900 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
34,700
34,700
Ai
Total
Future
34,700
102,900
34,700
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0304
Project Name 1 Ton Traffic Boom Truck
2012 thru 2016
Type Equipment Department Public Works: Streets/Traffic
Useful Life 17 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description 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.
Budget Impact/Other
(Variance from 20 year plan - Increase amount to reflect actual. I
Estimate salvage/resale value on replaced item: $8,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 82,500 82,500 136,400
Tom 82,500 82,500 Total
Funding Sources 2012 2013 2014 2015 2016
Equipment Replacement Fund 82,500
Tom 82,500
1Y:
Total
Future
82,500
136,400
82,500
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0305
Project Name Single Axle Dump Truck (3)
2012 thru 2016
Type Equipment Department Public Works: Streets/Traffic
Useful Life 17 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $674,100
tingle axle dump truck used by various division of Public Works.
lCurrent vehicles: 2001 Ford L7501 & 2004 Freightliner M2 106
Justification
Vehicle used for heavy hauling, snow plowing and sanding.
Adding 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 (chane from 2) dump truck and 1 tandem axel dump truck.
Prior Expenditures
80,000 Vehicles
Total
2012 2013 2014 2015 2016 Total Future
127,400 127,400 466,700
Total 127,400 127,400 Total
Prior Funding Sources
2012 2013
2014 2015 2016 Total
Future
80,000 Equipment Replacement Fund
127,400
127,400
466,700
Total Total
127,400
127,400
Total
Thursdav, htne 30, 2011
67
�• , KV, E
City of Hopkins,it
Project 4 01 -ERP -0308
Project Name Front End Loaders (2)
Type Equipment
Useful Life 15-18 years
Category Equipment
Future
Description
1991
Justification
Budget Impact/Other
2012 thru 2016
Department Public Works: Streets/Traffic
Contact Public Works Director
Priority n/a
Total Project Cost: $848,600
illar 928E Loader & 2005 Caterpillar 938G
Variance from 20 year plan - None
Estimate salvage/resale value on replaced item: $
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
140,000 Equipment 172,000 172,000 536,600
Total Total 172,000 172,000 Total
Prior Funding Sources 2012 2013 2014 2015 2016
140,000 Equipment Replacement Fund 172,000
Total Total 172,000
68
Total
Future
172,000
536,600
172,000
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0309
Project Name Skid Loader (2)
2012 thru 2016
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.
Justification
Budget Impact/Other
1998 John Deere 8875 Skid Loader & 2004 Bobcat 5-1851R Skid Loader
Variance from 20 year plan - move back from 2010 to 2011.
Estimate salvage/resale value on replaced item: $
Prior Expenditures 2012 2013 2014 21115 2016 Total Future
36,000 Equipment 41,900 41,900 109,700
Total Total 41,900 41,900 Total
Prior Funding Sources
36,000 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
[X
41,900
41,900
Total
Future
41,900
109,700
41,900
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0311
Project Name Sweeper
2012 thru 2016
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: $494,700
>treet sweeper used by Streets Division for sweeping streets and parking lots.
lCur ent equipment: 2001 Elgin Pelican SE
Justification
Street sweeping, event clean-up, spring sand removal.
Budget Impact/Other
(Variance from 20 year plan - none I
Estimate salvage/resale value on replaced item: $12,000
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
115,300 Equipment 156,400 156,400 223,000
Total Total 156,400 156,400 Total
Prior Funding Sources
115,300 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
156,400
156,400
0
Total
Future
156,400
223,000
156,400
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0312
Project Name Roller
2012 thru 2016
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
Jsed by Street Department for asphalt repair and resurfacing.
1989 Inizersoll 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
Tom 45,900 45,900
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 45,900 45,900
Total
rfl
45,900
45,900
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0314
Project Name Asphalt Paver
2012 thru 2016
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: $48,800
ksphalt paver used by Streets Division of Public Works.
-ur ent equipment: 1994 Cate-
Justification
?aving streets and parking lots.
Budget Impact/Other
AD200B Paver
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
Tom 48,800 48,800
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 48,800 48,800
Total
MAI
48,800
48,800
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0315
Project Name Snow Blower
2012 thru 2016
Type Equipment Department Public Works: Streets/Traffic
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description Total Project Cost: $102,300
;now blower used by the Streets Division of Public Works.
-ur ent equipment: 1995 SnoGo WKS00
Justification
3lowing and loading snow off Mainstreet into trucks.
Budget Impact/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
Tom 102,300 102,300
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 102,300 102,300
Total
73
102,300 102,300
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0317
Project Name Sign Machine (Traffic)
2012 thru 2016
Type Equipment Department Public Works: Streets/Traffic
UsefulLife 10 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $31,500
vlahcine used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city
lCur ent equipment: 2005 Signcad Sign Making System
Justification
Existing machine is not repairable and needs updating/
Budget Impact/Other
Variance from 20 year plan - new
Estimate salvage/resale value on replaced item: $-0-
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 13,400 13,400 18,100
Tom 13,400 13,400 Total
Funding Sources 2012 2013 2014 2015 2016
Equipment Replacement Fund
Total
74
13,400
13,400
Total
Future
13,400
18,100
13,400
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0318
Project Name Asphalt Hot Mix Heating Box
2012 thm 2016
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
k slide in truck mounted unit with built in heat source to heat up or keep heated asphalt mix when used in patching or
;treet 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 oneratin�4.
Variance from 20 year plan - New item.
Estimate salvage/resale value on replaced item: $-0-.
Expenditures
Equipment
2012 2013 2014 201-5 2016
15,500
Total 15,500
Total
Future
15,500
22,100
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
Thursday, June 30, 2011
OR
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project 4 01 -ERP -0400
Project Name 4x4 3/4 Ton Truck
Type Equipment
Useful Life 8 years
Category Vehicles
Future
Department HRA
Contact Unassigned
Priority n/a
2012 thru 2016
Description I Total Project Cost: $148,400
1 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
22,800 HRA - Housing and Redevelop
Total Total
2012 2013 2014 2015 2016
rc.:
32,400
32,400
Total
Future
32,400
93,200
32,400
Total
Thursday, June 30, 2011
City of Hopkins,it
Project 4 01 -ERP -0401
Project Name HRA Copier
Type Equipment
Useful Life 8 years
Category Equipment
Future
2012 thru 2016
Department HRA
Contact Finance Director
Priority n/a
Description I Total Project Cost: $50,400
"olor copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks.
Current equipment: Imagistics 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
Funding Sources
13,000 13,000 37,400
Tom 13,000 13,000 Total
HRA - Housing and Redevelop
Total
2012 2013 2014 2015 2016
77
13,000
13,000
Total
Future
13,000
37,400
13,000
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0502
Project Name Backhoe Loader
2012 thru 2016
Type Equipment Department 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.
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
`)'off 134,800 134,800
Funding Sources 2012 2013 2014 2015 2016 Total
WF - Water Fund 134,800 134,800
Total 134,800 134,800
Thursday, June 30, 2011
78
KV, E
City of Hopkins,it
Project 4 01 -ERP -0506
Project Name Public Works Copy Machine
2012 thru 2016
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
"opv machine to service needs of all division of Public Works.
lCur ent equipment: 2005 Ricoh Aficio 2238C
Justification
Making copies for various departments.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $800
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
22,800 Equipment 14,200 14,200 57,700
Total Total 14,200 14,200 Total
Prior Funding Sources
22,800 WF - Water Fund
Total
Total
2012 2013 2014 2015 2016
0*1
14,200
14,200
Total
Future
14,200
57,700
14,200
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0550
Project Name 4x4 3/4 Ton Truck
2012 thru 2016
Type Equipment Department Sewer
UsefulLife 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $110,300
Fruck used by Water/Sewer Division of Public Works.
lCurrent vehicle: 2004 Chevrolet Pickup
Justification
Snow plowing, light hauling, pulling trailers, general purpose transportation.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
26,600 Vehicles 35,700 35,700 48,000
Total Total 35,700 35,700 Total
Prior Funding Sources
26,600 SF - Sanitary Sewer Fund
Total Total
2012 2013 2014 2015 2016
80
35,700
35,700
Total
Future
35,700
48,000
35,700
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0551
Project Name 3/4 Ton Utility Truck
2012 thru 2016
Type Equipment Department Sewer
UsefulLife 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description Total Project Cost: $129,800
3/4 ton utility truck used by the Water/Sewer Division of Public Works.
ICurrrent vehicle: 2007 Chevrolet Pickup
Justification
Transportation to and from job sites, box carries tools used by personnel for -Job site repairs and light hauling.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $2,500
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
51,000 Vehicles 33,600 33,600 45,200
Total 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
Thursday, June 30, 2011
81
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
'roject # 01 -ERP -0700
'roject Name Engineering Van
2012 thru 2016
Type Equipment Department Public Works: Engineering
UsefulLife 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $66,400
fan used by Engineering Department for survey equipment and on job site work.
lCurrent vehicle: 2000 Chevrolet Suburban
Justification
Transportation to and from job site, hauling of surveying and traffic counting equipment.
Budget Impact/Other
Variance from 20 year plan - increase amount from 14,300 to 16,000 to reflect actual cost. Purchase used Suburban
from Hennepin Co. 2002 auction -price is $13,000 to $14,000 + $2,000 for equipment.
Estimate salvage/resale value on replaced item: $2,500
Prior Expenditures
16,000 Vehicles
Total
2012 2013 2014 2015 2016 Total Future
21,500 21,500 28,900
Total 21,500 21,500 Total
Prior Funding Sources 2012
2013 2014
2015 2016 Total
Future
16,000 Equipment Replacement Fund
21,500
21,500
28,900
Total Total
21,500
21,500
Total
Thursday, June 30, 2011
82
EQUIPMENT IlVIPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0701
Project Name Engineering Printer/Scanner
2012 thrit 2016
Type Equipment Department Public Works: Engineering
Useful Life 5 rears Contact Public Works Director
Category Equipment Prioiitp n
Future
Description I Total Project Cost: $54,560
Printer/scanner - large format copier use in Engineering to copy blueprints, plans and large documents.
Equipment is leased.
Beginning in 2012 the lease has been moved to the GF Engineering budget.
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 201=4 2015 2016 Total Future
54,560 Equipment 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
TIvirsdav, bine 30, 2011
83
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0800
Project Name 1/2 Ton Pickup Truck
2012 thru 2016
Type Equipment Department Public Works: Parks/Forestry
UsefulLife 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $61,800
?ickup used by Park Division of Public Works.
"urrent vehicle: 2001 Ford
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
Vehicles 26,400
Tom 26,400
Funding Sources 2012 2013 2014 2015
Equipment Replacement Fund
Total
26,400
26,400
84
2016 Total Future
26,400 35,400
26,400 Total
2016 Total Future
26,400 35,400
26,400 Total
Thursday, June 30, 2011
2012 thru 2016
City of Hopkins,it
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.
lCurrent 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 Expenditures 2012 2013 2014 2015 2016 Total Future
53,200 Vehicles 67,400 67,400 193,200
Total Total 67,400 67,400 Total
Prior Funding Sources
53,200 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
67,400
67,400
85
Total
Future
67,400
193,200
67,400
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0802
Project Name 3/4 Ton Utility Truck
2012 thru 2016
Type Equipment Department Public Works: Parks/Forestry
Useful Life 14 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description Total Project Cost: $80,900
>/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc.
tround the city.
Current 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
Vehicles 32,200
Tom 32,200
Funding Sources 2012 2013 2014 2015
Equipment Replacement Fund
Total
32,200
32,200
86
2016 Total Future
32,200 48,700
32,200 Total
2016 Total Future
32,200 48,700
32,200 Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0806
Project Name Tractor
2012 thru 2016
Type Equipment Department Public Works: Parks/Forestry
Useful Life 30 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description Total Project Cost: $49,300
,arm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration, plowing
tnd grass seeding.
lCurrent equipment: 1984 Ford Tractor 2910 (4816)
Justification
Budget Impact/Other
Variance from 20 year plan - Delete one tractor (2012) to be placed by ToolCat (2010). Move second tractor to 2016.
3stimate salvage/resale value on replaced item: $3,500
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 49,300 49,300
Tom 49,300 49,300
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 49,300 49,300
Total
87
49,300 49,300
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0807
Project Name Trucksters (3)
2012 thru 2016
Type Equipment Department Public Works: Parks/Forestry
Useful Life 15 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $114,700
Cruckster used by Parks Division of Public Works for ballfield and parks maintenance.
1996 Toro Workman. 2004 Toro Workman 3200. 2004 Toro Workman 2110
Justification
?ark maintenance, ballfield grooming and Weed spraying.
Budget Impact/Other
(Variance from 20 year plan - Move from 2012 to 2013. I
Estimate salvage/resale value on replaced item: $1,400 each
Prior Expenditures 2012 2013 2014 2015 2016 Total Future
29,900 Equipment 19,800 19,800 65,000
Total Total 19,800 19,800 Total
Prior Funding Sources
29,900 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
19,800
19,800
88
Total
Future
19,800
65,000
19,800
Total
Thursday, June 30, 2011
�• , KV, E
City of Hopkins,it
Project # 01 -ERP -0808
Project Name Riding Mowers (3)
2012 thru 2016
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
Ziding mowers used by Parks Divison of Public Works.
lCurrent equipment: 1996 Toro Groundmaster 345, 2004 Toro Zero Turn, 2006 Jacobson Rotary Mower
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 2012 2013 2014 2015 2016 Total Future
49,000 Equipment 22,800 30,600 53,400 153,300
Total Tom 22,800 30,600 53,400 Total
Prior Funding Sources
49,000 Equipment Replacement Fund
Total Total
2012 2013 2014 2015 2016
22,800
22,800
89
30,600
30,600
Total
Future
53,400
153,300
53,400
Total
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
Justification
2012 thru 2016
Department Public Works: Parks/Forestry
Contact Public Works Director
Priority n/a
Total Project Cost: $83,600
2001 DEW EZE ATM72 Slope Mower
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $1,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 32,700 32,700 Total
Thursday, June 30, 2011
FIt
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0813
Project Name Brush Chipper
2012 thru 2016
Type Equipment Department Public Works: Parks/Forestry
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $25,700
3rush chipper used for Forestry and brush pick up operations of Public Works.
1993 Brush Bandit ChiDDer 250
Justification
Budget Impact/Other
Variance from 20 year plan - change to usable life to 20 years - move back from 2009 to 2013.
Estimate salvage/resale value on replaced item: $
Expenditures 2012 2013 2014 2015 2016 Total
Equipment 25,700 25,700
Tom 25,700 25,700
Funding Sources 2012 2013 2014 2015 2016 Total
Equipment Replacement Fund 25,700 25,700
Total
25,700
OSI
25,700
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0817
Project Name Grass Seed Applicator (Overseeder)
2012 thru 2016
Type Equipment Department Public Works: Parks/Forestry
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description Total Project Cost: $7,400
Attachment for overseeding existing turf areas.
Justification
Overseeder was not part of ERP - old overseeder was sold two years ago due to poor condition.
ariance from 20 year plan - New item.
stimate salvage/resale value on replace item: $-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
Thursday, June 30, 2011
FY
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0900
Project Name Refuse Truck (RAP -R) (2)
2012 thru 2016
Type Equipment Department Refuse
UsefulLife 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $1,462,600
Zefuse truck used by Refuse Utility Division of Public Works.
lCurent vehicle: 2005 Peterbilt Rapid Rail & 2011 Freightliner Rapid Rail
Justification
Residential waste pick up.
Budget Impact/Other
Variance from 20 year plan - increase cost to reflect actual
Estimate salvage/resale value on replaced item: $18,000
Prior Expenditures 2012 2013 2014
2015 2016
Total
Future
349,100 Vehicles
204,800
204,800
908,700
Total Total
Prior Funding Sources 2012 2013 2014
204,800
2015 2016
204,800
Total
Total
Future
349,100 RF - Refuse Fund
204,800
204,800
908,700
Total Total
204,800
204,800
Total
Thursday, June 30, 2011
0191
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -0901
Project Name Refuse Truck (Rear -L)
2012 thru 2016
Type Equipment Department Refuse
UsefulLife 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $238,200
Zefuse truck used by Refuse Utility Division of Public Works.
�urrent vehicle: 1996 Fre
Justification
Zesidential waste pick up.
Budget Impact/Other
FL70
(Variance from 20 year plan - none I
Estimate salvage/resale value on replaced item: $9,000
Expenditures 2012 2013 2014 2015 2016 Total Future
Vehicles 101,600 101,600 136,600
Tom 101,600 101,600 Total
Funding Sources 2012 2013 2014 2015 2016 Total Future
RF - Refuse Fund 101,600 101,600 136,600
Tom 101,600 101,600 Total
Thursday, June 30, 2011
M,I
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -1000
Project Name Ice Resurfacer
2012 thm 2016
Type Equipment Department Pavilion
Useful Life 12 years Contact Facilities Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $496,600
cc resurfacer used by the Pavilion for ice sheet maintenance.
2003 Olvmbia Ice Resurfacer
Justification
Replace existing propane fueled ice resurfacer with a electric driven ice resurfacer. Due to changes in the states statues
for indoor air quality for ice arenas replacement with a propane fueled model would warrant the purchase and
installation of state approved air quality monitoring equipment. Additional costs that would accompany the monitoring
equipment would be annual testing and recalibration fees. State statues also require annual licensing and lower emission
standards to be meet that if exceeded could possibly lead to possible facility closures and loss of revenue. With
consideration of the above factors the Pavilion would be exempt from the new statues if a electric ice resurfacer was
used in place of DroDane ice resurfacer.
Budget Impact/Other
Variance from 20 year plan - Value increased to reflect actual replacement cost.
Estimate salvage/resale value on replaced item: $20,000
Prior Expenditures
60,000 Equipment
Total
Prior Funding Sources
60,000 PA - Pavilion Fund
Total
2012 2013 2014 2015 2016 Total Future
180,000 180,000 256,600
Tom 180,000 180,000 Total
2012 2013 2014 2015 2016
180,000
Total 180,000
0W
Total
Future
180,000
256,600
180,000
Total
Thursday, June 30, 2011
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -1001
Project Name Electric Ice Edger
2012 thru 2016
Type Equipment Department Pavilion
UsefulLife 10 years Contact Facilities Director
Category Equipment Priority n/a
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.
airance from 20 year plan - New item.
stimate 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
PA - Pavilion Fund 5,000 5,000 6,700
Tom 5,000 5,000 Total
Thursday, June 30, 2011
OR
EQUIPMENT IMPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -1101
Project Name Art Center Carpet Extractor
2012 thru 2016
Type Equipment Department Arts Center
UsefulLife 10 years Contact Arts Center Director
Category Equipment Priority n/a
Future
Description 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.
Includins4 carpet wand and long hose for ease of use, as well as low moisture capabilities.
Justification
Che current equipment is over 12 years old and very corroded from the dirt, water and cleaning chemicals. With regular
ouch up cleaning and removal of stains in the Arts Center carpet with this extractor, the need to pay contractual
,leavers to deep clean the carpet is reduced to once or twice annually.
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
Tom 3,900 3,900 Total
Thursday, June 30, 2011
01 FA
EQUIPMENT IlVIPROVEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -1102
Project Name Art Center Kitchen Catering Equipment
2012 thri, 2016
Type Equipment Department Arts Center
Useful Life 12 rears Contact its Center Director
Category Equipment Prioiitp n
Future
Description I Total Project Cost: $12,100
7nder counter freezer and refrigerator in catering kitchen.
Justification
Chese units are used for storing food for HCA events and for rental clients.
Variance from 20 year plan - Ne -,v item. Current pricing $2049 refrigerator, $2207 freezer plus delivery.
Estimate salvage/resale value on replaced item: $-0-
Expenditures 2012
2013 201.4
2015 2016 Total
Future
Equipment
5,000
5,000
7,100
Total
5,000
5,000
Total
Funding Sources 2012 2013 201.1 2015 2016 Total Future
AC - Arts Center Fund 5,000 5,000 7,100
Tom 5,000 5,000 Total
TIvirsdav, bine 30, 2011
ON]
EQUIPMENT IMPROVEMENT FLAN
City of Hopkins, MN
'rojeet # 01 -ERP -1103
'rojeet Name Art Center Video Camera Updates
2012 thru 2016
Type Equipment Department Arts Center
Useful Life 5 years Contact Arts Center Director
Category Equipment Priority n/a
Future
Description 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
[here was an item taken from a display case in 2011 and existing cameras did not provide clear angle and view of the
,ulprit. Also, addition of a camera in the back hallway may reduce tendency of youth to hang out in that area and
;ngage in inappropriate behavior.
Variance from 20 year plan - New item.
Estimate salvage/resale value on replaced item: $-0-
Expenditures 2012 2013 2014 2015 2016 Total Future
Equipment 3,200 3,200 13,000
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
Tom 3,200 3,200 Total
Thursday, June 30, 2011
OR,
TWENTY-YEAR
REPLACEMENT SCHEDULE
118181
(§
&
-
;9
..........
k
X22
/p
� \\\\\\\\\\
\
\\
\\
&
G
\
m3Et)
)
///{/))//)}\�
\\\\\\\}}}\)j/))\
/P4
c7, \�
4:
G
(§
3
to ,-.
m r
O
Vl In
m r O
l v l
m r
to
r
m
vl to
r
W
� �
O
O
O
b
O
W
M
O
b
N
O
r
M
O
O
N
O
�
O
14:
W
O
r
O
M
O
b
vl
� r
r
r �
r ti
W
to r ti
N�
r r r
m �
r b
W
l�
W
Vi
A
O
O
A
r
r
W
W
�
A
b
M
a
� �
m
oy 00�0�0 O
W
z �
o_ w
F o a
ow
F
�F" zp�5�za
aw
cw7
a�
yy
w w
WW �
zz�FF''w3�o5
w7w7x�¢3�a�a
z�F�
w7x�
zF
w7zz
�,FY �wwwwmnc7�`�
�ducgwwoaoa �wa�
z
w z
� w
WxW xF cazzza a
qqq �FFFaz �
F w
zzz �Fy�3�wo5 �
LO
0
EQUIPMENT AND BUILDING
INVENTORY
1118Iy
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2011
UNIT 4
YEAR
MAKE
MODEL
CURRENT
REPLACEMENT
COST
FIRE DEPARTMENT
2008
FORD
CROWN VICTORIA
100
2006
DODGE
DURANGO
$28,300
101
2003
CHEV
IMPALA
24,900
102.
1989
FORD L9000
TELE -SQUIRT
240,000
103.
2006
PETERBILT
PUMPER
403,300
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
`11YA
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2011
CURRENT
REPLACEMENT
UNIT 4 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
1989
IN GERS O L/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
`ter.]
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2011
UNIT 4
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.
I: ".I
411
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
RANGER 4X4
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
f[oi']
$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
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2011
UNIT 4
YEAR
MAKE
MODEL
CURRENT
REPLACEMENT
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
`sM
Location/Descrmtion
City Hall
1010 1st Street S.
Police Station
1010 1st Street S.
Fire Station
101 17th Avenue S.
Hopkins Activity Center
33 14th Avenue S.
Ice Arena/Pavilion
11000 Excelsior Boulevard
Arts Center
1111 Mainstreet
PW Admin/Garage
11100 Excelsior Boulevard
Moline Reservoir/Well 41
10421 Excelsor Boulevard
Blake Tower Reservoir
151 Tyler Avenue S.
Filtration Plant
1401 Elmo Park Service Road
Well 44 Workshop/Storage
1401 Elmo Park Service Road
Well #5
1205 Highway?
Well #6
801 Highway 7
Lift Station 42 - Drillane
619 Drillane Road
Lift Station 43 - Lindee's
901 Cambridge Street N.E.
CITY OF HOPKINS
BUILDING INVENTORY
June 2011
ISE
Replacement Cost
$3,400,900
3,835,100
4,214,000
1,825,000
5,011,000
6,865,000
7,171,000
2,295,000
1,386,700
3,372,000
649,400
227,800
303,800
65,000
130,000
Location/Describtion Replacement Cost
Lift Station 44 - LTL Meadowbrook
$95,000
244 Meadowbrook Road
Lift Station 45 - Big Meadowbrook
151,000
6601 Excelsior Blvd.
Lift Station 46 - Ronnie's
95,000
8546 Excelsior Avenue E.
Lift Station 47 - Valley
300,000
801 6th Avenue S.
Band Shell - Downtown Park
36,000
16 9th Avenue S.
Concession Stand - Maetzold Field
149,000
1215 1st 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/Bathhouse
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
IMM
Location/Description Replacement Cost
Depot Coffee House $469,000
9451 Excelsior Boulevard
Overpass Skate Park 7,500
100 Washington Avenue
Dow Towers (76 Units) HRA
22 5th Avenue S.
"K3