The URL can be used to link to this page

VII.2. 2019-2023 Equipment Replacement Plan; Bishop December 4, 2018 Council Report 2018-127 2018-2022 EQUIPMENT REPLACEMENT PLAN Proposed Action Staff recommends adoption of the following motion: Move to adopt the 2019-2023 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 (except Arts Center) 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 Arts 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 2019-2023 allows staff to 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 • What changes have occurred in the equipment replacement plan since last year? Supporting Information • 2018-2022 ERP Power Point slides • 2018-2022 Equipment Replacement Plan ______________________________________ Nick Bishop, CPA Finance Director Financial Impact: $ as provided in plan Budgeted: Y/N X N Source: Various Related Documents (CIP, ERP, etc.): __ERP_________ Notes: ____________________ 2019 –2023 Equipment Replacement Plan December 4, 2018 Overview 5 year plan, updated annually Approval authorizes purchases in 2019 Remaining four years are estimated replacement for information and planning Would be authorized in subsequent years Funding Sources User Department Charges Increasing by 9% in 2019 Total charges of $533,569 primarily in General Fund Tax Levy $230,000 in 2019 Reduced by $20,000 since preliminary levy Funding Sources Directly Funded Arts Center, HRA and Utility Funds Uses of Funds in 2019 Activity Center -$16K Dishwasher Information Technology -$153K Network server, computers, Office 365, VPN, E-Mail Threat Protection, Patching Automation Uses of Funds in 2019 Police -$258K Marked patrol vehicles, squad car camera system, data server and mobile data computers Streets/Traffic-$230K Sweeper Working Capital Projection Projected balance of $41,007 at end of 2019 Positive balance in future years with levy and 2023 Equipment Certificates EQUIPMENT REPLACEMENT PLAN 2019-2023 DATE: December 4th, 2018 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2019-2023 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2019-2023 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, Brent Johnson, Police Chief, Dale Specken, Fire Chief, Ari Lenz, Assistant City Manager, and Nick Bishop, Finance Director for their hard work and dedication. 1 2 Page City Manager's Message 1 Table of Contents 3 Introduction Background and Summary of Changes from 2017 Plan 6 Cash Flow Statements Equipment Replacement Fund 10 Five-Year Project Summaries Projects by Year 12 Department Summary 14 Projects by Department 15 Funding Source Summary 17 Projects by Funding Source 18 Equipment Requests Individual Equipment Request Details Activity Center 22 Arts Center 26 Community Services - IT 27 Fire 40 HRA 47 Police 48 Public Works 60 Refuse 71 Water/Sewer 72 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 76 Equipment Inventory 80 EQUIPMENT REPLACEMENT PLAN 2019-2023 TABLE OF CONTENTS 3 4 INTRODUCTION 5 EQUIPMENT REPLACEMENT PLAN 2019-2023 BACKGROUND AND SUMMARY OF CHANGES FROM 2018 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 2018 by 10% and will be increased in 2019 by 9%. Plans are to increase the rate going forward with increases of 9% in 2020-2021 and 6% in 2022-2023. 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. The fund will also implement a tax levy for 2019. The levy being proposed for 2019 is $230,000. It is planned to continue at $250,000 for 2020- 2023. 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, 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 that has been under discussion in recent years was police body cameras, which are currently included in this plan. 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) first 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. Equipment Certificates were sold for $590,000 in 2018. 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. Equipment certificates are next planned as a funding source in 2023. 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. 6 The Equipment Replacement Plan’s basic premise is scheduled replacement of present equipment. A new item must, in the year proposed, be presented in the annual operating budget with a stipulation that replacement will be necessary in the future. Flexibility of the Equipment Replacement Plan is established through annual review and revision, if necessary. Summary of Changes from 2018 Plan Highlights of changes from last year’s equipment replacement plan for the years 2019-2023: CS - Activity Center: Dishwasher was added in 2019 at a cost of $16,000. Replacement has been delayed for several years. Security system upgrade was added in 2020 at a cost of $20,000. A/V Replacements and upgrades was added in 2020 at a cost of $62,624. Kitchen storage projects were added in 2022/2023 for $29,000. CS - Arts Center: No changes CS - IT: Virtual privacy network software and equipment were added in 2019 for $19,000. E-mail threat protection software was added in in 2019 for $19,390. Patching automation software was added in 2019 for $30,000. Community Services: No changes Fire: No changes HRA No changes. Police: The cost of the squad car camera system was increased by $20,000, from $65,000 to $85,000. This is an improved system that allowed the police department to eliminate a data server project scheduled for replacement in 2018. Public Works: Building/Equipment Services No changes Parks/Forestry No Changes 7 Streets/Traffic No Changes Refuse No changes Sewer No Changes Water Air compressor was added in 2019 for $35,000. 8 CASH FLOW STATEMENT 9 City of Hopkins Equipment Replacement Fund (602) Rate Change 9%10%9%9%9%6%6% ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2017 2018 2019 2020 2021 2022 2023 Working Capital Begin Year 1,172,861 (28,845) (69,299) 41,007 173,984 443,107 327,733 Revenues from charges 445,012 489,513 533,569 581,591 633,934 671,970 712,288 Tax Levy 230,000 250,000 250,000 250,000 250,000 Transfer in Debt Service Fund - - - - - - Interest earnings 1,332 3,000 3,000 3,000 3,000 3,000 3,000 Other revenues (sale of assets)69,883 30,000 35,000 35,000 35,000 35,000 35,000 Enterpirse contribution to software upgrade - - - - - - Equipment Certificates (Bonds)- 590,000 - - - - 1,600,000 Interfund Loan - -- - - - Total Revenues 516,227 1,112,513 801,569 869,591 921,934 959,970 2,600,288 Expenditures (excludes Leases & Depr.) 31,929 32,887 33,873 34,890 35,936 37,014 38,125 Fire Truck Financing Pymnts (2009-2018)54,217 54,217 - - - - Capital Outlay - Equipment 1,631,787 1,065,863 657,390 701,724 616,875 1,038,329 1,604,077 Repayment of Interfund Loan - - Total Expenses 1,717,933 1,152,967 691,263 736,614 652,811 1,075,343 1,642,202 Working Capital Ending Balance (28,845) (69,299) 41,007 173,984 443,107 327,733 1,285,819 (Unrestricted Net Position) 10 FIVE-YEAR PROJECT SUMMARIES 11 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY YEAR 2019 2023thru Project Name Department Project #Priority Project Cost 2019 01-ERP-0039Activity Center Dishwasher 5 16,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-0017IT - Office 365 n/a 11,000Comm Svcs - IT 01-ERP-0018IT - RSA/Netmotion VPN n/a 19,000Comm Svcs - IT 01-ERP-0019IT - Email Threat Protection n/a 19,390Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 30,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0200Marked Patrol Vehicles (7)n/a 98,000Police 01-ERP-0212Squad Car Camera Systems n/a 85,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 230,000Public Works: Streets/Traffic 01-ERP-0503Air Compressor 2 35,000Water 692,390Total for 2019 2020 01-ERP-0037Activity Center Security System Upgrade 1 20,000Comm Svcs - Activity Center 01-ERP-0041Activity Center A/V Replacement & Upgrade 1 62,624Comm Svcs - Activity Center 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 31,500Comm 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-0017IT - Office 365 n/a 22,000Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,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-0051City Hall Exterior Security Camera System 1 40,000Community Services 01-ERP-0109Extrication Tool (2)n/a 29,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 107,400Police 01-ERP-0218Building Video Server n/a 20,000Police 01-ERP-0219PD - Video Data Server n/a 10,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 701,724Total for 2020 2021 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 33,075Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 33,000Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0200Marked Patrol Vehicles (7)n/a 161,100Police Wednesday, November 28, 2018 12 Project Name Department Project #Priority Project Cost 01-ERP-0201Sergeant's Vehicle n/a 57,000Police 01-ERP-0202PSO / Parking Enforcement Vehicle n/a 53,700Police 01-ERP-0305Single Axle Dump Truck (2)n/a 225,000Public Works: Streets/Traffic 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 270,300Refuse 887,175Total for 2021 2022 01-ERP-0038Activity Center Kitchen Storage 5 17,000Comm Svcs - Activity Center 01-ERP-1105Art Center Jaycee Studio Audio Visual n/a 13,500Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 25,000Comm Svcs - IT 01-ERP-0006Computers n/a 34,729Comm Svcs - IT 01-ERP-0009Network Infrastructure Upgrade n/a 23,400Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 44,000Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 25,000Comm Svcs - IT 01-ERP-0105Quick Attack Pumper/Rescue (Rescue 8)n/a 314,500Fire 01-ERP-0109Extrication Tool (2)n/a 30,000Fire 01-ERP-0401HRA Copier n/a 16,500HRA 01-ERP-0200Marked Patrol Vehicles (7)n/a 107,400Police 01-ERP-0203PSO - Utility 4x4 n/a 72,100Police 01-ERP-0221Records Management System n/a 150,000Police 01-ERP-0804Log Truck n/a 163,600Public Works: Parks/Forestry 01-ERP-03031 Ton Dump Truck (2)n/a 53,400Public Works: Streets/Traffic 01-ERP-0309Skid Loader (2)n/a 50,000Public Works: Streets/Traffic 01-ERP-0555Generator (2)n/a 43,000Sewer 1,193,129Total for 2022 2023 01-ERP-0038Activity Center Kitchen Storage 5 12,000Comm Svcs - Activity Center 01-ERP-0003CH - Network Server n/a 26,250Comm Svcs - IT 01-ERP-0004Telephone System n/a 89,600Comm Svcs - IT 01-ERP-0006Computers n/a 36,465Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 44,000Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 26,250Comm Svcs - IT 01-ERP-0109Extrication Tool (2)n/a 32,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 15,400Fire 01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 368,000Fire 01-ERP-0126Fire - Fire Helmets n/a 16,000Fire 01-ERP-0127Fire - Lucus Device n/a 18,000Fire 01-ERP-04004x4 3/4 Ton Truck n/a 41,100HRA 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 76,512Police 01-ERP-0215Police - Portable Radios n/a 290,000Police 01-ERP-0217Taser Replacement n/a 76,000Police 01-ERP-0218Building Video Server n/a 17,000Police 01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry 01-ERP-0808Riding Mowers (2)n/a 13,900Public Works: Parks/Forestry 01-ERP-03004x4 1/2 Ton Pickup with Plow n/a 28,900Public Works: Streets/Traffic 01-ERP-0308Front End Loaders (2)n/a 268,600Public Works: Streets/Traffic 1,658,777Total for 2023 GRAND TOTAL 5,133,195 Wednesday, November 28, 2018 13 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2019 2023thru Total20192020202120222023Department Comm Svcs - Activity Center 127,62416,000 82,624 17,000 12,000 Comm Svcs - Arts Center 13,50013,500 Comm Svcs - IT 891,659153,390 223,500 120,075 162,129 232,565 Community Services 51,30051,300 Fire 822,90029,000 344,500 449,400 HRA 57,60016,500 41,100 Police 1,573,612258,000 137,400 271,800 329,500 576,912 Public Works: Parks/Forestry 390,800177,900 163,600 49,300 Public Works: Streets/Traffic 855,900230,000 225,000 103,400 297,500 Refuse 270,300270,300 Sewer 43,00043,000 Water 35,00035,000 692,390 701,724 887,175 1,193,129 1,658,777 5,133,195TOTAL Tuesday, November 6, 201814 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2019 2023thru Total20192020202120222023DepartmentProject #Priority Comm Svcs - Activity Center 01-ERP-0037 20,00020,000Activity Center Security System Upgrade 1 01-ERP-0038 29,00017,000 12,000Activity Center Kitchen Storage 5 01-ERP-0039 16,00016,000Activity Center Dishwasher 5 01-ERP-0041 62,62462,624Activity Center A/V Replacement & Upgrade 1 127,62416,000 82,624 17,000 12,000Comm Svcs - Activity Center Total Comm Svcs - Arts Center 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 13,50013,500Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0003 117,25022,000 22,000 22,000 25,000 26,250CH - Network Server n/a 01-ERP-0004 89,60089,600Telephone System n/a 01-ERP-0006 165,76930,000 31,500 33,075 34,729 36,465Computersn/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0014 50,00050,000Distribution Network Switches n/a 01-ERP-0015 66,00066,000Backup Server n/a 01-ERP-0017 154,00011,000 22,000 33,000 44,000 44,000IT - Office 365 n/a 01-ERP-0018 19,00019,000IT - RSA/Netmotion VPN n/a 01-ERP-0019 19,39019,390IT - Email Threat Protection n/a 01-ERP-0020 70,00030,000 10,000 10,000 10,000 10,000IT - Patching Automation Software 1 01-ERP-0211 117,25022,000 22,000 22,000 25,000 26,250PD - Network Server n/a 891,659153,390 223,500 120,075 162,129 232,565Comm Svcs - IT Total Community Services 01-ERP-0008 11,30011,300Document Management Scanner (2)n/a 01-ERP-0051 40,00040,000City Hall Exterior Security Camera System 1 51,30051,300Community Services Total Fire 01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0109 91,00029,000 30,000 32,000Extrication Tool (2)n/a 01-ERP-0112 15,40015,400Thermal Imaging Camera (2)n/a 01-ERP-0125 368,000368,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 822,90029,000 344,500 449,400Fire Total HRA 01-ERP-0400 41,10041,1004x4 3/4 Ton Truck n/a 01-ERP-0401 16,50016,500HRA Copier n/a Tuesday, November 6, 201815 Total20192020202120222023DepartmentProject #Priority 57,60016,500 41,100HRA Total Police 01-ERP-0200 591,30098,000 107,400 161,100 107,400 117,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 57,00057,000Sergeant's Vehicle n/a 01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 72,10072,100PSO - Utility 4x4 n/a 01-ERP-0212 85,00085,000Squad Car Camera Systems n/a 01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 76,00076,000Taser Replacement n/a 01-ERP-0218 37,00020,000 17,000Building Video Server n/a 01-ERP-0219 20,00010,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 1,573,612258,000 137,400 271,800 329,500 576,912Police Total Public Works: Parks/Forestry 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0808 13,90013,900Riding Mowers (2)n/a 01-ERP-0810 92,70092,700Large Turf Mower n/a 390,800177,900 163,600 49,300Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0303 53,40053,4001 Ton Dump Truck (2)n/a 01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a 01-ERP-0308 268,600268,600Front End Loaders (2)n/a 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0311 230,000230,000Sweepern/a 855,900230,000 225,000 103,400 297,500Public Works: Streets/Traffic Total Refuse 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a 270,300270,300Refuse Total Sewer 01-ERP-0555 43,00043,000Generator (2)n/a 43,00043,000Sewer Total Water 01-ERP-0503 35,00035,000Air Compressor 2 35,00035,000Water Total GRAND TOTAL 5,133,195692,390 701,724 887,175 1,193,129 1,658,777 Tuesday, November 6, 201816 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2019 thru 2023 TotalSource20192020202120222023 AC - Arts Center Fund 13,50013,500 Equipment Replacement Fund 4,618,395657,390 701,724 616,875 1,038,329 1,604,077 HRA - Housing and Redevelopment Authority 57,60016,500 41,100 RF - Refuse Fund 352,100270,300 81,800 SF - Sanitary Sewer Fund 49,80043,000 6,800 WF - Water Fund 41,80035,000 6,800 692,390 701,724 887,175 1,193,129 1,658,777 5,133,195GRAND TOTAL Tuesday, November 6, 2018 17 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2019 2023thru TotalSourceProject #Priority 2019 2020 2021 2022 2023 AC - Arts Center Fund 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 13,50013,500AC - Arts Center Fund Total Equipment Replacement Fund 01-ERP-0003 117,25022,000 22,000 22,000 25,000 26,250CH - Network Server n/a 01-ERP-0004 76,00076,000Telephone System n/a 01-ERP-0006 165,76930,000 31,500 33,075 34,729 36,465Computersn/a 01-ERP-0008 11,30011,300Document Management Scanner (2)n/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0014 50,00050,000Distribution Network Switches n/a 01-ERP-0015 66,00066,000Backup Server n/a 01-ERP-0017 154,00011,000 22,000 33,000 44,000 44,000IT - Office 365 n/a 01-ERP-0018 19,00019,000IT - RSA/Netmotion VPN n/a 01-ERP-0019 19,39019,390IT - Email Threat Protection n/a 01-ERP-0020 70,00030,000 10,000 10,000 10,000 10,000IT - Patching Automation Software 1 01-ERP-0037 20,00020,000Activity Center Security System Upgrade 1 01-ERP-0038 29,00017,000 12,000Activity Center Kitchen Storage 5 01-ERP-0039 16,00016,000Activity Center Dishwasher 5 01-ERP-0041 62,62462,624Activity Center A/V Replacement & Upgrade 1 01-ERP-0051 40,00040,000City Hall Exterior Security Camera System 1 01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0109 91,00029,000 30,000 32,000Extrication Tool (2)n/a 01-ERP-0112 15,40015,400Thermal Imaging Camera (2)n/a 01-ERP-0125 368,000368,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0200 591,30098,000 107,400 161,100 107,400 117,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 57,00057,000Sergeant's Vehicle n/a 01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 72,10072,100PSO - Utility 4x4 n/a 01-ERP-0211 117,25022,000 22,000 22,000 25,000 26,250PD - Network Server n/a 01-ERP-0212 85,00085,000Squad Car Camera Systems n/a 01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 76,00076,000Taser Replacement n/a 01-ERP-0218 37,00020,000 17,000Building Video Server n/a 01-ERP-0219 20,00010,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-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0303 53,40053,4001 Ton Dump Truck (2)n/a 01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a 01-ERP-0308 268,600268,600Front End Loaders (2)n/a Tuesday, November 6, 2018 18 TotalSourceProject #Priority 2019 2020 2021 2022 2023 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0311 230,000230,000Sweepern/a 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0808 13,90013,900Riding Mowers (2)n/a 01-ERP-0810 92,70092,700Large Turf Mower n/a 4,618,395657,390 701,724 616,875 1,038,329 1,604,077Equipment Replacement Fund Total HRA - Housing and Redevelopment A 01-ERP-0400 41,10041,1004x4 3/4 Ton Truck n/a 01-ERP-0401 16,50016,500HRA Copier n/a 57,60016,500 41,100HRA - Housing and Redevelopment Authority Total RF - Refuse Fund 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a 352,100270,300 81,800RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0555 43,00043,000Generator (2)n/a 49,80043,000 6,800SF - Sanitary Sewer Fund Total WF - Water Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0503 35,00035,000Air Compressor 2 41,80035,000 6,800WF - Water Fund Total 5,133,195692,390 701,724 887,175 1,193,129 1,658,777GRAND TOTAL Tuesday, November 6, 2018 19 20 EQUIPMENT REQUESTS 21 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2019 2023thru Department Comm Svcs - Activity Center Description Upgrade the present security system, which was installed in 2008. Project #01-ERP-0037 Priority 1 Urgent Justification "It is important that we monitor who is in the Activity Center as well as their activity while here to insure the safety of our participants and staff. Staff works numerous hours while alone within the building. There is no panic button here to alert the police the staff is in trouble here, therefore we must rely on security cameras to deter those who might want to do harm to participants or staff, or damage to the building itself. Cameras can at least help identify the perpetrator if something should happen. Monitoring the outside of the facility would help assure the safety of our staff who come to work and leave work alone in the dark. It will also help deter and identify those wanting to use our outside trash and recycling bins for their personal use. Recommendation to complete security upgrades after capital improvements in the facility. Budget Impact/Other Useful Life 15-18 yearsProject Name Activity Center Security System Upgrade Category Equipment Type Equipment Future Total Project Cost:$20,000 Total20192020202120222023Expenditures 20,00020,000Equipment 20,000 20,000Total Total20192020202120222023Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Tuesday, November 6, 2018 22 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2019 2023thru Department Comm Svcs - Activity Center Description Purchase of stainless steel enclosed cabinets for the kitchen over a 2-year span. Project #01-ERP-0038 Priority 5 Future Consideration Justification The Activity Center kitchen presently has open type shelving cages, purchased in 1991. Shelving should be replaced with shelving conducive to water as some shelves are used for storing silverware and coffee cups directly from the dishwasher. The present shelving is rusting. Enclosed units are needed to secure items we use for our own kitchen operation from facility use renters, as well as proper storage of equipment from the dirt, dust, and grim associated with everyday use of the kitchen. Budget Impact/Other Useful Life 30 yearsProject Name Activity Center Kitchen Storage Category Equipment Type Equipment Future Total Project Cost:$29,000 Total20192020202120222023Expenditures 29,00017,000 12,000Equipment 17,000 12,000 29,000Total Total20192020202120222023Funding Sources 29,00017,000 12,000Equipment Replacement Fund 17,000 12,000 29,000Total Tuesday, November 6, 2018 23 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2019 2023thru Department Comm Svcs - Activity Center Description Replace the current dishwasher when it can no longer be repair or the Hennepin county Health Department no longer approves its use. This project was previously budgeted, but will not be replaced until the existing system malfuncations. Project #01-ERP-0039 Priority 5 Future Consideration Justification A dishwasher is a required piece of equipment for a functioning commercial kitchen that is needed for the Depot Coffee House operation, Activity Center events as well as the Activity Center's rental program. Budget Impact/Other Useful Life 30 yearsProject Name Activity Center Dishwasher Category Equipment Type Equipment Future Total Project Cost:$16,000 Total20192020202120222023Expenditures 16,00016,000Equipment 16,000 16,000Total Total20192020202120222023Funding Sources 16,00016,000Equipment Replacement Fund 16,000 16,000Total Tuesday, November 6, 2018 24 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2019 2023thru Department Comm Svcs - Activity Center Description C o n t i n u e t h i s r e p l a c e m e n t p r o j e c t t h a t b e g a n i n 2 0 1 6 t o r e p l a c e a n d u p g r a d e t h e a u d i o a n d v i s u a l s y s t e m w i t h i n t h e H o p k i n s A c t i v i t y C e n t e r , a r e a by area, throughout the next 4 years. Note: The gym has already been replaced and upgraded. Project #01-ERP-0041 Priority 1 Urgent Justification The present sound system in this facility was installed in 1980. It was primarily used as a paging system. This replacement and upgrading project began in 2016. We continue to replace and upgrade the audio/visual system in a new area each year, except 2018, to allow better hearing for our participants as well amplification devices for speakers, presenters, leaders, and instructors. We add equipment to use the technology now available for visual enhancements using our present televisions in various areas that are used in presentations, classroom instruction, and recreational activities. We are recommending delaying the project to corelate with the potential improvements at the Activity Center. We would like to complete upgrades at once time to ensure all equipment is compatible. There is a concern about the previously upgraded equipment having compatibility issues if delayed for too many years. We have upgraded sound and visual in the gymnasium and it has made significant difference in our participant’s ability to hear and see in the programs they participate in. In addition, those who have rented from us and have used our upgraded equipment say how much it has enhanced their events. Budget Impact/Other Useful Life 15-20 yearsProject Name Activity Center A/V Replacement & Upgrade Category Equipment Type Improvement Future Total Project Cost:$62,624 Total20192020202120222023Expenditures 62,62462,624Equipment 62,624 62,624Total Total20192020202120222023Funding Sources 62,62462,624Equipment Replacement Fund 62,624 62,624Total Tuesday, November 6, 2018 25 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2019 2023thru Department Comm Svcs - Arts Center Description Install a projector in a ceiling mount. Wire speakers into the ceiling. Wire input for computer on front wall. Add two microphones. Mount supporting hardware in rack that fits into closet. Originally scheduled for the Community Room this project was moved to the Jaycee Studio as they found a greater need for this equipment in that room. Project #01-ERP-1105 Priority n/a Justification An increasing number of users of this room require media support. Current means of providing this include the use of an oversized A/V cart, cords stretch across the floor and a large speaker on a stick. We can streamline the appearance and functionality by making these appropriate changes. These changes also address safety concerns. They will help attract safety concerns. They will help attract and retain rental customers as well as appropriately support our own activities. Budget Impact/Other Move this item from 2014 to 2015. Useful Life 7 yearsProject Name Art Center Jaycee Studio Audio Visual Category Equipment Type Equipment Future Total Project Cost:$41,100 Total20192020202120222023Expenditures 13,50013,500Equipment 13,500 13,500Total Total20192020202120222023Funding Sources 13,50013,500AC - Arts Center Fund 13,500 13,500Total Tuesday, November 6, 2018 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru 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 Changes reflect anticipated need for increased storage. Useful Life 1 yearProject Name CH - Network Server Category Equipment Type Equipment Future Total Project Cost:$627,250 Total20192020202120222023Expenditures 117,25022,000 22,000 22,000 25,000 26,250Equipment 22,000 22,000 22,000 25,000 26,250 117,250Total Total20192020202120222023Funding Sources 117,25022,000 22,000 22,000 25,000 26,250Equipment Replacement Fund 22,000 22,000 22,000 25,000 26,250 117,250Total Tuesday, November 6, 2018 27 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru Department Comm Svcs - IT Description Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Project #01-ERP-0004 Priority n/a Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Budget Impact/Other Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015. Estimate salvage/resale value on replaced item: $ Useful Life 8 yearsProject Name Telephone System Category Equipment Type Equipment Future Total Project Cost:$349,900 Total20192020202120222023Expenditures 89,60089,600Equipment 89,600 89,600Total Total20192020202120222023Funding Sources 76,00076,000Equipment Replacement Fund 6,8006,800SF - Sanitary Sewer Fund 6,8006,800WF - Water Fund 89,600 89,600Total Tuesday, November 6, 2018 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2019 2023thru 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 Increase in expenditure a result of supporting more computers than when the original allotment was put in place. Useful Life 3-5 yearsProject Name Computers Category Equipment Type Equipment Future Total Project Cost:$1,065,769 Total20192020202120222023Expenditures 165,76930,000 31,500 33,075 34,729 36,465Equipment 30,000 31,500 33,075 34,729 36,465 165,769Total Total20192020202120222023Funding Sources 165,76930,000 31,500 33,075 34,729 36,465Equipment Replacement Fund 30,000 31,500 33,075 34,729 36,465 165,769Total Tuesday, November 6, 2018 29 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2019 2023thru Department Comm Svcs - IT Description Install new and additional network wiring and equipment. Project #01-ERP-0009 Priority n/a Justification Improve capacity, coverage and reliability. Installation will coincide with office space update. Budget Impact/Other Variance from 20 year plan - new item to replace substandard network wiring. Estimate salvage/resale value on replaced item: $ Useful Life 15 yearsProject Name Network Infrastructure Upgrade Category Equipment Type Equipment Future Total Project Cost:$38,400 Total20192020202120222023Expenditures 23,40023,400Equipment 23,400 23,400Total Total20192020202120222023Funding Sources 23,40023,400Equipment Replacement Fund 23,400 23,400Total Tuesday, November 6, 2018 30 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru 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 yearsProject Name Distribution Network Switches Category Equipment Type Equipment Future Total Project Cost:$107,000 Total20192020202120222023Expenditures 50,00050,000Equipment 50,000 50,000Total Total20192020202120222023Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Tuesday, November 6, 2018 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru 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 yearsProject Name Backup Server Category Equipment Type Equipment Future Total Project Cost:$132,000 Total20192020202120222023Expenditures 66,00066,000Equipment 66,000 66,000Total Total20192020202120222023Funding Sources 66,00066,000Equipment Replacement Fund 66,000 66,000Total Tuesday, November 6, 2018 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru Department Comm Svcs - IT Description Transition from the legacy model of Microsoft Office to Office 365. This project would transition 25 percent of our users and devices per year. Project #01-ERP-0017 Priority n/a Justification As we become a more mobile workforce embracing new mobile and remote technology we need to move away from the traditonal office that can only be installed on a Windows computer and transition to the version of Office that can be used in the cloud and as a mobile app. Unfortunately, as is becoming common with most enterprise softwre, you can no longer just purchase it out right, you must rent it from the software author. The cost for Office 365 will now be a yearly ongoing cost. Office 365 is common at other cities, corporations, and educational environments. Budget Impact/Other Useful LifeProject Name IT - Office 365 Category Equipment Type Equipment Future Total Project Cost:$154,000 Total20192020202120222023Expenditures 154,00011,000 22,000 33,000 44,000 44,000Equipment 11,000 22,000 33,000 44,000 44,000 154,000Total Total20192020202120222023Funding Sources 154,00011,000 22,000 33,000 44,000 44,000Equipment Replacement Fund 11,000 22,000 33,000 44,000 44,000 154,000Total Tuesday, November 6, 2018 33 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru Department Comm Svcs - IT Description RSA dual factor authentication and Netmotion VPN software, yearly maintenance, and replacement of RSA tokens every 3 years. Project #01-ERP-0018 Priority n/a Justification This software would replace our current VPN solution with a more stable, always on connection for city owned devices. This enables our remote devices to channel all of their communication through the city's connection, taking advantage of all of the protection mechanisms we have installed for our users. Remote devices will also be connected to any patching and backup mechanisms we have in place as well. Occasional VPN users will also benefit from the increased reliability of the new VPN software. Our current solution can drop users unexpetedly when they are working on tasks remotely. Hennepin County uses this solution very effectively with their large amount of remote workers. We would like to replicate that on a much smaller scale. Budget Impact/Other Does require yearly maintenance to be added in 2020 to operating budget. Currently $2,300 per year. Useful Life 5 yearsProject Name IT - RSA/Netmotion VPN Category Equipment Type Equipment Future Total Project Cost:$19,000 Total20192020202120222023Expenditures 19,00019,000Equipment 19,000 19,000Total Total20192020202120222023Funding Sources 19,00019,000Equipment Replacement Fund 19,000 19,000Total Tuesday, November 6, 2018 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru Department Comm Svcs - IT Description FireEye Email threat protection. Advanced antivirus specificly for email. Price is for a 5 year contract. Project #01-ERP-0019 Priority n/a Justification Our current antispam solution does a great job of reducing spam, but a terrible job of removing malicious items from email. This would add an additional layer of protection to our email. We would send our email through the spam filtering to remove spam, then filter out additional threats with this solution before email arrives at the user. Email has become the number one vector in which enterprises get hacked because you are relying on non technical users to spot extremely tricky deceptions. The threat is threefold. We are seeing items that are launched at the Internet at large, we are seeing items that are specifically targeted at us, and we are seeing items that come from vendors and other people he have established relationships with when they get hacked. Adding this service will help cut down on the amount of dangerous items that arrive in our inboxes. Budget Impact/Other Useful Life 5 yearsProject Name IT - Email Threat Protection Category Equipment Type Equipment Future Total Project Cost:$19,390 Total20192020202120222023Expenditures 19,39019,390Equipment 19,390 19,390Total Total20192020202120222023Funding Sources 19,39019,390Equipment Replacement Fund 19,390 19,390Total Tuesday, November 6, 2018 35 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru Department Comm Svcs - IT Description Software to automate the delivery of critical and maintenance patches to our enterprise endpoints and yearly maintenance of the software going forward. Project #01-ERP-0020 Priority 1 Urgent Justification Microsoft software has to be patched the second Tuesday of every month. Adobe software has to be patched every time a critical vulnerability is discovered, which can be twice in a week in a bad week. Other applications have to be patched as new releases are produced from vendors. Currently our staff must touch every endpoint for the majority of the software installs. We are using up an inordinate amount of staff time to patch all of our endpoints only to have to restart the cycle 3 weeks later. Automation of this process would free up staff time to work on other projects and problems for the city. Approx. two full weeks of 1FTE per month or 960 hours per year saved. Budget Impact/Other Useful Life 5 yearsProject Name IT - Patching Automation Software Category Equipment Type Equipment Future Total Project Cost:$70,000 Total20192020202120222023Expenditures 70,00030,000 10,000 10,000 10,000 10,000Equipment 30,000 10,000 10,000 10,000 10,000 70,000Total Total20192020202120222023Funding Sources 70,00030,000 10,000 10,000 10,000 10,000Equipment Replacement Fund 30,000 10,000 10,000 10,000 10,000 70,000Total Tuesday, November 6, 2018 36 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2019 2023thru Department Comm Svcs - IT Description Computer servers store information and system programs for Police Department. 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 Useful Life 3 yearsProject Name PD - Network Server Category Equipment Type Equipment Future Total Project Cost:$632,250 Total20192020202120222023Expenditures 117,25022,000 22,000 22,000 25,000 26,250Equipment 22,000 22,000 22,000 25,000 26,250 117,250Total Total20192020202120222023Funding Sources 117,25022,000 22,000 22,000 25,000 26,250Equipment Replacement Fund 22,000 22,000 22,000 25,000 26,250 117,250Total Tuesday, November 6, 2018 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact City Clerk 2019 2023thru 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 yearsProject Name Document Management Scanner (2)Category Equipment Type Equipment Future Total Project Cost:$87,600 Total20192020202120222023Expenditures 11,30011,300Equipment 11,300 11,300Total Total20192020202120222023Funding Sources 11,30011,300Equipment Replacement Fund 11,300 11,300Total Tuesday, November 6, 2018 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Asst City Manager 2019 2023thru Department Community Services Description Expand the current police department security system to ensure a 360 degree view of City Hall. Project #01-ERP-0051 Priority 1 Urgent Justification Currently we do not have a 360 degree view of City Hall. This has made some investigations in the past more difficult when incidents have occurred right outside of our own facility. It also is a security concern to not have a front view it there ever was an incident in the building. The cameras will also help us to protect the City’s assets. With the upgrade to the front entrance vestibule and landscaping it makes sense to add new cameras after the project is complete to ensure full 360 view Budget Impact/Other Useful Life 15 yearsProject Name City Hall Exterior Security Camera System Category Equipment Type Equipment Future Total Project Cost:$40,000 Total20192020202120222023Expenditures 40,00040,000Equipment 40,000 40,000Total Total20192020202120222023Funding Sources 40,00040,000Equipment Replacement Fund 40,000 40,000Total Tuesday, November 6, 2018 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2019 2023thru Department Fire Description Quick attack pumper/rescue. Current vehicle: 2012 Rescue (#104) Project #01-ERP-0105 Priority n/a Justification Would replace Rescue 8 (lite rescue) and use as a utility vehicle. This truck could be used for daytime and nighttime medicals and small fires. This will reduce having all personnel respond to small fires. It will also let us drop one engine in 2022 but still keep ISO rating. Budget Impact/Other Variance from 20 year plan - Useful life change to 10 years. Reoccurs every 10 years. Useful Life 10 yearsProject Name Quick Attack Pumper/Rescue (Rescue 8)Category Vehicles Type Equipment Future Total Project Cost:$737,100 Total20192020202120222023Expenditures 314,500314,500Equipment 314,500 314,500Total Total20192020202120222023Funding Sources 314,500314,500Equipment Replacement Fund 314,500 314,500Total Tuesday, November 6, 2018 40 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2019 2023thru 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 Estimate salvage/resale value on replaced item: $1,000 Purchased: 2007 Useful Life 10 yearsProject Name Extrication Tool (2)Category Equipment Type Equipment Future Total Project Cost:$210,800 Total20192020202120222023Expenditures 91,00029,000 30,000 32,000Equipment 29,000 30,000 32,000 91,000Total Total20192020202120222023Funding Sources 91,00029,000 30,000 32,000Equipment Replacement Fund 29,000 30,000 32,000 91,000Total Tuesday, November 6, 2018 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2019 2023thru 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 2013 & 2017 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. Reoccuring expenditure. Estimate salvage/resale value on replaced item: $-0- Useful Life 10 yearsProject Name Thermal Imaging Camera (2)Category Equipment Type Equipment Future Total Project Cost:$92,900 Total20192020202120222023Expenditures 15,40015,400Equipment 15,400 15,400Total Total20192020202120222023Funding Sources 15,40015,400Equipment Replacement Fund 15,400 15,400Total Tuesday, November 6, 2018 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2019 2023thru Department Fire Description Portable and mobile radios used by the police departments to allow the department to communicate on one frequency. Fire has 50 portable and 13 mobile radios along with 50 pagers. Cost in ERP includes portable radios (30), portable radio's encrypted (20), mobile radio's (13), pagers (50), chargers single (60), charger base (3) plus other needed equipment. Details of all items are on file with Fire and Finance Depts. Project #01-ERP-0125 Priority n/a Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. Budget Impact/Other In 2016 the Fire radios were separated from Police for better accountability. Project was adjusted for current pricing. 2019 - 340,000 FD 2019 - 28,000 PW Useful Life 5-7 yearsProject Name Fire Radios - Portable and Mobile Devices Category Equipment Type Equipment Future Total Project Cost:$662,075 Total20192020202120222023Expenditures 368,000368,000Equipment 368,000 368,000Total Total20192020202120222023Funding Sources 368,000368,000Equipment Replacement Fund 368,000 368,000Total Tuesday, November 6, 2018 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2019 2023thru Department Fire Description Fire Helmets for firefighters. Helmets are used for safety of personnel at Fire and other Emergency incidents. In 2017, the NFPA and OSHA Standard changed to recommending helmet change every 10 years. Project #01-ERP-0126 Priority n/a Justification Safety of Firefighters. Current helmets useful life will be up in 2023. Budget Impact/Other Reoccuring every 10 years. Useful Life 10 yearsProject Name Fire - Fire Helmets Category Equipment Type Equipment Future Total Project Cost:$34,000 Total20192020202120222023Expenditures 16,00016,000Equipment 16,000 16,000Total Total20192020202120222023Funding Sources 16,00016,000Equipment Replacement Fund 16,000 16,000Total Tuesday, November 6, 2018 44 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact 2019 2023thru Department Fire Description Lucus device is used to assist CPR during full arrest. The current device was purchased in 2016 and with changed in technology, it is recommended to update every 5 years. Project #01-ERP-0127 Priority n/a Justification To continue to serve citizens of Hopkins during medical incidents. Budget Impact/Other Reoccurs every 5 years. Useful LifeProject Name Fire - Lucus Device Category Unassigned Type Unassigned Future Total Project Cost:$75,500 Total20192020202120222023Expenditures 18,00018,000Equipment 18,000 18,000Total Total20192020202120222023Funding Sources 18,00018,000Equipment Replacement Fund 18,000 18,000Total Tuesday, November 6, 2018 45 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Unassigned 2019 2023thru Department HRA Description 4 wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snow plow. Current vehicle: 2015 Chevrolet Pickup Project #01-ERP-0400 Priority n/a Justification Transportation for Public Housing Superintendent and snow plowing at various HRA properties around the city. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,800 Useful Life 8 yearsProject Name 4x4 3/4 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$148,400 Total20192020202120222023Expenditures 41,10041,100Vehicles 41,100 41,100Total Total20192020202120222023Funding Sources 41,10041,100HRA - Housing and Redevelopment Authority 41,100 41,100Total Tuesday, November 6, 2018 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2019 2023thru Department HRA Description Color copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks. Current equipment: Imagistics ZB35 Project #01-ERP-0401 Priority n/a Justification Daily use to make copies of correspondence, forms and rental documents. Periodically produce documents such as resident newsletters and marketing. Machine will duplex, sort, collate and staple copies. Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replace item: $ - 0 - Useful Life 8 yearsProject Name HRA Copier Category Equipment Type Equipment Future Total Project Cost:$50,400 Total20192020202120222023Expenditures 16,50016,500Equipment 16,500 16,500Total Total20192020202120222023Funding Sources 16,50016,500HRA - Housing and Redevelopment Authority 16,500 16,500Total Tuesday, November 6, 2018 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2019 2023thru 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 marked patrol vehicles 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 yearsProject Name Marked Patrol Vehicles (7)Category Vehicles Type Equipment Future Total Project Cost:$3,382,600 Total20192020202120222023Expenditures 591,30098,000 107,400 161,100 107,400 117,400Vehicles 98,000 107,400 161,100 107,400 117,400 591,300Total Total20192020202120222023Funding Sources 591,30098,000 107,400 161,100 107,400 117,400Equipment Replacement Fund 98,000 107,400 161,100 107,400 117,400 591,300Total Tuesday, November 6, 2018 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2019 2023thru 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: 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 yearsProject Name Sergeant's Vehicle Category Vehicles Type Equipment Future Total Project Cost:$400,600 Total20192020202120222023Expenditures 57,00057,000Vehicles 57,000 57,000Total Total20192020202120222023Funding Sources 57,00057,000Equipment Replacement Fund 57,000 57,000Total Tuesday, November 6, 2018 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2019 2023thru 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 yearsProject Name PSO / Parking Enforcement Vehicle Category Vehicles Type Equipment Future Total Project Cost:$168,900 Total20192020202120222023Expenditures 53,70053,700Vehicles 53,700 53,700Total Total20192020202120222023Funding Sources 53,70053,700Equipment Replacement Fund 53,700 53,700Total Tuesday, November 6, 2018 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2019 2023thru 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 yearsProject Name PSO - Utility 4x4 Category Vehicles Type Equipment Future Total Project Cost:$328,300 Total20192020202120222023Expenditures 72,10072,100Vehicles 72,100 72,100Total Total20192020202120222023Funding Sources 72,10072,100Equipment Replacement Fund 72,100 72,100Total Tuesday, November 6, 2018 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2019 2023thru Department Police Description Squad car camera systems are used to document events inside and outside of the patrol vehicles. The cameras utilize a forward facing camera and a prisoner transport area camaera. Body cameras capture interactions between the officers and the public for transparency. Body cameras also capture evidence used in future court proceedings. Project #01-ERP-0212 Priority n/a Justification The police vehicle cameras are a necessary component of the patrol vehicles. Evidentiary information is collected from the cameras and often used in court. Cameras also provide a snapshot of an officers interaction with the public so we are able to maintain transparency and public trust with our operations. Budget Impact/Other Integrated camera system - 12 Squad car cameras and 20 body cameras Squad cameras 6,000/each. Body cameras 1,200/each. Useful Life 5 yearsProject Name Squad Car Camera Systems Category Equipment Type Equipment Future Total Project Cost:$577,500 Total20192020202120222023Expenditures 85,00085,000Equipment 85,000 85,000Total Total20192020202120222023Funding Sources 85,00085,000Equipment Replacement Fund 85,000 85,000Total Tuesday, November 6, 2018 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2019 2023thru Department Police Description 12 Tactical Ballistical Vests worn by members of the Hopkins Police Department SWAT (Special Weapons and Tactics) team. These vests offer a higher level of protection for officers involved in high risk situations; this protection offers a higher level of ballistic protection compared to regular duty vests. SWAT team members also require ballistic helmets on the same rotational cycle. Equipment breakdown: 12 vests @ $4,215 = $50,580. 12 ballistic helmets @ $642 = $7,716. 2 New protective shields @ $2,864 = $5,729. 12 Radio headsets @ $1,042 = $12,500. Project #01-ERP-0214 Priority 3 Important Justification Variance - Change in vendor equipment pricing and SWAT team staffing levels. Current price is reflective of a twelve person (fully staffed) SWAT team with current vendor pricing. Budget Impact/Other 2018 - 20,000 increase to reflect current staffing levels and needs. Useful Life 5 yearsProject Name Tactical Ballistic Vests / Helmets - SWAT Category Equipment Type Equipment Future Total Project Cost:$269,712 Total20192020202120222023Expenditures 76,51276,512Equipment 76,512 76,512Total Total20192020202120222023Funding Sources 76,51276,512Equipment Replacement Fund 76,512 76,512Total Tuesday, November 6, 2018 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2019 2023thru Department Police Description Portable radios used by the police departments to allow the department to communicate on one frequency. Estimated Replacement Cost Portable - $4,500 x 50 = $225,000 Plus chargers, shoulder mic's and batteries - $11,300 TOTAL = $236,300 In 2016 we will need to replace the portables as the current model will no longer be supported by Hennepin County. Project #01-ERP-0215 Priority n/a Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. Budget Impact/Other Radio's have a 7-10 year life expectancy. Portables need replacement due to manufacturer issues and county requirements. Increase in cost from $3,800 to $4,500 per radior. Mobile radios were removed and now will be included with the vehicles as they are replaced. Estimate salvage/resale value on replaced item: $0 Useful Life 5-7 yearsProject Name Police - Portable Radios Category Equipment Type Equipment Future Total Project Cost:$571,400 Total20192020202120222023Expenditures 290,000290,000Equipment 290,000 290,000Total Total20192020202120222023Funding Sources 290,000290,000Equipment Replacement Fund 290,000 290,000Total Tuesday, November 6, 2018 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Captain 2019 2023thru 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. 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 35- X2 Tasers, each officer has their own taser. Total overall cost each Taser in 2018 = $2166.00 (+ shipping) Useful Life 4 yearsProject Name Taser Replacement Category Equipment Type Equipment Future Total Project Cost:$202,600 Total20192020202120222023Expenditures 76,00076,000Equipment 76,000 76,000Total Total20192020202120222023Funding Sources 76,00076,000Equipment Replacement Fund 76,000 76,000Total Tuesday, November 6, 2018 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2019 2023thru 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 - Change in replacement schedule and estimated cost. Current equipment was purchased with DTF funding. Beginning in 2020 it will be funded with ERP funds. Estimate salvage/resale value on replaced item: $-0- Useful Life 4 yearsProject Name Building Video Server Category Equipment Type Equipment Future Total Project Cost:$88,000 Total20192020202120222023Expenditures 37,00020,000 17,000Equipment 20,000 17,000 37,000Total Total20192020202120222023Funding Sources 37,00020,000 17,000Equipment Replacement Fund 20,000 17,000 37,000Total Tuesday, November 6, 2018 56 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2019 2023thru 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 video server will be replaced with a cloud based storage solution after 2020. Budget Impact/Other Cost of yearly maintenance for video data storgae server: $10,000.00/year Server no longer maintained after 2020. Useful Life 5 yearsProject Name PD - Video Data Server Category Equipment Type Equipment Future Total Project Cost:$135,000 Total20192020202120222023Expenditures 20,00010,000 10,000Equipment 10,000 10,000 20,000Total Total20192020202120222023Funding Sources 20,00010,000 10,000Equipment Replacement Fund 10,000 10,000 20,000Total Tuesday, November 6, 2018 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2019 2023thru 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 Replacement in 2019 for 12 computers. 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 yearsProject Name Mobile Data Computers Category Equipment Type Equipment Future Total Project Cost:$290,000 Total20192020202120222023Expenditures 65,00065,000Equipment 65,000 65,000Total Total20192020202120222023Funding Sources 65,00065,000Equipment Replacement Fund 65,000 65,000Total Tuesday, November 6, 2018 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2019 2023thru 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. Project #01-ERP-0221 Priority n/a Justification A new RMS system may be needed by 2022. Budget Impact/Other Current cost to maintain system is $29,368 anually. Useful LifeProject Name Records Management System Category Equipment Type Equipment Future Total Project Cost:$150,000 Total20192020202120222023Expenditures 150,000150,000Equipment 150,000 150,000Total Total20192020202120222023Funding Sources 150,000150,000Equipment Replacement Fund 150,000 150,000Total Tuesday, November 6, 2018 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Public Works: Parks/Forestry Description Pickup used by Park Division of Public Works. Project #01-ERP-0800 Priority n/a Justification Budget Impact/Other Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name 1/2 Ton Pickup Truck Category Vehicles Type Equipment Future Total Project Cost:$109,400 Total20192020202120222023Expenditures 35,40035,400Vehicles 35,400 35,400Total Total20192020202120222023Funding Sources 35,40035,400Equipment Replacement Fund 35,400 35,400Total Tuesday, November 6, 2018 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru 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 yearsProject Name 4x4 3/4Ton Trucks (2)Category Vehicles Type Equipment Future Total Project Cost:$313,800 Total20192020202120222023Expenditures 85,20085,200Vehicles 85,200 85,200Total Total20192020202120222023Funding Sources 85,20085,200Equipment Replacement Fund 85,200 85,200Total Tuesday, November 6, 2018 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Public Works: Parks/Forestry Description Truck is used for hauling brush and logs in the Forestry department. Current vehicle: 2007 International LP4600 Log Truck (#811) Project #01-ERP-0804 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - 50% Equipment Replacement/50% Refuse - increase amount to $105,000 to reflect actual cost. Estimated useful life reduced from 20 to 15 years. Useful Life 15 yearsProject Name Log Truck Category Vehicles Type Equipment Future Total Project Cost:$268,600 Total20192020202120222023Expenditures 163,600163,600Vehicles 163,600 163,600Total Total20192020202120222023Funding Sources 81,80081,800Equipment Replacement Fund 81,80081,800RF - Refuse Fund 163,600 163,600Total Tuesday, November 6, 2018 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Public Works: Parks/Forestry Description Riding mowers used by Parks Division of Public Works. Current equipment: 2004 Toro Zero Turn (#826), 2006 Jacobson Rotary Mower (#823) Project #01-ERP-0808 Priority n/a Justification Mowing city parks and right of ways. Budget Impact/Other Variance from 20 year plan Estimate salvage/resale value on replaced item: $600 each Moved useful life from 8 year to 6 Useful Life 6 yearsProject Name Riding Mowers (2)Category Equipment Type Equipment Future Total Project Cost:$169,000 Total20192020202120222023Expenditures 13,90013,900Equipment 13,900 13,900Total Total20192020202120222023Funding Sources 13,90013,900Equipment Replacement Fund 13,900 13,900Total Tuesday, November 6, 2018 63 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru 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. Estimated useful life reduced from 10 to 8 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 8 yearsProject Name Large Turf Mower Category Equipment Type Equipment Future Total Project Cost:$332,300 Total20192020202120222023Expenditures 92,70092,700Equipment 92,700 92,700Total Total20192020202120222023Funding Sources 92,70092,700Equipment Replacement Fund 92,700 92,700Total Tuesday, November 6, 2018 64 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Public Works: Streets/Traffic Description Pickup used by various divisions of Public Works. Current vehicle: #301 Project #01-ERP-0300 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 2015 to 2013. Replace with 1/2 ton 4x4 pickup. Reduce amount from 33,600 to 21,500.. Estimate salvage/resale value on replaced item: $1,500 Useful Life 10 yearsProject Name 4x4 1/2 Ton Pickup with Plow Category Vehicles Type Equipment Future Total Project Cost:$114,200 Total20192020202120222023Expenditures 28,90028,900Vehicles 28,900 28,900Total Total20192020202120222023Funding Sources 28,90028,900Equipment Replacement Fund 28,900 28,900Total Tuesday, November 6, 2018 65 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Public Works: Streets/Traffic Description Truck is used in the Street Division of Public Works. Current vehicles: 2000 Ford F450 (#304) & 2011 Ford F350 (#308) Project #01-ERP-0303 Priority n/a Justification Vehicle used by various departments for street and park maintenance and light hauling. Budget Impact/Other Variance from 20 year plan - move back from 2009 to 2010. Estimated useful life reduced from 12 to 8 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 8 yearsProject Name 1 Ton Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$281,600 Total20192020202120222023Expenditures 53,40053,400Vehicles 53,400 53,400Total Total20192020202120222023Funding Sources 53,40053,400Equipment Replacement Fund 53,400 53,400Total Tuesday, November 6, 2018 66 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Public Works: Streets/Traffic Description Single axle dump truck used by various division of Public Works. Current vehicles: 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. Estimated useful life reduced from 17 to 15 years. Useful Life 15 yearsProject Name Single Axle Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$643,000 Total20192020202120222023Expenditures 225,000225,000Vehicles 225,000 225,000Total Total20192020202120222023Funding Sources 225,000225,000Equipment Replacement Fund 225,000 225,000Total Tuesday, November 6, 2018 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Public Works: Streets/Traffic Description Current equipment: 1991 Caterpillar 928E Loader (#320) & 2005 Caterpillar 938G (#322) Project #01-ERP-0308 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $ Useful Life 15-18 yearsProject Name Front End Loaders (2)Category Equipment Type Equipment Future Total Project Cost:$848,600 Total20192020202120222023Expenditures 268,600268,600Equipment 268,600 268,600Total Total20192020202120222023Funding Sources 268,600268,600Equipment Replacement Fund 268,600 268,600Total Tuesday, November 6, 2018 68 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Public Works: Streets/Traffic Description Loading trucks, landscape work, snow removal, material handling. Current equipment: 2004 Bobcat S-1851R Skid Loader (#324) & 2011 Bobcat S650 Skid-Steer Loader (#325) Project #01-ERP-0309 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - move back from 2010 to 2011. Estimate salvage/resale value on replaced item: $ Useful life reduced from 12 years to 10. Useful Life 10 yearsProject Name Skid Loader (2)Category Equipment Type Equipment Future Total Project Cost:$258,900 Total20192020202120222023Expenditures 50,00050,000Equipment 50,000 50,000Total Total20192020202120222023Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Tuesday, November 6, 2018 69 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru 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 reduced from 15 years to 12. Useful Life 12 yearsProject Name Sweeper Category Equipment Type Equipment Future Total Project Cost:$345,300 Total20192020202120222023Expenditures 230,000230,000Equipment 230,000 230,000Total Total20192020202120222023Funding Sources 230,000230,000Equipment Replacement Fund 230,000 230,000Total Tuesday, November 6, 2018 70 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru 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 yearsProject Name Refuse Truck (RAP-R) (2)Category Vehicles Type Equipment Future Total Project Cost:$1,462,600 Total20192020202120222023Expenditures 270,300270,300Vehicles 270,300 270,300Total Total20192020202120222023Funding Sources 270,300270,300RF - Refuse Fund 270,300 270,300Total Tuesday, November 6, 2018 71 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru 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 Estimated useful life reduced from 25 to 20 years. Estimate salvage/resale value on replaced item: $2,500 Useful Life 20 yearsProject Name Generator (2)Category Equipment Type Equipment Future Total Project Cost:$79,000 Total20192020202120222023Expenditures 43,00043,000Equipment 43,000 43,000Total Total20192020202120222023Funding Sources 43,00043,000SF - Sanitary Sewer Fund 43,000 43,000Total Tuesday, November 6, 2018 72 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2019 2023thru Department Water Description The portable air compressor is used in various parks and other public areas of the city to blow out irrigation lines every fall to prevent the lines from freezing. The streets department uses it for jack hammering asphalt and concrete repairs. Project #01-ERP-0503 Priority 2 Very Important Justification Our current 2003 Leroi air compressor was purchased used in 2008 with 1375 hours. The air compressor has met it's lifecycle of 15 years. Would like to replace another used air compressor. Budget Impact/Other Variance from 20 year plan - Move up from 2012 to 2008. Replace 1982 unit with larger capacity due to larger irrigation lines. Purchase new or slightly used machine. Estimate salvage/resale value on replaced item : $2,000 2019 - Variance from 20 year plan. Reduced to 15 year average. Will add purchase request for 2019 and move back 15 years for future consideration. Useful Life 15 yearsProject Name Air Compressor Category Equipment Type Equipment Future Total Project Cost:$98,100 Total20192020202120222023Expenditures 35,00035,000Equipment 35,000 35,000Total Total20192020202120222023Funding Sources 35,00035,000WF - Water Fund 35,000 35,000Total Tuesday, November 6, 2018 73 74 TWENTY-YEAR REPLACEMENT SCHEDULE 75 12/4/2017 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average:1,118,200$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 ACTIVITY CENTER ERP-0032 Sound System 15 13,700 ERP-0035 Floor Scrubber 10 6,700 9,000 ERP-0036 Sound System Replacement 25 ERP-0037 Security System Upgrade 15-18 20,000 ERP-0038 Kitchen Storage 30 17,000 12,000 ERP-0039 Dishwasher 30 16,000 ERP-0041 A/V Replacement & Upgrade 20 62,624 SUBTOTAL 16,000 82,624 17,000 12,000 6,700 13,700 9,000 ARTS CENTER ERP-1101 Carpet Extractor 10 7,000 ERP-1102 Kitchen Catering Equipment 12 7,100 ERP-1105 Community Room A/V 7 13,500 16,600 ERP-1107 Theater Projection Screen 10 6,700 9,000 ERP-1109 Floor Scrubber 10 10,800 ERP-1112 Surveillance System 5 6,000 13,500 6,700 10,800 7,100 6,000 16,600 7,000 9,000 COMMUNITY SERVICES ERP-0008 Document Mgmt. Scanner (2)4 11,300 12,700 14,300 16,000 18,100 ERP-0010 Election Booths 20 6,500 ERP-0051 Exterior Security Camera System 15 40,000 65,000 EQUIPMENT SUBTOTAL 51,300 12,700 14,300 6,500 16,000 65,000 18,100 FIRE ERP-0100 Tele-Squirt E-2 10 1,000,000 ERP-0101 Fire Pumper E-3 20 722,400 ERP-0105 Quick Attack Pumper/Rescue R-8 10 314,500 422,600 ERP-0106 Aerial Truck 20 1,572,000 VEHICLES SUBTOTAL 314,500 722,400 1,000,000 1,572,000 422,600 ERP-0107 Air Compressor 15 54,400 ERP-0108 Breathing Apparatus (45) (SCBA)10 250,000 336,000 ERP-0109 Extrication Tool (2)10 29,000 30,000 32,000 36,900 40,300 ERP-0112 Thermal Imaging Camera (2)10 15,400 17,400 20,700 ERP-0113 Emergency Preparedness Siren 20 38,500 ERP-0114 Floor Scrubber 12 20,300 ERP-0125 Radios-Portable & Mobile 5-7 368,000 431,498 514,700 ERP-0126 Helmets 10 16,000 22,000 ERP-0127 Lucus Device 5 18,000 20,000 24,000 30,000 EQUIPMENT SUBTOTAL 29,000 30,000 449,400 250,000 38,500 37,700 20,000 468,398 54,400 40,300 66,700 850,700 30,000 IT ERP-0003 City Hall - Network Upgrade 1 22,000 22,000 22,000 25,000 26,250 27,038 27,849 28,684 29,545 30,431 31,344 32,284 33,253 34,250 35,278 36,336 37,426 38,549 39,705 40,897 ERP-0004 Phone System 8 89,600 110,700 ERP-0005 Financial Software 7 ERP-0006 Computers 3-5 30,000 31,500 33,075 34,729 36,465 38,288 40,203 42,213 44,323 46,540 48,867 51,310 53,875 56,569 59,398 62,368 65,486 68,760 72,198 75,808 ERP-0009 Network Infrastructure Upgrade 15 23,400 ERP-0012 Core Network Switch 6 20,000 24,000 27,000 ERP-0014 Distribution Network Switches 5 50,000 57,000 65,000 75,000 ERP-0015 Backup Server 3 66,000 74,000 78,000 82,000 87,000 ERP-0017 Office 365 1 11,000 22,000 33,000 44,000 44,000 45,000 47,000 49,000 51,000 54,000 57,000 60,000 63,000 66,000 69,000 72,000 75,000 78,000 80,000 85,000 ERP-0018 RSA/Netmotion VPN 5 19,000 21,000 24,000 27,000 ERP-0019 Email Threat Protection 5 19,390 21,500 26,500 30,000 ERP-0020 Patching Automation Software 5 30,000 10,000 10,000 10,000 10,000 40,000 10,000 10,000 10,000 10,000 50,000 10,000 10,000 10,000 10,000 60,000 10,000 10,000 10,000 10,000 ERP-0211 Police - Network Server (3)3 22,000 22,000 22,000 25,000 26,250 27,038 27,849 28,684 29,545 30,431 31,344 32,284 33,253 34,250 35,278 36,336 37,426 38,549 39,705 40,897 EQUIPMENT SUBTOTAL 153,390 223,500 120,075 162,129 232,565 239,863 209,900 232,581 164,413 171,401 347,054 274,878 304,081 201,070 290,953 324,040 300,338 347,858 241,609 252,601 POLICE ERP-0200 Squad 3 98,000 107,400 161,100 107,400 117,400 117,400 117,400 128,000 128,000 128,000 140,000 140,000 140,000 153,200 153,200 153,000 157,000 160,000 165,000 170,000 ERP-0201 Sergeant Vehicle #209 4 57,000 57,000 60,000 72,000 80,000 ERP-0202 Parking Vehicle #211 10 53,700 60,000 65,000 ERP-0203 PSO Utility 4x4 #212 6 72,100 86,100 90,000 92,000 ERP-0205 SWAT Vehicle #240 15 77,900 VEHICLES SUBTOTAL 98,000 107,400 271,800 179,500 117,400 117,400 174,400 274,100 128,000 128,000 200,000 230,000 217,900 153,200 225,200 245,000 157,000 225,000 245,000 170,000 ERP-0208 Computer System 20 200,000 ERP-0212 Mobile Data Computers/Digital Cameras 7 65,000 148,500 148,500 150,000 ERP-0214 Tactical Ballistic Vests (9)5 76,512 45,000 50,000 ERP-0215 Radios-Portable & Mobile 5-7 290,000 310,000 325,000 ERP-0217 Taser Replacement 4 76,000 35,000 38,000 42,000 45,000 ERP-0218 Building Video Server 4 20,000 17,000 17,000 17,000 19,000 ERP-0219 PD - Squad Video Server 5 10,000 10,000 ERP-0220 Data 911 Computers 5 85,000 70,000 75,000 80,000 ERP-0222 Body Worn Camera 5 150,000 165,000 175,000 185,000 EQUIPMENT SUBTOTAL 160,000 30,000 150,000 459,512 218,500 35,000 182,000 45,000 533,500 38,000 17,000 175,000 250,000 272,000 344,000 185,000 45,000 76 REPL EQUIPMENT /VEHICLES YRS 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 P.W. BLDG./EQUIPMENT SVCS ERP-0710 1/2 Ton Truck 10 42,100 47,000 ERP-0711 Vehicle Washer 12 8,300 ERP-0712 4x4 3/4 Ton Pick-up Truck 15 49,800 ERP-0715 PW - Forklift 15 28,000 42,100 8,300 49,800 28,000 47,000 P.W. ENGINEERING ERP-0700 Engineering Van 10 28,900 38,800 P.W. PARKS & FORESTRY ERP-0800 1/2 Ton Truck 10 35,400 47,600 ERP-0801 4x4 3/4 Ton Truck 8 85,200 108,000 115,000 ERP-0802 3/4 Ton Utility Truck 10 48,700 ERP-0804 Log Truck (50% w/Refuse)15 81,800 ERP-0805 Aerial Lift 20 228,900 ERP-0806 Tractor 30 52,000 ERP-0807 Truckster 15 17,140 53,200 ERP-0808 Riding Mower (8 13,900 25,300 17,700 32,100 19,000 35,000 ERP-0810 Large Turf Mower (#825)10 92,700 124,600 ERP-0812 Stump Cutter 20 45,000 ERP-0813 Brush Clipper 20 43,700 ERP-0814 Trailer Flatbed 15 10,000 12,500 ERP-0815 Skid Loader 12 45,600 50,000 ERP-0816 Toolcat 8 80,200 101,600 ERP-0817 Grass Seed Applicator 20 17,900 VEHICLES SUBTOTAL 177,900 81,800 49,300 35,300 80,200 17,140 232,600 45,600 313,200 32,100 91,300 206,800 127,500 64,000 85,000 P.W. STREETS/TRAFFIC ERP-0300 4x4 3/4 Ton Truck/Plow 10 28,900 38,800 ERP-0301 4x4 3/4 Ton Truck/Plow 8 38,500 48,800 ERP-0302 4x2 1 Ton Dump Truck 12 77,800 ERP-0303 1 Ton Dump Truck 12 53,400 49,500 76,100 ERP-0304 1 Ton Boom Truck 17 136,400 ERP-0305 Single Axle Dump Truck 17 225,000 210,600 ERP-0306 Tandem Dump Truck 17 286,000 294,000 ERP-0307 Water Truck 22 201,000 ERP-0308 Front End Loader 15 268,600 268,000 ERP-0309 Skid Loader 12 50,000 59,700 71,300 ERP-0310 Grader 20 167,300 ERP-0311 Sweeper 20 230,000 ERP-0312 Roller 20 82,000 ERP-0313 Striper 12 16,000 ERP-0314 Paver 20 120,000 ERP-0315 Snow Blower 20 117,000 ERP-0316 Trailer 20 4,900 ERP-0317 Sign Machine 10 18,100 ERP-0318 Asphalt Hot Mix Heating Box 12 22,100 ERP-0319 Regenerative Air Sweeper 20 210,000 ERP-0320 Planer 20 18,600 VEHICLES SUBTOTAL 230,000 225,000 103,400 297,500 110,100 167,300 18,100 268,000 269,700 363,000 82,700 219,600 168,800 38,800 550,400 294,000 82,000 HRA ERP-0400 4x4 3/4 Ton Truck 8 41,100 52,100 ERP-0401 Copier 8 16,500 20,900 SUBTOTAL 16,500 41,100 20,900 52,100 PAVILION ERP-1000 Ice Resurfacer 12 165,000 ERP-1001 Electric Ice Edger 12 8,900 ERP-1002 Arena Scoreboard 20 12,000 ERP-1003 Floor Scrubber 10 11,600 15,600 ERP-1004 Scissor Lift 15 16,200 SUBTOTAL 11,600 185,900 16,200 15,600 REFUSE ERP-0900 Refuse Truck (RAP-R)10 270,300 275,200 363,200 ERP-0901 Refuse Truck (Rear-L)10 136,500 ERP-0803 Swap Loader 20 171,000 ERP-0804 Log Truck (50% w/Forestry)20 81,800 SUBTOTAL 270,300 81,800 275,200 363,200 136,500 171,000 77 REPL EQUIPMENT /VEHICLES YRS 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 WATER ERP-0500 1./2 Ton Truck 10 36,000 54,000 ERP-0501 3/4 Ton Utility Truck 10 46,900 ERP-0502 Backhoe 20 153,700 ERP-0503 Air Compressor 20 35,000 SUBTOTAL 35,000 46,900 36,000 153,700 54,000 SEWER ERP-0550 4x4 3/4 Ton Truck 10 40,300 54,200 ERP-0551 3/4 Ton Utility Truck 10 45,200 54,000 ERP-0552 Jet Vactor 20 ERP-0555 Generator 25 43,000 SUBTOTAL 43,000 40,300 45,200 54,200 54,000 TOTALS 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 GENERAL FUND-VEHICLES/EQUIP 328,000 285,300 496,800 679,200 464,200 291,700 341,700 1,136,900 1,413,140 2,202,300 608,600 625,900 519,400 744,600 355,300 1,041,000 451,000 399,500 391,000 255,000 GENERAL FUND-OTHER EQUIP 329,390 416,424 120,075 359,129 1,153,477 471,063 459,900 312,781 384,113 250,701 1,357,252 333,078 375,481 432,370 635,653 596,040 1,560,038 559,958 241,609 327,601 HRA - - - 16,500 41,100 20,900 52,100 ARTS CENTER - - - 13,500 6,700 10,800 7,100 6,000 16,600 7,000 9,000 REFUSE - - 270,300 81,800 275,200 363,200 136,500 171,000 PAVILION - - - - 11,600 185,900 16,200 15,600 WATER 35,000 - - - 46,900 36,000 153,700 54,000 SEWER - - - 43,000 40,300 45,200 54,200 54,000 GENERAL FUND TOTAL 657,390 701,724 616,875 1,038,329 1,617,677 762,763 801,600 1,449,681 1,797,253 2,453,001 1,965,852 958,978 894,881 1,176,970 990,953 1,637,040 2,011,038 959,458 632,609 582,601 HRA TOTAL - - - 16,500 41,100 20,900 52,100 ARTS CENTER FUND TOTAL - - - 13,500 6,700 10,800 7,100 6,000 16,600 7,000 9,000 ENTERPRISE FUNDS TOTAL 35,000 - 270,300 124,800 51,900 275,200 278,000 36,000 16,200 363,200 290,200 171,000 69,800 108,000 TOTAL ALL FUNDS 692,390 701,724 887,175 1,193,129 1,658,777 821,363 1,087,600 1,734,781 1,839,253 2,453,001 1,998,652 979,878 1,310,181 1,474,170 1,161,953 1,715,840 2,011,038 1,067,458 632,609 582,601 GENERAL FUND SALVAGE 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 NET GENERAL FUND 617,390 661,724 576,875 998,329 1,577,677 722,763 761,600 1,409,681 1,757,253 2,413,001 1,925,852 918,978 854,881 1,136,970 950,953 1,597,040 1,971,038 919,458 592,609 542,601 20 YEAR AVERAGES:Total Average ACTIVITY CENTER ADMINISTRATION 157,024 7,900 IT 4,794,301 239,700 COMMUNITY SERVICES 183,900 9,200 FIRE EQUIPMENT 4,031,500 201,600 FIRE ADMINISTRATION 2,365,098 118,300 POLICE EQUIPMENT 3,664,300 183,200 POLICE ADMINISTRATION 3,139,512 157,000 PUBLIC WORKS ADMINISTRATION BLDG./EQUIPMENT SERVICES EQUIPMENT 175,200 8,800 ENGINEERING EQUIPMENT 67,700 3,400 PARKS/FORESTRY EQUIPMENT 1,639,740 82,000 STREET EQUIPMENT 3,488,400 174,400 GENERAL FUND VEHICLE/EQUIPMENT 13,066,840 653,300 GENERAL FUND OTHER EQUIPMENT 10,639,835 532,000 GENERAL FUND TOTAL 23,706,675 1,185,300 HRA FUND 130,600 6,500 ARTS CENTER FUND 76,700 3,800 REFUSE FUND 1,298,000 64,900 PAVILION FUND 229,300 11,500 WATER FUND 325,600 16,300 SEWER FUND 236,700 11,800 UTILITY VEHICLES/EQUIPMENT 2,296,900 114,800 26,003,575 78 EQUIPMENT INVENTORY 79 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2018 UNIT #YEAR MAKE MODEL VALUE FIRE DEPARTMENT 100 2017 PIERCE IMPEL 900,000$ 103 2006 PETERBILT 357 420,000 104 2012 FORD F550 248,500 105 2016 FORD F150 25,000 106 2015 FORD EXPLORER RED 47,500 107 2015 FORD EXPLORER BLK 47,500 108 2014 FORD F150 34,000 109 2008 PIERCE AREO XT 874,000 110 2017 FORD EXPLORER 47,500 115 1952 MACK NONE 4,000 POLICE DEPARTMENT 200 2018 FORD UTILITY 49,000$ 201 2018 FORD UTILITY 49,000 202 2018 FORD UTILITY 49,000 205 2016 FORD UTILITY 45,000 206 2016 FORD UTILITY 45,000 207 2017 FORD UTILITY 49,000 208 2017 FORD UTILITY 49,000 209 2018 FORD UTILITY 49,000 211 2016 FORD UTILITY 34,000 212 2018 FORD F150 55,000 213 2016 FORD TAURUS 25,000 214 2018 FORD EXPLORER 49,000 216 2011 FORD TAURUS 30,000 218 2013 FORD UTILITY BLUE 40,000 219 2012 FORD TAURUS 28,000 220 2017 FORD EXPLORER 50,000 221 2015 JEEP CHEROKEE 35,000 240 2017 FORD TRANSIT-350 67,000 299 2018 FORD F150 55,000 DWI.2015 FORD UTILITY 41,000 80 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2018 UNIT #YEAR MAKE MODEL VALUE STREET/TRAFFIC DIVISION 301 2013 FORD F-150 19,500$ 302 2018 FORD F350 DRW 54,600 303 2016 FORD F-250 26,500 307 2006 FORD F-350 27,400 308 2011 FORD F-350 20,300 309 2012 FORD F-450 30,300 311 2011 FREIGHTLINER M2-106V 79,400 312 2004 FREIGHTLINER M2-106 98,000 314 1998 FORD LTB500 84,000 315 2017 FREIGHTLINER 114SD 221,700 317 2016 FREIGHTLINER M2-106 69,400 320 1991 CATERPILLAR 928E 90,000 321 2012 CATERPILLAR 924K 177,500 322 2005 CATERPILLAR 938G 157,800 325 2011 BOBCAT S-650 35,100 326 1989 CATERPILLAR 140-G 82,000 327 2001 ELGIN PELICAN SE 105,000 328 2013 ISUZU 435 REGEN SWEEP 145,300 329 2017 BOMAG BW120 SL5 ROLLE 45,900 331 2016 BOBCAT S-650 35,100 337 1994 CATERPILLAR AP200B 17,000 343 2014 SNOWCRETE 84231 71,500 344 1996 SNO-GO WK800 58,000 346 2017 SNO- GO SG WK-800 160,000 348 2014 SPARKS T6202 TRAILER 5,300 350 1993 TOWMASTER T14 TRAILER 4,000 351 2004 TENNANT SWEEPER 3640 10,000 352 2017 FALCON PATCH TRAILER 15,000 ENGINEERING DIVISION 706 2015 FORD TRANSIT 250 24,000$ BUILDING MAINTENANCE & EQUIPMENT SERVICES 700 2015 FORD UTILITY 35,000$ 702 2004 FORD F350 18,000 704 2006 FORD F250 18,000 705 2018 FORD F350 30,000 708 2016 FORD TRANSIT 350 29,700 712 2015 FORD UTILITY 35,000 713 2014 FORD UTILITY 30,000 750 2018 CLARK GTS25-FORKLIFT 25,000 81 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2018 UNIT #YEAR MAKE MODEL VALUE PARKS/FORESTRY DIVISION 800 2013 FORD F-150 23,700$ 801 2012 FORD F-350 24,100 803 2004 FORD F-350 17,500 804 1995 CHEVROLET CC31403 45,000 806 2016 FORD TRANSIT 350 29,700 810 1993 INTERNATIONAL LP4700 50,000 811 2006 INTERNATIONAL LOG TRUCK 45,000 812 2010 FREIGHTLINER AERIAL LIFT 130,000 813 2019 FREIGHTLINER M2-106 235,000 816 2014 BOBCAT 5610 50,900 817 2018 BOBCAT 5600 63,300 818 2017 TORO WORKMAN HDX 13,000 820 2004 TORO WORKMAN 3200 15,000 822 2014 TORO MDE 18,000 823 2006 JACOBSON TURFCAT 600 10,000 825 2010 TORO 4100-D 56,500 826 2004 TORO Z587L 8,900 828 2001 DEWEZE ATM-72 21,000 829 2016 TORO 3280-D 10,000 831 2016 RAYCO RG45X 3,400 832 1997 VERMEER SC502 STUMP CTR 15,400 834 2013 VERMEER BRUSH CHIPPER 29,800 835 2016 BOBCAT S70 55,000 843 2007 CARR TRAILER 2,500 844 2010 FELLING FT-6T 6,000 845 1997 REMACKEL DT-D7-E 3,500 846 2001 DRESSEN 8110 2,000 848 2017 LOAD TRAIL TILT DECK 5,400 82 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2018 UNIT #YEAR MAKE MODEL VALUE HRA 411 2007 CHEVROLET 2500 17,500$ WATER/SEWER 501 2004 CHEVROLET 2500HD 16,000$ 502 2017 FORD F-150 SUPERCAB 28,000 503 2015 FORD F-350 24,000 508 2016 FORD TRANSIT CONNECT 25,000 509 2016 FORD F-350 65,000 510 2016 FORD F-350 30,000 531 2017 FREIGHTLINER 114SD 425,400 533 2012 CATERPILLAR 420-EH2 87,700 535 1992 KOHLER GEN/TRL 10,000 537 2010 CATERPILLAR C15 144,300 PAVILION 802 2012 FORD F-350 20,000$ 808 2014 ZAMBONI 552 126,000 809 2002 OLYMPIA MILLINEUM 87,800 REFUSE 900 2011 FREIGHTLINER M2-106 201,109$ 902 2015 FREIGHTLINER M2-106 232,500 903 2015 PETERBILT REAR LOADER 155,000 83