Filetype Excel XLS | Posted on 15 Aug 2022 | 3 years ago
Authentication
digital resources
132x Filetype XLS File size 0.09 MB Source: www.office.xerox.com
Sheet 1: Trip Planner
| Total travelers: | Length of trip (days): | Tips | |||||||
| 1 | 1 | 1 | Calculate both Gasoline and Airfare costs to determine the best mode of transportation. | ||||||
| Total trip cost: | Cost per person: | 2 | 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. | ||||||
| $0.00 | $0.00 | ||||||||
| 3 | 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.) | ||||||||
| Gasoline | Amount | Add to Trip? | |||||||
| Estimated total miles | 0 | Yes | |||||||
| Average miles per gallon | 21 | ||||||||
| Average cost per gallon | $4.12 | ||||||||
| Total vehicles | 1 | 4 | Business travelers can use the next tab to track their travel expenses. | ||||||
| TOTAL | $0.00 | ||||||||
| Airfare | Amount | Add to Trip? | |||||||
| Estimated cost per person | $0.00 | Yes | |||||||
| Rental car | $0.00 | ||||||||
| TOTAL | $0.00 | ||||||||
| Meals | Amount | Add to Trip? | |||||||
| Estimated cost per meal per person | $0.00 | Yes | |||||||
| Meals per day per person | 1 | ||||||||
| TOTAL | $0.00 | ||||||||
| Lodging | Amount | Add to Trip? | |||||||
| Average cost (per night) | $0.00 | Yes | |||||||
| Total nights | 1 | ||||||||
| Total rooms | 1 | ||||||||
| Valet service (per day) | $0.00 | ||||||||
| Internet service (per day) | $0.00 | ||||||||
| TOTAL | $0.00 | ||||||||
| Entertainment/Misc | Total Cost | Add to Total? | |||||||
| Concert | $0.00 | Yes | |||||||
| Boat rental | $0.00 | Yes | |||||||
| Surfboard rental | $0.00 | Yes | |||||||
| Incidentals | $0.00 | Yes | |||||||
| TOTAL | $0.00 | ||||||||
no reviews yet
Please Login to review.
