Inventory Visibility Tool

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.