Airport Economics: Passenger Flows, Gate Capacity & Non-Aeronautical Revenue

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn monthly traffic into passengers per movement and seasonal shares, then derive the average day of the peak month and the design peak hour that terminal planners size facilities for.
• Price a month of traffic with the airport's tariff: a landing rate per tonne by weight band, landing fees per aircraft type, passenger and security charges and the aeronautical revenue per departing passenger.
• Calculate turn times from on-block and off-block times, count the stands busy at each half past the hour with COUNTIFS, and measure peak occupancy and utilisation of the stand window.
• Simulate the security queue of a morning wave interval by interval, find the longest wait against the target and estimate the lanes the peak interval needs.
• Calculate the airport's income from each concession as the higher of the percentage fee and the minimum annual guarantee, express it per passenger and measure the non-aeronautical share of revenue.
• Measure peak occupancy of four car parks against practical capacity, flag the full ones with conditional formatting and calculate revenue and revenue per space.
• Build the airport's operating P&L for two years, calculate EBITDA, the EBITDA margin and the operating cost per passenger, and work out the aero revenue per passenger a target margin would need.
• Project passengers for six years under low, base and high growth, measure headroom and utilisation against terminal capacity, find the year the high case runs out of capacity and chart all scenarios.