# Purchasing RFQ Bid Comparison Worksheet

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

## Short answer

An editable bid tabulation that totals each supplier's quote including tooling and freight, calculates landed cost per unit and shows the lowest bid.

## Category

supply-chain

## Audience

- Buyer
- Purchasing manager
- Supplier quality

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Supplier

**Key:** supplier

**Type:** text

#### Incoterm

**Key:** incoterm

**Type:** select

**Options:**

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

#### Unit price

**Key:** unit_price

**Type:** number

**Format:** currency

#### Quantity

**Key:** qty

**Type:** number

**Format:** integer

#### One-time tooling

**Key:** tooling

**Type:** number

**Format:** currency

#### Freight and duty

**Key:** freight

**Type:** number

**Format:** currency

#### Lead time (days)

**Key:** lead_days

**Type:** number

**Format:** integer

#### Total cost

**Key:** total

**Type:** number

**Expr:** unit_price * qty + tooling + freight

**Format:** currency

#### Landed cost per unit

**Key:** landed

**Type:** number

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

**Format:** currency

#### Quote valid until

**Key:** valid_until

**Type:** date

**Rows:**

**Supplier:** Northline Castings

**Incoterm:** DAP

**Unit price:** 18.4

**Qty:** 2000

**Tooling:** 0

**Freight:** 1200

**Lead days:** 35

**Valid until:** 2026-12-15

**Supplier:** Pacific Metalworks

**Incoterm:** FOB

**Unit price:** 16.9

**Qty:** 2000

**Tooling:** 4500

**Freight:** 2600

**Lead days:** 49

**Valid until:** 2026-12-01

**Supplier:** Delta Forge

**Incoterm:** EXW

**Unit price:** 17.75

**Qty:** 2000

**Tooling:** 1800

**Freight:** 1900

**Lead days:** 28

**Valid until:** 2026-11-30

**Supplier:** Summit Machining

**Incoterm:** DDP

**Unit price:** 19.2

**Qty:** 2000

**Tooling:** 0

**Freight:** 0

**Lead days:** 30

**Valid until:** 2027-01-10

**Totals:**

#### Sum of all bids

**Key:** total

**Agg:** sum

**Format:** currency

#### Lowest landed cost per unit

**Key:** landed

**Agg:** min

**Format:** currency

#### Shortest lead time

**Key:** lead_days

**Agg:** min

**Format:** days

**Summary:**

#### Spread between highest and lowest landed cost

**Key:** spread

**Expr:** max_landed - min_landed

**Format:** currency

#### Spread as percent of lowest

**Key:** spread_pct

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

**Format:** percent

**Notes:** Enter the same quantity for every bidder. Tooling is shown as a one-time cost spread over this order only, so rerun with your lifetime volume if tooling will be reused. Always compare the same Incoterm basis, and add freight and duty where the quote is EXW or FOB.

## Content

**Intro:** A bid comparison worksheet puts every supplier quote on one basis so the cheapest unit price is not mistaken for the cheapest buy. This editable table adds tooling, freight and duty to each quote and shows landed cost per unit.

**Sections:**

#### How to use the worksheet

**Body:** Replace the sample rows with your bidders. Use one quantity for all suppliers so numbers are comparable. Enter the Incoterm each supplier quoted on, then add freight and duty for any quote that excludes them. Tooling and fixtures go in the one-time column. The sheet calculates total cost and landed cost per unit and the spread summary shows how far apart the bids really are. Export to Excel to share with your approvers.

#### Why landed cost, not unit price

**Body:** Unit price ignores everything outside the invoice line. A supplier quoting EXW at a low price can lose to a DAP quote once ocean freight, insurance, duty and brokerage are added. Tooling that looks small on a small order matters when volume is low. The landed cost formula used here is: (unit price times quantity, plus tooling, plus freight and duty) divided by quantity.

**Bullets:**

- Compare on the same Incoterm basis
- Include freight, insurance, duty and brokerage
- Spread tooling over the order or the expected lifetime volume
- Check quote validity dates before awarding

#### Beyond price

**Body:** The lowest landed cost is only one input. Use the lead time column to see which bidders meet your need date, and keep quality history, capacity, financial health and payment terms alongside this sheet. For a weighted decision, score those factors separately and combine with price. If the lowest bid is far below the others, confirm the supplier understood the drawing before awarding.

#### Common mistakes

**Body:** Comparing different quantities or price breaks, forgetting currency conversion, treating a quote past its validity date as current, leaving out tooling ownership terms, and ignoring payment terms that change the real cost of money. Record why you chose a bidder; auditors and finance will ask.

**Cta:** Netray can feed historical purchase prices and supplier delivery data from your ERP into a comparison like this, privately and read-only.

**Faq:**

#### How many suppliers should I request quotes from?

**Answer:** Three to five is typical for competitive buys. Fewer is reasonable for sole-source or specialized work, in which case record the justification.

#### How do I handle different currencies?

**Answer:** Convert every quote to your base currency using one agreed rate and date before entering it, and note the rate on the sheet. Consider a currency risk allowance for long contracts.

#### Should tooling be included in the unit price?

**Answer:** Compare it both ways. For a one-time order, spread it over that order. For ongoing supply, spread it over expected lifetime volume, and confirm who owns the tooling.

#### Does this work for services?

**Answer:** Yes. Use the unit price for the hourly or per-job rate and the quantity for hours or jobs, and treat mobilization as the one-time cost.

## Search terms

rfq comparison template excel, bid comparison sheet, supplier quote comparison template, bid tabulation template, rfq evaluation worksheet, quotation comparison statement format, purchase quote comparison excel, landed cost comparison supplier

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