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

Fully vaccinated are you?
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
D Supplier OTD Slip Due to Shipping Delays or Natural Disaster AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
D Re-labeler - audit the supplier EU Medical Device Regulations 2
Evelyn7E The fastest way to get supplier to ship good parts to you Supplier Quality Assurance and other Supplier Issues 10
J Verification of purchased product / supplier questionnaires ISO 13485:2016 - Medical Device Quality Management Systems 2
D Question on Supplier Quality (SCAR) ISO 13485:2016 - Medical Device Quality Management Systems 6
Z REACH: contradictory statement from supplier? REACH and RoHS Conversations 4
G How to implement H&S and Quality Control Requirements in Contract for Potential Supplier? Contract Review Process 6
R Select the 1 Supplier based on the Parts Durability from 6 Supplier Samples using Minitab Using Minitab Software 11
K Why does load cell supplier requires force verification General Measurement Device and Calibration Topics 3
D Question and advice for a supplier self audit questionnaire ISO 13485:2016 - Medical Device Quality Management Systems 6
D Special IATF audit of sub-supplier IATF 16949 - Automotive Quality Systems Standard 18
S IATF 16949 Supplier selection criteria 8.4.1.2 IATF 16949 - Automotive Quality Systems Standard 2
M Supplier approved list - Notified body, regulatory body Supply Chain Security Management Systems 4
N Making improvements in supplier relationship last? Supplier Quality Assurance and other Supplier Issues 6
K Supplier Qualification for Engineering Consultant? Supplier Quality Assurance and other Supplier Issues 3
M Supplier evaluation Supplier Quality Assurance and other Supplier Issues 5
briteme4 ASL - AS9100 / Supplier Survey Supplier Quality Assurance and other Supplier Issues 3
A System for Supplier Documents Quality Assurance and Compliance Software Tools and Solutions 7
T IMDS submission without supplier's input? RoHS, REACH, ELV, IMDS and Restricted Substances 4
J Supplier not responding to PPAP request APQP and PPAP 5
D Supplier audit Medical Device and FDA Regulations and Standards News 2
lanley liao Does all of the suppliers need to integrated into the supplier list qualified of the company? Oil and Gas Industry Standards and Regulations 2
S Distinction between a critical supplier and a Virtual manufacturer EU Medical Device Regulations 2
R AS9102 FAI Change in Material / Process Supplier AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
John Broomfield Five ways to botch your supplier management program Misc. Quality Assurance and Business Systems Related Topics 7
C Supplier survey - 200 to 250 duppliers Supplier Quality Assurance and other Supplier Issues 3
J Where is the definition of a critical supplier? ISO 13485:2016 - Medical Device Quality Management Systems 5
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 12
P Training department ideas and development for automotive supplier Training - Internal, External, Online and Distance Learning 6

Similar threads

Top Bottom