Import Landed Cost Calculator & Supplier Scorecard — Excel Template

Three suppliers quote you three prices. The cheapest quote is rarely the cheapest supplier once freight, duty, fees and minimum order quantity are in the picture.

This workbook puts the whole decision on one set of numbers.

Seven tabs:

• Start Here — colour legend and a one-screen tour

• Settings — insurance, broker fee, port fees, target margin, working-capital ceiling

• Landed Cost — true landed unit cost per quote, uplift over FOB, gross margin, pass/fail flag

• Supplier Scorecard — score 8 criteria, set your own weights, auto-ranked

• MOQ Break-Even — units to break even and cash at risk per price tier

• Quote Comparison — quotes side by side on landed cost, not quoted price

• Dashboard — the recommendation and the numbers behind it

Works in Excel 2010 and later, Excel for Mac, Excel Online, Google Sheets, Numbers and LibreOffice. A worked example of five quotes across five suppliers is pre-loaded so you can see every formula run before you type your own data in. Nothing is locked or protected.

The duty lookup table ships blank on purpose — rates depend on your classification and country of origin, and they move. Confirm yours with your broker and type it in.

This workbook performs calculations. It is not customs, tax or legal advice.