How to add transport costs to your product prices
If transport isn't in the unit cost, it's coming out of your margin.
· 4 min read
Many supplier invoices end with one line for transport: a pallet charge, delivery, Transportkosten. It is easy to pay it and forget it. But it is part of what every product on that invoice cost you — the landed cost — and if your selling price ignores it, it comes out of your margin.
The simple way: a transport percentage
For a mixed delivery, spread the transport in proportion to value: transport % = transport ÷ goods total. Goods of €12,000 with €600 transport is 5%. Each product's unit cost then rises 5%: a €0.70 unit becomes €0.735.
When to use weight instead
If one delivery mixes heavy, cheap products (flour, rice, oil) with light, expensive ones (spices, saffron), spreading by value puts too little transport on the heavy goods. For those deliveries, spread by weight or by case instead. For a typical grocery delivery, a percentage by value is close enough and easy to keep up to date.
How SAMZY does it
Put the transport percentage in its own column of your template, next to the item cost, and make the cost with transport a formula: item cost × (1 + transport %). Every product you bring in from an invoice gets it automatically, and your markups start from the full cost. Change the percentage once and every price in the sheet follows. Remember to delete the transport line itself from the product rows.
Questions
- What is landed cost?
- The full cost of a product once it is in your shop: the supplier price plus your share of transport and any other charges to get it there.
- How do I spread transport over many products?
- Divide the transport by the goods total to get a percentage, then add that percentage to each product's unit cost.
