All products

Calculate break-even sales with AI

See how many units, hours or projects have to sell to cover a month’s fixed costs. Compare different prices and volumes in an editable Excel workbook.

To calculate break-even sales with AI, start by choosing what counts as one sale. A studio might use an hour of editing; a shop might use a single print. With break-even-pricing you get a workbook that uses that same unit throughout. Include the studio’s software subscription in monthly costs and the cost of producing each print in the per-unit figure.

The workbook separates a fee taken as a percentage of the sale from an expense that stays the same per unit. That distinction matters when you try a discount. In the scenario table, each row is a price and each column a monthly sales volume. Read across a row to see how much volume would make a particular price workable.

What it does

  • Work out the first whole number of sales that covers monthly overheads.
  • Compare the profit on the same number of jobs at two different rates.
  • Include a marketplace percentage in every price scenario.
  • Find the volume required for a specific monthly profit.
  • Check which price leaves a target margin after variable costs and fees.

Install and use

  1. Give your agent Python with openpyxl and the figures for one product or service. Specify the percentage fee separately.
  2. State any monthly profit target and the margin you want to test. The agent generates the Excel file locally.
  3. Open it in a spreadsheet editor, change the highlighted inputs and compare the resulting monthly profits.

FAQ

Source

Made by Hearthbook Labs. Original skill: break-even-pricing, published on GitHub under the MIT licence.

View on GitHub