Skip to content
Piece Math Toolkit

Spreadsheet · Excel, Google Sheets, Numbers, LibreOffice

Candle & Wax Melt Pricing & Quote Toolkit

A spreadsheet that costs every candle and wax melt you make by the weight of wax and fragrance in it, plans each batch, prices every product for every channel you sell on and turns custom orders into a printable quote. It uses the same math as the free candle pricing calculator, across your whole catalog at once.

$27

one-time · instant download

Coming soon on Etsy and Gumroad. Until then, the free candle pricing calculator runs the same math, one product at a time.

One .zip with the English and Spanish workbooks (.xlsx) and a short read-me. No macros, no account, no subscription. Etsy or Gumroad handles payment and delivery.

PreviewProduct Costing sheetFill split, unit cost and effective hourly rate per product
Product Costing sheet of the candle toolkit, showing fill weight, unit cost and effective hourly rate for four example products

What's inside

11 sheets, filled in with a working example

Input cells and formula cells are colour-coded, and every sheet arrives filled in with a four-product example shop (an 8 oz jar, a 16 oz 3-wick tumbler, a 4 oz tin and wax melts) so you can see real numbers before you type your own.

  1. 01

    Start Here

    Five steps to your first price, the colour legend, a glossary (fill weight, fragrance load, batch, failure allowance, keystone, effective hourly), the disclaimer and the date fees were last checked.

  2. 02

    Shop Settings

    Labor rate, margins, keystone multiplier, equipment price and life in batches, upkeep, melter power and electricity, overhead, monthly volume, wax density factor and fragrance load basis. Gives your equipment cost per batch and overhead per unit.

  3. 03

    Channels

    Etsy, own website, craft fair (with booth fee) and wholesale: percentage fee, fixed fee per order and rounding rule, all editable. Optional Etsy Offsite Ads.

  4. 04

    Materials

    Your supplies library: wax per lb, fragrance per oz, wicks, vessels, lids, labels and dye, each with pack price, pack size and waste. 13 example supplies plus blank rows for your own.

  5. 05

    Batch Planner

    Pick a product and a batch size: wax to melt in lb, fragrance to weigh in oz, wicks, vessels, lids and labels to have ready, melter loads, units per wax pack, per fragrance bottle and per 10 lb of wax.

  6. 06

    Product Costing

    One row per product, at least 20 rows: enter the vessel capacity and fragrance load, pick supplies from dropdowns and get the fill split, each material line, labor, failure allowance, unit cost and effective hourly rate.

  7. 07

    Pricing

    Every product on every channel: suggested price, fees, profit and margin, with a wholesale check per product. Cells turn red when a margin falls 5 points under target or profit goes negative.

  8. 08

    Quantity Breaks

    Custom orders such as wedding favors and corporate gifts: six editable quantity tiers with design and batch time charged per job, giving batches, unit cost, unit price, order total and margin.

  9. 09

    Quote Builder

    A printable one-page quote: customer, event and date, product, quantity price, custom label design fee, personalization, rush, discount, sales tax, deposit and balance.

  10. 10

    What-If

    Change wax and fragrance prices, your labor rate or Etsy's fee and see each product's new cost, its margin at today's price and the price that keeps your margin.

  11. 11

    Equipment Payback

    Months and sales until your melting and pouring equipment pays for itself, and the same for a larger wax melter you're considering.

  12. .zip

    In the download

    The English workbook, the Spanish workbook with every sheet and label translated, and a read-me with the five steps to your first price.

Sheet previews

Batch Planner sheetBatch Planner sheet: wax and fragrance to weigh and supplies to have ready for one batch
Batch Planner: what to weigh for each batch.
Pricing sheetPricing sheet: price, fees, profit and margin for each product on each channel, with the wholesale check
Pricing: every product on every channel.
Quote Builder sheetQuote Builder sheet: a printable one-page quote for 60 wedding favor candles with names on the labels
Quote Builder: one printable page.

What the example shop shows

The workbook ships with the same four products as the free calculator, so you can check every figure there.

Product Costing and Pricing, default inputs
ProductUnit costEtsyOwn siteCraft fairWholesale
8 oz soy candle, amber jar$9.55$19.99$17.99$19.99$13.65
16 oz 3-wick tumbler$15.46$31.99$27.99$29.99$22.09
4 oz travel tin$5.16$11.99$9.99$11.99$7.37
Wax melts, 6-cube clamshell$3.75$8.99$7.99$9.99$5.36

The wholesale check on the Pricing sheet: the 8 oz candle wholesales at $13.65, a shop doubling it would shelve it at $27.30, and selling it wholesale at half the Etsy price ($10.00) would leave a 4.5% margin.

One batch, planned

