General Description

The main objective of this dashboard is to give Solvay’s Supply Chain family a tool with key performance indicators that help pilot supply chain activities and based on aligned definitions.

Commercial KPI	Planning KPI	Logistics KPI	Procurement
OTIF Leadtime Order processing Customer Service : orders details	Forecast Accuracy Inventory (link to other Inventory dashboard and definitions)	CO2 Emissions Transport Cost, Volumes Loading Time Haulier On Time Delivery and Shipment Inventory Volumes (BW)	Procurement rates (link to other Procurement rates dashboard and definitions)

Detailed KPI Pages

KPI dimensions

KPI targets (draft)

Source of data	In Bi4, data are only available for PAX/Pepol GBUs. In BW (WCAP, TIERS, OBAS,), data are only available for SAP companies. In BFC, data are available for all the consolidated companies, including the non SAP companies.
Update	Daily reload of the current and previous year, the dashboard will update as soon as extraction job from SAP is finished (variable time). Users can see at all time from which day is the data they are looking to thanks to the date indicated in the top left corner of the dashboard. The most recent data Tableau can display is at D-2.
Period	All KPI : Current year + year -1, Forecast Accuracy : Current year + Year -1 and Year -2. Note that you will not be able to find current month in the filters in the FA page as the FA figures for current month are only available the following month.
Archives	note: every year on Dec 31st, an archive is created and displayed in the access point. Data in this archive is frozen so new evolutions and corrections won't be available in this application. Previous KPI , definitions held <GSCD Archives>
Units	Weight: Net Weight = weight of active materials sold Gross Weight = weight of all materials (active or not) and the packaging Currency: EUR / USD Conversion rules: Transportation Costs (Query TIERS): conversion from a local currency to EUR or USD is based on the exchange rate managed by Finance. For each cost, the rate considered is the one of its reference month. The reference month of a transportation cost is : the actual completion month the planned completion month if the actual completion month is not available the shipment creation date if the planned completion month is also not available Inventory Values in Finance (BFC) : conversion from a local currency to EUR is based on the exchange rate managed by Finance. For each inventory value, the rate considered is the one of the inventory month. For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR). So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.

Target Users

Supply Chain Managers
Supply Chain Operational
Supply Chain Excellence
Logistics
Customer Service
Account Managers

Authorization & Rights

To get access to the Global Supply Chain Dashboard, raise a ticket on Service One (Corporate dashboard).

All the accesses must be validated by:

GBU specific Contacts or Supply Chain Excellence

Alsachimie : Marielle Lorusso
Aroma Performance : Marie PEREIRA
Coatis/Fibras : Marcia TOKUDA
Composite Materials : Ihab Elia (*China users: access must be denied for Composite Materials)
Novecare : Jose Pablo Leyva
Oil&Gas : Charles Aymes
Performance Polyamide : Emmanuel Hatt
Peroxides : Benoît HORNYAK
Polytechnyl : Damien RAMOS
Silica : Philippe DELORO
Soda Ash : Fabien PIRET
Special Chem : Anne VANESSE
Specialty Polymers : Beth BOUCHETTE
Technology Solutions : Louise MARDLING
Eco: Sonali Desale & Christian Backaert
Sco: Laure BRETEAU-LAURENT

Page tree

Until end June 2023 - QlikView dashboard <link> - Note : QlikView interface will be decommissioned in Dec 2023

From July 2023 Migration to Tableau dashboard <link>

Sonali Desale / Christian Backaert for Eco

Mathieu Pourque / Laure-Breteau Laurent for Sco

Antoine Frangieh

Donia Rachdi

General Description

The main objective of this dashboard is to give Solvay’s Supply Chain family a tool with key performance indicators that help pilot supply chain activities and based on aligned definitions.

In Bi4, data are only available for PAX/Pepol GBUs.

In BW (WCAP, TIERS, OBAS,), data are only available for SAP companies.

In BFC, data are available for all the consolidated companies, including the non SAP companies.

Update

Period

All KPI : Current year + year -1,

Forecast Accuracy : Current year + Year -1 and Year -2.

Note that you will not be able to find current month in the filters in the FA page as the FA figures for current month are only available the following month.

Archives

note: every year on Dec 31st, an archive is created and displayed in the access point. Data in this archive is frozen so new evolutions and corrections won't be available in this application.

Previous KPI , definitions held <GSCD Archives>

Units

Transportation Costs (Query TIERS): conversion from a local currency to EUR or USD is based on the exchange rate managed by Finance. For each cost, the rate considered is the one of its reference month. The reference month of a transportation cost is :

the actual completion month

the planned completion month if the actual completion month is not available

the shipment creation date if the planned completion month is also not available

Inventory Values in Finance (BFC) : conversion from a local currency to EUR is based on the exchange rate managed by Finance. For each inventory value, the rate considered is the one of the inventory month.

For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR).

So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.

Supply Chain Managers

Supply Chain Operational

Supply Chain Excellence

Logistics

Customer Service

Account Managers

To get access to the Global Supply Chain Dashboard, raise a ticket on Service One (Corporate dashboard).

All the accesses must be validated by:

GBU specific Contacts or Supply Chain Excellence