Buy Now

Supplier Relationship Management
Excel Template

Implement a system for evaluating the performance of suppliers or vendors with our Supplier Relationship Management Excel Template. Structured tables and dynamic visualizations (graphs and charts) give you all the tools you need to track vendor performance.
Unlock Access

What's Inside the Supplier Relationship Management Template?

Details | 4 Sheets 

Supported Versions | Excel 2010, 2013, 2016, 2019, Office 365 (Mac)

Category | Operations

Tags | Supply Chain, Vendor Review, Logistics, Sourcing, SRM

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Supplier Relationship Management (SRM) Excel Template

Input your criteria for vendors for fields such as quality, delivery, innovation, support and cost in the Scorecard sheet.

It would seem that once you secure a relationship with a supplier and establish parameters, your work would be done. In reality, the work has just begun. 

Supplier Relationship Management is a systematic assessment of suppliers’ assets and capabilities. Using our Supplier Relationship Management Excel Template, you can better manage your suppliers and create massive value for your company by understanding how each vendor contributes to the well-being (or detriment to the company). 

If you find this template useful, you’ll also want to check out our Warehouse Management System, Product Quality Control and Contract Management templates. Similar to this template, the Contract Management Template helps you manage ongoing contracts and assign accountability to your partners.

Start by adding company standards for each goal area in the Standard Reference sheet. Add weight for each goal area with the target criteria and milestone specifications. 

Move to the Scorecard sheet and add your suppliers. You can add up to 6 in this template. Inputs like Goal Area, Criteria, Weight and Total from the Standard Reference sheet will populate on this sheet. 

At the top of the sheet is a table titled Set KPI Limits. You can change your visualization limits to your standards here. 

You can add or collapse groups for the most simple data summary. 

Customize your Goal Area criteria for suppliers in the Scorecard sheet of our Supplier Relationship Management Excel Template
The Supplier Review sheet will reflect your inputs, allowing you to view how supplier rank compared to each other and overall.

Last but not least, navigate to the Suppliers Review tab. This sheet makes it easy to check each supplier's achievement compared with other suppliers. You can compare them by Cost, Quality, Delivery, Innovation, Support and a comprehensive rating based on all of those factors. 

To the right side of the screen, you can also view a Monthly Review which can be manipulated by clicking the Review button. The chart will auto populate, allowing you to view and analyze the five points over a period of months. 

More Operation Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  •  
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  •  
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  •  
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW