Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

IC Occupancy Rate  and Revenue Report

 


This report allows a thorough analysis of the flight revenue. It shows a certain information according to the status of the flight at the time of the inquiry.

The information displayed varies depending on whether it is requested:

1. Prior to the departure of a flight or,

2. After the flight closed at check-in.

 

Pre-Check-In Information

The command for getting this report is the following:

Code Block
languagexml
themeFadeToGrey
VICFLIGHT/DATE

Example:

VIC4420/22JUN

 

 FLTFlight number 
 DATEDeparture date 
ROUTING flight routing 
 TOTAL COLLECTTicket total amount collected
 FLT COSTTotal cost of the flight loaded in the table
 FLT BALANCE Flight balance, obtained from the difference between "Total Collect" and "Flt Cost"



LEG INFORMATION

LEGLeg order number
BRD/OFFBRD Origin OFF Destination
EQPEquipment
ACActual equipment capacity
KMDistance between origin/destination (in km)
A.K.OSeats per kilometer offered
BOOKNumber of passengers per leg
P.K.T.Passenger Kilometer Traveled
L.FLoad factor
COST

Prorated cost by leg

  

REVENUE

 

  
BRD /OFFBRD Origin /OFF Destination
KMDistance between origin and destination
BOOKNumber of passengers
EFFECEffective Passengers Booked/Ticketed
E-TKNumber of etickets issued
CUR.Currency
AMOUNTTicketed total amount
FARE AVAverage fare
YIELD

YIELD . This value is obtained by dividing the value of the Total Collect by the P.K.T (Passenger per Km Traveled)

«TICKETING ISSUE»Tickets issued
HOSTTickets issued in the host
AGENCYTickets issued by travel agents
WEBTickets issued from the web page

 

When  dealing with flights with intermediate stops in order to obtain the flight  balance ,the cost values must be charged for each of the legs, otherwise the total balance thereof can not be calculated.

 

Post Check-In Information

Example: VIC5200/13JUN

 

The command that must be entered to check this report is the following:

Code Block
languagexml
themeFadeToGrey
VICFLIGHT/DATE

 


General flight information

FLTFlight number
ROUTEComplete routing
DATEFlight date
TOTAL COLLECTTotal amount collected
COEFLoad Factor
LEGOrder number of each section
BRD OFFBRD:Origin OFF: Destination|
EQPEquipment
REGRegistration
SCHDScheduled departure time
DEPActual departure time
DLYDelay
ACAircraft capacity
BSSpace Block
PAXBooked passengers by Leg
COEFLoad factor(percentage)
LOADLoad
MAILMail

 

 

Information by marketing segments

BOAD/OFFBRD:Origin OFF: Destination|
PAXPassenger
E-TKTE-ticket
CURCurrency
AMOUNTTotal ticked amount by segment
FARE AVAverage fare
NO-SHOWNo-show passengers
GO-SHOWGo-Show passengers
INFOASInfant passengers
LOADCargo
MAILMail.

 

Booking Details

 

BOAD/OFFBRD:Origin OFF: Destination|
CBCabin
CLClass
PAXPassenger
E-TKTE-ticket
NO-SHOWNo-show passengers
CURCurrency
AMOUNTTotal ticked amount by segment
GO-SHOWGo-Show passengers
HOSTTickets issued in the host
AGENCYTickets issued by travel agents
WEBTickets issued from the web page

 

Flight Post Check-in information with Upgrades / Downgrades

 

In case the flight checked contains upgrade and /or  downgrades, the VIC report will contain other columns that will optimize the analysis. The columns are:

 

Code Block
languagexml
BOOK Number of reservations in each class

UPG / DWG: Number  upgraded or downgraded passengers in each class:

FROM: Number of passengers with reservations in another class, and due to an upgrade or downgrade are  checked in that class.

TO: Number of passengers with reservations in that class, and due to an upgrade or downgrade are checked in another class.


Example:

 

Description:


Class C: I had 2 reservations (BOOK). 8 passengers flew in this class (PAX). 7 passengers had upgrade. 1 passenger had a downgrade.
Class J: I had 2 reservations (BOOK). 1 passenger flew in this class (PAX).
Class Y: I had 5 reservations (BOOK). 1 passenger flew in this class (PAX). 1 passenger had upgrade. 5 passengers had downgrade.
Class H: I had 4 reservations (BOOK). 2 passengers flew in this class (PAX). 2 passengers had downgrade

 

Cost table


This functionality allows the administration of the "Cost Table " referential of in reference to the different sections of the airline.
Values assigned to the  Cost Table  will be reflected, in the VIC statistical report, in a comparative way with the collection of the flight.

Note:
The user must have duty code  6 or 8 in order to perform  this command

 

Add items

To enter the costs for each leg and period, the following command should be entered:

 

 

Code Block
languagexml
themeFadeToGrey
TFC / A- {Origin} {Destination} {-} / {date from} - {date to} / {currency} {amount}

 

Description:

 

TFC / A- Fixed command to add a new item.
Origin Code of the airport of origin of the section.
Destination Code of the destination airport of the section.
 The middle dash in this position indicates that the value will not be loaded in the reverse direction. By default it charges the amount in both directions.
/ Separator.
Date from Date From which the amount is valid.
- Date range separator.
Date until Date Until the amount is valid.
/ Separator
Currency Currency Code of the amount.
Amount Amount corresponding.

 

 

 

TFC / A- Fixed command to add a new item.
OriginOrigin airport code
DestinationDestination airport code
The middle dash in this position indicates that the value will not be loaded in the reverse direction. By default it charges the amount in both directions.
/ Separator.
/Slash
From DateEffective date