Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainLogistics & ShippingFreight Quote Comparison

SpreadsheetLogistics & ShippingFree

Freight Quote Comparison

Compare carrier quotes on total freight cost with fuel surcharge and accessorials, cost per pallet and per hundredweight, and transit time.

Shown with sample data

Colour

Freight Quote Comparison

Compare carrier quotes on total freight cost with fuel surcharge and accessorials, cost per pallet and per hundredweight, and transit time.

Cheapest that meets deadline
BlueLine Logistics (broker)
Its total cost
$1,411
Lowest quote overall
$1,242
Spread, highest to lowest
$1,266
Total cost by carrier
  • Atlas Expedite$2,508.80
  • Ridgeway Freight$1,617.73
  • Carver Trucking$1,593
  • Summit Express$1,547.40
  • BlueLine Logistics (broker)$1,410.90
  • Pioneer Intermodal$1,242.40

How to use it

  1. 1On Shipment, enter the pallet count, total weight and the maximum transit days you can accept.
  2. 2Add one row per quote with mode, linehaul charge and the fuel surcharge percentage quoted.
  3. 3Add every accessorial you will actually need; missing ones are the most common surprise on the invoice.
  4. 4Enter each carrier’s on-time percentage from your own history or their scorecard.
  5. 5Choose from the quotes that meet the deadline, weighing total cost against reliability.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

The cheapest linehaul rate is often not the cheapest shipment. Enter each carrier’s linehaul, fuel surcharge percentage, accessorial charges (liftgate, residential, appointment, inside delivery) and transit days; the sheet calculates the true total, cost per pallet and per hundredweight, ranks the quotes, checks each against your delivery deadline and names the cheapest carrier that arrives in time.

Who it’s for

  • LTL and truckload quote decisions
  • Annual carrier rate reviews
  • Checking broker quotes against direct carriers
  • Building a business case for a carrier change

What’s included

  • Quotes sheet: Each quote with total cost, unit costs and deadline check.
  • Shipment sheet: The shipment being quoted.

How to use it

  1. 1On Shipment, enter the pallet count, total weight and the maximum transit days you can accept.
  2. 2Add one row per quote with mode, linehaul charge and the fuel surcharge percentage quoted.
  3. 3Add every accessorial you will actually need; missing ones are the most common surprise on the invoice.
  4. 4Enter each carrier’s on-time percentage from your own history or their scorecard.
  5. 5Choose from the quotes that meet the deadline, weighing total cost against reliability.

Tips

  • Fuel surcharges usually move weekly with the US DOE diesel price index; compare quotes from the same week.
  • Ask whether the quote is based on the freight class and dimensions you will ship. Reclassification after pick-up can add 20% or more.
  • Check liability cover per pound in each carrier’s tariff, especially for high-value freight.

Questions

What is a fuel surcharge?

A percentage added to the linehaul to cover changes in diesel prices, usually tied to a published weekly fuel index. Total = linehaul × (1 + fuel %) + accessorials in this sheet.

What is cost per hundredweight (cwt)?

Total cost divided by the shipment weight in hundreds of pounds. It is the standard way to compare LTL costs across shipments of different sizes.

What are accessorial charges?

Charges for services beyond dock-to-dock: liftgate, residential or limited-access delivery, inside delivery, appointment, detention, redelivery and hazmat handling.

Related searchesfreight quote comparisoncarrier rate comparisonltl quote comparisonshipping quote spreadsheetfreight cost calculatorfuel surcharge calculator

Details

Format
Spreadsheet
Category
Logistics & Shipping
Sheets
2
Setup
15 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetLogistics & ShippingFree

Freight Quote Comparison

Compare carrier quotes on total freight cost with fuel surcharge and accessorials, cost per pallet and per hundredweight, and transit time.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Logistics & Shipping
Sheets
2
Setup
15 min
Level
Beginner
Price
Free

Your copy is private to you.

More logistics & shipping templates

View all
Shipment & Delivery Tracker2 sheets

In transit

4

Overdue or exception

5

On-time rate

71%

ABCD
1DirectionCustomer or supplierCarrierService
2OutboundNorthwind RetailUPSStandard
3OutboundBlue Harbor CafeFedExExpress
4InboundEcoPackDHLFreight
5OutboundGreenfield SchoolUSPSStandard
Shipments
SpreadsheetLogistics & Shipping

Shipment & Delivery Tracker

Inbound and outbound shipments with tracking numbers, transit times, late and exception flags, and on-time rate and cost per shipment by carrier.

10 min setupPreview
Fleet Vehicle Maintenance & Mileage Log2 sheets

Vehicles

4

Maintenance cost

$1,840

Due a service or inspection

1

ABCD
1DateVehicleTypeWork done
2Aug 14Van 1ServiceFull service, oil and filters
3Sep 2Van 2TyresTwo front tyres
4Sep 20Truck 1InspectionAnnual inspection, passed
5Oct 5Van 2RepairRear brake pads and discs
Service log
SpreadsheetLogistics & Shipping

Fleet Vehicle Maintenance & Mileage Log

Track each vehicle’s mileage, services, inspections and running cost per mile.

10 min setupPreview

Packing List

Packing list number: PL-0000 Date: Date Invoice number: INV-0000 Order / PO: Number

ShipperConsignee
Your companyCustomer company
AddressDelivery address

Shipment details

Carrier and serviceCarrier, service level
Tracking or waybillNumber
Ship dateDate

Contents

PackageDescription of goodsSKU
1 of 3Item descriptionSKU
2 of 3Item descriptionSKU

Total packages: 3 Total net weight: kg Total gross weight: kg Total volume: m³

DocumentLogistics & Shipping

Shipping Packing List

What is in each box of a shipment: items, quantities, weights and dimensions, for the receiver and for customs.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