Assortment Rationalization: The 80/20 Rule, the 9-Box Matrix, and the Volume You Get Back

Walk into a planning room that has not done a serious portfolio review in three years and you will find the same pattern. Forty SKUs in the brand range. Eight of them do most of the work. Fifteen of them sit at the bottom of the velocity report month after month, each one contributing a fraction of a percent of revenue, none of them quite small enough to delist on their own. Between them they take up 27 percent of the supply chain's work and cost, a third of the trade‑marketing team's time, and a real share of the yearly listing‑fee budget.

That is the long tail. Teams usually treat it as a marketing problem, when it really comes from how the range itself got built. Trimming it back to the SKUs that earn their place is what assortment rationalization means.

The brutal version of the 80/20 rule

In most FMCG brand portfolios the Pareto split is sharper than the textbook version suggests. The top 20 percent of SKUs typically generates 70 to 80 percent of revenue. The bottom 50 percent of SKUs delivers under 10 percent of revenue and under 5 percent of margin. Every one of those tail SKUs costs money to make, ship, list, plan, and forecast, regardless of how few units it sells.

What rationalization actually buys you

A clean rationalization sweep does three things at once. First, the SKUs that stay pick up the volume. Most shoppers who used to buy a variant you dropped do not walk out of the brand or the category. They move across to whatever you still sell. Where a lot of those shoppers already buy your other packs, 50 to 80 percent of the delisted volume stays with the brand, landing on whichever remaining SKU is closest to what they lost. The rest walks, and that is the price of the cut. Second, the supply chain gets simpler: fewer production changeovers, fewer SKUs to forecast, and fewer gaps in distribution to chase down. Third, the shelf space and the listing money you free up can go behind new products that stand a chance of mattering, rather than sitting under lines nobody is buying.

Be clear‑eyed about the size of each prize. The tail is small in volume by definition, so holding on to most of it barely moves total brand sales. The money is in the complexity you stop paying for and the budget you get to spend somewhere else.

Where it goes wrong

Assortment rationalization fails for one reason more often than any other. A SKU that looks bad on the standard velocity‑and‑margin report is sometimes the only reason a particular shopper segment walks the aisle at all. The only gluten‑free option in the range. The only children's flavor. The only premium‑tier line for the gifting trip. Cut that SKU and what you lose is a lot more than its 0.3 percent of revenue. You lose the whole basket that shopper would have filled on the same trip, fast sellers and all.

Two tools do most of the work in a portfolio review. The first is the velocity‑margin grid, which plots every SKU by how fast it sells against the margin it earns, and tells you what job each one is doing. The second is the three‑filter delist rule, which hands you a short list of SKUs to cut, and you then check that list by hand before anything comes off shelf.

The velocity‑margin grid

Plot every SKU on a grid. The horizontal axis is volume velocity (units per store per week, or share of brand volume). The vertical axis is margin contribution (percent gross margin, or absolute gross profit per kilo). Three bands on each axis (Low, Mid, High) give you nine SKU roles.

The roles tell you what each SKU is for.

• Top right (High velocity, High margin): the heroes. These are the engine of the brand. Protect them at all cost.
• Top‑middle (Mid velocity, High margin): the upgraders. Often premium‑tier SKUs. Worth nurturing toward the top right.
• Middle‑right (High velocity, Mid margin): the workhorses. Big volume, average margin. The Routine pack lives here.
• Bottom‑right (High velocity, Low margin): the entry SKUs. Loss‑leaders or price‑fighters. Earn their place by trip‑driving.
• Middle‑middle: the unclear ones. Decide what role they play, or kill them.
• Top‑left (Low velocity, High margin): the niches. Premium‑tier rarities, gifting SKUs. Worth defending when they are the only thing you sell into their corner of the category.
• Bottom‑left (Low velocity, Low margin): the tail. These come off the list unless the SKU is holding a job in the range that you can name out loud.

The three‑filter delist rule

A SKU is an automatic delist candidate when ALL THREE of the following hold at the same time. Any one of them on its own is not enough.

Filter 1: Category share below 0.1 percent
The SKU sells less than one unit per thousand of category volume. It is invisible at shelf and at scale.

