Supplier Scorecard Price Comparison Formula

PurchTips - Edition #98 April 18, 2006

By Charles Dominick, SPSM

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 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 the pricing score of the supplier who submitted the LQB. If the supplier’s price is 40% higher, it’s 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

As a special PurchTips bonus, I’ve set up a supplier scorecard spreadsheet for you to download so you can easily use the Dominick Formula in your own work. Just go to www.NextLevelPurchasing.com/dominick.xls.

(keep reading for a FREE Offer)

Spotlight On Professional Development Opportunities

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

You see, today's employers refuse to reward employees for yesterday's skills. They demand that purchasing professionals like you use the most modern skills and achieve unprecedented results. They want you to save more money, achieve better operational performance, and reduce risk.

Earning your Senior Professional in Supply Management^SM (SPSM) Certification is the action to take if you want to bring the most modern purchasing practices into your organization and achieve your career potential. Learn how to earn your SPSM Certification^SM at:

www.NextLevelPurchasing.com

The Latest Purchasing News!

• Purchasing Managers: Are you struggling to improve your staff’s performance? Wish planning improvements didn’t drain your time? We’ve introduced new services just for you. Read more at: www.NextLevelPurchasing.com/manage
• There are now over 75 jobs preferring candidates with the SPSM^SM Certification posted at www.NextLevelPurchasing.com/jobs

FREE Offer!

Do you want to earn discounts on our training, prizes, and possibly even FREE enrollment in one of our classes? If you have enrolled in one of our full-length classes costing $200 or the SPSM Certification Program, you owe it to yourself to check out how participating in the VIP Program can benefit you.