F&B Operations

Recipe Costing Template for Restaurants (With Worked Examples)

A recipe card tells you what one plate really costs, down to the garnish and the takeaway box. Here is a template you can copy, the yield maths behind it, and three worked Singapore examples.

Chef weighing an ingredient on a kitchen scale

Key takeaways

  • A recipe costing template needs seven columns: ingredient, purchase unit, purchase price, yield %, usable cost per unit, quantity per portion and cost per portion.
  • Yield % is where most recipe cards go wrong. A whole chicken bought at $6.00/kg can cost well over $10/kg once bones, skin and cooking loss are removed.
  • Cost sauces, stocks, rempah and cooked rice as sub-recipes, then use their cost per kg or litre as a single line on the main card.
  • Add garnish, condiments and, for takeaway and delivery, packaging. They are small per plate but add up across a month.
  • Re-cost cards when a supplier price changes. A POS with recipe-level costing does the arithmetic for you once the recipe is set up.

All prices in this article are hypothetical and chosen to keep the maths readable. They are not market prices. Use your own supplier invoices.

If you are new to food cost percentage, start with our guide to restaurant food cost in Singapore, which covers the period formula and targets. This article goes one level deeper: how to build the recipe card for each dish so you know the cost of a single plate before you set its price.

What a recipe costing template does

A recipe costing template, sometimes called a recipe card or plate cost sheet, lists every ingredient in one portion of a dish, how much of it goes on the plate, and what that quantity costs after trimming and cooking loss. Add the lines and you have the cost per portion, the number that drives menu pricing, promotions and delivery pricing.

The card does three jobs:

  • Pricing. You cannot price a dish with confidence if you only know what the whole kitchen spent last month.
  • Consistency. The quantities on the card are the portion standard your cooks follow. If the card says 100g of chicken, that is what goes on the plate.
  • Variance checks. When stock usage is higher than sales say it should be, the recipe card is the benchmark you compare against. Our food cost variance guide explains the calculation. Our stock take guide covers how to count and compare.

The template: columns and what goes in each

Copy this layout into a spreadsheet, one tab per dish. The formulas are shown so you can rebuild it in any tool.

Column What to enter Formula or source
A. Ingredient Name and spec, e.g. “Whole chicken, fresh, 1.4–1.6kg” Your supplier’s item name
B. Purchase unit The unit you buy in: kg, litre, pack of 10, 640ml bottle Supplier invoice
C. Purchase price Price per purchase unit Latest supplier invoice
D. Cost per base unit Price per kg, litre, ml, gram or piece C ÷ number of base units in B
E. Yield % Share of the purchased weight that ends up usable on the plate Your own yield test (see below)
F. Usable cost per unit What each usable kg, ml or piece really costs D ÷ E
G. Quantity per portion Usable quantity on one plate, in the same base unit as F Portion standard
H. Cost per portion Cost of that line on one plate F × G

Below the ingredient lines, add four rows: garnish and condiments, takeaway packaging (if the item is sold for takeaway or delivery), total cost per portion, and date costed. The date matters more than it looks. A card that has not been updated since last year is a guess.

A note on GST: if your business is GST-registered and claims input tax, cost ingredients at prices before GST; if you are not registered, the GST you pay is part of your cost, so include it. Check the approach with your accountant and keep it the same on every card. Our GST registration guide explains when registration applies.

Yield %: the column that changes everything

Yield % is the usable weight divided by the purchased weight. Very few ingredients are 100% usable. Chicken loses bones, skin and moisture. Prawns lose heads and shells. Herbs lose stems. Milk is left in the steaming jug. If you cost these at the purchase price, every card is understated.

The formula for usable cost is simple: usable cost per unit = purchase cost per unit ÷ yield %. At a 55% yield, chicken bought at $6.00/kg costs $6.00 ÷ 0.55 = $10.91 per usable kg. A 100g portion costs $1.09, not the $0.60 you would get from the invoice price.

There are two kinds of loss to capture:

  • Trim loss: what is removed before cooking, such as peel, shells, stems and fat.
  • Cooking loss: weight lost in the pot or on the grill through moisture and fat. Poached chicken, braised meats and roasts all shrink.

For some items the weight goes the other way. Dry rice and dried noodles absorb water, so it is easier to cost them as a sub-recipe per cooked kg than to use a yield above 100%.

How to run a yield test

Do not copy yield figures from the internet. Your supplier’s birds, your butcher’s cut and your cooks’ technique all differ. A yield test takes one prep session:

  1. Buy a normal batch. Use the same supplier and spec you order every week. Test more than one unit to smooth out variation, for example ten chickens rather than one.
  2. Weigh as purchased. Record the total weight and total invoice cost.
  3. Prep and cook as usual. Let the cook who normally does the job do it, at normal speed.
  4. Weigh the usable output. Only what goes on plates counts. If bones go into stock, note that separately.
  5. Calculate. Yield % = usable weight ÷ purchased weight. Usable cost per kg = total cost ÷ usable weight.
  6. Repeat and record. Test again after a supplier or spec change, and a few times a year anyway.

Hypothetical example: ten whole chickens weigh 16.0kg as purchased and cost $96.00. After poaching and deboning, the usable meat weighs 8.8kg. Yield is 8.8 ÷ 16.0 = 55%, and usable cost is $96.00 ÷ 8.8kg = $10.91/kg. That is the figure used in the chicken rice example below.

Sub-recipes: sauces, stocks, rempah and cooked rice

Many Singapore dishes rely on batch components: chilli sauce, ginger paste, laksa gravy, sambal, braising liquid, cooked rice. Rempah-heavy menus lean on this most; see our guide to opening a Peranakan restaurant. Cost each of these once as a sub-recipe with its own card, then divide the batch cost by the batch yield to get a cost per kg or litre. On the main card, the sub-recipe becomes one line.

Here is a hypothetical sub-recipe for chicken rice (the cooked rice itself):

Ingredient (hypothetical prices) Quantity Cost
Jasmine rice, raw ($2.50/kg) 2.0kg $5.00
Garlic, shallot, ginger, pandan Batch $1.50
Chicken fat and oil Batch $1.20
Salt and seasoning Batch $0.20
Batch cost $7.90
Batch yield (cooked rice, weighed) 5.0kg
Cost per cooked kg $1.58

Weigh the finished batch rather than estimating it. Reductions and stocks lose volume on the stove; rice gains weight. When an input price changes, update the sub-recipe and every dish that uses it picks up the new cost.

Worked examples: three Singapore dishes (hypothetical prices)

The three cards below use the template above. Every price is invented for illustration.

Example 1: chicken rice

A dine-in plate of steamed chicken rice with chilli, ginger, dark soy, cucumber and a small bowl of soup. For the stall side of this dish, see our chicken rice stall guide. All prices are hypothetical.

Ingredient Purchase unit and price Yield % Usable cost per unit Qty per portion Cost per portion
Whole chicken kg, $6.00 55% $10.91/kg 100g $1.09
Chicken rice (sub-recipe) cooked kg, $1.58 100% $1.58/kg 200g $0.32
Chilli sauce (sub-recipe) 1.5kg batch, $12.00 100% $8.00/kg 30g $0.24
Ginger paste (sub-recipe) 0.8kg batch, $6.00 100% $7.50/kg 20g $0.15
Dark soy sauce 640ml bottle, $4.00 100% $0.00625/ml 10ml $0.06
Cucumber kg, $3.00 85% $3.53/kg 30g $0.11
Coriander (garnish) 100g bunch, $2.00 70% $0.029/g 3g $0.09
Soup (sub-recipe, from poaching stock) per bowl n/a n/a 1 bowl $0.15
Total, dine-in $2.21
Takeaway box, 3 sauce cups, bag $0.18 + $0.09 + $0.05 $0.32
Total, takeaway $2.53

