Free ABC-XYZ Analysis Tool

Sort your range by volume and predictability, so you know where to focus, what to automate and what to question.
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.

Coefficient of variation: std dev divided by average

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.

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.