Stock Coverage (ABC-XYZ)

by Tableau

Description

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)

Features

Supports data mapping

Resources