How to Prepare a Worksheet for Comparing Supplier Bids

Comparing supplier bids is not just about choosing the lowest price. A low-cost proposal may involve transportation, maintenance, or start-up costs, while a more expensive bid could include better warranties or more reliable delivery times. A worksheet helps organize these factors and justify the decision using criteria agreed in advance.

The tool does not replace the contractual, financial, or technical review required for the purchase. It is used to compare proposals consistently and keep a record of the information available, outstanding questions, and exceptions.

1. Define the purchase and criteria before evaluating

Note what is needed, in what quantity, and by when. Include essential requirements and distinguish them from desirable features. This helps prevent the comparison rules from being changed to favor a particular bid.

Initial checklist

• Describe the product or service, scope, and required quantities.
• Set the delivery or start-up deadlines the company needs.
• Separate mandatory requirements from comparative criteria.
• Identify which departments should participate, for example, procurement, operations, finance, or the technical team.
• Determine what documentation or evidence will be requested from all suppliers.

The criteria will depend on the type of purchase. Common ones include price, quality, warranties, delivery times, payment terms, supply capacity, and after-sales service. Depending on the case, location, financial stability, regulatory compliance, information security, or the ability to integrate with the company's systems may also be relevant.

2. Record total cost, not just price

For the financial comparison to be useful, check what each proposal includes and what charges may be added. Total cost of ownership may cover the unit price and other purchase-related items, such as transportation, installation, maintenance, order costs, or payment terms.

• Record the price and unit of measure for each bid.
• Note taxes, transportation, installation, and other associated costs, where applicable.
• Review discounts, advance payments, due dates, and other payment terms.
• Identify costs that are not included or have not been confirmed by the supplier.
• Compare bids on the same basis: same scope, quantities, and period.

If information is missing, mark it as pending rather than treating it as equivalent to the information in the other proposals. A difference in scope may mean that two prices are not directly comparable.

3. Evaluate quality, capacity, and delivery times

The worksheet should capture whether the supplier can deliver what was requested and maintain the terms offered. Quality includes compliance with specifications; reliability may also depend on delivery regularity, available capacity, and the response to incidents.

• Check the bid against the specifications and technical requirements.
• Note warranties, acceptance criteria, and return or repair terms.
• Record the delivery times offered and any conditions that could affect them.
• Assess the capacity to meet the required volume and, if relevant, changes in demand.
• Document support services, response times offered, and contact methods.

When information is not substantiated, distinguish between a supplier's statement and verified evidence. This distinction prevents something that still needs to be confirmed from being presented as verified.

4. Include relevant terms and risks

Not every purchase requires the same review. Adjust the criteria to the nature, importance, and exposure of the procurement. For example, it may be necessary to check compliance, security, continuity of supply, or information handling requirements. The worksheet can flag these aspects, but it cannot by itself determine whether a company is meeting its obligations.

• Record relevant contractual terms and exceptions to the requirements.
• Identify dependencies or limitations that could affect supply.
• Review relevant information about financial solvency or continuity, if the criticality of the purchase warrants it.
• Check the regulatory, environmental, or security requirements applicable to that purchase, where relevant.
• Indicate which aspects require specialist validation or additional review.

5. Weight the criteria and use a common scale

Assign each criterion a weight according to its importance for that purchase. The weights should reflect the priorities agreed by the team and add up to 100% if expressed as percentages. There is no universal weighting: a purchase that is critical to operational continuity may place greater importance on capacity and reliability; for another purchase, financial terms may carry more weight.

To score bids, use the same scale for all suppliers and define what each value means before starting. For example, a scale from 1 to 5 can be used, with the team establishing in advance what the minimum and maximum levels represent. The weighted score for each criterion is calculated by multiplying the score by its weight; the sum allows the result to be compared using the chosen method.

The table is an adaptable structure, not a mandatory list of criteria. Add, remove, or modify rows according to the purchase, and keep the same criteria for all the bids you are comparing.

6. Keep a record of evidence and questions

A score without an explanation can be difficult to review. For each assessment, note the source: commercial proposal, technical data sheet, response to a query, or other documentation received. Also record differences from the requirements and any responses that are still outstanding.

• Save the version of each bid evaluated and its receipt date.
• Note the evidence supporting each score.
• Flag missing data, assumptions, and requested clarifications.
• Record exceptions, changes in scope, and special terms.
• Explain any criterion that could not be evaluated.

7. Review the result with the departments involved

Before deciding, check that the data are comparable and that the weights reflect the purchase's actual needs. Also review whether a high score depends on unconfirmed information or whether a bid fails to meet an essential requirement. The matrix result is a decision-making aid, not an automatic decision.

The final worksheet should make it possible to answer three questions: what was compared, what evidence was used, and what issues remain outstanding. If the procurement requires legal, financial, or technical analysis, that review should be carried out separately and with the appropriate scope.