Syensqo IS - Customer Support

Page tree

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

Compare with Current View Page History

« Previous Version 34 Next »

 

 

 

Process Owner

Benoit HORNYAK

 



General Description

This dashboard has been developed by Supply Chain Excellence and SBS 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
  • Average Inventory Value
 
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 without batch numbers are excluded
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 mapping is performed as follows:
      • Stock Type Group:
      • Stock Type:
      • Stock Type Details:
      TO BE COMPLETED
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.
    • Coefficient of Variation = Standard Deviation of the Demand/Average Demand for the period
    • Low Variability (L): COV≤1
    • Medium Variability (M): 1≤COV≤2
    • High Variability (H): COV≥2
    • Z= items with no demand

  • Excess Inventory: Excess Inventory ('The Excess Inventory Analysis permits to categorize products into ABCD categories (A: 80% of sales; B: next 15%; C: last 5%; D: negative sales) and Identify for each category the stock value that is beyond the DIOH bracket (in Excess). 

Reports
  • Excel extractor
  

 

 

 

 

 

 

 

Dimension 
  



Key FiguresDescriptionCalculation Method

Stock Value

Inventory values expressed in EURValues extracted from BW Core query BW_QRY_MPR_IC001_0014 (WP1) and BW_QRY_MVMMIC01_0003 (PF1)
Stock QuantityInventory values expressed in tonsQuantities extracted from BW Core query BW_QRY_MPR_IC001_0014 (WP1) and BW_QRY_MVMMIC01_0003 (PF1)
Global Sales  
Globales Consumptions  
SalesTotal billing without taxes converted in EUR per month. 
Restocking  
In Transit

The In Transit stock considered in the dashboard is Inter-company and Intra-company stock.

  • Inter-Company In Transit stock: a filter on the G/L account has been set-up in order to exclusively show the following accounts:
    Account 37000300 for other materials than RM shipped by a Solvay supplier and billed or not billed yet to a Solvay affiliate (inbound and outbound transit) :
   ¤ direct trading
   ¤ interco direct shipment
   ¤ interco stock replenishment (STO)

GL Account in 37000300 GOODS IN TRANSIT

+ 37000305

GL_ACCOUNT 2020000000 + attribut à trouver pour inter/intra

 



 
DIOH

DIOH ‘Inventory Days on Hand’ is an estimate of the number of days for which the average balance of inventory will be sufficient.

Average Stock Quantity (of concerned month) / Average 3 months (Global Sales Qty + Global Consumption Qty) X nbr of days in the period.

Note: to be aligned with Finance calculation: - Average Global Sales Qty + Global Consumption: M-1, M, M+1 - Exception: * first month of selection: M, M+1 * last month of selection: M-1, M

DOS

“Days of Supply” is an efficiency ratio that measures the average number of days the company holds its inventory before selling it. The ratio measures the number of days funds are tied up in inventory. Inventory levels (measured at value) are divided by sales per day (also measured at cost - COGS - rather than selling price.)

Average Stock Value (of concerned month) / Average 3 months (Global Sales Value + Global Consumption) X nbr of days in the period.

 Note: to be aligned with Finance calculation: - Average Global Sales Value + Global Consumption: M-1, M, M+1 - Exception: * first month of selection: M, M+1 * last month of selection: M-1, M

Inventory Turn

In accounting, the Inventory turnover is a measure of the number of times inventory is sold or used in a time period such as a year. The equation for inventory turnover equals the cost of goods sold or net sales divided by the average inventory.

Average 3 months (Global Sales Value or Quantity + Global Consumption) / Average Stock Value or Quantity (of concerned month) X nbr of days in the period

Note: to be aligned with Finance calculation: - Average Global Sales Value or Quantity + Global Consumption: M-1, M, M+1 - Exception: * first month of selection: M, M+1 * last month of selection: M-1, M

   
   
   
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
 

The best way to get IT support is to use the new Service One Platform.