SAP Vendor Evaluation Scorecard Worksheet
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.
| Vendor | Price score (0-100) | Quality score (0-100) | Delivery score (0-100) | Service score (0-100) | Weighted total | Action | |
|---|---|---|---|---|---|---|---|
89.5 | |||||||
78.9 | |||||||
87.1 | |||||||
69 | |||||||
82.2 |
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.
Automated supplier scorecard
Optional expert review of building supplier scores from SAP delivery and quality data.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
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
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
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
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.
Frequently Asked Questions
How does SAP calculate vendor evaluation?
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?
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?
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?
Quarterly is common for strategic suppliers and annually for low-risk ones. Score immediately after a serious incident rather than waiting for the cycle.
Netray can pull on-time delivery and rejection data from your SAP system so the scores are built from facts, read-only.
Related Tools
SAP Goods Receipt Discrepancy Report Template
Document shortages, overages, damage and wrong items found at receipt against the PO, and send the report to the vendor.
SAPSAP Scheduling Agreement Delivery Schedule Worksheet
Lay out schedule lines for a scheduling agreement, track cumulative quantity against the target and see open balance.
SAPSAP Purchase Requisition Approval Form Template
An approval form that mirrors the fields of an SAP purchase requisition so approvers see what they release in ME54N.
SAPSAP Subcontracting Component Tracking Worksheet
Track components sent to a subcontractor, expected consumption and what should still be on their premises.