Recipe Scaling & Batch Calculator
Recipe scaling is the process of multiplying a recipe's ingredient quantities by a scale factor (target yield ÷ base yield) to produce a different batch size. The math is straightforward — but units have to convert (oz to lb, ml to cups), salt and leaveners scale slightly less than linearly past 3×, and per-batch fixed costs change the per-unit economics. This Excel workbook handles the conversions and flags the cases where physics, not math, is the limit.
A five-tab Excel workbook for bakers, soap makers, candle makers, and small-batch food producers who scale recipes by hand and lose hours to oz↔lb math, broken volume conversions, and "wait, did I double the salt or quadruple it?" The Recipe (base) tab holds your canonical recipe at base yield with per-ingredient cost rolling up automatically. The Scaler tab takes a target yield, computes the scale factor, and rewrites every ingredient quantity proportionally — converting between weight and volume units (and between oz, g, lb, ml, cups, tsp, tbsp) on the fly via a built-in lookup table. A sanity-check column flags scale factors above 4× and below 0.25× where physics, not math, is the limit. The Batch Cost & Yield tab compares per-unit cost across 5 / 10 / 25 / 50 / 100 / 250-unit batches so you can see what doubling or quadrupling a run actually saves. The Unit Conversions tab is the editable reference the formulas read from, including density tables for water, flour, sugar, butter, honey, olive oil, coconut oil, soy wax, beeswax, lye, and fragrance oil.
- A Recipe (base) tab with ingredient, quantity, unit, cost basis ($ per unit), and a per-ingredient cost roll-up — replace the sample Lavender Honey Sugar Cookie recipe with your own
- A Scaler tab where you set a target yield (e.g. "60 cookies from a base recipe of 24") and every ingredient quantity, unit, and cost rewrites itself
- Built-in unit conversions: oz ↔ g ↔ lb ↔ kg for weight, tsp ↔ tbsp ↔ fl oz ↔ cup ↔ pint ↔ quart ↔ gal ↔ ml ↔ L for volume, all driven by a single lookup table
- A scale-factor sanity check that flags >4× ("verify by eye — salt, leaveners, and spices may need a 0.85× pull-back") and <0.25× ("measurement error becomes large")
- A Batch Cost & Yield tab: per-unit cost at 5, 10, 25, 50, 100, and 250 unit batches — the math behind "is it worth scaling up?"
- A Unit Conversions reference tab: weight, volume, and density tables for water, flour, sugar, butter, honey, olive oil, coconut oil, soy wax, beeswax, lye, and fragrance oil — editable for non-standard ingredients
- Sample data wired in: bakery, soap, and candle workflows you can replace with your own recipe in a few minutes
Educational tool only. Scaling food, soap, and candle recipes is not a substitute for product safety testing. Cold-process soap recipes should always be re-validated through a lye calculator at the new scale; food recipes should be test-baked at the scaled size before being sold; candle pours should be burn-tested at the scaled wick/wax/fragrance combination. Use the cost outputs as estimates — actual material draw and labor will vary batch to batch.
More about this resource
Why you can't just multiply every ingredient by the same number
Three categories of ingredient commonly break linear scaling: salt and leaveners (baking soda, baking powder, yeast) scale slightly less than linearly past 3×; spices and bittering agents (cinnamon, cloves, hops, garlic) often need a 0.85× pull-back at 4×+; and pan size changes thermal mass, so a 6× cake batter does not bake in a 6× pan at the same temperature for the same time. The scaling math is correct — the physics is what bites.
The Scaler tab flags any scale factor above 4× as a "verify by eye" pass, and any factor below 0.25× as a measurement-precision warning. Always run a single scaled batch as a test before committing to a wholesale order or a craft show stock-up.
How weight and volume unit conversions work in the calculator
Every recipe ingredient has a quantity-and-unit (e.g. "340 g flour") and a cost basis quoted in some other unit (e.g. "$14.50 per 5 lb"). The Recipe (base) tab converts the recipe quantity into the cost-unit (340 g → 0.749 lb) before multiplying by the unit price, using a single VLOOKUP into the combined weight + volume table on the Unit Conversions tab.
Volume-to-weight conversion (or vice versa) is density-dependent. The Unit Conversions tab stores per-ingredient densities for the common bakery and soap inputs — water 1.00 g/ml, all-purpose flour 0.53, granulated sugar 0.85, honey 1.42, olive oil 0.91, coconut oil 0.92, melted soy wax 0.88, melted beeswax 0.96. Override per ingredient if you import a non-standard density.
How batch size affects per-unit cost
Setup labor (mise en place, melting wax, sanitizing equipment, oven warm-up) is roughly the same whether you make 12 cookies or 120. The Batch Cost & Yield tab spreads that fixed cost across a range of batch sizes so you can see exactly what scaling up does to per-unit cost. The breakeven math is straightforward: per-unit cost = (per-batch fixed cost ÷ batch size) + per-unit variable cost. The bigger the fixed-cost share, the steeper the per-unit drop as batch size grows.
Worked example using the workbook's default cookie inputs ($18.75 setup labor + $4.00 equipment = $22.75 fixed; $0.85 per-unit variable): a 24-cookie baseline batch costs $1.80 per cookie; doubling to 48 drops it to $1.32 (-26%); 100 drops it to $1.08 (-40%); 250 drops it to $0.94 (-48%). The per-unit drop you actually see depends on how much of your cost is fixed versus variable — recipes with high ingredient cost and low setup time scale less aggressively than recipes with high setup time and cheap ingredients.
Use this tab when sizing a craft show stock-up, quoting a wholesale order, or deciding whether the second pour day this week is worth the labor. The "Worth it?" column flags the breakpoints by comparison to your baseline batch size; pair the per-unit savings against the cost of storing finished inventory and the working capital tied up in a larger ingredient buy.
Or skip the spreadsheet entirely
A spreadsheet scales one recipe at a time. Ardent Seller stores every recipe as a first-class object — ingredients linked to live inventory, cost rolling up automatically when a vendor price moves, and production runs that decrement raw materials and stamp a batch lot for traceability the moment you finish a pour. The recipe and the stock stay in sync without copy-paste.
Recipe costing & scaling
Build a recipe once with materials, labor, and overhead — the per-unit cost updates automatically when any ingredient price changes, and scaling is a single number on the production-run form.
Production runs & batch traceability
Pour a batch and the system decrements wax, fragrance, jars, and wicks (or flour, sugar, butter, and eggs) from inventory and stamps a batch lot — the label cottage food and wholesale buyers want to see.
Multi-location inventory
Track raw materials, finished goods, and packaging separately by location — booth, studio, kitchen, retail partner — with a single running balance per item.
Frequently asked questions
How do I scale a recipe up or down without breaking it?
Multiply every ingredient by the scale factor (target yield ÷ base yield) and convert units when the recipe and your supplier quote prices in different units. Beyond ~4× scale, pull back salt and leaveners by 5–15% and spices by ~15%, and run a test batch before committing — pan thermal mass and ingredient ratios both bite at high scale factors. The Scaler tab in this workbook handles the math and flags the warning thresholds automatically.
How do I convert between cups, grams, and ounces in a recipe?
Weight units (oz, g, lb, kg) convert by fixed factors: 1 oz = 28.35 g, 1 lb = 453.6 g, 1 kg = 1000 g. Volume units (tsp, tbsp, fl oz, cup, ml, L) also convert by fixed factors: 1 cup = 236.6 ml, 1 tbsp = 14.79 ml, 1 tsp = 4.93 ml. Weight ↔ volume is density-dependent — a cup of water is 237 g, but a cup of flour is only 125 g (density 0.53 g/ml), so you cannot convert weight to volume without knowing the ingredient. The Unit Conversions tab in this workbook stores densities for the most common bakery and soap inputs.
What is the formula to calculate cost per unit in a recipe?
Per-unit cost = total batch ingredient cost ÷ yield. For each ingredient: scaled quantity × (cost basis $ ÷ cost-basis quantity), with units converted as needed. Add per-batch fixed costs (setup labor, equipment overhead) divided by yield to get the fully-loaded per-unit cost. The Recipe (base) and Batch Cost & Yield tabs in this workbook compute both halves automatically.
How do I figure out how much a batch will cost before I make it?
Pre-batch cost = (sum of scaled ingredient costs) + (per-batch setup labor) + (per-batch equipment / overhead). The Scaler tab computes the ingredient half from your base recipe and a target yield. The Batch Cost & Yield tab adds the per-batch fixed costs and shows per-unit cost across a range of batch sizes — useful for quoting wholesale orders or sizing a craft show stock-up.
Does scaling a recipe also scale the bake time?
Not linearly — bake time scales with the geometry of the pan and the thermal mass of the batter, not with the recipe scale factor. A 2× cookie batch in two trays bakes in roughly the same time per tray; a 2× cake in one larger pan bakes longer at a slightly lower temperature. Above 3× scale, plan to test bake time and temperature at the new pan size before relying on the original recipe's timing.
Can I use this to scale a soap or candle recipe, not just baking?
Yes — the Unit Conversions tab includes densities for soy wax, beeswax, lye (NaOH solution), olive oil, coconut oil, and fragrance oil so soap and candle recipes scale correctly between volume and weight measurements. For cold-process soap, run the scaled recipe through a lye calculator (SoapCalc, Bramble Berry, etc.) afterward to confirm the lye-to-oils ratio and the water amount — saponification is exact chemistry, not a scaling exercise.
Do I need to re-run a lye calculator after scaling a soap recipe?
Yes, always. Saponification is exact chemistry — the lye-to-oils ratio (and the resulting superfat percentage) must be recalculated at the new scale using a dedicated lye calculator like SoapCalc or Bramble Berry rather than relying on a scale factor. This workbook handles the ingredient quantity math and unit conversions; the lye-to-oils validation is a separate, mandatory step before you mix any cold-process or hot-process batch. Skipping it risks lye-heavy bars that burn skin or fat-heavy bars that won't harden.
Related resources
Product Pricing Calculator
A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.
Candle & Soap Fragrance Load Calculator
Pick a wax or soap base, enter your batch size, and get the exact fragrance oil weight — plus the typical and max load for that medium and the cost per unit.
Inventory Tracker Starter Kit
A working Excel inventory tracker for makers — raw materials, finished goods, packaging, and a purchase log. Reorder thresholds and a status column do the math; conditional formatting flashes red when you are below the line.
Wholesale Line Sheet
A working Excel line sheet for handmade wholesale — buyer-ready front sheet, per-SKU pricing math behind it, and the formulas already wired in.
Spreadsheet vs Inventory Software: The Decision Guide
When a spreadsheet is enough, when it stops working, and how to tell the difference before it costs you.
Cottage Food Laws by State: The 50-State + DC Quick Reference
Revenue caps, sales venues, registration rules, and the most common restrictions for all 50 states and DC — in one place, in plain English.