Allocating freight by value, cube, weight or quantity

Twenty sofas, forty dining chairs, and ten coffee tables share a shipment. Allocate an illustrative $9,336.84 of shared charges by merchandise value and each table carries about $155.61. Allocate it by packed cube and the table carries about $100.04. The shipment has not changed, but the table's apparent profitability has.

Freight allocation is a choice about how to assign a real cost. The best basis follows what caused the charge and can be repeated on the next comparable shipment. This guide compares the methods before showing a mixed approach that suits the example load.

Define the goods and the charge before calculating shares

Start with the shipment population. Identify which PO lines traveled together and which invoices cover them. A delivery charge for one vendor's crate should not be spread across every piece received that day.

Here is the sample load. All measurements, weights, prices, and charges in the calculations are assumed for this example.

The $9,336.84 charge pool is deliberately held constant while the methods change. Comparing the methods does not mean every fee should ultimately use the same basis.

The landed-cost guide explains which costs belong in the pool. Inbound freight is part of merchandise cost in the IRS's cost-of-goods guidance; the allocation then connects that cost to the goods.

Allocate by value when value explains the charge

Value allocation gives each line its share of total merchandise value:

Line share = line merchandise value ÷ covered merchandise value × charge.

The sofas represent $40,000 of the $60,000 merchandise total. They receive two-thirds of the shared charge, or $6,224.56. The chairs and tables each represent $10,000, so each group receives $1,556.14.

That produces about $311.23 per sofa, $38.90 per chair, and $155.61 per table. Value can be useful for insurance or a fee connected to declared value. It is less convincing for a transport charge driven mostly by occupied space.

Check which value the invoice actually uses. Purchase value, insured value, and customs value are not interchangeable labels. Use a consistent, documented basis for the particular cost being allocated.

Allocate by cube when space explains the freight

Cube allocation gives each line its share of packed shipping volume:

Line share = line packed volume ÷ covered packed volume × charge.

The sofas use 40 of 56 cubic meters, the chairs use 10, and the tables use 6. On the same charge pool, the group shares are $6,669.17, $1,667.29, and $1,000.38 after rounding. Those sum to $9,336.84.

Per piece, the allocated amounts are about $333.46 for a sofa, $41.68 for a chair, and $100.04 for a table. The sofas and chairs take more of the bill than they did under value allocation because they occupy more space relative to their price.

Use packed dimensions from the vendor's packing list or carton specifications. The displayed size of a dining table is not necessarily its shipping cube: the legs might be removed, the top crated separately, or several components nested together. A chair can become surprisingly spacious once it has put its cardboard coat on.

If cube is missing, ask for carton measurements. Use a clearly documented temporary basis while waiting, or adopt a consistent alternative your reviewer can defend. Do not enter guessed dimensions merely to make the calculation look more exact.

Use quantity for costs that are truly per piece

Quantity allocation gives each unit the same share. Across the example's 70 pieces, the pool averages about $133.38 per unit.

That can fit a service charged equally for each piece, such as an agreed per-unit handling task. It is a poor explanation for space-driven freight when a chair receives the same amount as a sofa.

The chair would carry $133.38 of shared cost on a $250 vendor price before any direct charges. That result is not mathematically wrong. It is a signal to ask whether equal units explain the actual invoice.

Be precise about the unit. One carton is not always one furniture piece, and a dining set is not necessarily one handling unit. If the service is charged per carton, use the carton count behind the charge rather than a convenient sales quantity.

Use weight when mass explains the charge

Weight allocation uses each line's share of the covered shipment's weight. In the example, sofas contribute 1,200 kg, chairs 400 kg, and tables 400 kg.

The same $9,336.84 pool becomes $5,602.10 for sofas, $1,867.37 for chairs, and $1,867.37 for tables. Per unit, that is about $280.11, $46.68, and $186.74.

A dense table receives more than under cube because it represents a greater share of weight than space. Weight can help explain a weight-based transport leg, but an LTL rate can also depend on classification, density, minimums, and services. Follow the charge's structure rather than assuming that every truck invoice is simply a price per kilogram.

Displayed unit averages are rounded. Reconcile the actual group allocations to the invoice, rather than multiplying rounded averages and creating a stray cent.

Use different methods for different charges

Yes, different charges on the same PO can use different methods. A mixed approach often explains the invoices better than one blanket rule.

Suppose $8,514 of the pool is space-driven freight and drayage, while $822.84 represents charges allocated by value for this example. Allocate the first amount by cube and the second by value.

The resulting shared cost is about $331.50 per sofa, $41.44 per chair, and $104.94 per table. Add each piece's vendor cost and direct charges afterward.

Do not put duty into a common pool merely to simplify the spreadsheet. Your allocation method does not alter customs liability. Keep the broker's entry-line duty with the products that incurred it. Use the freight-and-duty comparison to examine the total effect on product cost.

Enter supported shares in OrderPilot

The charge dialog lets purchasing staff choose the amount, scope, and allocation method, then review the resulting line costs. A charge can cover the PO or selected lines. Use manual amounts for cube calculations. Enter the group totals, not rounded per-unit averages, and reconcile them to the charge. OrderPilot requires the manual amounts to match the total before the split can be saved. The by-weight control is disabled because PO unit weights are not currently recorded; calculate a justified weight split from shipping documents and enter its line amounts manually. The saved charge then preserves the intended distribution alongside the purchase.

Revisit the basis when units are rejected

Rejected units receive no allocation of a whole-PO charge in OrderPilot's kept-unit calculation. The remaining charge is redistributed across kept units; manual amounts retain their entered split. Review the result when the receiving population changes.

Establish whether any transport cost is recoverable and how the store will account for the loss. A rejection alone does not reduce the carrier invoice or create a cash refund. Keep the claim and the supported cost adjustment connected through the receiving-corrections workflow.

Write the chosen rule beside each charge type and use it on comparable shipments. Before the next booking, review the ocean-freight options and the consolidation guide so the allocation begins with a well-understood shipping arrangement.

Sources

1. Publication 334: freight-in and cost of goods sold — Internal Revenue Service, 2023 tax-year edition.