Comparative Statement Template for Supplier Evaluation and Purchase Decision

Description

The above image is only a preview. This Comparative Statement Template helps purchase teams compare supplier quotations with structured evaluation fields. It supports data-driven decision-making for procurement teams. Moreover, it brings clarity to vendor selection by combining cost, delivery and compliance factors.

The sheet allows users to record unit price, taxes and logistics costs. It also calculates Total Landed Cost automatically. Therefore, buyers can understand the full cost impact of each quotation. The template includes payment terms, warranty support and delivery ratings. It also includes the important Technical Deviation Score and Commercial Deviation Score. These scores help evaluate how closely a supplier meets technical and commercial requirements.

This tool works well for evaluating new suppliers. It also helps assess existing vendors through Past Performance Score. Additionally, a separate New Supplier Risk Score supports organisations onboarding new vendors. Weighted scoring is applied to calculate an Overall Weighted Score, ensuring balanced and fair evaluation. As a result, teams identify the best supplier based on value, reliability and compliance and not only cost.

Key evaluation fields include:
• Total Landed Cost comparison
• Price Rating based on the lowest offer
• Delivery Time Rating for supply performance
• Payment, Warranty and Compliance Scores
• Technical and Commercial Deviation Scores
• Past Performance Score for existing vendors
• New Supplier Risk Score for new vendors

Who can use this Comparative Statement Template?

• Manufacturing organisations evaluating critical parts
• Engineering and fabrication companies reviewing quotations
• EPC and project-based industries analysing vendor offers
• Trading firms comparing multiple quotation options
• MSMEs managing structured procurement processes
• Purchase departments needing documented justification

The template supports ISO 9001, ISO 14001 and ISO 45001 purchasing requirements. It also strengthens vendor approval processes. Furthermore, it ensures transparency in audit reviews and management reporting. All calculations use clean numeric cells without interference. Weighted scoring provides clear ranking. The Recommended Supplier appears automatically based on the highest score.

Additionally, this sheet is easy to use, yet it maintains a professional structure for all procurement environments. It also supports multiple suppliers and can be expanded for more items. Teams can make purchase decisions confidently, and suppliers can be assessed with fairness and accuracy.