|
-
Across the Entire top of your Spreadsheet you should have a title.
The title will say YOURNAME's Vacation Plan for DESTINATION.
Where YOURNAME is your name and DESTINATION is where you
are planning to go. Note: You must go somewhere that requires both
Travel and Lodging expense.
-
The next column should list the 5 days you plan to be on vacation.
You can use days of the week (Monday, Tuesday) or Dates, just as long
as it is clear which expenses belong to which days. The first Day
listed should be your Departure date and the last should be your date
of Return. (Hint: Start the dates in Column B)
-
In column A you should have a indented breakdown of your expenses that
uses the following Hierarchy:
-
Travel Expense - (Air, Train, boat, car). This is from your house and
return so include how you are getting to the airport. (Note: for the
purpose of this assignment you do not live walking distance from the
point of departure.) Divide and indent each business you need to have
money for (i.e. Marin Airporter, Alaska Airlines).
-
Lodging Expense - Hotel or other lodging expense for each night of
your vacation. (Note: No staying with relatives or tent camping on
the beach for this vacation, you must use lodging accommodations).
If you plan to stay at more than 1 hotel make a separate line for
each in the budget.
-
Dining Expense - This is what you plan to spend on meals. This
Category should be divided (and indented) to include - Breakfast,
Lunch, Dinner and Late Night Food.
-
Entertainment - Plan what you will be doing each day and give
yourself some funds to do these activities. You can sit on the beach
for no more than 2 days (but you need budget for drinks and rentals).
You must have activities on at least 2 days (helicopter ride, scuba
diving, etc.), each activity should have it's own line and be indented.
-
Each of the 4 Major Categories above must have a subtotal. There should be
a single underline between the items being totaled and the Subtotal. This
Sub total MUST use the excel sum formula. It may not be just a number you
entered into the cell.
-
On the last row of the worksheet you should include a total of expenses for
each day of the vacation. Your total should be a sum of your subtotals. Your
Totals should have a single line above then and a double line below them as
shown in the spreadsheet tutorial.
-
Add a column to the end of your spreadsheet that shows how much you spent
for each element of your vacation (Airfare, Lodging, Skydiving, Lunch etc.).
In this column, the last figure should be the total amount needed for the
Vacation.
-
Your format of your data should be enhanced to make it easy to read using
the techniques covered in the class: Shading, Borders, Font Size, Font Color,
Font Style. A good rule of thumb is you should change each of these at least
2 times in your output - 3 font colors etc.
-
Create a graphic which shows you how much you have budgeted to spend each day
of your vacation. The graphic should break down the overall cost into sub
categories of expense (Travel Lodging, Food, etc.).
|