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 Location Aggregation Level.

• GBU

• Group of Activity

• Activity

• Region (Ship Destination Zone)

• Plant (Ship Destination)

Inventory DOS

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]

• 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

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

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

Joëlle Hilaire / Christian Backaert

Diogo Paiva / Vendula Sianska

Financial Working Capital

Finance Corporate Function

Charlotte Rollier

Working Capital

Supply Chain Excellence

Charlotte Rollier