You do not need a spreadsheet for this, although it can help. The arithmetic is simple: tooling is a one-off cost, and it can reduce the labour needed for each candle. Start by working out how long a single pour cycle takes you now, from melter to trimmed candle, and what an hour of your time is worth. Multiply that by the number of candles you expect to make in a year. That is the labour cost your tooling investment is competing against.
The surprising part is how much the cavity count can change the process. Doubling the number of cavities does not double the tooling cost, because the mould box, silicone pour and setup are shared across all the cavities.
It does roughly halve the handling time per candle. You pour, wait and demould once for many candles instead of once for one. That asymmetry is the whole reason multi-cavity tooling exists.
The other half of the payback is consistency, although it is harder to put a figure on. When your candles are identical, you can state a burn time, quote a wholesale price with confidence and stop absorbing the cost of candles that came out wrong. For most chandlers moving into wholesale, that matters more than the labour saving.
We do not publish a payback figure because it depends on your labour cost, selling price and throughput. Any figure we printed could be wrong for you. Send us your weekly volume and we will work out the sum with you, rather than at you.