1/ Purpose of the Tool - Pre-carriage & Sea
This tool has been created to provide access to
- a rate catalogue for the Pre-carriage and Sea transport and have estimated of costs.
- the nominated carriers/haulier and information for specific trade lanes, based on GBUs request in FCL Global Tender
2/ How to search in the data base?
Select "Pre-carriage & Sea" tab on the rate dashboard
From the filters below, you can search and sort results in the table. By default, in the Classic View goods are considered non-dangerous and currency is EUR. Additional filters are available in the More Details view.

If you are looking for a rate indication only, we recommend you to filter first on ORIGIN (Plant or/and port) and Destination (Port or/and Site), then to adjust your search.
If you are looking for an exact rate and awarded lane, you can start by filtering on your GBU, on the top left corner of the filters.
You can sort the results in the table by clicking on the column name.
To start a new research, press "Clear All" button.
Please note that data is refreshed once a day only.
3/ How to read the data base results?
There are 3 views:
- Total Cost
- Pre-carriage
- FCL WW
The Total Cost view combines the Pre-Carriage and FCL flows. The purpose of this combination is to obtain the Total Cost of Ownership (TCO).
Due to external factors the Total Cost view is not fully .....
- Understand the exact content of each column
Total Cost View
| Column Name | Description | Classic View | More Details | Awarded Solution |
|---|
| Award | Nomination of the Sea Carriers for a specific trade lane. There are 3 possibilities: - P = 100% (to use in priority)
- BACKUP = 0 % (to use only if primary cannot deliver)
- Percentage
| | | X |
| GBU | Global Business Unit | X | X | X |
| Plant of Origin | The plant name or the location where the goods are picked up | X | X | X |
| Port of Origin | Location of the port of load | X | X | X |
| Port of Destination | Location of the port of destination. | X | X | X |
| Site of Destination | Location where the goods are delivered. It could be a port or the final destination. | X | X | X |
| Transport Mode | Mode of transport used from the plant to the port of load | X | X | X |
| Type of packaging | Type of container | X | X | X |
| Merchant/Carrier | The actual | | | |
Column Name | Explanation | Available in View |
|---|
Service package (ATA, DTA,DTD) | Rate is for : Airport to Airport (ATA), Door to Destination Airport (DTA), or Door to Door (DTD) | All |
|---|
Site of Origin | Location of pick up of the goods (only applicable to DTA and DTD rates)
If "N/A" rate is ATA | All |
|---|
Departure Airport | IATA CODE, usually only for information except for ATA rates | All |
|---|
Destination Airport | IATA CODE, location of end of transport for DTA and ATA rates
For DTD, for indication only | All |
|---|
Destination Airport Name | Name related to Destination Airport IATA Code | All |
|---|
Final Destination | Place of delivery in case of DTD rates, | All |
|---|
GBU | Global Business Unit | All |
|---|
Supplier | Supplier offering this specific service under those specific conditions | All |
|---|
Award | Nomination given to the supplier on this specific lane
100% = primary (to be use in priority) 0% = backup (to be use only if primary cannot deliver) | All |
|---|
Currency | Currency in which rates are display (can be different from currency of negociation or payment)
For currency of negociation, refer to "Currencies" | All |
|---|
Minimum Price (Unit) | Minimum invoiced per shipment on this tradeline, if "price per kg*number of kg" > "Minimum Price", minimum if not applicable | All |
|---|
Rate C-Consolidated Service (per kg) | Rate per kg (gross weight) for C-Consolidated service (freight forwarder consolidation 96-120 hours airport to airport) | All - NDG |
|---|
Rate A-Direct Service (per kg) | Rate per kg (gross weight) for A-Direct service (quickest service with direct flights 24 to 48 hours airport to airport) | All - NDG |
|---|
Rate A-Direct DG Service (per kg) | Rate per kg (gross weight) for A-Direct service for dangerous goods (24 to 48 hours airport to airport) | All- DG |
|---|
Rate Others Services (per kg) | Rate per kg (gross weight) for services others than C-Consolidated, A-Direct, A-Direct DG | All |
|---|
Others Service Description | Type of service request by the GBU: VUN, Temperature Controlled, DG Cargo, HOT, … (All definition are available in requirement documents) | All |
|---|
Transit Time C-Consolidated Service
| Total transit time based on "service package (ATA, DTA, DTD)" for C-Consolidated service | More details - NDG |
|---|
Transit Time A-Direct Service | Total transit time based on "service package (ATA, DTA, DTD)" for A-Direct Service | All - More Details |
|---|
Transit Time Others Service
| Total transit time based on "service package (ATA, DTA, DTD)" for Others Service | All - More Details |
|---|
Number of departures per week C-Consolidated Service
| Number of departures / available flights per week for C-Consolidated Service | NDG - More Details |
|---|
Number of departures per week A-Direct Service
| Number of departures / available flights per week for A-Direct Service | All - More Details |
|---|
Number of departures per week Others Service
| Number of departures / available flights per week for Others Services | All - More Details |
|---|
SAP Route Service C-Consolidated
| SAP Route created by SBS Data Log (Lisbon team) for Service C-Consolidated | NDG - More Details |
|---|
SAP Route Service A-Direct
| SAP Route created by SBS Data Log (Lisbon team) for Service A-Direct | All - More Details |
|---|
SAP Route Service C-Consolidated - Shipping Point 2
| SAP Route created by SBS Data Log (Lisbon team) for Service C-Consolidated - if Other Departure Shipping Point | NDG - More Details |
|---|
SAP Route Service A-Direct - Shipping Point 2 | SAP Route created by SBS Data Log (Lisbon team) for Service A-Direct - if Other Departure Shipping Point | All - More Details |
|---|
SAP Route Service A-Direct DG | SAP Route created by SBS Data Log (Lisbon team) for Service A-Direct DG | DG - More Details |
|---|
SAP Route Others Services
| SAP Route created by SBS Data Log (Lisbon team) for Others Services | All - More Details |
|---|
"Classic View" vs "More details"
The tool is offering two different views. The first one by default is the "classic view", giving a overview of rates for different services and supplier information.
By clicking on "More details", you will access more data on transit time, number of departure per week, as well as SAP route information.
The tool can display in 3 currencies, the currency name is always available in "Currency" column of the table. The default currency of the tool is EUR, but the user can choose to use:
Origin currency = currency of negotiation and contractEURUSD
Dangerous and Non Dangerous goods
The tool can provide rates for either non-dangerous goods or dangerous goods (if available). The default set up of the tool is NDG (non dangerous goods).
This clicking on DG (Dangerous Goods), rates and information display will be valid for dangerous good transportation (subject to DG class and UN Code being accepted by airline).
This information is based on the needs from the GBU expressed in the tender and on the entity paying the freight.
Inbound : Shipper is the exporting site and freight is paying by origin.Outbound: Shipper is the receiving site and freight is payed by destination
How to download your results?
If you are willing to have a copy of your results in a excel format, use right click and select "send to excel". A pop-up window will appear and press on the link. Your results will be then available in your "downloads".
4/ Airfreight Tender Requirements
Access the full tender document package using links and find out all details on:
General conditions contract conditions overview payment terms preliminary information shared with suppliers
Technical requirements rate structure, currency of negociation and fuel surcharge mechanismlevel of service descriptioncancelling conditionsspot trigger rule
Product and Sites Requirements loading timespecific site requirement (based on information received from supply chain)product specification and packaging dimensions
Access to documents: APAC - EMEA - NAM
All suppliers should send a monthly activity report, if you interested to receive it, please reach out to your local contact at PSCE.
5/ Conditions of air freight rates
Jet Fuel Calculation, Revision Schedule & Monitoring (Link)
Additional charges (Link)
Costs at destination (Link)
Selected suppliers and contact matrix and supplier codes (Link)
Validity
Contract is valid for 3 years from 1st of June 2018 to 31st May 2021
Rates are valid for 1 year (2 rates revision during contract period)
Fuel can be adjusted every 4 months (refer to technical requirements or Jet Fuel Calculation, Revision Schedule & Monitoring (Link))
All revisions will be monitored by Global Airfreight buyer and communicated to the Regional/Local buyers, as well as the suppliers. Rates available in the tool reflect prices adjustment.
By default, rates displayed are valid for the current period, if you need to access rates from a different period, please select the period by clicking on the button:

Rates for future period will be available few weeks before implementation.
6/ Spot Rates
EMEA: Airfreight Spot request EMEA
NAM: Process TBC
APAC: Process TBC
Contact List Suppliers:
Ask for Route creation in SAP
Using direct link : Route Creation Request
or
Freshdesk / Submit request / OtC

7/ Historical data
The tool is giving visibility on the rates for 12 to 16 months. Historical data is stored in XXX and can be available on request to XXX.
Access to raw data from Qlikview data base (Link).