The Flight Summary report, depicted in Figure 1, gives a comprehensive overview of revenue and profit for each flight segment.

This image is password protected.

Table 1 below outlines the data structure, with the granularity of the data metrics defined by the combination of fields with a key icon (key).

FieldDescription
AL keyOperating Airline
Org keyOrigin Airport
Dst keyDestination Airport
Flight keyFlight Number
Opt_Days keyOperational Day of Week (1-Monday, 2-Tuesday, …, 7-Sunday)
AircraftAircraft Type Code
MilesFlight Distance
DeparturesNumber of departures in the target month
SeatsTotal seat count in the target month
Block_hoursTotal block hours in the target month
PaxTotal passenger count in the target month
Local_PaxTotal passengers in the local market (flight origin and destination match the market origin and destination)
Seat_FactorTotal passenger count / total seat count
RevenueTotal revenue in USD prorated to the current flight
Local_RevTotal revenue in USD from the local traffic
OD_RevTotal revenue derived from Origin-Destination (OD) trips, encompassing earnings from both the current flight as well as any connecting flights
FareAverage fare prorated to the current flight
Local_FareAverage fare in the local market
CostTotal flight cost in the target month
Other_RevenueOther revenue (e.g., ancillary fees, cargo revenue, fuel surcharge) from the flight in the target month
ProfitTotal profit in the target month
ASM000Available Seat Miles in thousand
RPM000Revenue Passenger Miles in thousand
Table 1: Data Structure