Allocate Shared Freight Across a Mixed 1688 Order

A mixed 1688 order can contain inexpensive bulky organizers, compact metal parts, and high-value accessories in the same shipment. Dividing every transport charge by purchase value makes the expensive accessories carry most of the freight. Dividing by unit count can make a tiny component carry the same amount as a large carton. Neither result necessarily explains what caused the bill.

For purchasing decisions, first assign identifiable charges directly. Then divide each genuinely shared charge using a driver that fits that charge. Keep the method, measurements, and assumptions alongside the result. This produces a usable management-cost estimate without pretending that one formula is a universal accounting or customs rule.

Start with the invoice, not the SKU formula

Make a charge register before allocating anything. For each line, record the currency, supplier or carrier, shipment stage, amount, whether it is estimated or final, and which goods it covers. Separate domestic collection, consolidation handling, international transport, insurance, destination handling, delivery, and any other quoted service.

A special crate bought only for one fragile product belongs to that product. Collection from one supplier belongs to that supplier’s goods before any further split between its SKUs. A fee for checking every ordered line can reasonably follow the number of inspected lines if that matches the agreed service. Do not hide those direct costs inside a shared freight pool merely because they appear on the same invoice.

An unquoted amount is unknown, not zero. Also identify exclusions. A transport allocation does not by itself include duties, taxes, purchasing fees, defects, or exchange-rate differences. If a landed-cost sheet includes those items, give them separate rows and their own treatment. Ask your accountant or customs adviser about statutory valuation rather than reusing a management allocation automatically.

Match each shared pool to its cost driver

For a weight-driven pool, consider each SKU’s share of relevant packed weight. For a space-driven pool, consider packed volume. For transport sold on chargeable weight, use the forwarder’s assessed basis where available. UPS explains that dimensional weight reflects occupied space and can affect charges for relatively bulky packages; its published calculation is specific to its rate system. Do not transplant a parcel divisor into an unrelated freight quote. UPS dimensional-weight guidance

Value allocation can be appropriate for a genuinely value-based charge. It can also be a conscious management policy when measurement is unavailable. Label that choice clearly: product value is not evidence that a product caused transport capacity to be consumed.

Equal allocation is most defensible when the underlying service is equal per relevant unit, order, or shipment. Define the denominator. Equal per supplier is different from equal per carton, and equal per carton becomes misleading when carton sizes differ substantially.

When goods share cartons, obtain the packing breakdown. A carton’s total weight or volume cannot be assigned fully to every SKU inside it. If you estimate the division from item measurements, identify the estimate and preserve the carton total. Include packaging in the measurement basis rather than quietly treating product-only dimensions as finished shipping dimensions.

Compare two methods using the same fictional order

The following amounts and measurements are invented to illustrate the arithmetic. They are not current prices or a savings claim. Assume all monetary amounts use USD, the direct costs are complete for this example, and the shared freight total is 120.

The attributed volume is a hypothetical allocation input, rather than the result of measuring two cartons after consolidation. For a real order, document how shared void space and outer packaging were allocated so the inputs can be understood.

By gross weight, A takes 12 / 20 × 120 = 72 of freight, and B takes 8 / 20 × 120 = 48. Their planning cost per unit becomes (200 + 72) / 100 = 2.72 for A and (100 + 48) / 20 = 7.40 for B.

By attributed packed volume, A takes 0.02 / 0.10 × 120 = 24, and B takes 0.08 / 0.10 × 120 = 96. Per-unit planning costs become 2.24 for A and 9.80 for B. Both methods reconcile to the same 420 total. The different result describes how the cost is assigned, not a change in the amount you pay.

A useful sensitivity check is to change one packing assumption while holding the shared bill fixed. If B’s attributed volume rises from 0.08 to 0.10 cubic metres and A remains at 0.02, B receives 0.10 / 0.12 × USD 120 = USD 100 rather than USD 96. That is a change in allocation. Whether the carrier’s total also rises requires its actual rate structure; a minimum or fixed-container charge may behave differently.

Keep allocation separate from the cost of adding one more product

An allocated cost answers, “How much of this shipment should this SKU carry?” It does not answer, “How much cash would disappear if I removed this SKU?” A product can receive a share of a fixed shipment charge even when removing it would not lower the carrier’s invoice.

For a reorder decision, request a with-and-without quote or model the confirmed rate structure. Compare the incremental cash change with the allocation. For pricing and margin reporting, a stable allocation may be useful. For deciding whether to add a carton to unused capacity, incremental cost may be more relevant. Keep both views instead of forcing one number to serve incompatible questions.

Close the estimate after dispatch

Freeze the pre-shipment estimate, then create a final version using actual packing measurements and billed charges. Explain differences by cause: quantity, packaging, measurement correction, service change, or additional handling. Do not overwrite the estimate and lose the explanation.

Use these final checks before approving the sheet:

• Every invoice line appears once, with no hidden duplication
• Every shared pool has a stated denominator and units
• Allocated amounts reconcile to the billed total after rounding
• Direct costs remain traceable to the relevant products
• Per-unit results state whether the denominator is ordered, received, or saleable units
• Estimated inputs remain visibly marked until verified

For a sourcing enquiry, provide the SKU list, supplier grouping, carton breakdown, and itemized freight quote. Ask for the missing measurements and charge definitions before asking someone to produce a precise per-unit shipping cost.