Supplier Rate Comparison Worksheet
Compare supplier quotes on a common basis including unit, quantity, freight, lead time, validity, finish, minimum order, and commercial exceptions.
What this resource is for
The lowest visible unit price is not always the lowest reviewed cost. Freight, minimum quantities, lead time, validity, currency, finish, packaging, exclusions, and payment terms may change the commercial result.
This worksheet normalises supplier responses onto a comparable basis while preserving the evidence and date behind each rate.
Designed for: Estimators and purchasing teams comparing material, finishing, subcontract, and bought-out component quotes.
What is included
- request basis
- supplier response register
- unit and currency normalisation
- freight and surcharge review
- lead-time and validity comparison
- exceptions and exclusions
- selected basis and approval
Fields and review points
How to use it
Set one comparison basis
Define the same specification, quantity, unit, delivery point, finish, and required date for every supplier response.
Normalise without destroying source evidence
Retain each quoted value, then show conversions, freight, surcharges, minimums, and exclusions in separate review columns.
Record the selected commercial basis
Choose the rate used in the estimate, state why it was selected, record the evidence date, and flag when it must be refreshed before issue or award.
Important review boundaries
- Example supplier prices are not market benchmarks.
- Confirm tax, currency, freight, and Incoterms treatment where relevant.
- A selected rate should be refreshed when validity or scope changes.
Questions about this resource
Should supplier names be included in customer-facing quotes?
That is a business and commercial decision. This worksheet is designed for internal rate review; customer output should disclose only what the approved quote basis requires.
Can non-price factors be compared?
Yes. Lead time, validity, quality requirements, capacity, location, minimum order, and exceptions can be recorded alongside price without converting them into an invented score.
Use the editable version with your own reviewed data
We will email the download link and add you to the Kwantflow newsletter for practical RFQ and estimating guidance.
