Versions Compared

Old Version 2

changes.mady.by.user Miriam Luttrin

Saved on

compared with

New Version Current

changes.mady.by.user Rachdi, Donia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
titleSupply Chain Excellence
Christian Backaert for Eco


Info

 

 

Image Removed

false
Info
icon
titleProcess OwnerDemand managers
ECO: Ludovic ROUX
GBU Sales & Marketing / Finance
Info
iconfalse
titleD&PS ExpertData Product Owner
Donia Rachdi
Miriam Luttrin

General

Description

Description 

The
Analytics Dashboard was developed alongside the CRM project and is designed to facilitate analysis and reporting of data related to the following areas:

Orderbook

Sales Performance (Actuals)

Overdue & DSO

Opportunities

Quality

SPM

Solvay Report

Info
iconfalse
titleTarget Users
  • Sales
  • Marketing
  • Controlling
  • Supply Chain
  • Quality
Info
iconfalse
titleAuthorization & Rights

All the accesses must be validated by:

GBU CRM Champions

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.

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 KPIPlanning KPILogistics KPIProcurement
  • 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)

Detailed KPI Pages

KPI dimensions

KPI targets (draft)


Source of data

Image Added

  • 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 the data was taken from BW thanks to the date indicated in the top left corner of the dashboard. Every morning, Tableau is updated to show the data from BW from the previous day at 8pm UTC. Exception: on Monday the dashboard will be refreshed with the data of Saturday 8pm UTC. 
Note: Be aware that BW refresh happens after 8pm UTC. It means that on D-day on Tableau, you will see the data from BW from D-1 at 8pm UTC, which shows the actual data as of 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.
Warning
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.
Info
iconfalse
titleTarget Users
  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers
Info
iconfalse
titleAuthorization & 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 : Isabelle Dewille
  • Specialty Polymers : Beth BOUCHETTE
  • Technology Solutions : Louise MARDLING
  • Eco: Sonali Desale & Christian Backaert
  • Sco: Laure BRETEAU-LAURENT

GSC Archive : Archive taken on 6th Jan which has data with old OTIF logic. Before New logic is applied in BW Donia adviced us to take backup. The related CRQ's are  CRQ000000071025 and CRQ000000071029.

 SummaryOrderbookSales PerformanceOverdues and DSOOpportunitiesQualitySPMSolvay ReportMy Page

KPIs

  • Orderbook
  • Sales Flash
  • Top 5 products
  • Aged overdues
  • Top 5 opportunities pending
  • Top 5 opportunities closed
  • Highlights
  • Report
  • Highlights
  • Analysis
  • Commercial Roadmap
  • Report
  • Currency Report
  • Current
  • Historical
  • Business Analysis
  • Pipeline Efficiency
  • Pipeline Monitor
  • Report
  • Complaints
  • Customer Requests
  • Samples
  • Overview
  • Customer Market View
  • SPM Report
Solvay Report
My Page