ABC analysis
Splitting items into classes by contribution to revenue or margin.
Formula
Items sorted in descending order; class A while the cumulative share is below the A threshold
How to read
A is the core, B the middle, C candidates for cutting. It shows contribution, not cause; demand stability is shown by XYZ analysis.
Where it is discussed
Topics
- Stock and turnover
- Season, price and discounts
- Assortment and sizes
- Collection and range
- Size runs, stores and range in season
- Stock accuracy, shrink and availability
- Customers and loyalty
- Range: width, depth and price tiers
- Season results: brand, category, SKU
- Warehouse, fulfillment and the last mile
- Systems landscape and data exchange
- Data quality and data owners
Calculations
- Stock record accuracy and the cost of mismatches
- SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
- ABC analysis of the range
- Net effect of a new item: cannibalization
- Availability and lost revenue
- Customer concentration: share of the largest
- Product classifier check
- Warehouse slotting by ABC: a shorter picking path
Documents
- ABC-XYZ and Pareto: calculation, thresholds, link to safety stock and the range
- Excel for retail, part I: lookup by key, pivot tables and data validation
- Excel for retail, part II: ABC analysis and the open-to-buy (OTB) budget in a spreadsheet
- Warehouse and data: capacity for the peak, stock and sales reconciliation, returns, RFID and slotting