|Sloane Financial Planners M E M O R A N D U M To: Assistant Manager, Travel From: Wendy Takeoff, Manager – Travel Department Date: September 17, 2019 Subject: Travel input for the site location of our new regional office As you know, the Site Selection Committee is in the process of selecting a location for our new eastern regional office. We have been asked by the Committee to provide input on the travel portion of the proposed site locations. It is expected that there will be considerable commercial air travel between our headquarters in Houston and the location of the regional office. Total travel between the two cities will probably amount to over 1,000 round trips per year. Approximately one-half of the tickets will be advanced purchase (two plus weeks prior to departure) and one-half will be for immediate travel (typically within a couple of days of purchasing the ticket). All data should be for nonstop flights. It is rare that any of our personnel travel over the weekend. Most trips are completed between Sunday evening and Saturday morning of the same week. The expected volume of travel will allow us to negotiate a fare plan with one, or more, of the air carriers that serve both Houston and the selected city. That negotiation, however, is in the future. Right now we just need to know which city provides the most advantageous travel conditions. The finalist cities for our new eastern regional office are Charlotte, NC, Philadelphia, PA and Atlanta, GA. For convenience, these airports are known in the business by their three letter designations; Charlotte = CLT Philadelphia = PHL Atlanta = ATL Houston Hobby = HOU Houston Bush Intercontinental = IAH The criteria we are to use for the travel portion of the site selection are: High percentage of on time flights at the selected city’s major commercial airport Low cost of tickets, both for advanced purchase tickets and immediate travel tickets. Using the above criteria, please prepare for my review a table in an Excel spreadsheet showing the relevant data that we can use to make a presentation to the Site Selection Committee. Provide a citation to show your data sources. Do not send the data to me as a Word document. I want to be able to manipulate the data when I receive it. Please note, I want the data only in an Excel table, not a chart. Flight delay data is available on the following web sites: http://www.transtats.bts.gov/OT_Delay/OT_DelayCause1.asp http://airconsumer.ost.dot.gov/reports/index.htm To obtain a useful set of data you will probably need to take the average for a 12-month period of on time arrival at each airport. Price information can be obtained from: http://www.orbitz.com/ http://www.travelocity.com/ Feel free to use any other data source you feel will provide the accurate data we need. I offer the above only as suggestions.|
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.