Landed Cost Calculator — Side-by-Side (Apparel)
Compare supplier quotes and calculate true landed cost per unit. Enter Incoterms, HS code duty rate, freight, insurance, origin/destination fees, inspection, inland trucking, FX rates, and more — then see unit landed cost and margin side-by-side.
Excel (.xlsx) Google Sheets ready Side-by-side suppliers Incoterms · HS duty · FX
What’s inside
- Compare multiple suppliers side-by-side (quote columns)
- Support for Incoterms (EXW / FOB / CIF / DDP)
- Duty/VAT inputs by HS code & destination (manual rate field)
- Freight & insurance (sea/air), origin & destination charges
- Inspection/QC, bank fees, documentation, trucking
- FX rate & currency normalization to target currency
- Outputs: unit landed cost, % margin, and variance vs target
How to use
- Pick Incoterm per supplier; enter product cost and MOQs.
- Add freight/insurance + origin/destination fees.
- Enter HS duty rate (and VAT if applicable) for your destination.
- Set FX rate(s) and target currency.
- Review unit landed cost, margin, and choose the best option.
Who it’s for
- Apparel brands comparing Vietnam quotes
- Procurement & finance needing apples-to-apples landed cost
- Consultants preparing sourcing business cases
Template specs
- Inputs: product cost by Incoterm, carton/CBM, freight & insurance, origin/destination fees, inspection, bank/docs, trucking, HS duty %, VAT %, FX rate
- Outputs: unit landed cost, margin %, variance vs target
- Editable: fee buckets, currencies, supplier count
- Formats: .xlsx + GSheets
FAQs
Does it auto-fetch duty rates?
No. Enter your HS code and duty/VAT % manually (rates vary by destination). The sheet calculates totals using your inputs.
Can I change currencies and FX?
Yes. Set the FX rate(s) and choose a target currency, the template normalizes all quotes to that currency.
How many suppliers can I compare?
The default supports multiple side-by-side columns. You can duplicate a column group to add more.
Related Posts
Garment Defect Inspection Sheet Template 10 Oct 2025
Supplier Screening Checklist Template 25 Sep 2025
By submitting, you agree to our Privacy Policy.