An export costing sheet is the single most useful spreadsheet an exporter can build. It turns guesswork into a price you can defend, and it shows you exactly where your margin goes. Here is how to build one, line by line.
Part 1: Product Cost (Ex-Works Base)
Start with what it costs to make one unit, ready at your factory gate:
| Line | What to include |
|---|---|
| Raw materials | All materials per unit, including wastage |
| Direct labour | Labour cost per unit |
| Factory overheads | A fair share of electricity, rent, maintenance, and supervision |
| Quality control | Inspection time, testing, rejects |
| Export packaging | Inner packaging, cartons, labels, pallets, and wraps |
Divide order-level costs — setup, sampling, testing — by the order quantity and add them per unit. The total is your ex-works (EXW) cost.
Part 2: From Factory to Ship (FOB)
If you quote FOB, you cover everything up to the goods being loaded on board the vessel at the port of export:
| Line | What to include |
|---|---|
| Inland freight | Trucking from factory to port or dry port |
| Port and terminal charges | Charges payable by the exporter at the port of loading |
| Customs clearing | Clearing agent fees, Goods Declaration filing |
| Documentation | Certificate of origin, inspection, phytosanitary or other certificates |
| Bank charges | Document handling, LC advising or confirmation, foreign currency receipt |
| Finance cost | Interest on working capital for the period until payment |
| Commission | Any agent or partner commission |
Add these to your EXW cost to get your FOB cost. Always get current quotes from your forwarder and bank — these charges change.
💡 Cost per order, then per unit
Many export costs are per shipment, not per piece. A clearing fee is roughly the same for 500 cartons or 50. Calculate them per order first, then divide by quantity — you will immediately see why small orders need higher unit prices.
Part 3: From Ship to Destination (CFR and CIF)
If the buyer asks for a CFR or CIF price, add:
| Line | What to include |
|---|---|
| Sea freight | Ocean freight to the named destination port, including surcharges |
| Insurance (CIF only) | Cargo insurance, commonly calculated on 110% of the CIF value |
Freight rates can move quickly, so quote CFR and CIF prices with a short validity. See FOB vs CIF for when each term makes sense.
Part 4: Margin and Final Price
Add your profit margin on top of the relevant cost to get the price you quote. Then compare it with the market price you researched. If your cost-plus price is well above the market, look for savings — packaging, material specifications, order size — before cutting margin.
Converting Currency
If you quote in dollars or euros, convert your rupee costs at a conservative exchange rate — not today's best rate. Build in a small buffer for currency movement over the validity period and the time until payment. See currency risk for exporters.
A Worked Structure
For each quotation, your sheet should show:
- Unit cost at EXW
- Order-level export costs, divided per unit
- FOB unit cost
- Freight and insurance per unit (for CFR or CIF)
- Margin
- Final unit price in the quoted currency
- Validity date and exchange rate used
Keep every costing sheet with its quotation. When a buyer reorders months later, you will know exactly what has changed.
Common Costing Mistakes
- Forgetting bank charges and financing costs
- Using last year's freight rates
- Ignoring the cost of samples and rejected goods
- Pricing small orders with large-order per-unit costs
- Not accounting for extra requirements such as special labels, inspections, or certificates
Frequently Asked Questions
What is included in FOB price?
An FOB price includes the product cost, export packaging, transport to the port of loading, export clearance, and loading on board the vessel. Sea freight and insurance are paid by the buyer.
How do I calculate CIF price?
Start with your FOB price, add sea freight to the destination port, then add cargo insurance. Insurance is commonly calculated on 110% of the CIF value.
How often should I update my export costing?
Update it whenever raw material prices, freight rates, or exchange rates change significantly, and review it at least every quarter.
Ready to Take Your Products Global?
Hexaco Global works with manufacturers from first enquiry to shipped order — finding verified buyers, negotiating terms, and building the digital presence international buyers trust.
Explore the Seller Network →