Stock Keeping Unit (SKU) Rationalization KPI

What is Stock Keeping Unit (SKU) Rationalization?
The process of analyzing and streamlining the number of SKUs to optimize inventory management and reduce complexity in the supply chain.

View Benchmarks




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.

How Stock Keeping Unit (SKU) Rationalization Connects to Your Strategy

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.

Measuring Stock Keeping Unit (SKU) Rationalization in Practice

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.

Common Pitfalls

Many organizations underestimate the complexity of SKU rationalization, leading to misguided inventory decisions.

  • Failing to analyze sales data can result in retaining underperforming SKUs. Without quantitative analysis, businesses may overlook items that do not contribute to profitability, wasting resources on low-demand products.
  • Ignoring customer feedback can skew SKU decisions. Disregarding insights from sales teams or customer surveys may lead to misalignment between inventory and market needs, ultimately harming sales.
  • Overlooking seasonal trends can distort inventory planning. Companies that do not account for fluctuations in demand may find themselves overstocked or understocked during peak periods, impacting cash flow.
  • Neglecting cross-departmental collaboration can create silos. When marketing, sales, and operations do not align on SKU strategies, it can result in conflicting priorities and inefficiencies in inventory management.

Improvement Levers

Enhancing SKU rationalization requires a strategic approach to inventory management and data utilization.

  • Implement a robust data analytics platform to track SKU performance. A reporting dashboard that aggregates sales data and customer insights enables informed decisions about which SKUs to retain or phase out.
  • Regularly conduct variance analysis to identify trends in SKU performance. This allows businesses to measure the impact of changes and adjust strategies accordingly, ensuring alignment with financial ratios and business outcomes.
  • Engage in benchmarking against industry standards to set realistic SKU targets. Understanding where the organization stands relative to competitors can inform rationalization efforts and drive operational efficiency.
  • Foster cross-functional teams to oversee SKU management. Bringing together insights from various departments ensures a holistic view of inventory needs, enhancing strategic alignment and decision-making.

KPI Depot is trusted by consulting, strategy, finance, and analytics teams at leading organizations worldwide, including those listed below.

AAMC Accenture AXA Bristol Myers Squibb Capgemini DBS Bank Dell Delta Emirates Global Aluminum EY GSK GlaskoSmithKline Honeywell IBM Mitre Northrup Grumman Novo Nordisk NTT Data PepsiCo Samsung Suntory TCS Tata Consultancy Services Vodafone

Stock Keeping Unit (SKU) Rationalization Benchmarks

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

Unlock this benchmark, plus all 35,625 source-attributed benchmarks with full values, formulas, and citations.

Compare KPI Depot Plans Login

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

Unlock this benchmark, plus all 35,625 source-attributed benchmarks with full values, formulas, and citations.

Compare KPI Depot Plans Login

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

Unlock this benchmark, plus all 35,625 source-attributed benchmarks with full values, formulas, and citations.

Compare KPI Depot Plans Login

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

Unlock this benchmark, plus all 35,625 source-attributed benchmarks with full values, formulas, and citations.

Compare KPI Depot Plans Login

Browse the Top Benchmarked KPIs in ISO 22004

Reading the Benchmarks for Stock Keeping Unit (SKU) Rationalization

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.

OKRs That Use Stock Keeping Unit (SKU) Rationalization

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.

See OKR Examples for ISO 22004


What is the standard formula?
Number of Active SKUs After Rationalization / Number of Active SKUs Before Rationalization


Unlock all 35,625 source-attributed benchmarks.
Comparable benchmark data services start at $2,400 per year.
See all 4 benchmarks for Stock Keeping Unit (SKU) Rationalization
Access to 35,625 benchmarks
Access to 24,181 KPIs
Interactive Strategy Maps on every plan
13 attributes per KPI (view)

Compare Plans

KPI Categories

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].

FAQs about Stock Keeping Unit (SKU) Rationalization

What is SKU rationalization?

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.

Why is SKU rationalization important?

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.

How often should SKU rationalization be conducted?

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.

What metrics are used in SKU rationalization?

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.

How can technology aid SKU rationalization?

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.

What are the risks of not rationalizing SKUs?

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.

KPI Definition

A clear explanation of what the KPI measures

Potential Business Insights

The typical business insights we expect to gain through the tracking of this KPI

Measurement Approach

An outline of the approach or process followed to measure this KPI

Standard Formula

The standard formula organizations use to calculate this KPI

Trend Analysis

Insights into how the KPI tends to evolve over time and what trends could indicate positive or negative performance shifts

Diagnostic Questions

Questions to ask to better understand your current position is for the KPI and how it can improve

Actionable Tips

Practical, actionable tips for improving the KPI, which might involve operational changes, strategic shifts, or tactical actions

Visualization Suggestions

Recommended charts or graphs that best represent the trends and patterns around the KPI for more effective reporting and decision-making

Risk Warnings

Potential risks or warnings signs that could indicate underlying issues that require immediate attention

Tools & Technologies

Suggested tools, technologies, and software that can help in tracking and analyzing the KPI more effectively

Integration Points

How the KPI can be integrated with other business systems and processes for holistic strategic performance management

Change Impact

Explanation of how changes in the KPI can impact other KPIs and what kind of changes can be expected

BSC Perspective

NEW Mapping to a Balanced Scorecard perspective (financial, customer, internal process, learning & growth)


Compare Our Plans


Explore KPI Depot by Function & Industry