The problem
Flour, butter and energy prices move and a bakery's prices lag behind. If a baker re-costs 10 products a month at 20 minutes each, that's 200 minutes, 3.3 hours, and a loaf underpriced by 20p on 600 sales a month loses $160£120€143A$230C$226.
What the AI does
Ask ChatGPT, Claude or Gemini to build a costing spreadsheet: an ingredients tab with your supplier prices per kilo, and a recipe tab per product with weights, yield, packaging, labor minutes, an energy allowance and a target margin, giving cost per item and a suggested price. You type in the real prices from your invoices and check the formulas against two products you've costed by hand. The assistant writes the formulas; you decide the price. Never use it to work out allergen information.
A worked example
An independent bakery in Frome with the owner-baker and four staff, a shop counter on Square tills. The owner re-costs about 10 of 30 products a month when supplier prices change, using a sheet an assistant helped build.
Before
About 20 minutes a product by hand: 10 x 20 = 200 minutes, 3.3 hours a month
After
About 6 minutes a product updating the sheet: 10 x 6 = 60 minutes, 1 hour a month
What it's worth
About 2.3 hours a month saved (140 minutes), worth around $63£47€56A$90C$88 if your time is worth $27£20€24A$38C$38 an hour. The bigger prize is pricing correctly, such as the $160£120€143A$230C$226 a month on one underpriced loaf, which isn't counted. Free plans may be enough; ChatGPT Plus is about $27£20€24A$38C$38 a month, so $27£20€24A$38C$38 is the top of the range.
How to set it up
- List each product's recipe with weights, yield, packaging and the minutes it takes.
- Ask ChatGPT, Claude or Gemini to build a costing sheet with ingredient and recipe tabs and formulas for cost per item and suggested price.
- Enter your own supplier prices from invoices, not prices the assistant suggests.
- Check the sheet against two products you've costed by hand before trusting it.
- Update ingredient prices whenever an invoice changes, and review prices every quarter.
What goes wrong
- AI makes formula and arithmetic mistakes; test the sheet with a calculator on known products.
- Never ask it for allergen or ingredient declarations; those come from your recipes and supplier specifications, checked by a person.
- VAT on food is complicated (some bakery items are zero-rated, others not); ask your accountant rather than the assistant.
- Don't paste supplier contracts or customer details into an assistant.