Loading...
2014 - 2018 ERP EQUIPMENT REPLACEMENT PLAN 2014-2018 DATE: August 2013 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager 2014-2018 EQUIPMENT REPLACEMENT PLAN SUBJECT: With this letter, I respectfully submit the 2014-2018 Equipment Replacement Plan. This five-year planning document represents the combined efforts of city staff and the City Council. The Equipment Replacement Plan is a five-year forecast of equipment replacement needs in the City of Hopkins. It is intended to alert the Council and citizens of equipment replacement needs that are needed to maintain the efficiency of city services and the safety of city staff. The first year of the plan becomes the adopted budget, however the equipment is again re-evaluated before final approval is given for the purchase. The remaining four years represents estimated replacement needs and the related funding. The Equipment Replacement Plan does not include proposed capital projects. A document relating specifically to capital project needs has been developed into a separate document. The Equipment Replacement Plan is intended to serve as a planning tool and is therefore structured to present a meaningful, long-range perspective of the city’s equipment needs over the next 20 years. At the same time sufficient details on individual pieces of equipment scheduled for replacement is provided to enable those who review the information to make informed decisions of the city’s equipment needs over the next several years. Please use the information provided to assist in the understanding of the city’s equipment needs as they relate to the delivery of service to the citizens of Hopkins. This document was developed by the Finance Department with the assistance of all city departments. I wish to especially thank all those involved in the development of the Equipment Replacement Plan, and especially Steve Stadler, Public Works Director, Mike Reynolds, Police Chief, Brent Johnson, Police Captain, Dale Specken, Fire Chief, Christine Harkess, Finance Director and Deb Dahlheimer, Sr. Finance Clerk for their hard work and dedication. 1 EQUIPMENT REPLACEMENT PLAN 2014-2018 TABLE OF CONTENTS Page City Manager's Message 1 Table of Contents 2 Introduction Background and Summary of Changes from 2013 Plan5 Cash Flow Statements Equipment Replacement Fund 13 Chart - Revenues, Expenditures & Working Capital14 Five-Year Project Summaries Projects by Year17 Department Summary20 Projects by Department21 Funding Source Summary24 Projects by Funding Source25 Equipment Requests Individual Equipment Request Details31 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department109 Equipment and Building Inventor y Building Inventory117 Vehicle and Equipment Inventory119 2 3 4 EQUIPMENT REPLACEMENT PLAN 2014-2018 BACKGROUND AND SUMMARY OF CHANGES FROM 2013 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 $849,700. 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. The rates were held flat for 2013. 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. 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 66% 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 2014 ERP. As discussed above are scheduling an 8% rate increase for 2014, and 9% for 2015-2018 and plan to sell Equipment Certificates to fund some of the equipment scheduled for 2016-2018. This will allow us to replace aging equipment and spread the payments over 10 years. The required Equipment Certificate payment will be part of the debt levy in the applicable year. Each year staff re-evaluates the equipment needs and adjusts the schedule accordingly. Changes to the plan are reflected in the document. Refurbishments, extended life expectancy and closer cost estimates of replacements have been incorporated into the plan. The equipment replacement charges in the general fund represent approximately 2.8% of total general fund expenditures. The Equipment Replacement Plan’s basic premise is scheduled replacement of present equipment. A new item must, in the year proposed, be presented in the annual operating budget 5 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 2013 Plan Highlights of changes from last year’s equipment replacement plan for the years 2014-2018: Activity Center: There are no changes to Activity Center items in this ERP. Arts Center: The Theater projector replaced at a cost of $15,000 was rescheduled for 2018 at a cost of $17,100. The subsequent replacement had not been previously scheduled. The community room audio visual unit for $11,000 was moved from 2014 to 2015. A theater projection screen was added in 2014 at a cost of $5,000. This screen will replace the original retractable screen in the theater with a wider format screen to mesh with current technology. Theater presentation microphones were added in 2014 at a cost of $6,000. Three lapel and three hand held microphones will be replaced along with supporting transmitters, receivers, splitter kit and rack mount kit. A digital sign at a cost of $2,000 was added in 2015. This will be a programmable and highly visible digital sign for information at the information desk area. City Hall: Financial software was added in 2014 at a cost of $250,000. The current software company is not keeping up with security issues and staff has become increasingly frustrated with the operation of the current software. Community Services: There are no changes to Community Services items in this ERP. Fire: The fire utility vehicle used by the Fire Inspector and scheduled for 2016 at a cost of $35,000 was moved up to 2015 and the cost has been increased to $40,000 to reflect actual replacement cost. The duty chief vehicle schedule in 2015 was moved back to 2016. The cost remains at $37,000. The floor scrubber originally scheduled for 2016 was moved up to 2015. The Telesquirt fire truck scheduled for 2018 has been moved up to 2017 as the truck is beginning to have structural issues. Cost remains at $570,900. 6 The dumbbells for the fitness room scheduled to be replaced in 2014 have been moved back to 2017. HRA There are no changes to HRA items in this ERP. Pavilion: There are no changes to Pavilion items in this ERP. Parking: There are no changes to the Parking Dept. items in this ERP. Police: Marked squad cars that are replaced on a 3-year schedule at $71,200 have been increased to $90,000. Two cars are replaced each year in a three year cycle. The increase in cost is due to new models of police vehicles. The current equipment does not fit in the new models so new equipment needs to be purchased along with the cars. The sergeant’s vehicle scheduled for replacement in 2015 at $37,800 has been increased to $45,000 for the same reason the marked squad car cost was increased. The administrative vehicles for the police chief and captain will be leased starting in 2014. The chief’s car will be leased in 2014 and the captain’s in 2015. These vehicles were previously purchased on alternate years. The vehicles will leased for 4 years. The second two years of each lease will be used by the investigative sergeant (chief’s car) and a detective (captain’s car). The ERP item reflects the lease and a corresponding amount to outfit the vehicles estimated at $5,000 per vehicle. The police services liaison vehicle scheduled for replacement in 2015 at a cost of $25,000 has been removed from the ERP as it is no longer needed. A Drug Task Force vehicle has been added in 2014 on a leased basis. As part of the SW Metro DTF a vehicle is not provided to officers and each department needs to supply one. This vehicle will be leased for four years with the second two years of the lease going to a detective. The ERP item reflects the lease and a corresponding amount to outfit the vehicle estimated at $5,000. A FOCUS (Focus On Crime Using Strategy) vehicle has been added in 2015 on a leased basis. This car will be used by the FOCUS officers in the performance of their duties. This vehicle will be leased for four years with the second two years of the lease going to a detective. The ERP item reflects the lease and a corresponding amount to outfit the vehicle estimated at $5,000. 7 A logging recorded used by dispatch and scheduled for replacement in 2014 at a cost of $36,900 has been removed from the ERP. With dispatch moved to Hennepin County this item is no longer needed. Digital cameras for squad cars originally scheduled for 2014 have been moved back to 2015. The cost remains at $53,400. Mobile radios for squad cars originally scheduled for replacement in 2018 have been moved up according to car replacement. The current radios do not fit in the new model police cars so when new cars are purchased new radios will also be purchased and installed. Three were purchased in 2013, five will be purchased in 2014 and 2015 and three in 2016. The portable radios and mobiles for the Fire Dept. remain scheduled for 2018. Public Works: The lives of the equipment are annually reviewed by the public works department and over the past 10 years they have extended the lives of the 1-ton trucks from 8 to 12 years and the dump trucks from 13 to 17 years. Extending the lives of major equipment comes with the risk of increased maintenance costs. When maintenance costs become unmanageable the equipment will be put on the schedule for earlier replacement. Engineering No changes Parks/Forestry A tractor scheduled for 2016 at a cost of $49,300 was moved up to 2014 at a cost of $52,000. This vehicle will be replaced with a tool cat that has a blower and broom attachment. Cost was increased to reflect actual replacement cost. A trucksteer originally scheduled for 2013 was moved back to 2014. The cost was reduced from $19,800 to $11,000 to reflect the purchase of an electric style workman. Riding mowers scheduled for 2014 and 2015 at a cost of $11,000 and $20,000 were moved back to 2015 and 2016 at the same cost. Streets/Traffic A roller used by the street department for asphalt repair and resurfacing and originally scheduled for 2014 was moved back to 2016. Cost remains at $45,900. An asphalt paver used by the street department was moved from 2014 to 2016. The cost remains at $48,800. 8 A snow blower originally scheduled for replacement in 2016 at a cost of $102,300 has been moved up to 2014 and the cost reduced to $65,000 to reflect the purchase of a hydraulic powered blower. Refuse A rear loading refuse truck scheduled for replacement in 2014 at a cost of $101,600 has been moved back to 2015. Water There are no changes to water department items in this ERP. Sewer The 4x4 ¾ Ton Truck scheduled for replacement in 2014 at a cost of $35,700 has been reduced to $30,000 to more accurately reflect replacement cost. 9 10 11 12 EQUIPMENT REPLACEMENT FUND (602)07/26/2013 Impact on General Fund024,81230,54933,00336,59239,562 ate Change 5%0%8%9%9%9%9% R ACTUALBUDGETBUDGETBUDGETBUDGETBUDGETBUDGET 2012201320142015201620172018 Working Capital Begin Year890,189865,741 1 ,084,440 1 ,069,566 6 74,200 5 73,558 2 15,593 Revenues from charges316,784482,940 3 16,784 3 42,127 3 72,918 4 06,481 4 43,064 Transfer in General Fund50,000 5 0,000 5 0,000 Transfer In - Pavilion - Capital Lease20,000 1 5,609 Transfer In - Pavilion - Hockey Loan3,143 3 ,143 3 ,142 Federal & State Grants Interest earnings5,910 1 0,984 1 0,835 6 ,881 5 ,875 2 ,295 8 ,797 Other revenues (sale of assets)47,834 2 5,000 3 0,000 3 0,000 3 0,000 3 0,000 3 0,000 Equipment Certificates (Bonds)346,2741,272,000 4 51,769 Total Revenues739,944521,736 8 23,289 4 36,104 4 59,799 4 92,355 1 ,747,359 Expenditures (excludes Depr.) 15,802 1 6,276 1 6,764 1 7,267 1 7,785 1 8,319 1 8,868 Fire Truck Financing Pymnts (2009-2018)53,858 5 4,217 5 4,217 5 4,217 5 4,217 5 4,217 5 4,217 Capital Outlay - Equipment476,0341,246,448 7 03,300 7 60,488 4 88,958 7 78,318 1 ,024,676 2012 Equip Certificate Pymnts (10yr 3%)64,370 Total Expenses545,6941,442,908 8 38,163 8 31,469 5 60,442 8 50,320 1 ,097,211 Working Capital Ending Balance1,084,440(55,431) 1 ,069,566 6 74,200 5 73,558 2 15,593 8 65,741 (41,517) Actual/Estimated Cash balances1,098,353587,471 229,507 879,654 1,083,479 688,114 13 14 15 16 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20142018 thru PROJECTS BY YEAR Project NameProject #Priority Project Cost Department 2014 Art Center Theater Projection ScreenArts Center25,000 Art Center Theater Presentation MicrophonesArts Center16,000 Network ServerCity Hall Administrationn/a8,000 Financial Software - Various DeptsCity Hall Administrationn/a250,000 ComputersCity Hall Administrationn/a30,000 Election EquipmentCommunity Servicesn/a50,000 Aerial TruckFiren/a54,217 Automated External Defibrillator (2)Firen/a7,200 HRA CopierHRAn/a13,000 Marked Patrol Vehicles (6)Policen/a90,000 PSO - Utility 4x4 (unit 212)Policen/a47,700 Police Administrative Vehicles (2)Policen/a4,694 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 Drug Task Force VehiclePolicen/a4,694 Drug Task Force Vehicle - outfit leased vehiclePolicen/a5,000 Network Server (3)Policen/a8,500 Mobile Data ComputersPolicen/a62,700 Radios - Portable and Mobile DevicesPolicen/a20,500 Engineering VanPublic Works: Engineeringn/a2,000 3/4 Ton Utility TruckPublic Works: Parks/Forestryn/a32,200 TractorPublic Works: Parks/Forestryn/a52,000 Trucksters (3)Public Works: Parks/Forestryn/a11,000 Snow BlowerPublic Works: Streets/Trafficn/a65,000 4x4 3/4 Ton TruckSewern/a30,000 864,405 Total for 2014 2015 Art Center Community Room Audio VisualArts Centern/a11,000 Arts Center - Digital Information SignArts Center22,000 Network ServerCity Hall Administrationn/a8,000 Telephone SystemCity Hall Administrationn/a89,600 ComputersCity Hall Administrationn/a30,000 Fire Utility Vehicle (Pick Up Truck)Firen/a40,000 Aerial TruckFiren/a54,217 Floor ScrubberFiren/a14,300 Workout Equipment - ElipticalFiren/a5,800 Workout Equipment - Treadmill #1Firen/a5,800 Workout Equipment - Weight LiftingFiren/a5,800 4x4 3/4 Ton TruckHRAn/a32,400 Marked Patrol Vehicles (6)Policen/a90,000 Sergeant's VehiclePolicen/a45,000 Police Administrative Vehicles (2)Policen/a9,529 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 Drug Task Force VehiclePolicen/a4,694 Thursday, August 01, 2013 17 Project NameProject #Priority Project Cost Department Focus CarPolicen/a4,835 Focus Car - outfit leased vehiclePolicen/a5,000 Network Server (3)Policen/a8,500 Digital Squad Car CamerasPolicen/a53,400 Radios - Portable and Mobile DevicesPolicen/a20,500 Riding Mowers (2)Public Works: Parks/Forestryn/a11,000 4X4 3/4 Ton Truck with PlowPublic Works: Streets/Trafficn/a30,400 Sign Machine (Traffic)Public Works: Streets/Trafficn/a13,400 Refuse Truck (RAP-R) (2)Refusen/a204,800 Refuse Truck (Rear-L)Refusen/a101,600 906,575 Total for 2015 2016 Network ServerCity Hall Administrationn/a8,000 ComputersCity Hall Administrationn/a30,000 Duty Chief VehicleFiren/a37,000 Aerial TruckFiren/a54,217 Air CompressorFiren/a34,900 Self Contained Breathing Apparatus (45)Firen/a250,000 Marked Patrol Vehicles (6)Policen/a90,000 Parking Enforcement Vehicle (Parking Fund)Policen/a27,200 Police Administrative Vehicles (2)Policen/a14,509 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 SWAT VehiclePolicen/a30,000 Drug Task Force VehiclePolicen/a9,674 Drug Task Force Vehicle - outfit leased vehiclePolicen/a5,000 Copy Machine - Police DeptPolicen/a22,100 Focus CarPolicen/a4,835 Network Server (3)Policen/a8,500 Radios - Portable and Mobile DevicesPolicen/a12,300 Riding Mowers (2)Public Works: Parks/Forestryn/a20,000 Slope MowerPublic Works: Parks/Forestryn/a32,700 Skid Loader (2)Public Works: Streets/Trafficn/a41,900 RollerPublic Works: Streets/Trafficn/a45,900 Asphalt PaverPublic Works: Streets/Trafficn/a48,800 3/4 Ton Utility TruckSewern/a33,600 866,135 Total for 2016 2017 Art Center Video Camera UpdatesArts Centern/a3,700 Network ServerCity Hall Administrationn/a8,000 ComputersCity Hall Administrationn/a30,000 Document Management Scanner (2)Community Servicesn/a6,000 Tele-Squirt (Engine 2)Firen/a570,900 Aerial TruckFiren/a54,217 Thermal Imaging Camera (2)Firen/a12,900 Workout Equipment - Treadmill #2Firen/a5,800 Workout Equipment - Dumb BellsFiren/a5,000 Marked Patrol Vehicles (6)Policen/a98,000 Police Administrative Vehicles (2)Policen/a19,638 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 Drug Task Force VehiclePolicen/a9,674 Focus CarPolicen/a9,964 Focus Car - outfit leased vehiclePolicen/a5,000 Network Server (3)Policen/a8,500 Thursday, August 01, 2013 18 Project NameProject #Priority Project Cost Department Taser ReplacementPolice320,900 Stump CutterPublic Works: Parks/Forestryn/a21,200 Skid LoaderPublic Works: Parks/Forestryn/a32,000 Water TruckPublic Works: Streets/Trafficn/a150,000 StriperPublic Works: Streets/Trafficn/a11,200 Generator (2)Sewern/a26,400 1/2 Ton TruckWatern/a26,800 3/4 Ton Utility TruckWatern/a34,900 1,175,693 Total for 2017 2018 Art Center Theater ProjectorArts Centern/a17,100 Network ServerCity Hall Administrationn/a8,000 ComputersCity Hall Administrationn/a30,000 Core Network SwitchCity Hall Administrationn/a12,000 Document Management Scanner (2)Community Servicesn/a6,000 Aerial TruckFiren/a54,217 Automated External Defibrillator (2)Firen/a7,800 Marked Patrol Vehicles (6)Policen/a98,000 Police Administrative Vehicles (2)Policen/a20,224 Police Admin Cars - outfit leased vehiclesPolicen/a5,000 Drug Task Force VehiclePolicen/a10,260 Drug Task Force Vehicle - outfit leased vehiclePolicen/a5,000 Focus CarPolicen/a9,964 Network Server (3)Policen/a8,500 Tactical Ballistic VestsPolicen/a26,900 Radios - Portable and Mobile DevicesPolicen/a534,400 4X4 1/2 Ton TruckPublic Works: Bldg/Equip Servn/a31,300 Turf SweeperPublic Works: Parks/Forestryn/a18,000 ToolcatPublic Works: Parks/Forestryn/a63,300 4x2 1 Ton Dump TruckPublic Works: Streets/Trafficn/a54,600 Single Axle Dump Truck (3)Public Works: Streets/Trafficn/a124,000 Tandem Dump TruckPublic Works: Streets/Trafficn/a173,200 1,317,765 Total for 2018 5,130,573 GRAND TOTAL Thursday, August 01, 2013 19 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20142018 thru DEPARTMENT SUMMARY Department20142015201620172018Total Arts Center11,00013,0003,70017,100 City Hall Administration288,000127,60038,00038,00050,000 Community Services50,0006,0006,000 Fire61,417125,917376,117648,81762,017 HRA13,00032,400 Police248,788246,458229,118176,676718,248 Public Works: Bldg/Equip Serv31,300 Public Works: Engineering2,000 Public Works: Parks/Forestry95,20011,00052,70053,20081,300 Public Works: Streets/Traffic65,00043,800136,600161,200351,800 Refuse306,400 Sewer30,00033,60026,400 Water61,700 864,405906,575866,1351,175,6931,317,765 TOTAL 20 Thursday, August 01, 2013 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20142018 thru PROJECTS BY DEPARTMENT DepartmentProject#Priority20142015201620172018 Total Arts Center Art Center Video Camera Updatesn/a3,700 Art Center Theater Projectorn/a17,100 Art Center Community Room Audio Visualn/a11,000 Arts Center - Digital Information Sign22,000 Art Center Theater Projection Screen25,000 Art Center Theater Presentation Microphones16,000 Arts Center Total City Hall Administration Network Servern/a8,0008,0008,0008,0008,000 Telephone Systemn/a89,600 Financial Software - Various Deptsn/a250,000 Computersn/a30,00030,00030,00030,00030,000 Core Network Switchn/a12,000 City Hall Administration Total Community Services Document Management Scanner (2)n/a6,0006,000 Election Equipmentn/a50,000 Community Services Total Fire Tele-Squirt (Engine 2)n/a570,900 Duty Chief Vehiclen/a37,000 Fire Utility Vehicle (Pick Up Truck)n/a40,000 Aerial Truckn/a54,21754,21754,21754,21754,217 Air Compressorn/a34,900 Self Contained Breathing Apparatus (45)n/a250,000 Thermal Imaging Camera (2)n/a12,900 Floor Scrubbern/a14,300 Workout Equipment - Elipticaln/a5,800 Workout Equipment - Treadmill #1n/a5,800 Workout Equipment - Treadmill #2n/a5,800 Workout Equipment - Weight Liftingn/a5,800 Automated External Defibrillator (2)n/a7,2007,800 Workout Equipment - Dumb Bellsn/a5,000 Fire Total HRA 4x4 3/4 Ton Truckn/a32,400 HRA Copiern/a13,000 21 Thursday, August 01, 2013 DepartmentProject#Priority20142015201620172018 Total HRA Total Police Marked Patrol Vehicles (6)n/a90,00090,00090,00098,00098,000 Sergeant's Vehiclen/a45,000 Parking Enforcement Vehicle (Parking Fund)n/a27,200 PSO - Utility 4x4 (unit 212)n/a47,700 Police Administrative Vehicles (2)n/a4,6949,52914,50919,63820,224 Police Admin Cars - outfit leased vehiclesn/a5,0005,0005,0005,0005,000 SWAT Vehiclen/a30,000 Drug Task Force Vehiclen/a4,6944,6949,6749,67410,260 Drug Task Force Vehicle - outfit leased vehiclen/a5,0005,0005,000 Copy Machine - Police Deptn/a22,100 Focus Carn/a4,8354,8359,9649,964 Focus Car - outfit leased vehiclen/a5,0005,000 Network Server (3)n/a8,5008,5008,5008,5008,500 Mobile Data Computersn/a62,700 Digital Squad Car Camerasn/a53,400 Tactical Ballistic Vestsn/a26,900 Radios - Portable and Mobile Devicesn/a20,50020,50012,300534,400 Taser Replacement320,900 Police Total Public Works: Bldg/Equip Serv 4X4 1/2 Ton Truckn/a31,300 Public Works: Bldg/Equip Serv Total Public Works: Engineering Engineering Vann/a2,000 Public Works: Engineering Total Public Works: Parks/Forestry 3/4 Ton Utility Truckn/a32,200 Tractorn/a52,000 Trucksters (3)n/a11,000 Riding Mowers (2)n/a11,00020,000 Slope Mowern/a32,700 Turf Sweepern/a18,000 Stump Cuttern/a21,200 Skid Loadern/a32,000 Toolcatn/a63,300 Public Works: Parks/Forestry Total Public Works: Streets/Traffic 4X4 3/4 Ton Truck with Plown/a30,400 4x2 1 Ton Dump Truckn/a54,600 Single Axle Dump Truck (3)n/a124,000 Tandem Dump Truckn/a173,200 Water Truckn/a150,000 Skid Loader (2)n/a41,900 Rollern/a45,900 Stripern/a11,200 22 Thursday, August 01, 2013 DepartmentProject#Priority20142015201620172018 Total Asphalt Pavern/a48,800 Snow Blowern/a65,000 Sign Machine (Traffic)n/a13,400 Public Works: Streets/Traffic Total Refuse Refuse Truck (RAP-R) (2)n/a204,800 Refuse Truck (Rear-L)n/a101,600 Refuse Total Sewer 4x4 3/4 Ton Truckn/a30,000 3/4 Ton Utility Truckn/a33,600 Generator (2)n/a26,400 Sewer Total Water 1/2 Ton Truckn/a26,800 3/4 Ton Utility Truckn/a34,900 Water Total GRAND TOTAL 23 Thursday, August 01, 2013 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20142018 thru FUNDING SOURCE SUMMARY 20142015201620172018Total Source AC - Arts Center Fund6,00011,0003,70017,100 Bonds/Lease54,21754,21754,21754,21754,217 Equipment Replacement Fund755,488488,958778,3181,029,6761,246,448 HRA - Housing and Redevelopment Authority13,00032,400 PKG - Parking Fund5,700 RF - Refuse Fund306,400 SF - Sanitary Sewer Fund30,0006,80033,60026,400 WF - Water Fund6,80061,700 864,405906,575866,1351,175,6931,317,765 GRAND TOTAL Thursday, August 01, 2013 24 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 20142018 thru PROJECTS BY FUNDING SOURCE SourceProject#Priority20142015201620172018Total AC - Arts Center Fund Art Center Video Camera Updatesn/a3,700 Art Center Theater Projectorn/a17,100 Art Center Community Room Audio Visualn/a11,000 Art Center Theater Presentation Microphones16,000 AC - Arts Center Fund Total Bonds/Lease Aerial Truckn/a54,21754,21754,21754,21754,217 Bonds/Lease Total Equipment Replacement Fund Network Servern/a8,0008,0008,0008,0008,000 Telephone Systemn/a76,000 Financial Software - Various Deptsn/a250,000 Computersn/a30,00030,00030,00030,00030,000 Document Management Scanner (2)n/a6,0006,000 Election Equipmentn/a50,000 Core Network Switchn/a12,000 Tele-Squirt (Engine 2)n/a570,900 Duty Chief Vehiclen/a37,000 Fire Utility Vehicle (Pick Up Truck)n/a40,000 Air Compressorn/a34,900 Self Contained Breathing Apparatus (45)n/a250,000 Thermal Imaging Camera (2)n/a12,900 Floor Scrubbern/a14,300 Workout Equipment - Elipticaln/a5,800 Workout Equipment - Treadmill #1n/a5,800 Workout Equipment - Treadmill #2n/a5,800 Workout Equipment - Weight Liftingn/a5,800 Automated External Defibrillator (2)n/a7,2007,800 Workout Equipment - Dumb Bellsn/a5,000 Marked Patrol Vehicles (6)n/a90,00090,00090,00098,00098,000 Sergeant's Vehiclen/a45,000 Parking Enforcement Vehicle (Parking Fund)n/a27,200 PSO - Utility 4x4 (unit 212)n/a47,700 Police Administrative Vehicles (2)n/a4,6949,52914,50919,63820,224 Police Admin Cars - outfit leased vehiclesn/a5,0005,0005,0005,0005,000 SWAT Vehiclen/a30,000 Drug Task Force Vehiclen/a4,6944,6949,6749,67410,260 Drug Task Force Vehicle - outfit leased vehiclen/a5,0005,0005,000 Copy Machine - Police Deptn/a22,100 Thursday, August 01, 2013 25 SourceProect#Priorit20142015201620172018Total jy Focus Carn/a4,8354,8359,9649,964 Focus Car - outfit leased vehiclen/a5,0005,000 Network Server (3)n/a8,5008,5008,5008,5008,500 Mobile Data Computersn/a57,000 Digital Squad Car Camerasn/a53,400 Tactical Ballistic Vestsn/a26,900 Radios - Portable and Mobile Devicesn/a20,50020,50012,300534,400 Taser Replacement320,900 4X4 3/4 Ton Truck with Plown/a30,400 4x2 1 Ton Dump Truckn/a54,600 Single Axle Dump Truck (3)n/a124,000 Tandem Dump Truckn/a173,200 Water Truckn/a150,000 Skid Loader (2)n/a41,900 Rollern/a45,900 Stripern/a11,200 Asphalt Pavern/a48,800 Snow Blowern/a65,000 Sign Machine (Traffic)n/a13,400 Engineering Vann/a2,000 4X4 1/2 Ton Truckn/a31,300 3/4 Ton Utility Truckn/a32,200 Tractorn/a52,000 Trucksters (3)n/a11,000 Riding Mowers (2)n/a11,00020,000 Slope Mowern/a32,700 Turf Sweepern/a18,000 Stump Cuttern/a21,200 Skid Loadern/a32,000 Toolcatn/a63,300 Arts Center - Digital Information Sign22,000 Art Center Theater Projection Screen25,000 Equipment Replacement Fund Total HRA - Housing and Redevelopment A 4x4 3/4 Ton Truckn/a32,400 HRA Copiern/a13,000 HRA - Housing and Redevelopment Authority Total PKG - Parking Fund Mobile Data Computersn/a5,700 PKG - Parking Fund Total RF - Refuse Fund Refuse Truck (RAP-R) (2)n/a204,800 Refuse Truck (Rear-L)n/a101,600 RF - Refuse Fund Total SF - Sanitary Sewer Fund Thursday, August 01, 2013 26 SourceProect#Priorit20142015201620172018Total jy Telephone Systemn/a6,800 4x4 3/4 Ton Truckn/a30,000 3/4 Ton Utility Truckn/a33,600 Generator (2)n/a26,400 SF - Sanitary Sewer Fund Total WF - Water Fund Telephone Systemn/a6,800 1/2 Ton Truckn/a26,800 3/4 Ton Utility Truckn/a34,900 WF - Water Fund Total GRAND TOTAL Thursday, August 01, 2013 27 28 29 30 EQUIPMENT REPLACEMENT PLAN 20142018 thru Department Arts Center Cit of HokinsMN yp, ContactArts Center Director TypeEquipment 01-ERP-1103 Project # Useful Life 5 years Art Center Video Camera Updates Project Name Category Equipment FuturePriority n/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 20142015201620172018Future Equipment 3,7003,700 3,20015,100 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 3,7003,700 3,200 AC - Arts Center Fund 15,100 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $-0- Monday, July 29, 2013 31 EQUIPMENT REPLACEMENT PLAN 20142018 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:$75,000 Description Current projector is 3000 lumen -- 6500 lumen is required for theater usage including in partial light situations and to achieve the clarity needed for detailed images. Such a projector costs about $7,200 (including mounting and rigging hardware, cables and installation labor). The projector also needs to be part of a professional system that permits it to be operated from the theater tech booth or from on-stage -- the current projector is only operable from a hand-held remote requiring the operator to dash into the audience of the theater. This total cost of $15,200 includes all the wiring and hardware needed to support a projector well into the future. The projector itself is estimated to have a 5-year useful life. (The existing projector will be moved to one of the meeting rooms). Justification The justification of this expense is two-fold: First, in order to attract and retain arts and corporate renters we need to be able to provide the technical support required for their events. Income from such rentals (including Pen Pals and Digital Rivers) is becoming increasingly vital to the financial health of the Center. If we are not capable of competing with similar size venues, we will lose this income. Secondly, as a professional arts presenter we need to have the technical capatabilities to run our own programs in a professional manner. Year 2018: $17,100 Year 2023 $19,800 Year 2028 $22,900 PriorExpenditures20142015201620172018TotalFuture Equipment 17,10017,100 15,20042,700 TotalTotalTotal PriorFunding Sources20142015201620172018Total Future 17,10017,100 15,200 AC - Arts Center Fund 42,700 TotalTotalTotal Budget Impact/Other Investing $15, 000 to retain major renters such as Pen Pals and Digital Rivers is worthwhile. Pen Pals alone brings in about $20.000/year in income. Digital Rivers just under $9,000. Monday, July 29, 2013 32 EQUIPMENT REPLACEMENT PLAN 20142018 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. Add two microphones. Mount supporting hardware in rack that fits into closet. Justification An increasing number of users of this room require media support. Current means of providing this include the use of an oversized A/V cart, cords stretch across the floor and a large speaker on a stick. We can streamline the appearance and functionality by making these appropriate changes. These changes also address safety concerns. They will help attract safety concerns. They will help attract and retain rental customers as well as appropriately support our own activities. ExpendituresTotalFuture 20142015201620172018 Equipment 11,00011,000 30,100 TotalTotal Funding Sources20142015201620172018TotalFuture 11,00011,000 AC - Arts Center Fund 30,100 TotalTotal Budget Impact/Other Move this item from 2014 to 2015. Monday, July 29, 2013 33 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Co-Director Type Equipment 01-ERP-1106 Project # Useful Life 5 years Arts Center - Digital Information Sign Project Name Category Equipment FuturePriority2 Very Important Total Project Cost:$10,100 Description Add programmable and highly visable digital sign to information desk area. (Viewsonic 42" with integrated media, software - or similar) Justification Current system of posting printed schedules and key information each day is overlooked by visitors and difficult to update rapidly. ExpendituresTotalFuture 20142015201620172018 Equipment 2,0002,000 8,100 TotalTotal Funding Sources20142015201620172018TotalFuture 2,0002,000 Equipment Replacement Fund 8,100 TotalTotal Budget Impact/Other Variance from 20 year plan - New Item Estimated salvage/resale value $0 Monday, July 29, 2013 34 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentArts Center Cit of Hokins MN yp, Contact Arts Center Director Type Equipment 01-ERP-1107 Project # Useful Life 10 years Art Center Theater Projection Screen Project Name Category Equipment FuturePriority2 Very Important Total Project Cost:$11,700 Description Replace original retractable projection screen in the theater with wider format screen to mesh with current technology. Justification This is an item being requested more frequently from renters as they find the dimensions of the current screen do not match up with the presentations they bring in. ExpendituresTotalFuture 20142015201620172018 Equipment 5,0005,000 6,700 TotalTotal Funding Sources20142015201620172018TotalFuture 5,0005,000 Equipment Replacement Fund 6,700 TotalTotal Budget Impact/Other Variance from 20-year plan: New item Monday, July 29, 2013 35 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentArts Center Cit of Hokins MN yp, Contact Type Equipment 01-ERP-1108 Project # Useful Life 6 years Art Center Theater Presentation Microphones Project Name Category Equipment FuturePriority1 Urgent Total Project Cost:$31,800 Description Replace theater lapel (3) and hand held (3) microphones with supporting transmitters, receivers, splitter kit and rackmount kit. Justification Current microphones are of insufficient quality to work well in a space as large as the theater resulting in technical glitches during presentations. These are necessary for Center functions, City functions and rental events in the theater. ExpendituresTotalFuture 20142015201620172018 Equipment 6,0006,000 25,800 TotalTotal Funding Sources20142015201620172018TotalFuture 6,0006,000 AC - Arts Center Fund 25,800 TotalTotal Budget Impact/Other Variance from 20-year plan: New item. Monday, July 29, 2013 36 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentCity Hall Administration Cit of Hokins MN yp, Contact Finance Director/IT Type Equipment 01-ERP-0003 Project # Useful Life 1 year Network Server Project Name Category Equipment FuturePriorityn/a Total Project Cost:$249,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 20142015201620172018Future Equipment 8,0008,0008,0008,0008,00040,000 89,000120,000 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 8,0008,0008,0008,0008,00040,000 89,000 Equipment Replacement Fund 120,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Monday, July 29, 2013 37 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 89,60089,600 60,000200,300 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 76,00076,000 60,000 Equipment Replacement Fund 200,300 6,8006,800 SF - Sanitary Sewer Fund TotalTotal 6,8006,800 WF - Water Fund 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: $ Monday, July 29, 2013 38 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentCity Hall Administration Cit of Hokins MN yp, Contact Finance Director Type Equipment 01-ERP-0005 Project # Useful Life 7 years Financial Software - Various Depts Project Name Category Equipment FuturePriorityn/a Total Project Cost:$415,000 Description Finace software upgrade. Software currently used by Finance, City Clerk, Inspections and Public Works. This includes software for all finance applicatons including general ledger, payroll, accounts payable, accounts receivable, fixed assets, utility billing; Business Licesnes, Building Permits, GIS Mapping, Purchasing, etc. Justification Current software vendor is unable to keep up with technology and internet security standards. Staff is often frustrated with how the software works and are often unable to get reports they need from the system. PriorExpendituresTotal 20142015201620172018 Equipment 250,000250,000 165,000 TotalTotal PriorFunding Sources20142015201620172018Total 250,000250,000 165,000 Equipment Replacement Fund TotalTotal Budget Impact/Other Variance from 20 year plan - replacement needed in 2014 Estimate salvage/resale value on replaced item: $-0- Monday, July 29, 2013 39 EQUIPMENT REPLACEMENT PLAN 20142018 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:$990,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 20142015201620172018Future Equipment 30,00030,00030,00030,00030,000150,000 390,000450,000 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 30,00030,00030,00030,00030,000150,000 390,000 Equipment Replacement Fund 450,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Monday, July 29, 2013 40 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentCity Hall Administration Cit of Hokins MN yp, Contact Finance Director/IT Type Equipment 01-ERP-0012 Project # Useful Life 6 years Core Network Switch Project Name Category Equipment FuturePriorityn/a Total Project Cost:$53,300 Description Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates fibr optic network connection to fire department. 2 - Cisco 3560E-24PD managed switch - $3,000 each 2 - Cisco X2-10GB-LR fiber optic transceiver - $1200 each cost listed is for equipment only and does not include tax, shipping and other related costs Justification Current two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in significant network outage that was immediately noticed by many employees. PriorExpendituresTotal 20142015201620172018Future Equipment 12,00012,000 10,00031,300 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 12,00012,000 10,000 Equipment Replacement Fund 31,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Not currently in ERP but critical to network communication infrastructure. This is outside the budget for city hall server network budget as the "Lisa" service is scheduled for replacement due to end of life, out of PCI compliance and obsolete. Estimate salvage/resale value on replace item: - $-0- Monday, July 29, 2013 41 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentCommunity Services Cit of Hokins MN yp, Contact City Clerk Type Equipment 01-ERP-0008 Project # Useful Life 5 years Document Management Scanner (2) Project Name Category Equipment FuturePriorityn/a Total Project Cost:$65,100 Description Large document (11” x17”) scanner for document management and retention as well as general administrative use. Purchased two scanners in 2012 at a cost of $10,315. (1) Scanner in 2017, 2022 and 2027 (1) Scanner in 2018, 2023 and 2028 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 20142015201620172018Future Equipment 6,0006,00012,000 23,30029,800 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 6,0006,00012,000 23,300 Equipment Replacement Fund 29,800 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 Monday, July 29, 2013 42 EQUIPMENT REPLACEMENT PLAN 20142018 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. Asking for 10 in replacement plan from County. Justification All Hennepin County equipment is being replaced in 2014. ExpendituresTotalFuture 20142015201620172018 Equipment 50,00050,000 67,200 TotalTotal Funding Sources20142015201620172018TotalFuture 50,00050,000 Equipment Replacement Fund 67,200 TotalTotal Budget Impact/Other Variance from 20 year plan - Move from 2013 to 2014 Estimate salvage/resale value on replaced item: $-0- Monday, July 29, 2013 43 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0100 Project # Useful Life 10 years Tele-Squirt (Engine 2) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$1,338,100 Description Fire engine: full size response truck Current vehicle: 1989 Ford L9000 Tele-Squirt (#102) Justification This is a replacement engine for response to emergency response in the City. We will be reducing the fleet by one truck in making this one unit (ladder/pumper) which would reduce the life of a vehicle from 25 years to 10 years. We are finding that the life a vehicle is no longer 20 years. ExpendituresTotalFuture 20142015201620172018 Equipment 570,900570,900 767,200 TotalTotal Funding Sources20142015201620172018TotalFuture 570,900570,900 Equipment Replacement Fund 767,200 TotalTotal Budget Impact/Other Variance from 20 year plan - was scheduled for replacement in 2019 and has been moved up to 2017. Change useful life from 25 to 10 years. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 44 EQUIPMENT REPLACEMENT PLAN 20142018 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. PriorExpenditures20142015201620172018TotalFuture Vehicles 37,00037,000 64,500152,700 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 37,00037,000 64,500 Equipment Replacement Fund 152,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Add 2 vehicles and change life to 15 years. Move 2015 replacement back to 2016. Estimate salvage/resale value on replaced item: $4,000 Monday, July 29, 2013 45 EQUIPMENT REPLACEMENT PLAN 20142018 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:$201,700 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 20142015201620172018 Vehicles 40,00040,000 161,700 TotalTotal Funding Sources20142015201620172018TotalFuture 40,00040,000 Equipment Replacement Fund 161,700 TotalTotal Budget Impact/Other Variance from 20 year plan - Change from 10 year life to 5 years. Move from 2016 to 2015 and increased cost from $35,000 to $40,000 Estimate of salvage/resale value on replace item - $ Monday, July 29, 2013 46 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 54,21754,21754,21754,21754,217271,085 716,5121,572,000 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 54,21754,21754,21754,21754,217271,085 716,512 Bonds/Lease 1,572,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - .Lease payments on financing added to the plan. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 47 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 34,90034,900 54,400 TotalTotal Funding Sources20142015201620172018TotalFuture 34,90034,900 Equipment Replacement Fund 54,400 TotalTotal Budget Impact/Other Variance from 20 year plan - move back to 2017 Estimate salvage/resale value on replaced item - $ Purchased: 1996 Monday, July 29, 2013 48 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 250,000250,000 166,000336,000 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 250,000250,000 166,000 Equipment Replacement Fund 336,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 49 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 12,90012,900 26,50032,800 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 12,90012,900 26,500 Equipment Replacement Fund 32,800 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- Monday, July 29, 2013 50 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 14,30014,300 20,300 TotalTotal Funding Sources20142015201620172018TotalFuture 14,30014,300 Equipment Replacement Fund 20,300 TotalTotal Budget Impact/Other Variance from 20 year plan - Eliminate sweeper and add scrubber as scrubber is used more. Move from 2016 to 2015 Estimate salvage/resale value on replaced item: $0 Monday, July 29, 2013 51 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 5,8005,800 14,500 TotalTotal Funding Sources20142015201620172018TotalFuture 5,8005,800 Equipment Replacement Fund 14,500 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: $ Monday, July 29, 2013 52 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0117 Project # Useful Life 5 years Workout Equipment - Treadmill #1 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 - will be replaced with a treadmill Justification This equipment is available to all City employees for health and wellness. PriorExpendituresTotal 20142015201620172018Future Equipment 5,8005,800 5,00023,500 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 5,8005,800 5,000 Equipment Replacement Fund 23,500 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - replaces stairmaster. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 53 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentFire Cit of Hokins MN yp, Contact Fire Chief Type Equipment 01-ERP-0118 Project # Useful Life 5 years Workout Equipment - Treadmill #2 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 20142015201620172018Future Equipment 5,8005,800 5,00014,500 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 5,8005,800 5,000 Equipment Replacement Fund 14,500 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back one year from 2011 to 2012. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 54 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 5,8005,800 23,500 TotalTotal Funding Sources20142015201620172018TotalFuture 5,8005,800 Equipment Replacement Fund 23,500 TotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2011 to 2015 Estimate salvage/resale value on replaced items: $ Monday, July 29, 2013 55 EQUIPMENT REPLACEMENT PLAN 20142018 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 PriorExpenditures20142015201620172018TotalFuture Equipment 7,2007,80015,000 6,00028,100 TotalTotalTotal PriorFunding Sources20142015201620172018Total Future 7,2007,80015,000 6,000 Equipment Replacement Fund 28,100 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - adjustment from 3 years to 4 years. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 56 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 5,0005,000 6,700 TotalTotal Funding Sources20142015201620172018TotalFuture 5,0005,000 Equipment Replacement Fund 6,700 TotalTotal Budget Impact/Other Variance from 20 year plan - Move back from 2014 to 2017. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 57 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Vehicles 32,40032,400 22,80093,200 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 32,40032,400 22,800 HRA - Housing and Redevelop 93,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,800 Monday, July 29, 2013 58 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 13,00013,000 37,400 TotalTotal Funding Sources20142015201620172018TotalFuture 13,00013,000 HRA - Housing and Redevelop 37,400 TotalTotal Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replace item: $ - 0 - Monday, July 29, 2013 59 EQUIPMENT REPLACEMENT PLAN 20142018 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:$3,280,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 20142015201620172018Future Vehicles 90,00090,00090,00098,00098,000466,000 778,1002,036,000 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 90,00090,00090,00098,00098,000466,000 778,100 Equipment Replacement Fund 2,036,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - cost modified due to new models of squads which need to be re-outfitted for all equipment. Estimate salvage/resale value on replaced item: $4,000 each Monday, July 29, 2013 60 EQUIPMENT REPLACEMENT PLAN 20142018 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:$322,200 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 20142015201620172018Future Vehicles 45,00045,000 33,600243,600 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 45,00045,000 33,600 Equipment Replacement Fund 243,600 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - cost modified due to new model of car which will require all new equipment. Estimate salvage/resale value on replaced item: $3,500 each Monday, July 29, 2013 61 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Vehicles 27,20027,200 18,70036,600 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 27,20027,200 18,700 Equipment Replacement Fund 36,600 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 Monday, July 29, 2013 62 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0203 Project # Useful Life 6 years PSO - 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 20142015201620172018Future Vehicles 47,70047,700 67,400218,600 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 47,70047,700 67,400 Equipment Replacement Fund 218,600 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none. Estimate salvage/resale value on replaced item: $5,000 Monday, July 29, 2013 63 EQUIPMENT REPLACEMENT PLAN 20142018 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:$754,322 Description Police administration (chief, captian), Investigative Sergeant, and Detective vehicles. Replace Chief's vehicle - even numbered years Replace Captain's vehicle - odd numbered years Effective 2014 - Chief vehicle to be leased for 4 years - 2yr for chief and 2yr for Investigative Sergeant. In year 3 the Chief will get a new leased vehicle and use for two years before again passing the vehicle down to the Investigative Sergeant who will use it for another 2 years. Effective 2015 - Captain vehcile to be leaed for 4 years - 2yr for captain and 2yr for Detective #3. In year 3 of lease the Capitain will get a new leased vehicle, use for 2 years before passing down to Detective #3 who will use it for another two years. There are 4 leased vehicles accounted for in this ERP item 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. PriorExpenditures20142015201620172018TotalFuture 4,6949,52914,50919,63820,22468,594 298,700 Vehicles 387,028 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 4,6949,52914,50919,63820,22468,594 298,700 Equipment Replacement Fund 387,028 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - starting in 2014 chiefs vehcile will be leased and in 2015 the captians will be leased. Estimate salvage/resale value on replaced item: $4,000 each for current vehicles not leased. Monday, July 29, 2013 64 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0204a Project # Useful Life Police Admin Cars - outfit leased vehicles Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$100,000 Description Cost to outfit leased police chief and captains cars Justification We need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. Chief & Captain get a new vehicle every other year. Year 3 & 4 of chief lease - investigative sergeant Year 3 & 4 of captain lease - detective Since one is purchased each year the cost is estimated at $5,000 per vehicle per year. ExpendituresTotalFuture 20142015201620172018 Equipment 5,0005,0005,0005,0005,00025,000 75,000 TotalTotal Funding Sources20142015201620172018TotalFuture 5,0005,0005,0005,0005,00025,000 Equipment Replacement Fund 75,000 TotalTotal Budget Impact/Other Variance from 20 year plan: Cost of outfitting chief's and captain's vehicles is now accounted for separately from the vehicle purchase since the vehicles are now leased. Monday, July 29, 2013 65 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Vehicles 30,00030,000 46,700 TotalTotal Funding Sources20142015201620172018TotalFuture 30,00030,000 Equipment Replacement Fund 46,700 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 Monday, July 29, 2013 66 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0206 Project # Useful Life 4 years Drug Task Force Vehicle Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$232,276 Description Drug Task Force Vehicle Effective in 2014 this vehicle will be leased for 4 years 2 years as a DTF vehicle 2 years as Detective #1 vehicle (This accounts for the lease for 2 vehicles) Justification Previously in the NW Metro DTF which provided a vehicle. Now in SW Metro DTF and we need to provide our own vehicle. ExpendituresTotalFuture 20142015201620172018 Vehicles 4,6944,6949,6749,67410,26038,996 193,280 TotalTotal Funding Sources20142015201620172018TotalFuture 4,6944,6949,6749,67410,26038,996 Equipment Replacement Fund 193,280 TotalTotal Budget Impact/Other Variance from 20 year plan: New for 2014 Monday, July 29, 2013 67 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0206a Project # Useful Life Drug Task Force Vehicle - outfit leased vehicle Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$50,000 Description Cost to outfit leased Drug Task Force vehicle Justification We need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. DTF vehicle will be replaced every 2 years with the 2nd two years of the lease going to a Detective. ExpendituresTotalFuture 20142015201620172018 Equipment 5,0005,0005,00015,000 35,000 TotalTotal Funding Sources20142015201620172018TotalFuture 5,0005,0005,00015,000 Equipment Replacement Fund 35,000 TotalTotal Budget Impact/Other Variance from 20 year plan: Cost of outfitting DTF vehicles is now accounted for separately from the vehicle purchase since the vehicle is now now leased. Monday, July 29, 2013 68 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 22,10022,100 49,80089,700 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 22,10022,100 49,800 Equipment Replacement Fund 89,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Monday, July 29, 2013 69 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0210 Project # Useful Life 4 years Focus Car Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$223,346 Description Focus Vehicle (Focus on Crime Using Strategies) Effective in 2015 this vehicle will be leased for 4 years 2 years as a Focus vehicle 2 years as Detective #2 vehicle (This accounts for the lease for 2 vehicles) Justification This is the street crime/undercover vehicle. Previously did not have a car for this purpose. Expenditures20142015201620172018TotalFuture Equipment 4,8354,8359,9649,96429,598 193,748 TotalTotal Funding Sources20142015201620172018TotalFuture 4,8354,8359,9649,96429,598 Equipment Replacement Fund 193,748 TotalTotal Budget Impact/Other Variance from 20 year plan: New for 2015 Monday, July 29, 2013 70 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0210a Project # Useful Life Focus Car - outfit leased vehicle Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$50,000 Description Cost to outfit leased Focus vehicle Justification We need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. Focus vehicle will be replaced every 2 years with the 2nd two years of the lease going to a Detective ExpendituresTotalFuture 20142015201620172018 Equipment 5,0005,00010,000 40,000 TotalTotal Funding Sources20142015201620172018TotalFuture 5,0005,00010,000 Equipment Replacement Fund 40,000 TotalTotal Budget Impact/Other Variance from 20 year plan: Cost of outfitting Focus vehicle is now accounted for separately from the vehicle purchase since the vehicle is now now leased. Monday, July 29, 2013 71 EQUIPMENT REPLACEMENT PLAN 20142018 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:$263,500 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 20142015201620172018Future Equipment 8,5008,5008,5008,5008,50042,500 93,500127,500 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 8,5008,5008,5008,5008,50042,500 93,500 Equipment Replacement Fund 127,500 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Cost stabilized at $8,500 per year. Estimate salvage/resale value on replaced item - $ Monday, July 29, 2013 72 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 62,70062,700 47,000188,100 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 57,00057,000 47,000 Equipment Replacement Fund 188,100 5,7005,700 PKG - Parking Fund TotalTotal 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- Monday, July 29, 2013 73 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 53,40053,400 42,600160,200 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 53,40053,400 42,600 Equipment Replacement Fund 160,200 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: $ Monday, July 29, 2013 74 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 26,90026,900 43,20067,400 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 26,90026,900 43,200 Equipment Replacement Fund 67,400 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Team membership has increased to 11. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 75 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPolice Cit of Hokins MN yp, Contact Police Chief Type Equipment 01-ERP-0215 Project # Useful Life Radios - Portable and Mobile Devices Project Name Category Equipment FuturePriorityn/a Total Project Cost:$600,000 Description Portable and mobile radios used by the police, fire and public works departments to allow these departments to communicate on one frequency. Police and fire use their radios on a daily/regular basis. The public works only uses theirs in the event of an emergency. Estimated Replacement Cost (based on 2012 cost) Portable - $3,800 x 111 = $421,800 Mobile - $4,100 x 26 = $106,600 Total Radios $528,500 Installation of mobile $ 71,600 est Grand Total $600,000 target budget Police Fire PW Total Portable 65 46 0 111 PW radios went to Fire as PW wasn't using them. Mobile 17 9 0 26 Police Est Cost $363,500 Fire Est Cost $236,500 Pub Works Est Cost $ 0 Justification Provides radios so that the police, fire and public works can communicate on a common radio frequency during an emergency and multiple county interoperability. Mobile radios were replaced in police cars due to new model cars: 2013 - replaced in Captain car, squad #3, & #5 (3 = $12,300) 2014 - replace in Squad #1, #2, PSO, Chief, DTF (5 = $20,500) 2015 - replace in squad #4, #6, Sergeant, Captain, FOCUS (5 = $20,500) 2016 - replace in squad parking (1 = $4,100) note - some cars are duplicated as they are moved down to investigators PriorExpenditures20142015201620172018Total Equipment 20,50020,50012,300534,400587,700 12,300 TotalTotal PriorFunding Sources20142015201620172018Total 20,50020,50012,300534,400587,700 12,300 Equipment Replacement Fund TotalTotal Budget Impact/Other Variance from 20 year plan - Radio's have a 7-10 year life expectancy. Due to new squad models and the placement of the radios we needed to buy a new model of radio to fit into the squads.. Estimate salvage/resale value on replaced item: $0 Monday, July 29, 2013 76 EQUIPMENT REPLACEMENT PLAN 20142018 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. PriorExpendituresTotal 20142015201620172018Future Equipment 20,90020,900 18,60079,800 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 20,90020,900 18,600 Equipment Replacement Fund 79,800 TotalTotalTotal 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 Monday, July 29, 2013 77 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPublic Works: Bldg/Equip Ser Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0710 Project # Useful Life 10 years 4X4 1/2 Ton Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$96,700 Description Pickup used by various divisions of Public Works. Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. PriorExpendituresTotal 20142015201620172018Future Vehicles 31,30031,300 23,30042,100 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 31,30031,300 23,300 Equipment Replacement Fund 42,100 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move up from 2009 to 2008 - Fire Dept has requested to acquire surplus pickup for its use by daytime responders. Estimate salvage/resale value on replaced item: $1,500 Monday, July 29, 2013 78 EQUIPMENT REPLACEMENT PLAN 20142018 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. Cost ot paint the old Police Dept Chevy Tahoe Current vehicle: 2000 Chevrolet Suburban (#700) Justification Transportation to and from job site, hauling of surveying and traffic counting equipment. PriorExpenditures20142015201620172018TotalFuture Vehicles 2,0002,000 16,00028,900 TotalTotalTotal PriorFunding Sources20142015201620172018Total Future 2,0002,000 16,000 Equipment Replacement Fund 28,900 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 Monday, July 29, 2013 79 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Vehicles 32,20032,200 48,700 TotalTotal Funding Sources20142015201620172018TotalFuture 32,20032,200 Equipment Replacement Fund 48,700 TotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2013 to 2014. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 80 EQUIPMENT REPLACEMENT PLAN 20142018 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:$52,000 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 20142015201620172018 Equipment 52,00052,000 Total Funding Sources20142015201620172018Total 52,00052,000 Equipment Replacement Fund Total Budget Impact/Other Variance from 20 year plan. Estimate salvage/resale value on replaced item: $3,500 Move tractor up to 2014. Replace with toolcat with blower and broom attachment. Original tractor was to be replaced in 2014. (30 Years) Increase amount to reflect actual. Monday, July 29, 2013 81 EQUIPMENT REPLACEMENT PLAN 20142018 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:$92,240 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 20142015201620172018Future Equipment 11,00011,000 29,90051,340 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 11,00011,000 29,900 Equipment Replacement Fund 51,340 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move from 2013 to 2014. Estimate salvage/resale value on replaced item: (3) $1,400 each Reduce to $11,000 to purchase a electric style workman. Monday, July 29, 2013 82 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 11,00020,00031,000 49,00089,000 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 11,00020,00031,000 49,000 Equipment Replacement Fund 89,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2014 to 2015. Move back from 2015 to 2016. Estimate salvage/resale value on replaced item: $600 each Monday, July 29, 2013 83 EQUIPMENT REPLACEMENT PLAN 20142018 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 Expenditures20142015201620172018TotalFuture Equipment 32,70032,700 50,900 TotalTotal Funding Sources20142015201620172018TotalFuture 32,70032,700 Equipment Replacement Fund 50,900 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Monday, July 29, 2013 84 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0811 Project # Useful Life 15 years Turf Sweeper Project Name Category Equipment FuturePriorityn/a Total Project Cost:$57,600 Description Turf sweeper used by Parks Division of Public Works. Justification Spring and fall leaf pick up, debris pick up. PriorExpendituresTotal 20142015201620172018Future Equipment 18,00018,000 11,60028,000 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 18,00018,000 11,600 Equipment Replacement Fund 28,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move from 2001 to 2003 - current unit in good condition. Estimate salvage/resale value on replaced item: $1,500 Monday, July 29, 2013 85 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 21,20021,200 Total Funding Sources20142015201620172018Total Equipment Replacement Fund 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 Monday, July 29, 2013 86 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 32,00032,000 45,600 TotalTotal Funding Sources20142015201620172018TotalFuture 32,00032,000 Equipment Replacement Fund 45,600 TotalTotal Budget Impact/Other Variance from 20 year plan - new item in 2004. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 87 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPublic Works: Parks/Forestry Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0816 Project # Useful Life 8 years Toolcat Project Name Category Equipment FuturePriorityn/a Total Project Cost:$193,500 Description Use by Public Works for snow removal, skating rinks, sweeping, ballfield maintenance and transportation of people and materials. Current vehicle: 2010 Bobcat (#815) Justification New machine. PriorExpendituresTotal 20142015201620172018Future Equipment 63,30063,300 50,00080,200 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 63,30063,300 50,000 Equipment Replacement Fund 80,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - New item which replaces one tractor. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 88 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Vehicles 30,40030,400 24,00087,300 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 30,40030,400 24,000 Equipment Replacement Fund 87,300 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 Monday, July 29, 2013 89 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0302 Project # Useful Life 12 years 4x2 1 Ton Dump Truck Project Name Category Equipment FuturePriorityn/a Total Project Cost:$162,900 Description Truck used in the Street Division of Public Works. Current vehicle: 2006 Ford F350 Pickup (#307) Justification Plows alleys in winter, light hauling, snow removal and transportation. PriorExpendituresTotal 20142015201620172018Future Equipment 54,60054,600 30,50077,800 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 54,60054,600 30,500 Equipment Replacement Fund 77,800 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - change from 4x4 to 4x2 truck. Reduce cost to $30,500. Move up from 2008 to 2006. Extend useful life from 8 to 12 years. Estimate salvage/resale value on replaced item: $3,500 Monday, July 29, 2013 90 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0305 Project # Useful Life 17 years Single Axle Dump Truck (3) Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$674,100 Description Single axle dump truck used by various division of Public Works. Current vehicles: 2001 Ford L7501 (#313) & 2005 Freightliner M2 106 (#312) Justification Vehicle used for heavy hauling, snow plowing and sanding. Adding additional single axle truck in place of tandem truck from 01-ERP-306. PriorExpendituresTotal 20142015201620172018Future Vehicles 124,000124,000 207,400342,700 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 124,000124,000 207,400 Equipment Replacement Fund 342,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - Move 1 truck from tandem (was in 101-ERP-306) to single axle for 2012. Estimate salvage/resale value on replaced item: $4,500 each We would then have 3 single axel (chagne from 2) dump truck and 1 tandem axel dump truck. Monday, July 29, 2013 91 EQUIPMENT REPLACEMENT PLAN 20142018 thru DepartmentPublic Works: Streets/Traffic Cit of Hokins MN yp, Contact Public Works Director Type Equipment 01-ERP-0306 Project # Useful Life 17 years Tandem Dump Truck Project Name Category Vehicles FuturePriorityn/a Total Project Cost:$195,200 Description Dump truck used in Streets Division of Public Works. Current vehicles: 1996 Ford L-8000 (#315) & 1998 Ford LT8500 (#314) Justification Trucks used for heavy hauling, snow plowing and sanding. PriorExpendituresTotal 20142015201620172018 Vehicles 173,200173,200 22,000 TotalTotal PriorFunding Sources20142015201620172018Total 173,200173,200 22,000 Equipment Replacement Fund TotalTotal Budget Impact/Other Variance from 20 year plan - Change one (was two) tandem to single axle and move to 01-ERP-305. Decrease amount $15,000 for change in type of vehicle. Estimate salvage/resale value on replaced item: $-0- We are then down to 1 tandem dump truck and 3 single axel dump trucks Monday, July 29, 2013 92 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Vehicles 150,000150,000 45,000 TotalTotal PriorFunding Sources20142015201620172018Total 150,000150,000 45,000 Equipment Replacement Fund 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 Monday, July 29, 2013 93 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Equipment 41,90041,900 36,000109,700 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 41,90041,900 36,000 Equipment Replacement Fund 109,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - move back from 2010 to 2011. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 94 EQUIPMENT REPLACEMENT PLAN 20142018 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:$127,900 Description Used by Street Department for asphalt repair and resurfacing. Current equipment: 1989 Ingersoll Rand Roller (#330) Justification ExpendituresTotalFuture 20142015201620172018 Equipment 45,90045,900 82,000 TotalTotal Funding Sources20142015201620172018TotalFuture 45,90045,900 Equipment Replacement Fund 82,000 TotalTotal Budget Impact/Other Variance from 20 year plan - Move back from 2014 to 2016. Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 95 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 11,20011,200 16,000 TotalTotal Funding Sources20142015201620172018TotalFuture 11,20011,200 Equipment Replacement Fund 16,000 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 96 EQUIPMENT REPLACEMENT PLAN 20142018 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:$138,800 Description Asphalt paver used by Streets Division of Public Works. Current equipment: 1994 Caterpillar AD200B Paver (#337) Justification Paving streets and parking lots. ExpendituresTotalFuture 20142015201620172018 Equipment 48,80048,800 90,000 TotalTotal Funding Sources20142015201620172018TotalFuture 48,80048,800 Equipment Replacement Fund 90,000 TotalTotal Budget Impact/Other Variance from 20 year plan. Move back from 2014 to 2015 Estimate salvage/resale value on replaced item: $500 Monday, July 29, 2013 97 EQUIPMENT REPLACEMENT PLAN 20142018 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:$182,000 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. ExpendituresTotalFuture 20142015201620172018 Equipment 65,00065,000 117,000 TotalTotal Funding Sources20142015201620172018TotalFuture 65,00065,000 Equipment Replacement Fund 117,000 TotalTotal Budget Impact/Other Variance from 20 year plan. Move from 2016 to 2014. Reduce amount to purchase hydraulic powered blower. Estimate salvage/resale value on replaced item: $4,500 Monday, July 29, 2013 98 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 13,40013,400 18,100 TotalTotal Funding Sources20142015201620172018TotalFuture 13,40013,400 Equipment Replacement Fund 18,100 TotalTotal Budget Impact/Other Variance from 20 year plan - new Estimate salvage/resale value on replaced item: $-0- Monday, July 29, 2013 99 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Vehicles 204,800204,800 349,100908,700 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 204,800204,800 349,100 RF - Refuse Fund 908,700 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - increase cost to reflect actual Estimate salvage/resale value on replaced item: $18,000 Monday, July 29, 2013 100 EQUIPMENT REPLACEMENT PLAN 20142018 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,100 Description Refuse truck used by Refuse Utility Division of Public Works. Current vehicle: 1996 Freightliner FL70 (#903) Justification Residential waste pick up. ExpendituresTotalFuture 20142015201620172018 Vehicles 101,600101,600 136,500 TotalTotal Funding Sources20142015201620172018TotalFuture 101,600101,600 RF - Refuse Fund 136,500 TotalTotal Budget Impact/Other Variance from 20 year plan. Move back one year to evaluate needs. Estimate salvage/resale value on replaced item: $9,000 Monday, July 29, 2013 101 EQUIPMENT REPLACEMENT PLAN 20142018 thru Department Sewer Cit of HokinsMN yp, ContactPublic Works Director TypeEquipment 01-ERP-0550 Project # Useful Life 10 years 4x4 3/4 Ton Truck Project Name Category Vehicles FuturePriority n/a Total Project Cost: $96,900 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 20142015201620172018Future Vehicles 30,00030,000 26,60040,300 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 30,00030,000 26,600 SF - Sanitary Sewer Fund 40,300 TotalTotalTotal Budget Impact/Other Variance from 20 year plan. Reduce amount to $30,000 to reflect actual. Estimate salvage/resale value on replaced item: Thursday, August 01, 2013 102 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Vehicles 33,60033,600 51,00045,200 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 33,60033,600 51,000 SF - Sanitary Sewer Fund 45,200 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Monday, July 29, 2013 103 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Equipment 26,40026,400 23,000 TotalTotal Funding Sources20142015201620172018TotalFuture 26,40026,400 SF - Sanitary Sewer Fund 23,000 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Monday, July 29, 2013 104 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018Future Vehicles 26,80026,800 20,50036,000 TotalTotalTotal PriorFunding Sources20142015201620172018TotalFuture 26,80026,800 20,500 WF - Water Fund 36,000 TotalTotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Monday, July 29, 2013 105 EQUIPMENT REPLACEMENT PLAN 20142018 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 20142015201620172018 Vehicles 34,90034,900 46,900 TotalTotal Funding Sources20142015201620172018TotalFuture 34,90034,900 WF - Water Fund 46,900 TotalTotal Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Monday, July 29, 2013 106 107 108 109 110 111 112 113 114 115 116 CITY OF HOPKINS BUILDING INVENTORY January 2013 Location/DescriptionReplacement Cost City Hall & Police Station$7,584,428 1010 1st Street S. Fire Station4,411,843 101 17th Avenue S. Hopkins Activity Cente1,910,986 r 33 14th Avenue S. Ice Arena/Pavilion5,248,264 11000 Excelsior Boulevard Arts Center7,187,842 1111 Mainstreet PW Admin/Garage7,503,892 11100 Excelsior Boulevard Moline Reservoir/Well #12,407,797 10421 Excelsor Boulevard Blake Tower Reservoir1,449,795 151 Tyler Avenue S. Filtration Plant3,543,569 1401 Elmo Park Service Roa d Well #4 Workshop/Storage684,705 1401 Elmo Park Service Roa d Well #5241,217 1205 Highway7 Well #6321,548 801 Highway 7 Lift Station #2 - Drillane68,307 619 Drillane Road Lift Station #3 - Lindee's136,264 901 Cambridge Street N.E. Lift Station #4 - LTL Meadowbrook$99,933 244 Meadowbrook Roa d Lift Station #5 - Big Meadowbroo158,481 k 6601 Excelsior Blvd. 117 Location/DescriptionReplacement Cost Lift Station #6 - Ronnie's99,933 8546 Excelsior Avenue E. Lift Station #7 - Valley316,092 801 6th Avenue S. 37,638 Band Shell - Downtown Par k 16 9th Avenue S. Concession Stand - Maetzold Field156,059 1215 1st Street N. 168,378 Park Building-Beach - Lifeguard s 5200 Shady Oak Roa d Park Building-Beach-Concessions159,056 5200 Shady Oak Roa d Park Shelter - Office/Bathhouse386,235 5200 Shady Oak Roa d Park Shelter - Burnes51,440 201 Park Lane Park Building - Central116,705 101 17th Avenue S. Park Building - Harle39,520 y 108 Jackson Avenue S. 63,175 Park Shelter - Interlache n 220 Homedale Avenue Park Building - Oakes45,062 301 Tyler Avenue N. 53,035 Park Building - Valle y 800 7th Avenue S. Parking Ramp6,519,738 10th Avenue and Mainstreet Depot Coffee House$491,648 9451 Excelsior Boulevard Overpass Skate Par7,868 k 100 Washington Avenue Dow Towers (76 Units)HR A 22 5th Avenue S. 118 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2013 UNIT #YEAMAKEMODELVALUE R FIRE DEPARTMENT 1002006DODGEDURANGO$21,774 1012003CHEVIMPALA24,890 1021989FORD L9000TELE-SQUIRT380,000 1032006PETERBILT357 PUMPER420,000 1081995CHEV 4X4 LITE RESCUE36,000 1092008PIERCEAERO XT874,560 1102010CHEVROLETTAHOE30,000 1151952MACPUMPER4,000 K HAZMAT 1201995CHEVROLETSUBURBAN48,000 1212005FREIGHTLINERM2309,900 1222005PACEAMERICAN TRAILER40,100 POLICE DEPARTMENT 2002010FORDCROWN VICTORIA$29,815 2012008FORDCROWN VICTORIA22,693 2022011FORDCROWN VICTORIA22,375 2032009FORDCROWN VICTORIA28,160 2042007FORDCROWN VICTORIA23,000 205.2011FORDCROWN VICTORIA23,080 207.2010FORDCROWN VICTORIA29,815 209.2011FORDCROWN VICTORIA23,080 2112006JEEPLIBERTY17,580 2122008CHEVTAHOE26,148 2132010CHEVIMPALA23,624 2142007DODGECHARGER22,475 2152009CHEVIMPALA23,962 2162011FORDTAURUS23,500 2172008FORDTAURUS22,000 2192013FORDTAURUS23,866 2202005DODGERAM 150029,733 2401998CHEVP40 VAN12,000 241.2001CHRYSLERPT CRUISER17,855 119 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2013 UNIT #YEAMAKEMODELVALUE R STREET/TRAFFIC DIVISION 3022006FORDF250$21,015 3042000FORDF-45034,000 3051997FORD1/2 TON 17,300 3072006FORDF350-1 TON DUMP17,693 3082011FORDF350 - 2X420,182 3092012FORDF45072,000 3112011FREIGHTLINERM2-106V75,000 3122005FREIGHTLINERSGLAX DUMP45,346 3132001FORDL750172,000 3141998FORDLT 850084,000 3161995FORDWATER TR80,000 K 3201991CATERPILLERLOADER 928E138,300 3212012CATERPILLER924K LOADER172,000 3222005CATERPILLERLOADER 938G186,200 3242004BOBCATSKID LOADER32,000 3252011JOHN DEERESKID LOADER33,000 3261989CATERPILLAR140-G82,000 3272001ELGINPELICAN SE105,000 3301989INGERSOL/RANDROLLER DD-2523,000 3371994CATERPILLARBOX PAVER18,000 3421991TARGETCONCRETE SAW2,400 3441996SNOGOWK 80058,000 3491989TRAIL-KINGTK6V-12003,000 3501993TOWMASTERT144,000 3512004TENNANTSWEEPER 364010,000 ENGINEERING DIVISION 7002000CHEVSUBURBAN$14,500 7052005CHEVIMPALA14,600 BUILDING MAINTENANCE & EQUIPMENT SERVICES 7012006FORD500 SEDAN $20,800 7022004FORDF350 PICKUP17,570 7032002CHEV TAHOE18,000 7042006FORDF25024,000 120 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2013 UNIT #YEAMAKEMODELVALUE R PARKS/FORESTRY DIVISION 8002001FORDRANGER 4X4$18,000 8012012FORDF350$22,000 8022012FORDF-350$20,000 8032004FORDF35019,000 8041996CHEVROLET3/4 TON 4x423,000 8051998DODGERAM 350024,000 8101993INTERNATIONALLP 470050,000 8112006INTERNATIONALLP 4600 LOG TRUC45,000 K 8122010FREIGHTLINERAERIAL LIFT130,000 8152010BOBCATTOOLCAT50,000 8171982FORDTRACTOR 261022,000 8181996TOROTRUCKSTER13,000 8202004TOROWORKMAN 320015,000 8212004TOROWORKMAN 21107,900 8222001TORO325-D MOWER18,000 8532006JACOBSONMOWER 10,000 8241996TOROGROUND MASTER16,000 8252010TORO4100D MOWER53,000 8262004TOROZ587L8,900 8282001DEW EZEATM7221,000 8321997VERMEERSTUMP CTR 630A15,400 8332004BOBCATSKID LOADER22,000 8341993BRUSH BANDITCHIPPER 25014,000 836 RYANSOD CUTTER2,000 8442010FELLINGTRAILER4,000 8451997REMACKELTRAILER5,000 8462001DRESSEN81102,000 8472011SPARKS TRAILERT62024,900 HRA 4112007CHEV2500 HD$17,500 121 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2013 UNIT #YEAMAKEMODELVALUE R WATER/SEWER 500.2007CHEVPICKUP$22,000 501.2004CHEV4X4 3/4 T SILVERADO19,000 502.1999DODGEDAKOTA 4X418,000 505.2007CHEVCC2575324,000 506.2006CHEVSILVERADO20,700 530.2001STERLINGVAC-CON180,000 533.2012CATERPILLAR420EH2 BACKHOE85,000 534.1997KOHLERGENERATOR/TRL11,000 535.1992KOHLERGENERATOR/TRL10,000 536.1989FLEXIBLERODDING MACHINE25,000 537.2010GENERATORC15130,000 540.2008LEROIAIR COMPRESSOR12,000 542.1994WACKERTAMPER4,000 REFUSE 900.2011FREIGHTLINERRAPID-RAIL M2$201,000 901.2005PETERBILT320162,000 903.1995FREIGHTLINERFL-7054,000 PAVILION 801.1996CHEV4X4 TR$19,100 K 809.2003OLYMPIAICE RESURFACER85,000 122