How to Calculate the Weighted Average Contribution Margin
- 1). List the various products the business has to sell and the number of each product type you expect to sell. For example, based on sales data from previous years, a footwear store may expect to sell 6,000 pairs of sandals and 4,000 pairs of shoes.
- 2). Multiply the number of each product type you expect to sell by their sales prices to get the sales revenue for each product type. For example, if you sell 6,000 pairs of sandals for $20 a pair, you will get sales revenue of $120,000 from sandals. At $25 a pair, the 4,000 pairs of shoes will earn you $100,000.
- 3). Determine the variable cost of selling each product type. Variable cost refers to the cost a business has to pay to produce or sell one unit of an item. For example, you may have to give a commission of 5 percent to the sales associate every time he sells one item. The commission expense represents the variable cost of each item. To sell all the products, you will have to spend $6,000 for sandals (from 5 percent x $20 x 6,000) and $5,000 for shoes (from 5 percent x $25 x 4,000)
- 4). Deduct the variable cost of each product type from the sales revenue to obtain the contribution margin for each product. For example, with $120,000 sales revenue and $6,000 variable cost, the sandals have a contribution margin of $114,000. The shoes have a contribution margin of $95,000 (from $100,000 - $5,000).
- 5). Add all the contribution margins of all your products. For example, if the contribution margin of 6,000 pairs of sandals is $114,000 and the contribution margin of 4,000 pairs of shoes is $95,000, your total contribution margin will be $209,000.
- 6). Divide your total contribution margin by the total number of products you expect to sell to calculate the weighted average contribution margin. For example, with $209,000 total contribution margin and 10,000 products (6,000 pairs of sandals + 4,000 pairs of shoes), your weighted average contribution margin will be $20.90 per product unit (from $209,000/10,000).
