| Worksheets for Trucks & Tractors |
|
|
| Fleet & Tire
Information |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Start Date: |
1/1/03 |
|
|
|
32nd's |
Miles |
Miles |
Usable |
Total |
Proj. CPM |
|
| Customer
Name: |
Dickwrench
Trucking |
|
|
|
Worn |
Driven |
per/32nd |
32nd's |
Proj. Miles |
Per/Tire |
|
| Contact Name: |
Dick Wrench |
|
|
Standard Tires |
|
1st
Inspection |
|
|
|
| Location #: |
101 |
|
|
Steer |
5.0 |
30,000 |
6,000 |
14 |
84,000 |
0.0033 |
|
| Address: |
101 Pasadena
Drive |
|
|
Drive |
9.0 |
30,000 |
3,333 |
26 |
86,667 |
0.0038 |
|
|
LA |
|
|
|
|
|
|
|
|
|
| Phone # |
000-000-0000 |
|
|
Standard Tires |
2nd
Inspection |
|
|
|
|
| Fax # |
000-000-0000 |
|
|
Steer |
#DIV/0! |
0 |
#DIV/0! |
14 |
#DIV/0! |
#DIV/0! |
|
| E-mail: |
cktire@tireprograms.com |
|
|
Drive |
#DIV/0! |
0 |
#DIV/0! |
26 |
#DIV/0! |
#DIV/0! |
|
| Standard
Tire Information |
|
|
|
|
|
|
|
|
|
|
| Brand: |
Brand A |
|
|
Standard Tires |
Final
Inspection |
|
|
|
|
| Str Size: |
11R22.5 |
Drv Size: |
11R22.5 |
Steer |
#DIV/0! |
0 |
#DIV/0! |
14 |
#DIV/0! |
#DIV/0! |
|
| |
|
|
|
Drive |
#DIV/0! |
0 |
#DIV/0! |
26 |
#DIV/0! |
#DIV/0! |
|
| |
Tread |
Original |
|
Price |
|
|
|
|
|
|
|
| |
Design: |
Tread Depth |
Price |
F.E.T |
Pr/32nd |
|
|
|
|
|
|
|
| Steer: |
Rib |
18 |
$250.00 |
$25.00 |
$
15.28 |
Test Tires |
1st
Inspection |
|
|
|
|
| Drive: |
Traction |
28 |
$300.00 |
$32.00 |
$
11.86 |
Steer |
3.5 |
30,000 |
8,571 |
15 |
128,571 |
0.0021 |
|
|
|
|
|
Drive |
6.0 |
30,000 |
5,000 |
26 |
130,000 |
0.0026 |
|
|
|
|
|
|
|
|
|
|
|
| Test
Tire Information |
|
|
|
|
|
|
|
|
|
|
| Brand: |
Brand B |
|
|
Test Tires |
2nd
Inspection |
|
|
|
|
| Str Size: |
11R22.5 |
Drv Size: |
11R22.5 |
Steer |
#DIV/0! |
0 |
#DIV/0! |
15 |
#DIV/0! |
#DIV/0! |
|
| |
|
|
|
Drive |
#DIV/0! |
0 |
#DIV/0! |
26 |
#DIV/0! |
#DIV/0! |
|
| |
|
|
|
|
|
|
|
|
|
|
| |
Tread |
Original |
|
Price |
|
|
|
|
|
|
|
| |
Design |
Tread Depth |
Price |
F.E.T. |
Per/32nd |
Test Tires |
Final
Inspection |
|
|
|
|
| Steer: |
Rib |
19 |
$250.00 |
$25.00 |
$
14.47 |
Steer |
#DIV/0! |
0 |
#DIV/0! |
15 |
#DIV/0! |
#DIV/0! |
|
| Drive: |
Traction |
28 |
$300.00 |
$32.00 |
$
11.86 |
Drive |
#DIV/0! |
0 |
#DIV/0! |
26 |
#DIV/0! |
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Start Test
Information & Follow-up Inspection Data |
|
| Standard Tires |
|
|
|
|
|
|
|
|
Date: |
1/1/03 |
Date: |
3/12/03 |
Date: |
|
Date: |
|
|
|
|
|
| Vehicle # |
101 |
Veh. Manuf: |
Mack |
Model |
|
|
|
|
|
|
| Wheel |
Begin |
Begin |
1st Inspection |
|
2nd Inspection |
|
Final Inspection |
|
|
|
|
|
|
| Position |
Miles |
32nds |
Miles |
32nds |
Miles |
32nds |
Miles |
32nds |
|
|
|
|
|
| LF |
|
18 |
|
13 |
|
|
|
|
|
|
|
|
|
| RF |
|
18 |
|
13 |
|
|
|
|
Miles Pr/32nd 1st
Inspection |
|
|
| LFO |
|
28 |
|
21 |
|
|
|
|
|
|
Steer |
6000 |
|
| LFI |
|
28 |
|
20 |
|
|
|
|
|
|
Drive |
3333 |
|
| RFO |
|
28 |
|
21 |
|
|
|
|
Miles Pr/32nd 2nd
Inspection |
|
|
| RFI |
|
28 |
|
20 |
|
|
|
|
|
|
Steer |
#DIV/0! |
|
| LRO |
|
28 |
|
18 |
|
|
|
|
|
|
Drive |
#DIV/0! |
|
|
| LRI |
|
28 |
|
17 |
|
|
|
|
Miles Pr/32nd Final
Inspection |
|
|
|
| RRO |
|
28 |
|
18 |
|
|
|
|
|
|
Steer |
#DIV/0! |
|
|
| RRI |
|
28 |
|
17 |
|
|
|
|
|
|
Drive |
#DIV/0! |
|
|
| St Miles |
0 |
|
30,000 |
|
|
|
|
|
|
|
|
|
| Dr Miles |
0 |
|
30,000 |
|
|
|
|
|
|
|
|
|
| Average Steer |
|
18.0 |
|
13.0 |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
| Average Drive |
|
28.0 |
|
19.0 |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Test Tires |
|
|
|
|
|
|
|
|
|
|
|
Date: |
1/1/03 |
Date: |
3/12/03 |
Date: |
|
Date: |
|
|
|
|
|
| Vehicle # |
102 |
Veh. Manuf: |
Mack |
Model: |
|
|
|
|
|
|
| Wheel |
Install |
Install |
1st Inspection |
|
2nd Inspection |
|
Final Inspection |
|
|
|
|
|
| Position |
Miles |
32nds |
Miles |
32nds |
Miles |
32nds |
Miles |
32nds |
|
|
|
|
| LF |
|
19 |
|
15 |
|
|
|
|
Miles Pr/32nd 1st
Inspection |
|
|
| RF |
|
19 |
|
16 |
|
|
|
|
|
|
Steer |
8571 |
|
| LFO |
|
28 |
|
23 |
|
|
|
|
|
|
Drive |
5000 |
|
| LFI |
|
28 |
|
22 |
|
|
|
|
Miles Pr/32nd 2nd
Inspection |
|
|
| RFO |
|
28 |
|
23 |
|
|
|
|
|
|
Steer |
#DIV/0! |
|
| RFI |
|
28 |
|
22 |
|
|
|
|
|
|
Drive |
#DIV/0! |
|
| LRO |
|
28 |
|
22 |
|
|
|
|
Miles Pr/32nd Final
Inspection |
|
|
| LRI |
|
28 |
|
21 |
|
|
|
|
|
|
Steer |
#DIV/0! |
|
| RRO |
|
28 |
|
22 |
|
|
|
|
|
|
Drive |
#DIV/0! |
|
| RRI |
|
28 |
|
21 |
|
|
|
|
|
|
|
|
| St Miles |
0 |
|
30,000 |
|
|
|
|
|
|
|
|
|
| Dr Miles |
0 |
|
30,000 |
|
|
|
|
|
|
|
|
|
| Average Steer |
|
19.0 |
|
15.5 |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
| Average Drive |
|
28.0 |
|
22.0 |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Return to directions |
|
|
|
|
|
|
|
| Test Results |
|
| Vehicle Cost Per 1000 Miles |
|
|
|
|
|
|
|
|
|
|
Standard
Tires |
|
|
|
First |
Date: |
Second |
Date: |
Final |
Date: |
|
|
|
|
|
Insp. |
3/12/03 |
Insp. |
1/0/00 |
Insp. |
1/0/00 |
|
|
Vehicle # |
101 |
|
Total |
|
|
|
|
|
|
|
|
|
Tires |
|
Cost per 1000 Miles Driven |
|
|
|
|
|
|
|
|
|
|
|
|
Steer Axle |
|
2 |
|
$6.55 |
|
#DIV/0! |
|
#DIV/0! |
|
|
Drive Axles |
|
8 |
|
$30.65 |
|
#DIV/0! |
|
#DIV/0! |
|
|
Total Tires |
10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Vehicle Cost Per 1000 Miles |
|
$37.19 |
|
#DIV/0! |
|
#DIV/0! |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Test Tires |
|
|
|
First |
Date: |
Second |
Date: |
Final |
Date: |
|
|
|
|
|
Insp. |
3/12/03 |
Insp. |
1/0/00 |
Insp. |
1/0/00 |
|
|
Vehicle # |
102 |
|
Total |
|
|
|
|
|
|
|
|
|
Tires |
|
Cost per 1000 Miles Driven |
|
|
|
|
|
|
|
|
|
|
|
|
Steer Axle |
|
2 |
|
$4.28 |
|
#DIV/0! |
|
#DIV/0! |
|
|
Drive Axles |
|
8 |
|
$20.43 |
|
#DIV/0! |
|
#DIV/0! |
|
|
Total
Tires |
10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Vehicle Cost Per 1000
Miles |
|
$24.71 |
|
#DIV/0! |
|
#DIV/0! |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Variance |
|
|
|
|
|
|
|
|
|
|
Total Vehicle Cost
Standard |
|
$37.19 |
|
#DIV/0! |
|
#DIV/0! |
|
|
Total Vehicle Cost
Test +/- |
$24.71 |
|
#DIV/0! |
|
#DIV/0! |
|
|
Difference = |
$12.49 |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|