Rates DB Air (Requirements)

From UG

(Difference between revisions)
Jump to: navigation, search
(Paris office Examples)
 
(9 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Projects]]
+
[[Category:Rates DB]]
== Info ==
== Info ==
Line 39: Line 39:
  airline will offer 10.00 per Kilo with a 50/50 volume cut
  airline will offer 10.00 per Kilo with a 50/50 volume cut
  This means that you will subtract the actual weight from the chargeable weight and divide the sum by 2.   
  This means that you will subtract the actual weight from the chargeable weight and divide the sum by 2.   
-
  This is the amount you will be paying for.
+
  Add this total to the actual weight and this is the amount you will be paying for.
-
  (200-100)/2 = 150 Kilo's  
+
  (200-100)/2 = 50 + 100 = 150 Kilo's  
  Next you will need to break this down into an actual per kilo cost.
  Next you will need to break this down into an actual per kilo cost.
  You will do this by multiplying the 150 Kilos by the rate offered of 10.00.
  You will do this by multiplying the 150 Kilos by the rate offered of 10.00.
Line 270: Line 270:
   
   
  These rates are equal, they are only shown differently.
  These rates are equal, they are only shown differently.
 +
 +
'''the fixed tax'''
 +
*Description provided by Sanja in the Paris office below
 +
 +
This if for the import transfer fee the airlines charge us :
 +
 +
AIR FRANCE
 +
You have always a lumpsum of EUR 40.45 per shipment and this is what we called : Frais Fixe de Transfert
 +
 +
Then, on the top of this, you have to add another tax based on the G.W. of the shipment but per weight break :
 +
 +
To 200 kg                        EUR 6.75
 +
From 201 to 1 000 kg        EUR 13.60
 +
From 1 001 à 2 000 kg      EUR 30.00
 +
More than 2 000 kg            EUR 20.00 per 1 000 Kg
 +
 +
For example, for a shipment of 1 795 Kg, we will pay to AF EUR 40.45 & EUR 30.00
 +
For a shipment of 2 003 Kg, we will pay to AF EUR 40.45 & EUR 50.00
 +
(because AF charge EUR 20.00 per 1000 Kg and as we have 3 Kg more, they only take EUR 10.00 for them).
 +
 +
Finally, we pay '''VAT''' on all import shipments in France. I guess you are aware of this.
 +
The VAT is applied on both taxes and is of 19.6 %
=== Current business process ===
=== Current business process ===
Line 676: Line 698:
*10 Indicates additional terms of the contract
*10 Indicates additional terms of the contract
*11 indicates which airports are covered under the FR1 origin zone.
*11 indicates which airports are covered under the FR1 origin zone.
 +
 +
'''Esse Emme Contract'''
 +
 +
[[File:Esse emme email agreement coloader.jpg]]
 +
These rates are received in an email
 +
*1 – indicates the service (non- stop), carrier (Airline), origin and destination pairing, and the rates broken down by the weight breaks
 +
*2 – additional terms to the contract
 +
*3 – Indicates the ‘’’FOB’’’ or  ‘’’Freight On Board’’’ charges- These are the costs associated with picking the freight up from the pickup location through being loaded on the aircraft.
=== Hong Kong office Examples ===
=== Hong Kong office Examples ===
Line 722: Line 752:
==== A ====
==== A ====
 +
 +
'''Towne Air Management System'''
 +
 +
http://www.towneair.com
 +
 +
Requested login: JAGUARF
 +
Request pwd:         FREIGHT
 +
 +
After logging in go to Customer tools
 +
 +
Then click on simple quotes
 +
 +
Select the origin airport
 +
 +
Select the destination airport
 +
 +
Enter the shipments weight
 +
 +
Enter the ship date
 +
 +
Click submit
 +
 +
This generates a simple quote form listing your costs.
 +
 +
Please keep in mind that although this is showing airport to airport, this is really for moving via truck – but it is an example of an online tariff system.
 +
 +
'''Air France online'''
 +
TBD
== APPENDIX Bits and pieces ==
== APPENDIX Bits and pieces ==

Current revision as of 10:24, 13 July 2011


Contents

[edit] Info

  • mantis# 0002894: [Rates DB] Implement phase1 for MOT Air

See also: http://ct.jaguarfreight.com/wiki/Rates_DB

[edit] Glossary

Actual Gross Weight (GW) is the actual weight of the shipment

Volume Weight (VW) is calculated based on a cargo's size, measurement or dimensions

formula for calculating
Using the English System: L x W x H in inches (in.) / 165 = vw (in lbs.)
Using the Metric System: L x W x H in centimeters (cm.) / 6,000 = vw (in kgs.)

Chargeable Weight of cargo intended for air shipment is the actual gross weight (gw) or the volume weight (vw), whichever is greater.

Unit load device (ULD) is a pallet or container used to load freight on an aircraft. It allows a large quantity of cargo to be bundled into a single unit.

  • ULD pallets are rugged sheets of aluminum with rims designed to lock onto cargo net lugs
  • ULD containers, also known as cans and pods, are closed containers, which, depending on the nature of the goods to be transported, may have built-in refrigeration units