Filter 2: Distribution under 30 percent
The SKU is on shelf in fewer than three of every ten stores that could stock it. It may well sell at a decent rate in the stores that do carry it, and it is still sitting in too few of them to be worth what it costs to make, ship and plan.

Filter 3: Year-on-year trend worse than minus 20 percent
The SKU is shrinking fast, and it has been shrinking in the same direction long enough that you can rule out one bad quarter.

When all three fire at once, the SKU is on the cut list. You then run the sense‑check (next section) to confirm.

The cross‑SKU overlap sense‑check

Before any SKU on the automatic cut list is actually delisted, run one more test. Pull the data that follows the same households over time, either a purchase panel or the retailer's loyalty‑card records. Then ask one question. Of the shoppers who bought this SKU in the last 12 months, what share of them also bought something else of yours, on the same trip or anywhere in the same period?

• Overlap above 80 percent: safe to cut. These shoppers are buying the brand as much as the SKU, so they move to something else of yours and the volume lands where you expect it to.
• Overlap 50 to 80 percent: cut with care. Some shoppers will be lost, but the bulk will stay. Acceptable.
• Overlap under 50 percent: this SKU is either the reason those shoppers make the trip, or the only thing in the range that suits them. Cut it and the shopper goes with it. Think again, or cut it alongside a plan to walk those shoppers onto a substitute, with shelf signage and whatever you say about the range in store.

Imagine a mid‑sized biscuit brand with a 40‑SKU range that has grown unchecked for six years. Every product manager who passed through left two or three new SKUs behind. Nobody ever cut anything. The range has the shape of a brand that has been adding without pruning.

The starting picture

A weekly velocity ledger pulled across the full range shows the classic long tail.

• The top 8 SKUs deliver 81 percent of revenue, and they are the core flavors in their main pack sizes plus the family share‑pack. These are the heroes and the workhorse from the grid.
• SKUs 9 through 12 deliver another 9 percent. Mid‑tier variants, including the chocolate‑coated upgrade and the seasonal limited edition that has somehow stayed on shelf for two years.
• SKUs 13 through 25 deliver 9 percent between them. Each one sits at 0.5 to 1.2 percent of brand revenue. Most are flavor variants of the core line.
• SKUs 26 through 40 deliver under 1 percent collectively. All but one sit below 0.1 percent category share (the exception reads 0.11). Distribution runs under 30 percent for fourteen of the fifteen, with one at 32. The trend against a year ago sits between minus 19 and minus 35 percent, and fourteen of the fifteen are falling faster than the minus 20 line the third filter draws.

Running the three‑filter rule

Of the bottom 15, twelve fail all three filters at once: under 0.1 percent category share, under 30 percent distribution, and a trend worse than minus 20 percent against last year. Three sit slightly above one threshold each (one has 32 percent distribution, one has minus 19 percent trend, one has 0.11 percent share). The 12 are automatic cut candidates. The 3 are reviewed individually.

The cross‑SKU overlap test saves a SKU the filters condemned

The overlap numbers, pulled from loyalty‑card records, sort the cut candidates into clearly separated groups.

• 9 of the 12 candidates overlap with the rest of the brand above 80 percent. The shoppers who pick up these slow lines are nearly always buying one of the heroes on the same trip. Cutting them is safe, because the volume moves across to the SKUs that stay.
• 2 of the 12 candidates show overlap between 50 and 80 percent. These will lose some shoppers but most will stay. Acceptable cuts, with mild trade communication.
• 1 of the 12 candidates shows overlap of 23 percent. This is the gluten‑free variant. It is the only gluten‑free product in the range. The 23 percent of shoppers who buy it almost never buy anything else from the brand because the rest of the range is not for them. Cutting this SKU does not save 0.08 percent of revenue. It loses the entire 0.6 percent of revenue that the gluten‑free shoppers contribute across other categories the brand competes in.

The gluten‑free SKU stays. The other 11 are scheduled for delisting in two phases.

What landed after phase one

Six SKUs came off in the first cycle. Between them they carried 0.6 percent of brand volume, six listing slots, and roughly 15 percent of the SKUs the supply chain had to plan for. Across the next two quarters:

