Free ABC-XYZ Analysis Tool
Not every item deserves the same planning effort. This sorts your range by how much each item matters and how predictable it is, so you know where to focus, what to automate and what to question.
ABC-XYZ analysis
Sort your range by how much each item matters (ABC) and how predictable it is (XYZ). It tells you where to spend planning time, where to automate and what to question. Nothing is uploaded: the numbers stay in your browser.
XYZ needs at least 4 periods; 12 to 26 is better. Use units for a volume view or dollars for a value view. One number per row gives ABC only.
The matrix: number of items, and their share of volume
ABC ranks items by total volume across all periods: A items make up the first 80% of volume, B the next 15%, C the rest. XYZ uses the coefficient of variation (standard deviation divided by average) across periods: X is steady, Y is variable, Z is erratic or intermittent. Promotions and stockouts make items look more erratic than they are, so clean the history first if you can. The cut-offs are common starting points, not standards.
Related
- What Is Demand Planning? A Practical Guide
- Do You Even Need a Demand Forecast?
- Nerd Foods dataset (realistic data to practise on)
- All free Nerd Tools
Want someone to look at the whole picture? The Planning Health Check from Forward Cover reviews your forecasting, inventory and supply planning and tells you where the money is leaking.