Candle Making Business Spreadsheet, Excel and Google Sheets, Candle Cost Calculator, Fragrance Load, Wax Calculator, Inventory, Profit

Candle Making Business Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Know exactly what every candle costs, how much wax and fragrance oil to weigh out, and which candles and sales channels really make you money. Perfect for candle makers selling on Etsy, at craft markets and wholesale. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers). ★ WHAT'S INCLUDED ★ • 15 tabs with a clickable Start Here page and a How To Use guide with FAQ • Dashboard: 16 KPI tiles (sales, net profit, goal progress, average cost per candle, best seller, best channel, candles curing, ready stock, supplies to reorder, open orders, pour-now and overdue alerts and more), month by month table, orders to fill, supplies to reorder, top candles, sales channels and 5 charts • Candle Costing (40 candles): pick the vessel, wax, fragrance oil, wick, label, lid and packaging from your supplies. Fill weight, wax and fragrance amounts, materials cost, labor + overhead, total cost per candle, suggested wholesale and retail prices, margins, price check, stock and sales this year • Batch Calculator: wax and fragrance oil for any batch in oz, lb, grams and kg, a supply check (Enough / Short) and batch cost, plus a quick-reference chart for 2 to 16 oz vessels at 6% to 12% fragrance load • Production Batches (400 rows): pour date, fragrance load, pour temp, rejects, cure days, hot throw rating, ready date, curing / ready status and cost per good candle. Supplies used come off your inventory automatically • Supplies & Inventory (80 supplies): cost per oz (or each), starting count, received, used in batches, on hand, reorder alerts and packs to order, plus Supply Purchases (600 rows) with price creep flags • Sales Log (2,000 rows): Etsy, website, craft markets, consignment and more, with channel fees, postage, materials cost and profit per sale • Wholesale & Custom Orders (300 lines): due dates, deposits, balance due, pour-by dates that leave time to cure, and Pour now / Due this week / Overdue alerts • Expenses (500 rows) with a by-category summary • Profit & Loss: monthly P&L, sales by channel by month and expenses by category by month, with 2 charts • Insights: sales by channel, by scent family, top 10 candles by profit and by units, fragrance test results from your batches and production by month, with 2 charts • Pricing What-If: test new wax or fragrance prices, fragrance load, labor time and markups, see what you keep per candle on every channel, plus a price ladder and chart • Sample data from a busy small candle business so you can see how it works ★ PERFECT FOR ★ ✓ Candle makers selling on Etsy, at craft markets and wholesale ✓ Soy, coconut and wood wick candle and wax melt makers ✓ Anyone starting a candle business who wants to price candles properly ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload