HomeMy WebLinkAbout3.A. 2004-2008 Equipment List
5.F\.
CITY OF SHAKOPEE
Memorandum
TO: Mayor and Council
Mark McNeill, City Administrator
FROM: Gregg Voxland, Finance Director
SUBJ: 2004 - 2008 Equipment List
DATE: August 11, 2003
Introduction & Background
Attached for Council discussion is the list of requested
capital equipment items for 2004 and projected items for
2005 - 2008 that are to be purchased from the Equipment
Internal Service Fund. Also attached are the vehicle
acquisition policy and the current equipment listing and
rental rates charged for the equipment.
The Equipment Fund was set up for funding larger items of
mobile equipment which cost over $10,000 and last more than
one year and are "mobile" meaning trucks loaders etc.
Council should discuss whether revisions to the acquisition
policy, and what items should be included is in order.
Potential changes could include raising the $10,000 mark and
whether the smaller items like squad cars that are bought
every year and small trucks should be included. The initial
purpose of the fund was to smooth out spikes in the General
Fund budget due to buying large items like fire trucks or
loaders. The smaller items like cars and small truck do not
cause much of a spike any more when the General Fund budget
has grown to 11 million dollars.
Gregg Voxland
Finance Director
2004 2005 2006 2007 2008
Police
Marked Patrol Cars $ 133,100 $ 104,000 $ 134,400 $ 78,000 $ 168,000
Marked 4 Wheel Drive 45,000
Automobiles (unmarked) 44,000 46,000
Fire
Truck - Pumper 450,000
Truck - Mini Pumper 225,000
Truck - Tanker 250,000
Truck - Heavy Rescue 400,000
Truck - Command Center 200,000
Zodiac Boat 18,000
Truck - Telesquirt 700,000
Utility/Personnel Vehicle
One Ton 4x4 With Grass Pak 60,000
Engineering
Pickup Truck 4X4 19,000 19,000
Street
Single Axle Dump Truck/Equip 115,000 115,000 120,000
Loader 165,000
Sign Truck 50,000
Pick-up Truck 45,000
Fork Lift 15,000
Park
Pick-up Truck 4x4 30,000
Pick-up 2x4 n. 35,000
Large Mower 90,000
Small Tractor 50,000
Tow Mower 16,000
Snow Removal Machine/Bobcat
Sewer Fund
Low Pressure Jetter 90,000
Storm Drainage Fund
Tanker 100,000
Screener/Pulverizer 40,000
Skid Steer 50,000
Large Tractor/Mower 80,000
Excavator 85,000
Street Sweeper 150,000
Recreation Fund
Ice Resurfacer 55,000
Building
Inspector Truck
$ 1 ,432,100 $ 678,000 $ 729,400 $1,122,000 $ 628,000
I Police I
2004: 4 Patrol Cars ($133,100). Replace three patrol cars
purchased in 2000. Increase squad car fleet with one
additional squad.
Marked 4 Wheel Drive Police Vehicle ($45,000). This would be
an addition to the fleet.
2005: 3 Patrol Cars ($104,000). Replace three patrol cars
purchased in 2001.
2006: 4 Patrol Cars ($134,400). Replace three patrol cars purchased
in 2002. Increase squad car fleet with one additional squad.
2007: 2 Patrol Cars ($78,000). Replace two patrol cars purchased in
2003.
2 Unmarked Cars ($44,000). Replace unmarked administrative
vehicle purchased in 2002 and add one additional unmarked
vehicle.
2008: 5 Patrol Cars ($168,000). Replace four patrol cars purchased
in 2004. Increase squad car fleet with one additional squad.
2 Unmarked Cars ($46,000). Replace two unmarked
administrative vehicles acquired in 2002.
I Fire I
2004: Truck - Telesquirt ($700,000). This unit will replace the
1985 pumper #9522. We moved this out from the 1999 budget.
This truck would be the first due unit from the new Station
3.
Zodiac Boat ($18, OOO) . This will replace the 1994 Zodiac
boat. This inflatable boat with motor is used for open water
and ice rescue with the motor removed.
Tanker Truck ($250,000). This unit will replace the 1986
Mack. This unit is used for rural areas that do not have a
water supply.
2005: Mini Pumper ($225,000). This unit will be an addition to
the fleet and will be housed at station (3). This unit will
be a F-450 series four door 4x4 truck. This unit will have a
pump and OSHA approved water supply.
One Ton 4x4 with Grass pak ($60, OOO) . This unit will
replace the current 1990 Ford 4x4 pick-up with grass pak.
This unit is for fighting grass fires, towing the rescue
boat, and hauling hoses and equipment.
2006: Heavy Rescue ($400,000). This unit will replace the 1986
rescue in the fleet right now. This unit is used for (fires,
auto accidents, medicals, high and low level accidents,
hazardous spills, etc.)
- -
- -
2007: Pumper ($450,000). This unit will replace the 1993 pumper.
This unit will have a foam system. This unit will possibly
be first unit out in station (4).
2008: Command Center ($200,000). This unit will be an addition to
the fleet and would be used as a command post. The truck
would house resources that are needed at chemical and fire
scene situations such as a chemical assessment library,
computers, phones, area land maps with topography, and work
areas.
I Engineering I
2004: No Anticipated Purchases
2005: Truck ($19,000). This truck will replace an existing truck
that will be 11 years old (PW#304, 1994 Chevrolet S 10). It
18 anticipated that due to age, mileage and maintenance
costs this vehicle will need to be replaced. The department
will continue to monitor this situation annually and adjust
the equipment list accordingly. Replacement of this vehicle
is for a 4-wheel drive extended cab pick-up truck.
This request is being made due to the amount of construction
activity in the MUSA area south of T.H. 169. The
engineering department does the inspecting and grading of
utilities and streets before a gravel street is constructed.
Depending on the City's ability to hire additional
engineering staff this replacement mayor may not be needed
in 2005.
2006: No Anticipated Purchases
2007: No Ant~cipated Purchases
2008: Truck ($19,000). This truck will replace an existing truck
that will be 10 years old (PW#305, 1998 Ford Ranger). It is
anticipated that due to age, mileage and maintenance costs
this vehicle will need to be replaced. The department will
continue to monitor this situation annually and adjust the
equipment list accordingly. Replacement of this vehicle 1S
for a 4-wheel drive extended cab pick-up truck.
I Street I
2004: 1.5 ton Truck with utility box ($50,000). This will be an
addition to the fleet and set up for sign maintenance.
2005: Single Axle Dump Truck ($115,000). Replace existing unit
#103 1993 IH 2554 dump truck.
Fork Lift ($15,000). Used fork lift due to loss of shared
use of SPUC machine.
2006: Single Axle Dump Truck ($115,000). Replace existing unit
#104 1995 Ford LN 8000 dump truck.
- -
- -
2007: Loader ($165,000). Replace existing unit #119 1990 Case
621C.
Single Axle Dump Truck ($120,000). possible addition due to
growth.
2008: 1 ton pick up 4x4 with plow ($45,000) . Replace unit #155
1998 Chevrolet IT.
I Park Maintenance I
2004: Small Tractor ($50,000). Replacement for unit #132 1995
John Deere 1070 tractor with mower.
Tow Behind 16' Mower ($16,000).
1 Ton 4x4 pick up ($30,000). Replacement for unit #158 1984
Chevy pick up cycled down from Fire Department.
2005: 1 Ton Truck Dual Wheel 2x4 ($35,000). Replacement for unit
#114 1993 Chevy C3500 1.5 ton truck. To be evaluated yearly.
2006: No Anticipated Purchase
2007: Large Mower ($90,000). Replace existing unit #133 1997 Toro
Groundmaster 580D Mower.
2008: No Anticipated Purchase
I Sewer Fund I
2004: No Anticipated Purchases
2005: No Anticipated Purchases
2006: No Anticipated Purchases
2007: Sanitary Sewer Jetter ($90,000). To replace existing unit
#126 1992 Low P.S.I. Ford LN 8000 Jetter.
2008: No Anticipated Purchases
I Stor.m Drainage Fund I
2004: Tanker ($100,000). Replacement for unit #115 1986 GMC TB
700 tanker/flusher.
Screener/pulverizer ($40,000). To be used for screening
street sweepings, leaves, and other material. Possible
joint purchase with another city or County.
2005: Large Skid Steer Loader ($50,000). possible addition due to
growth. Track machine for storm drain maintenance of ponds
and ditches.
2006: Large Tractor with Mower/Plow ($80,000). Replace unit 124,
1996 John Deere 6400.
2007: Small Track-ho ($85,000). An addition to the fleet if
research justifies purchase over rental. used for the
cleaning of ditches and ponds.
2008: Street Sweeper ($150,000). Second machine if growth
warrants purchase.
I Park and Recreation I
2004: No Anticipated Purchases
2005: Ice Resurfacer ($55,000). Typical life of an lce resurfacer
lS ten years. The current unit was put in operation in 1995.
Several factors can affect the life expectancy of a
resurfacer, including year-round verses winter only use,
condi tion of the water being used to resurface, and the
maintenance program. In this case, the resurfacer has been
used year-round, the hardness of the water being used has
promoted premature corrosion, and a documented maintenance
program for the unit was not started until 2000.
2006: No Anticipated Purchases
2007: No Anticipated Purchases
2008: No Anticipated Purchases
I Building I
2004: No Anticipated Purchases
2005: No Anticipated Purchases
2006: No Anticipated Purchases
2007: No Anticipated Purchases
2008: No Anticipated Purchases
City of Shakopee
VEHICLE ACQUISITION. USE & REPLACEMENT POLICY
I. PURPOSE & NEED FOR POLICY
This policy will provide uniform criteria for all City departments and operations in the acquisition, use and
replacement of vehicles. The City of Shakopee is dedicated to managing its resources in a fiscally responsible
manner. Therefore, a specific need should be demonstrated before a new vehicle is added to the City's fleet, and
every existing vehicle should be utilized to its greatest economic extent prior to replacement. The personal use of
City vehicles will be defined to ensure proper accounting and maximum efficiency of public purpose. The
acquisition of additional vehicles to the City's overall fleet and their replacement should be only as necessary to
allow the City to provide the services and perform the duties and responsibilities that are expected by the public
within budgetary constraints.
II. VEHICLE ACQUISITION POLICY
The many varied aspects of public service provided by the City of Shakopee requires the use of different types of
vehicles. These include:
Type A) vehicles used primarily to transport employees to/from locations of work activity (Le.
administrative and inspection vehicles);
Type B) vehicles necessary to assist City employees in performing their duties (Le. squad car, survey
vehicle, utility repair truck etc.);
Type C) vehicles used to actually perform a physical function (fire truck, road grader, dump truck, etc.).
The type of vehicle purchased shall be that which is determined to be most appropriate and cost effective for that
vehicle's function. However, all administrative/personnel transportation type vehicles shall be of the compact (Le.
Ford Contour, Chevrolet Corsica) or intermediate (Le. Ford Taurus, Buick Century) class. If a multi-passenger
vehicle (MPV) is deemed necessary to maximize personnel transportation capabilities, it shall be of the minivan
class for 5-7 seat belts and extended cargo van category for 8-10 seat belts.
A. Staff Transportation Vehicles
A vehicle shall be acquired by the City of Shakopee and assigned for staff transportation only if one or more of
the following occur.
1. If the City has deemed it appropriate to identify the driver and/or passengers as City employees on the
way to/from remote work locations or while performing their official duties.
2. a. If a specific job description results in an employee accumulating a minimum of 10,000
reimbursable miles per year on their personal vehicle traveling to/from alternate work locations,
or
b. If an operational division has a cumulative staff mileage reimbursement of 12,000 miles per year
or more.
1
3. If the City Administrator has determined that a vehicle should be provided as part of a position's
responsibility and meets the requirements of State Law.
4. A pooled vehicle shall be available at City Hall for multi-departmental use.
B. Job Assistance Vehicles
1. In certain circumstances, City provided and equipped vehicles are necessary to allow employees to
perform their job functions. In those circumstances, the City shall provide the specific required type
of vehicle and equip it with the necessary tools, equipment and devices necessary to allow a City
employee to perform their duties in an efficient and safe manner. These vehicles may be assigned
to specific employees or be made available through a pool concept within a division or department
on an operational basis determined to be most efficient by the department head(s).
C. Job Performance Vehicles
1. If a certain specialty type of vehicle is deemed necessary by the department to perform a specific
work task, it shall be justified in writing by the department head and approved by the City
Administrator subject to budgetary constraints. The method of acquisition (purchase, lease, rental)
shall be determined by the Finance Director.
2. Specialty pieces of equipment shall be shared interdepartmentally to the greatest extent possible
subject to seasonal/usage availability in order to avoid redundant acquisitions.
III. VEHICLE REPLACEMENT POLICY
A. Minimum Replacement Standards
City acquired vehicles should not be programmed or budgeted for replacement until they have met the
guideline replacement standards for the particular vehicle category (see attached). Similarly, vehicles should
not be replaced just because they have met the guideline replacement standards. Any deviations for early
replacement must be justified in writing by the Department Head and approved by the City Administrator.
B. Replacement Evaluation Process
Any City ( including Fire Department but excluding SPUC) vehicle which has been proposed for replacement
shall have a standard Vehicle Evaluation Form completed with a written recommendation by the City
Mechanic, Public Works Supervisor and Department Head delineating the justification for its replacement. A
sample Vehicle Evaluation Form is attached hereto.
C. Disposition of Used Vehicles
Before a vehicle is removed from the City's Fleet, the City Mechanic shall review all City current vehicles of
similar type and determine if it would be economically beneficial to switch with another existing vehicle before
disposal. All vehicles to be disposed of will be coordinated by the City Mechanic and Finance Director to
determine the most economical method and time. Vehicles may be retained for continued use by the City for a
period not to exceed 9 months from the date the new vehicle is placed into service. Vehicles removed from
service in the Police and Fire Departments and those vehicles that regularly operate out of the city limits, shall
be evaluated for reliability to see if they should be retained for local use and thereby minimize the acquisition of
new vehicles. An example of this is a car removed from squad duty that is serviceable for non-emergency use
and assigned to a building inspector. Assignment/reassignment of vehicles shall be determined by the City
Administrator.
IV. PERSONAL USE OF CITY VEHICLES
2
City vehicles are not available for take home use by City employees except for the following situations:
A. Assigned Take-Home Vehicles
City employees, whose position responsibilities require them to respond directly to a work related situation from
their residence outside of normal work hours, will be allowed to use a City vehicle (Type A or B) to commute
to/from their place of residence under the following conditions:
1. The employee must live in the City of Shakopee
2. The vehicle is not available for other than minimal personal use while performing their job duties
and/or commuting to/from their place of residence.
3. The Chief of Police may use an unmarked car.
4. Two officers of the Fire Department may use a light duty vehicle for commuting use including their
regular place of employment if it is within 15 miles of the City of Shakopee.
5. Job performance specialty type vehicles (Type C) shall not be made available for personal use or
commuting.
6. For scheduled leaves of absence by the designated employee exceeding 1 workday, the City vehicle
shall be made available for pool use and remain at the employee's normal place of work.
B. Occasional Take-Home Vehicles
City employees may occasionally use a City vehicle (Type A or B) to travel to/from the employee's residence
under the following conditions.
1. Police officers on duty may take cars home in the city at the discretion of the Police Chief.
2. If the City employee has scheduled City business away from their normal work station and the
number of miles traveled, or time needed to conduct the business, will be minimized if the employee
uses a City vehicle to commute to/from the employee's residence before/after traveling to the place
of business.
3. The vehicle is not available for other than minimal personal use beyond commuting to/from the place
of residence.
V. CITY USE OF PERSONAL VEHICLES
A. Mileage Reimbursement
1. All employees of the City will be paid mileage for use of their personal vehicles and reimbursed for
all related legal parking costs while conducting official City business. The mileage rate will be the
maximum reimbursement rate allowed by the IRS for non-taxable income. However, employees are
encouraged to use available City vehicles whenever possible while conducting official City business.
2. Normal personal commuting mileage from home to work or work to home is not reimbursable. If an
employee uses a personal vehicle to travel to a work responsibility on the way to or from work,
normal personal commuting mileage shall be deducted from the total trip mileage used to calculate
the reimbursement.
3. Employees must have liability insurance coverage on their vehicle and may be required to furnish
proof of insurance to the city.
3
B. Monthly Allowance
The City Administrator and the Public Works Director may receive a monthly allowance as set by the City
Council. A monthly car allowance is subject to the following conditions:
1. The monthly allowance covers all business miles driven within the seven-county metropolitan area.
Any travel outside this region in a personal vehicle will be reimbursed according to Section VA
2. City vehicles may be used:
a. In an emergency work situation when the personal vehicle is not available,
b. For work related off road driving when the personal vehicle would be subjected to conditions
above normal wear and tear on a vehicle,
c. In severe adverse weather conditions,
d. Where the department head must travel by vehicle outside the seven-county metropolitan area
3. The employee has the option to decline the mileage allowance and claim reimbursement under V.A.
above.
C. Other Costs
Employees are responsible for all costs related to personal vehicle ownership and operation. The City is
responsible for all costs related to installation and maintenance of City equipment in the vehicles which is
necessary in order for the employee to perform the position's functions. The City is also responsible for all costs
related to the removal of such equipment and to the restoration of the vehicle caused by such removal.
VI. VEHICLE IDENTIFICATION
A. Color/City Logo
All City vehicles shall be licensed and marked as appropriate for their specific use as follows:
1. All Administrative transportation vehicles (Type A) shall be of compact or intermediate size, and have
the City's name prominently displayed on the side door panels. The City's official logo will be applied
when it is beneficial to have it displayed to the public as determined by the Department Head.
2. All specialty type vehicles (Type B or C) shall have the City name prominently displayed on the door
panel or other highly visible location.
3. Marked police squad/patrol vehicles shall be white and shall display the City name and vehicle
number, and it shall contain lettering identifying it as a police/law enforcement/emergency vehicle.
The color of unmarked police vehicles will be at the discretion of the Police Chief as necessary to
minimize their detection as a law enforcement vehicle.
4. Fire Department vehicles shall be red with the City's name and vehicle number and shall contain
lettering identifying it as a fire response emergency vehicle prominently displayed on the side door
panels.
5. All other vehicles purchased new shall be manufacturers standard medium blue in color or if blue is
not available as a standard color, white shall be used unless there is no color choice available.
Vehicles shall not be repainted solely to change the color.
VII. RESPONSIBILITY
4
Departments with assigned vehicles are responsible for the maintenance and cleaning of such vehicles.
Vehicles may be professionally cleaned once per year. The cost of cleaning a vehicle before it is disposed of or
turned over to another department is the responsibility of the department that had prior use of the vehicle
The City Administrator is responsible for the enforcement of this policy. City employees may not deviate from
the policy unless they have written approval from the City Administrator.
Revised 11/25/96
n :\budget\departm\vehicle3
5
Vehicle Categories
Guideline Replacement
Standards
Aae or Miles/Hours
Administrative 10 100,000
Sedan 10 100,000
Station Wagon 10 100,000
Compact Pickup 10 100,000
Vans 10 100,000
Squad car - squad duty 4 80,000
Specialtv
Light Duty
Suburban 10 100,000
Pickup 1/2 - 3/4 ton 10 100,000
Utility 10 100,000
Medium Duty
Utility Truck 10 100,000
4x4 pickup 10 100,000
truck - 1 to 1 .5 ton 10 100,000
Skid steer loader 10 4,000
Fire grass rig 15 N/A
Mowers - riding 10
Tractor 15
Heavy duty
Dump trucks 12 80,000
Front end loader 15 6,000
Road grader 15 6,000
Alley grader 15 6,000
Backhoe 20 6,000
Sweeper 10 5,000
Jetter 20 8,000
Tanker/flusher 20 8,000
Sewer Vac 20 N/A
Pumper 20 N/A
Aerial truck 20 N/A
6
VEHICLE EVALUATION FORM
Public Works Department - Equipment Maintenance Section
Unit# Serial # Department
Year Make Model
Vehicle Description
Special Eqpt/Attachments
Primary Use
Current Mileage Hour
s
Last Year Miles Hour
s
Avg. Annual Miles Hour
s
Purchase Price (includes special equipment)
Estimated Replacement Cost (includes special equipment)
Estimated Average Life years/hours/miles
ANALYSIS OF UNIT
YEAR
Annual Operating Costs
Cumulative Operating Costs
Annual CPM or CPH
Life- To-Date CPM or CPH
Average CPM or CPH for
vehicle class
% Downtime - Annually
% Downtime - Cumulative
%Downtime by Class
Body, mechanics and/or chassis condition comments:
I Prepared by IReviewed by I
7
IS Rent for 2004
Est. Replace. ANNUAL Monthly
PW Cost Salvage Cost @ RENTAL Rental
Number Asset # DescriDtion VIN DeDt. New/Used Value 5% RATE Rate
A B C E F K N
304 380 1994 Chev S10 PU 3079 ENGIN 10,231 1,500 13,847 1,385 115
305 532 1998 Ford Ranger 3626 ENGIN 17,665 1,500 24,997 2,500 208
301 608 1999 Ford Ranger 7614 ENGIN 17,104 1,500 24,157 2,416 201
303 722 2001 S10 4X4 5527 ENGIN 19,000 1,500 27,000 2,700 225
306 723 2001 S10 4X4 7623 ENGIN 19,000 1,500 27,000 2,700 225
302 869 2002 GMC Sonoma 4X4 1764 ENGIN 18,000 1,500 25,500 2,550 213
TOTAL ENGIN 101,001 142,501 14,250 1,188
9521 147 1974 Mack fire trk 1588 Fire 105,955 4,000 234,399 11,720 977
9522 126 1985 Hend. Fire trk 6384 Fire 164,350 4,000 324,700 16,235 1,353
9510 154 1986 Spartan fire rescue 5961 Fire 156,465 4,000 308,929 15,446 1,287
9560 214 1988 Mack fire tanker 1298 Fire 107,735 4,000 211,471 10,574 881
9572 271 1990 Ford 1 T 4x4 + grass pak 9105 Fire 31,066 2,500 59,631 2,982 248
9511 282 1991 Chev Step Van 3501 Fire 35,000 3,000 67,000 3,350 279
9523 310 1992 Fire pumper 6396 Fire 227,676 4,000 451,351 22,568 1,881
9580 383 1 994 Simon Duplex - Aerial (Mack) 0029 Fire 548,776 100,000 997,552 49,878 4,156
345 1994 Boat Motor & Trailer (Zodiac) 0293 Fire 8,318 - 16,637 832 69
9570 449 1996 Chev Pickup 5065 Fire 37,722 1,500 55,083 5,508 459
9520 535 1998 Pierce Pumper 0653 Fire 340,227 10,000 670,454 33,523 2,794
9524 536 1998 Pierce Pumper 0659 Fire 340,227 10,000 670,454 33,523 2,794
9593 606 Ice Angel Air Boat & Trailer 99trl Fire 50,541 3,000 72,812 7,281 607
9591 603 1999 Dodge 4X4 0098 Fire 31,712 3,000 44,568 4,457 371
9592 656 2000 Ranger 7936 Fire 22,000 1,500 31,500 3,150 263
9590 2003 Dodge Ram 4X4 5624 Fire 19,000 2,000 26,500 2,650 221
TOTAL FIRE 2,226,769 4,243,040 223,675 18,640
188 234 1988 GMC 3500 - 1T PU 4x4 + Equip 0360 Gov Bldg 15,600 3,000 20,400 1,020 85
TOTAL GOV BLDG 15,600 20,400 1,020 85
202 384 1994 Chev 3/4T Suburban 4X4 9735 Insp't 8,000 1,500 7,700 2,567 214
200 533 1998 Ford Ranger 3625 Insp't 17,631 1,500 24,946 2,495 208
201 657 2000 Ford Ranger 4284 Insp't 17,100 1,500 24,150 2,415 201
204 721 2001 Chev S1 0 4X4 5549 Insp't 19,000 1,500 27,000 2,700 225
206 868 2002 GMC Sonoma 4X4 0042 Insp't 18,000 1,500 25,500 2,550 213
TOTAL INSP 79,731 109,296 12,726 1,061
158 120 1983 Chev 3/4T 4x4 Red 1763 Park 4,000 2,000 3,000 600 50
156 251 1989 Chev S1 0 PU 3083 Park 9,061 1,500 12,092 605 50
114 338 1993 Chev C3500 1 .5T 7002 Park 25,799 2,500 36,198 3,620 302
139-2 381 1994 Turf Sweeper - Toro 5400 0112 Park 11 ,467 1,000 19,067 1,271 106
132 412 1995 JD 1070 Tractor w/mower 1037 Park 18,972 1,000 27,458 2,746 229
133 710 1997 Toro Groundmaster 580D 0305 Park 57,539 5,000 81,308 8,131 678
145 537 1998 GMC Sierra Truck 5505 Park 36,039 2,500 51 ,559 5,156 430
157 604 1990 Ford Super Duty W/Bucket 4713 Park 25,187 1,500 29,984 5,997 500
122 665 2000 ISU Garbage Truck 6308 Park 55,000 5,000 77,500 7,750 646
129 706 2000 Toro 580D Mower 0131 Park 59,853 5,000 84,780 8,478 706
161 733 2001 Ford F350 - 1 Ton w/Plow 9943 Park 22,790 2,500 31,685 3,169 264
154 2003 Melroe S-185 Hi-Flow Park 21,150 19,000 3,208 3,208 267
135 783 2002 JD 1445 Mower 2304 Park 25,626 1,000 37,439 3,744 312
147 2003 Melroe S-185 Hi-Flow 3418 Park 20,580 19,000 2,609 2,609 217
111 727 2002 Sterling Acteera w/Hooklift Sys 3708 Park 102,735 4,000 175,786 11 ,719 977
134 892 2002 JD 5420 Tractor 6395 Park 43,307 1,000 63,961 6,396 533
143P 866 2002 Graco Stripper/DriverfTrailer BA239 Park 12,120 800 17,380 1,738 145
163 865 2002 Ford F350 4X4 W/Plow 1195 Park 25,295 2,500 35,443 3,544 295
152 898 2002 JD 1445 Park 29,818 1,000 43,727 4,373 364
162 2003 JD Gator 1931W Park 7,991 500 11,487 1,149 96
TOTAL PARK 614,328 845,668 86,000 7,167
400 415 1996 Ford L TD CR VIC Squad 8183 Admin 3,000 1,000 3,000 1,000 83
TOTAL ADMIN 3,000 3,000 1,000 83
870 170 1987 Chev Suburban (squad) 9645 Police 17,384 4,000 22,075 1,104 92
970 858 1997 Ford Contour 0485 Police 6,000 1,500 5,400 1,800 150
994 859 1999 Chev Malibu 3594 Police 9,275 1,500 10,094 2,019 168
001 653 2000 Ford Crown Vic 8586 Police 25,000 1,500 28,500 7,125 594
002 654 2000 Ford Crown Vic 8587 Police 25,000 1,500 28,500 7,125 594
003 655 2000 Ford Crown Vic 8588 Police 25,001 1,500 28,501 7,125 594
004 712 2000 Ford Crown Vie 2283 Police 25,000 1,500 28,500 7,125 594
011 724 2001 Ford Crown Vic 1039 Police 25,185 1,500 28,722 7,181 598
012 725 2001 Ford Crown Vic 1040 Police 25,185 1,500 28,722 7,181 598
013 726 2001 Ford Crown Vic - Dk Blue 1038 Police 25,185 1,500 28,722 7,181 598
015 860 2001 Ford Taurus 9603 Police 11 ,235 1,500 12,544 2,509 209
021 862 2003 Ford Crown Vic 4393 Police 33,000 1,500 38,1 00 9,525 794
022 863 2003 Ford Crown Vic 4394 Police 33,000 1,500 38,100 9,525 794
023 fund.~ m~DlS1RibUBUltgWn Vic 4395 Police 33,000 1,500 38,100 8/g;tJ9B~ :54 AM 794
2003 Ford Crown Vic 0802 Police 34,000 1,500 39,300 9,825 819
IS Rent for 2004
Est. Replace. ANNUAL Monthly
PW Cost Salvage Cost @ RENTAL Rental
Number Asset # Descriotion VIN Deot. New/Used Value 5% RATE Rate
A B C E F K N
2003 Ford Crown Vic 0803 Police 34,000 1,500 39,300 9,825 819
TOTAL POLICE 386,450 443,180 105,698 8,808
126 307 1992 Ford LN8000 Jetter/Rootcutter 7540 Sewer 78,776 4,000 133,858 8,924 744
144 348 1993 Ford high pres. jetter 1054 Sewer 56,286 3,500 95,000 6,333 528
128 658 2000 Ford 1.5 T P/U w/Hoist/Plow 9337 Sewer 45,000 2,000 76,750 5,117 426
140 891 2002 Versa Vac 1000PD wrrrailer 4441 Sewer 60,286 3,000 102,501 6,833 569
TOTAL SEWER 240,348 408,109 27,207 2,267
115 233 1986 GMC TB 700 Tanker/Flusher 0737 Storm 52,402 4,000 87,703 5,847 487
124 894 JD 6400 Tractor w/mower & plow 19S 787 Storm 62,309 5,000 104,040 6,936 578
127 454 1996 Broce Side Broom Sweeper 8135 Storm 27,528 5,000 36,292 3,629 302
111 870 Giant Vac Leaf Collection System Storm 30,507 5,000 40,761 4,076 340
151 2003 Elgin Pelican Sweeper Storm 127,653 20,000 171 ,480 17,148 1 ,429
TOTAL STORM 300,398 440,275 37,636 3,136
160 252 1989 CAT #140G Road Grader 1865 Street 128,521 20,000 204,912 13,661 1,138
119 269 1990 Loader - Case 1442 Street 88,616 15,000 140,078 9,339 778
138 283 1991 ChevS10 9495 Street 9,571 1,500 12,856 1,286 107
108 305 1992 Ford LN 8000 dump trk & equip 1917 Street 65,348 4,000 110,359 7,357 613
121 306 1992 Loader - Case 621 7752 Street 90,428 15,000 143,249 9,550 796
123 343 1993 Alley Grader - Gehl 7478 0330 Street 50,295 5,000 95,590 4,780 398
103 346 1993 IHC 2554 Dump 6223 Street 70,809 4,000 119,915 7,994 666
104 411 1995 Ford LN 8000 Dump Truck 2437 Street 72,203 4,000 122,355 8,157 680
142 451 1996 Buthling Asphalt Roller 1650 Street 16,071 2,000 26,124 1,742 145
106 501 1998 Ford Single axle Dump Truck 0402 Street 62,547 4,000 105,457 7,030 586
107 502 1998 Ford Single axle Dump Truck 0403 Street 62,547 4,000 105,457 7,030 586
155 534 1998 1 Ton Chev Pickup with plow 2344 Street 24,840 2,000 35,260 3,526 294
117 538 1998 GMC 3500 HD 2x4 Trk w/box 1517 Street 23,816 2,500 33,224 3,322 277
980 531 1998 Ford L TD CR VIC Squad 9737 Street 3,000 1,500 1,800 900 75
105 667 2000 Sterling Dump Trk 1918 Street 90,000 4,000 153,500 10,233 853
102 669 2000 Sterling Dump Trk 1919 Street 90,000 4,000 153,500 10,233 853
159 659 2000 Inti 4700 LP Paving Trk 1937 Street 88,000 4,000 150,000 10,000 833
125 652 2000 GMC 3500 4x4 W/Plow & Lift 9591 Street 31,000 2,500 51,750 . 3,450 288
130 663 2000 Bandit Brush Chipper 250XP 5313 Street 24,770 2,000 35,155 3,516 293
109 717 2001 Sterling Dump 3318 Street 95,000 4,000 162,250 10,817 901
118 749 2001 Tenco TE 172 LM Snow Blower Street 66,468 8,000 98,349 4,917 410
120 896 2002 Case 621 D Loader W/plow & wi 3909 Street 136,000 15,000 223,000 14,867 1,239
101 782 2002 Sterling L8500 8314 Street 100,900 4,000 172,575 11 ,505 959
131 893 2002 JD 4710 Tractor 4wd w/cab 0766 Street 26,927 1,500 38,891 1,945 162
2003 Ford F350 4X4 w/plow 5015 Street 29,000 2,500 41,000 2,050 171
TOTAL STREET 1,546,676 2,536,606 169,206 14,101
700 414 Ice Resurfacer Rec Fund 45,000 2,000 65,500 6,550 546
702 309 1992 GMC Sonoma P/U 7331 Rec Fund 10,834 1,000 15,251 1,525 127
701 720 2001 Ford Windstar 3dr LX Minivan 3768 Rec Fund 19,533 1,500 27,800 2,780 232
TOTAL REC. 75,367 108,551 10,855 905
GRAND TOTAL 5,589,669 9,300,626 689,275 57,440
Isfund.xls12.03List-04Budget 8/11/039:54 AM