How to evaluate and rate your vendor's performance in MS Excel? Have a look at this video and learn more about how to professionally evaluate your vendors. Also, there is a reference to a Vendor Performance Evaluation Excel worksheet and start immediately with your comparison:
We support you and your company by providing this Vendor Performance Evaluation Form template, which will save your time, cost and efforts and help you to increase the results that come out of your purchasing process and vendor relations! This Vendor Rating Comparison in Excel works with a weighting system, and will automatically calculate all the results in Excel. You will see that its intuitive, ready-to-use and logically structured.
This blank Excel Vendor Rating system template enables you to compare 3 (or more) suppliers on a list of items for their supply of Commodities or Services. The scale goes from Excellent (4), Good (3), Fair (2) to Poor (1) and it has the option to place Comments.
You can fill in the Vendor Evaluation Sheets for each supplier, and see the results in 1 overview. After downloading, perform the following steps to gain insight in the current suppliers:
1. Evaluate Vendor on items listed and check the appropriate columns, because some items may not apply.
2. Indicate Vendor’s overall rating by checking the appropriate column.
3. If Vendor’s overall rating is fair or poor, please explain under “Comments”
4. Return to the Office of Purchasing.
Some of the following items are on the list of items to compare:
Delivers on Time
Condition of Goods on Arrival
Follows Instructions
Number of Rejections
Handles Rejections
Promptly
Handling of Complaints
Technical Assistance
Emergency Aid
Furnishes Specially
Requested Information
Delivers Without Constant
Follow-up
Keeps Promises
Other ( )
0 Comments