Assortment Optimization

The Assortment Optimization Mini Blueprint

The Assortment Optimization Mini Blueprint

A Step-by-Step System for Deciding What to Keep, Cut, Expand, Replace, or Test—Without Destroying Shopper Choice or Category Growth

Overview

Assortment optimization is not about cutting SKUs for the sake of simplicity.

It is about making every item earn its place by contributing to sales, margin, shopper choice, strategic relevance, or future growth.

The Assortment Optimization Mini Blueprint gives category managers a disciplined framework for evaluating products across productivity, incrementality, duplication, shopper need, price architecture, space efficiency, and strategic role.

Use it for:

  • Range reviews
  • Shelf resets
  • Annual category planning
  • New item reviews
  • SKU rationalization
  • Distribution expansion
  • Space reallocation
  • Retailer presentations
  • Portfolio simplification

The objective is simple:

Protect what matters. Remove what adds complexity without value. Expand what shoppers clearly want. Fill the gaps competitors are exploiting.

SECTION 1 — THE 5 OUTCOMES OF ASSORTMENT OPTIMIZATION

Every SKU should end up in one of five action buckets.

  1. PROTECT

Keep and defend because the item is strategically critical.

Typical signals:

  • High sales
  • High rate of sale
  • Strong incrementality
  • Important shopper need
  • Hero SKU
  • Strong margin
  • High loyalty
  • Essential price point

Typical Actions

  • Protect distribution
  • Increase facings
  • Improve availability
  • Maintain price position
  • Avoid unnecessary disruption
  1. EXPAND

Increase distribution, space, facings, or visibility.

Typical signals:

  • High velocity
  • Low current distribution
  • Strong growth
  • Strong shopper demand
  • High margin
  • Underrepresented segment

Typical Actions

  • Add stores
  • Add facings
  • Add secondary placement
  • Increase inventory
  • Expand digital availability
  1. MAINTAIN

Keep the SKU, but do not overinvest.

Typical signals:

  • Stable productivity
  • Clear shopper role
  • Acceptable margin
  • Limited strategic upside
  • Low risk

Typical Actions

  • Maintain current distribution
  • Monitor productivity
  • Keep shelf presence proportional
  1. INVESTIGATE / TEST

Do not make a permanent decision yet.

Typical signals:

  • Low sales but unique shopper role
  • New product
  • Seasonal item
  • Incomplete distribution
  • Recent pricing change
  • Poor availability distorting performance

Typical Actions

  • Test in selected stores
  • Improve availability
  • Run shopper research
  • Evaluate substitution
  • Monitor repeat purchase
  1. RATIONALIZE / REPLACE

Remove, reduce, or substitute the item.

Typical signals:

  • Low sales
  • Low velocity
  • Low incrementality
  • High duplication
  • Low margin
  • Declining relevance
  • Better alternative available

Typical Actions

  • Delist
  • Reduce distribution
  • Replace with whitespace item
  • Reallocate space
  • Transfer demand to a stronger substitute

SECTION 2 — THE ASSORTMENT OPTIMIZATION MASTER QUESTION

Before touching the range, ask:

If this SKU disappeared tomorrow, what would happen to the shopper, the category, and the retailer economics?

Possible answers:

Shopper simply switches to another SKU

Likely low incrementality.

Shopper leaves the category

High strategic importance.

Shopper shops a competitor

Potential competitive risk.

Shopper loses an important need state

Potential range gap.

Nothing material changes

Likely rationalization candidate.

SECTION 3 — THE 8-FACTOR SKU SCORECARD

Score every SKU from 1–5.

Factor Score
Dollar Sales Productivity ___
Unit Rate of Sale ___
Gross Margin Contribution ___
Growth Trend ___
Incrementality ___
Shopper Uniqueness ___
Strategic Fit ___
Space Efficiency ___

Maximum Score: 40

SCORE INTERPRETATION

34–40 — PROTECT / EXPAND

These SKUs are doing heavy lifting.

Consider:

  • More distribution
  • More facings
  • Better availability
  • Stronger visibility

