FREE TEMPLATE
Recipe Costing Template: Free Recipe Cost Card (Excel, CSV, Printable)
Free recipe costing template: an Excel recipe cost card with yield %, cost per portion and suggested menu price formulas, plus CSV and printable card.
Download Excel (.xlsx) Download CSV (Google Sheets) Printable version
Free. No signup, no email. The Excel file has working formulas and opens in Google Sheets, Numbers and LibreOffice.
How to use the recipe costing card template
- List each ingredient with what you pay (purchase cost and quantity) and how much the recipe uses, in the same unit.
- Add a yield % for trim and waste (e.g. 75% for romaine after trimming).
- Enter portions per batch, your target food cost % and menu price.
- The card returns batch cost, cost per portion, the price that hits your target and your actual food cost % at the current price.
Or calculate it right here
Same formula, live in your browser: Recipe Cost Calculator (Cost per Serving).
Formula
Ingredient cost = purchase cost ÷ purchase quantity × quantity used ÷ (yield % ÷ 100). Plate cost = total ingredient cost ÷ portions.