Goods cost
Quantity × supplier unit cost
Match the quantity to the unit your supplier priced. A price per carton needs a quantity in cartons.
Free shipment allocation worksheet
One freight bill, several products. Allocate the shipment’s shared costs and see the landed cost for every SKU and unit.
One shipment
Use the supplier price for one unit. Add another SKU only if your shipment needs it.
Amounts for the whole shipment. Count each charge once; blank optional charges mean 0.
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.
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.
Quantity × supplier unit cost
Match the quantity to the unit your supplier priced. A price per carton needs a quantity in cartons.
Charge × SKU basis ÷ total shipment basis
The selected basis assigns a share to every SKU. Each charge is then reconciled to whole cents.
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.
These synthetic figures show why the allocation basis changes a SKU’s cost while keeping the shipment total the same.
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.
100.00 goods + 10.00 freight = 110.00 landed total.
110.00 ÷ 10 units = USD 11.00 per unit.
200.00 goods + 20.00 freight = 220.00 landed total.
220.00 ÷ 10 units = USD 22.00 per unit.
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.
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.
A: 100 / 300 · B: 200 / 300
The higher-value line receives twice the share.
A: 10 / 20 · B: 10 / 20
Equal quantities receive equal shares.
A: 1 / 4 kg · B: 3 / 4 kg
Row B weighs three times as much as row A.
A: 0.5 / 2 m³ · B: 1.5 / 2 m³
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.
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.
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.
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.
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.
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.
These printable references connect a checked cost to the next question. They use synthetic examples and work without entering your shipment details.
Carry a reconciled unit cost into the appropriate markup, margin or wholesale calculation. Check which selling costs still need to be included.
Download pricing sheetSeparate your stock buffer, order trigger, order quantity and arrival-date checks before reviewing the chosen shipment.
Download inventory mapUse 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.
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.
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.
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.
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.
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.