27–33 — MAINTAIN / OPTIMIZE

Solid contributors.

Look for targeted improvements.

20–26 — INVESTIGATE

Performance is mixed.

Do not cut automatically.

Validate:

  • Shopper role
  • Incrementality
  • availability
  • distribution
  • seasonality

BELOW 20 — RATIONALIZATION CANDIDATE

Low overall contribution.

Evaluate substitution risk before removal.

SECTION 4 — PRODUCTIVITY ANALYSIS

The first question is:

How productive is the SKU relative to the space and distribution it consumes?

Review:

  • Sales
  • Units
  • Rate of sale
  • Sales per store per week
  • Sales per facing
  • Margin per facing
  • Distribution
  • Share of category sales

PRODUCTIVITY CHECKLIST

For each SKU:

Dollar Sales

$________

Unit Sales

Rate of Sale

________ units/store/week

Margin Dollars

$________

Distribution

________%

Facings

Sales per Facing

$________

Margin per Facing

$________

PRODUCTIVITY RED FLAGS

🔴 Low sales + high space

🔴 Low rate of sale + high distribution

🔴 Low margin + low strategic value

🔴 Declining sales + increasing space

🔴 Multiple low-selling near-identical SKUs

PRODUCTIVITY OPPORTUNITY SIGNAL

🟢 High rate of sale + low distribution

This often signals:

Expansion opportunity.

SECTION 5 — INCREMENTALITY ANALYSIS

Productivity alone is not enough.

A slow-selling SKU may still matter if it serves a unique shopper.

The critical question is:

Does this item create incremental category demand, or mostly steal demand from another SKU?

HIGH-INCREMENTALITY SIGNALS

A SKU may be highly incremental if it:

  • Recruits new shoppers
  • Serves a unique dietary need
  • Creates a new occasion
  • Occupies a missing price point
  • Provides a unique pack size
  • Introduces a new format
  • Appeals to an underserved segment

LOW-INCREMENTALITY SIGNALS

A SKU may be low incremental if it:

  • Closely duplicates another product
  • Serves the same need
  • Has nearly identical price
  • Has similar pack size
  • Has similar flavor or benefit
  • Mostly causes switching within the range

INCREMENTALITY QUESTIONS

Ask:

  1. Who buys this item?
  2. What would they buy instead?
  3. Would they leave the category?
  4. Would they leave the retailer?
  5. Does the item recruit anyone new?
  6. Does it create a unique occasion?
  7. Is there a true substitute?

SECTION 6 — DUPLICATION ANALYSIS

Duplication is one of the biggest hidden assortment costs.

Look for products that overlap across:

  • Benefit
  • Flavor
  • Pack size
  • Price point
  • Occasion
  • Format
  • Shopper need
  • Brand role

DUPLICATION GRID

SKU Need State Price Pack Benefit Likely Substitute
[SKU 1] [___] $[___] [___] [___] [___]
[SKU 2] [___] $[___] [___] [___] [___]
[SKU 3] [___] $[___] [___] [___] [___]

DUPLICATION TEST

If two items are very similar, ask:

Would deleting one materially reduce shopper choice?

If no:

Potential rationalization.

If yes:

Understand why before acting.

SECTION 7 — SHOPPER NEED-STATE COVERAGE

A good assortment does not maximize SKU count.

It maximizes meaningful choice.

Map the category against shopper needs.

NEED-STATE MAP

Value

Do we serve the most price-sensitive shopper?

□ Yes
□ No

Mainstream

Do we have strong core propositions?

□ Yes
□ No

Premium

Can shoppers trade up?

□ Yes
□ No

Convenience

Are there easy, fast, portable options?

□ Yes
□ No

Health / Wellness

Are relevant needs covered?

□ Yes
□ No

Indulgence

Is there an emotional/reward proposition?

□ Yes
□ No

Specialty

Are important niche needs served?

□ Yes
□ No

RANGE GAP QUESTION

Where does a shopper reasonably expect an option—but currently find nothing credible?

That is whitespace.

SECTION 8 — PRICE ARCHITECTURE CHECK