• 72 percent of the delisted volume stayed with the brand, landing on whatever was closest to what the shopper had lost. The family share‑pack, the nearest thing to two of the cut multipacks, took the biggest single share of it. The three core flavors and the chocolate‑coated upgrade picked up the rest.
• The other 28 percent walked, to a competitor or out of the category altogether. That is the price of the cut, and it is real.
• Net brand volume landed about 0.2 percent below where it would have been without the cut, which is just what you get from keeping 72 percent of 0.6 percent and losing the rest.
• Gross margin improved, because the delisted SKUs were among the lowest‑margin lines in the range and their volume moved to better ones.
• Forecasting in the supply chain got measurably more accurate, which handed the planning team back hours they spent on the new premium‑tier launch in cycle three.
• One retailer pushed back hard on the cut list and demanded one of the delisted variants be reinstated. The brand declined, and the retailer accepted, because the substitution onto the survivors was visible in the retailer's own scan data within eight weeks.

What this confirms

The share of volume that moved across came in near the top of the expected range: 72 percent of the delisted volume retained, against the 50 to 80 percent you should expect when shopper overlap is high.

Keep the size of the prize in proportion, though. What came off was 0.6 percent of volume, so even perfect substitution would have left the brand roughly where it started, and it ended the cycle fractionally smaller. What the cut bought was a simpler supply chain, a better mix of margins across what remained, six listing slots back, and the planning hours that paid for the premium launch. Any business case that promises volume growth from cutting the tail is selling you something. The growth turned up in cycle three, out of what the freed budget bought.

The overlap rule paid for itself on the gluten‑free line. A brand working from the velocity and margin report alone would have cut it, lost a profitable group of shoppers along with it, and had nothing in the numbers to tell them why.

After SKU 12 the curve runs almost flat, which means every SKU you add past that point brings in next to nothing. The shaded block from SKU 26 onward is the tail: 15 SKUs carrying under 1 percent of revenue and 27 percent of what the supply chain costs to run. That is the shape a range takes when nobody has been pruning it.

Rationalization done well feels boring. Done badly, it comes back to you six months later as smaller baskets, an unhappy retailer asking for a meeting, and a rush to get delisted lines back on shelf. What separates the two is the order you do things in.

Step 1: Build the SKU ledger

Pull every SKU in the brand range with the same six numbers against each one. Units sold over the last 12 months, sales value over the same 12 months, gross margin percent, the share of relevant stores that stock it, its share of the category, and how it is trending against a year ago. One row per SKU. No exceptions, even for the SKUs everyone "knows" are core. The ledger is the discipline. Once a senior leader's pet SKU shows up in the same Excel as everything else, the conversation changes.

Step 2: Plot the Pareto curve

Sort the ledger by velocity, descending. Compute cumulative revenue percent. The shape of the curve tells you how concentrated the brand is. A healthy brand might hit 80 percent of revenue by SKU 8 of 40, 90 percent by SKU 12, 99 percent by SKU 25. Everything past SKU 25 is the tail.

Step 3: Apply the three‑filter rule

Run the automatic‑delist filter on every SKU. Mark the candidates. This is typically 20 to 40 percent of the SKU count and well under 5 percent of revenue.

Step 4: Run the cross‑SKU overlap test

For every candidate, pull the shopper‑overlap number. Reclassify any SKU with under 50 percent overlap as "review individually, do not auto‑cut".

Step 5: Phase the cuts

Do not delist 15 SKUs in one cycle. Most retailers will resist a wholesale range cut and most internal teams will struggle to manage the transition cleanly. A typical run: cut the 5 clearest cases this cycle, the next 5 in the following cycle six months later, and hold the last 5 back until the first 10 have shown you the volume really does move across to the SKUs that stayed.

Step 6: Use the freed listing budget for innovation

The point of rationalization is to take the shelf space, the listing fees, the promotional money and the planners' hours you have just freed up, and put them behind something that can move the brand. That means a new variant in a tier that is growing, a launch aimed at an occasion next door to the one you already own, or a step up into the premium tier. A brand that cuts and then spends none of what it freed ends up smaller without growing any faster, which is the worst version of both outcomes.