1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
Dismiss Notice
You must be a registered member in order to post messages and view/download attached files in this forum.
Click here to register.

Supplier Scorecard wanted

Discussion in 'Supplier Quality, Audits & Other Supplier Issues' started by Andy Nichols, Feb 28, 2023.

  1. Andy Nichols

    Andy Nichols Moderator Staff Member

    Joined:
    Jul 30, 2015
    Messages:
    5,109
    Likes Received:
    2,562
    Trophy Points:
    112
    Location:
    In the "Rust Belt"
    Looking for a very simple example, in Excel, which calculates a score (0-5) based on categories such as Quality, Delivery to Schedule, Pricing, and maybe items such as premium freight, service/responsiveness etc.
    TIA
    Anyone?
     
    Andy Nichols, Feb 28, 2023
    #1
  2. Andy Nichols

    Andy Nichols Moderator Staff Member

    Joined:
    Jul 30, 2015
    Messages:
    5,109
    Likes Received:
    2,562
    Trophy Points:
    112
    Location:
    In the "Rust Belt"
    I found this which looks good to customize, if anyone else ever needs a basic one.
     

    Attached File(s): 1. Scan for viruses before using. 2. Report any 'bad' files by reporting this post. 3. Use at your own Risk.:

    Andy Nichols, Feb 28, 2023
    #2
    S1D3K1CK likes this.
  3. S1D3K1CK

    S1D3K1CK Active Member

    Joined:
    Nov 5, 2018
    Messages:
    78
    Likes Received:
    28
    Trophy Points:
    17
    Location:
    The Central Valley
    I currently use QI Macros, which is integrated with Excel, for our internal calculations but am looking into QT9 QMS/ERP software which has internal, Customer and Supplier portals that has scorecard capabilities.
     
    S1D3K1CK, Mar 2, 2023
    #3
    Andy Nichols likes this.
  4. WattsJA

    WattsJA Member

    Joined:
    Jan 13, 2023
    Messages:
    10
    Likes Received:
    4
    Trophy Points:
    2
    I'd love to work on something like this, if there's still a need.
     
    WattsJA, Jul 18, 2023
    #4
  5. Andy Nichols

    Andy Nichols Moderator Staff Member

    Joined:
    Jul 30, 2015
    Messages:
    5,109
    Likes Received:
    2,562
    Trophy Points:
    112
    Location:
    In the "Rust Belt"
    Always!
     
    Andy Nichols, Jul 18, 2023
    #5
    WattsJA likes this.