methodatlas
Method guideOperations

ABC Analysis

A practical method guide: clarify prerequisites and materials, understand the complete process, and look up outputs, pitfalls, and stop criteria.

ComplexityLow
Time30-60 min
Participants1-5
FormatAsync
MaturityCanonical
Plan
01

Prerequisite

What needs to be finished first

Complete firstConsistent valuation

Usage and price per item use the same period and currency.

Different periods produce unfair classes.
Complete firstClass thresholds

Thresholds and treatment of boundary-crossing items are agreed before classification.

80/95 are possible thresholds, not universal requirements.
02

Preparation

What needs to be ready before start

Materials

Item list with usage and unit value, spreadsheet, class thresholds and criticality flags.

People / roles

Inventory or portfolio owner, analyst and people familiar with supply risks.

Pre-read

Define the item population, valuation period, price unit and intended control decision.

Time needed

30–60 minutes analysis; regular reclassification

Setup

Create one row per item and columns for usage, price, value, share, cumulative share, class and policy; record thresholds separately.

03

Core question

The one question this method answers

What level of control does each item need given its value contribution?

04

Flow

Phases with goal, actions, output and pitfall

ABC analysis sorts items by a consistent value contribution and assigns A, B and C using agreed cumulative thresholds. Each class receives a different level of control.

ABC Analysis· worksheet

Fictional example

ABC analysis sorts items by a consistent value contribution and assigns A, B and C using agreed cumulative thresholds. Each class receives a different level of control.

ABC Analysis· worksheet
RankItemAnnual usage value (€)Share (%)Cumulative (%)ClassControl policy
1Enter category and measurements; calculate from unrounded values.Motor6,0006060AReview weekly
2Enter category and measurements; calculate from unrounded values.Sensor2,0002080AReview weekly
3Enter category and measurements; calculate from unrounded values.Housing1,5001595BReview monthly
4Enter category and measurements; calculate from unrounded values.Label5005100CReview quarterly

  1. 1. Item

    1
    Motor
    2
    Sensor
    3
    Housing
    4
    Label

  2. 2. Annual usage value (€)

    1
    6,000
    2
    2,000
    3
    1,500
    4
    500

  3. 3. Share (%)

    1
    60
    2
    20
    3
    15
    4
    5

  4. 4. Cumulative (%)

    1
    60
    2
    80
    3
    95
    4
    100

  5. 5. Class

    1
    A
    2
    A
    3
    B
    4
    C

  6. 6. Control policy

    1
    Review weekly
    2
    Review weekly
    3
    Review monthly
    4
    Review quarterly

Fictional: 100 × €60 = €6,000, 200 × €10 = €2,000, 300 × €5 = €1,500, 1,000 × €0.50 = €500; total €10,000. A through 80%, B through 95%, then C.

Oracle Inventory: Overview of ABC Analysis

  1. 1

    Value

    Calculate contribution

    Goal

    Comparable item values

    Inputs for this step

    • Usage
    • Unit prices

    Actions

    • Calculate usage × unit value for each item and sum all values.
    • Check period, currency, zero values and missing prices.

    Output

    Comparable item values

    Are usage and price complete and comparable?

    Quality check

    Are usage and price complete and comparable?

    Pitfall

    Unit prices alone determine rank. Multiply by usage; complete missing data before classification.

    Timing: 10–15 minutes

  2. 2

    Rank

    Rank and shares

    Goal

    Cumulative value distribution

    Inputs for this step

    • Comparable item values

    Actions

    • Sort items descending; share = item value / total × 100, cumulative = running value sum / total × 100.
    • Round only for display.

    Output

    Cumulative value distribution

    Do the total and cumulative 100% reconcile?

    Quality check

    Do the total and cumulative 100% reconcile?

    Pitfall

    The same item appears multiple times. Consolidate item IDs and recalculate values.

    Timing: 10–15 minutes

  3. 3

    Classify

    Assign A, B and C

    Goal

    Traceable ABC classes

    Inputs for this step

    • Value distribution
    • Thresholds and boundary rule

    Actions

    • Apply cumulative thresholds and the boundary rule; record each assignment.
    • Example rule: A through 80%, B through 95%, above that C.

    Output

    Traceable ABC classes

    Is a boundary-crossing item assigned unambiguously?

    Quality check

    Is a boundary-crossing item assigned unambiguously?

    Pitfall

    Thresholds are changed to obtain desired classes. Apply the original rule; justify substantive exceptions separately.

    Timing: 10–15 minutes

  4. 4

    Control

    Agree control policies

    Goal

    Control and review policies

    Inputs for this step

    • ABC classes
    • Supply risks

    Actions

    • Set review intervals and owners per class; also flag critical or volatile items.
    • Agree the next valuation period and triggers for early reclassification.

    Output

    Control and review policies

    Does every class have a practical control policy?

    Quality check

    Does every class have a practical control policy?

    Pitfall

    A, B and C receive identical treatment despite the analysis. Deliberately vary control effort and protect minimum supply for every class.

    Timing: 10–15 minutes

05

Artifact

What comes out at the end

Sketch: what the artifact looks like

