The URL can be used to link to this page

2023-2027 Equipment Replacement Plan EQUIPMENT REPLACEMENT PLAN 2023-2027 DATE: September 6, 2022 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2023-2027 EQUIPMENT REPLACEMENT PLAN W ith this letter, I respectfully submit the 2023-2027 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 2022 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 25 Community Services - IT 27 Community Services - Inspections 40 Fire 41 Pavilion 51 Police 55 Public Works 68 Refuse 83 Water/Sewer 84 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 92 Equipment Inventory 96 EQUIPMENT REPLACEMENT PLAN 2023-2027 TABLE OF CONTENTS 3 4 INTRODUCTION 5 EQUIPMENT REPLACEMENT PLAN 2023-2027 BACKGROUND AND SUMMARY OF CHANGES FROM 2022 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 2023 by 6% and will be increased by 6% in 2024 through 2027. 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 for the next five years. 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 $900,000 in 2022 and are planned to be sold in 2023 and 2024 for the replacement of a log truck, and front end loader. 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. 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 6 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 2022-2026 Plan Highlights of changes from last year’s equipment replacement plan for the years 2023-2027: CS - Activity Center: Kitchen Storage Equipment project was removed for $12,000 CS - Arts Center: Theater Projection Screen was removed for 6,700 Jaycee Studio Audio Visual was added for $13,500 CS - IT: Network Infrastructure Upgrades were added for $130,000 Patching Automation Software was increased for $108,091 Community Services: No changes Fire: Station Alerting System was increased from $75,000 to $100,000 Self Contained Breathing Apparatus increased from $250,000 to $300,000 Portable and Mobile Radios increased from $386,000 to $455,000 Police: Administrative vehicles (2) added for $70,000 Records Management was increased from $150,000 to $200,000 Taser Replacement was increased from $90,000 to $$140,000 Public Works: Building/Equipment Services No Changes Engineering No Changes Parks/Forestry No Changes Streets/Traffic Supervisor Vehicle added for $35,000 Refuse No changes Sewer/Water Supervisor Vehicle added for $35,000 7 8 CASH FLOW STATEMENT 9 City of Hopkins Equipment Replacement Fund (602) Rate Change 6%6%6%6%6%6% PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2022 2023 2024 2025 2026 2027 Working Capital Begin Year 784,628 845,691 415,956 845,691 255,136 462,221 Revenues from charges 669,755 709,940 752,536 797,688 845,549 896,282 Tax Levy - 250,000 250,000 250,000 250,000 250,000 Federal Grant - - - - Interest earnings 785 9,906 5,609 4,228 1,276 3,000 Other revenues (sale of assets)15,000 35,000 35,000 35,000 35,000 35,000 Equipment Certificates (Bonds)996,000 81,800 318,100 136,400 - 1,900,000 Transfer In - 220,564 - - - - Total Revenues 1,681,540 1,307,210 1,361,245 1,223,316 1,131,825 3,084,282 Expenditures (excludes Leases & Depr.) 35,248 35,600 35,956 36,316 36,679 37,046 Capital Outlay - Equipment 1,585,229 1,701,345 895,554 1,777,555 888,061 2,733,673 Total Expenses 1,620,477 1,736,945 931,510 1,813,871 924,740 2,770,719 Working Capital Ending Balance 845,691 415,956 845,691 255,136 462,221 775,784 (Unrestricted Net Position) 10 FIVE-YEAR PROJECT SUMMARIES 1111 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY YEAR 2023 2027thru Project Name Department Project #Priority Project Cost 2023 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-0009Network Infrastructure Upgrade - Fiber n/a 60,000Comm 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 33,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 38,000Fire 01-ERP-0127Fire - Lucus Device n/a 18,000Fire 01-ERP-0131Fire - Station Alerting System n/a 100,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 120,000Police 01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 81,160Police 01-ERP-0215Police - Portable Radios n/a 290,000Police 01-ERP-0217Taser Replacement n/a 140,000Police 01-ERP-0218Building Video Server n/a 22,000Police 01-ERP-0221Records Management System n/a 200,000Police 01-ERP-0227Police Equipment n/a 25,000Police 01-ERP-0228Administrative Vehicles n/a 70,000Police 01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry 01-ERP-0804Log Truck n/a 163,600Public Works: Parks/Forestry 01-ERP-03004x4 1/2 Ton Pickup with Plow n/a 28,900Public Works: Streets/Traffic 01-ERP-0322Streets/Parks Supervisor Vehicle 1 35,000Public Works: Streets/Traffic 01-ERP-0510Utilities Supervisor Vehicle n/a 35,000Water 1,831,745Total for 2023 2024 01-ERP-1105Art Center Jaycee Studio Audio Visual n/a 13,500Comm 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 36,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 120,000Police 01-ERP-0212Squad Car Camera Systems n/a 70,000Police 01-ERP-0220Squad Computers n/a 90,000Police 01-ERP-0228Administrative Vehicles n/a 35,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 Wednesday, August 3, 2022 12 Project Name Department Project #Priority Project Cost 01-ERP-0555Generator (2)n/a 43,000Sewer 967,154Total 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-0009Network Infrastructure Upgrade - Fiber n/a 70,000Comm 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 40,000Comm 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 300,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 18,600Fire 01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 455,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 120,000Police 01-ERP-0201Sergeant's Vehicle n/a 65,000Police 01-ERP-03041 Ton Traffic Boom Truck n/a 136,400Public Works: Streets/Traffic 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 275,200Refuse 2,063,555Total for 2025 2026 01-ERP-0035Activity Center - Floor Scrubber n/a 6,700Comm Svcs - Activity 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 40,000Comm 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 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 130,000Police 01-ERP-0202PSO / Parking Enforcement Vehicle n/a 65,000Police 01-ERP-0203PSO - Utility 4x4 n/a 86,100Police 01-ERP-0218Building Video Server n/a 25,000Police 01-ERP-0227Police Equipment n/a 25,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,166,061Total for 2026 2027 01-ERP-0003CH - Network Server n/a 29,545Comm Svcs - IT 01-ERP-0006Computers n/a 41,042Comm Svcs - IT Wednesday, August 3, 2022 13 Project Name Department Project #Priority Project Cost 01-ERP-0017IT - Office 365 n/a 49,522Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 40,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 45,895Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 29,545Comm Svcs - IT 01-ERP-0100Tele-Squirt (Engine 2)n/a 1,000,000Fire 01-ERP-0101Fire Pumper (Engine 3)n/a 900,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 20,000Fire 01-ERP-0114Floor Scrubber n/a 20,300Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 130,000Police 01-ERP-0217Taser Replacement n/a 90,041Police 01-ERP-0714PW - Truck Scan Kit 1 14,143Public Works: Bldg/Equip Serv 01-ERP-0807Trucksters (3)n/a 17,140Public Works: Parks/Forestry 01-ERP-03014X4 3/4 Ton Truck with Plow n/a 38,500Public Works: Streets/Traffic 01-ERP-0308Front End Loaders (2)n/a 268,000Public Works: Streets/Traffic 01-ERP-05003/4 Ton Truck n/a 36,000Water 01-ERP-0509Water Treatment Plant 1 134,392Water 2,904,065Total for 2027 GRAND TOTAL 8,932,580 Wednesday, August 3, 2022 14 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2023 2027thru Total20232024202520262027Department Comm Svcs - Activity Center 6,7006,700 Comm Svcs - Arts Center 24,30013,500 10,800 Comm Svcs - IT 1,941,173429,685 255,954 666,324 353,661 235,549 Community Services 16,23116,231 Fire 2,908,400156,000 773,600 38,500 1,940,300 Pavilion 197,50011,600 185,900 Police 1,999,301948,160 315,000 185,000 331,100 220,041 Public Works: Bldg/Equip Serv 56,24342,100 14,143 Public Works: Parks/Forestry 324,040199,000 10,000 97,900 17,140 Public Works: Streets/Traffic 843,00063,900 318,100 136,400 18,100 306,500 Refuse 275,200275,200 Sewer 88,20043,000 45,200 Water 252,29235,000 46,900 170,392 1,831,745 967,154 2,063,555 1,166,061 2,904,065 8,932,580TOTAL Wednesday, August 3, 202215 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2023 2027thru Total20232024202520262027DepartmentProject #Priority Comm Svcs - Activity Center 01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a 6,7006,700Comm Svcs - Activity Center Total Comm Svcs - Arts Center 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 24,30013,500 10,800Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0009 130,00060,000 70,000Network Infrastructure Upgrade - Fiber n/a 01-ERP-0024 45,00045,000IT - Sandbox Security Appliance n/a 01-ERP-0022 238,71342,000 63,000 43,260 44,558 45,895IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0020 189,00033,000 36,000 40,000 40,000 40,000IT - Patching Automation Software 1 01-ERP-0017 233,60244,000 45,320 46,680 48,080 49,522IT - Office 365 n/a 01-ERP-0015 150,92872,120 78,808Backup Server n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0211 139,36626,250 27,038 27,849 28,684 29,545PD - Network Server n/a 01-ERP-0006 193,59936,465 37,559 38,686 39,847 41,042Computersn/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0004 89,60089,600Telephone System n/a 01-ERP-0003 139,36526,250 27,037 27,849 28,684 29,545CH - Network Server n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 1,941,173429,685 255,954 666,324 353,661 235,549Comm Svcs - IT Total Community Services 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 16,23116,231Community Services Total Fire 01-ERP-0114 20,30020,300Floor Scrubber n/a 01-ERP-0131 100,000100,000Fire - Station Alerting System n/a 01-ERP-0100 1,000,0001,000,000Tele-Squirt (Engine 2)n/a 01-ERP-0125 455,000455,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a 01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a 01-ERP-0109 38,00038,000Extrication Tool (1)n/a 01-ERP-0108 300,000300,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0101 900,000900,000Fire Pumper (Engine 3)n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 2,908,400156,000 773,600 38,500 1,940,300Fire Total Wednesday, August 3, 202216 Total20232024202520262027DepartmentProject #Priority 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-0201 65,00065,000Sergeant's Vehicle n/a 01-ERP-0202 65,00065,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0200 620,000120,000 120,000 120,000 130,000 130,000Marked Patrol Vehicles (7)n/a 01-ERP-0228 105,00070,000 35,000Administrative Vehicles n/a 01-ERP-0221 200,000200,000Records Management System n/a 01-ERP-0218 47,00022,000 25,000Building Video Server n/a 01-ERP-0217 230,041140,000 90,041Taser Replacement n/a 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0214 81,16081,160Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0212 70,00070,000Squad Car Camera Systems n/a 01-ERP-0203 86,10086,100PSO - Utility 4x4 n/a 01-ERP-0227 50,00025,000 25,000Police Equipment n/a 1,999,301948,160 315,000 185,000 331,100 220,041Police Total Public Works: Bldg/Equip Serv 01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a 01-ERP-0714 14,14314,143PW - Truck Scan Kit 1 56,24342,100 14,143Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry 01-ERP-0807 17,14017,140Trucksters (3)n/a 01-ERP-0808 17,70017,700Riding Mowers (2)1 01-ERP-0816 80,20080,200Toolcatn/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0814 10,00010,000Trailer Flatbed n/a 324,040199,000 10,000 97,900 17,140Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0308 536,600268,600 268,000Front End Loaders (2)n/a 01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0303 49,50049,5001 Ton Dump Truck (2)n/a 01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0322 35,00035,000Streets/Parks Supervisor Vehicle 1 843,00063,900 318,100 136,400 18,100 306,500Public Works: Streets/Traffic Total Refuse 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a 275,200275,200Refuse Total Wednesday, August 3, 202217 Total20232024202520262027DepartmentProject #Priority Sewer 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 88,20043,000 45,200Sewer Total Water 01-ERP-0510 35,00035,000Utilities Supervisor Vehicle n/a 01-ERP-0500 36,00036,0003/4 Ton Truck n/a 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 01-ERP-0509 134,392134,392Water Treatment Plant 1 252,29235,000 46,900 170,392Water Total GRAND TOTAL 8,932,5801,831,745 967,154 2,063,555 1,166,061 2,904,065 Wednesday, August 3, 202218 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2023 thru 2027 TotalSource20232024202520262027 AC - Arts Center Fund 24,30013,500 10,800 Equipment Replacement Fund 7,996,1881,701,345 895,554 1,777,555 888,061 2,733,673 PA - Pavilion Fund 197,50011,600 185,900 PKG - Parking Fund 3,5003,500 RF - Refuse Fund 357,00081,800 275,200 SF - Sanitary Sewer Fund 112,50024,300 43,000 45,200 WF - Water Fund 241,59224,300 46,900 170,392 1,831,745 967,154 2,063,555 1,166,061 2,904,065 8,932,580GRAND TOTAL Wednesday, August 3, 2022 19 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2023 2027thru TotalSourceProject #Priority 2023 2024 2025 2026 2027 AC - Arts Center Fund 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 24,30013,500 10,800AC - Arts Center Fund Total Equipment Replacement Fund 01-ERP-0003 139,36526,250 27,037 27,849 28,684 29,545CH - 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 193,59936,465 37,559 38,686 39,847 41,042Computersn/a 01-ERP-0009 130,00060,000 70,000Network Infrastructure Upgrade - Fiber 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 233,60244,000 45,320 46,680 48,080 49,522IT - Office 365 n/a 01-ERP-0020 189,00033,000 36,000 40,000 40,000 40,000IT - Patching Automation Software 1 01-ERP-0022 238,71342,000 63,000 43,260 44,558 45,895IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0024 45,00045,000IT - Sandbox Security Appliance n/a 01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 01-ERP-0100 1,000,0001,000,000Tele-Squirt (Engine 2)n/a 01-ERP-0101 900,000900,000Fire Pumper (Engine 3)n/a 01-ERP-0108 300,000300,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0109 38,00038,000Extrication Tool (1)n/a 01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a 01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a 01-ERP-0114 20,30020,300Floor Scrubber n/a 01-ERP-0125 455,000455,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0131 100,000100,000Fire - Station Alerting System n/a 01-ERP-0200 620,000120,000 120,000 120,000 130,000 130,000Marked Patrol Vehicles (7)n/a 01-ERP-0201 65,00065,000Sergeant's Vehicle n/a 01-ERP-0202 65,00065,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 86,10086,100PSO - Utility 4x4 n/a 01-ERP-0211 139,36626,250 27,038 27,849 28,684 29,545PD - Network Server n/a 01-ERP-0212 66,50066,500Squad Car Camera Systems n/a 01-ERP-0214 81,16081,160Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 230,041140,000 90,041Taser Replacement n/a 01-ERP-0218 47,00022,000 25,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0221 200,000200,000Records Management System n/a 01-ERP-0227 50,00025,000 25,000Police Equipment n/a 01-ERP-0228 105,00070,000 35,000Administrative Vehicles n/a Wednesday, August 3, 2022 20 TotalSourceProject #Priority 2023 2024 2025 2026 2027 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a 01-ERP-0303 49,50049,5001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0308 536,600268,600 268,000Front End Loaders (2)n/a 01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a 01-ERP-0322 35,00035,000Streets/Parks Supervisor Vehicle 1 01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a 01-ERP-0714 14,14314,143PW - Truck Scan Kit 1 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0807 17,14017,140Trucksters (3)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 7,996,1881,701,345 895,554 1,777,555 888,061 2,733,673Equipment Replacement Fund 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 3,5003,500Squad Car Camera Systems n/a 3,5003,500PKG - 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-0510 17,50017,500Utilities Supervisor Vehicle n/a 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 112,50024,300 43,000 45,200SF - Sanitary Sewer Fund Total WF - Water Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0500 36,00036,0003/4 Ton Truck n/a 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 01-ERP-0509 134,392134,392Water Treatment Plant 1 01-ERP-0510 17,50017,500Utilities Supervisor Vehicle n/a Wednesday, August 3, 2022 21 TotalSourceProject #Priority 2023 2024 2025 2026 2027 241,59224,300 46,900 170,392WF - Water Fund Total 8,932,5801,831,745 967,154 2,063,555 1,166,061 2,904,065GRAND TOTAL Wednesday, August 3, 2022 22 EQUIPMENT REQUESTS 2123 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2023 2027 thru 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 years Project Name Activity Center - Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$20,700 Total2023 2024 2025 2026 2027Expenditures 6,7006,700Equipment 6,700 6,700Total Total2023 2024 2025 2026 2027Funding Sources 6,7006,700Equipment Replacement Fund 6,700 6,700Total Wednesday, August 3, 2022 24 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2023 2027 thru Department Comm Svcs - Arts Center Description Install a projector in a ceiling mount. Wire speakers into the ceiling. Wire input for computer on front wall. Add two microphones. Mount supporting hardware in rack that fits into closet. Originally scheduled for the Community Room this project was moved to the Jaycee Studio as they found a greater need for this equipment in that room. Project #01-ERP-1105 Priority n/a Justification An increasing number of users of this room require media support. Current means of providing this include the use of an oversized A/V cart, cords stretch across the floor and a large speaker on a stick. We can streamline the appearance and functionality by making these appropriate changes. These changes also address safety concerns. They will help attract safety concerns. They will help attract and retain rental customers as well as appropriately support our own activities. Budget Impact/Other Move this item from 2014 to 2015. Useful Life 7 years Project Name Art Center Jaycee Studio Audio Visual Category Equipment Type Equipment Future Total Project Cost:$61,515 Total2023 2024 2025 2026 2027Expenditures 13,50013,500Equipment 13,500 13,500Total Total2023 2024 2025 2026 2027Funding Sources 13,50013,500AC - Arts Center Fund 13,500 13,500Total Wednesday, August 3, 2022 25 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2023 2027 thru Department Comm Svcs - Arts Center Description 26-inch auto scrubber Project #01-ERP-1109 Priority n/a Justification Current scrubber has reached its lifetime and no longer spins fast enough to be effective. Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $-0- Useful Life 10 years Project Name Art Center Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$33,316 Total2023 2024 2025 2026 2027Expenditures 10,80010,800Equipment 10,800 10,800Total Total2023 2024 2025 2026 2027Funding Sources 10,80010,800AC - Arts Center Fund 10,800 10,800Total Wednesday, August 3, 2022 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description The network server is the hub of the network. New computers are faster and more reliable. Project #01-ERP-0003 Priority n/a Justification Networking allows user to share information that is stored in a single location, the network server. This is more efficient because the information does not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every user is working with the same data. Budget Impact/Other Changes reflect anticipated need for increased storage. Useful Life 1 year Project Name CH - Network Server Category Equipment Type Equipment Future Total Project Cost:$1,113,900 Total2023 2024 2025 2026 2027Expenditures 139,36526,250 27,037 27,849 28,684 29,545Equipment 26,250 27,037 27,849 28,684 29,545 139,365Total Total2023 2024 2025 2026 2027Funding Sources 139,36526,250 27,037 27,849 28,684 29,545Equipment Replacement Fund 26,250 27,037 27,849 28,684 29,545 139,365Total Wednesday, August 3, 2022 27 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Project #01-ERP-0004 Priority n/a Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Budget Impact/Other Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015. Estimate salvage/resale value on replaced item: $ Useful Life 8 years Project Name Telephone System Category Equipment Type Equipment Future Total Project Cost:$490,131 Total2023 2024 2025 2026 2027Expenditures 89,60089,600Equipment 89,600 89,600Total Total2023 2024 2025 2026 2027Funding Sources 76,00076,000Equipment Replacement Fund 6,8006,800SF - Sanitary Sewer Fund 6,8006,800WF - Water Fund 89,600 89,600Total Wednesday, August 3, 2022 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2023 2027 thru Department Comm Svcs - IT Description Finance software upgrade. Software currently used by Finance, City Clerk, Inspections and Public Works. This includes software for all finance applications including general ledger, payroll, accounts payable, accounts receivable, fixed assets, utility billing; Business Licenses, Building Permits, GIS Mapping, Purchasing, etc. Project #01-ERP-0005 Priority n/a Justification Current software vendor is unable to keep up with technology and internet security standards. Staff is often frustrated with how the software works and are often unable to get reports they need from the system. Budget Impact/Other Variance from 20 year plan - replacement needed in 2014 Estimate salvage/resale value on replaced item: $-0- Useful Life 7 years Project Name Financial Software - Various Depts.Category Equipment Type Equipment Future Total Project Cost:$1,593,000 Total2023 2024 2025 2026 2027Expenditures 315,000315,000Equipment 315,000 315,000Total Total2023 2024 2025 2026 2027Funding Sources 315,000315,000Equipment Replacement Fund 315,000 315,000Total Wednesday, August 3, 2022 29 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Project #01-ERP-0006 Priority n/a Justification Tools enabling staff to perform job responsibilities efficiently and effectively. Budget Impact/Other Increase in expenditure a result of supporting more computers than when the original allotment was put in place. Useful Life 3-5 years Project Name Computers Category Equipment Type Equipment Future Total Project Cost:$1,852,679 Total2023 2024 2025 2026 2027Expenditures 193,59936,465 37,559 38,686 39,847 41,042Equipment 36,465 37,559 38,686 39,847 41,042 193,599Total Total2023 2024 2025 2026 2027Funding Sources 193,59936,465 37,559 38,686 39,847 41,042Equipment Replacement Fund 36,465 37,559 38,686 39,847 41,042 193,599Total Wednesday, August 3, 2022 30 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Install fiber and related equipment to maintain and add reduncancy Project #01-ERP-0009 Priority n/a Justification Improve capacity, coverage and reliability. 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 years Project Name Network Infrastructure Upgrade - Fiber Category Equipment Type Equipment Future Total Project Cost:$145,000 Total2023 2024 2025 2026 2027Expenditures 130,00060,000 70,000Equipment 60,000 70,000 130,000Total Total2023 2024 2025 2026 2027Funding Sources 130,00060,000 70,000Equipment Replacement Fund 60,000 70,000 130,000Total Wednesday, August 3, 2022 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates fiber optic network connection to fire department. 2 - Cisco 3560E-24PD managed switch - $3,000 each 2 - Cisco X2-10GB-LR fiber optic transceiver - $1200 each cost listed is for equipment only and does not include tax, shipping and other related costs Project #01-ERP-0012 Priority n/a Justification Current two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in significant network outage that was immediately noticed by many employees. Budget Impact/Other Variance from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside the budget for city hall server network budget as the "Lisa" service is scheduled for replacement due to end of life, out of PCI compliance and obsolete. 2015 - change amount from $12,000 to $17,000 - more expensive than originally thought based on 2015 replacement. Estimate salvage/resale value on replace item: - $-0- Useful Life 6 years Project Name Core Network Switch Category Equipment Type Equipment Future Total Project Cost:$133,878 Total2023 2024 2025 2026 2027Expenditures 20,00020,000Equipment 20,000 20,000Total Total2023 2024 2025 2026 2027Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Wednesday, August 3, 2022 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description We have 25 distribution network switches in our enterprise environment along with fiber optic transceivers and direct attach sfp cables to connect them. Distribution switches connect to the core switches and bring the data to the actual endpoints such as desktops, servers, telephones, and copiers. Project #01-ERP-0014 Priority n/a Justification Replacement of these switches with current technology is vital to the function of the network as well as the safety of the data being passed through the switch. Budget Impact/Other 2016 - New item in ERP Useful Life 5 years Project Name Distribution Network Switches Category Equipment Type Equipment Future Total Project Cost:$338,486 Total2023 2024 2025 2026 2027Expenditures 57,00057,000Equipment 57,000 57,000Total Total2023 2024 2025 2026 2027Funding Sources 57,00057,000Equipment Replacement Fund 57,000 57,000Total Wednesday, August 3, 2022 33 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Group of Dell servers to run Dell Rapid Recovery software to backup city computers and servers, along with Windows and VMWare licsensing required to run the servers. Project #01-ERP-0015 Priority n/a Justification Backup servers are essential to keep the electronic data for the city safe. We have overgrown our current system and are not able to backup everything that needs to be backed up in a timely manor. Additinally restores on the curent system take hours to days. If we needed to restore a critical server from backup, we would be looking at an unacceptable amount of downtime. Budget Impact/Other Useful Life 3 years Project Name Backup Server Category Equipment Type Equipment Future Total Project Cost:$801,110 Total2023 2024 2025 2026 2027Expenditures 150,92872,120 78,808Equipment 72,120 78,808 150,928Total Total2023 2024 2025 2026 2027Funding Sources 150,92872,120 78,808Equipment Replacement Fund 72,120 78,808 150,928Total Wednesday, August 3, 2022 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Transition from the legacy model of Microsoft Office to Office 365. This project would transition 25 percent of our users and devices per year. Project #01-ERP-0017 Priority n/a Justification As we become a more mobile workforce embracing new mobile and remote technology we need to move away from the traditonal office that can only be installed on a Windows computer and transition to the version of Office that can be used in the cloud and as a mobile app. Unfortunately, as is becoming common with most enterprise softwre, you can no longer just purchase it out right, you must rent it from the software author. The cost for Office 365 will now be a yearly ongoing cost. Office 365 is common at other cities, corporations, and educational environments. Budget Impact/Other Useful Life 1 year Project Name IT - Office 365 Category Equipment Type Equipment Future Total Project Cost:$2,420,118 Total2023 2024 2025 2026 2027Expenditures 233,60244,000 45,320 46,680 48,080 49,522Equipment 44,000 45,320 46,680 48,080 49,522 233,602Total Total2023 2024 2025 2026 2027Funding Sources 233,60244,000 45,320 46,680 48,080 49,522Equipment Replacement Fund 44,000 45,320 46,680 48,080 49,522 233,602Total Wednesday, August 3, 2022 35 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Software to automate the delivery of critical and maintenance patches to our enterprise endpoints and yearly maintenance of the software going forward. Project #01-ERP-0020 Priority 1 Urgent Justification Microsoft software has to be patched the second Tuesday of every month. Adobe software has to be patched every time a critical vulnerability is discovered, which can be twice in a week in a bad week. Other applications have to be patched as new releases are produced from vendors. Currently our staff must touch every endpoint for the majority of the software installs. We are using up an inordinate amount of staff time to patch all of our endpoints only to have to restart the cycle 3 weeks later. Automation of this process would free up staff time to work on other projects and problems for the city. Approx. two full weeks of 1FTE per month or 960 hours per year saved. Budget Impact/Other Useful Life 1 year Project Name IT - Patching Automation Software Category Equipment Type Equipment Future Total Project Cost:$458,333 Total2023 2024 2025 2026 2027Expenditures 189,00033,000 36,000 40,000 40,000 40,000Equipment 33,000 36,000 40,000 40,000 40,000 189,000Total Total2023 2024 2025 2026 2027Funding Sources 189,00033,000 36,000 40,000 40,000 40,000Equipment Replacement Fund 33,000 36,000 40,000 40,000 40,000 189,000Total Wednesday, August 3, 2022 36 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Upgrade Windows 10 Pro software to Windows 10 Enterprise. Required to renew every 3 years. This plan would bring the PD into compliance in 2020 then upgrade 60 city computers a year until all city computers are upgraded. Each batch of 60 computers needs to be renewed every 3 years. It is estimated that it will take 3 years to fully upgrade the city to Windows 10 Enterprise. Project #01-ERP-0022 Priority n/a Justification The BCA has mandated that we move to Enterprise edition for our Windows computers in the PD. Microsoft is changing the way they deliver Windows. It is becoming like Office, where you will no longer own Windows outright, you will have to rent it from them. We have to switch to Enterprise in the PD for compliance reasons, but it is strongly suggested that we plan on switching to Enterprise for all city computers as well. There may come a time where we are forced to switch to Enterprise edition for the city. It would be ideal to plan ahead and budget money for a gradual upgrade for the city so it doesn't come as a surprise. Budget Impact/Other Useful Life 1 year Project Name IT - Windows 10 Enterprise Upgrade Category Unassigned Type Equipment Future Total Project Cost:$1,201,909 Total2023 2024 2025 2026 2027Expenditures 238,71342,000 63,000 43,260 44,558 45,895Equipment 42,000 63,000 43,260 44,558 45,895 238,713Total Total2023 2024 2025 2026 2027Funding Sources 238,71342,000 63,000 43,260 44,558 45,895Equipment Replacement Fund 42,000 63,000 43,260 44,558 45,895 238,713Total Wednesday, August 3, 2022 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru 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 years Project Name IT - Sandbox Security Appliance Category Equipment Type Equipment Future Total Project Cost:$272,000 Total2023 2024 2025 2026 2027Expenditures 45,00045,000Equipment 45,000 45,000Total Total2023 2024 2025 2026 2027Funding Sources 45,00045,000Equipment Replacement Fund 45,000 45,000Total Wednesday, August 3, 2022 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2023 2027 thru Department Comm Svcs - IT Description Computer servers store information and system programs for Police Department. Project #01-ERP-0211 Priority n/a Justification Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers usedfor data storage Budget Impact/Other Useful Life 1 year Project Name PD - Network Server Category Equipment Type Equipment Future Total Project Cost:$1,118,901 Total2023 2024 2025 2026 2027Expenditures 139,36626,250 27,038 27,849 28,684 29,545Equipment 26,250 27,038 27,849 28,684 29,545 139,366Total Total2023 2024 2025 2026 2027Funding Sources 139,36626,250 27,038 27,849 28,684 29,545Equipment Replacement Fund 26,250 27,038 27,849 28,684 29,545 139,366Total Wednesday, August 3, 2022 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Asst City Manager 2023 2027 thru Department Community Services Description Included in this request are equipment needed to move to an electronic plan review and inspections process. Revu -Bluebeam electronic plan review software - 2020 - $1,100 (useful life 8-10 years) Ipads - 2020 - $5,400 (useful life 5-6 years) Rental Inspection software - 2020 - $7,500 (useful life 7-10 years) Project #01-ERP-0052 Priority 2 Very Important Justification As more and more contractors and architects ask to submit plan electronically, Blubeam software will enable inspectors to perform electronic plan reviews which will make the plan review process more efficient and enhance customer service. As the inspection and construction industry becomes more paperless, iPads will enable inspectors to use mobile technology to keep up with the requests of engineers, architect, contractors, landlords and residents. Ipads are a key piece that will enable staff to view electronic plans in the field. Going paperless will eventually eliminate our need for paper plan scanning and sorting which is very time consuming and costs $1,500 - $2,000 per year. The software company currently used by Rental Inspectors has recently gone out of business and support for the software is going to be on a very limited basis after 2020. Because rental inspections effect such a large part of the city and the department, I believe getting a new software in place before the existing software stops functioning is essential to the rental inspection program. Budget Impact/Other Useful Life 5-7 years Project Name Electronic Inspections Processing Category Equipment Type Equipment Future Total Project Cost:$96,150 Total2023 2024 2025 2026 2027Expenditures 16,23116,231Equipment 16,231 16,231Total Total2023 2024 2025 2026 2027Funding Sources 16,23116,231Equipment Replacement Fund 16,231 16,231Total Wednesday, August 3, 2022 40 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru Department Fire Description Fire engine: full size response truck Current vehicle: 1989 Ford L9000 Tele-Squirt (#102) Project #01-ERP-0100 Priority n/a Justification This is a replacement engine for response to emergency response in the City. We will be reducing the fleet by one truck in making this one unit (ladder/pumper) which would reduce the life of a vehicle from 25 years to 10 years. We are finding that the life a vehicle is no longer 20 years. Budget Impact/Other Variance from 20 year plan - was scheduled for replacement in 2019 and has been moved up to 2017. Change useful life from 25 to 10 years. Updated value to reflect more accurate replacement cost. Estimate salvage/resale value on replaced item: $ Useful Life 10 years Project Name Tele-Squirt (Engine 2)Category Vehicles Type Equipment Future Total Project Cost:$3,243,916 Total2023 2024 2025 2026 2027Expenditures 1,000,0001,000,000Equipment 1,000,000 1,000,000Total Total2023 2024 2025 2026 2027Funding Sources 1,000,0001,000,000Equipment Replacement Fund 1,000,000 1,000,000Total Wednesday, August 3, 2022 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru Department Fire Description 1500 GPM fire pumper, fully equipped to respond to all fire situations in the city. Responds to mutual aid calls in other cities. This truck wil be pushed back to 2027 and will also be on a 10 year rotation. Current vehicle: 2006 Peterbilt Fire Pumper 357 (#103) Project #01-ERP-0101 Priority n/a Justification Current unit is a first out pumper. This apparatus construction will require 25 year specifications for life of the apparatus. Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $2,500 Useful Life 25 years Project Name Fire Pumper (Engine 3)Category Vehicles Type Equipment Future Total Project Cost:$2,550,000 Total2023 2024 2025 2026 2027Expenditures 900,000900,000Equipment 900,000 900,000Total Total2023 2024 2025 2026 2027Funding Sources 900,000900,000Equipment Replacement Fund 900,000 900,000Total Wednesday, August 3, 2022 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru Department Fire Description Breathing apparatus for interior firefighting for firefighters. Project #01-ERP-0108 Priority n/a Justification The breathing apparatus was taken out of the ERP in 2006 because we thought we were getting a grant. Grant was not successful. The SCBA's (45) need to be replaced because they are at the end of their life and cannot be hydro tested any longer. Budget Impact/Other Variance from 20 year plan - Move back to 2025. Purchased SCBA's in 2015 with grant funds. Estimate salvage/resale value on replaced item: $ Useful Life 10 years Project Name Self Contained Breathing Apparatus (SCBA) (45)Category Equipment Type Equipment Future Total Project Cost:$802,000 Total2023 2024 2025 2026 2027Expenditures 300,000300,000Equipment 300,000 300,000Total Total2023 2024 2025 2026 2027Funding Sources 300,000300,000Equipment Replacement Fund 300,000 300,000Total Wednesday, August 3, 2022 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru Department Fire Description Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. Project #01-ERP-0109 Priority n/a Justification All vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool will be added to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. Budget Impact/Other Estimate salvage/resale value on replaced item: $1,000 Purchased: 2007 Useful Life 10 years Project Name Extrication Tool (1)Category Equipment Type Equipment Future Total Project Cost:$240,800 Total2023 2024 2025 2026 2027Expenditures 38,00038,000Equipment 38,000 38,000Total Total2023 2024 2025 2026 2027Funding Sources 38,00038,000Equipment Replacement Fund 38,000 38,000Total Wednesday, August 3, 2022 44 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru Department Fire Description Used by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and heat may be hidden allowing for faster extinguishment. Note: purchased 2013 & 2017 Project #01-ERP-0112 Priority n/a Justification Current camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was purchased with donation money. Budget Impact/Other Variance from 20 year plan - department owns 2 cameras. Reoccuring expenditure. Estimate salvage/resale value on replaced item: $-0- Useful Life 10 years Project Name Thermal Imaging Camera (2)Category Equipment Type Equipment Future Total Project Cost:$149,905 Total2023 2024 2025 2026 2027Expenditures 38,60018,600 20,000Equipment 18,600 20,000 38,600Total Total2023 2024 2025 2026 2027Funding Sources 38,60018,600 20,000Equipment Replacement Fund 18,600 20,000 38,600Total Wednesday, August 3, 2022 45 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru 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 years Project Name Emergency Preparedness Sirens Category Equipment Type Equipment Future Total Project Cost:$65,500 Total2023 2024 2025 2026 2027Expenditures 38,50038,500Equipment 38,500 38,500Total Total2023 2024 2025 2026 2027Funding Sources 38,50038,500Equipment Replacement Fund 38,500 38,500Total Wednesday, August 3, 2022 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru Department Fire Description Floor scrubber to keep apparatus floors clean. Current equipment: 2004 Tennant 5400 Project #01-ERP-0114 Priority n/a Justification Scrubber is used to keep apparatus floors clean so that floor will last longer. Budget Impact/Other Variance from 20 year plan - Eliminate sweeper and add scrubber as scrubber is used more. Move from 2016 to 2015 Estimate salvage/resale value on replaced item: $0 Useful Life 12 years Project Name Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$63,541 Total2023 2024 2025 2026 2027Expenditures 20,30020,300Equipment 20,300 20,300Total Total2023 2024 2025 2026 2027Funding Sources 20,30020,300Equipment Replacement Fund 20,300 20,300Total Wednesday, August 3, 2022 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru Department Fire Description Portable and mobile radios used by the police departments to allow the department to communicate on one frequency. Fire has 50 portable and 13 mobile radios along with 50 pagers. Cost in ERP includes portable radios (30), portable radio's encrypted (20), mobile radio's (13), pagers (50), chargers single (60), charger base (3) plus other needed equipment. Details of all items are on file with Fire and Finance Depts. Project #01-ERP-0125 Priority n/a Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. Budget Impact/Other In 2016 the Fire radios were separated from Police for better accountability. Project was adjusted for current pricing. 2025 - 356,500 FD 2025 - 29,500 PW Useful Life 5-7 years Project Name Fire Radios - Portable and Mobile Devices Category Equipment Type Equipment Future Total Project Cost:$2,404,328 Total2023 2024 2025 2026 2027Expenditures 455,000455,000Equipment 455,000 455,000Total Total2023 2024 2025 2026 2027Funding Sources 455,000455,000Equipment Replacement Fund 455,000 455,000Total Wednesday, August 3, 2022 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru Department Fire Description Lucus device is used to assist CPR during full arrest. The current device was purchased in 2016 and with changed in technology, it is recommended to update every 5 years. Project #01-ERP-0127 Priority n/a Justification To continue to serve citizens of Hopkins during medical incidents. Budget Impact/Other Reoccurs every 5 years. Useful Life 5 years Project Name Fire - Lucus Device Category Equipment Type Equipment Future Total Project Cost:$98,686 Total2023 2024 2025 2026 2027Expenditures 18,00018,000Equipment 18,000 18,000Total Total2023 2024 2025 2026 2027Funding Sources 18,00018,000Equipment Replacement Fund 18,000 18,000Total Wednesday, August 3, 2022 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2023 2027 thru 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:$100,000 Total2023 2024 2025 2026 2027Expenditures 100,000100,000Equipment 100,000 100,000Total Total2023 2024 2025 2026 2027Funding Sources 100,000100,000Equipment Replacement Fund 100,000 100,000Total Wednesday, August 3, 2022 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2023 2027 thru 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 years Project Name Pavilion Ice Resurfacer Category Equipment Type Equipment Future Total Project Cost:$640,251 Total2023 2024 2025 2026 2027Expenditures 165,000165,000Equipment 165,000 165,000Total Total2023 2024 2025 2026 2027Funding Sources 165,000165,000PA - Pavilion Fund 165,000 165,000Total Wednesday, August 3, 2022 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2023 2027 thru 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 years Project Name Pavilion - Electric Ice Edger Category Equipment Type Equipment Future Total Project Cost:$25,861 Total2023 2024 2025 2026 2027Expenditures 8,9008,900Equipment 8,900 8,900Total Total2023 2024 2025 2026 2027Funding Sources 8,9008,900PA - Pavilion Fund 8,900 8,900Total Wednesday, August 3, 2022 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2023 2027 thru 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 years Project Name Pavilion Arena Scoreboard Category Equipment Type Equipment Future Total Project Cost:$33,674 Total2023 2024 2025 2026 2027Expenditures 12,00012,000Equipment 12,000 12,000Total Total2023 2024 2025 2026 2027Funding Sources 12,00012,000PA - Pavilion Fund 12,000 12,000Total Wednesday, August 3, 2022 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2023 2027 thru Department Pavilion Description 26" to 28" battery operated walk behind floor scrubber. Floor scrubber is used to clean the arenas concrete floor and tiled surfaces throughout the building. 2014 cost = $8,651.94 Asset ID #5172 Project #01-ERP-1003 Priority n/a Justification Replace the existing floor scrubber with new model. Current floor scrubber was purchased in 2014 and is scheduled to be replaced in 2024. Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $ Useful Life 10 years Project Name Pavilion - Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$48,167 Total2023 2024 2025 2026 2027Expenditures 11,60011,600Equipment 11,600 11,600Total Total2023 2024 2025 2026 2027Funding Sources 11,60011,600PA - Pavilion Fund 11,600 11,600Total Wednesday, August 3, 2022 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. Fleet consists of 7 marked patrol vehicles Project #01-ERP-0200 Priority n/a Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget Impact/Other Useful Life 3 years Project Name Marked Patrol Vehicles (7)Category Vehicles Type Equipment Future Total Project Cost:$4,681,000 Total2023 2024 2025 2026 2027Expenditures 620,000120,000 120,000 120,000 130,000 130,000Vehicles 120,000 120,000 120,000 130,000 130,000 620,000Total Total2023 2024 2025 2026 2027Funding Sources 620,000120,000 120,000 120,000 130,000 130,000Equipment Replacement Fund 120,000 120,000 120,000 130,000 130,000 620,000Total Wednesday, August 3, 2022 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. 4 year rotation. Current vehicle: 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 years Project Name Sergeant's Vehicle Category Vehicles Type Equipment Future Total Project Cost:$597,488 Total2023 2024 2025 2026 2027Expenditures 65,00065,000Vehicles 65,000 65,000Total Total2023 2024 2025 2026 2027Funding Sources 65,00065,000Equipment Replacement Fund 65,000 65,000Total Wednesday, August 3, 2022 56 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description Marked patrol vehicle used by Parking Enforcement Officer to respond to calls for service, enforce parking laws, and perfom duties as assigned. Current Vehicle: 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 years Project Name PSO / Parking Enforcement Vehicle Category Vehicles Type Equipment Future Total Project Cost:$417,572 Total2023 2024 2025 2026 2027Expenditures 65,00065,000Vehicles 65,000 65,000Total Total2023 2024 2025 2026 2027Funding Sources 65,00065,000Equipment Replacement Fund 65,000 65,000Total Wednesday, August 3, 2022 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description Four wheel drive marked patrol vehicle used by PSOs to respond to calls for service, handle animal complaints, and perform other duties associated with department operations. Current vehicle: 2021 Ford F150 (#212) Project #01-ERP-0203 Priority n/a Justification Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals, prisoners and equipment. The 4 wheel drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme snow conditions. Budget Impact/Other 2016 - Variance from 20 year plan - Change in replacement schedule due to full time use of vehicle. Changing useful life from 6 years to 4 years Useful Life 4 years Project Name PSO - Utility 4x4 Category Vehicles Type Equipment Future Total Project Cost:$795,189 Total2023 2024 2025 2026 2027Expenditures 86,10086,100Vehicles 86,100 86,100Total Total2023 2024 2025 2026 2027Funding Sources 86,10086,100Equipment Replacement Fund 86,100 86,100Total Wednesday, August 3, 2022 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description Squad car camera systems are used to document events inside and outside of the patrol vehicles. The cameras utilize a forward facing camera and a prisoner transport area camaera. Body cameras capture interactions between the officers and the public for transparency. 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 Squad cameras 6,000 each. Body cameras moved from the ERP to the general fund, reducing the ERP by $90,000. Useful Life 5 years Project Name Squad Car Camera Systems Category Equipment Type Equipment Future Total Project Cost:$776,921 Total2023 2024 2025 2026 2027Expenditures 70,00070,000Equipment 70,000 70,000Total Total2023 2024 2025 2026 2027Funding Sources 66,50066,500Equipment Replacement Fund 3,5003,500PKG - Parking Fund 70,000 70,000Total Wednesday, August 3, 2022 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description 12 Tactical Ballistical Vests worn by members of the Hopkins Police Department SWAT (Special Weapons and Tactics) team. These vests offer a higher level of protection for officers involved in high risk situations; this protection offers a higher level of ballistic protection compared to regular duty vests. SWAT team members also require ballistic helmets on the same rotational cycle. Equipment breakdown: 12 vests @ $4,215 = $50,580. 12 ballistic helmets @ $642 = $7,716. 2 New protective shields @ $2,864 = $5,729. 12 Radio headsets @ $1,042 = $12,500. Project #01-ERP-0214 Priority 3 Important Justification Variance - Change in vendor equipment pricing and SWAT team staffing levels. Current price is reflective of a twelve person (fully staffed) SWAT team with current vendor pricing. Budget Impact/Other 5 year replacement schedule Useful Life 5 years Project Name Tactical Ballistic Vests / Helmets - SWAT Category Equipment Type Equipment Future Total Project Cost:$628,274 Total2023 2024 2025 2026 2027Expenditures 81,16081,160Equipment 81,160 81,160Total Total2023 2024 2025 2026 2027Funding Sources 81,16081,160Equipment Replacement Fund 81,160 81,160Total Wednesday, August 3, 2022 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description Portable radios used by the police departments to allow the department to communicate on one frequency. Estimated Replacement Cost Portable - $4,500 x 50 = $225,000 Plus chargers, shoulder mic's and batteries - $11,300 TOTAL = $236,300 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 years Project Name Police - Portable Radios Category Equipment Type Equipment Future Total Project Cost:$1,906,203 Total2023 2024 2025 2026 2027Expenditures 290,000290,000Equipment 290,000 290,000Total Total2023 2024 2025 2026 2027Funding Sources 290,000290,000Equipment Replacement Fund 290,000 290,000Total Wednesday, August 3, 2022 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description Tasers can prevent officers and the public from injuries.Taser technology continues to develop and are worn/ carried 24/7. Tasers have a useful life expectancy of approximately 5 years. Project #01-ERP-0217 Priority n/a Justification Tasers are a crtical tool for Law Enforcement for control purposes during use of force encounters. Budget Impact/Other 40- X2 Tasers, each officer has their own taser. $3,500 per Taser (with cartridges) Useful Life 5 years Project Name Taser Replacement Category Equipment Type Equipment Future Total Project Cost:$771,905 Total2023 2024 2025 2026 2027Expenditures 230,041140,000 90,041Equipment 140,000 90,041 230,041Total Total2023 2024 2025 2026 2027Funding Sources 230,041140,000 90,041Equipment Replacement Fund 140,000 90,041 230,041Total Wednesday, August 3, 2022 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2023 2027 thru Department Police Description Building Video Server hardware and associated software is used to store video recorded by the cameras in and around the police department including interview rooms as well as booking. We record approximately 6 TB of video every 2-3 weeks. Large amounts of storage are required for 30 days of archival storage on the server itself. Project #01-ERP-0218 Priority n/a Justification Maintenance agreement with software vendor needs to be renewed every three years. Computer hardware should be refreshed around the same time to minimize drive failure and take advantage of new storage technology. Budget Impact/Other Variance from 20 year plan - Change in replacement schedule and estimated cost. Current equipment was purchased with DTF funding. Beginning in 2020 it will be funded with ERP funds. Estimate salvage/resale value on replaced item: $-0- Useful Life 3 years Project Name Building Video Server Category Equipment Type Equipment Future Total Project Cost:$165,907 Total2023 2024 2025 2026 2027Expenditures 47,00022,000 25,000Equipment 22,000 25,000 47,000Total Total2023 2024 2025 2026 2027Funding Sources 47,00022,000 25,000Equipment Replacement Fund 22,000 25,000 47,000Total Wednesday, August 3, 2022 63 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2023 2027 thru Department Police Description Mobile Data Computers are used in the squad cars to receive calls for service from dispatch, query information from criminal justice databases, and facilitate communication between squad cars. Replacement in 2019 for 12 computers. To be replaced in 2024. Project #01-ERP-0220 Priority n/a Justification Mobile Data Computers have a limited life expectancy. The computers facilitate the basic response to emergency calls for service to which police officers respond. Vital information is forwarded to officers via the mobile data computers. Officers complete investigative reports, issue traffic related warnings and citations, and process arrest incidents from the mobile data computers. As technology evolves the officers must be able to access information using up to date computers that can process the large amount of data and applications. Mobile data computers are currently used to host the squad car video camera system and have the potential to be integrated with a possible body worn camera. Budget Impact/Other Change in replacement year to accurately reflect life expectancy in relation to when the computers were purchased. Useful Life 5 years Project Name Squad Computers Category Equipment Type Equipment Future Total Project Cost:$561,242 Total2023 2024 2025 2026 2027Expenditures 90,00090,000Equipment 90,000 90,000Total Total2023 2024 2025 2026 2027Funding Sources 90,00090,000Equipment Replacement Fund 90,000 90,000Total Wednesday, August 3, 2022 64 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2023 2027 thru Department Police Description LETG - Records Management System was purchased at the end of 2012. This maintains all police records and reports. Project #01-ERP-0221 Priority n/a Justification A new RMS system may be needed by 2022. Budget Impact/Other Advance to 2023 from 2024. The upgrade is needed before 2024. Useful LifeProject Name Records Management System Category Equipment Type Equipment Future Total Project Cost:$200,000 Total2023 2024 2025 2026 2027Expenditures 200,000200,000Equipment 200,000 200,000Total Total2023 2024 2025 2026 2027Funding Sources 200,000200,000Equipment Replacement Fund 200,000 200,000Total Wednesday, August 3, 2022 65 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru 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 years Project Name Police Equipment Category Equipment Type Equipment Future Total Project Cost:$214,381 Total2023 2024 2025 2026 2027Expenditures 50,00025,000 25,000Equipment 25,000 25,000 50,000Total Total2023 2024 2025 2026 2027Funding Sources 50,00025,000 25,000Equipment Replacement Fund 25,000 25,000 50,000Total Wednesday, August 3, 2022 66 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2023 2027 thru Department Police Description Unmarked administrative vehicles used by detectives and other police department staff for community outreach, training and criminal investigation. The police departments maintains three vehicles for this type of use. Project #01-ERP-0228 Priority n/a Justification Currently the police department has three vehicles owned by the City that are not in lease rotation. The vehicles are a vital resource or outreach, training and criminal investigation activities. Purchasing the vehicles provides for long term use of the vehicles without the ongoing costs involved in a lease program. The current vehicles owned are between 9 and 11 years old. The Police Department would like to place the vehicles on a 10 year replacement rotation, starting with two vehicles in 2023 and one in 2024. Budget Impact/Other Administrative vehicles are equipped with minimal emergency lighting and other police equipment. The cost of the vehicles would be offset with the sale of current vehicles. Useful Life 10 years Project Name Administrative Vehicles Category Vehicles Type Equipment Future Total Project Cost:$105,000 Total2023 2024 2025 2026 2027Expenditures 105,00070,000 35,000Vehicles 70,000 35,000 105,000Total Total2023 2024 2025 2026 2027Funding Sources 105,00070,000 35,000Equipment Replacement Fund 70,000 35,000 105,000Total Wednesday, August 3, 2022 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru 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 years Project Name 4X4 3/4 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$222,289 Total2023 2024 2025 2026 2027Expenditures 42,10042,100Vehicles 42,100 42,100Total Total2023 2024 2025 2026 2027Funding Sources 42,10042,100Equipment Replacement Fund 42,100 42,100Total Wednesday, August 3, 2022 68 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Bldg/Equip Ser Description Scan kit to assist in diagnosing repairs needed on the fleets larger trucks. Project #01-ERP-0714 Priority 1 Urgent Justification Having the scan tool will provide the in-house mechanics to pull the codes off the trucks and make the repairs. We will not have to send the truck to an outside source for diagnosis. Budget Impact/Other Useful Life 10 years Project Name PW - Truck Scan Kit Category Vehicles Type Equipment Future Total Project Cost:$43,152 Total2023 2024 2025 2026 2027Expenditures 14,14314,143Equipment 14,143 14,143Total Total2023 2024 2025 2026 2027Funding Sources 14,14314,143Equipment Replacement Fund 14,143 14,143Total Wednesday, August 3, 2022 69 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Parks/Forestry Description Pickup used by Park Division of Public Works. Project #01-ERP-0800 Priority n/a Justification Budget Impact/Other Estimate salvage/resale value on replaced item: $ Useful Life 10 years Project Name 1/2 Ton Pickup Truck Category Vehicles Type Equipment Future Total Project Cost:$173,369 Total2023 2024 2025 2026 2027Expenditures 35,40035,400Vehicles 35,400 35,400Total Total2023 2024 2025 2026 2027Funding Sources 35,40035,400Equipment Replacement Fund 35,400 35,400Total Wednesday, August 3, 2022 70 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Parks/Forestry Description Truck is used for hauling brush and logs in the Forestry department. Current vehicle: 2007 International LP4600 Log Truck (#811) Project #01-ERP-0804 Priority n/a Justification Budget Impact/Other ncreased amount by $68,000 from original 2023-2027 ERP to reflect actual cost. Amendment approved on February 7, 2023. Useful Life 15 years Project Name Log Truck Category Vehicles Type Equipment Future Total Project Cost:$591,484 Total2023 2024 2025 2026 2027Expenditures 231,600231,600Vehicles 231,600 231,600Total Total2023 2024 2025 2026 2027Funding Sources 115,800115,800Equipment Replacement Fund 115,800115,800RF - Refuse Fund 231,600 231,600Total Wednesday, August 3, 2022 71 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Parks/Forestry Description Truckster used by Parks Division of Public Works for ballfield and parks maintenance. Current equipment: 1996 Toro Workman (#818), 2004 Toro Workman 3200 (#820), 2014 Toro Electric Workman (#821) Project #01-ERP-0807 Priority n/a Justification Park maintenance, ballfield grooming and weed spraying. Budget Impact/Other Variance from 20 year plan - Estimate salvage/resale value on replaced item: (3) $1,400 each 2016-Decreased useful life from 15 years to 10 years Useful Life 10 years Project Name Trucksters (3)Category Equipment Type Equipment Future Total Project Cost:$145,440 Total2023 2024 2025 2026 2027Expenditures 17,14017,140Equipment 17,140 17,140Total Total2023 2024 2025 2026 2027Funding Sources 17,14017,140Equipment Replacement Fund 17,140 17,140Total Wednesday, August 3, 2022 72 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2023 2027 thru Department Public Works: Parks/Forestry Description Riding mowers used by Parks Division of Public Works. Current equipment: 2004 Toro Zero Turn (#826), 2006 Jacobson Rotary Mower (#823) Project #01-ERP-0808 Priority 1 Urgent Justification Mowing city parks and right of ways. Move replacement of #826 to 2021 - Ran 10 years past useful life Move replacement of #823 to 2021 Both replacements of current vehicles were held off in 2020 due to the COVID-19 Pandemic. Budget Impact/Other 2021 - Replace 2004 Zero Turn #826 at $15,000 2021 - Replace 2006 Jacobson #823 at $35,000 The Jacobson will be replaced with 7500-D Zmaster Toro Zero Turn Useful Life 6 years Project Name Riding Mowers (2)Category Equipment Type Equipment Future Total Project Cost:$323,930 Total2023 2024 2025 2026 2027Expenditures 17,70017,700Equipment 17,700 17,700Total Total2023 2024 2025 2026 2027Funding Sources 17,70017,700Equipment Replacement Fund 17,700 17,700Total Wednesday, August 3, 2022 73 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Parks/Forestry Description Used to haul multiple riding mowers Current trailor: Unit #845, 1997 Remackle Trailer, overhauled/refurbished in 2016 Project #01-ERP-0814 Priority n/a Justification Allows one truck to pull two riding mowers to parks Budget Impact/Other Variance from 20 year plan - extend life 4 years due to overhaul/refurbishment. Estimate salvage/resale value on replaced item: $ 2016-Increased estimated replacement cost from $2,200 to $10,000 Useful Life 15 years Project Name Trailer Flatbed Category Equipment Type Equipment Future Total Project Cost:$26,980 Total2023 2024 2025 2026 2027Expenditures 10,00010,000Equipment 10,000 10,000Total Total2023 2024 2025 2026 2027Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Wednesday, August 3, 2022 74 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru 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 years Project Name Toolcat Category Equipment Type Equipment Future Total Project Cost:$423,804 Total2023 2024 2025 2026 2027Expenditures 80,20080,200Equipment 80,200 80,200Total Total2023 2024 2025 2026 2027Funding Sources 80,20080,200Equipment Replacement Fund 80,200 80,200Total Wednesday, August 3, 2022 75 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Streets/Traffic Description Pickup used by various divisions of Public Works. Current vehicle: 2013 Ford F-150 (#301) Project #01-ERP-0300 Priority n/a Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. Budget Impact/Other Variance from 20 year plan - Move up from 2015 to 2013. Replace with 1/2 ton 4x4 pickup. Reduce amount from 33,600 to 21,500.. Estimate salvage/resale value on replaced item: $1,500 Useful Life 10 years Project Name 4x4 1/2 Ton Pickup with Plow Category Vehicles Type Equipment Future Total Project Cost:$114,200 Total2023 2024 2025 2026 2027Expenditures 28,90028,900Vehicles 28,900 28,900Total Total2023 2024 2025 2026 2027Funding Sources 28,90028,900Equipment Replacement Fund 28,900 28,900Total Wednesday, August 3, 2022 76 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Streets/Traffic Description 3/4 ton pickup used by Street Division of Public Works for heavy loads and pulling trailers. Current vehicle: 2018 Ford F350 (#302) Project #01-ERP-0301 Priority n/a Justification Light hauling, pulling trailers, transportation to and from job sites. Budget Impact/Other Estimate salvage/resale value on replaced item: $1,500 Useful Life 10 years Project Name 4X4 3/4 Ton Truck with Plow Category Vehicles Type Equipment Future Total Project Cost:$203,519 Total2023 2024 2025 2026 2027Expenditures 38,50038,500Vehicles 38,500 38,500Total Total2023 2024 2025 2026 2027Funding Sources 38,50038,500Equipment Replacement Fund 38,500 38,500Total Wednesday, August 3, 2022 77 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Streets/Traffic Description Truck is used in the Street Division of Public Works. Current vehicles: 2000 Ford F450 (#805) & 2011 Ford F350 (#308) Project #01-ERP-0303 Priority n/a Justification Vehicle used by various departments for street and park maintenance and light hauling. Budget Impact/Other Variance from 20 year plan - move back from 2009 to 2010. Estimated useful life reduced from 12 to 8 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 10 years Project Name 1 Ton Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$281,600 Total2023 2024 2025 2026 2027Expenditures 49,50049,500Vehicles 49,500 49,500Total Total2023 2024 2025 2026 2027Funding Sources 49,50049,500Equipment Replacement Fund 49,500 49,500Total Wednesday, August 3, 2022 78 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Streets/Traffic Description Boom truck used in Street and Traffic Divisions of Public Works. Current vehicle: 2012 Ford F450 (#309) Project #01-ERP-0304 Priority n/a Justification Vehicle used by Traffic Department for signal and light pole maintenance. Budget Impact/Other Variance from 20 year plan - Increase amount to reflect actual. Estimate salvage/resale value on replaced item: $8,000 Useful life moved from 17 years to 12 years. Useful Life 12 years Project Name 1 Ton Traffic Boom Truck Category Vehicles Type Equipment Future Total Project Cost:$413,400 Total2023 2024 2025 2026 2027Expenditures 136,400136,400Vehicles 136,400 136,400Total Total2023 2024 2025 2026 2027Funding Sources 136,400136,400Equipment Replacement Fund 136,400 136,400Total Wednesday, August 3, 2022 79 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Streets/Traffic Description Current equipment: 2005 Caterpillar 938G (#322) Project #01-ERP-0308 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $ Useful Life 15-18 years Project Name Front End Loaders (2)Category Equipment Type Equipment Future Total Project Cost:$1,267,100 Total2023 2024 2025 2026 2027Expenditures 536,600268,600 268,000Equipment 268,600 268,000 536,600Total Total2023 2024 2025 2026 2027Funding Sources 536,600268,600 268,000Equipment Replacement Fund 268,600 268,000 536,600Total Wednesday, August 3, 2022 80 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru 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 years Project Name Sign Machine (Traffic)Category Equipment Type Equipment Future Total Project Cost:$55,823 Total2023 2024 2025 2026 2027Expenditures 18,10018,100Equipment 18,100 18,100Total Total2023 2024 2025 2026 2027Funding Sources 18,10018,100Equipment Replacement Fund 18,100 18,100Total Wednesday, August 3, 2022 81 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Public Works: Streets/Traffic Description Transportion for Street/Park Supervisor Ford Edge SUV Project #01-ERP-0322 Priority 1 Urgent Justification Supervisor needs transportation to meet at job sites wwith crews and residents. The current F-250 is also used for towing the hot mix trailer and for snow plow operations. An old police Ford Explorer is used when the F-250 is unavailable. The Ford Explorer will go to auction in 2023. Budget Impact/Other Useful Life 5-7 years Project Name Streets/Parks Supervisor Vehicle Category Equipment Type Equipment Future Total Project Cost:$35,000 Total2023 2024 2025 2026 2027Expenditures 35,00035,000Vehicles 35,000 35,000Total Total2023 2024 2025 2026 2027Funding Sources 35,00035,000Equipment Replacement Fund 35,000 35,000Total Wednesday, August 3, 2022 82 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2023 2027 thru Department Refuse Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 2011 Freightliner Rapid Rail (#900) Project #01-ERP-0900 Priority n/a Justification Residential waste pick up. Budget Impact/Other Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Useful Life 8 years Project Name Refuse Truck (RAP-R) (2)Category Vehicles Type Equipment Future Total Project Cost:$1,950,700 Total2023 2024 2025 2026 2027Expenditures 275,200275,200Vehicles 275,200 275,200Total Total2023 2024 2025 2026 2027Funding Sources 275,200275,200RF - Refuse Fund 275,200 275,200Total Wednesday, August 3, 2022 83 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru 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 years Project Name 3/4 Ton Utility Truck Category Vehicles Type Equipment Future Total Project Cost:$190,546 Total2023 2024 2025 2026 2027Expenditures 45,20045,200Vehicles 45,200 45,200Total Total2023 2024 2025 2026 2027Funding Sources 45,20045,200SF - Sanitary Sewer Fund 45,200 45,200Total Wednesday, August 3, 2022 84 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Sewer Description Portable generator used by Water/Sewer Divisions of Public Works. Current equipment: 1992 Kohler (#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 years Project Name Generator (2)Category Equipment Type Equipment Future Total Project Cost:$79,000 Total2023 2024 2025 2026 2027Expenditures 43,00043,000Equipment 43,000 43,000Total Total2023 2024 2025 2026 2027Funding Sources 43,00043,000SF - Sanitary Sewer Fund 43,000 43,000Total Wednesday, August 3, 2022 85 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Water Description Trucks used by Water Department. 2016 - Changed from 1/2 ton truck to 3/4 ton truck Current vehicle: 2007 Chevrolet Pickup Project #01-ERP-0500 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Useful Life 10 years Project Name 3/4 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$136,881 Total2023 2024 2025 2026 2027Expenditures 36,00036,000Vehicles 36,000 36,000Total Total2023 2024 2025 2026 2027Funding Sources 36,00036,000WF - Water Fund 36,000 36,000Total Wednesday, August 3, 2022 86 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru 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 years Project Name 3/4 Ton Utility Truck Category Vehicles Type Equipment Future Total Project Cost:$144,929 Total2023 2024 2025 2026 2027Expenditures 46,90046,900Vehicles 46,900 46,900Total Total2023 2024 2025 2026 2027Funding Sources 46,90046,900WF - Water Fund 46,900 46,900Total Wednesday, August 3, 2022 87 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2023 2027 thru Department Water Description Used to convert gas Chlorine to liquid Sodium Hypochlorite Project #01-ERP-0509 Priority 1 Urgent Justification Chlorine gas is extremely danferous and corrosive. Liquid bleach is easy to contain and work with. Budget Impact/Other Useful Life 10 years Project Name Water Treatment Plant Category Equipment Type Equipment Future Total Project Cost:$415,005 Total2023 2024 2025 2026 2027Expenditures 134,392134,392Equipment 134,392 134,392Total Total2023 2024 2025 2026 2027Funding Sources 134,392134,392WF - Water Fund 134,392 134,392Total Wednesday, August 3, 2022 88 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact 2023 2027 thru Department Water Description Transportation for Utility Supervisor Ford Edge SUV Project #01-ERP-0510 Priority n/a Justification Supervisor needs transportation to meet at job sites with crews and residents. The utility division has one additional employee after public works restructuring. An old police Ford Explorer is currently being used and will be auctioned in 2023. Budget Impact/Other Useful LifeProject Name Utilities Supervisor Vehicle Category Unassigned Type Unassigned Future Total Project Cost:$35,000 Total2023 2024 2025 2026 2027Expenditures 35,00035,000Vehicles 35,000 35,000Total Total2023 2024 2025 2026 2027Funding Sources 17,50017,500SF - Sanitary Sewer Fund 17,50017,500WF - Water Fund 35,000 35,000Total Wednesday, August 3, 2022 89 90 TWENTY-YEAR REPLACEMENT SCHEDULE 91 9/6/2022 1,760,600$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 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 13,700 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0035 Floor Scrubber 10 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 31,160 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 97,568 0 0 0 0 0 0 ERP-0042 Replace Sanitizer/Heat Booster 10 0 0 0 0 0 0 0 0 0 27,000 0 0 0 0 0 0 0 0 0 36,000 SUBTOTAL 0 0 0 6,700 0 0 0 13,700 0 27,000 0 0 0 137,728 0 0 0 0 0 36,000 221,128 ARTS CENTER ERP-1102 Kitchen Catering Equipment 12 0 0 0 0 0 7,100 0 0 0 0 0 0 0 0 0 0 0 10,123 0 0 ERP-1105 Jaycee Studio Audio Visual 7 0 13,500 0 0 0 0 0 0 17,000 0 0 0 0 0 21,000 0 0 0 0 ERP-1107 Theater Projection Screen 10 0 0 0 0 0 6,700 0 0 0 0 0 0 0 0 0 9,000 0 0 0 0 ERP-1109 Floor Scrubber 10 0 0 10,800 0 0 0 0 0 0 0 0 0 14,516 0 0 0 0 0 0 0 0 13,500 10,800 0 0 13,800 0 0 17,000 0 0 0 14,516 0 0 30,000 0 10,123 0 0 109,739 COMMUNITY SERVICES ERP-0108 Document Management Scanner (2) 4 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 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 62,319 0 0 0 0 0 0 0 ERP-0052 Electronic Inspections Processing 5-7 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 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 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 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 0 0 0 0 0 0 0 0 0 1,036,000 0 0 0 0 0 0 0 0 0 1,392,000 ERP-0106 Aerial Truck 20 0 0 0 0 0 1,572,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 VEHICLES SUBTOTAL 0 0 0 0 1,900,000 1,572,000 0 0 0 1,036,000 0 0 0 0 2,593,916 0 0 0 0 1,392,000 8,493,916 ERP-0107 Air Compressor 15 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 300,000 0 0 0 0 0 0 0 0 0 403,000 0 0 0 0 0 0 0 ERP-0109 Extrication Tool (2)10 38,000 0 0 0 0 0 45,000 0 0 0 51,000 0 0 0 0 0 61,000 0 0 0 ERP-0112 Thermal Imaging Camera (2)10 0 0 18,600 0 20,000 0 0 0 0 0 0 0 25,000 0 27,000 0 0 0 0 0 ERP-0113 Emergency Preparedness Siren 20 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 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 455,000 0 0 0 0 0 0 560,000 0 0 0 0 0 0 689,000 0 0 0 ERP-0126 Helmets 10 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 18,000 0 0 0 0 21,000 0 0 0 0 24,000 0 0 0 0 28,000 0 0 0 0 ERP-0128 Hose Replacement 20 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 100,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 EQUIPMENT SUBTOTAL 156,000 0 773,600 38,500 40,300 21,000 45,000 0 54,400 578,000 126,068 0 428,000 0 27,000 28,000 778,941 0 0 24,191 3,119,000 IT ERP-0003 City Hall - Network Upgrade 1 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 89,600 0 0 0 0 0 0 0 114,000 0 0 0 0 0 0 0 144,000 0 0 0 ERP-0005 Financial Software 7 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 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-Fiber 15 60,000 0 70,000 0 0 0 0 0 0 0 0 0 0 0 0 93,000 0 109,000 0 0 ERP-0012 Core Network Switch 6 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 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 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 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 33,000 36,000 40,000 40,000 40,000 41,000 42,000 43,000 44,000 45,000 46,000 47,000 48,000 49,000 50,000 52,000 54,000 56,000 58,000 60,000 ERP-0024 Sandbox Security Appliance 5 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 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 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 429,685 255,954 666,324 353,661 235,548 242,414 335,571 346,759 430,090 752,794 279,495 287,500 475,143 392,804 312,800 528,045 952,804 540,972 546,564 398,877 8,763,805 POLICE ERP-0200 Squad 3 120,000 120,000 120,000 130,000 130,000 134,000 138,000 142,000 146,000 150,000 155,000 160,000 165,000 170,000 175,000 180,000 185,000 191,000 197,000 203,000 ERP-0201 Sergeant Vehicle #209 4 0 0 65,000 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 5 0 0 0 65,000 0 0 0 0 75,000 0 0 0 0 87,000 0 0 0 0 101,000 0 ERP-0203 PSO Utility 4x4 #212 6 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 77,900 0 0 0 0 0 0 0 0 0 0 0 ERP-0228 Administrative Vehicles 10 70,000 35,000 0 0 0 0 0 0 0 0 94,000 47,000 0 0 0 0 0 0 0 0 VEHICLES SUBTOTAL 190,000 155,000 185,000 281,100 130,000 134,000 210,206 238,905 298,900 150,000 330,268 316,067 165,000 257,000 266,467 302,755 185,000 191,000 400,947 341,162 4,728,777 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 ERP-0212 Squad Car Camera System 7 0 70,000 0 0 0 0 0 86,000 0 0 0 0 0 0 106,000 0 0 0 0 ERP-0214 Tactical Ballistic Vests (9)5 81,160 0 0 0 0 94,000 0 0 0 0 109,000 0 0 0 0 126,000 0 0 0 0 ERP-0215 Radios-Portable & Mobile 5-7 290,000 0 0 0 0 0 0 357,000 0 0 0 0 0 439,000 0 0 0 0 0 ERP-0217 Taser Replacement 4 140,000 0 0 0 90,041 0 0 178,000 0 0 200,000 0 0 0 225,000 0 0 0 ERP-0218 Building Video Server 4 22,000 0 0 25,000 0 0 0 28,000 0 0 0 32,000 0 0 0 36,000 0 0 0 41,000 ERP-0220 Squad Computers 5 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 200,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ERP-0227 Police Equipment 3 25,000 0 0 25,000 0 0 27,000 0 0 30,000 0 0 33,000 0 0 36,000 0 0 39,000 0 EQUIPMENT SUBTOTAL 758,160 160,000 0 50,000 90,041 94,000 127,000 385,000 264,000 30,000 109,000 119,418 233,000 0 439,000 304,000 326,342 0 39,000 41,000 3,568,961 92 9/6/2022 1,760,600$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 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 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 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 50,000 0 0 0 0 0 0 0 0 0 0 ERP-0714 PW - Truck Scan Kit 10 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 36,714 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 38,800 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 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 108,000 0 0 0 0 0 0 0 137,000 0 0 0 0 0 0 ERP-0802 3/4 Ton Utility Truck 10 0 0 0 0 0 0 0 48,700 0 0 0 0 0 0 0 0 0 65,000 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 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 ERP-0807 Truckster 15 0 0 0 0 17,140 0 0 0 0 0 0 53,200 0 0 0 0 0 0 0 27,000 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 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 76,032 0 0 0 0 0 ERP-0813 Brush Clipper 20 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 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 45,600 0 0 0 0 0 0 0 0 0 0 0 65,014 0 ERP-0816 Toolcat 8 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 17,900 0 0 0 0 0 0 0 0 0 0 0 0 VEHICLES SUBTOTAL 117,200 10,000 0 97,900 17,140 261,709 45,600 295,500 0 21,135 91,300 193,129 0 291,050 76,032 279,884 15,580 110,766 65,014 155,704 2,144,643 P.W. STREETS/TRAFFIC ERP-0300 4x4 3/4 Ton Truck/Plow 10 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 38,500 0 0 0 0 0 0 48,800 0 0 0 0 0 0 ERP-0302 4x2 1 Ton Dump Truck 12 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 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 0 136,400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 225,000 ERP-0305 Single Axle Dump Truck 17 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 286,000 294,000 0 0 0 0 0 0 0 ERP-0307 Water Truck 22 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 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 0 0 0 0 0 59,700 0 0 0 0 0 71,300 0 0 0 0 0 85,000 0 0 ERP-0311 Sweeper 20 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 82,000 0 0 0 0 0 ERP-0313 Striper 12 0 0 0 0 0 0 16,000 0 0 0 0 0 0 0 0 0 0 0 23,000 0 ERP-0314 Paver 20 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 117,000 0 0 0 0 0 0 0 0 ERP-0316 Trailer 20 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 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 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 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 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 200,000 0 0 ERP-0322 Streets/Parks Supervisor Vehicle 5-7 35,000 0 0 0 0 0 42,000 0 0 0 0 0 50,000 0 0 0 0 0 60,000 0 VEHICLES SUBTOTAL 63,900 318,100 136,400 18,100 306,500 269,700 89,509 297,250 538,600 120,000 38,800 550,400 392,800 24,323 82,000 0 460,800 389,600 83,000 225,000 4,404,782 PAVILION ERP-1000 Ice Resurfacer 12 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 8,900 0 0 0 0 0 0 0 0 0 0 0 13,000 0 0 0 0 ERP-1002 Arena Scoreboard 20 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 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 16,200 0 0 0 0 0 0 0 0 0 0 0 0 0 SUBTOTAL 0 11,600 0 185,900 0 0 16,200 0 0 0 0 15,600 0 0 0 248,251 0 0 0 0 477,551 REFUSE ERP-0900 Refuse Truck (RAP-R)10 0 0 275,200 0 0 0 0 0 0 0 0 0 370,000 0 0 0 0 0 0 0 ERP-0901 Refuse Truck (Rear-L)15 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 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 81,800 0 275,200 0 0 0 0 0 0 136,500 171,000 0 370,000 0 0 0 0 0 0 0 1,034,500 WATER ERP-0500 1./2 Ton Truck 10 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 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 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 40,000 0 0 0 0 0 0 0 0 ERP-0509 Water Treatment Plant 10 0 0 0 0 134,392 0 0 0 0 0 0 0 0 0 180,613 0 0 0 0 0 ERP-0510 Utilities Supervisor Vehicle 5-7 35,000 0 0 0 0 0 42,000 0 0 0 0 0 50,000 0 0 0 0 0 60,000 0 SUBTOTAL 35,000 0 0 46,900 170,392 0 42,000 0 0 153,700 0 40,000 50,000 63,029 228,994 0 0 0 60,000 0 890,015 SEWER ERP-0551 3/4 Ton Utility Truck 10 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 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 ERP-0560 Televising Camera and Van 12 0 0 0 0 0 0 0 0 0 0 0 256,600 0 0 0 0 0 0 0 0 SUBTOTAL 0 43,000 0 45,200 0 0 0 0 0 0 0 256,600 0 60,746 750,000 0 0 0 0 0 1,155,546 93 9/6/2022 1,760,600$ INFLATION FACTOR 3.0% REPL EQUIPMENT /VEHICLES YRS 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 Total GENERAL FUND 1,714,945 899,054 1,777,555 888,061 2,733,672 2,609,123 861,186 1,648,170 1,585,990 2,780,929 1,011,645 1,519,845 1,778,076 1,120,912 3,816,224 1,442,684 2,719,467 1,277,892 1,146,025 2,681,492 36,012,948 ARTS CENTER 0 13,500 10,800 0 0 13,800 0 0 17,000 0 0 0 14,516 0 0 30,000 0 10,123 0 0 109,739 REFUSE 81,800 0 275,200 0 0 0 0 0 0 136,500 171,000 0 370,000 0 0 0 0 0 0 0 1,034,500 PAVILION 0 11,600 0 185,900 0 0 16,200 0 0 0 0 15,600 0 0 0 248,251 0 0 0 0 477,551 WATER 35,000 0 0 46,900 170,392 0 42,000 0 0 153,700 0 40,000 50,000 63,029 228,994 0 0 0 60,000 0 890,015 SEWER 0 43,000 0 45,200 0 0 0 0 0 0 0 256,600 0 60,746 750,000 0 0 0 0 0 1,155,546 GENERAL FUND TOTAL 1,714,945 899,054 1,777,555 888,061 2,733,672 2,609,123 861,186 1,648,170 1,585,990 2,780,929 1,011,645 1,519,845 1,778,076 1,120,912 3,816,224 1,442,684 2,719,467 1,277,892 1,146,025 2,681,492 36,012,948 ARTS CENTER FUND TOTAL 0 13,500 10,800 0 0 13,800 0 0 17,000 0 0 0 14,516 0 0 30,000 0 10,123 0 0 109,739 ENTERPRISE FUNDS TOTAL 116,800 54,600 275,200 278,000 170,392 0 58,200 0 0 290,200 171,000 312,200 420,000 123,775 978,994 248,251 0 0 60,000 0 3,557,612 TOTAL ALL FUNDS 1,831,745 967,154 2,063,555 1,166,061 2,904,064 2,622,923 919,386 1,648,170 1,602,990 3,071,129 1,182,645 1,832,045 2,212,592 1,244,687 4,795,218 1,720,935 2,719,467 1,288,015 1,206,025 2,681,492 39,680,299 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 800,000 NET GENERAL FUND 1,674,945 859,054 1,737,555 848,061 2,693,672 2,569,123 821,186 1,608,170 1,545,990 2,740,929 971,645 1,479,845 1,738,076 1,080,912 3,776,224 1,402,684 2,679,467 1,237,892 1,106,025 2,641,492 35,212,948 20 YEAR AVERAGES:Total Average ACTIVITY CENTER ADMINISTRATION 221,128 11,100 IT 8,763,805 438,200 COMMUNITY SERVICES 226,481 11,300 FIRE EQUIPMENT 8,493,916 424,700 FIRE ADMINISTRATION 3,119,000 156,000 POLICE EQUIPMENT 4,728,777 236,400 POLICE ADMINISTRATION 3,568,961 178,400 PUBLIC WORKS ADMINISTRATION 0 0 BLDG./EQUIPMENT SERVICES EQUIPMENT 302,655 15,100 ENGINEERING EQUIPMENT 38,800 1,900 PARKS/FORESTRY EQUIPMENT 2,144,643 107,200 STREET EQUIPMENT 4,404,782 220,200 GENERAL FUND VEHICLE/EQUIPMENT 20,113,573 1,005,700 GENERAL FUND OTHER EQUIPMENT 15,899,375 795,000 GENERAL FUND TOTAL 36,012,948 1,800,600 ARTS CENTER FUND 109,739 5,500 REFUSE FUND 1,034,500 51,700 PAVILION FUND 477,551 23,900 WATER FUND 890,015 44,500 SEWER FUND 1,155,546 57,800 UTILITY VEHICLES/EQUIPMENT 3,667,351 183,400 39,680,299 94 EQUIPMENT INVENTORY 8195 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY FALL, 2022 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 2021 FORD F150 60,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 2021 FORD EXPLORER 60,000 115 1952 MACK NONE 4,000 POLICE DEPARTMENT 200 2022 FORD UTILITY 57,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 2022 FORD UTILITY 57,000 211 2021 FORD UTILITY 57,000 213 2020 CHEVROLET BLAZER 54,000 214 2021 FORD EXPLORER 60,000 216 2011 FORD TAURUS 30,000 218 2013 FORD UTILITY BLUE 40,000 219 2013 FORD TAURUS 24,000 220 2021 FORD EXPLORER 60,000 221 2022 FORD EXPLORER 60,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, 2022 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 305 2021 FREIGHTLINER 114SD 225,000 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 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 2016 FORD F350 18,000 703 2015 FORD UTILITY 35,000 705 2018 FORD F350 30,000 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, 2022 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, 2022 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 511 2020 FORD TRANSIT 35,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 270,300 99