XYZ Analysis: Formula, Example & ABC-XYZ Matrix

6 min read

By

TranZact Solutions Team

· Published

Hero Background
Functions of ERP System Explained

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
  1. List items with 12 months of issues

  2. Work out average and standard deviation

  3. Divide to get each item's CV

  4. Sort by CV and label X, Y, Z

  5. 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.

Book a demo →

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.

Book a demo →

Check out other blogs

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders