Analysis of Qantas Group Data
Question 1. (10 Marks)
Calculate Qantas domestic RASK in Australian cents per ASK for the semi-annual period December 2011 to June 2021. Use this data to construct a line graph in Microsoft Excel and paste this graph into your answer word document. Ensure you have properly labelled relevant axes. Describe the seasonality in the data. Why might any seasonality come about? What measures could you use to quantify the seasonality in the data? Discuss why Qantas domestic RASK may increase or decrease over time? Discuss the impact of COVID-19 on the time series movements in Qantas Domestic RASK.
Question 2. (10 Marks)
Calculate Qantas international EBIT-level CASK in Australian cents per ASK for the semi-annual period December 2011 to December 2019. Use this data to construct a line graph in Microsoft Excel and paste this graph into your answer word document. You will be marked on the quality of the graph you present. Ensure you have properly labelled relevant axes. Discuss what may be causing the movement over time in Qantas International CASK? You are encouraged to support your answer with other data sources.
Question 3. (5 Marks)
Find the following:
- Qantas International EBIT-level cost per ASK and EBITDAR-level cost per ASK over the calendar annual period 2019. Note that this represents two sets of CASK estimates.
- Find Qantas Domestic EBIT-level cost per ASK and EBITDAR-level cost per ASK over the calendar annual period 2019.
- Find Jetstar Group EBIT-level cost per ASK and EBITDAR-level cost per ASK over the calendar annual period 2019.
Compare and contrast your estimates at (a) through to (c). You will be marked on the thoroughness of the research you give for this answer.
