Supplier Comparison & Landed Cost Calculator | Product Sourcing, MOQ, Import Costs, Inventory Excel Spreadsheet

📦 YOUR CHEAPEST SUPPLIER ISN’T ALWAYS YOUR CHEAPEST OPTION.

A supplier might quote you £4 per unit — but once you add shipping, import costs, packaging, inspection fees and other expenses, your TRUE product cost can look very different.

The Supplier Comparison & Landed Cost Calculator is an Excel workbook designed to help product-based business owners compare suppliers, calculate true landed costs and understand the cash commitment behind an order BEFORE placing it.

✨ COMPARE SUPPLIERS. CALCULATE TRUE COST. SOURCE WITH CLARITY.

📊 WHAT’S INCLUDED

Your workbook includes 7 dedicated sections:

✓ START HERE GUIDE
Simple instructions to help you set up and use the workbook.

✓ SUPPLIER DASHBOARD
See key supplier, cost and sourcing information together in one visual overview.

✓ SUPPLIER COMPARISON
Compare potential suppliers side by side using factors such as price, MOQ, lead time and other important considerations.

✓ LANDED COST CALCULATOR
Go beyond the supplier’s unit price and calculate a more complete estimated cost of getting your product ready to sell.

✓ MOQ & CASH PLANNER
Understand how minimum order quantities affect the amount of cash you may need to commit to an order.

✓ SAMPLE TRACKER
Keep potential supplier samples organised and record relevant costs and information during your sourcing process.

✓ ORDER PLANNER
Plan a potential first order and explore the financial implications before committing your cash.

💰 CALCULATE YOUR TRUE LANDED COST

The price on a supplier quote isn’t necessarily the amount your product ultimately costs you.

Depending on your circumstances, your costs could include:

• Product/unit cost
• Freight or shipping
• Duty/import costs
• Import VAT or taxes
• Broker or clearance costs
• Inspection / quality-control costs
• Packaging
• Other sourcing and import expenses

Enter the costs relevant to your business to estimate your true landed cost per unit.

📋 COMPARE SUPPLIERS SIDE BY SIDE

Supplier A might have the lowest unit price.

Supplier B might have a lower MOQ.

Supplier C might cost slightly more but offer better lead times or other advantages.

Use the Supplier Comparison section to organise your quotes and compare potential suppliers using multiple factors rather than simply choosing the lowest quoted unit price.

📦 UNDERSTAND MOQ & CASH COMMITMENT

A great unit price isn’t necessarily a great deal if the MOQ requires more cash than your business can comfortably commit.

Use the MOQ & Cash Planner to explore the financial impact of different order quantities and supplier requirements.

🧮 PLAN YOUR FIRST ORDER

Explore your potential:

• Order quantity
• Estimated landed cost
• Cash required
• Selling price
• Projected revenue
• Potential gross profit

before committing to an order.

🌿 PERFECT FOR

• Product-based small businesses
• Etsy sellers sourcing products
• TikTok Shop sellers
• Shopify brands
• Private-label businesses
• E-commerce businesses
• Importers
• Start-ups
• Entrepreneurs sourcing from overseas manufacturers
• Anyone comparing multiple product suppliers

📥 HOW IT WORKS

1. Purchase and download your digital file.
2. Unzip the downloaded ZIP folder.
3. Open the Microsoft Excel (.xlsx) workbook.
4. Read the Start Here guide.
5. Enter your supplier quotes and your own cost assumptions.
6. Compare suppliers and calculate estimated landed costs.
7. Use the planning tools to explore your potential order before committing.

💻 DIGITAL PRODUCT

This is a DIGITAL PRODUCT. No physical item will be shipped.

You will receive a ZIP file containing the Microsoft Excel (.xlsx) Supplier Comparison & Landed Cost Calculator.

Please unzip the file before opening the spreadsheet.

Microsoft Excel is recommended.

⚠️ IMPORTANT INFORMATION

Calculations and outputs depend on the information and assumptions entered by the user.

Import duty, VAT, taxes, freight, customs, brokerage and other charges vary by product, country, shipment and individual circumstances. The workbook does not determine the correct rates for you.

Please verify all applicable costs, customs classifications, tax obligations and import requirements with the relevant authorities or an appropriately qualified professional before placing an order.

This workbook is provided for business planning and educational purposes only and does not constitute financial, accounting, tax, customs, legal or investment advice.

LICENCE

For the purchaser’s personal/business use only.

This product may not be resold, redistributed, shared, copied for resale, sublicensed or offered as a digital template/product.

THE BRAND BLUEPRINT CO.

PLAN. PRICE. PROFIT. GROW. 🤍

✨ A Note About Our Creative Process

At The Brand Blueprint Co., every template is developed with a focus on thoughtful design, practical functionality and ease of use.

Our products are created through a combination of human-led creative direction and AI-assisted development. AI tools support elements of spreadsheet construction, formulas and visual design, while product concepts, features, aesthetics and refinements are guided by our brand.

Our mission is to make business management simpler, smarter and more beautiful for entrepreneurs and small business owners.