How to Calculate Margin Mix

Combining sales and gross margins into one powerful metric.

Jan 18, 2016 at 12:45AM

For companies that sell more than one product, it is helpful to calculate how much each individual product contributes to the overall company's sales and profits. To do that, we calculate the margin mix for all of the company's products.

First, calculate gross profits and gross margins for each product
To demonstrate how this calculation works, let's work through a simple example. First, we'll need the sales price and cost of each product. We should exclude costs that are not a direct result of the production of our products. The following table shows our products, their sales prices, and their costs to produce.

 

Sales Price

Costs of Goods Sold

Product A

$25

$12

Product B

$10

$4

Product C

$50

$40

Product D

$15

$3

With this data, we'll calculate the gross profit and gross margin we earn from the sale of each product. Gross profit is just the difference between the sales price and the cost to produce the product. Gross margin is a percentage calculated by dividing the gross profit by the sales price. Doing this for each product, we can see how much profit we earn from the sale of each individual product in both dollar and percentage terms.

 

Gross Profit

Gross Margin

Product A

$13

52%

Product B

$6

60%

Product C

$10

20%

Product D

$12

80%

At this point, we can already begin to learn about our margin mix, even though we have a few more steps to go before we are finished. We can already see that Product D produces the highest percentage profit in gross margin terms and the second highest profit in dollar terms per unit sold, even though its sales price is the second lowest of our products.

Product C, on the other hand, is by far our most expensive product, but it is the lowest earning in percentage terms and second lowest in dollar terms.

Because Product C requires so much expense to produce relative to the profits it generates, it is our most inefficient product. Product D, conversely, is very efficient with its extremely low costs and high profit margins.

Next, we have to look at the overall sales
With this understanding of our gross profit and gross margins, we can now expand our analysis to include actual sales numbers. Gross profit only matters if the product sells, after all.

This table summarizes our sales from the last quarter.

 

Unit Sales

% of Total Unit Sales

Product A

60

27%

Product B

43

20%

Product C

100

45%

Product D

17

8%

With this data now in hand, our understanding of our sales mix changes a bit from our review of the gross profit and gross margin. Product C was our least efficient product, but it is also our best-selling product by a wide margin. Product D, our most efficient product, is our least popular seller. Products A and B are both decent sellers, far outpacing product D but remaining well below Product C's volume.

The final step in calculating our margin mix is to combine the gross profit and gross margin data and our sales mix data into a single metric. We do this by multiplying each product's gross profit by its percentage of unit sales. Each products percentage contribution to this metric is its margin mix.

 

Gross Profit

% of Total Unit Sales

% of Sales x Gross Profit

Margin Mix

Product A

$13

27%

3.55

35%

Product B

$6

20%

1.17

12%

Product C

$10

45%

4.55

45%

Product D

$12

8%

0.93

9%

This final step confirms much of what we've already learned, but also brings a new insight to light. First, we already knew that Product C was a very important product because of its high sales volume. That volume more than makes up for its tight gross margins and high costs of goods sold.

Likewise, the margin mix confirms what we already learned about Product D. Despite its great margins, it doesn't have nearly enough sales volume to have a big impact on this business.

With this final step now complete, we can for the first time see that Product A is a much more important product to us that Product B. Product A and B had relatively similar gross profit margins and unit sales. Compared to the extreme differences between Products C and D, Products A and B flew under our radar until this point in the analysis. But now we can clearly see that Product A is our second most important product. The combination of its higher sales price and decent sales volume gives it the advantage over Product B's low sales price.

The beauty of this margin mix analysis is in how it reveals new and useful insight as we move through the process. At each step in this example we learned important information about each of our products. As a manager or investor, this kind of understanding is a critical consideration in developing plans for company strategy, expansion possibilities, and product development.

The $15,978 Social Security bonus most retirees completely overlook
If you're like most Americans, you're a few years (or more) behind on your retirement savings. But a handful of little-known "Social Security secrets" could help ensure a boost in your retirement income. In fact, one MarketWatch reporter argues that if more Americans knew about this, the government would have to shell out an extra $10 billion annually. For example: one easy, 17-minute trick could pay you as much as $15,978 more... each year! Once you learn how to take advantage of all these loopholes, we think you could retire confidently with the peace of mind we're all after. Simply click here to discover how you can take advantage of these strategies.

