Profit margin by product line

Profit margin by product — why your P&L can lie to you

Total company profitability is a blended average. A business can show healthy overall margins while one product line bleeds cash, subsidized by the margins of another. Product-level P&L analysis reveals which product lines are actually making money — and which ones you should reconsider.

Why total P&L masks product economics

Consider a business with two products: Product A ($500k revenue, 60% gross margin) and Product B ($1M revenue, 20% gross margin). Blended gross margin = ($300k + $200k) / $1.5M = 33%. The total looks adequate, but Product B is destroying value. If overhead allocation is proportional, Product B may actually have a negative contribution margin after allocated fixed costs.

This pattern is very common in businesses that have grown by adding product lines opportunistically. Each new line seemed like incremental revenue — but it added overhead, consumed management attention, and diluted margins on the core business.

The 80/20 of profitability

The Pareto principle appears reliably in product portfolios. In most businesses, 20% of product lines (or SKUs) generate 80% or more of gross profit. The remaining 80% of products generate the last 20% of profit — and consume disproportionate overhead because complexity scales with SKU count, not revenue.

Operational complexity from a large product catalog: more warehouse locations, more supplier relationships, more customer service touchpoints, more complexity in manufacturing scheduling, more items that can be out-of-stock or obsolete. The fixed cost of complexity is real and usually invisible in the aggregate P&L.

Simple overhead allocation vs activity-based costing

Simple allocation (what this calculator uses): divide overhead proportionally by each product's revenue share. If Product A is 40% of revenue, it gets 40% of overhead. Fast and easy, but imprecise — a low-revenue product that consumes disproportionate customer support time or warehouse space will appear more profitable than it truly is.

Activity-based costing (ABC): identify the cost drivers for each overhead category, then allocate based on actual driver consumption. If warehouse costs are $200k and Product B uses 60% of shelf space, Product B gets $120k of warehouse overhead regardless of its revenue share. ABC was developed by Robin Cooper and Robert Kaplan at Harvard Business School in the 1980s specifically to address the distortions of volume-based overhead allocation.

For most growing businesses, even a rough ABC exercise — estimating driver consumption for the top two or three overhead categories — will reveal more actionable insights than the most precise simple allocation.

Pricing implications of product-level margins

A low-volume, high-margin product is worth protecting. Resist the temptation to lower its price to drive volume — you may win market share but destroy the margin that makes it valuable. A high-volume, low-margin product may be a commodity where pricing power is limited, or it may be under-priced relative to the value it delivers. Product P&L analysis often surfaces pricing decisions that were made years ago and never revisited.

The SKU rationalization process

Cutting the lowest-margin products is rarely easy — customers use them, sales reps sell them, operations teams have workflows built around them. But the economics are compelling. McKinsey research shows that companies completing deliberate SKU rationalization programs improve gross margins by 2–4 percentage points and free 15–25% of operational capacity that can be redeployed to higher-margin activities.

The process: (1) Rank every product line by gross profit contribution in dollars (not percentage). (2) Identify the bottom quintile. (3) Test each for strategic necessity — is it required for a key customer relationship? Is it a gateway product that upsells into higher-margin offerings? (4) For products that fail the strategic test, discontinue or reprice to recover full cost plus margin. (5) Repeat annually.

Gross margin vs contribution margin for product decisions

When deciding whether to add or keep a product, use contribution margin (revenue minus variable costs only). A product with positive contribution margin covers its own variable costs and contributes something toward fixed costs — even a thin contribution is better than zero if fixed costs are already covered by other products.

When managing the total business profitability, use full cost including allocated fixed overhead. If a product can't cover its fully allocated cost at current volume and pricing, either volume must grow, price must rise, or costs must fall — or the product should be discontinued.