Map all SKUs against:

  • Opening price
  • Value
  • Mainstream
  • Premium

Ask:

  • Is the opening price credible?
  • Is the mainstream tier overcrowded?
  • Is premium underdeveloped?
  • Are there large price gaps?
  • Are two tiers priced too close together?

PRICE GAP TEMPLATE

Lowest Price

$________

Mainstream Sweet Spot

$________

Premium Entry

$________

Missing Price Band

$________ to $________

Opportunity

[INSERT]

SECTION 9 — PACK ARCHITECTURE CHECK

Map pack sizes.

Possible roles:

  • Trial
  • Single serve
  • Standard
  • Family
  • Bulk
  • On-the-go

Ask:

  • Are multiple SKUs clustered at the same size?
  • Is there a missing entry pack?
  • Is there a family-size gap?
  • Does the category have an impulse format?
  • Do price-per-unit relationships make sense?

PACK GAP EXAMPLE

Current range:

  • 250g
  • 275g
  • 300g
  • 325g

But no:

  • 100g trial
  • 750g family

This may indicate excessive clustering around one mission.

SECTION 10 — HERO SKU PROTECTION

Identify the products that carry the category.

Top 10 SKUs by Sales

Now check:

  • Distribution
  • OOS
  • Facings
  • Rate of sale
  • Margin
  • inventory

Red Flag

A top seller should not lose sales because it is under-faced while slow movers occupy excess space.

SECTION 11 — GROWTH SEGMENT REPRESENTATION

Do not optimize only using historical productivity.

A growth segment may deserve more space before it becomes large.

Ask:

  • Which segments are growing fastest?
  • What percentage of category growth do they contribute?
  • Are they under-ranged?
  • Are they under-spaced?
  • Do competitors have broader offerings?

GROWTH GAP FORMULA

[SEGMENT] represents [X]% of current sales but contributes [Y]% of growth, while receiving only [Z]% of assortment.

Recommendation

Expand representation in [SEGMENT], funded by duplicated or declining areas.

SECTION 12 — THE 2×2 SKU DECISION MATRIX

Plot each SKU across:

X-axis: Productivity
Y-axis: Incrementality

HIGH PRODUCTIVITY + HIGH INCREMENTALITY

ACTION:

Protect / Expand

These are ideal SKUs.

HIGH PRODUCTIVITY + LOW INCREMENTALITY

ACTION:

Maintain / Optimize

They sell well, but may substitute for others.

Watch total range duplication.

LOW PRODUCTIVITY + HIGH INCREMENTALITY

ACTION:

Investigate / Protect Selectively

These may serve:

  • Niche shoppers
  • Entry price
  • Specialty needs
  • strategic roles

LOW PRODUCTIVITY + LOW INCREMENTALITY

ACTION:

Rationalize

These are prime delisting candidates.

SECTION 13 — THE KEEP-CUT-EXPAND-REPLACE-TEST FRAMEWORK

For every SKU, assign one action.

KEEP

Use when:

  • Strong productivity
  • Clear role
  • High shopper relevance

CUT

Use when:

  • Weak productivity
  • Weak incrementality
  • High duplication

EXPAND

Use when:

  • High velocity
  • Underdistributed
  • High-growth

REPLACE

Use when:

  • SKU underperforms
  • Better whitespace opportunity exists
  • Shopper need remains important

TEST

Use when:

  • Evidence is incomplete
  • SKU is new
  • Strategic role is promising
  • Distribution is too limited to judge

SECTION 14 — SKU DECISION TEMPLATE

SKU

[INSERT]

CURRENT SALES

$________

RATE OF SALE

MARGIN

________%

DISTRIBUTION

________%

GROWTH

________%

INCREMENTALITY

High / Medium / Low

SHOPPER ROLE

[INSERT]

DUPLICATION RISK

High / Medium / Low

STRATEGIC ROLE

[INSERT]

RECOMMENDED ACTION

Protect / Expand / Maintain / Test / Replace / Rationalize

REASON

[INSERT]

SECTION 15 — DELISTING RISK CHECKLIST