Two points stand out. The chicken is half the plate cost, so its yield and portion size matter most. And the takeaway version costs 32 cents more, about 14% above the dine-in cost, before any delivery platform commission.

Example 2: laksa

A bowl of curry laksa with thick bee hoon, prawns, fishcake, tau pok, cockles, bean sprouts, half an egg, sambal and laksa leaf. The gravy is a sub-recipe: rempah, coconut milk, stock and dried shrimp cooked in a 10-litre batch costing $36.00 (hypothetical), so $3.60 a litre.

Ingredient Purchase unit and price Yield % Usable cost per unit Qty per portion Cost per portion
Laksa gravy (sub-recipe) 10L batch, $36.00 100% $3.60/L 400ml $1.44
Thick bee hoon, wet kg, $2.40 100% $2.40/kg 150g $0.36
Prawns, whole kg, $16.00 50% $32.00/kg 40g peeled $1.28
Fishcake kg, $10.00 100% $10.00/kg 30g $0.30
Tau pok pack of 10, $3.00 100% $0.30 each 1 piece $0.30
Cockles, in shell kg, $8.00 25% $32.00/kg 20g meat $0.64
Bean sprouts kg, $2.50 90% $2.78/kg 40g $0.11
Egg tray of 10, $3.60 100% $0.36 each half $0.18
Sambal (sub-recipe) kg, $8.00 100% $8.00/kg 15g $0.12
Laksa leaf (garnish) 50g bunch, $1.50 60% $0.05/g 2g $0.10
Total, dine-in $4.83

Here the proteins with low yields, prawns and cockles, cost more than the gravy even though they weigh far less. If prawn prices rise, this dish’s cost moves quickly. It is also a good candidate for a modifier: “no cockles” should arguably not be free if you swap in extra prawns.

Example 3: café latte

A 12oz hot latte with a double shot. Drinks are where small wastage adds up: grinder purges, dialling in each morning and milk left in the jug.

Ingredient Purchase unit and price Yield % Usable cost per unit Qty per portion Cost per portion
Espresso beans kg, $38.00 95% $40.00/kg 18g $0.72
Fresh milk 2L, $3.20 90% $0.00178/ml 220ml $0.39
Sugar sachet box of 100, $2.00 100% $0.02 each 1 $0.02
Total, dine-in $1.13
Takeaway cup, lid, sleeve $0.12 + $0.05 + $0.04 $0.21
Total, takeaway $1.34

Now cost the modifier. Oat milk at a hypothetical $4.50 a litre, with the same 90% yield, costs $1.10 for 220ml, which is $0.71 more than dairy. If your oat milk surcharge is lower than that, every oat latte earns less than a dairy one. Cost each paid modifier as its own mini card: extra shot, syrup, oat milk, add egg, upsize.

Garnish, condiments and packaging: the lines people skip

A sprig of coriander, a dish of cut chilli, a packet of tissue, a sauce cup: each costs a few cents. Across thousands of plates a month, a few cents per plate becomes a real number. Put them on the card:

  • Garnish: herbs, fried shallots, spring onion, lime. Cost them with a realistic yield, since herbs lose stems and wilt.
  • Condiments served by default: chilli, soy, sambal, pickles. If refills are free, estimate an average rather than one portion.
  • Takeaway and delivery packaging: box, lid, sauce cups, cutlery, bag, sticker. Keep a separate takeaway card or a packaging line that applies only to takeaway orders.

If packaging is a large share of the takeaway cost, it may justify a different takeaway price or a packaging charge. Our food waste guide covers the waste side of garnish and prep.

Updating costs when supplier prices change

A recipe card is only as good as its last update. Set a routine:

  • Every invoice: check the price of your top ten ingredients by spend against the price on your cards. Update when the change is material to you, for example a few percent.
  • Monthly: re-cost the dishes that use anything that moved, including via sub-recipes.
  • Quarterly: re-run yield tests on your biggest proteins and review portion sizes against what the kitchen actually plates.

