Loading...
2013 - 2017 ERP EQUIPMENT REPLACEMENT PLAN 2013-2017 DATE: August 2012 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager 2013-2017 EQUIPMENT REPLACEMENT PLAN SUBJECT: With this letter, I respectfully submit the 2013-2017 Equipment Replacement Plan. This five-year planning document represents the combined efforts of city staff and the City Council. The Equipment Replacement Plan is a five-year forecast of equipment replacement needs in the City of Hopkins.It is intended to alert the Council and citizens of equipment replacement needs that are needed to maintain the efficiency of city services and the safety of city staff. The first year of the plan becomes the adopted budget, however the equipment is again re-evaluated before final approval is given for the purchase. The remaining four years represents estimated replacement needs and the related funding. The Equipment Replacement Plan does not include proposed capital projects. A document relating specifically to capital project needs has been developed into a separate document. The Equipment Replacement Plan is intended to serve as a planning tool and is therefore structured to present a meaningful, long-range perspective of the city’s equipment needs over the next 20 years. At the same time sufficient details on individual pieces of equipment scheduled for replacement is provided to enable those who review the information to make informed decisions of the city’s equipment needs over the next several years. Please use the information provided to assist in the understanding of the city’s equipment needs as they relate to the delivery of service to the citizens of Hopkins. This document was developed by the Finance Department with the assistance of all city departments. I wish to especially thank all those involved in the development of the Equipment Replacement Plan, and especially Steve Stadler, Public Works Director, Mike Reynolds, Police Chief, Connie Kurtz, Police Administrative Services Director, Dale Specken, Fire Chief, Christine Harkess, Finance Director and Deb Dahlheimer, Sr. Finance Clerk for their hard work and dedication. 1 EQUIPMENT REPLACEMENT PLAN 2013-2017 TABLE OF CONTENTS Page City Manager's Message 1 Table of Contents 2 Introduction Background and Summary of Changes from 2012 Plan4 Cash Flow Statements Equipment Replacement Fund 9 Chart - Revenues, Expenditures & Working Capital10 Five-Year Project Summaries Projects by Year12 Department Summary15 Projects by Department16 Funding Source Summary19 Projects by Funding Source20 Equipment Requests Individual Equipment Request Details24 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department95 Equipment and Building Inventory Vehicle and Equipment Inventory101 Building Inventory105 2 INTRODUCTION 3 EQUIPMENT REPLACEMENT PLAN 2013-2017 BACKGROUND AND SUMMARY OF CHANGES FROM 2012 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 $845,400. The cash flow requirements to fund equipment needs in the equipment replacement fund, will experience a roller coaster effect over the next 20 years given the projected equipment needs and 3% inflation rate. After reducing the intragovernmental charges by 50% in 2003 in response to the LGA cuts, charges were increased 2% in 2004 and 9% in 2006 and were not increased again until 2010 when they were raised by 2% and again by 5% in 2012. This has resulted in a steady decline in the working capital of the fund. In order to start building cash reserves annual increases are built into the cash projections beginning in 2014 with an 8% increase and continuing forward with increases of 9% over the next 4 years. Originally a 6 % increase was planned for 2013, however due to budget constraints of the General Fund that absorbs the majority of the charges at 99% of rates charged, we eliminated the increase scheduled for 2013. The majority of items purchased with ERP funds are used by departments within the General Fund which accounts for the most of the operations of the city. Intergovernmental charges are at 61% of what they were in 2002 and at the current rate structure will not return to that level until 2021. In the last decade due to changes in technology and the way we operate there is more equipment in the plan; however the rate has not increased to accommodate the increase in equipment. Equipment that was purchased with grants such as digital squad cameras, laptop computers in squad cars and fire vehicles, AED’s, infrared cameras and fitness equipment in the fire hall fitness room now are included in the ERP. The long term viability of the fund remains questionable and will result in difficult decisions regarding equipment and operations which were discussed at length during the period leading up to the preparation of the 2013 ERP. As discussed above we eliminated the rate increase for 2013, changed the scheduled increased for 2014-2017 to 9% each year and plan to sell Equipment Certificates to fund some of the equipment needs scheduled for 2013 and 2014. This will allow us to replace aging equipment and spread the payments over 10 years. While we have the option to place the debt service requirements on the tax levy we have opted to included them in the annual operating expenses of the Equipment Replacement Fund. If at any time the rates are not adequate we do have the option of putting a portion or all of the debt service needs on the tax levy. Currently it is not our intention to do so. 4 Each year staff re-evaluates the equipment needs and adjusts the schedule accordingly. Changes to the plan are reflected in the document. Refurbishments, extended life expectancy and closer cost estimates of replacements have been incorporated into the plan. The equipment replacement charges in the general fund represent approximately 2.8% of total general fund expenditures. The Equipment Replacement Plan’s basic premise is scheduled replacement of present equipment. A new item must, in the year proposed, be presented in the annual operating budget 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 2012 Plan Highlights of changes from last year’s equipment replacement plan for the years 2013-2017: Activity Center: There are no changes to Activity Center items in this ERP. Arts Center: A theater projector was added in 2013 for $6,000. This unit will have higher lumens and HDMI connectivity and will allow the unit to be controlled from the control booth. A community room audio visual unit was added in 2014 for $11,000. This will be mounted from the ceiling and available for those renting this space. City Hall: Document scanners (3) were budgeted at $6,500 per year on a three year rotation. The number was reduced to two and put on a five year replacement schedule starting in 2015 at a cost of $11,300 for two. Community Services: There are no changes to Community Services items in this ERP. Fire: The air compressor was moved up from 2017 to 2016 at a cost of $24,900. The current unit is showing its age. In 2016 self-contained breathing apparatus (SCBA) (45) was added to the ERP at a cost of $250,000. The current units will have met their mandated life expectancy and will need to be replaced. The Fire Department was working on a grant for the SCBA’s, however that did not work out so the item was added to the ERP. Staff is working on purchasing these through a multi-jurisdictional agency that will provide us with some savings over the amount budgeted in the ERP. HRA There are no changes to HRA items in this ERP. Pavilion: The ice resurfacer and edger were moved from 2014 to 2013 as these items are being financed with the Equipment Certificates that are being sold in 2012. 5 Parking:There are no changes to the Parking Dept. items in this ERP. Police:Mobile Data Cameras scheduled for 2013 at a cost of $57,000 moved to 2014. Prior to 2013 the Taser’s were not included in the ERP. They were added in 2013 at a cost of $18,600 with a four year life to be replaced again in 2017. Public Works: The lives of the equipment are annually reviewed by the public works department and over the past 10 years they have extended the lives of the 1-ton trucks from 8 to 12 years and the dump trucks from 13 to 17 years. Extending the lives of major equipment comes with the risk of increased maintenance costs. When maintenance costs become unmanageable the equipment will be put on the schedule for earlier replacement. Engineering The engineering vehicle originally scheduled for 2013 was moved back to 2014 and the cost reduced from $21,500 to $2,000. The police Tahoe will be transferred to Engineering and there is minimal cost to refurbish the vehicle for non-police use. Parks/Forestry After an analysis of the riding mowers the two riding mowers scheduled for 2013 and 2014 were moved to 2014 and 2015 and the cost on the one scheduled for 2014 was reduced from $22,800 to $11,000 to purchase a zero turn mower rather than a Groundsmaster and the one scheduled for 2015 was reduced from $30,600 to $20,000 eliminating one mower and accounting for the Groundsmaster. The third mower was removed from the plan. Streets/Traffic After evaluation of the two 4x4 ¾ ton pickup trucks in the ERP the following changes were made: A 4x4 ¾ ton pickup with plow (ERP-0300) totaling $33,600 was moved from 2015 to 2013 and the cost reduced to $21,500. A 4x4 ¾ ton pickup with plow (ERP-0301) totaling $30,400 was moved from 2013 to 2015. Due to new equipment in that is available in street sweeping the following changes were made to the street sweeper replacement program: A mechanical sweeper scheduled for replacement in 2013 at a cost of $156,400 was moved back to 2021 and will be replaced every 20 years. This sweeper requires two people to operate, 6 one to drive the sweeper and one to drive a truck that the material collected is dumped into for disposal. In addition this sweeper needs water to wet the material that is picked up. A regenerative sweeper was added in 2013 at a cost of $185,000 on a 20-year replacement. This sweeper is a vacuum type sweeper and is a more efficient machine in that it can be used by a single person and uses no water. Refuse There are no changes to refuse department items in this ERP. Water There are no changes to water department items in this ERP. Sewer There are no changes to sewer department items in this ERP. 7 CASHFLOWSTATEMENT 8 EQUIPMENT REPLACEMENT FUND (602)07/27/2012 Impact on General Fund028,93835,16038,32341,773 ate Change 3%5%0%8%9%9%9% R BUDGETBUDGETBUDGETBUDGETBUDGETBUDGETBUDGET 2011201220132014201520162017 921,83145,149 Working Capital Begin Yea r 890,1891,364,161 898,102 668,938 5 15,342 ges302,012443,524 Revenues from char 317,113 317,113 342,482 373,305 4 06,902 Transfer in General Fund50,00050,000 50,000 Transfer In - Pavilion - Capital Lease20,000 20,000 15,609 Transfer In - Pavilion - Hockey Loa3,143 n 3,143 3,143 3,142 Interest earnings6,66213,7609,100 9,021 6 ,808 5 ,272 570 Other revenues (sale of assets)42,34330,000 199,462 25,000 30,000 30,000 30,000 Equipment Certificates (Bonds)804,4001,000,000 Total Revenues374,1601,474,094 1,353,138 374,625 434,723 460,113 4 92,175 Expenditures (excludes Depr.) (1)23,99518,79820,541 18,250 19,361 19,942 21,157 Fire Truck Financing Pymnts (2009-2018)53,874 5 4,217 5 4,217 5 4,217 5 4,217 5 4,217 5 4,217 Adj - Fire Quick Attach Pumper245,000 Capital Outlay - Equipment327,933414,001 561,700 703,300 497,500 447,500 7 96,400 2012 Equip Certificate Pymnts (10yr 3%)64,370 9 2,810 9 2,050 9 1,210 9 5,290 Total Expenses405,802584,664 879,167 840,684 663,888 613,709 9 62,367 Working Capital Ending Balance934,579 8 90,189 1,364,161 898,102 668,938 515,342 4 5,149 909,977527,21946,454 Actual/Estimated Cash balances902,0641,376,03 66 680,812 57,024 9 ЋЉЉЌЋЉЉЍЋЉЉЎЋЉЉЏЋЉЉАЋЉЉБЋЉЉВЋЉЊЉЋЉЊЊЋЉЊЋЋЉЊЌЋЉЊЍЋЉЊЎЋЉЊЏЋЉЊА /ğƦźƷğƌ wĻǝĻƓǒĻƭ 9ǣƦĻƓƭĻƭ ‘ƚƩƉźƓŭ ƚƷğƌƚƷğƌ /ğƦźƷğƌ ‘ƚƩƉźƓŭ ğƓķ 10 9ǣƦĻƓƭĻƭ wĻǝĻƓǒĻƭͲ 9wt ЊͲБЉЉͲЉЉЉЊͲЏЉЉͲЉЉЉЊͲЍЉЉͲЉЉЉЊͲЋЉЉͲЉЉЉЊͲЉЉЉͲЉЉЉБЉЉͲЉЉЉЏЉЉͲЉЉЉЍЉЉͲЉЉЉЋЉЉͲЉЉЉ FIVEYEAR PROJECTSUMMARIES 11 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20132017 thru PROJECTS BY YEAR Project NameProject #Priority Project Cost Department 2013 Art Center Kitchen Catering EquipmentArts Center01-ERP-1102n/a5,000 Art Center Theater ProjectorArts Centern/a6,000 01-ERP-1104 Network ServerCity Hall Administrationn/a8,000 01-ERP-0003 ComputersCity Hall Administrationn/a30,000 01-ERP-0006 Election EquipmentCommunity Servicesn/a50,000 01-ERP-0011 Aerial TruckFiren/a54,217 01-ERP-0106 Thermal Imaging Camera (2)Firen/a11,500 01-ERP-0112 Ice ResurfacerPavilion01-ERP-1000n/a180,000 Electric Ice EdgerPavilion01-ERP-1001n/a5,000 Marked Patrol Vehicles (6)Police01-ERP-0200n/a71,200 Police Administrative Vehicles (2)Police01-ERP-0204n/a29,600 LOGIS Computer SystemPolice01-ERP-0208n/a200,000 Network Server (3)Police01-ERP-0211n/a8,500 Tactical Ballistic VestsPolice01-ERP-0214n/a23,200 Taser ReplacementPolice01-ERP-0217318,600 1/2 Ton Pickup TruckPublic Works: Parks/Forestryn/a26,400 01-ERP-0800 Trucksters (3)Public Works: Parks/Forestryn/a19,800 01-ERP-0807 Brush ChipperPublic Works: Parks/Forestryn/a25,700 01-ERP-0813 4x4 3/4 Ton Pickup with PlowPublic Works: Streets/Trafficn/a21,500 01-ERP-0300 Regenerative Air SweeperPublic Works: Streets/Trafficn/a185,000 01-ERP-0319 Backhoe LoaderWatern/a75,000 01-ERP-0502 1,054,217 Total for 2013 2014 Art Center Community Room Audio VisualArts Center01-ERP-1105n/a11,000 Network ServerCity Hall Administration01-ERP-0003n/a8,000 ComputersCity Hall Administration01-ERP-0006n/a30,000 Aerial TruckFire01-ERP-0106n/a54,217 Automated External Defibrillator (2)Fire01-ERP-0120n/a7,200 Workout Equipment - Dumb BellsFiren/a5,000 01-ERP-0122 HRA CopierHRAn/a13,000 01-ERP-0401 Marked Patrol Vehicles (6)Policen/a73,400 01-ERP-0200 Utility 4x4 (unit 212)Policen/a47,700 01-ERP-0203 Police Administrative Vehicles (2)Policen/a30,500 01-ERP-0204 Logging RecorderPolicen/a36,900 01-ERP-0210 Network Server (3)Police01-ERP-0211n/a8,500 Mobile Data ComputersPolice01-ERP-0212n/a62,700 Digital Squad Car CamerasPolice01-ERP-0213n/a53,400 Engineering VanPublic Works: Engineering01-ERP-0700n/a2,000 3/4 Ton Utility TruckPublic Works: Parks/Forestry01-ERP-0802n/a32,200 Riding Mowers (2)Public Works: Parks/Forestry01-ERP-0808n/a11,000 RollerPublic Works: Streets/Traffic01-ERP-0312n/a45,900 Asphalt PaverPublic Works: Streets/Traffic01-ERP-0314n/a48,800 Refuse Truck (Rear-L)Refusen/a101,600 01-ERP-0901 Wednesday, August 15, 2012 12 Project NameProject #Priority Project Cost Department 4x4 3/4 Ton TruckSewer01-ERP-0550n/a35,700 718,717 Total for 2014 2015 Network ServerCity Hall Administration01-ERP-0003n/a8,000 Telephone SystemCity Hall Administration01-ERP-0004n/a89,600 ComputersCity Hall Administration01-ERP-0006n/a30,000 Document Management Scanner (2)Community Services01-ERP-0008n/a11,300 Duty Chief VehicleFire01-ERP-0103n/a37,000 Aerial TruckFire01-ERP-0106n/a54,217 Workout Equipment - ElipticalFire01-ERP-0116n/a5,800 Workout Equipment - Summit TrainerFire01-ERP-0117n/a5,800 Workout Equipment - Weight LiftingFiren/a5,800 01-ERP-0119 4x4 3/4 Ton TruckHRAn/a32,400 01-ERP-0400 Marked Patrol Vehicles (6)Policen/a75,600 01-ERP-0200 Sergeant's VehiclePolicen/a37,800 01-ERP-0201 Police Administrative Vehicles (2)Policen/a31,400 01-ERP-0204 Police Services Liaison VehiclePolicen/a25,000 01-ERP-0206 Network Server (3)Police01-ERP-0211n/a8,500 Riding Mowers (2)Public Works: Parks/Forestry01-ERP-0808n/a20,000 4X4 3/4 Ton Truck with PlowPublic Works: Streets/Traffic01-ERP-0301n/a30,400 Sign Machine (Traffic)Public Works: Streets/Traffic01-ERP-0317n/a13,400 Refuse Truck (RAP-R) (2)Refuse01-ERP-0900n/a204,800 726,817 Total for 2015 2016 Network ServerCity Hall Administration01-ERP-0003n/a8,000 ComputersCity Hall Administrationn/a30,000 01-ERP-0006 Fire Utility Vehicle (Pick Up Truck)Firen/a35,000 01-ERP-0105a Aerial TruckFiren/a54,217 01-ERP-0106 Air CompressorFiren/a34,900 01-ERP-0107 Self Contained Breathing Apparatus (45)Firen/a250,000 01-ERP-0108 Floor ScrubberFiren/a14,300 01-ERP-0114 Marked Patrol Vehicles (6)Police01-ERP-0200n/a77,800 Parking Enforcement Vehicle (Parking Fund)Police01-ERP-0202n/a27,200 Police Administrative Vehicles (2)Police01-ERP-0204n/a32,400 SWAT VehiclePolice01-ERP-0205n/a30,000 Copy Machine - Police DeptPolice01-ERP-0209n/a22,100 Network Server (3)Police01-ERP-0211n/a8,500 TractorPublic Works: Parks/Forestry01-ERP-0806n/a49,300 Slope MowerPublic Works: Parks/Forestryn/a32,700 01-ERP-0809 Skid Loader (2)Public Works: Streets/Trafficn/a41,900 01-ERP-0309 Snow BlowerPublic Works: Streets/Trafficn/a102,300 01-ERP-0315 3/4 Ton Utility TruckSewern/a33,600 01-ERP-0551 884,217 Total for 2016 2017 Refrigerator/FreezerActivity Center01-ERP-0031n/a1 Art Center Video Camera UpdatesArts Center01-ERP-1103n/a3,700 Network ServerCity Hall Administration01-ERP-0003n/a8,000 ComputersCity Hall Administration01-ERP-0006n/a30,000 Aerial TruckFire01-ERP-0106n/a54,217 Thermal Imaging Camera (2)Fire01-ERP-0112n/a12,900 Workout Equipment - TreadmillFire01-ERP-0118n/a5,800 Wednesday, August 15, 2012 13 Project NameProject #Priority Project Cost Department Marked Patrol Vehicles (6)Police01-ERP-0200n/a80,200 Police Administrative Vehicles (2)Policen/a33,300 01-ERP-0204 Network Server (3)Policen/a8,500 01-ERP-0211 Taser ReplacementPolice320,900 01-ERP-0217 Stump CutterPublic Works: Parks/Forestryn/a21,200 01-ERP-0812 Skid LoaderPublic Works: Parks/Forestryn/a32,000 01-ERP-0815 Water TruckPublic Works: Streets/Trafficn/a150,000 01-ERP-0307 StriperPublic Works: Streets/Traffic01-ERP-0313n/a11,200 Generator (2)Sewer01-ERP-0555n/a26,400 1/2 Ton TruckWater01-ERP-0500n/a26,800 3/4 Ton Utility TruckWater01-ERP-0501n/a34,900 560,018 Total for 2017 3,943,986 GRAND TOTAL Wednesday, August 15, 2012 14 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20132017 thru DEPARTMENT SUMMARY Department20132014201520162017Total Activity Center11 Arts Center11,00011,0003,700 25,700 City Hall Administration38,00038,000127,60038,00038,000 279,600 Community Services50,00011,300 61,300 Fire65,71766,417108,617388,41772,917 702,085 HRA13,00032,40045,400 Pavilion185,000185,000 Police351,100313,100178,300198,000142,9001,183,400 Public Works: Engineering2,000 2,000 Public Works: Parks/Forestry71,90043,20020,00082,00053,200 270,300 Public Works: Streets/Traffic206,50094,70043,800144,200161,200 650,400 Refuse101,600204,800306,400 Sewer35,70033,60026,40095,700 Water75,00061,700136,700 1,054,217718,717726,817884,217560,0183,943,986 TOTAL 15 Wednesday, August 15, 2012 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20132017 thru PROJECTS BY DEPARTMENT DepartmentProject#Priority20132014201520162017 Total Activity Center Refrigerator/Freezern/a01-ERP-003111 11 Activity Center Total Arts Center Art Center Kitchen Catering Equipmentn/a5,000 01-ERP-11025,000 Art Center Video Camera Updatesn/a3,700 01-ERP-11033,700 Art Center Theater Projectorn/a6,000 01-ERP-11046,000 Art Center Community Room Audio Visualn/a11,000 01-ERP-110511,000 25,700 11,00011,0003,700 Arts Center Total City Hall Administration Network Servern/a01-ERP-00038,0008,0008,0008,0008,00040,000 Telephone Systemn/a01-ERP-000489,60089,600 Computersn/a01-ERP-000630,00030,00030,00030,00030,000150,000 38,00038,000127,60038,00038,000279,600 City Hall Administration Total Community Services Document Management Scanner (2)n/a11,300 01-ERP-000811,300 Election Equipmentn/a50,000 01-ERP-001150,000 50,00011,30061,300 Community Services Total Fire Duty Chief Vehiclen/a01-ERP-010337,00037,000 Fire Utility Vehicle (Pick Up Truck)01-ERP-0105an/a35,00035,000 Aerial Truck01-ERP-0106n/a54,21754,21754,21754,21754,217271,085 Air Compressor01-ERP-0107n/a34,90034,900 Self Contained Breathing Apparatus (45)n/a250,000 01-ERP-0108250,000 Thermal Imaging Camera (2)n/a11,50012,900 01-ERP-011224,400 Floor Scrubbern/a14,300 01-ERP-011414,300 Workout Equipment - Elipticaln/a5,800 01-ERP-01165,800 Workout Equipment - Summit Trainern/a5,800 01-ERP-01175,800 Workout Equipment - Treadmilln/a5,800 01-ERP-01185,800 Workout Equipment - Weight Lifting01-ERP-0119n/a5,8005,800 Automated External Defibrillator (2)01-ERP-0120n/a7,2007,200 Workout Equipment - Dumb Bells01-ERP-0122n/a5,0005,000 702,085 65,71766,417108,617388,41772,917 Fire Total HRA 4x4 3/4 Ton Truckn/a01-ERP-040032,40032,400 HRA Copiern/a13,000 01-ERP-040113,000 16 Wednesday, August 15, 2012 DepartmentProject#Priority20132014201520162017 Total 13,00032,40045,400 HRA Total Pavilion Ice Resurfacern/a01-ERP-1000180,000180,000 Electric Ice Edgern/a5,000 01-ERP-10015,000 185,000185,000 Pavilion Total Police Marked Patrol Vehicles (6)n/a71,20073,40075,60077,80080,200 01-ERP-0200378,200 Sergeant's Vehiclen/a37,800 01-ERP-020137,800 Parking Enforcement Vehicle (Parking Fund)n/a27,200 01-ERP-020227,200 Utility 4x4 (unit 212)n/a47,700 01-ERP-020347,700 Police Administrative Vehicles (2)01-ERP-0204n/a29,60030,50031,40032,40033,300157,200 SWAT Vehicle01-ERP-0205n/a30,00030,000 Police Services Liaison Vehicle01-ERP-0206n/a25,00025,000 LOGIS Computer System01-ERP-0208n/a200,000200,000 Copy Machine - Police Dept01-ERP-0209n/a22,10022,100 Logging Recorder01-ERP-0210n/a36,90036,900 Network Server (3)n/a8,5008,5008,5008,5008,500 01-ERP-021142,500 Mobile Data Computersn/a62,700 01-ERP-021262,700 Digital Squad Car Camerasn/a53,400 01-ERP-021353,400 Tactical Ballistic Vestsn/a23,200 01-ERP-021423,200 Taser Replacement318,60020,900 01-ERP-021739,500 351,100313,100178,300198,000142,9001,183,400 Police Total Public Works: Engineering Engineering Vann/a01-ERP-07002,0002,000 2,0002,000 Public Works: Engineering Total Public Works: Parks/Forestry 1/2 Ton Pickup Truckn/a01-ERP-080026,40026,400 3/4 Ton Utility Truckn/a32,200 01-ERP-080232,200 Tractorn/a49,300 01-ERP-080649,300 Trucksters (3)n/a19,800 01-ERP-080719,800 Riding Mowers (2)n/a11,00020,000 01-ERP-080831,000 Slope Mowern/a32,700 01-ERP-080932,700 Stump Cuttern/a21,200 01-ERP-081221,200 Brush Chipper01-ERP-0813n/a25,70025,700 Skid Loader01-ERP-0815n/a32,00032,000 270,300 71,90043,20020,00082,00053,200 Public Works: Parks/Forestry Total Public Works: Streets/Traffic 4x4 3/4 Ton Pickup with Plown/a01-ERP-030021,50021,500 4X4 3/4 Ton Truck with Plown/a30,400 01-ERP-030130,400 Water Truckn/a150,000 01-ERP-0307150,000 Skid Loader (2)n/a41,900 01-ERP-030941,900 Rollern/a45,900 01-ERP-031245,900 Stripern/a11,200 01-ERP-031311,200 Asphalt Pavern/a48,800 01-ERP-031448,800 Snow Blower01-ERP-0315n/a102,300102,300 Sign Machine (Traffic)01-ERP-0317n/a13,40013,400 Regenerative Air Sweeper01-ERP-0319n/a185,000185,000 17 Wednesday, August 15, 2012 DepartmentProject#Priority20132014201520162017 Total 206,50094,70043,800144,200161,200650,400 Public Works: Streets/Traffic Total Refuse Refuse Truck (RAP-R) (2)n/a01-ERP-0900204,800204,800 Refuse Truck (Rear-L)n/a101,600 01-ERP-0901101,600 101,600204,800306,400 Refuse Total Sewer 4x4 3/4 Ton Truckn/a35,700 01-ERP-055035,700 3/4 Ton Utility Truckn/a33,600 01-ERP-055133,600 Generator (2)n/a26,400 01-ERP-055526,400 95,700 35,70033,60026,400 Sewer Total Water 1/2 Ton Truckn/a01-ERP-050026,80026,800 3/4 Ton Utility Truckn/a01-ERP-050134,90034,900 Backhoe Loadern/a01-ERP-050275,00075,000 75,00061,700136,700 Water Total 1,054,217718,717726,817884,217560,0183,943,986 GRAND TOTAL 18 Wednesday, August 15, 2012 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20132017 thru FUNDING SOURCE SUMMARY 20132014201520162017Total Source AC - Arts Center Fund11,00011,0003,70025,700 Bonds/Lease54,21754,21754,21754,21754,217 271,085 Equipment Replacement Fund729,000497,500421,800796,400414,0012,858,701 HRA - Housing and Redevelopment Authority13,00032,400 45,400 PA - Pavilion Fund185,000185,000 PKG - Parking Fund5,7005,700 RF - Refuse Fund101,600204,800 306,400 SF - Sanitary Sewer Fund35,7006,80033,60026,400102,500 WF - Water Fund75,0006,80061,700 143,500 1,054,217718,717726,817884,217560,0183,943,986 GRAND TOTAL Wednesday, August 15, 2012 19 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20132017 thru PROJECTS BY FUNDING SOURCE SourceProject#Priority20132014201520162017Total AC - Arts Center Fund Art Center Kitchen Catering Equipmentn/a5,000 01-ERP-11025,000 Art Center Video Camera Updatesn/a01-ERP-11033,7003,700 Art Center Theater Projector01-ERP-1104n/a6,0006,000 Art Center Community Room Audio Visual01-ERP-1105n/a11,00011,000 25,700 11,00011,0003,700 AC - Arts Center Fund Total Bonds/Lease Aerial Truckn/a01-ERP-010654,21754,21754,21754,21754,217271,085 54,21754,21754,21754,21754,217271,085 Bonds/Lease Total Equipment Replacement Fund Network Servern/a01-ERP-00038,0008,0008,0008,0008,00040,000 Telephone Systemn/a01-ERP-000476,00076,000 Computers01-ERP-0006n/a30,00030,00030,00030,00030,000150,000 Document Management Scanner (2)01-ERP-0008n/a11,30011,300 Election Equipment01-ERP-0011n/a50,00050,000 Refrigerator/Freezer01-ERP-0031n/a11 Duty Chief Vehicle01-ERP-0103n/a37,00037,000 Fire Utility Vehicle (Pick Up Truck)01-ERP-0105an/a35,00035,000 Air Compressorn/a34,900 01-ERP-010734,900 Self Contained Breathing Apparatus (45)n/a250,000 01-ERP-0108250,000 Thermal Imaging Camera (2)n/a11,50012,900 01-ERP-011224,400 Floor Scrubbern/a14,300 01-ERP-011414,300 Workout Equipment - Elipticaln/a5,800 01-ERP-01165,800 Workout Equipment - Summit Trainern/a5,800 01-ERP-01175,800 Workout Equipment - Treadmill01-ERP-0118n/a5,8005,800 Workout Equipment - Weight Lifting01-ERP-0119n/a5,8005,800 Automated External Defibrillator (2)01-ERP-0120n/a7,2007,200 Workout Equipment - Dumb Bells01-ERP-0122n/a5,0005,000 Marked Patrol Vehicles (6)01-ERP-0200n/a71,20073,40075,60077,80080,200378,200 Sergeant's Vehicle01-ERP-0201n/a37,80037,800 Parking Enforcement Vehicle (Parking Fund)01-ERP-0202n/a27,20027,200 Utility 4x4 (unit 212)01-ERP-0203n/a47,70047,700 Police Administrative Vehicles (2)n/a29,60030,50031,40032,40033,300 01-ERP-0204157,200 SWAT Vehiclen/a30,000 01-ERP-020530,000 Police Services Liaison Vehiclen/a25,000 01-ERP-020625,000 LOGIS Computer Systemn/a200,000 01-ERP-0208200,000 Copy Machine - Police Deptn/a22,100 01-ERP-020922,100 Logging Recordern/a36,900 01-ERP-021036,900 Network Server (3)n/a8,5008,5008,5008,5008,500 01-ERP-021142,500 Mobile Data Computers01-ERP-0212n/a57,00057,000 Wednesday, August 15, 2012 20 SourceProect#Priorit20132014201520162017Total jy Digital Squad Car Camerasn/a01-ERP-021353,40053,400 Tactical Ballistic Vestsn/a23,200 01-ERP-021423,200 Taser Replacement318,60020,900 01-ERP-021739,500 4x4 3/4 Ton Pickup with Plown/a21,500 01-ERP-030021,500 4X4 3/4 Ton Truck with Plown/a30,400 01-ERP-030130,400 Water Truckn/a150,000 01-ERP-0307150,000 Skid Loader (2)n/a41,900 01-ERP-030941,900 Roller01-ERP-0312n/a45,90045,900 Striper01-ERP-0313n/a11,20011,200 Asphalt Paver01-ERP-0314n/a48,80048,800 Snow Blower01-ERP-0315n/a102,300102,300 Sign Machine (Traffic)01-ERP-0317n/a13,40013,400 Regenerative Air Sweeper01-ERP-0319n/a185,000185,000 Engineering Vann/a2,000 01-ERP-07002,000 1/2 Ton Pickup Truckn/a26,400 01-ERP-080026,400 3/4 Ton Utility Truckn/a32,200 01-ERP-080232,200 Tractorn/a49,300 01-ERP-080649,300 Trucksters (3)n/a19,800 01-ERP-080719,800 Riding Mowers (2)n/a11,00020,000 01-ERP-080831,000 Slope Mowern/a32,700 01-ERP-080932,700 Stump Cutter01-ERP-0812n/a21,20021,200 Brush Chipper01-ERP-0813n/a25,70025,700 Skid Loader01-ERP-0815n/a32,00032,000 729,000497,500421,800796,400414,0012,858,701 Equipment Replacement Fund Total HRA - Housing and Redevelopment A 4x4 3/4 Ton Truckn/a01-ERP-040032,40032,400 HRA Copiern/a13,000 01-ERP-040113,000 13,00032,40045,400 HRA - Housing and Redevelopment Authority Total PA - Pavilion Fund Ice Resurfacern/a180,000 01-ERP-1000180,000 Electric Ice Edgern/a5,000 01-ERP-10015,000 185,000185,000 PA - Pavilion Fund Total PKG - Parking Fund Mobile Data Computersn/a01-ERP-02125,7005,700 5,700 5,700 PKG - Parking Fund Total RF - Refuse Fund Refuse Truck (RAP-R) (2)n/a204,800 01-ERP-0900204,800 Refuse Truck (Rear-L)n/a101,600 01-ERP-0901101,600 101,600204,800306,400 RF - Refuse Fund Total SF - Sanitary Sewer Fund Telephone Systemn/a01-ERP-00046,8006,800 4x4 3/4 Ton Truckn/a01-ERP-055035,70035,700 Wednesday, August 15, 2012 21 SourceProect#Priorit20132014201520162017Total jy 3/4 Ton Utility Truckn/a01-ERP-055133,60033,600 Generator (2)n/a26,400 01-ERP-055526,400 35,7006,80033,60026,400102,500 SF - Sanitary Sewer Fund Total WF - Water Fund Telephone Systemn/a01-ERP-00046,8006,800 1/2 Ton Truck01-ERP-0500n/a26,80026,800 3/4 Ton Utility Truck01-ERP-0501n/a34,90034,900 Backhoe Loader01-ERP-0502n/a75,00075,000 143,500 75,0006,80061,700 WF - Water Fund Total 1,054,217718,717726,817884,217560,0183,943,986 GRAND TOTAL Wednesday, August 15, 2012 22 EQUIPMENTREQUESTS 23 EQUIPMENT REPLACEMENT PLAN 20132017 thru Department City Hall Administration Cit of Hokins MN yp, ContactFinance Director/IT TypeEquipment 01-ERP-0003 Project # Useful Life 1 year Network Server Project Name Category Equipment FuturePriority n/a Total Project Cost: $233,000 Description The network server is the hub of the network. New computers are faster and more reliable. Justification Networking allows user to share information that is stored in a single location, the network server. This is more efficient because the information does not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every user is working with the same data. PriorExpendituresTotal 20132014201520162017Future Equipment 8,0008,0008,0008,0008,00040,000 81,000112,000 8,0008,0008,0008,0008,00040,000 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 8,0008,0008,0008,0008,00040,000 81,000 Equipment Replacement Fund 112,000 8,0008,0008,0008,0008,00040,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 24 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentCity Hall Administration Cit of Hokins MN yp, Contact IT Director Type Equipment 01-ERP-0004 Project # Useful Life 8 years Telephone System Project Name Category Equipment FuturePriorityn/a Total Project Cost:$349,900 Description Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) PriorExpendituresTotal 20132014201520162017Future Equipment 89,60089,600 60,000200,300 89,60089,600 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 76,00076,000 60,000 Equipment Replacement Fund 200,300 6,8006,800 SF - Sanitary Sewer Fund TotalTotal 6,8006,800 WF - Water Fund 89,60089,600 Total Budget Impact/Other Variance from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 25 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentCity Hall Administration Cit of Hokins MN yp, Contact Finance Director/IT Type Equipment 01-ERP-0006 Project # Useful Life 3-5 years Computers Project Name Category Equipment FuturePriorityn/a Total Project Cost:$930,000 Description Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Justification Tools enabling staff to perform job responsibilities efficiently and effectively. PriorExpendituresTotal 20132014201520162017Future Equipment 30,00030,00030,00030,00030,000150,000 360,000420,000 30,00030,00030,00030,00030,000150,000 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 30,00030,00030,00030,00030,000150,000 360,000 Equipment Replacement Fund 420,000 30,00030,00030,00030,00030,000150,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 26 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentCommunity Services Cit of Hokins MN yp, Contact City Clerk Type Equipment 01-ERP-0008 Project # Useful Life 3 years Document Management Scanner (2) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$109,200 Description Large document (11” x17”) scanner for document management and retention as well as general administrative use. Two scanners replaced every three years. Purchased two scanners in 2012 at a cost of $10,315 - Look to replace in three years. Scanners will be evaluated every three years for replacement. If scanners are working properly their life will be extended. Justification Current scanners were repaired many times and are beyond end of life per IT. Excess time was spent by IT keeping the scanners working. PriorExpendituresTotal 20132014201520162017Future Equipment 11,30011,300 23,30074,600 11,30011,300 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 11,30011,300 23,300 Equipment Replacement Fund 74,600 11,30011,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Two new scanners purchased in 2012 and will be replaced every three years. Previously scanners had been repaired. Estimate salvage/resale value on replaced item: $500-$1,000 Wednesday, August 15, 2012 27 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentCommunity Services Cit of Hokins MN yp, Contact City Clerk Type Equipment 01-ERP-0011 Project # Useful Life 10 years Election Equipment Project Name Category Equipment FuturePriorityn/a Total Project Cost:$117,200 Description Replace election M-100 ballot scanners and ballot boxes. - 9 machines total. Justification All Hennepin County equipment is being replaced in 2013. ExpendituresTotalFuture 20132014201520162017 Equipment 50,00050,000 67,200 50,00050,000 TotalTotal Funding Sources20132014201520162017TotalFuture 50,00050,000 Equipment Replacement Fund 67,200 50,00050,000 TotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 28 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentActivity Center Cit of Hokins MN yp, Contact Facilities Director Type Equipment 01-ERP-0031 Project # Useful Life 30 years Refrigerator/Freezer Project Name Category Equipment FuturePriorityn/a Total Project Cost:$10,501 Description Commerical, stainless steel refrigerator and freezer. Justification Cooling/freezing needed for programs or by use of the participants and their activities. Present unit was here when activity center opened in 1980. This unit was part of the old South Jr. High cafeteria kitchen. The unit continues to have problems due to the age of the unit. PriorExpendituresTotal 20132014201520162017 Equipment 11 10,500 11 TotalTotal PriorFunding Sources20132014201520162017Total 11 10,500 Equipment Replacement Fund 11 TotalTotal Budget Impact/Other Variance from 20 year plan - Delayed indefinetly. Will use and repair as necessary. Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 29 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0103 Project # Useful Life 5 years Duty Chief Vehicle Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$254,200 Description A marked passenger vehicle for use by the Duty Chief and Assistant Chiefs in transporting required equipment, reference materials and personnel for emergency response, and routine Fire Department business. Curent vehicles: 2010 Chevrolet Tahoe (#110) (Chief) 2006 Dodge Durango (#100) (Asst. Chief) 2003 Chevrolet Impala (#101) (Asst. Chief) to be replaced with 2015 SUV Justification Used by the Fire Chief and Asst. Chiefs when responding to fires and other emergencies. Used for official business in and out of the city and for fire fighter travel on official Fire Department business. Eventually 3 SUV's - replaced every 5 years with 15 year life. New - chief, cycle down to Asst. Chief 1 and Asst. Chief 2. PriorExpenditures20132014201520162017TotalFuture Vehicles 37,00037,000 64,500152,700 37,00037,000 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 37,00037,000 64,500 Equipment Replacement Fund 152,700 37,00037,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Add 2 vehicles and change life to 15 years. Estimate salvage/resale value on replaced item: $4,000 Wednesday, August 15, 2012 30 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0105a Project # Useful Life 5 years Fire Utility Vehicle (Pick Up Truck) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$177,100 Description A pickup truck on a 4 wheel drive chassis. Current vehicle: 1998 Chevrolet Lumina (#106) - used by Fire Inspector Justification With getting rid of our light rescue, we will be losing a way to haul equipment back and forth from the fire scene to the station. This vehicle would be used to haul equipment and personnel to and from the scene and can be used for people to go to schools. ExpendituresTotalFuture 20132014201520162017 Vehicles 35,00035,000 142,100 35,00035,000 TotalTotal Funding Sources20132014201520162017TotalFuture 35,00035,000 Equipment Replacement Fund 142,100 35,00035,000 TotalTotal Budget Impact/Other Variance from 20 year plan - Change from 10 year life to 5 years. Estimate of salvage/resale value on replace item - $ Wednesday, August 15, 2012 31 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0106 Project # Useful Life 20 years Aerial Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$2,559,597 Description One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on 2008 purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23. Current vehicle: 2008 Pierce Arrow XT Aerial Ladder (#109) Justification Vehicle was purchased in 2008 at a total cost of $870,427.08 including mounted equipment. Vehicle was paid using $445,427.08 in ERP cash and a 10-year capital lease of $425,000. At the end of the lease term payments (P&I) will total $542,170. Total costs of aerial including cash payments equals $987,597. PriorExpendituresTotal 20132014201520162017Future Equipment 54,21754,21754,21754,21754,217271,085 662,2951,626,217 54,21754,21754,21754,21754,217271,085 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 54,21754,21754,21754,21754,217271,085 662,295 Bonds/Lease 1,626,217 54,21754,21754,21754,21754,217271,085 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 32 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0107 Project # Useful Life 15 years Air Compressor Project Name Category Equipment FuturePriorityn/a Total Project Cost:$89,300 Description Justification ExpendituresTotalFuture 20132014201520162017 Equipment 34,90034,900 54,400 34,90034,900 TotalTotal Funding Sources20132014201520162017TotalFuture 34,90034,900 Equipment Replacement Fund 54,400 34,90034,900 TotalTotal Budget Impact/Other Variance from 20 year plan - move back to 2017 Estimate salvage/resale value on replaced item - $ Purchased: 1996 Wednesday, August 15, 2012 33 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0108 Project # Useful Life 10 years Self Contained Breathing Apparatus (45) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$752,000 Description Breathing apparatus for interior firefighting for firefighters. Justification The breathing apparatus was taken out of the ERP in 2006 because we thought we were getting a grant. Grant was not successful. The SCBA's (45) need to be replaced because they are at the end of their life and cannot be hydro tested any longer. PriorExpendituresTotal 20132014201520162017Future Equipment 250,000250,000 166,000336,000 250,000250,000 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 250,000250,000 166,000 Equipment Replacement Fund 336,000 250,000250,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 34 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0112 Project # Useful Life 10 years Thermal Imaging Camera (2) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$72,200 Description Used by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and heat may be hidden allowing for faster extinguishment. Note: purchased 2003 & 2007 Justification Current camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was purchased with donation money. PriorExpendituresTotal 20132014201520162017Future Equipment 11,50012,90024,400 15,00032,800 11,50012,90024,400 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 11,50012,90024,400 15,000 Equipment Replacement Fund 32,800 11,50012,90024,400 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - department owns 2 cameras. Previously one one was included in the replacement plan. This will add to the replacement schedule the camera purchased from the Fire Dept budget in 2003. Estimate salvage/resale value on repalced item: $-0- Wednesday, August 15, 2012 35 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0114 Project # Useful Life 12 years Floor Scrubber Project Name Category Equipment FuturePriorityn/a Total Project Cost:$34,600 Description Floor scrubber to keep apparatus floors clean. Current equipment: 2004 Tennant 5400 Justification Scrubber is used to keep apparatus floors clean so that floor will last longer. ExpendituresTotalFuture 20132014201520162017 Equipment 14,30014,300 20,300 14,30014,300 TotalTotal Funding Sources20132014201520162017TotalFuture 14,30014,300 Equipment Replacement Fund 20,300 14,30014,300 TotalTotal Budget Impact/Other Variance from 20 year plan - Eliminate sweeper and add $ to scrubber as scrubber is used more. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 36 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0116 Project # Useful Life 6 years Workout Equipment - Eliptical Project Name Category Equipment FuturePriorityn/a Total Project Cost:$20,300 Description Workout equipment used in Fire Department workout room. One eliptical machine replaced on a 6 year cycle, one every 3 years. Justification This equipment is available to all City employees for health and wellness. ExpendituresTotalFuture 20132014201520162017 Equipment 5,8005,800 14,500 5,8005,800 TotalTotal Funding Sources20132014201520162017TotalFuture 5,8005,800 Equipment Replacement Fund 14,500 5,8005,800 TotalTotal Budget Impact/Other Variance from 20 year plan - had two eliptical machines in the ERP. One was replaced along with the stairmaster with a summit trainer. The remaining eliptical is scheduled for replacement in 2015. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 37 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0117 Project # Useful Life 5 years Workout Equipment - Summit Trainer Project Name Category Equipment FuturePriorityn/a Total Project Cost:$34,300 Description Workout equipment used in Fire Department workout room. One summit trainer replaced on a 5 year cycle. Current equipment : 2010 Summit Trainer Justification This equipment is available to all City employees for health and wellness. PriorExpendituresTotal 20132014201520162017Future Equipment 5,8005,800 5,00023,500 5,8005,800 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 5,8005,800 5,000 Equipment Replacement Fund 23,500 5,8005,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - replaces stairmaster. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 38 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0118 Project # Useful Life 5 years Workout Equipment - Treadmill Project Name Category Equipment FuturePriorityn/a Total Project Cost:$25,300 Description Workout equipment used in the Fire Department workout room. One treadmill replaced on a 5 year cycle. Justification This equipment is available to all City employees for health and wellness. PriorExpendituresTotal 20132014201520162017Future Equipment 5,8005,800 5,00014,500 5,8005,800 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 5,8005,800 5,000 Equipment Replacement Fund 14,500 5,8005,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back one year from 2011 to 2012. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 39 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0119 Project # Useful Life 5 years Workout Equipment - Weight Lifting Project Name Category Equipment FuturePriorityn/a Total Project Cost:$29,300 Description Smith machine - weight lifting machine. Justification For use by Police, Fire, Public Works, City staff to keep in shape to perform job duties and stay healthy. Current machine will be 7 years old in 2012. Suggested replacement is every 5 years. ExpendituresTotalFuture 20132014201520162017 Equipment 5,8005,800 23,500 5,8005,800 TotalTotal Funding Sources20132014201520162017TotalFuture 5,8005,800 Equipment Replacement Fund 23,500 5,8005,800 TotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2011 to 2015 Estimate salvage/resale value on replaced items: $ Wednesday, August 15, 2012 40 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0120 Project # Useful Life 3 years Automated External Defibrillator (2) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$49,100 Description Defibrillator is used to help get someones heart restarted during a cardiac arrest. Own 2 - both are replaced at one time due to changing technology. Current equipment: 2010 - 4 AEDs 2010 ERP had 2 AEDs schedule for replacement at $6,000. Four were purchased. Justification With changes in technology, the AED's should be replaced every four years. Cost - $3,000 per unit PriorExpenditures20132014201520162017TotalFuture Equipment 7,2007,200 6,00035,900 7,2007,200 TotalTotalTotal PriorFunding Sources20132014201520162017Total Future 7,2007,200 6,000 Equipment Replacement Fund 35,900 7,2007,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - adjustment from 3 years to 4 years. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 41 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0122 Project # Useful Life 10 years Workout Equipment - Dumb Bells Project Name Category Equipment FuturePriorityn/a Total Project Cost:$11,700 Description Workout equipment used in Fire Department workout room. Justification Current dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead based plaint. This purchase would update our dumb bells to the current type fitness bells. ExpendituresTotalFuture 20132014201520162017 Equipment 5,0005,000 6,700 5,0005,000 TotalTotal Funding Sources20132014201520162017TotalFuture 5,0005,000 Equipment Replacement Fund 6,700 5,0005,000 TotalTotal Budget Impact/Other Variance from 20 year plan - Move back from 2012 to 2014. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 42 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0200 Project # Useful Life 3 years Marked Patrol Vehicles (6) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$2,620,100 Description Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. Fleet consists of 6 patrol vehicles - 5 marked, 1 unmarked. Current vehicles: (3) 2011 Ford Crown Victorias, (2) 2010 Ford Crown Victorias, (1) 2009 Ford Crown Victoria Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. PriorExpendituresTotal 20132014201520162017Future Vehicles 71,20073,40075,60077,80080,200378,200 706,9001,535,000 71,20073,40075,60077,80080,200378,200 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 71,20073,40075,60077,80080,200378,200 706,900 Equipment Replacement Fund 1,535,000 71,20073,40075,60077,80080,200378,200 TotalTotalTotal 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 Wednesday, August 15, 2012 43 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0201 Project # Useful Life 4 years Sergeant's Vehicle Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$276,400 Description Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. 4 year rotation. Current vehicle: 2011 Ford Crown Victoria Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. PriorExpendituresTotal 20132014201520162017Future Vehicles 37,80037,800 33,600205,000 37,80037,800 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 37,80037,800 33,600 Equipment Replacement Fund 205,000 37,80037,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none. Estimate salvage/resale value on replaced item: $3,500 each Wednesday, August 15, 2012 44 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0202 Project # Useful Life 10 years Parking Enforcement Vehicle (Parking Fund) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$82,500 Description Parking enforcement vehicle. Current vehicle: 2006 Jeep Liberty (#211) Justification Use by parking enforcement officers in the course of their duties enforcing parking regulations in the downtown area. PriorExpendituresTotal 20132014201520162017Future Vehicles 27,20027,200 18,70036,600 27,20027,200 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 27,20027,200 18,700 Equipment Replacement Fund 36,600 27,20027,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - amount allocated is not sufficient. Increase to $27,200. Estimate salvage/resale value on replaced item: $1,500 Wednesday, August 15, 2012 45 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0203 Project # Useful Life 6 years Utility 4x4 (unit 212) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$333,700 Description 4 wheel drive uitility vehicle. Current vehicle: 2008 Chevrolet Tahoe (#212) Justification Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals, prisoners and equipment. The 4 wheel drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme snow conditions. PriorExpendituresTotal 20132014201520162017Future Vehicles 47,70047,700 67,400218,600 47,70047,700 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 47,70047,700 67,400 Equipment Replacement Fund 218,600 47,70047,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none. Estimate salvage/resale value on replaced item: $5,000 Wednesday, August 15, 2012 46 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0204 Project # Useful Life 2 years Police Administrative Vehicles (2) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$1,065,300 Description Police administrative and detective vehicles. Replace Chief's vehicle - even numbered years Replace Captain's vehicle - odd numbered years Current vehicles: 2013 Ford Taurus, 2011 Ford Taurus (#216) Justification Unmarked vehicles, equipped with radios, siren and red grille lites used by chief and captain. Staff use is for two years. Vehicles are then rotated down to detectives and are kept for an additional 3-4 years. Vehicles are also used for surveillance by uniform and plain clothes officers. PriorExpendituresTotal 20132014201520162017Future Vehicles 29,60030,50031,40032,40033,300157,200 269,100639,000 29,60030,50031,40032,40033,300157,200 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 29,60030,50031,40032,40033,300157,200 269,100 Equipment Replacement Fund 639,000 29,60030,50031,40032,40033,300157,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $4,000 each Wednesday, August 15, 2012 47 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0205 Project # Useful Life 15 years SWAT Vehicle Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$76,700 Description Unmarked van to transport police tactics team for high risk calls, training and mutual aid. SWAT - Special Weapons And Tatics Current vehicle: 1998 Chevrolet Cube Van (#240) Justification Previous vehicle (15 years old) was a safety hazard and was replaced in 2005. ExpendituresTotalFuture 20132014201520162017 Vehicles 30,00030,000 46,700 30,00030,000 TotalTotal Funding Sources20132014201520162017TotalFuture 30,00030,000 Equipment Replacement Fund 46,700 30,00030,000 TotalTotal Budget Impact/Other Variance from 20 year plan - extended life from 10 to 15 years Estimate salvage/resale value on replaced item: $3,000 Wednesday, August 15, 2012 48 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0206 Project # Useful Life 15 years Police Services Liaison Vehicle Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$63,900 Description Used by Police Services Liaison/JCPP Liaison for transport to schools, neighborhood meetings, training and public relations events. Current vehicle: 2001 Chrysler PT Cruiser (#241) Justification 2001 PT Cruiser was leased to the Police Department for a nominal fee and detailing and wheels were also donated. The City purchased the vehicle from the leasor in 2005. ExpendituresTotalFuture 20132014201520162017 Vehicles 25,00025,000 38,900 25,00025,000 TotalTotal Funding Sources20132014201520162017TotalFuture 25,00025,000 Equipment Replacement Fund 38,900 25,00025,000 TotalTotal Budget Impact/Other Variance from 20 year plan - extended life from 10 to 15 years. Amount allocated is not sufficient. Increase to $25,000. Estimate salvage/resale value on replaced item: $1,000 Wednesday, August 15, 2012 49 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0208 Project # Useful Life 20 years LOGIS Computer System Project Name Category Equipment FuturePriorityn/a Total Project Cost:$200,000 Description Computer system for records management and retention of Police Department in addition to computer aided dispatch (CAD) and mobile data computer in squads. Looking at the LOGIS RMS/CAD/Mobile system. Computer system and maintenance - Year 1 - $200,000 est to include software, licenses, implementation and training, data conversion, and network connectivity. Year 2 - $95,800 - this is maintenance and should be budgeted in Dept budget about a 10% increase each subsequent year Year 2 through ?? Includes software/hardware support in addition to builing reserves for future upgrades Justification To store, retrieve and transfer required data to State and perform data entry, inquiries of local, state and national crime databases. The LOGIS system will allow a greater sharing of data and records with 30+ communities for invesatigative purposes. Expenditures20132014201520162017Total Equipment 200,000200,000 200,000200,000 Total Funding Sources20132014201520162017Total 200,000200,000 Equipment Replacement Fund 200,000200,000 Total Budget Impact/Other Variance from 20 year plan - Project was moved up from 2017 to allow greater ability to share information with other agencies in the system and allows us the capability to potentially explore merging with another dispatch center. Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 50 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0209 Project # Useful Life 5 years Copy Machine - Police Dept Project Name Category Equipment FuturePriorityn/a Total Project Cost:$161,600 Description Police Department copy machine capable of producing double side copies and collating pages, color/BW, fax acapability and scan.. Current equipment: 2011 Ricoh RMP C6501 Justification Used to make duplicate copies of reports, letters, memos, etc., generated by police personnel, fax and scan.. PriorExpendituresTotal 20132014201520162017Future Equipment 22,10022,100 49,80089,700 22,10022,100 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 22,10022,100 49,800 Equipment Replacement Fund 89,700 22,10022,100 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Wednesday, August 15, 2012 51 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0210 Project # Useful Life 7 years Logging Recorder Project Name Category Equipment FuturePriorityn/a Total Project Cost:$138,100 Description The police logging recorder is a device which records all telephone and radio transmissions produced/received by the Police Department. Current equipment: 2005 Mercom logging recorder system Justification Records all incoming/outgoing phone calls from the dispatch center and all radio transmissions from police, fire and interop radio talkgroups. Equipment is necessary in case questions arise as to how calls for service or events were handled or dispatched. ExpendituresTotalFuture 20132014201520162017 Equipment 36,90036,900 101,200 36,90036,900 TotalTotal Funding Sources20132014201520162017TotalFuture 36,90036,900 Equipment Replacement Fund 101,200 36,90036,900 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 52 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief/IT Type Equipment 01-ERP-0211 Project # Useful Life 3 years Network Server (3) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$255,000 Description Computer servers store information and system programs. One server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01-ERP-213) Justification Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used for data storage. PriorExpendituresTotal 20132014201520162017Future Equipment 8,5008,5008,5008,5008,50042,500 85,000127,500 8,5008,5008,5008,5008,50042,500 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 8,5008,5008,5008,5008,50042,500 85,000 Equipment Replacement Fund 127,500 8,5008,5008,5008,5008,50042,500 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Cost stabilized at $8,500 per year. Estimate salvage/resale value on replaced item - $ Wednesday, August 15, 2012 53 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0212 Project # Useful Life 5 years Mobile Data Computers Project Name Category Equipment FuturePriorityn/a Total Project Cost:$297,800 Description Mobile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various databases, communicate car to car. Current equipment: 11 - 2007 Panasonic Lap Tops Justification Limited life of 5 years - replacement necessary. PriorExpendituresTotal 20132014201520162017Future Equipment 62,70062,700 47,000188,100 62,70062,700 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 57,00057,000 47,000 Equipment Replacement Fund 188,100 5,7005,700 PKG - Parking Fund TotalTotal 62,70062,700 Total Budget Impact/Other Variance from 20 year plan - ERP - Move back one year to 2014. All working - no problems. Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 54 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0213 Project # Useful Life 5 years Digital Squad Car Cameras Project Name Category Equipment FuturePriorityn/a Total Project Cost:$256,200 Description 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. Currrent equipment: 2009 ICOP Model 20/20-W LIVE Justification Police Dept. currently has ten digital camera units installed and a dedicated server. The life expectancy of the cameras is about five years. Current cameras were installed in September 2009. Cost: 10 cameras @ $5,000 per unit plus tax - $53,430 1 server @ $15,000 (to be purchased from Police Network Server (01-ERP-211) annual allocation that carries forward. Estimated cost $53,430. Cost could be lower if, at the time of replacement, a suitable product is available through a State or County equipment bid. PriorExpendituresTotal 20132014201520162017Future Equipment 53,40053,400 42,600160,200 53,40053,400 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 53,40053,400 42,600 Equipment Replacement Fund 160,200 53,40053,400 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Increase quantity to ten to cover all marked/unmarked patrol vehicles. Cost of cameras remains at $5,000 each plus tax - $53,430. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 55 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0214 Project # Useful Life 5 years Tactical Ballistic Vests Project Name Category Equipment FuturePriorityn/a Total Project Cost:$137,500 Description Tactical ballistic vests worn by members of the Hopkins Police Department High-risk Entry and Assault Team (HEAT). These vests offer a higher level of protection against weapon assault than the regular duty ballistic vest. Current equipment: 11 - 2008 Titan Tactical Ballistic Vests Justification Federal and State grant monies have been available through the Ballistic Vest Program over the past several years. These grants only pay a portion of the total cost of the vest, leaving the Police Department to pay the balance. There is no guarantee that these grants will be available in the future. Warranty on the current vests expires in 2013. Cost: 11 vests PriorExpendituresTotal 20132014201520162017Future Equipment 23,20023,200 20,00094,300 23,20023,200 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 23,20023,200 20,000 Equipment Replacement Fund 94,300 23,20023,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Team membership has increased to 11. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 56 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Captain Type Equipment 01-ERP-0217 Project # Useful Life 4 years Taser Replacement Project Name Category Equipment FuturePriority3 Important Total Project Cost:$119,300 Description The police department will need to replace all of its X26 Tasers (ECD) Electronic Control Devices including all software and HD Camera systems and transition to the new X2 Tasers. Justification The current Tasers will need to be replaced due to the age and use of the equipment. ExpendituresTotalFuture 20132014201520162017 Equipment 18,60020,90039,500 79,800 18,60020,90039,500 TotalTotal Funding Sources20132014201520162017TotalFuture 18,60020,90039,500 Equipment Replacement Fund 79,800 18,60020,90039,500 TotalTotal Budget Impact/Other Using the numbers obtained from Tasers Bob Lovering, the cost breaks down as shown below: 8 X2 Tasers $7,600.00 8 HD Cams $3,999.60 8 4yr Warranty/X2 $2,399.92 8 4yr Warranty/Cam $1,199.96 6 Blade Tech Holsters $ 359.70 56 Cartridges $1,621.20 Download Kit $ 14.95 Shipping $ 120.00 Total $17,315.33 (plus tax) w/Tax est $18,575 Wednesday, August 15, 2012 57 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0300 Project # Useful Life 10 years 4x4 3/4 Ton Pickup with Plow Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$75,400 Description Pickup used by various divisions of Public Works. Current vehicle: 1997 Chevrolet 3/4 Ton 4X4 (#301) Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. PriorExpendituresTotal 20132014201520162017Future Vehicles 21,50021,500 25,00028,900 21,50021,500 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 21,50021,500 25,000 Equipment Replacement Fund 28,900 21,50021,500 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move up from 2015 to 2013. Replace with 1/2 ton 4x4 pickup. Reduce amount from 33,600 to 21,500.. Estimate salvage/resale value on replaced item: $1,500 Wednesday, August 15, 2012 58 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0301 Project # Useful Life 8 years 4X4 3/4 Ton Truck with Plow Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$141,700 Description 3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers. Current vehicle: 2006 Ford F250 (#302) Justification Light hauling, pulling trailers, transportation to and from job sites. PriorExpendituresTotal 20132014201520162017Future Vehicles 30,40030,400 24,00087,300 30,40030,400 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 30,40030,400 24,000 Equipment Replacement Fund 87,300 30,40030,400 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Unit in good condition - move out 2 years. Estimate salvage/resale value on replaced item: $1,500 Wednesday, August 15, 2012 59 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0307 Project # Useful Life 22 years Water Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$195,000 Description Water truck used in Streets and Parks Division of Public Works. Current vehicle: 1995 Ford Water Truck (#316) Justification Used for street flushing, watering trees and plants, rink flooding and standby fire protection. PriorExpendituresTotal 20132014201520162017 Vehicles 150,000150,000 45,000 150,000150,000 TotalTotal PriorFunding Sources20132014201520162017Total 150,000150,000 45,000 Equipment Replacement Fund 150,000150,000 TotalTotal Budget Impact/Other Variance from 20 year plan - replace tanker only in 2010 - replace tanker, cab & chassis in 2017, tanker only again in 2032 and entire vehicle in 2039. Change to a 22 year life. Estimate salvage/resale value on replaced item: $8,500 Wednesday, August 15, 2012 60 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0309 Project # Useful Life 12 years Skid Loader (2) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$187,600 Description Loading trucks, landscape work, snow removal, material handling. Current equipment: 2004 Bobcat S-1851R Skid Loader (#324) & 2011 Bobcat S650 Skid-Steer Loader (#325) Justification PriorExpendituresTotal 20132014201520162017Future Equipment 41,90041,900 36,000109,700 41,90041,900 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 41,90041,900 36,000 Equipment Replacement Fund 109,700 41,90041,900 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2010 to 2011. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 61 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0312 Project # Useful Life 20 years Roller Project Name Category Equipment FuturePriorityn/a Total Project Cost:$45,900 Description Used by Street Department for asphalt repair and resurfacing. Current equipment: 1989 Ingersoll Rand Roller (#330) Justification ExpendituresTotal 20132014201520162017 Equipment 45,90045,900 45,90045,900 Total Funding Sources20132014201520162017Total Equipment Replacement Fund 45,90045,900 45,90045,900 Total Budget Impact/Other Variance from 20 year plan - Move back from 2012 to 2014. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 62 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0313 Project # Useful Life 12 years Striper Project Name Category Equipment FuturePriorityn/a Total Project Cost:$27,200 Description Line striper. Current equipment: 1993 Line Striper A1990 (#352) Justification ExpendituresTotalFuture 20132014201520162017 Equipment 11,20011,200 16,000 11,20011,200 TotalTotal Funding Sources20132014201520162017TotalFuture 11,20011,200 Equipment Replacement Fund 16,000 11,20011,200 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 63 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0314 Project # Useful Life 20 years Asphalt Paver Project Name Category Equipment FuturePriorityn/a Total Project Cost:$48,800 Description Asphalt paver used by Streets Division of Public Works. Current equipment: 1994 Caterpillar AD200B Paver (#337) Justification Paving streets and parking lots. ExpendituresTotal 20132014201520162017 Equipment 48,80048,800 48,80048,800 Total Funding Sources20132014201520162017Total Equipment Replacement Fund 48,80048,800 48,80048,800 Total Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $500 Wednesday, August 15, 2012 64 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0315 Project # Useful Life 20 years Snow Blower Project Name Category Equipment FuturePriorityn/a Total Project Cost:$102,300 Description Snow blower used by the Streets Division of Public Works. Current equipment: 1996 SnoGo WK800 (#344) Justification Blowing and loading snow off Mainstreet into trucks. ExpendituresTotal 20132014201520162017 Equipment 102,300102,300 102,300102,300 Total Funding Sources20132014201520162017Total Equipment Replacement Fund 102,300102,300 102,300102,300 Total Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $4,500 Wednesday, August 15, 2012 65 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0317 Project # Useful Life 10 years Sign Machine (Traffic) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$31,500 Description Mahcine used by the Traffic Division of Public Works to make traffic signs and related signs and decals for general city use. Current equipment: 2005 Signcad Sign Making System (#353) Justification Existing machine is not repairable and needs updating/ ExpendituresTotalFuture 20132014201520162017 Equipment 13,40013,400 18,100 13,40013,400 TotalTotal Funding Sources20132014201520162017TotalFuture 13,40013,400 Equipment Replacement Fund 18,100 13,40013,400 TotalTotal Budget Impact/Other Variance from 20 year plan - new Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 66 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0319 Project # Useful Life 20 years Regenerative Air Sweeper Project Name Category Equipment FuturePriorityn/a Total Project Cost:$185,000 Description The City currently utilizes an Elgin Pelican Mechanical Sweeper (01-ERP-311). This type of sweeper is for heavy spring sweeps and is labor intensive due to the need for a water truck and dump truck to assist during its use. The proposed sweeper is a vacuum type sweeper that regenerates its air to vacuum up dirt and debris. The vacuum is effective in its ability to pick up even the smallest of dirt without the use of pre- wetting . It is also a truck type unit so it can be used by one operator to drive to a dump site to empty the sweepings without the need of a separate dump truck. Justification The existing sweeper that was due for replacement in 2013 for $156,400 will be moved out to 2021 and scheduled every twenty years. The new machine will also be a 20 year machine and budgeted at $185,000. The reduced usage by having two machines will allow us to keep both for a longer time and allow us more flexibility on different types of sweeping and reduce the labor needed to perform this duty. ExpendituresTotal 20132014201520162017 Equipment 185,000185,000 185,000185,000 Total Funding Sources20132014201520162017Total 185,000185,000 Equipment Replacement Fund 185,000185,000 Total Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value one replaced item: $ Wednesday, August 15, 2012 67 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentHRA Cit of Hokins MN yp, Contact Unassigned Type Equipment 01-ERP-0400 Project # Useful Life 8 years 4x4 3/4 Ton Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$148,400 Description 4 wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snow plow. Current vehicle: 2007 Chevrolet Pickup Justification Transportation for Public Housing Superintendent and snow plowing at various HRA properties around the city. PriorExpendituresTotal 20132014201520162017Future Vehicles 32,40032,400 22,80093,200 32,40032,400 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 32,40032,400 22,800 HRA - Housing and Redevelop 93,200 32,40032,400 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,800 Wednesday, August 15, 2012 68 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentHRA Cit of Hokins MN yp, Contact Finance Director Type Equipment 01-ERP-0401 Project # Useful Life 8 years HRA Copier Project Name Category Equipment FuturePriorityn/a Total Project Cost:$50,400 Description Color copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks. Current equipment: Imagistics ZB35 Justification Daily use to make copies of correspondence, forms and rental documents. Periodically produce documents such as resident newsletters and marketing. Machine will duplex, sort, collate and staple copies. ExpendituresTotalFuture 20132014201520162017 Equipment 13,00013,000 37,400 13,00013,000 TotalTotal Funding Sources20132014201520162017TotalFuture 13,00013,000 HRA - Housing and Redevelop 37,400 13,00013,000 TotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replace item: $ - 0 - Wednesday, August 15, 2012 69 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentWater Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0500 Project # Useful Life 10 years 1/2 Ton Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$83,300 Description Trucks used by Water Department. Current vehicle: 2007 Chevrolet Pickup Justification PriorExpendituresTotal 20132014201520162017Future Vehicles 26,80026,800 20,50036,000 26,80026,800 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 26,80026,800 20,500 WF - Water Fund 36,000 26,80026,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 70 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentWater Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0501 Project # Useful Life 10 years 3/4 Ton Utility Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$81,800 Description 3/4 ton utility truck used by the Water Division of Public Works. Current vehicle: 2006 Chevrolet Pickup Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. ExpendituresTotalFuture 20132014201520162017 Vehicles 34,90034,900 46,900 34,90034,900 TotalTotal Funding Sources20132014201520162017TotalFuture 34,90034,900 WF - Water Fund 46,900 34,90034,900 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Wednesday, August 15, 2012 71 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentWater Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0502 Project # Useful Life 20 years Backhoe Loader Project Name Category Equipment FuturePriorityn/a Total Project Cost:$75,000 Description Unit utilitzed by Water, Sewer and Street Divisions of Public Works for repair and installation of underground utilities. Current equipment: 1993 Caterpillar Backhoe 446 (#533) Justification ExpendituresTotal 20132014201520162017 Equipment 75,00075,000 75,00075,000 Total Funding Sources20132014201520162017Total 75,00075,000 WF - Water Fund 75,00075,000 Total Budget Impact/Other Variance from 20 year plan - Replace with smaller unit. Reduce price to $75,000. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 72 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentSewer Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0550 Project # Useful Life 10 years 4x4 3/4 Ton Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$110,300 Description Truck used by Water/Sewer Division of Public Works. Current vehicle: 2004 Chevrolet Pickup (#501) Justification Snow plowing, light hauling, pulling trailers, general purpose transportation. PriorExpendituresTotal 20132014201520162017Future Vehicles 35,70035,700 26,60048,000 35,70035,700 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 35,70035,700 26,600 SF - Sanitary Sewer Fund 48,000 35,70035,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 73 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentSewer Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0551 Project # Useful Life 10 years 3/4 Ton Utility Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$129,800 Description 3/4 ton utility truck used by the Water/Sewer Division of Public Works. Currrent vehicle: 2007 Chevrolet Pickup (#505) Justification Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. PriorExpendituresTotal 20132014201520162017Future Vehicles 33,60033,600 51,00045,200 33,60033,600 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 33,60033,600 51,000 SF - Sanitary Sewer Fund 45,200 33,60033,600 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Wednesday, August 15, 2012 74 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentSewer Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0555 Project # Useful Life 25 years Generator (2) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$49,400 Description Portable generator used by Water/Sewer Divisions of Public Works. Current equipment: 1997 Kohler Generator, 2008 Caterpillar C15 (#537) Justification Emergency back up generator for lift stations and pumps, off site power for lights and welding. ExpendituresTotalFuture 20132014201520162017 Equipment 26,40026,400 23,000 26,40026,400 TotalTotal Funding Sources20132014201520162017TotalFuture 26,40026,400 SF - Sanitary Sewer Fund 23,000 26,40026,400 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Wednesday, August 15, 2012 75 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Engineering Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0700 Project # Useful Life 10 years Engineering Van Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$46,900 Description Van used by Engineering Department for survey equipment and on job site work. Current vehicle: 2000 Chevrolet Suburban (#700) Justification Transportation to and from job site, hauling of surveying and traffic counting equipment. PriorExpendituresTotal 20132014201520162017Future Vehicles 2,0002,000 16,00028,900 2,0002,000 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 2,0002,000 16,000 Equipment Replacement Fund 28,900 2,0002,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Replace with surplus Police Tahoe in 2014. Leave $2,000 for modifications.. Estimate salvage/resale value on replaced item: $2,500 Wednesday, August 15, 2012 76 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0800 Project # Useful Life 10 years 1/2 Ton Pickup Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$61,800 Description Pickup used by Park Division of Public Works. Current vehicle: 2001 Ford Ranger (#800) Justification ExpendituresTotalFuture 20132014201520162017 Vehicles 26,40026,400 35,400 26,40026,400 TotalTotal Funding Sources20132014201520162017TotalFuture 26,40026,400 Equipment Replacement Fund 35,400 26,40026,400 TotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2012 to 2013 Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 77 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0802 Project # Useful Life 14 years 3/4 Ton Utility Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$80,900 Description 3/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city. Current vehicle: 1998 Dodge Ram 3500 (#805) Justification ExpendituresTotalFuture 20132014201520162017 Vehicles 32,20032,200 48,700 32,20032,200 TotalTotal Funding Sources20132014201520162017TotalFuture 32,20032,200 Equipment Replacement Fund 48,700 32,20032,200 TotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2013 to 2014. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 78 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0806 Project # Useful Life 30 years Tractor Project Name Category Equipment FuturePriorityn/a Total Project Cost:$49,300 Description Farm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration, plowing and grass seeding. Current equipment: 1984 Ford Tractor 2910 (#816) Justification ExpendituresTotal 20132014201520162017 Equipment 49,30049,300 49,30049,300 Total Funding Sources20132014201520162017Total 49,30049,300 Equipment Replacement Fund 49,30049,300 Total Budget Impact/Other Variance from 20 year plan - Delete one tractor (2012) to be placed by ToolCat (2010). Move second tractor to 2016. Estimate salvage/resale value on replaced item: $3,500 Wednesday, August 15, 2012 79 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0807 Project # Useful Life 15 years Trucksters (3) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$114,700 Description Truckster used by Parks Division of Public Works for ballfield and parks maintenance. Current equipment: 1996 Toro Workman (#818), 2004 Toro Workman 3200 (#820), 2004 Toro Workman 2110 (#821) Justification Park maintenance, ballfield grooming and weed spraying. PriorExpendituresTotal 20132014201520162017Future Equipment 19,80019,800 29,90065,000 19,80019,800 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 19,80019,800 29,900 Equipment Replacement Fund 65,000 19,80019,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move from 2012 to 2013. Estimate salvage/resale value on replaced item: $1,400 each Wednesday, August 15, 2012 80 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0808 Project # Useful Life 8 years Riding Mowers (2) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$169,000 Description Riding mowers used by Parks Divison of Public Works. Current equipment: 2004 Toro Zero Turn (#826), 2006 Jacobson Rotary Mower (#823) Justification Mowing city parks and right of ways. PriorExpendituresTotal 20132014201520162017Future Equipment 11,00020,00031,000 49,00089,000 11,00020,00031,000 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 11,00020,00031,000 49,000 Equipment Replacement Fund 89,000 11,00020,00031,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2013 to 2014 and reduce to 11,000. Move back from 2014 to 2015 and reduce to 20,000. Delete one mower from plan. Estimate salvage/resale value on replaced item: $600 each Wednesday, August 15, 2012 81 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0809 Project # Useful Life 15 years Slope Mower Project Name Category Equipment FuturePriorityn/a Total Project Cost:$83,600 Description Current equipment: 2001 DEW EZE ATM72 Slope Mower (#828) Justification Expenditures20132014201520162017TotalFuture Equipment 32,70032,700 50,900 32,70032,700 TotalTotal Funding Sources20132014201520162017TotalFuture 32,70032,700 Equipment Replacement Fund 50,900 32,70032,700 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Wednesday, August 15, 2012 82 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0812 Project # Useful Life 20 years Stump Cutter Project Name Category Equipment FuturePriorityn/a Total Project Cost:$21,200 Description Stump cutter used by Parks Division of Public Works. Current equipment: 1997 Vermeer Stump Cutter (#832) Justification Chipping out stumps of trees removed from city property. ExpendituresTotal 20132014201520162017 Equipment 21,20021,200 21,20021,200 Total Funding Sources20132014201520162017Total Equipment Replacement Fund 21,20021,200 21,20021,200 Total Budget Impact/Other Variance from 20 year plan - extend to 20 years to reflect actual. Estimate salvage/resale value on replaced item: $1,800 Wednesday, August 15, 2012 83 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0813 Project # Useful Life 20 years Brush Chipper Project Name Category Equipment FuturePriorityn/a Total Project Cost:$25,700 Description Brush chipper used for Forestry and brush pick up operations of Public Works. Current equipment: 1993 Brush Bandit Chipper 250 (#834) Justification ExpendituresTotal 20132014201520162017 Equipment 25,70025,700 25,70025,700 Total Funding Sources20132014201520162017Total Equipment Replacement Fund 25,70025,700 25,70025,700 Total Budget Impact/Other Variance from 20 year plan - Was moved back from 2013 to 2015, however recent developments show that the chipper is not performing well and will need to be replaced in 2013 so it was returned to the 2013 position. Estimate salvage/resale value on replaced item: $0 Wednesday, August 15, 2012 84 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0815 Project # Useful Life 12 years Skid Loader Project Name Category Equipment FuturePriorityn/a Total Project Cost:$77,600 Description Current equipment: 2004 Bobcat 463 (#833) Justification ExpendituresTotalFuture 20132014201520162017 Equipment 32,00032,000 45,600 32,00032,000 TotalTotal Funding Sources20132014201520162017TotalFuture 32,00032,000 Equipment Replacement Fund 45,600 32,00032,000 TotalTotal Budget Impact/Other Variance from 20 year plan - new item in 2004. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 85 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentRefuse Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0900 Project # Useful Life 10 years Refuse Truck (RAP-R) (2) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$1,462,600 Description Refuse truck used by Refuse Utility Division of Public Works. Curent vehicle: 2005 Peterbilt Rapid Rail (#901) & 2011 Freightliner Rapid Rail (#900) Justification Residential waste pick up. PriorExpendituresTotal 20132014201520162017Future Vehicles 204,800204,800 349,100908,700 204,800204,800 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 204,800204,800 349,100 RF - Refuse Fund 908,700 204,800204,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Wednesday, August 15, 2012 86 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentRefuse Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0901 Project # Useful Life 10 years Refuse Truck (Rear-L) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$238,200 Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 1996 Freightliner FL70 (#903) Justification Residential waste pick up. ExpendituresTotalFuture 20132014201520162017 Vehicles 101,600101,600 136,600 101,600101,600 TotalTotal Funding Sources20132014201520162017TotalFuture 101,600101,600 RF - Refuse Fund 136,600 101,600101,600 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $9,000 Wednesday, August 15, 2012 87 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPavilion Cit of Hokins MN yp, Contact Facilities Director Type Equipment 01-ERP-1000 Project # Useful Life 12 years Ice Resurfacer Project Name Category Equipment FuturePriorityn/a Total Project Cost:$496,600 Description Ice resurfacer used by the Pavilion for ice sheet maintenance. Current equipment: 2003 Olympia Ice Resurfacer (#809) Justification Replace existing propane fueled ice resurfacer with a electric driven ice resurfacer. Due to changes in the states statues for indoor air quality for ice arenas replacement with a propane fueled model would warrant the purchase and installation of state approved air quality monitoring equipment. Additional costs that would accompany the monitoring equipment would be annual testing and recalibration fees. State statues also require annual licensing and lower emission standards to be meet that if exceeded could possibly lead to possible facility closures and loss of revenue. With consideration of the above factors the Pavilion would be exempt from the new statues if a electric ice resurfacer was used in place of propane ice resurfacer. PriorExpendituresTotal 20132014201520162017Future Equipment 180,000180,000 60,000256,600 180,000180,000 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 180,000180,000 60,000 PA - Pavilion Fund 256,600 180,000180,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Value increased to reflect actual replacement cost. Estimate salvage/resale value on replaced item: $20,000 Wednesday, August 15, 2012 88 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentPavilion Cit of Hokins MN yp, Contact Facilities Director Type Equipment 01-ERP-1001 Project # Useful Life 10 years Electric Ice Edger Project Name Category Equipment FuturePriorityn/a Total Project Cost:$11,700 Description Electric ice edger used for ice maintenance of the Pavilion's ice sheet. An edger is used to shave the ice next to the boards to remove ice buildup that the ice resurface cannot reach. Justification For the Pavilion to be exempt from the changing state statutes for air quality in ice arenas, the gas fueled edger must be replaced with an electric model. ExpendituresTotalFuture 20132014201520162017 Equipment 5,0005,000 6,700 5,0005,000 TotalTotal Funding Sources20132014201520162017TotalFuture 5,0005,000 PA - Pavilion Fund 6,700 5,0005,000 TotalTotal Budget Impact/Other Vairance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 89 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Director Type Equipment 01-ERP-1102 Project # Useful Life 12 years Art Center Kitchen Catering Equipment Project Name Category Equipment FuturePriorityn/a Total Project Cost:$12,100 Description Under counter freezer and refrigerator in catering kitchen. Justification These units are used for storing food for HCA events and for rental clients. ExpendituresTotalFuture 20132014201520162017 Equipment 5,0005,000 7,100 5,0005,000 TotalTotal Funding Sources20132014201520162017TotalFuture 5,0005,000 AC - Arts Center Fund 7,100 5,0005,000 TotalTotal Budget Impact/Other Variance from 20 year plan - New item. Current pricing $2049 refrigerator, $2207 freezer plus delivery. Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 90 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Director Type Equipment 01-ERP-1103 Project # Useful Life 5 years Art Center Video Camera Updates Project Name Category Equipment FuturePriorityn/a Total Project Cost:$22,000 Description Replace the front entry camera with a better resolution camera. Relocate existing to above the display cabinet in the lobby. Add additional camera to the gallery, left of door to capture shot of faces of those exiting. Add a camera to the back hallway of the second floor. Justification There was an item taken from a display case in 2011 and existing cameras did not provide clear angle and view of the culprit. Also, addition of a camera in the back hallway may reduce tendency of youth to hang out in that area and engage in inappropriate behavior. PriorExpendituresTotal 20132014201520162017Future Equipment 3,7003,700 3,20015,100 3,7003,700 TotalTotalTotal PriorFunding Sources20132014201520162017TotalFuture 3,7003,700 3,200 AC - Arts Center Fund 15,100 3,7003,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $-0- Wednesday, August 15, 2012 91 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Director Type Equipment 01-ERP-1104 Project # Useful Life 5 years Art Center Theater Projector Project Name Category Equipment FuturePriorityn/a Total Project Cost:$30,400 Description Replace the projector currently in the theater with a projector that has higher lumens and HDMI connectivity. Rewire it so it can be operated from the control booth. Justification The current projector in the theater is a 3000 lumen projector. It is used for rental events and for showing pre-concert advertisements. When house lights are at half, the image is inadequate. Replacing it with a 4500 higher lumen projector improves the image in partial light conditions such as when the audience is being seated. In addition, it needs to have a HDMI input, which the existing unit does not offer. Rewiring it allows it to be turned on and off without being in line of site -- currently someone has to be sitting in the audience to power it off. Existing theater projector could be utilized for rental events until completely obsolete. ExpendituresTotalFuture 20132014201520162017 Equipment 6,0006,000 24,400 6,0006,000 TotalTotal Funding Sources20132014201520162017TotalFuture 6,0006,000 AC - Arts Center Fund 24,400 6,0006,000 TotalTotal Budget Impact/Other Variance from 20 year plan - New item: $3500 projector, $2500 installation (T&M estimate) Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 92 EQUIPMENT REPLACEMENT PLAN 20132017 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Director Type Equipment 01-ERP-1105 Project # Useful Life 7 years Art Center Community Room Audio Visual Project Name Category Equipment FuturePriorityn/a Total Project Cost:$41,100 Description Install a projector in a ceiling mount. Wire speakers into the ceiling. Wire input for computer on front wall. Utilize existing manual screen. Add two microphones. Mount equipment in rack in closet. Justification Current operations require the use of an A/V cart, several cords across the floor and a large unattractive speaker on a stick. By incorporating the projector into a ceiling mount and speakers into the ceiling, we will be able to present a much more streamlined appearance and functionality for groups making presentations in the room. This will enhance the experience of current rental clients and help us acquire new ones. It will keep the A/V safely off the floor and reduce cords and set up time. ExpendituresTotalFuture 20132014201520162017 Equipment 11,00011,000 30,100 11,00011,000 TotalTotal Funding Sources20132014201520162017TotalFuture 11,00011,000 AC - Arts Center Fund 30,100 11,00011,000 TotalTotal Budget Impact/Other Variance from 20 year plan: New item Estimate salvage/resale value on replaced item: $ Wednesday, August 15, 2012 93 TWENTYYEAR REPLACEMENTSCHEDULE 94 95 96 97 98 99 EQUIPMENTANDBUILDING INVENTORY 100 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTOR Y 06/15/2012 CURRENT REPLACEMENT UNITYEAMAKEMODELCOST #R FIRE DEPARTMENT 1002006DODGEDURANGO$28,300 1012003CHEVIMPAL24,900 A 102.1989FORD L9000TELE-SQUIR240,000 T 103.2006PETERBILTPUMPER403,300 108.1995CHEV 4X4 LITE RESCU25,000 E 1092008PIERCAERO XT845,000 E 1102010CHEVROLETTAHOE30,000 115.1952MACPUMPER4,000 K POLICE DEPARTMENT 200.2010FORDCROWN VICTORI$30,000 A 201.2008FORDCROWN VICTORI28,100 A 202.2011FORDCROWN VICTORI31,000 A 203.2009FORDCROWN VICTORI28,160 A 205.2011FORDCROWN VICTORI31,000 A 207.2010FORDCROWN VICTORI30,000 A 209.2011FORDCROWN VICTORI31,000 A 211.2006JEEPLIBERT18,800 Y 212.2008CHEVTAHOE36,000 213.2010CHEVIMPAL26,000 A 214.2007DODGECHARGE28,000 R 215.2009CHEVIMPAL25,000 A 216.2011FORDTAURUS30,000 217.2008FORDTAURUS22,000 219.2013FORDTAURUS27,500 240.1998CHEVP40 VAN20,000 241.2001CHRYSLEPT CRUISE18,000 RR 101 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTOR Y 06/15/2012 CURRENT REPLACEMENT UNITYEAMAKEMODELCOST #R STREET/TRAFFIC DIVISION 301.1997CHEV3/4 TON$21,000 302.2006FORDF25026,500 304.2000FORDF-45034,000 305.1997FORD1/2 TON 18,300 307.2006FORDF350-1 TON DUMP27,400 308.2011FORDF350 - 2X420,300 309.2012FORDF45030,300 310.1989INTERNATIONASGLAX DUMP70,000 L 311.2011FREIGHTLINEM2106V79,400 R 312.2005FREIGHTLINESGLAX DUMP98,000 R 313.2001FORDL750172,000 314.1998FORDLT 850086,000 315.1996FORDL-800085,000 316.1995FORDWATER TRK81,000 320.1991CATERPILLELOADER 92690,000 RE 322.2005CATERPILLELOADER 938157,800 RG 324.2004BOBCATSKID LOADE30,000 R 325.2011BOBCATSKID STEER LOADE38,000 R 326.1989CATERPILLA140-82,000 RG 327.2001ELGIPELICAN S105,000 NE 330.1989INGERSOL/RANROLLER DD-2523,000 D 337.1994CATERPILLABOX PAVER18,000 R 342.1991TARGETCONCRETE SA2,400 W 344.1996SNOGOWK 80058,000 349.1989TRAIL-KINTK6V-12003,000 G 350.1993TOWMASTERT144,000 351.2004TENNANTSWEEPER 364010,000 PUBLIC WORKS - ADMINISTRATION 401.2008FORDCROWN VICTORI$28,100 A ENGINEERING DIVISIO N 700.2000CHEVSUBURBA$14,500 N 705.2005CHEVIMPAL14,600 A 102 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTOR Y 06/15/2012 CURRENT REPLACEMENT UNITYEAMAKEMODELCOST #R BUILDING MAINTENANCE & EQUIPMENT SERVICE S 7011997CHEV C1500$16,000 7022004FORDF35023,000 703.2002CHEV TAHOE5,000 704.2005FORDF25024,000 PARKS/FORESTRY DIVISION 800.2001FORDRANGER 4X4$18,000 801.2012FORDF350 4X424,100 802.2012FORDF350 4X424,100 803.2004FORDF35023,000 804.1996CHEV3/4T 4X416,000 805.1998DODGERAM 350024,000 810.1993INTERNATIONALP 470050,000 L 811.2006INTERNATIONALP 4600 LOG TRUC45,000 LK 812.2010FREIGHTLINEAERIAL LIF130,000 RT 815.2010BOBCATTOOLCAT50,000 817.1982FORDTRACTOR 261022,000 818.1996TOROTRUCKSTER13,000 820.2004TOROWORKMAN 320015,000 821.2004TOROWORKMAN 21107,900 822.2001TORO325-D MOWE18,000 R 823.2006JACOBSOMOWER 10,000 N 824.1996TOROGROUND MASTE16,000 R 825.2010TORO4100D MOWER53,000 826.2004TOROZ587L8,900 828.2001DEW EZEATM7221,000 832.1997VERMEERSTUMP CTR 630A15,400 833.2004BOBCATSKID LOADE22,000 R 834.1993BRUSH BANDICHIPPER 2514,000 T0 836. RYASOD CUTTER2,000 N 842.2011P.J.TRAILE5,300 R 844.2010FELLINTRAILE4,000 GR 845.1997REMACKELTRAILE5,000 R 846.2001DRESSE81102,000 N 847.2011SPARKSTILT TRAILE5,300 R 103 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTOR Y 06/15/2012 CURRENT REPLACEMENT UNITYEAMAKEMODELCOST #R HRA 411.2007CHEV2500 HD$17,500 WATER/SEWER 500.2007CHEVPICKUP$22,000 501.2004CHEV4X4 3/4 T SILVERADO19,000 502.1999DODGEDAKOTA 4X418,000 505.2007CHEVCC2575324,000 506.2006CHEVSILVERADO20,700 530.2001STERLINVAC-CO180,000 GN 533.1993CATERPILLALDR-BKHOE-4450,000 R6 534.1997KOHLERGENERATOR/TRL11,000 535.1992KOHLERGENERATOR/TRL10,000 536.1989FLEXIBLRODDING MACHIN25,000 EE 537.2010GENERATOC15130,000 R 540.2008LEROAIR COMPRESSO12,000 IR 542.1994WACKERTAMPER4,000 REFUSE 900.2011FREIGHTLINERAPID-RAIL M$211,800 R2 901.2005PETERBILT320162,000 903.1995FREIGHTLINEFL-7054,000 R PAVILION 801.1996CHEV4X4 TRK$19,100 809.2003OLYMPIICE RESURFACE85,000 AR 104 CITY OF HOPKINS BUILDING INVENTORY June 2012 Location/DescriptionReplacement Cost City Hall$3,491,100 1010 1st Street S. Police Station3,936,800 1010 1st Street S. Fire Station4,322,850 101 17th Avenue S. Hopkins Activity Cente1,872,315 r 33 14th Avenue S. Ice Arena/Pavilion5,141,585 11000 Excelsior Boulevard Arts Center7,042,635 1111 Mainstreet PW Admin/Garage7,354,065 11100 Excelsior Boulevard Moline Reservoir/Well #12,357,175 10421 Excelsor Boulevard Blake Tower Reservoir1,421,368 151 Tyler Avenue S. Filtration Plant3,466,700 1401 Elmo Park Service Roa d Well #4 Workshop/Storage668,935 1401 Elmo Park Service Roa d Well #5235,245 1205 Highway7 Well #6313,645 801 Highway 7 Lift Station #2 - Drillane66,825 619 Drillane Road Lift Station #3 - Lindee's133,450 901 Cambridge Street N.E. 105 Location/DescriptionReplacement Cos t Lift Station #4 - LTL Meadowbrook$97,725 244 Meadowbrook Roa d Lift Station #5 - Big Meadowbroo155,125 k 6601 Excelsior Blvd. Lift Station #6 - Ronnie's97,725 8546 Excelsior Avenue E. Lift Station #7 - Valley308,900 801 6th Avenue S. Band Shell - Downtown Par36,900 k 16 9th Avenue S. Concession Stand - Maetzold Field152,885 1215 1st Street N. Park Building-Beach - Lifeguard164,970 s 5200 Shady Oak Roa d Park Building-Beach-Concessions155,880 5200 Shady Oak Roa d Park Shelter - Office/Bathhouse378,608 5200 Shady Oak Roa d Park Shelter - Burnes50,388 201 Park Lane Park Building - Central114,363 101 17th Avenue S. Park Building - Harle38,745 y 108 Jackson Avenue S. Park Shelter - Interlache61,926 n 220 Homedale Avenue Park Building - Oakes44,178 301 Tyler Avenue N. Park Building - Valle51,941 y 800 7th Avenue S. Parking Ramp6,391,900 10th Avenue and Mainstreet 106 Location/DescriptionReplacement Cos t Depot Coffee House$481,475 9451 Excelsior Boulevard Overpass Skate Par7,703 k 100 Washington Avenue Dow Towers (76 Units)HR A 22 5th Avenue S. 107