Project+2

**A Whirlwind Trip!**
Welcome to the corporate world. What a busy week you have coming up! You will be traveling all across Canada and to the United States to give company presentations and complete other work related duties. Using the Internet, make the necessary airline reservations for your trip (see questions 1-6 below) and prepare an organized schedule using Excel of your airline flights. For each "question", provide the following information:(You are based in Edmonton) Calculate the cost to your company for the trip. Estimate your meals at $6 for breakfast, $10 for dinner and $14 for supper. Include all flight costs and hotel rooms as well. Create an Excel sheet to organize this information.
 * Departure(s) -Place(s) and time(s)
 * Name of Airline(s)
 * Name of Airports
 * Number of Stops
 * This Sunday, you will need to be in Victoria and you decide to take the earliest flight.
 * On Monday and Tuesday, you need to work in the branch office in Victoria. On Wednesday, you have to travel to Montreal but need the earliest flight as you will need time Wednesday evening to set up your materials for Thursday’s presentation.
 * Friday’s meetings will be over before noon. On Saturday and Sunday, you are registered for an international convention in Los Angeles, California and plan to get some rest and relaxation in the sun. You determine that a Friday afternoon flight to Los Angeles is preferred.
 * The following Tuesday morning, you have an appointment with the regional manager in Calgary and will spend Wednesday working in the branch office there. A Monday evening flight is fine.
 * [[image:http://www.saskschools.ca/curr_content/info10/module20/images/airplane2.gif width="128" height="128" align="right"]]Thursday evening, you are the guest speaker at a dinner banquet in Saskatoon and need to stay in Saskatoon on Friday until mid-afternoon. You prefer a Wednesday evening flight.
 * Friday evening you travel home to see your family for the weekend!

Create your travel agenda and budgets as Excel documents. Use appropriate formulas where applicable. (add your columns, multiply your meals, etc.) Review formulas if you forget!