Free shipment allocation worksheet

Landed Cost Calculator

One freight bill, several products. Allocate the shipment’s shared costs and see the landed cost for every SKU and unit.

Created by BiznToolsFounder: Syed TalhaMethod checked

One shipment

Start with your products

Use the supplier price for one unit. Add another SKU only if your shipment needs it.

Item 1
Quantity × unit cost

Duty & included tax Optional

Enter amounts for this whole SKU row. Include only non-recoverable tax you have chosen to count as cost; no rates or tax treatment are calculated.

Shared shipment charges

Amounts for the whole shipment. Count each charge once; blank optional charges mean 0.

Insurance, clearance & other costs Optional

Choose how costs are split

Split in proportion to quantity × supplier unit cost. A higher-value row receives a larger share. All five shared charges use this basis.

Currency is a display label. Values are not converted. Examples use made-up costs.

Private to this tab. Your costs and SKU names are not sent or saved automatically.

From a shipment invoice to a usable unit cost

The supplier’s unit price is only the goods cost. Shared freight and fees belong to the whole shipment; this worksheet assigns them to each SKU using your selected basis. Enter row duty and included tax amounts separately, once. Every allocated charge and SKU total reconciles to the shipment.

Goods cost

Quantity × supplier unit cost

Match the quantity to the unit your supplier priced. A price per carton needs a quantity in cartons.

Shared charge quota

Charge × SKU basis ÷ total shipment basis

The selected basis assigns a share to every SKU. Each charge is then reconciled to whole cents.

SKU landed total

Goods + allocated shared charges + entered duty + included tax

Only the costs you enter are included. Duty and tax are row amounts you have already determined.

Two products, one freight bill

These synthetic figures show why the allocation basis changes a SKU’s cost while keeping the shipment total the same.

USD 300 goods + USD 30 freight

Ten small items cost USD 10 each; ten large items cost USD 20 each. Purchase value assigns one-third of the freight to the small items and two-thirds to the large items.

Small item / SKU A

100.00 goods + 10.00 freight = 110.00 landed total.
110.00 ÷ 10 units = USD 11.00 per unit.

Large item / SKU B

200.00 goods + 20.00 freight = 220.00 landed total.
220.00 ÷ 10 units = USD 22.00 per unit.

110.00 + 220.00 = USD 330.00 shipment total

Change the split to Units

Each ten-unit row receives USD 15 freight. The small item becomes USD 11.50 per unit and the large item USD 21.50. Their totals, USD 115 + USD 215, still reconcile to USD 330. The example also supplies made-up total row weights of 1 kg / 3 kg and volumes of 0.5 m³ / 1.5 m³ so you can compare all four bases.

Compare all four allocation bases

Same two products, same USD 30 freight charge. Only the way that charge is split changes. Weights and volumes below are totals for each ten-unit row, including the packaging you choose to include.

  • Purchase value

    A: 100 / 300 · B: 200 / 300

    SKU A / unit
    USD 11.00
    SKU B / unit
    USD 22.00
    Freight to A / B
    10.00 / 20.00

    The higher-value line receives twice the share.

  • Units

    A: 10 / 20 · B: 10 / 20

    SKU A / unit
    USD 11.50
    SKU B / unit
    USD 21.50
    Freight to A / B
    15.00 / 15.00

    Equal quantities receive equal shares.

  • Weight

    A: 1 / 4 kg · B: 3 / 4 kg

    SKU A / unit
    USD 10.75
    SKU B / unit
    USD 22.25
    Freight to A / B
    7.50 / 22.50

    Row B weighs three times as much as row A.

  • Volume

    A: 0.5 / 2 m³ · B: 1.5 / 2 m³

    SKU A / unit
    USD 10.75
    SKU B / unit
    USD 22.25
    Freight to A / B
    7.50 / 22.50

    The volume ratio matches the weight ratio in this example.

Every split reconciles to USD 330.00: USD 300 goods + USD 30 freight. A cheaper cost for one SKU means more of the same charge is assigned to the other SKU.

Choose a basis that fits the cost and your documented costing approach. Weight can help compare weight-driven freight; value can help compare value-driven charges. This worksheet applies one selected basis to all shared charges. Enter duty and nonrecoverable tax as row amounts you have already checked.

From landed cost per unit to a wholesale price

Your supplier’s price is the starting cost. Freight and other included charges raise what each unit costs before you sell it. After allocating a USD shipment, choose “Check wholesale pricing” on a SKU to use its landed unit cost in a private worksheet on this page.

1. Use the complete cost basis

Start with the selected SKU’s landed cost. Add other included selling costs once if they belong in your pricing basis. Use the same unit throughout: a carton cost needs a carton selling price.

2. Check both margins

