Part Two: Environmental Analysis The Board of Directors of a major airline is concerned about the possibility of an economic downturn affecting demand for air travel. Consider that you are a manager and have been tasked to do an environmental analysis for the industry and a destination analysis to determine which of the flight destinations are most popular. 1. Identify some of the questions you might have about the overall environmental industry trends (political, economic, social, technological, environmental, and legal, or others). You might include questions such as "What affects demand?" or "Who is likely to travel the most in the next five years?" "How are fuel prices determined" or "How can fuel efficiency be improved?", for instance a. Identify at least one question for each of the environmental factors (political, economic, social, technological, environmental, and legal). b. For at least one of the questions, hypothesize the answers to it, and identify where you might go to evaluate resources. For instance, if you asked a question regarding what affects demand, you might hypothesize that personal income could be a factor, and you might conclude that evaluating the overall U.S. economy or household income from data on the Bureau of Economic Analysis site could be valuable information. Identify at least one other question and at least two sources of possible information. 2. Open the Excel workbook, Departures_fy_2015_and_2016_Student.xls, and familiarize yourself with the fields in each of the worksheets. Metadata (Data Dictionary): For the tbl_Export_Departures worksheet: Column Name Year Month usg_apt_id usg_apt usg_wac fg_apt_id fg_apt fg_wac airlineid carrier carriergroup type Scheduled Charter Example Value 2015 11 10299 ANC 1 12277 ICN 778 19917 5Y Description Data Year Data Month US Gateway Airport ID - assigned by US DOT to identify an airport US Gateway Airport Code - usually assigned by IATA; otherwise FAA-assigned code US Gateway World Area Code - assigned by US DOT to represent a geographic territory Foreign Gateway Airport ID - assigned by US DOT to identify an airport Foreign Gateway Airport Code - usually assigned by IATA, otherwise FAA-assigned code Foreign Gateway World Area Code - assigned by US DOT to represent a geographic territory Airline ID - assigned by US DOT to identify an air carrier IATA-assigned air carrier code; otherwise, FAA-assigned code Carrier Group Code - 1 denotes US domestic air carriers, 0 denotes foreign air carriers Defines the type of flight operated Tons of freight carried by scheduled service operations Tons of freight carried by charter operations 1 Departures 245 792 Total 3247 Total tons of freight carried by scheduled service and charter operations For the Airport Codes worksheet: Column Name From tbl_Export_Departures Example Name fg_apt AirportCode Location ICN Agra, India Foreign Gateway Airport City and Country Name For the Air Carrier Codes worksheet: Column Name From tbl_Export_Departures Example Name Code carrier DL IATA-assigned air carrier code Name of air carrier Carrier Name Delta Air Lines, Inc. 3. Open the Excel workbook, Webdeparturesfy2016and2016.Is , and familiarize yourself with the fields in each of the worksheets. Part Two: Environmental Analysis The Board of Directors of a major airline is concerned about the possibility of an economic downturn affecting demand for air travel. Consider that you are a manager and have been tasked to do an environmental analysis for the industry and a destination analysis to determine which of the flight destinations are most popular. 1. Identify some of the questions you might have about the overall environmental industry trends (political, economic, social, technological, environmental, and legal, or others). You might include questions such as "What affects demand?" or "Who is likely to travel the most in the next five years?" "How are fuel prices determined" or "How can fuel efficiency be improved?", for instance a. Identify at least one question for each of the environmental factors (political, economic, social, technological, environmental, and legal). b. For at least one of the questions, hypothesize the answers to it, and identify where you might go to evaluate resources. For instance, if you asked a question regarding what affects demand, you might hypothesize that personal income could be a factor, and you might conclude that evaluating the overall U.S. economy or household income from data on the Bureau of Economic Analysis site could be valuable information. Identify at least one other question and at least two sources of possible information. 2. Open the Excel workbook, Departures_fy_2015_and_2016_Student.xls, and familiarize yourself with the fields in each of the worksheets. Metadata (Data Dictionary): For the tbl_Export_Departures worksheet: Column Name Year Month usg_apt_id usg_apt usg_wac fg_apt_id fg_apt fg_wac airlineid carrier carriergroup type Scheduled Charter Example Value 2015 11 10299 ANC 1 12277 ICN 778 19917 5Y Description Data Year Data Month US Gateway Airport ID - assigned by US DOT to identify an airport US Gateway Airport Code - usually assigned by IATA; otherwise FAA-assigned code US Gateway World Area Code - assigned by US DOT to represent a geographic territory Foreign Gateway Airport ID - assigned by US DOT to identify an airport Foreign Gateway Airport Code - usually assigned by IATA, otherwise FAA-assigned code Foreign Gateway World Area Code - assigned by US DOT to represent a geographic territory Airline ID - assigned by US DOT to identify an air carrier IATA-assigned air carrier code; otherwise, FAA-assigned code Carrier Group Code - 1 denotes US domestic air carriers, 0 denotes foreign air carriers Defines the type of flight operated Tons of freight carried by scheduled service operations Tons of freight carried by charter operations 1 Departures 245 792 Total 3247 Total tons of freight carried by scheduled service and charter operations For the Airport Codes worksheet: Column Name From tbl_Export_Departures Example Name fg_apt AirportCode Location ICN Agra, India Foreign Gateway Airport City and Country Name For the Air Carrier Codes worksheet: Column Name From tbl_Export_Departures Example Name Code carrier DL IATA-assigned air carrier code Name of air carrier Carrier Name Delta Air Lines, Inc. 3. Open the Excel workbook, Webdeparturesfy2016and2016.Is , and familiarize yourself with the fields in each of the worksheets