Food Business

Recipe Costing & Menu Engineering Template

Most food businesses guess at their margins. This template gives you exact numbers. Enter your ingredients and their per-unit costs once, build your recipes, and instantly see the true cost of every dish you serve.

When ingredient prices change — and they will — update the master ingredient list and every recipe recalculates automatically. No manual recalculation, no stale numbers.

Built for chefs, caterers, restaurant owners, and food entrepreneurs who need to price their menus with confidence, not guesswork.

Available on Etsy

Get Template on Etsy

Built for precise food cost management.

Ingredient Master List

One centralised place for all ingredients with per-unit costs. Update a price once and every recipe that uses that ingredient recalculates instantly.

Recipe Cost Calculator

Build recipes by selecting ingredients and quantities. The template calculates total ingredient cost, cost per portion, and suggested menu price automatically.

Menu Profitability Analysis

See every dish’s food cost percentage, gross margin, and contribution to overall menu profitability. Know exactly which items are carrying the menu and which are dragging it.

Menu Pricing Tool

Set your target food cost percentage and the template back-calculates the minimum menu price for each dish. Price with intention, not instinct.

Waste & Yield Factors

Account for prep waste and cooking yield so your cost calculations reflect real-world quantities, not theoretical purchase weights.

Data Validation & Protection

Dropdown selectors for ingredients eliminate typos. Protected formula cells prevent accidental overwrites while keeping all data entry areas open.

This template is built for you if…

You run a restaurant, café, or catering business and need to know your true food costs

You’re pricing a new menu and want to set prices based on real margins, not gut feel

Your ingredient costs fluctuate and you want your recipes to update automatically

You want to identify which dishes are most and least profitable on your current menu

You’re a personal chef or meal prep business calculating per-meal costs for clients

You want a food costing system that works without expensive restaurant software