The URL can be used to link to this page

VII.3. 2021-2025 Equipment Replacement Plan (ERP); Bishop November 17, 2020 Council Report 2020-086 2021-2025 EQUIPMENT REPLACEMENT PLAN (ERP) Proposed Action Staff recommends adoption of the following motion: Move to adopt the 2021-2025 Equipment Replacement Plan. Overview The equipment replacement plan is a detailed summary of the next five years of a twenty-year replacement schedule, for equipment of the City of Hopkins. General and Special Revenue (except Arts Center) fund equipment items are placed in the Equipment Replacement Fund budget which derives its revenues from service charges to the General and Special Revenue funds, tax levy, equipment sales and interest earnings. The Arts Center and Enterprise fund equipment in the plan is placed in the individual fund budgets, in the year in which the equipment is to be purchased. Approval of the 2021-2025 allows staff to begin preparation for their purchase. Items that fall under the Minnesota Statutes Uniform Bidding/Contracting Laws will require further approval by the council before their purchase. Staff is recommending adoption of the plan. Primary Issues to Consider • Does adoption of the ERP mean projects will be implemented? Adoption of the motion will authorize staff to prepare for purchases scheduled in 2021. Years 2022- 2025 serve as a long-range plan and purchases are not authorized by approving the plan. Appropriate notifications would also be made for those projects that have funding implications. • Are funds available for all projects? The plan outlines funding implications if all projects are implemented. Necessary funding changes have been anticipated as part of this plan, and are recommended therein Supporting Information • Overview of Equipment Replacement Fund • 2020-2024 Equipment Replacement Plan ______________________________________ Nick Bishop, CPA Finance Director Financial Impact: $ as provided in plan Budgeted: Y/N X N Source: Various Related Documents (CIP, ERP, etc.): __ERP_________ Notes: ____________________ 4 Equipment Replacement Fund This fund accounts for the purchase of machinery and equipment. The two sources of revenue are a tax levy and equipment charges. Equipment charges are billed to various City departments and are over 99% in the General Fund. Equipment replacement has also been accomplished through the issuance of equipment certificates (debt). In 2021, the Equipment Replacement Fund has projected revenues of $847,138 and projected expenditures of $580,398. The projected revenues include a tax levy amount of $200,000 which has not been finalized. The projected expenditures include projects for the Activity Center, Fire Department, Police Department, Public Works Department and Information Technology projects across the City. The fund is projected to increase its net position by $266,740 and end 2021 with a net position of $559,915 2021 2022 Beginning Fund Balance 293,175 559,915 Revenues & Other Financing Sources Tax Levy 200,000 250,000 Equipment Charges 631,845 669,755 Sale of Equipment 15,000 35,000 Interest Earnings 293 359 Total Revenue & Other Financing Sources 847,138 955,114 Expenditures & Other Financing Uses Current Expenditures 34,899 35,248 Capital Projects Community Services - Activity Center 82,624 17,000 Community Services - Information Technology 141,075 204,129 Fire Equipment - 28,000 Police Vehicles 271,800 332,100 Public Works: Parks/Forestry 50,000 - Public Works: Streets/Traffic - 328,400 Total Expenditures and Other Financing Sources 580,398 944,877 Increase (Decrease) in Fund Balance 266,740 10,237 Projected Ending Fund Balance 559,915 570,152 Equipment Replacement Fund - Projected Cash Flows City of Hopkins Equipment Replacement Plan 2021 – 2025 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 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 Project Name Department Project #Priority Project Cost 1,714,329Total for 2025 GRAND TOTAL 6,771,508 Wednesday, November 11, 2020 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, 2020 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, 2020 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, 2020 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 2021 –2025 Equipment Replacement Plan November 17, 2020 Overview 5 year plan, updated annually Equipment Replacement Fund included in Financial Management Plan Overview Arts Center, HRA/Dow Towers, and Enterprise Funds are included Directly Funded Overview Funding Sources (Not Finalized) Based on a 2021 Levy of $17,788,384, a $258,700 or 1.48% increase User Department Charges $631,845 in 2021, a 9% increase o 99.88% in General Fund o 0.06% in Economic Development and Communications Funds $200,000 Tax Levy in 2021 Overview Funding Sources Equipment Certificates –None in 2021 No eligible equipment in 2021 $225,000 issued in 2020 $278,400 of eligible equipment in 2022 o Useful life of at least 10 years o $225,000 -Single Axle Dump Truck o $53,400 -1 Ton Dump Truck Proposed 2021 Projects 2021 projects total $545,499 Activity Center -$82,624 Information Technology -$141,075 Forestry -$50,000 Police -$271,800 Proposed 2021 Decreases 2021 decreases total $482,468 Project removed or delayed -$532,468 Project added or advanced -$50,000 Proposed 2021 Decreases Information Technology Financial Software -$307,468 (Cancelled) Public Works: Streets/Traffic Single Axle Dump Truck -$225,000 (Delayed to 2022) Proposed 2021 Increases Public Works: Parks -$50,000 Replace two riding mowers Ran 8 and 10 years past useful lives Proposed 2021 Ending balance in Equipment Replacement Fund of $559,915