Part+5



Vacation Project, Part 5

You are required to design and complete a spreadsheet showing the daily expenses for each member going on vacation with you. You will need to show the expenses for transportation, meals, admission costs, spending money and the grand total for the trip. If you are driving to your destination, you will need to figure out how many gallons of gas will be used in order to figure the cost of your transportation. If you are using a plane, train, etc. you will need to include the cost for each person’s ticket as well as the cost for a rental car and gas while away.
 * // Be sure to keep track of the website(s) where you got your figures!  //**

You will need to approximate your meal costs as well. If at all possible, try to find local restaurants in which to “eat” while on vacation.

If visiting places that charge admission, include these costs as well. If you are going to the beach, to the city, etc. and there will be a charge for parking your car, include that as well.

Each person should have a set amount of spending money for each day. The amount is up to you, but this money would be only for expenses not already listed above such as souvenirs, sweatshirts, and so on. If you are going to the beach for the day, do you need as much spending money as if you are going to an amusement park?

as I stayed @ friend's house! || ** Friday ** || ** Saturday ** || ** Sunday ** || ** Monday ** ||  || ** total ** ||
 * REMINDER - no hotel costs
 * ** transportation to destination ** ||  ||   ||   ||   ||   ||   ||
 * gas for personal vehicle || $40  ||   ||  $40  ||  $40  ||   ||  $120  ||
 * tolls || $8.75  ||   ||   ||  $8.75  ||   ||  $17.50  ||
 * ** meals ** ||  ||   ||   ||   ||   ||   ||
 * Debra ||  ||  $20  ||  $30  ||  $13  ||   ||  $76  ||
 * Ginny || $13  ||  $20  ||  $30  ||  $13  ||   ||  $76  ||
 * Maureen || $13  ||  $20  ||  $30  ||  $13  ||   ||  $76  ||
 * Katie || $13  ||  $20  ||  $30  ||  $13  ||   ||  $76  ||
 * || $13  ||   ||   ||   || subtotal ||  $304  ||
 * ** admission costs ** ||  ||   ||   ||   ||   ||   ||
 * none ||  ||   ||   ||   ||   ||  $0  ||
 * ||  ||   ||   ||   || subtotal ||  $0  ||
 * ** shopping/other expenses ** ||  ||   ||   ||   ||   ||   ||
 * Debra ||  ||  $75  ||   ||   ||   ||  $75  ||
 * Ginny ||  ||  $50  ||   ||   ||   ||  $50  ||
 * Maureen ||  ||  $40  ||   ||   ||   ||  $40  ||
 * Katie ||  ||  $75  ||   ||   ||   ||  $75  ||
 * ||  ||   ||   ||   || subtotal ||  $240  ||
 * ** total for whole trip ** ||  ||   ||   ||   ||   || ** $682 ** ||
 * Maureen ||  ||  $40  ||   ||   ||   ||  $40  ||
 * Katie ||  ||  $75  ||   ||   ||   ||  $75  ||
 * ||  ||   ||   ||   || subtotal ||  $240  ||
 * ** total for whole trip ** ||  ||   ||   ||   ||   || ** $682 ** ||
 * ** total for whole trip ** ||  ||   ||   ||   ||   || ** $682 ** ||

Checklist:

I’ve/We’ve told/shown…. travel expenses

_ meal expenses _ meal expenses admission costs

_ spending money _ spending money

___ grand total