2018-2022 Equipment Replacement Plan; BishopCity of Hopkins
MEMORANDUM
Date: July 14th, 2017
To: Mayor & City Council
From: Nick Bishop, Finance Director
Subject: 2018-2022 Equipment Replacement Plan
Attached is a preliminary version of the 2018-2022 Equipment Replacement Plan (ERP). Total
Costs projected for the five year period are approximately $4.44 million. Costs in 2018 are
estimated to be approximately $1.18 million. Additional details are incorporated in the attached
documents and will be presented at the work session. This is an initial update for the 2018-
2022 ERP and any changes from the work session discussion will be incorporated in later
versions.
The following items are included for your review:
1. Summary of Projects by Department
2. Detailed Projects by Department and Year
3. Cash Flow Statement
Information on the individual projects, including description, justification and funding sources are
available on request.
FINANCE DEPARTMENT
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
DEPARTMENT SUMMARY
2018 2022thru
Total20182019202020212022Department
Comm Svcs - Activity Center 15,00015,000
Comm Svcs - Arts Center 82,80064,100 18,700
Comm Svcs - IT 579,40097,000 90,000 202,000 82,000 108,400
Community Services 11,30011,300
Fire 426,11754,217 27,400 344,500
HRA 16,50016,500
Police 1,587,700456,000 238,000 287,400 224,800 381,500
Public Works: Bldg/Equip Serv 61,00061,000
Public Works: Parks/Forestry 404,80063,300 177,900 163,600
Public Works: Streets/Traffic 848,000289,600 230,000 225,000 103,400
Refuse 365,30095,000 270,300
Sewer 43,00043,000
1,180,217 600,400 678,600 802,100 1,179,600 4,440,917TOTAL
Friday, July 14, 2017
EQUIPMENT REPLACEMENT PLAN
City of Hopkins, MN - ERP
PROJECTS BY DEPARTMENT
2018 2022thru
Total20182019202020212022DepartmentProject #Priority
Comm Svcs - Activity Center
01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3
15,00015,000Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
01-ERP-1101 5,2005,200Art Center Carpet Extractor n/a
01-ERP-1104 17,10017,100Art Center Theater Projector n/a
01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a
01-ERP-1112 47,00047,000Art Center Surveillance System 1
82,80064,100 18,700Comm Svcs - Arts Center Total
Comm Svcs - IT
01-ERP-0003 118,00022,000 23,000 23,000 25,000 25,000CH - Network Server n/a
01-ERP-0006 170,00030,000 35,000 35,000 35,000 35,000Computersn/a
01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a
01-ERP-0012 17,00017,000Core Network Switch n/a
01-ERP-0013 12,0006,000 6,000Wi-Fi and Cellular n/a
01-ERP-0014 50,00050,000Distribution Network Switches n/a
01-ERP-0015 66,00066,000Backup Server n/a
01-ERP-0016 10,00010,000Fortimail Hardware Appliance n/a
01-ERP-0211 113,00022,000 22,000 22,000 22,000 25,000PD - Network Server n/a
579,40097,000 90,000 202,000 82,000 108,400Comm Svcs - IT Total
Community Services
01-ERP-0008 11,30011,300Document Management Scanner (2)n/a
11,30011,300Community Services Total
Fire
01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a
01-ERP-0106 54,21754,217Aerial Truck n/a
01-ERP-0109 57,40027,400 30,000Extrication Tool (2)n/a
426,11754,217 27,400 344,500Fire Total
HRA
01-ERP-0401 16,50016,500HRA Copier n/a
16,50016,500HRA Total
Police
01-ERP-0200 620,900147,000 98,000 107,400 161,100 107,400Marked Patrol Vehicles (7)n/a
01-ERP-0201 49,00049,000Sergeant's Vehicle n/a
01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a
Friday, July 14, 2017
Total20182019202020212022DepartmentProject #Priority
01-ERP-0203 127,10055,000 72,100PSO - Utility 4x4 n/a
01-ERP-0212 65,00065,000Squad Car Camera Systems n/a
01-ERP-0214 55,00055,000Tactical Ballistic Vests / Helmets - SWAT 3
01-ERP-0217 67,00035,000 32,000Taser Replacement n/a
01-ERP-0218 20,00020,000Building Video Server n/a
01-ERP-0219 155,000115,000 10,000 10,000 10,000 10,000PD - Video Data Server n/a
01-ERP-0220 65,00065,000Mobile Data Computers n/a
01-ERP-0221 150,000150,000Records Management System n/a
01-ERP-0222 160,000160,000Body Worn Cameras n/a
1,587,700456,000 238,000 287,400 224,800 381,500Police Total
Public Works: Bldg/Equip Serv
01-ERP-0710 36,00036,0004X4 3/4 Ton Truck n/a
01-ERP-0715 25,00025,000PW - Forklift 2
61,00061,000Public Works: Bldg/Equip Serv Total
Public Works: Parks/Forestry
01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a
01-ERP-0804 163,600163,600Log Truck n/a
01-ERP-0810 92,70092,700Large Turf Mower n/a
01-ERP-0816 63,30063,300Toolcatn/a
404,80063,300 177,900 163,600Public Works: Parks/Forestry Total
Public Works: Streets/Traffic
01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a
01-ERP-0303 53,40053,4001 Ton Dump Truck (2)n/a
01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a
01-ERP-0306 235,000235,000Tandem Dump Truck (2)n/a
01-ERP-0309 50,00050,000Skid Loader (2)n/a
01-ERP-0311 230,000230,000Sweepern/a
848,000289,600 230,000 225,000 103,400Public Works: Streets/Traffic Total
Refuse
01-ERP-0803 95,00095,000Swap Loader n/a
01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a
365,30095,000 270,300Refuse Total
Sewer
01-ERP-0555 43,00043,000Generator (2)n/a
43,00043,000Sewer Total
GRAND TOTAL 4,440,9171,180,217 600,400 678,600 802,100 1,179,600
Friday, July 14, 2017
City of HopkinsEquipment Replacement Fund (602)Rate Change9% 9% 10% 9% 9% 9% 6%ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET2016 2017 2018 2019 2020 2021 2022Working Capital Begin Year (373,504) 1,172,861 271,121 44,156 (254,630) (596,009) (540,429) Revenues from charges 408,459 445,220 489,742 533,819 581,863 634,231 672,284 Tax Levy per FMPTransfer in Debt Service Fund 1,896,571 - - - - - - Interest earnings 6,294 3,000 3,000 3,000 3,000 3,000 3,000 Other revenues (sale of assets) 60,424 30,000 30,000 35,000 35,000 35,000 35,000 Enterpirse contribution to software upgrade 57,508 - - - - - - Equipment Certificates (Bonds) - - 590,000 - - - - Interfund Loan - 610,000 - - - - - Total Revenues 2,429,256 1,088,220 1,112,742 571,819 619,863 672,231 710,284 Expenditures (excludes Leases & Depr.) 268,755 76,544 78,840 81,206 83,642 86,151 88,735 Fire Truck Financing Pymnts (2009-2018) 53,782 54,217 54,217 - - - - Capital Outlay - Equipment 560,354 1,859,200 1,006,650 584,400 672,600 530,500 1,014,600 Repayment of Interfund Loan - - 200,000 205,000 205,000 - - Total Expenses 882,891 1,989,961 1,339,707 870,606 961,242 616,651 1,103,335 Working Capital Ending Balance 1,172,861 271,121 44,156 (254,630) (596,009) (540,429) (933,480) (Unrestricted Net Position)