For makers · Digital download
Candle & Wax Melt Pricing & Profit Calculator
Cost per candle and per wax melt pack from wax, fragrance, wicks, jars and clamshells. Suggested retail, wholesale and multipack prices, fees and real profit.
$12
Prices in USD. Sales tax / GST/HST calculated at checkout.
Canadian buyers: you pay in USD and your card converts to CAD automatically.
- 1 × .xlsx file, instant download
- Works in Excel, Google Sheets, Numbers, LibreOffice
- No macros, no subscription
- Sample data included
Look inside the spreadsheet
Real screenshots of the file with its sample data. Click any image to zoom.
What's inside
Stop guessing what your candles and wax melts cost. This Candle & Wax Melt Pricing & Profit Calculator turns your bulk supply prices into an exact cost per candle. Then it suggests retail and wholesale prices and shows the real profit after marketplace fees.
What it does
- Materials tab: enter what you paid for a pack (lb, kg, oz, g, ml or each) plus shipping, and get the cost per oz, gram or piece automatically
- Pricing tab: build each candle from dropdowns for wax, fragrance oil, wick, vessel, lid, label and packaging
- NEW Wax Melts tab: price clamshells, snap bars and mini cubes from the same materials list. See cost per pack and per cube, profit, margin, wholesale and multipack (e.g. "buy 4, save 10%") pricing
- Fragrance load % is calculated on wax weight, just as you pour it
- Labor (your hourly rate × minutes) and overhead per candle are included, so your time is never free
- Suggested retail price (your markup), wholesale price (keystone or your own %) and marketplace fees (Etsy-style % + fixed fee, editable)
- Profit and margin per candle, with automatic flags for anything below your target margin or losing money at wholesale
- Optional "Your price" column: see the profit at the price you actually charge
- Dashboard: averages, best and worst margin, cost-vs-profit chart, cost breakdown pie for any product, and "how many candles do I need to sell to hit my monthly profit goal?"
- Up to 50 candle products and 100 materials
- Currency label USD / EUR / GBP / CAD / AUD; weights in oz or grams
Easy to use
- Yellow cells are inputs and grey-green cells calculate for you. Formula cells are protected so you can't break them by accident (no password; unlock any time)
- Sample data included, so you can see how it works in seconds
- Start Here tab with step-by-step instructions
Works with
Microsoft Excel (2010 or newer, Windows & Mac), Google Sheets (free; upload and open), LibreOffice and Apple Numbers. No macros and no add-ons.
What you get
1 × .xlsx spreadsheet (6 tabs: Start Here, Dashboard, Settings, Materials, Pricing, Wax Melts)
Please note
- This is a DIGITAL product. Nothing will be shipped.
- Default marketplace fee settings are an approximation of Etsy US fees. Fees vary by country and change over time, so please enter your own.
- This is a planning tool, not financial or tax advice.
- For personal or single-business use. Please don't resell or share the file.
FAQ
Can I use ounces or grams?
Yes. Choose oz or g in Settings and enter pack sizes in whatever unit your supplier uses (g, kg, oz or lb). The calculator converts everything for you.
Does it handle different vessel sizes and fragrance loads?
Yes. Every candle line has its own fill weight, fragrance load %, wick, vessel and packaging, so a 4 oz tin and a 16 oz jar are costed separately.
Can I price wax melts too?
Yes. The Wax Melts tab prices clamshells, snap bars and mini cubes from the same materials list: wax per cavity, fragrance load, dye, container and label give the cost per pack and per cube, plus retail, wholesale and multipack prices.
What exactly do I get?
One .xlsx spreadsheet file, delivered as an instant download link after payment. Nothing is shipped.
Does it work on a Mac or iPad?
Yes. Open it in Excel for Mac, Apple Numbers, or Google Sheets in your browser or the Google Sheets app on iPad. No macros, so nothing is blocked.
Can I use it in Google Sheets for free? Do I need Excel?
You don't need Excel. Upload the file to Google Drive and open it with Google Sheets, which is free with a Google account. It also works in Excel 2010 or newer, LibreOffice and Numbers.
Is it a one-time payment?
Yes. You pay once. No subscription, no recurring charges.
Do I get lifetime access and free updates?
Yes. The file is yours to keep and use for your own business for as long as you like, and future fixes and updates to the same product are free.
What if I get stuck?
Every file has a Start Here tab and sample data. If you're still stuck, email us and we'll help, usually within 2 business days.
Can I get a refund?
If a formula doesn't work, we'll fix it or refund you. See the refund policy for details.
Does it work for Canada (CAD and metric units)?
Yes. The currency symbol is editable, and you can use metric units (grams, kilograms, centimeters, kilometers) where the sheet asks for units. Prices on this site are in USD; your card converts automatically.
Can I share or resell the file?
The license is for one person or one business. Please don't share, resell or redistribute the file.
Coming soon
AI-assisted, every formula checked by hand. How we build our spreadsheets