Soap Maker's Cost-Per-Bar Calculator
The cost of a handmade bar of soap is the total batch cost — oils, lye, water, fragrance, colorants, packaging, and labor — divided by the number of bars the cured batch actually produces. Cured weight is 5–9% less than wet batter weight on cold-process due to water evaporation over the 4–6 week cure, so pricing off wet weight under-prices every bar. This Excel workbook handles the SAP-table lye math, the cure-loss adjustment, and the per-bar roll-up for both cold-process and melt-and-pour.
A six-tab Excel workbook hyper-specific to cold-process (CP) and melt-and-pour (M&P) soap makers who want to know what every bar actually costs — not just what the oils on the recipe card add up to. The CP Recipe tab takes oils, water-as-percent-of-oils, superfat, fragrance, colorants, additives, and packaging, and computes lye via a SUMPRODUCT against a NaOH SAP table for 22 common oils on the Reference tab. Wet batter weight, cured weight (after a configurable 6% cure loss), and bar count at your target weight all flow downstream — so per-bar ingredient, packaging, and labor cost roll up to a fully-loaded number you can defend on a wholesale line sheet. The M&P Recipe tab handles base + FO + colorants + embeds with the simpler M&P math (no lye, ~1% cure loss). The Recipe Comparison tab shows your CP recipe, your M&P recipe, and two open slots side-by-side with suggested retail (3.0×) and wholesale (1.6×) prices. The Batch Scaling tab spreads setup labor across 1× / 2× / 3× / 4× / 6× / 10× scaled batches and flags where the per-bar savings stop being worth the storage and capital. The Reference tab carries the SAP values, fragrance load ranges by soap type, water-discount and cure-loss numbers, and a common-pitfalls list every soaper has run into at least once.
- A CP Recipe tab with oils, lye (auto-calculated from SAP values), water, fragrance, colorants, additives, packaging, and labor — with wet batter weight, cured weight after cure-loss, bar count, and per-bar fully-loaded cost rolling up automatically
- NaOH SAP values for 22 common oils on the Reference tab — olive, coconut, palm, castor, sweet almond, avocado, shea, cocoa, mango, sunflower, lard, tallow, rice bran, hemp, jojoba, soybean, grapeseed, apricot, argan, babassu, beeswax, stearic — type the oil name and the SAP autofills
- A built-in fragrance load sanity check that flags >6% as exceeding the typical CP safe max and a hard-oil-ratio check that warns when a recipe is below 30% (will not unmold cleanly) or above 70% (brittle, poor lather)
- An M&P Recipe tab with the simpler melt-and-pour math: base + FO + colorants + embeds, ~1% cure loss, and an FO load check tuned to the 1–3% M&P safe range
- A Recipe Comparison tab — CP vs M&P vs two of your own alternates, side-by-side, with per-bar fully-loaded cost and suggested retail (3.0× cost) and wholesale (1.6× cost) prices
- A Batch Scaling tab — per-bar cost at 1× / 2× / 3× / 4× / 6× / 10× scaled batches with setup-labor amortization and a "worth it?" flag at each batch size
- Cure weight loss accounted for: wet batter × (1 − cure loss %) gives saleable cured weight before bar count, so the per-bar cost reflects bars that actually leave the rack at week six (default 6% for CP, 1% for M&P, both editable)
- Sample data wired in: a balanced 64-oz Olive-Coconut-Palm-Shea-Castor bastille at 5% superfat with a 3% lavender FO load — replace it with your own recipe in a few minutes
Educational tool only. This workbook estimates lye for cost calculation and is NOT a substitute for a dedicated lye calculator (SoapCalc, Bramble Berry, Soapee, etc.) — always validate your final recipe through one of those before mixing any cold-process or hot-process batch. Cosmetic safety, label compliance, and batch-record requirements vary by jurisdiction; consult your local cosmetic-safety regulator and supplier SDS sheets. Use the cost outputs as estimates — actual material draw, cure loss, and labor will vary batch to batch.
More about this resource
How cost-per-bar is actually calculated for cold-process soap
Total batch cost = oils + lye + water + fragrance + colorants + additives. The non-obvious line is lye: it is computed as the sum across each oil of (oil weight × SAP value), then multiplied by (1 − superfat %) to leave some unsaponified oil in the bar for skin feel. The CP Recipe tab does this automatically via a SUMPRODUCT against the SAP table on the Reference tab — type "Olive oil (pomace)" and the SAP value 0.134 autofills.
Wet batter weight = oils + lye + water + fragrance + colorants. Cured weight = wet × (1 − cure loss %), default 6%. Bar count = floor(cured / target bar weight). Per-bar ingredient cost = total ingredient cost / bar count. Add per-bar packaging (wrap + label + sleeve) and per-bar labor (batch hours × hourly rate / bar count) to get the fully-loaded number.
Why cure weight loss matters more than soapers usually think
A 4 lb (64 oz) cold-process batch starts at roughly 96 oz of wet batter — the 64 oz of oils plus ~9 oz of lye, ~21 oz of water, and ~2–3 oz of fragrance and colorants. Over the 4–6 week cure, mostly water evaporates: 5–9% of the wet weight leaves the bar before it is saleable. At 6% cure loss the same 64 oz of oils produces roughly 90 oz of saleable cured bar weight, not the full 96 oz of wet batter.
At 4.5 oz per bar that is 20 bars, not the 21 you would expect off wet weight. One bar per batch sounds small until you do 100 batches in a year — that is 100 bars of "free" inventory you priced into someone else's margin. The CP Recipe tab subtracts the cure-loss percent before computing bar count, so the per-bar cost reflects what actually goes on the cure rack at week six.
Melt-and-pour cure loss is much smaller — typically 0–2%, mostly fragrance flash-off in the few minutes between pour and wrap. The M&P Recipe tab uses a 1% default and recommends wrapping immediately to minimize loss.
The two soap chemistry sanity checks the workbook runs for you
Fragrance load (% of oils for CP): a typical CP recipe runs 3% FO, with 6% as the conventionally accepted upper safe max. Above 6% the bar can develop ricing, acceleration, or seepage. The CP Recipe tab divides total fragrance weight by total oils weight and flags WARN above 6%, OK in the 3–6% range, and notes a low-throw scenario below 1%.
Hard-to-soft oil ratio: a balanced bar runs 50–70% hard fats (coconut, palm, lard, tallow, butters) and 30–50% soft / liquid oils (olive, sweet almond, etc.). Below 30% hard and the bar will not unmold cleanly within 24–48 hours; above 70% hard and the bar tends toward brittle with poor lather. The Reference tab tags every oil as Hard or Soft and the CP Recipe tab computes the ratio automatically — change an oil percentage and the warning chip updates.
How batch scaling affects per-bar cost on a soap recipe
Setup labor on a CP batch — sanitizing, melting fats, lye-water cooling, mise en place, blending, pour, cleanup — does not scale with batch size. The workbook defaults to 1.5 hours of setup labor at $20/hour ($30 fixed labor) on the sample recipe; spread that fixed cost across more bars and each bar gets cheaper. The Batch Scaling tab compares per-bar cost at 1× / 2× / 3× / 4× / 6× / 10× the base recipe with setup labor held constant.
Run the Batch Scaling tab against the workbook's sample recipe (64 oz oils, $33.37 ingredients, $30 fixed labor, 20 bars per batch) and a 4× batch drops per-bar fully-loaded cost roughly 15–20% versus the 1× baseline; a 10× batch plateaus near 28–33% saved. Your numbers will differ — recipes with high ingredient cost and low setup time scale less aggressively than recipes with cheap ingredients and lots of labor. Most home soapers also cap practical CP batches at 8–12 lb of oils due to soap-pot capacity, mold size, and trace timing on a single pour. Below a 5% per-bar drop, storage cost and the working capital tied up in a larger oil buy usually erase the savings.
Or skip the spreadsheet entirely
A spreadsheet prices one recipe at a time and assumes your oil costs are static. Ardent Seller stores every oil, fragrance, mica, jar, label, and shrink wrap as a live inventory item with batch-level cost lots — so when a supplier raises olive oil mid-quarter, every recipe and every product reprices itself overnight. Production runs decrement raw materials, stamp a batch lot for cosmetic recall readiness, and roll the real material draw and labor into the per-bar cost on your reports.
Recipe costing
Build a soap recipe once with oils, lye, FO, micas, and packaging at their current cost — the per-bar number updates automatically when any ingredient price moves.
Production runs & batch traceability
Pour a 4-pound batch and the system decrements every oil, the FO, the lye, the jars, and the wraps from inventory and stamps a batch lot — the cosmetic-recall paperwork most home soapers do by hand.
Pricing tiers (retail & wholesale)
Maintain retail and wholesale prices per bar with one-click margin rules — synced with cost so an FO price hike reprices both tiers and flags the bars that fell below your margin floor.
Frequently asked questions
How do I calculate the true cost per bar of cold-process soap?
Total batch cost (oils + lye + water + fragrance + colorants + additives) divided by the cured bar count. Cured bar count = (wet batter weight × (1 − cure loss %)) / target bar weight, rounded down. Add packaging (wrap, label, sleeve) and labor (batch hours × hourly rate / bar count) to get the fully-loaded per-bar cost. This Excel workbook does all six steps automatically — type oil weights and supplier prices, the per-bar number rolls up.
What is the SAP value of olive oil and how do I use it?
The NaOH SAP value for olive oil is 0.134 — meaning 0.134 ounces (or grams) of sodium hydroxide is needed to fully saponify one ounce (or gram) of olive oil. Multiply each oil weight in your recipe by its SAP value, sum them, then multiply by (1 − superfat %) to get the lye amount. The Reference tab in this workbook stores SAP values for 22 common oils; the CP Recipe tab does the SUMPRODUCT and the superfat discount automatically.
Is this workbook a substitute for SoapCalc, Bramble Berry, or another lye calculator?
No. This workbook estimates lye for cost calculation and runs reasonable sanity checks on FO load and hard-oil ratio, but saponification is exact chemistry — a 0.1 oz lye error on a 4 lb batch can mean a lye-heavy bar that burns skin. ALWAYS run your final recipe through a dedicated lye calculator (SoapCalc, Bramble Berry, Soapee) before mixing. This workbook is for cost math; the dedicated calculators exist for safety math, and the two are not interchangeable.
How much does cold-process soap lose in cure weight?
Most cold-process recipes lose 5–9% of their wet batter weight during the 4–6 week cure, with 6% as a reasonable default for a 33% water-of-oils formulation. The loss is almost entirely water evaporation. Recipes with a heavier water discount (lower water-as-percent-of-oils) cure faster and lose slightly less; full-water recipes lose more. The CP Recipe tab in this workbook subtracts the cure-loss percent from wet batter weight before computing bar count.
How do I price melt-and-pour soap differently from cold-process?
M&P math is much simpler: total weight = base + fragrance + colorants + embeds, with cure loss typically 1% (mostly FO flash-off in the minutes between pour and wrap). No lye, no superfat, no SAP-table lookup. The M&P Recipe tab handles this directly — drop in the base weight and the FO weight, the bar count and per-bar cost roll up. Pricing-wise, M&P typically commands lower retail than CP because the base cost is lower and the perceived craft is lower; a 3.0× markup on fully-loaded cost is a defensible retail starting point for both.
What is a typical fragrance load for cold-process soap?
Typical is 3% of oils weight, conventional safe max is 6%. Above 6% and you risk ricing (the FO seizing the batter into a chunky mess), acceleration (trace happens in seconds, not minutes), or seepage (FO weeping out of the cured bar). Most cold-process bath soaps land between 2.5% and 4% to balance scent throw against trace behavior. Floral and spice FOs (rose, cinnamon, clove) accelerate trace dramatically — pour at light trace and work fast, or use them at 1.5–2.5%.
How much does it cost to make a bar of soap?
It depends on the recipe, batch size, and packaging tier. The sample 4 lb (64 oz oils) bastille recipe wired into this workbook — olive 40% / coconut 25% / palm 20% / shea 10% / castor 5%, 5% superfat, 3% lavender FO, kraft-sleeve packaging, 1.5 hours of labor at $20/hour — produces 20 bars at $3.73 fully loaded ($1.67 ingredients + $0.56 packaging + $1.50 labor). Olive-heavy bastilles run cheaper per ounce of oil than shea-or-cocoa-butter-heavy luxury formulations; a 4× batch on the same recipe drops per-bar cost roughly 15–20% by amortizing setup labor across more bars. Use the CP Recipe and Batch Scaling tabs in this workbook to get a number specific to your recipe and labor rate.
What is a hard-to-soft oil ratio in cold-process soap?
Hard oils (coconut, palm, lard, tallow, shea, cocoa butter, mango butter) saponify into a firm bar with stable lather; soft / liquid oils (olive, sweet almond, sunflower, rice bran, castor) saponify into a softer, more conditioning bar with creamy lather. A balanced bath bar runs 50–70% hard fats and 30–50% soft. Below 30% hard the bar may not unmold cleanly within 24–48 hours; above 70% hard the bar tends toward brittle with poor lather. The Reference tab tags every oil and the CP Recipe tab computes the ratio automatically.
Related resources
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.
Recipe Scaling & Batch Calculator
A working Excel recipe scaler — enter a base recipe, set a target yield, and every ingredient auto-scales with unit conversions (oz/g/lb/ml/cups). Plus a batch-cost tab and a unit-conversion reference.
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.
Should I Raise My Prices? Decision Tool
A live web tool that runs the +10% / +20% / +30% price-hike math for one product — including the volume drop that comes with each — and tells you which scenario clears the most monthly profit.
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.
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.
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.