To scale a recipe for production, first turn it into grams by weighing every ingredient once, because cups and spoons don't scale reliably. Then work out the scale factor from the yield you need: units wanted × weight per unit, plus a little for loss, divided by the recipe's total weight. Multiply every ingredient by it, split the result into mixes your mixer can hold, and test at a small multiple before the full batch, because mixing, baking and cooling don't all scale the way arithmetic does. Below is a home cookie recipe taken from 24 cookies to 480, step by step, and a free calculator.
The short version
- Weigh every ingredient of the home recipe in grams. Your cup, your scoop, once.
- Write each ingredient as a percentage of the flour (or of the main ingredient). That's the formula.
- Scale factor = (units × grams per unit ÷ (1 − loss)) ÷ the recipe's total weight.
- Size the batch to the mixer by weight, not by how full the bowl looks.
- Keep salt, leavening and yeast exact. Round the big ingredients, not the small ones.
- Test at 2× or 5×, then full size, and write down what changed.
- TaroStack keeps the production recipe by weight, versioned, and checks it against what batches really yield. More below.
Step 1: weigh the home recipe
Windward Roots, the made-up taro business I use in these examples, makes macadamia taro cookies. The home recipe makes 24 cookies and is written in cups. The first job was to make it once, weighing everything:
| Ingredient | Home amount | Weighed |
|---|---|---|
| Bread flour | 2 1/4 cups | 285 g |
| Butter | 1 cup | 227 g |
| Sugar | 1 cup | 200 g |
| Macadamia nuts, chopped | 1 cup | 135 g |
| Taro paste | 1/2 cup | 130 g |
| Eggs | 2 large | 100 g |
| Salt | 1 tsp | 6 g |
| Baking soda | 1 tsp | 5 g |
| Total | 1,088 g |
That's 45 g of dough a cookie. Weigh your own rather than borrowing anyone's conversions: a cup of flour scooped from the bag and a cup spooned in and levelled can differ by a fifth, and over 20 batches that's the difference between a cookie and a cracker.
Step 2: write it as percentages
Divide every ingredient by the flour:
| Ingredient | Baker's % |
|---|---|
| Bread flour | 100% |
| Butter | 79.6% |
| Sugar | 70.2% |
| Macadamia nuts | 47.4% |
| Taro paste | 45.6% |
| Eggs | 35.1% |
| Salt | 2.1% |
| Baking soda | 1.8% |
These percentages are the recipe now. They don't care whether you're making 24 cookies or 2,400, and when you change something, say a little less sugar, you change one percentage and every size of batch follows. For something without flour, a sauce or a filling, use the main ingredient as 100% instead.
Step 3: find the scale factor
The shop and the wholesale orders need 480 cookies, at the same 45 g. Some dough stays in the bowl and on the scoop, so allow 2%:
Dough needed = 480 × 45 g ÷ 0.98 = 22,041 g
Scale factor = 22,041 ÷ 1,088 = 20.26
Multiply every ingredient by 20.26 and you have the production batch: 5,774 g of flour, 4,599 g of butter, and so on. Scaling from the yield you need, rather than doubling and doubling again, gets the batch right the first time and makes the loss allowance visible instead of a surprise.
Step 4: size it to the mixer
22 kg of cookie dough doesn't fit in the mixer, which takes about 8 kg of this dough. So the production recipe is written per mix: three mixes of 7,347 g.
| Ingredient | Per mix, exact | Per mix, as written |
|---|---|---|
| Bread flour | 1,925 g | 1,920 g |
| Butter | 1,533 g | 1,530 g |
| Sugar | 1,351 g | 1,350 g |
| Macadamia nuts | 912 g | 910 g |
| Taro paste | 878 g | 880 g |
| Eggs | 675 g | 680 g |
| Salt | 41 g | 41 g |
| Baking soda | 34 g | 34 g |
Big ingredients are rounded to the nearest 10 g, which nobody will taste. Salt and soda stay exact, because rounding 34 g of soda to 30 is a 12% change in the thing that makes the cookie spread. Mixer capacity goes by the weight of the dough, and stiff doughs fill a mixer's motor before they fill its bowl, so go by the maker's figure for the dough you're making.
Step 5: what doesn't scale like arithmetic
Weights scale. Some other things don't:
| What | What happens | What to do |
|---|---|---|
| Eggs | 680 g is 13.6 eggs | Weigh cracked eggs, or use liquid egg by weight |
| Mixing time | A bigger mixer creams and develops dough at its own pace | Mix to how it looks and feels; note the time that works |
| Oven | A convection or deck oven isn't a home oven | Bake one tray first; a convection oven often wants a lower temperature |
| Yeast doughs | Big dough masses hold heat and ferment faster | Control the water temperature; watch the dough, not the clock |
| Pots of sauce or filling | Evaporation follows the pot's surface, heating and cooling take far longer | Expect different cook times; cool in shallow pans |
| Seasoning | Scaled amounts are a starting point | Taste the first full batch, then change the percentage, not the pinch |
Cooling deserves its own line for anything cooked. A pot four times the size cools far slower, and the FDA Food Code's limits, from 135°F to 70°F within 2 hours and to 41°F within 6 hours, don't get longer because the batch did. How to record that is in the HACCP record keeping form example.
Step 6: test, then write it down
Make it at 2× first, then 5×, then the full batch, and change one thing at a time. Count what comes out at each size: if 480 cookies' worth of dough makes 462, the 45 g scoop is really dropping 47 g, or the loss is bigger than 2%. Then write the production recipe properly: weights and percentages, batch size, yield, weight per unit, the mixer and its speed and times, the oven and its temperature and time, and the checks that tell you it's right. That document is the master formula every batch is made from, as in master batch record vs batch record, and the day's quantities come from it, as in bakery production planning.
Get the calculator
Download the recipe scaling calculator. Put in the home recipe's weighed grams, the units you want, the weight per unit, the loss and your mixer's capacity, and it works out the baker's percentages, the scale factor, the production amounts and the amounts per mix, rounded the way a scaler would write them. It's an ordinary Excel file with no macros, it prints, and it works in Google Sheets, LibreOffice and Numbers.
Dough needed =units * grams per unit / (1 - loss)
Scale factor =dough needed / home recipe total
Per mix =ingredient * scale factor / mixes
Where this stops working
A scaled recipe on a spreadsheet is right until the kitchen changes it. The baker cuts the sugar to 1,300 g because the cookies spread too much, and writes it on the printout. The new taro paste is wetter, so the flour goes up by a handful. Six weeks later the spreadsheet, the printout and what's really in the mixer are three different recipes, and the costing, the allergen list and the shopping all come from the one that's wrong. And the yield, the most useful number in the whole exercise, gets checked once, during the test batches, and never again.
How TaroStack does it
TaroStack keeps the production recipe by weight, with versions: when the baker changes the sugar, it's version 2, with version 1 kept, so you can see what changed and when, and the costing follows the version being made. Buy by the case, stock by the each, cook by the gram: the 25 lb case of macadamia nuts and the 910 g in the mix are converted for you, and the recipe carries its batch size and a scrap allowance for what stays in the bowl. Recipes can contain other recipes, so a filling or a dough made in its own batch is one line in the product that uses it.
Then the part the spreadsheet can't do. Every batch you record notes how much it used and how many good units came out, and TaroStack reads that history to show whether a recipe really yields what it claims, which ingredient's quantity is wrong, and how long it really takes. The 462 cookies that should have been 480 stop being a one-off and become a number. Printable batch records carry your own checks, the dough temperature, the bake time, the initials.
Recipes and batches are on Standard at $99 a month, and the first 30 days are free. Your recipes import from a spreadsheet. If you'd like a hand setting up, ask, and we'll do it with you.
