Inventory Management Software

Kardex Tauro

Kardex Tauro® Inventory Software is designed to efficiently manage your warehouse or storage facility, and it is quick and easy to learn.

Kardex Tauro is free for non-commercial use.
It does not require an internet connection; it runs on Windows.

Break-even point: formula, example and how to use it

Break-even point: formula, example and how to use it

The break-even point is the sales level at which a company neither earns nor loses: revenue covers costs exactly. You get it by dividing the period's fixed costs by the unit contribution margin, or by the contribution margin ratio when the figure is wanted in money, and it answers two questions: how much must be sold to stay afloat, and how far sales can fall before the business turns a loss. What follows covers both formulas, how to build the fixed costs of a period, the margin of safety, the multi-product case, and a full example with its price change.

What the break-even point is and what it is not

It is the volume at which profit is zero. Below it the business loses, above it the business earns, and the distance between one point and the other is what makes the number useful.

Three confusions are worth clearing. It is not a permanent figure: it is calculated per period and with that period's fixed costs, so January's number stops working in March if rent, payroll or price changed. It is not a target: it does not include the profit you want to make, and adding that requires a different calculation. It is not a forecast: it is a threshold that sales must clear.

With the number in hand there are three readings. As a threshold, it says how much must be sold to avoid a loss. As a cushion, it says how far sales can fall. As a risk measure, it says how heavy the structure is: a high break-even demands a lot of volume and leaves little room for a weak month.

The formula in units: how many units must be sold

Fixed costs of the period divided by price minus unit variable cost. The result reads in units of the product.

The denominator has a name: unit contribution margin. It is what each unit contributes after paying its own variable cost, and the only thing that can help cover fixed costs. That is why the formula divides by margin and not by profit: at the break-even point profit does not exist yet.

With a price of $50,000 and a variable cost of $22,500, the margin is $27,500. If the month's fixed costs are $8,000,000, the division gives 290.9 units, rounded up to 291. The rounding is not a whim. At 290 units the accumulated margin is $7,975,000 and $25,000 are missing to cover fixed costs; at 291 the margin is $8,002,500 and the company sits just above zero.

This version works with one product, or with several homogeneous ones that can be counted in the same unit. With a broad catalogue and very different prices, counting units stops making sense.

The formula in money: the contribution margin ratio

To express break-even in money, divide fixed costs by the margin ratio, which is unit margin divided by price. Here $27,500 over $50,000 gives 0.55, that is 55%. Dividing $8,000,000 by 0.55 gives $14,545,455: what must be invoiced in the period to end at zero. The figure supports another reading that is easier to remember: for every peso of fixed cost, 1.82 pesos must be sold.

This version works with broad catalogues, because it does not require a common unit, and it speaks the language of sales targets, which is almost always revenue.

Three conditions make the result reliable. Time consistency: fixed costs and sales must belong to the same period, because one month of sales against one year of costs produces a meaningless number. Currency consistency: if the price is in pesos, the variable cost is too. And sales tax treatment: work with prices excluding VAT, because that tax is not the company's revenue and, if it is included, the margin is inflated and break-even comes out lower than reality.

How to build the fixed costs of the period

A cost is fixed when it does not change because volume changes, within a reasonable operating range and within a period. Rent is paid the same whether ten units or a thousand are sold; raw material only exists if there is something to produce. The classification does not depend on the account name but on how it behaves.

ItemBehaviorCriterion
Rent of premises or warehouseFixedBilled at the same amount in a bad month and in a good one
Administrative and management payrollFixedDoes not depend on units sold
Raw materials and direct inputsVariableGrows with each unit produced
Sales commissionsVariableExists only if there is a sale
Outbound freightVariableTriggered per order or per unit shipped
Utilities and maintenanceMixedHave a fixed part and another that follows consumption
Depreciation, insurance and subscriptionsFixedAccrue over time, not with volume

The practical rule: if the cost appears every time a unit is sold, it is variable. If it arrives billed at the same amount in a weak month and in a strong one, it is fixed. When the answer is "it depends", the item is mixed and must be split by comparing two or three months of very different volumes, or by reading the invoice detail, where a base charge and metered consumption usually appear. The decision should be documented: the same item classified two ways produces two different break-even points.

