Jose-Pablo Leyva


Donia Rachdi


General description

This is a macro KPI coming from the finance (BFC), as a consequence, results are available after completion of Month M-1 (no data for the current month until it is completed)
The objective is to bring the information shared among the leadership team: in value and in DOS.
Concerning quantities, we take them from BW in order to give a macro visibility between: Finish Good, Raw Mat, Spare parts, Packaging...
If more information is needed, please go to the link to the Inventory Visibility Tool.
KPI:
Inventory Values (BFC)
DOS - Days of Stock (BFC)
Inventory Volumes (BW) - Only the products that can be converted in KG.
Granularity:
BFC = BFC Account
BW = BFC Account & WC Acct Subtype
Comments:
  • BW versus BFC Inventory Values: 
BW Inventory values are different from those coming from BFC.
The 2 main reasons are : the organization perimeter (only SAP companies in BW and all companies even non SAP in Finance) and the CONSO adjustments.
BW Inventory Values are not shown in this dashboard.
  • Conversion rules: conversion from a local currency to EUR is based on the exchange rate managed by Finance. For each inventory value, the rate considered is the one of the inventory month.

For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR).
So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.




  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers


All the accesses must be validated by:
Supply Chain Excellence
Click here for the Access form to get access to the Global Supply Chain Dashboard.




Only the external sales of the GBU (We don’t consider the ‘Intra GBU’ flows)
DOS (Days of Sales): number of days of inventory in comparison to the executed sales. (inventory of month M, sales of month M)
Calculation:
 


Technical Documentation
Source:
BFC Extraction
Working Capital - QVWCAP_BW_QRY_MVFIWC01_0014
Update:
Daily
Query filters applied:

Dimensions:
Global Overview of Dimensions


Inventory Value

Inventory Volumes - Net Weight
Global Filters
Period
Month Year
Periodname
Data shown in column by Month Year
Organization
GBU
entrp_name
1 - BFC GBU [C_SUBACT2__CPFCTR1_2]
Group of Activity
N/A
2 - BFC Group of activ. [C_SUBACT2__CPFCTR2_2]
Sub-Activity
N/A
Sub-activity [C_MATPNT2__0G_CWWE01] Attribute/ BFC Activity 1 [C_MAGNUTU]
Company
N/A
[C_COMPCDE] Company_code
Plant
Zone
zonename
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country
countryname
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant
N/A
[C_PLANT] Plant
Ship Destination
Zone
N/A
Ship Dest Geo Zone [C_PNTDS3__C_ZONE]
Country
N/A
Ship Dest Country [C_PNTDS3__0COUNTRY]
Corporate Group
N/A
Delivery [MVSDTR017 / Del Ship to Party [C_SHIPTID] / Corporate Group [C_CORPGR]
Ship Destination
N/A
Ship Destination Point [C_PNTDS3]
Product
Product Hierarchy
N/A
Material Hierarchy C_MATNR2__0PROD_HIER]
Product
N/A
Commercial Product / Material Group [C_MATNR2__C_PROD]
Bulk/Packed
N/A
C_MATNR2__C_BULKPAC] Material bulk pack
Transport Mode
N/A
[C_SHIPNU2__C_TR_MODE] Ship Transportation Mode
Specific Filters

BFC Account
BFC Account
QV Mapping based on BFC Account [0GL_ACCOUNT__C_MGN_ACC]* see tranco table
WC Acct Suptype
N/A
GL Acct Subtype [0GL_ACCOUNT__C_GL_STYP]


Transcodition BFC Account
Inventory: finished gds
Finished Goods
Inventory: raw materials - Gross Value
Raw Materials
Inventory: work-in-progress
Work in Progress
Inventory : prov work-in-progress
Work in Progress
Inventory: prov. raw materials
Raw Materials
Inventory: prov finished/semi-finished goods
Finished Goods