Loading...
VII.2. Adoption of 2022-2026 Equipment Replacement Plan; Bishop December 14, 2021 Council Report 2021-123 2022-2026 EQUIPMENT REPLACEMENT PLAN (ERP) Proposed Action Staff recommends adoption of the following motion: Move to adopt the 2022-2026 Equipment Replacement Plan. Overview The equipment replacement plan is a detailed summary of the next five years projected equipment purchases. General and Special Revenue (except Arts Center) fund equipment items are placed in the Equipment Replacement Fund budget which derives its revenues from service charges to the General and Special Revenue funds, tax levy, equipment sales and interest earnings. (No tax levy was approved for 2022.) The Arts Center and Enterprise fund equipment in the plan is placed in the individual fund budgets, in the year in which the equipment is to be purchased. Approval of the 2022-2026 ERP allows staff to begin preparation for their purchase. Items that fall under the Minnesota Statutes Uniform Bidding/Contracting Laws will require further approval by the council before their purchase. Staff is recommending adoption of the plan. Primary Issues to Consider • Does adoption of the ERP mean projects will be implemented? Adoption of the motion will authorize staff to prepare for purchases scheduled in 2022. Years 2023- 2026 serve as a long-range plan and purchases are not authorized by approving the plan. Appropriate notifications would also be made for those projects that have funding implications. • Are funds available for all projects? The plan outlines funding implications if all projects are implemented. Necessary funding changes have been anticipated as part of this plan, and are recommended therein. All equipment scheduled for 2022 is funded. Supporting Information • Overview of Equipment Replacement Fund • 2022-2026 Equipment Replacement Plan Summary ______________________________________ Nick Bishop, CPA Finance Director Financial Impact: $ as provided in plan Budgeted: Y/N X N Source: Various Related Documents (CIP, ERP, etc.): __ERP_________ Notes: ____________________ Equipment Replacement Fund This fund accounts for the purchase of machinery and equipment. In 2022 purchases will be funded through equipment charges and the issuance of equipment certificates (debt). Equipment charges are billed to various City departments and are over 99% in the General Fund. There is no tax levy approved for equipment replacement in 2022. In 2022, the Equipment Replacement Fund has projected revenues of $1,681,540, including debt proceeds of $996,000. The projected expenditures are $1,620,477. Major purchases proposed for 2022 include a Quick Attack Pumper Fire Truck ($771,000) and Single Axle Dump Truck ($225,000). The fund is projected to increase its net position by $61,063 and end 2022 with a net position of $845,691. The $75,000 tax levy shown at the November 9, 2021 work session has been eliminated. 2022 2023 Beginning Fund Balance 784,628 845,691 Revenues & Other Financing Sources Tax Levy - 250,000 Equipment Charges 669,755 709,941 Sale of Equipment 15,000 35,000 Interest Earnings 785 1,175 Equipment Certificates (Bonds)996,000 - Total Revenue & Other Financing Sources 1,681,540 996,116 Expenditures & Other Financing Uses Current Expenditures 35,248 35,600 Capital Projects Community Services - Activity Center 37,000 12,000 Community Services - Information Technology 225,729 333,085 Fire Vehicles & Equipment 787,000 125,000 Police Vehicles & Equipment 207,100 595,912 Public Works: Parks/Forestry - 199,000 Public Works: Streets/Traffic 328,400 83,500 Total Expenditures and Other Financing Sources 1,620,477 1,384,097 Increase (Decrease) in Fund Balance 61,063 (387,981) Projected Ending Fund Balance 845,691 457,710 Equipment Replacement Fund - Projected Cash Flows EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY YEAR 2022 2026thru Project Name Department Project #Priority Project Cost 2022 01-ERP-0038Activity Center - Kitchen Storage 5 17,000Comm Svcs - Activity Center 01-ERP-0042Activity Center - Replace Sanitizer/Heat Booster 2 20,000Comm Svcs - Activity Center 01-ERP-1105Art Center Jaycee Studio Audio Visual n/a 13,500Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 25,000Comm Svcs - IT 01-ERP-0006Computers n/a 34,729Comm Svcs - IT 01-ERP-0009Network Infrastructure Upgrade n/a 0Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 44,000Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 42,000Comm Svcs - IT 01-ERP-0024IT - Sandbox Security Appliance n/a 45,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 25,000Comm Svcs - IT 01-ERP-0105Fire Engine/Rescue (2)n/a 771,000Fire 01-ERP-0126Fire - Fire Helmets n/a 16,000Fire 01-ERP-0401HRA Copier n/a 16,500HRA 01-ERP-0200Marked Patrol Vehicles (7)n/a 110,000Police 01-ERP-0203PSO - Utility 4x4 n/a 72,100Police 01-ERP-0227Police Equipment n/a 25,000Police 01-ERP-03031 Ton Dump Truck (2)n/a 53,400Public Works: Streets/Traffic 01-ERP-0305Single Axle Dump Truck (2)n/a 225,000Public Works: Streets/Traffic 01-ERP-0309Skid Loader (2)n/a 50,000Public Works: Streets/Traffic 01-ERP-0555Generator (2)n/a 43,000Sewer 01-ERP-0560Sewer Televising Camera and Van 1 180,000Sewer 1,838,229Total for 2022 2023 01-ERP-0038Activity Center - Kitchen Storage 5 12,000Comm Svcs - Activity Center 01-ERP-0003CH - Network Server n/a 26,250Comm Svcs - IT 01-ERP-0004Telephone System n/a 89,600Comm Svcs - IT 01-ERP-0006Computers n/a 36,465Comm Svcs - IT 01-ERP-0015Backup Server n/a 72,120Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 44,000Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 42,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 26,250Comm Svcs - IT 01-ERP-0109Extrication Tool (1)n/a 32,000Fire 01-ERP-0127Fire - Lucus Device n/a 18,000Fire 01-ERP-0131Fire - Station Alerting System n/a 75,000Fire 01-ERP-04004x4 3/4 Ton Truck n/a 41,100HRA 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 76,512Police 01-ERP-0215Police - Portable Radios n/a 290,000Police 01-ERP-0217Taser Replacement n/a 90,000Police 01-ERP-0218Building Video Server n/a 22,000Police 01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry Wednesday, December 8, 2021 Project Name Department Project #Priority Project Cost 01-ERP-0804Log Truck n/a 163,600Public Works: Parks/Forestry 01-ERP-03004x4 1/2 Ton Pickup with Plow n/a 28,900Public Works: Streets/Traffic 01-ERP-03041 Ton Traffic Boom Truck n/a 136,400Public Works: Streets/Traffic 1,484,997Total for 2023 2024 01-ERP-1107Art Center Theater Projection Screen 2 6,700Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 27,037Comm Svcs - IT 01-ERP-0006Computers n/a 37,559Comm Svcs - IT 01-ERP-0012Core Network Switch n/a 20,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 45,320Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 63,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 27,038Comm Svcs - IT 01-ERP-1003Pavilion - Floor Scrubber n/a 11,600Pavilion 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0212Squad Car Camera Systems/ Body Worn Camera n/a 160,000Police 01-ERP-0220Squad Computers n/a 90,000Police 01-ERP-0221Records Management System n/a 150,000Police 01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry 01-ERP-03031 Ton Dump Truck (2)n/a 49,500Public Works: Streets/Traffic 01-ERP-0308Front End Loaders (2)n/a 268,600Public Works: Streets/Traffic 1,093,754Total for 2024 2025 01-ERP-1109Art Center Floor Scrubber n/a 10,800Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 27,849Comm Svcs - IT 01-ERP-0005Financial Software - Various Depts.n/a 315,000Comm Svcs - IT 01-ERP-0006Computers n/a 38,686Comm Svcs - IT 01-ERP-0014Distribution Network Switches n/a 57,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 46,680Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,300Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 43,260Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 27,849Comm Svcs - IT 01-ERP-0052Electronic Inspections Processing 2 16,231Community Services 01-ERP-0108Self Contained Breathing Apparatus (SCBA) (45)n/a 250,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 16,180Fire 01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 386,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 117,400Police 01-ERP-0201Sergeant's Vehicle n/a 64,154Police 01-ERP-0227Police Equipment n/a 25,000Police 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 275,200Refuse 1,727,589Total for 2025 2026 01-ERP-0035Activity Center - Floor Scrubber n/a 6,700Comm Svcs - Activity Center 01-ERP-1102Art Center Kitchen Catering Equipment n/a 7,100Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 28,684Comm Svcs - IT 01-ERP-0006Computers n/a 39,847Comm Svcs - IT 01-ERP-0015Backup Server n/a 78,808Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 48,080Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 10,609Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 44,558Comm Svcs - IT 01-ERP-0024IT - Sandbox Security Appliance n/a 45,000Comm Svcs - IT Wednesday, December 8, 2021 Project Name Department Project #Priority Project Cost 01-ERP-0211PD - Network Server n/a 28,684Comm Svcs - IT 01-ERP-0113Emergency Preparedness Sirens n/a 38,500Fire 01-ERP-1000Pavilion Ice Resurfacer n/a 165,000Pavilion 01-ERP-1001Pavilion - Electric Ice Edger n/a 8,900Pavilion 01-ERP-1002Pavilion Arena Scoreboard n/a 12,000Pavilion 01-ERP-0200Marked Patrol Vehicles (7)n/a 128,000Police 01-ERP-0202PSO / Parking Enforcement Vehicle n/a 60,000Police 01-ERP-0203PSO - Utility 4x4 n/a 86,100Police 01-ERP-0218Building Video Server n/a 17,000Police 01-ERP-07104X4 3/4 Ton Truck n/a 42,100Public Works: Bldg/Equip Serv 01-ERP-0808Riding Mowers (2)1 17,700Public Works: Parks/Forestry 01-ERP-0816Toolcat n/a 80,200Public Works: Parks/Forestry 01-ERP-0317Sign Machine (Traffic)n/a 18,100Public Works: Streets/Traffic 01-ERP-05513/4 Ton Utility Truck n/a 45,200Sewer 01-ERP-05013/4 Ton Utility Truck n/a 46,900Water 1,103,770Total for 2026 GRAND TOTAL 7,248,339 Wednesday, December 8, 2021 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2022 2026thru Total20222023202420252026Department Comm Svcs - Activity Center 55,70037,000 12,000 6,700 Comm Svcs - Arts Center 38,10013,500 6,700 10,800 7,100 Comm Svcs - IT 1,693,262225,729 346,685 229,954 566,624 324,270 Community Services 16,23116,231 Fire 1,602,680787,000 125,000 652,180 38,500 HRA 57,60016,500 41,100 Pavilion 197,50011,600 185,900 Police 1,818,066207,100 595,912 517,400 206,554 291,100 Public Works: Bldg/Equip Serv 42,10042,100 Public Works: Parks/Forestry 306,900199,000 10,000 97,900 Public Works: Streets/Traffic 829,900328,400 165,300 318,100 18,100 Refuse 275,200275,200 Sewer 268,200223,000 45,200 Water 46,90046,900 1,838,229 1,484,997 1,093,754 1,727,589 1,103,770 7,248,339TOTAL Wednesday, December 8, 2021 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2022 2026thru Total20222023202420252026DepartmentProject #Priority Comm Svcs - Activity Center 01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a 01-ERP-0038 29,00017,000 12,000Activity Center - Kitchen Storage 5 01-ERP-0042 20,00020,000Activity Center - Replace Sanitizer/Heat Booster 2 55,70037,000 12,000 6,700Comm Svcs - Activity Center Total Comm Svcs - Arts Center 01-ERP-1102 7,1007,100Art Center Kitchen Catering Equipment n/a 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 38,10013,500 6,700 10,800 7,100Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0003 134,82025,000 26,250 27,037 27,849 28,684CH - Network Server n/a 01-ERP-0004 89,60089,600Telephone System n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 187,28634,729 36,465 37,559 38,686 39,847Computersn/a 01-ERP-0009 00Network Infrastructure Upgrade n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 01-ERP-0015 150,92872,120 78,808Backup Server n/a 01-ERP-0017 228,08044,000 44,000 45,320 46,680 48,080IT - Office 365 n/a 01-ERP-0020 50,90910,000 10,000 10,000 10,300 10,609IT - Patching Automation Software 1 01-ERP-0022 234,81842,000 42,000 63,000 43,260 44,558IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0024 90,00045,000 45,000IT - Sandbox Security Appliance n/a 01-ERP-0211 134,82125,000 26,250 27,038 27,849 28,684PD - Network Server n/a 1,693,262225,729 346,685 229,954 566,624 324,270Comm Svcs - IT Total Community Services 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 16,23116,231Community Services Total Fire 01-ERP-0105 771,000771,000Fire Engine/Rescue (2)n/a 01-ERP-0108 250,000250,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0109 32,00032,000Extrication Tool (1)n/a 01-ERP-0112 16,18016,180Thermal Imaging Camera (2)n/a 01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a 01-ERP-0125 386,000386,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0131 75,00075,000Fire - Station Alerting System n/a Wednesday, December 8, 2021 Total20222023202420252026DepartmentProject #Priority 1,602,680787,000 125,000 652,180 38,500Fire Total HRA 01-ERP-0400 41,10041,1004x4 3/4 Ton Truck n/a 01-ERP-0401 16,50016,500HRA Copier n/a 57,60016,500 41,100HRA Total Pavilion 01-ERP-1000 165,000165,000Pavilion Ice Resurfacer n/a 01-ERP-1001 8,9008,900Pavilion - Electric Ice Edger n/a 01-ERP-1002 12,00012,000Pavilion Arena Scoreboard n/a 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 197,50011,600 185,900Pavilion Total Police 01-ERP-0200 590,200110,000 117,400 117,400 117,400 128,000Marked Patrol Vehicles (7)n/a 01-ERP-0201 64,15464,154Sergeant's Vehicle n/a 01-ERP-0202 60,00060,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 158,20072,100 86,100PSO - Utility 4x4 n/a 01-ERP-0212 160,000160,000Squad Car Camera Systems/ Body Worn Camera n/a 01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 90,00090,000Taser Replacement n/a 01-ERP-0218 39,00022,000 17,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0221 150,000150,000Records Management System n/a 01-ERP-0227 50,00025,000 25,000Police Equipment n/a 1,818,066207,100 595,912 517,400 206,554 291,100Police Total Public Works: Bldg/Equip Serv 01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a 42,10042,100Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0808 17,70017,700Riding Mowers (2)1 01-ERP-0814 10,00010,000Trailer Flatbed n/a 01-ERP-0816 80,20080,200Toolcatn/a 306,900199,000 10,000 97,900Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0303 102,90053,400 49,5001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a 01-ERP-0308 268,600268,600Front End Loaders (2)n/a 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a 829,900328,400 165,300 318,100 18,100Public Works: Streets/Traffic Total Wednesday, December 8, 2021 Total20222023202420252026DepartmentProject #Priority Refuse 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a 275,200275,200Refuse Total Sewer 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 01-ERP-0560 180,000180,000Sewer Televising Camera and Van 1 268,200223,000 45,200Sewer Total Water 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 46,90046,900Water Total GRAND TOTAL 7,248,3391,838,229 1,484,997 1,093,754 1,727,589 1,103,770 Wednesday, December 8, 2021 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2022 thru 2026 TotalSource20222023202420252026 AC - Arts Center Fund 38,10013,500 6,700 10,800 7,100 Equipment Replacement Fund 6,261,4391,585,229 1,348,497 1,067,454 1,441,589 818,670 HRA - Housing and Redevelopment Authority 57,60016,500 41,100 PA - Pavilion Fund 197,50011,600 185,900 PKG - Parking Fund 8,0008,000 RF - Refuse Fund 357,00081,800 275,200 SF - Sanitary Sewer Fund 275,000223,000 6,800 45,200 WF - Water Fund 53,7006,800 46,900 1,838,229 1,484,997 1,093,754 1,727,589 1,103,770 7,248,339GRAND TOTAL Wednesday, December 8, 2021 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2022 2026thru TotalSourceProject #Priority 2022 2023 2024 2025 2026 AC - Arts Center Fund 01-ERP-1102 7,1007,100Art Center Kitchen Catering Equipment n/a 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 38,10013,500 6,700 10,800 7,100AC - Arts Center Fund Total Equipment Replacement Fund 01-ERP-0003 134,82025,000 26,250 27,037 27,849 28,684CH - Network Server n/a 01-ERP-0004 76,00076,000Telephone System n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 187,28634,729 36,465 37,559 38,686 39,847Computersn/a 01-ERP-0009 00Network Infrastructure Upgrade n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 01-ERP-0015 150,92872,120 78,808Backup Server n/a 01-ERP-0017 228,08044,000 44,000 45,320 46,680 48,080IT - Office 365 n/a 01-ERP-0020 50,90910,000 10,000 10,000 10,300 10,609IT - Patching Automation Software 1 01-ERP-0022 234,81842,000 42,000 63,000 43,260 44,558IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0024 90,00045,000 45,000IT - Sandbox Security Appliance n/a 01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a 01-ERP-0038 29,00017,000 12,000Activity Center - Kitchen Storage 5 01-ERP-0042 20,00020,000Activity Center - Replace Sanitizer/Heat Booster 2 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 01-ERP-0105 771,000771,000Fire Engine/Rescue (2)n/a 01-ERP-0108 250,000250,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0109 32,00032,000Extrication Tool (1)n/a 01-ERP-0112 16,18016,180Thermal Imaging Camera (2)n/a 01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a 01-ERP-0125 386,000386,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0131 75,00075,000Fire - Station Alerting System n/a 01-ERP-0200 590,200110,000 117,400 117,400 117,400 128,000Marked Patrol Vehicles (7)n/a 01-ERP-0201 64,15464,154Sergeant's Vehicle n/a 01-ERP-0202 60,00060,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 158,20072,100 86,100PSO - Utility 4x4 n/a 01-ERP-0211 134,82125,000 26,250 27,038 27,849 28,684PD - Network Server n/a 01-ERP-0212 152,000152,000Squad Car Camera Systems/ Body Worn Camera n/a 01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 90,00090,000Taser Replacement n/a 01-ERP-0218 39,00022,000 17,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a Wednesday, December 8, 2021 TotalSourceProject #Priority 2022 2023 2024 2025 2026 01-ERP-0221 150,000150,000Records Management System n/a 01-ERP-0227 50,00025,000 25,000Police Equipment n/a 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0303 102,90053,400 49,5001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a 01-ERP-0308 268,600268,600Front End Loaders (2)n/a 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a 01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0808 17,70017,700Riding Mowers (2)1 01-ERP-0814 10,00010,000Trailer Flatbed n/a 01-ERP-0816 80,20080,200Toolcatn/a 6,261,4391,585,229 1,348,497 1,067,454 1,441,589 818,670Equipment Replacement Fund Total HRA - Housing and Redevelopment A 01-ERP-0400 41,10041,1004x4 3/4 Ton Truck n/a 01-ERP-0401 16,50016,500HRA Copier n/a 57,60016,500 41,100HRA - Housing and Redevelopment Authority Total PA - Pavilion Fund 01-ERP-1000 165,000165,000Pavilion Ice Resurfacer n/a 01-ERP-1001 8,9008,900Pavilion - Electric Ice Edger n/a 01-ERP-1002 12,00012,000Pavilion Arena Scoreboard n/a 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 197,50011,600 185,900PA - Pavilion Fund Total PKG - Parking Fund 01-ERP-0212 8,0008,000Squad Car Camera Systems/ Body Worn Camera n/a 8,0008,000PKG - Parking Fund Total RF - Refuse Fund 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a 357,00081,800 275,200RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 01-ERP-0560 180,000180,000Sewer Televising Camera and Van 1 275,000223,000 6,800 45,200SF - Sanitary Sewer Fund Total WF - Water Fund Wednesday, December 8, 2021 TotalSourceProject #Priority 2022 2023 2024 2025 2026 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 53,7006,800 46,900WF - Water Fund Total 7,248,3391,838,229 1,484,997 1,093,754 1,727,589 1,103,770GRAND TOTAL Wednesday, December 8, 2021