Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Memo- Second look at ERP for 2012-2016
CITY OF HOPKINS MEMORANDUM Date: June 28, 2011 To: Mayor & City Council From: Christine Harkess, Finance Director Subject: 2012-2016 Equipment Replacement Plan (ERP) FINANCE DEPARTMENT This second look at the ERP will focus on the next 5 years and includes the financing plan we discussed at the 6/21/11 work session. In the short-term this financing option is needed as a stop -gap measure to meet the equipment needs in this 5 -year plan. As was stated we didn't get into this funding situation overnight and it will take a while to pull out of it. Finding a solution will be a major focus for staff this year. In this work session we will look at the equipment needs for 2012-2016 and what has changed from the current plan. Those changes are summarized in this document. The cash flow for the next five years is shown with lease financing in 2012 and payments starting in 2013. Also two copiers were removed from the ERP and will be leased on a 5 year basis. Those lease payments will be shown in the respective departments within the General Fund. Also included is the chart/graph showing the history of the fund and where we're headed if serious changes are not made to the plan. This chart is based on the cash flow statement included in this packet. And finally included are details of the equipment planed for the next 5 eyars. Projects by year Projects by funding source Projects by department ERP — SUMMARY OF CHANGES IN 2012-2016 PLAN General 1. Incorporated rate increases for years 2012-2016 ERP Fund 1. Activity Center a. Copier due in 2013 for purchase was changed to a lease and will be budgeted in this department within the General Fund. 2. City Hall a. Network Core Switch was added in 2012 at a cost of $12,000. This item provides the backbone on which all network communication is built. The current device is obsolete and no longer supported by the manufacturer. 3. Community Services a. Engineering copier/scanner lease of $10,000 has been moved to the General Fund, Engineering Dept. b. Election equipment of $50,000 was added in 2013. Replace ballot scanners and ballot boxes — 9 machines total per Hennepin County replacement schedule. 4. Fire Dept a. 2012 — Quick Attack Pumper taken out of 5 -year CIP — cost of $234,000 b. 2012 — Workout dumbbells of $5,000 moved to 2014 5. Police a. 2012 — Mobile Data Cameras of $62,700 moved to 2013 b. 2013 — Added LOGIS Computer System of $200,000 c. 2014 — Digital Squad Car Cameras increased by $10,800 to $53,400 d. 2015 — Police Services Liaison vehicle increased cost by $3,000 to $25,000. 6. Public Works — Forestry a. 2012 — four items scheduled for 2012 were moved back to 2013 i. 1/2 ton pickup (previously moved from 2011 to 2012) ii. 3/4 ton utility truck (previously moved from 2011 to 2012) iii. Trucksteer iv. Riding lawn mower b. 2012 — added a Grass Seed Applicator - $7,400 c. 2013 — pushed back one riding lawn mower to 2014 7. Public Works — Streets/Traffic a. 2012 — One ton dump truck — cost increased by $7,500 to $82,500 b. 2012 — Asphalt Hot Mix Box added at a cost of $15,500 c. 2012 — Moved Roller from 2012 to 2014 — cost is $45,900 d. Tandem axel dump truck of $142,400 scheduled in 2013 was moved back and replaced with a single axel dump truck costing $127,400 and scheduled for 2012. Arts Center Fund 1. Carpet Extractor priced changed from $3,300 to $3,900 (2012 item) 2. Video Camera Updates — added in 2012 at a cost of $3,200 Pavilion Fund 1. No changes Parking_Fund 1. Added Mobile Data Computer in 2013 at a cost of $5,700. One computer to be put in parking officer's vehicle. Water/Sewer/Storm Sewer Funds 1. No changes Impact on General Fund Rate Change Working Capital Begin Year Revenues from charges Transfer In - Pavilion - Capital Lease Transfer In - Pavilion - Hockey Loan Interest earnings Other revenues (sale of assets) Lease Financing Total Revenues Expenditures (excludes Depr.) (1) Fire Truck Financing Pymnts (2009-2018) Finance 6 items - annual finance cost Eliminate 2 copiers in 2013 and lease Capital Outlay - Equipment Working Capital Ending Balance Cash balance EQUIPMENT REPLACEMENT FUND (602) 06/23/2011 14,591 18,830 23,288 24,916 26,662 2% 3% 5% 6% 7% 7% 7% ACTUAL BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 2010 2011 2012 2013 2014 2015 2016 1,161,011 921,830 919,117 1,110,595 505,553 305,089 156,044 292,867 301,653 316,736 335,740 359,242 384,388 411,296 20,000 20,000 20,000 15,609 3,143 3,143 3,143 3,143 3,142 6,719 9,293 9,266 11,180 5,130 3,125 1,635 13,760 25,000 25,000 25,000 30,000 30,000 30,000 600,000 336,489 359,089 974,144 390,672 397,514 417,514 442,931 24,743 25,485 18,250 18,798 19,361 19,942 20,541 53,891 54,217 54,217 54,217 54,217 54,217 54,217 77,000 77,000 77,000 77,000 (35,000) 497,036 282,100 710,200 880,700 447,400 415,400 415,200 575,670 361,802 782,667 995,714 597,978 566,559 566,957 921,830 919,117 1,110,595 505,553 305,089 156,044 32,018 929,273 926,560 1,118,038 512,996 312,532 163,487 39,461 (1) Expenditures included copier and engineering scanner lease up until 2011. Beginning in 2011 for the copiers and 2012 for the scanners the responsible fund pays the lease .CL m U c L O Qi CL X W N� I.L 1 a w LU N 0 N 0 0 0 0 0 I 0 0 0 0 0 0 0 0 0 0 0 C C 0 0 0 0 C 0 0 0 0 0 0 0 0 0 0 0LQ 0 00 0 0) o oD 0 N N - r Tom! City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2012 thru 2016 PROJECTS BY YEAR Project Name Department Project # Priority Project Cost 2012 NEENEENNEMM AR Center Carpet Extractor Arts Center 01 -ERP -1101 n/a 3,900 Art Center Video Camera Updates Arts Center 01 -ERP -1103 n/a 3,200 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 Core Network Switch City Hall Administration 01 -ERP -0012 n/a 10,000 City Hall Main Copy Machine - Konica Copier Community Services 01 -ERP -0001 n/a 0 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Extrication Tool (2) Fire 01 -ERP -0109 n/a 22,300 Workout Equipment - Treadmill Fire 01 -ERP -0118 n/a 5,000 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 69,200 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 28,800 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 911 Phone System (Viper Phone) Police 01 -ERP -0216 n/a 0 Engineering Printer/Scanner Public Works: Engineering 01 -ERP -0701 n/a 0 44 3/4Ton Trucks (2) Public Works: Parks/Forestry 01 -ERP -0801 n/a 67,400 Grass Seed Applicator (Overseeder) Public Works: Parks/Forestry 01 -ERP -0817 n/a 7,400 1 Ton Dump Truck (2) Public Works: Streets/Traffic 01 -ERP -0303 n/a 34,700 1 Ton Traffic Boom Truck Public Works: Streets/Traffic 01 -ERP -0304 n/a 82,500 Single Axle Dump Truck (3) Public Works: Streets/Traffic 01 -ERP -0305 n/a 127,400 Front End Loaders (2) Public Works: Streets/Traffic 01 -ERP -0308 n/a 172,000 Asphalt Hot Mix Heating Box Public Works: Streets/Traffic 01 -ERP -0318 n/a 15,500 Total for 2012 771,517 2013 Activity Center Copy Machine Activity Center 01 -ERP -0030 n/a 0 Art Center Kitchen Catering Equipment Arts Center 01 -ERP -1102 n/a 5,000 Network Server City Hall Administration 01 -ERP -0003 nla 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 City Hall Main Copy Machine - Konica Copier Community Services 01 -ERP -0001 n/a 0 City Hall Small Copy Machine - Ricoh Copier Community Services 01 -ERP -0002 n/a 0 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Election Equipment Community Services 01 -ERP -0011 n/a 50,000 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Thermal Imaging Camera (2) Fire 01 -ERP -0112 n/a 11,500 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 71,200 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 29,600 RMS/CAD/Mobile Computer System Police 01 -ERP -0208 n/a 200,000 Network Server (3) Police 01 -ERP -0211 nla 8,500 Mobile Data Computers Police 01 -ERP -0212 n/a 62,700 Tactical Ballistic Vests Police 01 -ERP -0214 n/a 23,200 Radios - Portable and Mobile Devices Police 01 -ERP -0215 nla 15,000 Engineering Van Public Works: Engineering 01 -ERP -0700 n/a 21,500 Thursday, June 23, 2011 Project Name Department Project # Priority Project Cost Engineering Printer/Scanner Public Works: Engineering 01 -ERP -0701 nla 0 1/2 Ton Pickup Truck Public Works: Parks/Forestry 01 -ERP -0800 n/a 26,400 314 Ton Utility Truck Public Works: Parks/Forestry 01 -ERP -0802 n/a 32,200 Trucksters (3) Public Works: Parks/Forestry 01 -ERP -0807 n/a 19,800 Riding Mowers (3) Public Works: Parks/Forestry 01 -ERP -0808 n/a 22,800 Brush Chipper Public Works: Parks/Forestry 01 -ERP -0813 n/a 25,700 4X4 3/4 Ton Truck with Plow Public Works: Streets/Traffic 01 -ERP -0301 n/a 30,400 Sweeper Public Works: Streets/Traffic 01 -ERP -0311 n/a 156,400 Backhoe Loader Water 01 -ERP -0502 n/a 134,800 2015 Network Server Total for 2013 01 -ERP -0003 n/a 1,045,417 2014 City Hall Administration 01 -ERP -0004 n/a 89,600 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 City Hall Main Copy Machine - Konica Copier Community Services 01 -ERP -0001 n/a 0 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Automated External Defibrillator (2) Fire 01 -ERP -0120 n/a 7,200 Workout Equipment - Dumb Bells Fire 01 -ERP -0122 n/a 5,000 HRA Copier HRA 01 -ERP -0401 n/a 13,000 Ice Resurfacer Pavilion 01 -ERP -1000 n/a 180,000 Electric Ice Edger Pavilion 01 -ERP -1001 n/a 5,000 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 73,400 Utility 44 (unit 212) Police 01 -ERP -0203 n/a 47,700 Police Administrative Vehicles (2) Police 01 -ERP -0204 nla 30,500 Logging Recorder Police 01 -ERP -0210 n/a 36,900 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Digital Squad Car Cameras Police 01 -ERP -0213 n/a 53,400 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 Engineering Printer/Scanner Public Works: Engineering 01 -ERP -0701 n/a 0 Riding Mowers (3) Public Works: Parks/Forestry 01 -ERP -0808 n/a 30,600 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 Refuse Truck (Rear -L) Refuse 01 -ERP -0901 n/a 101,600 44 3/4 Ton Truck Sewer 01 -ERP -0550 n/a 35,700 Total for 2014 836,917 2015 Network Server City Hall Administration 01 -ERP -0003 n/a 8,000 Telephone System City Hall Administration 01 -ERP -0004 n/a 89,600 Computers City Hall Administration 01 -ERP -0006 n/a 30,000 City Hall Main Copy Machine - Konica Copier Community Services 01 -ERP -0001 n/a 0 Document Management Scanner (3) Community Services 01 -ERP -0008 n/a 6,500 Duty Chief Vehicle Fire 01 -ERP -0103 n/a 37,000 Aerial Truck Fire 01 -ERP -0106 n/a 54,217 Workout Equipment - Eliptical Fire 01 -ERP -0116 n/a 5,800 Workout Equipment - Summit Trainer Fire 01 -ERP -0117 n/a 5,800 Workout Equipment - Weight Lifting Fire 01 -ERP -0119 n/a 5,800 44 3/4 Ton Truck HRA 01 -ERP -0400 n/a 32,400 Marked Patrol Vehicles (6) Police 01 -ERP -0200 n/a 75,600 Sergeants Vehicle Police 01 -ERP -0201 n/a 37,800 Police Administrative Vehicles (2) Police 01 -ERP -0204 n/a 31,400 Police Services Liaison Vehicle Police 01 -ERP -0206 n/a 25,000 Network Server (3) Police 01 -ERP -0211 n/a 8,500 Radios - Portable and Mobile Devices Police 01 -ERP -0215 n/a 15,000 Thursday, June 23, 2011 Project Name Department Project # Priority Project Cost Engineering Printer/Scanner Public Works: Engineering 01 -ERP -0701 n/a 0 44 3/4 Ton Pickup with Plow Public Works: Streets/Traffic 01 -ERP -0300 n/a 33,600 Sign Machine (Traffic) Public Works: Streets/Traffic 01 -ERP -0317 n/a 13,400 Refuse Truck (RAP -R) (2) Refuse 01 -ERP -0900 n/a 204,800 Public Works Copy Machine Water 01 -ERP -0506 n/a 14,200 nla Total for 2015 Fire 01 -ERP -0115 734,417 2016 Refrigerator/Freezer Network Server Computers City Hall Main Copy Machine - Konica Copier Document Management Scanner (3) Fire Utility Vehicle (Pick Up Truck) Aerial Truck Floor Scrubber Floor Sweeper Marked Patrol Vehicles (6) Parking Enforcement Vehicle (Parking Fund) Police Administrative Vehicles (2) H.E.A.T. Vehicle Copy Machine - Police Dept Network Server (3) Radios - Portable and Mobile Devices Engineering Printer/Scanner Tractor Slope Mower Skid Loader (2) Snow Blower 314 Ton Utility Truck GRAND TOTAL Activity Center 01 -ERP -0031 n/a 1 City Hall Administration 01 -ERP -0003 n/a 8,000 City Hall Administration 01 -ERP -0006 n/a 30,000 Community Services 01 -ERP -0001 n/a 0 Community Services 01 -ERP -0008 n/a 6,500 Fire 01 -ERP -0105a n/a 35,000 Fire 01 -ERP -0106 n/a 54,217 Fire 01 -ERP -0114 nla 10,400 Fire 01 -ERP -0115 n/a 3,900 Police 01 -ERP -0200 n/a 77,800 Police 01 -ERP -0202 nla 27,200 Police 01 -ERP -0204 n/a 32,400 Police 01 -ERP -0205 n/a 30,000 Police 01 -ERP -0209 n/a 22,100 Police 01 -ERP -0211 n/a 8,500 Police 01 -ERP -0215 n/a 15,000 Public Works: Engineering 01 -ERP -0701 nla 0 Public Works: Parks/Forestry 01 -ERP -0806 n/a 49,300 Public Works: Parks/Forestry 01 -ERP -0809 n/a 32,700 Public Works: Streets/Traffic 01 -ERP -0309 nla 41,900 Public Works: Streets/Traffic 01 -ERP -0315 n/a 102,300 Sewer 01 -ERP -0551 n/a 33,600 Total for 2016 620,818 4,009,086 Thursday, June 23, 2011 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2012 thru 2016 FUNDING SOURCE SUMMARY Source 2012 2013 2014 AC - Arts Center Fund Bonds/Lease Equipment Replacement Fund HRA - Housing and Redevelopment Authority PA - Pavilion Fund PKG - Parking Fund RF - Refuse Fund SF - Sanitary Sewer Fund WF - Water Fund GRAND TOTAL 2015 2016 Total 7,100 5,000 12,100 54,217 54,217 54,217 54,217 54,217 271,085 710,200 845,700 447,400 415,200 533,001 21951,501 13,000 32,400 45,400 185,000 185,000 5,700 5,700 101,600 204,800 306,400 35,700 6,800 33,600 76,100 134,800 21,000 155,800 771,517 1,045,417 836,917 734,417 620,818 4,009,086 Thursday, June 23, 2011 City of Hopkins, N N EQUIPMENT REPLACEMENT PLAN 2012 thru 2016 PROJECTS BY FUNDING SOURCE Source Project# Priority 2012 2013 2014 2015 2016 Total AC - Arts Center Fund AR Center Carpet Extractor 01 -ERP -1101 n/a 3,900 0 3,900 Art Center Kitchen Catering Equipment 01 -ERP -1102 nla City Hall Small Copy Machine - Ricoh Copier 5,000 5,000 Art Center Video Camera Updates 01 -ERP -1103 n/a 3,200 3,200 AC - Arts Center Fund Total 01 -ERP -0003 n/a 7,100 5,000 12,100 Bonds/Lease 8,000 40,000 Telephone System 01 -ERP -0004 n/a Aerial Truck 01 -ERP -0106 n/a 54,217 54,217 54,217 54,217 54,217 271,085 Bonds/Lease Total 01 -ERP -0006 n/a 54,217 54,217 54,217 54,217 54,217 171,085 Eauinment Replacement Fund City Hall Main Copy Machine - Konica Copier 01 -ERP -0001 n/a 0 0 0 0 0 0 City Hall Small Copy Machine - Ricoh Copier 01 -ERP -0002 n/a 0 0 Network Server 01 -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01 -ERP -0004 n/a 76,000 76,000 Computers 01 -ERP -0006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 Document Management Scanner (3) 01 -ERP -0008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 Election Equipment 01 -ERP -0011 n/a 50,000 50,000 Core Network Switch 01 -ERP -0012 n/a 10,000 10,000 Activity Center Copy Machine 01 -ERP -0030 n/a 0 0 Refrigerator/Freezer 01 -ERP -0031 n/a 1 1 Duty Chief Vehicle 01 -ERP -0103 n/a 37,000 37,000 Fire Utility Vehicle (Pick Up Truck) 01 -ERP -0105a n/a 35,000 35,000 Extrication Tool (2) 01 -ERP -0109 n/a 22,300 22,300 Thermal Imaging Camera (2) 01 -ERP -0112 n/a 11,500 11,500 Floor Scrubber 01 -ERP -0114 n/a 10,400 10,400 Floor Sweeper 01 -ERP -0115 n/a 3,900 3,900 Workout Equipment - Eliptical 01 -ERP -0116 n/a 5,800 5,800 Workout Equipment - SummitTrainer 01 -ERP -0117 n/a 5,800 5,800 Workout Equipment - Treadmill 01 -ERP -0118 n/a 5,000 5,000 Workout Equipment - Weight Lifting 01 -ERP -0119 n/a 5,800 5,800 Automated External Defibrillator (2) 01 -ERP -0120 n/a 7,200 7,200 Workout Equipment- Dumb Bells 01 -ERP -0122 n/a 5,000 5,000 Marked Patrol Vehicles (6) 01 -ERP -0200 n/a 69,200 71,200 73,400 75,600 77,800 367,200 Sergeants Vehicle 01 -ERP -0201 n/a 37,800 37,800 Parking Enforcement Vehicle (Parking Fund) 01 -ERP -0202 n/a 27,200 27,200 Utility 4x4 (unit 212) 01 -ERP -0203 n/a 47,700 47,700 Police Administrative Vehicles (2) 01 -ERP -0204 n/a 28,800 29,600 30,500 31,400 32,400 152,700 H.E.A.T. Vehicle 01 -ERP -0205 n/a 30,000 30,000 Police Services Liaison Vehicle 01 -ERP -0206 nla 25,000 25,000 RMS/CAD/Mobile Computer System 01 -ERP -0208 n/a 200,000 200,000 Copy Machine - Police Dept 01 -ERP -0209 n/a 22,100 22,100 Thursday, June 23, 2011 Source Project# Priority 2012 2013 2014 2015 2016 Total Logging Recorder 01 -ERP -0210 n/a 36,900 36,900 Network Server (3) 01 -ERP -0211 n/a 8,500 8,500 8,500 8,500 8,500 42,500 Mobile Data Computers 01 -ERP -0212 n/a 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 23,200 23,200 Radios - Portable and Mobile Devices 01 -ERP -0215 n/a 15,000 15,000 15,000 15,000 15,000 75,000 911 Phone System (Viper Phone) 01 -ERP -0216 n/a 0 0 44 3/4 Ton Pickup with Plow 01 -ERP -0300 n/a 33,600 33,600 4X4 3/4 Ton Truck with Plow 01 -ERP -0301 n/a 30,400 30,400 1 Ton Dump Truck (2) 01 -ERP -0303 n/a 34,700 34,700 1 Ton Traffic Boom Truck 01 -ERP -0304 n/a 82,500 82,500 Single Axle Dump Truck (3) 01 -ERP -0305 n/a 127,400 127,400 Front End Loaders (2) 01 -ERP -0308 n/a 172,000 172,000 Skid Loader (2) 01 -ERP -0309 n/a 41,900 41,900 Sweeper 01 -ERP -0311 n/a 156,400 156,400 Roller 01 -ERP -0312 n/a 45,900 45,900 Asphalt Paver 01 -ERP -0314 n/a 48,800 48,800 Snow Blower 01 -ERP -0315 n/a 102,300 102,300 Sign Machine (Traffic) 01 -ERP -0317 n/a 13,400 13,400 Asphalt Hot Ma Heating Box 01 -ERP -0318 n/a 15,500 15,500 Engineering Van 01 -ERP -0700 n/a 21,500 21,500 Engineering Printer/Scanner 01 -ERP -0701 n/a 0 0 0 0 0 0 1/2 Ton Pickup Truck 01 -ERP -0600 n/a 26,400 26,400 44 3/4Ton Trucks (2) 01 -ERP -0801 n/a 67,400 67,400 3/4 Ton Utility Truck 01 -ERP -0802 n/a 32,200 32,200 Tractor 01 -ERP -0806 n/a 49,300 49,300 Trucksters (3) 01 -ERP -0807 We 19,800 19,800 Riding Mowers (3) 01 -ERP -0808 n/a 22,800 30,600 53,400 Slope Mower 01 -ERP -0809 n/a 32,700 32,700 Brush Chipper 01 -ERP -0813 n/a 25,700 25,700 Grass Seed Applicator (Overseeder) 01 -ERP -0817 n/a 7,400 7,400 Equipment Replacement Fund Total 710,200 845,700 447,400 415,200 533,001 2951,501 HRA - Housing and Redevelopment A 4x4 3/4 Ton Truck 01 -ERP -0400 n/a 32,400 32,400 HRA Copier 01 -ERP -0401 n/a 13,000 13,000 HRA - Housing and Redevelopment 13,000 32,400 45,400 Authority Total PA - Pavilion Fund Ice Resurfacer 01 -ERP -1000 n/a 180,000 180,000 Electric Ice Edger 01 -ERP -1001 n/a 5,000 5,000 PA - Pavilion Fund Total 185,000 185,000 PKG - Parking Fund Mobile Data Computers 01 -ERP -0212 n/a 5,700 5,700 PKG - Parking Fund Total 5,700 5,700 RF - Refuse Fund Thursday, June 23, 2011 Source Project# Priority 2012 2013 2014 2015 2016 Total Refuse Truck (RAP -R) (2) 01 -ERP -0900 n/a Refuse Truck (Rear -L) 01 -ERP -0901 n/a RF - Refuse Fund Total 204,800 306,400 6,800 6,800 SF - Sanitary Sewer Fund Telephone System 01 -ERP -0004 n/a 44 3/4 Ton Truck 01 -ERP -0550 n/a 3/4 Ton Utility Truck 01 -ERP -0551 n/a SF - Sanitary Sewer Fund Total 6,800 134,800 134,800 WF - Water Fund Telephone System 01 -ERP -0004 n/a Backhoe Loader 01 -ERP -0502 n/a Public Works Copy Machine 01 -ERP -0506 n/a WF - Water Fund Total GRAND TOTAL Thursday, June 23, 2011 204,800 204,800 101,600 101,600 101,600 204,800 306,400 6,800 6,800 35,700 35,700 33,600 33,600 35,700 600 33,600 76,100 6,800 6,800 134,800 134,800 14,200 14,200 134,800 21,000 155,800 771,517 1,045,417 836,917 734,417 620,818 4,009,086 Thursday, June 23, 2011 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2012 thru 2016 DEPARTMENT SUMMARY Department 2012 2013 2014 2015 2016 Total Activity Center 0 1 1 Arts Center 7,100 5,000 12,100 City Hall Administration 48,000 38,000 38,000 127,600 38,000 289,600 Community Services 6,500 56,500 6,500 6,500 6,500 82,500 Fire 81,517 65,717 66,417 108,617 103,517 425,785 HRA 13,000 32,400 45,400 Pavilion 185,000 185,000 Police 121,500 410,200 265,400 193,300 213,000 1,203,400 Public Works: Engineering 0 21,500 0 0 0 21,500 Public Works: Parks/Forestry 74,800 126,900 30,600 82,000 314,300 Public Works: Streets/Traffic 432,100 186,800 94,700 47,000 144,200 904,800 Refuse 101,600 204,800 306,400 Sewer 35,700 33,600 69,300 Water 134,800 14,200 149,000 TOTAL 771,517 1,045,417 836,917 734,417 620,818 4,009,086 Thursday, June 23, 2011 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2012 thru 2016 PROJECTS BY DEPARTMENT Department Project# Priority 2012 2013 2014 2015 2016 Total (Activity Center Activity Center Copy Machine 01 -ERP -0030 n/a 0 0 Refrigerator/Freezer 01 -ERP -0031 n/a 1 1 Activity Center Total 0 1 1 Arts Center Art Center Carpet Extractor 01 -ERP -1101 n/a 3,900 3,900 Art Center Kitchen Catering Equipment 01 -ERP -1102 n/a 5,000 5,000 Art Center Video Camera Updates 01 -ERP -1103 n/a 3,200 3,200 Arts Center Total 7,100 5,000 12,100 City Hall Administration Network Server 01 -ERP -0003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01 -ERP -0004 nla 89,600 89,600 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 10,000 10,000 City Hall Administration Total 48,000 38,000 38,000 127,600 38,000 289,600 �ommunity Services City Hall Main Copy Machine - Konica Copier 01 -ERP -0001 n/a 0 0 0 0 0 0 City Hall Small Copy Machine - Ricoh Copier 01 -ERP -0002 n/a 0 0 Document Management Scanner (3) Of -ERP -0008 n/a 6,500 6,500 6,500 6,500 6,500 32,500 Election Equipment 01 -ERP -0011 n/a 50,000 50,000 Community Services Total 6,500 56,500 6,500 6,500 6,500 82,500 Fire Duty Chief Vehicle 01 -ERP -0103 n/a 37,000 37,000 Fire Utility Vehicle (Pick Up Truck) 01 -ERP -0105a n/a 35,000 35,000 Aerial Truck 01 -ERP -0106 n/a 54,217 54,217 54,217 54,217 54,217 271,085 Extrication Tool (2) 01 -ERP -0109 n/a 22,300 22,300 Thermal Imaging Camera (2) 01 -ERP -0112 n/a 11,500 11,500 Floor Scrubber 01 -ERP -0114 n/a 10,400 10,400 Floor Sweeper 01 -ERP -0115 n/a 3,900 3,900 Workout Equipment - Eliptical 01 -ERP -0116 n/a 5,800 5,800 Workout Equipment - SummitTrainer 01 -ERP -0117 n/a 5,800 5,800 Workout Equipment - Treadmill 01 -ERP -0118 n/a 5,000 5,000 Workout Equipment - WeightLifting 01 -ERP -0119 n/a 5,800 5,800 Automated External Defibrillator (2) 01 -ERP -0120 n/a 7,200 7,200 Workout Equipment - Dumb Bells 01 -ERP -0122 n/a 5,000 5,000 Fire Total 81,517 65,717 66,417 108,617 103,517 425,785 Thursday, June 23, 2011 Department Project# PrioritN, 2012 2013 2014 2015 2016 Total HRA 44 314 Ton Truck 01 -ERP -0400 n/a 32.400 32,400 HRA Copier 01 -ERP -0401 n/a 13,000 13,000 HRA Total 13,000 32,400 45,400 Pavilion Ice Resurfacer 01 -ERP -1000 n/a 180,000 180,000 Electric Ice Edger 01 -ERP -1001 n/a 5,000 5,000 Pavilion Total 185,000 185,000 Police Marked Patrol Vehicles (6) 01 -ERP -0200 n/a 69,200 71,200 73,400 75,600 77,800 367,200 Sergeants Vehicle 01 -ERP -0201 nla 37,800 37,800 Parking Enforcement Vehicle (Parking Fund) 01 -ERP -0202 n/a 27,200 27,200 Utility 44 (unit 212) 01 -ERP -0203 n/a 47,700 47,700 Police Administrative Vehicles (2) 01 -ERP -0204 n/a 28,800 29,600 30,500 31,400 32,400 152,700 H.E.A.T. Vehicle 01 -ERP -0205 n/a 30,000 30,000 Police Services Liaison Vehicle 01 -ERP -0206 n/a 25,000 25,000 RMS/CAD/Mobile Computer System 01 -ERP -0208 n/a 200,000 200,000 Copy Machine -Police Dept 01 -ERP -0209 n/a 22,100 22,100 Logging Recorder 01 -ERP -0210 n/a 36,900 36,900 Network Server (3) 01 -ERP -0211 n/a 8,500 8,500 8,500 8,500 8,500 42,500 Mobile Data Computers 01 -ERP -0212 n/a 62,700 62,700 Digital Squad Car Cameras 01 -ERP -0213 n/a 53,400 53,400 Tactical Ballistic Vests 01 -ERP -0214 n/a 23,200 23,200 Radios - Portable and Mobile Devices 01 -ERP -0215 n/a 15,000 15,000 15,000 15,000 15,000 75,000 911 Phone System (Viper Phone) 01 -ERP -0216 n/a 0 0 Police Total 121,500 410,200 265,400 193,300 213,000 1,203,400 Public Works: Engineering Engineering Van 01 -ERP -0700 n/a 21,500 21,500 Engineering Printer/Scanner 01 -ERP -0701 n/a 0 0 0 0 0 0 Public Works: Engineering Total 0 21,500 0 0 0 21,500 (Public Works: Parks/Forestry 112 Ton Pickup Truck 01 -ERP -0800 n/a 26,400 26,400 44 314Ton Trucks (2) 01 -ERP -0801 n/a 67,400 67,400 3/4 Ton Utility Truck 01 -ERP -0802 n/a 32,200 32,200 Tractor 01 -ERP -0806 n/a 49,300 49,300 Trucksters (3) 01 -ERP -0807 n/a 19,800 19,800 Riding Mowers (3) 01 -ERP -0808 n/a 22,800 30,600 53,400 Slope Mower 01 -ERP -0809 n/a 32,700 32,700 Brush Chipper 01 -ERP -0813 n/a 25,700 25,700 Grass Seed Applicator (Overseeder) 01 -ERP -0817 n/a 7,400 7,400 Public Works: Parks/Forestry Total 74,800 126,900 30,600 82,000 314,300 Public Works: Streets/Traffic 44 3/4 Ton Pickup with Plow 01 -ERP -0300 n/a 33,600 33,600 4X4 3/4 Ton Truck with Plow 01 -ERP -0301 n/a 30,400 30,400 Thursday, June 23, 2011 Department Project# Priority 2012 2013 2014 2015 2016 Total 1 Ton Dump Truck (2) 01 -ERP -0303 n/a 34,700 34,700 1 Ton Traffic Boom Truck 01 -ERP -0304 n/a 82,500 82,500 Single Axle Dump Truck (3) 01 -ERP -0305 n/a 127,400 127,400 Front End Loaders (2) 01 -ERP -0308 n/a 172,000 172,000 Skid Loader (2) 01 -ERP -0309 n/a 41,900 41,900 Sweeper 01 -ERP -0311 n/a 156,400 156,400 Roller 01 -ERP -0312 n/a 45,900 45,900 Asphalt Paver 01 -ERP -0314 n/a 48,800 48,800 Snow Blower 01 -ERP -0315 n/a 102,300 102,300 Sign Machine (Traffic) 01 -ERP -0317 n/a 13,400 13,400 Asphalt Hot Mix Heating Box 01 -ERP -0318 n/a 15,500 15,500 Public Works: Streets/Traffic Total 432,100 186,800 94,700 47,000 144,200 904,800 Refuse Refuse Truck (RAP -R) (2) 01 -ERP -0900 n/a 204,800 204,800 Refuse Truck (Rear -L) 01 -ERP -0901 n/a 101,600 101,600 Refuse Total 101,600 204,800 306,400 Sewer 44 3/4 Ton Truck 01 -ERP -0550 n/a 35,700 35,700 3/4 Ton Utility Truck 01 -ERP -0551 n/a 33,600 33,600 Sewer Total 35,700 33,600 69,300 Water Backhoe Loader 01 -ERP -0502 n/a 134,800 134,800 Public Works Copy Machine 01 -ERP -0506 n/a 14,200 14,200 Water Total 134,800 14,200 149,000 GRAND TOTAL 771,517 1,045,417 836,917 734,417 620,818 4,009,086 Thursday. June 23, 2011