Food Cost Spreadsheet

Tab 1: Ingredients

One row per ingredient. Columns: Ingredient name | Package unit | Package cost | Cost per unit (formula: package cost ÷ package size). This is your master price list — update it when suppliers change prices.

Tab 2: Recipes

One tab per dish, or one tab for all dishes with a dish-name column. For each ingredient: pull cost per unit from Tab 1 using VLOOKUP, multiply by quantity used, then sum all ingredient costs.

Tab 3: Menu Overview

One row per dish. Pull the total ingredient cost from the relevant recipe tab. Add menu price, calculate food cost %, compare to target, and flag anything over threshold.

If: Food cost % is above target

→ Check whether the menu price is too low first (a quick fix), then check whether the recipe cost has increased since you last updated ingredient prices.

If: Actual food cost % (from inventory) is higher than theoretical (from recipes)

→ The gap is waste, over-portioning, comps, or theft. Investigate portions first — use a scale on protein stations and compare plated weight to recipe spec.

If: One category is consistently above target

→ Proteins and seafood run high in most restaurants. Check yield percentages and confirm you are costing post-trim weight, not raw weight.

If: Beverages have very low food cost %

→ This is normal and by design. Beverage margin subsidizes the rest of the menu. Use it to allow slightly higher food cost on your signature dishes.

What should a food cost spreadsheet include?

A food cost spreadsheet should include at minimum: dish name, ingredient cost per portion, menu price, food cost percentage, and target food cost percentage. For full recipe-level costing, add a separate ingredient tab with per-unit costs that feed into each dish's total. For tracking actual vs. theoretical food cost, add an inventory tab with opening stock, purchases, and closing count to calculate real food cost against sales.

How do you make a food cost spreadsheet in Excel or Google Sheets?

Set up three tabs: (1) Ingredients — one row per ingredient with purchase unit, purchase cost, and cost per unit. (2) Recipes — one row per dish, with ingredient quantities pulling cost from the Ingredients tab. (3) Menu — one row per dish with ingredient cost (from Recipes), menu price, food cost percentage formula, and a flag column highlighting dishes over your target. Link the tabs with VLOOKUP or named ranges so updating one ingredient price updates every dish that uses it.

What is the food cost percentage formula for a spreadsheet?

In a spreadsheet, food cost percentage is: =ingredient_cost_cell/menu_price_cell*100. If ingredient cost is in cell C2 and menu price is in D2, enter =C2/D2*100 in cell E2 and format it as a percentage. To calculate a target menu price from a desired food cost percentage, use =ingredient_cost/target_food_cost_decimal — for example, =C2/0.30 to find the price that gives you 30% food cost.

How is a food cost spreadsheet different from a recipe costing template?

A recipe costing template focuses on one dish at a time — listing every ingredient with exact quantities, yields, and unit costs to build up a precise portion cost. A food cost spreadsheet is a menu-level overview: one row per dish, showing ingredient cost, menu price, and food cost percentage side by side across your whole menu. You typically use both: the recipe costing template to calculate each dish's ingredient cost, then the food cost spreadsheet to manage the whole menu at a glance.