Loading...
2008 - 2012 ERP C\TY 0/= IiOPKINS Equipment Replacement Plan 2008 - 2012 ~LZiiii ~~ ...-c-.<?'L/.c-.c- - \ \,:111 I -.." r --J .. .~- ._~ - . - -. -- "! ,~~~-J' : ~~~ . I~- -- ~3~ ~ EQUIPMENT REPLACEMENT PLAN 2008 - 2012 Back2found The Equipn1ent Replacen1ent Plan is a twenty-year forecast and a five-year plan of equipment needs in the City of Hopkins. It is intended to inform the Council and citizens of the n1ajor equipn1ent needs on the horizon. The first year of the plan becon1es an adopted equipment budget and relates to the operating budget of the equipn1ent replacelnent fund, which is approved on an annual basis. The relnaining nineteen years represent an estimate of equiplnent needs and funding capabilities of the City. Funding requirements vary frOln year to year. In order to maintain a fairly consistent levy each year, the twenty-year schedule is projected with a 30/0 inflation factor for operating expenses and a yearly average dollar capital expenditure of $732,800. The cash flow requiren1ents to fund the equipn1ent needs in the equiplnent replacen1ent fund, will experience a roller coaster effect over the next 20 years given the projected equipn1ent needs and 3% inflation rate. Available funds will relnain about the same through the year 2009, decrease for approxin1ately five years before increasing again in preparation for replacement of some n1ajor fire and police equipn1ent in 2018, and 2020. It is anticipated that the intragovernn1ental charge to the general fund will need to increase each year to replace funds lost when charges to city funds was reduced in 2003 in response to aid cuts. If the rate increases proposed are in1plemented revenues in 2015 will have retun1ed to 2002 levels. The charges after 2015 will continue to increase each year, but at a slower pace. The future increases in charges to the general fund should provide sufficient funds to calTY us through 2027. Each year staff reevaluates the equiplnent needs and adjusts the schedule accordingly. Changes to the plan are reflected in the docun1ent. Refurbishn1ents, extended life expectancy and closer cost estimates of replacelnents have been incorporated into the plan. The equipn1ent replacement charges in the general fund represent approximately 30/0 of total general fund expenditures. Future increases each year are needed to fund the equipnlent replacelnent plan without issuing debt. The Equiplnent Replacement Plan's basic prelnise is scheduled replacelnent of present equipment. A new iten1 n1ust, in the year proposed, be presented in the annual operating budget with a stipulation that replace111ent will be necessary in the future. Flexibility of the Equipn1ent Replacen1ent Plan is established through annual review and revision, if necessary. Highlights of changes fro111 last year's equipment replacement plan for the years 2008-2012: City Hall: Main copy 111achine lease was renewed for 36 n10nths at a significant savings. Plans call for the purchase of a new copier in 2011. Fire: The 100ft aerial ladder truck scheduled for replace111ent in 2008 at an original cost of $900,000 was reduced to $600,000 in 2007 in an attempt to secure federal grant funds. After two unsuccessful attel11pts to obtain a federal grant, alternative financing options were explored. The fire department researched various options for replacen1ent of the fire truck, detelmining that our best option for replacelnent would cost approximately $900,000 the original amount budgeted. ERP funding was increased to $450,000 for 2008 and the ren1aining $450,000 will be financed with a lease or improvement bonds. Lite rescue truck replacement cost was increased by $5,000 due to inflation. The truck is scheduled for replacement in 2009. Fitness Center - the life of the elliptical machines were extended from 5 to 6 years, the Stairnlaster and weight equiplnent originally purchased with grant funds was previously not included in the ERP. Two automated external defibrillators were replaced in 2007 with funds fro111 the fire department budget and need to be included in the ERP for future replacen1ent. Both are replaced at one tin1e due to changes in technology. Police: The sergeant's squad car originally scheduled for replacement in 2010 was pushed back to 2011 as it was purchased new in 2007 and the expected life of this vehicle is 4 years. The six Inarked police vehicles were evaluated and the replacement schedule was adjusted based on target mileage levels of vehicles. The police utility 4x4 vehicle was evaluated and the replacen1ent n10ved back one year to 2009 due to an engine replacement. Digital squad car cameras purchased in 2006 with police departn1ent funds have a life expectancy of 5 years. They were added to the ERP in 2008 for replacelnent in 2011. Tactical ballistic vests WOll1 by the Police HEAT teanl offer the officers a higher level of protection against weapon assaults than regular duty ballistic vests. In the past federal and state grants have been available to assist in the purchase. WalTanty on the current vests expire in 2007 and will need to be replaced in 2008. Grant funds will be applied for but are not guaranteed. The police con1puter system budgeted at $700,000 in the previous ERP was reduced to $500,000 to better fit within the overall ERP plan. The exact cost of the replacenlent is unknown and our best esti111ate was used in placing this item in the ERP. Public Works: The lives of the equipn1ent are annually reviewed by the public works department and over the past 10 years they have extended the lives of the I-ton trucks frOl11 8 to 12 years and the dump trucks from 13 to 15 years. Extending the lives of major equiplnent comes with the risk of increased n1aintenance costs. When maintenance costs become ul11nanageable the equipment will be put on the schedule for earlier replacement. Equipn1ent Service Move 4x4 ~ ton truck up by one year from 2009 to 2008. The truck is used for light hauling by various divisions of public works. The fire departl11ent is in need of a used light duty truck for use by daytin1e responders. When replaced this truck will be transferred to the fire depal1n1ent. A hot water high-pressure vehicle washer used to wash city vehicles is 12 years old and needs to be replaced. The item was originally purchased with public works departn1ent funds and has been added to the ERP for 2008. P arks/F orestry The cost of the swap loader was increased from $55,200 to $76,000 to reflect actual cost. The vehicle is scheduled for replacen1ent in 2008. Water Air con1pressor was 1110ved frOln 2012 to 2008 to replace a 1982 unit with a larger capacity due to larger irrigation lines. Plans are to purchase a new or slightly used n1achine. EQUIPMENT REPLACEMENT PLAN 2008 - 2012 TABLE OF CONTENTS Page SECTION I Capital Equipment Five Year Funding Summary Department Summary Projects by Department Funding Source Summary Projects by Funding Source Projects & Funding Sources by Department 2 3 4 7 8 10 Item Requests/Justification Art Center Cable TV City Hall Administration Community Services Fire Police Public Works: Bldg/Equipment Services Public Works: Parks/Forestry Public Works: Streets/Traffic Refuse Sewer Water 14 15 16 19 23 33 43 45 53 60 61 62 Twenty Year Equipment Replacement Schedule 65 S ECTI ON II Equipment and Building Inventory 70 Vehicle/Equipment Inventory Building Inventory 71 75 CAPITAL EQUIPMENT r- o~N a:: 0..... 000 ;:;N CO r- ~ ~V::: r--.OO ;:;N CO r- ~O ~V..... r--.OO ;:;N CO N o e r- ~O\ ~OO If) 00 ;:;N CO o z ;:; t... r- Z ~ ~ ~ U ~ ..J Q.. ~ 0::: r- Z ~ ~ Q.. - ;:; 01 ~ r- ~oo ~OO If) 00 ;:;N co r- ~r--. ~VO 000 ;:;N c:o ..J ~\O ~;:;O ~r-O UN ~ ..J ~If) ~;:;O Or-O UN -< ~ ~.Ij ~ ..:::: U ~ ~ Cl::: ("') ~ ~ ("'") 1..0 ~ o If) ("'") ~ 00 ~ r--. 00 r--.~ o O~ ("I ("'") 00 00 If) O~ ("') 00 \O~ If) r--. ("'")~ If) r--. ("1 If) N~ \0 r--. 00 o~ o r--. 0\ If) 0\ vi o o~ ..... ro Q) >- c: 'en Q) CO ~ 0. ro U OJ) c: :.;;2 o :3: Vl c: c: C ,~ ,~ t'V ';; ';; 0 Q) ell t'V t'V Q) Vl C Vl Cl.I ~'7~~~ ~~ ::::c:d~~ ~~ ~~~l-.DVl~O::: ~~~E-E~~-; ~ ~ "2 ~ '(i) ~ ..c '0 E-E-lL..~e:::.50r- r--. \0 I,t;) 00 0\ ("'") 0("'") o ~ 0- o~("'") N -.:r N -.:r N I,t;) ~ 0("'") o ~ o~- 0("'") N -.:r ..... r--. 00 ("'") ~ 0("'") o ~ 0- o~("'") N If) If) If) v!; ..... ~ 0("'") o ~ o o~ ("') N ..... 00 -.:r~ ..... o ~ 0("'") o ~ o 0("'") N o o o o If) ~ If) N ~ 00 N 1..0 o 00 r-: ("') 0\ 0 - 00 0 ~ -.:r 0 ("1 000~ 000\0 N - ("~ 000 NO 0 0\ 0 0 v!;o ~ If) 0 0\ N - ell "'0 Cl.I c: CJ);:j \..,lL.. ~- .:: ro (,J ..... ~ (i) o ,::: Q) ,.... Vl @ t'V 0 ~....:J >-. ro Q) .<::: ...::.:: 0.0 t'V 0 U:r: E o ..:: ell Cl.I ..... ~~ Cl.I ~ ~ ~ O::E- 1..0 N 0 00 00 1..0 0 t- \0 1..0 ("'") ~ vi ("1 ~ 00 O\~-o 0\ E ~ Vl >-. r/) o :.0 ro e::: ~ 0 -.:r ("'") 0 -.:r o 0\ o If)~ v!; If) C"l 0\ -.:r 00 0 I,t;) r--. 0 -.:r ("'") 0 0\ o\~.r)~ ~ ("I If) -.:r - 0 0\ ("lOr--. 1f)0~ o~ If)~ ~ r--. N If) -.:r NOO r--. 0 r--. -~ o~ 00 If) v) r--. ("I ~ -.:r o 0 -.:r 00 0 0 o 00 1f)0~ \0 N If) 00 00..... o 0 ~ 000\ o If)~ ~ ~-r--. -.:r - If) \0 0\ If) \0 ~~~~6 -~.... If) ,--..., Vl t) Vl Vl ro 4- o Q) "'@ ~ Vl on c: E ro <l) ("') r--. ("'") ~ 00 If) ~ ("1 ~ N ("i ~ o ("I o o ~ If) If) 00 00 ("'") ("') ("I r--- r-: ("'") N \0 o r--.~ ("I 1..0 o \O~ N ,--..., ....: 0. Q) a ,--..., ("'") N o ~~ ]~ ...0 (l)~ r;~"2 <Il c: U ~ E @ (l) >-. c: c<l~t;:; t ~~ 8 .~ 2 -g ~ ~ ]~~ <Il ...::.:: 4- (l) U 0 ;:j Q) ;2 ~ g R~~ ~ ~ co <Jl Q) "'0 ;:l o X ~ Vl <l) ~ :.0 c:: Q) 0. X CD If) 0\ If) N~ ~ o o ~ ..... r--. \0 If) 0\ If) N~ ~ o ("'") o If) r--. r--.~ o If) o 00 -.:r ~ If) 0\ If) N ~ o \0 o o 00 v!; O\~ 00 \0 00 0\ If) 0\ If) N~ ~ o If) o ~ 0\ o ("1 ..... 0\ -.:r ~ 00 If) 00 If) o 00 1..0 o ~ I..O~ If) 00 r--. ~ \0 00 ("'") 00 N r--. 0 ~ v!; ("1 \0 ~ 0\ N If) N ("'") r--. 0\ .... r--. o 0 o r-: ~ 'n ~ ("'") r--. \0 0\ 00 If) ~ ~I..OI..O o ~~ ...0 -.:r If) r--. 00 c Cl.I ,--..., E C Q.t'V ._ 0 ::::::=., $c o . .... .- ~ > _ ro -~ :: 0 0.... - ..... .~~ Q.C: ~ ro U~ 1..0 ("I 0\ r--.~ If) r--. o I,t;) If) N o N ~ -.:r If) M \0 -.:r o If) ~ ~ 00 -.:r r--. 00 r--.~ ..... o q N ~ 00 00 If) q ~ 00 \0 v) r--. l"l If) t- .... N If) N~ \0 r--. 00 o o r--. <l) (,J = ~ -; co CJ) = :0 c:: ~ ~ '5. ~ U CJ) = :.;2 \.., o ~ ~ ~ I,.) 0\ 00 0\ If) o 00 1..0 N If)~ \O~ 00 00 ~ ~~ ..... ..... .....~ 0\ 00 o ("I \0 ~ .r) O\~ ("') ~ ~ f"") ~ 0\ ~ ~ 0\ - o r--. \0 If) If)~ ("1 'n - ~ ~ ..... "'~ \C I" .....~ 0\ ~ o \O~ r--.~ If) If) r--. - ~ 0\ '" .....~ 00 I" ~ 0\ r--. o If) \0 00 'n 00 0\ - f"") ~ ~ 00 ~ ~ .....~ 0\ 0 00 \0 0 'n~ ("1 ("I '" f"") 0\ ~~ ~ f"") .....~ 'n ~~ ("~ If) ("I 0\ 00 ~ I,.) ~ ~ ~ \0 If) 1..0 ("1 ("I \0 ~ ~ ~ ~ ~ c ~ ;;. t'V 0. ~ c: ro o Q)....:J :DE ~ <Jl '(i) g ~co e::: >-. ~E~ o ~ g ~E-:r: ~ ~8 ~OO ~....:JN ..:::: t'J C 0\ o r'l 0\ r--. 0\ \0 O\~ ~ 0\ o 0\ ("1 If) 'n r--. ("1 ~ I..O~ o ("I r--.~ r--. \O~ N If) o ~~ 1..0 ~ o If) r'l 1..0 'n 'r:.. If) ~ 0\ r--.~ N I..O~ Q) :n ro > 'Q) U Q) e::: E- ....:J + Q) U c: t'V "'@ co ..c Vl ro U 2 "'0 Q) Q) c: '~ ~ -5 c ::l o E ro <l) <Jl -5 c Q) E Q) l- '3 CT Q) ..... i:: Q) E >-. ro 0. OJ) c: .5 'g ~ ,::: tE "'0 c: ~ o o o o~ If) ~ U"} 4- o 0.. e::: CD "'0 Q)~ t) ::l OJ) ,.... "2 ~ .o~ i:: - ::l <Jl o t'V E t'V Q) -5 c::i ::: Vl ro [i c Q) ::: 3 :2 ]Ui ~ @ Ul 0. 'S u ~ .... 0. Vl Vl o o o o o 0\ U"} 4- o OJ) c: 'u c ro c: Ul ~ 8 0 "'00 <l) 0 ~o ,~ ~ Q) I "'0 Q) ~I~ ~ i~~ Q) 4- Li:~ -5 '~ Vl ..... t'V Q) >-. 'n ..... ~ ~ ("I 0: ~ ~ o o o o If) ~ U"} II "'0 Q) 3 o l- o ..D C ::l :2 c: <( ~ (5 0. E ;:l Vl Vl t'V OJ) C '~ .3 :E Q) -5 Vl Q) -g o ,::: Q) > o ..D ro c: ::: o ..c <Jl N ~ 'u c: ~ t2 ...::.:: g b ~ S E >-. t'V 0. >-. (i) t-' ~ g i.i: CT City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2008 thru 2012 DEPARTMENT SUMMARY Department 2008 2009 2010 2011 2012 Total Arts Center 12,100 12,100 Cable TV 5,000 5,000 5,000 5,000 5,000 25,000 City Hall Administration 38,000 38,000 38,000 114,000 38,000 266,000 Community Services 11,040 17,540 18,900 50,900 16,500 114,880 Fire 936,000 45,000 11,000 20,300 31,500 1,043,800 Police 115,700 104,300 633,600 199,100 126,600 1,179,300 Public Works: Bldg/Equip Serv 29,100 29,100 Public Works: Parks/Forestry 76,000 174,200 32,200 26,400 141,400 450,200 Public Works: StreetsfTraffic 42,300 164,700 327,600 534,600 Refuse 176,700 176,700 Sewer 6,800 6,800 Water 23,100 12,200 6,800 42,100 GRAND TOTAL 1,233,940 426,340 1,092,300 441,400 686,600 3,880,580 Thursday, August 02, 2007 "'l j City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2008 thru 2012 PROJECTS BY DEPARTMENT Department Project# Priority 2008 2009 2010 2011 2012 Total - ---, lArts Center , Arts Center Copy Machine 01-ERP-1100 n/a 12,100 12, 100 Arts Center Total 12,100 12,100 ~---- - I Cable TV Cable/Council Chamber Cameras & Control System 01-ERP-050 n/a 5,000 5,000 5,000 5,000 5,000 25,000 Cable TV Total 5,000 5,000 5,000 5,000 5,000 25,000 lCity Hall Administration , Network Server 01-ERP-003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01-ERP-004 n/a 76,000 76,000 Computers 01-ERP-006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 City Hall Administration Total 38,000 38,000 38,000 114,000 38,000 266,000 ICo~mu~ity- Servic-e;- - "1 City Hall Main Copy Machine - Oce' Copier 01-ERP-001 n/a 2,400 2,400 2,400 14,000 21,200 City Hall Small Copy Machine 01-ERP-002 n/a 26,900 26,900 Engineering Printer/Scanner 01-ERP-007 n/a 8,640 8,640 10,000 10,000 10,000 47,2BO Document Management Scanner (2) 01-ERP-00B n/a 6,500 6,500 6,500 19,500 Community Services Total 11,040 17,540 18,900 50,900 16,500 114,880 LFire -, Lite Rescue 01-ERP-105 n/a 40,000 40,000 Stuphen Aerial Truck 01-ERP-106 n/a 900,000 900,000 Breathing Apparatus 01-ERP-10B n/a 36,000 36,000 Extrication Tool (2) 01-ERP-109 n/a 26,500 26,500 Copy Machine 01-ERP-110 n/a 10,300 10,300 Workout Equipment - Eliptical 01-ERP-116 n/a 5,000 5,000 10,000 Workout Equipment - Stairmaster 01-ERP-117 n/a 5,000 5,000 Workout Equipment - Treadmill 01-ERP-11B n/a 5,000 5,000 Workout Equipment - Weight Lifting 01-ERP-119 n/a 5,000 5,000 Automated External Defibrillator (2) 01-ERP-120 n/a 6,000 6,000 Fire Total 936,000 45,000 11,000 20,300 31,500 1,043,800 ~ice--- - -- --'I Marked Patrol Vehicles (6) 01-ERP-200 n/a 61 ,400 31,600 97,800 67,200 34,600 292,600 Sergeant's Vehicle 01-ERP-201 n/a 33,600 33,600 Utility 4x4 (unit 212) 01-ERP-203 n/a 37,700 37,700 Thursday, August 02, 2007 4 Department Project# Priority 2008 2009 2010 2011 2012 Total Police Administrative Vehicles (2) 01-ERP-204 n/a 25,600 26,300 27,100 27,900 28,800 135,700 Computer System 01-ERP-208 n/a 500,000 500,000 Copy Machine 01-ERP-209 n/a 19,100 19, 100 Network Server (3) 01-ERP-211 n/a 8,700 8,700 8,700 8,700 8,700 43,500 Mobile Data Computers 01-ERP-212 n/a 54,500 54,500 Digital Squad Car Cameras 01-ERP-213 n/a 42,600 42,600 Tactical Ballistic Vests 01-ERP-214 n/a 20,000 20,000 Police Total 115,700 104,300 633,600 199,100 126,600 1,179,300 ~--- I LPublic Works: Bldg/Equip Serv 4X4 1/2 Ton Truck 01-ERP-710 n/a 23,300 23,300 Hot Water High Pressure Vehicle Washer 01-ERP-711 n/a 5,800 5,800 Public Works: Bldg/Equip Serv Total 29,100 29,100 ~blic Works: Parks/Forestry " 1/2 Ton Pickup Truck 01-ERP-800 n/a 26,400 26,400 4x4 3/4Ton Trucks (2) Ot-ERP-80t n/a 67,400 67,400 3/4 Ton Utility Truck Ot-ERP-802 n/a 32,200 32,200 Swap Loader 01-ERP-803 n/a 76,000 76,000 Aerial lift 01-ERP-805 n/a 110,000 110,000 Tractors (2) 01-ERP-806 n/a 41,400 43,900 85,300 Trucksters (3) 01-ERP-807 n/a 19,800 19,800 Riding Mowers (3) 01-ERP-808 n/a 22,800 10,300 33, 100 Public Works: Parks/Forestry Total 76,000 174,200 32,200 26,400 141,400 450,200 lPublic Works: Streets/Traffic I 1 Ton Dump Truck (2) 01-ERP-303 n/a 37,400 34,700 72,100 1 Ton Traffic Boom Truck 01-ERP-304 n/a 75,000 75,000 Water Truck 01-ERP-307 n/a 133,700 133,700 Front End Loaders (2) 01-ERP-30B n/a 172,000 172,000 Skid Loader (2) 01-ERP-309 n/a 31,000 31,000 Roller 01-ERP-312 n/a 45,900 45,900 Trailer 01-ERP-316 n/a 4,900 4,900 Public Works: Streets/Traffic Total 42,300 164,700 327,600 534,600 'Refus;--- ----------, , Refuse Truck (RAP-R) (2) 01-ERP-900 n/a 176,700 176,700 Refuse Total 176,700 176,700 lSewer-- -- , Telephone System 01-ERP-557 n/a 6,800 6,800 Sewer Total 6,800 6,800 [Water , Air Compressor 01-ERP-503 n/a 23,100 23,100 Public Works Copy Machine 01-ERP-506 n/a 12,200 t2,200 Telephone System 01-ERP-507 n/a 6,800 6,800 Thursday, August 02. 2007 5 Department Projcct# Priority 2008 2009 2010 2011 2012 W ater Total Total GRAND TOTAL 23,100 1,233,940 12,200 426,340 1,092,300 6,800 441,400 686,600 42,100 3,880,580 6 Thursday, August 02, 2007 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2008 thru 2012 FUNDING SOURCE SUMMARY SOU ree 2008 2009 2010 2011 2012 Total Bonds/Lease 450,000 450,000 Cable Television Fund 5,000 5,000 5,000 5,000 5,000 25,000 Equipment Replacement Fund 698,840 421,340 898,400 410,700 681,600 3,110,880 HAC - Arts Center Fund 12,100 12,100 RF - Refuse Fund 57,000 176,700 233,700 SF - Sanitary Sewer Fund 6,800 6,800 WF - Water Fund 23,100 12,200 6,800 42,100 GRAND TOTAL 1,233,940 426,340 1,092,300 441,400 686,600 3,880,580 Thursday. August 02. 2007 7 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2008 thru 2012 PROJECTS BY FUNDING SOURCE SOU ree Projeet# Priority 2008 2009 2010 2011 2012 Total [Bonds/Lease I Stuphen Aerial Truck 01-ERP-106 n/a 450,000 450,000 Bonds/Lease Total 450,000 450,000 lCable Television Fund 'I Cable/Council Chamber Cameras & Control System 01-ERP-050 n/a 5,000 5,000 5,000 5,000 5,000 25,000 Cable Television Fund Total 5,000 5,000 5,000 5,000 5,000 25,000 lEql-;jpme~-t-Replacement Fund I City Hall Main Copy Machine - Oce' Copier 01-ERP-001 n/a 2,400 2,400 2,400 14,000 21,200 City Hall Small Copy Machine 01-ERP-002 n/a 26,900 26,900 Network Server 01-ERP-003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01-ERP-004 n/a 76,000 76,000 Computers 01-ERP-006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 Engineering PrinterlScanner 01-ERP-007 n/a 8,640 8,640 10,000 10,000 10,000 47,2BO Document Management Scanner (2) 01-ERP-00B n/a 6,500 6,500 6,500 19,500 lite Rescue 01-ERP-105 n/a 40,000 40,000 Stuphen Aerial Truck 01-ERP-106 n/a 450,000 450,000 Breathing Apparatus 01-ERP-10B n/a 36,000 36,000 Extrication Tool (2) 01-ERP-109 n/a 26,500 26,500 .Copy Machine 01-ERP-110 n/a 10,300 10,300 Workout Equipment - Eliptical 01-ERP-116 n/a 5,000 5,000 10,000 Workout Equipment - Stairmaster 01-ERP-117 n/a 5,000 5,000 Workout Equipment - Treadmill 01-ERP-11B n/a 5,000 5,000 Workout Equipment - Weight Lifting 01-ERP-119 n/a 5,000 5,000 Automated External Defibrillator (2) 01-ERP-120 n/a 6,000 6,000 Marked Patrol Vehicles (6) 01-ERP-200 n/a 61,400 31,600 97,800 67,200 34,600 292,600 Sergeant's Vehicle 01-ERP-201 n/a 33,600 33,600 Utility 4x4 (unit 212) 01-ERP-203 n/a 37,700 37,700 Police Administrative Vehicles (2) 01-ERP-204 n/a 25,600 26,300 27,100 27,900 28,800 135,700 Computer System 01-ERP-20B n/a 500,000 500,000 Copy Machine 01-ERP-209 n/a 19,100 19,100 Network Server (3) 01-ERP-211 n/a 8,700 8,700 8,700 8,700 8,700 43,500 Mobile Data Computers 01-ERP-212 n/a 54,500 54,500 Digital Squad Car Cameras 01-ERP-213 n/a 42,600 42,600 Tactical Ballistic Vests 01-ERP-214 n/a 20,000 20,000 1 Ton Dump Truck (2) 01-ERP-303 n/a 37,400 34,700 72,100 1 Ton Traffic Boom Truck 01-ERP-304 n/a 75,000 75,000 Water Truck 01-ERP-307 n/a 133,700 133,700 Front End Loaders (2) 01-ERP-30B n/a 172,000 172,000 Skid Loader (2) 01-ERP-309 n/a 31 ,000 31,000 Roller 01-ERP-312 n/a 45,900 45,900 Thursday, August 02, 2007 8 Sou ree Projeet# Priority 2008 2009 2010 2011 2012 Total Trailer 01-ERP-316 n/a 4,900 4,900 4X4 1/2 Ton Truck 01-ERP-710 n/a 23,300 23,300 Hot Water High Pressure Vehicle Washer 01-ERP-711 n/a 5,800 5,BOO 1/2 Ton Pickup Truck 01-ERP-BOO n/a 26,400 26,400 4x4 3/4Ton Trucks (2) 01-ERP-B01 n/a 67,400 67,400 3/4 Ton Utility Truck 01-ERP-B02 n/a 32,200 32,200 Swap Loader 01-ERP-B03 n/a 19,000 19,000 Aerial Lift 01-ERP-B05 n/a 110,000 110,000 Tractors (2) 01-ERP.806 n/a 41,400 43,900 85,300 Trucksters (3) 01-ERp.807 n/a 19,800 19,800 Riding Mowers (3) 01-ERP-808 n/a 22,800 10,300 33, 100 Equipment Replacement Fund Total 698,840 421,340 898,400 410,700 681,600 3,110,880 lHAC - Arts Ce~~r Fund I Arts Center Copy Machine 01-ERP-1100 n/a 12,100 12,100 HAC - Arts Center Fund Total 12,100 12,100 r--- I lRF - Refuse Fund Swap Loader 01-ERP-803 n/a 57,000 57,000 Refuse Truck (RAP-R) (2) 01-ERP-900 n/a 176,700 176,700 RF - Refuse Fund Total 57,000 176,700 233,700 LSF - Sanitary Sewer Fund -----I Telephone System 01-ERP-557 n/a 6,800 6,800 SF - Sanitary Sewer Fund Total 6,800 6,800 r - -- -'1 LWF - Water Fund Air Compressor 01-ERP-503 n/a 23,100 23,100 Public Works Copy Machine 01-ERP-506 n/a 12,200 12,200 Telephone System 01-ERP-507 n/a 6,800 6,800 WF - Water Fund Total 23,100 12,200 6,800 42,100 GRAND TOTAL 1,233,940 426,340 1,092,300 441,400 686,600 3,880,580 Thursday, August 02. 2007 9 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2008 thru 2012 PROJECTS & FUNDING SOURCES BY DEPARTMENT Department Project# Priority 2008 2009 2010 2011 2012 Total ~Center Arts Center Copy Machine I 01-ERP-1100 n/a 12,100 12,100 Arts Center Total 12,100 12,100 HAC - Arts Center Fund nrt4 rtiCerztetqi O';aIJ!/rI~\)'? ~TV I Cable/Council Chamber Cameras & Control System 01-ERP-050 n/a 5,000 5,000 5,000 5,000 5,000 25,000 Cable TV Total 5,000 5,000 5,000 5,000 5,000 25,000 Cable Television FlInd lCity Hall Administration I Network Server o 1-ERP-003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01-ERP-004 n/a 76,000 76,000 Computers o 1-ERP-006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 City Hall Administration Total 38,000 38,000 38,000 114,000 38,000 266,000 Equipment Replacement Fuud CityH(lll [Community Services I City Hall Main Copy Machine - Oce' Copier 01-ERP-001 n/a 2,400 2,400 2,400 14,000 21,200 City Hall Small Copy Machine 01-ERP-002 n/a 26,900 26,900 Engineering Printer/Scanner 01-ERP-007 n/a 8,640 8,640 10,000 10,000 10,000 47,280 Document Management Scanner (2) 01-ERP-008 n/a 6,500 6,500 6,500 19,500 Community Services Total 11,040 17,540 18,900 50,900 16,500 114,880 Equipment Replacemeitt{ulld 19..590 , "~114880 :;i. t , '"':,:. Thursday, August 02, 2007 10 Department Project# Priority 2008 2009 2010 2011 2012 Total ;Fire 1 Lite Rescue 01-ERP-105 n/a 40,000 40,000 Stuphen Aerial Truck 01-ERP-106 n/a 900,000 900,000 Breathing Apparatus 01-ERP-108 n/a 36,000 36,000 Extrication Tool (2) 01-ERP-109 n/a 26,500 26,500 Copy Machine 01-ERP-110 n/a 10,300 10,300 Workout Equipment - Eliptical 01-ERP-116 n/a 5,000 5,000 10,000 Workout Equipment - Stairmaster 01-ERP-117 n/a 5,000 5,000 Workout Equipment - Treadmill 01-ERP-118 n/a 5,000 5,000 Workout Equipment - Weight Lifting 01-ERP-119 n/a 5,000 5,000 Automated External Defibrillator (2) 01-ERP-120 n/a 6,000 6,000 Fire Total 936,000 45,000 11,000 20,300 31,500 1,043,800 , Bqllds/Lease , [Police 'I Marked Patrol Vehicles (6) 01-ERP-200 n/a 61,400 31,600 97,800 67,200 34,600 292,600 Sergeant's Vehicle 01-ERP-201 n/a 33,600 33,600 Utility 4x4 (unit 212) 01-ERP-203 n/a 37,700 37,700 Police Administrative Vehicles (2) 01-ERP-204 n/a 25,600 26,300 27,100 27,900 28,800 135,700 Computer System 01-ERP-208 n/a 500,000 500,000 Copy Machine 01-ERP-209 n/a 19,100 19,100 Network Server (3) 01-ERP-211 n/a 8,700 8,700 8,700 8,700 8,700 43,500 Mobile Data Computers 01-ERP-212 n/a 54,500 54,500 Digital Squad Car Cameras 01-ERP-213 n/a 42,600 42,600 Tactical Ballistic Vests 01-ERP-214 n/a 20,000 20,000 Police Total 115,700 104,300 633,600 199,100 126,600 1,179,300 1tH'g;300 1,179,300 r -- -~ --- Public Works: Bldg/Equip Serv 1 4X4 1/2 Ton Truck 01-ERP-710 n/a 23,300 23,300 Hot Water High Pressure Vehicle Washer 01-ERP-711 n/a 5,800 5,800 Public Works: Bldg/Equip Serv Total 29,100 29,100 Thursday, August 02, 2007 II Department Project# Priority 2008 2009 2011 2012 Total 2010 Equ ipmeni RepiJceme;;tfFli1~(ii':r lPublic Works: Parlis/Forestry I 1/2 Ton Pickup Truck 01-ERP-800 n/a 26,400 26,400 4x4 3/4Ton Trucks (2) 01-ERP-801 n/a 67,400 67,400 3/4 Ton Utility Truck 01-ERP-802 n/a 32,200 32,200 Swap Loader 01-ERP-803 n/a 76,000 76,000 Aerial Lift 01-ERP-805 n/a 110,000 110,000 Tractors (2) 01-ERP-806 n/a 41,400 43,900 85,300 Trucksters (3) 01-ERP-807 n/a 19,800 19,800 Riding Mowers (3) 01-ERP-808 n/a 22,800 10,300 33,100 Public Works: Parks/Forestry Total 76,000 174,200 32,200 26,400 141,400 450,200 Equipment ReplacemelltFund, ", Rf!.{fI.ye FUIl~{ IPublic Works: Streets/Traffic I 1 Ton Dump Truck (2) 01-ERP-303 n/a 1 Ton Traffic Boom Truck 01-ERP-304 n/a Water Truck 01-ERP-307 n/a Front End Loaders (2) 01-ERP-308 n/a Skid Loader (2) 01-ERP-309 n/a Roller 01-ERP-312 n/a Trailer 01-ERP-316 nla 37,400 34,700 75,000 133,700 172,000 31,000 45,900 4,900 42,300 164,700 327,600 Public Works: Streets/Traffic Total 72,100 75,000 133,700 172,000 31,000 45,900 4,900 Equipme;,'i"Rep!ace;;lej'i/'Fu nd :r~::~>:, << ,~~~.<:~~ ;42,300/+' 16j,(OO 534,600 ::;:...;x; ~:~-. ,~",. ,:< , ~'\:,:;:::: :'it:~~j~'; ~.,: .'. ..<': ':;S<~::""; , ' ::;:/'. ~~<:d":>, ~27,600 4~;300::!!,j i~. i;~~,;io~ ~e- Refuse Truck (RAP-R) (2) 'I 01-ERP-900 nla 176,700 176,700 Refuse Total 176,700 17?,700 RF - Refuse FUlld t 534''660' :y! "53i~~oo, 176,700 .~ ~;'--'::::>: Jy" 17,6,?PO 12 Thursday, August 02, 2007 Department Project# Priority 2008 2009 2010 2011 2012 Total lSewer Telephone System , 01-ERP-557 n/a 6,800 6,800 Sewer Total 6,800 6,800 ~F - Sallitary Se'~er" F~~~[{ I 01-ERP-503 n/a 23,100 23,100 01-ERP-506 n/a 12,200 12,200 01-ERP-507 n/a 6,800 6,800 Water Total 23,100 12,200 6,800 42,100 42;100 lWater Air Compressor Public Works Copy Machine Telephone System WF - Water Flllld Grand Total 1,233,940 426,340 1,092,300 441,400 686,600 3,880,580 Thursday, August 02, 2007 13 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Facilities Director Department Arts Center Project # Ol-ERP-l100 Project Name Arts Center Copy Machine Type Equipment Useful Life 7 years Category Equipment Priority . n/a Total Project Cost $53.800 Description I Copy machine capable of enlarging and producing double sided, collated and stapled copies. Justification I Used to duplicate rep0l1s, letters, signs, flyers and rental information. Prior 8,500 I Total Expenditures Equipment 2008 2009 2010 2011 12,100 12,100 2012 Total Future 12,100 33,200 I 12,100 TOhtl Total Prior 8,500 I Total Funding Sources HAC - Arts Center Fund 2008 2009 2010 2011 12,100 12,100 2012 Total 12,100 12,100 Future 33,200 I Total Total Operational Impact/Other I Variance from 20 year plan - increase by $2,000 to reflect actual cost. Estimate salvage/resale value on replaced item: $ Thursday, August 02. 2007 14 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thrll 2012 Contact City Manager Department Cable TV Type Equipment Useful Life 8 years Category Equipment Priority . n/a Total Project Cost S 1 00,000 Project # Ol-ERP-OSO Project Name Cable/Council Chamber Cameras & Control System Description I Replacement of cameras, motors and VCS communications specialist camera control unit. J usti fication I Studio equipment, lighting and cameras for meeting cable casts and presentations, Prior 5,000 I Total 2012 5,000 5,000 Total 25,000 25,000 2009 5,000 5,000 2010 5,000 5,000 2011 5,000 5,000 Expenditures Equipment 2008 5,000 5,000 Total Prior 5,000 I Total 2012 5,000 5,000 Total 25,000 25,000 Funding Sources Cable Television Fund 2009 5,000 5,000 2010 5,000 5,000 2011 5,000 5,000 2008 5,000 5,000 Total Operational Impact/Other I Variance from 20 year plan - replace equipment as needed due to useful life variation, Estimate salvage/resale value on replaced item: $-0- FlI tu rc 70,000 I Total FlI tu re 70,000 I Total 15 Thursday, A ugllst 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Project # Ol-ERP-003 Project Name Network Server Description I The network server is the hub of the network, New computers are faster and more reliable, Contact Finance Director/IT Department City Hall Administration Type Equipment Useful Life I year Category Equipment Priority . n/a Total Project Cost $193,000 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 data, Prior 41,000 I Total 2009 8,000 8,000 2010 8,000 8,000 2011 8,000 8,000 Expenditures Equipment 2008 8,000 8,000 Total Prior 41,000 I Total Funding Sources Equipment Replacement Fund 2009 8,000 8,000 2010 8,000 8,000 2011 8,000 8,000 2008 8,000 8,000 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- 2012 8,000 8,000 Fu tu re 112,000 I Total Total 40,000 40,000 2012 8,000 8,000 Total 40,000 40,000 Future 112,000 I Total 16 Thursday, August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Finance Director/IT Department City Hall Administration Project # Ol-ERP-004 Type Equipment Useful Life 8 years Catcgory Equipment Priority n/a Projcct Namc Telephone System Total Project Cost $367,400 Description I Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification I Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc,) Prior 60,000 I Total Expenditures Equipment 2008 2009 2010 2011 76,000 76,000 2012 Total Future 76,000 231,400 I 76,000 Total Total Prior 60,000 I Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 76,000 76,000 2012 Total 76,000 76,000 Future 231,400 I Total Total Operational Impact/Other I Variance from 20 year plan - None. Estimate salvage/resale value on replaced item: $ Thursday, August 02, 2007 17 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Finance Director/IT Department City Hall Administration Project Name Computers Type Equipment Useful Life 3-5 years Category Equipment Project # Ol-ERP-006 Priority n/a Total Project Cost S810,000 Description I Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund, Justification I Tools enabling staff to perform job responsibilities efficiently and effectively. Prior 210,000 I Total Expenditures Equipment 2008 30,000 30,000 2009 30,000 30,000 2010 30,000 30,000 2011 30,000 30,000 2012 30,000 30,000 Total Future 150,000 450,000 I 150,000 Total Total Prior 210,000 I Total Funding Sources Equipment Replacement Fund 2008 30,000 30,000 2009 30,000 30,000 2010 30,000 30,000 2011 30,000 30,000 2012 30,000 30,000 Total 150,000 150,000 Futur(' 450,000 I Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Thursday, August 02, 2007 18 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thrll 2012 Contact City Clerk Department Community Services Project # Ol-ERP-OOl Project Name City Hall Main Copy Machine - Oce' Copier Type Equipment Useful Life 5 years Ca tegory Equipment Priority n/a Total Project Cost $165,000 Description I Copy machine to service needs of all departments located at City Hall. 1. Variety of copying tasks, 2. High volume product copier. Note: equipment is leased. Justification 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 repol1s, and hearing and information notices, Machine will duplex, sort, collate and staple copies. Prior 87,000 I Total Expenditures Equipment 2008 2,400 2,400 2009 2,400 2,400 2010 2,400 2,400 2011 14,000 14,000 2012 Total 21,200 21,200 Future 56,800 I Total Total Prior Funding Sources 87,000 I Equipment Replacement Fund Total Total 2008 2,400 2,400 2009 2,400 2,400 2010 2,400 2,400 2011 14,000 14,000 2012 Total Future 21,200 56,800 I 21,200 Total Operational Impact/Other I Variance from 20 year plan - lease renewed for 36 months. Plan to purchase new copier in 2011. Estimate salvage/resale value on replaced item: $-0- Thursday, A uguSI 02. 2007 19 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact City Clerk Departmcnt Community Services Project # Ol-ERP-002 Project Namc City Hall Small Copy Machine Typc Equipment Uscful Life 5 years Catcgory Equipment Priority n/a Total Projcct Cost SI79,500 Description I Coyy machine to service needs of all departments located at City Hall. 1, Variety of copying tasks. 2. High volume product copier. Note: This is a Ricoh color copier. Justification I Daily use to make copies of correspondence and forms. Periodically produce documents, i,e., budgets, financial reports, counci I reports and updates, city code revisions, various department reports, and hearing and information notices, Machine will duplex, sort, collate and staple copies. Prior 43,200 I Total Expenditures Equipment 2008 2009 2010 2011 26,900 26,900 2012 Total Future 26,900 109,400 I 26,900 Total Total Prior 43,200 I Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 26,900 26,900 2012 Total Future 26,900 109,400 I 26,900 Tota I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Thursday, August 02. 2007 20 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Project # OI-ERP-007 Project Name Engineering Printer/Scanner Contact City Clerk Department Community Services Type Equipment Useful Life 5 years Category Equipment Priority nfa Total Project Cost $262,560 Description I Printer/scanner - large format copier use in Engineering to copy blueprints, plans and large documents, Equipment is leased, Justification I Large document copier/scanner for use in Engineering, Also scans documents for permanent storage, Prior 17,280 I Total Expenditures Equipment 2010 10,000 10,000 2011 10,000 10,000 2008 8,640 8,640 2009 8,640 8,640 Total Prior 17,280 I Total Funding Sources Equipment Replacement Fund 2010 10,000 10,000 2011 10,000 10,000 2008 8,640 8,640 2009 8,640 8,640 Total Operational Impact/Other I Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $-0- 2012 10,000 10,000 FlI tu rc 198,000 I TObtl Total 47,280 47,280 2012 10,000 10,000 FlI tu ft' 198,000 I Total Total 47,280 47,280 21 Thursday, August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact City Clerk Department Community Services Project # Ol-ERP-008 Type Equipment Useful Life 3 years Category Equipment Priority nla Project Name Document Management Scanner (2) Total Project Cost 597,500 Description I Large document (11 "x 17") scanner for document management and retention as well as general adm inistrative use. Two scanners each replaced every three years, One replaced in 2009, 2012,..... One replaced in 2010, 2013..... Justification I 2007 - Replaces the second scanner that only scans documents to 8 1/2"x 14" that was purchased in 2004, Prior 13,000 I Total Expenditures Equipment 2008 2009 6,500 6,500 2010 6,500 6,500 2011 2012 6,500 6,500 Total Future 19,500 65,000 I 19,500 Total Total Prior 13,000 I To ta I Funding Sources Equipment Replacement Fund 2008 2009 6,500 6,500 2010 6,500 6,500 2011 2012 6,500 6,500 Total 19,500 19,500 Fu tu rc 65,000 I Total Total Operational Impact/Other I Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $500-$1,000 Thursday, August 02, 2007 22 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Fire Chief Department Fire Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost $93,700 Project # Ol-ERP-I05 Project Name Lite Rescue Description I Light rescue response vehicle on a 4 wheel drive chassis, Justification I Used for all emergency medical responses; vehicle accidents; industrical accidents; hazardous materials response. 2008 Expenditures Vehicles 2009 40,000 40,000 Total 2010 2012 Total 40,000 40,000 FlI tu re 53,700 I Total Funding Sources Equipment Replacement Fund 2008 2009 40,000 40,000 Total 2011 2010 2011 Total 40,000 40,000 FlI tu re 53,700 I Total Operational Impact/Other I Variance from 20 year plan - price increased $5,000 for inflation Estimate salvage/resale value on replaced item $ - 4,000 2012 23 Thursday, August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Fire Chief Department Fire Type Equipment Useful Life 20 years Ca tegory Vehicles Priority n/a Total Project Cost $900,000 Project # Ol-ERP-I06 Project Name Stuphen Aerial Truck Description I One hundred foot aerial ladder truck with a 1500 GPMfire pump and a full compliment of ground ladders, Justification I Vehicle responds to all structural emergencies, Used especially for rescue of people trapped on upper floors and venti lation of the hot gases and smoke. The body of the truck was refurbished in 1991. The pump, aerial ladder and hydraul ics were not. The plan was to refurb these components in 2007. We have been informed by the manufacturer that because of the new aerial construction standards, we will not longer be able to refurb. Need to replace. Expenditures Equipment 2008 900,000 900,000 2009 2010 2011 2012 Total 900,000 900,000 Total Funding Sources Bonds/Lease Equipment Replacement Fund 2008 450,000 450,000 900,000 2009 2010 2011 2012 Total 450,000 450,000 900,000 Total Operational Impact/Other I Variance from 20 year plan - Total cost of new truck estimated to be $900,000. Last three years we have been unsuccessful at securing federal grants, Balance of funds needs to purchase truck will be financed. Estimate salvage/resale value on replaced item: $ 71llirsday, August 02, 2007 24 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Con tact Fire Chief Dcpartmcnt Fire Type Equipment Uscful Life I 5 years Catcgory Equipment Priority n/a Total Proj(~ct Cost 5368,500 Project # Ol-ERP-I08 Project Name Breathing Apparatus Description I High pressure, light weight breathing apparatus carried on all emergency apparatus, Thirty minute capacity. Justification I OSHA required self contained breathing apparatus must be worn by fire-fighters when working in hazardous atmospheric conditions or oxygen deficient situations, Upgrade consists of new regulator and rapid escape valve ($900 each/40 count) 2012 Prior 130,000 I Total Expenditures Equipment 2008 36,000 36,000 2009 2011 2010 Total 36,000 36,000 Total Prior 130,000 I Total Funding Sources Equipment Replacement Fund Total 2008 36,000 36,000 2009 2010 2011 2012 Total 36,000 36,000 FlI tu I'C 202,500 I Total FlI tu rc 202,500 I Total Operational Impact/Other I Variance from 20 year plan - In 2007 an additional one time cost for the upgrade in 2008 was added. Needed to make apparatus compliant to NFPA and OSHA requirements for firefighter safety. Estimate salvage/resale value on replaced item: $ 200 each 25 Thursday, August 02, 2007 EQlliPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thrll 2012 Contact Fire Chief Department Fire Project # Ol-ERP-I09 Project Name Extrication Tool (2) Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost S146,200 Description I Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. Note: purchased 1995 & 2005 Justification I All vehicle and industrial rescue situations which will require paitient disentanglement or entrapment. Prior 20,300 I Total Expenditures Equipment 2008 2009 2010 2011 2012 26,500 26,500 Total Future 26,500 99,400 I 26,500 Total Total Prior 20,300 I Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 2012 26,500 26,500 Total Futun' 26,500 99,400 I 26,500 Total Total Operational Impact/Other I Variance from 20 year plan - added to ERP second extrication tool purchased from Fire Dept budget in 2005. Estimate salvage/resale value on replaced item: $1,000 71ll1rsday, August 02, 2007 26 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Fire Chief Department Fire Type Equipment Useful Life 8 years Cll tegory Equipment Priority n/a Total Project Cost $47,400 Project # Ol-ERP-l10 Project Name Copy Machine Description I Fire Station copy machine. Justification I Copying business papers, training records, etc. Expenditures Equipment 2008 Prior 7,400 I Total Total Prior 7,400 I Total Funding Sources Equipment Replacement Fund 2008 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $500 2009 2012 Total 10,300 10,300 Fu tu rc 29,700 I Total Future 29)00 I Total 2010 2011 10,300 10,300 2009 2010 2011 10,300 10,300 2012 Total 10,300 10,300 27 Thursday. August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 COil tact Fire Chief Department Fire Type Equipment Useful Life 6 years Ca tegory Equipment Priority n/a Total Project Cost $42,800 Projcct # 01-ERP-116 Projcct Namc Workout Equipment - EIiptical Description I Workout equipment used in Fire Department workout room. Two eliptical machines replaced on a 6 year cycle, one eve.ry 3 years. 2009 - replace eliptical 2012 - replace eliptical Justification I This equipment is available to all City employees for health and wellness. Expenditures Equipment 2008 2009 5,000 5,000 2010 2011 2012 5,000 5,000 Total 10,000 10,000 Future 32,800 I Total Total Funding Sources Equipment Replacement Fund Total 2008 2009 5,000 5,000 2010 2011 2012 5,000 5,000 Total 10,000 10,000 Future 32,800 I Total Operational Impact/Other I Variance from 20 year plan - life extended one year for each eliptical Estimate salvage/resale value on replaced item: $ Thursday, August 02, 2007 28 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 Ihrll 2012 Con tact Firc Chicf Department Fire Type Equipmcnt Useful Life 5 ycars Category Equipment Priority . nla Total Project Cost $25,300 Project # 01-ERP-117 Projt'ct Name Workout Equipment - Stairmaster Description I Workout equipment used in Fire Department workout room. One stainnaster replaced on a 5 year cycle. Justification I This equipment is available to all City employees for health and wellness. 2009 Expenditures Equipment 2008 2010 5,000 5,000 Total 2011 2012 Total 5,000 5,000 FlI tu rc 20,300 I Total Funding Sources Equipment Replacement Fund 2008 2009 2010 5,000 5,000 Total 2011 2012 Total 5,000 Futun' 20,300 I 5,000 Total Operational Impact/Other I Variance from 20 year plan - new item - Originally purchased with grant funds, Estimate salvage/resale value on replaced item: $ 29 71ll1rsday, A IIgllsl 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Con tact Fire Chief Drpa rtment Fire Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $25.300 Project # 01-ERP-118 Project i\'ame Workout Equipment - Treadmill Description I Workout equipment used in the Fire Department workout room, One treadmill replaced on a 5 year cycle. Justification I This equipment is available to all City employees for health and wellness. Expenditures Equipment 2009 2008 Total 2010 2011 5,000 5,000 Total 5,000 5,000 Fu tu J'e 20,300 I Total Funding Sources Equipment Replacement Fund 2008 2009 Total 2012 2010 2011 5,000 5,000 Total 5,000 5,000 Futur<.' 20,300 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value 011 replaced item: $ 2012 30 Thursday. August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thrll 2012 COli tact Fire Chief Dcpartmcnt Fire Typc Equipment Uscful Life 5 years Ca tcgory Equipment Priority n/a Total Project Cost $25,300 Projcct # Ol-ERP-119 Projcct Namc Workout Equipment - Weight Lifting Description I Smith machine - weight lifting machine. Justification I For use by Police, Fire, Public Works, City staff to keep in shape to perform job duties and stay healthy. Current machine will be 7 years old in 2012, Suggested replacement is every 5 years. Expenditures Equipment 2008 2009 2010 2011 5,000 5,000 2012 Total Future 5,000 20,300 I 5,000 T ota I Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 5,000 5,000 2012 Total 5,000 5,000 Fu tu re 20,300 I Total Total Operational Impact/Other I Variance from 20 year plan - new item. Not previously included in ERP. Originally purchased with grant funds. Estimate salvage/resale value on replaced items: $ Thursday, August 02. 2007 31 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Con tact Fire Chief Department Fire Type Equipment Useful Life 3 years Category Equipment Priority n/a Total Project Cost $49,100 Project # Ol-ERP-120 Project Name Automated External Defibrillator (2) Description I Defibri lIator is used to help get someones heart restarted during a cardiac arrest. Own 2 - both are replaced at one time due to changing technology, Justification I The current AED are not in the ERP. With changes in technology, they should be replaced every three years. Cost - $3,000 per unit Expenditures Equipment 2008 2009 2010 6,000 6,000 2011 2012 Total 6,000 6,000 Fu tu re 43,100 I Total Total Funding Sources Equipment Replacement Fund 2008 2009 2010 6,000 6,000 2011 2012 Total 6,000 6,000 Future 43,100 I Total Total Operational Impact/Other I Variance from 20 year plan - new item, Not previously included in ERP. 2007 replaced with fire department funds. Estimate salvage/resale value on replaced item: $ 71l1irsday, AI/gust 02, 2007 32 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Project # Ol-ERP-200 Project Name Marked Patrol Vehicles (6) Con tact Police Chief Department Police Type Equipment Useful Li fe 3 years Category Vehicles Priority nla Total Project Cost S2,O 16,600 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. Prior 412,300 I Total 2008 61 ,400 61,400 2010 97,800 97,800 2011 67,200 67,200 2009 31,600 31,600 Expenditures Vehicles Total Prior 412,3001 Total Funding Sources Equipment Replacement Fund 2010 97,800 97,800 2011 67,200 67,200 2008 61,400 61,400 2009 31,600 31,600 Total Operational Impact/Other I Variance from 20 year plan - move sergeant's vehicle to separate project number. Estimate salvage/resale value on replaced item: $4,000 each 2012 34,600 34,600 Total Future 292,600 I 1,311,700 I 292,600 Total 2012 34,600 34,600 Fu tu re I 1,311,700 I Total Total 292,600 292,600 33 Thursday, Augusl 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thrll 2012 Con tact Police Chief Department Police Type Equipment Useful Life 4 years Category Vehicles Priority nla Total Project Cost 5215,700 Project # Ol-ERP-201 Project Name Sergeant's Vehicle Description I Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties, Justification 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, Expenditures Vehicles 2008 2009 2010 2011 33,600 33,600 2012 Total Future 33,600 182,100 I 33,600 Total Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 33,600 33,600 2012 Total 33,600 33,600 Future 182,100 I Total Total Operational Impact/Other I Variance from 20 year plan -, move purchase of sergeant's squad back to 2011. Purchased new in 2007, Estimate salvage/resale value on replaced item: $3,500 each Thursday, August 02, 2007 34 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Police Chief Department Police Type Equipment Useful Life 6 years Category Vehicles Priority n/a Total Project Cost $247,600 Project # 01-ERP-203 Project l\'amc Utility 4x4 (unit 212) 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 transpoliing 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, Prior 29,700 I Total Expenditures Vehicles 2008 2009 37,700 37,700 2010 2011 2012 Total Future 37,700 180,200 I 37,700 Total Total Prior 29,700 I Total Funding Sources Equipment Replacement Fund 2008 2009 37,700 37,700 2010 2011 2012 Total 37,700 37,700 Future 180,200 I Total Total Operational Impact/Other I Variance from 20 year plan - can move replacement back one year to 2009 - new engine. Estimate salvage/resale value on replaced item: $5,000 Thursday, August 02, 2007 35 EQlliPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Project # Ol-ERP-204 Project Name Police Administrative Vehicles (2) Description I Police administrative and detective vehicles. Replace Chiefs vehicle - even numbered years Replace Captain's vehicle - odd numbered years Con tact Police Chief Department Police Type Equipment Useful Life 2 years Ca tegor)' Vehicles Priority nla Total Project Cost $820,100 Justification I Unmarked vehicles, equipped with radios, siren and red grille lites used by chief and captain. Staff use is for two years, Vehicles are then rotated down to detectives and are kept for an additional 3-4 years. Vehicles are also used for surveillance by uniform and plain clothes officers, Expenditures Vehicles Prior 133,400 I Total 2008 25,600 25,600 2009 26,300 26,300 2010 27,100 27,100 2011 27,900 27,900 Total Prior 133,400 I Total Funding Sources Equipment Replacement Fund 2008 25,600 25,600 2009 26,300 26,300 2010 27,100 27,100 2011 27,900 27,900 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $4,000 each 2012 28,800 28,800 Fu tu rc 551,000 I Total Total 135.700 135,700 2012 28,800 28,800 Fu tu re 551,000 I Total Total 135.700 135,700 36 Thursday, August 02,2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 COli tact Police Chief Department Police Type Equipment Useful Life 10 years Category Equipment Priority nla Total Project Cost $1,172,000 Project # OI-ERP-208 Project i\'amc Computer System Description I Computer system for records management and retention of Police Department. Justification I To store, retrieve and transfer required data to State and perform data entry, inquiries of local, state and national crime databases. During last purchase, the Police Department did not have CAD or mobile systems. Since then, these systems have been added and share the same data base/operating system as the records management. Replacement will have to incorporate all three systems, Expenditures Equipment 2008 2009 2010 500,000 500,000 2011 2012 Total Future 500,00067~,000 500,000 Total Total Funding Sources Equipment Replacement Fund 2008 2009 2010 500,000 500,000 2011 2012 Total Futun.' 500,00067~,000 500,000 Tota I Total Operational Impact/Other I Variance from 20 year plan - In 2007 the budget was increased to $700,000 to better reflect a more realistic replacement cost for Records Mgmt Mobile Data System and Computer Aided Dispatch (RMS/MDC/CAD) computer system. In 2008 the budget was reduced to $500,000 to fit within the overall ERP plan, Estimate salvage/resale value on replaced item: $-0- Thursday, August 02, 2007 37 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Con tact Police Chief Department Police Type Equipment Useful Life 5 years Category Equipment Priority nla Total Project Cost S127,200 Project # Ol-ERP-209 Project Name Copy Machine Description I Police Department copy machine capable of producing double side copies and collating pages. Justification I Used to make duplicate copies of reports, letters, memos, etc" generated by police personnel. 2012 Prior 30,700 I Total 2011 19,100 19,100 Total 19,100 19,100 Expenditures Equipment 2008 2009 2010 Total Prior 30,700 I Total Funding Sources Equipment Replacement Fund 20ll 19,100 19,100 2012 2008 2009 2010 Total 19,100 19,100 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Fu tu rc 77 ,400 I Total Fu tu fC 77,400 I Total 38 Thursday, August 02. 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Police Chief/IT Department Police Project # 01-ERP-211 Project Name Network Server (3) Type Equipment Useful Life 3 years Category Equipment Priority n/a Total Project Cost $225,500 Description I Computer servers store information and system programs. One server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01-ERP-213) Justification I Annual replacement cycle allows development of system storage program, Use of newer servers for heavy use programs while older servers used for data storage. Prior 42,500 I Total Expenditures Equipment 2008 8,700 8,700 2009 8,700 8,700 2010 8,700 8,700 2011 8,700 8,700 2012 8,700 8,700 Total Fu tu rc 43,500 139,500 I 43,500 Total Total Prior 42,500 I Total Funding Sources Equipment Replacement Fund 2008 8,700 8,700 2009 8,700 8,700 2010 8,700 8,700 2011 8,700 8,700 2012 8,700 8,700 Total 43,500 43,500 Futun.' 139,500 I Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item - $ 71ll1rsday, August 02, 2007 39 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Con tact Police Chief Dcpartmcnt Police Type Equipment Useful Life 5 years Ca tegory Equipment Priority n/a Total Project Cost $322,800 Projcct # 01-ERP-212 Project Name Mobile Data Computers Description I Mobile data computers installed in squad cars used to receive calls from dispatch, query information from various databases, communicate car to car. Justification I Limited life of 5 years - replacement necessary. Prior 47,000 I Total Expenditures Equipment 2008 2009 2010 2011 2012 54,500 54,500 Total Future 54,500 221,300 I 54,500 Total Total Prior 47,000 I Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 2012 54,500 54,500 Total 54,500 54,500 Fu tu re 221,300 I Total Total Operational Impact/Other I Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $-0- 71mrsday, August 02, 2007 40 EQillPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Con tact Police Chief Department Police Type Equipment Useful Life 5 years Ca tegory Equipment Priority n/a Total Project Cost $215,700 Project # 01-ERP-213 Project Name Digital Squad Car Cameras Description I Digital video camera system in each patrol car - used to document events in and out of the patrol car. Images downloaded to server for storage and retrieval. Justification I Police Dept. currently has eight digital camera units installed and a dedicated server. The life expectancy of the cameras is about five years, Current cameras were installed in September 2006. Cost: 8 cameras @ $5,000 per unit plus tax - $42,600 1 server @ $15,000 (to be purchased from Police Network Server (0 l-ERP-211) annual allocation that carries forward. Total estimated cost $57,600. Cost could be lower if, at the time of replacement, a suitable produce is available through a State or County equipment bid. Expenditures 2008 Equipment 2009 2010 2011 42,600 2012 Total 42,600 Fu tu re 173,100 I Total Total 42,600 42,600 Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 42,600 42,600 2012 Total Future 42,600 173,100 I 42,600 Total Total OperationallmpactJOther I Variance from 20 year plan - new item Estimate salvage/resale value on replaced item: $ Thursday, A Uglisl 02, 2007 41 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Police Chief Dcpartmcnt Police Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $101,300 Project # 01-ERP-214 Project Namc Tactical Ballistic Vests Description I Tactical ballistic vests worn by members of the Hopkins Police Department High-risk Entry and Assault Team (HEA T). These vests offer a higher level of protection against weapon assault than the regular duty ballistic vest. J usti fication I Federal and State grant monies have been available through the Ballistic Vest Program over the past several years. These grants only pay a portion of the total cost of the vest, leaving the Police Department to pay the balance. There is no guarantee that these grants will be available in the future. Warranty on the current vests expires in 2007. Cost: 9 vests x $2,133 = $19,197 (today's cost). Does not include any applicable taxes. Expenditures Equipment 2008 20,000 20,000 2009 2010 2011 2012 Total Future 20,000 81,300 I 20,000 T ota I Total Funding Sources Equipment Replacement Fund 2008 20,000 20,000 2009 2010 2011 2012 Total 20,000 20,000 Future 81,300 I Total Total Operational Impact/Other I Variance from 20 year plan - new item, Note: regular bullet proof vests funded by federal/state grants Estimate salvage/resale value on replaced item: $ Thursday, August 02, 2007 42 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 /hru 2012 Contact Public Works Director Department Public Works: Bldg/Equip Ser Project # Ol-ERP-710 Project Name 4X4 1/2 Ton Truck Type Equipmcnt Useful Life 10 years Ca tegory Vchicles Priority n/a Total Project Cost $54,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 23,300 23,300 2009 2010 2011 2012 Total 23.300 23,300 Fu tu rc 31,300 I Total Total Funding Sources Equipment Replacement Fund 2008 23,300 23,300 2009 2010 2011 2012 Total Future 23,300 31,300 I 23,300 Total Total Operational Impact/Other I Variance from 20 year plan - move up from 2009 to 2008 - Fire Dept has requested to acquire surplus pickup for its use by daytime responders. Estimate salvage/resale value on replaced item: $1,500 Thursday, August 02, 2007 43 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Project # 01-ERP-711 Projcct Namc Hot Water High Pressure Vehicle Washer Description I Hot water, high pressure vehicle washer. Contact Public Works Director Dcpartmcnt Public Works: BldglEquip Ser Typc Equipment Uscful Life 12 years Catcgory Equipment Priority . nla Total Projcct Cost S14,100 Justification I Existing washer is 12 years old; is in poor condition and needs to be replaced. Expenditures Equipment 2010 2011 Total 2008 5,800 5,800 2009 2012 Total 5,800 5,800 Future 8,300 I Total Funding Sources Equipment Replacement Fund 2010 2011 Total 2008 5,800 5,800 2009 2012 Total 5,800 5,800 Future 8,300 I Total Operational Impact/Other I Variance from 20 year plan - new item, Estimate salvage resale value on replaced item: $ 44 Thursday, August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thrll 2012 Project # Ol-ERP-800 Project Name 1/2 Ton Pickup Truck Description I Total Project Cost $61,800 Pickup used by Park Division of Public Works. Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Life 10 years Category . Vehicles Priority n/a Justification I Expenditures Vehicles 2008 2012 Total Future 26,400 35,400 I 26,400 Tot~1 Total 2009 2011 26,400 26,400 Funding Sources Equipment Replacement Fund 2008 Total 2010 2009 2010 2011 26,400 26,400 2012 Fu tu re 35,400 I Total Total 26,400 26,400 Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ 45 Thursday, August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Public Works: Parks/Forestry Project # Ol-ERP-801 Project Name 4x4 3/4Ton Trucks (2) Type Equipment Useful Life . 8 years Category Vehicles Priority n/a Total Project Cost $205,800 Description I Trucks Llsed by Parks Division of Public Works, Justification I Prior 53,200 I Total Expenditures Vehicles 2008 2009 2010 2011 2012 67,400 67,400 Total 67,400 67,400 Fu tu rc 85,200 I Total Total Prior 53,200 I Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 2012 67,400 67,400 Total 67,400 67,400 Fu tu re 85,200 I Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ 71ll1rsday, August 02, 2007 46 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Public Works: Parks/Forestry Project # Ol-ERP-802 Project Name 3/4 Ton Utility Truck Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost $75,600 Description I 3/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city, J usti fication I Expenditures Vehicles 2008 2009 2010 32,200 32,200 2011 2012 Total 32,200 32,200 Fu t\l rc 43,400 I Total Total Funding Sources Equipment Replacement Fund 2008 2009 2010 32,200 32,200 2011 2012 Total 32,200 32,200 Fu t\1 rc 43,400 I Total Total Operational Impact/Other I Variance from 20 year plan - In 2007 the vehicle was moved back two years from 2008 to 2010, Estimate salvage/resale value on replaced item: $ Thursday, August 02, 2007 47 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Public Works: Parks/Forestry Project # 01-ERP-803 Type Equipment Useful Life 15 years Category Equipment Project Name Swap Loader Priority n/a Total Project Cost S 194,400 Description I Single axle truck with a slide rail system used to swap between various boxes and bodies. Utilitized by Refuse for hauling dumpsters and Forestry for chipping trees. Justification I 250/0 Equipment Replacement Fund 75% Refuse Fund Expenditures Equipment 2008 76,000 76,000 2009 2010 2011 2012 Total Future 76,000 118,400 I 76,000 Total Total Funding Sources 2008 2009 2010 2011 2012 Total Future Equipment Replacement Fund 19,000 19,000 118.400 I RF - Refuse Fund 57,000 57,000 Total Total 76,000 76,000 Operational Impact/Other I Variance from 20 year plan - Increase from $55,200 to $76,000 to reflect actual cost. Estimate salvage/resale value on replaced item: $ 71l/1rsday, August 02, 2007 48 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Public Works: Parks/Forestry Project # Ol-ERP-80S Type Equipment Useful Life 20 years Category Equipment Project Name Aerial Lift Priority n/a Total Project Cost $110,000 Description I Aerial lift truck is utilized by the Forestry department to trim and remove trees. It is also used for ballfield light maintenance in the parks. Justification I Expenditures Equipment 2008 2009 110,000 110,000 2010 2011 2012 Total 110,000 110,000 Total Funding Sources Equipment Replacement Fund Total 2008 2009 110,000 110,000 2010 2011 2012 Total 110,000 110,000 Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Thursday, August 02, 2007 49 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 Ihru 2012 Contact Public Works Director Department Public Works: Parks/Forestry Project # Ol-ERP-806 Type Equipment Useful Life 20 years Category Equipment Priority n/a Project Name Tractors (2) Total Project Cost S85,300 Description I Farm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration, plowing and grass seeding, Justification I Expenditures Equipment 2008 2009 41,400 41,400 2010 2011 2012 43,900 43,900 Total 85,300 85,300 Total Funding Sources Equipment Replacement Fund 2008 2009 41,400 41,400 2010 2011 2012 43,900 43,900 Total 85,300 85,300 Total Operational Impact/Other I Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $3,500 Thursday, August 02, 2007 50 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Project # Ol-ERP-807 Projcct Namc Trucksters (3) Departmcnt Public Works: Parks/Forestry Type Equipment Useful Life 15 years Catcgory Equipment Priority n/a Total Project Cost $114,700 Description I Truckster used by Parks Division of Public Works for ballfield and parks maintenance. Justification I Park maintenance, ballfield grooming and weed spraying. Prior 29,900 I Total Expenditures Equipment 2008 2009 20.10 2011 2012 19,800 19,800 Total 19,800 19,800 Future 65,000 I Total Total Prior 29,900 I Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 2012 19,800 19,800 Total 19,800 19,800 Future 65,000 I Total Total Operational Impact/Other I Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $1,400 each Thursday, August 02, 2007 51 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 Ihru 2012 Contact Public Works Director Department Public Works: Parks/Forestry Project # Ol-ERP-808 Project Name Riding Mowers (3) Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost . $206,600 Description I 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 sidewalk snow removal. Prior 49,000 I Total Expenditures Equipment 2008 2009 22,800 22,800 2010 2011 2012 10,300 10,300 Total 33,100 33,100 Future 124,500 I Total Total Prior 49,000 I Total Funding Sources Equipment Replacement Fund Total 2008 2009 22,800 22,800 2010 2011 2012 10,300 10,300 Total 33,100 33,100 Future 124,500 I Total Operational Impact/Other I Variance from 20 year plan - none, Estimate salvage/resale value on replaced item: $600 each Thursday, August 02, 2007 52 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Public Works: Streetsrrratllc Project # Ol-ERP-303 Project Name 1 Ton Dump Truck (2) Type Equipment Useful Life 12 years Category Vehicles Priority nla Description I Truck is used in the Street Division of Public Works. Total Project Cost $205,500 Justification I Vehicle used by various departments for street and park maintenance and light hauling. Expenditures Vehicles 2008 Prior 30,500 I Total Total Prior 30,500 I Total Funding Sources Equipment Replacement Fund 2008 Total Operational Impact/Other I Variance from 20 year plan - Estimate salvage/resale value on replaced item: $3,500 2009 37,400 37,400 2009 37,400 37,400 2010 2011 Total 72,100 72,100 Fu tu re 102,900 I Total Fu tu n' 102,900 I Total 2012 34,700 34,700 2010 2011 2012 34,700 34,700 Total 72,100 72,100 53 Thursday, August 02, 2007 EQillPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Dcpartmcnt Public Works: Streetsrrraffic Project # Ol-ERP-304 Project Name 1 Ton Traffic Boom Truck Type Equipment Uscful Life 17 years Category Vehicles Priority n/a Total Project Cost $75,000 Description I Boom truck used in Street and Traffic Divisions of Publ ic Works. Justification I Vehicle used by Traffic Department for signal and light pole maintenance. Expenditures Vehicles 2008 2009 2010 2011 2012 75,000 75,000 Total 75,000 75,000 Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 2012 75,000 75,000 Total 75,000 75,000 Total Operational Impact/Other I Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $8,000 Thursday, August 02, 2007 54 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 fhru 2012 Contact Public Works Director P,'oject # Ol-ERP-307 Department Public Works: Streetsffraffic Type Equipment Useful Life 15 years Catcgory Vehicles Priority n/a Project Namc Water Truck Total Project Cost 5342,000 Description I Water truck used in Streets and Parks Division of Public Works, J usti fication I Used for street flushing, watering trees and plants, rink flooding and standby fire protection. Expenditures Vehicles 2008 2009 2010 133,700 133,700 2011 2012 Total Future 133,700201,300 133,700 Total Total Funding Sources Equipment Replacement Fund 2008 2009 2010 133,700 133,700 2011 2012 Total Future 133,700201,300 133,700 Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $8,500 Thursday. August 02. 2007 55 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 Ihru 2012 Project # Ol-ERP-308 Project Name Front End Loaders (2) Description I Contact Public Works Director Department Public Works: StreetsfTramc Type Equipment Usefu I Life 15-18 years Category Equipment Priority n/a Total Project Cost $530,100 Justification I Expenditures Equipment 2008 Prior 140,000 I Total Total Prior 140,000 I Total Funding Sources Equipment Replacement Fund Total 2008 2009 2010 2011 2012 172,000 172,000 Total 172,000 172,000 Fu tu rc 218,100 I Total Fu tu re 218,100 I Total Operational Impact/Other I Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $ 2009 2010 2011 2012 172,000 172,000 Total 172,000 172,000 56 Thursday, August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Public Works: Streets/Traffic Project # Ol-ERP-309 Project Name Skid Loader (2) Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost S117,100 Description I Loading trucks, landscape work, snow removal, material handling, Justification I Expenditures Equipment 2008 2009 2010 31,000 31,000 2011 2012 Total 31,000 31,000 Future 86,100 I Total Total Funding Sources Equipment Replacement Fund 2008 2009 2010 31,000 31,000 2011 2012 Total Futun.' 31,000 86,1001 31,000 Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Thursday, August 02, 2007 57 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Public Works: Streetsrrraftic Project l\'ame Roller Type Equipment Useful Life 20 years Category Equipment Priority n/a Project # 01-ERP-312 Total Project Cost S45,900 Description I Justification I Expenditures Equipment 2008 2009 2010 2011 2012 45,900 45,900 Total 45,900 45,900 Total Funding Sources Equipment Replacement Fund 2008 2009 2010 2011 2012 45,900 45,900 Total 45,900 45,900 Total Operational Impact/Other I Variance from 20 year plan - None Estimate salvage/resale value on replaced item: $ Thursday, August 02, 2007 58 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thrll 2012 Contact Public Works Director Department Public Works: Streetsffraflic Type Equipment Useful Life 20 years Category Equipment Priority nla Project # 01-ERP-316 Project Name Trailer Total Project Cost $4,900 Description I Used for transporting and hauling equipment and supplies. Justification I Expenditures Equipment 2008 2009 4,900 4,900 2010 2011 2012 Total 4,900 4,900 Total Funding Sources Equipment Replacement Fund 2008 2009 4,900 4,900 2010 2011 2012 Total 4,900 4,900 Total Operational Impact/Other I Variance from 20 year plan - none Estiamte salvage/resale value on replaced item: $ Thursday, August 02, 2007 59 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Refuse Project # Ol-ERP-900 Project Name Refuse Truck (RAP-R) (2) Type Equipment Useful Life 10 years Category Vehicles Priority nla Total Project Cost $1,042,100 Description I Refuse truck used by Refuse Utility Division of Public Works, Justification Residential waste pick up. I Prior 148,000 I Total Expenditures Vehicles 2008 2009 2010 176,700 176,700 2011 2012 Total Future 176,700 717,400 I 176,700 Total Total Prior 148,000 I Total Funding Sources RF - Refuse Fund 2008 2009 2010 176,700 176,700 2011 2012 Total 176,700 176,700 FlI tu n' 717,400 I Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $18,000 Thursday, AI/gust 02, 2007 60 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Finance Director/IT Dcpartmcnt Sewer Project # Ol-ERP-557 Projcct Name Telephone System Type Equipment Uscful Life 8 years Catcgory Equipment Priority n/a Total Project Cost $31,200 Description I Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. J usti fication I Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc,) Prior 4,700 I Total Expenditures Equipment 2008 2009 2010 2011 6,800 6,800 2012 Total 6,800 6,800 Fu tll rc 19,700 I Total Total Prior 4,700 I Total Funding Sources SF - Sanitary Sewer Fund 2008 2009 2010 2011 6,800 6,800 2012 Total 6,800 6,800 Fu tll rc 19,700 I Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Thursday, August 02, 2007 61 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Contact Public Works Director Department Water Project # Ol-ERP-S03 Type Equipment Useful Life 20 years Category Equipment Project Name Air Compressor Priority nfa Total Project Cost 523,100 Description I Portable air compressor used by various departments of Public Works. Justification I Air supply for operating jack hammers, blowing out irrigation lines, sand blasting and operations of various tools. Expenditures Equipment 2008 23,100 23,100 2009 .2010 2011 2012 Total 23,100 23,100 Total Funding Sources WF - Water Fund 2008 23,100 23,100 2009 2010 2011 2012 Total 23,100 23,100 Total Operational Impact/Other I Variance from 20 year plan - Move up [rom 2012 to 2008. Replace 1982 unit with larger capacity due to larger irrigation lines. Purchase new or slightly used machine. Estimate salvage/resale value on replaced item: $2,000 71ll1rsday, August 02, 2007 62 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thru 2012 Project # Ol-ERP-S06 Project Name Public Works Copy Machine Description I Copy machine to service needs of all division of Public Works, Contact Public Works Director Department Water Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $72,600 Justification I Making copies for various departments. Expenditures Equipment 2009 Prior 10,600 I Total 2008 Total Prior 10,600 I Total Funding Sources WF - Water Fund 2008 2009 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $800 2010 12,200 12,200 2011 2012 Total 12,200 12,200 Fu tu rc 49,800 I Total Future 49,800 I Total 2010 12,200 12,200 2011 2012 Total 12,200 12,200 63 Thursday, August 02, 2007 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2008 thrll 2012 COli tact Finance Director/IT Department Water Project # Ol-ERP-507 Type Equipment Useful Life 8 years Ca tegory Equipment Priority n/a Pro,ject Name Telephone System Total Project Cost $31,200 Description I Includes the PBX, the voice mail systems, and all telephone instruments, Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems, Justification I Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc,) Prior 4,700 I Total Expenditures Equipment 2008 2009 2010 2011 6,800 6,800 2012 Total 6,800 6,800 Future 19,700 I Total Total Prior 4,700 I Total Funding Sources WF - Water Fund 2008 2009 2010 2011 6,800 6,800 2012 Total 6,800 6,800 Future 19,700 I Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Thursday, A ugusl 02, 2007 64 '.' ~ ~ o r.n vi ~ ~ ~ .., o ~ ~ .< ~ 5 - ... ~ N - = 9'1 t- C ot ~ ... OJ = .; OJ Z ~ ~ ~ i ~ ::=:: p C ~ z g ~ ~ E; N o .:; N N ~ ~ o .... ;:; o .... ~ N .... t:! N .... .... .... .... c :? ,0 ~ ~ 00 .... r-- N >.:l .... v, .... ~ N !"l N o c o '" .... .... ~ o N ~ N ~ N r.n ~ ~ ..... E ~ \; ~ ~ ~ " ~ g ;;g~~ l; ~.~ -< c:....:: c " U :::: ~ z :.;: f .... :.;: g ~ ~ ~ ~ ~ o .:; N N ~ ,0 o g '" g ~ oc c C 0' '" c c ..... ~ l; '" ~ ;.., ~ <::E ~ c c ~ 8 c g c 8 c V) c c c V) c g c 8 o c c V) c o c V) c c c c c c V) c c c V) c c o V) 8 8 c 8 c c c V) c 8 "" c 8 8 c "': c c c '" , ~ ~ >. r.n ~ < .. l;U ] g cJ s:; s: ~ ~ ~ < = g >, r.n " " -g ~to5~ 5" ~8 ~_ oJ. ~ ~ ~ u~~l 8 ~ 8 8 ,o~"'g c 8 ,0 8 c ,0 c c c ,0 8 ,0 c c c ,0 c c c ,0 c c c ,0 c c c 0 c - ,oN o c c c ,0 52 o ,0 c c c ::Ii c 8 ::Ii 8 ::Ii c c c ,0 8 c ,0 8 8 x," ..::i r-- c c c ,0 c c c ,0 c c c ::Ii ~~~i~ 8 g c c o g 8 c g c 8 g 8 $ ~, g~~ o o o g o 0 is is "'0 M 8 g is o g 8 g o o c g o o c g 8 g 8 8 "'g is c g o c o g 8 g is o g o o o g V) M -g 1 ~~ ~ g " S r.n '" ~ ~ ~ oJ. t ~ ~ 3 (5 " 8' u z c g N oc 8 c ~ o c c ~~{ c c ~ ~~{ o o o ~ c o o ~ c o o '<t c c c ~ c c c ~ 8 ~ c c c ~ c c c ~ c 8 ~ c c o ~ c o c ..,,: c c c ~ c c c ~ o o c ~ C 0 C C C V) V) ":;\,ON N 888 oc C C -:N.c N '<t 8 ~ ~ 'o-oi=f 8 ~ ~ "":>.:l~ C ~.. x 0 C SS:;3 - -0 N ~ ~ 8 ~ ~ Otid-.:....:Jv{ - M - r-- $ 8 ~ ~ N-o,o 888 o V) V) N-o,o 8 o N ceo 0 C ~ ~ 8 s:; ~ ~";;;N~ '2 o C C 8 s:; s:; N X o C o 0 o 0 o 0 8 ~ ~ o \0 ~ 8~vs. c. ..c ..:; 888 0 C 0' C 0- "":-60 0 - N V) ~ 8 ~ g N ci..ccd o :? N 3 ~ ~ ~~r-: o :? N :? .:; ::Ii ti .~ .g. g- uU 't; ~ ~ r.ii '" ~ ~ ~ g ~_~~s E ~ .::,: ell Z ell ~ ::.: '5 5 ~ ;! E :J ~~8' ~ ~ ~ ~ ::::s ::::s ::::s a ~. ;:.. ..,,: C C C ..,,: C C C N C '<t 0, ~I .... !"l g: ;d; :.'l - ~ ~ ~ ~ OJ o o o o s:; V) V) V) N N N C 0 8 8 6 B c5 ~ffi ~~ffi~ o C 0, ~ ~ 0 ~ ] " ~ '" " '- ~ u ;'0..:: ~ 0 ~ ~ 8 :: is r", N V) o s:; N '<t o o -0 ;;; 8 ...: :9. o o r-- ..... V) ~ :;; g ~ ~ j ~ -jg S ~ :IJ ~ ~ ....._~ < ~ "tg: :r. ~ ;;:[ o o .:; 6 o ~ ~ 8 .:; ~ o o 0, 0' '<t 8 ~ ..,,: N ..... :9. o o -0 ~ o s:; :j g ~ o C ..... o o o o s:; o o N 8 ~ MN M C N ~ o N o o N ~ C o .:; ;;; 52 C ::Ii ~ -6 N g o C o C :j 52 C c 8 o 0 o C 0' 0' o o 0, ~ ~ ~ ~ ~ ~ ~ ~ -0 V) N .g I] fi: u ~ ~ = ;!J a ~ :: g ~ ~ .~ J: ~ ~~i~~~?>2 8~~~~_1 t~ <~:Eu~:-~~ o o oc r-" o o 00 '4 ~ r-" o i2 6 o o r-- 6 o i2 -6 o o oc '" 8 8 o V) ':TiM is 8 oe oe v) v) C o C '" 8 '" o o o '" ~. N '" 3 ~ t:: ~ . .~ .~ -o,,...~ Oc g ~~ ~ S I I I I ~ ~JJij~~ :: '5 ..;:: ::.. ~~i-g~~~ E ::: ::: ::: ::: ::: C ~ r-" $, ~ ~ r-" 8 .:; ~ C C N .:; ..,,: - V) ~ -6 52 N ..,,: N g ~ 0- i o 0 o 0 r-- r-- 60,,:5 o C o N o 12 -6 ~ ~.. N C o 0\, .:; N o i2 '" ~ 8 8 8 8 ~~~~ V') -=> ~ ~ 8 8 N N r- '" N C s:;, 88 -nv) o g o N o C is 8, .:; c C '" C C c, ~ 8 ~ ~ ~ ~ ~ .:; ~ ~ ~ ~ a~ffi~ffiffi~~@~ffiffia~ ~ i > ~ g ~ z ;.;: f ~ N ~ ~ c g r;f or. ~ N ..,. N N ~ ::> N c C 0- r;; N N N N N ~ c ~ Q =" N oe ~ f"- o N c c ~ ~ N or; N ..,. N c ~, ~ ~ N N N c c .o ~ N ~ ~ N x r=::: g 8 8 oe oe 00 V'l V'l c c S; ~ 66 '<:' '" c c c c V'l V'l NN ..,. ..". 8 8 0- ::1' ~ ~: 8 8 ~~ 8 8 .o .o ~~ c g N V'l 8 0- r;; ~ M ..,. o o o ~ o C f"- ~ c o .o ~ g g c c oe ~ c ~ .0 ~ c ~ N ~ o C ::1' ~~ c .o ~ o o .o ~ o c ~ ~ M~ V'l V'l o o ...~ c;; '<:' o c "" '<:' o o N, o 0 2;5 ~ ~~ o o .o ;;; o o .o, M x 0:- r;; o ~ rj o c .o ~ o ~ ~ o C N "" N o o ri ~ o .0 g r;; o i2 ~ oe ~ o o .o M ~ ~ g S ~ NOo-"; "':t oo::t N ~ c o ?iE ~ o i2 ~ c ~ ~~ o ~ ~ o c ~ ~ o g ;;; c g ~ c ~ ~ ~,c c c , 8 8 ~ g~c N 8 V'l g o c .o g; o ~ 00 N o o 0- fi o o r--' N c ~:. .0 N o o .o "" N ~ ~ M ~ M M ~ = ~ N N ~ ~ :.;;1 "'" ,.., - N M '" V'l .o :::::. ::::: ~ :;::: :::: :::: ~"g-g~-g--g = = = = = = ~~g~~g " ]~ ~ ~ ~ ~ 0; =0 '<l' U r~~J " ~ ~ ~ .i ~ :I) ~ 8 ~ '0 .~ Q 0>:1) ..... " ~ ~ u :;: < 8 8 8 8 8 8 c 8 8 3 ~" B ~, ~ N.~-,'", ~ ~ ~,_:,', ~ :'~.:..', ~ ~ ~ ~ g ~ ~_~ffi g3 ffi~ffi~t:3~ ~ N c o fi c g o 0- 2 8 N ~ c 8 ~ c o ~ c ~ "" ~ c ~ ~ ~ ,..; c g ;i c C 0- ,..; C ~ ~ ~ ,..; -.:: o i2 ~ 8 0- .,; N o o -.:: "" C' x C r--' oe o o f"- c;; N o C 0 S ~ g """"C;; N '" C C o ri .o o o ~ o o N N g 8 ~~ 8 c;; o C o o ~ ~ :::: V"'I r- M V"'I V"'I V') ~ u b c >.._ " b ~tg]~ ~~~~~ "" 0 0 0 " ~uu~z ['. x 0\ 0 N C"""l ""1' ;;;~~~~~ o C o 0 .o 0- C;;.,; DO C o \0 c;; 8 .o c;; 8 .o c;; o o .o c;; o C o C M N ~ri g c;; g c;; g c;; 8 8 o N 0\" r<"'~ -.:: o 8 c;; 8 o c;; o o o c;; o C o C f"- V'l oei g 00 o o f"- 00 g 00 o o f"- 00 ~~:< ~~p ~ ~ v; ~ M ~c::~~ o 0 f- '" III 2 8~~t ~ s .~ :3 ~g~g o C ..,. ..::J \0 o g r--' V'l 8 '<:' c;; '<l' 8 \0 N '<l' C ~ .,; 0- c ~ "" ::> 8 .o c;; 8 .o c;; x C N oe ~ C ~ N oe o c -.:: ~ g, oe -.:: c g c;; C 0:- ~ ~ ~ C o N ~ ~ o oe o o o ~ C C 0- '!j o C ~ ~ ~ f.{ C o N M -.:: o ~ ~ o ~ 00 ~ c i2 00 C C 8 i2 C oC N N c g ~ ~ !; ~ < ~ ~ :.. >. :I) ~ C ~ ]~ ~ I: Co) ~r=] ~~ ~ ::. c C ;::~ 888 M 00 r-~ V"') 0:- N N ::: ~ f"- f"- ~ 8 C' ~ g g 00 x" C ~, -0 ..::: o ~ N ::: ~ g a ~> ~ ~ .~- ~ ~ ~J o ~ ~ r-- ~ ~ r::i ~ ~ r?i r::i !") ~ r::i N N ~ N r::i N N ~ N oe N r-- r::i ..:> r::i or, N .,. N !") r::i N r::i N N ~ o ~ oe c o N ~ ~ ~ ~ ~ Z :.:: f :.:: ~ 0: N o o 00, c ~ ~ o 0 C C C C -::; -:;; ~ NNM V ~ ~ C c 82. o o 0- M ~ g ~ ~ o o N ~ 8 o o ~. 8, 0- ::: ::: V'\ V'\ ~ ~ ~ ~ ~ " '" ] ~ ~ ~ "tl ~ -- "tl"tl2~~ ~~ ~~g ~ .~ I- V"l ~ :~~5tj~,t"'"~""~':-~""~]~ ~~~~~~3] ~ !;;~~;~;;;;;; C o 00 g C 0 o C o N, ~ o o oe 0: ~ .::~~~ ,,...2 ~ 0 ~ ~ ~ ~ o C ~, ~ C o 0\ X N :>:: N N ~ N '" g r-- ori N o o C ....: :=: N N 8 00 C C N, N o f2 ~ ~ o N g o ori -:;; o o r-- ori N C ;~ ~ ~ ~ ~ ~ ~ ~ ~ e ;.... ~ ~ ~ .... ":l 12,' ~~~~~.,g o Co) ~ .&] b g ~ ~0u~-g 8..~~ Co.J:: 03:; .2 ~ 3 g 2 '" .- ::r.:.....:::-v:;=~~ oe oe 0- C N V'\ ~:-..:..f, ~ g oe _':_..:..', g ~ ~ g ~affi ~ffi~a ~ ~~ ~, '" N g -::; ~ o ~ 8 ~ ~ C C oe M ~ C o ~ ,; o o o X 8 g ~&i o f2 ~ o g o N o f2 o 0\ o ~. :! C ~, ~ o ~ ~ C C N ;i 8 0\' :=: N or; ~ o o V'\ ~ C o ~ :;; :=: ~ g ~ g' ::: ~ g V'\ 0: ~ ~ r-~ V'\ C o ~ ~ r.{ ~ x o N o f2 ~ C C oi N g 0\, g o r:f o o N -.i ~ o C 0, o C g S ~ ~: N C ~ i g ~ ....: r-- ~ o ~ 0: ~ o C ~ o C c, ~ N C o 00 o C -::; ~ :=: N, o ~, o g -.i N ~ rj C f2 ;;; C 8 ~ g ",' c o 0, -::; o o ~ ~ !:: $ ~ r-. g c- o-=> o ~ 00 ~ o ~ ~ o ~ ~ o o 0\ '4 g -:;; r-' ~ o o r-- i o o 0\ -.i o g N ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ::: ~ ~:-' ~ ~ ,j(, "j "tl .". ~ ~ ~ 2 2 :::: ~,-,_:....__:..> S,~C) , ';. ';. 2 2 ; . i]]]88~t:~_ - oc.c.=I:.)(,J::::~ e: ~ ~ 5;; 8 >< >< Cl Cl u ~ '""',_::" -g 11: ~1-c56=<< _ E u:: _~ ~ M ~ = U 0 0 U ~~~N 0 3~tt~-g u ~ ~ ~ ~ :- ~ ~ ~ ~ ~ ~ ~ ~ ffi N ,.., ,.., ~ 2 ~ ~ ~ ~ o 0 -g-.a .3 .3 ~ ~ u ] 0 ~~~ frCJ U ~~8~~V3 ~ V'\ =;-_:.', ~ ~ V'\ ~ -::; r- 00 oe 0\ 0\ C ,;_..:..', ~ ~ ~ ;:-..:..'. ;:-..;.',' ~ ~ 2 ~~~. ~~a ~ o :3 :Il o ~ ~ ~ -gQ 0~C)~~ k~~:i3 N"",:!~~ f""l(""'ir"'O(""'iMf""')f"i ~ffi~~ I- ~ N ~ N ~ N ~ ~ ~ N ~ <:> '" ~ N ~ <:> '" '" N :e <:> '" I- ~ ~ N v; '" ~ :; '" ~ N '" '" N N ~ N ~ N ., ~ :r. ~ g ~ Z: f :.; c c c $ N r-. <1-'0 :: ~ ~ ..". M ..". X c ~ ~ 8 8 c 0- ~~ ~ ~ ~~ o ::: ~ ~ -'" u 2 r- ~ :5 c '" c ~ ~~~-g M ~I :- -'" < '" ;1; o NMVi ~ ~ ~ ~ ~ ~ ~ ~ ~ c c c vl c c c. 8 ~ 8 8 c V'\ vl-6 o i2 00 o ~ ~ o o :>0 ~ c c c vl o ~ -6 8 N N o o M N c ~ '" ~ ~13 :1)135 ~ u 0 :I) ~~~ g ~ u 2~~ <::: 8 ~ ~ v ..:J :>0 ~ ~ ~ ~ ~ ~ Q 0; x 0- 8 ~ o o c 00 '7 o ~ g 00 o 0 c C I- l- e; ~ ..:J ::; N ~ o i2 ~ ::; :>0 ~ Q ~.. .::; o ~ N o c ~ ::: ::: ~ ~ ~ ~ 9 -'" ~I-'" ~ ;1;, ._~: ~~5 ;; 15 ~ ;( ~ > "1" r'j :Q 8 N vl '7 o o .::; ~ o ~ g 8 ~. .::; N 8 o ~ 8 8 o c vl . o o o vl c i2 00 o 0 i2 i2 o-~ V'\ V'\ o o o vl 8 :>0. .::; ~ ~ E ~ 2 ~?;~5 ~~UV')t/j jj~~~ - u~~~ cJvc:lf-:::::: ~V)~~~:gr;;~ ;:'.:...' ::::::.:,.',. = ~ = ~ ~ ~ _ a;: 8~ .::; ~ N c ~ vl '7 o o N ~ N o o o 00 '7 8 .::;. ~ 8 00 x oc 8 M N o o oc. o c 00 vl 00 c ~ N o o ~ N c i2 00 c o '<t -6 N 8 ..:J ~ c c ::. c N o 12 ~ o c .::;. o 8 vl o c V'\ N o C :>0 -::: o i2 -6 I- 8 ~ ::: ::: ::: ~ ~ ~ ~t .? ~ ~ ~ w ~.? 1....<< ~~1 ~ ~~:=.ua~ p i-'0~-'0~:-!~~ #, ~ ~~, _~ u U') ?; '-' - :;0: Co f:O ._ 222ca::.o ~ C)~~~~~:2 8 8 c 5' ~ c:- ~ a 8 c 8 8 :? O? q- c:- ~ ~ ~ ~ N 8 N ~ 8 ..:J ~ ~ 00 :>0 o ~. 8 '" ~ N ::; 8 I- r-, 0' '" V'\ V'\ Q oc .,,: ~ c c .::;. ~ N o 12, ~ c c c ~ ~ N c c .::; V'\ N o ~ N <>0 ..:; x x c S; N I ~ .... :2 ~ ~ :I) ~l ~o ~Ij '" u c V') c;- Q ::; ~ ~ :::> N ~ N ~ on N ~ ~ ~ N N N N N ~ N ="' N oe N r- N ~ N on N N ..., N N ~ ~ :::> N ="' :2 N ::51 ~ ~ ~ >= :I: ~ S2 ~ z ;.;: :: ;.;: ~ :::> N ~ ~ :q :::> N ;; ~ ;:l ~ N N :::> N N N :::> N ~ ="' ~ oe :; N ~ N on N "1' :; N ..., N N N N N ~ ~ N 3 ~ p ~ ~ r-"' ...: g ~ 8 8 NO OC 00 N g g r-P ~. ~ N C, C 0 C 0 ~i ~ 8 8 ~ 8 ~r-. Pv{ ~ ~ ~ ~. ~ ~ ~ ~ ~, N C r- -;t N 8 8 -;t r- oC ' ~ ~ C 0 C 0 f'\ ~ ,.-~ ~ ~ ~ ~ ~ r-~ ~.. ~ ~ x 8 x, ~ ~ ~ C 0 8 g oivi ~ N c ~ ~ 8 ~3~v) 8 ~ ~~ ~ ~, o ~ ::: o C o 0 -;t N ~~ o 0 o 0 - ~ vi vi V') V') - N o 0 o 0 OC ~ , ~. ~ !;:; C 0 o ~ ~ $. o 0 g ~ c;;c;; N O. ~~ ~~ g '" ~ 0 " 0 z Z 22 ~ ~ ~_" ~ U t:3 t.:.: VJ ..... ~~~~~~ 8 C vi 8 o vi o C 0 o C 0 o t"""", - vir.tiC;; o o o vi 8 o vi 8 vi 8 vi o C o vi 8 ~ g ~ g vi-.iC;;C;;C;; V') V') V') o o o vi o C o vi 8 vi 8 vi o o o vi 8 8 8 8 o - OC :>0 v{N~0 o o o vi o o o vi 8 o vi ~ 8, ~ ~ r.J5-.=NN 0- o ~ vi -;t 8 N vi r- N C 0 o 0 C ~ ~~ o ~ ;i C 0 C 0 C :>0. ,..: N 8 8 8 8 V') OC 0- V') "':~~N N :>0 f'\ N o X g r:: 00 x" o o ~ r- -;t ;~ o o ~ ~ o ~ o ~ -.i o N ~ 8, ~o ~ g ~ ~ o-'viNN M o o N N o g ;2 o o ,..,.. N c o o r-' V') '" ~ Oij z ~~3 ~ ~ 2 ;;: Oij02VJ;: 8 ~ vi N o o 00 00 o C;; oe -.:J 8 N N ~ o c C N 0- 8 ~ vi ~ 000 C 0 C - 0 r:i-:v{ 0- 8 N ~ 8 ~ ,..: r- ~ 8 o 8 0- N ~ ~ r-: ~ c g. ~ ~ ,..: e"; ~ ~ 8 ONvi ~ c-o o o 0- -6 ~ ~ N :c 8 ~. 00 ~ o g o o c "'" oi g; ~~ r;; ~ oe ~. -, ~ ~ ~ ~ ~ ~ ~ ~ 0 ~ ~~;Q 2 2 E Z <: c, ~ 2 =,~" t; u ~ _r- VJ ~ ~ <: ~ _ u <: ~ C o C vi x c vi C 0 C C 0 C C M r-j v{ oc ~. 0-. N o c vi o 8 vi 8 o vi o o o vi o o o vi 888 o 0- vi~C;; r- c o o vi x o vi 8 C vi 8 vi o C vi 888 o - -c v{ N ,.-; x o vi c 8 vi 8 C vi C C 0- C;; ~ i2 o C ~ .,; 00 C ~ ;[ ~ g ~ ~ -;t c ~ r-: o o oi oe C C -.:J P: C C C c;: N o ~ ~ o ~ c;: "'" C o 0- oi oe C C o oe e ~ ;;e ~ ~ ..., ~ ~ ~ v:. '1. on =" oe ~ ~ =" "1' -= -= ~ r- ~ 0i5 ~ -= r-. "i ~ ;r. e c oe ~ r-: ;: r-" r- ~ =:. N -= oe -= or. r- "i r- ="' ..,. ~ ="' -= ..: oe -= -;t ..,. -;t ;1 ~ ;; ~ ..,. -;t ="' ..; ..., "t , ~ ~ :< ~ Z -< ~ ~ :i -< 8 8 C g~ ~ 8 8 C N g~ ..,. o 8 ~~ c 8 o ~ g~ ~ ~ 8 ON -;t oe 00 C 0 o 0 o N 0C;; "'" 0' -;t 8 8 o ~ g~ ~ 8 8 o ~g N. o 8 8 0' ON -;t ::g: o 8 8 oc or": -;t oc '<:'. c 8 o r- 0"": ..,. -;t V') 8 8 o f'\ ~Q V') ~ 8 C "'" 00 ~ ...:: "'" C 0 8 ~ ~~ N 8 ~ vir-: ,.., 8 8 V{d ,... ;g 8 8 C r- gg M o 0 8 ~ g~ oc g ~.. g~ U~888888888888 ~ ~ ~ N ~ M ~ ~ ~ ~ ~ ~ 0 t3 N.:;.r-"'MrJiv{~Nr-:Nr-:r-~ > v)Nr"i~~N V1r""l -< - -- - o 0 o -;t o oc v-lrri N N x 8 ~ 8 8 888 8 8 8 8 ::31 c. oe. O. N. N. ~. -. ,.., r-. -;t. -=>. -. ~ ~ ~ ::g: ~ ~ 8 ~ ~ ~ ~ ~ 3 ~ - V') -.:J 0' 0- '<:' - -.:J .. N N N ....: r-.f 6 -< ~ 0 < Z ~2 Z 2 :5 t:3 ~ ~ Z (,) t.:.l t.:.J o Z Z g ~ Z ~g ~ ~ ~ :ij<:~u (3 ~ ~ ~ sr-~ffi ~ B <: ~ ~ ~ :s ~ t.:.l~(-~~ ~ U 0 N < U u Z Z g ~ ~ ;S~VJ ~t;;t~ ~z5~ ::J ~ t.:.l < o t.:.l t.:.l ~ ~ ~ _ ~ 2 2 ~ ~ z 5 gg ~ VJ Z ~ <: :n ~ o ;$ ~ ~ f- ~ f.; u ~_ ~ ~ 5 :i5~R''- ~~;:~ ~ ~ c ::E toVJ::: 5~~5 g~e~ ~z~ g 5 ~ c3~~:n ~ ~ ~ v1Nr-.: ~ ~ ~ 8 1i5 x ~ ~ C ~~~ ~V)~ ~ ~ t ~ 5 - S~ :::; ~ ~ ~ >bP "" Z Z -',_z-:, [2 2 ~ ~ ~ ~~B ~ 8 ~ ~ ~ ~ ~ g r'""~v1NM~"': 0" N N r- ~ g ~ g ~ ~ ~ g ri 8' ~ ~ c;: ~ r-: ,..,.. - ~ ~ 00::-... N z ~ ~ -~-~ 2 f- ~ :?; ~ o e:,_" ~ ;2 <: :.:: < u < ;$ ~ ~ ~ ~ rr~G:- ~ ~ ~::J :i5 ~ ;? ~ ~ 0- -=> o g. ::: o g -6 N oc N "" Z 2 ~ ~ 5 8' ~ ~ ;;: ~ ~ -' "" ::3~ ~ t:.. ~ 3 2 ;;: VJ ;: EQUIPMENT & BUILDING INVENTORY 70 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 07/15/2007 CURRENT REPLACEMENT UNIT # YEAR MAKE MODEL COST FIRE DEPARTMENT 102, 1989 FORD L9000 TELE-SQUIRT $240,000 103, 2006 PETERBIL T PUMPER 403,300 104, 1991 PETERBIL T HEA VY RESCUE 190,000 105, 1998 FORD CROWN VICTORIA 22,000 106. 1998 CHEV LUMINA 2 1 ,000 107, 1993 PETERBIL T PUMPER 225,000 108. 1995 CHEV 4X4 LITE RESCUE 25,000 109, 1972 STUPHEN AERIAL TRK 750,000 110, 2000 FORD CROWN VICTORIA 24,000 112. 2006 DODGE DURANGO 28,300 1 15, 1952 MACK PUMPER 4,000 120, 1995 CHEVROLET SUBURBAN 121. 2005 FREIGHTLINER M2 POLICE DEPARTMENT 200. 2004 FORD CROWN VICTORIA $28,100 201. 2004 FORD CROWN VICTORIA 28,100 202. 2004 FORD CROWN VICTORIA 28,100 203, 2005 FORD CROWN VICTORIA 28,160 204, 2007 FORD CROWN VICTORIA 29,000 205. 2007 FORD CROWN VICTORIA 29,000 206, 2007 FORD CROWN VICTORIA 29,000 207. 2002 FORD CROWN VICTORIA 28,000 208, 2007 FORD CROWN VICTORIA 29,000 209, 2005 FORD CROWN VICTORIA 30,000 211 2006 JEEP LIBERTY 18,800 212. 2002 CHEV TAHOE 26,000 213, 2003 CHEV IMPALA 25,000 215, 2002 CHEV IMPALA 18,800 216. 2005 CHEV IMPALA 20,000 217. 1999 FORD TAURUS 17,000 218, 2006 FORD 500 21,800 240. 1999 CHEV P40 V AN 25,000 241. 2001 CHRYSLER PT CRUISER 18,000 71 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 07/15/2007 CURRENT REPLACEMENT UNIT # YEAR MAKE MODEL COST STREET/TRAFFIC DIVISION 301. 1997 CHEV 3/4 TON $21,000 302. 2006 FORD F250 26,500 304, 2000 FORD F-450 34,000 305. 1997 FORD 1/2 TON 18,300 306. 1992 CHEV 4X4 1 TON 22,000 307. 2006 FORD F350-1 TON DUMP 27,400 309. 1995 CHEV 1 TON TRK 28,000 310. 1989 INTERNA TIONAL SGLAX DUMP 70,000 312. 2005 FREIGHTLINER SGLAX DUMP 98,000 313. 2001 FORD L7501 72,000 314. 1998 FORD L T 8500 86,000 315. 1996 FORD L-8000 85,000 316, 1995 FORD WATER TRK 81,000 318. 1968 FORD BOOM/AUGER TRK 8,500 320, 1991 CA TERPILLER LOADER 926E 90,000 322, 2005 CATERPILLER LOADER 938G 157,800 324, 2004 BOBCAT SKID LOADER 30,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 TERPI LLAR BOX PAVER 18,000 342. 1991 TARGET CONCRETE SAW 2,400 344. 1996 SNOGO WK 800 58,000 348. 1989 TRAIL-KING TK6V-I200 3,000 349. 1989 TRAIL-KING MK6V -1200 3,000 350, 1995 TOWMASTER T14 4,000 FLOAT VEHICLES 401. 2000 CHEV IMPALA $17,000 ENGINEERING DIVISION 700. 2000 CHEV SUBURBAN $14,500 72 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 07/15/2007 CURRENT REPLACEMENT UNIT # YEAR MAKE MODEL COST BUILDING & EQUIPMENT SERVICES 703, 1999 DODGE DAKOTA 4X4 $18,000 704, 2005 FORD F250 25,400 705, 1995 FORD F150 15,000 PARKS/FORESTRY DIVISION 800, 2001 FORD RANGER 4X4 $18,000 803, 2004 FORD F350 23,000 804. 2004 FORD F350 23,000 805, 1998 DODGE RAM 3500 24,000 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 824. 1996 TORO GROUND MASTER $16,000 825. 2001 TORO 455-D MOWER 40,000 826. 2004 TORO Z587L 8,900 828. 2001 DEW EZE ATM72 21,000 830. 1987 OLATHE TURF SWEEP 8,500 832. 1997 VERMEER STUMP CTR 630A 15,400 833. 2004 BOBCAT SKID LOADER 22,000 834, 1993 BRUSH BANDIT CHIPPER 250 14,000 836, RYAN SOD CUTTER 2,000 840, 1991 VICTORIAN TRAILER 2,000 845. 1997 REMACKEL TRAILER 5,000 846. 2001 DRESSEN 8110 2,000 73 CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 07/15/2007 CURRENT REPLACEMENT UNIT # YEAR MAKE MODEL COST HRA 411. 2007 CHEV 2500 HD $17,500 WATER/SEWER 500, 1997 CHEV C 1500 $17,000 501. 2004 CHEV 4X4 3/4 T SIL VERADO 24,000 504. 1996 JEEP CHEROKEE 18,000 505. 2007 CHEV CC25753 24,000 506. 2006 CHEV SIL VERADO 20,700 508. 1996 CHEV 3/4 T UTILITY 18,000 530. 2001 STERLING V AC-CON 180,000 533, 1993 CA TERPILLAR LDR-BKHOE-446 50,000 534, 1997 KOHLER GENERATOR/TRL 11,000 535, 1992 KOHLER GENERA TOR/TRL 10,000 536, 1989 FLEXIBLE RODDING MACHINE 25,000 540, 1982 SULLAI R AIR COMPRESSOR 12,000 542. 1994 WACKER TAMPER 4,000 REFUSE 901. 2005 PETERBIL T 320 $162,000 902, 1999 VOLVO WX42 150,000 903. 1995 FREIGHTLINER FL- 70 54,000 PAVILION 801. 1996 CHEV 4X4 TRK $19,100 809, 2003 OL YMPIA ICE RESURF ACER 85,000 74 Location/Descri ption City Hall 1010 1st Street S. Police Station 10 I 0 1 st Street S. Fire Station 101 17th Avenue S. Hopkins Activity Center 3314thAvenueS, Ice Arena/Pavilion 11000 Excelsior Boulevard Arts Center 1111 Mainstreet PW Admin/Garage 11100 Excelsior Boulevard PW Cold Storage Bldg # 1 1 I 7 -12 I 17th A ven ue S, PW Cold Storage Bldg #2 I I 7 -12 I 17th A ven ue S. Moline Reservoir 10421 Excelsor Boulevard Blake Tower Reservoir 151 Tyler Avenue S. Well # 1 Filtration Plant 10421 Excelsior Boulevard Filtration Plant 140 I Elmo Park Service Road Well #4 Workshop/Storage 1401 Elmo Park Service Road Well #5 1205 Highway7 CITY OF HOPKINS BUILDING INVENTORY July 2007 Replacement Cost $3,285,000 3,660,000 3,963,000 1,153,400 3,839,872 4,739,264 5,419,179 330,084 418,015 1,406,795 703,398 181,710 1 ,2 I 3, 1 1 6 . 246,424 99,649 75 Location/Descri ption Well #6 801 Highway 7 Lift Station # 1 - 21 st 202 21 st Avenue N. Lift Station #2 - Drillane 619 Dri lIane Road Lift Station #3 - Lindee's 90 I Cambridge Street N.E. Lift Station #4 - L TL Meadowbrook 244 Meadowbrook Road Lift Station #5 - Big Meadowbrook 6601 Excelsior Blvd. Lift Station #6 - Ronnie's 8546 Excelsior Avenue E, Lift Station #7 - Valley 8016thAvenueS. Band Shell - Downtown Park 16 9th Avenue S. Concession Stand - Maetzold Field 1215 1 st Street N. Park Building-Beach - Lifeguards 5200 Shady Oak Road Park Building-Beach-Concessions 5200 Shady Oak Road Park Shelter - Office/Bathhouse 5200 Shady Oak Road Park Shelter - Burnes 201 Park Lane Park Building - Central 101 17th Avenue S, Park Building - Harley 108 Jackson Avenue S. Park Shelter - InterIachen 220 Homedale A venue Replacement Cost 99,649 93,786 87,925 82,064 128,956 193,434 128,956 168,913 29,763 141,706 168,096 162,294 317,047 42,736 99,109 17,585 13,583 76 Location/Description Park Building - Oakes 301 Tyler AvenueN. Park Building - Valley 800 7th Avenue S. Dow Towers (76 Units) 22 5th Avenue S, 20th Avenue Townhouses (10 Units) 29 20th Avenue S, Parking Ramp 1 Oth Avenue and Mainstreet Depot Coffee House 9451 Excelsior Boulevard Overpass Skate Park 100 Washington Avenue Replacement Cost 33,998 40,378 HRA HRA 3,844,068 408,4 72 6,376 77