Purchasing Power Procurement Blog
Enabling Purchasing Power for Professional Buyers

Relationship Segmentation Procurement Template

Segment Key Suppliers During Strategy Development

This is the tenth procurement template, in our blog series 10 free procurement templates in 10 weeks. Procurement uses the relationship segmentation Excel template to segment buying categories and suppliers.

Suppliers are Segmented into Three Tiers

The procurement sourcing team scores economic and compatibility criteria on a scale of one through five. In all, there are 10 criteria for evaluation on the Excel template. The rating scale for determining each tier is as follows;

  • Tier 1 Strategic Relationship - score greater than 20 points
  • Tier 2 Preferred Relationship - score greater than 15 and less than 20
  • Tier 3 Transactional Relationship - score less than 15

Putting suppliers in the correct tier will drive purchasing power for your organization.

Economic Drivers for Relationship Assessment

The five economic areas evaluated by the procurement sourcing team are:

  1. Buyer View of Category - buying category assessment from transactional (low value) to strategic (high value)
  2. Supply Chain Impact - the probability that supplier will partner to significantly optimize total cost and value.
  3. Innovation Potential - supplier’s capability to increase innovation for our organization
  4. Profit Stability/Growth - the financial and economic strength of supplier’s company
  5. Supplier View of Buyer - the relative importance of our company and organization to the supplier

Compatibility Drivers for Relationship assessment

The five compatibility areas evaluation by the procurement sourcing team are:

  1. Strategic Fit - overall fit of business strategies of the supplier
  2. Processes & Technology - compatibility of supplier’s business processes and technology
  3. Close Proximity - supplier participates in similar or compatible market
  4. Assets & Resources - degree to which a supplier partnership can share assets and resources
  5. Corporate Compatibility - commitment and support to partnering for achievement of long-term goals

Understanding Compatibility Drivers Increases Purchasing Power

Matching category needs with supplier capabilities will increase purchasing power. For example, a procurement category that drives significant value for the organization should not be supported by a supplier with only transactional capabilities. Procurement will drive purchasing power by developing suppliers that can achieve strategic value.

Here is a screenshot of the relationship segmentation assessment template.


To download this free Excel procurement template go to this link; relationship segmentation template. You can download all the free procurement templates at this link.

If you have questions or comments please contact me through this link: http://purchasingtoolpak.com/#contact

Here is a list of all of the free procurement templates that help drive purchasing power for weeks one through ten.

Week 1: sourcing strategy template

Week 2: request for quotation template

Week 3: supplier cost improvement template

Week 4: flexible supplier scorecard template

Week 5: supplier risk assessment template

Week 6: supplier financial viability template

Week 7: inbound transportation survey template

Week 8: project charter template template

Week 9: stakeholder-feedback-template

Week 10: relationship segmentation template