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:
- 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.
- Weigh as purchased. Record the total weight and total invoice cost.
- Prep and cook as usual. Let the cook who normally does the job do it, at normal speed.
- Weigh the usable output. Only what goes on plates counts. If bones go into stock, note that separately.
- Calculate. Yield % = usable weight ÷ purchased weight. Usable cost per kg = total cost ÷ usable weight.
- 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.
- 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.
- 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.
- 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).
- 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.