Jose-Ignacio Patino


Ayoub Kadioui - Stéphane Bourgeaud-lignot





Scope of the Dashboard

External sales from all GBUs. Internal sales are being reintegrated in the dashboard for some SpP and CM specific usage.

Not Included : 

  • Corporate Business Services (SBS, ...) : TSA, operations for customers / partners such as BASF or Dow.
  • GY - Energy Services / SES
  • All the Services on all GBUs  

Delta is approx. 570M€ with the P&L (Net Sales + Revenues from non-core activities) in 2020.


Data Sources


GBU

Sales
incl. ICM
+ PT

Orderbook
+ Orderlines
(CCR)

OTIFForecast

Opportunities
+ Complaints
+ Contacts

Overdue
& DSO
Service LevelsNPS
PA

BW
P&L

MVCOPA

BW
Global
Sales

MVSDSO

BW
Global
Sales

MVSDSO

BW
Dynasis

MVDYN

Core CRM
(SalesForce)
BW
Financial
Account
Receivable

MVFIAR



Flat File
CT
CS
PE
SI
SD
CH
TS
OGN/A*
SPPicaso QVICARE CRM
(SalesForce)
CM (after jul. '21)

BW
Dynasis

ICARE CRM
(start. 03/22)
CM (before jul. '21)Monthly
Flat File

Weekly
Flat File

P/A
(01/2020)

N/AP/A
(01/2019)

N/A

N/A : Not Available

P/A : Partially Available (starting date)

*OG GBU is not yet under SalesForce, which means that their opportunities / complaints (and all SFDC objects) are still showing under the former GBUs : Mostly CS & TS (but maybe also CT, CH, PA ...)


Below a summary of Accuracy and confidence of each kind of indicator. Please refer to the footnote when needed.

GBU

Revenue

ICMVolumeOTIFForecast

Opport.

Compl.
+ CCR

Overdue
& DSO
Service
Levels
NPS
PA

+++

+++++2

+++

++++++++7
++8
CT++++1++2

+++

++++++++7
++8
CS

+++

+++++2

+++

+5+5++7
++8
PE++++1++2
+++++++++++7
++8
SI++++1++2
+++++++++++7
++8
SD++++1++2
+++++++++++7
++8
CH++++1++2
+++++++++++7
++8
TS++++++++2
++++5+5++7
++8
OG++++++++2
+++N/A5N/A5++7
++8
SP++++++++2
-4++++++++7
++8
CM (after jul. '21)++++++-3

+++

N/A6N/A6++7
++8

+++ : High Accuracy // ++ : As good as possible // + : Globally good, need to read the advices // - : Issues on these indicators


1 : For some GBUs, we can face some inaccuracies on ICM, specially when the sales are done through selling companies (Company 0001, 0005, ...)

2 : Volumes are depending on the VKG conversion in SAP. We know that some volumes can't be converted in KG (Services, Energy, other kind of products ...), therefore we face very minor inaccuracy

3 : For CM, the volume is a big challenge. From 40+ units (sq. meters, liters, cubic feet, units, ...) they need to maintain the conversion in VKG in SAP, which seems not to be accurate as of now.

4 : We take the forecasts from a SpP Specific Qlikview server in the US where a supply chain dashboard has been developed a few yers ago. It seems that we have some conversion issues as of now (currently being investigated by the GBU).

5 : OG GBU historical data has been "reshaped" excluding the carved-out activities from the former GBUs to virtually recreate the historical BW data (sales, orderlines, ...) for OG. The opportunities and complaints are still on the former GBUs (mostly TS and CS) since OG didn't roll out under SFDC yet. Therefore TS and CS have extra opportunities and complaints. On the other side, OG orderlines are already excluded from TS and CS to be attached to the newly created GBU : therefore the CCR is wrong for the 3 GBUs until Complaints are assigned to Oil & Gas

6 : Opportunities for CM should be available in March 22. Complaints will be handled in CM's historical tool for now. Therefore they are not integrated in the dashboard for now.

7 : Overdue and DSO is neither based on Sold-To nor Ship-To KA but on Payer dimension. In this dashboard, we linked the Overdue and DSO based on Corporate Sold-To Group code = Corporate Payer group code. First of all, we know that it is not 100% accurate. Then the Corporate Payer Group is only available for the top customers. Therefore we may face discrepancies in some cases (shared payment services, factoring, ... ). In case a Corporate Payer group needs to be updated / created, please contact SBS CCT teams.

8 : We would like to emphasize that we have a very few answers to the NPS survey as of now, which lower its accuracy. In addition to that, the NPS is not linked to a given GBU, therefore only users with an access to all GBUs will be able to see the NPS.


Specific Dimensions

The opportunity processes have been aligned between CORE CRM and ICARE CRM in the frame of Opportunity playbook project. 

GBUCorporate
Groups
ShipTo
KA
AERO
Dimensions
Corp/GBU
Segments

Notes
PA


CT


CS


PE


SI


SD


CH


TS



OG

Corporate Groups are common to all GBUs. Concerned ShipTo KAs have been replicated for TS / CS ShipTo KAs
SP

Manual Updates on a regular basis for these dimensions. Can lead to discrepancies with other GBUs.
CMXXOnly in
MVCOPA
X
Corporate Groups being manually updated. ShipTo KA not updated yet in GBR : It is derivated from the AERO dimensions for now. Segments are filled-in directly in SAP (since no SFDC), but since Corporate Groups are not yet accurate, we may face corporate segmentation discrepencies.