The URL can be used to link to this page

2015 - 2019 ERP EQUIPMENT REPLACEMENT PLAN 2015-2019 DATE: July 2014 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager 2015-2019 EQUIPMENT REPLACEMENT PLAN SUBJECT: With this letter, I respectfully submit the 2015-2019 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, Christine Harkess, Finance Director and Deb Dahlheimer, Sr. Finance Clerk for their hard work and dedication. 1 EQUIPMENT REPLACEMENT PLAN 2015-2019 TABLE OF CONTENTS Page City Manager's Message 1 Table of Contents 2 Introduction Background and Summary of Changes from 2013 Plan5 Cash Flow Statements Equipment Replacement Fund 11 Chart - Revenues, Expenditures & Working Capital12 Five-Year Project Summaries Projects by Year15 Department Summary18 Projects by Department19 Funding Source Summary22 Projects by Funding Source23 Equipment Requests Individual Equipment Request Details27 Activity Center29 Arts Center32 City Hall Administration37 Community Services 41 Fire 42 HRA57 Pavilion58 Police59 Public Works74 Refuse93 Sewer95 Water97 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department101 Equipment and Building Inventor y Building Inventory109 Vehicle and Equipment Inventory111 2 INTRODUCTION 3 4 EQUIPMENT REPLACEMENT PLAN 2015-2019 BACKGROUND AND SUMMARY OF CHANGES FROM 2014 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 $929,300. This is a 6.7% increase or $58,600 over the 2014 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 2014 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. 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 2015-2019 and plan to sell Equipment Certificates in 2017 to fund some of the equipment scheduled for 2016-2018. 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. The Equipment Replacement Plan’s basic premise is scheduled replacement of present equipment. A new item must, in the year proposed, be presented in the annual operating budget 5 with a stipulation that replacement will be necessary in the future. Flexibility of the Equipment Replacement Plan is established through annual review and revision, if necessary. Summary of Changes from 2014 Plan Highlights of changes from last year’s equipment replacement plan for the years 2015-2019: Activity Center: Sound system/public address system for $8,900 was added in 2015. The sound system is used throughout the facility and the current equipment does not work due to equipment failure. Tables for $12,200 were added for 2015. The Activity Center would like to add 23 tables to add depth to the type of activities they can accommodate. Arts Center: Video camera updates for $3,700 were added in 2015. The Arts Center would like to replace the front entry camera with a better resolution camera for security purposes along with adding cameras to other areas of the facility. A new floor scrubber for $8,000 was added in 2015. The current floor scrubber has reached its life expectancy and no longer performs efficiently. City Hall: Network server budget was increased by $7,000 to $15,000 due to the cost of replacing servers. Community Services: Document scanners previously in at $6,000 for 2017 and 2018 are now it at $10,000 for 2016 and are on a 4 year replacement cycle. Fire: The fire utility vehicle pickup used by the Fire Inspector was deleted. Plans are to lease a pick-up truck Two fire chief duty vehicles were added in 2015 and two were added in 2017. Plans are to lease all four duty chief vehicles. Cost to outfit each vehicle is also budget at $5,000 per vehicle in the year of the leases. These vehicles are used by the Chief, two Asst Chief’s and Duty Officer to respond to calls during their duty week to help assess what is happening and setting up command and establishing command and control. The Chief’s vehicles are also used for travel to meetings and Training outside the city. 6 The duty chief vehicle schedule in 2016 was deleted due to the lease proposal. The Telesquirt fire truck scheduled for 2017 has an increased cost of $79,100 for a total of $650,000. This vehicle will replace a 25 year vehicle that is currently being used for response. This vehicle due to its age is in need of replacement due to both age and on-going maintenance costs HRA No changes. Pavilion:Scoreboard for $12,000 was added in 2016. The scoreboard is used for hockey, soccer and lacrosse among other activities. The current scoreboard is original to building and was purchased in 1990. Parking: No changes. Police:The leases for the chief’s, captains, DTF and school resource officer cars was adjusted to actual. The original amount budgeted was an estimate of the lease and once they department selected a vehicle actual costs were known. The school resource officer car was formerly the FOCUS car. Digital squad cameras scheduled for 2015 at a cost of $53,400 and mobile data computers scheduled for 2014 at a cost of $62,700 have been combined into one unit. The total cost estimated at $116,100 is now $148,500 and are requested for 2014. Due to changes in equipment the Police Department feels this is a better option and will save money in the long run. The two items were in the plan on a 5 year replacement schedule and the new equipment will be on an 8-10 year replacement schedule. The cost for the mobile radios for the new squads has been reduced to only account for the purchased squads. Leased squad outfitting is in a separate line item. This results in a savings of $16,400. The cost of the SWAT vehicle was increased by $20,000 to $50,000 due the cost of the vehicle. The vehicle was originally in at $30,000. Portable radios for police and fire have been moved from 2018 to 2017 as the current radios will not be supported after that date. Cost remains at $534,400 and staff is researching options for financing the acquisition of the radios. 7 Network server budget for the police was increased by $6,500 to $15,000 due to the cost of replacing servers. Building video server was added in 2015 with replacement scheduled for 2019. The 2015 cost will come from DUI funds and in the future from the ERP. Public Works: The lives of the equipment are annually reviewed by the public works department and over the past 10 years they have extended the lives of the 1-ton trucks from 8 to 12 years and the dump trucks from 13 to 17 years. Extending the lives of major equipment comes with the risk of increased maintenance costs. When maintenance costs become unmanageable the equipment will be put on the schedule for earlier replacement. Engineering No changes Building/Equipment Services No changes Parks/Forestry Added a grass seed applicator (overseeder) at a cost of $11,500. This item was previously in the ERP but not purchased and did not get rescheduled. Streets/Traffic A sign machine scheduled for 2015 was pushed back to 2016. A tandem dump truck originally scheduled for 2018 was pulled forward to 2017. Cost remains the same. Refuse A rear loading refuse truck scheduled for replacement in 2015 at a cost of $101,600 has been moved back to 2016. Water No changes Sewer No changes 8 CASH FLOW STATEMENTS 9 10 EQUIPMENT REPLACEMENT FUND (602)06/10/2014 evised R Impact on General Fund 24,81230,54933,00336,59239,562 ate Change R0%8%9%9%9%9%9% ACTUALBUDGETBUDGETBUDGETBUDGETBUDGETBUDGET 2013201420152016201720182019 Working Capital Begin Year1,084,439(82,843)83,982(57,464) 7 26,160 3 84,854 3 04,844 Revenues from charges320,157532,009 3 45,770 3 76,889 4 10,809 4 47,782 4 88,082 Tax Levy per FMP138,563326,713 Transfer in General Fund50,000 5 0,000 5 0,000 5 0,000 Transfer In - Pavilion - Capital Lease15,609 Transfer In - Pavilion - Hockey Loan3,143 3 ,068 Interest earnings4,8433,855(22) 8 ,068 4 ,655 1 ,646 2 32 Net Incr (Decr) in FV of Investments(7,689) Other revenues (sale of assets)29,020 3 0,000 3 0,000 3 0,000 3 0,000 3 0,000 3 5,000 Equipment Certificates (Bonds)451,7691,601,700 Transfers In (Misc)23,580 Total Revenues840,432893,954 4 36,906 4 61,544 4 94,664 2 ,129,460 6 58,291 Expenditures (excludes Depr.) 32,726 3 3,708 3 4,719 3 5,761 3 6,833 3 7,938 3 9,077 Fire Truck Financing Pymnts (2009-2018)53,841 5 4,217 5 4,217 5 4,217 5 4,217 5 4,217 Capital Outlay - Equipment1,043,649386,856 6 90,288 4 52,618 7 92,374 1 ,871,585 5 84,207 2012 Equip Certificate Pymnts (10yr 3%)68,495 Total Expenses1,198,711549,308 7 78,212 5 41,554 8 82,351 1 ,962,635 7 99,737 Working Capital Ending Balance726,160(82,843)83,982(57,464)287,183 3 84,854 3 04,844 (cash + receivables - payables) Actual/Estimated Cash balances806,821367,844 465,514 385,505 (2,182) 164,643 23,197 11 ЋЉЊЉЋЉЊЊЋЉЊЋЋЉЊЌЋЉЊЍЋЉЊЎЋЉЊЏЋЉЊАЋЉЊБЋЉЊВ ƚƩƉźƓŭ /ğƦźƷğƌ ƚƷğƌ wĻǝĻƓǒĻƭ ƚƷğƌ 9ǣƦĻƓƭĻƭ ERP -Revenues, Expenses and Working Capital ΛЎЉЉͲЉЉЉΜ Ώ ЋͲЎЉЉͲЉЉЉ ЋͲЉЉЉͲЉЉЉ ЊͲЎЉЉͲЉЉЉ ЊͲЉЉЉͲЉЉЉ ЎЉЉͲЉЉЉ 12 FIVE-YEAR PROJECT SUMMARIES 13 14 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20152019 thru PROJECTS BY YEAR Project NameProject #Priority Project Cost Department 2015 Activity Center Sound System/Public Address Systemn/a8,800Activity Center Activity Center TablesActivity Centern/a12,200 Art Center Video Camera UpdatesArts Centern/a3,700 Art Center Community Room Audio VisualArts Centern/a11,000 Art Center Digital Information SignArts Center22,000 Art Center Floor ScrubberArts Centern/a8,000 Network ServerCity Hall Administrationn/a15,000 Telephone SystemCity Hall Administrationn/a89,600 ComputersCity Hall Administrationn/a30,000 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a19,606 Outfit Duty Chief Leased Vehicles (5)Firen/a10,000 Aerial TruckFiren/a54,217 Floor ScrubberFiren/a14,300 Workout Equipment - ElipticalFiren/a5,800 Workout Equipment - Treadmill #1Firen/a5,800 Workout Equipment - Weight LiftingFiren/a5,800 4x4 3/4 Ton TruckHRAn/a32,400 Marked Patrol Vehicles (6)Policen/a90,000 Sergeant's VehiclePolicen/a45,000 Police Administrative Vehicles (2)Policen/a11,923 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 Drug Task Force VehiclePolicen/a6,189 School Resource Officer CarPolicen/a6,000 School Resource Ofcr Car - outfit leased vehiclePolicen/a5,000 Network Server (3)Policen/a15,000 Radios - Portable and Mobile DevicesPolicen/a12,300 Building Video ServerPolicen/a17,000 Riding Mowers (2)Public Works: Parks/Forestryn/a11,000 Grass Seed Applicator (Overseeder)Public Works: Parks/Forestryn/a11,500 4X4 3/4 Ton Truck with PlowPublic Works: Streets/Trafficn/a30,400 Refuse Truck (RAP-R) (2)Refusen/a204,800 799,335 Total for 2015 2016 Network ServerCity Hall Administrationn/a15,000 ComputersCity Hall Administrationn/a30,000 Document Management Scanner (2)Community Servicesn/a10,000 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a19,606 Aerial TruckFiren/a54,217 Air CompressorFiren/a34,900 Self Contained Breathing Apparatus (SCBA) (45)n/a250,000Fire Pavilion Arena ScoreboardPavilionn/a12,000 Marked Patrol Vehicles (6)Policen/a90,000 Parking Enforcement Vehicle (Parking Fund)Policen/a27,200 Monday, June 16, 2014 15 Project NameProject #Priority Project Cost Department Police Administrative Vehicles (2)Policen/a16,794 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 SWAT VehiclePolicen/a50,000 Drug Task Force VehiclePolicen/a11,074 Drug Task Force Vehicle - outfit leased vehiclePolicen/a5,000 School Resource Officer CarPolicen/a6,000 Network Server (3)Policen/a15,000 Radios - Portable and Mobile DevicesPolicen/a4,100 Riding Mowers (2)Public Works: Parks/Forestryn/a20,000 Slope MowerPublic Works: Parks/Forestryn/a32,700 Skid Loader (2)Public Works: Streets/Trafficn/a41,900 RollerPublic Works: Streets/Trafficn/a45,900 Asphalt PaverPublic Works: Streets/Trafficn/a48,800 Sign Machine (Traffic)Public Works: Streets/Trafficn/a13,400 Refuse Truck (Rear-L)Refusen/a101,600 3/4 Ton Utility TruckSewern/a33,600 993,791 Total for 2016 2017 Network ServerCity Hall Administrationn/a15,000 ComputersCity Hall Administrationn/a30,000 Tele-Squirt (Engine 2)Firen/a650,000 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a32,707 Outfit Duty Chief Leased Vehicles (5)Firen/a10,000 Aerial TruckFiren/a54,217 Thermal Imaging Camera (2)Firen/a12,900 Workout Equipment - Treadmill #2Firen/a5,800 Workout Equipment - Dumb BellsFiren/a5,000 Marked Patrol Vehicles (6)Policen/a98,000 Police Administrative Vehicles (2)Policen/a21,999 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 Drug Task Force VehiclePolicen/a11,074 School Resource Officer CarPolicen/a11,205 School Resource Ofcr Car - outfit leased vehiclePolicen/a5,000 Network Server (3)Policen/a15,000 Radios - Portable and Mobile DevicesPolicen/a534,400 Taser ReplacementPolice320,900 Stump CutterPublic Works: Parks/Forestryn/a21,200 Skid LoaderPublic Works: Parks/Forestryn/a32,000 Tandem Dump TruckPublic Works: Streets/Trafficn/a173,200 Water TruckPublic Works: Streets/Trafficn/a150,000 StriperPublic Works: Streets/Trafficn/a11,200 Generator (2)Sewern/a26,400 1/2 Ton TruckWatern/a26,800 3/4 Ton Utility TruckWatern/a34,900 2,013,902 Total for 2017 2018 Art Center Theater ProjectorArts Centern/a17,100 Network ServerCity Hall Administrationn/a15,000 ComputersCity Hall Administrationn/a30,000 Core Network SwitchCity Hall Administrationn/a12,000 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a32,707 Aerial TruckFiren/a54,217 Automated External Defibrillator (2)Firen/a7,800 Monday, June 16, 2014 16 Project NameProject #Priority Project Cost Department Marked Patrol Vehicles (6)Policen/a98,000 Police Administrative Vehicles (2)Policen/a22,655 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 Drug Task Force VehiclePolicen/a11,740 Drug Task Force Vehicle - outfit leased vehiclePolicen/a5,000 School Resource Officer CarPolicen/a11,205 Network Server (3)Policen/a15,000 Tactical Ballistic VestsPolicen/a26,900 4X4 1/2 Ton TruckPublic Works: Bldg/Equip Servn/a31,300 Turf SweeperPublic Works: Parks/Forestryn/a18,000 ToolcatPublic Works: Parks/Forestryn/a63,300 4x2 1 Ton Dump TruckPublic Works: Streets/Trafficn/a54,600 Single Axle Dump Truck (3)Public Works: Streets/Trafficn/a124,000 655,524 Total for 2018 2019 Activity Center Refrigerator/FreezerActivity Centern/a1 Network ServerCity Hall Administrationn/a15,000 ComputersCity Hall Administrationn/a30,000 Fire/Duty Chief & Utility Leased Vehicles (5)Firen/a32,707 Outfit Duty Chief Leased Vehicles (5)Firen/a10,000 Extrication Tool (2)Firen/a27,400 Marked Patrol Vehicles (6)Policen/a98,000 Sergeant's VehiclePolicen/a50,600 Police Administrative Vehicles (2)Policen/a23,329 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 Drug Task Force VehiclePolicen/a11,740 School Resource Officer CarPolicen/a11,879 School Resource Ofcr Car - outfit leased vehiclePolicen/a5,000 Network Server (3)Policen/a15,000 Building Video ServerPolicen/a17,000 Trucksters (3)Public Works: Parks/Forestryn/a34,200 386,856 Total for 2019 4,849,408 GRAND TOTAL Monday, June 16, 2014 17 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20152019 thru DEPARTMENT SUMMARY Department20152016201720182019Total Activity Center21,0001 Arts Center24,70017,100 City Hall Administration134,60045,00045,00057,00045,000 Community Services10,000 Fire115,523358,723770,62494,72470,107 HRA32,400 Pavilion12,000 Police213,412230,168722,578195,500237,548 Public Works: Bldg/Equip Serv31,300 Public Works: Parks/Forestry22,50052,70053,20081,30034,200 Public Works: Streets/Traffic30,400150,000334,400178,600 Refuse204,800101,600 Sewer33,60026,400 Water61,700 799,335993,7912,013,902655,524386,856 TOTAL 18 Monday, June 16, 2014 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20152019 thru PROJECTS BY DEPARTMENT DepartmentProject#Priority20152016201720182019 Total Activity Center Activity Center Refrigerator/Freezern/a1 Activity Center Sound System/Public Address Systemn/a8,800 Activity Center Tablesn/a12,200 Activity Center Total Arts Center Art Center Video Camera Updatesn/a3,700 Art Center Theater Projectorn/a17,100 Art Center Community Room Audio Visualn/a11,000 Art Center Digital Information Sign22,000 Art Center Floor Scrubbern/a8,000 Arts Center Total City Hall Administration Network Servern/a15,00015,00015,00015,00015,000 Telephone Systemn/a89,600 Computersn/a30,00030,00030,00030,00030,000 Core Network Switchn/a12,000 City Hall Administration Total Community Services Document Management Scanner (2)n/a10,000 Community Services Total Fire Tele-Squirt (Engine 2)n/a650,000 Fire/Duty Chief & Utility Leased Vehicles (5)n/a19,60619,60632,70732,70732,707 Outfit Duty Chief Leased Vehicles (5)n/a10,00010,00010,000 Aerial Truckn/a54,21754,21754,21754,217 Air Compressorn/a34,900 Self Contained Breathing Apparatus (SCBA) (45)n/a250,000 Extrication Tool (2)n/a27,400 Thermal Imaging Camera (2)n/a12,900 Floor Scrubbern/a14,300 Workout Equipment - Elipticaln/a5,800 Workout Equipment - Treadmill #1n/a5,800 Workout Equipment - Treadmill #2n/a5,800 Workout Equipment - Weight Liftingn/a5,800 Automated External Defibrillator (2)n/a7,800 Workout Equipment - Dumb Bellsn/a5,000 19 Monday, June 16, 2014 DepartmentProject#Priority20152016201720182019 Total Fire Total HRA 4x4 3/4 Ton Truckn/a32,400 HRA Total Pavilion Pavilion Arena Scoreboardn/a12,000 Pavilion Total Police Marked Patrol Vehicles (6)n/a90,00090,00098,00098,00098,000 Sergeant's Vehiclen/a45,00050,600 Parking Enforcement Vehicle (Parking Fund)n/a27,200 Police Administrative Vehicles (2)n/a11,92316,79421,99922,65523,329 Police Admin Cars - outfit leased vehiclesn/a5,0005,0005,0005,0005,000 SWAT Vehiclen/a50,000 Drug Task Force Vehiclen/a6,18911,07411,07411,74011,740 Drug Task Force Vehicle - outfit leased vehiclen/a5,0005,000 School Resource Officer Carn/a6,0006,00011,20511,20511,879 School Resource Ofcr Car - outfit leased vehiclen/a5,0005,0005,000 Network Server (3)n/a15,00015,00015,00015,00015,000 Tactical Ballistic Vestsn/a26,900 Radios - Portable and Mobile Devicesn/a12,3004,100534,400 Taser Replacement320,900 Building Video Servern/a17,00017,000 Police Total Public Works: Bldg/Equip Serv 4X4 1/2 Ton Truckn/a31,300 Public Works: Bldg/Equip Serv Total Public Works: Parks/Forestry Trucksters (3)n/a34,200 Riding Mowers (2)n/a11,00020,000 Slope Mowern/a32,700 Turf Sweepern/a18,000 Stump Cuttern/a21,200 Skid Loadern/a32,000 Toolcatn/a63,300 Grass Seed Applicator (Overseeder)n/a11,500 Public Works: Parks/Forestry Total Public Works: Streets/Traffic 4X4 3/4 Ton Truck with Plown/a30,400 4x2 1 Ton Dump Truckn/a54,600 Single Axle Dump Truck (3)n/a124,000 Tandem Dump Truckn/a173,200 Water Truckn/a150,000 Skid Loader (2)n/a41,900 Rollern/a45,900 20 Monday, June 16, 2014 DepartmentProject#Priority20152016201720182019 Total Stripern/a11,200 Asphalt Pavern/a48,800 Sign Machine (Traffic)n/a13,400 Public Works: Streets/Traffic Total Refuse Refuse Truck (RAP-R) (2)n/a204,800 Refuse Truck (Rear-L)n/a101,600 Refuse Total Sewer 3/4 Ton Utility Truckn/a33,600 Generator (2)n/a26,400 Sewer Total Water 1/2 Ton Truckn/a26,800 3/4 Ton Utility Truckn/a34,900 Water Total GRAND TOTAL 21 Monday, June 16, 2014 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20152019 thru FUNDING SOURCE SUMMARY 20152016201720182019Total Source AC - Arts Center Fund24,70017,100 Bonds/Lease54,21754,21754,21754,217 Drug Task Force Funds17,000 Equipment Replacement Fund452,618792,3741,871,585584,207386,856 HRA - Housing and Redevelopment Authority32,400 PA - Pavilion Fund12,000 RF - Refuse Fund204,800101,600 SF - Sanitary Sewer Fund6,80033,60026,400 WF - Water Fund6,80061,700 799,335993,7912,013,902655,524386,856 GRAND TOTAL Monday, June 16, 2014 22 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20152019 thru PROJECTS BY FUNDING SOURCE SourceProject#Priority20152016201720182019Total AC - Arts Center Fund Art Center Video Camera Updatesn/a3,700 Art Center Theater Projectorn/a17,100 Art Center Community Room Audio Visualn/a11,000 Art Center Digital Information Sign22,000 Art Center Floor Scrubbern/a8,000 AC - Arts Center Fund Total Bonds/Lease Aerial Truckn/a54,21754,21754,21754,217 Bonds/Lease Total Drug Task Force Funds Building Video Servern/a17,000 Drug Task Force Funds Total Equipment Replacement Fund Network Servern/a15,00015,00015,00015,00015,000 Telephone Systemn/a76,000 Computersn/a30,00030,00030,00030,00030,000 Document Management Scanner (2)n/a10,000 Core Network Switchn/a12,000 Activity Center Refrigerator/Freezern/a1 Activity Center Sound System/Public Address Systemn/a8,800 Activity Center Tablesn/a12,200 Tele-Squirt (Engine 2)n/a650,000 Fire/Duty Chief & Utility Leased Vehicles (5)n/a19,60619,60632,70732,70732,707 Outfit Duty Chief Leased Vehicles (5)n/a10,00010,00010,000 Air Compressorn/a34,900 Self Contained Breathing Apparatus (SCBA) (45)n/a250,000 Extrication Tool (2)n/a27,400 Thermal Imaging Camera (2)n/a12,900 Floor Scrubbern/a14,300 Workout Equipment - Elipticaln/a5,800 Workout Equipment - Treadmill #1n/a5,800 Workout Equipment - Treadmill #2n/a5,800 Workout Equipment - Weight Liftingn/a5,800 Automated External Defibrillator (2)n/a7,800 Workout Equipment - Dumb Bellsn/a5,000 Marked Patrol Vehicles (6)n/a90,00090,00098,00098,00098,000 Sergeant's Vehiclen/a45,00050,600 Monday, June 16, 2014 23 SourceProect#Priorit20152016201720182019Total jy Parking Enforcement Vehicle (Parking Fund)n/a27,200 Police Administrative Vehicles (2)n/a11,92316,79421,99922,65523,329 Police Admin Cars - outfit leased vehiclesn/a5,0005,0005,0005,0005,000 SWAT Vehiclen/a50,000 Drug Task Force Vehiclen/a6,18911,07411,07411,74011,740 Drug Task Force Vehicle - outfit leased vehiclen/a5,0005,000 School Resource Officer Carn/a6,0006,00011,20511,20511,879 School Resource Ofcr Car - outfit leased vehiclen/a5,0005,0005,000 Network Server (3)n/a15,00015,00015,00015,00015,000 Tactical Ballistic Vestsn/a26,900 Radios - Portable and Mobile Devicesn/a12,3004,100534,400 Taser Replacement320,900 4X4 3/4 Ton Truck with Plown/a30,400 4x2 1 Ton Dump Truckn/a54,600 Single Axle Dump Truck (3)n/a124,000 Tandem Dump Truckn/a173,200 Water Truckn/a150,000 Skid Loader (2)n/a41,900 Rollern/a45,900 Stripern/a11,200 Asphalt Pavern/a48,800 Sign Machine (Traffic)n/a13,400 4X4 1/2 Ton Truckn/a31,300 Trucksters (3)n/a34,200 Riding Mowers (2)n/a11,00020,000 Slope Mowern/a32,700 Turf Sweepern/a18,000 Stump Cuttern/a21,200 Skid Loadern/a32,000 Toolcatn/a63,300 Grass Seed Applicator (Overseeder)n/a11,500 Building Video Servern/a17,000 Equipment Replacement Fund Total HRA - Housing and Redevelopment A 4x4 3/4 Ton Truckn/a32,400 HRA - Housing and Redevelopment Authority Total PA - Pavilion Fund Pavilion Arena Scoreboardn/a12,000 PA - Pavilion Fund Total RF - Refuse Fund Refuse Truck (RAP-R) (2)n/a204,800 Refuse Truck (Rear-L)n/a101,600 RF - Refuse Fund Total SF - Sanitary Sewer Fund Telephone Systemn/a6,800 Monday, June 16, 2014 24 SourceProect#Priorit20152016201720182019Total jy 3/4 Ton Utility Truckn/a33,600 Generator (2)n/a26,400 SF - Sanitary Sewer Fund Total WF - Water Fund Telephone Systemn/a6,800 1/2 Ton Truckn/a26,800 3/4 Ton Utility Truckn/a34,900 WF - Water Fund Total GRAND TOTAL Monday, June 16, 2014 25 26 EQUIPMENT REQUESTS 27 28 EQUIPMENT REPLACEMENT PLAN 20152019 thru Department Activity Center Cit of HokinsMN yp, ContactFacilities Director Type Equipment 01-ERP-0031 Project # Useful Life 30 years Activity Center Refrigerator/Freezer Project Name Category Equipment FuturePriorityn/a Total Project Cost:$10,501 Description Commerical, stainless steel refrigerator and freezer. Justification Cooling/freezing needed for programs or by use of the participants and their activities. Present unit was here when activity center opened in 1980. This unit was part of the old South Jr. High cafeteria kitchen. The unit continues to have problems due to the age of the unit. PriorExpendituresTotal 20152016201720182019 Equipment 11 10,500 TotalTotal PriorFunding Sources20152016201720182019Total 11 10,500 Equipment Replacement Fund TotalTotal Budget Impact/Other Variance from 20 year plan - Delayed indefinetly. Will use and repair as necessary. Estimate salvage/resale value on replaced item: $-0- Monday, June 16, 2014 29 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentActivity Center Cit of Hokins MN yp, Contact Facilities Director Type Equipment 01-ERP-0032 Project # Useful Life 15 years Activity Center Sound System/Public Address System Project Name Category Equipment FuturePriorityn/a Total Project Cost:$22,500 Description All new equipment to allow for sound in every room as well as the public address system in the gymnasium and Raspberry Room. Justification Our current sound system does not work due to equipment failure as well as our PA system in our gymnasium no longer works due to equipment failure. The sound system was installed shortly after we opened in 1980 and the PA system was upgraded in 1990, but has now failed. The Raspberry Room is now being used more and more for lectures and classroom type activities and we would like to improve the system we currently use in there. ExpendituresTotalFuture 20152016201720182019 Equipment 8,8008,800 13,700 TotalTotal Funding Sources20152016201720182019TotalFuture 8,8008,800 Equipment Replacement Fund 13,700 TotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced items: $ -0- Monday, June 16, 2014 30 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentActivity Center Cit of Hokins MN yp, Contact Facilities Director Type Equipment 01-ERP-0033 Project # Useful Life 15 years Activity Center Tables Project Name Category Equipment FuturePriorityn/a Total Project Cost:$31,200 Description 23 tables - 6' x 24" mobile, multiple use, folding tables @$475 each Justification This type of table will add depth to the type of activities we can accommodate at the Activity Center. It will help cut staff time taken to setting up and resetting up rooms for varying types of activities that occur. For instance, we set up the Raspberry Room for a class very differently than we do for an anniversary reception. ExpendituresTotalFuture 20152016201720182019 Equipment 12,20012,200 19,000 TotalTotal Funding Sources20152016201720182019TotalFuture 12,20012,200 Equipment Replacement Fund 19,000 TotalTotal Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced items: $ Monday, June 16, 2014 31 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$22,000 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 20152016201720182019Future Equipment 3,7003,700 3,20015,100 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 3,7003,700 3,200 AC - Arts Center Fund 15,100 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move up from 2017 to 2015. Estimate salvage/resale value on replaced item: $-0- Monday, June 16, 2014 32 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$75,000 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 capatabilities to run our own programs in a professional manner. Year 2018: $17,100 Year 2023 $19,800 Year 2028 $22,900 PriorExpenditures20152016201720182019TotalFuture Equipment 17,10017,100 15,20042,700 TotalTotalTotal PriorFunding Sources20152016201720182019Total Future 17,10017,100 15,200 AC - Arts Center Fund 42,700 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. Monday, June 16, 2014 33 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Director Type Equipment 01-ERP-1105 Project # Useful Life 7 years Art Center Community Room Audio Visual Project Name Category Equipment FuturePriorityn/a Total Project Cost:$41,100 Description Install a projector in a ceiling mount. Wire speakers into the ceiling. Wire input for computer on front wall. Add two microphones. Mount supporting hardware in rack that fits into closet. Justification An increasing number of users of this room require media support. Current means of providing this include the use of an oversized A/V cart, cords stretch across the floor and a large speaker on a stick. We can streamline the appearance and functionality by making these appropriate changes. These changes also address safety concerns. They will help attract safety concerns. They will help attract and retain rental customers as well as appropriately support our own activities. ExpendituresTotalFuture 20152016201720182019 Equipment 11,00011,000 30,100 TotalTotal Funding Sources20152016201720182019TotalFuture 11,00011,000 AC - Arts Center Fund 30,100 TotalTotal Budget Impact/Other Move this item from 2014 to 2015. Monday, June 16, 2014 34 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$10,100 Description Add programmable and highly visable 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. ExpendituresTotalFuture 20152016201720182019 Equipment 2,0002,000 8,100 TotalTotal Funding Sources20152016201720182019TotalFuture 2,0002,000 AC - Arts Center Fund 8,100 TotalTotal Budget Impact/Other Variance from 20 year plan - New Item Estimated salvage/resale value $0 Monday, June 16, 2014 35 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Co-Director Type Equipment 01-ERP-1109 Project # Useful Life 10 years Art Center Floor Scrubber Project Name Category Equipment FuturePriorityn/a Total Project Cost:$18,800 Description 26-inch autoscrubber Justification Current scrubber has reached its lifetime and no longer spins fast enough to be effective. ExpendituresTotalFuture 20152016201720182019 Equipment 8,0008,000 10,800 TotalTotal Funding Sources20152016201720182019TotalFuture 8,0008,000 AC - Arts Center Fund 10,800 TotalTotal Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $-0- Monday, June 16, 2014 36 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentCity Hall Administration Cit of Hokins MN yp, Contact Finance Director/IT Type Equipment 01-ERP-0003 Project # Useful Life 1 year Network Server Project Name Category Equipment FuturePriorityn/a Total Project Cost:$397,000 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 20152016201720182019Future Equipment 15,00015,00015,00015,00015,00075,000 97,000225,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 15,00015,00015,00015,00015,00075,000 97,000 Equipment Replacement Fund 225,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- Monday, June 16, 2014 37 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentCity Hall Administration Cit of Hokins MN yp, Contact IT Director Type Equipment 01-ERP-0004 Project # Useful Life 8 years Telephone System Project Name Category Equipment FuturePriorityn/a Total Project Cost:$349,900 Description Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) PriorExpendituresTotal 20152016201720182019Future Equipment 89,60089,600 60,000200,300 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 76,00076,000 60,000 Equipment Replacement Fund 200,300 6,8006,800 SF - Sanitary Sewer Fund TotalTotal 6,8006,800 WF - Water Fund Total Budget Impact/Other Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 38 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentCity Hall Administration 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 Total Project Cost:$1,020,000 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 20152016201720182019Future Equipment 30,00030,00030,00030,00030,000150,000 420,000450,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 30,00030,00030,00030,00030,000150,000 420,000 Equipment Replacement Fund 450,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Monday, June 16, 2014 39 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentCity Hall Administration 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 Total Project Cost:$53,300 Description Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates fibr 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 20152016201720182019Future Equipment 12,00012,000 10,00031,300 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 12,00012,000 10,000 Equipment Replacement Fund 31,300 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. Estimate salvage/resale value on replace item: - $-0- Monday, June 16, 2014 40 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$87,600 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 20152016201720182019Future Equipment 10,00010,000 23,30054,300 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 10,00010,000 23,300 Equipment Replacement Fund 54,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 Monday, June 16, 2014 41 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$1,523,500 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 20152016201720182019 Equipment 650,000650,000 873,500 TotalTotal Funding Sources20152016201720182019TotalFuture 650,000650,000 Equipment Replacement Fund 873,500 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: $ Monday, June 16, 2014 42 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$627,938 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 Asst Chief Mackey 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. Expenditures20152016201720182019TotalFuture 19,60619,60632,70732,70732,707137,333 Vehicles 490,605 TotalTotal Funding SourcesTotalFuture 20152016201720182019 19,60619,60632,70732,70732,707137,333 Equipment Replacement Fund 490,605 TotalTotal 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. Monday, June 16, 2014 43 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$100,000 Description Cost to outfit leased vehicles 2015 - lease one Ford F-150 utility vehicle 2015 - lease two Ford Explorers for duty crews 2017 - lease two Ford Explorers for Fire Chief and Asst. Fire Chief Justification Leased vehicles need to be outfitted for use by Fire Dept. ExpendituresTotalFuture 20152016201720182019 Vehicles 10,00010,00010,00030,000 70,000 TotalTotal Funding Sources20152016201720182019TotalFuture 10,00010,00010,00030,000 Equipment Replacement Fund 70,000 TotalTotal Budget Impact/Other Variance from 20 year plan - New item. Cost of outfitting new leased vehicles for Fire Dept. Monday, June 16, 2014 44 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$2,559,597 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 20152016201720182019Future Equipment 54,21754,21754,21754,217216,868 770,7291,572,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 54,21754,21754,21754,217216,868 770,729 Bonds/Lease 1,572,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 45 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$89,300 Description The air compressor is used to fill breathing apparatus that has been used by Fire personnel after training and fires. Justification ExpendituresTotalFuture 20152016201720182019 Equipment 34,90034,900 54,400 TotalTotal Funding Sources20152016201720182019TotalFuture 34,90034,900 Equipment Replacement Fund 54,400 TotalTotal Budget Impact/Other Variance from 20 year plan - move back to 2017 Estimate salvage/resale value on replaced item - $ Purchased: 1996 Monday, June 16, 2014 46 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0108 Project # Useful Life 10 years Self Contained Breathing Apparatus (SCBA) (45) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$752,000 Description Breathing apparatus for interior firefighting for firefighters. Justification The breathing apparatus was taken out of the ERP in 2006 because we thought we were getting a grant. Grant was not successful. The SCBA's (45) need to be replaced because they are at the end of their life and cannot be hydro tested any longer. PriorExpendituresTotal 20152016201720182019Future Equipment 250,000250,000 166,000336,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 250,000250,000 166,000 Equipment Replacement Fund 336,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 47 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$177,200 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 wil be added to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. PriorExpendituresTotal 20152016201720182019Future Equipment 27,40027,400 42,600107,200 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 27,40027,400 42,600 Equipment Replacement Fund 107,200 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 Monday, June 16, 2014 48 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$92,900 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 20152016201720182019Future Equipment 12,90012,900 26,50053,500 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 12,90012,900 26,500 Equipment Replacement Fund 53,500 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - department owns 2 cameras. Previously one 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 repalced item: $-0- Monday, June 16, 2014 49 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0114 Project # Useful Life 12 years Floor Scrubber Project Name Category Equipment FuturePriorityn/a Total Project Cost:$34,600 Description Floor scrubber to keep apparatus floors clean. Current equipment: 2004 Tennant 5400 Justification Scrubber is used to keep apparatus floors clean so that floor will last longer. ExpendituresTotalFuture 20152016201720182019 Equipment 14,30014,300 20,300 TotalTotal Funding Sources20152016201720182019TotalFuture 14,30014,300 Equipment Replacement Fund 20,300 TotalTotal Budget Impact/Other Variance from 20 year plan - Eliminate sweeper and add scrubber as scrubber is used more. Move from 2016 to 2015 Estimate salvage/resale value on replaced item: $0 Monday, June 16, 2014 50 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0116 Project # Useful Life 6 years Workout Equipment - Eliptical Project Name Category Equipment FuturePriorityn/a Total Project Cost:$29,600 Description Workout equipment used in Fire Department workout room. One eliptical machine replaced on a 6 year cycle, one every 3 years. Justification This equipment is available to all City employees for health and wellness. ExpendituresTotalFuture 20152016201720182019 Equipment 5,8005,800 23,800 TotalTotal Funding Sources20152016201720182019TotalFuture 5,8005,800 Equipment Replacement Fund 23,800 TotalTotal Budget Impact/Other Variance from 20 year plan - had two eliptical machines in the ERP. One was replaced along with the stairmaster with a summit trainer. The remaining eliptical is scheduled for replacement in 2015. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 51 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$34,300 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 20152016201720182019Future Equipment 5,8005,800 5,00023,500 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 5,8005,800 5,000 Equipment Replacement Fund 23,500 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - replaces stairmaster. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 52 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$34,300 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 20152016201720182019Future Equipment 5,8005,800 5,00023,500 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 5,8005,800 5,000 Equipment Replacement Fund 23,500 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back one year from 2011 to 2012. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 53 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$29,300 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. ExpendituresTotalFuture 20152016201720182019 Equipment 5,8005,800 23,500 TotalTotal Funding Sources20152016201720182019TotalFuture 5,8005,800 Equipment Replacement Fund 23,500 TotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2011 to 2015 Estimate salvage/resale value on replaced items: $ Monday, June 16, 2014 54 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$60,600 Description Defibrillator is used to help get someones 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 PriorExpenditures20152016201720182019TotalFuture Equipment 7,8007,800 13,20039,600 TotalTotalTotal PriorFunding Sources20152016201720182019Total Future 7,8007,800 13,200 Equipment Replacement Fund 39,600 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - adjustment from 3 years to 4 years. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 55 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$11,700 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 20152016201720182019 Equipment 5,0005,000 6,700 TotalTotal Funding Sources20152016201720182019TotalFuture 5,0005,000 Equipment Replacement Fund 6,700 TotalTotal Budget Impact/Other Variance from 20 year plan - Move back from 2014 to 2017. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 56 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentHRA Cit of Hokins MN yp, Contact Unassigned Type Equipment 01-ERP-0400 Project # Useful Life 8 years 4x4 3/4 Ton Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$148,400 Description 4 wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snow plow. Current vehicle: 2007 Chevrolet Pickup Justification Transportation for Public Housing Superintendent and snow plowing at various HRA properties around the city. PriorExpendituresTotal 20152016201720182019Future Vehicles 32,40032,400 22,80093,200 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 32,40032,400 22,800 HRA - Housing and 93,200 Redevelopment Authority TotalTotal Total Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,800 Monday, June 16, 2014 57 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPavilion Cit of Hokins MN yp, Contact Facilities Director Type Equipment 01-ERP-1002 Project # Useful Life 20 years Pavilion Arena Scoreboard Project Name Category Equipment FuturePriorityn/a Total Project Cost:$12,000 Description Arena scoreboard used for hockey, lacrosse, soccer and other activities in the arena. Justification The current scoreboard was purchased and installed during the original construction of the Pavilion in 1990. The current scoreboard is outdated and is hard to find qualified repair personnel and replacement parts. ExpendituresTotal 20152016201720182019 Equipment 12,00012,000 Total Funding Sources20152016201720182019Total 12,00012,000 PA - Pavilion Fund Total Budget Impact/Other Variance from 20 year plan - New item Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 58 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$3,279,900 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: (3) 2011 Ford Crown Victorias, (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria 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 20152016201720182019Future Vehicles 90,00090,00098,00098,00098,000474,000 868,1001,937,800 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 90,00090,00098,00098,00098,000474,000 868,100 Equipment Replacement Fund 1,937,800 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 Monday, June 16, 2014 59 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$322,200 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: 2011 Ford Crown Victoria 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 20152016201720182019Future Vehicles 45,00050,60095,600 33,600193,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 45,00050,60095,600 33,600 Equipment Replacement Fund 193,000 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 Monday, June 16, 2014 60 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$82,500 Description Parking enforcement vehicle. 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. PriorExpendituresTotal 20152016201720182019Future Vehicles 27,20027,200 18,70036,600 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 27,20027,200 18,700 Equipment Replacement Fund 36,600 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - amount allocated is not sufficient. Increase to $27,200. Estimate salvage/resale value on replaced item: $1,500 Monday, June 16, 2014 61 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$846,913 Description Police administration (chief, captian), Investigative Sergeant, 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 Investigative Sergeant. In year 3 the Chief will get a new leased vehicle and use for two years before again passing the vehicle down to the Investigative Sergeant who will use it for another 2 years. Effective 2015 - Captain vehcile to be leaed for 4 years - 2yr for captain and 2yr for Detective #3. In year 3 of lease the Capitain will get a new leased vehicle, use for 2 years before passing down to Detective #3 who will use it for another two years. There are 4 leased vehicles accounted for in this ERP item Current vehicles: 2013 Ford Taurus, 2011 Ford Taurus (#216) Justification Unmarked vehicles, equipped with radios, siren and red grille lites used by chief and captain. Staff use is for two years. Vehicles are then rotated down to detectives and are kept for an additional 3-4 years. Vehicles are also used for surveillance by uniform and plain clothes officers. PriorExpenditures20152016201720182019TotalFuture 11,92316,79421,99922,65523,32996,700 303,394 Vehicles 446,819 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 11,92316,79421,99922,65523,32996,700 303,394 Equipment Replacement Fund 446,819 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - starting in 2014 chiefs vehcile will be leased and in 2015 the captians will be leased. Estimate salvage/resale value on replaced item: $4,000 each for current vehicles not leased. Monday, June 16, 2014 62 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$105,000 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 - investigative sergeant 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 20152016201720182019Future Equipment 5,0005,0005,0005,0005,00025,000 5,00075,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 5,0005,0005,0005,0005,00025,000 5,000 Equipment Replacement Fund 75,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. Monday, June 16, 2014 63 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$127,900 Description Unmarked van to transport police tactics team for high risk calls, training and mutual aid. SWAT - Special Weapons And Tatics Current vehicle: 1998 Chevrolet Cube Van (#240) Justification Previous vehicle (15 years old) was a safety hazard and was replaced in 2005. ExpendituresTotalFuture 20152016201720182019 Vehicles 50,00050,000 77,900 TotalTotal Funding Sources20152016201720182019TotalFuture 50,00050,000 Equipment Replacement Fund 77,900 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 Monday, June 16, 2014 64 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$284,951 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 20152016201720182019Future Vehicles 6,18911,07411,07411,74011,74051,817 4,694228,440 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 6,18911,07411,07411,74011,74051,817 4,694 Equipment Replacement Fund 228,440 TotalTotalTotal Budget Impact/Other Variance from 20 year plan: New for 2014 Monday, June 16, 2014 65 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$55,000 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 20152016201720182019Future Equipment 5,0005,00010,000 5,00040,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 5,0005,00010,000 5,000 Equipment Replacement Fund 40,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 now leased. Monday, June 16, 2014 66 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0210 Project # Useful Life 4 years School Resource Officer Car Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$270,308 Description Focus Vehicle (Focus on Crime Using Strategies) Effective in 2015 this vehicle will be leased for 4 years 2 years as a Focus vehicle 2 years as Detective #2 vehicle (This accounts for the lease for 2 vehicles) Justification This is the street crime/undercover vehicle. Previously did not have a car for this purpose. Expenditures20152016201720182019TotalFuture Equipment 6,0006,00011,20511,20511,87946,289 224,019 TotalTotal Funding Sources20152016201720182019TotalFuture 6,0006,00011,20511,20511,87946,289 Equipment Replacement Fund 224,019 TotalTotal Budget Impact/Other Variance from 20 year plan: New for 2015 Monday, June 16, 2014 67 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0210a Project # Useful Life School Resource Ofcr Car - outfit leased vehicle Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$50,000 Description Cost to outfit leased Focus vehicle Justification We need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. Focus vehicle will be replaced every 2 years with the 2nd two years of the lease going to a Detective ExpendituresTotalFuture 20152016201720182019 Equipment 5,0005,0005,00015,000 35,000 TotalTotal Funding Sources20152016201720182019TotalFuture 5,0005,0005,00015,000 Equipment Replacement Fund 35,000 TotalTotal Budget Impact/Other Variance from 20 year plan: Cost of outfitting Focus vehicle is now accounted for separately from the vehicle purchase since the vehicle is now now leased. Monday, June 16, 2014 68 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief/IT Type Equipment 01-ERP-0211 Project # Useful Life 3 years Network Server (3) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$402,000 Description Computer servers store information and system programs. One server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01-ERP-213) 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 20152016201720182019Future Equipment 15,00015,00015,00015,00015,00075,000 102,000225,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 15,00015,00015,00015,00015,00075,000 102,000 Equipment Replacement Fund 225,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 - $ Monday, June 16, 2014 69 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$179,500 Description Tactical ballistic vests worn by members of the Hopkins Police Department High-risk Entry and Assault Team (HEAT). These vests offer a higher level of protection against weapon assault than the regular duty ballistic vest. Current equipment: 11 - 2008 Titan Tactical Ballistic 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 2013. Cost: 11 vests PriorExpendituresTotal 20152016201720182019Future Equipment 26,90026,900 43,200109,400 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 26,90026,900 43,200 Equipment Replacement Fund 109,400 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Team membership has increased to 11. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 70 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0215 Project # Useful Life Radios - Portable and Mobile Devices Project Name Category Equipment FuturePriorityn/a Total Project Cost:$583,600 Description Portable and mobile radios used by the police, fire and public works departments to allow these departments to communicate on one frequency. Police and fire use their radios on a daily/regular basis. The public works only uses theirs in the event of an emergency. Estimated Replacement Cost (based on 2012 cost) Portable - $3,800 x 111 = $421,800 Mobile - $4,100 x 26 = $106,600 Total Radios $528,500 Installation of mobile $ 71,600 est Grand Total $600,000 target budget Police Fire PW Total Portable 65 46 0 111 PW radios went to Fire as PW wasn't using them. Mobile 17 9 0 26 Police Est Cost $363,500 Fire Est Cost $236,500 Pub Works Est Cost $ 0 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. Mobile radios were replaced in police cars due to new model cars: 2013 - replaced in Captain car, squad #3, & #5 (3 = $12,300) 2014 - replace in Squad #1, #2, PSO, Chief, DTF (5 = $20,500) 2015 - replace in squad #4, #6, Sergeant, (3 = $12,300) - Captian & Schl Res Ofcr funded through a different line item now that these vehicles are leased 2016 - replace in squad parking (1 = $4,100) note - some cars are duplicated as they are moved down to investigators PriorExpenditures20152016201720182019Total Equipment 12,3004,100534,400550,800 32,800 TotalTotal PriorFunding Sources20152016201720182019Total 12,3004,100534,400550,800 32,800 Equipment Replacement Fund TotalTotal Budget Impact/Other Variance from 20 year plan - Radio's have a 7-10 year life expectancy. Due to new squad models and the placement of the radios we needed to buy a new model of radio to fit into the squads.. Estimate salvage/resale value on replaced item: $0 Monday, June 16, 2014 71 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$119,300 Description The police department will need to replace all of its X26 Tasers (ECD) Electronic Control Devices including all software and HD Camera systems and transition to the new X2 Tasers. Justification The current Tasers will need to be replaced due to the age and use of the equipment. PriorExpendituresTotal 20152016201720182019Future Equipment 20,90020,900 18,60079,800 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 20,90020,900 18,600 Equipment Replacement Fund 79,800 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 Monday, June 16, 2014 72 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief/IT Type Equipment 01-ERP-218 Project # Useful Life 4 years Building Video Server Project Name Category Equipment FuturePriorityn/a Total Project Cost:$85,000 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 mimimize drive failure and take advantage of new storage technology. ExpendituresTotalFuture 20152016201720182019 Equipment 17,00017,00034,000 51,000 TotalTotal Funding Sources20152016201720182019TotalFuture 17,00017,000 Drug Task Force Funds 51,000 17,00017,000 Equipment Replacement Fund Total Total 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- Monday, June 16, 2014 73 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$96,700 Description Pickup used by various divisions of Public Works. Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. PriorExpendituresTotal 20152016201720182019Future Vehicles 31,30031,300 23,30042,100 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 31,30031,300 23,300 Equipment Replacement Fund 42,100 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 Monday, June 16, 2014 74 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$145,440 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), 2004 Toro Workman 2110 (#821) Justification Park maintenance, ballfield grooming and weed spraying. PriorExpendituresTotal 20152016201720182019Future Equipment 34,20034,200 40,90070,340 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 34,20034,200 40,900 Equipment Replacement Fund 70,340 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move from 2013 to 2014. Estimate salvage/resale value on replaced item: (3) $1,400 each Reduce to $11,000 to purchase a electric style workman. Monday, June 16, 2014 75 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$169,000 Description Riding mowers used by Parks Divison of Public Works. Current equipment: 2004 Toro Zero Turn (#826), 2006 Jacobson Rotary Mower (#823) Justification Mowing city parks and right of ways. PriorExpendituresTotal 20152016201720182019Future Equipment 11,00020,00031,000 49,00089,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 11,00020,00031,000 49,000 Equipment Replacement Fund 89,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 Monday, June 16, 2014 76 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0809 Project # Useful Life 15 years Slope Mower Project Name Category Equipment FuturePriorityn/a Total Project Cost:$83,600 Description Current equipment: 2001 DEW EZE ATM72 Slope Mower (#828) Justification Expenditures20152016201720182019TotalFuture Equipment 32,70032,700 50,900 TotalTotal Funding Sources20152016201720182019TotalFuture 32,70032,700 Equipment Replacement Fund 50,900 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Monday, June 16, 2014 77 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0811 Project # Useful Life 15 years Turf Sweeper Project Name Category Equipment FuturePriorityn/a Total Project Cost:$57,600 Description Turf sweeper used by Parks Division of Public Works. Justification Spring and fall leaf pick up, debris pick up. PriorExpendituresTotal 20152016201720182019Future Equipment 18,00018,000 11,60028,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 18,00018,000 11,600 Equipment Replacement Fund 28,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move from 2001 to 2003 - current unit in good condition. Estimate salvage/resale value on replaced item: $1,500 Monday, June 16, 2014 78 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$21,200 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 20152016201720182019 Equipment 21,20021,200 Total Funding Sources20152016201720182019Total Equipment Replacement Fund 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 Monday, June 16, 2014 79 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$77,600 Description Current equipment: 2004 Bobcat 463 (#833) Justification ExpendituresTotalFuture 20152016201720182019 Equipment 32,00032,000 45,600 TotalTotal Funding Sources20152016201720182019TotalFuture 32,00032,000 Equipment Replacement Fund 45,600 TotalTotal Budget Impact/Other Variance from 20 year plan - new item in 2004. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 80 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$295,100 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 20152016201720182019Future Equipment 63,30063,300 50,000181,800 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 63,30063,300 50,000 Equipment Replacement Fund 181,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item which replaces one tractor. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 81 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0817 Project # Useful Life 15 years Grass Seed Applicator (Overseeder) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$29,400 Description Pull behind overseeder used to seed grass into established turf areas to build thicker grass in athletic fields and fill in spots that thin from overuse. Justification Fields like Maetzold that are premier fields get constant use and require overseeding to maintain thick playable turf and non-irrigated fields such as Valley Park also benefit from a turf management plan that includes overseeding. Have been borrowing an overseeder from Minnetonka but run into use conflicts as both communities need the overseeder during the same period between seasons and missed opportunities to seed are opportunities lost until next season. ExpendituresTotalFuture 20152016201720182019 Equipment 11,50011,500 17,900 TotalTotal Funding Sources20152016201720182019TotalFuture 11,50011,500 Equipment Replacement Fund 17,900 TotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replace item: $-0- Monday, June 16, 2014 82 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$141,700 Description 3/4 ton pickup used by Street Divison 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 20152016201720182019Future Vehicles 30,40030,400 24,00087,300 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 30,40030,400 24,000 Equipment Replacement Fund 87,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Unit in good condition - move out 2 years. Estimate salvage/resale value on replaced item: $1,500 Monday, June 16, 2014 83 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$162,900 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 20152016201720182019Future Equipment 54,60054,600 30,50077,800 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 54,60054,600 30,500 Equipment Replacement Fund 77,800 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 Monday, June 16, 2014 84 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0305 Project # Useful Life 17 years Single Axle Dump Truck (3) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$674,100 Description Single axle dump truck used by various division of Public Works. Current vehicles: 2001 Ford L7501 (#313) & 2005 Freightliner M2 106 (#312) Justification Vehicle used for heavy hauling, snow plowing and sanding. Adding additional single axle truck in place of tandem truck from 01-ERP-306. PriorExpendituresTotal 20152016201720182019Future Vehicles 124,000124,000 207,400342,700 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 124,000124,000 207,400 Equipment Replacement Fund 342,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move 1 truck from tandem (was in 101-ERP-306) to single axle for 2012. Estimate salvage/resale value on replaced item: $4,500 each We would then have 3 single axel (chagne from 2) dump truck and 1 tandem axel dump truck. Monday, June 16, 2014 85 EQUIPMENT REPLACEMENT PLAN 20152019 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 Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$481,500 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. PriorExpendituresTotal 20152016201720182019Future Vehicles 173,200173,200 22,000286,300 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 173,200173,200 22,000 Equipment Replacement Fund 286,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move from 2018 to 2017. Estimate salvage/resale value on replaced item: $-0- Monday, June 16, 2014 86 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0307 Project # Useful Life 22 years Water Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$195,000 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 20152016201720182019 Vehicles 150,000150,000 45,000 TotalTotal PriorFunding Sources20152016201720182019Total 150,000150,000 45,000 Equipment Replacement Fund TotalTotal Budget Impact/Other Variance from 20 year plan - replace tanker only in 2010 - replace tanker, cab & chassis in 2017, tanker only again in 2032 and entire vehicle in 2039. Change to a 22 year life. Estimate salvage/resale value on replaced item: $8,500 Monday, June 16, 2014 87 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$258,900 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 20152016201720182019Future Equipment 41,90041,900 36,000181,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 41,90041,900 36,000 Equipment Replacement Fund 181,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2010 to 2011. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 88 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0312 Project # Useful Life 20 years Roller Project Name Category Equipment FuturePriorityn/a Total Project Cost:$127,900 Description Used by Street Department for asphalt repair and resurfacing. Current equipment: 1989 Ingersoll Rand Roller (#330) Justification ExpendituresTotalFuture 20152016201720182019 Equipment 45,90045,900 82,000 TotalTotal Funding Sources20152016201720182019TotalFuture 45,90045,900 Equipment Replacement Fund 82,000 TotalTotal Budget Impact/Other Variance from 20 year plan - Move back from 2014 to 2016. Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 89 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$27,200 Description Line striper. Current equipment: 1993 Line Striper A1990 (#352) Justification ExpendituresTotalFuture 20152016201720182019 Equipment 11,20011,200 16,000 TotalTotal Funding Sources20152016201720182019TotalFuture 11,20011,200 Equipment Replacement Fund 16,000 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 90 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0314 Project # Useful Life 20 years Asphalt Paver Project Name Category Equipment FuturePriorityn/a Total Project Cost:$138,800 Description Asphalt paver used by Streets Division of Public Works. Current equipment: 1994 Caterpillar AD200B Paver (#337) Justification Paving streets and parking lots. ExpendituresTotalFuture 20152016201720182019 Equipment 48,80048,800 90,000 TotalTotal Funding Sources20152016201720182019TotalFuture 48,80048,800 Equipment Replacement Fund 90,000 TotalTotal Budget Impact/Other Variance from 20 year plan. Move back from 2014 to 2015 Estimate salvage/resale value on replaced item: $500 Monday, June 16, 2014 91 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$31,500 Description Mahcine 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 20152016201720182019 Equipment 13,40013,400 18,100 TotalTotal Funding Sources20152016201720182019TotalFuture 13,40013,400 Equipment Replacement Fund 18,100 TotalTotal Budget Impact/Other Variance from 20 year plan - Move back to 2016 Estimate salvage/resale value on replaced item: $-0- Monday, June 16, 2014 92 EQUIPMENT REPLACEMENT PLAN 20152019 thru DepartmentRefuse Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0900 Project # Useful Life 10 years Refuse Truck (RAP-R) (2) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$1,462,600 Description Refuse truck used by Refuse Utility Division of Public Works. Curent vehicle: 2005 Peterbilt Rapid Rail (#901) & 2011 Freightliner Rapid Rail (#900) Justification Residential waste pick up. PriorExpendituresTotal 20152016201720182019Future Vehicles 204,800204,800 349,100908,700 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 204,800204,800 349,100 RF - Refuse Fund 908,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Monday, June 16, 2014 93 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$238,100 Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 1996 Freightliner FL70 (#903) Justification Residential waste pick up. ExpendituresTotalFuture 20152016201720182019 Vehicles 101,600101,600 136,500 TotalTotal Funding Sources20152016201720182019TotalFuture 101,600101,600 RF - Refuse Fund 136,500 TotalTotal Budget Impact/Other Variance from 20 year plan. Move back one year to evaluate needs. Estimate salvage/resale value on replaced item: $9,000 Monday, June 16, 2014 94 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$129,800 Description 3/4 ton utility truck used by the Water/Sewer Division of Public Works. Currrent 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 20152016201720182019Future Vehicles 33,60033,600 51,00045,200 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 33,60033,600 51,000 SF - Sanitary Sewer Fund 45,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Monday, June 16, 2014 95 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$49,400 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 20152016201720182019 Equipment 26,40026,400 23,000 TotalTotal Funding Sources20152016201720182019TotalFuture 26,40026,400 SF - Sanitary Sewer Fund 23,000 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Monday, June 16, 2014 96 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$83,300 Description Trucks used by Water Department. Current vehicle: 2007 Chevrolet Pickup Justification PriorExpendituresTotal 20152016201720182019Future Vehicles 26,80026,800 20,50036,000 TotalTotalTotal PriorFunding Sources20152016201720182019TotalFuture 26,80026,800 20,500 WF - Water Fund 36,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Monday, June 16, 2014 97 EQUIPMENT REPLACEMENT PLAN 20152019 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 Total Project Cost:$81,800 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 20152016201720182019 Vehicles 34,90034,900 46,900 TotalTotal Funding Sources20152016201720182019TotalFuture 34,90034,900 WF - Water Fund 46,900 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Monday, June 16, 2014 98 TWENTY-YEAR REPLACEMENT SCHEDULE 99 100 101 102 103 104 105 106 EQUIPMENT AND BUILDING INVENTORY 107 108 CITY OF HOPKINS BUILDING INVENTORY January 2014 Replacement Cost Location/Description City Hall & Police Statio$7,724,424 n 1010 1st Street S. Fire Statio4,496,359 n 101 17th Avenue S. 1,947,409 Hopkins Activity Cente r 33 14th Avenue S. Ice Arena/Pavilio5,347,585 n 11000 Excelsior Boulevard 7,325,210 Arts Cente r 1111 Mainstree t PW Admin/Garage7,649,942 11100 Excelsior Boulevard Moline Reservoir/Well #12,450,851 10421 Excelsor Boulevard Blake Tower Reservio1,478,791 r 151 Tyler Avenue South 3,603,386 Filtration Plan t 1401 Elmo Park Service Roa d Well #4 Workshop/Storag694,892 e 1401 Elmo Park Service Roa d Well #5244,181 1205 Highway7 Well #6325,588 801 Highway 7 69,461 Lift Station #2 - Drillan e 619 Drillane Road Lift Station #3 - Lindee'138,777 s 901 Cambridge Street N.E. 101,560 Lift Station #4 - LTL Meadowbroo k 244 Meadowbrook Roa d Lift Station #5 - Big Meadowbroo161,279 k 6601 Excelsior Blvd. 109 Location/DescriptionReplacement Cost Lift Station #6 - Ronnie'$101,560 s 8546 Excelsior Avenue E. 320,926 Lift Station #7 - Valle y 801 6th Avenue S. Band Shell - Downtown Par38,391 k 16 9th Avenue S. 159,010 Concession Stand - Maetzold Fiel d 1215 1st Street N. Park Building-Beach - Lifeguard171,586 s 5200 Shady Oak Road 162,152 Park Building-Beach-Concession s 5200 Shady Oak Road Park Shelter - Office/Bathhous393,880 e 5200 Shady Oak Road Park Shelter - Burnes52,405 201 Park Lane Park Building - Central118,960 101 17th Avenue S. 40,310 Park Building - Harle y 108 Jackson Avenue S. Park Shelter - Interlache64,423 n 220 Homedale Avenue Park Building - Oakes45,963 301 Tyler Avenue N. Park Building - Valle54,016 y 800 7th Avenue S. Parking Ramp6,650,133 10th Avenue and Mainstreet Depot Coffee House500,684 9451 Excelsior Boulevar d Overpass Skate Par8,009 k 100 Washington Avenue Studio305,000 20 Shady Oak Roa d Dow Towers (76 Units)HRA 22 5th Avenue S. 110 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTOR Y Januar 1, 2014 y UNIT #YEAMAKEMODELVALUE R FIRE DEPARTMENT 1002006DODGEDURANGO$28,300 1012003CHEVIMPALA24,900 102.1989FORDTELE-SQUIRT L9000240,000 103.2006PETERBILTPUMPER403,300 1042012FORDQUICK ATTACK PUMPER F550248,500 108.1995CHEV 4X4 LITE RESCUE25,000 1092008PIERCEAERO XT845,000 1102010CHEVROLETTAHOE30,000 115.1952MACKPUMPER4,000 POLICE DEPARTMENT 200.2010FORDCROWN VICTORIA$30,000 202.2011FORDCROWN VICTORIA31,000 205.2011FORDCROWN VICTORIA31,000 207.2014FORDEXPLORER47,500 208.2013FORDEXPLORER42,600 209.2011FORDCROWN VICTORIA31,000 211.2006JEEPLIBERTY18,800 212.2008CHEVTAHOE36,000 213.2010CHEVIMPALA26,000 214.2007DODGECHARGER28,000 215.2009CHEVIMPALA25,000 216.2011FORDTAURUS30,000 217.2008FORDTAURUS22,000 218.2013FORDINTERCEPTOR SUV37,200 219.2013FORDTAURUS27,500 229.2013FORDINTERCEPTOR 39,700 240.1998CHEVP40 VAN20,000 111 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTOR Y Januar 1, 2014 y UNIT #YEAMAKEMODELVALUE R STREET/TRAFFIC DIVISION 301.2013FORDF150$21,000 302.2006FORDF25026,500 304.2000FORDF45034,000 305.1997FORD1/2 TON 18,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 850086,000 316.1995FORDWATER TRK81,000 320.1991CATERPILLERLOADER 926E90,000 321.2012CATERPILLERLOADER 924K174,900 322.2005CATERPILLERLOADER 938G157,800 324.2004BOBCATSKID LOADER30,000 325.2011BOBCATSKID STEER LOADER38,000 326.1989CATERPILLAR140-G82,000 327.2001ELGINPELICAN SE105,000 328.2013ISUZUSTREET SWEEPER143,200 330.1989INGERSOL/RANDROLLER DD-2523,000 337.1994CATERPILLARBOX PAVER18,000 342.1991TARGETCONCRETE SAW2,400 344.1996SNOGOWK 80058,000 349.1989TRAIL-KINGTK6V-12003,000 350.1993TOWMASTERT144,000 351.2004TENNANTSWEEPER 364010,000 ENGINEERING DIVISIO N 700.2002CHEVTAHOE$26,000 705.2005CHEVIMPALA14,600 BUILDING MAINTENANCE & EQUIPMENT SERVICE S 701.2006FORD500$16,000 702.2004FORDF35023,000 704.2005FORDF25024,000 112 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTOR Y Januar 1, 2014 y UNIT #YEAMAKEMODELVALUE R PARKS/FORESTRY DIVISIO N 800.2013FORDF150$25,400 801.2012FORDF350 4X424,100 803.2004FORDF35023,000 804.1995CHEV1 TON BOOM16,000 805.1998DODGERAM 350024,000 810.1993INTERNATIONALLP 470050,000 811.2006INTERNATIONALLP 4600 LOG TRUCK45,000 812.2010FREIGHTLINERAERIAL LIFT130,000 815.2010BOBCATTOOLCAT50,000 818.1996TOROTRUCKSTER13,000 820.2004TOROWORKMAN 320015,000 821.2004TOROWORKMAN 21107,900 822.2001TORO325-D MOWER18,000 823.2006JACOBSONMOWER 10,000 824.1996TOROGROUND MASTER16,000 825.2010TORO4100D MOWER53,000 826.2004TOROZ587L8,900 828.2001DEW EZEATM7221,000 832.1997VERMEERSTUMP CTR 630A15,400 833.2004BOBCATSKID LOADER22,000 834.1993BRUSH BANDITCHIPPER 25014,000 836. RYANSOD CUTTER2,000 842.2011P.J.TRAILER5,300 844.2010FELLINGTRAILER4,000 845.1997REMACKELTRAILER5,000 846.2001DRESSEN81102,000 847.2011SPARKSTILT TRAILER5,300 HRA 411.2007CHEV2500 HD$17,500 WATER/SEWER 500.2007CHEVPICKUP$22,000 501.2004CHEV4X4 3/4 T SILVERADO19,000 502.1999DODGEDAKOTA 4X418,000 505.2007CHEVCC2575324,000 506.2006CHEVSILVERADO20,700 507.2001CHRYSLERPT CRUISER18,000 530.2001STERLINGVAC-CON180,000 533.2012CATERPILLAR420EH2 BACKHOE86,500 534.1997KOHLERGENERATOR/TRL11,000 535.1992KOHLERGENERATOR/TRL10,000 536.1989FLEXIBLERODDING MACHINE25,000 537.2010GENERATORC15130,000 540.2008LEROIAIR COMPRESSOR12,000 542.1994WACKERTAMPER4,000 113 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTOR Y Januar 1, 2014 y UNIT #YEAMAKEMODELVALUE R REFUSE 900.2011FREIGHTLINERRAPID-RAIL M2$211,800 901.2005PETERBILT320162,000 903.1995FREIGHTLINE RFL-7054,000 PAVILION 802.2012FORDF350$24,100 809.2003OLYMPIAICE RESURFACER85,000 114