Product profitability analysis reveals which products create value and which consume it — accounting product cost is not a reliable proxy because it allocates overhead using mechanical rules that obscure actual economics. The 20/80 pattern typically applies: 20 per cent of products generate 80 per cent of total contribution margin, and knowing which 20 per cent is the starting point for portfolio decisions. Two contribution margin layers are needed: CM I (revenue minus direct variable costs) shows the variable margin per product, while CM II adds attributable fixed costs to show whether each product sustains itself. Product proliferation is the silent margin killer — each new SKU adds complexity costs (quality testing, special handling, customer care) that erode average margin without visibility. Product rationalisation, reducing the portfolio based on CM II data, is one of the highest-impact profitability interventions available. Without product-level contribution margin data, price erosion through the discount waterfall remains invisible.
The product catalogue has grown every year. New variants, new sizes, new configurations, new service bundles — each one launched with a business case showing positive margin. Revenue grew by 30 per cent. Yet profit barely moved. The finance team cannot explain why, because the management reports show gross margin at the product-line level — not the contribution margin at the individual product level where the margin is actually being consumed.
Product profitability analysis closes this gap. It calculates the true profit contribution of each product, product line, or service after accounting for all costs directly attributable to producing and delivering it. The output is not a cost sheet — it is a portfolio decision framework that identifies which products to grow, which to reprice, and which to discontinue.
What Product Profitability Analysis Measures
Product profitability analysis applies the contribution margin methodology to the product dimension. It moves beyond accounting product cost — which allocates overhead using mechanical rules — to reveal the actual economics of each product in the portfolio.
The product revenue waterfall
The analysis begins not with list price, but with what the company actually collects:
| Revenue Layer | Example |
|---|---|
| List price | £25.00 per unit |
| Minus: standard discounts | (£2.50) — 10% trade discount |
| Minus: volume rebates | (£0.75) — 3% retrospective volume bonus |
| Minus: promotional allowances | (£0.50) — co-op marketing contribution |
| Minus: returns and credit notes | (£0.25) — 1% average return rate |
| Net-net revenue | £21.00 per unit — 16% below list price |
The gap between list price and net-net revenue is the discount waterfall. It typically widens by 1–2 percentage points per year as customers negotiate deeper terms and sales teams concede incremental allowances. Without tracking the waterfall at product level, price erosion is invisible.
The two contribution margin layers
Product CM I = Net-net revenue minus direct variable costs (materials, direct labour, variable production overhead, outbound logistics). This shows the variable margin — what each unit contributes above the costs it directly causes.
Product CM II = CM I minus product-attributable fixed costs (dedicated production lines, product-specific tooling, moulds, dedicated storage, regulatory compliance costs, product-specific marketing). This shows whether the product covers not only its variable costs but also the fixed infrastructure dedicated to it.
| Line | Product A | Product B | Product C | Product D |
|---|---|---|---|---|
| Net-net revenue | 2,400,000 | 1,800,000 | 600,000 | 200,000 |
| Direct variable costs | (1,440,000) | (1,260,000) | (240,000) | (140,000) |
| CM I | 960,000 | 540,000 | 360,000 | 60,000 |
| CM I ratio | 40.0% | 30.0% | 60.0% | 30.0% |
| Attributable fixed costs | (300,000) | (280,000) | (80,000) | (90,000) |
| CM II | 660,000 | 260,000 | 280,000 | (30,000) |
| CM II ratio | 27.5% | 14.4% | 46.7% | −15.0% |
Product D has a positive CM I — each unit sold contributes margin above its variable costs. But the fixed costs dedicated to Product D (a production line, specific tooling, dedicated storage) exceed the total CM I the product generates. Product D is consuming resources faster than it generates revenue. Without this layered view, Product D remains in the portfolio indefinitely because “it contributes gross margin.”
Why This Matters for Mid-Market Companies
Product proliferation is the silent margin killer
Each new SKU, variant, or service offering adds complexity costs that are real but rarely captured in product costing:
- Setup and changeover time — switching production between products consumes capacity
- Storage and warehousing — each SKU requires space, handling, and inventory management
- Quality assurance — each product requires testing, certification, and compliance monitoring
- Minimum order quantities — low-volume products generate proportionally higher ordering and production costs
- Catalogue and support — documentation, training, customer support knowledge for each product
These costs are spread across the portfolio in standard accounting, which systematically under-costs complex, low-volume products and over-costs simple, high-volume ones. The result: the products that appear most profitable in accounting reports are often the least profitable, and vice versa.
Revenue growth masks product-level erosion
Aggregate growth can hide that 20–30 per cent of the portfolio generates negative contribution margin at the CM II level. Revenue grows because the company is selling more — but selling more of the wrong products at the wrong margins.
The PARP (Polish Agency for Enterprise Development) data illustrates the mechanism at national scale: micro-firms with narrow product ranges consistently achieve higher profitability ratios than medium-sized firms with broad catalogues. Product proliferation during growth is a primary cause. Micro-firms have fewer products and better margin visibility per product.
Pricing decisions require product CM data
Cost-plus pricing from accounting data — the approach most mid-market companies use — allocates overhead based on volume or labour hours. This distorts pricing signals. A high-volume product absorbs more overhead per unit than a low-volume product, making it appear less profitable than it is. The low-volume product absorbs less overhead, appearing more profitable. Pricing based on this data is systematically wrong in both directions.
Deloitte research estimates that a 1 per cent increase in selling prices improves operating profit by 12.3 per cent. But price increases must be targeted at products where margin headroom exists and demand elasticity permits. This requires product-level CM data — not accounting product cost.
The portfolio rationalisation opportunity
Product rationalisation — reducing the number of active SKUs — is consistently identified in management literature as one of the highest-impact profitability interventions. BCG (Boston Consulting Group) research shows that only 48 per cent of cost-saving targets are achieved, partly because complexity costs are among the hardest to identify and cut. Product CM II data makes these costs visible and provides the evidence base for rationalisation decisions.
How to Build a Product Profitability Report
Step 1: Define the product hierarchy
Decide the level of analysis. Product line is too aggregated — profitable product lines often contain individual unprofitable SKUs that drag the average down. Individual SKU is ideal for manufacturing. For services firms, the equivalent is engagement type, service tier, or project category.
Step 2: Calculate net-net revenue per product
Extract transaction data from the ERP. Apply all discounts, rebates, credit notes, and returns at the product level. The gap between list price and net-net revenue is the first diagnostic signal — products with deep discount waterfalls are candidates for price erosion investigation.
Step 3: Identify direct variable costs per product
For manufacturing, the bill of materials (BOM) provides the starting point. Add direct labour at actual (not standard) rates, variable production overhead (energy, consumables), and variable logistics costs. Adjust for yield and scrap — the BOM shows what should be used; actual consumption includes waste.
For services, calculate the direct delivery cost: hours times the fully loaded cost rate for the people who delivered the work, plus any direct expenses (subcontractors, materials, travel).
The causality test: if this product were removed from the portfolio tomorrow, would this cost disappear? If yes, it belongs in CM I.
Step 4: Calculate CM I and rank the portfolio
Calculate CM I for every product. Sort by CM I ratio (highest to lowest) and by absolute CM I contribution (highest to lowest). These two rankings are complementary:
- CM I ratio identifies which products are most efficient at converting revenue into margin
- Absolute CM I identifies which products contribute the most total margin to the business
A product with a low CM I ratio but high absolute CM I (sold in very large volumes) may be more valuable to the business than a high-ratio product with minimal volume. Both views are needed for portfolio decisions.
Step 5: Identify product-attributable fixed costs
For each product or product group, identify fixed costs that exist because that product exists:
| Attributable Fixed Cost | Example |
|---|---|
| Dedicated production line | Depreciation, maintenance, operators |
| Product-specific tooling | Moulds, dies, jigs, calibration |
| Dedicated storage | Warehouse space, climate control, handling |
| Regulatory costs | Certification, testing, compliance per product |
| Product-specific marketing | Catalogue, samples, trade show presence |
The test: if this product were discontinued, would this cost eventually disappear (within 6–12 months)? If yes, it is attributable. If it would remain regardless, it is shared overhead and belongs below CM II.
Step 6: Calculate CM II and break-even volume
CM II = CM I minus attributable fixed costs. Products with negative CM II are consuming more resources than they generate and cannot be justified on financial grounds alone.
Break-even volume = Attributable fixed costs divided by CM I per unit. This shows how many units must be sold for the product to cover its dedicated fixed costs. If current volume is below break-even, the product is underwater at the CM II level.
Step 7: Build portfolio analysis views
Three views convert the data into management decisions:
Pareto analysis: Which 20 per cent of products generate 80 per cent of total CM I? This identifies the core of the portfolio — the products that fund everything else.
Volume-margin matrix: Plot products on two axes — volume (horizontal) and CM I ratio (vertical). This creates four quadrants:
| Low Volume | High Volume | |
|---|---|---|
| High CM I Ratio | Niche stars — protect margin, explore volume growth | Portfolio core — protect and optimise |
| Low CM I Ratio | Rationalisation candidates — review justification | Volume fillers — reprice or accept as capacity utilisation |
Product lifecycle view: Track CM I ratio for each product over time. Products in decline show falling CM I ratios as volume drops and fixed costs are spread over fewer units. This trend analysis provides early warning of products approaching the exit threshold.
Common Pitfalls
Using accounting product cost as a proxy for profitability. Accounting allocates overhead based on volume, revenue, or labour hours. This distorts product economics. A high-volume, simple product absorbs disproportionate overhead and appears less profitable. A low-volume, complex product absorbs too little and appears more profitable. The result is pricing and portfolio decisions based on systematically incorrect data.
Ignoring complexity costs. Setup and changeover, minimum batch sizes, quality testing, storage segmentation, and support requirements vary dramatically across products. A company with 500 SKUs may find that the bottom 200 generate 5 per cent of revenue but consume 30 per cent of production complexity costs. These costs are invisible in standard accounting.
Analysing profitability at the product-line level only. A profitable product line may contain individual products with deeply negative CM II. The line average hides the problem. Analysis at the individual product or SKU level reveals the variance that line-level reporting conceals.
Discontinuing products based on CM I alone. Some low-CM I products serve strategic purposes. A product with a 10 per cent CM I ratio may be the entry point that brings customers into the portfolio, who then buy high-margin products alongside it. Discontinuing the entry product may lose the customer entirely. Portfolio interdependencies must be assessed before exit decisions — which is why CM II data combined with customer-product cross-analysis is needed.
Treating product profitability as static. Input costs, volume, pricing, and competitive dynamics shift continuously. A product that was highly profitable 18 months ago may have eroded significantly due to material cost increases, competitive price pressure, or volume decline. Quarterly CM review is the minimum cadence.
Assuming ERP product costing equals product profitability. ERP standard costing allocates overhead mechanically — typically by production volume or direct labour hours. This systematically over-costs high-volume simple products and under-costs low-volume complex products. The restructuring from accounting product cost to management contribution margin is analytical work performed outside the standard ERP reports.
Industry Considerations
Manufacturing: BOM-based costing provides strong CM I accuracy when adjusted for actual yield and scrap rates. Production-run efficiency (setup time relative to run time) is a critical complexity cost that varies dramatically across products. Tooling amortisation and dedicated line costs form the core of attributable fixed costs.
Professional and business services: Engagement or project profitability replaces product profitability. The key variable cost is utilisation-adjusted labour — a consultant’s cost rate must reflect not just salary but the realistic utilisation rate. Scope creep is the services equivalent of product complexity cost: the client receives more work than was priced, consuming margin invisibly.
Retail and distribution: Category and SKU-level analysis with markdown, shrinkage, and shelf-space costs as product-attributable overheads. The cost of markdown on seasonal or slow-moving inventory is a direct product profitability factor that is often excluded from standard margin calculations.
Frequently Asked Questions
How many products should I analyse individually? Start with the products that represent 80 per cent of revenue — typically the top 20–30 per cent of the catalogue. Then analyse the long tail by category or segment. The long tail often reveals that hundreds of SKUs collectively generate minimal margin but significant complexity cost.
What if the same production line serves multiple products? If a production line is shared, the line cost is not attributable to any single product — it belongs below CM II as shared overhead. Only costs that are dedicated to a single product (or that would be eliminated if that product were discontinued) belong in the attributable fixed cost layer.
How do I handle products that customers expect as part of a range? This is the portfolio interdependency question. Analyse these products at CM I level. If CM I is positive, the product contributes to covering shared fixed costs even if CM II is negative. If CM I is also negative, the product destroys value on every unit sold and the strategic justification must be very strong to retain it. Customer-product cross-analysis — how much profitable volume would be lost if this product were discontinued — provides the evidence for the decision.
Should I use standard cost or actual cost for CM I? Use actual costs where available. Standard costs are designed for accounting — they smooth variance and allocate overhead. For product profitability analysis, you need the actual material cost, actual labour hours, and actual variable overhead consumed. The variance between standard and actual is itself a diagnostic signal: if actual consistently exceeds standard, the standard is wrong and pricing decisions based on it are misinformed.
Can I use ERP product costing reports directly? As a starting point, yes. As a final answer, no. ERP product costing allocates overhead mechanically. The value of product profitability analysis lies in stripping out mechanical allocations and replacing them with attribution based on causality — which costs does this product actually cause? The ERP provides the transaction data. The analytical restructuring is where the insight emerges.
Where This Fits in Our Expertise
Product profitability analysis applies the contribution margin methodology to the most operationally controllable dimension of margin — the product. It populates the product view of the management profit and loss statement, informs pricing strategy, guides portfolio rationalisation, and diagnoses the growth-without-profit paradox that mid-market companies frequently experience.
This article is part of the profitability analysis cluster within Performance & Profitability . Product profitability analysis connects directly to pricing — Deloitte’s 12.3 per cent operating profit sensitivity to a 1 per cent price change is the proof point — but pricing insight is invisible without product CM data. The companies that understand their product economics at the CM I and CM II level have the information to price accurately, rationalise effectively, and grow without diluting margin.
Related Reading
- Profitability Analysis Fundamentals — the parent framework for profitability measurement
- Contribution Margin Analysis — the methodology that product profitability analysis applies
- Customer Profitability Analysis — the parallel application to the customer dimension
- Margin Erosion — Causes and Prevention — product-driven erosion as a key cause of margin decline
- Cost Drivers — How to Identify What Really Drives Your Costs — product complexity as a cost driver
- Performance & Profitability — Our Expertise — how we approach performance analysis
- Glossary: Contribution Margin | Gross Margin | Cost Structure
Sources
- Deloitte — Pricing and Profitability Management — 1% increase in selling prices improves operating profit by 12.3%
- BCG — Cost Management 2025 — only 48% of cost-saving targets achieved; product complexity costs among hardest to identify
- PARP — Polish Agency for Enterprise Development — micro-firm profitability exceeds medium-firm profitability; product proliferation during growth is a primary mechanism
- PIE — Polish Economic Institute, Enterprise Profitability Report 2024 — net profitability fell from 4.3% to 3.4%; product-level margin pressure from input cost inflation
- IMA — Institute of Management Accountants — management accounting practice gaps at mid-market level
Martin Duben is the founder of Onetribe, where he works with mid-market finance leaders on profitability analysis, management reporting, and performance measurement across Central and Eastern Europe.