Supply Chain & Warehouse Inventory Lab

ABC-XYZ Inventory Classification Calculator

Model Pareto 80/20 ABC consumption value, XYZ demand volatility coefficient of variation, and 9-segment inventory replenishment policies.

3x3 ABC-XYZ Matrix SKU Data Table Inventory Policy Theory FAQ

Industry Catalog Presets

Load calibrated inventory datasets.

Total Catalog Value
$0
Across managed inventory SKUs
Class A Items (Top ~70-80%)
0.0% Value
Strict control & cycle counts
Class B Items (~15-20%)
0.0% Value
Standard EOQ periodic review
Class C Items (~5-10%)
0.0% Value
Bulk ordering & two-bin visual

9-Segment Inventory Matrix

ABC-XYZ Replenishment Grid

Value \ Volatility X: Constant Demand (CV < 0.5) Y: Variable Demand (0.5 ≤ CV ≤ 1.0) Z: Sporadic Demand (CV > 1.0)
A: High Value (Top 70%)
--
JIT / Kanban, tight buffer
--
Predictive seasonal buffer
--
Make-to-order / central pool
B: Medium Value (70-90%)
--
Standard EOQ reorder
--
Periodic review + buffer
--
High safety stock buffer
C: Low Value (Bottom 10%)
--
Two-bin visual reorder
--
Bulk order, large batches
--
Drop-ship / eliminate dead stock

Catalog Item Details

SKU Inventory Classification Table

SKU / Product Name Annual Demand Unit Cost ($) Monthly StdDev Annual Value ($) CV Score Segment Action

Supply Chain Management Principles

Principles of ABC-XYZ Inventory Control

Key inventory optimization principles governing multi-criteria SKU segmentation:

  • Pareto 80/20 Rule: 20% of your product catalog generates 80% of your annual working capital consumption. Focus executive management time where capital is concentrated.
  • Demand Volatility & Predictability: High-value items with steady demand (AX) require almost zero safety stock, freeing millions in working capital. High-value erratic items (AZ) require make-to-order protocols.
  • Cycle Counting Efficiency: Auditing 100% of SKUs equally wastes labor. Class A items get counted monthly; Class C items get counted once per year.
  • Dead Stock Prevention: CZ items (low value, sporadic demand) represent high obsolescence risk. Managers should purge, bundle, or switch to supplier drop-shipping.

Calculate buffer stock in the Safety Stock Lab.

Mathematical Formulation

Classification mathematical equations

Annual_Value = Annual_Demand × Unit_Cost

Value_Share_% = ( Annual_Value ÷ Total_Catalog_Value ) × 100%

Monthly_Mean_Demand = Annual_Demand ÷ 12

Coefficient_of_Variation (CV) = Demand_StdDev ÷ Monthly_Mean_Demand

XYZ_Class = X if CV < 0.5, Y if 0.5 ≤ CV ≤ 1.0, Z if CV > 1.0

Calculate economic order batch size in the Inventory EOQ Lab.

FAQ

ABC-XYZ inventory classification questions

What is ABC Analysis in inventory management?

ABC Analysis categorizes SKUs based on Pareto's 80/20 rule of annual consumption dollar value: Class A represents ~70%–80% of total inventory value (highest control), Class B represents ~15%–20% (moderate control), and Class C represents ~5%–10% of value (minimal control, bulk replenishment).

What is XYZ Analysis and how is it measured?

XYZ Analysis classifies inventory by demand predictability using the Coefficient of Variation (CV = Standard Deviation / Mean). Class X (CV < 0.5) has steady, predictable demand; Class Y (0.5 ≤ CV ≤ 1.0) has moderate variability; and Class Z (CV > 1.0) has sporadic, erratic demand.

How does the combined 3x3 ABC-XYZ Matrix improve supply chain operations?

The 9-cell matrix assigns customized replenishment strategies: AX items get lean JIT/Kanban with minimal safety stock; AZ items get make-to-order or central pooling; and CX/CY items use simple two-bin visual reordering, eliminating wasted management labor on low-value items.

How often should Class A items be counted during cycle audits?

Class A items are typically cycle-counted monthly or weekly to maintain 98%+ inventory accuracy. Class B items are counted quarterly, and Class C items are audited semi-annually or annually.

Can I export the ABC-XYZ classification table to CSV?

Yes. You can export complete SKU annual usage values, cumulative Pareto percentages, CV volatility scores, matrix assignments, and tactical policies as a UTF-8 CSV spreadsheet with formula defense.

Continue Exploring Inventory & Supply Chain Tools

Explore our Retail & Inventory Hub, calculate safety stock in the Safety Stock Lab, optimize order batches in the EOQ Lab, model supply chain distortion in the Bullwhip Effect Lab, or optimize single-period perishable orders in the Newsvendor Lab.