Supplier Tracking Software

S

Steven Sulkin

#1
We need to track on time delivery, non conformances, and corrective actions from our suppliers. Anyone have an access or excel database we can use?

Please email me at [email protected]

Thanks in advance.
 
Elsmar Forum Sponsor
D
#2
Same problem here Steven. I am also looking for a good program. (and cheap). I will let you know if I find something!
 
A

Andy Bassett

#4
Just for info
I once created a simple excel database with 3 sheets in it;
One for overdue deliveries
One for Quality Problems
One for Invoice defects.
Purchase were able to complete this becuase all the above information ran over their desk ie they received copies of all the QC Rejection Sheets. They had to sign off all invoices that did not match the orders. And they got a simple print-out every Thursday of which suppliers were overdue with deliveries.
All very crude, but you should aim for a consistent system, not a high tech system.
Problems

A. Programmer made a small programme that allowed you to press a button and produce a ream of paper that compared the suppliers with each other. Ie in January supplier X is our top supplier. PROGRAMME never worked, but to do this manually was not more than 2-3 hours work per month.
B. Purchasers needed a lot of discipline to keep entering the data. Make the sheets as simple as possible, ie no more than 4-5 columns.

My experience is that if you want the system to be maintained it should be very simple. It does not matter what it is telling you (At least at the beginning of the implementation)it should however be consistent.
You will be amazed at the suppliers reaction when they know that they are being measured (Irrespective what the results actually say).

Regards


------------------
Andy B
 
S

Steven Sulkin

#5
Have you been using the excell sheets a while? How many buyers do you have?

We are developing a more automated approach, though I like the idea of a simple spreadsheet. We just purchased a piece of software to help us query for reports a little easier. Our current measure is avg (price variance from standard, delivery, and percent conforming).

Our next step is to use the report to write corrective action requests and develop suppliers, but that's an entirely different matter, for a time that is far, far away, on a Distant planet and all. ;)
 
S

Steven Sulkin

#6
Andy- do you track corrective actions too? We have since decided to absorb tracking into our internal corrective action system. A lots changed since I first posted ;)
 
A

Andy Bassett

#7
Sorry Steve
Only just caught your reply.
One page of the Excel sheet was for Goods-in Quality problems. If we were able to send the goods back (wasnt always the case) we sent them a standard form that asked them;
1.Why didnt you find the problem-
2.What was the cause of the problem.
3.What are you going to do to correct the problem in the future.
The number of the form and the date of the reply was noted in the excel sheet, and yes the supplier was chased if he didnt answer.

In all honesty a greater emphasis was placed on getting a reply from the supplier than what the reply actually said.

Does this help.

As regards the Corrective Action system, irrespective of where the problems have come from i have nearly always orgnaised that they go into an Excel sheet so that someone can maintain an overview.

Regards

Andy
 
Thread starter Similar threads Forum Replies Date
N On-Time Supplier PPAP Tracking APQP and PPAP 3
A Tracking Supplier Surcharges - Looking for forms or templates to use Document Control Systems, Procedures, Forms and Templates 3
C Tracking Premium Freight - Audit nonconformance - 7.4.3.2 Supplier Monitoring Supplier Quality Assurance and other Supplier Issues 11
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
G How to implement H&S and Quality Control Requirements in Contract for Potential Supplier? Contract Review Process 6
R Select the 1 Supplier based on the Parts Durability from 6 Supplier Samples using Minitab Using Minitab Software 11
K Why does load cell supplier requires force verification General Measurement Device and Calibration Topics 3
D Question and advice for a supplier self audit questionnaire ISO 13485:2016 - Medical Device Quality Management Systems 6
D Special IATF audit of sub-supplier IATF 16949 - Automotive Quality Systems Standard 18
S IATF 16949 Supplier selection criteria 8.4.1.2 IATF 16949 - Automotive Quality Systems Standard 2
M Supplier approved list - Notified body, regulatory body Supply Chain Security Management Systems 4
N Making improvements in supplier relationship last? Supplier Quality Assurance and other Supplier Issues 6
K Supplier Qualification for Engineering Consultant? Supplier Quality Assurance and other Supplier Issues 3
M Supplier evaluation Supplier Quality Assurance and other Supplier Issues 5
briteme4 ASL - AS9100 / Supplier Survey Supplier Quality Assurance and other Supplier Issues 3
A System for Supplier Documents Quality Assurance and Compliance Software Tools and Solutions 7
T IMDS submission without supplier's input? RoHS, REACH, ELV, IMDS and Restricted Substances 4
J Supplier not responding to PPAP request APQP and PPAP 5
D Supplier audit Medical Device and FDA Regulations and Standards News 2
lanley liao Does all of the suppliers need to integrated into the supplier list qualified of the company? Oil and Gas Industry Standards and Regulations 2
S Distinction between a critical supplier and a Virtual manufacturer EU Medical Device Regulations 2
R AS9102 FAI Change in Material / Process Supplier AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
John Broomfield Five ways to botch your supplier management program Misc. Quality Assurance and Business Systems Related Topics 7
C Supplier survey - 200 to 250 duppliers Supplier Quality Assurance and other Supplier Issues 3
J Where is the definition of a critical supplier? ISO 13485:2016 - Medical Device Quality Management Systems 5
U Approved Vendor (supplier) List Supplier Quality Assurance and other Supplier Issues 8
M Supplier requirements - Major supplier is a Non-Profit registered with ICCBBA (FDA UDI) Supply Chain Security Management Systems 12
P Training department ideas and development for automotive supplier Training - Internal, External, Online and Distance Learning 6
B Software service provider as critical supplier ISO 13485:2016 - Medical Device Quality Management Systems 5
T AS9100D Clause 10.2.1g Supplier Corrective Action for each and every nonconformity? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
S Supplier protocol for the Quality Supplier Quality Assurance and other Supplier Issues 6
A API Spec Q1 Purchasing Process - Supplier Reevaluation based on Supplier Risks 5.6.1.4 Oil and Gas Industry Standards and Regulations 17
D Approved supplier list - Distributors question ISO 13485:2016 - Medical Device Quality Management Systems 6
G Supplier delivered recent PPAP, should he deliver yearly layout inspection? IATF 16949 - Automotive Quality Systems Standard 4
E ISO 13485 QMS certification as a Supplier ISO 13485:2016 - Medical Device Quality Management Systems 8
G Supplier doesn't share drawings IATF 16949 - Automotive Quality Systems Standard 15
S Use of raw materials by two supplier CE Marking (Conformité Européene) / CB Scheme 2
D Are Supplier Quality Agreements Quality Records ? Other Medical Device Regulations World-Wide 9
G Dealing with non conformity caused by Supplier Components detected in the production line IATF 16949 - Automotive Quality Systems Standard 14
G Supplier doesn't accept the complaints Supplier Quality Assurance and other Supplier Issues 20
K New supplier audit as per V3.1 by French Automotive OEM General Auditing Discussions 2
A ASL requirement when the supplier is certified for ISO 13485 ISO 13485:2016 - Medical Device Quality Management Systems 6
S Supplier Management ISO 13485: 2016- Which supplier needs to fill in a self assessment form? ISO 13485:2016 - Medical Device Quality Management Systems 6
D Approved supplier list for R&D ISO 13485:2016 - Medical Device Quality Management Systems 5
M SemaTech SSQA Standardized Supplier Quality Assessment - my favorite tool ever Manufacturing and Related Processes 1

Similar threads

Top Bottom