Hypothetical example: if whole chicken rises from $6.00 to $6.90/kg, the usable cost at 55% yield goes from $10.91 to $12.55/kg, and the chicken line rises from $1.09 to $1.25. The dine-in plate moves from $2.21 to $2.37. That is small on one plate and noticeable across a month of sales, which is why the date-costed row belongs on every card.

Unit conversion causes many errors: buying by the carton, storing by the kg and plating by the gram. Keep one base unit per ingredient on the card and convert once, at the top.

From cost per portion to menu price

Once you know the cost per portion, pricing becomes a decision rather than a guess. Our menu pricing strategy guide covers cost-plus, competitor and value-based methods, and delivery pricing, so we will not repeat them here. Two points specific to recipe cards:

  • Price takeaway and delivery from the takeaway card, which includes packaging, not from the dine-in card.
  • Look at cash margin, not just percentage. The laksa above costs more than twice the chicken rice, so it may earn more cash per plate even at a higher food cost percentage. Our profit margin guide explains how plate costs roll up into outlet margin.

The menu costing formula at a glance

Food costing and menu costing come down to three lines. If you want a simple menu cost calculator, put these in the last columns of the template:

  • Ingredient line cost = quantity on the plate × (purchase cost per unit ÷ yield %)
  • Cost per portion = sum of every ingredient, garnish and packaging line
  • Food cost % = cost per portion ÷ selling price before GST and service charge × 100

To test a price, work backwards: divide the cost per portion by the food cost percentage you are aiming for. Re-run the calculator whenever a supplier changes a price.

Recipe costing in your POS

A spreadsheet works for a small menu. It gets harder when you have dozens of items, modifiers and sub-recipes, and prices that change every week. A POS that links recipes to sales helps in two ways.

Recipe-level stock deduction. In ChaChaCha, each menu item can carry a recipe, and each sale deducts the ingredients in that recipe from stock. Theoretical usage then comes straight from sales, so your stock take shows the gap between what should have been used and what was used.

Recipe costing per menu item. ChaChaCha calculates the cost of each menu item from its recipe, so you can see cost per item next to its selling price in one place, and use reports to see which items sell.

How purchase units convert to recipe units, how sub-recipes are set up, and how cost updates flow from supplier prices vary between systems. Ask us to confirm how these work in ChaChaCha for your menu during a demo, and get the same answers in writing from every vendor you compare, including us. Our inventory management page and restaurant inventory software comparison cover the wider picture. ChaChaCha packages are quote-based; see our grant page for EDGE Grant support, or contact us for a quote.

Common recipe costing mistakes

  • Using purchase price without yield. The single biggest cause of understated plate costs.
  • Estimating portions instead of weighing them. Weigh ten real plates at service and average them.
  • Forgetting oil, seasoning and the fryer. Put a small “cooking oil and seasoning” line on each card, based on monthly usage divided by covers.
  • No takeaway card. Packaging goes uncosted and delivery prices are set too low.
  • Uncosted modifiers. Add-ons and swaps are priced by feel.
  • Cards that are never updated. Add the date costed and review on a schedule.

Building the template in Excel or Google Sheets

One workbook with three kinds of tab keeps every price in one place, so a supplier change updates all your cards at once. The formulas below work in both Excel and Google Sheets.

  1. Prices tab. One row per ingredient: name (column A), purchase unit (B), purchase price (C), base units per purchase unit (D), yield % (E) and date updated (H). Cost per base unit in F is =C2/D2, and usable cost in G is =F2/E2.
  2. Sub-recipe tabs. Cost each sauce, stock or rice batch, divide the batch cost by the weighed batch yield, and add the result to the Prices tab as an ingredient with 100% yield.
  3. Dish tabs. Pick the ingredient in column A from a drop-down list built from the Prices tab (data validation). Pull its usable cost into B with =VLOOKUP(A2,Prices!A:G,7,FALSE), enter the quantity per portion in C, and line cost in D is =B2*C2. Total cost is =SUM(D2:D20).
  4. Price check. Add a selling price before GST and food cost % as total cost divided by price, formatted as a percentage.