This article is part of The Motley Fool's Knowledge Center, which was created based on the collected wisdom of a fantastic community of investors based in the Foolsaurus . Pop on over there to learn more about our Wiki and how you can be involved in helping the world invest, better! If you see any issues with this page, please email us at knowledgecenter@fool.com . Thanks -- and Fool on!

Try any of our Foolish newsletter services free for 30 days. We Fools may not all hold the same opinions, but we all believe that considering a diverse range of insights makes us better investors. The Motley Fool has a disclosure policy.

1 Key Step to Get Rich

Our mission at The Motley Fool is to help the world invest better. Whether that’s helping people overcome their fear of stocks all the way to offering clear and successful guidance on complicated-sounding options trades, we can help.

Feb 1, 2016 at 4:54PM

To be perfectly clear, this is not a get-rich action that my Foolish colleagues and I came up with. But we wouldn't argue with the approach.

A 2015 Business Insider article titled, "11 websites to bookmark if you want to get rich" rated The Motley Fool as the #1 place online to get smarter about investing.

"The Motley Fool aims to build a strong investment community, which it does by providing a variety of resources: the website, books, a newspaper column, a radio [show], and [newsletters]," wrote (the clearly insightful and talented) money reporter Kathleen Elkins. "This site has something for every type of investor, from basic lessons for beginners to investing commentary on mutual funds, stock sectors, and value for the more advanced."

Our mission at The Motley Fool is to help the world invest better, so it's nice to receive that kind of recognition. It lets us know we're doing our job.

Whether that's helping the entirely uninitiated overcome their fear of stocks all the way to offering clear and successful guidance on complicated-sounding options trades, we want to provide our readers with a boost to the next step on their journey to financial independence.

Articles and beyond

As Business Insider wrote, there are a number of resources available from the Fool for investors of all levels and styles.

In addition to the dozens of free articles we publish every day on our website, I want to highlight two must-see spots in your tour of fool.com.

For the beginning investor

Investing can seem like a Big Deal to those who have yet to buy their first stock. Many investment professionals try to infuse the conversation with jargon in order to deter individual investors from tackling it on their own (and to justify their often sky-high fees).

But the individual investor can beat the market. The real secret to investing is that it doesn't take tons of money, endless hours, or super-secret formulas that only experts possess.

That's why we created a best-selling guide that walks investors-to-be through everything they need to know to get started. And because we're so dedicated to our mission, we've made that available for free.

If you're just starting out (or want to help out someone who is), go to www.fool.com/beginners, drop in your email address, and you'll be able to instantly access the quick-read guide ... for free.

For the listener

Whether it's on the stationary exercise bike or during my daily commute, I spend a lot of time going nowhere. But I've found a way to make that time benefit me.

The Motley Fool offers five podcasts that I refer to as "binge-worthy financial information."

Motley Fool Money features a team of our analysts discussing the week's top business and investing stories, interviews, and an inside look at the stocks on our radar. It's also featured on several dozen radio stations across the country.

The hosts of Motley Fool Answers challenge the conventional wisdom on life's biggest financial issues to reveal what you really need to know to make smart money moves.

David Gardner, co-founder of The Motley Fool, is among the most respected and trusted sources on investing. And he's the host of Rule Breaker Investing, in which he shares his insights into today's most innovative and disruptive companies ... and how to profit from them.

Market Foolery is our daily look at stocks in the news, as well as the top business and investing stories.

And Industry Focus offers a deeper dive into a specific industry and the stories making headlines. Healthcare, technology, energy, consumer goods, and other industries take turns in the spotlight.

They're all informative, entertaining, and eminently listenable ... and I don't say that simply because the hosts all sit within a Nerf-gun shot of my desk. Rule Breaker Investing and Answers contain timeless advice, so you might want to go back to the beginning with those. The other three take their cues from the market, so you'll want to listen to the most recent first. All are available at www.fool.com/podcasts.

But wait, there's more

The book and the podcasts – both free ... both awesome – also come with an ongoing benefit. If you download the book, or if you enter your email address in the magical box at the podcasts page, you'll get ongoing market coverage sent straight to your inbox.

Investor Insights is valuable and enjoyable coverage of everything from macroeconomic events to investing strategies to our analyst's travels around the world to find the next big thing. Also free.

Get the book. Listen to a podcast. Sign up for Investor Insights. I'm not saying that any of those things will make you rich ... but Business Insider seems to think so.


Compare Brokers