Never delist based on sales alone.

Before removing a SKU, check:

□ Does it serve a unique shopper?
□ Does it occupy a unique price point?
□ Does it meet a specialty need?
□ Is it highly loyal?
□ Does it drive category entry?
□ Does it support premium perception?
□ Is performance suppressed by low distribution?
□ Is performance distorted by poor availability?
□ Is it seasonal?
□ Does it have strong digital sales?
□ Could deletion cause retailer switching?

If several are yes:

Investigate before cutting.

SECTION 16 — SUBSTITUTION PLANNING

For every rationalization candidate, identify:

SKU to Remove

[INSERT]

Primary Substitute

[INSERT]

Secondary Substitute

[INSERT]

Shopper Need Preserved?

Yes / No

Price Point Preserved?

Yes / No

Pack Need Preserved?

Yes / No

Estimated Transfer Rate

________%

SUBSTITUTION PRINCIPLE

The goal is not to delete demand.

The goal is to:

Transfer low-productivity demand into stronger products while preserving shopper satisfaction.

SECTION 17 — RANGE SIMPLIFICATION WITHOUT LOSING SALES

A smart rationalization program should aim to:

  • Reduce clutter
  • Improve navigation
  • Increase hero visibility
  • Improve availability
  • Increase productivity
  • Preserve shopper choice

SIMPLIFICATION TEST

If SKU count falls by 10%, ask:

  • What percentage of sales is at risk?
  • What percentage transfers?
  • What shopper needs remain?
  • What space becomes available?
  • What growth segments gain investment?

SECTION 18 — ASSORTMENT WHITESPACE BLUEPRINT

Use removed space strategically.

Do not simply cut and leave the range smaller.

Reinvest in:

Missing Price Points

[INSERT]

Missing Pack Sizes

[INSERT]

Missing Need States

[INSERT]

Emerging Segments

[INSERT]

Innovation Territories

[INSERT]

Premium Opportunities

[INSERT]

SECTION 19 — NEW SKU ENTRY GATE

Before adding a new SKU, require it to answer:

  1. What shopper problem does it solve?

[INSERT]

  1. What does it add that the range lacks?

[INSERT]

  1. Who will buy it?

[INSERT]

  1. What will it replace or compete with?

[INSERT]

  1. Is demand likely incremental?

[INSERT]

  1. What is the expected rate of sale?

[INSERT]

  1. What role does it play?

[INSERT]

  1. What is the success threshold?

[INSERT]

NEW ITEM RULE

A new product should not enter simply because it is “new.”

It should earn space by improving:

  • Shopper choice
  • Growth
  • Margin
  • productivity
  • strategic relevance

SECTION 20 — DISTRIBUTION OPTIMIZATION

Not every SKU needs full distribution.

Build tiers.

TIER 1 — UNIVERSAL CORE

Highest-priority items.

Distribution target:

90–100%

TIER 2 — BROAD

Strong products with wide appeal.

Distribution target:

70–90%

TIER 3 — SELECTIVE

Regional, demographic, or mission-specific.

Distribution target:

30–70%

TIER 4 — TEST / NICHE

Strategic or experimental.

Distribution target:

Limited test stores.

SECTION 21 — STORE CLUSTER ASSORTMENT

Avoid treating every store identically.

Possible clusters:

  • Urban
  • Suburban
  • Rural
  • Premium
  • Value
  • Family
  • Convenience
  • Ethnic / cultural
  • High digital penetration

Cluster Question

Which products should be universal, and which should vary by local demand?

SECTION 22 — SPACE REALLOCATION BLUEPRINT

Once products are cut or reduced:

Step 1

Calculate freed facings.

Step 2

Prioritize hero SKU availability.

Step 3

Increase support for high-growth segments.

Step 4

Fill critical assortment gaps.

Step 5

Test emerging innovation.

SPACE REALLOCATION TEMPLATE

Space Removed From

[SEGMENT / SKUs]

Facings Freed

Reallocated To

[INSERT]

Reason

[INSERT]

Expected KPI Improvement