The most common error is not misclassifying but forgetting. Depreciation, insurance, software subscriptions, accountant fees, security and bank charges accrue month after month and are rarely on the list the first time. A break-even calculated without them is an optimistic one.

The time unit rules: with annual fixed costs the result is annual, and mixing scales produces unusable figures.

Margin of safety: the figure that actually supports decisions

The break-even point says where zero is. The margin of safety says how far the company is from that zero: actual sales minus break-even sales, divided by actual sales.

In the example the company sells 400 units at $50,000, that is $20,000,000, and its break-even is $14,545,455. The difference, $5,454,545, over $20,000,000 gives 27.3%. That is the answer to the question every owner eventually asks: how far sales can fall before losing money. Here it equals about 109 units or $5.4 million in revenue.

This indicator is more useful than the break-even point because it is a proportion and not an absolute threshold. Two companies with the same break-even can carry very different risk: the one selling just above it lives on the edge; the one selling far above absorbs a bad month, a departing customer or a competitor cutting prices.

There is no universal value that can be called good: a comfortable margin in a services firm with annual contracts would be insufficient in a seasonal retailer. What works is comparing it with your own history, with the months of the year and with customer concentration. If 40% of sales depends on three customers, 20% is more fragile than it looks.

The use is direct: with a wide cushion you can invest or hire; with a narrow one, protecting the structure comes before growing.

Several products: weighted margin and mix

With several products you cannot divide fixed costs by different margins, because the division would have no coherent unit. The margin is weighted by each product's share of sales, measured in money and not in units.

Take two products. A sells at $50,000, costs $22,500 and leaves a margin of $27,500, and brings 60% of revenue. B sells at $30,000, costs $21,000 and leaves $9,000, with the remaining 40%. The weighted margin is 0.60 × $27,500 + 0.40 × $9,000 = $16,500 + $3,600 = $20,100. The weighted price is $42,000, so the margin ratio drops to 47.86%.

With $8,000,000 in fixed costs, break-even in money is $16,716,418, considerably higher than the $14,545,455 of a single product. In composite units it is 398, split into 239 of A and 159 of B. Check: 239 × $27,500 = $6,572,500 and 159 × $9,000 = $1,431,000; the total, $8,003,500, covers fixed costs through rounding.

The warning belongs here: mix is the most fragile assumption. If the lower-margin product grows faster, the weighted margin falls and break-even rises even though total sales also rise.

A complete example with a single-product company

One product at $50,000, a variable cost of $22,500 and monthly fixed costs of $8,000,000. The figures are an exercise, not market data: what matters is the procedure, which can be repeated with any business's real numbers.

StepCalculationResult
Selling pricePrice list, excluding VAT$50,000
Unit variable costProduct cost$22,500
Contribution margin50,000 − 22,500$27,500
Margin ratio27,500 ÷ 50,00055%
Fixed costs of the monthSum of fixed items$8,000,000
Break-even in units8,000,000 ÷ 27,500291 units
Break-even in money8,000,000 ÷ 0.55$14,545,455
Profit at 400 units400 × 27,500 − 8,000,000$3,000,000
Actual sales400 × 50,000$20,000,000
Margin of safety(20,000,000 − 14,545,455) ÷ 20,000,00027.3%

The full reading: 291 units a month are needed to avoid a loss; the current 400 leave $3,000,000 of profit and a cushion of 27.3%. If sales fall to 350 units the company still earns $1,625,000, because 350 × $27,500 = $9,625,000 minus $8,000,000. Below 291, the month closes at a loss.

What happens when the price drops 10%

Cutting the price to sell more is the decision that has ruined the most break-even points. If the price goes from $50,000 to $45,000 and the variable cost does not move, the unit margin falls to $22,500, the ratio drops from 55% to 50% and break-even jumps.

ConceptPrice $50,000Price $45,000
Unit contribution margin$27,500$22,500
Margin ratio55%50%
Break-even in units291356
Break-even in money$14,545,455$16,000,000
Sales at 400 units$20,000,000$18,000,000
Profit at 400 units$3,000,000$1,000,000
Margin of safety27.3%11.1%

Break-even rises from 291 to 356 units: 65 more, an extra 22%, just to get back to zero. And since the price is lower, break-even in money also rises, to $16,000,000. Selling 400 units no longer leaves $3,000,000 but $1,000,000, and the cushion falls to 11.1%.