Keep one base unit per ingredient, protect the formula cells so staff only edit quantities and prices, and show the oldest date updated on each dish tab so stale cards stand out. For targets and period food cost, see our guide to restaurant food cost in Singapore.

Web Admin

Written by Web Admin

Frequently asked questions

What should a recipe costing template include?

At minimum: ingredient, purchase unit, purchase price, cost per base unit, yield %, usable cost per unit, quantity per portion and cost per portion. Below the ingredient lines, add garnish and condiments, takeaway packaging if relevant, the total cost per portion and the date the card was last costed, so you know when it needs updating.

How do I calculate yield percentage for an ingredient?

Weigh a normal batch as purchased, prep and cook it the way your kitchen normally does, then weigh only the usable portion that goes on plates. Divide usable weight by purchased weight. For example, 8.8kg of usable chicken from 16.0kg purchased is a 55% yield. Test several units, not one, and repeat after supplier changes.

Should I cost sauces and stocks separately?

Yes. Cost each batch item, such as chilli sauce, laksa gravy, sambal or cooked rice, as a sub-recipe. Divide the batch cost by the weighed batch yield to get a cost per kg or litre, then use that as one line on each dish card. When an input price changes, you only update the sub-recipe.

Do I include GST in ingredient costs?

It depends on your GST status. If you are GST-registered and claim input tax on purchases, cost ingredients at prices before GST. If you are not registered, the GST you pay is part of your cost, so include it. Agree the approach with your accountant and apply it consistently across every recipe card.

How often should I update recipe costs?

Check your biggest ingredients by spend against each new invoice, re-cost affected dishes and sub-recipes monthly, and re-run yield tests on major proteins a few times a year or after a supplier or spec change. Keep a date-costed row on every card so you can see which cards are out of date.

Can a POS do recipe costing for me?

Some can. ChaChaCha supports recipe-level stock deduction, where each sale deducts ingredients by recipe, and recipe costing per menu item. How purchase units convert to recipe units and how sub-recipes are set up differ between systems, so ask each vendor, including us, to confirm these details for your menu in writing.

Is there a free recipe costing template in Excel or Google Sheets?

You can build one free in a few minutes from the column layout on this page: ingredient, purchase unit, purchase price, cost per base unit, yield %, usable cost, quantity per portion and cost per portion. The same formulas work in Excel and Google Sheets. Keep one tab per dish and a separate price list tab, so updating one supplier price flows through every card that uses that ingredient.

Should labour be included in recipe cost?

Usually not. A recipe cost card shows ingredient, garnish and packaging cost per portion, which gives you food cost. Labour is tracked separately and combined with food cost as prime cost for the whole outlet. The exception is a make-or-buy decision: when comparing a ready-made sauce with your own, add the prep time at your hourly labour cost to see which is really cheaper.

How do I cost a set meal or combo?

Add up the cost per portion of each component from its own card, then add any extra packaging or garnish the set includes. A hypothetical lunch set of chicken rice at $2.21, a drink at $0.35 and a dessert at $0.40 costs $2.96. Divide that by the set price before GST to get its food cost percentage, and check the bundle discount still leaves an acceptable cash margin.

What is the difference between recipe cost and menu price?

Recipe cost is what the ingredients, garnish and packaging in one portion cost you; menu price is what the guest pays. The gap has to cover labour, rent, utilities and profit. Food cost percentage links the two: cost per portion divided by the selling price before GST and service charge, times 100. A dish costing $2.21 that sells for $6.00 before GST has a food cost of about 37%.

See ChaChaCha running in your business

Book a 20-minute walkthrough. We'll set up your menu or catalogue and your payments so you can see how it would run on day one.