Preview

Recipe costing card preview

Download (Excel)

File VersionFormat Size Download
XLSXFood cost calculator – blank (3 recipe sheets + summary) BlankExcel (XLSX) 12.5 KB Download
XLSXFood cost calculator – with examples (burger, salad, pasta) ExampleExcel (XLSX) 13.3 KB Download
PDFPrintable recipe costing card Blank, for printingPDF 2.4 KB Download

The workbook has a Menu summary sheet, one sheet per recipe and a Target food cost reference sheet. Copy a recipe sheet to add more dishes. To use it in Google Sheets, upload the .xlsx to Google Drive and open it with Google Sheets — all formulas keep working.

How to calculate food cost percentage

  1. Unit cost = purchase price ÷ units per purchase (for example a $6.00 pack of 8 buns = $0.75 per bun).
  2. Ingredient cost = unit cost × quantity used ÷ yield %. Yield accounts for trimming and waste: if you lose 15% of a lettuce head, the yield is 85%.
  3. Cost per portion = total recipe cost ÷ number of portions.
  4. Food cost % = cost per portion ÷ menu price × 100.

Example: burger costing

The example file costs a classic cheeseburger with fries: 1/3 lb of beef, a brioche bun, two slices of cheddar, lettuce, tomato, pickles, sauce and 0.4 lb of fries. The template adds up each ingredient, shows the food cost % at the current $14.50 menu price, and suggests the price for a 30% target. Two more examples — a chicken Caesar salad and a 4-portion spaghetti marinara — show how portions and yield work.

Target food cost by restaurant type

Restaurant typeTypical food cost %
Quick service / fast food25–30%
Fast casual28–32%
Casual dining28–35%
Fine dining30–38%
Pizza20–28%
Coffee shop / bakery20–30%

These are common rules of thumb; check your own numbers monthly with an inventory count.