The URL can be used to link to this page

2018 - 2022 ERPEQUIPMENT REPLACEMENT PLAN 2018-2022 DATE: December 5th, 2017 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2018-2022 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2018-2022 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 7 Cash Flow Statements Equipment Replacement Fund 13 Five-Year Project Summaries Projects by Year 17 Department Summary 19 Projects by Department 20 Funding Source Summary 22 Projects by Funding Source 23 Equipment Requests Individual Equipment Request Details Activity Center 27 Arts Center 28 Community Services - IT 31 Fire 41 HRA 44 Police 45 Public Works 57 Refuse 69 Water/Sewer 71 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 75 Equipment Inventory 81 EQUIPMENT REPLACEMENT PLAN 2018-2022 TABLE OF CONTENTS 3 4 INTRODUCTION 5 6 EQUIPMENT REPLACEMENT PLAN 2018-2022 BACKGROUND AND SUMMARY OF CHANGES FROM 2016 PLAN Background The Equipment Replacement Plan is a twenty-year forecast and a five-year plan of equipment needs in the City of Hopkins. It is intended to inform the Council and citizens of the major equipment needs on the horizon. The first year of the plan becomes an adopted equipment budget and relates to the operating budget of the equipment replacement fund, which is approved on an annual basis. The remaining nineteen years represent an estimate of equipment needs and funding capabilities of the City. Funding requirements vary from year to year. In order to maintain a fairly consistent levy each year, the twenty- year schedule is projected with a 3% inflation factor for operating expenses. The cash flow requirements to fund equipment needs in the equipment replacement fund will experience a roller coaster effect over the next 20 years given the projected equipment needs and 3% inflation rate. The intragovernmental charges were increased in 2017 by 9% and will be increased in 2018 by 10%. Plans are to increase the rate going forward with increases of 9% in 2019 - 2022. The majority of items purchased with ERP funds are used by departments within the General Fund which accounts for the most of the operations of the city. There have been many changes in technology and the way we operate and as a result there is more equipment in the plan; however the rate has not increased to accommodate the increase in equipment. Equipment that was purchased with grants such as digital squad cameras, laptop computers in squad cars and fire vehicles, 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. As discussed above are scheduling a 10% rate increase for 2018-2022 and plan to sell Equipment Certificates in 2018 to fund some of the equipment scheduled for 2018-2019. This will allow us to replace aging equipment and spread the payments over 10 years. The required Equipment Certificate payment will be part of the debt levy in the applicable year. Each year staff re-evaluates the equipment needs and adjusts the schedule accordingly. Changes to the plan are reflected in the document. Refurbishments, extended life expectancy and closer cost estimates of replacements have been incorporated into the plan. The equipment replacement charges in the general fund represent approximately 3% of total general fund expenditures. 7 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 2017 Plan Highlights of changes from last year’s equipment replacement plan for the years 2018-2022: CS - Activity Center: No changes CS - Arts Center: Surveillance System was added in 2019 at a cost of $47,000. The current surveillance system is no longer functional. CS - IT: Fortimail Hardware Appliance added in 2019 at a cost of $10,000. Community Services: No changes Fire: No changes HRA No changes. Police: The cost of a building video server was increased by $3,000 and delayed from 2019 to 2020. The cost of Taser replacement scheduled in 2018 was increased by $6,000. The cost of tactical vests and helmets scheduled in 2018 has increased by $20,000. The changes accounts for outfitting one additional officer from the 2017 plan, a new protective shield and current vendor pricing. Public Works: Building/Equipment Services A new forklift has been added in 2018 for $25,000. Currently, staff uses a skidloader with forks. A forklift provides additional safety to public works staff and is the preferred method for handling pallets and materials. A ½ on truck replacement has been changed to a ¾ ton truck at an additional cost of $4,700 in 2018. Parks/Forestry No Changes 8 Streets/Traffic Sweeper scheduled for replacement in 2019 at a cost of $156,400 has increased in cost to $230,000. Single axle dump truck scheduled for replacement in 2021 at a cost of $132,100 has increased in cost to $225,000. A flatbed trailer scheduled for replacement in 2020 has been moved to 2024. Refuse No changes Sewer No Changes Water No Changes 9 10 CASH FLOW STATEMENT 11 12 City of HopkinsEquipment Replacement Fund (602)Rate Change9% 9% 10% 9% 9% 9% 6%ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET2016 2017 2018 2019 2020 2021 2022Working Capital Begin Year(373,504) 1,172,861 271,121 60,156 81,370 69,991 222,271 Revenues from charges408,459 445,220 489,742 533,819 581,863 634,231 672,284 Tax Levy250,000 250,000 250,000 250,000 Transfer in Debt Service Fund1,896,571 - - - - - - Interest earnings6,294 3,000 3,000 3,000 3,000 3,000 3,000 Other revenues (sale of assets)60,424 30,000 30,000 35,000 35,000 35,000 35,000 Enterpirse contribution to software upgrade57,508 - - - - - - Equipment Certificates (Bonds)- - 590,000 - - - - Interfund Loan- 610,000 - - - - - Total Revenues2,429,256 1,088,220 1,112,742 821,819 869,863 922,231 960,284 Expenditures (excludes Leases & Depr.) 268,755 76,544 78,840 81,206 83,642 86,151 88,735 Fire Truck Financing Pymnts (2009-2018)53,782 54,217 54,217 - - - - Capital Outlay - Equipment560,354 1,859,200 990,650 594,400 672,600 523,800 1,014,600 Repayment of Interfund Loan- - 200,000 125,000 125,000 160,000 - Total Expenses882,891 1,989,961 1,323,707 800,606 881,242 769,951 1,103,335 Working Capital Ending Balance1,172,861 271,121 60,156 81,370 69,991 222,271 79,220 (Unrestricted Net Position)13 14 FIVE-YEAR PROJECT SUMMARIES 15 16 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY YEAR 2018 2022thru Project Name Department Project #Priority Project Cost 2018 01-ERP-1112Art Center Surveillance System 1 47,000Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0012Core Network Switch n/a 17,000Comm Svcs - IT 01-ERP-0013Wi-Fi and Cellular n/a 6,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0106Aerial Truck n/a 54,217Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 147,000Police 01-ERP-0201Sergeant's Vehicle n/a 49,000Police 01-ERP-0203PSO - Utility 4x4 n/a 55,000Police 01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 55,000Police 01-ERP-0217Taser Replacement n/a 35,000Police 01-ERP-0219PD - Video Data Server n/a 115,000Police 01-ERP-07104X4 3/4 Ton Truck n/a 36,000Public Works: Bldg/Equip Serv 01-ERP-0715PW - Forklift 2 25,000Public Works: Bldg/Equip Serv 01-ERP-0816Toolcat n/a 63,300Public Works: Parks/Forestry 01-ERP-03024x2 1 Ton Dump Truck n/a 54,600Public Works: Streets/Traffic 01-ERP-0306Tandem Dump Truck (2)n/a 235,000Public Works: Streets/Traffic 01-ERP-0803Swap Loader n/a 95,000Refuse 1,163,117Total for 2018 2019 01-ERP-0036Activity Center Sound System Replacement 3 15,000Comm Svcs - Activity Center 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0016Fortimail Hardware Appliance n/a 10,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0109Extrication Tool (2)n/a 27,400Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 98,000Police 01-ERP-0212Squad Car Camera Systems n/a 65,000Police 01-ERP-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 594,400Total for 2019 2020 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0013Wi-Fi and Cellular n/a 6,000Comm Svcs - IT 01-ERP-0014Distribution Network Switches n/a 50,000Comm Svcs - IT 01-ERP-0015Backup Server n/a 66,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0008Document Management Scanner (2)n/a 11,300Community Services Thursday, November 30, 2017 17 Project Name Department Project #Priority Project Cost 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-0221Records Management System n/a 150,000Police 01-ERP-08014x4 3/4Ton Trucks (2)n/a 85,200Public Works: Parks/Forestry 01-ERP-0810Large Turf Mower n/a 92,700Public Works: Parks/Forestry 672,600Total for 2020 2021 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0200Marked Patrol Vehicles (7)n/a 161,100Police 01-ERP-0202PSO / Parking Enforcement Vehicle n/a 53,700Police 01-ERP-0219PD - Video Data Server n/a 10,000Police 01-ERP-0305Single Axle Dump Truck (2)n/a 225,000Public Works: Streets/Traffic 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 270,300Refuse 794,100Total for 2021 2022 01-ERP-1101Art Center Carpet Extractor n/a 5,200Comm Svcs - Arts 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 30,000Comm Svcs - IT 01-ERP-0009Network Infrastructure Upgrade n/a 23,400Comm 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-0217Taser Replacement n/a 32,000Police 01-ERP-0219PD - Video Data Server n/a 10,000Police 01-ERP-0222Body Worn Cameras n/a 160,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,174,600Total for 2022 GRAND TOTAL 4,398,817 Thursday, November 30, 2017 18 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2018 2022thru Total20182019202020212022Department Comm Svcs - Activity Center 15,00015,000 Comm Svcs - Arts Center 65,70047,000 18,700 Comm Svcs - IT 554,40097,000 84,000 196,000 74,000 103,400 Community Services 11,30011,300 Fire 426,11754,217 27,400 344,500 HRA 16,50016,500 Police 1,587,700456,000 238,000 287,400 224,800 381,500 Public Works: Bldg/Equip Serv 61,00061,000 Public Works: Parks/Forestry 404,80063,300 177,900 163,600 Public Works: Streets/Traffic 848,000289,600 230,000 225,000 103,400 Refuse 365,30095,000 270,300 Sewer 43,00043,000 1,163,117 594,400 672,600 794,100 1,174,600 4,398,817TOTAL Thursday, November 30, 201719 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2018 2022thru Total20182019202020212022DepartmentProject #Priority Comm Svcs - Activity Center 01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3 15,00015,000Comm Svcs - Activity Center Total Comm Svcs - Arts Center 01-ERP-1101 5,2005,200Art Center Carpet Extractor n/a 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1112 47,00047,000Art Center Surveillance System 1 65,70047,000 18,700Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0003 113,00022,000 22,000 22,000 22,000 25,000CH - Network Server n/a 01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computersn/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0012 17,00017,000Core Network Switch n/a 01-ERP-0013 12,0006,000 6,000Wi-Fi and Cellular n/a 01-ERP-0014 50,00050,000Distribution Network Switches n/a 01-ERP-0015 66,00066,000Backup Server n/a 01-ERP-0016 10,00010,000Fortimail Hardware Appliance n/a 01-ERP-0211 113,00022,000 22,000 22,000 22,000 25,000PD - Network Server n/a 554,40097,000 84,000 196,000 74,000 103,400Comm Svcs - IT Total Community Services 01-ERP-0008 11,30011,300Document Management Scanner (2)n/a 11,30011,300Community Services Total Fire 01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0106 54,21754,217Aerial Truck n/a 01-ERP-0109 57,40027,400 30,000Extrication Tool (2)n/a 426,11754,217 27,400 344,500Fire Total HRA 01-ERP-0401 16,50016,500HRA Copier n/a 16,50016,500HRA Total Police 01-ERP-0200 620,900147,000 98,000 107,400 161,100 107,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 49,00049,000Sergeant's Vehicle n/a 01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 127,10055,000 72,100PSO - Utility 4x4 n/a Thursday, November 30, 201720 Total20182019202020212022DepartmentProject #Priority 01-ERP-0212 65,00065,000Squad Car Camera Systems n/a 01-ERP-0214 55,00055,000Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0217 67,00035,000 32,000Taser Replacement n/a 01-ERP-0218 20,00020,000Building Video Server n/a 01-ERP-0219 155,000115,000 10,000 10,000 10,000 10,000PD - Video Data Server n/a 01-ERP-0220 65,00065,000Mobile Data Computers n/a 01-ERP-0221 150,000150,000Records Management System n/a 01-ERP-0222 160,000160,000Body Worn Cameras n/a 1,587,700456,000 238,000 287,400 224,800 381,500Police Total Public Works: Bldg/Equip Serv 01-ERP-0710 36,00036,0004X4 3/4 Ton Truck n/a 01-ERP-0715 25,00025,000PW - Forklift 2 61,00061,000Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0810 92,70092,700Large Turf Mower n/a 01-ERP-0816 63,30063,300Toolcatn/a 404,80063,300 177,900 163,600Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck 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-0306 235,000235,000Tandem Dump Truck (2)n/a 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0311 230,000230,000Sweepern/a 848,000289,600 230,000 225,000 103,400Public Works: Streets/Traffic Total Refuse 01-ERP-0803 95,00095,000Swap Loader n/a 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a 365,30095,000 270,300Refuse Total Sewer 01-ERP-0555 43,00043,000Generator (2)n/a 43,00043,000Sewer Total GRAND TOTAL 4,398,8171,163,117 594,400 672,600 794,100 1,174,600 Thursday, November 30, 201721 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2018 thru 2022 TotalSource20182019202020212022 AC - Arts Center Fund 65,70047,000 18,700 Bonds/Lease 54,21754,217 Equipment Replacement Fund 3,796,050990,650 594,400 672,600 523,800 1,014,600 HRA - Housing and Redevelopment Authority 16,50016,500 RF - Refuse Fund 423,35071,250 270,300 81,800 SF - Sanitary Sewer Fund 43,00043,000 1,163,117 594,400 672,600 794,100 1,174,600 4,398,817GRAND TOTAL Thursday, November 30, 2017 22 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2018 2022thru TotalSourceProject #Priority 2018 2019 2020 2021 2022 AC - Arts Center Fund 01-ERP-1101 5,2005,200Art Center Carpet Extractor n/a 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1112 47,00047,000Art Center Surveillance System 1 65,70047,000 18,700AC - Arts Center Fund Total Bonds/Lease 01-ERP-0106 54,21754,217Aerial Truck n/a 54,21754,217Bonds/Lease Total Equipment Replacement Fund 01-ERP-0003 113,00022,000 22,000 22,000 22,000 25,000CH - Network Server n/a 01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computersn/a 01-ERP-0008 11,30011,300Document Management Scanner (2)n/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0012 17,00017,000Core Network Switch n/a 01-ERP-0013 12,0006,000 6,000Wi-Fi and Cellular n/a 01-ERP-0014 50,00050,000Distribution Network Switches n/a 01-ERP-0015 66,00066,000Backup Server n/a 01-ERP-0016 10,00010,000Fortimail Hardware Appliance n/a 01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3 01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0109 57,40027,400 30,000Extrication Tool (2)n/a 01-ERP-0200 620,900147,000 98,000 107,400 161,100 107,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 49,00049,000Sergeant's Vehicle n/a 01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 127,10055,000 72,100PSO - Utility 4x4 n/a 01-ERP-0211 113,00022,000 22,000 22,000 22,000 25,000PD - Network Server n/a 01-ERP-0212 65,00065,000Squad Car Camera Systems n/a 01-ERP-0214 55,00055,000Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0217 67,00035,000 32,000Taser Replacement n/a 01-ERP-0218 20,00020,000Building Video Server n/a 01-ERP-0219 155,000115,000 10,000 10,000 10,000 10,000PD - Video Data Server n/a 01-ERP-0220 65,00065,000Mobile Data Computers n/a 01-ERP-0221 150,000150,000Records Management System n/a 01-ERP-0222 160,000160,000Body Worn Cameras n/a 01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck 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-0306 235,000235,000Tandem Dump Truck (2)n/a 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0311 230,000230,000Sweepern/a Thursday, November 30, 2017 23 TotalSourceProject #Priority 2018 2019 2020 2021 2022 01-ERP-0710 36,00036,0004X4 3/4 Ton Truck n/a 01-ERP-0715 25,00025,000PW - Forklift 2 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a 01-ERP-0803 23,75023,750Swap Loader n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0810 92,70092,700Large Turf Mower n/a 01-ERP-0816 63,30063,300Toolcatn/a 3,796,050990,650 594,400 672,600 523,800 1,014,600Equipment Replacement Fund Total HRA - Housing and Redevelopment A 01-ERP-0401 16,50016,500HRA Copier n/a 16,50016,500HRA - Housing and Redevelopment Authority Total RF - Refuse Fund 01-ERP-0803 71,25071,250Swap Loader n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a 423,35071,250 270,300 81,800RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0555 43,00043,000Generator (2)n/a 43,00043,000SF - Sanitary Sewer Fund Total 4,398,8171,163,117 594,400 672,600 794,100 1,174,600GRAND TOTAL Thursday, November 30, 2017 24 EQUIPMENT REQUESTS 25 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2018 2022thru Department Comm Svcs - Activity Center Description Replace and enhance the sound system in the Raspberry, Conference, Computer Nook, Harmony Hill, Lounge/Dining, and Office areas. Project #01-ERP-0036 Priority 3 Important Justification The present sound system in many of these areas are the original system installed in 1980. It was primarily used as a paging system. We will replace and enhance the sound system to allow better hearing for our participants as well as easier use of amplification devises for speakers, presenters, and instructors in these areas. Budget Impact/Other Useful Life 25 yearsProject Name Activity Center Sound System Replacement Category Equipment Type Equipment Future Total Project Cost:$15,000 Total20182019202020212022Expenditures 15,00015,000Equipment 15,000 15,000Total Total20182019202020212022Funding Sources 15,00015,000Equipment Replacement Fund 15,000 15,000Total Thursday, November 30, 2017 27 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2018 2022thru Department Comm Svcs - Arts Center Description The carpet extractor is used at the Arts Center and occasionally in other city facilities. The equipment is used to clean carpets on a regular basis between annual contractual cleanings, to remove spots and stains, and to pick up spills. Including carpet wand and long hose for ease of use, as well as low moisture capabilities. Project #01-ERP-1101 Priority n/a Justification The current equipment is over 12 years old and very corroded from the dirt, water and cleaning chemicals. With regular touch up cleaning and removal of stains in the Arts Center carpet with this extractor, the need to pay contractual cleaners to deep clean the carpet is reduced to once or twice annually. Budget Impact/Other Variance from 20 year plan - Increase cost from $3,300 to $3,900. Estimate salvage/resale value on replace item: $ Useful Life 10 yearsProject Name Art Center Carpet Extractor Category Equipment Type Equipment Future Total Project Cost:$16,100 Total20182019202020212022Expenditures 5,2005,200Equipment 5,200 5,200Total Total20182019202020212022Funding Sources 5,2005,200AC - Arts Center Fund 5,200 5,200Total Thursday, November 30, 2017 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2018 2022thru 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 Total20182019202020212022Expenditures 13,50013,500Equipment 13,500 13,500Total Total20182019202020212022Funding Sources 13,50013,500AC - Arts Center Fund 13,500 13,500Total Thursday, November 30, 2017 29 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2018 2022thru Department Comm Svcs - Arts Center Description 18 Interior cameras and 2 exterior cameras 1 Network video recorded with 30 days of storage 1 Network switch and power over Ethernet for cameras Cabling, installation, and programming of the cameras Estimated Cost $47,000 2020-2025: Annual software maintenance and potential maintenance in 2-5 years of $3,000 2027-2029: More extensive upgrades (may include replacing some components, but no full replacement) $5,000-$6,000. Project #01-ERP-1112 Priority 1 Urgent Justification The current surveillance system is no longer functional. The cameras are of poor quality and when needed, make it impossible to identify anyone. There are areas of the builiding that are not covered by camera or severly affected by street traffic. We have no security at the back of the building. Because of the nature of events and art work in the building, it is important to have a system that can capture activities in the building to ensure safety of guests and staff. It is also very important given the limited staff we have on duty. Staff may need to be away from the lobby in order to clean or set up for an event. We have not had a lot of problems, but have had minor vandalism to the building, theft of guests belonings and few circumstances of art theft. Budget Impact/Other Useful Life 5 yearsProject Name Art Center Surveillance System Category Buildings: Arts Center Type Equipment Future Total Project Cost:$56,000 Total20182019202020212022Expenditures 47,00047,000Equipment 47,000 47,000Total Total20182019202020212022Funding Sources 47,00047,000AC - Arts Center Fund 47,000 47,000Total Thursday, November 30, 2017 30 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2018 2022thru Department Comm Svcs - IT Description The network server is the hub of the network. New computers are faster and more reliable. Project #01-ERP-0003 Priority n/a Justification Networking allows user to share information that is stored in a single location, the network server. This is more efficient because the information does not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every user is working with the same data. Budget Impact/Other Variance from 20 year plan - Increase from 8,000 to 15,000. Software licensing has become more expensive. We are paying half of our server budget to required software and 8,000 isn't enough anymore. 2016 - Variance from 20 year plan - We were using a 4 year old server design for our servers that is not meeting current standards for speed of data access. Our new hardware design costs aprroximately 7,000 more than the old standard that was insufficent. 2017 - Changes reflect anticipated need for increased storage. Useful Life 1 yearProject Name CH - Network Server Category Equipment Type Equipment Future Total Project Cost:$626,000 Total20182019202020212022Expenditures 113,00022,000 22,000 22,000 22,000 25,000Equipment 22,000 22,000 22,000 22,000 25,000 113,000Total Total20182019202020212022Funding Sources 113,00022,000 22,000 22,000 22,000 25,000Equipment Replacement Fund 22,000 22,000 22,000 22,000 25,000 113,000Total Thursday, November 30, 2017 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2018 2022thru Department Comm Svcs - IT Description Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Project #01-ERP-0006 Priority n/a Justification Tools enabling staff to perform job responsibilities efficiently and effectively. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- 2017 - 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,050,000 Total20182019202020212022Expenditures 150,00030,000 30,000 30,000 30,000 30,000Equipment 30,000 30,000 30,000 30,000 30,000 150,000Total Total20182019202020212022Funding Sources 150,00030,000 30,000 30,000 30,000 30,000Equipment Replacement Fund 30,000 30,000 30,000 30,000 30,000 150,000Total Thursday, November 30, 2017 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2018 2022thru 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 Total20182019202020212022Expenditures 23,40023,400Equipment 23,400 23,400Total Total20182019202020212022Funding Sources 23,40023,400Equipment Replacement Fund 23,400 23,400Total Thursday, November 30, 2017 33 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2018 2022thru Department Comm Svcs - IT Description Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates fiber optic network connection to fire department. 2 - Cisco 3560E-24PD managed switch - $3,000 each 2 - Cisco X2-10GB-LR fiber optic transceiver - $1200 each cost listed is for equipment only and does not include tax, shipping and other related costs Project #01-ERP-0012 Priority n/a Justification Current two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in significant network outage that was immediately noticed by many employees. Budget Impact/Other Variance from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside the budget for city hall server network budget as the "Lisa" service is scheduled for replacement due to end of life, out of PCI compliance and obsolete. 2015 - change amount from $12,000 to $17,000 - more expensive than originally thought based on 2015 replacement. Estimate salvage/resale value on replace item: - $-0- Useful Life 6 yearsProject Name Core Network Switch Category Equipment Type Equipment Future Total Project Cost:$71,000 Total20182019202020212022Expenditures 17,00017,000Equipment 17,000 17,000Total Total20182019202020212022Funding Sources 17,00017,000Equipment Replacement Fund 17,000 17,000Total Thursday, November 30, 2017 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2018 2022thru Department Comm Svcs - IT Description With technology trending towards an explosion of mobile devices we need to be able to manage, secure and provide connectivity to current and future devices Project #01-ERP-0013 Priority n/a Justification We have cellular dead spots in buildings that can be fixed with inexpensive cell bosing technology. The number of mobile devices owned by the city is increasing every year. Our current internal Wi-Fi infrastructure has been put to together with technology that was never designed for the enterprise. As the Wi-Fi infrastructure is increasing the system isn't staying stable enough to meet demands. Just about every city building now has a business need for Wi-Fi. Our current mobile device management infrastructure needs updating to handle the influx of city data on employee owned devices, CJIS protected data, need for content filtering, as well as maintain the security of current devices. Budget Impact/Other 2016 - New ERP item Useful Life 5-7 yearsProject Name Wi-Fi and Cellular Category Equipment Type Equipment Future Total Project Cost:$18,000 Total20182019202020212022Expenditures 12,0006,000 6,000Equipment 6,000 6,000 12,000Total Total20182019202020212022Funding Sources 12,0006,000 6,000Equipment Replacement Fund 6,000 6,000 12,000Total Thursday, November 30, 2017 35 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2018 2022thru 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 Total20182019202020212022Expenditures 50,00050,000Equipment 50,000 50,000Total Total20182019202020212022Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Thursday, November 30, 2017 36 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2018 2022thru 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 Total20182019202020212022Expenditures 66,00066,000Equipment 66,000 66,000Total Total20182019202020212022Funding Sources 66,00066,000Equipment Replacement Fund 66,000 66,000Total Thursday, November 30, 2017 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2018 2022thru Department Comm Svcs - IT Description Hardware appliance to act as another layer of security to filter out malicious links, messages and attachments. This device will also provide a future capability for email archiving if it is required or desired by the city. Project #01-ERP-0016 Priority n/a Justification The number one vector malicious actors use to penetrate enterprise networks is email. Once a user clicks on a link, runs a program, or opens an attachment, the threat actor has already penetrated the border defenses. Cutting down on the amount of malicious emails that make their way to the end user is a key method of keeping the network safe from threats such as ransomware and other dangerous cyber attacks. Budget Impact/Other Useful Life 5 yearsProject Name Fortimail Hardware Appliance Category Equipment Type Equipment Future Total Project Cost:$10,000 Total20182019202020212022Expenditures 10,00010,000Equipment 10,000 10,000Total Total20182019202020212022Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Thursday, November 30, 2017 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2018 2022thru Department Comm Svcs - IT Description Computer servers store information and system programs for Police Department. One server @ $22,000 for system upgrades Project #01-ERP-0211 Priority n/a Justification Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used for data storage. Budget Impact/Other Variance from 20 year plan - Increase from 8,500 to 15,000. Software licensing has become more expensive. We are paying half our server budget for required software and 8,500 isn't enough anymore. 2016 Variance from 20 year plan - We were using a 4 year old server design for our servers that is not meeting current standards for speed of data access. Our new hardware design costs aprroximately 7,000 more than the old standard that was insufficent. Useful Life 3 yearsProject Name PD - Network Server Category Equipment Type Equipment Future Total Project Cost:$631,000 Total20182019202020212022Expenditures 113,00022,000 22,000 22,000 22,000 25,000Equipment 22,000 22,000 22,000 22,000 25,000 113,000Total Total20182019202020212022Funding Sources 113,00022,000 22,000 22,000 22,000 25,000Equipment Replacement Fund 22,000 22,000 22,000 22,000 25,000 113,000Total Thursday, November 30, 2017 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact City Clerk 2018 2022thru 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 Total20182019202020212022Expenditures 11,30011,300Equipment 11,300 11,300Total Total20182019202020212022Funding Sources 11,30011,300Equipment Replacement Fund 11,300 11,300Total Thursday, November 30, 2017 40 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2018 2022thru Department Fire Description Quick attack pumper/rescue. Current vehicle: 1995 Rescue (#108) 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. Estimate salvage/resale value on replaced item $ Useful Life 10 yearsProject Name Quick Attack Pumper/Rescue (Rescue 8)Category Vehicles Type Equipment Future Total Project Cost:$737,100 Total20182019202020212022Expenditures 314,500314,500Equipment 314,500 314,500Total Total20182019202020212022Funding Sources 314,500314,500Equipment Replacement Fund 314,500 314,500Total Thursday, November 30, 2017 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2018 2022thru Department Fire Description One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on 2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23. Current vehicle: 2008 Pierce Arrow XT Aerial Ladder (#109) Project #01-ERP-0106 Priority n/a Justification Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using $445,427.08 in ERP cash and a 10-year capital lease of $425,000. At the end of the lease term payments (P&I) will total $542,170. Total costs of aerial including cash payments equals $987,597. Budget Impact/Other Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage/resale value on replaced item: $ Useful Life 20 yearsProject Name Aerial Truck Category Vehicles Type Equipment Future Total Project Cost:$2,559,597 Total20182019202020212022Expenditures 54,21754,217Equipment 54,217 54,217Total Total20182019202020212022Funding Sources 54,21754,217Bonds/Lease 54,217 54,217Total Thursday, November 30, 2017 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2018 2022thru Department Fire Description Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. Project #01-ERP-0109 Priority n/a Justification All vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool will be added to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. Budget Impact/Other Variance from 20 year plan - move back from 2015 to 2019. Estimate salvage/resale value on replaced item: $1,000 Purchased: 2007 Useful Life 10 yearsProject Name Extrication Tool (2)Category Equipment Type Equipment Future Total Project Cost:$177,200 Total20182019202020212022Expenditures 57,40027,400 30,000Equipment 27,400 30,000 57,400Total Total20182019202020212022Funding Sources 57,40027,400 30,000Equipment Replacement Fund 27,400 30,000 57,400Total Thursday, November 30, 2017 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2018 2022thru 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 Total20182019202020212022Expenditures 16,50016,500Equipment 16,500 16,500Total Total20182019202020212022Funding Sources 16,50016,500HRA - Housing and Redevelopment Authority 16,500 16,500Total Thursday, November 30, 2017 44 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2018 2022thru Department Police Description Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. Fleet consists of 7 patrol vehicles - all marked Current Vehicles: (1) 2013 Ford Utility, (1) 2014 Ford Utility, (3) 2015 Ford Utility, (2) 2016 Ford Utility Project #01-ERP-0200 Priority n/a Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget Impact/Other Variance from 20 year plan - cost modified due to new models of squads which need to be re-outfitted for all equipment. Estimate salvage/resale value on replaced item: $4,000 each Useful Life 3 yearsProject Name Marked Patrol Vehicles (7)Category Vehicles Type Equipment Future Total Project Cost:$3,382,600 Total20182019202020212022Expenditures 620,900147,000 98,000 107,400 161,100 107,400Vehicles 147,000 98,000 107,400 161,100 107,400 620,900Total Total20182019202020212022Funding Sources 620,900147,000 98,000 107,400 161,100 107,400Equipment Replacement Fund 147,000 98,000 107,400 161,100 107,400 620,900Total Thursday, November 30, 2017 45 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2018 2022thru Department Police Description Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. 4 year rotation. Current vehicle: 2014 Ford Utility Project #01-ERP-0201 Priority n/a Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget Impact/Other Variance from 20 year plan - cost modified due to new model of car which will require all new equipment. Estimate salvage/resale value on replaced item: $3,500 each Useful Life 4 yearsProject Name Sergeant's Vehicle Category Vehicles Type Equipment Future Total Project Cost:$400,600 Total20182019202020212022Expenditures 49,00049,000Vehicles 49,000 49,000Total Total20182019202020212022Funding Sources 49,00049,000Equipment Replacement Fund 49,000 49,000Total Thursday, November 30, 2017 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2018 2022thru 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 Total20182019202020212022Expenditures 53,70053,700Vehicles 53,700 53,700Total Total20182019202020212022Funding Sources 53,70053,700Equipment Replacement Fund 53,700 53,700Total Thursday, November 30, 2017 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2018 2022thru 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 Total20182019202020212022Expenditures 127,10055,000 72,100Vehicles 55,000 72,100 127,100Total Total20182019202020212022Funding Sources 127,10055,000 72,100Equipment Replacement Fund 55,000 72,100 127,100Total Thursday, November 30, 2017 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2018 2022thru 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. Current equipment: 11 digital cameras from DATA 911. Video is downloaded into the police department server for evidentiary purposes. Project #01-ERP-0212 Priority n/a Justification Computers: Limited life of 5 years - replacement necessary. 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 Variance from 20 year plan - ERP - Move back one year to 2014. All working - no problems. Estimate salvage/resale value on replaced item: $-0- In 2014 the Police Dept. has the opportunity to purchase a combined mobile data computer/digital camera component for a total cost of $148,000. Originally the total of the cameras and computers together totaled $116,100 with the computers scheduled for 2014 and the cameras scheduled for 2015. The cameras are being pulled forward to 2014. 2016 - Variance from 20 year plan - Change in replacement year to accurately reflect life expectancy in relation to when the cameras were purchased. Change in budgeted amount to reflect past and anticipated costs. Useful Life 5 yearsProject Name Squad Car Camera Systems Category Equipment Type Equipment Future Total Project Cost:$557,500 Total20182019202020212022Expenditures 65,00065,000Equipment 65,000 65,000Total Total20182019202020212022Funding Sources 65,00065,000Equipment Replacement Fund 65,000 65,000Total Thursday, November 30, 2017 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2018 2022thru 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 @ $3,700 = $44,400. 12 ballistic helmets @ $515 = $6,180. New protective shield = $3,000. 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:$233,200 Total20182019202020212022Expenditures 55,00055,000Equipment 55,000 55,000Total Total20182019202020212022Funding Sources 55,00055,000Equipment Replacement Fund 55,000 55,000Total Thursday, November 30, 2017 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Captain 2018 2022thru 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 12- X2 Tasers Total overall cost each Taser in 2018 = $2870.00 (+ shipping/tax) Useful Life 4 yearsProject Name Taser Replacement Category Equipment Type Equipment Future Total Project Cost:$158,600 Total20182019202020212022Expenditures 67,00035,000 32,000Equipment 35,000 32,000 67,000Total Total20182019202020212022Funding Sources 67,00035,000 32,000Equipment Replacement Fund 35,000 32,000 67,000Total Thursday, November 30, 2017 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2018 2022thru 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 Total20182019202020212022Expenditures 20,00020,000Equipment 20,000 20,000Total Total20182019202020212022Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Thursday, November 30, 2017 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2018 2022thru Department Police Description The police department video server is used to store evidentiary video and audio data. Rules pertaining to criminal procedure, and laws regarding data privacy and retention place requirements on the Police Department to store and manage the data for varying lengths of time. The current data storage solution was designed for squad car video only and is near capacity. The storage solution is also not currently designed to efficiently back up data and is potentially subject to data loss from environmental factors such as drive failure and unsuited fire suppression systems. Project #01-ERP-0219 Priority n/a Justification The server is needed to maintain evidentiary squad car video and audio based upon State of Minnesota statutes and rules for varying lengths of time. The current storage solution is near capacity and is not being backed up in a manner suitably protecting it from loss. The current storage solution will not facilitate data storage of body worn camera video data and data retention. A properly designed and implemented video data storage server will protect data from potential loss and corruption. Maintenance of the video data storage server will have yearly associated costs that need to be accounted for. Budget Impact/Other Cost of video data storgae server: $115,000.00 Cost of yearly maintenance for video data storgae server: $10,000.00/year Useful Life 5 yearsProject Name PD - Video Data Server Category Equipment Type Equipment Future Total Project Cost:$165,000 Total20182019202020212022Expenditures 155,000115,000 10,000 10,000 10,000 10,000Equipment 115,000 10,000 10,000 10,000 10,000 155,000Total Total20182019202020212022Funding Sources 155,000115,000 10,000 10,000 10,000 10,000Equipment Replacement Fund 115,000 10,000 10,000 10,000 10,000 155,000Total Thursday, November 30, 2017 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2018 2022thru Department Police Description Mobile Data Computers are used in the squad cars to receive calls for service from dispatch, query information from criminal justice databases, and facilitate communication between squad cars. Current equipment: 11 - Data 911 Computers purchased in 2014 Project #01-ERP-0220 Priority n/a Justification Mobile Data Computers have a limited life expectancy. The computers facilitate the basic response to emergency calls for service to which police officers respond. Vital information is forwarded to officers via the mobile data computers. Officers complete investigative reports, issue traffic related warnings and citations, and process arrest incidents from the mobile data computers. As technology evolves the officers must be able to access information using up to date computers that can process the large amount of data and applications. Mobile data computers are currently used to host the squad car video camera system and have the potential to be integrated with a possible body worn camera. Budget Impact/Other 2016 - Variance from 20 year plan - Change in replacement year to accurately reflect life expectancy in relation to when the computers were purchased. Change in budgeted amount to reflect past and anticipated costs. Useful Life 5 yearsProject Name Mobile Data Computers Category Equipment Type Equipment Future Total Project Cost:$290,000 Total20182019202020212022Expenditures 65,00065,000Equipment 65,000 65,000Total Total20182019202020212022Funding Sources 65,00065,000Equipment Replacement Fund 65,000 65,000Total Thursday, November 30, 2017 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2018 2022thru Department Police Description LETG - Records Management System was purchased at the end of 2012. This maintains all police records and reports. Zurcher Technologies acquired LETG in 2016 unexpectedly. We anticipate LETG will not be supported by 2020. Project #01-ERP-0221 Priority n/a Justification A new RMS system may be needed by 2020 as the current system will likely not be supported by the new company. Budget Impact/Other Current cost to maintain system is $26,989 anually. Useful LifeProject Name Records Management System Category Equipment Type Equipment Future Total Project Cost:$150,000 Total20182019202020212022Expenditures 150,000150,000Equipment 150,000 150,000Total Total20182019202020212022Funding Sources 150,000150,000Equipment Replacement Fund 150,000 150,000Total Thursday, November 30, 2017 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2018 2022thru Department Police Description Body worn cameras (BWC) are cameras worn on the person of a police officer to capture the actions of individuals and the situations encountered by police officers. The BWCs offer video data and evidence that cannot be captured by traditional squad car video systems. The State of Minnesota recently passed legislation regarding the use of BWCs and the video data associated with their use. The use of BWCs by police officers is an emergeing documentation tool in law enforcement, and considered directly associated with transparency and positive community relations. Project #01-ERP-0222 Priority n/a Justification There are a number of costs associated with the implementation of a BWC program. The State of Minnesota set forth specific data privacy and retention guidelines in the legislation that must be followed. The legislation mandates the performance of duties that are not currently performed by members of the Police Department staff and may require the hiring of additional staff to perform the mandated duties. Initial inquiries into BWC platforms indicate the best practice will be the acquistion of one BWC per officer in contact with the public as a core function of their job duties, which for the Police Department would result in the purchase of 30 BWCs. BWC manufacturers require license fees per device and ongoing warranty and maintenace fees. Computer software to manage the video data has additional associated costs, not including staff salary / compensation to perform needed duties. Budget Impact/Other Useful Life 5 yearsProject Name Body Worn Cameras Category Equipment Type Equipment Future Total Project Cost:$160,000 Total20182019202020212022Expenditures 160,000160,000Equipment 160,000 160,000Total Total20182019202020212022Funding Sources 160,000160,000Equipment Replacement Fund 160,000 160,000Total Thursday, November 30, 2017 56 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru Department Public Works: Bldg/Equip Ser Description Pickup used by various divisions of Public Works. Project #01-ERP-0710 Priority n/a Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. Budget Impact/Other Variance from 20 year plan - move up from 2009 to 2008 - Fire Dept. has requested to acquire surplus pickup for its use by daytime responders. Estimated useful life reduced from 10 to 8 years. Estimate salvage/resale value on replaced item: $1,500 Useful Life 8 yearsProject Name 4X4 3/4 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$101,400 Total20182019202020212022Expenditures 36,00036,000Vehicles 36,000 36,000Total Total20182019202020212022Funding Sources 36,00036,000Equipment Replacement Fund 36,000 36,000Total Thursday, November 30, 2017 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact 2018 2022thru Department Public Works: Bldg/Equip Ser Description Used for unloading deliveries and moving palletized materials to messanine. Project #01-ERP-0715 Priority 2 Very Important Justification Currentl we use a skidloader with forms. For safety reasons the forklift is the preferred method for handling pallets on/off a delivery truck and for material in and around our facilities. The facilities that would benefit are PW, Fire and the Ice Arena. Budget Impact/Other New Item Useful Life 15 yearsProject Name PW - Forklift Category Unassigned Type Unassigned Future Total Project Cost:$25,000 Total20182019202020212022Expenditures 25,00025,000Equipment 25,000 25,000Total Total20182019202020212022Funding Sources 25,00025,000Equipment Replacement Fund 25,000 25,000Total Thursday, November 30, 2017 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru 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 Total20182019202020212022Expenditures 85,20085,200Vehicles 85,200 85,200Total Total20182019202020212022Funding Sources 85,20085,200Equipment Replacement Fund 85,200 85,200Total Thursday, November 30, 2017 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru 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 Total20182019202020212022Expenditures 163,600163,600Vehicles 163,600 163,600Total Total20182019202020212022Funding Sources 81,80081,800Equipment Replacement Fund 81,80081,800RF - Refuse Fund 163,600 163,600Total Thursday, November 30, 2017 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru 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 Total20182019202020212022Expenditures 92,70092,700Equipment 92,700 92,700Total Total20182019202020212022Funding Sources 92,70092,700Equipment Replacement Fund 92,700 92,700Total Thursday, November 30, 2017 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru Department Public Works: Parks/Forestry Description Use by Public Works for snow removal, skating rinks, sweeping, ballfield maintenance and transportation of people and materials. Current vehicle: 2010 Bobcat (#815) Project #01-ERP-0816 Priority n/a Justification New machine. Budget Impact/Other Variance from 20 year plan - New item which replaces one tractor. Estimate salvage/resale value on replaced item: $ Useful Life 8 yearsProject Name Toolcat Category Equipment Type Equipment Future Total Project Cost:$295,100 Total20182019202020212022Expenditures 63,30063,300Equipment 63,300 63,300Total Total20182019202020212022Funding Sources 63,30063,300Equipment Replacement Fund 63,300 63,300Total Thursday, November 30, 2017 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru Department Public Works: Streets/Traffic Description Truck used in the Street Division of Public Works. Current vehicle: 2006 Ford F350 Pickup (#307) Project #01-ERP-0302 Priority n/a Justification Light hauling, snow removal and transportation. Budget Impact/Other Estimated useful life reduced from 12 to 10 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 10 yearsProject Name 4x2 1 Ton Dump Truck Category Equipment Type Equipment Future Total Project Cost:$162,900 Total20182019202020212022Expenditures 54,60054,600Equipment 54,600 54,600Total Total20182019202020212022Funding Sources 54,60054,600Equipment Replacement Fund 54,600 54,600Total Thursday, November 30, 2017 63 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru 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 Total20182019202020212022Expenditures 53,40053,400Vehicles 53,400 53,400Total Total20182019202020212022Funding Sources 53,40053,400Equipment Replacement Fund 53,400 53,400Total Thursday, November 30, 2017 64 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru 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 Total20182019202020212022Expenditures 225,000225,000Vehicles 225,000 225,000Total Total20182019202020212022Funding Sources 225,000225,000Equipment Replacement Fund 225,000 225,000Total Thursday, November 30, 2017 65 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru Department Public Works: Streets/Traffic Description Dump truck used in Streets Division of Public Works. Current vehicles: 1998 Ford LT8500 Tandem (#314) Project #01-ERP-0306 Priority n/a Justification Trucks used for heavy hauling, snow plowing and sanding. To increase snow and other material hauling capacity. Moved from a single axel dump truck in 2018 to a tandem axel truck in 2018. Budget Impact/Other Variance from 20 year plan - Moved 1 single axel dump truck due in 2018 to a tandem axel dump truck due in 2018. Estimate salvage/resale value on replaced item: $-0- 2016-Increased estimated replacement costs by $50,000 each year Estimated useful life reduced from 17 to 15 years. Useful Life 15 yearsProject Name Tandem Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$1,062,000 Total20182019202020212022Expenditures 235,000235,000Vehicles 235,000 235,000Total Total20182019202020212022Funding Sources 235,000235,000Equipment Replacement Fund 235,000 235,000Total Thursday, November 30, 2017 66 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru 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 12 yearsProject Name Skid Loader (2)Category Equipment Type Equipment Future Total Project Cost:$258,900 Total20182019202020212022Expenditures 50,00050,000Equipment 50,000 50,000Total Total20182019202020212022Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Thursday, November 30, 2017 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru Department Public Works: Streets/Traffic Description Street sweeper used by Streets Division for sweeping streets and parking lots. Current equipment: 2001 Elgin Pelican SE (#327) Project #01-ERP-0311 Priority n/a Justification Street sweeping, event clean-up, spring sand removal. Budget Impact/Other Variance from 20 year plan - Move from 2021 to 2019 Estimate salvage/resale value on replaced item: $12,000 Useful Life 15 yearsProject Name Sweeper Category Equipment Type Equipment Future Total Project Cost:$345,300 Total20182019202020212022Expenditures 230,000230,000Equipment 230,000 230,000Total Total20182019202020212022Funding Sources 230,000230,000Equipment Replacement Fund 230,000 230,000Total Thursday, November 30, 2017 68 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru Department Refuse Description Dumpster swap loader refuse truck used to haul bulk pick-up items, refuse from parks and downtown, scrap metal and hauling waster and snow. Utilized by Refuse for hauling dumpsters and Forestry for chipping trees. Cost shared Refuse and Eqiupment Replacement Fund as follows: 75% Refuse 25% ER Fund (Parks/Forrestry) Current equipment: 1993 International LP4700 (#810) Project #01-ERP-0803 Priority n/a Justification Needed for waste and snow hauling. Budget Impact/Other Estimated useful life reduced from 20 to 15 years. Useful Life 15 yearsProject Name Swap Loader Category Equipment Type Equipment Future Total Project Cost:$346,000 Total20182019202020212022Expenditures 95,00095,000Equipment 95,000 95,000Total Total20182019202020212022Funding Sources 23,75023,750Equipment Replacement Fund 71,25071,250RF - Refuse Fund 95,000 95,000Total Thursday, November 30, 2017 69 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru 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 Total20182019202020212022Expenditures 270,300270,300Vehicles 270,300 270,300Total Total20182019202020212022Funding Sources 270,300270,300RF - Refuse Fund 270,300 270,300Total Thursday, November 30, 2017 70 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2018 2022thru 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 Total20182019202020212022Expenditures 43,00043,000Equipment 43,000 43,000Total Total20182019202020212022Funding Sources 43,00043,000SF - Sanitary Sewer Fund 43,000 43,000Total Thursday, November 30, 2017 71 72 TWENTY-YEAR REPLACEMENT SCHEDULE 73 74 12/4/2017 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average:1,031,700$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 ACTIVITY CENTER ERP-0032 Sound System 15 13,700 ERP-0035 Floor Scrubber 10 6,700 9,000 ERP-0036 Sound System Replacement 25 15,000 SUBTOTAL 15,000 6,700 13,700 9,000 ARTS CENTER ERP-1101 Carpet Extractor 10 5,200 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 47,000 3,000 6,000 47,000 18,700 3,000 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-0011 Election Equipment 10 EQUIPMENT SUBTOTAL 11,300 12,700 14,300 6,500 16,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 54,217 1,572,000 VEHICLES SUBTOTAL 54,217 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 27,400 30,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 361,000 431,498 514,700 EQUIPMENT SUBTOTAL 27,400 30,000 376,400 250,000 38,500 37,700 468,398 54,400 40,300 20,700 850,700 IT ERP-0003 City Hall - Network Upgrade 1 22,000 22,000 22,000 22,000 25,000 25,000 25,000 25,000 25,000 28,000 28,000 28,000 28,000 28,000 31,000 31,000 31,000 31,000 31,000 33,000 ERP-0004 Phone System 8 89,600 110,700 ERP-0005 Financial Software 7 250,000 ERP-0006 Computers 3-5 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 32,000 ERP-0009 Network Infrastructure Upgrade 15 23,400 ERP-0012 Core Network Switch 6 17,000 20,000 24,000 27,000 ERP-0013 Wi-Fi and Cellular 5-7 6,000 6,000 ERP-0014 Distribution Network Switches 5 50,000 57,000 65,000 75,000 ERP-0015 Backup Server 3 66,000 70,000 74,000 78,000 82,000 87,000 ERP-0016 Fortimail Hardware Appliance 5 10,000 ERP-0211 Police - Network Server (3)3 22,000 22,000 22,000 22,000 25,000 25,000 25,000 25,000 25,000 28,000 28,000 28,000 28,000 28,000 31,000 31,000 31,000 31,000 31,000 33,000 EQUIPMENT SUBTOTAL 97,000 84,000 196,000 74,000 103,400 489,600 100,000 137,000 154,000 86,000 86,000 164,000 175,000 196,700 92,000 174,000 92,000 167,000 206,000 98,000 POLICE ERP-0200 Squad 3 147,000 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 ERP-0201 Sergeant Vehicle #209 4 49,000 57,000 64,000 72,000 80,000 ERP-0202 Parking Vehicle #211 10 53,700 60,000 65,000 ERP-0203 PSO Utility 4x4 #212 6 55,000 72,100 86,100 90,000 92,000 ERP-0205 SWAT Vehicle #240 15 77,900 VEHICLES SUBTOTAL 251,000 98,000 107,400 214,800 179,500 174,400 117,400 117,400 274,100 192,000 128,000 140,000 230,000 289,900 153,200 153,200 245,000 237,000 225,000 165,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 55,000 40,000 45,000 50,000 ERP-0215 Radios-Portable & Mobile 290,000 ERP-0217 Taser Replacement 4 35,000 32,000 35,000 38,000 42,000 ERP-0218 Building Video Server 4 20,000 17,000 17,000 17,000 19,000 ERP-0219 PD - Squad Video Server 5 115,000 10,000 10,000 10,000 10,000 10,000 ERP-0220 Data 911 Computers 5 65,000 70,000 75,000 80,000 ERP-0221 Records Management System 150,000 ERP-0222 Body Worn Camera 5 160,000 165,000 175,000 185,000 EQUIPMENT SUBTOTAL 205,000 140,000 180,000 10,000 202,000 357,000 218,500 35,000 182,000 45,000 223,500 38,000 17,000 175,000 250,000 272,000 19,000 185,000 75 REPL EQUIPMENT /VEHICLES YRS 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 P.W. BLDG./EQUIPMENT SVCS ERP-0710 1/2 Ton Truck 10 36,000 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 25,000 28,000 61,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 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 ERP-0816 Toolcat 8 63,300 80,200 101,600 ERP-0817 Grass Seed Applicator 20 17,900 VEHICLES SUBTOTAL 63,300 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 45,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 54,600 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 235,000 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 289,600 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 95,000 171,000 ERP-0804 Log Truck (50% w/Forestry)20 81,800 SUBTOTAL 95,000 270,300 81,800 275,200 363,200 136,500 171,000 76 REPL EQUIPMENT /VEHICLES YRS 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 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 41,700 SUBTOTAL 46,900 36,000 41,700 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 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 GENERAL FUND-VEHICLES/EQUIP 694,117 328,000 285,300 439,800 679,200 521,200 262,800 284,700 1,136,900 1,477,140 2,202,300 548,600 625,900 591,400 744,600 283,300 1,002,200 531,000 399,500 292,000 GENERAL FUND-OTHER EQUIP 327,000 266,400 387,300 84,000 335,400 1,223,000 331,200 387,000 234,200 305,700 145,300 864,198 233,200 268,100 323,300 472,700 364,000 1,036,700 418,100 98,000 HRA - - - - 16,500 41,100 20,900 52,100 ARTS CENTER 47,000 - - - 18,700 3,000 6,700 10,800 7,100 6,000 16,600 7,000 9,000 REFUSE 95,000 - - 270,300 81,800 275,200 363,200 136,500 171,000 PAVILION - - - - - 11,600 185,900 16,200 15,600 WATER - - - - - 46,900 36,000 41,700 153,700 54,000 SEWER - - - - 43,000 40,300 45,200 54,200 54,000 GENERAL FUND TOTAL 1,021,117 594,400 672,600 523,800 1,014,600 1,744,200 594,000 671,700 1,371,100 1,782,840 2,347,600 1,412,798 859,100 859,500 1,067,900 756,000 1,366,200 1,567,700 817,600 390,000 HRA TOTAL - - - - 16,500 41,100 20,900 52,100 ARTS CENTER FUND TOTAL 47,000 - - - 18,700 3,000 6,700 10,800 7,100 6,000 16,600 7,000 9,000 ENTERPRISE FUNDS TOTAL 95,000 - - 270,300 124,800 51,900 275,200 278,000 36,000 41,700 16,200 363,200 290,200 171,000 69,800 108,000 TOTAL ALL FUNDS 1,163,117 594,400 672,600 794,100 1,174,600 1,788,300 652,600 957,700 1,656,200 1,824,840 2,389,300 1,445,598 880,000 1,274,800 1,365,100 927,000 1,445,000 1,567,700 925,600 390,000 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,001 NET GENERAL FUND 981,117 554,400 632,600 483,800 974,600 1,704,200 554,000 631,700 1,331,100 1,742,840 2,307,600 1,372,798 819,100 819,500 1,027,900 716,000 1,326,200 1,527,700 777,600 349,999 20 YEAR AVERAGES:Total Average ACTIVITY CENTER ADMINISTRATION 44,400 2,200 IT 2,971,700 148,600 COMMUNITY SERVICES 78,900 3,900 FIRE EQUIPMENT 4,085,717 204,300 FIRE ADMINISTRATION 2,194,498 109,700 POLICE EQUIPMENT 3,692,300 184,600 POLICE ADMINISTRATION 2,754,000 137,700 PUBLIC WORKS ADMINISTRATION BLDG./EQUIPMENT SERVICES EQUIPMENT 236,200 11,800 ENGINEERING EQUIPMENT PARKS/FORESTRY EQUIPMENT 1,599,040 80,000 STREET EQUIPMENT 3,778,000 188,900 GENERAL FUND VEHICLE/EQUIPMENT 13,391,257 669,600 GENERAL FUND OTHER EQUIPMENT 8,043,498 402,200 GENERAL FUND TOTAL 21,434,755 1,071,700 HRA FUND 130,600 6,500 ARTS CENTER FUND 131,900 6,600 REFUSE FUND 1,393,000 69,700 PAVILION FUND 229,300 11,500 WATER FUND 332,300 16,600 SEWER FUND 236,700 11,800 UTILITY VEHICLES/EQUIPMENT 2,453,800 122,700 23,888,555 77 78 EQUIPMENT INVENTORY 79 80 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2017 UNIT # YEAR MAKE MODEL VALUE FIRE DEPARTMENT POLICE DEPARTMENT 200 2015 FORD EXPLORER - INTERCEPTOR $30,000 201 2014 FORD EXPLORER - INTERCEPTOR (SGT) 31,000 202 2015 FORD EXPLORER - INTERCEPTOR 31,000 205 2016 FORD EXPLORER - INTERCEPTOR 34,000 206 2016 FORD EXPLORER - INTERCEPTOR 34,000 207 2017 FORD EXPLORER - INTERCEPTOR 50,000 208 2017 FORD EXPLORER - INTERCEPTOR 50,000 209 2015 FORD EXPLORER - INTERCEPTOR 31,000 211 2016 FORD EXPLORER 23,080 212 2014 FORD F150 (PSO) 34,000 213 2016 FORD TAURUS 25,000 214 2014 NISSAN MAXIMA ( LEASED VEHICLE) 38,800 216 2011 FORD TAURUS 30,000 218 2013 FORD INTERCEPTOR SUV 40,000 219 2013 FORD TAURUS 27,500 220 2017 FORD EXPLORER 33,200 221 2015 JEEP CHEROKEE - LEASED 35,000 240 2017 FORD TRANSIT 350 (SWAT) 67,000 299 2014 NISSAN TITAN (DTF LEASED VEHICLE) 40,300 DWI 2015 FORD UTILITY - INTERCEPTOR 40,300 103 2006 PETERBILT PUMPER $420,000 104 2012 FORD QUICK ATTACK PUMPER F550 248,500 105 2016 FORD F150 25,000 106 2015 FORD EXPLORER (RED) - LEASED 47,500 107 2015 FORD EXPLORER (BLACK) - LEASED 47,500 108 2014 FORD F150 - LEASED 34,000 109 2008 PIERCE AERO XT 874,000 110 2017 FORD EXPLORER 47,500 115 1952 MACK PUMPER 4,000 121 2005 FREIGHTLINER M2-HAZMAT 309,900 81 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2017 UNIT # YEAR MAKE MODEL VALUE STREET/TRAFFIC DIVISION 301 2013 FORD F150 $19,500 303 2016 FORD F250 26,500 304 2000 FORD F450 34,000 307 2006 FORD F350-1 TON DUMP 27,400 308 2011 FORD F350 - 2X4 20,300 309 2012 FORD F450 30,300 311 2011 FREIGHTLINER M2106V 79,400 312 2005 FREIGHTLINER SGLAX DUMP 98,000 314 1998 FORD LT 8500 84,000 315 2017 FREIGHTLINER 114SD 221,700 317 2016 FREIGHTLINER M2-106 69,400 320 1991 CATERPILLER LOADER 926E 90,000 321 2012 CATERPILLER LOADER 924K 177,500 322 2005 CATERPILLER LOADER 938G 157,800 325 2011 BOBCAT SKID STEER LOADER 35,100 326 1989 CATERPILLAR 140-G 82,000 327 2001 ELGIN PELICAN SE 105,000 328 2013 ISUZU STREET SWEEPER 145,300 329 2017 BOMAG BW120 SL5 ROLLER 45,900 337 1994 CATERPILLAR BOX PAVER 17,000 343 2014 SNOWCRETE SNOWBLOWER - CUMMINS QSB6.7 71,500 344 1996 SNOGO WK 800 58,000 348 2014 PJ TRAILER 20' TILT TRAILER 5,300 350 1993 TOWMASTER T14 4,000 351 2004 TENNANT SWEEPER 3640 10,000 352 2017 FALCON PATCH TRAILER 15,000 ENGINEERING DIVISION 701 2010 CHEVROLET IMPALA $23,600 706 2015 FORD TRANSIT 250 VAN 24,000 707 2009 CHEVROLET IMPALA 14,600 708 2016 FORD TRANSIT 350 29,700 BUILDING MAINTENANCE & EQUIPMENT SERVICES 702 2004 FORD F350 $18,000 703 2004 CHEVROLET 2500HD 19,000 704 2005 FORD F250 18,000 82 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2017 UNIT # YEAR MAKE MODEL VALUE PARKS/FORESTRY DIVISION 800 2013 FORD F150 $23,700 801 2012 FORD F350 4X4 24,100 803 2004 FORD F350 17,500 804 1995 CHEVROLET 1 TON BOOM 45,000 810 1993 INTERNATIONAL LP 4700 50,000 811 2006 INTERNATIONAL LP 4600 LOG TRUCK 45,000 812 2010 FREIGHTLINER AERIAL LIFT 130,000 815 2010 BOBCAT TOOLCAT 53,000 816 2014 BOBCAT 5610 TOOLCAT 50,900 818 2017 TORO WORKMAN HDX 13,000 820 2004 TORO WORKMAN 3200 15,000 822 2014 TORO MDE MOWER 18,000 823 2006 JACOBSON MOWER 10,000 825 2010 TORO 4100D MOWER 56,500 826 2004 TORO Z587L 8,900 828 2001 DEW EZE ATM72 21,000 829 2016 TORO 3280-D MOWER 10,000 831 2016 RAYCO RG45X TRAILER 3,400 832 1997 VERMEER STUMP CTR 630A 15,400 834 2013 VERMEER BRUSH CHIPPER 29,800 843 2007 CARR TRAILER 2,500 844 2010 FELLING TRAILER 6,000 845 1997 REMACKEL TRAILER 3,500 846 2001 DRESSEN 8110 2,000 847 2011 SPARKS TILT TRAILER 4,900 848 2017 LOAD TRAILER 5,400 HRA 411. 2007 CHEVROLET 2500 HD $17,500 83 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2017 UNIT # YEAR MAKE MODEL VALUE WATER/SEWER 500 2007 CHEVROLET PICKUP $22,000 502 1999 DODGE DAKOTA 4X4 18,000 503 2015 FORD F350 38,000 505 2007 CHEVROLET CC25753 31,900 508 2016 FORD TRANSIT CONNECT 25,000 509 2016 FORD F350 65,000 510 2016 FORD F350 30,000 531 2017 FREIGHTLINER 114SD 425,400 533 2012 CATERPILLAR 420EH2 BACKHOE 87,700 534 1997 KOHLER GENERATOR/TRL 11,000 535 1992 KOHLER GENERATOR/TRL 10,000 537 2010 GENERATOR C15 144,300 REFUSE 900 2011 FREIGHTLINER RAPID-RAIL M2 $201,109 901 2005 PETERBILT 320 155,000 902 2015 FREIGHTLINER M2106V 232,500 903 1995 FREIGHTLINER FL-70 50,000 PAVILION 802 2012 FORD F350 $20,000 808 2014 ZAMBONI ICE RESURFACER 126,000 809 2003 OLYMPIA ICE RESURFACER 87,800 84