3 replies to this topic

[genZfoodie]

Hello all,
 
First time post from a first time Quality Control Manager. I am looking for any thoughts on my draft Non-conformance record and on how to format the reference numbers for each.
 
The site is currently ISO9001 accredited and uses a paper based non-conformance system whereby a printed document for each NC or recommendation is signed and filed which makes continuous improvement recommendations very time-consuming e.g. pest control recommendations. 
 
I am looking to produce a simple live excel document to track and close out ncs and recommendations in a more practical way with a view to be audit ready and show trending if customer requirements lead us to further accreditations such as BRC. 
 
Thanks in advance

Attached Files

•  Draft Non-conformance Record Issue 1.xlsx   10.83KB   46 downloads

Edited by genZfoodie, 24 January 2024 - 03:51 PM.

[jfrey123]

Your log is sensible.  You document the real findings and CAPAs on your paper forms but record a summary of them in the log.  I'd suggest adding a couple category columns with drop downs for trend analysis purposes (the drop downs keep the data cleaner and let you pull statistics rapidly with a pivot table).  I learned a bunch of sharepoint stuff, especially MS Lists, and we log our CAPAs from audit findings and observations on this MS List.  Two questions on the entry form ask them to classify the finding (building maintenance, building sanitation, equipment sanitation, GMP, etc) and also how the finding was made (observation, gmp audit, sanitation audit, etc).  I run trend analysis for 8 different plants off of this list, and at a glance can tell which of my buildings are suffering from GMP issues or general sanitation issues.  Also by using MS Lists, they're web based and allow multiple people to add items at the same time (no issues with the excel file being locked by another user).

[kingstudruler1]

that is similar to what i use at my locations.   i attached a copy of one - 

 

Most of my facilites do not have an another paper form but only use this live document for tracking everything.    I like Jfreys additions as well.   they are good ideas.  

 

Attached Files

•  nc headers.xlsx   9.18KB   34 downloads

[francois12]

I utilize excel also and added root cause , correction and effectiveness column as well as status since auditors would look at the root cause and also verify the effectiveness of the identified CA/PA's - during audit i use powerbi to create an interactive dashboard- save time in showing trends especially if you have multiple products / areas to monitor.

 

France