Page History

External Sales

CRM Analytics dashboard Sales Performance

Alignment with CRM Analytics 

• GBU

• Group of Activity

• Activity

• Region (Ship-To Zone)

• Plant

• Product Line

• Archetype

Constrained Forecast & Budget for the 2 next months

Constrained Forecast 

Budget : budget by default, then replaced by BFR6 when available

Alignment with CRM Analytics 

• GBU

• Group of Activity

• Activity

• Region (Ship-To Zone)

• Plant

Orderbook & Orderbook Repartition

CRM Analytics dashboard Orderbook (external sales only)

View of the Invoiced, Shipped Not Billed, Confirmed, Not Confirmed, and Open Orders upon 3 months (Current month M, M+1 and M+2), plus the previous month and the same month last year to compare

Total Repartition of the orders split over 3 months (Current month M, M+1 and M+2)

Alignment with  Customer Engagement Analysis 

• GBU

• Group of Activity

• Activity

• Region (Ship-To Zone)

• Plant

• Product Line

• Archetype

DSO & Best DSO (Receivables)

SBS KPIs dashboard DSO & Best DSO

Days of Sales Outstanding of the Account Receivables

• GBU

• Group of Activity

• Activity (Sub-Activity)

• Region (Payer Geo Zone)

CCR Orderlines (‰)

CRM Quality dashboard CCR (Customer Complaints Rate) for 1000 Orderlines

• Monthly CCR 

• 12-months rolling average

• GBU

• Group of Activity

• Activity

• Region (Ship Destination Zone)

• Plant (Resolution site)

OTIF (On Time In Full)

Customer (Delivered) Requested & 1st Confirmed

Departure Plant Requested & 1st Confirmed

Global Supply Chain dashboard OTIF

• Split by number of OTIF and non OTIF orderlines

• OTIF rate

• GBU

• Group of Activity

• Activity

• Region (Ship Destination Zone)

• Plant (Ship Destination)

• Product Line

• Archetype

Direct Spend Trend and Repartition

Indirect Spend Trend and Repartition

SBS Purchasing dashboard Spend

Trend of the Spend by Region

Repartition of the Spend by:

• Domain

• Segment

• GBU

• Region (Plant Zone)

• Plant

External Sales

BW_QRY_MVCOPA01_0004

Chemlogics : BO : SALES TREND & MANAGEMENT REPORT with CONTRIB-MARGIN (period) CWWPPE_R001

Composite Materials: All Order book data (WP1 + Baan + PE1) are added on a weekly basis using a flat file from CM (no longer daily OB updates for WP1 perimeter)

External sales only

Consolidated Entities

Peroxides: JV figures cut (companies 0360, 5985, 6034, 6235)

'Specialty Polymers: excludes HFCN / SOLVAY FRANCE (FR)'

Constrained Forecast

GBUs in Dynasys: BW_QRY_MVDYN11_0001  

Specialty Polymers: NA

Aroma Performance
Novecare
Peroxides
Silica
Soda Ash
Special Chem
Technology Solutions

Budget

BW_QRY_MVSDSO61_0001

BFR6: latest update 

Special Chem: Commercial Roadmap in SalesForces

Orderbook & Orderbook Repartition

Sales Orders: BW_QRY_MVSDSO41_SD004

PO Orders: BW_QRY_MVSDSO47_001

Chemlogics : BO : ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001

Composite Materials:

• Before August 2021: flat file*

• Starting August 1st, 2021, BW query, like the other GBUs

* All Order book data (WP1 + Baan + PE1) are added on a weekly basis using a flat file from CM (no longer daily OB updates for WP1 perimeter)

External sales only

Consolidated Entities

Peroxides: JV figures cut (companies 0360, 5985, 6034, 6235)

Composite Materials: Product Line Level not available

DSO & Best DSO (Receivables)

BW_QRY_MVFIAR01_0001

When no GBU is selected, the Group DPO includes  CBS&Others  and  Energy Services  to align with the Values communicated by the Credit Management team 

• GL Account Subtype = Products & Services

• PRS Customer
  <> 2200000000 CLIENTI
  <> 1039781 SIEMENS FINANCE & LEASING GMBH

CCR Orderlines (‰)

Complaints : CRM Salesforce.com and iCare for Specialty Polymers

Order Lines : BW_QRY_MVSDSO57_0001

Severity: All except anomalies

Internal complaint = No

Justified/Valid Complaints = Yes

Additional filters for Specialty Polymers:

• Status ≠ Archived & Rejected

• Product Family ≠ Monomers

• Valid = Yes AND Blank

Orderlines: Intra-GBU = No

OTIF (On Time In Full)

QVSCE_BW_QRY_MVSDSO51_0001

QV_BW_QRY_CPSDSO51_0001 for Composite Materials (this query contains the AERO Market, the AERO Program and the Shipping Point)

Intra GBU = No
Order Doc Type is different from UB or NB (replenishment excluded)

Direct Spend Trend and Repartition

Indirect Spend Trend and Repartition

BW_QRY_MV_SPD01_0004

Internal Partner = No

Spend including 100% JV

Domain: Logistics, Packaging, Energy and Raw Materials only