A reliable wholesale price starts with more than the supplier’s quoted unit cost. This guide shows how to build a repeatable profit margin calculator for internationally sourced products, including freight, duties, packaging, payment fees, currency changes, break-even volume, and target profit. Use the worksheet structure and worked examples to compare suppliers, test pricing decisions, and update your numbers whenever costs change.
Overview
Small businesses often lose margin because they price from the factory or wholesale quote alone. A product may appear profitable until freight, import charges, packaging, transaction fees, storage, returns, and currency movement are included. A landed cost calculator helps turn those separate expenses into one usable cost per sellable unit.
The main measures are related but not interchangeable:
- Landed cost: the total cost of getting a product ready for sale, divided by the number of sellable units.
- Wholesale price: the amount you charge a business customer or reseller.
- Gross profit: sales revenue minus the direct cost of the goods sold.
- Gross margin: gross profit divided by sales revenue.
- Markup: gross profit divided by cost.
- Break-even point: the sales volume or revenue needed to cover fixed costs.
Margin and markup are frequently confused. If an item costs $60 and sells for $100, the gross profit is $40. The gross margin is 40%, while the markup is 66.7%. Use margin when setting a sales target and markup when calculating a selling price from cost.
For supplier comparisons, calculate the same cost categories for every quote. An international supplier RFQ template can help you request comparable information about unit prices, minimum order quantities, packaging, lead times, and shipping terms.
How to estimate wholesale price and profit
Start with the following worksheet formulas. Keep the inputs in separate cells or columns so you can change one assumption without rebuilding the entire calculation.
1. Calculate total shipment cost
Total shipment cost = product cost + origin charges + freight + insurance + duties and taxes + destination charges + packaging and preparation + payment fees + other direct costs
Product cost is usually the supplier’s unit price multiplied by the ordered quantity. Direct costs may include inspection, labeling, documentation, customs handling, local delivery, warehouse receiving, and protective packaging. Include only costs that are connected to acquiring and preparing the specific shipment.
2. Calculate landed cost per unit
Landed cost per unit = total shipment cost ÷ sellable units received
Use sellable units rather than ordered units if some units are expected to be damaged, used for samples, or held back for quality checks. If the expected yield is 98%, for example, multiply the order quantity by 0.98 before dividing the total cost.
3. Calculate a price from a target margin
Wholesale price = landed cost per unit ÷ (1 − target gross margin)
If landed cost is $12 and the target gross margin is 40%, the calculation is $12 ÷ 0.60, producing a wholesale price of $20. The gross profit is $8 per unit, and $8 represents 40% of the $20 selling price.
4. Calculate a price from a markup
Wholesale price = landed cost per unit × (1 + target markup)
With a $12 landed cost and a 50% markup, the price is $18. The resulting margin is $6 divided by $18, or 33.3%. This illustrates why a markup target should not be described as a margin target.
5. Calculate break-even volume
Break-even units = fixed costs ÷ contribution per unit
Contribution per unit is the selling price minus variable costs per unit. Depending on your model, variable costs may include landed cost, sales commissions, payment fees, fulfillment, customer-specific packaging, and shipping that you pay on the buyer’s behalf. Fixed costs can include software, rent, salaries, product development, and other expenses that do not change directly with unit volume.
For a broader view, a business ROI calculator can compare the expected profit from an order with the capital committed, time required, and recurring operating costs. ROI is useful for comparing opportunities, but it should not replace a margin calculation.
Inputs and assumptions for an updateable worksheet
Create one worksheet with an input area, a calculation area, and a decision area. Label every figure with its currency and whether it is a per-unit, per-shipment, or percentage amount.
Recommended input fields
- Supplier unit price and order quantity
- Incoterm or quoted shipping basis
- Origin pickup, export handling, and documentation costs
- International freight and insurance
- Duty, brokerage, taxes, and destination handling
- Packaging, labeling, inspection, and preparation
- Payment processing or currency conversion fees
- Expected damaged, defective, or unsellable units
- Domestic delivery, storage, and fulfillment costs
- Wholesale price, target margin, and target markup
- Fixed costs allocated to the launch or order
- Exchange rate and a sensitivity rate for adverse movement
Incoterms affect which costs are included in a supplier’s quote, so do not compare an EXW quote with a delivered quote as if they were equivalent. Review the responsibilities and cost boundaries for each term in this Incoterms guide.
For currency assumptions, record the rate used, the date of the estimate, and a conservative alternative rate. If your supplier quotes in one currency and you sell in another, a small rate change can alter the landed cost and the margin. Avoid hiding that risk inside a rounded unit price.
Example worksheet structure
Use rows for cost categories and columns for quantity, unit amount, currency, exchange rate, converted amount, and notes. Add a separate scenario column for base, cautious, and higher-cost assumptions. The decision area should show landed cost per unit, wholesale price, gross profit, gross margin, break-even units, and cash required for the order.
Keep taxes that you expect to recover or offset separate from permanent costs. Treatment varies by business structure and jurisdiction, so label these amounts for review rather than automatically treating every tax or fee as a final product cost.
Worked examples
Example 1: Comparing a product quote with landed cost
Assume a business orders 500 units at $8 each. The product cost is $4,000. Freight and insurance total $900, origin and destination charges total $300, duties and other direct import costs total $500, packaging and preparation total $250, and payment fees total $100. The shipment total is:
$4,000 + $900 + $300 + $500 + $250 + $100 = $6,050
If all 500 units are sellable, landed cost is $12.10 per unit. If the business expects 10 units to be unavailable for sale, the sellable quantity is 490 and landed cost becomes about $12.35 per unit. That difference should be reflected before setting a wholesale price.
Example 2: Setting a target margin
Using the $12.35 landed cost, a 35% gross margin requires:
$12.35 ÷ (1 − 0.35) = $19.00 approximately
At a $19 wholesale price, gross profit is approximately $6.65 per unit. If the business also pays $1.25 per unit for fulfillment and payment-related selling costs, the contribution used for break-even analysis is closer to $5.40, unless those costs were already included in the landed cost.
Example 3: Testing break-even
Suppose launch-specific fixed costs are $2,700 and contribution is $5.40 per unit. Break-even volume is:
$2,700 ÷ $5.40 = 500 units
This result does not guarantee that 500 units will sell. It tells you the volume required to recover the stated fixed costs under the stated price and cost assumptions. Test a lower selling price, higher freight cost, and slower sales volume before committing to the order.
When to recalculate
Revisit the worksheet whenever a cost or operating assumption changes. At minimum, update it before placing a new order, approving a supplier quote, changing a wholesale price, entering a new market, or reviewing an underperforming product.
Recalculate after:
- A supplier changes the unit price, minimum order quantity, packaging, or payment terms.
- The shipping method, Incoterm, route, insurance, or freight quote changes.
- Currency rates move enough to affect the purchase budget or target margin.
- Duty, brokerage, taxes, inspection, or destination charges are revised.
- Defect rates, returns, fulfillment costs, or sell-through assumptions differ from the plan.
- A buyer requests custom labeling, smaller quantities, extended terms, or delivered pricing.
- You introduce discounts, commissions, promotional pricing, or reseller incentives.
Use a dated version of the worksheet and save the supplier quote or RFQ response beside it. When a number changes, record the old assumption and the reason for the revision. This creates a practical audit trail and makes supplier comparisons easier.
Before approving an order, complete three checks: confirm that every quote uses the same cost basis, calculate the price from the margin target rather than guessing, and run a cautious scenario with higher direct costs or fewer sellable units. If the cautious scenario still meets your required contribution and cash limits, the decision is more resilient. For related sourcing work, review the overseas supplier due diligence checklist and the import cost calculator guide before finalizing the purchase.
