Service Total
Resume:
Tips
Total travelers: Length of trip (days):
*.
2.
Total trip cost: Cost per person:
Err:508 Err:508
3.
Add to Trip?
Gasoline Amount
Estimated total miles 690
Average miles per gallon
Yes
21
Average cost per gallon $4.12
Total vehicles 2
Total $270.74
Add to Trip?
Airfare Amount
Estimated cost per person
No
$220.00
Rental car $480.00
Total $1,800.00
Add to Trip?
Meals Amount
Estimated cost per meal
Yes
$10.00
Meals per day 3
Total $1,260.00
Add to Trip?
Lodging Amount
Average cost (per night) $110.00
Total nights 6
Yes
Total rooms 3
Valet service (per day) $20.00
Internet service (per day) $10.00
Total $2,520.00
Entertainment/Misc Total Cost Add to Total?
Concert No
$300.00
Boat rental Yes
$100.00
Surfboard rental Yes
$80.00
Incidentals Yes
$150.00
Total added to trip Err:508
Trip Planner
Summer Break
ips
Calculate both Gasoline and Airfare costs to determine
the best mode of transportation.
Plan the most cost effective trip by entering Yes/No in
the Add to Trip or Add to Total columns to add/remove
the amount from the Total Trip Cost.
In the Entertainment/Misc table, use a formula to
calculate total cost per person. For example, to calculate
concert tickets at $50 per ticket, enter
=50*TotalTravelers in the Amount column.
(TotalTravelers is a named cell that refers to the total
travelers in cell B6.)
Contact this candidate