A sub-recipe is something you make in its own batch and then use as an ingredient: a caramel sauce, a pie dough, a spice blend, a stock. It has its own recipe, its own yield and its own cost. The way to handle it is to cost it once, as a batch, weigh what the batch actually makes, and turn that into a cost for 100 grams. Then every recipe that uses it carries one line: so many grams of caramel at so much. In the example below, a batch of salted caramel costs $8.95 and yields 1,650 g, which is 54 cents for 100 g. A latte takes 11 cents' worth, a pan of brownies $1.63, and a jar for the shelf $1.23. Below are the sums and a template.
The short version
- A sub-recipe gets its own sheet: ingredients, amounts, cost.
- Weigh the finished batch. Yield is what came out, not what went in.
- Cost of 100 g = batch cost ÷ yield × 100.
- In each recipe that uses it, write grams used and multiply.
- Its allergens travel with it into everything.
- TaroStack lets a recipe contain other recipes and costs them all from what you paid. More below.
Step 1: cost the batch
A made-up cafe's salted caramel sauce.
| Ingredient | Amount | You pay | For this much | Cost in the batch | Contains |
|---|---|---|---|---|---|
| Granulated sugar | 1,000 g | $8.50 | 4,536 g | $1.87 | |
| Heavy cream | 600 g | $5.40 | 950 g | $3.41 | Milk |
| Butter, unsalted | 200 g | $4.80 | 454 g | $2.11 | Milk |
| Vanilla extract | 15 g | $12.00 | 118 g | $1.53 | |
| Sea salt | 10 g | $3.10 | 1,361 g | $0.02 | |
| Batch | 1,825 g | $8.95 | Milk |
Step 2: weigh the yield
The ingredients add up to 1,825 g. The finished caramel weighs 1,650 g. Sugar cooked to amber and cream boiled down both lose water, and some sauce stays on the pan.
| Batch cost | $8.95 |
| Yield, weighed | 1,650 g |
| Cost of 100 g | $0.54 |
Use 1,825 g and you'd get 49 cents, 10% too low, in every product the caramel goes into. Weigh three batches and use the average. This is the step most costings skip.
Step 3: use it
| Used in | Grams | Cost of the caramel |
|---|---|---|
| Caramel latte | 20 g | $0.11 |
| Caramel brownies, a pan | 300 g | $1.63 |
| 8 oz jar for retail | 227 g | $1.23 |
Each of those recipes now has one line for caramel. When butter goes up, you recost the sub-recipe once and all three follow. Without it, you'd be finding and changing "sugar, cream, butter, vanilla, salt" in three places and missing one.
One batch makes 82 lattes, or five pans of brownies with a little over, or seven jars. Knowing that tells you how often to make it.
What else belongs on the card
| Line | Example | Why |
|---|---|---|
| Yield | 1,650 g | The costing depends on it |
| Keeps | 14 days refrigerated (this cafe's limit) | A sub-recipe is made ahead; it needs a date |
| Allergens | Milk | Everything made with it contains milk |
| Batch code | CAR-1118 | So a brownie can be traced to its caramel |
| Method | Steps, temperatures | It's a recipe |
Allergens travel. The caramel contains milk, so the latte, the brownie and the jar all do, whatever else is in them. Sub-recipes are where allergens hide: a spice blend with mustard, a stock made with celery, a dough brushed with egg. Write what each sub-recipe contains on its card, and carry it into the chart: see allergen matrix template.
Dates travel too. Brownies made today with caramel from twelve days ago are only as fresh as the caramel. Put the batch code and date on the container.
How deep to go
A sub-recipe can use another sub-recipe: brownies use caramel, and a brownie sundae uses brownies. Two levels are manageable on paper. Past that, the spreadsheet becomes a chain of sheets that one mistyped cell breaks.
Don't make everything a sub-recipe. The test: is it made in its own batch, kept, and used in more than one thing? A vinaigrette used in four salads, yes. Salt and pepper mixed for one dish, no.
The full card for a recipe is in standardized recipe template. Scaling a sub-recipe up is in recipe multiplier calculator, and carrying costs through to a menu price in menu costing template.
Get the template
Download the sub-recipe template. Two sheets and a read-me: the recipe, where each ingredient's cost works itself out, and a yield-and-use sheet that gives the cost of 100 g and of the amount each product takes. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Copy the file for each sub-recipe.
Where this stops working
Ten sub-recipes feeding thirty products is forty sheets with links between them. Butter goes up. In principle you change one price and everything follows. In practice the butter price is typed into six of those sheets, and four get updated. A month later two costings for the same brownie disagree and nobody knows which is right.
How TaroStack does it
TaroStack keeps one price for butter and lets recipes nest.
A recipe can contain other recipes. Caramel is a recipe. The brownie's recipe has a line for 300 g of it.
The sub-recipe is made as its own batch. Record it and it's in stock, with a lot code and a date, as an ingredient. Use it in a batch of brownies and the batch record notes which lot of caramel went in.
Yield from real batches. Each batch records what came out. Recipe truth shows whether the sub-recipe really yields what its recipe claims.
One price, everywhere. Each ingredient's cost comes from what you paid. When butter moves, the caramel moves, and so does everything made with it.
Allergens are checked. On Growth, with allergen tracking on, a batch can't start if its label leaves out an allergen its ingredients contain. The caramel is one of those ingredients.
| The job | Linked spreadsheets | In TaroStack |
|---|---|---|
| Butter went up | Find every sheet | One price; every recipe follows |
| Real yield of the caramel | Weigh and retype | Recipe truth |
| Which caramel is in these brownies | Unknown | On the batch record |
| Does the brownie's label say milk? | Trace it by hand | Checked before the batch starts (Growth) |
Recipes with sub-recipes are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). A sub-recipe is a recipe like any other, so a kitchen with several wants the 50. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
