Inventory segmentation and optimization tool
ABC-XYZ Inventory Analysis
Segment your inventory and decide how to manage each SKU. This page combines a quick classifier, a full portfolio analyzer, and a practical decision matrix so you can move from category labels to stocking policy.
An ABC value segment, an XYZ variability segment, and a combined class that tells you how to prioritize each SKU.
It stops you from managing all SKUs the same way, so buffer stock, supplier attention, and planning effort go to the items that matter most.
Inventory managers, supply chain analysts, planners, procurement teams, and students learning practical inventory segmentation.
Quick SKU classifier
Enter one SKU to get its ABC-XYZ category, the risk level behind it, and the operational action that follows. Use this when you want a fast decision before you analyze a full portfolio.
Single-item classification tool
Rank SKUs from highest to lowest annual consumption value, then enter the running cumulative percentage for this item.
CV equals demand standard deviation divided by average demand. Low CV means stable demand, high CV means unpredictable demand.
Full portfolio analyzer
Upload or paste your SKU list to classify the full assortment, identify the segments driving value or risk, and export the result for policy setting.
Results
Use the summary, matrix, and detailed table to see where value is concentrated, where predictability is weak, and which policies need to change.
Analysis summary
What is ABC-XYZ inventory analysis?
ABC-XYZ analysis is a two-dimensional inventory segmentation method. It combines value with predictability, so you can decide not only how important an item is, but also how difficult it is to manage.
ABC analysis: classify by value
ABC analysis applies the Pareto principle to inventory. Rank all SKUs from highest to lowest annual consumption value, which is unit cost multiplied by annual usage. The portfolio usually breaks into three broad groups:
- A items are the high-impact items that account for most of the portfolio value. They need close review, better supplier attention, and explicit replenishment policy.
- B items are the mid-value items. They matter, but standard controls are usually enough.
- C items are the long tail of low-value items. They should consume very little planner time unless they also create service risk.
XYZ analysis: classify by predictability
XYZ analysis measures how stable or erratic demand is for each SKU. The key metric is the coefficient of variation, which is demand standard deviation divided by average demand.
- X items have stable demand, so reorder points and automated replenishment work well.
- Y items have moderate variability, so they need periodic review and a practical safety stock buffer.
- Z items are highly unpredictable, so forecasting adds less value and supplier responsiveness matters more.
ABC tells you where the money is. XYZ tells you where the uncertainty is. Together they tell you where to focus control, where to hold more stock, and where to simplify the policy.
Why inventory segmentation matters
The value of ABC-XYZ is not in the labels. It is in replacing one-size-fits-all inventory rules with policies that match the economics and the uncertainty of each SKU.
No segmentation
When every SKU gets the same review frequency and stock policy, the business usually under-controls high-value items and over-manages low-value items.
Balanced segmentation
A practical ABC-XYZ policy reduces working capital, protects service where it matters, and frees planners to focus on the SKUs that genuinely need judgment.
Over-complex segmentation
Too many categories create reporting clutter instead of action. ABC-XYZ is often the right balance between useful detail and operational simplicity.
The ABC-XYZ matrix: strategy for all 9 categories
Each cell points to a different stocking policy, review rhythm, and supplier approach. Use the matrix below to move from classification to operational action.
| X - Stable | Y - Variable | Z - Unpredictable | |
|---|---|---|---|
| A |
AX
High priority, low operational risk
Risk: Stable demand reduces day-to-day disruption, but stockouts are still expensive because the item carries high value. Strategy: Use tight control, frequent review, and lean replenishment. Policy: Low safety stock, reliable supplier service level, fixed reorder point. |
AY
High priority, moderate risk
Risk: High value plus variable demand creates both service risk and overstock risk. Strategy: Forecast actively and review safety stock regularly. Policy: Moderate buffer, tighter replenishment cadence, strong supplier communication. |
AZ
Critical, highest risk
Risk: These items are expensive and unpredictable, so every stockout is painful and hard to prevent with forecasting alone. Strategy: Protect availability with extra safety stock or faster replenishment. Policy: Large buffer, escalation plan, weekly review, premium supplier coverage. |
| B |
BX
Standard priority, low risk
Risk: Predictable demand and mid-level value make this category manageable with standard rules. Strategy: Apply routine replenishment and reduce planner touch time. Policy: Moderate safety stock, periodic review, blanket purchase orders where useful. |
BY
Standard priority, watch closely
Risk: Variability can erode service if the policy is too rigid. Strategy: Review regularly and adjust buffers when seasonality or trends change. Policy: Moderate safety stock, min-max or periodic review rules. |
BZ
Monitor actively, consider simplification
Risk: Planning effort is high relative to the value contribution. Strategy: Favor reactive replenishment, consignment, or make-to-order when possible. Policy: Practical buffer only if needed, otherwise simplify supply. |
| C |
CX
Automate with minimal planner time
Risk: Low value and predictable demand mean little operational danger. Strategy: Automate replenishment and keep manual review close to zero. Policy: Two-bin system, blanket orders, or supplier-managed stock. |
CY
Low priority, simplify policy
Risk: Demand varies, but the financial impact is limited. Strategy: Use simple review rules and avoid over-engineering the forecast. Policy: Small buffer or order-on-demand when service impact is acceptable. |
CZ
Minimize or eliminate
Risk: These items create complexity without enough value to justify heavy management. Strategy: Review for rationalization, substitution, or order-only supply. Policy: Zero planned stock unless there is a clear service reason to keep it. |
How to interpret your ABC-XYZ results
The point of the classification is to decide where to focus, where to simplify, and where to stop treating items as if they were equally important.
Categories that deserve close attention
AZ items deserve the most attention because they combine high value with low predictability. These are the items where stockouts are expensive and standard forecasting is least reliable.
AY items deserve disciplined forecasting and regular safety stock review. They are not as unstable as AZ, but they still need tighter control than the rest of the portfolio.
AX items should be managed carefully, but not heavily overstocked. Their predictability is the reason you can run them lean.
Categories to reduce or rationalize
CZ items should be challenged first. They are low value, highly erratic, and often create more planning work than commercial benefit.
BZ items are the next candidates for simplification. If a supplier can replenish quickly, order-on-demand may outperform holding stock.
Categories to automate
CX items are strong candidates for automated replenishment. CY items can also be simplified if service exposure is low enough. The time saved here should be reinvested in A and Z categories.
Real-world examples
These examples show how the classification should lead directly to a stocking or sourcing decision.
Retail example
- SKU: premium running shoes
- Annual consumption value: EUR 42,000, cumulative position 8%
- Monthly demand CV: 0.62 due to seasonal spikes
Manufacturing example
- Component: standard steel bracket
- Annual consumption value: EUR 18,500, cumulative position 62%
- Monthly demand CV: 0.09 because usage follows a stable production plan
Distribution example
- SKU: specialty industrial cleaning agent
- Annual consumption value: EUR 1,200, cumulative position 97%
- Monthly demand CV: 1.4 because orders are project-driven
Common mistakes in ABC-XYZ analysis
The classification works only when it changes policy. These are the mistakes that usually prevent that from happening.
Value alone does not tell you how difficult an item is to manage. Two items can contribute the same spend and need completely different replenishment rules.
Treating Z items with standard reorder-point logic leads to repeated stockouts or bloated buffers because the demand pattern itself is unstable.
Product lifecycles, promotions, and supplier changes move items between categories. A static matrix quickly becomes a stale policy file.
If the classification does not change review frequency, safety stock, or sourcing policy, the analysis becomes reporting instead of decision support.
Best practices for ABC-XYZ classification
These practices keep the analysis practical and useful in day-to-day inventory management.
Formulas used in this calculator
The page combines a value calculation for ABC and a variability calculation for XYZ.
- Consumption value = unit cost x annual usage. This ranks items by annual monetary impact.
- Percent of total = consumption value divided by total portfolio consumption value.
- Cumulative percent is the running total used to assign A, B, and C categories.
- Coefficient of variation = demand standard deviation divided by average demand. This drives X, Y, and Z classification.
The combined category tells you which items should run lean, which need extra buffer, and which should be simplified or challenged.
Related tools: build the next step of your inventory strategy
ABC-XYZ tells you how to segment the portfolio. The tools below help you translate that segmentation into stocking and supplier decisions.
Safety Stock Calculator
Set buffer stock by segment so high-risk classes get more protection and stable classes stay lean.
Lead Time Calculator
Evaluate how supplier lead time changes the stocking policy for volatile or high-value items.
Supplier Reliability Calculator
Compare supplier performance when your A categories need tighter service commitments.
Inventory Coverage Calculator
Check whether each segment is carrying the right number of days of stock.
Slow-Moving and Obsolete Stock Tool
Use it to challenge CZ items that are already tying up capital without enough demand.
EOQ and Reorder Point Suite
Turn segment decisions into order quantities and reorder rules for the items you keep in stock.
Frequently asked questions
ABC analysis classifies items by annual consumption value, while XYZ analysis classifies them by demand variability. The combined ABC-XYZ matrix shows both value importance and planning difficulty at the same time.
Quarterly is a practical minimum. Update sooner if promotions, seasonality, product launches, supplier changes, or demand shocks significantly change the portfolio.
A common starting point is X at or below 0.2, Y between 0.2 and 0.5, and Z above 0.5. Adjust the thresholds to fit the variability profile of your industry and product mix.
AZ is usually the most critical category because the items are both high value and hard to forecast. They often need extra safety stock, faster suppliers, or a more active review cycle.
Yes. The logic is simple to automate in Excel, Python, BI tools, or ERP workflows. The most important step is not the automation itself, but linking the category to a real replenishment and sourcing policy.
The minimum is ItemID, ItemName, UnitCost, and AnnualUsage. Add monthly demand columns when you want the page to calculate CV and assign X, Y, or Z automatically.
No. The analysis runs locally in your browser. Uploaded or pasted data is processed on the page and is not sent to an external server by this tool.
Build your full inventory strategy
Use ABC-XYZ as the foundation, then set safety stock, reorder rules, and supplier service levels that match the economics and the risk of each segment.