A free recipe cost calculator for Excel that converts purchase units (lb, kg) to recipe units (oz, g) automatically, adjusts for ingredient trim loss (yield %), and turns the result into a food cost percentage against your menu price — download it below, or keep reading to see exactly how the formulas work and what we verified before publishing it.
Target query this answers: recipe cost calculator excel free download. Download: recipe_cost_calculator.xlsx (link below). It opens in Excel, LibreOffice Calc, and Google Sheets.
Download the Recipe Cost & Food Cost % Calculator (.xlsx)
The file has four tabs: How to Use (instructions), Ingredient Prices (what you paid, converted to a true edible-portion cost per gram), Recipe Costing (a sample 10-serving stew recipe that totals into a batch cost, cost per serving, and food cost %), and Unit Reference (the g/kg/oz/lb conversion table every formula pulls from). Replace the sample rows with your own ingredients and recipe — every number recalculates automatically. It’s the third file in a small library of verified, downloadable Excel templates on this site, alongside a tip pool calculator that balances to the cent and a free invoice tracker with AR aging for partial payments.
Why Most Free Recipe Costing Templates Get the Math Wrong
Two things reliably break a hand-built recipe costing spreadsheet, and both are unit problems, not math problems. First, most free templates don’t convert between how you buy an ingredient and how a recipe calls for it: a chef resource site that publishes multiple recipe-costing Excel templates notes plainly that its basic versions “don’t appear to offer automatic unit conversion between imperial and metric measurements” — you’re expected to do the lb-to-oz or kg-to-g math yourself, by hand, every time. Second, and more dangerous, is the classic trap of confusing weight ounces with fluid ounces. As one recipe-costing guide puts it, the most common wrong assumption is “one ‘oz means fluid ounce, right?’ and the number is garbage” — because a weight ounce of oil and a fluid ounce of oil are not the same mass, mixing them in a formula produces a cost that looks plausible but is quietly wrong.
This template fixes both. Every unit field (purchase and recipe) pulls from a four-row conversion table (g, kg, oz, lb — weight only), so lb-to-oz or kg-to-g conversion happens automatically in the formula, not in your head. And it refuses to guess: if you type a volume unit like fl oz, cup, or ml into a unit cell, the lookup fails on purpose and a visible “CHECK UNIT” warning appears instead of a silently wrong number.
How to Calculate Food Cost Percentage (the Formula)
Food cost percentage is: (cost per serving ÷ menu price) × 100. Cost per serving is the total cost of every ingredient in a batch, divided by how many servings the batch makes. In the sample recipe shipped with the file — a 10-serving beef and vegetable stew — the batch of six ingredients costs $10.35 total, or $1.03 per serving. Priced at $3.45 a bowl, that’s a food cost of 29.9%.
The part almost every template gets wrong is the “total cost of every ingredient” step: it isn’t the price you paid per pound or kilogram, it’s the true usable cost after trim loss — which is the next section.
What Is Yield Percentage, and Why Does It Change Your Real Ingredient Cost?
Yield percentage (also called trim loss or edible-portion yield) is how much of what you buy is actually usable after trimming, peeling, or deboning. The standard formula, used across culinary-math references, is: edible-portion (EP) cost = as-purchased (AP) cost ÷ (yield % ÷ 100). A recipe-costing guide gives the textbook example: tomatoes bought at $1.20/lb with a 90% yield actually cost $1.33/lb once you account for the 10% that gets trimmed away and never reaches a plate.
The template’s own sample data shows the same effect at a larger scale. Chicken breast bought at $92 for a 40 lb case, with a typical 85% trim yield, has an as-purchased cost of $0.00507 per gram — but its true edible-portion cost is $0.00597 per gram, about 17.6% higher. Skip the yield adjustment (as plenty of basic templates do, or let you forget to do) and every recipe using that ingredient understates its real cost by nearly a fifth.
| Ingredient (sample) | Yield % | AP cost / g (before yield) | EP cost / g (true cost) | Understated by |
|---|---|---|---|---|
| Chicken breast, boneless | 85% | $0.00507 | $0.00597 | 17.6% |
| Carrots, whole | 82% | $0.00174 | $0.00212 | 22.0% |
| Yellow onion | 90% | $0.00145 | $0.00161 | 11.1% |
| Whole butter | 100% (no trim) | $0.0057 | $0.0057 | 0% (none to adjust) |
Decision rule: if an ingredient has any trim, peel, bone, or fat loss, cost it at EP (yield-adjusted), never AP. If it’s a no-waste ingredient like a bagged or boxed product, yield is 100% and EP equals AP — the formula still runs, it just doesn’t change anything, which is why it’s safe to leave on every row by default rather than deciding case by case.
How to Use the Template, Step by Step
- Open the Ingredient Prices tab. For each ingredient, fill in the purchase unit (pick g, kg, oz, or lb from the dropdown), the quantity you bought, the price you paid, and the yield % (100% if there’s no trim loss).
- Check the Unit check column on the far right — it must say “OK” on every row. If it says “CHECK UNIT,” the unit you typed isn’t one of the four supported weight units.
- Open the Recipe Costing tab. List each ingredient exactly as it’s spelled on the Ingredient Prices tab, pick the unit the recipe uses (it can differ from the purchase unit — the sheet converts automatically), and enter the quantity.
- Check the Warnings cell near the bottom. It counts any row that isn’t “OK” — it must read 0 before you trust the totals below it.
- Enter your Servings and Menu price per serving in the two yellow cells. Cost per serving and Food cost % update immediately.
What We Verified — and What We Didn’t
Verified: every formula in the file was recalculated with LibreOffice Calc running headless, then the resulting values were pulled back out and checked against an independent Python calculation across edge cases: a 100%-yield ingredient, a trim-loss ingredient, a zero-quantity recipe line (must cost exactly $0.00, not blank or an error), and a deliberately unsupported unit (fl oz) worked all the way through to confirm it produces a visible warning instead of a silent wrong number — without breaking the totals for the other, valid rows. The file also carries a built-in cross-check: the batch total is computed two different ways (a column sum, and an independent SUMPRODUCT recompute), and a “Reconciliation check” cell subtracts one from the other — it must read $0.00. In our test file it does. We also scanned every cell on every sheet for raw spreadsheet error values (#DIV/0!, #REF!, #VALUE!, #N/A, #NAME?) and found none.
Not verified: the file was not opened in Microsoft Excel itself — only LibreOffice Calc’s recalculation engine. If you hit a formula quirk specific to Excel’s engine, the fix is almost always to re-enter the affected cell’s formula (copy it from an adjacent working row) rather than anything structural — if you see a raw error value like #VALUE! or #DIV/0! elsewhere in your own spreadsheet work, this site’s guide to common spreadsheet formula errors and fixes covers the most frequent causes. The yield % and prices in the sample rows are illustrative placeholders for demonstrating the formulas — they are not a verified industry-standard yield table, and real trim loss varies by supplier, cut, and your own kitchen’s prep method. Replace them with numbers from your own invoices and your own prep testing.
Does This Food Cost Calculator Work in Google Sheets?
Yes. In Google Sheets, go to File > Import > Upload, choose the downloaded .xlsx, and select “Insert new sheet(s).” All the formulas, the unit conversion table, and the dropdown data validation carry over. Re-check the Warnings cell after importing, the same way you would after editing it in Excel or LibreOffice.
What’s a Good Food Cost Percentage for a Restaurant?
There’s no single correct number — it depends heavily on segment and menu — but as a reference point, the National Restaurant Association’s 2024 data put the median food-and-nonalcoholic-beverage cost ratio at 32.0% for full-service restaurants and 32.4% for limited-service restaurants, and a 30% to 35% range is commonly used as a rule of thumb (as reported by Toast POS, fetched 2026-10-07). This is general industry context, not an audited benchmark for any specific business, and it isn’t legal or financial advice — compare it against your own menu, market, and margins before treating it as a target.