[INSERT]

SECTION 23 — THE RANGE REVIEW WORKFLOW

STEP 1 — Define the Retailer Objective

Examples:

  • Grow sales
  • Simplify range
  • Improve margin
  • Improve value perception
  • Increase premium
  • Reduce OOS

STEP 2 — Diagnose Category Growth

Identify:

  • Growing segments
  • declining segments
  • market gaps

STEP 3 — Score SKU Productivity

Use:

  • Sales
  • ROS
  • margin
  • space

STEP 4 — Add Incrementality

Identify:

  • unique vs. duplicated demand

STEP 5 — Map Shopper Needs

Find:

  • gaps
  • duplication
  • unmet needs

STEP 6 — Review Price and Pack Architecture

Ensure:

  • entry
  • core
  • premium
  • pack choice

STEP 7 — Assign Actions

Protect / Expand / Maintain / Test / Replace / Cut.

STEP 8 — Model Risk

Estimate:

  • sales at risk
  • transfer
  • shopper impact

STEP 9 — Reallocate Space

Fund:

  • heroes
  • growth segments
  • whitespace

STEP 10 — Define Success KPIs

Measure:

  • sales
  • units
  • margin
  • rate of sale
  • OOS
  • shopper metrics

SECTION 24 — ASSORTMENT OPTIMIZATION SCORECARD

BEFORE RESET

SKU Count: ______

Sales: $________

Margin: $________

Average ROS: ______

OOS: ______%

Sales per Facing: $________

AFTER RESET

SKU Count: ______

Sales: $________

Margin: $________

Average ROS: ______

OOS: ______%

Sales per Facing: $________

TARGET OUTCOMES

Aim for combinations such as:

  • Fewer low-value SKUs
  • Higher average productivity
  • Better availability
  • Higher shopper clarity
  • Better growth segment representation
  • Improved margin mix

SECTION 25 — ASSORTMENT RED-FLAG CHEAT SHEET

High SKU Count + Flat Sales

Potential over-assortment.

Low ROS + High Distribution

Potential rationalization.

High ROS + Low Distribution

Potential expansion.

Multiple Similar SKUs + Low Incrementality

Potential duplication.

Fast-Growing Segment + Low Representation

Potential whitespace.

Hero SKU OOS + Slow Movers Over-Spaced

Potential space misallocation.

Premium Growth + Few Premium SKUs

Potential premium gap.

Penetration Decline + Weak Entry Price

Potential accessibility issue.

SECTION 26 — RETAILER-READY RECOMMENDATION FORMULAS

Rationalization

“Remove [X] low-productivity, low-incrementality SKUs that generate only [Y]% of sales, while preserving all core shopper need states.”

Expansion

“Expand distribution of [SKU / SEGMENT] from [X]% to [Y]% based on above-average rate of sale and strong growth.”

Space Reallocation

“Reallocate [X] facings from duplicated [SEGMENT] items into [GROWTH SEGMENT] and hero SKUs.”

Whitespace

“Introduce a proposition within the missing [PRICE / NEED / PACK] space to address an unmet shopper requirement.”

Price Architecture

“Strengthen the [ENTRY / MID / PREMIUM] tier to create a clearer shopper progression across the range.”

SECTION 27 — RANGE REVIEW SLIDE HEADLINES

Instead of:

SKU Performance

Use:

A small number of SKUs generate the majority of category productivity.

Instead of:

Delisting Recommendation

Use:

Range simplification can reduce complexity while preserving meaningful shopper choice.

Instead of:

Growth Segment

Use:

Future growth is underrepresented within the current assortment.

Instead of:

Distribution Opportunity

Use:

High-velocity products remain underdistributed relative to demonstrated demand.

Instead of:

Range Gap

Use:

The assortment is broad, but critical shopper needs remain underserved.

SECTION 28 — THE ASSORTMENT DECISION MEETING SCRIPT

Opening

“Our objective is not simply to reduce the range. It is to improve category productivity while preserving meaningful shopper choice.”

Productivity

“We identified products that occupy disproportionate space relative to their contribution.”

