XYZ Analysis: Formula, Example & ABC-XYZ Matrix
6 min read
By
TranZact Solutions Team
· Published


XYZ analysis groups stock items by how steady their demand is. It uses the coefficient of variation (CV): the standard deviation of monthly demand divided by the average monthly demand. Items with low CV are X (steady), medium CV are Y (seasonal or swinging) and high CV are Z (erratic). Used with ABC analysis, it shows which items can be reordered on a fixed rule and which need extra safety stock or make-to-order.
What is XYZ analysis?
X items: steady
Demand is nearly the same every month. Example: fasteners issued to the assembly line every week. You can reorder these on a fixed rule.
Y items: seasonal or swinging
Demand rises and falls, but in a pattern you can see. Example: paint or packing material that climbs before year-end dispatch in February and March.
Z items: erratic
Demand comes in lumps with long gaps. Example: a casting made for one customer's rare orders.
XYZ analysis formula (coefficient of variation)
CV = standard deviation of demand ÷ average demand × 100
Use the monthly quantity issued to production, not the quantity purchased. Take 12 months, so seasonal items show their full swing.
The Excel / Google Sheets formula
Put 12 months of issue quantity for one item in cells B2 to M2. In N2, type =STDEV.S(B2:M2)/AVERAGE(B2:M2) and format it as a percentage.
STDEV.S uses the sample method (it divides by N−1). Copy the formula down for every item.
X, Y and Z cut-offs
A common starting point is below. Each factory adjusts the lines to fit its own items.
X: CV up to 10%
Y: CV above 10% and up to 25%
Z: CV above 25%
To label each item, put =IF(N2<=10%,"X",IF(N2<=25%,"Y","Z")) in O2.
How to do XYZ analysis: step by step
XYZ analysis in 5 steps
List items with 12 months of issues
Work out average and standard deviation
Divide to get each item's CV
Sort by CV and label X, Y, Z
Set a stock rule per class
Worked example: 3 items from an engineering unit
Here are 12 months of issue quantities, April to March, for three items. The numbers are illustrative. Each item has the same average of 100 a month.
M10 hex bolts (boxes): 100, 104, 98, 102, 96, 100, 103, 97, 101, 99, 102, 98
Packing cartons: 80, 75, 85, 90, 95, 100, 110, 105, 100, 110, 120, 130
Special casting (pieces): 0, 0, 300, 0, 0, 0, 450, 0, 0, 0, 0, 450
Item | Standard deviation | CV | Class |
|---|---|---|---|
M10 hex bolts | 2.5 | 2.5% | X |
Packing cartons | 16.2 | 16.2% | Y |
Special casting | 184.6 | 184.6% | Z |
The average alone says these three items are the same. The CV shows they need three different stock rules. Bolts can go on a fixed reorder level. Cartons need a bigger buffer before the March peak. The casting should be bought against confirmed orders.
Where TranZact fits
XYZ analysis is only as good as the monthly issue data behind it. In many factories, that data is split across a stores register, Excel and WhatsApp. Issues missed on a busy day make steady items look erratic.
TranZact's manufacturing AI software records stock in, issues and the bin card for each item, across multiple stores. Your issue history sits in one place, ready to analyse. TranZact's inventory management also covers reorder, AI stock alerts, and inventory ageing & valuation.
TranZact also integrates with Excel and Google Sheets, where you can work out the CV.
One honest limit: TranZact does not label items X, Y or Z or calculate CV for you. You decide the class and the stock rule. TranZact keeps the issue records those decisions depend on.
TranZact is used by 10,000+ manufacturers and goes live in 2–3 weeks. See plans on our pricing page.
ABC vs XYZ analysis: what's the difference?
ABC ranks items by consumption value: how much money flows through each one in a year. XYZ ranks items by how predictable their demand is. The two are separate scales.
So a high-value item can still be erratic. That AZ item is the hardest to plan: costly to overstock and costly to run out of. Our ABC analysis guide shows how to work out the value side.
ABC vs XYZ at a glance
ABC analysis | XYZ analysis | |
|---|---|---|
Measures | Consumption value | Demand steadiness |
Data used | Annual quantity × unit cost | Monthly issue quantity |
Tells you | Where your money sits | How hard to forecast |
Drives | How closely to control | Safety stock and reorder rule |
The ABC-XYZ matrix: a stock rule for all 9 cells
ABC-XYZ classification sorts the same item list two ways, by value and by demand. Each item lands in one of nine cells. AX means high value and steady; CZ means low value and erratic.
Value class | X (steady) | Y (swinging) | Z (erratic) |
|---|---|---|---|
A (high value) | Tight control, lean buffer, frequent planned orders | Plan to forecast, moderate buffer, review monthly | Buy against confirmed orders or make-to-order |
B (medium value) | Fixed reorder level, low safety stock | Reorder level, moderate buffer, raise it before the peak | Order against orders where you can; review each buy |
C (low value) | Simple automatic reorder, buy in bulk | Reorder level with a seasonal top-up | Small buffer, minimal effort; watch for dead stock |
Set safety stock from the class, then work out each item's reorder level. Our safety stock guide has the formula.
Common mistakes in XYZ analysis
Using purchases instead of issues. A bulk buy every quarter makes a steady item look erratic.
Too few months. Three months can't show a seasonal swing. Use 12.
System stock that doesn't match the floor. Unrecorded issues make the CV wrong. Fix the records first.
Classifying new items. Without enough history, the CV means little.
Doing it once. Demand shifts over time. Redo it every quarter.
Overstocking cheap Z items. A small buffer is fine. A big one turns into dead stock.
ABC, EOQ and the formula for ABC analysis
What is the formula for ABC analysis?
Annual consumption value = annual quantity used × unit cost. Sort items from highest value to lowest and add up each one's share of the total. The few items at the top are A, the middle band is B and the long tail is C.
What is EOQ and ABC analysis?
ABC tells you which items deserve the most attention. EOQ (economic order quantity) tells you how much to order at a time. The formula is EOQ = √(2DS ÷ H).
D is annual demand, S is the cost of placing one order and H is the holding cost per unit per year. Our EOQ guide works through an example.
XYZ fills the gap between them. It sets how much safety stock each item carries, which feeds its reorder level. For seasonal Y items, pair it with demand forecasting.
Become the AI-Run Factory
Bring your item list to a demo and see your stock in, issues and bin cards in one place. Then run XYZ on numbers you trust.
Don't be the bottleneck. Become the AI-Run Factory.




