How to use ABC Inventory Analyzer
- Provide a unique SKU, period usage and unit cost for each product.
- Enter increasing A and B cumulative percentage boundaries.
- Read the descending value report and the cumulative share after each tie group.
- Export the bands alongside their usage-value evidence.
Example: ABC Inventory Analyzer
Rank usage value with explicit cumulative bands and tie rules.
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.