The URL can be used to link to this page

2022-2026 Equipment Replacement PlanEQUIPMENT REPLACEMENT PLAN 2022-2026 DATE: December 14, 2021 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2022-2026 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2022-2026 Equipment Replacement Plan. This five-year planning document represents the combined efforts of city staff and the City Council. The Equipment Replacement Plan is a five-year forecast of equipment replacement needs in the City of Hopkins. It is intended to alert the Council and residents of equipment replacement needs that are needed to maintain the efficiency of city services and the safety of city staff. The first year of the plan becomes the adopted budget, however the equipment is again re-evaluated before final approval is given for the purchase. The remaining four years represents estimated replacement needs and the related funding. The Equipment Replacement Plan does not include proposed capital projects. A document relating specifically to capital project needs has been developed into a separate document. The Equipment Replacement Plan is intended to serve as a planning tool and is therefore structured to present a meaningful, long-range perspective of the city’s equipment needs over the next 20 years. At the same time sufficient details on individual pieces of equipment scheduled for replacement is provided to enable those who review the information to make informed decisions of the city’s equipment needs over the next several years. Please use the information provided to assist in the understanding of the city’s equipment needs as they relate to the delivery of service to the residents of Hopkins. This document was developed by the Finance Department with the assistance of all city departments. I wish to especially thank all those involved in the development of the Equipment Replacement Plan, and especially Nate Stanley, 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 2021 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 31 Fire 45 HRA 55 Pavilion 56 Police 60 Public Works 72 Refuse 85 Water/Sewer 86 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 92 Equipment Inventory 96 EQUIPMENT REPLACEMENT PLAN 2022-2026 TABLE OF CONTENTS 3 4 INTRODUCTION 5 EQUIPMENT REPLACEMENT PLAN 2022-2026 BACKGROUND AND SUMMARY OF CHANGES FROM 2021 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 2022 by 6% and will be increased by 6% in 2023 through 2026. The majority of items purchased with ERP funds are used by departments within the General Fund which accounts for the most of the operations of the city. The fund will continue to rely on a tax levy in 2022. There is not tax levy proposed for 2021. It is planned to be $250,000 for 2022- 2026. There have been many changes in technology and the way we operate and as a result there is more equipment in the plan; the funding rate has recently increased to accommodate the higher demand in equipment. In addition, society is dictating some of the equipment under consideration. A few items that have been under discussion in recent years was the increase need in information technology security to help thwart virutal attacks from malicious entities as well as additional police protective equipment to maintain the safety of both our police personnel and community at all times. 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 $225,000 in 2020 and are planned to be sold in 2022 for the replacement of a fire engine and dump truck. This financing source allows the City to replace aging equipment and spread the payments over 10 years. The required Equipment Certificate payment will be part of the debt levy in the applicable year. Each year staff re-evaluates the equipment needs and adjusts the schedule accordingly. Changes to the plan are reflected in the document. Refurbishments, extended life expectancy and closer cost estimates of replacements have been incorporated into the plan. The equipment replacement charges in the general fund represent approximately 3% of total general fund expenditures. 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 2021-2025 Plan Highlights of changes from last year’s equipment replacement plan for the years 2022-2026: CS - Activity Center: Replace Sanitizer/Heat Booster was added in 2022 for $20,000 CS - Arts Center: No changes CS - IT: Network Infrastructure Update was removed for $23,400 IT – Sandbox Security Appliance was added for $45,000 Community Services: No changes Fire: Fire Engine/Rescue in 2023 estimated costs increased from $725,000 to $771,000 and also moved to 2022. Emergency Operations Center Upgrade was removed from 2022 $12,000. Fire Station Alerting System was moved up from 2025 to 2023 and increased in estimated costs from $55,000 to $75,000. HRA No changes Police: Records Management System was delayed from 2022 to 2024. Police Equipment was added to 2022 and 2025 at $25,000 for each year. Public Works: Building/Equipment Services No Changes Engineering No Changes Parks/Forestry No Changes Streets/Traffic No Changes Refuse No changes Sewer/Water No Changes 7 8 CASH FLOW STATEMENT 9 City of Hopkins Equipment Replacement Fund (602) Rate Change 9%6%6%6%6%6% PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2021 2022 2023 2024 2025 2026 Working Capital Begin Year 499,556 784,628 845,691 457,710 393,415 253,715 Revenues from charges 631,845 669,755 709,941.30 752,538 797,690 845,551 Tax Levy 200,000 - 250,000 250,000 250,000 250,000 Federal Grant - - - - - Interest earnings 500 785 1,175 2,289 1,967 1,269 Other revenues (sale of assets)33,125 15,000 35,000 35,000 40,000 40,000 Equipment Certificates (Bonds)- 996,000 - - - - Capital Lease - -- - 250,000 - Total Revenues 865,470 1,681,540 996,116 1,039,826 1,339,657 1,136,820 Expenditures (excludes Leases & Depr.) 34,899 35,248 35,600 36,668 37,768 38,901 Capital Outlay - Equipment 545,499 1,585,229 1,348,497 1,067,454 1,441,589 818,670 Total Expenses 580,398 1,620,477 1,384,097 1,104,122 1,479,357 857,571 Working Capital Ending Balance 784,628 845,691 457,710 393,415 253,715 532,964 (Unrestricted Net Position) 10 FIVE-YEAR PROJECT SUMMARIES 11 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY YEAR 2022 2026thru Project Name Department Project #Priority Project Cost 2022 01-ERP-0038Activity Center - Kitchen Storage 5 17,000Comm Svcs - Activity Center 01-ERP-0042Activity Center - Replace Sanitizer/Heat Booster 2 20,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 0Comm 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-0024IT - Sandbox Security Appliance n/a 45,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 25,000Comm Svcs - IT 01-ERP-0105Fire Engine/Rescue (2)n/a 771,000Fire 01-ERP-0126Fire - Fire Helmets n/a 16,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-0227Police Equipment n/a 25,000Police 01-ERP-03031 Ton Dump Truck (2)n/a 53,400Public Works: Streets/Traffic 01-ERP-0305Single Axle Dump Truck (2)n/a 225,000Public Works: Streets/Traffic 01-ERP-0309Skid Loader (2)n/a 50,000Public Works: Streets/Traffic 01-ERP-0555Generator (2)n/a 43,000Sewer 01-ERP-0560Sewer Televising Camera and Van 1 180,000Sewer 1,838,229Total 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-0109Extrication Tool (1)n/a 32,000Fire 01-ERP-0127Fire - Lucus Device n/a 18,000Fire 01-ERP-0131Fire - Station Alerting System n/a 75,000Fire 01-ERP-04004x4 3/4 Ton Truck n/a 41,100HRA 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 76,512Police 01-ERP-0215Police - Portable Radios n/a 290,000Police 01-ERP-0217Taser Replacement n/a 90,000Police 01-ERP-0218Building Video Server n/a 22,000Police 01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry Wednesday, December 8, 2021 12 Project Name Department Project #Priority Project Cost 01-ERP-0804Log Truck n/a 163,600Public Works: Parks/Forestry 01-ERP-03004x4 1/2 Ton Pickup with Plow n/a 28,900Public Works: Streets/Traffic 01-ERP-03041 Ton Traffic Boom Truck n/a 136,400Public Works: Streets/Traffic 1,484,997Total for 2023 2024 01-ERP-1107Art Center Theater Projection Screen 2 6,700Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 27,037Comm Svcs - IT 01-ERP-0006Computers n/a 37,559Comm Svcs - IT 01-ERP-0012Core Network Switch n/a 20,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 45,320Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 63,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 27,038Comm Svcs - IT 01-ERP-1003Pavilion - Floor Scrubber n/a 11,600Pavilion 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0212Squad Car Camera Systems/ Body Worn Camera n/a 160,000Police 01-ERP-0220Squad Computers n/a 90,000Police 01-ERP-0221Records Management System n/a 150,000Police 01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry 01-ERP-03031 Ton Dump Truck (2)n/a 49,500Public Works: Streets/Traffic 01-ERP-0308Front End Loaders (2)n/a 268,600Public Works: Streets/Traffic 1,093,754Total for 2024 2025 01-ERP-1109Art Center Floor Scrubber n/a 10,800Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 27,849Comm Svcs - IT 01-ERP-0005Financial Software - Various Depts.n/a 315,000Comm Svcs - IT 01-ERP-0006Computers n/a 38,686Comm Svcs - IT 01-ERP-0014Distribution Network Switches n/a 57,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 46,680Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,300Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 43,260Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 27,849Comm Svcs - IT 01-ERP-0052Electronic Inspections Processing 2 16,231Community Services 01-ERP-0108Self Contained Breathing Apparatus (SCBA) (45)n/a 250,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 16,180Fire 01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 386,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0201Sergeant's Vehicle n/a 64,154Police 01-ERP-0227Police Equipment n/a 25,000Police 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 275,200Refuse 1,727,589Total for 2025 2026 01-ERP-0035Activity Center - Floor Scrubber n/a 6,700Comm Svcs - Activity Center 01-ERP-1102Art Center Kitchen Catering Equipment n/a 7,100Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 28,684Comm Svcs - IT 01-ERP-0006Computers n/a 39,847Comm Svcs - IT 01-ERP-0015Backup Server n/a 78,808Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 48,080Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,609Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 44,558Comm Svcs - IT 01-ERP-0024IT - Sandbox Security Appliance n/a 45,000Comm Svcs - IT Wednesday, December 8, 2021 13 Project Name Department Project #Priority Project Cost 01-ERP-0211PD - Network Server n/a 28,684Comm Svcs - IT 01-ERP-0113Emergency Preparedness Sirens n/a 38,500Fire 01-ERP-1000Pavilion Ice Resurfacer n/a 165,000Pavilion 01-ERP-1001Pavilion - Electric Ice Edger n/a 8,900Pavilion 01-ERP-1002Pavilion Arena Scoreboard n/a 12,000Pavilion 01-ERP-0200Marked Patrol Vehicles (7)n/a 128,000Police 01-ERP-0202PSO / Parking Enforcement Vehicle n/a 60,000Police 01-ERP-0203PSO - Utility 4x4 n/a 86,100Police 01-ERP-0218Building Video Server n/a 17,000Police 01-ERP-07104X4 3/4 Ton Truck n/a 42,100Public Works: Bldg/Equip Serv 01-ERP-0808Riding Mowers (2)1 17,700Public Works: Parks/Forestry 01-ERP-0816Toolcat n/a 80,200Public Works: Parks/Forestry 01-ERP-0317Sign Machine (Traffic)n/a 18,100Public Works: Streets/Traffic 01-ERP-05513/4 Ton Utility Truck n/a 45,200Sewer 01-ERP-05013/4 Ton Utility Truck n/a 46,900Water 1,103,770Total for 2026 GRAND TOTAL 7,248,339 Wednesday, December 8, 2021 14 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2022 2026thru Total20222023202420252026Department Comm Svcs - Activity Center 55,70037,000 12,000 6,700 Comm Svcs - Arts Center 38,10013,500 6,700 10,800 7,100 Comm Svcs - IT 1,693,262225,729 346,685 229,954 566,624 324,270 Community Services 16,23116,231 Fire 1,602,680787,000 125,000 652,180 38,500 HRA 57,60016,500 41,100 Pavilion 197,50011,600 185,900 Police 1,818,066207,100 595,912 517,400 206,554 291,100 Public Works: Bldg/Equip Serv 42,10042,100 Public Works: Parks/Forestry 306,900199,000 10,000 97,900 Public Works: Streets/Traffic 829,900328,400 165,300 318,100 18,100 Refuse 275,200275,200 Sewer 268,200223,000 45,200 Water 46,90046,900 1,838,229 1,484,997 1,093,754 1,727,589 1,103,770 7,248,339TOTAL Wednesday, December 8, 202115 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2022 2026thru Total20222023202420252026DepartmentProject #Priority Comm Svcs - Activity Center 01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a 01-ERP-0038 29,00017,000 12,000Activity Center - Kitchen Storage 5 01-ERP-0042 20,00020,000Activity Center - Replace Sanitizer/Heat Booster 2 55,70037,000 12,000 6,700Comm Svcs - Activity Center Total Comm Svcs - Arts Center 01-ERP-1102 7,1007,100Art Center Kitchen Catering Equipment n/a 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 38,10013,500 6,700 10,800 7,100Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0003 134,82025,000 26,250 27,037 27,849 28,684CH - Network Server n/a 01-ERP-0004 89,60089,600Telephone System n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 187,28634,729 36,465 37,559 38,686 39,847Computersn/a 01-ERP-0009 00Network Infrastructure Upgrade n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 01-ERP-0015 150,92872,120 78,808Backup Server n/a 01-ERP-0017 228,08044,000 44,000 45,320 46,680 48,080IT - Office 365 n/a 01-ERP-0020 50,90910,000 10,000 10,000 10,300 10,609IT - Patching Automation Software 1 01-ERP-0022 234,81842,000 42,000 63,000 43,260 44,558IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0024 90,00045,000 45,000IT - Sandbox Security Appliance n/a 01-ERP-0211 134,82125,000 26,250 27,038 27,849 28,684PD - Network Server n/a 1,693,262225,729 346,685 229,954 566,624 324,270Comm Svcs - IT Total Community Services 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 16,23116,231Community Services Total Fire 01-ERP-0105 771,000771,000Fire Engine/Rescue (2)n/a 01-ERP-0108 250,000250,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0109 32,00032,000Extrication Tool (1)n/a 01-ERP-0112 16,18016,180Thermal Imaging Camera (2)n/a 01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a 01-ERP-0125 386,000386,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0131 75,00075,000Fire - Station Alerting System n/a Wednesday, December 8, 202116 Total20222023202420252026DepartmentProject #Priority 1,602,680787,000 125,000 652,180 38,500Fire 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 Pavilion 01-ERP-1000 165,000165,000Pavilion Ice Resurfacer n/a 01-ERP-1001 8,9008,900Pavilion - Electric Ice Edger n/a 01-ERP-1002 12,00012,000Pavilion Arena Scoreboard n/a 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 197,50011,600 185,900Pavilion Total Police 01-ERP-0200 590,200110,000 117,400 117,400 117,400 128,000Marked Patrol Vehicles (7)n/a 01-ERP-0201 64,15464,154Sergeant's Vehicle n/a 01-ERP-0202 60,00060,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 158,20072,100 86,100PSO - Utility 4x4 n/a 01-ERP-0212 160,000160,000Squad Car Camera Systems/ Body Worn Camera n/a 01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 90,00090,000Taser Replacement n/a 01-ERP-0218 39,00022,000 17,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0221 150,000150,000Records Management System n/a 01-ERP-0227 50,00025,000 25,000Police Equipment n/a 1,818,066207,100 595,912 517,400 206,554 291,100Police Total Public Works: Bldg/Equip Serv 01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a 42,10042,100Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0808 17,70017,700Riding Mowers (2)1 01-ERP-0814 10,00010,000Trailer Flatbed n/a 01-ERP-0816 80,20080,200Toolcatn/a 306,900199,000 10,000 97,900Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0303 102,90053,400 49,5001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a 01-ERP-0308 268,600268,600Front End Loaders (2)n/a 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a 829,900328,400 165,300 318,100 18,100Public Works: Streets/Traffic Total Wednesday, December 8, 202117 Total20222023202420252026DepartmentProject #Priority Refuse 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a 275,200275,200Refuse Total Sewer 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 01-ERP-0560 180,000180,000Sewer Televising Camera and Van 1 268,200223,000 45,200Sewer Total Water 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 46,90046,900Water Total GRAND TOTAL 7,248,3391,838,229 1,484,997 1,093,754 1,727,589 1,103,770 Wednesday, December 8, 202118 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2022 thru 2026 TotalSource20222023202420252026 AC - Arts Center Fund 38,10013,500 6,700 10,800 7,100 Equipment Replacement Fund 6,261,4391,585,229 1,348,497 1,067,454 1,441,589 818,670 HRA - Housing and Redevelopment Authority 57,60016,500 41,100 PA - Pavilion Fund 197,50011,600 185,900 PKG - Parking Fund 8,0008,000 RF - Refuse Fund 357,00081,800 275,200 SF - Sanitary Sewer Fund 275,000223,000 6,800 45,200 WF - Water Fund 53,7006,800 46,900 1,838,229 1,484,997 1,093,754 1,727,589 1,103,770 7,248,339GRAND TOTAL Wednesday, December 8, 2021 19 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2022 2026thru TotalSourceProject #Priority 2022 2023 2024 2025 2026 AC - Arts Center Fund 01-ERP-1102 7,1007,100Art Center Kitchen Catering Equipment n/a 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 38,10013,500 6,700 10,800 7,100AC - Arts Center Fund Total Equipment Replacement Fund 01-ERP-0003 134,82025,000 26,250 27,037 27,849 28,684CH - Network Server n/a 01-ERP-0004 76,00076,000Telephone System n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 187,28634,729 36,465 37,559 38,686 39,847Computersn/a 01-ERP-0009 00Network Infrastructure Upgrade n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 01-ERP-0015 150,92872,120 78,808Backup Server n/a 01-ERP-0017 228,08044,000 44,000 45,320 46,680 48,080IT - Office 365 n/a 01-ERP-0020 50,90910,000 10,000 10,000 10,300 10,609IT - Patching Automation Software 1 01-ERP-0022 234,81842,000 42,000 63,000 43,260 44,558IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0024 90,00045,000 45,000IT - Sandbox Security Appliance n/a 01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a 01-ERP-0038 29,00017,000 12,000Activity Center - Kitchen Storage 5 01-ERP-0042 20,00020,000Activity Center - Replace Sanitizer/Heat Booster 2 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 01-ERP-0105 771,000771,000Fire Engine/Rescue (2)n/a 01-ERP-0108 250,000250,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0109 32,00032,000Extrication Tool (1)n/a 01-ERP-0112 16,18016,180Thermal Imaging Camera (2)n/a 01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a 01-ERP-0125 386,000386,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0131 75,00075,000Fire - Station Alerting System n/a 01-ERP-0200 590,200110,000 117,400 117,400 117,400 128,000Marked Patrol Vehicles (7)n/a 01-ERP-0201 64,15464,154Sergeant's Vehicle n/a 01-ERP-0202 60,00060,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 158,20072,100 86,100PSO - Utility 4x4 n/a 01-ERP-0211 134,82125,000 26,250 27,038 27,849 28,684PD - Network Server n/a 01-ERP-0212 152,000152,000Squad Car Camera Systems/ Body Worn Camera n/a 01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 90,00090,000Taser Replacement n/a 01-ERP-0218 39,00022,000 17,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a Wednesday, December 8, 2021 20 TotalSourceProject #Priority 2022 2023 2024 2025 2026 01-ERP-0221 150,000150,000Records Management System n/a 01-ERP-0227 50,00025,000 25,000Police Equipment n/a 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0303 102,90053,400 49,5001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a 01-ERP-0308 268,600268,600Front End Loaders (2)n/a 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a 01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0808 17,70017,700Riding Mowers (2)1 01-ERP-0814 10,00010,000Trailer Flatbed n/a 01-ERP-0816 80,20080,200Toolcatn/a 6,261,4391,585,229 1,348,497 1,067,454 1,441,589 818,670Equipment 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-1000 165,000165,000Pavilion Ice Resurfacer n/a 01-ERP-1001 8,9008,900Pavilion - Electric Ice Edger n/a 01-ERP-1002 12,00012,000Pavilion Arena Scoreboard n/a 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 197,50011,600 185,900PA - Pavilion Fund Total PKG - Parking Fund 01-ERP-0212 8,0008,000Squad Car Camera Systems/ Body Worn Camera n/a 8,0008,000PKG - Parking Fund Total RF - Refuse Fund 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a 357,00081,800 275,200RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 01-ERP-0560 180,000180,000Sewer Televising Camera and Van 1 275,000223,000 6,800 45,200SF - Sanitary Sewer Fund Total WF - Water Fund Wednesday, December 8, 2021 21 TotalSourceProject #Priority 2022 2023 2024 2025 2026 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 53,7006,800 46,900WF - Water Fund Total 7,248,3391,838,229 1,484,997 1,093,754 1,727,589 1,103,770GRAND TOTAL Wednesday, December 8, 2021 22 EQUIPMENT REQUESTS 23 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2022 2026thru Department Comm Svcs - Activity Center Description Floor scrubbed is used to clean tiled floors at the Activity Center Project #01-ERP-0035 Priority n/a Justification Floor scrubber has been used to the extent of it's useful life. Budget Impact/Other New item for 2016 Useful Life 10 yearsProject Name Activity Center - Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$20,700 Total20222023202420252026Expenditures 6,7006,700Equipment 6,700 6,700Total Total20222023202420252026Funding Sources 6,7006,700Equipment Replacement Fund 6,700 6,700Total Wednesday, December 15, 2021 24 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Activity Ctr Director 2022 2026thru 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 Total20222023202420252026Expenditures 29,00017,000 12,000Equipment 17,000 12,000 29,000Total Total20222023202420252026Funding Sources 29,00017,000 12,000Equipment Replacement Fund 17,000 12,000 29,000Total Wednesday, December 15, 2021 25 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact 2022 2026thru Department Comm Svcs - Activity Center Description Replace existing kitchen dish sanitizer and heat booster with newer model - if needed. Pricing is an estimate of the cost for the unit. It does not include delivery or installation. Project #01-ERP-0042 Priority 2 Very Important Justification There were some problems with the current unit in 2020. These have been repaired, however, the unit is quite old. If it continues to have problems, especially with more kitchen use now that the Activity Center has reopened, it may be necessary to replace. Budget Impact/Other Useful Life 10 yearsProject Name Activity Center - Replace Sanitizer/Heat Booster Category Unassigned Type Equipment Future Total Project Cost:$83,000 Total20222023202420252026Expenditures 20,00020,000Equipment 20,000 20,000Total Total20222023202420252026Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Wednesday, December 15, 2021 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2022 2026thru Department Comm Svcs - Arts Center Description Under counter freezer and refrigerator in catering kitchen. Project #01-ERP-1102 Priority n/a Justification These units are used for storing food for HCA events and for rental clients. Budget Impact/Other Variance from 20 year plan - New item. Current pricing $2049 refrigerator, $2207 freezer plus delivery. Estimate salvage/resale value on replaced item: $-0- Useful Life 12 yearsProject Name Art Center Kitchen Catering Equipment Category Equipment Type Equipment Future Total Project Cost:$22,223 Total20222023202420252026Expenditures 7,1007,100Equipment 7,100 7,100Total Total20222023202420252026Funding Sources 7,1007,100AC - Arts Center Fund 7,100 7,100Total Wednesday, December 15, 2021 27 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2022 2026thru 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 Total20222023202420252026Expenditures 13,50013,500Equipment 13,500 13,500Total Total20222023202420252026Funding Sources 13,50013,500AC - Arts Center Fund 13,500 13,500Total Wednesday, December 15, 2021 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2022 2026thru 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 Total20222023202420252026Expenditures 6,7006,700Equipment 6,700 6,700Total Total20222023202420252026Funding Sources 6,7006,700AC - Arts Center Fund 6,700 6,700Total Wednesday, December 15, 2021 29 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Co-Director 2022 2026thru Department Comm Svcs - Arts Center Description 26-inch auto scrubber Project #01-ERP-1109 Priority n/a Justification Current scrubber has reached its lifetime and no longer spins fast enough to be effective. Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $-0- Useful Life 10 yearsProject Name Art Center Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$33,316 Total20222023202420252026Expenditures 10,80010,800Equipment 10,800 10,800Total Total20222023202420252026Funding Sources 10,80010,800AC - Arts Center Fund 10,800 10,800Total Wednesday, December 15, 2021 30 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru 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 Total20222023202420252026Expenditures 134,82025,000 26,250 27,037 27,849 28,684Equipment 25,000 26,250 27,037 27,849 28,684 134,820Total Total20222023202420252026Funding Sources 134,82025,000 26,250 27,037 27,849 28,684Equipment Replacement Fund 25,000 26,250 27,037 27,849 28,684 134,820Total Wednesday, December 15, 2021 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru 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 Total20222023202420252026Expenditures 89,60089,600Equipment 89,600 89,600Total Total20222023202420252026Funding Sources 76,00076,000Equipment Replacement Fund 6,8006,800SF - Sanitary Sewer Fund 6,8006,800WF - Water Fund 89,600 89,600Total Wednesday, December 15, 2021 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2022 2026thru 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,593,000 Total20222023202420252026Expenditures 315,000315,000Equipment 315,000 315,000Total Total20222023202420252026Funding Sources 315,000315,000Equipment Replacement Fund 315,000 315,000Total Wednesday, December 15, 2021 33 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2022 2026thru 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 Total20222023202420252026Expenditures 187,28634,729 36,465 37,559 38,686 39,847Equipment 34,729 36,465 37,559 38,686 39,847 187,286Total Total20222023202420252026Funding Sources 187,28634,729 36,465 37,559 38,686 39,847Equipment Replacement Fund 34,729 36,465 37,559 38,686 39,847 187,286Total Wednesday, December 15, 2021 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2022 2026thru 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:$51,456 Total20222023202420252026Expenditures 00Equipment 0 0Total Total20222023202420252026Funding Sources 00Equipment Replacement Fund 0 0Total Wednesday, December 15, 2021 35 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director/IT 2022 2026thru 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 Total20222023202420252026Expenditures 20,00020,000Equipment 20,000 20,000Total Total20222023202420252026Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Wednesday, December 15, 2021 36 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru 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 Total20222023202420252026Expenditures 57,00057,000Equipment 57,000 57,000Total Total20222023202420252026Funding Sources 57,00057,000Equipment Replacement Fund 57,000 57,000Total Wednesday, December 15, 2021 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru 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 Total20222023202420252026Expenditures 150,92872,120 78,808Equipment 72,120 78,808 150,928Total Total20222023202420252026Funding Sources 150,92872,120 78,808Equipment Replacement Fund 72,120 78,808 150,928Total Wednesday, December 15, 2021 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru 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 Total20222023202420252026Expenditures 228,08044,000 44,000 45,320 46,680 48,080Equipment 44,000 44,000 45,320 46,680 48,080 228,080Total Total20222023202420252026Funding Sources 228,08044,000 44,000 45,320 46,680 48,080Equipment Replacement Fund 44,000 44,000 45,320 46,680 48,080 228,080Total Wednesday, December 15, 2021 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru 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:$321,169 Total20222023202420252026Expenditures 50,90910,000 10,000 10,000 10,300 10,609Equipment 10,000 10,000 10,000 10,300 10,609 50,909Total Total20222023202420252026Funding Sources 50,90910,000 10,000 10,000 10,300 10,609Equipment Replacement Fund 10,000 10,000 10,000 10,300 10,609 50,909Total Wednesday, December 15, 2021 40 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru 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:$1,201,909 Total20222023202420252026Expenditures 234,81842,000 42,000 63,000 43,260 44,558Equipment 42,000 42,000 63,000 43,260 44,558 234,818Total Total20222023202420252026Funding Sources 234,81842,000 42,000 63,000 43,260 44,558Equipment Replacement Fund 42,000 42,000 63,000 43,260 44,558 234,818Total Wednesday, December 15, 2021 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru Department Comm Svcs - IT Description The sandbox is a security appliance that integrates into the overall security fabric of the city providing an automated method of detecting malware. Project #01-ERP-0024 Priority n/a Justification The city relies on our sandbox as a place to investigate questionable files that user received to determine if they are safe to open. The sandbox performs automated analysis that would normally take a significatn amount of manual time invested to determine if an item is dangerous. This allows the IT department to perform investigations in minutes instead of hours. The existing sandbox has proved extremly useful over the last 5 years and needs to be replaced because it is no longer supported by the ventor Budget Impact/Other Useful Life 5 yearsProject Name IT - Sandbox Security Appliance Category Equipment Type Equipment Future Total Project Cost:$272,000 Total20222023202420252026Expenditures 90,00045,000 45,000Equipment 45,000 45,000 90,000Total Total20222023202420252026Funding Sources 90,00045,000 45,000Equipment Replacement Fund 45,000 45,000 90,000Total Wednesday, December 15, 2021 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2022 2026thru Department Comm Svcs - IT Description Computer servers store information and system programs for Police Department. Project #01-ERP-0211 Priority n/a Justification Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used for data storage Budget Impact/Other Useful Life 1 yearProject Name PD - Network Server Category Equipment Type Equipment Future Total Project Cost:$1,118,901 Total20222023202420252026Expenditures 134,82125,000 26,250 27,038 27,849 28,684Equipment 25,000 26,250 27,038 27,849 28,684 134,821Total Total20222023202420252026Funding Sources 134,82125,000 26,250 27,038 27,849 28,684Equipment Replacement Fund 25,000 26,250 27,038 27,849 28,684 134,821Total Wednesday, December 15, 2021 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Asst City Manager 2022 2026thru Department Community Services Description Included in this request are equipment needed to move to an electronic plan review and inspections process. Revu -Bluebeam electronic plan review software - 2020 - $1,100 (useful life 8-10 years) Ipads - 2020 - $5,400 (useful life 5-6 years) Rental Inspection software - 2020 - $7,500 (useful life 7-10 years) Project #01-ERP-0052 Priority 2 Very Important Justification As more and more contractors and architects ask to submit plan electronically, Blubeam software will enable inspectors to perform electronic plan reviews which will make the plan review process more efficient and enhance customer service. As the inspection and construction industry becomes more paperless, iPads will enable inspectors to use mobile technology to keep up with the requests of engineers, architect, contractors, landlords and residents. Ipads are a key piece that will enable staff to view electronic plans in the field. Going paperless will eventually eliminate our need for paper plan scanning and sorting which is very time consuming and costs $1,500 - $2,000 per year. The software company currently used by Rental Inspectors has recently gone out of business and support for the software is going to be on a very limited basis after 2020. Because rental inspections effect such a large part of the city and the department, I believe getting a new software in place before the existing software stops functioning is essential to the rental inspection program. Budget Impact/Other Useful Life 5-7 yearsProject Name Electronic Inspections Processing Category Equipment Type Equipment Future Total Project Cost:$96,150 Total20222023202420252026Expenditures 16,23116,231Equipment 16,231 16,231Total Total20222023202420252026Funding Sources 16,23116,231Equipment Replacement Fund 16,231 16,231Total Wednesday, December 15, 2021 44 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru Department Fire Description Duty Crew Vehicles to respond to all calls. Current vehicle: 2012 Ford F550 (#104) Current Vehicle: 2006 Peterbilt Fire Pumper 357 (#103) Project #01-ERP-0105 Priority n/a Justification 2012 Rescue (#104) will be replaced by the a fire engine for day to day operation. The current vehicle is undersized for the type of truck it is on. We have spent $70,000 on maintenance cost since 2014. With going to overnight duty crews in Aug of 2021 and going to 24-hour duty crews in 2022, we will need a larger truck to fit more personnel. This would be a 10-year truck. It will be utilized as a first out response vehicle. 2006 Peterbilt Fire Pumper 357 (#103) will be replaced in 2027 and will also be on a 10 year rotation. Budget Impact/Other The replacement schedule for 2012 Rescue (#104) has been advanced from 2023 to 2022. The replacement schedule for 2006 Peterbilt Fire Pumper 357 (#103) has been delayed from 2026 to 2027. Useful Life 10 yearsProject Name Fire Engine/Rescue (2)Category Vehicles Type Equipment Future Total Project Cost:$3,232,000 Total20222023202420252026Expenditures 771,000771,000Equipment 771,000 771,000Total Total20222023202420252026Funding Sources 771,000771,000Equipment Replacement Fund 771,000 771,000Total Wednesday, December 15, 2021 45 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru Department Fire Description Breathing apparatus for interior firefighting for firefighters. Project #01-ERP-0108 Priority n/a Justification The breathing apparatus was taken out of the ERP in 2006 because we thought we were getting a grant. Grant was not successful. The SCBA's (45) need to be replaced because they are at the end of their life and cannot be hydro tested any longer. Budget Impact/Other Variance from 20 year plan - Move back to 2025. Purchased SCBA's in 2015 with grant funds. Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Self Contained Breathing Apparatus (SCBA) (45)Category Equipment Type Equipment Future Total Project Cost:$752,000 Total20222023202420252026Expenditures 250,000250,000Equipment 250,000 250,000Total Total20222023202420252026Funding Sources 250,000250,000Equipment Replacement Fund 250,000 250,000Total Wednesday, December 15, 2021 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru Department Fire Description Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. Project #01-ERP-0109 Priority n/a Justification All vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool will be added to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. Budget Impact/Other Estimate salvage/resale value on replaced item: $1,000 Purchased: 2007 Useful Life 10 yearsProject Name Extrication Tool (1)Category Equipment Type Equipment Future Total Project Cost:$234,800 Total20222023202420252026Expenditures 32,00032,000Equipment 32,000 32,000Total Total20222023202420252026Funding Sources 32,00032,000Equipment Replacement Fund 32,000 32,000Total Wednesday, December 15, 2021 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru Department Fire Description Used by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and heat may be hidden allowing for faster extinguishment. Note: purchased 2013 & 2017 Project #01-ERP-0112 Priority n/a Justification Current camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was purchased with donation money. Budget Impact/Other Variance from 20 year plan - department owns 2 cameras. Reoccuring expenditure. Estimate salvage/resale value on replaced item: $-0- Useful Life 10 yearsProject Name Thermal Imaging Camera (2)Category Equipment Type Equipment Future Total Project Cost:$144,885 Total20222023202420252026Expenditures 16,18016,180Equipment 16,180 16,180Total Total20222023202420252026Funding Sources 16,18016,180Equipment Replacement Fund 16,180 16,180Total Wednesday, December 15, 2021 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru Department Fire Description Emergency warning system for City of Hopkins. Project #01-ERP-0113 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $-0- Useful Life 20 yearsProject Name Emergency Preparedness Sirens Category Equipment Type Equipment Future Total Project Cost:$65,500 Total20222023202420252026Expenditures 38,50038,500Equipment 38,500 38,500Total Total20222023202420252026Funding Sources 38,50038,500Equipment Replacement Fund 38,500 38,500Total Wednesday, December 15, 2021 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru Department Fire Description Portable and mobile radios used by the police departments to allow the department to communicate on one frequency. Fire has 50 portable and 13 mobile radios along with 50 pagers. Cost in ERP includes portable radios (30), portable radio's encrypted (20), mobile radio's (13), pagers (50), chargers single (60), charger base (3) plus other needed equipment. Details of all items are on file with Fire and Finance Depts. Project #01-ERP-0125 Priority n/a Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. Budget Impact/Other In 2016 the Fire radios were separated from Police for better accountability. Project was adjusted for current pricing. 2025 - 356,500 FD 2025 - 29,500 PW Useful Life 5-7 yearsProject Name Fire Radios - Portable and Mobile Devices Category Equipment Type Equipment Future Total Project Cost:$2,335,328 Total20222023202420252026Expenditures 386,000386,000Equipment 386,000 386,000Total Total20222023202420252026Funding Sources 386,000386,000Equipment Replacement Fund 386,000 386,000Total Wednesday, December 15, 2021 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru Department Fire Description Fire Helmets for firefighters. Helmets are used for safety of personnel at Fire and other Emergency incidents. In 2017, the NFPA and OSHA Standard changed to recommending helmet change every 10 years. Project #01-ERP-0126 Priority n/a Justification Safety of Firefighters. Current helmets useful life will be up in 2022. Budget Impact/Other Reoccuring every 10 years. Useful Life 10 yearsProject Name Fire - Fire Helmets Category Equipment Type Equipment Future Total Project Cost:$58,191 Total20222023202420252026Expenditures 16,00016,000Equipment 16,000 16,000Total Total20222023202420252026Funding Sources 16,00016,000Equipment Replacement Fund 16,000 16,000Total Wednesday, December 15, 2021 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru 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 Total20222023202420252026Expenditures 18,00018,000Equipment 18,000 18,000Total Total20222023202420252026Funding Sources 18,00018,000Equipment Replacement Fund 18,000 18,000Total Wednesday, December 15, 2021 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2022 2026thru Department Fire Description This sytem would alert members throughout the station when there is a call. This system will integrate with the new paging system that Hennepin County is adopting. Project #01-ERP-0131 Priority n/a Justification Help with quicker response to in coming calls. Will prepare the station for future 24 hour duty crew shifts and overnights. Budget Impact/Other Useful LifeProject Name Fire - Station Alerting System Category Buildings: Fire Facilities Type Equipment Future Total Project Cost:$75,000 Total20222023202420252026Expenditures 75,00075,000Equipment 75,000 75,000Total Total20222023202420252026Funding Sources 75,00075,000Equipment Replacement Fund 75,000 75,000Total Wednesday, December 15, 2021 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Unassigned 2022 2026thru 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,400 Total20222023202420252026Expenditures 41,10041,100Vehicles 41,100 41,100Total Total20222023202420252026Funding Sources 41,10041,100HRA - Housing and Redevelopment Authority 41,100 41,100Total Wednesday, December 15, 2021 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2022 2026thru 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,900 Total20222023202420252026Expenditures 16,50016,500Equipment 16,500 16,500Total Total20222023202420252026Funding Sources 16,50016,500HRA - Housing and Redevelopment Authority 16,500 16,500Total Wednesday, December 15, 2021 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Facilities Director 2022 2026thru Department Pavilion Description Ice resurfacer used by the Pavilion for ice sheet maintenance. Current equipment: Zamboni Ice Resurfacer 2014 cost = $116,205.93 Asset ID #5176 Project #01-ERP-1000 Priority n/a Justification Replace existing electric (battery) ice resurfacer. The current electric ice resurfacer was purchased in 2014 and has a useful life of 12 years and is scheduled for replacement in 2026. Budget Impact/Other Variance from 20 year plan - Decrease cost due to 2014 purchase price. Move back one year. Estimate salvage/resale value on replaced item: $30,000 Useful Life 12 yearsProject Name Pavilion Ice Resurfacer Category Equipment Type Equipment Future Total Project Cost:$640,251 Total20222023202420252026Expenditures 165,000165,000Equipment 165,000 165,000Total Total20222023202420252026Funding Sources 165,000165,000PA - Pavilion Fund 165,000 165,000Total Wednesday, December 15, 2021 56 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Facilities Director 2022 2026thru Department Pavilion Description Electric ice edger used for ice maintenance of the Pavilion's ice sheet. An edger is used to shave the ice next to the boards to remove ice buildup that the ice resurfacer cannot reach. 2014 cost = $6,281.25 Asset ID #5174 Project #01-ERP-1001 Priority n/a Justification Replace the current battery fueled ice edger with a new model of battery ice edger. Scheduled to replace at the end of useful life should occur in 2026, the model was purchased in 2014. Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Pavilion - Electric Ice Edger Category Equipment Type Equipment Future Total Project Cost:$25,861 Total20222023202420252026Expenditures 8,9008,900Equipment 8,900 8,900Total Total20222023202420252026Funding Sources 8,9008,900PA - Pavilion Fund 8,900 8,900Total Wednesday, December 15, 2021 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Facilities Director 2022 2026thru Department Pavilion Description Arena scoreboard used for hockey, lacrosse, soccer and other activities in the arena. Project #01-ERP-1002 Priority n/a Justification The current scoreboard was purchased and installed in 2014 with donations from HYHA and other city funds. Budget Impact/Other Variance from 20 year plan - Originally scheduled for 2016, the scoreboard was replaced in 2014 with donations from HYHA and other city funds. Replacement is now scheduled again for 2026. Estimate salvage/resale value on replaced item: $0 Useful Life 20 yearsProject Name Pavilion Arena Scoreboard Category Equipment Type Equipment Future Total Project Cost:$33,674 Total20222023202420252026Expenditures 12,00012,000Equipment 12,000 12,000Total Total20222023202420252026Funding Sources 12,00012,000PA - Pavilion Fund 12,000 12,000Total Wednesday, December 15, 2021 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2022 2026thru 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 Total20222023202420252026Expenditures 11,60011,600Equipment 11,600 11,600Total Total20222023202420252026Funding Sources 11,60011,600PA - Pavilion Fund 11,600 11,600Total Wednesday, December 15, 2021 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2022 2026thru 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 Useful Life 3 yearsProject Name Marked Patrol Vehicles (7)Category Vehicles Type Equipment Future Total Project Cost:$4,669,200 Total20222023202420252026Expenditures 590,200110,000 117,400 117,400 117,400 128,000Vehicles 110,000 117,400 117,400 117,400 128,000 590,200Total Total20222023202420252026Funding Sources 590,200110,000 117,400 117,400 117,400 128,000Equipment Replacement Fund 110,000 117,400 117,400 117,400 128,000 590,200Total Wednesday, December 15, 2021 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2022 2026thru 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: 2021 Ford Utility (#201) VIN #1FM5K8AB6MGB53652 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 Total20222023202420252026Expenditures 64,15464,154Vehicles 64,154 64,154Total Total20222023202420252026Funding Sources 64,15464,154Equipment Replacement Fund 64,154 64,154Total Wednesday, December 15, 2021 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2022 2026thru 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: 2021 Ford Utility (#211) VIN# 1FM5K8AB3MGB53656 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 Total20222023202420252026Expenditures 60,00060,000Vehicles 60,000 60,000Total Total20222023202420252026Funding Sources 60,00060,000Equipment Replacement Fund 60,000 60,000Total Wednesday, December 15, 2021 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2022 2026thru 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) VIN# 1FTEW1PG2JKE86443 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 Total20222023202420252026Expenditures 158,20072,100 86,100Vehicles 72,100 86,100 158,200Total Total20222023202420252026Funding Sources 158,20072,100 86,100Equipment Replacement Fund 72,100 86,100 158,200Total Wednesday, December 15, 2021 63 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2022 2026thru Department Police Description Squad car camera systems are used to document events inside and outside of the patrol vehicles. The cameras utilize a forward facing camera and a prisoner transport area camaera. Body cameras capture interactions between the officers and the public for transparency. Body cameras also capture evidence used in future court proceedings. Project #01-ERP-0212 Priority n/a Justification The police vehicle cameras are a necessary component of the patrol vehicles. Evidentiary information is collected from the cameras and often used in court. Cameras also provide a snapshot of an officers interaction with the public so we are able to maintain transparency and public trust with our operations. Budget Impact/Other Integrated camera system - 11 Squad car cameras and 24 body cameras Squad cameras 6,000/each. Body cameras 1,200/each. Annual costs/maintenance = $17,325 (Body Cameras 3 year warranty, Squad Cameras 5 year warranty) Useful Life 5 yearsProject Name Squad Car Camera Systems/ Body Worn Camera Category Equipment Type Equipment Future Total Project Cost:$866,921 Total20222023202420252026Expenditures 160,000160,000Equipment 160,000 160,000Total Total20222023202420252026Funding Sources 152,000152,000Equipment Replacement Fund 8,0008,000PKG - Parking Fund 160,000 160,000Total Wednesday, December 15, 2021 64 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2022 2026thru 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 Total20222023202420252026Expenditures 76,51276,512Equipment 76,512 76,512Total Total20222023202420252026Funding Sources 76,51276,512Equipment Replacement Fund 76,512 76,512Total Wednesday, December 15, 2021 65 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2022 2026thru 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 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 Total20222023202420252026Expenditures 290,000290,000Equipment 290,000 290,000Total Total20222023202420252026Funding Sources 290,000290,000Equipment Replacement Fund 290,000 290,000Total Wednesday, December 15, 2021 66 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Captain 2022 2026thru Department Police Description Tasers can prevent officers and the public from injuries.Taser technology continues to develop and are worn/ carried 24/7. Tasers have a useful life expectancy of approximately 5 years. Project #01-ERP-0217 Priority n/a Justification Tasers are a crtical tool for Law Enforcement for control purposes during use of force encounters. Budget Impact/Other 35- X2 Tasers, each officer has their own taser. Total overall cost of Tasers in 2020 was $81,130 ($2,1318 x 35) Useful Life 4 yearsProject Name Taser Replacement Category Equipment Type Equipment Future Total Project Cost:$721,905 Total20222023202420252026Expenditures 90,00090,000Equipment 90,000 90,000Total Total20222023202420252026Funding Sources 90,00090,000Equipment Replacement Fund 90,000 90,000Total Wednesday, December 15, 2021 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2022 2026thru 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:$157,907 Total20222023202420252026Expenditures 39,00022,000 17,000Equipment 22,000 17,000 39,000Total Total20222023202420252026Funding Sources 39,00022,000 17,000Equipment Replacement Fund 22,000 17,000 39,000Total Wednesday, December 15, 2021 68 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2022 2026thru 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 Total20222023202420252026Expenditures 90,00090,000Equipment 90,000 90,000Total Total20222023202420252026Funding Sources 90,00090,000Equipment Replacement Fund 90,000 90,000Total Wednesday, December 15, 2021 69 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2022 2026thru 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 Total20222023202420252026Expenditures 150,000150,000Equipment 150,000 150,000Total Total20222023202420252026Funding Sources 150,000150,000Equipment Replacement Fund 150,000 150,000Total Wednesday, December 15, 2021 70 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2022 2026thru Department Police Description The police department needs to maintain law and order during times of civil unrest. We need to allow for the peaceful demonstrations and first amendment rights of our community members, while ensuring that we have the ability to keep everyone safe and property from being damaged. This requires specialized equipment for each of our officer. Project #01-ERP-0227 Priority n/a Justification Community safety is our priority and specialized equipment is necessary to perform this core function. This includes full face shielts, soft body armor (turltle gear), gas masks and less lethal munitions, which are necessary to keep officer and the community members safe. The general fund supported numerous acquisitions and purchases in 2021, however this was only a temporary solution. Budget Impact/Other Useful Life 3 yearsProject Name Police Equipment Category Equipment Type Equipment Future Total Project Cost:$214,381 Total20222023202420252026Expenditures 50,00025,000 25,000Equipment 25,000 25,000 50,000Total Total20222023202420252026Funding Sources 50,00025,000 25,000Equipment Replacement Fund 25,000 25,000 50,000Total Wednesday, December 15, 2021 71 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Public Works: Bldg/Equip Ser Description Pickup used by various divisions of Public Works. Project #01-ERP-0710 Priority n/a Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. Budget Impact/Other Variance from 20 year plan - move up from 2009 to 2008 - Fire Dept. has requested to acquire surplus pickup for its use by daytime responders. Estimated useful life reduced from 10 to 8 years. Estimate salvage/resale value on replaced item: $1,500 Useful Life 8 yearsProject Name 4X4 3/4 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$222,289 Total20222023202420252026Expenditures 42,10042,100Vehicles 42,100 42,100Total Total20222023202420252026Funding Sources 42,10042,100Equipment Replacement Fund 42,100 42,100Total Wednesday, December 15, 2021 72 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru 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 Total20222023202420252026Expenditures 35,40035,400Vehicles 35,400 35,400Total Total20222023202420252026Funding Sources 35,40035,400Equipment Replacement Fund 35,400 35,400Total Wednesday, December 15, 2021 73 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru 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 Total20222023202420252026Expenditures 163,600163,600Vehicles 163,600 163,600Total Total20222023202420252026Funding Sources 81,80081,800Equipment Replacement Fund 81,80081,800RF - Refuse Fund 163,600 163,600Total Wednesday, December 15, 2021 74 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2022 2026thru Department Public Works: Parks/Forestry Description Riding mowers used by Parks Division of Public Works. Current equipment: 2004 Toro Zero Turn (#826), 2006 Jacobson Rotary Mower (#823) Project #01-ERP-0808 Priority 1 Urgent Justification Mowing city parks and right of ways. Move replacement of #826 to 2021 - Ran 10 years past useful life Move replacement of #823 to 2021 Both replacements of current vehicles were held off in 2020 due to the COVID-19 Pandemic. Budget Impact/Other 2021 - Replace 2004 Zero Turn #826 at $15,000 2021 - Replace 2006 Jacobson #823 at $35,000 The Jacobson will be replaced with 7500-D Zmaster Toro Zero Turn Useful Life 6 yearsProject Name Riding Mowers (2)Category Equipment Type Equipment Future Total Project Cost:$323,930 Total20222023202420252026Expenditures 17,70017,700Equipment 17,700 17,700Total Total20222023202420252026Funding Sources 17,70017,700Equipment Replacement Fund 17,700 17,700Total Wednesday, December 15, 2021 75 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru 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 Total20222023202420252026Expenditures 10,00010,000Equipment 10,000 10,000Total Total20222023202420252026Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Wednesday, December 15, 2021 76 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Public Works: Parks/Forestry Description Use by Public Works for snow removal, skating rinks, sweeping, ballfield maintenance and transportation of people and materials. Current vehicle: 2010 Bobcat (#815) Project #01-ERP-0816 Priority n/a Justification New machine. Budget Impact/Other Variance from 20 year plan - New item which replaces one tractor. Estimate salvage/resale value on replaced item: $ Useful Life 8 yearsProject Name Toolcat Category Equipment Type Equipment Future Total Project Cost:$423,804 Total20222023202420252026Expenditures 80,20080,200Equipment 80,200 80,200Total Total20222023202420252026Funding Sources 80,20080,200Equipment Replacement Fund 80,200 80,200Total Wednesday, December 15, 2021 77 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru 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 Total20222023202420252026Expenditures 28,90028,900Vehicles 28,900 28,900Total Total20222023202420252026Funding Sources 28,90028,900Equipment Replacement Fund 28,900 28,900Total Wednesday, December 15, 2021 78 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Public Works: Streets/Traffic Description Truck is used in the Street Division of Public Works. Current vehicles: 2000 Ford F450 (#805) & 2011 Ford F350 (#308) Project #01-ERP-0303 Priority n/a Justification Vehicle used by various departments for street and park maintenance and light hauling. Budget Impact/Other Variance from 20 year plan - move back from 2009 to 2010. Estimated useful life reduced from 12 to 8 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 10 yearsProject Name 1 Ton Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$281,600 Total20222023202420252026Expenditures 102,90053,400 49,500Vehicles 53,400 49,500 102,900Total Total20222023202420252026Funding Sources 102,90053,400 49,500Equipment Replacement Fund 53,400 49,500 102,900Total Wednesday, December 15, 2021 79 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Public Works: Streets/Traffic Description Boom truck used in Street and Traffic Divisions of Public Works. Current vehicle: 2012 Ford F450 (#309) Project #01-ERP-0304 Priority n/a Justification Vehicle used by Traffic Department for signal and light pole maintenance. Budget Impact/Other Variance from 20 year plan - Increase amount to reflect actual. Estimate salvage/resale value on replaced item: $8,000 Useful life moved from 17 years to 12 years. Useful Life 12 yearsProject Name 1 Ton Traffic Boom Truck Category Vehicles Type Equipment Future Total Project Cost:$413,400 Total20222023202420252026Expenditures 136,400136,400Vehicles 136,400 136,400Total Total20222023202420252026Funding Sources 136,400136,400Equipment Replacement Fund 136,400 136,400Total Wednesday, December 15, 2021 80 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru 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 Total20222023202420252026Expenditures 225,000225,000Vehicles 225,000 225,000Total Total20222023202420252026Funding Sources 225,000225,000Equipment Replacement Fund 225,000 225,000Total Wednesday, December 15, 2021 81 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Public Works: Streets/Traffic Description Current equipment: 2005 Caterpillar 938G (#322) Project #01-ERP-0308 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $ Useful Life 15-18 yearsProject Name Front End Loaders (2)Category Equipment Type Equipment Future Total Project Cost:$1,267,100 Total20222023202420252026Expenditures 268,600268,600Equipment 268,600 268,600Total Total20222023202420252026Funding Sources 268,600268,600Equipment Replacement Fund 268,600 268,600Total Wednesday, December 15, 2021 82 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Public Works: Streets/Traffic Description Loading trucks, landscape work, snow removal, material handling. Current equipment: 2011 Bobcat S650 Skid-Steer Loader (#325) Project #01-ERP-0309 Priority n/a Justification Budget Impact/Other Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Skid Loader (2)Category Equipment Type Equipment Future Total Project Cost:$258,900 Total20222023202420252026Expenditures 50,00050,000Equipment 50,000 50,000Total Total20222023202420252026Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Wednesday, December 15, 2021 83 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Public Works: Streets/Traffic Description Machine used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city use. Current equipment: 2005 Signcad Sign Making System (#353) Project #01-ERP-0317 Priority n/a Justification Existing machine is not repairable and needs updating. Budget Impact/Other Variance from 20 year plan - Move back to 2016 Estimate salvage/resale value on replaced item: $-0- Useful Life 10 yearsProject Name Sign Machine (Traffic)Category Equipment Type Equipment Future Total Project Cost:$55,823 Total20222023202420252026Expenditures 18,10018,100Equipment 18,100 18,100Total Total20222023202420252026Funding Sources 18,10018,100Equipment Replacement Fund 18,100 18,100Total Wednesday, December 15, 2021 84 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2022 2026thru Department Refuse Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 2011 Freightliner Rapid Rail (#900) Project #01-ERP-0900 Priority n/a Justification Residential waste pick up. Budget Impact/Other Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Useful Life 8 yearsProject Name Refuse Truck (RAP-R) (2)Category Vehicles Type Equipment Future Total Project Cost:$1,950,700 Total20222023202420252026Expenditures 275,200275,200Vehicles 275,200 275,200Total Total20222023202420252026Funding Sources 275,200275,200RF - Refuse Fund 275,200 275,200Total Wednesday, December 15, 2021 85 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Sewer Description 3/4 ton utility truck used by the Water/Sewer Division of Public Works. Current vehicle: 2007 Chevrolet Pickup (#505) Project #01-ERP-0551 Priority n/a Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Useful Life 10 yearsProject Name 3/4 Ton Utility Truck Category Vehicles Type Equipment Future Total Project Cost:$190,546 Total20222023202420252026Expenditures 45,20045,200Vehicles 45,200 45,200Total Total20222023202420252026Funding Sources 45,20045,200SF - Sanitary Sewer Fund 45,200 45,200Total Wednesday, December 15, 2021 86 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Sewer Description Portable generator used by Water/Sewer Divisions of Public Works. Current equipment: 2022 Generator (#535), "PW Generator " 2010 Caterpillar C15 (#537) Project #01-ERP-0555 Priority n/a Justification Emergency back up generator for lift stations and pumps, off site power for lights and welding. Budget Impact/Other Estimated useful life reduced from 25 to 20 years. Estimate salvage/resale value on replaced item: $2,500 Useful Life 20 yearsProject Name Generator (2)Category Equipment Type Equipment Future Total Project Cost:$79,000 Total20222023202420252026Expenditures 43,00043,000Equipment 43,000 43,000Total Total20222023202420252026Funding Sources 43,00043,000SF - Sanitary Sewer Fund 43,000 43,000Total Wednesday, December 15, 2021 87 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Sewer Description Sewer inspection Crawler (Televising Camera) with Ford Transit Van used by Utility crews to televise sanitary and storm sewers annually. Project #01-ERP-0560 Priority 1 Urgent Justification Better effectiviness, efficiency and cost. Currently the televising for our sanitary lines go out for bids, RFP's for 2020's work averaged over $33,000. The payback would be 6 years and with the camera's useful life as 12-15 years, we would benefit 6-9 years of induring no costs other than maintenance before needing to replace. We're at the mercy of the contractor for a timley completion of televising, the best scenario is to televise immediately after jetting to make sure the sanitary lines are clean of debris or damage. With this we can react immediately to resolve any issues we may find. Budget Impact/Other Estimate salvage/resale value at the end of useful life is $30,000. Useful Life 12 yearsProject Name Sewer Televising Camera and Van Category Utilities: Municipal Sanitary Se Type Equipment Future Total Project Cost:$436,600 Total20222023202420252026Expenditures 180,000180,000Equipment 180,000 180,000Total Total20222023202420252026Funding Sources 180,000180,000SF - Sanitary Sewer Fund 180,000 180,000Total Wednesday, December 15, 2021 88 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2022 2026thru Department Water Description 3/4 ton utility truck used by the Water Division of Public Works. Current vehicle: 2006 Chevrolet Pickup Project #01-ERP-0501 Priority n/a Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. Budget Impact/Other Variance from 20 year plan - moved up from 2017 to 2016 Estimate salvage/resale value on replaced item: $2,500 Useful Life 10 yearsProject Name 3/4 Ton Utility Truck Category Vehicles Type Equipment Future Total Project Cost:$144,929 Total20222023202420252026Expenditures 46,90046,900Vehicles 46,900 46,900Total Total20222023202420252026Funding Sources 46,90046,900WF - Water Fund 46,900 46,900Total Wednesday, December 15, 2021 89 90 TWENTY-YEAR REPLACEMENT SCHEDULE 91 12/14/2021 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average:1,746,400$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 Total ACTIVITY CENTER ERP-0032 Sound System 15 0 0 0 0 0 0 0 0 13,700 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0035 Floor Scrubber 10 0 0 0 0 6,700 0 0 0 0 0 0 0 0 0 9,000 0 0 0 0 0 0 ERP-0037 Security System Upgrade 15-18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 31,160 0 0 0 0 0 0 ERP-0038 Kitchen Storage 30 17,000 12,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0041 A/V Replacement & Upgrade 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 97,568 0 0 0 0 0 0 ERP-0042 Replace Sanitizer/Heat Booster 10 20,000 0 0 0 0 0 0 0 0 0 27,000 0 0 0 0 0 0 0 0 0 36,000 SUBTOTAL 37,000 12,000 0 0 6,700 0 0 0 13,700 0 27,000 0 0 0 137,728 0 0 0 0 0 36,000 270,128 ARTS CENTER ERP-1102 Kitchen Catering Equipment 12 0 0 0 0 7,100 0 0 0 0 0 0 0 0 0 0 0 10,123 0 0 0 0 ERP-1105 Community Room A/V 7 13,500 0 0 0 0 0 0 16,600 0 0 0 0 0 0 20,415 0 0 0 0 0 0 ERP-1107 Theater Projection Screen 10 0 0 6,700 0 0 0 0 0 0 0 0 0 9,000 0 0 0 0 0 0 0 0 ERP-1109 Floor Scrubber 10 0 0 0 10,800 0 0 0 0 0 0 0 0 0 14,516 0 0 0 0 0 0 0 13,500 0 6,700 10,800 7,100 0 0 16,600 0 0 0 0 9,000 14,516 20,415 0 10,123 0 0 0 0 108,754 COMMUNITY SERVICES ERP-0108 Document Management Scanner (2) 4 0 0 0 0 0 0 14,300 0 0 0 16,000 0 0 0 18,007 0 0 0 20,266 0 0 ERP-0010 Election Booths 20 0 0 0 0 0 0 0 0 13,439 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0051 Exterior Security Camera System 15 0 0 0 0 0 0 0 0 0 0 0 0 0 62,319 0 0 0 0 0 0 0 ERP-0052 Electronic Inspections Processing 5-7 0 0 0 16,231 0 0 0 0 18,817 0 0 0 0 21,814 0 0 0 0 25,288 0 0 EQUIPMENT SUBTOTAL 0 0 0 16,231 0 0 14,300 0 32,256 0 16,000 0 0 84,133 18,007 0 0 0 45,554 0 0 226,481 FIRE ERP-0100 Tele-Squirt E-2 10 0 0 0 0 0 1,000,000 0 0 0 0 0 0 0 0 0 1,343,916 0 0 0 0 0 ERP-0101 Fire Pumper E-3 20 0 0 0 0 0 900,000 0 0 0 0 0 0 0 0 0 1,250,000 0 0 0 0 0 ERP-0105 Quick Attack Pumper/Rescue R-8 10 771,000 0 0 0 0 0 0 0 0 0 1,050,000 0 0 0 0 0 0 0 0 0 1,411,000 ERP-0106 Aerial Truck 20 0 0 0 0 0 0 1,572,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 VEHICLES SUBTOTAL 771,000 0 0 0 0 1,900,000 1,572,000 0 0 0 1,050,000 0 0 0 0 2,593,916 0 0 0 0 1,411,000 9,297,916 ERP-0107 Air Compressor 15 0 0 0 0 0 0 0 0 0 54,400 0 0 0 0 0 0 0 0 0 0 0 ERP-0108 Breathing Apparatus (45) (SCBA)10 0 0 0 250,000 0 0 0 0 0 0 0 0 0 336,000 0 0 0 0 0 0 0 ERP-0109 Extrication Tool (2)10 0 32,000 0 0 0 0 0 36,900 0 0 40,300 0 0 0 0 0 0 0 0 0 54,000 ERP-0112 Thermal Imaging Camera (2)10 0 0 0 16,180 0 17,400 0 0 0 0 0 20,700 0 0 0 23,384 0 0 0 0 0 ERP-0113 Emergency Preparedness Siren 20 0 0 0 0 38,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0114 Floor Scrubber 12 0 0 0 0 0 20,300 0 0 0 0 0 0 0 0 0 0 28,941 0 0 0 ERP-0125 Radios-Portable & Mobile 5-7 0 0 0 386,000 0 0 0 0 0 0 459,581 0 0 0 0 0 0 546,297 0 0 0 ERP-0126 Helmets 10 16,000 0 0 0 0 0 0 0 0 0 18,000 0 0 0 0 0 0 0 0 0 24,191 ERP-0127 Lucus Device 5 0 18,000 0 0 0 0 18,500 0 0 0 0 19,000 0 0 0 0 20,000 0 0 0 0 ERP-0128 Hose Replacement 20 0 0 0 0 0 0 0 0 0 0 0 51,068 0 0 0 0 0 0 0 0 0 ERP-0131 Station Alerting System 0 75,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 EQUIPMENT SUBTOTAL 16,000 125,000 0 652,180 38,500 37,700 18,500 36,900 0 54,400 517,881 90,768 0 336,000 0 23,384 20,000 575,238 0 0 78,191 2,620,642 IT ERP-0003 City Hall - Network Upgrade 1 25,000 26,250 27,037 27,849 28,684 29,545 30,431 31,344 32,284 33,253 34,251 35,279 36,337 37,427 38,550 39,706 40,897 42,124 43,388 44,690 46,030 ERP-0004 Phone System 8 0 89,600 0 0 0 0 0 0 0 110,700 0 0 0 0 0 0 0 140,231 0 0 0 ERP-0005 Financial Software 7 0 0 0 315,000 0 0 0 0 0 0 387,000 0 0 0 0 0 0 476,000 0 0 0 ERP-0006 Computers 3-5 34,729 36,465 37,559 38,686 39,847 41,042 42,273 43,541 44,847 46,192 47,578 49,005 50,475 51,990 53,549 55,155 56,810 58,514 60,269 62,078 63,940 ERP-0009 Network Infrastructure Upgrade 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36,456 0 0 0 0 0 ERP-0012 Core Network Switch 6 0 0 20,000 0 0 0 0 0 24,000 0 0 0 0 0 28,658 0 0 0 0 0 34,220 ERP-0014 Distribution Network Switches 5 0 0 0 57,000 0 0 0 0 66,079 0 0 0 0 76,603 0 0 0 0 88,804 0 0 ERP-0015 Backup Server 3 0 72,120 0 0 78,808 0 0 86,115 0 0 94,100 0 102,826 0 0 112,361 0 122,780 0 ERP-0017 Office 365 1 44,000 44,000 45,320 46,680 48,080 49,522 51,008 52,538 54,114 55,738 57,410 59,132 60,906 62,733 64,615 66,554 68,551 70,607 72,725 74,907 77,154 ERP-0020 Patching Automation Software 5 10,000 10,000 10,000 10,300 10,609 10,927 11,255 11,593 11,941 12,299 12,668 13,048 13,439 13,842 14,258 14,685 15,126 15,580 16,047 16,528 17,024 ERP-0024 Sandbox Security Appliance 5 45,000 0 0 0 45,000 0 0 0 0 52,000 0 0 0 0 60,000 0 0 0 0 70,000 0 ERP-0211 Police - Network Server (3)3 25,000 26,250 27,038 27,849 28,684 29,545 30,431 31,344 32,284 33,253 34,251 35,279 36,337 37,427 38,550 39,706 40,897 42,124 43,388 44,690 46,030 ERP-0022 Windows 10 Enterprise Upgrade 1 42,000 42,000 63,000 43,260 44,558 45,895 47,271 48,690 50,150 51,655 53,204 54,800 56,444 58,138 59,882 61,678 63,529 65,435 67,398 69,420 71,502 EQUIPMENT SUBTOTAL 225,729 346,685 229,954 566,624 324,270 206,475 212,669 305,164 315,700 395,089 720,462 246,543 253,939 440,985 358,062 313,941 398,171 910,615 392,019 505,093 355,902 8,024,091 POLICE ERP-0200 Squad 3 110,000 117,400 117,400 117,400 128,000 128,000 128,000 140,000 140,000 140,000 153,200 153,200 153,000 157,000 160,000 165,000 170,000 175,000 180,000 185,000 190,000 ERP-0201 Sergeant Vehicle #209 4 0 0 0 64,154 0 0 0 72,206 0 0 0 81,268 0 0 0 91,467 0 0 0 102,947 0 ERP-0202 Parking Vehicle #211 10 0 0 0 0 60,000 0 0 0 0 69,557 0 0 0 0 80,636 0 0 0 0 93,479 0 ERP-0203 PSO Utility 4x4 #212 6 72,100 0 0 0 86,100 0 0 0 96,905 0 0 0 109,067 0 0 0 122,755 0 0 0 138,162 ERP-0205 SWAT Vehicle #240 15 0 0 0 0 0 0 0 0 0 77,900 0 0 0 0 0 0 0 0 0 0 0 VEHICLES SUBTOTAL 182,100 117,400 117,400 181,554 274,100 128,000 128,000 212,206 236,905 287,457 153,200 234,468 262,067 157,000 240,636 256,467 292,755 175,000 180,000 381,426 328,162 4,526,303 ERP-0208 Computer System 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0212 Mobile Data Computers/Digital Cameras 7 0 0 160,000 0 0 0 0 121,724 0 0 0 0 141,111 0 0 0 0 163,586 0 0 0 ERP-0214 Tactical Ballistic Vests (9)5 0 76,512 0 0 0 0 88,697 0 0 0 0 102,825 0 0 0 0 119,203 0 0 0 0 ERP-0215 Radios-Portable & Mobile 5-7 0 290,000 0 0 0 0 0 0 356,664 0 0 0 0 0 438,652 0 0 0 0 0 ERP-0217 Taser Replacement 4 0 90,000 0 0 0 90,041 0 0 101,342 0 0 114,060 0 0 0 128,375 0 0 0 ERP-0218 Building Video Server 4 0 22,000 0 0 17,000 0 0 0 17,000 0 0 0 19,134 0 0 0 21,535 0 0 0 24,238 ERP-0220 Squad Computers 5 0 0 90,000 0 0 0 0 100,000 0 0 0 0 87,418 0 0 0 0 101,342 0 0 0 ERP-0221 Records Management System 0 0 150,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0222 Body Worn Camera 5 0 0 0 0 0 165,000 0 0 0 0 0 0 0 0 175,000 0 0 0 214,500 0 0 ERP-0227 Police Equipment 3 25,000 0 0 25,000 0 0 27,318 0 0 29,851 0 0 32,619 0 0 35,644 0 0 38,949 0 0 EQUIPMENT SUBTOTAL 25,000 478,512 400,000 25,000 17,000 255,041 116,015 221,724 373,664 131,193 0 102,825 280,282 114,060 175,000 474,296 140,738 393,303 253,449 0 24,238 4,001,341 92 12/14/2021 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average:1,746,400$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 Total P.W. BLDG./EQUIPMENT SVCS ERP-0710 1/2 Ton Truck 10 0 0 0 0 42,100 0 0 0 0 0 0 0 53,331 0 0 0 0 0 0 0 67,558 ERP-0711 Vehicle Washer 12 0 0 0 0 0 0 0 8,300 0 0 0 0 0 0 0 0 0 0 0 11,500 0 ERP-0712 4x4 3/4 Ton Pick-up Truck 15 0 0 0 0 0 0 0 0 0 0 50,000 0 0 0 0 0 0 0 0 0 0 ERP-0714 PW - Truck Scan Kit 10 0 0 0 0 0 14,143 0 0 0 0 0 0 0 0 0 19,009 0 0 0 0 0 ERP-0715 PW - Forklift 15 0 0 0 0 0 0 0 0 0 0 0 36,714 0 0 0 0 0 0 0 0 0 0 0 0 0 42,100 14,143 0 8,300 0 0 50,000 36,714 53,331 0 0 19,009 0 0 0 11,500 67,558 302,655 P.W. ENGINEERING ERP-0700 Engineering Van 15 0 0 0 0 0 0 0 38,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 38,800 0 0 0 0 0 0 0 0 0 0 0 0 38,800 P.W. PARKS & FORESTRY ERP-0800 1/2 Ton Truck 10 0 35,400 0 0 0 0 0 0 0 0 0 47,600 0 0 0 0 0 0 0 0 0 ERP-0801 4x4 3/4 Ton Truck 8 0 0 0 0 0 0 108,000 0 0 0 0 0 0 0 136,811 0 0 0 0 0 0 ERP-0802 3/4 Ton Utility Truck 10 0 0 0 0 0 0 0 0 48,700 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0804 Log Truck (50% w/Refuse)20 81,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 254,884 0 0 0 0 ERP-0805 Aerial Lift 20 0 0 0 0 0 0 0 0 228,900 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0806 Tractor 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0807 Truckster 15 0 0 0 0 0 17,140 0 0 0 0 0 0 53,200 0 0 0 0 0 0 0 0 ERP-0808 Riding Mower 6 0 17,700 32,100 21,135 38,329 0 0 0 25,000 0 45,766 0 0 ERP-0810 Large Turf Mower (#825)10 0 0 0 0 0 0 121,609 0 0 0 0 0 0 0 154,050 0 0 0 0 0 0 ERP-0812 Stump Cutter 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76,032 0 0 0 0 0 ERP-0813 Brush Clipper 20 0 0 0 0 0 0 0 0 0 0 0 43,700 0 0 0 0 0 0 0 0 0 ERP-0814 Trailer Flatbed 15 0 0 10,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 15,580 0 0 0 ERP-0815 Skid Loader 12 0 0 0 0 0 0 0 45,600 0 0 0 0 0 0 0 0 0 0 0 65,014 0 ERP-0816 Toolcat 8 0 0 0 0 80,200 0 0 0 0 0 0 0 101,600 0 0 0 0 0 0 0 128,704 ERP-0817 Grass Seed Applicator 20 0 0 0 0 0 0 0 0 17,900 0 0 0 0 0 0 0 0 0 0 0 0 VEHICLES SUBTOTAL 0 117,200 10,000 0 97,900 17,140 261,709 45,600 295,500 0 21,135 91,300 193,129 0 290,861 76,032 279,884 15,580 45,766 65,014 128,704 2,052,454 P.W. STREETS/TRAFFIC ERP-0300 4x4 3/4 Ton Truck/Plow 10 0 28,900 0 0 0 0 0 0 0 0 0 38,800 0 0 0 0 0 0 0 0 0 ERP-0301 4x4 3/4 Ton Truck/Plow 8 0 0 0 0 38,500 0 0 0 0 0 0 0 0 48,800 0 0 0 0 0 ERP-0302 4x2 1 Ton Dump Truck 12 0 0 0 0 0 0 0 0 77,800 0 0 0 0 0 0 0 0 0 104,600 0 0 ERP-0303 1 Ton Dump Truck 12 53,400 0 49,500 0 0 0 0 0 0 0 0 0 76,100 0 0 0 0 0 0 0 0 ERP-0304 1 Ton Boom Truck 17 0 136,400 0 0 0 0 0 0 0 0 0 0 194,500 0 0 0 0 0 0 0 ERP-0305 Single Axle Dump Truck 17 225,000 0 0 0 0 0 0 0 210,600 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0306 Tandem Dump Truck 17 0 0 0 0 0 0 0 0 0 0 0 0 286,000 294,000 0 0 0 0 0 0 0 ERP-0307 Water Truck 22 0 0 0 0 0 0 0 0 0 201,000 0 0 0 0 0 0 0 0 0 0 0 ERP-0308 Front End Loader 15 0 268,600 0 0 268,000 0 0 0 0 0 0 0 0 0 0 0 418,500 0 0 0 ERP-0309 Skid Loader 12 50,000 0 0 0 0 0 59,700 0 0 0 0 0 71,300 0 0 0 0 0 0 0 0 ERP-0311 Sweeper 20 0 0 0 0 0 0 0 0 0 319,000 0 0 0 0 0 0 0 0 0 0 0 ERP-0312 Roller 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 82,000 0 0 0 0 0 ERP-0313 Striper 12 0 0 0 0 0 0 0 16,000 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0314 Paver 20 0 0 0 0 0 0 0 0 0 0 120,000 0 0 0 0 0 0 0 0 0 0 ERP-0315 Snow Blower 20 0 0 0 0 0 0 0 0 0 0 0 0 117,000 0 0 0 0 0 0 0 0 ERP-0316 Trailer 20 0 0 0 0 0 0 0 0 8,850 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0317 Sign Machine 10 0 0 0 0 18,100 0 0 0 0 0 0 0 0 0 24,323 0 0 0 0 0 0 ERP-0318 Asphalt Hot Mix Heating Box - Trailer 10 0 0 0 0 0 0 0 31,509 0 0 0 0 0 0 0 0 0 42,300 0 0 0 ERP-0319 Regenerative Air Sweeper 20 0 0 0 0 0 0 210,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0320 Planer 20 0 0 0 0 0 0 0 0 0 18,600 0 0 0 0 0 0 0 0 0 0 0 ERP-0321 Wheel Loader 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200,000 0 0 VEHICLES SUBTOTAL 328,400 165,300 318,100 0 18,100 306,500 269,700 47,509 297,250 538,600 120,000 38,800 550,400 488,500 24,323 130,800 0 460,800 304,600 0 0 4,407,682 HRA ERP-0400 4x4 3/4 Ton Truck 8 0 41,100 0 0 0 0 0 0 0 52,100 0 0 0 0 0 0 0 66,000 0 0 0 ERP-0401 Copier 8 16,500 0 0 0 0 0 0 0 20,900 0 0 0 0 0 0 0 26,500 0 0 0 0 SUBTOTAL 16,500 41,100 0 0 0 0 0 0 20,900 52,100 0 0 0 0 0 0 26,500 66,000 0 0 0 223,100 PAVILION ERP-1000 Ice Resurfacer 12 0 0 0 0 165,000 0 0 0 0 0 0 0 0 0 0 0 235,251 0 0 0 0 ERP-1001 Electric Ice Edger 12 0 0 0 0 8,900 0 0 0 0 0 0 0 0 0 11,961 0 0 0 0 0 0 ERP-1002 Arena Scoreboard 20 0 0 0 0 12,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-1003 Floor Scrubber 10 0 0 11,600 0 0 0 0 0 0 0 0 0 15,600 0 0 0 0 0 0 0 0 ERP-1004 Scissor Lift 15 0 0 0 0 0 0 0 16,200 0 0 0 0 0 0 0 0 0 0 0 0 0 SUBTOTAL 0 0 11,600 0 185,900 0 0 16,200 0 0 0 0 15,600 0 11,961 0 235,251 0 0 0 0 476,512 REFUSE ERP-0900 Refuse Truck (RAP-R)10 0 0 0 275,200 0 0 0 0 0 363,200 0 0 0 0 0 0 0 0 0 488,100 0 ERP-0901 Refuse Truck (Rear-L)15 0 0 0 0 0 0 0 0 0 0 136,500 0 0 0 0 0 0 0 0 0 ERP-0803 Swap Loader 20 0 0 0 0 0 0 0 0 0 0 0 171,000 0 0 0 0 0 0 0 0 0 ERP-0804 Log Truck (50% w/Forestry)20 81,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 SUBTOTAL 0 81,800 0 275,200 0 0 0 0 0 363,200 136,500 171,000 0 0 0 0 0 0 0 488,100 0 1,515,800 WATER ERP-0500 1./2 Ton Truck 10 0 0 0 0 0 36,000 0 0 0 0 0 0 0 0 0 48,381 0 0 0 0 0 ERP-0501 3/4 Ton Utility Truck 10 0 0 0 0 46,900 0 0 0 0 0 0 0 0 0 63,029 0 0 0 0 0 0 ERP-0502 Backhoe 20 0 0 0 0 0 0 0 0 0 0 153,700 0 0 0 0 0 0 0 0 0 0 ERP-0503 Air Compressor 15 0 0 0 0 0 0 0 0 0 0 0 0 40,000 0 0 0 0 0 0 0 0 ERP-0509 Water Treatment Plant 10 0 0 0 0 0 134,392 0 0 0 0 0 0 0 0 0 180,613 0 0 0 0 0 SUBTOTAL 0 0 0 0 46,900 170,392 0 0 0 0 153,700 0 40,000 0 63,029 228,994 0 0 0 0 0 703,015 SEWER ERP-0551 3/4 Ton Utility Truck 10 0 0 0 0 45,200 0 0 0 0 0 0 0 0 0 60,746 0 0 0 0 0 0 ERP-0552 Jet Vactor 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 750,000 0 0 0 0 0 ERP-0555 Generator 25 43,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0560 Televising Camera and Van 12 180,000 0 0 0 0 0 0 0 0 0 0 0 256,600 0 0 0 0 0 0 0 0 SUBTOTAL 223,000 0 0 0 45,200 0 0 0 0 0 0 0 256,600 0 60,746 750,000 0 0 0 0 0 1,335,546 93 12/14/2021 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average:1,746,400$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 Total GENERAL FUND-VEHICLES/EQUIP 1,281,500 399,900 445,500 181,554 432,200 2,351,640 2,231,409 305,315 868,455 826,057 1,394,335 364,568 1,058,927 645,500 555,820 3,057,215 572,639 651,380 530,366 446,440 1,935,424 20,536,144 GENERAL FUND-OTHER EQUIP 303,729 962,197 629,954 1,260,035 386,470 513,359 361,484 572,088 735,320 580,682 1,281,343 476,850 534,220 975,178 688,797 830,630 558,909 1,879,156 691,022 516,593 494,331 15,232,348 HRA 16,500 41,100 0 0 0 0 0 0 20,900 52,100 0 0 0 0 0 0 26,500 66,000 0 0 0 223,100 ARTS CENTER 13,500 0 6,700 10,800 7,100 0 0 16,600 0 0 0 0 9,000 14,516 20,415 0 10,123 0 0 0 0 108,754 REFUSE - 81,800 0 275,200 0 0 0 0 0 363,200 136,500 171,000 0 0 0 0 0 0 0 488,100 0 1,515,800 PAVILION - 0 11,600 0 185,900 0 0 16,200 0 0 0 0 15,600 0 11,961 0 235,251 0 0 0 0 476,512 WATER - 0 0 0 46,900 170,392 0 0 0 0 153,700 0 40,000 0 63,029 228,994 0 0 0 0 0 703,015 SEWER 223,000 0 0 0 45,200 0 0 0 0 0 0 0 256,600 0 60,746 750,000 0 0 0 0 0 1,335,546 GENERAL FUND TOTAL 1,585,229 1,362,097 1,075,454 1,441,589 818,670 2,864,999 2,592,893 877,403 1,603,775 1,406,739 2,675,678 841,418 1,593,147 1,620,678 1,244,617 3,887,845 1,131,548 2,530,536 1,221,388 963,033 2,429,755 35,768,492 HRA TOTAL 16,500 41,100 0 0 0 0 0 0 20,900 52,100 0 0 0 0 0 0 26,500 66,000 0 0 0 223,100 ARTS CENTER FUND TOTAL 13,500 0 6,700 10,800 7,100 0 0 16,600 0 0 0 0 9,000 14,516 20,415 0 10,123 0 0 0 0 108,754 ENTERPRISE FUNDS TOTAL 223,000 81,800 11,600 275,200 278,000 170,392 0 16,200 0 363,200 290,200 171,000 312,200 0 135,736 978,994 235,251 0 0 488,100 0 4,030,873 TOTAL ALL FUNDS 1,838,229 1,484,997 1,093,754 1,727,589 1,103,770 3,035,391 2,592,893 910,203 1,624,675 1,822,039 2,965,878 1,012,418 1,914,347 1,635,194 1,400,768 4,866,839 1,403,422 2,596,536 1,221,388 1,451,133 2,429,755 40,131,219 GENERAL FUND SALVAGE 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 840,000 NET GENERAL FUND 1,545,229 1,322,097 1,035,454 1,401,589 778,670 2,824,999 2,552,893 837,403 1,563,775 1,366,739 2,635,678 801,418 1,553,147 1,580,678 1,204,617 3,847,845 1,091,548 2,490,536 1,181,388 923,033 2,389,755 34,928,492 20 YEAR AVERAGES:Total Average ACTIVITY CENTER ADMINISTRATION 270,128 13,500 IT 8,024,091 401,200 0 COMMUNITY SERVICES 226,481 11,300 FIRE EQUIPMENT 9,297,916 464,900 FIRE ADMINISTRATION 2,620,642 131,000 POLICE EQUIPMENT 4,526,303 226,300 POLICE ADMINISTRATION 4,001,341 200,100 PUBLIC WORKS ADMINISTRATION 0 0 BLDG./EQUIPMENT SERVICES EQUIPMENT 302,655 15,100 ENGINEERING EQUIPMENT 38,800 1,900 PARKS/FORESTRY EQUIPMENT 2,052,454 102,600 STREET EQUIPMENT 4,407,682 220,400 GENERAL FUND VEHICLE/EQUIPMENT 20,625,810 1,031,300 GENERAL FUND OTHER EQUIPMENT 15,142,682 757,100 GENERAL FUND TOTAL 35,768,492 1,788,400 HRA FUND 223,100 11,200 ARTS CENTER FUND 108,754 5,400 REFUSE FUND 1,515,800 75,800 PAVILION FUND 476,512 23,800 WATER FUND 703,015 35,200 SEWER FUND 1,335,546 66,800 UTILITY VEHICLES/EQUIPMENT 4,362,727 218,100 40,131,219 - 94 EQUIPMENT INVENTORY 95 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2021 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 2021 FORD UTILITY 57,000 202 2021 FORD UTILITY 57,000 205 2020 FORD UTILITY 54,000 206 2020 FORD UTILITY 54,000 207 2021 FORD UTILITY 57,000 208 2021 FORD UTILITY 57,000 209 2018 FORD UTILITY 49,000 211 2021 FORD UTILITY 57,000 213 2020 CHEVROLET BLAZER 54,000 214 2018 FORD EXPLORER 49,000 216 2011 FORD TAURUS 30,000 218 2013 FORD UTILITY BLUE 40,000 219 2013 FORD TAURUS 24,000 220 2017 FORD EXPLORER 50,000 221 2019 FORD EXPLORER 55,000 240 2017 FORD TRANSIT-350 67,000 299 2021 FORD F150 60,000 DWI.2016 FORD UTILITY 49,000 96 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2021 UNIT #YEAR MAKE MODEL VALUE STREET/TRAFFIC DIVISION 301 2013 FORD F-150 19,500$ 302 2018 FORD F350 DRW 54,600 303 2016 FORD F-250 26,500 307 2006 FORD F-350 27,400 308 2011 FORD F-350 20,300 309 2012 FORD F-450 30,300 311 2011 FREIGHTLINER M2-106V 79,400 312 2004 FREIGHTLINER M2-106 98,000 315 2017 FREIGHTLINER 114SD 221,700 317 2016 FREIGHTLINER M2-106 69,400 318 2019 FREIGHTLINER 114SD 235,000 320 2020 CATERPILLAR 926M 232,000 321 2012 CATERPILLAR 924K 177,500 322 2005 CATERPILLAR 938G 157,800 325 2011 BOBCAT S-650 35,100 327 2019 ELGIN PELICAN 230,000 328 2013 ISUZU 435 REGEN SWEEP 145,300 329 2017 BOMAG BW120 SL5 ROLLE 45,900 331 2016 BOBCAT S-650 35,100 337 1994 CATERPILLAR AP200B 17,000 344 1996 SNO-GO WK800 58,000 346 2017 SNO- GO SG WK-800 160,000 348 2014 SPARKS T6202 TRAILER 5,300 350 1993 TOWMASTER T14 TRAILER 4,000 351 2004 TENNANT SWEEPER 3640 10,000 352 2017 FALCON PATCH TRAILER 15,000 ENGINEERING DIVISION 706 2015 FORD TRANSIT 250 24,000$ BUILDING MAINTENANCE & EQUIPMENT SERVICES 701 2016 FORD UTILITY 34,000$ 702 2004 FORD F350 18,000 703 2015 FORD UTILITY 35,000 705 2018 FORD F350 30,000 706 2015 FORD TRANSIT 250 29,700 707 2020 FORD F250 35,000 712 2015 FORD UTILITY 35,000 713 2014 FORD UTILITY 30,000 750 2018 CLARK GTS25-FORKLIFT 25,000 97 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2021 UNIT #YEAR MAKE MODEL VALUE PARKS/FORESTRY DIVISION 800 2013 FORD F-150 23,700$ 801 2012 FORD F-350 24,100 804 1995 CHEVROLET CC31403 45,000 806 2016 FORD TRANSIT 350 29,700 807 2006 FORD F250 18,000 811 2006 INTERNATIONAL LOG TRUCK 45,000 812 2010 FREIGHTLINER AERIAL LIFT 130,000 813 2019 FREIGHTLINER M2-106 235,000 814 2020 FORD F350 43,000 815 2020 FORD F350 43,000 816 2014 BOBCAT 5610 50,900 817 2018 BOBCAT 5600 63,300 818 2017 TORO WORKMAN HDX 13,000 820 2004 TORO WORKMAN 3200 15,000 822 2014 TORO MDE 18,000 824 2020 TORO GM4000 68,000 825 2021 TORO Z MASTER 6000 15,000 826 2021 TORO Z MASTER 7500 35,000 828 2001 DEWEZE ATM-72 21,000 829 2016 TORO 3280-D 10,000 831 2016 RAYCO RG45X 3,400 834 2013 VERMEER BRUSH CHIPPER 29,800 835 2016 BOBCAT S70 55,000 843 2007 CARR TRAILER 2,500 844 2010 FELLING FT-6T 6,000 845 1997 REMACKEL DT-D7-E 3,500 846 2001 DRESSEN 8110 2,000 848 2017 LOAD TRAIL TILT DECK 5,400 98 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2021 UNIT #YEAR MAKE MODEL VALUE WATER/SEWER 502 2017 FORD F-150 SUPERCAB 28,000 503 2015 FORD F-350 24,000 508 2016 FORD TRANSIT CONNECT 25,000 509 2016 FORD F-350 65,000 510 2016 FORD F-350 30,000 531 2017 FREIGHTLINER 114SD 425,400 533 2012 CATERPILLAR 420-EH2 87,700 535 1992 KOHLER GEN/TRL 10,000 537 2010 CATERPILLAR C15 144,300 PAVILION 802 2012 FORD F-350 20,000$ 808 2014 ZAMBONI 552 126,000 809 2002 OLYMPIA MILLINEUM 87,800 REFUSE 902 2015 FREIGHTLINER M2-106 232,500 903 2015 PETERBILT REAR LOADER 155,000 905 2021 FREIGHTLINER M2-106 217,572 99