Plan - E2E Value Chain

Forecast Accuracy

Global Supply Chain dashboard Forecast Accuracy

Picaso for Specialty Polymers

• Forecast Accuracy at Month M-1

• Forecast Accuracy at Month M-2

• Forecast Accuracy at Month M-3

In the E2E VC Dashboard, the Forecast Accuracy is based on the Weighted Calculation at the Product x Ship Destination Zone x Group of Activity Aggregation Level for all GBUs using Dynasys or APO as their Demand Planning System.

For Specialty Polymers, the Forecast Accuracy is based on the Standard Calculation at the Product x ECCO Region (Ship Destination Zone) Aggregation Level.

ECCO regions may be retrieved under the Corporate Region filter as follow: EMEA = EU, APAC = IN, JP, KR, VD, SG, LAM = MC, NAM = US

• GBU

• Group of Activity

• Activity

• Region (Ship Destination Zone)

• Plant (Ship Destination)

Inventory DOS (Manual)

Inventory Visibility Tool

DOS : Days of Sales. Is a DOS on sales, not on COGS

Inventory values : line “total inventory value” : includes FG/RM/Wip. Spare Parts are part of RM

Sales Values :

For GBU : based on “Net sales at GBU level”

For Group : based on “External sales”DOS calculation: (End-of-Month Inventory*365) / [(last 3 Months sales)*4]

Note 1: there is no target for the actual DOS of 2021 as the most relevant calculation for the Group

Note 2: if you need the values for ALL GBUs in a table, then right-click on the graph when no GBU is selected and select "Download as", "Export data" to get the results in an Excel file. For other needs, you may use "My Report".

• GBU

• Group of Activity

• Activity

• Region (Ship Destination Zone)

• Plant (Coming soon)

SMOG - Slow Moving Obsolete Goods

Slow Moving, Obsolete & Off-Grade Inventory for Finished Goods, Raw Materials, Intermediates, and Trading Goods

Sum of (by importance order to avoid double counting) :
1 - Blocked stock : stock types [ C Blocked Stock Returns + D Blocked Stock + E Restricted-Use ]
2 - Expired stock : batch shelf life passed
3 - Slow mover : batches older than 12 months (date of today versus manufacturing date of the batch)  

Value (k€) and Quantity (T)

• GBU

• Group of Activity

• Activity

• Region (Plant Zone)

• Plant 

• Product Line 

• Archetype 

Financial Working Capital

Finance Cockpit

Available in Value (k€)

• GBU

• Group of Activity

• Activity

Working Capital

Global Supply Chain dashboard Working Capital

Available by

• Account Group

• Account Inventory Group

• Account Sub-type

• GBU

• Group of Activity

• Activity

• Region (Plant Geo Zone)

• Plant

Forecast Accuracy

GBUs on Dynasys: BW_QRY_MVDYN11_0005

Specialty Polymers: Picaso

There is no data for Coatis, Composite Materials and Special Chem for the moment.

Exclusions for Specialty Polymers:

• Mat Field 4 = HCL, Others and 140 (by-products)

• Mat Field 3 = Raw Material, HF, MVE, OBS, PFE, SMILE, TECHNYL, VDC, Vinileters, WAM

• Sold-to <> Solvay or Rhodia

Inventory DOS

Manual File from Corporate Finance sent on a Monthly basis +/- 13th of the Month -

New query in progress QVDOS_BW_QRY_CPFIWC04_0001

SMOG - Slow Moving Obsolete Goods

BW_QRY_CPMMIM02_0001

Data available starting January 2020

Financial Working Capital

Finance Cockpit - Publication

Working Capital

Revenue: WCAP_BW_QRY_MVFIWC01_0013

Volumes: WCAP_BW_QRY_MVFIWC01_0014

Forecast Accuracy

Pilar Gamboa

Diogo Paiva

Inventory DOS

Joëlle Hilaire / Christian Backaert

Charlotte Rollier

SMOG - Slow Moving Obsolete Goods

Hélène Vrot / Christian Backaert

Diogo Paiva 

Financial Working Capital

Finance Corporate Function

Charlotte Rollier

Working Capital

Supply Chain Excellence

Charlotte Rollier