Start free

ABC Analysis in Inventory: Example and Steps

By mise · Updated October 7, 2026

Quick answer: ABC analysis ranks items by the value they move. A items are about 20% of SKUs and 80% of value; B, 30% and 15%; C, 50% and 5%. Count A weekly, B monthly, C quarterly.

Not every item deserves the same attention. ABC tells you where to spend it.

Step by step

  1. Annual usage value per item (units × cost).
  2. Sort high to low.
  3. Cumulative percentage.
  4. Up to 80% = A; 80–95% = B; the rest = C.
ClassItemsValueControl
A≈20%≈80%Weekly count, tight par
B≈30%≈15%Monthly
C≈50%≈5%Quarterly
In a restaurant, A items are usually proteins, seafood, olive oil and spirits; C items are spices, napkins and condiments.

mise gives you the stock value of every item from your counts and purchases. Export it to Excel, sort by value, and your A items are right at the top.

Worked example: ABC analysis for a small restaurant

Take ten items and their usage value for a quarter (units used × unit cost). Sort them from highest to lowest and add a running share of the total.

ItemUsage valueShareCumulativeClass
Beef (all cuts)$9,60032%32%A
Seafood$6,30021%53%A
Spirits$4,50015%68%A
Cheese$2,7009%77%A
Olive oil$1,8006%83%B
Wine$1,5005%88%B
Produce$1,3504.5%92.5%B
Flour and dry goods$9003%95.5%C
Spices$7502.5%98%C
Paper goods$6002%100%C

Total usage value is $30,000. Four items make up 77% of it: those are your A items. They deserve a weekly count, a tight par and a look at every variance. The C items can be counted once a quarter without losing much.

How to build it in a spreadsheet

  1. One row per item: item, units used in the period, unit cost.
  2. Usage value = units × cost. Sort the sheet by usage value, largest first.
  3. Share = usage value ÷ total usage value. Cumulative = running sum of the share.
  4. Class with a formula, for example =IF(cumulative<=0.8,"A",IF(cumulative<=0.95,"B","C")).
  5. Re-run it every quarter, or when the menu changes.

Usage comes from your counts: beginning inventory + purchases − ending inventory, per item. If you don't have per-item usage yet, purchases for the period are a reasonable first approximation.

What to do with each class

ClassCountOrderingWhere to look for losses
AWeekly (cycle count)Tight par, frequent smaller ordersEvery variance, by item, in dollars
BMonthlyPar reviewed monthlyVariance by category
CQuarterlyLarger, less frequent ordersOnly if the category total moves

ABC pairs naturally with cycle counting: the A list is what you count every week. It also points at dead stock: C items that also have no usage at all are candidates to stop buying.

Try mise in your business

Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.

Start free
Download on the App StoreGet it on Google Play
Keep reading Restaurant inventory turnover: formula and industry average Par level: meaning, formula and calculator Safety Stock Formula: Calculation and Example Cycle Counting: How to Do Inventory Cycle Counts All guides

Frequently asked questions

What is ABC analysis?

A way to rank inventory by economic importance, based on the Pareto 80/20 rule.

How often should I update it?

Quarterly, or when the menu or assortment changes.

Can I do it in Excel?

Yes: annual value, sort, cumulative %.

Should ABC be based on value or on quantity?

On value (units × cost). A case of napkins moves more units than a bottle of whiskey but ties up far less money.

Is the 80/20 split fixed?

No. It is a rule of thumb. Use whatever cut-offs make sense for your list; what matters is that the few items carrying most of the value get the most attention.

What is XYZ analysis?

A companion to ABC that classifies items by how predictable their demand is (X steady, Z erratic). Combined, AX items are high value and steady; AZ items are high value and hard to forecast, so they need safety stock.

Can I try mise for free?

Yes. You get a free trial, with no card needed.