# ERP Vendor Scoring Matrix (Weighted Worksheet) > Source: https://netray.co/tools/erp-vendor-scoring-matrix-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A weighted evaluation matrix for three ERP vendors. Edit criteria and weights, score each vendor and read the totals. ## Category erp-migration ## Audience - CIO - ERP project lead - Selection committee ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Criterion **Key:** criterion **Type:** text #### Category **Key:** category **Type:** select **Options:** - Functional fit - Technology - Implementation - Commercial - Vendor - Security and compliance #### Weight **Key:** weight **Type:** number **Unit:** % **Help:** Weights should total 100 #### Vendor A score (1-5) **Key:** a **Type:** number #### Vendor B score (1-5) **Key:** b **Type:** number #### Vendor C score (1-5) **Key:** c **Type:** number #### A weighted **Key:** wa **Type:** number **Expr:** weight * a / 100 **Format:** decimal #### B weighted **Key:** wb **Type:** number **Expr:** weight * b / 100 **Format:** decimal #### C weighted **Key:** wc **Type:** number **Expr:** weight * c / 100 **Format:** decimal **Rows:** **Criterion:** Fit to scripted scenarios (order to cash, procure to pay, make to order) **Category:** Functional fit **Weight:** 25 **A:** 4 **B:** 3 **C:** 4 **Criterion:** Industry-specific capability (traceability, quality, compliance) **Category:** Functional fit **Weight:** 10 **A:** 3 **B:** 4 **C:** 3 **Criterion:** Architecture, integration and API openness **Category:** Technology **Weight:** 12 **A:** 4 **B:** 3 **C:** 5 **Criterion:** Implementation partner team and method **Category:** Implementation **Weight:** 15 **A:** 3 **B:** 4 **C:** 3 **Criterion:** Five-year total cost **Category:** Commercial **Weight:** 18 **A:** 3 **B:** 4 **C:** 2 **Criterion:** Reference calls and vendor viability **Category:** Vendor **Weight:** 10 **A:** 4 **B:** 4 **C:** 3 **Criterion:** Security, data residency and audit controls **Category:** Security and compliance **Weight:** 10 **A:** 4 **B:** 3 **C:** 4 **Totals:** #### Total weight (must equal 100) **Key:** weight **Agg:** sum **Format:** number #### Vendor A total (out of 5) **Key:** wa **Agg:** sum **Format:** decimal #### Vendor B total (out of 5) **Key:** wb **Agg:** sum **Format:** decimal #### Vendor C total (out of 5) **Key:** wc **Agg:** sum **Format:** decimal **Summary:** #### Highest weighted score **Key:** best **Expr:** max(max(sum_wa, sum_wb), sum_wc) **Format:** decimal **Primary:** true **Description:** Top total across the three vendors #### Spread between best and worst vendor **Key:** gap **Expr:** max(max(sum_wa, sum_wb), sum_wc) - min(min(sum_wa, sum_wb), sum_wc) **Format:** decimal **Description:** Spread between best and worst vendor; under 0.3 is effectively a tie **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the matrix **Body:** 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 **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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. **Cta:** 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. **Faq:** #### What scale should I use for ERP vendor scoring? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms erp vendor scoring matrix, erp vendor evaluation matrix excel, erp selection scoring template, weighted decision matrix erp, erp vendor comparison worksheet, erp evaluation criteria weights, erp scorecard excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json