VII.4. 2017-2021 Equipment Replacement Plan; Harkess (CR2016-119)
December 6, 2016 Council Report 2016-119
2017-2021 EQUIPMENT REPLACEMENT PLAN
Proposed Action
Staff recommends adoption of the following motion: Move to adopt the 2017-2021 Equipment Replacement
Plan.
Overview
The equipment replacement plan is a detailed summary of the next five years of a twenty-year replacement
schedule, for equipment of the City of Hopkins. General and Special Revenue fund equipment items are
placed in the Equipment Replacement Fund budget which derives its revenues from service charges to the
General and Special Revenue funds, equipment sales and interest earnings. The Art Center and Enterprise
fund equipment in the plan is placed in the individual fund budgets, in the year in which the equipment is to
be purchased.
Approval of the 2017-2021 allows staff to incorporate the 2017 ERP items into the 2017 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
2017-2021 ERP Power Point slides
2017-2021 Equipment Replacement Plan
______________________________________
Christine M. Harkess, CPA, CGFM
Finance Director
Financial Impact: $ as provided in plan Budgeted: Y/N X N Source: Various
Related Documents (CIP, ERP, etc.): __ERP_________ Notes: ____________________
11/21/2016
1
Equipment Replacement Plan
2017-2021
City PresentationERP Background
• The city has established an equipment replacement plan that is
reviewed and adjusted on an annual basis.
• The purpose of the plan was to smooth out the funding of large
pieces of equipment. In the past this allowed the City to avoid
bonding for purchases thereby saving interest costs.
• Equipment certificates were sold in 2016 to fund equipment needs
in 2016 and 2017.
11/21/2016
2
City PresentationFunding ERP
• The cost of equipment is allocated back to the user departments
based on life expectancy and cost of the equipment.
• A 9% increase to the charge is planned for 2017.
• Impact of increase to the General Fund is $30,000
• Increases in the charge are planned for future years
• Bond Issue planned for 2018
• Staff continues to apply for grants as they become available
City PresentationERP Future
• Revenues in the Equipment Replacement fund are derived from
charges to city departments that use the equipment – mainly the
General Fund.
• Cash flow projections are updated annually to ensure adequate
funds for scheduled replacements.
• Funding challenges are foreseen in the future and alternative
options have been explored.
– Equipment Certificates most likely will be sold in 2018
11/21/2016
3
City Presentation2017 ERP
• In 2017 the city is planning on leasing, replacing or
upgrading vehicles and equipment for several
departments.
– The leased items were placed in the operating budgets
• All vehicles and equipment are reviewed annually and
useful lives adjusted while maintaining the integrity,
reliability and safety of the vehicles, equipment and
employees.
• Purchases are made based upon the condition of the
equipment, not simply on the ERP Schedule.
Activity Center
• No items for 2017
11/21/2016
4
Arts Center
• No items in 2017
Comm Svcs ‐IT
• Backup Server
• Annually the city replaces a portion of its
obsolete computers with newer technology.
– This includes both computers and servers in
all city departments
11/21/2016
5
Fire Equipment
• The fire department annually assess its fleet and adjusts the useful lives of the equipment accordingly.
• 2008 Aerial Ladder Lease Payment
– 10 year lease at $54,217 annually
• Items scheduled for replacement
– Tele‐squirt Truck (Engine #2)
– Thermal Imaging Camera
Police Equipment
• Marked patrol cars (2)
• Squad Car Wireless Solution
11/21/2016
6
Public Works
Equipment
• Building & Equipment Services
– Truck Scan Kit
Public Works
Equipment
•P a r k s / F o r e s t r y
– Truckster
– Stump Cutter & Trailer
–S k i d L o a d e r
11/21/2016
7
Public Works
Equipment
• Streets/Traffic
– Tandem Dump Truck
– Roller
–S t r i p e r
–A s p h a l t P a v e r
– Snow Blower
– Asphalt Hot Mix Heating Box Trailer
Public Works
Equipment
•R e f u s e
– Rear Loading Refuse Truck
11/21/2016
8
Public Works
Equipment
• Sewer
–J e t V a c t o r
– Generator
–S C A D A U p g r a d e
Public Works
Equipment
•W a t e r
– ¾ ton utility truck
– Water Treatment Plant – equipment to convert
chlorine liquid to sodium hypochlorite
11/21/2016
9
Conclusion
• The Equipment Replacement Plan is a valuable tool used to
assess, plan and fund future equipment needs of the City.
• In the past by annually evaluating equipment and adjusting
useful lives where practical, the city has been able to
maintain the reserves in this fund to cover equipment.
• Maintaining adequate funding for future needs continues to
be a challenge.
• Equipment certificates will need to be sold for future
purchases
• Transfers and tax levy are scheduled.
EQUIPMENT REPLACEMENT PLAN
2017-2021
DATE: November 2016
TO: Honorable Mayor and Members of the City Council
FROM: Mike Mornson, City Manager
SUBJECT: 2017-2021 EQUIPMENT REPLACEMENT PLAN
With this letter, I respectfully submit the 2017-2021 Equipment Replacement Plan. This
five-year planning document represents the combined efforts of city staff and the City
Council.
The Equipment Replacement Plan is a five-year forecast of equipment replacement needs
in the City of Hopkins. It is intended to alert the Council and citizens of equipment
replacement needs that are needed to maintain the efficiency of city services and the
safety of city staff. The first year of the plan becomes the adopted budget, however the
equipment is again re-evaluated before final approval is given for the purchase. The
remaining four years represents estimated replacement needs and the related funding.
The Equipment Replacement Plan does not include proposed capital projects. A
document relating specifically to capital project needs has been developed into a separate
document.
The Equipment Replacement Plan is intended to serve as a planning tool and is therefore
structured to present a meaningful, long-range perspective of the city’s equipment needs
over the next 20 years. At the same time sufficient details on individual pieces of
equipment scheduled for replacement is provided to enable those who review the
information to make informed decisions of the city’s equipment needs over the next several
years.
Please use the information provided to assist in the understanding of the city’s equipment
needs as they relate to the delivery of service to the citizens of Hopkins.
This document was developed by the Finance Department with the assistance of all city
departments. I wish to especially thank all those involved in the development of the
Equipment Replacement Plan, and especially Steve Stadler, Public Works Director, Mike
Reynolds, Police Chief, Brent Johnson, Police Captain, Dale Specken, Fire Chief, and
Christine Harkess, Finance Director for their hard work and dedication.
1
Page
City Manager's Message 1
Table of Contents 2
Introduction
Background and Summary of Changes from 2015 Plan 5
Cash Flow Statements
Equipment Replacement Fund 11
Five-Year Project Summaries
Projects by Year 15
Department Summary 17
Projects by Department 18
Funding Source Summary 20
Projects by Funding Source 21
Equipment Requests
Individual Equipment Request Details
Activity Center 25
Arts Center 26
Community Services - IT 27
Community Services 34
Fire 35
Police 39
Public Works 51
Refuse 69
Sewer 72
Water 75
Twenty Year Replacement Schedule
Twenty Year Replacement Schedule by Department 79
Equipment and Building Inventory
Building Inventory 85
Vehicle and Equipment Inventory 87
EQUIPMENT REPLACEMENT PLAN
2017-2021
TABLE OF CONTENTS
2
INTRODUCTION
3
4
EQUIPMENT REPLACEMENT PLAN 2017-2021
BACKGROUND AND SUMMARY OF CHANGES FROM 2016 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.
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. The intragovernmental charges were increased in 2016 by 9% and will again
be increased in 2017 by 9%. Plans are to increase the rate going forward with increases of 9%
over the next 5 years. The majority of items purchased with ERP funds are used by departments
within the General Fund which accounts for the most of the operations of the city.
There have been many changes in technology and the way we operate and as a result there is
more equipment in the plan; however the rate has not increased to accommodate the increase in
equipment. Equipment that was purchased with grants such as digital squad cameras, laptop
computers in squad cars and fire vehicles, AED’s, and infrared cameras are included in the ERP
but the rates have not kept up with the addition of all these items. In addition society is dictating
some of the equipment under consideration. One of the items under discussion was police body
cameras. They were originally put in the ERP and later removed until it can be determined how
the data the cameras capture will be disseminated upon a public data request.
The long term viability of the fund remains questionable and will result in difficult decisions
regarding equipment and operations. These issues were addressed as part of the Financial
Management Plan (FMP) completed in 2014. The FMP establishes funding mechanisms to get
the fund to a constant balance of $750,000. Items that will be considered and/or implemented
are rate increases, a tax levy and issuing equipment certificates.
As discussed above are scheduling a 9% rate increase for 2017-2021 and plan to sell Equipment
Certificates in 2018 to fund some of the equipment scheduled for 2018-2019. This will allow us
to replace aging equipment and spread the payments over 10 years. The required Equipment
Certificate payment will be part of the debt levy in the applicable year.
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 3% of total general fund expenditures.
The Equipment Replacement Plan’s basic premise is scheduled replacement of present
equipment. A new item must, in the year proposed, be presented in the annual operating budget
5
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 2016 Plan
Highlights of changes from last year’s equipment replacement plan for the years 2017-2021:
CS - Activity Center: Sound system replacement was added in 2019 at a cost of $15,000.
CS - Arts Center: Two items totaling $9,400 were removed from the ERP and put in the
operational budget.
CS - IT: Network servers for city hall and the police department originally
budgeted at $15,000 per year each were increased to $22,000 as
technology demands increase.
A backup server for city computers essential to keeping electronic data
safe for the city was added in 2017 and 2020 at a cost of $66,000 for
each year.
Community Services: No changes
Fire: Leased vehicle cost of $32,707 per year was moved to the General
Fund Fire Dept operations budget along with the cost to outfit those
vehicles.
Workout equipment totaling $24,200 over 4 years was removed from
the ERP and into the operations budget for the respective years.
Automated external defibrillators (2) totaling $7,800 in 2018 were
removed from the ERP and will be put in the operations budget for
2018.
A washer & dryer for the turnout gear totaling $13,000 in 2018 was
removed from the ERP and will be put into the operations budget for
2018.
The Tele-squirt fire truck scheduled for replacement in 2017 at a cost
of $650,000 has been increased to $900,000 to reflect the actual cost
of replacement.
HRA No changes.
Pavilion: No changes
Parking: No changes.
6
Police: Leased vehicles for the chief, captain and DTF were removed from the
ERP along with the cost to outfit those vehicles and moved to the
Police operations budget. Total cost eliminated was $297,370 over the
next five years.
The cost of the marked squad cars has been evaluated and the cost
updated to reflect the prices on the state contracts. Cost for the
vehicles has increased up to $49,000 from 2017-2020 over the same
period in the prior year’s ERP.
The sergeant’s vehicle originally scheduled for 2019 was moved up to
2018 and the cost reduced by $1,600.
The PSO vehicle originally scheduled for 2020 was moved up to 2018
and the cost reduced by $5,400.
Tactical ballistic vests for the SWAT Team scheduled for 2018 also
now incorporates helmets and the cost was increased by $8,100.
PD squad video server scheduled for 2019 at a cost of $15,000 has
been removed and replaced with a PD video data server in 2018 to
2020. Cost in 2018 will be $115,000 and $10,000 per year thereafter.
Mobile data computers were added in 2019 at a cost of $65,000.
The records management system originally in as Data 911 in 2020 for
$50,000 has been renamed to appropriately describe the equipment
needed and the cost increased to $150,000.
Public Works: Engineering
No changes
Building/Equipment Services
A high pressure vehicle washer scheduled for 2020 at a cost of $8,300
has been removed and is part of the PW garage upgrade project.
Parks/Forestry
Trucksters originally scheduled for 2019 were moved to 2017 with no
change in cost.
The cost of the stump cutter originally scheduled for 2017 has
increased from $21,200 to $45,000 to reflect replacement cost.
The cost of the trailer flatbed scheduled for 2020 has increased in cost
from $2,200 to $10,000 to reflect replacement cost.
7
Streets/Traffic
Tandem dump trucks scheduled for replacement in 2017 and 2018
have increased in cost from $173,200 and $180,000 to $225,000 and
$235,000 a total impact of $106,800 over the two years. Cost
increased to better reflect replacement cost.
The asphalt paver originally in for 2018 at a cost of $48,800 has been
moved to 2017 at a cost of $118,000.
A snow blower has been added for 2017 at a cost of $160,000. This
item was originally scheduled for 2014, did not get purchased and did
not get put back in the ERP.
An asphalt hot mix heating box and trailer has been added in 2017 at a
cost of $15,000. Current box sits on the back of a truck is too small
and sits too high to be handled easily. Plans are to move to a hot box
on a trailer to provide greater efficiency and safety to employees.
Refuse
No changes
Sewer
A generator originally scheduled for 2017 at a cost of $26,400 has
increased in cost to $36,000.
A Jet Vactor has been moved from 2020 to 2017 and the cost
increased by $110,000 to reflect replacement cost.
SCADA upgrade has been added in 2017 at a cost to the sewer fund of
$160,000. Our current SCADA system is outdated and an upgrade is
needed for the system to continue to work with the PLC software and
radio parts.
Water
¾ ton Utility truck originally scheduled for 2016 was moved back to
2017. Current vehicle is a 2006 Chev Pick-up.
Water treatment plant equipment used to convert chlorine gas to liquid
sodium hypochlorite has been added at cost of $100,000. Chlorine gas
is extremely dangerous and corrosive. Liquid bleach is easy to contain
and work with.
8
CASH FLOW STATEMENTS
9
10
EQUIPMENT REPLACEMENT FUND (602)11/11/2016
Rate Change 9%9%9%10%9%9%9%
BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET
2015 2016 2017 2018 2019 2020 2021
Working Capital Begin Year 538,514 (373,504) 1,046,877 145,136 167,361 169,647 452,727
Revenues from charges 376,884 408,459 445,220 489,742 533,819 581,863 634,231
Tax Levy per FMP 400,865 472,848 532,834 605,750
Transfer in General Fund
Federal & State Grants 237,120
Interest earnings 5,982 3,000 3,000 3,000 3,000 3,000 3,000
Other revenues (sale of assets)27,535 30,000 30,000 30,000 35,000 35,000 35,000
Enterpirse contribution to software upgrade 57,058
Equipment Certificates (Bonds)1,896,570 590,000
Transfers In (Misc)
Interfund Loan 610,000
Total Revenues 647,521 2,395,087 1,088,220 1,513,607 1,044,667 1,152,697 1,277,981
Expenditures (excludes Leases & Depr.) 72,150 74,315 76,544 78,841 81,206 83,642 86,151
Fire Truck Financing Pymnts (2009-2018)53,803 54,217 54,217 54,217
Capital Outlay - Equipment 1,433,586 846,174 1,859,200 934,950 527,800 662,600 430,900
Transfer Out
Repayment of Interfund Loan 300,000 310,000
Total Expenses 1,559,539 974,705 1,989,961 1,491,382 1,042,381 869,617 640,426
Working Capital Ending Balance (373,504) 1,046,877 145,136 167,361 169,647 452,727 1,090,281
(cash + receivables - payables)
11
12
FIVE‐YEAR
PROJECT SUMMARIES
13
14
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
PROJECTS BY YEAR
2017 2021thru
Project Name Department Project # Priority Project Cost
2017
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0015Backup Server n/a 66,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0100Tele-Squirt (Engine 2)n/a 900,000Fire
01-ERP-0106Aerial Truck n/a 54,217Fire
01-ERP-0112Thermal Imaging Camera (2)n/a 12,900Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 98,000Police
01-ERP-0223Squad Car Wireless Solution n/a 12,000Police
01-ERP-0714PW - Truck Scan Kit 1 10,000Public Works: Bldg/Equip Serv
01-ERP-0807Trucksters (3)n/a 34,200Public Works: Parks/Forestry
01-ERP-0812Stump Cutter n/a 45,000Public Works: Parks/Forestry
01-ERP-0815Skid Loader n/a 32,000Public Works: Parks/Forestry
01-ERP-0306Tandem Dump Truck (2)n/a 225,000Public Works: Streets/Traffic
01-ERP-0312PW - Roller n/a 45,900Public Works: Streets/Traffic
01-ERP-0313Striper n/a 11,200Public Works: Streets/Traffic
01-ERP-0314PW - Asphalt Paver n/a 118,000Public Works: Streets/Traffic
01-ERP-0315Snow Blower n/a 160,000Public Works: Streets/Traffic
01-ERP-0318Asphalt Hot Mix Heating Box - Trailer n/a 15,000Public Works: Streets/Traffic
01-ERP-0901Refuse Truck (Rear-L)n/a 101,600Refuse
01-ERP-0552Jet Vactor n/a 425,000Sewer
01-ERP-0555Generator (2)n/a 36,000Sewer
01-ERP-0559SCADA Upgrade 1 160,000Sewer
01-ERP-05003/4 Ton Truck n/a 32,000Water
01-ERP-0509Water Treatment Plant 1 100,000Water
2,768,017Total for 2017
2018
01-ERP-1104Art Center Theater Projector n/a 17,100Comm Svcs - Arts Center
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0012Core Network Switch n/a 17,000Comm Svcs - IT
01-ERP-0013Wi-Fi and Cellular n/a 6,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0106Aerial Truck n/a 54,217Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 147,000Police
01-ERP-0201Sergeant's Vehicle n/a 49,000Police
01-ERP-0203PSO - Utility 4x4 n/a 55,000Police
01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT n/a 35,000Police
01-ERP-0217Taser Replacement n/a 29,000Police
01-ERP-0219PD - Video Data Server n/a 115,000Police
01-ERP-07104X4 1/2 Ton Truck n/a 31,300Public Works: Bldg/Equip Serv
01-ERP-0816Toolcat n/a 63,300Public Works: Parks/Forestry
01-ERP-03024x2 1 Ton Dump Truck n/a 54,600Public Works: Streets/Traffic
Friday, November 11, 2016
15
Project Name Department Project # Priority Project Cost
01-ERP-0306Tandem Dump Truck (2)n/a 235,000Public Works: Streets/Traffic
01-ERP-0803Swap Loader n/a 95,000Refuse
1,077,517Total for 2018
2019
01-ERP-0036Activity Center Sound System Replacement 3 15,000Comm Svcs - Activity Center
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0109Extrication Tool (2)n/a 27,400Fire
01-ERP-0200Marked Patrol Vehicles (7)n/a 98,000Police
01-ERP-0212Squad Car Camera Systems n/a 65,000Police
01-ERP-0218Building Video Server n/a 17,000Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0220Mobile Data Computers n/a 65,000Police
01-ERP-0311Sweeper n/a 156,400Public Works: Streets/Traffic
527,800Total for 2019
2020
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0013Wi-Fi and Cellular n/a 6,000Comm Svcs - IT
01-ERP-0014Distribution Network Switches n/a 50,000Comm Svcs - IT
01-ERP-0015Backup Server n/a 66,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0008Document Management Scanner (2)n/a 11,300Community Services
01-ERP-0200Marked Patrol Vehicles (7)n/a 107,400Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0221Records Management System n/a 150,000Police
01-ERP-08014x4 3/4Ton Trucks (2)n/a 85,200Public Works: Parks/Forestry
01-ERP-0810Large Turf Mower n/a 92,700Public Works: Parks/Forestry
01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry
662,600Total for 2020
2021
01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0006Computers n/a 30,000Comm Svcs - IT
01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT
01-ERP-0200Marked Patrol Vehicles (7)n/a 161,100Police
01-ERP-0202PSO / Parking Enforcement Vehicle n/a 53,700Police
01-ERP-0219PD - Video Data Server n/a 10,000Police
01-ERP-0305Single Axle Dump Truck (2)n/a 132,100Public Works: Streets/Traffic
01-ERP-0900Refuse Truck (RAP-R) (2)n/a 270,300Refuse
701,200Total for 2021
GRAND TOTAL 5,737,134
Friday, November 11, 2016
16
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
DEPARTMENT SUMMARY
2017 2021thru
Total2017 2018 2019 2020 2021Department
Comm Svcs - Activity Center 15,00015,000
Comm Svcs - Arts Center 17,10017,100
Comm Svcs - IT 581,000140,000 97,000 74,000 196,000 74,000
Community Services 11,30011,300
Fire 1,048,734967,117 54,217 27,400
Police 1,287,200110,000 430,000 255,000 267,400 224,800
Public Works: Bldg/Equip Serv 41,30010,000 31,300
Public Works: Parks/Forestry 362,400111,200 63,300 187,900
Public Works: Streets/Traffic 1,153,200575,100 289,600 156,400 132,100
Refuse 466,900101,600 95,000 270,300
Sewer 621,000621,000
Water 132,000132,000
2,768,017 1,077,517 527,800 662,600 701,200 5,737,134TOTAL
Friday, November 11, 201617
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
PROJECTS BY DEPARTMENT
2017 2021thru
Total2017 2018 2019 2020 2021Department Project# Priority
Comm Svcs - Activity Center
01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3
15,00015,000Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
01-ERP-1104 17,10017,100Art Center Theater Projector n/a
17,10017,100Comm Svcs - Arts Center Total
Comm Svcs - IT
01-ERP-0003 110,00022,000 22,000 22,000 22,000 22,000CH - Network Server n/a
01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computers n/a
01-ERP-0012 17,00017,000Core Network Switch n/a
01-ERP-0013 12,0006,000 6,000Wi-Fi and Cellular n/a
01-ERP-0014 50,00050,000Distribution Network Switches n/a
01-ERP-0015 132,00066,000 66,000Backup Server n/a
01-ERP-0211 110,00022,000 22,000 22,000 22,000 22,000PD - Network Server n/a
581,000140,000 97,000 74,000 196,000 74,000Comm Svcs - IT Total
Community Services
01-ERP-0008 11,30011,300Document Management Scanner (2) n/a
11,30011,300Community Services Total
Fire
01-ERP-0100 900,000900,000Tele-Squirt (Engine 2) n/a
01-ERP-0106 108,43454,217 54,217Aerial Truck n/a
01-ERP-0109 27,40027,400Extrication Tool (2)n/a
01-ERP-0112 12,90012,900Thermal Imaging Camera (2)n/a
1,048,734967,117 54,217 27,400Fire Total
Police
01-ERP-0200 611,50098,000 147,000 98,000 107,400 161,100Marked Patrol Vehicles (7) n/a
01-ERP-0201 49,00049,000Sergeant's Vehicle n/a
01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 55,00055,000PSO - Utility 4x4 n/a
01-ERP-0212 65,00065,000Squad Car Camera Systems n/a
01-ERP-0214 35,00035,000Tactical Ballistic Vests / Helmets - SWAT n/a
01-ERP-0217 29,00029,000Taser Replacement n/a
01-ERP-0218 17,00017,000Building Video Server n/a
01-ERP-0219 145,000115,000 10,000 10,000 10,000PD - Video Data Server n/a
01-ERP-0220 65,00065,000Mobile Data Computers n/a
01-ERP-0221 150,000150,000Records Management System n/a
01-ERP-0223 12,00012,000Squad Car Wireless Solution n/a
Friday, November 11, 201618
Total2017 2018 2019 2020 2021Department Project# Priority
1,287,200110,000 430,000 255,000 267,400 224,800Police Total
Public Works: Bldg/Equip Serv
01-ERP-0710 31,30031,3004X4 1/2 Ton Truck n/a
01-ERP-0714 10,00010,000PW - Truck Scan Kit 1
41,30010,000 31,300Public Works: Bldg/Equip Serv Total
Public Works: Parks/Forestry
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2) n/a
01-ERP-0807 34,20034,200Trucksters (3) n/a
01-ERP-0810 92,70092,700Large Turf Mower n/a
01-ERP-0812 45,00045,000Stump Cutter n/a
01-ERP-0814 10,00010,000Trailer Flatbed n/a
01-ERP-0815 32,00032,000Skid Loader n/a
01-ERP-0816 63,30063,300Toolcat n/a
362,400111,200 63,300 187,900Public Works: Parks/Forestry Total
Public Works: Streets/Traffic
01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a
01-ERP-0305 132,100132,100Single Axle Dump Truck (2) n/a
01-ERP-0306 460,000225,000 235,000Tandem Dump Truck (2) n/a
01-ERP-0311 156,400156,400Sweeper n/a
01-ERP-0312 45,90045,900PW - Roller n/a
01-ERP-0313 11,20011,200Striper n/a
01-ERP-0314 118,000118,000PW - Asphalt Paver n/a
01-ERP-0315 160,000160,000Snow Blower n/a
01-ERP-0318 15,00015,000Asphalt Hot Mix Heating Box - Trailer n/a
1,153,200575,100 289,600 156,400 132,100Public Works: Streets/Traffic Total
Refuse
01-ERP-0803 95,00095,000Swap Loader n/a
01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a
01-ERP-0901 101,600101,600Refuse Truck (Rear-L)n/a
466,900101,600 95,000 270,300Refuse Total
Sewer
01-ERP-0552 425,000425,000Jet Vactor n/a
01-ERP-0555 36,00036,000Generator (2)n/a
01-ERP-0559 160,000160,000SCADA Upgrade 1
621,000621,000Sewer Total
Water
01-ERP-0500 32,00032,0003/4 Ton Truck n/a
01-ERP-0509 100,000100,000Water Treatment Plant 1
132,000132,000Water Total
GRAND TOTAL 5,737,1342,768,017 1,077,517 527,800 662,600 701,200
Friday, November 11, 201619
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
FUNDING SOURCE SUMMARY
2017 thru 2021
TotalSource2017 2018 2019 2020 2021
AC - Arts Center Fund 17,10017,100
Bonds/Lease 108,43454,217 54,217
Equipment Replacement Fund 4,415,4501,859,200 934,950 527,800 662,600 430,900
RF - Refuse Fund 443,150101,600 71,250 270,300
SF - Sanitary Sewer Fund 531,000531,000
WF - Water Fund 222,000222,000
2,768,017 1,077,517 527,800 662,600 701,200 5,737,134GRAND TOTAL
Friday, November 11, 2016
20
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN
PROJECTS BY FUNDING SOURCE
2017 2021thru
TotalSourceProject# Priority 2017 2018 2019 2020 2021
AC - Arts Center Fund
01-ERP-1104 17,10017,100Art Center Theater Projector n/a
17,10017,100AC - Arts Center Fund Total
Bonds/Lease
01-ERP-0106 108,43454,217 54,217Aerial Truck n/a
108,43454,217 54,217Bonds/Lease Total
Equipment Replacement Fund
01-ERP-0003 110,00022,000 22,000 22,000 22,000 22,000CH - Network Server n/a
01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computers n/a
01-ERP-0008 11,30011,300Document Management Scanner (2)n/a
01-ERP-0012 17,00017,000Core Network Switch n/a
01-ERP-0013 12,0006,000 6,000Wi-Fi and Cellular n/a
01-ERP-0014 50,00050,000Distribution Network Switches n/a
01-ERP-0015 132,00066,000 66,000Backup Server n/a
01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3
01-ERP-0100 900,000900,000Tele-Squirt (Engine 2)n/a
01-ERP-0109 27,40027,400Extrication Tool (2)n/a
01-ERP-0112 12,90012,900Thermal Imaging Camera (2)n/a
01-ERP-0200 611,50098,000 147,000 98,000 107,400 161,100Marked Patrol Vehicles (7)n/a
01-ERP-0201 49,00049,000Sergeant's Vehicle n/a
01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 55,00055,000PSO - Utility 4x4 n/a
01-ERP-0211 110,00022,000 22,000 22,000 22,000 22,000PD - Network Server n/a
01-ERP-0212 65,00065,000Squad Car Camera Systems n/a
01-ERP-0214 35,00035,000Tactical Ballistic Vests / Helmets - SWAT n/a
01-ERP-0217 29,00029,000Taser Replacement n/a
01-ERP-0218 17,00017,000Building Video Server n/a
01-ERP-0219 145,000115,000 10,000 10,000 10,000PD - Video Data Server n/a
01-ERP-0220 65,00065,000Mobile Data Computers n/a
01-ERP-0221 150,000150,000Records Management System n/a
01-ERP-0223 12,00012,000Squad Car Wireless Solution n/a
01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a
01-ERP-0305 132,100132,100Single Axle Dump Truck (2)n/a
01-ERP-0306 460,000225,000 235,000Tandem Dump Truck (2)n/a
01-ERP-0311 156,400156,400Sweepern/a
01-ERP-0312 45,90045,900PW - Roller n/a
01-ERP-0313 11,20011,200Stripern/a
01-ERP-0314 118,000118,000PW - Asphalt Paver n/a
01-ERP-0315 160,000160,000Snow Blower n/a
01-ERP-0318 15,00015,000Asphalt Hot Mix Heating Box - Trailer n/a
Friday, November 11, 2016
21
TotalSourceProject# Priority 2017 2018 2019 2020 2021
01-ERP-0710 31,30031,3004X4 1/2 Ton Truck n/a
01-ERP-0714 10,00010,000PW - Truck Scan Kit 1
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2) n/a
01-ERP-0803 23,75023,750Swap Loader n/a
01-ERP-0807 34,20034,200Trucksters (3) n/a
01-ERP-0810 92,70092,700Large Turf Mower n/a
01-ERP-0812 45,00045,000Stump Cutter n/a
01-ERP-0814 10,00010,000Trailer Flatbed n/a
01-ERP-0815 32,00032,000Skid Loader n/a
01-ERP-0816 63,30063,300Toolcatn/a
4,415,4501,859,200 934,950 527,800 662,600 430,900Equipment Replacement Fund Total
RF - Refuse Fund
01-ERP-0803 71,25071,250Swap Loader n/a
01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2) n/a
01-ERP-0901 101,600101,600Refuse Truck (Rear-L) n/a
443,150101,600 71,250 270,300RF - Refuse Fund Total
SF - Sanitary Sewer Fund
01-ERP-0552 425,000425,000Jet Vactor n/a
01-ERP-0555 36,00036,000Generator (2) n/a
01-ERP-0559 70,00070,000SCADA Upgrade 1
531,000531,000SF - Sanitary Sewer Fund Total
WF - Water Fund
01-ERP-0500 32,00032,0003/4 Ton Truck n/a
01-ERP-0509 100,000100,000Water Treatment Plant 1
01-ERP-0559 90,00090,000SCADA Upgrade 1
222,000222,000WF - Water Fund Total
5,737,1342,768,017 1,077,517 527,800 662,600 701,200GRAND TOTAL
Friday, November 11, 2016
22
EQUIPMENT REQUESTS
23
24
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Activity Ctr Director
2017 2021thru Department Comm Svcs - Activity Center
Description
Replace and enhance the sound system in the Raspberry, Conference, Computer Nook, Harmony Hill, Lounge/Dining, and Office areas.
Project #01-ERP-0036
Priority 3 Important
Justification
The present sound system in many of these areas are the original system installed in 1980. It was primarily used as a paging system. We will
replace and enhance the sound system to allow better hearing for our participants as well as easier use of amplification devises for speakers,
presenters, and instructors in these areas.
Budget Impact/Other
Useful Life 25 years
Project Name Activity Center Sound System Replacement Category Equipment
Type Equipment
Future
Total Project Cost:$15,000
Total2017 2018 2019 2020 2021Expenditures
15,00015,000Equipment
15,000 15,000Total
Total2017 2018 2019 2020 2021Funding Sources
15,00015,000Equipment Replacement Fund
15,000 15,000Total
Friday, November 11, 2016
25
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Arts Center Director
2017 2021thru Department Comm Svcs - Arts Center
Description
Current projector is 3000 lumen -- 6500 lumen is required for theater usage including in partial light situations and to achieve the clarity needed for
detailed images. Such a projector costs about $7,200 (including mounting and rigging hardware, cables and installation labor). The projector also
needs to be part of a professional system that permits it to be operated from the theater tech booth or from on-stage -- the current projector is only
operable from a hand-held remote requiring the operator to dash into the audience of the theater. This total cost of $15,200 includes all the wiring
and hardware needed to support a projector well into the future. The projector itself is estimated to have a 5-year useful life. (The existing
projector will be moved to one of the meeting rooms).
Project #01-ERP-1104
Priority n/a
Justification
The justification of this expense is two-fold: First, in order to attract and retain arts and corporate renters we need to be able to provide the technical
support required for their events. Income from such rentals (including Pen Pals and Digital Rivers) is becoming increasingly vital to the financial
health of the Center. If we are not capable of competing with similar size venues, we will lose this income. Secondly, as a professional arts
presenter we need to have the technical capabilities to run our own programs in a professional manner.
Year 2018: $17,100
Year 2023 $19,800
Year 2028 $22,900
Budget Impact/Other
Investing $15, 000 to retain major renters such as Pen Pals and Digital Rivers is worthwhile. Pen Pals alone brings in about $20.000/year in
income. Digital Rivers just under $9,000.
Useful Life 5 years
Project Name Art Center Theater Projector Category Equipment
Type Equipment
Future
Total Project Cost:$75,000
Total2017 2018 2019 2020 2021Expenditures
17,10017,100Equipment
17,100 17,100Total
Total2017 2018 2019 2020 2021Funding Sources
17,10017,100AC - Arts Center Fund
17,100 17,100Total
Friday, November 11, 2016
26
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact IT Director
2017 2021thru Department Comm Svcs - IT
Description
The network server is the hub of the network. New computers are faster and more reliable.
Project #01-ERP-0003
Priority n/a
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 - Increase from 8,000 to 15,000. Software licensing has become more expensive. We are paying half of our server
budget to required software and 8,000 isn't enough anymore.
2016 - Variance from 20 year plan - We were using a 4 year old server design for our servers that is not meeting current standards for speed of data
access. Our new hardware design costs aprroximately 7,000 more than the old standard that was insufficent.
Useful Life 1 year
Project Name CH - Network Server Category Equipment
Type Equipment
Future
Total Project Cost:$626,000
Total2017 2018 2019 2020 2021Expenditures
110,00022,000 22,000 22,000 22,000 22,000Equipment
22,000 22,000 22,000 22,000 22,000 110,000Total
Total2017 2018 2019 2020 2021Funding Sources
110,00022,000 22,000 22,000 22,000 22,000Equipment Replacement Fund
22,000 22,000 22,000 22,000 22,000 110,000Total
Friday, November 11, 2016
27
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Finance Director/IT
2017 2021thru Department Comm Svcs - IT
Description
Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one
fund.
Project #01-ERP-0006
Priority n/a
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-
Useful Life 3-5 years
Project Name Computers Category Equipment
Type Equipment
Future
Total Project Cost:$1,050,000
Total2017 2018 2019 2020 2021Expenditures
150,00030,000 30,000 30,000 30,000 30,000Equipment
30,000 30,000 30,000 30,000 30,000 150,000Total
Total2017 2018 2019 2020 2021Funding Sources
150,00030,000 30,000 30,000 30,000 30,000Equipment Replacement Fund
30,000 30,000 30,000 30,000 30,000 150,000Total
Friday, November 11, 2016
28
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Finance Director/IT
2017 2021thru Department Comm Svcs - IT
Description
Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates
fiber optic network connection to fire department.
2 - Cisco 3560E-24PD managed switch - $3,000 each
2 - Cisco X2-10GB-LR fiber optic transceiver - $1200 each
cost listed is for equipment only and does not include tax, shipping and other related costs
Project #01-ERP-0012
Priority n/a
Justification
Current two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in significant network outage
that was immediately noticed by many employees.
Budget Impact/Other
Variance from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside the budget for city hall
server network budget as the "Lisa" service is scheduled for replacement due to end of life, out of PCI compliance and obsolete.
2015 - change amount from $12,000 to $17,000 - more expensive than originally thought based on 2015 replacement.
Estimate salvage/resale value on replace item: - $-0-
Useful Life 6 years
Project Name Core Network Switch Category Equipment
Type Equipment
Future
Total Project Cost:$71,000
Total2017 2018 2019 2020 2021Expenditures
17,00017,000Equipment
17,000 17,000Total
Total2017 2018 2019 2020 2021Funding Sources
17,00017,000Equipment Replacement Fund
17,000 17,000Total
Friday, November 11, 2016
29
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact IT Director
2017 2021thru Department Comm Svcs - IT
Description
With technology trending towards an explosion of mobile devices we need to be able to manage, secure and provide connectivity to current and
future devices
Project #01-ERP-0013
Priority n/a
Justification
We have cellular dead spots in buildings that can be fixed with inexpensive cell bosing technology. The number of mobile devices owned by the
city is increasing every year. Our current internal Wi-Fi infrastructure has been put to together with technology that was never designed for the
enterprise. As the Wi-Fi infrastructure is increasing the system isn't staying stable enough to meet demands. Just about every city building now has
a business need for Wi-Fi. Our current mobile device management infrastructure needs updating to handle the influx of city data on employee
owned devices, CJIS protected data, need for content filtering, as well as maintain the security of current devices.
Budget Impact/Other
2016 - New ERP item
Useful Life 5-7 years
Project Name Wi-Fi and Cellular Category Equipment
Type Equipment
Future
Total Project Cost:$18,000
Total2017 2018 2019 2020 2021Expenditures
12,0006,000 6,000Equipment
6,000 6,000 12,000Total
Total2017 2018 2019 2020 2021Funding Sources
12,0006,000 6,000Equipment Replacement Fund
6,000 6,000 12,000Total
Friday, November 11, 2016
30
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact IT Director
2017 2021thru Department Comm Svcs - IT
Description
We have 25 distribution network switches in our enterprise environment along with fiber optic transceivers and direct attach sfp cables to connect
them. Distribution switches connect to the core switches and bring the data to the actual endpoints such as desktops, servers, telephones, and
copiers.
Project #01-ERP-0014
Priority n/a
Justification
Replacement of these switches with current technology is vital to the function of the network as well as the safety of the data being passed through
the switch.
Budget Impact/Other
2016 - New item in ERP
Useful Life 5 years
Project Name Distribution Network Switches Category Equipment
Type Equipment
Future
Total Project Cost:$107,000
Total2017 2018 2019 2020 2021Expenditures
50,00050,000Equipment
50,000 50,000Total
Total2017 2018 2019 2020 2021Funding Sources
50,00050,000Equipment Replacement Fund
50,000 50,000Total
Friday, November 11, 2016
31
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact IT Director
2017 2021thru Department Comm Svcs - IT
Description
Group of Dell servers to run Dell Rapid Recovery software to backup city computers and servers, along with Windows and VMWare licsensing
required to run the servers.
Project #01-ERP-0015
Priority n/a
Justification
Backup servers are essential to keep the electronic data for the city safe. We have overgrown our current system and are not able to backup
everything that needs to be backed up in a timely manor. Additinally restores on the curent system take hours to days. If we needed to restore a
critical server from backup, we would be looking at an unacceptable amount of downtime.
Budget Impact/Other
Useful Life 3 years
Project Name Backup Server Category Equipment
Type Equipment
Future
Total Project Cost:$132,000
Total2017 2018 2019 2020 2021Expenditures
132,00066,000 66,000Equipment
66,000 66,000 132,000Total
Total2017 2018 2019 2020 2021Funding Sources
132,00066,000 66,000Equipment Replacement Fund
66,000 66,000 132,000Total
Friday, November 11, 2016
32
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact IT Director
2017 2021thru Department Comm Svcs - IT
Description
Computer servers store information and system programs for Police Department.
One server @ $22,000 for system upgrades
Project #01-ERP-0211
Priority n/a
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 - Increase from 8,500 to 15,000. Software licensing has become more expensive. We are paying half our server budget
for required software and 8,500 isn't enough anymore.
2016 Variance from 20 year plan - We were using a 4 year old server design for our servers that is not meeting current standards for speed of data
access. Our new hardware design costs aprroximately 7,000 more than the old standard that was insufficent.
Useful Life 3 years
Project Name PD - Network Server Category Equipment
Type Equipment
Future
Total Project Cost:$631,000
Total2017 2018 2019 2020 2021Expenditures
110,00022,000 22,000 22,000 22,000 22,000Equipment
22,000 22,000 22,000 22,000 22,000 110,000Total
Total2017 2018 2019 2020 2021Funding Sources
110,00022,000 22,000 22,000 22,000 22,000Equipment Replacement Fund
22,000 22,000 22,000 22,000 22,000 110,000Total
Friday, November 11, 2016
33
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact City Clerk
2017 2021thru Department Community Services
Description
Large document (11” x17”) scanner for document management and retention as well as general administrative use.
Purchased two scanners in 2012 at a cost of $10,315 - 1 at scanner station, 1 in City Clerk's office
Current equipment: Canon DR 7550C
Project #01-ERP-0008
Priority n/a
Justification
Scanners are needed for converting paper copies to electronic data to reduce storage space.
Budget Impact/Other
Variance from 20 year plan - Two scanners purchased in 2012 and will be replaced every four years.
Estimate salvage/resale value on replaced item: $500-$1,000
Useful Life 4 years
Project Name Document Management Scanner (2)Category Equipment
Type Equipment
Future
Total Project Cost:$87,600
Total2017 2018 2019 2020 2021Expenditures
11,30011,300Equipment
11,300 11,300Total
Total2017 2018 2019 2020 2021Funding Sources
11,30011,300Equipment Replacement Fund
11,300 11,300Total
Friday, November 11, 2016
34
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Fire Chief
2017 2021thru Department Fire
Description
Fire engine: full size response truck
Current vehicle: 1989 Ford L9000 Tele-Squirt (#102)
Project #01-ERP-0100
Priority n/a
Justification
This is a replacement engine for response to emergency response in the City. We will be reducing the fleet by one truck in making this one unit
(ladder/pumper) which would reduce the life of a vehicle from 25 years to 10 years. We are finding that the life a vehicle is no longer 20 years.
Budget Impact/Other
Variance from 20 year plan - was scheduled for replacement in 2019 and has been moved up to 2017. Change useful life from 25 to 10 years.
Updated value to reflect more accurate replacement cost.
Estimate salvage/resale value on replaced item: $
Useful Life 10 years
Project Name Tele-Squirt (Engine 2)Category Vehicles
Type Equipment
Future
Total Project Cost:$1,900,000
Total2017 2018 2019 2020 2021Expenditures
900,000900,000Equipment
900,000 900,000Total
Total2017 2018 2019 2020 2021Funding Sources
900,000900,000Equipment Replacement Fund
900,000 900,000Total
Friday, November 11, 2016
35
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Fire Chief
2017 2021thru Department Fire
Description
One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on
2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23.
Current vehicle: 2008 Pierce Arrow XT Aerial Ladder (#109)
Project #01-ERP-0106
Priority n/a
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: $
Useful Life 20 years
Project Name Aerial Truck Category Vehicles
Type Equipment
Future
Total Project Cost:$2,559,597
Total2017 2018 2019 2020 2021Expenditures
108,43454,217 54,217Equipment
54,217 54,217 108,434Total
Total2017 2018 2019 2020 2021Funding Sources
108,43454,217 54,217Bonds/Lease
54,217 54,217 108,434Total
Friday, November 11, 2016
36
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Fire Chief
2017 2021thru Department Fire
Description
Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram.
Project #01-ERP-0109
Priority n/a
Justification
All vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool will be added to the purchase of the
quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost.
Budget Impact/Other
Variance from 20 year plan - move back from 2015 to 2019.
Estimate salvage/resale value on replaced item: $1,000
Purchased: 2007
Useful Life 10 years
Project Name Extrication Tool (2)Category Equipment
Type Equipment
Future
Total Project Cost:$177,200
Total2017 2018 2019 2020 2021Expenditures
27,40027,400Equipment
27,400 27,400Total
Total2017 2018 2019 2020 2021Funding Sources
27,40027,400Equipment Replacement Fund
27,400 27,400Total
Friday, November 11, 2016
37
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Fire Chief
2017 2021thru Department Fire
Description
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
Project #01-ERP-0112
Priority n/a
Justification
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
Variance from 20 year plan - department owns 2 cameras. Previously 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 replaced item: $-0-
Useful Life 10 years
Project Name Thermal Imaging Camera (2)Category Equipment
Type Equipment
Future
Total Project Cost:$92,900
Total2017 2018 2019 2020 2021Expenditures
12,90012,900Equipment
12,900 12,900Total
Total2017 2018 2019 2020 2021Funding Sources
12,90012,900Equipment Replacement Fund
12,900 12,900Total
Friday, November 11, 2016
38
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief
2017 2021thru Department Police
Description
Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
Fleet consists of 7 patrol vehicles - all marked
Current Vehicles: (1) 2013 Ford Utility, (1) 2014 Ford Utility, (3) 2015 Ford Utility, (2) 2016 Ford Utility
Project #01-ERP-0200
Priority n/a
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 - cost modified due to new models of squads which need to be re-outfitted for all equipment.
Estimate salvage/resale value on replaced item: $4,000 each
Useful Life 3 years
Project Name Marked Patrol Vehicles (7)Category Vehicles
Type Equipment
Future
Total Project Cost:$3,382,600
Total2017 2018 2019 2020 2021Expenditures
611,50098,000 147,000 98,000 107,400 161,100Vehicles
98,000 147,000 98,000 107,400 161,100 611,500Total
Total2017 2018 2019 2020 2021Funding Sources
611,50098,000 147,000 98,000 107,400 161,100Equipment Replacement Fund
98,000 147,000 98,000 107,400 161,100 611,500Total
Friday, November 11, 2016
39
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief
2017 2021thru Department Police
Description
Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties.
4 year rotation.
Current vehicle: 2014 Ford Utility
Project #01-ERP-0201
Priority n/a
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 - cost modified due to new model of car which will require all new equipment.
Estimate salvage/resale value on replaced item: $3,500 each
Useful Life 4 years
Project Name Sergeant's Vehicle Category Vehicles
Type Equipment
Future
Total Project Cost:$400,600
Total2017 2018 2019 2020 2021Expenditures
49,00049,000Vehicles
49,000 49,000Total
Total2017 2018 2019 2020 2021Funding Sources
49,00049,000Equipment Replacement Fund
49,000 49,000Total
Friday, November 11, 2016
40
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief
2017 2021thru Department Police
Description
Marked patrol vehicle used by PSO Evidence Tech / Parking Enforcement Officer to respond to calls for service, enforce parking laws, and perform
duties associated with evidentiary processes.
Current Vehicle: (1) 2016 Ford Utility
Project #01-ERP-0202
Priority n/a
Justification
Use by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown area.
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 - vehicle was increasd to account for the outfitting and radio
Estimate salvage/resale value on replaced item: $1,500
2016 - Change in replacement schedule due to full time use of vehicle and change of position responsibilities. Next replacement scheduled for 2021
from 2026
Useful Life 5 years
Project Name PSO / Parking Enforcement Vehicle Category Vehicles
Type Equipment
Future
Total Project Cost:$168,900
Total2017 2018 2019 2020 2021Expenditures
53,70053,700Vehicles
53,700 53,700Total
Total2017 2018 2019 2020 2021Funding Sources
53,70053,700Equipment Replacement Fund
53,700 53,700Total
Friday, November 11, 2016
41
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief
2017 2021thru Department Police
Description
Four wheel drive marked patrol vehicle used by PSOs to respond to calls for service, handle animal complaints, and perform other duties associated
with department operations.
Current vehicle: 2014 Ford F150 (#212)
Project #01-ERP-0203
Priority n/a
Justification
Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals, prisoners and equipment. The 4 wheel
drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme snow conditions.
Budget Impact/Other
Estimate salvage/resale value on replaced item: $5,000
2016 - Variance from 20 year plan - Change in replacement schedule due to full time use of vehicle. Changing useful life from 6 years to 4 years
Useful Life 4 years
Project Name PSO - Utility 4x4 Category Vehicles
Type Equipment
Future
Total Project Cost:$328,300
Total2017 2018 2019 2020 2021Expenditures
55,00055,000Vehicles
55,000 55,000Total
Total2017 2018 2019 2020 2021Funding Sources
55,00055,000Equipment Replacement Fund
55,000 55,000Total
Friday, November 11, 2016
42
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief
2017 2021thru Department Police
Description
Squad car camera systems are used to document events inside and outside of squad cars. The camera systems utilize a forward facing camera and a
prisoner transport area camaera. The squad car camaera systems is independent of any body worn camera system that may be in use by a police
officer.
Current equipment: 11 - 2007 Panasonic Laptops
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.
Current equipment: 2009 ICOP Model 20/20-W LIVE
Project #01-ERP-0212
Priority n/a
Justification
Computers: Limited life of 5 years - replacement necessary.
The squad car camera systems are vital to accurate documentation of law enforcement activities and criminal prosecution of crimes. The squad car
camera systems are also used for documentation of police officer activities and open transparency with the community.
Budget Impact/Other
Variance from 20 year plan - ERP - Move back one year to 2014. All working - no problems.
Estimate salvage/resale value on replaced item: $-0-
In 2014 the Police Dept. has the opportunity to purchase a combined mobile data computer/digital camera component for a total cost of $148,000.
Originally the total of the cameras and computers together totaled $116,100 with the computers scheduled for 2014 and the cameras scheduled for
2015. The cameras are being pulled forward to 2014.
2016 - Variance from 20 year plan - Change in replacement year to accurately reflect life expectancy in relation to when the cameras were
purchased. Change in budgeted amount to reflect past and anticipated costs.
Useful Life 5 years
Project Name Squad Car Camera Systems Category Equipment
Type Equipment
Future
Total Project Cost:$557,500
Total2017 2018 2019 2020 2021Expenditures
65,00065,000Equipment
65,000 65,000Total
Total2017 2018 2019 2020 2021Funding Sources
65,00065,000Equipment Replacement Fund
65,000 65,000Total
Friday, November 11, 2016
43
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief
2017 2021thru Department Police
Description
Tactical ballistic vests worn by members of the Hopkins Police Department SWAT (Special Weapons and Tactics) team. These vests offer a higher
level of protection against weapon assault than the regular duty ballistic vest. SWAT members also require a kevlar helmet on the same roatational
cycle
Current equipment: 11 - Protech Tactical Vests
Project #01-ERP-0214
Priority n/a
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 2018.
Budget Impact/Other
Variance from 20 year plan - Team membership has increased to 11.
Estimate salvage/resale value on replaced item: $
Without grant money the estimated cost for 11 vests and helmets is $44,274
Useful Life 5 years
Project Name Tactical Ballistic Vests / Helmets - SWAT Category Equipment
Type Equipment
Future
Total Project Cost:$213,200
Total2017 2018 2019 2020 2021Expenditures
35,00035,000Equipment
35,000 35,000Total
Total2017 2018 2019 2020 2021Funding Sources
35,00035,000Equipment Replacement Fund
35,000 35,000Total
Friday, November 11, 2016
44
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Captain
2017 2021thru Department Police
Description
Tasers can prevent officers and the public from injuries.Taser technology continues to develop and are worn/ carried 24/7. Tasers have a useful life
expectancy of approximately 5 years. The department purchases 10 Tasers with cameras along with a warranty plan. We are able to trade in the
older devices and receive credit on new equipment.
Project #01-ERP-0217
Priority n/a
Justification
Tasers are a crtical tool for Law Enforcement for control purposes during use of force encounters.
Budget Impact/Other
10- X2 Taser, 2 – batteries, 10 – training cartridges, 10 – field use cartridges, 1 – holster, 1 – extended warranty
(Taser Camera and warranty) for each Taser. $708.82
Total overall cost each Taser in 2018 = $2870.00 (+ shipping/tax)
Useful Life 4 years
Project Name Taser Replacement Category Equipment
Type Equipment
Future
Total Project Cost:$152,600
Total2017 2018 2019 2020 2021Expenditures
29,00029,000Equipment
29,000 29,000Total
Total2017 2018 2019 2020 2021Funding Sources
29,00029,000Equipment Replacement Fund
29,000 29,000Total
Friday, November 11, 2016
45
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief/IT
2017 2021thru Department Police
Description
Building Video Server hardware and associated software is used to store video recorded by the cameras in and around the police department
including interview rooms as well as booking. We record approximately 6 TB of video every 2-3 weeks. Large amounts of storage are required for
30 days of archival storage on the server itself.
Project #01-ERP-0218
Priority n/a
Justification
Maintenance agreement with software vendor needs to be renewed every three years. Computer hardware should be refreshed around the same
time to minimize drive failure and take advantage of new storage technology.
Budget Impact/Other
Variance from 20 year plan - New item. Current equipment was purchased with DTF funding as will the 2015 replacement. Beginning in 2019 it
will be funded with ERP funds.
Estimate salvage/resale value on replaced item: $-0-
Useful Life 4 years
Project Name Building Video Server Category Equipment
Type Equipment
Future
Total Project Cost:$85,000
Total2017 2018 2019 2020 2021Expenditures
17,00017,000Equipment
17,000 17,000Total
Total2017 2018 2019 2020 2021Funding Sources
17,00017,000Equipment Replacement Fund
17,000 17,000Total
Friday, November 11, 2016
46
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief
2017 2021thru Department Police
Description
The police department video server is used to store evidentiary video and audio data. Rules pertaining to criminal procedure, and laws regarding
data privacy and retention place requirements on the Police Department to store and manage the data for varying lengths of time.
The current data storage solution was designed for squad car video only and is near capacity. The storage solution is also not currently designed to
efficiently back up data and is potentially subject to data loss from environmental factors such as drive failure and unsuited fire suppression systems
Project #01-ERP-0219
Priority n/a
Justification
The server is needed to maintain evidentiary squad car video and audio based upon State of Minnesota statutes and rules for varying lengths of
time. The current storage solution is near capacity and is not being backed up in a manner suitably protecting it from loss. The current storage
solution will not facilitate data storage of body worn camera video data and data retention.
A properly designed and implemented video data storage server will protect data from potential loss and corruption. Maintenance of the video data
storage server will have yearly associated costs that need to be accounted for.
Budget Impact/Other
Cost of video data storgae server: $115,000.00
Cost of yearly maintenance for video data storgae server: $10,000.00/year
Useful Life 5 years
Project Name PD - Video Data Server Category Equipment
Type Equipment
Future
Total Project Cost:$165,000
Total2017 2018 2019 2020 2021Expenditures
145,000115,000 10,000 10,000 10,000Equipment
115,000 10,000 10,000 10,000 145,000Total
Total2017 2018 2019 2020 2021Funding Sources
145,000115,000 10,000 10,000 10,000Equipment Replacement Fund
115,000 10,000 10,000 10,000 145,000Total
Friday, November 11, 2016
47
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief/IT
2017 2021thru Department Police
Description
Mobile Data Computers are used in the squad cars to receive calls for service from dispatch, query information from criminal justice databases, and
facilitate communication between squad cars.
Current equipment: 11 - Data 911 Computers purchased in 2014
Project #01-ERP-0220
Priority n/a
Justification
Mobile Data Computers have a limited life expectancy. The computers facilitate the basic response to emergency calls for service to which police
officers respond. Vital information is forwarded to officers via the mobile data computers. Officers complete investigative reports, issue traffic
related warnings and citations, and process arrest incidents from the mobile data computers.
As technology evolves the officers must be able to access information using up to date computers that can process the large amount of data and
applications. Mobile data computers are currently used to host the squad car video camera system and have the potential to be integrated with a
possible body worn camera.
Budget Impact/Other
2016 - Variance from 20 year plan - Change in replacement year to accurately reflect life expectancy in relation to when the computers were
purchased. Change in budgeted amount to reflect past and anticipated costs.
Useful Life 5 years
Project Name Mobile Data Computers Category Equipment
Type Equipment
Future
Total Project Cost:$290,000
Total2017 2018 2019 2020 2021Expenditures
65,00065,000Equipment
65,000 65,000Total
Total2017 2018 2019 2020 2021Funding Sources
65,00065,000Equipment Replacement Fund
65,000 65,000Total
Friday, November 11, 2016
48
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief/IT
2017 2021thru Department Police
Description
LETG - Records Management System was purchased at the end of 2012. This maintains all police records and reports. Zurcher Technologies
acquired LETG in 2016 unexpectedly. We anticipate LETG will not be supported by 2020.
Project #01-ERP-0221
Priority n/a
Justification
A new RMS system may be needed by 2020 as the current system will likely not be supported by the new company.
Budget Impact/Other
Current cost to maintain system is $26,989 anually.
Useful LifeProject Name Records Management System Category Equipment
Type Equipment
Future
Total Project Cost:$150,000
Total2017 2018 2019 2020 2021Expenditures
150,000150,000Equipment
150,000 150,000Total
Total2017 2018 2019 2020 2021Funding Sources
150,000150,000Equipment Replacement Fund
150,000 150,000Total
Friday, November 11, 2016
49
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Police Chief
2017 2021thru Department Police
Description
The squad cars must have reliable wireless cellular solutions in order for the mobile data comupters to communicate with the numerous criminal
justice databases that officers must access throughout daily patrol functions.
Project #01-ERP-0223
Priority n/a
Justification
The current aircard solutions and Mifi wireless modems are not specifically designed for continuous law enforcement activies. The purposed
Cradlepoint wireless solution would provide a stable wireless solution with mil-spec hardware designed to withstand the harsh vehicle conditions.
Budget Impact/Other
Useful Life 4 years
Project Name Squad Car Wireless Solution Category Equipment
Type Equipment
Future
Total Project Cost:$12,000
Total2017 2018 2019 2020 2021Expenditures
12,00012,000Equipment
12,000 12,000Total
Total2017 2018 2019 2020 2021Funding Sources
12,00012,000Equipment Replacement Fund
12,000 12,000Total
Friday, November 11, 2016
50
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Bldg/Equip Ser
Description
Pickup used by various divisions of Public Works.
Project #01-ERP-0710
Priority n/a
Justification
Light hauling and transportation for supervisors. Maintenance garage service vehicle.
Budget Impact/Other
Variance from 20 year plan - move up from 2009 to 2008 - Fire Dept. has requested to acquire surplus pickup for its use by daytime responders.
Estimate salvage/resale value on replaced item: $1,500
Useful Life 10 years
Project Name 4X4 1/2 Ton Truck Category Vehicles
Type Equipment
Future
Total Project Cost:$96,700
Total2017 2018 2019 2020 2021Expenditures
31,30031,300Vehicles
31,300 31,300Total
Total2017 2018 2019 2020 2021Funding Sources
31,30031,300Equipment Replacement Fund
31,300 31,300Total
Friday, November 11, 2016
51
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Bldg/Equip Ser
Description
Scan kit to assist in diagnosing repairs needed on the fleets larger trucks.
Project #01-ERP-0714
Priority 1 Urgent
Justification
Having the scan tool will provide the in-house mechanics to pull the codes off the trucks and make the repairs. We will not have to send the truck
to an outside source for diagnosis.
Budget Impact/Other
Useful Life 10 years
Project Name PW - Truck Scan Kit Category Vehicles
Type Equipment
Future
Total Project Cost:$10,000
Total2017 2018 2019 2020 2021Expenditures
10,00010,000Equipment
10,000 10,000Total
Total2017 2018 2019 2020 2021Funding Sources
10,00010,000Equipment Replacement Fund
10,000 10,000Total
Friday, November 11, 2016
52
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Parks/Forestry
Description
Trucks used by Parks Division of Public Works.
Current vehicles: 2012 Ford F350 4X4 (#801) & 2012 Ford F350 4X4 (#802)
Project #01-ERP-0801
Priority n/a
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: $
Useful Life 8 years
Project Name 4x4 3/4Ton Trucks (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$313,800
Total2017 2018 2019 2020 2021Expenditures
85,20085,200Vehicles
85,200 85,200Total
Total2017 2018 2019 2020 2021Funding Sources
85,20085,200Equipment Replacement Fund
85,200 85,200Total
Friday, November 11, 2016
53
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Parks/Forestry
Description
Truckster used by Parks Division of Public Works for ballfield and parks maintenance.
Current equipment: 1996 Toro Workman (#818), 2004 Toro Workman 3200 (#820), 2014 Toro Electric Workman (#821)
Project #01-ERP-0807
Priority n/a
Justification
Park maintenance, ballfield grooming and weed spraying.
Budget Impact/Other
Variance from 20 year plan -
Estimate salvage/resale value on replaced item: (3) $1,400 each
2016-Decreased useful life from 15 years to 10 years
Useful Life 10 years
Project Name Trucksters (3)Category Equipment
Type Equipment
Future
Total Project Cost:$145,440
Total2017 2018 2019 2020 2021Expenditures
34,20034,200Equipment
34,200 34,200Total
Total2017 2018 2019 2020 2021Funding Sources
34,20034,200Equipment Replacement Fund
34,200 34,200Total
Friday, November 11, 2016
54
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Parks/Forestry
Description
Large turf mower (11' cutting width) used by Parks Division of Public Works.
Current equipment: 2010 Toro Groundmaster (#825)
Project #01-ERP-0810
Priority n/a
Justification
Required to efficiently mow large parks.
Budget Impact/Other
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
Useful Life 10 years
Project Name Large Turf Mower Category Equipment
Type Equipment
Future
Total Project Cost:$332,300
Total2017 2018 2019 2020 2021Expenditures
92,70092,700Equipment
92,700 92,700Total
Total2017 2018 2019 2020 2021Funding Sources
92,70092,700Equipment Replacement Fund
92,700 92,700Total
Friday, November 11, 2016
55
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Parks/Forestry
Description
Stump cutter used by Parks Division of Public Works.
Current equipment: 1997 Vermeer Stump Cutter (#832)
Project #01-ERP-0812
Priority n/a
Justification
Chipping out stumps of trees removed from city property.
Budget Impact/Other
Variance from 20 year plan - extend to 20 years to reflect actual.
Estimate salvage/resale value on replaced item: $1,800
2016-Increased estimated replacement cost from $21,200 to $45,000
Useful Life 20 years
Project Name Stump Cutter Category Equipment
Type Equipment
Future
Total Project Cost:$45,000
Total2017 2018 2019 2020 2021Expenditures
45,00045,000Equipment
45,000 45,000Total
Total2017 2018 2019 2020 2021Funding Sources
45,00045,000Equipment Replacement Fund
45,000 45,000Total
Friday, November 11, 2016
56
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Parks/Forestry
Description
Used to haul multiple riding mowers
Current trailor: Unit #845, 1997 Remackle Trailer
Project #01-ERP-0814
Priority n/a
Justification
Allows one truck to pull two riding mowers to parks
Budget Impact/Other
Variance from 20 year plan - Move up one year.
Estimate salvage/resale value on replaced item: $
2016-Increased estimated replacement cost from $2,200 to $10,000
Useful Life 15 years
Project Name Trailer Flatbed Category Equipment
Type Equipment
Future
Total Project Cost:$11,400
Total2017 2018 2019 2020 2021Expenditures
10,00010,000Equipment
10,000 10,000Total
Total2017 2018 2019 2020 2021Funding Sources
10,00010,000Equipment Replacement Fund
10,000 10,000Total
Friday, November 11, 2016
57
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Parks/Forestry
Description
Current equipment: 2004 Bobcat 463 (#833)
Project #01-ERP-0815
Priority n/a
Justification
Budget Impact/Other
Variance from 20 year plan - new item in 2004.
Estimate salvage/resale value on replaced item: $
Useful Life 12 years
Project Name Skid Loader Category Equipment
Type Equipment
Future
Total Project Cost:$77,600
Total2017 2018 2019 2020 2021Expenditures
32,00032,000Equipment
32,000 32,000Total
Total2017 2018 2019 2020 2021Funding Sources
32,00032,000Equipment Replacement Fund
32,000 32,000Total
Friday, November 11, 2016
58
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Parks/Forestry
Description
Use by Public Works for snow removal, skating rinks, sweeping, ballfield maintenance and transportation of people and materials.
Current vehicle: 2010 Bobcat (#815)
Project #01-ERP-0816
Priority n/a
Justification
New machine.
Budget Impact/Other
Variance from 20 year plan - New item which replaces one tractor.
Estimate salvage/resale value on replaced item: $
Useful Life 8 years
Project Name Toolcat Category Equipment
Type Equipment
Future
Total Project Cost:$295,100
Total2017 2018 2019 2020 2021Expenditures
63,30063,300Equipment
63,300 63,300Total
Total2017 2018 2019 2020 2021Funding Sources
63,30063,300Equipment Replacement Fund
63,300 63,300Total
Friday, November 11, 2016
59
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
Truck used in the Street Division of Public Works.
Current vehicle: 2006 Ford F350 Pickup (#307)
Project #01-ERP-0302
Priority n/a
Justification
Plows alleys in winter, light hauling, snow removal and transportation.
Budget Impact/Other
Variance from 20 year plan - change from 4x4 to 4x2 truck. Reduce cost to $30,500. Move up from 2008 to 2006. Extend useful life from 8 to 12
years.
Estimate salvage/resale value on replaced item: $3,500
Useful Life 12 years
Project Name 4x2 1 Ton Dump Truck Category Equipment
Type Equipment
Future
Total Project Cost:$162,900
Total2017 2018 2019 2020 2021Expenditures
54,60054,600Equipment
54,600 54,600Total
Total2017 2018 2019 2020 2021Funding Sources
54,60054,600Equipment Replacement Fund
54,600 54,600Total
Friday, November 11, 2016
60
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
Single axle dump truck used by various division of Public Works.
Current vehicles: 2001 Ford L7501 (#313), 2005 Freightliner M2 106 (#312) and 2011 Freightliner MZ-1068 (#311)
Project #01-ERP-0305
Priority n/a
Justification
Vehicle used for heavy hauling, snow plowing and sanding.
Moved single axel dump truck due in 2018 to a tandem axel dump truck in 2018. Done to increase snow hauling and other material hauling
capacity.
Budget Impact/Other
Variance from 20 year plan - Move 1 truck from single axle to tandem axel to increase hauling capacity for snow and road materials.
Estimate salvage/resale value on replaced item: $4,500 each
We will then have 2 single axel (change from 3) dump trucks and 2 (change from 1) tandem axel dump trucks.
Useful Life 17 years
Project Name Single Axle Dump Truck (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$550,100
Total2017 2018 2019 2020 2021Expenditures
132,100132,100Vehicles
132,100 132,100Total
Total2017 2018 2019 2020 2021Funding Sources
132,100132,100Equipment Replacement Fund
132,100 132,100Total
Friday, November 11, 2016
61
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
Dump truck used in Streets Division of Public Works.
Current vehicles: 1998 Ford LT8500 Tandem (#314)
Project #01-ERP-0306
Priority n/a
Justification
Trucks used for heavy hauling, snow plowing and sanding.
To increase snow and other material hauling capacity. Moved from a single axel dump truck in 2018 to a tandem axel truck in 2018.
Budget Impact/Other
Variance from 20 year plan - Move from 2018 to 2017. Moved 1 single axel dump truck due in 2018 to a tandem axel dump truck due in 2018.
Estimate salvage/resale value on replaced item: $-0-
2016-Increased estimated replacement costs by $50,000 each year
Useful Life 17 years
Project Name Tandem Dump Truck (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$1,062,000
Total2017 2018 2019 2020 2021Expenditures
460,000225,000 235,000Vehicles
225,000 235,000 460,000Total
Total2017 2018 2019 2020 2021Funding Sources
460,000225,000 235,000Equipment Replacement Fund
225,000 235,000 460,000Total
Friday, November 11, 2016
62
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
Street sweeper used by Streets Division for sweeping streets and parking lots.
Current equipment: 2001 Elgin Pelican SE (#327)
Project #01-ERP-0311
Priority n/a
Justification
Street sweeping, event clean-up, spring sand removal.
Budget Impact/Other
Variance from 20 year plan - Move from 2021 to 2019
Estimate salvage/resale value on replaced item: $12,000
Useful Life 15 years
Project Name Sweeper Category Equipment
Type Equipment
Future
Total Project Cost:$271,700
Total2017 2018 2019 2020 2021Expenditures
156,400156,400Equipment
156,400 156,400Total
Total2017 2018 2019 2020 2021Funding Sources
156,400156,400Equipment Replacement Fund
156,400 156,400Total
Friday, November 11, 2016
63
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
Used by Street Department for asphalt repair and resurfacing.
Current equipment: 1989 Ingersoll Rand Roller (#330)
Project #01-ERP-0312
Priority n/a
Justification
Budget Impact/Other
Variance from 20 year plan - Move from 2016 to 2017.
Estimate salvage/resale value on replaced item: $
Useful Life 20 years
Project Name PW - Roller Category Equipment
Type Equipment
Future
Total Project Cost:$127,900
Total2017 2018 2019 2020 2021Expenditures
45,90045,900Equipment
45,900 45,900Total
Total2017 2018 2019 2020 2021Funding Sources
45,90045,900Equipment Replacement Fund
45,900 45,900Total
Friday, November 11, 2016
64
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
Line striper.
Current equipment: 1993 Line Striper A1990 (#352)
Project #01-ERP-0313
Priority n/a
Justification
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
Useful Life 12 years
Project Name Striper Category Equipment
Type Equipment
Future
Total Project Cost:$27,200
Total2017 2018 2019 2020 2021Expenditures
11,20011,200Equipment
11,200 11,200Total
Total2017 2018 2019 2020 2021Funding Sources
11,20011,200Equipment Replacement Fund
11,200 11,200Total
Friday, November 11, 2016
65
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
Asphalt paver used by Streets Division of Public Works.
Current equipment: 1994 Caterpillar AD200B Paver (#337)
Project #01-ERP-0314
Priority n/a
Justification
Paving streets and parking lots.
Budget Impact/Other
Variance from 20 year plan. Move from 2016 to 2018
Estimate salvage/resale value on replaced item: $500
2016 - Move from 2018 to 2017, decrease useful life from 20 to 15 years, update estimated cost from 48,800 to $118,000
Useful Life 15 years
Project Name PW - Asphalt Paver Category Equipment
Type Equipment
Future
Total Project Cost:$238,000
Total2017 2018 2019 2020 2021Expenditures
118,000118,000Equipment
118,000 118,000Total
Total2017 2018 2019 2020 2021Funding Sources
118,000118,000Equipment Replacement Fund
118,000 118,000Total
Friday, November 11, 2016
66
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
Snow blower used by the Streets Division of Public Works for snow removal in the downtown area.
Current equipment: 1996 SnoGo WK800 (#344)
Project #01-ERP-0315
Priority n/a
Justification
Blowing and loading snow off Mainstreet into trucks.
The current Sno-Go is a 1996 model and has served its useful life. The street department must have a dependable snow blower for the removal of
snow in the downtown area. This is a two stage blower fed with augers, which will ensure the completion of the work required.
In 2014 we purchased a Fair Snocrete snow blower for $71,489. This machine does not perform its function for our needs to remove snow from the
downtown area. Public Works would like to trade-in or sell this machine and purchase a Sno-Go machine, which has proven to be the one that
works for our application. We are currently depending on a 1996 Sno-Go to handle the work.
Budget Impact/Other
Variance from 20 year plan. Move from 2016 to 2014. Reduce amount to purchase hydraulic powered blower.
Item no purchased in 2014 and did not get put back in the ERP. Now scheduled for 2017. Originally budgeted for $65,000, complete replacement
now estimated at $160,000
Estimate salvage/resale value on replaced item: $4,500
Useful Life 20 years
Project Name Snow Blower Category Equipment
Type Equipment
Future
Total Project Cost:$342,000
Total2017 2018 2019 2020 2021Expenditures
160,000160,000Equipment
160,000 160,000Total
Total2017 2018 2019 2020 2021Funding Sources
160,000160,000Equipment Replacement Fund
160,000 160,000Total
Friday, November 11, 2016
67
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Public Works: Streets/Traffic
Description
A trailer that hauls up to 2.5 tons of hot asphalt and heats the mix to keep it workable.
Project #01-ERP-0318
Priority n/a
Justification
Current asphalt hot mix heating box insert sits in the back of a truck and is too small, 1 ton capacity. Sits too high to be handled easily. The trailer
will hold more mix, reducing the trips to the asphalt plant, and will work better ergonomically.
Budget Impact/Other
Variance from 20 year plan - New item.
2016 - Upgrading from mounted unit to trailer
Estimate salvage/resale value on replaced item: $-0-.
Useful Life 12 years
Project Name Asphalt Hot Mix Heating Box - Trailer Category Equipment
Type Equipment
Future
Total Project Cost:$52,600
Total2017 2018 2019 2020 2021Expenditures
15,00015,000Equipment
15,000 15,000Total
Total2017 2018 2019 2020 2021Funding Sources
15,00015,000Equipment Replacement Fund
15,000 15,000Total
Friday, November 11, 2016
68
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Refuse
Description
Dumpster swap loader refuse truck used to haul bulk pick-up items, refuse from parks and downtown, scrap metal and hauling waster and snow.
Utilized by Refuse for hauling dumpsters and Forestry for chipping trees.
Cost shared Refuse and Eqiupment Replacement Fund as follows:
75% Refuse
25% ER Fund (Parks/Forrestry)
Current equipment: 1993 International LP4700 (#810)
Project #01-ERP-0803
Priority n/a
Justification
Needed for waste and snow hauling.
Budget Impact/Other
Variance from 20 year plan -
Estimate salvage/resale value on replaced item: $
Useful Life 20 years
Project Name Swap Loader Category Equipment
Type Equipment
Future
Total Project Cost:$346,000
Total2017 2018 2019 2020 2021Expenditures
95,00095,000Equipment
95,000 95,000Total
Total2017 2018 2019 2020 2021Funding Sources
23,75023,750Equipment Replacement Fund
71,25071,250RF - Refuse Fund
95,000 95,000Total
Friday, November 11, 2016
69
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Refuse
Description
Refuse truck used by Refuse Utility Division of Public Works.
Current vehicle: 2005 Peterbilt Rapid Rail (#901) & 2011 Freightliner Rapid Rail (#900)
Project #01-ERP-0900
Priority n/a
Justification
Residential waste pick up.
Budget Impact/Other
Variance from 20 year plan - increase cost to reflect actual
Estimate salvage/resale value on replaced item: $18,000
Useful Life 10 years
Project Name Refuse Truck (RAP-R) (2)Category Vehicles
Type Equipment
Future
Total Project Cost:$1,462,600
Total2017 2018 2019 2020 2021Expenditures
270,300270,300Vehicles
270,300 270,300Total
Total2017 2018 2019 2020 2021Funding Sources
270,300270,300RF - Refuse Fund
270,300 270,300Total
Friday, November 11, 2016
70
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Refuse
Description
Refuse truck used by Refuse Utility Division of Public Works.
Current vehicle: 1996 Freightliner FL70 (#903)
Project #01-ERP-0901
Priority n/a
Justification
Residential waste pick up.
Budget Impact/Other
Variance from 20 year plan. Move from 2016 to 2017
Estimate salvage/resale value on replaced item: $9,000
Useful Life 15
Project Name Refuse Truck (Rear-L)Category Vehicles
Type Equipment
Future
Total Project Cost:$238,100
Total2017 2018 2019 2020 2021Expenditures
101,600101,600Vehicles
101,600 101,600Total
Total2017 2018 2019 2020 2021Funding Sources
101,600101,600RF - Refuse Fund
101,600 101,600Total
Friday, November 11, 2016
71
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Sewer
Description
Single axle truck used by Water/Sewer Divisions of Public Works.
2016 - Change to dual axel Vactor jet truck
Current equipment: 2001 Sterling Vac-Con
Project #01-ERP-0552
Priority n/a
Justification
Cleaning sewer and catch basins.
2016 - Changed purchase date from 2020 to 2017 due to frequent breakdown of the current jetter.
Budget Impact/Other
Variance from 20 year plan - increase cost from $180,000 to $350,000 to reflect actual replacement cost.
Estimate salvage/resale value on replaced item: $25,000
2016 - Cost increase by 75,000
Useful Life 20 years
Project Name Jet Vactor Category Equipment
Type Equipment
Future
Total Project Cost:$425,000
Total2017 2018 2019 2020 2021Expenditures
425,000425,000Equipment
425,000 425,000Total
Total2017 2018 2019 2020 2021Funding Sources
425,000425,000SF - Sanitary Sewer Fund
425,000 425,000Total
Friday, November 11, 2016
72
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Sewer
Description
Portable generator used by Water/Sewer Divisions of Public Works.
2016 - Increase cost from 26k to 36k due to updated information
Current equipment: 1997 Kohler Generator, 2008 Caterpillar C15 (#537)
Project #01-ERP-0555
Priority n/a
Justification
Emergency back up generator for lift stations and pumps, off site power for lights and welding.
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $2,500
2016 - Increase cost from 26k to 36k due to updated information
Useful Life 25 years
Project Name Generator (2)Category Equipment
Type Equipment
Future
Total Project Cost:$79,000
Total2017 2018 2019 2020 2021Expenditures
36,00036,000Equipment
36,000 36,000Total
Total2017 2018 2019 2020 2021Funding Sources
36,00036,000SF - Sanitary Sewer Fund
36,000 36,000Total
Friday, November 11, 2016
73
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Sewer
Description
SCADA upgrades
Project #01-ERP-0559
Priority 1 Urgent
Justification
SCADA is outdated, upgrade or replacement needed for PLC, software and radio parts
Budget Impact/Other
Useful Life 10 years
Project Name SCADA Upgrade Category Equipment
Type Equipment
Future
Total Project Cost:$160,000
Total2017 2018 2019 2020 2021Expenditures
160,000160,000Equipment
160,000 160,000Total
Total2017 2018 2019 2020 2021Funding Sources
70,00070,000SF - Sanitary Sewer Fund
90,00090,000WF - Water Fund
160,000 160,000Total
Friday, November 11, 2016
74
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Water
Description
Trucks used by Water Department.
2016 - Changed from 1/2 ton truck to 3/4 ton truck
Current vehicle: 2007 Chevrolet Pickup
Project #01-ERP-0500
Priority n/a
Justification
Budget Impact/Other
Variance from 20 year plan - none
Estimate salvage/resale value on replaced item: $
Useful Life 10 years
Project Name 3/4 Ton Truck Category Vehicles
Type Equipment
Future
Total Project Cost:$88,500
Total2017 2018 2019 2020 2021Expenditures
32,00032,000Vehicles
32,000 32,000Total
Total2017 2018 2019 2020 2021Funding Sources
32,00032,000WF - Water Fund
32,000 32,000Total
Friday, November 11, 2016
75
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN Contact Public Works Director
2017 2021thru Department Water
Description
Used to convert gas Chlorine to liquid Sodium Hypochlorite
Project #01-ERP-0509
Priority 1 Urgent
Justification
Chlorine gas is extremely danferous and corrosive. Liquid bleach is easy to contain and work with.
Budget Impact/Other
Useful Life 10 years
Project Name Water Treatment Plant Category Equipment
Type Equipment
Future
Total Project Cost:$100,000
Total2017 2018 2019 2020 2021Expenditures
100,000100,000Equipment
100,000 100,000Total
Total2017 2018 2019 2020 2021Funding Sources
100,000100,000WF - Water Fund
100,000 100,000Total
Friday, November 11, 2016
76
TWENTY‐YEAR
REPLACEMENT SCHEDULE
77
78
11
-
N
o
v
-
1
6
E
Q
U
I
P
M
E
N
T
R
E
P
L
A
C
E
M
E
N
T
S
C
H
E
D
U
L
E
N
e
t
G
e
n
e
r
a
l
F
u
n
d
2
0
Y
e
a
r
A
v
e
r
a
g
e
:
$9
1
4
,
6
0
0
IN
F
L
A
T
I
O
N
F
A
C
T
O
R
-
3
%
RE
P
L
EQ
U
I
P
M
E
N
T
/
V
E
H
I
C
L
E
S
Y
R
S
2
0
1
7
2
0
1
8
2
0
1
9
2
0
2
0
2
0
2
1
2
0
2
2
2
0
2
3
2
0
2
4
2
0
2
5
2
0
2
6
2
0
2
7
2
0
2
8
2
0
2
9
2
0
3
0
2
0
3
1
2
0
3
2
2
0
3
3
2
0
3
4
2
0
3
5
2
0
3
6
AC
T
I
V
I
T
Y
C
E
N
T
E
R
ER
P
-
0
3
2
S
o
u
n
d
S
y
s
t
e
m
15
15
,
0
0
0
24,000
ER
P
-
0
3
5
F
l
o
o
r
S
c
r
u
b
b
e
r
10
6,
7
0
0
9,000
SU
B
T
O
T
A
L
15
,
0
0
0
6,
7
0
0
24,000 9,000
AR
T
S
C
E
N
T
E
R
ER
P
-
1
1
0
0
C
op
y
M
a
c
h
i
n
e
(
l
e
a
s
e
d
)
ER
P
-
1
1
0
1
C
a
r
p
e
t
E
x
t
r
a
c
t
o
r
1
0
5
,
2
0
0
7,000
ER
P
-
1
1
0
2
K
i
t
c
h
e
n
C
a
t
e
r
i
n
g
E
q
u
i
p
m
e
n
t
1
2
7,
1
0
0
ER
P
-
1
1
0
3
V
i
d
e
o
C
a
m
e
r
a
U
p
d
a
t
e
s
5
4
,
3
0
0
5
,
0
0
0
5
,
8
0
0
ER
P
-
1
1
0
4
T
h
e
a
t
e
r
P
r
o
j
e
c
t
o
r
5
1
7
,
1
0
0
1
9
,
8
0
0
2
2
,
9
0
0
ER
P
-
1
1
0
5
C
o
m
m
u
n
i
t
y
R
o
o
m
A
/
V
7
1
3
,
5
0
0
16
,
6
0
0
ER
P
-
1
1
0
6
D
i
g
i
t
a
l
I
n
f
o
r
m
a
t
i
o
n
S
i
g
n
5
2
,
3
0
0
2
,
7
0
0
3
,
1
0
0
ER
P
-
1
1
0
7
T
h
e
a
t
e
r
P
r
o
j
e
c
t
i
o
n
S
c
r
e
e
n
1
0
6,
7
0
0
9,000
ER
P
-
1
1
0
8
T
h
e
a
t
e
r
P
r
e
s
e
n
t
a
t
i
o
n
M
i
c
r
op
h
o
n
e
6
7
,
1
0
0
8
,
5
0
0
1
0
,
2
0
0
ER
P
-
1
1
0
9
F
l
o
o
r
S
c
r
u
b
b
e
r
1
0
10
,
8
0
0
17
,
1
0
0
3
2
,
4
0
0
1
9
,
8
0
0
1
7
,
5
0
0
7
,
1
0
0
7
,
7
0
0
3
1
,
4
0
0
1
6
,
6
0
0
1
5
,
9
0
0
1
0
,
2
0
0
9
,
0
0
0
CO
M
M
U
N
I
T
Y
S
E
R
V
I
C
E
S
-
C
I
T
Y
C
L
E
R
K
ER
P
-
0
0
8
D
o
c
u
m
e
n
t
M
g
m
t
.
S
c
a
n
n
e
r
(
2
)
4
11
,
3
0
0
12
,
7
0
0
14
,
3
0
0
16,000
ER
P
-
0
1
0
E
l
e
c
t
i
o
n
B
o
o
t
h
s
20
ER
P
-
0
1
1
E
l
e
c
t
i
o
n
E
q
u
i
p
m
e
n
t
10
EQ
U
I
P
M
E
N
T
S
U
B
T
O
T
A
L
11
,
3
0
0
12
,
7
0
0
14
,
3
0
0
16,000
CO
M
M
U
N
I
T
Y
S
E
R
V
I
C
E
S
-
I
T
ER
P
-
0
0
3
C
i
t
y
H
a
l
l
-
N
e
t
w
o
r
k
U
p
g
r
a
d
e
1
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,000 22,000 22,000 22,000 22,000
ER
P
-
0
0
4
P
h
o
n
e
S
y
s
t
e
m
8
89
,
6
0
0
11
0
,
7
0
0
EP
R
-
0
0
5
F
i
n
a
n
c
i
a
l
S
o
f
t
w
a
r
e
7
ER
P
-
0
0
6
C
o
m
p
u
t
e
r
s
3-
5
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
3
0
,
0
0
0
ER
P
-
0
0
9
N
e
t
w
o
r
k
I
n
f
r
a
s
t
r
u
c
t
u
r
e
U
p
g
r
a
d
e
15
23
,
4
0
0
ER
P
-
0
1
2
C
o
r
e
N
e
t
w
o
r
k
S
w
i
t
c
h
6
17
,
0
0
0
20
,
0
0
0
24
,
0
0
0
ER
P
-
0
0
1
3
W
i
-
F
i
a
n
d
C
e
l
l
u
l
a
r
5-
7
6,
0
0
0
6,
0
0
0
6,
0
0
0
6,
0
0
0
6,
0
0
0
6,
0
0
0
6,
0
0
0
6,000 6,000 6,000
ER
P
-
0
1
4
D
i
s
t
r
i
b
u
t
i
o
n
N
e
t
w
o
r
k
S
w
i
t
c
h
e
s
5
50
,
0
0
0
57
,
0
0
0
ER
P
-
0
0
1
5
B
a
c
ku
p
S
e
r
v
e
r
4
6
6
,
0
0
0
66
,
0
0
0
66
,
0
0
0
66
,
0
0
0
66,000 66,000
ER
P
-
2
1
1
P
o
l
i
c
e
-
N
e
t
w
o
r
k
S
e
r
v
e
r
(
3
)
3
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,
0
0
0
2
2
,000 22,000 22,000 22,000 22,000
EQ
U
I
P
M
E
N
T
S
U
B
T
O
T
A
L
14
0
,
0
0
0
9
7
,
0
0
0
7
4
,
0
0
0
1
9
6
,
0
0
0
7
4
,
0
0
0
1
0
3
,
4
0
0
1
6
3
,
6
0
0
1
4
6
,
0
0
0
1
5
1
,
0
0
0
8
0
,
0
0
0
7
4
,
0
0
0
1
4
6
,
0
0
0
7
4
,
0
0
0
8
0
,
0
0
0
2
0
8
,
7
0
0
1
4
6
,
0
0
0
7
4
,
0
00 80,000 74,000 146,000
FI
R
E
ER
P
-
1
0
0
T
e
l
e
-
S
q
u
i
r
t
E-
2
10
9
0
0
,
0
0
0
1,
2
0
0
,
0
0
0
ER
P
-
1
0
1
F
i
r
e
P
u
m
p
e
r
E-
3
20
72
2
,
4
0
0
ER
P
-
1
0
3
D
u
t
y
C
h
i
e
f
V
e
h
i
c
l
e
5
ER
P
-
1
0
5
Q
u
i
c
k
A
t
t
a
c
k
P
u
m
p
e
r
/
R
e
s
c
u
e
R
-
8
10
3
1
4
,
5
0
0
422,600
ER
P
-
1
0
6
A
e
r
i
a
l
T
r
u
c
k
L-
9
20
5
4
,
2
1
7
5
4
,
2
1
7
1,
5
7
2
,
0
0
0
VE
H
I
C
L
E
S
S
U
B
T
O
T
A
L
9
5
4
,
2
1
7
5
4
,
2
1
7
3
1
4
,
5
0
0
7
2
2
,
4
0
0
1
,
2
0
0
,
0
0
0
1
,
5
7
2
,
0
0
0
4
2
2
,
6
0
0
ER
P
-
1
0
7
A
i
r
C
o
m
p
r
e
s
s
o
r
1
5
54
,
4
0
0
ER
P
-
1
0
8
B
r
e
a
t
h
i
n
g
A
p
p
a
r
a
t
u
s
(
4
5
)
(
S
C
B
A
)
1
0
25
0
,
0
0
0
336,000 336,000
ER
P
-
1
0
9
E
x
t
r
i
c
a
t
i
o
n
T
o
o
l
(
2
)
1
0
2
7
,
4
0
0
3
0
,
0
0
0
36
,
9
0
0
4
0
,
3
0
0
ER
P
-
1
1
2
T
h
e
r
m
a
l
I
m
a
g
i
n
g
C
a
m
e
r
a
(
2
)
1
0
1
2
,
9
0
0
1
5
,
4
0
0
1
7
,
4
0
0
2
0
,
7
0
0
ER
P
-
1
1
3
E
m
e
r
g
e
n
c
y
P
r
e
p
a
r
e
d
n
e
s
s
S
i
r
e
n
2
0
38
,
5
0
0
ER
P
-
1
1
4
F
l
o
o
r
S
c
r
u
b
b
e
r
1
2
20
,
3
0
0
ER
P
-
2
1
5
R
a
d
i
o
s
-
P
o
r
t
a
b
l
e
&
M
o
b
i
l
e
1
0
-
1
5
36
1
,
0
0
0
361,000 `
EQ
U
I
P
M
E
N
T
S
U
B
T
O
T
A
L
1
2
,
9
0
0
2
7
,
4
0
0
3
0
,
0
0
0
3
7
6
,
4
0
0
2
5
0
,
0
0
0
3
8
,
5
0
0
3
7
,
7
0
0
3
6
,
9
0
0
5
4
,
4
0
0
4
0
,
3
0
0
3
8
1
,
7
0
0
3
3
6
,
0
0
0
3
3
6
,
0
0
0
79
RE
P
L
EQ
U
I
P
M
E
N
T
/
V
E
H
I
C
L
E
S
Y
R
S
2
0
1
7
2
0
1
8
2
0
1
9
2
0
2
0
2
0
2
1
2
0
2
2
2
0
2
3
2
0
2
4
2
0
2
5
2
0
2
6
2
0
2
7
2
0
2
8
2
0
2
9
2
0
3
0
2
0
3
1
2
0
3
2
2
0
3
3
2
0
3
4
2
0
3
5
2
0
3
6
PO
L
I
C
E
ER
P
-
2
0
0
S
q
u
a
d
#
1
#
2
0
7
3
4
9
,
0
0
0
53
,
7
0
0
58
,
7
0
0
64
,
0
0
0
70
,
0
0
0
76,600
ER
P
-
2
0
0
S
q
u
a
d
#
2
#
2
0
8
3
4
9
,
0
0
0
53
,
7
0
0
58
,
7
0
0
64
,
0
0
0
70
,
0
0
0
76,600
ER
P
-
2
0
0
S
q
u
a
d
#
3
#
2
0
0
3
49
,
0
0
0
53
,
7
0
0
58
,
7
0
0
64
,
0
0
0
70
,
0
0
0
76,500
ER
P
-
2
0
0
S
q
u
a
d
#
4
#
2
0
2
3
49
,
0
0
0
53
,
7
0
0
58
,
7
0
0
64
,
0
0
0
70
,
0
0
0
76,600
ER
P
-
2
0
0
S
q
u
a
d
#
5
#
2
0
5
3
49
,
0
0
0
53
,
7
0
0
58
,
7
0
0
64
,
0
0
0
70
,
0
0
0
76,500
ER
P
-
2
0
0
S
q
u
a
d
#
6
#
2
0
9
3
49
,
0
0
0
53
,
7
0
0
58
,
7
0
0
64
,
0
0
0
70
,
0
0
0
76,600
ER
P
-
2
0
0
S
q
u
a
d
#
7
#
2
0
6
3
49
,
0
0
0
53
,
7
0
0
58
,
7
0
0
64
,
0
0
0
70
,
0
0
0
76,500
ER
P
-
2
0
1
S
e
r
g
e
a
n
t
V
e
h
i
c
l
e
#
2
0
1
4
49
,
0
0
0
57
,
0
0
0
64
,
0
0
0
72
,
0
0
0
80,000 80,000
ER
P
-
2
0
2
P
a
r
k
i
n
g
V
e
h
i
c
l
e
#
2
1
1
10
53
,
7
0
0
74
,
0
0
0
ER
P
-
2
0
3
P
S
O
U
t
i
l
i
t
y
4
x
4
#
2
1
2
6
55
,
0
0
0
67
,
0
0
0
83
,
0
0
0
96000
ER
P
-
2
0
5
S
W
A
T
V
e
h
i
c
l
e
#
2
4
0
15
77
,
9
0
0
VE
H
I
C
L
E
S
S
U
B
T
O
T
A
L
98
,
0
0
0
2
5
1
,
0
0
0
9
8
,
0
0
0
1
0
7
,
4
0
0
2
1
4
,
8
0
0
1
6
4
,
4
0
0
1
1
7
,
4
0
0
2
4
3
,
1
0
0
1
1
7
,
4
0
0
1
9
2
,
0
0
0
1
9
2
,
0
0
0
1
2
8
,
0
0
0
1
4
0
,
0
0
0
3
6
5
,
0
0
0
2
9
1
,
9
0
0
1
5
3
,
2
0
0
229,700 233,000 80,000 96,000
ER
P
-
2
1
2
S
q
u
a
d
C
a
r
C
a
m
e
r
a
S
y
s
t
e
m
7
65
,
0
0
0
65
,
0
0
0
65,000
ER
P
-
2
1
4
T
a
c
t
i
c
a
l
B
a
l
l
i
s
t
i
c
V
e
s
t
s
(
9
)
5
35
,
0
0
0
41
,
7
0
0
48
,
4
0
0
56,100
ER
P
-
2
1
5
R
a
d
i
o
s
-
P
o
r
t
a
b
l
e
&
M
o
b
i
l
e
7
29
0
,
0
0
0
29
0
,
0
0
0
ER
P
-
2
1
7
T
a
s
e
r
R
e
p
l
a
c
e
m
e
n
t
4
29
,
0
0
0
33
,
6
0
0
37
,
8
0
0
42
,
5
0
0
47,900
ER
P
-
2
1
8
B
u
i
l
d
i
n
g
V
i
d
e
o
S
e
r
v
e
r
4
17
,
0
0
0
17
,
0
0
0
17
,
0
0
0
17
,
0
0
0
ER
P
-
2
1
9
P
D
-
S
q
u
a
d
V
i
d
e
o
S
e
r
v
e
r
5
11
5
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
1
5
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
1
5
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
1
5
,000 10,000 10,000 10,000
ER
P
-
2
2
0
M
o
b
i
l
e
D
a
t
a
C
o
m
p
u
t
e
r
s
7
65
,
0
0
0
82
,
0
0
0
101,000 77,000 77,000
ER
P
-
2
2
3
S
q
u
a
d
C
a
r
e
W
i
r
e
l
e
s
s
S
o
l
u
t
i
o
n
5
1
2
,
0
0
0
EQ
U
I
P
M
E
N
T
S
U
B
T
O
T
A
L
12
,
0
0
0
1
7
9
,
0
0
0
1
5
7
,
0
0
0
1
0
,
0
0
0
1
0
,
0
0
0
4
3
,
6
0
0
4
6
3
,
7
0
0
1
0
,
0
0
0
1
0
,
0
0
0
1
9
4
,
8
0
0
2
7
,
0
0
0
1
6
3
,
4
0
0
1
0
,
0
0
0
3
4
2
,
5
0
0
2
7
,
0
0
0
1
0
,
0
0
0
3
3
7
,
1
0
0
57,900 87,000 87,000
P.
W
.
A
D
M
I
N
ER
P
-
2
1
5
R
a
d
i
o
s
-
P
o
r
t
a
b
l
e
&
M
o
b
i
l
e
P.
W
.
B
L
D
G
.
/
E
Q
U
I
P
M
E
N
T
S
V
C
S
ER
P
-
7
1
0
1
/
2
T
o
n
T
r
u
c
k
10
31
,
3
0
0
42
,
1
0
0
ER
P
-
7
1
1
V
e
h
i
c
l
e
W
a
s
h
e
r
12
8,
3
0
0
11,500
ER
P
-
7
1
2
4
x
4
3
/
4
T
o
n
P
i
c
k
-
u
p
T
r
u
c
k
15
49
,
8
0
0
ER
P
-
7
1
4
S
c
a
n
K
i
t
10
1
0
,
0
0
0
13
,
8
0
0
10
,
0
0
0
3
1
,
3
0
0
8,
3
0
0
13
,
8
0
0
4
2
,
1
0
0
49
,
8
0
0
11,500
P.
W
.
E
N
G
I
N
E
E
R
I
N
G
ER
P
-
7
0
0
E
n
g
i
n
e
e
r
i
n
g
V
a
n
10
28
,
9
0
0
38,800
28
,
9
0
0
38,800
P.
W
.
P
A
R
K
S
&
F
O
R
E
S
T
R
Y
ER
P
-
8
0
0
1
/
2
T
o
n
T
r
u
c
k
10
35
,
4
0
0
47,600
ER
P
-
8
0
1
4
x
4
3
/
4
T
o
n
T
r
u
c
k
8
42
,
6
0
0
54
,
0
0
0
ER
P
-
8
0
1
4
x
4
3
/
4
T
o
n
T
r
u
c
k
8
42
,
6
0
0
54
,
0
0
0
ER
P
-
8
0
2
3
/
4
T
o
n
U
t
i
l
i
t
y
T
r
u
c
k
10
48
,
7
0
0
ER
P
-
8
0
4
L
o
g
T
r
u
c
k
(
5
0
%
w
/
R
e
f
u
s
e
)
15
81
,
8
0
0
ER
P
-
8
0
5
A
e
r
i
a
l
L
i
f
t
20
22
8
,
9
0
0
ER
P
-
8
0
6
T
r
a
c
t
o
r
30
ER
P
-
8
0
7
T
r
u
c
k
s
t
e
r
(
#
8
1
8
)
15
17
,
1
4
0
ER
P
-
8
0
7
T
r
u
c
k
s
t
e
r
(
#
8
2
0
)
15
2
3
,
0
0
0
35,800
ER
P
-
8
0
7
T
r
u
c
k
s
t
e
r
(
#
8
2
1
)
15
1
1
,
2
0
0
17,400
ER
P
-
8
0
8
R
i
d
i
n
g
M
o
w
e
r
(
#
8
2
3
)
8
25
,
3
0
0
32,100
ER
P
-
8
0
8
R
i
d
i
n
g
M
o
w
e
r
(
#
8
2
6
)
8
13
,
9
0
0
17
,
7
0
0
ER
P
-
8
0
9
S
l
o
p
e
M
o
w
e
r
(
#
8
2
8
)
-
-
d
e
l
e
t
e
d
f
r
o
m
E
R
P
1
5
ER
P
-
8
1
0
L
a
r
g
e
T
u
r
f
M
o
w
e
r
(
#
8
2
5
)
10
92
,
7
0
0
12
4
,
6
0
0
ER
P
-
8
1
1
T
u
r
f
S
w
e
e
p
e
r
-
d
e
l
e
t
e
d
f
r
o
m
E
R
P
ER
P
-
8
1
2
S
t
u
m
p
C
u
t
t
e
r
20
4
5
,
0
0
0
ER
P
-
8
1
3
B
r
u
s
h
C
l
i
p
p
e
r
20
43,700
ER
P
-
8
1
4
T
r
a
i
l
e
r
F
l
a
t
b
e
d
15
10
,
0
0
0
ER
P
-
8
1
5
S
k
i
d
L
o
a
d
e
r
12
3
2
,
0
0
0
45
,
6
0
0
ER
P
-
8
1
6
T
o
o
l
c
a
t
8
63
,
3
0
0
80
,
2
0
0
101,600
ER
P
-
8
1
7
G
r
a
s
s
S
e
e
d
A
p
p
l
i
c
a
t
o
r
20
17
,
9
0
0
VE
H
I
C
L
E
S
S
U
B
T
O
T
A
L
11
1
,
2
0
0
6
3
,
3
0
0
18
7
,
9
0
0
81
,
8
0
0
4
9
,
3
0
0
2
5
,
3
0
0
80
,
2
0
0
10
8
,
0
0
0
6
2
,
7
4
0
4
2
0
,
1
0
0
1
7
,
7
0
0
8
5
,
3
0
0
9
1
,
3
0
0
1
0
1
,
6
0
0
80
RE
P
L
EQ
U
I
P
M
E
N
T
/
V
E
H
I
C
L
E
S
Y
R
S
2
0
1
7
2
0
1
8
2
0
1
9
2
0
2
0
2
0
2
1
2
0
2
2
2
0
2
3
2
0
2
4
2
0
2
5
2
0
2
6
2
0
2
7
2
0
2
8
2
0
2
9
2
0
3
0
2
0
3
1
2
0
3
2
2
0
3
3
2
0
3
4
2
0
3
5
2
0
3
6
P.
W
.
S
T
R
E
E
T
S
/
T
R
A
F
F
I
C
ER
P
-
3
0
0
4
x
4
3
/
4
T
o
n
T
r
u
c
k
/
P
l
o
w
10
28
,
9
0
0
38,800
ER
P
-
3
0
1
4
x
4
3
/
4
T
o
n
T
r
u
c
k
/
P
l
o
w
8
38
,
5
0
0
48,800
ER
P
-
3
0
2
4
x
2
1
T
o
n
D
u
m
p
T
r
u
c
k
12
54
,
6
0
0
77
,
8
0
0
ER
P
-
3
0
3
1
T
o
n
D
u
m
p
T
r
u
c
k
12
49
,
5
0
0
ER
P
-
3
0
3
1
T
o
n
D
u
m
p
T
r
u
c
k
12
53
,
4
0
0
76,100
ER
P
-
3
0
4
1
T
o
n
B
o
o
m
T
r
u
c
k
17
13
6
,
4
0
0
ER
P
-
3
0
5
S
i
n
g
l
e
A
x
l
e
D
u
m
p
T
r
u
c
k
17
13
2
,
1
0
0
ER
P
-
3
0
5
S
i
n
g
l
e
A
x
l
e
D
u
m
p
T
r
u
c
k
17
ER
P
-
3
0
5
S
i
n
g
l
e
A
x
l
e
D
u
m
p
T
r
u
c
k
17
21
0
,
6
0
0
ER
P
-
3
0
6
T
a
n
d
e
m
D
u
m
p
T
r
u
c
k
17
2
2
5
,
0
0
0
2
3
5
,
0
0
0
286,000 294,000 294,000
ER
P
-
3
0
7
W
a
t
e
r
T
r
u
c
k
22
ER
P
-
3
0
8
F
r
o
n
t
E
n
d
L
o
a
d
e
r
15
26
8
,
0
0
0
ER
P
-
3
0
8
F
r
o
n
t
E
n
d
L
o
a
d
e
r
18
26
8
,
6
0
0
ER
P
-
3
0
9
S
k
i
d
L
o
a
d
e
r
12
59
,
7
0
0
ER
P
-
3
0
9
S
k
i
d
L
o
a
d
e
r
12
50
,
0
0
0
71,300
ER
P
-
3
1
0
G
r
a
d
e
r
20
16
7
,
3
0
0
ER
P
-
3
1
1
S
w
e
e
p
e
r
20
15
6
,
4
0
0
ER
P
-
3
1
2
R
o
l
l
e
r
20
4
5
,
9
0
0
ER
P
-
3
1
3
S
t
r
i
p
e
r
12
1
1
,
2
0
0
16
,
0
0
0
ER
P
-
3
1
4
P
a
v
e
r
20
1
1
8
,
0
0
0
ER
P
-
3
1
5
S
n
o
w
B
l
o
w
e
r
20
1
6
0
,
0
0
0
288,000
ER
P
-
3
1
6
T
r
a
i
l
e
r
20
ER
P
-
3
1
7
S
i
g
n
M
a
c
h
i
n
e
10
18
,
1
0
0
ER
P
-
3
1
8
A
s
p
h
a
l
t
H
o
t
M
i
x
H
e
a
t
i
n
g
B
o
x
12
1
5
,
0
0
0
21
,
3
0
0
ER
P
-
3
1
9
R
e
g
e
n
e
r
a
t
i
v
e
A
i
r
S
w
e
e
p
e
r
20
ER
P
-
3
2
0
P
l
a
n
e
r
20
18
,
6
0
0
VE
H
I
C
L
E
S
S
U
B
T
O
T
A
L
57
5
,
1
0
0
2
8
9
,
6
0
0
1
5
6
,
4
0
0
13
2
,
1
0
0
1
0
3
,
4
0
0
2
9
7
,
5
0
0
8
8
,
0
0
0
1
6
7
,
3
0
0
1
8
,
1
0
0
2
6
8
,
0
0
0
8
1
,
0
0
0
3
6
3
,
0
0
0
7
7
,
8
0
0
1
8
,
6
0
0
4
8
,
8
0
0
3
8
,
8
0
0
4
3
3
,
4
00 294,000 582,000
HR
A
ER
P
-
4
0
0
4
x
4
3
/
4
T
o
n
T
r
u
c
k
8
41
,
1
0
0
52
,
1
0
0
ER
P
-
4
0
1
C
o
p
i
e
r
8
16
,
5
0
0
20
,
9
0
0
SU
B
T
O
T
A
L
16
,
5
0
0
4
1
,
1
0
0
20
,
9
0
0
5
2
,
1
0
0
PA
V
I
L
I
O
N
ER
P
-
1
0
0
0
I
c
e
R
e
s
u
r
f
a
c
e
r
12
16
5
,
0
0
0
ER
P
-
1
0
0
1
E
l
e
c
t
r
i
c
I
c
e
E
d
g
e
r
12
8,
9
0
0
ER
P
-
1
0
0
2
A
r
e
n
a
S
c
o
r
e
b
o
a
r
d
20
12
,
0
0
0
ER
P
-
1
0
0
3
F
l
o
o
r
S
c
r
u
b
b
e
r
10
11
,
6
0
0
15,600
ER
P
-
1
0
0
4
S
c
i
s
s
o
r
L
i
f
t
15
16
,
2
0
0
SU
B
T
O
T
A
L
11
,
6
0
0
18
5
,
9
0
0
16
,
2
0
0
15,600
RE
F
U
S
E
ER
P
-
9
0
0
R
e
f
u
s
e
T
r
u
c
k
(
R
A
P
-
R
)
10
27
5
,
2
0
0
ER
P
-
9
0
0
R
e
f
u
s
e
T
r
u
c
k
(
R
A
P
-
R
)
10
27
0
,
3
0
0
36
3
,
2
0
0
ER
P
-
9
0
1
R
e
f
u
s
e
T
r
u
c
k
(
R
e
a
r
-
L
)
10
1
0
1
,
6
0
0
13
6
,
5
0
0
ER
P
-
8
0
3
S
w
a
p
L
o
a
d
e
r
20
95
,
0
0
0
ER
P
-
8
0
4
L
o
g
T
r
u
c
k
(
5
0
%
w
/
F
o
r
e
s
t
r
y
)
20
81
,
8
0
0
SU
B
T
O
T
A
L
1
0
1
,
6
0
0
9
5
,
0
0
0
27
0
,
3
0
0
8
1
,
8
0
0
27
5
,
2
0
0
13
6
,
5
0
0
36
3
,
2
0
0
SE
W
E
R
ER
P
-
5
5
0
4
x
4
3
/
4
T
o
n
T
r
u
c
k
10
40
,
3
0
0
54,200
ER
P
-
5
5
1
3
/
4
T
o
n
U
t
i
l
i
t
y
T
r
u
c
k
10
45
,
2
0
0
ER
P
-
5
5
2
J
e
t
V
a
c
t
o
r
20
4
2
5
,
0
0
0
700,000
ER
P
-
5
5
5
G
e
n
e
r
a
t
o
r
2
5
3
6
,
0
0
0
ER
P
-
5
5
5
G
e
n
e
r
a
t
o
r
25
23
,
0
0
0
ER
P
-
5
5
9
S
C
A
D
A
U
p
g
r
a
d
e
10
1
6
0
,
0
0
0
21
5
,
0
0
0
SU
B
T
O
T
A
L
6
2
1
,
0
0
0
23
,
0
0
0
40
,
3
0
0
45
,
2
0
0
2
1
5
,
0
0
0
54,200
WA
T
E
R
ER
P
-
5
0
0
1
.
/
2
T
o
n
T
r
u
c
k
10
3
2
,
0
0
0
43
,
0
0
0
ER
P
-
5
0
1
3
/
4
T
o
n
U
t
i
l
i
t
y
T
r
u
c
k
10
46
,
9
0
0
ER
P
-
5
0
2
B
a
c
k
h
o
e
20
153,700
ER
P
-
5
0
3
A
i
r
C
o
m
p
r
e
s
s
o
r
20
41
,
7
0
0
ER
P
-
5
0
9
W
a
t
e
r
T
r
e
a
t
m
e
n
t
P
l
a
n
t
10
1
0
0
,
0
0
0
13
4
,
3
0
0
SU
B
T
O
T
A
L
1
3
2
,
0
0
0
22
4
,
2
0
0
4
1
,
7
0
0
153,700
81
RE
P
L
EQ
U
I
P
M
E
N
T
/
V
E
H
I
C
L
E
S
Y
R
S
2
0
1
7
2
0
1
8
2
0
1
9
2
0
2
0
2
0
2
1
2
0
2
2
2
0
2
3
2
0
2
4
2
0
2
5
2
0
2
6
2
0
2
7
2
0
2
8
2
0
2
9
2
0
3
0
2
0
3
1
2
0
3
2
2
0
3
3
2
0
3
4
2
0
3
5
2
0
3
6
TO
T
A
L
S
20
1
7
2
0
1
8
2
0
1
9
2
0
2
0
2
0
2
1
2
0
2
2
2
0
2
3
2
0
2
4
2
0
2
5
2
0
2
6
2
0
2
7
2
0
2
8
2
0
2
9
2
0
3
0
2
0
3
1
2
0
3
2
2
0
3
3
2
0
3
4
2
0
3
5
2
0
3
5
GE
N
E
R
A
L
F
U
N
D
-
V
E
H
I
C
L
E
S
/
E
Q
U
I
P
1,
7
3
8
,
5
1
7
6
8
9
,
4
1
7
2
5
4
,
4
0
0
2
9
5
,
3
0
0
3
4
6
,
9
0
0
6
6
4
,
1
0
0
4
6
4
,
2
0
0
3
8
5
,
3
0
0
2
8
4
,
7
0
0
1
,
0
1
2
,
7
0
0
1
,
6
6
0
,
0
0
0
1
,
9
3
1
,
1
0
0
5
6
5
,
7
4
0
8
62
,
9
0
0
3
7
8
,
0
0
0
7
0
9
,
9
0
0
3
5
9
,
8
0
0
8
0
6
,
8
0
0
3
7
4
,
0
0
0
6
7
8
,
0
0
0
GE
N
E
R
A
L
F
U
N
D
-
O
T
H
E
R
E
Q
U
I
P
17
4
,
9
0
0
2
7
6
,
0
0
0
2
7
3
,
4
0
0
2
1
7
,
3
0
0
8
4
,
0
0
0
1
8
5
,
3
0
0
1
,
0
0
3
,
7
0
0
1
6
8
,
7
0
0
4
1
1
,
0
0
0
3
2
0
,
0
0
0
1
5
2
,
5
0
0
3
2
3
,
7
0
0
1
2
0
,
9
0
0
4
2
2
,
5
0
0
2
9
0
,
10
0
2
1
2
,
3
0
0
7
9
2
,
8
0
0
1
7
3
,
4
0
0
4
9
7
,
0
0
0
5
7
8
,
0
0
0
HR
A
16
,
5
0
0
4
1
,
1
0
0
20
,
9
0
0
5
2
,
1
0
0
AR
T
S
C
E
N
T
E
R
17
,
1
0
0
32
,
4
0
0
1
9
,
8
0
0
17
,
5
0
0
7
,
1
0
0
7
,
7
0
0
3
1
,
4
0
0
1
6
,
6
0
0
15,900 10,200 9,000
RE
F
U
S
E
10
1
,
6
0
0
9
5
,
0
0
0
27
0
,
3
0
0
8
1
,
8
0
0
27
5
,
2
0
0
13
6
,
5
0
0
36
3
,
2
0
0
PA
V
I
L
I
O
N
11
,
6
0
0
18
5
,
9
0
0
16
,
2
0
0
15,600
WA
T
E
R
13
2
,
0
0
0
22
4
,
2
0
0
4
1
,
7
0
0
153,700
SE
W
E
R
62
1
,
0
0
0
23
,
0
0
0
40
,
3
0
0
45
,
2
0
0
2
1
5
,
0
0
0
54,200
GE
N
E
R
A
L
F
U
N
D
T
O
T
A
L
1,
9
1
3
,
4
1
7
9
6
5
,
4
1
7
5
2
7
,
8
0
0
5
1
2
,
6
0
0
4
3
0
,
9
0
0
8
4
9
,
4
0
0
1
,
4
6
7
,
9
0
0
5
5
4
,
0
0
0
6
9
5
,
7
0
0
1
,
3
3
2
,
7
0
0
1
,
8
1
2
,
5
0
0
2
,
2
5
4
,
8
0
0
6
8
6
,
6
4
0
1
,
2
8
5
,
4
0
0
6
6
8
,
1
0
0
9
2
2
,
2
0
0
1
,
1
5
2
,
6
0
0
9
8
0
,
2
0
0
8
7
1
,
0
0
0
1
,
2
5
6
,
0
0
0
HR
A
T
O
T
A
L
16
,
5
0
0
4
1
,
1
0
0
20
,
9
0
0
5
2
,
1
0
0
AR
T
S
C
E
N
T
E
R
F
U
N
D
T
O
T
A
L
17
,
1
0
0
32
,
4
0
0
1
9
,
8
0
0
17
,
5
0
0
7
,
1
0
0
7
,
7
0
0
3
1
,
4
0
0
1
6
,
6
0
0
15,900 10,200 9,000
EN
T
E
R
P
R
I
S
E
F
U
N
D
S
T
O
T
A
L
85
4
,
6
0
0
9
5
,
0
0
0
27
0
,
3
0
0
1
0
4
,
8
0
0
51
,
9
0
0
2
7
5
,
2
0
0
2
3
1
,
1
0
0
5
7
5
,
7
0
0
4
1
,
7
0
0
1
6
,
2
0
0
36
3
,
2
0
0
1
5
3
,
7
0
0
69,800
TO
T
A
L
A
L
L
F
U
N
D
S
2,
7
6
8
,
0
1
7
1
,
0
7
7
,
5
1
7
5
2
7
,
8
0
0
5
1
2
,
6
0
0
7
0
1
,
2
0
0
1
,
0
0
3
,
1
0
0
1,
5
2
8
,
8
0
0
6
0
5
,
9
0
0
9
8
8
,
4
0
0
1
,
5
7
0
,
9
0
0
2
,
3
9
5
,
9
0
0
2
,
3
2
7
,
9
0
0
7
1
9
,
4
4
0
1
,
3
0
6
,
3
0
0
1
,
0
8
3
,
4
0
0
1
,
0
9
1
,
8
0
0
1
,
1
5
2
,
6
0
0
1
,
0
6
0
,
2
0
0
8
8
0
,
0
0
0
1
,
2
5
6
,
0
0
0
GE
N
E
R
A
L
F
U
N
D
S
A
L
V
A
G
E
40
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0
4
0
,
0
0
0 40,000 40,001
NE
T
G
E
N
E
R
A
L
F
U
N
D
1,
8
7
3
,
4
1
7
9
2
5
,
4
1
7
4
8
7
,
8
0
0
4
7
2
,
6
0
0
3
9
0
,
9
0
0
8
0
9
,
4
0
0
1
,
4
2
7
,
9
0
0
5
1
4
,
0
0
0
6
5
5
,
7
0
0
1
,
2
9
2
,
7
0
0
1
,
7
7
2
,
5
0
0
2
,
2
1
4
,
8
0
0
6
4
6
,
6
4
0
1
,
2
4
5
,
4
0
0
6
28
,
1
0
0
8
8
2
,
2
0
0
1
,
1
1
2
,
6
0
0
9
4
0
,
2
0
0
8
3
1
,
0
0
0
1
,
2
1
5
,
9
9
9
20
Y
E
A
R
A
V
E
R
A
G
E
S
:
To
t
a
l
Av
e
r
a
g
e
AC
T
I
V
I
T
Y
C
E
N
T
E
R
A
D
M
I
N
I
S
T
R
A
T
I
O
N
54
,
7
0
0
2
,
7
0
0
CO
M
M
U
N
I
T
Y
S
E
R
V
I
C
E
S
-
I
T
2,
3
2
7
,
7
0
0
1
1
6
,
4
0
0
CO
M
M
U
N
I
T
Y
S
E
R
V
I
C
E
S
-
C
I
T
Y
C
L
E
R
K
54
,
3
0
0
2
,
7
0
0
FI
R
E
E
Q
U
I
P
M
E
N
T
1,
9
5
8
,
2
0
0
9
7
,
9
0
0
FI
R
E
A
D
M
I
N
I
S
T
R
A
T
I
O
N
5,
2
3
9
,
9
3
4
2
6
2
,
0
0
0
PO
L
I
C
E
E
Q
U
I
P
M
E
N
T
2,
2
3
9
,
0
0
0
1
1
2
,
0
0
0
PO
L
I
C
E
A
D
M
I
N
I
S
T
R
A
T
I
O
N
3,
5
1
2
,
3
0
0
1
7
5
,
6
0
0
PU
B
L
I
C
W
O
R
K
S
A
D
M
I
N
I
S
T
R
A
T
I
O
N
BL
D
G
.
/
E
Q
U
I
P
M
E
N
T
S
E
R
V
I
C
E
S
E
Q
U
I
P
M
E
N
T
16
6
,
8
0
0
8
,
3
0
0
EN
G
I
N
E
E
R
I
N
G
E
Q
U
I
P
M
E
N
T
67
,
7
0
0
3
,
4
0
0
PA
R
K
S
/
F
O
R
E
S
T
R
Y
E
Q
U
I
P
M
E
N
T
1,
4
8
5
,
7
4
0
7
4
,
3
0
0
ST
R
E
E
T
E
Q
U
I
P
M
E
N
T
4,
0
3
2
,
9
0
0
2
0
1
,
6
0
0
GE
N
E
R
A
L
F
U
N
D
V
E
H
I
C
L
E
/
E
Q
U
I
P
M
E
N
T
9,
9
5
0
,
3
4
0
4
9
7
,
5
0
0
GE
N
E
R
A
L
F
U
N
D
O
T
H
E
R
E
Q
U
I
P
M
E
N
T
11
,
1
8
8
,
9
3
4
5
5
9
,
4
0
0
GE
N
E
R
A
L
F
U
N
D
T
O
T
A
L
21
,
1
3
9
,
2
7
4
1,
0
5
7
,
0
0
0
HR
A
F
U
N
D
13
0
,
6
0
0
6
,
5
0
0
AR
T
S
C
E
N
T
E
R
F
U
N
D
18
4
,
7
0
0
9
,
2
0
0
RE
F
U
S
E
F
U
N
D
1,
3
2
3
,
6
0
0
6
6
,
2
0
0
PA
V
I
L
I
O
N
F
U
N
D
22
9
,
3
0
0
1
1
,
5
0
0
WA
T
E
R
F
U
N
D
55
1
,
6
0
0
2
7
,
6
0
0
SE
W
E
R
F
U
N
D
99
8
,
7
0
0
4
9
,
9
0
0
UT
I
L
I
T
Y
V
E
H
I
C
L
E
S
/
E
Q
U
I
P
M
E
N
T
3,
4
1
8
,
5
0
0
1
7
0
,
9
0
0
24
,
5
5
7
,
7
7
4
82
EQUIPMENT AND BUILDING
INVENTORY
83
84
CITY OF HOPKINS
BUILDING INVENTORY
January 2016
Location/Description Replacement Cost
City Hall & Police Station $7,935,297
1010 1st Street S.
Fire Station 4,619,899
101 17th Avenue S.
Hopkins Activity Center 2,000,869
33 14th Avenue S.
Ice Arena/Pavilion 5,494,200
11000 Excelsior Boulevard
Arts Center 7,526,389
1111 Mainstreet
PW Admin/Garage 7,860,717
11100 Excelsior Boulevard
Moline Reservoir/Well #1 2,517,401
10421 Excelsor Boulevard
Blake Tower Reservior 1,519,735
151 Tyler Avenue South
Filtration Plant 3,700,322
1401 Elmo Park Service Road
Well #4 Workshop/Storage 585,527
1401 Elmo Park Service Road
Well #5 250,465
1205 Highway7
Well #6 333,989
801 Highway 7
Lift Station #2 - Drillane 71,330
619 Drillane Road
Lift Station #3 - Lindee's 142,565
901 Cambridge Street N.E.
Lift Station #4 - LTL Meadowbrook 104,277
244 Meadowbrook Road
Lift Station #5 - Big Meadowbrook 165,649
6601 Excelsior Blvd.
Lift Station #6 - Ronnie's $104,277
8546 Excelsior Avenue E.
85
Location/Description Replacement Cost
Lift Station #7 - Valley 329,431
801 6th Avenue S.
Storage Facility 127,706
1401 Elmo Park Service Road
Band Shell - Downtown Park 39,454
16 9th Avenue S.
Concession Stand - Maetzold Field 163,369
1215 1st Street N.
Park Building-Beach - Lifeguards 176,296
5200 Shady Oak Road
Park Building-Beach-Concessions 166,620
5200 Shady Oak Road
Park Shelter - Office/Bathhouse 404,766
5200 Shady Oak Road
Park Shelter - Burnes 53,840
201 Park Lane
Park Building - Central 122,233
101 17th Avenue S.
Park Building - Harley 41,426
108 Jackson Avenue S.
Park Shelter - Interlachen 66,202
220 Homedale Avenue
Park Building - Oakes 47,236
301 Tyler Avenue N.
Park Building - Valley 55,492
800 7th Avenue S.
Parking Ramp 6,834,259
10th Avenue and Mainstreet
Depot Coffee House 514,342
9451 Excelsior Boulevard
Overpass Skate Park 8,226
100 Washington Avenue
Historical Society Bldg 1,053,864
907 Mainstrre
Dow Towers (76 Units) HRA
22 5th Avenue S.
86
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
Fall, 2016
UNIT # YEAR MAKE MODEL VALUE
FIRE DEPARTMENT
102. 1989 FORD 380,000
103. 2006 PETERBILT PUMPER 420,000
104 2012 FORD QUICK ATTACK PUMPER F550 248,500
105 2015 FORD EXPLORER (RED) - LEASED 47,500
106 2015 FORD EXPLORER (RED) - LEASED 47,500
107 2015 FORD EXPLORER (BLACK) - LEASED 47,500
108 2014 FORD F-150 - LEASED 34,000
109 2008 PIERCE AERO XT 874,000
110 2010 CHEVROLET TAHOE 30,000
115. 1952 MACK PUMPER 4,000
POLICE DEPARTMENT
200. 2015 FORD EXPLORER - INTERCEPTOR $30,000
201 2014 FORD EXPLORER - INTERCEPTOR (SGT)31,000
202. 2015 FORD EXPLORER - INTERCEPTOR 31,000
205. 2016 FORD EXPLORER - INTERCEPTOR 34,000
206 2016 FORD EXPLORER - INTERCEPTOR 34,000
207. 2014 FORD EXPLORER - INTERCEPTOR 47,500
208. 2013 FORD EXPLORER - INTERCEPTOR 42,600
209. 2015 FORD EXPLORER - INTERCEPTOR 31,000
211. 2006 JEEP LIBERTY (PKG)18,800
212 2014 FORD F150 (PSO)34,000
213. 2010 CHEV IMPALA 26,000
214 2014 NISSAN MAXIMA ( LEASED VEHICLE)38,800
216. 2011 FORD TAURUS 30,000
218. 2013 FORD INTERCEPTOR SUV 40,000
219. 2013 FORD TAURUS 27,500
220 2005 DODGE RAM 1500 (PATROL)29,000
221 2015 JEEP CHEROKEE - LEASED 35,000
240. 1998 CHEV P40 VAN (SWAT)12,000
299 2014 NISSAN TITAN (DTF LEASED VEHICLE)40,300
DWI 2015 FORD UTILITY - INTERCEPTOR 40,300
87
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
Fall, 2016
UNIT # YEAR MAKE MODEL VALUE
STREET/TRAFFIC DIVISION
301. 2013 FORD F150 $19,500
302. 2006 FORD F250 26,500
304. 2000 FORD F450 34,000
305. 1997 FORD F350 18,300
307. 2006 FORD F350-1 TON DUMP 27,400
308. 2011 FORD F350 - 2X4 20,300
309. 2012 FORD F450 30,300
311. 2011 FREIGHTLINER M2106V 79,400
312. 2005 FREIGHTLINER SGLAX DUMP 98,000
313. 2001 FORD L7501 72,000
314. 1998 FORD LT 8500 84,000
316. 1995 FORD WATER TRK 81,000
320. 1991 CATERPILLER LOADER 926E 90,000
321. 2012 CATERPILLER LOADER 924K 177,500
322. 2005 CATERPILLER LOADER 938G 157,800
324. 2004 BOBCAT SKID LOADER 32,900
325. 2011 BOBCAT SKID STEER LOADER 35,100
326. 1989 CATERPILLAR 140-G 82,000
327. 2001 ELGIN PELICAN SE 105,000
328. 2013 ISUZU STREET SWEEPER 145,300
330. 1989 INGERSOL/RAND ROLLER DD-25 15,000
337. 1994 CATERPILLAR BOX PAVER 17,000
342. 1991 TARGET CONCRETE SAW 2,400
343 2014 SNOWCRETE SNOWBLOWER - CUMMINS QSB6.7 71,500
344. 1996 SNOGO WK 800 58,000
348 2014 PJ TRAILER 20' TILT TRAILER 5,300
350. 1993 TOWMASTER T14 4,000
351. 2004 TENNANT SWEEPER 3640 10,000
ENGINEERING DIVISION
700. 2002 CHEV TAHOE $18,000
701 2008 FORD TAURUS 22,000
706 2015 FORD TRANSIT 250 VAN 24,000
707 2009 CHEV IMPALA 14,600
BUILDING MAINTENANCE & EQUIPMENT SERVICES
702. 2004 FORD F350 $18,000
703 1995 CHEV EXT CAB 4X4 36,000
704. 2005 FORD F250 18,000
88
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
Fall, 2016
UNIT # YEAR MAKE MODEL VALUE
PARKS/FORESTRY DIVISION
800. 2013 FORD F150 $23,700
801. 2012 FORD F350 4X4 24,100
803. 2004 FORD F350 17,500
804. 1995 CHEV 1 TON BOOM 45,000
805. 1998 DODGE RAM 3500 17,100
810. 1993 INTERNATIONAL LP 4700 50,000
811. 2006 INTERNATIONAL LP 4600 LOG TRUCK 45,000
812. 2010 FREIGHTLINER AERIAL LIFT 130,000
815. 2010 BOBCAT TOOLCAT 53,000
816 2014 BOBCAT 5610 TOOLCAT 50,900
818. 1996 TORO TRUCKSTER 13,000
820. 2004 TORO WORKMAN 3200 15,000
822. 2001 TORO 325-D MOWER 18,000
823. 2006 JACOBSON MOWER 10,000
824. 1996 TORO GROUND MASTER 16,000
825. 2010 TORO 4100D MOWER 56,500
826. 2004 TORO Z587L 8,900
828. 2001 DEW EZE ATM72 21,000
832. 1997 VERMEER STUMP CTR 630A 15,400
833. 2004 BOBCAT SKID LOADER 22,000
834. 2013 VERMEER BRUSH CHIPPER 29,800
836. RYAN SOD CUTTER 2,000
843 2007 CARR TRAILER 2,500
844. 2010 FELLING TRAILER 6,000
845. 1997 REMACKEL TRAILER 3,500
846. 2001 DRESSEN 8110 2,000
847. 2011 SPARKS TILT TRAILER 4,900
HRA
411. 2007 CHEV 2500 HD $17,500
89
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
Fall, 2016
UNIT # YEAR MAKE MODEL VALUE
WATER/SEWER
500. 2007 CHEV PICKUP $22,000
501. 2004 CHEV 4X4 3/4 T SILVERADO 19,000
502. 1999 DODGE DAKOTA 4X4 18,000
503 2015 FORD F350 38,000
505. 2007 CHEV CC25753 31,900
506. 2006 CHEV SILVERADO 20,700
507. 2001 CHRYSLER PT CRUISER 18,000
530. 2001 STERLING VAC-CON 180,000
533. 2012 CATERPILLAR 420EH2 BACKHOE 87,700
534. 1997 KOHLER GENERATOR/TRL 11,000
535. 1992 KOHLER GENERATOR/TRL 10,000
536. 1989 FLEXIBLE RODDING MACHINE 49,000
537. 2010 GENERATOR C15 144,300
REFUSE
900. 2011 FREIGHTLINER RAPID-RAIL M2 $201,109
901. 2005 PETERBILT 320 155,000
902 2015 FREIGHTLINER M2106V 232,500
903. 1995 FREIGHTLINER FL-70 50,000
PAVILION
802. 2012 FORD F350 $20,000
808 2014 ZAMBONI ICE RESURFACER $126,000
809. 2003 OLYMPIA ICE RESURFACER 87,800
90