Supplier Tracking Software

S

Steven Sulkin

#1
#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.
 
Paper to QMS ad
Elsmar Forum Sponsor
D

Dawn

#2
#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
#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
#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
#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
#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
 
You must log in or register to reply here.
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
R Supplier/Vendor Surveys (360) Supplier Quality Assurance and other Supplier Issues 0
was named killer AS9100 Supplier Approval Requirements AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 10
B AS9100 8.4.1 Supplier Selection/Evaluation criteria and reevaluations AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 3
J Sub-supplier change from manual to automated process - same specs - Report to FDA? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
M Supplier Audit Report - Template for second party audit wanted Lean in Manufacturing and Service Industries 1
T Difference between a subcontractor and a supplier ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 21
Ed Panek Corona Virus impact on Supplier Audits and Received Parts ISO 13485:2016 - Medical Device Quality Management Systems 4
NDesouza Verification of Supplier RCCAs Nonconformance and Corrective Action 5
K Supply Agreement Regarding MDR 2017/745 - Manufacturer-supplier cooperation Other Medical Device Related Standards 0
L How to deal with an ISO 13485 Supplier Audit nonconformance ISO 13485:2016 - Medical Device Quality Management Systems 17
P Supplier Audits in the wake of COVID-19 ISO 14971 - Medical Device Risk Management 2
T Ideas for developing a Supplier Quality Management System, non automotive ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
B Vendor (Supplier) Evaluations and Reports Supplier Quality Assurance and other Supplier Issues 11
F Is there such a thing as 'Critical supplier' status under the Dept. of Health (UK)? Medical Device and FDA Regulations and Standards News 2
A MSA results differences - Supplier results vs. My results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
G Supplier flowdown verification of tests and revisions Supplier Quality Assurance and other Supplier Issues 0
B Supplier of design and manufacture process ISO 13485:2016 - Medical Device Quality Management Systems 10
S Software for Supplier Charge back and internal PPM General Information Resources 2
R IATF/IAOB Red Supplier Pilot Program IATF 16949 - Automotive Quality Systems Standard 1
M Changing supplier of critical raw material (III class device) Other Medical Device and Orthopedic Related Topics 1
S VW Supplier Product Safety Representative (PSB) upgrade to PSCR VDA Standards - Germany's Automotive Standards 0
S Process Map for Supplier Process Maps, Process Mapping and Turtle Diagrams 5
D Licensee as a Supplier on the ASL Medical Device and FDA Regulations and Standards News 10
R Definition Key Supplier - Definition of Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 7
V IATF 16949 8.4.1 Control of externally provided processes, products and services - Should the CB be on our Approved Supplier List? IATF 16949 - Automotive Quality Systems Standard 10
M Risk Classification For Supplier - Clinical Research Organisation (CRO) Supply Chain Security Management Systems 3
shimonv Rigid rules for handling supplier audit findings ISO 13485:2016 - Medical Device Quality Management Systems 11
G Supplier Checking With Gauge Pin Problem Solving, Root Cause Fault and Failure Analysis 2
R AS9100 DELTA FAI - Sub-supplier for plating changed AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 2
P IATF 16949 8.4.2.4 Supplier Monitoring IATF 16949 - Automotive Quality Systems Standard 2
A Supplier Quality Standard vs Senior Management Direction Supplier Quality Assurance and other Supplier Issues 2
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
R Supplier evaluation and business needs in the context of ISO 13485 ISO 13485:2016 - Medical Device Quality Management Systems 2
J IATF 16949 8.4.1.2 Supplier selection process IATF 16949 - Automotive Quality Systems Standard 4
Q Supplier audit question cataloque VDA Standards - Germany's Automotive Standards 0
Ed Panek Inactive key supplier question - We are not actively buying from them ISO 13485:2016 - Medical Device Quality Management Systems 2
Ajit Basrur Quality Agreement with supplier covering medical devices and consumer requirements ISO 13485:2016 - Medical Device Quality Management Systems 2
K Supplier re-evaluation (API Q1) Manufacturing and Related Processes 8
C Approving AWS as a supplier (ISO 13485) ISO 13485:2016 - Medical Device Quality Management Systems 1
R Supplier related drawings and verification of process requirements - Source Inspection AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 3
Q AS9120 Vendor of ESD Monitoring Equipment needs to be in the Approved Supplier List? AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 8
R Supplier Controls we can place on Single-Source Suppliers ISO 13485:2016 - Medical Device Quality Management Systems 2
N Declaration of Conformity for Product from Supplier ISO 13485:2016 - Medical Device Quality Management Systems 6
M Supplier selection criteria - Medical devices ISO 13485:2016 - Medical Device Quality Management Systems 3
Ed Panek Can a single supplier fit two or more categories for risk? ISO 13485:2016 - Medical Device Quality Management Systems 2
V Determining FDA 820 (registration) vs ISO 13485 - Supplier gives us the kit ISO 13485:2016 - Medical Device Quality Management Systems 1
G ISO 22442 Supplier Audit Checklist - Medical devices utilizing animal tissues General Auditing Discussions 0
Similar threads
Top Bottom