Weighted Average Margin Calculator

Behind the number

Weighted average margin weights each product's margin by its share of revenue: Σ(margin × revenue share). It produces the same answer as total profit over total revenue, and the weighted form is more useful because it shows each product's contribution to the result.

The weight has to be revenue, not units. Weighting by units treats a $8 sale and an $80 sale as equally important, which produces a figure that describes nothing.

A real example

Product A: 33% of revenue at 55% margin contributes 18.2 points. B: 37% at 55% contributes 20.4. C: 30% at 45% contributes 13.4. Weighted average: 52.0%.

Now the useful part. If C's share rose to 50% and A and B fell to 25% each, the contributions become 13.75, 13.75 and 22.5 for a weighted average of 50.0%. Seeing the point contributions makes it obvious where the two points went.

The same table also shows the upside: moving five points of revenue share from C to B raises the weighted average by half a point, which on $290,000 of annual revenue is $1,450 of gross profit for a merchandising change.

The usual mistakes

Revenue weighting understates the operational cost of low-value products. A product with 30% of revenue may account for 60% of orders, and orders: not revenue: drive picking, packing, support and returns handling.

For that reason a business whose costs scale with order count rather than order value should look at a second weighted figure using order share, and the two together tell a fuller story than either alone.

Using the result

Build the table with a point-contribution column and revisit it quarterly. The column turns an abstract percentage into a list of which products are responsible for the result, which is what makes it actionable.

Use it to set merchandising priorities. The products with the largest gap between their revenue share and their point contribution are the ones where a share shift is worth most.

Using it to plan a target margin

Weighted average margin can be solved backwards, which is what makes it a planning tool rather than a reporting one. If the business needs 55% blended and currently runs 52%, the table shows exactly what mix would achieve it.

Three routes usually appear. Shift revenue share towards the higher-margin lines, which requires no product changes. Raise the margin on the largest revenue contributor, which has the biggest effect per point. Or introduce a new high-margin line and give it enough promotion to take meaningful share.

Running the arithmetic on each shows which is realistic. Frequently the answer is that the largest contributor needs a two-point margin improvement, which is a supplier conversation rather than a strategy, and considerably more achievable than the mix shift that was being contemplated instead.

One caution on the target-setting version: the mix required to hit a blended margin has to be a mix customers will actually buy. A table showing that 55% is achievable if the lowest-margin line falls to 10% of revenue is arithmetically true and commercially meaningless if that line is what brings people to the site.

The honest version of the exercise separates products you could de-emphasise without consequence from those that anchor the range. The second group is usually smaller than people assume, and identifying it is more useful than the margin target that prompted the question.