Stock Coverage (ABC-XYZ)

This Tableau Accelerator allows you to optimise the Stock Coverage of the items you hold in your inventory (based on recommendations suggested by an ABC-XYZ analysis).

Demo video

The ABC-XYZ analysis classifies your products and then recommends how to handle:

• Degree of automation replenishment processes
• Buffer Stock
• Inventory Control

Products are classified by:

• Consumption Volume
  • A: High consumption volume
  • B: Medium consumption volume
  • C: Low consumption volume
• Consumption Volume Volatility: if past consumption is stable (= not volatile), we can make a reliable estimate of future demand
  • X: Stable consumption/Linear demand
  • Y: Volatile consumption/Variable demand
  • Z: Very Volatile consumption/Unpredictable demand

Each combination (AX, BX, CY...) implies a suggested way to manage inventory:

• Identify products at risk (rupture and overstock)
• Define the right stock/security stock coverage
• Optimise production/purchasing volumes

Answer key business questions

• How are my products classified according to ABC/XYZ approach?
• What are the best inventory actions for my products?
• Which buffer stock to hedge against customer-induced variations?
• How many products do I have with a reliable forecast?
• Which products do I have with a high consumption value?

Required attributes

• Date (date): Date
• Product (string): Inventory item
• Volume (numeric): Sales / Demand / Consumption Volume (amount)