Streamline your assortment, reduce SKU complexity, and grow profitable sales with data-driven merchandising decisions.
The Assortment Optimization & SKU Rationalization Playbook provides a practical framework for evaluating, simplifying, and strengthening product assortments across retail and ecommerce channels. Learn how to diagnose SKU proliferation, build data-driven scorecards, define cut-and-keep rules, optimize assortments by store and channel, and implement governance processes that improve sales, margins, inventory productivity, and customer experience.
Table of Contents
Chapter 1. The Executive Case for Assortment Optimization
1.1 What Assortment Optimization and SKU Rationalization Are — and Are Not
1.2 Why Assortment Matters: Sales, Margin, Working Capital, Labor, and Customer Experience
1.3 Common Symptoms of Assortment Proliferation
1.4 The Core Decisions: Keep, Cut, Add, Expand, Localize, Substitute
1.5 The Assortment Optimization Project Roadmap
Chapter 2. Category Strategy and Category Roles
2.1 Defining Category Roles: Destination, Routine, Convenience, Seasonal, and Image Categories
2.2 Translating Category Roles into Assortment Principles
2.3 Understanding Customer Decision Trees
2.4 Segmenting Stores, Channels, and Customer Missions
2.5 Category Role Template and Decision Checklist
Chapter 3. Building the Fact Base
3.1 Required Data: Sales, Margin, Inventory, Space, Supplier, Customer, and Operational Metrics
3.2 Cleaning and Normalizing SKU-Level Data
3.3 Creating Comparable SKU Groups and Attribute Families
3.4 Diagnosing the Long Tail: Volume, Profit, Duplication, and Complexity
3.5 Data Readiness Checklist
Chapter 4. SKU Scoring and Performance Diagnostics
4.1 The Core SKU Scorecard: Sales, Gross Margin, Turns, Growth, Loyalty, and Availability
4.2 Strategic and Customer Criteria: Basket Role, Trip Driver Value, Substitutability, and Brand Importance
4.3 Complexity Criteria: Supply Chain Burden, Store Labor, Space Productivity, and Vendor Management
4.4 Creating a Weighted SKU Scoring Model
4.5 SKU Scorecard Template and Worked Example
Chapter 5. Defining Cut, Keep, Add, and Test Rules
5.1 Keep Rules: Protecting Strategic, Profitable, and Customer-Critical SKUs
5.2 Cut Rules: Identifying Weak, Redundant, Low-Rotation, and Operationally Costly SKUs
5.3 Add Rules: Finding Gaps in Good-Better-Best, Price Points, Brands, Sizes, Flavors, and Use Cases
5.4 Test-and-Learn Rules: Pilots, Control Groups, and Success Metrics
5.5 Decision Tree for SKU Actions
Chapter 6. Designing the Optimized Assortment
6.1 National Core, Regional Modules, Local Variants, and Online-Only SKUs
6.2 Optimizing Assortment by Store Cluster and Channel
6.3 Balancing Breadth, Depth, Choice, and Simplicity
6.4 Managing Private Label, National Brands, Opening Price Points, and Premium Tiers
6.5 Optimized Assortment Blueprint Template
Chapter 7. Implementation, Change Management, and Governance
7.1 Building the Implementation Plan: Timeline, Owners, Milestones, and Dependencies
7.2 Managing Vendor Conversations and Commercial Terms
7.3 Store, Supply Chain, Merchandising, and Digital Execution
7.4 Tracking Results: Sales Transfer, Margin Impact, Inventory Reduction, Availability, and Customer Response
7.5 Ongoing Assortment Governance Model
Chapter 8. When and How to Use External Advisors
8.1 When External Support Is Worth Considering
8.2 Large Consulting Firms: Best Uses, Strengths, Limitations, and Cost Considerations
8.3 Specialist Retail, Merchandising, Analytics, and Space Planning Firms
8.4 Independent Management Consultants and Interim Merchandising Leaders
8.5 Engaging Independent Consultants Through Umbrex
Appendices. Practitioner Tools and Templates
A. Assortment Optimization Project Charter Template
B. SKU Scorecard Template
C. Category Role Definition Worksheet
D. Cut / Keep / Add Decision Rules Template
E. Vendor Discussion Guide
F. Pilot Design and Test-and-Learn Template
G. Assortment Governance Meeting Agenda
H. KPI Dashboard Template
