Loading...
2016 - 2020 ERP EQUIPMENT REPLACEMENT PLAN 2016-2020 DATE: October 2015 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager 2016-2020 EQUIPMENT REPLACEMENT PLAN SUBJECT: With this letter, I respectfully submit the 2016-2020 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 EQUIPMENT REPLACEMENT PLAN 2016-2020 TABLE OF CONTENTS Page City Manager's Message 1 Table of Contents 2 Introduction Background and Summary of Changes from 2015 Plan5 Cash Flow Statements Equipment Replacement Fund 11 Five-Year Project Summaries Projects by Year15 Department Summary18 Projects by Department19 Funding Source Summary22 Projects by Funding Source23 Equipment Requests Individual Equipment Request Details Activity Center29 Arts Center30 City Hall Administration34 Community Services 41 Fire 35 IT Department50 Police56 Public Works71 Refuse94 Sewer96 Water99 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department103 Equipment and Building Inventory Building Inventory109 Vehicle and Equipment Inventory111 2 INTRODUCTION 3 4 EQUIPMENT REPLACEMENT PLAN 2016-2020 BACKGROUND AND SUMMARY OF CHANGES FROM 2015 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 and a yearly average dollar capital expenditure of $992,400. This is a 6.7% increase or $63,100 over the 2015 plan. 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 2015 by 8% after being held flat for 2013. Rates will again be increased in 2015 by 9% and 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. A $75,000 transfer from the General Fund to the Equipment Replacement Fund is planned for 2015 pending council approval. 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, infrared cameras and fitness equipment in the fire hall fitness room now are included in the ERP but the rates have not kept up with the addition of all these items. 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 2016-2020 and plan to sell Equipment Certificates in 2016 and future years to fund some of the equipment scheduled for 2016-2020. 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 2.8% of total general fund expenditures. 5 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 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 2015 Plan Highlights of changes from last year’s equipment replacement plan for the years 2016-2020: Activity Center: Floor scrubber was added for 2016. The current scrubber has exceeded its useful life. Arts Center: Video camera updates for $3,700 added in 2015 have been pushed back to 2016. Community Services: No changes Fire: The SCBA’s (Self Contained Breathing Apparatus) originally scheduled for 2016 were purchased in 2015 with grant funds received. Mobile and portable radios were moved from 2017 to 2016 and with more accurate pricing the cost increased by $57,575 to $294,075. The current radios will not be supported by Hennepin County in 2017 and need to be replaced prior to that date to maintain vital communication with the various public safety entities. A commercial grade washing machine and dryer were added in 2018 at a cost of $8,500 and $4,500 respectively. Both items came over from the old fire station and are used to wash and dry the turnout gear. Both are at the end of their life expectancy and need to be replaced. They were not previously in the ERP. The cost to outfit the leased vehicles has been reduced by $5,000 in 2017 and 2019 to more accurately reflect the cost of outfitting the leased vehicles and to remove the vehicle paid for with HazMat funds. IT: Wi-Fi and cellular technology was added in 2016, 2018 and 2020 at $6,000 each of those years. 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. Core Network Switch originally budgeted at $12,000 has been increased to $17,000 as the device is more expensive than originally thought based on 2015 estimates. Distribution Network Switches was added to the budget in 2020 at a cost of $50,000. We have 25 network switches in our enterprise environment that connect to the core switches and bring data to the 6 actual endpoints such as desktops, servers, telephones and copiers. 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. HRA No changes. Pavilion: No changes Parking: No changes. Police: Mobile and portable radios were moved from 2017 to 2016 and with more accurate pricing the cost decreased by $61,600 to $236,300. The current radios will not be supported by Hennepin County in 2017 and need to be replaced prior to that date to maintain vital communication with the various public safety entities. The cost to replace the parking enforcement vehicle scheduled for 2016 was increased by $5,200 to $36,500 to more accurately account for outfitting the vehicle. The current vehicle is a 2006 Jeep Liberty. A Squad Video Server was added for replacement in 2019 at a cost of $15,000. This video server is used to store evidentiary squad video and audio that is kept for one year. In the future body camera storage will be added. Data 911 Computers were added for replacement in 2020 at a cost of $50,000. This is the mobile and video system for patrol vehicles, In order to keep technology up to date and verify that the technology stays compliant with current and new security requirements for criminal justice data. Public Works: The lives of the equipment are annually reviewed by the public works department and have been adjusted to closely reflect the useful life expected of the equipment so that realistic replacement of equipment can be planned. Engineering No changes Building/Equipment Services A 4x4 ¾ ton truck was added for the maintenance staff. This vehicle will be used for light hauling and transportation for the maintenance supervisor. Parks/Forestry 7 A slope mower originally scheduled for 2016 at a cost of $32,700 has been eliminated. A turf sweeper originally scheduled for 2018 at a cost of $18,000 has been eliminated. A 4x4 ¾ ton truck originally scheduled for 2014 and not purchased “fell” off the ERP and has been reinstated for 2016. The current vehicle is a 1998 Dodge Ram truck. Streets/Traffic The water truck originally scheduled for 2017 at a cost of $150,000 was moved up to 2016 due to condition of the vehicle. In addition parts are no longer available to repair the vehicle. Current vehicle is a 1995 Ford truck. A planer was added in 2016 at a cost of $12,000. This item will be used by the street department for pavement repairs and can be used on any of the bobcat equipment. The roller originally scheduled for 2016 at a cost of $45,900 was moved back to 2017. A single axel dump truck originally scheduled for replacement in 2018 at a cost of $173,200 was changed to a tandem dump truck, moved to 2017 and the cost increased to $180,000 due to the change in vehicle type. The asphalt paver originally scheduled for replacement in 2016 at $48,800 was moved back to 2018. The sweeper originally scheduled for replacement in 2021 at a cost of $156,400 was moved up to 2019 Refuse A rear loading refuse truck scheduled for replacement in 2016 at a cost of $101,600 has been moved back to 2017. Sewer No changes Water ¾ ton Utility truck originally scheduled for 2017 was moved up to 2016. Current vehicle is a 2006 Chev Pick-up. 8 CASH FLOW STATEMENTS 9 10 EQUIPMENT REPLACEMENT FUND (602)10/7/2015 ate Chane 8%9%9%9%9%9%6% Rg ACTUALBUDGETBUDGETBUDGETBUDGETBUDGETBUDGET 2014201520162017201820192020 Working Capital Begin Yea726,16034,1062,057659,614 r 538,514 149,729 2 11,967 Revenues from charges 343,792560,704 376,900 408,459 445,220 485,290 5 28,966 Tax Levy per FMP360,708493,240 4 37,549 Transfer in General Fund75,00035,000 50,000 Transfer In - Pavilion - Hockey Loan3,068 Interest earnings8,538 5,535 1,647 491 1 70 2 ,270 6,746 Net Incr (Decr) in FV of Investments- Other revenues (sale of assets)27,23535,000 30,000 30,000 30,000 30,000 35,000 Equipment Certificates (Bonds)800,000200,000 850,000 350,000 2 50,000 Transfers In (Misc) Total Revenues382,6331,295,690 487,435 1,290,106 1,360,711 1,226,169 1 ,253,785 Expenditures (excludes Leases & Depr.) 176,113210,288 181,396 186,838 192,443 198,217 2 04,163 Fire Truck Financing Pymnts (2009-2018)53,82154,217 5 4,217 5 4,217 5 4,217 Capital Outlay - Equipment340,345556,900 6 40,607 1 ,164,675 1 ,146,100 6 40,450 4 78,600 Transfer Out Total Expenses570,279890,563 8 76,220 1 ,405,730 1 ,392,760 1 ,016,258 8 06,138 Working Capital Ending Balance538,51434,1062,0571,064,741 1 49,729 2 11,967 6 59,614 (cash + receivables - payables) Actual/Estimated Cash balances553,502164,49,09417,04226,951,079,729 55 717 674,602 11 12 FIVE-YEAR PROJECT SUMMARIES 13 14 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20162020 thru PROJECTS BY YEAR Project NameProject #Priority Project Cost Department 2016 Activity Center - Floor ScrubberActivity Center01-ERP-0035n/a5,000 Art Center Video Camera UpdatesArts Centern/a3,700 01-ERP-1103 Document Management Scanner (2)Community Servicesn/a10,000 01-ERP-0008 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a19,606 01-ERP-0103a Aerial TruckFiren/a54,217 01-ERP-0106 Air CompressorFiren/a34,900 01-ERP-0107 Fire Radios - Portable and Mobile DevicesFiren/a294,075 01-ERP-0125 CH - Network ServerIT01-ERP-0003n/a15,000 ComputersIT01-ERP-0006n/a30,000 Wi-Fi and CellularIT01-ERP-0013n/a6,000 PD - Network Server (3)IT01-ERP-0211n/a15,000 Marked Patrol Vehicles (6)Police01-ERP-0200n/a90,000 Parking Enforcement Vehicle (Parking Fund)Police01-ERP-0202n/a36,500 Police Administrative Vehicles (2)Police01-ERP-0204n/a16,794 Police Admin Cars - outfit leased vehiclesPolice01-ERP-0204an/a5,000 SWAT VehiclePolicen/a50,000 01-ERP-0205 Drug Task Force VehiclePolicen/a11,074 01-ERP-0206 Drug Task Force Vehicle - outfit leased vehiclePolicen/a5,000 01-ERP-0206a Police - Portable RadiosPolicen/a236,300 01-ERP-0215 PW - 4x4 3/4 Ton Pick-up TruckPublic Works: Bldg/Equip Servn/a32,000 01-ERP-0712 3/4 Ton Utility TruckPublic Works: Parks/Forestryn/a32,200 01-ERP-0802 Riding Mowers (2)Public Works: Parks/Forestry01-ERP-0808n/a20,000 4X4 3/4 Ton Truck with PlowPublic Works: Streets/Traffic01-ERP-0301n/a30,400 Water TruckPublic Works: Streets/Traffic01-ERP-0307n/a150,000 Skid Loader (2)Public Works: Streets/Traffic01-ERP-0309n/a41,900 Sign Machine (Traffic)Public Works: Streets/Traffic01-ERP-0317n/a13,400 PW - PlanerPublic Works: Streets/Traffic01-ERP-0320n/a12,000 3/4 Ton Utility TruckSewer01-ERP-0551n/a33,600 3/4 Ton Utility TruckWater01-ERP-0501n/a35,000 1,338,666 Total for 2016 2017 Tele-Squirt (Engine 2)Firen/a650,000 01-ERP-0100 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a32,707 01-ERP-0103a Outfit Duty Chief Leased Vehicles (5)Firen/a5,000 01-ERP-0103b Aerial TruckFiren/a54,217 01-ERP-0106 Thermal Imaging Camera (2)Fire01-ERP-0112n/a12,900 Workout Equipment - Treadmill #2Fire01-ERP-0118n/a5,800 Workout Equipment - Dumb BellsFire01-ERP-0122n/a5,000 CH - Network ServerIT01-ERP-0003n/a15,000 ComputersIT01-ERP-0006n/a30,000 PD - Network Server (3)IT01-ERP-0211n/a15,000 Marked Patrol Vehicles (6)Police01-ERP-0200n/a98,000 Police Administrative Vehicles (2)Policen/a21,999 01-ERP-0204 Wednesday, October 14, 2015 15 Project NameProject #Priority Project Cost Department Police Admin Cars - outfit leased vehiclesPolice01-ERP-0204an/a5,000 Drug Task Force VehiclePolicen/a11,074 01-ERP-0206 Taser ReplacementPolice320,900 01-ERP-0217 Stump CutterPublic Works: Parks/Forestryn/a21,200 01-ERP-0812 Skid LoaderPublic Works: Parks/Forestryn/a32,000 01-ERP-0815 Tandem Dump Truck (2)Public Works: Streets/Trafficn/a173,200 01-ERP-0306 PW - RollerPublic Works: Streets/Trafficn/a45,900 01-ERP-0312 StriperPublic Works: Streets/Traffic01-ERP-0313n/a11,200 Refuse Truck (Rear-L)Refuse01-ERP-0901n/a101,600 Generator (2)Sewer01-ERP-0555n/a26,400 1/2 Ton TruckWater01-ERP-0500n/a26,800 1,420,897 Total for 2017 2018 Art Center Theater ProjectorArts Center01-ERP-1104n/a17,100 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a32,707 01-ERP-0103a Aerial TruckFiren/a54,217 01-ERP-0106 Automated External Defibrillator (2)Firen/a7,800 01-ERP-0120 Fire - Washing MachineFiren/a8,500 01-ERP-0123 Fire - DryerFiren/a4,500 01-ERP-0124 CH - Network ServerITn/a15,000 01-ERP-0003 ComputersIT01-ERP-0006n/a30,000 Core Network SwitchIT01-ERP-0012n/a17,000 Wi-Fi and CellularIT01-ERP-0013n/a6,000 PD - Network Server (3)IT01-ERP-0211n/a15,000 Marked Patrol Vehicles (6)Police01-ERP-0200n/a98,000 Police Administrative Vehicles (2)Police01-ERP-0204n/a22,655 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 01-ERP-0204a Drug Task Force VehiclePolicen/a11,740 01-ERP-0206 Drug Task Force Vehicle - outfit leased vehiclePolicen/a5,000 01-ERP-0206a Tactical Ballistic VestsPolicen/a26,900 01-ERP-0214 4X4 1/2 Ton TruckPublic Works: Bldg/Equip Servn/a31,300 01-ERP-0710 ToolcatPublic Works: Parks/Forestryn/a63,300 01-ERP-0816 4x2 1 Ton Dump TruckPublic Works: Streets/Trafficn/a54,600 01-ERP-0302 Tandem Dump Truck (2)Public Works: Streets/Traffic01-ERP-0306n/a180,000 PW - Asphalt PaverPublic Works: Streets/Traffic01-ERP-0314n/a48,800 Swap LoaderRefuse01-ERP-0803n/a95,000 850,119 Total for 2018 2019 Fire/Duty Chief & Utility Leased Vehicles (5)Fire01-ERP-0103an/a32,707 Outfit Duty Chief Leased Vehicles (5)Firen/a15,000 01-ERP-0103b Extrication Tool (2)Firen/a27,400 01-ERP-0109 CH - Network ServerITn/a15,000 01-ERP-0003 ComputersITn/a30,000 01-ERP-0006 PD - Network Server (3)ITn/a15,000 01-ERP-0211 Marked Patrol Vehicles (6)Policen/a98,000 01-ERP-0200 Sergeant's VehiclePolice01-ERP-0201n/a50,600 Police Administrative Vehicles (2)Police01-ERP-0204n/a23,329 Police Admin Cars - outfit leased vehiclesPolice01-ERP-0204an/a5,000 Drug Task Force VehiclePolice01-ERP-0206n/a11,740 Building Video ServerPolice01-ERP-0218n/a17,000 PD - Squad Video ServerPolice01-ERP-0219n/a15,000 Trucksters (3)Public Works: Parks/Forestry01-ERP-0807n/a34,200 SweeperPublic Works: Streets/Trafficn/a156,400 01-ERP-0311 Wednesday, October 14, 2015 16 Project NameProject #Priority Project Cost Department 546,376 Total for 2019 2020 Art Center Digital Information SignArts Center22,300 01-ERP-1106 Art Center Theater Presentation MicrophonesArts Center17,100 01-ERP-1108 Document Management Scanner (2)Community Servicesn/a11,300 01-ERP-0008 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a32,707 01-ERP-0103a Workout Equipment - Treadmill #1Fire01-ERP-0117n/a6,700 Workout Equipment - Weight LiftingFire01-ERP-0119n/a6,700 CH - Network ServerIT01-ERP-0003n/a15,000 ComputersIT01-ERP-0006n/a30,000 Wi-Fi and CellularIT01-ERP-0013n/a6,000 Distribution Network SwitchesIT01-ERP-014n/a50,000 PD - Network Server (3)ITn/a15,000 01-ERP-0211 Marked Patrol Vehicles (6)Policen/a107,400 01-ERP-0200 PSO - Utility 4x4 (unit 212)Policen/a60,400 01-ERP-0203 Police Administrative Vehicles (2)Policen/a24,029 01-ERP-0204 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 01-ERP-0204a Drug Task Force VehiclePolicen/a12,460 01-ERP-0206 Drug Task Force Vehicle - outfit leased vehiclePolice01-ERP-0206an/a5,000 Data 911 ComputersPolice01-ERP-0220n/a50,000 Hot Water High Pressure Vehicle WasherPublic Works: Bldg/Equip Serv01-ERP-0711n/a8,300 4x4 3/4Ton Trucks (2)Public Works: Parks/Forestry01-ERP-0801n/a85,200 Large Turf MowerPublic Works: Parks/Forestry01-ERP-0810n/a92,700 Trailer FlatbedPublic Works: Parks/Forestry01-ERP-0814n/a2,200 Jet VactorSewer01-ERP-0552n/a350,000 985,496 Total for 2020 5,141,554 GRAND TOTAL Wednesday, October 14, 2015 17 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20162020 thru DEPARTMENT SUMMARY Department20162017201820192020Total Activity Center5,0005,000 Arts Center3,70017,1009,400 30,200 Community Services10,00011,300 21,300 Fire402,798765,624107,72475,10746,107 1,397,360 IT66,00060,00083,00060,000116,000 385,000 Police450,668156,973169,295220,669264,2891,261,894 Public Works: Bldg/Equip Serv32,00031,3008,30071,600 Public Works: Parks/Forestry52,20053,20063,30034,200180,100383,000 Public Works: Streets/Traffic247,700230,300283,400156,400 917,800 Refuse101,60095,000 196,600 Sewer33,60026,400350,000 410,000 Water35,00026,80061,800 1,338,6661,420,897850,119546,376985,496 TOTAL 5,141,554 18 Wednesday, October 14, 2015 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20162020 thru PROJECTS BY DEPARTMENT DepartmentProject#Priority20162017201820192020 Total Activity Center Activity Center - Floor Scrubbern/a01-ERP-00355,0005,000 5,0005,000 Activity Center Total Arts Center Art Center Video Camera Updatesn/a3,700 01-ERP-11033,700 Art Center Theater Projectorn/a17,100 01-ERP-110417,100 Art Center Digital Information Sign22,300 01-ERP-11062,300 Art Center Theater Presentation Microphones17,100 01-ERP-11087,100 30,200 3,70017,1009,400 Arts Center Total Community Services Document Management Scanner (2)n/a01-ERP-000810,00011,30021,300 21,300 10,00011,300 Community Services Total Fire Tele-Squirt (Engine 2)n/a650,000 01-ERP-0100650,000 Fire/Duty Chief & Utility Leased Vehicles (5)n/a19,60632,70732,70732,70732,707 01-ERP-0103a150,434 Outfit Duty Chief Leased Vehicles (5)n/a5,00015,000 01-ERP-0103b20,000 Aerial Truckn/a54,21754,21754,217 01-ERP-0106162,651 Air Compressor01-ERP-0107n/a34,90034,900 Extrication Tool (2)01-ERP-0109n/a27,40027,400 Thermal Imaging Camera (2)01-ERP-0112n/a12,90012,900 Workout Equipment - Treadmill #101-ERP-0117n/a6,7006,700 Workout Equipment - Treadmill #201-ERP-0118n/a5,8005,800 Workout Equipment - Weight Lifting01-ERP-0119n/a6,7006,700 Automated External Defibrillator (2)01-ERP-0120n/a7,8007,800 Workout Equipment - Dumb Bellsn/a5,000 01-ERP-01225,000 Fire - Washing Machinen/a8,500 01-ERP-01238,500 Fire - Dryern/a4,500 01-ERP-01244,500 Fire Radios - Portable and Mobile Devicesn/a294,075 01-ERP-0125294,075 402,798765,624107,72475,10746,1071,397,360 Fire Total IT CH - Network Servern/a01-ERP-000315,00015,00015,00015,00015,00075,000 Computersn/a01-ERP-000630,00030,00030,00030,00030,000150,000 Core Network Switchn/a01-ERP-001217,00017,000 Wi-Fi and Cellularn/a01-ERP-00136,0006,0006,00018,000 Distribution Network Switchesn/a01-ERP-01450,00050,000 PD - Network Server (3)n/a01-ERP-021115,00015,00015,00015,00015,00075,000 66,00060,00083,00060,000116,000385,000 IT Total 19 Wednesday, October 14, 2015 DepartmentProject#Priority20162017201820192020 Total Police Marked Patrol Vehicles (6)n/a90,00098,00098,00098,000107,400 01-ERP-0200491,400 Sergeant's Vehiclen/a50,600 01-ERP-020150,600 Parking Enforcement Vehicle (Parking Fund)n/a36,500 01-ERP-020236,500 PSO - Utility 4x4 (unit 212)n/a60,400 01-ERP-020360,400 Police Administrative Vehicles (2)01-ERP-0204n/a16,79421,99922,65523,32924,029108,806 Police Admin Cars - outfit leased vehicles01-ERP-0204an/a5,0005,0005,0005,0005,00025,000 SWAT Vehicle01-ERP-0205n/a50,00050,000 Drug Task Force Vehicle01-ERP-0206n/a11,07411,07411,74011,74012,46058,088 Drug Task Force Vehicle - outfit leased vehicle01-ERP-0206an/a5,0005,0005,00015,000 Tactical Ballistic Vests01-ERP-0214n/a26,90026,900 Police - Portable Radios01-ERP-0215n/a236,300236,300 Taser Replacement320,900 01-ERP-021720,900 Building Video Servern/a17,000 01-ERP-021817,000 PD - Squad Video Servern/a15,000 01-ERP-021915,000 Data 911 Computersn/a50,000 01-ERP-022050,000 450,668156,973169,295220,669264,2891,261,894 Police Total Public Works: Bldg/Equip Serv 4X4 1/2 Ton Truckn/a01-ERP-071031,30031,300 Hot Water High Pressure Vehicle Washern/a01-ERP-07118,3008,300 PW - 4x4 3/4 Ton Pick-up Truckn/a01-ERP-071232,00032,000 71,600 32,00031,3008,300 Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry 4x4 3/4Ton Trucks (2)n/a01-ERP-080185,20085,200 3/4 Ton Utility Truckn/a32,200 01-ERP-080232,200 Trucksters (3)n/a34,200 01-ERP-080734,200 Riding Mowers (2)n/a20,000 01-ERP-080820,000 Large Turf Mowern/a92,700 01-ERP-081092,700 Stump Cuttern/a21,200 01-ERP-081221,200 Trailer Flatbedn/a2,200 01-ERP-08142,200 Skid Loader01-ERP-0815n/a32,00032,000 Toolcat01-ERP-0816n/a63,30063,300 52,20053,20063,30034,200180,100383,000 Public Works: Parks/Forestry Total Public Works: Streets/Traffic 4X4 3/4 Ton Truck with Plown/a01-ERP-030130,40030,400 4x2 1 Ton Dump Truckn/a54,600 01-ERP-030254,600 Tandem Dump Truck (2)n/a173,200180,000 01-ERP-0306353,200 Water Truckn/a150,000 01-ERP-0307150,000 Skid Loader (2)n/a41,900 01-ERP-030941,900 Sweepern/a156,400 01-ERP-0311156,400 PW - Rollern/a45,900 01-ERP-031245,900 Striper01-ERP-0313n/a11,20011,200 PW - Asphalt Paver01-ERP-0314n/a48,80048,800 Sign Machine (Traffic)01-ERP-0317n/a13,40013,400 PW - Planer01-ERP-0320n/a12,00012,000 917,800 247,700230,300283,400156,400 Public Works: Streets/Traffic Total Refuse Swap Loadern/a01-ERP-080395,00095,000 20 Wednesday, October 14, 2015 DepartmentProject#Priority20162017201820192020 Total Refuse Truck (Rear-L)n/a01-ERP-0901101,600101,600 196,600 101,60095,000 Refuse Total Sewer 3/4 Ton Utility Truckn/a01-ERP-055133,60033,600 Jet Vactorn/a350,000 01-ERP-0552350,000 Generator (2)n/a26,400 01-ERP-055526,400 33,60026,400350,000410,000 Sewer Total Water 1/2 Ton Truckn/a26,800 01-ERP-050026,800 3/4 Ton Utility Truck01-ERP-0501n/a35,00035,000 61,800 35,00026,800 Water Total 1,338,6661,420,897850,119546,376985,4965,141,554 GRAND TOTAL 21 Wednesday, October 14, 2015 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20162020 thru FUNDING SOURCE SUMMARY 20162017201820192020Total Source AC - Arts Center Fund3,70017,1009,40030,200 Bonds/Lease54,21754,21754,217 162,651 Equipment Replacement Fund1,212,1491,205,320700,992539,816619,5364,277,813 GU - Other Governmental Units6,5606,5606,5606,560 26,240 RF - Refuse Fund101,60071,250172,850 SF - Sanitary Sewer Fund33,60026,400350,000410,000 WF - Water Fund35,00026,800 61,800 1,338,6661,420,897850,119546,376985,496 GRAND TOTAL 5,141,554 Wednesday, October 14, 2015 22 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20162020 thru PROJECTS BY FUNDING SOURCE SourceProject#Priority20162017201820192020Total AC - Arts Center Fund Art Center Video Camera Updatesn/a3,700 01-ERP-11033,700 Art Center Theater Projectorn/a01-ERP-110417,10017,100 Art Center Digital Information Sign01-ERP-110622,3002,300 Art Center Theater Presentation Microphones01-ERP-110817,1007,100 30,200 3,70017,1009,400 AC - Arts Center Fund Total Bonds/Lease Aerial Truckn/a01-ERP-010654,21754,21754,217162,651 54,21754,21754,217162,651 Bonds/Lease Total Equipment Replacement Fund CH - Network Servern/a01-ERP-000315,00015,00015,00015,00015,00075,000 Computersn/a01-ERP-000630,00030,00030,00030,00030,000150,000 Document Management Scanner (2)01-ERP-0008n/a10,00011,30021,300 Core Network Switch01-ERP-0012n/a17,00017,000 Wi-Fi and Cellular01-ERP-0013n/a6,0006,0006,00018,000 Activity Center - Floor Scrubber01-ERP-0035n/a5,0005,000 Tele-Squirt (Engine 2)01-ERP-0100n/a650,000650,000 Fire/Duty Chief & Utility Leased Vehicles (5)01-ERP-0103an/a19,60626,14726,14726,14726,147124,194 Outfit Duty Chief Leased Vehicles (5)n/a5,00015,000 01-ERP-0103b20,000 Air Compressorn/a34,900 01-ERP-010734,900 Extrication Tool (2)n/a27,400 01-ERP-010927,400 Thermal Imaging Camera (2)n/a12,900 01-ERP-011212,900 Workout Equipment - Treadmill #1n/a6,700 01-ERP-01176,700 Workout Equipment - Treadmill #2n/a5,800 01-ERP-01185,800 Workout Equipment - Weight Lifting01-ERP-0119n/a6,7006,700 Automated External Defibrillator (2)01-ERP-0120n/a7,8007,800 Workout Equipment - Dumb Bells01-ERP-0122n/a5,0005,000 Fire - Washing Machine01-ERP-0123n/a8,5008,500 Fire - Dryer01-ERP-0124n/a4,5004,500 Fire Radios - Portable and Mobile Devices01-ERP-0125n/a294,075294,075 Distribution Network Switches01-ERP-014n/a50,00050,000 Marked Patrol Vehicles (6)01-ERP-0200n/a90,00098,00098,00098,000107,400491,400 Sergeant's Vehiclen/a50,600 01-ERP-020150,600 Parking Enforcement Vehicle (Parking Fund)n/a36,500 01-ERP-020236,500 PSO - Utility 4x4 (unit 212)n/a60,400 01-ERP-020360,400 Police Administrative Vehicles (2)n/a16,79421,99922,65523,32924,029 01-ERP-0204108,806 Police Admin Cars - outfit leased vehiclesn/a5,0005,0005,0005,0005,000 01-ERP-0204a25,000 SWAT Vehiclen/a50,000 01-ERP-020550,000 Drug Task Force Vehiclen/a11,07411,07411,74011,74012,460 01-ERP-020658,088 Drug Task Force Vehicle - outfit leased vehicle01-ERP-0206an/a5,0005,0005,00015,000 Wednesday, October 14, 2015 23 SourceProect#Priorit20162017201820192020Total jy PD - Network Server (3)n/a01-ERP-021115,00015,00015,00015,00015,00075,000 Tactical Ballistic Vestsn/a26,900 01-ERP-021426,900 Police - Portable Radiosn/a236,300 01-ERP-0215236,300 Taser Replacement320,900 01-ERP-021720,900 Building Video Servern/a17,000 01-ERP-021817,000 PD - Squad Video Servern/a15,000 01-ERP-021915,000 Data 911 Computersn/a50,000 01-ERP-022050,000 4X4 3/4 Ton Truck with Plow01-ERP-0301n/a30,40030,400 4x2 1 Ton Dump Truck01-ERP-0302n/a54,60054,600 Tandem Dump Truck (2)01-ERP-0306n/a173,200180,000353,200 Water Truck01-ERP-0307n/a150,000150,000 Skid Loader (2)01-ERP-0309n/a41,90041,900 Sweeper01-ERP-0311n/a156,400156,400 PW - Rollern/a45,900 01-ERP-031245,900 Stripern/a11,200 01-ERP-031311,200 PW - Asphalt Pavern/a48,800 01-ERP-031448,800 Sign Machine (Traffic)n/a13,400 01-ERP-031713,400 PW - Planern/a12,000 01-ERP-032012,000 4X4 1/2 Ton Truckn/a31,300 01-ERP-071031,300 Hot Water High Pressure Vehicle Washern/a8,300 01-ERP-07118,300 PW - 4x4 3/4 Ton Pick-up Truck01-ERP-0712n/a32,00032,000 4x4 3/4Ton Trucks (2)01-ERP-0801n/a85,20085,200 3/4 Ton Utility Truck01-ERP-0802n/a32,20032,200 Swap Loader01-ERP-0803n/a23,75023,750 Trucksters (3)01-ERP-0807n/a34,20034,200 Riding Mowers (2)01-ERP-0808n/a20,00020,000 Large Turf Mower01-ERP-0810n/a92,70092,700 Stump Cutter01-ERP-0812n/a21,20021,200 Trailer Flatbed01-ERP-0814n/a2,2002,200 Skid Loadern/a32,000 01-ERP-081532,000 Toolcatn/a63,300 01-ERP-081663,300 1,212,1491,205,320700,992539,816619,5364,277,813 Equipment Replacement Fund Total GU - Other Governmental Units Fire/Duty Chief & Utility Leased Vehicles (5)n/a01-ERP-0103a6,5606,5606,5606,56026,240 26,240 6,5606,5606,5606,560 GU - Other Governmental Units Total RF - Refuse Fund Swap Loadern/a01-ERP-080371,25071,250 Refuse Truck (Rear-L)n/a101,600 01-ERP-0901101,600 101,60071,250172,850 RF - Refuse Fund Total SF - Sanitary Sewer Fund 3/4 Ton Utility Truckn/a01-ERP-055133,60033,600 Jet Vactor01-ERP-0552n/a350,000350,000 Generator (2)01-ERP-0555n/a26,40026,400 410,000 33,60026,400350,000 SF - Sanitary Sewer Fund Total WF - Water Fund Wednesday, October 14, 2015 24 SourceProect#Priorit20162017201820192020Total jy 1/2 Ton Truckn/a01-ERP-050026,80026,800 3/4 Ton Utility Truckn/a35,000 01-ERP-050135,000 35,00026,80061,800 WF - Water Fund Total 1,338,6661,420,897850,119546,376985,4965,141,554 GRAND TOTAL Wednesday, October 14, 2015 25 26 EQUIPMENT REQUESTS 27 28 EQUIPMENT REPLACEMENT PLAN 20162020 thru Department Activity Center Cit of HokinsMN yp, ContactBldg/Equip Supt Type Equipment 01-ERP-0035 Project # Useful Life 10 years Activity Center - Floor Scrubber Project Name Category Equipment FuturePriorityn/a Description Floor scrubbed is used to clean tiled floors at the Activity Center Justification Floor scrubber has been used to the extent of it's useful life. ExpendituresTotalFuture 20162017201820192020 Equipment 5,0005,000 15,700 5,0005,000 TotalTotal Funding Sources20162017201820192020TotalFuture 5,0005,000 Equipment Replacement Fund 15,700 5,0005,000 TotalTotal Budget Impact/Other New item for 2016 Wednesday, October 14, 2015 29 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Director Type Equipment 01-ERP-1103 Project # Useful Life 5 years Art Center Video Camera Updates Project Name Category Equipment FuturePriorityn/a Description Replace the front entry camera with a better resolution camera. Relocate existing to above the display cabinet in the lobby. Add additional camera to the gallery, left of door to capture shot of faces of those exiting. Add a camera to the back hallway of the second floor. Justification There was an item taken from a display case in 2011 and existing cameras did not provide clear angle and view of the culprit. Also, addition of a camera in the back hallway may reduce tendency of youth to hang out in that area and engage in inappropriate behavior. PriorExpendituresTotal 20162017201820192020Future Equipment 3,7003,700 3,20015,100 3,7003,700 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 3,7003,700 3,200 AC - Arts Center Fund 15,100 3,7003,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move up from 2017 to 2015. In 2015 - move back to 2016. Estimate salvage/resale value on replaced item: $-0- Wednesday, October 14, 2015 30 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Director Type Equipment 01-ERP-1104 Project # Useful Life 5 years Art Center Theater Projector Project Name Category Equipment FuturePriorityn/a 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). 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 PriorExpenditures20162017201820192020TotalFuture Equipment 17,10017,100 15,20042,700 17,10017,100 TotalTotalTotal PriorFunding Sources20162017201820192020Total Future 17,10017,100 15,200 AC - Arts Center Fund 42,700 17,10017,100 TotalTotalTotal 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. Wednesday, October 14, 2015 31 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Co-Director Type Equipment 01-ERP-1106 Project # Useful Life 5 years Art Center Digital Information Sign Project Name Category Equipment FuturePriority2 Very Important Description Add programmable and highly visible digital sign to information desk area. (Viewsonic 42" with integrated media, software - or similar) Justification Current system of posting printed schedules and key information each day is overlooked by visitors and difficult to update rapidly. PriorExpendituresTotal 20162017201820192020Future Equipment 2,3002,300 2,0005,800 2,3002,300 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 2,3002,300 2,000 AC - Arts Center Fund 5,800 2,3002,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New Item Estimated salvage/resale value $0 Wednesday, October 14, 2015 32 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentArts Center Cit of Hokins MN yp, Contact Type Equipment 01-ERP-1108 Project # Useful Life 6 years Art Center Theater Presentation Microphones Project Name Category Equipment FuturePriority1 Urgent Description Replace theater lapel (3) and hand held (3) microphones with supporting transmitters, receivers, splitter kit and rack mount kit. Justification Current microphones are of insufficient quality to work well in a space as large as the theater resulting in technical glitches during presentations. These are necessary for Center functions, City functions and rental events in the theater. PriorExpendituresTotal 20162017201820192020Future Equipment 7,1007,100 6,00018,700 7,1007,100 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 7,1007,100 6,000 AC - Arts Center Fund 18,700 7,1007,100 TotalTotalTotal Budget Impact/Other Variance from 20-year plan: New item. Wednesday, October 14, 2015 33 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentCommunity Services Cit of Hokins MN yp, Contact City Clerk Type Equipment 01-ERP-0008 Project # Useful Life 4 years Document Management Scanner (2) Project Name Category Equipment FuturePriorityn/a 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 Justification Scanners are needed for converting paper copies to electronic data to reduce storage space. PriorExpendituresTotal 20162017201820192020Future Equipment 10,00011,30021,300 23,30043,000 10,00011,30021,300 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 10,00011,30021,300 23,300 Equipment Replacement Fund 43,000 10,00011,30021,300 TotalTotalTotal 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 Wednesday, October 14, 2015 34 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0100 Project # Useful Life 10 years Tele-Squirt (Engine 2) Project Name Category Vehicles FuturePriorityn/a Description Fire engine: full size response truck Current vehicle: 1989 Ford L9000 Tele-Squirt (#102) 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. ExpendituresTotalFuture 20162017201820192020 Equipment 650,000650,000 873,500 650,000650,000 TotalTotal Funding Sources20162017201820192020TotalFuture 650,000650,000 Equipment Replacement Fund 873,500 650,000650,000 TotalTotal 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: $ Wednesday, October 14, 2015 35 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0103a Project # Useful Life 4 years Fire/Duty Chief & Utility Leased Vehicles (5) Project Name Category Vehicles FuturePriorityn/a Description Proposal to switch from owned to leased utility and squad vehicles for fire department use. - 4 year leases on each vehicle 2015 - Ford F150 - General Use ($6,486 annual) 2015 - Ford Explorer - two to be used by two duty chiefs ($6,560 annual each) one replaced vehicle used by Sandon that belongs to the City of Edina one will replace the Chevy Impala currently used 2017 - Ford Explorer - two to be used by Fire Chief & Asst Fire Chief ($6,560 annual each) Current vehicle - 2006 Durango used by HazMat and paid with State HazMat funds Current vehicle - 2010 Chevy Tahoe used by Fire Chief Also need to budget for outfitting the vehicles - $5,000 each Justification Our current fleet of vehicles is becoming aged and is in need of replacement over the next couple of years. This replacement is scheduled into the current ERP but at a rate that will not allow us to replace vehicles in a timely manner and will continue to keep older and maintenance intensive vehicles in the fleet. The department’s current vehicle replacement structure means vehicles are kept in the department for 10+ years. Keeping the vehicles for this extended period of time greatly increased the cost of maintenance and often requires much more costly maintenance procedures. By switching to a leasing program this will ensure that vehicles are replaced at 4 years allowing us to avoid the costly repairs associated with these older vehicles. Maintenance is also built into this program, at a substantial savings over our current expenditures. Engaging in a leasing program is by far the most cost effective way to accomplish the goal of fleet replacement. PriorExpenditures20162017201820192020TotalFuture 19,60632,70732,70732,70732,707150,434 19,606 Vehicles 490,605 19,60632,70732,70732,70732,707150,434 TotalTotalTotal PriorFunding SourcesTotal 20162017201820192020Future 19,60626,14726,14726,14726,147124,194 Equipment Replacement Fund 19,606490,605 6,5606,5606,5606,56026,240 GU - Other Governmental TotalTotal Units 19,60632,70732,70732,70732,707150,434 Total Budget Impact/Other Variance from 20 year plan - New item. Projected savings of a least $43,324 over 18 year period, actual savings could be compounded through the equity of leased vehicles due to lower mileage and reuse of some emergency equipment between up-fits of vehicles. Wednesday, October 14, 2015 36 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0103b Project # Useful Life 4 years Outfit Duty Chief Leased Vehicles (5) Project Name Category Vehicles FuturePriorityn/a Description Cost to outfit leased vehicles 2015 - lease one Ford F-150 utility vehicle 2015 - lease two Ford Explorers for 1 Asst Chief and 1 Duty Chief 2017 - lease one Ford Explorers for Fire Chief One leased vehicle for 1 Asst Chief is paid for from HazMAt CAT Funds Justification Leased vehicles need to be outfitted for use by Fire Dept. PriorExpendituresTotal 20162017201820192020Future Vehicles 5,00015,00020,000 10,00080,000 5,00015,00020,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 5,00015,00020,000 10,000 Equipment Replacement Fund 80,000 5,00015,00020,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item. Cost of outfitting new leased vehicles for Fire Dept. Wednesday, October 14, 2015 37 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0106 Project # Useful Life 20 years Aerial Truck Project Name Category Vehicles FuturePriorityn/a 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) 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. PriorExpendituresTotal 20162017201820192020Future Equipment 54,21754,21754,217162,651 824,9461,572,000 54,21754,21754,217162,651 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 54,21754,21754,217162,651 824,946 Bonds/Lease 1,572,000 54,21754,21754,217162,651 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 38 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0107 Project # Useful Life 15 years Air Compressor Project Name Category Equipment FuturePriorityn/a Description The air compressor is used to fill breathing apparatus that has been used by Fire personnel after training and fires. Justification ExpendituresTotalFuture 20162017201820192020 Equipment 34,90034,900 54,400 34,90034,900 TotalTotal Funding Sources20162017201820192020TotalFuture 34,90034,900 Equipment Replacement Fund 54,400 34,90034,900 TotalTotal Budget Impact/Other Variance from 20 year plan - move back to 2017 Estimate salvage/resale value on replaced item - $ Purchased: 1996 Wednesday, October 14, 2015 39 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0109 Project # Useful Life 10 years Extrication Tool (2) Project Name Category Equipment FuturePriorityn/a Description Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. 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. PriorExpendituresTotal 20162017201820192020Future Equipment 27,40027,400 42,600107,200 27,40027,400 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 27,40027,400 42,600 Equipment Replacement Fund 107,200 27,40027,400 TotalTotalTotal 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 Wednesday, October 14, 2015 40 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0112 Project # Useful Life 10 years Thermal Imaging Camera (2) Project Name Category Equipment FuturePriorityn/a 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 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. PriorExpendituresTotal 20162017201820192020Future Equipment 12,90012,900 26,50053,500 12,90012,900 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 12,90012,900 26,500 Equipment Replacement Fund 53,500 12,90012,900 TotalTotalTotal 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- Wednesday, October 14, 2015 41 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0117 Project # Useful Life 5 years Workout Equipment - Treadmill #1 Project Name Category Equipment FuturePriorityn/a Description Workout equipment used in Fire Department workout room. One summit trainer replaced on a 5 year cycle. Current equipment : 2010 Summit Trainer - will be replaced with a treadmill Justification This equipment is available to all City employees for health and wellness. PriorExpendituresTotal 20162017201820192020Future Equipment 6,7006,700 10,80016,800 6,7006,700 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 6,7006,700 10,800 Equipment Replacement Fund 16,800 6,7006,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - replaces Stairmaster. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 42 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0118 Project # Useful Life 5 years Workout Equipment - Treadmill #2 Project Name Category Equipment FuturePriorityn/a Description Workout equipment used in the Fire Department workout room. One treadmill replaced on a 5 year cycle. Justification This equipment is available to all City employees for health and wellness. PriorExpendituresTotal 20162017201820192020Future Equipment 5,8005,800 5,00023,500 5,8005,800 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 5,8005,800 5,000 Equipment Replacement Fund 23,500 5,8005,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back one year from 2011 to 2012. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 43 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0119 Project # Useful Life 5 years Workout Equipment - Weight Lifting Project Name Category Equipment FuturePriorityn/a Description Smith machine - weight lifting machine. Justification For use by Police, Fire, Public Works, City staff to keep in shape to perform job duties and stay healthy. Current machine will be 7 years old in 2012. Suggested replacement is every 5 years. PriorExpendituresTotal 20162017201820192020Future Equipment 6,7006,700 5,80016,800 6,7006,700 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 6,7006,700 5,800 Equipment Replacement Fund 16,800 6,7006,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2011 to 2015 Estimate salvage/resale value on replaced items: $ Wednesday, October 14, 2015 44 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0120 Project # Useful Life 4 years Automated External Defibrillator (2) Project Name Category Equipment FuturePriorityn/a Description Defibrillator is used to help get someone's heart restarted during a cardiac arrest. Own 2 - both are replaced at one time due to changing technology. Current equipment: 2010 - 4 AEDs 2010 ERP had 2 AEDs schedule for replacement at $6,000. Four were purchased. Justification With changes in technology, the AED's should be replaced every four years. Cost - $3,000 per unit PriorExpenditures20162017201820192020TotalFuture Equipment 7,8007,800 13,20039,600 7,8007,800 TotalTotalTotal PriorFunding Sources20162017201820192020Total Future 7,8007,800 13,200 Equipment Replacement Fund 39,600 7,8007,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - adjustment from 3 years to 4 years. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 45 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0122 Project # Useful Life 10 years Workout Equipment - Dumb Bells Project Name Category Equipment FuturePriorityn/a Description Workout equipment used in Fire Department workout room. Justification Current dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead based plaint. This purchase would update our dumb bells to the current type fitness bells. ExpendituresTotalFuture 20162017201820192020 Equipment 5,0005,000 6,700 5,0005,000 TotalTotal Funding Sources20162017201820192020TotalFuture 5,0005,000 Equipment Replacement Fund 6,700 5,0005,000 TotalTotal Budget Impact/Other Variance from 20 year plan - Move back from 2014 to 2017. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 46 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0123 Project # Useful Life 15 years Fire - Washing Machine Project Name Category Equipment FuturePriorityn/a Description Replacement of current washing machine. Used to wash turnout gear after fire and any Hazardous conditions Justification This machine has not been in the ERP and came from the old Fire Station. This machine is used to wash turnout gear after a fire and any Hazardous conditions. ExpendituresTotalFuture 20162017201820192020 Equipment 8,5008,500 13,000 8,5008,500 TotalTotal Funding Sources20162017201820192020TotalFuture 8,5008,500 Equipment Replacement Fund 13,000 8,5008,500 TotalTotal Budget Impact/Other 2016 - New item in ERP Wednesday, October 14, 2015 47 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0124 Project # Useful Life 15 years Fire - Dryer Project Name Category Equipment FuturePriorityn/a Description Replacement of current dryer Justification This machine has not been in the ERP and came from the old fire station. This machine is used to dry turnout gear after fire and any Hazardous conditions. This is a commercial dryer. ExpendituresTotalFuture 20162017201820192020 Equipment 4,5004,500 7,000 4,5004,500 TotalTotal Funding Sources20162017201820192020TotalFuture 4,5004,500 Equipment Replacement Fund 7,000 4,5004,500 TotalTotal Budget Impact/Other 2016 - New in ERP Wednesday, October 14, 2015 48 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0125 Project # Useful Life 5-7 years Fire Radios - Portable and Mobile Devices Project Name Category Equipment FuturePriorityn/a Description Portable and mobile radios used by the police departments to allow the department to communicate on one frequency. Fire has 50 portable and 13 mobile radios along with 50 pagers. Cost in ERP includes portable radios (30), portable radio's encrypted (20), mobile radio's (13), pagers (50), chargers single (60), charger base (3) plus other needed equipment. Details of all items are on file with Fire and Finance Depts. Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. ExpendituresTotalFuture 20162017201820192020 Equipment 294,075294,075 361,000 294,075294,075 TotalTotal Funding Sources20162017201820192020TotalFuture 294,075294,075 Equipment Replacement Fund 361,000 294,075294,075 TotalTotal Budget Impact/Other In 2016 the Fire radios were separated from Police for better accountability. Project was adjusted for current pricing. Wednesday, October 14, 2015 49 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentIT Cit of Hokins MN yp, Contact IT Director Type Equipment 01-ERP-0003 Project # Useful Life 1 year CH - Network Server Project Name Category Equipment FuturePriorityn/a Description The network server is the hub of the network. New computers are faster and more reliable. 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. PriorExpendituresTotal 20162017201820192020Future Equipment 15,00015,00015,00015,00015,00075,000 112,000225,000 15,00015,00015,00015,00015,00075,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 15,00015,00015,00015,00015,00075,000 112,000 Equipment Replacement Fund 225,000 15,00015,00015,00015,00015,00075,000 TotalTotalTotal 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. Estimate salvage/resale value on replaced item: $-0- Wednesday, October 14, 2015 50 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentIT Cit of Hokins MN yp, Contact Finance Director/IT Type Equipment 01-ERP-0006 Project # Useful Life 3-5 years Computers Project Name Category Equipment FuturePriorityn/a Description Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Justification Tools enabling staff to perform job responsibilities efficiently and effectively. PriorExpendituresTotal 20162017201820192020Future Equipment 30,00030,00030,00030,00030,000150,000 450,000450,000 30,00030,00030,00030,00030,000150,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 30,00030,00030,00030,00030,000150,000 450,000 Equipment Replacement Fund 450,000 30,00030,00030,00030,00030,000150,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Wednesday, October 14, 2015 51 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentIT Cit of Hokins MN yp, Contact Finance Director/IT Type Equipment 01-ERP-0012 Project # Useful Life 6 years Core Network Switch Project Name Category Equipment FuturePriorityn/a 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 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. PriorExpendituresTotal 20162017201820192020Future Equipment 17,00017,000 10,00044,000 17,00017,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 17,00017,000 10,000 Equipment Replacement Fund 44,000 17,00017,000 TotalTotalTotal 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- Wednesday, October 14, 2015 52 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentIT Cit of Hokins MN yp, Contact IT Director Type Equipment 01-ERP-0013 Project # Useful Life 5-7 years Wi-Fi and Cellular Project Name Category Equipment FuturePriorityn/a 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 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. ExpendituresTotal 20162017201820192020 Equipment 6,0006,0006,00018,000 6,0006,0006,00018,000 Total Funding Sources20162017201820192020Total 6,0006,0006,00018,000 Equipment Replacement Fund 6,0006,0006,00018,000 Total Budget Impact/Other 2016 - New ERP item Wednesday, October 14, 2015 53 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentIT Cit of Hokins MN yp, Contact IT Director Type Equipment 01-ERP-014 Project # Useful Life 5 years Distribution Network Switches Project Name Category Equipment FuturePriorityn/a 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. 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. ExpendituresTotalFuture 20162017201820192020 Equipment 50,00050,000 57,000 50,00050,000 TotalTotal Funding Sources20162017201820192020TotalFuture 50,00050,000 Equipment Replacement Fund 57,000 50,00050,000 TotalTotal Budget Impact/Other 2016 - New item in ERP Wednesday, October 14, 2015 54 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentIT Cit of Hokins MN yp, Contact IT Director Type Equipment 01-ERP-0211 Project # Useful Life 3 years PD - Network Server (3) Project Name Category Equipment FuturePriorityn/a Description Computer servers store information and system programs for Police Department. One server @ $15,000 for system upgrades 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. PriorExpendituresTotal 20162017201820192020Future Equipment 15,00015,00015,00015,00015,00075,000 117,000225,000 15,00015,00015,00015,00015,00075,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 15,00015,00015,00015,00015,00075,000 117,000 Equipment Replacement Fund 225,000 15,00015,00015,00015,00015,00075,000 TotalTotalTotal 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. Estimate salvage/resale value on replaced item - $ Wednesday, October 14, 2015 55 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0200 Project # Useful Life 3 years Marked Patrol Vehicles (6) Project Name Category Vehicles FuturePriorityn/a Description Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. Fleet consists of 6 patrol vehicles - 5 marked, 1 unmarked. Current vehicles: (2) 2015 Ford Utility, (1) 2015 Unmarked Ford Utility, (1) 2014 Ford Utility, (1) 2013 Ford Interceptor 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. PriorExpendituresTotal 20162017201820192020Future Vehicles 90,00098,00098,00098,000107,400491,400 958,1001,830,400 90,00098,00098,00098,000107,400491,400 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 90,00098,00098,00098,000107,400491,400 958,100 Equipment Replacement Fund 1,830,400 90,00098,00098,00098,000107,400491,400 TotalTotalTotal 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 Wednesday, October 14, 2015 56 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0201 Project # Useful Life 4 years Sergeant's Vehicle Project Name Category Vehicles FuturePriorityn/a 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 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. PriorExpendituresTotal 20162017201820192020Future Vehicles 50,60050,600 78,600273,000 50,60050,600 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 50,60050,600 78,600 Equipment Replacement Fund 273,000 50,60050,600 TotalTotalTotal 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 Wednesday, October 14, 2015 57 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0202 Project # Useful Life 10 years Parking Enforcement Vehicle (Parking Fund) Project Name Category Vehicles FuturePriorityn/a Description Parking enforcement vehicle - $27,500 Add: $5,000 to outfit the vehicle Add: $4,000 for radio Current vehicle: 2006 Jeep Liberty (#211) Justification Use by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown area. PriorExpenditures20162017201820192020TotalFuture Vehicles 36,50036,500 18,70049,000 36,50036,500 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 36,50036,500 18,700 Equipment Replacement Fund 49,000 36,50036,500 TotalTotalTotal 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 Wednesday, October 14, 2015 58 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0203 Project # Useful Life 6 years PSO - Utility 4x4 (unit 212) Project Name Category Vehicles FuturePriorityn/a Description 4 wheel drive utility vehicle. Current vehicle: 2014 Ford F150 (#212) 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. PriorExpendituresTotal 20162017201820192020Future Vehicles 60,40060,400 115,100158,200 60,40060,400 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 60,40060,400 115,100 Equipment Replacement Fund 158,200 60,40060,400 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none. Estimate salvage/resale value on replaced item: $5,000 Wednesday, October 14, 2015 59 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0204 Project # Useful Life 2 years Police Administrative Vehicles (2) Project Name Category Vehicles FuturePriorityn/a Description Police administration (Chief, Captain) and Detective vehicles. Replace Chief's vehicle - even numbered years Replace Captain's vehicle - odd numbered years Effective 2014 - Chief vehicle to be leased for 4 years - 2yr for Chief and 2yr for Detective #3. In year 3 the Chief will get a new leased vehicle and use for two years before again passing the vehicle down to Detective #3 who will use it for another 2 years. Effective 2015 - Captain vehicle to be leased for 4 years - 2yr for Captain and 2yr for Detective #2. In year 3 of lease the Captain will get a new leased vehicle, use for 2 years before passing down to Detective #2 who will use it for another two years. There are 4 leased vehicles accounted for in this ERP item Current vehicles: 2013 Ford Utility, 2014 Nissan Maxima Justification Unmarked vehicles, equipped with radios, siren and red grill lights used by Chief and Captain. Staff use is for two years. Vehicles are then rotated down to detectives and are kept for an additional 2 years. Vehicles are also used for surveillance by uniform and plain clothes officers. PriorExpenditures20162017201820192020TotalFuture 16,79421,99922,65523,32924,029108,806 315,317 Vehicles 459,140 16,79421,99922,65523,32924,029108,806 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 16,79421,99922,65523,32924,029108,806 315,317 Equipment Replacement Fund 459,140 16,79421,99922,65523,32924,029108,806 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - starting in 2014 Chief's vehicle will be leased and in 2015 the Captain's will be leased. Estimate salvage/resale value on replaced item: $4,000 each for current vehicles not leased. Wednesday, October 14, 2015 60 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0204a Project # Useful Life Police Admin Cars - outfit leased vehicles Project Name Category Vehicles FuturePriorityn/a Description Cost to outfit leased police Chief and Captains cars Justification We need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. Chief & Captain get a new vehicle every other year. Year 3 & 4 of Chief lease - Detective Year 3 & 4 of Captain lease - Detective Since one is purchased each year the cost is estimated at $5,000 per vehicle per year. PriorExpendituresTotal 20162017201820192020Future Equipment 5,0005,0005,0005,0005,00025,000 10,00075,000 5,0005,0005,0005,0005,00025,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 5,0005,0005,0005,0005,00025,000 10,000 Equipment Replacement Fund 75,000 5,0005,0005,0005,0005,00025,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan: Cost of outfitting chief's and captain's vehicles is now accounted for separately from the vehicle purchase since the vehicles are now leased. Wednesday, October 14, 2015 61 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0205 Project # Useful Life 15 years SWAT Vehicle Project Name Category Vehicles FuturePriorityn/a Description Unmarked van to transport police tactics team for high risk calls, training and mutual aid. SWAT - Special Weapons And Tactics Current vehicle: 1998 Chevrolet Cube Van (#240) Justification Previous vehicle (15 years old) was a safety hazard and was replaced in 2005. ExpendituresTotalFuture 20162017201820192020 Vehicles 50,00050,000 77,900 50,00050,000 TotalTotal Funding Sources20162017201820192020TotalFuture 50,00050,000 Equipment Replacement Fund 77,900 50,00050,000 TotalTotal Budget Impact/Other Variance from 20 year plan - Increase cost from 30,000 to 50,000 Estimate salvage/resale value on replaced item: $3,000 Wednesday, October 14, 2015 62 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0206 Project # Useful Life 4 years Drug Task Force Vehicle Project Name Category Vehicles FuturePriorityn/a Description Drug Task Force Vehicle Effective in 2014 this vehicle will be leased for 4 years 2 years as a DTF vehicle 2 years as Detective #1 vehicle (This accounts for the lease for 2 vehicles) Justification Previously in the NW Metro DTF which provided a vehicle. Now in SW Metro DTF and we need to provide our own vehicle. PriorExpendituresTotal 20162017201820192020Future Vehicles 11,07411,07411,74011,74012,46058,088 10,883234,820 11,07411,07411,74011,74012,46058,088 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 11,07411,07411,74011,74012,46058,088 10,883 Equipment Replacement Fund 234,820 11,07411,07411,74011,74012,46058,088 TotalTotalTotal Budget Impact/Other Variance from 20 year plan: New for 2014 Wednesday, October 14, 2015 63 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0206a Project # Useful Life Drug Task Force Vehicle - outfit leased vehicle Project Name Category Vehicles FuturePriorityn/a Description Cost to outfit leased Drug Task Force vehicle Justification We need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. DTF vehicle will be replaced every 2 years with the 2nd two years of the lease going to a Detective. PriorExpendituresTotal 20162017201820192020Future Equipment 5,0005,0005,00015,000 5,00035,000 5,0005,0005,00015,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 5,0005,0005,00015,000 5,000 Equipment Replacement Fund 35,000 5,0005,0005,00015,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan: Cost of outfitting DTF vehicles is now accounted for separately from the vehicle purchase since the vehicle is now leased. Wednesday, October 14, 2015 64 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0214 Project # Useful Life 5 years Tactical Ballistic Vests Project Name Category Equipment FuturePriorityn/a 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. Current equipment: 11 - Protech Tactical Vests 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. Cost: 11 vests PriorExpendituresTotal 20162017201820192020Future Equipment 26,90026,900 43,200109,400 26,90026,900 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 26,90026,900 43,200 Equipment Replacement Fund 109,400 26,90026,900 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Team membership has increased to 11. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 65 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0215 Project # Useful Life 5-7 years Police - Portable Radios Project Name Category Equipment FuturePriorityn/a Description Portable radios used by the police departments to allow the department to communicate on one frequency. Estimated Replacement Cost Portable - $4,500 x 50 = $225,000 Plus chargers, shoulder mic's and batteries - $11,300 TOTAL = $236,300 In 2016 we will need to replace the portables as the current model will no longer be supported by Hennepin County. Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. PriorExpenditures20162017201820192020TotalFuture Equipment 236,300236,300 45,100290,000 236,300236,300 TotalTotalTotal PriorFunding Sources20162017201820192020Total Future 236,300236,300 45,100 Equipment Replacement Fund 290,000 236,300236,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Radio's have a 7-10 year life expectancy. Portables need replacement due to manufacturer issues and county requirements. Increase in cost from $3,800 to $4,500 per radior. Mobile radios were removed and now will be I included with the vehicles as they are replaced. Separate fire radios from police and create new ERP item for Fire. Estimate salvage/resale value on replaced item: $0 Wednesday, October 14, 2015 66 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Captain Type Equipment 01-ERP-0217 Project # Useful Life 4 years Taser Replacement Project Name Category Equipment FuturePriority3 Important Description Tasers and new technology continues to evolve and require replacement every 4 years. Justification The current Tasers will need to be replaced in 2017 due to the age and use of the equipment. PriorExpendituresTotal 20162017201820192020Future Equipment 20,90020,900 18,60079,800 20,90020,900 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 20,90020,900 18,600 Equipment Replacement Fund 79,800 20,90020,900 TotalTotalTotal Budget Impact/Other Using the numbers obtained from Tasers Bob Lovering, the cost breaks down as shown below: 8 X2 Tasers $7,600.00 8 HD Cams $3,999.60 8 4yr Warranty/X2 $2,399.92 8 4yr Warranty/Cam $1,199.96 6 Blade Tech Holsters $ 359.70 56 Cartridges $1,621.20 Download Kit $ 14.95 Shipping $ 120.00 Total $17,315.33 (plus tax) w/Tax est $18,575 Wednesday, October 14, 2015 67 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief/IT Type Equipment 01-ERP-0218 Project # Useful Life 4 years Building Video Server Project Name Category Equipment FuturePriorityn/a 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. 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. PriorExpendituresTotal 20162017201820192020Future Equipment 17,00017,000 17,00051,000 17,00017,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 17,00017,000 17,000 Equipment Replacement Fund 51,000 17,00017,000 TotalTotalTotal 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- Wednesday, October 14, 2015 68 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0219 Project # Useful Life 5 years PD - Squad Video Server Project Name Category Equipment FuturePriorityn/a Description Squad video server used to store evidentiary squad video and audio which we need to keep for one year. Justification Needed to maintain evidentiary squad video and audio which we need to keep for one year. This requires a large amount of data storage space. Body camera storage will also be needed in the future. ExpendituresTotalFuture 20162017201820192020 Equipment 15,00015,000 60,800 15,00015,000 TotalTotal Funding Sources20162017201820192020TotalFuture 15,00015,000 Equipment Replacement Fund 60,800 15,00015,000 TotalTotal Budget Impact/Other 2016 - New ERP item Wednesday, October 14, 2015 69 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief/IT Type Equipment 01-ERP-0220 Project # Useful Life 5 years Data 911 Computers Project Name Category Equipment FuturePriorityn/a Description Mobile computer and video system for the patrol vehicles. Justification To keep technology up to date and verify technology stays compliant with current and new security requirements for criminal justice data. ExpendituresTotalFuture 20162017201820192020 Equipment 50,00050,000 202,000 50,00050,000 TotalTotal Funding Sources20162017201820192020TotalFuture 50,00050,000 Equipment Replacement Fund 202,000 50,00050,000 TotalTotal Budget Impact/Other New for 2016 - will need to be added for 2020 replacement Wednesday, October 14, 2015 70 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Bldg/Equip Ser Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0710 Project # Useful Life 10 years 4X4 1/2 Ton Truck Project Name Category Vehicles FuturePriorityn/a Description Pickup used by various divisions of Public Works. Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. PriorExpendituresTotal 20162017201820192020Future Vehicles 31,30031,300 23,30042,100 31,30031,300 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 31,30031,300 23,300 Equipment Replacement Fund 42,100 31,30031,300 TotalTotalTotal 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 Wednesday, October 14, 2015 71 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Bldg/Equip Ser Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0711 Project # Useful Life 12 years Hot Water High Pressure Vehicle Washer Project Name Category Equipment FuturePriorityn/a Description Hot water, high pressure vehicle washer. Justification Existing washer is 12 years old; is in poor condition and needs to be replaced. PriorExpendituresTotal 20162017201820192020Future Equipment 8,3008,300 5,80011,500 8,3008,300 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 8,3008,300 5,800 Equipment Replacement Fund 11,500 8,3008,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - new item. Estimate salvage resale value on replaced item: $ Wednesday, October 14, 2015 72 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Bldg/Equip Ser Cit of Hokins MN yp, Contact Bldg/Equip Supt Type Equipment 01-ERP-0712 Project # Useful Life 15 years PW - 4x4 3/4 Ton Pick-up Truck Project Name Category Equipment FuturePriorityn/a Description Building Foreman truck - currently a 1995 3/4 ton utility truck passed down from the Fire Dept. Justification the current truck is 20 years old and has served its useful life. The Building Foreman needs to have a dependable truck with a utility body to store and carry his tools and equipment to the City's many facilities he works on. ExpendituresTotalFuture 20162017201820192020 Vehicles 32,00032,000 49,800 32,00032,000 TotalTotal Funding Sources20162017201820192020TotalFuture 32,00032,000 Equipment Replacement Fund 49,800 32,00032,000 TotalTotal Budget Impact/Other New item for 2016 - currently using a "hand-me-down". Wednesday, October 14, 2015 73 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0801 Project # Useful Life 8 years 4x4 3/4Ton Trucks (2) Project Name Category Vehicles FuturePriorityn/a Description Trucks used by Parks Division of Public Works. Current vehicles: 2012 Ford F350 4X4 (#801) & 2012 Ford F350 4X4 (#802) Justification Snow plowing, hauling, transportation. Units are heavily used. PriorExpendituresTotal 20162017201820192020Future Vehicles 85,20085,200 120,600108,000 85,20085,200 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 85,20085,200 120,600 Equipment Replacement Fund 108,000 85,20085,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 74 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0802 Project # Useful Life 14 years 3/4 Ton Utility Truck Project Name Category Vehicles FuturePriorityn/a Description 3/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city. Current vehicle: 1998 Dodge Ram 3500 (#805) Justification ExpendituresTotalFuture 20162017201820192020 Vehicles 32,20032,200 48,700 32,20032,200 TotalTotal Funding Sources20162017201820192020TotalFuture 32,20032,200 Equipment Replacement Fund 48,700 32,20032,200 TotalTotal Budget Impact/Other Variance from 20 year plan - move from 2014 to 2016. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 75 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0807 Project # Useful Life 15 years Trucksters (3) Project Name Category Equipment FuturePriorityn/a 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 (#822) Justification Park maintenance, ballfield grooming and weed spraying. PriorExpendituresTotal 20162017201820192020Future Equipment 34,20034,200 40,90070,340 34,20034,200 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 34,20034,200 40,900 Equipment Replacement Fund 70,340 34,20034,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Estimate salvage/resale value on replaced item: (3) $1,400 each Wednesday, October 14, 2015 76 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0808 Project # Useful Life 8 years Riding Mowers (2) Project Name Category Equipment FuturePriorityn/a Description Riding mowers used by Parks Division of Public Works. Current equipment: 2004 Toro Zero Turn (#826), 2006 Jacobson Rotary Mower (#823) Justification Mowing city parks and right of ways. PriorExpendituresTotal 20162017201820192020Future Equipment 20,00020,000 60,00089,000 20,00020,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 20,00020,000 60,000 Equipment Replacement Fund 89,000 20,00020,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2014 to 2015. Move back from 2015 to 2016. Estimate salvage/resale value on replaced item: $600 each Wednesday, October 14, 2015 77 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0810 Project # Useful Life 10 years Large Turf Mower Project Name Category Equipment FuturePriorityn/a Description Large turf mower (11' cutting width) used by Parks Division of Public Works. Current equipment: 2010 Toro Groundmaster (#825) Justification Required to efficiently mow large parks. PriorExpendituresTotal 20162017201820192020Future Equipment 92,70092,700 115,000124,600 92,70092,700 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 92,70092,700 115,000 Equipment Replacement Fund 124,600 92,70092,700 TotalTotalTotal 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 Wednesday, October 14, 2015 78 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0812 Project # Useful Life 20 years Stump Cutter Project Name Category Equipment FuturePriorityn/a Description Stump cutter used by Parks Division of Public Works. Current equipment: 1997 Vermeer Stump Cutter (#832) Justification Chipping out stumps of trees removed from city property. ExpendituresTotal 20162017201820192020 Equipment 21,20021,200 21,20021,200 Total Funding Sources20162017201820192020Total Equipment Replacement Fund 21,20021,200 21,20021,200 Total Budget Impact/Other Variance from 20 year plan - extend to 20 years to reflect actual. Estimate salvage/resale value on replaced item: $1,800 Wednesday, October 14, 2015 79 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0814 Project # Useful Life 15 years Trailer Flatbed Project Name Category Equipment FuturePriorityn/a Description Justification PriorExpendituresTotal 20162017201820192020 Equipment 2,2002,200 1,400 2,2002,200 TotalTotal PriorFunding Sources20162017201820192020Total 2,2002,200 1,400 Equipment Replacement Fund 2,2002,200 TotalTotal Budget Impact/Other Variance from 20 year plan - Move up one year. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 80 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0815 Project # Useful Life 12 years Skid Loader Project Name Category Equipment FuturePriorityn/a Description Current equipment: 2004 Bobcat 463 (#833) Justification ExpendituresTotalFuture 20162017201820192020 Equipment 32,00032,000 45,600 32,00032,000 TotalTotal Funding Sources20162017201820192020TotalFuture 32,00032,000 Equipment Replacement Fund 45,600 32,00032,000 TotalTotal Budget Impact/Other Variance from 20 year plan - new item in 2004. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 81 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0816 Project # Useful Life 8 years Toolcat Project Name Category Equipment FuturePriorityn/a Description Use by Public Works for snow removal, skating rinks, sweeping, ballfield maintenance and transportation of people and materials. Current vehicle: 2010 Bobcat (#815) Justification New machine. PriorExpendituresTotal 20162017201820192020Future Equipment 63,30063,300 50,000181,800 63,30063,300 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 63,30063,300 50,000 Equipment Replacement Fund 181,800 63,30063,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item which replaces one tractor. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 82 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0301 Project # Useful Life 8 years 4X4 3/4 Ton Truck with Plow Project Name Category Vehicles FuturePriorityn/a Description 3/4 ton pickup used by Street Division of Public Works for heavy loads and pulling trailers. Current vehicle: 2006 Ford F250 (#302) Justification Light hauling, pulling trailers, transportation to and from job sites. PriorExpendituresTotal 20162017201820192020Future Vehicles 30,40030,400 24,00087,300 30,40030,400 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 30,40030,400 24,000 Equipment Replacement Fund 87,300 30,40030,400 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Unit in good condition - move from 2015 to 2016 Estimate salvage/resale value on replaced item: $1,500 Wednesday, October 14, 2015 83 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0302 Project # Useful Life 12 years 4x2 1 Ton Dump Truck Project Name Category Equipment FuturePriorityn/a Description Truck used in the Street Division of Public Works. Current vehicle: 2006 Ford F350 Pickup (#307) Justification Plows alleys in winter, light hauling, snow removal and transportation. PriorExpendituresTotal 20162017201820192020Future Equipment 54,60054,600 30,50077,800 54,60054,600 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 54,60054,600 30,500 Equipment Replacement Fund 77,800 54,60054,600 TotalTotalTotal 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 Wednesday, October 14, 2015 84 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0306 Project # Useful Life 17 years Tandem Dump Truck (2) Project Name Category Vehicles FuturePriorityn/a Description Dump truck used in Streets Division of Public Works. Current vehicles: 1998 Ford LT8500 Tandem (#314) 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. PriorExpendituresTotal 20162017201820192020Future Vehicles 173,200180,000353,200 22,000580,000 173,200180,000353,200 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 173,200180,000353,200 22,000 Equipment Replacement Fund 580,000 173,200180,000353,200 TotalTotalTotal 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- Wednesday, October 14, 2015 85 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0307 Project # Useful Life 20 years Water Truck Project Name Category Vehicles FuturePriorityn/a Description Water truck used in Streets and Parks Division of Public Works. Current vehicle: 1995 Ford Water Truck (#316) Justification Used for street flushing, watering trees and plants, rink flooding and standby fire protection. PriorExpendituresTotal 20162017201820192020Future Vehicles 150,000150,000 45,000201,000 150,000150,000 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 150,000150,000 45,000 Equipment Replacement Fund 201,000 150,000150,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move from 2017 to 2016. Due to age of truck parts are no longer available. Change life from 22 years to 20 years. Estimate salvage/resale value on replaced item: $8,500 Wednesday, October 14, 2015 86 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0309 Project # Useful Life 12 years Skid Loader (2) Project Name Category Equipment FuturePriorityn/a Description Loading trucks, landscape work, snow removal, material handling. Current equipment: 2004 Bobcat S-1851R Skid Loader (#324) & 2011 Bobcat S650 Skid-Steer Loader (#325) Justification PriorExpendituresTotal 20162017201820192020Future Equipment 41,90041,900 36,000181,000 41,90041,900 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 41,90041,900 36,000 Equipment Replacement Fund 181,000 41,90041,900 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2010 to 2011. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 87 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0311 Project # Useful Life 20 years Sweeper Project Name Category Equipment FuturePriorityn/a Description Street sweeper used by Streets Division for sweeping streets and parking lots. Current equipment: 2001 Elgin Pelican SE (#327) Justification Street sweeping, event clean-up, spring sand removal. PriorExpendituresTotal 20162017201820192020 Equipment 156,400156,400 115,300 156,400156,400 TotalTotal PriorFunding Sources20162017201820192020Total 156,400156,400 115,300 Equipment Replacement Fund 156,400156,400 TotalTotal Budget Impact/Other Variance from 20 year plan - Move from 2021 to 2019 Estimate salvage/resale value on replaced item: $12,000 Wednesday, October 14, 2015 88 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0312 Project # Useful Life 20 years PW - Roller Project Name Category Equipment FuturePriorityn/a Description Used by Street Department for asphalt repair and resurfacing. Current equipment: 1989 Ingersoll Rand Roller (#330) Justification ExpendituresTotalFuture 20162017201820192020 Equipment 45,90045,900 82,000 45,90045,900 TotalTotal Funding Sources20162017201820192020TotalFuture 45,90045,900 Equipment Replacement Fund 82,000 45,90045,900 TotalTotal Budget Impact/Other Variance from 20 year plan - Move from 2016 to 2017. Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 89 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0313 Project # Useful Life 12 years Striper Project Name Category Equipment FuturePriorityn/a Description Line striper. Current equipment: 1993 Line Striper A1990 (#352) Justification ExpendituresTotalFuture 20162017201820192020 Equipment 11,20011,200 16,000 11,20011,200 TotalTotal Funding Sources20162017201820192020TotalFuture 11,20011,200 Equipment Replacement Fund 16,000 11,20011,200 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 90 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0314 Project # Useful Life 20 years PW - Asphalt Paver Project Name Category Equipment FuturePriorityn/a Description Asphalt paver used by Streets Division of Public Works. Current equipment: 1994 Caterpillar AD200B Paver (#337) Justification Paving streets and parking lots. ExpendituresTotalFuture 20162017201820192020 Equipment 48,80048,800 90,000 48,80048,800 TotalTotal Funding Sources20162017201820192020TotalFuture 48,80048,800 Equipment Replacement Fund 90,000 48,80048,800 TotalTotal Budget Impact/Other Variance from 20 year plan. Move from 2016 to 2018 Estimate salvage/resale value on replaced item: $500 Wednesday, October 14, 2015 91 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0317 Project # Useful Life 10 years Sign Machine (Traffic) Project Name Category Equipment FuturePriorityn/a Description Machine used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city use. Current equipment: 2005 Signcad Sign Making System (#353) Justification Existing machine is not repairable and needs updating. ExpendituresTotalFuture 20162017201820192020 Equipment 13,40013,400 18,100 13,40013,400 TotalTotal Funding Sources20162017201820192020TotalFuture 13,40013,400 Equipment Replacement Fund 18,100 13,40013,400 TotalTotal Budget Impact/Other Variance from 20 year plan - Move back to 2016 Estimate salvage/resale value on replaced item: $-0- Wednesday, October 14, 2015 92 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Bldg/Equip Supt Type Equipment 01-ERP-0320 Project # Useful Life 15 PW - Planer Project Name Category Equipment FuturePriorityn/a Description 4" planer used by the street department for pavement repairs used on any of the Bobcat equipment. Justification This 4” Planer mounts on a skid loader and allows the Streets Department to cut a 4” wide opening to the depth of any street in Hopkins. The four inch width cut creates a seem in which can the blacktop can be cleanly picked from the hole with a loader bucket. Currently using a 15+ year old concrete saw and plus a jack hammer when street surface depths exceed four inches. The deeper the road surface cut the less crisp the edge of the hole becomes which affects the quality of the replacement patch. This equipment will allow for a one tool cutting procedure for all depths which will be more efficient and provide for a better patch in the end. ExpendituresTotalFuture 20162017201820192020 Equipment 12,00012,000 18,600 12,00012,000 TotalTotal Funding Sources20162017201820192020TotalFuture 12,00012,000 Equipment Replacement Fund 18,600 12,00012,000 TotalTotal Budget Impact/Other 2014 - New item in ERP Wednesday, October 14, 2015 93 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentRefuse Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0803 Project # Useful Life 20 years Swap Loader Project Name Category Equipment FuturePriorityn/a 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) Justification Needed for waste and snow hauling. PriorExpenditures20162017201820192020TotalFuture 95,00095,000 80,000 Equipment 171,000 95,00095,000 TotalTotalTotal PriorFunding SourcesTotal 20162017201820192020Future Equipment Replacement Fund 23,75023,750 80,000171,000 RF - Refuse Fund 71,25071,250 TotalTotal 95,00095,000 Total Budget Impact/Other Variance from 20 year plan - Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 94 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentRefuse Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0901 Project # Useful Life 10 years Refuse Truck (Rear-L) Project Name Category Vehicles FuturePriorityn/a Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 1996 Freightliner FL70 (#903) Justification Residential waste pick up. ExpendituresTotalFuture 20162017201820192020 Vehicles 101,600101,600 136,500 101,600101,600 TotalTotal Funding Sources20162017201820192020TotalFuture 101,600101,600 RF - Refuse Fund 136,500 101,600101,600 TotalTotal Budget Impact/Other Variance from 20 year plan. Move from 2016 to 2017 Estimate salvage/resale value on replaced item: $9,000 Wednesday, October 14, 2015 95 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentSewer Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0551 Project # Useful Life 10 years 3/4 Ton Utility Truck Project Name Category Vehicles FuturePriorityn/a Description 3/4 ton utility truck used by the Water/Sewer Division of Public Works. Current vehicle: 2007 Chevrolet Pickup (#505) Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. PriorExpendituresTotal 20162017201820192020Future Vehicles 33,60033,600 51,00045,200 33,60033,600 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 33,60033,600 51,000 SF - Sanitary Sewer Fund 45,200 33,60033,600 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Wednesday, October 14, 2015 96 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentSewer Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0552 Project # Useful Life 20 years Jet Vactor Project Name Category Equipment FuturePriorityn/a Description Single axle truck used by Water/Sewer Divisions of Public Works. Current equipment: 2001 Sterling Vac-Con Justification Cleaning sewer and catch basins. ExpendituresTotal 20162017201820192020 Equipment 350,000350,000 350,000350,000 Total Funding Sources20162017201820192020Total SF - Sanitary Sewer Fund 350,000350,000 350,000350,000 Total 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 Wednesday, October 14, 2015 97 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentSewer Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0555 Project # Useful Life 25 years Generator (2) Project Name Category Equipment FuturePriorityn/a Description Portable generator used by Water/Sewer Divisions of Public Works. Current equipment: 1997 Kohler Generator, 2008 Caterpillar C15 (#537) Justification Emergency back up generator for lift stations and pumps, off site power for lights and welding. ExpendituresTotalFuture 20162017201820192020 Equipment 26,40026,400 23,000 26,40026,400 TotalTotal Funding Sources20162017201820192020TotalFuture 26,40026,400 SF - Sanitary Sewer Fund 23,000 26,40026,400 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Wednesday, October 14, 2015 98 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentWater Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0500 Project # Useful Life 10 years 1/2 Ton Truck Project Name Category Vehicles FuturePriorityn/a Description Trucks used by Water Department. Current vehicle: 2007 Chevrolet Pickup Justification PriorExpendituresTotal 20162017201820192020Future Vehicles 26,80026,800 20,50036,000 26,80026,800 TotalTotalTotal PriorFunding Sources20162017201820192020TotalFuture 26,80026,800 20,500 WF - Water Fund 36,000 26,80026,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, October 14, 2015 99 EQUIPMENT REPLACEMENT PLAN 20162020 thru DepartmentWater Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0501 Project # Useful Life 10 years 3/4 Ton Utility Truck Project Name Category Vehicles FuturePriorityn/a Description 3/4 ton utility truck used by the Water Division of Public Works. Current vehicle: 2006 Chevrolet Pickup Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. ExpendituresTotalFuture 20162017201820192020 Vehicles 35,00035,000 46,900 35,00035,000 TotalTotal Funding Sources20162017201820192020TotalFuture 35,00035,000 WF - Water Fund 46,900 35,00035,000 TotalTotal Budget Impact/Other Variance from 20 year plan - moved up from 2017 to 2016 Estimate salvage/resale value on replaced item: $2,500 Wednesday, October 14, 2015 100 TWENTY-YEAR REPLACEMENT SCHEDULE 101 102 103 104 105 106 EQUIPMENT AND BUILDING INVENTORY 107 108 CITY OF HOPKINS BUILDING INVENTORY January 2015 Replacement Cost Location/Description City Hall & Police Station$7,823,932 1010 1st Street S. Fire Station4,553,503 101 17th Avenue S. Hopkins Activity Cente1,972,206 r 33 14th Avenue S. Ice Arena/Pavilion5,415,855 11000 Excelsior Boulevard Arts Cente7,418,388 r 1111 Mainstree t PW Admin/Garage7,746,583 11100 Excelsior Boulevard Moline Reservoir/Well #12,482,775 10421 Excelsor Boulevard 1,497,276 Blake Tower Reservio r 151 Tyler Avenue South Filtration Plan3,651,220 t 1401 Elmo Park Service Road Well #4 Workshop/Storage578,484 1401 Elmo Park Service Road Well #5247,703 1205 Highway7 Well #6330,261 801 Highway 7 Lift Station #2 - Drillane70,383 619 Drillane Road Lift Station #3 - Lindee's140,565 901 Cambridge Street N.E. Lift Station #4 - LTL Meadowbroo102,924 k 244 Meadowbrook Road 163,389 Lift Station #5 - Big Meadowbroo k 6601 Excelsior Blvd. Lift Station #6 - Ronnie's$102,924 8546 Excelsior Avenue E. 109 Location/DescriptionReplacement Cost Lift Station #7 - Valle325,314 y 801 6th Avenue S. 125,980 Storage Facilit y 1401 Elmo Park Service Road Band Shell - Downtown Par38,871 k 16 9th Avenue S. Concession Stand - Maetzold Field161,041 1215 1st Street N. Park Building-Beach - Lifeguards173,772 5200 Shady Oak Road Park Building-Beach-Concessions164,201 5200 Shady Oak Road Park Shelter - Office/Bathhouse398,824 5200 Shady Oak Road Park Shelter - Burnes53,077 201 Park Lane Park Building - Central120,467 101 17th Avenue S. 40,814 Park Building - Harle y 108 Jackson Avenue S. Park Shelter - Interlachen65,232 220 Homedale Avenue Park Building - Oakes46,538 301 Tyler Avenue N. Park Building - Valle54,712 y 800 7th Avenue S. Parking Ramp6,733,260 10th Avenue and Mainstree t Depot Coffee House507,144 9451 Excelsior Boulevard 8,009 Overpass Skate Par k 100 Washington Avenue Commercial Bldg - Studio Tan308,813 20 Shady Oak Road Dow Towers (76 Units)HRA 22 5th Avenue S. 110 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2015 MAKEMODELVALUE UNIT #YEA R FIRE DEPARTMENT 102.1989FORDTELE-SQUIRT L9000380,000 103.2006PETERBILTPUMPER420,000 1042012FORDQUICK ATTACK PUMPER F550248,500 1052015FORDEXPLORER (RED) - LEASED47,500 1062015FORDEXPLORER (RED) - LEASED47,500 1072015FORDEXPLORER (BLACK) - LEASED47,500 1082014FORDF-150 - LEASED34,000 1092008PIERCEAERO XT874,000 1102010CHEVROLETTAHOE30,000 PUMPER4,000 115.1952MAC K POLICE DEPARTMENT 200.2010FORDCROWN VICTORIA$30,000 2012014FORDEXPLORER31,000 202.2011FORDCROWN VICTORIA31,000 205.2011FORDCROWN VICTORIA31,000 207.2014FORDEXPLORER47,500 208.2013FORDEXPLORER42,600 209.2011FORDCROWN VICTORIA31,000 211.2006JEEPLIBERTY18,800 2122014FORDF15034,000 213.2010CHEVIMPALA26,000 2142014ISSANMAXIMA (CHIEF LEASED VEHICLE)38,800 N 215.2009CHEVIMPALA25,000 216.2011FORDTAURUS30,000 218.2013FORDINTERCEPTOR SUV40,000 219.2013FORDTAURUS27,500 229.2013FORDINTERCEPTOR39,700 2202005DODGERAM 1500 (DWI ENFORCEMENT)29,000 2212015JEEPCHEROKEE35,000 240.1998CHEVP40 VAN12,000 ISSANTITAN (DTF LEASED VEHICLE)40,300 2992014 N 111 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2015 MAKEMODELVALUE UNIT #YEA R STREET/TRAFFIC DIVISION 301.2013FORDF150$19,500 302.2006FORDF25026,500 304.2000FORDF45034,000 305.1997FORDF35018,300 307.2006FORDF350-1 TON DUMP27,400 308.2011FORDF350 - 2X420,300 309.2012FORDF45030,300 311.2011FREIGHTLINERM2106V79,400 312.2005FREIGHTLINERSGLAX DUMP98,000 313.2001FORDL750172,000 314.1998FORDLT 850084,000 81,000 316.1995FORDWATER TR K 320.1991CATERPILLERLOADER 926E90,000 177,500 321.2012CATERPILLERLOADER 924 K 322.2005CATERPILLERLOADER 938G157,800 324.2004BOBCATSKID LOADER32,900 325.2011BOBCATSKID STEER LOADER35,100 326.1989CATERPILLAR140-G82,000 327.2001ELGINPELICAN SE105,000 328.2013ISUZUSTREET SWEEPER145,300 330.1989INGERSOL/RANDROLLER DD-2515,000 337.1994CATERPILLARBOX PAVER17,000 342.1991TARGETCONCRETE SAW2,400 3432014SNOWCRETESNOWBLOWER - CUMMINS QSB6.771,500 344.1996SNOGOWK 80058,000 3482014PJ TRAILER20' TILT TRAILER5,300 349.1989TRAIL-KINGTK6V-12002,500 350.1993TOWMASTERT144,000 351.2004TENNANTSWEEPER 364010,000 ENGINEERING DIVISION 700.2002CHEVTAHOE$18,000 7012008FORDTAURUS22,000 705.2005CHEVIMPALA14,600 7062015FORDTRANSIT 250 VAN24,000 BUILDING MAINTENANCE & EQUIPMENT SERVICES 702.2004FORDF350$18,000 7031995CHEVEXT CAB 4X436,000 704.2005FORDF25018,000 112 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2015 MAKEMODELVALUE UNIT #YEA R PARKS/FORESTRY DIVISION 800.2013FORDF150$23,700 801.2012FORDF350 4X424,100 803.2004FORDF35017,500 804.1995CHEV1 TON BOOM45,000 805.1998DODGERAM 350017,100 810.1993INTERNATIONALLP 470050,000 45,000 811.2006INTERNATIONALLP 4600 LOG TRUC K 812.2010FREIGHTLINERAERIAL LIFT130,000 815.2010BOBCATTOOLCAT53,000 8162014BOBCAT5610 TOOLCAT 50,900 818.1996TOROTRUCKSTER13,000 820.2004TOROWORKMAN 320015,000 822.2001TORO325-D MOWER18,000 823.2006JACOBSONMOWER 10,000 824.1996TOROGROUND MASTER16,000 825.2010TORO4100D MOWER56,500 826.2004TOROZ587L8,900 828.2001DEW EZEATM7221,000 832.1997VERMEERSTUMP CTR 630A15,400 833.2004BOBCATSKID LOADER22,000 834.2013VERMEERBRUSH CHIPPER29,800 836. RYANSOD CUTTER2,000 8432007CARRTRAILER2,500 844.2010FELLINGTRAILER6,000 845.1997REMACKELTRAILER3,500 846.2001DRESSEN81102,000 847.2011SPARKSTILT TRAILER4,900 HRA 411.2007CHEV2500 HD$17,500 113 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY Fall, 2015 MAKEMODELVALUE UNIT #YEA R WATER/SEWER 500.2007CHEVPICKUP$22,000 501.2004CHEV4X4 3/4 T SILVERADO19,000 502.1999DODGEDAKOTA 4X418,000 5032015FORDF35038,000 505.2007CHEVCC2575331,900 506.2006CHEVSILVERADO20,700 507.2001CHRYSLERPT CRUISER18,000 530.2001STERLINGVAC-CON180,000 533.2012CATERPILLAR420EH2 BACKHOE87,700 534.1997KOHLERGENERATOR/TRL11,000 535.1992KOHLERGENERATOR/TRL10,000 536.1989FLEXIBLERODDING MACHINE49,000 537.2010GENERATORC15144,300 REFUSE 900.2011FREIGHTLINERRAPID-RAIL M2$201,109 901.2005PETERBILT320155,000 9022015FREIGHTLINERM2106V232,500 903.1995FREIGHTLINERFL-7050,000 PAVILION 802.2012FORDF350$20,000 8082014ZAMBONI ICE RESURFACER$126,000 809.2003OLYMPIAICE RESURFACER87,800 114