Break Even Analysis Template Formula to Calculate Break-Even Point

break even analysis for multiple products

In the YouTube video below, I use Excel to find the break-even with multiple products. I demonstrate the array function, use conditional formatting, and work with absolute reference to find the weighted average contribution margin per unit. Fixed costs are those which are assumed to be constant during the specified payback period and which do not depend on the number of units produced. Advertising, insurance, real estate taxes, rent, accounting fees, and supplies would all be examples of fixed costs. Fixed costs also include salaries and payroll taxes for non-direct labor such as administrative assistants and managers, or in other words, the payroll not included as variable costs. The result obtained with the methods proposed are compared with those obtained using other methods, and the implications for managerial decision-making are analyzed.

  • However, you need to think about whether your customers would pay $200 for a table, given what your competitors are charging.
  • The hard part of running a business is when customer sales or product demand remains the same while the price of variable costs increases, such as the price of raw materials.
  • In addition to the Break-Even Point, the worksheets also solve for the number of units or the price to reach a target Net Income Before Taxes (NIBT).
  • When there is an increase in customer sales, it means that there is higher demand.
  • If we change the composition of the basket, then the composite contribution margin would change even though contribution margin of the individual items would not change.

The weighted average contribution margin can now be used as before in steps 2 and 3 above. The business breaks even when it sells 1,842 units of product A, and 205 units of product B. The small net income of 7 is due to rounding up to the nearest unit during the calculations. For companies that produce more than one product, break-even analysis may be performed for each type of product if fixed costs can be determined separately for each product. So we need to break up the 180 units into the 3 different products using our mix of 60%.

Best Startup Business Loan Options for Entrepreneurs

The contribution margin is the excess between the selling price of the product and the total variable costs. For example, if an item sells for $100, the total fixed costs are $25 per unit, and the total variable costs are $60 per unit, the contribution margin of the product is $40 ($100 – $60). This $40 reflects the amount of revenue collected to cover the remaining fixed costs, which are excluded when figuring the contribution margin. Revenue represents total income generated from the sale of goods or services by an individual or business.

One of the assumptions of the linear CVP model is that the Sales Price per unit (P) remains constant. So, the total revenue (TR) is just the price (P) multiplied by number of units sold (X). However, prices typically decrease with increasing demand, so be aware that the linear CVP model is a simplification.

Calculating Break-Even Analysis in a Multi-Product Environment

It can also hint at whether it’s worth using less expensive materials to keep the cost down, or taking out a longer-term business loan to decrease monthly fixed costs. The loss becomes smaller as sales volume increases, due to the higher contribution as sales volume increases. Break-even point is then reached and profits are made at sales volumes above the break-even point. The determination of the break-even point in CVP analysis is easy once variable and fixed costs are determined. The calculation of a multi-product break-even point is almost the same as a single-product break-even point. The only difference is that the denominator is the weighted average contribution per unit (for break-even point in units) or weighted average contribution to sales (C/S) ratio (for Break-even Revenue).

Another reason why break-even analysis is important to stock and option traders is that break-even analysis provides insight into their positions’ profitability. By determining the breakeven point for their positions, stock and option traders can gauge the potential risk-reward ratio and make informed decisions as to whether to pursue a stock or option trade. CVP Analysis assumes that, if a range of products is sold, sales will be in accordance with a pre-determined sales mix.

Multi-Product Break-even Analysis

The formulas for the break even point are relatively simple, but it can be difficult coming up with the projected sales, selecting the right sale price, and calculating the fixed and variable costs. While these tasks are still the responsibility of the business owner, our Break Even Calculator can help you run and report the analysis. Once you’re above the break-even point, every additional unit you sell increases profit by the amount of the unit contribution margin. This is the amount each unit contributes to paying off fixed costs and increasing profits, and it’s the denominator of the break-even analysis formula.

break even analysis for multiple products

Adam Hayes, Ph.D., CFA, is a financial writer with 15+ years Wall Street experience as a derivatives trader. Besides his extensive derivative trading expertise, Adam is an expert in economics and behavioral finance. Adam received his master’s in economics from The New School for Social Research and his Ph.D. from the University of Wisconsin-Madison in sociology. He is a CFA charterholder as well as holding FINRA Series 7, 55 & 63 licenses.