Loading...
Memo-August 6,2008 2009-2028 Equipment Replacement PlanCITY OF HOPKINS MEMORANDUM Date: August 6, 2008 To: Mayor & City Council From: Christine Harkess, Finance Director Subject: 2009 -2028 Equipment Replacement Plan Overview The City of Hopkins is beginning the process of establishing the 2009 -2013 equipment replacement plan. Every year the city council reviews with the city manager and staff, the equipment planned for replacement for the next five years. The goal is to ensure the city's priorities and objectives are being met and the funding sources are reasonable and available Departments were once again asked to assess the equipment planned for replacement, evaluate the estimated cost and life expectancy of the equipment with the intent to prolong equipment life expectancy when practical and to refurbishing equipment instead of replacing it. Through a combination of several equipment changes and a better estimate of costs, departments were successful in accomplishing this goal. Included in the ERP draft is an explanation of the changes that are considered for implementation. ERP Goals • Maintain the integrity, reliability and safety of city equipment. • Provide funding for replacement of current equipment as needed. • Forecast funding needs and tax implications to assure strong long -term financial stability. Attached is a draft of the 2009 -2013 equipment replacement plan. FINANCE DEPARTMENT Background EQUIPMENT REPLACEMENT PLAN 2009 - 2013 The Equipment Replacement Plan is a twenty -year forecast and a five -year plan of equipment needs in the City of Hopkins. It is intended to inform the Council and citizens of the major equipment needs on the horizon. The first year of the plan becomes an adopted equipment budget and relates to the operating budget of the equipment replacement fund, which is approved on an annual basis. The remaining nineteen years represent an estimate of equipment needs and funding capabilities of the City. Funding requirements vary from year to year. In order to maintain a fairly consistent levy each year, the twenty -year schedule is projected with a 3% inflation factor for operating expenses and a yearly average dollar capital expenditure of $772,900. The cash flow requirements to fund the equipment needs in the equipment replacement fund, will experience a roller coaster effect over the next 20 years given the projected equipment needs and 3% inflation rate. Available funds will remain about the same through the year 2012, and decrease each year thereafter.. It is anticipated that the intragovernmental 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 implemented, revenues in 2017 will have returned to 2002 levels. The charges after 2017 will continue to increase each year, but at a slower pace. The future increases in charges to the general fund will not provide sufficient funds to carry us through 2027 with the current replacement schedule. Each year staff reevaluates the equipment needs and adjusts the schedule accordingly. Changes to the plan are reflected in the document. Refurbishments, extended life expectancy and closer cost estimates of replacements have been incorporated into the plan. The equipment replacement charges in the general fund represent approximately 3% of total general fund expenditures. Future increases each year are needed to fund the equipment replacement plan without issuing debt. The Equipment Replacement Plan's basic premise is scheduled replacement of present equipment. A new item must, in the year proposed, be presented in the annual operating budget with a stipulation that replacement will be necessary in the future. Flexibility of the Equipment Replacement Plan is established through annual review and revision, if necessary. Highlights of changes from last year's equipment replacement plan for the years 2009 -2013: City Hall: Election booths were added at a cost of $6,400. In 2008 the city replaced approximately 1/2 of the voting booths currently in use. The remaining booths are over 25 years old, many no longer have functioning lights and each year a few are taken out of use as they can no longer be repaired. Fire: A lite rescue truck originally scheduled for replacement in 2009 at a cost of $40,000 has been eliminated and replaced with a Quick Attack Pumper /Rescue, a new item scheduled for purchase in 2012 at a cost of $234,000. This new vehicle will be used for responding to medical calls and small fires and will allow the department to reduce the number of personnel responding to small fires. It will also allow the fire department drop one engine in 2022 while maintaining our ISO rating. In addition, the Heavy Rescue truck totaling $491,000 and the Pirsch Pumper totaling $563,100 were eliminated from the ERP as these vehicles are no longer needed in the Fire Equipment Fleet. Together these two vehicles will save over $1,000,000 in the ERP. A duty chief vehicle originally scheduled for replacement in 2013 at a cost of $34,600 has been moved to 2009 and the 7 -year replacement changed to 5 years with the vehicle being replaced again in 2015 at a cost of $42,200. Fitness Center — the elliptical machine originally scheduled for replacement in 2009 has been eliminated and dumb bells added which is cost neutral at $5,000. Police: The police utility 4x4 vehicle was evaluated and the replacement moved from 2009 to 2014. Digital squad car cameras purchased in 2006 with police department funds have a life expectancy of 5 years. They were added to the ERP in 2008 for replacement in 2011 at a cost of $42,600. Future replacement costs were left at $42,600 as technology prices have historically been going down. Mobile Data Computers installed in all squad cars and used to receive calls from dispatch, query information and communicate from car to car was scheduled for replacement in 2012 at a cost of $54,500. The cost has been increased to $62,700 to more accurately reflect the actual cost of the computers and docking stations. Future replacement costs were left at $62,700 as technology prices have historically been going down. The police computer system budgeted at $700,000 in previous ERP's was reduced to $500.000 in 2008 to better fit within the overall ERP plan. The replacement cost was returned to $700,000 for the current ERP plan, again reduced and funded over a two year period at $200,000 per year in 2013 and 2014. Previously this item has been scheduled for replacement in 2011. The exact cost of the replacement is unknown and our best estimate was used in placing this item in the ERP. Cable TV: Activity Center: Public Works: All items preciously in the ERP have been moved to the CIP. Previously scheduled for replacement in 2013 the refrigerator /freezer has been moved up to 2010 due to increasing maintenance issues and the age of the unit (has been in service since the Activity Center opened in 1980) The lives of the equipment are annually reviewed by the public works department and over the past 10 years they have extended the lives of the 1 -ton trucks from 8 to 12 years and the dump trucks from 13 to 15 years. Extending the lives of major equipment comes with the risk of increased maintenance costs. When maintenance costs become unmanageable the equipment will be put on the schedule for earlier replacement. Streets /Traffic No changes to items scheduled in the previous 5 -year plan. Parks /Forestry The cost of the aerial lift vehicle was increased from $110,000 to $130,000 to reflect actual cost. The vehicle is scheduled for replacement in 2009. The large turf mower originally scheduled for replacement in 2013 has been moved to 2011 based on maintenance experience and lowest overall cost. This mower is required to efficiently mow the large parks. Water No changes to items scheduled in the previous 5 -year plan. Sewer No changes to items scheduled in the previous 5 -year plan. Refuse No changes to items scheduled in the previous 5 -year plan. 00 o F4 O 0 W M N , `,--i r-■ O A O O N 00 O O O O N O 1D N U M O 00 d © 00 v- M •--- 0r1 •-• M M kD tt O M ON O N - O VD 1/4/0 N Q\ ,-� O }" 00 t- O •:r CT O .--1 O OT O 0T O O O 00 .-. O O O O O .. 01 O N 1D 00 D \ M 0 1D N c• c vi 4� .t N O M N N M O N M 15 © 00 1D 1-' = o N 10 N 1D N N M .--i 00 r~ N -. d' U y N 00 M V O� Q, M O� c • E CT "O 4 c cd © o O 1D OT O re) N O O © 1p ■1p 00 O O © rJ [� © [1 �-- Q T O O 00 0 0 O N OT O O � . 1-1 O M O ' t� k t- O O CT 1D © N O ; O� a1 O M vi N Q1 N vi 00 !t 0.7 � Q� v' k Q\ M N 1D N N d O M M 69 69 ,- .� O Q. II a ta U W O N t © M N O O N © O \D N Q■ - 0 ,- , N O d N O 'ct 01 O d' r•-1 N O t - M -O N 1G O --4 N O O 00 ' 00 'l 1D M C _ O M r M DD N 10 r" D; N v� N 00 O O N 1D N N N M O .--+ h r. O O O M e. .1. � ON ti c 0 --I .0 U ct Q O .. O +.+ cn N O O M .1 O 01 v� v) © © [� . ON 1D C O 1D O O d O O et © o O © r, N -.. - M O ¢' V 1 O �-+ DD O O r••n 0 N O� 1p [ v) 3 1D [ O M 10 d [� 00 N O� ai !h Sri © co En CA O 00 N 1D N M N M C V ~ k ccl r" r~ ti - 00 N 0 O -= - 0 v' o C) 00 In O M O O O 00 OT O O 01 ts- M U 0 N -0 ct ct 4. 00 N O .i• O © O 10 00 O O 00 1p 00 O� Q1 -a N .•-+ c O O O N -- O 00 a\ et h 1D 00 -- --+ F. O M O O O O s' O t- d' 1p V 06 ' N CO N V) N M N 00 1D M 00 U •--, 00 M N d 00 d' 10 O a v r.. r.. ,-, ^y ,--- V7 1D N N r■r 00 V1 00 M N N - 1D O\ O ,--, 0 O • O 00 O a1 O 00 O 1D N N - M 1D 0 0 O v- 0 v1 07 N ' N 'O cu N O O O k r0 00 ' N 0 d' N 0 M d N O O h M v 00 0) r~ h • 3 v) d cci 7 "Cr 10 .••■ •--- 00 v7 N N 0 \ e 9 ,--+ o © V) In 00 M O O N 01 N 0 N 00 O N w U ., U .-: m rn li C i vv) C U 4? N O 00 0 M o N M M M - ti r~ t- M ,-, O 0 r-( ON d - M en N en N U .- a U s. 0 O 00 0 0 0 • O U .- 0 0 0) 69 O 0 0 ON 0 0 - 0 1D 0 01 0 czt vi N d - N 00 o O 0 •--I ,-- el al OD vj U 0 O o te g A en 1D 0) 0 0 U >, z E a) a w wc- 0 O 0 h C 0 of O 0 O O O O 0 0 0 O a O M 0 0 0 0 8 ^ O CD CD O O C O w c 0 0 O O 00 d M 0 0 O 0 OJ O M C C O 0 C 0 co O M CD CD CD O O C O O 7 00 O r<. M N O O O 0 00 O C O 0 O C O 0'7 O r1 0 0 0 O 0 0 o0 .7 O n M 0 0 O O W O f^, O 0 O O O O 00 C o c 0 0 o c 00 0 0 O 0 0 O M O O 76 O 0 0 0 0 0 7J O M 0 0 0 0 O O � C 0 0 0 0 0 0 r 0 0 0 0 7J O m O O 0 x 0 M 0 0 0 0 0 0 0 0 cc' -= r4 .6 ,,, N 7 — O 06 0 O O oo O O C DO r•. O O 0 0 0 0 0 0 a N O V1 W m :J -7 O M - M O 06 O O O O 0 0 M 0 O 0 0 0 0 0 0 0 00 O N N O , /1 J - N 0 0 O 0 O O 0 0 O O O 0 0 0 0 " 0 O O v1 7J O O O 0 0 O , 7 O O O 0 0 0 0 0 0 0 0 7 7 O 0 O O v1 N 0 0 O v, N O O O O O O 0 0 , N J O O O 0 0 , • •. O 0 o 0 0 v1 C 0 0 0 O O 7 O '1'1 7 N co 0 r-. C O 7 0 7 , o N Y O rr, ._ U C y u < c .� v! ▪ r,i = v < 0 ... < y r_ a � O O t a on .L .Oj v u U � u I-` 2. J G e C C = a^ E o .c • C u [:: [:] Y Y L • %J U ❑ — 5 G' < !t7 CJ at: P • 0 _ 3 3 3 l; 3 r r 0 C - 0 0 - O O _ C C v, N O cc 0 0 C O v1 0 0 O O C O O U1 O - O v1 C Oi 0 O O rJ V . O O O O 0 O C O fJ O O 7 f l f J N C C C C N N N N N N I � l 0 0 0 0 0 .� 0• '0 0 O O O O 0 0 , M C O 0 0 kri O O O O O O 0 M 0 — v1 0 0 N N N r. 7 N 0 0 0 O , 7 ..6' M N N C CD O 0 O N r N • 0 N r! O 0 0 O O O O C C O 0 — h X r C O'J OC OC 0o r r 0 O C O n r r 0 O 0 0 7J vi C C 0 DD N O O J' O 0 °O 0 0 Q c n o0 oc 00 0o „ vi vi r 0 0 0 0 N 0 O O 0 0 C h ,f1 0 0 0 0 0 0 O C C "✓. o 0 C f J N 0 v1 r , r ^. O n 0 0 - N M 7 h t O 0 rJ rJ �� N N N N N ^ L] ! L.) 0 0 0 0 0 [:.1 0 0 0' 1_• ._ 0 0 0 O O 0 0 O C C O O 0 O O N c 0 C 00 O O c V'1 O O O 0 O CC ;r O o c 0 r J G o 0 C G G .'J J ' T 7 0 G 0 O _ 0 0 7 7 0 0 0 C O O ry M, r1 r1 C C C 0 P a x r r: 7 0 0 0 c O 0 C — r. N r, 0 c o ° 0 0 0 0o x co N r: O O O N C C 0 0 0 0 0 0 0 0 0 a a a 00 n" r r a 7 7 7 ri O O O C O O o O x x 7 7 en n rri O 7 7 0 r'. C O O O o 0 v-J r4 N N N v1 7 7 0 0 0 0 N M, s ? r, 0 0 0 0 0 ` 0` 0 0 0 0 0 VJ x co •'1 N r 1 r, M in M . 0 0 O c DO x rr M, r'1 0 0 0 0 0 0 0 0 r r n ire . .7 r O N in in 7 r, C C C .0 V Cr r 0 O C O 0 O C 0. ri r ri r r, M M, r 1 O 0 O O C 0 ri rri rn r M. M• r, N c o o O r, M. N O C C 7 0 0 -- O N .'J 7 ^ '0 N N 0. 0 g, U .- u ' V U U U ^ — N in 7, 4 t c7 U V 7,, 7, 7 C n C ? U Z r 2 .:D 1 i y C U c7 _E3 < G •_ _ O -- r J" y 7 1 v', O O 0 0 ! O i fl N fl N f 1 N fJ N r.1 s r'? f! C .'0 V 0 0 0 0 o x a N N 0 Q 0 rJ O 0 v1 O M C a c c 0 0 0 N r n x 0 v n O O O O O .G 7 r , N n vj P ri CO rJ O 0 O O O r- 0 r O 0 O 8 a N O a c c a 0 a 0 C 0 0 0 0 0 0 O '0 P — c M N 0 0 .0 C 7 0 0 C J 0 a r, 0 F.-.I N O 0 0 r r ri y N v C C 0 C_ C 0 r r 06 x r 1 N — 7 O 9. O a r 7 r N C ? N 0 0 a ri C 0 C 0 r a 0 0 N o ° 0 r 0 r 0 O r i ^ n — N r, 7 rJ N r1 rJ N N N '0 r C c c a 0 0 00 0 0 0' O O a O a 0 C O 0 O C 0 7 C 0 0 O O O N O 0 o c • • 7 7 ,, 0 0 0 O O 0 0 0 N N M, 7 7 7 0 O O OC 0 0 O 0 0 c 0 7 N M 7 O O O O C Q• N C W rJ N N r. 0 0 O r J C v1 0 0 0 C M ' n r M M` r'i - O.. O. rte, r'. 7 — — C N O• O O O O O N M fJ O 0 O 0 ri r O .: O v1 v1 v� d' yJ yJ V, v"1 •/1 C O vl r — — — — N rJ N — -- — — — N ri — — O — — C J r-1 ? vl 0 r- h h . J.7 5: C — N r^, 7 •�1 !` T f Y_ A 77 r r t U: . :q Y. r rf J: . Y J' 0 0 0 N O v1 M 7 O O , N h 7 C 7 O C 0 0 v' 7 00 OG r. N 0 0 O O 07 O O O O O M O N 0 'J U =/ u O :G i r "- 0 1 C 6 G : U L t- _ — T 7 r-, v7 — C i-- , r it 2 2 2 ✓7 . - J ;/r ... it s 0 0 0 0 h 7 vi C N rr, 0 0 O 7 h o C 7 v r z r-. h n O O C O N 7 C M 0 0 O O C 7 7 v1 N 0 C M f ,_^. 00 r.--- -0- 0 O M N — N 0 0 0 0 0 0 0 r1 , N 7 M 0 O O C 00 7 C cc O 0 0 O O C 0 7 7 ri N M M 7 ^ J.1 N r1 N h h h h h vl Y v'1 f l N r N f 1 — — rJ h 0 f^, 7 0 , ^ h 1' Y_ _ — r 7 r', 7 v1 .. N N N N N N G/ N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N �..� .� 0 0 0 0 — 0 0 : 0 0 — 0 — 0 — 0 0 0 0 0 -—'0 0 0 0 0 0 0 0 J 0 0 0 — — — 0 0 0 c 0 v1 O O O • N 0 0 0 0 O 00 0 0 0 0 0 0 0 0 7 00 co cci 0 0 O 0 0 G O U U 1 " _ _ 7 Et g Q G G 2 C O O C J DO .� 7 O 8 O 00 `T 0 r 00 M N O O O r- 0 0 C 0 ✓ O O JD O O O 00 0 O W 0 O N O O co ce O O W O O O O co 0 O 0 0 r r- r 0 0 0 0 c c c c C O r C r O O a a' - C O a M 00 7 N T 7 CO - 0 ^ O _ C 5 p 0 Q V 'J` M G 7 r1 .-' r. O T o .: 00 00 O` - V C • - 7 N rJ O C • O O C O O 0 N N �7 r^. 00 C e, 4 7 O. O OC N N O C CO 0 0 O 0 O O ^ r• r r', — N 0 r. r', 0 8 cc Q` v1 .'7 00 7 00 O u r^, r J — — r- , r — a 0 7 — O — N N 7 C C CO 0C O 7 • h 00 © o c N r 00 a 00 00 O o 'V' - 4 00 vl 4 00 00 7 - N - M 7 rr O C 0' 00 0 DC • — O C O O O 0 r vl N N O r 7 O r1 , a a 7 v, 7 N 0 ' ' c c c c c c c c c c N r , 00 7 0•' r . O 0' v1 'S . 0 h O 4 7 O a , O' - N O 7 N 7 .7 O C 0 C O 0 O O C O 0.. 0 C O • O 0 0 O N r r 00 7 N 0 CO a O o0 00 a r N 0 a rr, r 0 — N 7 0 h — 0 a 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 -t- 0' r r r 00 0' - 00 0 00 m -7 -r a a a r- ' 0' o r O r — 0 ,, N — h N 7 DO en h 0 — N 0 0 00 0 O O 0 0 00 0 0 J 7 - 'J DO a O - O r O r 00 00 .'0 7 7 N — M 7 r'. O c O 0 • 6 O c O 8 O 07 00 en: N • r^. O ..7.. ▪ rJ 0 0 0 0 0 0 0 0 0 0 0 0 r') 7 N CO O 4 0 r'. 0 0 O 0 0 m - O 00 re, ' 7 0 4 , r; — N 4 N r 7 o O 0 ✓ 0' O r cJ 0 0 0 00 a 00 O • en. 00 O .7 00 .0 n 0 c c 0 O V 0 N O J 4 7 a O 7 x a 4 r N — M — CO O O c c 0 0 G 00 r Cc v o h r, 7 M O 00 N 00 N O M 4 00 c 0 0 O C O O 0 h V 0 7 O 0 0 vj - vl a r: O o0 N 7 r1 h rJ r T • c O 0 0 h 77 V' O r r 7 N m r r^. r•, h r+1 C 07 a Y 7 , 00 00 0 00 O , • /'1 N N r^. 00 , r - a a x 0 O C 0 0 0 0 0 0 0 C 0 0 0 0 0 0 0 0 o 0 0 - .0 CO 00 r T O h O ,r1 r J .. .J 0rl rJ M O 00 N v1 — h — ^ 0 r•1 7 N N 7 ■r. 7 0 0 0 0 0 0 0 0 0 N ' N h 0r 0' r' 0 0r 00 0 N 0 00 00 r O - O 7 r 7 h 5 Lc !' 1 > C z Z N < - < / N U N H f r Z Z < i i ^ > SLE - 7 O 7 d O O C h r r•1 4 r^. M r^• 0 0 0 O C 0 0 C O 0 '0 T r . c 00 0 00 r o kr 0r ^ 00 N r 1 N 0 `: O 7 0 C _ c _ c C O O G _ 7 N "" — f 1 00 — rn .0 0 a O 0 P• r N - r r rJ r — - N .G z O C r Q cri 0 O O N O C 0 7 7 N N r 7 O O C O O C O O O • C 0' r f i GO 0 r'. rJ r^, r7 0 O • N O fJ N r'1 0 0 00 0 G 0 0 7 0 O O 0 0 0 0 7 ,n n P. a C N r', N , vj Q' C r J r• r^, h r 7 J r 0 — 7 7 7 r. N 0 N — N Department City of Hopkins, MN EQUIPMENT IMPR O VEMENT PLAN 2009 thru 2013 DEPARTMENT SUMMARY 2009 2010 2011 2012 2013 Total Activity Center 14,000 15,000 29,000 Arts Center 12,100 12,100 City Hall Administration 38,000 38,000 114,000 38,000 38,000 266,000 Community Services 24,040 18,900 50,900 16,500 16,500 126,840 Fire 5,000 47,400 20,300 265,500 25,200 363,400 Police 66,600 133,600 199,100 134,800 368,600 902,700 Public Works: Engineering 21,500 21,500 Public Works: Parks /Forestry 194,200 32,200 91,400 141,400 25,700 484,900 Public Works: Streets/Traffic 42,300 164,700 327,600 327,200 861,800 Refuse 176,700 176,700 Sewer 6,800 6,800 Water 12,200 6,800 134,800 153,800 GRAND TOTAL 370,140 637,700 501,400 923,800 972,500 3,405,540 Friday, August 08, 2008 Department Network Server Telephone System Computers Fire 'Police Activity Center Total Arts Center 1 Arts Center Copy Machine 01 -ERP -1100 n/a Community Services [City Hall Administration Arts Center Total City Hall Administration Total City Hall Main Copy Machine - Oce' Copier City Hall Small Copy Machine Engineering Printer /Scanner Document Management Scanner (2) Election Booths Community Services Total Fire Total City of Hopkins, MN EQUIPMENT IMPROVEMENT PLAN 2009 thru 2013 PROJECTS BY DEPARTMENT 1 Duty Chief Vehicle 01 -ERP -103 n/a Extrication Tool (2) 01- ERP -109 n/a Copy Machine 01 - ERP - 110 n/a Thermal Imaging Camera (2) 01 -ERP -112 n/a Workout Equipment - Eliptical 01 -ERP -116 n/a Workout Equipment - Stairmaster 01 -ERP -117 n/a Workout Equipment - Treadmill 01 -ERP -118 n/a Workout Equipment - Weight Lifting 01- ERP -119 n/a Automated External Defibrillator (2) 01 -ERP -120 n/a Workout Equipment - Dumb Bells 01 -ERP -122 n/a 5,000 Quick Attack Pumper/Rescue 01- ERP -121 n/a Project# Priority 2009 2010 2011 2012 2013 Total Activity Center Activity Center Copy Machine 01- ERP -030 n/a 15,000 15,000 Refrigerator /Freezer 01- ERP -031 n/a 14,000 14,000 14,000 15,000 29,000 12,100 12,100 12,100 12,100 01- ERP -003 n/a 8,000 8,000 8,000 8,000 8,000 40,000 01- ERP -004 n/a 76,000 76,000 01- ERP -006 n/a 30,000 30,000 30,000 30,000 30,000 150,000 38,000 38,000 114,000 38,000 38,000 266,000 01- ERP -001 n/a 2,400 2,400 14,000 18,800 01- ERP -002 n/a 26,900 26,900 01- ERP -007 n/a 8,640 10,000 10,000 10,000 10,000 48,640 01- ERP -008 n/a 6,500 6,500 6,500 6,500 26,000 01- ERP -010 n/a 6,500 6,500 24,040 18,900 50,900 16,500 16,500 126,840 36,400 5,000 6,000 10,300 5,000 5,000 26,500 5,000 234,000 36,400 26,500 10,300 18,000 18,000 5,000 5,000 5,000 5,000 7,200 13,200 5,000 234,000 5,000 47,400 20,300 265,500 25,200 363,400 Friday, August 08, 2008 Department Project# Priority 2009 2010 2011 2012 2013 Total Marked Patrol Vehicles (6) Sergeant's Vehicle Police Administrative Vehicles (2) Computer System Copy Machine Network Server (3) Mobile Data Computers Digital Squad Car Cameras Tactical Ballistic Vests Public Works: Engineering Engineering Van Public Works: Engineering Total Public Works: Parks/Forestry 1/2 Ton Pickup Truck 4x4 3 /4Ton Trucks (2) 3/4 Ton Utility Truck Aerial Lift Tractors (2) Trucksters (3) Riding Mowers (3) Large Turf Mower Brush Chipper Public Works: Parks/Forestry Total Public Works: Streets /Traffic 4X4 3/4 Ton Truck with Plow 1 Ton Dump Truck (2) 1 Ton Traffic Boom Truck Tandem Dump Trucks (2) Water Truck Front End Loaders (2) Skid Loader (2) Sweeper Roller Trailer Public Works: Streets /Traffic Total Refuse 1 Refuse Truck (RAP -R) (2) Sewer Telephone System Police Total Refuse Total Sewer Total 01 -ERP -200 n/a 31,600 97,800 67,200 34,600 106,800 338,000 01 -ERP -201 n/a 33,600 33,600 01 -ERP -204 n/a 26,300 27,100 27,900 28,800 29,600 139,700 01 -ERP -208 n/a 200,000 200,000 01 -ERP -209 n/a 19,100 19,100 01 -ERP -211 n/a 8,700 8,700 8,700 8,700 9,000 43,800 01 -ERP -212 n/a 62,700 62,700 01- ERP -213 n/a 42,600 42,600 01 -ERP -214 n/a 23,200 23,200 66,600 133,600 199,100 134,800 368,600 902,700 01 -ERP -700 n/a 21,500 21,500 21,500 21,500 01 -ERP -800 n/a 26,400 26,400 01 -ERP -801 n/a 67,400 67,400 01 -ERP -802 n/a 32,200 32,200 01 -ERP -805 n/a 130,000 130,000 01- ERP -806 n/a 41,400 43,900 85,300 01 -ERP -807 n/a 19,800 19,800 01- ERP -808 n/a 22,800 10,300 33,100 01 -ERP -810 n/a 65,000 65,000 01- ERP -813 n/a 25,700 25,700 194,200 32,200 91,400 141,400 25,700 484,900 01 -ERP -301 n/a 30,400 30,400 01 -ERP -303 n/a 37,400 34,700 72,100 01 -ERP -304 n/a 75,000 75,000 01 -ERP -306 n/a 132,300 132,300 01 -ERP -307 n/a 133,700 133,700 01 -ERP -308 n/a 172,000 172,000 01 -ERP -309 n/a 31,000 31,000 01- ERP -311 n/a 164,500 164,500 01- ERP -312 n/a 45,900 45,900 01- ERP -316 n/a 4,900 4,900 01 -ERP -900 n/a 176,700 01 -ERP -557 n/a 42,300 164,700 176,700 6,800 6,800 327,600 327,200 861,800 176,700 176,700 6,800 6,800 Friday, August 08, 2008 Department Project# Priority 2009 2010 2011 2012 2013 Total Water Backhoe Loader 01 -ERP -502 n/a 134,800 134,800 Public Works Copy Machine 01 -ERP -506 n/a 12,200 12,200 Telephone System 01 -ERP -507 n/a 6,800 6,800 Water Total 12,200 6,800 134,800 153,800 GRAND TOTAL 370,140 637,700 501,400 923,800 972,500 3,405,540 Friday, Aug rsl 08, 2008 City of Hopkins, MN EQUIPMENT IMPROVEMENT PLAN 2009 thru 2013 FUNDING SOURCE SUMMARY Source 2009 2010 2011 2012 2013 Total Equipment Replacement Fund 370,140 448,800 475,700 923,800 837,700 3,056,140 HAC - Arts Center Fund 12,100 12,100 RF - Refuse Fund 176,700 176,700 SF - Sanitary Sewer Fund 6,800 6,800 WF - Water Fund 12,200 6,800 134,800 153,800 GRAND TOTAL 370,140 637,700 501,400 923,800 972,500 3,405,540 Friday, August 08, 2008 Source City of Hopkins, MN EQUIPMENT IMPROVEMENT PLAN 2009 thru 2013 PROJECTS BY FUNDING SOURCE Project# Priority 2009 2010 2011 2012 2013 Total 1Equipment Replacement Fund City Hall Main Copy Machine - Oce' Copier 01- ERP -001 n/a 2,400 2,400 14,000 18,800 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 Printer /Scanner 01- ERP -007 n/a 8,640 10,000 10,000 10,000 10,000 48,640 Document Management Scanner (2) 01- ERP -008 n/a 6,500 6,500 6,500 6,500 26,000 Election Booths 01- ERP -010 n/a 6,500 6,500 Activity Center Copy Machine 01- ERP -030 n/a 15,000 15,000 Refrigerator /Freezer 01- ERP -031 n/a 14,000 14,000 Duty Chief Vehicle 01 -ERP -103 n/a 36,400 36,400 Extrication Tool (2) 01 -ERP -109 n/a 26,500 26,500 Copy Machine 01 -ERP -110 n/a 10,300 10,300 Thermal Imaging Camera (2) 01 -ERP -112 n/a 18,000 18,000 Workout Equipment - Eliptical 01 -ERP -116 nla 5,000 5,000 Workout Equipment - Stairmaster 01 -ERP -117 nla 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 Extemal Defibrillator (2) 01 -ERP -120 n/a 6,000 7,200 13,200 Workout Equipment - Dumb Bells 01 -ERP -122 n/a 5,000 5,000 Marked Patrol Vehicles (6) 01 -ERP -200 n/a 31,600 97,800 67,200 34,600 106,800 338,000 Sergeants Vehicle 01- ERP -201 n/a 33,600 33,600 Police Administrative Vehicles (2) 01 -ERP -204 n/a 26,300 27,100 27,900 28,800 29,600 139,700 Computer System 01 -ERP -208 n/a 200,000 200,000 Copy Machine 01 -ERP -209 nla 19,100 19,100 Network Server (3) 01 -ERP -211 n/a 8,700 8,700 8,700 8,700 9,000 43,800 Mobile Data Computers 01- ERP -212 n/a 62,700 62,700 Digital Squad Car Cameras 01- ERP -213 n/a 42,600 42,600 Tactical Ballistic Vests 01 -ERP -214 n/a 23,200 23,200 4X4 3/4 Ton Truck with Plow 01 -ERP -301 n/a 30,400 30,400 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 Tandem Dump Trucks (2) 01 -ERP -306 n/a 132,300 132,300 Water Truck 01 -ERP -307 n/a 133,700 133,700 Front End Loaders (2) 01 -ERP -308 n/a 172,000 172,000 Skid Loader (2) 01 -ERP -309 n/a 31,000 31,000 Sweeper 01 -ERP -311 n/a 164,500 164,500 Roller 01 -ERP -312 n/a 45,900 45,900 Trailer 01- ERP -316 n/a 4,900 4,900 Engineering Van 01 -ERP -700 n/a 21,500 21,500 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 Aerial Lift 01- ERP -805 n/a 130,000 130,000 Friday, August 08, 2008 Source Project# Priority 2009 2010 2011 2012 2013 Total 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 Large Turf Mower 01- ERP -810 n/a 65,000 65,000 Brush Chipper 01- ERP -813 n/a 25,700 25,700 Quick Attack Pumper /Rescue 01- ERP -121 n/a 234,000 234,000 Equipment Replacement Fund Total HAC - Arts Center Fund Arts Center Copy Machine RF - Refuse Fund Refuse Truck (RAP -R) (2) Telephone System Backhoe Loader Public Works Copy Machine Telephone System HAC - Arts Center Fund Total RF - Refuse Fund Total WF - Water Fund Total GRAND TOTAL SF - Sanitary Sewer Fund WF - Water Fund 01 -ERP -1100 n/a 370,140 448,800 475,700 923,800 837,700 3,056,140 12,100 12,100 01 -ERP -900 n/a 176,700 176,700 01 -ERP -557 n/a 01 -ERP -502 n/a 01 -ERP -506 n/a 01 -ERP -507 n/a 176,700 176,700 12,200 6,800 SF - Sanitary Sewer Fund Total 6,800 6,800 12,100 12,100 6,800 6,800 134,800 134,800 12,200 6,800 12,200 6,800 134,800 153,800 370,140 637,700 501,400 923,800 972,500 3,405,540 Friday, August 08, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -001 Project Name City Hall Main Copy Machine - Oce' Copier Description 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 Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. Prior 89,400 Total Prior 89,400 Total Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other Total 2009 thru 2013 Total Project Cost $165,000 2009 2010 2011 2012 2013 Total Future 2,400 2,400 14,000 18,800 Total 2,400 2,400 14,000 18,800 Total 2009 2010 2011 2012 2013 Total Future 2,400 2,400 14,000 18,800 { 56,800, 2,400 2,400 14,000 18,800 Total 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- Contact City Clerk Department Community Services Type Equipment Useful Life 5 years Category Equipment Priority n/a 56,8001 Thursday, July 2-/, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -002 Project Vann City Hall Small Copy Machine Description 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 Prior 43,200 I Total Prior 43,200 I Total Expenditures Equipment Funding Sources Operational Impact/Other Equipment Replacement Fund Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $2,500 2009 thru 201 Contact City Clerk Department Community Services Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost S179,500 Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. 2009 2010 2011 2012 2013 Total Future 26,900 26,900 26,900 26,900 109,400 I Total 26,900 26,900 Total 2009 2010 2011 2012 2013 Total Future 109,400 I Total 26,900 26,900 Total Thursday, July 2-1, 2008 • EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -003 Project Name Network Server Description The network server is the hub of the network. New computers are faster and more reliable. Justification Networking allows user to share information that is stored in a single location, the network server. This is more efficient because the information does not have to be stored on many different computers. It also makes for better accuracy because as the information changes or is updated, every user is working with the same data. Prior 49,000, Total Prior 49,000 I Total Expenditures Equipment Operational Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ -0- 2009 thru 2013 Contact Finance Director /IT Department City Hall Administration Type Equipment Useful Life 1 year Category Equipment Priority n/a Total Project Cost $209,000 2009 2010 2011 2012 2013 Total Future 8,000 8,000 8,000 8,000 8,000 40,000 120,0001 Total 8,000 8,000 8,000 8,000 8,000 40,000 Tota I Funding Sources 2009 2010 2011 2012 2013 Total Future Equipment Replacement Fund 8,000 8,000 8,000 8,000 8,000 40,000 r 120,000 1 Total 8,000 8,000 8,000 8,000 8,000 40,000 Total Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -004 Project Name Telephone System Description Justification Prior 60,000 Total Prior 60,000 Total Expenditures Equipment Funding Sources Operational Impact/Other 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. Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Equipment Replacement Fund Variance from 20 year plan - None. Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Finance Director /IT Department City Hall Administration Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost $288,000 2009 2010 2011 2012 2013 Total Future 76,000 76,000 Total 76,000 76,000 Total 2009 2010 2011 2012 2013 Total Future 76,000 76,000 152,000 152,000 I Total 76,000 76,000 'Tota Thursday. July 2-1. 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -006 Project Name Computers Description Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Justification Prior 240,000 I Total Prior 240,000 I Total Expenditures Equipment Funding Sources Operational Impact/Other 2009 thru 2013 Tools enabling staff to perform job responsibilities efficiently and effectively. Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ -0- Contact Finance Director /IT Department City Hall Administration Type Equipment Useful Life 3 -5 years Category Equipment Priority n/a Total Project Cost $840,000 2009 2010 2011 2012 2013 Total Future 30,000 30,000 30,000 30,000 30,000 150,000 Equipment Replacement Fund 30,000 30,000 30,000 30,000 30,000 150,000 30,000 30,000 30,000 30,000 30,000 450,0001 Total 30,000 30,000 30,000 30,000 30,000 150,000 Total 2009 2010 2011 2012 2013 Total Future 450,000 150,000 Tota l Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -007 Project Name Engineering Printer /Scanner Description Printer /scanner - large format copier use in Engineering to copy blueprints, plans and large documents. Equipment is leased. Justification Large document copier /scanner for use in Engineering. Also scans documents for permanent storage. Prior 25,920 Total Prior 25,920 I Total Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other 2009 8,640 Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $ -0- 2010 10,000 2009 thru 2013 2011 10,000 2012 Total Project Cost 5278,560 10,000 Contact City Clerk Department Community Services Type Equipment Useful Life 5 years Category Equipment Priority n/a 2013 10,000 Total Future 48,640 204,000 I Total 8,640 10,000 10,000 10,000 10,000 48,640 "1ote I 2009 2010 2011 2012 2013 Total Future 8,640 10,000 10,000 10,000 10,000 48,640 204,0001 Total 8,640 10,000 10,000 10,000 10,000 48,640 1 o t a I Thursday, July 2-/, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -008 Project Name Document Management Scanner (2) Description Large document (11"x17") scanner for document management and retention as well as general administrative use. Two scanners each replaced every three years. One replaced in 2009, 2012 One replaced in 2010, 2013..... Justification 2007 - Replaces the second scanner that only scans documents to 8 1/2 "x14" that was purchased in 2004. Prior 13,000 Total Prior 13,000 Total Expenditures Equipment Funding Sources Total Equipment Replacement Fund Total 6,500 6,500 Operational Impact/Other Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $500- $1,000 2009 thru 2013 Contact City Clerk Department Community Services Type Equipment Useful Life 3 years Category Equipment Priority n/a Total Project Cost $104,000 2009 2010 2011 2012 2013 Total Future 6,500 6,500 6,500 6,500 26,000 65,000 1 6,500 6,500 26,000 'Total 2009 2010 2011 2012 2013 Total Futurc 6,500 6,500 6,500 6,500 26,000 65,0001 6,500 6,500 6,500 6,500 26,000 Fotal Thursday, July 24. 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -010 Project Vance Election Booths Description Election booths Justification In 2008 the City replaced approximately 1/2 of the voting booths in use now. The booths we have now are over 25 years old - many of them no longer have functioning lights. Every year we have to stop using some because they have broken parts and can no longer be used. Expenditures Equipment Funding Sources Equipment Replacement Fund 6,500 Operational Impact/Other 2009 6,500 2010 2009 thru 2013 2011 2012 Contact City Clerk Department Community Services Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost $29,800 2013 Total Future 6,500 6,500 23,300 j Total 6,500 6,500 Total 2009 2010 2011 2012 2013 Total Future C 23,3001 Total 6,500 6,500 Tota l Variance from 20 year plan - new item - cost in 2008 - $6,400 for 1/2 of the booths. Cost in 2009 - $6,500 for 1/2 of the booths. Estimate salvage /resale value on replaced item: $ -0- Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -031 Project Nance Refrigerator/Freezer Description Commerical, stainless steel refrigerator and freezer. Justification Cooling /freezing needed for programs or by use of the participants and their activities. Present unit was here when activity center opened in 1980. This unit was part of the old South Jr. High cafeteria kitchen. The unit continues to have problems due to the age of the unit. Prior 10,500 Total Prior 10,500 Total Expenditures Equipment Funding Sources Operational Impact/Other Total Equipment Replacement Fund Total 2009 thru 2013 Variance from 20 year plan - New dollar amount applied for replacement. Estimate salvage /resale value on replaced item: $ -0- Contact Facilities Director Department Activity Center Type Equipment Useful Life 30 years, Category Equipment Priority n/a Total Project Cost $24,500 2009 2010 2011 2012 2013 Total 14,000 14,000 14,000 14,000 2009 2010 2011 2012 2013 Total 14,000 14,000 14,000 14,000 Thursday, July 2-4, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -103 Project lame Duty Chief Vehicle Description A marked passenger vehicle for use by the Duty Chief in transporting required equipment, reference materials and personnel for emergency response, and routine Fire Department business. Justification Prior 28,100 1 Total Prior 28,100 I Total Expenditures Vehicles Funding Sources Used by the Fire Chief when responding to fires and other emergencies. Used for official business in and out of the city and for fire fighter travel on official Fire Department business. Going to 3 year rotation will replace current used squad car that ends up costing us more money in repairs. Each car will be cycled down and older squad will be replaced. Equipment Replacement Fund 2009 thru 2013 Contact Fire Chief Department Fire Type Equipment Useful Life 5 years Category Vehicles Priority n/a Total Project Cost $212,300 2009 2010 2011 2012 2013 Total Future Total 36,400 36,400 36,400 2009 2010 2011 2012 2013 Total Future 36,400 36,400 Total 36,400 36,400 Total Operational Impact/Other 1 Variance from 20 year plan - Change from 7 year life to 3 years. Add vehicle rotation in 2009. Estimate salvage /resale value on replaced item: $4,000 147,800 36,400 "rota 147,800 Thursday, July 2,1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 4 01 -ERP -109 Project Name Extrication Tool (2) Description Hydraulic rescue and extrication tool with spreader, cutters and hydraulic ram. Note: purchased 1995 & 2005 Justification 2009 thru 2013 Contact Fire Chief Department Fire Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost $146,200 All vehicle and industrial rescue situations which will require paitient disentanglement or entrapment. Prior 20,300 Total Prior 20,300 I Total Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other 1 Total 2009 2010 2011 2012 2013 Total Future 26,500 26,500 99,4001 Total 26,500 26,500 Total 2009 2010 2011 2012 2013 Total Future 26,500 26,500 26,500 26,500 'Total 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 99,400 Thursday, July 2-1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -110 Project vane Copy Machine Description Fire Station copy machine. Justification Prior 7,400 Total Prior 7,400 Total Expenditures Equipment Operational Impact/Other Copying business papers, training records, etc. Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $500 2009 thru 2013 Contact Fire Chief Department Fire Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost S47,400 2009 2010 2011 2012 2013 Total Fntttre Total 10,300 10,300 10,300 [ 29,700 1 10,300 Total Funding Sources 2009 2010 2011 2012 2013 Total Future Equipment Replacement Fund 10,300 10,300 r 29,700 l Total 10,300 10,300 I otal Thursday, July 2-1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -112 Project Name Thermal Imaging Camera (2) Description Used by our fire companies to locate victims trapped in a smoke filled building. It helps us determine where fire and heat may be hidden allowing for faster extinguishment. Note: purchased 1997 & 2003 Justification Current camera is ten years old and has been through many hot fires and needs to be replaced. Current camera was purchased with donation money. Prior 15,000' Total Prior 15,000 Total Expenditures Equipment Funding Sources Total Equipment Replacement Fund Operational Impact/Other Total 2009 thru 2013 Contact Fire Chief Department Fire Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost $104,600 2009 2010 2011 2012 2013 Total Future 18,000 18,000 18,000 71,600 I 18,000 Total 2009 2010 2011 2012 2013 Total Future 18,000 18,000 71,600 1 18,000 18,000 Total Variance from 20 year plan - department owns 2 cameras. Previously one one was included in the replacement plan. This will add to the replacement schedule the camera purchased from the Fire Dept budget in 2003. Estimate salvage /resale value on repalced item: $ -0- Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -116 Project Name Workout Equipment - Eliptical Description 2009 - replace eliptical 2012 - replace eliptical Justification This equipment is available to all City employees for health and wellness. Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other 2009 thru 2013 Variance from 20 year plan - remove $5,000 in 2009 and use for dumb bells. Estimate salvage /resale value on replaced item: $ Contact Fire Chief Department Fire Type Equipment Useful Life 6 years Category Equipment Priority n/a 537,800 Total Project Cost Workout equipment used in Fire Department workout room. Two eliptical machines replaced on a 6 year cycle, one every 3 years. 2009 2010 2011 2012 2013 Total Future 5,000 5,000 Total 5,000 5,000 "Total 2009 2010 2011 2012 2013 Total Future 5,000 5,000 32,8001 1 32,800 Total 5,000 5,000 'Total Thursday, July 24. 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Description Workout equipment used in Fire Department workout room. One stairmaster replaced on a 5 year cycle. Justification Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other Total 2009 thru 2013 Project # 01 -ERP -117 Project Name Workout Equipment - Stairmaster This equipment is available to all City employees for health and wellness. Variance from 20 year plan new item - Originally purchased with grant funds. Estimate salvage /resale value on replaced item: $ Contact Fire Chief Department Fire Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost 525,300 2009 2010 2011 2012 2013 Total Future 5,000 5,000 20,300 I Total 5,000 5,000 Total 2009 2010 2011 2012 2013 Total Future 5,000 5,000 ( 20,300 5,000 5,000 Tot s ;I Thursday, July 2-1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project i! 01 -ERN -118 Project Name Workout Equipment - Treadmill Description Workout equipment used in the Fire Department workout room. One treadmill replaced on a 5 year cycle. Justification This equipment is available to all City employees for health and wellness. Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other Total Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ 2009 thru 2013 2009 2010 2011 2012 2013 Total Future 5,000 5,000 5,000 Contact Fire Chief Department Fire Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $25,300 5,000 5,000 1 20,300 1 5,000 Total 2009 2010 2011 2012 2013 Total Future 20,3001 5,000 5,000 'Iota! Thursday. July ?-!, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -119 Project Name Workout Equipment - Weight Lifting Description Smith machine - weight lifting machine. Justification Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other Total Total 2009 thru 2013 Contact Fire Chief Department Fire Type Equipment Useful Life 5 years Category Equipment Priority n/a $25,300 Total Project Cost 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. 2009 2010 2011 2012 2013 Total Future 5,000 5,000 5,000 5,000 Tote i 2009 2010 2011 2012 2013 Total Future 5,000 5,000 5,000 5,000 Total Variance from 20 year plan - new item. Not previously included in ERP. Originally purchased with grant funds. Estimate salvage /resale value on replaced items: $ 20,300 1 20,3001 Thursday, July 2.1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Description Justification Expenditures Funding Sources Operational Impact/Other 2009 thru 2013 Project # 01 -ERP -120 Project lame Automated External Defibrillator (2) Defibrillator is used to help get someones heart restarted during a cardiac arrest. Own 2 - both are replaced at one time due to changing technology. Contact Fire Chief Department Fire Type Equipment Useful Life 3 years Category Equipment Priority n/a Total Project Cost S60,200 The current AED are not in the ERP. With changes in technology, they should be replaced every three years. Cost - $3,000 per unit 2009 2010 2011 2012 2013 Total Future Equipment 6,000 7,200 13,200 1 47,0001 Total 6,000 7,200 13,200 Tota l 2009 2010 2011 2012 2013 Total Future Equipment Replacement Fund 6,000 7,200 13,200 47,000 I Total 6,000 7,200 13,200 Total 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: $ Thursday, July 4, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -122 Project Name Workout Equipment - Dumb Bells Description Workout equipment used in Fire Department workout room. Justification Instead of replacing eliptical machine in 2009 - would replace dumb bell. They are used by all City employees and are 15 years old. They are also covered with lead paint that could be harmful. Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other Total 5,000 Total 5,000 Variance from 20 year plan - new item. Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Fire Chief Department Fire Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost $11,700 2009 2010 2011 2012 2013 Total Future 5,000 5,000 2009 2010 2011 2012 2013 Total Future 5,000 5,000 6,700 1 5,000 Tota 1 6,7001 5,000 Toth 1 Thursday, July 2-1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # O1 -ERP -121 Project Vane Quick Attack Pumper/Rescue Description Quick attack pumper /rescue. Justification Would replace Rescue 8 (lite rescue) and use as a utility vehicle. This truck could be used for daytime and nighttime medicals and small fires. This will reduce having all personnel respond to small fires. It will also let us drop one engine in 2022 but still keep ISO rating. Expenditures Vehicles Funding Sources Equipment Replacement Fund Operational Impact/Other Variance from 20 year plan - new item. Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Fire Chief Department Fire Type Equipment Useful Life 25 years Category Vehicles Priority n/a Total Project Cost $234,000 2009 2010 2011 2012 2013 Total 234,000 234,000 Total 234,000 234,000 2009 2010 2011 2012 2013 Total 234,000 234,000 Total 234,000 234,000 Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -200 Project Name Marked Patrol Vehicles (6) Description Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. Justification Set up and marking of police vehicles must conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Prior 473,7001 Total Prior 473,700 Total Expenditures Vehicles Funding Sources Equipment Replacement Fund 31,600 97,800 67,200 34,600 106,800 338,000 Operational Impact/Other Total Total 2009 thru 2013 Contact Police Chief Department Police Type Equipment Useful Life 3 years Category Vehicles Priority n/a Total Project Cost $2,183,100 2009 2010 2011 2012 2013 Total Future 31,600 97,800 67,200 34,600 106,800 338,000 31,600 97,800 67,200 34,600 106,800 1,371,400 338,000 Tota 2009 2010 2011 2012 2013 Total Future 31,600 97,800 67,200 34,600 106,800 338,000 Total Variance from 20 year plan - move sergeant's vehicle to separate project number. Estimate salvage /resale value on replaced item: $4,000 each 1,371,400 Thursday. July 4, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Description Justification Expenditures Vehicles Funding Sources Equipment Replacement Fund Operational Impact/Other Total Total 2009 thru 2013 Project a 01 -ERP -201 Project Name Sergeant's Vehicle Contact Police Chief Department Police Type Equipment Useful Life 4 years Category Vehicles Priority n/a Total Project Cost S215,700 Marked patrol vehicle used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. 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. 2009 2010 2011 2012 2013 Total Future 33,600 33,600 r 182,100 I 33,600 33,600 Tota I 2009 2010 2011 2012 2013 Total Future 33,600 33,600 33,600 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 182,100 I 33,600 Total Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -204 Project Name Police Administrative Vehicles (2) Description Police administrative and detective vehicles. Replace Chiefs vehicle - even numbered years Replace Captain's vehicle - odd numbered years Justification Unmarked vehicles, equipped with radios, siren and red grille lites used by chief and captain. Staff use is for two years. Vehicles are then rotated down to detectives and are kept for an additional 3 -4 years. Vehicles are also used for surveillance by uniform and plain clothes officers. Prior 159,000 Total Prior 159,000 Total Expenditures Vehicles Funding Sources Operational Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $4,000 each 2009 thru 2013 Contact Police Chief Department Police Type Equipment Useful Life 2 years Category Vehicles Priority n/a Total Project Cost $866,400 2009 2010 2011 2012 2013 Total Future 26,300 27,100 27,900 28,800 29,600 139,700 Total 26,300 27,100 27,900 28,800 29,600 Equipment Replacement Fund 26,300 27,100 27,900 28,800 29,600 139,700 567,700 1 139,700 Total 2009 2010 2011 2012 2013 Total Future 567,700 1 Total 26,300 27,100 27,900 28,800 29,600 139,700 Totat Thursday, July 2-/, 2008 EQUIPMENT IMPROVEMENT PLAN City of Hopkins, MN 2009 thru 2013 Project # 01 -ERP -208 Project Name Computer System Description Computer system for records management and retention of Police Department. Contact Police Chief Department Police Type Equipment Useful Life 20 years Category Equipment Priority n/a $400,000 Total Project Cost Justification 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 Funding Sources Equipment Replacement Fund Operational Impact/Other Total Total 2009 2010 2011 2012 2013 Total Future 200,000 200,000201,000 1 200,000 200,000 Total 2009 2010 2011 2012 2013 Total Future 200,000 200,000201,000 l 200,000 200,000 Total Variance from 20 year plan - Cost to replace needs to be increased from $500,000 to $700,000. Move back from 2010 to 2013. Change from 10 to 20 year life.. Estimate salvage /resale value on replaced item: $ -0- Friday, August 08, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -209 Project Name Copy Machine Description Police Department copy machine capable of producing double side copies and collating pages. Justification Used to make duplicate copies of reports, letters, memos, etc., generated by police personnel. Prior 30,700 Total Prior 30,700 Total Expenditures Equipment Funding Sources Operational Impact/Other Total Equipment Replacement Fund Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $1,000 2009 thru 2013 19,100 Contact Police Chief Department Police Type Equipment Useful Life 5 years Category Equipment Priority n/a $127,200 Total Project Cost 2009 2010 2011 2012 2013 Total Future 19,100 19,100 19,100 19,100 77,400 19,100 19,100 'fota i 2009 2010 2011 2012 2013 Total Future 1 77,400 1 19,100 Total Thursday, July 2-1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -211 Project Name Network Server (3) Description Computer servers store information and system programs. One server @ $15,000 (to be purchased for digital squad car cameras storage and retrieval - see 01 -ERP -213) Justification Annual replacement cycle allows development of system storage program. Use of newer servers for heavy use programs while older servers used for data storage. Prior 51,200 Total Prior 51,2001 Total Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item - $ 2009 thru 2013 Contact Police Chief/IT Department Police Type Equipment Useful Life 3 years Category Equipment Priority n/a Total Project Cost $235,400 2009 2010 2011 2012 2013 Total l'tlturc 8,700 8,700 8,700 8,700 9,000 43,800 8,700 8,700 8,700 8,700 9,000 43,800 Total 8,700 8,700 8,700 8,700 9,000 140,400 I Total 8,700 8,700 8,700 8,700 9,000 43,800 Total 2009 2010 2011 2012 2013 Total Future 1 140,4001 43,800 Total Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -212 Project Name Mobile Data Computers Description Mobile data computers installed in squad cars used to receive calls from dispatch, query information from various databases, communicate car to car. Justification Limited life of 5 years - replacement necessary. Prior 47,000 1 Total Prior 47,000 Total Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other 2009 thru 2013 2009 2010 2011 2012 2013 Total Futu Total 62,700 Total 62,700 Contact Police Chief Department Police Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $364,400 62,700 62,700 62,700 62,700 62,700 Tota 2009 2010 2011 2012 2013 Total Future 62,700 'Tota Variance from 20 year plan - Increase cost from $54,500 to $62,700 ($5,700 x 11) to better reflect actual cost of MDC /docking station. Estimate salvage /resale value on replaced item: $ -0- 254,700 1 254,700 I Thursday, July 2-1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -213 Project Name Digital Squad Car Cameras Description Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other 2009 thru 2013 Contact Police Chief Department Police Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $215,700 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 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 (01- ERP -21 1) annual allocation that carries forward. Estimated cost $57,600. Cost could be lower if, at the time of replacement, a suitable product is available through a State or County equipment bid. 2009 2010 2011 2012 2013 Total Future 42,600 42,600 [ 173,100 Total 42,600 42,600 'T otaI 2009 2010 2011 2012 2013 Total Future 42,600 42,600 173,100 I Total 42,600 42,600 Total Variance from 20 year plan - cost needs to be increased from $42,600 to $57,600 to reflect more accurate estimate o replacement. Estimate salvage /resale value on replaced item: $ Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -214 Project Name Tactical Ballistic Vests Description Tactical ballistic vests worn by members of the Hopkins Police Department High -risk Entry and Assault Team (HEAT). These vests offer a higher level of protection against weapon assault than the regular duty ballistic vest. 1 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. Justification Prior 20,000 Total Prior 20,000 Total Expenditures Equipment Funding Sources Operational Impact/Other Equipment Replacement Fund Total 2009 thru 2013 Contact Police Chief Department Police Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $137,500 2009 2010 2011 2012 2013 Total Future 23,200 23,200 1 94,3001 Total 23,200 23,200 Total 2009 2010 2011 2012 2013 Total Future 23,200 23,200 23,200 Variance from 20 year plan - new item. Note: regular bullet proof vests funded by federal /state grants Estimate salvage /resale value on replaced item: $ 94,3001 23,200 Total Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 4 01 -ERP -700 Project Name Engineering Van Description Van used by Engineering Department for survey equipment and on job site work. Justification Transportation to and from job site, hauling of surveying and traffic counting equipment. Prior 16,000 1 Total Prior 16,000 Total Expenditures Vehicles Funding Sources Equipment Replacement Fund Operational Impact/Other 2009 thr•u 2013 Contact Public Works Director Department Public Works: Engineering Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost $66,400 2009 2010 2011 2012 2013 Total Future 21,500 21,500 1 28,900 Total 21,500 21,500 Total 2009 2010 2011 2012 2013 Total Future 21,500 21,500 Total 21,500 21,500 *I'otatl Variance from 20 year plan - increase amount from 14,300 to 16,000 to reflect actual cost. Purchase used Suburban from Hennepin Co. 2002 auction -price is $13,000 to $14,000 + $2,000 for equipment. Estimate salvage /resale value on replaced item: $2,500 1 28,9001 Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Description Pickup used by Park Division of Public Works. Justification Expenditures 2009 Vehicles Funding Sources Equipment Replacement Fund Operational Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Project # 01 -ERP -800 Project Vane 1/2 Ton Pickup Truck Contact Public Works Director Department Public Works: Parks /Forestry Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost S61,800 2010 2011 2012 2013 Total Future 26,400 26,400 r 35,400 Total 26,400 26,400 'iota! 2009 2010 2011 2012 2013 Total Future 26,400 26,400 1 35,400 Total 26,400 26,400 Tot Thursday, July 2-/, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -801 Project Name 4x4 3 /4Ton Trucks (2) Description Trucks used by Parks Division of Public Works. Justification Snow plowing, hauling, transportation. Units are heavily used. Prior 53,200 I Total Prior 53,200 I Total Expenditures Vehicles Funding Sources Equipment Replacement Fund Operational Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Public Works Director Department Public Works: Parks /Forestr■ Type Equipment Useful Life 8 years Category Vehicles Priority n/a Total Project Cost $313,800 2009 2010 2011 2012 2013 Total Future 67,400 67,400 1 193,200 Total 67,400 67,400 T(►ttd 2009 2010 2011 2012 2013 Total Future 67,400 67,400 193,200) Total 67,400 67,400 T otal Thursday, July 2-1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -802 Project Vance 3/4 Ton Utility Truck Description 3/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city. Justification Expenditures Vehicles Funding Sources Equipment Replacement Fund Operational Impact/Other 2009 thru 2013 Contact Public Works Director Department Public Works: Parks /Forestry Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost $75,600 2009 2010 2011 2012 2013 Total Future 32,200 32,200 43,400 I Total 32,200 32,200 Tota 2009 2010 2011 2012 2013 Total Future 32,200 32,200 L 43,400, Total 32,200 32,200 Total 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, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Description Justification Expenditures Equipment Funding Sources Operational Impact/Other 2009 thru 2013 Project # 01 -ERP -805 Project Name Aerial Lift Contact Public Works Director Department Public Works: Parks /Forestry Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost $130,000 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. 2009 2010 2011 2012 2013 Total 130,000 130,000 Total 130,000 130,000 2009 2010 2011 2012 2013 Total Equipment Replacement Fund 130,000 130,000 Total 130,000 130,000 Variance from 20 year plan - Increase amount from $110,000 to $130,000 to reflect actual cost. Estimate salvage /resale value on replaced item: $ 15,000 Thursday, July 2.1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -806 Project Vane Tractors (2) Description Farm type tractors with cab used with various attachments. Ice rink sweeping, flail mower, fertilizing, aeration, plowing and grass seeding. Justification Expenditures Equipment 41,400 43,900 85,300 Funding Sources Total 41,400 2009 thru 2013 Contact Public Works Director Department Public Works: Parks /Forestry' Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost $85,300 2009 2010 2011 2012 2013 Total 43,900 85,300 2009 2010 2011 2012 2013 Total Equipment Replacement Fund 41,400 43,900 85,300 Operational Impact/Other Total 41,400 Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $3,500 43,900 85,300 Thursday, July 2-1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -807 Project Name Trucksters (3) Description Justification Prior 29,900 Total Prior 29,900 1 Total Expenditures Equipment Funding Sources Operational Impact/Other Truckster used by Parks Division of Public Works for ballfield and parks maintenance. Park maintenance, ballfield grooming and weed spraying. Equipment Replacement Fund Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $1,400 each 2009 thru 2013 Contact Public Works Director Department Public Works: Parks /Forestry Type Equipment Useful Life 15 years Category Equipment Priority n/a Total Project Cost $114,700 2009 2010 2011 2012 2013 Total Future 19,800 19,800 Total 19,800 19,800 I utal 2009 2010 2011 2012 2013 Total Future 19,800 19,800 65,0001 65,0001 Total 19,800 19,800 Total Thursday, July 4, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -808 Project Name Riding Mowers (3) Description Riding mowers used by Parks Divison of Public Works. One mower also used for sidewalk snow removal during winter months. Justification Prior 49,000 Total Prior 49,000 Total Expenditures Funding Sources Operational Impact/Other Mowing city parks and right of ways and sidewalk snow removal. Equipment 22,800 10,300 33,100 Total Total 2009 2010 2011 2012 2013 Total Future 22,800 Variance from 20 year plan - none. Estimate salvage /resale value on replaced item: $600 each 2009 thru 2013 Total Project Cost $223,100 10,300 Contact Public Works Director Department Public Works: Parks /Forestry Type Equipment Useful Life 8 years Category Equipment Priority n/a Equipment Replacement Fund 22,800 10,300 33,100 141,000 33,100 Total 2009 2010 2011 2012 2013 Total Future 1 141,000, 22,800 10,300 33,100 'Total Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -810 Project Vane Large Turf Mower Description Large turf mower (11' cutting width) used by Parks Division of Public Works. Justification Required to efficiently mow large parks. Prior 50,000 I Total Prior 50,000 I Total Expenditures Equipment Funding Sources Operational Impact/Other Total Equipment Replacement Fund Total 2009 thru 2013 Contact Public Works Director Department Public Works: Parks /Forestry Type Equipment Useful Life 10 years Category Equipment Priority n/a Total Project Cost $207,700 2009 2010 2011 2012 2013 Total Future 65,000 65,000 65,000 92,700 1 65,000 Total 2009 2010 2011 2012 2013 Total Future 65,000 65,000 927700 65,000 65,000 Total Variance from 20 year plan - change useful life from 12 to 10 years - move replacement year from 2013 to 201 1 based on maintenance experience and lowest overall cost. Estimate salvage /resale value on replaced item: $3,500 Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -813 Project Name Brush Chipper Description Brush chipper used for Forestry and brush pick up operations of Public Works. Justification Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other Total 2009 thru 2013 Contact Public Works Director Department Public Works: Parks /Forestry Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost $25,700 2009 2010 2011 2012 2013 Total 2009 2010 2011 2012 2013 Total Total 25,700 25,700 Variance from 20 year plan - change to usable life to 20 years - move back from 2009 to 2013. Estimate salvage /resale value on replaced item: $ 25,700 25,700 25,700 25,700 25,700 25,700 Thursday. July 2-1. 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -301 Project Name 4X4 3/4 Ton Truck with Plow Description 3/4 ton pickup used by Street Divison of Public Works for heavy loads and pulling trailers. Justification Light hauling, pulling trailers, transportation to and from job sites. Prior 24,000 Total Prior 24,000 J Total Expenditures Vehicles Funding Sources Total Equipment Replacement Fund 2009 thru 2013 Contact Public Works Director Department Public Works: Streets/Trafiic Type Equipment Useful Life 8 years Category Vehicles Priority n/a Total Project Cost $92,900 2009 2010 2011 2012 2013 Total Future 30,400 30,400 30,400 2009 2010 2011 2012 2013 Total Future 30,400 30,400 1 38,500 30,400 Total 38,500 l Total 30,400 30,400 E ut a Operational Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $1,500 Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -303 Project vane 1 Ton Dump Truck (2) Description Truck is used in the Street Division of Public Works. Justification Vehicle used by various departments for street and park maintenance and light hauling. Prior 30,5001 Total Prior 30,500 Total Expenditures Vehicles 37,400 34,700 72,100 Funding Sources Operational Impact/Other Total Variance from 20 year plan - Estimate salvage /resale value on replaced item: $3,500 2009 thru 2013 Contact Public Works Director Department Public Works: Streets/Traffic Type Equipment Useful Life 12 years Category Vehicles Priority n/a Total Project Cost $205,500 2009 2010 2011 2012 2013 Total Future 1 102,9001 Total 37,400 34,700 72,100 Total 2009 2010 2011 2012 2013 Total Future Equipment Replacement Fund' 37,400 34,700 72,100 102,9001 37,400 34,700 72,100 Total Thursday, July /. 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 4 01 -ERP -304 Project Name 1 Ton Traffic Boom Truck Description Boom truck used in Street and Traffic Divisions of Public Works. Justification Vehicle used by Traffic Department for signal and Tight pole maintenance. Expenditures Vehicles Funding Sources Equipment Replacement Fund Operational Impact/Other Total Total Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $8,000 2009 thru 2013 Contact Public Works Director Department Public Works: Streets /Traffic Type Equipment Useful Life 17 years Category Vehicles Priority n/a Total Project Cost 575,000 2009 2010 2011 2012 2013 Total 75,000 75,000 75,000 75,000 2009 2010 2011 2012 2013 Total 75,000 75,000 75,000 75,000 Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -306 Project Name Tandem Dump Trucks (2) Description Dump trucks used in Streets Division of Public Works. Justification Trucks used for heavy hauling, snow plowing and sanding. Expenditures Vehicles Funding Sources Total Equipment Replacement Fund Operational Impact/Other Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ -0- 2009 thru 2013 Contact Public Works Director Department Public Works: Streets/Traffic Type Equipment Useful Life 17 years Category Vehicles Priority n/a Total Project Cost 5274,700 2009 2010 2011 2012 2013 Total Future 132,300 132,30014,400 I 132,300 132,300 Total 2009 2010 2011 . 2012 2013 Total Future 132,300 132, 30014,400 1 132,300 132,300 ,.1., o t a 1 Thursday, Duty 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -307 Project Name Water Truck Description Water truck used in Streets and Parks Division of Public Works. Justification Used for street flushing, watering trees and plants, rink flooding and standby fire protection. Expenditures Vehicles Operational Impact/Other Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $8,500 2009 thru 2013 Contact Public Works Director Department Public Works: Streets /Traffic Type Equipment Useful Life 15 years Category Vehicles Priority n/a Total Project Cost $342,000 2009 2010 2011 2012 2013 Total Future 133,700 133,70020,300 I 133,700 133,700 7 ota l Funding Sources 2009 2010 2011 2012 2013 Total Future Equipment Replacement Fund 133,700 133,70020,300 1 Total 133,700 133,700 'Total Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project ti 01 -ERP -308 Project Name Front End Loaders (2) Description Justification Prior 140,000 Total Prior 140,000 I Total Expenditures Equipment Funding Sources Equipment Replacement Fund Operational Impact/Other Total Total Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Public Works Director Department Public Works: Streets/Traftic Type Equipment Useful Life 15 -18 years Category Equipment Priority n/a Total Project Cost $530,100 2009 2010 2011 2012 2013 Total Future 172,000 172,000 [ 218,100 172,000 172,000 Total 2009 2010 2011 2012 2013 Total Future 172,000 172,000 172,000 1 218,1001 172,000 Tota I Thursday .% July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01- ERN -309 Project NNW Skid Loader (2) Description Loading trucks, landscape work, snow removal, material handling. Justification Expenditures Equipment Funding Sources Total Equipment Replacement Fund 31,000 Operational Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Public Works Director Department Public Works: Streets /Traffic Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost $176,800 2009 2010 2011 2012 2013 Total Future 31,000 31,000 145,8001 31,000 31,000 Total 2009 2010 2011 2012 2013 Total Future 31,000 r 145,800 I Total 31,000 31,000 Tota I Thursday, July 2-!, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # O1 -ERP -311 Project Name Sweeper Description Street sweeper used by Streets Division for sweeping streets and parking lots. Justification Prior 115,300 Total Prior 115,300 I Total Expenditures Equipment Funding Sources Operational Impact/Other Street sweeping, event clean - up, spring sand removal. Total Equipment Replacement Fund Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $12,000 2009 thru 2013 Contact Public Works Director Department Public Works: Streets/Traftic Type Equipment Useful Life 12 years Category Equipment Priority n/a Total Project Cost $514,400 2009 2010 2011 2012 2013 Total Future 164,500 164,500 • 234,600 1 164,500 164,500 •rota I 2009 2010 2011 2012 2013 Total Future 164,500 164,500 164,500 [ 234,6001 164,500 Total Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project a 01 -ERP -312 Project Name Roller Description Used by Street Department for asphalt repair and resurfacing. Justification Expenditures Equipment Funding Sources Total Equipment Replacement Fund Operational Impact/Other Total Variance from 20 year plan - None Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Public Works Director Department Public Works: Streets/Traffic Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost $45,900 2009 2010 2011 2012 2013 Total 45,900 45,900 45,900 45,900 2009 2010 2011 2012 2013 Total 45,900 45,900 45,900 45,900 Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -316 Project Name Trailer Description Used for transporting and hauling equipment and supplies. Justification Expenditures Equipment 4,900 Funding Sources Equipment Replacement Fund Operational Impact/Other Total Total 4,900 Variance from 20 year plan - none Estiamte salvage /resale value on replaced item : $ 2009 thru 2013 Contact Public Works Director Department Public Works: Streets /Traffic Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost $4,900 2009 2010 2011 2012 2013 Total 4,900 4,900 2009 2010 2011 2012 2013 Total 4,900 4,900 4,900 4,900 Thursday, July 2-/, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # Project Name 01 -ERP -900 Refuse Truck (RAP -R) (2) Description Refuse truck used by Refuse Utility Division of Public Works. Justification Residential waste pick up. Prior 148,000 1 Total Prior 148,000 Total Expenditures Vehicles Funding Sources RF - Refuse Fund Operational Impact/Other 2009 2010 2011 2012 2013 Total Future Total 176,700 Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $18,000 2009 thru 2013 Contact Public Works Director Department Refuse Type Equipment Useful Life 10 years Category Vehicles Priority n/a Total Project Cost S1,042,100 176,700 176,700 176,700 176,700 717,400, 176,700 Total 2009 2010 2011 2012 2013 Total Future { 717,400 176,700 176,700 'Iota! Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -557 Project Name Telephone System Description Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Prior 4,700) Total Prior 4,700 1 Total Expenditures Equipment Funding Sources SF - Sanitary Sewer Fund Operational Impact/Other Total Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Finance Director/IT Department Sewer Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost $31,200 2009 2010 2011 2012 2013 Total Future 6,800 6,800 6,800 6,800 Total 2009 2010 2011 2012 2013 Total Future 6,800 6,800 6,800 19,7001 19,700 I 6,800 'Total Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project td 01 -ERP -502 Project Name Backhoe Loader Justification Expenditures Equipment Funding Sources WF - Water Fund Operational Impact/Other Total Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Public Works Director Department Water Type Equipment Useful Life 20 years Category Equipment Priority n/a Total Project Cost $134,800 Description Unit utilitzed by Water, Sewer and Street Divisions of Public Works for repair and installation of underground utilities. 2009 2010 2011 2012 2013 Total 134,800 134,800 134,800 134,800 2009 2010 2011 2012 2013 Total 134,800 134,800 Total 134,800 134,800 Thursday, July 24, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # 01 -ERP -506 Project Name Public Works Copy Machine Description Copy machine to service needs of all division of Public Works. Justification Making copies for various departments. Prior 10,600 I Total Prior 10,600 Total Expenditures Equipment Funding Sources Operational Impact/Other Total 2009 Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $800 2010 12,200 12,200 WF - Water Fund 12,200 Total 12,200 2009 thru 2013 2011 2012 Contact Public Works Director Department Water Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $72,600 2013 Total Future 12,200 49,800 1 12,200 T otal 2009 2010 2011 2012 2013 Total Future 12,200 1 49,800 } 12,200 Total Thursday, July 2.1, 2008 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project 4 01 -ERP -507 Project Name Telephone System Description Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Prior 4,7001 Total Prior 4,700 I Total Expenditures Equipment Funding Sources WF - Water Fund Operational Impact/Other Variance from 20 year plan - none Estimate salvage /resale value on replaced item: $ 2009 thru 2013 Contact Finance Director /1T Department Water Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost $31,200 2009 2010 2011 2012 2013 Total Future 6,800 6,800 1 19,700 Total 6,800 6,800 Total 2009 2010 2011 2012 2013 Total Future 6,800 6,800 19,700 Total 6,800 6,800 Total Thursday, July 2-1, "008