# Recipe costing spreadsheet: ingredients, batch yield and portion cost

Put each ingredient in a consistent base unit, multiply recipe quantity by its usable unit cost, add the ingredient costs and divide by the actual number of portions

> Put each ingredient in a consistent base unit, multiply recipe quantity by its usable unit cost, add the ingredient costs and divide by the actual number of portions. Separate ingredient contribution from net profit and recalculate when prices or batch yield change.

Kivloo editorial team · 2026-11-12T07:01:00.072Z

## Define the measurement

Keep one recipe version, one output definition and one costing date. State whether ingredient quantities are purchased or usable quantities; if a usable unit cost already includes preparation loss, do not divide by the same yield again. Match kilograms to prices per kilogram and litres to prices per litre. Supplier packaging is a purchase constraint, not the recipe quantity used in one batch.

[BCcampus · Controlling Food Costs](https://opentextbc.ca/basickitchenandfoodservicemanagement/chapter/controlling-food-costs/)

## Example record and review decision

Fictional batch: 2 kg tomatoes at €3/kg cost €6; 1 kg beans at €4/kg costs €4; 0.10 litres oil at €8/litre costs €0.80. Total ingredient cost is €10.80. A verified output of 12 portions gives €0.90 per portion. The example prices are stated on a consistent tax-exclusive basis; adapt your own accounting treatment instead of mixing incomparable prices.

## Check the result and its limits

At a €6 selling price on the same stated basis, ingredient cost is 0.90 ÷ 6 = 15%, and the amount left after ingredients is €5.10. That amount is not net profit: labour, energy, rent, payment fees, other expenses and applicable tax treatment still matter. If the same batch produces only 10 portions, cost becomes €1.08 and ingredient cost 18%. Do not keep the 12-portion denominator after measuring a smaller output.

## Choose the next action

Change one driver at a time when investigating an increase: supplier price, quantity used, usable yield or portion count. Preserve the old recipe version and observation rather than overwriting history. An unexplained gap between recipe cost and recorded food cost needs inventory and sales reconciliation; increasing menu price is not the only possible response and is not justified by an unverified spreadsheet alone.

[Restaurant food cost calculator: stock, transfers and sales](https://kivloo.com/en/guides/restaurant-food-cost-calculator)

[Actual vs theoretical food cost: reconcile the gap without counting waste twice](https://kivloo.com/en/guides/actual-vs-theoretical-food-cost-reconciliation)

## Use the downloadable record

Download the ingredient CSV and the paired output examples. It includes the three ingredient lines, a batch total, a 12-portion baseline, a 10-portion stress case and blank records. It stores plain numbers rather than automatic formulas. Recalculate after editing, keep units visible and refuse a zero portion count. Compare the batch total against the sum of its ingredient lines before using the portion result.

## Check the workflow in Kivloo

Kivloo's procurement beta connects saved recipe documents to structured ingredients and finished planning items. Production uses recorded eligible lots and their costs; the manual worksheet does not claim exact parity with every product rule or live profit accounting. Set up the recipe on the web and check quantities and yield before recording production. An active connection is required, and purchasing approval remains an internal step with separate supplier dispatch.

[Restaurant procurement software: what to test before you buy](https://kivloo.com/en/guides/restaurant-procurement-software)

[Kivloo · Procurement beta](https://kivloo.com/features#mobile-procurement)

## Recipe costing spreadsheet: ingredients, batch yield and portion cost

Worked example

| Batch cost | Portions | Portion cost | Ingredient cost |
| --- | --- | --- | --- |
| €10.80 | 12 | €0.90 | 15% |

[Download the worked CSV](https://kivloo.com/worksheets/recipe-costing-spreadsheet-en.csv)

## Does the CSV recalculate after editing?

No. It contains plain worked values and a blank record. Recalculate after changing inputs, keep units consistent and verify the result before using it.

## Are the examples measured business results?

No. They are fictional planning examples with explicit assumptions, not evidence of savings or a guaranteed outcome.

## Continue reading

- [Restaurant food cost calculator: stock, transfers and sales](https://kivloo.com/en/guides/restaurant-food-cost-calculator)

- [Actual vs theoretical food cost: reconcile the gap without counting waste twice](https://kivloo.com/en/guides/actual-vs-theoretical-food-cost-reconciliation)

- [Restaurant procurement software: what to test before you buy](https://kivloo.com/en/guides/restaurant-procurement-software)

- [Food batch traceability: connect deliveries, ingredients and finished products](https://kivloo.com/en/guides/food-batch-traceability-records)

- [Food yield percentage: calculate the cost of a usable portion](https://kivloo.com/en/guides/food-yield-percentage-usable-portion-cost)

- [Digital HACCP records: build a temperature log your team can actually use](https://kivloo.com/en/guides/digital-haccp-temperature-records)

## Sources and further reading

- [BCcampus · Controlling Food Costs](https://opentextbc.ca/basickitchenandfoodservicemanagement/chapter/controlling-food-costs/)

- [Kivloo · Procurement beta](https://kivloo.com/features#mobile-procurement)

Operational guidance, not a certification or a legal assessment. Adapt examples to your site, approved procedures and local requirements. Product links lead to the English website; this guide does not imply a fully translated application or verified hardware compatibility.

Canonical: https://kivloo.com/en/guides/recipe-costing-spreadsheet-portions-yield