I Have 20 Candle SKUs With Different Jars, Fragrances and Fill Weights — How Do I Build a Costing System That Updates Every Product When Wax or Fragrance Prices Change?

Why twenty separate costings always drift

A range of twenty candles is usually costed the way it grew: one sheet per product, built the week that product launched, with the wax price of that week typed into it. Each sheet is correct on the day it is made. The trouble starts the first time a rate changes, because a rate that appears twenty times has to be found twenty times, and the one you miss is the one you will quote from. Six months later the range carries three different wax prices and nobody can say which is current.

Count the cells. Twenty SKUs with four material lines each is 80 rate cells across the range, but if those twenty share one wax, eight oils, six vessels and two wick sizes, only 17 rates actually exist. The other 63 cells are copies, and a copy is not information — it is a future error waiting for a price change.

There is a third drift that is specific to buying materials rather than making them, and it catches careful people. The rate you pay depends on the pack you bought. Luxury Soy Wax CSI 464 is ₹520.00 a kilogram in the 500 g pack and ₹507.40 a kilogram in the 1 kg, 5 kg and 10 kg packs, live CSI pricing in September 2026. Citronella runs from ₹9.44 a gram at 15 gm to ₹2.89 a gram at 1 kg. A rate copied into a sheet without the pack beside it cannot be checked, cannot be reproduced, and will quietly be applied to a batch you bought differently.

The shape: rates in, quantities in, cost out

The system is three layers, and the whole of its value is in refusing to mix them. The first layer is rates — what a gram or a piece of something costs. The second is quantities — how much of each thing an SKU uses. The third is output — cost per candle, which is nothing but the first two multiplied together and added up. Rates change often and without warning. Quantities change only when you reformulate. Output should never be typed at all.

Put in those terms the design writes itself. When a maker says their costing sheet is a mess, what they almost always mean is that the three layers are interleaved: a grams column next to a rupee column next to a hand-typed total, all on one row, with no way to tell which was edited last.

Sheet 1: the rate table, with the pack beside every rate

Build the rate sheet first, because everything downstream inherits its quality. Each row needs five columns: a short code the SKU sheet will point at, the material's name, the rate, the pack that rate came from, and the month you read it. The code matters more than it looks — one that never changes lets you rename a product without breaking twenty formulas.

Here is the rate sheet for the three worked SKUs on this page, from live CSI stock in September 2026. The wax is Luxury Soy Wax CSI 464, taken at the 1 kg pack rate of ₹0.51 a gram. The two fragrances are Woody Oud at ₹4.53 a gram and Citronella at ₹2.89 a gram, both at their 1 kg pack. The wicks are Eco Candle Wicks: Thin (C1) at ₹5.90 each and Thick (C2) at ₹9.44 each, at the 100 pack. Three vessels sit on the same sheet, priced per piece from their pack prices.

Two of those rows repay a second look. The wax rate is the 1 kg rate, and it is not the only one CSI publishes for that grade: the 500 g pack works out at ₹0.52 a gram against ₹0.51 from 1 kg upward, and above 1 kg the rate is the same at 5 kg and 10 kg. The fragrance rows are the same story with a wider spread: Citronella is ₹7.67 a gram in the 100 gm pack and ₹2.89 a gram at 1 kg, a difference of ₹4.78 a gram on the oil line. Check the ladder on what you actually buy; the sheet only needs the pack column filled in.

Sheet 2: grams and counts, and nothing that looks like money

The SKU sheet is the one that describes your range. One row per product, and the columns are all quantities: grams of wax, the load as a percentage of wax weight, the code of the oil, the code of the vessel, the code of the wick and how many of them. That is the whole row. It does not know what anything costs and it should not.

Store grams of wax, not the finished weight. A fragrance load is a percentage of wax weight — that is how CSI product pages state it, and it is the convention this whole series uses — so the oil is derived from the wax, not the other way round. 60 g of wax at 8% is 4.8 g of oil and 64.8 g poured. If you store the finished weight instead, every load on the sheet is quietly wrong: taking 8% off a 64.8 g finished weight gives a higher load on wax than you meant, and the error shows up in a burn test rather than on the cost sheet. This page carries the wax-weight reading throughout and the SKU sheet below stores wax grams in every row.

Store the wick count, not the wick decision. Which wick a candle needs is settled by burn testing, not by a spreadsheet. Wide vessels commonly take more than one wick as general candle-making practice, and the only way to know your own number is to burn the thing. Put the tested count in the cell and move on.

Now multiply. The output sheet takes each SKU row, looks up each code on the rate sheet and produces four line costs and a total. Nothing below was typed: every figure is a rate from the table above times a quantity from the table before it.

Read the last column before the totals. Cost per gram of fill is ₹1.27 on the votive, ₹1.60 on the 150 and ₹1.14 on the large one: the vessel and the wick are fixed costs spread over fewer grams, so small candles cost less to make and more per gram, and the 150 sits highest because it carries a dearer vessel and a dearer oil at a higher load. None of that is visible from the totals, which is why the output sheet should carry the per-gram column.