ABC Analysis · WertklassenWenige A-Items tragen den größten Wert, viele C-Items werden leichter gesteuert
ABC Analysis WertklassenDie Skizze zeigt sortierte Items mit kumulativem Wertverlauf, A-, B- und C-Klasse sowie passende Steuerungsregeln.Nach Wertbeitrag klassifizierenItems sortieren, kumulierten Wert sehen und daraus passende Steuerungsregeln ableiten.Aca. 70-80%wenige Items, hoher WertBca. 15-25%mittlere SteuerungCRestwertviele Items, kleiner WertWert100%Items sortiertkumulierter WertGrenze zwischen Fokus und RoutineSTEUERUNGSLOGIKAeng steuernTop-Items prüfenRisiken aktiv managenBregelmäßig prüfenStandard-Rhythmusklare GrenzwerteCvereinfachenAutomatisierenbündeln oder reduzieren
Form

Item-class matrix with annual usage value, share, cumulative share, class and control policy.

Versioning / ownership

Record date and scope; retain the previous version and reason when changing it.

Tool alternatives
  • Spreadsheet
  • Inventory-system ABC report
  • Exported item list with formulas

abc-analysis-working-template.md

Define the item population, valuation period, price unit and intended control decision.

ABC Analysis: Worksheet

Question

To be confirmed

Desired outcome

To be confirmed

Scope

Complete cycle Time: 30–60 minutes analysis; regular reclassification

Complete this worksheet on paper or in your own document during the work.

Preparation for this scope

Method setup

  • Materials: Item list with usage and unit value, spreadsheet, class thresholds and criticality flags.
  • Roles: Inventory or portfolio owner, analyst and people familiar with supply risks.
  • Advance information: Define the item population, valuation period, price unit and intended control decision.
  • Overall time needed: 30–60 minutes analysis; regular reclassification
  • Setup: Create one row per item and columns for usage, price, value, share, cumulative share, class and policy; record thresholds separately.

Prepare for the work steps

Value: Calculate contribution

  • Usage
  • Unit prices

Rank: Rank and shares

  • Comparable item values

Classify: Assign A, B and C

  • Value distribution
  • Thresholds and boundary rule

Control: Agree control policies

  • ABC classes
  • Supply risks

ABC Analysis· worksheet

RankItemAnnual usage value (€)Share (%)Cumulative (%)ClassControl policy
1
2
3
4
  • 1: Enter category and measurements; calculate from unrounded values.
  • 2: Enter category and measurements; calculate from unrounded values.
  • 3: Enter category and measurements; calculate from unrounded values.
  • 4: Enter category and measurements; calculate from unrounded values.

Record metric, period and total. Share = value / total × 100; cumulative = running sum / total × 100. Sort descending; for ABC also define thresholds and the boundary rule.

Oracle Inventory: Overview of ABC Analysis

Value: Calculate contribution

Expected artifact: Comparable item values

Are usage and price complete and comparable?

Entry:

...

  • Are usage and price complete and comparable?

Rank: Rank and shares

Expected artifact: Cumulative value distribution

Do the total and cumulative 100% reconcile?

Entry:

...

  • Do the total and cumulative 100% reconcile?

Classify: Assign A, B and C

Expected artifact: Traceable ABC classes

Is a boundary-crossing item assigned unambiguously?

Entry:

...

  • Is a boundary-crossing item assigned unambiguously?

Control: Agree control policies

Expected artifact: Control and review policies

Does every class have a practical control policy?

Entry:

...

  • Does every class have a practical control policy?

Open questions and next steps

...

Method guide: https://methodatlas.meierhoff-systems.de/en/methods/abc-analysis/run-sheet

06

Example output

Concrete filled scenario, fictional example

Fictional example for orientation. Counts and timings describe this case and are not universal requirements.

abc-analysis-beispiel.md

Concrete filled scenario, fictional example

Fictional example

Valuation basis: Fictional: annual usage value of four items: 100 × €60, 200 × €10, 300 × €5, 1,000 × €0.50. Total €10,000.

Class thresholds: A: cumulative ≤80%, B: >80 through ≤95%, C: >95%. A crossing item belongs to the class of its ending cumulative value.

Classification and control: Motor 60% A; sensor cumulative 80% A; housing 95% B; label 100% C. Review A weekly, B monthly, C quarterly.

07

Pitfalls

Recognize symptoms and steer against them

Quick overview, the full text is in the matching phase in the flow

  1. Calculate contributionUnit prices alone determine rank.View in phase
  2. Rank and sharesThe same item appears multiple times.View in phase
  3. Assign A, B and CThresholds are changed to obtain desired classes.View in phase
  4. Agree control policiesA, B and C receive identical treatment despite the analysis.View in phase
08

Stop criteria

When to pause, resolve prerequisites, or choose another approach

Low value does not imply low criticality. Critical spares receive justified additional controls regardless of C classification.

Method after Inventory Management Community. ABC Analysis transfers Pareto logic to inventories, customers, or work items. Curated with 1 sources.

Sources: Oracle Inventory: Overview of ABC Analysis

Flow, timeboxes, and pitfalls are editorially curated practice recommendations based on the listed sources.

Where to go next?

Paper illustration of a four-column Kanban board with limited ongoing work, a visible blocker and a review loop.
Engineering
Kanban

Reflects the control intensity per class in differentiated card rules.

Visual Management workspace showing the question, observations, and next decision.
Operations
Visual Management

Makes the control rules per class visible to everyone.

Finished the method guide?

Go to the profile for purpose, similar methods, and sources or continue to the next method in the catalog.

Go to profileMore methods