Supplier Comparison Sheet
Compare up to five supplier quotations by evaluated cost, lead time, payment terms, delivery conditions, specification compliance, warranty and overall weighted score.
What is a Supplier Comparison Sheet?
A supplier comparison sheet helps procurement teams evaluate multiple supplier quotations using consistent commercial and operational criteria before selecting a preferred supplier.
Compare Prices
Compare quotation values, freight, other charges and discounts.
Compare Lead Times
Evaluate how quickly each supplier can meet the requirement.
Check Compliance
Consider whether each supplier meets the requested specification.
Support Selection
Use weighted scoring and rankings to support supplier-selection decisions.
Compare more than the lowest price
The workbook combines commercial value with delivery, compliance and supplier-performance considerations.
Evaluated Cost
Compare quoted item value, freight, other charges, discounts and final quotation value.
Lead Time
Compare supplier delivery lead times and automatically generate a lead-time score.
Payment Terms
Score supplier payment terms from 1 to 5 based on their commercial value.
Specification Compliance
Record supplier compliance against the requested specification from 0–100%.
Warranty & Support
Consider warranty, after-sales support and supplier service quality.
Overall Score
Automatically calculate a weighted overall score and supplier ranking.
Compare up to five suppliers
Enter the commercial and evaluation information from each supplier quotation into the comparison sheet.
Enter quotation values and commercial charges.
Enter lead time, compliance and qualitative scores.
Excel calculates price and lead-time scores.
Suppliers receive weighted overall scores and rankings.
Document the procurement decision and approvals.
Balanced supplier scoring
The workbook uses a practical weighted evaluation model so supplier selection is not based only on price.
Price
Final evaluated quotation value has the largest weighting.
Lead Time
Shorter delivery lead times receive a higher score.
Specification Compliance
Evaluate how closely the supplier meets the requested requirement.
Commercial & Supplier Factors
Payment terms, delivery terms, warranty, quotation validity and supplier service.
Automatic comparison and ranking
The workbook performs the key calculations after you enter each supplier's quotation information.
Price Ranking
Automatically ranks suppliers from the lowest to highest final quotation value.
AutomaticLead-Time Score
Automatically evaluates supplier lead time relative to competing quotations.
AutomaticWeighted Overall Score
Combines price and non-price criteria into one supplier evaluation score.
AutomaticRecommendation
Highlights the highest-ranked supplier as RECOMMENDED and second place as ALTERNATE.
AutomaticLowest price does not always mean best supplier
A lower quotation can still create operational risk if the supplier cannot meet specifications, delivery requirements, quality expectations or other mandatory conditions.
Use the calculated score as decision support and apply your organization's procurement policy and approval requirements before awarding a purchase.
Where Supplier Comparison fits
Use the comparison sheet after receiving supplier quotations and before issuing the Purchase Order.
1. Purchase Requisition
Approve the internal requirement before starting supplier sourcing.
2. Request for Quotation
Collect supplier prices and commercial terms.
3. Supplier Comparison
Compare quotations and identify the preferred supplier.
4. Purchase Order
Issue the approved order to the selected supplier.
Download the Supplier Comparison Sheet
Use the Excel workbook to compare up to five supplier quotations and calculate weighted evaluation scores.
Supplier Comparison — Frequently Asked Questions
How many suppliers can I compare?
The Excel template is designed to compare up to five supplier quotations in one evaluation.
Does the spreadsheet automatically rank suppliers?
Yes. It calculates price ranking, lead-time scoring, weighted overall scores and final supplier rankings.
Does the cheapest supplier automatically win?
No. Price is an important part of the evaluation, but the overall score also considers lead time, specification compliance and other supplier factors.
Can I change the evaluation weights?
Yes. The weighting cells can be adjusted to match your organization's purchasing priorities. Make sure the total weighting remains 100%.
What does specification compliance mean?
It represents how closely the supplier's quotation meets the requested technical or commercial specification. The template accepts a compliance value from 0 to 100%.
What does RECOMMENDED mean?
The supplier with the highest calculated overall score is marked RECOMMENDED, while the second-ranked supplier is marked ALTERNATE.
Should I select a supplier only from the calculated score?
No. The score should support the evaluation rather than replace procurement judgment, mandatory compliance checks, budget approval or your organization's purchasing policy.