1. Start With Where You Need The Product
Before we touch the spreadsheet, where do you need this order to end up? Your warehouse? A prep center? An Amazon fulfillment facility? Pick that destination first. We want every quote to take us to the same place.
When someone says “delivery included,” ask: “Included to where?” A price that gets your goods to the port still leaves you with work—and potentially costs—to get them to your door.
Keep the destination, quantity, currency, quote date and delivery terms beside your numbers. If a cost hasn’t been confirmed, mark it as an open question. We’ll come back to it.
Do You Know Your Incoterms?
You’ve got the price. Now look for the letters beside it. EXW? FOB? Maybe the supplier has offered DDP. Those letters help explain who handles which parts of the shipment, who pays for them, and where the risk of loss or damage passes from seller to buyer. They can make a big difference to what you still need to budget.
EXW (Ex Works), FOB and DDP are three terms you’re likely to run into when comparing supplier quotes. But they’re only part of the picture. Incoterms 2020 has 11 rules in total, and the right one depends on the shipment and the handoff you’ve agreed to. Let’s start with these three.
EXW means Ex Works. Think: “Your order is ready for collection at the agreed place.” The seller makes the goods available, usually at its premises, without loading the collecting vehicle. You take on the onward arrangements, including export clearance. Before accepting it, ask your forwarder how pickup, loading and export formalities will actually be handled.
FOB means Free On Board. For an Incoterms 2020 FOB shipment, the seller clears the goods for export and delivers them on board the vessel at the named shipment port. That’s where risk passes to you. You arrange the main freight and the onward import and delivery steps. Getting the goods to the port gate alone is not the FOB handoff.
DDP means Delivered Duty Paid. The seller takes responsibility through delivery at the agreed destination, including import clearance and applicable import duties and taxes. The goods arrive ready for you to unload. That can make the quote easier to work with—but the costs are built into the price, not made to disappear.
But wait, there’s more. “DDP to your door” still needs a specific destination and a workable import-clearance arrangement. Ask who will act as importer of record, how clearance will be handled, and what documents you’ll receive. Confirm unloading and any services you need beyond delivery. Have your broker check that the proposed arrangement works for the shipment.
And here’s an important detail for global sourcing: FOB is a sea and inland-waterway rule. It isn’t the right label for an air or truck shipment. When goods are handed to a carrier at a container terminal before vessel loading, ask whether FCA—Free Carrier—better matches the handoff.
Put the chosen rule, the exact named place or port, and “Incoterms 2020” in the agreement. Then compare the quotes to the same final destination. The letters help define the delivery responsibilities; they don’t replace your payment terms, product specification or the rest of the contract.
A simplified view of delivery and risk transfer under Incoterms 2020.
Ready For Collection
At the named place, before loading the collecting vehicle.
Buyer handles onward transport and export/import clearance.On Board The Vessel
At the named shipment port, with export clearance handled by the seller.
Buyer handles main freight and import arrangements.At The Named Destination
Import-cleared, on the arriving vehicle, ready for unloading.
Seller handles transport and import duties; buyer unloads.FOB is for sea and inland waterways. EXW and DDP can cover any mode. Confirm the named place, actual handoff and full contract terms.
2. Work Out What The Factory Price Includes
Now take the supplier quote and ask what you’re getting for that price. Does it include the packaging you need? Are inspection or sourcing costs separate? What freight, insurance, duty, handling and delivery costs still need to be added?
The idea is simple: follow the order from the supplier to your chosen destination and account for each cost once. If prep work is part of getting the order ready at that destination, include it too.
The workbook labels its factory-price input as FOB. Check the agreed terms and named place on your actual quote. If another supplier quotes on a different basis, sort out what each price includes before comparing them.
And keep everything in one currency. If you’re paying the supplier in one currency and the forwarder in another, note the exchange rate you used and allow for any payment or conversion costs.
3. Get The Packing Details Right
Open the Calculator tab and start with the blue boxes. Enter your product price, order quantity and any separate per-unit costs. You can also enter your selling price and marketplace fees for the margin comparison—we’ll talk about what that result does and doesn’t tell you in a moment.
Next, get the packing details from your supplier: units per carton, outside carton dimensions and the weight of a full carton. Make sure the units match the sheet. Centimeters and kilograms are a different input from inches and pounds.
Ask for the shipping carton measurements, including the packaging. Product dimensions alone won’t give you the answer you need. If you have mixed products or a partly filled last carton, confirm the actual packing list as well.
These details feed the volume, weight and container estimates. It’s worth getting them right before you ask someone to quote freight.
4. Ask What The Freight Quote Leaves Out
For sea freight, enter the total quote. For air, the workbook asks for a rate per kilogram. It compares the actual weight with a size-based weight and uses the higher figure. Ask your forwarder to confirm the chargeable weight and calculation for the service they’re quoting, including any minimums or surcharges.
Then ask a straightforward question: “What else will I have to pay to get this order to my destination?” Check pickup, handling at both ends, customs clearance and final delivery. Add missing charges in Fees & Settings, but don’t add something a second time if it’s already in the quote.
Once the costs line up, look at the schedule. When will you have inventory you can actually sell? Ask about production, pickup, clearance and delivery—not just the time on the water or in the air.
The sheet helps compare the freight costs. You still need to weigh those costs against the timing your business needs. It doesn’t calculate the cost of running out of stock or promise an arrival date.
5. Don’t Skip Fees & Settings
The main tab gives you a quick comparison, but spend a few minutes on Fees & Settings before you trust the total. That’s where you’ll find broker and bond charges, ocean-related fees, delivery and other shipment costs.
Some fields contain example amounts. Delivery and other shipment costs start at zero. Ask yourself: “Is this really zero, is it included somewhere else, or have I just not entered it yet?” Those are three very different answers.
The same goes for duty and extra tariffs. Have your customs broker confirm the U.S. classification, country of origin, customs value and applicable treatment for your product. A code from the factory may not be the right U.S. HTS code.
The workbook applies the percentages you enter to its calculated goods value. Ask your broker whether that approach covers your shipment and how to handle anything it doesn’t cover. Also review the setting for including agent costs in customs value.
Check the government fees against your entry date, too. Version 4 uses the FY2027 U.S. formal-entry Merchandise Processing Fee (MPF): 0.3464% of the applicable customs value, with a $34.58 minimum and a $670.86 maximum. Those limits apply to entries from October 1, 2026 through September 30, 2027. The workbook doesn’t have an entry-date selector, so don’t carry those limits into a later year without checking them.
Looking at an older entry? The FY2026 examples are marked as historical and keep the $33.58 minimum and $651.50 maximum for October 1, 2025 through September 30, 2026. Have your broker confirm which fees apply to your shipment.
6. Let’s Walk Through The Example
The workbook starts with a kitchen set: 3,000 units at $4.50 each, plus $0.25 per unit for agent and inspection costs. So we’re at $4.75 per unit, or $14,250 for the order, before we add the remaining costs. These are example inputs, not a client story or a current supplier quote.
In the preview, the estimated landed cost comes out to $7.24 per unit by sea and $11.15 by air. Those are rounded results from the example assumptions. Delivery and other shipment costs are still set to zero, so don’t use those totals as a budget for your own order.
The point of the example is to show how the factory price changes as you add the rest of the costs. Replace the inputs, check what’s missing, and then look at the comparison for your order.
One more thing: the sheet divides by the quantity ordered. If you’ll use some units as samples, or some won’t be available to sell, take another look at the cost spread across the units you expect to sell.
And when you see “profit,” remember what’s included. The workbook subtracts entered landed cost and marketplace fees from selling price. Advertising, returns, storage and overhead still need your attention. That number isn’t your final business profit.
7. Ask Your Supplier To Confirm The Container Fit
Open the Container Planner and you’ll see an estimate based on carton volume, weight limits and a packing allowance. It gives you a starting point for the loading conversation.
Send it to your supplier and ask: “Can you confirm this loading quantity with our actual packaging?” Talk through pallets, carton orientation, stacking limits and usable space. Ask your freight partner to check the transport limits too.
There’s a section for the confirmed carton count, gross weight, volume, name and date. Use it. Keep a note of what the confirmation is based on, and revisit it if the packaging changes.
8. Use The Same Questions Wherever You Source
This conversation applies to suppliers in Canada, Mexico, Europe, Latin America, Africa and Asia. Wherever the product is made, we need to know whether the supplier can do the work and what it will cost to get the finished goods where you need them.
The workbook has a narrower job: comparing sea and air shipments into the U.S. If your order is coming by truck from Canada or Mexico, you need the freight and border costs for that route. Don’t drop it into the sea column and assume the comparison is complete. Rail and imports into other countries need their own assumptions too.
Build a separate cost breakdown for those routes, then compare the same quantity, currency and delivery destination. Put lead time, minimum orders, replenishment flexibility and supplier risk beside the cost. That gives you a much better basis for the decision.
A Few Things To Watch For
Before you compare the totals, check that both quotes reach the same destination. Then look for sample rates you haven’t replaced, delivery fields still at zero, fees counted twice and container quantities nobody has confirmed.
For each important number, ask: “Where did this come from?” A current quote, a supplier confirmation and an assumption shouldn’t all carry the same weight in your decision. Keep the open questions visible until you have answers.
Before You Place The Order
Go back through the product and packing details, the quantity, delivery terms and freight quotes. Get the customs assumptions checked and close out the missing fees. Save the estimate with the quotes and dates so you can see what changed later.
If the order only makes sense when every unanswered question works in your favor, pause and work through those questions. This is the time to do it—while you can still adjust the order, the terms or the plan.
That’s what I want you to get from this tool: better decisions before supplier problems become expensive.
Estimates only. Verify duty rates and freight quotes before ordering. This guide and workbook are planning tools, not a customs ruling or customs, tax or legal advice.
Sources And Last Review
- International Trade Administration: Determine Total Export Price
- USITC: Tariff classification and importing FAQs
- International Trade Administration: Know Your Incoterms
- ICC: Incoterms 2020 Checklist And Flowcharts
- ICC: FOB Rules And Container Handoffs
Last reviewed November 19, 2026. Confirm rates, fees and shipment requirements with your customs broker and freight partner before ordering.