Loading...
CR 11-064 (2012 - 2016 Equipment Replacement Plan)• June 30, 2011 Proposed Action -4ca City of Hopkins Council Report 2011-064 2012-2016 EQUIPMENT REPLACEMENT PLAN Staff recommends adoption of the following motion: Move to adopt the 2012-2016 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 Enterprise fund equipment in the plan is placed in the individual enterprise fund budgets, in the year in which the equipment is to be purchased. Approval of the 2012-2016 allows staff to incorporate the 2012 ERP items into the 2012 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 • 2012-2016 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: City of Hopkins EQUIPMENT REPLACEMENT PLAN AL S, rj -�----- 2012-2016 I • r • City of q%kins 1010 !first Street South • Hopky: xs, MN 55343-7573 • Phone: 952-935-8474 • fax• 952-935-1834 Web address: uruw.hopkjnsmn.com DATE: June 2011 TO: Honorable Mayor and Members of the City Council FROM: Jim Genellie, Acting/Assistant City Manager SUBJECT: 2012-2016 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2012-2016 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, Connie Kurtz, Police Administrative Services Director, 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 0 Educate 4 Involve • Communicate 4 EQUIPMENT REPLACEMENT PLAN 2012-2016 TABLE OF CONTENTS Paqe City Manager's Message Table of Contents 2 Introduction Background and Summary of Changes from 2011 Plan 4 Cash Flow Statements Equipment Replacement Fund 9 Chart - Revenues, Expenditures & Working Capital 10 Five -Year Project Summaries Projects by Year 12 Department Summary 15 Projects by Department 16 Funding Source Summary 19 Projects by Funding Source 20 Equipment Requests Individual Equipment Request Details 24 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 101 Equipment and Building Inventory Vehicle and Equipment Inventory 107 Building Inventory 111 2 • • • INTRODUCTION 0 0 EQUIPMENT REPLACEMENT PLAN 2012-2016 0 BACKGROUND AND SUMMARY OF CHANGES FROM 2011 PLAN Back round 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 $827,500. 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. After reducing the intragovernmental charges by 50% in 2003 in response to the LGA cuts, charges were increased 2% in 2004 and 9% in 2006 and were not increased again until 2010 when they were raised by 2%. This has resulted in a steady decline in the working capital of the fund. In order to start building cash reserves annual increases are built into the cash projections beginning in 2011 with a 3% increase and continuing forward with increases from 5-7% over the next 5 years. Intergovernmental charges are at 61 % of what they were in 2002 and at the current rate structure will not return to that level until 2021. In the last decade due to changes in technology and the way we operate 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. The long term viability of the fund remains questionable and will result in difficult decisions regarding equipment and operations which will be discussed at length during 2011-2012 leading up to the preparation of the 2013 ERP in the summer of 2012. In the 2012-2016 ERP we have plans for a 5% increase in rates for 2012, 6% for 2013 and 7% for 2014-2016. In addition approximately 5 pieces of equipment will be purchased on a capital lease option allowing us to level the expenditures over 10 years and smooth out the funding needs. Copiers that formerly were purchased are now being leased over a 5 year period and have been removed from the ERP. The lease payments are now included in departmental budgets. 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 4 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 2011 Plan Highlights of changes from last year's equipment replacement plan for the years 2012-2016: Activity Center: Copier due in 2013 for purchase was changed to a lease and will be budgeted in this department within the General Fund. Arts Center: The cost of the carpet extractor scheduled for 2012 has changed from $3,300 to $3,900. Video Camera Updates — added in 2012 at a cost of $3,200 City Hall: Network Core Switch was added in 2012 at a cost of $12,000. This item provides the backbone on which all network communication is built. The current device is obsolete and no longer supported by the manufacturer. Community Services: Engineering copier/scanner lease of $10,000 has been moved to the General Fund, Engineering Dept. Election equipment of $50,000 was added in 2013 as Hennepin County has scheduled replacement of all county wide ballot scanners and ballot boxes, Hopkins has 9. Fire: The Quick Attack Pumper at a cost of $234,000 was moved from 2012 to 2022. Workout dumbbells scheduled for 2012 at a cost of $5,000 were moved to 2014 HRA: There were no changes to HRA items in this CIP. Pavilion: There were no changes to Pavilion items in this CIP. Parking: Added Mobile Date Computer in 2013 at a cost of $5,700 Police: Mobile Data Cameras scheduled for 2012 at a cost of $62,700 moved to 2013. In 2013, added LOGIS Computer System of $200,000 to allow our department to communicate our information with other Police Departments and provide for emergency redundancy between departments. 5 The cost of the Digital Squad Car Cameras scheduled for 2014 were increased by $10,800 to $53,400. The cost of the Police Services Liaison vehicle scheduled for 2015 was increased by $3,000 to $25,000 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 15 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. Parks/Forestry The '/z ton pickup originally scheduled for replacement in 2011 was moved back to 2012 and now moved again to 2013 as its condition warranted extension of its life. The 3/ ton pickup originally scheduled for replacement in 2011 was moved back to 2012 and now moved again to 2013 as its condition warranted extension of its life . The life of this truck was extended from 10 to 14 years. 0 Riding Mower originally scheduled for replacement in 2011 was moved back to 2013 as its condition warranted extension of its life. In addition another riding lawn mower scheduled for 2013 was pushed back to 2014. Trusksteer originally scheduled for replacement in 2011 was moved back to 2013 as its condition warranted extension of its life. A Grass Seed Applicator was added in 2012 at a cost of $7,400. The previous overseeder was sold two years ago due to it's poor condition and was not in the ERP for replacement. Streets/Traffic The tandem dump truck (item 01 -ERP -306) originally scheduled for replacement in 2013 at a cost of $142,400 was deleted and a single axel dump truck was added in 2012 at a cost of $127,400. This changes the trucks to 1 tandem (previously 2) and 3 single axel dump trucks (previously 2). The cost of the one ton traffic boom truck scheduled for 2012 was increased by $7,500 to $82,500. is 9 In 2012 an asphalt hot mix box was added at a cost of $15,500. We currently do not have a hot mix box and this will allow the hot mix that is picked up in the morning to stay pliable throughout the day as the mix is used and minimize hot mix waste. The roller used for asphalt repair was moved from 2012 to 2014. The cost of this equipment totals $45,900. Refuse There were no changes to refuse department items in this CIP. Water There were no changes to water department items in this CIP. Sewer There were no changes to sewer department items in this CIP. • 0 CASH FLOW STATEMENT • C • lampact on General Fund Rate Change Working Capital Begin Year Revenues from charges Transfer In - Pavilion - Capital Lease Transfer In - Pavilion - Hockey Loan Interest earnings Other revenues (sale of assets) Lease Financing Total Revenues Expenditures (excludes Depr.) (1) Fire Truck Financing Pymnts (2009-2018) Finance 6 items - annual finance cost Eliminate 2 copiers in 2013 and lease Capital Outlay - Equipment Working Capital Ending Balance Cash balance EQUIPMENT REPLACEMENT FUND (602) 06/30/2011 (1) Expenditures included copier and engineering scanner lease up until 2011. Beginning in 2011 for the copiers and 2012 for the scanners the responsible fund and department budgets for the lease 0 • 9 14,591 18,830 23,288 24,916 26,662 2% 3% 5% 6% 7% 7% 7% ACTUAL BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 2010 2011 2012 2013 2014 2015 2016 1,161,011 921,830 919,117 1,110,595 505,553 305,089 156,044 292,867 301,653 316,736 335,740 359,242 384,388 411,296 20,000 20,000 20,000 15,609 3,143 3,143 3,143 3,143 3,142 6,719 9,293 9,266 11,180 5,130 3,125 1,635 13,760 25,000 25,000 25,000 30,000 30,000 30,000 600,000 336,489 359,089 974,144 390,672 397,514 417,514 442,931 24,743 25,485 18,250 18,798 19,361 19,942 20,541 53,891 54,217 54,217 54,217 54,217 54,217 54,217 77,000 77,000 77,000 77,000 (35,000) 497,036 282,100 710,200 880,700 447,400 415,400 415,200 575,670 361,802 782,667 995,714 597,978 566,559 566,957 921,830 919,117 1,110,595 505,553 305,089 156,044 32,018 929,273 916,560 1,118,038 512,996 312,532 163,487 39,461 (1) Expenditures included copier and engineering scanner lease up until 2011. Beginning in 2011 for the copiers and 2012 for the scanners the responsible fund and department budgets for the lease 0 • 9 Fa') Q) �_ 7 cn Q C C (0 > Q U W c � � L O o H ❑ ■ ❑ O O O O O O O O O O O O O LO 04 N CD N O N V 0 N M O N N O N C) N 0 0 N rn O O N W O cli O O O N C) O O N LIDO O N V O O N M O O N N O O N O O N O O O N O O O O O 0 • • • FIVE-YEAR PROJECT SUMMARIES w City of Hopkins, MN EQUIPMENT IMPRO FEMENT PLAN 2012 tllrt, 2016 PROJECTS BY YEAR Project Name Department Project # PrioritN' Project Cost 2012 Art Center Carpet Extractor Arts Center 01 -ERP -7707 n/a 3,900 Art Center Video Camera Updates Arts Center 01 -ERP -1103 n/a 3,200 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 07 -ERP -0006 n/a 30,000 Core Network Switch City Hall Administration 01 -ERP -0072 n/a 10,000 City Hall Main Copy Machine - Konica Copier Community Services 01 -ERP -0007 n/a 0 Document Management Scanner (3) Community Services 07 -ERP -0008 n/a 6,500 Aerial Truck Fire 07 -ERP -0706 n/a 54,217 Extrication Tool (2) Fire 07 -ERP -0709 n/a 22,300 Workout Equipment - Treadmill Fire 07 -ERP -0118 n/a 5,000 Marked Patrol Vehicles (6) Police 07 -ERP -0200 n/a 69,200 Police Administrative Vehicles (2) Police 07 -ERP -0204 n/a 28,800 Network Server (3) Police 07 -ERP -0211 n/a 8,500 Radios - Portable and Mobile Devices Police 07 -ERP -0275 n/a 15,000 911 Phone System (Viper Phone) Police 07 -ERP -0276 n/a 0 Engineering Printer/Scanner Public Works: Engineering 01 -ERP -0701 n/a 0 44 3/4Ton Trucks (2) Public Works: Parks/Forestry 01 -ERP -0801 n/a 67,400 Grass Seed Applicator (Overseeder) Public Works: Parks/Forestry 01 -ERP -0877 n/a 7,400 1 Ton Dump Truck (2) Public Works: Streets/Traffic 07 -ERP -0303 n/a 34,700 1 Ton Traffic Boom Truck Public Works: Streets/Traffic 01 -ERP -0304 n/a 82,500 Single Axle Dump Truck (3) Public Works: Streets/Traffic 01 -ERP -0305 n/a 127,400 Front End Loaders (2) Public Works: Streets/Traffic 07 -ERP -0308 n/a 172,000 Asphalt Hot Mix Heating Box Public Works: Streets/Traffic 01 -ERP -0378 n/a 15,500 Total for 2012 771,517 2013 Activity Center Copy Machine Activity Center 01 -ERP -0030 n/a 0 Art Center Kitchen Catering Equipment Arts Center 01 -ERP -7702 n/a 5,000 Network Server City Hall Administration 07 -ERP -0003 n/a 8,000 Computers City Hall Administration 07 -ERP -0006 n/a 30,000 City Hall Main Copy Machine - Konica Copier Community Services 01 -ERP -0007 n/a 0 City Hall Small Copy Machine - Ricoh Copier Community Services 07 -ERP -0002 n/a 0 Document Management Scanner (3) Community Services 07 -ERP -0008 n/a 6,500 Election Equipment Community Services 07 -ERP -0011 n/a 50,000 Aerial Truck Fire 07 -ERP -0706 n/a 54,217 Thermal Imaging Camera (2) Fire 07 -ERP -0772 n/a 11,500 Marked Patrol Vehicles (6) Police 07 -ERP -0200 n/a 71,200 Police Administrative Vehicles (2) Police 07 -ERP -0204 n/a 29,600 LOGIS Computer System Police 07 -ERP -0208 n/a 200,000 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Mobile Data Computers Police 07 -ERP -0272 n/a 62,700 Tactical Ballistic Vests Police 07 -ERP -0274 n/a 23,200 • Radios - Portable and Mobile Devices Police 07 -ERP -0275 n/a 15,000 Engineering Van Public Works: Engineering 01 -ERP -0700 n/a 21,500 Ehursda ' Am, 30. 1011 12 Project Name Department Project # Priority Project Cost Engineering Printer/Scanner Public Works: Engineering 07 -ERP -0707 n/a 0 112 Ton Pickup Truck Public Works: Parks/Forestry 01 -ERP -0800 n/a 26,400 3/4 Ton Utility Truck Public Works: Parks/Forestry 07 -ERP -0802 n/a 32,200 Trucksters (3) Public Works: Parks/Forestry 07 -ERP -0807 n/a 19,800 Riding Mowers (3) Public Works: Parks/Forestry 07 -ERP -0808 n/a 22,800 Brush Chipper Public Works: Parks/Forestry 07 -ERP -0813 n/a 25,700 4X4 3/4 Ton Truck with Plow Public Works: Streets/Traffic 01 -ERP -0301 n/a 30,400 Sweeper Public Works: Streets/Traffic 01 -ERP -0311 n/a 156,400 Backhoe Loader Water 01 -ERP -0502 n/a 134,800 Total for 2013 1,045,417 2014 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 07 -ERP -0006 n/a 30,000 City Hall Main Copy Machine - Konica Copier Community Services 07 -ERP -0001 n/a 0 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Aerial Truck Fire 07 -ERP -0106 n/a 54,217 Automated External Defibrillator (2) Fire 01 -ERP -0720 n/a 7,200 Workout Equipment - Dumb Bells Fire 01 -ERP -0722 n/a 5,000 HRA Copier HRA 07 -ERP -0401 n/a 13,000 Ice Resurfacer Pavilion 07 -ERP -7000 n/a 180,000 Electric Ice Edger Pavilion 07 -ERP -7001 n/a 5,000 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 73,400 Utility 44 (unit 212) Police 07 -ERP -0203 n/a 47,700 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 30,500 Logging Recorder Police 07 -ERP -0210 n/a 36,900 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Digital Squad Car Cameras Police 01 -ERP -0213 n/a 53,400 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 Engineering Printer/Scanner Public Works: Engineering 07 -ERP -0701 n/a 0 Riding Mowers (3) Public Works: Parks/Forestry 07 -ERP -0808 n/a 30,600 Roller Public Works: Streets/Traffic 07 -ERP -0312 n/a 45,900 Asphalt Paver Public Works: Streets/Traffic 01 -ERP -0314 n/a 48,800 Refuse Truck (Rear -L) Refuse 01 -ERP -0901 n/a 101,600 44 3/4 Ton Truck Sewer 07 -ERP -0550 n/a 35,700 Total for 2014 836,917 20� Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Telephone System City Hall Administration 01 -ERP -0004 n/a 89,600 Computers City Hall Administration 07 -ERP -0006 n/a 30,000 City Hall Main Copy Machine - Konica Copier Community Services 01 -ERP -0007 n/a 0 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Duty Chief Vehicle Fire 01 -ERP -0103 n/a 37,000 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Workout Equipment - Eliptical Fire 01 -ERP -0776 n/a 5,800 Workout Equipment - Summit Trainer Fire 01 -ERP -0777 n/a 5,800 Workout Equipment - Weight Lifting Fire 01 -ERP -0179 n/a 5,800 44 3/4 Ton Truck HRA 07 -ERP -0400 n/a 32,400 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 75,600 Sergeant's Vehicle Police 01 -ERP -0207 n/a 37,800 Police Administrative Vehicles (2) Police 07 -ERP -0204 n/a 31,400 Police Services Liaison Vehicle Police 07 -ERP -0206 n/a 25,000 Network Server (3) Police 07 -ERP -0277 n/a 8,500 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 l'hursday. June 30, 2011 13 Project Name Department Project # Priority Project Cost Engineering Printer/Scanner Public Works: Engineering 07 -ERP -0707 n/a 0 4x4 3/4 Ton Pickup with Plow Public Works: Streets/Traffic 07 -ERP -0300 n/a 33,600 Sign Machine (Traffic) Public Works: Streets/Traffic 01 -ERP -0377 n/a 13,400 • Refuse Truck (RAP -R) (2) Refuse 07 -ERP -0900 n/a 204,800 Public Works Copy Machine Water 07 -ERP -0506 n/a 14,200 Total for 2015 734,417 20� Network Server City Hall Administration 07 -ERP -0003 n/a 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 City Hall Main Copy Machine - Konica Copier Community Services 07 -ERP -0001 n/a 0 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Fire Utility Vehicle (Pick Up Truck) Fire 01 -ERP -0705a n/a 35,000 Aerial Truck Fire 01 -ERP -0706 n/a 54,217 Floor Scrubber Fire 07 -ERP -0714 n/a 10,400 Floor Sweeper Fire 07 -ERP -0115 n/a 3,900 Marked Patrol Vehicles (6) Police 07 -ERP -0200 n/a 77,800 Parking Enforcement Vehicle (Parking Fund) Police 07 -ERP -0202 n/a 27,200 Police Administrative Vehicles (2) Police 07 -ERP -0204 n/a 32,400 H.E.A.T. Vehicle Police 07 -ERP -0205 n/a 30,000 Copy Machine- Police Dept Police 01 -ERP -0209 n/a 22,100 Network Server (3) Police 07 -ERP -0271 n/a 8,500 Radios - Portable and Mobile Devices Police 07 -ERP -0275 n/a 15,000 Engineering Printer/Scanner Public Works: Engineering 01 -ERP -0701 n/a 0 Tractor Public Works: Parks/Forestry 01 -ERP -0806 n/a 49,300 Slope Mower Public Works: Parks/Forestry 07 -ERP -0809 n/a 32,700 Skid Loader (2) Public Works: Streets/Traffic 07 -ERP -0309 n/a 41,900 Snow Blower Public Works: Streets/Traffic 07 -ERP -0375 n/a 102,300 3/4 Ton Utility Truck Sewer 07 -ERP -0557 n/a 33,600 Total for 2016 620,817 GRAND TOTAL 4,009,085 1hur iaY. Jim(, 30. 2011 14 City of Hopkins, MN • EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016 • DEPARTMENT SUMMARY Department 2012 2013 2014 2015 2016 Total Activity Center 0 0 Arts Center 7,100 5,000 12,100 City Hall Administration 48,000 38,000 38,000 127,600 38,000 289,600 Community Services 6,500 56,500 6,500 6,500 6,500 82,500 Fire 81,517 65,717 66,417 108,617 103,517 425,785 HRA 13,000 32,400 45,400 Pavilion 185,000 185,000 Police 121,500 410,200 265,400 193,300 213,000 1,203,400 Public Works: Engineering 0 21,500 0 0 0 21,500 Public Works: Parks/Forestry 74,800 126,900 30,600 82,000 314,300 Public Works: Streets/Traffic 432,100 186,800 94,700 47,000 144,200 904,800 Refuse 101,600 204,800 306,400 Sewer 35,700 33,600 69,300 Water 134,800 14,200 149,000 TOTAL 771,517 1,045,417 836,917 734,417 620,817 4,009,085 15 Thursday, June 30, 2011 City of Hopkins, MN EQUIPMENT IMPROFF.AJENT PLAN 2012 11111, 2016 PROJECTS BY DEPARTMENT Department Project# PrioritN 2012 2013 2014 2015 2016 Total Activity Center Activity Center Copy Machine 07 -ERP -0030 n/a 0 0 Activity Center Total 0 0 Arts Center Art Center Carpet Extractor 07 -ERP -1107 n/a 3,900 3,900 Art Center Kitchen Catering Equipment O1 -ERP -7702 n/a 5,000 5,000 Art Center Video Camera Updates 07 -ERP -7103 n/a 3,200 3,200 Arts Center Total 7,100 5,000 12,100 City Hall Administration Network Server 07 -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 07 -ERP -0004 n/a 89,600 89,600 Computers 07 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 750,000 Core Network Switch 01 -ERP -0072 n/a 10,000 10,000 City Hall Administration Total 48,000 38,000 38,000 127,600 38,000 289,600 Community Services City Hall Main Copy Machine - Konica Copier 01 -ERP -0001 n/a 0 0 0 0 0 0 City Hall Small Copy Machine - Ricoh Copier 07 -ERP -0002 n/a 0 0 Document Management Scanner (3) 07 -ERP -0008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 Election Equipment 07 -ERP -0077 n/a 50,000 50,000 Community Services Total 6,500 56,500 6,500 6,500 6,500 82,500 Fire A Duty Chief Vehicle 07 -ERP -0703 n/a 37,000 37,000 Fire Utility Vehicle (Pick Up Truck) 01 -ERP -0705a n/a 35,000 35,000 Aerial Truck 01 -ERP -0706 n/a 54,217 54,217 54,217 54,217 54,217 277,085 Extrication Tool (2) 07 -ERP -0709 n/a 22,300 22,300 Thermal Imaging Camera (2) 07 -ERP -0772 n/a 11,500 77,500 Floor Scrubber 07 -ERP -0774 n/a 10,400 70,400 Floor Sweeper 01 -ERP -0175 n/a 3,900 3,900 Workout Equipment - Eliptical 07 -ERP -0776 n/a 5,800 5,800 Workout Equipment - Summit Trainer 07 -ERP -0777 n/a 5,800 5,800 Workout Equipment - Treadmill 07 -ERP -0178 n/a 5,000 5,000 Workout Equipment - Weight Lifting 07 -ERP -0119 n/a 5,800 5,800 Automated External Defibrillator (2) 07 -ERP -0720 n/a 7,200 7,200• Workout Equipment- Dumb Bells 07 -ERP -0722 n/a 5,000 5,000 Fire Total 81,517 65,717 66,417 108,617 103,517 425,785 16 Thurcdur, June 30, 2011 Department Project# Priority 2012 2013 2014 2015 2016 Total IHRA 32,400 73,000 13,000 32,400 45,400 180,000 5,000 180,000 5,000 44 3/4 Ton Truck 01 -ERP -0400 n/a HRA Copier 01 -ERP -0401 n/a HRA Total 0 0 21,500 (Pavilion 27,200 27,200 Ice Resurfacer 07 -ERP -1000 n/a Electric Ice Edger 01 -ERP -1001 n/a Pavilion Total 29,600 30,500 Police 32,400 152,700 Marked Patrol Vehicles (6) 01 -ERP -0200 n/a Sergeants Vehicle 01 -ERP -0201 n/a Parking Enforcement Vehicle (Parking Fund) 01 -ERP -0202 n/a Utility 44 (unit 212) 07 -ERP -0203 n/a Police Administrative Vehicles (2) 01 -ERP -0204 n/a H.E.A.T. Vehicle 01 -ERP -0205 n/a Police Services Liaison Vehicle 07 -ERP -0206 n/a LOGIS Computer System 01 -ERP -0208 n/a Copy Machine - Police Dept 07 -ERP -0209 n/a Logging Recorder 01 -ERP -0210 n/a Network Server (3) 07 -ERP -0211 n/a Mobile Data Computers 01 -ERP -0212 n/a •Digital Squad Car Cameras 01 -ERP -0213 n/a Tactical Ballistic Vests 07 -ERP -0274 n/a Radios - Portable and Mobile Devices 01 -ERP -0215 n/a 911 Phone System (Viper Phone) 01 -ERP -0216 n/a Police Total 23,200 Public Works: Engineering 23,200 Engineering Van 07 -ERP -0700 n/a Engineering Printer/Scanner 01 -ERP -0701 n/a Public Works: Engineering Total Public Works: Parks/Forestry 0 1/2 Ton Pickup Truck 07 -ERP -0800 n/a 44 3/4Ton Trucks (2) 07 -ERP -0801 n/a 3/4 Ton Utility Truck 07 -ERP -0802 n/a Tractor 01 -ERP -0806 n/a Trucksters (3) 01 -ERP -0807 n/a Riding Mowers (3) 01 -ERP -0808 n/a Slope Mower 01 -ERP -0809 n/a Brush Chipper 07 -ERP -0813 n/a Grass Seed Applicator (Overseeder) 07 -ERP -0817 n/a Public Works: Parks/Forestry Total OPublic Works: Streets/Traffic 44 314 Ton Pickup with Plow 01 -ERP -0300 n/a 4X4 3/4 Ton Truck with Plow 07 -ERP -0307 n/a 32,400 13,000 32,400 73,000 13,000 32,400 45,400 180,000 5,000 180,000 5,000 185,000 185,000 69,200 71,200 73,400 75,600 77,800 367,200 0 0 0 0 37,800 0 37,800 0 0 0 21,500 27,200 27,200 26,400 47,700 47,700 28,800 29,600 30,500 31,400 32,400 152,700 49,300 30,000 30,000 19,800 25,000 25,000 30,600 200,000 53,400 200,000 32,700 32,700 25,700 22,100 22,100 25,700 7,400 36,900 36,900 8,500 8,500 8,500 8,500 8,500 42,500 62,700 62,700 53,400 53,400 23,200 23,200 15,000 15,000 15,000 15,000 15,000 75,000 0 0 121,500 410,200 265,400 193,300 213,000 1,203,400 33,600 30,400 33,600 30,400 17 7hurerlay. June 30. 2011 21,500 21,500 0 0 0 0 0 0 0 21,500 0 0 0 21,500 26,400 26,400 67,400 67,400 32,200 32,200 49,300 49,300 19,800 19,800 22,800 30,600 53,400 32,700 32,700 25,700 25,700 7,400 7,400 74,800 126,900 30,600 82,000 314,300 33,600 30,400 33,600 30,400 17 7hurerlay. June 30. 2011 Department Project# Prioritc 2012 2013 2014 2015 2016 Total 1 Ton Dump Truck (2) 07-ERP-0303 n/a 34,700 34,700 1 Ton Traffic Boom Truck 07-ERP-0304 n/a 82,500 82,500 Single Axle Dump Truck (3) 07-ERP-0305 n/a 127,400 127,400 Front End Loaders (2) 07-ERP-0308 n/a 172,000 772,000 Skid Loader (2) 01-ERP-0309 n/a 41,900 41,900 Sweeper 07-ERP-0311 n/a 156,400 756,400 Roller 01-ERP-0312 n/a 45,900 45,900 Asphalt Paver 07-ERP-0374 n/a 48,800 48,800 Snow Blower 07-ERP-0375 n/a 102,300 702,300 Sign Machine (Traffic) 07-ERP-0377 n/a 13,400 13,400 Asphalt Hot Mix Heating Box 01-ERP-0318 n/a 15,500 15,500 Public Works: Streets/Traffic Total 432,100 186,800 94,700 47,000 144,200 904,800 Refuse Refuse Truck (RAP-R) (2) 01-ERP-0900 n/a 204,800 204,800 Refuse Truck (Rear-L) 07-ERP-0907 n/a 101,600 101,600 Refuse Total 101,600 204,800 306,400 Sewer I 44 3/4 Ton Truck 07-ERP-0550 n/a 35,700 35,700 3/4 Ton Utility Truck 01-ERP-0557 n/a 33,600 33,600 Sewer Total 35,700 33,600 69,300 Water jl • Backhoe Loader 07-ERP 0502 n/a 134,800 734,800 Public Works Copy Machine 07-ERP-0506 n/a 14,200 14,200 Water Total 134,800 14,200 149,000 GRAND TOTAL 771,517 1,045,417 836,917 734,417 620,817 4,009,085 18 1111ir dal. Junr 30, 3U17 • City of Hopkins, MN EQUIPMENT IMPROVEMENT PLAN i 2012 auu 2016 U • FUNDING SOURCE SUMMARY Source 2012 2013 2014 2015 2016 Total AC - Arts Center Fund 7,100 5,000 12,100 Bonds/Lease 54,217 54,217 54,217 54,217 54,217 271,085 Equipment Replacement Fund 710,200 845,700 447,400 415,200 533,000 2,951,500 HRA - Housing and Redevelopment Authority 13,000 32,400 45,400 PA - Pavilion Fund 185,000 185,000 PKG - Parking Fund 5,700 5,700 RF - Refuse Fund 101,600 204,800 306,400 SF - Sanitary Sewer Fund 35,700 6,800 33,600 76,100 WF - Water Fund 134,800 21,000 155,800 GRAND TOTAL 771,517 1,045,417 836,917 734,417 620,817 4,009,065 19 Thursday, June 30, 2011 City of Hopkins, MN EO 1PR0FEMENT PLAN 2012 thru 2016 PROJECTS BY FUNDING SOURCE Source Project# Priorit.N 2012 2013 2014 2015 2016 Total AC - Arts Center Fund 1 Art Center Carpet Extractor 01 -ERP -7707 n/a 3,900 3,900 Art Center Kitchen Catering Equipment 07 -ERP -7702 n/a 5,000 5,000 Art Center Video Camera Updates 01 -ERP -1103 n/a 3,200 3,200 AC - Arts Center Fund Total 7,100 5,000 12,100 Bonds/Lease Aerial Truck 07 -ERP -0706 n/a 54,217 54,217 54,217 54,217 54,217 271,085 Bonds/Lease Total 54,217 54,217 54,217 54,217 54,217 271,085 Equipment Replacement Fund City Hall Main Copy Machine - Konica Copier 07 -ERP -0007 n/a 0 0 0 0 0 0 City Hall Small Copy Machine - Ricoh Copier 07 -ERP -0002 n/a 0 0 Network Server 07 -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,00010 Telephone System 07 -ERP -0004 n/a 76,000 76,000 Computers 01 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 750,000 Document Management Scanner (3) O1 -ERP 0008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 Election Equipment O1 ERP -0017 n/a 50,000 50,000 Core Network Switch 07 -ERP -0012 n/a 10,000 10,000 Activity Center Copy Machine 07 -ERP -0030 n/a 0 0 Duty Chief Vehicle 07 -ERP -0703 n/a 37,000 37,000 Fire Utility Vehicle (Pick Up Truck) 01 -ERP -0705a n/a 35,000 35,000 Extrication Tool (2) 07 -ERP -0709 n/a 22,300 22,300 Thermal Imaging Camera (2) 07 -ERP -0772 n/a 11,500 71,500 Floor Scrubber 07 -ERP -0114 n/a 10,400 70,400 Floor Sweeper 07 -ERP -0775 n/a 3,900 3,900 Workout Equipment - Eliptical 01 -ERP -0776 n/a 5,800 5,800 Workout Equipment - SummitTrainer 07 -ERP -0117 n/a 5,800 5,800 Workout Equipment - Treadmill 07 -ERP -0118 n/a 5,000 5,000 Workout Equipment- Weight Lifting 07 -ERP -0179 n/a 5,800 5,800 Automated External Defibrillator (2) 01 -ERP -0720 n/a 7,200 7,200 Workout Equipment - Dumb Bells 07 -ERP -0722 n/a 5,000 5,000 Marked Patrol Vehicles (6) 07 -ERP -0200 n/a 69,200 71,200 73,400 75,600 77,800 367,200 Sergeants Vehicle 01 -ERP -0207 n/a 37,800 37,800 Parking Enforcement Vehicle (Parking Fund) 01 -ERP -0202 n/a 27,200 27,200 Utility 44 (unit 212) 07 -ERP -0203 n/a 47,700 47,700 Police Administrative Vehicles (2) 07 -ERP -0204 n/a 28,800 29,600 30,500 31,400 32,400 752,700 H.E.A.T. Vehicle 07 -ERP -0205 n/a 30,000 30,000 Police Services Liaison Vehicle 07 -ERP -0206 n/a 25,000 25,000 LOGIS Computer System 07 -ERP -0208 n/a 200,000 200,0000 Copy Machine - Police Dept 07 -ERP -0209 n/a 22,100 22,700 Logging Recorder 01 -ERP -0270 n/a 36,900 36,900 Hirci dm -lun, 311. 2011 20 Source Project# Priority 2012 2013 2014 201.5 2016 Total Network Server (3) 01 -ERP -0211 n/a 8,500 8,500 8,500 8,500 8,500 42,500 Mobile Data Computers 01 -ERP -0212 n/a 57,000 57,000 Digital Squad Car Cameras 01 -ERP -0213 n/a 53,400 53,400 Tactical Ballistic Vests 01 -ERP -0214 n/a 23,200 23,200 Radios - Portable and Mobile Devices 01 -ERP -0215 n/a 15,000 15,000 15,000 15,000 15,000 75,000 911 Phone System (Viper Phone) 01 -ERP -0216 n/a 0 0 44 3/4 Ton Pickup with Plow 01 -ERP -0300 n/a 33,600 33,600 4X4 3/4 Ton Truck with Plow 01 -ERP -0301 n/a 30,400 30,400 1 Ton Dump Truck (2) 01 -ERP -0303 n/a 34,700 34,700 1 Ton Traffic Boom Truck 01 -ERP -0304 n/a 82,500 82,500 Single Axle Dump Truck (3) 01 -ERP -0305 n/a 127,400 127,400 Front End Loaders (2) 01 -ERP -0308 n/a 172,000 172,000 Skid Loader (2) 01 -ERP -0309 n/a 41,900 41,900 Sweeper 01 -ERP -0311 n/a 156,400 156,400 Roller 01 -ERP -0312 n/a 45,900 45,900 Asphalt Paver 01 -ERP -0314 n/a 48,800 48,800 Snow Blower 01 -ERP -0315 n/a 102,300 102,300 Sign Machine (Traffic) 01 -ERP -0317 n/a 13,400 13,400 Asphalt Hot Mix Heating Box 01 -ERP -0318 n/a 15,500 15,500 Engineering Van 01 -ERP -0700 n/a 21,500 21,500 Engineering Printer/Scanner 01 -ERP -0701 n/a 0 0 0 0 0 0 1/2 Ton Pickup Truck 01 -ERP -0800 n/a 26,400 26,400 4x4 3/4Ton Trucks (2) 01 -ERP -0801 n/a 67,400 67,400 3/4 Ton Utility Truck 01 -ERP -0802 n/a 32,200 32,200 Tractor 01 -ERP -0806 n/a 49,300 49,300 Trucksters (3) 01 -ERP -0807 n/a 19,800 19,800 Mowers (3) 01 -ERP -0808 n/a 22,800 30,600 53,400 •Riding Slope Mower 01 -ERP -0809 n/a 32,700 32,700 Brush Chipper 01 -ERP -0813 n/a 25,700 25,700 Grass Seed Applicator (Overseeder) 01 -ERP -0817 n/a 7,400 7,400 Equipment Replacement Fund Total 710,200 845,700 447,400 415,200 533,000 2,951,500 HRA - Housing and Redevelopment A 4x4 314 Ton Truck 01 -ERP -0400 n/a 32,400 32,400 HRA Copier 01 -ERP -0401 n/a 13,000 13,000 HRA - Housing and Redevelopment 13,000 32,400 45,400 Authority Total PA - Pavilion Fund Ice Resurfacer 01 -ERP -1000 n/a 180,000 180,000 Electric Ice Edger 01 -ERP -1001 n/a 5,000 5,000 PA - Pavilion Fund Total 185,000 185,000 PKG - Parking Fund Mobile Data Computers 01 -ERP -0212 n/a 5,700 5,700 PKG - Parking Fund Total 5,700 5,700 _ RF - Refuse Fund Refuse Truck (RAP -R) (2) 01 -ERP -0900 n/a 204,800 204,800 Thursday, June 30, 2011 21 Source Project# PrioritN 2012 2013 2014 2015 2016 Total Refuse Truck (Rear -L) 07 -ERP -0907 n/a 101,600 707,600 RF - Refuse Fund Total 101,600 204,800 306,400 SF - Sanitary Sewer Fund Telephone System 01 -ERP -0004 n/a 6,800 6,800 44 3/4 Ton Truck 01 -ERP -0550 n/a 35,700 35,700 3/4 Ton Utility Truck 01 -ERP -0557 n/a 33,600 33,600 SF - Sanitary Sewer Fund Total 35,700 6,800 33,600 76,100 WF - Water Fund Telephone System 07 -ERP -0004 n/a 6,800 6,800 Backhoe Loader 07 -ERP -0502 n/a 134,800 734,800 Public Works Copy Machine 01 -ERP -0506 n/a 14,200 14,200 WF - Water Fund Total 134,800 21,000 155,800 GRAND TOTAL 771,517 1,045,417 836,917 734,417 620,817 4,009,085 lhur�d«r..hir�� ,ll. 'UIl `PA • 0 • :7 EQUIPMENT REQUESTS 23 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN 1pp,r.ojj ect # 01 -ERP -0001 ect Name City Hall Main Copy Machine - Konica Copier 2012 ,i„„ 2016 Type Equipment Department Comnwnity Ser6ces Useful Life 5 years Contact City Clerk Category Equipment Priorit.N n a Future Description Total Project ( ost• $107,200 Copy machine to service needs of all departments located at City Hall. 1. Variety of copying tasks. 2. High volume product copier. Note: equipment is leased. - 2011 Konica Minolta bizhub C652DS --- lease in being charged to General Fund Inventory - NOT the ERP and allocated to City Hall Departments. Intention is to either renew the lease after 5 years or replace copier with another one on a 5 year lease. Justification Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports. council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. Variance from 20 year plan - copier was to be replaced in 2011 but instead it is leased and expensed to the General Fund. Estimate salvage/resale value on replaced item: $-0- Prior Expenditures 2012 2013 2014 2015 2016 Total Future —107,-20-01 Equipment 0 0 0 0 0 0 Total Total 0 0 0 0 0 0 Total Prior Funding Sources F--10-7-,2-0-01 Equipment Replacement Fund Total Total 2012 2013 2014 2015 2016 0 0 0 0 0 0 0 0 0 0 24 • Total Future 0 0 0 Total 1hnrvdw Juu< 31), '011 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0002 Project Name City Hall Small Copy Machine - Ricoh Copier Type Equipment Useful Life 5 years Category Equipment Future Description 2012 thru 2016 Department Community Services Contact City Clerk Priority n/a Total Project Cost: $43,200 Coyy machine to service needs of all departments located at City Hall. 1, Variety of copying tasks. 2. High volume product copier. Note: This is a Ricoh color copier. 2006 Ricoh 5560G W Justification Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. Budget Impact/Other Variance from 20 year plan - Cost reduced $6,900 due to pricing reductions. Move back to 2013. Estimate salvage/resale value on replaced item: $2,500 Prior Expenditures 2012 2013 2014 2015 2016 Total Future 7-43,-20-01 Equipment 0 0 Total Total 0 0 Total Prior Funding Sources 2012 F--43-,2-0-01 Equipment Replacement Fund Total Total • 2013 2014 2015 2016 Total Future 0 0 0 0 Total Thursday, June 30, 2011 25 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0003 Project Name Network Server Type Equipment Useful Life t year Category Equipment Future Description 2012 au, 2016 Department City Hall Administration Contact Finance Director'IT Priorit.N TI a Total Project Cost: $233,000 The network server is the hub of the network. New computers are faster and more reliable. Justification Networking allows user to share information that is stored in a single location, the network server. This is more ,fficient because the information does not have to be stored on many different computers. It also makes for better tccuracy because as the information changes or is updated, every user is working with the same data. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Prior Expenditures 2012 2013 2014 2015 2016 Total Future 73,000 Equipment 8,000 8,000 8,000 8,000 8,000 40,000 120,000 Total Total 8,000 8,000 8,000 8,000 8,000 40,000 Total Prior 73,000 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 8,000 8,000 8,000 8,000 8,000 40,000 7 120,000 Total 8,000 8,000 8,000 8,000 8,000 40,000 Total 26 1h111 wl<n. J1111r in, 'n EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016 City of Hopkins, MN Project # 01 -ERP -0004 Project Name Telephone System Type Equipment Department City Hall Administration Useful Life 8 years Contact IT Director Category Equipment Priority n/a Future Description I Total Project Cost: $349,900 Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Budget Impact/Other Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015. Estimate salvage/resale value on replaced item: $ Prior Expenditures 2012 2013 2014 2015 2016 Total Future 60,000 Equipment 89,600 89,600 200,300 Total Total 89,600 89,600 Total Prior 60,000 Total Funding Sources Equipment Replacement Fund SF - Sanitary Sewer Fund WF - Water Fund 2012 2013 2014 2015 2016 76,000 6,800 6,800 Total Future 76,000 200,300 6,800 Total 6,800 Total 89,600 89,600 27 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0006 Project Namc Computers 2012 2016 Type Equipment Department City Hall Administration Useful Life 3-5 years Contact Finance Director IT Category Equipment Priori(% n a Future Description I Total Project Cost: $930,000 Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Justification Tools enabling staff to perform job responsibilities efficiently and effectively. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Prior Expenditures 2012 2013 2014 2015 330,000 Equipment 30,000 30,000 30,000 30,000 Total Total 30,000 30,000 30,000 30,000 n LJ 2016 Total Future 30,000 150,000F---4-50—,0700 2015 30,000 150,000 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 330,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 L J llnir,dur..lnnr 30. ?Illl 28 EQUIPMENT IMPROVEMENT PLAN 2012 ,n,,, 2016 City of Hopkins, MN Project # 01 -ERP -0008 Project Name Document Management Scanner (3) Type Equipment Useful Life 3 years Category Equipment Future Description Department Community Services Contact City Clerk Priority n/a Total Project Cost: $156,000 Large document (11" x17') scanner for document management and retention as well as general administrative use. Three scanners each replaced every three years. One replaced in 2009, 2012, 2015....... — note we did not replace one in 2009; unit was repaired to extend the life. One replaced in 2010, 2013, 2016......... One replaced in 2011, 2014, 2017 ............. additional small scanner was added to the scanning station in 2009. This scanner previously was used by the -ctions secretary. This scanner does not handle 11" x 17" paper so can not do all documents. will be evaluated each vear for replacement. If scanners are their life will be extended. Justification We have been getting up to three Tree Trust volunteers to work on scanning and the small scanner only handles iocuments up to 8'/2" x 14". We would like to replace this scanner with a large document scanner to fully utilize our Budget Impact/Other Variance from 20 year plan - item scheduled for 2009 was not replaced. Unit was repaired to extend its life. One additional scanner was added to the replacement shedule in 2010. Estimate salvage/resale value on replaced item: $500-$1,000 Prior Expenditures 2012 2013 2014 2015 2016 Total Future 26,0001 Equipment 6,500 6,500 6,500 6,500 6,500 32,500 97,500 Total Total 6,500 6,500 6,500 6,500 6,500 32,500 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future L 26,000 Equipment Replacement Fund Total Total • 6,500 6,500 6,500 6,500 6,500 32,500 1 97,500 6,500 6,500 6,500 6,500 6,500 32,500 Total 29 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0011 Project Name Election Equipment 2012 ,i„„ 2016 Type Equipment Department Community Services Useful Life 10 years ('ontact City Clerk Category Equipment Priorit.N n a Future Description I I otal Project Cost: $117,200 Zeplace election M-100 ballot scanners and ballot boxes. - 9 machines total. Justification I k11 Hennepin County equipment is being replaced in 2013. Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $-0- C] Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 50,000 50,000 67,200 Total 50,000 50,000 Total Funding Sources 2012 2013 2014 2015 2016 Equipment Replacement Fund 50,000 Total 50,000 30 Total Future 50,000 67,200 50,000 Total 11110 �lur..Iunr 311. '011 EQUIPMENT IMPROVEMENT PLAN 2012,/,,.,/ 2016 City of Hopkins, MN Project # 01 -ERP -0012 Project Name Core Network Switch Type Equipment Department City Hall Administration Useful Life 6 years Contact Finance Director/IT Category Equipment Priority n/a Future Description Total Project Cost: $53,300 Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates fibr optic network connection to fire department. 2 - Cisco 3560E-24PD managed switch - $3,000 each 2 - Cisco X2-IOGB-LR fiber optic transceiver - $1200 each cost listed is forequipment onl and does not include tax, shipping and other related costs Justification two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in Int network outage that was immediately noticed by many employees. Variance from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside the budget for city hall server network budget as the "Lisa" service is scheduled for replacement due to end of life, out of PCI compliance and obsolete. Estimate salvaize/resale value on replace item: - $-0- • Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 10,000 10,000 43,300 Total 10,000 10,000 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 10,000 10,000 43,300 Total 10,000 10.000 1 Total KE Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0030 Project Name Activity Center Copy Machine 2012aw„2016 Type Equipment Department Activity Center Useful Life 7 years Contact Facilities Director Category Equipment Priori(, n a Future Description Total Project Cost: $0 -opy machine used by staff for daily operations of the Hopkins Activity Center. lCurrent equipment: Ricoh 2228C Justification Copy flyers, letters, forms, informational items, etc. • Budget hnpact/Other I 1 Variance from 20 year plan - None Estimate salvage/resale value on replaced item: Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 0 0 0 Total 0 0 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 0 0 Total 0 0 Total • 7hurvlm —how 30, 2011 32 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERR -0103 Project Name Duty Chief Vehicle Type Equipment Useful Life 5 years Category Vehicles Future Description Department Fire Contact Fire Chief Priority n/a Total Project Cost: $254,200 2012 17 u 2016 marked passenger vehicle for use by the Duty Chief and Assistant Chiefs in transporting required equipment, Ference materials and personnel for emergency response, and routine Fire Department business. Curent vehicles: 2010 Chevrolet Tahoe (Chief) 2006 Dodge Durango (Asst. Chief) Chevrolet Impala (Asst. Chief) to be replaced with 2015 SUV Justification Used by the Fire Chief and Asst. Chiefs when responding to fires and other emergencies. Used for official business in and out of the city and for fire fighter travel on official Fire Department business. Eventually 3 SUV's - replaced every 5 years with 15 year life. New - chief, cycle down to Asst. Chief 1 and Asst. Chief 2. Budget Impact/Other Variance from 20 year plan - Add 2 vehicles and change life to 15 years. Estimate salvage/resale value on replaced item: $4,000 Prior 64,500 Total Prior 64,500 Total • Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 37,000 37,000 152,700 Total 37,000 37,000 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 37,000 37,000 152,700 Total 37,000 37,000 Total 33 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN -oject # 01 -ERP -0105a *oject Name Fire Utility Vehicle (Pick Up Truck) Type Equipment Department Fire Useful Life 5 years Contact Firc Chief Category Vehicles Priorit.N n a Future Description I Total Project Cost: $177,100 A pickup truck on a 4 wheel drive chassis. Current vehicle: Lumina - used by Fire Inspector Justification I 2012 ,i„„ 2016 With getting rid of our light rescue, we will be losing a way to haul equipment back and forth from the fire scene to the nation. This vehicle would be used to haul equipment and personnel to and from the scene and can be used for people ;o go to schools. Budget Impact/Other Variance from 20 year plan - Change from 10 year life to 5 years. Estimate of salvage/resale value on replace item - $ Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 35,000 35,000 142,100 Total 35,000 35,000 Total Funding Sources 2012 2013 2014 2015 2016 Equipment Replacement Fund Total 35,000 35,000 0 Total Future 35,000 142,100 35,000 Total 7hurcdur. J��nr ±tl. 3Ul J 34 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0106 Project Name Aerial Truck Type Equipment Useful Life 20 years Category Vehicles Future Description Department Fire Contact Fire Chief Priority n/a Total Project Cost: $2,559,597 2012 rhi-t, 2016 One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on 2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23. Current vehicle: 2008 Pierce Arrow XT Aerial Ladder Justification Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using $445,427.08 in ERP cash and a 10 -year capital lease of $425,000. At the end of the lease term payments (P&I) will total $542,170. Total costs of aerial including cash payments equals $987,597. Budget Impact/Other Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage/resale value on replaced item: $ Prior Expenditures 2012 2013 2014 2015 2016 Total Future F__60_8_,_0_7_8J Equipment 54,217 54,217 54,217 54,217 54,217 271,085 17680,434 Total Total 54,217 54,217 54,217 54,217 54,217 271,085 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 608,078 Bonds/Lease 54,217 54,217 54,217 54,217 54,217 271,085 1,680,434 Total Total 54,217 54,217 54,217 54,217 54,217 271,085 Total • 35 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0109 Project Name Extrication Tool (2) Type Equipment Useful Life 10 years Category Equipment Future Departinew Firc Contact Firc Chief Priorit.N n a 2012 awn 2016 Description I Totarl Project Cost: $136,900 Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. • Justification X111 vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool wil be idded to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. Budget Impact/Other Variance from 20 year plan - move back from 2015 to 2019. Estimate salvage/resale value on replaced item: $1,000 Purchased: 2007 Prior Expenditures 2012 2013 2014 2015 2016 20,300 Equipment 22,300 Total Total 22,300 Prior Funding Sources 20,300 Equipment Replacement Fund Total Total 2012 2013 2014 2015 2016 22,300 22,300 36 Total Future 22,300 94,300 22,300 Total Total Future 22,300 94,300 22,300 Total l hur dw —1 um 30, 2011 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0112 Project Name Thermal Imaging, Camera (2) Type Equipment Useful Life 10 years Category Equipment Future Description Department Fire Contact Fire Chief Priority n/a Total Project Cost: $72,200 2012 thru 2016 sed by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and ;at may be hidden allowing for faster extinguishment. 61I17.'ji►.IIIIy] Justification camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was -d with donation money. Budget Impact/Other Variance from 20 year plan - department owns 2 cameras. Previously one one was included in the replacement plan. This will add to the replacement schedule the camera purchased from the Fire Dept budget in 2003. Estimate salvase/resale value on rei)alced item: $-0- Prior Expenditures 2012 2013 2014 2015 2016 Total Future 15,000 Equipment 11,500 11,50045, 700 Total Total 11,500 11,500 Total Prior 15,000 Total • Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 11,500 11,500 45,700 Total 11,500 11,500 Total 37 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Epp-r-ojj ect # 01 -ERP -0114 ect Name Floor Scrubber Type Equipment Useful Life 12 years Category Equipment Future Department Fite Contact Fire Chid Priority n a 2012 rh t, 2016 Description rotal Project Cost: $25,200 Floor scrubber to keep apparatus floors clean. Justification Scrubber is used to keep apparatus floors clean so that floor will last longer. Budget hnpact/Other Variance from 20 year plan - Estimate salvage/resale value on replaced item: S Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 10,400 10,400 F 14,800 Total 10,400 10,400 Total Funding Sources 2012 2013 2014 201.5 2016 Total Future Equipment Replacement Fund 10,400 10,400 14,800 Total 38 10,400 10,400 Total 71111' dur. Junc° 31i 9 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0115 Project Name Floor Sweeper Type Equipment Useful Life 12 years Category Equipment Future Description Department Fire Contact Fire Chief Priority n/a Total Project Cost: $9,400 2012 ai n„ 2016 Sweeper that is used to clean apparatus floor prior to using scurbber. Justification Sweeper is used to pick up debris before using scrubber. Sweeper uses less time to sweep floor. Budget hnpact/Other Variance from 20 year plan - new item Estimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 3,900 3,900 7,500 Total 3,900 3,900 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 3,900 3,900 5,500 Total 3,900 3,900 Total Thursday, June 30, 2011 39 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0116 Project Name Workout Equipment - Elliptical Type Equipment Useful Life 6 years Category Equipment Future Department Fire Contact Fire Chief Priorit.N n a 2012 2016 Description I Total Project Cost: $20,300 Workout equipment used in Fire Department workout room. One eliptical machine replaced on a 6 year cycle, one ;very 3 years. Justification I Chis equipment is available to all City employees for health and wellness. Budget hnpact/Other Variance from 20 year plan - had two eliptical machines in the ERP. One was replaced along with the stairmaster with a summit trainer. The remaining eliptical is scheduled for replacement in 2015. Estimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 5,800 5,8007--1-4,-5700 14,500 Total 5,800 5,800 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 5,800 5,800 14,500 Total 5,800 5,800 Total 1hursdur. Jum 30. 2011 40 0 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0117 Project Name workout Equipment - Summit Trainer Type Equipment Useful Life 5 years Category Equipment Future Description Department Fire Contact Fire Chief Priority n/a Total Project Cost: $34,300 Workout equipment used in Fire Department workout room. One summit trainer replaced on a 5 year cycle. Current equipment : 2010 Summit Trainer 2012 thru 2016 Justification This equipment is available to all City employees for health and wellness. Variance from 20 year plan - replaces stairmaster. Estimate salvage/resale value on replaced item: $ Prior Expenditures 2012 2013 2014 2015 2016 Total Future F-75—,00-01 Equipment 5,800 5,800 23,500 Total Total 5,800 5,800 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 5,000 Equipment Replacement Fund 5,800 5,800 23,500 Total Total 5,800 5,800 Total L 41 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project# 01 -ERP -0118 Project Name Workout Equipment - Treadmill Type Equipment Useful Life 5 years Category Equipment Future Department Fire Contact Fire Chief Priority n a Description I Total Project Cost: $25.300 Workout equipment used in the Fire Department workout room. Dne treadmill replaced on a 5 year cycle. 2012 ,tt, tt 2016 I Justification This equipment is available to all City employees for health and wellness. Budget Impact/Other I Variance from 20 year plan - move back one year from 2011 to 2012. Estimate salvage/resale value on replaced item: S Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 5,000 5,000 20,300 Total 5,000 5,000 Total • Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 5,000 5,000 20,300 Total 5,000 5,000 Total lhmsrlur. Junr 311. 'U/ / 42 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN • Project # 01 -ERP -0119 Project Name Workout Equipment - Weight Lifting Type Equipment Useful Life 5 years Category Equipment Future Department Fire Contact Fire Chief Priority n/a Description ( Total Project Cost: $29,300 Smith machine - weight lifting machine. 2012 airu 2016 Justification ,or use by Police, Fire, Public Works, City staff to keep in shape to perform job duties and stay healthy. Current nachine will be 7 years old in 2012. Suggested replacement is every 5 years. ariance from 20 year plan - move back from 2011 to 2015 stimate salvage/resale value on replaced items: $ Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 5,800 5,800 23,500 Total 5,800 5,800 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 5,800 5,800 23,500 Total 5,800 5,800 Total 43 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0120 Project Name Automated External Defibrillator (2) Type Equipment Useful Life 3 years Category Equipment Future Department Fire Contact Fire Chief Priorio n a 2012 an, 2016 Description I Total Project ( ost: $49,100 )efibrillator is used to help get someones heart restarted during a cardiac arrest. )wn 2 - both are replaced at one time due to changing technology. Current equipment: 2010 - 4 AEDs 2010 ERP had 2 AEDs schedule for replacement at $6,000. Four were purchased. Justification With changes in technology, the AED's should be replaced every four years. -ost - $3,000 per unit Budget bnpact/Other Variance from 20 year plan - adjustment from 3 years to 4 years. Estimate salvage/resale value on replaced item: $ • Prior Expenditures 2012 2013 2014 2015 2016 Total Future .F---6,-00-0-1 Equipment 7,200 7,200 35,900 Total Total 7,200 7,200 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 6,000 Equipment Replacement Fund 7,200 7,200 35,900 Total Total 7,200 7,200 Total Tluu:cdur..lun� 40, 11111 44 0 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0122 Project Name workout Equipment - Dumb Bells Type Equipment Useful Life 10 years Category Equipment Future Description Department Fire Contact Fire Chief Priority n/a Total Project Cost: $11,700 Workout equipment used in Fire Department workout room. 9 Justification 2012 thru 2016 1t dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead plaint. This purchase would update our dumb bells to the current type fitness bells. Budget hnpact/Other Variance from 20 year plan - Move back from 2012 to 2014. 3stimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 5,000 5,000 6,700 Total 5,000 5,000 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 5,000 5,000 6,700 Total 5,000 5,000 Total 45 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN 2012 City of Hopkins, MN Project # 01 -ERP -0200 Project Name Marked Patrol Vehicles (6) Type .Equipment Useful Life 3 years Category Vehicles Future Description Departmew Police ('ontact Policc Chief Priorio n a Total Project ( ost: $2,495,500 2016 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. nt vehicles: (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria, (2) 2008 Ford Crown Victorias, (1) Ford Crown Victoria Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget hnpact/Other Variance from 20 year plan - Original replacement schedule was modified several years ago during the LGA cuts. The )roposed purchase schedule is to realign the replacement of squads more evenly. Estimate salvage/resale value on replaced item: $4,000 each Prior Expenditures 2012 2013 2014 201.5 2016 Total Future 637,700 Vehicles 69,200 71.200 73,400 75,600 77,800 367,200 1,490,600 Total Total 69,200 71,200 73,400 75,600 77,800 367,200Total 75,600 Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 637,700 Equipment Replacement Fund 69,200 71,200 73,400 75,600 77,800 367,200 1,490,600 Total Total 69,200 71,200 73,400 75,600 77,800 367,200 Total lhuculur. Jum ;U_ ?IJ// 46 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0201 Project Name Sergeant's Vehicle Type Equipment Useful Life 4 years Category Vehicles Future Description Department Police Contact Police Chief Priority n/a Total Project Cost: $276,400 2012 thru 2016 Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. 4 year rotation. vehicle: 2011 Ford Crown Victoria Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure lata and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. ariance from 20 year plan - none. stimate salvage/resale value on replaced item: $3,500 each Prior Expenditures 2012 2013 2014 2015 2016 Total Future —33—,60-01 Vehicles 37,800 37,800205,000 37,800 Total Total 37,800 37,800 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 33,600 Equipment Replacement Fund 37,800 37,800205,000 Total Total 37,800 37,800 Total :7 47 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0202 Project Name parking Enforcement Vehicle (Parking Fund) Type Equipment Useful Life 10 years Category Vehicles Future Description ?arkinlz enforcement vehicle. Current vehicle: 2006 Jeen Li Deparuuent Police Contact Policechicl Priorih n a Total Project Cost: $82,500 2012,i„„2016 Justification Jse by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown area. Variance from 20 year plan - amount allocated is not sufficient. Increase to $27,200. Estimate salvage/resale value on replaced item: $1,500 r: Prior Expenditures 2012 2013 2014 2015 2016 Total Future 18,700 Vehicles 27,200 27,200 36,600 Total Total 27,200 27,200 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 18,700 Equipment Replacement Fund 27,200 27,200 F 36,600 Total Total 27,200 27,200 Total I hm +drn'. Jane 30. 301 I 48 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0203 Project Name Utility 4x4 (unit 212) Type Equipment Useful Life 6 years Category Vehicles Future Description 4 wheel drive uitility vehicle. Department Police Contact Police Chief Priority n/a Total Project Cost: $247,600 vehicle: 2008 Chevrolet Tahoe 2012 /in, 2016 Justification Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals, prisoners and ;quipment. The 4 wheel drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme ;now conditions. Budget Impact/Other Variance from 20 year plan - none. Estimate salvage/resale value on replaced item: $5,000 Prior Expenditures 2012 2013 2014 2015 2016 Total Future 67,400 Vehicles 47,700 47,700 132,500 Total Total 47.700 47,700 Total Prior 67,400 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 47,700 47,700 132,500 Total 47.700 47,700 Total 49 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0204 Project Name Police Administrative Vehicles (2) Type Equipment Useful Life 2 years Category Vehicles Future Department Police Contact Police Chief Priorit.N n a Description I 'rotal Project Cost: $1,013,300 ?olice administrative and detective vehicles. Chiefs vehicle - even numbered years Captain's vehicle - odd numbered years vehicles: 2009 Chevrolet Impala. 2008 Ford Taurus 2012 //,-, 2016 Justification Jnmarked vehicles, equipped with radios, siren and red grille liter used by chief and captain. Staff use is for two years. Vehicles are then rotated down to detectives and are kept for an additional 3-4 years. Vehicles are also used for surveillance by uniform and plain clothes officers. • Budget Impact/Other I q Variance from 20 year plan - none Estimate salvage/resale value on replaced item: 54,000 each Prior Expenditures 240,300 Vehicles Total 2012 2013 2014 2015 2016 Total Future 28,800 29,600 30,500 31,400 32,400 152,700620,300 Total 28,800 29,600 30,500 31,400 32,400 152,700 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future F-724-0,330-0-1 Equipment Replacement Fund 28,800 29,600 30,500 31,400 32,400 152,700 620,300 Total Total 28,800 29,600 30,500 31,400 32,400 152,700 Total lhurc�lur. June 30. 3011 50 • • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0205 Project Name H.E.A.T. Vehicle Type Equipment Useful Life 15 years Category Vehicles Future Department Police Contact Police Chief Priority n/a 2012 2016 Description I Total Project Cost: $76,700 Unmarked van to transport police tactics team for high risk calls, training and mutual aid. vehicle: 1998 Chevrolet Cube Van Justification 'revious vehicle (15 years old) was a safety hazard and was replaced in 2005. Budget Impact/Other Variance from 20 year plan - extended life from 10 to 15 years Estimate salvage/resale value on replaced item: $3,000 Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 30,000 30,000 46,700 Total 30,000 30,000 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 30,000 30,000 46,700 Total 30,000 30,000 Total 51 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0206 Project Name Police Services Liaison Vehicle Type Equipment Useful Life 15 years Category Vehicles Future Department Police Contact Police Chief Prioritc n a 2012 2016 Description I Total Project Cost: $63,900 Used by Police Services Liaison/JCPP Liaison for transport to schools, neighborhood meetings, training and public .-elation events. vehicle: 2001 Chrysler PT Cruiser Justification 1001 PT Cruiser was leased to the Police Department for a nominal fee and detailing and wheels were also donated. Che City purchased the vehicle from the leasor in 2005. Budget Impact/Other Variance from 20 year plan - extended life from 10 to 15 years. Amount allocated is not sufficient. Increase to $25,000. ?stimate salvage/resale value on replaced item: $1,000 Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 25,000 25,000 38,900 Total 25,000 25,000 Total • Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 25,000 25,000 38,900 Total 25,000 25,000 Total lhursdur. June° 30. 201 52 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN • Project # 01 -ERP -0208 Project Name LOGIS Computer System Type Equipment Useful Life 20 years Category Equipment Future Description Department Police Contact Police Chief Priority n/a Total Project Cost: $200,000 2012 rhru 2016 Computer system for records management and retention of Police Department in addition to computer aided dispatch (CAD) and mobile data computer in squads. Looking at the LOGIS RMS/CAD/Mobile system. Computer system and maintenance - Year 1 - $200,000 est to include software, licenses, implementation and training, data conversion, and network Year 2 - $95,800 - this is maintenance and should be budgeted in Dept budget about a 10% increase each subsequent year 'ear 2 through ?? Includes software/hardware support in addition to builing reserves for future Justification Fo store, retrieve and transfer required data to State and perform data entry, inquiries of local, state and national crime LOGIS system will allow a greater sharing of data and records with 30+ communities for invesatigative purposes. Budget Impact/Other Variance from 20 year plan - Project was moved up from 2017 to allow greater ability to share information with other agencies in the system and allows us the capability to potentially explore merging with another dispatch center. Estimate salvage/resale value on replaced item: $-0- Expenditures 2012 2013 2014 2015 2016 Total Equipment 200,000 200,000 Total 200,000 200,000 Funding Sources 2012 2013 2014 2015 2016 Total Equipment Replacement Fund 200,000 200,000 Total 200,000 200,000 53 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Epplrjj ect # 01 -ERP -0209 ect Name Copy Machine - Police Dept Type Equipment Useful Life 5 years Category Equipment Future Department Police Contact Police Chief Priority n a 2012 ,i„„ 2016 Description I Total Project Cost: $161,600 ?olice Department copy machine capable of producing double side copies and collating pages, color/BW, fax tcapability and scan.. lCurrent equipment: 2006 Ricoh 2051 SP Justification Used to make duplicate copies of reports, letters, memos, etc., generated by police personnel, fax and scan.. Budget Impact/Other I q Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Prior Expenditures 2012 2013 2014 2015 2016 Total Future 49,800 Equipment 22,100 22,100 89,700 Total Total 22,100 22,100 Total Prior Funding Sources 2012 2013 2014 2015 49,800 Equipment Replacement Fund Total Total 54 2016 22,100 22,100 Total Future 22,100 89,700 22,100 Total Anrvdur. ,hin, 30 ?loll C: EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0210 Project Name Logging Recorder Type Equipment Useful Life 7 years Category Equipment Future Description Department Police Contact Police Chief Priority n/a Total Project Cost: $138,100 2012 /hru 2016 The police logging recorder is a device which records all telephone and radio transmissions produced/received by the Police Department. Current eauivment: 2005 Mercom lo22in2 recorder Justification Records all incoming/outgoing phone calls from the dispatch center and all radio transmissions from police, fire and interop radio talkgroups. Equipment is necessary in case questions arise as to how calls for service or events were handled or dispatched. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- • Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 36,900 36,900 101,200 Total 36,900 36,900 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 36,900 36,900 101,200 Total 36,900 36,900 Total 55 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project 4 01 -ERP -0211 Project Name Network Server (3) Type Equipment Useful Life 3 years Category Equipment Future Description Department Police Contact Police Chict' IT Priorit,N n a Total Project ( ost: $246,500 2012 r6ru 2016 Computer servers store information and system programs. One server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval -see 01 -ERP -213) Justification knnual replacement cycle allows development of system storage program. Use of newer servers for heavy use )rograms while older servers used for data storage. Budget Impact/Other Variance from 20 year plan - Cost stabilized at $8,500 per year. Estimate salvage/resale value on replaced item - $ Is Prior Expenditures 2012 2013 2014 2015 2016 Total Future 76,500 Equipment 8,500 8,500 8,500 8,500 8,500 42,500 127,500 Total Total 8,500 8,500 8,500 8,500 8,500 42,500 Total Prior 76,500 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 8,500 8,500 8,500 8,500 8,500 42,500 1 127,500 Total 8,500 8,500 8,500 8,500 8,500 42,500 Total 56 lhundur. Jui�30. ?l,l l EQUIPMENT IMPROVEMENT PLAN 2012 rhru 2016 City of Hopkins, MN Project # 01 -ERP -0212 Project Name Mobile Data Computers Type Equipment Useful Life 5 years Category Equipment Future Description Department Police Contact Police Chief Priority n/a Total Project Cost: $297,800 Mobile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various databases, communicate car to car. Justification Limited life of 5 years - replacement necessary. Budget Impact/Other Variance from 20 year plan - ERP - 10 mobile data computers ( includes 1 spare) includes docking stations. Replacement of MDC's can be moved to 2013 due to experiencing minimal performance issues. Parking Fund (1) MDC - $5.700 value on replaced item: Prior Expenditures 2012 2013 2014 2015 2016 Total Future —47,-0-00-1 Equipment 62,700 62,700 188,100 Total Total 62,700 62.700 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 47,000 Equipment Replacement Fund 57,000 57,000 F 188,100 Tata] PKG - Parking Fund 5,700 5,700 Total Total C. 62,700 57 62,700 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0213 Project Name Digital Squad Car Cameras Type Equipment Department Police Useful Life 5 years Contact Police Chief Category Equipment Priority n a Future 2012 rhrtt 2016 Description I I otal Project Cost: $256,200 Digital video camera system in each marked patrol car - used to document events in and out of the patrol car. Images downloaded to server for storage and retrieval. Justification Police Dept. currently has ten digital camera units installed and a dedicated server. The life expectancy of the cameras is about five years. Current cameras were installed in September 2009. Cost: 10 cameras @ $5,000 per unit plus tax - $53,430 1 server @ $15,000 (to be purchased from Police Network Server (01 -ERP -211) annual allocation that carries forward. Estimated cost $53,430. Cost could be lower if, at the time of replacement, a suitable product is available through a State or Countv eauivment bid. Budget Impact/Other Variance from 20 year plan - Increase quantity to ten to cover all marked/unmarked patrol vehicles. Cost of cameras remains at $5,000 each plus tax - $53,430. Estimate salvage/resale value on replaced item: $ Prior Expenditures F-42—,60-01 Equipment Total 2012 2013 2014 2015 2016 53,400 Total 53,400 Total Future 53,400 160,200 53,400 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future .F--4-2-,6-0-01 Equipment Replacement Fund 53,400 53,400 160,200 Total Total 53,400 53,400 Total Tlrt�c�dnr..lune 30. 2011 58 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0214 Project Name Tactical Ballistic Vests Type Equipment Useful Life 5 years Category Equipment Future Description Department Police Contact Police Chief Priority n/a Total Project Cost: $137,500 2012 /hr„ 2016 Tactical ballistic vests worn by members of the Hopkins Police Department High-risk Entry and Assault Team (HEAT). These vests offer a higher level of protection against weapon assault than the regular duty ballistic vest. Justification Federal and State grant monies have been available through the Ballistic Vest Program over the past several years. These grants only pay a portion of the total cost of the vest, leaving the Police Department to pay the balance. There is no guarantee that these grants will be available in the future. Warranty on the current vests expires in 2013. Cost: 11 vests Variance from 20 year plan - Team membership has increased to 11. Estimate salvage/resale value on replaced item: $ Prior Expenditures 2012 2013 2014 2015 2016 Total Future 20,000 Equipment 23,200 23,200 94,300 Total Total 23,200 23,200 Total Prior 20,000 Total Funding Sources Equipment Replacement Fund Total 2012 2013 2014 2015 2016 23,200 23,200 -] Total Future 23,200 94,300 23,200 Total Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0215 Project Name Radios - Portable and Mobile Devices Type Equipment Useful Life Category Equipment Future Department Police Contact Police Chief Priorit.N n a 2012 2016 Description I rota] Project cost: $300,000 ?ortable and mobile radios used by the police, fire and public works departments to allow these departments to ;ommunicate on one frequency. Police and fire use their radios on a daily/regular basis. The public works only uses heirs in the event of an emergency. ?stimated Replacement Cost (based on 2009 cost) Portable - $2,300 Mobile - $3,000 Police Fire PW Total Portable 65 36 10 111 Mobile 17 9 0 26 Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. Budget Impact/Other Variance from 20 year plan - added replacement cost at S 15.000 per year fixed, starting in 2012. Do not expect all 132 radios to need replacing at one time. Estimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 15,000 15,000 15,000 15,000 15,000 75,000 225,000 Total 15,000 15,000 15,000 15,000 15,000 75,000 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 15,000 15,000 15,000 15,000 15,000 75,000 225,000 Total 15,000 15,000 15,000 15,000 15,000 75,000 Total /huredur-111n, 30, 0// 60 • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0216 Project Name 911 Phone System (Viper Phone) Type Equipment Useful Life Category Equipment Future Description Department Police Contact Police Chief Priority n/a Total Project Cost: $0 2012 thru 2016 tron Lifeline 100 IAP+ is an analog enhanced 911 phone system installed in 1986 and upgraded twice. There are 911 landlines, three 911 wireless and one 911 rollover line. This phone system receives and transfers 911 calls displays landline location information or longitude/latitude information from cell phones. This system allows 911 to be transferred to other agencies as needed. Current plans call for leasing of new Viper phone equipment. 60 month lease at $2,015 per month. No payoff or buyout at the end - we will own outright. Lease includes hardware, software, Evergreen software support for term of lease and hardware maintenance for 1 year. Subsequent years hardware maintenance will be provided by Qwest and funded by Police budget. PD budget - current lease expense of $1,071.43 from expiring system plus funds from E-911 state funds to the difference - aDDroximately $944. Justification The analog 911 phone system has never been in the ERP. The equipment was leased until November 2010 when leasing options expired and the equipment was purchased for $1.00. The current service provider will not guarantee part availability or maintenance service beyond our current maintenance agreement which ends in April 2012. They will review contracts on a case by case basis. The equipment is discontinued and parts are no longer manufactured and limited in availability. The 911 next generation phone technology is digital and internet based. The state of MN 911 service provider has already established this new technology and in 1-2 years all systems would need to be upgraded to Budget Impact/Other Variance from 20 year plan - Cost of the upgrade is estimated between $94,000 - $150,000 depending which option is chosen. Plus monthly recurring maintenance charges and/or user fees if services are shared with another department. $14,058 is already in the current budget for monthly lease/maintenance. Estimated salvage/resale value on replaced item: -0- Expenditures Equipment • Total 2012 2013 2014 2015 2016 Total 61 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Funding Sources 2012 Equipment Replacement Fund Total 2012 mn, 2016 2013 2014 2015 2016 Total 62 Thur'day../unr 30 • • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0300 Project Name 4x4 3/4 Ton Pickup with Plow Type Equipment Useful Life 10 years Category Vehicles Future 2012 2016 Department Public Works: Streets/Traffic Contact Public Works Director Priority n/a Description I Total Project Cost: $103,800 ?ickup used by various divisions of Public Works. Current vehicle: 1997 Chevrolet 3/4 Ton 4X4 Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. Budget Impact/Other Variance from 20 year plan - Increase expenditure to reflect actual cost. Change from 1/2 ton pickup to 3/4 ton 4x4 value on replaced item: $1 Prior Expenditures F--2-5—,00-0-1 Vehicles Total 2012 2013 2014 2015 2016 Total Future 33,600 33,600 1 45,200 Total 33,600 33,600 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 25,000 Equipment Replacement Fund 33,600 33,600 45,200 Total Total 33,600 33,600 Total • 63 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0301 Project name 4X4 3/4 Ton Truck with Plow 2012 rJrrrr 2016 Type Equipment Dep:a-invent Public Works: Streets Traffic Useful Life 8 years Contact Public Works Director Category Vehicles Priorit,N n a Future Description I Total Project Cost: $141,700 3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers. vehicle: 2006 Ford F250 Justification �ight hauling, pulling trailers, transportation to and from job sites. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,500 is Prior Expenditures 2012 2013 2014 2015 2016 Total Future 24,000 Vehicles 30,400 30,400 87,300: Total Total 30,400 30,400 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 24,000 1 Equipment Replacement Fund 30,400 30,400 87,300 Total Total 30,400 30,400 Total 11111r0al,June30_Z0ll 64 • EQUIPMENT IMPROVEMENT PLAN 2012 th i, 2016 City of Hopkins, MN Project # 01 -ERP -0303 Project Name 1 Ton Dump Truck (2) Type Equipment Department Public Works: Streets/Traffic Useful Life 12 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $205,500 Truck is used in the Street Division of Public Works. Current vehicles: 2000 Ford F450 & 2011 Ford F350 Justification Vehicle used by various departments for street and park maintenance and light hauling. Budget hnpact/Other Variance from 20 year plan - move back from 2009 to 2010. Estimate salvage/resale value on replaced item: $3,500 Prior Expenditures 67,900 Vehicles Total 2012 2013 2014 2015 2016 34,700 Total 34,700 Total Future 34,700 102,900 34,700 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 67,900 Equipment Replacement Fund 34,700 34,700 102,900 Total Total 34,700 34,700 Total • 65 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN EPPIrlij ect # 01 -ERP -0304 ect Name 1 Ton Traffic Boom Truck 2012 aw, 2016 Type Equipment Department Public Works: Succts Traffic Useful Life 17 years Contact Public Works Director Category Vehicles Priority n a Future Description I Total Project Cost: $218.900 3oom truck used in Street and Traffic Divisions of Public Works. lCurrent vehicle: 1995 Chevrolet 1 Ton Boom Truck Justification Vehicle used by Traffic Department for signal and light pole maintenance. W -w ' N �A'�a AMU Budget Impact/Other 1 11 Variance from 20 year plan - Increase amount to reflect actual. Estimate salvage/resale value on replaced item: $8,000 Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 82,500 82,500 136,400 Total 82,500 82,500 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 82,500 82,500 136,400 Total 82,500 82,500 Total 0 1hnt "bil. Jinn 30. ?ul l 66 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0305 Project Name Single Axle Dump Truck (3) Type Equipment Useful Life 17 years Category Vehicles Future 2012 thru 2016 Department Public Works: Streets/Traffic Contact Public Works Director Priority n/a Description I Total Project Cost: $674,100 Single axle dump truck used by various division of Public Works. Current vehicles: 2001 Ford L7501 & 2004 Freightliner M2 106 Justification Vehicle used for heavy hauling, snow plowing and sanding. additional single axle truck in place of tandem truck from 01 -ERP -306. Budget Impact/Other Variance from 20 year plan - Move 1 truck from tandem (was in 101 -ERP -306) to single axle for 2012. Estimate salvage/resale value on replaced item: $4,500 each We would then have 3 single axel (chaene from 2) dump truck and 1 tandem axel dump truck. Prior Expenditures 80700 Vehicles Total 2012 2013 2014 2015 2016 127,400 Total 127,400 Total Future 127,400 466,700 127,400 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 80,000 1 Equipment Replacement Fund 127,400 127,400 466,700 Total Total 127,400 127,400 Total • 67 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0308 Project Name Front End Loaders (2) Type Equipment Useful Life 15-18 years Category Equipment Future Description Justification 2012 ,i„„ 2016 Department Public Works: Streets Traffic Contact Public Works Director Priorit,N n a Total Project ( ost: $848,600 1991 Caterpillar 928E Loader & 2005 Caterpillar 938G Budget Impact/Other Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $ 9 Prior Expenditures 2012 2013 2014 2015 2016 Total Future —140-,-0001 Equipment 172,000 172,000 536,600 Total Total Total 172,000 172,000 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 140,000 Equipment Replacement Fund 172,000 172,000 536,600 Total Total 172,000 172,000 Total 7hnrc�hn..lum in, ?Ill l 68 EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016 City of Hopkins, MN Project # 01 -ERP -0309 Project Name Skid Loader (2) Type Equipment Department Public Works: Streets/Traffic. Useful Life 12 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $187,600 Loading trucks, landscape work, snow removal, material handling. Current eauinment: 1998 John Deere 8875 Skid Loader & 2004 Bobcat S-1851 R Skid Loader Justification Budget hnpact/Other Variance from 20 year plan - move back from 2010 to 2011. Estimate salvage/resale value on replaced item: $ Prior Expenditures 36,000 Equipment Total 2012 2013 2014 2015 2016 Total Future 41,900 41,900 1 109,700 Total 41,900 41,900 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 36,000 Equipment Replacement Fund 41,900 41,900109,700 Total Total 41,900 41,900 Total • 69 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN E,P,r.ojj ect # 01 -ERP -0311 ect Name Sweeper 2012 air„ 2016 Type Equipment Dcp:u-imcnl Public Works: Streets Traffic Useful Life 12 years Contact Public Works Director Category Equipment Priorit, n a Future Description I 'total Project Cost: $494,700 Street sweeper used by Streets Division for sweeping streets and parking lots. 2001 Erin Pelican SE Justification Street sweeping, event clean-up, spring sand removal. Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $12,000 Prior Expenditures 1 —17,305-01 Equipment Total Total 2012 2013 2014 2015 2016 156,400 156,400 n U Total Future 156,400 223,000 156,400 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 115,300 Equipment Replacement Fund 156,400 156,400 223,000 Total Total 156,400 156,400 Total • lhnrvdur.Jnn< 30,3011 70 EQUIPMENT IMPROVEMENT PLAN 2012 rhru 2016 City of Hopkins, MN Project # 01 -ERP -0312 Project Name Roller Type Equipment Department Public Works: Streets/Traffic Useful Life 20 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $45,900 Used by Street Department for asphalt repair and resurfacing. Current equipment: 1989 Ingersoll Rand Roller Justification Budget Impact/Other Variance from 20 year plan - Move back from 2012 to 2014. Estimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Equipment 45,900 45,900 Total 45,900 45,900 Funding Sources 2012 2013 2014 2015 2016 Total Equipment Replacement Fund 45,900 45,900 Total FJ 71 45,900 45,900 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0314 Project Name Asphalt Paver 2012 ,1„t, 2016 Type Equipment Department Public Works: Streets Traffic Useful Life 20 years Contact Public Works Director Category Equipment Priorit.N n a Future Description I Total Project ('ost: $48,800 ksphalt paver used by Streets Division of Public Works. Current equipment: 1994 Caterpillar AD200B Paver Justification Paving streets and parking lots. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $500 Expenditures 2012 2013 2014 2015 2016 Total Equipment 48,800 48,800 Total 48,800 48,800 Funding Sources 2012 2013 2014 2015 2016 Total Equipment Replacement Fund 48,800 48,800 Total 48,800 48,800 1karsdur..how 30. 2011 72 • EQUIPMENT IMPROVEMENT PLAN 2012 M ., 2016 City of Hopkins, MN Project # 01 -ERP -0315 Project Name Snow Blower Type Equipment Department Public Works: Streets/Traffic Useful Life 20 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $102,300 Snow blower used by the Streets Division of Public Works. (Current equipment: 1998 SnoGo WK800 Justification Blowing and loading snow off Mainstreet into trucks. • Budget hupact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $4,500 Expenditures 2012 2013 2014 2015 2016 Total Equipment 102,300 102,300 Total 102,300 102,300 Funding Sources 2012 2013 2014 2015 2016 Total Equipment Replacement Fund 102,300 102,300 Total 102,300 102,300 Thursday, June 30, 2011 73 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0317 Project Name Sign Machine (Traffic) Type Equipment Useful Life 10 years Category Equipment Future Description 2012 ,i„„ 2016 Department Public Works: StreetsTraffic Contact Public Works Director Priori[) n a Total Project Cost: $31,500 used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city 2005 Sicncad Shun Makine S Justification Existing machine is not repairable and needs updating/ Budget Impact/Other Variance from 20 year plan - new E-stimate salvage/resale value on replaced item: S -0 - Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 13,400 13,400 18,100 Total 13,400 13,400 Total L� Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 13,400 13,400 18,100 Total 13,400 13,400 Total l7urcadm, ,how 30. I011 74 • EQUIPMENT IMPROVEMENT PLAN 2012,/7,.,,2016 City of Hopkins, MN Project # 01 -ERP -0318 Project Name Asphalt Hot Mix Heating Box 0 Type Equipment Department Public Works: Streets/Traffic Useful Life 12 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $37,600 slide in truck mounted unit with built in heat source to heat up or keep heated asphalt mix when used in patching or eet repair. Justification Currently hot mix asphalt is picked up at the mixing plant in the morning and used throughout the day for patching operations, and as the mix cools it becomes unusable. The proposed "Hot Box" will keep the mix hot and pliable until used up which minimizes waste. This hot box will also allow the crew to use hot mix during colder months of the year. In addition, it will be used to heat up and make pliable patching material specifically formulated for winter use when hot mix plants are not operating. Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $-0-. Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 15,500 15,500 22,100 Total 15,500 15,500 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 15,500 15,500 22,100 Total 15,500 15,500 Total 75 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN EPP,r-oij ect # 01 -ERP -0400 ect Name 4x4 3/4 Ton Truck Type Equipment Useful Life 8 years Category Vehicles Future Department HRA Contact Unassigned Prioritc n a 2012 ,i„„ 2016 Description I Total Project Cost: $148,400 t wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snow plow. lCurrent vehicle: 2007 Chevrolet Pickup Justification Transportation for Public Housing Superintendent and snow plowing at various HRA properties around the city. Budget Impact/Other • Variance from 20 year plan - none ' Estimate salvage/resale value on replaced item: $1,800 Prior Expenditures 2012 2013 2014 2015 2016 Total Future 22,800 Vehicles 32,400 32,400 93,200 Total Total 32,400 32,400 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 22,800 HRA - Housing and Redevelop 32,400 32,400 93,200 Total Total 32,400 32,400 Total • 7hurvelav, June 30. 2077 76 EQUIPMENT IMPROVEMENT PLAN 2012 ihru 2016 City of Hopkins, MN Project# 01 -ERP -0401 Project Name 11RA Copier Type Equipment Department HRA Useful Life 8 years Contact Finance Director Category Equipment Priority n/a Future Description I Total Project Cost: $50,400 Color copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks. Current equipment: Imnistics ZB35 Justification Daily use to make copies of correspondence, forms and rental documents. Periodically produce documents such as resident newsletters and marketing. Machine will duplex, sort, collate and staple copies. Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replace item: $ - 0 - Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 13,000 13,0 0F-75,405-01 Total 13,000 13,000 Total Funding Sources 2012 2013 2014 2015 2016 Total Future HRA - Housing and Redevelop 13,000 13,000 37,400 Total 13,000 13,000 Total Aursday, June 30, 2011 77 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN EPPIr-01ject ect # 01 -ERP -0502 Name Backhoe Loader 2012 air, 2016 Type Equipment Dcparuneut Water Useful Life 20 years Contact Public Works Director Category Equipment Priority n a Future Description I Total Project Cost: $134,800 Jnit utilitzed by Water, Sewer and Street Divisions of Public Works for repair and installation of underground utilities. lCurrent equipment: 1993 Caterpillar Backhoe 446 Justification Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Equipment 134,800 134,800 Total 134,800 134,800 Funding Sources 2012 2013 2014 2015 2016 Total WF - Water Fund 134,800 134,800 Total 134,800 134,800 771111 "hn . hol, 311. M l 78 • EQUIPMENT IMPROVEMENT PLAN 2012,/,/-,,,2016 City of Hopkins, MN Project # 01 -ERP -0506 Project Name Public Works Copy Machine Type Equipment Department Water Useful Life 5 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $94,700 Copy machine to service needs of all division of Public Works. uipment: 2005 Ricoh Aficio 2238C Justification \laking copies for various departments. Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $800 Prior Expenditures 22,800 Equipment Total Prior Funding Sources 22,800 WF - Water Fund Total • 2012 2013 2014 2015 2016 Total Future 14,200 14,200 57,700 Total 14,200 14,200 Total 2012 2013 2014 2015 2016 Total Future 14,200 14,200 57,700 Total 14,200 14,200 Total 79 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0550 Project Name 4x4 3/4 Ton Truck 2012 r!u a 2016 Type Equipment DepartineW scorer Useful Life 10 years Contact Public Works Director Category Vehicles Prioritc n a Future Description I Total Project Cost: $110,300 Cruck used by Water/Sewer Division of Public Works. Current vehicle: 2004 Chevrolet Pic Justification Snow plowing, light hauling, pulling trailers, general purpose transportation. (Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ • Prior Expenditures 2012 2013 2014 2015 2016 Total Future 7600 Vehicles 35,700 35,7007-74-8,700-1, Total Total 35,700 35,700 Total Prior Funding Sources 26,600 SF - Sanitary Sewer Fund Total Total 2012 2013 2014 2015 2016 35,700 35,700 Total Future 35,700 88,000 , 35,700 Total lhui "drn'. ,luny 30. 10! 1 U EQUIPMENT IMPROVEMENT PLAN 2012 ,i„ t, 2016 City of Hopkins, MN Project # 01 -ERP -0551 Project Name 3/4 Ton Utility Truck Type Equipment Department Sewer Useful Life 10 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $129,800 3/4 ton utility truck used by the Water/Sewer Division of Public Works. Currrent vehicle: 2007 Chevrolet Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. Budget hnpact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Prior Expenditures 51,000 Vehicles Total 2012 2013 2014 2015 2016 Total Future 33,600 33,600 45,200 Total 33,600 33,600 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 51,000 SF - Sanitary Sewer Fund 33,600 33,600 45,200 Total Total 33,600 33,600 Total • 81 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0700 Project Name Engineering Van 2012 ,i 2016 Type Equipment DcparUnent Public Works: Engineering Useful Life 10 years Contac) Public Works Director Category Vehicles Prioritc n Future Description I 'total Project Cosa $66,400 Van used by Engineering Department for survey equipment and on job site work. vehicle: 2000 Chevrolet Suburban Justification Transportation to and from job site, hauling of surveying and traffic counting equipment. Budget Impactl0ther Variance from 20 year plan - increase amount from 14,300 to 16,000 to reflect actual cost. Purchase used Suburban 'rom Hennepin Co. 2002 auction -price is $13,000 to $14,000 + $2,000 for equipment. 3stimate salvage/resale value on replaced item: $2,500 • Prior Expenditures 2012 2013 2014 2015 2016 Total Future 15000 Vehicles 21,500 21,500 28,900 Total Total 21,500 21,500 Total Prior Funding Sources 16,000 Equipment Replacement Fund Total Total 2012 2013 2014 2015 2016 21,500 21,500 82 Total Future 21,500 F28,900 21,500 Total 11ml,dai. Ju„, M. 2011 EQUIPMENT IMPROVEMENT PLAN 2012 rhru 2016 City of Hopkins, MN Project # 01 -ERP -0701 Project Name Engineering Printer/Scanner Type Equipment Department Public Works: Engineering Useful Life 5 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $54,560 ?rinter/scanner - large format copier use in Engineering to copy blueprints, plans and large documents. is leased. in 2012 the lease has been moved to the GF Justification Large document copier/scanner for use in Engineering. Also scans documents for permanent storage. Budget Impact/Other Variance from 20 year plan - Decrease from 10,000 to 8,000 per lease charges. Estimate salvage/resale value on replaced item: $-0- Prior Expenditures 2012 2013 2014 2015 2016 Total Future 54,560 Equipment 0 0 0 0 0 0 0 Total Total 0 0 0 0 0 0 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 54,560 Equipment Replacement Fund 0 0 0 0 0 0 Total Total 0 0 0 0 0 0 Total • 83 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN [PpIr-0j, ect # 01 -ERP -0800 ect Name 1/2 Ton Pickup Truck 2012 2016 Type Equipment Department Public Works: Parks'Foresu), Useful Life 10 years Contact Public Works Director Category Vehicles Priorit,N n a Future Description I Total Project Cost: $61,800 ?ickup used by Park Division of Public Works. Current vehicle: 2001 Ford Justification ariance from 20 year plan - move back from 2012 to 2013 stimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 26,400 26,400 35,400 Total 26,400 26,400 Total Funding Sources 2012 2013 2014 2015 Equipment Replacement Fund Total 26,400 26,400 2016 Total Future 26,400 35,400 26,400 Total lhrvrv�lur..hun iU, ZUl l 84 • 0 EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016 City of Hopkins, MN Project # 01 -ERP -0801 Project Name 4x4 3/4Ton Trucks (2) Type Equipment Department Public Works: Parks/Forestry Useful Life 8 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $313,800 Crucks used by Parks Division of Public Works. vehicles: 2004 Ford F350 4X4 & 2004 Ford F350 4X4 Justification Snow plowing, hauling, transportation. Units are heavily used. Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Prior 53,200 Total Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 67,400 67,400 193,200 Total 67,400 67,400 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 53,200 Equipment Replacement Fund 67,400 67,400 193,200 Total Total 67,400 67,400 Total t 85 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0802 Project Name 3/4 Ton Utility Truck 2012 ,hrvt 2016 Type Equipment Department Public Works: Parks Foresny Useful Life 14 years Contact Public Works Director Category Vehicles Priorit.N u a Future Description I Total Project ( ost: $80,900 3/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city. lCurrent vehicle: 1998 Dodge Ram 3500 Justification Budget Impact/Other Variance from 20 year plan - move back from 2012 to 2013. Estimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 32,200 32,200 48,700 Total 32,200 32,200 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund Total 32,200 32,200 48,700 32,200 32,200 Total 86 1hursdur.,huu 30. 2011 11 • EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016 City of Hopkins, MN Project # 01 -ERP -0806 Project Name Tractor Type Equipment Department Public Works: Parks/Forestry Useful Life 30 years Contact Public Works Director Category Equipment Priority n/a Future • Description I Total Project Cost: $49,300 arm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration, plowing ind grass seeding. 1984 Ford Tractor 2910 (#81 Justification ariance from 20 year plan - Delete one tractor (2012) to be placed by ToolCat (2010). Move second tractor to 2016. Aimate salvage/resale value on replaced item: $3,500 Expenditures 2012 2013 2014 2015 2016 Total Equipment 49,300 49,300 Total 49,300 49,300 Funding Sources 2012 2013 2014 2015 2016 Total Equipment Replacement Fund 49,300 49,300 Total 49,300 49,300 87 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0807 Project Name Trueksters (3) 2012 ,n, „ 2016 Type Equipment Department Public Works: Parks Forestry Useful Life 15 years contact Public Works Director Category Equipment Priority n Future Description I I mal Project cost: $114,700 Cruckster used by Parks Division of Public Works for ballfield and parks maintenance. Current equipment: 1996 Toro Workman, 2004 Toro Workman 3200, 2004 Toro Workman 2110 Justification ?ark maintenance, ballfield grooming and weed spraying. 0 Budget Impact/Other I\ Variance from 20 year plan - Mov c from 2012 to 2013. Estimate salvage/resale value on replaced item: $1,400 each Prior Expenditures 2012 2013 2014 2015 2016 Total Future 7,900 Equipment 19,800 19,800F---65-,-0700 F 65,000 Total Total 19,800 19,800 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 29,900 Equipment Replacement Fund 19,800 19,800 F 65,000 Total Total 19,800 19,800 Total llrnr�sdal../Ifm 30. '0// 88 0 EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016 City of Hopkins, MN Project # 01 -ERP -0808 Project Name Riding Mowers (3) Type Equipment Department Public Works: Parks/Forestry Useful Life 8 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $255,700 Riding mowers used by Parks Divison of Public Works. Current eauinment: 1996 Toro Groundmaster 345, 2004 Toro Zero Justification Mowing city parks and right of ways. Budget Impact/Other Variance from 20 year plan - move from 2012to 2014. Changes in use. Estimate salvage/resale value on replaced item: $600 each Prior Expenditures -49—,00-01 Equipment Total 2006 Jacobson Rotary Mower 2012 2013 2014 2015 2016 Total Future 22,800 30,600 53,400 1 153,300 Total 22,800 30,600 53,400 Total Prior Funding Sources 2012 2013 2014 2015 2016 Total Future 49,000 1 Equipment Replacement Fund 22,800 30,600 53,400 153,300 Total Total 22,800 30,600 53,400 Total • 89 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0809 Project Name Slope Mower Type Equipment Useful Life 15 years Category Equipment Future Description 2012 rl„ rr 2016 Department Public Works: Parks Forestry ( ontact Public Works Director Priority n a I otal Project ( ost: $83,600 lurrent equipment: 2001 DEW EZE ATM72 Slope Mower Justification Budget Impact/Other • Variance from 20 year plan - none Estimate salvage/resale value on replaced item: 51,000 Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 32,700 32,700 50,900., Total 32,700 32,700 Total Funding Sources 2012 2013 2014 2015 2016 Total Future Equipment Replacement Fund 32,700 32,700 50,900 Total i 32,700 32,700 Total • EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0813 Project Name Brush Chipper Type Equipment Useful Life 20 years Category Equipment Future 2012 thru 2016 Department Public Works: Parks/Forestry Contact Public Works Director Priority n/a Description I Total Project Cost: $25,700 Brush chipper used for Forestry and brush pick up operations of Public Works. lCurrent equipment: 1993 Brush Bandit Chipper 250 Justification • ludget Impact/Other ariance from 20 year plan - change to usable life to 20 years - move back from 2009 to 2013. stimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Equipment 25,700 25,700 Total 25,700 25,700 Funding Sources 2012 2013 2014 2015 2016 Total Equipment Replacement Fund 25,700 25,700 Total 25,700 25,700 RE Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN EPPIrl-oil ect # 01 -ERP -0817 ect Name Grass Seed Applicator (Overseeder) 2012 2016 Type Equipment Department Public Works: Parks'Foresty Useful Life 20 years (bnlacl Public Works Director Category Equipment Priorit,N n Future Description I ,1 otal Project Cost: $7,400 kttachment for overseeding existing turf areas. Justification werseeder was not part of ERP - old overseeder was sold two years ago due to poor condition. Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replace item: S -0 - Expenditures 2012 2013 2014 2015 2016 Total Equipment 7,400 7,400 Total 7,400 7,400 Funding Sources 2012 2013 2014 2015 2016 Total Equipment Replacement Fund 7,400 7,400 Total 7,400 7,400 17unsrlur. June 3U. 2011 92 • 0 EQUIPMENT IMPROVEMENT PLAN 2012,/,,.,,2016 City of Hopkins, MN Project 4 01 -ERP -0900 Project Name Refuse Truck (RAP -R) (2) € Type Equipment Department Refuse Useful Life 10 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $1,462,600 Refuse truck used by Refuse Utility Division of Public Works. vehicle: 2005 Peterbilt Justification Residential waste pick up. Rail & 2011 Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Prior Expenditures 349,100 Vehicles Total Prior Funding Sources 349,100 RF - Refuse Fund Total • M 2012 2013 2014 2015 2016 Total Future 204,800 204,800 1 908,700 Total 204,800 204,800 Total 2012 2013 2014 2015 2016 Total Future 204,800 204,800 1 908,700 Total 204,800 204,800 Total 93 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN [PIr-0j, ect # 01 -ERP -0901 ect Name Refuse Truck (Rear -L) 2012 ,i„„ 2016 �.J Type Equipment Department Refuse Useful Life 10 years Contact Public Works Director Category Vehicles Priority n a Future Description total Project Cost: $238,200 Zefuse truck used by Refuse Utility Division of Public Works. �urrent vehicle: 1996 Fre Justification Zesidential waste pick up. liner FL70 Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $9,000 Expenditures 2012 2013 2014 2015 2016 Total Future Vehicles 101,600 101,600 136,600 Total 101,600 101,600 Total Funding Sources 2012 2013 2014 2015 2016 Total Future RF - Refuse Fund 101,600 101,600 136,600 Total 101,600 101,600 Total • 77n�r��lnr..lunr 311. ?Ul I 94 EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016 City of Hopkins, MN Project # 01 -ERP -1000 Project Name Ice Resurfacer Type Equipment Department Pavilion Useful Life 12 years Contact Facilities Director Category Equipment Priority Wa Future Description Total Project Cost: $496,600 Ice resurfacer used by the Pavilion for ice sheet maintenance. 2003 Olvmpia Ice Resurfacer Justification teplace existing propane fueled ice resurfacer with a electric driven ice resurfacer. Due to changes in the states statues .or indoor air quality for ice arenas replacement with a propane fueled model would warrant the purchase and nstallation of state approved air quality monitoring equipment. Additional costs that would accompany the monitoring ,quipment would be annual testing and recalibration fees. State statues also require annual licensing and lower emission ;tandards to be meet that if exceeded could possibly lead to possible facility closures and loss of revenue. With ;onsideration of the above factors the Pavilion would be exempt from the new statues if a electric ice resurfacer was zsed in Dlace of propane ice resurfacer. Variance from 20 year plan - Value increased to reflect actual replacement cost. Estimate salvage/resale value on replaced item: $20,000 Prior 60,000 Total Prior 60,000 Total • Expenditures Equipment Funding Sources 2012 2013 2014 2015 2016 180,000 Total 180,000 Total Future 180,000 256,600 180,000 Total 2012 2013 2014 2015 2016 Total Future PA - Pavilion Fund 180,000 180,000 256,600 Total 180,000 180,000 Total 95 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Project # 01 -ERP -1001 Project Name Electric Ice Edger 2012 ,i„„ 2016 Type Equipment Department Pavilion Useful Life 10 years Contact Facilities Director Category Equipment Prioritc ma Future Description I Total Project Cost: $11,700 • Electric ice edger used for ice maintenance of the Pavilion's ice sheet. An edger is used to shave the ice next to the boards to remove ice buildup that the ice resurface cannot reach. Justification For the Pavilion to be exempt from the changing state statutes for air quality in ice arenas, the gas fueled edger must be replaced with an electric model. Budget Impact/Other Vairance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $ Expenditures 2012 2013 2014 2015 2016 Total Future Equipment Total 5,000 5,000 Funding Sources 2012 2013 2014 2015 2016 PA - Pavilion Fund 5,000 Total 5,000 5,000 6,700 5,000 Total Total Future 5,000 6,700 5,000 Total Ihurcdui. Junr 30. ?Ol l 96 • is EQUIPMENT IMPROVEMENT PLAN 2012 thru 2016 City of Hopkins, MN Project# 01 -ERP -1101 Project Name Art Center Carpet Extractor Type Equipment Department Arts Center Useful Life 10 years Contact Arts Center Director Category Equipment Priority n/a Future Description I Total Project Cost: $9,100 The carpet extractor is used at the Arts Center and occassionally in other city facilities. The equipment is used to clean carpets on a regular basis between annual contractual cleanings, to remove spots and stains, and to pick up spills. Includini? carpet wand and long hose for ease of use, as well as low moisture capabilities. Justification 'he current equipment is over 12 years old and very corroded from the dirt, water and cleaning chemicals. With regular )uch up cleaning and removal of stains in the Arts Center carpet with this extractor, the need to pay contractual leaners to deep clean the carpet is reduced to once or twice annually. Budget Impact/Other Variance from 20 year plan - Increase cost from $3,300 to $3,900. Estimate salvage/resale value on replace item: $ Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 3,900 3,900 5,200 Total 3,900 3,900 Total Funding Sources 2012 2013 2014 2015 2016 Total Future AC - Arts Center Fund 3,900 3,900 5,200 Total 3,900 3,900 Total 97 Thursday, June 30, 2011 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN Ej ect#01-ERP-1102 ect Name Art Center Kitchen Catering Equipment 2012 2016 Type Equipment Dcparunent Arts Center Useful Life 12 years Contact Arts Center Director Category Equipment Priorit.N n it Future Description I Total Project Cost: $12,100 Jnder counter freezer and refrigerator in catering kitchen. Justification These units are used for storing food for HCA events and for rental clients. Budget Impact/Other Variance from 20 year plan - New item. Current pricing $2049 refrigerator, $2207 freezer plus delivery. Estimate salvage/resale value on replaced item: $-0- 0 Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 5,000 5,000 7,100 Total Funding Sources 2012 2013 2014 2015 2016 AC - Arts Center Fund Total 5,000 5,000 98 5,000 Total Total Future 5,000 7,100 5,000 Total 1 hursdav 1unc 30. 3011 • Pi EQUIPMENT IMPROVEMENT PLAN 2012 m 2016 City of Hopkins, MN Project# 01 -ERP -1103 Project Name Art Center Video Camera Updates Type Equipment Useful Life 5 years Category Equipment Future Description Department Arts Center Contact Arts Center Director Priority n/a Total Project Cost: $16,200 Replace the front entry camera with a better resolution camera. Relocate existing to above the display cabinet in the lobby. Add additional camera to the gallery, left of door to capture shot of faces of those exiting. Add a camera to the back hallwav of the second floor. Justification There was an item taken from a display case in 2011 and existing cameras did not provide clear angle and view of the culprit. Also, addition of a camera in the back hallway may reduce tendency of youth to hang out in that area and engage in inappropriate behavior. Variance from 20 year plan - New item. I Estimate salvage/resale value on replaced item: $-0- Expenditures 2012 2013 2014 2015 2016 Total Future Equipment 3,200 3,200 13,000 51 Total 3,200 3,200 Total Funding Sources 2012 2013 2014 2015 2016 Total Future AC - Arts Center Fund 3,200 3,200 13,000 Total 3,200 3,200 Total 99 Thursday, June 30, 2011 TWENTY-YEAR REPLACEMENT SCHEDULE 0 • 8 g g n 8 8 8 8 N S S o o o $ S N x o � '^ 8 p h S O O O O vOi O O S O YC W `D � e S $ S 8 8 N a 8 8 8 o S 8 $ 8 S oc 8 m 06oN r 8 0 8 8 o S S S m g$8 8 S 88 8 8 8 8 N g o 8 8 o S 8 8 N N - o o $ S g S O S O O O O N N N N N .N. w U - o w rz d N w S 0 0 0o S r r $ S ry e� Q S 14 � N � K N op p O O O 8 8 8$ O S N N N NNN M ZR • F,,., F } $ V �m ."p. r7 �n '—�.' m L� X F F 3 P >'aa�m� Q � C V j.y O N y yg5 z u Uh F 00 Vi Vi J y 1 L 1 E$° 3 3 3 3 0 3 w ua uu�e> zauzu vyaw^w t-'wSv aaa ewua�wwv "a i94 w w w w w www w w w w w w www w w w w w w w w w w w w w w w • � o6 e x o 8 8 8 S S o o ID S Y - .15 - 0 0 _ o N N P P O� O 00 T C 8 8 8 e � 0 0 oc o" o Q Q v o N N N cD oc 8 8 8 N N Q 0 8 8 8 8 O v. _ - o a a P N O 1� O O N of 00 00 O l r o �0 3 c c. r o. 8 $ 8 a = 0 8 u 'J. �- N Q _ _ 9= E z N r N N N N N N N N N 0qG ppC� Cq Ppb, {01C, ip�� fpX� R��j qR'a d d N G 1 4 G C Y C L L d G 6 C • • • 0 8 � S O O h O O S O 8 � r S O r O O O N N O O N 8 gN� � N r O S y �O O O ADD O S 8 o S 8 8 8 N N tin M � G G CC O N N N N S S S 8 a 8 8 F S $ C O 8 N M O m 8 T S O TT N R O O N O S 8 V C S O O V N O Ci V C O P S S S pp O S M m n .. n v W h N o } w F w F2" F2" A A aE KA 6AF N V V 0' u U J 0 0 0 0 0 O 00 F .0 f� Q — v v en .ol Q F F F F H F F ti 0. v e e—— .� vim, ti h F 3 V. k`. y y h oC ti a h F h M aujwwwwujww wj Ii w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w w V O O O O v. b vi c O c 8 h N N N � C C v01 v� v4Oi r0 z x z z z z z C o00 rOv z x x z z a z x n • 0 • • • p7 b N Q 00 O m h wMi V t� �p p W 00 8r P O O 8 8 b O O P N Q N Q N Q o og ss a 88 8 8 8 S 8 S S 8 S M� p p Q N vNi pM W p Q O S S S O O O 8 8 8 r P N r V ti O N 88 88 8 S 8 8 88 X88 88 &S 8 � 88 O0 1� 8 8 000 �r m voi g g g g cT 8 a 8 8 W Q � O ri Vi O 00 o� o s 88 m O P. vQi v r Q O� e 00 m b N P 0p `O Q ma Qp �p N �O 00 O N 8 m v pm b Q8 VQ1 O Q S O S 000 N �O ff P N N yy G O� o 10 8 Op p 8 p 8 0 0 Q O OOO` z e�, � o a vice ww"oo < owwu�ayW CY C7 C7 T� Q '3 rwi, 04 �Fi1 L Ci .T. C! 7+ N 6' U U 8s� 8&888 �8 e O jP O �88 � 8N N a0 N e I • EQUIPMENT AND BUILDING INVENTORY • �J Im POLICE DEPARTMENT 200. 2010 CITY OF HOPKINS CROWN VICTORIA $30,000 • 201. VEHICLE/EQUIPMENT INVENTORY FORD CROWN VICTORIA 28,100 202. 06/15/2011 FORD CROWN VICTORIA 31,000 203. 2009 CURRENT CROWN VICTORIA 28,160 205. 2011 REPLACEMENT UNIT # YEAR MAKE MODEL COST FIRE DEPARTMENT 29,000 207. 2010 100 2006 DODGE DURANGO $28,300 101 2003 CHEV IMPALA 24,900 102. 1989 FORD L9000 TELE -SQUIRT 240,000 103. 2006 PETERBILT PUMPER 403,300 104. 1991 PETERBILT HEAVY RESCUE 190,000 106. 2004 FORD CROWN VICTORIA 28,100 107. 1993 PETERBILT PUMPER 225,000 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 • 201. 2008 FORD CROWN VICTORIA 28,100 202. 2011 FORD CROWN VICTORIA 31,000 203. 2009 FORD CROWN VICTORIA 28,160 205. 2011 FORD CROWN VICTORIA 31,000 206. 2007 FORD CROWN VICTORIA 29,000 207. 2010 FORD CROWN VICTORIA 30,000 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. 2006 FORD 500 21,800 240. 1998 CHEV P40 VAN 20,000 241. 2001 CHRYSLER PT CRUISER 18,000 • 107 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2011 CURRENT REPLACEMENT UNIT # YEAR MAKE MODEL COST STREET/TRAFFIC DIVISION 301. 1997 CHEV 302. 2006 FORD 304. 2000 FORD 305. 1997 FORD 307. 2006 FORD 308. 2011 FORD 309. 1995 CHEV 310. 1989 INTERNATIONAL 312. 2005 FREIGHTLINER 313. 2001 FORD 314. 1998 FORD 315. 1996 FORD 316. 1995 FORD 320. 1991 CATERPILLER 322. 2005 CATERPILLER 324. 2004 BOBCAT 325. 1998 JOHN DEERE 326. 1989 CATERPILLAR 327. 2001 ELGIN 330. 1989 INGERSOL/RAND 337. 1994 CATERPILLAR 342. 1991 TARGET 344. 1996 SNOGO 349. 1989 TRAIL -KING 350. 1993 TOWMASTER 351. 2004 TENNANT PUBLIC WORKS - ADMINISTRATION 401. 2008 FORD ENGINEERING DIVISION 3/4 TON F250 F-450 1/2 TON F350-1 TON DUMP F350 - 2X4 1 TON TRK SGLAX DUMP SGLAX DUMP L7501 LT 8500 L-8000 WATER TRK LOADER 926E LOADER 938G SKID LOADER SKID LOADER 140-G PELICAN SE ROLLER DD -25 BOX PAVER CONCRETE SAW WK 800 TK6V-1200 T14 SWEEPER 3640 CROWN VICTORIA $21,000 26,500 34,000 18,300 27,400 20,300 28,000 70,000 98,000 72,000 86,000 85,000 81,000 90,000 157,800 30,000 24,000 82,000 105,000 23,000 18,000 2,400 58,000 3,000 4,000 10,000 $28,100 700. 2000 CHEV SUBURBAN $14,500 705. 2005 CHEV IMPALA 14,600 WIN • 0 • • CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2011 UNIT # YEAR MAKE MODEL CURRENT REPLACEMENT COST BUILDING MAINTENANCE & EQUIPMENT SERVICES 701 1997 CHEV C1500 $16,000 702 1992 CHEV 3/4 TON 4X4 16,000 703. 2002 CHEV TAHOE 5,000 704. 2005 FORD F250 24,000 PARKS/FORESTRY DIVISION 800. 803. 804. 805. 810. 811. 812. 815. 817. 818. 820. 821. 822. 823. 824. 825. 826. 828. 832. 833. 834. 836. 844. 845. 846. HRA 411. Is 2001 2004 2004 1998 1993 2006 2010 2010 1982 1996 2004 2004 2001 2006 1996 2010 2004 2001 1997 2004 1993 2010 1997 2001 FORD FORD FORD DODGE INTERNATIONAL INTERNATIONAL FREIGHTLINER BOBCAT FORD TORO TORO TORO TORO JACOBSON TORO TORO TORO DEW EZE VERMEER BOBCAT BRUSH BANDIT RYAN FELLING REMACKEL DRESSEN 2007 CHEV RANGER4X4 F350 F350 RAM 3500 LP 4700 LP 4600 LOG TRUCK AERIAL LIFT TOOLCAT TRACTOR 2610 TRUCKSTER WORKMAN 3200 WORKMAN 2110 325-D MOWER MOWER GROUND MASTER 4100D MOWER Z587L ATM72 STUMP CTR 630A SKID LOADER CHIPPER 250 SOD CUTTER TRAILER TRAILER 8110 2500 HD 109 $18,000 23,000 23,000 24,000 50,000 45,000 130,000 50,000 22,000 13,000 15,000 7,900 18,000 10,000 16,000 53,000 8,900 21,000 15,400 22,000 14,000 2,000 4,000 5,000 2,000 $17,500 • 110 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2011 CURRENT REPLACEMENT UNIT # YEAR MAKE MODEL COST 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 530. 2001 STERLING VAC -CON 180,000 533. 1993 CATERPILLAR LDR-BKHOE-446 50,000 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 REFUSE • 900. 2011 FREIGHTLINER RAPID -RAIL M2 $201,000 901. 2005 PETERBILT 320 162,000 903. 1995 FREIGHTLINER FL -70 54,000 PAVILION 801. 1996 CHEV 4X4 TRK $19,100 809. 2003 OLYMPIA ICE RESURFACER 85,000 • 110 CITY OF HOPKINS BUILDING INVENTORY June 2011 Location/Description Replacement Cost City Hall $3,400,900 1010 1st Street S. Police Station 3,835,100 1010 1st Street S. Fire Station 4,214,000 101 17th Avenue S. Hopkins Activity Center 1,825,000 33 14th Avenue S. Ice Arena/Pavilion 5,011,000 11000 Excelsior Boulevard Arts Center 6,865,000 1111 Mainstreet PW Admin/Garage 7,171,000 • 11100 Excelsior Boulevard Moline Reservoir/Well #1 2,295,000 10421 Excelsor Boulevard Blake Tower Reservoir 1,386,700 151 Tyler Avenue S. Filtration Plant 3,372,000 1401 Elmo Park Service Road Well #4 Workshop/Storage 649,400 1401 Elmo Park Service Road Well #5 227,800 1205 Highway? Well #6 303,800 801 Highway 7 Lift Station #2 - Drillane 65,000 619 Drillane Road • Lift Station #3 - Lindee's 130,000 901 Cambridge Street N.E. 111 Location/Description Replacement Cost Lift Station #4 - LTL Meadowbrook $95,000 244 Meadowbrook Road Lift Station #5 - Big Meadowbrook 151,000 6601 Excelsior Blvd. Lift Station #6 - Ronnie's 95,000 8546 Excelsior Avenue E. Lift Station #7 - Valley 300,000 801 6th Avenue S. Band Shell - Downtown Park 36,000 16 9th Avenue S. Concession Stand - Maetzold Field 149,000 1215 1 st Street N. Park Building -Beach - Lifeguards 160,800 5200 Shady Oak Road Park Building -Beach -Concessions 152,000 5200 Shady Oak Road Park Shelter - Office/Bathliouse 369,300 5200 Shady Oak Road Park Shelter - Burnes 49,100 201 Park Lane Park Building - Central 111,500 101 17th Avenue S. Park Building - Harley 37,800 108 Jackson Avenue S. Park Shelter - Interlachen 101,400 220 Homedale Avenue Park Building - Oakes 43,100 301 Tyler Avenue N. Park Building - Valley 50,600 800 7th Avenue S. Parking Ramp 6,236,000 10th Avenue and Mainstreet 112 �J Location/Description Replacement Cost • Depot Coffee House $469,000 9451 Excelsior Boulevard r- I Overpass Skate Park 7,500 100 Washington Avenue Dow Towers (76 Units) HRA 22 5th Avenue S. 113 C