FormatForge logoFormatForge

Procurement Tools

RFQ Comparison Tool Online Free

Compare line-by-line unit prices and freight from three supplier quotations to identify the lowest evaluated total.

Compare RFQ line prices

Enter item quantities and unit prices from three supplier quotations.

ItemQuantitySupplier A unit priceSupplier B unit priceSupplier C unit priceAction

Rank #1

Supplier C

3635.00

Lines 3535.00 + freight 100.00

Rank #2

Supplier A

3750.00

Lines 3550.00 + freight 200.00

Rank #3

Supplier B

3850.00

Lines 3500.00 + freight 350.00

The lowest quoted total may not be the best award decision. Also review specification compliance, lead time, payment terms, warranty and supplier risk.

Business context

The business problem this tool helps solve

RFQ responses frequently use different units, currencies, exclusions and commercial assumptions. The tool helps buyers compare compliant offers on a common basis and identify questions that must be resolved before award.

What can happen when the issue is ignored

  • Non-comparable quotations
  • Hidden commercial exclusions
  • Incorrect award recommendation
  • Delayed clarification

Who should use this tool?

This guidance is designed for people who need to use rfq comparison tool results in a real approval, planning or operational workflow.

Buyers and category managers

Compare suppliers, quotations, prices and commercial terms.

Operations managers

Balance price, service, quality and continuity of supply.

Small-business owners

Make repeatable purchasing decisions without a complex ERP report.

Input guide

Prepare the inputs before calculation

ColumnPurposeExample
Supplier *Bidder name.Prime Industrial
Item / Lot *RFQ item, service or lot reference.LOT-02
Quoted Price *Price after unit and currency normalisation.485000
Lead Time *Committed delivery period.21 days
Commercial Notes Validity, freight, payment terms and exclusions.Delivered duty paid

Mapping note: Use consistent dates, currencies, units and definitions. A correct calculation based on inconsistent inputs can still lead to a poor decision.

From raw data to a business decision

Use the analysis as a controlled decision-support step: prepare reliable data, review the exceptions, verify the cause and document the action taken.

  1. STEP 1

    Prepare

    Clean the source data and confirm the required fields and reporting period.

  2. STEP 2

    Analyse

    Run the tool and prioritise the most important RFQ results.

  3. STEP 3

    Investigate

    Validate the cause with contracts, transactions and operational evidence.

  4. STEP 4

    Act and review

    Assign actions, export the report and measure improvement in the next cycle.

Decision support

Recommended next actions

These actions are practical review priorities. Apply your organisation's approval limits, tolerance rules and contractual requirements.

  1. 1

    Immediate

    Review the material RFQ exceptions

    Start with records that have the greatest financial, service or operational effect. Confirm the source data before taking action.

  2. 2

    Next

    Identify the business cause

    Separate genuine performance or demand movement from data quality, timing, unit, currency and process issues.

  3. 3

    Monitor

    Create a repeatable review

    Run the analysis on a consistent schedule, record decisions and compare whether corrective actions improve the next period.

Practical review tips

  • Use one reporting period and consistent definitions.
  • Review high-value exceptions before low-value noise.
  • Keep operational context with the analysis.

Common mistakes

  • Using incomplete or stale records.
  • Mixing units, currencies or reporting periods.
  • Taking action without checking the underlying transaction.

Good control practices

  • Define thresholds before reviewing results.
  • Assign each action to an owner and due date.
  • Retain the exported report with management decisions.

Practical examples

How teams use this analysis

The same result can require a different response depending on product criticality, shelf life, contract terms, service impact and available alternatives.

Construction

Bidders exclude different installation and transport elements.

Expected outcome: Clarifications create a like-for-like evaluated total.

Retail

Three suppliers quote different carton quantities.

Expected outcome: All bids are converted to cost per saleable unit.

About this procurement tool

Compare line-by-line unit prices and freight from three supplier quotations to identify the lowest evaluated total. It provides an immediate first-line evaluation without requiring an account, database or server-side processing.

Common use cases

  • Supplier quotation evaluation
  • Purchase approval support
  • Procurement savings analysis
  • Small-business purchasing decisions

How to use it

  1. Enter the requested price, quantity and commercial values.
  2. Review calculated totals, rankings and variances.
  3. Confirm assumptions against supplier quotations and contracts.
  4. Document the final decision using your organisation's approval process.

Important notes

Related Procurement Tools

Frequently asked questions

What does RFQ mean?

RFQ means request for quotation, a process used to collect comparable prices and commercial terms from suppliers.

Can I compare different quantities?

Yes. Each line has its own quantity and the tool extends each supplier's unit price.

Does the tool include freight?

Yes. You can add one freight amount for each supplier.

Can it make the award decision?

It identifies evaluated price differences but procurement should also review technical and commercial requirements.