Product Margin Analyser

Why this question matters

Sales revenue can make a product look important even when its delivery costs consume most of the value it brings into the business. This analyser compares the contribution of up to eight product lines over a consistent period. It helps you see which lines provide money towards shared overhead and which consume money before overhead is considered. The result is a starting point for reviewing the offer mix, cost control and pricing decisions.

Define each product line consistently. A line might represent one standard product, a repeatable service package or a group of genuinely similar items. Enter the actual selling price, direct cost per unit and units sold over the chosen period. Use the realised price where routine discounts or concessions change the amount received. If a line contains very different prices or delivery requirements, separate it into more meaningful groups instead of relying on an average that hides the variation.

Direct cost should follow the activity required to deliver the unit. Materials, packaging, transaction charges, direct labour or outsourced delivery may be relevant depending on the business model. Avoid counting shared overhead inside every product line and then subtracting it again when reviewing company profit. Record the cost definition so that a colleague can reproduce the calculation. A clear, imperfect estimate is easier to improve than a precise looking figure with an unknown basis.

Understand the method

1. Unit contribution = price − direct unit cost.
2. Period contribution = unit contribution × units sold.
3. Contribution margin = total contribution ÷ total revenue × 100.

The tool subtracts direct unit cost from selling price to obtain unit contribution. It multiplies that difference by units sold to calculate contribution over the entered period. Product lines are ordered from the lowest period contribution upwards. The summary identifies how many entered lines have negative contribution. Total contribution is then compared with total revenue to obtain the combined contribution margin. This combined percentage reflects the actual entered sales mix.

A large contribution amount and a high contribution percentage answer different questions. One product may deliver a modest percentage on substantial volume, while another produces a strong percentage on very few sales. Neither measure alone determines which product deserves attention. Consider capacity consumed, collection timing, repeat demand and strategic fit. If two lines compete for a scarce resource, contribution per unit of that resource may be more informative than contribution per product.

Investigate negative lines before expanding their volume. Check for missing revenue, incorrect units, unusual introductory costs or an intentionally limited promotion. If the figures are correct, review price, scope, waste and sourcing. Do not assume that removing a negative line automatically improves the whole business by exactly the displayed amount. Some costs may remain, and the line may be linked to another purchase. Examine those relationships explicitly before changing the offer.

Keep the result in perspective

This is a transparent planning calculation or self assessment, not a sector benchmark, professional valuation or a prediction of an outcome.

Contribution is not net profit. Shared overhead, tax and finance costs still need to be covered.

Contribution is not net profit. Shared administration, rent, financing, tax and other overhead still need to be covered. The analyser does not automatically allocate those costs, value inventory, recognise revenue under an accounting standard or determine the profitability of the entire company. It uses the unit economics and volume supplied by you, so cost omissions can make a weak line appear attractive.

Up to eight rows are intended for a focused review. Group a large catalogue deliberately or analyse it in coherent batches. Zero units create zero period contribution even if the unit price is below cost. Where total revenue is zero, a percentage margin cannot be interpreted normally and the tool says no revenue was entered. Positive contribution also does not establish that customers pay quickly enough to fund delivery.

Read the full limitations or explore how Ayodeji approaches this work.