Excel (.xlsx) — also opens in Google Sheets & Numbers
Know the true cost and margin of every drink — milk, coffee/syrup and cup included. Enter your sell price and it flags any drink with a weak margin.
Coffee margins look great until you cost the milk, the syrup, the lid and the cup. This calculator builds the true cost of every drink on your board, then shows per-drink cost, GP £, GP % and food cost % against your sell price — with a status flag on any drink whose margin is weak.
Oat milk surcharge decisions, syrup pricing, cup sizes — the sheet makes each one a number instead of a guess.
Cafés and coffee shops. If drinks are most of your revenue, drink margins ARE your business — and they deserve the same costing rigour as food. Also check your overall margin on the free GP calculator.
Try the numbers first, free: the food cost & GP calculator and the recipe costing tool run in your browser.