Cost every drink and bake, down to the cup and the syrup

The problem

A latte's cost is more than the coffee: milk, cup, lid, sleeve and syrup add up. Costing each item shows which ones barely make money.

What AI does

AI builds a costing spreadsheet that works out what each drink and bake costs you from your invoice prices and recipes. All prices come from your own invoices, and your accountant guides how VAT is treated.

Time

The steps, in short

1. Collect your latest supplier invoices with pack sizes and prices.
2. Write down each recipe, including cups, lids and syrups.
3. Have AI build the spreadsheet and formulas from your figures.
4. Compare each item's cost with its price and decide what needs attention.

A short sample prompt

Build a costing spreadsheet for my café that works out the cost of each menu item from my invoice prices and recipes, then compares it with the selling price. Show the formulas, stick to my figures and mark gaps as [CHECK]. Data: [paste]