Break-even calculator: the number of sales that covers your costs

Fixed costs, price and cost per unit in; the units and sales needed to break even out.

Live example

The example: A candle stall at a Saturday market

Four inputs, one crossing point, the working shown

A candle stall at a Saturday market

Open the exampleThe names and numbers are made up.

What to notice

  • Under each input is what's inside it. The $600 of fixed costs is the pitch at 4 × $85, $120 of canopy and table hire, $100 for the card reader and website, and $40 of insurance.
  • The answer is 53 candles a month, given again as $954 in sales and as about 14 a Saturday.
  • Set the price to $6 and the number disappears. The page says every sale loses $0.50 and that selling more only makes the loss bigger.

The prompt that starts one like it

Make a break-even calculator as a single HTML page for [partner or adviser] to check. I'm planning [product or business]. Start it on my estimates: [fixed costs a month], [price] and [cost per unit], each with what's in it. Show the units and sales needed to break even, a chart where the cost and sales lines cross, the working, and what's left out. If the price doesn't cover the unit cost, say so plainly. It must work on a phone. Then publish it on sharable.link with a password.

Break-even is one easy division: fixed costs over what each sale leaves after its own cost. The three numbers that go into it are guesses, and a page that lets someone else move them is how you find out which one is wrong. Here a candle maker sends hers to Sam, who checks her thinking, two days before she signs for a market pitch.

Who it's for

Anyone pricing a product or sizing up a small business before the money is spent: a market stall, a food truck, an evening class, a print run. You send it to a partner, an adviser or whoever is lending you the deposit, and ask them to argue with it.

It answers one question for one product at one price. A shop with forty products at different margins needs a spreadsheet, and so does a business whose costs jump when it hires.

What a good one contains

  • Your three guesses to begin with. The sample opens on $600 of fixed costs a month, an $18 candle and $6.50 to make one. The answer is already there: 53 candles.
  • What's inside each number. Under the cost per candle: wax $2.10, jar and lid $2.40, wick and scent $1.30, label and box $0.70. A reader can't question "$6.50". They can question the jar.
  • The answer in units someone can picture. 53 a month is also $954 in sales, and about 14 each Saturday. The last of those tells you whether it's plausible.
  • Where one sale's money goes. A bar splits the $18: 36% to make the candle, 64% toward the fixed costs. That 64% is the whole calculation.
  • The crossing chart. Sales rise from zero, costs start at $600, and the lines cross at 53.
  • Expected sales, as a fourth input. At the 80 candles she hopes to sell, the stall clears $320.
  • A plain "no". When the price doesn't cover the unit cost, the page says there is no break-even instead of printing a negative number.
  • What's left out. Her own time, a $380 start-up kit, unsold stock, tax and quiet months.

Break-even isn't a wage

The usual mistake is reading break-even as success. At 53 candles the stall has paid its costs and its owner has earned nothing for four Saturdays. If the business has to pay you, put your pay into the fixed costs: add $400 a month to the sample and the answer moves from 53 candles to 87.

Then test the number you trust least. Drop the sample's price from $18 to $16 and break-even goes from 53 to 64. A two-dollar discount costs eleven more sales every month.

How to send it

With a password. Your costs and your margin are on it. Those are for a partner or an adviser to pick apart, and not for the stall next to yours.

Every page you publish gets one link that opens in any browser. You choose who can open it: anyone with the link, anyone with the password, or only the people and company domains you name, who sign in with Google or Microsoft. Change the page later and the link stays the same.

Make yours in Claude

Add the connector once, then publish from any Claude conversation and get a link to send.

Add Claude Connector

Already have the file? Upload it here.

More in strategy and finance

  • Business plan: A one-page plan an owner sends to a bank, a landlord or a partner ahead of the full version.
  • SWOT analysis: Strengths, weaknesses, opportunities and threats for one organization, each backed by evidence.
  • Gantt chart: One project's tasks as bars across weeks, with owners, milestones and a line for today.
  • Executive summary: One screen that tells executives what a longer report found and what they're being asked to decide.
  • Timeline: Dated events in order, for a history people will enjoy or a project they have to follow.
  • Org chart: Who reports to whom in a small company, with teams, open roles and what each person looks after.
  • All use cases

Keep reading