Plan - E2E Value Chain

Forecast Accuracy

Global Supply Chain dashboard Forecast Accuracy 3.0

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)

Charts and reports are made to display 2 types of data : 1/ data by GBU or 2/ data all GBU combined. 

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) / [(sum of last 3 Months  sales value )*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".

Note 3: if you need the values for DOS Value for ALL GBUs in a table, use "my report" functionality and extract DOS GBU by GBU .

• GBU

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 ]. Note since June 2023- Blocked stock is no longer reported in SMOG value
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

Removed as the source does not exists anymore

• GBU

• Group of Activity

• Activity

Working Capital

Global Supply Chain dashboard Working Capital - archive

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 -

Source Gsheet for ECO

Source Gsheet for SCO

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 => removed as the source does not exist anymore

Working Capital

Revenue: WCAP_BW_QRY_MVFIWC01_0013

Volumes: WCAP_BW_QRY_MVFIWC01_0014

Forecast Accuracy

Laure Breteau-Laurent / Christian Backaert

Inventory DOS

Laure Breteau-Laurent / Christian Backaert

SMOG - Slow Moving Obsolete Goods

Laure Breteau-Laurent / Christian Backaert

Working Capital

Finance / Supply Chain Excellence