Stop underpricing your candles. Know your exact cost, set
profitable prices, and plan every batch with confidence —
all in one spreadsheet built specifically for candle makers.
─────────────────────────────
📦 WHAT’S INCLUDED — 6 SHEETS
─────────────────────────────
📋 Sheet 1 — Start Here
Step-by-step guide so you know exactly what to do.
– 5-step walkthrough
– Colour key explained
– Zero learning curve
📦 Sheet 2 — Materials Cost Tracker
Track the cost of every ingredient you use.
– Enter total cost + qty purchased
– Cost Per Unit auto-calculated
– 18 materials pre-loaded
– Add unlimited materials by inserting rows
🕯️ Sheet 3 — Per-Candle COGS Calculator
Know exactly what each candle costs to make.
– Section A: Direct Materials
– Section B: Labour Cost (your hourly rate)
– Section C: Overhead (utilities, workspace)
– Total COGS Per Candle — auto-calculated
💰 Sheet 4 — Pricing Strategy Calculator
Get your selling price instantly — 3 strategies included.
– Strategy 1: Markup Multiplier (3× / 4× / Wholesale)
– Strategy 2: Target Profit Margin (40% / 50% / 65%)
– Strategy 3: Etsy Net Profit Calculator
→ See exactly what you keep after all Etsy fees
📦 Sheet 5 — Batch Planner & Profit Projector
Plan your batch before you pour a single candle.
– Enter batch size → materials needed auto-calculated
– Total batch revenue & COGS
– Gross profit & profit margin %
🧪 Sheet 6 — Scent Load & Wax Calculator
Get your fragrance and wax amounts right every time.
– Enter jar weight + fragrance %
– Exact FO and wax per candle — auto
– Full batch totals — auto
– Fragrance Load Reference Guide included
─────────────────────────────
✅ WHY CANDLE MAKERS LOVE THIS
─────────────────────────────
✔ Built specifically for candle makers — not a generic calculator
✔ True cost clarity — materials + labour + overhead all included
✔ 3 pricing strategies in one place
✔ See retail, wholesale & Etsy prices instantly
✔ Know exactly what you keep after Etsy fees
✔ Plan your batch before buying materials
✔ Never waste materials with exact scent load calculations
✔ Zero manual math — every number auto-calculated
✔ Works on Excel & Google Sheets (free)
✔ Pre-filled with sample data so you can see it in action
✔ Unlimited use — one purchase, forever
─────────────────────────────
📥 HOW TO GET STARTED
─────────────────────────────
1. Purchase & download the file instantly
2. Open in Google Sheets (free) or Excel
3. Go to Materials tab — enter your ingredient costs
4. Go to COGS Calculator — enter qty used per candle
5. Go to Pricing Strategy — your prices appear instantly
⚠️ Download via web browser only.
Not supported through the Etsy app.
Go to etsy.com/your/purchases to access your file.
─────────────────────────────
📌 FILE DETAILS
─────────────────────────────
– Format: .xlsx (Excel + Google Sheets compatible)
– Delivery: Instant Digital Download
– Use: Personal & commercial use for your own business
– Support: Message me anytime if you need help!
─────────────────────────────
💡 ALSO IN MY SHOP
─────────────────────────────
Need to manage your invoices too?
Check out my Candle Business Invoice System —
the perfect companion tool for your candle business.
─────────────────────────────
© BizMind Studio
For personal & commercial use within your own candle business.
Please do not resell or redistribute this file.
