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
- Annual usage value per item (units × cost).
- Sort high to low.
- Cumulative percentage.
- Up to 80% = A; 80–95% = B; the rest = C.
| Class | Items | Value | Control |
|---|---|---|---|
| A | ≈20% | ≈80% | Weekly count, tight par |
| B | ≈30% | ≈15% | Monthly |
| C | ≈50% | ≈5% | Quarterly |
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.
| Item | Usage value | Share | Cumulative | Class |
|---|---|---|---|---|
| Beef (all cuts) | $9,600 | 32% | 32% | A |
| Seafood | $6,300 | 21% | 53% | A |
| Spirits | $4,500 | 15% | 68% | A |
| Cheese | $2,700 | 9% | 77% | A |
| Olive oil | $1,800 | 6% | 83% | B |
| Wine | $1,500 | 5% | 88% | B |
| Produce | $1,350 | 4.5% | 92.5% | B |
| Flour and dry goods | $900 | 3% | 95.5% | C |
| Spices | $750 | 2.5% | 98% | C |
| Paper goods | $600 | 2% | 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
- One row per item: item, units used in the period, unit cost.
- Usage value = units × cost. Sort the sheet by usage value, largest first.
- Share = usage value ÷ total usage value. Cumulative = running sum of the share.
- Class with a formula, for example
=IF(cumulative<=0.8,"A",IF(cumulative<=0.95,"B","C")). - 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
| Class | Count | Ordering | Where to look for losses |
|---|---|---|---|
| A | Weekly (cycle count) | Tight par, frequent smaller orders | Every variance, by item, in dollars |
| B | Monthly | Par reviewed monthly | Variance by category |
| C | Quarterly | Larger, less frequent orders | Only 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.
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.
Start freeFrequently 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.
