You boss at Delta Airlines has noticed certain stations are consistently having issues with on-time departures (D0).
Question:
You boss at Delta Airlines has noticed certain stations are consistently having issues with on-time departures (D0). He would like to know if this poor D0 performance is due to capacity growth at the respective stations. You are tasked with calculating D0 performance for all stations, identifying those with poor D0 scores and comparing these scores to first quarter (1Q) year-over-year (YoY) change in available seats (capacity) between 2015 and 2016. Does the data support your boss' suspicion that poor D0 performance is due to YoY capacity growth at these outstations?
- D0 is calculated by counting the number of departures where Out is less than or equal to Scheduled Departure and dividing by the total number of departures.
- Capacity is calculated by summing the maximum seating capacity of each aircraft departure.
- YoY change is calculated by dividing the difference in the new value and the old value by the old value.
Submit your findings as a scatterplot graph with D0 performance on the x-axis and YoY capacity change in the y-axis. Your graph must be on the first worksheet in the MS Excel file (.xlsx) and on a separate worksheet from the data.
Auditing Cases An Interactive Learning Approach
ISBN: 978-0132423502
4th Edition
Authors: Steven M Glover, Douglas F Prawitt