ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
 Lakeland Tours Quote Analysis
3
4
Move Variables
65
Drive Time
Operator Margin Quote
5
Deadhead Mileage
10.02
6
Live Mileage
1#REF!
Operator Target Margin
7
Service Mileage
10.02
Margin Quote
#REF!
8
Number of Days
1
(Expense Cost + Operator Tg Margin)
Margin Ration#REF!
9
Price of Diesel
$6.50
10
Daily Rate Cost Quote
11
Live Mileage Rate
 $ 6.25
Operator Margin
#REF!
12
Deadhead Mileage Rate
 $ 6.25
Expense Cost of move
#REF!
13
Daily Coach Rate
$1,000.00
Total Cost of Move
#REF!
14
(Expense Cost + Coach Daily Rate)
Margin Ration#REF!
15
Driver Daily Rate
$300.00
16
Boost Driver Daily Rate
$0.00
Mileage Quote
17
Additional Driver Rate
$0.00
Operator Margin
#REF!
18
Mileage Quote
#REF!
19
Hotel Budget/Room
(Total Miles x's Mileage Rate)
Margin Ration#REF!
20
No. Rooms
21
Additional Expense
 $ 300.00
Target Quote
22
Coach Miles per gallon
5
Operator Margin
#REF!
23
Maintenance Allowance Per Mile
 $ 0.10
Expense Cost of move
#REF!
24
Customer Target Quote
25
Margin Ration#REF!
26
Cost Analysis
Mileage Analysis
GallonsCost of Fuel
27
Driver Pay
$300.00
Service Mileage Fuel Cost
0$1.30
28
Driver Supplemental
$0.00
Live Mileage Fuel Cost
#REF!#REF!
29
Maintenance Allocation.
#REF!
Deadhead Mileage Fuel Cost
0.4$2.60
30
Hotel & Additional Cost
 $ 300.00
Total Mileage Fuel Cost
#REF!#REF!
31
Fuel Cost
#REF!
Total Miles
#REF!Miles Quote
32
Total Cost
#REF!
33
Coach Daily Rate Total Cost
$1,000.00
Required Deposit
25%
34
25%
Deposit Amount for Op Margin
#REF!
35
25%
Deposit Amount for Mileage Quote
#REF!
36
Quote ID
25%
Deposit Amount for Daily Rate Cost Quote
#REF!
37
Departure Location
 25%
Deposit Amount for Mileage Quote
$0.00
38
Destination Location
39
Departure date
Mileage/ Op. Margin Difference
#REF!
40
Return date
Mileage/Daily Rate Cost Difference
#REF!
41
Margin/Daily Rate Cost Difference
#REF!
42
Notes:
43
44
45
46
47
48
49
50
Helpful Links
51
Goggle Maps
52
Priceline
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100