The URL can be used to link to this page

2011 - 2015 ERPCity of Hopkins EQUIPMENT REPLACEMENT PLAN 2011-2015 13200City of qfopkzns 1010 First Street South • Hopkh: w 55343-7573 * Pham:952-935-8474 • FaX. 952-935-1834 - Web address: www.hop(tinsmn.com DATE: July 2010 TO: Honorable Mayor and Members of the City Council FROM: Rick Getschow, City Manager SUBJECT: 2011-2015 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2011-2015 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, Connie Kurtz, Police Administrative Services Director, Dale Specken, Fire Chief, Jim Genellie, Assistant City Manager, Christine Harkess, Finance Director and Deb Dahlheimer, Sr. Finance Clerk for their hard work and dedication. Partnering with the Community to Enhance the QuaCty of Life 0 Inspire • Educate • Involve • Communicate. • EQUIPMENT REPLACEMENT PLAN 2011-2015 TABLE OF CONTENTS CITY MANAGER'S MESSAGE TABLE OF CONTENTS Page INTRODUCTION Background and Summary of Changes from 2010 Plan 1 FIVE YEAR SUMMARIES Equipment Replacement Fund Cash Flow 4 Projects by Year 5 Department Summary 8 Projects by Department 9 Funding Source Summary 12 Projects by Funding Source 13 Projects & Funding Source by Department 16 EQUIPMENT REQUESTS Individual Equipment Request Details 21 TWENTY YEAR REPLACEMENT SCHEDULE Twenty Year Schedule by Department 82 EQUIPMENT AND BUILDING INVENTORY Vehicle/Equipment Inventory 87 Building Inventory 91 Introduction EQUIPMENT REPLACEMENT PLAN 2011 - 2015 BACKGROUND AND SUMMARY OF CHANGES FROM 2010 PLAN Background The Equipment Replacement Plan is a twenty-year forecast and a five-year plan of equipment needs in the City of Hopkins. It is intended to inform the Council and citizens of the major equipment needs on the horizon. The first year of the plan becomes an adopted equipment budget and relates to the operating budget of the equipment replacement fund, which is approved on an annual basis. The remaining nineteen years represent an estimate of equipment needs and funding capabilities of the City. Funding requirements vary from year to year. In order to maintain a fairly consistent levy each year, the twenty-year schedule is projected with a 3% inflation factor for operating expenses and a yearly average dollar capital expenditure of $816,100. 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. Intragovernmental charges are at 58% of what they were in 2002 and at the current rate structure will not return to that level until 2021. Unfortunately our equipment needs are not changing. The plan as presented proposes a 3% increase in charges for 2011, a 4% increase for 2012, a 5% increase in 2013 and a 6% increase in 2014 and 2015. 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. Future increases each year are needed to fund the equipment replacement plan without issuing debt. The Equipment Replacement Plan's basic premise is scheduled replacement of present equipment. A new item must, in the year proposed, be presented in the annual operating budget with a stipulation that replacement will be necessary in the future. Flexibility of the Equipment Replacement Plan is established through annual review and revision, if necessary. Summary of Changes from 2010 Plan Highlights of changes from last year's equipment replacement plan for the years 2011-2015: Activity Center: There were no changes to Activity Center items in this CIP. Arts Center: Due to limited availability of the carpet extractor located in another city building the Arts Center added a carpet extractor for their building at a cost of $3,000 to be purchased in 2012. Due to high usage of this facility it is more efficient for this facility to have their own carpet extractor for cleaning carpets between contract cleanings. City Hall: There were no changes to city hall items in this CIP. Community Services: One copier scheduled for replacement in 2011 was moved back to 2013 based on usage and life expectancy. Fire: Extraction Tool — cost was decreased by $4,200 to $22,300 to reflect actual cost. This item is scheduled for replacement in 2012. Thermal Imaging Camera — cost was decreased by $6,500 to $11,500 to reflect the cost of replacement. This item is scheduled for replacement in 2013. Automated Defibrillator — Purchased four for the price of two in 2010 so adjusted replacement to four at the same replacement cost and moved replacement back to one year to 2014 to plan for a 4 year replacement rather than 3. Summit Trainer — purchased a summit trainer instead of a stairmaster in 2010 and scheduled replacement of the summit trainer for 2015. HRA: Added Housing and Redevelopment Authority capital items to the CIP with funding from the HRA. Pavilion: Ice Resurfacer — price was adjusted from $80,000 to $180,000 to replace existing propane fueled ice resurfacer with an electric driven machine that will meet the new state standards for indoor air quality. Ice Edger — added to the CIP for replacement in 2014 at a cost of $5,000. The ice edger will be used for ice maintenance of the ice sheet and is used to shave the ice next to the boards to remove ice buildup. Police: There were no changes to police department items in this CIP. 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 `a unmanageable the equipment will be put on the schedule for earlier replacement. Parks/Forestry The '/2 ton pickup originally scheduled for replacement in 2011 was moved back to 2012 as its condition warranted extension of its life. The 3/4 ton pickup originally scheduled for replacement in 2011 was moved back to 2012 as its condition warranted extension of its life . The life of this truck was extended from 10 to 14 years. Riding Mower originally scheduled for replacement in 2011 was moved back to 2013 as its condition warranted extension of its life. A tractor (item 10 -ERP -806) originally scheduled for replacement in 2012 was eliminated and replaced with a toolcat that was purchased in 2010. The second tractor due for replacement in 2014 was moved back to 2016. Streets/Traffic The tandem dump truck (item 01 -ERP -306) originally scheduled for replacement in 2013 was moved ahead to 2011 due to the current condition of the truck. The truck will be refurbished at a cost of $22,000 and its life extended to 2018. The second tandem dump truck scheduled for 2015 was moved ahead to 2013 due to the conditions of that truck. Skid Steer Loader originally scheduled for purchase in 2010 was moved back to 2011 as staff felt we could get another year of use from this piece of equipment. Sweeper due for replacement in 2013 at a cost of $164,500 was reduced by $8,100 to $156,400 to more accurately reflect the cost of replacement. 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. 3 Five Year Summaries EQUIPMENT REPLACEMENT FUND (602) Rate Change 0% 0% 2% 3% 4% 5% 6% 6% ACTUAL ACTUAL BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 2008 2009 2010 2011 2012 2013 2014 2015 Working Capital Begin Year 1,371,188 1,033,705 1,161,011 1,087,404 1,123,901 476,717 151,896 83,082 Revenues from charges 287,127 287,463 293,212 302,009 314,089 329,793 349,581 370,556 Transfer In - Pavilion - Capital Lease 20,000 20,000 20,000 20,000 20,000 15,609 Transfer In -Pavilion - Hockey Loan 3,217 3,143 3,143 3,143 3,143 3,143 3,142 Federal & State Grants 12,154 52,545 Fire Truck Lease 425,000 Interest earnings 37,377 18,519 52,760 49,447 51,090 21,966 7,349 4,253 Other revenues (sale of assets) 16,150 10,258 25,000 25,000 25,000 25,000 30,000 30,000 Total Revenues 801,025 391,928 394,115 399,599 413,322 395,512 390,072 404,809 Expenditures (excludes Dept.) 25,604 25,248 26,005 26,786 27,589 28,417 29,269 30,147 expendihues include copier & eng scanner leases Fire Truck Financing Pymnts (2009-2018) 3,889 53,907 54,217 54,217 54,217 54,217 54,217 54,217 Capital Outlay - Equipment 1,109,014 185,467 387,500 282,100 978,700 637,700 375,400 412,200 1,138,507 264,622 467,722 363,102 1,060,506 720,333 458,886 496,564 Working Capital Ending Balance 1,033,705 1,161,011 1,087,404 1,123,901 476,717 151,896 83,082 (8,673) Cash balance 1,031,170 1,172,437 1,098,830 1,135,327 488,143 163,321 94,508 2,753 Memo Only Long Term Receivable 95,609 75,609 55,609 35,609 15,609 - 2007 Hockey Booster Loan repayment 18,783 15,640 12,497 9,354 6,211 3,068 Cash Balance + LT Receivable 1,126,779 1,248,046 1,154,439 1,170,936 503,752 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2011 thm 2015 PROJECTS BY YEAR Project Name Department Project # Priority Project Cost 2011 Art Center Copy Machine Arts Center 01 -ERP -1100 n/a 12,100 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 City Hall Main Copy Machine - Oce' Copier Community Services 01 -ERP -0001 n/a 13,000 Engineering Printer/Scanner Community Services 01 -ERP -0007 n/a 10,000 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Copy Machine Fire 01 -ERP -0110 n/a 10,300 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 67,200 Sergeant's Vehicle Police 01 -ERP -0201 n/a 33,600 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 27,900 Copy Machine Police 01 -ERP -0209 n/a 19,100 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Tandem Dump Trucks (2) Public Works: Streets/Traffic 01 -ERP -0306 n/a 22,000 Skid Loader (2) Public Works: Streets/Traffic 01 -ERP -0309 n/a 36,000 Total for 2011 358,417 2012 Art Center Carpet Extractor Arts Center 01 -ERP -1101 n/a 3,300 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 Engineering Printer/Scanner Community Services 01 -ERP -0007 n/a 10,000 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Quick Attack Pumper/Rescue (Rescue 8) Fire 01 -ERP -0105 n/a 234,000 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Extrication Tool (2) Fire 01 -ERP -0109 n/a 22,300 Workout Equipment - Treadmill Fire 01 -ERP -0118 n/a 5,000 Workout Equipment - Dumb Bells Fire 01 -ERP -0122 n/a 5,000 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 69,200 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 28,800 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Mobile Data Computers Police 01 -ERP -0212 n/a 62,700 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 1/2 Ton Pickup Truck Public Works: Parks/Forestry 01 -ERP -0800 n/a 26,400 4x4 3/4Ton Trucks (2) Public Works: Parks/Forestry 01 -ERP -0801 n/a 67,400 3/4 Ton Utility Truck Public Works: Parks/Forestry 01 -ERP -0802 n/a 32,200 Trucksters (3) Public Works: Parks/Forestry 01 -ERP -0807 n/a 19,800 Riding Mowers (3) Public Works: Parks/Forestry 01 -ERP -0808 n/a 10,300 1 Ton Dump Truck (2) Public Works: Streets/Traffic 01 -ERP -0303 n/a 34,700 1 Ton Traffic Boom Truck Public Works: Streets/Traffic 01 -ERP -0304 n/a 75,000 Front End Loaders (2) Public Works: Streets/Traffic 01 -ERP -0308 n/a 172,000 Roller Public Works: Streets/Traffic 01 -ERP -0312 n/a 45,900 Total for 2012 1,046,217 Wednesday, June 30, 2010 5 Project Name Department Project # Priorit- Project Cost 2013 Activity Center Copy Machine Activity Center 01 -ERP -0030 n/a 15,000 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 City Hall Small Copy Machine Community Services 01 -ERP -0002 n/a 20,000 Engineering Printer/Scanner Community Services 01 -ERP -0007 n/a 10,000 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Thermal Imaging Camera (2) Fire 01 -ERP -0112 n/a 11,500 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 71,200 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 29,600 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Tactical Ballistic Vests Police 01 -ERP -0214 n/a 23,200 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 Engineering Van Public Works: Engineering 01 -ERP -0700 n/a 21,500 Riding Mowers (3) Public Works: Parks/Forestry 01 -ERP -0808 n/a 22,800 Brush Chipper Public Works: Parks/Forestry 01 -ERP -0813 n/a 25,700 4X4 3/4 Ton Truck with Plow Public Works: Streets/Traffic 01 -ERP -0301 n/a 30,400 Tandem Dump Trucks (2) Public Works: Streets/Traffic 01 -ERP -0306 n/a 142,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 836,717 2014 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 Engineering Printer/Scanner Community Services 01 -ERP -0007 n/a 10,000 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Automated External Defibrillator (2) Fire 01 -ERP -0120 n/a 7,200 Copier HRA 01 -ERP -0401 n/a 13,000 Ice Resurfacer Pavilion 01 -ERP -1000 n/a 180,000 Electric Ice Edger Pavilion 01 -ERP -1001 n/a 5,000 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 73,400 Utility 4x4 (unit 212) Police 01 -ERP -0203 n/a 47,700 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 30,500 Logging Recorder Police 01 -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 42,600 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 Riding Mowers (3) Public Works: Parks/Forestry 01 -ERP -0808 n/a 20,300 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 01 -ERP -0550 n/a 35,700 Total for 2014 774,917 2015 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 01 -ERP -0006 n/a 30,000 Engineering Printer/Scanner Community Services 01 -ERP -0007 n/a 12,000 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Duty Chief Vehicle (1) Asst. Chiefs Vehicles (2) Fire 01 -ERP -0103 n/a 37,000 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Wednesday, June 30, 2010 6 Project Name Department Project # Priority Project Cost Workout Equipment - Eliptical Fire 01 -ERP -0116 n/a 5,800 Workout Equipment - Summit Trainer Fire 01 -ERP -0117 n/a 5,800 Workout Equipment - Weight Lifting Fire 01 -ERP -0119 n/a 5,800 4x4 3/4 Ton Truck HRA 01 -ERP -0400 n/a 32,400 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 75,600 Sergeant's Vehicle Police 01 -ERP -0201 n/a 37,800 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 31,400 Police Services Liaison Vehicle Police 01 -ERP -0206 n/a 22,000 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 4x4 3/4 Ton Pickup with Plow Public Works: Streets/Traffic 01 -ERP -0300 n/a 33,600 Sign Machine (Traffic) Public Works: Streets/Traffic 01 -ERP -0317 n/a 13,400 Refuse Truck (RAP -R) (2) Refuse 01 -ERP -0900 n/a 204,800 Public Works Copy Machine Water 01 -ERP -0506 n/a 14,200 Total for 2015 GRAND TOTAL 743,417 3,759,685 Wednesday, June 30, 2010 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2011 thm 2015 DEPARTMENT SUMMARY Department 2011 2012 2013 2014 201.5 Total Activity Center 15,000 15,000 Arts Center 12,100 3,300 15,400 City Hall Administration 38,000 38,000 38,000 38,000 127,600 279,600 Community Services 29,500 16,500 36,500 16,500 18,500 117,500 Fire 64,517 320,517 65,717 61,417 108,617 620,785 HRA 13,000 32,400 45,400 Pavilion 185,000 185,000 Police 156,300 184,200 147,500 254,600 190,300 932,900 Public Works: Engineering 21,500 21,500 Public Works: Parks/Forestry 156,100 48,500 20,300 224,900 Public Works: Streets/Traffic 58,000 327,600 329,200 48,800 47,000 810,600 Refuse 101,600 204,800 306,400 Sewer 35,700 35,700 Water 134,800 14,200 149,000 TOTAL 358,417 1,046,217 836,717 774,917 743,417 3,759,685 8 Wednesday, June 30, 2010 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2011 thm 2015 PROJECTS BY DEPARTMENT Department Project# Priority 2011 2012 2013 2014 2015 Total Activity Center Activity Center Copy Machine 01 -ERP -0030 n/a 15,000 15.000 Activity Center Total 15,000 151.000 Arts Center Art Center Copy Machine 01 -ERP -1100 n/a 12,100 12,100 Art Center Carpet Extractor 01 -ERP -1101 n/a 3,300 3,300 Arts Center Total 12,100 3,300 15,400 City Hall Administration Network Server 01 -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01 -ERP -0004 n/a 89,600 89,600 Computers 01 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 City Hall Administration Total 38,000 38,000 38,000 38,000 127,600 279,600 Community Services City Hall Main Copy Machine - Oce' Copier 01 -ERP -0001 n/a 13,000 13,000 City Hall Small Copy Machine 01 -ERP -0002 n/a 20,000 20,000 Engineering Printer/Scanner 01 -ERP -0007 n/a 10,000 10,000 10,000 10,000 12,000 52,000 Document Management Scanner (3) 01 -ERP -0008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 Community Services Total 29,500 16,500 36,500 16,500 18,500 117,500 Fire Duty Chief Vehicle (1) Asst. Chiefs Vehicles (2) 01 -ERP -0103 n/a 37,000 37,000 Quick Attack Pumper/Rescue (Rescue 8) 01 -ERP -0105 n/a 234,000 234,000 Aerial Truck 01 -ERP -0106 n/a 54,217 54,217 54,217 54,217 54,217 271,085 Extrication Tool (2) 01 -ERP -0109 n/a 22,300 22,300 Copy Machine 01 -ERP -0110 n/a 10,300 10,300 Thermal Imaging Camera (2) 01 -ERP -0112 n/a 11,500 11,500 Workout Equipment - Eliptical 01 -ERP -0116 n/a 5,800 5,800 Workout Equipment - Summit Trainer 01 -ERP -0117 n/a 5,800 5,800 Workout Equipment - Treadmill 01 -ERP -0118 n/a 5,000 5,000 Workout Equipment - Weight Lifting 01 -ERP -0119 n/a 5,800 5,800 Automated External Defibrillator (2) 01 -ERP -0120 n/a 7,200 7,200 Workout Equipment - Dumb Bells 01 -ERP -0122 n/a 5,000 5,000 Fire Total 64,517 320,517 65,717 61,417 108,617 6201.785 HRA 4x43/4 Ton Truck 01 -ERP -0400 n/a 32,400 32,400 Copier 01 -ERP -0401 n/a 13,000 13,000 9 Wednesday, June 30, 2010 Department Project# Priority 2011 2012 2013 2014 201.5 Total HRA Total Pavilion Ice Resurfacer 01 -ERP -1000 n/a Electric Ice Edger 01 -ERP -1001 n/a Pavilion Total Police Marked Patrol Vehicles (6) 01 -ERP -0200 n/a Sergeant's Vehicle 01 -ERP -0201 n/a Utility 4x4 (unit 212) 01 -ERP -0203 n/a Police Administrative Vehicles (2) 01 -ERP -0204 n/a Police Services Liaison Vehicle 01 -ERP -0206 n/a Copy Machine 01 -ERP -0209 n/a Logging Recorder 01 -ERP -0210 n/a Network Server (3) 01 -ERP -0211 n/a Mobile Data Computers 01 -ERP -0212 n/a Digital Squad Car Cameras 01 -ERP -0213 n/a Tactical Ballistic Vests 01 -ERP -0214 n/a Radios - Portable and Mobile Devices 01 -ERP -0215 n/a Police Total 37,800 71,400 Public Works: Engineering Engineering Van 01 -ERP -0700 n/a Public Works: Engineering Total 47,700 27,900 28,800 29,600 30,500 Public Works: Parks/Forestry 1/2 Ton Pickup Truck 01 -ERP -0800 n/a 4x4 3/4Ton Trucks (2) 01 -ERP -0801 n/a 3/4 Ton Utility Truck 01 -ERP -0802 n/a Trucksters (3) 01 -ERP -0807 n/a Riding Mowers (3) 01 -ERP -0808 n/a Brush Chipper 01 -ERP -0813 n/a Public Works: Parks/Forestry Total 8,500 8,500 8,500 8,500 8,500 Public Works: Streets/Traffic 4x4 3/4 Ton Pickup with Plow 01 -ERP -0300 n/a 4X4 3/4 Ton Truck with Plow 01 -ERP -0301 n/a 1 Ton Dump Truck (2) 01 -ERP -0303 n/a 1 Ton Traffic Boom Truck 01 -ERP -0304 n/a Tandem Dump Trucks (2) 01 -ERP -0306 n/a Front End Loaders (2) 01 -ERP -0308 n/a Skid Loader (2) 01 -ERP -0309 n/a Sweeper 01 -ERP -0311 n/a Roller 01 -ERP -0312 n/a Asphalt Paver 01 -ERP -0314 n/a Sign Machine (Traffic) 01 -ERP -0317 n/a Public Works: Streets/Traffic Total 156,100 48,500 20,300 224.900 33,600 33,600 30,400 30,400 34,700 34,700 13,000 32,400 45,400 22,000 142,400 164,400 180,000 180,000 36,000 36,000 5,000 156,400 5,000 45,900 45,900 185,000 48,800 185,000 67,200 69,200 71,200 73,400 75,600 356,600 33,600 37,800 71,400 47,700 47,700 27,900 28,800 29,600 30,500 31,400 148,200 22,000 22,000 19,100 19,100 36,900 36,900 8,500 8,500 8,500 8,500 8,500 42,500 62,700 62,700 42,600 42,600 23,200 23,200 15,000 15,000 15,000 15,000 60,000 156,300 184,200 147,500 254,600 190,300 932,900 21,500 21.500 21,500 21,500 26,400 26,400 67,400 67,400 32,200 32,200 19,800 19,800 10,300 22,800 20,300 53,400 25,700 25,700 156,100 48,500 20,300 224.900 10 Wednesday, June 30, 2010 33,600 33,600 30,400 30,400 34,700 34,700 75,000 75,000 22,000 142,400 164,400 172,000 172,000 36,000 36,000 156,400 156,400 45,900 45,900 48,800 48,800 13,400 13,400 58,000 327,600 329,200 48,800 47,000 810,600 10 Wednesday, June 30, 2010 Department Project# Priority 2011 2012 2013 2014 2015 Total 101,600 204,800 204.800 101.600 101,600 Refuse 306,400 Refuse Truck (RAP -R) (2) 01 -ERP -0900 n/a Refuse Truck (Rear -L) 35,700 01 -ERP -0901 n/a 134.800 14.200 Refuse Total 14,200 149,000 358,417 1,046,217 836,717 774,917 743,417 3,759,685 Sew er 4x4 3/4 Ton Truck 01 -ERP -0550 n/a Sewer Total Water Backhoe Loader 01 -ERP -0502 n/a Public Works Copy Machine 01 -ERP -0506 n/a Water Total GRAND TOTAL 101,600 204,800 204.800 101.600 101,600 204,800 306,400 35,700 35.700 35,700 35,700 134,800 14,200 134.800 14.200 134,800 14,200 149,000 358,417 1,046,217 836,717 774,917 743,417 3,759,685 11 T['eclnesclar, June 30, 2010 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2011 thm 2015 FUNDING SOURCE SUMMARY Source 2011 2012 2013 AC - Arts Center Fund 12,100 3,300 Bonds/Lease 54,217 54,217 Equipment Replacement Fund 292,100 988,700 HRA - Housing and Redevelopment Authority PA - Pavilion Fund RF - Refuse Fund SF - Sanitary Sewer Fund WF - Water Fund 2014 2015 Total GRAND TOTAL 358,417 1,046,217 836,717 774,917 743,417 3,759,685 Wednesday, June 30, 2010 fV 15,400 54,217 54,217 54,217 271,085 647,700 385,400 424,200 2,738,100 13,000 32,400 45,400 185,000 185,000 101,600 204,800 306,400 35,700 6,800 42,500 134,800 21,000 155,800 GRAND TOTAL 358,417 1,046,217 836,717 774,917 743,417 3,759,685 Wednesday, June 30, 2010 fV City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2011 thm 2015 PROJECTS BY FUNDING SOURCE Source Project# Prioritv 2011 2012 2013 2014 2015 Total AC - Arts Center Fund Art Center Copy Machine 01 -ERP -1100 n/a 12,100 12,100 Art Center Carpet Extractor 01 -ERP -1101 n/a 3,300 3,300 AC - Arts Center Fund Total 12,100 3,300 15,400 Bonds/Lease Aerial Truck 01 -ERP -0106 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 - Oce' Copier 01 -ERP -0001 n/a 13,000 13,000 City Hall Small Copy Machine 01 -ERP -0002 n/a 20,000 20,000 Network Server 01 -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01 -ERP -0004 n/a 76,000 76,000 Computers 01 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 Engineering Printer/Scanner 01 -ERP -0007 n/a 10,000 10,000 10,000 10,000 12,000 52,000 Document Management Scanner (3) 01 -ERP -0008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 Activity Center Copy Machine 01 -ERP -0030 n/a 15,000 15,000 Duty Chief Vehicle (1) Asst. Chiefs Vehicles (2) 01 -ERP -0103 n/a 37,000 37,000 Quick Attack Pumper/Rescue (Rescue 8) 01 -ERP -0105 n/a 234,000 234,000 Extrication Tool (2) 01 -ERP -0109 n/a 22,300 22,300 Copy Machine 01 -ERP -0110 n/a 10,300 10,300 Thermal Imaging Camera (2) 01 -ERP -0112 n/a 11,500 11,500 Workout Equipment - Eliptical 01 -ERP -0116 n/a 5,800 5,800 Workout Equipment - Summit Trainer 01 -ERP -0117 n/a 5,800 5,800 Workout Equipment - Treadmill 01 -ERP -0118 n/a 5,000 5,000 Workout Equipment - Weight Lifting 01 -ERP -0119 n/a 5,800 5,800 Automated External Defibrillator (2) 01 -ERP -0120 n/a 7,200 7,200 Workout Equipment - Dumb Bells 01 -ERP -0122 n/a 5,000 5,000 Marked Patrol Vehicles (6) 01 -ERP -0200 n/a 67,200 69,200 71,200 73,400 75,600 356,600 Sergeant's Vehicle 01 -ERP -0201 n/a 33,600 37,800 71,400 Utility 4x4 (unit 212) 01 -ERP -0203 n/a 47,700 47,700 Police Administrative Vehicles (2) 01 -ERP -0204 n/a 27,900 28,800 29,600 30,500 31,400 148,200 Police Services Liaison Vehicle 01 -ERP -0206 n/a 22,000 22,000 Copy Machine 01 -ERP -0209 n/a 19,100 19,100 Logging Recorder 01 -ERP -0210 n/a 36,900 36,900 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 62,700 62,700 Digital Squad Car Cameras 01 -ERP -0213 n/a 42,600 42,600 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 60,000 4x43/4 Ton Pickup with Plow 01 -ERP -0300 n/a 33,600 33,600 Wednesday, June 30, 2010 13 Source Project# Priority 2011 2012 2013 2014 2015 Total 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 75,000 75,000 Tandem Dump Trucks (2) 01 -ERP -0306 n/a 22,000 142,400 164,400 Front End Loaders (2) 01 -ERP -0308 n/a 172,000 172,000 Skid Loader (2) 01 -ERP -0309 n/a 36,000 36,000 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 Sign Machine (Traffic) 01 -ERP -0317 n/a 13,400 13,400 Engineering Van 01 -ERP -0700 n/a 21,500 21,500 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 Trucksters (3) 01 -ERP -0807 n/a 19,800 19,800 Riding Mowers (3) 01 -ERP -0808 n/a 10,300 22,800 20,300 53,400 Brush Chipper 01 -ERP -0813 n/a 25,700 25,700 Equipment Replacement Fund Total 292,100 988,700 647,700 385,400 424,200 2,738,100 HRA - Housing and Redevelopment A 4x43/4 Ton Truck 01 -ERP -0400 n/a 32,400 32,400 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 RF - Refuse Fund Refuse Truck (RAP -R) (2) 01 -ERP -0900 n/a 204,800 204,800 Refuse Truck (Rear -L) 01 -ERP -0901 n/a 101,600 101,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 4x43/4 Ton Truck 01 -ERP -0550 n/a 35,700 35,700 SF - Sanitary Sewer Fund Total 35,700 6,800 42,500 WF - Water Fund Telephone System 01 -ERP -0004 n/a 6,800 6,800 Backhoe Loader 01 -ERP -0502 n/a 134,800 134,800 Public Works Copy Machine 01 -ERP -0506 n/a 14,200 14,200 WF - Water Fund Total 134,800 21,000 155,800 Wednesday, June 30, 2010 14 Source Project# Priority GRAND TOTAL 2011 2012 2013 358,417 1,046,217 836,717 2014 2015 774,917 743,417 Total 3,759,685 'wines lav, Jidne -,0, 2010 15 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2011 thru 2015 PROJECTS & FUNDING SOURCES BY DEPARTMENT Department Project# Priority 2011 2012 2013 201.4 2015 Total Activity Center Activity Center Copy Machine 01 -ERP -0030 n/a 15,000 15,000 Activity Center Total 15,000 15,000 Equipment Replacement Fund 15,000 15,000 Activity Center Total 15,000 15,000 Arts Center Art Center Copy Machine 01 -ERP -1100 n/a 12,100 12,100 Art Center Carpet Extractor 01 -ERP -1101 n/a 3,300 3,300 Arts Center Total 12,100 3,300 15,400 AC -Arts Center Fund 12,100 3,300 15,400 Arts Center Total 12,100 3,300 15,400 City Hall Administration Network Server 01 -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01 -ERP -0004 n/a 89,600 89,600 Computers 01 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 City lull Administration Total 38,000 38,000 38,000 38,000 127,600 279,600 Equipment Replacement Fund 38,000 38,000 38,000 38,000 114,000 266,000 SF- Sanitary Sewer Fund 6,800 6,800 WF- Water Fund 6,800 6,800 City Hall Administration Total 38,000 38,000 38,000 38,000 127,600 279,600 Community Services City Hall Main Copy Machine - Oce' Copier 01 -ERP -0001 n/a 13,000 13,000 City Hall Small Copy Machine 01 -ERP -0002 n/a 20,000 20,000 Engineering Printer/Scanner 01 -ERP -0007 n/a 10,000 10,000 10,000 10,000 12,000 52,000 Document Management Scanner (3) 01 -ERP -0008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 Wednesday, June 30, 2010 16 Department Project# Priority 2011 2012 2013 2014 201.5 Total Community Services Total 37,000 Quick Attack Pumper/Rescue (Rescue 8) 01 -ERP -0105 n/a 234,000 29,500 16,500 36,500 16,500 18,500 117,500 n/a 54,217 54,217 54,217 54,217 54,217 Equipment Replacement Fund 29,500 16,500 36,500 16,500 18,500 117,500 Community Services Total 22,300 Copy Machine 01 -ERP -0110 n/a 10,300 29,500 16,500 36,500 16,500 18,500 117,500 Fire Duty Chief Vehicle (1) Asst. Chiefs Vehicles (2) 01 -ERP -0103 n/a 37,000 37,000 Quick Attack Pumper/Rescue (Rescue 8) 01 -ERP -0105 n/a 234,000 234,000 Aerial Truck 01 -ERP -0106 n/a 54,217 54,217 54,217 54,217 54,217 271,085 Extrication Tool (2) 01 -ERP -0109 n/a 22,300 22,300 Copy Machine 01 -ERP -0110 n/a 10,300 10,300 Thermal Imaging Camera (2) 01 -ERP -0112 n/a 11,500 11,500 Workout Equipment - Eliptical 01 -ERP -0116 n/a 5,800 5,800 Workout Equipment - Summit Trainer 01 -ERP -0117 n/a 5,800 5,800 Workout Equipment - Treadmill 01 -ERP -0118 n/a 5,000 5,000 Workout Equipment - Weight Lifting 01 -ERP -0119 n/a 5,800 5,800 Automated External Defibrillator (2) 01 -ERP -0120 n/a 7,200 7,200 Workout Equipment - Dumb Bells 01 -ERP -0122 n/a 5,000 5,000 Fire Total 64,517 320,517 65,717 61,417 108,617 620,785 Bonds/Lease 54,217 54,217 54,217 54,217 54,217 271,085 Equipment Replacement Fund 10,300 266,300 11,500 7,200 54,400 349,700 Fare Total 64,517 320,517 65,717 61,417 108,617 620,785 HRA 4x43/4 Ton Truck 01 -ERP -0400 n/a 32,400 32,400 Copier 01 -ERP -0401 n/a 13,000 13,000 HRA Total 13,000 32,400 45,400 HRA - Housing and Redevelopment Ant 13,000 32,400 45,400 HRA Total 13,000 32,400 45,400 Pavilion Ice Resurfacer 01 -ERP -1000 n/a 180,000 180,000 Electric Ice Edger 01 -ERP -1001 n/a 5,000 5,000 Pavilion Total 185,000 185,000 PA - Pavilion Fund 185,000 185,000 Wednesday, June 30, 2010 17 Department Project# Priority 2011 2012 2013 2014 2015 Total Pavilion Total 185,000 185,000 Police Marked Patrol Vehicles (6) 01 -ERP -0200 n/a 67,200 69,200 71,200 73,400 75,600 356,600 Sergeant's Vehicle 01 -ERP -0201 n/a 33,600 37,800 71,400 Utility 44 (unit 212) 01 -ERP -0203 n/a 47,700 47,700 Police Administrative Vehicles (2) 01 -ERP -0204 n/a 27,900 28,800 29,600 30,500 31,400 148,200 Police Services Liaison Vehicle 01 -ERP -0206 n/a 22,000 22,000 Copy Machine 01 -ERP -0209 n/a 19,100 19,100 Logging Recorder 01 -ERP -0210 n/a 36,900 36,900 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 62,700 62,700 Digital Squad Car Cameras 01 -ERP -0213 n/a 42,600 42,600 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 60,000 Police Total 156,300 184,200 147,500 254,600 190,300 932,900 Equipment Replacement Fund 156,300 184,200 147,500 254,600 190,300 932,900 Police Total 156,300 184,200 147,500 254,600 190,300 932,900 Public Works: Engineering Engineering Van 01 -ERP -0700 n/a 21,500 21,500 Public Works: Engineering Total 21,500 21,500 Equipment Replacement Fund 21,500 21,500 Public Works: Engineering Total 21,500 21,500 Public Works: Parks/Forestry 1/2 Ton Pickup Truck 01 -ERP -0800 n/a 26,400 26,400 443/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 Trucksters (3) 01 -ERP -0807 n/a 19,800 19,800 Riding Mowers (3) 01 -ERP -0808 n/a 10,300 22,800 20,300 53,400 Brush Chipper 01 -ERP -0813 n/a 25,700 25,700 Public Works: Parks/Forestry Total 156,100 48,500 20,300 224,900 Equipment Replacement Fund 156,100 48,500 20,300 224,900 Public Works: Parks/Forestry Total 156,100 48,500 20,300 224,900 Wednesday, June 30, 2010 18 Department Project# Priority 2011 2012 2013 2014 2015 Total Public Works: Streets/Traffic 4x43/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 75,000 75,000 Tandem Dump Trucks (2) 01 -ERP -0306 n/a 22,000 142,400 164,400 Front End Loaders (2) 01 -ERP -0308 n/a 172,000 172,000 Skid Loader (2) 01 -ERP -0309 n/a 36,000 36,000 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 Sign Machine (Traffic) 01 -ERP -0317 n/a 13,400 13,400 Public Works: Streets/Traffic Total 58,000 327,600 329,200 48,800 47,000 810,600 Equipment Replacement Fund 58,000 327,600 329,200 48,800 47,000 810,600 Public Works: Streets/Traffic Total 58,000 327,600 329,200 48,800 47,000 810,600 Refuse Refuse Truck (RAP -R) (2) 01 -ERP -0900 n/a 204,800 204,800 Refuse Truck (Rear -L) 01 -ERP -0901 n/a 101,600 101,600 Refuse Total 101,600 204,800 306,400 RF- Refuse Fund 101,600 204,800 306,400 Refuse Total 101,600 204,800 306,400 Sewer 4x43/4 Ton Truck 01 -ERP -0550 n/a 35,700 35,700 Sewer Total 35,700 35,700 SF- Sanitary Sewer Fund 35,700 35,700 Sewer Total 35,700 35,700 Water Backhoe Loader 01 -ERP -0502 n/a 134,800 134,800 Public Works Copy Machine 01 -ERP -0506 n/a 14,200 14,200 Water Total 134,800 14,200 149,000 WF- Water Fund 134,800 14,200 149,000 Wednesday, June 30, 2010 19 Department Project# Priority 2011 2012 2013 201.4 2015 Total Vater Total 134,800 14,200 149,000 Grand Total 358,417 1,046,217 836,717 774,917 743,417 3,759,685 Of U ednesdoY, June 30, 2010 Equipment Requests EQUIPMENT REPLACEMENT FLAN 2011 thru 2015 City of Hopkins, MN Project # 01 -ERP -0001 Project Name City Hall Main Copy Machine - Oce' Copier Type Equipment Department Community Services Useful Life 5 years Contact City Clerk Category Equipment Priority n/a Future Description I Total Project Cost: $160,000 Copy machine to service needs of all departments located at City Hall. 1. Variety of copying tasks. 2. High volume product copier. [dote: equipment is leased. This copier may not make it to 2011. 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 - lease renewed for 36 months. Plan to purchase new copier in 2011. Cost reduced by $1,000 due to pricing reductions. Estimate salvage/resale value on replaced item: $-0- Prior Expenditures 2011 2012 2013 2014 2015 Total Future 94,200 Equipment 13,000 13,000 52,800 Total Total 13,000 13,000 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 94,200 Equipment Replacement Fund 13,000 13,000 52,800 Total Total 13,000 13,000 Total Wednesday, June 30, 2010 PAI EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0002 Project Name City Hall Small Copy Machine 2011 thru 2015 Type Equipment Department Community Services Useful Life 5 years Contact City Clerk Category Equipment Priority n/a Future Description I Total Project Cost: $144,500 Coyy machine to service needs of all departments located at City Hall. 1, Variety of copying tasks. 2. High volume product copier. ote: This is a Ricoh color copier. 2006 Ricoh 55606W Justification )aily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and ipdates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. ance from 20 year plan - Cost reduced $6,900 due to pricing reductions. Move back to 2013. nate salvage/resale value on replaced item: $2,500 Prior Expenditures 43,200 Equipment Total 2011 2012 2013 2014 2015 20,000 `);'per 20,000 Total Future 20,000 81,300 20,000 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 43,200 Equipment Replacement Fund 20,000 20,000 81,300 Total Total 20,000 20,000 Total Wednesday, June 30, 2010 01 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0003 Project Name Network Server 2011 thru 2015 Type Equipment Department City Hall Administration Useful Life 1 year Contact Finance Director/IT Category Equipment Priority n/a Future Description I Total Project Cost: $225,000 Che network server is the hub of the network. New computers are faster and more reliable. Justification 4etworking allows user to share information that is stored in a single location, the network server. This is more efficient because the information loes not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every xser is working with the same data. ance from 20 year plan - none nate salvage/resale value on replaced item: $-0- Prior Expenditures 65,000 Equipment Total 2011 2012 2013 2014 2015 Total Future 8,000 8,000 8,000 8,000 8,000 40,000 120,000 Tom 8,000 8,000 8,000 8,000 8,000 40,000 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 65,000 Equipment Replacement Fund 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 Wednesday, June 30, 2010 23 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0004 Project Name Telephone System 2011 thru 2015 Type Equipment Department City Hall Administration Useful Life 8 years Contact IT Director Category Equipment Priority n/a Future Description I Total Project Cost: $239,200 ncludes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also ncludes software for the PBX and voice mail systems. Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015. Estimate salvage/resale value on replaced item: $ Prior Expenditures 2011 2012 2013 2014 2015 Total Future 60,000 Equipment 89,600 89,600 89,600 Total Total 89,600 89,600 Total Prior Funding Sources 60,000 Equipment Replacement Fund Total SF - Sanitary Sewer Fund 2011 2012 2013 2014 2015 76,000 6,800 6,800 Total Future 76,000 89,600 6,800 Total Total 89,600 89,600 Wednesday, June 30, 2010 24 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0006 Project Name Computers 2011 thru 2015 Type Equipment Department City Hall Administration Useful Life 3-5 years Contact Finance Director/IT Category Equipment Priority n/a Future Description I Total Project Cost: $900,000 'ersonal computer purchases and upgrades for the entire City stag. Coordinating personal computer purchases from individual departments to one Justification Cools enabling staff to perform job responsibilities efficiently and effectively. ance from 20 year plan - none nate salvage/resale value on replaced item: $-0- Prior Expenditures 300,000 Equipment Total 2011 2012 2013 2014 2015 Total Future 30,000 30,000 30,000 30,000 30,000 150,000 450,000 Tom 30,000 30,000 30,000 30,000 30,000 150,000 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 300,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 Wednesday, June 30, 2010 Pki EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0007 Project Name Engineering Printer/Scanner 2011 thru 2015 Type Equipment Department Community Services Useful Life 5 years Contact City Clerk Category Equipment Priority n/a Future Description I Total Project Cost: $312,560 Tinter/scanner - large format copier use in Engineering to copy blueprints, plans and large documents. uipment is leased. Justification ,arge document copier/scanner for use in Engineering. Also scans documents for permanent storage. fiance from 20 year plan - None mate salvage/resale value on replaced item: $-0- Prior Expenditures 44,500 Equipment Total 2011 2012 2013 2014 2015 Total Future 10,000 10,000 10,000 10,000 12,000 52,000 216,000 Tom 10,000 10,000 10,000 10,000 12,000 52,000 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 44,560 Equipment Replacement Fund 10,000 10,000 10,000 10,000 12,000 52,000 216,000 Total Total 10,000 10,000 10,000 10,000 12,000 52,000 Total Wednesday, June 30, 2010 KV: EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN 'rojeet 4 01 -ERP -0008 'roject Name Document Management Scanner (3) 2011 thru 2015 Type Equipment Department Community Services Useful Life 3 years Contact City Clerk Category Equipment Priority n/a Future Description Total Project Cost: $149,500 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 ............ . One additional small scanner was added to the scanning station in 2009. This scanner previously was used by the Inspections secretary. This scanner does not handle 11" x 17" paper so can not do all documents. Scanners will be evaluated each year for replacement. If scanners are working properly 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 documents up to 8'/z" x 14". We would like to replace this scanner with a large document scanner to fully utilize our volunteers. 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. 97,500 32,500 Estimate salvage/resale value on replaced item: $500-$1,000 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 19,500 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 19,500 Equipment Replacement Fund Total Total 2011 2012 6,500 6,500 6,500 6,500 27 2013 2014 6,500 6,500 6,500 6,500 2015 6,500 6,500 Total Future 32,500 97,500 32,500 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0030 Project Name Activity Center Copy Machine 2011 thrit 2015 Type Equipment Department Activity Center Useful Life Unassigned Contact Facilities Director Category Equipment Prioiitp n Future Description Total Project Cost: $56,000 .opy machine used by staff for daily operations of the Hopkins Activity Center. Current equipment: Ricoh 2228C Justification Copy flyers. letters, forms, informational items, etc. arianee from 20 year plan - None >timate salvaue;'resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 15,000 15,000 41,000 Tom 15,000 15,000 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund Total 28 15,000 15,000 41,000 15,000 15,000 Total IT'ednesdav, Ane 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0103 Project Name Duty Chief Vehicle (1) Asst. Chiefs Vehicles (2) Type Equipment Useful Life 15 years Category Vehicles Future Department Fire Contact Fire Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $254,200 � marked passenger vehicle for use by the Duty Chief and Assistant Chiefs in transporting required equipment, reference materials and personnel or emergency response, and routine Fire Department business. vehicles: 2010 Chevrolet Tahoe (Chief) 2006 Dodge Durango (Asst. Chief) Chevrolet Impala (Asst. Chief) to be replaced with 2015 SUV Justification Jsed 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 ire 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. ante from 20 year plan - Add 2 vehicles and change life to 15 years. nate salvage/resale value on replaced item: $4,000 Prior Expenditures 64,500 Vehicles Total 2011 2012 2013 2014 2015 37,000 Tom 37,000 Total Future 37,000 152,700 37,000 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 64,500 Equipment Replacement Fund 37,000 37,000 152,700 Total Total 37,000 37,000 Total Wednesday, June 30, 2010 p EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0105 Project Name Quick Attack Pumper/Rescue (Rescue 8) Type Equipment Useful Life 15 years Category Vehicles Future Description Zuick attack pumper/rescue. Department Fire Contact Fire Chief Priority n/a Total Project Cost: $598,600 2011 thru 2015 Justification ]Vould replace Rescue 8 (lite rescue) and use as a utility vehicle. This truck could be used for daytime and nighttime medicals and small fires. Chis will reduce having all personnel respond to small fires. It will also let us drop one engine in 2022 but still keep ISO rating. ante from 20 year plan - New item. nate salvage/resale value on replaced item S Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 234,000 234,000 364,600 Tom 234,000 234,000 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund 234,000 234,000 364,600 Total 234,000 234,000 Total Wednesday, June 30, 2010 at, EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0106 Project Name Aerial Truck Type Equipment Useful Life 20 years Category Vehicles Future Department Fire Contact Fire Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $2,559,597 ane hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on '.008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23. ,urrent vehicle: 2008 Pierce Arrow XT Aerial Ladder Justification lehicle 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 L 10 -year capital lease of $425,000. At the end of the lease term payments (P&I) will total $542,170. Total costs of aerial including cash )ayments equals $987,597. Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage/resale value on replaced item: $ Prior Expenditures 2011 2012 2013 2014 2015 Total Future 553,861 Equipment 54,217 54,217 54,217 54,217 54,217 271,085 1,734,651 Total Total 54,217 54,217 54,217 54,217 54,217 271,085 Total Prior Funding Sources 553,861 Bonds/Lease Total 2011 2012 2013 2014 2015 Total Future 54,217 54,217 54,217 54,217 54,217 271,085 1,734,651 Total 54,217 54,217 54,217 54,217 54,217 271,085 Total 01 Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN 'roject # 01 -ERP -0109 'roject Name Extrication Tool (2) Type Equipment Useful Life 10 years Category Equipment Future Department Fire Contact Fire Chief Priority n/a Description I Total Project Cost: $136,900 iydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. 2011 thru 2015 Justification X11 vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool wil be added to the purchase of the luick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. Variance from 20 year plan - move back from 2015 to 2019. Estimate salvage/resale value on replaced item: $1,000 Purchased: 2007 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 20,300 Equipment 22,300 22,300 94,300 Total Total 22,300 22,300 Total Prior Funding Sources 20,300 Equipment Replacement Fund Total Total 2011 2012 22,300 22,300 [c3A 2013 2014 2015 Total Future 22,300 94,300 22,300 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0110 Project Name Copy Machine Type Equipment tTseful Life 8 rears Category Equipment Future Description Tire Station cope machine. Current equipment: 2003 Ricoh Aficio 1035P Justification Copying business papers, training records. etc. Department Fire Contact Fire Chief Prioiitv n Total Project Cost: $47,400 2011 thrit 2015 Variance from 20 year plan - none Estimate salvage;"resale value on replaced item: $500 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 7,400 Equipment 10,300 10,300 29,700 Total Total 10,300 10,300 Total Prior Funding Sources 2011 2012 2013 2014 2015 7,400 Equipment Replacement Fund 10,300 Total Tom 10,300 33 Total Future 10,300 29,700 10,300 Total If'ednesdav, hire 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN 'roject # 01 -ERP -0112 'roject Name Thermal Imaging Camera (2) Type Equipment Useful Life 10 years Category Equipment Future Department Fire Contact Fire Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $72,200 Jsed by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and heat may be hidden allowing or faster extinguishment. Note: purchased 2005 & 2007 Justification Current camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was purchased with donation Variance from 20 year plan - department owns 2 cameras. Previously one one was included in the replacement plan. This will add to the replacement schedule the camera purchased from the Fire Dept budget in 2003. Estimate salvage/resale value on re alced item: $-0- Prior Expenditures 2011 2012 2013 2014 2015 Total Future 15,000 Equipment 11,500 11,500 45,700 Total Total 11,500 11,500 Total Prior Funding Sources 15,000 Equipment Replacement Fund Total Total 2011 2012 2013 2014 2015 11,500 11,500 34 Total Future 11,500 45,700 11,500 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN 'rojeet # 01 -ERP -0116 'rojeet Name Workout Equipment - Eliptical Type Equipment Useful Life 6 years Category Equipment Future Department Fire Contact Fire Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $20,300 ]Vorkout equipment used in Fire Department workout room. One eliptical machine replaced on a 6 year cycle, one every 3 years. Justification Chis equipment is available to all City employees for health and wellness. ance from 20 year plan - had two eliptical machines in the ERP. One was replaced along with the stairmaster with a summit trainer. The lining eliptical is scheduled for replacement in 2015. nate salvage/resale value on replaced item: S Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 5,800 5,800 14,500 Tom 5,800 5,800 Total Funding Sources Equipment Replacement Fund Total 2011 2012 2013 2014 2015 5,800 5,800 m Total Future 5,800 14,500 5,800 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0117 Project Name Workout Equipment - Summit Trainer Type Equipment tTseful Life 5 rears Category Equipment Future Department Fire Contact Fire Chief Prioiitv n Description I Total Project Cost: $34,300 Vorkout equipment used in Fire Department workout room. ane summit trainer replaced on a 5 year cycle. Current equipment: 2010 Summit Trainer Justification This equipment is available to all Cite employees for health and wellness. 2011 thri, 2015 Variance from 20 year plan - replaces stairmaster. Estimate salvaae;'resale value on replaced item: S Prior Expenditures 2011 2012 2013 2014 2015 Total Future 5,000 Equipment 5,800 5,800 23,500 Total Total 5,800 5,800 Total Prior Funding Sources 5,000 Equipment Replacement Fund Total Total 2011 2012 2013 2014 0 2015 Total Future 5,800 5,800 23,500 5,800 5,800 Total If'ednesdav, hire 30, 2010 EQUIPMENT REPLACEMENT 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 7Vorkout equipment used in the Fire Department workout room. )ne treadmill replaced on a 5 year cycle. Justification Chis equipment is available to all City employees for health and wellness. 2011 thru 2015 ante from 20 year plan - move back one year from 2011 to 2012. nate salvage/resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 5,000 5,000 20,300 Total 5,000 5,000 Total Funding Sources 2011 2012 2013 201.1 2015 Total Future Equipment Replacement Fund 5,000 5,000 20,300 Tom 5,000 5,000 Total Wednesday, June 30, 2010 37 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Projeet # 01 -ERP -0119 Project Name Workout Equipment - Weight Lifting Type Equipment Useful Life 5 years Category Equipment Future Description smith machine - weight lifting machine. Department Fire Contact Fire Chief Priority n/a Total Project Cost: $29,300 2011 thru 2015 Justification or use by Police, Fire, Public Works, City staff to keep in shape to perform job duties and stay healthy. Current machine will be 7 years old in !012. Suggested replacement is every 5 years. ante from 20 year plan - move back from 2011 to 2015 nate salvage/resale value on replaced items: $ Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 5,800 5,800 23,500 Total 5,800 5,800 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund 5,800 5,800 23,500 Tom 5,800 5,800 Total Wednesday, June 30, 2010 38 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Projeet 4 01 -ERP -0120 Vrojeet Name Automated External Defibrillator (2) Type Equipment Useful Life 3 years Category Equipment Future Department Fire Contact Fire Chief Priority n/a Description I Total Project Cost: $49,100 )efibrillator is used to help get someones heart restarted during a cardiac arrest. awn 2 - both are replaced at one time due to changing technology. 2011 thru 2015 (Current equipment: 2010 - 4 AEDs I 2010 ERP had 2 AEDs schedule for replacement at $6,000. Four were purchased. Justification With changes in technology, the AED's should be replaced every four years. Cost - $3,000 per unit ante from 20 year plan - adjustment from 3 years to 4 years. nate salvage/resale value on replaced item: $ Prior Expenditures 6,000 Equipment Total 2011 2012 2013 2014 2015 7,200 Total 7,200 Total Future 7,200 35,900 7,200 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 000 Equipment Replacement Fund 7,200 7,200 35,900 Total Total 7,200 7,200 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0122 Project Name Workout Equipment - Dumb Bells Type Equipment Useful Life 10 years Category Equipment Future Department Fire Contact Fire Chief Priority n/a Description I Total Project Cost: $11,700 ]Vorkout equipment used in Fire Department workout room. 2011 thru 2015 Justification ,urrent dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead based plaint. This purchase vould update our dumb bells to the current type fitness bells. Variance from 20 year plan - Estimate salvage/resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 5,000 5,000 6,700 Total 5,000 5,000 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund 5,000 5,000 6,700 Tom 5,000 5,000 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0200 Project Name Marked Patrol Vehicles (6) Type Equipment Useful Life 3 years Category Vehicles Future Department Police Contact Police Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $2,374,300 Marked 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. ,urrent vehicles: (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria, (2) 2008 Ford Crown Victorias, (1) 2007 Ford Crown Victoria Justification ;et up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for online and emergency operations. Vehicles contain secure seating for prisoner transport. Variance from 20 year plan - Original replacement schedule was modified several years ago during the LGA cuts. The proposed purchase schedule is to realign the replacement of squads more evenly. Estimate salvaee/resale value on replaced item: $4,000 each Prior Expenditures 570,500 Vehicles Total 2011 2012 2013 2014 2015 Total Future 67,200 69,200 71,200 73,400 75,600 356,600 1,447,200 Tom 67,200 69,200 71,200 73,400 75,600 356,600 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 570,500 Equipment Replacement Fund 67,200 69,200 71,200 73,400 75,600 356,600 1,447,200 Total Total 67,200 69,200 71,200 73,400 75,600 356,600 Total Wednesday, June 30, 2010 Ell EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0201 Project Name Sergeant's Vehicle Type Equipment Useful Life 4 years Category Vehicles Future Department Police Contact Police Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $215,700 Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. I year rotation. ,urrent vehicle: 2007 Ford Crown Victoria Justification ;et up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for outine and emergency operations. Vehicles contain secure seating for prisoner transport. ariance from 20 year plan - move purchase of sergeant's squad back to 2011. Purchased new in 2007. stimate salvage/resale value on replaced item: $3,500 each Expenditures 2011 2012 2013 2014 2015 Vehicles Total 33,600 33,600 37,800 37,800 Total Future 71,400 144,300 71,400 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund 33,600 37,800 71,400 144,300 Tom 33,600 37,800 71,400 Total Wednesday, June 30, 2010 Cy EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0203 Project Name Utility 4x4 (unit 212) Type Equipment Useful Life 6 years Category Vehicles Future Description I wheel drive uitlity vehicle. vehicle: 2008 Chevrolet Tahoe Department Police Contact Police Chief Priority n/a Total Project Cost: $247,600 2011 thru 2015 Justification iehicle is normally used by public service officers for a wide variety of uses such as transporting animals and equipment. The 4 wheel drive ,ehicle is also used at times as a patrol vehicle, particularly in the winter in extreme snow conditions. ance from 20 year plan - can move replacement back one year to 2009 - new engine. nate salvage/resale value on replaced item: $5,000 Prior Expenditures 67,400 Vehicles Total 2011 2012 2013 2014 2015 47,700 `);'per 47,700 Total Future 47,700 132,500 47,700 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 67,400 Equipment Replacement Fund 47,700 47,700 132,500 Total Total 47,700 47,700 Total Wednesday, June 30, 2010 43 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0204 Project Name Police Administrative Vehicles (2) Type Equipment Useful Life 2 years Category Vehicles Future Department Police Contact Police Chief Priority n/a Description I Total Project Cost: $962,900 'olice administrative and detective vehicles. teplace Chief s vehicle - even numbered years Zeplace Captain's vehicle - odd numbered years 2011 thru 2015 Current vehicles: 2009 Chevrolet Impala, 2008 Ford Taurus Justification Unmarked vehicles, equipped with radios, siren and red grille lites used by chief and captain. Staff use is for two years. Vehicles are then rotated down to detectives and are kept for an additional 3-4 years. Vehicles are also used for surveillance by uniform and plain clothes officers. Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $4,000 each Prior Expenditures 2011 2012 2013 2014 2015 Total Future 212,400 Vehicles 27,900 28,800 29,600 30,500 31,400 148,200 602,300 Total Total 27,900 28,800 29,600 30,500 31,400 148,200 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 212,400 Equipment Replacement Fund 27,900 28,800 29,600 30,500 31,400 148,200 602,300 Total Total 27,900 28,800 29,600 30,500 31,400 148,200 Total Wednesday, June 30, 2010 44 EQUIPMENT REPLACEMENT 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 Priority n/a 2011 thru 2015 Description Total Project Cost: $56,300 ,urrent vehicle was leased to Police Department. Used by Police Services Liaison for transport to schools, neighborhood meetings, training and mblic relations events. Current vehicle: 2001 Chrysler PT Cruiser Justification 2001 PT Cruiser was leased to the Police Department for a nominal fee and detailing and wheels were also donated. The City purchased the vehicle from the leasor in 2005. ance from 20 year plan - extended life from 10 to 15 years nate salvage/resale value on replaced item: $1,000 Expenditures 2011 2012 2013 2014 Vehicles Total Funding Sources 2011 2012 2013 2014 Equipment Replacement Fund Total t6 2015 Total Future 22,000 22,000 34,300 22,000 22,000 Total 2015 Total Future 22,000 22,000 34,300 22,000 22,000 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0209 Project Name Copy Machine Type Equipment Useful Life 5 years Category Equipment Future Department Police Contact Police Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $127,200 'olice Department copy machine capable of producing double side copies and collating pages. Current equipment: 2006 Ricoh 2051SP Justification Used to make duplicate copies of reports, letters, memos, etc., generated by police personnel. Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 30,700 Equipment 19,100 19,100 77,400 Total Total 19,100 19,100 Total Prior Funding Sources 30,700 Equipment Replacement Fund Total Total 2011 2012 2013 2014 2015 19,100 19,100 CI: Total Future 19,100 77,400 19,100 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0210 Project Name Logging Recorder Type Equipment Useful Life 7 years Category Equipment Future Department Police Contact Police Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $138,100 Che police logging recorder is a device which records all telephone and radio transmissions produced/received by the Police Department. Current equipment: 2005 Mercom logging recorder system 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. Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 36,900 36,900 101,200 Tom 36,900 36,900 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund 36,900 36,900 101,200 Tom 36,900 36,900 Total Wednesday, June 30, 2010 47 EQUIPMENT REPLACEMENT FLAN 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 Chief/IT Priority n/a Total Project Cost: $238,000 2011 thru 2015 puter servers store information and system programs. server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01 -ERP -213) Justification annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used br data storage. ante from 20 year plan - Cost stabilized at $8,500 per year. nate salvage/resale value on replaced item - $ Prior Expenditures 68,000 Equipment Total 2011 2012 2013 2014 2015 Total Future 8,500 8,500 8,500 8,500 8,500 42,500 127,500 Tom 8,500 8,500 8,500 8,500 8,500 42,500 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 68,000 Equipment Replacement Fund 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 Wednesday, June 30, 2010 48 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0212 Project Name Mobile Data Computers Type Equipment Useful Life 5 years Category Equipment Future Department Police Contact Police Chief Priority n/a 2011 thru 2015 Description I 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 o car. Justification ,imited life of 5 years - replacement necessary. ance from 20 year plan - Increase cost from $54,500 to $62,700 ($5,700 x 11) to better reflect actual cost of MDC/docking station. nate salvage/resale value on replaced item: $-0- Prior Expenditures 47,000 Equipment Total 2011 2012 2013 2014 2015 Total Future 62,700 62,700 188,100 Total 62,700 62,700 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 47,000 Equipment Replacement Fund 62,700 62,700 188,100 Total Tom 62,700 62,700 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 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 2011 thru 2015 Description I Total Project Cost: $213,000 )igital 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 'olice Dept. currently has eight digital camera units installed and a dedicated server. The life expectancy of the cameras is about five years. :urrent cameras were installed in September 2006. ,ost 8 cameras @ $5,000 per unit plus tax - $42,600 1 server @ $15,000 (to be purchased from Police Network Server (O1 -ERP -211) annual allocation that carries forward. ,-stimated cost $57,600. Cost could be lower if, at the time of replacement, a suitable product is available through a State or County equipment Budget Impact/Other Variance from 20 year plan - Purchase of squad cameras scheduled in 2011moved to 2009 due to continued equipment failure. Replacement schedule life is 5 years. Estimate salvage/resale value on replaced item: $ Prior Expenditures 2011 2012 2013 2014 2015 Total Future 42,600 Equipment 42,600 42,600 127,800 Total Total 42,600 42,600 Total Prior Funding Sources 42,600 Equipment Replacement Fund Total Total 2011 2012 2013 2014 2015 42,600 42,600 6% Total Future 42,600 127,800 42,600 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0214 Project Name Tactical Ballistic Vests Type Equipment Useful Life 5 years Category Equipment Future Department Police Contact Police Chief Priority n/a 2011 thru 2015 Description I Total Project Cost: $137,500 Cactical ballistic vests worn by members of the Hopkins Police Department High-risk Entry and Assault Team (HEAT). These vests offer a higher evel of protection against weapon assault than the regular duty ballistic vest. Justification ederal and State grant monies have been available through the Ballistic Vest Program over the past several years. These grants only pay a portion ,f the total cost of the vest, leaving the Police Department to pay the balance. There is no guarantee that these grants will be available in the future Varranty on the current vests expires in 2007. :ost 9 vests x $2,133 = $19,197 (today's cost). Does not include any applicable taxes. ance from 20 year plan - new item. Note: regular bullet proof vests funded by federal/state grants nate salvage/resale value on replaced item: $ Prior Expenditures 2011 2012 2013 2014 2015 Total Future 20,000 Equipment 23,200 23,200 94,300 Total Total 23,200 23,200 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 20,000 Equipment Replacement Fund 23,200 23,200 94,300 Total Total 23,200 23,200 Total Wednesday, June 30, 2010 611 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0215 Project Name Radios - Portable and Mobile Devices Type Equipment Department Police Useful Life Contact Police Chief Category Equipment Priority n/a Future Description I Total Project Cost: $285,000 2011 thru 2015 Portable and mobile radios used by the police, fire and public works departments to allow these departments to communicate on one frequency. Police and fire use their radios on a daily/regular basis. The public works only uses theirs in the event of an emergency. Estimated Replacement Cost (based on 2009 cost) Portable - $2,300 Mobile - $3,000 Police Fire PW Total Portable 65 32 10 107 Mobile 17 8 0 25 Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency ance from 20 year plan - added replacement cost at $15,000 per year fixed, starting in 2012. Do not expect all 132 radios to need replacing at time. nate salvage/resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 15,000 15,000 15,000 15,000 60,000 225,000 Total 15,000 15,000 15,000 15,000 60,000 Total Funding Sources 2011 2012 2013 2014 2015 Equipment Replacement Fund Total 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 6YA Total Future 60,000 225,000 60,000 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0300 Project Name 4x4 3/4 Ton Pickup with Plow 2011 thru 2015 Type Equipment Department Public Works: Streets/Traffic UsefulLife 10 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $103,800 'ickup used by various divisions of Public Works. vehicle: 1997 Chevrolet 3/4 Ton 4X4 Justification ,fight hauling and transportation for supervisors. Maintenance garage service vehicle. ance from 20 year plan - Increase expenditure to reflect actual cost. Change from 1/2 ton pickup to 3/4 ton 4x4 pickup. nate salvage/resale value on replaced item: $1,500 Prior Expenditures 25,000 Vehicles Total 2011 2012 2013 2014 2015 33,600 Tom 33,600 Total Future 33,600 45,200 33,600 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 25,000 Equipment Replacement Fund 33,600 33,600 45,200 Total Total 33,600 33,600 Total Wednesday, June 30, 2010 53 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0301 Project Name 4X4 3/4 Ton Truck with Plow 2011 thrit 2015 Type Equipment Department Public Works: StreetsTraffic Useful Life 8 rears Contact Public Works Director Category Vehicles Priority n Future Description I Total Project Cost: $111,700 ;i4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers. Current vehicle: 2006 Ford F250 Justification Light hauling. pulling trailers, transportation to and from job sites. Variance from 20 year plan - none Estimate salvage;' resale value on replaced item: $I J00 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 24,000 Vehicles 30,400 30,400 87,300 Total Total 30,400 30,400 Total Prior Funding Sources 24,000 Equipment Replacement Fund Total Total 2011 2012 2013 2014 54 30,400 30,400 2015 Total Future 30,400 87,300 30,400 Total If'ednesdav, hire 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0303 Project Name 1 Ton Dump Truck (2) 2011 thri, 2015 Type Equipment Department Public Works: StreetsTraffic Useful Life 12 rears Contact Public Works Director Category Vehicles Prioiitp n Future Description I Total Project Cost: $205,500 Cruck is used in the Street Division of Public Works. Current vehicles: 1997 Ford F350 & 2000 Ford F450 Justification Vehicle used by various departments for street and park maintenance and light hauling Variance from 20 year plan - move back from 2009 to 2010. Estimate salvage; resale value on replaced item: $3,500 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 67,900 Vehicles 34,700 34,700 102,900 Total Total 34,700 34,700 Total Prior Funding Sources 67,900 Equipment Replacement Fund Total Total 2011 2012 2013 2014 34,700 34,700 610 2015 Total Future 34,700 102,900 34,700 Total If'ednesdav, Ane 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0304 Project Name 1 Ton Traffic Boom Truck 2011 thri, 2015 Type Equipment Department Public Works: StreetsTraffic Useful Life 17 rears Contact Public Works Director Category Vehicles Priority n Future Description I Total Project Cost: $199,000 3oom truck used in Street and Traffic Divisions of Public Works. Current vehicle: 1995 Chevrolet 1 Ton Boom Truck � Justification Vehicle used by Traffic Department for signal and light pole maintenance. arianee from 20 year plan - None >timate salvage ;'resale value on replaced item: $8.000 Expenditures 2011 2012 2013 2014 2015 Total Future Vehicles 75,000 75,000 124,000 Tom 75,000 75,000 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund Total 75,000 75,000 124,000 75,000 75,000 Total 6'S If'ednesdav, Ane 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 'roject # 01 -ERP -0306 'roject Name Tandem Dump Trucks (2) 2011 thru 2015 Type Equipment Department Public Works: Streets/Traffic Useful Life 17 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $576,100 ) unp trucks used in Streets Division of Public Works. Current vehicles: 1996 Ford L-8000 & 1998 Ford LT8500 Justification Trucks used for heavy hauling, snow plowing and sanding. iance from 20 year plan - Move 2013 to2011 - budget $22,000 to refurb 98 Ford Tandem with new style box and drop sander and pre -wetting option - extend life to 2018. Move 2015 purchase to 2013 due to conditions of truck. mate salvage/resale value on replaced item: $-0- Expenditures -0-Expenditu es 2011 2012 2013 2014 2015 Total Future Vehicles Funding Sources 22,000 142,400 164,400 411,700 Tom 22,000 142,400 164,400 Total Equipment Replacement Fund Total 2011 2012 2013 2014 2015 22,000 142,400 22,000 142,400 57 Total Future 164,400 411,700 164,400 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0308 Project Name Front End Loaders (2) 2011 thri, 2015 Type Equipment Department Public Works: StreetsTraffic Useful Life 15-18 rears Contact Public Works Director Category Equipment Prioiitp n Future Description I Total Project Cost: $848,600 ICurfent equipment: 1991 Caterpillar 928E Loader & 2005 Caterpillar 938G Justification Variance from 20 year plan - None Estimate salvaae;'resale value on replaced item: $ Prior Expenditures 2011 2012 2013 2014 2015 Total Future 140,000 Equipment 172,000 172,000 536,600 Total Total 172,000 172,000 Total Prior Funding Sources 140,000 Equipment Replacement Fund Total Total 2011 2012 2013 2014 2015 Total Future 172,000 172,000 536,600 172,000 172,000 Total 58 IT'ednesdav, Ane 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0309 Project Name Skid Loader (2) 2011 thrit 2015 Type Equipment Department Public Works: StreetsTraffic Useful Life 12 rears Contact Public Works Director Category Equipment Prioiitp n Future Description I Total Project Cost: $187,600 .oadin, trucks, landscape Work, snow removal_ material handling. 1998 John Deere 8875 Skid Loader & 2004 Bobcat S-18518 Skid Loader Justification Variance from 20 year plan - move back from 2010 to 2011. Estimate salvaue;'resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 36,000 36,000 151,600 Total 36,000 36,000 Total Funding Sources 2011 2012 2013 2014 Equipment Replacement Fund 36,000 Total 36,000 2015 Total Future 36,000 151,600 36,000 Total IT'ednesdav, Ane 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0311 Project Name Sweeper 2011 thru 2015 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: $494,700 itreet sweeper used by Streets Division for sweeping streets and parking lots. Current equipment: 2001 Elgin 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 2011 2012 2013 2014 2015 Total Future 115,300 Equipment 156,400 156,400 223,000 Total Tom 156,400 156,400 Total Prior Funding Sources 115,300 Equipment Replacement Fund Total Total 2011 2012 2013 201.1 [4t 156,400 156,400 2015 Total Future 156,400 223,000 156,400 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0312 Project Name Roller 2011 thru 2015 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 Jsed by Street Department for asphalt repair and resurfacing. Current equipment: 1989 Ingersoll Rand Roller Justification ance from 20 year plan - None nate salvage/resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Equipment 45,900 45,900 Total 45,900 45,900 Funding Sources 2011 2012 2013 2014 2015 Total Equipment Replacement Fund 45,900 45,900 Total 45,900 45,900 Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0314 Project Name Asphalt Paver 2011 thru 2015 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: $48,800 asphalt paver used by Streets Division of Public Works. ,urrent equipment: 1994 Cate Justification 'aving streets and parking lots. AD200B Paver ance from 20 year plan - none nate salvage/resale value on replaced item: $500 Expenditures 2011 2012 2013 2014 2015 Total Equipment 48,800 48,800 Total 48,800 48,800 Funding Sources 2011 2012 2013 2014 2015 Total Equipment Replacement Fund 48,800 48,800 Total 48,800 48,800 Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0317 Project Name Sign Machine (Traffic) 2011 thru 2015 Type Equipment Department Public Works: Streets/Traffic UsefulLife 10 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $31,500 Jahcine used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city use. Current equipment: 2005 Signcad Sign Making System Justification Existing machine is not repairable and needs updating/ Variance from 20 year plan - new Estimate salvage/resale value on replaced item: $-0- Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 13,400 13,400 18,100 Tom 13,400 13,400 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund 13,400 13,400 18,100 Total 13,400 13,400 Total Wednesday, June 30, 2010 63 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0400 Project Name 4x4 3/4 Ton Truck Type Equipment Useful Life 8 years Category Vehicles Future Department HRA Contact Unassigned Priority n/a 2011 thru 2015 Description I Total Project Cost: $96,300 I wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snow plow. vehicle: 2007 Chevrolet Justification for Public Housing Superintendent and snow plowing at various HRA properties around the city. ariance from 20 year plan - none stimate salvage/resale value on replaced item: $1,800 Prior Expenditures 22,800 Vehicles Total 2011 2012 2013 2014 2015 32,400 Tom 32,400 Total Future 32,400 41,100 32,400 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 22,800 HRA - Housing and Redevelop 32,400 32,400 41,100 Total Total 32,400 32,400 Total Wednesday, June 30, 2010 64 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0401 Project Name Copier Type Equipment Useful Life 8 years Category Equipment Future 2011 thru 2015 Department HRA Contact Finance Director Priority n/a Description Total Project Cost: $50,400 ,olor copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks. Current equipment: Imagistics 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. Variance from 20 year plan - New item. Estimate salvage/resale value on replace item: S - 0 - Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 13,000 13,000 37,400 Tom 13,000 13,000 Total Funding Sources 2011 2012 2013 2014 2015 Total Future HRA - Housing and Redevelop 13,000 13,000 37,400 Total 13,000 13,000 Total Wednesday, June 30, 2010 Ai EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0502 Project Name Backhoe Loader 2011 thru 2015 Type Equipment Department 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. Current equipment: 1993 Caterpillar Backhoe 446 Justification ariance from 20 year plan - none stimate salvage/resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Equipment 134,800 134,800 Total 134,800 134,800 Funding Sources 2011 2012 2013 2014 2015 Total WF - Water Fund 134,800 134,800 Tom 134,800 134,800 Wednesday, June 30, 2010 C:3. EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0506 Project Name Public Works Copy Machine 2011 thri, 2015 Type Equipment Department Water Useful Life 5 vears Contact Public Works Director Category Equipment Prioiitp n Future Description Total Project Cost: $91,700 .opv machine to service needs of all division of Public Works. Current equipment: 2005 Ricoh Aficio 2238C Justification Making copies for various departments. Variance from 20 year plan - none Estimate salvage;"resale value on replaced item: $800 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 22,800 Equipment 14,200 14,200 57,700 Total Total 14,200 14,200 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 22,800 WF - Water Fund 14,200 14,200 57,700 Total Total 14,200 14,200 Total If'ednesdav, hire 30, 2010 67 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0550 Project Name 4x4 3/4 Ton Truck 2011 thrit 2015 Type Equipment Department Sewer Useful Life 10 rears Contact Public Works Director Category Vehicles Priority n Future Description I Total Project Cost: $110,300 Cruck used by Water Sewer Division of Public Works. Current vehicle: 2001 Chevrolet Pickup Justification Snow plowing. light hauling, pulling trailers, general purpose transportation. Variance from 20 year plan - none Estimate salvaue;'resale value on replaced item: S Prior Expenditures 2011 2012 2013 2014 2015 Total Future 26,600 Vehicles 35,700 35,700 48,000 Total Total 35,700 35,700 Total Prior Funding Sources 26,600 SF - Sanitary Sewer Fund Total Total 2011 2012 2013 2014 68 35,700 35,700 2015 Total Future 35,700 48,000 35,700 Total If'ednesdav, hire 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN 'roject # 01 -ERP -0700 'roject Name Engineering Van 2011 thru 2015 Type Equipment Department Public Works: Engineering UsefulLife 10 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $66,400 ran used by Engineering Department for survey equipment and on job site work. Current vehicle: 2000 Chevrolet Suburban Justification Transportation to and from job site, hauling of surveying and traffic counting equipment. Variance from 20 year plan - increase amount from 14,300 to 16,000 to reflect actual cost. Purchase used Suburban from Hennepin Co. 2002 auction -price is $13,000 to $14,000 + $2,000 for equipment. Estimate salvage/resale value on replaced item: $2,500 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 16,000 Vehicles 21,500 21,500 28,900 Total Total 21,500 21,500 Total Prior Funding Sources 16,000 Equipment Replacement Fund Total Total 2011 2012 2013 2014 2015 21,500 21,500 [X Total Future 21,500 28,900 21,500 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0800 Project Name 1/2 Ton Pickup Truck 2011 thri, 2015 Type Equipment Department Public Works: ParksForestrN Useful Life 10 rears Contact Public Works Director Category Vehicles Prioiitp n Future Description I Total Project Cost: $61,800 'ickup used by Park Division of Public Works. .urrent vehicle: 2001 Ford Justification ariance from 20 year plan - move back from 2011 to 2012 >timate salvaue;'resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Future Vehicles 26,400 26,400 35,400 Tom 26,400 26,400 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund Total 26,400 26,400 35,400 26,400 26,400 Total rig If'ednesdav, Ane 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0801 Project Name 4x4 3/4Ton Trucks (2) 2011 thri, 2015 Type Equipment Department Public Works: Parris ForestrN Useful Life 8 rears Contact Public Works Director Category Vehicles Priority n Future Description I Total Project Cost: $313,800 Crucks used by Parks Division of Public Works. Current vehicles: 2004 Ford F350 4X4 & 2004 Ford F350 4X4 Justification Snow plowing. hauling, transportation. Units are heavily used. Variance from 20 year plan - none Estimate salvaae;'resale value on replaced item: $ Prior Expenditures 2011 2012 2013 2014 2015 Total Future 53,200 Vehicles 67,400 67,400 193,200 Total Total 67,400 67,400 Total Prior Funding Sources 53,200 Equipment Replacement Fund Total Total 2011 2012 2013 2014 67,400 67,400 r`I 2015 Total Future 67,400 193,200 67,400 Total If'ednesdav, Ane 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0802 Project Name 3/4 Ton Utility Truck 2011 thru 2015 Type Equipment Department Public Works: Parks/Forestry Useful Life 14 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $80,900 I/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city. ,urrent vehicle: 1998 Dodge Ram 3500 Justification ariance from 20 year plan - move back from 2011 to 2012. Change life from 10 to 14 years. stimate salvage/resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Vehicles Total 32,200 32,200 Total Future 32,200 48,700 32,200 Total Funding Sources 2011 2012 2013 2014 2015 Total Future Equipment Replacement Fund 32,200 32,200 48,700 Tom 32,200 32,200 Total Wednesday, June 30, 2010 MAI EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0807 Project Name Trucksters (3) 2011 thru 2015 Type Equipment Department Public Works: Parks/Forestry Useful Life 15 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $114,700 Cruckster used by Parks Division of Public Works for balltield and parks maintenance. Current equipment: 1996 Toro Workman, 2004 Toro Workman 3200, 2004 Toro Workman 2110 Justification Park maintenance. ballfield grooming and 'weed spraying. Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $1,400 each Prior Expenditures 2011 2012 2013 2014 2015 Total Future 29,900 Equipment 19,800 19,800 65,000 Total Total 19,800 19,800 Total Prior Funding Sources 29,900 Equipment Replacement Fund Total Total 2011 2012 2013 2014 19,800 19,800 73 2015 Total Future 19,800 65,000 19,800 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project 4 01 -ERP -0808 Project Name Riding Mowers (3) 2011 thru 2015 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 tiding mowers used by Parks Divison of Public Works. One mower also used for sidewalk snow removal during winter months. 1996 Toro Groundmaster 345, 2004 Toro Zero Turn, 2006 Jacobson Rotary Mower Justification vlowing city parks and right of ways and sidewalk snow removal. Variance from 20 year plan - move from 201 Ito 2013 . Estimate salvage/resale value on replaced item: $600 each Prior Expenditures 2011 2012 2013 2014 2015 Total Future 49,000 Equipment 10,300 22,800 20,300 53,400 153,300 Total Tom 10,300 22,800 20,300 53,400 Total Prior Funding Sources 2011 2012 2013 2014 2015 Total Future 49,000 Equipment Replacement Fund 10,300 22,800 20,300 53,400 153,300 Total Total 10,300 22,800 20,300 53,400 Total Wednesday, June 30, 2010 74 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0813 Project Name Brush Chipper 2011 thru 2015 Type Equipment Department Public Works: Parks/Forestry Useful Life 20 years Contact Public Works Director Category Equipment Priority n/a Future Description I Total Project Cost: $25,700 3rush chipper used for Forestry and brush pick up operations of Public Works. Current equipment: 1993 Brush Bandit Chipper 250 Justification ance from 20 year plan - change to usable life to 20 years - move back from 2009 to 2013. nate salvage/resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Equipment 25,700 25,700 Total 25,700 25,700 Funding Sources 2011 2012 2013 2014 2015 Total Equipment Replacement Fund 25,700 25,700 Total 25,700 25,700 Wednesday, June 30, 2010 rV EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0900 Project Name Refuse Truck (RAP -R) (2) 2011 thru 2015 Type Equipment Department Refuse UsefulLife 10 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $1,059,300 tefuse truck used by Refuse Utility Division of Public Works. lCurent vehicle: 2005 Peterbilt Rapid Rail & 2000 Volvo Rapid Rail Justification Residential waste pick up. Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Prior Expenditures 2011 2012 2013 2014 2015 Total Future 332,000 Vehicles 204,800 204,800 522,500 Total Total 204,800 204,800 Total Prior Funding Sources 332,000 RF - Refuse Fund Total 2011 2012 2013 2014 2015 Total Future 204,800 204,800 522,500 Total 204,800 204,800 Total rc.: Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT FLAN City of Hopkins, MN Project # 01 -ERP -0901 Project Name Refuse Truck (Rear -L) 2011 thru 2015 Type Equipment Department Refuse UsefulLife 10 years Contact Public Works Director Category Vehicles Priority n/a Future Description I Total Project Cost: $238,200 tefuse truck used by Refuse Utility Division of Public Works. ,urrent vehicle: 1996 Fre Justification Zesidential waste pick up. FL70 Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $9,000 Expenditures 2011 2012 2013 2014 2015 Total Future Vehicles 101,600 101,600 136,600 Tom 101,600 101,600 Total Funding Sources 2011 2012 2013 2014 2015 Total Future RF - Refuse Fund 101,600 101,600 136,600 Tom 101,600 101,600 Total Wednesday, June 30, 2010 77 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 'roject # 01 -ERP -1000 'roject Name Ice Resurfacer 2011 thru 2015 Type Equipment Department Pavilion Useful Life 12 years Contact Facilities Director Category Equipment Priority n/a Future Description I Total Project Cost: $496,600 ce resurfacer used by the Pavilion for ice sheet maintenance. 2003 Olvmpia Ice Resurfacer Justification Zeplace existing propane fueled ice resurfacer with a electric driven ice resurfacer. Due to changes in the states statues for indoor air quality for ice arenas replacement with a propane fueled model would warrant the purchase and installation of state approved air quality monitoring equipment. additional costs that would accompany the monitoring equipment would be annual testing and recalibration fees. State statues also require annual icensing and lower emission standards 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 used in place of propane ice ance from 20 year plan - Value increased to reflect actual replacement cost. nate salvage/resale value on replaced item: $20,000 Prior Expenditures 60,000 Equipment Total Prior Funding Sources 60,000 PA - Pavilion Fund Total 2011 2012 2013 2014 2015 180,000 Tom 180,000 Total Future 180,000 256,600 180,000 Total 2011 2012 2013 2014 2015 Total Future 180,000 180,000 256,600 Total 180,000 180,000 Total 78 Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -1001 Project Name Electric Ice Edger 2011 thru 2015 Type Equipment Department Pavilion UsefulLife 10 years Contact Facilities Director Category Equipment Priority n/a Future Description Total Project Cost: $11,700 ?lectric 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 hat the ice resurface cannot reach. Justification or 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 from 20 year plan - New item. salvage/resale value on replaced item: $ Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 5,000 5,000 6,700 Tom 5,000 5,000 Total Funding Sources 2011 2012 2013 2014 2015 Total Future PA - Pavilion Fund 5,000 5,000 6,700 Tom 5,000 5,000 Total Wednesday, June 30, 2010 ra EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -1100 Project Name Art Center Copy Machine 2011 thru 2015 Type Equipment Department Arts Center Useful Life 7 years Contact Facilities Director Category Equipment Priority n/a Future Description Total Project Cost: $53,800 ,opy machine capable of printing in color as well as performing the functions of enlarging, duplexing, collating, stapling copies as well as ,canning, faxing and acting as a network printer. ,urrent equipment: Aficio A1035 Justification Che Art Center staff does a large volume of copying/printing for event programs, reception materials, mailing, as well as regular office duplication ,f reports, signs, records, etc. A multi -functional networked copier will allow the center to eliminate a printer/copier/fax machine and a color )rinter. The printer/copier/fax machine works very slowly as a networked machine and the color printer is using a lot of replacements parts due to is heavy work load. The multi -functional network copier will save the center repair dollars, will be more efficient saving staff time, and is more inorooriate for the level of usage than usinz multiple machines. Variance from 20 year plan - Estimate salvage/resale value on replaced item: $ Prior Expenditures 2011 2012 2013 2014 2015 Total Future 8,500 Equipment 12,100 12,100 33,200 Total Total 12,100 12,100 Total Prior Funding Sources 8,500 AC - Arts Center Fund Total Total 2011 2012 2013 2014 2015 12,100 12,100 80 Total Future 12,100 33,200 12,100 Total Wednesday, June 30, 2010 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -1101 Project Name Art Center Carpet Extractor 2011 thru 2015 Type Equipment Department Arts Center UsefulLife 10 years Contact Facilities Director Category Equipment Priority n/a Future Description I Total Project Cost: $7,700 Che 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 )etween annual contractual cleanings, to remove spots and stains, and to pick up spills. Justification Che current equipment is over 12 years old and very corroded from the dirt, water and cleaning chemicals. With regular touch up cleaning and emoval of stains in the Arts Center carpet with this extractor, the need to pay contractual cleaners to deep clean the carpet is reduced to once or wice annually. fiance from 20 year plan - New item. mate salvage/resale value on replace item: $ Expenditures 2011 2012 2013 2014 2015 Total Future Equipment 3,300 3,300 4,400 Tom 3,300 3,300 Total Funding Sources 2011 2012 2013 2014 2015 Total Future AC - Arts Center Fund 3,300 3,300 4,400 Total 3,300 3,300 Total Wednesday, June 30, 2010 81 20 Year Replacement Schedule 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o cv cv 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o co 0 o co 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 co o co a � o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a co o co cv � co � m o 0 0 0 0 0 0 0 0 0 0 00 N N co o co cv � co o � n a cv vi a 0 0 0 0 0 o a cv a� co o co cv � vi a � o m a 0 0 0 0 0 o a a co co co a 0 0 0 0 o N N 0 0 0 0 o a cv o 0 N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n iv iv z �0. F ❑~ v F m d � N '� .a � F F a F 0 0F �D G a a W' ' o W W W>>> W '" x w �° q ro cC p W U o d d z a o z U m w Is 2 w F 'w" x 2¢¢ 'w" a ¢ ¢ w o x F wFZ w 3 3 3 3 n 3 ro a.. .. 0 0 0 0a.. 0 0 0 0 .. 0 0 0 0 0 0 0 0 0 0 0 0 o a s a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a a x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x w w w w w www 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 oy oy 0 0 n n a m o N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 co cv o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 oy oy oy m � o N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 cv cv m cv m a ov co N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 co co a co 0 0 o ri co 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 cv cv � o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 oy oy oy m a o � a s a m m m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 co co a a a o o � a co co 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 cn a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o co cv vi � N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 oy oy N a o a o� co co cv o cv co 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 co co co a o m 0 m m m m a� iv 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m m a m m a o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 p o 1 v� 0.a a U U 9 � o ' ° 2 w O P. fx o^ :t ' 0 C 3 a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 . 0 . o 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 0.. 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 (`") 00 P. G C4 � 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 co co 0 0 0 o co co N N 0 0 0 0 0 � co" o co a m N 0 0 0 0 0 0 0 0 0 0 a � N 0 0 0 0 o; o; 0 0 0 0 co co N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ni o 0 0 0 0 0 0 0 0 0 0 oy oy � co co co ni o 0 0 0 0 0 0 0 0 0 0 0 0 ni ni ni ni 0 0 0 0 0 0 N a V 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ni o 0 0 0 0 0 0 0 0 0 0 0 0 o; ni ni ni a a cn co a o a 0 0 0 0 0 0 � a o cn � 0 0 0 0 0 0 0 0 co co 0 o co co N N a a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 cv co o cv � ov �v iv a cn a N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 �v cn � U o � o P -i o o F� B o 0 0 `i' ❑pa .� � a w m .. G G G�� a s �� w .7, . 7, 1- , F a �n o .. a m m a m m ov ov o .. a m a �n 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .� co co co co co co co co co co co co co co co co co co co co co 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 W W a� P. G C4 � co co 0 0 0 0 �n co �n o 0 o co �n 0 0 0 0 0 �n N N ik F W F 0." F F 3 a U .. 0. U F fx a ti C7 C7 F fx fx fx fx o . 0 0 a a W W 0 0 0 0 0 0 0 N W W W W W W W I o N P. P. P. P. P. P. W W W W W W W 0 0 0 0 0 0 O\ O\ o\ m m N W W W W W W 0 0 W W LO 00 0 0 0 0 0 0 O O O O 0 0 0 0 0 0 0 0 0 0 O O O 0 0 O O O 0 0 0 0 O O O O O O O O O O O� N O O O O vl N O O O O CO O O O O CO O� � O� h O O O O O O O O O O O O O O O O N b O O O O O O CO O� .• .• h N O O O O O O O O CO CO O O O O O O O O h O O O O O� CO O O O O O O CO CO � � .. O� W N O O O O O O O �O O O O O 00 O O h O O O lD O O O O O O O O O O O �O O O O O O O� O O O O O CO � O W O O O O Pm r O O O O O O O O O cn N O O O O .-i r O O O O O O lM O O O O O O O O O O O O O O O O O O O O Vl .� O O W O O O O O N O fx O O h O O 00 O O O fx O O O O O Vl O O O O O CO O O O O O O O N O O 00 QO h 0 t� �O h 0 0 h 0 0 O O .• �O O O O O O O r O O� CO h 0 O h 0 O h h h h O r O O� O h O h h 0 N h r O O O CO O O h O O� CO r O O h h O h O O� O r O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O h 0 O r O h O r M 0 0. 0 0 0 0 0 0 0 0 -a O � � IR W [n r � O M � vl � O O O O O O � O M O W O .4 F w F w o 0 4 w w a a z w w d F F z U z a z wa w d xw a dq a 2 � d U p F, F,dF�x,z dz w x F g zZ Zxw a o 0 ✓" j OO F z Qz z x w z x Q Qz a z Q w a z vF a z z z F F F x z F 3 xwaFz xw� go�zaa xwxwxw FF''F3xw w a s z z w z a w d a z ¢ 3 a w o w d w wz d d a a a a a a z z x F w w w w0 F x x w w a d W woo ¢ w F a w a w w w d> w o x U U W w w a w U 0 w w w W m w x�4 c7c7xd3v,xv,a F c7xdx c7z Ndc�c�wwaaamwav, 0 0 c7 c7 c7 xd3v,xv,a x Equipment and Building Inventory CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2010 UNIT 4 YEAR MAKE MODEL CURRENT REPLACEMENT COST FIRE DEPARTMENT 2008 FORD CROWN VICTORIA 100 2006 DODGE DURANGO 28,300 102. 1989 FORD L9000 TELE -SQUIRT $240,000 103. 2006 PETERBILT PUMPER 403,300 104. 1991 PETERBILT HEAVY RESCUE 190,000 105. 1998 FORD CROWN VICTORIA 22,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 120. 1995 CHEVROLET SUBURBAN IMPALA 121. 2005 FREIGHTLINER M2 TAURUS POLICE DEPARTMENT 200. 2010 FORD CROWN VICTORIA $30,000 201. 2008 FORD CROWN VICTORIA 28,100 202. 2008 FORD CROWN VICTORIA 28,100 203. 2009 FORD CROWN VICTORIA 28,160 204. 2007 FORD CROWN VICTORIA 29,000 206. 2007 FORD CROWN VICTORIA 29,000 207. 2010 FORD CROWN VICTORIA 30,000 208. 2007 FORD CROWN VICTORIA 29,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. 2005 CHEV IMPALA 20,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 87 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2010 CURRENT REPLACEMENT UNIT 4 YEAR MAKE MODEL COST STREET/TRAFFIC DIVISION 301. 1997 CHEV 302. 2006 FORD 304. 2000 FORD 305. 1997 FORD 307. 2006 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 1989 IN GERS O L/RAND 337. 1994 CATERPILLAR 342. 1991 TARGET 344. 1996 SNOGO 349. 1989 TRAIL -KING 350. 1993 TOWMASTER 351. 2004 TENNANT ENGINEERING DIVISION 700. 2000 CHEV 705. 2002 CHEV BUILDING & EQUIPMENT SERVICES 3/4 TON F250 F-450 1/2 TON F350-1 TON DUMP 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 SUBURBAN IMPALA $21,000 26,500 34,000 18,300 27,400 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 $14,500 $18,800 703. 2002 CHEV TAHOE $5,000 704. 2005 FORD F250 24,000 88 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2010 CURRENT REPLACEMENT UNIT 4 YEAR MAKE MODEL COST PARKS/FORESTRY DIVISION 800. 803. 804. 805. 810. 811. 812. 816. 817. 818. 819. 820. 821. 822. 824. 825. 826. 828. 832. 833. 834. 836. 840. 844. 845. 846. HRA 411 2001 2004 2004 1998 1993 2006 2010 1984 1982 1996 1987 2004 2004 2001 1996 2010 2004 2001 1997 2004 1993 1991 2010 1997 2001 FORD FORD FORD DODGE INTERNATIONAL INTERNATIONAL FREIGHTLINER FORD FORD TORO CUSHMAN TORO TORO TORO TORO TORO TORO DEW EZE VERMEER BOBCAT BRUSH BANDIT RYAN VICTORIAN FELLING REMACKEL DRESSEN 2007 CHEV 89 RANGER 4X4 F350 F350 RAM 3500 LP 4700 LP 4600 LOG TRUCK AERIAL LIFT TRACTOR 2910 TRACTOR 2610 TRUCKSTER 14AULSTER WORKMAN 3200 WORKMAN 2110 325-D MOWER GROUND MASTER 4100D MOWER Z587L ATM72 STUMP CTR 630A SKID LOADER CHIPPER 250 SOD CUTTER TRAILER TRAILER TRAILER 8110 2500 HD $18,000 23,000 23,000 24,000 50,000 45,000 130,000 22,000 22,000 13,000 5,000 15,000 7,900 18,000 16,000 53,000 8,900 21,000 15,400 22,000 14,000 2,000 2,000 4,000 5,000 2,000 $17,500 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2010 UNIT 4 YEAR MAKE MODEL CURRENT REPLACEMENT 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 540. 2008 LEROI AIR COMPRESSOR 12,000 542. 1994 WACKER TAMPER 4,000 REFUSE 901. 2005 PETERBILT 320 $162,000 902. 1999 VOLVO WX42 150,000 903. 1995 FREIGHTLINER FL -70 54,000 PAVILION 801. 1996 CHEV 4X4 TRK $19,100 809. 2003 OLYMPIA ICE RESURFACER 85,000 Olt Location/Descrmtion City Hall 1010 1st Street S. Police Station 1010 1st Street S. Fire Station 101 17th Avenue S. Hopkins Activity Center 33 14th Avenue S. Ice Arena/Pavilion 11000 Excelsior Boulevard Arts Center 1111 Mainstreet PW Admin/Garage 11100 Excelsior Boulevard Moline Reservoir 10421 Excelsor Boulevard Blake Tower Reservoir 151 Tyler Avenue S. Well 41 Filtration Plant 10421 Excelsior Boulevard Filtration Plant 1401 Elmo Park Service Road Well 44 Workshop/Storage 1401 Elmo Park Service Road Well #5 1205 Highway? Well #6 801 Highway 7 Lift Station 41 - 21 st 202 21 st Avenue N. CITY OF HOPKINS BUILDING INVENTORY June 2010 Oil Replacement Cost $3,370,837 3,801,157 4,091,653 1,324,718 4,404,998 5,439,674 6,217,636 1,613,617 806,810 208,424 1,391,782 283,492 114,299 114,299 107,574 Location/Descrmtion Replacement Cost Lift Station 42 - Drillane 100,852 619 Drillane Road Lift Station #3 - Lindee's 94,129 901 Cambridge Street N.E. Lift Station 44 - LTL Meadowbrook 147,915 244 Meadowbrook Road Lift Station 45 - Big Meadowbrook 221,872 6601 Excelsior Blvd. Lift Station #6 - Ronnie's 147,915 8546 Excelsior Avenue E. Lift Station 47 - Valley 195,146 801 6th Avenue S. Band Shell - Downtown Park 3 4, 13 8 16 9th Avenue S. Concession Stand - Maetzold Field 162,729 1215 1st Street N. Park Building -Beach - Lifeguards 192,984 5200 Shady Oak Road Park Building -Beach -Concessions 186,250 5200 Shady Oak Road Park Shelter - Office/Bathhouse 363,745 5200 Shady Oak Road Park Shelter - Burnes 49,090 201 Park Lane Park Building - Central 113,768 101 17th Avenue S. Park Building - Harley 20,170 108 Jackson Avenue S. Park Shelter - Interlachen 51,598 220 Homedale Avenue Park Building - Oakes 38,996 301 Tyler Avenue N. Park Building - Valley 46,401 800 7th Avenue S My Location/Description Replacement Cost Dow Towers (76 Units) HRA 22 5th Avenue S. 20th Avenue Townhouses (10 Units) HRA 29 20th Avenue S. Parking Ramp 4,409,208 10th Avenue and Mainstreet Depot Coffee House 469,400 9451 Excelsior Boulevard Overpass Skate Park 7,331 100 Washington Avenue 0:x1