Travel Agent

You have been commissioned to plan a weeklong (8 days; 7 nights) vacation for a family of 5 (two adults and three children). The kids are ages 8, 5 and 2. Your budget is $5,000.

The family is interested in visiting the following locations:

1. Maui, Hawaii
2. Orland, Florida
3. New York City
4. Grand Canyon
5. Disney Cruise
6. San Diego, California

Your assignment is to choose from one of these destinations and plan their trip. You will need to find:

1. Round trip airfare (from either Sacramento - SMF or San Francisco - SFO)
2. Hotel Accommodations
3. Rental Car
4. Amusement Activities (schedule at least two days at a local attraction or theme park)

Input all information into an excel spreadsheet. Your spreadsheet should include the following headings and information:

• Name of Company/Vendor (ex: Southwest Airlines, Budget Rental Car)
• Website where you found your information (ex: hotels.com, travezoo.com)
• Price
• Details regarding the reservation (ex: flight number and times, cost per day of hotel room, cost per ticket of theme park)
• Total Cost of the Vacation

Tips for Spreadsheet:

• Font should be at least 12 size
• Change orientation to landscape
• Change margins to Narrow
• Click box to print gridlines
• Click on box to format cells & wrap text
• Change row height to fit information