Loading...
CR 2014-062 ERP for 2015-2019July 1, 2014A:a Council Report 2014-062 City of Hopkins 2015-2019 EQUIPMENT REPLACEMENT PLAN Proposed Action Staff recommends adoption of the following motion: Move to adopt the 2015-2019 Equipment Replacement Plan. Overview The equipment replacement plan is a detailed summary of the next five years of a twenty-year replacement schedule, for equipment of the City of Hopkins. General and Special Revenue fund equipment items are placed in the Equipment Replacement Fund budget which derives its revenues from service charges to the General and Special Revenue funds, equipment sales and interest earnings. The Art Center and Enterprise fund equipment in the plan is placed in the individual fund budgets, in the year in which the equipment is to be purchased. Approval of the 2015-2019 allows staff to incorporate the 2015 ERP items into the 2015 budgets and begin preparation for their purchase. Items that fall under the Minnesota Statutes Uniform Bidding/Contracting Laws will require further approval by the council before their purchase. Staff is recommending adoption of the plan. Primary Issues to Consider • Should the annual service charges to the general and special revenue funds be adjusted? • What changes have occurred in the equipment replacement plan since last year? Supporting Information • 2015-2019 ERP Power Point slides • 2015-2019 Equipment Replacement Plan Christine M. Harkess, CPA, CGFM Finance Director Financial Impact: $ as provided in plan Budgeted: Y/N X N Source: Various Related Documents (CIP, ERP, etc.): ERP Notes: Equipment Replacement Plan 2015-2019 ERP Background • The city has established an equipment replacement plan that is reviewed and adjusted on an annual basis. • The purpose of the plan was to smooth out the funding of large pieces of equipment. In the past this allowed the City to avoid bonding for purchases thereby saving interest costs. • The purchase of the ladder truck in 2008 was the first time apiece of equipment needed to be financed. This truck will be paid off in 2018. • Equipment certificates were sold in 2013 to fund equipment needs in 2013 and 2014. Minnesota • The cost of equipment is allocated back to the user departments based on life expectancy and cost of the equipment. • A 9% increase to the charge is planned for 2015. • Impact of increase to the General Fund is $30,000 • Increases in the charge are planned for future years • Bond Issue planned for 2017 • Grants are and will be applied for ERP Future • Revenues in the Equipment Replacement fund are derived from charges to city departments that use the equipment - mainly the General Fund. • Cash flow projections are updated annually to ensure adequate funds for scheduled replacements. • Funding challenges are foreseen in the future and alternative options have been explored. - Equipment Certificates for some 2016-2018 purchases - Equipment Certificates maybe sold in 2017 OJ- 11opkim innesota Revenue, Capital Expenditures and Cash Variances �inthonsa�ds, 2500 2000 L 1500 ■ Revenue 1000 ■ Capital Expend. o Cash 500 0 2012 2013 2014 2015 2016 2917 2018 2019 -500 PArtnenng WATh the COMMunitc to ClIKUKs the 9WRInY of 1A. c a 1rnv+Ge • C.a+vvnrxiei�i+k dEMIL 2015 ERP • In 2015 the city is planning on leasing, replacing or upgrading ten vehicles and two pieces of equipment. • All vehicles and equipment are reviewed annually and useful lives adjusted while maintaining the integrity, reliability and safety of the vehicles, equipment and employees. • Purchases are made based upon the condition of the equipment, not simply on the ERP Schedule. Gill. ol- kins w Minnesota • Sound system/Public Address System • Tables f City Hall Equipment • Telephone system is due for replacement • Annually the city replaces a portion of its obsolete computers with newer technology. - This includes both computers and servers in all city departments �9I71'S25Dt3 • The fire department annually assess its fleet and adjusts the useful lives of the equipment accordingly. • 2008 Aerial Ladder Lease Payment - 10 year lease at $54,217 annually • Items scheduled for replacementA - Duty Chief Vehicles to be leased_ - Workout equipment - Floor Scrubber Police Equipment • Marked patrol cars (2) • Sergeant's vehicle • Leased Vehicles - Administration (2) - Drug Task Force - School Resource Officer • Radios for leased vehicles • Network server • Building Video Server City olopkim Minnesota - e Streets Department Public Works - 4x4 3/4 Ton Truck with Plow Equipment Public Works ' Equipment • Forestry - Riding Mower - Grass Seed Overseeder �-, City ol- `� K14 apkins • Refuse - Refuse Truck Public Works Equipment Arts Center Equipment • Video Camera Updates • Community Room Audio Visual • Digital Information Sign • Floor Scrubber MPT Gill. ol- kim v Minnesota • The Equipment Replacement Plan is a valuable tool used to assess, plan and fund future equipment needs of the City. • In the past by annually evaluating equipment and adjusting useful lives where practical, the city has been able to maintain the reserves in this fund to cover equipment • Maintaining adequate funding for future needs continues to be a challenge. • Equipment certificates will need to be sold for future purchases • Transfers and tax levy are scheduled. City of Hopkins EQUIPMENT REPLACEMENT PLAN 2015-2019 t l - A -W-A City or Hops 13200City of q1opk ns 1010 Fast Street South • Hopky: w 55343-7573 * Pham:952-935-8474 • FaX. 952-935-1834 - Web address: www.hop(tinsmn.com DATE: July 2014 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2015-2019 EQUIPMENT REPLACEMENT PLAN 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. Partnering with the Community to Enhance the Quality of Life + Inspire • Educate • Involve • Communicate � 1 EQUIPMENT REPLACEMENT PLAN 2015-2019 TABLE OF CONTENTS Paqe City Manager's Message Table of Contents 2 Introduction Background and Summary of Changes from 2013 Plan 5 Cash Flow Statements Equipment Replacement Fund 11 Chart - Revenues, Expenditures & Working Capital 12 Five -Year Project Summaries Projects by Year 15 Department Summary 18 Projects by Department 19 Funding Source Summary 22 Projects by Funding Source 23 Equipment Requests Individual Equipment Request Details 27 Activity Center 29 Arts Center 32 City Hall Administration 37 Community Services 41 Fire 42 HRA 57 Pavilion 58 Police 59 Public Works 74 Refuse 93 Sewer 95 Water 97 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 101 Equipment and Building Inventory Building Inventory 109 Vehicle and Equipment Inventory 111 `, INTRODUCTION City or Hops 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 (IMP) completed in 2014. The IMP 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 67 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. VA 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 --qca City or Hops Ilt is EQUIPMENT REPLACEMENT FUND (602) 06/10/2014 Revised Impact on General Fund 24,812 30,549 33,003 36,592 39,562 Rate Change 0% 8% 9% 9% 9% 9% 9% ACTUAL BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 2013 2014 2015 2016 2017 2018 2019 Working Capital Begin Year 1,084,439 726,160 384,854 304,844 (82,843) 83,982 (57,464) Revenues from charges 320,157 345,770 376,889 410,809 447,782 488,082 532,009 Tax Levy per IMP 138,563 326,713 Transfer in General Fund 50,000 50,000 50,000 50,000 Transfer In - Pavilion - Capital Lease 15,609 Transfer In - Pavilion - Hockey Loan 3,143 3,068 Interest earnings 4,843 8,068 4,655 3,855 (22) 1,646 232 Net Incr (Deer) in FV of Investments (7,689) Other revenues (sale of assets) 29,020 30,000 30,000 30,000 30,000 30,000 35,000 Equipment Certificates (Bonds) 451,769 1,601,700 Transfers In (Mise) 23,580 Total Revenues 840,432 436,906 461,544 494,664 2,129,460 658,291 893,954 Expenditures (excludes Depr.) 32,726 33,708 34,719 35,761 36,833 37,938 39,077 Fire Truck Financing Pymnts (2009-2018) 53,841 54,217 54,217 54,217 54,217 54,217 Capital Outlay - Equipment 1,043,649 690,288 452,618 792,374 1,871,585 584,207 386,856 2012 Equip Certificate Pymnts (10yr 3%) 68,495 Total Expenses 1,1989711 778,212 541,554 8829351 199629635 799,737 549,308 Working Capital Ending Balance 7269160 384,854 304,844 (829843) 839982 (579464) 2879183 (cash + receivables - payables) ActuallEstimated Cash balances 806,821 465,514 385,505 (2,182) 164,643 23,197 367,844 is I�� rn O N m N a) a+ M Q C C M U � Q aA o�C w C: W _ ra _ ra � O + O N H 0 H n c-I O N �V lD ^� YL C) O N V C Ln O i N O f0 0 p N N N i m CL r-I p X N W � N C) a o N N W ^I NO C) y I N O O O O O p O O O O O p O O O O O O Lr O Ln O Ln Lf1 N N r cI v I�� FIVE-YEAR PROJECT SUMMARIES 13 --qca City or Hops 14 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2015 thru 2019 PROJECTS BY YEAR Project Name Department Project # Priority Project Cost 2015 Activity Center Sound System/Public Address System Activity Center 09 -ERP -0032 n/a 8,800 Activity Center Tables Activity Center 09 -ERP -0033 n/a 12,200 Art Center Video Camera Updates Arts Center 09 -ERP -9903 n/a 3,700 Art Center Community Room Audio Visual Arts Center 09 -ERP- 9 905 n/a 11,000 Art Center Digital Information Sign Arts Center 09 -ERP- 9906 2 2,000 Art Center Floor Scrubber Arts Center 09 -ERP- 9909 n/a 8,000 Network Server City Hall Administration 09 -ERP -0003 n/a 15,000 Telephone System City Hall Administration 09 -ERP -0004 n/a 89,600 Computers City Hall Administration 09 -ERP -0006 n/a 30,000 Fire/Duty Chief & Utility Leased Vehicles (5) Fire 09 -ERP -0903a n/a 19,606 Outfit Duty Chief Leased Vehicles (5) Fire 09 -ERP -0903b n/a 10,000 Aerial Truck Fire 09 -ERP -0906 n/a 54,217 Floor Scrubber Fire 09 -ERP -0994 n/a 14,300 Workout Equipment - Eliptical Fire 09 -ERP -0996 n/a 5,800 Workout Equipment - Treadmill #1 Fire 09 -ERP -0197 n/a 5,800 Workout Equipment - Weight Lifting Fire 09 -ERP -0999 n/a 5,800 44 3/4 Ton Truck HRA 09 -ERP -0400 n/a 32,400 Marked Patrol Vehicles (6) Police 09 -ERP -0200 n/a 90,000 Sergeants Vehicle Police 09 -ERP -0209 n/a 45,000 Police Administrative Vehicles (2) Police 09 -ERP -0204 n/a 11,923 Police Admin Cars - outfit leased vehicles Police 09 -ERP -0204a n/a 5,000 Drug Task Force Vehicle Police 09 -ERP -0206 n/a 6,189 School Resource Officer Car Police 09 -ERP -0290 n/a 6,000 School Resource Ofcr Car - outfit leased vehicle Police 09 -ERP -0290a n/a 5,000 Network Server (3) Police 09 -ERP -0299 n/a 15,000 Radios - Portable and Mobile Devices Police 09 -ERP -0295 n/a 12,300 Building Video Server Police 09 -ERP -298 n/a 17,000 Riding Mowers (2) Public Works: Parks/Forestry 09 -ERP -0808 n/a 11,000 Grass Seed Applicator (Overseeder) Public Works: Parks/Forestry 09 -ERP -0897 n/a 11,500 4X4 3/4 Ton Truck with Plow Public Works: Streets/Traffic 09 -ERP -0309 n/a 30,400 Refuse Truck (RAP -R) (2) Refuse 09 -ERP -0900 n/a 204,800 Total for 2015 799,335 2016 Network Server City Hall Administration 09 -ERP -0003 n/a 15,000 Computers City Hall Administration 09 -ERP -0006 n/a 30,000 Document Management Scanner (2) Community Services 09 -ERP -0008 n/a 10,000 Fire/Duty Chief & Utility Leased Vehicles (5) Fire 09 -ERP -0903a n/a 19,606 Aerial Truck Fire 09 -ERP -0906 n/a 54,217 Air Compressor Fire 09 -ERP -0907 n/a 34,900 Self Contained Breathing Apparatus (SCBA) (45) Fire 09 -ERP -0908 n/a 250,000 Pavilion Arena Scoreboard Pavilion 09 -ERP- 9002 n/a 12,000 Marked Patrol Vehicles (6) Police 09 -ERP -0200 n/a 90,000 Parking Enforcement Vehicle (Parking Fund) Police 09 -ERP -0202 n/a 27,200 Monday, June 16, 2014 15 Project Name Department Project # Priority Project Cost Police Administrative Vehicles (2) Police 09 -ERP -0204 n/a 16,794 Police Admin Cars - outfit leased vehicles Police 09 -ERP -0204a n/a 5,000 SWAT Vehicle Police 09 -ERP -0205 n/a 50,000 Drug Task Force Vehicle Police 09 -ERP -0206 n/a 11,074 Drug Task Force Vehicle - outfit leased vehicle Police 09 -ERP -0206a n/a 5,000 School Resource Officer Car Police 09 -ERP -0290 n/a 6,000 Network Server (3) Police 09 -ERP -0299 n/a 15,000 Radios - Portable and Mobile Devices Police 09 -ERP -0295 n/a 4,100 Riding Mowers (2) Public Works: Parks/Forestry 09 -ERP -0808 n/a 20,000 Slope Mower Public Works: Parks/Forestry 09 -ERP -0809 n/a 32,700 Skid Loader (2) Public Works: Streets/Traffic 09 -ERP -0309 n/a 41,900 Roller Public Works: Streets/Traffic 09 -ERP -0392 n/a 45,900 Asphalt Paver Public Works: Streets/Traffic 09 -ERP -0394 n/a 48,800 Sign Machine (Traffic) Public Works: Streets/Traffic 09 -ERP -0397 n/a 13,400 Refuse Truck (Rear -L) Refuse 09 -ERP -0909 n/a 101,600 3/4 Ton Utility Truck Sewer 09 -ERP -0559 n/a 33,600 Monday, June 16, 2014 16 Total for 2016 993,791 2017 Network Server City Hall Administration 09 -ERP -0003 n/a 15,000 Computers City Hall Administration 09 -ERP -0006 n/a 30,000 Tele -Squirt (Engine 2) Fire 09 -ERP -0900 n/a 650,000 Fire/Duty Chief & Utility Leased Vehicles (5) Fire 09 -ERP -0903a n/a 32,707 Outfit Duty Chief Leased Vehicles (5) Fire 09 -ERP -0903b n/a 10,000 Aerial Truck Fire 09 -ERP -0906 n/a 54,217 Thermal Imaging Camera (2) Fire 09 -ERP -0992 n/a 12,900 Workout Equipment - Treadmill #2 Fire 09 -ERP -0998 n/a 5,800 Workout Equipment - Dumb Bells Fire 09 -ERP -0922 n/a 5,000 Marked Patrol Vehicles (6) Police 09 -ERP -0200 n/a 98,000 Police Administrative Vehicles (2) Police 09 -ERP -0204 n/a 21,999 Police Admin Cars - outfit leased vehicles Police 09 -ERP -0204a n/a 5,000 Drug Task Force Vehicle Police 09 -ERP -0206 n/a 11,074 School Resource Officer Car Police 09 -ERP -0290 n/a 11,205 School Resource Ofcr Car - outfit leased vehicle Police 09 -ERP -0290a n/a 5,000 Network Server (3) Police 01 -ERP -0211 n/a 15,000 Radios - Portable and Mobile Devices Police 09 -ERP -0295 n/a 534,400 Taser Replacement Police 09 -ERP -0297 3 20,900 Stump Cutter Public Works: Parks/Forestry 09 -ERP -0892 n/a 21,200 Skid Loader Public Works: Parks/Forestry 09 -ERP -0895 n/a 32,000 Tandem Dump Truck Public Works: Streets/Traffic 09 -ERP -0306 n/a 173,200 Water Truck Public Works: Streets/Traffic 09 -ERP -0307 n/a 150,000 Striper Public Works: Streets/Traffic 09 -ERP -0393 n/a 11,200 Generator (2) Sewer 09 -ERP -0555 n/a 26,400 1/2 Ton Truck Water 09 -ERP -0500 n/a 26,800 3/4 Ton Utility Truck Water 09 -ERP -0509 n/a 34,900 Total for 2017 2,013,902 2018 Art Center Theater Projector Arts Center 09 -ERP -9904 n/a 17,100 Network Server City Hall Administration 09 -ERP -0003 n/a 15,000 Computers City Hall Administration 09 -ERP -0006 n/a 30,000 Core Network Switch City Hall Administration 09 -ERP -0092 n/a 12,000 Fire/Duty Chief & Utility Leased Vehicles (5) Fire 09 -ERP -0903a n/a 32,707 Aerial Truck Fire 09 -ERP -0906 n/a 54,217 Automated External Defibrillator (2) Fire 09 -ERP -0920 n/a 7,800 Monday, June 16, 2014 16 Project Name Department Project # Priority Project Cost Marked Patrol Vehicles (6) Police 09 -ERP -0200 n/a 98,000 Police Administrative Vehicles (2) Police 09 -ERP -0204 n/a 22,655 Police Admin Cars - outfit leased vehicles Police 09 -ERP -0204a n/a 5,000 Drug Task Force Vehicle Police 09 -ERP -0206 n/a 11,740 Drug Task Force Vehicle - outfit leased vehicle Police 09 -ERP -0206a n/a 5,000 School Resource Officer Car Police 09 -ERP -0290 n/a 11,205 Network Server (3) Police 09 -ERP -0299 n/a 15,000 Tactical Ballistic Vests Police 09 -ERP -0294 n/a 26,900 4X41/2 Ton Truck Public Works: Bldg/Equip Sery 09 -ERP -0790 n/a 31,300 Turf Sweeper Public Works: Parks/Forestry 09 -ERP -0899 n/a 18,000 Toolcat Public Works: Parks/Forestry 09 -ERP -0896 n/a 63,300 4x2 1 Ton Dump Truck Public Works: Streets/Traffic 09 -ERP -0302 n/a 54,600 Single Axle Dump Truck (3) Public Works: Streets/Traffic 09 -ERP -0305 n/a 124,000 Total for 2019 386,856 GRAND TOTAL 4,849,408 Monday, June 16, 2014 17 Total for 2018 655,524 2019 Activity Center Refigerator/Freezer Activity Center 09 -ERP -0039 n/a 1 Network Server City Hall Administration 09 -ERP -0003 n/a 15,000 Computers City Hall Administration 09 -ERP -0006 n/a 30,000 Fire/Duty Chief & Utility Leased Vehicles (5) Fire 09 -ERP -0903a n/a 32,707 Outfit Duty Chief Leased Vehicles (5) Fire 09 -ERP -0903b n/a 10,000 Extrication Tool (2) Fire 09 -ERP -0909 n/a 27,400 Marked Patrol Vehicles (6) Police 09 -ERP -0200 n/a 98,000 Sergeants Vehicle Police 09 -ERP -0209 n/a 50,600 Police Administrative Vehicles (2) Police 09 -ERP -0204 n/a 23,329 Police Admin Cars - outfit leased vehicles Police 09 -ERP -0204a n/a 5,000 Drug Task Force Vehicle Police 09 -ERP -0206 n/a 11,740 School Resource Officer Car Police 09 -ERP -0290 n/a 11,879 School Resource Ofcr Car - outfit leased vehicle Police 09 -ERP -0290a n/a 5,000 Network Server (3) Police 09 -ERP -0299 n/a 15,000 Building Video Server Police 09 -ERP -298 n/a 17,000 Trucksters (3) Public Works: Parks/Forestry 09 -ERP -0807 n/a 34,200 Total for 2019 386,856 GRAND TOTAL 4,849,408 Monday, June 16, 2014 17 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2015 tiim 2019 DEPARTMENT SUMMARY Department 2015 2016 2017 Activity Center 21,000 Arts Center 24,700 City Hall Administration 134,600 45,000 45,000 Community Services 10,000 Fire 115,523 358,723 770,624 HRA 32,400 Pavilion 12,000 Police 213,412 230,168 722,578 Public Works: Bldg/Equip Sery Public Works: Parks/Forestry 22,500 52,700 53,200 Public Works: Streets/Traffic 30,400 150,000 334,400 Refuse 204,800 101,600 Sewer 33,600 26,400 Water 61,700 2018 2019 Total 17,100 57,000 94,724 1 45,000 70,107 195,500 237,548 31,300 81,300 34,200 178,600 21,001 41,800 326,600 10,000 1409,709 32,400 12,000 1599,206 31,300 243,900 693,400 306,400 60,000 61,700 TOTAL 799,335 993,791 2,013,902 655,524 386,856 4,949,40E 18 Monday, June 16, 2014 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2015 tiim 2019 PROJECTS BY DEPARTMENT Department Project# Priority 2015 2016 2017 2018 2019 Total Activity Center Activity Center Refrigerator/Freezer 09 -ERP -0039 n/a 1 9 Activity Center Sound System/Public Address System 09 -ERP -0032 n/a 8,800 8,800 Activity Center Tables 09 -ERP -0033 n/a 12,200 92,200 Activity Center Total 21,000 1 21,001 Arts Center Art Center Video Camera Updates 09 -ERP -9903 n/a 3,700 3,700 Art Center Theater Projector 09 -ERP -9904 n/a 17,100 97,900 Art Center Community Room Audio Visual 09 -ERP -9905 n/a 11,000 99,000 Art Center Digital Information Sign 09 -ERP -9906 2 2,000 2,000 Art Center Floor Scrubber 09 -ERP -9909 n/a 8,000 8,000 Arts Center Total 24,700 17,100 41,800 City Hall Administration Network Server 09 -ERP -0003 nla 15,000 15;000 15,000 15,000 15,000 75,000 Telephone System 09 -ERP -0004 n/a 89,600 89,600 Computers 09 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 950,000 Core Network Switch 09 -ERP -0092 n/a 12,000 12,000 City Hall Administration Total 134,600 45,000 45,000 57,000 45,000 326,600 ICommunity Services Document Management Scanner (2) 09 -ERP -0008 n/a 10;000 90,000 Community Services Total 10,000 10,000 Fire Tele -Squirt (Engine 2) 09 -ERP -0900 n/a 650,000 650,000 Fire/Duty Chief & Utility Leased Vehicles (5) 09 -ERP -0903a n/a 19,606 19,606 32,707 32,707 32,707 137333 Outfit Duty Chief Leased Vehicles (5) 09 -ERP -0903b n/a 10,000 10,000 10,000 30,000 Aerial Truck 09 -ERP -0906 n/a 54,217 54,217 54,217 54,217 296,868 Air Compressor 09 -ERP -0907 n/a 34,900 34,900 Self Contained Breathing Apparatus (SCBA) (45) 09 -ERP -0908 n/a 250,000 250,000 Extrication Tool (2) 09 -ERP -0909 n/a 27,400 27,400 Thermal Imaging Camera (2) 09 -ERP -0992 n/a 12,900 92,900 Floor Scrubber 09 -ERP -0994 n/a 14,300 94,300 Workout Equipment-Eliptical 09 -ERP -0996 n/a 5,800 5,800 Workout Equipment- Treadmill #1 09 -ERP -0997 n/a 5,800 5,800 Workout Equipment - Treadmill #2 09 -ERP -0998 n/a 5,800 5,800 Workout Equipment - Weight Lifting 09 -ERP -0999 n/a 5,800 5,800 Automated External Defibrillator(2) 09 -ERP -0920 n/a 7,800 7,800 Workout Equipment- Dumb Bells 09 -ERP -0922 n/a 5,000 5,000 19 Monday, June 16, 2014 Department Project# Priority 2015 2016 2017 2018 2019 Total Fire Total HRA 90,000 98,000 44 3/4 Ton Truck 09 -ERP -0400 n/a LIRA Total 39,000 50,600 95,600 Pavilion Pavilion Arena Scoreboard 09 -ERP -9002 n/a Pavilion Total 09 -ERP -0808 n/a Slope Mower 09 -ERP -0809 n/a Police Marked Patrol Vehicles (6) 09 -ERP -0200 n/a Sergeant's Vehicle 09 -ERP -0209 n/a Parking Enforcement Vehicle (Parking Fund) 09 -ERP -0202 n/a Police Administrative Vehicles (2) 09 -ERP -0204 nla Police Admin Cars - outfit leased vehicles 09 -ERP -0204a n/a SWAT Vehicle 09 -ERP -0205 n/a Drug Task Force Vehicle 09 -ERP -0206 n/a Drug Task Force Vehicle - outfit leased vehicle 09 -ERP -0206a n/a School Resource Officer Car 09 -ERP -0290 n/a School Resource Ofcr Car - outfit leased vehicle 09 -ERP -0290a n/a Network Server (3) 09 -ERP -0299 n/a Tactical Ballistic Vests 09 -ERP -0294 n/a Radios - Portable and Mobile Devices 09 -ERP -0295 n/a Taser Replacement 09 -ERP -0297 3 Building Video Server 09 -ERP -298 n/a Police Total Public Works: Bldg/Equip Sery 90,000 98,000 4X41/2 Ton Truck 09 -ERP -0790 n/a Public Works: Bldg/Equip Sery Total 39,000 50,600 95,600 Public Works: Parks/Forestry Trucksters (3) 09 -ERP -0807 n/a Riding Mowers (2) 09 -ERP -0808 n/a Slope Mower 09 -ERP -0809 n/a Turf Sweeper 09 -ERP -0899 n/a Stump Cutter 09 -ERP -0892 n/a Skid Loader 09 -ERP -0895 n/a Toolcat 09 -ERP -0896 n/a Grass Seed Applicator (Overseeder) 09 -ERP -0817 n/a Public Works: Parks/Forestry Total 11,074 11,740 11,740 59,897 53,200 Public Works: Streets/Traffic 4X4 3/4 Ton Truck with Plow 09 -ERP -0309 n/a 42 1 Ton Dump Truck 09 -ERP -0302 n/a Single Axle Dump Truck (3) 09 -ERP -0305 n/a Tandem Dump Truck 09 -ERP -0306 n/a Water Truck 09 -ERP -0307 n/a Skid Loader (2) 09 -ERP -0309 n/a Roller 09 -ERP -0392 n/a 115,523 358,723 770,624 94,724 70,107 1,409,701 32,400 32,400 32,400 32,400 12,000 12,000 12,000 12,000 90,000 90,000 98,000 98,000 98,000 474,000 45,000 39,000 50,600 95,600 27,200 32,700 27,200 11,923 16,794 21,999 22,655 23,329 96,700 5,000 5,000 5,000 5,000 5,000 25,000 50,000 63,300 63,300 50,000 6,189 11,074 11,074 11,740 11,740 59,897 53,200 5,000 243,900 5,000 10,000 6,000 6,000 11,205 11,205 11,879 46,289 5,000 5,000 5,000 95,000 15,000 15,000 15,000 15,000 15,000 75,000 150,000 26,900 26,900 12,300 4,100 534,400 45,900 550,800 45,900 20,900 20,900 17,000 17,000 34,000 213,412 230,168 722,578 195,500 237,548 1599,206 31,300 31,300 31,300 31,300 20 Monday, June 16, 2014 34,200 34,200 11,000 20,000 39,000 32,700 32,700 18,000 18,000 21,200 21,200 32,000 32,000 63,300 63,300 11,500 99,500 22,500 52,700 53,200 81,300 34,200 243,900 30,400 30,400 54,600 54,600 124,000 124,000 173,200 973,200 150,000 950,000 41,900 41,900 45,900 45,900 20 Monday, June 16, 2014 Department Project# Priority 2015 2016 2017 2018 2019 Total Striper 09-ERP-0393 n/a 11,200 99,200 Asphalt Paver 09-ERP-0394 n/a 48,800 48,800 Sign Machine (Traffic) 09-ERP-0397 n/a 13,400 93,400 Public Works: Streets/Traffic Total 30,400 150,000 334,400 178,600 693,400 Refuse Refuse Truck (RAP-R) (2) 09-ERP-0900 n/a 204,800 204,800 Refuse Truck (Rear-L) 09-ERP-0909 n/a 101,600 909,600 Refuse Total 204,800 101,600 306,400 Sewer 3/4 Ton Utility Truck 09-ERP-0559 n/a 33,600 33,600 Generator (2) 09-ERP-0555 n/a 26,400 26,400 Sewer Total 33,600 26,400 60,000 Water 1/2 Ton Truck 09-ERP-0500 n/a 26,800 26,800 3/4 Ton Utility Truck 09-ERP-0509 n/a 34,900 34,900 Water Total 61,700 61,700 GRAND TOTAL 799,335 993,791 2,013,902 655,524 386,856 4,849,408 21 Monday, June 16, 2014 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 FUNDING SOURCE SUMMARY Source 2015 2016 2017 AC - Arts Center Fund 24,700 54,217 216,868 Bonds/Lease 54,217 54,217 54,217 Drug Task Force Funds 17,000 12,000 Equipment Replacement Fund 452,618 792,374 1,871,585 HRA - Housing and Redevelopment Authority 32,400 655,524 386,856 4,649,409 PA - Pavilion Fund 12,000 RF - Refuse Fund 204,800 101,600 SF - Sanitary Sewer Fund 6,800 33,600 26,400 WF - Water Fund 6,800 61,700 GRAND TOTAL 799,335 993,791 2,013,902 W -A 2018 2019 Total 17,100 41,800 54,217 216,868 17000 584,207 386,856 4,087,640 32,400 12,000 306,400 66,800 68,500 655,524 386,856 4,649,409 Monday, June 16, 2014 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2015 thru 2019 PROJECTS BY FUNDING SOURCE Source Project# Priority 2015 2016 2017 2018 2019 Total AC - Arts Center Fund 1 Art Center Video Camera Updates 09 -ERP -9903 nla 3,700 3,700 Art Center Theater Projector 09 -ERP -9904 n/a 17,100 97,900 Art Center Community Room Audio Visual 09 -ERP -9905 nla 11,000 99,000 Art Center Digital I nformation Sign 09 -ERP -9906 2 2,000 2,000 Art Center Floor Scrubber 09 -ERP -9909 n/a 8,000 8,000 AC - Arts Center Fund Total 24,700 17,100 41,800 Bonds/Lease Aerial Truck 09 -ERP -0906 n/a 54,217 54,217 54,217 54,217 296,868 Bonds/Lease Total 54,217 54,217 54,217 54,217 216,868 Drug Task Force Funds Building Video Server 09 -ERP -298 n/a 17,000 97,000 Drug Task Force Funds Total 17,000 17,000 Equipment Replacement Fund Network Server 09 -ERP -0003 n/a 15,000 15,000 15,000 15,000 15,000 75,000 Telephone System 09 -ERP -0004 n/a 76,000 76,000 Computers 09 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 950,000 Document Management Scanner (2) 09 -ERP -0008 n/a 10,000 10,000 Core Network Switch 09 -ERP -0092 n/a 12,000 92,000 Activity Center Refrigerator/Freezer 09 -ERP -0039 n/a 1 9 Activity Center Sound System/Public Address System 09 -ERP -0032 n/a 8,800 8,800 Activity Center Tables 09 -ERP -0033 n/a 12,200 92,200 Tele -Squirt (Engine 2) 09 -ERP -0900 n/a 650,000 650,000 Fire/Duty Chief & Utility Leased Vehicles (5) 09 -ERP -0903a n/a 19,606 19,606 32,707 32,707 32,707 937,333 Outfit Duty Chief Leased Vehicles (5) 09 -ERP -0903b n/a 10,000 10,000 10,000 30,000 Air Compressor 09 -ERP -0907 n/a 34,900 34,900 Self Contained Breathing Apparatus (SCBA) (45) 09 -ERP -0908 n/a 250,000 250,000 Extrication Tool (2) 09 -ERP -0909 n/a 27,400 27400 Thermal Imaging Camera (2) 09 -ERP -0992 n/a 12,900 92,900 Floor Scrubber 09 -ERP -0994 n/a 14,300 94,300 Workout Equipment -Eliptical 09 -ERP -0996 n/a 5,800 5,800 Workout Equipment- Treadmill #1 09 -ERP -0997 n/a 5,800 5,800 Workout Equipment- Treadmill #2 09 -ERP -0998 n/a 5;800 5,800 Workout Equipment - Weight Lifting 09 -ERP -0999 nla 5,800 5,800 Automated External Defibrillator(2) 09 -ERP -0920 n/a 7,800 7,800 Workout Equipment - Dumb Bells 09 -ERP -0922 n/a 5,000 5,000 Marked Patrol Vehicles (6) 09 -ERP -0200 n/a 90;000 90,000 98,000 98;000 98,000 474,000 Sergeant's Vehicle 09 -ERP -0209 n/a 45;000 50,600 95,600 Monday, June 16, 2014 23 Source Project# Priority 2015 2016 2017 2018 2019 Total Parking Enforcement Vehicle (Parking Fund) 09 -ERP -0202 n/a 27,200 27,200 Police Administrative Vehicles (2) 09 -ERP -0204 nla 11,923 16,794 21,999 22,655 23,329 96,700 Police Admin Cars - outfit leased vehicles 09 -ERP -0204a n/a 5,000 5,000 5,000 5,000 5,000 25,000 SWAT Vehicle 09 -ERP -0205 n/a 50,000 50,000 Drug Task Force Vehicle 09 -ERP -0206 n/a 6,189 11,074 11,074 11,740 11,740 59,897 Drug Task Force Vehicle - outfit leased vehicle 09 -ERP -0206a n/a 5,000 5,000 10,000 School Resource Officer Car 09 -ERP -0290 n/a 6,000 6,000 11,205 11,205 11,879 46,289 School Resource Ofcr Car - outfit leased vehicle 09 -ERP -0290a n/a 5,000 5,000 5,000 15,000 Network Server (3) 09 -ERP -0299 n/a 15,000 15,000 15,000 15,000 15,000 75,000 Tactical Ballistic Vests 09 -ERP -0294 nla 26,900 26,900 Radios - Portable and Mobile Devices 09 -ERP -0295 n/a 12,300 4,100 534,400 550,800 Taser Replacement 09 -ERP -0297 3 20,900 20,900 4X4 3/4 Ton Truck with Plow 09 -ERP -0309 n/a 30,400 30,400 42 1 Ton Dump Truck 09 -ERP -0302 n/a 54,600 54,600 Single Axle Dump Truck (3) 09 -ERP -0305 n/a 124,000 124,000 Tandem Dump Truck 09 -ERP -0306 n/a 173,200 973,200 Water Truck 09 -ERP -0307 n/a 150,000 950,000 Skid Loader (2) 09 -ERP -0309 n/a 41,900 49,900 Roller 09 -ERP -0392 n/a 45,900 45,900 Striper 09 -ERP -0393 n/a 11,200 99,200 Asphalt Paver 09 -ERP -0394 n/a 48,800 48,800 Sign Machine (Traffic) 09 -ERP -0397 n/a 13,400 13,400 4X41/2 Ton Truck 09 -ERP -0790 n/a 31,300 39,300 Trucksters (3) 09 -ERP -0807 n/a 34,200 34,200 Riding Mowers (2) 09 -ERP -0808 n/a 11,000 20,000 39,000 Slope Mower 09 -ERP -0809 n/a 32,700 32,700 Turf Sweeper 09 -ERP -0899 n/a 18,000 98,000 Stump Cutter 09 -ERP -0892 n/a 21,200 29,200 Skid Loader 09 -ERP -0895 n/a 32,000 32,000 Toolcat 09 -ERP -0896 n/a 63,300 63,300 Grass Seed Applicator (Overseeder) 09 -ERP -0897 nla 11,500 99,500 Building Video Server 09 -ERP -298 n/a 17,000 97,000 Equipment Replacement Fund Total 452,618 792,374 1,871,585 584,207 386,856 4,087,640 HRA - Housing and Redevelopment A 4x4 3/4 Ton Truck 09 -ERP -0400 n/a 32,400 32,400 HRA - Housing and Redevelopment 32,400 32,400 Authority Total PA - Pavilion Fund Pavilion Arena Scoreboard 09 -ERP -9002 n/a 12,000 92,000 PA - Pavilion Fund Total 12,000 12,000 IRF - Refuse Fund Refuse Truck (RAP -R) (2) 09 -ERP -0900 n/a 204,800 204,800 Refuse Truck (Rear -L) 09 -ERP -0909 n/a 101,600 909,600 RF - Refuse Fund Total 204,800 101,600 306,400 ISF - Sanitary Sewer Fund Telephone System 09 -ERP -0004 n/a 6,800 6,800 Monday, June 16, 2014 24 Source Project# Priority 3/4 Ton Utility Truck 09 -ERP -0559 n/a Generator (2) 09 -ERP -0555 n/a SF - Sanitary Sewer Fund Total WF - Water Fund Telephone System 09 -ERP -0004 n/a 1/2 Ton Truck 09 -ERP -0500 n/a 3/4 Ton Utility Truck 09 -ERP -0509 n/a WF - Water Fund Total GRAND TOTAL W 2015 2016 2017 2018 2019 Total 33,600 33,600 26,400 26,400 6,800 33,600 26,400 66,800 6,800 6,800 26,800 26,800 34,900 34,900 6,800 61,700 68,500 799,335 993,791 2,013,902 655,524 386,856 4,849,408 Monday, June 16, 2014 --qca City or Hops `1- EQUIPMENT REQUESTS 27 --qca City or Hops 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0031 Project Name Activity Center Refrigerator/Freezer Future Description 'ommerical, stainless steel refrigerator and freezer. 2015 thru 2019 Department Activity Center Contact Facilities Director Type Equipment Useful Life 30 years Category Equipment Priority n/a Total Project Cost: $10,501 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. Prior Expenditures 10,500 Equipment Total Total Prior Funding Sources 10,500 Equipment Replacement Fund Total Total 2015 2016 2017 2018 2019 Total 1 1 1 1 2015 2016 2017 2018 2019 Total from 20 year plan - Delayed indefinetly. Will use and repair as necessary. salvage/resale value on replaced item: $-0- Monday, June 16, 2014 29 EQUIPMENT REPLACEMENT PLAN 2015 ffim 2019 City of Hopkins, MN 'roject # 01 -ERP -0032 'roject Name Activity Center Sound System/Public Address System Future Department Activity Center Contact Facilities Director Type Equipment Useful Life 15 years Category Equipment Priority n/a Description Total Project Cost: $22,500 k11 new equipment to allow for sound in every room as well as the public address system in the gymnasium and Raspberry Room. Justification fur 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 ailure. The sound system was installed shortly after we opened in 1980 and the PA system was upgraded in 1990, but has now failed. The Wpberry Room is now being used more and more for lectures and classroom type activities and we would like to improve the system we curren xse in there. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 8;800 8,800 13,700 Total 8,800 8,800 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 8,800 8,800 13,700 Total 8,800 8,800 Total Budget Impact/Qtber Jariance from 20 year plan - New item. ?stimate salvage/resale value on replaced items: $ -0- 30 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0033 Project Name Activity Center Tables Future Description ?3 tables - 6'x 24" mobile, multiple use, folding tables @$475 each Department Activity Center Contact Facilities Director Type Equipment Useful Life 15 years Category Equipment Priority n/a Total Project Cost: $31,200 Justification Chis 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 to for an anniversary reception. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 12,200 12,200 19,000 Total 12,200 12,200 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 12,200 12,200 19,000 Total 12,200 12,200 Total Budget Impact/Qther Jariance from 20 year plan - New item ?stimate salvage/resale value on replaced items: $ 0 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -1103 Project Name Art Center Video Camera Updates Future Department Arts Center Contact Arts Center Director Type Equipment Useful Life 5 years Category Equipment Priority n/a Description Total Project Cost: $22,000 ?,eplace the front entry camera with a better resolution camera. Relocate existing to above the display cabinet in the lobby. Add additional camera o 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 ;amera in the back hallway may reduce tendency of youth to hang out in that area and engage in inappropriate behavior. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 3,200 Equipment 3;700 3,700 15,100 Total Total 3,700 3,700 Total Prior Funding Sources 3,200 AC - Arts Center Fund Total 2015 2016 2017 2018 2019 Total Future 3,700 3,700 15,100 Total 3,700 3,700 Total Budget Impact/Qther Jariance from 20 year plan - Move up from 2017 to 2015. ?stimate salvage/resale value on replaced item: $-0- WA Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 City of Hopkins, MN Project # 01 -ERP -1104 Project Name Art Center Theater projector Future Department Arts Center Contact Arts Center Director Type Equipment Useful Life 5 years Category Equipment Priority n/a Description I Total Project Cost: $75,000 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 Che 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 echr&al 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 irts presenter we need to have the technical capatabilities to run our own programs in a professional manner. ear2018: $17,100 ear 2023 $19,800 ear 2028 $22.900 Prior 15,200 Total Prior 15,200 Total Expenditures 2015 2016 2017 2018 2019 Total Future Equipment Funding Sources AC - Arts Center Fund 17,100 17,100 42,700 Tom 17,100 17,100 Total 2015 2016 2017 2018 2019 17,100 Total 17,100 Total Future 17,100 42,700 17,100 Total $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 Digital Rivers just under $9,000. Monday, June 16, 2014 33 EQUIPMENT REPLACEMENT PLAN 2015 ffim 2019 City of Hopkins, MIST 'roject # 01 -ERP -1105 'rojeet Name Art Center Community Room Audio Visual Future Department Arts Center Contact Arts Center Director Type Equipment Useful Life 7 years Category Equipment Priority n/a Description Total Project Cost: $41,100 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 kn increasing number of users of this room require media support. Current means of providing this include the use of an oversized AN 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. Fhese 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. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 11,000 11,000 30,100 Total Funding Sources AC - Arts Center Fund 11,000 2015 2016 11,000 11,000 2017 2018 2019 Total 11,000 Total Future 30,100 Total 11,000 11,000 Total Budget Impact/Other vlove this item from 2014 to 2017 34 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -1106 Project Name Art Center Digital Information Sign Future Description Add programmable and highly visable digital sign to information desk area. Yiewsonic 42" with integrated media, software - or similar) Department Arts Center Contact Arts Center Co -Director Type Equipment Useful Life 5 years Category Equipment Priority 2 Very Important Total Project Cost: $10,100 Justification 'urrent system of posting printed schedules and key information each day is overlooked by visitors and difficult to update rapidly. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 2;000 2,000 8,100 Total 2,000 2,000 Total Funding Sources 2015 2016 2017 2018 2019 Total Future AC - Arts Center Fund 2,000 2,000 8,100 Total 2,000 2,000 Total Budget Impact/Other Jariance from 20 year plan - New Item ?stimated salvage/resale value $0 moi Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -1109 Project Name Art Center Floor Scrubber Future Description 26 -inch autoscrubber Justification 'urrent scrubber has reached its lifetime and no longer spins fast enough to be effective. Department Arts Center Contact Arts Center Co -Director Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost: $18,800 Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 8;000 8,000 10,800 Total 8,000 8,000 Total Funding Sources 2015 2016 2017 2018 2019 Total Future AC - Arts Center Fund 8,000 8,000 10,800 Total 8,000 8,000 Total Budget Impact/Qther Jariance from 20 year plan - New item ?stimate salvage/resale value on replaced item: $-0- K% Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0003 Project Name Network Server Future Department City Hall Administration Contact Finance Director/IT Type Equipment Useful Life 1 year Category Equipment Priority n/a Description I Total Project Cost: $397,000 Che network server is the hub of the network. New computers are faster and more reliable. Justification letworking allows user to share information that is stored in a single location, the network server. This is more efficient because the information toes not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every rser is working with the same data. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 97,000 Equipment 15,000 15,000 15,000 15,000 15,000 75,000 225,000 Total Total 15,000 15,000 15,000 15,000 15,000 75,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 97,000 Equipment Replacement Fund 15,000 15,000 15,000 15,000 15,000 75,000 225,000 Total Total 15,000 15,000 15,000 15,000 15,000 75,000 Total Budget Ifnpact/Qther 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 )udget to required software and 8,000 isn't enough anymore. ?stimate salvage/resale value on replaced item: $-0- Monday, June 16, 2014 37 EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 Department City Hall Administration City of Hopkins, MN Contact IT Director Project # 01 -ERP -0004 Type Equipment Useful Life 8 years Project Name Telephone System llCategory Equipment Future Priority n/a Description Total Project Cost: $349,900 ncludes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also ncludes software for the PBX and voice mail systems. Justification vlaking, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Prior Expenditures 60,000 Equipment Total Tota Prior Funding Sources 60,000 Equipment Replacement Fund Total SF - Sanitary Sewer Fund 2015 2016 2017 2018 2019 89,600 89,600 2015 2016 2017 2018 2019 76,000 6,800 6,800 Total Future 89,600 200,300 89,600 Total Total Future 76,000 200,300 6,800 Total Total 89,600 89,600 Budget Impact/Other Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015. ?stimate salvage/resale value on replaced item: $ Monday, June 16, 2014 38 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0006 Project Name Computers Future Department City Hall Administration Contact Finance Director/IT Type Equipment Useful Life 3-5 years Category Equipment Priority n/a Description Total Project Cost: $1,020,000 3ersonal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one Justification Cools enabling staff to perform job responsibilities efficiently and effectively. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 420,000 Equipment 30;000 30,000 30,000 30,000 30,000 150,000 450,000 Total Total 30,000 30,000 30,000 30,000 30,000 150,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 420,000 Equipment Replacement Fund 30,000 30,000 30,000 30,000 30,000 150,000 450,000 Total Total 30,000 30,000 30,000 30,000 30,000 150,000 Total Budget Impact/Qther Jariance from 20 year plan - none ?stimate salvage/resale value on replaced item: $-0- 39 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 City of Hopkins, MN Project # 01 -ERP -0012 Project Name Core Network Switch Future Department City Hall Administration Contact Finance Director/IT Type Equipment Useful Life 6 years Category Equipment Priority n/a Description Total Project Cost: $53,300 'rovides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates ibr optic network connection to fire department. 2 - Cisco 3560E-24PD managed switch - $3,000 each 2 - Cisco X2-IOGB-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. Prior Expenditures 10,000 Equipment Total 2015 2016 2017 2018 2019 Total Future 12,000 12,000 31,300 Tom 12,000 12,000 Total Prior Funding Sources 10,000 Equipment Replacement Fund Total Total 2015 2016 2017 2018 2019 12,000 12,000 Total Future 12,000 31,300 12,000 Total ice from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside the budget for city hall network budget as the "Lisa" service is scheduled for replacement due to end of life, out of PCI compliance and obsolete. ite salvage/resale value on replace item: - $-0- Monday, June 16, 2014 40 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0008 Project Name Document Management Scanner (2) Future Department Community Services Contact City Clerk Type Equipment Useful Life 4 years Category Equipment Priority n/a Description Total Project Cost: $87,600 ,arge document (1 P' x17") scanner for document management and retention as well as general administrative use. two scanners in 2012 at a cost of $10,315 - 1 at scanner station, 1 in City Clerk's office equipment: Canon DR 7550C Justification ;canners are needed for converting paper copies to electronic data to reduce storage space. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 23,300 Equipment 10,000 10,000 54,300 Total Total 10,000 10,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 23,300 Equipment Replacement Fund 10,000 10,000 54,300 Total Total 10,000 10,000 Total Budget Impact/Qther Jariance from 20 year plan - Two scanners purchased in 2012 and will be replaced every four years. ?stimate salvage/resale value on replaced item: $50041,000 Monday, June 16, 2014 41 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0100 Project Name Tele -Squirt (Engine 2) Future Description 'ire engine: full size response truck Department Fire Contact Fire Chief Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $1,523,500 (Current vehicle: 1989 Ford L9000 Tele -Squirt (9102) I 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. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 650,000 650,000 873,500 Total 650,000 650,000 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 650,000 650,000 873,500 Total 650,000 650,000 Total Budget Imlpact/Qther 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. Jpdated value to reflect more accurate replacement cost. ?stimate salvage/resale value on replaced item: $ Monday, June 16, 2014 E,% EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 City of Hopkins, MN Project # 01 -ERP -0103a Project Name Fire/Duty Chief & Utility Leased Vehicles (5) Future Department Fire Contact Fire Chief Type Equipment Useful Life 4 years Category Vehicles Priority n/a Description I Total Project Cost: $627,938 3roposal 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 '.017 - 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 need to budget for outfitting the vehicles - $5,000 each Justification fur 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 mrrent 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 7ehicles in the fleet. The department's current vehicle replacement structure means vehicles are kept in the department for 10+ years. Keeping the 7ehicles for this extended period of time greatly increased the cost of maintenance and often requires much more costly maintenance procedures. 3y 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 elder vehicles. Maintenance is also built into this program, at a substantial savings over our current expenditures. Engaging in a leasing program is )v far the most cost effective wav to accomDlish the goal of fleet replacement. Expenditures 2015 2016 2017 2018 2019 Total Future Vehicles 19,606 19,606 32,707 32,707 32,707 137,333 490,605 Total 19,606 19,606 32,707 32,707 32,707 137,333 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 19,606 19,606 32,707 32,707 32,707 137,333 490,605 Tom 19,606 19,606 32,707 32,707 32,707 137,333 Total Budget Impact/®ther Jariance 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 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0103b Project Name Outfit Duty Chief Leased Vehicles (5) Future Description 'ost to outfit leased vehicles '.015 - lease one Ford F-150 utility vehicle ?015 - lease two Ford Explorers for duty crews '.017 - lease two Ford Explorers for Fire Chief and Asst. Fire Chief Justification ,eased vehicles need to be outfitted for use by Fire Dept. Department Fire Contact Fire Chief Type Equipment Useful Life 4 years Category Vehicles Priority n/a Total Project Cost: $100,000 Expenditures 2015 2016 2017 2018 2019 Total Future Vehicles 10;000 10,000 10,000 30,000 70,000 Total 10,000 10,000 10,000 30,000 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 10,000 10,000 10,000 30,000 70,000 Total 10,000 10,000 10,000 30,000 Total Budget Impact/Other variance from 20 year plan - New item. Cost of outfitting new leased vehicles for Fire Dept. Monday, June I6, 2014 44 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0106 Project Name Aerial Truck Future Department Fire Contact Fire Chief Type Equipment Useful Life 20 years Category Vehicles Priority n/a Description Total Project Cost: $2,559,597 ane hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on '.008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23. 'urrent vehicle: 2008 Pierce Arrow XT Aerial Ladder (#109) Justification Jchicle 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 i 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 )ayments equals $987,597. Prior Expenditures 770,729 Equipment Total Prior Funding Sources 770,729 Bonds/Lease Total 2015 2016 2017 2018 2019 Total Future 54,217 54,217 54,217 54,217 216,868 1,572,000 Tom 54,217 54,217 54,217 54,217 216,868 Total 2015 2016 2017 2018 2019 Total Future 54,217 54,217 54,217 54,217 216,868 1,572,000 Total 54,217 54,217 54,217 54,217 216,868 Total from 20 year plan - .Lease payments on financing added to the plan. salvage/resale value on replaced item: $ Monday, June 16, 2014 :R EQUIPMENT REPLACEMENT PLAN 2015 ffim 2019 Department Fire City of Hopkins, MN Contact Fire Chief Project # 01 -ERP -0107 Type Equipment Useful Life 15 years Project Name Air Compressor h Category Equipment Future Priority n/a Description Total Project Cost: $89,300 Che air compressor is used to fill breathing apparatus that has been used by Fire personnel after training and fires. Justification Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 34,900 34,900 54,400 Total 34,900 34,900 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 34,900 34,900 54,400 Total 34,900 34,900 Total Budget Impact/Other Jariance from 20 year plan - move back to 2017 ?stimate salvage/resale value on replaced item - $ 'urchased: 1996 : Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0108 Project Name Self Contained Breathing Apparatus (SCBA) (45) Future Description 3reathing apparatus for interior firefighting for firefighters. Department Fire Contact Fire Chief Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost: $752,000 Justification Che 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. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 166,000 Equipment 250,000 250,000 336,000 Total Total 250,000 250,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 166,000 Equipment Replacement Fund 250,000 250,000 336,000 Total Total 250,000 250,000 Total Budget Impact/Qther Jariance from 20 year plan - New item. ?stimate salvage/resale value on replaced item: $ 47 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0109 Project Name Extrication Tool (2) Future Description lydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. Department Fire Contact Fire Chief Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost: $177,200 Justification k11 vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool wil be added to the purchase of the luick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 42,600 Equipment 27,400 27,400 107,200 Total Total 27,400 27,400 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 42,600 Equipment Replacement Fund 27,400 27,400 107,200 Total Total 27,400 27,400 Total Budget Impact/Other Jariance from 20 year plan - move back from 2015 to 2019. ?stimate salvage/resale value on replaced item: $1,000 'urchased: 2007 48 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 City of Hopkins, MN Project # 01 -ERP -0112 Project Name Thermal Imaging Camera (2) Future Department Fire Contact Fire Chief Type Equipment Useful Life 10 years Category Equipment Priority n/a Description Total Project Cost: $92,900 Jsed 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 or faster extinguishment. ote: purchased 2003 & 2007 Justification 'urrent camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was purchased with donation Prior Expenditures 2015 2016 2017 2018 2019 Total Future 26,500 Equipment 12,900 12,900 53,500 Total Total 12,900 12,900 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 26,500 Equipment Replacement Fund 12,900 12,900 53,500 Total Total 12,900 12,900 Total 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 eplacement schedule the camera purchased from the Fire Dept budget in 2003. ?stimate salvage/resale value on repalced item: $-0- Monday, June 16, 2014 49 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0114 Project Name Floor Scrubber Future Description loor scrubber to keep apparatus floors clean. 2004 Tennant 5400 Justification icrubber is used to keep apparatus floors clean so that floor will last longer. Department Fire Contact Fire Chief Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost: $34,600 Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 14,300 14,300 20,300 Total Funding Sources Equipment Replacement Fund 14,300 2015 2016 14,300 14,300 2017 2018 2019 Total 14,300 Total Future 20,300 Total 14,300 14,300 Total ice from 20 year plan - Eliminate sweeper and add scrubber as scrubber is used more. from 2016 to 2015 ite salvage/resale value on replaced item: $0 Monday, June 16, 2014 50 EQUIPMENT REPLACEMENT PLAN 2015 ffim 2019 7� �1V � Department Fire 1VJ City of Hopkins, Contact Fire Chief Project # 01 -ERP -0116 Type Equipment Useful Life 6 years Project Name Workout Equipment - Elitical h Category Equipment Future Priority n/a Description Total Project Cost: $29,600 Workout equipment used in Fire Department workout room. One eliptical machine replaced on a 6 year cycle, one every 3 years. Justification Chis equipment is available to all City employees for health and wellness. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 5;800 5,800 23,800 Total 5,800 5,800 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 5,800 5,800 23,800 Total 5,800 5,800 Total 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 'emaining eliptical is scheduled for replacement in 2015. ?stimate salvage/resale value on replaced item: $ Monday, June 16, 2014 A' EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0117 Project Name Workout Equipment- Treadmill #1 Future Description Workout equipment used in Fire Department workout room. ane summit trainer replaced on a 5 year cycle. 2010 Summit Trainer - will be replaced with a treadmill Justification Chis equipment is available to all City employees for health and wellness. Prior Expenditures 5,000 Equipment Total Department Fire Contact Fire Chief Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost: $34,300 2015 2016 2017 2018 2019 Total Future 5,800 5,800 23,500 Total 5,800 5,800 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 5,000 Equipment Replacement Fund 5,800 5,800 23,500 Total Total 5,800 5,800 Total from 20 year plan - replaces stairmaster. salvage/resale value on replaced item: $ 6Y: Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0118 Project Name Workout Equipment- Treadmill #2 Future Description Workout equipment used in the Fire Department workout room. ane treadmill replaced on a 5 year cycle. Justification Chis equipment is available to all City employees for health and wellness. Department Fire Contact Fire Chief Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost: $34,300 Prior Expenditures 2015 2016 2017 2018 2019 Total Future 5,000 Equipment 5,800 5,800 23,500 Total Total 5,800 5,800 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 5,000 Equipment Replacement Fund 5,800 5,800 23,500 Total Total 5,800 5,800 Total Budget Impact/Other Jariance from 20 year plan - move back one year from 2011 to 2012. ?stimate salvage/resale value on replaced item: $ 53 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0119 Project Name Workout Equipment- Weight Lifting Future Description imith machine - weight lifting machine. Department Fire Contact Fire Chief Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost: $29,300 Justification or 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 !012. Suggested replacement is every 5 years. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 5;800 5,800 23,500 Total 5,800 5,800 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 5,800 5,800 23,500 Total 5,800 5,800 Total Budget Impact/Other Jariance from 20 year plan - move back from 2011 to 2015 ?stimate salvage/resale value on replaced items: $ 54 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0120 Project Name Automated External Defibrillator (2) Future Description )efibrillator is used to help get someones heart restarted during a cardiac arrest. awn 2 - both are replaced at one time due to changing technology. Department Fire Contact Fire Chief Type Equipment Useful Life 4 years Category Equipment Priority n/a Total Project Cost: $60,600 (Current equipment: 2010 - 4 AEDs I 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 Prior Expenditures 13,200 Equipment Total 2015 2016 2017 2018 2019 Total Future 7,800 7,800 39,600 Total 7,800 7,800 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 13,200 Equipment Replacement Fund 7,800 7,800 39,600 Total Total 7,800 7,800 Total from 20 year plan - adjustment from 3 years to 4 years. salvage/resale value on replaced item: $ 61i Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0122 Project Name Workout Equipment -Dumb Bells Future Description Workout equipment used in Fire Department workout room. Department Fire Contact Fire Chief Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost: $11,700 Justification 'urrent dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead based plaint. This purchase vould update our dumb bells to the current type fitness bells. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 5,000 5,000 6,700 Total 5,000 5,000 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 5,000 5,000 6,700 Total 5,000 5,000 Total Budget Impact/Other Jariance from 20 year plan - Move back from 2014 to 2017. ?stimate salvage/resale value on replaced item: $ 67: Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 City of Hopkins, MN Project # 01 -ERP -0400 Project Name 4x43/4 Ton Truck Future Department HRA Contact Unassigned Type Equipment Useful Life 8 years Category Vehicles Priority n/a Description Total Project Cost: $148,400 1 wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snow plow. vehicle: 2007 Chevrolet Justification for Public Housing Superintendent and snow plowing at various HRA properties around the city. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 22,800 Vehicles 32,400 32,400 93,200 Total Total 32,400 32,400 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 22,800 HRA - Housing and 32,400 32,400 93,200 Redevelopment Authority Total Total Total 32,400 32,400 Budget Impact/Qther Jariance from 20 year plan - none ?stimate salvage/resale value on replaced item: $1,800 57 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -1002 Project Name Pavilion Arena Scoreboard 2015 thru 2019 Department Pavilion Contact Facilities Director Type Equipment Useful Life 20 years Category Equipment Future Priority n/a Description Total Project Cost: $12,000 krena scoreboard used for hockey, lacrosse, soccer and other activities in the arena. Justification Che 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. Expenditures 2015 2016 2017 2018 2019 Total Equipment 12,000 12,000 Total Funding Sources 2015 12,000 2016 2017 12,000 2018 2019 Total PA - Pavilion Fund 12,000 12,000 Total 12,000 12,000 from 20 year plan - New item salvage/resale value on replaced item: $ 58 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0200 Project Name Marked Patrol Vehicles (6) Future Department Police Contact Police Chief Type Equipment Useful Life 3 years Category Vehicles Priority n/a Description Total Project Cost: $3,279,900 vlarked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. consists of 6 patrol vehicles - 5 marked, 1 unmarked. vehicles: (3) 2011 Ford Crown Victorias, (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria Justification ;et up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for 'outine and emergency operations. Vehicles contain secure seating for prisoner transport. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 868,100 Vehicles 90,000 90,000 98,000 98,000 98,000 474,000 1,937,800 Total Total 90,000 90,000 98,000 98,000 98,000 474,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 868,100 Equipment Replacement Fund 90,000 90,000 98,000 98,000 98,000 474,000 1,937,800 Total Total 90,000 90,000 98,000 98,000 98,000 474,000 Total Budget Impact/Other Jariance from 20 year plan - cost modified due to new models of squads which need to be re -outfitted for all equipment. ?stimate salvage/resale value on replaced item: $4,000 each Monday, June 16, 2014 59 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0201 Project Name Sergeant's Vehicle Future Department Police Contact Police Chief Type Equipment Useful Life 4 years Category Vehicles Priority n/a Description Total Project Cost: $322,200 vlarked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. 1 year rotation. vehicle: 2011 Ford Crown Victoria Justification ;et up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for 'outine and emergency operations. Vehicles contain secure seating for prisoner transport. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 33,600 Vehicles 45;000 50,600 95,600 193,000 Total Total 45,000 50,600 95,600 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 33,600 Equipment Replacement Fund 45,000 50,600 95,600 193,000 Total Total 45,000 50,600 95,600 Total Budget Impact/Other variance from 20 year plan - cost modified due to new model of car which will require all new equipment. ?stimate salvage/resale value on replaced item: $3,500 each Monday, June 16, 2014 60 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0202 Project Name Parking Enforcement Vehicle (Parking Fund) Future Description 'arking enforcement vehicle. Department Police Contact Police Chief Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $82,500 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. Prior Expenditures 18,700 Vehicles Total 2015 2016 2017 2018 2019 Total Future 27,200 27,200 36,600 Tom 27,200 27,200 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 18,700 Equipment Replacement Fund 27,200 27,200 36,600 Total Total 27,200 27,200 Total from 20 year plan - amount allocated is not sufficient. Increase to $27,200. salvage/resale value on replaced item: $1,500 Monday, June 16, 2014 61 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0204 Project Name Police Administrative Vehicles (2) Future Description 'olice administration (chief, captian), Investigative Sergeant, and Detective vehicles. Chief s vehicle - even numbered years Captain's vehicle - odd numbered years Department Police Contact Police Chief Type Equipment Useful Life 2 years Category Vehicles Priority n/a Total Project Cost: $846,913 ve 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 and use for two years before again passing the vehicle down to the Investigative Sergeant who will use it for another 2 years. ve 2015 - Captain vehcile to be leaed for 4 years - 2yr for captain and 2yr for Detective 0. In year 3 of lease the Capitain will get a new vehicle, use for 2 years before passing down to Detective 93 who will use it for another two years. are 4 leased vehicles accounted for in this ERP item vehicles: 2013 Ford Taurus, 2011 Ford Taurus 021 Justification Jnmarked vehicles, equipped with radios, siren and red grille lites used by chief and captain. Staff use is for two years. Vehicles are then rotated town to detectives and are kept for an additional 3-4 years. Vehicles are also used for surveillance by uniform and plain clothes officers. Prior Expenditures 303,394 Vehicles Total 2015 2016 11,923 16,794 Total 11,923 16,794 2017 2018 21,999 22,655 21,999 22,655 2019 23,329 23,329 Total Future 96,700 446,819 96,700 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 303,394 Equipment Replacement Fund 11,923 16,794 21,999 22,655 23,329 96,700 446,819 Total Total 11,923 16,794 21,999 22,655 23,329 96,700 Total Budget Impact/Other Variance from 20 year plan - starting in 2014 chiefs vehcile will be leased and in 2015 the captians will be leased. ?stimate salvage/resale value on replaced item: $4,000 each for current vehicles not leased. Monday, June 16, 2014 62 EQUIPMENT REPLACEMENT PLAN 2015 ffim 2019 City of Hopkins, MN Project # 01 -ERP -0204a Project Name Police Admin Cars - outfit leased vehicles Future Description 'ost to outfit leased police chief and captains cars Department Police Contact Police Chief Type Equipment Useful Life Category Vehicles Priority n/a Total Project Cost: $105,000 Justification Me need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. 'hief & Captain get a new vehicle every other year. Year 3 & 4 of chief lease - investigative sergeant Year 3 & 4 of captain lease - detective ince one is purchased each year the cost is estimated at $5,000 per vehicle per year. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 5,000 Equipment 5,000 5,000 5,000 5,000 5,000 25,000 75,000 Total Total 5,000 5,000 5,000 5,000 5,000 25,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 5,000 Equipment Replacement Fund 5,000 5,000 5,000 5,000 5,000 25,000 75,000 Total Total 5,000 5,000 5,000 5,000 5,000 25,000 Total Budget Imlpact/Qther Variance from 20 year plan: Cost of outfitting chiefs and captain's vehicles is now accounted for separately from the vehicle purchase since the lehicles are now leased. Monday, June 16, 2014 63 EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 City of Hopkins, MN Project # 01 -ERP -0205 Project Name SWAT Vehicle Future Description Jnmarked van to transport police tactics team for high risk calls, training and mutual aid. TWAT - 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. Department Police Contact Police Chief Type Equipment Useful Life 15 years Category Vehicles Priority n/a Total Project Cost: $127,900 Expenditures 2015 2016 2017 2018 2019 Total Future Vehicles 50,000 50,000 77,900 Total Funding Sources 2015 Equipment Replacement Fund 50,000 2016 2017 50,000 50,000 2018 2019 Total 50,000 Total Future 77,900 Total 50,000 50,000 Total from 20 year plan - Increase cost from 30,000 to 50,000 salvage/resale value on replaced item: $3,000 64 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0206 ProjeetName Drug Task Force Vehicle Future Department Police Contact Police Chief Type Equipment Useful Life 4 years Category Vehicles Priority n/a Description Total Project Cost: $284,951 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. Prior Expenditures 4,694 Vehicles Total 2015 2016 2017 2018 2019 Total Future 6,189 11,074 11,074 11,740 11,740 51,817 228,440 Tom 6,189 11,074 11,074 11,740 11,740 51,817 Total 51,817 228,440 Total Total 6,189 11,074 Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 4,694 Equipment Replacement Fund 6,189 11,074 11,074 11,740 11,740 51,817 228,440 Total Total 6,189 11,074 11,074 11,740 11,740 51,817 Total from 20 year plan: New for 2014 65 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0206a Project Name Drug Task Force Vehicle -outfit leased vehicle Future Description 'ost to outfit leased Drug Task Force vehicle Department Police Contact Police Chief Type Equipment Useful Life Category Vehicles Priority n/a Total Project Cost: $55,000 Justification Ye need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. vehicle will be replaced every 2 years with the 2nd two years of the lease going to a Detective. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 5,000 Equipment 5,000 5,000 10,000 40,000 Total Total 5,000 5,000 10,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 5,000 Equipment Replacement Fund 5,000 5,000 10,000 40,000 Total Total 5,000 5,000 10,000 Total Budget Impact/Other iariance from 20 year plan: Cost of outfitting DTT vehicles is now accounted for separately from the vehicle purchase since the vehicle is now iow leased. Monday, June 16, 2014 66 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0210 Project Name School Resource Officer Car Future Department Police Contact Police Chief Type Equipment Useful Life 4 years Category Vehicles Priority n/a Description Total Project Cost: $270,308 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. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 6;000 6,000 11,205 11,205 11,879 46,289 224,019 Tom Funding Sources Equipment Replacement Fund 6,000 2015 6;000 6,000 2016 6,000 11,205 2017 11,205 11,205 2018 11,205 11,879 2019 11,879 46,289 Total 46,289 Total Future 224,019 Total 6,000 6,000 11,205 11,205 11,879 46,289 Total from 20 year plan: New for 2015 67 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0210a Project Name School Resource Ofcr Car -outfit leased vehicle Future Description 'ost to outfit leased Focus vehicle Department Police Contact Police Chief Type Equipment Useful Life 5,000 Category Vehicles Priority n/a Total Project Cost: $50,000 Justification 7Ve need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. ocus vehicle will be replaced every 2 years with the 2nd two years of the lease going to a Detective Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 5,000 5,000 5,000 15,000 35,000 Total 5,000 5,000 5,000 15,000 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 5,000 5,000 5,000 15,000 35,000 Total 5,000 5,000 5,000 15,000 Total 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 iow leased. Monday, June 16, 2014 68 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0211 Project Name Network Server (3) Future Department Police Contact Police Chief/IT Type Equipment Useful Life 3 years Category Equipment Priority n/a Description Total Project Cost: $402,000 'omputer servers store information and system programs. ane server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01 -ERP -213) Justification knnual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used or data storage. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 102,000 Equipment 15,000 15,000 15,000 15,000 15,000 75,000 225,000 Total Total 15,000 15,000 15,000 15,000 15,000 75,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 102,000 Equipment Replacement Fund 15,000 15,000 15,000 15,000 15,000 75,000 225,000 Total Total 15,000 15,000 15,000 15,000 15,000 75,000 Total Budget Ifnpact/Qther Variance from 20 year plan - Increase from 8,500 to 15,000. Software licensing has become more expensive. We are paying half our server )udget for required software and 8,500 isn't enough anymore. ?stimate salvage/resale value on replaced item - $ Monday, June 16, 2014 69 EQUIPMENT REPLACEMENT PLAN 2015 thru 2019 City of Hopkins, MN Project # 01 -ERP -0214 Project Name Tactical Ballistic Vests Future Department Police Contact Police Chief Type Equipment Useful Life 5 years Category Equipment Priority n/a Description I Total Project Cost: $179,500 Cactical ballistic vests worn by members of the Hopkins Police Department High-risk Entry and Assault Team (HEAT). These vests offer a higher evel of protection against weapon assault than the regular duty ballistic vest. 11 - 2008 Titan Tactical Ballistic Vests Justification ederal and State grant monies have been available through the Ballistic Vest Program over the past several years. These grants only pay a portion )f 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 JVarranty on the current vests expires in 2013. 'ost: 11 vests Prior Expenditures 2015 2016 2017 2018 2019 Total Future 43,200 Equipment 26,900 26,900 109,400 Total Total 26,900 26,900 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 43,200 Equipment Replacement Fund 26,900 26,900 109,400 Total Total 26,900 26,900 Total Budget Iolpact/Qther Variance from 20 year plan - Team membership has increased to 11. ?stimate salvage/resale value on replaced item: $ 70 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 thru 2019 City of Hopkins, MN 'roject # 01 -ERP -0215 'roject Name Radios -Portable and Mobile Devices Future Department Police Contact Police Chief Type Equipment Useful Life Equipment Category Equipment Priority n/a Description I Total Project Cost: $583,600 'ortable and mobile radios used by the police, fire and public works departments to allow these departments to communicate on one frequency. 'olice and fire use their radios on a daily/regular basis. The public works only uses theirs in the event of an emergency. ?stimated 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 'olice Est Cost $363,500 ire Est Cost $236,500 'ub Works Est Cost $ 0 Justification 'rovides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county ile radios were replaced in police cars due to new model cars: - replaced in Captain car, squad #3, & #5 (3 = $12,300) - replace in Squad #1, #2, PSO, Chief, DTF (5 = $20,500) - 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 - replace in squad parking (1 = $4,100) - some cars are duplicated as thev are moved down to investieators Prior Expenditures 2015 2016 2017 2018 2019 Total 32,800 Equipment 12;300 4;100 534;400 550,800 Total Prior Total Funding Sources 12,300 2015 4,100 2016 534,400 2017 2018 550,800 2019 Total 32,800 Total Equipment Replacement Fund Total 12,300 12,300 4,100 4,100 534,400 534,400 550,800 550,800 ariance 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 xy a new model of radio to fit into the squads.. stimate salvage/resale value on replaced item: $0 Monday, June 16, 2014 rf' EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0217 Project Name Taser Replacement Future Department Police Contact Police Captain Type Equipment Useful Life 4 years Category Equipment Priority 3lmportant Description I Total Project Cost: $119,300 Che 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 Che current Tasers will need to be replaced due to the age and use of the equipment. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 18,600 Equipment 20,900 20,900 79,800 Total Total 20,900 20,900 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 18,600 Equipment Replacement Fund 20,900 20,900 79,800 Total Total 20,900 20,900 Total Budget Ilmpact/Other Jsing the numbers obtained from Tasers Bob Lovering, the cost breaks down as shown below X2 Tasers $7,600.00 HD Cams $3,999.60 4yr Warranty/X2 $2,399.92 4yr Warranty/Cam $1,199.96 i Blade Tech Holsters $ 359.70 i6 Cartridges $1,621.20 )ownload Kit $ 14.95 ;hipping $ 120.00 Total $17,315.33 (plus tax) w/Tax est $18,575 NJ, Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 Department Police City of Hopkins, M1V7�� Contact Police Chief/IT Type Equipment Useful Life 4 years Category Equipment Future Priority n/a Description Total Project Cost: $85,000 3uilding Video Server hardware and associated software is used to store video recorded by the cameras in and around the police department ncluding interview rooms as well as booking. We record approximately 6 TB of video every 2-3 weeks. Large amounts of storage are required or 30 days of archival storage on the server itself. Justification vlaintenance agreement with software vendor needs to be renewed every three years. Computer hardware should be refreshed around the same ime to mimimize drive failure and take advantage of new storage technology. Expenditures 2015 2016 2017 2018 2019 Equipment 17,000 17,000 Total 17,000 17,000 Funding Sources 2015 2016 2017 2018 2019 Drug Task Force Funds 17,000 Equipment Replacement Fund Total 17,000 17,000 17,000 Total Future 34,000 51,000 34,000 Total Total Future 17,000 51,000 17,000 Total Budget Ifnpact/Qther Variance from 20 year plan - New item. Current equipment was purchased with DTF funding as will the 2015 replacement. Beginning in 2019 it vill be funded with ERP funds. ?stimate salvage/resale value on replaced item: $-0- Monday, June I6, 2014 73 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0710 Project Name 4X4 1/2 Ton Truck Future Description 'ickup used by various divisions of Public Works. Justification eight hauling and transportation for supervisors. Maintenance garage service vehicle. Department Public Works: Bldg/Equip Ser Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $96,700 Prior Expenditures 2015 2016 2017 2018 2019 Total Future 23,300 Vehicles 31,300 31,300 42,100 Total Total 31,300 31,300 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 23,300 Equipment Replacement Fund 31,300 31;300 42,100 Total Total 31,300 31,300 Total Budget Impact/Qther Jariance from 20 year plan - move up from 2009 to 2008 - Fire Dept has requested to acquire surplus pickup for its use by daytime responders. ?stimate salvage/resale value on replaced item: $1,500 Monday, June 16, 2014 74 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0807 Project Name Trucksters (3) Future Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 15 years Category Equipment Priority n/a Description Total Project Cost: $145,440 Fruckster used by Parks Division of Public Works for ballfield and parks maintenance. 1996 Toro Workman W818), 2004 Toro Workman 3200 (9820), 2004 Toro Workman 2110 Justification 'ark maintenance, ballfield grooming and weed spraying. Prior Expenditures 40,900 Equipment Total 2015 2016 2017 2018 2019 Total Future 34,200 34,200 70,340 Tom 34,200 34,200 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 40,900 Equipment Replacement Fund 34,200 34,200 70,340 Total Total 34,200 34,200 Total e from 20 year plan - Move from 2013 to 2014. salvage/resale value on replaced item: (3) $1,400 each to $11,000 to purchase a electric style workman. rV Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project 9 01 -ERP -0808 Project Name Riding Mowers (2) Future Description tiding mowers used by Parks Divison of Public Works. 2004 Toro Zero Turn (8826), 2006 Jacobson Justification dowing city parks and right of ways. Mower (9823) Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost: $169,000 Prior Expenditures 2015 2016 2017 2018 2019 Total Future 49,000 Equipment 11,000 20,000 31,000 89,000 Total Total 11,000 20,000 31,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 49,000 Equipment Replacement Fund 11,000 20,000 31,000 89,000 Total Total 11,000 20,000 31,000 Total Budget Impact/Other I 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 re EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0809 Project Name Slope Mower Future Description 2001 DEW EZE ATM72 Slope Mower Justification Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 15 years Category Equipment Priority n/a Total Project Cost: $83,600 Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 32,700 32;700 50,900 Tom Funding Sources 2015 Equipment Replacement Fund 32,700 2016 2017 32,700 32,700 2018 2019 Total 32,700 Total Future 50,900 Total 32,700 32,700 Total from 20 year plan - none salvage/resale value on replaced item: $1,000 77 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0811 Project Name Turf Sweeper Future Description Curf sweeper used by Parks Division of Public Works. Justification ipring and fall leaf pick up, debris pick up. Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 15 years Category Equipment Priority n/a Total Project Cost: $57,600 Prior Expenditures 2015 2016 2017 2018 2019 Total Future 11,600 Equipment 18,000 18,000 28,000 Total Total 18,000 18,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 11,600 Equipment Replacement Fund 18,000 18,000 28,000 Total Total 18,000 18,000 Total Budget Impact/Qtier Jariance from 20 year plan - move from 2001 to 2003 - current unit in good condition. ?stimate salvage/resale value on replaced item: $1,500 Monday, June 16, 2014 78 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0812 Project Name Stump Cutter Future Description hump 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. 2015 thru 2019 Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost: $21,200 Expenditures 2015 2016 2017 2018 2019 Total Equipment 21,200 21,200 Total Funding Sources 2015 21,200 2016 2017 2018 21,200 2019 Total Equipment Replacement Fund 21,200 21,200 Total 21,200 21,200 Budget Imlpact/Other Jariance from 20 year plan - extend to 20 years to reflect actual. ?stimate salvage/resale value on replaced item: $1,800 79 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0815 Project Name Skid Loader Future Description 2004 Bobcat 463 Justification Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost: $77,600 Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 32,000 32,000 45,600 Total Funding Sources 2015 Equipment Replacement Fund 32,000 2016 2017 2018 32,000 32,000 2019 Total 32,000 Total Future 45,600 Total 32,000 32,000 Total from 20 year plan - new item in 2004. salvage/resale value on replaced item: $ 80 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 thm 2019 City of Hopkins, MN Project # 01 -ERP -0816 Project Name Toolcat Future Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 8 years Category Equipment Priority n/a Description I Total Project Cost: $295,100 Jse by Public Works for snow removal, skating rinks, sweeping, ballfield maintenance and transportation of people and materials. vehicle: 2010 Bobcat (9815) Justification few machine. Prior Expenditures 2015 2016 2017 2018 2019 Total Future 50,000 Equipment 63,300 63,300 181,800 Total Total 63,300 63,300 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 50,000 Equipment Replacement Fund 63,300 63,300 181,800 Total Total 63,300 63,300 Total Budget Iulpact/Qtier Jariance from 20 year plan - New item which replaces one tractor. ?stimate salvage/resale value on replaced item: $ 81 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 thru 2019 City of Hopkins, MN Project # 01 -ERP -0817 Project Name Grass Seed Applicator (Overseeder) Future Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 15 years Category Equipment Priority n/a Description Total Project Cost: $29,400 'ull 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 ields 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 nto use conflicts as both communities need the overseeder during the same period between seasons and missed opportunities to seed are ronortunities lost until next season. Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 11,500 11,500 17,900 Total 11,500 11,500 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 11,500 11,500 17,900 Total 11,500 11,500 Total Budget Impact/Qther Variance from 20 year plan - New item. ?stimate salvage/resale value on replace item: $-0- 82 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 thru 2019 City of Hopkins, MN Project # 01 -ERP -0301 Project Name 4X4 3/4 Ton Truck with Plow Future Description {A ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers. Current vehicle: 2006 Ford F250 (11302) Justification Light hauling, pulling trailers, transportation to and from job sites. Prior Expenditures 24,000 Vehicles Total Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 8 years Category Vehicles Priority n/a Total Project Cost: $141,700 2015 2016 2017 2018 2019 Total Future 30,400 30,400 87,300 Total 30,400 30,400 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 24,000 Equipment Replacement Fund 30,400 30,400 87,300 Total Total 30,400 30,400 Total from 20 year plan - Unit in good condition - move out 2 years. salvage/resale value on replaced item: $1,500 83 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0302 Project Name 4x2 1 Ton Dump Truck Future Description Cruck 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. Prior Expenditures 30,500 Equipment Total Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost: $162,900 2015 2016 2017 2018 2019 Total Future 54,600 54,600 77,800 Tom 54,600 54,600 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 30,500 Equipment Replacement Fund 54,600 54,600 77,800 Total Total 54,600 54,600 Total 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 2015 Mm 2019 City of Hopkins, MN Project # 01 -ERP -0305 Project Name Single Axle Dump Truck (3) Future Description Tingle axle dump truck used by various division of Public Works. Current vehicles: 2001 Ford L7501 (#313) & 2005 Freightliner M2 106 (9312) Justification Vehicle used for heavy hauling, snow plowing and sanding. Adding additional single axle truck in place of tandem truck from 01 -ERP -306. Prior Expenditures 207,400 Vehicles Total Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 17 years Category Vehicles Priority n/a Total Project Cost: $674,100 2015 2016 2017 2018 2019 Total Future 124,000 124,000 342,700 Total 124,000 124,000 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 207,400 Equipment Replacement Fund 124,000 124,000 342,700 Total Total 124,000 124,000 Total triance from 20 year plan - Move 1 truck from tandem (was in 101 -ERP -306) to single axle for 2012. timate salvage/resale value on replaced item: $4,500 each e 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 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0306 Project Name Tandem Dump Truck Future Description dump truck used in Streets Division of Public Works. Current vehicles: 1998 Ford LT8500 Tandem (9314) Justification Trucks used for heavy hauling, snow plowing and sanding. Prior Expenditures 22,000 Vehicles Total Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 17 years Category Vehicles Priority n/a Total Project Cost: $481,500 2015 2016 2017 2018 2019 Total Future 173,200 173,200 286,300 Tom 173,200 173,200 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 22,000 Equipment Replacement Fund 173,200 173,200 286,300 Total Total 173,200 173,200 Total from 20 year plan - Move from 2018 to 2017. salvage/resale value on replaced item: $-0- 86 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0307 Project Name Water Truck Future Description ]Vater 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. Prior Expenditures 45,000 Vehicles Total Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 22 years Category Vehicles Priority n/a Total Project Cost: $195,000 2015 2016 2017 2018 2019 Total 150,000 150,000 Total 150,000 150,000 Prior Funding Sources 2015 2016 2017 2018 2019 Total 45,000 Equipment Replacement Fund 150,000 150,000 Total Total 150,000 150,000 Budget Impact/Qthel 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 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0309 Project Name Skid Loader (2) Future Description ,oading trucks, landscape work, snow removal, material handling. Justification Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost: $258,900 2004 Bobcat S-185 IR Skid Loader (#324) & 2011 Bobcat S650 Skid -Steer Loader Prior Expenditures 36,000 Equipment Total 2015 2016 2017 2018 2019 Total Future 41;900 41,900 181,000 Tom 41,900 41,900 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 36,000 Equipment Replacement Fund 41,900 41,900 181,000 Total Total 41,900 41,900 Total from 20 year plan - move back from 2010 to 2011. salvage/resale value on replaced item: $ 88 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0312 Project Name Roller Future Description Jsed by Street Department for asphalt repair and resurfacing. 1989 Ingersoll Rand Roller Justification Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost: $127,900 Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 45;900 45,900 82,000 Total Funding Sources 2015 Equipment Replacement Fund 45,900 2016 2017 45,900 45,900 2018 2019 Total 45,900 Total Future 82,000 Total 45,900 45,900 Total from 20 year plan - Move back from 2014 to 2016. salvage/resale value on replaced item: $ 89 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0313 Project Name Striper Future Description eine striper. 1993 Line Striper A1990 Justification Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost: $27,200 Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 11;200 11,200 16,000 Total Funding Sources 2015 Equipment Replacement Fund 11,200 2016 2017 2018 11,200 11,200 2019 Total 11,200 Total Future 16,000 Total 11,200 11,200 Total from 20 year plan - none salvage/resale value on replaced item: $ 90 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0314 Project Name Asphalt Paver Future Description ksphalt paver used by Streets Division of Public Works. 1994 Caterpillar AD200B Paver Justification Saving streets and parking lots. Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost: $138,800 Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 48;800 48,800 90,000 Tom Funding Sources 2015 Equipment Replacement Fund 48,800 2016 2017 48,800 48,800 2018 2019 Total 48,800 Total Future 90,000 Total 48,800 48,800 Total from 20 year plan. Move back from 2014 to 2015 salvage/resale value on replaced item: $500 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 Department Public Works: Streets/Traffic City of Hopkins, MN Contact Public Works Director Project # 01 -ERP -0317 Type Equipment Useful Life 10 years Project Name Sign Machine (Traffic) Category Equipment Future Priority n/a Description Total Project Cost: $31,500 dahcine used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city use. 2005 Signcad Sign Making System (#353) Justification ?xisting machine is not repairable and needs updating/ Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 13,400 13,400 18,100 Total 13,400 13,400 Total Funding Sources 2015 2016 2017 2018 2019 Total Future Equipment Replacement Fund 13,400 13,400 18,100 Total 13,400 13,400 Total Budget Impact/Other Jariance from 20 year plan - Move back to 2016 ?stimate salvage/resale value on replaced item: $-0- MA Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0900 Project Name Refuse Truck (RAP -R) (2) Future Description Zefuse truck used by Refuse Utility Division of Public Works. 'urent vehicle: 2005 Peterbilt Justification Zesidential waste pick up. Prior Expenditures 349,100 Vehicles Total Prior Funding Sources 349,100 RF - Refuse Fund Total Rail (#901) & 2011 Rail Department Refuse Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $1,462,600 2015 2016 2017 2018 2019 Total Future 204;800 204,800 908,700 Total 204,800 204,800 Total 2015 2016 2017 2018 2019 Total Future 204;800 204,800 908,700 Total 204,800 204,800 Total from 20 year plan - increase cost to reflect actual salvage/resale value on replaced item: $18,000 93 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0901 Project Name Refuse Truck (Rear -L) Future Description Zefuse truck used by Refuse Utility Division of Public Works. 'urrent vehicle: 1996 Freightliner FL70 Justification Zesidential waste pick up. Department Refuse Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $238,100 Expenditures 2015 2016 2017 2018 2019 Total Future Vehicles 101,600 101,600 136,500 Total Funding Sources 2015 RF - Refuse Fund 101,600 2016 2017 101,600 101,600 2018 2019 Total 101,600 Total Future 136,500 Total 101,600 101,600 Total from 20 year plan. Move back one year to evaluate needs. salvage/resale value on replaced item: $9,000 94 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0551 Project Name 3/4 Ton Utility Truck Future Description {A ton utility truck used by the Water/Sewer Division of Public Works. Department Sewer Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $129,800 JCurrrent 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. Prior Expenditures 51,000 Vehicles Total 2015 2016 2017 2018 2019 Total Future 33,600 33,600 45,200 Total 33,600 33,600 Total Prior Funding Sources 2015 2016 2017 2018 2019 Total Future 51,000 SF - Sanitary Sewer Fund 33,600 33,600 45,200 Total Total 33,600 33,600 Total from 20 year plan - none salvage/resale value on replaced item: $2,500 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0555 Project Name Generator (2) Future Description 'ortable generator used by Water/Sewer Divisions of Public Works. 1997 Kohler Generator, 2008 Caterpillar C15 Justification ?mergency back up generator for lift stations and pumps, off site power for lights and welding. Department Sewer Contact Public Works Director Type Equipment Useful Life 25 years Category Equipment Priority n/a Total Project Cost: $49,400 Expenditures 2015 2016 2017 2018 2019 Total Future Equipment 26,400 26,400 23,000 Total Funding Sources 2015 SF - Sanitary Sewer Fund 26,400 2016 2017 2018 26,400 26,400 2019 Total 26,400 Total Future 23,000 Total 26,400 26,400 Total from 20 year plan - none salvage/resale value on replaced item: $2,500 �I: Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0500 Project Name 1/2 Ton Truck Future Description Frucks used by Water Department. 'urrent vehicle: 2007 Chevrolet Justification Prior Expenditures 20,500 Vehicles Total Prior Funding Sources 20,500 WF - Water Fund Total Department Water Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $83,300 2015 2016 2017 2018 2019 Total Future 26,800 26,800 36,000 Total 26,800 26,800 Total 2015 2016 2017 2018 2019 Total Future 26,800 26,800 36,000 Total 26,800 26,800 Total from 20 year plan - none salvage/resale value on replaced item: $ 97 Monday, June 16, 2014 EQUIPMENT REPLACEMENT PLAN 2015 Mm 2019 City of Hopkins, MIST Project # 01 -ERP -0501 Project Name 3/4 Ton Utility Truck Future Description {A ton utility truck used by the Water Division of Public Works. Department Water Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $81,800 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. Expenditures 2015 2016 2017 2018 2019 Total Future Vehicles 34,900 34,900 46,900 Tom 34,900 34,900 Total Funding Sources 2015 2016 2017 2018 2019 Total Future WF - Water Fund 34,900 34,900 46,900 Total 34,900 34,900 Total from 20 year plan - none salvage/resale value on replaced item: $2,500 98 Monday, June 16, 2014 TWENTY-YEAR REPLACEMENT SCHEDULE 99 --qca City or Hops Will 1]am-14 IT-ATIDN FACTOR 10% EQUIPMIF'Ni TREPLACEND:NTSCHEDUL: REPL EQUIPMENT NEHICLES YRS 2015 2016 201] 2018 2019 2020 2021 2022 2023 2- 2025 2- 2027 2028 2029 2030 2031 2032 2033 2034 ACITVITY CENTER ERP -030 Copy-ffime(tobe heal) ERP -031 ReGigaatu/Era'za 30 1 ERP 032 Swvd Sym® 15 8,800 13700 HRP -033 Tables SUBTOTAL 15 1200 19,000 21,000 1 32]00 ARTS CENTER ERP -1100 Copy M ffime(Iasal) ERP -1101 CmpaExhazfa 10 5200 7,000 ERP -1102 Kitch® Cmaivg Egvipm®t 12 7,100 ERP -1103 Vidm Camas Updabs 5 3,7()() i,- 5,000 5,800 ERP -1104 Tlo-Projata 5 17,100 ]9,800 22,- 2900 ERP -1105 ly Raav AN M ] 11,()W 13,500 16,bOD D1=1-b. ERP-110fi DigJal Ivfmvatiov 9igo M1 5 25000 2,300 2,]00 3,100 ERP -110] Th—Pryatiov Svc ]0 6]00 9,000 ERP -1108 Th-Prmm.ffi M ,h- fi 7,100 8500 10,200 HRP -1109 Flaa Savbba to 8,000 10,800 21,700 17,100 13,700 18,700 19,800 6,700 18,500 15,600 22,90() 16,600 8,900 17,200 9,000 CITY HALL ADMEN ERP -003 N-kUpgrade 1 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,0()0 15,000 15,0()0 15,000 15,000 15,000 15,000 15,000 15,000 15,000 ERP -004 Phove s-8 76,000 76,()00 93,500 EPR.. Fivevael6oftwme 7 ER - Cavpvtav 3-5 3(),000 3(),000 3(),000 3D,- .,WD 30,000 30,000 3(),000 30,000 3(),000 3D,O. 3D,O. 3(),000 3D,000 30,000 30,00() 30,00() 30,000 30,0()0 30,0()0 ERP -009 NtlwakIvfiash -Upgrade 15 23,400 ERP -012 -N-k SWit 6 12,000 14,300 1],000 EQUIPMENT SUBTOTAL 121,000 45,000 45,000 57,000 45,000 45,000 45,000 fi8,400 121,000 59,300 45,000 45,000 45,000 45,000 45,000 62,MO 138,500 45,000 45,000 45,000 COMMUNITY SER110ES EAP -0O] M®v Copia (lea i) ERP -002 Smill Copia (tobekasal) ERP-0O8Doeum®[Mg�vt 6vavva(2) 4 10,000 11,300 12,700 14,300 16,000 EAP -0]0 Elstim Badha 20 ERP oil Ela .H vipm- to EQUIPMENT SUBTOTAL i iw 11,300 1270() 14,300 16,000 101 REPL EQL]PME\T NEMCLES YRS 2015 2016 201] 2018 2019 2020 2021 2022 2023 2028 2025 2026 202] 2028 2029 2030 2031 2032 2039 2034 FIRE ERP -100 TeleSquik E-2 ]0 b5D,000 8]3,500 ERP -101 Fire Puapa EJ 20 ]22,400 ERP-103Duly ChiefVdkle 5 ERP-_ Fi ty Chief&] ityL JVeLi 4 19606 19606 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]0] 32,]D] 32,]D] 32,]D] 32,]0] ERP -]036 Outfit Duty Chie L�.sxl V hicks 4 10,000 1D,000 10,0011 ]0,0110 10,000 1O,D00 1D,000 10,000 ]0,0110 10,- 0,000ERP-1D5 I- ID5 Quick Attack Puapa/Rawe R I0 314,500 422,600 ERP -106 Aaial Thick L-9 20 54217 54217 54217 54,217 1,572,000 VEHICLES SUBTOTAL 83,823 73,823 746,924 86,924 42,]0] 32,]0] 42,]0] 34],20] 42,]0] 32,]0] 42,]0] ]55,10] 916,20] 1,604,]D] 42,]D] 32,]D] 42,]0] 4553D7 42,]D] 32,]0] ERP -]0] Air Cavpr- 15 31,900 54,4W ERP -108 -thmg Appavms(45)(SCBA) W 25D,000 336,000 ERP -109 Ealricffiiw Twl(2) 10 2],400. 30,- 36,90D 403DD ERP -110 Copy Nmchme (tobe l��) ERP -112 Tharnal laagmg Csaaa (2) 10 12,900 15,- 17,400 20,]00 ERP -]]3 Em g -Z preparalvecs 6hm 20 38,5W ERP -114 Flaw Saubba 12 14,- 203W ERP -]]6 Wakwl Equip - Eliptiml 6 5,800 6,]00 ],800 9300 ERP -117 Wakwt Equip-TreadaiR 41 5 5800 6,7.],800 9000 ERP118Wakwt Equip-Tr�dain42 5 5,800 6,]00 ]800 90D0 ERP -119 Wakwt Equip-Waght Lifting 5 5,800 6,]00 7,800 91OOD ERP120Defi BW(2) 4 7,800 8,600 9300 10,20011"m ERP -122 Wakwt Equip-Duab Be➢s to 5000 6,]DO ERP -215 RadiosPalabk&Mobile to -15 236,500 ' EQUIPMENT SUBTOTAL 31,700 284,900 260,200 7,800 27,400 13400 6,]00 45300 15400 15,wo 383,800 60,000 36,900 28,200 54,400 49300 30,000 11,500 POLICE ERP -200 Squad 41 4204 3 49,OW 53,]00 58,]00 64,000 ]0,000 ]6,600 ERP -200 Squad 42 420] 3 49,- 13,7.58,]00 64,000 ]D,- 76,60D ERP -200 Squad 43 4208 3 45000 49000 53,]00 58,]00 64,000 ]0,000 ]6,500 ERP -200 Squad *IT3 450D0 49000 53,]00 58,]00 64,000 70,OW ]6,60D ERP -2011 Squad 45 4229 3 4500D 49000 53,]00 58,]00 64,000 ]0,00076,1W ERP -200 Squad 46 4200 3 45000 49,DW 53,7W 58,70D 64- ]O,- ]6,600 ERP-201Sag-drick 4209 4 45000 50,600 5],000 64,000 72000 ERP_ Parking Vehicle 4211 to 2]200 36,600 ERP -203 PSOUfilh- 4212 660,400 ]2,100 86,100 ERP -204 Ad Car 4 (chief) -l�sal 2 5,923 klW 6,100 6,470 6,470 6,8]0 6,870 ]29D 7,29D ],]30 7,730 8200 820D 8,7W 8,7W 9230 9230 9,]90 9]90 10390 ERP -204a Outfi--i Ad Car 5,OOD 5WD S,ODO S,ODO S,ODO 5000 50D0 5,000 5,000 5,w0 Chiefcar to lw Sergeant -teasel 2 4,694 4,694 4,98D 4,98D 5280 5280 5,600 5,600 5900 5900 6,30D 630D 6,690 6,690 ],IW ],IOD ],530 ],530 ],990 ERP -204 Adaw Car 4218 (captain) 2 6,000 6,000 63]0 63]0 6,]50 6,750 7,160 7,160 ],600 ],6W 8,060 8,060 8,560 8,560 9080 9080 9,630 9630 1D220 10220 ERP -204a OutfilLasal Adaw Car 5000 5,w 5000 5000 5,wo 5000 5wo 5,wo 5000 5000 Capt car to D-we3-t-s 2 4,835 4,835 5,129 5,129 5440 5440 5770 5770 6,100 6,100 6,500 6,500 6,900 6,900 ]300 ]300 7,]50 7,]50 ERP -206 Drug Task Face -1 1 2 6,189 6,380 6380 6,]60 6,]60 ],180 ],180 ],610 ],610 8,D8D 8,080 8,5]D 8,5]D 9090 9090 96- 9640 10230 10230 10,850 I__� OutfitL� iDTF rer 5,000 5," 5,000 5000 5,000 S,ODO 5'" 5000 0D 50D 5000 -- OTFfo DB wel-l-s 2 4,694 4,694 4,980 4,980 5,280 5280 5600 5600 5900 5900 63006,3W 6,690 6,690 ],100 ],100 7,53D ],530 ],990 ERP -210 ch Sool RerourceCar -lase] 2 6,000 6,000 6,3]0 6,3]0 6,750 6,750 7,160 7,160 ],600 ],600 8 ,060 8,060 8,560 8,560 9080 9080 9,630 9630 10,220 10,220 ERP -210a OutfilL 5000 5,w0 5000 5000 5000 5000 5000 5000 5000 School Rrnwree cart. -m e2 -1-s 2 4,835 4,835 5,129 5129 1'- 5440 5,]70 5,]]0 6,100 6,100 6,500 6,500 6,900 6,900 7,300 ]300 ],]50 7,750 ERP -205 SWATVdricle 4210 15 0,ow 77,90D ERP -206 police Svcs Li -ffimh de19a1 15 VE£3ICLES SUBTOTAL 169112 211,068 152278 153600 205548 226,168 167210 168,]00 23]240 181,750 183,330 301390 261,490 199290 213,130 215,030 366,830 318210 234220 23G160 ERP -208 Cavputa Sysfan 20 ERP-2091apy Machme(tobel��) ERP -210 Log Recede (del.x ERP) 7 ERP -211 -k Sava(3) 3 15000 15000 15000 15000 15000 15,W0 15000 15000 15000 15000 15,000 15000 15000 15,Dw 15000 15000 15000 15000 15000 15000 ERP -212 Mobile Data CanpulasDig"lCeases 7148,500 148,500 ERP214 Tactical Bani9 Vems(9) 5 26�OD 31,200 36200 42,000 ERP-215RadiosPatabm&Mobile 12,300 4,100 297,900 ERP -216 911Phwe Sys (Vipa)(del9ad) ERP217Tasa Repmcan®t 4 20,900 23,500 26500 29,80D ERP -218 Building Vidw Sava 4 17,- 17,000 17,000 17,000 17,000 EQUIPMENT SUBTOTAL 44,300 19100 333,800 41,900 32,000 15000 187,000 15000 63,200 15000 41,500 15000 32,000 199700 44,800 15,ow 32,OW 15,000 57,000 15000 102 P.W. STREETS/TRAFFIC ERP -300 4x43/4Tov T.ck/Pl- 10 28,9. 38,8. ERP -301 —3/4— .&M— 8 30,400 38,5. 4S,8. ERP -302 4x21 T- Dm Tmrk 12 54,6. ]],8. ERP -303 1 T® Dump Tmck 12 49,5. ERP -303 1T.D pT.& 12 51400 76,1. ERP -304 1T. Bmv—& 17 136,- 305 Siegle Axle Dome T.& 17 132,100 ERP -305 Siegle Axk Dump T.& 17 1.,— ERP-305 Smgle Axle Dm T.& 17 210,600 ER 1. Tavd,v Dump T.& 17 173200 2.,- -307 Water T.& 22 150,.0 ERP -308 Frmt Evd Load, 15 268,000 ERP308—Evd Load, 18 268,600 —1. Skid Laada 12 41,9. 59,7. ERP -309 Skid Laada 12 50,0. 713. ERP310 Grad, 20 ]w3. ERP -311 9wapa 20 156,400 —112 Roll, 20 45,900 ERP -313 Strip, 12 112. 16,0. ERP -314 Paver 20 48,800 ERP -315 Svow Bkw 20 ERP -316 Traiki 20 ERP317Sip ffime 10 13,4. ERP -318 Asphalt Het NSx Heafivg Box 12 22,1. ERP -319 Reg®aatese kSwap, 20 VEHICLES SLBTOTAL 30,4. 150,0. .4,.0 1]8,600 288,500 103,.0 3360W 716. 167,300 18100 268,.0 59,7. 3.,0. ]],800 48,800 38,8. 433,7. 103 EQL]PME\T NEHICLES YRS 2015 201fi 201] 2018 2019 2020 2021 2022 2023 202A 2025 2026 P.W. ADARN ERP -215 Radios-Patabk&Mobile P.W. BLDGJEOUkm,3 T SVCS ERP -]]0 12T.Tmck 10 313. ERP- 11 VeLicle Waeha 12 8300 313. 8,300 P.W. ENGINEERING ERP -]00 Evgweaivg V. 10 25900 28,900 P.W. PARKS & FORESTRY ERP SGO 12 T. T.& to 35,- -01 4x43/4Tov—& 8 42,6. ERP SGI —/4T.T.& 8 42,6. ERP -802 3/4 T.I ffity Tmdc to ERP -804 Log T.& (SG%w/Refu=e) 15 818. —05 Aerial Lift 20 ERP -806 E 807 T.— 30 Truckma (N818) 15 E 807 Tr &—(4820) 15 ERP -80] Tr &c (4821) 15 112. ERP�O8 Ilidivg Mov, (H823) 8 209. 253. ERPSO8 Ridivg Moxa(N826) 8 11000 13,9. EAP�09 Slope Moxa (N828) 15 3257. ERP -810 Lags TarfM (#825) 1D 92,7. ERP 811 Ta B9w 15 ERP -812 Stmvp CLfta 20 212. ERP$13 Brush Clipper 20 ERP 814 Traiki Elatbol 15 2,— ERP815 9kidLmda 12 32,- - TM8 633. 8D2. ERP$17 (3mas Sm Applicata 20 115. VEHICLES—TOTAL 22,5. 52,7. 53,200 81,300 342. 180,1. 81800 49,3. 25,300 802. P.W. STREETS/TRAFFIC ERP -300 4x43/4Tov T.ck/Pl- 10 28,9. 38,8. ERP -301 —3/4— .&M— 8 30,400 38,5. 4S,8. ERP -302 4x21 T- Dm Tmrk 12 54,6. ]],8. ERP -303 1 T® Dump Tmck 12 49,5. ERP -303 1T.D pT.& 12 51400 76,1. ERP -304 1T. Bmv—& 17 136,- 305 Siegle Axle Dome T.& 17 132,100 ERP -305 Siegle Axk Dump T.& 17 1.,— ERP-305 Smgle Axle Dm T.& 17 210,600 ER 1. Tavd,v Dump T.& 17 173200 2.,- -307 Water T.& 22 150,.0 ERP -308 Frmt Evd Load, 15 268,000 ERP308—Evd Load, 18 268,600 —1. Skid Laada 12 41,9. 59,7. ERP -309 Skid Laada 12 50,0. 713. ERP310 Grad, 20 ]w3. ERP -311 9wapa 20 156,400 —112 Roll, 20 45,900 ERP -313 Strip, 12 112. 16,0. ERP -314 Paver 20 48,800 ERP -315 Svow Bkw 20 ERP -316 Traiki 20 ERP317Sip ffime 10 13,4. ERP -318 Asphalt Het NSx Heafivg Box 12 22,1. ERP -319 Reg®aatese kSwap, 20 VEHICLES SLBTOTAL 30,4. 150,0. .4,.0 1]8,600 288,500 103,.0 3360W 716. 167,300 18100 268,.0 59,7. 3.,0. ]],800 48,800 38,8. 433,7. 103 REz'! EQLIPMEhT NEMSYRS 2015 201fi 201J 2018 2019 2020 2021 2022 2023 2028 202.5 2026 202] 2028 2029 2030 2031 2032 2N3 2034 HRA ERP -0o0 4x43/4Tov Tmck 8 325400 41,100 52,100 ERP -0O] Capia 8 ]6,500 20,900 SUBTOTAL WATER 32,400 16,500 41,100 20,900 52,100 ERP -500 1J2 T®Truck]0 26,800 36000 ERP -501 3/4 T. Utility T.ok ]0 34900 46,900 ERP -502 Backhoe 20 153,700 ERP -503 Air(:mprecae ERP-SOfi Copy-ohm,(to_l) 20 41,700 ERP -507 Tele h-Syat® 8 6,800 6,8[10 8,fi00 SUBTOTAL SEWER 6800 61,700 6800 82,900 41,700 8,fi00 153,700 ERP -5511 4x43/417ov Thick]0 40300 54200 ERP -551 3/4 T®Utility Truck ]0 33,600 45200 ERP -552 I4 Vador ERP -555 G®affiQ 20 1811,8110 25 26,400 ERP -555 Go- -157 TelTh-Syat® 2523,000 8 68[111 6,800 8,600 SUBTOTAL 6800 33,fio0 26400 180,800 23,000 6800 40,300 41,200 8,fi00 54,200 REFUSE ERP -9110 Refuse Truck (RAP -R) ]0 2111,800 2]5,2110 ERP -900 Refse Truck (R-) 10 270300 3632o0 ERP -901 RefsTruck(--L) 111 ioi,fi110 136,5D0 ERP -803 Swap Laada 20 144800 ERP -804 Lag Truck (5- -T -AL 201,8011 1111,6011 270300 81,800 275,200 13650D 144,8011 363,2011 STOR ISEVVT.R PAVILION ERP -loon 12 178,000 ERP -1001 Elxtric [ce Edge 12 9,700 EAP -1002 Arnie Sem�amd 211 12,000 ERP -1003 Flaw Swbba ERP -1004 Sm -Lift 104 EQLTPMENT NEHICLES GENERAL FUNAVEHICLES/EQU1P 305,835 487,591 1286,802 53172A 2825455 438,975 49$417 ]01,10] fi65247 -,257 393337 1,157797 1445 fig] 2,062,497 681,577 fi96,937 526,93] 805,64] 435,02] $96,167 GENERAL FOND-0THER w- 21$ODO 359,OD0 639,DOD 1.,7. 104,401 93,OD0 23$700 128,]00 199,600 87,OD0 1.,- 443,8D0 137,000 259,000 126,70D 137,900 22A,%O 136,8W 132,000 71,SOD HRA 32,400 16,500 41100 20,900 525100 ARTS CENTER 21700 ]],IOD 13,7OD 18,7W 19,800 6,]00 185D0 15,600 22,900 16,600 $900 17200 9,000 WATER 6,800 61,700 6800 82,900 41700 $fi00 153,700 SEWER 6,800 33600 26,4W 180,800 23,DOD 6,80D 40,3D0 452W 8,fi0D 54200 REPUSE 204,800 1O1fi00 2]0,300 81,800 275200 136,500 144,800 363200 STORMSEWER PA m- 125000 9,000 187,7D0 13,OW 125100 GENERAL FUND'. HRA TOTAL ARTS CENTER Fl UT-FUNDSI TOTAL ALL FLT GENERAL FUND! NET GENERAL FL 20YEARAVERA( ACTNITY CENTE CITY HALL ADMI COMMUMTY SEF FIRE EQ--- UIPMENT -I-.Q--- POLICEEQUIPMENT B- B-D QOIPMENF SERVICES EQ� ENGEJEE -EQUIPMENT PARKS&-STRY EQ - STREET EQUIPMENL GENERALFUNDVEHI--QUIPMENT GENERAL FOND OTHER EQUIPMENT GENERAL FUND TOTAL HRA ARTS CENTER FUND WATER OTR,ITY FOND SEWERO 7Y FUND REFUSE -7Y FUND STORM SEWER --TY FUND -v-- UTII.ITY VEFTtCLES/ QU@MENT 523,835 846,591 1,925,802 B8,- 386,856 5319]5 737,117 829,807 864,847 42],25] 493437 16D159] 1,582,69] 2,32149] 8D8,- 834,837 ]51,83] 942,44] 56],D27 96],66] 32,400 16,500 41,100 20,90D 52,1W 24,]00 17,100 13,700 18,700 19,800 6,700 1$SDO 15,600 22,900 16,600 $900 17200 9,000 218,400 147200 88,100 180,800 270,300 1D180D 13,- 49,300 275200 369,400 ffi,900 41,7W 13,000 144,8D0 380,40D 153,7W 66,30D ]99,335 993,]91 2,013,902 655,52A 386,856 ]26,4]5 100],417 9®,507 939,347 483,25] ]89,13] 1986,59] 1665,59] 2,386,09] 83],8]7 1,009,43] 1184,337 1113,347 483835 806,591 1,885,802 59$421 346,856 4919]5 69],11] ]89,80] 821,84] 38],25] 455,437 1561 597 1512,69] 2,28149] 76$2]] ]94,83] ]11,83] 9D2,447 527,D27 Tofet Av- 53,]01 2,700 1212200 fi0,fi00 64,3W 3200 1,233,3. 61,700 932W 4,- 67,700 3,400 1626,210 81,300 2,96$100 -,- 4,659,830 733- 3,92A.1 330003,926,001 -,- 18,585,831 96,300 105 --qca City or Hops EQUIPMENT AND BUILDING INVENTORY I W N --qca City or Hops 111M CITY OF HOPKINS BUILDING INVENTORY January 2014 Location/Description Replacement Cost City Hall & Police Station $7,724,424 1010 1st Street S. Fire Station 4,496,359 101 17th Avenue S. Hopkins Activity Center 1,947,409 33 14th Avenue S. Ice Arena/Pavilion 5,347,585 11000 Excelsior Boulevard Arts Center 7,325,210 1111 Mainstreet PW Admin/Garage 7,649,942 11100 Excelsior Boulevard Moline Reservoir/Well 91 2,450,851 10421 Excelsor Boulevard Blake Tower Reservior 1,478,791 151 Tyler Avenue South Filtration Plant 3,603,386 1401 Elmo Park Service Road Well 44 Workshop/Storage 694,892 1401 Elmo Park Service Road Well 95 244,181 1205 Highway? Well 96 325,588 801 Highway 7 Lift Station 92 - Drillane 69,461 619 Drillane Road Lift Station 93 - Lindee's 138,777 901 Cambridge Street N.E. Lift Station #4 - LTL Meadowbrook 101,560 244 Meadowbrook Road Lift Station 95 - Big Meadowbrook 161,279 6601 Excelsior Blvd. 109 Location/Description Renlacement Cost Lift Station #6 - Ronnie's $101,560 8546 Excelsior Avenue E. Lift Station #7 - Valley 320,926 801 6th Avenue S. Band Shell - Downtown Park 38,391 16 9th Avenue S. Concession Stand - Maetzold Field 159,010 1215 1 st Street N. Park Building -Beach - Lifeguards 171,586 5200 Shady Oak Road Park Building -Beach -Concessions 162,152 5200 Shady Oak Road Park Shelter - Office/Bathhouse 393,880 5200 Shady Oak Road Park Shelter - Burnes 52,405 201 Park Lane Park Building - Central 118,960 101 17th Avenue S. Park Building - Harley 40,310 108 Jackson Avenue S. Park Shelter - Interlachen 64,423 220 Homedale Avenue Park Building - Oakes 45,963 301 Tyler Avenue N. Park Building - Valley 54,016 800 7th Avenue S. Parking Ramp 6,650,133 10th Avenue and Mainstreet Depot Coffee House 500,684 9451 Excelsior Boulevard Overpass Skate Park 8,009 100 Washington Avenue Studio 305,000 20 Shady Oak Road Dow Towers (76 Units) HRA 22 5th Avenue S. 110 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2014 UNIT # YEAR MAKE MODEL VALUE FIRE DEPARTMENT 2011 FORD CROWN VICTORIA 100 2006 DODGE DURANGO $28,300 101 2003 CHEV IMPALA 24,900 102. 1989 FORD TELE -SQUIRT L9000 240,000 103. 2006 PETERBILT PUMPER 403,300 104 2012 FORD QUICK ATTACK PUMPER F550 248,500 108. 1995 CHEV 4X4 LITE RESCUE 25,000 109 2008 PIERCE AERO XT 845,000 110 2010 CHEVROLET TAHOE 30,000 115. 1952 MACK PUMPER 4,000 POLICE DEPARTMENT 200. 2010 FORD CROWN VICTORIA $30,000 202. 2011 FORD CROWN VICTORIA 31,000 205. 2011 FORD CROWN VICTORIA 31,000 207. 2014 FORD EXPLORER 47,500 208. 2013 FORD EXPLORER 42,600 209. 2011 FORD CROWN VICTORIA 31,000 211. 2006 JEEP LIBERTY 18,800 212. 2008 CHEV TAHOE 36,000 213. 2010 CHEV IMPALA 26,000 214. 2007 DODGE CHARGER 28,000 215. 2009 CHEV IMPALA 25,000 216. 2011 FORD TAURUS 30,000 217. 2008 FORD TAURUS 22,000 218. 2013 FORD INTERCEPTOR SUV 37,200 219. 2013 FORD TAURUS 27,500 229. 2013 FORD INTERCEPTOR 39,700 240. 1998 CHEV P40 VAN 20,000 111 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2014 UNIT # YEAR MAKE MODEL VALUE STREET/TRAFFIC DIVISION 301. 2013 FORD F150 $21,000 302. 2006 FORD F250 26,500 304. 2000 FORD F450 34,000 305. 1997 FORD 1/2 TON 18,300 307. 2006 FORD F350-1 TON DUMP 27,400 308. 2011 FORD F350 - 2X4 20,300 309. 2012 FORD F450 30,300 311. 2011 FREIGHTLINER M2106V 79,400 312. 2005 FREIGHTLINER SGLAX DUMP 98,000 313. 2001 FORD L7501 72,000 314. 1998 FORD LT 8500 86,000 316. 1995 FORD WATER TRK 81,000 320. 1991 CATERPILLER LOADER 926E 90,000 321. 2012 CATERPILLER LOADER 924K 174,900 322. 2005 CATERPILLER LOADER 938G 157,800 324. 2004 BOBCAT SKID LOADER 30,000 325. 2011 BOBCAT SKID STEER LOADER 38,000 326. 1989 CATERPILLAR 140-G 82,000 327. 2001 ELGIN PELICAN SE 105,000 328. 2013 ISUZU STREET SWEEPER 143,200 330. 1989 INGERSOL/RAND ROLLER DD -25 23,000 337. 1994 CATERPILLAR BOX PAVER 18,000 342. 1991 TARGET CONCRETE SAW 2,400 344. 1996 SNOGO WK 800 58,000 349. 1989 TRAIL -KING TK6V-1200 3,000 350. 1993 TOWMASTER T14 4,000 351. 2004 TENNANT SWEEPER 3640 10,000 ENGINEERING DIVISION 700. 2002 CHEV 705. 2005 CHEV TAHOE IMPALA BUILDING MAINTENANCE & EQUIPMENT SERVICES $26,000 14,600 701. 2006 FORD 500 $16,000 702. 2004 FORD F350 23,000 704. 2005 FORD F250 24,000 112 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2014 UNIT # YEAR MAKE MODEL VALUE PARKS/FORESTRY DIVISION 2004 CHEV 800. 2013 FORD F 150 $25,400 801. 2012 FORD F350 4X4 24,100 803. 2004 FORD F350 23,000 804. 1995 CHEV 1 TON BOOM 16,000 805. 1998 DODGE RAM 3500 24,000 810. 1993 INTERNATIONAL LP 4700 50,000 811. 2006 INTERNATIONAL LP 4600 LOG TRUCK 45,000 812. 2010 FREIGHTLINER AERIAL LIFT 130,000 815. 2010 BOBCAT TOOLCAT 50,000 818. 1996 TORO TRUCKSTER 13,000 820. 2004 TORO WORKMAN 3200 15,000 821. 2004 TORO WORKMAN 2110 7,900 822. 2001 TORO 325-D MOWER 18,000 823. 2006 JACOBSON MOWER 10,000 824. 1996 TORO GROUND MASTER 16,000 825. 2010 TORO 4100D MOWER 53,000 826. 2004 TORO Z587L 8,900 828. 2001 DEW EZE ATM72 21,000 832. 1997 VERMEER STUMP CTR 630A 15,400 833. 2004 BOBCAT SKID LOADER 22,000 834. 1993 BRUSH BANDIT CHIPPER 250 14,000 836. RYAN SOD CUTTER 2,000 842. 2011 P.J. TRAILER 5,300 844. 2010 FELLING TRAILER 4,000 845. 1997 REMACKEL TRAILER 5,000 846. 2001 DRESSEN 8110 2,000 847. 2011 SPARKS TILT TRAILER 5,300 411. 2007 CHEV 2500 HD $17,500 WATER/SEWER 500. 2007 CHEV PICKUP $22,000 501. 2004 CHEV 4X4 3/4 T SILVERADO 19,000 502. 1999 DODGE DAKOTA 4X4 18,000 505. 2007 CHEV CC25753 24,000 506. 2006 CHEV SILVERADO 20,700 507. 2001 CHRYSLER PT CRUISER 18,000 530. 2001 STERLING VAC -CON 180,000 533. 2012 CATERPILLAR 420EH2 BACKHOE 86,500 534. 1997 KOHLER GENERATOR/TRL 11,000 535. 1992 KOHLER GENERATOR/TRL 10,000 536. 1989 FLEXIBLE RODDING MACHINE 25,000 537. 2010 GENERATOR C15 130,000 540. 2008 LEROI AIR COMPRESSOR 12,000 542. 1994 WACKER TAMPER 4,000 113 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2014 UNIT # YEAR MAKE MODEL REFUSE 900. 2011 FREIGHTLINER 901. 2005 PETERBILT 903. 1995 FREIGHTLINER PAVILION 802. 2012 FORD 809. 2003 OLYMPIA RAPID -RAIL M2 320 FL -70 F350 ICE RESURFACER 114 VALUE $211,800 162,000 54,000 $24,100 85,000