Building A Product Cost Sheet You Can Trust

Ask a founder what a product costs and you usually get one number. That number is almost always the factory gate price, quoted per unit, in an email, several months ago. It is not wrong. It is just the first line of a sheet that has fifteen more, and the missing lines are where the business actually lives.

A cost sheet you can trust is not a cleverer number. It is a structure. Build it once, in layers, so that when a supplier revises a quote or a platform revises a fee you know exactly which line moved.

Start with the bill of materials

The bill of materials lists every input that physically becomes the product, each with a quantity, a unit of measure, a rate and a wastage allowance. Quantity and unit of measure matter more than founders expect, because suppliers quote in their units and you sell in yours. Fabric is quoted per metre and consumed per garment with a cutting yield. Resin is quoted per kilogram and consumed per bottle at a part weight. Fragrance is quoted per kilogram and dosed at a percentage.

Two disciplines keep a BOM honest. Put wastage in as its own column rather than folding it into the rate, because wastage is a yield problem you can work on and a rate is not. And date every rate. A BOM with undated rates is a historical document pretending to be a plan.

Conversion cost is the line most people skip

Conversion is what it costs to turn the bill of materials into a finished unit. Labour, machine time, energy, consumables, quality checks, rework and the factory overhead recovery the supplier has loaded into your price. If you buy on a finished goods basis, conversion is already inside the quote and you cannot see it. Ask for the split anyway.

The reason is leverage. When a supplier cites input costs for a price increase, a visible split lets you test the claim against the material that actually moved. It also tells you whether a cost reduction opportunity sits in the material, the process or the run length.

Amortised tooling belongs here too. If you paid for a mould or a die, spread it across a realistic quantity and carry it as a line. Treating tooling as a one time capital event is why a first production run often fails to earn back what it seemed to promise.

Packaging is a product, not an afterthought

Packaging carries at least three layers and each one needs a line. Primary, which touches the product. Secondary, meaning the carton, sleeve, label, leaflet or insert. And tertiary, meaning the shipper, void fill, tape and pallet. Add the labelling requirements your category carries in India, which can mean an additional sticker, a separate leaflet or a market specific artwork variant.

Then add the line most sheets miss, which is the packing labour to assemble all of it. A gift set that looks like one SKU on the price list is often three components and a few minutes of hand assembly per unit. That is a real cost and it scales exactly when you are busiest.

Inbound freight and duties

Inbound is everything it costs to get goods from the supplier to your first storage point. For domestic supply that is freight, loading and unloading, insurance and any transit damage allowance. Convert it to a per unit basis using the actual load plan, because freight is charged by weight or volume and your cost per unit therefore depends on how well the product cubes out in a truck.

For imported goods there are more lines and more judgement. Customs duty applies according to the tariff classification of your specific goods, and both the classification and the applicable rate vary by product, by category and by any trade agreement in force. Do not carry an assumed percentage in your sheet. Get the classification confirmed by a customs broker or licensed clearing agent against the actual product, and take the rate from the tariff as it stands on the day. Alongside duty you will typically carry integrated tax on import, customs clearance and documentation charges, port or airport handling, container detention risk and inland transport from the port. Some of those are recoverable against output tax and some are not, and only the ones that are genuinely not recoverable belong in product cost.

Landed cost per sellable unit

Add the layers and you have landed cost. Two corrections separate a landed cost you can trust from one that flatters you.

The first is currency. If any input is imported, the sheet needs the exchange rate it was built on and a sensitivity view, because a quote that was comfortable at one rate can be uncomfortable at another and the change will not announce itself.

The second is yield. Divide by sellable units, not units produced. Rejections at inspection, damage in transit, short shipments and units consumed as samples or influencer seeding never reach a customer but their cost is already spent. A brand with a meaningful reject rate that divides by units produced is understating landed cost on every single unit it sells.

The channel stack sits on top

A factory gate number tells you nothing about whether a product works on a marketplace, because the marketplace adds its own layers. Build a second block, per channel, and stack it above landed cost.

Platform commission, which varies by category and often by price band. Fulfilment and shipping, including weight slabs and the dimensional weight rule that punishes bulky lightweight goods. Payment gateway or cash handling charges. A returns provision, built from your own return rate and the true cost of a return, which is forward shipping plus reverse shipping plus inspection plus the share of returned units that cannot be resold at full value. Storage fees where applicable. And a marketing cost per order, because for most D2C brands acquisition is a cost of sale rather than a discretionary overhead.

Run the block once per channel. The same product carries a different stack on a marketplace, on quick commerce, on your own website and in general trade. A cost sheet with a single channel block is answering a question you do not have.

Keeping the sheet honest

Version it, date it, and note the source and validity of every rate. Rebuild against actuals after the first production run and after the first full quarter, using invoices and settlement reports rather than assumptions. Keep the structure identical across every SKU so any two products compare line by line.

The output is not a single number. It is a sheet where you can point at any line, say where it came from and when it was last verified, and see immediately which layer moved when the economics change.