BYTETOOLS

ABC Inventory Analysis Calculator

Paste SKUs with annual usage and unit cost to rank them by consumption value and classify them into A, B and C at editable Pareto cut-offs.

12
Items classified
$409,310
Total annual value
5 (41.7%)
Class A items
78.4%
Class A value share
ClassItems% of itemsAnnual value% of value
A541.7%$320,73078.4%
B325.0%$56,29013.8%
C433.3%$32,2907.9%
#SKUAnnual usageUnit costAnnual value% of valueCumulative %Class
1SEN-4120150$640.00$96,000.0023.5%23.5%A
2MTR-900145$1,850.00$83,250.0020.3%43.8%A
3VLV-2210300$210.00$63,000.0015.4%59.2%A
4PMP-10011,200$48.50$58,200.0014.2%73.4%A
5HSE-53002,600$7.80$20,280.005.0%78.4%A
6BRG-30509,400$2.15$20,210.004.9%83.3%B
7CPL-8140760$26.00$19,760.004.8%88.1%B
8FLT-60154,800$3.40$16,320.004.0%92.1%B
9ADP-3390980$14.25$13,965.003.4%95.5%C
10GSK-700215,200$0.42$6,384.001.6%97.1%C
11SWT-11203,100$1.95$6,045.001.5%98.6%C
12CBL-22406,700$0.88$5,896.001.4%100.0%C

annual consumption value = annual usage × unit cost  ·  sort descending  ·  class = A while cumulative % ≤ 80, B while ≤ 95, otherwise C

Worked example: a motor used 45 times a year at $1,850.00 each is worth $83,250.00 a year, while a gasket used 15,200 times at $0.42 is worth only $6,384.00. The motor lands in class A on two orders a year; the gasket, despite being the highest-volume line, sits in C.

ABC is a Pareto ranking on annual consumption value, so it deliberately ignores criticality: a cheap gasket that stops the line when it is missing still needs a policy, which is why many planners overlay a second criticality dimension. The 80/95 cut-offs are conventions, not rules — adjust them above and the classes re-sort instantly. Your SKU list is parsed entirely in your browser and never uploaded.

What is the ABC Inventory Analysis Calculator?

ABC analysis is Pareto's rule applied to stock: a small share of SKUs accounts for most of the money tied up in inventory, and those are the ones worth managing tightly.

  • Annual consumption value from usage × unit cost, sorted descending
  • Cumulative Pareto percentage with an inline progress bar per row
  • Editable A and B cut-offs, defaulting to 80% and 95%
  • Class summary with item count, item share, value and value share
  • Handles comma, semicolon or tab separated data with quoted fields
  • CSV download and copy of the fully classified list

How to use the ABC Inventory Analysis Calculator

  1. 1

    Paste your SKU list: item name, annual usage in units, unit cost — one row per item.

  2. 2

    Leave a header row in if you have one; it is detected and skipped automatically.

  3. 3

    Adjust the class A and class B cumulative cut-offs if 80% and 95% do not suit your catalogue.

  4. 4

    Read the class summary for the count and value share of A, B and C items.

  5. 5

    Download or copy the classified CSV to take the classes back into your planning system.

About the ABC Inventory Analysis Calculator

ABC analysis is Pareto's rule applied to stock: a small share of SKUs accounts for most of the money tied up in inventory, and those are the ones worth managing tightly. Paste a list of items with their annual usage and unit cost, and this tool multiplies them into annual consumption value, sorts descending and builds the cumulative Pareto curve.

Items are classified A, B or C at cut-offs you control — 80% and 95% by default, but both are editable because the conventional split rarely matches a real catalogue exactly. The summary shows how many items and how much value sit in each class, and the ranked table shows every SKU with its share and cumulative percentage.

Your list is parsed entirely in your browser. Nothing is uploaded, stored or sent to a server, so it is safe to paste a real SKU export. The classified result can be downloaded as CSV or copied straight back into a spreadsheet.

Frequently asked questions

How does ABC analysis classify inventory?

Items are ranked by annual consumption value — annual usage multiplied by unit cost — then split by cumulative share. Class A is typically the top 80% of value, class B the next 15%, class C the remaining 5%. The counts usually land near 20, 30 and 50 percent of items, but that is an outcome, not a rule.

What data do I need for ABC analysis?

Three columns: an item identifier, the quantity used or sold in a year, and the cost of one unit. That is enough to compute annual consumption value, which is the only thing the ranking depends on. Unit cost should be your purchase cost, not the retail price.

Why are the 80/20 cut-offs adjustable?

Because real catalogues rarely split cleanly at 80%. A business with a few dominant SKUs might put class A at 70%, while a long-tail distributor might push it to 85%. Both cut-offs are editable here and the classes re-sort as soon as you change them.

Does a cheap part always end up in class C?

By value, yes — and that is ABC's blind spot. A two-cent gasket that stops the production line when it is missing still needs a policy. Many planners overlay a second criticality dimension, giving a matrix rather than a single letter, and treat critical C items like A items for availability.

How often should ABC analysis be rerun?

Usually quarterly, or after any major assortment change. Consumption value drifts as prices and demand move, and an item that was class C last year can quietly become class A. Rerunning it here takes seconds because the data stays in your browser.

Related tools