Drum is a cylindrical container used for shipping bulk cargo (a liquid or as a mass of relatively small solids like grains). Drums can be made of steel, dense paperboard (commonly called a fiber drum), or plastics, and are generally used for the transportation of certain dangerous materials or modest quantities of bulk goods.

Known Shipper A shipper that is qualified by specific regulations as a known shipper. A known shipper has less restrictions for shipping and as a result will usually have lower rates.

Unknown Shipper A shipper that has not yet been qualified according to the Transportation Security Administrations regulations as a known shipper. An Unknown shipper's cargo has more restrictions when shipping and therefore may have to pay higher rates to ship cargo.

Hazardous Freight is freight that is capable of posing risk to people, health, property, or environment when transported in quantity. AKA dangerous goods

Weight Break is the point at which the weight or chargeable weight of a shipment is large enough to be assessed the lower freight rates which are applicable to larger shipments, this is as per the carrier's tariff.

Volume Cut is discount offered for voluminous cargo. It is the same concept as weight break, but has its own formula to calculate.

If you have freight that is 100 Kilos and the chargeable weight is 200 Kilos, the co-loader or
airline will offer 10.00 per Kilo with a 50/50 volume cut
This means that you will subtract the actual weight from the chargeable weight and divide the sum by 2.  
Add this total to the actual weight and this is the amount you will be paying for.
(200-100)/2 = 50 + 100 = 150 Kilo's 
Next you will need to break this down into an actual per kilo cost.
You will do this by multiplying the 150 Kilos by the rate offered of 10.00.
150 X 10.00 = 1,500.00
Then dividing the sum of this by the chargeable Kilo's to get the actual per Kilo cost.
1,500.00 / 200 = 7.50 per Kilo
*This volume cut can vary and may not always be 50/50, it could be 25/75, 40/60, etc...

Minimum (Min) is the lowest amount that can be charged for the service.

Maximum (Max) is the highest amount that can be charged for the service.

Flat Fee is a single fixed fee for a service

Spot Rate is the rate that is quoted for an immediate shipment, as per the shipment specifications, and is not part of a contract.

Royalties Tax is a governmental Tax actually only applicable by the Democratic Republic of Congo, Kinshasa. We are charged by Brussels Airlines, The tax code is TXC and it is applicable on actual gross weight

Lumpsum charge are applied to taxes applicable per shipment and only one rate exists and is applied by all airlines. It is a flat tax not applicable per weight break

Diagnose is a security process which replace the X-Ray one. As soon as a cargo released to the airline cannot be secured by X-Ray, they will apply the Diagnose method which consists in securing the cargo by dogs (Diag = Diagnosis + Nose). for more information http://www.diag-nose.com/

[edit] Summary

What are we trying to achieve? What are the main goals of this module?

[edit] Core need

See Rates DB.

[edit] Core functionality

See Rates DB.

[edit] Detailed Requirements and Related Information

[edit] Charge codes related to Rates DB Air

[edit] Question

  • For each existing charge code:
    • define meaning
    • provide formula
    • give example
  • If CC list will be different after Rates DB is added go over all changes in details.

[edit] Answer

File below is cc air.xls attached to 0002894: [Rates DB] Implement phase1 for MOT Air File:Cc air.JPG

