Audit Summary Report - Nonconformance Aging Analysis

S

spvarkey

#1
hi all,
This is a doubt regarding NC analysis report.
I need to know about the NC Aging analysis report, NC cause and PA based Analysis and NC repition Analysis.Any one can help me out to create these report based on Non- Conformance.
Thank you very much
Regards
S Varkey
 
Elsmar Forum Sponsor

Marc

Hunkered Down for the Duration with a Mask on...
Staff member
Admin
#2
Re: Audit Summary report

Where are these from? For instance I have never heard of a NC Aging analysis report.

Can you give us more details?
 

Ajit Basrur

Staff member
Admin
#3
Re: Audit Summary report

Ageing Analysis report provides a detailed aging analysis of all non-conformances. It provides details such as total number of NCs, number of closed NCs, open NCs, average delay for closed NCs and overdue NCs.
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#4
Re: Audit Summary report

Interesting. I would not make a big blown-out affair over it, but it's worthwhile to look at what takes how long to get done, and why.

I attached a chart that my spreadsheet CA tracking log automatically generates using the TODAY() time counting function, because it so happens I do track time frames and look at the trends for overdue response, overdue action and overdue closure as these have been problem areas in the past.

I look at those three performance metrics and keep in mind who have the highest and lowest numbers, for what types of system issues, what else was going on at the time, and so on to try to draw inferences on what drove the behavior. Maybe you don't want to do this kind of "armchair psychology" which is fine, but it is fair to comment not just on the hard data, but on man-material-machine factors of the timeframe the more questionable data points occurred in.

You could do the same, just do so on paper using sections listing the three types of metrics, the CARs producing the highest/lowest points and the groups who own them. I would avoid using individuals' names because it's not usually about Johnny or Jane being recalcitrant - problems in setting and hitting realistic targets are very often a system matter.

In a different system I use the SUMPRODUCT function to count types of repeat issues among groups.

I hope this helps!
 

Attachments

Last edited:

qusys

Trusted Information Resource
#5
Re: Audit Summary report

I remember that I already contribute to a quite similar question in an another thread.
The most useful thing to do this is to create a tool that can facilitate to handle statistics coming from the audit results ( internal and external).
Besided, it could be useful in order to manage corrective action ,preventive action, follow up, closure, verification of the effectiveness of the implemented action plan.


hi all,
This is a doubt regarding NC analysis report.
I need to know about the NC Aging analysis report, NC cause and PA based Analysis and NC repition Analysis.Any one can help me out to create these report based on Non- Conformance.
Thank you very much
Regards
S Varkey
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#6
Re: Audit Summary report

In a PM I was asked to attach the tracking log I use to produce the chart I attached last month. But it is too big to download: 5.11MB, and I don't have a zip program. :(

Any ideas?
 

Marc

Hunkered Down for the Duration with a Mask on...
Staff member
Admin
#7
Re: Audit Summary report

If you email it to me I'll post it - Check you PMs for my email.
 

Marc

Hunkered Down for the Duration with a Mask on...
Staff member
Admin
#8
Re: Audit Summary report

In a PM I was asked to attach the tracking log I use to produce the chart I attached last month. But it is too big to download: 5.11MB, and I don't have a zip program. :(

Any ideas?
See if this will unzip and open. It is the file Jennifer sent me to post.
 

Attachments

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#9
Re: Audit Summary report

It worked for me. Thank you Mark! :applause:

I'd like to point out I made a change to the chart - it isn't a line chart anymore, but it can be turned into one again.
 
G

gehadeldin

#10
Re: Audit Summary report

I'm really appreciated, Jennifer, it is a great effort!

Thanks Mark!
 
