Process Owner

Benoit HORNYAK

 



General Description

This dashboard has been developed by Supply Chain Excellence to provide visibility on inventories. Visibility on inventories is a key element to start inventory optimization projects and ensure sustainability in the improvements. The visibility can support 5 to 10% of the reductions.

General features:

  • The tool provides graphical views, analytical functions, possibility to extract to Excel.
  • Ability to make a selection on inventory by month (end of Month inventory situation).
  • Visibility of inventory at each distribution point and globally.
  • For a given GBU, visibility by Zone/Company/Plant/Material (aggregation and dis-aggregation possible).
  • Ability to select a material or a group of material (from material number to product hierarchy/commercial product)
  • Make distinction between Finished Goods, Intermediates, Raw Materials.

Scope:

  • The tool covers Finished Goods, Intermediates, Raw Materials. The distinction between the different material types is done according to the SAP valuation class (Accounting 1 view of material master file MM03).
    • WP1: Z100 CS Raw materials, Z130 CS Trading goods, Z140 CS Intermediates.
    • PF1: Z000 Main raw materials, Z007 Main raw materials-import, Z049 Interplant raw materials, Z050 Other raw materials, Z053 Semi finished products, Z061 Semi finished products, Z100 Finished goods manuf, Z101 Finished goods purch.
  • Packaging and Spare Parts are not included in this dashboard.
  • Data available for the 2 past full years.
Tabs
Description
Key figures
Description

Overview

Stock value by Zone / Country / Plant / Stock Type / Valuation Class  
Inventory Value

Inventory value by Zone / Country / Plant / Stock Type / Valuation Class.

Evolution of Level Inventory value by Zone / Country / Plant / Stock Type / Valuation Class.

  • Inventory Value
  • Global Sales
  • Global Consumption
  • DOS
  • Inventory Turn
  • Sales
  • Restocking
  • High level Inventory and Global Sales Value:

Average value of inventory according to selected months. Average value of Global Sales&Consumption (MM) for the same period. DOS and Inventory Turn.

  • High Level Sales Value:

Average value of Sales (OBAS - invoiced) and Restocking (inter-company replenishment) converted in EUR for the same period.

  • Evolution of Inventory, global Sales&Consumption (MM), Sales, Restocking, DOS and Inventory Turn.
Inventory Quantity

Inventory Quantity by Zone / Country / Plant / Stock Type / Valuation Class.

Evolution of Inventory Quantity by Zone / Country / Plant / Stock Type / Valuation Class.

  • Inventory Quantity
  • Global Sales
  • Global Consumption
  • DOS
  • Inventory Turn
  • Sales
  • Restocking
  • High level Inventory and Global Sales Quantity:

Average quantity of inventory according to selected months. Average value of Global Sales&Consumption (MM) for the same period. DIOH and Inventory Turn.

  • High Level Sales Quantity:

Average quantity of Sales (OBAS - invoiced) and Restocking (inter-company replenishment) converted in EUR for the same period.

  • Evolution of Inventory, global Sales&Consumption (MM), Sales, Restocking, DIOH and Inventory Turn.
Aging StockReport on inventory age identified at batch level by its manufacturing date or last goods receipt date and last day of the month date. The age of the stock is divided into 4 categories: 0-4 months, 4-12 months, 12-24 months, >24 months.  Ageing Analysis also lists out items batch wise the shelf life of the products i.e. already expired or may expire in the near future (number of days before the expiry date).
  • Aging stock by categories ( 0-4, 4-12, 12-24, >24 months in quantity and value
  • Expired - Not Expired stock in quantity and value.
  • Evolution Expired and >12 months in quantity and value.


  • The number of days and months in stock is calculated as follows: Last Day of the Month - Last Goods Receipt date (or Manufacturing date if Last GR date not available).
  • Expired stock: Expiry Date - Last Day of the Month = Number of days before expiry.
    • If Number of days before expiry > 0 => Not Expired
    • If Number of days before expiry <= 0 => Expired
Stock Typology

The tool provides visibility on the following stock layers:

  • Unrestricted Use
  • Quality
  • Material Provided to Vendor
  • Inter-plant Transfer
  • In Transit
  • Customer consignment
  • Blocked

 

 
  • The Stock Type status is showed as defined in SAP
Analytics
  • Double ABC Analysis
  • 9 Box Model
  • Excess Inventory

 

 

  • Double ABC analysis. It illustrates the 80% for each product, an 80/15/5 analysis in term of Sales value and in stock value, assigning an ABC category to each product on both sales and volume. ABC Analysis is a valuable tool for inventory management. It makes sense to direct effort to control closely the items classified as A and use less sophisticated techniques on the items classified as C. By closely controlling the few (e.g. 20% of the items) A items, a company can focus on 80% of the inventory cost.
  • 9 Box Model: Compares the ABC Classification based on sales with a Coefficient of Variation of the Demand in order to analyze further the stock composition.
Reports   

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Dimension 
  



Key FiguresDescriptions

Stock Value

Inventory values expressed in EUR
Stock QuantityInventory values expressed in tons
Global Sales 
Globales Consumptions 
Sales 
Restocking 
In Transit!!! Filter on GL Account !!!
Source SystemData sourcesSource Query NameSource Query DescriptionWBP Qlikview Query Name
WP1Stock Value and Quantity, Stock Typology, Global Consumption, Global SalesWBP: BW_QRY_MPR_IC001_0014BW - Stock Movement All Types (Core Query)QVSBS_BW_QRY_MPR_IC001_0004 (VAL QTY)
PF1 & WP1Stock In TransitWBP: BW_QRY_MVFIWC01_0005BW - Working Capital Inventories (Core Query)QVSBS_BW_QRY_MVFIWC01_0001
WP1Aging StockWBP: BW_QRY_MPR_IC001_0051 BW - Stock Values and Quantities (Core Query)QVSBS_BW_QRY_MPR_IC001_0003(BATCH)
PF1Stock Value and Quantity, Stock Typology, Global Consumption, Global SalesWBP: BW_QRY_MVMMIC01_0003BW - Inventory Management - Stock Movement (Core Query)

QVSBS_BW_QRY_MVMMIC01_0001

QVSBS_BW_QRY_MVMMIC01_0002

PF1 & WP1SalesBI4: INVEX_LIST_OF_SALES_CWWPPS_R001INVEX_LIST_OF_SALES_CWWPPS_R001QVSBS_BW_QRY_MVSDSO44_0001
PF1 & WP1Purchase (Inter-company Stock Replenishment)BI4: INVEX_LIST_OF_SALES_CWWPPS_R001INVEX_LIST_OF_SALES_CWWPPS_R001QVSBS_BW_QRY_MVSDSO42_0001
Currencies
  • EUR
  • Conversion rate : ????? Yearly Cumulated average Monthly of Y-1

Target Users

Authorization & Rights

All the accesses must be validated by the process owner Benoit HORNYAK