Export Price Calculation for Mixed-SKU Orders: Allocate Freight Without Hiding Losses

A reliable export price calculation must show more than whether the shipment makes money overall. For mixed-SKU orders, it must also reveal which products consume freight capacity, trigger handling charges and recover their allocated costs.

Dividing every shipment expense by the total number of units is convenient. But a small metal component, a bulky display unit and a fragile accessory rarely create equal logistics costs. An average allocation can make one product subsidise another without anyone noticing.

For exporters quoting distributors, the practical solution is to separate cost pools, assign defensible allocation drivers and make the quotation conditional on the agreed product mix.

Why export price calculation needs SKU-level visibility

An order can remain profitable while individual products sell below their allocated cost. That matters when distributors reorder selectively, substitute products or negotiate prices using the previous quotation as a reference.

Equal-per-unit allocation is reasonable when units consume the relevant resources similarly or when the charge itself is assessed per unit. Otherwise, it can:

• Underprice bulky or heavy products.
• Overprice compact, efficient products.
• Hide product-specific packing or handling expenses.
• Produce misleading margins when quantities change.

Mixed-SKU pricing therefore needs two views: total order profitability and SKU-level profitability after allocation.

Neither view replaces the other. Allocated costs can expose cross-subsidies, but an allocated loss does not automatically mean removing that SKU improves the remaining order. Freight minimums and fixed charges may remain. Any margin analysis should also state which costs it includes.

Build the input sheet before requesting freight

Use one row per SKU, with logistics measurements based on its actual export packing rather than the unpacked product.

Product and packing inputs

Collect:

• SKU code, description and sales unit.
• Ordered quantity and units per export carton.
• Production or purchase cost per unit.
• Export packaging cost, unless already included.
• Packed carton dimensions and gross weight.
• Carton count, total cubic volume and total gross weight.
• Pallet footprint, loaded height and stacking restrictions.
• Product-specific handling requirements and charges.

Calculate volume using consistent units. For identical rectangular cartons measured in metres:

SKU volume = carton length × width × height × carton count

If carton sizes differ, calculate each size separately and add the results. Use the final palletised dimensions where those determine the freight charge, rather than relying solely on carton volume.

Round carton counts and pallet requirements to actual packing configurations. A spreadsheet showing a fractional carton may underestimate the shipment unless split-carton packing is genuinely available.

Commercial and logistics inputs

Record the quotation currency, exchange-rate assumption where relevant, proposed unit prices, freight quotation reference, validity and applicable minimum charges.

Keep direct product costs separate from shipment costs. This prevents packaging, loading or handling from appearing in both pools. Identify other seller-borne expenses, such as payment fees or commissions, where relevant to the margin being measured.

If you are preparing your first export quotation, establish this input discipline before sending a multi-product offer. Freight allocation cannot correct missing measurements.

Define the seller’s cost scope first

Use the agreed Incoterms rule, named place or port, and applicable version to establish the delivery-cost boundary. Check the sales contract and logistics quotation for the seller’s actual obligations and any separately agreed services. Incoterms rules do not determine every commercial term or cost of a sale.

Include seller-borne costs within that scope. Keep buyer-borne freight, clearance, duties or onward delivery outside the seller’s cost calculation unless the seller has expressly agreed to bear them. If the seller pays a charge on the buyer’s behalf, account for the charge and its reimbursement separately.

Do not rely on a broad label such as “export freight.” Break the logistics quotation into identifiable charges: collection, terminal handling, main carriage, documentation, insurance where applicable, and other relevant services.

Before allocating anything, confirm:

• Who ultimately bears each charge?
• What service and route does it cover?
• Is it fixed, variable, minimum-based or conditional?
• Is it already included elsewhere?

An accurate allocation of the wrong cost scope still produces an unreliable pricing basis.

Allocate each cost pool by its actual driver

For a shared cost pool, use:

SKU allocation = total cost pool × SKU driver quantity ÷ total driver quantity

Apply that formula separately to each pool, using a nonzero total driver quantity. Export freight cost allocation becomes unreliable when unrelated expenses are bundled under one driver.

Weight, volume and chargeable weight

Use gross weight when the quoted service is weight-rated. Use cubic volume when the relevant charge follows shipment volume.

For services using chargeable weight, follow the forwarder’s actual dimensional conversion, aggregation and minimum-charge rules. Do not assume one universal conversion factor or that separately calculated SKU chargeable weights always sum to the billed shipment weight.

Where billing is nonlinear, reconcile the allocated amounts to the actual shipment charge and document the method used to distribute any residual. This allocation supports pricing analysis; it does not necessarily measure the freight savings from removing a SKU.

Pallet positions and restricted capacity

Allocate pallet-rated charges by occupied positions, accounting for stacking restrictions. A non-stackable load can consume more paid capacity than its cubic volume suggests.

For mixed pallets, use a documented space-usage method rather than charging every SKU for a whole pallet. Identify unused capacity separately before deciding how to distribute its cost.

Documentation and product-specific work

Shipment-level documentation often has no direct relationship to weight or volume. Allocate it consistently by order line, quantity or another documented policy appropriate to the work involved.

Treat this as a policy allocation, not proof that each SKU caused the charge. If a particular product requires separate documentation or special handling, assign that incremental expense directly to that product.

The operating rule is straightforward: trace direct costs first, then allocate shared costs.

