HomeMy WebLinkAbout6. MANAGERS REPORT 03/20/2007
:Mount Prospect
Mount Prospect Public Works Department
INTEROFFICE MEMORANDUM
FROM: VEHICLE MAINTENANCE SUPERINTENDENT
TO: VILLAGE MANAGER MICHAEL E. JANONIS
DATE: MARCH 12,2007
SUBJECT: ACCEPT THE SUBURBAN PURCHASING COOPERATIVE (NWMC) B FOR
THE PURCHASE OF TWO 2008 FORD 4 WHEEL DRIVE CAB & CHASSIS
($69,900.00)
Background
In the current budget, there are funds available to replace unit 2716 and 2742. Both trucks are
1997 Chevrolet 1-ton dump trucks used by the Public Works Department Street/Buildings
Division for hauling small loads of material, supplies and equipment to job sites throughout the
Village. Both trucks are equipped with snow and ice removal equipment. These trucks are used
during snow removal operations to clear snow from public buildings, Village parking facilities,
and downtown business district.
Replacement Schedule
2716 and 2742 were purchased in 1997. The vehicle/equipment replacement schedule for 1-ton
dump trucks is 12 years or 50,000 miles. 2716 and 2742 have entered their 10th year of service
with 2716 having logged 40,752 miles and 2742 logging 25,466 miles.
Life Cvcle Cost Analvsis
Life cycle cost analysis has been completed for both 2716 and 2742. The life cycle cost analysis
is attached for your review. The optimum economic replacement point for 2716 has been
calculated at year 6 and the modified economic replacement point for 2716 has been calculated
at year 8. The optimum economic replacement point for 2742 has been calculated at year 3
and the modified economic replacement point for 2742 has been calculated at year 6.
Other Factors
These trucks have been moved up for replacement due to the problems with the General
Motors 6.5L diesel engines. Both trucks had the fuel injection pump and fuel injection module
replaced twice and 2742 has had the pump replaced three times. General Motors has
recognized the problem and has provided a 11 year/120,000 mile warranty on the injector
pump, but have not made the fuel injector pumps more reliable. With the warranty running out in
March 2008 we had moved the replacement up to 2007. Replacing the vehicles this year they
will still have warranty coverage and still have retail value when they are sold at auction.
In budget year 2006 we deferred the replacement due to the warranty troubles Ford Motor
Company was having with the 6.0L diesel engine. The new Ford cab and chassis being
proposed have a new 6.4L diesel engine which Ford has stated will resolve all the problems in
the past with the 6.0L diesel engine.
Subject: Accept Suburban Purchasing Cooperative (NWMC) Bid for Two 4-Wheel Drive Cab & Chassis
Date: March 12, 2007
Page 2 of2
Another factor is the clearing of snow from the top floor of the Village Hall Parking Facility.
These trucks will be equipped with a lower profile dump body and emergency lighting to
facilitate easy access to the upper deck without having to remove the emergency lighting when
it is necessary to haul snow from the parking facility.
Replacement Recommendation
It is my recommendation that replacements for 2716 and 2742 be purchased during the 2007
budget year.
Bid Recommendation
I am recommending the purchase of two (2) 2008 Ford F450 4-wheel drive, 16,000# GVWR,
cab and chassis with a 6.4L diesel engine per our specifications from the Suburban Purchasing
Cooperative (NWMC) award winner Currie Motors, Inc., Frankfurt, Illinois. I request that the
Village Board authorize the purchase of two (2) new 2008 Ford F450 4 wheel drive cab and
chassis at a cost not to exceed $69,900.00.
Funds for this proposed purchase are available in account 6707709-660115, in the amount of
$91,400.00, page 293, of the current budget. Funds remaining will be used to purchase the
necessary equipment to make the unit completely functional. The trucks being replaced will be
sold at the fall 2008 Northwest Municipal Conference auction.
z-11
James E. Guentner
~
-
Jg
Attachments
c:
Deputy Director of Public Works Sean Dorsey
H:\Administration\BIDS\RESUL TS\Cab and Chassis 4X4 2006.doc
Mount Prospect Public Works Department
Life Cycle Cost Analysis for 19971-Ton Dump Truck 2716
2 3 4 7 8 9 10
25000 23100 21200 19300 13600 11700 9800 7900
23100 21200 19300 17400 11700 9800 7900 6000
1900 1900 1900 1900 1900 1900 1900 1900
200 200 200 200 200 200 200 200
2.5 25 21.25 32 23.5 29.5 22.5 16
500 5000 4250 6400 4700 5900 4500 3200
37 1160 717 2275 460 2161 415 1120
Year
Value at Beginning of Year:
Estimated Value at Year End:
Actual Dollar Depreciation for Year:
Downtime Costs/Hour:
Hours DownlY ear:
Downtime Costs per Year:
Cost of Maintenance and Repairs per Year:
(including labor, parts, etc.)
Fuel Costs per Year:
329
Total Variable Costs:
2766
Total Lifetime Variable Costs:
2766
Miles:
1002
Cumulative Cost per Mile:
(Divide Total Lifetime Variable Costs by Mileage)
$
2.76 $
$3.00
..!!! $2.50
:i
..
Gl $2.00
0..
-
III
0 $1.50
u
Gl
~
<ll $1.00
:;
E
::l $0.50
u
$-
691
945
997
1014
642
756
1024
1112
8751
7839
7332
7812
11572
5809
7702
10717
11516
55512
66229
74068
81400
19328
30900
36709
4882
10188
15786
21481
29636
33365
36960
40752
2.36 $
$
1.87 I $
2.00 $
1.90 $
1.96 $
1.98 I $
1.71
2.00
t Denotes Modified Optimum Economic Replacement. I
r Denotes Optimum EGQnomic'Replacem~!Jt><, ~<I
Modified Optimum Economic Replacement Point Calculation
Purchase price of new vehicle:
Less: estimated value of new vehicle at Replacement:
Estimated depreciation of new vehicle:
Less: estimated value of present vehicle:
Net depreciation cost of new vehicle:
Estimated total miles on replacement vehicle at Replacement:
Estimated increase in new vehicle cost per mile
Cumulative cost per mile of present vehicle at Optimum Replacement:
Add: estimated increase in new vehicle cost/mile:
Cumulative cost per mile at Modified Optimum Replacement:
45,700
35,000
10,700
6,000
4,700
26,000
0.18
1.73
0.18
1.91
Mount Prospect Public Works Department
Life Cycle Cost Analysis for 19971.Ton Dump Truck 2742
4 5 6 7 8 9 10
25000 231001 212001 19300 17400 15500 13600 11700 9800 7900
23100 21200 19300 17400 15500 13600 11700 9800 7900 6000
1900 19001' >19001 1900 1900 1900 1900 1900 1900 1900
200 2001 .<4001 200 200 200 200 200 200 200
6 8.75 12.25 28 17 29 29.75 18 29 29
1200 5600 3400 5800 5950 3600 5800 5800
44 1855 517 770 1303 1001 405 1114
Year
Value at Beginning of Year:
Estimated Value at Year End:
Actual Dollar Depreciation for Year:
Downtime Costs/Hour:
Hours DownlYear:
Downtime Costs per Year:
Cost of Maintenance and Repairs per Year:
(including labor, parts, etc.)
Fuel Costs per Year:
358
Total Variable Costs:
3502
Total Lifetime Variable Costs:
3502
Miles:
1091
Cumulative Cost per Mile:
(Divide Total Lifetime Variable Costs by Mileage)
$
3.21 $
$3.50
oS! $3.00
:iE
; $2.50
n.
... $2.00
III
0
U
ClI $1.50
>
:;
"5 $1.00
E
:l
u $0.50
$-
2 3 4 5 6 7 8 9 10 11
YEAR
575
471
606
593
213
276
912
9930
6288
9076
9746
6714
8381
9726
23882
30170
39246
48992
55706
64086
73812
10528
13172
16575
20213
21389
22356
25466
$
2.291 $
2.90
2.27 $
2.371 $
2.42 $
2.60 $
2.87 $
I . Denotes MOdified Optimum E:ConomicReplacement. . .. .....,
I Denotes Optimum Economic Replacement. I
Modified Optimum Economic Replacement Point Calculation
Purchase price of new vehicle:
Less: estimated value of new vehicle at Replacement:
Estimated depreciation of new vehicle:
Less: estimated value of present vehicle:
Net depreciation cost of new vehicle:
Estimated total miles on replacement vehicle at Replacement:
Estimated increase in new vehicle cost per mile
Cumulative cost per mile of present vehicle at Optimum Replacement:
Add: estimated increase in new vehicle cost/mile:
Cumulative cost per mile at Modified Optimum Replacement:
45,700
36,500
9,200
6,000
3,200
7,300
0.44
1.87
0.44
2.31
Mount Prospect
Mount Prospect Public Works Department
INTEROFFICE MEMORANDUM
DATE:
MARCH 12, 2007
ACCEPT STATE OF ILLINOIS BID FOR THE PURCHASE OF ONE TRUCK CA
CHASSIS - $71,356.00
TO:
VILLAGE MANAGER MICHAEL E. JANONIS
FROM:
VEHICLE/EQUIPMENT MAINTENANCE SUPERINTENDENT
SUBJECT:
Backqround
In the current budget, there are funds available to replace unit 4528. 4528 is a 1992 International 53,000
lb. GVWR dump truck with snow and ice control equipment. This unit is used by the Public Works
Department maintenance crews to haul miscellaneous materials, such as asphalt, black dirt, sand, stone,
etc. to job sites throughout the Village. The unit is also equipped with a snowplow, underbody scraper,
and "V" type salt spreader for winter snow and ice control.
Replacement Schedule
4528 was purchased in 1991. The vehicle/equipment replacement schedule for large dump trucks is 15
years. 4528 has entered its 16th year of service and has logged 35,626 miles. In addition, the hour meter
on the engine has logged 3722 hours of operation (equivalent to 111,060 road miles). This vehicle
satisfies the Vehicle/Equipment Replacement Schedule criteria for replacement.
Life Cvcle Cost Analvsis
Life cycle cost analysis has been completed on 4528 and is attached for your review. The optimum
economic replacement point has been calculated at year 6. The modified economic replacement point
has been calculated at year 15.
Other Factors
The truck we are proposing to replace has some frame cracking showing this year due to the rust
between the two "e" channel frame construction. The cracks have been welded and reinforced to make
the frame as sound as it was when new. The rust will continue to grow because the truck is operated in
extreme wet and cold weather conditions where salt and other chemicals are needed to control the snow
and ice conditions. The new proposed truck chassis will have a single heavy duty "e" channel frame and
will eliminate the build up rust between the channels.
We are also proposing to install a pre-wetting system on this new truck. The pre-wetting system shall be
used to wet the salt with liquid calcium chloride as the salt is spread. The liquid calcium chloride
increases the salt melting action to a minus 5 degrees. With the pre-wetting system there will be
additional weight on the truck due to the "liquid salt" and storage tanks.
Replacement Recommendation
It is my recommendation that a replacement vehicle for 4528 be purchased during the 2007 budget year.
Bid Recommendation
I am recommending the purchase of one 2007 International 7400 Series, 53,000# GVWR cab and
chassis from the State of Illinois contract (PSD 4013471) award winner Prairie International Truck Sales,
Springfield, Illinois.
Accept State of Illinois Bid For The Purchase of One Truck Cab and Chassis
March 12, 2007
Page 2 of 2
I request that the Village Board authorize the purchase of one new 2007 International 7400 Series
53,000# GVWR truck cab and chassis at a cost not to exceed $71,356.00. Funds for this proposed
purchase are available in account no. 6707709 - 660115 ($116,700.00), page 293 of the current budget.
The remaining funds will be used for equipment (underbody snow plow, pre-wetting system, and hydraulic
components) to make the vehicle completely functional. The unit being replaced will be sold at the
NWMC auction in fall 2008.
I concur.
~ [J1~6
James E. Guenther
Glen R. Andler
Director of Public Works
JG
Attachment
c: Deputy Director of Public Works Sean Dorsey
H:\Administration\BIDS\RESUL TS\StatePurchase1TruckCab&Chassis2007 - 4528.doc
Mount Prospect Public Works Department
Life Cycle Cost Analysis for 1991 International Tandem Dump Truck 4528
Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
78000 73500 69000 64500 60000 55500 51000 46500 42000 37500 33000 28500 24000 19500 15000 10500
73500 69000 64500 60000 55500 51000 46500 42000 37500 33000 28500 24000 19500 15000 10500 6000
4500 4500 4500 4500 4500 4500 4500 4500 4500 4500 4500 4500 4500 4500 4500 4500
200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
3 15 31 15 25 12 66 67 25 64 88 32 67 28 77 25
500 3000 6100 3000 5000 2460 13100 13350 4950 12800 17600 6300 13300 5500 15300 5000
83 1020 1648 490 995 223 6393 2526 1516 3386 3786 1522 5739 2684 6519 2197
263 468 537 345 421 418 359 600 623 524 265 332 296 314 421 185
5548 9203 13016 8550 11141 7813 24618 21243 11814 21474 26439 12885 24101 13225 27017 12107
5548 14751 27766 36317 47458 55271 79889 101132 112946 134420 160858 173744 197845 211071 238088 250195
685 3360 6432 8408 10816 13206 15261 18694 22259 25256 26770 28669 30362 32158 34568 35626
Value at Beginning of Year:
Estimated Value at Year End:
Actual Dollar Depreciation for Year:
Downtime Costs/Mile:
Hours DownlYear:
Downtime Costs per Year:
Cost of Maintenance and Repairs per Year:
(including labor, parts, etc.)
Fuel Costs per Year:
Total Variable Costs:
Miles':
Total Lifetime Variable Costs:
Cumulative Cost per Mile: $ 8,10 $ 4,39 $ 4,32 $ 4,32 $ 4,391 $ 4.191 $ 5.23 $ 5,41 $ 5,07 $ 5,32 $ 6.01 $ 6,06 $ 6.52 $ 6,56 ~ 1$ 7,02
(Divide Total Lifetime Vanable Costs by Mileage)
'Hour/Mileage Conversion
$9.00
.! $8.00
:i $7,00
..
~ $6.00
....
~ $5,00
u
Q) $4,00
>
~ $3,00
:::l
E $2.00
:::l
U $1.00
$-
I Modified Optimum Economic Replacement Pointl
I Denotes Optimum Economic Replacement. I
Modified Optimum Economic Replacement Point Calculation
Purchase Price of New Vehicle:
LESS: Estimated Value of New Vehicle at Optimum Economic Replacement Point:
Estimated Depreciation Cost of New Vehicle:
LESS: Estimated Value of Present Vehicle:
Net Depreciation Cost of New Vehicle:
Estimated Total Miles on Replacement at Optimum Economic Replacement Point:
Estimated Depreciation Cost Cost/Mile of New Vehicle:
Existing Vehicle Cumulative Cost per Mile at Optimum at Optimum Economic Replacement Point:
ADD: Estimated Depreciation Cost/Mile of New Vehicle:
Cumulative Cost/Mile at Modified Optimum Economic Replacement Point:
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Years of Service
$116,000
$74,240
$41,760
$6,000
$35,760
14,000
$2.55
$4.19
$2.55
$6.74
Mount Prospc(."1;
~
Mount Prospect Public Works Department
INTEROFFICE MEMORANDUM
FROM:
VILLAGE MANAGER MICHAEL E. JANONIS
VEHICLE/EQUIPMENT MAINTENANCE SUPERINTENDENT
MARCH 12, 2007
ACCEPT STATE OF ILLINOIS BID FOR THE PURCHASE OF ONE TRUCK CAB
CHASSIS - $63,129.00
TO:
DATE:
SUBJECT:
Backqround
In the current budget, there are funds available to replace unit 4527. 4527 is a 1992 International 35,000
lb. GVWR dump truck with snow and ice control equipment. This unit is used by the Public Works
Department maintenance crews to haul miscellaneous materials, such as asphalt, black dirt, sand, stone,
etc. to job sites throughout the Village. The unit is also equipped with a snowplow, underbody scraper,
and "V" type salt spreader for winter snow and ice control.
Replacement Schedule
4527 was purchased in 1991. The vehicle/equipment replacement schedule for large dump trucks is 15
years. 4527 has entered its 16th year of service and has logged 32,100 miles. In addition, the hour meter
on the engine has logged 3734 hours of operation (equivalent to 112,020 road miles). This vehicle
satisfies the Vehicle/Equipment Replacement Schedule criteria for replacement.
Life Cvcle Cost Analvsis
Life cycle cost analysis has been completed on 4527 and is attached for your review. The optimum
economic replacement point has been calculated at year 8. The modified economic replacement point
has been calculated at year 14.
Other Factors
The current truck chassis has a double "c" channel frame construction and has rust between the two
channels. This rust will eventually cause the frame to crack. At the time when we purchased the truck in
1991 we had to have both "c" channels to meet the weight limits when the truck is loaded with salt during
snow and ice control operations. The new proposed chassis will have a heavier single "c" channel frame
construction eliminating the need for a double "c" channel and the rust between the channels.
Replacement Recommendation
It is my recommendation that a replacement vehicle for 4527 be purchased during the 2007 budget year.
Bid Recommendation
I am recommending the purchase of one 2007 International 7400 SFA Series, 35,000# GVWR cab and
chassis from the State of Illinois contract (PSD 4013471) award winner Prairie International Truck Sales,
Springfield, Illinois. I request that the Village Board authorize the purchase of one new 2007 International
7400 Series 35,000# GVWR truck cab and chassis at a cost not to exceed $63,129.00. Funds for this
proposed purchase are available in account no. 6707709 - 660115 ($97,500.00), page 293 of the current
budget.
Accept State of Illinois Bid For The Purchase of One Truck Cab and Chassis
March 12, 2007
Page 2 of 2
The remaining funds will be used for equipment (underbody snow plow, dump body. and hydraulic
components) to make the vehicle completely functional. The unit being replaced will be sold at the
NWMC auction in fall 2008.
James/~~j~~
Glen R. Andler
Director of Public Works
JG
Attachment
c: Deputy Director of Public Works Sean Dorsey
H:\Administration\BIDS\RESUL TS\StatePurchase1 TruckCab&Chassis2007 - 4527.doc
Mount Prospect Public Works Department
Life Cycle Cost Analysis for 1991 International Dump Truck 4527
Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
68000 64200 60400 56600 52800 49000 45200 41400 37600 33800 30000 26200 22400 18600 14800 11000
64200 60400 56600 52800 49000 45200 41400 37600 33800 30000 26200 22400 18600 14800 11000 7200
3800 3800 3800 3800 3800 3800 3800 3800 3800 3800 3800 3800 3800 3800 3800 3800
200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
3 8 19 8 18 28 23 14 19 39 45 48 22 88 28 25
500 1500 3800 1600 3600 5600 4500 2700 3700 7700 9000 9600 4400 17600 5600 5000
83 212 890 150 2430 1560 576 1201 677 2125 3545 2527 923 6907 1799 2197
646 395 256 193 453 503 201 431 257 647 226 194 353 241 497 453
5232 6115 8965 5951 10501 11691 9300 8346 8653 14510 16816 16369 9698 28836 11924 11675
5232 11347 20312 26263 36764 48455 57754 66100 74753 89263 106079 122449 132147 160983 172907 184583
1685 3946 5413 6516 9106 11983 13133 15601 17072 20772 22066 23178 25199 26578 29422 32014
Value at Beginning of Year:
Estimated Value at Year End:
Actual Dollar Depreciation for Year:
Downtime Costs/Mile:
Hours DownNear:
Downtime Costs per Year:
Cost of Maintenance and Repairs per Year:
(includin9 labor, parts, etc.)
Fuel Costs per Year:
Total Variable Costs:
Miles':
Total Ufetime Variable Costs:
Cumulative Cost per Mile: $ 3.10 $ 2.88 $ 3.75 $ 4.03 $ 4.04 $ 4.04 $ 4.40 1 $ 4.241 $ 4.38 $ 4.30 $ 4.81 $ 5.28 $ 5.24 ~ 1$ 5.88 $ 5.77
(Divide Total Lifetime Variable Costs by Mileage)
'Hour/Mileage Conversion
$7.00
~ $6.00
~
~ $5.00
n.
-
~ $4.00
()
~ $3.00
+l
l'll
:i $2.00
E
::s
() $1.00
$-
I Modified Optimum Economic Replacement Pointl
I Denotes Optimum Economic Replacement.. I
Modified Optimum Economic Replacement Point Calculation
Purchase Price of New Vehicle:
LESS: Estimated Value of New Vehicle at Optimum Economic Replacement Point:
Estimated Depreciation Cost of New Vehicle:
LESS: Estimated Value of Present Vehicle:
Net Depreciation Cost of New Vehicle:
Estimated Total Miles on Replacement at Optimum Economic Replacement Point:
Estimated Depreciation Cost CosUMile of New Vehicle:
Existing Vehicle Cumulative Cost per Mile at Optimum at Optimum Economic Replacement Point:
ADD: Estimated Depreciation CosUMile of New Vehicle:
Cumulative Cost/Mile at Modified Optimum Economic Replacement Point:
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Years of Service
$97,000
$62,000
$35,000
$7.200
$27,800
16,000
$1.74
$4.24
$1.74
$5.98