Bid Comparison Matrix

Weighted offer scores

Enter an importance weight and scores for offers A and B for each criterion. For each offer, the result is the sum of weight times score divided by total weight. Weights do not need to add up to 100. With weights of 3 and 1, scores of 100 and 0 give A a total of 75. Scores of 0 and 100 give B a total of 25.

Scoring limits

Every score must be between 0 and 100, with higher values always meaning better performance. A price or delivery time is not a score. Decide how values map to scores before comparing offers. A zero weight removes a criterion from the result. Do not offset failure to meet a mandatory technical requirement with good scores elsewhere. This tool provides a subjective weighted comparison of two offers, not a formal tender evaluation or an automatic purchasing decision.

See which criteria drive the decision

Let two example criteria have weights of 2 and 3. Give offer A scores of 90 and 60, and offer B scores of 70 and 80 respectively. Total weight is 2 + 3 = 5. A scores (2 × 90 + 3 × 60) / 5 = 72, while B scores (2 × 70 + 3 × 80) / 5 = 76. The difference A minus B is 72 − 76 = −4 points. B leads under the selected weights and scores, which does not establish superiority in every unmeasured property.

Write down what each criterion represents before scoring. Scoring the same cost effect under both price and total cost can weight some properties twice. Higher scores must consistently mean better performance in every row. Using the price amount directly as a score conflicts with a scale where higher scores mean better performance. Review the importance of related criteria together. For close results, change the weights and check whether the ranking survives. If small subjective changes reverse the ranking, do not present a decisive advantage. Multiplying all weights by the same factor leaves the average unchanged. Recheck the evaluation basis when adding another offer or criterion.

Frequently asked questions

How do you calculate weighted scores?

For example, dividing weighted scores by total weight gives offer A 75 points from scores 100 and 0 with weights 3 and 1. Offer B receives 25 from 0 and 100, and this preliminary comparison assumes consistent scales and preference direction without checking mandatory technical requirements or legal compliance.