Hypothetical quotation: the average hides a loss

The following figures are illustrative, not market rates. All amounts are in USD. Assume the agreed seller scope contains the packed product costs and logistics charges shown. This simplified example excludes any other costs; its results are not net profit figures.

The order contains 100 units of each SKU. Freight is volume-rated at $90 per cubic metre, subject to a $600 shipment minimum. At 10 cubic metres, freight totals $900. Documentation costs $90, and SKU B requires $150 of special handling.

| Input | SKU A: compact | SKU B: bulky | SKU C: medium | |---|---:|---:|---:| | Quantity | 100 | 100 | 100 | | Packed product cost/unit | $8.00 | $12.00 | $6.00 | | Selling price/unit | $12.00 | $18.00 | $11.00 | | Total packed volume | 1 m³ | 6 m³ | 3 m³ |

Total revenue is $4,100. Packed product costs total $2,600, while logistics costs total $1,140. The order therefore produces $360 before any costs outside this example.

Method 1: spread everything evenly

Dividing $1,140 by 300 units assigns $3.80 to every unit.

| Result | SKU A | SKU B | SKU C | |---|---:|---:|---:| | Allocated logistics/unit | $3.80 | $3.80 | $3.80 | | Product + allocated logistics cost/unit | $11.80 | $15.80 | $9.80 | | SKU result | $20 | $220 | $120 |

Every SKU appears profitable within the example’s cost scope. However, the equal allocation shifts part of bulky SKU B’s freight and special handling costs onto the other products.

Method 2: allocate by defensible drivers

Allocate freight by volume, documentation equally across the three order lines, and special handling directly to SKU B.

| Cost or result | SKU A | SKU B | SKU C | |---|---:|---:|---:| | Freight allocation | $90 | $540 | $270 | | Documentation allocation | $30 | $30 | $30 | | Direct special handling | $0 | $150 | $0 | | Total logistics allocation | $120 | $720 | $300 | | Product + allocated logistics cost/unit | $9.20 | $19.20 | $9.00 | | SKU result | $280 | −$120 | $200 |

The order still produces $360. Allocation has not changed the total; it has revealed that SKU B does not recover its attributed costs at the quoted price under this method.

Use that visibility to review packing, product pricing or the commercial rationale for accepting the mix.

Recalculate when the buyer changes the mix

Suppose the buyer removes SKU B, with all other example assumptions unchanged. Volume falls to 4 cubic metres, but freight does not fall to $360: the hypothetical $600 minimum applies. Documentation remains $90, while B’s special handling disappears.

Allocating the $600 freight by the remaining volumes gives A $150 and C $450. Splitting documentation between the two remaining lines adds $45 each.

The remaining order generates $2,300 revenue against $1,400 product costs and $690 logistics costs: a $210 result, down from $360.

Removing the SKU with an allocated loss did not improve the total order result because freight costs did not fall proportionately. This is why allocated SKU margins and incremental order economics must be reviewed together.

After any substitution or quantity change:

• Rebuild carton counts, dimensions, weights and pallet positions.
• Recheck freight minimums, rate tiers and capacity limits.
• Remove only charges that genuinely disappear.
• Identify unused paid capacity.
• Reallocate the revised charges.
• Compare both SKU margins and the total order result.

Also distinguish margin from markup. Margin equals profit divided by selling price; markup equals profit divided by cost. Define the costs included in that profit figure and use the intended measure consistently in pricing formulas.

Present a quotation that protects the assumptions

Your export quotation template should connect unit prices to a defined shipment configuration, not suggest they apply to any future combination.

Include:

• SKU quantities, unit prices and total order value.
• Currency, payment terms and quotation validity.
• Agreed Incoterms rule, named place or port, and applicable version.
• Packing configuration and stacking assumptions.
• Included seller-borne services and stated exclusions.
• Changes that require freight verification and revised pricing.

Suggested wording: “Prices apply to the listed quantities and packing configuration shipped together. Changes to product mix, quantities, packing, destination or delivery requirements may require a revised quotation.”

Agree any revised pricing with the buyer before accepting or implementing the change, consistent with the contract. A quotation note is not a substitute for agreed change-control terms.

For distributor orders, retain the internal cost sheet alongside the customer-facing quotation. Buyers need clear commercial terms; your team needs the allocation logic for repeat orders.

FAQ

Should freight always be allocated by weight?

No. Use the quoted service’s cost driver, which may be weight, volume, chargeable weight or pallet positions. Account for minimum charges and allocate other cost pools separately.

Is equal-per-unit allocation ever acceptable?

Yes, when units consume the relevant resources similarly or the charge is assessed per unit. It is unreliable across products with materially different logistics requirements unless the billing basis justifies it.

Does an allocated SKU loss mean I should reject that product?

Not automatically. Check which costs would disappear without it and recalculate the remaining shipment. Fixed charges and freight minimums can change the decision.

When should a mixed-SKU quotation be revised?

Recheck it whenever quantities, product mix, packing, destination or delivery requirements change. Propose revised prices when those changes invalidate the original cost assumptions, subject to the agreed contract terms.

Put a transparent quotation behind your next trade connection

Accurate allocation makes potential cross-subsidies visible and gives your team a defensible basis for quoting changed orders. To explore your next B2B trade opportunity, visit IMEX Center, then build the quotation around the actual product mix and shipment requirements.