Start free

ABC Analysis in Inventory: Example and Steps

By mise · Updated September 29, 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 ranks your items by value from your counts and purchases.

Try mise in your business

Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. 7-day free trial, then US$33 a month (£26 in the UK).

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

How much does mise cost?

A 7-day free trial, then US$33 a month per location (£26 in the UK).