For example, when a company has a poorly performing product, it can decrease or eliminate the product’s presence in the sales mix and focus on the more profitable products. Divide that by total units of 2,900 and we get a weighted average contribution margin of $1.50. To calculate the break-even point for multiple product lines, first determine the sales mix, which is the percent of overall sales each of the two products represents. When adjusting the sales mix, it is of considerable importance to understand the impact on the company constraint.

For example, suppose Amy’s Accounting Service has three departments—tax, audit, and consulting—that provide services to the company’s clients. Figure 6.5 “Income Statement for Amy’s Accounting Service” shows the company’s income statement for the year. Amy, the owner, would like to know what sales are required to break even. Note that fixed costs are known in total, but Amy does not allocate fixed costs to each department.

What Is Meant by a Product’s Contribution Margin?

Whatever remains after paying fixed costs equals your profit. If you sell lots of lobster you will have a lousy food cost…but you will have lots of cash! In the examples below 1,000 orders are served in each case. In one example it is mostly lobster, and in the other it is mostly spaghetti. At the end of the day would you rather have a 49.6% food cost and $23,000 net cash; or a 37.1% food cost and only $8,800 net cash? That’s $14,200 more net cash for the same amount of covers, the same amount of labor…focusing on the “lousy” food cost is a mistake.

Individual product performances can be analyzed based on which the sales mix can be fixed. The actual Sales Mix is the actual performance of every product concerning the business’s total sales. They also sell Kia Forte, a costlier car that yields more profit, but there is not much demand for that car. This has to be decided based on the demand in the market, production capacity, profitability of the product, etc.

Unlocking a measurable sales pipeline

The calculation method for the break-even point of sales mix is based on the contribution approach method. Since we have multiple products in sales mix therefore it is most likely that we will be dealing with products with different contribution margin per unit and contribution margin ratios. This problem is overcome by calculating weighted average contribution margin per unit and contribution margin ratio. These are then used to calculate the break-even point for sales mix. The sales mix variance represents the difference between what the company planned to sell and what the company actually sold.

We’ll calculate the sales mix variance for products A and B below. When the company realizes that a specific product is not getting enough profits, they can always ask for suggestions from the customers. Customer feedback, together with research and market intelligence team, can revamp the product and get it working in the market.

Examples of Inventory Cost Issues

Sales Mix is an evaluation of your Theoretical Food Cost based upon total items sold for a given period and the margin generated from those items. Following information is related to sales mix percentage formula sales mix of product A, B and C. If we know we need $125,000 in sales to break even but the sales mix is different from what we budgeted, the numbers will appear quite different .

• We’ll calculate the sales mix variance for products A and B below.
• If the sales mix is different from our estimate, the break even point will not be the same.
• The planned sales mix is 20,000 units of very-low-profit models + 50,000 units of medium-profit models + 30,000 units of very-high-profit models.
• Just like the variance analysis shown above, companies can also take their analysis one step further to determine market share and market size variances.
• You should remember that your mix value should be zero at the base level.
• Therefore, your optimal product mix might not be the one that gives you the most profit on paper, because on paper, you will sell every product you produce with no errors or returns.
• For the protein powder, there was an unfavorable variance, meaning the actual cost to produce and sell the protein powder was $138.60 greater than the expected cost.

Market share variance is the difference between actual market share and the estimated/standard market share at the same volume of sales. We should calculate the contribution margin per unit for each product as the first step in break-even analysis for the sales mix. Understanding sales mix can help companies maximize their profitability and growth, as companies can change their sales mix to correlate with demand.

It includes all of the items a business offers for sale to consumers. The sales mix considers the profit margin from each product and the ratio in comparison to its total products. This means that different products may have different profit margins, with some performing much better than others with consumers. Revenue Variance Analysis is used to measure differences between actual sales and expected sales, based on sales volume metrics, sales mix metrics, and contribution margin calculations.

• Master excel formulas, graphs, shortcuts with 3+hrs of Video.
• The sales volume variance, therefore, is unfavorable overall because the sales mix variance is significant.
• Better yet, you sell all 1,000 men’s shoes and women’s shoes.
• Menu Mix is often used interchangeably to refer to the same thing as Sales Mix.
• If you sell lots of lobster you will have a lousy food cost…but you will have lots of cash!
• Using the profit, in particular, makes this analysis 10 times or 20 times more insightful.

To meet Food Cost goals, it is not individual items that must meet Food Cost goal. A menu will include a variety of items at higher and lower price points, with higher or lower contribution margins with some items that are more popular than others. A restaurant like Applebee’s, which serves chicken, steak, seafood, appetizers, and beverages, would find it difficult to measure a “unit” of product. Such companies need a different approach to finding the break-even point. Now, let’s check your understanding of using the CVP model with multiple product lines. The cost of revenue is the total cost of manufacturing and delivering a product or service and is found in a company’s income statement.