Loading...
2010 - 2014 ERPEQUIPMENT REPLACEMENT PLAN City of Hopkins 2010 -2014 City of TIopkins 1010 First Street South • Hopkins, ML 55343 -7573 • Phone: 952 - 935 -8474 • 5at: 952-935-1834 Web address: www.hopkinsmn.com DATE: August 2009 TO: Honorable Mayor and Members of e C ;ty Council FROM: Rick Getschow, City Manager SUBJECT: 2010 -2014 EQUIPMENT REPLACEMENT PLAN With this letter, I respectfully submit the 2010 -2014 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 fmal 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 infoimation 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, Craig Reid, Chief of Police, 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 Quality of Life • Inspire • Educate • Involve • Communicate • EQUIPMENT REPLACEMENT PLAN 2010 -2014 TABLE OF CONTENTS INTRODUCTION Background and Summary of Changes from 2009 Plan Page 1 FIVE YEAR SUMMARIES Funding Summary 5 Department Summary 6 Projects by Department 7 Funding Source Summary 10 Projects by Funding Source 11 Projects & Funding Source by Department 13 EQUIPMENT REQUESTS Request Details by Individual Equipment 17 TWENTY YEAR REPLACEMENT SCHEDULE Twenty Year Schedule by Department 75 EQUIPMENT AND BUILDING INVENTORY • Vehicle /Equipment Inventory 80 Building Inventory 84 Introduction EQUIPMENT REPLACEMENT PLAN 2010 - 2014 BACKGROUND AND SUMMARY OF CHANGES FROM 2009 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 $639,500. The cash flow requirements to fund equipment needs in the equipment replacement fund, will experience a roller coaster effect over the next 20 years given the projected equipment needs and 3% inflation rate. After reducing the intragovernnental charges by 50% in 2003 in response to the LGA cuts, charges were increased 2% in 2004 and 9% in 2006 but have not increased since resulting in a steady decline in the working capital of the fund. Intragovernnental charges are at 55% of what they were in 2002 and at the current rate structure will not return to that level until 2023. Unfortunately our equipment needs are not changing. The plan as presented proposes a 2% increase in charges for 2010 and 2011, a 3% increase in 2012 and 2013 and a 5% increase in 2014. 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 2009 Plan Highlights of changes from last year's equipment replacement plan for the years 2010 -2014: City Hall: The telephone system was originally scheduled for replacement in 2011 at a cost of $89,600, however, due to promotional pricing and a manufacturer rebate we can upgrade the controller at a cost of under $6,800 and postpone the replacement until 2015. The upgrade was done in 2009. 1 Due to volunteer staffing and the amount of scanning that needs to be done a third scanning station was added to the ERP. We currently have two large document scanners (scanners that take paper up to 11x17) and one small scanner We are proposing to replace the small scanner with a large document scanner in 2010 so that we have three large scanners. The cost to replace the small copier scheduled for replacement in 2011 was reduced by $6,900 to $20,000 as costs of copiers have come down. An aerial ladder truck was purchased in 2008 with a combination of cash and a capital lease. The capital lease payments were added to the ERP for the years 2010 -2018 at $54,217 per year. Fitness Center — the dumb bells and stand scheduled for replacement in 2009 have been postponed until 2012. The treadmill originally scheduled for 2011 has been postponed to 2012 and the weightlifting equipment scheduled for 2011 has been postponed to 2015. All fitness equipment is reviewed annually and the replacement schedule adjusted accordingly. The six police patrol cars replacement schedule has been re- evaluated and the replacement of the patrol cars spread out evenly over their life cycle. Due to the 2003 budget challenges the replacement of several patrol cars was extended and the replacement schedule for these vehicles was thrown off schedule. The status of the cars was evaluated along with the replacement schedule. The current plan includes replacing two patrol cars each year on a three -year cycle. The police computer system budgeted at $700,000 in previous ERP's was reduced to $500,000 in 2008 to better fit within the overall ERP plan. In 2009 it was again reduced and funded over a two year period at $200,000 per year in 2013 and 2014. This ERP item was again evaluated and it has been determined that the existing system may not need replacing but rather an upgrade. The upgrade has been scheduled for 2017 at a cost of $200,000. Digital squad car cameras purchased in 2006 with police department funds have a life expectancy of 5 years. They were added to the ERP in 2008 for replacement in 2011 at a cost of $42,600. Due to continued equipment failure the cameras were replaced in 2009 with combined funding from the ERP, the computer fund, DUI forfeiture funds, and federal stimulus funds. The cameras have a 5 year life and are again scheduled for replacement in 2014. The replacement of radio's — portable and mobile totaling 132 among the police (82), fire (40) and public works (10) and originally purchased with a 2 Activity Center: Public Works: Homeland Security grant were not scheduled in the ERP. The units will be replaced as they wear out or no longer work, therefore to provide for replacement we have a scheduled replacement fund at $15,000 per year starting in 2012. The current cost (2009) to replace the portable radios is $2,300 per unit and the mobile radios is $3,000 per unit. Previously scheduled for replacement in 2013 the refrigerator /freezer was moved up to 2010 due to increasing maintenance issues and the age of the unit (unit has been in service since the Activity Center opened in 1980), however it has been determined that we can continue to repair and use the existing freezer so the replacement has been delayed indefmitely. The lives of the equipment are annually reviewed by the public works department and over the past 10 years they have extended the lives of the 1 -ton trucks from 8 to 12 years and the dump trucks from 13 to 15 years. Extending the lives of major equipment comes with the risk of increased maintenance costs. When maintenance costs become unmanageable the equipment will be put on the schedule for earlier replacement. Streets /Traffic The 1 -ton dump truck with an estimated cost of $37,400 and trailer at an estimated cost of $4,900 originally scheduled for replacement in 2009 were postponed to 2010. Parks /Forestry The large turf mower originally scheduled for replacement in 2013 was moved to 2011 in the 2008 ERP and now has been moved up to 2010 based on maintenance experience and required repairs. This mower is required to efficiently mow the large parks. Two tractors currently on a 20 year replacement plan will be changed to one at 20 years replacement and one at 30 years replacement. The 20 -year tractor scheduled for replacement in 2009 was postponed to 2012 and the 30 -year tractor is scheduled for replacement in 2014. The three riding lawn mowers had a replacement schedule of 2009, 2012 and 2014. Upon evaluation of the mowers the mower scheduled for 2009 has been postponed to 2011. Water Water funds share of telephone cost postponed to 2015 as described above under City Hall. Sewer Sewer funds share of telephone cost postponed to 2015 as described above under City Hall. 3 Refuse Swap loader originally scheduled for replacement in 2008 was postponed in late 2008 to 2010. This was done after the 2009 ERP was completed so the swap loader was not in the 2009 ERP. The cost of the swap loader was changed to be 100% funded by the refuse fund. It was formerly funded 75/25 refuse /public works- forestry. Five Year Summaries Rate Change EQUIPMENT REPLACEMENT FUND (602) 08/10/2009 0% 0% 0% 2% 2% 3% 3% 5% ACTUAL ACTUAL BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 2007 2008 2009 2010 2011 2012 2013 2014 Working Capital Begin Year 1,252,175 1,371,188 1,033,705 1,083,688 1,006,910 996,159 350,287 60,866 Revenues from charges 287,125 287,127 287,125 292,868 298,725 307,687 316,917 332,763 Transfer in General Fund Transfer In - Pavilion - Capital Lease 137,806 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 Fire Truck Lease 425,000 Reimbursement - Radio System Interest earnings 66,984 37,377 46,403 51,092 50,076 52,032 25,408 14,824 Other revenues (sale of assets) 9,456 16,150 20,000 25,000 25,000 25,000 25,00D 30,000 Total Revenues 501,371 801,025 376,671 392,102 396,944 407,862 386,077 380,729 Expenditures (excludes Depr.) 56,121 25,604 26,372 27,163 27,978 28,817 29,682 30,572 expenditures include copier & eng scanner leases Fire Truck Financing Pymnts (2009 -2018) 3,889 54,217 54,217 54,217 54,217 54,217 54217 Capital Outlay - Equipment 304,237 1,109,014 246,100 387,500 325,500 970,700 591,600 414,700 Transfer to Pavilion (loan) 22,000 382,358 1,138,507 326,689 468,880 407,695 1,053,734 675,498 499,489 Working Capital Ending Balance 1,371,188 1,033,705 1,083,688 1,006,910 996,159 350,287 60,866 (57,894) 1,369,304 1,031,170 1,135,368 1,112,807 1,156,273 564,618 329,413 264,869 Cash balance Memo Only Long Tenn Receivable 115,609 95,609 75,609 55,609 35,609 15,609 2007 Hockey Booster Loan repayment 22,000 18,783 15,640 12,497 9,354 6,211 3,068 Cash Balance + LT Receivable 1,484,913 1,126,779 1,210,977 1,168,416 1,191,882 580,227 5 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2010 tlu 2014 DEPARTMENT SUMMARY Department 2010 2011 2012 2013 2014 Total Activity Center 15,000 15,000 Arts Center 12,100 12,100 City Hall Administration 38,000 38,000 38,000 38,000 38,000 190,000 Community Services 25,400 49,500 16,500 16,500 16,500 124,400 Fire 101,617 64,517 329,717 79,417 54,217 629,485 Pavilion 88,100 88,100 Police 100,800 156,300 184,200 147,500 254,600 843,400 Public Works: Engineering 21,500 21,500 Public Works: Parks /Forestry 65,000 81,400 138,900 25,700 66,800 377,800 Public Works: Streets/Traffic 123,300 327,600 327,200 48,800 826,900 Refuse 264,000 101,600 365,600 Sewer 35,700 35,700 Water 12,200 134,800 147,000 GRAND TOTAL 730,317 401,817 1,034,917 805,617 704,317 3,676,985 6 Tuesday, August 11, 2009 Department Activity Center 1 Activity Center Copy Machine Arts Center 1 Arts Center Copy Machine City Hall Administration A Network Server Computers Community Services 1 City Hall Main Copy Machine - Oce' Copier City Hall Small Copy Machine Engineering Printer /Scanner Document Management Scanner (3) Election Booths Fire r Duty Chief Vehicle Aerial Truck Extrication Tool (2) Copy Machine Thermal Imaging Camera (2) Workout Equipment - Eliptical Workout Equipment - Stairmaster Workout Equipment - Treadmill Automated External Defibrillator (2) Quick Attack Pumper /Rescue Workout Equipment - Dumb Bells Pavilion 1 Ice Resurfacer Arts Center Total City Hall Administration Total Community Services Total Fire Total City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2010 thru 2014 PROJECTS BY DEPARTMENT Project# Priority 2010 2011 2012 2013 2014 Total 01 -ERP -030 n/a 01 -ERP -1000 n/a 7 15,000 Activity Center Total 15,000 15,000 15,000 01 -ERP -1100 nla 12,100 12,100 12,100 12,100 01 -ERP -003 nla 8,000 8,000 8,000 8,000 8,000 40,000 01 -ERP -006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 38,000 38,000 38,000 38,000 38,000 190,000 01- ERP -001 n/a 2,400 13,000 15,400 01 -ERP -002 n/a 20,000 20,000 01 -ERP -007 n/a 10,000 10,000 10,000 10,000 10,000 50,000 01 -ERP -008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 01 -ERP -010 n/a 6,500 6,500 25,400 49,500 16,500 16,500 16,500 124,400 01 -ERP -103 n/a 36,400 36,400 01- ERP -106 n/a 54,217 54,217 54,217 54,217 54,217 271,085 01 -ERP -109 n/a 26,500 26,500 01 -ERP -110 n/a 10,300 10,300 01 -ERP -112 n/a 18,000 18,000 01 -ERP -116 nla 5,000 5,000 01- ERP -117 n/a 5,000 5,000 01- ERP -118 n/a 5,000 5,000 01 -ERP -120 n/a 6,000 7,200 13,200 01 -ERP -121 nla 234,000 234,000 01- ERP -122 n/a 5,000 5,000 101,617 64,517 329,717 79,417 54,217 629,485 88,100 88,100 Tuesday, August 11, 2009 Department Project+ Priority Police Marked Patrol Vehicles (6) Sergeant's Vehicle Utility 4x4 (unit 212) Police Administrative Vehicles (2) Copy Machine Logging Recorder Network Server (3) Mobile Data Computers Digital Squad Car Cameras Tactical Ballistic Vests Radios - Portable and Mobile Devices Public Works: Engineering 1 Engineering Van 01 -ERP -700 nla Public Works: Engineering Total Public Works: Parks/Forestry 1 1/2 Ton Pickup Truck 4x4 3 /4Ton Trucks (2) 3/4 Ton Utility Truck Tractors (2) Trucksters (3) Riding Mowers (3) Large Turf Mower Brush Chipper Pavilion Total Police Total Public Works: Parks/Forestry Total Public Works: Streets /Traffic 1 2010 4X4 3/4 Ton Truck with Plow 01 -ERP -301 nla 1 Ton Dump Truck (2) 01 -ERP -303 nla 37,400 1 Ton Traffic Boom Truck 01- ERP -304 nla Tandem Dump Trucks (2) 01 -ERP -306 nla Water Truck 01 -ERP -307 n/a 45,000 Front End Loaders (2) 01 -ERP -308 nla Skid Loader (2) 01 -ERP -309 n/a 36,000 Sweeper 01 -ERP -311 n/a Roller 01- ERP -312 nla Asphalt Paver 01 -ERP -314 n/a Trailer 01- ERP -316. nla 4,900 Public Works: Streets /Traffic Total Refuse Swap Loader Refuse Truck (RAP -R) (2) Refuse Truck (Rear -L) 123,300 01 -ERP -803 nla 80,000 01 -ERP -900 n/a 184,000 01- ERP -901 n/a 8 2011 2012 34,700 75,000 172,000 45,900 2013 30,400 132,300 164,500 2014 Total 88.100 88,100 01 -ERP -200 nla 65,200 67,200 69,200 71,200 73,400 346,200 01- ERP -201 nla 33,600 33,600 01 -ERP -203 n/a 47,700 47,700 01 -ERP -204 n/a 27,100 27,900 28,800 29,600 30,500 143,900 01 -ERP -209 n/a 19,100 19,100 01 -ERP -210 n/a 36,900 36,900 01 -ERP -211 nla 8,500 8,500 8,500 8,500 8,500 42,500 01 -ERP -212 nla 62,700 62,700 01- ERP -213 n/a 42,600 42,600 01 -ERP -214 nla 23,200 23,200 01 -ERP -215 nla 15,000 15,000 15,000 45,000 100,800 156,300 184,200 147,500 254,600 843,400 21,500 21,500 21,500 21,500 01 -ERP -800 nla 26,400 26,400 01 -ERP -801 nla 67,400 67,400 01 -ERP -802 nla 32,200 32,200 01 -ERP -806 nla 41,400 46,500 87,900 01 -ERP -807 nla 19,800 19,800 01 -ERP -808 nla 22,800 10,300 20,300 53,400 01 -ERP -810 nla 65,000 65,000 01 -ERP -813 n/a 25,700 25,700 65,000 81,400 138,900 25,700 66,800 377,800 30,400 72,100 75,000 132,300 45,000 172,000 36,000 164,500 45,900 48,800 48,800 4,900 327,600 327,200 48,800 826,900 101,600 80,000 184,000 101,600 Tuesday, August 11, 2009 Department Project# Priority 2010 2011 2012 2013 2014 Total Refuse Total Sewer 4x4 3/4 Ton Truck Sewer Total Water Backhoe Loader Public Works Copy Machine Water Total GRAND TOTAL 264,000 101,600 365,600 01 -ERP -550 n/a 35,700 35,700 01 -ERP -502 n/a 01 -ERP -506 n/a 12,200 9 12,200 134,800 134,800 35,700 35,700 134,800 12,200 147,000 730,317 401,817 1,034,917 805,617 704,317 3,676,985 Tuesday, August 11, 2009 Source City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2010 thru 2014 FUNDING SOURCE SUMMARY 2010 2011 2012 2013 2014 Total Bonds /Lease 54,217 54,217 54,217 54,217 54,217 271,085 Equipment Replacement Fund 399,900 335,500 980,700 616,600 424,700 2,757,400 HCA - Arts Center Fund 12,100 12,100 PA - Pavilion Fund 88,100 88,100 RF - Refuse Fund 264,000 101,600 365,600 SF - Sanitary Sewer Fund 35,700 35,700 WF - Water Fund 12,200 134,800 147,000 GRAND TOTAL 730,317 401,817 1,034,917 805,617 704,317 3,676,985 10 Tuesday, August 11, 2009 Source Bonds/Lease Aerial Truck Bonds /Lease Total Equipment Replacement Fund City Hall Main Copy Machine - Oce' Copier City Hall Small Copy Machine Network Server Computers Engineering Printer /Scanner Document Management Scanner (3) Election Booths Activity Center Copy Machine Duty Chief Vehicle Extrication Tool (2) Copy Machine Thermal Imaging Camera (2) Workout Equipment - Eliptical Workout Equipment - Stairmaster Workout Equipment - Treadmill Automated Extemal Defibrillator (2) Quick Attack Pumper /Rescue Workout Equipment- Dumb Bells Marked Patrol Vehicles (6) Sergeants Vehicle Utility 4x4 (unit 212) Police Administrative Vehicles (2) Copy Machine Logging Recorder Network Server (3) Mobile Data Computers Digital Squad Car Cameras Tactical Ballistic Vests Radios - Portable and Mobile Devices 4X4 3/4 Ton Truck with Plow 1 Ton Dump Truck (2) 1 Ton Traffic Boom Truck Tandem Dump Trucks (2) Water Truck Front End Loaders (2) Skid Loader (2) Sweeper Roller City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2010 thru 2014 PROJECTS BY FUNDING SOURCE Project# Priority 2010 2011 2012 2013 2014 Total 01 -ERP -106 n/a 54,217 54,217 54,217 54,217 54,217 271,085 01 -ERP -001 n/a 2,400 13,000 15,400 01 -ERP -002 n/a 20,000 20,000 01 -ERP -003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 01- ERP -006 n/a • 30,000 30,000 30,000 30,000 30,000 150,000 01 -ERP -007 n/a 10,000 10,000 10,000 10,000 10,000 50,000 01 -ERP -008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 01- ERP -010 n/a 6,500 6,500 01 -ERP -030 n/a 15,000 15,000 01 -ERP -103 n/a 36,400 36,400 01- ERP -109 n/a 26,500 26,500 01 -ERP -110 n/a 10,300 10,300 01- ERP -112 n/a 18,000 18,000 01 -ERP -116 n/a 5,000 5,000 01 -ERP -117 n/a 5,000 5,000 01 -ERP -118 n/a 5,000 5,000 01 -ERP -120 n/a 6,000 7,200 13,200 01 -ERP -121 n/a 234,000 234,000 01 -ERP -122 n/a 5,000 5,000 01 -ERP -200 n/a 65,200 67,200 69,200 71,200 73,400 346,200 01 -ERP -201 n/a 33,600 33,600 01 -ERP -203 n/a 47,700 47,700 01 -ERP -204 n/a 27,100 27,900 28,800 29,600 30,500 143,900 01 -ERP -209 n/a 19,100 19,100 01 -ERP -210 n/a 36,900 36,900 01- ERP -211 n/a 8,500 8,500 8,500 8,500 8,500 42,500 01 -ERP -212 n/a 62,700 62,700 01- ERP -213 n/a 42,600 42,600 01 -ERP -214 n/a 23,200 23,200 01 -ERP -215 n/a 15,000 15,000 15,000 45,000 01 -ERP -301 n/a 30,400 30,400 01 -ERP -303 n/a 37,400 34,700 72,100 01 -ERP -304 n/a 75,000 75,000 01 -ERP -306 n/a 132,300 132,300 01 -ERP -307 n/a 45,000 45,000 01 -ERP -308 n/a 172,000 172,000 01 -ERP -309 n/a 36,000 36,000 01 -ERP -311 n/a 164,500 164,500 01- ERP -312 n/a 45,900 45,900 11 54,217 54,217 54,217 54,217 54,217 271,085 Tuesday, August 11, 2009 Source Project# Priority 2010 2011 2012 2013 2014 Total Asphalt Paver Trailer Engineering Van 1/2 Ton Pickup Truck 4x4 314Ton Trucks (2) 3/4 Ton Utility Truck Tractors (2) Trucksters (3) Riding Mowers (3) Large Turf Mower Brush Chipper Ice Resurfacer Equipment Replacement Fund Total HCA - Arts Center Fund ti Arts Center Copy Machine PA - Pavilion Fund RF - Refuse Fund 1 Swap Loader Refuse Truck (RAP -R) (2) Refuse Truck (Rear -L) SF - Sanitary Sewer Fund 4x4 3/4 Ton Truck HCA - Arts Center Fund Total PA - Pavilion Fund Total RF - Refuse Fund Total SF - Sanitary Sewer Fund Total Backhoe Loader Public Works Copy Machine 01 -ERP -314 n/a 48,800 48,800 01- ERP -316 n/a 4,900 4,900 01 -ERP -700 n/a 21,500 21,500 01 -ERP -800 n/a 26,400 26,400 01- ERP -801 nla 67,400 67,400 01 -ERP -802 n/a 32,200 32,200 01 -ERP -806 n/a 41,400 46,500 87,900 01 -ERP -807 n/a 19,800 19,800 01 -ERP -808 nla 22,800 10,300 20,300 53,400 01 -ERP -810 n/a 65,000 65,000 01 -ERP -813 n/a 25,700 25,700 399,900 335,500 980,700 616,600 424,700 2,757,400 01- ERP -1100 n/a 12,100 12,100 12,100 12,100 01- ERP -1000 n/a 88,100 88,100 88,100 88,100 01 -ERP -803 n/a 80,000 80,000 01 -ERP -900 nla 184,000 184,000 01- ERP -901 n/a 101,600 101,600 264,000 101,600 365,600 01 -ERP -550 n/a 35,700 35,700 35,700 35,700 01 -ERP -502 nla 134,800 134,800 01 -ERP -506 n/a 12,200 12,200 WF - Water Fund Total 12,200 134,800 147,000 GRAND TOTAL 730,317 401.817 1,034,917 805,617 704,317 3,676,985 l2 Tuesday, August 11, 2009 Department ;Activity Center I Activity Center Copy Machine l Arts Center Arts Center Copy Machine City Hall Administration Network Server Computers City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2010 thru 2014 PROJECTS & FUNDING SOURCES BY DEPARTMENT Project# Priority 2010 2011 2012 2013 2014 Total 01 - ERP - 030 n/a 15,000 15,000 Activity Center Total Equipment Replacement Fund Activity Center Total 15,000 15,000 15,000 15,000 01 -ERP -1100 n/a 12,100 12,100 Arts Center Total HCA -`Arts Center Fund Arts Center Total 12,100 12,100 12,100 12,100 01 -ERP -003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 01 -ERP -006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 City Hall Administration Total Community Services Total 13 15,000 15,000 12,100 12,100 38,000 38,000 38,000 38,000 38,000 190,000 Equipment Replacement Fund City Hall Administration Total Community Services 38,000 38,000 38,000 38,000 38,000 190,000 38,000 38,000 38,000 38,000 38,000 190,000 City Hall Main Copy Machine - Oce' Copier 01 -ERP -001 n/a 2,400 13,000 15,400 City Hall Small Copy Machine 01 -ERP -002 n/a 20,000 20,000 Engineering PrinterlScanner 01 -ERP -007 n/a 10,000 10,000 10,000 10,000 10,000 50,000 Document Management Scanner (3) 01 -ERP -008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 Election Booths 01 -ERP -010 n/a 6,500 6,500 25,400 49,500 16,500 16,500 16,500 124,400 Equipment Replacement Fund 25,400 49,500 16,500 16,500 16,500 " 124,400 Tuesday, August 11, 2009 Department Fire 1 Duty Chief Vehicle Aerial Truck Extrication Tool (2) Copy Machine Thermal Imaging Camera (2) Workout Equipment - Eliptical Workout Equipment - Stairmaster Workout Equipment - Treadmill Automated External Defibrillator (2) Quick Attack Pumper /Rescue Workout Equipment - Dumb Bells Pavilion Ice Resurfacer [Police 1 Marked Patrol Vehicles (6) Sergeants Vehicle Utility 4x4 (unit 212) Police Administrative Vehicles (2) Copy Machine Logging Recorder Network Server (3) Mobile Data Computers Digital Squad Car Cameras Tactical Ballistic Vests Radios - Portable and Mobile Devices Project# Priority 2010 2011 2012 2013 Community Services Total 25,400 49,500 16,500 16,500 16,500 124,400 01 -ERP -103 n/a 36,400 36,400 01 -ERP -106 n/a 54,217 54,217 54,217 54,217 54,217 271,085 01 -ERP -109 n/a 26,500 26,500 01 -ERP -110 n/a 10,300 10,300 01 -ERP -112 n/a 18,000 18,000 01 -ERP -116 n/a 5,000 5,000 01 -ERP -117 n/a 5,000 5,000 01 -ERP -118 n/a 5,000 5,000 01 -ERP -120 n/a 6,000 7,200 13,200 01- ERP -121 n/a 234,000 234,000 01 -ERP -122 n/a 5,000 5,000 Fire Total Bonds /Lease Equipment Replacement Fund 54,217 54,217 54,217 54,217 54,217 271,085 47,400 10,300 275,500 25,200 358,400 Fire Total 101,617 64,517 329,717 79,417 54,217 629,485 01- ERP -1000 n/a 88,100 88,100 Pavilion Total PA - Pavilion Fund Pavilion Total 88,100 88,100 88,100 88,100 01 -ERP -200 n/a 65,200 67,200 69,200 71,200 73,400 346,200 01 -ERP -201 n/a 33,600 33,600 01 -ERP -203 n/a 47,700 47,700 01 -ERP -204 n/a 27,100 27,900 28,800 29,600 30,500 143,900 01 -ERP -209 n/a 19,100 19,100 01 -ERP -210 n/a 36,900 36,900 01 -ERP -211 n/a 8,500 8,500 8,500 8,500 8,500 42,500 01 -ERP -212 n/a 62,700 62,700 01 -ERP -213 n/a 42,600 42,600 01 -ERP -214 n/a 23,200 23,200 01 -ERP -215 n/a 15,000 15,000 15,000 45,000 14 2014 Total 101,617 64,517 329,717 79,417 54,217 629,485 88,100 88,100 Tuesday, August 11, 2009 Department Project# Priority 2010 2011 2012 2013 2014 Total Equipment Replacement Fund 100,800 156,300 184,200 147,500 254,600 843,400 Police Total 100,800 156,300 184,200 147,500 254,600 843,400 Public Works: Engineering r Engineering Van Equipment Replacement Fund Public Works: Engineering Total 21,500 21,500 21,500 21,500 Public Works: Parks/Forestry 1 1/2 Ton Pickup Truck 01 -ERP -800 n/a 26,400 26,400 4x4 3 /4Ton Trucks (2) 01 -ERP -801 n/a 67,400 67,400 3/4 Ton Utility Truck 01- ERP -802 n/a 32,200 32,200 Tractors (2) 01 -ERP -806 n/a 41,400 46,500 87,900 Trucksters (3) 01- ERP -807 n/a 19,800 19,800 Riding Mowers (3) 01 -ERP -808 n/a 22,800 10,300 20,300 53,400 Large Turf Mower 01 -ERP -810 n/a 65,000 65,000 Brush Chipper 01 -ERP -813 n/a 25,700 25,700 Public Works: Streets /Traffic r 4X4 3/4 Ton Truck with Plow 1 Ton Dump Truck (2) 1 Ton Traffic Boom Truck Tandem Dump Trucks (2) Water Truck Front End Loaders (2) Skid Loader (2) Sweeper Roller Asphalt Paver Trailer Public Works: Engineering Total Public Works: Parks/Forestry Total Police Total 100,800 156,300 184,200 147,500 254,600 843,400 01 -ERP -700 n/a 21,500 21,500 15 01 -ERP -301 n/a 01 -ERP -303 n/a 37,400 01 -ERP -304 n/a 01 -ERP -306 n/a 01 -ERP -307 n/a 45,000 01 -ERP -308 n/a 01 -ERP -309 n/a 36,000 01 -ERP -311 n/a 01 -ERP -312 n/a 01 -ERP -314 n/a 01 -ERP -316 n/a 4,900 65,000 81,400 138,900 25,700 66,800 377,800 Equipment Replacement Fund 65,000 81,400 138,900 25,700 66,800 377,800 Public Works: Parks /Forestry Total 65,000 81,400 138,900 25,700 66,800 377,800 34,700 75,000 172,000 45,900 21,500 21,500 30,400 132,300 164,500 30,400 72,100 75,000 132,300 45,000 172,000 36,000 164,500 45,900 48,800 48,800 4,900 Tuesday, August 11, 2009 Department Project# Priority 2010 2011 2012 2013 2014 Total Equipment Replacement Fund 123,300 327,600 327,200 48,800 826,900 Public Works: Streets /Traffic Total 123,300 327,600 327,200 48,800 826,900 Refuse Swap Loader 01 -ERP -803 n/a 80,000 Refuse Truck (RAP -R) (2) 01- ERP -900 n/a 184,000 Refuse Truck (Rear -L) 01 -ERP -901 n/a RF- Refuse Fund Refuse Total 264,000 264,000 101,600 365,600 101,600 365,600 Sewer 4x4 3/4 Ton Truck ;Water Backhoe Loader Public Works Copy Machine Public Works: Streets/Traffic Total Refuse Total 264,000 101,600 365,600 01 -ERP -550 n/a 35,700 35,700 Sewer Total 01 -ERP -502 n/a 134,800 134,800 01 -ERP -506 n/a 12,200 12,200 Water Total 123,300 327,600 327,200 48,800 826,900 101,600 80,000 184,000 101,600 35,700 35,700 SF - Sanitary Seiner Fund Sewer Total 35,700 35,700, 35,700 35,700 12,200 134,800 147,000 WF - i'Vater Fund 12,200 134,800 147,000 Water Total 12,200 134,800 147,000 Grand Total 730,317 401,817 1,034,917 805,617 704,317 3,676,985 16 Tuesday, .-August 11, 2009 Equipment Requests EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -001 Project Name City Hall Main Copy Machine - Oce' Copier 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. Note: 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. Budget Impact/Other Prior 91,800 Total Prior 91,800 Total Type Equipment Useful Life 5 years Category Equipment Future Expenditures Equipment Funding Sources 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- Total Equipment Replacement Fund Department Community Services Contact City Clerk Priority n/a 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 2,400 13,000 15,400 2,400 13,000 52,800 15,400 Tota 2010 2011 2012 2013 2014 Total Future 2,400 13,000 15,400 52,800 Total 2,400 13,000 15,400 Total 17 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # O1 -ERP -002 Project Name City Hall Small Copy Machine Description Coyy machine to service needs of all departments located at City Hall. 1, Variety of copying tasks. 2. High volume product copier. Note: This is a Ricoh color copier. Justification Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. Budget Impact/Other Variance from 20 year plan - Cost reduced $6,900 due to pricing reductions. Estimate salvage /resale value on replaced item: $2,500 Prior 43,200 Total Prior Type Equipment Useful Life 5 years Category Equipment Future 43,200 Expenditures Equipment Funding Sources J Equipment Replacement Fund Total Total Department Community Services Contact City Clerk Priority n/a Total Project Cost: S144,500 2010 2011 2012 2013 2014 Total 20,000 20,000 20,000 20,000 20,000 20,000 18 2010 tl7ru 2014 Total Future 81,300 20,000 Total 2010 2011 2012 2013 2014 Total Future 81,300 20,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 01 -ERP -003 Project Name Network Server Type Equipment Useful Life 1 year Category Equipment Future Description The network server is the hub of the network. New computers are faster and more reliable. Justification Networking allows user to share information that is stored in a single location, the network server. This is more efficient because the information does not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every user is working with the same data. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ -0- Prior Expenditures 57,000 Total Prior 57,000 Total Equipment Funding Sources J Equipment Replacement Fund Department City Hall Administration Contact Finance Director/IT Priority n/a Total Project Cost: 5217,000 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 8,000 8,000 8,000 8,000 8,000 40,000 Total 8,000 8,000 8,000 8,000 8,000 40,000 Total 2010 2011 2012 2013 2014 Total Future 8,000 8,000 8,000 8,000 8,000 40,000 120,000 120,000 Total 8,000 8,000 8,000 8,000 8,000 40,000 Total 19 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -006 Project Name Computers Prior Total Prior Total Type Useful Life Category Future Justification 270,000 270,000 Equipment 3 -5 years Equipment Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ -0- Expenditures Equipment Department City Hall Administration Contact Finance Director /IT Priority n/a 20 2010 thru 2014 Description Total Project Cost: $870,000 Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Tools enabling staff to perform job responsibilities efficiently and effectively. 2010 2011 2012 2013 2014 Total Future 30,000 30,000 30,000 30,000 30,000 150,000 Funding Sources Equipment Replacement Fund 30,000 30,000 30,000 30,000 30,000 150,000 450,000 Total 30,000 30,000 30,000 30,000 30,000 150,000 Total 2010 2011 2012 2013 2014 Total Future 450,000 Total 30,000 30,000 30,000 30,000 30,000 150,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -007 Project Name Engineering Printer /Scanner Description Printer /scanner - large format copier use in Engineering to copy blueprints, plans and large documents. Equipment is leased. Justification Large document copier /scanner for use in Engineering. Also scans documents for permanent storage. Budget Impact/Other Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $ -0- Prior Total Prior Total Type Equipment Useful Life 5 years Category Equipment Future 34,560 34,560 Expenditures Equipment Funding Sources Department Community Services Contact City Clerk Priority n/a Total Project Cost: $294,560 21 2010 thru 2014 2010 2011 2012 2013 2014 10,000 10,000 10,000 10,000 10,000 50,000 Total Future 210,000 Total 10,000 10,000 10,000 10,000 10,000 50,000 Total 2010 2011 2012 2013 2014 Total Future Equipment Replacement Fund 10,000 10,000 10,000 10,000 10,000 50,000 210,000 Total 10,000 10,000 10,000 10,000 10,000 50,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -008 Project Name Document Management Scanner (3) Type Equipment Useful Life 3 years Category Equipment Future Description Justification Prior 13,000 1 Total Prior 13,000 Total Expenditures Equipment Department Community Services Contact City Clerk Priority n/a Total Project Cost: S143,000 2010 rhru 2014 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 he evaluated each year for replacement. If scanners are working properly their life will be extended. We have been getting up to three Tree Trust volunteers to work on scanning and the small scanner only handles documents up to 8 x 14 ". We would like to replace this scanner with a large document scanner to fully utilize our volunteers. Budget Impact/Other Variance from 20 year plan - item scheduled for 2009 was not replaced. Unit was repaired to extend its life. One additional scanner was added to the replacement shedule in 2010. Estimate salvage /resale value on replaced item: $500- $1,000 2010 6,500 2011 6,500 22 2012 6,500 2013 6,500 2014 6,500 Total Future 32,500 97,500 I Total 6,500 6,500 6,500 6,500 6,500 32,500 Total 2010 2011 2012 2013 2014 Total Futo Funding Sources Equipment Replacement Fund 6,500 6,500 6,500 6,500 6,500 32,500 97,500 Total 6,500 6,500 6,500 6,500 6,500 32,500 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -010 Project Name Election Booths Type Equipment Useful Life 20 years Category Equipment Future Description Election booths Justification In 2008 the City replaced approximately 1/2 of the voting booths in use now. The booths we have now are over 25 years old - many of them no longer have functioning lights. Every year we have to stop using some because they have broken parts and can no longer be used. Budget Impact/Other Variance from 20 year plan - new item - cost in 2008 - $6,400 for 1/2 of the booths. Cost in 2009 - $6,500 for 1/2 of the booths. Move out to 2010. Estimate salvage /resale value on replaced item: $ -0- Expenditures Equipment Funding Sources Equipment Replacement Fund Department Community Services Contact City Clerk Priority n/a Total Project Cost: 56,500 2010 2011 2012 2013 2014 Total 6,500 6,500 Total 6,500 6,500 2010 2011 2012 2013 2014 Total 6,500 6,500 Total 6,500 6,500 23 2010 thru 2014 Tuesday, August I1, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project ti 01 -ERP -030 Project Name Activity Center Copy Machine Type Equipment Useful Life Unassigned Category Equipment Future Description Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources Total Equipment Replacement Fund Department Activity Center Contact Facilities Director Priority n/a Total Project Cost: S56,000 Copy flyers, letters, forms, informational items, etc. 24 2010 thru 2014 Copy machine used by staff for daily operations of the Hopkins Activity Center. 2010 2011 2012 2013 2014 15,000 15,000 15,000 2010 2011 2012 2013 2014 15,000 15,000 Total Future 41,000 15,000 Total Total Future 41,000 I Total 15,000 15,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -103 Project Name Duty Chief Vehicle Description Justification Prior Total Prior Total Type Useful Life Category Future 28,100 28,100 Equipment 5 years Vehicles A marked passenger vehicle for use by the Duty Chief in transporting required equipment, reference materials and personnel for emergency response, and routine Fire Department business. Used by the Fire Chief when responding to fires and other emergencies. Used for official business in and out of the city and for fire fighter travel on official Fire Department business. Going to 3 year rotation will replace current used squad car that ends up costing us more money in repairs. Each car will be cycled down and older squad will be replaced. Budget Impact/Other Variance from 20 year plan - Change from 7 year life to 3 years. Add vehicle rotation in 2009. Estimate salvage /resale value on replaced item: $4,000 Expenditures Vehicles Funding Sources Total 36,400 Equipment Replacement Fund 36,400 36,400 Total 36,400 Department Fire Contact Fire Chief Priority n/a Total Project Cost: 5212,300 25 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 36,400 36,400 147,800 36,400 Total 2010 2011 2012 2013 2014 Total Future 147,800 36,400 Totai Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -106 Project Name Aerial Truck Type Equipment Useful Life 20 years Category Vehicles Future Description One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009 -2018 on 2008 purchase of Pierce Aerial Truck. Payments due semi - annually each April 23 and October 23. Justification Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using $445,427.08 in ERP cash and a 10 -year capital lease of $425,000. At the end of the lease tern payments (P &I) will total $542,170. Total costs of aerial including cash payments equals $987,597. Budget Impact/Other Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage /resale value on replaced item: $ Prior 499,644 Total Prior 499,644 Expenditures Equipment Funding Sources Bonds /Lease Total Total Department Fire Contact Fire Chief Priority Ma Total Project Cost: $987,597 26 2010 thri, 2014 2010 2011 2012 2013 2014 54,217 54,217 54,217 54,217 54,217 271,085 54,217 54,217 54,217 54,217 54,217 271,085 Total Future 216,868 Total 54,217 54,217 54,217 54,217 54,217 271,085 Total 2010 2011 2012 2013 2014 Total Future 216,868 54,217 54,217 54,217 54,217 54,217 271,085 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -109 Project Name Extrication Tool (2) Type Useful Life Category Future Description Justification Prior 20,300 Total Prior 20,300 I Total Equipment 10 years Equipment Expenditures Equipment Funding Sources Total Equipment Replacement Fund Total Department Fire Contact Fire Chief Priority n/a Total Project Cost: S154,100 2010 2011 27 2010 thru 2014 Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. All vehicle and industrial rescue situations which will require patient disentanglement or entrapment. This tool wil be added to the purchase of the quick attack pumper. The tool will be scaled down to a smaller tool, possibly reducing cost. Budget Impact/Other Variance from 20 year plan - move back from 2015 to 2019. Estimate salvage /resale value on replaced item: $1,000 2012 26,500 26,500 2010 2011 2012 2013 2014 Total Future 26,500 26,500 26,500 2013 2014 Total Future 26,500 107,300 26,500 Total 107,300 26,500 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -110 Project Name Copy Machine Description Fire Station copy machine. Justification Copying business papers, training records, etc. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $500 Prior 7,400 Total Prior 7,400 Total Type Equipment Useful Life 8 years Category Equipment Future Expenditures Equipment Funding Sources Equipment Replacement Fund Total Project Cost: $47,400 2010 2011 2012 2013 2014 Total Future Department Fire Contact Fire Chief Priority n/a Total 10,300 Total 2010 thru 2014 10,300 10,300 29,700 10,300 Total 2010 2011 2012 2013 2014 Total Future 10,300 10,300 10,300 28 29,700 10,300 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -112 Project Name Thermal Imaging Camera (2) Type Equipment Useful Life 10 years Category Equipment Future Description Justification Prior 15,000 Total Prior 15,000 Expenditures Equipment Funding Sources Equipment Replacement Fund Total Total Department Fire Contact Fire Chief Priority n/a Total Project Cost: $104,600 2010 thru 2014 Used by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and heat may be hidden allowing for faster extinguishment. Note: purchased 2003 & 2007 Current camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was purchased with donation money. Budget Impact/Other Variance from 20 year plan - department owns 2 cameras. Previously one one was included in the replacement plan. This will add to the replacement schedule the camera purchased from the Fire Dept budget in 2003. Estimate salvage /resale value on repalced item: $ -0- 2010 2011 29 2012 2013 18,000 2014 Total Future 18,000 18,000 18,000 71,600 Total 18,000 18,000 Total 2010 2011 2012 2013 2014 Total Future 71,600 18,000 18,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -116 Project Name Workout Equipment - EIiptical Type Useful Life Category Future Description Total Project Cost: S37,800 Workout equipment used in Fire Department workout room. Two eliptical machines replaced on a 6 year cycle, one every 3 years. 2012- replace eliptical 2015 - replace eliptical Justification Equipment 6 years Equipment This equipment is available to all City employees for health and wellness. Budget Impact/Other Variance from 20 year plan - remove $5,000 in 2009 and use for dumb bells. Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources Equipment Replacement Fund Total 5,000 Total Department Fire Contact Fire Chief Priority n/a 30 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 5,000 5,000 5,000 5,000 5,000 32,800 5,000 Total 2010 2011 2012 2013 2014 Total Future 32,800 5,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -117 Project Name Workout Equipment - Stairmaster Type Equipment Useful Life 5 years Category Equipment Future Description Workout equipment used in Fire Department workout room. One stairmaster replaced on a 5 year cycle. Justification This equipment is available to all City employees for health and wellness. Budget Impact/Other { Variance from 20 year plan - new item - Originally purchased with grant funds. Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources Equipment Replacement Fund Total 5,000 Total 5,000 Department Fire Contact Fire Chief Priority n/a Total Project Cost: $25,300 31 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 5,000 5,000 5,000 5,000 20,300 5,000 Total 2010 2011 2012 2013 2014 Total Future 20,300 5,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project ti 01 -ERP -118 Project Nam Workout Equipment - Treadmill Type Equipment Useful Life 5 years Category Equipment Future Department Fire Contact Fire Chief Priority n/a Description Total Project Cost: S25,300 Workout equipment used in the Fire Department workout room. One treadmill replaced on a 5 year cycle. Justification This equipment is available to all City employees for health and wellness. Budget Impact/Other Variance from 20 year plan - move back one year from 2011 to 2012. Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources Total Equipment Replacement Fund Total 2010 2011 32 2010 thru 2014 2012 5,000 5,000 5,000 2013 2014 5,000 5,000 5,000 Total Future 20,300 5,000 Total 2010 2011 2012 2013 2014 Total Future 20,300 5,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # Ol -ERP -120 Project Name Automated External Defibrillator (2) Type Equipment Useful Life 3 years Category Equipment Future Description Department Fire Contact Fire Chief Priority nla Total Project Cost: $60,200 Defibrillator is used to help get someones heart restarted during a cardiac arrest. Own 2 - both are replaced at one time due to changing technology. Justification The current AED are not in the ERP. With changes in technology, they should be replaced every three years. Cost - $3,000 per unit Budget Impact/Other Variance from 20 year plan - new item. Not previously included in ERP. 2007 replaced with fire department funds. Estimate salvage /resale value on replaced item: $ Expenditures Equipment 2010 6,000 Total 6,000 Total 6,000 2011 33 2010 dm.' 2014 2012 2013 7,200 7,200 2014 13,200 Funding Sources Equipment Replacement Fund 6,000 7,200 13,200 Total Future 47,000 13,200 Total 2010 2011 2012 2013 2014 Total Future 47,000 I 7,200 13,200 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -121 Project Name Quick Attack Pumper/Rescue Type Equipment Useful Life 25 years Category Vehicles Future Description Justification Expenditures Vehicles Funding Sources Equipment Replacement Fund Department Fire Contact Fire Chief Priority n/a Total Project Cost: 5234,000 2010 thru 2014 Quick attack pumper /rescue. Would replace Rescue 8 (lite rescue) and use as a utility vehicle. This truck could be used for daytime and nighttime tnedicals and small fires. This will reduce having all personnel respond to small fires. It will also let us drop one engine in 2022 but still keep ISO rating. Budget Impact/Other Variance from 20 year plan - new item. Estimate salvage /resale value on replaced item: $ 2010 2011 34 2012 234,000 2013 2014 Total 234,000 Total 234,000 234,000 2010 2011 2012 2013 2014 Total 234,000 234,000 Total 234,000 234,000 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -122 Project Name Workout Equipment - Dumb Bells Type Equipment Useful Life 10 years Category Equipment Future Department Fire Contact Fire Chief Priority n/a Description Total Project Cost: $11,700 Workout equipment used in Fire Department workout room. Justification Instead of replacing eliptical machine in 2009 - would replace dumb bell. They are used by all City employees and are 15 years old. They are also covered with lead paint that could be harmful. Budget Impact/Other Variance from 20 year plan - new item. Move back from 2009 to 2012. Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources Equipment Replacement Fund 2010 2011 2012 2013 2014 Total Future Total 5,000 2010 2011 2012 2013 2014 Total 5,000 35 2010 thru 2014 5,000 5,000 5,000 5,000 6,700 5,000 Total Total Future 6,700 ` 5,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -200 Project Name Marked Patrol Vehicles (6) Type Useful Life Category Future Description Justification Equipment 3 years Vehicles Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. Fleet consists of 6 patrol vehicles - 5 marked, 1 unmarked. Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget Impact/Other 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 salvage /resale value on replaced item: $4,000 each Prior 505,300 Total Prior 505,300 1 Total Expenditures Vehicles Funding Sources Department Police Contact Police Chief Priority n/a Total Project Cost: $2,256,500 2010 rhru 2014 2010 2011 2012 2013 2014 Total Future 65,200 67,200 69,200 71,200 73,400 346,200 Equipment Replacement Fund 65,200 67,200 69,200 71,200 73,400 346,200 2010 2011 2012 2013 2014 36 1,405,000 1 Total 65,200 67,200 69,200 71,200 73,400 346,200 Total Total Future 1,405,000 Total 65,200 67,200 69,200 71,200 73,400 346,200 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Type Equipment Useful Life 4 years Category Vehicles Future Description Justification Department Police Contact Police Chief Priority Ma Total Project Cost: $215,700 2010 thri 2014 Project # 01- ERZP_201 Project Name Sergeant's Vehicle Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. 4 year rotation. Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Budget Impact/Other Variance from 20 year plan - move purchase of sergeant's squad back to 2011. Purchased new in 2007. Estimate salvage /resale value on replaced item: $3,500 each Expenditures Vehicles Funding Sources Equipment Replacement Fund 2010 2011 2012 2013 2014 Total Future Total 33,600 Total 33,600 33,600 2010 2011 2012 2013 2014 Total Future 33,600 33,600 33,600 37 182,100 33,600 Total 182,100 33,600 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -203 Project Name Utility 4x4 (unit 212) Type Equipment Useful Life 6 years Category Vehicles Future Description 4 wheel drive uitlity vehicle. Justification Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals and equipment. The 4 wheel drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme snow conditions. Budget Impact/Other Variance from 20 year plan - can move replacement back one year to 2009 - new engine. Estimate salvage /resale value on replaced item: $5,000 Prior 67,400 Total Prior 67,400 I Total Expenditures Vehicles Funding Sources Equipment Replacement Fund Department Police Contact Police Chief Priority n/a Total Project Cost: $247,600 2010 2011 2012 2013 2014 Total Future 38 2010 thru 2014 47,700 47,700 47,700 47,700 132,500 Total 47,700 47,700 Total 2010 2011 2012 2013 2014 Total Future 132,500 1 Total 47,700 47,700 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -204 Project Name Police Administrative Vehicles (2) Description Prior 185,300 Total Prior Type Useful Life Category Future 185,300 Total Equipment 2 years Vehicles Police administrative and detective vehicles. Expenditures Vehicles Department Police Contact Police Chief Priority n/a J Total Project Cost: $913,900 Replace Chiefs vehicle - even numbered years Replace Captain's vehicle - odd numbered years 2010 thru 2014 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. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $4,000 each 2010 2011 2012 2013 2014 27,100 27,900 28,800 29,600 30,500 143,900 Total 27,100 27,900 28,800 29,600 30,500 143,900 Total 2010 2011 2012 2013 2014 Total Future Funding Sources Equipment Replacement Fund 27,100 27,900 28,800 29,600 30,500 143,900 584,700 Total Future 39 584,700 Total 27,100 27,900 28,800 29,600 30,500 143,900 Tota I Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Type Equipment Useful Life 5 years Category Equipment Future Project # 01 -ERP -209 Project Name Copy Machine Description Department Police Contact Police Chief Priority n/a Total Project Cost: S127,200 2010 th, -, 2014 Police Department copy machine capable of producing double side copies and collating pages. Justification Prior 30,700 Total Prior 30,700 Total Expenditures Equipment Funding Sources Used to make duplicate copies of reports, letters, memos, etc., generated by police personnel. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $1,000 Total Total 2010 2011 19,100 19,100 Equipment Replacement Fund 19,100 19,100 40 2012 2013 2014 Total Future 19,100 77,400 19,100 Total 2010 2011 2012 2013 2014 Total Future 19,100 I 77,400 19,100 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -210 Project Name Logging Recorder Type Equipment Useful Life 7 years Category Equipment Future Description The police logging recorder is a device which records all telephone and radio transmissions produced /received by the Police Department. Justification Equipment J Total Project Cost: 5138,100 Records all incoming /outgoing phone calls from the dispatch center and all radio transmissions from police, fire and interop radio talkgroups. Equipment is necessary in case questions arise as to how calls for service or events were handled or dispatched. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ -0- Expenditures Funding Sources Equipment Replacement Fund Total 2010 Department Police Contact Police Chief Priority n/a 2011 41 2010 thru 2014 2012 2013 2014 36,900 36,900 36,900 Total Future 36,900 101,200 Total 36,900 36,900 Total 2010 2011 2012 2013 2014 Total Future 101,200 36,900 36,900 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -211 Project Name Network Server (3) Type Equipment Useful Life 3 years Category Equipment Future Description Computer servers store information and system programs. One server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01 -ERP -213) Justification Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used for data storage. Budget Impact/Other Variance from 20 year plan - Cost stabilized at $8,500 per year. Estimate salvage /resale value on replaced item - $ Prior 59,500 I Total Prior 59,500 Total Expenditures Equipment Funding Sources Equipment Replacement Fund Department Police Contact Police Chief/IT Priority n/a Total Project Cost: $229,500 2010 2011 2012 2013 2014 Total Future 8,500 8,500 8,500 8,500 8,500 42,500 Total 8,500 8,500 8,500 8,500 8,500 42,500 Total 2010 2011 2012 2013 2014 Total Future 8,500 8,500 8,500 8,500 8,500 42,500 Total 8,500 8,500 8,500 8,500 8,500 42,500 Total 42 2010 tlat -u 2014 127,500 127,500 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 4 01 -ERP -212 Project Name Mobile Data Computers Type Equipment Useful Life 5 years Category Equipment Future Description Mobile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various databases, communicate car to car. Justification Limited life of 5 years - replacement necessary. Budget Impact/Other Variance from 20 year plan - Increase cost from $54,500 to $62,700 ($5,700 x 11) to better reflect actual cost of MDC /docking station. Estimate salvage /resale value on replaced item: $ -0- Prior 47,000 Total Prior 47,000 1 Total Expenditures Equipment Funding Sources J j Total Equipment Replacement Fund Total Department Police Contact Police Chief Priority n/a Total Project Cost: 5297,800 2010 2011 43 2010 thru 2014 2012 62,700 62,700 2013 2014 62,700 2010 2011 2012 2013 2014 Total Future 62,700 62,700 62,700 Total Future 188,100 62,700 Total 188,100 62,700 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -213 Project Name Digital Squad Car Cameras Prior Total Prior Total Type Useful Life Category Future Description Justification Equipment 5 years Equipment Budget Impact/Other 42,600 42,600 Expenditures Equipment Funding Sources Total Equipment Replacement Fund Department Police Contact Police Chief Priority n/a Total Project Cost: $213,000 2010 thru 2014 Digital video camera system in each marked patrol car - used to document events in and out of the patrol car. Images downloaded to server for storage and retrieval. Police Dept. currently has eight digital camera units installed and a dedicated server. The life expectancy of the cameras is about five years. Current cameras were installed in September 2006. Cost: 8 cameras @ $5,000 per unit plus tax - $42,600 1 server @ $15,000 (to be purchased from Police Network Server (01 -ERP -211) annual allocation that carries forward. Estimated cost $57,600. Cost could be lower if, at the time of replacement, a suitable product is available through a State or County equipment bid. 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: $ 2010 2011 44 2012 2013 2014 42,600 42,600 42,600 Total Future 42,600 127,800 42,600 42,600 Total 2010 2011 2012 2013 2014 Total Future 127,800 Total 42,600 42,600 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -214 Project Name Tactical Ballistic Vests Description Justification Prior 20,000 Total Prior 20,000 Total Type Equipment Useful Life 5 years Category Equipment Future Expenditures Equipment Funding Sources Total Equipment Replacement Fund Department Police Contact Police Chief Priority n/a Total Project Cost: 5137,500 2010 thru 2014 Tactical ballistic vests worn by members of the Hopkins Police Department High -risk Entry and Assault Team (HEAT). These vests offer a higher level of protection against weapon assault than the regular duty ballistic vest. Federal and State grant monies have been available through the Ballistic Vest Program over the past several years. These grants only pay a portion of the total cost of the vest, leaving the Police Depat lucent to pay the balance. There is no guarantee that these grants will be available in the future. Warranty on the current vests expires in 2007. Cost: 9 vests x $2,133 = $19,197 (today's cost). Does not include any applicable taxes. Budget Impact/Other Variance from 20 year plan - new item. Note: regular bullet proof vests funded by federallstate grants Estimate salvage /resale value on replaced item: $ 2010 2011 2012 2013 2014 Total Future 45 23,200 23,200 23,200 94,300 I 23,200 Total 2010 2011 2012 2013 2014 Total Future 23,200 23,200 94,300 Total 23,200 23,200 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -215 Project Name Radios - Portable and Mobile Devices Type Equipment Useful Life Category Equipment Future Description Portable and mobile radios used by the police, fire and public works departments to allow these departments to communicate on one frequency. Police and fire use their radios on a daily /regular basis. The public works only uses theirs in the event of an emergency. Estimated Replacement Cost (based on 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. Budget Impact/Other Variance 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 one time. Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources Total Equipment Replacement Fund Total Department Police Contact Police Chief Priority n/a Total Project Cost: 5270,000 46 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 15,000 15,000 15,000 45,000 15,000 15,000 15,000 45,000 Total 2010 2011 2012 2013 2014 15,000 15,000 15,000 45,000 225,000 Total Future 225,000 15,000 15,000 15,000 45,000 Total Tuesday, August I1, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -301 Project Name 4X4 3/4 Ton Truck with Plow Prior Total Prior Total Type Equipment Useful Life 8 years Category Vehicles Future Description Total Project Cost: 592,900 3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers. Justification Light hauling, pulling trailers, transportation to and from job sites. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $1,500 24,000 24,000 1 Expenditures Vehicles Funding Sources Equipment Replacement Fund 2010 thru 2014 Department Public Works: Streets /Traffic Contact Public Works Director Priority n/a 2010 2011 2012 2013 2014 Total Future 30,400 30,400 38,500 Total 30,400 30,400 Total 2010 2011 2012 2013 2014 Total Future Total 30,400 30,400 Total 47 30,400 30,400 38,500 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -303 Project Name 1 Ton Dump Truck (2) Type Useful Life Category Future Description Truck is used in the Street Division of Public Works, Justification Vehicle used by various departments for street and park maintenance and light hauling. Budget Impact/Other Prior 30,500 Total Prior 30,500 Total Equipment 12 years Vehicles Expenditures Vehicles Funding Sources Total 37,400 Total 37,400 Department Public Works: Streets/Traffic Contact Public Works Director Priority n/a Total Project Cost: 5205,500 Variance from 20 year plan - move back from 2009 to 2010. Estimate salvage /resale value on replaced item: $3,500 48 2010 2011 2012 2013 37,400 34,700 2010 thru 2014 34,700 2014 Total Future 72,100 Equipment Replacement Fund 37,400 34,700 72,100 34,700 102,900 72,100 Total 2010 2011 2012 2013 2014 Total Future 72,100 Total 102,900 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -304 Project Name 1 Ton Traffic Boom Truck Type Equipment Useful Life 17 years Category Vehicles Future Description Boom truck used in Street and Traffic Divisions of Public Works. Justification Vehicle used by Traffic Department for signal and light pole maintenance. Budget Impact/Other Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $8,000 Expenditures Vehicles Funding Sources Total Equipment Replacement Fund Total Project Cost: 5199,000 Total 75,000 49 2010 thru 2014 Department Public Works: Streets /Traffic Contact Public Works Director Priority n/a 2010 2011 2012 2013 2014 Total Future 75,000 75,000 75,000 75,000 Total 2010 2011 2012 2013 2014 Total Future 75,000 75,000 124,000 I 124,000 75,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Type Equipment Useful Life 17 years Category Vehicles Future Justification Trucks used for heavy hauling, snow plowing and sanding. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ -0- Expenditures Vehicles Funding Sources Equipment Replacement Fund 50 2010 thru 2014 Project # 01 -ERP -306 Project Name Tandem Dump Trucks (2) Department Public Works: Streets/Traffic Contact Public Works Director Priority Ma Description Total Project Cost: $274,700 Dump trucks used in Streets Division of Public Works. 2010 2011 2012 2013 2014 132,300 132,300 Total Future 142,400 Total 132,300 132,300 Total 2010 2011 2012 2013 2014 Total Future 132,300 132,300 142,400 Total 132,300 132,300 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -307 Project Name Water Truck Type Equipment Useful Life 22 years Category Vehicles Future Description Water truck used in Streets and Parks Division of Public Works. Justification Used for street flushing, watering trees and plants, rink flooding and standby fire protection. Budget Impact/Other Variance from 20 year plan - replace tanker only in 2010 - replace tanker, cab & chassis in 2017, tanker only again in 2032 and entire vehicle in 2039. Change to a 22 year life. Estimate salvage /resale value on replaced item: $8,500 Expenditures Vehicles Funding Sources Total Total Department Public Works: Streets/Traffic Contact Public Works Director Priority n/a Total Project Cost: 5195,000 2010 45,000 45,000 Equipment Replacement Fund 45,000 45,000 2011 51 2010 thru 2014 2012 2013 2014 Total Future 45,000 45,000 Total 2010 2011 2012 2013 2014 Total Future 45,000 150,000 150,000 45,000 Total Tuesday, August ll, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # Project Name 01 -ERP -308 Front End Loaders (2) Description Total Project Cost: 5530,100 Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $ Prior 140,000 Total Prior Type Equipment Useful Life 15 -18 years Category Equipment Future 140,000 Total Expenditures Equipment Funding Sources Total Equipment Replacement Fund Total 172,000 52 2010 thru 2014 Department Public Works: Streets/Traffic Contact Public Works Director Priority n/a 2010 2011 2012 2013 2014 Total Future 172,000 172,000 172,000 172,000 172,000 218,100 172,000 Total 2010 2011 2012 2013 2014 Total Future 218,100 172,000 Tatal Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -309 Project Name Skid Loader (2) Type Equipment Useful Life 12 years Category Equipment Future Description Department Public Works: Streets/Traffic Contact Public Works Director Priority n/a Total Project Cost: $188,900 Loading trucks, landscape work, snow removal, material handling. Justification Budget Impact/Other Variance from 20 year plan - increase cost by $5,000 to reflect actual. Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources 2010 36,000 Total 36,000 Equipment Replacement Fund 36,000 Total 36,000 2011 2010 2011 2012 2013 53 2010 thru 2014 2012 2013 2014 Total Future 36,000 36,000 152,900 36,000 - Total 2014 Total Future 152,900 36,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -311 Project Name Sweeper Description Justification Prior 115,300 Total Prior Type Useful Life Category Future 115,300 Total Equipment 12 years Equipment Expenditures Equipment Funding Sources Equipment Replacement Fund Department Public Works: Streets /Traffic Contact Public Works Director Priority n/a Total Project Cost: 5514,400 Street sweeping, event clean -up, spring sand removal. 2010 2011 54 2010 thru 2014 Street sweeper used by Streets Division for sweeping streets and parking lots. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $12,000 2012 2013 164,500 2014 Total Future 164,500 234,600 Total 164,500 164,500 Total 2010 2011 2012 2013 2014 Total Future 164,500 164,500 234,600 Total 164,500 164,500 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -312 Project Name Roller Type Equipment Useful Life 20 years Category Equipment Future Description Total Project Cost: $45,900 Used by Street Depat talent for asphalt repair and resurfacing. Justification Budget Impact/Other Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources Total Equipment Replacement Fund Total Department Public Works: Streets /Traffic Contact Public Works Director Priority n/a 2010 2011 2012 2013 2014 Total 2010 2011 2012 2013 2014 Total 55 2010 thru 2014 45,900 45,900 45,900 45,900 45,900 45,900 45,900 45,900 Tuesday, August 11, 2009 Description Total Project Cost: S48,800 Asphalt paver used by Streets Division of Public Works. Justification Paving streets and parking lots. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $500 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Type Equipment Useful Life 20 years Category Equipment Future Expenditures Equipment Funding Sources Equipment Replacement Fund 2010 2011 56 2010 thru 2014 Project # 01 -ERP -314 Project Name Asphalt Paver Department Public Works: Streets /Traffic Contact Public Works Director Priority n/a 2012 2013 2014 48,800 Total 48,800 Total 48,800 48,800 2010 2011 2012 2013 2014 Total 48,800 48,800 Total 48,800 48,800 Tuesday, 4ugust 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -316 Project Name Trailer Type Equipment Useful Life 20 years Category Equipment Future Description Used for transporting and hauling equipment and supplies. Justification Budget Impact/Other Variance from 20 year plan - move back from 2009 to 2010 Estiamte salvage /resale value on replaced item : $ Expenditures Equipment Funding Sources Total Department Public Works: Streets/Traffic Contact Public Works Director Priority n/a Total Project Cost: $4,900 2010 4,900 4,900 Equipment Replacement Fund 4,900 Total 4,900 2011 57 2010 thru 2014 2012 2013 2014 Total 4,900 4,900 2010 2011 2012 2013 2014 Total 4,900 4,900 Tuesday, August 11, 2009 Description Total Project Cost: S134,800 Unit utilitzed by Water, Sewer and Street Divisions of Public Works for repair and installation of underground utilities. Justification Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2010 thru 2014 Project # 01 -ERP -502 Project Name Backhoe Loader Type Equipment Useful Life 20 years Category Equipment Future Expenditures Equipment Funding Sources WF - Water Fund Total 2010 Department Water Contact Public Works Director Priority n/a 2011 58 2012 2013 134,800 134,800 2014 Total 134,800 134,800 2010 2011 2012 2013 2014 Total 134,800 134,800 Total 134,800 134,800 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -506 Project Name Public Works Copy Machine Type Useful Life Category Future Description Total Project Cost: S72,600 Copy machine to service needs of all division of Public Works. Justification Making copies for various departments. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $800 Prior 10,600 Total Prior 10,600 Total Equipment 5 years Equipment Expenditures Equipment 12,200 Funding Sources Total 12,200 WF - Water Fund 12,200 Department Water Contact Public Works Director Priority n/a 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 59 12,200 49,800 12,200 Total 2010 2011 2012 2013 2014 Total Future 12,200 49,800 Total 12,200 12,200 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -550 Project Name 4x4 3/4 Ton Truck Description Truck used by Water /Sewer Division of Public Works. Justification Snow plowing, light hauling, pulling trailers, general purpose transportation. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ Prior 26,600 Total Prior 26,600 Total Type Equipment Useful Life 10 years Category Vehicles Future Expenditures Vehicles Funding Sources SF - Sanitary Sewer Fund Total Total Department Sewer Contact Public Works Director Priority n/a Total Project Cost: 5110,300 2010 2011 2012 2013 2014 Total Future 60 2010 thru 2014 35,700 35,700 48,000 35,700 35,700 Total 2010 2011 2012 2013 2014 Total Future 35,700 35,700 48,000 1 35,700 35,700 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 01 -ERP -700 Project Name Engineering Van Description Prior 16,000 Total Prior 16,000 Total Type Equipment Useful Life 10 years Category Vehicles Future Expenditures Vehicles Funding Sources Total Equipment Replacement Fund 2010 Department Public Works: Engineering Contact Public Works Director Priority nia Total Project Cost: $66,400 Van used by Engineering Department for survey equipment and on job site work. Justification Transportation to and from job site, hauling of surveying and traffic counting equipment. Budget Impact/Other 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 2011 61 2010 thru 2014 2012 2013 21,500 21,500 2014 2010 2011 2012 2013 2014 21,500 21,500 Total Future 21,500 28,900 21,500 Total Total Future 28,900 Total 21,500 21,500 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -800 Project Name 1/2 Ton Pickup Truck Type Equipment Useful Life 10 years Category Vehicles Future Description Pickup used by Park Division of Public Works. Justification Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ Expenditures Vehicles Funding Sources Equipment Replacement Fund Total 26,400 Total Department Public Works: Parks/Forestry Contact Public Works Director Priority n/a Total Project Cost: 561,800 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 26,400 26,400 2010 2011 2012 2013 2014 Total Future 26,400 26,400 26,400 62 35,400 26,400 Total 35,400 26,400 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -801 Project Name 4x4 3 /4Ton Trucks (2) Type Equipment Useful Life 8 years Category Vehicles Future Description Trucks used by Parks Division of Public Works. Justification Snow plowing, hauling, transportation. Units are heavily used. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ Prior 53,200 Total Prior 53,200 Total Expenditures Vehicles Funding Sources Total Total Project Cost: 8313,800 63 2010 thru 2014 Department Public Works: Parks /Forestry Contact Public Works Director Priority n/a 2010 2011 2012 2013 2014 Total Future 67,400 67,400 67,400 193,200 67,400 Total 2010 2011 2012 2013 2014 Total Future Equipment Replacement Fund 67,400 67,400 I 193,200 Total 67,400 67,400 Total Tuesday, .4ugust 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -802 Project Name 3/4 Ton Utility Truck Type Useful Life Category Future Equipment 10 years Vehicles Description Total Project Cost: $75,600 3/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city. Justification Budget Impact/Other Variance from 20 year plan - move back from 2010 to 2011. Estimate salvage /resale value on replaced item: $ Expenditures Vehicles Funding Sources Total Total 2010 Department Public Works: Parks/Forestry Contact Public Works Director Priority n/a 2011 32,200 32,200 Equipment Replacement Fund 32,200 32,200 64 2010 thru 2014 2012 2013 2014 Total Future 32,200 32,200 43,400 32,200 Total 2010 2011 2012 2013 2014 Total Future 43,400 32,200 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # Project Name 01 -ERP -803 Swap Loader Type Equipment Useful Life 20 years Category Equipment Future Description Justification Expenditures Equipment Funding Sources Total 2010 Total 80,000 RF - Refuse Fund 80,000 Department Refuse Contact Public Works Director Priority n/a Total Project Cost: $80,000 Single axle truck with a slide rail system used to swap between various boxes and bodies. Utilitized by Refuse for hauling dumpsters and Forestry for chipping trees. Budget Impact/Other Variance from 20 year plan - move to 20 yr life; move from 2008 to 2010 with all costs to Refuse Fund.. Estimate salvage /resale value on replaced item: $ 80,000 80,000 2011 65 2010 thru 2014 2012 2013 2014 Total 80,000 80,000 2010 2011 2012 2013 2014 Total 80,000 80,000 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -806 Project Name Tractors (2) Type Equipment Useful Life 30 years Category Equipment Future Description Justification Expenditures Equipment Funding Sources 2010 2010 thru 2014 Department Public Works: Parks/Forestry Contact Public Works Director Priority n/a Total Project Cost: S87,900 Farm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration, plowing and grass seeding. Item purchased: 1982 & 1984 Budget Impact/Other Variance from 20 year plan - move from 2009 to 2012. Estimate salvage /resale value on replaced item: $3,500 2011 66 2012 41,400 2013 2014 46,500 Total 87,900 Total 41,400 46,500 87,900 2010 2011 2012 2013 2014 Total Equipment Replacement Fund 41,400 46,500 87,900 Total 41,400 46,500 87,900 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 01 -ERP -807 Project Name Trucksters (3) Prior Type Equipment Useful Life 15 years Category Equipment Future Description 29,900 Total Prior 29,900 Total Expenditures Equipment Funding Sources Total Equipment Replacement Fund Total Department Public Works: Parks /Forestry Contact Public Works Director Priority n/a Total Project Cost: $114,700 2010 thru 2014 Truckster used by Parks Division of Public Works for ballfield and parks maintenance. Justification Park maintenance, ballfield grooming and weed spraying. Budget Impact/Other Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $1,400 each 2010 2011 67 2012 19,800 19,800 2010 2011 2012 2013 2014 Total Future 19,800 19,800 I 65,000 19,800 2013 2014 Total Future 19,800 65,000 19,800 Total 19,800 Total Tuesday, .9ugust 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 14 01 -ERP -808 Project Name Riding Mowers (3) Type Equipment Useful Life 8 years Category Equipment Future Description Riding mowers used by Parks Divison of Public Works. One mower also used for sidewalk snow removal during winter months. Justification Mowing city parks and right of ways and sidewalk snow removal. Budget Impact/Other Variance from 20 year plan - move from 2009 to 2011 Estimate salvage /resale value on replaced item: $600 each Prior 49,000 Total Prior 49,000 Total Expenditures Equipment Funding Sources Equipment Replacement Fund 2010 thru 2014 Department Public Works: Parks/Forestry Contact Public Works Director Priority n/a Total Project Cost: $223,100 2010 2011 2012 2013 2014 Total Future 22,800 10,300 20,300 53,400 120,700 Total 22,800 10,300 20,300 53,400 Total 2010 2011 2012 2013 2014 Total Future 22,800 10,300 20,300 53,400 120,700 Total 22,800 10,300 20,300 53,400 Total 68 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -810 Project Name Large Turf Mower Description Justification Prior 50,000 Total Prior 50,000 Total Type Equipment Useful Life 10 years Category Equipment Future Expenditures Equipment Funding Sources Total 65,000 Equipment Replacement Fund 65,000 Total 2010 thru 2014 Department Public Works: Parks/Forestry Contact Public Works Director Priority n/a Total Project Cost: $207,700 Large turf mower (11' cutting width) used by Parks Division of Public Works. Required to efficiently plow large parks. Budget Impact/Other Variance from 20 year plan - move from 2011 to 2010 due to poor condition of existing mower.. Estimate salvage /resale value on replaced item: $3,500 2010 2011 2012 2013 2014 Total Future 65,000 65,000 69 65,000 92,700 65,000 Total 2010 2011 2012 2013 2014 Total Future 65,000 92,700 65,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -813 Project Name Brush Chipper Type Useful Life Category Future Description Justification Equipment 20 years Equipment 2010 thru 2014 Department Public Works: Parks /Forestry Contact Public Works Director Priority n/a Total Project Cost: $25,700 Brush chipper used for Forestry and brush pick up operations of Public Works. Budget Impact/Other Variance from 20 year plan - change to usable life to 20 years - move back from 2009 to 2013. Estimate salvage /resale value on replaced item: $ Expenditures Equipment Funding Sources Total Equipment Replacement Fund 2010 2011 2012 2013 2014 Total 2010 2011 2012 2013 2014 Total Total 25,700 25,700 70 25,700 25,700 25,700 25,700 25,700 25,700 Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Type Equipment Useful Life 10 years Category Vehicles Future Justification Department Refuse Contact Public Works Director Priority n/a 2010 thru 2014 Project # 01 -ERP -900 Project Name Refuse Truck (RAP -R) (2) Description Total Project Cost: S1,059,300 Refuse truck used by Refuse Utility Division of Public Works. Residential waste pick up. Budget Impact/Other Variance from 20 year plan - increase cost to reflect actual Estimate salvage /resale value on replaced item: $18,000 Prior 148,000 Total Prior 148,000 Total Expenditures Vehicles Funding Sources Total 2010 184,000 Total 184,000 RF - Refuse Fund 184,000 184,000 2011 71 2012 2013 2014 Total Future 184,000 184,000 727,300 184,000 Total 2010 2011 2012 2013 2014 Total Future 727,300 I 184,000 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -901 Project Name Refuse Truck (Rear -L) Type Equipment Useful Life 10 years Category Vehicles Future Description Refuse truck used by Refuse Utility Division of Public Works. Justification Residential waste pick up. Budget Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $9,000 Expenditures Vehicles Funding Sources RF - Refuse Fund Department Refuse Contact Public Works Director Priority n/a Total Project Cost: $238,200 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 101,600 101,600 136,600 Total 101,600 101,600 Total 2010 2011 2012 2013 2014 Total Future 101,600 101,600 136,600 Total 101,600 101,600 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -1000 Project Name Ice Resurfacer Type Equipment Useful Life 12 years Category Equipment Future Description Ice resurfacer used by the Pavilion for ice sheet maintenance. Justification Ice maintenance, ice removal and resurfacing of ice sheet during the indoor ice season. Budget Impact/Other Variance from 20 year plan - new item Estimate salvage /resale value on replaced item: $20,000 Prior Expenditures 2010 2011 2012 2013 2014 Total Future 60,0001 Equipment 88,100 88,100 125,600 Total Total 88,100 88,100 Total Prior 60,000 Total Funding Sources PA - Pavilion Fund Total Department Pavilion Contact Facilities Director Priority n/a Total Project Cost: S273,700 73 2010 thru 2014 2010 2011 2012 2013 2014 Total Future 88,100 88,100 88,100 i 125,600 88,100 Total Tuesday, August 11, 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project# 01 -ERP -1100 Project Name Arts Center Copy Machine Type Equipment Useful Life 7 years Category Equipment Future Description Justification Prior 8,500 Total Prior 8,500 Total Expenditures Equipment Funding Sources Total Total Department Arts Center Contact Facilities Director Priority n/a Total Project Cost: 853,800 Copy machine capable of enlarging and producing double sided, collated and stapled copies. Used to duplicate reports, letters, signs, flyers and rental information. Budget Impact/Other Variance from 20 year plan - increase by $2,000 to reflect actual cost, Estimate salvage /resale value on replaced item: $ 2010 2011 12,100 12,100 HCA - Arts Center Fund 12,100 12,100 74 2010 thru 2014 2012 2013 2014 Total Future 12,100 33,200 12,100 Total 2010 2011 2012 2013 2014 Total tu 12,100 33,200 12,100 Total Tuesday, August 11, 2009 20 Year Replacement Schedule N 0 0 O 0 0 0 0 — M O 00 00 W L'V 0 0 r.` 0 0 0 0 0 co O 0 00 0 o o o o o o 00 0 O O 00 00 O O O o o O O O O o o o o 0 0 r" o O 0 0 O O O O O 0 00 O O O O O O O O o d' 0 0 0 o o O o 00 O O 0 0 O 0 o o 0 o 0 0 0 00 '0 o 0 0 O o o o o o G o 0 O O o o 0 0 0 o o 00 M 00 .0 01 000 C�yi 0 0 0 Cy W W. 0 0 O O O O O O O O O , 00 0 00 en o 000 0 0 m N O h O M J` 'D 0 0 0 0 d' 0 O d O 0 0 0 0 0 o h 0 o , m r` o 7 oo 0 0 0 0 0 0 0 O 0 0 0 0 0 O 0 0 0 0 0 0 0 0 O O , N N N cV oo M J d' N 0 0 O rn 0 0 0 0 0 0 01 0 0 O O 0 01 � b 0 0 O O . 0 0 c 0 0 '0 7 C 0 0 0 0 O 01 0 0 0 0 O 01 0 0 0 0 G en O N 0 01 - N N N '0 0 O O 0 0 0 0 0 0 0 O 01 m - N - b 0 0 0 0 0 0 o 01 01 N 'V 00 0 0 0 0 0 0 N 0 00 O 0 0 0 0 h 0 0 0 0 0 0 0 0 0 o 01 o 00 N 0 0 r O r -- 00 0 ? 01 01 01 vl m O N r 00 0 0 0 0 0 — O O O O O C 0. 0. 000000000 0 0 N N O 0 0 0 r O 01 N N O i0 10 00 0 0 0 r 0 0 0 0 v1 01 N o 0 a 0 0 0 - 0 O , , N O h m, O 0 00 O1 N O r O O O N - N 0 7 v v1 t N • N 00 r _ N N 01 00 r N 00 ° o — 00 N d h N N N 0 N N 0 -- M, 10 — 0 0 0 0 N 00 W W W W W O 0 0 G O O O 00 00 N r` r` o 0 0 N a W N • 0 - 0 N M 0 O O O G O O O O U N 00 a0 r` — N rn 0 O O O C O O r m r O O O O r 0 0 0 0 0 0 0 0 o d rr m O O O 0 fJ O 01 0 0 0 0 00 m` M, r 0 0 0 0 0 0 0 0 N O N 00 00 r 0 0 0 0 O O O 01 h vi -- C 0 0 O O 01 '0 01 0 00 01 0 0 N N 00 01 01 01 M 0 N r 00 0 r N m 00 01 .0 r 00 P 0 N 0 0 7 0 N N C4 P. CI 0. U7 0.' FC L 4 R. [G Py W W W W W W W W W W W W W W O 0 0 00 0 0 0 0 0 h 0 0 00 0 0 rn O 0 O o C • W .N.. ••'- u E 01 F O 0 E '2 L n O Z? e.) 0 a lF A u , + a N q . �, w / N " 7 , �„ g,, v o ff, W � F3 0 F yl w w Vl _' — � a a a a O d N m y. E. Y T GL G N -5-,', n G b L W W W F W 2 G U O a V 0' E- U F Q p 'U 2 to . f s o s o o '- o .0 E F 'F T o d 0, > U 7. 0 E $ o o s 3 s d o _ v p o ° F o 0 0 0 0 y o W mLE07.3 1-. 4. ¢ W US - E. 3333L13 r 0 0 0 0 0 0 0 o N 00' 00 r 0 0 0 0 0 M M 01 — 10 N N ri N M N N M r 7 0 0 0 0 0 0 U 01 0+ ✓ r r 7 7 7 0 0 YJ 00 re ,, 7 7 0 0 0 O O O 0 7 7 r 0 0 r r 0 0 O O 0 0 0 O O 0 0 0 0 01 0 00 n r0 00 7 N N N 7 O O O O 0 0 O N 00 0 7 7 0 0 0 0 7 7 0 n O 0 0 0 0 0 0 0. U N 7 O oo N 00 O N M 0 0 0 0 O 0 00 7 O r r r N M M M M N 0 0 r 00 0 0 0 0 M M 7 M O O O O O O 0 O 0 O 0 0 , ' C 00 00 7 00 M, N O 0 O 0 0 0 O 0 N N 0 M M N M M 00 M M 00 7 0 0 0 0 y N • <Q • " • O o F , .5 CO • 51 > U 7 iy r ? U • 0 m m 0 '° .5 .5 F 0 w 1 Q �o 5 Q.�> 00 01 00 01 0 a c 0 0 0 0 0 0— N M 7 7 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N CJ N N N N 0 0 0 0 0 0 0 0 01 N 00 o 10 00 00 - 0 0 0 0 00 N N r N 00 0r N O 0 0 0 O 0 0 0 N r O 00 N h O0 — 0 0 0 0 0 0 r N O O 00 v1 0 0 0 O O W h O 0 0 0 O O O O N N O O 0` 00 N 0) M 7 — O 0 0 0 O O O N N O r■-■ m = 0o O 0 0 0 0 0 0 0 N r O CO N h 0 0 0 0 0 0 v, re, o r N N 00 01 N N 7 O O O O 0 00 N 0 0 0 0 0 0 0 0 0• N 00 0 0 00 7 — 01 O 0 0 O O r N 01 • 0 0 00 0r 0 0 — M N O O O 00 O O O 0 O O 0 N 00 01 00 0 — 0 0 0 0 0 0 N r o 0o r` 0 0 0 0 N O N o0 N 0 O O 0 0 '0 0 N 'U O o`00 N of N M 7 O 0 0 0 O O 0 O 00 N N 00 0 O O O O O O O 0 O N r 0 00 00 CJ N O 0 N 00 0 0 0 0 — N M 7 N 0000000,4N ��14WW0000 w UWWUWWW O Vi O 0 0 CO 0 O 0 0 O O O O_ O 0 O 00 O N GO O 00 00 O O O O O O' 0 7 0 O N 0 0 0 0 O O O 7 0 0 00 O O 00 N 0 0 r M N N N N 0 .a 0 o F z v y 0 U F 4 v = a z -w O Ti 5 T o _ o ' a A U V 3 2 Q F 0 0 N 7 0 O CC 0 00 0 O N C 00 O O o o O O O G O C O O 0 V 0 (V N 0 ' 'Y 'Y '- 0' 0 0 0 0 C-- M M M o o O O O 0 0 0 0 0 O O - o O O O 0' O ^ N 7 N V 0 r M1 r CO 00 CO 0\ o -- N M V N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 co 0? CO CO 07 CO 00 00 CO 00 CO CO CO CO 00 CO CO 00 00 00 CO W°dLQW0W w 00 ex°0a�°00 0 W w w w w w w W W w W w W w w w w w w w 0 0 0 0 v 0 0 N N O w w F g 7 ° 3 m 'D v) 2 ° 3 a W 0. ' c 0 � a = - t U E ,,, N v 7 M 3 Q E- F F F F .G v) a E rn m H Or 0 0 C 0 0 0 00 4 V N 0 O O N O O O O N O O O O 00 r � a M M O O V O O h O O O G O O lV O O O o+ 7 0 0 0 0 0 0 N O Y V M. Cr' d co 0 0 0 0 cn N M 0 C O O 4 m" — t O O O O O O O O V O O 9 r h (0 V 0 CO 00 0 N 0 0 0 N 01 N 00 0 0 co N 0 N 0 0 N N 0 00 N N 0 00 r M1 r r 0 N 00 0 0 0 0 0 00 0 0 0 0 O -- N M M r N N CO c0 0 — 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 tit M M t�1 [fit . c!1 M M 2 2 M 2 M M NI a 0 00000000 w w w w w w w w w w w w w w w 0 w w w w w w w w 0 O r N O O O O 0' O O V O O 0 O O N M s F 0 o u 2 2,s.m O t [ X J ,y F F U U n U U 6 6 4 F 4 a I-- F F c E F. F, v 1 L 0 i a o. m m U vi 0 0 O a n p 0 v- g u. 33 t" 3 s a F F `E o K x Q A 2 v -o v o u U F c Q P] v Q m m F j w _o t o q ` v 2 O O O > 5 0 b "d U G C 'b b 'D 4. N 3 F F F ❑ ❑ ^ ' > It v v — — — c7) - 65 F F 3 [ . v; r r 0 v i i g rn a ri F` v ; a } 00 00 C O o O 0 O 0 m� 0 0 0 0 00 P N 00 0 os O 00 00 O O l0' O O N O O C O N 00 O O 00 r_ 0 0 0 0 00 00 00 00 O 0 O O 0 0 O O 01 00 00 O O 00 O O co 00 O O N E F w ->4' o»0 , E o F c p E Tr; m rn F F - U o 00 Q U F 00 0 0 0 0 r 00 b J N O O O O O O O 0> 0 0 N._ O O O N O O O O a0 rn 0 00 N O O co 0 4 a 0 E F o O o 0 j O M F c c m o V . v in :; C7 U F cat O O O O 00 os O O h 0 0 0 00 ` n 00 0 0 0 0 0 0 00 N N - N N J N N 0 0 N 00 0 0 r 0 N ,n 0 n r r 0 0— a r 0 0 0 0 0 0 0 0 01 .n 01 �n 0 0 0 0 0 0 0 00 u {0 0 0 0 0 1 0 p N y H 00 N x00 00 00 p4 0 0 P '2,‘ Oi 00 0 0 >0 W 00 L 00 U1 00 W L L 0 W 14 00 00 00 W 0 >0 Lu V O C O O P O O 0 0 0 C 00 0 N h N o N b O N O N 7 O M 0 N N O O N O N T O 00 N N 0 N 7 0 N M O O o o 0 0 rn h 1 r O O O O O O O O .o h r r co o r m o r 00 O 7 CO 7 N 7 7 • m N h V 0 0 0 0 0 0 O 0 0 0 r 00 0 00 0 0 0 N O N M 0 0 7 N 0 h o0 N 7 M N N r CO h O O O O O O O O O N O N O 04 0 O N 7 7 h 0 0 O T O 0 N N 7 2 7 n 0 7 00 O O 0 O O r 00 V1 0 OG - H 10 O r O 0 0 O O O 0 0 0 O M O J' M 0 00 0 M 0 7 7 0 0 00 M 7 M N 00 O 7 CO 00 00 N O O O 0 0 O O O O O O 0 0 0 0 0 0 O O O 0 0 7 7- 0 00 0 0 0 0 0 N M .6 ,..6 v - rt O O h 7 N 7 — 00 7 0O N N 7 7 m O O O O O o O O O 01 7 0 00 0 m M V m— O 7 00 0 O 7 N N 0 h 0 h 7 m 0 0 0 0 0 0 0 0 O 0 0 (4 00 O N rz o 'Co" 0 7 a M N 01 V1 '0 0 0 0 0 0 0 0 0 0 0 01 - 01 00 r' V 0 N O 0 '0 N - 0 7 '0 a N O— — N r 7 t. r 0 0 0 0 0 0 0 Q1 00 00 O 01 10 7 0 0 0 0 h �- 0 0 7 00 r 0 0 0 0 0 0 0 0 0 — O — 00 V O\ r h r 7 T -- 7 c 7 00 00 7 0; 0'0 701 ■ o"r a\ M — 01 01 01 en — h M 7 0 m h e� O h 0 0 0 — 0 0 0 r 7 N — — '" co a 0 N r O m 1 o 7 - h- 0 0 0 0 — 0 0 0 0 0 O 7 7 O 00 00 00 00 00 N 0 - 0 0 0 0 0 0 O 00 r 0o - v 0 r -- 0 7 ^1 0 m — N 01 t 0 0 r N 0 M 7 — M— 7 N h 7 r O 7 - N - r - o h N N fV 00 W r O 01 V 0 N N h O O N 00 O N r m 0 0 0 0 0 0 0 0 J V' 0 0 r1 0" M M 7 0\ S 0 0 0 0 0 0 r en M r O h 00 7 00 O v1 03 0 7 m r N O r I 0 h 0 0 0 h w a 0 0o " 0 M 0 h 7 7 0 CO r- 0 h 00 00 10 V O Cr, V r 10 N O 7 M 00 0 - o O 7 0 N N 00 0 00 o -- 0 0 0 0 7 0 00 h O h O O 0 00 \0 O 0 O M 0 h h . - 0 M 0 S 0 h o — a 0 00 M M co O co h O h CS. 0 h it 0 01 0 m M Q 7 0 0 0 0 0 0 0 0 0 0 0 0 o 00 0 0 O en O N O 0 C 0 'O O 0 0 (4 10 00 O 00 0' 00 N 7 (4 01 00 7 N h M 7 0 10 7 0 0 0' 01 7 0 0 00 0 r 0 01 0 0 0 0 0 0 0 0 h 0 0 0 0 0 0 0 0 0 0 0 0 0 N n. 0 - 0 7 0- 0 0 co r 7 h 0, 7 m 10 O O a" p 0 000 4 .0 7 .0 .0 O 10 10 0 O r M M N h 10 0 0 00 r 01 00 v1 01 r 01 01 N h 7 F 01 0 7 h 0 h r1 01 0 — N 0 7 O O O O O O O O 7 00 M on m 40 h M N v.) 1 M N N N 00- 0� O — M, O r 41 eel 7 0 0 O h 0 0 h 0 0 — 01 0 h 7 7 V m N ' m .. N F Z g F O — z F P. Z I W O d a a. m cn O Q F d Q F z^? Z o'. u d E c 0 Q F z E ? a L' 10 � a a Q F a } O F Q a d T Q z uzcG u4, >" >o ° nw Pw E-, z Q � ,e, Z en '� c., Q Q Q a F F h C Q U v 4 z a — ? a F F= F 3 ul r z �' d Q 3 a w , ¢ J g -? Z a o z > - yac' . wwU �- u da; � -+aa: , '� F >I ¢' Ci U .a C7 'Z w w m u `� w a C J O �-' O _ 00 a g z 4 F w w 0 03 0 4 1 w O 4 F- 4 U O L :, o, a a. a7 w a : 000 5 4 3 rn g 0n a; a Equipment and Building Inventory UNIT # YEAR FIRE DEPARTMENT 102. 103. 104. 105. 106. 107. 108. 109 112. 115. 120. 121. 200. 201. 202. 203. 204. 205. 206. 208. 209. 211. 212. 213. 214. 216. 217. 218. 240. 241. 1989 2006 1991 1998 2004 1993 1995 2008 2006 1952 1995 2005 POLICE DEPARTMENT 2004 2008 2008 2005 2007 2007 2007 2007 2005 2006 2008 2003 2007 2005 2008 2006 1998 2001 CITY OF HOPKINS VEHICLE /EQUIPMENT INVENTORY 07/15/2009 MAKE FORD L9000 PETERBILT PETERBILT FORD FORD PETERBILT CHEV PIERCE DODGE MACK CHEVROLET FREIGHTLINER FORD FORD FORD FORD FORD FORD FORD FORD FORD JEEP CHEV CHEV DODGE CHEV FORD FORD CHEV CHRYSLER 80 MODEL TELE - SQUIRT PUMPER HEAVY RESCUE CROWN VICTORIA CROWN VICTORIA PUMPER 4X4 LITE RESCUE AERO XT DURANGO PUMPER SUBURBAN M2 CROWN VICTORIA CROWN VICTORIA CROWN VICTORIA CROWN VICTORIA CROWN VICTORIA CROWN VICTORIA CROWN VICTORIA CROWN VICTORIA CROWN VICTORIA LIBERTY TAHOE IMPALA CHARGER IMPALA TAURUS 500 P40 VAN PT CRUISER CURRENT REPLACEMENT COST $240,000 403,300 190,000 22,000 28,100 225,000 25,000 845,000 28,300 4,000 $28,100 28,100 28,100 28,160 29,000 29,000 29,000 29,000 30,000 18,800 36,000 25,000 28,000 20,000 22,000 21,800 20,000 18,000 UNIT # YEAR STREET /TRAFFIC DIVISION 301. 302. 304. 305. 307. 309. 310. 312. 313. 314. 315. 316. 320. 322. 324. 325. 326. 327. 330. 337. 342. 344. 348. 349. 350. 351. 1997 2006 2000 1997 2006 1995 1989 2005 2001 1998 1996 1995 1991 2005 2004 1998 1989 2001 1989 1994 1991 1996 1989 1989 1993 2004 ENGINEERING DIVISION 700. 2000 CHEV 705. 2002 CHEV CITY OF HOPKINS VEHICLE /EQUIPMENT INVENTORY 07/15/2009 MAKE CHEV FORD FORD FORD FORD CHEV INTERNATIONAL FREIGHTLINER FORD FORD FORD FORD CATERPILLER CATERPILLER BOBCAT JOHN DEERE CATERPILLAR ELGIN INGERSOL/RAND CATERPILLAR TARGET SNOGO TRAIL -KING TRAIL -KING TOWMASTER TENNANT 81 MODEL 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 MK6V -1200 T14 SWEEPER 3640 SUBURBAN IMPALA CURRENT REPLACEMENT COST $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 3,000 4,000 10,000 $14,500 $18,800 UNIT # YEAR BUILDING & EQUIPMENT SERVICES 703. 2002 CHEV 704. 2005 FORD MAKE 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. 845. 846. 2001 2004 2004 1998 1993 2006 1989 1984 1982 1996 1987 2004 2004 2001 1996 2001 2004 2001 1997 2004 1993 1991 1997 2001 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 07/1 5/2009 FORD FORD FORD DODGE INTERNATIONAL INTERNATIONAL FORD FORD FORD TORO CUSHMAN TORO TORO TORO TORO TORO TORO DEW EZE VERMEER BOBCAT BRUSH BANDIT RYAN VICTORIAN REMACKEL DRESSEN 82 TAHOE F250 MODEL RANGER 4X4 F350 F350 RAM 3500 LP 4700 LP 4600 LOG TRUCK AERIAL LIFT TRACTOR 2910 TRACTOR 2610 TRUCKSTER HAULSTER WORKMAN 3200 WORKMAN 2110 325 -D MOWER GROUND MASTER 455 -D MOWER Z587L ATM72 STUMP CTR 630A SKID LOADER CHIPPER 250 SOD CUTTER TRAILER TRAILER 8110 CURRENT REPLACEMENT COST $5,000 24,000 $18,000 23,000 23,000 24,000 50,000 45,000 60,000 22,000 22,000 13,000 5,000 15,000 7,900 18,000 $16,000 40,000 8,900 21,000 15,400 22,000 14,000 2,000 2,000 5,000 2,000 UNIT # YEAR MAKE 411. 2007 CHEV WATER/SEWER 500. 501. 502. 505. 506. 530. 533. 534. 535. 536. 540. 542. REFUSE PAVILION 2007 2004 1999 2007 2006 2001 1993 1997 1992 1989 2008 1994 CHEV CHEV DODGE CHEV CHEV STERLING CATERPILLAR KOHLER KOHLER FLEXIBLE LEROI WACKER 901. 2005 PETERBILT 902. 1999 VOLVO 903. 1995 FREIGHTLINER 801. 1996 CHEV 809. 2003 OLYMPIA CITY OF FIOPKINS VEHICLE /EQUIPMENT INVENTORY 07/15/2009 83 2500 HD 320 WX42 FL -70 4X4 TRK MODEL PICKUP 4X4 3/4 T SILVERADO DAKOTA 4X4 CC25753 SILVERADO VAC -CON LDR -BKHOE -446 GENERATOR/TRL GENERATOR/TRL RODDING MACHINE AIR COMPRESSOR TAMPER CURRENT REPLACEMENT COST $17,500 $22,000 19,000 18,000 24,000 20,700 180,000 50,000 11,000 10,000 25,000 12,000 4,000 $162,000 150,000 54,000 $19,100 ICE RESURFACER 85,000 Location/Description Replacement Cost 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 PW Cold Storage Bldg #1 117 -121 17th Avenue S. PW Cold Storage Bldg #2 117 -121 17th Avenue S. Moline Reservoir 10421 Excelsor Boulevard Blake Tower Reservoir 151 Tyler Avenue S. Well #1 Filtration Plant 10421 Excelsior Boulevard Filtration Plant 1401 Elmo Park Service Road Well #4 Workshop /Storage 1401 Elmo Park Service Road Well #5 1205 Highway? CITY OF HOPKINS BUILDING INVENTORY July 2009 84 $3,370,837 3,801,157 4,091,653 1,324,718 4,404,998 5,439,674 6,217,636 379,281 480,187 1,613,617 806,810 208,424 1,391,782 283,492 114,299 Location/Description Replacement Cost Well #6 801 Highway 7 114,299 Lift Station #1 - 21st 107,574 202 21st Avenue N. Lift Station #2 - Drillane 100,852 619 Drillane Road Lift Station #3 - Lindee's 94,129 901 Cambridge Street N.E. Lift Station #4 - LTL Meadowbrook 147,915 244 Meadowbrook Road Lift Station #5 - Big Meadowbrook 221,872 6601 Excelsior Blvd. Lift Station #6 - Ronnie's 147,915 8546 Excelsior Avenue E. Lift Station #7 - Valley 195,146 801 6th Avenue S. Band Shell - Downtown Park 34,138 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 15.598 220 Homedale Avenue 85 Location/Description Replacement Cost Park Building - Oakes 38,996 301 Tyler Avenue N. Park Building - Valley 46,401 800 7th Avenue S. Dow Towers (76 Units) 22 5th Avenue S. 20th Avenue Townhouses (10 Units) 29 20th Avenue S. Parking Ramp 10th Avenue and Mainstreet Depot Coffee House 9451 Excelsior Boulevard Overpass Skate Park 100 Washington Avenue 86 HRA HRA 4,409,208 469,400 7,331