ISO certs from suppliers - Expiration Tracking Method

#11
I have a spreadsheet in Excel and use conditional formatting to change the colour of the expiry dates from black to orange @ 60 days or less to expiry, and red @ 30 days or less to expiry. As I record delivery performance and other KPI's in the same spreadsheet on a monthly basis, it alerts me to the upcoming expiry dates in plenty of time.

I have just over 100 suppliers by the way, so this is comfortably manageable.
@ Scanton, would you mind sharing the template you use for this spreadsheet? I was thinking of doing something similar but can't figure out how to setup the conditional formatting correctly so that it turns a different color at the specified time range. Would greatly appreciate the head start if you're able to share, thanks.
 
Elsmar Forum Sponsor

Scanton

Wearer of many hats
#12
Apologies for the late reply.

I am not able to share my actual spreadsheet as it would been a massive pain to undo/un-link all of the sensitive data contained within it, however I have mocked up how I track the days remaining using a traffic light style system to give you an idea as to how I do it. It's fairly simplistic, but it serves its purpose (please see file attached).
 

Attachments

#13
Apologies for the late reply.

I am not able to share my actual spreadsheet as it would been a massive pain to undo/un-link all of the sensitive data contained within it, however I have mocked up how I track the days remaining using a traffic light style system to give you an idea as to how I do it. It's fairly simplistic, but it serves its purpose (please see file attached).
Thank you so much for providing this for me, this is more than helpful and I genuinely appreciate your support, thanks again.
 

ScottK

Not out of the crisis
Leader
Super Moderator
#14
The audit report belongs to the registrant, who can redact the type of sensitive information before forwarding it on to customers. As far as I know, the overwhelming majority of management system reports issued by CB auditors are meaningless, with very few nonconformities, extremely rare OFI's and observations. For the small percentage of value added reports with meaningful information, I believe, that customers should have access to the information. A certificate is an attribute and, as most of us know, louzy systems attain and maintain certification; even substandard systems do. A certificate, just like a driver's license, does not tell anyone if the system is robust or not.

If I were working in a position of supplier quality management, I would demand to receive copies of the supplier's surveillance audit reports and scrutinize the information contained therein.
All due respect Sidney - no way.
As a supplier to big companies for many years, I never did that. When I was asked, which was very rarely, I always refused and said "I'm sorry we treat those as confidential between us and our registrar".
It will give the auditor too many preconceptions and they won't be able to be objective... especially if they've never been to us.
Never once got pushback on that.

Today I'm on the other side and I'm in charge of hundreds of suppliers - I also do not ask that of my current supplier base for the same reason... my QEs/auditors are going to these companies to learn, not to follow up on someone else's work unless it was their own or a colleague's. The audit scope is defined in advance based on history and what processes we need to sample. I don't want them chasing what wasn't uncovered by our own colleagues.
 

Sidney Vianna

Post Responsibly
Leader
Admin
#15
Don’t understand why you take issue with my position. As a supplier, you can refuse to share the report. As a customer you have the latitude not to request from the suppliers. It is your choice.

Someone’s driving record tells me much more about their driving ability than a driver’s license does. In the IAQG process, the OASIS database facilitates the request from interested stakeholders in accessing the CB audit reports. I have heard many OEM reps mentioning how eye opening some of the information contained therein was. If I were in charge of a supply chain effort I would like to know as much as possible about my tier one suppliers.
 
