The Cove Business Standards Discussion Forums
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > >
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

Supplier Rating Excel .xls Spreadsheet form

Monitor the Elsmar Forum
Courtesy Quick Links


Links Elsmar Cove visitors will find useful in the quest for knowledge and support:

Jennifer Kirley's
Conway Business Services


Howard's
International Quality Services


Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum


Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining


Ajit Basrur
Claritas Consulting, LLC



International Standards Bodies - World Wide Standards Bodies

AIAG - Automotive Industry Action Group

ASQ - American Society for Quality

International Organization for Standardization - ISO Standards and Information

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Some Related Topic Tags
microsoft excel .xls .xlsx spreadsheet, supplier selection qualification and approval, forms and templates (general), supplier evaluation/rating/approval
Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
  Post Number #1  
Old 16th September 2002, 03:04 PM
sxbalasu

 
 
Total Posts: n/a
Please Help! Supplier Rating Excel .xls Spreadsheet form

Does any body has any supplier rating done using excel. Please let me know. I am in the process of developing one.
Thanks
Thanks to for your informative Post and/or Attachment!

Sponsored Links
  Post Number #2  
Old 17th September 2002, 08:46 AM
Sam

 
 
Total Posts: n/a
This may need to be up-dated to suit your needs.

NOTE: This form contains Macros!
Attached Files: 1. Scan for viruses before opening, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls Supplier Rating form.xls (25.5 KB, 6392 views)
Thank You to for your informative Post and/or Attachment!
  Post Number #3  
Old 17th September 2002, 11:16 AM
Douglas E. Purdy's Avatar
Douglas E. Purdy

 
 
Total Posts: 555
Sam,

Do you have your suppliers perform a survey monthly? If not how do you score it on the spread sheet?
  Post Number #4  
Old 17th September 2002, 11:41 AM
Sam

 
 
Total Posts: n/a
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.
  Post Number #5  
Old 5th May 2006, 11:24 AM
Marc's Avatar
Marc

 
 
Total Posts: 26,672
Here are two more supplier rating .xls spreadsheets that do the calculations:
Supplier Rating Calculator Spreadsheet.xls
and
Supplier Rating Spreadsheet.xls
Thank You to Marc for your informative Post and/or Attachment!
  Post Number #6  
Old 17th May 2006, 09:58 PM
knight_sirk's Avatar
knight_sirk

 
 
Total Posts: 65
7.4.3.2 Supplier Monitoring

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.
Thanks to knight_sirk for your informative Post and/or Attachment!
  Post Number #7  
Old 27th June 2006, 04:14 PM
Steve McQuality's Avatar
Steve McQuality

 
 
Total Posts: 108
Please Help! Re: Supplier Rating Excel .xls Spreadsheet form

Quote:
In Reply to Parent Post 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
  Post Number #8  
Old 27th June 2006, 04:32 PM
Marc's Avatar
Marc

 
 
Total Posts: 26,672
Re: Supplier Rating Excel .xls Spreadsheet form

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.
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > >

Bookmarks



Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Emoticons are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Form and Form/Record Numbering in an Excel Spreadsheet Subie Girl Excel .xls Spreadsheet Templates and Tools 2 11th August 2016 10:59 AM
Supplier Quality Rating Scorecard Template (excel spreadsheet) rarguelles Supplier Quality Assurance and other Supplier Issues 4 29th December 2009 03:44 PM
Cpk Formula: Am I using it correctly? Excel .xls Spreadsheet form amna77 Excel .xls Spreadsheet Templates and Tools 14 18th September 2009 09:34 AM
APQP Timeline spreadsheet form in Word .doc or Excel .xls wanted chiefexec Excel .xls Spreadsheet Templates and Tools 11 23rd April 2007 04:59 PM
Implementing and Monitoring Vendor (Supplier) Rating - Spreadsheet? George.Temperley Supplier Quality Assurance and other Supplier Issues 6 27th March 2006 02:42 PM



The time now is 10:51 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.



Misc. Internal Links


NOTE: This forum uses "Cookies"