The URL can be used to link to this page

2005 - 2009 ERP t l -~...--,--------._._- -- ...---------- - --.---.-..-:............. ///// C\TY Op "~~ // /---------.~'''" ~\ / / ~~ \ f / \ \ { ( \ \ I I I I \ \ I I \ \ / / \ ~ / / ~ "~~------- ---/--/// / ~"____ IiOPKINS //'// -~-...--...-..._._--_...._..._-_._----...-----.....,- Equipment Replacement Plan 2005 - 2009 (lmI~~ ~.....,..".:".",.,'...,....,'....... i..,......,....'.,.:...:..........,....:.,....."......'. " ""q?,,~~ ~'i$\~ EQUIPMENT REPLACEMENT PLAN 2005 - 2024 Background The Equiplnent Replacement Plan is a twenty-year forecast of equipment needs in the City of Hopkins. It is intended to inform the Council and citizens to the major equipment needs on the horizon. The first year of the plan becomes an adopted equipn1ent budget and relates almost completely to the operating budget of the equiplnent replacelnent fund, which is approved on an annual basis. The ren1aining nineteen years represent an estilnate of equipment needs and funding capabilities of the City. Funding requirements vary from year to year. In order to n1aintain a fairly consistent levy each year, the twenty-year schedule is projected with a 3% inflation factor and a yearly average dollar need for the equipment replacement fund is presently $630,500. The cash flow requirelnents to fund the equipment needs in the equipn1ent replacen1ent fund, will experience a roller coaster effect over the next 20 years given the projected equipment needs and 30/0 inflation rate. Available funds will remain about the san1e through the year 2013 and then the fund will experience a substantial increase in funds available thru 2017 in preparation for replacement of SOlne lnajor fire equipment in 2018, 2019 and 2020. It is anticipated that the intragovernmental charge to the general fund will need to increase incrementally by 20/0 each year until 2009. The charges will continue to increase each year after that, but at a slower pace. The future increases in charges to the general fund should provide sufficient funds to carry us through 2024. A goal of the city this year was to reevaluate the n1ajor adjustn1ents lnade in 2004 and adjust the schedule accordingly. Changes to the plan are reflected in the dOCUlnent. The success of the adjustn1ents made in 2004 can be witnessed with no needed changes to the planned funding sources. Refurbishlnents, extended life expectancy and closer cost estimates of replacements have accon1plished the goal of reducing future replacement costs. The charges to the general fund for equiplnent replacen1ent will be increased by $10,280 in 2005. This represents a scheduled increase of 40/0 over the current rates. The equipn1ent replacement charges in the general fund represent only 30/0 of total general fund expenditures. Future increases incrementally of 2% every year are needed to fund the equipn1ent replacen1ent plan without issuing debt. The Equiplnent Replacement Plan's basic pren1ise is scheduled replacelnent of present equipment. A new item must, in the year proposed, be presented in the annual operating budget with a stipulation that replacelnent will be necessary in the future. Flexibility of the Equipment Replacement Plan is established through annual review and revision, if necessary. Highlights of changes fron1 last year: Fire: The Luverne pumper has been moved up from 2007 to 2005. It had been lnoved back in 2004 but is in need of major repairs so replacement is necessary . The Duty Chief vehicle has been moved back from 2005 to 2006. The Stuphen aerial truck refurbishment has been n10ved back frOln 2006 to 2007. Police: The K-9 marked patrol vehicle has been transferred to marked patrol vehicles since the K-9 progran1 has been eliminated. It will be used by the power shift officers. This is an overlap shift that provides additional coverage during peak call times. It was scheduled for replacement in 2005 but has been moved back one year to 2006. This vehicle is on a four-year replacement schedule. City Hall: The main copy machine costs have been reduced due to the lease changes. Finance cOlnputer system software has been lnoved up to 2007 for an upgrade only to Invision/Tyler Technologies software. This will move full replacement back until 2014. Public Works: Activity Center has added their refrigerator/freezer for replacen1ent In 2006. The cost is $6,500. The skid loader replacelnent has been extended from 2008 to 2010 and the cost decreased for a $12,000 savings. Cost has been reduced due to cooperative bidding by the State. An additional skid loader will be purchased in 2004 and will become an iten1 in the ERP for replacen1ent in 2016. This skid loader will be a smaller machine than the other one. The Parks Dept. trailer has been n10ved up fron1 2006 to 2005. The cost of the trailer is $1,400. The stun1p cutter replacement has been extended from 2007 to 2012 and its useful life froln 15 to 20 years. The front end loader replacement cost has been increased $20,000 to reflect actual cost. The Yz ton pickup for the Street Dept. has been changed to a % ton 4x4 with a plow. The actual cost has been increased by $5,800 to reflect this upgrade. The % ton truck for the Street Dept. has been upgraded to a 4x4 with a plow. However, the cost will be lessened by $3,200 to reflect actual cost. The Sewer utility truck has been upgraded to a 3;4 ton truck. This will cost an additional $3,200 in 2006. The Sewer % ton utility truck replacen1ent in 2007 cost has been decreased by $5,100 to reflect actual cost. The two Sewer utility trucks have been con1bined on one worksheet. EQUIPMENT REPLACEMENT PLAN 2005 - 2009 TABLE OF CONTENTS SECTION I Capital Equipment Five Year Funding Summary Sources of Revenue Summary Projects by Funding Source Department Summary Projects by Department A B B-1 thru B-2 C C-l thru C-3 Item Requests/Justification Twenty Year Equipment Replacement Schedule D SECTION II Equipment and Building Inventory Vehicle/Equipment Inventory Building Inventory I - V VI - VIII CAPITAL EQUIPMENT "<:j- r-- 0 0 \0 0 ("r") 00 0 00 00 r-- "<:j- VI 0 0 VI 0 - r-- 0 r-- r-- "<:j- 0\ 00 o~ o~ O\~ 0 00 0 o~ 0 00 r-- 0 M \D 0 VI M VI 0' v:i r--~ v:i N 0 00 r-- N - VI N 0\ VI \D 0 N N ("r") "<:j- VI VI 0 0 0 ("r") 0 N 0 0 0 "<:j- ("r") 0 00 0 0 r-- 0 VI 0 "<:j- 00 ~ "<:j- 0 O~ '<:j""~ 0 O\~ \D VI 0 0 v:i O~ VI 00 VI '<:j"" VI r-- M ("r") ~ 0 \D ("r") N - "<:j- N "<:j- 0 N 00 0\ N O~ M "<:j- M ("r") - 0 0 "<:j- 0 VI VI 0 VI 0 00 r-- 0\ 0\ 0 0 r-- 0 \D VI 0 VI 0 r-- N O\~ 00 0 O~ <'t 0 - r-- 00 ~ 0 ~ 0' 0 VI VI 0 VI VI VI VI VI r-- 0\ N 0 - "<:j- N 0 "<:j- VI \D r-- \D ("r") - VI VI VI O~ O~ 0\ 0\ N 0 0 "<:j- 0 \D "<:j- 0 "<:j- 0 00 ("r") 0 ("r") 0 \D VI \D 0\ \D \D 0\ N~ O~ 00 0 0 r-- ~ 0 O\~ 00 0 ~ r--: v:i ~ 0' 0 ("r") 0 VI VI VI N r-- 00 "<:j- N N r-- N "<:j- M \D N ("r") \D N N "<:j- N - Q M - ;Z 0\ 0 0 0 ("r") 0 M ("r") 0 M 0\ 00 N 0\ 0 0 0 0 0 0 00 VI ~ VI - N O~ '<:j""~ 0 \D 0 00 00 0\ 00 V ~ 0 ~ r--: N ~ 0:: u 0 0 N VI If) r- ~ N "<:j- \D \D "<:j- N 0\ "<:j- VI r-- 0\ ~ 0 N M r-- r-- \D \D ;Z ro ~ CO :; ,S ~ VI 0 0 0 0"- 0 0\ VI 0 VI 0\ 00 0.. U r-- N 0 0 0 N 0 0 0 0\ \D ro < "<:j- r-- 0\ 0 \0 0 VI \0 VI 0 U ..J 0 r--:' v:i N \!:i VI 0' ("r") 0' ~ ~ 0' ~I) Q.. 0 M VI \D -:::t - 00 \D r--. '<:j"" \D N VI N ("r") 00 00 O~ 0 ~ ~ cG (3 ~ ~ Z ~ VI \D 0 r--. VI 00 00 VI VI M VI '<:j"" :; r--. M VI M N \D '<:j"" - - r-- "<:j- ("r") O\~ '<:j""~ ("r") 0\ r-- - N 0\ r--. \D ~ 0 O\~ ~ "<:j-~ ~ O\~ ~ 00 r-- M - 0 0 VI N 00 00 "<:j- 0\ M VI ~ N 0 N N \D VI VI 0 N ~ 0 00 00 VI - 0\ N VI ("r") 0\ N 0 "<:j- 00 0\ r-- r-- r-- VI N O\~ ~ - 00 N O~ VI \D O\~ '<:j"" 0 0 0 r-- 00 \D~ VI v:i N~ 0 N VI - 0\ N 00 0 0 0\ N r--. VI VI N ("r") 0 O\~ N Cci ~ v 0 .......:J .......:J v F --. ~ .:3 ~ ~ ~ 0.. ~ 0.. ...... ro v ro v r- eo >- u (jJ 0 ~ V bl) V c:: (jJ :J (jJ a. c:: ~ "bl) v r- r- r- V bl) V -g "'0 ~ V ~ 0 .2 :J c:: c:: co ~ > u v .2 w ro v W U ~ ..0 ,S > > (jJ >< I ro ro ~I) v > .~ ..c E c.. c.. (jJ '-.-/ >, (jJ ~ ro ro ro 0.. 0 0 (jJ ~ c.. 0.. ro J::: I r- V ro U U c:: r- t: c:: t- .~ ~ E u ro v bJ) (jJ v > 0 v ~ ~ v ~ bl) c:: :J ~ ...... ~ ~ ~ ~ c:: r- (jJ ...:.::: V (jJ (jJ v ~ V ~ ...:.::: ~ r- r- ~ ~ ~ 0 > ~ ro ~ 0.. 0.. ~ 0 ~ v ~ ~ -;:; >< ro ~ ~ c::: t- t- O W U t- EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN SOURCES OF REVENUE SUMMARY 2005 thru 2009 Source 2005 2006 2007 2008 2009 Total Cable Television Fund 40,600 40,600 Equipment Replacement Fund 741,800 225,300 540,700 307,500 551,000 2,366,300 RF - Refuse Fund 8,400 27,600 171,600 207,600 SF - Sanitary Sewer Fund 25,000 51,500 36,400 112,900 SU - Storm Sewer Fund 8,400 8,400 WF - Water Fund 10,600 34,700 21,100 66,400 Total 752,400 250,300 684,300 335,100 780,100 2,802,200 Thursday, .June 2-1. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN PROJECTS BY FUNDING SOURCE 2005 thru 2009 Source Project# Priority 2005 2006 2007 2008 2009 Total Cable Television Fund Cable/Council Chamber Cameras & Control System 01-ERP-050 0 40,600 40,600 Cable Television Fund Total 40,600 40,600 Equipment Replacement Fund City Hall Main Copy Machine 01-ERP-001 0 8,000 8,000 8,000 8,000 12,000 44,000 City Hall Small Copy Machine 01-ERP-002 0 23,200 23,200 Network Server Upgrade 01-ERP-003 0 5,000 5,000 5,000 5,000 5,000 25,000 Finance Computer System Software 01.ERP-005 0 50,000 50,000 Computers 01-ERP-006 0 30,000 30,000 30,000 30,000 30,000 150,000 Refrigerator/Freezer 01-ERP-031 0 6,500 6,500 Luverne Pumper 01-ERP-101 0 400,000 400,000 Duty Chief Vehicle 01-ERP-103 0 28,100 28,100 Lite Rescue 01-ERP-105 0 35,000 35,000 Stuphen Aerial Truck 01-ERP-106 0 300,000 300,000 Extrication Tool 01-ERP-109 0 20,300 20,300 Marked Patrol Vehicles (6) and Sergeant's Vehicle 01-ERP-200 0 56,200 28,900 89,400 92,100 266,600 Parking Enforcement Vehicle (210) 01-ERp.202 0 18,700 18,700 Utility 4x4 (211) 01-ERP-203 0 37,700 37,700 Police Administrative Vehicles (2) 01-ERP-204 0 23,400 24,100 24,800 25,600 26,300 124,200 Copy Machine 01-ERP-207 0 16,500 16,500 Logging Recorder 01-ERP-208 0 29,900 29,900 Network Server (3) 01-ERP-209 0 8,500 8,500 8,500 8,700 8,700 42,900 4x4 3/4 Ton Pickup with Plow 01-ERP-300 0 25,000 25,000 4X4 3/4 Ton Truck with Plow 01-ERp.301 0 24,000 24,000 4x4 1 Ton Dump Truck 01-ERp.302 0 40,600 40,600 1 Ton Dump Truck (2) 01-ERP-303 0 31,800 31,800 1 Ton Traffic Boom Truck 01-ERP-304 0 25,000 25,000 Front End Loaders (2) 01-ERP-308 0 140,000 157,500 297,500 Trailer 01-ERP-316 0 4,900 4,900 4X4 1/2 Ton Truck 01.ERP-710 0 24,100 24,100 3/4 Ton Utility Truck 01-ERP-802 0 32,200 32,200 Swap Loader o 1-ERP-803 0 27,600 27,600 Aerial Lift o 1-ERP-805 0 110,000 110,000 Tractors (2) 01-ERP-806 0 41 ,400 41,400 Trucksters (3) 01-ERP-807 0 16,600 16,600 Riding Mowers (2) 01-ERP-808 0 22,800 22,800 Friday, July 09, 2004 Source Project# Priority 2005 2006 2007 2008 2009 Total Brush Chipper 01-ERP-813 0 22,800 22,800 Trailer Flatbed 01-ERP-814 0 1,400 1,400 Equipment Replacement Fund Total 741,800 225,300 540,700 307,500 551,000 2,366,300 RF - Refuse Fund Refuse Truck 01-ERP-900 0 171,600 171,600 Utility Billing System 01-ERP-902 0 8,400 8,400 Swap Loader 01-ERP-910 0 27,600 27,600 RF - Refuse Fund Total 8,400 27,600 171,600 207,600 SF - Sanitary Sewer Fund 3/4 Ton Utility Truck (2) 01-ERP-551 0 25,000 26,000 51 ,000 Rodding Machine 01-ERP-553 0 36,400 36,400 Utility Billing System 01-ERP-556 0 25,500 25,500 SF - Sanitary Sewer Fund Total 25,000 51,500 36,400 112,900 SU - Storm Sewer Fund Utility Billing System o 1-E RP -950 0 8,400 8,400 SU - Storm Sewer Fund Total 8,400 8,400 WF - Water Fund 1/2 Ton Truck 01-ERP-500 0 20,500 20,500 Air Compressor 01-ERP-503 0 21,100 21,100 Utility Billing System 01-ERP-505 0 14,200 14,200 Public Works Copy Machine 01-ERP-506 0 10,600 10,600 WF - Water Fund Total 10,600 34,700 21,100 66,400 GRAND TOTAL 752,400 250,300 684,300 335,100 780,100 2,802,200 . ..__ ..___n_.____._______.. U . Friday, July 09. 200./ EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN DEPARTMENT SUMMARY 2005 thru 2009 Department 2005 2006 2007 2008 2009 Total Activity Center 6,500 6,500 Cable TV 40,600 40,600 City Hall Administration 43,000 66,200 93,000 43,000 47,000 292,200 Fire 420,300 28,100 300,000 35,000 783,400 Police 88,1 00 107,900 122,700 164,100 53,700 536,500 Public Works: Bldg/Equip Serv 24,100 24,100 Public Works: Parks/Forestry 1,400 16,600 59,800 197,000 274,800 Public Works: StreetsfTraffic 189,000 25,000 40,600 194,200 448,800 Refuse 8,400 27,600 171,600 207,600 Sewer 25,000 51,500 36,400 112,900 Storm Sewer 8,400 8,400 Water 10,600 34,700 21,100 66,400 Total 752,400 250,300 684,300 335,100 780,100 2,802,200 Thursday, June 24, 200-1 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN PROJECTS BY DEPARTMENT 2005 thru 2009 Department Project# Priority 2005 2006 2007 2008 2009 Total Activity Center Refrigerator/F reezer 01-ERP-031 0 6,500 6,500 Activity Center Total 6,500 6,500 Cable TV Cable/Council Chamber Cameras & Control System 01-ERP-050 0 40,600 40,600 Cable TV Total 40,600 40,600 City Hall Administration City Hall Main Copy Machine 01-ERP-001 0 8,000 8,000 8,000 8,000 12,000 44,000 City Hall Small Copy Machine 01-ERP-002 0 23,200 23,200 Network Server Upgrade 01-ERP-003 0 5,000 5,000 5,000 5,000 5,000 25,000 Finance Computer System Software o 1-ERP-005 0 50,000 50,000 Computers o 1-ERP-006 0 30,000 30,000 30,000 30,000 30,000 150,000 City Hall Administration Total 43,000 66,200 93,000 43,000 47,000 292,200 Fire Luverne Pumper 01-ERP-101 0 400,000 400,000 Duty Chief Vehicle 01-ERP-103 0 28,100 28,1 00 Lite Rescue 01-ERP-105 0 35,000 35,000 Stuphen Aerial Truck 01-ERP-106 0 300,000 300,000 Extrication Tool 01-ERP-109 0 20,300 20,300 Fire Total 420,300 28,100 300,000 35,000 783,400 Police Marked Patrol Vehicles (6) and Sergeant's Vehicle 01-ERP-200 0 56,200 28,900 89,400 92,100 266,600 Parking Enforcement Vehicle (210) o 1-ERP-202 0 18,700 18,700 Utility 4x4 (211) 01-ERP-203 0 37,700 37,700 Police Administrative Vehicles (2) 01-ERP-204 0 23,400 24,100 24,800 25,600 26,300 124,200 Copy Machine 01-ERP-207 0 16,500 16,500 Logging Recorder 01-ERP-208 0 29,900 29,900 Network Server (3) 01-ERP-209 0 8,500 8,500 8,500 8,700 8,700 42,900 Pol ice Total 88,100 107,900 122,700 164,100 53,700 536,500 Friday, July 09, 2004 Department Project# Priority 2005 2006 2007 2008 2009 Total Public Works: Bldg/Equip Serv 4X4 1/2 Ton Truck 01-ERP-710 0 24,100 24,100 Public Works: Bldg/Equip Serv Total 24,100 24,100 Public Works: Parks/Forestry 3/4 Ton Utility Truck o 1-ERP-802 0 32,200 32,200 Swap Loader 01-ERP-803 0 27,600 27,600 Aerial Lift 01-ERP-805 0 110,000 110,000 Tractors (2) 01-ERP-806 0 41,400 41,400 Trucksters (3) 01-ERP-807 0 16,600 16,600 Riding Mowers (2) 01-ERP-808 0 22,800 22,800 Brush Chipper 01-ERP-813 0 22,800 22,800 Trailer Flatbed 01-ERP-814 0 1,400 1,400 Public Works: Parks/Forestry Total 1,400 16,600 59,800 197,000 274,800 Public Works: Streets/Traffic 4x4 3/4 Ton Pickup with Plow 01-ERP-300 0 25,000 25,000 4X4 3/4 Ton Truck with Plow 01-ERP-301 0 24,000 24,000 4x4 1 Ton Dump Truck 01-ERP-302 0 40,600 40,600 1 Ton Dump Truck (2) 01-ERP-303 0 31,800 31 ,800 1 Ton T rafflc Boom Truck 01-ERP-304 0 25,000 25,000 Front End Loaders (2) 01-ERP-308 0 140,000 157,500 297,500 Trailer 01-ERP-316 0 4,900 4,900 Public Works: Streets/Traffic Total 189,000 25,000 40,600 194,200 448,800 Refuse Refuse Truck o 1-ERP-900 0 171,600 171,600 Utility Billing System 01-ERP-902 0 8,400 8,400 Swap Loader 01-ERP-910 0 27,600 27,600 Refuse Total 8,400 27,600 171,600 207,600 Sewer 3/4 Ton Utility Truck (2) 01-ERP-551 0 25,000 26,000 51,000 Rodding Machine o 1-ERP-553 0 36,400 36,400 Utility Billing System 01-ERP-556 0 25,500 25,500 Sewer Total 25,000 51,500 36,400 112,900 Storm Sewer Utility Billing System 01-ERP-950 0 8,400 8,400 Storm Sewer Total 8,400 8,400 Water 1/2 Ton Truck 01-ERP-500 0 20,500 20,500 Air Compressor 01-ERP-503 0 21,100 21,100 Utility Billing System o 1-ERP-505 0 14,200 14,200 Frida)', July 09, 2004 Department Public Works Copy Machine Water Total GRAND TOTAL Project# 01-ERP-506 Priority o 2005 10,600 10,600 2006 2007 34,700 2008 2009 Total 10,600 66,400 752,400 250,300 684,300 335,100 21,100 780,100 2,802,200 Friday, July 09. 200./ EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thrll 2009 Projcl't # Ol-ERP-OOl Projcct Namc City Hall Main Copy Machine Description I Copy machine to service needs orall departments located at City Hall. I. Variety or copying tasks. 2. High volume product copier. Contact Finance Director Dcpartmcnt City Hall Administration Typc Equipment Useful Life Category Equipment Priority n/a Total Project Cost $351,000 J usti fication I Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. Prior 59,000 I Total Expenditures Equipment 2005 8,000 8,000 Total Prior 59,000 I Total Funding Sources Equipment Replacement Fund 2005 8,000 8,000 Total Operational Impact/Other I Variance from 20 year plan - lease amount reduced Estimate salvage/resale value on replaced item: $-0- 2006 8,000 8,000 2008 8,000 8,000 2009 12,000 12,000 Total 44,000 44,000 Future 248,000 I Total Fu tll rc 248,000 I Total 2007 8,000 8,000 2006 8,000 8,000 2007 8,000 8,000 2008 8,000 8,000 2009 12,000 12,000 Total 44,000 44,000 Thursday, June 2./. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Con tact Finance Director Department City Hall Administration Project # Ol-ERP-002 Project Name City Hall Small Copy Machine Type Equipment Useful Life 5 years Category Equipment Priority n/a Description I Coyy machine to service needs of all departments located at City Hall. I, Variety of copying tasks. 2. High volume product copier. Total Project Cost 5137,500 J usti fication I Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. Expenditures Equipment 2005 Prior 20,000 I Total Total Prior 20,000 I Total Funding Sources Equipment Replacement Fund 2005 Total Operational I mpact/Other I Variance from 20 year plan - move back one year to 200 I Estimate salvage/resale value on replaced item: $2,500 2006 23,200 23,200 2008 2009 Total 23,200 23,200 Future 94,300 I Total Future 94,300 I Total 2007 2006 23,200 23,200 2007 2008 2009 Total 23.200 23,200 Thursday. June 24. 2004 2005 thrll 2009 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-003 Project # Project Name Networl{ Server Upgrade Description I Contact Finance Director Department City Hall Administration Type Equipment Useful Life 1 year Category Equipment Priori ty n/a Total Project Cost S 120,000 The network server is the hub of the network. New computers are faster and more reliable. Justification I 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 dat<l Prior 20,000 I Total Prior 20,000 I Total Expenditures Equipment Total 2005 5,000 5,000 2006 5,000 5,000 2007 5,000 5,000 2008 5,000 5,000 2009 5,000 5,000 Total 25,000 25,000 Future 75,000 I Total Funding Sou rees Equipment Replacement Fund Total 2005 5,000 5,000 2006 5,000 5,000 2007 5,000 5,000 2008 5,000 5,000 2009 5,000 5,000 Total 25,000 25,000 Future 75,000 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Con tact Finance Director Department City Hall Administration Project # Ol-ERP-OOS Project Name Finance Computer System Software Type Equipment Useful Life 7 years Category Equipment Priority n/a Total Project Cost $338,000 Description I Financial software package upgrade. Upgrade current financial software to InvisioIl. Justification I Produce reports, checks and bills for payroll, accounting and accounts payable. Provide a platform for citywide network. Provide on line inquiry for all departments. Tyler Technology version is user fricndly and adds more Ocxibility. Integrate utility billing software with financial system. Prior 30,000 I Total Expenditures Equipment 2005 2006 2007 50,000 50,000 2008 2009 Total 50,000 50,000 Futu re 258,000 I Total Total Prior 30,000 I Total Funding Sources Equipment Replacement Fund 2005 2006 2007 50,000 50,000 2008 2009 Total 50,000 50,000 Fu tll rc 258,000 I Total Total Operational Impact/Other I Variance from 20 year plan - upgrade in 2007. Beginning in 2014 schedule replacement every 7 years. Estimate salvagelresale valuc on replaced item: $-0- 7/11Irsday. June 2.f. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01- ERP-006 Project Name Computers 2005 thru 2009 Description I Contact Finance Director Department City Hall Administration Type Equipment Useful Life 3-5 years Category Equipment Priority nla Total Project Cost S720,000 Personal computer purchases and upgrades for the entire City stall', Coordinating personal computer purchases from individual departments to one fund. Justification I Tools enabling stalTto perform job responsibilities efficiently and ctTectively. Prior 120,000 I Total Expenditures Equipment Total Prior 120,000 I Total Funding Sources Equipment Replacement Fund Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- 2005 30,000 30,000 2005 30,000 30,000 2006 30,000 30,000 2006 30,000 30,000 2007 30,000 30,000 2007 30,000 30,000 2008 30,000 30,000 2008 30,000 30,000 2009 30,000 30,000 Total 150,000 150,000 Futl! rc 450,000 I Total Future 450,000 I Total 2009 30,000 30,000 Total 150,000 150,000 71l11rsday. June 24. 20Q.l EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 lhru 2009 Contact Public Works Director Department Activity Center Project # 01-ERP-031 Project Name Refrigerator/Freezer Type Equipment Useful Life 30 years Category Equipment Priority n/a Total Project Cost S10,500 Description I Commerical, stainless steel refrigerator and freezer. Justification I Cool ing/freezing needed for programs or by use of the participants and their activities. Present unit was here when activity center opened in 1980. This unit was part of the old South.lr. High cafeteria kitchen. The unit continues to have problems due to the age oflhe unit. Prior 4,000 I Total Expenditures Equipment 2005 2006 6,500 6,500 2007 2008 2009 Total 6,500 6,500 Total Prior 4,000 I Total Funding Sources Equipment Replacement Fund Total 2005 2006 6,500 6,500 2007 2008 2009 Total 6,500 6,500 Operational Impact/Other I Variance from 20 year plan - new item Estimate salvage/resale value on replaced item: $ 71l11rsday, June 24. 2()()4 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Project # OI-ERP-050 Project Name Cable/Council Chamber Cameras & Control System Description I Replacement of cameras, motors and VCS communications specialist camera control unit. Contact City Manager Department Cable TV Type Equipment Usefu I Li fe 8 years Ca tegory Equipment Priority n/a Total Project Cost S157,300 Justification I Cameras and their control equipment for meeting cable casts and presentations. Expenditures Equipment 2005 2008 2006 2007 40,600 40,600 Total 2009 Total 40,600 40,600 Futl! rc 116,700 I Total Funding Sources Cable Television Fund 2008 2005 2006 2007 40,600 40,600 Total 2009 Total 40,600 40,600 Future 116,700 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Thursday. June 2-1. 200-1 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thrll 2009 Contact Fire Chief Department Fire Type Equipment Useful Life 25 years Ca tcgory Equipment Priority n/a Total Project Cost S400,OOO Projt'ct # Ol-ERP-IOl Project Name Luverne Pumper Description I 1500 GPM fire pumper, fully equipped to respond to all fire situations in the city. Responds to mutual aid calls in other cities. Justification I Current unit is a second alarm unit. Replacement would be used as first out pumper. This apparatus construction will require 25 year specifications for life of the apparatus. Current Engine 3 is requiring major maintenance annually. Expenditures Equipment 2005 400,000 400,000 2006 2007 2008 2009 Total 400,000 400,000 Total Funding Sources Equipment Replacement Fund 2005 400,000 400,000 2006 2007 2008 2009 Total 400,000 400,000 Total Operational Impact/Other I Variance from 20 year plan - Move up from 2007 to 2005. Need for major repairs. Estimate salvage/resale value on replaced item: $2,500 Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Contact fire Chief Dcpartmcnt Fire Type Equipment lIseful Life 7 years Ca tegory Vehicles Priority n/a Total Project Cost S I 05,200 Project # Ol-ERP-I03 Project Name Duty Chief Vehicle Description I A marked passenger vehicle far use by the Duty Chief in transporting required equipment, reference materials and personnel for emergency response, and routine Fire Department business. Justification I Used by the fire Chief when responding to fires and other emergencies. Used for orticial business in and out of the city and for fire fighter travel on orticial Fire Department business. Expenditures Vehicles 2005 2006 28,100 28,100 2007 2008 2009 Total Future 28,100 77,100 I 28,100 Total Total Funding Sources Equipment Replacement Fund 2005 2006 28,100 28,100 2007 2008 2009 Total 28,100 28,100 Futu rc 77,100 I Total Total Operational Impact/Other I Variance from 20 year plan - Move back one year. Estimate salvage/resale value on replaced item: $4,000 Thursday, June 2./. 2004 EQUIPMENT REPLACEMENT PLAN 2005 thru 2009 City of Hopkins, MN Contact Fire Chief Department Fire Type Equipment Useful Life 1 0 years Category Vehicles Priority n/a Total Project Cost S118,800 Project # Ol-ERP-I05 Project Name Lite Rescue Description I Light rescue response vehicle on a 4 wheel drive chassis. J usti fication I Used for all emergency medical responses; vehicle accidents; industrical accidents; hazardous materials response. Expenditures Vehicles 2007 2005 2006 Total 2008 2009 35,000 35,000 Total 35,000 35,000 Future 83,800 I Total Funding Sources Equipment Replacement Fund 2006 2005 2007 Total 2008 2009 35,000 35,000 Total 35,000 35,000 Future 83,800 I Total Operational I mpact/Other I Variance from 20 year plan - move back to 2009 Estimate salvage/resale value on replaced item $ - 4,000 Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 Ih,.u 2009 Contact Fire Chief Department Fire Type Equipment lJseful Life 20 years Category Eq u i pment Priority n/a Total Project Cost S300,OOO Projt'ct # 01- ERP-l 06 Project Name Stuphen Aerial Truck Description I One hundred foot aerial ladder truck with a 1500 GPM fire pump and a full compliment of ground ladders. J usti fication I Vehicle would be used for ladder company operations during fires. This vehicle responds to all structure fires. Its job is to make openings in the building to let hot smoke out and to rescue people that might be trapped. Expenditures Equipment 2005 2006 2007 300,000 300,000 2008 2009 Total 300,000 300,000 Total Funding Sources Equipment Replacement Fund 2005 2006 2007 300,000 300,000 2008 2009 Total 300,000 300,000 Total Operational Impact/Other I Variance from 20 year plan - move back to 2007. Estimate salvage/resale value on replaced item: $ Thursday, June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-I09 Proj crt # Projcct Namc Extrication Tool 2005 thru 2009 Con tact Fire Chief Department Fire Type Equipment Useful Lifc 10 years Ca tcgory Equipment Priori ty nla Total Project Cost $47,500 Description I Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. Justification I All vehicle and industrial rescue situations which will require paitient disentanglement or entrapment. Expenditures Equipment Total Funding Sources Equipment Replacement Fund Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 2005 20,300 20,300 2006 2007 2008 2009 Total 20,300 20,300 Future 27,200 I Total Future 27,200 I Total 2005 20,300 20,300 2006 2008 2009 Total 20,300 20,300 2007 Friday. J1I0,09. 2004 EQUIPMENT REPLACEMENT PLAN City ofHopkins,MN 2005 thru 2009 Contact Police Chief Department Police Project # Ol-ERP-200 Project Name Marked Patrol Vehicles (6) and Sergeant's Vehicle Type Equipment Useful Life 3-4 years Category Vehicles Priority n/a Total Project Cost S I ,819,20{) Description I Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. J usti fication I Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Additional vehicle comes from K-9 program. Vehicle will be used by the power shift officers (overlap shift that provides additional coverage during peak call times). This vehicle is on a 4 year life. Prior 237,800 I Total Expenditures Vehicles 2005 56,200 56,200 2006 28,900 28,900 2007 89,400 89,400 2008 92,100 92,100 2009 Total 266,600 266,600 Future I 1,314,800 I Total Total Prior 237,800 I Total Funding Sources Equipment Replacement Fund 2005 56,200 56,200 2006 28,900 28,900 2007 89,400 89,400 2008 92,100 92,100 2009 Total Futl! rc 266,600 I 1,314.800 I 266,600 Total Total Operational Impact/Other I Variance from 20 year plan - None.. Estimate salvage/resale value on replaced item: $4,000 each Thursday. June 2-1. 200-1 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Project # 01- ERP-202 Project Namc Parking Enforcement Vehicle (210) Description Parking enforcement vchiclc. I Departmcnt Policc Contact Policc Chicf Typc Useful Lifc Ca tcgory Priority nla Equ i pmcnt 10 ycars Vehicles Total Projcct Cost 543.900 J usti fication I Use by parking cnforccmcnt officcrs in thc course of their dutics enforcing parking rcgulations in the downtown area. Expenditures Vehicles 2005 Total 2006 2008 2009 18,700 18,700 Total 18,700 18,700 Future 25,200 I Total Funding Sources Equipment Replacement Fund 2005 Total 2007 2006 2007 2008 2009 18,700 18,700 Total 18,700 18,700 Futl! re 25,200 I Total Operational Impact/Other I Variance from 20 year plan - nonc Estimate salvage/resalc value on replaccd itcm: $1,500 Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 Ihru 2009 Contact Police Chief Dcpa,-tment Police Type Equipment Useful Life 6 years Ca tegory Vehicles Priodty n/a Total Project Cost S 175,500 Projl'ct # 01-ERP-203 Project Name Utility 4x4 (211) Description I 4 wheel drive uitlity vehicle. J usti fication I Vehicle is normally used by public service officers for a wide variety of uses such as transporting animals and equipment. The 4 wheel drive vehicle is also used at times as a patrol vehicle, particularly in the winter in extreme snow conditions. Expenditures Vehicles 2005 Prior 29,700 I Total Total Prior 29,700 I Total Funding Sources Equipment Replacement Fund 2005 Total Operational I mpact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $5,000 2006 2008 37,700 37,700 Total 37,700 37,700 Futl! rc 1 08,1 00 I Total Future 108,100 I Total 2009 2007 2006 2008 37,700 37,700 Total 37,700 37,700 2009 2007 71ll1rsday, June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Con tact Police Chief Department Police Type Equipment Useful Life 2 years Category Vehicles Priori ty nla Total Project Cost $689,500 P,'ojCl't # Ol-ERP-204 Project Name Police Administrative V chicles (2) Description I Police administrative and detective vehicles. J usti fication I Unmarked vehicles. equipped with radios, siren and red grille lites used by chiefand captain. Staff-use is for two years. Vehicles arc then rotated down to detectives and are kept for an additional 3-4 years. Vehicles are also used for surveillance by uniform and plain clothes officers. Prior 61,100 I Total Expenditures Vehicles 2005 23.400 23,400 Total Prior 61,100 I Total Funding Sources Equipment Replacement Fund 2005 23.400 23,400 Total Operational I mpact/Other I Variance from 20 year plan - move back schedules cars one year. Estimate salvagelresale value on replaced item: $4,000 each 2006 24,100 24,100 2006 24,100 24,100 2007 24,800 24,800 2007 24,800 24,800 2008 25,600 25,600 2009 26,300 26,300 Total 124,200 124,200 Futu rc 504,200 I Total Fu tu rc 504,200 I Total 2008 25,600 25,600 2009 26,300 26,300 Total 124,200 124,200 Thursday, June 24, 2004 EQUIPMENT REPLACEMENT PLAN 2005 thrlf 2009 City of Hopkins, MN Contact Police Chief Department Police Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost S97 .500 Project # Ol-ERP-207 Project Name Copy Machine Description I Pol ice Department copy mach ine capable of producing double side copies and collating pages. Justification I Used to make dupl icate copies of reports, letters, memos, etc., generated by pol ice presonnel. Expenditures Equipment 2007 Prior 14,200 I Total 2005 Total 2006 16,500 16,500 2008 2009 Total 16,500 16,500 Futu rc 66,800 I Total Prior 14,200 I Total Funding Sources Equipment Replacement Fund 2005 Total 2006 16,500 16,500 2007 2008 2009 Total 16,500 16,500 Future 66,800 I To ta I Operationallmpact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Contact Police Chief Department Police Project # Ol-ERP-208 Project Name Logging Recorder Type Equipment Useful Life 7 years Category Equipment Description I Priority n/a Total Project Cost SIll ,800 The police logging recorder is a device which tape records all telephone and radio transmissions which go through the Police Department. Justification I Records all phone calls coming into the dispatch center and all incoming and outgoing radio transmissions. This is necessary in case questions arise as to how calls for service were received or dispatched. Expenditures Equipment 2005 Total 2006 29,900 29,900 2008 2009 Total 29,900 29,900 Futll rc 81,900 I Total Funding Sources Equipment Replacement Fund 2005 Total 2007 Futu rc 81,900 I Total Operational Impact/Other I Variance from 20 year plan - moved back from 1998 to 1999 Estimate salvage/resale value on replaced item: $-0- 2006 29,900 29,900 2009 Total 29,900 29,900 2007 2008 Thursday, June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 /hru 2009 Project # Ol-ERP-209 Project Name Network Server (3) Description I Contact Police Chief Depa rtm ent Pol ice Type Equipment Useful Life 3 years Category Equipment Priority nla Total Project Cost SI96,700 J usti fication I Prior 17,000 I Total Expenditures Equipment 2005 8,500 8,500 Total Prior 17,000 I Total Funding Sources Equipment Replacement Fund 2005 8,500 8,500 Total Operational Impact/Other I Variance from 20 year plan - Estimate salvagelresale value on replaced item - $ 2006 8,500 8,500 2007 8,500 8,500 2008 8,700 8,700 2008 8,700 8,700 2009 8,700 8,700 Total 42,900 42,900 Futu re 136,800 I Total Fu tu rc 136,800 I Total 2006 8,500 8,500 2007 8,500 8,500 2009 8,700 8,700 Total 42,900 42,900 Thursday. June 2-1. 200-1 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 1/1,.u 2009 Contact Public Works Director Department Public Works: Streetsffraftic Project # Ol-ERP-300 Project Name 4x4 3/4 Ton Pickup with Plow Type Useful Life Ca tegory Priority n/a Equipment 10 years Vehicles Total Project Cost S58,600 Description I Pickup used by various divisions of Public Works. Justification I Light hauling and transportation for supervisors. Maintenance garage service vehicle. Expenditures Vehicles 2008 2009 2006 2007 Total 2005 25,000 25,000 Total 25,000 25,000 Futu rc 33,600 I Total Funding Sources Equipment Replacement Fund 2008 2009 Total 2005 25,000 25,000 2007 2006 Total 25,000 25,000 Future 33,600 I Total Operational Impact/Other I Variance from 20 year plan - Increase expenditure to reflect actual cost. Change from 1/2 ton pickup to 3/4 ton 4x4 pickup. Estimate salvage/resale value on replaced item: $1,500 Thursday. June 2./. 200./ EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Proj('ct # Ol-ERP-301 Project Name 4X4 3/4 Ton Truck with Plow Description I 3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers. Contact Public Works Director Department Public Works: Streetsrrraffic Type Equipment Useful Life 8 years Category Vehicles Priority n/a Total Project Cost S92,900 Justification I Light hauling, pulling trailers, transportation to and from job sites. Expenditures Vehicles 2005 24,000 24,000 Total 2006 2007 2008 2009 Total 24,000 24,000 Future 68,900 I Total Funding Sources Equipment Replacement Fund 2005 24,000 24,000 Total 2006 2007 2008 2009 Total 24,000 24,000 Future 68,900 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,500 Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thrll 2009 Projl'l't # Ol-ERP-302 Project Name 4x4 1 Ton Dump Truck Description I Truck is used in the Street Division of Public Works. Contact Public Works Director Department Public Works: Streetsrrratlic Type Equipment Useful Life 8 years Category Vehicles Priority nla Total Project Cost S157,300 Justification I Plows alleys in winter, light hauling, snow removal and transportation. Expenditures Vehicles 2005 Total 2006 2007 2008 40,600 40,600 2009 Total 40,600 40,600 Futu re 116,700 I Total Funding Sources Equipment Replacement Fund 2005 Total 2006 2007 2008 40,600 40,600 2009 Total 40,600 40,600 Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $3,500 Fu tu re 116,700 I Total Thursday, ./une 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Project # Ol-ERP-303 Projcct Namc 1 Ton Dump Truck (2) Description I Truck is used in the Street Division of Public Works. Contact Public Works Director Department Public Works: Streetsrrraflic Type Equipment Useful Life 12 years Category Vehicles Priority nla Total Project Cost S 152,400 J usti fication I Vehicle used by various departments for street and park maintenance and light hauling. Expenditures Vehicles 2006 2007 2008 Prior 30,500 I Total 2005 Total Prior 30,500 I Total Funding Sources Equipment Replacement Fund 2007 2008 2005 2006 Total Operational I mpact/Other I Variance from 20 year plan -move one truck back one year to 2003 Estimate salvage/resale value on replaced item: $3,500 2009 31,800 31,800 Total 31,800 31,800 Future 90,100 I Total Futu re 90,100 I Total 2009 31,800 31,800 Total 31 ,800 31,800 Thursday. June 2.f. 2(}(}.f EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thrll 2009 Con tact Publ ic Works Director Dcpartmcnt Public Works: Strcctsnraflic Project # Ol-ERP-304 Projcct Namc 1 Ton Traffic Boom Truck Typc Useful Lifc Equipment 12 years Vehicles Ca tcgor)' Priority n/a Total Projcct Cost SIOI,300 Description I Boom truck used in Street and Traffic Divisions of Public Works. Justification I Vehicle used by Traffic Departmcnt for signal and light pole maintcpancc. Expenditures Vehicles 2005 2006 2007 25,000 25,000 2008 2009 Total 25,000 25,000 Future 76,300 I Total Total Funding Sources Equipment Replacement Fund 2005 2006 2007 25,000 25,000 2008 2009 Total Future 25,000 76,300 I 25,000 To ta I Total Operational Impact/Other I Variance from 20 year plan - change to 25,000 cost in 2007 - cost to replace cab/chassis and reuse lift assembly. Estimate salvage/rcsalc valuc on replaced itcm: $8,000 Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 Ihrll 2009 Project # Ol-ERP-308 Project Name Front End Loaders (2) Description I Contact Public Works Director Department Public Works: Streetsn'raftlc Type Equipment Useful Life 15 years Category Equipment Priority n/a Total Project Cost S761,100 Justification I Expenditures Equipment Total 2005 140,000 140,000 2006 2007 2008 2009 157,500 157,500 Total 297,500 297,500 Future 463,600 I Total Funding Sources Equipment Replacement Fund Total 2005 140,000 140,000 2006 2007 2008 2009 157,500 157,500 Total 297,500 297,500 Futu rc 463,600 I Total Operational Impact/Other I Variance from 20 year plan - Increase costs to reflect actual replacement cost. Estimate salvage/resale value on replaced item: S Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Contact Public Works Director Department Public Works: Streetsrrranic Project # 01-ERP-316 Type Equipment Useful Life 20 years Category Equipment Project Name Trailer Priority n/a Total Project Cost S4,900 Description I Justi fication I Expenditures Equipment 2005 2006 2007 2008 2009 4,900 4,900 Total 4,900 4,900 Total Funding Sources Equipment Replacement Fund 2005 2006 2007 2008 2009 4,900 4,900 Total 4,900 4,900 Total Operational Impact/Other I Variance from 20 year plan - none Estiamte salvage/resale value on replaced item: $ 71l11rsday. Jllne 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 Ihr1l 2009 Projl'ct # Ol-ERP-SOO Project Name 1/2 Ton Truck Description Trucks used by Water Department. I Contact Public Works Director Department Water Type Eq 1I i pment Useful Life 10 years Ca tegor)' Equipment Priority nla Total Project Cost S47,300 Justification I Expenditures Vehicles 2005 Total 2006 2007 20,500 20,500 2008 2009 Total 20,500 20,500 rutu re 26,800 I Total Funding Sources WF - Water Fund 2005 Total 2006 2007 20,500 20,500 2008 2009 Total 20,500 20,500 Future 26,800 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Thursday, June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-S03 2005 thru 2009 Contact Public Works Director Department Water Project # Type Equipment Useful Life 20 years Category Equipment Project Name Air Compressor Priori ty n/a Total Project Cost $21, I 00 Description I Portable air compressor used by various departments of Public Works. J usti fication I Air supply for operating jack hammers, blowing out irrigation lines, sand blasting and operations of various tools. Expenditures Equipment 2005 2006 2007 2008 2009 21 , 1 00 21,100 Total 21,100 21 ,100 Total Funding Sources WF - Water Fund 2005 2006 2007 2008 2009 21,100 21 J 100 Total 21,100 21 ,100 Total Operational Impact/Other I Variance from 20 year plan - move back to 2009 - current compressor in good condition Estimate salvage/resale value on replaced item: $2,000 Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Projl'('t # 01- ERP-505 Project Name Utility Billing System Description I Uti! ity bill ing system for bill ing customers for water/sewer/refuse and storm sewer usage. Contact Finance Director Department Water Type Equipment Useful Li fe 8 years Category Equipment Priority n/a Total Project Cost S55,OOO Justification I Allows billing clerk to bill customers efficiently and efTectively. Also, rrovides tools for analysis and monitoring. Expenditures Equipment 2008 2005 2006 Total 2007 14,200 14,200 2009 Total 14,200 14,200 Future 40,800 I Total Funding Sources WF - Water Fund 2005 2006 Total 2007 14,200 14,200 2008 2009 Total 14,200 14,200 rutu re 40,800 I Total Operational Impact/Other I Variance from 20 year rlan - none Estimate salvage/resale value on rerlaced item: $ Thursday, June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Project # Ol-ERP-S06 Project Name Public Works Copy Machine Description I Copy machine to service needs orall division orpublic Works. Contact Public Works Director Department Water Type Equipmcnt Useful Life 5 years Ca tegory Equipmcnt Priori ty nla Total Project Cost S53,500 J usti fication I Making copies lar various departments. Expenditures Equipment 2005 10,600 10,600 Total 2006 2008 2009 Total 10,600 10,600 Future 42,900 I Total Funding Sources WF - Water Fund 2005 10,600 10,600 Total 2007 2006 2008 2009 Total 10,600 10,600 Futu rc 42,900 I Total Operational Impact/Other I Variance rrom 20 year plan - none Estimate salvage/rcsale value on replaced item: $800 2007 Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Contact Public Works Director Dcpartmcnt Sewer Projl'ct # 01-ERP-551 Projcct Nalllc 3/4 Ton Utility Trucl{ (2) Type Useful Life Equipment 10 years Vehicles Ca tegory Description I 3/4 ton utility trucks used by the Water/Sewer Division of Public Works. Priority n/a Total Project Cost S119,500 Justification I Transportation to and from job sites, box carries tools used by personnel for job sitc repairs and I ight haul ing. Expenditures Vehicles 2005 Total 2006 25,000 25,000 2008 2009 Total 51,000 51,000 Future 68,500 I Total Funding Sources SF - Sanitary Sewer Fund Total 2005 2007 26,000 26,000 2006 25,000 25,000 2007 26,000 26,000 2008 2009 Total 51,000 51,000 Future 68,500 I Total Operational Impact/Other I Variance from 20 year plan - Delete 1/2 ton truck and 4x4 3/4 ton truck - change to 3/4 ton truck. Adjust expenditures to reflect actual cost. Estimate salvage/resale value on replaced item: $2,500 7/lursday, June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Contact Public Works Director Dcpartmcnt Sewer Projcct # Ol-ERP-553 Type Equipment Useful Life 20 years Project Name Rodding Machine Category Equipment Priority nla Total Project Cost $36,400 Description I Mechanical sanitary sewer cleaning machine. J usti fication I Expenditures Equipment 2005 2006 2007 2008 2009 36,400 36,400 Total 36,400 36,400 Total Funding Sources SF - Sanitary Sewer Fund 2005 2006 2007 2008 2009 36,400 36,400 Total 36,400 36,400 Total OperationallmpactlOther I Variance from 20 year plan - extend life to 20 years to renect actual. Estimate salvage resale value on replaced item: $ 7/l/Irsday, June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 lhl'1I 2009 Project # Ol-ERP-556 Projcct Namc Utility Billing System Description I Uti I ity bill ing systcm for bill ing customcrs for water/sewer/refusc and storm sewer usagc. Contact Finance Director Dcpartmcnt Sewer Type Equipmcnt Useful Lifc 8 ycars Category Equipmcnt Priori ty n/a Total Projcct Cost $98,700 J usti fication I Allows billing clerk to bill customcrs efficicntly and effcctivcly. Also, provides tools for analysis and monitoring. Expenditures Equipment 2005 Total 2006 2007 25,500 25,500 2008 2009 Total 25,500 25,500 Future 73,200 I Total Funding Sources SF - Sanitary Sewer Fund Total 2005 2006 2008 2009 Total 25,500 25,500 Flit II rc 73,200 I Total OperationallmpactlOther I Variance from 20 year plan - none Estimatc salvagc/rcsale valuc on rcplaccd item: $ 2007 25,500 25,500 Thursday. June 2-1. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 Ihl'u 2009 Project # Ol-ERP-710 Project Name 4X4 1/2 Ton Truck Description I Pickup used by various divisions of Public Works. Con tact Publ ic Works Director Department Public Works: BldgJEquip Ser Type Useful Life Ca tegory Priority n/a Equipment 10 years Vehicles Total Project Cost S56,400 J usti fication I Light hauling and transportation for supervisors. Maintenance garage service vehicle. Expenditures Vehicles 2005 Total 2006 2008 2009 24,100 24,100 Total 24,100 24,100 Future 32,300 I Total Funding Sources Equipment Replacement Fund 2005 Total 2007 2006 2007 2008 2009 24,100 24,100 Total 24,100 24,100 Fu tu rc 32,300 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvagclresale value on replaced item: $1,500 71/11rsday. June 2-1, 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Projt'ct # Ol-ERP-802 Project Name 3/4 Ton Utility Truck Description I Truck used by Parks Division of Publ ic Works. Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost $75,600 J usti tication I 2005 2007 Expcnditurcs Vehicles 2006 2008 32,200 32,200 Total 2009 Total 32,200 32,200 Futurc 43.400 I Total Funding Sources Equipment Replacement Fund 2005 2006 2007 2008 32,200 32,200 Total 2009 Total 32,200 32,200 Futurc 43.400 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Thursday, June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thrll 2009 Project # Ol-ERP-803 Project Name Swap Loader Description I Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Li fe 15 years Category Equipment Priority n/a Total Project Cost S70,500 Justification I Expenditures Equipment 2005 Total 2006 2007 2008 27,600 27,600 2009 Total 27,600 27,600 Futu re 42,900 I Total Funding Sources Equipment Replacement Fund 2005 Total 2006 2008 27,600 27,600 2009 Total 27,600 27,600 Future 42,900 I l' 0 ta I Operational Impact/Other I Variance rrom 20 year plan - Apply 50% or replacement to Refuse Fund. Estimate salvage/resale value on replaced item: $ 2007 Thursday. June 2./. 200./ EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thrll 2009 Contact Public Works Director Departmcnt Public Works: Parks/Forestry Projcl'l # Ol-ERP-80S Project Namc Aerial Lift Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost S II 0,000 Description I Justification I Expenditures Equipment 2005 2006 2007 2008 2009 110,000 110,000 Total 110,000 110,000 Total Funding Sources Equipment Replacement Fund 2005 2006 2007 2008 2009 110,000 110,000 Total 110,000 110,000 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Project # 01-ERP-806 Project Namc Tractors (2) Description I Farm type tractors with cab used with various attachmcnts. Contact Public Works Director Departmcnt Public Works: Parks/Forestry Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost S82,800 Justification I Icc rink swceping, flail mower, fertilizing, aeration, plowing and grass secding. Expenditures Equipment 2007 2008 2005 2006 Total 2009 41,400 41,400 Total 41,400 41,400 Futu rc 41 ,400 I Total Funding Sources Equipment Replacement Fund 2005 2006 2007 2008 Total 2009 41 ,400 41,400 Total 41,400 41,400 Futu re 41 ,400 I Total Operational I mpact/Other I Variancc from 20 year plan - move tractor back from 2004 to 2009, move back tractor from 2006 to 20 I O. Estimate salvage/resale value on replaced item: $3,500 Thursday. June 2-1. 200.; EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-807 Project # Project Name Trucksters (3) 2005 thru 2009 Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Life 15 years Category Equipment Priority n/a Description I Total Project Cost S I 05,900 Truckster used by Parks Division of Pub I ic Works for ball field and parks maintenance. Justification I Park maintenance, balllield grooming and weed spraying. Prior 29,900 I Total Prior 29,900 I Total Expenditures Equipment 2005 2006 16,600 16,600 Total 2007 2008 Total 16,600 16,600 Future 59,400 I Total Funding Sources Equipment Replacement Fund 2005 2006 16,600 16,600 Total 2009 2007 2008 Total 16,600 16,600 Future 59,400 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,400 each 2009 Thursday. June 24. 20M EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Project # Ol-ERP-808 Project Name Riding Mowers (2) Description I Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Life 8 years Category Equipment Priori ty n/a Total Project Cost S I 08,000 Riding mowers used by Parks Divison of Public Works. One mower also used for sidewalk snow removal during winter months. J usti fication I Mowing city parks and right of ways and sidcwalk snow rcmoval. Expenditures Equipment 2005 Prior 33,000 I Total Total Prior 33,000 I Total Funding Sources Equipment Replacement Fund 2005 Total Operationallmpact/Other I Variance from 20 year plan - none. Estimate salvage/resale value on replaced item: 5600 cach 2006 2007 2008 2009 22,800 22,800 Total 22,800 22,800 Futl! re 52,200 I Total Futu rc 52,200 I Total 2006 2008 2007 2009 22,800 22,800 Total 22,800 22,800 Thursday. June 2-1. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Contact Public Works Director Project # 01-ERP-813 Project Nallle Brush Chipper Department Public Works: Parks/Forestry Type Equipment Useful Life 15 years Category Equipment Priority n/a Total Project Cost S58,300 Description I Brush chipper used for Forestry and brush pick up operations of Public Works. Justification I Expenditures Equipment 2005 2006 2007 2008 2009 22,800 22,800 Total 22,800 22,800 Future 35,500 I Total Total Funding Sources Equipment Replacement Fund 2005 2006 2007 2008 2009 22,800 22,800 Total 22,800 22,800 Futu rc 35,500 I Total Total Operational Impact/Other I Variance from 20 year plan - change to usable life to 15 years. Estimate salvagelrcsalc value on replaced item: $ 71ll1rsday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Life 15 years Category Equipment Priority nla Projel't # 01-ERP-814 Project Name Trailer Flatbed Total Project Cost S3,600 Description I Justification I Expenditures Equipment 2005 1,400 1,400 2006 2007 2008 2009 Total 1,400 1,400 Futl! re 2,200 I Total Total Funding Sources Equipment Replacement Fund 2005 1,400 1,400 2006 2007 2008 2009 Total 1,400 1,400 Fu tll rc 2,200 I Total Total Operational Impact/Other I Variance from 20 year plan - Move up one year. Estimate salvagc/resale value on replaced item: $ Thursday. June 24, 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Project # Ol-ERP-900 Project Name Refuse Truck Description I Refuse truck used by Refuse Utility Division of Public Works. Contact Public Works Director Department Refuse Type Equipment Useful Life 5 years Ca tegory Vehicles Priority nla Total Project Cost 51,016,200 J usti fication I Residential waste pick up. Expenditu res Vehicles 2005 Prior 148,000 I Total Total Prior 148,000 I Total Funding Sources RF - Refuse Fund 2005 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resalc value on replaced item: $18,000 2006 2007 2008 2009 171,600 171,600 Total 171,600 171,600 Future 696,600 I Total Future 696,600 I Total 2006 2008 2007 2009 171,600 171,600 Total 171,600 171,600 7'llllrsday. June 2-1. 200-1 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Projl'ct # Ol-ERP-902 Project Name Utility Billing System Description I Utility billing system for billing customers for water, sewer, refuse and storm sewer usage. Contact Finance Director Department Refuse Type Equipment Useful Life 8 years Category Equipment Priority nla Total Project Cost S32,900 Justification I Allows billing clerk to bill customers efficiently and elTectivcly. Also, provides tools for analysis and monitoring. Expenditu res Equipment 2007 8,400 8,400 2008 2005 2006 Total 2009 Total 8,400 8,400 Future 24,500 I Total Funding Sources RF - Refuse Fund 2005 2006 2007 8,400 8,400 2008 Total 2009 Total 8,400 8,400 Futu rc 24,500 I Total Operational] mpact/Other I Variance from 20 year plan - none Estimate salvage/resalc value on replaced item: $ Thursday. June 24. 2004 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thru 2009 Projl.'ct # Ol-ERP-910 Projcct Namc Swap Loader Description I Contact Public Works Director Department Refuse Type Equipment Useful Life 15 years Ca tegory Eq u ipment Priority n/a Total Project Cost S70,500 Justification I Expenditures Equipment 2006 2005 Total 2007 2008 27,600 27,600 2009 Total 27,600 27,600 Futl! re 42,900 I Total Funding Sources RF - Refuse Fund 2005 2006 Total 2007 2008 27,600 27,600 2009 Total 27,600 27,600 Full! rc 42,900 I Total Operational I mpact/Other I Variance from 20 year plan - 50% to Refusc Fund/50% to Equipmcnt Replacement. Estimate salvage/resale value on replaced item: $ Thursday. June 2-1. 200-1 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2005 thrll 2009 Projl'ct # Ol-ERP-950 Project Name Utility Billing System Description I Utility billing systcm for billing customers for water, sewer, refuse and storm sewer usage. Contact Finance Director Department Storm Sewcr Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost S32,900 Justification I Allows billing clerk to bill customers efficiently and effectively. Also, provides tools for analysis and monitoring. Expenditures Equipment 2005 Total 2006 2007 8,400 8,400 2008 2009 Total 8,400 8,400 Futu re 24,500 I Total Funding Sources SU - Storm Sewer Fund 2005 Total 2006 2007 8,400 8,400 2008 2009 Total 8,400 8,400 Future 24,500 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale valuc on replaced item: $ Thursday. June 24. 2004 :3 ;:J o :.J ~ ~~ f- ~! :;: w 2 u ". ~ ~ ~ 5 ::::: w:: ~c'" ~ - ~ ~ ;:J Z o :.J .,. o C ::l .,. ..J Vl r; ~ ~ M or. o r- u -<: "- z o f= -<: ....l "- ~ .,. N o N N o '" N N o N N o '" o '" o ,,' 0' o '" ~ o N !:: o '" ~ o N o '" ::: o N ~ ~ o N o N ~ o '" 0' o o N 00 o o r- o o N ~ o o '" tz ~ t 5 8 o o o ~ ~ ~ ~I G: ~ 5 g wJ ~ I- 8 ~ 0 ~ 8 o o o o ~ ~ r:j o o o 0' .,. a o ~ ;r; g o ~ ~ ~" ~ ~ or; r- N ~ - ~ or. ~ ~ ~ ~ Ul C2 2 c ~ :< :3 ~ ~ or. r- ....l ..J <: Ulor. <l- e; ~ C2 ~ :E ~ UJ ~ ::0 UJ ; ::J < ::J > ~ u Z Vl ~ :r: ~ :;: ~ ~ UJ c:: ~ ~ j ~ 00 0' o 0 o o o ~ ~ r:j ~ ~ g M o o o ~ ~" g ;:: g ~ :::;" o ~ ;r; o o o o o o ~ o 0 g g ~ ~ o :: ~ o o o ~ ~ ~ ~ Vl ::J I- ~ ..J ....l or. < 0 < og;o i3 ~-<:I- ~r- ~ <) ~ I- ~ ~~f= ~Vl 8 ~ :i or. ~ ~ ~ ~ ~ :;: ;5 Gl 8 ~ o ~ r:; o o 00 ':i o o M ~~ o ~ ~ o o ~ o o N ~ o g ~ o o o ; o g ;:;" ~ ~ o o ~ ~ ~ ~~ ~ ~ ~ ~. q ~ ~ ~~ o 0 ~ ~ ~~ ~ s s ~~ ~ ~ ~ g'; ~ ~ ':i ~ ~ ~ ~ ~{ ~ g ~ o g ;:;" ~ ~ g ~ '!j ~~ o o ~ g ~ o ~ ~ ~ s ~~ o o 00 g; ~ .,. ~ ~ ~ f""'I ~ 1'"""1 M M "1'" "1" ~ ~I c.. ~ ~ :;t :: :n ~ 0:: 000 0 0 ~ < :5 :3 :3 :3 :3 ::> u gSi'Si'ggSi'~ o o 0' r:; o o 00 ':i ~ :cf o o 0- ~ o o -0 "i. ~ o;i o o r- ;:;" or. UJ .,. o ~ ~ ~ o ....l ~ 5 ~ ~ M N ~ .,. ~ ~ ~ ~ g ~~ g ;r; ~ ~ ~ ~ ~~ ~ i'f ~ ::." g 8 r- '-? ~~ 2 ~ ..J -<: I- o r- er. or. ::0 < < ::J U U Vl ~ ~ o 0 < < o 0 ~ ~ ~~ ~ ~ o 0 o 0 ~~ o o N ~ o 0 o 0 .,. ~: o o '-? ~ o 0 o 0 ~r..{ o o o ~ ~~ ~~ o o ...., ~ ~ ~ ~ ~ o o ;i ~ 8 ~ ~ o o ~ o 0 o 0 o ~ ';j o o .,. ~ o 0 o 0 ~ ::: o o :;::" ~ ~ ~ ri o o .,. S 0" o o -0 0-: o o -0 0" o o -0 0-: ~ 0-: o o 0-: s ~ I,) a: N o o 0- ;z: o ~. N .,. ~ ~ g a:'4~ o o ,., 0-: o o ,., 0-: ~ o ~ 0-: o ~ ~ o o o 0-: o o o 0-: ~ 8 ~f 0: o o o o o 0-: o o o 0-: o 0 o 0 o 0 O"~ a: 8 g ~ a: ~ ';f o o o r- o;i g o;i ~ ~ ~ QIJ~ o ~ ~ o o r- M o o r- o;i o o .,. Ef o o r- o;i o o r- o;i o o r- o;i o g o;i ~ o;i ~ o;i o 0 0 0 ~ 0 ~ ~ 'i.oo~'i o o or; o;i ~ o;i ~ ::: "" UJ t;; ~ ~ I- or. Vl UJ ~ ~ ffi ~ 8 8 ~ or. ....l UJ < ~ er. i3 ~ ~ s; ~ 8 ~ ~ ~ ~ <) UJ 0 Z ....l 0 ~ g "T ~ N .,; ~~ 0 0 'C '" ~ N ~ a N ~ ~ a a 00 N :f N ~ ~ ~ a ~ a a a N '" ;i ':j ~~ ~ a '" a a ~ a a a '" 00 :i ~ a '" '" ~ a ~ a a a 0- ~- ~ ~ ~ a N a 00 S; ~ ;:j !::: a N '" a v; 2 a '" '" a v; i2 ~ a ~ a a g 00 ~ ~ :i -0 ~ :! a '" ~ ~ ~ a a :c v, a g ;;; i '" N 0 ~ ~ ~- ~ ~ ';j '" ~ ~ ~ a ~ a I"- a .,.- v; :i ~ N ~ v; g ~ a a g a ~ i '" ..... a '" a ~ 0 0- a ~ a 0 00 0- a ~ .r" ;j ~ a N '" ~ 00 8 a <i <i a '" I"- 8 8 a ~f ~ a '" '" 0 ~ a 8 a a a a :5 a a a ~ ;{ <i ~ a '" Vl :: 00 ~ "" ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ a :: a :: ~ 0 a :: :: t:::l oc N N N N en oc >- U U > en G: c.; I- u.. Z Z ~ ~ ?E; t...l f- ~ oc oc ::; ~ t ;:; ;:; UJ UJ -l t...l Z ::; 0 0 2 ~ 0 ..: t...l ..: Q., en -l -l c.. ..: f- ~ > 0 I- ~ ~ ~ f- ~ ~ :L :3 g oc 0 (,;) -< .<. -' 5 t...l :::l c.. ~ U oc ~ f0- e...? UJ t...l c.. 0 c.. ~ ~ ::J :::l :::l UJ ~ Z tI; 8' oc ~ ::E 0 0 0 Z C2 ::: ::::: ~ f- f- Z 0 ::J :::l 0 oc z z 0 0 t...l >- l- f- fo- 5 0 :::l 0 0 0 ::E ~ fo- UJ UJ ..: oc oc ...J oc UJ c.: Vl ~ :L 0 CO oc 0 ~ ~ oc CO UJ oc en ~ ~ f- X ~ UJ f- !Z ...J UJ UJ oc UJ ::: z 0 z z z ..: 0 0 UJ Z 0 UJ 2 UJ ;:; -l f- ::: ~ 0 .,. 0 0 -l ...J Z ~ f- ~ 0 0 ;:i UJ ::l > 0 ~ c.: G 0 f0- X f- ~ f- fo- " " ..: ..: oc ::;: ;:; 0 f- ..: Z Z ;:i N N c.: .,. - - - Vl Vl f- r- ::: Lt. Lt. Vl " Vl oc Vl c.. Vl r- UJ " ~ g .,. ~ ~ - ..... :! v; '" '" v; '" 00 a .,. I"- .,. 0- g ~ "" a N a '" a ;;; N N N N ,... ... "T Q., c.. ..... ..... ..... ..... ..... ..... ..... ..... I"- ", '" ~ ...,. N o N N o N N o o o ~ N o N o N o r, '"' o '" 00 ~ t- O N "" :? ~ o '" :::: o '" o N o N o 0 o '" 0 N r-... r--- ~: ~ ~ o N o o N '"' o o 00 o o '" t- O o N "" o o '" o o N 5: Vl ;2 s: ~ ~ ~ .." 2 o o '"' r;f 8 g "" "" c;jrj ~. '" '" ~ ~ ~ ~ o o '"' ~ ~ or) o g ~ o o '"' ~ o o ...,. ...,. ~ 't o ~ -6 2 ~ ~ ~ ~ 0 ~ ~ f- Z ~ 5 o U..l ~ ~ 2 u U f- ~ ~ ~ ~ ~ :>:: ~ ~ ~ ~ ~ ~ ~ t ~ ~_~ ~ ~ ~ ~ S ~ j d ~ ~ ~ ~ ;;: f- ~ ~ ~ ~ ~ ~ ~ ~ 9 ~ ~ :... :>:: '" o 0 t; t ;2 ;2 f- f- '" '" '" U..l [.lJ U..l t;; f- t;; ~ ~ ~ U U U ::l ::l ::l :>:: :>:: :>:: f- f- f- o o '" .., ~ g ~ ~ ~ '" '" ffi w ~ ..J g 6 ~ ~ :E :I: x ~ ~ o o o ,..; o o '"' r::' g .0 ~ ~ ~ 0 ~ _ :>:: ffi ffi ~ ~ ~ ~ ~ U CI '" c.. ~ ~ ~ CI f- Vl ~ :i g <Xi g 00 ~ ~f ..J -< :>:: ~ b ~ ~ ~ a ~ ~ ;;; :J ~ ~ c:l f- ~ ~ ~ ~ : ~ M : : ~ ~ ~ ~ ~ ~ ~ E ~ : ~ ~ ~ ~ o o '"' <j o s; ~ ~ (!2 o 0 o 0 '" ...,. C'i ~ o ~t o R ;;j o ~ ~ o o "" ,..; '"' o o ~ o o 't 't o g ~ o ~ ~ o o "" -6 o 0 o 0 't ...,. o o o ~f o g ~ o g ;:f 8 ~ 8 ~~~ o o o ~ o o o ~; o o o -6 o o o -6 8 ~ 8 ...0 C'f') ~ o 8 -6 o g -6 o o o "i g N g ~ 8 8 M~v{;2 o o o "i o o o N o g 00 8 00 g ~ 8 oo~ ~ .,-\ o g 00 ~ ~ Q ~ :>:: ,u.: ::i 5: ~ 8 z >- < f- :2 U :r u UJ Vl Cl i;; ;2 :>:: '" CI U..l ..J ~ 5 ~ ~ 8 2 U1 ~ tI1 g ..J ~ t; 8 :>:: 2 ..J r:- i;; U..l ~ ~, ~ ~ ~ ~ ~ 5c~~8 o g vi o o o vi o g vi 8 8 ~ ~g~ o o o .,.; 8 ~ v)N ~ o g vi o o o .,.; o o o vi o o o .,.; g g g ~ g ~ o o o .,.: o o o .,.; g vi o o o vi o g vi 8 vi g ~ g ~ ~ ~ o o o .,.; g g g~ o o t- g g g~ ~ 8 g ~~ 8 g g ~ g g ~ ~ g g ~ 8 8, g o o 0-: o 0 8 g ~ ~ g g ~ o 0 8 g g t;~ ~ g g ~ g ~ g ?j 8 g ~ ~. o o t- ,.... 8 g g ~~ o c g ~ ~ ~i o 0 8 g g~ '" .., t- 0 .., 5 :>:: ~ ~ "" ~..J <..; UJ I:'- ~ z Q! 0 i::c~s >U;2~ f: ~ G U 1;: 0;: ~ 8 ~ g, o s; '"" g ,.... ~ ~ ..:;) ..c ~ :2 o o r; o o o o o ~ o ~ ~ ~ > 5 f- ::r: ~ ~ .-:: ~ U ~ U..l :2 -< U 0:: "" f- Z w U..l U ~ VJ U ~ ~ ~ ;:- o U 0 0 0 0 " N N N ~ ~ 0 '" 8 ~ 0 ~ 0 0 ~ 0 0 g ~ 0 0 0 0 a- '" .... N N ~ ~. 12 ~ ~ ~ N M ~ M 0 '1' '" 8 0 N ~ g '" ;:i 0 N 0 0 ~. 0 '" N 0 '" ~ 0 0 0 0 0 0 0 00 00 '" ..0 ..0 g g 0 N 0 g 0 ~ 0 ~ 0 0 0 0 0 a- .... .... 0 ~ 00 00 00- 00 ~ ~ '" ~ 0 0 0 ~ 0 0 0 ~ ~ 00 00 00 0 r::: r::: r::: r::: r::: r::: '" 0 0 0 0 0 ~ ~ 0 0 0 ~ a- .,. 0 ~ ~ ;;; ~ ~ '" 0 ~ 0 ~ '" 0 ~- ~ N ~ 0 0 0 ~ 0 0 0 :?, 0 0 0 ~ ~ ~ N 0 .,: ~ ~ ~ ~ ~ ~ N 0 ~ ~ 0 ::: a- 0 ~ ~ ;i '" ~ ~ 0 ~ ~ 0 :i ;;; 12 '" 0 ~ 0 0 ~ 0 ~ 0 0 0 0 0 0 0 0 g 00 00 0 ~ ~ ;:i ..0 g ..0 ..0 ~ ~ 0 0 0 0 ~ N N 0 N N ~. 0 ~ ~ ~ 0 a- ~ 0 '" 0 ;:::; ~ ~ 0 N .... .... N 0 0 00 ~ ~ 0 ~ ~ 0 N 0 ~ 0 0 0 ~ 0 0 0 .... 0 0 0 0 0 ~ 0 .... 0 .,. " ~ ~ ::: ;;; ~ ~ 00 00 00 8 0 '" 0 0 ~ ~f ~ ~ 0 0 0 '" 0 0 ~ N ...J Vl ~ ~ ~ :?, ~ ~ ~ ~ 0 :?, ~ '" ~ ~ ~ 'n ~ ~ c.. s: N '" - l:.J o! :x: ~ ::E r :J t.l ;:: ...J UJ ::E ;:: ...J i? ~ ;:: ...J ~ z ~I " UJ <: r ~ ~ <: <: ~ l:.J ~I o! Iii c..: f- ~ ~ ~ <2 ::E c..: f- (J) c.. ~ <: :::E c..: f- t..: :::E o! :::E ~ :<: Sl '" ~ ;:J ~ ~ (J) UJ c.. o! UJ ~ 1;; :::E 0 ;;.. f- a ~ l:.J 1;; :::E 0 o! UJ ::E 0 ~ u Vl UJ Iii ~ f- ~ E f- UJ f- t...~ f- f- ~ 5 - o! -< 2 ~ :::E o! UJ c:l ~ o! <: o! Vl f- c:l ~ ~ 2 :..G UJ Vl UJ c:: Vl >- <: 0 ~ 1;; UJ Vl ~ 0 ::E 0 0 >- UJ Vl ~ :x: ~ o! Cl >- Iii ~ :x: 1;; 2 ~ UJ f- I- UJ c.. :::E z 1;; ...J :J f- f- 5 Vl z 1;; f- <: Vl o! f- :..G l- S? ~ :2 E: Q 0 Q f- 0 1;; 0 ::> o! 0 0 ~ ~ u ~ ~ 0 l:.J UJ UJ ...J 0 I- 0 ~ ~ f- ~ Q 0 ~ u E: Q <: Cl UJ Z 0;: 0 Vl Vl Vl c.. ~ 0 CIl z <2 u ~ UJ > UJ :J UJ ;:; ::> ::> ::> Ci :J " f- S U ~ U ...J ~ ...J Cl f- I- Cl Z Z -J ~ ... ~ <: ~ N <: :;: ~ -J ~ ~ ;Ii ;!; f- 0 UJ UJ ...J 1= :;: ~ ~ UJ ~ ~ ...J UJ " c:l co c..: ::; o! 0 0 Cii o! o! Iii co ~ " 0 "., ~ ~ 0 '" " '" 0 ~ ...., ...., oil 0 '" ;;: 0 0 '" ...., ...., 0 0 ~ '" '" '" 0' 0' .,. N ~ o <:> ~ g ~~ N o N g ~ ~i N N o N o 0 g ~ 00 ~. -c N o N g ~ ~~ o 1'1 o N g 2 ~ ~ '" o N ~ ~ 8 *~~ 00 ~ ~ ~ ~~ r-- ~ ~ 8 ~~ V) o 1" ~ g ~ ~ o N ~ ~ ~~ .,. ~ g g : ~ ~ g ~ ~~ o 0 o ~~ o 1" ~ 8 g :~~ ::: o 1'1 ~ ~ ~ :-~ '" o o N g ~ ~ ~f o o 1" o ~ r-- ~ ~ r-- o o N ~ ~ ~ ~ -0 o o o x ~ ~ o o 1'1 g ~ ~ r:: Vl ...l <( f- o f- '" 5 5 0' 0' UJ S ~ G:i i= oc > 0 UJ ~ ~ i: ~ 2 2 ::l ~ C5~~_~~ o 0 u-<: " ", '" c.. ~ ...: ~ ~ :2 ~ ~ ~ ~ ~~~M o g ~ ~ ,., ~ ~ ;s~ g ~. ~ ~ x> oo~ ~ ~.~~~ ~ g ~f '-0 o o V) ;;: ~ ~ ~ ~ ~ ~ ~ ~~ ci ~ ~" ~ ;2 g g ~ 8 og-D~ ~ N g ~ ~ N ~ ~ s ::; ~ ~- ~ g ~ ~ ~:;:OtioQ o o o ~ ~ :::' oc oc c: ~ ~ ~ oc t:J ~ ~ z ~ -< g It 6 ;; oc t;; ;;; ~ ~ o o or) ~ o ~ ,..; ~ t o o 00 ~ o o o ~ ~ ~ g~ o o r-- ~ o o o o ~ ~ o o r-- ~ o ~ o o .,. r-- ...l 3 ;:: (:) 0 f- f- o 0 z ~ 2 ...l "'- ~ ;:: ~ ~ ~ ::l & ;2 ~ o :c u o ~ ~ o o '" 0: 00 o o 1'1 :2 o g ~ o o -0 ~ o o -0 ~ ~ ~ ~. ~ ..: o o 00 ~ o ~ ~ o ~- o o -0 ~ o o 1'1 ~ ~ :! o o o ~ o o "'. o o ~ o o C' ~ ~ ~ ~f ~ o ::: ;i o o -0 ;;: o ::: ~ o g ~ o ~ ;2 ~ ~ ;:~ ~ o o N 1" o o ~ o ~ ~; o o o ;3 8 ~ o o -0 ~ ...l <t. f- o ...l r- -< o b ~ ~ oc 0 UJ z ~ 2 ~ i: Vl :J ~ ~ o 12 ~ o o r-- g:" ..: o g ~ o o 1" ~ o o C' ~. o ::: ~. o ~ 00 r-- o o ~ o o ~ o Si. or) ..,. o ~ -0 o o ~ o o o ~ o o '" ~ o o C' ~ o o ~ o o ~ o g ~ ~ ~ o o .,. o ...l <( f- o f- ...l <( ~ z z <( Vl o z 2 ::::l <( o <:> ~ ~ ~~ ~ 8. ~ ~ ~ ~ ~ S ~ g ~ ~~ ~ g ~~ ~ ~ ~~ ~ ~ ~~ g g C' V) ~ ~~ ~ ~ ~~ ~ 8 ~~ N ~ ~ ~~ ~ ~ ~ ~~ ~ ~ ~~ ;i ~ ~ ;;;~ ~ ~ g ~. ~ ~ ~ ~ 8 ~ ~g o o ." r-- '" ~ ~ ~~~ ! ~ 8 ~ ~ ~ g ~ ~ ~ ~ ~~ ~~~~~C'iC'iM~~ <( g ~ = ~ ~ ~:"'~ ; ]1 .,. .. :-: N N UJ o ;; ...l 0 <( z Vl ~ o "'- 2 ~ ~ ~ t:J 0 a3 Gi o z <ii z G ~ ~ ~ ;2 ~ ~ t; -< c: ~ ::z:: 5 ::0 -< 0' 0 t.T.J UJ <( ~ ~ ~ ~ 8 ~ ~ ~ ~ ~ ~ ~~.~~~~~~~ -: r-i z o 1= ~ ;2 ~ ~ 1;; :# c.. ~ ~ g~5 t:J <( UJ ~ S! 8 :J ...l oc 2 2 t;; ~ ~ 5 0' t:J Vl ~ ~ ; ~ I-- 5 z 0' Ul UJ ::0 0 ~ Z ::J 02 O'UJ l!::! UJ g G ...l Z al UJ z o 6 1= 1= z ;2 ~ ~ g i ~ ~ ;2 ::0 5 ~ t;; 0 0' _ <( UJ ~ ~ frl ~ ~ f- f- ~ :< z Vl o ...l ~ ~ ~ ~ i: ~ :J ;; ~ al i: 1= oc ~'u ~ 2 o 0 ~ N a ~ g ~ ~ ~ ~ ~. ~ ~ 00 M f"i f- Z UJ f- t ~ 5 ~ 0'5 ~ 0' ...l Ul ...l ~ ffi < ~ ~ ~ 000 2 ~ 2 ~ ~ ~ UJ t:J UJ Z Z Z UJ t:J t:J 000 g ~ g ~ ~ ~ ~ ~ ~-:~~~ .; g ~ ~ ~ g ~~.~~~ 000 o 5 z z z "'- 2 2 o 2 i: i: i: 5 ~ ::::l :J :J E d3 ~ ~ ~ UJ U oc oc Ul .J Vl ~ UJ ::5 ;2alf-<(:::",- = 25 ~ ::: ~ ~ o g 8 g C' - ; ~ ~~ o o o ~ ~ ~ N o z 2 >- f- :J ~ oc 0 ~ ~ t:J Z ~ 0 6 ~ t;; ~ ~ UJ ::0 <:l.. 5 0' 12 Vl Ui g G:i > >- f- :J ~ EQUIPMENT & BUILDING INVENTORY CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2004 CURRENT REPLACEMENT UN I T # YEAR MAKE MODEL COST FIRE DEPARTMENT 102. 1989 FORD L9000 TELE-SQUIRT $240,000 103. 1982 LUVERNE PUMPER 225,000 104. 199] PETERBI L T HEA VY RESCUE 190,000 105. 1998 FORD CROWN VICTORIA 22,000 106. 1998 CHEV LUMINA 2],000 107. ]993 PETERBIL T PUMPER 225,000 108. ]995 CHEV 4X4 LITE RESCUE 25,000 109. 1972 STUPHEN AERIAL TRK 750,000 110. 2000 FORD CROWN VICTORIA 24,000 ] 10. 1997 FORD CROWN VICTORIA 20,000 POLICE DEPARTMENT 200. 2004 FORD CROWN VICTORIA $28, ] 00 201. 2004 FORD CROWN VICTORIA 28, I 00 202. 2004 FORD CROWN VICTORIA 28, ] 00 203. 200] FORD CROWN VICTORIA 26, I 05 204. 2001 FORD CROWN VICTORIA 26,000 205. 2000 FORD CROWN VICTORIA 24,000 206. 2002 FORD CROWN VICTORIA 28,000 207. 2002 FORD CROWN VICTORIA 28,000 208. 200] FORD CROWN VICTORIA 26,105 209. 1999 FORD CROWN VICTORIA 22,000 2]0. 1998 CHEV GEO TRACKER 14,000 212. 2002 CHEV TAHOE 26,000 213. 2003 CHEV IMPALA 25,000 2 ]4. 200] DODGE INTREPI D 20,000 215. 2002 CHEV IMPALA 18,800 2] 7. 1999 FORD TAURUS 17,000 218. 2000 CHEV IMPALA 22,000 2]9. 1979 FORD VAN 20,000 241. 2001 CHRYSLER PT CRUISER 18,000 252. 1972 H.M. TRAILER 3,000 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2004 CURRENT REPLACEMENT UNIT # YEAR MAKE MODEL COST STREET/TRAFFIC DIVISION 300. 1995 FORD 1/2 TON $13,000 301. 1997 CHEV 3/4 TON 21,000 304. 2000 FORD F-450 34,000 305. 1997 FORD 1/2 TON 18,300 306. 1992 CHEV 4X4 1 TON 22,000 308. 1989 CHEV 1 TON DUMP 23,000 309. 1995 CHEV 1 TON TRK 28,000 310. 1989 INTERNA TIONAL SGLAX DUMP 70,000 311. 1985 INTERNA TIONAL SGLAX DUMP 70,000 313. 2000 FORD L 7501 72,000 314. 1998 FORD L T 8500 86,000 315. 1996 FORD L-8000 85,000 316. 1995 FORD WATER TRK 318. 1968 FORD BOOM/AUGER TRK 320. 1991 CA TERPI LLER LOADER 926E 90,000 321. 1990 CA TERPILLER LOADER 936E 120,000 324. 1989 NEW HOLLAND SKID LOADER 24,000 325. 1998 JOHN DEERE SKID LOADER 24,000 326. 1989 CA TERPI LLAR 140-G 82,000 327. 2001 ELGIN PELICAN SE 105,000 330. 1989 INGERSOL/RAND ROLLER DD-25 23,000 334. 2003 GRACO GM 3500 4,500 337. 1994 CA TERPILLAR BOX PAVER 18,000 338. 1984 STONE CEMENT MIXER 3,000 342. 1991 TARGET CONCRETE SA W 2,400 344. 1996 SNOGO WK 800 58,000 345. 1989 M-B-W VIB PLATE 2,000 346. 1984 WENGER STAGE TRLER 8,000 348. 1989 TRAIL-KING TK6V -1200 3,000 349. 1989 TRAIL-KING MK6V -1200 3,000 350. 1995 TOWMASTER T14 4,000 351. 1943 POLE TRAILER 500 352. 1996 HOMEMADE TRAILER 1,400 I I CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2004 CURRENT REPLACEMENT UN IT # YEAR MAKE MODEL COST FLOAT VEHICLES 407. 1998 FORD TAURUS $16,500 701. 1996 FORD TAURUS $6,000 ENGINEERING DIVISION 700. 2000 CHEV SUBURBAN $14,500 700A 1987 FORD ENG. VAN 20,000 BUILDING & EQUIPMENT SERVICES 703. 1999 DODGE RAM 4X4 $18,000 704. 1991 CHEV 1/2 T S- 1 0 11,000 705. 1988 CHEV 3/4 T TRK 11,000 708. 1998 JLG PERSONAL LI FT 2,800 PARKS/FORESTRY DIVISION 800. 2001 FORD RANGER 4X4 $18,000 801. 1996 CHEV 4X4 TRK 19,100 803. 2004 FORD F350 19,000 804. 2004 FORD F350 19,000 805. 1998 DODGE RAM 3500 24,000 808. 1988 CHEV 1/2 T TRK S- 1 0 2,500 810. 1993 INTERNA TIONAL LP 4700 50,000 811. 1987 FORD LOG TRUCK 83,000 812. 1989 FORD AERIAL LIFT 85,000 816. 1984 FORD TRACTOR 2910 22,000 817. 1982 FORD TRACTOR 2610 22,000 818. 1996 TORO TRUCKSTER 13,000 819. 1987 CUSHMAN HAULSTER 5,000 820. 2004 TORO WORKMAN 3200 15,000 821. 2004 TORO WORKMAN 2110 7,900 822. 2001 TORO 325-D MOWER 18,000 III CITY OF HOPKINS VEI-IICLE/EQUIPMENT INVENTORY 06/15/2004 CURRENT REPLACEMENT UN I T # YEAR MAKE MODEL COST PARKS/FORESTRY DIVISION (CONT.) 824. 1996 TORO GROUND MASTER $16,000 825. 2001 TORO 455-D MOWER 40,000 826. 1994 GO- FER P-35 5,000 827. 2004 TORO Z587L 8,200 828. 2001 DEW EZE A TM72 21,000 830. 1987 OLATHE TURF SWEEP 8,500 832. 1997 VERMEER STUMP CTR 630A 15,400 834. 1993 BRUSH BANDIT CHIPPER 250 14,000 836. RYAN SOD CUTTER 2,000 840. 1991 VICTORIAN TRAILER 2,000 843. 1975 H.M. TRAI LER FL TBD 2,500 844. 1973 CANOE HM TRAILER 1,000 845. 1997 REMACKEL TRAILER 5,000 846. 2001 DRESSEN 8110 2,000 HRA 411. 1995 CHEV 3/4 T 4X4 $17,500 W A TERlSEWER 500. 1997 CHEV C 1500 $17,000 501. 2004 CHEV 4X4 3/4 T SIL VERADO 19,000 502. 1993 CHEV 1/2 T PICKUP 12,500 504. 1996 JEEP CHEROKEE 18,000 505. 1992 CHEV 3/4 T 4X4 16,000 508. 1996 CHEV 3/4 T UTILITY 18,000 509. 1997 FORD F250 22,000 530. 2001 STERLING V AC-CON 180,000 533. 1993 CA TERPILLAR LDR-BKHOE-446 50,000 534. 1997 KOHLER GENERA TOR/TRL 11 ,000 535. 1992 KOHLER GENERA TOR/TRL 10,000 536. 1989 FLEXIBLE ROODING MACHINE 25,000 540. 1982 SULLAIR AIR COMPRESSOR 12,000 541. 1981 WACKER TAMPER 2,000 542. 1994 WACKER TAMPER 4,000 IV CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 06/15/2004 CURRENT REPLACEMENT UN I T # YEAR MAKE MODEL COST REFUSE 900. 1994 PETERBI L T RAPID RAIL $160,000 902. 1999 VOLVO WX42 150,000 903. 1977 FORD PAC-MOR 56,000 PAVILION 807. 2003 OL YMPIA ICE RESURFACER $85,000 V Location/Description City H a \I 1010 1st Street S. Hopkins Activity Center 33 14th Avenue S. Ice Arena/Pavi I ion 11000 Excelsior Boulevard Arts Center 1111 Mainstreet PW Admin/Garage 11100 Excelsior Boulevard PW Cold Storage Bldg # 1 117-121 17th Avenue S. PW Cold Storage Bldg #2 117-121 17th Avenue S. Barn 117-121 17th Avenue S. Moline Reservoir 916 County Road 3 Blake Tower Reservoir 151 Tyler Avenue S. Well # I Filtration Plant 916 Excelsior Boulevard Fi Itration Plant 1401 Elmo Park Service Road Well #4 140 I Elmo Park Service Road Well #5 1205 H ighway7 Well #6 80 I Highway 7 CITY OF HOPKINS BUILDING INVENTORY July 2003 Replacement Cost $1,957,000 721,000 2,266,000 3,500,000 952,750 190,600 278,000 118,500 779,000 443,000 680,000 587,000 80,000 64,000 63,000 VI Location/Description Lift Station # 1 - 21 st 202 21 st Avenue N. Lift Station #2 - Drillane 619 Drillane Road Lift Station #3 - Lindee's 901 Cambridge Street N.E. Li ft Station #4 - L TL Meadowbrook 244 Meadowbrook Road Lift Station #5 - Big Meadowbrook 6601 Excelsior Blvd. Lift Station #6 - Ronnie's 1029 Excelsior A venue E. Lift Station #7 - Valley 801 6th A venue S. Park Building-Beach-Lifeguards 5200 Shady Oak Road Park Building-Beach-Concessions 5200 Shady Oak Road Park Bui Iding-Beach-Restrooms 5200 Shady Oak Road Park Shelter - Beach 5200 Shady Oak Road Park Shelter - Burnes 201 Park Lane Park Building - Central 101 1 7th Avenue S. Park Building - Harley 108 Jackson A venue S. Park Shelter - Interlachen 220 Homedale A venue Park Building - Oakes 301 Tyler Avenue N. Park Building - Valley 800 7th A venue S. Replacement Cost 70,000 20,000 50,000 100,000 150,000 70,000 135,000 21,700 24,000 27,000 16,000 27,000 70,000 12,000 9,000 9,800 10,300 VII Location/Description Dow Towers (76 Units) 22 5th Avenue S. 20th Avenue Townhouses (10 Units) 29 20th A venue S. Parking Ramp 1 Oth Avenue and Mainstreet Depot Coffee House 9451 Excelsior Boulevard Overpass Skate Park 100 Washington Avenue Replacement Cost HRA HRA 1,740,000 277,560 VIII