Analyze Contribution Margin by Product and Customer: ABC Analysis and Portfolio Optimization

Analyze Contribution Margin by Product and Customer: ABC Analysis and Portfolio Optimization

Most businesses manage their product portfolio intuitively – without knowing which products and customers are actually profitable. High revenue does not automatically mean high profitability. Numerous analyses show that in many companies, about 20% of products generate 80% of total contribution margin (Pareto principle), while the remaining 80% contribute only 20% – some even with negative CM.

In this article, you'll learn how to perform product analysis by contribution margin, apply ABC analysis, and then optimize your portfolio. This is one of the most powerful strategies for cost optimization and profitability improvement.

The Pareto Principle in Product Analysis

The Pareto principle (or 80/20 rule) describes a frequently observed phenomenon: 80% of results are caused by 20% of causes. In the context of contribution margin, this means:

• 20% of your products generate approximately 80% of your total contribution margin
• 30% of your products generate approximately 15% of your contribution margin
• 50% of your products generate only approximately 5% or even negative contribution margin

This means you can focus on a small number of products to achieve the greatest benefit. Conversely, it also means many products in your portfolio are unprofitable anomalies that you should either optimize or remove.

ABC Analysis: Classification by Contribution Margin

ABC analysis is a classification system that divides products into three categories based on their contribution margin:

A-Products (approximately 20% of portfolio)

• Generate approximately 80% of total contribution margin
• Highest priority for management and resources
• Require constant monitoring and optimization
• Example: Premium products, bestsellers with high margins

B-Products (approximately 30% of portfolio)

• Generate approximately 15% of total contribution margin
• Medium priority – should be reviewed regularly
• Potential for improvement or optimization
• Example: Mid-range products with moderate margin

C-Products (approximately 50% of portfolio)

• Generate approximately 5% or even negative contribution margin
• Low priority – often administration costs don't justify the return
• Candidates for price increase, cost reduction, or discontinuation
• Example: Niche products, slow movers, clearance items

Step-by-Step: Conducting Product Analysis

Here's how to conduct a product analysis by contribution margin:

• 1. Collect all product data: selling price, cost price, variable costs per product
• 2. Calculate contribution margin per product: CM = Selling price - (COGS + Variable costs)
• 3. Sort by CM in descending order (highest CM first)
• 4. Calculate cumulative contribution margin percentage
• 5. Divide into ABC based on cumulative percentage (approx. 20% A, 30% B, 50% C)
• 6. Analyze findings and plan actions

Concrete Example: A 50-Product Portfolio

Assume you have 50 products with the following CM per unit and annual volume:

In this simplified example, you can see that the top 4-5 products (approximately 10% of inventory) already generate 30-40% of total contribution margin. Products 48-50 with negative or minimal CM are candidates for immediate action.

What to Do with C-Products?

C-products are a dilemma. They tie up inventory, administrative effort, and shipping costs, but generate little or no benefit. Here are three strategies:

1. Price Increase

If demand for a C-product is stable, you can try raising the price. Often C-products are only unprofitable because the price is too low. A 10-15% price increase can move the product into B or even A category – if demand doesn't collapse.

2. Cost Reduction

Work with procurement to lower costs. Can you find a better supplier, negotiate volume discounts, or substitute materials? Even a 10-20% cost reduction can make an unprofitable product profitable.

3. Discontinuation or Clearance

If price increases and cost reduction don't work, it's time to remove the product from inventory. Create a clearance plan: reduce selling price, special promotions, bundle offers – the goal is to move inventory quickly and then stop production.

Customer Profitability: The Often Forgotten Dimension

While many companies analyze products by CM, they often forget customer profitability. A large customer with special discounts, high service costs, and slow payment can have negative contribution margin despite high revenue.

Conduct a similar ABC analysis for customers:

• A-Customers: 20% of customers, 80% of profit – serve these intensively
• B-Customers: 30% of customers, 15% of profit – cultivate these regularly
• C-Customers: 50% of customers, 5% or negative – reconsider the relationship

For C-customers, raise minimum order quantities, introduce shipping fees, or set alternative pricing models that compensate for high service costs.

Portfolio Optimization: Making Strategic Decisions

With ABC data in hand, make strategic decisions about your portfolio:

A-Products: Maximum Focus

• Ensure A-products are always in stock
• Invest in marketing and sales of these products
• Continuously optimize costs and pricing
• Consider variations or bundles for upselling opportunities

B-Products: Regular Review

• Review CM monthly or quarterly
• Identify which B-products can move to A
• Consider moving less profitable B-products to C

C-Products: Critical Decisions

• Divide them into three groups: Optimize, Reassess, Discontinue
• Set timelines for improvements
• Plan an orderly exit for unprofitable products

Cross-Subsidization and Strategy

Not all C-products should simply be discontinued. In some cases, cross-subsidization is a business strategy: you accept low or negative CM on one product because it drives high-CM sales.

Examples:

• Loss Leader: A popular C-product with minimal margin attracts customers who then buy A-products
• Bundling: A popular C-product is bundled with an A-product to drive A-product sales
• Complementary Strategy: A C-product is necessary to sell an A-product (e.g., accessories)

The key: be conscious and intentional. Not all C-products are inherently "bad" – but you must know why you're keeping them.

Practical Implementation Example

Here's a practical scenario for implementation:

Month 1: Data Collection and Analysis

• Export all product sales data from the last 12 months
• Calculate CM per product
• Conduct ABC classification

Month 2: Strategy Development

• Identify which C-products to optimize
• Set objectives: price increase, cost reduction, or discontinuation plan
• Decide on cross-subsidization strategies

Month 3+: Implementation

• Implement price adjustments for A-products (profit maximization)
• Negotiate with suppliers for cost reduction in B and C
• Start clearance for discontinued products
• Track monthly CM development

Additional KPIs to Monitor

Beyond ABC analysis, track these metrics:

• Average CM per product (should increase monthly)
• Average CM per order (indicates customer mix quality)
• Inventory turnover (C-products usually tie up capital)
• Portfolio breadth (how many SKUs are you managing?)
• CM concentration (what % comes from top 10 products?)

Common Mistakes to Avoid

Mistake 1: Confusing Revenue with Profit

Many managers pour resources into high-revenue products with low CM. A product with 10,000 EUR revenue and 1% CM generates less profit than a product with 5,000 EUR revenue and 20% CM.

Mistake 2: Waiting Too Long

Many companies hold onto unprofitable products, hoping they'll "eventually" become profitable. This ties up inventory and administrative resources for nothing. Quick decisions and fast action are key.

Mistake 3: Cutting Too Aggressively

Aggressive portfolio pruning can lose customers who wanted discontinued products. Take a gradual, data-driven approach: analyze how many customers bought only for these C-products.

Conclusion: Data-Driven Portfolio Optimization

ABC analysis and product profitability analysis is one of the simplest and most powerful techniques for improving profitability. With minimal effort, you can identify which products and customers truly create value and where you need to take action.

Many companies see profitability improvements of 15-30% after implementing ABC analysis, because they better concentrate their resources and markets. This is a low-cost, high-impact optimization lever.

Further Reading

Deepen your knowledge of contribution margin and financial planning:

• Calculate CM
• Multi-Level CM
• CM E-Commerce