You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Supply Chain Excellence

Jose-Pablo Leyva

D&PS Expert

Miriam Luttrin


General Description

xxxx - Jose Pablo Leyva


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


Target Users

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

Authorization & Rights

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.

Official inventory values

Only in EURO as it is Solvay official currency (i.e. USD is not available). Those results are the official inventories considered by Solvay.
  • 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.
  • Sales value: COGS (Cost Of Goods Sold)

Perimeter

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
















PeriodMonth YearPeriodname
Data shown in column by Month Year

Organization


GBU

entrp_name
1 - BFC GBU [C_SUBACT2__CPFCTR1_2]

Group of Activity

N/A2 - BFC Group of activ. [C_SUBACT2__CPFCTR2_2]

Sub-Activity

N/ASub-activity [C_MATPNT2__0G_CWWE01] Attribute/ BFC Activity 1 [C_MAGNUTU]

Company

N/A[C_COMPCDE] Company_code
PlantZonezonename
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Countrycountryname
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
PlantN/A
[C_PLANT] Plant
Ship DestinationZoneN/A
Ship Dest Geo Zone [C_PNTDS3__C_ZONE]
CountryN/A
Ship Dest Country [C_PNTDS3__0COUNTRY]
Corporate GroupN/A
Delivery [MVSDTR017 / Del Ship to Party [C_SHIPTID] / Corporate Group [C_CORPGR]
Ship DestinationN/A
Ship Destination Point [C_PNTDS3]
ProductProduct HierarchyN/A
Material Hierarchy C_MATNR2__0PROD_HIER]
ProductN/A
Commercial Product / Material Group [C_MATNR2__C_PROD]
Bulk/PackedN/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/AGL Acct Subtype [0GL_ACCOUNT__C_GL_STYP]


Transcodition BFC Account
Inventory: finished gdsFinished Goods
Inventory: raw materials - Gross ValueRaw Materials
Inventory: work-in-progressWork in Progress
Inventory : prov work-in-progressWork in Progress
Inventory: prov. raw materialsRaw Materials
Inventory: prov finished/semi-finished goodsFinished Goods

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels