Mr. Harris' Page

Copied From
Home Page
© 2003 Gourarie

In this assignment, you will begin to research your trip costs. You will research transportation information, Lodging and Meals information, as well as activities you would like to do. You will format all of this information on an attractive and functional spreadsheet.  I anticipate this assignment will take 4 days.

You will need to include information about the following Special Requirements:

 

Passports, vaccinations, Visas, and State Department Warnings.
You need a passport - fill out an application and link it to your spreadsheet using a hyperlink.
Research and find out what vaccinations you will need for your trip.
Do you need a visa to enter your destination, and how do you get it?
Is your destination designated as unsafe by the State Department?

 

 

 

Assignment Requirements:

1. Use the supplied links for travel information.
2. Unless you are 25 years old, you cannot rent a car, and will need to rely on public transportation.
3. Check the Per Diem information so you know how much you can spend on lodging and meals.
4. Spending money is limited, and you should check the amount allowed for Entertainment and shopping.
5. Remember that there are three of you going, so all budgeted amounts should be multiplied by three.

 

 

 

 

 

 

 

 

 

Per Diem:
Per Diem means daily allowance. The US State Department puts out a regular bulletin about per diem rates for lodging and meals for every country in the world. A copy of the per diem listing can be found here, so you can look up your daily allowance for meals and lodging.

Excel Data


Record the following information on your Excel spreadsheet:

 

Airlines: Airline, Flight Numbers and Dates.
Price for each, and total for three.
Link to site where you received the quote.

Other Travel: Travel Dates.
Costs - each and total.
Name of train or trip if available.

 

 

 

 

 

 

 

Lodging: Name of hotel(s), and locations. (Cities.)
Dates you will be staying.
Total Cost (1 room or Qty*Room)
Calculating Lodging Costs:
Daily Lodging Rate X People X Total Days
Total Per Diem cost for Meals and Incidentals.  Total cost = Total Days X People X Cost per day

Entertainment and Shopping:
$700 per person - Entertainment
$300 per person - Shopping
Special Requirements, including:
Passport Requirements
Immunization Requirements
State Department Warnings.

 

 

 

 

 

 

 

Digital Communications