Product Margin Analysis: How to Find Your Real Winners and Losers

Product margin analysis ranks every product by what it really earns after the costs it causes, so you can see which products carry the business, which merely break even and which lose money without anyone noticing. Most companies know their gross margin by product, but gross margin leaves out freight, returns, fees and commissions that differ widely between products, and it includes allocations that distort the picture. This guide gives a step-by-step method, works a six-product example with checked arithmetic, shows how to test a decision to drop a product, and covers the allocation traps that cause the wrong decisions. It belongs to unit economics and budgeting and forecasting, builds on operating margin and contribution margin, and leads to SKU profitability analysis and customer profitability analysis.

Step 1: define the product level

Decide at what level you will analyze. Product families are good for strategic decisions and SKUs for operational ones. Start with the product line or family, where data are more reliable, and drill into the biggest and weakest groups. A common structure is brand, category, product family and SKU. Keep it stable, so that trends can be followed. See SKU profitability analysis for the next level down.

Step 2: collect revenue net of discounts and returns

Use net revenue: gross sales less discounts, rebates, allowances and returns. If your system books returns and promotions at company level, allocate them to products based on actual transactions. Products that attract heavy promotion can look much better on list price revenue than they are.

Step 3: assign variable costs by product

For each product, gather every cost that rises with its volume:

• Product cost or materials, including inbound freight and duties.
• Direct labor and packaging.
• Outbound freight and handling, by weight, volume or lane.
• Payment fees, marketplace fees and sales commissions.
• Returns cost and warranty.
• Product-specific marketing and promotions.

Assign as directly as the data allow. For costs that cannot be traced, use a driver that reflects cause: pick lines for warehouse labor, weight for freight, order count for payment fees. Avoid allocating by revenue unless there is no better driver, since revenue-based allocation spreads costs evenly and hides the very differences you are looking for.

Step 4: calculate contribution by product

Contribution = Net revenue - Product cost - Other variable costs
Contribution margin % = Contribution / Net revenue

A worked example

A hypothetical company with six products (annual figures, illustrative):

Check: revenue 900 + 700 + 500 + 400 + 300 + 200 = 3,000 (thousands); product cost 450 + 350 + 300 + 200 + 150 + 140 = 1,590; other 90 + 70 + 100 + 120 + 60 + 90 = 530; contribution 360 + 280 + 100 + 80 + 90 - 30 = 880 = 3,000 - 1,590 - 530.

What the table says

• Concentration. Products A and B generate 360,000 + 280,000 = $640,000, or 640 / 880 = 72.7% of contribution from 53 percent of revenue (1,600 / 3,000).
• Hidden weakness. Product D earns the same 20 percent as C, but 30 percent of its revenue goes to freight, fees and returns (120 / 400). A change in carrier rates would hit it hard. Products C and D are candidates for price increases or cost work.
• A loser. Product F loses $30,000 on every dollar of revenue before any overhead. Its gross margin before freight, fees and returns is (200 - 140) / 200 = 30 percent, which would not have flagged it. The costs below the gross margin line turned a seemingly acceptable product into a loss.

Step 5: look at the right fixed costs

Allocations of shared overhead can make the picture misleading. If $600,000 of overhead were allocated by revenue, Product F would receive (200 / 3,000) × 600,000 = $40,000, and its fully loaded result would be -$70,000. Product A would receive $180,000 and show a fully loaded profit of $180,000. The ranking is the same here, but the allocation adds no new information, and it can mislead when it makes marginal products look like losers or winners for reasons unrelated to cause. Use contribution for deciding about the product, then use fully loaded results to test whether the portfolio covers overhead and delivers the profit you need.

Step 6: decide what to do with each product

Testing the "drop it" decision

Before discontinuing Product F, check four things.

1. Avoidable costs. Dropping F removes its $200,000 of revenue, $140,000 of product cost and $90,000 of other variable costs, for a gain of $30,000 in contribution. The allocated overhead of $40,000 does not go away unless it is truly avoidable. If it stays, the company's profit rises by $30,000, not by $70,000.
2. Halo effects. Do customers who buy F also buy A or B? If dropping F lost $60,000 of contribution on related sales, the net effect would be -$30,000.
3. Capacity. What will the freed capacity, working capital or shelf space be used for?
4. Fixability. Could a price increase of 10 percent turn F positive? 10 percent of $200,000 is $20,000, which on its own does not offset the -$30,000, so cost or freight changes are also needed. A freight reduction of $15,000 together with the price increase would bring F to +$5,000.

Common traps

• Gross margin as the product margin. It omits freight, fees and returns.
• Allocating overhead by revenue and drawing conclusions about individual products.
• Looking at one period. Seasonal products and launches need a longer view.
• Ignoring product interactions. Complements and traffic drivers matter.
• Ignoring inventory. A product with fine margin can still destroy cash through slow turns.
• Not updating costs. Standard costs lag reality.
• Treating analysis as a one-off. Refresh quarterly.

Operations affect product margin

Product margin depends on forecast accuracy and inventory discipline. Slow sellers generate markdowns and storage costs, fast sellers generate stockouts, and both change the margin that the analysis would show. Link the analysis to the demand plan. See demand planning and inventory optimization.

Quick wins the analysis tends to reveal

Once you have the table, small changes to the mid-tier products often produce larger gains than dramatic moves on the extremes. In the example, Product C has freight, fees and returns of $100,000 on $500,000 of revenue. Consolidating shipments and changing packaging to cut that cost by 15 percent saves $15,000, raising contribution to $115,000 and the margin from 20.0 to 23.0 percent. Product D could take a 3 percent price increase: revenue rises by $12,000 to $412,000, and if volume holds, contribution rises to $92,000, a margin of 22.3 percent. Together, the two changes add $27,000 to contribution, close to the $30,000 a year that dropping Product F would add, without losing a product.

Data sources and how much effort to expect

A first pass can usually be built in a week or two from the sales ledger, purchase costs, carrier invoices, payment processor reports and returns records. The hardest part is usually returns and freight by product, since many systems book them at order or company level. Accept an allocation by order lines or weight for the first version, label it as an estimate and improve it over time. Reconcile the sum of product contributions to the company's income statement, so that the analysis can be trusted.

Reporting to leadership

Present the analysis on one page: a ranked table, a chart of cumulative contribution (showing how few products produce most of it), the three biggest problems with a proposed action and owner for each, and the expected effect on profit. Revisit the same page every quarter, with progress against the actions. A product margin analysis that ends in a presentation and no actions is a missed opportunity.

FAQs

What is product margin analysis?

A method for calculating the margin that each product contributes after the costs it causes, to identify which products make money and which do not.

How do I calculate product margin?

Subtract the product's cost and other variable costs, such as freight, fees and returns, from its net revenue. Divide by net revenue for the percentage.

Should I drop a product with negative margin?

Not automatically. Check avoidable costs, halo effects on other sales, whether price or cost can be fixed and how the freed resources will be used.

Should I allocate overhead to products?

For decisions on individual products, use contribution. Use allocated results only to check whether the portfolio as a whole covers overhead.

How often should I update product margin analysis?

Quarterly for most companies, and whenever prices, supplier costs or freight rates change significantly.