Loading...
VII.5. Adoption of the 2023-2027 Equipment Replacement Plan (ERP); Bishop September 6, 2022 Council Report 2022-082 2023-2027 EQUIPMENT REPLACEMENT PLAN (ERP) Proposed Action Staff recommends adoption of the following motion: Move to adopt the 2023-2027 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. 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 2023-2027 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 2023. Years 2024- 2027 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 2023 is funded. Supporting Information • Overview of Equipment Replacement Fund • 2023-2027 Equipment Replacement Plan Summary ______________________________________ Nick Bishop, CPA Finance Director Financial Impact: $ as provided in plan Budgeted: Y/N Y Source: Various Related Documents (CIP, ERP, etc.): __ERP_________ Notes: ____________________ Equipment Replacement Fund This fund accounts for the purchase of machinery and equipment. In 2023 purchases will be funded through equipment charges, tax levy, the issuance of equipment certificates (debt) and transfers in. Equipment charges are billed to various City departments and are over 99% in the General Fund. In 2023, the Equipment Replacement Fund has projected revenues of $1,307,210, including transfers in of $220,564. The projected expenditures are $1,763,945. Major purchases proposed for 2022 include, portable radios ($290,000), police records management system ($200,000) and a log truck ($163,600). The fund is projected to decrease its net position by $429,735 and end 2023 with a net position of $560,917. The fund will rebound and end 2024 with a fund balance of $990,652. EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY YEAR 2023 2027thru Project Name Department Project #Priority Project Cost 2023 01-ERP-0003CH - Network Server n/a 26,250Comm Svcs - IT 01-ERP-0004Telephone System n/a 89,600Comm Svcs - IT 01-ERP-0006Computers n/a 36,465Comm Svcs - IT 01-ERP-0009Network Infrastructure Upgrade - Fiber n/a 60,000Comm Svcs - IT 01-ERP-0015Backup Server n/a 72,120Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 44,000Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 33,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 42,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 26,250Comm Svcs - IT 01-ERP-0109Extrication Tool (1)n/a 38,000Fire 01-ERP-0127Fire - Lucus Device n/a 18,000Fire 01-ERP-0131Fire - Station Alerting System n/a 100,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 120,000Police 01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT 3 81,160Police 01-ERP-0215Police - Portable Radios n/a 290,000Police 01-ERP-0217Taser Replacement n/a 140,000Police 01-ERP-0218Building Video Server n/a 22,000Police 01-ERP-0221Records Management System n/a 200,000Police 01-ERP-0227Police Equipment n/a 25,000Police 01-ERP-0228Administrative Vehicles n/a 70,000Police 01-ERP-08001/2 Ton Pickup Truck n/a 35,400Public Works: Parks/Forestry 01-ERP-0804Log Truck n/a 163,600Public Works: Parks/Forestry 01-ERP-03004x4 1/2 Ton Pickup with Plow n/a 28,900Public Works: Streets/Traffic 01-ERP-0322Streets/Parks Supervisor Vehicle 1 35,000Public Works: Streets/Traffic 01-ERP-0510Utilities Supervisor Vehicle n/a 35,000Water 1,831,745Total for 2023 2024 01-ERP-1105Art Center Jaycee Studio Audio Visual n/a 13,500Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 27,037Comm Svcs - IT 01-ERP-0006Computers n/a 37,559Comm Svcs - IT 01-ERP-0012Core Network Switch n/a 20,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 45,320Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 36,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 63,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 27,038Comm Svcs - IT 01-ERP-1003Pavilion - Floor Scrubber n/a 11,600Pavilion 01-ERP-0200Marked Patrol Vehicles (7)n/a 120,000Police 01-ERP-0212Squad Car Camera Systems n/a 70,000Police 01-ERP-0220Squad Computers n/a 90,000Police 01-ERP-0228Administrative Vehicles n/a 35,000Police 01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry 01-ERP-03031 Ton Dump Truck (2)n/a 49,500Public Works: Streets/Traffic 01-ERP-0308Front End Loaders (2)n/a 268,600Public Works: Streets/Traffic Wednesday, August 3, 2022 Project Name Department Project #Priority Project Cost 01-ERP-0555Generator (2)n/a 43,000Sewer 967,154Total for 2024 2025 01-ERP-1109Art Center Floor Scrubber n/a 10,800Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 27,849Comm Svcs - IT 01-ERP-0005Financial Software - Various Depts.n/a 315,000Comm Svcs - IT 01-ERP-0006Computers n/a 38,686Comm Svcs - IT 01-ERP-0009Network Infrastructure Upgrade - Fiber n/a 70,000Comm Svcs - IT 01-ERP-0014Distribution Network Switches n/a 57,000Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 46,680Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 40,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 43,260Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 27,849Comm Svcs - IT 01-ERP-0052Electronic Inspections Processing 2 16,231Community Services 01-ERP-0108Self Contained Breathing Apparatus (SCBA) (45)n/a 300,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 18,600Fire 01-ERP-0125Fire Radios - Portable and Mobile Devices n/a 455,000Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 120,000Police 01-ERP-0201Sergeant's Vehicle n/a 65,000Police 01-ERP-03041 Ton Traffic Boom Truck n/a 136,400Public Works: Streets/Traffic 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 275,200Refuse 2,063,555Total for 2025 2026 01-ERP-0035Activity Center - Floor Scrubber n/a 6,700Comm Svcs - Activity Center 01-ERP-0003CH - Network Server n/a 28,684Comm Svcs - IT 01-ERP-0006Computers n/a 39,847Comm Svcs - IT 01-ERP-0015Backup Server n/a 78,808Comm Svcs - IT 01-ERP-0017IT - Office 365 n/a 48,080Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 40,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 44,558Comm Svcs - IT 01-ERP-0024IT - Sandbox Security Appliance n/a 45,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 28,684Comm Svcs - IT 01-ERP-0113Emergency Preparedness Sirens n/a 38,500Fire 01-ERP-1000Pavilion Ice Resurfacer n/a 165,000Pavilion 01-ERP-1001Pavilion - Electric Ice Edger n/a 8,900Pavilion 01-ERP-1002Pavilion Arena Scoreboard n/a 12,000Pavilion 01-ERP-0200Marked Patrol Vehicles (7)n/a 130,000Police 01-ERP-0202PSO / Parking Enforcement Vehicle n/a 65,000Police 01-ERP-0203PSO - Utility 4x4 n/a 86,100Police 01-ERP-0218Building Video Server n/a 25,000Police 01-ERP-0227Police Equipment n/a 25,000Police 01-ERP-07104X4 3/4 Ton Truck n/a 42,100Public Works: Bldg/Equip Serv 01-ERP-0808Riding Mowers (2)1 17,700Public Works: Parks/Forestry 01-ERP-0816Toolcat n/a 80,200Public Works: Parks/Forestry 01-ERP-0317Sign Machine (Traffic)n/a 18,100Public Works: Streets/Traffic 01-ERP-05513/4 Ton Utility Truck n/a 45,200Sewer 01-ERP-05013/4 Ton Utility Truck n/a 46,900Water 1,166,061Total for 2026 2027 01-ERP-0003CH - Network Server n/a 29,545Comm Svcs - IT 01-ERP-0006Computers n/a 41,042Comm Svcs - IT Wednesday, August 3, 2022 Project Name Department Project #Priority Project Cost 01-ERP-0017IT - Office 365 n/a 49,522Comm Svcs - IT 01-ERP-0020IT - Patching Automation Software 1 40,000Comm Svcs - IT 01-ERP-0022IT - Windows 10 Enterprise Upgrade n/a 45,895Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 29,545Comm Svcs - IT 01-ERP-0100Tele-Squirt (Engine 2)n/a 1,000,000Fire 01-ERP-0101Fire Pumper (Engine 3)n/a 900,000Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 20,000Fire 01-ERP-0114Floor Scrubber n/a 20,300Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 130,000Police 01-ERP-0217Taser Replacement n/a 90,041Police 01-ERP-0714PW - Truck Scan Kit 1 14,143Public Works: Bldg/Equip Serv 01-ERP-0807Trucksters (3)n/a 17,140Public Works: Parks/Forestry 01-ERP-03014X4 3/4 Ton Truck with Plow n/a 38,500Public Works: Streets/Traffic 01-ERP-0308Front End Loaders (2)n/a 268,000Public Works: Streets/Traffic 01-ERP-05003/4 Ton Truck n/a 36,000Water 01-ERP-0509Water Treatment Plant 1 134,392Water 2,904,065Total for 2027 GRAND TOTAL 8,932,580 Wednesday, August 3, 2022 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2023 2027thru Total20232024202520262027Department Comm Svcs - Activity Center 6,7006,700 Comm Svcs - Arts Center 24,30013,500 10,800 Comm Svcs - IT 1,941,173429,685 255,954 666,324 353,661 235,549 Community Services 16,23116,231 Fire 2,908,400156,000 773,600 38,500 1,940,300 Pavilion 197,50011,600 185,900 Police 1,999,301948,160 315,000 185,000 331,100 220,041 Public Works: Bldg/Equip Serv 56,24342,100 14,143 Public Works: Parks/Forestry 324,040199,000 10,000 97,900 17,140 Public Works: Streets/Traffic 843,00063,900 318,100 136,400 18,100 306,500 Refuse 275,200275,200 Sewer 88,20043,000 45,200 Water 252,29235,000 46,900 170,392 1,831,745 967,154 2,063,555 1,166,061 2,904,065 8,932,580TOTAL Wednesday, August 3, 2022 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2023 2027thru Total20232024202520262027DepartmentProject #Priority Comm Svcs - Activity Center 01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a 6,7006,700Comm Svcs - Activity Center Total Comm Svcs - Arts Center 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 24,30013,500 10,800Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0009 130,00060,000 70,000Network Infrastructure Upgrade - Fiber n/a 01-ERP-0024 45,00045,000IT - Sandbox Security Appliance n/a 01-ERP-0022 238,71342,000 63,000 43,260 44,558 45,895IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0020 189,00033,000 36,000 40,000 40,000 40,000IT - Patching Automation Software 1 01-ERP-0017 233,60244,000 45,320 46,680 48,080 49,522IT - Office 365 n/a 01-ERP-0015 150,92872,120 78,808Backup Server n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0211 139,36626,250 27,038 27,849 28,684 29,545PD - Network Server n/a 01-ERP-0006 193,59936,465 37,559 38,686 39,847 41,042Computersn/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0004 89,60089,600Telephone System n/a 01-ERP-0003 139,36526,250 27,037 27,849 28,684 29,545CH - Network Server n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 1,941,173429,685 255,954 666,324 353,661 235,549Comm Svcs - IT Total Community Services 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 16,23116,231Community Services Total Fire 01-ERP-0114 20,30020,300Floor Scrubber n/a 01-ERP-0131 100,000100,000Fire - Station Alerting System n/a 01-ERP-0100 1,000,0001,000,000Tele-Squirt (Engine 2)n/a 01-ERP-0125 455,000455,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a 01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a 01-ERP-0109 38,00038,000Extrication Tool (1)n/a 01-ERP-0108 300,000300,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0101 900,000900,000Fire Pumper (Engine 3)n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 2,908,400156,000 773,600 38,500 1,940,300Fire Total Wednesday, August 3, 2022 Total20232024202520262027DepartmentProject #Priority Pavilion 01-ERP-1000 165,000165,000Pavilion Ice Resurfacer n/a 01-ERP-1001 8,9008,900Pavilion - Electric Ice Edger n/a 01-ERP-1002 12,00012,000Pavilion Arena Scoreboard n/a 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 197,50011,600 185,900Pavilion Total Police 01-ERP-0201 65,00065,000Sergeant's Vehicle n/a 01-ERP-0202 65,00065,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0200 620,000120,000 120,000 120,000 130,000 130,000Marked Patrol Vehicles (7)n/a 01-ERP-0228 105,00070,000 35,000Administrative Vehicles n/a 01-ERP-0221 200,000200,000Records Management System n/a 01-ERP-0218 47,00022,000 25,000Building Video Server n/a 01-ERP-0217 230,041140,000 90,041Taser Replacement n/a 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0214 81,16081,160Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0212 70,00070,000Squad Car Camera Systems n/a 01-ERP-0203 86,10086,100PSO - Utility 4x4 n/a 01-ERP-0227 50,00025,000 25,000Police Equipment n/a 1,999,301948,160 315,000 185,000 331,100 220,041Police Total Public Works: Bldg/Equip Serv 01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a 01-ERP-0714 14,14314,143PW - Truck Scan Kit 1 56,24342,100 14,143Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry 01-ERP-0807 17,14017,140Trucksters (3)n/a 01-ERP-0808 17,70017,700Riding Mowers (2)1 01-ERP-0816 80,20080,200Toolcatn/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0814 10,00010,000Trailer Flatbed n/a 324,040199,000 10,000 97,900 17,140Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0308 536,600268,600 268,000Front End Loaders (2)n/a 01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0303 49,50049,5001 Ton Dump Truck (2)n/a 01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0322 35,00035,000Streets/Parks Supervisor Vehicle 1 843,00063,900 318,100 136,400 18,100 306,500Public Works: Streets/Traffic Total Refuse 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a 275,200275,200Refuse Total Wednesday, August 3, 2022 Total20232024202520262027DepartmentProject #Priority Sewer 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 88,20043,000 45,200Sewer Total Water 01-ERP-0510 35,00035,000Utilities Supervisor Vehicle n/a 01-ERP-0500 36,00036,0003/4 Ton Truck n/a 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 01-ERP-0509 134,392134,392Water Treatment Plant 1 252,29235,000 46,900 170,392Water Total GRAND TOTAL 8,932,5801,831,745 967,154 2,063,555 1,166,061 2,904,065 Wednesday, August 3, 2022 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2023 thru 2027 TotalSource20232024202520262027 AC - Arts Center Fund 24,30013,500 10,800 Equipment Replacement Fund 7,996,1881,701,345 895,554 1,777,555 888,061 2,733,673 PA - Pavilion Fund 197,50011,600 185,900 PKG - Parking Fund 3,5003,500 RF - Refuse Fund 357,00081,800 275,200 SF - Sanitary Sewer Fund 112,50024,300 43,000 45,200 WF - Water Fund 241,59224,300 46,900 170,392 1,831,745 967,154 2,063,555 1,166,061 2,904,065 8,932,580GRAND TOTAL Wednesday, August 3, 2022 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2023 2027thru TotalSourceProject #Priority 2023 2024 2025 2026 2027 AC - Arts Center Fund 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 01-ERP-1109 10,80010,800Art Center Floor Scrubber n/a 24,30013,500 10,800AC - Arts Center Fund Total Equipment Replacement Fund 01-ERP-0003 139,36526,250 27,037 27,849 28,684 29,545CH - Network Server n/a 01-ERP-0004 76,00076,000Telephone System n/a 01-ERP-0005 315,000315,000Financial Software - Various Depts.n/a 01-ERP-0006 193,59936,465 37,559 38,686 39,847 41,042Computersn/a 01-ERP-0009 130,00060,000 70,000Network Infrastructure Upgrade - Fiber n/a 01-ERP-0012 20,00020,000Core Network Switch n/a 01-ERP-0014 57,00057,000Distribution Network Switches n/a 01-ERP-0015 150,92872,120 78,808Backup Server n/a 01-ERP-0017 233,60244,000 45,320 46,680 48,080 49,522IT - Office 365 n/a 01-ERP-0020 189,00033,000 36,000 40,000 40,000 40,000IT - Patching Automation Software 1 01-ERP-0022 238,71342,000 63,000 43,260 44,558 45,895IT - Windows 10 Enterprise Upgrade n/a 01-ERP-0024 45,00045,000IT - Sandbox Security Appliance n/a 01-ERP-0035 6,7006,700Activity Center - Floor Scrubber n/a 01-ERP-0052 16,23116,231Electronic Inspections Processing 2 01-ERP-0100 1,000,0001,000,000Tele-Squirt (Engine 2)n/a 01-ERP-0101 900,000900,000Fire Pumper (Engine 3)n/a 01-ERP-0108 300,000300,000Self Contained Breathing Apparatus (SCBA) (45)n/a 01-ERP-0109 38,00038,000Extrication Tool (1)n/a 01-ERP-0112 38,60018,600 20,000Thermal Imaging Camera (2)n/a 01-ERP-0113 38,50038,500Emergency Preparedness Sirens n/a 01-ERP-0114 20,30020,300Floor Scrubber n/a 01-ERP-0125 455,000455,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0131 100,000100,000Fire - Station Alerting System n/a 01-ERP-0200 620,000120,000 120,000 120,000 130,000 130,000Marked Patrol Vehicles (7)n/a 01-ERP-0201 65,00065,000Sergeant's Vehicle n/a 01-ERP-0202 65,00065,000PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 86,10086,100PSO - Utility 4x4 n/a 01-ERP-0211 139,36626,250 27,038 27,849 28,684 29,545PD - Network Server n/a 01-ERP-0212 66,50066,500Squad Car Camera Systems n/a 01-ERP-0214 81,16081,160Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 230,041140,000 90,041Taser Replacement n/a 01-ERP-0218 47,00022,000 25,000Building Video Server n/a 01-ERP-0220 90,00090,000Squad Computers n/a 01-ERP-0221 200,000200,000Records Management System n/a 01-ERP-0227 50,00025,000 25,000Police Equipment n/a 01-ERP-0228 105,00070,000 35,000Administrative Vehicles n/a Wednesday, August 3, 2022 TotalSourceProject #Priority 2023 2024 2025 2026 2027 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0301 38,50038,5004X4 3/4 Ton Truck with Plow n/a 01-ERP-0303 49,50049,5001 Ton Dump Truck (2)n/a 01-ERP-0304 136,400136,4001 Ton Traffic Boom Truck n/a 01-ERP-0308 536,600268,600 268,000Front End Loaders (2)n/a 01-ERP-0317 18,10018,100Sign Machine (Traffic)n/a 01-ERP-0322 35,00035,000Streets/Parks Supervisor Vehicle 1 01-ERP-0710 42,10042,1004X4 3/4 Ton Truck n/a 01-ERP-0714 14,14314,143PW - Truck Scan Kit 1 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0807 17,14017,140Trucksters (3)n/a 01-ERP-0808 17,70017,700Riding Mowers (2)1 01-ERP-0814 10,00010,000Trailer Flatbed n/a 01-ERP-0816 80,20080,200Toolcatn/a 7,996,1881,701,345 895,554 1,777,555 888,061 2,733,673Equipment Replacement Fund Total PA - Pavilion Fund 01-ERP-1000 165,000165,000Pavilion Ice Resurfacer n/a 01-ERP-1001 8,9008,900Pavilion - Electric Ice Edger n/a 01-ERP-1002 12,00012,000Pavilion Arena Scoreboard n/a 01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a 197,50011,600 185,900PA - Pavilion Fund Total PKG - Parking Fund 01-ERP-0212 3,5003,500Squad Car Camera Systems n/a 3,5003,500PKG - Parking Fund Total RF - Refuse Fund 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0900 275,200275,200Refuse Truck (RAP-R) (2)n/a 357,00081,800 275,200RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0510 17,50017,500Utilities Supervisor Vehicle n/a 01-ERP-0551 45,20045,2003/4 Ton Utility Truck n/a 01-ERP-0555 43,00043,000Generator (2)n/a 112,50024,300 43,000 45,200SF - Sanitary Sewer Fund Total WF - Water Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0500 36,00036,0003/4 Ton Truck n/a 01-ERP-0501 46,90046,9003/4 Ton Utility Truck n/a 01-ERP-0509 134,392134,392Water Treatment Plant 1 01-ERP-0510 17,50017,500Utilities Supervisor Vehicle n/a Wednesday, August 3, 2022 TotalSourceProject #Priority 2023 2024 2025 2026 2027 241,59224,300 46,900 170,392WF - Water Fund Total 8,932,5801,831,745 967,154 2,063,555 1,166,061 2,904,065GRAND TOTAL Wednesday, August 3, 2022