Your minimum wholesale price must cover your entered margin. The retailer’s maximum must leave their entered margin at the known retail price. A range exists only where both bounds overlap.

3. Keep the decision

Check an actual quote, then download the wholesale worksheet as CSV. Keep the shipment worksheet separately to reconcile exact SKU totals; rounded unit costs can differ when multiplied back.

A USD 11 cost becomes a USD 22–30 range

Use the small SKU from the example above: USD 110 landed total ÷ 10 units = USD 11 per unit. A 50% maker margin gives a USD 22 minimum. At USD 50 retail and a 40% retailer margin, the ceiling is USD 30. A USD 25 quote gives the maker 56% margin and the retailer 50% margin. These are fictional choices, not recommended margins.

Already have your unit cost? Use the Wholesale Price Calculator directly. Pricing from a percentage added to cost uses markup; checking an agreed selling price uses profit margin.

Keep the next decision clear

These printable references connect a checked cost to the next question. They use synthetic examples and work without entering your shipment details.

Pricing decision sheet

Carry a reconciled unit cost into the appropriate markup, margin or wholesale calculation. Check which selling costs still need to be included.

Download pricing sheet

Inventory replenishment map

Separate your stock buffer, order trigger, order quantity and arrival-date checks before reviewing the chosen shipment.

Download inventory map

Before you use the cost for pricing

Which allocation basis should I use?

Use a basis that reflects the charge and your consistent costing approach. Units treats every piece equally; purchase value follows supplier spend; weight and volume follow the total physical measure for each row. The default is a starting selection, not a universal rule. All shared charges use the same basis in this worksheet.

Should I include every tax I paid?

Enter only the amount you want included in this cost basis. A tax that you recover may belong in your cash-flow records rather than the included cost; confirm its treatment for your own records. This worksheet accepts your chosen amount and does not decide tax recoverability.

Can I mix currencies or pack sizes?

Convert costs to one chosen currency before entering them; no exchange rate is supplied. Match quantity to the supplier unit price. Under Units, a carton and a loose piece count equally unless you first express them in comparable units. Weight or volume may fit a mixed shipment better.

Why does a cent go to one SKU?

Each shared charge must add back to its entered amount. The worksheet floors the exact quotas, then assigns remaining cents to the largest remainders. Equal remainders use the row order. Each fee is handled separately, so several tied residual cents can go to the same row.

What should I do with the landed unit cost?

Use it as the included cost basis for the next pricing decision. Keep any additional selling costs separate and count each expense once. The Wholesale, Markup and Profit Margin tools answer different pricing questions from that cost.

Calculation rules, supported values & sources
  • All costs use the same selected display currency. USD, EUR, GBP, CAD, AUD and PKR use two-decimal amounts here; the currency selector does not convert values.
  • One allocation basis applies to all five shared charge buckets. Weight is total kilograms for the SKU row; volume is total cubic metres. Neither is multiplied by quantity again.
  • Each shared charge is allocated independently to exact cents. Quotas are floored, then residual cents follow the largest exact fractional remainders. Ties follow the original row order.
  • Purchase value can include a zero-value row with zero share. An all-zero value basis is unavailable; choose Units if it matches your shipment. Every row needs a positive selected weight or volume, even when shared charges are zero.
  • Required quantities and supplier unit costs cannot be blank. Blank optional charges are excluded and use zero. Duty and included tax are amounts entered for the row, not rates calculated by this tool.
  • Quantity accepts 1–1,000,000,000 whole units. Money inputs accept 0–999,999,999.99 with two decimals; physical measures accept positive values through 999,999,999.999999 with six decimals. Up to 50 SKU rows and a derived shipment total through 999,999,999,999.99 are supported.
  • Displayed unit costs round half-up to two decimals. The exact SKU total is authoritative; multiplying a rounded unit cost by its quantity may not reproduce that total.
  • Each active numeric entry accepts up to 64 characters, including whitespace and leading zeros; longer entries are rejected without truncation. Unselected physical entries are ignored and marked NOT_USED in exports.
  • CSV includes UTF-8 text, exact cents and each unit divisor. A reversible safety prefix is identified in csv_prefix_added_columns. The printable PDF supports basic Latin SKU names; use CSV to preserve other scripts.
  • This is a costing worksheet using your inputs. It has no HS lookup, automatic tariffs, country tax defaults, FX service, recoverability determination or supplier integration.

International Trade Administration — Determine Total Export Price — Goods, freight, insurance, duty, taxes and other fees can contribute to landed cost. Its route-specific examples are not used as defaults.

IFRS Foundation — IAS 2 Inventories overview — General inventory-cost context for bringing goods to their present location and condition. This worksheet’s allocation and cent rules are disclosed product conventions, not professional review.