Thread starter Similar threads Forum Replies Date
S Do ISO certs require an Apostille? ISO 13485:2016 - Medical Device Quality Management Systems 14
K Putting a regulated device on the market without the proper ISO Certs and CE Marking EU Medical Device Regulations 9
B ISO 9001:2015 Registered Companies ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
C ISO Cert and Parent Company is not Certified ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
B Is 14971 Annex C checklist now in ISO/TR 24971 required to complete prior to 510k filing? ISO 14971 - Medical Device Risk Management 1
Q ISO Training Providers to fix careless workers? Training - Internal, External, Online and Distance Learning 19
M PROBLEM IN SCOPE OF ISO 13485 ISO 13485:2016 - Medical Device Quality Management Systems 6
S ISO 13485 signing of Procedures etc. ISO 13485:2016 - Medical Device Quality Management Systems 4
N ISO 13485 Scope Reduction Other ISO and International Standards and European Regulations 2
Sidney Vianna ISO 37301 - Compliance management systems – Requirements with guidance for use Other ISO and International Standards and European Regulations 0
S ISO 3497 Metallic Coatings Other ISO and International Standards and European Regulations 1
R Basic Lab Practices - related to ISO 17025 testing labs ISO 17025 related Discussions 1
JDJohnson Micrometer & Caliper Calibration (ISO-9001) General Measurement Device and Calibration Topics 26
M Can veterinary implants be ISO 13485 certified? ISO 13485:2016 - Medical Device Quality Management Systems 23
D Audit Report details when ISO 13485:2016 and cGMP 21 CFR 820 are applicable ISO 13485:2016 - Medical Device Quality Management Systems 6
G Why do you guys think ISO 9001 doesn't ask specifically for preventive maintenance? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
D Training for ISO 17025 ISO 17025 related Discussions 2
R Looking for ISO 13485 Internal Audit Checklist ISO 13485:2016 - Medical Device Quality Management Systems 7
FuzzyD ISO 13485 change in process ISO 13485:2016 - Medical Device Quality Management Systems 3
D ISO 9001:2015 Calibration Procedures Manufacturing and Related Processes 16
R Interesting Discussion Chapter 7.5 of ISO 13485 for manufacturers of mobile medical applications ISO 13485:2016 - Medical Device Quality Management Systems 4
J ISO Certificate Expiration ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
V ADDING NEW MEDICAL DEVICE / Product, WHEATHER THIS AFFECTS EXISTING ISO 13485 CERTIFICATION? ISO 13485:2016 - Medical Device Quality Management Systems 4
G Auditing Top management: 6.3 ISO 9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
S Question regarding AQL - ISO 3951 Inspection, Prints (Drawings), Testing, Sampling and Related Topics 0
Sidney Vianna Informational ISO/NP TS 17012 - Guidelines for use of remote methods in conducting audits of management systems Other ISO and International Standards and European Regulations 0
G IT being audited during ISO 9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
S Is the ISO/SAE 21434 a certifiable standard? IATF 16949 - Automotive Quality Systems Standard 3
K Subcontractors Providing Services Under MDD or MDR need ISO 13485 from EU Notified Body? CE Marking (Conformité Européene) / CB Scheme 5
2 What is ISO? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
Moncia Customer satisfaction monitoring - ISO 9001 and 14001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
M Document Control ISO and FDA ISO 13485:2016 - Medical Device Quality Management Systems 7
E Theoretical project: Implementing ISO 13485:2016 into a start up acrylic bone cement manufacturer ISO 13485:2016 - Medical Device Quality Management Systems 4
Sidney Vianna ISO 9001 News ISO 9001 Design Specification to be developed - May 2022 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
M Regulatory compliance ISO 14001 ISO 14001:2015 Specific Discussions 5
M ISO 13485: 2016 Lot numbering question ISO 13485:2016 - Medical Device Quality Management Systems 4
Q Documented Evidence of Training ISO 13485: 2016 ISO 13485:2016 - Medical Device Quality Management Systems 33
D Customer Survey Example - ISO 13485:2016 ISO 13485:2016 - Medical Device Quality Management Systems 7
M ISO 20417:2021, Requirements for e-doc 6.6.5 Other Medical Device Related Standards 3
S ISO 9001:2015 Project Plan ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
lisap Design falling outside ISO scope Misc. Quality Assurance and Business Systems Related Topics 11
G Common items : which iso 9001 are common to all areas? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
G ISO 9001 - when implementing customer requirement ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
V ISO 9001 or ISO 17065 required for an organization issuing 5 star rating certification of digital experience? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
A VDA 19.2 vs. ISO 14644-1 VDA Standards - Germany's Automotive Standards 0
P How to keep a ISO 9001:2015 certification when a company is sold ? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
D ISO 9001:2015 Recertification Audit Timing ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
B ISO 14971:2019 amendment A11:2021 questions ISO 14971 - Medical Device Risk Management 5
L ISO 11607-1 Packaging system validation Design and Development of Products and Processes 9
Sidney Vianna Informational Changes to Terms and Definitions in ISO/TC 176 Standards since ISO 9000:2015 was issued. ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 0

Similar threads

Top Bottom