HomeMy WebLinkAbout9.b. 2017 Proposed Fire Department Equipment PurchaseEXECUTIVE SUMMARY
City Council Regular Meeting: May 16, 2017
AGENDA ITEM: 2017 Proposed Fire Department
Equipment Purchase
AGENDA SECTION:
New Business
PREPARED BY: Rick Schroeder, Fire Chief AGENDA NO. 9.b.
ATTACHMENTS: Equipment Evaluation Matrix & Rating,
Vehicle Images, Maintenance Reports,
New Equipment Quotes
APPROVED BY: LJM
RECOMMENDED ACTION: Motion to approve purchase of new hose truck.
Background
The council is asked to consider the expenditure to replace the fire department Utility 11
Hose Truck. This unit was purchased in 1992 and is primarily used for response to lay large
diameter hose at structure fires. Over the years this truck has been instrumental in
preventing back related injuries due to the large diameter hose that it carries and its ability to
roll up hose via the use of a hydraulic reel. Three years ago, the fire department changed its
large diameter hose to 5” hose which added a lot of weight to this vehicle. This also added
additional stress to the pump motor for the reel and to the chassis of the vehicle as well as
the safe operation of the hose reel. The hydraulics of this vehicle has been diminishing over
the years and the added weight at times causes firefighters to have to manually assist the
reel with the rolling up of the hose.
This vehicle would be replaced with a 2017 Ford F350 4x4 Regular Cab pickup from Midway
Ford on the state bid for a cost of $32,315.00. The fire department would take the existing
hose reel and have it repainted at Phil’s Body Shop for a cost of $3,947.26. This price also
includes the painting of the back of the pickup cab to match the hose reel as well as
additional areas on the truck to match the paint themes of existing fire department vehicles.
In addition, Macqueen Emergency group would install the LED lighting package and
emergency radio, install a new PTO and hydraulic pump and hydraulic hoses for the hose
reel, and they would also remove the hose reel body and wiring and mount it on the new
chassis for a total cost of $19,700.00. The total cost of this vehicle is $55,962.26, which is
consistent with the $55,000.00 CIP allocation for this project.
Summary
Staff is requesting council approval for the purchase of the above described vehicle.
1 2 3 4 5
AGE One point for each year of chronological age, based on in-service
date.
Light duty vehicles and pickups - 1 point for every 10,000 miles
Plow trucks - 1 point for every 15,000 miles
Off-road equipment over 150 hp - 1 point for every 1,000 hours
Off-road equipment under 150 hp - 1 point for every 500 hours
CONDITION This category takes into consideration body condition, rust,
interior condition, accident history and anticipated repairs.Like New Slight Wear / Few
Deficiencies
Moderate Wear /
Some Deficiencies
Significant Wear /
Multiple Deficiencies
Extreme Wear /
Numerous
Deficiencies
SERVICE TYPE 1, 2, or 3 points based on how the vehicle is used.Administrative or
Infrequent Use Frequent Light Duty Frequent Heavy Duty
REDUNDANCY
(CRITICAL
FUNCTION)
This category takes into consideration the vehicle function and
the effects of downtime on overall service levels.
More than one same
unit. Service levels
unaffected by
downtime.
One other same unit.
Service levels
slightly affected by
downtime.
One other similar
unit. Service levels
moderately affected
by down time
Only unit of this type,
but easily rentable.
Service levels
moderately affected
by downtime.
Specialized and not
rentable. Service
levels significantly
affected by downtime.
MAINTENANCE
AND REPAIR
Points are assigned based on the total M&R costs as a
percentage of the vechicle cost. One point for each 10% step
(i.e. 8 points if M&R is 80% of original cost, no limit)
Less than 20% of the
vehicle cost
Between 20% and
30% of the vehicle
cost
Between 30% and
40% of the vehicle
cost
Between 40% and
50% of the vehicle
cost
Greater than 50% of
the vehicle cost
RELIABILITY
Year-Round
Equipment
Less than 5 hours per
year
Between 5 and 10
hours per year
More than 10 hours
per year
RELIABILITY
Seasonal
Equipment
Less than 3 hours per
year
Between 3 and 6
hours per year
More than 6 hours
per year
Range Rating Number of Units Percent
< 20 Points Excellent 28 44%
20 - 25 Points Good 13 21%
26 - 30 Points Qualifies for
Replacement 6 10%
> 30 Points Needs Immediate
Consideration 16 25%
63
1, 3, or 5 points based on how often the vehicle is out of service
for repairs. This excludes routine maintenance and repairs due
to accidents.
Equipment Evaluation Matrix
Category Definitions
Points
MILES / HOURS
I:\City Clerk\Agenda Items\9.x. 2017 Proposed Fire Department Equipment Purchase - attach 1.2
Scoring Matrix
Vehicle
ID Description
Service
Type
Rating
Condition
Rating
Critical
Function
Rating Purchase Date Purchase Cost
Estimated
Salvage Value
(at time of
disposal)
Estimated
Lifespan
(years)
Estimated
Replacement
Cost
Years
Since
Purchase
Recommended
Replacement
Year
Age
Rating
Current
Mileage or
Hours
Mileage
Rating
Average
Annual
Mileage
9196 Utility 11 1 3 3 01/01/92 $41,887 $5,000 20 $85,000 25.4 2017 25 8,701 0 343
Total
Mainten
ance
Costs Total M&R%
M&R
Rating
Repair
Hours
Avg Repair
Hours per
Year Reliability Rating
Average
Annual
Maintenance
Costs
Total Gallons
of Fuel
Total Fuel
Costs
Estimated
Annual Fuel
Costs
Fuel
Economy
(mpg)
Annual
Insurance
Costs
Estimate
d Annual
Operatin
g Costs
Annual
Depreciation
(rounded up)
Total
Rating
Condition
Category
$10,566 25%2 66.25 3.0 1 $437 2195 $5,232 $206 4.0 $243 $887 $1,900 35 IV
Equipment Rating Report
Date 01/04/2017
Details Parts: 85515, 5W20Total Cost $79.57Activity003 - General Service
Date 12/05/2016
Details Replaced fuel shut-off on fuel tank. Parts: 490912053, 510232096Total Cost $88.92Activity475 - Equipment Repair
Date 11/01/2016
Details Repair rusted running board.Total Cost $59.63Activity475 - Equipment Repair
Date 10/15/2016
Details Replace spark plugs and wires. Parts: ANT30803, GBTGT2430HDDTotal Cost $190.87Activity480 - Equipment Maintenance
Date 02/02/2016
Details Tail light repair.Total Cost $39.75Activity475 - Equipment Repair
Date 01/07/2016
Details Also serviced portable fan. Parts: 85515, 5W20, 10W30Total Cost $97.86Activity003 - General Service
Date 12/29/2015
Details Repair tail light.Total Cost $39.75Activity475 - Equipment Repair
Date 12/23/2015
Details Replaced both batteries. Parts: optima batteryTotal Cost $349.50Activity480 - Equipment Maintenance
Date 03/12/2015
Details IGH Ford repair - truck runs rough. See attached.Total Cost $583.59Activity475 - Equipment Repair
Date 02/26/2015
Details EAM - Repair spool brake controler. See attached.Total Cost $1,429.12Activity475 - Equipment Repair
Maintenance Details
ID 9196DescriptionUTILITY 11ManufacturerFORD
Model F350 CUSTOMModel Year 1992Odometer8,701
Date:Tuesday, May 02, 2017Report Title:Mainenance Summary Rosemount
Date 01/07/2015
Details Parts: 5W20, 85515, 88174Total Cost $83.05Activity003 - General Service
Date 12/11/2014
Details Replace left side battery. Parts: SC34DUTotal Cost $268.65Activity480 - Equipment Maintenance
Date 09/24/2014
Details Top off antifreeze.Total Cost $18.93Activity480 - Equipment Maintenance
Date 02/05/2014
Details Replace left headlamp. Parts: 9007Total Cost $37.85Activity475 - Equipment Repair
Date 01/16/2014
Details Parts: 5W20, 85515Total Cost $53.80Activity003 - General Service
Date 07/16/2013
Details Repair flasher light.Total Cost $75.70Activity475 - Equipment Repair
Date 01/08/2013
Details Parts: 5W20, 88174, 85515Total Cost $57.65Activity003 - General Service
Date 04/11/2012
Details Odometer cluster repaired by IGH Ford. See attached.Total Cost $625.60Activity475 - Equipment Repair
Date 04/09/2012
Details Replace speed sensor. Parts: 970012Total Cost $81.98Activity475 - Equipment Repair
Date 01/17/2012
Details Parts: 85515, 5W20, 88174Total Cost $75.77Activity003 - General Service
Date 06/13/2011
Details Air tires.Total Cost $36.50Activity480 - Equipment Maintenance
Maintenance Details
ID 9196DescriptionUTILITY 11ManufacturerFORD
Model F350 CUSTOMModel Year 1992Odometer8,701
Date:Tuesday, May 02, 2017Report Title:Mainenance Summary Rosemount
Date 01/21/2011
Details Parts: 85515, 5W20Total Cost $50.32Activity003 - General Service
Date 07/28/2010
Details Gal leaking out of fan carburator. Removed and cleaned carburator, reinstalled and test ran.Total Cost $52.50Activity475 - Equipment Repair
Date 07/07/2010
Details Build mount and cover for positive pressure fan, and mount on side of truck. Parts: misc alluminum,latches from Boyer
Total Cost $740.90Activity485 - Fabrication & Welding
Date 04/19/2010
Details Replace brake booster check valve, replace idle speed motor. Parts: MTM80190, ECC734812Total Cost $99.53Activity475 - Equipment Repair
Date 01/25/2010
Details Replace muffler and tail pipes. Parts: GOE10301, GOEH200, GOE44811, GOE54874, 16525Total Cost $546.76Activity003 - General Service
Date 09/30/2009
Details Inver Grove Ford - ingnition and cooling system repair.Total Cost $1,335.38Activity475 - Equipment Repair
Date 08/03/2009
Details Check batteries and charging system. All OK.Total Cost $17.25Activity480 - Equipment Maintenance
Date 05/19/2009
Details Repair hyd. control valve handles. Replace control cable. Parts: FA2845-120P, 206301-FPTotal Cost $365.18Activity475 - Equipment Repair
Date 02/12/2009
Details Parts: 85552, 85515, 88174, 5W20, HYD OILTotal Cost $165.95Activity003 - General Service
Date 02/13/2008
Details Parts: 85515, 5W20 (6 qts)Total Cost $37.00Activity003 - General Service
Date 02/13/2007
Details Parts: 85515, 85552, 88174, 5W20, HYD OILTotal Cost $128.59Activity003 - General Service
Maintenance Details
ID 9196DescriptionUTILITY 11ManufacturerFORD
Model F350 CUSTOMModel Year 1992Odometer8,701
Date:Tuesday, May 02, 2017Report Title:Mainenance Summary Rosemount
Date 02/05/2007
Details Replace headlight bulb. Parts: BP9007Total Cost $19.89Activity475 - Equipment Repair
Date 01/26/2007
Details Adjust belts and tensioner bracket.Total Cost $24.00Activity480 - Equipment Maintenance
Date 01/22/2007
Details Replace water pump to manifold coolant hose.Total Cost $138.00Activity475 - Equipment Repair
Date 11/01/2006
Details Historical data from Manager PlusTotal Cost $2,471.00Activity499 - Miscellaneous
Date 02/13/2006
DetailsTotal CostActivity 003 - General Service
Maintenance Details
ID 9196DescriptionUTILITY 11ManufacturerFORD
Model F350 CUSTOMModel Year 1992Odometer8,701
Date:Tuesday, May 02, 2017Report Title:Mainenance Summary Rosemount
Total Cost $10,566