SKU Rationalization: How to Cut Product Complexity Without Hurting Sales

Most manufacturers do not set out to build an unmanageable product portfolio. Complexity accumulates one customer request at a time — a custom color here, a non-standard length there, a one-off configuration for a large account that eventually becomes a permanent catalog item. After a few years of this pattern, a plant that once ran 150 SKUs efficiently is now wrestling with 600, and schedulers are spending more time managing exceptions than running the floor. SKU rationalization is the disciplined process of reversing that drift by evaluating every item in the portfolio against clear financial and operational criteria, then eliminating or consolidating the items that fail to clear the bar.

Why SKU Proliferation Happens

SKU count grows because the incentives that drive growth run in one direction. Sales teams earn commission on new business, and the easiest way to close a deal is to say yes to customization. Product managers build careers on launches, not consolidations. Operations absorbs the complexity without an explicit budget for it, so the true cost of each additional SKU never surfaces in the new-product approval process.

The result is predictable. A 2022 study of 150 mid-size manufacturers found that the bottom 30% of SKUs by revenue contributed less than 3% of total sales while consuming 22% of production scheduling time and 18% of inventory value. Those numbers are consistent with what manufacturers encounter when they run the analysis for the first time: a significant tail of low-volume, high-complexity products that are quietly destroying margin and scheduling efficiency.

The Four-Category Framework

A practical rationalization framework sorts every SKU into one of four buckets:

Keep and grow: High revenue, strong margin, good forecast accuracy, and efficient to produce. These items deserve priority scheduling, preferred inventory positions, and investment in process improvement to drive costs lower.

Keep and optimize: Good revenue or strategic importance, but with addressable cost or complexity problems. These SKUs stay, but with a mandate to standardize components, consolidate variants, or improve forecast accuracy within a defined period.

Rationalize to substitute: Low volume or margin, but customer need is real. The correct action is to redesign or consolidate into a standard SKU that meets the need at lower complexity. This is not discontinuation — it is product engineering that converts a custom SKU into a standard one.

Discontinue: Low volume, low margin, high complexity, no strategic rationale. These items should be eliminated with a managed transition for any affected customers.

The framework forces a decision category for every item. Left uncategorized, SKUs default to "keep" by inertia.

Building the SKU-Level P&L

The foundation of any rationalization analysis is a SKU-level contribution margin that captures true complexity cost. Standard financial systems often show SKUs as profitable because they allocate overhead as a flat percentage of revenue or standard cost — a method that systematically undercharges high-complexity, low-volume items and overcharges high-volume standard items.

A more accurate view builds the following cost elements at the SKU level:

Direct material cost: Actual BOM cost at current purchase prices, not standard cost.

Direct labor: Actual run time multiplied by burdened labor rate, adjusted for actual yield.

Setup and changeover cost: Average changeover time for this SKU multiplied by machine rate. A SKU that runs 4 times per year for 50 units each run, with a 2-hour changeover at a $180/hour machine rate, carries $1,440 per year in setup cost alone — before any material or labor is counted.

Inventory carrying cost: Average inventory value for this SKU multiplied by your carrying cost rate (typically 20-30% per year). A SKU with $15,000 average inventory and a 25% carrying rate adds $3,750 per year in holding cost.

Planning and administrative cost: Scheduling time, purchasing transactions, and quality inspection events attributable to the SKU. This is harder to quantify but real — a low-volume specialty item that generates a purchase order for a custom raw material every six weeks, a dedicated quality inspection plan, and regular scheduling exceptions is genuinely more expensive than a standard item that rides on blanket orders and shared quality plans.

When these costs are summed and subtracted from actual revenue, many rationalization candidates shift from modest-profit to loss-making.

How SKU Rationalization Affects Production Scheduling

The scheduling benefits of rationalization are direct and measurable. Every SKU removed from the active portfolio eliminates:

• At least one changeover event per production cycle
• At least one material planning decision per replenishment cycle
• At least one inventory position (and its associated holding cost and stockout risk)
• At least one forecasting challenge (low-volume SKUs are notoriously hard to forecast accurately)

For a job shop or mixed-mode manufacturer running 400 active SKUs, reducing to 280 through rationalization might eliminate 150-200 changeover events per month. At an average changeover time of 45 minutes and a machine rate of $150/hour, that is $169,000 to $225,000 per year in recovered productive capacity — before any material or inventory savings are counted.

The scheduler's workload improves in quality, not just quantity. Fewer SKUs means fewer exception situations, more predictable material requirements, better BOM accuracy (because the active BOMs get more review attention), and longer production runs that allow the scheduler to build more efficient sequences.

When production scheduling software like RMDB is used to sequence jobs across work centers, a rationalized SKU portfolio allows the optimizer to build longer runs on similar setups and reduce total changeover time further — a benefit that compounds across the schedule rather than applying only to the eliminated items.

Executing the Rationalization Decision

Analysis is the easy part. The organizational challenge is making and implementing discontinuation decisions in the face of sales and customer resistance.

Set decision thresholds before the analysis. Agree in advance on the revenue, margin, and volume minimums that a SKU must meet to remain active. When the thresholds are set before the data is revealed, it is harder for advocacy to override the analysis.

Require sales to defend exceptions in writing. Any SKU below the threshold that sales wants to retain should require a written strategic rationale and a revenue commitment. This surfaces the actual strategic value of each item and filters the list to genuine exceptions rather than reflexive objection.

Give customers adequate transition time. A 90-180 day notice period with a final-buy opportunity is standard practice and minimizes customer disruption. For customers with long production lead times or regulated supply chains (aerospace, medical), 12 months is more appropriate.

Track the outcomes. Six months after discontinuation decisions take effect, compare actual revenue impact against the projected impact. Most manufacturers find that 50-70% of the revenue from discontinued SKUs migrates to other items in the portfolio rather than being lost permanently. Documenting this outcome builds the organizational confidence to run rationalization as an ongoing process rather than a one-time event.

Maintaining a Rationalized Portfolio

The natural tendency is for complexity to regrow after rationalization. New SKUs will be proposed, customers will request customization, and without active controls, the portfolio will drift back toward its prior state within three to five years.

Sustainable rationalization requires a standing governance process:

New SKU approval thresholds: Every new SKU should clear the same thresholds used in the rationalization analysis — projected revenue, margin, and volume minimums over a defined payback period. Include estimated setup cost and inventory investment in the approval package.

Annual portfolio review: Schedule an annual review of the portfolio against the thresholds. Any SKU that has fallen below the minimums for two consecutive years enters the rationalization process automatically.

Sunset provisions at launch: When a new SKU is approved, set a review date — typically 18-24 months post-launch — at which the SKU must meet projected performance or enter the rationalization queue. This prevents the "we just need more time" pattern from indefinitely deferring discontinuation decisions.

RMDB's job-level visibility makes the annual review easier by surfacing actual machine time, changeover frequency, and order frequency by product — the exact data needed to run the rationalization analysis without a separate manual data pull. See the production scheduling software guide and the MRP guide for how scheduling and materials management interact with portfolio decisions.

Frequently Asked Questions

SKU rationalization is ultimately a capacity decision. Every item you remove from the active portfolio returns machine time, planner attention, and inventory capital to the items that deserve it most. Manufacturers who run rationalization as an ongoing governance process — not a one-time cleanup — consistently outperform their peers on margin and on-time delivery because their schedulers are working with a manageable, well-understood portfolio. To see how RMDB gives you the job-level visibility needed to run rationalization analysis from your actual scheduling data, reach out to our team for a demonstration.