Rank #1
Supplier C
3635.00
Lines 3535.00 + freight 100.00
Procurement Tools
Compare line-by-line unit prices and freight from three supplier quotations to identify the lowest evaluated total.
Enter item quantities and unit prices from three supplier quotations.
| Item | Quantity | Supplier A unit price | Supplier B unit price | Supplier C unit price | Action |
|---|---|---|---|---|---|
Rank #1
3635.00
Lines 3535.00 + freight 100.00
Rank #2
3750.00
Lines 3550.00 + freight 200.00
Rank #3
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
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.
This guidance is designed for people who need to use rfq comparison tool results in a real approval, planning or operational workflow.
Compare suppliers, quotations, prices and commercial terms.
Balance price, service, quality and continuity of supply.
Make repeatable purchasing decisions without a complex ERP report.
Input guide
| Column | Purpose | Example |
|---|---|---|
| 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.
Use the analysis as a controlled decision-support step: prepare reliable data, review the exceptions, verify the cause and document the action taken.
Clean the source data and confirm the required fields and reporting period.
Run the tool and prioritise the most important RFQ results.
Validate the cause with contracts, transactions and operational evidence.
Assign actions, export the report and measure improvement in the next cycle.
Decision support
These actions are practical review priorities. Apply your organisation's approval limits, tolerance rules and contractual requirements.
Immediate
Start with records that have the greatest financial, service or operational effect. Confirm the source data before taking action.
Next
Separate genuine performance or demand movement from data quality, timing, unit, currency and process issues.
Monitor
Run the analysis on a consistent schedule, record decisions and compare whether corrective actions improve the next period.
Practical examples
The same result can require a different response depending on product criticality, shelf life, contract terms, service impact and available alternatives.
Bidders exclude different installation and transport elements.
Expected outcome: Clarifications create a like-for-like evaluated total.
Three suppliers quote different carton quantities.
Expected outcome: All bids are converted to cost per saleable unit.
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.
RFQ means request for quotation, a process used to collect comparable prices and commercial terms from suppliers.
Yes. Each line has its own quantity and the tool extends each supplier's unit price.
Yes. You can add one freight amount for each supplier.
It identifies evaluated price differences but procurement should also review technical and commercial requirements.