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:

1. Total Cost
2. Pre-carriage
3. 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

• "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.

• Currencies

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 contract
  • EUR
  • USD

• 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).

• Inbound vs Outbound

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 mechanism
  • level of service description
  • cancelling conditions
  • spot trigger rule
• Product and Sites Requirements 
  • loading time
  • specific site requirement (based on information received from supply chain)
  • product specification and packaging dimensions

Access to documents: APAC - EMEA - NAM

• Standard reporting template

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)

• 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

• Request a rate

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 

• Supplier Contact Matrix

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).