Breakeven analysis

Pooja Maneesha
Analytics Vidhya
Published in
4 min readApr 27, 2020

--

Maybe even used the term before, or said: “At what point do we break even?”

Having the right price for a product or service can boost profit much faster than increasing volume. Setting a price is, of course, complicated but breakeven analysis can help.It’s a simple calculation to determine how many units must be sold at a given price to cover one’s fixed costs. You’re typically solving for the Break-Even Volume (BEV).

To show how this works, let’s take the hypothetical example of a high-end kite maker. Assume she must incur a fixed cost of $25,500 to produce and sell a kite. These costs might cover the software needed to design the kite and be sure it is sufficiently aerodynamic, the fee paid to a graphic designer to design the look and feel of the kite, and the development of promotional materials used to advertise the kite. These costs are fixed because they will not change with the number of kites sold.

The variable costs include the materials used to make each kite — special string for $3, the fabric for the body for $6, wooden dowels for $7, a special plastic handle for $4 — and the labor required to assemble the
kite, which amounted to one and a half hours for a worker earning $20 per hour. Therefore, the unit variable costs to make a single kite is: $50 ($20 in materials and $30 in labor). If she sells the kite for $75, she’ll make a unit margin of $25.Given the $25 unit margin she’ll receive for each kite sold, she will cover her $25,500 in total fixed costs if she sells:

You can see that the Breakeven Volume is 1,020 units. In other words, if this kite maker sells 1,020 units of this particular kite over the lifetime of the operation, she will fully recover the $25,500 in fixed costs she invested in production and selling. If she sells fewer than 1,020 units, she will lose money. And if she sells more than 1,020 units, she will turn a profit. That’s the breakeven point.

What if we change the price?

Suppose our kite maker is worried about current demand for kites and has concerns about her firm’s marketing capabilities, calling into question her ability to sell 1,020 units at a price of $75. What would be the implication of raising the price to $90, which would increase the unit margin to $40? moving the Revenue per Unit Sold to $100, you’ll see that breakeven sales would decline to 638 units.

With this information, the kite maker could assess whether she was better off trying to sell 1,020 kites at $75 or 638 kits at $90, and price accordingly.

What if we want to make an investment and increase the fixed costs?

Breakeven analysis also can be used to assess how sales volume would need to change to justify other potential investments. For instance, consider the possibility of keeping the price at $75, but having a celebrity endorse the kite (think Mary Poppins!) for a fee of $21,000. This would be worthwhile if the kite maker believed that the endorsement would result in total sales of $46,000 (the original fixed cost plus the $21,000 for Ms. Poppins).

When the Fixed Costs is $46,000 ,it would be only be worthwhile if the kite maker believed that the endorsement would result in total sales of 1,840 units. In other words, if the endorsement led to incremental sales of 820 kites units, the endorsement would break-even. If it led to incremental sales of greater than 820 kites, it would increase profits.

What if we change the variable cost of producing a good?

Breakeven also can be used to examine the impact of a potential change to the variable cost of producing a good. Imagine that our kite maker could switch from using a rather plain $6 fabric for the kite to a higher-end $16 fabric, thereby increasing the variable cost of the kite from $50 to $60 and decreasing the unit margin from $25 to $15. How much would sales need to increase to compensate for the extra cost?

Adjust the Variable Cost slider to $60 and the Fixed Costs back to the original $25,500 — our kite maker can’t afford to have nice fabric AND get Mary Poppins). You’ll see the switch to the nicer fabric would make sense if the kite maker thought it would result in sales of 1,700 units, an additional 680 kites.

You likely aren’t a kite maker or able to get a celebrity endorsement from Mary Poppins, but you can use breakeven analysis to figure out how the various inputs on your product — revenue, costs, and output sold ­ — impact your business’s profitability.

--

--