In this assignment, youili be visualizing and interpreting data pulled from the balance sheet and income statements of major US airlines (Delta, United, Alaskan, American, JetBlue, and Southwest] sourced from Yahoo Finance. Click here to view the data in Tablesu, and here to view it in Power BI. (The Tableou and Power BV files contain the same data; pou can use either to answer the questions in this assignment. Your instructor may specify which progrom they prefer pou to use!! How to Access Tableau. You can apen the Tablesu file in this problem statement with Tableau Desktop software. If you dan't have Tableau Desktop, you can download Tableau Reader, a free program that allows you to open Tableau visualizations. To get it, search fou "Tableau Reader" in your internet brawser, ar click here. How to Access Power BI: You can apen the Power BI file in this prablem statement with Power BI Desktop. If you dan't have it already, search for "Power BI download" in your internet browser, or click here for a free download. In the airline industry, unearned revenue represents a significant amount of liability since airline tickets have been purchased by customers, but revenue has not been "earned" since the flight has not been taken. You are a financial controller at a new airline compary called Desert Airways. You are asked by the CEO to interpret a data visualization dashboard comparing Desert Airways' unearned revenue in competing airlines and answer the follawing questions. What airline had the highest unearned revenue to total revenue ratio in 2018 ? American Airlines Sauthwest Airlines Alaskan Airlines JetBlue Airways What is JetBlue Airways' unearned revenue to total revernue ratio in 2018? 0.26 0.39 0.29 0.23 Which of the following statement is true? American Airlines had a large increase in unearned revenue in 2017. Southwest Airlines had a large increase in unearned revenue in 2017. United Airlines had a decrease in unearned revenue in 2016. Unearned revenue from Delta Airlines has been steadily decreasing. Based on Figure 2, what can be concluded regarding the unearned revenue to total revenue ratio? Mast airlines are nat introducing new revenue generating incentive and therefore unearned revenue to tatal revenue ratios have remained consistent year aver year. Airlines with lower revenues tend to have lower unearned revenue to total revenue ratios. The unearned revenue to total revenue ratio varies too dramatically to use for benchmarking purposes. The unearned revenue to total revenue ratio is consistent among these airlines and can be used for benchmarking other airline companies. Based on Figure 3, what is a possible reasan why the unearned reverue has changed in recent years for the airline companies? Airlines have intraduced flash sales for last minute trips. Payment from customers have been slower compared to previous years. Mare customers are cancelling future flights. Airlines have intraduced baggage fees which are callected at reservation and recarded as unearned revenues at the time of reservation