Loading...
2020 - 2024 ERP EQUIPMENT REPLACEMENT PLAN 2020-2024 DATE: October 15, 2019 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2020-2024 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2020-2024 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 citizens of Hopkins. This document was developed by the Finance Department with the assistance of all city departments. I wish to especially thank all those involved in the development of the Equipment Replacement Plan, and especially Steve Stadler, Public Works Director, Brent Johnson, Police Chief, Dale Specken, Fire Chief, Ari Lenz, Assistant City Manager, and Nick Bishop, Finance Director for their hard work and dedication. 1 2 Page City Manager's Message 1 Table of Contents 3 Introduction Background and Summary of Changes from 2017 Plan 6 Cash Flow Statements Equipment Replacement Fund 10 Five-Year Project Summaries Projects by Year 12 Department Summary 15 Projects by Department 16 Funding Source Summary 19 Projects by Funding Source 20 Equipment Requests Individual Equipment Request Details Activity Center 24 Arts Center 27 Community Services - IT 29 Fire 41 HRA 49 Pavilion 51 Police 52 Public Works 64 Refuse 81 Water/Sewer 82 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 86 Equipment Inventory 90 EQUIPMENT REPLACEMENT PLAN 2020-2024 TABLE OF CONTENTS 3 4 INTRODUCTION 5 EQUIPMENT REPLACEMENT PLAN 2020-2024 BACKGROUND AND SUMMARY OF CHANGES FROM 2019 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 2019 by 9% and will be increased in 2020 by 9%. Plans are to increase the rate going forward with increases of 9% in 2021 and 6% in 2022-2024. The majority of items purchased with ERP funds are used by departments within the General Fund which accounts for the most of the operations of the city. The fund will also implement a tax levy for 2020. The levy being proposed for 2019 is $110,000. It is planned to continue at $250,000 for 2021-2024. There have been many changes in technology and the way we operate and as a result there is more equipment in the plan; however the rate has not increased to accommodate the increase in equipment. Equipment that was purchased with grants such as digital squad cameras, laptop computers in squad cars and fire vehicles, and infrared cameras are included in the ERP but the rates have not kept up with the addition of all these items. In addition society is dictating some of the equipment under consideration. One of the items that has been under discussion in recent years was police body cameras, which are currently included in this plan. The long term viability of the fund remains questionable and will result in difficult decisions regarding equipment and operations. These issues were addressed as part of the Financial Management Plan (FMP) first completed in 2014. The FMP establishes funding mechanisms to get the fund to a constant balance of $750,000. Items that will be considered and/or implemented are rate increases, a tax levy and issuing equipment certificates. Equipment Certificates were sold for $590,000 in 2018. This will allow us to replace aging equipment and spread the payments over 10 years. The required Equipment Certificate payment will be part of the debt levy in the applicable year. Equipment certificates are also planned as a funding source in 2020. 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 2019 Plan Highlights of changes from last year’s equipment replacement plan for the years 2020-2023: CS - Activity Center: Security System Upgrade was delayed from 2020 to 2021. A/V Replacements and upgrades were delayed from 2020 to 2021. CS - Arts Center: No changes CS - IT: Financial Software Upgrade added in 2021 for $307,468. (Project has been cancelled) Community Services: No changes Fire: Hose replacement project added in 2023 for $38,000. Quick Attack Pumper/Rescue advanced from 2023 to 2022 and costs increased from $314,500 to $525,000. HRA No changes. Police: Building Video Server for $20,000 in 2020 was deleted. Video storage will be done on the cloud in 2020. . Public Works: Building/Equipment Services 4x4 ¾ Ton Truck with Service Body was added in 2020 for $35,000. Parks/Forestry Turf Mower added for $25,300 in 2022. Streets/Traffic Wheel Loader was advanced from 2025 to 2020 for $170,000 1 Ton Boom Truck was advanced from 2029 to 2023 for $136,400. Refuse No changes Sewer No Changes Water No Changes 7 8 CASH FLOW STATEMENT 9 City of Hopkins Equipment Replacement Fund (602) Rate Change 10%9%9%9%6%6%6% ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2018 2019 2020 2021 2022 2023 2024 Working Capital Begin Year (24,461) (114,895) (9,347) 19,438 72,477 179,852 346,870 Revenues from charges 487,900 531,811 579,674 631,845 669,755 709,941 752,537 Tax Levy 230,000 110,000 250,000 250,000 250,000 250,000 Transfer in Debt Service Fund - - - - - Interest earnings - - - 97 362 899 3,000 Other revenues (sale of assets)(36,670) 35,000 35,000 35,000 35,000 35,000 35,000 Enterpirse contribution to software upgrade - - - - - Equipment Certificates (Bonds)592,000 - 170,000 200,000 - 1,600,000 Interfund Loan - - - - - Total Revenues 1,043,230 796,811 894,674 1,116,942 955,118 2,595,840 1,040,537 Expenditures (excludes Leases & Depr.) 259,742 33,873 34,889 35,936 37,014 38,124 39,268 Fire Truck Financing Pymnts (2009-2018)52,295 - - - - Capital Outlay - Equipment 821,627 657,390 831,000 1,027,967 810,729 2,390,697 698,354 Repayment of Interfund Loan - Total Expenses 1,133,664 691,263 865,889 1,063,903 847,743 2,428,821 737,622 Working Capital Ending Balance (114,895) (9,347) 19,438 72,477 179,852 346,870 649,785 (Unrestricted Net Position) 10 FIVE-YEAR PROJECT SUMMARIES 11 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY YEAR 2020 2024thru Project Name Department Project #Priority Project Cost 2020 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 31,500Comm Svcs - IT 01-ERP-0014Distribution Network Switches n/a 50,000Comm Svcs - IT 01-ERP-0015Backup Server n/a 66,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 22,000Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 21,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0109Extrication Tool (2)n/a 29,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 107,400Police 01-ERP-0219PD - Video Data Server n/a 10,000Police 01-ERP-0712PW - 4x4 3/4 Ton Truck with Service Body n/a 35,000Public Works: Bldg/Equip Serv 01-ERP-08014x4 3/4Ton Trucks (2)n/a 85,200Public Works: Parks/Forestry 01-ERP-0808Riding Mowers (2)n/a 13,900Public Works: Parks/Forestry 01-ERP-0810Large Turf Mower n/a 96,000Public Works: Parks/Forestry 01-ERP-0321Wheel Loader 1 170,000Public Works: Streets/Traffic 791,000Total for 2020 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-0005Financial Software - Various Depts.n/a 307,468Comm 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-0305Single Axle Dump Truck (2)n/a 225,000Public Works: Streets/Traffic 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 270,300Refuse 1,298,267Total 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 Wednesday, October 9, 2019 12 Project Name Department Project #Priority Project Cost 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-0109Extrication Tool (2)n/a 30,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-0804Log Truck n/a 163,600Public Works: Parks/Forestry 01-ERP-0808Riding Mowers (2)n/a 25,300Public Works: Parks/Forestry 01-ERP-03031 Ton Dump Truck (2)n/a 53,400Public Works: Streets/Traffic 01-ERP-0309Skid Loader (2)n/a 50,000Public Works: Streets/Traffic 01-ERP-0555Generator (2)n/a 43,000Sewer 948,529Total for 2022 2023 01-ERP-0038Activity Center Kitchen Storage 5 12,000Comm Svcs - Activity Center 01-ERP-0003CH - Network Server n/a 26,250Comm Svcs - IT 01-ERP-0004Telephone System n/a 89,600Comm Svcs - IT 01-ERP-0006Computers n/a 36,465Comm Svcs - IT 01-ERP-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 525,000Fire 01-ERP-0109Extrication Tool (2)n/a 32,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 15,400Fire 01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 368,000Fire 01-ERP-0126Fire - Fire Helmets n/a 16,000Fire 01-ERP-0127Fire - Lucus Device n/a 18,000Fire 01-ERP-0128Fire - Hose Replacement 2 38,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 80,000Police 01-ERP-0218Building Video Server n/a 17,000Police 01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry 01-ERP-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 01-ERP-0308Front End Loaders (2)n/a 268,600Public Works: Streets/Traffic 2,462,397Total 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-0129Fire - EOC Upgrade n/a 12,000Fire 01-ERP-1003Pavilion - Floor Scrubber n/a 11,600Pavilion 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police Wednesday, October 9, 2019 13 Project Name Department Project #Priority Project Cost 01-ERP-0212Squad Car Camera Systems/ Body Worn Camera n/a 105,000Police 01-ERP-0220Squad Computers n/a 90,000Police 01-ERP-0700Engineering Van n/a 28,900Public Works: Engineering 01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry 01-ERP-03014X4 3/4 Ton Truck with Plow n/a 38,500Public Works: Streets/Traffic 01-ERP-03031 Ton Dump Truck (2)n/a 49,500Public Works: Streets/Traffic 01-ERP-0318Asphalt Hot Mix Heating Box - Trailer n/a 22,100Public Works: Streets/Traffic 01-ERP-05504x4 3/4 Ton Truck n/a 40,300Sewer 761,954Total for 2024 GRAND TOTAL 6,262,147 Wednesday, October 9, 2019 14 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2020 2024thru Total20202021202220232024Department Comm Svcs - Activity Center 111,62482,624 17,000 12,000 Comm Svcs - Arts Center 20,20013,500 6,700 Comm Svcs - IT 1,473,811244,500 448,543 204,129 346,685 229,954 Fire 1,083,40029,000 30,000 1,012,400 12,000 HRA 57,60016,500 41,100 Pavilion 11,60011,600 Police 1,614,612117,400 271,800 332,100 580,912 312,400 Public Works: Bldg/Equip Serv 35,00035,000 Public Works: Engineering 28,90028,900 Public Works: Parks/Forestry 429,400195,100 188,900 35,400 10,000 Public Works: Streets/Traffic 1,042,400170,000 225,000 103,400 433,900 110,100 Refuse 270,300270,300 Sewer 83,30043,000 40,300 791,000 1,298,267 948,529 2,462,397 761,954 6,262,147TOTAL Wednesday, October 9, 201915 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2020 2024thru Total20202021202220232024DepartmentProject #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 20,20013,500 6,700Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0003 122,28722,000 22,000 25,000 26,250 27,037CH - Network Server n/a 01-ERP-0004 89,60089,600Telephone System n/a 01-ERP-0005 307,468307,468Financial Software - Various Depts.n/a 01-ERP-0006 173,32831,500 33,075 34,729 36,465 37,559Computersn/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 50,00050,000Distribution Network Switches n/a 01-ERP-0015 138,12066,000 72,120Backup Server n/a 01-ERP-0017 188,32022,000 33,000 44,000 44,000 45,320IT - Office 365 n/a 01-ERP-0020 50,00010,000 10,000 10,000 10,000 10,000IT - Patching Automation Software 1 01-ERP-0022 189,00021,000 21,000 42,000 42,000 63,000IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0211 122,28822,000 22,000 25,000 26,250 27,038PD - Network Server n/a 1,473,811244,500 448,543 204,129 346,685 229,954Comm Svcs - IT Total Fire 01-ERP-0105 525,000525,000Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0109 91,00029,000 30,000 32,000Extrication Tool (2)n/a 01-ERP-0112 15,40015,400Thermal Imaging Camera (2)n/a 01-ERP-0125 368,000368,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0128 38,00038,000Fire - Hose Replacement 2 01-ERP-0129 12,00012,000Fire - EOC Upgrade n/a 1,083,40029,000 30,000 1,012,400 12,000Fire Total 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 Wednesday, October 9, 201916 Total20202021202220232024DepartmentProject #Priority Pavilion 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 11,60011,600Pavilion Total Police 01-ERP-0200 613,300107,400 161,100 110,000 117,400 117,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 57,00057,000Sergeant's Vehicle n/a 01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 72,10072,100PSO - Utility 4x4 n/a 01-ERP-0212 105,000105,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 80,00080,000Taser Replacement n/a 01-ERP-0218 17,00017,000Building Video Server n/a 01-ERP-0219 10,00010,000PD - Video Data Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0221 150,000150,000Records Management System n/a 1,614,612117,400 271,800 332,100 580,912 312,400Police Total Public Works: Bldg/Equip Serv 01-ERP-0712 35,00035,000PW - 4x4 3/4 Ton Truck with Service Body n/a 35,00035,000Public Works: Bldg/Equip Serv Total Public Works: Engineering 01-ERP-0700 28,90028,900Engineering Van n/a 28,90028,900Public Works: Engineering Total Public Works: Parks/Forestry 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0808 39,20013,900 25,300Riding Mowers (2)n/a 01-ERP-0810 96,00096,000Large Turf Mower n/a 01-ERP-0814 10,00010,000Trailer Flatbed n/a 429,400195,100 188,900 35,400 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-0301 38,50038,5004X4 3/4 Ton Truck 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 01-ERP-0318 22,10022,100Asphalt Hot Mix Heating Box - Trailer n/a 01-ERP-0321 170,000170,000Wheel Loader 1 1,042,400170,000 225,000 103,400 433,900 110,100Public Works: Streets/Traffic Total Refuse 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a Wednesday, October 9, 201917 Total20202021202220232024DepartmentProject #Priority 270,300270,300Refuse Total Sewer 01-ERP-0550 40,30040,3004x4 3/4 Ton Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 83,30043,000 40,300Sewer Total GRAND TOTAL 6,262,147791,000 1,298,267 948,529 2,462,397 761,954 Wednesday, October 9, 201918 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2020 thru 2024 TotalSource20202021202220232024 AC - Arts Center Fund 20,20013,500 6,700 Equipment Replacement Fund 5,718,747791,000 1,027,967 810,729 2,390,697 698,354 HRA - Housing and Redevelopment Authority 57,60016,500 41,100 PA - Pavilion Fund 11,60011,600 PKG - Parking Fund 5,0005,000 RF - Refuse Fund 352,100270,300 81,800 SF - Sanitary Sewer Fund 90,10043,000 6,800 40,300 WF - Water Fund 6,8006,800 791,000 1,298,267 965,529 2,445,397 761,954 6,262,147GRAND TOTAL Wednesday, October 9, 2019 19 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2020 2024thru TotalSourceProject #Priority 2020 2021 2022 2023 2024 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 20,20013,500 6,700AC - Arts Center Fund Total Equipment Replacement Fund 01-ERP-0003 122,28722,000 22,000 25,000 26,250 27,037CH - Network Server n/a 01-ERP-0004 76,00076,000Telephone System n/a 01-ERP-0005 307,468307,468Financial Software - Various Depts.n/a 01-ERP-0006 173,32831,500 33,075 34,729 36,465 37,559Computersn/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 50,00050,000Distribution Network Switches n/a 01-ERP-0015 138,12066,000 72,120Backup Server n/a 01-ERP-0017 188,32022,000 33,000 44,000 44,000 45,320IT - Office 365 n/a 01-ERP-0020 50,00010,000 10,000 10,000 10,000 10,000IT - Patching Automation Software 1 01-ERP-0022 189,00021,000 21,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-0105 525,000525,000Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0109 91,00029,000 30,000 32,000Extrication Tool (2)n/a 01-ERP-0112 15,40015,400Thermal Imaging Camera (2)n/a 01-ERP-0125 368,000368,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0128 38,00038,000Fire - Hose Replacement 2 01-ERP-0129 12,00012,000Fire - EOC Upgrade n/a 01-ERP-0200 613,300107,400 161,100 110,000 117,400 117,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 57,00057,000Sergeant's Vehicle n/a 01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 72,10072,100PSO - Utility 4x4 n/a 01-ERP-0211 122,28822,000 22,000 25,000 26,250 27,038PD - Network Server n/a 01-ERP-0212 100,000100,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 80,00080,000Taser Replacement n/a 01-ERP-0218 17,00017,000Building Video Server n/a 01-ERP-0219 10,00010,000PD - Video Data 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 01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a 01-ERP-0303 102,90053,400 49,5001 Ton Dump Truck (2)n/a Wednesday, October 9, 2019 20 TotalSourceProject #Priority 2020 2021 2022 2023 2024 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-0318 22,10022,100Asphalt Hot Mix Heating Box - Trailer n/a 01-ERP-0321 170,000170,000Wheel Loader 1 01-ERP-0700 28,90028,900Engineering Van n/a 01-ERP-0712 35,00035,000PW - 4x4 3/4 Ton Truck with Service Body n/a 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0808 39,20013,900 25,300Riding Mowers (2)n/a 01-ERP-0810 96,00096,000Large Turf Mower n/a 01-ERP-0814 10,00010,000Trailer Flatbed n/a 5,718,747791,000 1,027,967 810,729 2,390,697 698,354Equipment 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 5,0005,000Squad Car Camera Systems/ Body Worn Camera n/a 5,0005,000PKG - Parking Fund Total RF - Refuse Fund 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a 352,100270,300 81,800RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0550 40,30040,3004x4 3/4 Ton Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 90,10043,000 6,800 40,300SF - Sanitary Sewer Fund Total WF - Water Fund 01-ERP-0004 6,8006,800Telephone System n/a 6,8006,800WF - Water Fund Total Wednesday, October 9, 2019 21 TotalSourceProject #Priority 2020 2021 2022 2023 2024 6,262,147791,000 1,298,267 965,529 2,445,397 761,954GRAND TOTAL Wednesday, October 9, 2019 22 EQUIPMENT REQUESTS 23 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 20,00020,000Equipment 20,000 20,000Total Total2020 2021 2022 2023 2024Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Wednesday, October 9, 2019 24 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 29,00017,000 12,000Equipment 17,000 12,000 29,000Total Total2020 2021 2022 2023 2024Funding Sources 29,00017,000 12,000Equipment Replacement Fund 17,000 12,000 29,000Total Wednesday, October 9, 2019 25 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 62,62462,624Equipment 62,624 62,624Total Total2020 2021 2022 2023 2024Funding Sources 62,62462,624Equipment Replacement Fund 62,624 62,624Total Wednesday, October 9, 2019 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 13,50013,500Equipment 13,500 13,500Total Total2020 2021 2022 2023 2024Funding Sources 13,50013,500AC - Arts Center Fund 13,500 13,500Total Wednesday, October 9, 2019 27 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 6,7006,700Equipment 6,700 6,700Total Total2020 2021 2022 2023 2024Funding Sources 6,7006,700AC - Arts Center Fund 6,700 6,700Total Wednesday, October 9, 2019 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 122,28722,000 22,000 25,000 26,250 27,037Equipment 22,000 22,000 25,000 26,250 27,037 122,287Total Total2020 2021 2022 2023 2024Funding Sources 122,28722,000 22,000 25,000 26,250 27,037Equipment Replacement Fund 22,000 22,000 25,000 26,250 27,037 122,287Total Wednesday, October 9, 2019 29 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 89,60089,600Equipment 89,600 89,600Total Total2020 2021 2022 2023 2024Funding Sources 76,00076,000Equipment Replacement Fund 6,8006,800SF - Sanitary Sewer Fund 6,8006,800WF - Water Fund 89,600 89,600Total Wednesday, October 9, 2019 30 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2020 2024 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,565,687 Total2020 2021 2022 2023 2024Expenditures 307,468307,468Equipment 307,468 307,468Total Total2020 2021 2022 2023 2024Funding Sources 307,468307,468Equipment Replacement Fund 307,468 307,468Total Wednesday, October 9, 2019 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 173,32831,500 33,075 34,729 36,465 37,559Equipment 31,500 33,075 34,729 36,465 37,559 173,328Total Total2020 2021 2022 2023 2024Funding Sources 173,32831,500 33,075 34,729 36,465 37,559Equipment Replacement Fund 31,500 33,075 34,729 36,465 37,559 173,328Total Wednesday, October 9, 2019 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 23,40023,400Equipment 23,400 23,400Total Total2020 2021 2022 2023 2024Funding Sources 23,40023,400Equipment Replacement Fund 23,400 23,400Total Wednesday, October 9, 2019 33 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 20,00020,000Equipment 20,000 20,000Total Total2020 2021 2022 2023 2024Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Wednesday, October 9, 2019 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 50,00050,000Equipment 50,000 50,000Total Total2020 2021 2022 2023 2024Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Wednesday, October 9, 2019 35 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 138,12066,000 72,120Equipment 66,000 72,120 138,120Total Total2020 2021 2022 2023 2024Funding Sources 138,12066,000 72,120Equipment Replacement Fund 66,000 72,120 138,120Total Wednesday, October 9, 2019 36 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 188,32022,000 33,000 44,000 44,000 45,320Equipment 22,000 33,000 44,000 44,000 45,320 188,320Total Total2020 2021 2022 2023 2024Funding Sources 188,32022,000 33,000 44,000 44,000 45,320Equipment Replacement Fund 22,000 33,000 44,000 44,000 45,320 188,320Total Wednesday, October 9, 2019 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 50,00010,000 10,000 10,000 10,000 10,000Equipment 10,000 10,000 10,000 10,000 10,000 50,000Total Total2020 2021 2022 2023 2024Funding Sources 50,00010,000 10,000 10,000 10,000 10,000Equipment Replacement Fund 10,000 10,000 10,000 10,000 10,000 50,000Total Wednesday, October 9, 2019 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 189,00021,000 21,000 42,000 42,000 63,000Equipment 21,000 21,000 42,000 42,000 63,000 189,000Total Total2020 2021 2022 2023 2024Funding Sources 189,00021,000 21,000 42,000 42,000 63,000Equipment Replacement Fund 21,000 21,000 42,000 42,000 63,000 189,000Total Wednesday, October 9, 2019 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 122,28822,000 22,000 25,000 26,250 27,038Equipment 22,000 22,000 25,000 26,250 27,038 122,288Total Total2020 2021 2022 2023 2024Funding Sources 122,28822,000 22,000 25,000 26,250 27,038Equipment Replacement Fund 22,000 22,000 25,000 26,250 27,038 122,288Total Wednesday, October 9, 2019 40 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2020 2024 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,230,557 Total2020 2021 2022 2023 2024Expenditures 525,000525,000Equipment 525,000 525,000Total Total2020 2021 2022 2023 2024Funding Sources 525,000525,000Equipment Replacement Fund 525,000 525,000Total Wednesday, October 9, 2019 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2020 2024 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 (2)Category Equipment Type Equipment Future Total Project Cost:$210,800 Total2020 2021 2022 2023 2024Expenditures 91,00029,000 30,000 32,000Equipment 29,000 30,000 32,000 91,000Total Total2020 2021 2022 2023 2024Funding Sources 91,00029,000 30,000 32,000Equipment Replacement Fund 29,000 30,000 32,000 91,000Total Wednesday, October 9, 2019 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2020 2024 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,105 Total2020 2021 2022 2023 2024Expenditures 15,40015,400Equipment 15,400 15,400Total Total2020 2021 2022 2023 2024Funding Sources 15,40015,400Equipment Replacement Fund 15,400 15,400Total Wednesday, October 9, 2019 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2020 2024 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. 2019 - 340,000 FD 2019 - 28,000 PW Useful Life 5-7 yearsProject Name Fire Radios - Portable and Mobile Devices Category Equipment Type Equipment Future Total Project Cost:$2,355,889 Total2020 2021 2022 2023 2024Expenditures 368,000368,000Equipment 368,000 368,000Total Total2020 2021 2022 2023 2024Funding Sources 368,000368,000Equipment Replacement Fund 368,000 368,000Total Wednesday, October 9, 2019 44 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2020 2024 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 2023. 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 Total2020 2021 2022 2023 2024Expenditures 16,00016,000Equipment 16,000 16,000Total Total2020 2021 2022 2023 2024Funding Sources 16,00016,000Equipment Replacement Fund 16,000 16,000Total Wednesday, October 9, 2019 45 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 18,00018,000Equipment 18,000 18,000Total Total2020 2021 2022 2023 2024Funding Sources 18,00018,000Equipment Replacement Fund 18,000 18,000Total Wednesday, October 9, 2019 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2020 2024 thru Department Fire Description Replacement of Firefighteing Hose Project #01-ERP-0128 Priority 2 Very Important Justification Per OSHA and NFPA all hose needs to be replaced every 10 years. We currently replace our hose as it wears out. This will put us on a complete replacement every 10 years to comply with the standard Budget Impact/Other Useful Life 10 yearsProject Name Fire - Hose Replacement Category Equipment Type Equipment Future Total Project Cost:$157,698 Total2020 2021 2022 2023 2024Expenditures 38,00038,000Equipment 38,000 38,000Total Total2020 2021 2022 2023 2024Funding Sources 38,00038,000Equipment Replacement Fund 38,000 38,000Total Wednesday, October 9, 2019 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 12,00012,000Equipment 12,000 12,000Total Total2020 2021 2022 2023 2024Funding Sources 12,00012,000Equipment Replacement Fund 12,000 12,000Total Wednesday, October 9, 2019 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Unassigned 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 41,10041,100Vehicles 41,100 41,100Total Total2020 2021 2022 2023 2024Funding Sources 41,10041,100HRA - Housing and Redevelopment Authority 41,100 41,100Total Wednesday, October 9, 2019 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 16,50016,500Equipment 16,500 16,500Total Total2020 2021 2022 2023 2024Funding Sources 16,50016,500HRA - Housing and Redevelopment Authority 16,500 16,500Total Wednesday, October 9, 2019 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 11,60011,600Equipment 11,600 11,600Total Total2020 2021 2022 2023 2024Funding Sources 11,60011,600PA - Pavilion Fund 11,600 11,600Total Wednesday, October 9, 2019 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 613,300107,400 161,100 110,000 117,400 117,400Vehicles 107,400 161,100 110,000 117,400 117,400 613,300Total Total2020 2021 2022 2023 2024Funding Sources 613,300107,400 161,100 110,000 117,400 117,400Equipment Replacement Fund 107,400 161,100 110,000 117,400 117,400 613,300Total Wednesday, October 9, 2019 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 57,00057,000Vehicles 57,000 57,000Total Total2020 2021 2022 2023 2024Funding Sources 57,00057,000Equipment Replacement Fund 57,000 57,000Total Wednesday, October 9, 2019 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 53,70053,700Vehicles 53,700 53,700Total Total2020 2021 2022 2023 2024Funding Sources 53,70053,700Equipment Replacement Fund 53,700 53,700Total Wednesday, October 9, 2019 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 72,10072,100Vehicles 72,100 72,100Total Total2020 2021 2022 2023 2024Funding Sources 72,10072,100Equipment Replacement Fund 72,100 72,100Total Wednesday, October 9, 2019 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2020 2024 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 - 12 Squad car cameras and 20 body cameras Squad cameras 6,000/each. Body cameras 1,200/each. Cameras to be purchased in 2019. Useful Life 5 yearsProject Name Squad Car Camera Systems/ Body Worn Camera Category Equipment Type Equipment Future Total Project Cost:$811,921 Total2020 2021 2022 2023 2024Expenditures 105,000105,000Equipment 105,000 105,000Total Total2020 2021 2022 2023 2024Funding Sources 100,000100,000Equipment Replacement Fund 5,0005,000PKG - Parking Fund 105,000 105,000Total Wednesday, October 9, 2019 56 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 76,51276,512Equipment 76,512 76,512Total Total2020 2021 2022 2023 2024Funding Sources 76,51276,512Equipment Replacement Fund 76,512 76,512Total Wednesday, October 9, 2019 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 290,000290,000Equipment 290,000 290,000Total Total2020 2021 2022 2023 2024Funding Sources 290,000290,000Equipment Replacement Fund 290,000 290,000Total Wednesday, October 9, 2019 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Captain 2020 2024 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 each Taser in 2018 = $2166.00 (+ shipping) Useful Life 4 yearsProject Name Taser Replacement Category Equipment Type Equipment Future Total Project Cost:$711,905 Total2020 2021 2022 2023 2024Expenditures 80,00080,000Equipment 80,000 80,000Total Total2020 2021 2022 2023 2024Funding Sources 80,00080,000Equipment Replacement Fund 80,000 80,000Total Wednesday, October 9, 2019 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2020 2024 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:$88,000 Total2020 2021 2022 2023 2024Expenditures 17,00017,000Equipment 17,000 17,000Total Total2020 2021 2022 2023 2024Funding Sources 17,00017,000Equipment Replacement Fund 17,000 17,000Total Wednesday, October 9, 2019 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2020 2024 thru Department Police Description The police department video server is used to store evidentiary video and audio data. Rules pertaining to criminal procedure, and laws regarding data privacy and retention place requirements on the Police Department to store and manage the data for varying lengths of time. The current data storage solution was designed for squad car video only and is near capacity. The storage solution is also not currently designed to efficiently back up data and is potentially subject to data loss from environmental factors such as drive failure and unsuited fire suppression systems Project #01-ERP-0219 Priority n/a Justification The video server will be replaced with a cloud based storage solution after 2020. Budget Impact/Other Cost of yearly maintenance for video data storgae server: $10,000.00/year Server no longer maintained after 2020. Useful Life 5 yearsProject Name PD - Video Data Server Category Equipment Type Equipment Future Total Project Cost:$135,000 Total2020 2021 2022 2023 2024Expenditures 10,00010,000Equipment 10,000 10,000Total Total2020 2021 2022 2023 2024Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Wednesday, October 9, 2019 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 90,00090,000Equipment 90,000 90,000Total Total2020 2021 2022 2023 2024Funding Sources 90,00090,000Equipment Replacement Fund 90,000 90,000Total Wednesday, October 9, 2019 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 150,000150,000Equipment 150,000 150,000Total Total2020 2021 2022 2023 2024Funding Sources 150,000150,000Equipment Replacement Fund 150,000 150,000Total Wednesday, October 9, 2019 63 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2020 2024 thru Department Public Works: Bldg/Equip Ser Description Current vehicle is used to trasport building maintenenace technician, haul his equipment and tools for the maintenance of the City's multiple facilities. This vehicle also hauls cleaning and paper supplies to the different sites. Current Vehicle: 2006 Ford F-250 Unit #704 Project #01-ERP-0712 Priority n/a Justification Technician needs to have reliable transportation to maintain City's facilities, and have a source to supply the different facilities with their operational needs. Budget Impact/Other Useful Life 12 yearsProject Name PW - 4x4 3/4 Ton Truck with Service Body Category Equipment Type Equipment Future Total Project Cost:$85,000 Total2020 2021 2022 2023 2024Expenditures 35,00035,000Vehicles 35,000 35,000Total Total2020 2021 2022 2023 2024Funding Sources 35,00035,000Equipment Replacement Fund 35,000 35,000Total Wednesday, October 9, 2019 64 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Public Works: Engineering Description Van used by Engineering Department for survey equipment and on job site work. Cost to paint the old Police Dept. Chevy Tahoe Current vehicle: 2000 Chevrolet Suburban (#700) Project #01-ERP-0700 Priority n/a Justification Transportation to and from job site, hauling of surveying and traffic counting equipment. Budget Impact/Other Variance from 20 year plan - Replace with surplus Police Tahoe in 2014. Leave $2,000 for modifications.. Estimate salvage/resale value on replaced item: $2,500 Useful Life 10 yearsProject Name Engineering Van Category Vehicles Type Equipment Future Total Project Cost:$85,700 Total2020 2021 2022 2023 2024Expenditures 28,90028,900Vehicles 28,900 28,900Total Total2020 2021 2022 2023 2024Funding Sources 28,90028,900Equipment Replacement Fund 28,900 28,900Total Wednesday, October 9, 2019 65 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 35,40035,400Vehicles 35,400 35,400Total Total2020 2021 2022 2023 2024Funding Sources 35,40035,400Equipment Replacement Fund 35,400 35,400Total Wednesday, October 9, 2019 66 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Public Works: Parks/Forestry Description Trucks used by Parks Division of Public Works. Current vehicles: 2012 Ford F350 4X4 (#801) & 2012 Ford F350 4X4 (#802) Project #01-ERP-0801 Priority n/a Justification Snow plowing, hauling, transportation. Units are heavily used. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Useful Life 8 yearsProject Name 4x4 3/4Ton Trucks (2)Category Vehicles Type Equipment Future Total Project Cost:$623,918 Total2020 2021 2022 2023 2024Expenditures 85,20085,200Vehicles 85,200 85,200Total Total2020 2021 2022 2023 2024Funding Sources 85,20085,200Equipment Replacement Fund 85,200 85,200Total Wednesday, October 9, 2019 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 163,600163,600Vehicles 163,600 163,600Total Total2020 2021 2022 2023 2024Funding Sources 81,80081,800Equipment Replacement Fund 81,80081,800RF - Refuse Fund 163,600 163,600Total Wednesday, October 9, 2019 68 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 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 n/a Justification Mowing city parks and right of ways. Move replacement of #826 to 2020 - Ran 10 years past useful life Move replacement of #823 to 2022 Budget Impact/Other Variance from 20 year plan Estimate salvage/resale value on replaced item: $600 each Moved useful life from 8 year to 6 Useful Life 6 yearsProject Name Riding Mowers (2)Category Equipment Type Equipment Future Total Project Cost:$299,230 Total2020 2021 2022 2023 2024Expenditures 39,20013,900 25,300Equipment 13,900 25,300 39,200Total Total2020 2021 2022 2023 2024Funding Sources 39,20013,900 25,300Equipment Replacement Fund 13,900 25,300 39,200Total Wednesday, October 9, 2019 69 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Public Works: Parks/Forestry Description Large turf mower (11' cutting width) used by Parks Division of Public Works. Current equipment: 2010 Toro Groundmaster (#825) Project #01-ERP-0810 Priority n/a Justification Required to efficiently mow large parks. Budget Impact/Other Variance from 20 year plan - move from 2011 to 2010 due to poor condition of existing mower. Estimated useful life reduced from 10 to 8 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 8 yearsProject Name Large Turf Mower Category Equipment Type Equipment Future Total Project Cost:$486,659 Total2020 2021 2022 2023 2024Expenditures 96,00096,000Equipment 96,000 96,000Total Total2020 2021 2022 2023 2024Funding Sources 96,00096,000Equipment Replacement Fund 96,000 96,000Total Wednesday, October 9, 2019 70 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 10,00010,000Equipment 10,000 10,000Total Total2020 2021 2022 2023 2024Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Wednesday, October 9, 2019 71 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 28,90028,900Vehicles 28,900 28,900Total Total2020 2021 2022 2023 2024Funding Sources 28,90028,900Equipment Replacement Fund 28,900 28,900Total Wednesday, October 9, 2019 72 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Public Works: Streets/Traffic Description 3/4 ton pickup used by Street Division of Public Works for heavy loads and pulling trailers. Current vehicle: 2018 Ford F350 (#302) Project #01-ERP-0301 Priority n/a Justification Light hauling, pulling trailers, transportation to and from job sites. Budget Impact/Other Estimate salvage/resale value on replaced item: $1,500 Useful Life 8 yearsProject Name 4X4 3/4 Ton Truck with Plow Category Vehicles Type Equipment Future Total Project Cost:$203,519 Total2020 2021 2022 2023 2024Expenditures 38,50038,500Vehicles 38,500 38,500Total Total2020 2021 2022 2023 2024Funding Sources 38,50038,500Equipment Replacement Fund 38,500 38,500Total Wednesday, October 9, 2019 73 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Public Works: Streets/Traffic Description Truck is used in the Street Division of Public Works. Current vehicles: 2000 Ford F450 (#304) & 2011 Ford F350 (#308) Project #01-ERP-0303 Priority n/a Justification Vehicle used by various departments for street and park maintenance and light hauling. Budget Impact/Other Variance from 20 year plan - move back from 2009 to 2010. Estimated useful life reduced from 12 to 8 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 8 yearsProject Name 1 Ton Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$281,600 Total2020 2021 2022 2023 2024Expenditures 102,90053,400 49,500Vehicles 53,400 49,500 102,900Total Total2020 2021 2022 2023 2024Funding Sources 102,90053,400 49,500Equipment Replacement Fund 53,400 49,500 102,900Total Wednesday, October 9, 2019 74 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 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 17 yearsProject Name 1 Ton Traffic Boom Truck Category Vehicles Type Equipment Future Total Project Cost:$218,900 Total2020 2021 2022 2023 2024Expenditures 136,400136,400Vehicles 136,400 136,400Total Total2020 2021 2022 2023 2024Funding Sources 136,400136,400Equipment Replacement Fund 136,400 136,400Total Wednesday, October 9, 2019 75 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 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 Total2020 2021 2022 2023 2024Expenditures 225,000225,000Vehicles 225,000 225,000Total Total2020 2021 2022 2023 2024Funding Sources 225,000225,000Equipment Replacement Fund 225,000 225,000Total Wednesday, October 9, 2019 76 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Public Works: Streets/Traffic Description Current equipment: 1991 Caterpillar 928E Loader (#320) & 2005 Caterpillar 938G (#322) Project #01-ERP-0308 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $ Useful Life 15-18 yearsProject Name Front End Loaders (2)Category Equipment Type Equipment Future Total Project Cost:$848,600 Total2020 2021 2022 2023 2024Expenditures 268,600268,600Equipment 268,600 268,600Total Total2020 2021 2022 2023 2024Funding Sources 268,600268,600Equipment Replacement Fund 268,600 268,600Total Wednesday, October 9, 2019 77 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Public Works: Streets/Traffic Description Loading trucks, landscape work, snow removal, material handling. Current equipment: 2004 Bobcat S-1851R Skid Loader (#324) & 2011 Bobcat S650 Skid-Steer Loader (#325) Project #01-ERP-0309 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - move back from 2010 to 2011. Estimate salvage/resale value on replaced item: $ Useful life reduced from 12 years to 10. Useful Life 10 yearsProject Name Skid Loader (2)Category Equipment Type Equipment Future Total Project Cost:$258,900 Total2020 2021 2022 2023 2024Expenditures 50,00050,000Equipment 50,000 50,000Total Total2020 2021 2022 2023 2024Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Wednesday, October 9, 2019 78 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Public Works: Streets/Traffic Description A trailer that hauls up to 2.5 tons of hot asphalt and heats the mix to keep it workable. Project #01-ERP-0318 Priority n/a Justification Current asphalt hot mix heating box insert sits in the back of a truck and is too small, 1 ton capacity. Sits too high to be handled easily. The trailer will hold more mix, reducing the trips to the asphalt plant, and will work better ergonomically. Budget Impact/Other Variance from 20 year plan - New item. 2016 - Upgrading from mounted unit to trailer Estimate salvage/resale value on replaced item: $-0-. Useful Life 12 yearsProject Name Asphalt Hot Mix Heating Box - Trailer Category Equipment Type Equipment Future Total Project Cost:$84,109 Total2020 2021 2022 2023 2024Expenditures 22,10022,100Equipment 22,100 22,100Total Total2020 2021 2022 2023 2024Funding Sources 22,10022,100Equipment Replacement Fund 22,100 22,100Total Wednesday, October 9, 2019 79 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Facilities Director 2020 2024 thru Department Public Works: Streets/Traffic Description Wheel loader used for snow plowing with V-blade all alleys in the city and loading trucks. Project #01-ERP-0321 Priority 1 Urgent Justification Both pieces of equipment has surpassed useful life exptectancies. Estimates for trade in were done by Ziegler Caterpillar Equiment. Current loader is 30 years old (1990). Current trade in value is $19,150. The city has a 31 year old Grader (1989 Unit #326) that is used for a backup snowplow. Current trade in value is $30,415, We would like to utilize trading in the two 30+ year old equipment for 1 new loader. Actual full price of equiment is approx. $218,000. Budget Impact/Other Useful Life 20 yearsProject Name Wheel Loader Category Equipment Type Equipment Future Total Project Cost:$170,000 Total2020 2021 2022 2023 2024Expenditures 170,000170,000Vehicles 170,000 170,000Total Total2020 2021 2022 2023 2024Funding Sources 170,000170,000Equipment Replacement Fund 170,000 170,000Total Wednesday, October 9, 2019 80 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Refuse Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 2005 Peterbilt Rapid Rail (#901) & 2011 Freightliner Rapid Rail (#900) Project #01-ERP-0900 Priority n/a Justification Residential waste pick up. Budget Impact/Other Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Useful Life 10 yearsProject Name Refuse Truck (RAP-R) (2)Category Vehicles Type Equipment Future Total Project Cost:$1,462,600 Total2020 2021 2022 2023 2024Expenditures 270,300270,300Vehicles 270,300 270,300Total Total2020 2021 2022 2023 2024Funding Sources 270,300270,300RF - Refuse Fund 270,300 270,300Total Wednesday, October 9, 2019 81 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Sewer Description Truck used by Water/Sewer Division of Public Works. Current vehicle: 2004 Chevrolet Pickup (#501) Project #01-ERP-0550 Priority n/a Justification Snow plowing, light hauling, pulling trailers, general purpose transportation. Budget Impact/Other Variance from 20 year plan. Reduce amount to $30,000 to reflect actual. Estimate salvage/resale value on replaced item: Useful Life 10 yearsProject Name 4x4 3/4 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$151,100 Total2020 2021 2022 2023 2024Expenditures 40,30040,300Vehicles 40,300 40,300Total Total2020 2021 2022 2023 2024Funding Sources 40,30040,300SF - Sanitary Sewer Fund 40,300 40,300Total Wednesday, October 9, 2019 82 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2020 2024 thru Department Sewer Description Portable generator used by Water/Sewer Divisions of Public Works. Current equipment: 1997 Kohler 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 Total2020 2021 2022 2023 2024Expenditures 43,00043,000Equipment 43,000 43,000Total Total2020 2021 2022 2023 2024Funding Sources 43,00043,000SF - Sanitary Sewer Fund 43,000 43,000Total Wednesday, October 9, 2019 83 84 TWENTY-YEAR REPLACEMENT SCHEDULE 85 10/15/2019 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average:1,264,800$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 ACTIVITY CENTER ERP-0032 Sound System 15 13,700 ERP-0035 Floor Scrubber 10 6,700 9,000 ERP-0036 Sound System Replacement 25 ERP-0037 Security System Upgrade 15-18 20,000 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 ERP-1107 Theater Projection Screen 10 6,700 9,000 ERP-1109 Floor Scrubber 10 10,800 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 10,000 COMMUNITY SERVICES ERP-0010 Election Booths 20 6,500 ERP-0051 Exterior Security Camera System 15 65,000 EQUIPMENT SUBTOTAL 6,500 65,000 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 525,000 705,000 ERP-0106 Aerial Truck 20 1,572,000 VEHICLES SUBTOTAL 525,000 722,400 1,000,000 1,572,000 705,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 29,000 30,000 32,000 36,900 40,300 ERP-0112 Thermal Imaging Camera (2)10 15,400 17,400 20,700 ERP-0113 Emergency Preparedness Siren 20 38,500 ERP-0114 Floor Scrubber 12 20,300 ERP-0125 Radios-Portable & Mobile 5-7 368,000 431,498 514,700 ERP-0126 Helmets 10 16,000 22,000 ERP-0127 Lucus Device 5 18,000 20,000 24,000 30,000 ERP-0128 Hose Replacement 20 38,000 ERP-0129 EOC Upgrade 20 12,000 EQUIPMENT SUBTOTAL 29,000 30,000 487,400 12,000 250,000 38,500 37,700 20,000 468,398 54,400 40,300 66,700 850,700 30,000 IT ERP-0003 City Hall - Network Upgrade 1 22,000 22,000 25,000 26,250 27,038 27,849 28,684 29,545 30,431 31,344 32,284 33,253 34,250 35,278 36,336 37,426 38,549 39,705 40,897 42,124 ERP-0004 Phone System 8 89,600 110,700 140,000 ERP-0005 Financial Software 7 307,468 ERP-0006 Computers 3-5 31,500 33,075 34,729 36,465 37,559 39,437 41,409 43,479 45,653 47,936 50,333 52,849 55,492 58,266 61,180 64,239 67,451 70,823 74,364 78,082 ERP-0009 Network Infrastructure Upgrade 15 23,400 ERP-0012 Core Network Switch 6 20,000 24,000 27,000 ERP-0014 Distribution Network Switches 5 50,000 57,000 65,000 75,000 ERP-0015 Backup Server 3 66,000 72,120 74,000 78,000 82,000 87,000 ERP-0017 Office 365 1 22,000 33,000 44,000 44,000 45,320 47,000 49,000 51,000 54,000 57,000 60,000 63,000 66,000 69,000 72,000 75,000 78,000 80,000 85,000 88,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,000 10,000 10,000 10,000 10,000 50,000 10,000 10,000 10,000 10,000 60,000 10,000 10,000 10,000 10,000 10,000 ERP-0022 Windows 10 Enterprise Upgrade 1 21,000 21,000 42,000 42,000 63,000 64,890 66,837 68,842 70,907 73,034 75,225 77,482 79,807 82,201 84,667 87,207 89,823 92,518 95,293 98,152 ERP-0211 Police - Network Server (3)3 22,000 22,000 25,000 26,250 27,038 27,849 28,684 29,545 30,431 31,344 32,284 33,253 34,250 35,278 36,336 37,426 38,549 39,705 40,897 42,124 EQUIPMENT SUBTOTAL 244,500 448,543 204,129 346,685 229,954 274,024 298,614 232,410 241,422 419,158 349,126 380,537 279,799 372,023 407,519 386,298 436,372 332,752 346,451 529,981 POLICE ERP-0200 Squad 3 107,400 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 ERP-0201 Sergeant Vehicle #209 4 57,000 57,000 60,000 72,000 80,000 ERP-0202 Parking Vehicle #211 10 53,700 60,000 65,000 ERP-0203 PSO Utility 4x4 #212 6 72,100 86,100 90,000 92,000 107,000 ERP-0205 SWAT Vehicle #240 15 77,900 VEHICLES SUBTOTAL 107,400 271,800 182,100 117,400 117,400 174,400 274,100 128,000 128,000 200,000 230,000 217,900 153,200 225,200 245,000 157,000 225,000 245,000 170,000 282,000 ERP-0208 Computer System 20 200,000 ERP-0212 Mobile Data Computers/Digital Cameras 7 105,000 148,500 150,000 ERP-0214 Tactical Ballistic Vests (9)5 76,512 45,000 50,000 ERP-0215 Radios-Portable & Mobile 5-7 290,000 310,000 325,000 ERP-0217 Taser Replacement 4 80,000 35,000 38,000 42,000 45,000 ERP-0218 Building Video Server 4 17,000 17,000 17,000 19,000 21,500 ERP-0219 PD - Squad Video Server 5 10,000 11,593 13,439 15,580 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 EQUIPMENT SUBTOTAL 10,000 150,000 463,512 195,000 11,593 35,000 182,000 45,000 562,835 51,439 17,000 175,000 250,000 312,952 359,580 185,000 45,000 161,717 86 REPL EQUIPMENT /VEHICLES YRS 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 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 35,000 52,000 ERP-0715 PW - Forklift 15 28,000 35,000 42,100 8,300 28,000 52,000 47,000 P.W. ENGINEERING ERP-0700 Engineering Van 10 28,900 38,800 P.W. PARKS & FORESTRY ERP-0800 1/2 Ton Truck 10 35,400 47,600 ERP-0801 4x4 3/4 Ton Truck 8 85,200 108,000 115,000 ERP-0802 3/4 Ton Utility Truck 10 48,700 ERP-0804 Log Truck (50% w/Refuse)15 81,800 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 (8 13,900 25,300 17,500 32,100 21,000 35,000 ERP-0810 Large Turf Mower (#825)10 96,000 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 195,100 107,100 35,400 10,000 80,200 34,640 108,000 207,700 295,500 91,300 227,800 162,500 173,000 50,000 175,000 P.W. STREETS/TRAFFIC ERP-0300 4x4 3/4 Ton Truck/Plow 10 28,900 38,800 ERP-0301 4x4 3/4 Ton Truck/Plow 8 38,500 48,800 ERP-0302 4x2 1 Ton Dump Truck 12 77,800 ERP-0303 1 Ton Dump Truck 12 53,400 49,500 76,100 ERP-0304 1 Ton Boom Truck 17 136,400 ERP-0305 Single Axle Dump Truck 17 225,000 210,600 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-0310 Grader 20 167,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-0318 Asphalt Hot Mix Heating Box 12 22,100 31,500 ERP-0319 Regenerative Air Sweeper 20 210,000 ERP-0320 Planer 20 18,600 ERP-321 Wheel Loader 20 170,000 308,000 VEHICLES SUBTOTAL 170,000 225,000 103,400 433,900 110,100 167,300 18,100 269,700 226,600 82,700 219,600 168,800 38,800 550,400 294,000 55,500 82,000 787,000 308,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 363,200 ERP-0901 Refuse Truck (Rear-L)10 136,500 ERP-0803 Swap Loader 20 171,000 ERP-0804 Log Truck (50% w/Forestry)20 81,800 SUBTOTAL 270,300 81,800 363,200 136,500 171,000 87 REPL EQUIPMENT /VEHICLES YRS 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 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 ERP-0503 Air Compressor 20 SUBTOTAL 46,900 36,000 153,700 63,000 54,000 SEWER ERP-0550 4x4 3/4 Ton Truck 10 40,300 54,200 ERP-0551 3/4 Ton Utility Truck 10 45,200 54,000 ERP-0552 Jet Vactor 20 ERP-0555 Generator 25 43,000 SUBTOTAL 43,000 40,300 45,200 54,200 54,000 TOTALS 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 GENERAL FUND-VEHICLES/EQUIP 507,500 496,800 392,600 1,111,700 266,400 341,700 1,136,900 1,162,640 2,077,700 634,300 608,200 437,500 322,000 1,060,300 1,114,000 451,000 490,000 1,850,000 1,007,000 765,000 GENERAL FUND-OTHER EQUIP 283,500 531,167 401,129 1,309,597 436,954 535,617 378,814 452,110 306,422 1,458,691 420,765 451,937 495,099 716,723 720,471 1,661,577 630,372 364,752 421,451 691,699 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 10,000 REFUSE - 270,300 81,800 363,200 136,500 171,000 PAVILION - - - 11,600 185,900 16,200 15,600 247,900 WATER - - - 46,900 36,000 153,700 63,000 54,000 SEWER - - 43,000 40,300 45,200 54,200 54,000 GENERAL FUND TOTAL 791,000 1,027,967 793,729 2,421,297 703,354 877,317 1,515,714 1,614,750 2,384,122 2,092,991 1,028,965 889,437 817,099 1,777,023 1,834,471 2,112,577 1,120,372 2,214,752 1,428,451 1,456,699 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 10,000 ENTERPRISE FUNDS TOTAL - 270,300 124,800 51,900 278,000 36,000 16,200 363,200 290,200 171,000 69,800 63,000 108,000 247,900 TOTAL ALL FUNDS 791,000 1,298,267 948,529 2,462,397 761,954 888,117 1,800,814 1,656,750 2,384,122 2,125,791 1,049,865 1,304,737 1,122,299 1,948,023 1,913,271 2,175,577 1,228,372 2,224,752 1,676,351 1,522,699 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 NET GENERAL FUND 751,000 987,967 753,729 2,381,297 663,354 837,317 1,475,714 1,574,750 2,344,122 2,052,991 988,965 849,437 777,099 1,737,023 1,794,471 2,072,577 1,080,372 2,174,752 1,388,451 20 YEAR AVERAGES:Total Average ACTIVITY CENTER ADMINISTRATION 173,024 8,700 x IT 6,760,296 338,000 x COMMUNITY SERVICES 71,500 3,600 x FIRE EQUIPMENT 5,874,400 293,700 x FIRE ADMINISTRATION 2,415,098 120,800 x POLICE EQUIPMENT 3,850,900 192,500 x POLICE ADMINISTRATION 3,212,628 160,600 x PUBLIC WORKS ADMINISTRATION BLDG./EQUIPMENT SERVICES EQUIPMENT 212,400 10,600 x ENGINEERING EQUIPMENT 67,700 3,400 x PARKS/FORESTRY EQUIPMENT 1,953,240 97,700 x STREET EQUIPMENT 4,310,900 215,500 x GENERAL FUND VEHICLE/EQUIPMENT 16,269,540 813,500 GENERAL FUND OTHER EQUIPMENT 12,632,545 631,600 GENERAL FUND TOTAL 28,902,085 1,445,100 HRA FUND 196,600 9,800 ARTS CENTER FUND 94,700 4,700 x REFUSE FUND 1,022,800 51,100 x PAVILION FUND 477,200 23,900 WATER FUND 353,600 17,700 x SEWER FUND 236,700 11,800 x UTILITY VEHICLES/EQUIPMENT 2,381,600 119,100 31,283,685 88 EQUIPMENT INVENTORY 89 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2019 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 2016 FORD UTILITY 45,000 206 2016 FORD UTILITY 45,000 207 2017 FORD UTILITY 49,000 208 2017 FORD UTILITY 49,000 209 2018 FORD UTILITY 49,000 211 2016 FORD UTILITY 34,000 212 2018 FORD F150 55,000 213 2016 FORD TAURUS 25,000 214 2018 FORD EXPLORER 49,000 216 2011 FORD TAURUS 30,000 218 2013 FORD UTILITY BLUE 40,000 219 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 90 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2019 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 1991 CATERPILLAR 928E 90,000 321 2012 CATERPILLAR 924K 177,500 322 2005 CATERPILLAR 938G 157,800 325 2011 BOBCAT S-650 35,100 326 1989 CATERPILLAR 140-G 82,000 327 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 704 2006 FORD F250 18,000 705 2018 FORD F350 30,000 708 2016 FORD TRANSIT 350 29,700 712 2015 FORD UTILITY 35,000 713 2014 FORD UTILITY 30,000 750 2018 CLARK GTS25-FORKLIFT 25,000 91 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2019 UNIT #YEAR MAKE MODEL VALUE PARKS/FORESTRY DIVISION 800 2013 FORD F-150 23,700$ 801 2012 FORD F-350 24,100 803 2004 FORD F-350 17,500 804 1995 CHEVROLET CC31403 45,000 806 2016 FORD TRANSIT 350 29,700 811 2006 INTERNATIONAL LOG TRUCK 45,000 812 2010 FREIGHTLINER AERIAL LIFT 130,000 813 2019 FREIGHTLINER M2-106 235,000 816 2014 BOBCAT 5610 50,900 817 2018 BOBCAT 5600 63,300 818 2017 TORO WORKMAN HDX 13,000 820 2004 TORO WORKMAN 3200 15,000 822 2014 TORO MDE 18,000 823 2006 JACOBSON TURFCAT 600 10,000 825 2010 TORO 4100-D 56,500 826 2004 TORO Z587L 8,900 828 2001 DEWEZE ATM-72 21,000 829 2016 TORO 3280-D 10,000 831 2016 RAYCO RG45X 3,400 832 1997 VERMEER SC502 STUMP CTR 15,400 834 2013 VERMEER BRUSH CHIPPER 29,800 835 2016 BOBCAT S70 55,000 843 2007 CARR TRAILER 2,500 844 2010 FELLING FT-6T 6,000 845 1997 REMACKEL DT-D7-E 3,500 846 2001 DRESSEN 8110 2,000 848 2017 LOAD TRAIL TILT DECK 5,400 92 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2019 UNIT #YEAR MAKE MODEL VALUE HRA 411 2007 CHEVROLET 2500 17,500$ WATER/SEWER 501 2004 CHEVROLET 2500HD 16,000$ 502 2017 FORD F-150 SUPERCAB 28,000 503 2015 FORD F-350 24,000 508 2016 FORD TRANSIT CONNECT 25,000 509 2016 FORD F-350 65,000 510 2016 FORD F-350 30,000 531 2017 FREIGHTLINER 114SD 425,400 533 2012 CATERPILLAR 420-EH2 87,700 535 1992 KOHLER GEN/TRL 10,000 537 2010 CATERPILLAR C15 144,300 PAVILION 802 2012 FORD F-350 20,000$ 808 2014 ZAMBONI 552 126,000 809 2002 OLYMPIA MILLINEUM 87,800 REFUSE 900 2011 FREIGHTLINER M2-106 201,109$ 902 2015 FREIGHTLINER M2-106 232,500 903 2015 PETERBILT REAR LOADER 155,000 93