Candle Business Calculator for Candles, Wax Melts and Room Sprays (Excel and Google Sheets)

Know what each candle, wax melt and room spray costs you to make, and set prices that cover your costs. This workbook is built for small candle and home fragrance makers in the US. Enter what you paid for supplies once, and the formulas do the math for every product.

This is a digital download. Nothing ships. You will receive the workbook (.xlsx) and a two page Start Here PDF guide. You need Microsoft Excel or a free Google account to use Google Sheets.

What's inside (11 tabs):

• Start Here: numbered steps, color key and your settings
• Supplies Cost: cost per oz, gram, fl oz, mL or unit for wax, fragrance oil, wicks, jars, tins, clamshells, labels, bottles and more
• Candle Cost, Wax Melt Cost and Room Spray Cost: material cost per item
• Pricing: suggested retail at an editable multiplier (default 3x; 3x to 4x is common) and wholesale at half of retail, or a cost plus labor method
• Fees and Profit: true profit per sale on Etsy, Shopify and in person, with editable fee rates
• Batch Planner: total wax and fragrance oil in ounces and grams, spray liquids in fl oz and mL
• Inventory and Reorder: reorder alerts and estimated reorder cost
• Monthly Profit Goal: how many of each product to sell per month and per week
• Sales Log: monthly orders, units, revenue, fees and profit

Enter weights in ounces or grams and liquids in fl oz or mL, and it converts for you. Comes filled with labeled example numbers so you can see how it works. No macros. Made for US sellers.

Good to know: results are estimates based on the numbers you enter. Platform fees change, so check current rates and update the fee cells. Because this is a digital file, returns and exchanges are not accepted. If you have trouble opening it, contact us and we will help. For use in your own business; please do not resell or share the file.

Common Questions

What do I receive?
The workbook (.xlsx) and a two page Start Here PDF guide. This is a digital download, so nothing ships.

What do I need to use it?
Microsoft Excel or a free Google account to use Google Sheets.

Does it use macros?
No. It comes filled with labeled example numbers so you can see how it works.

Can I return it?
Because this is a digital file, returns and exchanges are not accepted. If you have trouble opening it, contact us and we will help.

Made by Cozyees in Hartfield, Virginia.