# SAP Vendor Evaluation Scorecard Worksheet > Source: https://netray.co/tools/sap-vendor-evaluation-scorecard-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Score vendors on price, quality, delivery and service with weighted points that mirror SAP vendor evaluation (ME61 and ME6x). ## Category sap ## Erp SAP S/4HANA ## Audience - Buyer - Procurement manager - Supplier quality engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Vendor **Key:** vendor **Type:** text #### Price score (0-100) **Key:** price **Type:** number #### Quality score (0-100) **Key:** quality **Type:** number #### Delivery score (0-100) **Key:** delivery **Type:** number #### Service score (0-100) **Key:** service **Type:** number #### Weighted total **Key:** total **Type:** number **Expr:** price * 0.3 + quality * 0.3 + delivery * 0.3 + service * 0.1 **Format:** decimal #### Action **Key:** action **Type:** select **Options:** - Preferred - Approved - Watch - Corrective action - Phase out **Rows:** **Vendor:** Northline Bearings **Price:** 82 **Quality:** 96 **Delivery:** 91 **Service:** 88 **Action:** Preferred **Vendor:** Kestrel Metals **Price:** 90 **Quality:** 78 **Delivery:** 70 **Service:** 75 **Action:** Watch **Vendor:** Orbit Fasteners **Price:** 75 **Quality:** 92 **Delivery:** 95 **Service:** 85 **Action:** Approved **Vendor:** Delta Castings **Price:** 88 **Quality:** 64 **Delivery:** 58 **Service:** 60 **Action:** Corrective action **Vendor:** Summit Packaging **Price:** 70 **Quality:** 85 **Delivery:** 89 **Service:** 90 **Action:** Approved **Totals:** #### Average weighted score **Key:** total **Agg:** avg **Format:** decimal #### Lowest score **Key:** total **Agg:** min **Format:** decimal #### Highest score **Key:** total **Agg:** max **Format:** decimal **Summary:** #### Spread between best and worst **Key:** spread **Expr:** max_total - min_total **Format:** decimal **Notes:** Weights are 30 percent price, 30 percent quality, 30 percent delivery and 10 percent service. SAP vendor evaluation lets you set your own weights and criteria, so adjust the weights in your own copy after export. ## Content **Intro:** SAP vendor evaluation scores suppliers on criteria such as price, quality, delivery and service, but many teams keep a spreadsheet for the review meeting. This worksheet lets you score vendors, apply weights and see who needs action, then export to Excel. **Sections:** #### How to use the worksheet **Body:** Add one row per vendor and enter a score from 0 to 100 for each criterion. The weighted total is calculated automatically using 30 percent price, 30 percent quality, 30 percent delivery and 10 percent service. Pick an action for each vendor so the meeting ends with a decision. The summary shows the spread between your best and worst supplier, which helps you decide whether consolidation or corrective action pays off. Export to Excel and change the weights if your policy differs. #### Where the scores come from **Body:** In SAP, vendor evaluation uses main criteria such as price, quality, delivery and general service, each with sub-criteria. Quality scores can come from quality notifications and inspection results, delivery scores from on-time and quantity reliability in goods receipt, and price from price variance against market or history. Scores are on a point scale configured in your system. Use the SAP evaluation as the evidence and this worksheet to compare vendors in one view. #### Reading the results **Body:** A high total can hide a failing criterion. A vendor with 96 quality and 58 delivery still hurts your line, so read each column and not just the total. Look for vendors that score well on price but poorly on delivery, because the apparent saving is often paid back in expediting and line stoppage. Compare scores over several quarters; a single bad month is noise, a downward trend is a signal. #### Common mistakes **Body:** Scoring from memory instead of data gives you the loudest incident, not the real pattern. Using the same weights for a commodity part and a critical component hides risk, so keep separate sheets by category. Letting price dominate encourages the cheapest supplier to win until failure. Finally, a score without an action is only a report, so always record the decision and the owner. **Cta:** Netray can pull on-time delivery and rejection data from your SAP system so the scores are built from facts, read-only. **Faq:** #### How does SAP calculate vendor evaluation? **Answer:** SAP scores main criteria and sub-criteria with weights you configure, then combines them into a total score. Some criteria are automatic, based on purchasing and quality data, and others are entered manually. The setup lives in the vendor evaluation configuration. #### Which SAP transactions relate to vendor evaluation? **Answer:** ME61 maintains a vendor evaluation, ME62 displays it, ME63 shows evaluation by vendor and ME6x transactions cover comparisons and lists. Exact menu paths may differ by release. #### What weights should I use? **Answer:** There is no universal answer. Critical components often weigh quality and delivery more heavily, commodities weigh price more. Pick weights per category and document them. #### How often should vendors be scored? **Answer:** Quarterly is common for strategic suppliers and annually for low-risk ones. Score immediately after a serious incident rather than waiting for the cycle. ## Search terms sap vendor evaluation excel, vendor scorecard template, supplier evaluation worksheet, sap me61 vendor evaluation, vendor rating calculation, supplier performance scorecard excel, weighted vendor score --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json