Supplier Scorecard Price Comparison Formula

PurchTips edition #98

Having Trouble With Supplier Scorecard Formulas?

When there are multiple criteria for a supplier selection, purchasers often rely on supplier scorecards as a guide.

Such supplier scorecards allow a maximum number of points per criterion. Suppliers’ scores for each criterion are based on predetermined point award schemes.

For example, one criterion may be the location with a maximum of 50 points. The evaluator may award 50 points if the supplier is located within 20 miles of the buyer’s plant, 25 points if the supplier is located between 20 and 40 miles away, and 0 points if the supplier is located more than 40 miles away. That’s pretty simple.

But most purchasers struggle to figure out a way to score prices for comparison. So, I took it upon myself to create a supplier scorecard price comparison formula. Let’s dub it the “Dominick Formula” for ease of recall.

The Dominick Formula is built on this principle: the penalty to a supplier’s pricing score should be proportionate to the degree that its price varies from the Lowest Qualified Bid (LQB). So, if a supplier’s price is 25% higher than the LQB, its pricing score should be 25% lower than that of the supplier who submitted the LQB. If the supplier’s price is 40% higher, its pricing score should be 40% lower. Here is the Dominick Formula:

PS = MP x (1 – ((SP-LQB)/LQB))

Where,

PS = Pricing Score

MP = Maximum Points

SP = Supplier’s Price

LQB = Lowest Qualified Bid

Check out our Supplier RFP Scorecard designed to help your procurement department rate supplier RFPs.

Become a member of one of the world’s largest procurement associations today.

Recommended Reading

 

Visit NLPA Learning, the new home to all of our certifications and online courses. NLPA Learning also includes learning resources, including live and on-demand webinars, publications and reports, articles, templates, white papers, and much more!

Do You Want a More Rewarding Procurement Career?

Are you tired of not getting enough opportunities, respect, and money out of your procurement career? Well, guess what? Nothing will change unless you take action towards becoming a world-class procurement professional.

Earning your SPSM Certification is the action to take if you want to bring the most modern procurement practices into your organization and achieve your career potential. Download the SPSM Certification Guide today to learn how to get started on your journey to a more rewarding procurement career!

Need Better Performance From Your Procurement Team?

Are you a procurement leader whose team isn’t achieving the results you know are possible? Maybe it’s not enough cost savings. Or frustrating performance from the supply base. Or dissatisfied internal customers.

You need a performance improvement plan that’s easy to implement and quick to produce results. The NLPA can help.

Download our whitepaper “The Procurement Leader’s Guide To A More Successful Team.” You’ll learn the 7 steps for transforming your staff into a results-producing, world-class procurement team.

Are You Getting The Most Out of Your NLPA Membership?

Members of the NLPA get more than just articles like this by email. As a member, you also get access to:

  • The Procurement Training & Certification Starter Kit
  • The latest Purchasing & Supply Management Salaries Report
  • Leading-Edge Supply Management™ magazine
  • Members-only webinars 10x per year
  • And more!

If you haven’t been taking advantage of these benefits, why not log in and start now?