# Freight Carrier RFQ Bid Comparison Worksheet

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

## Short answer

An editable worksheet for comparing carrier bids per lane, with fuel surcharge, accessorials and annualized cost calculated for you.

## Category

supply-chain

## Audience

- Logistics coordinator
- Transportation buyer
- Procurement

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Lane

**Key:** lane

**Type:** text

#### Carrier

**Key:** carrier

**Type:** text

#### Mode

**Key:** mode

**Type:** select

**Options:**

- LTL
- FTL
- Intermodal
- Parcel
- Air
- Ocean

#### Base rate per shipment

**Key:** rate

**Type:** number

**Format:** currency

#### Fuel surcharge %

**Key:** fsc

**Type:** number

**Unit:** %

#### Accessorials per shipment

**Key:** acc

**Type:** number

**Format:** currency

#### Transit days

**Key:** transit

**Type:** number

#### Shipments per month

**Key:** vol

**Type:** number

#### All-in cost per shipment

**Key:** landed

**Type:** number

**Expr:** rate * (1 + fsc / 100) + acc

**Format:** currency

#### Annual cost

**Key:** annual

**Type:** number

**Expr:** (rate * (1 + fsc / 100) + acc) * vol * 12

**Format:** currency

**Rows:**

**Lane:** Houston to Dallas

**Carrier:** Lone Star Freight

**Mode:** LTL

**Rate:** 285

**Fsc:** 24

**Acc:** 35

**Transit:** 2

**Vol:** 30

**Lane:** Houston to Dallas

**Carrier:** Prairie Express

**Mode:** LTL

**Rate:** 262

**Fsc:** 28

**Acc:** 55

**Transit:** 2

**Vol:** 30

**Lane:** Houston to Chicago

**Carrier:** Midwest Haulers

**Mode:** FTL

**Rate:** 2650

**Fsc:** 20

**Acc:** 0

**Transit:** 3

**Vol:** 8

**Lane:** Houston to Chicago

**Carrier:** RailLink Intermodal

**Mode:** Intermodal

**Rate:** 2100

**Fsc:** 14

**Acc:** 120

**Transit:** 6

**Vol:** 8

**Lane:** Houston to Atlanta

**Carrier:** Southern Line

**Mode:** LTL

**Rate:** 410

**Fsc:** 24

**Acc:** 40

**Transit:** 3

**Vol:** 12

**Totals:**

#### Total annual cost (all rows)

**Key:** annual

**Agg:** sum

**Format:** currency

#### Lowest all-in cost per shipment

**Key:** landed

**Agg:** min

**Format:** currency

**Summary:**

#### Average all-in cost per shipment

**Key:** avg_ship

**Expr:** avg_landed

**Format:** currency

#### Bids compared

**Key:** rows

**Expr:** count

**Format:** integer

**Notes:** Compare bids within the same lane and mode only. The total row adds every bid, so for a budget total keep only the winning bid per lane. Add rows for each carrier and lane you are evaluating.

## Content

**Intro:** Carrier bids rarely arrive in the same format. One quotes a flat rate, another a lower base rate with heavy fuel and accessorial charges. This worksheet puts each bid on the same footing by calculating the all-in cost per shipment and the annual cost for each lane.

**Sections:**

#### How to use this worksheet

**Body:** Add one row per carrier per lane. Enter the base rate, the fuel surcharge percentage, an estimate of accessorial charges per shipment and your expected monthly shipment volume. The worksheet computes the all-in cost and the annualized spend automatically. Sort or scan by lane and pick the lowest annual cost that also meets your transit and service needs. Export to Excel to share with procurement or to attach to the award decision.

#### The formula behind the numbers

**Body:** All-in cost per shipment is the base rate multiplied by one plus the fuel surcharge percentage, plus accessorials. Annual cost multiplies that by shipments per month and twelve. The method is deliberately simple so every stakeholder can check it by hand. It does not model weight breaks, minimum charges or tiered fuel tables, so for LTL with heavily varying weights compute an average rate per shipment from historical data first.

#### Reading the results

**Body:** The cheapest base rate is not always the cheapest bid. In the sample data, the second Houston to Dallas carrier has a lower base rate but higher fuel and accessorials, so the gap narrows. Look beyond price too.

**Bullets:**

- Transit days and reliability on the lane
- Claims history and liability terms
- Capacity commitments and tender acceptance rates
- Accessorial schedules such as liftgate, residential and detention
- Fuel surcharge table basis and update frequency

#### Common mistakes

**Body:** Bid comparisons go wrong in predictable ways.

**Bullets:**

- Comparing a flat all-in quote with a base rate that excludes fuel
- Ignoring accessorials that your freight triggers every time
- Using volumes that do not match last year's actuals
- Awarding on price alone without a service check

**Cta:** If your freight history sits in ERP shipment and invoice tables, we can help pull real lane volumes and accessorial rates to feed bid analysis.

**Faq:**

#### What is an all-in freight cost?

**Answer:** The total expected charge for a shipment: base rate, fuel surcharge and the accessorial fees that usually apply. It makes quotes from different carriers comparable on the same basis.

#### How do I estimate accessorials?

**Answer:** Review the last six to twelve months of freight invoices for the lane and calculate the average accessorial charge per shipment. Use that figure for every bidder so the comparison is fair.

#### Should I always pick the lowest annual cost?

**Answer:** Not necessarily. Weigh transit time, on-time performance, claims handling and capacity. A slightly more expensive carrier that delivers reliably can cost less overall once failures and expediting are counted.

#### Can I use this for ocean or air?

**Answer:** Yes, as a rough comparison, if you convert each quote into a cost per shipment including surcharges. For detailed ocean quotes with many origin and destination charges, build the all-in figure first and enter it as the base rate.

## Search terms

freight rate comparison spreadsheet, carrier bid comparison template, freight RFQ template excel, transportation bid analysis, LTL rate comparison worksheet, carrier quote comparison, freight bid evaluation template

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