Many organizations have no documented information as to just how well a given supplier's quality performance really stacks up the other suppliers of a similar commodity.  Supplier Quality Performance Data Tracking (SQPDT) services, as we provide them, is painless for our customers.  Not only that, but it has all of the flexibility anyone could imagine.  

As you can understand, we need to have you provide us the information in some form or fashion to get into a database.  To make that happen as painless as possible, the following options are available to make this happen.

• We can capture the information by having your personnel enter the information directly to your database via our secured web site on the internet.
• We can capture the information by having your personnel enter the information at your facility.  It would go directly to your on site database with a data entry program that we will provide you.  You will then upload the accumulated data to us at regular intervals.
• You can capture information from database tracking systems already in place.  Many purchasing programs include the tracking of received items, but rarely include reporting functions which flag excellent or poor supplier quality.  The appropriate information can usually be obtained easily by your information systems group and e-mailed to us at regular intervals.  We then translate the information for inclusion on your web site database.
• You can capture the information on simple Pencil and Paper Log Sheets and mail them to us at regular intervals.  We will do the data entry from your log sheets and enter the data into your web site database.  Together, we will figure out some way to make it happen.

There are any number of items or fields that you may wish to capture for your supplier tracking.  All of this can be easily accomplished.  There are a number of  fields we view as being helpful to determine Supplier Quality Performance.  Some are Essential, while others may be desirable, but are not essential.  Any other fields you desire can also be included.

• Date of your inspection (Essential)
• Type of Inspection (Desirable, but not Essential) This would be for a. Product ininspected while in use at the facility that was found to be deficient (FI), b. Product inspected at a suppliers facility/Source Inspections( SI), or c. Product checked by your Receiving Inspection area (RI).  This will default to RI with hard coded drop down for the other two.
• Inspection Number (Desirable, but not Essential)
• NUPIC Supplier Number (Desirable, but not Essential)
• The Supplier's name (Essential)
• The location of the supplier - City/State (Desirable, but not Essential) Note: This becomes very important for suppliers of the same name with facilities in different locations.  
• Your Purchase Order Number (Desirable, but not Essential)
• Your Purchase Order Line Item Number (Desirable, but not Essential)
• Your Buyer's Initials (Desirable, but not Essential)
• The Type Of Purchase (Desirable, but not Essential) Note: For example with the nuclear industry the types would be Safety Related, Augmented Quality, or Commercial Grade
• The Part Number (Desirable, but not Essential)
• The Part Name (Desirable, but not Essential)
• Whether the Lot inspected was Acceptable, Deficient, or whether the status is uncertain (Essential)  Note: The rule for this item is that if the Acceptability of the  Lot can not be determined, then the status is uncertain (?) until a decision is made.  The supplier, therefore, would not be Responsible for the uncertain Lot being Deficient.
• Is the supplier Responsible, if the Lot under inspection was found to be Deficient (Essential only when the Lot inspected is found Deficient). Normally about 1/3 of the Deficiencies are not the responsible of the supplier.
• Deficiency Report Number (Desirable, but not Essential) There are all kinds of names or initials for Deficiency Report, so whatever you call your Deficiency Reports is what will be shown for your data entry information.
• The Deficiency Code for the deficient Lot, even if it was not the suppliers responsiblity.
• Inspector name/initials/clock number (Desirable, but not Essential)
• Comments (Desirable, but not Essential) This would be for any comments about the inspection.

Note that the Essential fields are date, type of inspection, supplier name, acceptable/deficient, if Deficient was the supplier responsible, and if deficient the deficiency code.

The information will be used to compile a stack Supplier Quality Performance Data Tracking reports.  These reports include:

• A Supplier Quality Performance Data Tracking report which takes all suppliers in your database and shows the number of Lots inspected and the percentage which you have determined are deficient and the responsibility of the supplier.  This report show information for the current quarter, the last quarter, the last 12 months, for the period 13 to 24 months, and for the period 25 to 36 months.  If there are a number of locations, the report will also reflect the same information, but include all locations.  When there are multiple facilities, this report will have an option of either including or excluding the user facility in the supplier summary information.
• There will be a report which shows all Lots inspected where the inspector was not able to determine whether the Lot was acceptable or deficient at the time of inspection.  The supplier NEVER is held responsible on any reports when the inspection information does not reflect the Lot was found deficient and the supplier was responsible for the deficiency.
• There will be a report which determines the top 10 poorest suppliers in the past year.  One of the criteria for this reports is that the supplier MUST have provided a minimum of 25 Lots of material in the past 12 month.  This report will reflect the percentage deficient which were found to be the suppliers responsibility.
• There will be a report which determines the top 10 best suppliers in the past year.  One of the criteria for this reports is that the supplier MUST have provided a minimum of 25 Lots of material in the past 12 month.  This report will reflect the percentage acceptable which were not found to be the suppliers responsibility.
• There will be Commodity Code report which will show suppliers listed for all or any given commodity, rated by the best supplier at the top of each Commodity.  The Supplier Commodity Codes will be identified as an separate thing to do for each facility.  There may be multiple Commodity Codes for each supplier.   When there are multiple facilities, the option will be provided for just the single facility or for all facilities.
• There will be a report for each facility showing all of their suppliers and the appropriate Commodity Codes which they have identified.  For those suppliers which are either new or for some other reason lack Commodity Codes, they will be assigned Commodity Code "999".
• There will be a report which prints out the Commodity Codes list.  The Commodity Code list will be identical to the NUPIC Commodity Code list.
• There will be a report which shows all or a given supplier by Deficiency Codes.  When there are multiple facilities, the option will be provided for just the single facility or for all facilities.
• There will be a report which prints out the Deficiency Codes list.
• Any single facility which desires additional reports will be given the option on their internet screen to print out their special reports anytime they wish.
• There are many other reports that you can print out or view in addition to the above, all available to you and any of your personnel that you desire, directly over our secured internet site.
• The SQPDT group will share the SQPDT summary information on suppliers the NUPIC organization tracks with all NUPIC members on the NUPIC web site.  The results should benefit all members of the NUPIC organization and encourage non-SQPDT members to join.