Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2014-2018 Equipment Replacement Plan (ERP)
August 5, 2013 Council Report 2013-078 City of Hopkins 2014-2018 EQUIPMENT REPLACEMENT PLAN Proposed Action Staff recommends adoption of the following motion: Move to adopt the 2014-2018 Equipment Replacement Plan. Overview The equipment replacement plan is a detailed summary of the next five years of a twenty-year replacement schedule, for equipment of the City of Hopkins. General and Special Revenue fund equipment items are placed in the Equipment Replacement Fund budget which derives its revenues from service charges to the General and Special Revenue funds, equipment sales and interest earnings. The Enterprise fund equipment in the plan is placed in the individual enterprise fund budgets, in the year in which the equipment is to be purchased. Approval of the 2014-2018 allows staff to incorporate the 2014 ERP items into the 2014 budgets and begin preparation for their purchase. Items that fall under the Minnesota Statutes Uniform Bidding/Contracting Laws will require further approval by the council before their purchase. Staff is recommending adoption of the plan. Primary Issues to Consider • Should the annual service charges to the general and special revenue funds be adjusted? • What changes have occurred in the equipment replacement plan since last year? Supporting Information • 2014-2018 ERP Power Point slides • 2014-2018 Equipment Replacement Plan Christine M. Harkess, CPA, CGFM Finance Director Financial Impact: $ as provided in plan Budgeted: Y/N X N Source: Various Related Documents (CIP, ERP, etc.): ERP Notes: ERP Background • The city has established an equipment replacement Elan that is reviewed and adjusted on an annual asis. • Theurpose of the plan was to smooth out the fundpng of large pieces of equipment. In the past this allowed the City to avoid bonding for purchases thereby saving interest costs. • The purchase of the ladder truck in 2oo8 was the first time a piece of equipment needed to be financed. This truck will be paid off in 2o18. • Equipment certificates were sold in 2013 to fund equipment needs in 2013 and 2014. Funding Equipment Replacement The cost of equipment is allocated back to the user departments based on life expectancy and cost of the equipment. A 8% increase to the charge is planned for 2014. Impact of increase to the General Fund is $25,000 Increases in the charge are planned for future years. ERP Future Revenues in the Equipment Replacement fund are derived from charges to city departments that use the Cash flow projections are updated annually to ensure adequate funds for scheduled replacements. Funding challenges are foreseen in the future and alternative options have been explored. • Equipment Certificates for some 2013 & 2014 purchases • Equipment Certificates may be sold in 2017 2 Revenue, Capital Expenditures and Cash Variances (IN THOUSANDS) 1600 1400 i 1200 ! 1000 800 v Revenue o Capital Expend 600 W Cash 400 200 2011 2012 2013 2014 2015 2016 2017 2018 200 2014 ERP • For 2014 the city is planning on replacing or upgrading six vehicles and four pieces of equipment. • All vehicles and equipment are reviewed annually and useful lives adjusted while maintaining the integrity, reliability and safety of the vehicles, equipment and employees. • Purchases are made based upon the condition of the equipment, not simply on the ERP Schedule. 3 City Hall Equipment Election equipment is due for replacement Annually the city replaces a portion of its obsolete computers with newer technology. • This includes both computers and servers in all city departments • We will also be replacing the financial software in 2014 that is used by many departments , _ — Fire Equipment The fire department annually assess its fleet and adjusts the useful lives of the equipment accordingly. 2oo8 Aerial Ladder Lease Payment • 10 year lease at $54,217 annually Items scheduled for replacement • Automated External Defibrillator • Workout equipment AED 21 Police Equipment • Scheduled for replacement are • • DTF Vehicle • Two squad cars • PSO Utility Vehicle • Mobile Data Computers • Mobile Radios for cars purchased F', F�7 • Snow Blower • Van used by Engineering Dept. 140 �Y 5 3/4 Ton Utility Truck Trucksteer • Tractor ?? 7 4 X 4 3/4 "Ton Truck 44 a J _ i I Arts Center Theater projection screen Theater presentation microphones Conclusion • The Equipment Replacement Plan is a valuable tool used to assess, plan and fund future equipment needs of the City. • In the past by annually evaluating equipment and adjusting useful lives where practical, the city has been able to maintain the reserves in this fund to cover equipment. • Beginning in 2013 and again in 2017 this becomes a challenge. • Equipment certificates will need to be sold for future purchases. 7 City of Hopkins EQUIPMENT REPLACEMENT PLAN 2014-2018 '�;•i` .- • •� � -4coCity of Hopkins lolo fust Street South • Nopkms, ` ` 55343-7573 • Phone: 952-935-8474 • fax• 952.935-1834 'Web address: www.hopk-insmn.com DATE: August 2013 TO: Honorable Mayor and Members of the City Council FROM: Mike Mornson, City Manager SUBJECT: 2014-2018 EQUIPMENT REPLACEMENT PLAN 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. Partnering with the Community to Enhance the QuaCty of Life • Inspim • Educate • Involve • Communicate • EQUIPMENT REPLACEMENT PLAN 2014-2018 TABLE OF CONTENTS Paqe City Manager's Message 1 Table of Contents 2 Introduction Background and Summary of Changes from 2013 Plan 5 Cash Flow Statements Equipment Replacement Fund 13 Chart - Revenues. Expenditures & Working Capital 14 Five -Year Project Summaries Projects by Year 17 Department Summary 20 Projects by Department 21 Funding Source Summary 24 Projects by Funding Source 25 Equipment Requests Individual Equipment Request Details 31 Twenty Year Replacement Schedule Twenty Year Replacement Schedule by Department 109 Equipment and Building Inventory Building Inventory 117 Vehicle and Equipment Inventory 119 2 INTRODUCTION City of Hopkins 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 M 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. 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 tit 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. live 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/Trattic 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. s 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 3/ 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. -.4ca City of Hopkins 10 CASH FLOW STATEMENTS --qca City of Hopkins 12 EQUIPMENT REPLACEMENT FUND (602) 07/26/2013 Impact on General Fund 0 14,812 30,549 33,003 36,592 39,561 Rate Change 5% 0% 8% 9% 9% 9% 9% ACTUAL BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 2012 2013 2014 2015 2016 2017 2018 Working Capital Begin Year 890,189 1,084,440 1,069,566 674,200 573,558 215,593 865,741 Revenues from charges 316,784 316,784 342,127 372,918 406,481 443,064 482,940 Transfer in General Fund 50,000 50,000 50,000 Transfer In - Pavilion - Capital Lease 20,000 15,609 Transfer In - Pavilion - Hockey Loan 3,143 3,143 3,142 Federal & State Grants Interest earnings 5,910 10,984 10,835 6,881 5,875 2,295 8,797 Other revenues (sale of assets) 47,834 25,000 30,000 30,000 30,000 30,000 30,000 Equipment Certificates (Bonds) 346,274 451,769 1,272,000 Total Revenues 739,944 823,289 436,104 459,799 492,355 1,747,359 521,736 Expenditures (excludes Dept.) 15,802 16,276 16,764 17,267 17,785 18,319 18,868 Fire Truck Financing Pymnts (2009-2018) 53,858 54,217 54,217 54,217 54,217 54,217 54,217 Capital Outlay - Equipment 476,034 703,300 760,488 488,958 778,318 1,024,676 1,246,448 2012 Equip Certificate Pymnts (IOyr 3%) 64,370 Total Expenses 545,694 838,163 831,469 560,442 850,320 1,097,211 1,442,908 Working Capital Ending Balance 1,084,440 1,0699566 674,200 573,558 215,593 865,741 (55,431) Actual/Estimated Cash balances 1,098,353 1,083,479 688,114 587,471 229,507 879,654 (41,517) 13 00 ti 0 r -I O O L(1 O O •Q i.L M r-1 O V N .. ON L O O N N N i rn �A o0 i.f. N X W 00 o ^N' W y N Qi O W 1 O 2 O A N w� WU) o O N O O N FIVE-YEAR PROJECT SUMMARIES 15 -4ca City of Hopkins 16 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 PROJECTS BY YEAR Project Name Department Project # Priorit-v Project Cost 2014 Art Center Theater Projection Screen Arts Center O1 -ERP -1107 2 5,000 Art Center Theater Presentation Microphones Arts Center 01 -ERP -1108 1 6,000 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Financial Software - Various Depts City Hall Administration 01 -ERP -0005 n/a 250,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 Election Equipment Community Services 0l -ERP -0011 n/a 50,000 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Automated External Defibrillator (2) Fire 01 -ERP -0120 n/a 7,200 HRA Copier HRA 01 -ERP -0401 n/a 13,000 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 90,000 PSO - Utility 44 (unit 212) Police 01 -ERP -0203 n/a 47,700 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 4,694 Police Admin Cars - outfit leased vehicles Police 01 -ERP -0204a n/a 5,000 Drug Task Force Vehicle Police 01 -ERP -0206 n/a 4,694 Drug Task Force Vehicle - outfit leased vehicle Police 01 -ERP -0206a n/a 5,000 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Mobile Data Computers Police 01 -ERP -0212 n/a 62,700 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 20,500 Engineering Van Public Works: Engineering 01 -ERP -0700 n/a 2,000 3/4 Ton Utility Truck Public Works: Parks/Forestry 01 -ERP -0802 n/a 32,200 Tractor Public Works: Parks/Forestry 01 -ERP -0806 n/a 52,000 Trucksters (3) Public Works: Parks/Forestry 01 -ERP -0807 n/a 11,000 Snow Blower Public Works: Streets/Traffic 01 -ERP -0315 n/a 65,000 44 3/4 Ton Truck Sewer 01 -ERP -0550 n/a 30,000 Total for 2014 864,405 2015 Art Center Community Room Audio Visual Arts Center 01 -ERP -1105 n/a 11,000 Arts Center - Digital Information Sign Arts Center 01 -ERP -1106 2 2,000 Network Server City Hall Administration Of -ERP -0003 n/a 8,000 Telephone System City Hall Administration 01 -ERP -0004 n/a 89,600 Computers City Hall Administration O1 -ERP -0006 n/a 30,000 Fire Utility Vehicle (Pick Up Truck) Fire Of -ERP -0105a n/a 40,000 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Floor Scrubber Fire 01 -ERP -0114 n/a 14,300 Workout Equipment - Eliptical Fire 01 -ERP -0116 n/a 5,800 Workout Equipment - Treadmill #1 Fire Of -ERP -0117 n/a 5,800 Workout Equipment - Weight Lifting Fire O1 -ERP -0119 n/a 5,800 44 3/4 Ton Truck HRA 01 -ERP -0400 n/a 32,400 Marked Patrol Vehicles (6) Police O1 -ERP -0200 n/a 90,000 Sergeant's Vehicle Police O1 -ERP -0201 n/a 45,000 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 9,529 Police Admin Cars - outfit leased vehicles Police O1 -ERP -0204a n/a 5,000 Drug Task Force Vehicle Police O1 -ERP -0206 n/a 4,694 Thursday, August 01, 2013 17 Project Name Department Project # Priorih Project Cost Focus Car Police 01 -ERP -0210 n/a 4.835 Focus Car - outfit leased vehicle Police 0l -ERP -0210a n/a 5,000 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Digital Squad Car Cameras Police 0l -ERP -0213 n/a 53,400 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 20,500 Riding Mowers (2) Public Works: Parks/Forestry 0l -ERP -0808 n/a 11,000 4X4 3/4 Ton Truck with Plow Public Works Streets/Traffic 0l -ERP -0301 n/a 30,400 Sign Machine (Traffic) Public Works: Streets/Traffic 01 -ERP -0317 n/a 13,400 Refuse Truck (RAP -R) (2) Refuse 0l -ERP -0900 n/a 204,800 Refuse Truck (Rear -L) Refuse 01 -ERP -0901 n/a 101,600 Ibtal for 2016 866,135 2017 Art Center Video Camera Updates Total for 2015 O1 -ERP -1103 n/a 906,575 2016 City Hall Administration 01 -ERP -0003 n/a 8,000 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 Duty Chief Vehicle Fire 01 -ERP -0103 n/a 37,000 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Air Compressor Fire 01 -ERP -0107 n/a 34,900 Self Contained Breathing Apparatus (45) Fire 01 -ERP -0108 n/a 250,000 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 90,000 Parking Enforcement Vehicle (Parking Fund) Police 01 -ERP -0202 n/a 27,200 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 14,509 Police Admin Cars - outfit leased vehicles Police 01 -ERP -0204a n/a 5,000 SWAT Vehicle Police 01 -ERP -0205 n/a 30,000 Drug Task Force Vehicle Police 01 -ERP -0206 n/a 9.674 Drug Task Force Vehicle - outfit leased vehicle Police 01 -ERP -0206a n/a 5.000 Copy Machine - Police Dept Police 01 -ERP -0209 n/a 22.100 Focus Car Police 01 -ERP -0210 n/a 4,835 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 12,300 Riding Mowers (2) Public Works: Parks/Forestry 01 -ERP -0808 n/a 20,000 Slope Mower Public Works: Parks/Forestry 01 -ERP -0809 n/a 32,700 Skid Loader (2) Public Works, Streets/Traffic 01 -ERP -0309 n/a 41,900 Roller Public Works: Streets/Traffic 01 -ERP -0312 n/a 45,900 Asphalt Paver Public Works: Streets/Traffic 01 -ERP -0314 n/a 48,800 3/4 Ton Ublity Truck Sewer 01 -ERP -0551 n/a 33,600 Ibtal for 2016 866,135 2017 Art Center Video Camera Updates Arts Center O1 -ERP -1103 n/a 3,700 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration O1 -ERP -0006 n/a 30,000 Document Management Scanner (2) Community Services O1 -ERP -0008 n/a 6,000 Tele -Squirt (Engine 2) Fire 0I -ERP -0100 n/a 570,900 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Thermal Imaging Camera (2) Fire 01 -ERP -0112 n/a 12,900 Workout Equipment - Treadmill #2 Fire Of -ERP -0118 n/a 5,800 Workout Equipment - Dumb Bells Fire 01 -ERP -0122 n/a 5,000 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 98,000 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 19,638 Police Admin Cars - outfit leased vehicles Police 01 -ERP -0204a n/a 5,000 Drug Task Force Vehicle Police 01 -ERP -0206 n/a 9,674 Focus Car Police 01 -ERP -0210 n/a 9,964 Focus Car- outfit leased vehicle Police 01 -ERP -0210a n/a 5,000 Network Server (3) Police 01 -ERP -0211 n/a 8,500 I'll ursdgr, August III. '013 18 Project Name Department Project # Priority Project Cost Taser Replacement Police O1 -ERP -0217 3 20,900 Stump Cutter Public Works: Parks/Forestry 01 -ERP -0812 n/a 21,200 Skid Loader Public Works: Parks/Forestry 01 -ERP -0815 n/a 32,000 Water Truck Public Works: Streets/Traffic 01 -ERP -0307 n/a 150,000 Striper Public Works: Streets/Traffic 01 -ERP -0313 n/a 11,200 Generator (2) Sewer O1 -ERP -0555 n/a 26,400 1/2 Ton Truck Water 01 -ERP -0500 n/a 26,800 3/4 Ton Utility Truck Water 01 -ERP -0501 n/a 34,900 2018 Art Center Theater Projector Network Server Computers Core Network Switch Document Management Scanner (2) Aerial Truck Automated External Defibrillator (2) Marked Patrol Vehicles (6) Police Administrative Vehicles (2) Police Admin Cars - outfit leased vehicles Drug Task Force Vehicle Drug Task Force Vehicle - outfit leased vehicle Focus Car Network Server (3) Tactical Ballistic Vests Radios - Portable and Mobile Devices 4X41/2 Ton Truck Turf Sweeper Toolcat 4x21 Ton Dump Truck Single Axle Dump Truck (3) Tandem Dump Truck GRAND TOTAL Total for 2017 1,175,693 Arts Center Of -ERP -1104 n/a 17,100 City Hall Administration 01 -ERP -0003 n/a 8,000 City Hall Administration 01 -ERP -0006 n/a 30,000 City Hall Administration 01 -ERP -0012 n/a 12,000 Community Services Of -ERP -0008 n/a 6,000 Fire 0f -ERP -0106 n/a 54,217 Fire Of -ERP -0120 n/a 7,800 Police 01 -ERP -0200 n/a 98,000 Police 01 -ERP -0204 n/a 20,224 Police 01 -ERP -0204a n/a 5,000 Police 01 -ERP -0206 n/a 10,260 Police 01 -ERP -0206a n/a 5,000 Police 01 -ERP -0210 n/a 9,964 Police 01 -ERP -0211 n/a 8,500 Police 01 -ERP -0214 n/a 26,900 Police 01 -ERP -0215 n/a 534,400 Public Works: Bldg/Equip Sery 01 -ERP -0710 n/a 31,300 Public Works: Parks/Forestry O1 -ERP -0811 n/a 18,000 Public Works: Parks/Forestry 01 -ERP -0816 n/a 63,300 Public Works: Streets/Traffic 01 -ERP -0302 n/a 54,600 Public Works: Streets/Traffic 01 -ERP -0305 n/a 124,000 Public Works: Streets/Traffic 01 -ERP -0306 n/a 173,200 Total for 2018 1,317,765 5,130,573 19 Thursday, August 01, 2013 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 DEPARTMENT SUMMARY Department 2014 2015 2016 2017 2018 Total Arts Center 11,000 13,000 3,700 17,100 44,800 City Hall Administration 288,000 127,600 38,000 38,000 50,000 541,600 Community Services 50,000 6,000 6,000 62,000 Fire 61,417 125.917 376,117 648,817 62,017 1,274,285 HRA 13,000 32,400 45,400 Police 248.788 246,458 229,118 176,676 718,248 1,619,288 Public Works: Bldg/Equip Sery 31,300 31,300 Public Works: Engineering 2.000 2,000 Public Works: Parks/Forestry 95,200 11,000 52,700 53,200 81,300 293,400 Public Works: Streets[TrafBc 65,000 43,800 136,600 161,200 351,800 758,400 Refuse 306,400 306,400 Sewer 30.000 33,600 26,400 90,000 Water 61,700 61,700 TOTA1, 864,405 906,575 866,135 1,175,693 1,317,765 5,130,573 20 Am alar..lu; City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 PROJECTS BY DEPARTMENT Department Project# Priority 2014 2015 2016 2017 2018 Total Arts Center i Art Center Video Camera Updates 01 -ERP -1103 n/a 3,700 3,700 Art Center Theater Projector 01 -ERP -1104 n/a 17,100 17,100 Art Center Community Room Audio Visual 01 -ERP -1105 n/a 11,000 11,000 Arts Center - Digital Information Sign 01 -ERP -1106 2 2,000 2,000 Art Center Theater Projection Screen 01 -ERP -1107 2 5,000 5,000 Art Center Theater Presentation Microphones O1 -ERP -1108 1 6,000 6,000 Arts Center Total 11,000 13,000 3,700 17,100 44,800 City Hall Administration Network Server 01 -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 0l -ERP -0004 n/a 89,600 89,600 Financial Software - Various Depts 01 -ERP -0005 n/a 250,000 250,000 Computers 01 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 Core Network Switch 01 -ERP -0012 n/a 12,000 12,000 City Hall Administration Total 288.000 127,600 38,000 38,000 50,000 541,600 Community services i Document Management Scanner (2) 01 -ERP -0008 n/a 6,000 6,000 12,000 Election Equipment 01 -ERP -0011 n/a 50,000 50,000 Community Services Total 50,000 6,000 6,000 62,0010 Fire Tele -Squirt (Engine 2) 01 -ERP -0100 n/a 570,900 570,900 Duty Chief Vehicle 01 -ERP -0103 n/a 37,000 37,000 Fire Utility Vehicle (Pick Up Truck) 01 -ERP -0105a n/a 40,000 40,000 Aerial Truck 01 -ERP -0106 n/a 54,217 54,217 54,217 54,217 54,217 271,085 Air Compressor Of -ERP -0107 n/a 34,900 34,900 Self Contained Breathing Apparatus (45) 01 -ERP -0108 n/a 250,000 250,000 Thermal Imaging Camera (2) 01 -ERP -0112 n/a 12,900 12,900 Floor Scrubber 01 -ERP -0114 n/a 14,300 14,300 Workout Equipment - Eliptical 01 -ERP -0116 n/a 5,800 5,800 Workout Equipment - Treadmill #1 01 -ERP -0117 n/a 5,800 5,800 Workout Equipment - Treadmill #2 01 -ERP -0118 n/a 5,800 5,800 Workout Equipment - Weight Lifting 01 -ERP -0119 n/a 5,800 5,800 Automated External Defibrillator (2) 01 -ERP -0120 n/a 7,200 7,800 15,000 Workout Equipment - Dumb Bells 01 -ERP -0122 n/a 5,000 5,000 Fire Total 61,417 125,917 376,117 648,817 62,017 1,274,285 �H RA 44 3/4 Ton Truck 01 -ERP -0400 n/a 32,400 32,400 HRA Copier 01 -ERP -0401 n/a 13,000 13,000 21 7hursdai. August 0/. 2013 Department Project# Priorit-,, 2014 2015 2016 2017 2018 Total HRA Total 13,000 32,400 45,400 Police 01 -ERP -0710 Public Works: Bldg/Equip Sery Total 52,000 Public Works: Engineering 11,000 Engineering Van O1 -ERP -0700 Public Works: Engineering Total Marked Patrol Vehicles (6) O1 -ERP -0200 n/a 90.000 90,000 90,000 98,000 98,000 466,000 Sergeants Vehicle 01 -ERP -0201 n/a 01 -ERP -0809 45,000 01 -ERP -0811 Stump Cutter 01 -ERP -0812 45,000 Parking Enforcement Vehicle (Parking Fund) 01 -ERP -0202 n/a Public Works: Parks/Forestry Total 27,200 4X4 3/4 Ton Truck with Plow 27,200 PSO - Utility 44 (unit 212) 01 -ERP -0203 n/a 47,700 Tandem Dump Truck 01 -ERP -0306 Water Truck 01 -ERP -0307 47,700 Police Administrative Vehicles (2) 01 -ERP -0204 n/a 4,694 9,529 14,509 19,638 20,224 68,594 Police Admin Cars- outfit leased vehicles 01 -ERP -0204a n/a 5,000 5,000 5,000 5,000 5,000 25,000 SWAT Vehicle 01 -ERP -0205 n/a 30,000 30,000 Drug Task Force Vehicle 01 -ERP -0206 n/a 4,694 4,694 9,674 9,674 10,260 38,996 Drug Task Force Vehicle - outfit leased vehicle 01 -ERP -0206a n/a 5,000 5,000 5,000 15,000 Copy Machine - Police Dept 01 -ERP -0209 n/a 22,100 22,100 Focus Car 01 -ERP -0210 n/a 4,835 4,835 9,964 9,964 29,598 Focus Car- outfit leased vehicle 01 -ERP -0210a n/a 5,000 5,000 10,000 Network Server (3) 01 -ERP -0211 n/a 8.500 8,500 8,500 8,500 8,500 42,500 Mobile Data Computers 01 -ERP -0212 n/a 62.700 62,700 Digital Squad Car Cameras 01 -ERP -0213 n/a 53,400 53,400 Tactical Ballistic Vests O1 -ERP -0214 n/a 26,900 26,900 Radios - Portable and Mobile Devices 01 -ERP -0215 n/a 20.500 20,500 12.300 534,400 587,700 Taser Replacement O1 -ERP -0217 3 20,900 20,900 Police Total Public Works: Blde/Eauiu Ser-, 4X41/2 Ton Truck 01 -ERP -0710 Public Works: Bldg/Equip Sery Total 52,000 Public Works: Engineering 11,000 Engineering Van O1 -ERP -0700 Public Works: Engineering Total 32,700 Public Works: Parks/Forestry 18,000 3/4 Ton Utility Truck 01 -ERP -0802 Tractor 01 -ERP -0806 Trucksters (3) 01 -ERP -0807 Riding Mowers (2) 01 -ERP -0808 Slope Mower 01 -ERP -0809 Turf Sweeper 01 -ERP -0811 Stump Cutter 01 -ERP -0812 Skid Loader 01 -ERP -0815 Toolcat Of -ERP -0816 Public Works: Parks/Forestry Total Public Works: Streets/Traffic 4X4 3/4 Ton Truck with Plow OI -ERP -0301 4x21 Ton Dump Truck 01 -ERP -0302 Single Axle Dump Truck (3) 01 -ERP -0305 Tandem Dump Truck 01 -ERP -0306 Water Truck 01 -ERP -0307 Skid Loader (2) 01 -ERP -0309 Roller 01 -ERP -0312 Striper 01 -ERP -0313 248,788 246,458 229,118 176,676 718,248 1,619,288 n a 31 300 31.300 31,300 31,300 n a 2.000 2,000 2,000 2,000 n/a 32,200 32,200 n/a 52,000 52,000 n/a 11,000 11,000 n/a 11,000 20,000 31,000 n/a 32,700 32,700 n/a 18,000 18,000 n/a 21,200 21,200 n/a 32,000 32,000 n/a 63,300 63,300 95,200 11,000 52,700 53,200 81,300 293,400 n/a 30,400 30,400 n/a 54,600 54,600 n/a 124,000 124,000 n/a 173,200 173,200 n/a 150,000 150,000 n/a 41,900 41,900 n/a 45,900 45,900 n/a 11,200 11,200 22 7hmwsdur. lugusr 0/, 3111 Department Project# Priority 2014 2015 2016 2017 2018 Total Asphalt Paver 01-ERP-0314 n/a 48,800 48,800 Snow Blower 01-ERP-0315 n/a 65,000 65,000 Sign Machine (Traffic) 01-ERP-0317 n/a 13,400 13,400 Public Works: Streets/Traffic Total 65,000 43,800 136,600 161,200 351,800 758,400 Refuse Refuse Truck (RAP-R) (2) 01-ERP-0900 n/a 204,800 204,800 Refuse Truck (Rear-L) O1-ERP-0901 n/a 101,600 101,600 Refuse Total 306,400 306,400 Sewer 44 3/4 Ton Truck O1-ERP-0550 n/a 30,000 30,000 3/4 Ton Utility Truck O1-ERP-0551 n/a 33,600 33,600 Generator (2) O1-ERP-0555 n/a 26,400 26,400 Sewer Total 30,000 33,600 26,400 90,000 Water 1/2 Ton Truck O1-ERP-0500 n/a 26,800 26,800 3/4 Ton Utility Truck O1-ERP-0501 n/a 34,900 34,900 Water Total 61,700 61,700 GRAND TOTAL 864,405 906,575 866,135 1,175,693 1,317,765 5,130,573 23 Thursday, August 01, 2013 City of Hopkins, MN EQUIPMENT REPLACEMF_NT PLAN 2014 thru 2018 FUNDING SOURCE: SUMMARY Source 2014 2015 2016 AC - Arts Center Fund Bonds/Lease Equipment Replacement Fund HRA - Housing and Redevelopment Authority PKG - Parking Fund RF - Refuse Fund SF - Sanitary Sewer Fund WF - Water Fund GRA N D '1'0'1'A I 2017 2018 Total 6,000 11,000 3,700 17,100 37,800 54,217 54,217 54,217 54,217 54,217 271,085 755,488 488,958 778,318 1,029,676 1,246,448 4,298,888 13,000 32,400 45,400 5,700 5,700 306.400 306,400 30.000 6.800 33,600 26,400 96,800 6.800 61,700 68,500 864,405 906,575 866,135 1,175,693 1,317,765 5,130,573 24 77nnnlui. 1u,ucrlll 'l�l� City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 PROJECTS BY FUNDING SOURCE Source Project# Priority 2014 2015 2016 2017 2018 Total IAC - Arts Center Fund Art Center Video Camera Updates O1 -ERP -1103 n/a 3,700 3,700 Art Center Theater Projector O1 -ERP -1104 n/a 17,100 17,100 Art Center Community Room Audio Visual 01 -ERP -1105 n/a 11,000 11,000 Art Center Theater Presentation Microphones O1 -ERP -1108 1 6,000 6,000 AC - Arts Center Fund Total 6,000 11,000 3,700 17,100 37,800 (Bonds/Lease Aerial Truck 01 -ERP -0106 n/a 54,217 54,217 54,217 54,217 54,217 171,085 Bonds/Lease Total 54,217 54,217 54,217 54,217 54,217 271,085 Equipment Replacement Fund Network Server Of -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01 -ERP -0004 n/a 76,000 76,000 Financial Software - VariousDepts 01 -ERP -0005 n/a 250,000 250,000 Computers 0l -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 Document Management Scanner (2) 01 -ERP -0008 n/a 6,000 6,000 12,000 Election Equipment 0l -ERP -0011 n/a 50,000 50,000 Core Network Switch 01 -ERP -0012 n/a 12,000 12,000 Tele -Squirt (Engine 2) 01 -ERP -0100 n/a 570,900 570,900 Duty Chief Vehicle O1 -ERP -0103 n/a 37,000 37,000 Fire Utility Vehicle (Pick Up Truck) 01 -ERP -0105a n/a 40,000 40,000 Air Compressor O1 -ERP -0107 n/a 34,900 34,900 Self Contained Breathing Apparatus (45) O1 -ERP -0108 n/a 250,000 250,000 Thermal Imaging Camera (2) O1 -ERP -0112 n/a 12,900 12,900 Floor Scrubber 01 -ERP -0114 n/a 14,300 14,300 Workout Equipment - Eliptical O1 -ERP -0116 n/a 5,800 5,800 Workout Equipment - Treadmill #1 O1 -ERP -0117 n/a 5,800 5,800 Workout Equipment - Treadmill #2 O1 -ERP -0118 n/a 5,800 5,800 Workout Equipment - Weight Lifting O1 -ERP -0119 n/a 5,800 5,800 Automated External Defibrillator (2) O1 -ERP -0120 n/a 7,200 7,800 15,000 Workout Equipment - Dumb Bells 01 -ERP -0122 n/a 5,000 5,000 Marked Patrol Vehicles (6) O1 -ERP -0200 n/a 90,000 90,000 90,000 98,000 98,000 466,000 Sergeant's Vehicle O1 -ERP -0201 n/a 45,000 45,000 Parking Enforcement Vehicle (Parking Fund) O1 -ERP -0202 n/a 27,200 27,200 PSO - Utility 44 (unit 212) 01 -ERP -0203 n/a 47,700 47,700 Police Administrative Vehicles (2) O1 -ERP -0204 n/a 4,694 9,529 14,509 19,638 20,224 68,594 Police Admin Cars - outfit leased vehicles 01 -ERP -0204a n/a 5,000 5,000 5,000 5,000 5,000 25,000 SWAT Vehicle O1 -ERP -0205 n/a 30,000 30,000 Drug Task Force Vehicle O1 -ERP -0206 n/a 4,694 4,694 9,674 9,674 10,260 38,996 Drug Task Force Vehicle - outfit leased vehicle 01 -ERP -0206a n/a 5,000 5,000 5,000 15,000 Copy Machine - Police Dept O1 -ERP -0209 n/a 22,100 22,100 7hursdar, August W, 2013 25 Source Project# 1'rioritN 2014 2015 2016 2017 2018 Total Focus Car 01 -ERP -0210 n/a 4,835 4,835 9,964 9,964 29,598 Focus Car - outfit leased vehicle 01 -ERP -0210a n/a 5,000 5,000 10,000 Network Server (3) 01 -ERP -0211 n/a 8,500 8.500 8,500 8,500 8,500 42,500 Mobile Data Computers 0l -ERP -0212 n/a 57,000 57,000 Digital Squad Car Cameras 01 -ERP -0213 n/a 53,400 53,400 Tactical Ballistic Vests 01 -ERP -0214 n/a 26,900 26,900 Radios - Portable and Mobile Devices 01 -ERP -0215 n/a 20,500 20,500 12,300 534,400 587,700 Taser Replacement 01 -ERP -0217 3 20.900 10,900 4X4 3/4 Ton Truck with Plow 01 -ERP -0301 n/a 30,400 30,400 4x21 Ton Dump Truck 01 -ERP -0302 n/a 54,600 54,600 Single Axle Dump Truck (3) 01 -ERP -0305 n/a 124,000 124,000 Tandem Dump Truck 01 -ERP -0306 n/a 173,200 173,200 Water Truck 01 -ERP -0307 n/a 150,000 150,000 Skid Loader (2) 01 -ERP -0309 n/a 41,900 41,900 Roller 01 -ERP -0312 n/a 45,900 45,900 Striper 01 -ERP -0313 n/a 11,200 11,200 Asphalt Paver 01 -ERP -0314 n/a 48,800 48,800 Snow Blower 01 -ERP -0315 n/a 65.000 65,000 Sign Machine (Traffic) 0l -ERP -0317 n/a 13.400 13,400 Engineering Van O1 -ERP -0700 n/a 2.000 2,000 4X41/2 Ton Truck 01 -ERP -0710 n/a 31,300 31,300 3/4 Ton Utility Truck 0l -ERP -0802 n/a 32,200 32,200 Tractor 01 -ERP -0806 n/a 52.000 52,000 Trucksters (3) O1 -ERP -0807 n/a 11,000 11,000 Riding Mowers (2) 01 -ERP -0808 n/a 11,000 20,000 31,000 Slope Mower 01 -ERP -0809 n/a 32.700 32,700 Turf Sweeper 01 -ERP -0811 n/a 18,000 18,000 Stump Cutter 01 -ERP -0812 n/a 21,200 21,200 Skid Loader 01 -ERP -0815 n/a 32,000 32,000 Toolcat 0l -ERP -0816 n/a 63,300 63,300 Arts Center - Digital Information Sign 01 -ERP -1106 2 2.000 2,000 Art Center Theater Projection Screen 01 -ERP -1107 2 5.000 5,000 Equipment Replacement Fund Total 755,488 488,958 778,318 1,029,676 1,246,448 4,298,888 HRA - Housing and Redevelopment .k 44 3/4 Ton Truck 0l -ERP -0400 n/a 32,400 32,400 HRA Copier 0l -ERP -0401 n/a 13,000 13,000 HRA - Housing and Redevelopment 13,000 32,400 0400 Authority Total PKG - Parking Fund Mobile Data Computers 01 -ERP -0212 n/a 5,700 5,700 PKG - Parking Fund Total 5,700 5,700 FRF - Refuse Fund Refuse Truck (RAP -R) (2) 01 -ERP -0900 n/a 204,800 204 800 Refuse Truck (Rear -L) 0l -ERP -0901 n/a 101,600 101,600 RF - Refuse Fund Total 306,400 306,400 SF - Sanitary Sewer Fund 26 Thuredgr„ August 01, 2u1 3 Source Project# Priorit. 2014 2015 2016 2017 2018 Total Telephone System 0l -ERP -0004 n/a 6,800 6,800 44 3/4 Ton Truck O1 -ERP -0550 n/a 30,000 30,000 3/4 Ton Utility Truck 0I -ERP -0551 n/a 33,600 33,600 Generator (2) O1 -ERP -0555 n/a 26,400 26,400 SF - Sanitary Sewer Fund Total 30,000 6,800 33,600 26,400 96,800 I `�'F - Water Fund Telephone System O1 -ERP -0004 n/a 6,800 6,800 1/2 Ton Truck 01 -ERP -0500 n/a 26,800 26,800 3/4 Ton Utility Truck 01 -ERP -0501 n/a 34,900 34,900 WF - Water Fund Total 6,800 61,700 68,500 GRAND TOTAL 864,405 906,575 866,135 1,175,693 1,317,765 5,130,573 Thursday, August 01, 2013 27 13200- City of Hopkins 28 EQUIPMENT REQUESTS 29 -4ca City of Hopkins 30 EQUIPMENT REPLACEMENT PLAN 2014 lhru 2018 Department Arts Center City of Hopkins, MN Contact Arts Center Director Project tt 01 -ERP -1103 Type Equipment Useful Life 5 years Project Name Art Center Video Camera Updates P Category Equipment Future Priority n/a Description71 Total Project Cost: $22,000 2eplace the front entry camera with a better resolution camera. Relocate existing to above the display cabinet in the lobby. Add additional camera o 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 fhere 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 ,amera in the back hallway may reduce tendency of youth to hang out in that area and engage in inappropriate behavior. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 3,200 Equipment 3,700 3,700 15,100 Total Total 3,700 3,700 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 3,200 AC - Arts Center Fund 3,700 3,700 15,100 Total Total 3,700 3,700 Total Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $-0- 31 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 lhrn 2018 City of Hopkins, MN Project # 01 -ERP -1104 Project Name Art Center Theater Projector Future Dep:u•Imenl Arts ('enter Contact arts Center Director 1) pe Equipment t seful Lire 5 years Cawgor. Equipment Priork.% ma Description I Total Project (Cost: $75,11110 Current projector is 3000 lumen -- 6500 lumen is required torr theater wase including in partial light situations and to achieve the clarity needed for detailed images. Such a projector costs about 57.200 (including mounting and rigging hard X\ are. cables and installation labor). 'l -he projector also needs to be part of a professional system that permits it to be operated from the theater tech booth or from on-a;i,_c -- the current projector is only operable from a hand-held remote requiring the operator to dash into the audience of the theater. This total cast oftid 5.200 includes all the wiring and hardware needed to support a pn�jcctor \\ ell into the future. The proJector itself is estimated to have a 5 -year useful life. (The existing Droiector will be moved to one of the mectim_ rooms). Justification Fhe justification of this expense is ileo -told: First. in order to attract and retain arts and corporate renters tvc need to be able to provide the echnical support required for their events. Income from such rentals (including- Pen Pak and Digital Rivers) is becoming increasingly vital to the financial health of the Center. If tcc are not capable of competing X+ ith similar siic x enues. ice kill lose this income. Secondly, as a professional ills presenter we need to have the technical capatabilitics to run our o\\ it programs in a professional manner. ear 2018: $17,100 ear 2023 $19,800 ear 2028 $22,900 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 15,200 Equipment 17,100 17,100 42,700 Total Total 17,100 17,100 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 15,200 AC - Arts Center Fund 17,100 17,100 42,700 Total Total 17,100 17,100 Total Budget Impact/Other Investing $15, 000 to retain major renters such as Pen Pak and Digital Rivers is tcorthtchile. Pen Pals alone brings in about �120.0um \ car in ncome. Digital Rivers just under 59.000. Wond(i. Joy ") -lol («1A EQUIPMENT REPLACEMENT PLAN 2014 lhru 2018 City of Hopkins, MN Project # 01 -ERP -1105 Project Name Art Center Community Room Audio Visual Future Department Arts Center Contact Arts Center Director Type Equipment Useful Life 7 years Category Equipment Priority n/a Description Total Project Cost: $41,100 nstall 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 kn increasing number of users of this room require media support. Current means of providing this include the use of an oversized AN 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. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 11,000 11,000 30,100 Total 11,000 1100 Total Funding Sources 2014 2015 2016 2017 2018 Total Future AC - Arts Center Fund 11,000 11,000 30,100 Total 11,000 11,000 Total Budget Impact/Other Move this item from 2014 to 2015. 33 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -1106 Project Name Arts Center - Digital Information Sign Future Add programmable and highly visable digital sign to information desk area. (Viewsonic 42" with integrated media. sottwarc - or similar) 2014 din, 2018 Department Arts Center Contact Arts Center Co -Director I.xpe Equipment t seful Life t years Category Equipment Priori(% 2 Very Important I otal Project Covt: $10,100 system of posting printed schedules and key information each day is overlooked by visitors and difficult to update rapidly. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 2.000 2,000 8,100 Total 2,000 2,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 2,000 2,000 8,100 Total 2,000 2,000 'Dotal Budget Impact/Other Variance from 20 year plan - New Item Estimated salvage/resale value $0 34 .Aloidlur. July 9. 2013 EQUIPMENT REPLACEMENT PLAN 20141/1,-1,2018 Department Arts Center City of Hopkins, NW Contact Arts Center Director Project # 01 -ERP -1107 Type Equipment Useful Life 10 years Project Name Art Center Theater Projection Screen J Category Equipment Future Priority 2 Very Important Description Total Project Cost: $11,700 Replace original retractable projection screen in the theater with wider format screen to mesh with current technology. Justification Chis is an item being requested more frequently from renters as they find the dimensions of the current screen do not match up with the vesentations they bring in. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 5,000 5,000 F 6,700 Total 5,000 5,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 5,000 5,000 6,700 Total 5,000 5,000 Total Budget ImpaWOther Variance from 20 -year plan: New item 35 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 th tt 2018 City of Hopkins, MN Project # 01 -ERP -1108 Project Name Art Center Theater Presentation Microphones Future Department earls Center Contact I N pe Equipment I seful Life 6 years Category Equipment Priority I Urgent Description I atal Proicct Cost: $31,800 Replace theater lapel (3) and hand held (3) microphones kith supporting transmitters, receixers, splitter kit and rackmount kit. Justification �urrent microphones are of insufficient quality to \cork n clI in a space as lar_c as the theater resulting in technical -I itches during presentations. These are necessary for Center functions. Ci I\ functions and rental c\cws in the theater. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 6,000 6,000 25,800 Total 6,000 6,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future AC - Arts Center Fund 6,000 6,000 25,800 Total 6,000 6,000 Total from 20 -year plan: Ne" item. 36 %fond r. Jule 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 rhl- 1 2018 City of Hopkins, MN Project # 01 -ERP -0003 Project Name Network Server Future Department City Hall Administration Contact Finance Director/IT Type Equipment Useful Life 1 year Category Equipment Priority n/a Description 7 Total Project Cost: $249,000 Fhe 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.. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 89,000 Equipment 8,000 8,000 8,000 8,000 8,000 40,000 120,000 Total Total 8,000 8,000 8,000 8,000 8,000 40,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future F--89—,0-0-01 Equipment Replacement Fund 8,000 8,000 8,000 8,000 8,000 40,000 120,000 Total Total 8,000 8,000 8,000 8,000 8,000 40,000 Total Budget Impact/Other Variance from 20 year plan -none Estimate salvage/resale value on replaced item: $-0- 37 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 l irn 2018 City of Hopkins, MN F ject # 01 -ERP -0004 ject Name Telephone System Future DeparunenI City Ilall Administration Contact 11' Director I ) pe liquipment I. sefuI Life 8 years ('ategor� Equipment Priorits n (tion focal Project CosC $349,900 the PBX, the voice mail systems. and all telephone instruments. Currenih there arc ox cr 200 extensions screed by this system. Also software for the PBX and \ oice mail systems. Justification Making, receiving and routing telephone calls. storing voice mail messages. and providing telephone based information sery ices (snow line, etc.) Prior Expenditures 2014 2015 2016 2017 2018 Total Future 60,000 Equipment 89.600 89,600 200,300 Total Total 89,600 89,600 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 60,000 Equipment Replacement Fund 76,000 76,000 200,300 Total SF - Sanitary Sewer Fund 6,800 6,800 Total WF - Water Fund 6,800 6,800 Total 89,600 from 20 year plan - Upgrade to controller in 2009 delays complete replacement to 2015. salvage/resale value on replaced item: S 89,600 A1��n�lui lull _'9. 'u/ 38 EQUIPMENT REPLACEMENT PLAN 2014 lhru 2018 Department City Hall Administration City of Hopkins, MN Contact Finance Director Project # 01 -ERP -0005 Project Name Financial Software - Various Depts Type Equipment Useful Life 7 years Category Equipment Future Priority n/a iption Total Project Cost: $415,000 software upgrade. Software currently used by Finance, City Clerk, Inspections and Public Works. This includes software for all finance tons including general ledger, payroll, accounts payable, accounts receivable, fixed assets, utility billing; Business Licesnes, Building GIS Mapping, Purchasing, etc. Justification �urrent 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. Prior Expenditures 2014 2015 2016 2017 2018 Total 165,000 Equipment 250,000 250,000 Total Total Prior Funding Sources 250,000 2014 2015 250,000 2016 2017 2018 Total 165,000 Equipment Replacement Fund 250,000 250,000 Total Total Budget Impact/Other 250,000 250,000 Variance from 20 year plan - replacement needed in 2014 Estimate salvage/resale value on replaced item: $-0- 39 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 thri, 2018 City of Hopkins, MN Project a 01 -ERP -0006 Project Name Computers Future Department City Ilall Administration Contact finance Direcun'II 1) pe Equipment I seful Life 3-5 yeas Cmegor� Equipment Priorits n a Description I total 1'ro,ject Cost: $990,000 Personal computer purchases and upgrades for the entire City staff. C(,�ndinating personal computer purchases from indis idual departments to one Justification Fools enabling staff to perform job responsibilities efficiently and cflccticcly. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 390,000 Equipment 30,000 30,000 30,000 30,000 30,000 150,000 450,000 Total Total 30,000 30,000 30,000 30,000 30,000 150,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 'Total Future 390,000 Equipment Replacement Fund 30,000 30,000 30,000 30,000 30,000 150,000 450,000 Total Total 30,000 30,000 30,000 30,000 30,000 150,000 Total Budget Impact/Other ✓ariance from 20 year plan - none Estimate salvage/resale value on replaced item: 5-0- 40 Slandur../uh 29. ?ni3 EQUIPMENT REPLACEMENT PLAN 2014 lhru 2018 City of Hopkins, MN Project# 01 -ERP -0012 Project Name Core Network Switch Future Department City Hall Administration Contact Finance Director/IT Type Equipment Useful Life 6 years Category Equipment Priority n/a Description Total Project Cost: $53,300 Provides layer 3 IP presence for the network, core switching connectivity, backbone on which all network communication is built and facilitates 6br optic network connection to fire department. Cisco 3560E-24PD managed switch - $3,000 each Cisco X2-1 OGB-LR fiber optic transceiver - $1200 each cost listed is for equipment only and does not include tax, shionin2 and other related costs Justification �urrent two switches are obsolete, end of life and no longer supported by manufacturer. Past lost of service resulted in significant network outage :hat was immediately noticed by many employees. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 10,000 Equipment 12,000 12,000 31,300 Total Total 12,000 12,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 10,000 Equipment Replacement Fund 12,000 12,000 31,300 Total Total 12,000 12,000 Total 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 2014 th tt 2018 City of Hopkins, MN project # 01 -ERP -0008 Project Name Document Management Scanner (2) Future Departnicut CommunityScnices Contact City Clerk IN pe Fquipmew t seful Life 5 years Cawgor\ Equipment Priorits n Description I otal Project Cosi: $65,100 Large document (11" xIT) scanner lbr doCUnlCnt management and retention as vNell as general administratjve use. Purchased two scanners in 2012 at a cost of S 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 her IT. Excess time \\ as spent by IT keeping the scanners working. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 23,300 Equipment 6,000 6,000 12,00029,800 Total Total 6,000 6,000 12,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future F--23—,3-00-1 Equipment Replacement Fund 6,000 6,000 12,000 29,800 Total Total 6,000 6,000 12,000 'I'otal Budget Impact/Other Variance from 20 year plan - Two nevN scanners purchased in 2012 and will be replaced every three years. Previously scanners had been repaired. Estimate salvage/resale value on replaced item: 5500-S 1.000 Monday. July '9, 'nl ,' 42 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0011 Project Name Election Equipment Future Department Community Services Contact City Clerk Type Equipment Useful Life 10 years Category Equipment Priority n/a Description Total Project Cost: $117,200 Replace election M-100 ballot scanners and ballot boxes. - 9 machines total. Asking for 10 in replacement plan from County. Justification k11 Hennepin County equipment is being replaced in 2014. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 50,000 50,000 67,200 Total Total 50,000 50,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 50,000 50,00067,200 Total 50.E 50,000 Total Budget Impact/Other Variance from 20 year plan - Move from 2013 to 2014 Estimate salvage/resale value on replaced item: $-0- 43 Monday, Julv 29, 20/3 EQUIPMENT REPLACEMENT PLAN 2014 th i, 2018 City of Hopkins, MN Project # 01 -ERP -0100 Project Name Tele -Squirt (Engine 2) Future engine: full size response truck Department Fire Contact Fire Chief I.Npe Fquipment t setul Lire 10 years Cawgor) Vehicles Priorih n a Total Project Cost: $1,338,100 Current vehicle: 1989 Ford L9000 Tele -Squirt (=102) Justification This is a replacement engine for response to cmcrgcm:y response in the City. We kill be reducing the fleet by one truck in making this one unit (ladder/pumper) which would reduce the lite of a \ chicic from 25 years to 111 v cars. `v','c are finding that the life a v,chicle is no longer 2(1 years. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 570,900 570,900 767,200 Total 570,900 570,900 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 570,900 570,900 767,200 Total 570,900 570,900 Total from 20 year plan - was scheduled for replacement in 2019 and has been mo\ ed up to 2017. Change useful life from 25 to 10 years. salvage/resale value on replaced item: S Mundm,.hdr"l. 'til 44 EQUIPMENT REPLACEMENT PLAN 2014 1hrit 2018 City of Hopkins, MN Project # 01 -ERP -0103 Project Name Duty Chief Vehicle Future Department Fire Contact Fire Chief Type Equipment Useful Life 5 years Category Vehicles Priority n/a description Total Project Cost: $254,200 marked passenger vehicle for use by the Duty Chief and Assistant Chiefs in transporting required equipment, reference materials and personnel r emergency response, and routine Fire Department business. 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 Jsed by the Fire Chief and Asst. Chiefs when responding to fires and other emergencies. Used for official business in and out of the city and for Fire fighter travel on official Fire Department business. °ventually 3 SUV's - replaced every 5 years with 15 year life. New - chief, cycle down to Asst. Chief 1 and Asst. Chief 2. Prior Expenditures F--6-4,-50-01 Vehicles Total 2014 2015 2016 2017 2018 Total Future 37,000 37,000 152,700 Total 37,000 37,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future —64,500-1 Equipment Replacement Fund 37,000 37,000 152,700 Total Total 37,000 37,000 Total ice from 20 year plan - Add 2 vehicles and change life to 15 years. 2015 replacement back to 2016. tte salvage/resale value on replaced item: $4,000 Monday, July 29, 2013 45 EQUIPMENT REPLACEMENT PLAN 2014 th ti 2018 City of Hopkins, MN Project # 01 -ERP -0105a Project Name Fire Utility Vehicle (Pick Lip Truck) Future pickup truck on a 4 wheel drive chassis. Dep:u'nucnt Fire Contact Fire Chien I N pe Equipment I scful Life 5 vears Category Vehicles Prioritc ii Total Projccl Cost: $201.700 'urrent vehicle: 1998 Chevrolet Lumina (4106) - wxd h% Fire Inspector Justification With getting rid of our light rescue, we will be losing a \c.ry to haul equipment back and forth from the fire scene to the station. This vehicle would >e used to haul equipment and personnel to and from the scene and can he used for people to go to schools. Expenditures 2014 2015 2016 2017 2018 Total Future Vehicles 40,000 40,000 161,700 Total 40.000 40,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 40,000 40,000 161,700 Total 40.000 40,000 Total Budget Impact/Other Jariance from 20 year plan - Change from 10 year life to 5 years. dove from 2016 to 2015 and increased cost from 535.000 to S40.(100 Estimate of salvage/resale value on replace item - S 46 Atowl'n ..111/1 29. 2013 EQUIPMENT REPLACEMENT PLAN 2014 /hru 2018 City of Hopkins, MN IIroject# 01 -ERP -0106 Project Name Aerial Truck Future Department Fire Contact Fire Chief Type Equipment Useful Life 20 years Category Vehicles Priority n/a Total Project Cost: $2,559,597 hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. Lease payments due 2009-2018 on purchase of Pierce Aerial Truck. Payments due semi-annually each April 23 and October 23. vehicle: 2008 Pierce Arrow XT Aerial Ladder (#1 Justification ehicle 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 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 tyments equals $987,597. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 716,512 Equipment 54,217 54,217 54,217 54,217 54,217 271,085 1,572,000 Total Total 54,217 54,217 54,217 54,217 54,217 271,085 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 716,512 Bonds/Lease 54,217 54,217 54,217 54,217 54,217 271,085 1,572,000 Total Total 54,217 54,217 54,217 54,217 54,217 271,085 Total 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 2014 Mri, 2018 Department Fire City of Hopkins, MN Contact Dire Chief Project # 01 -ERP -0107 Project Name Air Compressor Future Description Justification I ape Fquipment I serul hire 15 years ( ate#,or� Equipment Priority ma I otal Project Cost: $89,300 Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 34,900 34,900 54,400 Total Funding Sources 2014 34,900 2015 2016 2017 34,900 2018 'Total Total Future Equipment Replacement Fund 34,900 34,900 F 54,400 Total 34,900 34,900 Total Impact/Other from 20 year plan - move back to 2017 salvage/resale value on replaced item - S 3: 1996 Alondun.Juh 29, 20/; 48 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0108 Project Name Self Contained Breathing Apparatus (45) Future Description 3reathing apparatus for interior firefighting for firefighters. Department Fire Contact Fire Chief Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost: $752,000 Justification rhe 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. Prior Expenditures 2014 2015 2016 2017 2018 Total Future F-1-66.000-1 Equipment 250,000 250,000 336,000 Total Total 250,000 250,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 166,000 Equipment Replacement Fund 250,000 250,000 336,000 Total Total 250,000 250,000 Total Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replaced item: $ Monday, July 29, 20/3 49 EQUIPMENT REPLACEMENT PLAN 2014 i1wit 2018 City of Hopkins, MN Project # 01 -ERP -0112 Project Name Thermal Imaging Camera (2) Future Department Fire Contact Fire Chief pe Equipment l seful life IO vears Calc! on Equipment Priorio n ascription I otal Project Cost $72,200 :d by our fire companies to locate \ ictims trapped in a smoke tilled building. It helps us determine nhere fire and heat may be hidden allowing faster extinguishment. e: purchased 2003 & 2007 Justification -urrent camera is ten years old and has been through many hot tires and needs to be replaced. Current camera Baas purchased with donation Prior Expenditures 2014 2015 2016 2017 2018 Total future 26,500 Equipment 12,900 12,900 32,800 Total Total 12,900 12,900 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future —26,500-1 Equipment Replacement Fund 12,900 12,900 32,800 Total Total 12.900 12,900 Total Budget Impact/Other Variance from 20 year plan - department owns 2 cameras. Previously one uric \v°as included in the replacement plan. This NNill add to the replacement schedule the camera purchased from the Fire Dept budget in 2003. Estimate salvage/resale value on repalced item: S-0- Mnndar. Juh 1). 'Ol t 50 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0114 Project Name Floor Scrubber Future Description Floor scrubber to keep apparatus floors clean. lCurrent equipment: 2004 Tennant 5400 Justification Scrubber is used to keep apparatus floors clean so that floor will last longer. Department Fire Contact Fire Chief Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost: $34,600 Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 14,300 14,300 20,300 Total 14,300 14,300 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 14,300 14,300 F 20,300 Total 14,300 14,300 Total Budget ImpacVOther Variance from 20 year plan - Eliminate sweeper and add scrubber as scrubber is used more. dove from 2016 to 2015 Estimate salvage/resale value on replaced item: $0 Monday, July 29, 2013 51 EQUIPMENT REPLACEMENT PLAN 2014 rhru 2018 Department Piro City of Hopkins, MN Contact Fire chit Project# 01—ERP-0116 t>pe Equipment t sdul Life 6 years Project Name Workout Equipment - Eli tical h Ca[egon 1{quipment Future Priorih wa Description olal Project ( os(: $20,300 Morkout equipment used in Fire Department veorkout room. One eliptical machine replaced on a 6 year cycle. one c\ cry 3 years. Justification Chis equipment is available to all City employees for health and wellness. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 5.800 5,800 14,500 Total 5,800 5,800 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 5,800 5,800 F 14,500 Total 5,800 5,800 Total Budget Impact/Other ✓ariance from 20 year plan -had t%ko eliptical machines in the ERP. One eras replaced along kith the stainnaster with a summit trainer. The emaining eliptical is scheduled for replacement in 2015. Estimate salvage/resale value on replaced item: S Atondui..hih _'9 'W") 52 EQUIPMENT REPLACEMENT PLAN 2014 /hru 2018 City of Hopkins, MN Project # 01 -ERP -0117 Project Name workout Equipment- Treadmill #1 Future Description Workout equipment used in Fire Department workout room. Jne summit trainer replaced on a 5 year cycle. 2010 Summit Trainer - will be replaced with a treadmill Justification chis equipment is available to all City employees for health and wellness. Department Fire Contact Fire Chief Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost: $34,300 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 5,000 Equipment 5,800 5,800 23,500 Total Total 5,800 5,800 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 5,000 Equipment Replacement Fund 5,800 5,800 23,500 Total Total 5,800 5,800 Total Budget Impact/Other Variance from 20 year plan - replaces stairmaster. Estimate salvage/resale value on replaced item: $ 53 Monday, July 29, 20/3 EQUIPMENT REPLACEMENT PLAN 2014 f wn 2018 City of Hopkins, MN Project # 01 -ERP -0118 Project Name Workout Equipment - Treadmill #2 Future kout equipment used in the Fire Department workout room. treadmill replaced on a 5 year cycle. Justification This equipment is available to all City employees for health and wellness. Department Fire Contac) Fire Chief 1) Pe Equipment I seful Life 5 years Catel;or� Equipment Prioritc n,a I o1al Project Cost: $25_100 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 5,000 Equipment 5,800 5,800 14,500 Total Total 5,800 5,800 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 57000 Equipment Replacement Fund 5,800 5,800 14,500 Total Total 5,800 5,800 Total Variance from 20 year plan - move back one year from 2011 to 2012. Estimate salvage/resale value on replaced item: S 54 4fondur. Juh 29. 20/ EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN roject # 01 -ERP -0119 'roject Name Workout Equipment - Weight Lifting Future ription machine - weight lifting machine. Department Fire Contact Fire Chief Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost: $29,300 Justification I 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 ?012. Suggested replacement is every 5 years. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 5,800 5,800 23,500 Total 5,800 5,800 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 5,800 5,800 F 23,500 Total 5,800 5,800 Total Budget Impact/Other Variance from 20 year plan - move back from 2011 to 2015 Estimate salvage/resale value on replaced items: $ 55 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 i1 it 2018 City of Hopkins, MN Project # 01 -ERP -0120 Project Name Automated External Defibrillator (2) Future 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. rrent equipment: 2010 - 4 AEDs 10 ERP had 2 AEDs schedule for replacement at 86,000. Four x\ ere purchased. Justification With changes in technology, the AED's should be replaced e% cry tour \,cars. Cost - $3,000 per unit Department Fire Contact Fire Chief 'I ape Equipment I seful Lae 3 years Categor\ Equipment Priority nla Total Project Cost: $49,100 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 6,000 Equipment 7,200 7,800 15,000 28,100 Total Total 7,200 7,800 15,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 6,000 Equipment Replacement Fund 7,200 7,800 15,000 F 28,100 Total Total 7,200 7,800 15,000 Total ariance from 20 year plan - adju.nrtcnt from 3 years to 4 years. stimate salvage/resale value on replaced item: S 56 Mondor../nh "l. 2013 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0122 Project Name Workout Equipment - Dumb Bells Future Description Workout equipment used in Fire Department workout room. Department Fire Contact Fire Chief Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost: $11,700 Justification �urrent dumb bells are 15 plus years old. The current dumb bells are older and some of the weights contained lead based plaint. This purchase Mould update our dumb bells to the current type fitness bells. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 5,000 5,000 6,700 Total 5,000 5,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 5,000 5,000 6,700 Total 5,000 5,000 Total Budget Impact/Other Variance from 20 year plan - Move back from 2014 to 2017. Estimate salvage/resale value on replaced item: $ 57 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 Mri, 2018 City of Hopkins, MN Project # 01 -ERP -0400 Project Name 4x4 3/4 Ton Truck Future Departinew HRA Contact Unassigned pc [quipment t seful Life 8 years Catcgor� Vehicles Priority n a Description total Project Cost: $148,400 1 wheel drive 3/4 ton truck to be used by Public Housing maintenance staff. Includes snoxc ploy. Current vehicle: 2007 Chevrolet Pickup Justification Transportation for Public Housing Superintendent and snow plo\ying at Various HRA properties around the city. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 22,800 Vehicles 32,400 32,400 93,200 Total Total 32,400 32,400 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 22,800 HRA - Housing and Redevelop 32.400 32,400 93,200 Total Total 32,400 32,400 Total ariance from 20 year plan - none stimate salvage/resale value on replaced item: S 1.800 58 Afoudur. Juh '9, 2013 EQUIPMENT REPLACEMENT PLAN 2014 thrl, 2018 City of Hopkins, MN Project a 01 -ERP -0401 Project Name HRA Copier Future Department HRA Contact Finance Director Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost: $50,400 copy machine to service the needs of the HRA. High volume product copier to do a variety of copying tasks. equipment: Imagistics ZB35 Justification daily use to make copies of correspondence, forms and rental documents. Periodically produce documents such as resident newsletters and narketing. Machine will duplex, sort, collate and staple copies. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 13,000 13,000 37,400 Total 13,000 13,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future HRA - Housing and Redevelop 13,000 13,000 37,400 Total 13,000 13,000 Total Budget Impact/Other Variance from 20 year plan - New item. Estimate salvage/resale value on replace item: $ - 0 - 59 Monday, July 29, 20/3 EQUIPMENT REPLACEMENT PLAN 2014 thrix 2018 City of Hopkins, MN F ect # 01 -ERP -0200 ect Name Marked Patrol Vehicles (6) Future Uepartinent Police Contact Police Chief ►ape Equipment t seful Lire 3 years Cate! ori Vehicles Priorio n a Description l opal Project ('ust: $3,280,100 Marked patrol vehicles used by patrol officers to respond to �:;il Is. enforce traffic lay\ s and pertorm general patrol duties. Fleet consists of 6 patrol vehicles - 5 marked. 1 unmarked. Zurrent vehicles: (3) 2011 Ford Crox+n Victorias. (2) 2010 Ford Crovv n \1ictorias. ( I ) 2009 Ford Croy%n Victoria Justification iet up and marking of police vehicles must contiwm to Alinncsota lavv and POST standards. Ve111CICS contain Seatrc data and radio equipment k i -outine and emergency operations. Vehicles contain secure seating for prisoner transport. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 778,100 Vehicles 90,000 90,000 90,000 98,000 98,000 466,000F-2-,-036,7000 Total Total 90,000 90,000 90,000 98,000 98,000 466,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future F-778—,10-01 Equipment Replacement Fund 90,000 90,000 90,000 98,000 98,000 466,000 2,036,000 Total Total 90,000 90,000 90,000 98,000 98,000 466,000 Total Budget Impact/Other Variance from 20 year plan - cost modified due to ne\\ models of'squads xehich need to be re -outfitted for all equipment. E-'stimate salvage/resale value on replaced item: 54.000 each Alondnr. Juh29. 2013 60 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0201 Project Name Sergeant's Vehicle Future Department Police Contact Police Chief Type Equipment Useful Life 4 years Category Vehicles Priority n/a )ascription Total Project Cost: $322,200 larked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. year rotation. �urrent vehicle: 2011 Ford Crown Victoria Justification 71 Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for •outine and emergency operations. Vehicles contain secure seating for prisoner transport. Prior Expenditures 33,600 Vehicles Total 2014 2015 2016 2017 2018 Total Future 45,000 45,000 243,600 Total 45,000 45,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future F-3-3,-60-01 Equipment Replacement Fund 45,000 45,000 243,600 Total Total 46.E 45,000 Total from 20 year plan - cost modified due to new model of car which will require all new equipment. salvage/resale value on replaced item: $3,500 each Monday, July 29, 2013 61 EQUIPMENT REPLACEMENT PLAN 2014 th tl 2018 City of Hopkins, MN Project # 01 -ERP -0202 Project Name Parking Enforcement Vehicle (Parking Fund) Future Description Parking enforcement vehicle. Department Police 0111fact Police Chief I N pe t(quipmcnt l sefuI Life 10 vcars C ategor1 Vehicles Priority n I oral Project (blit: $82.500 Current vehicle: 2006 Jeep Liberty (�21 1) Justification Use by parking enforcement officers in the course of their duties enforcing parking regulations in the dox%nto\, n arca. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 18,700 Vehicles 27,200 27,200 36,600 Total Total 27,200 27.200 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 18,700 Equipment Replacement Fund 27,200 27,200 36,600 Total Total 27,200 27,200 Total Budget Impact/Other Variance from 20 year plan - amount allocated is not sufficient. Increase to S27.200. Estimate salvage/resale value on replaced item: S 1.500 Afoudur. Jult 29. 2013 62 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, NIN Project # 01 -ERP -0203 Project name PSO - Utility 4x4 (unit 212) Future Department Police Contact Police Chief Type Equipment Useful Life 6 years Category Vehicles Priority n/a Description Total Project Cost: $333,700 l 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. Prior Expenditures 2014 2015 2016 2017 2018 Total Future -67,400-1 Vehicles 47,700 47,700218,600 Total Total 47,700 47,700 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 67,400 1 Equipment Replacement Fund 47,700 47,700 218,600 Total Total 47,700 47,700 Total Budget Impact/Other Variance from 20 year plan - none. Estimate salvage/resale value on replaced item: $5,000 Monday, July 29, 20/3 63 EQUIPMENT REPLACEMENT PLAN 2014 th tt 2018 City of Hopkins, MN Project # 01 -ERP -0204 Project Name Police Administrative Vehicles (2) Future Description ?olice administration (chief, captian). Imestigat ke Scrgcant. and Detective \ ell icIcs. Chiefs vehicle - even numbered wars Captain's vehicle - odd numbered years Depar(luent Police Contact Police ('fief 1.%Pc Equipment t seful Life 2 years Catvgorc Vehicles Priorits n a Total Project Cost: $754,322 ,e 2014 - Chief vehicle to he leased torr 4 years - 2yr for chief and 2yr for Im esti gatiyc Sergeant. In year 3 the Chief will get a nes\ leased and use for two years before again passing the chicle do�yn to the Im cstigati�c Scrgcant who will use it torr another 2 years. ve 2015 - Captain vehcilc to be leacd for 4 years - 2yr tier captain and 2yr for Detective #3. In year 3 of (ease the Capitain will _act a neN vehicle, use for 2 years before passing down to Defectis c -, who \\ ill uSc it torr another t\yo year:. 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 IIICS used by chief and captain. Staff use is for two years. Vehicles are then rotatcd down to detectives and are kept for an additional 3-4 years. Vehicles are also used for suryciIlance by uniform and plain clothes officers. Prior Expenditures 298,700 Vehicles Total 2014 2015 2016 2017 2018 Total Future 4,694 9,529 14,509 19,638 20,224 68,594 387,028 Total 4,694 9,529 14,509 19,638 20,224 68,594 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 298,700 Equipment Replacement Fund 4,694 9,529 14,509 19,638 20,224 68,594 387,028 Total Total 4,694 9,529 14,509 19,638 20,224 68,594 Total from 20 year plan - starting in 2014 chief, \ ehcile will be leased and in 2015 the captians will be leased. salvage/resale value on replaced item: 54.000 each for current ychicles not leased. h9ondur../uh 29. 2013 64 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0204a Project Name Police Admin Cars - outfit leased vehicles Future Description ; EQUIPMENT REPLACEMENT PLAN 2014 illrit 2018 City of Hopkins, MN Project # 01 -ERP -0205 Project Name SWAT Vehicle Future 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 771 Previous vehicle (15 years old) was a safety hazard and N+ as replaced in 2005. Department Police Contact Police Chief 'I.% pe Equipment t seful Life 15 years Category Vehicles 1'riorits n a Total Project Cost: $76,700 Expenditures 2014 2015 2016 2017 2018 Total Future Vehicles 30,000 30,000 467700 Total 30,000 30,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 30,000 30,000 46,700 Total 30,000 30,000 Total Budget Impact/Other Variance from 20 year plan - extended life from 10 to 15 years Estimate salvage/resale value on replaced item: S3.000 66 A/muhn. July 29. 2013 EQUIPMENT REPLACEMENT PLAN 2014 rhru 2018 City of Hopkins, MN Project # 01 -ERP -0206 Project Name Drug Task Force Vehicle Future Task Force Vehicle affective 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. Department Police Contact Police Chief Type Equipment Useful Life 4 years Category Vehicles Priority n/a Total Project Cost: $232,276 Expenditures 2014 2015 2016 2017 2018 Total Future Vehicles 4,694 4,694 9,674 9,674 10,260 38,996 r 193,280 Total 4,694 4,694 9,674 9,674 10,260 38,996 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 4,694 4,694 9,674 9,674 10,260 38,996 193,280 Total 4,694 4,694 9,674 9,674 10,260 36,996 Total from 20 year plan: New for 2014 Monday, July 29, 2013 67 EQUIPMENT REPLACEMENT PLAN 2014 M tt 2018 City of Hopkins, MN Project # 01 -ERP -0206a Project Name Drug Task Force Vehicle - outrit leased vehicle Future Description �ost to outfit leased Drug Task Force vehicle Deparnuenl Police Contact Police Chief } pc Equipment t serol Life 5,000 Category Vehicles Priorih ma Total Project Cost: $50,000 Justification We need to account for the cost to outfit the vehicles that are leased. Estimated cost is S5.000 per ncNv ychicle. DTF vehicle will be replaced every 2 years with the 2nd two years of the lease going to a Detective. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 5,000 5,000 5,000 15,000 35,000 Total 5,000 5,000 5,000 15,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 5,000 5,000 5,000 15,000 35,000 Total 5,000 5,000 5,000 15,000 Total ariance from 20 year plan: Cost of outfitting DTF vchicles is nog+ accounted for separately from the ychicle purchase since the vehicle is now >w leased. Alondar. Juh 29. 201.3 68 EQUIPMENT REPLACEMENT PLAN 2014 rhr„ 2018 Department Police City of Hopkins, N4N Contact Police Chief Project # 01 -ERP -0209 Type Equipment Useful Life 5 years Project Name Copy Machine - Police Dept Category Equipment Future Priority n/a Description Total Project Cost: $161,600 ?olice Department copy machine capable of producing double side copies and collating pages, color/BW, fax acapability and scan.. 2011 Ricoh RMP C6501 Justification Jsed to make duplicate copies of reports, letters, memos, etc., generated by police personnel, fax and scan.. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 49,800 Equipment 22,100 22,100 89,700 Total Total 22,100 22100 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 49,800 Equipment Replacement Fund 22,100 22,100 89,700 Total Total 2'1,100 22,100 Total Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 69 Monday, July 29, 20/3 EQUIPMENT REPLACEMENT PLAN 2014 Ill, a 2018 City of Hopkins, MN Project to 01 -ERP -0210 Project Name Focus Car Future Vehicle on Crime Using Strategies) affective in 2015 this vehicle will be leased for 4 years 2 years as a Focus vehicle 2 years as Detective #2 vehicle for the lease for 2 vch Justification fhis is the street crime/undercover vehicle. Previously did not haXrc it car for this purpose. I)CPartment Police Contact Police Chief I.%PC I{quipment I seful Life 4 vcars Catcgor� Vehicles Priories it it Total Project Cost: $223,346 Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 4,835 4,835 9,964 9,964 29,598 193,748 Total 4,835 4,835 9,964 9,964 29,598 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 4,835 4,835 9,964 9,964 29,598 193,748 Total 4,835 4,835 9,964 9,964 29,598 Total ariance from 20 year plan: New for 2015 70 Mundur. Jule 'y. _'ell ; EQUIPMENT REPLACEMENT PLAN 2014 lhru 2018 City of Hopkins, MN Project # 01 -ERP -0210a Project Name Focus Car - outfit leased vehicle Future Description 'ost to outfit leased Focus vehicle Department Police Contact Police Chief Type Equipment Useful Life Total Category Vehicles Priority n/a Total Project Cost: $50,000 Justification Ale need to account for the cost to outfit the vehicles that are leased. Estimated cost is $5,000 per new vehicle. 'ocus vehicle will be replaced every 2 years with the 2nd two years of the lease going to a Detective Expenditures 2014 2015 2016 Equipment 5,000 2017 2018 5,000 Total 10,000 Future 40,000 Total 5,000 5,000 10,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 5,000 5,000 10,000 40,000 Total 5,000 500 10,000 Total 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 iow leased. Monday, July 29, 2013 71 EQUIPMENT REPLACEMENT PLAN 2014 lltvt 2018 City of Hopkins, MN Project # 01 -ERP -0211 Project Name Network Server (3) Future Deparunent Police Contact Police Chief I [.c pe Equipment I seful Lire 3 years Categon Lquipmcnt Priorith n I otal Project Cotte $263,500 puter servers store information and system programs. server @ $15,000 (to be purchased for digital squad car cameras storagc and retrieval - sec 01 -ERP -213) Justification knnual replacement cycle allows development of system storage program. Use of ncvN cr servers for heavy use programs while older servers used or data storage. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 93,500 Equipment 8,500 8,500 8,500 8,500 8,500 42,500127,500 Total Total 8,500 8,500 8,500 8,500 8,500 42,500 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 93,500 Equipment Replacement Fund 8,500 8,500 8,500 8,500 8,500 42,500 127,500 Total Total 8,500 8,500 8,500 8,500 8,500 42,500 Total Budget Impact/Other Variance from 20 year plan - Cost stabilized at 58.500 per year. Estimate salvage/resale value on replaced item - S Mondor. July 29. 201 i 72 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN 'roject # 01 -ERP -0212 'roject Name Mobile Data Computers Future Department Police Contact Police Chief Type Equipment Useful Life 5 years Category Equipment Priority n/a Description Total Project Cost: $297,800 Mobile data computers installed in 11 squad cars used to receive calls from dispatch, query information from various databases, communicate car :o car. 11 - 2007 Panasonic Justification : imited life of 5 years - replacement necessary. Prior Expenditures 2014 2015 2016 2017 2018 Total Future F-74-7,00-0-1 Equipment 62,700 62,700 1887100 Total Total 62,700 62,700 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 47,000 Equipment Replacement Fund 57,000 57,000 188,100 Total PKG - Parking Fund 5,700 5,700 Total Total 62,700 62,700 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, 20/3 73 EQUIPMENT REPLACEMENT PLAN 2014 1111 -it 2018 City of Hopkins, MN Project # 01 -ERP -0213 Project Name Digital Squad Car Cameras Future Department Police Contact Police Chief I �N pe Equipment I seful Life 5 years Category Equipment Priorio n a Description fatal Project Cost: $256,200 Digital video camera system in each marked patrol car - used to d0CamC111 events in and out of the patrol car. Images downloaded to server for storage and retrieval. Currrent eauinment: 20091COP Model 20 20-W LIVE Justification Police Dept. currently has ten digital camera units installed and a dedicated serer. The lifc expectancy of the cameras is about five }ears. Current cameras were installed in September 2009. Cost: 10 cameras @ $5,000 per unit plus tax - S53.430 1 server@ $15,000 (to be purchased from Police Nemork Sencr (01 -ERP -21 1) annual allocation that carries forward. Estimated cost $53,430. Cost could be lower it. at the time of replacement. a suitable product is available through a State or County equipment Prior Expenditures 2014 2015 2016 2017 2018 Total Future 42,600 1 Equipment 53.400 53,400 160,200 Total Total 53,400 53,400 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 42,600 Equipment Replacement Fund 53,400 53,400F--1-6-0,-2700 Total Total 53,400 53,400 Total Budget ImpacVOther Variance from 20 year plan - Increase quantity to ten to cower all marked unmarked patrol ychicles. Cost of cameras remains at 55,000 each plus tax - $53,430. Estimate salvage/resale value on replaced item: S tfomlur. Juh 29. 20/3 74 EQUIPMENT REPLACEMENT PLAN 2014 lhru 2018 Department Police City of Hopkins, MV Contact Police Chief Project # 01 -ERP -0214 Type Equipment Useful Life 5 years Project Name Tactical Ballistic Vests Category Equipment Future Priority n/a Description Total Project Cost: $137,500 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 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 43,200 Equipment 26,900 26,900 67,400 Total Total 26,900 26,900 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 43,200 Equipment Replacement Fund 26,900 26,900 67,400 Total Total 26,900 26,900 Total from 20 year plan - Team membership has increased to 11. salvage/resale value on replaced item: $ Monday, July 19, 2013 75 EQUIPMENT REPLACEMENT PLAN 2014 dirii 2018 City of Hopkins, MN Project # 01 -ERP -0215 Project Name Radios - Portable and Mobile Devices Future Oepart[licit t Police Contact Police Chief T.Npc Equipment t seful Life 20,500 Cawgort I(quipment Priority n a Description I otal Project Cost: $600,000 Portable and mobile radios used by the police. fire and public works departments to alloNN 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 S528.500 Installation of mobile S 71.600 est Grand Total 5600.000 target budget Police Fire PW Total Portable 65 46 0 1 1 1 PNV radios vv cit 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 count )bile radios were replaced in police cars due to nc\X model cars: 13 - replaced in Captain car, squad #3. & #5 (3 = S 12.300) 14 - replace in Squad #1, #2, PSO. Chief. DTF (5 =, 520.5(10) 15 - replace in squad #4, #6, Sergeant. Captain. FOCUS (5 = S20,500) 16 - replace in squad parking (I = S4.100) to - some cars are duplicated as thev are nwved do\N n to investigators Prior Expenditures 12,300 Equipment Total 2014 2015 2016 2017 2018 Total 20,500 20,500 12,300 534,400 587,700 Total 20,500 20,500 12,300 534,400 587,700 Prior Funding Sources 2014 2015 2016 2017 2018 Total 1 —2,30-0-1 Equipment Replacement Fund 20,500 20,500 12,300 534,400 587,700 Total Total 20,500 20,500 12,300 534,400 587,700 Budget Impact/Other Variance from 20 year plan - Radio's have a 7-10 year life expectancy. Duc to new squad models and the placement of the radios we needed to )uy a new model of radio to fit into the squads.. Estimate salvage/resale value on replaced item: SO A4ondar. Judi 29. 2f)13 76 EQUIPMENT REPLACEMENT PLAN 2014 rhru 2018 City of Hopkins, MN Project # 01 -ERP -0217 Project Name Taser Replacement Future Department Police Contact Police Captain Type Equipment Useful Life 4 years Category Equipment Priority 3Important scription Total Project Cost: $119,300 police department will need to replace all of its X26 Tascrs (ECD) Electronic Control Devices including all software and HD Camera systems transition to the new X2 Tasers. Justification fhe current Tasers will need to be replaced due to the age and use of the equipment. Prior Expenditures 2014 2015 2016 2017 2018 Total Future F-71-8,-60-01 Equipment 20,900 20,900 F 79,800 Total Prior Total Funding Sources 2014 2015 20,900 2016 2017 2018 20,900 Total Total Future 18,600 Equipment Replacement Fund 20,900 20,900 F 79,800 Total Total 20,900 20,900 Total 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 2014 th u 2018 City of Hopkins, MN Project # 01 -ERP -0710 Project Name 4X4 1/2 Ton Truck Future Description Pickup used by various divisions of Public Works. Justification _fight hauling and transportation for supervisor;. Maintenance garage scryice \chicle. Department Public Works: 131de-Equip Ser Contact Public Works Director 1'.% pe Equipment t sefnl Life 10 years Cate„ ori Vehicles Priorio n/a fatal Project Cos(: $96,700 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 23,300 Vehicles 31,300 31,300 42,100 Total Total 31,300 31,300 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 23,300 Equipment Replacement Fund 31,300 31,300 42,100 Total Total 31,300 31,300 Total 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: S 1.500 Mondur..luh 29. -11) /3 78 EQUIPMENT REPLACEMENT PLAN 2014 rhru 2018 City of Hopkins, MN Project # 01 -ERP -0700 ?roject Name Engineering Van Future Description Van used by Engineering Department for survey equipment and on job site work. �ost of 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. Prior Expenditures 16,000 Vehicles Total Department Public Works: Engineering Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $46,900 2014 2015 2016 2017 2018 Total Future 2,000 2,000 F 28,900 Total 2.000 2,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future ----16-,-00-01 Equipment Replacement Fund 2,000 2,000 28,900 Total Total 2,000 ZOOO Total from 20 year plan - Replace with surplus Police Tahoe in 2014. Leave $2,000 for modifications.. salvage/resale value on replaced item: $2,500 Monday, July 29, 20/3 79 EQUIPMENT REPLACEMENT PLAN 2014 darn 2018 �,�l�l T Ucp:u�imcni Public Works: ParksForestry lYl City of Hopkins, Contact Public Works Director Project # 01 -ERP -0802 1.% pe Fquipment t seful Life 14 years Project Name 3/4 Ton Utility Truck Category Vehicles Future Priority ria Description Total Projcct Cuss: $80,9011 3/4 ton truck with utility body used for transporting lools and equipmcnl tier repair of carious buildings. irrigation, etc. around the cite. vehicle: 1998 Dodge Ram 3500 (#805) Expenditures 2014 2015 2016 2017 2018 Total Future Vehicles 32,200 32,200 48,700 Total 32,200 32,200 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 32,200 32,200 48,700 Total 32,200 32,200 Total Budget Impact/Other Variance from 20 year plan - move back from 2013 to 2014. Estimate salvage/resale value on replaced item: S 80 Mondeo. Juh " , 2013 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0806 Project Name Tractor Future Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 30 years Category Equipment Priority n/a Description71 Total Project Cost: $52,000 Farm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration, plowing and grass seeding. equipment: 1984 Ford Tractor 2910 (#816) Justification Expenditures 2014 2015 2016 2017 2018 Total Equipment 52,000 52,000 Total 52,000 52,000 Funding Sources 2014 2015 2016 2017 2018 Total Equipment Replacement Fund 52,000 52,000 Total 52,000 52,000 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 2014 th t, 2018 City of Hopkins, MN Project# 01 -ERP -0807 Project Name Trueksters (3) Future used by Parks Division of Public Works for ballficld and nark, nutintcnancc. Department Public Works: Narks Forestry Contact Public Works Director 1.% pe Equipment t seful Life 15 years Category Equipment Priority wa Total Project Cost: $92,240 1996 Toro Workman (=818). 2004 Toro A\ orkman 3200 (82(1). 2004 Toro A\'orkman 2110 (4821 Justification 'ark maintenance, ballfield grooming and \yccd spraying. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 29,900 Equipment 11,000 11,000 51,340 Total Total 11,000 11,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 29,900 Equipment Replacement Fund 11,000 11,000 51,340 Total Total 11,000 11,000 Total Variance from 20 year plan - Move from 2013 to 2014. Estimate salvage/resale value on replaced item: (3) S 1.400 each Reduce to $11,000 to purchase a electric style workman. 82 Mondal. Jnh 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0808 Project Name Riding Mowers (2) Future mowers used by Parks Divison of Public Works. 2004 Toro Zero Turn 0826). 2006 Jacobson Rotary Mower Justification vlowing city parks and right of ways. Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost: $169,000 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 4 9—,0 0-01 Equipment 11,000 20,000 31,000 89,000 Total Total 11,000 20,000 31,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future F---49,-0-00-1 Equipment Replacement Fund 11,000 20,000 31,000 89,000 Total Total 11,000 20,000 31,000 Total ariance from 20 year plan - move back from 2014 to 2015. Move back from 2015 to 2016. 3timate salvage/resale value on replaced item: $600 each Monday, July 29, 2013 83 EQUIPMENT REPLACEMENT PLAN 2014 h u 2018 City of Hopkins, MN Project # 01 -ERP -0809 Project Name Slope Mower Departmen( Public Works: Parks Forestry Contact Public AForks Dirccun 1 cpe Equipment I seful Life 15 years Ca(egor) Equipment Future 11riorit.% nfa .-44--Fo(al Project Cos(: $83,600 Current equipment: 2001 DEW EZE ATM72 Slope \lo\%cr Justification Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 32.700 32,700 50,900 Total 32,700 32,700 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 32,700 32,700 50,900 Total 32,700 32,700 Total Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: S 1.000 84 EQUIPMENT REPLACEMENT PLAN 2014 Ihru 2018 City of Hopkins, MN Project # 01 -ERP -0811 Project Name Turf Sweeper Future Description rurf sweeper used by Parks Division of Public Works. Justification Spring and fall leaf pick up, debris pick up. Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 15 years Category Equipment Priority n/a Total Project Cost: $57,600 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 1 1—,6-00-1 Equipment 18,000 18,000 28,000 'I'otal Total 18,000 18,000 'Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 11,600 1 Equipment Replacement Fund 18,000 18,000 28,000 Total Total 18,000 18,000 Total Budget from 20 year plan - move from 2001 to 2003 - current unit in good condition. salvage/resale value on replaced item: $1,500 85 Monday, July 29, 20/3 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -0812 Project Name Stump Cutter Future Stump cutter used by Parks Division of Public Works. Current equipment: 1997 Vermeer Stump Cutter (K832) Justification Chipping out stumps of trees renesv cc] from city property. 2014 illi t 2018 DcparUncnl Public \\'orks: Parks Forestry Con(acl Public Works Director I .% pe Equipment l seful Life 20 vears Category Equipment Prioril) n Total Project OM: $21,200 Expenditures 2014 2015 2016 2017 2018 Total Equipment 21,200 21,200 Total 21,200 21,200 Funding Sources 2014 2015 2016 2017 2018 Total Equipment Replacement Fund 21,200 21,200 Total 21,200 21,200 Budget Impact/Other Variance from 20 year plan - extend to 20 years to reflect actual. Estimate salvage/resale value on replaced item: S 1.800 Wondar.Juh '9.2013 86 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0815 Project Name Skid Loader Future Description 2004 Bobcat 463 Justification Department Public Works: Parks/Forestry Contact Public Works Director Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost: $77,600 Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 32,000 32,00045,600 Total 32,000 32,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 32,000 32,000 45,600 Total 32,000 32,000 Total Budget Impact/Other Variance from 20 year plan - new item in 2004. Estimate salvage/resale value on replaced item: $ 87 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 1/111, 2018 City of Hopkins, MN F ect # 01 -ERP -0816 ect Name Tooleat Future Department Public orks: Parks lForestry Contact Public Forks Director I .% pe Equipment I seful Life 8 years Category Equipment Priority it )escription Total Project Cost: $193,500 se by Public Works for snow removal. skating rinks, strceping, baIIficld maintenance and transportation of people and materials. �utrent vehicle: 2010 Bobcat (#815) Justification Vew machine. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 50,000 Equipment 63,300 63,300 80,200 Total Total 63,300 63,300 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future F--50—,O—O-01 Equipment Replacement Fund 63,300 63,300 80,200 Total Total 63,300 63,300 Total Budget Impact/Other Variance from 20 year plan - NeA item \+hich replaces one tractor. Estimate salvage/resale value on replaced item: S Mondai. Alt '9 01 88 EQUIPMENT REPLACEMENT PLAN 2014 rhru 2018 City of Hopkins, MN Project # 01 -ERP -0301 Project Name 4X4 3/4 Ton Truck with Plow Future Description 3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers. JCurrent vehicle: 2006 Ford F250 (#302) Justification 71 Light hauling, pulling trailers, transportation to and from job sites. Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 8 years Category Vehicles Priority n/a Total Project Cost: $141,700 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 24,000 Vehicles 30,400 30,40087,300 30,400 Total Total 30,400 30,400 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 24,000 Equipment Replacement Fund 30,400 30,400 F 87,300 Total Total 30,400 30,400 Total 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 89 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 thril 2018 City of Hopkins, MN Project # 01 -ERP -0302 Project Name 4x2 1 Ton Dump Truck Future used in the Street Division of Public Works. lCurrent vehicle: 2006 Ford F350 Pickup (-307) Justification 71 Plows alleys in winter, light hauling. snoN� rano\ al and transportation. Department Public AVorks: Sweets/'I iatric Contact Public Works Director 1 cpc Equipment I seful Life 12 vears Categon I'.quipntcnt Priority ma Total Project Cost: $162,900 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 30,500 Equipment 54,600 54,600 77, 000 Total Total 54,600 54,600 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 30,500 Equipment Replacement Fund 54,600 54,600 F 77,800 Total Total 54,600 54,600 Total Budget Impact/Other Variance from 20 year plan - change from 4.x4 to 4x2 truck. RCdllee cost to S30.500. Moce LIP from 2005 to 2006. Extend useful life from 5 to 12 years. Estimate salvage/resale value on replaced item: 53.51111 Afonden. Juh "/. 2013 411 EQUIPMENT REPLACEMENT PLAN 2014 /hru 2018 City of Hopkins, MN rProject# 01 -ERP -0305 Project Name Single Axle Dump Truck (3) Future 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. Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 17 years Category Vehicles Priority n/a Total Project Cost: $674,100 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 207,400 Vehicles 124,000 124,000 342,700 Total Prior Total Funding Sources 2014 2015 124,000 2016 2017 2018 124,000 Total Total Future 207,400 Equipment Replacement Fund 124,000 124,000 342,700 Total Total 124,000 124,000 Total 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 2014 ihni 2018 City of Hopkins, MN Project # 01 -ERP -0306 Project Name Tandem Dump Truck Future Dump truck used in Streets Division of Public Works. lCurrent vehicles: 1996 Ford L-8000 (#315) & 1998 Ford LT8500 (--314) Justification Trucks used for heavy hauling, snow plowing and sanding. Department Public \Forks: Streets Traffic Contact Public Works Director l .N pe Equipment I seful Life 17 years Catekor� Vehicles Priorih n a I atal Project Cost: $195,200 Prior Expenditures 2014 2015 2016 2017 2018 Total 22,000 Vehicles 173,200 173,200 Total Total 173,200 173,200 Prior Funding Sources 2014 2015 2016 2017 2018 Total 22,000 Equipment Replacement Fund 173,200 173,200 Total Total 173,200 173,200 Variance from 20 year plan - Change one (was two) tandem to single axle and mm c to 01 -ERP -305. Decrease amount SI �.Illlll fur change in type of vehicle. Estimate salvage/resale value on replaced item: S -0 - We are then down to 1 tandem dump truck and 3 single axel dump trucks Mondur. A& 29. 3013 92 EQUIPMENT REPLACEMENT PLAN 2014 thrit 2018 City of Hopkins, MN Project # 01 -ERP -0307 Project Name Water Truck Future Description I Nater truck used in Streets and Parks Division of Public Works. lCurrent vehicle: 1995 Ford Water Truck (#316) Justification Used for street flushing, watering trees and plants, rink flooding and standby fire protection. Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 22 years Category Vehicles Priority n/a Total Project Cost: $195,000 Prior Expenditures 2014 2015 2016 2017 2018 Total —45,0-0-01 Vehicles 150,000 150,000 Total Total Prior Funding Sources 2014 150,000 2015 2016 2017 2018 150,000 Total 45,000 Equipment Replacement Fund 150,000 150,000 Total Total Budget Impact/Other 150,000 150,000 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 2014 Mri, 2018 City of Hopkins, MN Project # 01 -ERP -0309 Project Name Skid Loader (2) Future trucks, landscape work, snoxr rcmosaL material handling. Justification Department Public Works: Streets "Iraf6c Contact Public Works Director I ape Equipment I wful Life 12 years Cattegor\ Equipment Priority n a Total Project Cost: $187,61111 2004 Bobcat 5-1851 R Skid Loader (=32.1) & 2011 Bobcat 5650 Skid -Steer Loader (9325 Prior Expenditures 2014 2015 2016 2017 2018 "Total Future 36,000 1 Equipment 41,900 41,900 109,700 Total Total 41,900 41,900 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 36,000 Equipment Replacement Fund 41,900 41,900 109,700 Total Total 41,900 41,900 Total Budget Impact/Other Variance from 20 year plan - mo\ e back from 2010 to 2011. Estimate salvage/resale value on replaced item: S 94 Alnndu1..hih_'9, 'OL" EQUIPMENT REPLACEMENT PLAN 2014 that 2018 City of Hopkins, MN Project # 01 -ERP -0312 Project Name Roller Future Description Used by Street Department for asphalt repair and resurfacing. 1989 Ingersoll Rand Roller Justification Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost: $127,900 Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 45,900 45,900 82,000 Total 45,E 45.E Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 45,900 45,900 82,000 Total 45,900 45,900 Total Budget Impact/Other Variance from 20 year plan - Move back from 2014 to 2016. Estimate salvage/resale value on replaced item: $ 95 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 th tt 2018 City of Hopkins, MN Project At 01 -ERP -0313 Project Name Striper Future stnper. 1993 Line Striner A 199 (=3i2 Justification Department Public Works: Sit -eels l Irtlfic Contact Public AWorks Director I'IN pe liquipmcnt t seful Life 12 vears ('atet;orc Equipment Priority it a Total Project ( ost: $27,200 Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 11.200 11,200 16,000 Total 11,200 11,200 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Replacement Fund 11,200 11,200 16,000 Total 11,200 11,200 Total from 20 year plan - none salvage/resale value on replaced item: S 96 Mondor. Jtth 1), 201 EQUIPMENT REPLACEMENT PLAN 2014 lhru 2018 City of Hopkins, MN Project # 01 -ERP -0314 Project Name Asphalt Paver Future Description Asphalt paver used by Streets Division of Public Works. 1994 Justification Paving streets and parking lots. liar AD200B Paver Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost: $138,800 Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 48,800 48,800 90,000 Total 48,800 4800 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 48,800 48,800 r 90,000 Total 48,800 48,800 Total Budget Impact/Other Variance from 20 year plan. Move back from 2014 to 2015 Estimate salvage/resale value on replaced item: $500 97 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 hri, 2018 City of Hopkins, MN Project # 01 -ERP -0315 Project Name Snow Blower Future Snowblower used by the Streets Division of Public Works. 1996 SnoGo WKSOO t-,441 Justification Blowing and loading snow off Mainstrcct into trucks. Department Public Works: Streets"Ira1Tic Contact Public Works Director .% pc F(Juipmcnt t seful Life 20 years Catcgorc Fquipment Priority n/a Total Project Cost: $182,000 Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 65,000 65,000 117,000 Total Total 65,000 65,000 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 65,000 65,000 F 117,000 Total 65,000 65,000 Total from 20 year plan. Move from 2016 to 2014. Reduce amount to Purchase hydraulic po\rered blower. salvage/resale value on replaced item: 54,500 Mondalr .loh 29. _'Ul 98 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0317 Project Name Sign Machine (Traffic) Future Department Public Works: Streets/Traffic Contact Public Works Director Type Equipment Useful Life 10 years Category Equipment Priority n/a Description Total Project Cost: $31,500 vlahcine 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/ Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 13,400 13,400 18,100 Total 13,400 13,400 Total Funding Sources 2014 2015 2016 2017 2018 Total Future Equipment Replacement Fund 13,400 13,400 18,100 Total 13,400 13,400 Total Budget Impact/Other Variance from 20 year plan - new Estimate salvage/resale value on replaced item: S -0 - 99 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 1/1, 11 2018 City of Hopkins, MN Project # 01 -ERP -0900 Traject Name Refuse Truck (RAP -R) (2) Future truck used by Refuse Utility Dix inion of Public Works. Ranid Rail (901 ) & 2011 Freiuhtlincr Ranid Rail 1=900 Justification Residential waste pick up. Department Refuse Contact Public Works Director Iape Equipment l seful life 10 years Category Vehicles Priorih ma Total Project Cost: $1,462,600 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 349,100 I Vehicles 204,800 204,800 908,700 Total Prior Total Funding Sources 2014 204,800 2015 2016 204,800 2017 2018 Total Total Future 349,100 RF - Refuse Fund 204,800 204,800 908,700 Total Total 204,800 204,800 Total ariance from 20 year plan - increase cost to reflect actual stimate salvage/resale value on replaced item: S 18.000 100 Afunthn. Ath _'9 EQUIPMENT REPLACEMENT PLAN 20141/1,-112018 City of Hopkins, MN Project # 01 -ERP -0901 Project Name Refuse Truck (Rear -L) Future Description Muse truck used by Refuse Utility Division of Public Works. �urrent vehicle: 1996 Fre Justification 2esidential waste pick up. FL70 Department Refuse Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $238,100 Expenditures 2014 2015 2016 2017 2018 Total Future Vehicles 101,600 101,600 136,500 Total 101,600 101,600 Total Funding Sources 2014 2015 2016 2017 2018 Total Future RF - Refuse Fund 101,600 101,600 136,500 Total 101,600 101,600 Total Budget Impact/Other Variance from 20 year plan. Move back one year to evaluate needs. Estimate salvage/resale value on replaced item: $9,000 101 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 Mru 2018 City of Hopkins, MN Project # 01 -ERP -0550 Project Name 4x4 3/4 Ton Truck Future used by Water/Sewer Division oaf Public AA`urks. lCurrent vehicle: 2004 Chevrolet Pickup (-501) Justification Snow plowing, light hauling, pulling trailers_ general purpose transportation. Department Sewer Contact Public Works Director 1.% pe Equipment I seful lite 10 years (mekorry A'chicles Priorit,N n'a Total Project Cost: $96,900 Prior Expenditures 2014 2015 2016 2017 2018 Total Future 26,600 Vehicles 30.000 30,000 40,300 Total Total 30.E 30,000 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 26,600 SF - Sanitary Sewer Fund 30,000 30,00040,300 Total Total 30,000 30,000 'Total Budget Impact/Other Variance from 20 year plan. Reduce amount to 530.000 to reticct actual. Estimate salvage/resale value on replaced item: I'limsdai..4ugu,w 01. 'Ill 102 EQUIPMENT REPLACEMENT PLAN 2014 thru 2018 City of Hopkins, MN Project # 01 -ERP -0551 Project Name 3/4 Ton Utility Truck Future Description 1/4 ton utility truck used by the Water/Sewer Division of Public Works. Department Sewer Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost: $129,800 JCurrrent 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. Prior Expenditures 2014 2015 2016 2017 2018 Total Future 51,000 Vehicles 33,600 33,600 45,200 Total Total 33,600 33.600 Total Prior Funding Sources 2014 2015 2016 2017 2018 Total Future 51,000 1 SF - Sanitary Sewer Fund 33,600 33,600 45,200 Total Total 33.E 33.600 Total Budget Impact/Other ✓ariance from 20 year plan - none :stimate salvage/resale value on replaced item: $2,500 103 Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 th u 2018 City of Hopkins, MN Project # 01 -ERP -0555 Project Name Generator (2) Future Description Portable generator used by Water Sewer DkrisiunS of PlIb11C WVorks. Departhnent Sewer Contact Public Works Director I N pe [quipment I seful I.ik 25 years Categorc Equipment Priority n I olal Project Cost: $49,400 Current equipment: 1997 Kohler Generator. 2008 Caterpillar C15 ( 537) � Justification Emergency back up generator for lift stations and pumps. off.itc puxcer for lights and \N elding. Expenditures 2014 2015 2016 2017 2018 Total Future Equipment 26 400 26,400 23,000 Total 26,400 26,400 Total Funding Sources 2014 2015 2016 2017 2018 Total Future SF - Sanitary Sewer Fund 26,400 26,400 23,000 Total 26,400 26,400 Total Budget Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: 52.500 104 Menden .111/1 29. EQUIPMENT REPLACEMENT PLAN 2014 rhru 2018 City of Hopkins, MN Project # 01 -ERP -0500 Project Name 1/2 Ton Truck Department Water Contact Public Works Director Type Equipment Useful Life 10 years Category Vehicles Future Priority n/a Description Total Project Cost: $83,300 Frucks used by Water Department. 'urrent vehicle: 2007 Chevrolet Justification Prior Expenditures 2014 2015 2016 2017 2018 Total Future F--2-0,-5-00-1 Vehicles 26,800 26,800 36,000 Total Prior Total Funding Sources 2014 2015 26,800 2016 2017 2018 26,800 Total Total Future 20,500 WF - Water Fund 26,800 26,80036,000 Total Total 26,800 26•8W Total Budget Impact/Other Variance from 20 year plan - none 3stimate salvage/resale value on replaced item: $ KIN Monday, July 29, 2013 EQUIPMENT REPLACEMENT PLAN 2014 i/ / n 2018 City of Hopkins, MN EProiect # 01 -ERP -0501 Proieet Name 3/4 Ton Utility Truck Future Description i/4 ton utility truck used by the Water Div inion of Public Works. Dep:u1mem Water Contact Public Works Director I .% pe Equipment t seful Life 10 years C atcgor\ Vehicles Priorio n a Total Project Cost: $81,8110 lCurrent vehicle: 2006 Chevrolet Pickup Justification Transportation to and from job sites. box carries tools used by personnel for job site repairs and light hauling. Expenditures 2014 2015 2016 2017 2018 Total Future Vehicles 34,900 34,900 46,900 Total Funding Sources 2014 34,900 2015 2016 2017 2018 34,900 Total Total Future WF - Water Fund 34,900 34,900 46,900 Total 34,900 34,900 Total Budget Impact/Other ✓ariance from 20 year plan - none 3stimate salvage/resale value on replaced item: 52.500 106 Aloudur. July 21). 21113 TWENTY-YEAR REPLACEMENT SCHEDULE 107 13:0 - City of Hopkins 108 ( ƒ } f\ f # f }f { f f ! f ^ / b f ( ƒ \ \ } \\} } \\\ \\ }) \ \ ! k # WWI {})1 3� 22 [\`® �/.JI..r.. . z,!« •( � \a%u! f.(! \(( a \/\\\lfaft?#![ f$!: :&,t!|2 oyE,==� __ !■>#\!� ± »!= k!J{£®}7®� +2 ®�»)��© � /|�uz u !u� �!!e� = \___:::®* §7§#!§ : ___�,ezeo=se=l22 \\ §\\\§(§(\ !B!!E§ \\\(§ � .J � `" '✓ rqirA �, $ h �i vii 6 � _ .. L : C - - z i = a d w ° s 5 \q )§ /( / § \§/ 2)}§� } /k( /)( :• !; � Cl) § \ \[§ k§� {i 4( Kf $ {( ! f\ §§ m ;y _$ #\ - z! ■ -i 4\ §§([ § )! k§) !/r®}k }\ \ {( ( } {\ ( \( z ,a,��:e:ml�m ; oz }/ \ \ {{ 12 §_ :#{JJ�{ \8-\ / �\-�'\ Ir 16 ƒ \\If ` ! `K\#7# #\i# ,�-- -»/ \q )§ /( / § \§/ 2)}§� } /k( /)( :• !; � Cl) § \ \[§ k§� {i !�(§k !; )k §§ m )�!k )/ 2 (�:ls §§([ § )! k§) !/r®}k C§(§((`} z ,a,��:e:ml�m ; \q )§ /( / § \§/ 2)}§� } /k( /)( :• !; � Cl) -44ca City of Hopkins 114 EQUIPMENT AND BUILDING INVENTORY 115 City of Ilopkins um CITY OF HOPKINS BUILDING INVENTORY January 2013 Location/Description Replacement Cost City Hall & Police Station $7,584,428 1010 1st Street S. Fire Station 4,411,843 101 17th Avenue S. Hopkins Activity Center 1,910,986 33 14th Avenue S. Ice Arena/Pavilion 5,248,264 11000 Excelsior Boulevard Arts Center 7,187,842 1111 Mainstreet PW Admin/Garage 7,503,892 11100 Excelsior Boulevard Moline Reservoir/Well #1 2,407,797 10421 Excelsor Boulevard Blake Tower Reservoir 1,449,795 151 Tyler Avenue S. Filtration Plant 3,543,569 1401 Elmo Park Service Road Well #4 Workshop/Storage 684,705 1401 Elmo Park Service Road Well #5 241,217 1205 Highway? Well #6 321,548 801 Highway 7 Lift Station #2 - Drillane 68,307- 619 Drillane Road Lift Station #3 - Lindee's 136,264 901 Cambridge Street N.E. Lift Station #4 - LTL Meadowbrook $99,933 244 Meadowbrook Road Lift Station #5 - Big Meadowbrook 158,481 6601 Excelsior Blvd. 117 Location/Description Replacement Cost Lift Station #6 - Ronnie's 99,933 8546 Excelsior Avenue E. Lift Station #7 - Valley 316,092 801 6th Avenue S. Band Shell - Downtown Park 37,638 16 9th Avenue S. Concession Stand - Maetzold Field 156,059 1215 1st Street N. Park Building -Beach - Lifeguards 168,378 5200 Shady Oak Road Park Building -Beach -Concessions 159,056 5200 Shady Oak Road Park Shelter - Office./Bathhouse 386,235 5200 Shady Oak Road Park Shelter - Burnes 51,440 201 Park Lane Park Building - Central 116,705 101 17th Avenue S. Park Building - Harley 39,520 108 Jackson Avenue S. Park Shelter - Interlachen 63,175 220 Homedale Avenue Park Building - Oakes 45,062 301 Tyler Avenue N. Park Building - Valley 53,035 800 7th Avenue S. Parking Ramp 6,519,738 10th Avenue and Mainstreet Depot Coffee House $491,648 9451 Excelsior Boulevard Overpass Skate Park 7,868 100 Washington Avenue Dow Towers (76 Units) HRA 22 5th Avenue S. 118 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2013 UNIT # YEAR MAKE MODEL VALUE FIRE DEPARTMENT 100 2006 DODGE DURANGO $21,774 101 2003 CHEV IMPALA 24,890 102 1989 FORD L9000 TELE -SQUIRT 380,000 103 2006 PETERBILT 357 PUMPER 420,000 108 1995 CHEV 4X4 LITE RESCUE 36,000 109 2008 PIERCE AERO XT 874,560 110 2010 CHEVROLET TAHOE 30,000 115 1952 MACK PUMPER 4,000 HAZMAT 120 1995 CHEVROLET SUBURBAN 48,000 121 2005 FREIGHTLINER M2 309,900 122 2005 PACE AMERICAN TRAILER 40,100 POLICE DEPARTMENT 200 2010 FORD CROWN VICTORIA $29,815 201 2008 FORD CROWN VICTORIA 22,693 202 2011 FORD CROWN VICTORIA 22,375 203 2009 FORD CROWN VICTORIA 28,160 204 2007 FORD CROWN VICTORIA 23,000 205. 2011 FORD CROWN VICTORIA 23,080 207. 2010 FORD CROWN VICTORIA 29,815 209. 2011 FORD CROWN VICTORIA 23,080 211 2006 JEEP LIBERTY 17,580 212 2008 CHEV TAHOE 26,148 213 2010 CHEV IMPALA 23,624 214 2007 DODGE CHARGER 22,475 215 2009 CHEV IMPALA 23,962 216 2011 FORD TAURUS 23,500 217 2008 FORD TAURUS 22,000 219 2013 FORD TAURUS 23,866 220 2005 DODGE RAM 1500 29,733 240 1998 CHEV P40 VAN 12,000 241. 2001 CHRYSLER PT CRUISER 17,855 119 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2013 UNIT # YEAR MAKE MODEL VALUE STREET/TRAFFIC DIVISION 2004 FORD 302 2006 FORD F250 $21,015 304 2000 FORD F-450 34,000 305 1997 FORD 1/2 TON 17,300 307 2006 FORD F350-1 TON DUMP 17,693 308 2011 FORD F350 - 2X4 20,182 309 2012 FORD F450 72,000 311 2011 FREIGHTLINER M2 -106V 75,000 312 2005 FREIGHTLINER SGLAX DUMP 45,346 313 2001 FORD L7501 72,000 314 1998 FORD LT 8500 84,000 316 1995 FORD WATER TRK 80,000 320 1991 CATERPILLER LOADER 928E 138,300 321 2012 CATERPILLER 924K LOADER 172,000 322 2005 CATERPILLER LOADER 938G 186,200 324 2004 BOBCAT SKID LOADER 32,000 325 2011 JOHN DEERE SKID LOADER 33,000 326 1989 CATERPILLAR 140-G 82,000 327 2001 ELGIN PELICAN SE 105,000 330 1989 INGERSOL/RAND ROLLER DD -25 23,000 337 1994 CATERPILLAR BOX PAVER 18,000 342 1991 TARGET CONCRETE SAW 2,400 344 1996 SNOGO WK 800 58,000 349 1989 TRAIL -KING TK6V-1200 3,000 350 1993 TOWMASTER T14 4,000 351 2004 TENNANT SWEEPER 3640 10,000 ENGINEERING DIVISION 700 2000 CHEV SUBURBAN $14,500 705 2005 CHEV IMPALA 14,600 BUILDING MAINTENANCE & EQUIPMENT SERVICES 701 2006 FORD 500 SEDAN $20,800 702 2004 FORD F350 PICKUP 17,570 703 2002 CHEV TAHOE 18,000 704 2006 FORD F250 24,000 120 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2013 UNIT # YEAR MAKE MODEL VALUE PARKS/FORESTRY DIVISION 800 2001 FORD RANGER 4X4 $18,000 801 2012 FORD F350 $22,000 802 2012 FORD F-350 $20,000 803 2004 FORD F350 19,000 804 1996 CHEVROLET 3/4 TON 4x4 23,000 805 1998 DODGE RAM 3500 24,000 810 1993 INTERNATIONAL LP 4700 50,000 811 2006 INTERNATIONAL LP 4600 LOG TRUCK 45,000 812 2010 FREIGHTLINER AERIAL LIFT 130,000 815 2010 BOBCAT TOOLCAT 50,000 817 1982 FORD TRACTOR 2610 22,000 818 1996 TORO TRUCKSTER 13,000 820 2004 TORO WORKMAN 3200 15,000 821 2004 TORO WORKMAN 2110 7,900 822 2001 TORO 325-D MOWER 18,000 853 2006 JACOBSON MOWER 10,000 824 1996 TORO GROUND MASTER 16,000 825 2010 TORO 4100D MOWER 53,000 826 2004 TORO Z587L 8,900 828 2001 DEW EZE ATM72 21,000 832 1997 VERMEER STUMP CTR 630A 15,400 833 2004 BOBCAT SKID LOADER 22,000 834 1993 BRUSH BANDIT CHIPPER 250 14,000 836 RYAN SOD CUTTER 2,000 844 2010 FELLING TRAILER 4,000 845 1997 REMACKEL TRAILER 5,000 846 2001 DRESSEN 8110 2,000 847 2011 SPARKS TRAILER T6202 4,900 HRA 411 2007 CHEV 2500 HD $17,500 121 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY January 1, 2013 UNIT # YEAR MAKE MODEL VALUE WATER/SEWER 901. 2005 PETERBILT 500. 2007 CHEV PICKUP $22,000 501. 2004 CHEV 4X4 3/4 T SILVERADO 19,000 502. 1999 DODGE DAKOTA 4X4 18,000 505. 2007 CHEV CC25753 24,000 506. 2006 CHEV SILVERADO 20,700 530. 2001 STERLING VAC -CON 180,000 533. 2012 CATERPILLAR 420EH2 BACKHOE 85,000 534. 1997 KOHLER GENERATOR/TRL 11,000 535. 1992 KOHLER GENERATOR/TRL 10,000 536. 1989 FLEXIBLE RODDING MACHINE 25,000 537. 2010 GENERATOR C15 130,000 540. 2008 LEROI AIR COMPRESSOR 12,000 542. 1994 WACKER TAMPER 4,000 REFUSE 900. 2011 FREIGHTLINER 901. 2005 PETERBILT 903. 1995 FREIGHTLINER PAVILION 801. 1996 CHEV 809. 2003 OLYMPIA RAPID -RAIL M2 $201,000 320 162,000 FL -70 54,000 4X4 TRK $19,100 ICE RESURFACER 85,000 122