Calculator Inputs
Example Data Table
| Product | Selling Price | Variable Cost | Sales Mix % | Contribution / Unit |
|---|---|---|---|---|
| Product A | $120.00 | $72.00 | 40% | $48.00 |
| Product B | $90.00 | $54.00 | 35% | $36.00 |
| Product C | $60.00 | $30.00 | 25% | $30.00 |
With fixed costs of $18,000 and target profit of $6,000, the weighted contribution margin ratio is 41.59%, break-even sales are $43,282.44, and break-even composite units are 458.02.
Formula Used
Contribution per unit: Selling Price − Variable Cost
Normalized mix share: Product Mix ÷ Total Mix
Composite sales value: Σ(Normalized Mix × Selling Price)
Composite contribution value: Σ(Normalized Mix × Contribution per Unit)
Weighted contribution margin ratio: Composite Contribution Value ÷ Composite Sales Value
Break-even sales: Fixed Costs ÷ Weighted Contribution Margin Ratio
Break-even composite units: Fixed Costs ÷ Composite Contribution Value
Target sales: (Fixed Costs + Target Profit) ÷ Weighted Contribution Margin Ratio
Per-product break-even units: Break-Even Composite Units × Normalized Mix Share
How to Use This Calculator
- Enter total fixed costs for the period you want to evaluate.
- Add a target profit if you want a goal above simple break-even.
- Enter expected sales revenue to calculate margin of safety metrics.
- Complete at least two product cards with price, variable cost, and mix weight.
- Use any mix weights you prefer, such as percentages, units, or ratios.
- Click the calculate button to show results above the form.
- Review weighted margins, break-even sales, target sales, and product allocations.
- Download the summary and product detail tables as CSV or PDF.
Frequently Asked Questions
1. Why does this calculator use weighted contribution margin?
Different products generate different margins. A weighted contribution margin combines those margins using your sales mix, creating one realistic blended rate for break-even planning.
2. What is a composite unit?
A composite unit is a blended sales bundle based on normalized mix. It is not one physical unit unless your products always sell in that exact ratio.
3. Do my sales mix values need to total 100?
No. The calculator normalizes your mix automatically. You can enter percentages, quantities, or ratio weights, as long as each active product has a positive value.
4. What happens if one product has a low margin?
A low-margin product can still fit the mix, but it reduces the blended contribution rate. If the overall weighted contribution becomes nonpositive, break-even is not achievable.
5. How is target profit different from break-even?
Break-even covers fixed costs only. Target profit adds your desired operating income, so the required sales and units increase above the break-even point.
6. Why is margin of safety useful?
Margin of safety shows how much projected revenue exceeds break-even sales. It helps you judge downside risk and how much sales can fall before losses start.
7. When is degree of operating leverage shown?
It appears when expected operating income is positive. That measure estimates how strongly profits may react to percentage changes in sales volume.
8. Can I use this for monthly or yearly planning?
Yes. Keep every input on the same time basis. If fixed costs are monthly, prices, costs, sales, and targets should also reflect a monthly period.