Thread starter Similar threads Forum Replies Date
S Internal ISO 9001:2008 Audit Summary Report wanted General Auditing Discussions 4
N Audit Summary Report - Need template example and help Internal Auditing 3
S Internal Audit Findings Summary Rewrite by an Auditee ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
R Product Audit Summary Form needed IATF 16949 - Automotive Quality Systems Standard 5
Q ISO 9001-2015 Internal audit finding Internal Auditing 12
lanley liao How to understand this words that the planning of internal audit shall take into consideration the results of previous audits? Oil and Gas Industry Standards and Regulations 10
P Audit check for IT company (ISO 9001) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
D Supplier audit Medical Device and FDA Regulations and Standards News 2
M Go Live With New ERP System before Recertification Audit General Auditing Discussions 6
A Add MDSAP to Internal Audit Schedule Medical Device Related Regulations 0
A Define timeline for Major and Miner Audit finding General Auditing Discussions 4
J IATF 16949 Internal Audit question - Auditor's responsibility Internal Auditing 6
A API Monogram audit review process Oil and Gas Industry Standards and Regulations 4
S IATF 16949 Internal Audit Example IATF 16949 - Automotive Quality Systems Standard 7
B Remote IATF 16949 audit preparation General Auditing Discussions 10
M AS9100D Registrar pre-audit requirements AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 15
I Do I need to sign off my annual audit calendar? Internal Auditing 2
R AS9100D internal audit checklist or ISO 9001 2015 to AS9100 D AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
M Nice and simple invitation email to an audit kickoff meeting Internal Auditing 1
M IATF 16949 - Audit of Remote Location/Support Site and IT IATF 16949 - Automotive Quality Systems Standard 4
Q IATF audit - Root Cause Analysis results IATF 16949 - Automotive Quality Systems Standard 5
Q Self-assessment audit information Quality Management System (QMS) Manuals 6
Le Chiffre Online training available for ISO/IEC 17021-1: Requirements for bodies providing audit and certification of management systems Training - Internal, External, Online and Distance Learning 3
xfngrs NIOSH Audit for N95 respirators US Food and Drug Administration (FDA) 1
Sidney Vianna IATF 16949 News Risked Based Audit Day Calculation IATF 16949 - Automotive Quality Systems Standard 2
T AS9100 audit due to facility move AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
M ISO 13485:2016 internal audit checklist Medical Device and FDA Regulations and Standards News 5
A Internal Audit Questions ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
B SAP Audit trail Periodic Review EU Medical Device Regulations 1
N What are the software audit and control steps Reliability Analysis - Predictions, Testing and Standards 2
R Gap Audit Aerospsace and Rail QMS Quality Manager and Management Related Issues 0
salaheddine96 Internal audit planning Internal Auditing 2
A MDSAP Audit Questionnaire Medical Device and FDA Regulations and Standards News 7
H Obligations as a contract manufacturer during an MDSAP audit ISO 13485:2016 - Medical Device Quality Management Systems 5
M What are the basics of Medical Device Single Audit Program (MDSAP)? ISO 13485:2016 - Medical Device Quality Management Systems 7
Sidney Vianna IATF 16949 News Update on the IATF CARA Project (“Common Audit Report Application”) - 12/2020 IATF 16949 - Automotive Quality Systems Standard 1
R ISO 17025 vertical audit checklist wanted Document Control Systems, Procedures, Forms and Templates 2
Z Rapid audit template for plastic parts manufacturing process Manufacturing and Related Processes 12
M ISO 9001 Major Nonconformance Internal Audit Schedule/COVID-19 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 18
S Quality Audit Training Activities Quality Manager and Management Related Issues 2
G IATF Rules for COVID 5th revision - Re-certification audit timing IATF 16949 - Automotive Quality Systems Standard 3
E MDR internal audit Internal Auditing 1
Ed Panek Remote Audit GOTOMEETING thoughts Coffee Break and Water Cooler Discussions 22
B ISO 9001 - "Remote Audit Fee" Registrars and Notified Bodies 13
L IATF external audit virtual (remote) IATF 16949 - Automotive Quality Systems Standard 13
M Audit Criteria Training Materials Internal Auditing 1
K New supplier audit as per V3.1 by French Automotive OEM General Auditing Discussions 2
S Complexity Rating - CB adding another audit day for "high complexity" AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
U Internal Auditor not trained but done Audit for some process Nonconformance and Corrective Action 5
B Looking for 10 Internal Audit Online Training Participants ISO 17025 related Discussions 2

Similar threads

Top Bottom