# China Sourcing RFQ Quote Comparison Worksheet

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

## Short answer

Line up factory quotes on landed unit cost including freight, duty and tooling per piece so the cheapest price is not the wrong choice.

## Category

supply-chain

## Region

China

## Audience

- Buyer
- Sourcing manager
- Procurement analyst
- Product manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Supplier

**Key:** supplier

**Type:** text

#### Factory city

**Key:** city

**Type:** text

#### Incoterm

**Key:** term

**Type:** select

**Options:**

- EXW
- FCA
- FOB
- CIF
- DAP
- DDP

#### Quoted unit price

**Key:** unit_price

**Type:** number

**Format:** currency

#### Freight per unit

**Key:** freight

**Type:** number

**Format:** currency

#### Duty rate

**Key:** duty_pct

**Type:** number

**Unit:** %

#### Tooling charge

**Key:** tooling

**Type:** number

**Format:** currency

#### Order quantity

**Key:** qty

**Type:** number

#### Lead time

**Key:** lead_days

**Type:** number

**Unit:** days

#### Landed unit cost

**Key:** landed

**Type:** number

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

**Format:** currency

#### Total landed cost

**Key:** ext

**Type:** number

**Expr:** (unit_price + freight + unit_price * duty_pct / 100) * qty + tooling

**Format:** currency

**Rows:**

#### FOB

**Supplier:** Dongguan Precision A

**City:** Dongguan

**Unit price:** 4.2

**Freight:** 0.35

**Duty pct:** 3.4

**Tooling:** 6500

**Qty:** 20000

**Lead days:** 45

#### FOB

**Supplier:** Ningbo Components B

**City:** Ningbo

**Unit price:** 3.95

**Freight:** 0.31

**Duty pct:** 3.4

**Tooling:** 9000

**Qty:** 20000

**Lead days:** 55

#### EXW

**Supplier:** Suzhou Metalwork C

**City:** Suzhou

**Unit price:** 4.05

**Freight:** 0.52

**Duty pct:** 3.4

**Tooling:** 4800

**Qty:** 20000

**Lead days:** 40

#### FCA

**Supplier:** Qingdao Stamping D

**City:** Qingdao

**Unit price:** 4.4

**Freight:** 0.38

**Duty pct:** 3.4

**Tooling:** 0

**Qty:** 20000

**Lead days:** 35

#### EXW

**Supplier:** Chengdu Parts E

**City:** Chengdu

**Unit price:** 3.7

**Freight:** 0.74

**Duty pct:** 3.4

**Tooling:** 7200

**Qty:** 20000

**Lead days:** 60

**Totals:**

#### Sum of all quotes

**Key:** ext

**Agg:** sum

**Format:** currency

#### Lowest landed unit cost

**Key:** landed

**Agg:** min

**Format:** currency

**Summary:**

#### Landed cost spread (high minus low)

**Key:** spread

**Expr:** max_landed - min_landed

**Format:** currency

**Description:** Difference between the most and least expensive quote per unit.

**Primary:** true

#### Spread as percent of lowest quote

**Key:** spread_pct

**Expr:** (max_landed - min_landed) / min_landed * 100

**Format:** percent

#### Average lead time

**Key:** avg_lead

**Expr:** avg_lead_days

**Format:** days

**Notes:** Enter freight to your destination per unit so all quotes are on the same basis, and convert EXW or FOB quotes by adding inland and ocean freight. Duty uses the quoted price as the base, which is a simplification; customs value rules depend on your country. The worksheet does not include VAT, insurance, brokerage or inventory carrying cost.

## Content

**Intro:** A quote of 3.70 per piece from one factory and 4.40 from another is not a comparison until freight, duty, tooling and quantity are on the same basis. This worksheet computes the landed unit cost for each quote so the ranking reflects real cost.

**Sections:**

#### How to use the worksheet

**Body:** Replace the example rows with your own quotes. For each supplier enter the unit price, the Incoterm quoted, the freight per unit to your destination, the duty rate for your classification, any one-time tooling charge and the order quantity the quote assumes. The landed unit cost column adds freight and duty to the price and spreads the tooling over the quantity. Export the sheet to Excel for approvals, and add rows for each additional bidder.

#### The formula behind the result

**Body:** Landed unit cost equals unit price plus freight per unit plus duty (price times duty rate) plus tooling divided by quantity. In the example, the supplier with the lowest ex-works price has the highest freight because it is far inland, which narrows its advantage. A supplier with no tooling charge looks expensive per piece but may win at low volume. Change the quantity to see how tooling amortization shifts the ranking, since that is the number most quotes hide.

**Bullets:**

- Unit price plus freight gives the delivered price
- Duty is a percentage of the customs value
- Tooling divided by quantity gives the per-piece charge
- Lead time is shown beside cost, not inside it

#### What cost alone will not tell you

**Body:** The cheapest landed cost is not always the best award. Add quality history, capacity, payment terms, certifications and the cost of delay. A supplier 5 percent cheaper but 20 days slower ties up working capital and may need extra safety stock. Record the score of these factors beside the worksheet, or use a weighted scorecard, before awarding.

#### Common mistakes

**Body:** Comparing EXW and FOB prices without adding inland freight and export clearance, using different quantities for different bidders, and ignoring tooling ownership. Make sure the quotes list the same material grade, finish, tolerance and packing. Anything missing from one quote should be priced as an assumption in the others.

**Cta:** If your quotes live in email and spreadsheets, Netray can help build a private workflow that pulls bids into your ERP purchasing records for comparison and approval.

**Faq:**

#### Should I include VAT in the comparison?

**Answer:** Usually no. Export VAT is typically refunded or zero-rated and import VAT is recoverable for most business buyers, so it does not change the ranking. Include it only if it is a real, non-recoverable cost in your situation.

#### How do I handle different currencies?

**Answer:** Convert every quote into one currency at the same date and rate before you enter it. For RMB quotes consider the effect of exchange rate movement over the lead time, and note whether the quote price is fixed or adjustable.

#### Why is tooling spread over the order quantity?

**Answer:** It shows the per-piece effect of a one-time charge at the quantity you plan to buy. If total lifetime volume is higher, you may spread it over more units, but keep one basis for all bidders so the comparison is fair.

#### Can I add more cost columns?

**Answer:** You can add columns after exporting to Excel, for example insurance, brokerage, packaging or inspection. Keep the formula consistent for all suppliers so the comparison stays fair.

## Search terms

supplier quote comparison template, RFQ comparison excel China, landed unit cost comparison, quote comparison worksheet, factory quote comparison tooling amortization, bid comparison template sourcing, compare Chinese supplier quotes, RFQ evaluation spreadsheet

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