Loading...
2024-2028 Equipment Replacement PlanEQUIPMENT REPLACEMENT PLAN 2024-2028 DATE: November 21, 2023 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2024-2028 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2024-2028 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 five 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 Page City Manager's Message 1 Table of Contents 2 Cash Flow Statement Equipment Replacement Fund 3 Five-Year Project Summaries Department Summary 4 Projects by Department 5 Funding Source Summary 8 Projects by Funding Source 9 Equipment Requests Individual Equipment Request Details Activity Center 11 Arts Center 12 Information Technology 14 City Clerk 27 Inspections 28 Fire 29 Pavilion 38 Police 42 Public Works 54 Refuse 72 Water/Sewer 73 EQUIPMENT REPLACEMENT PLAN 2024-2028 TABLE OF CONTENTS 2 2024 2025 2026 2027 2028 Beginning Fund Balance 1,113,268 796,187 140,226 627,920 950,807 Revenues & Other Financing Sources Tax Levy 360,000 360,000 360,000 360,000 360,000 Equipment Charges 752,536 797,688 845,549 896,282 950,059 Sale of Equipment 35,000 35,000 35,350 35,704 36,061 Interest Earnings 11,133 7,962 1,402 6,279 9,508 Equipment Certificates (Bonds)- 136,400 - 3,200,000 1,575,000 Transfer In - -- -- Total Revenue & Other Financing Sources 1,158,669 1,337,050 1,242,301 4,498,265 2,930,628 Expenditures & Other Financing Uses Current Expenditures 35,956 36,316 36,679 37,046 37,416 Capital Projects Community Services - Activity Center - - 6,700 - - Community Services - Information Technology 255,954 666,324 364,588 235,549 212,669 Community Services - Inspections - 16,231 - - 14,300 Fire Vehicles & Equipment - 893,600 45,000 3,245,500 1,590,500 Police Vehicles & Equipment 391,640 244,140 301,640 336,640 365,337 Police Records Management System 500,000 - - - - Public Works: Bldg/Equip Serv - - - 14,143 Public Works: Parks/Forestry 92,000 - - - 469,609 Public Works: Streets/Traffic 200,200 136,400 - 306,500 339,700 Total Expenditures and Other Financing Sources 1,475,750 1,993,011 754,607 4,175,378 3,029,531 Increase (Decrease) in Fund Balance (317,081) (655,961) 487,694 322,887 (98,903) Projected Ending Fund Balance 796,187 140,226 627,920 950,807 851,904 Equipment Replacement Fund - Projected Cash Flows 3 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2024 2028thru Total20242025202620272028Department Comm Svcs - Activity Center 6,7006,700 Comm Svcs - Arts Center 24,30013,500 10,800 Comm Svcs - IT 1,735,084255,954 666,324 364,588 235,549 212,669 Community Services 30,53116,231 14,300 Fire 5,774,600893,600 45,000 3,245,500 1,590,500 Pavilion 197,90024,000 173,900 Police 2,139,397891,640 244,140 301,640 336,640 365,337 Public Works: Bldg/Equip Serv 74,14360,000 14,143 Public Works: Parks/Forestry 641,809172,200 469,609 Public Works: Streets/Traffic 842,60060,000 136,400 306,500 339,700 Refuse 275,200275,200 Sewer 88,20043,000 45,200 Water 82,90082,900 1,482,794 2,269,395 1,030,728 4,138,332 2,992,115 11,913,364TOTAL Wednesday, November 15, 20234 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2024 2028thru Total20242025202620272028DepartmentProject #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-0003 143,54627,037 27,849 28,684 29,545 30,431CH - Network Server n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 199,40737,559 38,686 39,847 41,042 42,273Computersn/a 01-ERP-0009 70,00070,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 78,80878,808Backup Server n/a 01-ERP-0017 240,61045,320 46,680 48,080 49,522 51,008IT - Office 365 n/a 01-ERP-0020 167,25536,000 40,000 40,000 40,000 11,255IT - Patching Automation Software 1 01-ERP-0021 10,92710,927IT - Laptops for Mobile Computer Lab n/a 01-ERP-0022 243,98463,000 43,260 44,558 45,895 47,271IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0024 45,00045,000IT - Sandbox Security Appliance n/a 01-ERP-0211 143,54727,038 27,849 28,684 29,545 30,431PD - Network Server n/a 1,735,084255,954 666,324 364,588 235,549 212,669Comm Svcs - IT Total Community Services 01-ERP-0008 14,30014,300Document Management Scanner (2)n/a 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 30,53116,231 14,300Community Services Total Fire 01-ERP-0100 1,700,0001,700,000Ladder #7 n/a 01-ERP-0101 1,500,0001,500,000Fire Pumper (Engine 3)n/a 01-ERP-0106 1,572,0001,572,000Aerial Truck n/a 01-ERP-0108 400,000400,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a 01-ERP-0113 45,00045,000Emergency Preparedness Sirens n/a 01-ERP-0114 25,50025,500Floor Scrubber n/a 01-ERP-0125 475,000475,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0127 18,50018,500Fire - Lucus Device n/a 5,774,600893,600 45,000 3,245,500 1,590,500Fire Total Wednesday, November 15, 20235 Total20242025202620272028DepartmentProject #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-1003 14,00014,000Pavilion - Floor Scrubber n/a 01-ERP-1004 10,00010,000Pavilion - Scissor Lift 3 197,90024,000 173,900Pavilion Total Police 01-ERP-0200 740,000140,000 145,000 150,000 150,000 155,000Marked Patrol Vehicles (7)n/a 01-ERP-0201 72,50072,500Sergeant's Vehicle n/a 01-ERP-0202 75,00075,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 180,00085,000 95,000PSO - Utility 4x4 n/a 01-ERP-0212 133,20026,640 26,640 26,640 26,640 26,640Squad Car Camera Systems n/a 01-ERP-0214 88,69788,697Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0217 160,000160,000Taser Replacement n/a 01-ERP-0218 25,00025,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0221 500,000500,000Records Management System n/a 01-ERP-0227 25,00025,000Police Equipment n/a 01-ERP-0228 50,00050,000Administrative Vehicles n/a 2,139,397891,640 244,140 301,640 336,640 365,337Police Total Public Works: Bldg/Equip Serv 01-ERP-0710 50,00050,0004X4 3/4 Ton Truck - Electric n/a 01-ERP-0714 14,14314,143PW - Truck Scan Kit 1 01-ERP-0716 10,00010,000Scissor Lift n/a 74,14360,000 14,143Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry 01-ERP-0801 108,000108,0004x4 3/4Ton Trucks (2)n/a 01-ERP-0807 27,00027,000Trucksters (3)4 01-ERP-0808 55,00055,000Riding Mowers (2)1 01-ERP-0810 121,609121,609Large Turf Mower n/a 01-ERP-0814 10,00010,000Trailer Flatbed 5 01-ERP-0816 80,20080,200Toolcatn/a 01-ERP-0818 240,000240,000Forestry Boom/Chipper Box Truck n/a 641,809172,200 469,609Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a 01-ERP-0303 60,00060,0001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0308 268,000268,000Front End Loaders (2)n/a 01-ERP-0309 59,70059,700Skid Loader (2)n/a 01-ERP-0319 210,000210,000Regenerative Air Sweeper n/a 01-ERP-0323 30,00030,000Trailer3 01-ERP-0324 40,00040,000Riding Floor Sweeper 3 842,60060,000 136,400 306,500 339,700Public Works: Streets/Traffic Total Refuse 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a Wednesday, November 15, 20236 Total20242025202620272028DepartmentProject #Priority 275,200275,200Refuse Total Sewer 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)2 88,20043,000 45,200Sewer Total Water 01-ERP-0500 36,00036,0003/4 Ton Truck n/a 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 82,90082,900Water Total GRAND TOTAL 11,913,3641,482,794 2,269,395 1,030,728 4,138,332 2,992,115 Wednesday, November 15, 20237 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2024 thru 2028 TotalSource20242025202620272028 AC - Arts Center Fund 24,30013,500 10,800 Equipment Replacement Fund 11,244,8641,439,794 1,956,695 717,928 4,138,332 2,992,115 PA - Pavilion Fund 197,90024,000 173,900 RF - Refuse Fund 275,200275,200 SF - Sanitary Sewer Fund 88,20043,000 45,200 WF - Water Fund 82,90082,900 1,482,794 2,269,395 1,030,728 4,138,332 2,992,115 11,913,364GRAND TOTAL Wednesday, November 15, 2023 8 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2024 2028thru TotalSourceProject #Priority 2024 2025 2026 2027 2028 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 143,54627,037 27,849 28,684 29,545 30,431CH - Network Server n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 199,40737,559 38,686 39,847 41,042 42,273Computersn/a 01-ERP-0008 14,30014,300Document Management Scanner (2)n/a 01-ERP-0009 70,00070,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 78,80878,808Backup Server n/a 01-ERP-0017 240,61045,320 46,680 48,080 49,522 51,008IT - Office 365 n/a 01-ERP-0020 167,25536,000 40,000 40,000 40,000 11,255IT - Patching Automation Software 1 01-ERP-0021 10,92710,927IT - Laptops for Mobile Computer Lab n/a 01-ERP-0022 243,98463,000 43,260 44,558 45,895 47,271IT - 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,700,0001,700,000Ladder #7 n/a 01-ERP-0101 1,500,0001,500,000Fire Pumper (Engine 3)n/a 01-ERP-0106 1,572,0001,572,000Aerial Truck n/a 01-ERP-0108 400,000400,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a 01-ERP-0113 45,00045,000Emergency Preparedness Sirens n/a 01-ERP-0114 25,50025,500Floor Scrubber n/a 01-ERP-0125 475,000475,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0127 18,50018,500Fire - Lucus Device n/a 01-ERP-0200 740,000140,000 145,000 150,000 150,000 155,000Marked Patrol Vehicles (7)n/a 01-ERP-0201 72,50072,500Sergeant's Vehicle n/a 01-ERP-0202 75,00075,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 180,00085,000 95,000PSO - Utility 4x4 n/a 01-ERP-0211 143,54727,038 27,849 28,684 29,545 30,431PD - Network Server n/a 01-ERP-0212 133,20026,640 26,640 26,640 26,640 26,640Squad Car Camera Systems n/a 01-ERP-0214 88,69788,697Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0217 160,000160,000Taser Replacement n/a 01-ERP-0218 25,00025,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0221 500,000500,000Records Management System n/a 01-ERP-0227 25,00025,000Police Equipment n/a 01-ERP-0228 50,00050,000Administrative Vehicles n/a 01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a Wednesday, November 15, 2023 9 TotalSourceProject #Priority 2024 2025 2026 2027 2028 01-ERP-0303 60,00060,0001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0308 268,000268,000Front End Loaders (2)n/a 01-ERP-0309 59,70059,700Skid Loader (2)n/a 01-ERP-0319 210,000210,000Regenerative Air Sweeper n/a 01-ERP-0323 30,00030,000Trailer3 01-ERP-0324 40,00040,000Riding Floor Sweeper 3 01-ERP-0710 50,00050,0004X4 3/4 Ton Truck - Electric n/a 01-ERP-0714 14,14314,143PW - Truck Scan Kit 1 01-ERP-0716 10,00010,000Scissor Lift n/a 01-ERP-0801 108,000108,0004x4 3/4Ton Trucks (2)n/a 01-ERP-0807 27,00027,000Trucksters (3)4 01-ERP-0808 55,00055,000Riding Mowers (2)1 01-ERP-0810 121,609121,609Large Turf Mower n/a 01-ERP-0814 10,00010,000Trailer Flatbed 5 01-ERP-0816 80,20080,200Toolcatn/a 01-ERP-0818 240,000240,000Forestry Boom/Chipper Box Truck n/a 11,244,8641,439,794 1,956,695 717,928 4,138,332 2,992,115Equipment 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-1003 14,00014,000Pavilion - Floor Scrubber n/a 01-ERP-1004 10,00010,000Pavilion - Scissor Lift 3 197,90024,000 173,900PA - Pavilion Fund Total RF - Refuse Fund 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a 275,200275,200RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)2 88,20043,000 45,200SF - Sanitary Sewer Fund Total WF - Water Fund 01-ERP-0500 36,00036,0003/4 Ton Truck n/a 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 82,90082,900WF - Water Fund Total 11,913,3641,482,794 2,269,395 1,030,728 4,138,332 2,992,115GRAND TOTAL Wednesday, November 15, 2023 10 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2024 2028thru Department Comm Svcs - Activity Center Description Floor scrubbed is used to clean tiled floors at the Activity Center Project #01-ERP-0035 Priority n/a Justification Floor scrubber has been used to the extent of it's useful life. Budget Impact/Other New item for 2016 Useful Life 10 yearsProject Name Activity Center - Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$20,700 Total20242025202620272028Expenditures 6,7006,700Equipment 6,700 6,700Total Total20242025202620272028Funding Sources 6,7006,700Equipment Replacement Fund 6,700 6,700Total Wednesday, November 15, 2023 11 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2024 2028thru Department Comm Svcs - Arts Center Description Install a projector in a ceiling mount. Wire speakers into the ceiling. Wire input for computer on front wall. Add two microphones. Mount supporting hardware in rack that fits into closet. Originally scheduled for the Community Room this project was moved to the Jaycee Studio as they found a greater need for this equipment in that room. Project #01-ERP-1105 Priority n/a Justification An increasing number of users of this room require media support. Current means of providing this include the use of an oversized A/V cart, cords stretch across the floor and a large speaker on a stick. We can streamline the appearance and functionality by making these appropriate changes. These changes also address safety concerns. They will help attract safety concerns. They will help attract and retain rental customers as well as appropriately support our own activities. Budget Impact/Other Move this item from 2014 to 2015. Useful Life 7 yearsProject Name Art Center Jaycee Studio Audio Visual Category Equipment Type Equipment Future Total Project Cost:$61,515 Total20242025202620272028Expenditures 13,50013,500Equipment 13,500 13,500Total Total20242025202620272028Funding Sources 13,50013,500AC - Arts Center Fund 13,500 13,500Total Wednesday, November 15, 2023 12 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Arts Center Director 2024 2028thru Department Comm Svcs - Arts Center Description 26-inch auto scrubber Project #01-ERP-1109 Priority n/a Justification Current scrubber has reached its lifetime and no longer spins fast enough to be effective. Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $-0- Useful Life 10 yearsProject Name Art Center Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$33,316 Total20242025202620272028Expenditures 10,80010,800Equipment 10,800 10,800Total Total20242025202620272028Funding Sources 10,80010,800AC - Arts Center Fund 10,800 10,800Total Wednesday, November 15, 2023 13 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description The network server is the hub of the network. New computers are faster and more reliable. Project #01-ERP-0003 Priority n/a Justification Networking allows user to share information that is stored in a single location, the network server. This is more efficient because the information does not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every user is working with the same data. Budget Impact/Other Changes reflect anticipated need for increased storage. Useful Life 1 yearProject Name CH - Network Server Category Equipment Type Equipment Future Total Project Cost:$1,113,900 Total20242025202620272028Expenditures 143,54627,037 27,849 28,684 29,545 30,431Equipment 27,037 27,849 28,684 29,545 30,431 143,546Total Total20242025202620272028Funding Sources 143,54627,037 27,849 28,684 29,545 30,431Equipment Replacement Fund 27,037 27,849 28,684 29,545 30,431 143,546Total Wednesday, November 15, 2023 14 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Finance Director 2024 2028thru Department Comm Svcs - IT Description Finance software upgrade. Software currently used by Finance, City Clerk, Inspections and Public Works. This includes software for all finance applications including general ledger, payroll, accounts payable, accounts receivable, fixed assets, utility billing; Business Licenses, Building Permits, GIS Mapping, Purchasing, etc. Project #01-ERP-0005 Priority n/a Justification Current software vendor is unable to keep up with technology and internet security standards. Staff is often frustrated with how the software works and are often unable to get reports they need from the system. Budget Impact/Other Variance from 20 year plan - replacement needed in 2014 Estimate salvage/resale value on replaced item: $-0- Useful Life 7 yearsProject Name Financial Software - Various Depts.Category Equipment Type Equipment Future Total Project Cost:$1,593,000 Total20242025202620272028Expenditures 315,000315,000Equipment 315,000 315,000Total Total20242025202620272028Funding Sources 315,000315,000Equipment Replacement Fund 315,000 315,000Total Wednesday, November 15, 2023 15 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Project #01-ERP-0006 Priority n/a Justification Tools enabling staff to perform job responsibilities efficiently and effectively. Budget Impact/Other Increase in expenditure a result of supporting more computers than when the original allotment was put in place. Useful Life 3-5 yearsProject Name Computers Category Equipment Type Equipment Future Total Project Cost:$1,852,679 Total20242025202620272028Expenditures 199,40737,559 38,686 39,847 41,042 42,273Equipment 37,559 38,686 39,847 41,042 42,273 199,407Total Total20242025202620272028Funding Sources 199,40737,559 38,686 39,847 41,042 42,273Equipment Replacement Fund 37,559 38,686 39,847 41,042 42,273 199,407Total Wednesday, November 15, 2023 16 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru 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 yearsProject Name Network Infrastructure Upgrade - Fiber Category Equipment Type Equipment Future Total Project Cost:$145,000 Total20242025202620272028Expenditures 70,00070,000Equipment 70,000 70,000Total Total20242025202620272028Funding Sources 70,00070,000Equipment Replacement Fund 70,000 70,000Total Wednesday, November 15, 2023 17 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates fiber optic network connection to fire department. 2 - Cisco 3560E-24PD managed switch - $3,000 each 2 - Cisco X2-10GB-LR fiber optic transceiver - $1200 each cost listed is for equipment only and does not include tax, shipping and other related costs Project #01-ERP-0012 Priority n/a Justification Current two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in significant network outage that was immediately noticed by many employees. Budget Impact/Other Variance from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside the budget for city hall server network budget as the "Lisa" service is scheduled for replacement due to end of life, out of PCI compliance and obsolete. 2015 - change amount from $12,000 to $17,000 - more expensive than originally thought based on 2015 replacement. Estimate salvage/resale value on replace item: - $-0- Useful Life 6 yearsProject Name Core Network Switch Category Equipment Type Equipment Future Total Project Cost:$133,878 Total20242025202620272028Expenditures 20,00020,000Equipment 20,000 20,000Total Total20242025202620272028Funding Sources 20,00020,000Equipment Replacement Fund 20,000 20,000Total Wednesday, November 15, 2023 18 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description We have 25 distribution network switches in our enterprise environment along with fiber optic transceivers and direct attach sfp cables to connect them. Distribution switches connect to the core switches and bring the data to the actual endpoints such as desktops, servers, telephones, and copiers. Project #01-ERP-0014 Priority n/a Justification Replacement of these switches with current technology is vital to the function of the network as well as the safety of the data being passed through the switch. Budget Impact/Other 2016 - New item in ERP Useful Life 5 yearsProject Name Distribution Network Switches Category Equipment Type Equipment Future Total Project Cost:$338,486 Total20242025202620272028Expenditures 57,00057,000Equipment 57,000 57,000Total Total20242025202620272028Funding Sources 57,00057,000Equipment Replacement Fund 57,000 57,000Total Wednesday, November 15, 2023 19 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description Group of Dell servers to run Dell Rapid Recovery software to backup city computers and servers, along with Windows and VMWare licsensing required to run the servers. Project #01-ERP-0015 Priority n/a Justification Backup servers are essential to keep the electronic data for the city safe. We have overgrown our current system and are not able to backup everything that needs to be backed up in a timely manor. Additinally restores on the curent system take hours to days. If we needed to restore a critical server from backup, we would be looking at an unacceptable amount of downtime. Budget Impact/Other Useful Life 3 yearsProject Name Backup Server Category Equipment Type Equipment Future Total Project Cost:$801,110 Total20242025202620272028Expenditures 78,80878,808Equipment 78,808 78,808Total Total20242025202620272028Funding Sources 78,80878,808Equipment Replacement Fund 78,808 78,808Total Wednesday, November 15, 2023 20 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description Transition from the legacy model of Microsoft Office to Office 365. This project would transition 25 percent of our users and devices per year. Project #01-ERP-0017 Priority n/a Justification As we become a more mobile workforce embracing new mobile and remote technology we need to move away from the traditonal office that can only be installed on a Windows computer and transition to the version of Office that can be used in the cloud and as a mobile app. Unfortunately, as is becoming common with most enterprise softwre, you can no longer just purchase it out right, you must rent it from the software author. The cost for Office 365 will now be a yearly ongoing cost. Office 365 is common at other cities, corporations, and educational environments. Budget Impact/Other Useful Life 1 yearProject Name IT - Office 365 Category Equipment Type Equipment Future Total Project Cost:$2,420,118 Total20242025202620272028Expenditures 240,61045,320 46,680 48,080 49,522 51,008Equipment 45,320 46,680 48,080 49,522 51,008 240,610Total Total20242025202620272028Funding Sources 240,61045,320 46,680 48,080 49,522 51,008Equipment Replacement Fund 45,320 46,680 48,080 49,522 51,008 240,610Total Wednesday, November 15, 2023 21 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description Software to automate the delivery of critical and maintenance patches to our enterprise endpoints and yearly maintenance of the software going forward. Project #01-ERP-0020 Priority 1 Urgent Justification Microsoft software has to be patched the second Tuesday of every month. Adobe software has to be patched every time a critical vulnerability is discovered, which can be twice in a week in a bad week. Other applications have to be patched as new releases are produced from vendors. Currently our staff must touch every endpoint for the majority of the software installs. We are using up an inordinate amount of staff time to patch all of our endpoints only to have to restart the cycle 3 weeks later. Automation of this process would free up staff time to work on other projects and problems for the city. Approx. two full weeks of 1FTE per month or 960 hours per year saved. Budget Impact/Other Useful Life 1 yearProject Name IT - Patching Automation Software Category Equipment Type Equipment Future Total Project Cost:$458,333 Total20242025202620272028Expenditures 167,25536,000 40,000 40,000 40,000 11,255Equipment 36,000 40,000 40,000 40,000 11,255 167,255Total Total20242025202620272028Funding Sources 167,25536,000 40,000 40,000 40,000 11,255Equipment Replacement Fund 36,000 40,000 40,000 40,000 11,255 167,255Total Wednesday, November 15, 2023 22 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description Laptops for emergency management and training city employees. Project #01-ERP-0021 Priority n/a Justification The city has a need for a mobile computer lab to assist with both emergency management preparedness and with employee training opportunities. The process improvement commmittee has identified a need to setup an internal training program for employees on existing software as well as future software initiatives. This ERP item would purchase 10 - 15 low cost laptops to be utilized for giving employees hands on training with Office, Springbrook, Laserfiche, and other future software. Budget Impact/Other Useful Life 3 yearsProject Name IT - Laptops for Mobile Computer Lab Category Equipment Type Operating Budget Item Future Total Project Cost:$102,777 Total20242025202620272028Expenditures 10,92710,927Equipment 10,927 10,927Total Total20242025202620272028Funding Sources 10,92710,927Equipment Replacement Fund 10,927 10,927Total Wednesday, November 15, 2023 23 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description Upgrade Windows 10 Pro software to Windows 10 Enterprise. Required to renew every 3 years. This plan would bring the PD into compliance in 2020 then upgrade 60 city computers a year until all city computers are upgraded. Each batch of 60 computers needs to be renewed every 3 years. It is estimated that it will take 3 years to fully upgrade the city to Windows 10 Enterprise. Project #01-ERP-0022 Priority n/a Justification The BCA has mandated that we move to Enterprise edition for our Windows computers in the PD. Microsoft is changing the way they deliver Windows. It is becoming like Office, where you will no longer own Windows outright, you will have to rent it from them. We have to switch to Enterprise in the PD for compliance reasons, but it is strongly suggested that we plan on switching to Enterprise for all city computers as well. There may come a time where we are forced to switch to Enterprise edition for the city. It would be ideal to plan ahead and budget money for a gradual upgrade for the city so it doesn't come as a surprise. Budget Impact/Other Useful Life 1 yearProject Name IT - Windows 10 Enterprise Upgrade Category Unassigned Type Equipment Future Total Project Cost:$1,201,909 Total20242025202620272028Expenditures 243,98463,000 43,260 44,558 45,895 47,271Equipment 63,000 43,260 44,558 45,895 47,271 243,984Total Total20242025202620272028Funding Sources 243,98463,000 43,260 44,558 45,895 47,271Equipment Replacement Fund 63,000 43,260 44,558 45,895 47,271 243,984Total Wednesday, November 15, 2023 24 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description The sandbox is a security appliance that integrates into the overall security fabric of the city providing an automated method of detecting malware. Project #01-ERP-0024 Priority n/a Justification The city relies on our sandbox as a place to investigate questionable files that user received to determine if they are safe to open. The sandbox performs automated analysis that would normally take a significatn amount of manual time invested to determine if an item is dangerous. This allows the IT department to perform investigations in minutes instead of hours. The existing sandbox has proved extremly useful over the last 5 years and needs to be replaced because it is no longer supported by the ventor Budget Impact/Other Useful Life 5 yearsProject Name IT - Sandbox Security Appliance Category Equipment Type Equipment Future Total Project Cost:$272,000 Total20242025202620272028Expenditures 45,00045,000Equipment 45,000 45,000Total Total20242025202620272028Funding Sources 45,00045,000Equipment Replacement Fund 45,000 45,000Total Wednesday, November 15, 2023 25 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact IT Director 2024 2028thru Department Comm Svcs - IT Description Computer servers store information and system programs for Police Department. Project #01-ERP-0211 Priority n/a Justification Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used for data storage Budget Impact/Other Useful Life 1 yearProject Name PD - Network Server Category Equipment Type Equipment Future Total Project Cost:$1,118,901 Total20242025202620272028Expenditures 143,54727,038 27,849 28,684 29,545 30,431Equipment 27,038 27,849 28,684 29,545 30,431 143,547Total Total20242025202620272028Funding Sources 143,54727,038 27,849 28,684 29,545 30,431Equipment Replacement Fund 27,038 27,849 28,684 29,545 30,431 143,547Total Wednesday, November 15, 2023 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact City Clerk 2024 2028thru Department Community Services Description Large document (11” x17”) scanner for document management and retention as well as general administrative use. Purchased two scanners in 2012 at a cost of $10,315 - 1 at scanner station, 1 in City Clerk's office Current equipment: Canon DR 7550C Project #01-ERP-0008 Priority n/a Justification Scanners are needed for converting paper copies to electronic data to reduce storage space. Budget Impact/Other Variance from 20 year plan - Two scanners purchased in 2012 and will be replaced every four years. Estimate salvage/resale value on replaced item: $500-$1,000 Useful Life 4 yearsProject Name Document Management Scanner (2)Category Equipment Type Equipment Future Total Project Cost:$101,873 Total20242025202620272028Expenditures 14,30014,300Equipment 14,300 14,300Total Total20242025202620272028Funding Sources 14,30014,300Equipment Replacement Fund 14,300 14,300Total Wednesday, November 15, 2023 27 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Asst City Manager 2024 2028thru Department Community Services Description Included in this request are equipment needed to move to an electronic plan review and inspections process. Revu -Bluebeam electronic plan review software - 2020 - $1,100 (useful life 8-10 years) Ipads - 2020 - $5,400 (useful life 5-6 years) Rental Inspection software - 2020 - $7,500 (useful life 7-10 years) Project #01-ERP-0052 Priority 2 Very Important Justification As more and more contractors and architects ask to submit plan electronically, Blubeam software will enable inspectors to perform electronic plan reviews which will make the plan review process more efficient and enhance customer service. As the inspection and construction industry becomes more paperless, iPads will enable inspectors to use mobile technology to keep up with the requests of engineers, architect, contractors, landlords and residents. Ipads are a key piece that will enable staff to view electronic plans in the field. Going paperless will eventually eliminate our need for paper plan scanning and sorting which is very time consuming and costs $1,500 - $2,000 per year. The software company currently used by Rental Inspectors has recently gone out of business and support for the software is going to be on a very limited basis after 2020. Because rental inspections effect such a large part of the city and the department, I believe getting a new software in place before the existing software stops functioning is essential to the rental inspection program. Budget Impact/Other Useful Life 5-7 yearsProject Name Electronic Inspections Processing Category Equipment Type Equipment Future Total Project Cost:$96,150 Total20242025202620272028Expenditures 16,23116,231Equipment 16,231 16,231Total Total20242025202620272028Funding Sources 16,23116,231Equipment Replacement Fund 16,231 16,231Total Wednesday, November 15, 2023 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru Department Fire Description Fire engine: full size response truck Current vehicle: 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 yearsProject Name Ladder #7 Category Vehicles Type Equipment Future Total Project Cost:$1,700,000 Total20242025202620272028Expenditures 1,700,0001,700,000Equipment 1,700,000 1,700,000Total Total20242025202620272028Funding Sources 1,700,0001,700,000Equipment Replacement Fund 1,700,000 1,700,000Total Wednesday, November 15, 2023 29 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru 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 yearsProject Name Fire Pumper (Engine 3)Category Vehicles Type Equipment Future Total Project Cost:$3,250,000 Total20242025202620272028Expenditures 1,500,0001,500,000Equipment 1,500,000 1,500,000Total Total20242025202620272028Funding Sources 1,500,0001,500,000Equipment Replacement Fund 1,500,000 1,500,000Total Wednesday, November 15, 2023 30 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru Department Fire Description One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on 2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23. Current vehicle: 2008 Pierce Arrow XT Aerial Ladder (#109) Project #01-ERP-0106 Priority n/a Justification Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using $445,427.08 in ERP cash and a 10-year capital lease of $425,000. At the end of the lease term payments (P&I) will total $542,170. Total costs of aerial including cash payments equals $987,597. Budget Impact/Other Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage/resale value on replaced item: $ Useful Life 20 yearsProject Name Aerial Truck Category Vehicles Type Equipment Future Total Project Cost:$2,559,597 Total20242025202620272028Expenditures 1,572,0001,572,000Equipment 1,572,000 1,572,000Total Total20242025202620272028Funding Sources 1,572,0001,572,000Equipment Replacement Fund 1,572,000 1,572,000Total Wednesday, November 15, 2023 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru Department Fire Description Breathing apparatus for interior firefighting for firefighters. Project #01-ERP-0108 Priority n/a Justification The breathing apparatus was taken out of the ERP in 2006 because we thought we were getting a grant. Grant was not successful. The SCBA's (45) need to be replaced because they are at the end of their life and cannot be hydro tested any longer. Budget Impact/Other Variance from 20 year plan - Move back to 2025. Purchased SCBA's in 2015 with grant funds. Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Self Contained Breathing Apparatus (SCBA) (45)Category Equipment Type Equipment Future Total Project Cost:$902,000 Total20242025202620272028Expenditures 400,000400,000Equipment 400,000 400,000Total Total20242025202620272028Funding Sources 400,000400,000Equipment Replacement Fund 400,000 400,000Total Wednesday, November 15, 2023 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru Department Fire Description Used by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and heat may be hidden allowing for faster extinguishment. Note: purchased 2013 & 2017 Project #01-ERP-0112 Priority n/a Justification Current camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was purchased with donation money. Budget Impact/Other Variance from 20 year plan - department owns 2 cameras. Reoccuring expenditure. Estimate salvage/resale value on replaced item: $-0- Useful Life 10 yearsProject Name Thermal Imaging Camera (2)Category Equipment Type Equipment Future Total Project Cost:$149,905 Total20242025202620272028Expenditures 38,60018,600 20,000Equipment 18,600 20,000 38,600Total Total20242025202620272028Funding Sources 38,60018,600 20,000Equipment Replacement Fund 18,600 20,000 38,600Total Wednesday, November 15, 2023 33 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru Department Fire Description Emergency warning system for City of Hopkins. Project #01-ERP-0113 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $-0- Useful Life 20 yearsProject Name Emergency Preparedness Sirens Category Equipment Type Equipment Future Total Project Cost:$72,000 Total20242025202620272028Expenditures 45,00045,000Equipment 45,000 45,000Total Total20242025202620272028Funding Sources 45,00045,000Equipment Replacement Fund 45,000 45,000Total Wednesday, November 15, 2023 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru 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 yearsProject Name Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$68,741 Total20242025202620272028Expenditures 25,50025,500Equipment 25,500 25,500Total Total20242025202620272028Funding Sources 25,50025,500Equipment Replacement Fund 25,500 25,500Total Wednesday, November 15, 2023 35 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru Department Fire Description Portable and mobile radios used by the police departments to allow the department to communicate on one frequency. Fire has 50 portable and 13 mobile radios along with 50 pagers. Cost in ERP includes portable radios (30), portable radio's encrypted (20), mobile radio's (13), pagers (50), chargers single (60), charger base (3) plus other needed equipment. Details of all items are on file with Fire and Finance Depts. Project #01-ERP-0125 Priority n/a Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. Budget Impact/Other In 2016 the Fire radios were separated from Police for better accountability. Project was adjusted for current pricing. 2025 - 356,500 FD 2025 - 29,500 PW Useful Life 5-7 yearsProject Name Fire Radios - Portable and Mobile Devices Category Equipment Type Equipment Future Total Project Cost:$2,424,328 Total20242025202620272028Expenditures 475,000475,000Equipment 475,000 475,000Total Total20242025202620272028Funding Sources 475,000475,000Equipment Replacement Fund 475,000 475,000Total Wednesday, November 15, 2023 36 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Fire Chief 2024 2028thru Department Fire Description Lucus device is used to assist CPR during full arrest. The current device was purchased in 2016 and with changed in technology, it is recommended to update every 5 years. Project #01-ERP-0127 Priority n/a Justification To continue to serve citizens of Hopkins during medical incidents. Budget Impact/Other Reoccurs every 5 years. Useful Life 5 yearsProject Name Fire - Lucus Device Category Equipment Type Equipment Future Total Project Cost:$98,686 Total20242025202620272028Expenditures 18,50018,500Equipment 18,500 18,500Total Total20242025202620272028Funding Sources 18,50018,500Equipment Replacement Fund 18,500 18,500Total Wednesday, November 15, 2023 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2024 2028thru Department Pavilion Description Ice resurfacer used by the Pavilion for ice sheet maintenance. Current equipment: Zamboni Ice Resurfacer 2014 cost = $116,205.93 Asset ID #5176 Project #01-ERP-1000 Priority n/a Justification Replace existing electric (battery) ice resurfacer. The current electric ice resurfacer was purchased in 2014 and has a useful life of 12 years and is scheduled for replacement in 2026. Budget Impact/Other Variance from 20 year plan - Decrease cost due to 2014 purchase price. Move back one year. Estimate salvage/resale value on replaced item: $30,000 Useful Life 12 yearsProject Name Pavilion Ice Resurfacer Category Equipment Type Equipment Future Total Project Cost:$640,251 Total20242025202620272028Expenditures 165,000165,000Equipment 165,000 165,000Total Total20242025202620272028Funding Sources 165,000165,000PA - Pavilion Fund 165,000 165,000Total Wednesday, November 15, 2023 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2024 2028thru Department Pavilion Description Electric ice edger used for ice maintenance of the Pavilion's ice sheet. An edger is used to shave the ice next to the boards to remove ice buildup that the ice resurfacer cannot reach. 2014 cost = $6,281.25 Asset ID #5174 Project #01-ERP-1001 Priority n/a Justification Replace the current battery fueled ice edger with a new model of battery ice edger. Scheduled to replace at the end of useful life should occur in 2026, the model was purchased in 2014. Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Pavilion - Electric Ice Edger Category Equipment Type Equipment Future Total Project Cost:$25,861 Total20242025202620272028Expenditures 8,9008,900Equipment 8,900 8,900Total Total20242025202620272028Funding Sources 8,9008,900PA - Pavilion Fund 8,900 8,900Total Wednesday, November 15, 2023 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Pavilion Manager 2024 2028thru Department Pavilion Description 26" to 28" battery operated walk behind floor scrubber. Floor scrubber is used to clean the arenas concrete floor and tiled surfaces throughout the building. 2014 cost = $8,651.94 Asset ID #5172 Project #01-ERP-1003 Priority n/a Justification Replace the existing floor scrubber with new model. Current floor scrubber was purchased in 2014 and is scheduled to be replaced in 2024. Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Pavilion - Floor Scrubber Category Equipment Type Equipment Future Total Project Cost:$50,567 Total20242025202620272028Expenditures 14,00014,000Equipment 14,000 14,000Total Total20242025202620272028Funding Sources 14,00014,000PA - Pavilion Fund 14,000 14,000Total Wednesday, November 15, 2023 40 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Facilities Director 2024 2028thru Department Pavilion Description 25 foot scissor lift used to perform maintenance duties in the arena. 2014 cost = $10,430.35 Asset ID #5173 Project #01-ERP-1004 Priority 3 Important Justification The current model was purchased in 2014 and is scheduled for replacement in 2029. The scissor lift allows staff the ability to perform maintenance on arena lighting fixtures and other maintenance around the arena ceiling. Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $ Useful Life 15 yearsProject Name Pavilion - Scissor Lift Category Equipment Type Equipment Future Total Project Cost:$35,240 Total20242025202620272028Expenditures 10,00010,000Equipment 10,000 10,000Total Total20242025202620272028Funding Sources 10,00010,000PA - Pavilion Fund 10,000 10,000Total Wednesday, November 15, 2023 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru 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 8 marked patrol vehicles Project #01-ERP-0200 Priority n/a Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget Impact/Other Useful Life 3 yearsProject Name Marked Patrol Vehicles (7)Category Vehicles Type Equipment Future Total Project Cost:$4,793,000 Total20242025202620272028Expenditures 740,000140,000 145,000 150,000 150,000 155,000Vehicles 140,000 145,000 150,000 150,000 155,000 740,000Total Total20242025202620272028Funding Sources 740,000140,000 145,000 150,000 150,000 155,000Equipment Replacement Fund 140,000 145,000 150,000 150,000 155,000 740,000Total Wednesday, November 15, 2023 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru Department Police Description Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. 4 year rotation. Current vehicle: 2021 Ford Utility (#201) VIN #1FM5K8AB6MGB53652 Project #01-ERP-0201 Priority n/a Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget Impact/Other Useful Life 4 yearsProject Name Sergeant's Vehicle Category Vehicles Type Equipment Future Total Project Cost:$604,988 Total20242025202620272028Expenditures 72,50072,500Vehicles 72,500 72,500Total Total20242025202620272028Funding Sources 72,50072,500Equipment Replacement Fund 72,500 72,500Total Wednesday, November 15, 2023 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru Department Police Description Marked patrol vehicle used by Parking Enforcement Officer to respond to calls for service, enforce parking laws, and perfom duties as assigned. Current Vehicle: 2021 Ford Utility (#211) VIN# 1FM5K8AB3MGB53656 Project #01-ERP-0202 Priority n/a Justification Use by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown area. Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget Impact/Other 2016 - Change in replacement schedule due to full time use of vehicle and change of position responsibilities. Next replacement scheduled for 2021 from 2026 Useful Life 5 yearsProject Name PSO / Parking Enforcement Vehicle Category Vehicles Type Equipment Future Total Project Cost:$427,572 Total20242025202620272028Expenditures 75,00075,000Vehicles 75,000 75,000Total Total20242025202620272028Funding Sources 75,00075,000Equipment Replacement Fund 75,000 75,000Total Wednesday, November 15, 2023 44 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru 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 2023 Variance from 20 year plan - Originally this vehicles was scheduled to be replaced in 2022. Ford cancelled the order, and we missed the next order window. Need to replace in 2024 and reset ERP schedule. Useful Life 4 yearsProject Name PSO - Utility 4x4 Category Vehicles Type Equipment Future Total Project Cost:$816,989 Total20242025202620272028Expenditures 180,00085,000 95,000Vehicles 85,000 95,000 180,000Total Total20242025202620272028Funding Sources 180,00085,000 95,000Equipment Replacement Fund 85,000 95,000 180,000Total Wednesday, November 15, 2023 45 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru 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 - 12 squad car cameras Squad cameras 11,100 each over 5 years. The industry has changed its service model for cloud storage of video data. Body worn cameras moved to Video as a Service (VAAS) and incorporated into the general fund. Useful Life 5 yearsProject Name Squad Car Camera Systems Category Equipment Type Equipment Future Total Project Cost:$413,700 Total20242025202620272028Expenditures 133,20026,640 26,640 26,640 26,640 26,640Equipment 26,640 26,640 26,640 26,640 26,640 133,200Total Total20242025202620272028Funding Sources 133,20026,640 26,640 26,640 26,640 26,640Equipment Replacement Fund 26,640 26,640 26,640 26,640 26,640 133,200Total Wednesday, November 15, 2023 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru Department Police Description 12 Tactical Ballistical Vests worn by members of the Hopkins Police Department SWAT (Special Weapons and Tactics) team. These vests offer a higher level of protection for officers involved in high risk situations; this protection offers a higher level of ballistic protection compared to regular duty vests. SWAT team members also require ballistic helmets on the same rotational cycle. Equipment breakdown: 12 vests @ $4,215 = $50,580. 12 ballistic helmets @ $642 = $7,716. 2 New protective shields @ $2,864 = $5,729. 12 Radio headsets @ $1,042 = $12,500. Project #01-ERP-0214 Priority 3 Important Justification Variance - Change in vendor equipment pricing and SWAT team staffing levels. Current price is reflective of a twelve person (fully staffed) SWAT team with current vendor pricing. Budget Impact/Other 5 year replacement schedule Useful Life 5 yearsProject Name Tactical Ballistic Vests / Helmets - SWAT Category Equipment Type Equipment Future Total Project Cost:$628,274 Total20242025202620272028Expenditures 88,69788,697Equipment 88,697 88,697Total Total20242025202620272028Funding Sources 88,69788,697Equipment Replacement Fund 88,697 88,697Total Wednesday, November 15, 2023 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru 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- X7 Tasers, each officer has their own taser. $3,500 per Taser (with cartridges) Useful Life 5 yearsProject Name Taser Replacement Category Equipment Type Equipment Future Total Project Cost:$841,864 Total20242025202620272028Expenditures 160,000160,000Equipment 160,000 160,000Total Total20242025202620272028Funding Sources 160,000160,000Equipment Replacement Fund 160,000 160,000Total Wednesday, November 15, 2023 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2024 2028thru 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 yearsProject Name Building Video Server Category Equipment Type Equipment Future Total Project Cost:$165,907 Total20242025202620272028Expenditures 25,00025,000Equipment 25,000 25,000Total Total20242025202620272028Funding Sources 25,00025,000Equipment Replacement Fund 25,000 25,000Total Wednesday, November 15, 2023 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2024 2028thru 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 2024 for 15 computers. To be replaced in 2024. Project #01-ERP-0220 Priority n/a Justification Mobile Data Computers have a limited life expectancy. The computers facilitate the basic response to emergency calls for service to which police officers respond. Vital information is forwarded to officers via the mobile data computers. Officers complete investigative reports, issue traffic related warnings and citations, and process arrest incidents from the mobile data computers. As technology evolves the officers must be able to access information using up to date computers that can process the large amount of data and applications. Mobile data computers are currently used to host the squad car video camera system and have the potential to be integrated with a possible body worn camera. Budget Impact/Other Change in replacement year to accurately reflect life expectancy in relation to when the computers were purchased. Useful Life 5 yearsProject Name Squad Computers Category Equipment Type Equipment Future Total Project Cost:$561,242 Total20242025202620272028Expenditures 90,00090,000Equipment 90,000 90,000Total Total20242025202620272028Funding Sources 90,00090,000Equipment Replacement Fund 90,000 90,000Total Wednesday, November 15, 2023 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief/IT 2024 2028thru 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 is needed in 2024. This is crucial to police department functions. 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:$700,000 Total20242025202620272028Expenditures 500,000500,000Equipment 500,000 500,000Total Total20242025202620272028Funding Sources 500,000500,000Equipment Replacement Fund 500,000 500,000Total Wednesday, November 15, 2023 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru Department Police Description The police department needs to maintain law and order during times of civil unrest. We need to allow for the peaceful demonstrations and first amendment rights of our community members, while ensuring that we have the ability to keep everyone safe and property from being damaged. This requires specialized equipment for each of our officer. Project #01-ERP-0227 Priority n/a Justification Community safety is our priority and specialized equipment is necessary to perform this core function. This includes full face shielts, soft body armor (turltle gear), gas masks and less lethal munitions, which are necessary to keep officer and the community members safe. The general fund supported numerous acquisitions and purchases in 2021, however this was only a temporary solution. Budget Impact/Other Useful Life 3 yearsProject Name Police Equipment Category Equipment Type Equipment Future Total Project Cost:$214,381 Total20242025202620272028Expenditures 25,00025,000Equipment 25,000 25,000Total Total20242025202620272028Funding Sources 25,00025,000Equipment Replacement Fund 25,000 25,000Total Wednesday, November 15, 2023 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Police Chief 2024 2028thru 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 two 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 yearsProject Name Administrative Vehicles Category Vehicles Type Equipment Future Total Project Cost:$120,000 Total20242025202620272028Expenditures 50,00050,000Vehicles 50,000 50,000Total Total20242025202620272028Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Wednesday, November 15, 2023 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru 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, traffica barricades, etc. Budget Impact/Other Variance from 20 year plan - move up from 2009 to 2008 - Fire Dept. has requested to acquire surplus pickup for its use by daytime responders. Estimated useful life reduced from 10 to 8 years. Estimate salvage/resale value on replaced item: $1,500 Useful Life 8 yearsProject Name 4X4 3/4 Ton Truck - Electric Category Vehicles Type Equipment Future Total Project Cost:$230,189 Total20242025202620272028Expenditures 50,00050,000Vehicles 50,000 50,000Total Total20242025202620272028Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Wednesday, November 15, 2023 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru 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 yearsProject Name PW - Truck Scan Kit Category Vehicles Type Equipment Future Total Project Cost:$43,152 Total20242025202620272028Expenditures 14,14314,143Equipment 14,143 14,143Total Total20242025202620272028Funding Sources 14,14314,143Equipment Replacement Fund 14,143 14,143Total Wednesday, November 15, 2023 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Facilities Director 2024 2028thru Department Public Works: Bldg/Equip Ser Description Replace existing Public Works scissor lift with a used newer model Project #01-ERP-0716 Priority n/a Justification The current scissor lift was purchased in 2007 and can only reach 20'. A lift with a higher reach is needed to perform some tasks in and around Public Works and other facilities. Budget Impact/Other Useful LifeProject Name Scissor Lift Category Equipment Type Unassigned Future Total Project Cost:$10,000 Total20242025202620272028Expenditures 10,00010,000Equipment 10,000 10,000Total Total20242025202620272028Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Wednesday, November 15, 2023 56 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Parks/Forestry Description Trucks used by Parks Division of Public Works. Current vehicles: 2012 Ford F350 4X4 (#801) & 2012 Ford F350 4X4 (#802) Project #01-ERP-0801 Priority n/a Justification Snow plowing, hauling, transportation. Units are heavily used. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Useful Life 8 yearsProject Name 4x4 3/4Ton Trucks (2)Category Vehicles Type Equipment Future Total Project Cost:$623,918 Total20242025202620272028Expenditures 108,000108,000Vehicles 108,000 108,000Total Total20242025202620272028Funding Sources 108,000108,000Equipment Replacement Fund 108,000 108,000Total Wednesday, November 15, 2023 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru 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 4 Less Important 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 yearsProject Name Trucksters (3)Category Equipment Type Equipment Future Total Project Cost:$155,300 Total20242025202620272028Expenditures 27,00027,000Equipment 27,000 27,000Total Total20242025202620272028Funding Sources 27,00027,000Equipment Replacement Fund 27,000 27,000Total Wednesday, November 15, 2023 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2024 2028thru Department Public Works: Parks/Forestry Description Riding mowers used by Parks Division of Public Works. Current equipment: 2004 Toro Zero Turn (#826), 2006 Jacobson Rotary Mower (#823) Project #01-ERP-0808 Priority 1 Urgent Justification Mowing city parks and right of ways. Move replacement of #826 to 2021 - Ran 10 years past useful life Move replacement of #823 to 2021 Both replacements of current vehicles were held off in 2020 due to the COVID-19 Pandemic. Budget Impact/Other 2021 - Replace 2004 Zero Turn #826 at $15,000 2021 - Replace 2006 Jacobson #823 at $35,000 The Jacobson will be replaced with 7500-D Zmaster Toro Zero Turn Useful Life 6 yearsProject Name Riding Mowers (2)Category Equipment Type Equipment Future Total Project Cost:$329,130 Total20242025202620272028Expenditures 55,00055,000Equipment 55,000 55,000Total Total20242025202620272028Funding Sources 55,00055,000Equipment Replacement Fund 55,000 55,000Total Wednesday, November 15, 2023 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Parks/Forestry Description Large turf mower (11' cutting width) used by Parks Division of Public Works. Current equipment: 2010 Toro Groundmaster (#825) Project #01-ERP-0810 Priority n/a Justification Required to efficiently mow large parks. Budget Impact/Other Variance from 20 year plan - move from 2011 to 2010 due to poor condition of existing mower. Estimated useful life reduced from 10 to 8 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 8 yearsProject Name Large Turf Mower Category Equipment Type Equipment Future Total Project Cost:$486,659 Total20242025202620272028Expenditures 121,609121,609Equipment 121,609 121,609Total Total20242025202620272028Funding Sources 121,609121,609Equipment Replacement Fund 121,609 121,609Total Wednesday, November 15, 2023 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru 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 5 Future Consideration Justification Allows one truck to pull two riding mowers to parks Budget Impact/Other Variance from 20 year plan - extend life 4 years due to overhaul/refurbishment. Estimate salvage/resale value on replaced item: $ 2016-Increased estimated replacement cost from $2,200 to $10,000 Useful Life 15 yearsProject Name Trailer Flatbed Category Equipment Type Equipment Future Total Project Cost:$26,980 Total20242025202620272028Expenditures 10,00010,000Equipment 10,000 10,000Total Total20242025202620272028Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Wednesday, November 15, 2023 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Parks/Forestry Description Use by Public Works for snow removal, skating rinks, sweeping, ballfield maintenance and transportation of people and materials. Current vehicle: 2010 Bobcat (#815) Project #01-ERP-0816 Priority n/a Justification New machine. Budget Impact/Other Variance from 20 year plan - New item which replaces one tractor. Estimate salvage/resale value on replaced item: $ Useful Life 8 yearsProject Name Toolcat Category Equipment Type Equipment Future Total Project Cost:$423,804 Total20242025202620272028Expenditures 80,20080,200Equipment 80,200 80,200Total Total20242025202620272028Funding Sources 80,20080,200Equipment Replacement Fund 80,200 80,200Total Wednesday, November 15, 2023 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Parks/Forestry Description Forestry boom truck, used to trim/remove trees. Has chipper box on back to haul chipped wood. Is also used to replace lights too high for traffic boom. Current equipment: 812 2010 Freightliner Project #01-ERP-0818 Priority n/a Justification Is used every day during summer months and as needed during winter. It is reaching the end of its lifecycle. Budget Impact/Other Useful LifeProject Name Forestry Boom/Chipper Box Truck Category Equipment Type Equipment Future Total Project Cost:$240,000 Total20242025202620272028Expenditures 240,000240,000Equipment 240,000 240,000Total Total20242025202620272028Funding Sources 240,000240,000Equipment Replacement Fund 240,000 240,000Total Wednesday, November 15, 2023 63 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru 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 yearsProject Name 4X4 3/4 Ton Truck with Plow Category Vehicles Type Equipment Future Total Project Cost:$203,519 Total20242025202620272028Expenditures 38,50038,500Vehicles 38,500 38,500Total Total20242025202620272028Funding Sources 38,50038,500Equipment Replacement Fund 38,500 38,500Total Wednesday, November 15, 2023 64 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Streets/Traffic Description Truck is used in the Street Division of Public Works. Current vehicles: 2000 Ford F450 (#805) & 2011 Ford F350 (#308) Project #01-ERP-0303 Priority n/a Justification Vehicle used by various departments for street and park maintenance and light hauling. Budget Impact/Other Variance from 20 year plan - move back from 2009 to 2010. Estimated useful life reduced from 12 to 8 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 10 yearsProject Name 1 Ton Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$292,100 Total20242025202620272028Expenditures 60,00060,000Vehicles 60,000 60,000Total Total20242025202620272028Funding Sources 60,00060,000Equipment Replacement Fund 60,000 60,000Total Wednesday, November 15, 2023 65 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Streets/Traffic Description Boom truck used in Street and Traffic Divisions of Public Works. Current vehicle: 2012 Ford F450 (#309) Project #01-ERP-0304 Priority n/a Justification Vehicle used by Traffic Department for signal and light pole maintenance. Budget Impact/Other Variance from 20 year plan - Increase amount to reflect actual. Estimate salvage/resale value on replaced item: $8,000 Useful life moved from 17 years to 12 years. Useful Life 12 yearsProject Name 1 Ton Traffic Boom Truck Category Vehicles Type Equipment Future Total Project Cost:$413,400 Total20242025202620272028Expenditures 136,400136,400Vehicles 136,400 136,400Total Total20242025202620272028Funding Sources 136,400136,400Equipment Replacement Fund 136,400 136,400Total Wednesday, November 15, 2023 66 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Streets/Traffic Description Current equipment: 2005 Caterpillar 938G (#322) Project #01-ERP-0308 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $ Useful Life 15-18 yearsProject Name Front End Loaders (2)Category Equipment Type Equipment Future Total Project Cost:$998,500 Total20242025202620272028Expenditures 268,000268,000Equipment 268,000 268,000Total Total20242025202620272028Funding Sources 268,000268,000Equipment Replacement Fund 268,000 268,000Total Wednesday, November 15, 2023 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Streets/Traffic Description Loading trucks, landscape work, snow removal, material handling. Current equipment: 2011 Bobcat S650 Skid-Steer Loader (#325) Project #01-ERP-0309 Priority n/a Justification Budget Impact/Other Estimate salvage/resale value on replaced item: $ Useful Life 10 yearsProject Name Skid Loader (2)Category Equipment Type Equipment Future Total Project Cost:$258,900 Total20242025202620272028Expenditures 59,70059,700Equipment 59,700 59,700Total Total20242025202620272028Funding Sources 59,70059,700Equipment Replacement Fund 59,700 59,700Total Wednesday, November 15, 2023 68 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Streets/Traffic Description The City currently utilizes an Elgin Pelican Mechanical Sweeper (01-ERP-311). This type of sweeper is for heavy spring sweeps and is labor intensive due to the need for a water truck and dump truck to assist during its use. The proposed sweeper is a vacuum type sweeper that regenerates its air to vacuum up dirt and debris. The vacuum is effective in its ability to pick up even the smallest of dirt without the use of pre- wetting . It is also a truck type unit so it can be used by one operator to drive to a dump site to empty the sweepings without the need of a separate dump truck. Project #01-ERP-0319 Priority n/a Justification The existing sweeper that was due for replacement in 2013 for $156,400 will be moved out to 2021 and scheduled every twenty years. The new machine will also be a 20 year machine and budgeted at $185,000. The reduced usage by having two machines will allow us to keep both for a longer time and allow us more flexibility on different types of sweeping and reduce the labor needed to perform this duty. Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value one replaced item: $ Useful Life 15 yearsProject Name Regenerative Air Sweeper Category Equipment Type Equipment Future Total Project Cost:$395,000 Total20242025202620272028Expenditures 210,000210,000Equipment 210,000 210,000Total Total20242025202620272028Funding Sources 210,000210,000Equipment Replacement Fund 210,000 210,000Total Wednesday, November 15, 2023 69 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Public Works: Streets/Traffic Description Streets trailer used for paver and light poles Current equipment 350 1993 T3 Trailer Project #01-ERP-0323 Priority 3 Important Justification This trailer is well past its lifecycle. PW request a new trailer able to haul PDI blocks for road closures. Budget Impact/Other Useful Life 20 yearsProject Name Trailer Category Equipment Type Equipment Future Total Project Cost:$30,000 Total20242025202620272028Expenditures 30,00030,000Equipment 30,000 30,000Total Total20242025202620272028Funding Sources 30,00030,000Equipment Replacement Fund 30,000 30,000Total Wednesday, November 15, 2023 70 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact 2024 2028thru Department Public Works: Streets/Traffic Description Floor sweeper for PW parking garage and Public Parking ramp Current equipment: 351 2004 Tennant Sweeper Project #01-ERP-0324 Priority 3 Important Justification Current sweeper is past its useful life. Current sweeper is not big enough to handle either space. City rents a sweeper to clean ramp. Budget Impact/Other Useful Life 20 yearsProject Name Riding Floor Sweeper Category Equipment Type Equipment Future Total Project Cost:$40,000 Total20242025202620272028Expenditures 40,00040,000Equipment 40,000 40,000Total Total20242025202620272028Funding Sources 40,00040,000Equipment Replacement Fund 40,000 40,000Total Wednesday, November 15, 2023 71 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Bldg/Equip Supt 2024 2028thru Department Refuse Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 2011 Freightliner Rapid Rail (#900) Project #01-ERP-0900 Priority n/a Justification Residential waste pick up. Budget Impact/Other Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Useful Life 8 yearsProject Name Refuse Truck (RAP-R) (2)Category Vehicles Type Equipment Future Total Project Cost:$1,950,700 Total20242025202620272028Expenditures 275,200275,200Vehicles 275,200 275,200Total Total20242025202620272028Funding Sources 275,200275,200RF - Refuse Fund 275,200 275,200Total Wednesday, November 15, 2023 72 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Sewer Description 3/4 ton utility truck used by the Water/Sewer Division of Public Works. Current vehicle: 2007 Chevrolet Pickup (#505) Project #01-ERP-0551 Priority n/a Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Useful Life 10 yearsProject Name 3/4 Ton Utility Truck Category Vehicles Type Equipment Future Total Project Cost:$190,546 Total20242025202620272028Expenditures 45,20045,200Vehicles 45,200 45,200Total Total20242025202620272028Funding Sources 45,20045,200SF - Sanitary Sewer Fund 45,200 45,200Total Wednesday, November 15, 2023 73 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru 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 2 Very Important Justification Emergency back up generator for lift stations and pumps, off site power for lights and welding. Budget Impact/Other Estimated useful life reduced from 25 to 20 years. Estimate salvage/resale value on replaced item: $2,500 Useful Life 20 yearsProject Name Generator (2)Category Equipment Type Equipment Future Total Project Cost:$79,000 Total20242025202620272028Expenditures 43,00043,000Equipment 43,000 43,000Total Total20242025202620272028Funding Sources 43,00043,000SF - Sanitary Sewer Fund 43,000 43,000Total Wednesday, November 15, 2023 74 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru 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 yearsProject Name 3/4 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$136,881 Total20242025202620272028Expenditures 36,00036,000Vehicles 36,000 36,000Total Total20242025202620272028Funding Sources 36,00036,000WF - Water Fund 36,000 36,000Total Wednesday, November 15, 2023 75 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP Contact Public Works Director 2024 2028thru Department Water Description 3/4 ton utility truck used by the Water Division of Public Works. Current vehicle: 2006 Chevrolet Pickup Project #01-ERP-0501 Priority n/a Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. Budget Impact/Other Variance from 20 year plan - moved up from 2017 to 2016 Estimate salvage/resale value on replaced item: $2,500 Useful Life 10 yearsProject Name 3/4 Ton Utility Truck Category Vehicles Type Equipment Future Total Project Cost:$144,929 Total20242025202620272028Expenditures 46,90046,900Vehicles 46,900 46,900Total Total20242025202620272028Funding Sources 46,90046,900WF - Water Fund 46,900 46,900Total Wednesday, November 15, 2023 76