Memo - 2010-2014 Equiment Replacement PlanCITY OF HOPKINS
MEMORANDUM
Date: July 7, 2009
To: Mayor & City Council t�(
From: Christine Harkess, Finance Director
Subject: 2010 - 2014 Equipment Replacement Plan
Overview
FINANCE DEPARTMENT
The City of Hopkins is beginning the process of establishing the 2010 -2014 equipment
replacement plan. Every year the city council reviews with the city manager and staff, the
equipment planned for replacement for the next five years. The goal is to ensure the city's
priorities and objectives are being met and the funding sources are reasonable and available.
Departments were once again asked to assess the equipment planned for replacement, evaluate
the estimated cost and life expectancy of the equipment with the intent to prolong equipment life
expectancy when practical and to refurbishing equipment instead of replacing it.
Through a combination of several equipment changes and a better estimate of costs, departments
were successful in accomplishing this goal. Included in the ERP draft is an explanation of the
changes that are considered for implementation.
ERP Goals
• Maintain the integrity, reliability and safety of city equipment.
• Provide funding for replacement of current equipment as needed.
• Forecast funding needs and tax implications to assure strong long -term financial stability.
Attached is a draft of the 2010 -2014 equipment replacement plan.
EQUIPMENT REPLACEMENT PLAN 2010 - 2014
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
$639,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 but have not increased since
resulting in a steady decline in the working capital of the fund. Intragovernmental charges are at
55% of what they were in 2002 and at the current rate structure will not return to that level until
2023. Unfortunately our equipment needs are not changing. The plan as presented proposes a
2% increase in charges for 2010 and 2011, a 3% increase in 2012 and 2013 and a 5% increase in
2014.
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.
Highlights of changes from last year's equipment replacement plan for the years 2010 -2014:
City Hall: The telephone system was originally scheduled for replacement in 2011 at
a cost of $89,600, however, due to promotional pricing and a manufacturer
rebate we can upgrade the controller at a cost of under $6,800 and
postpone the replacement until 2015. The upgrade will be done in 2009.
Due to volunteer staffing and the amount of scanning that needs to be done
a third scanning station was added to the ERP. We currently have two
large document scanners (scanners that take paper up to 11 x 17) and one
small scanner. We are proposing to replace the small scanner with a large
document scanner in 2010 so that we have three large scanners.
The cost to replace the small copier scheduled for replacement in 2011
was reduced by $6,900 to $20,000 as costs of copiers have come down.
Fire: An aerial ladder truck was purchased in 2008 with a combination of cash
and a capital lease. The capital lease payments were added to the ERP for
the years 2010 -2018 at $54,217 per year.
Fitness Center — the dumb bells and stand scheduled for replacement in
2009 have been postponed until 2012. The treadmill originally scheduled
for 2011 has been postponed to 2012 and the weightlifting equipment
scheduled for 2011 has been postponed to 2015. All fitness equipment is
reviewed annually and the replacement schedule adjusted accordingly.
Police: The six police patrol cars replacement schedule has been re- evaluated and
the replacement of the patrol cars spread out evenly over their life cycle.
Due to the 2003 budget challenges the replacement of several patrol cars
was extended and the replacement schedule for these vehicles was thrown
off schedule. The status of the cars was evaluated along with the
replacement schedule.
The police computer system budgeted at $700,000 in previous ERP's was
reduced to $500,000 in 2008 to better fit within the overall ERP plan, in
2009 it was again reduced and funded over a two year period at $200,000
per year in 2013 and 2014. This EPR item was again evaluated and it has
been determined that the existing system may not need replacing but rather
an upgrade. The upgrade has been scheduled for 2017 at a cost of
$200,000.
Digital squad car cameras purchased in 2006 with police department funds
have a life expectancy of 5 years. They were added to the ERP in 2008
for replacement in 2011 at a cost of $42,600. Due to continued equipment
failure the cameras were replaced in 2009 with combined funding from the
ERP, computer fund, DUI forfeiture, and federal stimulus funds. The
cameras have a 5 year life and are again scheduled for replacement in
2014.
The replacement of radio's — portable and mobile totaling 132 among the
police (82), fire (40) and public works (10) and originally purchased with a
Homeland Security grant were not scheduled in the ERP. The units will
be replaced as they wear out or no longer work therefore to provide for
replacement we have a scheduled replacement fund at $15,000 per year
starting in 2012. The current cost (2009) to replace the portable radio's is
$2,300 per unit and the mobile radio's is $3,000 per unit.
Activity Center: Previously scheduled for replacement in 2013 the refrigerator /freezer was
moved up to 2010 due to increasing maintenance issues and the age of the
unit (has been in service since the Activity Center opened in 1980),
however it has been determined that we can continue to repair and use the
existing freezer so the replacement has been delayed indefinitely.
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.
Streets /Traffic
The 1 -ton dump truck with an estimated cost of $37,400 and trailer at an
estimated cost of $4,900 originally scheduled for replacement in 2009
were postponed to 2010.
Parks /Forestry
The large turf mower originally scheduled for replacement in 2013 was
moved to 2011 for the 2008 ERP and now has been moved up to 2010
based on maintenance experience and required repairs. This mower is
required to efficiently mow the large parks.
Two tractors currently on a 20 year replacement plan will be changed to
one at 20 years replacement and one at 30 years replacement. The 20 -year
tractor scheduled for replacement in 2009 was postponed to 2012 and the
30 -year tractor is scheduled for replacement in 2014.
The three riding lawn mowers had a replacement schedule of 2009, 2012
and 2014. Upon evaluation of the mowers the mower scheduled for 2009
has been postponed to 2011.
Water
Water funds share of telephone cost postponed to 2015 as described above
under City Hall.
Sewer
Sewer funds share of telephone cost postponed to 2015 as described above
under City Hall.
Refuse
Swap loader originally scheduled for replacement in 2008 was postponed
in late 2008 to 2010. This was done after the 2009 ERP was completed so
the swap loader was not in the 2009 ER-P. The cost of the swap loader was
changed to be 100% funded by the refuse fund. It was formerly funded
75/25 refuse /public works - forestry.
EQUIPMENT REPLACEMENT FUND (602) 07/07/2009
Rate Change
Working Capital Begin Year
Revenues from charges
Transfer in General Fund
Transfer In - Pavilion - Capital Lease
Transfer In - Pavilion - Hockey Loan
Federal & State Grants
Fire Truck Lease
Reimbursement - Radio System
Interest earnings
Other revenues (sale of assets)
Total Revenues
Expenditures (excludes Depr.)
expenditures include copier & eng scanner leases
Fire Truck Financing Pymnts (2009 -2023)
Capital Outlay - Equipment
Transfer to Pavilion (loan)
Working Capital Ending Balance
Cash balance
Memo Only
Long Term Receivable
2007 Hockey Booster Loan repayment
Cash Balance + LT Receivable
0%
0%
0%
2%
2%
3%
3%
5%
ACTUAL
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
BUDGET
2007
2008
2009
2010
2011
2012
2013
2014
1,252,175
1,371,188
1,033,705
1,083,892
1,007,328
996,800
351,161
61,984
287,125
287,127
287,125
292,868
298,725
307,687
316,917
332,763
137,806
20,000
20,000
20,000
20,000
20,000
15,609
3,217
3,143
3,143
3,143
3,143
3,143
3,142
12,154
425,000
66,984
37,377
46,607
51,305
50,299
52,265
25,651
15,078
9,456
16,150
20,000
25,000
25,000
25,000
25,000
30,000
501,371
801,025
376,875
392,316
397,167
408,095
386,321
380,983
56,121
25,604
26,372
27,163
27,978
28,817
29,682
30,572
3,889
. 54,217
54,217
54,217
54,217
54,217
54,217
304,237
1,109,014
246,100 i
387,500
325,500
970,700
591,600
414,700
22,000
382,358
1,138,507
326,689 I
468,880
407,695
1,053,734
675,498
499,489
1,371,188
1,033,705
1,083,892 l
1,007,328
996,800
351,161
61,984
(56,522)
1,369,304
1,035,710
1,140,113
I I 1,117,765
1,161,455
570,032
335,071
270,782
115,609
95,609
75,609
l 55,609
35,609
15,609
-
22,000
18,783
15,640
12,497
9,354
6,211
3,068
(74)
1,484,913
1,131,319
1,215,722
1,173,374
1,197,064
585,641
Christine M Harkess:
net of leases shown under expenditures
city hall main copy machine $2,400
Engineering printer /scanner $8,640
$113,000 items originally slated for 2009 have
been moved to 2010.
Working Capital Beginning Year
Revenues:
Operating Revenues
Miscellaneous (penalties)
Grants
Interest
Total Revenues
Expenditures:
Operation Expense
Transfer Out
Capital Outlay (per ERP)
Capital Projects per CIP
Capital Lease (PW Facility)
Total Expenditures
Change in available funds
Inventory change
Working Capital Ending Year
Rate History
1989 $15.10
1991 $17.25
1995 $11.00 -14.45 refuse
$2.25 recycling fee
2002 $2.75 recycle fee
2005 $13.20,15.90, 17.25, refuse
2008 $3.25 recycling fee
2009 $15.85, 18.55, 21.25, refuse
2009 $3.50 recycling fee
2010 $3.75 recycling fee
2011 $16.85, 19.85, 23.15 refuse
2012 $4.00 recycling fee
2013 $17.85, 20.85, 24.15 refuse
2014 $4.25 recycling fee
REFUSE FUND - WORKING CAPITAL PROJECTION
903,169
07/07/2009
Actual Actual Projected Projected Projected
Projected
Projected Projected
2007 2008 2009 2010 2011
2012
2013 2014
266,196 230,536 218,619 228,342 (46,228)
(13,053)
19,263 94,136
G = Garbage fee increase
R = Recycling fee increase
Recycling - 2008 revenues totaled $111,945.11
On average recycling accounts total 2870 per month
966,140 G 982,140 R
19,000 18,500
193 941
985,333 1,001,581
885,460
903,169
0
G&
25,000
25,000
683,527
702,751 R
831,530
R 840,140 R
895,140 G
911,140 R
8,695
10,519
12,000
21,920
24,776
23,000
23,000
23,000
23,000
14,992
8,408
12,500
2.283
(462)
(131)
729,134
746,454
879,030
865,423
917,678
934,009
686,739
724,027
834,307
850,993
859,503
876,693
52,681
8,850
10,000
264,000
0
0
25,000
25,000
25,000
25,000
25,000
25,000
764,420
757,877
869,307
1,139,993
884,503
901,693
(35.286)
(11,423)
9,723
(274,570)
33,175
32,316
(374)
(494)
230,536
218,619
228,342
(46,228)
(13,053)
19,263
G = Garbage fee increase
R = Recycling fee increase
Recycling - 2008 revenues totaled $111,945.11
On average recycling accounts total 2870 per month
966,140 G 982,140 R
19,000 18,500
193 941
985,333 1,001,581
885,460
903,169
0
101,600
25,000
25,000
910,460
1,029,769
74,873
(28,188)
94,136 65,948
City of Hopkins, MN
EQUIPMENT REPLACEMENT PLAN
2010 thru 2014
FUNDING SOURCE SUMMARY
Source
2010
2011
2012
2013
2014
Total
Bonds /Lease
54,217
54,217
54,217
54,217
54,217
271,085
Equipment Replacement Fund
399,900
335,500
980,700
616,600
424,700
2,757,400
HCA - Arts Center Fund
12,100
12,100
PA - Pavilion Fund
88,100
88,100
RF - Refuse Fund
264,000
101,600
365,600
SF - Sanitary Sewer Fund
35,700
35,700
WF - Water Fund
12,200
134,800
147,000
GRAND TOTAL
730,317
401,817
1,034,917
805,617
704,317
3,676,985
Tzresday, Judy 07, 2009
City of Hopkins, MN
EOUIPAMATT REPLACEMENT PLAA
2010 t;Iru 2014
PROJECTS BY FUNDING SOURCE
Source Project# Priority 2010 2011 2012 2013 2014 Total
, ! Bonds/Lease
Aerial Truck 0 i - ERP -106 Na 54.217 54 217 54 917 nn n,; -A
Bonds /Lease "total
Equipm R eplace m ent Fund
13,000
City Hall Main Copy Machine - Oce' Copier
01-ERR-001
City Hall Small Copy Machine
0i -ERP -002
Network Server
01 -ERP -003
Computers
01- ERP -005
Engineering Printer /Scanner
01 -ER° -007
Document Management Scanner (3)
01- ERP -008
Election Booths
O1 -ERP -010
Activity Center Copy Machine
01 -ERP -030
Duty Chief Vehicle
01 -ERP -103
Extrication Tool (2)
01 -ERP -109
Copy Machine
01 -ERP -110
Thermal Imaging Camera (2)
O1 -E,RP -112
Workout Equipment - Eliptical
01- ERP -115
Workout Equipment- Stairmaster
G1 -ERP -117
Workout Equipment - Treadmill
01 -E,RP -118
Automated External Defibrillator (2)
O1- ERP -120
Quick Attack Pumper /Rescue
01- ERP -121
Workout Equipment- Dumb Bells
01- ERP -122
Marked Patrol Vehicles (6)
01 -ERP -200
Sergeant's Vehicle
01 -ERP -201
Utility 44 (unit 212)
01 -ERP -203
Police Administrative Vehicles (2)
01 -ERP -204
Copy Machine
G1- ERP 209
Logging Recorder
01 -E.RP -210
Network Server (3)
01- ERP -211
Mobile Data Computers
0 i ERP -212
Digital Squad Car Cameras
01- ERP -213
Tactical Ballistic Vests
01 -ERP -214
Radios - Portable and Mobile Devices
01- ERP -215
4X4 3/4 Ton Truck with Plow
01- ERP -301
1 Ton Dump Truck (2)
G1- ERP -303
1 Ton Traffic Boom Truck
O1 -ERP -304
Tandem Dump Trucks (2)
01 -ERP -306
Water Truck
01 -E,RP -307
Front End Loaders (2)
01 -ERP -308
Skid Loader (2)
01 -ERP -309
Sweeper
01 -ERP -311
Roller
01 -ERP -312
n!a
n,!a
nia
n'a
n/a
ma
n!a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n'a
n %a
n!a
ma
n'a
n!a
n'a
n/a
n/a
n
n'a
n; a
n'a
n'a
n/a
n/a
n,'a
n/a
n/a
n/a
n/a
n/a
^Ja
54,217 54,217 54,217 54,217 54,217 271,085
2,400
13,000
20,000
8,003
8,000
8,000
8,000
8,OOC
32 006
33,030
30,000
30,000
30 N'
10,003
10,000
10,000
10,006
10.010
6,500
6.500
6,500
6,570
6.500
6,506
x.000
36,400
26,500
10,300
18,000
5.000
6,000
55,209 67,230
33,600
27,10( 27,900
19,100
c 50- 8,560
37.400
45,000
36.000
5,000
5,000
7.200
234,030
5,030
69,200 71,203
28,800 29,600
8,500 8,500
62.700
23, 20,)
15,000 15,000
30,400
34,700
75,000
132,300
172,000
164,500
45,900
73,400
47,700
30,500
36,900
8,500
12.600
15,000
15,400
20,000
40.000
150,000
50,009
32.500
6,500
15.000
36,400
26,500
10,300
18,000
5,000
5, 000
5,003
13,200
234 000
5,000
346,200
33,600
47,700
143,900
19,100
36, 900
42.500
62, 730
42, 600
23,200
45.000
30,400
72,100
75,000
132,300
45,000
172,000
36,090
164,500
45, 900
Turszlai. Ji,lr 07, 2009
' Source Project# Priority
2010
2011
2012
2013
2014
Total
Asphalt Paver
O1 -ERP -314
n/a
48,800
48,800
Trailer
01 -ERP -316
n/a
4,900
4,900
Engineering Van
01 -ERP -700
n/a
21,500
21,500
26,400
112 Ton Pickup Truck
01 -ERP -800
n/a
26,400
67,400
4x4 314Ton Trucks (2)
01 -ERP -801
n/a
67,400
32,200
314 Ton Utility Truck
01 -ERP -802
n/a
32,200
41,400
46,500
87,900
Tractors (2)
01 -ERP -806
n/a
19,800
19,800
Trucksters(3)
01 -ERP -807
n/a
22,800
10,300
20,300
53,400
Riding Mowers (3)
01 -ERP -808
n/a
65,000
Large Turf Mower
01 -ERP -810
n/a
65,000
25,700
25,700
Brush Chipper
01- ERP -813
n/a
Equipment Replacement Fund Total
399,900
335,500
980,700
616,600
424,700
2,757,400
0 - CA - Arts Cente Fund
Arts Center Copy Machine
01- ERP -1100
n/a
12,100
12,100
HCA - Arts Center Fund Total
12,100
12,100
PA - Pavilion F und
Ice Resurfacer
01 -ERP -1000
n/a
88,100
88,100
88,100
B8,100
PA - Pavilion Fund Total
RF fuse Fund -
�'
Swap Loader
01 -ERP -803
n/a
80,000
80,000
184,000
Refuse Truck (RAP -R) (2)
01 -ERP -900
n/a
184,000
101,600
101,600
Refuse Truck (Rear-L)
01 -ERP -901
n/a
RF - Refuse Fund Total
264,000
101,600
365,600
ISF - Sanitary Seiv Fund
44 314 Ton Truck
01 -ERP -550
n/a
35,700
35,700
35,700
35,700
SP - Sanitary Sewer Fund Total
WF - Water Fund
Backhoe Loader
01 -ERP -502
n/a
134,800
1,800
Public Works Copy Machine
01 -ERP -506
nla
12,200
12
12,200
WF - Water Fund Total
12,200
134,800
147,000
GRAND TOTAL
730,317
401,817
1,034,917
805,617
704,317
3,676,985
Tuesdon July 07, 2009
City of Hopkins, MN
EQ UIPMENT REPLACEMENT PLAN
2010 thru 2014
DEPARTMENT SUMMARY
7'uesday, July 07, 2009
2010
2011
2012
2013
2014
Total
Department
15,000
15,000
Activity Center
12,100
12,100
Arts Center
38,000
38,000
38,000
38,000
38,000
190,000
City Hall Administration
25,400
49,500
16,500
16,500
16,500
124,400
Community Services
101,617
64,517
329,717
79,417
54,217
629,485
Fire
88,100
88,100
Pavilion
100,800
156,300
184,200
147,500
254,600
843,4
Police �
21,500
21,500
Public Works'. Engineering
65,000
81,400
138,900
25,700
66,800
377,800
Public Works: Parks /Forestry
327,600
327,200
48,800
826,900
Public Works:Streets/Traffic
123,300
101,600
365,600
264,000
Refuse
35,700
35,700
Sewer
134,800
147,000
12,200
Water
730,317
401,817
1,034,917
805,617
704,317
3,676,985
GRAND TOTAL
7'uesday, July 07, 2009
City of Hopkins. %'1N
EOLIP IIENT REPLACE -AIENT PLA All
2010 tl - 2014
PROJECTS BY DEPARTMENT
Department
Project#
Priority
2010
2011
2012
2013
2014
Total
Activity Center
Activity Center Copy Machine
O1- ER,� -030
n
15000
15.000
Activity Center Total
15,000
15,000
Arts Center
Arts Center Copy Machine
01 -ERP -1 i 00
n/a
12,100
12,100
Arts Center Total
12,100
12,100
City Hall Administration
Network Server
Computers
01 -6RP 003
nia
8,000
8,000
8,000
8,000
8,000
40 000
01 ERP -0G6
nla
30,000
30,000
30,000
30,000
30,000
150.000
City Hall Administ Total
38,000
38,000
38,000
38,000
38,000
190,000
Community Services
City Hall Main Copy Machine - Oce' Copier
01 - 5RP - 001
n/a
2,400
13,000
City all Small Co Machine
� PY
D_
01 -ER, 002
n/a
20,000
15,400
Engineering Printer /Scanner
01 -ERP -007
n/a
10,00
10,000
10,000
10,000
20,000
Document Management Scanner (3)
01 -ERP -008
nia
6,500
6,500
10,000
50,000
Election Booths
01 -FRP -0 0
6,500
6,50C
6,500
32500
nia
6 500
E.500
Community Services Total
25,400
49,500
16,500
16,500
16,500
124,400
Fire
Duty Chief Vehicle
01- ERP - i 03
nla
36 400
Aerial Truck
G1- ERP -i 6
n!a
54.217
54,217
54,217
54,217
54,217
36,400
Extrication Tool (2)
Oi- ERP -109
^ia
271
Copy Machine
-RP i 0
��ia
0 300
26,500
26,500
Thermal Imaging Camera (2)
- ;
G1 -t R:
1 0,300
Workout Equipment - Eliptical
.2
01- ERP -1116
nia
n,a
18,000
18,000
Workout Eq
ui ment - Stairmaster
O1 ER, P_ j 17
Na
5, ,, 0�
�
5,000
5,000
Workout Equipment - Treadmill
01 -ERP -118
nia
5,000
Automated External Defibrillator 2 O
01- ERP -120
ma
6,000
5,000
5,000
Quick AttackPumper /Rescue
01 -ERP -121
n/a
7,200
13,200
Workout Equipment - Dumb Bells
O1 -ERP -122
nla
234,000
234,000
5,000
5,000
Fire Total
101,617
64,517
329,717
79,417
54,217
629,485
Pavilion
Ice Resurfacer
01- ERP -
Na
88,100
88,100
Tzresda7, July 07, ?OOJ
Department Project# Priority
2010
2011
2012
2013
2014
Total
88,100
88,100
Pavilion Total
L Police
Marked Patrol Vehicles (6)
01 -ERP -200
n1a
65,200
67,200
69,200
71,200
73,400
346,200
Sergeant's Vehicle
01 -ERP -201
n/a
33,600
47,700
33,600
47,700
Utility 4x4 (unit 212)
01 -ERP -203
01 -204
nla
n/a
27,100
27,900
28,800
29,600
30,500
143,900
Police Administrative Vehicles (2)
-ERP
19,100
Copy Machine
01 -ERP -209
n/a
19,100
36,900
36,900
Logging Recorder
01 -ERP -210
01 -ERP -211
n/a
n/a
8,500
8,500
8,500
8,500
8,500
42,500
Network Server (3)
62,700
62,700
Mobile Data Computers
01 -ERP -212
nla
42,600
42,600
Digital Squad Car Cameras
01 -ERP -213
n/a
23,200
23,200
Tactical Ballistic Vests
01 -ERP -214
n/a
15,000
15,000
15,000
45,000
Radios - Portable and Mobile Devices
01 -ERP -215
n/a
Police Total
100,800
156,300
184,200
147,500
254,600
843,400
Public Works: Engineering
Engineering Van
01 -ERP -700
n/a
21,500
21,500
21,500
21,500
Public Worlcs: Engineering Total
; Public Worlcs: P arks /Forestry
1l2 Ton Pickup Truck
01 -ERP -800
n/a
26,400
26,400
67,400
4x4 3 /4Ton Trucks (2)
01- ERP -801
n/a
67,400
32,200
3l4 Ton Utility Truck
01 -ERP -802
n/a
32,200
41,400
46,500
87,900
Tractors (2)
01 -ERP -806
n/a
19,800
19,800
Trucksters (3)
01 -ERP -807
n/a
22,800
10,300
20,300
53,400
Riding Mowers (3)
01 -ERP -808
n/a
65,000
Large Turf Mower
01 -ERP -810
n/a
65,000
25,700
25,700
Brush Chipper
01 -ERP -813
n/a
Public \NIorlcs: Parks /Forestry Total
65,000
81,400
138,900
25,700
66,800
377,800
Public Works: Streets /Traffic
4X4 3/4 Ton Truck with Plow
O1 ERP 301
n/ a
30,400
30,400
72,100
1 Ton Dump Truck (2)
01 ERP 303
n/a
37,400
34,700
75,000
1 Ton Traffic Boom Truck
01 -ERP -304
n/a
75,000
132,300
132,300
Tandem Dump Trucks (2)
01- ERP -306
n/a
45,000
Water Truck
01 -ERP -307
n/a
45,000
172,000
Front End Loaders (2)
01 -ERP -308
n/a
172,000
36,000
Skid Loader (2)
01 -ERP -309
n/a
36,000
164,500
164,500
Sweeper
01 -ERP -311
n/a
45,900
45,900
Roller
01 -ERP -312
n/a
48,800
48,800
Asphalt Paver
O1- ERP -314
n/a
4, 900
Trailer
01 -ERP -316
n/a
4,900
Public Works: Streets /Traffic Total
123,300
327,600
327,200
48,800
816,900
jRefuse
Swap Loader
01 -ERP -803
n/a
80, 000
80,000
184,000
Refuse Truck (RAP -R) (2)
01 -ERP -900
n/a
184,000
101,600
101,600
Refuse Truck (Rear -L)
01 -ERP -901
n/a
Tuesday, July 07, 2009
Department
Projects
2010
2011 2012 2013
2014
Total
Refuse Total
264,000
101,600
365,600
Sewer
44 314 Ton Truck
01 -ERP -550 tia
35,700
35,700
Sewer Total
35,700
35,700
Water
Backhoe Loader
01- ERP -502 n;a
134,800
34,800
Public Works Copy Machine
01- ERP -506 n!a
12,200
92,200
Water Total
12,200
134,800
147,000
GRAND TOTAL
730,317
401,817 1,034,917 805,617
704,317
3,676,985
Tuesday, July 07, 2009
0
m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m
�o 'o t
Fd��EC n�max ma_ o> o ?� mo; �v n o �� a a o
m o y o 0 0 0 0 o m� a o �;
A o o o 0 o to tom ° g o m r, n 'e n C n n 3 S '� Y-q
c? w 3 5
z m _ z
n
m 3
y Q
� N N N O W In lli W
O W to In In P N N O p In W O U O lA VI U N 00 J O J
� •!� O O O • O O O O O O
p 00 p J J O O O O O O O O O
O O A A P O O w m O oo N
'' "N O IJ O O O • O
O O O O O J O J O O O O O O
J oo A A O� O. "O o • O Oo
O O O J O O O O O O O O
A A P P O wm O o0
J p 0 0 O O O
r J
u U A N P N A O P .O
O O O O
U — N
o A A P P N
• • j.� N U "O N O O O O
o p p o 0 o p o p o ° o ° o 0
O O 0 0 J J
N W p p oo P N o O Oo
� U O
O N O N N
O O O O J J • O • O O O O O
O O O J O O O O O O O
N W • O O O • P N O Oo
El
• O "O O O O O O O O O O O
O p O
P P m w O "P A w O o0 00 00
O O O O • O O O O O O O O O
O O O O O O O O
P P A P A P J W O Oo
J O O
O O " O O • O O O " O O O
O • P A T W • O o0
• p, U O • A A O O
O O O O 00 p p p 0 0 0 O
O O O O
A A • O P A A O "O o0
O O O O O O O p 0
O O O p 0
p� P
O O p p p 0 O O O
O O
IN p� p� N P P Do O Oo
_ J "N "p .O • O O
O 0 0 0 0 O O O
J P P wW O Oo
N N
to O "O O O P •P
O O O O O
"O .�
O A O 0 0 • O O O
O O O p O O O O O O
A A IJ P O. o O , 00
y — • U p O O O
O
7 �
' a
d
� y
n
H
e Is�i e
n t e
e Z
N
O
{
A
< C
00 �
Z
P �
r
r�
n
x
0
C
r
n
N
b
N
N
N
V
IN
N
O
b
0
> >
t L L
cc
O
l
- O
0
N
M m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m
w w _w w w V w w o w w w w m w o0 00 _o 0o ro o0 w m
y
o o ❑ 9 a H H N A A w c o° o 0 2 2 2 D n ° A A A IS
,a o7 o o >> O O-
3 EE� y H -j a d n n n p l r 2° H a
d n
m o 9 3 0 p '� 'O O o H t 7 m
cn
r H V C
o F 2 2 2 o £ F
9 °0." n T. E E C m
> r
n �
O O O O N O N O N IJ to 00 N J J J J J N N N W O N U O O U N U ID Oo 0o U U U 0 0 0 U O 00 W O
iw N N N
O O O O O O O
N W N
O O O O
O O O O O O O 0 0 0 0
O O O p
J °
O � U
O O O o O
O O O O O O
co A O P
?o
M pp W 'U
O O O O O
� — A
�O w IJ
O O V O O
O O J
D\ N I
--
N N O N
O O O p 0 p
O O O O O O
A A
O O O O O
W
�0 IJ O
O O O O
00 0o W O A A
N N
O p
O O O O p p
0 0 0 0 0 0 o p
W
O N 1
O �
O p
A O N W
O O O O O O
A
V
0
O
A
.
O i
O i
O
O
IJ
O
O
O
O
N
O
O
J
A
O
O
N
A
O
O
N
O
O
O
A U
A
� O
O p
N
A
O
O
W
T O
O p
O
O
� rfl
n �.
A
N
O
O
N ...
A �
�
P
O O
O O
O
O
O
O
N
O
O
J
A
O
O
N
A
O
O
N
O
O
O
A U
A
� O
O p
N
A
O
O
W
T O
O p
O
O
� rfl
n �.
O
O
O
O
IP
O
O
O
O
O
O
O
F 7
O
O
IP
O
O
O
O
O
O
O
c v rn cn 9 x
n n n
m z
rn ro m W - o t -a n f7 D '`'
.� z m c 0 0 O n
z n D
m m r
-1 m
A vm :P 2 n n
9 -� m m Y > m m
D m m
;
o F N
C m
z Z
C-1 m C'1
n m
m G� r C7 (� m Y�x
m
--1
m O
O m 7o F n
�
9
z D 2
^C
�, m
Z
r D,
n<
m .�
r z
z
O� o
w
eQ a
r n , v c ,C .� -�
rn
coo
O�
'F A z D ,;�ro,u'. -'2 ' m
�!'
C
Z D d
0 O G 0O
'yy� O�
O m m
c- z
2 =
,�'� D
v r-
Y
m C j 2
�
10 m
a C7 ..3 z
M
C
'z rn zz "�
r
'9 A n
A
d
'o
"Da
z
'o z o
y
O O O O O
A O w
O p 0 0 0 0 0 0 w p 0
J O
O
O O
N P
N
O
0 0 0 0 0
O O O O
O O
0
•'V" °O Y
J O J
�
o j
N
? ?
W
r
�
O
O J
J
N
Y
J O J
• �p
O J
O� J
O O O
O J
A
U
N P
� N
w v
N
w A O
J
U w
O
DO
A W
N
J O J
O J
O O
O
J o
J
J O J
�O
O O J
0 0 0 0
oo
O
Oe
W b
`O
J iJ
N A
_
J O P
-- P
N A
N
N
O
0 O O
O O
O p 0
0 0
U In
W
O j
O
IJ
N
N
N
p 0 O
O O
O O
O O
U O O
•�
A N
• O
T P
y
A W N
+° V O
N
W
° to
p 0 O
P y 0
O O
0
O O
°
N
O
b
O� w0
.-
O O
O
W O
p 0 O
O O
0 0
O
O O
P
U O
A oo
A
U
p 0 O
O O O
O O O O O
A a
r A
J
N
N
N N
N A W
00 O b
p 0 O
�
O
O O
v
O O
A
' jJ
O
A N
p�
O
A
UO
N
N
N
W O
p 0 O
O O
O
O
O
P
A
U
Oa
A
N
O
N
u0
A N
A
N
N
W W
w O 4
J
J
U N
p b
r
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project k 01 -ERP -001
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.
ote: equipment is leased. This copier may not make it to 2011.
Justification I
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
91,800 Equipment
Total
2010 2011
2,400 13,000
Total 2,400 13,000
Total
Future
15,400
52,800
15,400
Total
Prior Funding Sources
2010
2011 2012
2013 2014 Total
Future
F - 91,800 1 Equipment Replacement Fund
2,400
13,000
15,400
52,800
Total Total
2,400
13,000
15,400
Total
2012 2013 2014
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -002
Project Name City Hall Small Copy Machine
Type Equipment Department Community services
Useful Life 5 years Contact City Clerk
Category Equipment Priority n/a
Future
Description I Total Project cost: 5144,500
Coyy machine to service needs of all departments located at City Hall.
1, Variety of copying tasks.
2. High volume product copier.
ote: This is a Ricoh color copier.
Justification
Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports,
council reports and updates, city code revisions, various department reports, and hearing and information notices.
Machine will duplex, sort, collate and staple copies.
Budget Impact/Other
Variance from 20 year plan - Cost reduced $6,900 due to pricing reductions.
Estimate salvage /resale value on replaced item: $2,500
Prior Expenditures 2010 2011 2 2013 2014 Total Future
---- 43 - , - 20 - 0 1 Equipment 20,000 20,000 81,300
Total Total 20,000 20,000 Total
Prior Funding Sources
F --- 4 - 3,2 - 00 - 1 Equipment Replacement Fund
Total Total
2010 201 2012 2013 2 Total future
20,000 20,000 F 81,300
20,000 20,000 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project tt 01 -ERP -003
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: $217,000
The network server is the hub of the network. New computers are faster and more reliable.
Justification
Networking allows user to share information that is stored in a single location, the network server. This is more
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 2010 2011 2012 2013 2014 T ota l Future
F --- 57 - , - 0 - 00 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
2010
2011
2012
2013
2014
To
Future
57,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
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -006
Project Name Computers
Type Equipment Department City Mall Administration
Useful Life 3 -5 years Contact Finance Director /IT
Category Equipment Priority n/a
Future
Description I Total Project Cost: $870,000
Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from
individual departments to one fund.
Justification
Tools enabling staff to perform job responsibilities efficiently and effectively.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $ -0-
Prior Expenditures
F -7 2 - 7 - 0 - ,0 5 00 - 1 Equipment
Total
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
2010
2011
2012
2013
2014
Total
Future
F - 2 - 7 - 0, - 00 - 0 1
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
2010 2011 2012 2013 2014 Total Future
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -007
Project Name Engineering Printer /Scanner
Type Equipment Department Community Services
Useful Life 5 years Contact City Clerk
Category Equipment Priority n/a
Future
Description I Total Project Cost: $294,560
Printer /scanner - large format copier use in Engineering to copy blueprints, plans and large documents.
Equipment is leased.
Justification
Large document copier /scanner for use in Engineering. Also scans documents for permanent storage.
Budget Impact/Other
Variance from 20 year plan - None
Estimate salvage /resale value on replaced item: $ -0-
Prior Expenditures 2010 2011 2012
2013 2014 Total Future
34,560 I Equipment 10,000 10,000 10,000
10,000 10,000 50,000 210,000
Total Total 10,000 10,000 10,000
10,000 10,000 50,000 Total
Prior
34,560
Total
Funding Sources 2010 2011 2012 2013 2014 Total Future
Equipment Replacement Fund 10,000 10,000 10,000 10,000 10,000 50,000 210,000
Total 10,000 10,000 10,000 10,000 10,000 50,000 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 lhru 2014
Project # 01 -ERP -008
Project Name Document Management Scanner (3)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Department Community' ,erNtCeS
Contact City Clerk
Priority n/a
Total Project Cost: $143,000
Large document (11" x17 ") scanner for document management and retention as well as general administrative use.
Three scanners each replaced every three years.
One replaced in 2009, 2012, 2015....... — note we did not replace one in 2009; unit was repaired to extend the life.
One replaced in 2010, 2013, 2016.........
One replaced in 2011, 2014, 2017 .............
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 evalua each year for replacement. If scanners are working properly the 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 our
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
13,000
Total
Expenditures 2010 2011 2012 2013 2014 Total Future
Equipment 6,500 6,500 6,500 6,500 6,500 32,500 97,500
Total 6,500 6,500 6,500 6,500 6,500 32,500 Total
Prior
Funding Sources
2010
2011
2012
2013
2014
Total
Future
13,000
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
7'uesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
City of Hopkins, MN
Project # 01 -ERP -010
Project Name Election Booths
Type Equipment Department Community Services
Useful Life 20 years Contact City Clerk
Category Equipment Priority n/a
Future
Description
Total Project Cost: $6,500
Election booths
Justification
6,500
In 2008 the City replaced approximately 1/2 of the voting booths in use now. The booths we have now are over 25
years old - many of them no longer have functioning lights. Every year we have to stop using some because they have
broken parts and can no longer be used.
Budget Impact/Other
Equipment Replacement Fund
Variance from 20 year plan - new item - cost in 2008 - $6,400 for 1/2 of the booths. Cost in 2009 - $6,500 for 1/2 of the
booths. Move out to 2010.
Estimate salvage/resale value on replaced item: $ -0-
Expenditures
2010 2011
2012 2013 2014 Total
Equipment
6,500
6,500
Total
Funding Sources
6,500
2010 2011
6,500
2012 2013 2014 Total
Equipment Replacement Fund
6,500
6,500
Total
6,500
6,500
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
City of Hopkins, MN
Project # 01 -ERP -030
Project Name Activity Center Copy Machine
Type Equipment
Useful Life Unassigned
Category Equipment
Future
Description I Total Project Cost: $56,000
Copy machine used by staff for daily operations of the Hopkins Activity Center.
Justification
- opyflyers, letters, forms, informational items, etc.
Budget Impactlottter
Variance from 20 year plan - None
Estimate salvage /resale value on replaced item: $
Department Actrvny �-enter
Contact Facilities Director
Priority n/a
Expenditures 2010 2011 2012 2013 2014 Total Future
Equipment 15,000 15,000 41,000
Total 15,000 15,000 't'otaI
Funding Sources
Equipment Replacement Fund
Total
2010 2 2012 201 2014
15,000
15,000
Total
Future
41,000
15,000
15,000
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -103
Project Name Duty Chief Vehicle
Type Equipment
Useful Life 5 years
Category Vehicles
Future
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $212,300
A marked passenger vehicle for use by the Duty Chief in transporting required equipment, reference materials and
personnel for emergency response, and routine Fire Department business.
Justification
Jsed by the Fire Chief when responding to fires and other emergencies. Used for official business in and out of the city
ind for fire fighter travel on official Fire Department business.
3oing to 3 year rotation will replace current used squad car that ends up costing us more money in repairs. Each car
xill be cycled down and older sauad will be replaced.
Budget Impact/Other
Variance from 20 year plan - Change from 7 year life to 3 years. Add vehicle rotation in 2009.
Estimate salvage /resale value on replaced item: $4,000
Prior
28,100
Total
Expenditures 2010 2011 2012 2013 2014 Total Future
Vehicles 36,400 36,400 147,800
Total 36,400 36,400 Total
Prior. Funding Sources
2010 2011
2012 2013 2014 Total
Future
28,100 Equipment Replacement Fund
36,400
36,400
147,800
Total Total
36,400
36,400
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -106
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: 8987,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.
Justification
Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using
$445,427.08 in ERP cash and a 10 -year capital lease of $425,000. At the end of the lease term payments (P &I) will
total $542,170. Total costs of aerial including cash payments equals $987,597.
Budget Impact/Other
Variance from 20 year plan - .Lease payments on financing added to the plan.
Estimate salvage /resale value on replaced item: $
Prior
Expenditures
2010
2011
2012
2013
2014
Total
Future
F -- 4 - 9 - 9, - 64 - 4 - 1
Equipment
54,217
54,217
54,217
54,217
54,217
271,085
1 216,868
Total
Total 54,217
54,217
54,217
54,217
54,217
271,085
total
Prior Funding Sources
499,644 Bonds /Lease
Total
2010 2011 2012 2013 2014 Total Future
54,217 54,217 54,217 54,217 54,217 271,085 216,868
Total 54,217 54,217 54,217 54,217 54,2 271,085 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkin M
2010 thru 2014
Project # 01 -ER -109
Project Name Extrication Tool (2)
Type Equipment
Useful Life 10 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Description I Total Project Cost: $154,100
Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram.
Justification I
All vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool wil be
added to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cc
Budget Impact/Other
Variance from 20 year plan - move back from 2015 to 2019.
Estimate salvage /resale value on replaced item: $1,000
Prior Expenditures
20,300 Equipment
Total
26,500 26,500 107300
Total 26,500 26,500 Total
Prior Funding Sources 2010
2011 2012 2013
2014 Total
Future
F - 20,300 1 Equipment Replacement Fund
26,500
26,500
107,300
Total Total
26,500
26,500
Total
2010 2011 2012 2013 2014 Total Future
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -110
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
Justification
- opying business papers, training records, etc.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $500
Prior Expenditures 2010 2011 2012 2013 2014 Total Future
7 Equipment 10,300 1 0,300 29,700
Total Total 10,300 10,300 Total
Prior
Funding Sources 2010
2011 2012
2013 2 T
Future
7,400
Equipment Replacement Fund
10,300
10,300
29,700
Total
Total
10,300
10,300
'Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thm 2014
Project # 01 -ERP -112
Project Name Thermal Imaging Camera (2)
"Type Equipment
Useful Life 10 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority Na
Description
Total Project Cost: $104,600
Used by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and
heat may be hidden allowing for faster extinguishment.
Note: purchased 2003 & 2007
Justification
18,000
Current camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was
purchased with donation money.
Budget Impact/Other
18,000
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 re alced item: $ -0-
Prior Expenditures 2010 2011
2012 2013 2014
Total
Future
F - 15,0001 Equipment
18,000
18,000
71,600
Total Total
18,000
18,000
Total
Prior
Funding Sources 2010 2011
2012 2013 2014
Total
Future
15,0001
Total
Equipment Replacement Fund
Total
18,000
18,000
18,000
18,000
71,600
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 rhru 2014
City of Hopkins, MN
Project # 01 -ERP -116
Project Name workout Equipment - Eliptical
Type Equipment Department Fire
Useful Life 6 years Contact Fire Chief
Category Equipment Priority n/a
Future
Description Total Project Cost: s37,800
Workout equipment used in Fire Department workout room. Two eliptical machines replaced on a 6 year cycle, one
every 3 years.
1 2012- replace eliptical
2015 replace eliptical
Justification
This equipment is available to all City employees for health and wellness.
Budget impact/Other
Variance from 20 year plan - remove $5,000 in 2009 and use for dumb bells.
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011
2012 2013
2014 Total
Future
Equipment
5,000
5,000
32,800
Total
Funding Sources 2010 2011
5,000
2012 2013
5,000
2014 Total
Total
Future
Equipment Replacement Fund
5,000
5,000
I F 32,800
Total
5,000
5,000
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -117
Project Name workout Equipment - Stairma
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Description
Total Project Cost: $25,300
Workout equipment used in Fire Department workout room.
One stairmaster replaced on a 5 year cycle.
Justification
Equipment Replacement Fund
This equipment is available to all City employees for health and wellness.
Budget Impact/Other
20,300
Variance from 20 year plan - new item - Originally purchased with grant funds.
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total Future
Equipment 5,000 5,000 20,300
Total 5,000 5,000 Total
Funding Sources
2010 2011
2012 2013 2014 Total
Future
Equipment Replacement Fund
5,000
5,000
20,300
Total
5,000
5,000
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -118
Project Name workout Equipment -Treadmill
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: 525,300
Workout equipment used in the Fire Department workout room.
One treadmill replaced on a 5 year cycle.
2010 thru 2014
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 2010 2011 2012 2013 2014 Total Future
Equipment 5,000 5,000 20,300
Total
5,000 5,000 'Total
Funding Sources 2010
Equipment Replacement Fund
2011 2012 2013
5,000
2014 Total
5,000
Future
20,300
Total
5,000
5,000
Total
Tuesday, July 07, 2009
. EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -120
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: $60,200
Defibrillator is used to help get someones heart restarted during a cardiac arrest.
Own 2 - both are replaced at one time due to changing technology.
Justification
The current AED are not in the ERP. With changes in technology, they should be replaced every three years.
Cost - $3,000 per unit
Budget Impact/Other
Variance from 20 year plan - new item. Not previously included in ERP. 2007 replaced with fire department funds.
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total Future
Equipment 6,000 7,200 13,200 47,000
Total 6,000 7,200 13,200 Total
Funding Sources 2010 2011
2012 2013 2014
Total
Future
Equipment Replacement Fund 6,000
7,200
13,200
47,000
Total 6,000
7,200
13,200
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 rhY„ 2014
City of Hopkins, MN
Project # 01 -ERP -121
Project Name Quick Attack Pumper /Rescue
Type Equipment
Useful Life 25 years
Category Vehicles
Future
attack pumper /rescue.
Department Fire
Contact Fire Chief
Priority n/a
Total Project Cost: $234,000
Justification
Would replace Rescue 8 (lite rescue) and use as a utility vehicle. This truck could be used for daytime and nighttime
medicals and small fires. This will reduce having all personnel respond to small fires. It will also let us drop one
engine in 2022 but still keep ISO rating.
Budget Impact/Other
Variance from 20 year plan - new item.
Estimate salvage /resale value on replaced item: $
Expenditures 2010 20 2 2013 2 Total
Vehicles 234,000 234,000
Total 234,000 234,000
Funding Sources 2010 2011 2012 2013 2014 Total
Equipment Replacement Fund 234,000 234,000
Total 234,000 234,000
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project# 01 -ERP -122
Project Name workout Equipment -Dumb Bells
I ype tquipment
Useful Life 10 years
Category Equipment
Future
Department Fire
Contact Fire Chief
Priority n/a
Description
Total Project Cost: $11,700
Workout equipment used in Fire Department workout room.
Justification
Equipment Replacement Fund
Instead of replacing eliptical machine in 2009 - would replace dumb bell. They are used by all City employees and are
15 years old. They are also covered with lead paint that could be harmful.
Budget Impact/Other
6,700
Variance from 20 year plan - new item. Move back from 2009 to 2012.
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total Future
Equipment 5,000 5,000 6,700
Total 5,000 5,000 Total
Funding Sources 2010 2011
2012 2013
2014 Total
Future
Equipment Replacement Fund
5,000
5,000
6,700
Total
5,000
5,000
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 rhru 2014
City of Hopkins, MN
Project # 01 -ERP -200
Project name Marked Patrol Vehicles (6)
Type Equipment Department Police
Useful Life 3 years Contact Police Chief
Category Vehicles Priority n/a
Future
Description Total Project Cost: $2,256,500
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.
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 - 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 2010 2011 2012 2013 2014 Total Future
505,300 Vehicles 65,200 67,200 69,200 71,200 73,400 346,200 1,405,000
Total Total 65,200 67,200 69,200 71,200 73,400 346,200 Total
Prior Funding Sources 2010 2011 2012 2013 2014 Total Future
5 - 0 - 5 — ,3 - 0 - 01 Equipment Replacement Fund 65,200 67,200 69,200 71,200 73,400 346,200 1,405,000
Total Total 65,200 67,200 69,200 71,200 73,400 346,200 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
E PP,roo,icct ect # 01 -ERP -201
Name Sergeant's Vehicle
Type Equipment
Useful Life 4 years
Category Vehicles
Future
Department Police
Contact Police Chief
Priority n/a
Description
Total Project Cost: $215,700
Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
4 year rotation.
Justification
33,600
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 - move purchase of sergeant's squad back to 2011. Purchased new in 2007.
Estimate salvage /resale value on replaced item: $3,500 each
Expenditures 2010 2011 2012 2013 2014 Total Future
Vehicles
Funding Sources
equipment Keplacement Fund
Total
Total
Future
33,600
182,100
33,600
Total
33,600 33,600 182,100
Total 33,600 33,600 Total
2010 2011 2012 2013 2014
33,600
33,600
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -203
Project Name Utility 4x4 (unit 212)
Type Equipment
Useful Life 6 years
Category Vehicles
Future
Description
4 wheel drive uitlity vehicle.
Department Police
Contact Police Chief
Priority n/a
Total Project Cost: $247,600
2010 thru 2014
Justification I -
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 2010 2011 2012 2013 2014 Total Future
fi7,400 Vehicles 47,700 47,700 132 ,500
Total Total 47,700 47,700 Total
Prior Funding Sources 2010 2011 2012 2013 2014 Total Future
67,400 Equipment Replacement Fund 47,700 47,700 132,500
Total Total
47,700 47,700 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -204
Project Name police Administrative Vehicles (2)
Type Equipment
Useful Life 2 years
Category Vehicles
Future
Department Police
Contact Police Chief
Priority n/a
Description
Total Project Cost: $913,900
Police administrative and detective vehicles.
Replace Chiefs vehicle - even numbered years
Replace Captain's vehicle - odd numbered years
Justification
Total
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
28,800
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $4,000 each
Prior Expenditures
2010
2011
2012
2013
2014
Total
Future
185,300 Vehicles
27,100
27,900
28,800
29,600
30,500
143,900
584,700
Total
Total 27,100
27,900
28,800
29,600
30,500
143,900
Total
Prior Funding Sources
2010
2011
2012
2013
2014
Total
Future
185,300 1 Equipment Replacement Fund
27,100
27,900
28,800
29,600
30,500
143,900
584,700
Total Total
27,100
27,900
28,800
29,600
30,500
143,900
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
Project # 01 -ERP -209
Project Name Copy Machine
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n/a
2010 thru 2014
Description rotal Project Cost: 5127,200
Police Department copy machine capable of producing double side copies and collating pages.
Justification
Jsed to make duplicate copies of reports, letters, memos, etc., generated by police personnel.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $1,000
Prior Expenditures
307700 Equipment
Total
Prior Funding Sources
30,700 Equipment Replacei
Total
2010 2011 2 012 2013 2 T Future
19,100 19,1UU L 11,4UU'
Total
19,100 19,100 Total
2010 2011 2012 2013 2014 Total Future
Fund 19,100 19,100 F . 77,400
Total 19,100 19,100 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -210
Project Name Logging Recorder
Type Equipment
Useful Life 7 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n/a
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.
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 2010 2011 2012 2013 2014 Total Future
Equipment 36,900 36,900 101,200
Total 36,900 36,900 Total
Funding Sources 2010 2011
2012 2013 2014
Total
Future
Equipment Replacement Fund
Total
36,900
36,900
36,900
36,900
101,200
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 rh,,, 2014
City of Hopkins, MN
Project # 01 -ERP -211
Project Name Network Server (3)
Type Equipment
Useful Life 3 years
Category Equipment
Future
Department Police
Contact Police Chief'/11'
Priority n/a
Description I Total Project Cost: 5229,500
Computer servers store information and system programs.
One server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01 -ERP -213)
Justification
Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use
programs while older servers used for data storage.
Budget Impact/Other
Variance from 20 year plan - Cost stabilized at $8,500 per year.
Estimate salvage /resale value on replaced item - $
Prior Expenditures
F --- 5 - 9 — ,50 - 0 - 1 Equipment
Total
2 2011 2012
8,500 8,500 8,500
Total 8,500 8,500 8,500
Prior
Funding Sources
2010
2011
2012
2013
2014
Total
Future
F --- 5 - 9, - 5 - 0 - 01
Equipment Replacement Fund
8,500
8,500
8,500
8,500
8,500
42,500
1 127,500
Total
Total
8,500
8,500
8,500
8,500
8,500
42,500
'Total
20
2014
8,500
8,500
8,500
8,500
Tota
Future
42,500
127,500
42,500
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -212
Project Name Mobile Data Computers
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n/a
Description I Total Project Cost: $297,800
Mobile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various
databases, communicate car to car.
Justification I
imited 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-
Prior Expenditures
47,000 I Equipment
Total
62,700 62,700 188,100
Total 62,700 62,700 Total
Prior Funding Sources 2010 2011
2012 2013
2014 Total
Future
F - 47,666 1 Equipment Replacement Fund
62,700
62,700
188,100
Total Total
62,700
62,700
Total
2010 2011 2012 2013 2014 Total Future
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 rh,-u 2014
City of Hopkins, MN
Project a 01 -ERP -213
Project Name Digital Squad Car Cameras
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n/a
Description I Total Project Cost: 5213,000
Digital video camera system in each marked patrol car - used to document events in and out of the patrol car. Images
downloaded to server for storage and retrieval.
Justification
Police Dept. currently has eight digital camera units installed and a dedicated server. The life expectancy of the
cameras is about five years. Current cameras were installed in September 2006.
Cost: 8 cameras @ $5,000 per unit plus tax - $42,600
1 server @ $15,000 (to be purchased from Police Network Server (01- ERP -21 1)
annual allocation that carries forward.
Estimated cost $57,600. Cost could be lower if, at the time of replacement, a suitable product is available through a
State or County equipment bid.
Budget Impact/Other
Variance from 20 year plan - Purchase of squad cameras scheduled in 2011 moved to 2009 due to continued equipment
failure. Replacement schedule life is 5 years.
Estimate salvage/resale value on replaced item: $
Prior Expenditures 2010 2011 2012 2013 2014 Total Future
42,600 Equipment 42,600 42,600 127,800
Total Total 42,600 42,600 Total
Prior
Funding Sources 2010 2011
2012 2013 2014
Total
Future
F --- 4 - 2 - ,6 - 00 - 1
Equipment Replacement Fund
42,600
42,600
F 127,800
Total
Total
42,600
42,600
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -214
Project Name Tactical Ballistic Vests
Type Equipment
Useful Life 5 years
Category Equipment
Future
Department Police
Contact Police Chief
Priority n/a
Description
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
23,200
23,200
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
23,200
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 2010 2011
2012 2013 2014
Total
Future
20,000 1 Equipment
Total Total
23,200
23,200
23,200
23,200
94,300
Total
Prior
Funding Sources 2010 2011
2012 2013 2014
Total
Future
20,000 1
Equipment Replacement Fund
23,200
23,200
94,300
Total
Total
23,200
23,200
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
Citv of Hopkins. MN
2010 thru 2014
Project # 01 -ERP -215
Project Name Radios - Portable and Mobile Devices
Type Equipment Department eouce
Useful Life Contact Police Chien
Category Equipment Priority n/a
Future
Description I Total Project Cost: x270,000
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 32 10 107
Mobile 17 8 0 25
Justification
Provides radios so that the police, fire and public works can communicate on a common radio frequency during an
Budget Impact/Other
Variance from 20 year plan - added replacement cost at $15,000 per year fixed, starting in 2012. Do not expect all 132
radios to need replacing at one time.
Estimate salvage /resale value on replaced item: $
Expenditures 2010
2011 2012
2013
2014
Total
Future
Equipment
15,000
15,000
15,000
45,000
225,000
Total
15,000
15,000
15,000
45,000
Total
Funding Sources 2010 2011
2012
2013
2014
Total
Future
Equipment Replacement Fund
15,000
15,000
15,000
45,000
225,000
Total
15,000
15,000
15,000
45,000
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project s 01 -ERP -301
Project Name 4X4 3/4 Ton Truck with Plow
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: $92,900
3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers.
Justification
Future
Light hauling, pulling trailers, transportation to and from job sites.
Budget Impact/Other
30,400
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $1,500
Prior
24,000
Total
Expenditures 2010 2011 2012 2013 2014 Total Future
Vehicles 30,400 30,400 1 38,500
Total 30,400 30,400 Total
Prior
Funding Sources 2010 2011
2012 2013 2014
Total
Future
24,000 1
Equipment Replacement Fund
30,400
30,400
38,500
Total
Total
30,400
30,400
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 rhru 2014
City of Hopkins. MN
Project # 01 -ERP -303
Project Name 1 Ton Dump Truck (2)
Type Equipment Department t-uonc worts. oucowi
Useful Life 12 years Contact Public Works Dircctor
Category Vehicles Priority n/a
Future
Description Total Project Cost: $205,5011
Truck is used in the Street Division of Public Works.
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 2010 2011 2012 2013 2014 Total Future
F -- 30 — ,50 - 01 Vehicles 37,400 34,700 72,100 102,900
Total Total 37,400 34,700 72,100 Total
Prior Funding Sources
F --- 3 - o, - 50 - o l Equipment Replacement Fund
Total Total
37,400
37,400
2011 2012 2013 2014
34,700
34,700
Total
Future
7 102,900
72,100
72,100
Total
2010
Tuesday, July 07, 2009
_ EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project P 01 -ERP -304
Project Name 1 Ton Traffic Boom Truck
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: $199,000
Boom truck used in Street and Traffic Divisions of Public Works.
Justification
Equipment Replacement Fund
Vehicle used by Traffic Department for signal and light pole maintenance.
Budget Impact/Other
124,000
Variance from 20 year plan - None
Estimate salvage /resale value on replaced item: $8,000
Expenditures 2010 2011 2012 2013 2014 Total Future
Vehicles 75,000 75,000 124,000
Total 75,000 75,000 Total
Funding Sources 2010
2011 2012 2013
2014 Total
Future
Equipment Replacement Fund
75,000
75,000
124,000
Total
75,000
75,000
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
City of Hopkins, MN
Project # 01 -ERP -306
ProjectName Tandem Dump Trucks (2)
Type Equipment Department VuMic works: JHCCLsl uaiiw
2011 2012 2013 2014
132,300
Useful Life 17 years Contact Public Works Director
Future
142,400
Category Vehicles' Priority n/a
132,300
Future
'Total
Description Total Project Cost: $274,700
Dump trucks used in Streets Division of Public Works.
Justification
Trucks used for heavy hauling, snow plowing and sanding.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $ -0-
Expenditures 2010 2011 2012 2013 2014
Total Future
132,300
132,300 142,400
Vehicles
Total 132,300
132,300 Total
Funding Sources 2010
Equipment Replacement Fund
2011 2012 2013 2014
132,300
Total
132,300
Future
142,400
Total
132,300
132,300
'Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
3roject # 01 -ERP -307
'roject Name water Truck
Type Equipment Department Public Works: Streets/Traffic
Useful Life 22 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: $195,000
Water truck used in Streets and Parks Division of Public Works.
Justifi
(Used for street flushing, watering trees and plants, rink flooding and standby fire protection.
Budget Imp act / Ot h er I
Variance from 20 year plan - replace tanker only in 2010 - replace tanker, cab & chassis in 2017, tanker only again in
2032 and entire vehicle in 2039. Change to a 22 year life.
Estimate salvage /resale value on replaced item: $8,500
Expenditures 2010 2011 2 012 2013 2014 Total Future
V ehic l es
Funding Sources
Equipment Replacement Fund
Total
2010 2011 2012 2013 2014
45,000
45,000
45,000 45,000 150,000
Total 45,000 45,000 Total
Total
Future
45,000
150,000
45,000
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
City of Hopkins, MN
Project # 01 -ERP -308
Project Name Front End Loaders (2)
Type Equipment
Useful Life 15 -18 years
Category Equipment
Future
Description
Justification
Budget Impact/Other
Department Public Works: Streets/ Iraltic
Contact Public Works Director
Priority n/a
Total Project Cost: 5530,100
Variance from 20 year plan - None
Estimate salvage /resale value on replaced item: $
Prior Expenditures 2010 2011 2012 2013 2014 Total Future
140,000 Equipment 172,000 172,000 F . 218,100
Total Total 172,000 17 Total
Prior
Funding Sources 2010
2011 2012 2013
2014 Total
Future
140,000
Equipment Replacement Fund
172,000
172,000
218,100
Total
Total
172,000
172,000
Total
7'uesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
'roject # 01 -ER -309
'roject Name Skid Loader (2)
Type Equipment Department Public Works: Streets/Traffic
Useful Life 12 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $188,900
Loading trucks, landscape work, snow removal, material handling.
Justification
Budget Impact/Other
Variance from 20 year plan - increase cost by $5,000 to reflect actual.
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total Future
Equipment 36,000 36,000 1527900
Total 36,000 36,000 Total
Funding Sources 2010 2011 2012 2013 2014 Total Future
Equipment Replacement Fund 36,000 36,000 152,900
Total 36,000 36,000 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
City of Hopkins, MN
Project a 01 -ERP -311
Project Name Sweeper
Type Equipment Department aubuc works. -)meets / i raiuc
Useful Life 12 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $514,400
Street sweeper used by Streets Division for sweeping streets and parking lots.
Justification
Street sweeping, event clean -up, spring sand removal.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $12,000
Prior Expenditures 2010 2011 2012 2013 2014 Total Future
115,300 Equipment 164,500 164,500 234,600
Total Total 164,500 164,500 Total
Prior
Funding Sources 2010 2011
2012 2013 2014
Total
Future
115,300
Equipment Replacement Fund
164,500
164,500
234,600
Total.
Total
164,500
164,500
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project P 01 -ERP -312
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
Total Project Cost: $45,900
Used by Street Department for asphalt repair and resurfacing.
Justification
Budget Impact/Other
Variance from 20 year plan - None
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total
Equipment 45,900 45,900
Total 45,900 45,900
Funding Sources 2 010 2011 201 2013 2014 Total
equipment Replacement Fund 45,900 45,900
Total 45,900 45,900
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 Ihru 2014
City of Hopkins, MN
Project # 01 -ERP -314
Project Name Asphalt Paver
Type Equipment Department tluhiic worn: arrecrsi ua,Hw
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description Total Project Cost: $48,8110
ksphalt paver used by Streets Division of Public Works.
Justification
?aving streets and parking lots.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $500
Expenditures 2010 2011 2012 2013 2014 Total
Equipment 48,800 48,800
Total 48,800 48,800
Funding Sources 2010 2011 2012 2013 2014 Total
Equipment Replacement Fund 48,800 48,800
Total 48,800 48,800
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
City of Hopkins, MN
Project # 01 -ERP -316
Project Name Trailer
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: $4,900
Used for transporting and hauling equipment and supplies.
Justification
Budget Impact/Other
Variance from 20 year plan - move back from 2009 to 2010
Estiamte salvage /resale value on replaced item : $
Expenditures 2010 2011 2012 2013 2014 Total
Equipment 4,900 4,900
Total 4,900 4,900
Funding Sources 2010 2011 2012 2013 2014 Total
Equipment Replacement Fund 4,900 4,900
Total 4,900 4,900
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
City of Hopkins, MN
Project # 01 -ERP -502
Project Name Backhoe Loader
Type Equipment Department Water
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
lescription I Total Project Cost: $134,800
nit utilitzed by Water, Sewer and Street Divisions of Public Works for repair and installation of underground utilities.
Justification
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total
Equipment 134,800 134,800
Total 134,800 134,800
Funding Sources 2010 2011 2012 2013 20 Total
WF - Water Fund 134,800 134,80u
Total 134,800 134,800
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -506
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
Total Project Cost: $72,600
Copy machine to service needs of all division of Public Works.
Justification
Making copies for various departments.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $800
Prior
10,600
Total
Expenditures 2010 2011 2012 2013 2014 Total Future
Equipment 12,200 12,200 49,800
Total 12,200 12,200
Total
Prior Funding Sources 2010 2011 2012 2013 2014 Total Future
10,600 WF - Water Fund 12,200 12,200 1 49,800
Total Total 12,200
12,200 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins. MN
2010 thru 2014
Project # 01 -ERP -550
Project Name 4x4 3/4 Ton Truck
Type Equipment Department �)cwer
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description Total Project Cost. $110,300
Truck used by Water /Sewer Division of Public Works.
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 2010 2011 2012 2013 2014 Total Future
F --- 26 — ,6 - 0 - 01 Vehicles 35,700 35,700 48,000
Total Total 35,700 35,700 Total
Prior Funding Sources 2010 2011 2012 2013 2014 Total Future
26,600 SF - Sanitary Sewer Fund 35,700 35,700 I F 48,000
Total Total 35,700 35,700 Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -700
Project Name Engineering Van
Type Equipment Department Public Works: Engineering
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description
Total Project Cost: $66,400
Van used by Engineering Department for survey equipment and on job site work.
Justification
Future
Transportation to and from job site, hauling of surveying and traffic counting equipment.
Budget Impact/Other
21,500
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
21,500 21,500 28,900
Total 21,500 21,500 Total
Prior
Funding Sources 2010 2011
2012 2013 2014
Total
Future
16,000 1
Equipment Replacement Fund
21,500
21,500
F____2_8_ ,900
Total
Total
21,500
21,500
Total
20 2011 2012 2013 2014 Total Future
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 rh, -u 2014
City of Hopkins, NVIN
r -
Project # 01 -ERP -800
Project Name 1/2 Ton Pickup Truck
Type Equipment Department ruunc worn. rdmn /Y "—"Y
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description 'rotal Project Cost: $61,800
Pickup used by Park Division of Public Works.
Justification
Budget Impactlother
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total Future
Vehicles 26,400 26,400 35,400
Total 26,400 26,400 Total
Funding Sources
Equipment Replacement Fund
Total
2010 2011 2012 2013 2014
26,400
26,400
Total
Future
35,400
26,400
26,400
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -801
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
Total Project Cost: $313,800
Trucks used by Parks Division of Public Works.
Justification
Future
Snow plowing, hauling, transportation. Units are heavily used.
Budget Impact/Other
67,400
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $
Prior
53,200
Total
Expenditures 2010 2011 2012 2013 2014 Total Future
Vehicles 67,400 67,400 193,200
Total 67,400 67,400 'Total
Prior
Funding Sources 2010
2011 2012 2013
2014 Total
Future
53,200 1
Equipment Replacement Fund
67,400
67,400
1 193,200
Total
Total
67,400
67,400
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thr,, 2014
rite of Hop kins. MN
Project # 01 -ERP -802
Project Name 3/4 Ton Utility Truck
Type Equipment Department ruonc "UIKa' , o, �' . '. a - ,
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description I Total Project Cost: 575,600
3/4 ton truck with utility body used for transporting tools and equipment for repair of various building Irrigation, etc.
around the city.
Justification
Budget Impact/Other
Variance from 20 year plan - move back from 2010 to 2011.
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total Future
Vehicles 32,200 32,200 43,400
Total 32,200 32,200 Total
Funding Sources 2010
Equipment Replacement Fund
2011 2012
32,200
2013 2014 Total
32,200
Future
43,400
Total
32,200
32,200
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -803
Project Name Swap Loader
Type Equipment Department Refuse
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description
Total Project Cost: $80,000
Single axle truck with a slide rail system used to swap between various boxes and bodies. Utilitized by Refuse for
hauling dumpsters and Forestry for chipping trees.
Justification
Budget Impact/Other
Variance from 20 year plan - move to 20 yr life; move from 2008 to 2010 with all costs to Refuse Fund..
Estimate salvage /resale value on replaced item: $
Expenditures 2010 2011 2012 2013 2014 Total
Equipment 80,000 80,000
Total 80,000 80,000
Funding Sources 2010 2011 2012 2013 2014 Total
RF - Refuse Fund 80,000 80,000
Total 80,000 80,000
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 lhrt, 2014
rity of Hopkins. MN
Project # 01 -ERP -806
Project Name Tractors (2)
Type Equipment ueparrment ruimi
Useful Life 30 years Contact Public Works Director
Category Equipment Priority n/a
Future
Descr Total Project Cost: 587,900
Farm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration,
plowing and grass seeding.
Item purchased: 1982 & 1984
Justification
Budget Impact/Other
Variance from 20 year plan - move from 2009 to 2012.
Estimate salvage /resale value on replaced item: $3,500
Expenditures 2 2011
Total
201 2013
2014
Total
41,400
46,500
87,900
41,40
46,500
87,900
Funding Sources 2010 2011 2012 2013 2014 Total
Equipment Replacement Fund 41,400 46,500 87,900
Total 41,400 46,500 87,900
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -807
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
Total Project Cost: $114,700
Truckster used by Parks Division of Public Works for ballfield and parks maintenance.
Justification
Future
Park maintenance, ballfield grooming and weed spraying.
Budget Impact/Other
19,800
Variance from 20 year plan - None
Estimate salvage /resale value on replaced item: $1,400 each
Prior Expenditures
29,900 1 Equipment
Total
19,800 19,800 65,000
Total 19,800 19,800 Total
Prior
Funding Sources 2010
2011 2012 2013
2014 Total
Future
29,9001
Equipment Replacement Fund
19,800
19,800
F 65,000
Total
Total
19,800
19,800
Total
2010 2011 2012 2013 2014 Total Future
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
City of Hopkins, MN
Project # 01 -ERP -808
Project Name Riding Mowers (3)
Type Equipment Department Public Works: Parks /Forestry
Useful Life 8 years Contact Public Works Director
Category Equipment Priority n/a
Future
Descr Total Project Cost: 5223,100
Riding mowers used by Parks Divlson of Public Works. One mower also used for sidewalk snow removal during
winter months.
Justification
Mowing city parks and right of ways and sidewalk snow removal.
Budget Impacttother
Variance from 20 year plan - move from 2009 to 2011
Estimate salvage /resale value on replaced item: $600 each
Prior Expenditures 2010 2011 2012 2013 2014 Total Future
49,000 Equipment 22,800 10,300 20,300 53,400 120,700
Total Total 22,800 10,300 20,300 53,400 'I otal
Prior Funding Sources 2010 2011 2012 2013 2014 Total Future
49,000 Equipment Replacement Fund 22,800 10,300 20,300 53,400 120,700
Total Total 22,800 10,300 20,300 53,400 'Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -810
Project Name Large Turf Mower
Type Equipment Department Public Works: Parks /Forestry
Useful Life 10 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description
Total Project Cost: $207,700
Large turf mower (11' cutting width) used by Parks Division of Public Works.
Justification
50, 001 Equipment Replacement Fund
Required to efficiently mow large parks.
Budget Impact/Other
f ----- 9 - 2 7700
Variance from 20 year plan - move from 2011 to 2010 due to poor condition of existing mower..
Estimate salvage /resale value on replaced item: $3,500
Prior Expenditures
50,000 1 Equipment
Total
65,000 65,000 92,700
Total 65,000 65,000
Total
Prior Funding Sources
2010 2011
2012 2013 2014 Total
Future
50, 001 Equipment Replacement Fund
65,000
65,000
f ----- 9 - 2 7700
Total Total
65,000
65,000
Total
2010 2011 2012 2013 2014 Total Future
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thru 2014
inky of Hopkins. MN
-- -J -- - - -Jr
Project a 01 -ERP -813
Project Name Brush Chipper
Type Equipment Department ruouc --. 1 ., , iY
Useful Life 20 years Contact Public Works Director
Category Equipment Priority n/a
Future
Description Total Project Cost: 525,700
Brush chipper used for Forestry and brush pick up operations of Public Works.
Justification
Budget Impact/Mer
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 2010 2011 2012 2013 2014 Total
Eauipment 25,700 25,700
Total 25,700 25,700
Funding Sources 2010 2011 2012 2013 2014 Total
Equipment Replacement Fund 25,700 25,700
Total 25,700 25,700
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project # 01 -ERP -900
Project Name Refuse Truck (RAP -R) (2)
Type Equipment Department Refuse
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description
Total Project Cost: $1,059,300
Refuse truck used by Refuse Utility Division of Public Works.
Justification
148,000 RF - Refuse Fund
Total Total
Residential waste pick up.
Budget Impact/Other
727,300
Total
Variance from 20 year plan - increase cost to reflect actual
Estimate salvage /resale value on replaced item: $18,000
Prior Expenditures
148,000 Vehicles
Total
184, 184,000 727,300
Total 184,000 184,000 Total
Prior Funding Sources
2010 2011
2012 2013 2014 Total
Future
148,000 RF - Refuse Fund
Total Total
184,000
184,000
184,000
184,000
727,300
Total
2010 2011 2012 2013 2014 Total Future
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 thrar 2014
City of Hopkins, MN
Project # 01 -ERP -901
Project Name Refuse Truck (Rea r -L)
Type Equipment Department Refuse
Useful Life 10 years Contact Public Works Director
Category Vehicles Priority n/a
Future
Description Total Project Cost: 8238,200
Refuse truck used by Refuse Utility Division of Public Works.
Justification
Residential waste pick up.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage /resale value on replaced item: $9,000
Expenditures 2010 2011 2012 2013 2014 Total future
Vehicles 101,600 101,600 136,600
Total 101,600 101,600 Total
Fundinit Sourc
RF - Refuse Fund
2010 2011 2012 2013 2014
101,600
Total _ 101,600
Total
Future
136,600
101,600
101,600
Total
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
2010 thru 2014
Project tl 01 -ERP -1000
Project Name Ice Resurfacer
Type Equipment Department Pavilion
Useful Life 12 years Contact Facilities Director
Category Equipment Priority n/a
Future
Description
Total Project Cost: $273,700
Ice resurfacer used by the Pavilion for ice sheet maintenance.
Justification
60,000 1 PA - Pavilion Fund
Ice maintenance, ice removal and resurfacing of ice sheet during the indoor ice season.
Budget Impact/Other
125,600
Variance from 20 year plan - new item
Estimate salvage /resale value on replaced item: $20,000
Prior Expenditures
60,000 Equipment
Total
88,100 88,100 125,600
Total 88,100 88,100 Total
Prior Funding Sources 2010
2011 2012 2013 2014
Total
Future
60,000 1 PA - Pavilion Fund
88,100
88,100
125,600
Total Total
88,100
88,100
Total
2010 2011 2012 2013 2014 Total Future
Tuesday, July 07, 2009
EQUIPMENT REPLACEMENT PLAN 2010 rhru 2014
City of Hopkins, MN
Project # 01 -ERP -1100
Project Name Arts Center Copy Machine
Type Equipment Department Arts (enter
Useful Life 7 years Contact Facilities Director
Category Equipment Priority n/a
Future
Description I Total Project Cost: $53,800
Copy machine capable of enlarging and producing double sided, collated and stapled copies.
Justification
Used to duplicate reports, letters, signs, flyers and rental information.
Budget Impact/Other
Variance from 20 year plan - increase by $2,000 to reflect actual cost.
Estimate salvage /resale value on replaced item: $
Prior Expenditures 2010 2011 2012 2013 2014 Total Future
8500 Equipment 12,100 12,100 33,200
Total Total 12,100 12,100 Total
Prior Funding Sources
8,500 HCA - Arts Center Fund
Total Total
2010 2011 2012 2013 2014
12,100
12.100
Total
Future
12,100
33,200
12,100
Total
Tuesday, July 07, 2009