Menu Pricing and Food Cost Calculator for Cafes

For café owners and coffee shop managers who want to know what every latte, sandwich and cookie really costs and earns.

Enter what you buy once: pack size in the unit you use in recipes, pack cost and usable yield (trim, cooking loss, waste). The workbook turns it into a cost per gram, millilitre or piece, with a what-if column to test a supplier price rise. Build recipes from a drop-down list (up to 200 lines; a check column flags typos), split batch bakes into portions and add packaging per portion. Menu Items shows cost per portion, food cost %, a suggested price at the target for that category (rounded up to your increment, e.g. $0.25) and gross profit per portion. Menu Engineering uses your units sold to classify each item within its category as a Star, Plowhorse, Puzzle or Dog, with a suggested action. A Recipe Card prints a costed card for any item, and the Dashboard shows theoretical food cost %, revenue and gross profit by category against target.

Included: worked-example and blank workbooks (8 sheets, 2,172 formulas) and a 5-page guide (US Letter and A4) with the worked example, the whole menu costed, menu engineering explained and a printable recipe costing sheet.

General information, not financial or tax advice. Prices are entered before sales tax.