ABC Analysis Calculator

This ABC analysis calculator sorts your items by value, works out cumulative shares and classifies them into A, B and C: paste items with their values and read off the result.

Source: Wikipedia – ABC-Analyse (classification by value share, usual benchmarks 80/15/5). Updated: .

one line per item, e.g. “Screws; 52000” (name and value separated by semicolon, tab or space)
% of value
A items cover at least this share (usually 80)
% of value
A and B together cover at least this share (usually 95)
My ToolboxYour inputs are saved in this browser only.

Result

Result
3 of 10 items (30 %) make up 84.9 % of the total value (class A)
Ranking
RankItemValueShareCumulativeClass
1Screws52,00049.1 %49.1 %A
2Gaskets30,00028.3 %77.4 %A
3Cables8,0007.5 %84.9 %A
4Brackets5,0004.7 %89.6 %B
5Nuts3,0002.8 %92.5 %B
6Wall plugs2,5002.4 %94.8 %B
7Washers1,8001.7 %96.5 %B
8Tape1,5001.4 %97.9 %C
9Cable ties1,2001.1 %99.1 %C
10Gloves1,0000.9 %100 %C
Classes
  • Class A: 3 items (30 % of items) with 84.9 % of total value
  • Class B: 4 items (40 % of items) with 11.6 % of total value
  • Class C: 3 items (30 % of items) with 3.5 % of total value
  • An item that crosses the limit still counts in the better class, so A reaches at least the A limit.
The 80/95 limits are guide values. Whether an item is truly important also depends on lead time, risk and strategy, not just value.

How it is calculated

In the example list, 3 of 10 items (30 %) make up about 85 % of the total value: these are the A items. ABC analysis separates the important from the less important by classifying items by their share of value.

How it is calculated

First all items are sorted by value in descending order. Then the calculator works out each item's share of the total and the running total. The items that together reach the A limit (usually 80 %) form class A, those up to the B limit (usually 95 %) class B, and the rest class C. This follows the Pareto principle: a small part of the items produces most of the value.

What the classification is for

Frequently asked questions

What is an ABC analysis?

A method of classifying items such as products or customers by their share of value into class A (very important), B (medium) and C (less important).

How do you do an ABC analysis?

Sort by value in descending order, form shares and cumulative shares and set the class boundaries at limits such as 80 % and 95 %. The calculator does this from your list.

What limits are usual?

Often 80 / 15 / 5: A up to 80 % of value, B up to 95 %, C the rest. You can change them in the calculator.

How do I enter the data?

One line per item, name and value separated by a semicolon. Numbers with a point or comma work; a line with only a number gets numbered.

Sources and legal basis

As of: · Editorial policy

Related tools