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?
Leader
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
C Supplier Audit - Looking for a quality audit checklist General Auditing Discussions 3
L Supplier Performance when your supplier is also the customer ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16
L Supplier performance evaluation Supplier Quality Assurance and other Supplier Issues 8
D Definition of Sub-supplier in chemicals IATF 16949 - Automotive Quality Systems Standard 3
A Supplier File info for large (Microsoft) companies. Medical Device and FDA Regulations and Standards News 2
J Revamping Supplier Qualification, Re-evaluation, and Monitoring Requirements ISO 13485:2016 - Medical Device Quality Management Systems 6
J Outsourced Purchasing for Contract Manufacturing vs more typical/simple Supplier Management ISO 13485:2016 - Medical Device Quality Management Systems 5
D "FAI" Requirements/Process for New Supplier Materials Design and Development of Products and Processes 3
T Stellantis supplier quality manual Supplier Quality Assurance and other Supplier Issues 5
G Use of Supplier's Corrective Action Form vs. Corporate Form Supplier Quality Assurance and other Supplier Issues 4
Stefan Mundt AS9100D Engineering sample purchases - Supplier not approved AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
G Audit & Agreements for "Test Laboratory" Supplier? US Medical Device Regulations 4
S Supplier performance required to be reported to supplier? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
P Homologation responsibilities as OEM supplier Manufacturing and Related Processes 0
S Non-approved supplier? Supplier Quality Assurance and other Supplier Issues 3
Q 8.4.2.4 supplier monitoring IATF 16949 - Automotive Quality Systems Standard 3
Q IATF 16949 8.4.2.4 Supplier Monitoring IATF 16949 - Automotive Quality Systems Standard 2
G Control of Approved Supplier List (ASL) When Employees Make Purchases Supplier Quality Assurance and other Supplier Issues 6
V Prototype for chemical supplier IATF 16949 - Automotive Quality Systems Standard 0
Sortinghat Locating Customer Supplier Manuals Customer and Company Specific Requirements 5
Q BMW Supplied Parts Quality Management -> Is there any new supplier quality manual? Customer and Company Specific Requirements 0
M Supplier Control for Unique Product ISO 13485:2016 - Medical Device Quality Management Systems 6
C Process owner for Supplier Controls ISO 13485:2016 - Medical Device Quality Management Systems 11
L Unique Supplier Control Issue AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 0
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

Similar threads

Top Bottom