24 of the 8 oz candles need 9.851 lb of wax and 12.609 oz of fragrance; 10 lb of wax makes 24 of them, a 45 lb case 109 and a 16 oz bottle of fragrance covers 30. 64 clamshells of wax melts need 9.672 lb of wax and 15.475 oz of fragrance. Each default batch holds 165.12 oz of fill, one load of a 20 lb melter.

Quantity breaks for custom-label wedding favors

4 oz tins with the couple's names on the label. Design and batch time are charged to the job, so the price per tin falls as the order grows. Custom orders are quoted to the nickel.

4 oz tin, 20 minutes of label setup per job
QuantityBatchesPrice eachOrder total
11$71.70$71.70
121$13.15$157.80
251$10.40$260.00
502$10.05$502.50
1003$9.45$945.00
2506$9.05$2,262.50

A single custom tin carries a whole batch and the label setup, which is why it comes to $71.70: the table makes the case for a minimum order.

A quote for 60 favors, each with a guest's name

60 tins at the 60-piece price of $9.70 come to $582.00. Add a $35.00 custom label design fee and $20.83 for putting 60 names on the labels, and the quote totals $637.83, with a 50% deposit of $318.92 and the same again on delivery.

What if wax goes up 10% and fragrance 15%?

The 8 oz candle's cost rises from $9.55 to $9.80 and its Etsy margin at $19.99 falls to 39.2%; $20.99 keeps 40%. The 16 oz tumbler needs $32.99. The tin and the wax melts absorb it and keep their prices.

Equipment payback

At the example shop's average Etsy profit of $7.58 a unit and 200 units a month ($1,515.58), a $650 equipment set-up pays for itself in 0.43 months (86 units) and a $900 larger melter in 0.59 months (119 units).

Free calculator or the toolkit?

The calculators on this site are free and stay free. Use them to price one product. The toolkit is for running the whole shop's prices in one place.

Free calculatorToolkit
Products at onceOneAt least 20, side by side
SuppliesTyped in each timeSaved library with dropdowns
Batch planFor the batch you enterAny product and batch size, with melter loads
Channels and feesFour, editableFour, editable, with your own rounding rules
Custom ordersSet units sharing the designQuantity tiers and a printable quote
Price changesRe-enter inputsWhat-If sheet for the whole catalog
Equipment paybackNoYes, plus a melter upgrade
LanguageEnglishEnglish and Spanish
Works offlineNoYes

Spanish edition included

Edición en español incluida en la misma descarga: todas las hojas, etiquetas y nombres de hoja traducidos, con las mismas fórmulas.

Both editions are in the same .zip, so a shop with Spanish-speaking staff or customers doesn't need to buy twice.

Who it's for

  • Small-batch candle and wax melt makers (soy, coconut, paraffin or blends; jars, tumblers, tins and clamshells) who sell on Etsy, at craft fairs, on their own site or wholesale to shops.
  • Makers who take custom orders, such as wedding favors and corporate gifts with custom labels, and need to quote them quickly and consistently.

It is not accounting or inventory software, it doesn't connect to Etsy, and it doesn't teach candle making: there is no wick, temperature or fragrance-load guidance. Follow your supplier's maximum fragrance load and flash-point guidance. Figures are estimates, not tax, legal or safety advice. Fees were last checked on 2026-10-27 and example supply prices on 2026-10-29; both are editable.

Questions about the toolkit

What exactly do I download?

One .zip file containing the English workbook, the Spanish workbook and a short read-me. Both workbooks are .xlsx files with the same 11 sheets.

Which apps does it work in?

Microsoft Excel (Windows, Mac and web), Google Sheets (upload the file and open it with Sheets), Apple Numbers and LibreOffice Calc. It uses standard formulas and no macros.

Does it handle wax melts, tins and multi-wick candles?

Yes. Each product row has its own vessel, lid, wicks per unit, fragrance load, dye and batch size, so a 3-wick tumbler, a tin with its lid included and a clamshell of wax melts sit side by side. The example shop includes all three.

Can I use a currency other than dollars?

Yes. Money cells hold whatever amounts you type; change the cell format if you want a different currency symbol. Weights are in ounces and pounds.

Is it the same math as the free calculator?

Yes. The formulas are the same and the example shop gives the same results, for example an 8 oz candle that costs $9.55 and is priced at $19.99 on Etsy. The toolkit adds the whole catalog, the supplies library, any batch size, quantity breaks, quotes, what-if and payback.

Does it tell me how to make candles?

No. It is a pricing tool. It doesn't give wick, temperature or fragrance-load guidance; follow your supplier's maximum fragrance load and flash-point guidance. Warning labels appear only as a cost line.

Are the platform fees current?

They were last checked on 2026-10-27 for US sellers. Every fee lives in the Channels sheet as an editable input, so you can update it in seconds when a platform changes its pricing.

What if something doesn't work?

Message Piece Math through the platform you bought from, Etsy or Gumroad, and describe what you see.