Miriam LuttrinSimone Fornai (Process Owner PSCE) |
DISCLAIMER
Please note that below information is confidential and cannot be disclosed out of Solvay's organization.
1/ Purpose of the Tool - Airfreight
This tool has been created to provide access to
If you cannot find a rate in the tool, please go to "SPOT" in Section 6
2/ How to search in the data base?
Select "Airfreight" tab on the rate dashboard
From the filters below, you can search and sort results in the table. By default, goods are considered non-dangerous and currency is EUR.

If you are looking for a rate indication only, we recommend you to filter first on departure and origin country, 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.
If you cannot find a rate in the tool, please go to "SPOT" in Section 6.
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?
| 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 | |||
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:
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.
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:
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)
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:
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).
|
All the accesses must be validated by: or Immediate Supervisor for Novecare GBU. Margin data MUST be validated by CRM Champions/Finance Directors Click here for the Access form to get access to Analytics. Access Rights and Dashboard Entry Points - Click here for descriptions. |