SBS - The best value in QMS software

Supplier Rating Excel .xls Spreadsheet form

S

sxbalasu

#1
Does any body has any supplier rating done using excel. Please let me know. I am in the process of developing one.
Thanks
 
Elsmar Forum Sponsor
#4
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.
 
K

knight_sirk

#6
7.4.3.2 Supplier Monitoring

Hi to all! :bigwave:

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.
:thanx:
 

Steve McQuality

Quality Engineer
#7
Marc said:
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? :confused: 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

Hunkered Down for the Duration with a Mask on...
Staff member
Admin
#8
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.
 

Steve McQuality

Quality Engineer
#9
Marc said:
To be honest there are several 'supplier rating calculators' here in the forums that people have put 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.
Thanks Mark. I looked in the "posts" section to see if I could find who originally posted it and couldn't find it. Luckily, I didn't have to go all the way back through the "supplier" forum to find your post! I'll just sit back and be patient in case someone knows. I've found enough other "stuff" to keep me busy for a while!!:cool:

Thanks!
 
#10
Steve McQuality said:
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? :confused: 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
I wanted to bump this question back up on the "Current Discussions" list to see if anyone could help me out with this question. Thanks!

-Steve
 
Thread starter Similar threads Forum Replies Date
R Supplier Quality Rating Scorecard Template (excel spreadsheet) Supplier Quality Assurance and other Supplier Issues 4
M Supplier 8D Report-Rating Procedure Problem Solving, Root Cause Fault and Failure Analysis 10
A Supplier Rating from SAP QM Module Data Supplier Quality Assurance and other Supplier Issues 2
K Supplier Performance and Supplier Rating Process - AS9100 Requirements AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 12
M Supplier Rating Form with Quality, Cost, Delivery wanted Document Control Systems, Procedures, Forms and Templates 4
C Supplier Performance Index (Spi) - Supplier Rating Supplier Quality Assurance and other Supplier Issues 10
I Service Supplier Rating where Objective Pass/Fail Data is not Available Service Industry Specific Topics 7
R Supplier Rating System Ideas and Suggestions Quality Manager and Management Related Issues 3
D How to use the Supplier Rating Calculator Supplier Quality Assurance and other Supplier Issues 2
S Supplier Quality Rating - What to evaluate Supplier Quality Assurance and other Supplier Issues 11
J Need Advice on Supplier Performance Rating System Supplier Quality Assurance and other Supplier Issues 9
I WHO is managing your supplier rating data? Supplier Quality Assurance and other Supplier Issues 4
F Supplier Rating System - Weighting low volume suppliers vs. high volume suppliers Supplier Quality Assurance and other Supplier Issues 2
S Staff Augmentation Vendor (Supplier) - Performance Evaluation (rating & index) Supplier Quality Assurance and other Supplier Issues 9
F Review my Supplier Performance Measure and Rating System Procedure Supplier Quality Assurance and other Supplier Issues 3
D Supplier Rating Metrics and Normal Weighted Allotments or Percentages example Supplier Quality Assurance and other Supplier Issues 1
G Implementing and Monitoring Vendor (Supplier) Rating - Spreadsheet? Supplier Quality Assurance and other Supplier Issues 6
Q Supplier Analysis - Rating using an FMEA - Anyone ever try something like this? Supplier Quality Assurance and other Supplier Issues 11
A ISO 9001 Clause 7.4.1 Supplier Rating System - Seeking simple system example Supplier Quality Assurance and other Supplier Issues 28
B Supplier (Vendor) Rating - What type of supplier rating system to utilize Supplier Quality Assurance and other Supplier Issues 1
U Approved Vendor (supplier) List Supplier Quality Assurance and other Supplier Issues 8
M Supplier requirements - Major supplier is a Non-Profit registered with ICCBBA (FDA UDI) Supply Chain Security Management Systems 7
P Training department ideas and development for automotive supplier Training - Internal, External, Online and Distance Learning 6
B Software service provider as critical supplier ISO 13485:2016 - Medical Device Quality Management Systems 4
T AS9100D Clause 10.2.1g Supplier Corrective Action for each and every nonconformity? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
S Supplier protocol for the Quality Supplier Quality Assurance and other Supplier Issues 6
A API Spec Q1 Purchasing Process - Supplier Reevaluation based on Supplier Risks 5.6.1.4 Oil and Gas Industry Standards and Regulations 15
D Approved supplier list - Distributors question ISO 13485:2016 - Medical Device Quality Management Systems 6
G Supplier delivered recent PPAP, should he deliver yearly layout inspection? IATF 16949 - Automotive Quality Systems Standard 4
E ISO 13485 QMS certification as a Supplier ISO 13485:2016 - Medical Device Quality Management Systems 8
G Supplier doesn't share drawings IATF 16949 - Automotive Quality Systems Standard 15
S Use of raw materials by two supplier CE Marking (Conformité Européene) / CB Scheme 2
D Are Supplier Quality Agreements Quality Records ? Other Medical Device Regulations World-Wide 9
G Dealing with non conformity caused by Supplier Components detected in the production line IATF 16949 - Automotive Quality Systems Standard 14
G Supplier doesn't accept the complaints Supplier Quality Assurance and other Supplier Issues 20
K New supplier audit as per V3.1 by French Automotive OEM General Auditing Discussions 2
A ASL requirement when the supplier is certified for ISO 13485 ISO 13485:2016 - Medical Device Quality Management Systems 6
S Supplier Management ISO 13485: 2016- Which supplier needs to fill in a self assessment form? ISO 13485:2016 - Medical Device Quality Management Systems 6
D Approved supplier list for R&D ISO 13485:2016 - Medical Device Quality Management Systems 5
M SemaTech SSQA Standardized Supplier Quality Assessment - my favorite tool ever Manufacturing and Related Processes 1
D Supplier Quality level category help - high level ISO 13485:2016 - Medical Device Quality Management Systems 6
J Supplier Controlled Shipping (GM CS1) Condition Manufacturing and Related Processes 3
L Supplier within the Organization ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
D Supplier Quality - How to classify a supplier level Medical Device and FDA Regulations and Standards News 10
P Understanding DFMEA and PFMEA - Supplier Related IATF 16949 - Automotive Quality Systems Standard 21
S Can assembly manufacturing sub-supplier be certified IATF 16949? IATF 16949 - Automotive Quality Systems Standard 6
M How Supplier Capacity check is done by competitors Manufacturing and Related Processes 0
C One Time Service Supplier - Temperature and Humidity Testing Service ISO 13485:2016 - Medical Device Quality Management Systems 5
M Supplier Audits - Stop Wasting Everyone's Time! General Auditing Discussions 15
G Supplier management when the supplier is your headquarter IATF 16949 - Automotive Quality Systems Standard 3

Similar threads

Top Bottom