Supplier Rating Excel .xls Spreadsheet form

[sxbalasu]

Does any body has any supplier rating done using excel. Please let me know. I am in the process of developing one.
Thanks

[Sam]

This may need to be up-dated to suit your needs.

NOTE: This form contains Macros!

[Douglas E. Purdy]

Sam,

Do you have your suppliers perform a survey monthly? If not how do you score it on the spread sheet?

[Sam]

The survey scoring is based on an annual response.
If I receive an acceptable "mail -in" survey they get 100 pts,
if I perfrom an on-site they get 100 pts (new vendors only) and will carry 100 pts each month for the year,
If I do not receive a "mail -in" from existing vendors they get 0 pts and will carry 0 pts each month until a response is received.

Vendors that are registered to ISO9K2K or TS16949 do not require mail-in or on-site surveys as long as their quality and delivery performance is acceptable.

[Marc]

Here are two more supplier rating .xls spreadsheets that do the calculations:
Supplier Rating Calculator Spreadsheet.xls
and
Supplier Rating Spreadsheet.xls

[knight_sirk]

Hi to all!

Does anybody have a good example of Supplier performance monitoring (rating system / guidelines)
considering all indicators mentioned in 7.4.3.2 Supplier Monitoring, ISO/TS16949:2002.



Thanks in advance.

[Steve McQuality]

Originally Posted by Marc

Here are two more supplier rating .xls spreadsheets that do the calculations:
Supplier Rating Calculator Spreadsheet.xls
and
Supplier Rating Spreadsheet.xls

Marc:

I've been tasked w/ revamping our Supplier Program. I went through the entire history of this discussion (Now's the time to thank you for starting this forum!!!)... In a recent post, you attached the two files above. Do you have any explanation for the "SR Calculator" you posted? I plugged in some numbers and understand the basics (I think), but I was wondering if you have any explanation for the "Supplier Performance Index Multiplier" that the whole thing spits out in the end?

Thanks,
~Steve

[Marc]

To be honest there are several 'supplier rating calculators' here in the forums that people have sent me or posted in threads to share with others. I'm not familiar with any of them as I'm not in a position to use them.

Hopefully someone else can tell you what the "Supplier Performance Index Multiplier" is.