ERP Migration & SelectionFree worksheetPDF, Excel, Word export

ERP Vendor Scoring Matrix (Weighted Worksheet)

A weighted scoring matrix turns a messy ERP selection into a ranked, defensible result. List your criteria, give each a weight, score three vendors from 1 to 5 and the worksheet calculates weighted totals as you type. Export it to Excel for the steering committee.

Download:

A weighted	B weighted	C weighted
1	0.75	1
0.3	0.4	0.3
0.48	0.36	0.6
0.45	0.6	0.45
0.54	0.72	0.36
0.4	0.4	0.3
0.4	0.3	0.4

Total weight (must equal 100)

100

Vendor A total (out of 5)

3.57

Vendor B total (out of 5)

3.53

Vendor C total (out of 5)

3.41

Highest weighted score

3.57

Top total across the three vendors

Spread between best and worst vendor

0.16

Spread between best and worst vendor; under 0.3 is effectively a tie

Score every vendor on the same evidence: scripted demo results, RFP answers and reference calls. Add or delete rows to match your criteria, keep weights summing to 100 and have each committee member score independently before averaging.

Need a second opinion on your shortlist?

Share your exported matrix and we will point out weighting gaps and risks the scores may hide. Optional.

Optional. The tool and every export work without this. No spam.

How to use the matrix

Edit the criteria rows to match what matters in your business, then set weights that sum to 100. Enter a score from 1 (does not meet) to 5 (fully meets with evidence) for each vendor. The weighted columns multiply weight by score and divide by 100, so each vendor ends with a total out of 5. Add rows for extra criteria and delete rows you do not need. Have each committee member score separately, then average the scores and discuss the large disagreements.

Setting weights that hold up

Agree weights before you see pricing or demos. Once vendors are scored, people unconsciously reshape the weights to favour a preferred outcome. Typical manufacturing selections put 25 to 35 percent on functional fit, 10 to 20 percent on technology, 10 to 20 percent on implementation capability, 15 to 25 percent on cost and the rest on vendor viability and security. If the committee cannot agree, use pairwise comparison of the top four criteria and fill the remainder.

Fewer than 12 criteria keeps the matrix readable
No single criterion above 30 percent unless it is a hard gate
Treat must-have failures as pass or fail gates, not weighted scores

Reading the result

The highest total is the leader but not always the winner. A spread under about 0.3 between two vendors is effectively a tie given scoring subjectivity, so use risk, references and negotiation leverage to decide. Look at which category drives the lead: a vendor winning on cost but trailing on implementation is a different risk than one winning on fit. Run a sensitivity check by moving a weight by 5 points and seeing if the ranking changes.

Common mistakes

Scoring from the sales pitch instead of the evidence is the most frequent error. Tie each score to a demo result, an RFP answer or a reference call. Another is scoring cost last and using the matrix to justify a decision already made. Finally, avoid averaging scores that disagree by more than two points without discussion, because the average hides a real unresolved risk.

Frequently Asked Questions

What scale should I use for ERP vendor scoring?

A 1 to 5 scale is common because it is quick and gives enough resolution. Define each level in writing, for example 1 does not meet, 3 meets with configuration, 5 meets out of the box with proof. Without definitions, different evaluators will use the scale differently.

How many vendors should be in the matrix?

Two to four. The worksheet holds three because most selections end with a shortlist of that size. If you have more, run an earlier gate on must-have criteria and reduce the list before doing weighted scoring.

Should price be a weighted criterion?

Yes, but score it from a comparable five-year total cost, not year one. Many committees also keep price separate and compare value per score point after ranking. Either way, make the approach explicit before bids arrive.

Can I score as a group instead of individually?

Individual scoring first, then a calibration discussion, produces better results. Group scoring from the start lets the loudest voice anchor the numbers. Average the independent scores and discuss only the criteria where evaluators differ by two points or more.

If you want vendor evidence pulled automatically from RFP responses and demo notes into a matrix like this, we can discuss a private setup that keeps the documents on your own systems.

Talk to an Expert Explore More Free Tools

Related Tools

ERP Migration & Selection

More ERP Migration & Selection tools

See all

Back to All Tools