CR 10-059 - 2011-2015 Equipment Replacement PlanJuly 6, 2010
0
Proposed Action
Council Report 2010-059
City of Hopkin
2011-2015 EQUIPMENT REPLACEMENT PLAN
Staff recommends adoption of the following motion: Move to adopt the 2011-2015 Equipment Re lacement
Plan.
Overview
The equipment replacement plan is a detailed summary of the next five years of a twenty-year replacement
schedule, for equipment of the City of Hopkins. General and Special Revenue fund equipment items are
placed in the Equipment Replacement Fund budget which derives its revenues from service charges to the
General and Special Revenue funds, equipment sales and interest earnings. The Enterprise fund equipment
in the plan is placed in the individual enterprise fund budgets, in the year in which the equipment is to be
purchased.
Approval of the 2011-2015 allows staff to incorporate the 2011 ERP items into the 2011 budgets and begin
•preparation for their purchase. Items that fall under the Minnesota Statutes Uniform Bidding/Contracting
Laws will require further approval by the council before their purchase.
Staff is recommending adoption of the plan.
Primary Issues to Consider
• Should the annual service charges to the general and special revenue funds be adjusted?
• What changes have occurred in the equipment replacement plan since last year?
Supporting Information
• Power point presentation
• 2011-2015 Equipment Replacement Plan
Christine M. Harkess, CPA, CGFM
Finance Director
Financial Impact: $ as provided in plan Budgeted: YIN X N Source: Various
. Related Documents (CIP, ERP, etc.): ERP Notes:
U
•
0
City of Hopkins
2011-2015
r�
k
" ERP Future
Hues in the Equipment Replacement fund are
ed from charges to city departments that use the
iment.
flow projections are updated annually to ensure
uate funds for scheduled replacements.
• Funding challenges are foreseen in the future
V , City Nall Equipment
•The large city hall copy machine is scheduled
for"re placement at a cost of $13,000
Engineering printer/scanner is leased on a 5-
yearlease
Document management scanner to be replaced
at a cost of $6, Soo
ERP Background
• The'city has established an equipment
replacement plan that is reviewed and adjusted
on an annual basis.
For 2011 the city is planning on replacing or
upgrading seven vehicles and four pieces of
equipment.
• Following are some highlights of the plan.
MW
a City Hall Equipment
u.
•Annually the city replaces a portion of its obsolete '
corrputerswith newer technology.
• ,$30,000 per year is allocated to replace old
computers and s16,5oo per year is allocated for
network upgrades.
i p'!
4 i F � {
j
yy h �
�• t f
City of qfopkins
• l oto first street South • Hopkins, W 55343-7573 • Phone: 952-935-8474 • Fax• 952-935-1834
Ino- Web address. www.hopkinsmn.com
DATE: July 2010
TO: Honorable Mayor and Members of the City Council
FROM: Rick Getschow, City Manager
SUBJECT: 2011-2015 EQUIPMENT REPLACEMENT PLAN
With this letter, I respectfully submit the 2011-2015 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,
Connie Kurtz, Police Administrative Services Director, Dale Specken, Fire Chief, Jim
Genellie, Assistant City Manager, Christine Harkess, Finance Director and Deb
Dahlheimer, Sr. Finance Clerk for their hard work and dedication.
Partnering with the Community to Enhance the Qaafity of Life
0 Inspire # Educate + Involve + Communicate •
9 EQUIPMENT REPLACEMENT PLAN 2011-2015
TABLE OF CONTENTS
CITY MANAGER'S MESSAGE
TABLE OF CONTENTS
Page
INTRODUCTION
Background and Summary of Changes from 2010 Plan
1
FIVE YEAR SUMMARIES
Equipment Replacement Fund Cash Flow
4
Projects by Year
5
Department Summary
8
Projects by Department
9
Funding Source Summary
12
Projects by Funding Source
13
Projects & Funding Source by Department
16
•
EQUIPMENT REQUESTS
Individual Equipment Request Details
21
TWENTY YEAR REPLACEMENT SCHEDULE
Twenty Year Schedule by Department
82
EQUIPMENT AND BUILDING INVENTORY
Vehicle/Equipment Inventory
87
Building Inventory
91
0
• EQUIPMENT REPLACEMENT PLAN 2011 - 2015
BACKGROUND AND SUMMARY OF CHANGES FROM 2010 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
$816,100.
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 intragoverninental 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. Intragovernmental charges are at 58% of what they were in 2002 and at the
• current rate structure will not return to that level until 2021. Unfortunately our equipment needs
are not changing. The plan as presented proposes a 3% increase in charges for 2011, a 4%
increase for 2012, a 5% increase in 2013 and a 6% increase in 2014 and 2015.
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.
Future increases each year are needed to fund the equipment replacement plan without issuing
debt.
The Equipment Replacement Plan's basic premise is scheduled replacement of present
equipment. A new item must, in the year proposed, be presented in the annual operating budget
with a stipulation that replacement will be necessary in the future. Flexibility of the Equipment
Replacement Plan is established through annual review and revision, if necessary.
Summary of Changes from 2010 Plan
Highlights of changes from last year's equipment replacement plan for the years 2011-2015:
Activity Center: There were no changes to Activity Center items in this CIP.
• Arts Center: Due to limited availability of the carpet extractor located in another
city building the Arts Center added a carpet extractor for their building
at a cost of $3,000 to be purchased in 2012. Due to high usage of this
•
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 as its condition warranted extension of its life.
The 3/4 ton pickup originally scheduled for replacement in 2011 was
moved back to 2012 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.
A tractor (item 10 -ERP -806) originally scheduled for replacement in
2012 was eliminated and replaced with a toolcat that was purchased in
2010. The second tractor due for replacement in 2014 was moved
back to 2016.
Streets/Traffic
The tandem dump truck (item 01 -ERP -306) originally scheduled for
• replacement in 2013 was moved ahead to 2011 due to the current
condition of the truck. The truck will be refurbished at a cost of
$22,000 and its life extended to 2018. The second tandem dump truck
scheduled for 2015 was moved ahead to 2013 due to the conditions of
that truck.
Skid Steer Loader originally scheduled for purchase in 2010 was
moved back to 2011 as staff felt we could get another year of use from
this piece of equipment.
Sweeper due for replacement in 2013 at a cost of $164,500 was
reduced by $8,100 to $156,400 to more accurately reflect the cost of
replacement.
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.
is
Five Year Summaries
•
Memo Only
Long Tenn Receivable
2007 Hockey Booster Loan repayment
Cash Balance + LT Receivable
•
0
95,609 75,609 55,609 35,609 15,609 -
18,783 15,640 12,497 9,354 6,211 3,068
1,126,779 1,248,046 1,154,439 1,170,936 503,752
EQUIPMENT REPLACEMENT FUND (602)
06/28/2010
Rate Change
0%
0%
2%
3%
4%
5%
6%
6%
ACTUAL
ACTUAL
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
2008
2009
2010
2011
2012
2013
2014
2015
Working Capital Begin Year
1,371,188
1,033,705
1,161,011
1,087,404
1,123,901
476,717
151,896
83,082
Revenues from charges
287,127
287,463
293,212
302,009
314,089
329,793
349,581
370,556
Transfer In - Pavilion - Capital Lease
20,000
20,000
20,000
20,000
20,000
15,609
TransferIn- Pavilion - Hockey Loan
3,217
3,143
3,143
3,143
3,143
3,143
3,142
Federal & State Grants
12,154
52,545
Fire Truck Lease
425,000
Interest earnings
37,377
18,519
52,760
49,447
51,090
21,966
7,349
4,253
Otherrevenues (saleofassets)
16,150
10,258
25,000
25,000
25,000
25,000
30,000
30,000
Total Revenues
801,025
391,928
394,115
399,599
413,322
395,512
390,072
404,809
Expenditures (excludes Depr.)
25,604
25,248
26,005
26,786
27,589
28,417
29,269
30,147
expenditures include copier & eng scanner leases
Fire Truck Financing Pymnts (2009-2018)
3,889
53,907
54,217
54,217
54,217
54,217
54,217
54,217
CapitalOutlay- Equipment
1,109,014
185,467
387,500
282,100
978,700
637,700
375,400
412,200
1,138,507
264,622
467,722
363,102
1,060,506
720,333
458,886
496,564
Working Capital Ending Balance
1,033,705
1,161,011
1,087,404
1,123,901
476,717
151,896
83,082
(8,673)
Cash balance
1,031,170
1,171,437
1,098,830
1,135,317
488,143
163,321
94,508
1,753
Memo Only
Long Tenn Receivable
2007 Hockey Booster Loan repayment
Cash Balance + LT Receivable
•
0
95,609 75,609 55,609 35,609 15,609 -
18,783 15,640 12,497 9,354 6,211 3,068
1,126,779 1,248,046 1,154,439 1,170,936 503,752
Project Name Department Project # Priority Project Cost
• 2013
Activity Center Copy Machine
Activity Center
01 -ERP -0030
n/a
15,000
Network Server
City Hall Administration
07 -ERP -0003
n/a
8,000
Computers
City Hall Administration
01 -ERP -0006
nla
30,000
City Hall Small Copy Machine
Community Services
07 -ERP -0002
nla
20,000
Engineering Printer/Scanner
Community Services
01 -ERP -0007
n/a
10,000
Document Management Scanner (3)
Community Services
01 -ERP -0008
n/a
6,500
Aerial Truck
Fire
01 -ERP -0106
nla
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
Network Server (3)
Police
01 -ERP -0211
nla
8,500
Tactical Ballistic Vests
Police
01 -ERP -0214
nla
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
Riding Mowers (3)
Public Works: Parks/Forestry
01 -ERP -0808
n/a
22,800
Brush Chipper
Public Works: Parks/Forestry
01 -ERP -0813
nla
25,700
4X4 3/4 Ton Truck with Plow
Public Works: Streets/Traffic
01 -ERP -0301
n/a
30,400
Tandem Dump Trucks (2)
Public Works: Streets/Traffic
01 -ERP -0306
n/a
142,400
Sweeper
Public Works: Streets/Traffic
01 -ERP -0317
nla
156,400
Backhoe Loader
Water
01 -ERP -0502
n/a
134,800
Total for 2013
836,717
2014
Network Server
City Hall Administration
07 -ERP -0003
n/a
8,000
Computers
City Hall Administration
01 -ERP -0006
n/a
30,000
• Engineering Printer/Scanner
Community Services
01 -ERP -0007
n/a
10,000
Document Management Scanner (3)
Community Services
01 -ERP -0008
nla
6,500
Aerial Truck
Fire
01 -ERP -0706
n/a
54,217
Automated External Defibrillator (2)
Fire
01 -ERP -0720
n/a
7,200
Copier
HRA
01 -ERP -0401
n/a
13,000
Ice Resurfacer
Pavilion
07 -ERP -1000
n/a
180,000
Electric Ice Edger
Pavilion
07 -ERP -1001
nla
5,000
Marked Patrol Vehicles (6)
Police
01 -ERP -0200
nla
73,400
Utility 44 (unit 212)
Police
01 -ERP -0203
nla
47,700
Police Administrative Vehicles (2)
Police
01 -ERP -0204
n/a
30,500
Logging Recorder
Police
01 -ERP -0270
n/a
36,900
Network Server (3)
Police
01 -ERP -0217
n/a
8,500
Digital Squad Car Cameras
Police
01 -ERP -0213
n/a
42,600
Radios - Portable and Mobile Devices
Police
01 -ERP -0215
n/a
15,000
Riding Mowers (3)
Public Works: Parks/Forestry
01 -ERP -0808
n/a
20,300
Asphalt Paver
Public Works: Streets/Traffic
01 -ERP -0314
n/a
48,800
Refuse Truck (Rear -L)
Refuse
01 -ERP -0901
n/a
101,600
44 3/4 Ton Truck
Sewer
07 -ERP -0550
n/a
35,700
Total for 2014
774,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
Engineering Printer/Scanner
Community Services
01 -ERP -0007
n/a
12,000
Document Management Scanner (3)
Community Services
01 -ERP -0008
nla
6,500
. Duty Chief Vehicle (1) Asst Chiefs Vehicles (2)
Fire
01 -ERP -0103
nla
37,000
Aerial Truck
Fire
01 -ERP -0106
n/a
54,217
Wednesday, June 30, 2010
6
City of Hopkins, MN
. EQUIPMENT REPLACEMENT PLAN
2011 thru 2015
DEPARTMENT SUMMARY
Department
2011
2012
2013
2014
2015
Total
Activity Center
15,000
15,000
Arts Center
12,100
3,300
15,400
City Hall Administration
38,000
38,000
38,000
38,000
127,600
279,600
Community Services
29,500
16,500
36,500
16,500
18,500
717,500
Fire
64,517
320,517
65,717
61,417
108,617
620,785
HRA
13,000
32,400
45,400
Pavilion
185,000
785,000
Police
156,300
184,200
147,500
254,600
190,300
932,900
Public Works: Engineering
21,500
21,500
Public Works: Parks/Forestry
156,100
48,500
20,300
224,900
Public Works: Streets/Traffic
58,000
327,600
329,200
48,800
47,000
810,600
Refuse
101,600
204,800
306,400
Sewer
35,700
35,700
Water
134,800
14,200
749,000
TOTAL 358,417 1,046,217 836,717 774,917 743,417 3,759,685
•
0
8 I14ednesday, June 30, 2010
Department Project# Priority 2011 2012 2013 2014 2015 Total
• HRA Total 13,000 32,400 45,400
Pavilion
Ice Resurfacer 01 -ERP -7000 n/a 180,000 180,000
Electric Ice Edger 01 -ERP -1001 n/a 5,000 5,000
Pavilion Total
Police
Marked Patrol Vehicles (6)
01 -ERP -0200
n/a
Sergeant's Vehicle
01 -ERP -0201
n/a
Utility 44 (unit 212)
01 -ERP -0203
n/a
Police Administrative Vehicles (2)
01 -ERP -0204
n/a
Police Services Liaison Vehicle
01 -ERP -0206
nla
Copy Machine .
01 -ERP -0209
nla
Logging Recorder
01 -ERP -0270
n/a
Network Server (3)
01 -ERP -0211
n/a
Mobile Data Computers
01 -ERP -0212
nla
Digital Squad Car Cameras
07 -ERP -0213
n/a
Tactical Ballistic Vests
01 -ERP -0214
n/a
Radios - Portable and Mobile Devices
01 -ERP -0215
n/a
Police Total
19,700
Public Works: Engineering
. Engineering Van
01 -ERP -0700
n/a
Public Works: Engineering Total
36,900
8,500
8,500
8,500
8,500
Public Works: Parks/Forestry
1/2 Ton Pickup Truck
01 -ERP -0800
n/a
44 3/4Ton Trucks (2)
01 -ERP -0801
n/a
3/4 Ton Utility Truck
01 -ERP -0802
n/a
Trucksters (3)
01 -ERP -0807
n/a
Riding Mowers (3)
01 -ERP -0808
n/a
Brush Chipper
01 -ERP -0813
n/a
Public Works: Parks/Forestry Total
15,000
15,000
15,000
15,000
Public Works: Streets/Traffic
44 3/4 Ton Pickup with Plow
01 -ERP -0300
n/a
4X4 3/4 Ton Truck with Plow
07 -ERP -0301
nla
1 Ton Dump Truck (2)
01 -ERP -0303
n/a
1 Ton Traffic Boom Truck
01 -ERP -0304
nla
Tandem Dump Trucks (2)
01 -ERP -0306
n/a
Front End Loaders (2)
01 -ERP -0308
n/a
Skid Loader (2)
01 -ERP -0309
n/a
Sweeper
01 -ERP -0371
n/a
Roller
01 -ERP -0312
n/a
Asphalt Paver
01 -ERP -0314
n/a
• Sign Machine (Traffic) 01 -ERP -0377 n/a
Public Works: Streets/Traffic Total
33,600
33,600
30,400
185,000
34,700
185,000
67,200
69,200
71,200
73,400
75,600
356,600
33,600
36,000
156,400
156,400
37,800
71,400
48,800
48,800
13,400
47,700
47,700
27,900
28,800
29,600
30,500
31,400
148,200
22,000
22,000
19,100
19,700
36,900
36,900
8,500
8,500
8,500
8,500
8,500
42,500
62,700
62,700
42,600
42,600
23,200
23,200
15,000
15,000
15,000
15,000
60,000
156,300
184,200
147,500
254,600
190,300
932,900
21,500
21,500
21,500
21,500
26,400
26,400
67,400
67,400
32,200
32,200
19,800
79,800
10,300
22,800
20,300
53,400
25,700
25,700
156,100
48,500
20,300
214,900
33,600
33,600
30,400
30,400
34,700
34,700
75,000
75,000
22,000 142,400
164,400
172,000
172,000
36,000
36,000
156,400
156,400
45,900
45,900
48,800
48,800
13,400
13,400
58,000 327,600 329,200 48,800 47,000 810,600
10 Ifednesday, June 30, 2010
•
•
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2011 ffim 2015
FUNDING SOURCE SUMMARY
Source
2011
2012
2013
2014
2015
Total
AC - Arts Center Fund
12,100
3,300
15,400
Bonds/Lease
54,217
54,217
54,217
54,217
54,217
271,085
Equipment Replacement Fund
292,100
988,700
647,700
385,400
424,200
2,738,100
HRA - Housing and Redevelopment Authority
13,000
32,400
45,400
PA- Pavilion Fund
185,000
185,000
RF - Refuse Fund
101,600
204,800
306,400
SF - Sanitary Sewer Fund
35,700
6,800
42,500
WF - Water Fund
134,800
21,000
155,800
GRAND TOTAL 358,417 1,046,217 836,717 774,917 743,417 3,759,685
12
I,Yednesday, June 30, 2010
Source Project# Priority
2011
2012
2013
2014
2015
Total
4X4 314 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
75,000
75,000
Tandem Dump Trucks (2)
01 -ERP -0306
n/a
22,000
142,400
764,400
Front End Loaders (2)
07 -ERP -0308
nla
172,000
772,000
Skid Loader (2)
01 -ERP -0309
n/a
36,000
36,000
Sweeper
01 -ERP -0311
n/a
156,400
156,400
Roller
01 -ERP -0372
nla
45,900
45,900
Asphalt Paver
07 -ERP -0314
n/a
48,800
48,800
Sign Machine (Traffic)
01 -ERP -0317
n/a
13,400
13,400
Engineering Van
D7 -ERP -0700
n/a
21,500
21,500
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
Trucksters (3)
01 -ERP -0807
n/a
19,800
19,800
Riding Mowers (3)
07 -ERP -0808
n/a
10,300
22,800
20,300
53,400
Brush Chipper
01 -ERP -0813
n/a
25,700
25,700
Equipment Replacement Fund Total
292,100
988,700
647,700
385,400
424,200
2,738,100
HRA - Housing and Redevelopment A
44 3/4 Ton Truck
01 -ERP -0400
n/a
32,400
32,400
Copier
01 -ERP -0401
n/a
13,000
13,000
HRA - Housing and Redevelopment
13,000
32,400
45,400
Authority Total
•
PA Fund
-Pavilion
Ice Resurfacer
01 -ERP -1000
nla
180,000
180,000
Electric Ice Edger
01 -ERP -1001
n/a
5,000
5,000
PA - Pavilion Fund Total
185,000
185,000
RF - Refuse Fund
Refuse Truck (RAP -R) (2)
01 -ERP -0900
n/a
204,800
204,800
Refuse Truck (Rear -L)
01 -ERP -0901
nla
101,600
101,600
RF - Refuse Fund Total
101,600
204,800
306,400
SF - Sanitary Sewer Fund
Telephone System
07 -ERP -0004
n/a
6,800
6,800
4x4 3/4 Ton Truck
01 -ERP -0550
n/a
35,700
35,700
SF - Sanitary Sewer Fund Total
35,700
6,800
42,500
WF - Water Fund
Telephone System
01 -ERP -0004
n/a
6,800
6,800
Backhoe Loader
01 -ERP -0502
n/a
134,800
734,800
Public Works Copy Machine
07 -ERP -0506
n/a
14,200
14,209
WF - Water Fund Total
134,800
21,000
155,800
•
Wednesday, June 30, 2010
14
City of Hopkins, MN
City Hall Administration
Network Server . 01 -ERP -0003 n/a
EQ UIPMENT REPLACEMENT PLAN
2011 thru 2015
PROJECTS & FUNDING SOURCES BY DEPARTMENT
Department Project# Priority 2011 2012 2013 2014 2015
Total
8,000
Activity Center
8,000
40,000
Telephone System 01 -ERP -0004 n/a
Activity Center Copy Machine
01 -ERP -0030 n/a 15,000
15,000
20,000
89,600
Activity Center Total 15,000
15,000
30,000
Equipment Replacement Fund
15,000
15,000
30,000
150,000
Activity Center Total 15,000
15,000
38,000
Arts Center
38,000
127,600
279,600
Art Center Copy Machine
01 -ERP -1100 n/a 12,100
12,100
Art Center Carpet Extractor
01 -ERP -1101 n/a 3,300
3,300
38,000
38,000
Arts Center Total 12,100 3,300
15,400
•
AC - Arts Center Fund
12,100 3,300
15,400
Arts Center Total 12,100 3,300
15,400
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
n/a
20,000
20,000
89,600
89,600
Computers 01 -ERP -0006 n/a
30,000
30,000
30,000
4000
30,000
150,000
City Hall Administration Total
38,000
38,000
38,000
38,000
127,600
279,600
Equipment Replacement Fund
38,000
38,000
38,000
38,000
114,000
266,000
SF - Sanitary Sewer Fund
6,800
6,800
WF- Water Fund
6,800
6,800
City Hall Administration Total
Community Services
City Hall Main Copy Machine - Oce' Copier 01 -ERP -0001
City Hall Small Copy Machine 01 -ERP -0002
Engineering Printer/Scanner 01 -ERP -0007
0 Document Management Scanner (3) 01 -ERP -0008
16
Wednesday, June 30, 2010
38,000
38,000 38,000 38,000 127,600
279,600
n/a
13,000
13,000
n/a
20,000
20,000
n/a
10,000
10,000 10,000 10,000 12,000
52,000
n/a
6,500
6,500 6,500 6,500 6,500
32,500
16
Wednesday, June 30, 2010
Department
Project# Priority
2011
2012
2013
2014
2015
Total
•
Pavilion Total
185,000
185,000
Police
Marked Patrol Vehicles (6)
01-ERP-0200
n/a
67,200
69,200
71,200
73,400
75,600
356,600
Sergeant's Vehicle
01-ERP-0201
n/a
33,600
37,800
71,400
Utility 44 (unit 212)
01-ERP-0203
n/a
47,700
47,700
Police Administrative Vehicles (2)
01-ERP-0204
n/a
27,900
28,800
29,600
30,500
31,400
148,200
Police Services Liaison Vehicle
01-ERP-0206
n/a
22,000
22,000
Copy Machine
01-ERP-0209
n/a
19,100
19,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
42,600
42,600
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
60,000
Police Total
156,300
184,200
147,500
254,600
190,300
932,900
Equipment Replacement Fund
156,300
184,200
147,500
254,600
190,300
932,900
Police Total
156,300
184,200
147,500
254,600
190,300
932,900
•
Public Works: Engineering
Engineering Van
01-ERP-0700
n/a
21,500
21,500
Public Works: Engineering Total
21,500
21,500
Equipment Replacement Fund
21,500
21,500
Public Works: Engineering Total
21,500
21,500
Public Works: Parks/Forestry
1/2 Ton Pickup Truck
01-ERP-0800
n/a
26,400
26,400
4x4 314Ton 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
Trucksters (3)
01-ERP-0807
n/a
19,800
19,800
Riding Mowers (3)
01-ERP-0808
n/a
10,300
22,800
20,300
53,400
Brush Chipper
01-ERP-0813
n/a
25,700
25,700
Public Works:
Parks/Forestry Total
156,100
48,500
20,300
224,900
Equipment Replacement Fund
156,100
48,500
20,300
224,900
Public Works: Parks/Forestry Total
156,100
48,500
20,300
224,900
Wednesday, Jwze 30, 2010
18
•
•
•
1. Department Project# Priority 2011 2012 2013 2014 2015 Total
Water Total 134,800 14,200 149,000
Grand Total 358,417 1,046,217 836,717 774,917 743,417 3,759,665
20
Wednesday, June 30, 2010
•
Equipment Requests
0
EQUIPMENT REPLACEMENT PLAN 2011 rhru 2015
• City of Hopkins, MN
•
Project# 01 -ERP -0001
Project Name City Hall Main Copy Machine - Oce' Copier
Type Equipment Department Community Services
Useful Life 5 years Contact City Clerk
Category Equipment Priority n/a
Future
Description I Total Project Cost: $160,000
Copy machine to service needs of all departments located at City Hall.
1. Variety of copying tasks.
2. High volume product copier.
is leased. This copier may not make it to 2011.
Justification
Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and
updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies.
Budget Impact/Other
Variance from 20 year plan - lease renewed for 36 months. Plan to purchase new copier in 2011. Cost reduced by $1,000 due to pricing
reductions.
Estimate salvage/resale value on replaced item: $-0-
Prior Expenditures 2011 2012 2013 2014 2015 Total Future
—94,2-00-1 Equipment 13,000 13,000 52,800
Total Total 13,000 13,000 Total
Prior
Funding Sources
2011 2012
2013 2014 2015 Total
Future
—94,-2-00-1
Equipment Replacement Fund
13,000
13,000
52,800
Total
Total
13,000
13,000
Total
N
Wednesday, Juice 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
• City of Hopkins, MN
Project# 01 -ERP -0003
Project Name Network Server
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: 5225,000
The network server is the hub of the network. New computers are faster and more reliable.
Justification
Nehvorking allows user to share information that is stored in a single location, the network server. This is more efficient because the information
does not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every
user is working with the same data.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
Prior Expenditures 2011 2012 2013 2014 2015 Total Future
65,000 1 Equipment 8,000 8,000 8,000 8,000 8,000 40,000 120,000
Total Total 8,000 8,000 8,000 8,000 8,000 40,000 Total
Prior
Funding Sources
2011
2012
2013
2014
2015
Total
Future
65,000
Equipment Replacement Fund
8,000
8,000
8,000
8,000
8,000
40,000120,000
Total
Total
8,000
8,000
8,000
8,000
8,000
40,000
Total
Wednesday, June 30, 2010
23
EQUIPMENT REPLACEMENT PLAN 2011 awu 2015
• City of Hopkins, MN
,7
•
Project# 01 -ERP -0006
Project Name Computers
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: 5900,000
Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one
Justification
Fools enabling staff to perform job responsibilities efficiently and effectively.
Impact/Other
from 20 year plan - none
salvage/resale value on replaced item: $-0-
Prior Expenditures
300,000 Equipment
Total
2011 2012 2013 2014 2015 Total Future
30,000 30,000 30,000 30,000 30,000 150,000 1 450,000
Total 30,000 30,000 30,000 30,000 30,000 150,000 Total
Prior
Funding Sources
2011
2012
2013
2014
2015
Total .
Future
300,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
25
Wednesday, June 30, 2010
•
0
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins, MN
Project# 01 -ERP -0008
ProjectName Document Management Scanner (3)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Description
Department Community Services
Contact City Clerk
Priority n/a
Total Project Cost: $149,500
document (11" x17'') scanner for document management and retention as well as general administrative use.
Three scanners each replaced every three years.
One replaced in 2009, 2012, 2015....... — note we did not replace one in 2009; unit was repaired to extend the life.
One replaced in 2010, 2013, 2016.........
One replaced in 2011, 2014, 2017 .............
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 year for replacement. If scanners are working properly their life will be extended.
Justification
We have been getting up to three Tree Trust volunteers to work on scanning and the small scanner only handles documents up to 8'/2" x 14". We
would like to replace this scanner with a large document scanner to fully utilize out volunteers.
Budget Impact/Other
Variance from 20 year plan - item scheduled for 2009 was not replaced. Unit was repaired to extend its life. One additional scanner was added to
the replacement shedule in 2010.
Estimate salvage/resale value on replaced item: $500-$1,000
Prior IExpenditures
2011
2011
2012
2013
2014
2015
Total
Future
19,500
Equipment
6,500
6,500
6,500
6,500
6,500
32,500
97,500
Total
6,500
Total 6,500
6,500
6,500
6,500
6,500
32,500
Total
Prior Funding Sources
2011
2012
2013
2014
2015
Total
Future
1 —9.50-01 Equipment Replacement Fund
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
Wednesday, Juice 30, 2010
27
•
•
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins, MN
Project# 01 -ERP -0103
Project Name Duty Chief Vehicle (1) Asst. Chiefs Vehicles (2)
Type Equipment
Useful Life 15 years
Category Vehicles
Future
Department Fire
Contact Fire Chief
Priority n/a
DescriptionI Total Project Cost: $254,200
k marked passenger vehicle for use by the Duty Chief and Assistant Chiefs in transporting required equipment, reference materials and personnel
.or emergency response, and routine Fire Department business.
Curent vehicles: 2010 Chevrolet Tahoe (Chief)
2006 Dodge Durango (Asst. Chief)
Chevrolet Impala (Asst. Chief) to be replaced with 2015 SUV
Justification
Used by the Fire Chief and Asst. Chiefs when responding to fires and other emergencies. Used for official business in and out of the city and for
fire fighter travel on official Fire Department business.
Eventually 3 SUV's - replaced every 5 years with 15 year life. New - chief, cycle down to Asst. Chief I and Asst. Chief 2.
from 20 year plan - Add 2 vehicles and change life to 15 years.
salvage/resale value on replaced item: $4,000
Prior Expenditures
64,500 1 Vehicles
Total
2011 2012 2013 2014 2015 Total Future
37,000 37,000 1 152,700
Total 37,000 37,000 Total
Prior Funding Sources 2011 2012
2013 2014 2015
Total
Future
64,500 . Equipment Replacement Fund
37,000
37,000
1 152,700
Total Total
37,000
37,000
Total
Wednesday, June 30, 2010
29
•
L�
EQUIPMENT REPLACEMENT PLAN 2011 a7ru 2015
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
Description I Total Project Cost: $2,559,597
One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on
2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23.
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
i 10 -year capital lease of $425,000. At the end of the lease term payments (P&I) will total $542,170. Total costs of aerial including cash
?ayments equals $987,597.
from 20 year plan - .Lease payments on financing added to the plan.
salvage/resale value on replaced item: $
Prior Expenditures
2011
2012
2013
2014
2015
Total
Future
553,861 Equipment
54,217
54,217
54,217
54,217
54,217
271,085
F 1,734,651
Total
Total 54,217
54,217
54,217
54,217
54,217
271,085
Total
Prior
553,861
Total
Funding Sources 2011 2012 2013 2014 2015 Total Future
Bonds/Lease 54,217 54,217 54,217 54,217 54,217 271,085 17734,651
Total 54,217 54,217 54,217 54,217 54,217 271,085 Total
31
Mednesday, JU77e 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
• City of Hopkins, MN
Project# . 01 -ERP -0110
Project Name Copy Machine
Type Equipment
Useful Life 8 years
Category Equipment
Future
Description
Fire Station copy machine.
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $47,400
Current equipment: 2003 Ricoh Aficio 1035P
Justification
Copying business papers, training records, etc.
•Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $500
Prior Expenditures 2011
7,400 Equipment 10,300
Total Total 10,300
Prior Funding Sources
7,4001 Equipment Replacer
Total
•
2012 2013 2014 2015 Total Future
10,300 1 29,700
10,300 Total
2011 2012 2013 2014 2015 Total Future
Fund 10,300 10,300 1 29,700
Total 10,300 10,300 Total
33
Wednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins, MN
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
Description I Total Project Cost: 520,300
Workout equipment used in Fire Department workout room. One eliptical machine replaced on a 6 year cycle, one every 3 years.
Justification
rbis equipment is available to all City employees for health and wellness.
Budget Impact/Other
Variance from 20 year plan - had two eliptical machines in the ERP. One was replaced along with the stairmaster with a summit trainer. The
remaining eliptical is scheduled for replacement in 2015.
Estimate salvage/resale value on replaced item: $
Expenditures 2011 2012 2013 2014 2015 Total Future
Equipment 5,800 5,800 F 14,500
Total 5,800 5,800 Total
Funding Sources 2011 2012 2013 2014 2015 Total Future
Equipment Replacement Fund 5,800 5,800 F 14,500
Total 5,800 5,800 Total
Wednesday, June 30, 2010
35
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
M City of Hopkins, MN
•
Project 01 -ERP -0118
Project Name workout Equipment- Treadmill
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Description I Total Project Cost: $25,300
Workout equipment used in the Fire Department workout room.
One treadmill replaced on a 5 year cycle.
Justification
This equipment is available to all City employees for health and wellness.
Budget Impact(Other
Variance from 20 year plan - move back one year from 2011.to 2012.
Estimate salvage/resale value on replaced item: $
Expenditures 2011 2012 2013 2014 2015 Total Future
Equipment 5,000 5,000 F 20,300
Total 5,000 5,000 Total
Funding Sources 2011 2012 2013 2014 2015 Total Future
Equipment Replacement Fund 5,000 5,000 20,300
Total 5,000 5,000 Total
37
Wednesday, Jm7e 30, 2010
L_J
•
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins, MN
Project 01 -ERP -0120
Project Name Automated External Defibrillator (2)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Description I Total Project Cost: $49,100
3efibrillator is used to help get someones heart restarted during a cardiac arrest.
awn 2 - both are replaced at one time due to changing technology.
Current equipment: 2010 - 4 AEDs I
2010 ERP had 2 AEDs schedule for replacement at $6,000. Four were purchased.
Justification
With changes in technology, the AED's should be replaced every four years.
Cost - $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
2011 2012 , 2013 2014 2015 Total Future
7,200 7,200 1 35,900
Total 7,200 7,200 Total
Prior
Funding Sources 2011
2012 2013 2014 2015
Total
Future
6,000
Equipment Replacement Fund
7,200
7,200
35,900
Total
Total
7,200
7,200
Total
39
Mednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
• City of Hopkins, MN
0
0
Project# 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
Description I Total Project Cost: $2,374,300
Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
Fleet consists of 6 patrol vehicles - 5 marked, 1 unmarked. .
Current vehicles: (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria, (2) 2008 Ford Crown Victorias, (1) 2007 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.
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 salvaee/resale value on replaced item: $4,000 each
Prior Expenditures
570,500 Vehicles
Total
2011 2012 2013 2014 2015 Total Future
67,200 69,200 71,200 73,400 75,600 356,600 1 1,447,200
Total 67;200 69,200 71,200 73,400 75,600 356,600 Total
Prior
Funding Sources
2011
2012
2013
2014
2015
Total
Future
570,500 1
Equipment Replacement Fund
67,200
69,200
71,200
73,400
75,600
356,600
F 1,447,200
Total
Total
67,200
69,200
71,200
73,400
75,600
356,600
Total
41
Wednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
• City of Hopkins, MN
Project# 01 -ERP -0203
Project Name Utility 4A (unit 212)
Type Equipment
Useful Life 6 years
Category Vehicles
Future
Description
t wheel drive uitlity vehicle.
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $247,600
Current vehicle: 2008 Chevrolet Tahoe
Justification
Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals 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 - can move replacement back one year to 2009 - new engine.
Estimate salvage/resale value on replaced item: $5,000
Prior Expenditures 2011 2012 2013 2014 2015 Total Future
67,400 Vehicles 47,700 47,700 132,500
Total Total 47,700 47,700 Total
•
Prior
Funding Sources 2011
2012 2013 2014 2015
Total
Future
—67,4-0-01
Equipment Replacement Fund
47,700
47,700
1 132,500
Total
Total
47,700
47,700
Total
43
Wednesday, Ane 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 rhru 2015
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
Description I Total Project Cost: $56,300
�urrent vehicle was leased to Police Department. Used by Police Services Liaison for transport to schools, neighborhood meetings, training and
mblic relations events.
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
Estimate salvage/resale value on replaced item: $1,000
Expenditures 2011 2012 2013 2014 2015 Total Future
Vehicles 22,000 22,000 34,300
Total 22,000 22,000 Total
Funding Sources 2011
2012 2013 2014 2015
Total
Future
Equipment Replacement Fund
22,000
22,000
F 34,300
Total
22,000
22,000
Total
Wednesday, June 30, 2010
M
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
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
2011 thru 2015
Description I Total Project Cost: $138,100
The police logging recorder is a device which records all telephone and radio transmissions produced/received by the Police Department.
2005 Mercom loRRina recorder
Justification
Records all incoming/outgoing phone calls from the dispatch center and all radio transmissions from police, fire and interop radio talkgroups.
Equipment is necessary in case questions arise as to how calls for service or events were handled or dispatched.
Budget Impact/Other
• Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $-0-
•
Expenditures 2011
2012 2013 2014 2015
Total
Future
Equipment
36,900
36,900
101,200
Total
36,900
36,900
Total
Funding Sources 2011
2012 2013 2014 2015
Total
Future
Equipment Replacement Fund
36,900
36,900101,200
Total
36,900
36,900
Total
47
Wednesday, June 30, 2010
• Prior Expenditures
4-7,0001 Equipment
Total
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
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
Description
Total Project Cost: 5297,800
Mobile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various databases, communicate car
to car.
Justification
Limited life of 5 years - replacement necessary.
Budget Impact/Other
Variance from 20 year plan - Increase cost from $54,500 to $62,700 ($5,700 x 11) to better reflect actual cost of MDC/docking station.
Estimate salvage/resale value on replaced item: $-0-
•
2011 2012 2013 2014 2015 Total Future
62,700 62,700 188,100
Total 62,700 62,700 Total
Prior Funding Sources
47,000 Equipment Replacement Fund
Total Total
2011 2012 2013 2014 2015 Total Future
62,700 62,700 188,100
62,700 62,700 Total
Wednesday, June 30,2070
EQUIPMENT REPLACEMENT PLAN 2011 rhru 2015
• 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
Description I Total Project Cost: $137,500
tactical ballistic vests worn by members of the Hopkins Police Department High-risk Entry and Assault Team (HEAT). These vests offer a higher
level of protection against weapon assault than the regular duty ballistic vest..
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 2007.
Cost: 9 vests x $2,133 = $19,197 (today's cost). Does not include any applicable taxes.
Budget Impact(Other
Variance from 20 year plan - new item. Note: regular bullet proof vests funded by federal/state grants
Estimate salvage/resale value on replaced item:. $
• Prior Expenditures 2011 2012 2013 2014 2015 Total Future
—20—,00-01 Equipment 23,200 23,20094,300
Total Total 23,200 23,200 Total
Prior Funding Sources
20,000 Equipment Replacement Fund
Total Total
0
2011 2012 2013 2014 2015
51
23,200
23,200
Total Future
23,200 94,300
23,200 Total
Wednesday, Juice 30, 2010
•
EQUIPMENT REPLACEMENT PLAN 2011 thm 2015
City of Hopkins, MN
Project# 01 -ERP -0300
Project Name 4x4 3/4 Ton Pickup with Plow
Type Equipment Department Public Works: Streets/Traffic
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $103,800
Pickup used by various divisions of Public Works.
Current vehicle: 1997 Chevrolet 3/4 Ton 4X4
Justification
ILight 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 salvage/resale value on replaced item: $1,500
Prior Expenditures 2011 2012 2013 2014 2015 Total Future
25,000 Vehicles 33,600 33,600 1 45,200
Total Total 33,600 33,600 Total
Prior Funding Sources 2011
2012 2013 2014 2015
Total
Future
25,000 Equipment Replacement Fund
33,600
33,6001
45,200
Total Total
33,600
33,600
Total
Wednesday, June 30, 2010
53
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
• City of Hopkins, MN
•
Project# 01 -ERP -0303
ProjectName 1 Ton Dump Truck (2)
Type Equipment Department Public Works: Streets/Traffic
Useful Life 12 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $205,500
Truck is used in the Street Division of Public Works.
Current vehicles: 1997 Ford F350 & 2000 Ford F450 I
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.
Estimate salvage/resale value on replaced item: $3;500
Prior Expenditures
75900 Vehicles
Total
2011 2012 2013 2014 2015 Total Future
34,700 34,700 102,900
Total 34,700 34,700 Total
Prior
Funding Sources 2011
2012 2013
2014 2015 Total
Future
67,900
Equipment Replacement Fund
34,700
34,700
1 102,900
Total
Total
34,700
34,700
Total
55
Wednesday, Juice 30, 2010
EQUIPMENT REPLACEMENT PLAN
10 City of Hopkins, MN
•
Project# 01 -ERP -0306
Project Name Tandem Dump Trucks (2)
2011 thru 2015
Type Equipment Department Public Works: Streets/Traffic
Useful Life l7 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $576,100
Sump trucks used in Streets Division of Public Works.
Current vehicles: 1996 Ford L-8000 & 1998 Ford LT8500 I
Justification
(Trucks used for heavy hauling, snow plowing and sanding.
Budget Impact/Other
Variance from 20 year plan - Move 2013 to2011 - budget $22,000 to refurb 98 Ford Tandem with new style box and drop sander and pre -wetting
salt option - extend life to 2018. Move 2015 purchase to 2013 due to conditions of truck.
Estimate salvage/resale value on replaced item: $-0-
Expenditures 2011 2012 2013 2014 2015 Total Future
Vehicles 22,000 142,400 164,400 1 411,700
Total 22,000 142,400 164,400 Total
Funding Sources 2011 2012 2013 2014 2015 Total Future
Replacement Fund 22,000 142,400 164,400 1 411,700
Total 22,000 142,400 164,400 Total
Wednesday, June 30, 2010
57
•
•
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins, MN
Ei
ect#01-ER -0309
ect Name Skid Loader (2)
Type Equipment Department Public Works: Streets/Traffic
Useful Life 12 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description
Total Project Cost: $187,600
Loading trucks, landscape work, snow removal, material handling.
Current equipment: 1998 John Deere 8875 Skid Loader & 2004 Bobcat S -1851R Skid Loader
Justification
Equipment Replacement Fund
Budget Impact(Other
Variance from 20 year plan - move back from 2010 to 2011.
Estimate salvage/resale value on replaced item: $
Expenditures 2011 2012 2013 2014 2015 Total Future
Equipment 36,000 36,000 151,600
Total 36,000 36,000 Total
Funding Sources
2011 2012 2013
2014 2015 Total
Future
Equipment Replacement Fund
36,000
36,000
151,600
Total
36,000
36.000
Total
Wednesday, June 30, 2010
59
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins, MN
Project# 01—ERP-0312
Project Name Roller
Type Equipment Department Public Works: Streets/Traffic
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $45,900
Used by Street Department for asphalt repair and resurfacing.
1989 Ingersoll Rand Roller
Justification
Budget Impact(Other
Variance from 20 year plan - None
Estimate salvage/resale value on replaced item: $
Expenditures 2011 2012 2013 2014 2015 Total
Equipment 45,900 45,900
Toff 45,900 45,900
Funding Sources 2011 2012 2013 2014 2015 Total
Equipment Replacement Fund 45,900 45,900
TOW 45,900 45,900
1T'ednesday, June 30, 2010
61
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins, MN
Project# 01 -ERP -0317
Project Name Sign Machine (Traffic)
Type Equipment Department Public Works: Streets/Traffic
Useful Life 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 use.
Current 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: 5 -0 -
'Expenditures 2011 2012 2013 2014 2015 Total Future
Equipment 13,400 13,400 18,100
Total 13,400 13,400 Total
Funding Sources 2011 2012 2013 2014 2015 Total Future
Equipment Replacement Fund
Total
•
63
13,400 13,400 L 18,100
13,400 13,400 Total
Mednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Houkins, MN
Project# 01 -ERR -0401
Project Name Copier
Type Equipment
Useful Life 8 years
Category Equipment
Future
Department HRA
Contact Finance Director
Priority n/a
Description I Total Project Cost: 550,400
�oior 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
is Variance from 20 year plan - New item.
Estimate salvage/resale value on replace item: $ - 0 -
Expenditures 2011 2012 2013 2014 2015 Total Future
Equipment 13,000 13,000 37,400
Total 13,000 13,000 Total
Funding Sources 2011
2012 2013 2014 2015
Total
Future
HRA - Housing and Redevelop
13,000
13,000
37,400
Total
13,000
13,000
Total
Wednesday, June 30, 20/0
65
0
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins, MN
Project# 01 -ERP -0506
Project Name Public Works Copy Machine
Type Equipment Department Water
Useful Life 5 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: 594,700
Copy machine to service needs of all division of Public Works.
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 2011
2012 2013 2014 2015
Total
Future
22,800 Equipment
14,200
14,200
1 57,700
Total Total
14,200
14,200
Total
Prior Funding Sources 2011
2012 2013 2014 2015
Total
Future
22,800 WF - Water Fund
14,200
14,200
57,700
Total Total
14,200
14,200
Total
67
Wednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 rhru 2015
City of Houkins, MN
'roject# 01 -ERR -0700
'rojectName Engineering Van
Type Equipment Department Public Works: Engineering
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $66,400
Van used by Engineering Department for survey equipment and on job site work.
Current 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 2011 2012 2013 2014 2015 Total Future
F---1-6,-00-01 Vehicles 21,500 21,500 28,900
Total Total 21,500 21,500 Total
Prior
Funding Sources 2011
2012 2013 2014
2015 Total
Future
16,000
Equipment Replacement Fund
21,500
21,500
28,900
Total
Total
21,500
21,500
Total
Wednesday, Juice 30, 2010
69
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
City of Hopkins. MN
Project# 01 -ERP -0801
Project Name 4x4 3/4Ton Trucks (2)
Type Equipment Department Public Works: Parks/Forestry
Useful Life 8 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $313,800
Ducks used by Parks Division of Public Works.
Current vehicles: 2004 Ford F350 4X4 & 2004 Ford F350 4X4 I
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 2011
2012 2013
2014 2015 Total
Future
53,200 Vehicles
67,400
67,400
1 193,200
Total Total
67,400
67,400
Total
67,400
67,400
•
Prior
Funding Sources 2011
2012 2013
2014 2015 Total
Future
53,200
Equipment Replacement Fund
67,400
67,400
193,200
Total
Total
67,400
67,400
Total
Wednesday, June 30, 2010
71
11
•
EQUIPMENT REPLACEMENT PLAN 2011 rhru 2015
City of Hopkins, MN
Project# 01 -ERP -0807
Project Name Trucksters (3)
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
Fruckster used by Parks Division of Public Works for ballfield and parks maintenance.
(Current equipment 1996 Toro Workman, 2004 Toro Workman 3200 2004 Toro Workman 2110
Justification _
Park maintenance, ballfield grooming and weed spraying.
from 20 year plan - None
salvage/resale value on replaced item: $1,400 each
Prior
Expenditures 2011
2012 2013
2014 2015 Total
Future
29,900 1
Equipment
19,800
19,800
65,000
Total
Total
19.800
19,800
Total
Prior
Funding Sources 2011
2012 2013 2014
2015 Total
Future
F---29,9-0-01
Equipment Replacement Fund
19,800
19,800
F 65,000
Total
Total
19,800
19.800
Total
73
Wednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN
City of Honkins. MN
'roject# 01 -ERP -0813
?rojectName Brush Chipper
2011 thru 2015
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.
Current equipment: 1993 Brush Bandit
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 2011 2012 2013 2014 2015 Total
Equipment 25,700 25,700
Total 25,700 25,700
Funding Sources 2011 2012 2013 2014 2015 Total
Equipment Replacement Fund 25,700 25,700
TOW 25,700 25,700
75
Wednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 r iru 2015
Citv of Honkins- MN
Project# 01 -ERP -0901
Project Name Refuse Truck (Rear -L)
Type Equipment
Useful Life 10 years
Category Vehicles
Future
Department Refuse
Contact Public Works Director
Priority n/a
Description I Total Project Cost: $238,200
Zefuse truck used by Refuse Utility Division of Public Works.
Current vehicle: 1996 Fre
Justification
Residential waste pick up.
70
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $9,000
Expenditures 2011 2012 2013 2014 2015 Total Future
Vehicles 101,600 101,600 136,600
Total 101,600 101,600 Total
Funding Sources 2011 2012 2013 2014 2015 Total Future
RF - Refuse Fund
Total
•
77
101,600 101,600 1 136,600
101,600 101,600 Total
Wednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 thru 2015
Citv of Houkins. MN
Project # 01 -ERP -1001
Project Name Electric Ice Edger
Type Equipment Department Pavilion
Useful Life 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
:hat the ice resurface cannot reach.
I Justification I
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
Budget Impact/Other
Vairance from 20 year plan - New item.
Estimate salvage/resale value on replaced item: $
•
Expenditures 2011 2012 2013 2014 2015 Total Future
Equipment 5,000 5,000 1 6,700
TOW 5,000 5,000 Total
Funding Sources 2011 2012 2013 2014 2015 Total Future
PA - Pavilion Fund 5,000 5,000 1 6,700
Total 5,000 5,000 Total
79
Wednesday, June 30, 2010
EQUIPMENT REPLACEMENT PLAN 2011 th,-u 2015
• City of Hopkins, MN
•
Project 01 -ERP -1101
Project Name Art Center Carpet Extractor
Type Equipment Department Arts Center
Useful Life 10 years Contact Facilities Director
Category Equipment Priority n/a
Future
Description ( Total Project Cost: $7,700
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.
Justification
fhe current equipment is over 12 years old and very corroded from the dirt, water and cleaning chemicals. With regular touch up cleaning and
-emoval of stains in the Arts Center carpet with this extractor, the need to pay contractual cleaners to deep clean the carpet is reduced to once or
tiwice annually.
Budget Impact(Other
Variance from 20 year plan - New item.
Estimate salvage/resale value on replace item: $
Expenditures 2011 2012 2013 2014 2015 Total Future
Equipment 3,300 3,300 1 4,400
Total 3,300 3,300 Total
Funding Sources 2011 2012 2013 2014 2015 Total Future
AC - Arts Center Fund 3,300 3,300 4,400
Total 3,300 3,300 Total
81
Wednesday, June 30, 2010
C
20 Year
Replacement Schedule
•
•
3D -Jun -10
EQUIPMENT REPLACEMENT
SCHEDULE
$777,400
INFLATION FACTOR 3.0 %
-
REPL
EQUIPMENT/ VEHICLES
YRS
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
ACTIVITY CENTER
ERP -030 Copy Machine
7
_
15,000
. -
_
-
18,400
_
22,600
ERP -03 I... Reftigerator/Freezer
30
,SUBTOTAL
15,000
1
18,400
22,600
ARTSCENTER
ERP -1100 Copy Machine
7
12,100
14,900
_ 18,300
ERP -1101 Carpet Extractor -
IG
3,300
- -
_
4,400
-
12,100
3,300
14,900
_
4,400
18,300
CITY HALL ADMIN
ERP -003 Network Upgrade
I
8,000
8,000
8,000
8,000
8,000
8,000 _
8,000
8,000
8,000
8,000
_. 8,000
.8,000
8,000
8,000
8,000
8,000
8,000
8,000 _...
8,000
8,000
ERP -004.. Phone System ...
8 .
_.._
_..
_.
76,000
76,000
ERP -006 Computers
3-5
30,000
30,000
30,000
30,000
30,000
30,000
-
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
.ERP -009 Network Infrastructure Upgrade
15
-
-23,400
EQUIPMENT SUBTOTAL
38,000
38,000
38,000
38,000
114,000
38,000
38,000
33,000
38,000
38,000
38,000
61,400
114,000
38,000
38,000
38,000
38,000
38,000
38,000
38,000
COMMUNITY SERVICES
ERP -001 Main Copier
5
13,000
15,000
17,500
20,300
-
ERP -002. Small Copier,
5
-.
20,000
- 23,200
26,900
-
31,200
ERP -007 Engineering Printer/Scanner
ERP -008 Document Mgmt. Scanner (3)
5
3
10,000
6,500
10,000
6,500
10,000
6,500
10,000
6,500
12,000
6,500
12,000
6,500.
12,000
6,500
12,000
6,500
12,000
6,500
14,000
: 6,500:
14,000
6,500.
14,000
- 6,500 -.
14,000
6,500..
14,000
6,500
16,000
6,500.
16,000
6,500
16,000
6,500 -
16,000
-" 6,500.
16,000
6,500
18,000
6,500
ERP -010 Election Bombs
20
EQUIPMENT SUBTOTAL
29,500
16,500
36,500
16,500
18,500
33,500
18,500
41,700
18,500
20,500
38,000
20,500
47,400
20,500
22,500
42,800
22,500
53,700
22,500
24,500
FIRE
ERP -100 Tele -Squirt E-2 _
10
-.
_
.. _ ..
_
470,900
.ERP -101- Fire Pumper E-3
25
-
ERP -102 Heavy Rescue R-4
25
-
-
100,000
.ERP -103 Duty Chief Vehicle
15
-
.51,100.
-
ERP -103 Asst. Chief Vehicle
15
44,100
-
-
ERP -103 Asst. Chief Vehicle
15
37,000
57,500 .
ERP -104 Fire Paimper E-1.
X
-
ERP -105 Quick. Attack Pumper/Rescue T
15
234,000
364,600
GRP -105a Utility Vehicle
10
35,000
47,000
ERP -106 Aerial Truck L-9
20
54,217
54,217
54,217
54,217
54,217
54,217
54,217
54,217
-
1,572,000
VEHICLES SUBTOTAL
54,217
288,217
54,217
54,217
91,217
89,217
525,117
54,217
44,100
151,100
47,000
997,600
1,572,000
57,500
.ERP -107.... Air Compressor
-15
_.34,900
ERP -109 Extracting Tool (2)
1022,300
27,400
30,000
36,900_
ERP -110 Copy Machine
8...
_ 10,300
- - :
13,100.
16,600
ERP -207 Radio System
15
211,100
-
ERP -112 Thermal Imaging Camera (2)
10
11,500
12,900
-
.15,400
-17,400.
-
ERP -113 Emergency Preparedness Siren
20
-
38,500
ERP- 114.Floor Scrubber
12
10,400,.
_
,..
14,800
ERP -115 Floor Sweeper
12
.3,900
5,500
ERP -116 Workout Equip -Eliptical
6
5,800
-
6,700
7,800.
ERP -117 WorkoutEquip - Summit Traim
5
5,800
6,700
7,800
9,000_
ERP -118 WorkoutEquip- Treadmill
5
'5,000
-
5,800
-
6,700
_.7,800
-
ERP -119 Workout Equip -Weight Lifting
5
-
5,800
6,700.
_
7,800
9,000
ERP -120 Defibrillator (2)
4,
7,200
7,800
..
8,600
9,300
.10,200
ERP -122 WorkoutEquip - Dumb Bells
10
5,000
6,700
EQUIPMENT SUBTOTAL -
10,300
32,300
11,500
7,200
17,400
14,300
53,600
218,900
40,500
13,400
6,700
52,000
15,400
15,600
47,800
49,600
20,300
36,900
.28,200
82
84
REEL
EQUIPMENT NEIRCLES YRS
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022 2023
2024 2025
2026
2027
2028
2029
2030
P.W. PARKS & FORESTRY
ERP -800 1/2 Ton Truck
10
26,400
_.
_..
35,400
_
.ERP -801 4x43/4 Ton: Truck.
8
33,700
-
42,600
:.
54,000..
ERP -801 4x4 3/4 Ton Truck
8
33,700
42,600
54,000
ERP -802 3/4 Ton Utility Truck
10
32,200
-
48,700
ERP -804 Log Truck (50% w/Rcfuse)
15
81,800
ERP -805 Aerial Lift
20.
-
228,900
ERP -806 Tractor
30
49,300
:ERP -807 Truckster
15
19,800
...
30,800
ERP -807 Truckster
-
15
-.
23,000
e
ERP -307. Truckster .
' 15
11,200
-
ERP -803 Mower
8
22,800
28,900
36,600
ERP -808 Mower
8
20,300
25,700
-
32,600
ERP -808 Mower
8
_
10,300
13,000
16,500
ERP -809 Slope Mower
15
-
-
32,700:
ERP -810 Large Turf Mower
10
92,700
124,600
ERP -811 TurfSweeper
15
-
18,000
-
ERP -812 Stump Cutter
20
..
21,200
.ERP -813 Bruslt Clipper-
20
25,700
ERP -814 TrailcrFlatbed
15
2,200
ERP -815 Skid Loader
12
32,000
45,600
ERP -816 Toolcat
8
63,300
80,200
VEHICLES SUBTOTAL
156,100
48,500
20,300
82,000
53,200
81,300
34,200
193,100
28,900
142,900
128,900
30,800
124,500
82,200
386,100
P.W. STREETS/TRAFFIC
ERP -300 4x4 3/4 Ton Truck/1'low
10
33,600
- 45,200
ERP -301 4x43/4 TonTruck/Plow
8
30,400.
.38,500
48,800
ERP -302 4x2 1 Ton Dump Truck
12
54,600
77,800
.ERP -303 1 Ton Dump Truck -
12
34,700
49,500
.
ERP -303 I Ton Dump Truck
12
53,400
-
ERP -304. 1 Ton Boom Truck
17
75,000
_
-
124,000
ERP -305 Single Axle Dump Truck
17
-
132,100
ERP -305 Single Axle Dump Truck
17
-
124,000
ERP -306 Tandem Dump Truck
17
142,400
238,500
ERP -306 Tandem Dump Truck
17
22,000.
173,200
ERP -307 Water Truck
22
150,000
ERP -308 Front End Loader
15
172,000
-
268,000.
GRP -308 Front End Loader
18
268,600
-
- -
ERP -309 Skid Loader
12
41,900
-
59,700
ERP -309 Skid Loader
12
36,000
50,000
:ERP -310 Grader •
20
-
... 167,300
ERP -311 Sweeper
12
156,400
223,000
ERP -312 Roller
20
45,900
ERP -313 Striper
12
-
-
11,200
BRP -314 Paver.
20
48,800
ERP -315 Snow Blower
20
102,300
ERP -316 Trailer
20
-
ERP -317 Sign Machine
10
13,400
-
18,100
VEHICLES SUBTOTAL
58,000
327,600
329,200
48,300
47,000
144,200
161,200
351,800
170,600
103,400 268,600
49,500 453,600
268,000
59,700
.172,800
316,300
84
•
REPL
EQUU'MENT/VEHICLF.S YRS 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030
GENERALFUND-VEHICLES/EQUIP 240,917 869,917 554,217 274,917 305,017 480,817 853,017 635,317 197,100 377,500 371,300 378,000 481,000 189,000 748,500 430,100 1,502,900 1,955,600 416,500 961,000
GENERAL FUND -OTHER EQUIP 105,400 173,000 147,700 164,700 173,400 173,400 .13.1,401 396,300 761;800 163,100 122,100 '177,200 220,100.E 23.1,500 124,600 99,600 181,800 218,900 227,500 163,500 114,200
HRA _ 13,000 32,400 16,500 41,100 20,900
ARTSCENTER 12,100 3,300 14,900 - 4,400. 18,300
WATER 134,800 21,000 61,700 59,700 16,500 6,800 19,100 82,900 41,700 22,100
SEWER 35,700 6,800 33,600 26,400 59,700 180,800 23,000 6,800 48,000 45,200
REFUSE 101,600 204,800 59,700 247,300 81,800 136,600 275,200 144,800
STORM SEWER
PAVILION 185,000 - 6,700 256,600
GENERAL FUND TOTAL 346,317 1,042,917 701,917 439,617 478,417 612,218 1,249,317 1,399,117 360,200 499,600 548,500 598,100 712,500 313,600 848,100 611,900 1,721,800 2,183,100 580,000 1,075,200
HRA TOTAL 13,000 32,400 .16,500 _ 41,100 20,900
ARTS CENTER FUND TOTAL 12,100 3,300 14,900 - 4,400 18,300
UTILITYFUNDSTOTAL 134,800 322,300 232,600 33,600 88,100 179,100 . ,444,600 104,800 13,600 191,300 294,300 301,800 82,900 41,700 166,900
358,417 1,046,217 836,717 774,917 743,417 645,818 1,337,417 1,593,117 360,200 944,200 548,500 723,800 767,200 504,900 1,160,700 913,700 1,804,700 2,224,800 580,000 1,263,000
GENERAL FUND SALVAGE 30,000 35,000 35,000 35,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000
NET GENERAL FUND 316,3.17 1,007,917 666,917. 404,617 ..438,417 '572,218 1,209,317 1,359,117. 320,200 , 459,600 508,500 5581100s 672,500','.273,600 808,100 .571;900 1,681,800 2,143,100 540,000 1,035,200
20 YEAR AVERAGES:- Total Averaac
ACTIVITY CENTER ADMINISTRATION 56,001 2,800
CITY HALL ADMINISTRATION 935,400 46,800
.CONIMUNITY.SERVICES 565,100 28,300
FIRE EQUIPMENT 4,079,936 204,000
FIREADMINISTRATION. 691,900 34,600. -
POLICE EQUIPINFENT 3,095,600 154,800
POLICE ADMINISTRATION 1,786,800 ' 89,300 -
PUBLIC WORKS ADMINISTRATION 56,300 2,800 -
BLDG.IEQUIPMENT:SERVICES EQUIPMENT 81,700 4,100
ENGINEERING
ENGINEERING EQUIPMENT 50,400 2,500
PARKSMORESTRY EQUIPMENT 1,593,000 79,700
STREET EQUIPMENT 3,330,300 166,500 - -
GENERAL FUND VE•HICLE/EQUIPMENT 12,230,936 611,500
GENERAL FUND OTHER EQUIPMENT. - 4,091,501 204,600 .
GENERAL FUND TOTAL 16,322,437 816,100
'HRA. 123,900 6,200.
ARTS CENTER FUND 53,000 2,700
WATER UTILITY FUND 4GG,300. - 23,300
SEWER UTILITY FUND 466,000 23,300
REF- USE UTILITY FUND _ :1,251,800 - 62,600;
STORM SEWER UTILITY FUND
PAVILIONFUND ..448,300:. 22,400
UTILITY VEI ICLES/EQUIPMENT 2,809,300 140,500
86
•
Equipment and Building
Inventory
40
0
CITY OF HOPKINS
• VEHICLE/EQUIPMENT INVENTORY
06/15/2010
CURRENT
REPLACEMENT
UNIT # YEAR MAKE MODEL COST
FIRE DEPARTMENT
100
2006
DODGE
DURANGO
28,300
102.
1989
FORD L9000
TELE -SQUIRT
$240,000
103.
2006
PETERBILT
PUMPER
403,300
104.
1991
PETERBILT
HEAVY RESCUE
190,000
105.
1998
FORD
CROWN VICTORIA
22,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
120.
1995
CHEVROLET
SUBURBAN
121.
2005
FREIGHTLINER
M2
• POLICE DEPARTMENT
200.
2010
FORD
CROWN VICTORIA
$30,000
201.
2008
FORD
CROWN VICTORIA
28,100
202.
2008
FORD
CROWN VICTORIA
28,100
203.
2009
FORD
CROWN VICTORIA
28,160
204.
2007
FORD
CROWN VICTORIA
29,000
206.
2007
FORD
CROWN VICTORIA
29,000.
207.
2010
FORD
CROWN VICTORIA
30,000
208.
2007
FORD
CROWN VICTORIA
29,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.
2005
CHEV
IMPALA
20,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
87
•
•
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
06/15/2010
UNIT # YEAR MAKE
PARKS/FORESTRY DIVISION
800.
803.
804.
805.
810.
811.
812.
816.
817.
818.
819.
820.
821.
822.
824..
825.
826.
828.
832.
833.
834.
836.
840.
844.
845.
846.
2001
2004
2004
1998
1993
2006
2010
1984
1982
1996
1987
2004
2004
2001
1996
2010
2004
2001
1997
2004
1993
1991
2010
1997
2001
FORD
FORD
FORD
DODGE
INTERNATIONAL
INTERNATIONAL
FREIGHTLINER
FORD
FORD
TORO
CUSHMAN
TORO
TORO
TORO
TORO
TORO
TORO
DEW EZE
VERMEER
BOBCAT
BRUSH BANDIT
RYAN
VICTORIAN
FELLING
REMACKEL
DRESSEN
411. 2007 CHEV
89
MODEL
RANGER4X4
F350
F350
RAM 3500
LP 4700
LP 4600 LOG TRUCK
AERIAL LIFT
TRACTOR 2910
TRACTOR 2610
TRUCKSTER
HAULSTER
WORKMAN 3200
WORKMAN 2110
325-D MOWER
GROUND MASTER
4100D MOWER
Z587L
ATM72
STUMP CTR 630A
SKID LOADER
CHIPPER 250
SOD CUTTER
TRAILER
TRAILER
TRAILER
8110
2500 HD
CURRENT
REPLACEMENT
COST
$18,000
23,000
23,000
24,000
50,000
45,000
130,000
22,000
22,000
13,000
5,000
15,000
7,900
18,000
16,000
53,000
8,900
21,000
15,400
22,000
14,000
2,000
2,000
4,000
5,000
2,000
$17,500
. CITY OF HOPKINS
BUILDING INVENTORY
June 2010
Location/Descrit)tion Replacement Cost
City Hall
$3,370,837
1010 1st Street S.
Police Station
3,801,157
1010 1st Street S.
Fire Station
4,091,653
101 17th Avenue S.
Hopkins Activity Center
1,324,718
33 14th Avenue S.
Ice Arena/Pavilion
4,404,998
11000 Excelsior Boulevard
Arts Center
5,439,674
1111 Mainstreet
PW Admin/Garage
6,217,636
• 11100 Excelsior Boulevard
Moline Reservoir
1,613,617
10421 Excelsor Boulevard
Blake Tower Reservoir
806,810
151 Tyler Avenue S.
Well #1 Filtration Plant
208,424
10421 Excelsior Boulevard
Filtration Plant
1,391,782
1401 Elmo Park Service Road
Well #4 Workshop/Storage
283,492
1401 Elmo Park Service Road
Well #5
114,299
1205 Highway?
Well #6
114,299
801 Highway 7
Lift Station #1 - 21st 107,574
• 202 21 st Avenue N.
91
•
•
Location/Description Replacement Cost
Dow Towers (76 Units) HRA
22 5th Avenue S.
20th Avenue Townhouses (10 Units)
HRA
29 20th Avenue S.
Parking Ramp
4,409,208
10th Avenue and Mainstreet
Depot Coffee House
469,400
9451 Excelsior Boulevard
Overpass Skate Park
7,331
100 Washington Avenue
93