Recipe Costing & Food Cost Calculator: Excel & Google Sheets Template for Chefs
Know exactly what every plate costs, and what to charge for it.
RECIPE COSTING & FOOD COST % · EXCEL & GOOGLE SHEETS · by a professional chef
• Ingredient database (200 rows): supplier, pack size, pack price ex VAT, usable yield % after trimming and cooking. Cost per usable kg / L / piece is calculated for you.
• 3 recipe cards (duplicate the tab for more): pick ingredients from a dropdown, type net quantities in g, ml or pieces.
• Scales any recipe to the portions you need.
• Gross quantity to buy for every line (net ÷ yield).
• Cost per portion with a buffer for seasoning, oil and waste.
• Suggested menu price from your target gross margin, with VAT (Belgium 6/12/21% preset, change it for your country).
• Actual food cost % and gross profit per portion, with an on-target check.
• Menu summary tab: all recipe cards side by side.
EUR by default with a currency switch · metric units · protected formulas (no password) · Instructions tab · worked example.
You get: 1 .xlsx file + START HERE guide (PDF). Instant download. Part of the Chef's Kitchen Spreadsheet Toolkit (4 templates, save 34%).