Loading...
2017 - 2021 ERP EQUIPMENT REPLACEMENT PLAN 2017-2021 DATE: November 2016 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2017-2021 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2017-2021 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 citizens 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 20 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 citizens 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 Steve Stadler, Public Works Director, Mike Reynolds, Police Chief, Brent Johnson, Police Captain, Dale Specken, Fire Chief, and Christine Harkess, Finance Director for their hard work and dedication. 1 Page City Manager's Message 1 Table of Contents 2 Introduction Background and Summary of Changes from 2015 Plan 5 Cash Flow Statements Equipment Replacement Fund 11 Five-Year Project Summaries Projects by Year 15 Department Summary 17 Projects by Department 18 Funding Source Summary 20 Projects by Funding Source 21 Equipment Requests Individual Equipment Request Details Activity Center 25 Arts Center 26 Community Services - IT 27 Community Services 34 Fire 35 Police 39 Public Works 51 Refuse 69 Sewer 72 Water 75 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 79 Equipment and Building Inventory Building Inventory 85 Vehicle and Equipment Inventory 87 EQUIPMENT REPLACEMENT PLAN 2017-2021 TABLE OF CONTENTS 2           INTRODUCTION  3 4 EQUIPMENT REPLACEMENT PLAN 2017-2021 BACKGROUND AND SUMMARY OF CHANGES FROM 2016 PLAN Background The Equipment Replacement Plan is a twenty-year forecast and a five-year plan of equipment needs in the City of Hopkins. It is intended to inform the Council and citizens of the major equipment needs on the horizon. The first year of the plan becomes an adopted equipment budget and relates to the operating budget of the equipment replacement fund, which is approved on an annual basis. The remaining nineteen years represent an estimate of equipment needs and funding capabilities of the City. Funding requirements vary from year to year. In order to maintain a fairly consistent levy each year, the twenty-year schedule is projected with a 3% inflation factor for operating expenses. The cash flow requirements to fund equipment needs in the equipment replacement fund will experience a roller coaster effect over the next 20 years given the projected equipment needs and 3% inflation rate. The intragovernmental charges were increased in 2016 by 9% and will again be increased in 2017 by 9%. Plans are to increase the rate going forward with increases of 9% over the next 5 years. The majority of items purchased with ERP funds are used by departments within the General Fund which accounts for the most of the operations of the city. There have been many changes in technology and the way we operate and as a result there is more equipment in the plan; however the rate has not increased to accommodate the increase in equipment. Equipment that was purchased with grants such as digital squad cameras, laptop computers in squad cars and fire vehicles, AED’s, and infrared cameras are included in the ERP but the rates have not kept up with the addition of all these items. In addition society is dictating some of the equipment under consideration. One of the items under discussion was police body cameras. They were originally put in the ERP and later removed until it can be determined how the data the cameras capture will be disseminated upon a public data request. The long term viability of the fund remains questionable and will result in difficult decisions regarding equipment and operations. These issues were addressed as part of the Financial Management Plan (FMP) completed in 2014. The FMP establishes funding mechanisms to get the fund to a constant balance of $750,000. Items that will be considered and/or implemented are rate increases, a tax levy and issuing equipment certificates. As discussed above are scheduling a 9% rate increase for 2017-2021 and plan to sell Equipment Certificates in 2018 to fund some of the equipment scheduled for 2018-2019. This will allow us to replace aging equipment and spread the payments over 10 years. The required Equipment Certificate payment will be part of the debt levy in the applicable year. Each year staff re-evaluates the equipment needs and adjusts the schedule accordingly. Changes to the plan are reflected in the document. Refurbishments, extended life expectancy and closer cost estimates of replacements have been incorporated into the plan. The equipment replacement charges in the general fund represent approximately 3% of total general fund expenditures. The Equipment Replacement Plan’s basic premise is scheduled replacement of present equipment. A new item must, in the year proposed, be presented in the annual operating budget 5 with a stipulation that replacement will be necessary in the future. Flexibility of the Equipment Replacement Plan is established through annual review and revision, if necessary. Summary of Changes from 2016 Plan Highlights of changes from last year’s equipment replacement plan for the years 2017-2021: CS - Activity Center: Sound system replacement was added in 2019 at a cost of $15,000. CS - Arts Center: Two items totaling $9,400 were removed from the ERP and put in the operational budget. CS - IT: Network servers for city hall and the police department originally budgeted at $15,000 per year each were increased to $22,000 as technology demands increase. A backup server for city computers essential to keeping electronic data safe for the city was added in 2017 and 2020 at a cost of $66,000 for each year. Community Services: No changes Fire: Leased vehicle cost of $32,707 per year was moved to the General Fund Fire Dept operations budget along with the cost to outfit those vehicles. Workout equipment totaling $24,200 over 4 years was removed from the ERP and into the operations budget for the respective years. Automated external defibrillators (2) totaling $7,800 in 2018 were removed from the ERP and will be put in the operations budget for 2018. A washer & dryer for the turnout gear totaling $13,000 in 2018 was removed from the ERP and will be put into the operations budget for 2018. The Tele-squirt fire truck scheduled for replacement in 2017 at a cost of $650,000 has been increased to $900,000 to reflect the actual cost of replacement. HRA No changes. Pavilion: No changes Parking: No changes. 6 Police: Leased vehicles for the chief, captain and DTF were removed from the ERP along with the cost to outfit those vehicles and moved to the Police operations budget. Total cost eliminated was $297,370 over the next five years. The cost of the marked squad cars has been evaluated and the cost updated to reflect the prices on the state contracts. Cost for the vehicles has increased up to $49,000 from 2017-2020 over the same period in the prior year’s ERP. The sergeant’s vehicle originally scheduled for 2019 was moved up to 2018 and the cost reduced by $1,600. The PSO vehicle originally scheduled for 2020 was moved up to 2018 and the cost reduced by $5,400. Tactical ballistic vests for the SWAT Team scheduled for 2018 also now incorporates helmets and the cost was increased by $8,100. PD squad video server scheduled for 2019 at a cost of $15,000 has been removed and replaced with a PD video data server in 2018 to 2020. Cost in 2018 will be $115,000 and $10,000 per year thereafter. Mobile data computers were added in 2019 at a cost of $65,000. The records management system originally in as Data 911 in 2020 for $50,000 has been renamed to appropriately describe the equipment needed and the cost increased to $150,000. Public Works: Engineering No changes Building/Equipment Services A high pressure vehicle washer scheduled for 2020 at a cost of $8,300 has been removed and is part of the PW garage upgrade project. Parks/Forestry Trucksters originally scheduled for 2019 were moved to 2017 with no change in cost. The cost of the stump cutter originally scheduled for 2017 has increased from $21,200 to $45,000 to reflect replacement cost. The cost of the trailer flatbed scheduled for 2020 has increased in cost from $2,200 to $10,000 to reflect replacement cost. 7 Streets/Traffic Tandem dump trucks scheduled for replacement in 2017 and 2018 have increased in cost from $173,200 and $180,000 to $225,000 and $235,000 a total impact of $106,800 over the two years. Cost increased to better reflect replacement cost. The asphalt paver originally in for 2018 at a cost of $48,800 has been moved to 2017 at a cost of $118,000. A snow blower has been added for 2017 at a cost of $160,000. This item was originally scheduled for 2014, did not get purchased and did not get put back in the ERP. An asphalt hot mix heating box and trailer has been added in 2017 at a cost of $15,000. Current box sits on the back of a truck is too small and sits too high to be handled easily. Plans are to move to a hot box on a trailer to provide greater efficiency and safety to employees. Refuse No changes Sewer A generator originally scheduled for 2017 at a cost of $26,400 has increased in cost to $36,000. A Jet Vactor has been moved from 2020 to 2017 and the cost increased by $110,000 to reflect replacement cost. SCADA upgrade has been added in 2017 at a cost to the sewer fund of $160,000. Our current SCADA system is outdated and an upgrade is needed for the system to continue to work with the PLC software and radio parts. Water ¾ ton Utility truck originally scheduled for 2016 was moved back to 2017. Current vehicle is a 2006 Chev Pick-up. Water treatment plant equipment used to convert chlorine gas to liquid sodium hypochlorite has been added at cost of $100,000. Chlorine gas is extremely dangerous and corrosive. Liquid bleach is easy to contain and work with. 8           CASH FLOW STATEMENTS  9 10 EQUIPMENT REPLACEMENT FUND (602)11/11/2016 Rate Change 9%9%9%10%9%9%9% BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 2015 2016 2017 2018 2019 2020 2021 Working Capital Begin Year 538,514 (373,504) 1,046,877 145,136 167,361 169,647 452,727 Revenues from charges 376,884 408,459 445,220 489,742 533,819 581,863 634,231 Tax Levy per FMP 400,865 472,848 532,834 605,750 Transfer in General Fund Federal & State Grants 237,120 Interest earnings 5,982 3,000 3,000 3,000 3,000 3,000 3,000 Other revenues (sale of assets)27,535 30,000 30,000 30,000 35,000 35,000 35,000 Enterpirse contribution to software upgrade 57,058 Equipment Certificates (Bonds)1,896,570 590,000 Transfers In (Misc) Interfund Loan 610,000 Total Revenues 647,521 2,395,087 1,088,220 1,513,607 1,044,667 1,152,697 1,277,981 Expenditures (excludes Leases & Depr.) 72,150 74,315 76,544 78,841 81,206 83,642 86,151 Fire Truck Financing Pymnts (2009-2018)53,803 54,217 54,217 54,217 Capital Outlay - Equipment 1,433,586 846,174 1,859,200 934,950 527,800 662,600 430,900 Transfer Out Repayment of Interfund Loan 300,000 310,000 Total Expenses 1,559,539 974,705 1,989,961 1,491,382 1,042,381 869,617 640,426 Working Capital Ending Balance (373,504) 1,046,877 145,136 167,361 169,647 452,727 1,090,281 (cash + receivables - payables) 11 12           FIVE‐YEAR   PROJECT SUMMARIES  13 14 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN PROJECTS BY YEAR 2017 2021thru Project Name Department Project # Priority Project Cost 2017 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0015Backup Server n/a 66,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0100Tele-Squirt (Engine 2)n/a 900,000Fire 01-ERP-0106Aerial Truck n/a 54,217Fire 01-ERP-0112Thermal Imaging Camera (2)n/a 12,900Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 98,000Police 01-ERP-0223Squad Car Wireless Solution n/a 12,000Police 01-ERP-0714PW - Truck Scan Kit 1 10,000Public Works: Bldg/Equip Serv 01-ERP-0807Trucksters (3)n/a 34,200Public Works: Parks/Forestry 01-ERP-0812Stump Cutter n/a 45,000Public Works: Parks/Forestry 01-ERP-0815Skid Loader n/a 32,000Public Works: Parks/Forestry 01-ERP-0306Tandem Dump Truck (2)n/a 225,000Public Works: Streets/Traffic 01-ERP-0312PW - Roller n/a 45,900Public Works: Streets/Traffic 01-ERP-0313Striper n/a 11,200Public Works: Streets/Traffic 01-ERP-0314PW - Asphalt Paver n/a 118,000Public Works: Streets/Traffic 01-ERP-0315Snow Blower n/a 160,000Public Works: Streets/Traffic 01-ERP-0318Asphalt Hot Mix Heating Box - Trailer n/a 15,000Public Works: Streets/Traffic 01-ERP-0901Refuse Truck (Rear-L)n/a 101,600Refuse 01-ERP-0552Jet Vactor n/a 425,000Sewer 01-ERP-0555Generator (2)n/a 36,000Sewer 01-ERP-0559SCADA Upgrade 1 160,000Sewer 01-ERP-05003/4 Ton Truck n/a 32,000Water 01-ERP-0509Water Treatment Plant 1 100,000Water 2,768,017Total for 2017 2018 01-ERP-1104Art Center Theater Projector n/a 17,100Comm Svcs - Arts Center 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0012Core Network Switch n/a 17,000Comm Svcs - IT 01-ERP-0013Wi-Fi and Cellular n/a 6,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0106Aerial Truck n/a 54,217Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 147,000Police 01-ERP-0201Sergeant's Vehicle n/a 49,000Police 01-ERP-0203PSO - Utility 4x4 n/a 55,000Police 01-ERP-0214Tactical Ballistic Vests / Helmets - SWAT n/a 35,000Police 01-ERP-0217Taser Replacement n/a 29,000Police 01-ERP-0219PD - Video Data Server n/a 115,000Police 01-ERP-07104X4 1/2 Ton Truck n/a 31,300Public Works: Bldg/Equip Serv 01-ERP-0816Toolcat n/a 63,300Public Works: Parks/Forestry 01-ERP-03024x2 1 Ton Dump Truck n/a 54,600Public Works: Streets/Traffic Friday, November 11, 2016 15 Project Name Department Project # Priority Project Cost 01-ERP-0306Tandem Dump Truck (2)n/a 235,000Public Works: Streets/Traffic 01-ERP-0803Swap Loader n/a 95,000Refuse 1,077,517Total for 2018 2019 01-ERP-0036Activity Center Sound System Replacement 3 15,000Comm Svcs - Activity Center 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0109Extrication Tool (2)n/a 27,400Fire 01-ERP-0200Marked Patrol Vehicles (7)n/a 98,000Police 01-ERP-0212Squad Car Camera Systems n/a 65,000Police 01-ERP-0218Building Video Server n/a 17,000Police 01-ERP-0219PD - Video Data Server n/a 10,000Police 01-ERP-0220Mobile Data Computers n/a 65,000Police 01-ERP-0311Sweeper n/a 156,400Public Works: Streets/Traffic 527,800Total for 2019 2020 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0013Wi-Fi and Cellular n/a 6,000Comm Svcs - IT 01-ERP-0014Distribution Network Switches n/a 50,000Comm Svcs - IT 01-ERP-0015Backup Server n/a 66,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0008Document Management Scanner (2)n/a 11,300Community Services 01-ERP-0200Marked Patrol Vehicles (7)n/a 107,400Police 01-ERP-0219PD - Video Data Server n/a 10,000Police 01-ERP-0221Records Management System n/a 150,000Police 01-ERP-08014x4 3/4Ton Trucks (2)n/a 85,200Public Works: Parks/Forestry 01-ERP-0810Large Turf Mower n/a 92,700Public Works: Parks/Forestry 01-ERP-0814Trailer Flatbed n/a 10,000Public Works: Parks/Forestry 662,600Total for 2020 2021 01-ERP-0003CH - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0006Computers n/a 30,000Comm Svcs - IT 01-ERP-0211PD - Network Server n/a 22,000Comm Svcs - IT 01-ERP-0200Marked Patrol Vehicles (7)n/a 161,100Police 01-ERP-0202PSO / Parking Enforcement Vehicle n/a 53,700Police 01-ERP-0219PD - Video Data Server n/a 10,000Police 01-ERP-0305Single Axle Dump Truck (2)n/a 132,100Public Works: Streets/Traffic 01-ERP-0900Refuse Truck (RAP-R) (2)n/a 270,300Refuse 701,200Total for 2021 GRAND TOTAL 5,737,134 Friday, November 11, 2016 16 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN DEPARTMENT SUMMARY 2017 2021thru Total2017 2018 2019 2020 2021Department Comm Svcs - Activity Center 15,00015,000 Comm Svcs - Arts Center 17,10017,100 Comm Svcs - IT 581,000140,000 97,000 74,000 196,000 74,000 Community Services 11,30011,300 Fire 1,048,734967,117 54,217 27,400 Police 1,287,200110,000 430,000 255,000 267,400 224,800 Public Works: Bldg/Equip Serv 41,30010,000 31,300 Public Works: Parks/Forestry 362,400111,200 63,300 187,900 Public Works: Streets/Traffic 1,153,200575,100 289,600 156,400 132,100 Refuse 466,900101,600 95,000 270,300 Sewer 621,000621,000 Water 132,000132,000 2,768,017 1,077,517 527,800 662,600 701,200 5,737,134TOTAL Friday, November 11, 201617 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN PROJECTS BY DEPARTMENT 2017 2021thru Total2017 2018 2019 2020 2021Department Project# 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-1104 17,10017,100Art Center Theater Projector n/a 17,10017,100Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0003 110,00022,000 22,000 22,000 22,000 22,000CH - Network Server n/a 01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computers 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 132,00066,000 66,000Backup Server n/a 01-ERP-0211 110,00022,000 22,000 22,000 22,000 22,000PD - Network Server n/a 581,000140,000 97,000 74,000 196,000 74,000Comm Svcs - IT Total Community Services 01-ERP-0008 11,30011,300Document Management Scanner (2) n/a 11,30011,300Community Services Total Fire 01-ERP-0100 900,000900,000Tele-Squirt (Engine 2) n/a 01-ERP-0106 108,43454,217 54,217Aerial Truck n/a 01-ERP-0109 27,40027,400Extrication Tool (2)n/a 01-ERP-0112 12,90012,900Thermal Imaging Camera (2)n/a 1,048,734967,117 54,217 27,400Fire Total Police 01-ERP-0200 611,50098,000 147,000 98,000 107,400 161,100Marked 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 01-ERP-0203 55,00055,000PSO - Utility 4x4 n/a 01-ERP-0212 65,00065,000Squad Car Camera Systems n/a 01-ERP-0214 35,00035,000Tactical Ballistic Vests / Helmets - SWAT n/a 01-ERP-0217 29,00029,000Taser Replacement n/a 01-ERP-0218 17,00017,000Building Video Server n/a 01-ERP-0219 145,000115,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-0223 12,00012,000Squad Car Wireless Solution n/a Friday, November 11, 201618 Total2017 2018 2019 2020 2021Department Project# Priority 1,287,200110,000 430,000 255,000 267,400 224,800Police Total Public Works: Bldg/Equip Serv 01-ERP-0710 31,30031,3004X4 1/2 Ton Truck n/a 01-ERP-0714 10,00010,000PW - Truck Scan Kit 1 41,30010,000 31,300Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2) n/a 01-ERP-0807 34,20034,200Trucksters (3) n/a 01-ERP-0810 92,70092,700Large Turf Mower n/a 01-ERP-0812 45,00045,000Stump Cutter n/a 01-ERP-0814 10,00010,000Trailer Flatbed n/a 01-ERP-0815 32,00032,000Skid Loader n/a 01-ERP-0816 63,30063,300Toolcat n/a 362,400111,200 63,300 187,900Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a 01-ERP-0305 132,100132,100Single Axle Dump Truck (2) n/a 01-ERP-0306 460,000225,000 235,000Tandem Dump Truck (2) n/a 01-ERP-0311 156,400156,400Sweeper n/a 01-ERP-0312 45,90045,900PW - Roller n/a 01-ERP-0313 11,20011,200Striper n/a 01-ERP-0314 118,000118,000PW - Asphalt Paver n/a 01-ERP-0315 160,000160,000Snow Blower n/a 01-ERP-0318 15,00015,000Asphalt Hot Mix Heating Box - Trailer n/a 1,153,200575,100 289,600 156,400 132,100Public 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 01-ERP-0901 101,600101,600Refuse Truck (Rear-L)n/a 466,900101,600 95,000 270,300Refuse Total Sewer 01-ERP-0552 425,000425,000Jet Vactor n/a 01-ERP-0555 36,00036,000Generator (2)n/a 01-ERP-0559 160,000160,000SCADA Upgrade 1 621,000621,000Sewer Total Water 01-ERP-0500 32,00032,0003/4 Ton Truck n/a 01-ERP-0509 100,000100,000Water Treatment Plant 1 132,000132,000Water Total GRAND TOTAL 5,737,1342,768,017 1,077,517 527,800 662,600 701,200 Friday, November 11, 201619 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN FUNDING SOURCE SUMMARY 2017 thru 2021 TotalSource2017 2018 2019 2020 2021 AC - Arts Center Fund 17,10017,100 Bonds/Lease 108,43454,217 54,217 Equipment Replacement Fund 4,415,4501,859,200 934,950 527,800 662,600 430,900 RF - Refuse Fund 443,150101,600 71,250 270,300 SF - Sanitary Sewer Fund 531,000531,000 WF - Water Fund 222,000222,000 2,768,017 1,077,517 527,800 662,600 701,200 5,737,134GRAND TOTAL Friday, November 11, 2016 20 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN PROJECTS BY FUNDING SOURCE 2017 2021thru TotalSourceProject# Priority 2017 2018 2019 2020 2021 AC - Arts Center Fund 01-ERP-1104 17,10017,100Art Center Theater Projector n/a 17,10017,100AC - Arts Center Fund Total Bonds/Lease 01-ERP-0106 108,43454,217 54,217Aerial Truck n/a 108,43454,217 54,217Bonds/Lease Total Equipment Replacement Fund 01-ERP-0003 110,00022,000 22,000 22,000 22,000 22,000CH - Network Server n/a 01-ERP-0006 150,00030,000 30,000 30,000 30,000 30,000Computers n/a 01-ERP-0008 11,30011,300Document Management Scanner (2)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 132,00066,000 66,000Backup Server n/a 01-ERP-0036 15,00015,000Activity Center Sound System Replacement 3 01-ERP-0100 900,000900,000Tele-Squirt (Engine 2)n/a 01-ERP-0109 27,40027,400Extrication Tool (2)n/a 01-ERP-0112 12,90012,900Thermal Imaging Camera (2)n/a 01-ERP-0200 611,50098,000 147,000 98,000 107,400 161,100Marked 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 01-ERP-0203 55,00055,000PSO - Utility 4x4 n/a 01-ERP-0211 110,00022,000 22,000 22,000 22,000 22,000PD - Network Server n/a 01-ERP-0212 65,00065,000Squad Car Camera Systems n/a 01-ERP-0214 35,00035,000Tactical Ballistic Vests / Helmets - SWAT n/a 01-ERP-0217 29,00029,000Taser Replacement n/a 01-ERP-0218 17,00017,000Building Video Server n/a 01-ERP-0219 145,000115,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-0223 12,00012,000Squad Car Wireless Solution n/a 01-ERP-0302 54,60054,6004x2 1 Ton Dump Truck n/a 01-ERP-0305 132,100132,100Single Axle Dump Truck (2)n/a 01-ERP-0306 460,000225,000 235,000Tandem Dump Truck (2)n/a 01-ERP-0311 156,400156,400Sweepern/a 01-ERP-0312 45,90045,900PW - Roller n/a 01-ERP-0313 11,20011,200Stripern/a 01-ERP-0314 118,000118,000PW - Asphalt Paver n/a 01-ERP-0315 160,000160,000Snow Blower n/a 01-ERP-0318 15,00015,000Asphalt Hot Mix Heating Box - Trailer n/a Friday, November 11, 2016 21 TotalSourceProject# Priority 2017 2018 2019 2020 2021 01-ERP-0710 31,30031,3004X4 1/2 Ton Truck n/a 01-ERP-0714 10,00010,000PW - Truck Scan Kit 1 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2) n/a 01-ERP-0803 23,75023,750Swap Loader n/a 01-ERP-0807 34,20034,200Trucksters (3) n/a 01-ERP-0810 92,70092,700Large Turf Mower n/a 01-ERP-0812 45,00045,000Stump Cutter n/a 01-ERP-0814 10,00010,000Trailer Flatbed n/a 01-ERP-0815 32,00032,000Skid Loader n/a 01-ERP-0816 63,30063,300Toolcatn/a 4,415,4501,859,200 934,950 527,800 662,600 430,900Equipment Replacement Fund Total RF - Refuse Fund 01-ERP-0803 71,25071,250Swap Loader n/a 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2) n/a 01-ERP-0901 101,600101,600Refuse Truck (Rear-L) n/a 443,150101,600 71,250 270,300RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0552 425,000425,000Jet Vactor n/a 01-ERP-0555 36,00036,000Generator (2) n/a 01-ERP-0559 70,00070,000SCADA Upgrade 1 531,000531,000SF - Sanitary Sewer Fund Total WF - Water Fund 01-ERP-0500 32,00032,0003/4 Ton Truck n/a 01-ERP-0509 100,000100,000Water Treatment Plant 1 01-ERP-0559 90,00090,000SCADA Upgrade 1 222,000222,000WF - Water Fund Total 5,737,1342,768,017 1,077,517 527,800 662,600 701,200GRAND TOTAL Friday, November 11, 2016 22           EQUIPMENT REQUESTS  23 24 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Activity Ctr Director 2017 2021 thru Department Comm Svcs - Activity Center Description Replace and enhance the sound system in the Raspberry, Conference, Computer Nook, Harmony Hill, Lounge/Dining, and Office areas. Project #01-ERP-0036 Priority 3 Important Justification The present sound system in many of these areas are the original system installed in 1980. It was primarily used as a paging system. We will replace and enhance the sound system to allow better hearing for our participants as well as easier use of amplification devises for speakers, presenters, and instructors in these areas. Budget Impact/Other Useful Life 25 years Project Name Activity Center Sound System Replacement Category Equipment Type Equipment Future Total Project Cost:$15,000 Total2017 2018 2019 2020 2021Expenditures 15,00015,000Equipment 15,000 15,000Total Total2017 2018 2019 2020 2021Funding Sources 15,00015,000Equipment Replacement Fund 15,000 15,000Total Friday, November 11, 2016 25 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Arts Center Director 2017 2021 thru Department Comm Svcs - Arts Center Description Current projector is 3000 lumen -- 6500 lumen is required for theater usage including in partial light situations and to achieve the clarity needed for detailed images. Such a projector costs about $7,200 (including mounting and rigging hardware, cables and installation labor). The projector also needs to be part of a professional system that permits it to be operated from the theater tech booth or from on-stage -- the current projector is only operable from a hand-held remote requiring the operator to dash into the audience of the theater. This total cost of $15,200 includes all the wiring and hardware needed to support a projector well into the future. The projector itself is estimated to have a 5-year useful life. (The existing projector will be moved to one of the meeting rooms). Project #01-ERP-1104 Priority n/a Justification The justification of this expense is two-fold: First, in order to attract and retain arts and corporate renters we need to be able to provide the technical support required for their events. Income from such rentals (including Pen Pals and Digital Rivers) is becoming increasingly vital to the financial health of the Center. If we are not capable of competing with similar size venues, we will lose this income. Secondly, as a professional arts presenter we need to have the technical capabilities to run our own programs in a professional manner. Year 2018: $17,100 Year 2023 $19,800 Year 2028 $22,900 Budget Impact/Other Investing $15, 000 to retain major renters such as Pen Pals and Digital Rivers is worthwhile. Pen Pals alone brings in about $20.000/year in income. Digital Rivers just under $9,000. Useful Life 5 years Project Name Art Center Theater Projector Category Equipment Type Equipment Future Total Project Cost:$75,000 Total2017 2018 2019 2020 2021Expenditures 17,10017,100Equipment 17,100 17,100Total Total2017 2018 2019 2020 2021Funding Sources 17,10017,100AC - Arts Center Fund 17,100 17,100Total Friday, November 11, 2016 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact IT Director 2017 2021 thru 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 Variance from 20 year plan - Increase from 8,000 to 15,000. Software licensing has become more expensive. We are paying half of our server budget to required software and 8,000 isn't enough anymore. 2016 - Variance from 20 year plan - We were using a 4 year old server design for our servers that is not meeting current standards for speed of data access. Our new hardware design costs aprroximately 7,000 more than the old standard that was insufficent. Useful Life 1 year Project Name CH - Network Server Category Equipment Type Equipment Future Total Project Cost:$626,000 Total2017 2018 2019 2020 2021Expenditures 110,00022,000 22,000 22,000 22,000 22,000Equipment 22,000 22,000 22,000 22,000 22,000 110,000Total Total2017 2018 2019 2020 2021Funding Sources 110,00022,000 22,000 22,000 22,000 22,000Equipment Replacement Fund 22,000 22,000 22,000 22,000 22,000 110,000Total Friday, November 11, 2016 27 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Finance Director/IT 2017 2021 thru 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 Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Useful Life 3-5 years Project Name Computers Category Equipment Type Equipment Future Total Project Cost:$1,050,000 Total2017 2018 2019 2020 2021Expenditures 150,00030,000 30,000 30,000 30,000 30,000Equipment 30,000 30,000 30,000 30,000 30,000 150,000Total Total2017 2018 2019 2020 2021Funding Sources 150,00030,000 30,000 30,000 30,000 30,000Equipment Replacement Fund 30,000 30,000 30,000 30,000 30,000 150,000Total Friday, November 11, 2016 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Finance Director/IT 2017 2021 thru 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 years Project Name Core Network Switch Category Equipment Type Equipment Future Total Project Cost:$71,000 Total2017 2018 2019 2020 2021Expenditures 17,00017,000Equipment 17,000 17,000Total Total2017 2018 2019 2020 2021Funding Sources 17,00017,000Equipment Replacement Fund 17,000 17,000Total Friday, November 11, 2016 29 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact IT Director 2017 2021 thru Department Comm Svcs - IT Description With technology trending towards an explosion of mobile devices we need to be able to manage, secure and provide connectivity to current and future devices Project #01-ERP-0013 Priority n/a Justification We have cellular dead spots in buildings that can be fixed with inexpensive cell bosing technology. The number of mobile devices owned by the city is increasing every year. Our current internal Wi-Fi infrastructure has been put to together with technology that was never designed for the enterprise. As the Wi-Fi infrastructure is increasing the system isn't staying stable enough to meet demands. Just about every city building now has a business need for Wi-Fi. Our current mobile device management infrastructure needs updating to handle the influx of city data on employee owned devices, CJIS protected data, need for content filtering, as well as maintain the security of current devices. Budget Impact/Other 2016 - New ERP item Useful Life 5-7 years Project Name Wi-Fi and Cellular Category Equipment Type Equipment Future Total Project Cost:$18,000 Total2017 2018 2019 2020 2021Expenditures 12,0006,000 6,000Equipment 6,000 6,000 12,000Total Total2017 2018 2019 2020 2021Funding Sources 12,0006,000 6,000Equipment Replacement Fund 6,000 6,000 12,000Total Friday, November 11, 2016 30 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact IT Director 2017 2021 thru 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 years Project Name Distribution Network Switches Category Equipment Type Equipment Future Total Project Cost:$107,000 Total2017 2018 2019 2020 2021Expenditures 50,00050,000Equipment 50,000 50,000Total Total2017 2018 2019 2020 2021Funding Sources 50,00050,000Equipment Replacement Fund 50,000 50,000Total Friday, November 11, 2016 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact IT Director 2017 2021 thru 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 years Project Name Backup Server Category Equipment Type Equipment Future Total Project Cost:$132,000 Total2017 2018 2019 2020 2021Expenditures 132,00066,000 66,000Equipment 66,000 66,000 132,000Total Total2017 2018 2019 2020 2021Funding Sources 132,00066,000 66,000Equipment Replacement Fund 66,000 66,000 132,000Total Friday, November 11, 2016 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact IT Director 2017 2021 thru Department Comm Svcs - IT Description Computer servers store information and system programs for Police Department. One server @ $22,000 for system upgrades 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 Variance from 20 year plan - Increase from 8,500 to 15,000. Software licensing has become more expensive. We are paying half our server budget for required software and 8,500 isn't enough anymore. 2016 Variance from 20 year plan - We were using a 4 year old server design for our servers that is not meeting current standards for speed of data access. Our new hardware design costs aprroximately 7,000 more than the old standard that was insufficent. Useful Life 3 years Project Name PD - Network Server Category Equipment Type Equipment Future Total Project Cost:$631,000 Total2017 2018 2019 2020 2021Expenditures 110,00022,000 22,000 22,000 22,000 22,000Equipment 22,000 22,000 22,000 22,000 22,000 110,000Total Total2017 2018 2019 2020 2021Funding Sources 110,00022,000 22,000 22,000 22,000 22,000Equipment Replacement Fund 22,000 22,000 22,000 22,000 22,000 110,000Total Friday, November 11, 2016 33 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact City Clerk 2017 2021 thru 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 years Project Name Document Management Scanner (2)Category Equipment Type Equipment Future Total Project Cost:$87,600 Total2017 2018 2019 2020 2021Expenditures 11,30011,300Equipment 11,300 11,300Total Total2017 2018 2019 2020 2021Funding Sources 11,30011,300Equipment Replacement Fund 11,300 11,300Total Friday, November 11, 2016 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Fire Chief 2017 2021 thru Department Fire Description Fire engine: full size response truck Current vehicle: 1989 Ford L9000 Tele-Squirt (#102) 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 years Project Name Tele-Squirt (Engine 2)Category Vehicles Type Equipment Future Total Project Cost:$1,900,000 Total2017 2018 2019 2020 2021Expenditures 900,000900,000Equipment 900,000 900,000Total Total2017 2018 2019 2020 2021Funding Sources 900,000900,000Equipment Replacement Fund 900,000 900,000Total Friday, November 11, 2016 35 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Fire Chief 2017 2021 thru 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 years Project Name Aerial Truck Category Vehicles Type Equipment Future Total Project Cost:$2,559,597 Total2017 2018 2019 2020 2021Expenditures 108,43454,217 54,217Equipment 54,217 54,217 108,434Total Total2017 2018 2019 2020 2021Funding Sources 108,43454,217 54,217Bonds/Lease 54,217 54,217 108,434Total Friday, November 11, 2016 36 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Fire Chief 2017 2021 thru Department Fire Description Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. Project #01-ERP-0109 Priority n/a Justification All vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool will be added to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. Budget Impact/Other Variance from 20 year plan - move back from 2015 to 2019. Estimate salvage/resale value on replaced item: $1,000 Purchased: 2007 Useful Life 10 years Project Name Extrication Tool (2)Category Equipment Type Equipment Future Total Project Cost:$177,200 Total2017 2018 2019 2020 2021Expenditures 27,40027,400Equipment 27,400 27,400Total Total2017 2018 2019 2020 2021Funding Sources 27,40027,400Equipment Replacement Fund 27,400 27,400Total Friday, November 11, 2016 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Fire Chief 2017 2021 thru 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 2003 & 2007 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. Previously one was included in the replacement plan. This will add to the replacement schedule the camera purchased from the Fire Dept. budget in 2003. Estimate salvage/resale value on replaced item: $-0- Useful Life 10 years Project Name Thermal Imaging Camera (2)Category Equipment Type Equipment Future Total Project Cost:$92,900 Total2017 2018 2019 2020 2021Expenditures 12,90012,900Equipment 12,900 12,900Total Total2017 2018 2019 2020 2021Funding Sources 12,90012,900Equipment Replacement Fund 12,900 12,900Total Friday, November 11, 2016 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief 2017 2021 thru 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 7 patrol vehicles - all marked Current Vehicles: (1) 2013 Ford Utility, (1) 2014 Ford Utility, (3) 2015 Ford Utility, (2) 2016 Ford Utility 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 Variance from 20 year plan - cost modified due to new models of squads which need to be re-outfitted for all equipment. Estimate salvage/resale value on replaced item: $4,000 each Useful Life 3 years Project Name Marked Patrol Vehicles (7)Category Vehicles Type Equipment Future Total Project Cost:$3,382,600 Total2017 2018 2019 2020 2021Expenditures 611,50098,000 147,000 98,000 107,400 161,100Vehicles 98,000 147,000 98,000 107,400 161,100 611,500Total Total2017 2018 2019 2020 2021Funding Sources 611,50098,000 147,000 98,000 107,400 161,100Equipment Replacement Fund 98,000 147,000 98,000 107,400 161,100 611,500Total Friday, November 11, 2016 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief 2017 2021 thru 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: 2014 Ford Utility 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 Variance from 20 year plan - cost modified due to new model of car which will require all new equipment. Estimate salvage/resale value on replaced item: $3,500 each Useful Life 4 years Project Name Sergeant's Vehicle Category Vehicles Type Equipment Future Total Project Cost:$400,600 Total2017 2018 2019 2020 2021Expenditures 49,00049,000Vehicles 49,000 49,000Total Total2017 2018 2019 2020 2021Funding Sources 49,00049,000Equipment Replacement Fund 49,000 49,000Total Friday, November 11, 2016 40 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief 2017 2021 thru Department Police Description Marked patrol vehicle used by PSO Evidence Tech / Parking Enforcement Officer to respond to calls for service, enforce parking laws, and perform duties associated with evidentiary processes. Current Vehicle: (1) 2016 Ford Utility 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 Variance from 20 year plan - vehicle was increasd to account for the outfitting and radio Estimate salvage/resale value on replaced item: $1,500 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 years Project Name PSO / Parking Enforcement Vehicle Category Vehicles Type Equipment Future Total Project Cost:$168,900 Total2017 2018 2019 2020 2021Expenditures 53,70053,700Vehicles 53,700 53,700Total Total2017 2018 2019 2020 2021Funding Sources 53,70053,700Equipment Replacement Fund 53,700 53,700Total Friday, November 11, 2016 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief 2017 2021 thru 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: 2014 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 Estimate salvage/resale value on replaced item: $5,000 2016 - Variance from 20 year plan - Change in replacement schedule due to full time use of vehicle. Changing useful life from 6 years to 4 years Useful Life 4 years Project Name PSO - Utility 4x4 Category Vehicles Type Equipment Future Total Project Cost:$328,300 Total2017 2018 2019 2020 2021Expenditures 55,00055,000Vehicles 55,000 55,000Total Total2017 2018 2019 2020 2021Funding Sources 55,00055,000Equipment Replacement Fund 55,000 55,000Total Friday, November 11, 2016 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief 2017 2021 thru Department Police Description Squad car camera systems are used to document events inside and outside of squad cars. The camera systems utilize a forward facing camera and a prisoner transport area camaera. The squad car camaera systems is independent of any body worn camera system that may be in use by a police officer. Current equipment: 11 - 2007 Panasonic Laptops Digital video camera system in each marked patrol car - used to document events in and out of the patrol car. Images downloaded to server for storage and retrieval. Current equipment: 2009 ICOP Model 20/20-W LIVE Project #01-ERP-0212 Priority n/a Justification Computers: Limited life of 5 years - replacement necessary. The squad car camera systems are vital to accurate documentation of law enforcement activities and criminal prosecution of crimes. The squad car camera systems are also used for documentation of police officer activities and open transparency with the community. Budget Impact/Other Variance from 20 year plan - ERP - Move back one year to 2014. All working - no problems. Estimate salvage/resale value on replaced item: $-0- In 2014 the Police Dept. has the opportunity to purchase a combined mobile data computer/digital camera component for a total cost of $148,000. Originally the total of the cameras and computers together totaled $116,100 with the computers scheduled for 2014 and the cameras scheduled for 2015. The cameras are being pulled forward to 2014. 2016 - Variance from 20 year plan - Change in replacement year to accurately reflect life expectancy in relation to when the cameras were purchased. Change in budgeted amount to reflect past and anticipated costs. Useful Life 5 years Project Name Squad Car Camera Systems Category Equipment Type Equipment Future Total Project Cost:$557,500 Total2017 2018 2019 2020 2021Expenditures 65,00065,000Equipment 65,000 65,000Total Total2017 2018 2019 2020 2021Funding Sources 65,00065,000Equipment Replacement Fund 65,000 65,000Total Friday, November 11, 2016 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief 2017 2021 thru Department Police Description Tactical ballistic vests worn by members of the Hopkins Police Department SWAT (Special Weapons and Tactics) team. These vests offer a higher level of protection against weapon assault than the regular duty ballistic vest. SWAT members also require a kevlar helmet on the same roatational cycle Current equipment: 11 - Protech Tactical Vests Project #01-ERP-0214 Priority n/a Justification Federal and State grant monies have been available through the Ballistic Vest Program over the past several years. These grants only pay a portion of the total cost of the vest, leaving the Police Department to pay the balance. There is no guarantee that these grants will be available in the future. Warranty on the current vests expires in 2018. Budget Impact/Other Variance from 20 year plan - Team membership has increased to 11. Estimate salvage/resale value on replaced item: $ Without grant money the estimated cost for 11 vests and helmets is $44,274 Useful Life 5 years Project Name Tactical Ballistic Vests / Helmets - SWAT Category Equipment Type Equipment Future Total Project Cost:$213,200 Total2017 2018 2019 2020 2021Expenditures 35,00035,000Equipment 35,000 35,000Total Total2017 2018 2019 2020 2021Funding Sources 35,00035,000Equipment Replacement Fund 35,000 35,000Total Friday, November 11, 2016 44 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Captain 2017 2021 thru 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. The department purchases 10 Tasers with cameras along with a warranty plan. We are able to trade in the older devices and receive credit on new equipment. 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 10- X2 Taser, 2 – batteries, 10 – training cartridges, 10 – field use cartridges, 1 – holster, 1 – extended warranty (Taser Camera and warranty) for each Taser. $708.82 Total overall cost each Taser in 2018 = $2870.00 (+ shipping/tax) Useful Life 4 years Project Name Taser Replacement Category Equipment Type Equipment Future Total Project Cost:$152,600 Total2017 2018 2019 2020 2021Expenditures 29,00029,000Equipment 29,000 29,000Total Total2017 2018 2019 2020 2021Funding Sources 29,00029,000Equipment Replacement Fund 29,000 29,000Total Friday, November 11, 2016 45 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief/IT 2017 2021 thru 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 - New item. Current equipment was purchased with DTF funding as will the 2015 replacement. Beginning in 2019 it will be funded with ERP funds. Estimate salvage/resale value on replaced item: $-0- Useful Life 4 years Project Name Building Video Server Category Equipment Type Equipment Future Total Project Cost:$85,000 Total2017 2018 2019 2020 2021Expenditures 17,00017,000Equipment 17,000 17,000Total Total2017 2018 2019 2020 2021Funding Sources 17,00017,000Equipment Replacement Fund 17,000 17,000Total Friday, November 11, 2016 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief 2017 2021 thru Department Police Description The police department video server is used to store evidentiary video and audio data. Rules pertaining to criminal procedure, and laws regarding data privacy and retention place requirements on the Police Department to store and manage the data for varying lengths of time. The current data storage solution was designed for squad car video only and is near capacity. The storage solution is also not currently designed to efficiently back up data and is potentially subject to data loss from environmental factors such as drive failure and unsuited fire suppression systems Project #01-ERP-0219 Priority n/a Justification The server is needed to maintain evidentiary squad car video and audio based upon State of Minnesota statutes and rules for varying lengths of time. The current storage solution is near capacity and is not being backed up in a manner suitably protecting it from loss. The current storage solution will not facilitate data storage of body worn camera video data and data retention. A properly designed and implemented video data storage server will protect data from potential loss and corruption. Maintenance of the video data storage server will have yearly associated costs that need to be accounted for. Budget Impact/Other Cost of video data storgae server: $115,000.00 Cost of yearly maintenance for video data storgae server: $10,000.00/year Useful Life 5 years Project Name PD - Video Data Server Category Equipment Type Equipment Future Total Project Cost:$165,000 Total2017 2018 2019 2020 2021Expenditures 145,000115,000 10,000 10,000 10,000Equipment 115,000 10,000 10,000 10,000 145,000Total Total2017 2018 2019 2020 2021Funding Sources 145,000115,000 10,000 10,000 10,000Equipment Replacement Fund 115,000 10,000 10,000 10,000 145,000Total Friday, November 11, 2016 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief/IT 2017 2021 thru 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. Current equipment: 11 - Data 911 Computers purchased in 2014 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 2016 - Variance from 20 year plan - Change in replacement year to accurately reflect life expectancy in relation to when the computers were purchased. Change in budgeted amount to reflect past and anticipated costs. Useful Life 5 years Project Name Mobile Data Computers Category Equipment Type Equipment Future Total Project Cost:$290,000 Total2017 2018 2019 2020 2021Expenditures 65,00065,000Equipment 65,000 65,000Total Total2017 2018 2019 2020 2021Funding Sources 65,00065,000Equipment Replacement Fund 65,000 65,000Total Friday, November 11, 2016 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief/IT 2017 2021 thru Department Police Description LETG - Records Management System was purchased at the end of 2012. This maintains all police records and reports. Zurcher Technologies acquired LETG in 2016 unexpectedly. We anticipate LETG will not be supported by 2020. Project #01-ERP-0221 Priority n/a Justification A new RMS system may be needed by 2020 as the current system will likely not be supported by the new company. Budget Impact/Other Current cost to maintain system is $26,989 anually. Useful LifeProject Name Records Management System Category Equipment Type Equipment Future Total Project Cost:$150,000 Total2017 2018 2019 2020 2021Expenditures 150,000150,000Equipment 150,000 150,000Total Total2017 2018 2019 2020 2021Funding Sources 150,000150,000Equipment Replacement Fund 150,000 150,000Total Friday, November 11, 2016 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Police Chief 2017 2021 thru Department Police Description The squad cars must have reliable wireless cellular solutions in order for the mobile data comupters to communicate with the numerous criminal justice databases that officers must access throughout daily patrol functions. Project #01-ERP-0223 Priority n/a Justification The current aircard solutions and Mifi wireless modems are not specifically designed for continuous law enforcement activies. The purposed Cradlepoint wireless solution would provide a stable wireless solution with mil-spec hardware designed to withstand the harsh vehicle conditions. Budget Impact/Other Useful Life 4 years Project Name Squad Car Wireless Solution Category Equipment Type Equipment Future Total Project Cost:$12,000 Total2017 2018 2019 2020 2021Expenditures 12,00012,000Equipment 12,000 12,000Total Total2017 2018 2019 2020 2021Funding Sources 12,00012,000Equipment Replacement Fund 12,000 12,000Total Friday, November 11, 2016 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru 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. 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. Estimate salvage/resale value on replaced item: $1,500 Useful Life 10 years Project Name 4X4 1/2 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$96,700 Total2017 2018 2019 2020 2021Expenditures 31,30031,300Vehicles 31,300 31,300Total Total2017 2018 2019 2020 2021Funding Sources 31,30031,300Equipment Replacement Fund 31,300 31,300Total Friday, November 11, 2016 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru 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 years Project Name PW - Truck Scan Kit Category Vehicles Type Equipment Future Total Project Cost:$10,000 Total2017 2018 2019 2020 2021Expenditures 10,00010,000Equipment 10,000 10,000Total Total2017 2018 2019 2020 2021Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Friday, November 11, 2016 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru 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 years Project Name 4x4 3/4Ton Trucks (2)Category Vehicles Type Equipment Future Total Project Cost:$313,800 Total2017 2018 2019 2020 2021Expenditures 85,20085,200Vehicles 85,200 85,200Total Total2017 2018 2019 2020 2021Funding Sources 85,20085,200Equipment Replacement Fund 85,200 85,200Total Friday, November 11, 2016 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru 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 n/a 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 years Project Name Trucksters (3)Category Equipment Type Equipment Future Total Project Cost:$145,440 Total2017 2018 2019 2020 2021Expenditures 34,20034,200Equipment 34,200 34,200Total Total2017 2018 2019 2020 2021Funding Sources 34,20034,200Equipment Replacement Fund 34,200 34,200Total Friday, November 11, 2016 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru 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.. Estimate salvage/resale value on replaced item: $3,500 Useful Life 10 years Project Name Large Turf Mower Category Equipment Type Equipment Future Total Project Cost:$332,300 Total2017 2018 2019 2020 2021Expenditures 92,70092,700Equipment 92,700 92,700Total Total2017 2018 2019 2020 2021Funding Sources 92,70092,700Equipment Replacement Fund 92,700 92,700Total Friday, November 11, 2016 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Parks/Forestry Description Stump cutter used by Parks Division of Public Works. Current equipment: 1997 Vermeer Stump Cutter (#832) Project #01-ERP-0812 Priority n/a Justification Chipping out stumps of trees removed from city property. Budget Impact/Other Variance from 20 year plan - extend to 20 years to reflect actual. Estimate salvage/resale value on replaced item: $1,800 2016-Increased estimated replacement cost from $21,200 to $45,000 Useful Life 20 years Project Name Stump Cutter Category Equipment Type Equipment Future Total Project Cost:$45,000 Total2017 2018 2019 2020 2021Expenditures 45,00045,000Equipment 45,000 45,000Total Total2017 2018 2019 2020 2021Funding Sources 45,00045,000Equipment Replacement Fund 45,000 45,000Total Friday, November 11, 2016 56 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Parks/Forestry Description Used to haul multiple riding mowers Current trailor: Unit #845, 1997 Remackle Trailer Project #01-ERP-0814 Priority n/a Justification Allows one truck to pull two riding mowers to parks Budget Impact/Other Variance from 20 year plan - Move up one year. Estimate salvage/resale value on replaced item: $ 2016-Increased estimated replacement cost from $2,200 to $10,000 Useful Life 15 years Project Name Trailer Flatbed Category Equipment Type Equipment Future Total Project Cost:$11,400 Total2017 2018 2019 2020 2021Expenditures 10,00010,000Equipment 10,000 10,000Total Total2017 2018 2019 2020 2021Funding Sources 10,00010,000Equipment Replacement Fund 10,000 10,000Total Friday, November 11, 2016 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Parks/Forestry Description Current equipment: 2004 Bobcat 463 (#833) Project #01-ERP-0815 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - new item in 2004. Estimate salvage/resale value on replaced item: $ Useful Life 12 years Project Name Skid Loader Category Equipment Type Equipment Future Total Project Cost:$77,600 Total2017 2018 2019 2020 2021Expenditures 32,00032,000Equipment 32,000 32,000Total Total2017 2018 2019 2020 2021Funding Sources 32,00032,000Equipment Replacement Fund 32,000 32,000Total Friday, November 11, 2016 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru 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 years Project Name Toolcat Category Equipment Type Equipment Future Total Project Cost:$295,100 Total2017 2018 2019 2020 2021Expenditures 63,30063,300Equipment 63,300 63,300Total Total2017 2018 2019 2020 2021Funding Sources 63,30063,300Equipment Replacement Fund 63,300 63,300Total Friday, November 11, 2016 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description Truck used in the Street Division of Public Works. Current vehicle: 2006 Ford F350 Pickup (#307) Project #01-ERP-0302 Priority n/a Justification Plows alleys in winter, light hauling, snow removal and transportation. Budget Impact/Other Variance from 20 year plan - change from 4x4 to 4x2 truck. Reduce cost to $30,500. Move up from 2008 to 2006. Extend useful life from 8 to 12 years. Estimate salvage/resale value on replaced item: $3,500 Useful Life 12 years Project Name 4x2 1 Ton Dump Truck Category Equipment Type Equipment Future Total Project Cost:$162,900 Total2017 2018 2019 2020 2021Expenditures 54,60054,600Equipment 54,600 54,600Total Total2017 2018 2019 2020 2021Funding Sources 54,60054,600Equipment Replacement Fund 54,600 54,600Total Friday, November 11, 2016 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description Single axle dump truck used by various division of Public Works. Current vehicles: 2001 Ford L7501 (#313), 2005 Freightliner M2 106 (#312) and 2011 Freightliner MZ-1068 (#311) Project #01-ERP-0305 Priority n/a Justification Vehicle used for heavy hauling, snow plowing and sanding. Moved single axel dump truck due in 2018 to a tandem axel dump truck in 2018. Done to increase snow hauling and other material hauling capacity. Budget Impact/Other Variance from 20 year plan - Move 1 truck from single axle to tandem axel to increase hauling capacity for snow and road materials. Estimate salvage/resale value on replaced item: $4,500 each We will then have 2 single axel (change from 3) dump trucks and 2 (change from 1) tandem axel dump trucks. Useful Life 17 years Project Name Single Axle Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$550,100 Total2017 2018 2019 2020 2021Expenditures 132,100132,100Vehicles 132,100 132,100Total Total2017 2018 2019 2020 2021Funding Sources 132,100132,100Equipment Replacement Fund 132,100 132,100Total Friday, November 11, 2016 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description Dump truck used in Streets Division of Public Works. Current vehicles: 1998 Ford LT8500 Tandem (#314) Project #01-ERP-0306 Priority n/a Justification Trucks used for heavy hauling, snow plowing and sanding. To increase snow and other material hauling capacity. Moved from a single axel dump truck in 2018 to a tandem axel truck in 2018. Budget Impact/Other Variance from 20 year plan - Move from 2018 to 2017. Moved 1 single axel dump truck due in 2018 to a tandem axel dump truck due in 2018. Estimate salvage/resale value on replaced item: $-0- 2016-Increased estimated replacement costs by $50,000 each year Useful Life 17 years Project Name Tandem Dump Truck (2)Category Vehicles Type Equipment Future Total Project Cost:$1,062,000 Total2017 2018 2019 2020 2021Expenditures 460,000225,000 235,000Vehicles 225,000 235,000 460,000Total Total2017 2018 2019 2020 2021Funding Sources 460,000225,000 235,000Equipment Replacement Fund 225,000 235,000 460,000Total Friday, November 11, 2016 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description Street sweeper used by Streets Division for sweeping streets and parking lots. Current equipment: 2001 Elgin Pelican SE (#327) Project #01-ERP-0311 Priority n/a Justification Street sweeping, event clean-up, spring sand removal. Budget Impact/Other Variance from 20 year plan - Move from 2021 to 2019 Estimate salvage/resale value on replaced item: $12,000 Useful Life 15 years Project Name Sweeper Category Equipment Type Equipment Future Total Project Cost:$271,700 Total2017 2018 2019 2020 2021Expenditures 156,400156,400Equipment 156,400 156,400Total Total2017 2018 2019 2020 2021Funding Sources 156,400156,400Equipment Replacement Fund 156,400 156,400Total Friday, November 11, 2016 63 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description Used by Street Department for asphalt repair and resurfacing. Current equipment: 1989 Ingersoll Rand Roller (#330) Project #01-ERP-0312 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - Move from 2016 to 2017. Estimate salvage/resale value on replaced item: $ Useful Life 20 years Project Name PW - Roller Category Equipment Type Equipment Future Total Project Cost:$127,900 Total2017 2018 2019 2020 2021Expenditures 45,90045,900Equipment 45,900 45,900Total Total2017 2018 2019 2020 2021Funding Sources 45,90045,900Equipment Replacement Fund 45,900 45,900Total Friday, November 11, 2016 64 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description Line striper. Current equipment: 1993 Line Striper A1990 (#352) Project #01-ERP-0313 Priority n/a Justification Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Useful Life 12 years Project Name Striper Category Equipment Type Equipment Future Total Project Cost:$27,200 Total2017 2018 2019 2020 2021Expenditures 11,20011,200Equipment 11,200 11,200Total Total2017 2018 2019 2020 2021Funding Sources 11,20011,200Equipment Replacement Fund 11,200 11,200Total Friday, November 11, 2016 65 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description Asphalt paver used by Streets Division of Public Works. Current equipment: 1994 Caterpillar AD200B Paver (#337) Project #01-ERP-0314 Priority n/a Justification Paving streets and parking lots. Budget Impact/Other Variance from 20 year plan. Move from 2016 to 2018 Estimate salvage/resale value on replaced item: $500 2016 - Move from 2018 to 2017, decrease useful life from 20 to 15 years, update estimated cost from 48,800 to $118,000 Useful Life 15 years Project Name PW - Asphalt Paver Category Equipment Type Equipment Future Total Project Cost:$238,000 Total2017 2018 2019 2020 2021Expenditures 118,000118,000Equipment 118,000 118,000Total Total2017 2018 2019 2020 2021Funding Sources 118,000118,000Equipment Replacement Fund 118,000 118,000Total Friday, November 11, 2016 66 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description Snow blower used by the Streets Division of Public Works for snow removal in the downtown area. Current equipment: 1996 SnoGo WK800 (#344) Project #01-ERP-0315 Priority n/a Justification Blowing and loading snow off Mainstreet into trucks. The current Sno-Go is a 1996 model and has served its useful life. The street department must have a dependable snow blower for the removal of snow in the downtown area. This is a two stage blower fed with augers, which will ensure the completion of the work required. In 2014 we purchased a Fair Snocrete snow blower for $71,489. This machine does not perform its function for our needs to remove snow from the downtown area. Public Works would like to trade-in or sell this machine and purchase a Sno-Go machine, which has proven to be the one that works for our application. We are currently depending on a 1996 Sno-Go to handle the work. Budget Impact/Other Variance from 20 year plan. Move from 2016 to 2014. Reduce amount to purchase hydraulic powered blower. Item no purchased in 2014 and did not get put back in the ERP. Now scheduled for 2017. Originally budgeted for $65,000, complete replacement now estimated at $160,000 Estimate salvage/resale value on replaced item: $4,500 Useful Life 20 years Project Name Snow Blower Category Equipment Type Equipment Future Total Project Cost:$342,000 Total2017 2018 2019 2020 2021Expenditures 160,000160,000Equipment 160,000 160,000Total Total2017 2018 2019 2020 2021Funding Sources 160,000160,000Equipment Replacement Fund 160,000 160,000Total Friday, November 11, 2016 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Public Works: Streets/Traffic Description A trailer that hauls up to 2.5 tons of hot asphalt and heats the mix to keep it workable. Project #01-ERP-0318 Priority n/a Justification Current asphalt hot mix heating box insert sits in the back of a truck and is too small, 1 ton capacity. Sits too high to be handled easily. The trailer will hold more mix, reducing the trips to the asphalt plant, and will work better ergonomically. Budget Impact/Other Variance from 20 year plan - New item. 2016 - Upgrading from mounted unit to trailer Estimate salvage/resale value on replaced item: $-0-. Useful Life 12 years Project Name Asphalt Hot Mix Heating Box - Trailer Category Equipment Type Equipment Future Total Project Cost:$52,600 Total2017 2018 2019 2020 2021Expenditures 15,00015,000Equipment 15,000 15,000Total Total2017 2018 2019 2020 2021Funding Sources 15,00015,000Equipment Replacement Fund 15,000 15,000Total Friday, November 11, 2016 68 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Refuse Description Dumpster swap loader refuse truck used to haul bulk pick-up items, refuse from parks and downtown, scrap metal and hauling waster and snow. Utilized by Refuse for hauling dumpsters and Forestry for chipping trees. Cost shared Refuse and Eqiupment Replacement Fund as follows: 75% Refuse 25% ER Fund (Parks/Forrestry) Current equipment: 1993 International LP4700 (#810) Project #01-ERP-0803 Priority n/a Justification Needed for waste and snow hauling. Budget Impact/Other Variance from 20 year plan - Estimate salvage/resale value on replaced item: $ Useful Life 20 years Project Name Swap Loader Category Equipment Type Equipment Future Total Project Cost:$346,000 Total2017 2018 2019 2020 2021Expenditures 95,00095,000Equipment 95,000 95,000Total Total2017 2018 2019 2020 2021Funding Sources 23,75023,750Equipment Replacement Fund 71,25071,250RF - Refuse Fund 95,000 95,000Total Friday, November 11, 2016 69 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Refuse Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 2005 Peterbilt Rapid Rail (#901) & 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 10 years Project Name Refuse Truck (RAP-R) (2)Category Vehicles Type Equipment Future Total Project Cost:$1,462,600 Total2017 2018 2019 2020 2021Expenditures 270,300270,300Vehicles 270,300 270,300Total Total2017 2018 2019 2020 2021Funding Sources 270,300270,300RF - Refuse Fund 270,300 270,300Total Friday, November 11, 2016 70 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Refuse Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 1996 Freightliner FL70 (#903) Project #01-ERP-0901 Priority n/a Justification Residential waste pick up. Budget Impact/Other Variance from 20 year plan. Move from 2016 to 2017 Estimate salvage/resale value on replaced item: $9,000 Useful Life 15 Project Name Refuse Truck (Rear-L)Category Vehicles Type Equipment Future Total Project Cost:$238,100 Total2017 2018 2019 2020 2021Expenditures 101,600101,600Vehicles 101,600 101,600Total Total2017 2018 2019 2020 2021Funding Sources 101,600101,600RF - Refuse Fund 101,600 101,600Total Friday, November 11, 2016 71 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Sewer Description Single axle truck used by Water/Sewer Divisions of Public Works. 2016 - Change to dual axel Vactor jet truck Current equipment: 2001 Sterling Vac-Con Project #01-ERP-0552 Priority n/a Justification Cleaning sewer and catch basins. 2016 - Changed purchase date from 2020 to 2017 due to frequent breakdown of the current jetter. Budget Impact/Other Variance from 20 year plan - increase cost from $180,000 to $350,000 to reflect actual replacement cost. Estimate salvage/resale value on replaced item: $25,000 2016 - Cost increase by 75,000 Useful Life 20 years Project Name Jet Vactor Category Equipment Type Equipment Future Total Project Cost:$425,000 Total2017 2018 2019 2020 2021Expenditures 425,000425,000Equipment 425,000 425,000Total Total2017 2018 2019 2020 2021Funding Sources 425,000425,000SF - Sanitary Sewer Fund 425,000 425,000Total Friday, November 11, 2016 72 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Sewer Description Portable generator used by Water/Sewer Divisions of Public Works. 2016 - Increase cost from 26k to 36k due to updated information Current equipment: 1997 Kohler Generator, 2008 Caterpillar C15 (#537) Project #01-ERP-0555 Priority n/a Justification Emergency back up generator for lift stations and pumps, off site power for lights and welding. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 2016 - Increase cost from 26k to 36k due to updated information Useful Life 25 years Project Name Generator (2)Category Equipment Type Equipment Future Total Project Cost:$79,000 Total2017 2018 2019 2020 2021Expenditures 36,00036,000Equipment 36,000 36,000Total Total2017 2018 2019 2020 2021Funding Sources 36,00036,000SF - Sanitary Sewer Fund 36,000 36,000Total Friday, November 11, 2016 73 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Sewer Description SCADA upgrades Project #01-ERP-0559 Priority 1 Urgent Justification SCADA is outdated, upgrade or replacement needed for PLC, software and radio parts Budget Impact/Other Useful Life 10 years Project Name SCADA Upgrade Category Equipment Type Equipment Future Total Project Cost:$160,000 Total2017 2018 2019 2020 2021Expenditures 160,000160,000Equipment 160,000 160,000Total Total2017 2018 2019 2020 2021Funding Sources 70,00070,000SF - Sanitary Sewer Fund 90,00090,000WF - Water Fund 160,000 160,000Total Friday, November 11, 2016 74 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru 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 years Project Name 3/4 Ton Truck Category Vehicles Type Equipment Future Total Project Cost:$88,500 Total2017 2018 2019 2020 2021Expenditures 32,00032,000Vehicles 32,000 32,000Total Total2017 2018 2019 2020 2021Funding Sources 32,00032,000WF - Water Fund 32,000 32,000Total Friday, November 11, 2016 75 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Contact Public Works Director 2017 2021 thru Department Water Description Used to convert gas Chlorine to liquid Sodium Hypochlorite Project #01-ERP-0509 Priority 1 Urgent Justification Chlorine gas is extremely danferous and corrosive. Liquid bleach is easy to contain and work with. Budget Impact/Other Useful Life 10 years Project Name Water Treatment Plant Category Equipment Type Equipment Future Total Project Cost:$100,000 Total2017 2018 2019 2020 2021Expenditures 100,000100,000Equipment 100,000 100,000Total Total2017 2018 2019 2020 2021Funding Sources 100,000100,000WF - Water Fund 100,000 100,000Total Friday, November 11, 2016 76           TWENTY‐YEAR  REPLACEMENT SCHEDULE  77 78 11-Nov-16 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average:$914,600INFLATION FACTOR - 3%REPLEQUIPMENT /VEHICLES YRS 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036ACTIVITY CENTERERP-032 Sound System1515,00024,000ERP-035 Floor Scrubber106,7009,000SUBTOTAL15,0006,70024,0009,000ARTS CENTERERP-1100 Copy Machine (leased) ERP-1101 Carpet Extractor 10 5,2007,000ERP-1102 Kitchen Catering Equipment 127,100ERP-1103 Video Camera Updates 5 4,300 5,000 5,800ERP-1104 Theater Projector 5 17,100 19,800 22,900ERP-1105 Community Room A/V 7 13,50016,600ERP-1106 Digital Information Sign 5 2,300 2,700 3,100ERP-1107 Theater Projection Screen 106,7009,000ERP-1108 Theater Presentation Microphone 6 7,100 8,500 10,200ERP-1109 Floor Scrubber 1010,80017,100 32,400 19,800 17,500 7,100 7,700 31,400 16,600 15,900 10,200 9,000COMMUNITY SERVICES - CITY CLERKERP-008 Document Mgmt. Scanner (2)411,30012,70014,30016,000ERP-010 Election Booths20ERP-011 Election Equipment10EQUIPMENT SUBTOTAL11,30012,70014,30016,000COMMUNITY SERVICES - ITERP-003 City Hall - Network Upgrade1 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000ERP-004 Phone System889,600110,700EPR-005 Financial Software7ERP-006 Computers3-5 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000ERP-009 Network Infrastructure Upgrade1523,400ERP-012 Core Network Switch617,00020,00024,000ERP-0013 Wi-Fi and Cellular5-76,0006,0006,0006,0006,0006,0006,0006,0006,0006,000ERP-014 Distribution Network Switches550,00057,000ERP-0015 Backup Server4 66,00066,00066,00066,00066,00066,000ERP-211 Police - Network Server (3)3 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000 22,000EQUIPMENT SUBTOTAL140,000 97,000 74,000 196,000 74,000 103,400 163,600 146,000 151,000 80,000 74,000 146,000 74,000 80,000 208,700 146,000 74,000 80,000 74,000 146,000FIRE ERP-100 Tele-Squirt E-210 900,0001,200,000ERP-101 Fire Pumper E-320722,400ERP-103 Duty Chief Vehicle 5ERP-105 Quick Attack Pumper/Rescue R-810 314,500422,600ERP-106 Aerial Truck L-920 54,217 54,2171,572,000VEHICLES SUBTOTAL 954,217 54,217 314,500 722,400 1,200,000 1,572,000 422,600ERP-107 Air Compressor 1554,400ERP-108 Breathing Apparatus (45) (SCBA) 10250,000336,000 336,000ERP-109 Extrication Tool (2) 10 27,400 30,00036,900 40,300ERP-112 Thermal Imaging Camera (2) 10 12,900 15,400 17,400 20,700ERP-113 Emergency Preparedness Siren 2038,500ERP-114 Floor Scrubber 1220,300ERP-215 Radios-Portable & Mobile 10-15361,000361,000 `EQUIPMENT SUBTOTAL 12,900 27,400 30,000 376,400 250,000 38,500 37,700 36,900 54,400 40,300 381,700 336,000 336,00079 REPLEQUIPMENT /VEHICLES YRS 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036POLICE ERP-200 Squad #1 #2073 49,00053,70058,70064,00070,00076,600ERP-200 Squad #2 #2083 49,00053,700 58,70064,00070,00076,600ERP-200 Squad #3 #200349,00053,70058,70064,00070,00076,500ERP-200 Squad #4 #202349,00053,700 58,70064,00070,00076,600ERP-200 Squad #5 #2053 49,00053,70058,70064,00070,00076,500ERP-200 Squad #6 #209349,00053,700 58,70064,00070,00076,600ERP-200 Squad #7 #2063 49,00053,70058,70064,00070,00076,500ERP-201 Sergeant Vehicle #2014 49,00057,00064,00072,00080,000 80,000ERP-202 Parking Vehicle #2111053,700 74,000ERP-203 PSO Utility 4x4 #212655,00067,00083,00096000ERP-205 SWAT Vehicle #2401577,900VEHICLES SUBTOTAL98,000 251,000 98,000 107,400 214,800 164,400 117,400 243,100 117,400 192,000 192,000 128,000 140,000 365,000 291,900 153,200229,700 233,000 80,000 96,000ERP-212 Squad Car Camera System765,00065,00065,000ERP-214 Tactical Ballistic Vests (9)535,00041,70048,40056,100ERP-215 Radios-Portable & Mobile7290,000290,000ERP-217 Taser Replacement429,00033,60037,80042,50047,900ERP-218 Building Video Server417,00017,00017,00017,000ERP-219 PD - Squad Video Server5115,000 10,000 10,000 10,000 10,000 115,000 10,000 10,000 10,000 10,000 115,000 10,000 10,000 10,000 10,000 115,000 10,000 10,000 10,000ERP-220 Mobile Data Computers765,00082,000101,00077,000 77,000ERP-223 Squad Care Wireless Solution5 12,000EQUIPMENT SUBTOTAL12,000 179,000 157,000 10,000 10,000 43,600 463,700 10,000 10,000 194,800 27,000 163,400 10,000 342,500 27,000 10,000 337,10057,900 87,000 87,000P.W. ADMINERP-215 Radios-Portable & Mobile P.W. BLDG./EQUIPMENT SVCSERP-710 1/2 Ton Truck1031,30042,100ERP-711 Vehicle Washer128,300 11,500ERP-712 4x4 3/4 Ton Pick-up Truck1549,800ERP-714 Scan Kit10 10,00013,80010,000 31,3008,30013,800 42,10049,80011,500P.W. ENGINEERINGERP-700 Engineering Van1028,90038,80028,90038,800P.W. PARKS & FORESTRYERP-800 1/2 Ton Truck1035,40047,600ERP-801 4x4 3/4 Ton Truck842,60054,000ERP-801 4x4 3/4 Ton Truck842,60054,000ERP-802 3/4 Ton Utility Truck1048,700ERP-804 Log Truck (50% w/Refuse)1581,800ERP-805 Aerial Lift20228,900ERP-806 Tractor30ERP-807 Truckster (#818)1517,140ERP-807 Truckster (#820)15 23,00035,800ERP-807 Truckster (#821)15 11,20017,400ERP-808 Riding Mower (#823)825,30032,100ERP-808 Riding Mower (#826)8 13,90017,700ERP-809 Slope Mower (#828) -- deleted from ERP 15ERP-810 Large Turf Mower (#825)1092,700124,600ERP-811 Turf Sweeper - deleted from ERPERP-812 Stump Cutter20 45,000ERP-813 Brush Clipper2043,700ERP-814 Trailer Flatbed1510,000ERP-815 Skid Loader12 32,00045,600ERP-816 Toolcat863,30080,200101,600ERP-817 Grass Seed Applicator2017,900VEHICLES SUBTOTAL111,200 63,300187,90081,800 49,300 25,30080,200108,000 62,740 420,100 17,700 85,300 91,300 101,60080 REPLEQUIPMENT /VEHICLES YRS 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036P.W. STREETS/TRAFFICERP-300 4x4 3/4 Ton Truck/Plow1028,90038,800ERP-301 4x4 3/4 Ton Truck/Plow838,50048,800ERP-302 4x2 1 Ton Dump Truck1254,60077,800ERP-303 1 Ton Dump Truck1249,500ERP-303 1 Ton Dump Truck1253,40076,100ERP-304 1 Ton Boom Truck17136,400ERP-305 Single Axle Dump Truck17 132,100ERP-305 Single Axle Dump Truck17ERP-305 Single Axle Dump Truck17210,600ERP-306 Tandem Dump Truck17 225,000 235,000286,000 294,000 294,000ERP-307 Water Truck22ERP-308 Front End Loader15268,000ERP-308 Front End Loader18268,600ERP-309 Skid Loader1259,700ERP-309 Skid Loader1250,00071,300ERP-310 Grader20167,300ERP-311 Sweeper20156,400ERP-312 Roller20 45,900 ERP-313 Striper12 11,20016,000ERP-314 Paver20 118,000ERP-315 Snow Blower20 160,000288,000ERP-316 Trailer20ERP-317 Sign Machine1018,100ERP-318 Asphalt Hot Mix Heating Box12 15,00021,300ERP-319 Regenerative Air Sweeper20ERP-320 Planer2018,600VEHICLES SUBTOTAL575,100 289,600 156,400132,100 103,400 297,500 88,000 167,300 18,100 268,000 81,000 363,000 77,800 18,600 48,800 38,800 433,400 294,000 582,000HRAERP-400 4x4 3/4 Ton Truck8 41,10052,100ERP-401 Copier 816,50020,900SUBTOTAL 16,500 41,10020,900 52,100PAVILIONERP-1000 Ice Resurfacer12165,000ERP-1001 Electric Ice Edger128,900ERP-1002 Arena Scoreboard2012,000ERP-1003 Floor Scrubber1011,60015,600ERP-1004 Scissor Lift1516,200SUBTOTAL 11,600185,90016,20015,600REFUSEERP-900 Refuse Truck (RAP-R)10 275,200ERP-900 Refuse Truck (RAP-R)10270,300363,200ERP-901 Refuse Truck (Rear-L)10 101,600 136,500ERP-803 Swap Loader2095,000ERP-804 Log Truck (50% w/Forestry)2081,800SUBTOTAL 101,600 95,000270,300 81,800275,200136,500363,200SEWERERP-550 4x4 3/4 Ton Truck1040,30054,200ERP-551 3/4 Ton Utility Truck1045,200ERP-552 Jet Vactor20 425,000700,000ERP-555 Generator 25 36,000ERP-555 Generator2523,000ERP-559 SCADA Upgrade10 160,000215,000SUBTOTAL 621,00023,00040,30045,200 215,00054,200WATER ERP-500 1./2 Ton Truck10 32,00043,000ERP-501 3/4 Ton Utility Truck1046,900ERP-502 Backhoe20153,700ERP-503 Air Compressor2041,700ERP-509 Water Treatment Plant 10 100,000134,300SUBTOTAL 132,000224,200 41,700153,70081 REPLEQUIPMENT /VEHICLES YRS 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036TOTALS2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2035GENERAL FUND-VEHICLES/EQUIP1,738,517 689,417 254,400 295,300 346,900 664,100 464,200 385,300 284,700 1,012,700 1,660,000 1,931,100 565,740 862,900 378,000 709,900 359,800 806,800 374,000 678,000GENERAL FUND-OTHER EQUIP174,900 276,000 273,400 217,300 84,000 185,300 1,003,700 168,700 411,000 320,000 152,500 323,700 120,900 422,500 290,100 212,300 792,800 173,400 497,000 578,000HRA 16,500 41,10020,900 52,100ARTS CENTER17,10032,400 19,80017,500 7,100 7,700 31,400 16,60015,90010,200 9,000REFUSE101,600 95,000270,300 81,800275,200136,500363,200PAVILION11,600185,90016,20015,600WATER132,000224,200 41,700153,700SEWER621,00023,00040,30045,200 215,00054,200GENERAL FUND TOTAL1,913,417 965,417 527,800 512,600 430,900 849,400 1,467,900 554,000 695,700 1,332,700 1,812,500 2,254,800 686,640 1,285,400 668,100 922,200 1,152,600 980,200 871,000 1,256,000HRA TOTAL16,500 41,10020,900 52,100ARTS CENTER FUND TOTAL17,10032,400 19,80017,500 7,100 7,700 31,400 16,60015,90010,200 9,000ENTERPRISE FUNDS TOTAL854,600 95,000270,300 104,80051,900 275,200 231,100 575,700 41,700 16,200363,200 153,70069,800TOTAL ALL FUNDS2,768,017 1,077,517 527,800 512,600 701,200 1,003,1001,528,800 605,900 988,400 1,570,900 2,395,900 2,327,900 719,440 1,306,300 1,083,400 1,091,800 1,152,600 1,060,200 880,000 1,256,000GENERAL FUND SALVAGE40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,001NET GENERAL FUND1,873,417 925,417 487,800 472,600 390,900 809,400 1,427,900 514,000 655,700 1,292,700 1,772,500 2,214,800 646,640 1,245,400 628,100 882,200 1,112,600 940,200 831,000 1,215,99920 YEAR AVERAGES:TotalAverageACTIVITY CENTER ADMINISTRATION54,700 2,700COMMUNITY SERVICES - IT2,327,700 116,400COMMUNITY SERVICES - CITY CLERK54,300 2,700FIRE EQUIPMENT1,958,200 97,900FIRE ADMINISTRATION5,239,934 262,000POLICE EQUIPMENT2,239,000 112,000POLICE ADMINISTRATION3,512,300 175,600PUBLIC WORKS ADMINISTRATIONBLDG./EQUIPMENT SERVICES EQUIPMENT166,800 8,300ENGINEERING EQUIPMENT67,700 3,400PARKS/FORESTRY EQUIPMENT1,485,740 74,300STREET EQUIPMENT4,032,900 201,600GENERAL FUND VEHICLE/EQUIPMENT9,950,340 497,500GENERAL FUND OTHER EQUIPMENT11,188,934 559,400GENERAL FUND TOTAL21,139,2741,057,000HRA FUND130,600 6,500ARTS CENTER FUND184,700 9,200REFUSE FUND1,323,600 66,200PAVILION FUND229,300 11,500WATER FUND551,600 27,600SEWER FUND998,700 49,900UTILITY VEHICLES/EQUIPMENT3,418,500 170,90024,557,774 82           EQUIPMENT AND BUILDING  INVENTORY  83 84 CITY OF HOPKINS BUILDING INVENTORY January 2016 Location/Description Replacement Cost City Hall & Police Station $7,935,297 1010 1st Street S. Fire Station 4,619,899 101 17th Avenue S. Hopkins Activity Center 2,000,869 33 14th Avenue S. Ice Arena/Pavilion 5,494,200 11000 Excelsior Boulevard Arts Center 7,526,389 1111 Mainstreet PW Admin/Garage 7,860,717 11100 Excelsior Boulevard Moline Reservoir/Well #1 2,517,401 10421 Excelsor Boulevard Blake Tower Reservior 1,519,735 151 Tyler Avenue South Filtration Plant 3,700,322 1401 Elmo Park Service Road Well #4 Workshop/Storage 585,527 1401 Elmo Park Service Road Well #5 250,465 1205 Highway7 Well #6 333,989 801 Highway 7 Lift Station #2 - Drillane 71,330 619 Drillane Road Lift Station #3 - Lindee's 142,565 901 Cambridge Street N.E. Lift Station #4 - LTL Meadowbrook 104,277 244 Meadowbrook Road Lift Station #5 - Big Meadowbrook 165,649 6601 Excelsior Blvd. Lift Station #6 - Ronnie's $104,277 8546 Excelsior Avenue E. 85 Location/Description Replacement Cost Lift Station #7 - Valley 329,431 801 6th Avenue S. Storage Facility 127,706 1401 Elmo Park Service Road Band Shell - Downtown Park 39,454 16 9th Avenue S. Concession Stand - Maetzold Field 163,369 1215 1st Street N. Park Building-Beach - Lifeguards 176,296 5200 Shady Oak Road Park Building-Beach-Concessions 166,620 5200 Shady Oak Road Park Shelter - Office/Bathhouse 404,766 5200 Shady Oak Road Park Shelter - Burnes 53,840 201 Park Lane Park Building - Central 122,233 101 17th Avenue S. Park Building - Harley 41,426 108 Jackson Avenue S. Park Shelter - Interlachen 66,202 220 Homedale Avenue Park Building - Oakes 47,236 301 Tyler Avenue N. Park Building - Valley 55,492 800 7th Avenue S. Parking Ramp 6,834,259 10th Avenue and Mainstreet Depot Coffee House 514,342 9451 Excelsior Boulevard Overpass Skate Park 8,226 100 Washington Avenue Historical Society Bldg 1,053,864 907 Mainstrre Dow Towers (76 Units) HRA 22 5th Avenue S. 86 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2016 UNIT # YEAR MAKE MODEL VALUE FIRE DEPARTMENT 102. 1989 FORD 380,000 103. 2006 PETERBILT PUMPER 420,000 104 2012 FORD QUICK ATTACK PUMPER F550 248,500 105 2015 FORD EXPLORER (RED) - LEASED 47,500 106 2015 FORD EXPLORER (RED) - LEASED 47,500 107 2015 FORD EXPLORER (BLACK) - LEASED 47,500 108 2014 FORD F-150 - LEASED 34,000 109 2008 PIERCE AERO XT 874,000 110 2010 CHEVROLET TAHOE 30,000 115. 1952 MACK PUMPER 4,000 POLICE DEPARTMENT 200. 2015 FORD EXPLORER - INTERCEPTOR $30,000 201 2014 FORD EXPLORER - INTERCEPTOR (SGT)31,000 202. 2015 FORD EXPLORER - INTERCEPTOR 31,000 205. 2016 FORD EXPLORER - INTERCEPTOR 34,000 206 2016 FORD EXPLORER - INTERCEPTOR 34,000 207. 2014 FORD EXPLORER - INTERCEPTOR 47,500 208. 2013 FORD EXPLORER - INTERCEPTOR 42,600 209. 2015 FORD EXPLORER - INTERCEPTOR 31,000 211. 2006 JEEP LIBERTY (PKG)18,800 212 2014 FORD F150 (PSO)34,000 213. 2010 CHEV IMPALA 26,000 214 2014 NISSAN MAXIMA ( LEASED VEHICLE)38,800 216. 2011 FORD TAURUS 30,000 218. 2013 FORD INTERCEPTOR SUV 40,000 219. 2013 FORD TAURUS 27,500 220 2005 DODGE RAM 1500 (PATROL)29,000 221 2015 JEEP CHEROKEE - LEASED 35,000 240. 1998 CHEV P40 VAN (SWAT)12,000 299 2014 NISSAN TITAN (DTF LEASED VEHICLE)40,300 DWI 2015 FORD UTILITY - INTERCEPTOR 40,300 87 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2016 UNIT # YEAR MAKE MODEL VALUE STREET/TRAFFIC DIVISION 301. 2013 FORD F150 $19,500 302. 2006 FORD F250 26,500 304. 2000 FORD F450 34,000 305. 1997 FORD F350 18,300 307. 2006 FORD F350-1 TON DUMP 27,400 308. 2011 FORD F350 - 2X4 20,300 309. 2012 FORD F450 30,300 311. 2011 FREIGHTLINER M2106V 79,400 312. 2005 FREIGHTLINER SGLAX DUMP 98,000 313. 2001 FORD L7501 72,000 314. 1998 FORD LT 8500 84,000 316. 1995 FORD WATER TRK 81,000 320. 1991 CATERPILLER LOADER 926E 90,000 321. 2012 CATERPILLER LOADER 924K 177,500 322. 2005 CATERPILLER LOADER 938G 157,800 324. 2004 BOBCAT SKID LOADER 32,900 325. 2011 BOBCAT SKID STEER LOADER 35,100 326. 1989 CATERPILLAR 140-G 82,000 327. 2001 ELGIN PELICAN SE 105,000 328. 2013 ISUZU STREET SWEEPER 145,300 330. 1989 INGERSOL/RAND ROLLER DD-25 15,000 337. 1994 CATERPILLAR BOX PAVER 17,000 342. 1991 TARGET CONCRETE SAW 2,400 343 2014 SNOWCRETE SNOWBLOWER - CUMMINS QSB6.7 71,500 344. 1996 SNOGO WK 800 58,000 348 2014 PJ TRAILER 20' TILT TRAILER 5,300 350. 1993 TOWMASTER T14 4,000 351. 2004 TENNANT SWEEPER 3640 10,000 ENGINEERING DIVISION 700. 2002 CHEV TAHOE $18,000 701 2008 FORD TAURUS 22,000 706 2015 FORD TRANSIT 250 VAN 24,000 707 2009 CHEV IMPALA 14,600 BUILDING MAINTENANCE & EQUIPMENT SERVICES 702. 2004 FORD F350 $18,000 703 1995 CHEV EXT CAB 4X4 36,000 704. 2005 FORD F250 18,000 88 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2016 UNIT # YEAR MAKE MODEL VALUE PARKS/FORESTRY DIVISION 800. 2013 FORD F150 $23,700 801. 2012 FORD F350 4X4 24,100 803. 2004 FORD F350 17,500 804. 1995 CHEV 1 TON BOOM 45,000 805. 1998 DODGE RAM 3500 17,100 810. 1993 INTERNATIONAL LP 4700 50,000 811. 2006 INTERNATIONAL LP 4600 LOG TRUCK 45,000 812. 2010 FREIGHTLINER AERIAL LIFT 130,000 815. 2010 BOBCAT TOOLCAT 53,000 816 2014 BOBCAT 5610 TOOLCAT 50,900 818. 1996 TORO TRUCKSTER 13,000 820. 2004 TORO WORKMAN 3200 15,000 822. 2001 TORO 325-D MOWER 18,000 823. 2006 JACOBSON MOWER 10,000 824. 1996 TORO GROUND MASTER 16,000 825. 2010 TORO 4100D MOWER 56,500 826. 2004 TORO Z587L 8,900 828. 2001 DEW EZE ATM72 21,000 832. 1997 VERMEER STUMP CTR 630A 15,400 833. 2004 BOBCAT SKID LOADER 22,000 834. 2013 VERMEER BRUSH CHIPPER 29,800 836. RYAN SOD CUTTER 2,000 843 2007 CARR TRAILER 2,500 844. 2010 FELLING TRAILER 6,000 845. 1997 REMACKEL TRAILER 3,500 846. 2001 DRESSEN 8110 2,000 847. 2011 SPARKS TILT TRAILER 4,900 HRA 411. 2007 CHEV 2500 HD $17,500 89 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2016 UNIT # YEAR MAKE MODEL VALUE WATER/SEWER 500. 2007 CHEV PICKUP $22,000 501. 2004 CHEV 4X4 3/4 T SILVERADO 19,000 502. 1999 DODGE DAKOTA 4X4 18,000 503 2015 FORD F350 38,000 505. 2007 CHEV CC25753 31,900 506. 2006 CHEV SILVERADO 20,700 507. 2001 CHRYSLER PT CRUISER 18,000 530. 2001 STERLING VAC-CON 180,000 533. 2012 CATERPILLAR 420EH2 BACKHOE 87,700 534. 1997 KOHLER GENERATOR/TRL 11,000 535. 1992 KOHLER GENERATOR/TRL 10,000 536. 1989 FLEXIBLE RODDING MACHINE 49,000 537. 2010 GENERATOR C15 144,300 REFUSE 900. 2011 FREIGHTLINER RAPID-RAIL M2 $201,109 901. 2005 PETERBILT 320 155,000 902 2015 FREIGHTLINER M2106V 232,500 903. 1995 FREIGHTLINER FL-70 50,000 PAVILION 802. 2012 FORD F350 $20,000 808 2014 ZAMBONI ICE RESURFACER $126,000 809. 2003 OLYMPIA ICE RESURFACER 87,800 90