The URL can be used to link to this page

2021-2025 Equipment Replacement Plan EQUIPMENT REPLACEMENT PLAN 2021-2025 DATE: November 17, 2020 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2021-2025 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2021-2025 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 residents 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 residents 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 15 Projects by Department 16 Funding Source Summary 18 Projects by Funding Source 19 Equipment Requests Individual Equipment Request Details Activity Center 22 Arts Center 25 Community Services - IT 28 Fire 41 HRA 50 Pavilion 52 Police 53 Public Works 64 Refuse 74 Water/Sewer 75 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 78 Equipment Inventory 82 EQUIPMENT REPLACEMENT PLAN 2021-2025 TABLE OF CONTENTS 3 4 INTRODUCTION 5 EQUIPMENT REPLACEMENT PLAN 2021-2025 BACKGROUND AND SUMMARY OF CHANGES FROM 2020 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 residents 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 2021 by 9% and will be increased by 6% in 2022 through 2025. 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 continue to rely on a tax levy in 2021. The levy being proposed for 2020 is $200,000. It is planned to be $250,000 for 2022-2025. 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 was added 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 will be considered as a funding source in 2022. 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 2020-2024 Plan Highlights of changes from last year’s equipment replacement plan for the years 2021-2024: CS - Activity Center: No changes CS - Arts Center: No changes CS - IT: Financial Software Upgrade was cancelled in 2021 for $307,468. Community Services: No changes Fire: Hose replacement project removed in 2023 for $38,000. Quick Attack Pumper/Rescue in 2022 estimated costs increased from $525,000 to $725,000. Extrication Tool in 2022 was removed for $30,000. Emergency Operations Center Updated advanced from 2024 to 2022 for $16,000. Fire Helmets advanced from 2023 to 2022 for $12,000. Thermal Imaging Cameras delayed from 2023 to 2025 for $16,180. Radios delayed from 2023 to 2025 for $386,000. HRA No changes. Police: Building Video Server costs increased by $5,000 in 2023. Taser Replacement costs increased by $10,000 in 2023. Squad Car Camera System/Body Worn Cameras cost increased by $55,000 in 2024. . Public Works: Building/Equipment Services No Changes Engineering Van was removed from 2024 for $28,900. 7 Parks/Forestry Riding Mowers advanced from 2022 to 2021 for $50,000 Log Truck delayed from 2022 to 2023 for $163,600. Trailer Flatbed Streets/Traffic Single Axle Dump Truck was delayed from 2021 to 2022 for $225,000. Front End Loader delayed from 2023 to 2024 for $268,600. 4x4 ¾ Ton Truck with Plow was removed from 2024 for $38,500. Asphalt Hot Mix Heating Box was removed from 2024 for $22,100. Refuse No changes Sewer Televising Camera and Van added to 2022 for $180,000. 4x4 ¾ Ton Truck was removed from 2024 for $40,300. Water No Changes 8 CASH FLOW STATEMENT 9 City of Hopkins Equipment Replacement Fund (602) Rate Change 9%9%9%6%6%6%6% ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2019 2020 2021 2022 2023 2024 2025 Working Capital Begin Year (114,895) 250,501 293,175 559,915 570,152 383,141 468,829 Revenues from charges 529,264 579,674 631,845 669,755 709,941 752,537 797,689 Tax Levy 227,680 110,000 200,000 250,000 250,000 250,000 196,947 Interest earnings - - 293 359 2,851 3,000 3,000 Other revenues (sale of assets)3,254 - 15,000 35,000 35,000 35,000 40,000 Equipment Certificates (Bonds)- 255,539 - - 850,000 - 425,000 Total Revenues 760,198 945,213 847,138 955,114 1,847,791 1,040,537 1,462,636 Expenditures (excludes Leases & Depr.) 6,333 6,333 34,899 35,248 36,305 37,395 38,516 Capital Outlay - Equipment 388,469 896,206 545,499 909,629 1,998,497 917,454 1,428,329 Total Expenses 394,802 902,539 580,398 944,877 2,034,802 954,849 1,466,845 Working Capital Ending Balance 250,501 293,175 559,915 570,152 383,141 468,829 464,620 (Unrestricted Net Position) 10 FIVE-YEAR PROJECT SUMMARIES 11 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY YEAR 2021 2025thru Project Name Department Project #Priority Project Cost 2021 01-ERP-0037Activity Center Security System Upgrade 1 20,000Comm Svcs - Activity Center 01-ERP-0041Activity Center A/V Replacement & Upgrade 3 62,624Comm Svcs - Activity Center 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-0022IT - Windows 10 Enterprise Upgrade n/a 21,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-0201Sergeant's Vehicle n/a 57,000Police 01-ERP-0202PSO / Parking Enforcement Vehicle n/a 53,700Police 01-ERP-0808Riding Mowers (2)1 50,000Public Works: Parks/Forestry 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 270,300Refuse 815,799Total 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-0022IT - Windows 10 Enterprise Upgrade n/a 42,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 25,000Comm Svcs - IT 01-ERP-0126Fire - Fire Helmets n/a 16,000Fire 01-ERP-0129Fire - EOC Upgrade n/a 12,000Fire 01-ERP-0401HRA Copier n/a 16,500HRA 01-ERP-0200Marked Patrol Vehicles (7)n/a 110,000Police 01-ERP-0203PSO - Utility 4x4 n/a 72,100Police 01-ERP-0221Records Management System n/a 150,000Police 01-ERP-03031 Ton Dump Truck (2)n/a 53,400Public Works: Streets/Traffic 01-ERP-0305Single Axle Dump Truck (2)n/a 225,000Public Works: Streets/Traffic 01-ERP-0309Skid Loader (2)n/a 50,000Public Works: Streets/Traffic 01-ERP-0555Generator (2)n/a 43,000Sewer 01-ERP-0560Sewer Televising Camera and Van n/a 180,000Sewer 1,162,629Total 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 Wednesday, November 11, 2020 12 Project Name Department Project #Priority Project Cost 01-ERP-0015Backup Server n/a 72,120Comm 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-0022IT - Windows 10 Enterprise Upgrade n/a 42,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 26,250Comm Svcs - IT 01-ERP-0105Quick Attack Pumper/Rescue (Rescue 8)n/a 725,000Fire 01-ERP-0109Extrication Tool (1)n/a 32,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 90,000Police 01-ERP-0218Building Video Server n/a 22,000Police 01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry 01-ERP-0804Log Truck n/a 163,600Public Works: Parks/Forestry 01-ERP-03004x4 1/2 Ton Pickup with Plow n/a 28,900Public Works: Streets/Traffic 01-ERP-03041 Ton Traffic Boom Truck n/a 136,400Public Works: Streets/Traffic 2,134,997Total for 2023 2024 01-ERP-1107Art Center Theater Projection Screen 2 6,700Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 27,037Comm Svcs - IT 01-ERP-0006Computers n/a 37,559Comm Svcs - IT 01-ERP-0012Core Network Switch n/a 20,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 45,320Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 63,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 27,038Comm Svcs - IT 01-ERP-1003Pavilion - Floor Scrubber n/a 11,600Pavilion 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0212Squad Car Camera Systems/ Body Worn Camera n/a 160,000Police 01-ERP-0220Squad Computers n/a 90,000Police 01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry 01-ERP-03031 Ton Dump Truck (2)n/a 49,500Public Works: Streets/Traffic 01-ERP-0308Front End Loaders (2)n/a 268,600Public Works: Streets/Traffic 943,754Total for 2024 2025 01-ERP-1109Art Center Floor Scrubber n/a 10,800Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 27,849Comm Svcs - IT 01-ERP-0005Financial Software - Various Depts.n/a 315,000Comm Svcs - IT 01-ERP-0006Computers n/a 38,686Comm Svcs - IT 01-ERP-0014Distribution Network Switches n/a 57,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 46,680Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,300Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 27,849Comm Svcs - IT 01-ERP-0052Electronic Inspections Processing 2 16,231Community Services 01-ERP-0108Self Contained Breathing Apparatus (SCBA) (45)n/a 250,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 16,180Fire 01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 386,000Fire 01-ERP-0131Fire - Station Alerting System n/a 55,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0201Sergeant's Vehicle n/a 64,154Police 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 275,200Refuse Wednesday, November 11, 2020 13 Project Name Department Project #Priority Project Cost 1,714,329Total for 2025 GRAND TOTAL 6,771,508 Wednesday, November 11, 2020 14 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2021 2025thru Total2021 2022 2023 2024 2025Department Comm Svcs - Activity Center 111,62482,624 17,000 12,000 Comm Svcs - Arts Center 31,00013,500 6,700 10,800 Comm Svcs - IT 1,445,207141,075 204,129 346,685 229,954 523,364 Community Services 16,23116,231 Fire 1,510,18028,000 775,000 707,180 HRA 57,60016,500 41,100 Pavilion 11,60011,600 Police 1,748,766271,800 332,100 595,912 367,400 181,554 Public Works: Parks/Forestry 259,00050,000 199,000 10,000 Public Works: Streets/Traffic 811,800328,400 165,300 318,100 Refuse 545,500270,300 275,200 Sewer 223,000223,000 815,799 1,162,629 2,134,997 943,754 1,714,329 6,771,508TOTAL Wednesday, November 11, 202015 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2021 2025thru Total2021 2022 2023 2024 2025Department Project # 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-0041 62,62462,624Activity Center A/V Replacement & Upgrade 3 111,62482,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 01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 31,00013,500 6,700 10,800Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0003 128,13622,000 25,000 26,250 27,037 27,849CH - Network Server n/a 01-ERP-0004 89,60089,600Telephone System n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 180,51433,075 34,729 36,465 37,559 38,686Computersn/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 01-ERP-0015 72,12072,120Backup Server n/a 01-ERP-0017 213,00033,000 44,000 44,000 45,320 46,680IT - Office 365 n/a 01-ERP-0020 50,30010,000 10,000 10,000 10,000 10,300IT - Patching Automation Software 1 01-ERP-0022 168,00021,000 42,000 42,000 63,000IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0211 128,13722,000 25,000 26,250 27,038 27,849PD - Network Server n/a 1,445,207141,075 204,129 346,685 229,954 523,364Comm Svcs - IT Total Community Services 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 16,23116,231Community Services Total Fire 01-ERP-0105 725,000725,000Quick Attack Pumper/Rescue (Rescue 8) n/a 01-ERP-0108 250,000250,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0109 32,00032,000Extrication Tool (1)n/a 01-ERP-0112 16,18016,180Thermal Imaging Camera (2)n/a 01-ERP-0125 386,000386,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-0129 12,00012,000Fire - EOC Upgrade n/a 01-ERP-0131 55,00055,000Fire - Station Alerting System n/a 1,510,18028,000 775,000 707,180Fire Total Wednesday, November 11, 202016 Total2021 2022 2023 2024 2025Department Project # Priority HRA 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 Total Pavilion 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 11,60011,600Pavilion Total Police 01-ERP-0200 623,300161,100 110,000 117,400 117,400 117,400Marked Patrol Vehicles (7) n/a 01-ERP-0201 121,15457,000 64,154Sergeant'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 160,000160,000Squad Car Camera Systems/ Body Worn Camera 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 90,00090,000Taser Replacement n/a 01-ERP-0218 22,00022,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0221 150,000150,000Records Management System n/a 1,748,766271,800 332,100 595,912 367,400 181,554Police Total Public Works: Parks/Forestry 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0808 50,00050,000Riding Mowers (2)1 01-ERP-0814 10,00010,000Trailer Flatbed n/a 259,00050,000 199,000 10,000Public 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 102,90053,400 49,5001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck 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 811,800328,400 165,300 318,100Public Works: Streets/Traffic Total Refuse 01-ERP-0900 545,500270,300 275,200Refuse Truck (RAP-R) (2) n/a 545,500270,300 275,200Refuse Total Sewer 01-ERP-0555 43,00043,000Generator (2) n/a 01-ERP-0560 180,000180,000Sewer Televising Camera and Van n/a 223,000223,000Sewer Total GRAND TOTAL 6,771,508815,799 1,162,629 2,134,997 943,754 1,714,329 Wednesday, November 11, 202017 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2021 thru 2025 TotalSource2021 2022 2023 2024 2025 AC - Arts Center Fund 31,00013,500 6,700 10,800 Equipment Replacement Fund 5,799,408545,499 909,629 1,998,497 917,454 1,428,329 HRA - Housing and Redevelopment Authority 57,60016,500 41,100 PA - Pavilion Fund 11,60011,600 PKG - Parking Fund 8,0008,000 RF - Refuse Fund 627,300270,300 81,800 275,200 SF - Sanitary Sewer Fund 229,800223,000 6,800 WF - Water Fund 6,8006,800 815,799 1,162,629 2,134,997 943,754 1,714,329 6,771,508GRAND TOTAL Wednesday, November 11, 2020 18 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2021 2025thru TotalSource Project # Priority 2021 2022 2023 2024 2025 AC - Arts Center Fund 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 31,00013,500 6,700 10,800AC - Arts Center Fund Total Equipment Replacement Fund 01-ERP-0003 128,13622,000 25,000 26,250 27,037 27,849CH - Network Server n/a 01-ERP-0004 76,00076,000Telephone System n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 180,51433,075 34,729 36,465 37,559 38,686Computersn/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 01-ERP-0015 72,12072,120Backup Server n/a 01-ERP-0017 213,00033,000 44,000 44,000 45,320 46,680IT - Office 365 n/a 01-ERP-0020 50,30010,000 10,000 10,000 10,000 10,300IT - Patching Automation Software 1 01-ERP-0022 168,00021,000 42,000 42,000 63,000IT - Windows 10 Enterprise Upgrade n/a 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-0041 62,62462,624Activity Center A/V Replacement & Upgrade 3 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 01-ERP-0105 725,000725,000Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0108 250,000250,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0109 32,00032,000Extrication Tool (1)n/a 01-ERP-0112 16,18016,180Thermal Imaging Camera (2)n/a 01-ERP-0125 386,000386,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-0129 12,00012,000Fire - EOC Upgrade n/a 01-ERP-0131 55,00055,000Fire - Station Alerting System n/a 01-ERP-0200 623,300161,100 110,000 117,400 117,400 117,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 121,15457,000 64,154Sergeant'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 128,13722,000 25,000 26,250 27,038 27,849PD - Network Server n/a 01-ERP-0212 152,000152,000Squad Car Camera Systems/ Body Worn Camera 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 90,00090,000Taser Replacement n/a 01-ERP-0218 22,00022,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad 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 Wednesday, November 11, 2020 19 TotalSource Project # Priority 2021 2022 2023 2024 2025 01-ERP-0303 102,90053,400 49,5001 Ton Dump Truck (2) n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck 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-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0808 50,00050,000Riding Mowers (2)1 01-ERP-0814 10,00010,000Trailer Flatbed n/a 5,799,408545,499 909,629 1,998,497 917,454 1,428,329Equipment 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 PA - Pavilion Fund 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 11,60011,600PA - Pavilion Fund Total PKG - Parking Fund 01-ERP-0212 8,0008,000Squad Car Camera Systems/ Body Worn Camera n/a 8,0008,000PKG - Parking Fund Total RF - Refuse Fund 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0900 545,500270,300 275,200Refuse Truck (RAP-R) (2)n/a 627,300270,300 81,800 275,200RF - 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 01-ERP-0560 180,000180,000Sewer Televising Camera and Van n/a 229,800223,000 6,800SF - Sanitary Sewer Fund Total WF - Water Fund 01-ERP-0004 6,8006,800Telephone System n/a 6,8006,800WF - Water Fund Total 6,771,508815,799 1,162,629 2,134,997 943,754 1,714,329GRAND TOTAL Wednesday, November 11, 2020 20 EQUIPMENT REQUESTS 21 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2021 2025 thru Department Comm Svcs - Activity Center Description Upgrade the present security system, which was installed in 2008. Project #01-ERP-0037 Priority 1 Urgent Justification We monitor the Activity Center to insure the safety of our participants and staff. Staff works numerous hours while alone within the building. We rely on security cameras to deter harm to participants or staff, or damage to the building itself. Cameras can help identify the perpetrator if something should happen. 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:$51,160 Total2021 2022 2023 2024 2025Expenditures 20,00020,000Equipment 20,000 20,000Total Total2021 2022 2023 2024 2025Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Wednesday, November 11, 2020 22 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2021 2025 thru 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 Total2021 2022 2023 2024 2025Expenditures 29,00017,000 12,000Equipment 17,000 12,000 29,000Total Total2021 2022 2023 2024 2025Funding Sources 29,00017,000 12,000Equipment Replacement Fund 17,000 12,000 29,000Total Wednesday, November 11, 2020 23 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2021 2025 thru Department Comm Svcs - Activity Center Description Continue this replacement project that began in 2016 to replace and upgrade the audio and visual system within the Hopkins Activity Center, area by area, throughout the next 4 years. Note: The gym has already been replaced and upgraded. Project #01-ERP-0041 Priority 3 Important 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 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. 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:$160,192 Total2021 2022 2023 2024 2025Expenditures 62,62462,624Equipment 62,624 62,624Total Total2021 2022 2023 2024 2025Funding Sources 62,62462,624Equipment Replacement Fund 62,624 62,624Total Wednesday, November 11, 2020 24 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2021 2025 thru 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:$61,515 Total2021 2022 2023 2024 2025Expenditures 13,50013,500Equipment 13,500 13,500Total Total2021 2022 2023 2024 2025Funding Sources 13,50013,500AC - Arts Center Fund 13,500 13,500Total Wednesday, November 11, 2020 25 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2021 2025 thru Department Comm Svcs - Arts Center Description Replace original retractable projection screen in the theater with wider format screen to mesh with current technology. Project #01-ERP-1107 Priority 2 Very Important Justification This is an item being requested more frequently from renters as they find the dimensions of the current screen do not match up with the presentations they bring in. Budget Impact/Other Variance from 20-year plan: New item Useful Life 10 yearsProject Name Art Center Theater Projection Screen Category Equipment Type Equipment Future Total Project Cost:$32,794 Total2021 2022 2023 2024 2025Expenditures 6,7006,700Equipment 6,700 6,700Total Total2021 2022 2023 2024 2025Funding Sources 6,7006,700AC - Arts Center Fund 6,700 6,700Total Wednesday, November 11, 2020 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Co-Director 2021 2025 thru Department Comm Svcs - Arts Center Description 26-inch auto scrubber Project #01-ERP-1109 Priority n/a Justification Current scrubber has reached its lifetime and no longer spins fast enough to be effective. Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $-0- Useful Life 10 yearsProject Name Art Center Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$33,316 Total2021 2022 2023 2024 2025Expenditures 10,80010,800Equipment 10,800 10,800Total Total2021 2022 2023 2024 2025Funding Sources 10,80010,800AC - Arts Center Fund 10,800 10,800Total Wednesday, November 11, 2020 27 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2021 2025 thru 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:$1,113,900 Total2021 2022 2023 2024 2025Expenditures 128,13622,000 25,000 26,250 27,037 27,849Equipment 22,000 25,000 26,250 27,037 27,849 128,136Total Total2021 2022 2023 2024 2025Funding Sources 128,13622,000 25,000 26,250 27,037 27,849Equipment Replacement Fund 22,000 25,000 26,250 27,037 27,849 128,136Total Wednesday, November 11, 2020 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2021 2025 thru 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:$490,131 Total2021 2022 2023 2024 2025Expenditures 89,60089,600Equipment 89,600 89,600Total Total2021 2022 2023 2024 2025Funding Sources 76,00076,000Equipment Replacement Fund 6,8006,800SF - Sanitary Sewer Fund 6,8006,800WF - Water Fund 89,600 89,600Total Wednesday, November 11, 2020 29 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2021 2025 thru Department Comm Svcs - IT Description Finance software upgrade. Software currently used by Finance, City Clerk, Inspections and Public Works. This includes software for all finance applications including general ledger, payroll, accounts payable, accounts receivable, fixed assets, utility billing; Business Licenses, Building Permits, GIS Mapping, Purchasing, etc. Project #01-ERP-0005 Priority n/a Justification Current software vendor is unable to keep up with technology and internet security standards. Staff is often frustrated with how the software works and are often unable to get reports they need from the system. Budget Impact/Other Variance from 20 year plan - replacement needed in 2014 Estimate salvage/resale value on replaced item: $-0- Useful Life 7 yearsProject Name Financial Software - Various Depts.Category Equipment Type Equipment Future Total Project Cost:$1,573,219 Total2021 2022 2023 2024 2025Expenditures 315,000315,000Equipment 315,000 315,000Total Total2021 2022 2023 2024 2025Funding Sources 315,000315,000Equipment Replacement Fund 315,000 315,000Total Wednesday, November 11, 2020 30 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2021 2025 thru 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,852,679 Total2021 2022 2023 2024 2025Expenditures 180,51433,075 34,729 36,465 37,559 38,686Equipment 33,075 34,729 36,465 37,559 38,686 180,514Total Total2021 2022 2023 2024 2025Funding Sources 180,51433,075 34,729 36,465 37,559 38,686Equipment Replacement Fund 33,075 34,729 36,465 37,559 38,686 180,514Total Wednesday, November 11, 2020 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2021 2025 thru 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:$74,856 Total2021 2022 2023 2024 2025Expenditures 23,40023,400Equipment 23,400 23,400Total Total2021 2022 2023 2024 2025Funding Sources 23,40023,400Equipment Replacement Fund 23,400 23,400Total Wednesday, November 11, 2020 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2021 2025 thru 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:$133,878 Total2021 2022 2023 2024 2025Expenditures 20,00020,000Equipment 20,000 20,000Total Total2021 2022 2023 2024 2025Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Wednesday, November 11, 2020 33 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2021 2025 thru 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:$338,486 Total2021 2022 2023 2024 2025Expenditures 57,00057,000Equipment 57,000 57,000Total Total2021 2022 2023 2024 2025Funding Sources 57,00057,000Equipment Replacement Fund 57,000 57,000Total Wednesday, November 11, 2020 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2021 2025 thru 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:$801,110 Total2021 2022 2023 2024 2025Expenditures 72,12072,120Equipment 72,120 72,120Total Total2021 2022 2023 2024 2025Funding Sources 72,12072,120Equipment Replacement Fund 72,120 72,120Total Wednesday, November 11, 2020 35 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2021 2025 thru 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 Life 1 yearProject Name IT - Office 365 Category Equipment Type Equipment Future Total Project Cost:$2,420,118 Total2021 2022 2023 2024 2025Expenditures 213,00033,000 44,000 44,000 45,320 46,680Equipment 33,000 44,000 44,000 45,320 46,680 213,000Total Total2021 2022 2023 2024 2025Funding Sources 213,00033,000 44,000 44,000 45,320 46,680Equipment Replacement Fund 33,000 44,000 44,000 45,320 46,680 213,000Total Wednesday, November 11, 2020 36 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2021 2025 thru 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 1 yearProject Name IT - Patching Automation Software Category Equipment Type Equipment Future Total Project Cost:$287,617 Total2021 2022 2023 2024 2025Expenditures 50,30010,000 10,000 10,000 10,000 10,300Equipment 10,000 10,000 10,000 10,000 10,300 50,300Total Total2021 2022 2023 2024 2025Funding Sources 50,30010,000 10,000 10,000 10,000 10,300Equipment Replacement Fund 10,000 10,000 10,000 10,000 10,300 50,300Total Wednesday, November 11, 2020 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2021 2025 thru Department Comm Svcs - IT Description Upgrade Windows 10 Pro software to Windows 10 Enterprise. Required to renew every 3 years. This plan would bring the PD into compliance in 2020 then upgrade 60 city computers a year until all city computers are upgraded. Each batch of 60 computers needs to be renewed every 3 years. It is estimated that it will take 3 years to fully upgrade the city to Windows 10 Enterprise. Project #01-ERP-0022 Priority n/a Justification The BCA has mandated that we move to Enterprise edition for our Windows computers in the PD. Microsoft is changing the way they deliver Windows. It is becoming like Office, where you will no longer own Windows outright, you will have to rent it from them. We have to switch to Enterprise in the PD for compliance reasons, but it is strongly suggested that we plan on switching to Enterprise for all city computers as well. There may come a time where we are forced to switch to Enterprise edition for the city. It would be ideal to plan ahead and budget money for a gradual upgrade for the city so it doesn't come as a surprise. Budget Impact/Other Useful Life 1 yearProject Name IT - Windows 10 Enterprise Upgrade Category Unassigned Type Equipment Future Total Project Cost:$189,000 Total2021 2022 2023 2024 2025Expenditures 168,00021,000 42,000 42,000 63,000Equipment 21,000 42,000 42,000 63,000 168,000Total Total2021 2022 2023 2024 2025Funding Sources 168,00021,000 42,000 42,000 63,000Equipment Replacement Fund 21,000 42,000 42,000 63,000 168,000Total Wednesday, November 11, 2020 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2021 2025 thru 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 usedfor data storage Budget Impact/Other Useful Life 1 yearProject Name PD - Network Server Category Equipment Type Equipment Future Total Project Cost:$1,118,901 Total2021 2022 2023 2024 2025Expenditures 128,13722,000 25,000 26,250 27,038 27,849Equipment 22,000 25,000 26,250 27,038 27,849 128,137Total Total2021 2022 2023 2024 2025Funding Sources 128,13722,000 25,000 26,250 27,038 27,849Equipment Replacement Fund 22,000 25,000 26,250 27,038 27,849 128,137Total Wednesday, November 11, 2020 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Asst City Manager 2021 2025 thru Department Community Services Description Included in this request are equipment needed to move to an electronic plan review and inspections process. Revu -Bluebeam electronic plan review software - 2020 - $1,100 (useful life 8-10 years) Ipads - 2020 - $5,400 (useful life 5-6 years) Rental Inspection software - 2020 - $7,500 (useful life 7-10 years) Project #01-ERP-0052 Priority 2 Very Important Justification As more and more contractors and architects ask to submit plan electronically, Blubeam software will enable inspectors to perform electronic plan reviews which will make the plan review process more efficient and enhance customer service. As the inspection and construction industry becomes more paperless, iPads will enable inspectors to use mobile technology to keep up with the requests of engineers, architect, contractors, landlords and residents. Ipads are a key piece that will enable staff to view electronic plans in the field. Going paperless will eventually eliminate our need for paper plan scanning and sorting which is very time consuming and costs $1,500 - $2,000 per year. The software company currently used by Rental Inspectors has recently gone out of business and support for the software is going to be on a very limited basis after 2020. Because rental inspections effect such a large part of the city and the department, I believe getting a new software in place before the existing software stops functioning is essential to the rental inspection program. Budget Impact/Other Useful Life 5-7 yearsProject Name Electronic Inspections Processing Category Equipment Type Equipment Future Total Project Cost:$96,150 Total2021 2022 2023 2024 2025Expenditures 16,23116,231Equipment 16,231 16,231Total Total2021 2022 2023 2024 2025Funding Sources 16,23116,231Equipment Replacement Fund 16,231 16,231Total Wednesday, November 11, 2020 40 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru Department Fire Description Quick attack pumper/rescue. Current vehicle: 2012 Rescue (#104) Project #01-ERP-0105 Priority n/a Justification This truck is used for day to day operation. We would move to a bigger vehicle due to the use of the vehicle for response. The current vehicle is undersized for the type of truck it is on. We are spending $20,000.00 per maintanance cost per year. 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:$1,653,063 Total2021 2022 2023 2024 2025Expenditures 725,000725,000Equipment 725,000 725,000Total Total2021 2022 2023 2024 2025Funding Sources 725,000725,000Equipment Replacement Fund 725,000 725,000Total Wednesday, November 11, 2020 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru Department Fire Description Breathing apparatus for interior firefighting for firefighters. Project #01-ERP-0108 Priority n/a Justification The breathing apparatus was taken out of the ERP in 2006 because we thought we were getting a grant. Grant was not successful. The SCBA's (45) need to be replaced because they are at the end of their life and cannot be hydro tested any longer. Budget Impact/Other Variance from 20 year plan - Move back to 2025. Purchased SCBA's in 2015 with grant funds. Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Self Contained Breathing Apparatus (SCBA) (45)Category Equipment Type Equipment Future Total Project Cost:$752,000 Total2021 2022 2023 2024 2025Expenditures 250,000250,000Equipment 250,000 250,000Total Total2021 2022 2023 2024 2025Funding Sources 250,000250,000Equipment Replacement Fund 250,000 250,000Total Wednesday, November 11, 2020 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru 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 (1)Category Equipment Type Equipment Future Total Project Cost:$180,800 Total2021 2022 2023 2024 2025Expenditures 32,00032,000Equipment 32,000 32,000Total Total2021 2022 2023 2024 2025Funding Sources 32,00032,000Equipment Replacement Fund 32,000 32,000Total Wednesday, November 11, 2020 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru 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:$144,885 Total2021 2022 2023 2024 2025Expenditures 16,18016,180Equipment 16,180 16,180Total Total2021 2022 2023 2024 2025Funding Sources 16,18016,180Equipment Replacement Fund 16,180 16,180Total Wednesday, November 11, 2020 44 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru 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. 2025 - 356,500 FD 2025 - 29,500 PW Useful Life 5-7 yearsProject Name Fire Radios - Portable and Mobile Devices Category Equipment Type Equipment Future Total Project Cost:$2,335,328 Total2021 2022 2023 2024 2025Expenditures 386,000386,000Equipment 386,000 386,000Total Total2021 2022 2023 2024 2025Funding Sources 386,000386,000Equipment Replacement Fund 386,000 386,000Total Wednesday, November 11, 2020 45 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru 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 2022. Budget Impact/Other Reoccuring every 10 years. Useful Life 10 yearsProject Name Fire - Fire Helmets Category Equipment Type Equipment Future Total Project Cost:$58,191 Total2021 2022 2023 2024 2025Expenditures 16,00016,000Equipment 16,000 16,000Total Total2021 2022 2023 2024 2025Funding Sources 16,00016,000Equipment Replacement Fund 16,000 16,000Total Wednesday, November 11, 2020 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru 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 Life 5 yearsProject Name Fire - Lucus Device Category Equipment Type Equipment Future Total Project Cost:$98,686 Total2021 2022 2023 2024 2025Expenditures 18,00018,000Equipment 18,000 18,000Total Total2021 2022 2023 2024 2025Funding Sources 18,00018,000Equipment Replacement Fund 18,000 18,000Total Wednesday, November 11, 2020 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru Department Fire Description Upgrade EOC Project #01-ERP-0129 Priority n/a Justification The EOC has not been upgraded since the station opened in 2004. The upgrade would consist of upgrading Technology IE: TV and Video conferencing. Budget Impact/Other Useful Life 20 yearsProject Name Fire - EOC Upgrade Category Equipment Type Equipment Future Total Project Cost:$12,000 Total2021 2022 2023 2024 2025Expenditures 12,00012,000Equipment 12,000 12,000Total Total2021 2022 2023 2024 2025Funding Sources 12,00012,000Equipment Replacement Fund 12,000 12,000Total Wednesday, November 11, 2020 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2021 2025 thru Department Fire Description This sytem would alert members thogh out the station when there is a call. This system will integrate with the new paging system that Hennepin County is adopting. Project #01-ERP-0131 Priority n/a Justification Help with quicker response to in coming calls. Will prepare the staion for future 24 hour shifts. Budget Impact/Other Useful LifeProject Name Fire - Station Alerting System Category Buildings: Fire Facilities Type Equipment Future Total Project Cost:$55,000 Total2021 2022 2023 2024 2025Expenditures 55,00055,000Equipment 55,000 55,000Total Total2021 2022 2023 2024 2025Funding Sources 55,00055,000Equipment Replacement Fund 55,000 55,000Total Wednesday, November 11, 2020 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Unassigned 2021 2025 thru 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:$214,398 Total2021 2022 2023 2024 2025Expenditures 41,10041,100Vehicles 41,100 41,100Total Total2021 2022 2023 2024 2025Funding Sources 41,10041,100HRA - Housing and Redevelopment Authority 41,100 41,100Total Wednesday, November 11, 2020 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2021 2025 thru 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:$76,876 Total2021 2022 2023 2024 2025Expenditures 16,50016,500Equipment 16,500 16,500Total Total2021 2022 2023 2024 2025Funding Sources 16,50016,500HRA - Housing and Redevelopment Authority 16,500 16,500Total Wednesday, November 11, 2020 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2021 2025 thru Department Pavilion Description 26" to 28" battery operated walk behind floor scrubber. Floor scrubber is used to clean the arenas concrete floor and tiled surfaces throughout the building. 2014 cost = $8,651.94 Asset ID #5172 Project #01-ERP-1003 Priority n/a Justification Replace the existing floor scrubber with new model. Current floor scrubber was purchased in 2014 and is scheduled to be replaced in 2024. Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Pavilion - Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$48,167 Total2021 2022 2023 2024 2025Expenditures 11,60011,600Equipment 11,600 11,600Total Total2021 2022 2023 2024 2025Funding Sources 11,60011,600PA - Pavilion Fund 11,600 11,600Total Wednesday, November 11, 2020 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2021 2025 thru 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 In 2019, no vehicles were purchased. Planned reallocation to body camera project. Useful Life 3 yearsProject Name Marked Patrol Vehicles (7)Category Vehicles Type Equipment Future Total Project Cost:$3,287,200 Total2021 2022 2023 2024 2025Expenditures 623,300161,100 110,000 117,400 117,400 117,400Vehicles 161,100 110,000 117,400 117,400 117,400 623,300Total Total2021 2022 2023 2024 2025Funding Sources 623,300161,100 110,000 117,400 117,400 117,400Equipment Replacement Fund 161,100 110,000 117,400 117,400 117,400 623,300Total Wednesday, November 11, 2020 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2021 2025 thru 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 Useful Life 4 yearsProject Name Sergeant's Vehicle Category Vehicles Type Equipment Future Total Project Cost:$596,642 Total2021 2022 2023 2024 2025Expenditures 121,15457,000 64,154Vehicles 57,000 64,154 121,154Total Total2021 2022 2023 2024 2025Funding Sources 121,15457,000 64,154Equipment Replacement Fund 57,000 64,154 121,154Total Wednesday, November 11, 2020 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2021 2025 thru Department Police Description Marked patrol vehicle used by Parking Enforcement Officer to respond to calls for service, enforce parking laws, and perfom duties as assigned. 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 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:$412,572 Total2021 2022 2023 2024 2025Expenditures 53,70053,700Vehicles 53,700 53,700Total Total2021 2022 2023 2024 2025Funding Sources 53,70053,700Equipment Replacement Fund 53,700 53,700Total Wednesday, November 11, 2020 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2021 2025 thru 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: 2018 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 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:$795,189 Total2021 2022 2023 2024 2025Expenditures 72,10072,100Vehicles 72,100 72,100Total Total2021 2022 2023 2024 2025Funding Sources 72,10072,100Equipment Replacement Fund 72,100 72,100Total Wednesday, November 11, 2020 56 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2021 2025 thru 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 - 11 Squad car cameras and 24 body cameras Squad cameras 6,000/each. Body cameras 1,200/each. Annual costs/maintenance = $17,325 (Body Cameras 3 year warranty, Squad Cameras 5 year warranty) Useful Life 5 yearsProject Name Squad Car Camera Systems/ Body Worn Camera Category Equipment Type Equipment Future Total Project Cost:$866,921 Total2021 2022 2023 2024 2025Expenditures 160,000160,000Equipment 160,000 160,000Total Total2021 2022 2023 2024 2025Funding Sources 152,000152,000Equipment Replacement Fund 8,0008,000PKG - Parking Fund 160,000 160,000Total Wednesday, November 11, 2020 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2021 2025 thru 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 5 year replacement schedule Useful Life 5 yearsProject Name Tactical Ballistic Vests / Helmets - SWAT Category Equipment Type Equipment Future Total Project Cost:$623,626 Total2021 2022 2023 2024 2025Expenditures 76,51276,512Equipment 76,512 76,512Total Total2021 2022 2023 2024 2025Funding Sources 76,51276,512Equipment Replacement Fund 76,512 76,512Total Wednesday, November 11, 2020 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2021 2025 thru 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:$1,906,203 Total2021 2022 2023 2024 2025Expenditures 290,000290,000Equipment 290,000 290,000Total Total2021 2022 2023 2024 2025Funding Sources 290,000290,000Equipment Replacement Fund 290,000 290,000Total Wednesday, November 11, 2020 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Captain 2021 2025 thru 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 of Tasers in 2020 was $81,130 ($2,1318 x 35) Useful Life 4 yearsProject Name Taser Replacement Category Equipment Type Equipment Future Total Project Cost:$721,905 Total2021 2022 2023 2024 2025Expenditures 90,00090,000Equipment 90,000 90,000Total Total2021 2022 2023 2024 2025Funding Sources 90,00090,000Equipment Replacement Fund 90,000 90,000Total Wednesday, November 11, 2020 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2021 2025 thru 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:$93,000 Total2021 2022 2023 2024 2025Expenditures 22,00022,000Equipment 22,000 22,000Total Total2021 2022 2023 2024 2025Funding Sources 22,00022,000Equipment Replacement Fund 22,000 22,000Total Wednesday, November 11, 2020 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2021 2025 thru 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. Replacement in 2019 for 12 computers. To be replaced in 2024. 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 Change in replacement year to accurately reflect life expectancy in relation to when the computers were purchased. Useful Life 5 yearsProject Name Squad Computers Category Equipment Type Equipment Future Total Project Cost:$561,242 Total2021 2022 2023 2024 2025Expenditures 90,00090,000Equipment 90,000 90,000Total Total2021 2022 2023 2024 2025Funding Sources 90,00090,000Equipment Replacement Fund 90,000 90,000Total Wednesday, November 11, 2020 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2021 2025 thru Department Police Description LETG - Records Management System was purchased at the end of 2012. This maintains all police records and reports. 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 Total2021 2022 2023 2024 2025Expenditures 150,000150,000Equipment 150,000 150,000Total Total2021 2022 2023 2024 2025Funding Sources 150,000150,000Equipment Replacement Fund 150,000 150,000Total Wednesday, November 11, 2020 63 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru 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:$173,369 Total2021 2022 2023 2024 2025Expenditures 35,40035,400Vehicles 35,400 35,400Total Total2021 2022 2023 2024 2025Funding Sources 35,40035,400Equipment Replacement Fund 35,400 35,400Total Wednesday, November 11, 2020 64 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru 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:$523,484 Total2021 2022 2023 2024 2025Expenditures 163,600163,600Vehicles 163,600 163,600Total Total2021 2022 2023 2024 2025Funding Sources 81,80081,800Equipment Replacement Fund 81,80081,800RF - Refuse Fund 163,600 163,600Total Wednesday, November 11, 2020 65 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru 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 1 Urgent Justification Mowing city parks and right of ways. Move replacement of #826 to 2021 - Ran 10 years past useful life Move replacement of #823 to 2021 Both replacements of current vehicles were held off in 2020 due to the COVID-19 Pandemic. Budget Impact/Other 2021 - Replace 2004 Zero Turn #826 at $15,000 2021 - Replace 2006 Jacobson #823 at $35,000 The Jacobson will be replaced with 7500-D Zmaster Toro Zero Turn Useful Life 6 yearsProject Name Riding Mowers (2)Category Equipment Type Equipment Future Total Project Cost:$323,930 Total2021 2022 2023 2024 2025Expenditures 50,00050,000Equipment 50,000 50,000Total Total2021 2022 2023 2024 2025Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Wednesday, November 11, 2020 66 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Public Works: Parks/Forestry Description Used to haul multiple riding mowers Current trailor: Unit #845, 1997 Remackle Trailer, overhauled/refurbished in 2016 Project #01-ERP-0814 Priority n/a Justification Allows one truck to pull two riding mowers to parks Budget Impact/Other Variance from 20 year plan - extend life 4 years due to overhaul/refurbishment. Estimate salvage/resale value on replaced item: $ 2016-Increased estimated replacement cost from $2,200 to $10,000 Useful Life 15 yearsProject Name Trailer Flatbed Category Equipment Type Equipment Future Total Project Cost:$26,980 Total2021 2022 2023 2024 2025Expenditures 10,00010,000Equipment 10,000 10,000Total Total2021 2022 2023 2024 2025Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Wednesday, November 11, 2020 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Public Works: Streets/Traffic Description Pickup used by various divisions of Public Works. Current vehicle: 2013 Ford F-150 (#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 Total2021 2022 2023 2024 2025Expenditures 28,90028,900Vehicles 28,900 28,900Total Total2021 2022 2023 2024 2025Funding Sources 28,90028,900Equipment Replacement Fund 28,900 28,900Total Wednesday, November 11, 2020 68 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Public Works: Streets/Traffic Description Truck is used in the Street Division of Public Works. Current vehicles: 2000 Ford F450 (#805) & 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 10 yearsProject Name 1 Ton Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$281,600 Total2021 2022 2023 2024 2025Expenditures 102,90053,400 49,500Vehicles 53,400 49,500 102,900Total Total2021 2022 2023 2024 2025Funding Sources 102,90053,400 49,500Equipment Replacement Fund 53,400 49,500 102,900Total Wednesday, November 11, 2020 69 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Public Works: Streets/Traffic Description Boom truck used in Street and Traffic Divisions of Public Works. Current vehicle: 2012 Ford F450 (#309) Project #01-ERP-0304 Priority n/a Justification Vehicle used by Traffic Department for signal and light pole maintenance. Budget Impact/Other Variance from 20 year plan - Increase amount to reflect actual. Estimate salvage/resale value on replaced item: $8,000 Useful life moved from 17 years to 12 years. Useful Life 12 yearsProject Name 1 Ton Traffic Boom Truck Category Vehicles Type Equipment Future Total Project Cost:$218,900 Total2021 2022 2023 2024 2025Expenditures 136,400136,400Vehicles 136,400 136,400Total Total2021 2022 2023 2024 2025Funding Sources 136,400136,400Equipment Replacement Fund 136,400 136,400Total Wednesday, November 11, 2020 70 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru 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 Total2021 2022 2023 2024 2025Expenditures 225,000225,000Vehicles 225,000 225,000Total Total2021 2022 2023 2024 2025Funding Sources 225,000225,000Equipment Replacement Fund 225,000 225,000Total Wednesday, November 11, 2020 71 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Public Works: Streets/Traffic Description Current equipment: 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 Total2021 2022 2023 2024 2025Expenditures 268,600268,600Equipment 268,600 268,600Total Total2021 2022 2023 2024 2025Funding Sources 268,600268,600Equipment Replacement Fund 268,600 268,600Total Wednesday, November 11, 2020 72 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Public Works: Streets/Traffic Description Loading trucks, landscape work, snow removal, material handling. Current equipment: 2011 Bobcat S650 Skid-Steer Loader (#325) Project #01-ERP-0309 Priority n/a Justification Budget Impact/Other Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Skid Loader (2)Category Equipment Type Equipment Future Total Project Cost:$258,900 Total2021 2022 2023 2024 2025Expenditures 50,00050,000Equipment 50,000 50,000Total Total2021 2022 2023 2024 2025Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Wednesday, November 11, 2020 73 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Refuse Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 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 8 yearsProject Name Refuse Truck (RAP-R) (2)Category Vehicles Type Equipment Future Total Project Cost:$1,462,600 Total2021 2022 2023 2024 2025Expenditures 545,500270,300 275,200Vehicles 270,300 275,200 545,500Total Total2021 2022 2023 2024 2025Funding Sources 545,500270,300 275,200RF - Refuse Fund 270,300 275,200 545,500Total Wednesday, November 11, 2020 74 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Sewer Description Portable generator used by Water/Sewer Divisions of Public Works. Current equipment: 2022 Generator (#535), "PW Generator " 2010 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 Total2021 2022 2023 2024 2025Expenditures 43,00043,000Equipment 43,000 43,000Total Total2021 2022 2023 2024 2025Funding Sources 43,00043,000SF - Sanitary Sewer Fund 43,000 43,000Total Wednesday, November 11, 2020 75 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2021 2025 thru Department Sewer Description Sewer inspection Crawler (Televising Camera) with Ford Transit Van used by Utility crews to televise sanitary and storm sewers annually. Project #01-ERP-0560 Priority n/a Justification Better effectiviness, efficiency and cost. Currently the televising for our sanitary lines go out for bids, RFP's for 2020's work averaged over $33,000. The payback would be 6 years and with the camera's useful life as 12-15 years, we would benefit 6-9 years of induring no costs other than maintenance before needing to replace. We're at the mercy of the contractor for a timley completion of televising, the best scenario is to televise immediately after jetting to make sure the sanitary lines are clean of debris or damage. With this we can react immediately to resolve any issues we may find. Budget Impact/Other Estimate salvage/resale value at the end of useful life is $30,000. Useful Life 12 yearsProject Name Sewer Televising Camera and Van Category Utilities: Municipal Sanitary Se Type Equipment Future Total Project Cost:$180,000 Total2021 2022 2023 2024 2025Expenditures 180,000180,000Equipment 180,000 180,000Total Total2021 2022 2023 2024 2025Funding Sources 180,000180,000SF - Sanitary Sewer Fund 180,000 180,000Total Wednesday, November 11, 2020 76 TWENTY-YEAR REPLACEMENT SCHEDULE 77 11/17/2020 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average:1,400,100$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 ACTIVITY CENTER ERP-0032 Sound System 15 13,700 ERP-0035 Floor Scrubber 10 6,700 9,000 ERP-0037 Security System Upgrade 15-18 20,000 32,000 ERP-0038 Kitchen Storage 30 17,000 12,000 ERP-0039 Dishwasher 30 ERP-0041 A/V Replacement & Upgrade 20 62,624 SUBTOTAL 82,624 17,000 12,000 6,700 13,700 9,000 32,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 20,400 ERP-1107 Theater Projection Screen 10 6,700 9,000 ERP-1109 Floor Scrubber 10 10,800 14,500 ERP-1112 Surveillance System 5 6,000 8,000 10,000 13,500 6,700 10,800 7,100 6,000 16,600 15,000 9,000 14,500 20,400 10,000 COMMUNITY SERVICES ERP-0010 Election Booths 20 6,500 ERP-0051 Exterior Security Camera System 15 65,000 ERP-0052 Electronic Inspections Processing 5-7 16,231 21,800 29,200 EQUIPMENT SUBTOTAL 16,231 6,500 21,800 65,000 29,200 FIRE ERP-0100 Tele-Squirt E-2 10 1,000,000 1,350,000 ERP-0101 Fire Pumper E-3 20 722,400 ERP-0105 Quick Attack Pumper/Rescue R-8 10 725,000 974,000 ERP-0106 Aerial Truck 20 1,572,000 VEHICLES SUBTOTAL 725,000 722,400 1,000,000 1,572,000 974,000 1,350,000 ERP-0107 Air Compressor 15 54,400 ERP-0108 Breathing Apparatus (45) (SCBA)10 250,000 336,000 ERP-0109 Extrication Tool (2)10 32,000 36,900 40,300 ERP-0112 Thermal Imaging Camera (2)10 16,180 20,700 ERP-0113 Emergency Preparedness Siren 20 38,500 ERP-0114 Floor Scrubber 12 20,300 28,900 ERP-0125 Radios-Portable & Mobile 5-7 386,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 ERP-0128 Hose Replacement 20 70,000 ERP-0129 EOC Upgrade 20 12,000 ERP-0131 Station Alerting System 55,000 EQUIPMENT SUBTOTAL 28,000 50,000 707,180 38,500 20,300 20,000 36,900 485,898 62,300 24,000 356,700 514,700 30,000 28,900 70,000 IT ERP-0003 City Hall - Network Upgrade 1 22,000 25,000 26,250 27,038 27,849 28,684 29,545 30,431 31,344 32,285 33,253 34,251 35,278 36,337 37,427 38,550 39,706 40,897 42,124 43,388 ERP-0004 Phone System 8 89,600 110,700 140,000 ERP-0005 Financial Software 7 315,000 ERP-0006 Computers 3-5 33,075 34,729 36,465 37,559 38,686 40,620 42,651 44,784 47,023 49,374 51,843 54,435 57,157 60,015 63,015 66,166 69,474 72,948 76,596 80,425 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 57,000 65,000 75,000 ERP-0015 Backup Server 3 72,120 74,000 78,000 82,000 87,000 ERP-0017 Office 365 1 33,000 44,000 44,000 45,320 46,680 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 88,000 90,000 ERP-0018 RSA/Netmotion VPN 5 24,000 27,000 31,500 ERP-0019 Email Threat Protection 5 26,500 30,000 ERP-0020 Patching Automation Software 5 10,000 10,000 10,000 10,000 10,300 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 10,000 10,000 ERP-0022 Windows 10 Enterprise Upgrade 1 21,000 42,000 42,000 63,000 ERP-0211 Police - Network Server (3)3 22,000 25,000 26,250 27,038 27,849 28,684 29,545 30,431 31,344 32,285 33,253 34,251 35,278 36,337 37,427 38,550 39,706 40,897 42,124 43,388 EQUIPMENT SUBTOTAL 141,075 204,129 346,685 229,954 523,364 230,989 162,741 169,647 345,212 272,943 302,049 198,937 288,713 321,688 297,869 345,265 238,887 249,743 430,344 267,201 POLICE ERP-0200 Squad 3 161,100 110,000 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 175,000 180,000 ERP-0201 Sergeant Vehicle #209 4 57,000 64,154 72,200 81,300 91,500 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 107,000 ERP-0205 SWAT Vehicle #240 15 77,900 VEHICLES SUBTOTAL 271,800 182,100 117,400 117,400 181,554 274,100 128,000 128,000 212,200 230,000 217,900 153,200 234,500 245,000 157,000 225,000 256,500 170,000 282,000 180,000 ERP-0208 Computer System 20 200,000 ERP-0212 Mobile Data Computers/Digital Cameras 7 160,000 196,800 242,000 ERP-0214 Tactical Ballistic Vests (9)5 76,512 45,000 50,000 58,000 ERP-0215 Radios-Portable & Mobile 5-7 290,000 310,000 325,000 ERP-0217 Taser Replacement 4 90,000 101,300 114,000 128,300 144,400 ERP-0218 Building Video Server 4 22,000 24,800 27,900 31,400 35,300 ERP-0220 Squad Cams 5 90,000 104,335 120,952 140,217 ERP-0222 Body Worn Camera 5 150,000 165,000 175,000 185,000 214,500 EQUIPMENT SUBTOTAL 150,000 478,512 250,000 291,100 45,000 414,335 338,700 175,000 250,000 120,952 484,700 185,000 300,000 319,917 214,500 78 REPL EQUIPMENT /VEHICLES YRS 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 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 52,000 ERP-0715 PW - Forklift 15 28,000 42,100 8,300 28,000 52,000 47,000 P.W. ENGINEERING ERP-0700 Engineering Van 10 28,900 38,800 28,900 P.W. PARKS & FORESTRY ERP-0800 1/2 Ton Truck 10 35,400 47,600 ERP-0801 4x4 3/4 Ton Truck 8 108,000 115,000 ERP-0802 3/4 Ton Utility Truck 10 48,700 65,400 ERP-0804 Log Truck (50% w/Refuse)20 81,800 128,000 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 (6 50,000 59,700 71,300 85,100 ERP-0810 Large Turf Mower (#825)10 130,000 175,000 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 50,000 117,200 10,000 80,200 76,840 108,000 175,600 295,500 162,600 206,800 127,500 173,000 50,000 260,100 65,400 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 372,000 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 415,000 ERP-0309 Skid Loader 12 50,000 59,700 71,300 ERP-0311 Sweeper 20 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 24,000 ERP-0319 Regenerative Air Sweeper 20 210,000 ERP-0320 Planer 20 18,600 ERP-321 Wheel Loader 20 308,000 VEHICLES SUBTOTAL 328,400 165,300 318,100 56,600 269,700 226,600 82,700 219,600 120,000 38,800 599,200 294,000 24,000 82,000 1,095,000 HRA ERP-0400 4x4 3/4 Ton Truck 8 41,100 52,100 66,000 ERP-0401 Copier 8 16,500 20,900 SUBTOTAL 16,500 41,100 20,900 52,100 66,000 PAVILION ERP-1000 Ice Resurfacer 12 165,000 235,200 ERP-1001 Electric Ice Edger 12 8,900 12,700 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 247,900 REFUSE ERP-0900 Refuse Truck (RAP-R)10 270,300 275,200 363,200 369,800 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 369,800 WATER ERP-0500 1./2 Ton Truck 10 36,000 54,000 ERP-0501 3/4 Ton Utility Truck 10 46,900 63,000 ERP-0502 Backhoe 20 153,700 SUBTOTAL 46,900 36,000 153,700 63,000 54,000 79 REPL EQUIPMENT /VEHICLES YRS 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 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 ERP-0560 Televising Camera and Van 12 180,000 256,600 SUBTOTAL 223,000 85,500 256,600 108,200 TOTALS 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 GENERAL FUND-VEHICLES/EQUIP 321,800 510,500 1,124,900 445,500 181,554 1,204,300 1,204,840 2,077,700 614,400 608,200 437,500 273,200 1,409,900 1,103,000 451,000 462,300 1,861,500 220,000 1,637,100 245,400 GENERAL FUND-OTHER EQUIP 223,699 399,129 887,197 479,954 1,246,775 276,189 474,141 234,647 804,746 293,143 1,148,447 436,237 590,713 442,640 1,204,269 539,265 814,787 579,743 779,161 551,701 HRA - 16,500 41,100 20,900 52,100 66,000 ARTS CENTER - 13,500 6,700 10,800 7,100 6,000 16,600 15,000 9,000 14,500 20,400 10,000 REFUSE 270,300 - 81,800 275,200 363,200 136,500 171,000 369,800 PAVILION - - 11,600 185,900 16,200 15,600 247,900 WATER - - 46,900 36,000 153,700 63,000 54,000 SEWER - 223,000 85,500 256,600 108,200 GENERAL FUND TOTAL 545,499 909,629 2,012,097 925,454 1,428,329 1,480,489 1,678,981 2,312,347 1,419,146 901,343 1,585,947 709,437 2,000,613 1,545,640 1,655,269 1,001,565 2,676,287 799,743 2,416,261 797,101 HRA TOTAL - 16,500 41,100 20,900 52,100 66,000 ARTS CENTER FUND TOTAL - 13,500 6,700 10,800 7,100 6,000 16,600 15,000 9,000 14,500 20,400 10,000 ENTERPRISE FUNDS TOTAL 270,300 223,000 81,800 11,600 275,200 318,300 36,000 16,200 363,200 290,200 171,000 272,200 432,800 162,200 247,900 TOTAL ALL FUNDS 815,799 1,162,629 2,134,997 943,754 1,714,329 1,805,889 1,720,981 2,312,347 1,451,946 922,243 2,001,247 1,014,637 2,171,613 1,826,840 2,102,569 1,184,165 2,686,287 1,047,643 2,482,261 797,101 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 505,499 869,629 1,972,097 885,454 1,388,329 1,440,489 1,638,981 2,272,347 1,379,146 861,343 1,545,947 669,437 1,960,613 1,505,640 1,615,269 961,565 2,636,287 759,743 2,376,261 757,101 20 YEAR AVERAGES:Total Average ACTIVITY CENTER ADMINISTRATION 173,024 8,700 IT 5,567,435 278,400 COMMUNITY SERVICES 138,731 6,900 FIRE EQUIPMENT 6,343,400 317,200 FIRE ADMINISTRATION 2,473,378 123,700 POLICE EQUIPMENT 3,963,654 198,200 POLICE ADMINISTRATION 4,017,716 200,900 PUBLIC WORKS ADMINISTRATION BLDG./EQUIPMENT SERVICES EQUIPMENT 177,400 8,900 ENGINEERING EQUIPMENT 67,700 3,400 PARKS/FORESTRY EQUIPMENT 1,958,740 97,900 STREET EQUIPMENT 3,920,000 196,000 GENERAL FUND VEHICLE/EQUIPMENT 16,430,894 821,500 GENERAL FUND OTHER EQUIPMENT 12,370,284 618,500 GENERAL FUND TOTAL 28,801,178 1,440,100 HRA FUND 196,600 9,800 ARTS CENTER FUND 129,600 6,500 REFUSE FUND 1,667,800 83,400 PAVILION FUND 477,200 23,900 WATER FUND 353,600 17,700 SEWER FUND 673,300 33,700 UTILITY VEHICLES/EQUIPMENT 3,498,100 174,900 32,299,278 80 EQUIPMENT INVENTORY 81 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2020 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 2019 FORD EXPLORER 55,000 107 2019 FORD EXPLORER 55,000 108 2019 FORD F150 33,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 2020 FORD UTILITY 54,000 206 2020 FORD UTILITY 54,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 2020 CHEVROLET BLAZER 54,000 214 2018 FORD EXPLORER 49,000 216 2011 FORD TAURUS 30,000 218 2013 FORD UTILITY BLUE 40,000 219 2013 FORD TAURUS 24,000 220 2017 FORD EXPLORER 50,000 221 2019 FORD EXPLORER 55,000 240 2017 FORD TRANSIT-350 67,000 299 2018 FORD F150 55,000 DWI.2015 FORD UTILITY 41,000 82 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2020 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 315 2017 FREIGHTLINER 114SD 221,700 317 2016 FREIGHTLINER M2-106 69,400 318 2019 FREIGHTLINER 114SD 235,000 320 2020 CATERPILLAR 926M 232,000 321 2012 CATERPILLAR 924K 177,500 322 2005 CATERPILLAR 938G 157,800 325 2011 BOBCAT S-650 35,100 327 2019 ELGIN PELICAN 230,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 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 705 2018 FORD F350 30,000 707 2020 FORD F250 35,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 83 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2020 UNIT #YEAR MAKE MODEL VALUE PARKS/FORESTRY DIVISION 800 2013 FORD F-150 23,700$ 801 2012 FORD F-350 24,100 804 1995 CHEVROLET CC31403 45,000 806 2016 FORD TRANSIT 350 29,700 807 2006 FORD F250 18,000 811 2006 INTERNATIONAL LOG TRUCK 45,000 812 2010 FREIGHTLINER AERIAL LIFT 130,000 813 2019 FREIGHTLINER M2-106 235,000 814 2020 FORD F350 43,000 815 2020 FORD F350 43,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 824 2020 TORO GM4000 68,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 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 84 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2020 UNIT #YEAR MAKE MODEL VALUE HRA 411 2007 CHEVROLET 2500 17,500$ WATER/SEWER 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 85