Travel input for the site location of new regional office

Assignment Help Other Subject
Reference no: EM13850328

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:

https://www.transtats.bts.gov/OT_Delay/OT_DelayCause1.asp

https://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:

https://www.orbitz.com/

https://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.

Reference no: EM13850328

Questions Cloud

Perform a regression analysis using compa as the dependent : Perform a regression analysis using compa as the dependent variable and the same independent variables as used in question
Do you agree or disagree that the best way to learn : Do you agree or disagree that the best way to learn about and become interested in the diverse cultures and traditions in the world is by wearing fashions, hairstyles, or body jewelry from other parts of the world?
Wirte one page essay to talk about the film : Watching film Amadeus, wirte one page essay to talk about the film. Dont need to be high level. just write what is the film talking about.
What are the key ideas being presented : You can extract the essence from works of this nature without reading each word and line with "pain-staking detail." You may find the essence of the author's work in the first chapter, sometimes it appears in the last chapter, sometimes it is spre..
Travel input for the site location of new regional office : 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 tr..
Define the value of qualitative and quantitative data : How do you feel about conducting action research now, compared to before you started this course. Describe how you perceive the value of qualitative and quantitative data when considering improvements.
How you applied each of the steps in the gebmo process : Discuss how you applied each of the steps in the GEBMO process and what risks you identified and provide recommendations for preventing spills or releases.
Create a scatter chart to display the game : create a scatter chart to display thegame
Estimate the power rating of motor required to drive pump : If the flow rate of the water is to be maintained at 3.15*10-3 m3/s and the water temperature remains constant at 16oc ,estimate the power rating of the motor required to drive the pump.

Reviews

Write a Review

 

Other Subject Questions & Answers

  Social welfare programs

How will globalization affect social welfare programs in the future? What should be done now to help us be proactive as globalization continues to affect our nation?

  Communicating effectively to diverse population groups

Why is pretesting materials so important? What was your experience with using the readability calculators.

  Impacts of information systems on organizations

Define information systems and discuss at least two positive and two negative impacts of information systems on organizations.

  Does descartes believe in god

Does Descartes believe in God? If so discuss his argument(s) for the existence of God. Are they convincing? Why or why not?

  What were the three categories listed in billboard in 1954

What were the three categories listed in Billboard in 1954?  In what ways did rock and roll threaten the established practices of Tin Pan Alley?  In what ways did Tin Pan Alley try to undermine rock and roll?

  Standard-form claims specify which elements

Standard-form categorical claims require that claims in other forms be translated so that the four standard-form claims specify which elements?

  Literature review or an additional search

Find an example of evaluation research from your literature review or an additional search. Summarize the findings and recommendation based on this research. Do you agree or disagree?

  The object-oriented approach

You are having a discussion with a systems analyst who has been in the field for 30 years. He makes the statement that traditional methods of systems design are far superior to the object-oriented approach. How would you explain to him the rationale ..

  Physician-assisted suicide ought to be legalized

What are the standard arguments for the view that physician-assisted suicide ought to be legalized?

  Hard drop and a currency acceptor drop

What is the difference between a hard drop and a currency acceptor drop and In which games would you find each type of drop?

  Describe parenting styles

Describe parenting styles that can insulate a youth from delinquency while also producing a well-socialized adolescent. Can you have it both ways?

  Discuss the forces that cause crustal plates lithospheric

describe the forces that cause crustal plates lithospheric plates to

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd