Updated: Feb 26, 2021
While facilitating the Money and Metrics module of the Goldman Sachs 10,000 Small Businesses Program this week, I had a few business owners ask me how to calculate a multi-product or multi-service break-even point. An online search gave me several good explanations, but nothing I thought was comprehensive enough. As I started to write out something to answer these business owners’ questions, I realized I had enough to make a blog post. Here we go…
Regardless of whether you are selling one product or service, or multiple products and services, you start with two simple steps:
Once you’ve done this, the basic formula for figuring out break-even for a single product or service is simple enough.
So far so good. But this only works for businesses selling one item. And most businesses sell more than one product or service. To understand the calculation for multiple products or services, we need to dive a bit deeper. We’ll need the below formulas:
Average Cost Per Unit = Total Variable Costs / (sum of all quantities sold of all products and services)
Contribution Margin Ratio = Contribution Margin Per Unit / Average Revenue Per Unit = (Average Revenue Per Unit – Average Costs Per Unit) / Average Revenue Per Unit
Break-even = Expenses / Contribution Margin Ratio
Let’s work through an example. Suppose the below represents either a historic or forecast period of our business where we sell three products, A, B, and C:
Average Revenue Per Unit = Total Revenue / (sum of all quantities sold of all products and services) = $883,750 / 3,250 = $271.92
Average Cost Per Unit = Total Variable Costs / (sum of all quantities sold of all products and services) = $576,000 / 3,250 = $177.23
Contribution Margin Ratio = Contribution Margin Per Unit / Average Revenue Per Unit = (Average Revenue Per Unit – Average Costs Per Unit) / Average Revenue Per Unit = ($271.92 – $177.23) / $271.92 = 0.348
And then the break-even point is:
So in layman’s terms, this means that our business needs $574,712.64 in revenue in order to not lose money. Anything less than that puts us into debt. Anything greater, gives us a profit. In terms of units, we need to sell 529 units of Product A, 782 units of Product B, and 803 units of Product C.