What a recipe cost sheet is
A recipe cost sheet is the calculation of what it costs you to produce a dish or a product, broken down ingredient by ingredient and including the other costs involved. Its result is the cost per portion (or per unit, or per kilo), the figure you need to set prices, decide which dishes to keep on the menu and negotiate with suppliers.
Without a cost sheet, prices are set by looking at the competition or by gut feeling. And it is very common to find that the best-selling dish is one of those that earns the least. If you want to go over the concept before calculating, read what a recipe cost sheet is.
Which costs go into a cost sheet
Direct or variable costs
- Ingredients. The weight of each one in the recipe multiplied by its purchase price. It is the easiest to allocate and the one that changes most.
- Production losses. What is lost when trimming, peeling, boning, filleting or baking. If you buy 1 kg of hake and use 650 g, the real cost of a usable kilo is quite a lot higher than the one on the invoice.
- Display waste. What is thrown out of the display case because it did not sell in time. It does not go into the recipe's cost, but it does go into the price you need to charge.
Staff costs
This is often the biggest cost in the business. To allocate it, measure the time the team spends on each product and multiply it by the cost per hour (wages plus employer contributions). Bear in mind that not all paid time is productive: cleaning, receiving goods or downtime also cost money.
Fixed or indirect costs
Rent, electricity, gas, water, insurance, maintenance, equipment depreciation, accountant. The practical approach is to work out a monthly amount and spread it over production, for example by working hours or by kilos produced.
Example: cost sheet for a cheesecake
A simplified example for a 1.2 kg cake sold as 10 portions (indicative prices, excluding VAT):
| Ingredient | Quantity | Price | Cost |
|---|---|---|---|
| Cream cheese | 600 g | €7.50/kg | €4.50 |
| Cream 35% | 250 g | €4.20/kg | €1.05 |
| Sugar | 150 g | €1.10/kg | €0.17 |
| Egg | 4 units | €0.22/unit | €0.88 |
| Biscuit and butter (base) | 200 g | €4.00/kg | €0.80 |
| Ingredients | €7.40 | ||
| Staff (20 min at €18/h) | €6.00 | ||
| Allocated fixed costs | €1.50 | ||
| Total cost of the cake | €14.90 | ||
| Cost per portion (10) | €1.49 | ||
Notice two things. First, if you only counted ingredients, a portion would come to €0.74, half the real cost. Second, staff weigh almost as much as raw materials: making two cakes at once instead of one cuts the cost per portion considerably.
How to cost a recipe step by step
- Write the recipe with exact weights, in grams, as it is actually made in the kitchen, not from memory.
- Enter the current purchase price of each ingredient, in the same unit (kilo, litre, unit).
- Apply the losses from trimming or cooking to the ingredients that have them.
- Add semi-finished products as one more ingredient, with their own cost sheet (the dough, the cream, the stock).
- Add staff and fixed costs according to the preparation time.
- Divide by the number of portions or by the final weight.
- Compare with the selling price excluding VAT and work out your margin.
When is a dish profitable?
When its price covers the full cost and leaves the margin your business needs. As a rough benchmark, restaurants usually aim for raw materials not to exceed 30-35% of the price excluding VAT, but every business is different. In pastry sold to trade customers, for example, the margin per piece is lower and is made up for with volume.
Bear in mind too that the cost sheet is not the only thing that sets the price: competition, what your customer is willing to pay and psychological pricing all count. We discuss it in how to set prices in food service.
The problem with costing in Excel: it goes out of date
With ten recipes, a spreadsheet works. With fifty recipes and twenty semi-finished products, the problems start: butter goes up, you update the base dough, but the three products that use it still carry the old cost. Margin is lost without anyone seeing it, product by product, until the month-end close.
Automatic costing solves it like this:
- You update an ingredient's price just once, by hand or by uploading the supplier's price list or invoice.
- Every recipe that uses it, including through semi-finished products, recalculates itself.
- You see instantly which products have dropped below your minimum margin, before you produce the next batch.
- You negotiate with the supplier with data: what each price rise really costs you.
How Recipok does the costing
In Recipok you create the recipe (or upload it as a photo or PDF and Recipok reads it), and the cost sheet appears on its own: ingredients with their losses, semi-finished products nested with no limit on levels, staff costs and fixed costs you set once for the whole workshop. It gives you the cost per unit, per kilo and per portion, how it changes over time and a recommended selling price based on your target margin. You will find the details in how the cost sheet is calculated, fixed and staff costs and selling price and margins, and an overview on the recipe costing page.
You can duplicate a recipe to test changes (another portion size, another ingredient) without touching the original. And the same recipe gives you the label with allergens and the technical sheet.
Also review what is not in the recipe
Once a month, take some time out of the day-to-day to look at the numbers: what sold most, what went up in price, which products lost margin. Compare each month with the same month last year, not with the previous month, so you do not mistake the season for a trend. That habit, more than any tool, is what turns a cost sheet into money. If you would rather start with a spreadsheet, there are free recipe costing templates.
