Restaurants · cafés · hotels · food trucks

Recipe costing in Excel – cost per portion, menu price and food cost %

A chicken supplier puts up his price and twenty dishes change cost overnight. Recipe costing keeps ingredient prices in one list and pulls them through every recipe and sub-recipe, so you see the new cost per portion, the food cost % and the gross profit as soon as the price is typed.

  • 200 ingredients with pack size and yield
  • 100 dishes and sub-recipes
  • Menu price from your target food cost
  • Printable recipe card
Add to basket
Recipe Costing & Menu Pricing – Dashboard

Screenshots from the file

From pack price to portion

  1. The INGREDIENTS tab: supplier, pack, pack size, price excluding VAT and yield
  2. RECIPE LINES: quantities for every dish and sub-recipe such as gravy or brown bread
  3. RECIPES: portions, VAT type, sundries allowance and suggested price
  4. RECIPE CARD: an A4 card with ingredients, costs and method

VAT types cover 9% for restaurant and catering, 0% for cold takeaway and 23% for alcohol and soft drinks – all editable.

10sheets
14allergens per dish
0macros

Allergens from the ingredients

Each ingredient carries its allergens, and ALLERGENS pulls them through recipes and sub-recipes to the dish, with menu numbers 1 to 14. Change an ingredient and the dish's allergen list follows.

Which dishes earn their place

MENU ENGINEERING compares popularity and gross profit within each menu category and sorts dishes into four groups, from stars to dishes that neither sell nor earn. PRICE UPDATE shows what new supplier prices do to every dish before you change the menu.

Questions and answers

What food cost % should I aim for?
Many restaurants work at roughly 25–35% on food, lower for desserts and sides, higher for steaks and seafood. You set the target per category.
Can sub-recipes go inside other recipes?
Yes. A sauce or dressing is costed once as a sub-recipe and used in any dish.
Is the price suggestion rounded?
Yes. Rounding rules in SETTINGS turn the calculated price into a menu price such as €14.50.

The file in numbers

  • START
  • SETTINGS
  • INGREDIENTS
  • RECIPE LINES
  • RECIPES
  • RECIPE CARD
  • ALLERGENS
  • MENU ENGINEERING
  • PRICE UPDATE
  • DASHBOARD
File format
.xlsx
Tabs
10
Capacity
200 ingredients · 100 dishes and sub-recipes · 700 recipe lines · 15 price updates
Requires
Excel 2016+ / Microsoft 365
Macros
None

Price every plate from its real cost

Add recipe costing to your basket and continue to payment.

Add to basket