The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page

Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Supplier Quality Assurance and other Supplier Issues
Forum Username

Elsmar Cove Forum Visitor Notice(s)


Elsmar Cove Forum Sidebar
Custom Search
Monitor the Elsmar Forum
Monitor New Forum Posts
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links







Donate and $ Contributor Forum Access
Sponsored Links
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:


Howard's
International Quality Services

Atul's
Symphony Technologies

Marcelo Antunes'
SQR Consulting

Bob Doering's
Correct SPC - Precision Machining


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest Portal

IEST - Institute of Environmental Sciences and Technology

ASQ - American Society for Quality


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 Rate Thread Content Display Modes
  #9  
Old 27th June 2006, 04:35 PM
Steve McQuality's Avatar
Steve McQuality Steve McQuality is offline
Quality Engineer

 
Registration Date: Mar 2006
Location: State College, Pennsylvania
Age: 51
 
Posts: 108
Thanks Given to Others: 13
Thanked 30 Times in 15 Posts
Karma Power: 40
Karma: 204
Steve McQuality is appreciated, and has over 200 Karma points.Steve McQuality is appreciated, and has over 200 Karma points.Steve McQuality is appreciated, and has over 200 Karma points.
Re: Supplier Rating Excel .xls Spreadsheet form

Quote:
In Reply to Parent Post by Marc

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!!

Thanks!

Sponsored Links
  #10  
Old 10th July 2006, 11:06 AM
Steve McQuality's Avatar
Steve McQuality Steve McQuality is offline
Quality Engineer

 
Registration Date: Mar 2006
Location: State College, Pennsylvania
Age: 51
 
Posts: 108
Thanks Given to Others: 13
Thanked 30 Times in 15 Posts
Karma Power: 40
Karma: 204
Steve McQuality is appreciated, and has over 200 Karma points.Steve McQuality is appreciated, and has over 200 Karma points.Steve McQuality is appreciated, and has over 200 Karma points.
Re: Supplier Rating Excel .xls Spreadsheet form

Quote:
In Reply to Parent Post by Steve McQuality

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
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
Sponsored Links

  #11  
Old 22nd July 2006, 11:27 AM
tonny.xu tonny.xu is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Mar 2006
Location: Dongguan City/China
 
Posts: 4
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 30
Karma: 10
tonny.xu has less than 100 Karma points so far.
Re: Supplier Rating Excel .xls Spreadsheet form

I also want to see several examples for rating suppliers. My company will introduce it into supplier management.
  #12  
Old 24th July 2006, 07:41 AM
Steve McQuality's Avatar
Steve McQuality Steve McQuality is offline
Quality Engineer

 
Registration Date: Mar 2006
Location: State College, Pennsylvania
Age: 51
 
Posts: 108
Thanks Given to Others: 13
Thanked 30 Times in 15 Posts
Karma Power: 40
Karma: 204
Steve McQuality is appreciated, and has over 200 Karma points.Steve McQuality is appreciated, and has over 200 Karma points.Steve McQuality is appreciated, and has over 200 Karma points.
Let Me Help You Re: Supplier Rating Excel .xls Spreadsheet form

Quote:
In Reply to Parent Post by tonny.xu

I also want to see several examples for rating suppliers. My company will introduce it into supplier management.
Tonny:
If you go to the "Post Attachments List" in the header of the Cove and type in a search on "Supplier" or "Vendor", you'll find many examples of supplier ratings. Just look through them and choose one (or choose a couple and combine them) that best fits your company or situation - there is a wealth of information already attached in the Cove. I have downloaded several examples myself!

-Steve
  #13  
Old 28th July 2006, 09:09 AM
Fatboy Fatboy is offline
CQA

 
Registration Date: Sep 2002
Location: Round Rock Texas
Age: 49
 
Posts: 49
Thanks Given to Others: 4
Thanked 3 Times in 2 Posts
Karma Power: 48
Karma: 35
Fatboy has less than 100 Karma points so far.
Re: Supplier Rating Excel .xls Spreadsheet form

here is our supplier rating criteria
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: doc Ratingexplanation.doc (32.0 KB, 987 views)
  #14  
Old 28th July 2006, 01:42 PM
Al Rosen's Avatar
Al Rosen Al Rosen is offline
Super Moderator

 
Registration Date: Jun 2002
Location: Lawn Guyland
Age: 62
 
Posts: 3,547
Thanks Given to Others: 71
Thanked 717 Times in 442 Posts
Karma Power: 413
Karma: 7090
Al Rosen is appreciated, and has over 1700 Karma points.Al Rosen is appreciated, and has over 1700 Karma points.
Al Rosen is appreciated, and has over 1700 Karma points.Al Rosen is appreciated, and has over 1700 Karma points.Al Rosen is appreciated, and has over 1700 Karma points.Al Rosen is appreciated, and has over 1700 Karma points.Al Rosen is appreciated, and has over 1700 Karma points.Al Rosen is appreciated, and has over 1700 Karma points.Al Rosen is appreciated, and has over 1700 Karma points.Al Rosen is appreciated, and has over 1700 Karma points.
Send a message via AIM to Al Rosen
Re: Supplier Rating Excel .xls Spreadsheet form

Quote:
In Reply to Parent Post by Fatboy

here is our supplier rating criteria
Is the rating for each lot or is it accumulated over a specific time period?

When you say for on-time and documentation rating, it's all or nothing, do you award 0 points if one delivery is late or if one lot has inadequate documentation?
__________________
Al
  #15  
Old 28th July 2006, 01:54 PM
Fatboy Fatboy is offline
CQA

 
Registration Date: Sep 2002
Location: Round Rock Texas
Age: 49
 
Posts: 49
Thanks Given to Others: 4
Thanked 3 Times in 2 Posts
Karma Power: 48
Karma: 35
Fatboy has less than 100 Karma points so far.
Re: Supplier Rating Excel .xls Spreadsheet form

Each receipt is assigned a rating case.

You are correct. 0 points are awarded if there are issues (incomplete, in error, missing, etc) associated with documentation. Also, 0 points are awarded if the delivery is outside of the limits (early or late).
  #16  
Old 16th August 2006, 09:35 AM
phopkins phopkins is offline
Inactive Registered Visitor

 
Registration Date: Jul 2006
Location: New Hampsire, USA
 
Posts: 1
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 28
Karma: 10
phopkins has less than 100 Karma points so far.
Lightbulb Re: Supplier Rating Excel .xls Spreadsheet form

That was great. I have just started a position as the Supplier Quality Manger. I have been able to take a lot of information from this Web site. Its been great. I am also looking for some forms or information on Qualifying Vendors for a Dock to stock program and information anyone has on Excel for qualifications for vendors for a dock to stock program, or the Dock to stock program. We are a large manufacturing plant with software and hardware vendors.Anyone have any information? Thanks in advance!!:
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Supplier Quality Assurance and other Supplier Issues

Do you find this discussion thread helpful and informational?


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
Smilies 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
Supplier Quality Rating Scorecard Template (excel spreadsheet) rarguelles Supplier Quality Assurance and other Supplier Issues 4 29th December 2009 02:44 PM
5 Whys Template - Excel .xls Spreadsheet jrubio ISO/TS 16949 - International Automotive Quality Systems Standard 10 27th October 2009 03:15 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
Calculating PPM for a Supplier on a Specific Defect - Excel .xls Spreadsheet Wanted jkittle SPC Monitoring and Statistical Analysis Techniques 7 31st August 2006 02:06 PM



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


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272