To keep the $3,000,000 profit at the lower price, the company would have to sell 489 units: $11,000,000 of required margin divided by $22,500. That is 89 more units, 22.3% additional volume, and revenue would climb to $22,005,000. There is the question that precedes every discount: can the market grow 22%, or was the price simply too low? If it is the second, the discount does not increase profit, it transfers it to the customer.

The logic works in reverse. A 10% price increase would take the margin to $32,500 and break-even to 247 units, with more cushion. The limit is not arithmetic but commercial: how much volume is lost at the new price.

Target profit: how much must be sold to earn what you want

The break-even point takes profit to zero and many companies do not work for that. For a given profit, add that profit to fixed costs and repeat the division: fixed costs plus target profit, divided by the unit margin.

With the same $8,000,000 and a desired profit of $3,000,000, the sum is $11,000,000 and the division by $27,500 gives exactly 400 units, that is $20,000,000 in sales. The coincidence is not accidental: the company in the example sits right on its target. If the target rose to $4,000,000, it would take 437 units and $21,850,000 in revenue.

Two clarifications. Target profit is not a cost: it is added to fixed costs as an algebraic device to solve for volume, not because it accrues month to month. And the formula works with pre-tax profit; if the target is stated as net profit, it must be converted first and the applicable rate confirmed with your accountant, because it depends on each company.

Assumptions and limits of the model

The calculation is simple, but it rests on four assumptions that must be checked before trusting the result.

  • Constant price. With volume discounts, promotions or per-customer negotiation, the real price is not the list price and the margin is calculated on an average that may represent nothing.
  • Proportional variable costs. It assumes every unit costs the same. With volume economies or growing waste, the proportion breaks.
  • Stable mix. If the composition of sales changes, the weighted margin changes and so does break-even.
  • Sufficient capacity. The formula does not ask whether the company can produce that volume. If it cannot, the number is a target with no operational backing.

There is a fifth limit, almost always the most important: the operating range. Fixed costs are fixed within a band. Crossing a certain volume means hiring a shift, renting more warehouse space or buying a machine, and fixed costs jump. The break-even calculated with the current structure stops holding exactly when the company starts to grow. That is why the indicator is recalculated whenever something structural changes: it ages.

Frequent errors and how to spot them

The missteps in this calculation do not show up at the moment, they show up in next month's result. These are the most common, with the signal each one leaves.

ErrorSymptomConsequence
Mixing fixed and variable costsThe margin comes out different each time it is recalculatedPricing decisions on a false base
Forgetting fixed items such as depreciation or insuranceBreak-even lands below what the company needsA loss at closing even though "the target was met"
Using the price with VAT includedThe margin ratio looks better than it isUnderstated break-even
Calculating once and never updatingThe number is more than a year oldBelieving a cost that already rose is covered
Cutting price without recalculatingMore is sold and profit does not riseThe cushion narrows with nobody noticing
Averaging margins without weightingThe catalogue's break-even does not match realityImpossible targets and late decisions

The antidote is always the same: write down what was included in fixed costs, which prices were used and which period the sales came from. When the calculation can be audited, it can also be corrected.

An honest close before deciding

The break-even point is a tool about structure, not a complete diagnosis. It does not say whether the product is good or whether the price is competitive; it says how much must be sold to cover what it costs to operate.

Nor does it replace the accountant or the cash flow statement. A company can sit above its break-even and still run out of cash because it collects at ninety days and pays at thirty, or because it financed inventory with expensive debt. Break-even measures result, not cash, and confusing the two is costly.

If the business is highly seasonal, if the mix changes every month, or if a large part of the costs are mixed, it is better to work with scenarios instead of a single number: one with the current structure, one with the fixed costs of the most expensive month and one with the least favorable mix. The answer stops being a figure and becomes a range, which is what reality supports.

And if the calculation becomes an end-of-month chore, the cause is almost always the same: the data are scattered. When inventory, sales and costs live in one system — such as Kardex Tauro, which consolidates margin by product — break-even is reviewed when the price changes, not when there is time. That is the use that gives it value: stop calculating it once a year and start using it in every pricing decision.

Keep reading

Share
Link copied
Microsoft Store from Microsoft StoreDownload free
Chatea por WhatsApp