There is one derived rate worth holding on to, and it is not the cost per candle. It is the cost of a gram of poured wax at a given load: the wax rate plus the load times the oil rate. At 8% with Citronella that is ₹0.74 a gram of wax, and at 10% with Woody Oud it is ₹0.96. Twenty SKUs sharing four recipes need four of these, not twenty, and with them you can cost a new size in one multiplication plus a vessel and a wick. Keep one per recipe, labelled with its load, and recompute it only when a rate or a load changes.

Building it in an afternoon

A fifth pass is optional and worth it once you are past a handful of products: add a batch-size column to the SKU sheet and an output column that multiplies the per-candle total by it. Batch totals are what you compare against a real purchase order, and they are the fastest way to catch a units error.

What happens when a price moves

This is the test the system exists to pass. A supplier price changes; you edit one cell on the rate sheet; every SKU that uses that material updates. Nothing else is touched, nothing is missed, and the size of the change is visible per product rather than buried in a new total.

Take an illustrative move of ₹50.00 a kilogram on the wax line — not a CSI figure, just a round number to show the mechanism. That is ₹0.05 a gram, so it lands on each SKU in proportion to its wax weight: ₹3.00 on the 60 g votive, ₹6.50 on the 130 g candle and ₹23.00 on the 460 g one. The large SKU absorbs roughly seven times the hit of the small one, which is exactly the kind of thing a single-sheet costing never tells you.

Now the version that is not illustrative, because it is sitting on the store today. The rate you record depends on the pack you buy, and switching packs is a price move like any other. Buying Luxury Soy Wax CSI 464 in 500 g packs instead of 1 kg or larger puts the wax rate at ₹0.52 a gram instead of ₹0.51, which lands as ₹0.76, ₹1.64 and ₹5.80 on the three SKUs. Buying Citronella in 100 gm packs instead of the 1 kg puts the oil rate at ₹7.67 a gram instead of ₹2.89, which is ₹22.94 on the votive and ₹175.87 on the large SKU. Buying Woody Oud at 50 gm instead of 1 kg is ₹11.66 on the Signature. Those are the live September 2026 rates, and they are why the pack column on Sheet 1 is not decoration.

Inbound freight, and the rows the sheet must leave empty

Getting materials to you is a real cost and it does not fit the rate sheet, because it depends on the whole order rather than on any one material. Handle it as a separate allocation: take the delivery charge on a real order and split it across that order by weight.

Here is one order, with packed weights taken from the store rather than from the label. A 5 kg pack of Luxury Soy Wax CSI 464 stores a packed weight of 6 kg, a 1 kg pack of Citronella 1.5 kg, a 1 kg pack of Woody Oud 1.5 kg and a pack of ten Clear Glass Jar with Golden Lid 3 kg — 12 kg together. The cheapest published band covering that weight in September 2026 is ₹1,200.00 on Standard Shipping. Sent as four separate parcels the same materials bill ₹1,260.00, a difference of ₹60.00. Rates are the published flat bands as at September 2026 and can change.

Allocate by weight and the wax, at half the parcel, carries ₹600.00 of it. Spread over the 5,000 g in the pack that is ₹0.12 a gram, taking the delivered wax rate from ₹0.51 to ₹0.63 a gram — ₹7.20, ₹15.60 and ₹55.20 a candle on the three SKUs, larger than most pack-size savings makers chase. Two reviews on the store say these charges are high, which is fair; the answer is to consolidate orders and carry the cost openly rather than leave it out of the sheet. Keep it in its own column, though — a per-gram rate should be reproducible from a product page, and a freight loading depends on what else was in the box.

Keeping it true: the four maintenance rules

Stamp the month on the rates. A rate sheet with no date is a rumour, and the person it misleads most is you in four months. When you refresh, keep the previous version rather than overwriting it: the difference between two dated sheets is the only honest answer to whether your costs are rising.

Recheck on a cadence, not on a feeling. Pick a rhythm you can actually keep — the month you place your regular order is the natural one — and always recheck before quoting a large order, before publishing a price list, and before the festive build. For Diwali on 8 November 2026, a candle that needs a 14 to 21 day cure plus delivery should be poured by about mid-October, which means the rates behind the October purchase order want checking in the last week of September. Availability moves as well as price, and a sheet that assumes a pack is in stock is a plan with a hole in it.

Never let the output sheet be edited. The moment somebody types over a computed cell to make a number look right, nobody knows which cells are still live. If a computed figure looks wrong, the answer is upstream: a rate, a quantity or a formula. Lock the output columns, or colour them and keep the rule by hand.

One last thing the sheet must not do: decide your fragrance load. Loads are bounded by what the wax page and the oil page state, and the lower of the two governs — Luxury Soy Wax CSI 464 states a maximum of 10% of total wax weight, the Woody Oud page states soy use of 6 to 10% and the Citronella page states up to 10%. A sheet will cost a candle at any percentage you type, including one above the stated ceiling, and it will look just as tidy. Keep a maximum-load column beside each oil on the rate sheet. Where a page publishes no range, ask on WhatsApp rather than putting an estimate in a cell.

Frequently asked questions