Sales Mix: Videos & Practice Problems

Cost-Volume-Profit (CVP) analysis is a vital tool for understanding how sales, costs, and profits interact, especially when a business sells multiple products. In real-world scenarios, companies rarely sell just one product, so incorporating the sales mix—the proportion of each product sold—is essential for accurate analysis. The sales mix allows businesses to calculate a weighted average contribution margin, which reflects the combined profitability of all products sold.

For example, consider a company like Pearson Pints that sells two types of ice cream: strawberry and chocolate. If 25% of sales are strawberry and 75% are chocolate, the weighted average contribution margin per unit can be calculated by multiplying each product’s contribution margin by its sales mix percentage and then summing these values. Mathematically, this is expressed as:

\[\text{Weighted Average Contribution Margin} = (P_A \times CM_A) + (P_B \times CM_B)\]

where \(P_A\) and \(P_B\) are the sales mix proportions for products A and B, and \(CM_A\) and \(CM_B\) are their respective contribution margins per unit. Using Pearson Pints’ data, if strawberry ice cream has a contribution margin of \$2 per unit and chocolate has \$1 per unit, the weighted average contribution margin is:

\[0.25 \times 2 + 0.75 \times 1 = 1.25\]

This means that on average, each pint sold contributes \$1.25 toward covering fixed costs and generating profit.

To determine the break-even point in units for the entire company, divide the total fixed costs by the weighted average contribution margin:

\[\text{Break-even Point (units)} = \frac{\text{Fixed Costs}}{\text{Weighted Average Contribution Margin}}\]

For fixed costs of \$15,000, the break-even volume is:

\[\frac{15,000}{1.25} = 12,000 \text{ pints}\]

To find the break-even sales volume for each product, multiply the total break-even units by each product’s sales mix percentage:

\[\text{Break-even units for product A} = P_A \times \text{Total Break-even Units}\]

\[\text{Break-even units for product B} = P_B \times \text{Total Break-even Units}\]

Applying this to Pearson Pints:

Strawberry ice cream:

\[0.25 \times 12,000 = 3,000 \text{ pints}\]

Chocolate ice cream:

\[0.75 \times 12,000 = 9,000 \text{ pints}\]

Thus, the company must sell 3,000 pints of strawberry and 9,000 pints of chocolate ice cream to break even.

This weighted average approach can be extended beyond break-even analysis to other CVP calculations, such as determining target profit levels. By using the weighted average contribution margin, businesses can analyze complex product mixes and make informed decisions about pricing, production, and sales strategies. Understanding how to integrate sales mix into CVP analysis enhances the ability to evaluate profitability across multiple products and supports more strategic financial planning.

When analyzing a business with multiple products, such as Tyler's Tables selling vegetarian and steak dinners, understanding the sales mix is crucial for calculating the break-even point. The sales mix represents the proportion of each product sold, which in this case is 80% steak dinners and 20% vegetarian dinners. To determine the break-even sales volume, the first step is to calculate the weighted average contribution margin per unit. The contribution margin is the difference between the sales price and the variable cost of each product, reflecting how much each unit contributes to covering fixed costs.

For the steak dinner, the contribution margin is calculated as \$20 (sales price) minus \$14 (variable cost), resulting in \$6. For the vegetarian dinner, it is \$20 minus \$10, equaling \$10. The weighted average contribution margin is then found by multiplying each product’s contribution margin by its sales mix percentage and summing the results:

\[\text{Weighted Average Contribution Margin} = (0.8 \times 6) + (0.2 \times 10) = 4.8 + 2 = 6.8\]

This weighted average contribution margin of \(6.80 per unit is essential for calculating the overall break-even point. The break-even point in units is the fixed costs divided by the weighted average contribution margin. Given fixed costs of \)5,000, the break-even point is:

\[\text{Break-even Point} = \frac{5000}{6.8} \approx 735.29 \text{ units}\]

Although the break-even point is not a whole number, it indicates the total number of units that must be sold to cover all fixed and variable costs. To find the specific number of steak and vegetarian dinners needed to break even, multiply the total break-even units by each product’s sales mix percentage:

\[\text{Steak Dinners} = 735.29 \times 0.8 = 588.24\]

\[\text{Vegetarian Dinners} = 735.29 \times 0.2 = 147.06\]

Therefore, Tyler's Tables must sell approximately 588 steak dinners and 147 vegetarian dinners to reach the break-even point. This approach highlights the importance of weighted averages in multi-product break-even analysis, enabling businesses to allocate sales targets effectively based on product mix and contribution margins.