Warehouse Management
Example of ABC Pareto Analysis for Warehouse Management
Example calculation of ABC analysis for warehouse management using pick frequency.
What it does
Example calculation of ABC analysis for warehouse management using pick frequency.
Rank counts how often each product is picked and groups products into A, B and C classes.
- Ranks every SKU by how often it is picked
- Groups SKUs into A, B and C classes you can set yourself
- Shows the result as a table as well as a chart
See it in action
A worked example
Six SKUs and the number of times each was picked last month. Rank sorts them from most to least picked and groups them by share of all picks.
| Rank | Product | Picks | Share of picks | Class |
|---|---|---|---|---|
| 1 | SKU-104 | 4,200 | 42% | A |
| 2 | SKU-017 | 2,800 | 70% (running) | A |
| 3 | SKU-233 | 1,500 | 85% (running) | B |
| 4 | SKU-090 | 900 | 94% (running) | B |
| 5 | SKU-312 | 400 | 98% (running) | C |
| 6 | SKU-455 | 200 | 100% (running) | C |
Put the A SKUs in the easiest-to-reach pick faces.
What data it needs
You import these once for your Site. Every Tool-module that needs them uses the same data.
- Order Lines