Stock Keeping Unit (SKU) Rationalization is crucial for optimizing inventory management and enhancing operational efficiency.
By streamlining SKU offerings, organizations can reduce excess stock, improve forecasting accuracy, and better align with customer demand.
This KPI directly influences cost control metrics and overall financial health, enabling businesses to allocate resources more effectively.
A well-executed SKU rationalization strategy can lead to significant improvements in ROI metrics and customer satisfaction.
Companies that leverage data-driven decision-making in this area often see enhanced performance indicators and strategic alignment across departments.
Stock Keeping Unit (SKU) Rationalization sits in the ISO 22004 KPI group, an internal-process metric expressing how far an assortment has been trimmed, the count of active SKUs after a rationalization against the count before. The KPI group is organized around food-safety-driven supply chain management, and its priority order leads with supplier and fulfillment metrics: Supplier On-time Delivery Rate, Order Accuracy Rate, Perfect Order Rate, and Customer Order Cycle Time hold the top ranks, with Supply Chain Cost Reduction and Inventory Turnover Ratio carrying the financial view. SKU Rationalization ranks in the middle of that order, which fits a metric that is a lever on the others rather than a headline outcome.
The connections run in two directions. On the operations side, a leaner SKU count feeds Order Accuracy Rate and Perfect Order Rate, because fewer near-identical items mean fewer picking errors and simpler fulfillment, and it supports Customer Order Cycle Time by shortening the path from order to ship. On the financial side it links straight to Inventory Turnover Ratio and Supply Chain Cost Reduction: retiring slow SKUs frees working capital and cuts carrying cost. Within a food-safety KPI group the tie is sharper than in general retail, because every additional SKU is another item to trace, hold at temperature, and verify against ISO 22004 controls. Rationalization narrows the surface a safety program has to cover, so here it reads as a risk-reduction move as much as a cost one. That is why customers should read it against the group's supplier metrics too: a smaller, better-controlled assortment is easier to hold suppliers accountable for.
The formula is active SKUs after rationalization over active SKUs before, so the count definitions carry the whole measurement. Fix what active means: whether a SKU with no recent sales but open inventory still counts, and whether seasonal or regional variants are one SKU or many. Set the before and after dates deliberately, because a rationalization that runs for months will read very differently depending on when you snapshot the baseline. Decide how new SKU introductions during the period are treated, since a program can retire many items while launches quietly refill the count and mask the reduction.
Read the metric as a ratio, not an absolute cut, and pair it with an outcome so it does not reward cutting for its own sake. A shrinking SKU count that drags Order Accuracy Rate the wrong way, or that removes items customers wanted, is not a win. In an ISO 22004 context the strongest use is to watch rationalization alongside traceability and safety load: fewer SKUs should make lot tracking and temperature control simpler, so the metric earns its keep when a lower count shows up as easier compliance, not just lower inventory. Track it as a before-and-after on a defined program rather than a rolling monthly figure, and record what was retired and why, so a later review can tell deliberate pruning from drift.
Many organizations underestimate the complexity of SKU rationalization, leading to misguided inventory decisions.
Enhancing SKU rationalization requires a strategic approach to inventory management and data utilization.
We have 4 relevant benchmarks in our benchmarks database.
Source: Subscribers only
Source Excerpt: Subscribers only
Additional Comments: Subscribers only
| Value | Unit | Type | Company Size | Time Period | Population | Industry | Geography | Sample Size |
| Subscribers only | percent | threshold | large CPG companies | 2013–2018 (examples referenced) | SKU portfolios | consumer packaged goods |
Source: Subscribers only
Source Excerpt: Subscribers only
Additional Comments: Subscribers only
| Value | Unit | Type | Company Size | Time Period | Population | Industry | Geography | Sample Size |
| Subscribers only | percent | range | retailer and CPG assortments | CPG retail |
Source: Subscribers only
Source Excerpt: Subscribers only
Additional Comments: Subscribers only
| Value | Unit | Type | Company Size | Time Period | Population | Industry | Geography | Sample Size |
| Subscribers only | percent | average | 2009 | grocery retailer assortments | grocery retail |
Source: Subscribers only
Source Excerpt: Subscribers only
Additional Comments: Subscribers only
| Value | Unit | Type | Company Size | Time Period | Population | Industry | Geography | Sample Size |
| Subscribers only | percent | range | CPG product portfolios | consumer packaged goods |
Browse the Top Benchmarked KPIs in ISO 22004
Four sources anchor the benchmark picture for SKU rationalization, and they do not measure the same thing, which is the first thing to notice before comparing any of them. Strategy& (PwC) approaches it as a portfolio question in large consumer packaged goods companies, framing rationalization against a threshold of where value hides in a product line. NielsenIQ looks across retailer and CPG assortments and reports a range rather than a single point, reflecting how widely the right assortment size varies by category. A Mass Market Retailers piece relays an earlier Nielsen study of grocery assortments as an average across retailers, a different statistical basis again. Boston Consulting Group also treats CPG portfolios but reports as a range tied to portfolio composition.
The disagreements are structural, not just numerical. The population differs: large CPG manufacturers, general retail and CPG assortments, and grocery specifically are not interchangeable, and an assortment norm from grocery does not transfer to a manufacturer's brand portfolio. The unit of analysis differs too, since a retailer rationalizing shelf assortment and a manufacturer rationalizing a production portfolio are solving related but distinct problems. The metric type varies from threshold to range to average, so a figure that reads as a target in one source is a midpoint in another. The sources also span more than a decade, and assortment strategy shifted over that period as retailers first cut hard and then partly restored variety, which means older grocery figures and recent CPG ranges reflect different phases of thinking. The lesson for customers is that a benchmark for this metric is only usable once you match it to your own model: manufacturer versus retailer, category, and whether the source states a target, a range, or an observed average. That matching is exactly what the source-attributed records support and what a single borrowed number would get wrong.
The ISO 22004 KPI group frames its OKRs around optimizing supplier performance for food safety and timely delivery, and enhancing order fulfillment accuracy to improve customer satisfaction and reduce waste. SKU Rationalization is not named as a key result in either objective, but it is a direct lever on the second one and worth positioning there.
The fulfillment-accuracy objective sets key results on Order Accuracy Rate, Perfect Order Rate, and Customer Order Cycle Time. Rationalizing the assortment supports all three at their root: fewer confusable items reduce picking errors that drag on order accuracy, simplify the conditions for a perfect order, and shorten cycle time by cutting handling complexity. Use SKU Rationalization as an enabling initiative behind that objective rather than a headline key result, the structural change that makes the fulfillment targets easier to hit. It also touches the supplier objective indirectly, since a narrower assortment concentrates volume with fewer suppliers and makes compliance and on-time performance easier to enforce. Set it as a supporting metric with a defined program window, and read its progress through the fulfillment key results it is meant to move.
This KPI is associated with the following categories and industries in our KPI database:
KPI Depot takes you from KPI intelligence to finished deliverable. Consultants, strategy teams, FP&A leaders, and analytics teams use it to answer the two hardest questions in performance management, what to measure and what the target should be, and then to produce the scorecard itself.
The difference is intelligence, not just data. Anyone can list metrics. Every KPI in KPI Depot carries 13 practical attributes, from formula and measurement approach to diagnostic questions, risk warnings, and Balanced Scorecard perspective, across 15 corporate functions and 153 industries. And every target you set is grounded in our database of 34,304 source-attributed benchmarks, each detailing metric value, company size, time period, industry, geography, sample size, and source. Benchmark data at this scale is otherwise the domain of research services costing thousands to hundreds of thousands of dollars per year.
When your metrics are selected, KPI Depot finishes the job: export an interactive Strategy Map, a Balanced Scorecard with formulas and tracking columns, or a CSV KPI pack, and go from research to working deliverable in hours instead of weeks.
Formerly the Flevy KPI Library, KPI Depot is trusted by teams at organizations including Accenture, EY, IBM, PepsiCo, Samsung, and Vodafone.
Got a question? Email us at [email protected].
SKU rationalization is the process of evaluating and optimizing a company's product offerings to improve inventory management and operational efficiency. It involves analyzing sales data, customer feedback, and market trends to determine which SKUs to retain or eliminate.
SKU rationalization is vital for reducing excess inventory and improving cash flow. It helps organizations align their product offerings with customer demand, ultimately enhancing profitability and operational efficiency.
Regular SKU rationalization should occur at least annually, but more frequent reviews may be necessary in fast-changing markets. Continuous monitoring allows businesses to adapt to shifts in consumer preferences and market conditions.
Key metrics include sales velocity, inventory turnover, and gross margin per SKU. These performance indicators help organizations assess the profitability and demand for each product in their portfolio.
Technology, such as advanced analytics and business intelligence tools, can provide insights into SKU performance and customer behavior. These data-driven insights enable more informed decisions regarding inventory management and product offerings.
Failing to rationalize SKUs can lead to overstocking, increased carrying costs, and reduced profitability. It may also result in missed sales opportunities and diminished customer satisfaction due to stockouts or lack of variety.
Each KPI in our knowledge base includes 13 attributes.
A clear explanation of what the KPI measures
The typical business insights we expect to gain through the tracking of this KPI
An outline of the approach or process followed to measure this KPI
The standard formula organizations use to calculate this KPI
Insights into how the KPI tends to evolve over time and what trends could indicate positive or negative performance shifts
Questions to ask to better understand your current position is for the KPI and how it can improve
Practical, actionable tips for improving the KPI, which might involve operational changes, strategic shifts, or tactical actions
Recommended charts or graphs that best represent the trends and patterns around the KPI for more effective reporting and decision-making
Potential risks or warnings signs that could indicate underlying issues that require immediate attention
Suggested tools, technologies, and software that can help in tracking and analyzing the KPI more effectively
How the KPI can be integrated with other business systems and processes for holistic strategic performance management
Explanation of how changes in the KPI can impact other KPIs and what kind of changes can be expected
NEW Mapping to a Balanced Scorecard perspective (financial, customer, internal process, learning & growth)