VII.1. 2020-2024 Equipment Replacement Plan (ERP); Bishop
October 15, 2019 Council Report 2019-106
2020-2024 EQUIPMENT REPLACEMENT PLAN (ERP)
Proposed Action
Staff recommends adoption of the following motion: Move to adopt the 2020-2024 Equipment Replacement
Plan.
Overview
The equipment replacement plan is a detailed summary of the next five years of a twenty-year replacement
schedule, for equipment of the City of Hopkins. 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 2020-2024 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 2020. Years 2021-
2024 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
Supporting Information
• 2020-2024 Equipment Replacement Plan
______________________________________
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: ____________________
City of Hopkins
Equipment Replacement Fund (602)
Rate Change 10%9%9%9%6%6%
ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET
2018 2019 2020 2021 2022 2023
Working Capital Begin Year (24,461) (114,895) (9,347) 19,438 (127,523) (21,148)
Revenues from charges 487,900 531,811 579,674 631,845 669,755 709,941
Tax Levy 230,000 240,000 250,000 250,000 250,000
Transfer in Debt Service Fund - - - - -
Interest earnings - - - 97 (638) (106)
Other revenues (sale of assets)(36,670) 35,000 35,000 35,000 35,000 35,000
Enterpirse contribution to software upgrade - - - - -
Equipment Certificates (Bonds)592,000 - - - - 1,600,000
Interfund Loan - - - - -
Total Revenues 1,043,230 796,811 854,674 916,942 954,118 2,594,835
Expenditures (excludes Leases & Depr.) 259,742 33,873 34,889 35,936 37,014 38,124
Fire Truck Financing Pymnts (2009-2018)52,295 - - - -
Capital Outlay - Equipment 821,627 657,390 791,000 1,027,967 810,729 2,390,697
Repayment of Interfund Loan -
Total Expenses 1,133,664 691,263 825,889 1,063,903 847,743 2,428,821
Working Capital Ending Balance (114,895) (9,347) 19,438 (127,523) (21,148) 144,865
(Unrestricted Net Position)
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
DEPARTMENT SUMMARY
2020 2024thru
Total20202021202220232024Department
Comm Svcs - Activity Center 111,62482,624 17,000 12,000
Comm Svcs - Arts Center 20,20013,500 6,700
Comm Svcs - IT 1,473,811244,500 448,543 204,129 346,685 229,954
Fire 1,083,40029,000 30,000 1,012,400 12,000
HRA 57,60016,500 41,100
Pavilion 11,60011,600
Police 1,614,612117,400 271,800 332,100 580,912 312,400
Public Works: Bldg/Equip Serv 35,00035,000
Public Works: Engineering 28,90028,900
Public Works: Parks/Forestry 429,400195,100 188,900 35,400 10,000
Public Works: Streets/Traffic 1,042,400170,000 225,000 103,400 433,900 110,100
Refuse 270,300270,300
Sewer 83,30043,000 40,300
791,000 1,298,267 948,529 2,462,397 761,954 6,262,147TOTAL
Wednesday, October 9, 2019
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY DEPARTMENT
2020 2024thru
Total20202021202220232024DepartmentProject #Priority
Comm Svcs - Activity Center
01-ERP-0037 20,00020,000Activity Center Security System Upgrade 1
01-ERP-0038 29,00017,000 12,000Activity Center Kitchen Storage 5
01-ERP-0041 62,62462,624Activity Center A/V Replacement & Upgrade 3
111,62482,624 17,000 12,000Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2
20,20013,500 6,700Comm Svcs - Arts Center Total
Comm Svcs - IT
01-ERP-0003 122,28722,000 22,000 25,000 26,250 27,037CH - Network Server n/a
01-ERP-0004 89,60089,600Telephone System n/a
01-ERP-0005 307,468307,468Financial Software - Various Depts.n/a
01-ERP-0006 173,32831,500 33,075 34,729 36,465 37,559Computersn/a
01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a
01-ERP-0012 20,00020,000Core Network Switch n/a
01-ERP-0014 50,00050,000Distribution Network Switches n/a
01-ERP-0015 138,12066,000 72,120Backup Server n/a
01-ERP-0017 188,32022,000 33,000 44,000 44,000 45,320IT - Office 365 n/a
01-ERP-0020 50,00010,000 10,000 10,000 10,000 10,000IT - Patching Automation Software 1
01-ERP-0022 189,00021,000 21,000 42,000 42,000 63,000IT - Windows 10 Enterprise Upgrade n/a
01-ERP-0211 122,28822,000 22,000 25,000 26,250 27,038PD - Network Server n/a
1,473,811244,500 448,543 204,129 346,685 229,954Comm Svcs - IT Total
Fire
01-ERP-0105 525,000525,000Quick Attack Pumper/Rescue (Rescue 8)n/a
01-ERP-0109 91,00029,000 30,000 32,000Extrication Tool (2)n/a
01-ERP-0112 15,40015,400Thermal Imaging Camera (2)n/a
01-ERP-0125 368,000368,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-0128 38,00038,000Fire - Hose Replacement 2
01-ERP-0129 12,00012,000Fire - EOC Upgrade n/a
1,083,40029,000 30,000 1,012,400 12,000Fire 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
Wednesday, October 9, 2019
Total20202021202220232024DepartmentProject #Priority
Pavilion
01-ERP-1003 11,60011,600Pavilion - Floor Scrubber n/a
11,60011,600Pavilion Total
Police
01-ERP-0200 613,300107,400 161,100 110,000 117,400 117,400Marked Patrol Vehicles (7)n/a
01-ERP-0201 57,00057,000Sergeant's Vehicle n/a
01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 72,10072,100PSO - Utility 4x4 n/a
01-ERP-0212 105,000105,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 80,00080,000Taser Replacement n/a
01-ERP-0218 17,00017,000Building Video Server n/a
01-ERP-0219 10,00010,000PD - Video Data Server n/a
01-ERP-0220 90,00090,000Squad Computers n/a
01-ERP-0221 150,000150,000Records Management System n/a
1,614,612117,400 271,800 332,100 580,912 312,400Police Total
Public Works: Bldg/Equip Serv
01-ERP-0712 35,00035,000PW - 4x4 3/4 Ton Truck with Service Body n/a
35,00035,000Public Works: Bldg/Equip Serv Total
Public Works: Engineering
01-ERP-0700 28,90028,900Engineering Van n/a
28,90028,900Public Works: Engineering Total
Public Works: Parks/Forestry
01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a
01-ERP-0804 163,600163,600Log Truck n/a
01-ERP-0808 39,20013,900 25,300Riding Mowers (2)n/a
01-ERP-0810 96,00096,000Large Turf Mower n/a
01-ERP-0814 10,00010,000Trailer Flatbed n/a
429,400195,100 188,900 35,400 10,000Public Works: Parks/Forestry Total
Public Works: Streets/Traffic
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 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-0318 22,10022,100Asphalt Hot Mix Heating Box - Trailer n/a
01-ERP-0321 170,000170,000Wheel Loader 1
1,042,400170,000 225,000 103,400 433,900 110,100Public Works: Streets/Traffic Total
Refuse
01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a
Wednesday, October 9, 2019
Total20202021202220232024DepartmentProject #Priority
270,300270,300Refuse Total
Sewer
01-ERP-0550 40,30040,3004x4 3/4 Ton Truck n/a
01-ERP-0555 43,00043,000Generator (2)n/a
83,30043,000 40,300Sewer Total
GRAND TOTAL 6,262,147791,000 1,298,267 948,529 2,462,397 761,954
Wednesday, October 9, 2019
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
FUNDING SOURCE SUMMARY
2020 thru 2024
TotalSource20202021202220232024
AC - Arts Center Fund 20,20013,500 6,700
Equipment Replacement Fund 5,718,747791,000 1,027,967 810,729 2,390,697 698,354
HRA - Housing and Redevelopment Authority 57,60016,500 41,100
PA - Pavilion Fund 11,60011,600
PKG - Parking Fund 5,0005,000
RF - Refuse Fund 352,100270,300 81,800
SF - Sanitary Sewer Fund 90,10043,000 6,800 40,300
WF - Water Fund 6,8006,800
791,000 1,298,267 965,529 2,445,397 761,954 6,262,147GRAND TOTAL
Wednesday, October 9, 2019
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY FUNDING SOURCE
2020 2024thru
TotalSourceProject #Priority 2020 2021 2022 2023 2024
AC - Arts Center Fund
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1107 6,7006,700Art Center Theater Projection Screen 2
20,20013,500 6,700AC - Arts Center Fund Total
Equipment Replacement Fund
01-ERP-0003 122,28722,000 22,000 25,000 26,250 27,037CH - Network Server n/a
01-ERP-0004 76,00076,000Telephone System n/a
01-ERP-0005 307,468307,468Financial Software - Various Depts.n/a
01-ERP-0006 173,32831,500 33,075 34,729 36,465 37,559Computersn/a
01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a
01-ERP-0012 20,00020,000Core Network Switch n/a
01-ERP-0014 50,00050,000Distribution Network Switches n/a
01-ERP-0015 138,12066,000 72,120Backup Server n/a
01-ERP-0017 188,32022,000 33,000 44,000 44,000 45,320IT - Office 365 n/a
01-ERP-0020 50,00010,000 10,000 10,000 10,000 10,000IT - Patching Automation Software 1
01-ERP-0022 189,00021,000 21,000 42,000 42,000 63,000IT - Windows 10 Enterprise Upgrade n/a
01-ERP-0037 20,00020,000Activity Center Security System Upgrade 1
01-ERP-0038 29,00017,000 12,000Activity Center Kitchen Storage 5
01-ERP-0041 62,62462,624Activity Center A/V Replacement & Upgrade 3
01-ERP-0105 525,000525,000Quick Attack Pumper/Rescue (Rescue 8)n/a
01-ERP-0109 91,00029,000 30,000 32,000Extrication Tool (2)n/a
01-ERP-0112 15,40015,400Thermal Imaging Camera (2)n/a
01-ERP-0125 368,000368,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-0128 38,00038,000Fire - Hose Replacement 2
01-ERP-0129 12,00012,000Fire - EOC Upgrade n/a
01-ERP-0200 613,300107,400 161,100 110,000 117,400 117,400Marked Patrol Vehicles (7)n/a
01-ERP-0201 57,00057,000Sergeant's Vehicle n/a
01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a
01-ERP-0203 72,10072,100PSO - Utility 4x4 n/a
01-ERP-0211 122,28822,000 22,000 25,000 26,250 27,038PD - Network Server n/a
01-ERP-0212 100,000100,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 80,00080,000Taser Replacement n/a
01-ERP-0218 17,00017,000Building Video Server n/a
01-ERP-0219 10,00010,000PD - Video Data Server n/a
01-ERP-0220 90,00090,000Squad Computers n/a
01-ERP-0221 150,000150,000Records Management System n/a
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 102,90053,400 49,5001 Ton Dump Truck (2)n/a
Wednesday, October 9, 2019
TotalSourceProject #Priority 2020 2021 2022 2023 2024
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-0318 22,10022,100Asphalt Hot Mix Heating Box - Trailer n/a
01-ERP-0321 170,000170,000Wheel Loader 1
01-ERP-0700 28,90028,900Engineering Van n/a
01-ERP-0712 35,00035,000PW - 4x4 3/4 Ton Truck with Service Body n/a
01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a
01-ERP-0804 81,80081,800Log Truck n/a
01-ERP-0808 39,20013,900 25,300Riding Mowers (2)n/a
01-ERP-0810 96,00096,000Large Turf Mower n/a
01-ERP-0814 10,00010,000Trailer Flatbed n/a
5,718,747791,000 1,027,967 810,729 2,390,697 698,354Equipment 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-1003 11,60011,600Pavilion - Floor Scrubber n/a
11,60011,600PA - Pavilion Fund Total
PKG - Parking Fund
01-ERP-0212 5,0005,000Squad Car Camera Systems/ Body Worn Camera n/a
5,0005,000PKG - Parking Fund Total
RF - Refuse Fund
01-ERP-0804 81,80081,800Log Truck n/a
01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a
352,100270,300 81,800RF - Refuse Fund Total
SF - Sanitary Sewer Fund
01-ERP-0004 6,8006,800Telephone System n/a
01-ERP-0550 40,30040,3004x4 3/4 Ton Truck n/a
01-ERP-0555 43,00043,000Generator (2)n/a
90,10043,000 6,800 40,300SF - Sanitary Sewer Fund Total
WF - Water Fund
01-ERP-0004 6,8006,800Telephone System n/a
6,8006,800WF - Water Fund Total
Wednesday, October 9, 2019
TotalSourceProject #Priority 2020 2021 2022 2023 2024
6,262,147791,000 1,298,267 965,529 2,445,397 761,954GRAND TOTAL
Wednesday, October 9, 2019