How to Build a Landed Cost Model for a Lighting Order

Landed cost is the number a buyer needs in order to set a retail price, and it is the number a supplier's quotation carefully does not provide. Building it once, properly, changes every subsequent negotiation.

The structure

Build it as a chain, per unit, and keep each line visible so the model can be audited when a rate changes:

Freight is per cubic metre, not per lamp

Lamps are bulky, so the freight line scales with packaging volume. This is why a two-piece base or a shorter carton changes the model more than a five percent price concession at the factory, and why buyers who own the packaging design usually have the cheaper product.

Duty is a range, not a number

The duty line depends on classification, origin and whatever additional measures are in force at the time. Model it as a variable with a conservative value, then confirm the current position with a customs broker before advising a retail price.

Include the cost of a wrong forecast

Two more lines belong in the model, even though nobody likes them: the cost of carrying slow stock, and the discount required to clear it. Buyers who include them make different decisions about the assortment and about how much to import.

Use it to compare sources

Run the same model for a direct import and for a domestic stockist. The comparison is only meaningful when both use identical assumptions for freight, duty and damage, and the conclusion frequently changes once they do.

The lines buyers forget

A landed cost model that only carries unit price, freight and duty will consistently understate the real figure. The omitted lines are usually small individually and significant in aggregate, and they fall across different budgets — which is why nobody reconciles them and why the total keeps surprising people.

Build the list before the order, not after. A model assembled from last year's returns data and warehouse logs beats a model assembled from memory.

1. Take the returns rate for the category and multiply it by the true cost of a return, not the refund value
2. Add warranty claims as a handling cost per claim, not as a cost of goods
3. Add the carrying cost of the stock you hold, including the slow movers
4. Add freight, duty and the oversize surcharges you actually paid last year
5. Add the staff hours spent chasing suppliers and administering claims

Frequently asked questions

What should a landed-cost model for lamps include

A useful landed-cost model adds product cost, factory freight to port, ocean or air freight, insurance, customs duties including any Section 301 additional duty, brokerage, last-mile delivery, and a share of packaging and quality-control cost. Only when all of those are in does the number you quote to a customer stay true if a single input moves.

Why does my ex-works price not match my real cost

Ex-works is only the factory gate. By the time a lamp reaches your warehouse or customer it has absorbed freight, duty, insurance, and handling that can be a large share of the total. Quoting on ex-works alone hides that spread and can erase margin on a long or volatile lane.

How often should I rerun the model

Rerun it whenever a key input changes: a freight-rate move, a tariff adjustment, an exchange-rate shift, or a packaging change. A model that is only built once drifts out of date and quietly misprices the assortment.