SKU Rationalization Calculator

About the SKU Rationalization Calculator

SKU rationalization is the process of evaluating each product in your catalog to determine whether it should be kept, improved, or discontinued. Too many SKUs create inventory complexity, increase carrying costs, dilute marketing focus, and strain operations without proportional revenue gains.

This calculator scores each SKU across multiple dimensions: revenue contribution, profit margin, sales velocity, and carrying cost burden. Products scoring below your threshold are flagged for review and potential removal from your catalog.

For e-commerce businesses, rationalization is especially important because every additional SKU requires inventory investment, listing maintenance, advertising budget, and customer service capacity. Eliminating underperformers frees these resources for your best products.

When This Page Helps

A bloated catalog drains resources from your best products. SKU rationalization helps you identify and remove underperformers, freeing up capital, warehouse space, and management attention for the products that actually drive your business forward.

How to Use the Inputs

1. Enter the product's monthly revenue.
2. Enter the profit margin percentage.
3. Enter the monthly sales velocity (units/month).
4. Enter the monthly carrying cost for this product.
5. Enter a complexity score (1–10) reflecting operational burden.
6. Review the composite score and keep/review/discontinue recommendation.

Example Calculation

Tips & Best Practices

• Evaluate all SKUs at least twice a year — quarterly is ideal for dynamic catalogs.
• Don't just look at revenue; a high-revenue product with negative margin should be flagged.
• Consider strategic value: some low-scoring products complete a product line or serve as entry points.
• Phase out C-rated products gradually — sell through existing stock before discontinuing.
• After rationalization, reinvest freed resources into your top-performing A products.
• Track the impact of removing SKUs on total revenue to validate your rationalization decisions.

The Complexity Cost of Too Many SKUs

Every SKU in your catalog has both visible and hidden costs: listing creation and maintenance, photography, advertising, inventory monitoring, customer service, and returns handling. When a product only generates $50/month in margin but requires the same operational overhead as a $500/month product, it's destroying value.

SKU Rationalization Framework

Step 1: Score all SKUs on financial and operational criteria. Step 2: Flag bottom 20% for detailed review. Step 3: Classify flagged items as improve, phase-out, or immediate discontinue. Step 4: Execute sell-through plans for discontinued items. Step 5: Reinvest freed resources into top performers.

When NOT to Rationalize

Don't rationalize during a product's launch phase (first 90 days), during peak season, or when you lack sufficient data (less than 3 months of sales history). Also be cautious with products in growing categories where velocity may be accelerating.

Frequently Asked Questions

• What is SKU rationalization?

  SKU rationalization is the systematic evaluation and pruning of your product catalog. It scores each product against defined criteria and flags underperformers for improvement or removal. The goal is a leaner, more profitable product portfolio.

• How many SKUs should I cut?

  There is no fixed target, but the 80/20 rule suggests that your bottom 20–50% of SKUs may contribute very little revenue while consuming significant resources. Start by reviewing the lowest-scoring 10–20% and work your way up based on results.

• What if a low-scoring SKU completes a product line?

  Consider strategic value alongside the financial score. If removing a product would push customers to competitors for their full purchase, it may be worth keeping despite a low score. Flag it as "strategic" and set a minimum performance threshold.

• How does SKU rationalization differ from ABC analysis?

  ABC analysis classifies products by a single dimension (typically revenue). SKU rationalization uses multiple dimensions including margin, velocity, cost, and complexity to provide a more comprehensive evaluation. A product could be A-class by revenue but still warrant discontinuation if it has negative margin.

• What happens to existing inventory when I discontinue a SKU?

  Plan a sell-through strategy before discontinuing. Options include gradual markdown, bundling with popular items, liquidation channels, or donation for tax benefits. The key is to recover as much value as possible while clearing stock within a defined timeline.

• How do I measure the impact of SKU rationalization?

  Track total revenue, total profit, inventory turnover, carrying costs, and operational metrics before and after rationalization. A successful rationalization should show improved margins, better turnover, and reduced operational complexity with minimal revenue impact.