CandleCalc — Candle & Soap Batch Cost, Fragrance Load & IFRA Compliance Sheet — product cover

Category: Spreadsheets · Business Spreadsheets

About this product

Know exactly what every candle and every bar of soap costs - and whether the fragrance load is within limits - before you pour.

IMPORTANT, STATED PLAINLY

  • This workbook does NOT contain official IFRA limits - fragrance limits come from your supplier's certificates and you enter them. The flags check your math against your entries.
  • SAP values are editable starting points - verify against your supplier's SAP chart before making soap.
  • Burn and safety testing is your responsibility - test every recipe and wick combination.
  • Sample data is fictional. No earnings or outcomes promised. Calculation and record-keeping aid, not professional advice.

Instant download. Yours to use and modify in your own business (single-buyer license).

What's included

  • 9-sheet Excel workbook (works in Excel, Google Sheets, LibreOffice - 100% native formulas, no macros)
  • Candle batch calculator: full per-unit cost build-up (wax, fragrance, wick, vessel, lid, label, packaging, additive, labor, overhead) with wholesale/retail pricing at YOUR multipliers and margins
  • Soap batch calculator: oil blend, lye from your superfat, water, fragrance load, bars per batch, per-bar cost and pricing
  • Fragrance library + IFRA limit check: enter the max % from YOUR supplier's IFRA certificate per oil (candle and soap columns); every batch is flagged WITHIN or OVER against the limits you entered
  • Supplies cost setup: purchase qty and price in, cost per gram/unit out - every calculator reads from it
  • Batch log, burn/cure test log, and a dashboard (batch counts, average unit costs, IFRA pass rate, test pass rate)
  • Quick-Start Guide PDF + license README

Key features

  • Full cost build-up per unit → every material, labor, and overhead line feeds the per-candle and per-bar cost
  • Your pricing rules → wholesale/retail pricing at YOUR multipliers and margins
  • Soap math from your inputs → oil blend, lye from your superfat, water, bars per batch, per-bar cost
  • IFRA flags WITHIN / OVER → each batch is checked against the max % you entered from your supplier's IFRA certificate (QA-proven both ways: candle batch WITHIN at 7.41% vs a 10% entered limit; a 15%-load variant flags OVER)
  • One supplies setup → purchase quantity and price in, cost per gram/unit out, read by every calculator
  • Logs + dashboard → batch log, burn/cure test log, batch counts, average unit costs, IFRA pass rate, test pass rate
  • QA-verified → 115/115 checks passed against an independent Python model + LibreOffice recalc, 0 error cells

Frequently asked questions

Does the workbook contain official IFRA limits?

No — this workbook does NOT contain official IFRA limits. Fragrance limits come from your supplier's certificates and you enter them; the flags check your math against your entries.

Can I trust the SAP values for soap?

SAP values are editable starting points — verify against your supplier's SAP chart before making soap.

Who is responsible for burn and safety testing?

You are — burn and safety testing is your responsibility; test every recipe and wick combination.

Are earnings or outcomes promised?

No — sample data is fictional, and no earnings or outcomes are promised. This is a calculation and record-keeping aid, not professional advice.

Does it use macros?

No — 100% native formulas, no macros, in Excel, Google Sheets, and LibreOffice.

CandleCalc — Candle & Soap Batch Cost, Fragrance Load & IFRA Compliance Sheet — product image

CandleCalc — Candle & Soap Batch Cost, Fragrance Load & IFRA Compliance Sheet

A 9-sheet Excel workbook for candle and soap makers: full per-unit cost build-ups and pricing at your multipliers for both batch types, a supplies cost setup, a fragrance library with an IFRA limit check against the limits YOU enter, batch and test logs, and a dashboard.

$19

Buy Now on Gumroad

Related products

More Spreadsheets
TradeGuard — Contractor Job Costing, Price-Book & Change-Order OS — product image
Spreadsheets

TradeGuard — Contractor Job Costing, Price-Book & Change-Order OS

Stop losing margin to guesswork bids and unsigned change orders. TradeGuard is a no-macros Excel/Google-Sheets system for residential GCs and remodelers: a 312-item master price book, a markup-protected bid estimator that shows your TRUE gross margin, a client-ready proposal view, per-cost-code job costing with a subcontractor draw tracker, and a change-order log with automatic margin impact — plus 3 fillable change-order sign-off PDFs.

MakerMargin Pro — 3D Print & Craft Quote Engine — product image
Spreadsheets

MakerMargin Pro — 3D Print & Craft Quote Engine

Know your exact net profit on every single-color or multi-color 3D print — before you slice. A no-macros Excel/Google Sheets quote engine for print farms and custom makers: true per-job costing (filament by the gram with purge waste, machine depreciation, electricity, labor, hardware BOM, failure buffer), markup vs true-margin pricing, and a side-by-side fee simulator showing your real net on Etsy Organic, Etsy Offsite Ads, Shopify and Wholesale.