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 " 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.
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.
/Slash
From DateFirst date to display
-Dash to split dates range
Up To DateLast date to display
/Slash
CurrencyISO currency code
AmountAmount

 

Example:

 

Code Block
languagexml
TFC/A-EZELPB/1NOV-30NOV/USD4500


Add items indicating equipment 

 

You can enter the cost table by type of aircraft that operates the route. To indicate the type of aircraft, the equipment indicator should be inserted between the section and the date, as shown below:

 

Code Block
languagexml
TFC / A- (Destination Distance) / E (equipment id) / (date from) - (date to) / (currency) (amount)

 

Example:

 

Code Block
languagexml
TFC / A-EZELPB / E737 / 1NOV-30NOV / USD4500

 

Notes:
Field E (equipment) is optional. If this field is not entered, the cost will apply to all equipments.
After the indicator E, the equipment indicator should be entered in the DNE field. For example: 733 for the 737-300 aircraft-

 

Delete Items

To delete  costs added for a section, the following command must be entered:

 

Code Block
languagexml
themeFadeToGrey
TFC/D-ítems
TFC / D-Fixed Command to eliminate items.
ItemsItem number (depending on the table display) that you wish to delete.

Note:

Several items can be indicated separated by comma or with hyphens (to indicate ranges).

 

Modify Items

 

Code Block
languagexml
themeFadeToGrey
TFC/M-7/30NOV15/USD4500
TFC / M- Fixed command
MModify indicator
-Hyphen
7Iten number to modify
/Slash
30NOV15New effective date
/Slash
USD4500New cost

 

The cost can also be modified for a period of time, provided that this period is within the time range of the item to be modified.

 

Check the cost table

 

The following command must be performed in order to check the cost table:

Code Block
languagexml
themeFadeToGrey
TFC*


Table Display 

Image Added

 

Description:

 

ITEMItem number
BRD / OFFSegment origini and destination
DATE FROM / TOEffective date
CURRENCY AMOUNT Currency amount added as cost.