1993-2000 ERP '4.,4.,V.ka.riH' 1/1.‘,/1(.7.---4.)AJVIC, 4)./
City of Hopkins, Minnesota
"......... ;1 y
0
3 � -;'-,-Tim 14.7!..,1
isr_tir_v Equipment
Replacement. t
- , low
- 7....„,_,___:____,_,_„
� = . Plan
AMR liiiiiiiiC
1996 - 2000
',1.4„. ,ilk: 41:Cs,,z 1.
hCG' If., ! f r. :a>,<.
bZ0 t It.,
4 �I�,� I ,,I l i I
I:
_,w
1 _ 4dit4. 4 .1 I.
0-. r a 1, r'
0 Uri
OMR
r-,
P.
114
poni
.,
...
•1I•
ee1340
•111111
134*
CITY O F HOPKINS
DATE: October 1995
TO: Honorable Mayor and City Council
FROM: Steven C. Mielke, City Manager
SUBJECT: 1996-2000 Equipment Replacement Plan
With this letter, I respectfully submit the 1996-2000 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 $484,700).
The cash needs will experience a somewhat drastic roller coaster effect over the next 20 years
given the present equipment needs and a 3% inflation rate. Cash will increase thru the year 2000
and then the next five years will deplete the cash balance. The last ten years of the schedule will
smooth, but will pick up by 2015. In order to accomplish this pattern, it will be necessary to
increase the 1995 levy by $50,000 to the $450,000 level - the first levy increase 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.
1010 First Street South Hopkins, Minnesota 55343
Phone: 612-935-8474 Fax: 612-935-1834
An Equal Opportunity Employer
Highlights of changes from last year:
Fire:
Drop ambulance and crew cab
Add lite rescue 4x4 vehicle
City Hall Admin:
Finance computer and network were integrated and purchased in 1995, with a biannual
upgrade amount established. The inspection computers were eliminated from the
Equipment Replacement Plan.
Copiers - previously two machines were replaced at 3 year alternating intervals. In the
future, City will use one heavy duty copier with a 5 year life and one smaller copier whose
life will be extended to 4 years.
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 1996-2000
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-46
Twenty Year Equipment Replacement Schedule D
SECTION II
Equipment and Building Inventory
Vehicle/Equipment Inventory I - IV
Building Inventory V-VII
S
CAPITAL EQUIPMENT
FIVE YEAR FUNDING SUMMARY
EQUIPMENT REPLACEMENT FUND
(000 omitted)
1996 1997 1998 1999 2000
Fund Balance Begin Year 442 555 801 531 750
Tax Levy 450 450 450 450 450
Other Income(Expenses) 35 35 35 35 35
Capital Purchases 372 239 755 266 191
Balance 12/31/2000 1,044
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 1996 1997 1998 1999 2000
C-1 Haz-Mat Van y'ya E.R. 37,900
C-2 Breathing Air Compressor / 87c" S/, E.R. 10,000
C-3 Marked Patrol Vehicles (13) E.R. 64,500 67,800 94,800 49,800 78,300
C-4 4x4 Vehicle E.R. 26,000
C-5 Parking Enforcement Vehicle E.R. 14,000
C-6 Administration Vehicles (5) E.R. 17,000 17,500 18,000 18,600 19,100
C-7 Body Armor E.R. 5,800
C-8 Police Computer E.R. 250,000
C-9 L/I- Police Copy Machine C2? E.R. 12,200
C-10 Police Logging Recorder E.R. 25,000
C-11 3/4 Ton Pickup E.R. 15,000
C-12 4X4 One Ton Truck E.R. 22,000
C-13 One Ton Dump Truck (2) E.R. 25,500 30,500
C-14 Single Axle Dump E.R. 78,200
C-15 Tandem Dump Trucks (3) E.R. 66,100 75,200
C-16 Skid Loader E.R. 32,500
C-17 Grader E.R. 139,400
C-18 Litter Hog E.R. 16,200
C-19 Crack Filler E.R. 4,900
C-20 Cement Mixer E.R. 2,900
C-21 Asphalt Paver E.R. 27,000
C-22 Snow Bloweraw cy,-0Q,:c2,“/dyt'4 3!$Z E.R 62,000_..
C-23 Engineering Van E.R. 12,000
C-24 1/2 Ton Pickups (3) E.R. 14,800 15,000
C-25 3/4 Ton Pickup with Plow (2) E.R. 42,000
C-26 3/4 Ton Utility Truck E.R. 17,300
C-27 Tractor - Parks E.R. 28,200 29,900
C-28 Truckster (3) 14( R S% /Z1Z7 E.R. 12,300 12,700
C-29 Riding Mowers (2) 5/7 /5- Lifb E.R. 10,900 11,800
C-30 Gang Mower E.R. 10,000
C-31 Turf Sweeper E.R. 10,900
C-32 Stump Chipper E.R. 12,000
C-33 Turf Vac E.R. 11,200
C-34 City Hall Main Copy Machine (2) E.R. 18,000 35,000
C-35 City Hall Micro Network Upgrade E.R. 10,000 • 10,000
�.. C-36 Optical Scanner E.R. 6,700
C-37 Election Equipment E.R. 68,000
C-38 Skid Loader HRA 20,900
C-39 1/2 Ton Pickup W.F. 15,200
- C-39 1/2 Ton Pickup S.F. 16,100
C-40 4X4 3/4 Ton Dump Truck W.F. 21,900
C-41 3/4 Ton Utility Truck I 60/c1 (1(lilc'c W.F. 16,300
C-41 3/4 Ton Utility Truck S.F. 17,700
- C-42 Water Meter Computer W.F. 34,900
C-43 Public Works Copy Machine W.F. 9,100
C-44 Jet Vactor S.F. 164,600
C-45 Portable Generator S.F. 11,900
C-46 Refuse Trucks (2) R.F. 56,300 127,700
TOTAL CAPITAL EQUIPMENT REPLACEMENT PROGRAM 444,600 283,500 919,900 393,400 293,600
FUNDING: EQUIPMENT REPLACEMENT FUND (LEVY) 372,000 238,700 755,300 265,700 190,700
ENTERPRISE FUND 72,600 44,800 164,600 127,700 82,000
HRA 20,900
B
CATEGORY CAPITAL ITEM NUMBER
Vehicle Haz-Mat Van (101) C - 1
TOTAL COST SCHEDULED PURCHASE YEAR
—
$ 37,900 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 37,900
DESCRIPTION:
Marked hazardous materials response 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 ti-
y
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
Ell Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,000
CATEGORY CAPITAL ITEM NUMBER
Equipment Breathing Air Compressor C - 2
TOTAL COST SCHEDULED PURCHASE YEAR
$ 10,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 10,000
DESCRIPTION:
Breathing air compressor with moisture and dirt filtering system.
TYPICAL USE OF ITEM:
Used to refill air bottles used by firefighters for breathing air when entering a hazardous atmosphere.
ESTIMATED LIFE OF ITEM: 10 years
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
No
MI Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $ 200
CATEGORY CAPITAL ITEM NUMBER
Vehicle Marked Patrol Vehicles C - 3
TOTAL COST SCHEDULED PURCHASE YEAR
$ 355,200 1996 1997 1998 1999 2000
FUNDING (202)
SOURCE(S) (202) (200) (203) (202)
(203) (201) (207) (200) (203)
(208) (206) (208) (201) (208)
ER 64,500 67,800 94,800 49,800 78,300
DESCRIPTION:
Replacement of marked patrol vehicles:
15 vehicles: 3 replaced in each of 1996, 1997 and 2000, 4 in 1998, and 2 in 1999.
TYPICAL USE OF ITEM:
Vehicles are used by patrol officers to respond to calls, enforce traffic laws and perform general patrol
duties.
ti
ESTIMATED LIFE OF ITEM: 2 to 4 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
NM No
Yes (Justification)
Less than expected usage allowed us to defer purchase of two vehicles. One was deferred in
1995 and one will be in 1996.
Price increase of vehicles due to manufacturers reduction in fleet discounts given.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $4,000 each
CATEGORY CAPITAL ITEM NUMBER
Vehicle 4 Wheel Drive Pickup (209) C - 4
TOTAL COST SCHEDULED PURCHASE YEAR
$ 26,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 26,000
DESCRIPTION:
4 wheel drive pickup or similar vehicle.
TYPICAL USE OF ITEM:
Utility vehicle used primarily by public service officers who must pick up stray animals and transport
property. This vehicle is also used by reserve officers on patrol and by regular officers as a patrol vehicle
in weather necessitating the use of 4 wheel drive.
ESTIMATED LIFE OF ITEM: 6 years
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
No
7Z1, Yes (Justification)
Pickup truck type vehicle has been found less than suitable for its multiple uses. A 4 door
utility type vehicle would function much better. These types of vehicles are more expensive
than regular pickup trucks because of their popularity. In addition, vehicle manufacturers
have restructured their fleet pricing in the past year resulting in prices of all types of vehicles
being considerably higher. Resale value of the used vehicles is also anticipated to be
considerably higher than estimated originally.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $8,000
CATEGORY CAPITAL ITEM NUMBER
Vehicle Parking Enforcement Vehicle (210) C - 5
TOTAL COST SCHEDULED PURCHASE YEAR
$ 14,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
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:
Kl No
NM Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $3,000
CATEGORY CAPITAL ITEM NUMBER
Vehicle Police Administrative Vehicles C - 6
TOTAL COST SCHEDULED PURCHASE YEAR
$ 90,200 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(214) (213) (214) (213) (214)
ER 17,000 17,500 18,000 18,600 19,100
DESCRIPTION:
Replacement of department administrative and detective vehicles.
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.
ESTIMATED LIFE OF ITEM: 5 years
VARIANCE(YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
No
Yes (Justification)
Increase in base price due to manufacturers reduction in fleet discount amounts.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $4,000 each
CATEGORY CAPITAL ITEM NUMBER
Equipment Body Armor _ C - 7
TOTAL COST SCHEDULED PURCHASE YEAR
$ 5,800 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 5,800
DESCRIPTION:
Bullet proof vest for police officers.
TYPICAL USE OF ITEM:
ESTIMATED LIFE OF ITEM: 7 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
rSZ No
Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
CATEGORY CAPITAL ITEM NUMBER
Equipment P.D. Computer C - 8
TOTAL COST SCHEDULED PURCHASE YEAR
$ 250,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 250,000
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:
►� No
F-1 Yes (Justification)
The State, barring unforeseen problems, is continuing to support our current platform and will
do so as long as they can afford to. Estimate 3-5 years for a mandated change.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $-0-
CATEGORY CAPITAL ITEM NUMBER
Equipment Police Copy Machine _ C - 9
TOTAL COST SCHEDULED PURCHASE YEAR
$ 12,200 1996 1997 1998 1999 2000
FUNDINGa{ G 15
SOURCE(S) ? 3q
ER 12,200
/- 1 .f5
DESCRIPTION:
Copy machine capable of producing double sided copies and collating pages.
TYPICAL USE OF ITEM:
Used to make duplicate copies of reports, letters, memos, etc., generated by police personnel.
ESTIMATED LIFE OF ITEM: 5 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
1751 No
MI Yes (Justification)
5 a4)
°'
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,060
CATEGORY CAPITAL ITEM NUMBER
Equipment Police Logging Recorder C - 10
TOTAL COST SCHEDULED PURCHASE YEAR
$ 25,000 1996 1997 s 1998 1999 2000
FUNDING
SOURCE(S)
ER 25,000
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 trans-
missions. 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:
►NM No
111.1 Yes (Justification)
Current equipment working well. This equipment has been well maintained and continues to
work reliably. Technical support is available.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $-0-
CATEGORY CAPITAL ITEM NUMBER
Vehicle 3/4 Ton Pickup (301) C - 11
TOTAL COST SCHEDULED PURCHASE YEAR
$ 15,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 15,000
DESCRIPTION:
3/4 ton pickups used by Building Services and Water/Sewer Divisions of Public Works for heavy
loads and pulling trailers.
TYPICAL USE OF ITEM:
Light hauling, pulling trailers, transportation to and from job sites.
ESTIMATED LIFE OF ITEM: 8 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
►� No
MMI Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,500
CATEGORY CAPITAL ITEM NUMBER
Vehicle 4x4 One Ton Truck (306) C - 12
TOTAL COST SCHEDULED PURCHASE YEAR
$ 22,000 1996 1997 1998 I 1999 I 2000
FUNDING
SOURCE(S)
ER 22,000
DESCRIPTION:
Truck is used in the Street Dept. of Public Works.
S
TYPICAL USE OF ITEM:
S
ESTIMATED LIFE OF ITEM: 8 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
IIIII Yes (Justification)
S
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
CATEGORY CAPITAL ITEM NUMBER
Vehicle One Ton Dump Truck (2) C - 13
TOTAL COST SCHEDULED PURCHASE YEAR
$ 56,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(308) (307) —
ER 25,500 30,500
DESCRIPTION:
Truck is used in the Street Department of Public Works.
TYPICAL USE OF ITEM:
Vehicle used by various departments for light hauling and snow plowing.
ESTIMATED LIFE OF ITEM: 8 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $3,500
CATEGORY CAPITAL ITEM NUMBER
Vehicle Sinae Axle Durn. (311) C - 14
TOTAL COST SCHEDULED PURCHASE YEAR
$ 78,200 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 78,200
DESCRIPTION:
Single axle dump truck used in the Street Department.
TYPICAL USE OF ITEM:
Vehicle used for heavy hauling, snow plowing and sanding.
ESTIMATED LIFE OF ITEM: 13 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
�� No
OM Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $6,000
CATEGORY CAPITAL ITEM NUMBER
Vehicle Tandem Dump Trucks (2) C - 15
TOTAL COST SCHEDULED PURCHASE YEAR
$ 141,300 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(313) (312)
ER 66,100 75,200
DESCRIPTION:
Dump trucks used in Streets Division of Public Works.
TYPICAL USE OF ITEM:
Trucks used for heavy hauling, snow plowing and sanding.
ESTIMATED LIFE OF ITEM: 13 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
Ell No
Yes (Justification)
Change tandem to single axle and add front mounted plow and under belly plow.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $-0-
S
CATEGORY CAPITAL ITEM NUMBER
Equipment Skid Loader 324 C C . 16
TOTAL COST SCHEDULED PURCHASE YEAR
$ 32,500 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 32,500
DESCRIPTION:
S
TYPICAL USE OF ITEM:
r
ESTIMATED LIFE OF ITEM: 10 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
IM Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
S
CATEGORY CAPITAL ITEM NUMBER
Equipment Grader (326) C - 17
TOTAL COST SCHEDULED PURCHASE YEAR
$ 139,400 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 139,400
DESCRIPTION:
Grader with wing used by Streets Division 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
MN Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $18,000
CATEGORY CAPITAL ITEM NUMBER
Equipment Litter Hog (333) C - 18
TOTAL COST SCHEDULED PURCHASE YEAR
$ 16,200 1996 1997 1998 1999 I 2000
FUNDING
SOURCE(S)
ER 16,200
— DESCRIPTION:
S
TYPICAL USE OF ITEM:
ESTIMATED LIFE OF ITEM: 10 years
S
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
J No
Yes (Justification)
S
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
CATEGORY CAPITAL ITEM NUMBER
Equipment Crack Filler (335) C - 19
TOTAL COST SCHEDULED PURCHASE YEAR
$ 4,900 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 4,900
DESCRIPTION:
Crack filler used in Street Department for street maintenance.
TYPICAL USE OF ITEM:
Filling cracks in asphalt with a hot emulsion.
ESTIMATED LIFE OF ITEM: 10 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
MI Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $500
CATEGORY CAPITAL ITEM NUMBER
Equipment Cement Mixer (338) C - 20
TOTAL COST SCHEDULED PURCHASE YEAR
$ 2,900 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 2,900
DESCRIPTION:
TYPICAL USE OF ITEM:
ESTIMATED LIFE OF ITEM: 15 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
1: 1, No
N Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
CATEGORY CAPITAL ITEM NUMBER
Equipment Asphalt Paver (341) C - 21
TOTAL COST SCHEDULED PURCHASE YEAR
$ 27,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 27,000
DESCRIPTION:
Asphalt paver used by Streets Division of Public Works.
TYPICAL USE OF ITEM:
Paving streets and parking lots.
ESTIMATED LIFE OF ITEM: 15 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
175i, No
IME Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $500
CATEGORY CAPITAL ITEM NUMBER
Equipment Snow Blower(343) C - 22
TOTAL COST SCHEDULED PURCHASE YEAR
$ 62,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 62,000
DESCRIPTION:
Snow blower used by the Streets Division of Public Works.
TYPICAL USE OF ITEM:
Blowing and loading snow off Mainstreet into trucks.
S
ESTIMATED LIFE OF ITEM: 20 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
Ili No
1>Z11 Yes (Justification)
Increase amount to reflect actual costs.
S
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $4,500
S
CATEGORY CAPITAL ITEM NUMBER
Vehicle Engineering Van (700) C - 23
TOTAL COST SCHEDULED PURCHASE YEAR
$ 12,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 12,000
DESCRIPTION:
Van used by Engineering Department for survey equipment and on job site work.
TYPICAL USE OF ITEM:
Transportation to and from job site, hauling of surveying and traffic counting equipment.
ESTIMATED LIFE OF ITEM: 10 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
MI Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $2,500
CATEGORY CAPITAL ITEM NUMBER
Vehicle 1/2 Ton Picks (3) C - 24
TOTAL COST SCHEDULED PURCHASE YEAR
$ 29,800 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(706) (704)
ER 14,800 15,000
DESCRIPTION:
Pickups used by various divisions of Public Works.
a
TYPICAL USE OF ITEM:
Light hauling and transportation for supervisors.
ESTIMATED LIFE OF ITEM: 8 years
VARIANCE(YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
EMI No
161 Yes (Justification)
706 - Extend out to 1997.
704 - Extend out to 1998.
a
a
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,500 each
CATEGORY CAPITAL ITEM NUMBER
Vehicle 3/4 Ton 4x4 Pickup with Plow(2) C - 25
TOTAL COST SCHEDULED PURCHASE YEAR
$ 42,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S) (803)
21,000
(809)
ER 21,000
DESCRIPTION:
Trucks used by Parks Division of Public Works for park maintenance and snow plowing.
TYPICAL USE OF ITEM:
Snow plowing, pulling mower trailers, light hauling and transportation.
,ESTIMATED LIFE OF ITEM: 8 years
VARIANCE(YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
Mil No
Yes (Justification)
Increase amount to reflect actual costs.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $2,500 each
CATEGORY CAPITAL ITEM NUMBER
Vehicle 3/4 Ton Utility Truck (804) C - 26
TOTAL COST SCHEDULED PURCHASE YEAR
$ 17,300 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 17,300
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: 8 years
^ VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
Yes (Justification)
a
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $2,500 each
CATEGORY CAPITAL ITEM NUMBER
Equipment Parks Tractor(2) C - 27
TOTAL COST SCHEDULED PURCHASE YEAR
$ 58,100 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(817) (816)
ER 28,200 29,900
DESCRIPTION:
Tractor used in Parks Department for rink maintenance and flail mower attachments.
TYPICAL USE OF ITEM:
Rink maintenance, garden maintenance, flail mower used for mowing tall grass and fall leaf pick up.
ESTIMATED LIFE OF ITEM: 15 years
ARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $4,000
CATEGORY CAPITAL ITEM NUMBER
Equipment Truckster (3) _ C - 28
a TOTAL COST SCHEDULED PURCHASE YEAR
$ 25,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(821) (820)
ER 12,300 12,700
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
a
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
No
EM Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,400 each
a
CATEGORY CAPITAL ITEM NUMBER
Equipment Riding Mower (2) C - 29
TOTAL COST SCHEDULED PURCHASE YEAR
$ 22,700 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(822) (823)
ER 10,900 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: 6 years
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
pq No
Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,800 each
CATEGORY CAPITAL ITEM NUMBER
Equipment Gang Mower(827) C - 30
TOTAL COST SCHEDULED PURCHASE YEAR
$ 10,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 10,000
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:
EN No
►� Yes (Justification)
Recondition reels and tractor in lieu of replacement. Extend replacement out 5 years.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $3,500
CATEGORY CAPITAL ITEM NUMBER
Equipment Turf Sweeper(830) C - 31
TOTAL COST SCHEDULED PURCHASE YEAR
$ 10,900 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
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.
ESTIMATED LIFE OF ITEM: 15 years
VARIANCE(YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
Il No
M Yes (Justification)
STIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,500
CATEGORY CAPITAL [TEM NUMBER
Equipment Stump Chipper (832) C - 32
TOTAL COST SCHEDULED PURCHASE YEAR
$ 12,000 1996 1997 1998 1999 2000
—
FUNDING
SOURCE(S)
ER 12,000
DESCRIPTION:
Stump chipper used by Parks Division of Public Works.
TYPICAL USE OF ITEM:
Chipping out stumps of trees removed from city property.
ESTIMATED LIFE OF ITEM: 10 years
VARIANCE(YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
MII No
�ii Yes (Justification)
Increase amount to reflect actual cost.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,800
CATEGORY CAPITAL ITEM NUMBER
Equipment Turf Vac (837) C - 33
TOTAL COST SCHEDULED PURCHASE YEAR
$ 11,200 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 11,200
DESCRIPTION:
Trailer mounted vacuum used by Parks Department.
TYPICAL USE OF ITEM:
Event clean up, leaf removal.
ESTIMATED LIFE OF ITEM: 25 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
No
Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,000
CATEGORY CAPITAL TTEM NUMBER
Equipment City Hall Main Copy Machine(2) C - 34
TOTAL COST SCHEDULED PURCHASE YEAR
$ 53,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 18,000 35,000
DESCRIPTION:
Copy machine to service needs of all departments located at City Hall.
1. Variety of copying tasks.
2. High volume product copier.
S
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: 4-5 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
MN No
Yes (Justification)
Increased need for copying in general and the addition of the communication coordinator
position.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $2,500
CATEGORY CAPITAL ITEM NUMBER
Equipment Microcomputer Network Server Upgrade C - 35
TOTAL COST SCHEDULED PURCHASE YEAR
$ 20,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER
10,000 10,000
-
DESCRIPTION:
Upgrade microcomputer network for new technology which is constantly being produced. Six hundred
chip to replace the pentium should be on the market within a year or so.
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. r.
ESTIMATED LIFE OF ITEM: Biannual flat amount.
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
No
►M Yes (Justification)
Network system purchased and installed in 1995. There are constant improvements to software
and equipment needed to keep network in tune with the latest technology.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $-0-
CATEGORY CAPITAL ITEM NUMBER
Equipment Optical Scanner C - 36
TOTAL COST SCHEDULED PURCHASE YEAR
$ 6,700 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 6,700
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.
S
ESTIMATED LIFE OF ITEM: 5 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
�� No
MIN Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $500
CATEGORY CAPITAL ITEM NUMBER
—
Equipment Election Equpment C - 37
TOTAL COST SCHEDULED PURCHASE YEAR
$ 68,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
ER 68,000 —
DESCRIPTION:
TYPICAL USE OF ITEM: —
ESTIMATED LIFE OF ITEM: 6 years
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
J No
MIll Yes (Justification)
—
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
CATEGORY CAPITAL ITEM NUMBER
Equipment Skid Loader`LC - 38
TOTAL COST SCHEDULED PURCHASE YEAR
$ 20,900 1996 1997 1998 1999 j 2000
FUNDING
SOURCE(S)
HRA 20,900
—
DESCRIPTION:
TYPICAL USE OF ITEM:
ESTIMATED LIFE OF ITEM: 15 years
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
No
— IIIIII Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
CATEGORY CAPITAL ITEM NUMBER
Vehicle 1/2 Ton Pickups (2) C - 39
TOTAL COST SCHEDULED PURCHASE YEAR
$ 31,300 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(500) (502)
WF/SF WF 15,200 SF 16,100
DESCRIPTION:
Pickups used by Water/Sewer Divisions of Public Works.
TYPICAL USE OF ITEM:
Light hauling and transportation for supervisors.
ESTIMATED LIFE OF ITEM: 8 years
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
J No
Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $1,500 each
CATEGORY CAPITAL ITEM NUMBER
Vehicle 4x4 3/4 Ton Dump Truck (505) C a 40
TOTAL COST SCHEDULED PURCHASE YEAR
$ 21,900 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
WF 21,900
DESCRIPTION:
Dump truck used by Water Division of Public Works.
^
TYPICAL USE OF ITEM:
a
ESTIMATED LIFE OF ITEM: 8 years
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
^
No
MI Yes (Justification)
^
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
CATEGORY CAPITAL ITEM NUMBER
Vehicle 3/4 Ton Utility Trucks (2) C - 41
TOTAL COST SCHEDULED PURCHASE YEAR
$ 34,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S) —
(507) (506)
WF/SF WF 16,300 SF 17,700
DESCRIPTION:
3/4 ton utility trucks used by the 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:
—
1 [ No
MN Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $2,500 each
CATEGORY CAPITAL ITEM NUMBER
Equipment Water Meter Corn•uter C - 42
TOTAL COST SCHEDULEID PURCHASE YEAR
$ 34,900 1996 1997 1998 ( 1999 2000
FUNDING
SOURCE(S)
WF 34,900
DESCRIPTION:
S
TYPICAL USE OF ITEM:
ESTIMATED LIFE OF ITEM: 10 years
VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
11 No
Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $
CATEGORY CAPITAL ITEM NUMBER
—
Equipment Public Works Copy Machine C - 43
TOTAL COST SCHEDULED PURCHASE YEAR
$ 9,100 1996 1997 1998 1999 2000
FUNDING
SOURCE(S) —
WF 9,100
DESCRIPTION:
Copy machine to service needs of all divisions of Public Works.
rJ
TYPICAL USE OF ITEM:
Making copies for various departments.
ESTIMATED LIFE OF ITEM: 5 years
ARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
No
NM Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $800
CATEGORY CAPITAL ITEM NUMBER
Equipment Jet Vactor (530) C - 44
—
TOTAL COST SCHEDULED PURCHASE YEAR
$ 164,600 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
SF 164,600
DESCRIPTION:
Single axle truck used by Water/Sewer Departments.
TYPICAL USE OF ITEM:
Cleaning sewers and catch basins.
ESTIMATED LIFE OF ITEM: 15 years
"' VARIANCE (YEAR AND/OR AMOUNT)FROM 20 YEAR PLAN:
No
IIIII Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $25,000
CATEGORY CAPITAL ITEM NUMBER
—
Equipment Portable Generator (537) C - 45
TOTAL COST SCHEDULED PURCHASE YEAR
—
$ 11,900 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
SF 11,900
DESCRIPTION:
Portable generator used by Water/Sewer Division 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
VARIANCE (YEAR AND/OR AMOUNT) FROM 20 YEAR PLAN:
IIIII No
j7;q Yes (Justification)
Extend out to 1997.
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $2,500
CATEGORY CAPITAL ITEM NUMBER
Vehicle Refuse Truck: (2) C - 46
TOTAL COST SCHEDULED PURCHASE YEAR
$ 184,000 1996 1997 1998 1999 2000
FUNDING
SOURCE(S)
(903) (900)
RF 56,300 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
MIN Yes (Justification)
ESTIMATE SALVAGE/RESALE VALUE ON REPLACED ITEM: $18,000 - 900, $ 9,000 - 903
Equipment Replacement Fund
27-Jul-95 EQUIPMENT REPLACEMENT SCHEDULE
Net General Fond 20 Year Avg S462,900
INFLATION FACTOR 3.0%
REFL./
EQUIPMENT DESCRIPTION YRS 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
101 HAZ-MAT VAN 20 37,900
490.000
102 TELE-SQUIRT 25
318 500
103 LUVERNE PUMPER 25
104 HEAVY RESCUE 25
107 PIRSCH PUMPER 25
108 LrisRes=JE 10 62,400. 83,800
109 STUPHEN AERIAL TRK 25 687,000
113 MACK PUMPER NONE
SUBTOTAL 37,900 318,500 687,000 62,400 573,300
BREATHING APPARATUS 10 10,000 13,400
EXIRACI1ON TOOL 10 20,E 27,200
COPIER 8 7,400 9,300
RADIO SYSTEM 177,800
SUBTOTAL 10,000 177,800 7,400 20,300 13,400 9,300 27,200
POLICE
200 SQUAD CAR 2 22,600 24,900 26,900 28,600 30,300 32,200 34,100 36,200 38,400 40,700
201 SQUAD CAR 2 22,600 24,900 26,900. 28,600 30,100 32,200 34,100 36,200 38,400 40,700
202 SQUAD CAR 2 21,500 23,700 26,100 27,700 29,400 31,200 33,100 35,100 37,200 39,500
203 SQUAD.CAR I 21,500 23,700 - 26,100 27,700 29,400 31,200 33,100 35,100 37,200 39,500
26,900 30,300 34,100 38,400
206 SQUAD CAR(K-9) 4 22,600 - - - 35,100 39,500
207 SOT GAR 4 23,700 27,700 31,200
208 SQUAD CAR 2 21,500 23,700 26,100 27,700 29,400 31,200 33,100 35,100 37,200 39,500
209 UTB.1TY 420 6 26.000 31,100 37,200 44,400
210 CUSHMAN HAULSTER 5 14,000 16,200 18,700 21,700
213 AMON CAR 2 17,500 18.600 19,700 20,900 22,100 23.300 24,900 26,400 28,000 29,700
214 ADMIN CAR 2 17,000 18,000 19,100 20,300 21,500 22,800 24,200 25,600 27,200 28,800
240 ASTRO VAN-CRIME PREY.
252 TRAILER 20
SUBTOTAL 107,600 85,300 112,800 82,400 97,400 100,400 162,200 78,100 125,900 113,000 147,600 87,900 160,700 145,900 166,000 98,800 138,800 143,200 252,900 111,100
RADIO SYSTEM 15 293,000
BODY ARMOR 7 5,800 7,200 8,700
COMPUTER SYSTEM 10 250,000 257,500
COPIER 5 12,200 14,200 16.500 19,100
LOG RECORDER 5 25,000 29,000 33,700 39,000
- ,
SUBTOTAL 12,200 25,000 250,000 5,800 307,200 29,000 16,500 40,900 257,500 1 19,100 39,000 8,700
I I I I I I I I I I I I I I. I I I f I
l 1 1 l l l I I 1 I 1 I 1 I I 1 1 1 1
Equipment Replacement Fund
Page 2
EQUIPMENT DESCRIPTION 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
p.W.STREEIS/IRAF7IC
301 3/4 T TRK 8 15,000 19,100 24,200
304 I/2TIRK 8 18,100 22,900 25,800
305 1 TON BOOM TRK 1050,400 _ _
306 4X41 TON 8 22,000 27,900
307 1 TON DUMP 8 30,E 38,E
308 1 TON DUMP 8 25,500 32,309 41,000
310SG1AX..DUMP 13 - _ - ._ - 84,700 124,200
311 SQLAX DUMfi 13 18,208 114,600
312 TANDEM DUMP 13 75,200 110,400
313 TANDEM DUMP 13 66,100
314 TANDEM DUMP 13 91,400
315 WATER TRUCK 15 133,700
318 BOOM/AUGERTRUCK NONE
320 CASE LOADER 15 123,400
321 LOADER 15 194,300
324 SKID LOADER 10 32,500 43,700
326 GRADER 20 139,400
328 SWEEPER 10 115,300 - 155,100
330 ROLLER 15 36,200
333 LTM,ERROO 10 16,200 21,700
335 CRACK FILLER 10 4,900 6,800
336 STRIPER 10 10,100 11,700
338 CEMENT MIXER 15 2,900 4,400
340 STEAMER NONE
341 SKID PAVER 15 27,000 44,700
343 SNOW BLOWER 20 62,000
346 STAGE NONE
348 TRAILER 20 4,900
349 TRAILER 20 4,900
351 POLE TRAILER NONE _ .
SUBTOTAL 155,100 45,400 292,800 51,600 52,500 115,300 84,700 28,200 36,200 296,100 1 123,400 98,200 66,500 172,200 133,700 447,900 76,900 4,400 150.000
p.W.ENGINEERING
700 ENGINEERING VAN 10 I 12,000 26,400
1,4
702 ENGINEERING CAR(RPL) 8
1
SUBTOTAL 12,000 I I I- 1,400 I 26,400 1 1,400
ADMIN
RADIO SYSTEM 15 I I II ___ I 1 I 188,600 I I I_ I I I I I I J
p.W.BLDOJEOUIPMENTSERVICES
704 1/2 TTRK 8 15,000 ]I 1 19,100 24,200
706 1/2TTR1CS 10 8 14,8001 1 118,700 19,100 23,800
23,800 --
SUBTOTAL 14,800 15,000
D
Equipment Replacement Fund
Page 3
EQUIPMENT DESCRIPTION 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
p.W.PARKS&FORESTRY
802 3/4 TON TRUCK 8 19,100 24,200
803 3/4 TON 4X4 TRUCK 8 21,000 26,600 33,700
804 3/4 TON UTILITY TRK 8 17,300 21,800 27,700
809 3/4 TON 4X4 TRUCK 8 21,000 26,600 33,700
811 LOO TRUCK 20 19,200
812 AERIAL LIFT 20 19,200
814 TRICKSTER 10 15,600 21,000
816 1'RACT3R19 29,900 46,600
817 TRACTOR 15 28,200 43,900
820 TRUCBBSTER 10 12,700 17,100
821 TRUCKSTER 10 12,300 16,600
822 MOWER 6 10,900 13,000 13,300. 18,500
823 BOBCAT MOWER 6 11,800 14,200 17,000
825 HUSTLER 25 25,000
827 GANG MOWER 15 10,000 42,300
830 TURF SWEEPER 05 10,900 17,000
832 STUMP CUTTER 10 12,000 - 16,300
834 BRUSH CHIPPER 10 19,100 - 25,600
836 SOD CUTTER NONE
837 TURYYAC 25 11,200
841 TRAILER NONE
842 TRAILER NONE
843 TRAILER FLTBD 20 2,700
844 TRAILER NONE
SUBTOTAL 87,200 58,200 22,100 41,700 61,400 13,000 19,100 68,800 61,000 32,900 17,100 15,500 24,200 58,100 111,300 70,300 86,100
CITY HALL ADMIN
C.H.MAIN COPIER 4 18,000 20,300 22,800 25,600 28,800
C;H.W4N COPIER S 35.000 40,600 47,100 54,600
C.H.NETWORK UPGRADE 5 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000
OPTICAL SCANNER 5 6,700 8,200.. 10,006- 12,100
ELECTION EQUIP 10 68,000 91,400
PHONE:SYSTEM 10 102,700 I38,200
FINANCE COMPUTER 6 164,800 169,800 _ 174,800
SUBTOTAL 10,000 24,700 78,000 35,000 164,800 133,000 8,200 10,000 40,600 22,800 179,800 10,000 101,400 72,700 148,200 186,900 38,800 54,600
1 I I I I I I I I I I I I I I I I I
I I I I l I I I I l I I I I I I I 1 I
Equipment Repenement Fund
Page 4
EQUIPMENTDESCRIPTION 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
IBA
410 112 T TRK 4x4(ERA) 8
22,800 28,800
413 SEM LOADER(HRA) 1520900 32,400
SUBTOTAL HRA 20,900 22,800 28,800 32,400
WATER
500 1/2 T S-10 8 15,200 19,300 24,500
503 4X4 314T 8 21,900 30,100
507 3/4 T UTILITY 8 16,300 20,600 26,100
333 BACKHOE 20 134,800
539 PUMP TRAILER NONE
540 AIR COMPRESSOR 20 17,700
541 WACKERTAMPER NONE
WATER METER COMPUTER 10 34,900 46,800
P.W.COPIER(Water) 5 9,100 10,600 12,200 14,200
TELEPHONE SYSTEM 198,0009,300
SUBTOTAL 16,300 15,200 65,900 25,700 20,600 29,900 30,100 59,000 35,400 159,300 14,200
SEWER
502 1/2 TTRUCK 8 16,100 20,400
306 3/4 UTILITY TRK 8 17,700 22,400 28,400
530 JET VACTOR 15 164,600 256,300
S36 RODDING MACHINE 15 31,400
537 GENERATOR 25 11,900
538 OENERATOWI'RL 25
TELEPHONE SYSTEM 10 _ 8,000 9,300 ---
SUBTOTAL 29,600 164,600 16,100 8,000 31,400 22,400 20,400 9,300 284,700
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 56,300 ._ 85,100
SUBTOTAL 56,300 127,700 148,000 85,100 171,600 198,900
D
Equipment Replacement Fund
07/27/95
Page 5
TOTALS 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
OEN FUND VEH/EQUIP TOTAL ' 349,800 203,700 480,600 187,700 149,900 277,100 578,400 813,800 230,900 551,200 323,000 203,200 269,100 342,300 299,700 606,200 250,100 314,200 343,400 834,900
OEN FUND OTHER EQUIP TOTAL 22,200 35,000 274,700 78,000 40,800 472,000 339,800 15,600 198,600 60,900 92,700 220,7.00 267,300 101,400 72,700, 28,400 187,200 186,900 47,500 81,800
HRA TOTAL 20,900 22,800 28,800 32400
WATERT 1TA1. 16,300 15,200 65,900 25,700 20,400 29,900 30,100 59,000,' 35,400 159,300 14200
SEWER TOTAL 29,600 164,600 16,100 8,000 31,400 22,400 20,400 9,300 284,700
REFUSE TOTAL 56,300 127,700 148,000 85,100 171,600 198,900
GENERAL FUND TOTAL 372,000 238,700 755,300 265,700 190,700 749,100 918,200 829,400 429,500 612,100 375,700 423,900 536,600 443,700 372,400 634,600 437,300 501,100 390,900 916,700
HRA TOTAL. 20,900 22,800 28,800 32,400
UTILRYTOTAL 72,600 44,800 164,600 127,700 82,000 33,700 200,000 52,300 135,600 171,600 59,000 44,700 444,000 198,900 14,200
ALL FUNDS ANNUAL TOTAL 444,600 283,500 919,900 393,400 293,600 749,100 951,900 852,200 629,500 664,400 375,700 423,900 672,200 615,300 431,400 663,400 482,000 945,100 589,800 963,300
GENERAL FUND SALVAGE 79,300 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
NET GENERAL FUND 292,700 212,000 711,700 225,200 153,100 691,200 870,200 802,400 360,800 501,100 329,000 358,900 468,200 357,600 338,300 575,700 378,400 442,200 332,000 857,800
AVERAGES
Total & a¢o
FIRE EQUIP 20 YEAR AVERAGE: 1,679,600 84,000
FIRE ADMIN 20 YEAR AVERAGE: 265,400 13,300
POLICE EQUIP 20 YEAR AVERAGE 2,517,900 125,900
POLICE ADMIN 20 YEAR AVERAGE. 1,010,900 50,500
STREET EQUIP 20 YEAR AVERAGE: 2,431,100 121,600
BLDG MAINT EQUIP 20 YEAR AVERAGE. 91,400 4,600
ENGINEERING EQUIP 20 YEAR AVERAGE: 41,200 2,100
PUBLIC WORKS ADMIN 20 YEAR AVERAGE. 188,600 9,400
CITY HALL ADMIN 20 YEAR AVERAGE* 1,319,500 66,000
PARKS/FORESTRY EQUIP 20 YEAR AVERAGE: 848,000 42,400 r7
/ ,
GEN FUND VEH/EQUIP 20 YEAR AVERAGE 7,609,200 380,500 _ 1S�{ - `35`5 0 5 ' -' �'�'��
GEN FUND OTHER EQUIP 20 YEAR AVERAGE 2,784,400 139,200 // D D 0.1%, 'ZC -v� / 9 `j
GEN FUND TOTAL 20 YEAR AVERAGE: 10,393,600 519,700 QJJ y SO QO ti 'Y / 1
1
HRA 20 YEAR AVERAGE: 104,900 5,200
WATER 20 YEAR AVERAGE. 471,600 23,600
SEWER 20 YEAR AVERAGE- 586,500 29,300
REFUSE 20 YEAR AVERAGE 787,600 39,400
UTILITY VEH/EQUIP 20 YEAR AVERAGE 1,845,700 92,300
I I I I I I I I I I 3 I I t I I I I I I
EQUIPMENT & BUILDING
INVENTORY
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
5/9/95
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 PETE HEAVY RESCUE 190,000
105. 1993 CHEV CAPRICE 18,000
-
106. 1991 CHEV CAPRICE 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. 1992 FORD CROWN VICTORIA $20,000
201. 1995 FORD CROWN VICTORIA 20,000
202. 1994 FORD CROWN VICTORIA 20,000 -
203. 1992 FORD CROWN VICTORIA 20,000
204. 1993 FORD CROWN VICTORIA 20,000
205. 1995 FORD CROWN VICTORIA 20,000
206. 1993 FORD CROWN VICTORIA 20,000
207. 1990 CHEV CAPRICE 16,000
208. 1995 FORD CROWN VICTORIA 20,000
209. 1990 CHEV S-10 4X4 P.U. 14,000
210. 1994 CUSHMAN HAULSTER 13,000
212. 1991 CHEV LUMINA 14,000
213. 1994 PONTIAC GRAND PRIX SED 13,000
214. 1995 FORD TAURUS 16,500
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
I
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
5/9/95
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
305. 1985 FORD BOOM TRK 34,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
-
315. 1980 INTERNATIONAL WATER TRK 80,000
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
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
FLOAT VEHICLES
409. 1987 CHEV CELEBRITY WAGON
601. 1983 CHEV 1/2 T TRK
611. 1979 CHEV 1 T DUMP
II
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
5/9/95
CURRENT REPLACEMENT
UNIT # YEAR MAKE MODEL COST -
ENGINEERING DIVISION
700. 1986 FORD ENG. VAN $17,000
702. 1989 CHEV CELEBRITY 12,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
803. 1988 GMC 1 T 4X4 TRK 3,500
804. 1986 CHEV 3/4 T UTILITY 15,000
807. 1990 OLYMPIA ICE RESURFACER 45,000 -
809. 1988 GMC 1 T 4X4 TRK 15,500
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
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
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 10,000
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
III
CITY OF HOPKINS
VEHICLE/EQUIPMENT INVENTORY
5/9/95
CURRENT REPLACEMENT
UNIT # YEAR MAKE MODEL COST
HRA
410. 1986 DODGE 1/2 T TRK $11,000
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
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 1995
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 Highway7
Well #6 63,000
801 Highway 7
V
Location/Description Replacement Cost
Lift Station #1 - 21st 70,000
202 21st Avenue N.
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
Park Shelter - Burnes 27,000
201 Park Lane
Park Building - Central 70,000
101 17th Avenue S.
Park Building - Harley 12,000
108 Jackson Avenue S.
Park Shelter - Interlachen 9,000
220 Homedale Avenue
Park Building - Oakes 9,800
301 Tyler Avenue N.
Park Building - Valley 10,300
800 7th Avenue S.
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
VII