# Supplier RFQ Quote Comparison Worksheet

> Source: https://netray.co/tools/supplier-rfq-quote-comparison-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compare supplier quotes on landed cost: unit price, freight, duty, MOQ and lead time per supplier, with extended cost and price spread calculated.

## Category

supply-chain

## Audience

- Buyer
- Procurement
- Cost engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Supplier

**Key:** supplier

**Type:** text

#### Unit price

**Key:** unit_price

**Type:** number

**Format:** currency

#### Freight per unit

**Key:** freight

**Type:** number

**Format:** currency

#### Duty %

**Key:** duty_pct

**Type:** number

**Format:** percent

#### Landed cost per unit

**Key:** landed

**Type:** number

**Expr:** unit_price + freight + unit_price * duty_pct / 100

**Format:** currency

#### Order quantity

**Key:** qty

**Type:** number

**Format:** integer

#### Extended landed cost

**Key:** ext

**Type:** number

**Expr:** landed * qty

**Format:** currency

#### MOQ

**Key:** moq

**Type:** number

**Format:** integer

#### Lead time (days)

**Key:** lead_days

**Type:** number

**Format:** integer

#### Payment terms

**Key:** terms

**Type:** select

**Options:**

- Net 30
- Net 45
- Net 60
- Advance
- 2/10 Net 30

**Rows:**

**Supplier:** Precision Castings Ltd

**Unit price:** 14.8

**Freight:** 0.35

**Duty pct:** 0

**Landed:** 0

**Qty:** 5000

**Ext:** 0

**Moq:** 1000

**Lead days:** 28

**Terms:** Net 45

**Supplier:** Northline Components

**Unit price:** 13.95

**Freight:** 0.6

**Duty pct:** 0

**Qty:** 5000

**Moq:** 2500

**Lead days:** 35

**Terms:** Net 30

**Landed:** 0

**Ext:** 0

**Supplier:** Overseas Metals Co

**Unit price:** 11.2

**Freight:** 1.15

**Duty pct:** 7.5

**Landed:** 0

**Qty:** 5000

**Ext:** 0

**Moq:** 5000

**Lead days:** 70

**Terms:** Advance

**Supplier:** Harbor Machining

**Unit price:** 15.4

**Freight:** 0.2

**Duty pct:** 0

**Landed:** 0

**Qty:** 5000

**Ext:** 0

**Moq:** 500

**Lead days:** 21

**Terms:** Net 60

**Totals:**

#### Lowest landed cost per unit

**Key:** landed

**Agg:** min

**Format:** currency

#### Shortest lead time

**Key:** lead_days

**Agg:** min

**Format:** integer

**Summary:**

#### Landed cost spread per unit

**Key:** spread

**Expr:** max_landed - min_landed

**Format:** currency

#### Value of spread at order quantity

**Key:** spread_value

**Expr:** spread * 5000

**Format:** currency

**Notes:** Landed cost here is unit price plus freight per unit plus duty on unit price. Add rows or columns in Excel for tooling, packaging, inspection or inventory carrying cost of long lead times. Price is not the only factor: weigh quality, delivery and risk before awarding.

## Content

**Intro:** Comparing quotes on unit price alone often picks the wrong supplier. This worksheet puts price, freight, duty, MOQ, lead time and payment terms side by side and calculates landed cost per unit, so the comparison reflects what you will actually pay.

**Sections:**

#### How to use the worksheet

**Body:** Replace the example rows with one row per quoted supplier. Enter unit price, freight per unit and duty percent. The sheet calculates landed cost per unit and extended cost at your order quantity. Compare MOQ and lead time against your need, and note payment terms because longer terms have a cash value. Export to Excel to add notes, attach quotes or share the comparison with approvers.

#### The formula and what it leaves out

**Body:** Landed cost per unit equals unit price plus freight per unit plus duty on the unit price. Extended cost multiplies by quantity. The spread between the highest and lowest landed cost shows how much choosing the cheapest option saves. The model deliberately omits items that vary by case, so add them when relevant.

**Bullets:**

- Tooling, setup and NRE amortized over volume
- Inspection, testing and packaging costs
- Inventory carrying cost for long lead times and large MOQs
- Currency risk and payment terms value
- Quality cost: expected rejects, rework and expediting

#### Common mistakes

**Body:** The classic error is comparing an ex-works price with a delivered price. Convert everything to the same Incoterms basis first. Another is ignoring MOQ: a low unit price with a very high MOQ may force excess inventory. Watch for quotes with different specifications or revisions, which makes the comparison meaningless, and do not select solely on price when the cheaper supplier has a weak delivery record.

#### From comparison to award

**Body:** Use the worksheet to shortlist, then run a weighted decision including quality, delivery, financial stability and risk. Record the winning quote and the rationale with the purchase requisition so the decision is auditable. In your ERP, update the vendor price or purchase info record only after the award, and keep the comparison with the sourcing file.

**Cta:** If you want RFQ comparisons and price history pulled from your ERP automatically, Netray can help build that view on your own data.

**Faq:**

#### What is landed cost?

**Answer:** Landed cost is the total per-unit cost of getting an item to your door, including unit price, freight, insurance, duty and other charges. It gives a fairer comparison than unit price when suppliers quote on different shipping and duty bases.

#### How many quotes should I get?

**Answer:** Many companies require three quotes above a spend threshold, with fewer for sole-source or customer-directed items. Your procurement policy sets the rule. The aim is real competition on comparable specifications.

#### Should I always choose the lowest landed cost?

**Answer:** Not necessarily. Total cost also includes quality, delivery reliability, risk and payment terms. A slightly higher landed cost with strong performance and short lead time can cost less overall once rejects, expediting and inventory are counted.

#### How do I compare quotes in different currencies?

**Answer:** Convert all quotes to one currency using the same rate and date, and consider exposure if the contract runs long. Note the rate used in the worksheet so approvers can reproduce the numbers.

## Search terms

supplier quote comparison template, RFQ comparison excel, bid comparison sheet, quotation comparison statement, supplier quotation comparison template, landed cost comparison worksheet, vendor quote comparison spreadsheet, bid tabulation template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json