Most planning teams already rank their assortment. Pull sales by choice into Excel. Sort descending. Draw a line. The top of the list is your A's. The tail is your C's.

That ranking tells you how much each choice sold. It doesn't tell you whether you could have seen it coming.

Same Total, Different Bet

Picture two choices that finish the season with the same sales:

• The core tee: sold a steady number of units every week.
• The trend piece: sat flat for weeks, then spiked hard after a social moment.

A sales-only ranking puts both in the A bucket and invites the same buy for both. You know they're different bets. But that knowledge lives in your head, not on the grid.

What a One-Dimensional Ranking Costs You

• Time and shifting rules. Someone rebuilds the ranking before every line review. Thresholds change depending on who built the sheet. Volatility gets judged by scrolling through weekly sales one choice at a time, or it doesn't get judged at all.
• Distorted buy depth. Buy an erratic A like a steady one and you carry more inventory than the demand signal supports. That excess tends to end up in markdown. Treat a steady choice as cautiously as a volatile one and you miss sales on the items you had the best shot at getting right.
• A flawed cut list. A sales-only ranking makes every low-volume choice look like a cut. Some are low-volume but highly predictable. Others are low-volume and erratic. Lump them together and your cut list is built on half the picture.
• Anecdote-driven line reviews. Merchants cite what they saw on the floor. Planners cite a spreadsheet the merchants didn't build. Without a shared grade, the loudest anecdote often wins.
• Unmeasured portfolio risk. If the method changes every season, you can't compare this season's mix to last season's. Nobody can tell leadership whether the assortment is getting easier or harder to plan.

How to Grade on Two Axes

The fix is to grade every choice on two axes and then turn the grade into a decision rule.

• Contribution (ABC): how much each choice drives sales, units, or margin. A's are the small group that drives most of the total. C's are the long tail.
• Predictability (XYZ): how much weekly sales vary relative to their average. This is usually measured with the coefficient of variation.
  
  • X: sells at a steady rate week to week.
  • Y: moderate variability.
  • Z: swings hard.

Where the value is: Most choices land where you'd expect. The value is in the minority where volume and predictability disagree: the erratic A's (AZ) and the steady C's (CX). Those are the calls a one-dimensional ranking gets wrong.

Four Rules to Set Once

1. Match the metric to the decision. Rank on margin when you're deciding what to keep. Rank on units when you're sizing buys.
2. Fix your cutoffs. Pick contribution thresholds, such as the common 80/15/5 split, and keep them. If an A means the same thing every season, you can compare seasons.
3. Choose a window that fits the product. A seasonal item measured over a short window can look erratic even when it's following a reliable seasonal pattern. Short-lifecycle styles have less history, so the window matters even more there.
4. Compare like with like. Ranking outerwear against socks distorts both axes, and so does ranking wholesale against DTC. Grade within comparable groups such as category, channel, or hierarchy level.

The Segment Playbook

Here's a common starting playbook for a seasonal buy:

In apparel, the AX/AZ split is the basic tee sitting next to the trend piece.

Make the Grade Part of the Decision

Put it where you make the call. A classification that lives in a separate workbook gets ignored at the buy grid. It belongs next to the choice in the line plan, where you can sort and filter during review.

Re-run it on a cadence and watch the mix. Track how the share of choices and dollars in each segment moves over time. A growing Z share is an early warning that the assortment is getting harder to plan. That's the trend line leadership has been missing.

Make the Matrix Automatic, Not a Side Spreadsheet

Planners don't skip two-axis grading because they doubt it works. They skip it because keeping it current is painful. Calculating variability by choice, inside each category and channel, and keeping it in sync as the line plan changes is where spreadsheets break down.

Toolio's ABCXYZ Analysis takes that work off your plate. You set the rules once (metric, cutoffs, window, grouping), and Toolio grades every choice on performance and demand predictability. The combined ABCXYZ grade shows up as a column on your Line Plan grid, so you can sort and filter by segment in the review where merchants and planners make the call together. Every season gets graded the same way, so the mix trend is there when leadership asks.