Allocation method
Allocate landed cost by weight
Air and courier freight is billed per kilogram. Give each line the share of the bill its kilograms caused — and refuse to run when a weight is missing.
The rule in one paragraph
A cost allocated by weight is split in proportion to each received line’s total weight (received quantity × weight per unit). If any received line has no weight, the run stops and names the SKUs: a blank weight is not zero kilograms, it is a missing number.
Why the obvious shortcut is wrong
Freight by value makes a 55 g strap that happens to be pricey pay for the heavy steel stakes. Freight by quantity charges the strap the same as a 960 g stake set. The forwarder weighed the cartons; use the weights. And never let a missing weight silently take 0% — that pushes the whole bill onto the other lines and nobody notices.
A worked example
PO-2214: 1,860.00 of air freight across lanterns, straps and stakes
Total weight 456.5 kg. The stakes are 300 × 960 g = 288 kg, so they carry 63% of the freight although they are only 19% of the units.
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Freight | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|
| OD-LAMP-01 | Camping lantern | 250 | 0 | 7.80 | 1950.00 | 417.63 | 417.63 | 2367.63 | 9.47 | 21.4% | 9.47 |
| OD-STRAP-02 | Webbing strap 2 m | 1200 | 0 | 0.62 | 744.00 | 268.92 | 268.92 | 1012.92 | 0.84 | 36.1% | 0.84 |
| OD-STAKE-03 | Steel tent stake (set of 8) | 300 | 0 | 2.35 | 705.00 | 1173.45 | 1173.45 | 1878.45 | 6.26 | 166.4% | 6.26 |
| Total · 3 lines | 1750 | 0 | 3399.00 | 1860.00 | 1860.00 | 5259.00 | ×1.5472 | 54.7% | |||
Same shipment with one weight missing
Remove the strap’s weight and the allocator refuses to run. Some calculators would allocate 0.00 to the strap and 1,860.00 to the other two lines — a quiet overstatement of the lantern and stake cost. Try it in the mini allocator below: clear the strap weight and press Allocate.
What we record
- Weight per unit (grams) and the basis total in kg.
- The SKUs that blocked a run, and the switch you made (to quantity) if you made one.
- Rejected units: they weigh something, but they take no share because you did not receive them.
If you only remember one thing
What the carrier billed by the kilo, you allocate by the kilo. A missing weight stops the run instead of hiding in a zero.
Try it
Change any number — the stamp stays balanced
Every cost line in this mini allocator is locked to “by weight”. The full allocator on the home page lets each bill pick its own method.
01Receipt lines
02Payments & exchange rate
03Costs to allocate
Each bill picks its own method. Defaults follow what moves the cost: freight by weight, duty by value, brokerage per unit.Duty: use the amount on your customs entry (CBP 7501 line totals); this tool does not classify HS codes. MPF: use the amount printed on the entry — the prefill is the 0.3464% ad valorem part before the yearly minimum and maximum.
04Landed cost by SKU
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Freight | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|
| OD-LAMP-01 | Camping lantern | 250 | 0 | 7.80 | 1950.00 | 417.63 | 417.63 | 2367.63 | 9.47 | 21.4% | 9.47 |
| OD-STRAP-02 | Webbing strap 2 m | 1200 | 0 | 0.62 | 744.00 | 268.92 | 268.92 | 1012.92 | 0.84 | 36.1% | 0.84 |
| OD-STAKE-03 | Steel tent stake (set of 8) | 300 | 0 | 2.35 | 705.00 | 1173.45 | 1173.45 | 1878.45 | 6.26 | 166.4% | 6.26 |
| Total · 3 lines | 1750 | 0 | 3399.00 | 1860.00 | 1860.00 | 5259.00 | ×1.5472 | 54.7% | |||
| Cost line | Method | Bill | In USD | Allocated | Closes |
|---|---|---|---|---|---|
| Air freight SZX → LAX · International freight | By weight | 1860.00 USD | 1860.00 | 1860.00 | Σ to the cent |