Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
1997-2001 ERP
City of Hopkins, Minnesota !!!!!..,.•_••... ..-„,-,'"...,-.. :',7,1 .........--z.:,....� 4 in.1'I 111 ,--17---..-.=;:77-'r —___.ilk t. '.r� +��QC - ,G Alt- Equipment r f Replacement I i 111111111111s Plan 3_,:,,.,.:-:.-0), 1997 IMI 2001 , ,r, ;$ ,.•;,..:i) w-,0; 44 �.. Z' • El• .. P = > p 11'y1. _-`.,a,r_'.11 II."' � `1� ,u__ Liu i 4,111144:::1: ill P4a L-, =1f,_ I Or ; X11 j. '..i 11 1• 410k..... ...________", A F, ., n n ., 01, r, .1, n 1"1 .., n n -, n n n City ofJ{opkins 1010 First Street South •9fopkins, ger 553 43-75 73 • phone: 612-935-8474 • Ta.Z 612-935-1834 DATE: October 1996 TO: Honorable Mayor and City Council FROM: Steven C. Mielke, City Manager SUBJECT: 1997 - 2001 Equipment Replacement Plan With this letter, I respectfully submit the 1997 - 2001 Equipment Replacement Plan. This five year planning document represents the combined efforts of City staff and the City Council. The Equipment Replacement Plan is a twenty year forecast of equipment needs in the City of Hopkins. It is intended to alert the Council and citizens to the major equipment needs on the horizon. The first year of the plan becomes an adopted equipment budget and relates almost completely to the operating budget which is approved on a yearly basis. The remaining nineteen years represent an estimate of equipment needs and funding capabilities of the City. Funding requirements vary drastically from year to year. In order to maintain a more even levy year by year, the twenty year schedule is projected with a 3% inflation factor and a yearly average dollar need is calculated (presently $518,100). The cash needs will experience a somewhat drastic roller coaster effect over the next 20 years given the present equipment needs and 3% inflation rate. Cash will increase through the year 2001 and then the next five years will deplete the cash balance. The last eight years of the schedule will smooth and will drop drastically the last two years so that by the end of 2016 cash will be reduced to $599,000. In order to accomplish this pattern, it will be necessary to increase the 1996 levy by $35,000 to the $485,000 level - the second levy increase in as many years since inception of the Equipment Replacement Plan. 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. The annual review assures that the plan is a continuing part of the budgetary process and that it will be consistent with changing demands as well as changing patterns in cost and financial resources. fin Equal Opportunity Employer J Highlights of changes from last year: L, Police: Squads (7) extended life from 2 to 3 years as 3 year warranty options are now purchased. New 800 MHZ radio system appears for the first time on the 5 year summary sheets. Public Works: Single axle dump scheduled for replacement in 1998 was deleted because the truck that is used with the chipper can handle needed capacity for this size vehicle. Litter Hog- seldom used will be sold and not replaced. Park Superintendent's 3/4 ton truck extended from 8 to 10 years and will L! be replaced with a 1/2 ton truck. The replacement life on two park tractors was extended from 15 to 20 Lr' years. I—. Current turf vac will not be replaced - deleted from schedule. Simple construction for which major parts will not wear out. The current Engineering van was acquired from the Fire Dept. in 1995. g g q This 1987 Ford van is in excellent condition and the scheduled replacement has been extended from 1999 to 2004. Building and Equipment Services will drop one 1/2 ton pickup from schedule. Shop will utilize surplus vehicle from other sources. Sewer/Water will drop one 1/2 ton pickup. Meter reading truck will be replaced with a different vehicle. The water meter computer has been dropped from the schedule. Future acquisition, if necessary, would be requested under the new equipment procedure with it first being requested in the annual budget. Finance: Experience of the 1995/1996 installation of the Finance computer system "' indicates the replacement projection can be extended from 6 years to 7 years. The replacement of the Novell network may be of even a greater frequency and the initial set up need not be repeated. The costs for both systems have been reduced by $34,000 for the 2003 scheduled f replacement. .J U HRA: The skid loader will not be replaced and is dropped from the schedule. The new 4x4 pickup will deal with snow removal. There were a few items for which the useful life was extended and/or minor cost adjustments made. This document was developed by the Finance Department with the assistance of all City ^ departments. I wish to thank all those involved in the development of the Equipment Replacement Plan, and especially to John Schedler, Finance Director, Steven Stadler, Public Works Director, and Deborah Dahlheimer, Senior Accounting Clerk, for their hard work and dedication. EQUIPMENT REPLACEMENT PLAN 1997- 2001 TABLE OF CONTENTS SECTION I Equipment Replacement Five Year Funding Summary A Funding Sources Codes A Five Year Expenditures Summary B Item Requests/Justification C-1 thru C-33 Twenty Year Equipment Replacement Schedu e D SECTION II Equipment and Building Inventory Vehicle/Equipment Inventory I - IV Building Inventory V -VII CAPITAL EQUIPMENT FIVE YEAR FUNDING SUMMARY EQUIPMENT REPLACEMENT FUND (000 omitted) 1997 1998 1999 2000 2001 Fund Balance Begin Year 590 1,006 1,020 1,316 1,553 Tax Levy 485 485 485 485 485 Other Income(Expenses) 33 33 33 33 33 Capital Purchases 102 504 222 281 597 Balance 12/31/2001 1,474 FUNDING SOURCES Current Revenues- General Fund C.R. Equipment Replacement Fund E.R. Water Fund W.F. Sewer Fund S.F. Refuse Fund R.F. Pavilion Fund P.A. Housing& Redevelopment Authority HRA A CAPITAL EQUIPMENT REPLACEMENT PLAN FIVE YEAR EXPENDITURE SUMMARY PROGRAM FUNDING CATEGORY PROJECT TITLE SOURCE 1997 1998 1999 2000 2001 C-1 Haz-Mat Van E.R. 37,900 C-2 Marked Patrol Vehicles(10) E.R. 27,100 56,400 58,800 91,200 62,800 •- C-3 Parking Enforcement Vehicle E.R. 14,000 C-4 Administration Vehicles(5) E.R. 17,500 18,000 18,600 19,100 19,700 C-5 Radio System E.R. 470,800 C-6 Body Armor E.R. 5,800 C-7 Police Computer E.R. 250,000 C-8 Police Copy Machine E.R. 14,200 C-9 Police Logging Recorder E.R. 20,000 C-10 3/4 Ton Pickup E.R. 21,500 C-11 4X4 One Ton Truck E.R. 22,000 C-12 One Ton Dump Truck(2) E.R. 25,500 30,500 C-13 Single Axle Dump E.R. 83,000 C-14 Skid Loader E.R. 32,500 C-15 Grader E.R. 80,000 C-16 Sweeper E.R. 115,300 C-17 1/2 Ton Pickup E.R. 15,900 C-18 3/4 Ton Utility Truck E.R. 21,000 C-19 Truckster(3) E.R. 12,700 C-20 Riding Mowers(2) E.R. 11,800 C-21 Gang Mower E.R. 42,300 C-22 Turf Sweeper E.R. 10,900 C-23 City Hall Main Copy Machine(2) E.R. 19,000 35,000 C-24 City Hall Micro Network Upgrade E.R. 10,000 10,000 10,000 C-25 Optical Scanner E.R. 6,000 C-26 Election Equipment E.R. 68,000 C-27 1/2 Ton Pickup W.F. 15,200 C-28 4X4 3/4 Ton Dump Truck W.F. 21,900 C-29 3/4 Ton Utility Truck S.F. 23,000 C-30 Public Works Copy Machine W.F. 9,100 C-31 Jet Vactor S.F. 100,000 C-32 Portable Generator S.F. 8,500 C-33 Refuse Truck R.F. 127,700 TOTAL CAPITAL EQUIPMENT REPLACEMENT PROGRAM 148,300 503,800 349,800 411,800 776,500 FUNDING: EQUIPMENT REPLACEMENT FUND(LEVY) 101,600 503,800 222,100 280,800 776,500 ENTERPRISE FUND 46,700 127,700 131,000 B Vehicle Command/Mitigation(101) C - 1 ............................................ ............................................ S HEDULED.PURCRASE::' AR:::::; $37,900 1997 1998 1999 2000 2001 ,'100.2— FUNDING>>» > ............................................ ............................................ ............................................ ............................................ ............................................ ER 37,900 / r DESCRIPTION: Marked hazardous materials reponse unit and mobile command vehicle. Carries personnel and equipment. TYPICAL USE OF ITEM: Responds to hazardous materials incidents in Hopkins and member Southwest mutual aid communities. Used by police and fire as a mobile command unit. ESTIMATED LIFE OF ITEM: 20 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No E Yes Justification: ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,000 Vehicle Marked Patrol Vehicles C ......... ®off $2 ,300 1997 1998 1999 2000 2001 ::::. ....................... ggseuRuksym Squad#3 Squad#2 Squad#1 Squad#3 Squad#2 "14 K-9 Sgt Car ER 2/00 56400 58,800 91,200 62,8000" (P-6-/.5/C4 DESCRIPTION: Replacement of marked patrol vehicles: 10 vehicles(1 replaced in 1997; 2 in 1998, 1999, and 2001; 3 in 2000) TYPICAL USE OF ITEM: Vehicles are used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. ESTIMATED LIFE OF ITEM: 3 to 4 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: No xi Yes Justification: Continued large price increase by vehicle manufacturers will continue in 1997. Vehicle life will be extended to 3 years from the current 2 as 3 year warranty options are being purchased. This new plan will also expand the patrol fleet by one vehicle- needed to accommodate the new officer hired with a federal grant. Number of vehicles purchased over the next five years will decrease from current schedule of 15 down to 10 with a corresponding reduction in capital outlay despite the rise in per unit price. Price increase includes extended warranty need to justify 3 year useful life and equipment(lights, siren, etc.). ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $4,000 each Vehicle Parking Enforcement Vehicle(210) C -4" ............................................ $ 14,000 1997 1998 1999 2000 2001 a vUz EiMinj.KMK.ONO ER 14,000 DESCRIPTION: Replacement of parking enforcement vehicle. TYPICAL USE OF ITEM: Used by parking enforcement officer in the course of his duties enforcing parking regulations in the downtown area. ESTIMATED LIFE OF ITEM: 5 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: No LJ Yes Justification: ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $3,000 • Vehicle Police Administrative Vehicles C - > OTST>> ............................................ eze.;;j � I1CTl€ E Y1 $12;9(161 1997 1998 1999 2000 2001 ,160.?-" . ... ... ....... .... .................................. ................................... - (2,f3) (214) (213) (214) (213) (�/�1, ER 1,500 18,000 18,600 19,100 19,700 30o I DESCRIPTION: Replacement of department administrative and detective vehicles. a TYPICAL USE OF ITEM: 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. a ESTIMATED LIFE OF ITEM: 5-6 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: ® No LJ Yes Justification: a ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $4,000 each v a R.. MCATECONVii Equipment Radio System C -#51 $470,800 1997 1998 1999 2000 MSOURCEMM' Fire 177,800 Police ER 293,000 ✓ DESCRIPTION: Fixed site equipment for two-way radio communications. Includes console electronics,tower improvements,base stations, receivers, misc. equipment. Estimated on probability of joining Hennepin County's 800 MH2 system as an independent PSAP. TYPICAL USE OF ITEM: Provides radio communications capabilities for Police Department. ESTIMATED LIFE OF ITEM: 15 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: RI No LI Yes Justification: ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ -0- a Equipment Body Armor C -q TOTALicoR > •;:.;::::;::::>;::::>:'>::>::::>::::>::::>:::'>::>:';::::>::>::>:::::>::::>::::SCIIEDDULLED.:PURGU;SE':YEAR.::.::::::.:::: ..::::::......:.::::>:::.:::::;;; ............ .... ..........:iii:!ilii:^iii:'i:::i:'ii}ilii:'iii:::4iiiiJi:v:'i:•iY:::4i:•:�:iiiiiii:vvv4:v:�::i4: ::::: $ 5,800 19971998 1999 2000 2001 A 00 a ER 5,800 V DESCRIPTION: Bullet proof vest for police officers. v TYPICAL USE OF ITEM: a ESTIMATED LIFE OF ITEM: 5 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: Egf No D Yes Justification: a a ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ a a Equipment Police Department Computer C - ............................................ ammgoomumuminisentialtimptattnAstilegAgmminimimimmimmii. $250,000 1997 1998 1999 2000 2001 ER 250,000 v DESCRIPTION: Computer for records functions and state communications. TYPICAL USE OF ITEM: To store and retrieve department records,transfer required data to State and perform data entry, inquiries of local, state and national crime databases. ESTIMATED LIFE OF ITEM: 10 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: �-i No fl Yes Justification: ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $-0- Mll?l Equipment Police Copy Machine C- 40 TT COST SCJ DU'W P tCUA `SAA $14,200 1997 1998 1999 2000 2001 S ER 14,200 v S DESCRIPTION: Copy machine capable of producting double sided copies and collating pages. e S TYPICAL USE OF ITEM: Used to make duplicate copies of reports, letters, memos,etc., generated by police personnel. S S ESTIMATED LIFE OF ITEM: 5 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: TX No E Yes Justification: S Lam' ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,000 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii Equipment Police Logging Recorder C - 9 I r $20,000 1997 1998 1999 2000 2001 MOVMDINGNM ER 20,000 is DESCRIPTION: The police logging recorder is a device which tape records all telephone and radio transmissions which go through the Police Department. TYPICAL USE OF ITEM: Records all phone calls coming into the dispatch center and all incoming and outgoing radio transmissions. This is necessary in case questions arise as to how calls for service were received or dispatched. ESTIMATED LIFE OF ITEM: 5 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No lig Yes Justification: Equipment is in good working condition, on maintenance contract and should continue to meet our needs for at least the next year. Refinements in technology have brought down prices on recording equipment. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $-0- Vehicle 3/4 Ton Pickup(301) C- 10 SC D11 PURCH ASE'EAR $ ,500 1997 1998 1999 2000 2001 ER 21,50, DESCRIPTION: 3/4 ton 4x4 used by Street Dept. of Public Works for parking lot plowing and street maintenance. TYPICAL USE OF ITEM: Snowplowing, pulling trailers, light hauling and transportation. a ESTIMATED LIFE OF ITEM: 8 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: ❑ No Yes Justification: Change 3/4 ton pickup to 3/4 ton 4x4 with plow to better utilize vehicle for winter snowplowing. Change dollar amount to reflect actual cost. a ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,500 Vehicle 4x4 One Ton Truck(306) C - DTLFRIi iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii $22,000 1997 1998 1999 2000 2001 ER 22,000 ✓ DESCRIPTION: Truck is used in the Street Dept. of Public Works. TYPICAL USE OF ITEM: Plows alleys in winter, light hauling, snow removal and transportation. ESTIMATED LIFE OF ITEM: 8 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: NI No fl Yes Justification: ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,200 Vehicle One Ton Dump Truck(2) C - l� .. «TO AL S.T' ............................................ 5°`' 11 PGIIAE'BAR 5. 1997 1998 1999 2000 2001 ............................................ (307) (308) ER 25,500 30,500 I/ DESCRIPTION: Truck is used in the Street Department of Public Works. TYPICAL USE OF ITEM: Vehicle used by various departments for street and park maintenance and light hauling. ESTIMATED LIFE OF ITEM: 12 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: No E Yes Justification: Extend replacement out to 12 years. Past experience has shown this to be a more accurate time frame. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 3,500 /, Vehicle Tandem Dump Trucks(312,313, 315) C - 13 SC~H.EDULED PURC}I .SE YEAR .... ... $ 83,000 1997 1998 1999 2000 2001 :.;:.;:.;:.;:>::T. 11> 1::.:..':> ::::: ........ :.::.... (312) ER 83,000 v DESCRIPTION: Dump trucks used in Street Department of Public Works. TYPICAL USE OF ITEM: Trucks used for heavy hauling, snow plowing and sanding. ESTIMATED LIFE OF ITEM: 15 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: El No a Yes Justification: Extend replacement out to 15 years to reflect past actual time frame. Increase amount to $83,000 to reflect actual cost. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ -0- I� Equipment Skid Loader(324) C - 14 ............................................ ............................................ $32,500 19971998:::::::............::::.: 1999 2000 2001 ER 32,500 1/ DESCRIPTION: Skid loader used by all departments of Public Works. TYPICAL USE OF ITEM: Snow removal, loading material, light excavating, moving of palletized material, hole augering, hydro hammering and ice removal. ESTIMATED LIFE OF ITEM: 8 years a VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: a D No Ei Yes Justification: Move unit up 1 year to 1998. Current unit is in high demand. Propose to purchase new unit and retain old unit as spare to elevate the high usage. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $4,000 a el Equipment Grader(326) C- 15 < `€1' T' ;:.;:.:.:;:......... . . RULED PURCHASE YES.. ... .. .. . $ 80,000 1997 1998 1999 2000 2001 NEFuNDINGNE ER 80,000 DESCRIPTION: Grader with wing used by Street Department of Public Works. TYPICAL USE OF ITEM: Snow plowing, grading, asphalt work. ESTIMATED LIFE OF ITEM: 20 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No tgi Yes Justification: Extend out replacement 2 years, reduce amount to $80,000 and purchase 10 year- old newer machine. Reevaluate use of machine in year 2000. ^ ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 18,000 Equipment Sweeper(328) C - 16 ............................................ ............................................ $ 115 1999;.>:.>:.;;:..........:.::.;:.;:.::2000:.;:.;:.;::...................200I:.;:.;:.;:.:.,... 300 1997 1998 a ER 115,300 DESCRIPTION: Street sweeper used by Street Department for sweeping streets and parking lots. TYPICAL USE OF ITEM: Street sweeping, event clean-up, Spring sand removal. ESTIMATED LIFE OF ITEM: 10 years a VARIANCE(YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: a NI No fl Yes Justification: a ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 12,000 a OCATEGORVE ct Vehicle 1/2 Ton Pickup(704) C - 17 ............................................ S hEDU PURL rE` EAA> > $ 15,900 1997 1998 1999 2000 2001 ER 15,900 V DESCRIPTION: Pickup used by various divisions of Public Works. TYPICAL USE OF ITEM: Light hauling and transportation for supervisors. Maintenance garage service vehicle. ESTIMATED LIFE OF ITEM: 10 years VARIANCE(YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No ® Yes Justification: Delete unit 706 from schedule. Shop will utilize surplus vehicle from other sources. Extend replacement out to 10 years. Past experience has shown this to be a more accurate time frame. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,500 a0 nNumnERN Vehicle 3/4 Ton Utility Truck(804) C- 18 TOTAL; CQST> ............................................ ............................................ ............................................ $21,000 1997 1998 1999 2000 2001 ............................................ WSOURCEMiiinii ............................................ ER 21,000 V `� DESCRIPTION: 3/4 ton utility truck used by the Parks Division of Public Works. TYPICAL USE OF ITEM: Transportation to and from job sites, utility box carries tools used by personnel for job site repairs and light hauling. ESTIMATED LIFE OF ITEM: 10 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No Er Yes Justification: Extend replacement out to 10 years. Past experience has shown this to be a more accurate time frame. Change amount to reflect actual cost. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $2,500 3.I Equipment Trucksters(814, 820, 821) C --1-1 ............................................ ............................................ $ 12,700 1997 1998 1999 2000 2001 (820) ER 12,700 v DESCRIPTION: Truckster used by Parks Division of Public Works for ballfield and parks maintenance. TYPICAL USE OF ITEM: Park maintenance, ballfield grooming and weed spraying. ESTIMATED LIFE OF ITEM: 10 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: No cg Yes Justification: Extend replacement out 2 years. Existing unit in good condition. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,400 each Equipment Riding Mowers(822, 823) C - 20 $ 11,800 1997 1998 1999 2000 2001 FUC<> > ............................................ ............................................ (823) ER 11,800/ DESCRIPTION: Riding mower used by Parks Maintenance Division of Public Works. TYPICAL USE OF ITEM: Mowing city parks and right of ways. ESTIMATED LIFE OF ITEM: 7 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: No 21 Yes Justification: Extend mowers 822 and 823 to 7 year schedule. Current units in good condition. S ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,800 each S WCATECONVE Equipment Gang Mower(827) C -21 ............................................ . ....:..:........:..............:.:.::........................:...................................................................::: $42,300 1997 1998 1999 2000 2001 > FUND. GNI ............................................ .;:.;:...:::::::.....:::...:...:............... ER 42,300 s- DESCRIPTION: Tractor/gang mower used by Parks Maintenance Division of Public Works. TYPICAL USE OF ITEM: Mowing large areas in city parks. ESTIMATED LIFE OF ITEM: 15 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: 14 No El Yes Justification: ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 3,500 Equipment Turf Sweeper(830) C -2?b ............................................ ............................................ $ 10,900 1997 1998 1999 2000 2001 NNFTINDINGEM ............................................ ............................................ ER 10,900 DESCRIPTION: Turf sweeper used by Parks Department of Public Works. TYPICAL USE OF ITEM: Spring and fall leaf pick up, debris pick up. a ESTIMATED LIFE OF ITEM: 15 years a VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: a No gi Yes Justification: Existing unit was refurbished in 1996 and can be extended out 3 more years to 2001. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,500 Equipment City Hall Main Copy Machine(2) C -23 TOTALCOSI ............................................ ............................................ ............................................ 'HEDULED P .GRASE YEAR $ 1997 1998 1999 2000 2001 ......:....... :.::...:. ER 19,000' 35,000 +/ ©� OL) DESCRIPTION: Copy machine to service needs of all departments located at City Hall. 1. Variety of copying tasks. 2. High volume product copier. TYPICAL USE OF ITEM: 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. ESTIMATED LIFE OF ITEM: 3 and 5 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: No Yes Justification: Increased need for copying in general and the addition of the communication coordinator position. Short run copier needs replacement in 1996. It is 4 years old and many service calls are required. A 3 year cycle was previously used and the addition of the long run copier has not extended the life of the short run copier sufficiently to change to a 3 year life at this time. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 2,500 Equipment Microcomputer Network Server Upgrade C - : $ , 00 1997 1998 1999 2000 2001 ER 10,000 10,000 ✓ 10,000 DESCRIPTION: The network server is the hub of the network. New computers are faster and more reliable. TYPICAL USE OF ITEM: Networking allows users 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. ESTIMATED LIFE OF ITEM: Biannual flat amount. VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No ® Yes Justification: Improved technology will allow for improved performance for the network. In addition,the current server will be used to upgrade another user in the City. The old server is devoted to other uses in the organization. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $-0- Equipment Optical Scanner C -25 >`T` COST ............................................ S IEDULED PURCUASE YE: 1997 1998 1999 2000 2001 002—, ::.:. :::::::..............: ER 6,000 "" - 6 g'®u DESCRIPTION: Optical scanner for scanning documents to be put into the computer system. TYPICAL USE OF ITEM: Input of existing City documents, such as minutes and council reports, into a computer in order to have the ability to search the documents electronically. Input documents received from outside the City to avoid having to retype the documents. ESTIMATED LIFE OF ITEM: 4 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No B Yes Justification: Five years is a long time for this type of technology. Four years is more accurate. A new scanner will be faster and more accurate. The old scanner will be used elsewhere in the organization. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $-0- Equipment Election Equipment C - 2eP1 SCHEDULED URCHA E'BAR $ 68,000 1997 1998 1999 2000 2001 ER 68,000 DESCRIPTION: Ten Optech III vote tabulator machines. Machines scan and tabulate ballots. a TYPICAL USE OF ITEM: Machines are used for all even year elections. Plan is to also use them in odd year(municipal) elections. a ESTIMATED LIFE OF ITEM: 6 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: a No ❑ Yes Justification: a v ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,500 each a a ...... ... .. .......�::::.:::::.�::::::::.:::::::•:::•:::::::::::.>:.?::.?:.>:<.::....::...:..........:....>::.............:':iiiiiiii:i:::::.?:.:::.:::.:::1:.::.:iiiiii::<.ii:::�:::.Y::•:::.:i�:::::. ::::;:.: ■may,; '. �:``::�� :::;::2::�"�:::<;:?i:;:;::::;::::::::::::;::::%'<';;:�:C:::::%`�: ::7.G::�!L^'..tti'":'.: .:..��W.'i'k':.yy'�.yy.. .:�::.�::o::<.::?:.?iii:::.::.:::i::.i:iF:�:l::..�...�.�..�.............�.il��.':.•.�� Vehicle 1/2 Ton Pickup(500) ............................................ ............................................ iEDU PAI.0 ... $ 1 , 0 1997 1998 1999 2000 2001 INGM .;:.;:..::::::......:::...:..............:.... WF 15;2110-V DESCRIPTION: Pickup used by Water/Sewer Divisions of Public Works. TYPICAL USE OF ITEM: Light hauling and transportation for supervisors. ESTIMATED LIFE OF ITEM: 10 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No Yes Justification: Extend replacement out to 10 years. Past experience has shown this to be a more accurate time frame. Truck#502 dropped from ERP. Meter reading truck will be replaced with different vehicle. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 1,500 Vehicle 4x4 3/4 Ton Truck(505) C - 28 €T OST $21,900 1997 1998 1999 2000 2001 WF 21,900/ DESCRIPTION: Dump truck used by Water Division of Public Works. a TYPICAL USE OF ITEM: Snow plowing, light hauling, pulling trailers, general purpose transportation. ESTIMATED LIFE OF ITEM: 8 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: M No ❑ Yes Justification: Experience has shown an 8 year replacement cycle most cost effective, especially for this truck which is heavily used in the winter for parking lot plowing. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ v Vehicle 3/4 Ton Utility Trucks(506, 507) C - 29 ............................................ 0 1997 1998...........................1999 2000 2001 .......::..::....::::...:...:............... (506) WF/SF SF-23,000 DESCRIPTION: 3/4 ton utility trucks used by Water/Sewer Divisions of Public Works. TYPICAL USE OF ITEM: Transportation to and from job sites, utility box carries tools used by personnel for job site repairs and light hauling. ESTIMATED LIFE OF ITEM: 8 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No rgi Yes Justification: Eight year replacement cycle most cost effective. Replaces 1987 truck with 97,000 miles. Amount increased from $17,700 to $23,000 to replace existing deteriorated steel utility box. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 2,500 each Equipment Public Works Copy Machine C- 30 ii!ii!ORNUpxygii $ 9,100 1997 1998:.;:.;:.::..... 19992000:::::.:::::. 2001:::::::...... PM;.FUNP. MGM WF 9,1003 DESCRIPTION: Copy machine to service needs of all divisions of Public Works. TYPICAL USE OF ITEM: Making copies for various departments. ESTIMATED LIFE OF ITEM: 5 years VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: RI No EJ Yes Justification: Current machine will be six years old in year 2000. When replaced,the old unit will be transferred to Pavilion. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 800 ^ >;rAES(3R"Y::>::::>::>::::>::::>::::>::::>:::::<:::>::::>::::>::::>:::;::::>::::»:»< 3 - Equipment Jet Vactor(530) C - 31 <TOTAL COST ............................................ ............................................ ............................................ $ 100,000 .1997 1998 1999 2000 2001 ............................................ ............................................ ............................................ ............................................ ............................................ li$ 001 SF 100,000 DESCRIPTION: Single axle truck used by Water/Sewer Departments. S TYPICAL USE OF ITEM: Cleaning sewer and catch basins. ESTIMATED LIFE OF ITEM: 20 years S VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN: No IN Yes Justification: Reduce amount to $100,000 to reflect actual cost of size unit needed by City. Move unit on 20 year replacement schedule,evaluate existing unit in year 2000. S ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 25,000 Equipment Portable Generator(537) C - 32 Di 1 URCRASE AR $ ( 1997 1998 1999 2000 2001 e SF 8,5 DESCRIPTION: Portable generator used by Water/Sewer Divisions of Public Works. TYPICAL USE OF ITEM: Emergency back up generator for lift stations and pumps,off site power for lights and welding. ESTIMATED LIFE OF ITEM: 25 years a VARIANCE(YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: ❑ No 21 Yes Justification: Replaces two 1945 portable generators. Amount reduced from $11,900 to$8,500 as late model used generator to be purchased. ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $2,500 <><:: .Ali(3TC ::::>:::.::::::;:>: :.>:?:: :»:::::::::::: :': >:':. .. ,;::: : >;:.<: ,, . Vehicle Refuse Trucks(900, 903) C - 33 I UII�E PURCHASE YES`...... ... ::::..:::...:...::: ... ........ $ 127,700 1997 1998 1999 2000 2001 (900) RF 127,700 DESCRIPTION: Refuse trucks used by Refuse Utility Division of Public Works. TYPICAL USE OF ITEM: Residential waste pick up. ESTIMATED LIFE OF ITEM: 900- 5 years, 903 - 12 years VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN: No El Yes Justification: ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 18,000(900) $ 9,000 (903) 1 22-Oct-96 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Avg: $440,800 INFLATION FACTOR 3.0% REPL EQUIPMENT YRS 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 FIRE 101 COAMANDMBTIGATION 20 37,900 102 TELE-SQUIRT 25 490.000 103 LUVERNE PUMPER 25 318,500 104 HEAVY RESCUE 25 363,000 107 PIRSCH PUMPER 25 108 LITE RESCUE 10 62,400 83,800 109 STUPHEN AERIAL TRIO 25 687,000 115 MACK PUMPER NONE _ - SUBTOTAL 37,900 318,500 687,000 62,400 573,800 363,000 BREATHING APPARATUS 10 13,400 18,000 EXTRACTION TOOL 10 20,300 27,200 COPIER 8 7,400 9,300 RADIO SYSTEM 15 177,800_ _ SUBTOTAL 177,800 7,400 20.300 13,400 9,300 27,200 18,000 POLICE SQUAD#1 3 29,400 32,900 37,000 41,600 46,800 52,600 SQUAD#2 3 28,200 31,400 35,600 40,000 45,000; 50,660 56,900 SQUAD#3 3 27,100 30,400 34,200 38,500 43,300 48,700 54,700 SQUAD#4 3 29,400 32,900 37.000 41,600 46,800 52,600 SQUAD#5 3 28,200 31,400 35,600 40,000 45,000 50,600 56,900 207 SQUAD CAR(K-9) 4 30,400 35,600 41,600 48,700 56,900 208 SGT.CAR 4 30,400 35,600 41,600 48,700 56,900 210 CUSHMANHAULSTER 5 14,000 18,700 211 UTILITY 4X4 6 29,800 37,700 47,700 213 ADMIN CAR 2 17,500 18,600 1.9,700 20.900 22.100 23,500 24,900 26,400 28,000 29,700 214 ADMIN CAR 2 18,000 19,10020,300 21,500 22,800 24,200 25,600 27,200 28,800 30,600 SUBTOTAL 44,600 74,400 91,400 110,300 82,500 ' 115,900 55,100 163,900 96,100 61,300 103,500 228,300 86,900 115,600 120,000 173,300 129,200 181,700 84,400 258,200 RADIO SYSTEM 25 293,000 BODY ARMOR 5 5,800 6,800 7,800 9,000 COMPUTER SYSTEM 10 250,000 257.500 COPIER 5 - 14,200 16,500 19,100 LOG RECORDER 5 20,000 _ 23,200 26,900 31,200 SUBTOTAL 270,000 5,800 307,200 23,200 6,800 16,500 284,400 7,800 19,100 31,200 9,000 D t I I I [ I I [ I I I I I I I I ) 1 ) 1 1 ) 1 1 1 ) 1 1 1 1 1 1 1 ) I Page 2 REPL EQUIPMENT YRS 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 P.W.STREETS/TRAFFIC 300 1/2 T TRK 8 18,100 22,900 301 3/4 T 4X4 TRK 8 21,500 27,200 34400 306 4X4 I TON 8 22,000 27,900 307 1 TON DUMP 12 25,500 36,400 308 I TON DUMP 12 30,500 43,500 309 1 TON BOOM TRK 10 50,400 67,900 310 SGLAX DUMP 13 84,700 124,200 312 TANDEM DUMP IS 83,000 129,700 313 TANDEM DUMP 15 102,900 315 TANDEM DUMP 15 96,900 316 WATER TRUCK 15 133,700 320 FRONT END LOADER 15 123,400 321 FROM END LOADER 15 194,300 324 SKID LOADER 8 32,500 41,200 52,200 326 GRADER 20 80,000 328 SWEEPER 10 115,300 155,100 330 ROLLER 15 36,200 336 STRIPER 10 10,100 11,700 341 PAVER 15 44,700 343 SNOW BLOWER 20 119,100 348 TRAILER 20 4,900 349 TRAILER 20 4900 SUBTOTAL 47,000 115,500 102,000 145,800 84,700 28,200 36,200 271,900 164,600 27,900 143,100 133,700 325600 219,300 52,200 192,100 119,100 F.W.ENGINEERING 700 ENGINEERING VAN 10 I I I I I 1 I 1 14,300 1 I I I I I I I I 1 19,200 1 I • P.W ADMIN RADIO SYSTEM 151 I I 1 I I I 1 47,2001 1 I I I I I I I I I P.W.BLDG./EOUIPMENT SERVICES 704 1/2TTRK 101 I I 1 15,E 1 I I I I I I I I 1 21,500 1 I I 1 1 I D Page 4 REPL EQUIPMENT YRS 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 HRA 410 1/2TTRK 4x4(HRA) e I I I I I 1 I 22,8001 1 I I I I I I 28,800 I I 1 I I I WATER 500 1/2 T S-10 10 15,200 I 20,500 505 4X4 3/4 T TRK 8 21,900 27,800 35,200 508 3/4 T UTILITY 8 20,600 26,100 533 BACKHOE 20 134,80 540 AIR COMPRESSOR 20 17,700 P.W.COPIER(Water) 5 9,100 10,600 12,200 14,200 TELEPHONE SYSTEM 10 8,000 9,300 RADIO SYSTEM P.W. 1550,000 SUBTOTAL 15,200 31,000 25,700 70,600 10,600 20,50 27,800 12,200 35,400 134,800 14,200 35,200 SEWER 506 3/4 UTILITY TRK- 8 23,000 29,30 37,200 530 JET VACTOR 20 10,00 536 RODDING MACHINE 15 - 31,400 537 GENERATOR 25 8,500 538 GENERATOR/I'R.L 25 TELEPHONE SYSTEM 10 8.000 9,300 RADIO SYSTEM P.W. 15 - 50,000 SUBTOTAL 31,500 100,000 8,000 81,400 29,300 9,300 37,200 REFUSE 900 REFUSE TRK(RAP-R) 5 127,700 148,000 171,600 198,900 901 REFUSE TRK(RAP-R)SPARE 6 903 REFUSE TRK(REAR-L) 12 85,100 RADIO SYSTEM P.W. 15 50,000 - ' SUBTOTAL 127,700 198,000 85,10 171,600 198,900 D f I I I I I I I 1 I I I I I I 1 I I f I I I i I I I I I I I I I I I I I l I Page 3 REPL EQUIPMENT YRS 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 P.W.PARKS&FORESTRY 800 I/2 TON TRUCK 10 20,300 27,200 801 3/4 TON 4X4 TRUCK 8 26,600. 33,700 802 3/4 TON 4X4 TRUCK 8 26,600 33,700 804 3/4 TON UTILITY TRK 10 21,000 . .28,200 811 LOG TRUCK 20 19,200 812 AERIAL LIFT 20 19,200 816 TRACTOR 20 34,700 817 TRACTOR 20 32,700 818 TRUCKSTER 10 16,600 820 TRUCKSTER 10 12,700 17,100 821 TRUCKSTER 10 15,600 21,000 822 MOWER 7 13,400 16,500 823 MOWER 7 11,800 14,600 18,000 825 HUSTLER 25 i 25,000 827 GANG MOWER 15 42,300 66,000 830 TURF SWEEPER 15 10,900 17,000 832 STUMP CUTTER ID 16,300 21,800 834 BRUSH CHIPPER 10 19,100 25,600 843 TRAILER FLTBD 20' _ 2,700 SUBTOTAL 33,700 11,800 53,200 32,700 52,800 103,500 25,000 32,900 14,600 45,300 16,500 41,100 67,400 52,800 39,000 104,800 CITY HALL ADMIN C.H.MAIN COPIER 3 19.000 20,800 22,700 24.800 27,100 29,600 C.H.MAIN COPIER 5 35,000 40,600 47,100 54,600 C.H.NETWORK UPGRADE 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 OPTICAL SCANNER 4 6,000 6,800 7,600 8,400 9,600 ELECTION EQUIP 6 68,000 81,200 96,900 • PHONE SYSTEM 10 102,700 138,200 FINANCE COMPUTER 7 130,000 _ 159,900 _ SUBTOTAL 10,000 6,000 97,000 35,000 10,000, 130,300 140,000 154,500 7,600 10,000 24,800 10,000 215,400 134,000 138,200 10,000 39,200 64,600 D Page 5 TOTALS 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 GEN FUND VEH/EQUIP TOTAL 91,600 227,800 125,100 240,000 281,500 551,800 823,100 303,600 455,400 258,800 118,100 256,200 275,300 287,300 486,700 240,700 401,300 272,900 850,300 845,100 GEN FUND OTHER EQUIP TOTAL 10,000 276,000 97,000 40,800 495,000 130,300 170,600<._ 47,200::-.-181,600 37,500 ;;.10,000 109,200 10000 223,200 162,400 138,200 41,200 39,200 100,800 18,000 HRA TOTAL 22.800 28,800 WATER TOTAL 15,200 31,000 25,700 70,600 10,600 20,500 27,800 12,200 35,400 134,800 14200 35200 SEWER TOTAL 31,500 100,000 8,000 81,400 29,300 9,300 37,200 REFUSE TOTAL 127,700 198,00085,100 171,600 198,900 GENERAL FUND TOTAL 101,600 503,800 222,100 280,800 776,500 682,100 993,700 350,800 637,000 296,300 128,100 565,400 285,300 510,500 649,100 378,900 442,500 312,100 951,100 863,100 HRA TOTAL 22,800 28,800 UTILITY TOTAL 46,700 127,700 131,000 33,700 350,000 39,900 20,500 112,900 171,600 12,200 44,700 172,000 198,900 14,200 35,200 ALL FUNDS ANNUAL TOTAL 148,300 503,800 349,800 411,800 776,500 715,800 1,016,500 700,800 676,900 296,300 148,600 678,300 456,900 522,700 677,900 423,600 614,500 511,000 965,300 898,300 GENERAL FUND SALVAGE 26,700 43,600 40,500 37,600 57,900 48,000 27,000 68,700 111,000 46,700 65,000 68,400 86,100 34,100 58.900 58.900 58,900 58,900 58,900 58,900 NEC GENERAL FUND 74,900 460,200 181,600 243,200 718,600 634,100 966,700 282,100 526,000 249,600 63,100 497,000 199,200 476,400 590,200 320,000 383,600 253,200 892,200 804,200 AVERAGES Total A Ann FIRE EQUIP 20 YEAR AVERAGE: 2,042,600 102,100 FIRE ADMIN 20 YEAR AVERAGE: 273,400 13,700 POLICE EQUIP 20 YEAR AVERAGE 2,376,600 118,800 POLICE ADMIN 20 YEAR AVERAGE: 981,000 49,100 STREET EQUIP 20 YEAR AVERAGE: 2,208,900 110,400 BLDG MAINT EQUIP 20 YEAR AVERAGE: 37,400 1,900 ENGINEERING EQUIP 20 YEAR AVERAGE: 33,500 1,700 PUBLIC WORKS ADMIN 20 YEAR AVERAGE: 47,200 2,400 CITY HALL ADMIN 20 YEAR AVERAGE: 1,236,600 61,800 PARKS/FORESTRY EQUIP 20 YEAR AVERAGE: 727.100 36,400 GEN FUND VEH/EQUIP 20 YEAR AVERAGE: 7,426,100 371,300 GEN FUND OTHER EQUIP 20 YEAR AVERAGE: 2,538,200 126,900 GEN FUND TOTAL 20 YEAR AVERAGE: 9,964,300 498,200 HRA 20 YEAR AVERAGE: 51,600 2,600 WATER 20 YEAR AVERAGE: 433,200 21,700 SEWER 20 YEAR AVERAGE: 296,700 14,800 REFUSE 20 YEAR AVERAGE 781,300 39,100 UTILITY VEH/EQUIP 20 YEAR AVERAGE: 1,562,800 78,100 D I I I I I I I I I I I I I I I 1 I [ I EQUIPMENT & BUILDING INVENTORY a a CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 08/05/96 CURRENT REPLACEMENT UNIT# YEAR MAKE MODEL COST FIRE DEPARTMENT 101. 1978 CHEV HAZ-MAT VAN $39,400 102. 1989 FORD L9000 TELE-SQUIRT 280,000 103. 1982 LUVERNE PUMPER 225,000 104. 1991 PETERBILT HEAVY RESCUE 190,000 105. 1993 FORD CROWN VICTORIA 18,000 106. 1991 FORD CROWN VICTORIA 18,000 107. 1993 PETERBILT PUMPER 230,000 108. 1995 CHEV 4X4 LITE RESCUE 25,000 ,_ 109. 1972 STUPHEN AERIAL TRK 750,000 POLICE DEPARTMENT 200. 1996 FORD CROWN VICTORIA $20,000 201. 1995 FORD CROWN VICTORIA 20,000 202. 1994 FORD CROWN VICTORIA 20,000 204. 1996 FORD CROWN VICTORIA 20,000 205. 1995 FORD CROWN VICTORIA 20,000 206. 1993 FORD CROWN VICTORIA 20,000 207. 1996 FORD CROWN VICTORIA 20,000 208. 1995 FORD CROWN VICTORIA 20,000 ,_, 209. 1990 CHEV S-10 4X4 P.U. 15,000 210. 1994 CUSHMAN HAULSTER 13,000 211. 1996 JEEP CHEROKEE 19,000 212. 1991 CHEV LUMINA 14,000 213. 1994 PONTIAC GRAND PRIX SED 13,000 214. 1995 FORD TAURUS 16,500 215. 1996 FORD TAURUS 15,600 216. 1992 CHEV LUMINA 14,000 217. 1993 CHEV LUMINA 14,000 219. 1979 FORD VAN 20,000 240. 1989 CHEV ASTRO VAN 15,000 252. 1972 H.M. TRAILER 3,000 a I CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 08/05/96 CURRENT REPLACEMENT UNIT# YEAR MAKE MODEL COST STREET/TRAFFIC DIVISION - 300. 1995 FORD 1/2 T TRK $13,000 301. 1988 CHEV 3/4 T TRK 12,000 306. 1992 CHEV 4X4 1 TON 22,000 - 307. 1982 CHEV 1 TON DUMP 23,000 308. 1989 CHEV 1 TON DUMP 23,000 309. 1995 CHEV 1 TON TRK 28,000 310. 1989 INTERNATIONAL SGLAX DUMP 70,000 311. 1985 INTERNATIONAL SGLAX DUMP 70,000 312. 1983 INTERNATIONAL TANDEM DUMP 55,000 313. 1981 INTERNATIONAL TANDEM DUMP 55,000 314. 1979 INTERNATIONAL TANDEM DUMP 55,000 316. 1995 FORD WATER TRK 318. 1968 FORD BOOM/AUGER TRK 320. 1991 CATERPILLER LOADER 926E 90,000 321. 1990 CATERPILLER LOADER 936E 120,000 324. 1989 NEW HOLLAND SKID LOADER 24,000 326. 1976 JOHN DEERE GRADER 670 123,000 328. 1991 ELGIN SWEEPER 80,000 330. 1989 INGERSOL/RAND ROLLER DD-25 23,000 333. 1989 INNOVAC LITTER HOG 12,000 334. 1988 FOX SANDER 3,000 335. 1987 CRAFCO CRACK FILLER 5,000 336. 1987 MB STRIPER W/TRLER 7,000 337. 1994 CATERPILLAR BOX PAVER 18,000 338. 1984 STONE CEMENT MIXER 3,000 340. 1980 ALKOTA STEAMER 1,000 341. 1970 LAYTON SKID PAVER 25,000 342. 1991 TARGET CONCRETE SAW 2,400 343. 1968 ROOT SNOW BLOWER 40,000 344. 1964 ROGERS ASPHALT CUTTER 2,000 345. 1989 M-B-W VIB PLATE 2,000 346. 1984 WENGER STAGE TRLER 8,000 348. 1989 TRAIL-KING TK6V-1200 3,000 349. 1989 TRAIL-KING MK6V-1200 3,000 351. 1943 POLE TRAILER II CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 08/05/96 CURRENT REPLACEMENT UNIT# YEAR MAKE MODEL COST FLOAT VEHICLES 408. 1989 CHEV CELEBRITY $12,000 601. 1983 CHEV 1/2 T TRK 10,000 611. 1979 CHEV 1 T DUMP 15,000 ENGINEERING DIVISION 700. 1986 FORD ENG. VAN $17,000 701. 1991 CHEV LUMINA 10,000 BUILDING& EQUIPMENT SERVICES 704. 1991 CHEV 1/2 T S-10 $11,000 705. 1985 CHEV 1/2 T TRK 11,000 706. 1988 CHEV 1/2 T TRK S-10 11,000 PARKS/FORESTRY DIVISION 800. 1993 CHEV 1/2 T TRK $12,500 801. 1996 CHEV 4X4 TRK 19,100 802. 1996 CHEV 4X4 TRK 19,100 804. 1986 CHEV 3/4 T UTILITY 15,000 807. 1990 OLYMPIA ICE RESURFACER 45,000 810. 1993 INTERNATIONAL LP 4700 50,000 811. 1987 FORD LOG TRUCK 83,000 812. 1989 FORD AERIAL LIFT 85,000 814. 1983 EZ-GO TRUCKSTER 10,000 816. 1984 FORD TRACTOR 2910 22,000 816.1 FLAIL ATTACHMENT 11,000 817. 1982 FORD TRACTOR 2610 22,000 818. 1996 TORO TRUCKSTER 13,000 819. 1987 CUSHMAN HAULSTER 5,000 820. 1987 CUSHMAN TRUCKSTER 10,000 821. 1986 CUSHMAN TRUCKSTER 10,000 822. 1989 TORO GM72 MOWER 10,000 823. 1992 TORO MOWER 345 14,000 824. 1996 TORO GROUND MASTER 16,000 825. 1980 EXCEL/HUSTLER 602D 10,000 827. 1979 JACOBSON GANG MOWER 40,000 830. 1987 OLATHE TURF SWEEP 8,500 832. 1986 VERMEER STUMP CTR 630A III CITY OF HOPKINS VEHICLE/EQUIPMENT INVENTORY 08/05/96 CURRENT REPLACEMENT UNIT# YEAR MAKE MODEL COST PARKS/FORESTRY DIVISION(CONT.) 834. 1983 MORBARK BRUSH CHIPPER $12,500 836. RYAN SOD CUTTER 2,000 837. 1973 PUTTTYPE TURF VAC 8,500 840. 1991 VICTORIAN TRAILER 2,000 841. 1977 H.M. TRAILER 1,000 842. 1975 H.M. TRAILER 1,000 843. 1975 H.M. TRAILER FLTBD 2,500 844. 1973 CANOE HM TRAILER 1,000 BRA 411. 1995 CHEV 3/4 T 4X4 $17,500 413. 1985 MUSTANG SKID LOADER 15,000 WATER/SEWER 500. 1989 CHEV 1/2 TON S-10 $10,500 501. 1990 CHEV 1/2 TON 4X4 6,000 502. 1984 GMC 1/2 T TRK 11,500 505. 1992 CHEV 3/4 T 4X4 16,000 506. 1987 CHEV 3/4 T UTILITY 14,500 507. 1985 FORD 3/4 T UTILITY 14,500 530. 1982 FORD JET VACTOR 150,000 533. 1993 CATERPILLAR LDR-BKHOE-446 50,000 535. 1992 KOHLER GENERATOR/TRL 10,000 536. 1989 FLEXIBLE RODDING MACHINE 25,000 537. 1948 FAIRBANKS MORSE GENERATOR/TRL 15,000 538. 1948 FAIRBANKS MORSE GENERATOR/TRL 15,000 539. ESSICK PUMP TRAILER 540. 1982 SULLAIR AIR COMPRESSOR 12,000 541. 1981 WACKER TAMPER 2,000 542. 1994 WACKER TAMPER 4,000 REFUSE 900. 1994 PETERBILT RAPID RAIL $160,000 901. 1985 MACK RAPID RAIL 106,000 903. 1977 FORD PAC-MOR 56,000 IV CITY OF HOPKINS BUILDING INVENTORY August 1996 Location/Description Replacement Cost City Hall $1,957,000 1010 1st Street S. Hopkins Activity Center 721,000 33 14th Avenue S. Ice Arena 2,266,000 1515 2nd Street S. PW Admin/Garage 952,750 1601 2nd Street S. PW Cold Storage Bldg#1 190,600 117-121 17th Avenue S. PW Cold Storage Bldg#2 278,000 117-121 17th Avenue S. Barn 118,500 117-121 17th Avenue S. Landfill Building 25,000 1414 7th Street S. — Moline Reservoir 779,000 916 County Road 3 Blake Tower Reservoir 443,000 151 Tyler Avenue S. Well #1 Filtration Plant 134,000 916 County Road 3 Filtration Plant 587,000 1401 Elmo Park Service Road Well#4 80,000 1401 Elmo Park Service Road Well#5 64,000 1205 Highway? Well#6 63,000 801 Highway 7 V a Location/Description Replacement Cost Lift Station#1 - 21st 70,000 202 21st Avenue N. a Lift Station#2- Drillane 20,000 619 Drillane Road Lift Station#3 - Lindee's 50,000 901 Cambridge Street N.E. Lift Station#4- LTL Meadowbrook 100,000 244 Meadowbrook Road Lift Station#5 - Big Meadowbrook 150,000 6601 Excelsior Blvd. Lift Station#6- Ronnie's 70,000 1029 Excelsior Avenue E. Lift Station#7-Valley 135,000 801 6th Avenue S. Park Building-Beach-Lifeguards 21,700 5200 Shady Oak Road Park Building-Beach-Concessions 24,000 5200 Shady Oak Road Park Building-Beach-Restrooms 27,000 5200 Shady Oak Road — Park Shelter- Beach 16,000 5200 Shady Oak Road a Park Shelter- Burnes 27,000 201 Park Lane — Park Building- Central 70,000 101 17th Avenue S. a Park Building- Harley 12,000 108 Jackson Avenue S. a Park Shelter- Interlachen 9,000 220 Homedale Avenue a Park Building- Oakes 9,800 301 Tyler Avenue N. Park Building-Valley 10,300 800 7th Avenue S. a VI Location/Description Replacement Cost Dow Towers(76 Units) HRA 22 5th Avenue S. 20th Avenue Townhouses(10 Units) HRA 29 20th Avenue S. Parking Ramp 1,740,000 10th Avenue and Mainstreet e a VII kumi ..d .. Immt ..