HermeTronTOOLS FOR HANDMADE SELLERSThe Excel kit ↗

A LITTLE CLARITY BEFORE MARKET DAY

Will your next
craft fair pay off?

Find out how many sales cover your costs. Try the free calculator before you book your next stall.

Free to useNo account neededYour figures stay in your browser

One product, or a representative average. Use the same currency in every field.

Starting values are a fictional example. Include expected fixed transaction charges in fixed costs.

With the example numbers, you need to sell

9items

to cover your event costs

To reach your target23 items
Left per item before fixed costs10.96

This estimates surplus after the costs you enter. It excludes owner pay, income tax and unlisted overhead. It does not predict how many items will sell.

Get the free market-day checklist ↗

BEFORE THE FAIR IS ONLY HALF THE STORY

Track what actually happened.

The Craft Fair Profit Kit brings your event costs and product sales into one Excel workbook, so you can compare what remained after each fair.

  • Plan and compare up to 50 events
  • Record 200 product sales rows
  • See surplus, leftover units and surplus per hour
  • Follow a worked example and quick-start guide
Get the Excel kit · $9 USD →

One-time digital download. Desktop Microsoft Excel required. English. Google Sheets, Numbers and mobile Excel are not tested. Checkout may display local currency and applicable taxes.

Actual Excel worksheet showing event break-even calculations
A real sheet from the kit. Example figures are fictional.

A few useful answers.

How does the calculator work?

Contribution per item = price × (1 − selling fee percentage) − materials and packaging. Break-even units = fixed costs ÷ contribution, rounded up. Target units include your target surplus in fixed costs.

What if I sell several different products?

Use a representative average for planning. The Excel kit lets you enter product sales separately to calculate actual results after the event.

Is my information saved?

Your prices and costs stay in your browser. With your permission, we count visits and button clicks using a random browser identifier. We do not send your calculator inputs. Email signup is optional and handled by EmailOctopus.