Shopper Lens

“We then tested whether those items provide unique shopper value or whether demand can transfer.”

Growth Lens

“Finally, we identified where released space can be reinvested behind growth segments and unmet shopper needs.”

Close

“The recommendation simplifies duplication while strengthening the parts of the assortment most likely to drive future category growth.”

SECTION 29 — OBJECTION HANDLING

“But the SKU still sells.”

“The question is not whether it sells. The question is whether it delivers enough incremental value relative to alternative uses of the space.”

“We can’t risk losing shoppers.”

“Agreed. That is why the recommendation preserves key need states and maps clear substitutes before any deletion.”

“We don’t have more space.”

“The strategy is designed to be space-neutral by reallocating low-productivity space into higher-value opportunities.”

“The new product is too small.”

“Current sales should be considered alongside rate of sale, distribution, incrementality, and future growth potential.”

SECTION 30 — THE ASSORTMENT OPTIMIZATION ONE-PAGER

Retailer Objective

[INSERT]

Current SKU Count

Core Range Issue

[INSERT]

Number of Hero SKUs

Number of Duplication Candidates

Number of Growth SKUs

Number of Whitespace Opportunities

Recommended Delists

Recommended Expansions

Recommended Tests

Estimated Space Reallocated

________ facings

Expected Commercial Impact

$________

ADVANCED APPLICATION — THE CATEGORY BALANCE TEST

A strong range should balance five jobs:

  1. VOLUME

What products drive the most sales?

  1. VALUE

What products drive margin?

  1. CHOICE

What products serve unique needs?

  1. GROWTH

What products represent future demand?

  1. ACCESS

What products keep the category affordable?

If the range is strong in only one or two of these, it may be commercially unbalanced.

ADVANCED APPLICATION — THE 80/20/20 RULE

Use this as a diagnostic—not a rigid law.

First 80

Which products generate roughly 80% of sales?

First 20

Which 20% of SKUs are doing most of the commercial work?

Second 20

Which bottom 20% of SKUs add little productivity and little shopper value?

The second group often contains the strongest rationalization candidates.

ADVANCED APPLICATION — THE “DELETE THE DATA” TEST

Imagine you could not see total sales.

Would you still keep the SKU based on:

  • Shopper uniqueness
  • strategic role
  • margin
  • growth
  • incrementality
  • need-state coverage

This prevents raw size from dominating every decision.

ADVANCED APPLICATION — THE “DELETE THE SKU” TEST

Now reverse it.

Imagine the SKU disappeared.

Ask:

  • Would shoppers notice?
  • Would total category sales fall?
  • Would margin fall?
  • Would a need go unmet?
  • Would a competitor benefit?
  • Could another item absorb demand?

This reveals true strategic importance.

THE ASSORTMENT OPTIMIZATION MASTER FORMULA

Use this structure for every range decision:

Because [SKU / SEGMENT] delivers [PRODUCTIVITY RESULT] and has [HIGH / LOW] incrementality, we recommend [KEEP / CUT / EXPAND / TEST / REPLACE].

This will [PRESERVE / IMPROVE] shopper choice while freeing [SPACE / INVESTMENT] for [HIGHER-VALUE OPPORTUNITY], measured through [KPIs].

Example

Because four mainstream variants generate only 3% of category sales and largely duplicate the same shopper need, we recommend removing two low-velocity variants and reallocating the released facings to the highest-velocity hero SKU and a fast-growing premium segment.

The range will retain the same core need states while improving sales per facing, availability, and premium growth.

That is assortment optimization—not indiscriminate SKU cutting.

Wrap-Up

The goal of assortment optimization is not to create the smallest possible range.

It is to create the most productive assortment that still gives shoppers meaningful choice and positions the category for future growth.

Evaluate every SKU through productivity, incrementality, shopper need, price role, pack role, strategic relevance, and space efficiency.

Protect the items that matter, remove duplication, expand demonstrated winners, test uncertain opportunities, and reinvest every freed facing with purpose.

Use this asset to instantly shortcut assortment optimization and position yourself as the expert.