ABC Inventory Analyzer

Rank product usage value into configurable A, B and C bands while keeping equal-value products together.

On-device No sign-up Free to use

Classify usage value controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    ?

    ?

    Processed in your browser. Your inputs stay on this device.

    Result

    Showing an example.

    Rank usage value with explicit cumulative bands and tie rules.

    Usage values A=80, B=15 and C=5 with 80/95 boundaries produce A, B and C bands respectively. Their cumulative percentages are 80.0000, 95.0000 and 100.0000.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/abc-inventory-analyzer · 20 November 2026

    Was this helpful?

    How to use ABC Inventory Analyzer

    1. Provide a unique SKU, period usage and unit cost for each product.
    2. Enter increasing A and B cumulative percentage boundaries.
    3. Read the descending value report and the cumulative share after each tie group.
    4. Export the bands alongside their usage-value evidence.

    Example: ABC Inventory Analyzer

    Rank usage value with explicit cumulative bands and tie rules.

    You add
    Product usage: sku,usage,unit_cost A,80,1 B,15,1 C,5,1 A band cumulative boundary (%): 80 B band cumulative boundary (%): 95
    You get
    Usage values A=80, B=15 and C=5 with 80/95 boundaries produce A, B and C bands respectively. Their cumulative percentages are 80.0000, 95.0000 and 100.0000.

    Supported inputs and limits

    • Up to 2,000 products, 80 CSV columns and 2 MiB.
    • Usage and unit cost are nonnegative plain decimals, up to six decimal places; the combined value must be positive.
    • Use one currency and observation period.
    • Bands require 0 <= A < B < 100.
    • A tie group receives the band selected by cumulative share before that group, so it may cross a boundary.
    More details

    Zero-value rows fall into C.

    Classification is based on entered usage value, not demand forecasts or profitability.

    Where your input is processed

    This tool does not upload your inputs. See the limits for anything saved on your device.

    Questions about ABC Inventory Analyzer

    What happens when a product crosses the A boundary?

    The band uses cumulative share before that product or tie group. A group starting below the A boundary remains A even when its full value crosses the boundary.

    Are products with equal values split across bands?

    Equal exact usage values stay together. SKU ordering only makes their display order consistent; it does not split the tie group into different classes.

    Should I enter annual sales or current stock?

    Enter usage for one consistent period and its unit cost. Current stock alone measures a different question and does not establish period usage value.

    Page updated · Project managed by Tony Hines · Report a problem with ABC Inventory Analyzer