ABC Analysis
Classification of items by their contribution to revenue: which positions drive the turnover, and which merely occupy space on the menu.
How to Access
Menu: Analytics → ABC Analysis.
Route: /analytics/abc
Quick actions:
Overview
ABC analysis sorts items by descending sales amount and splits the list into three categories by cumulative percentage:
| Category | What it is | Typical share |
|---|---|---|
| A | Positions producing the bulk of revenue | up to threshold A (80% by default) |
| B | Mid-contribution positions | from threshold A to threshold B (95% by default) |
| C | The tail — rare, low-impact positions | everything above threshold B |
The classification is computed twice and independently: by amount and by quantity. An item can be A by money and C by units — an expensive rare position; the reverse combination means a cheap fast mover.
Filters
| Filter | Description | Required |
|---|---|---|
| Date from | Start of the period, to the minute | Yes |
| Date to | End of the period, to the minute | Yes |
| Sales points | One, several, or all points | No |
| Employee | A specific employee or all | No |
| Threshold A, % | Boundary of category A, 80 by default | No |
| Threshold B, % | Boundary of category B, 95 by default | No |
| Grouping | Item group to filter by | No |
| Search | Filter by item name | No |
| ABC category | Show only A, only B, only C, or all | No |
An empty sales point selection means "all points".
Options
| Option | What it does |
|---|---|
| By retail price | Calculate contribution at selling price |
| By purchase price | Calculate contribution at purchase price |
| Group by groups | Break the result down by item group with per-group totals |
| With modifications | Count item modifiers separately |
| With stock | Add a current stock column |
Choosing between retail and purchase price changes not only the numbers but the composition of the categories: revenue favours high-margin positions, purchase price favours those absorbing the most money in procurement. Menu decisions usually use retail; stock decisions use purchase.
Result
Above the table sit the ABC summary — item count and total per category — and a Pareto chart showing cumulative contribution.
Table columns: name, group, price, amount, share of amount, quantity, share of quantity, category by amount, and category by quantity. With With stock enabled, a stock column is added.
Tips
- The With stock option turns the analysis into a purchasing tool: a category C item with large stock is frozen cash.
- The period must be representative. Over two or three days, category A fills with random positions; use a month or more.
- The 80/95 thresholds are an industry convention, not a system requirement. Adjust them if the assortment is very narrow or very wide.
Related
- Item Analytics — sales dynamics by position
- Sales Analysis — sales across dimensions
- Profitability — item margins
- Stock Balance — current stock