CCC # Description Definition Vendor or carrier to/From or transactional fee Quantity type Derivatives Derivatives Derivatives Formula Examples
1101Airfreightthe amount of money charged for sending goods by airAirline / Coloaderairport to airport pairingChargeable weightweight breaksKnown shipper ratesCommodity typeper Kilo rate X chargeable weight $0.90 x 100 K = $90.00.
Minimummanual break points (electing to pay for more Kilo\'s to get a lower per Kilo rateUnknown shipper ratesConfirming the total of the above is higher than the minimumif the minimum rate is $125.00, then using the above the rate would be $125.00
ULDVolume cut checking against weight breaks to confirm you are paying the best rate using the first example if you have 90 Kilo\'s you may choose to pay for 100 Kilo\'s if the rate for the 100 K weight break will total to be less then paying for the actual Kilos90 K X 1.20 (less than 100 k rate) = 108.00 which is higher then paying for 100 Kilo\'s at the lesser rate of .90 (100+ k rate) x 100 K= 90.00
Please see volume cut definition for formula
1102Airfreight Fuel surcharge is a fee that can be added to the freight charges as reimbursed for excessive fuel costs incurred in shipping the freight from one point to anotherAirline / Coloaderairport to airportactual weightUsing same formula as airfreight.50 x 90 K = 45.00
region to regionchargeable weightChecking it is over the min
country to countryminimumSometimes the airline will provide an all in rate - which will include this feeWhen the fee is included we do not know what the charge is
1103Airline Security Fee is a fee that can be added to the freight charges as reimbursed for security screening costs incurred in shipping the freight from one point to anotherAirline / Coloaderairport to airportactual weightUsing same formula as airfreight.50 x 90 K = 45.00
region to regionchargeable weightChecking it is over the min
country to countryminimumSometimes the airline will provide an all in rate - which will include this feeWhen the fee is included we do not know what the charge is
1105War Riskas a result of the 9/11, insurance companies stopped insuring airlines for war risk. Some airlines are now charging this fee in order to insure themselves, in case of any war / attacksAirline / Coloaderairport to airportactual weightUsing same formula as airfreight.50 x 90 K = 45.00
region to regionchargeable weightChecking it is over the min
country to countryminimumSometimes the airline will provide an all in rate - which will include this feeWhen the fee is included we do not know what the charge is
MaximumChecking that the total is not above the maximum charge
1111Dangerous Goods FeeIs a fee charged by the airline (per UN number) to check the packaging and documentation of dangerous goods freight Also, for the special handling of Dangerous Goods freight UN numbers or UN IDs are four-digit numbers that identify hazardous substances, and articles. Some hazardous substances have their own UN numbers , while sometimes groups of chemicals or products with similar properties receive a common UN number. A chemical in its solid state may receive a different UN number than the liquid phase if their hazardous properties differ significantly; substances with different levels of purity (or concentration in solution) may also receive different UN numbers.Airline/ColoaderTransactional feecharged per UN#For each UN # (how many types of hazardous materials) are part of each shipment, you will have to pay a fee25.00 per UN x 5 UN #\'s = 125
Flat FeeFlat dangerous goods fee for the shipment$25.00
Chargeable weightper Kilo rate based on chargeable weight$0.25 x 500 K = $125.00
Actual weightPer Kilo rate based on actual weight$0.25 x 150 K = 37.50
Flat tax (Lump Sum)EUR 57.75 per shipment
1114Dangerous Good DeclarationIs a fee for completing a Dangerous good declaration and/or packaging of the dangerous goods freight. RA Specialists (agent)Transactional feeFlat feeFlat fee$55.00
1116Air Waybill FeeIs a fee for issuing an airway billColoaderTransactional feeFlat feeFlat fee$55.00
Flat tax (Lump Sum)EUR 17.45 per shipment
1115Import Service Chargesis an airline handling fee for transmitting customs information and handling documentationAirline / Coloader / TruckerTransactional feeFlat feeFlat fee$55.00
1104Airfreight Insurance SurchargeIs the fee charged for insurance covering the freight during transportationInsurance Co.Transactional feeBased on Value declared (freight charges + value of goods)a fee based on the total amount being insured. If the value of the goods in $25,000.00 and the freight costs are $5,000.00 you would want to insure $30,000.00. The insurance co. may charge you 50.00 per $1,000.00 (($25,000.00 (value of goods) + $5,000.00 (cost of freight))/1,000.00) x $50.00 = $1,500.00
1112Export Airline Transfer ChargesIs the charge for transferring or moving freight from a warehouse to an airline. Usually paid to trucker.Trucker / airline / coloaderTransactional fee actual weightrate x quantity type checking the total is higher than the minimum
chargeable weight
minimum
Flat fee
1113Import Airline Transfer FeeIs the charge for transferring or moving the freight from the airlines to a warehouse. Usually paid to trucker.Trucker / airline / coloaderTransactional feeactual weightrate x quantity type checking the total is higher than the minimum
chargeable weight
minimum
Flat fee
1106Air Security Xray ChargesIs a fee charged by an airline or warehouse for xraying or swabbing freight for security purposesAirline / Trucker /ColoaderTransactional feeactual weightrate x quantity type checking the total is higher than the minimum
chargeable weight
minimum
Flat fee
1110Air Unloading / Loading ChargesHandling fee for loading and unloading freight to or from ULDAirline / Trucker /ColoaderTransactional feeactual weightrate x quantity type checking the total is higher than the minimum
chargeable weight
minimum
Flat fee
Loose HU
Pallets
1107Export Airline / Terminal Handling ChargesHandling fee for documentation and freightAirline / Trucker /Coloader / Terminal or warehouseTransactional feeactual weightrate x quantity type checking the total is higher than the minimum
chargeable weight
minimum
Flat fee
Loose HU
Pallets
1108Import Airline / Terminal Handling ChargeHandling fee for documentation and freightAirline / Trucker /Coloader / Terminal or warehouseTransactional feeactual weightrate x quantity type checking the total is higher than the minimum
chargeable weight
minimum
Flat fee
Loose HU
Pallets
TBDEuropean Union advanced noticeis a fee charged by the airline for manually entering and transmitting required information to you European Union CustomsAirline / ColoaderTransactional feeflat feeflat fee$25.00
TBDDiagnose Chargeis a security process which replace the X-Ray one. As soon as a cargo released to the airline cannot be secured by X-Ray, they will apply the Diagnose method which consists in securing the cargo by dogs (Diag = Diagnosis + Nose). You can have a look to the website of DiagNose which is comprehensive : http://www.diag-nose.com/Airline / CASSTransactional feeactual weightMin
Max
TBDRoyalties taxA tax actually only applicable by the Democratic Republic of Congo, Kinshasa, charged by Brussels Airlines through the .Airline / CASSCountry to Countryactual weight 0.025€ per K 0.025 x 100 = 2.50€

Rates structures and formulas

Each charge will have its own rates structures and formulas necessary to maintain these rates. However, it is possible to have some costs that are an all in rate.

For Example:
We could receive a rate from Air France for a shipment from JFK to CDG of 100 K showing:
Air Freight:   .75
Fuel Surcharge .90
Security       .75
Then we could receive a rate from KLM for the same shipment showing:
Air Freight:  2.40 all in

These rates are equal, they are only shown differently.

the fixed tax

  • Description provided by Sanja in the Paris office below

This if for the import transfer fee the airlines charge us :

AIR FRANCE You have always a lumpsum of EUR 40.45 per shipment and this is what we called : Frais Fixe de Transfert

Then, on the top of this, you have to add another tax based on the G.W. of the shipment but per weight break :

To 200 kg EUR 6.75 From 201 to 1 000 kg EUR 13.60 From 1 001 à 2 000 kg EUR 30.00 More than 2 000 kg EUR 20.00 per 1 000 Kg

For example, for a shipment of 1 795 Kg, we will pay to AF EUR 40.45 & EUR 30.00
For a shipment of 2 003 Kg, we will pay to AF EUR 40.45 & EUR 50.00 
(because AF charge EUR 20.00 per 1000 Kg and as we have 3 Kg more, they only take EUR 10.00 for them).

Finally, we pay VAT on all import shipments in France. I guess you are aware of this.

The VAT is applied on both taxes and is of 19.6 %

[edit] Current business process

[edit] Questions

  • What is the current business process - How Jaguar deals with Contracts and Tariffs (in each office) now?
  • Who is in charge for this in each office?
  • Please describe "A Day in the life of Inside Sales Dept NOW"
  • In what form existing Air contracts received and maintained ?
  • How requests for rates handled (receive, search, answer)?
  • What is the typical Request format?
  • What is typical Response format?
  • Sounds like most of these are "spot rates" received by phone call? Is that right? Do we ever in a response to a phone call ever receive "entire contract" by email instead of just rate from A to B for specific cargo and dates?

[edit] Answers

Since Air freight shipments move quickly, when you are contacted for rates, you must provide the rates as quickly as possible. Also, Jaguar Freight does not handle a large volume of air freight shipments and are not currently IATA certified. These are a couple of the reasons, that we do not have many tariff's in place

[edit] NY office

NY office has a special group called "Inside Sales".

  • Steve - manager
  • Sylvia - handles mostly ocean, gets involved into ocean contracts, main user of Rate Explorer?
  • Mary - handles ocean, air

They are responsible for providing cost's to our Outside Sales team, operations team, and overseas offices. In addition to obtaining costs for internal employees, they also quote out cost's the customers.

Currently, requests are usually received verbally (in person), via email, or via telephone.

Once the request is received, the inside sales team will begin to research the cost. They begin by determining if the specifications of this shipment are covered within already existing airline tariffs.

This is done by checking 1st that the airline has flight from and to the desired airports. Once this is confirmed, they still need to make sure that the airlines has the room required (over sized freight can only shipper on freighter not a passenger aircraft), accepts the specified commodity type (certain kinds of hazardous freight cannot ship on a passenger aircraft), and accepts freight from this shipper type (Unknown shippers cannot ship on a passenger aircraft).

If they find multiple airlines fitting these specifications, they will determine the best rate and service level. This is the information they will use to quote out the air portion of this rate.

If it does not, they will then research all of this information again using an existing co-loaders tariff. Once again, if multiple rates are found they will select one based on price and service comparison and use this to quote out the air portion of this rate.

If the shipment specifications are unusual, large, or are not covered under any existing tariff, they will email or call the airline or co-loader to find someone that can give them a cost. They will complete the total cost's of the shipment by calculating the rates for any additional services required. (pickup, delivery, Customs, etc...)

In addition to the inside sales team, operators, sales, and management are also involved in obtaining cost's.

Everyone seems to be handling the management of the rates that they obtain in their own way. Some keep them saved in their emails, some keep them saved on their desktop, and some have the rates printed out and keep paper copies.

....

NY office has tariffs in place with 4 airlines and 3 co-loaders. Steven the inside sales manager intends to increase this in the future.

[edit] London office

The London office has three main contacts for Cost/Sell rates.

Vikesh - Sales

Ginny - Account manager

Anshu - Inside Sales

The London office currently does not book freight directly with any airlines, they only book with co-loaders. They have no airline tariff's in place at this time.

When they need to cost out an airfreight shipment, they always handle this on a spot rate (case by case)basis. This is because they do not handle a high enough volume of air freight shipments. Also, they are afraid that they will be locked into using these co-loaders for the additional services (delivery, Customs, special handling, etc....). They are using two co-loaders Hook and LS Express. Every time they receive a request for rates, they call or email the co-loaders for a rate.

EXAMPLE OF THE TYPICAL EMAIL EXCHANGE FOR OBTAINING RATES TO BE ADDED.

[edit] Paris office

Currently in the Paris office we have three main contacts handling rates

Sanja - Account Manager

Wassila - Account Manager

Inma - Inside Sales

The Paris office requires vendors send contract rates are received as an attachment to an email.

These rates are received in various forms such as word docs, PDF's, and excel sheets. When the rates are received Inma saves the file in a shared drive, so the whole office can access.

All operators in the Paris office are able to access this shared drive and quote out cost's according to these sell rates.

In this shared drive they have general contract rates as well as specific contract rates. The general contract rates are rates that are provided to everyone by the airline. These rates are usually very high and not usually used.

The Paris office has several general contracts uploaded into the shared drive as a guide line for rates, but once again it is preferred to never use general contract rates.

When you begin to offer the airline more volume to specific destinations, they will give you contracted rates for these specific moves.

They currently have negotiated contracted rates with 7 airlines and 1 co-loader.

  • Air France
  • British Airways
  • Gulf Air
  • Air Nautic (Etihads Rep)
  • Continental
  • Cargo World (Virgins Rep)
  • Gulf Air (Egypt Airs Rep)
  • Co-loader - Esse Emme

Although, they only have one contract in place with a coloader, they do use other co-loaders/agents.

The additional co-loaders / agents used are contacted for "spot" rates. They are supposed to provide us with the actual costs they are paying and we negotiate a profit share agreement with them.

If they need to quote a shipment, that they only have general contract rates for, they will call the airline to negotiate a better rate. Once this rate is agreed on, they will request the airline to email these rates to them and add it to the shared folder.

[edit] HK office

They do not currently have an inside sales team, but will have at least one person to handle this in the future.

Right now the main contact for rates in Hong Kong is

Canny - Account Manager

all operators are able to quote costs and sell rates.

Currently Jaguar Hong Kong does not book shipments directly with any airlines. So they do not have any airline tariffs. This is because you must be able to guarantee the airline a large volume of freight, in order to secure a good rate.

They are using the following 3 co-loaders. These co-loaderd are building weekly pallets (ULD's) and are able to obtain much better rates with the airlines.

  • AIF for Taiwan rates
  • Topfor for China rates
  • A-sonic for Hong Kong rates

The rates are being managed and maintained by a spreadsheet that was created by the Hong Kong office and is updated by the co-loaders. The last version of the spreadsheet is emailed to the co-loaders, the co-loaders will update any necessary information and email the spreadsheet back.

Although they are receiving monthly versions of this air freight tariff, they continue to email the co-loaders on a case by case basis for costs. The spreadsheet is maintained only as a reference tool for the other Jaguar offices, when an estimate is needed and they are unable to contact the Hong Kong office.

This is because the rates change frequently. The individual rate requests are handled mostly via email exchange.

[edit] Future business process

[edit] Questions

  • What is the vision for the biz proc in the future?
  • A Day in the life of Inside Sales ONCE SYSTEM IS IN PLACE.
  • Explain vision of every office.
  • This should be formulated by person responsible for this area(like Steven in NY)
  • How will we manage tariffs/cpntracts in the system (how to populate? how to update? expiration management)?
  • What is a suggested Format of request (for rates) and response?

[edit] Answers

[edit] NY office

Stevens future vision for the rate database would be to have a place to maintain spot rates, by entering manually.

being able to upload contract rates directly into the rate database and be able to update these rates all at once, select ones, or only one rate.

He would like to have quick easy access to our costs and in the future enable customers / operators to be able to access their own sell rates or cost rates.

Once the system is in place, it should free up some time for the inside sale department to be able to maintain the rates instead of quoting costs and sell rates

[edit] London office

Speaking with virginie in the UK office, she would like to be able to work on obtaining some contract rates.

Philippe is currently the VP EMEA (Europe, Middle East, and Africa)and his vision is listed below under the Paris office.

[edit] Paris office

Philippe's vision for the rate database

I would say , as far as airfreight is concerned that we have already a database in Paris : we compile all rates given by air carriers , carrier per carrier , and put all in a common file ( everyone in the office could have access to ) . So , as soon as we have an access we can start to enter all air rates to the CT database . If every office is able to provide airfreight export rates then ,we should be able to get something consistent in quite short time .I think we just need to enter carrier’s name , carrier’ prefix ( 057 for AF as eg. ) , reference of the tariff if any and airport of departure and arrival ( with already existing airport codes ? ).

London is dealing with an air agent so I have to check with Anshu if she has compiling some rates ( at the opposite, in Paris , we are dealing directly with carriers as you in NY ) but she is off ‘til next week . Anyway , I think this is a Isales job and I would like Anshu leading this process for all Europe . I need to talk to her when she is back .

One idea could be to have access ( as rate explorer for eg. ) : enter an airport of departure and airport of destination and see all carriers they propose rates for such trade .

We have to deal with all taxes ( fuel , IRC ,sec ) because they are not all the same per carrier , per country and this is the main topic , I think . I would suggest to deal directly with Sanja for that .

This is for our buying costs . For the selling rates , I think we have to enter it into the database as per client’s name . And if possible link it with CT operational system . As an example , you open and air file for EA from Europe to USA and depends of the trade concerned , you already have the agreed tariff directly on the billing page . CT file has already name of client , departure and arrival airport , gross and chargeable weight .

This is the first step , please feel free to give me your comment and if needed we can talk on Skype for a meeting .

Thank you

[edit] HK office

Chikei's vision for the rate database:

In the short term: As same as we are currently doing for rates ex Asia to Europe and USA, we exchange rates information through an password protected excel spreadsheet. The objective would be to have a quick access to buying rates information and provide quick quotation to customers. However the limit of this is that airfreight rates are very volatile in some period of time (e.g. peak season) and rates can change from a day to another. Handling a spreadsheet is not flexible enough to provide daily update.

In the long term: Indubitably, it will be through a platform (can be Cybertrax?) where we can maintain and share a database and where the data can be extracted for other purposes such as billing, selling rates, quotation,….etc. The objective is the same as above with some other purposes or applications but having a platform would increase the update frequency for certain main trade lanes and possibly integrate the assessment of ‘net/net rates’(net of volume cut*).

  • I would explain the volume cut principle in due course

[edit] Various types of Contracts and Tariffs And How to calculate rate from point A to point B

[edit] Questions

  • Provide examples of contracts/tariffs used by Jaguar.
  • At least one example for each type.
  • Provide example of how to manually calculate rate for specific request.
  • Attach actual contract/tariff into mantis. Post screen shot into wiki and explain.
  • If possible classify all types of existing Air tariffs.

[edit] New York office Examples

[edit] Singapore Air contract

It comes as an xls file with two tabs. See below. (Original file Singapore Air NYC Rates Apr 1 - Sep 30 2011 example rate sheet.xlsx attached to 0002894: [Rates DB] Implement phase1 for MOT Air ).

File:Singapore Air tab1.JPG

The attached spreadsheet is an example of one of the airlines tariffs.

The top of the page shows you the airline, the commodity (general cargo), any exclusion or notes and the date range these rates are valid for.

Table:

Column A is the origin of the shipment.

Column B is the name of the destination.

Column C is the Country of destination.

Column D is the 3 letter destination airport code.

Column E is the commodity type line.

Column F is the 3 letter commodity type

Column G is the minimum air freight charge for the origin and destination pairing (column A and Column D)

Column H TBD - (The – 45 kilo rate. This is the rate per Kilo from 0 K to the next weight break, in this example it is + 45 Kilo’s.

So this rate is for 1 Kilo – 44 Kilo’s, as long as the total is higher than the minimum rate.

Column I - is the + 45 Kilo rate. This is the rate per Kilo over 45 K and under the next weight break (in this example the next weight break is 100 +, so this rate is for 45K – 99 Kilo’s, as long as the rate is higher than the minimum.

Column J – Is the + 100 Kilo rate – following the same rules as Column I.

Column K – Is the + 300 Kilo rate – following the same rules as Column I.

Column L – Is the + 500 Kilo rate – following the same rules as Column I.

Column M – Is the + 1000 Kilo rate – following the same rules as Column I.

Using this drop downs on the spreadsheet, you can set filters to view multiple selections or narrow it down to just one line.

Tab 2

File:Singapore Air tab2.JPG

Example 1:

(Setting column A to NYC and Column D to AKL for a shipment from NY to New Zealand)

If you have a shipment of boxes that is a total of 5 cartons, total 20 K, and total 45 K chargeable weight going from NY to New Zealand.

You would use the dropdown to set as much information as possible.

I set A to NYC, D to AKL, and E to general. This narrowed it down to one line where I can see my rate for this shipment.


File:Singapore example 1.JPG

To calculate my rate I take my total chargeable Kilo's (45) and check the tariff according to this weight break to find which rate would apply to this shipment ($3.85). Next I compare this total with the minimum ($125.00) and take the higher rate as my cost.

45 x 3.85 = $173.25 (which is higher then the minimum of $125.00, so $173.25 is my cost)

[edit] Solent co-loader tariff

File:Solent.JPG

  • 1- This is the company name of the co loader
  • 2- Indicates that you can call for shipments not covered in this tariff.
  • 3- Indicates what is covered by this tariff and what charges will be additional. ( Ex. AWB fee is included – Fuel and Security is additional )
  • 4- This is the bottom tab of the excel sheet, indicating that these rates cover shipment departing from NYC
  • 5- Rates
    • a. Destination Column – arrival City
    • b. Code – Airport Code
    • c. Column C is hidden
    • d. The rate per K from 0-99 for Known shippers only
    • e. The rate per K from 100-299 for Known shippers only
    • f. The rate per K from 300-499 for Known shipper only
    • g. Column G is hidden
    • h. Column H is a space holder
    • i. The rate per K for 0-99 K for Unknown shippers
    • j. The rate per K for 100-299 for Unknown shippers
    • k. The rate per K for 300-599 for Unknown shippers
[edit] Email exchange for rates

File:Email Exchange example.JPG

  • 1- The bottom portion of the email, you will see that Gabrielle (NY Export Operator) is requesting an air tariff from Aeronet (Co-Loader).
    • a. You will see that she indicates she needs the rate going to TPE (this is the airlines code for Taipei).
    • b. She also indicates that this is ID8000. This is because she is looking for a rate for cosmetics. Cosmetics can be considered Hazardous, but this commodity does not need a hazardous UN number. She is advising the co-loader that the freight is ID8000 because some airlines will charge a hazardous fee for this and some will waive the hazardous fee.
  • 2- This is the reply – the rate tariff for this specific lane,commodity, with weight breaks and minimum indicated.
[edit] Air France rates

File:NY Air France rates example.JPG


  • 1. Airline company logo
  • 2. Agreement Ref. #
  • 3. Agreement Ref.#
  • 4. Customer (our) name
  • 5. Shipper (only will be filled in if the rate applies only to a specific shipper
  • 6. Airline contact name
  • 7. Two digit airline code
  • 8. The date in which the rate becomes valid
  • 9. The date in which the rate expires
  • 10. The three digit airline code for the departure airport
  • 11. The currency the rates are in.
  • 12. Rate information
    • a. Indicates the three letter airport of arrival.
    • b. TBA
    • c. Direct flight or multiple stop flight, if filled in, would indicate if the flight was going to stop in any other airports before the final airport of arrival or not.
    • d. Indicates that these rates are for passenger aircrafts. It is important to note that because some freight cannot be shipped on a passenger aircraft.
      • a. Unknown shippers
      • b. Hazardous freight
    • e. Would note the flight number if this was for a specific flight.
    • f. Would indicate how frequently this airline moves passenger aircrafts from the departure airport to this airport of arrival. Usually noted per week.
    • g. This indicates if any minimum weight is required. If a minimum weight is required, it would work the same as a minimum charge, this means you would have to pay for the minimum kilo’s indicated here.
    • h. Minimum charge per shipment
    • i. The per kilo rate from 100 – 299 kilos
    • j. 1st weights break at 300 plus kilos. This rate is valid from 300 – 499 Kilos
    • k. 2nd weights break at 500 plus kilos. This rate is valid from 500 – 999 Kilos
    • l. 3rd weights break at 1000 plus kilos. This rate is valid from 1000 – 2999 kilos
    • m. Last weights break at 3000 plus kilos. This rate is valid for 3000 kilos and higher
    • n. This is for a high volume of freight, for the same lane, moving weekly or multiple times in a week. It would indicate the percent or amount of freight we would be guaranteeing per week in order to obtain a better rate.
      • a. For example: You could agree that you would provide the carrier with 10,000 Kilos per week. The carrier would give you a special rate for this and indicate the 10,000 kilo amount here.
    • o. This is also for a high volume of freight, for the same lane, moving weekly or multiple times in a week. This would be space allocated for your freight. If you agreed on an allocated space, it would benefit you during peak shipping times by guaranteeing the room. The disadvantage to allocated space, is that you will always pay for that space, even if it is not used. If you allocated space, the amount allocated would be listed here.
      • a. You could allocate space for 4 airline pallets on three flights a week from JFK to CDG. This means that on each of the three flights from JFK to CDG per week, the airline will reserve that space for you and will not book that space with anyone else. You in turn must pay for that space even when you are not using it.
[edit] Increased fuel surcharge notification

File:Fuel surcharge increase example.JPG

File:Fuel surcharge increase on ULD example.JPG

These are two types of notifications sent by the airlines advising increased fuel surcharges. They list the increase and effective dates.

These are received as attachments to emails.

[edit] London office Examples

[edit] Exchange Hawk Freight Services Email Exchange

File:UK Email exchange example.JPG

  • 1- The bottom portion of the email, you will see that Ginny (UK Account Manager) is requesting a spot rate from Hawk Freight Services (Co-Loader).
    • a. You will see that she indicates she needs a rate from the pick up location to Tunis airport.
    • b. She advises this shipment is considered Non-hazardous.
    • c. She includes the commodity description.
    • d. This is the details of this specific shipments handling units.
    • e. She advises the pickup location's zip code, so they can include the trucking from the pickup location to the airport of departure in the quote.
  • 2- This is the reply – the spot rate for this specific shipment.

[edit] Paris office Examples

[edit] British Airways General Contract Rates

File:BA general contract .jpg

  • 1 Indicates the airline name
  • 2 Indicates that these rates are the published rates (general contract rates)
  • 3 Is the table of rates
    • column a - space holder
    • column b – Indicates the Destination City Name
    • column c – Indicates the destination region
    • column d – Indicates the destination 3 letter code
    • column e – TBD
    • column f – Indicates the per kilo rate starting at 100 K to 499 K
    • column g – Indicates the per kilo rate starting at 500 K to 999 k
    • column h – Indicates the per kilo from 1000 k and over

[edit] British Airways Jaguar Contract Rates

File:BA Contracted Rates.jpg


  • 1 – Indicates this contract rate agreement is with Jaguar Freight CDG office with contact information and account / IATA number
  • 2- Indicates the contract reference number
  • 3 – Indicates this rate is for shipments departing from CDG airport
  • 4 – Indicates the currency the rates are listed in
  • 5 – Table of rates
    • column a- Indicates the destination airport name
    • column b – Indicates the destination 3 letter airport code
    • column c - Indicates the 3 letter airport code of the trans-shipment airport
    • column d – Indicates the rate for 100 to 499 K
    • column e – Indicates the rate for 500 to 999 K
    • column f – Indicates the rate for 1000 to 1999 K
    • column g – Indicates the rate for 2000 + K
    • column h – N/A
    • column i- Indicates the date the rates become valid from
    • column j – Indicates the date the rates are valid until

'’’Etihad Airways Rate Sheet’’’ File:Etihad contract.jpg

  • 1 – Indicates the two digit code for the airline
  • 2 – Indicates the issuing sales office three digit airport code
  • 3 – Indicates the Currency the rates are listed in
  • 4 – Indicates that this is for bulk freight or loose freight (not containerized or palletized)
  • 5 – Indicates these rates are good for shipments booked on a prepaid basis (Meaning the freight charges are paid for at origin)
  • 6 – Contract reference number
  • 7 – Indicates the date range this contract is good for
  • 8 – indicates Jaguar Paris’s name, code, and branch
  • 9 – Rate Table
    • a. Indicates the origin zone
      • zone covered under 11
    • b. Indicates the three letter airport code for the destination airport.
    • c. Is the minimum charge
    • d. is the rate per Kilo from 1 k to 44 K
    • e. is the rate per kilo from 45 k to 99 k
    • f. Is the rate per kilo from 100 k to 249 k
    • g. Is the rate per kilo from 250 k to 499 K
    • h. Is the rate per kilo from 500 K to 999 k
    • i. Is the rate per kilo for 1000 k and above
  • 10 Indicates additional terms of the contract
  • 11 indicates which airports are covered under the FR1 origin zone.

Esse Emme Contract

File:Esse emme email agreement coloader.jpg These rates are received in an email

  • 1 – indicates the service (non- stop), carrier (Airline), origin and destination pairing, and the rates broken down by the weight breaks
  • 2 – additional terms to the contract
  • 3 – Indicates the ‘’’FOB’’’ or ‘’’Freight On Board’’’ charges- These are the costs associated with picking the freight up from the pickup location through being loaded on the aircraft.

[edit] Hong Kong office Examples

[edit] Hong Kong Air Rates

File:Hong Kong Air Rate.JPG

This excel spreadsheet is emailed to our co-loaders monthly for updates.

  • 1 Each departure airport has its own tab. HKG is the three letter airport code the Hong Kong, so this tab includes the rates for shipments that are departing from Hong Kong airport.
  • 2 This sheet is divided into sections; each arrival airport has its own section. The first section is for shipments arriving into CDG. CDG is the three letter airport code for Charles De Gaulle airport in France.
  • 3 This is the able of rates.
    • Column a is the two digit airline code, AF is Air France
    • Column b is the currency the rates are. These are in US dollars.
    • Column c is the rate per Kilo starting a 45 K and up to the next weight break, which is 100 K. Since this is blank, they are not offering a rate for shipments under the next weight break of 100
    • Column d is the rate per Kilo from 100 K – 299 K.
    • Column e is the rate per Kilo from 300 K – 499 K.
    • Column f is the rate per Kilo from 500 K – 999 K.
    • Column g is the rate per Kilo from 1000 K and above.
    • Column h is the per Kilo rate for security surcharge
    • Column I is the per Kilo rate for the fuel surcharge
    • Column j indicates if these rates are booked on a direct or deferred (with trans-shipment points) flights.
    • Column K indicates the transit time from departure airport to arrival airport.
    • Column L indicates the last time these rates were updated.


[edit] Misc

Types and Examples of Air contracts

Examples attached to Mantis http://ct.jaguarfreight.com/mantis/view.php?id=2894 .
Sample XLS Quote form.  This is what the ISales department uses to create quotes.
Sample PDF Quote form.  This is a copy of the quote generated from the above.
Sample XLS Quote Report.  Steven Inside Sales Manager has been assigning a quote number to each quote he creates and logging these into  an excel sheet to keep track.
Sample of Co-loaders tariff - This is an example of one of the tariffs inside sales uses to search rates offered by one of our co-loaders.  
Singapore Rates - This is an example of one of the airlines rate tariffs used by inside sales to search rates offered by an airline.

[edit] Tariff management systems (known and in use by Jaguar)

[edit] Q

Please find and describe in details any tariff management systems that:

  • a) Jaguar is using
  • b) know but not used in Jaguar

[edit] A

Towne Air Management System

http://www.towneair.com

Requested login: JAGUARF Request pwd: FREIGHT

After logging in go to Customer tools

Then click on simple quotes

Select the origin airport

Select the destination airport

Enter the shipments weight

Enter the ship date

Click submit

This generates a simple quote form listing your costs.

Please keep in mind that although this is showing airport to airport, this is really for moving via truck – but it is an example of an online tariff system.

Air France online TBD

[edit] APPENDIX Bits and pieces

  • Other CT2 components related to Rates DB Air
    • Please explain what do we already have in CT2 that is related to Rates DB.
Personal tools