darikwaLanded cost per purchase order
Enter a purchase order's lines and its freight, insurance, duty and clearance to see the landed cost per unit, the uplift on the supplier price, and the margin each line makes at its retail price. Download it as an Excel workbook for the next order.
- 1.The landed cost per unit of every line on the order.
- 2.How much freight, insurance, duty and clearance added.
- 3.The margin each line makes at retail, on its landed cost.
- 4.Which lines fall below your target margin.
| # | SKU | Landed per unit | Margin at retail | Uplift on goods | Goods (£) | Freight + insurance | Duty | Clearance | Description | Units | Supplier unit price (order currency) | Duty rate (blank = order rate) | Retail price inc VAT (£) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| £18.76 | 71.5% | 21.6% | £6,170 | £478 | £798 | £58 | |||||||
| £18.76 | 71.5% | 21.6% | £4,628 | £359 | £598 | £44 | |||||||
| £21.82 | 72.4% | 21.6% | £4,306 | £334 | £557 | £41 | |||||||
| £14.74 | 72.8% | 21.6% | £1,818 | £141 | £235 | £17 | |||||||
| £28.24 | 71.8% | 21.6% | £6,036 | £468 | £781 | £57 | |||||||
| £45.81 | 54.2% | 11.9% | £2,455 | £190 | £79 | £23 | |||||||
Take it into Excel
The download carries your rows and the same rules as live Excel formulas, so it keeps working as you add lines: yellow cells for your data, blue-grey cells calculated, drop-down lists, red and amber flags, frozen headers and filters. Tabs: Start here · Settings (rate, freight, duty) · Lines (with allocation) · Order summary.
Your data never leaves this browser: nothing is uploaded, and the workbook is built on your device. Copy rows from Excel or Google Sheets and paste into any cell; include the header row to match columns by name.