Take some time to familiarize yourself with the provided Class Project Excel file. Open the file and begin at the START HERE tab. The first text box provides a background and the following boxes provide an overview of content for each tab in the file. There are four blue tabs that correspond to the four key assignments of the air transportation analysis for this course. The blue tab titled, City-Pair Analysis will be considered for this assignment.
You have been tasked by the Chief Operations Officer (COO, your professor) to give a summary of travel history and to consider the impact to travel if the company decides to purchase an aggregate mine in Afton, OK. The City-Pair Analysis tab is the product of your analysis of company travel for last year and it also includes data if the company were to expand. Prepare a two to five minute narrated PowerPoint for the COO. This briefing must include the following:
A short "elevator" pitch that highlights your excitement about how much time could be saved IF the company were to utilize an on-demand travel solution.
Include the number of travel miles the COO travels and the number of travel miles the company travels as a whole.
Select a turboprop and then a jet in the Make/Model drop down menu and highlight the time savings.
Create a visual (chart, table, or graphic) that illustrates company travel.
OPTIONAL: Consider the city-pair data tables to the right (On-Demand and Airline Travel Models). Role play and make appropriate comments about travel demand.
Sample Solution