Discrepancy Costs Measuring Methods - Excel spreadsheets or other methods

M

Munther J

#1
Hi, I would like to know if you have any tools or methods of measuring discrepancies cost regarding incoming/manufacturing Non-Conformance materials .

I would like to have some key factors, easy to retrieve and easy to explain so I can give my organization information of what we need to prioritize. The cost can give info to aim actions cross company to decrease NCMR?s.

Do you have any nice Excel sheets or some methods to share?

// Jonny
 
Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#4
Welcome to the Cove!

It might also be interesting to adapt one of the elephant charts in the Post Attachments List. Instead of counting incidents, the cost could be entered in. If you are dealing with them and are interested in a log that also graphs the data for analysis, you might try applying the EMS elephant chart. Process 1, Process 2 etc. could be your suppliers. The Reportable/Non-reportable could be used for recording whether or not a threshold of cost was exceeded, or else that feature and its related formulas could be adapted to sum costs instead of count Reportables entries.

If you did choose to use one of these charts I would really appreciate your letting us know how it goes. Please be advised that these are open source tools; you are free to adapt them for your own use. If you do, we would appreciate sharing your results because there are probably others with the same question as you have.
 
Last edited:
Thread starter Similar threads Forum Replies Date
T The “use-by“ time limit - Terminology discrepancy - MEDDEV & HS EU Medical Device Regulations 0
S Internal audit discrepancy - We missed a few audits that were scheduled Internal Auditing 12
M Raw stock material testing discrepancy using an XRF (x-ray fluorescence) analyzer Manufacturing and Related Processes 7
KyloDen Checking Threads - Discrepancy in threads that are machined In-House vs. Outsourced General Measurement Device and Calibration Topics 11
J Discrepancy in Manual Counting - Finished Goods Boxes ISO 13485:2016 - Medical Device Quality Management Systems 13
marmotte 510(k) "received date" discrepancy Other US Medical Device Regulations 1
P Audit Finding - Work Instruction discrepancy Nonconformance and Corrective Action 25
G Receiving Discrepancy Report vs Nonconformance Report Nonconformance and Corrective Action 4
C (DDR) Delivery Discrepancy Report received from customer for late delivery Nonconformance and Corrective Action 3
C How to analyse the internal audit finding in term of discrepancy Internal Auditing 4
RoxaneB ISO 9001:2000 Transition Poll Discrepancy? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 18
N do you need to update PPAP due to a discrepancy APQP and PPAP 1
V Corrective Action for Discrepancy - Where to start and how to document Nonconformance and Corrective Action 2
A EAR costs and recommendations under MDR CE Marking (Conformité Européene) / CB Scheme 0
J Australian TGA Sponsor costs Other Medical Device Regulations World-Wide 3
T Reasons to change certification body and typical costs Registrars and Notified Bodies 16
M Informational Understanding Costs And Risks For HFE Usability Studies — Part 1: Testing In-House Medical Device and FDA Regulations and Standards News 0
C AS9100, Clause 8.5.1.3 - First Article Inspection Costs AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 16
B Warranty costs - What is your definition of a "warranty cost"? Nonconformance and Corrective Action 1
P Health Insurance Costs Career and Occupation Discussions 3
Edward Reesor Role of increased regulatory costs in increasing risk ISO 13485:2016 - Medical Device Quality Management Systems 10
Edward Reesor MDSAP (Medical Device Single Audit Program) Costs Canada Medical Device Regulations 7
L Percentage Thumb Rules for Quality Costs Misc. Quality Assurance and Business Systems Related Topics 1
B Costs, Benefits, and Consequences of ISO 9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
J IEC 60601 Medical Device Testing House Costs IEC 60601 - Medical Electrical Equipment Safety Standards Series 9
F 2 Year Part Re-Validation and FAIR Costs (Aerospace Parts) AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 3
D AS9100 Audit Preparation Costs and Hours AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 6
L Forecasting of Product Returns and Warranty Costs Quality Tools, Improvement and Analysis 4
I IT Costs Analysis Excel Chart Excel .xls Spreadsheet Templates and Tools 6
C Third Party Inspection and Certification Costs for a Project Registrars and Notified Bodies 7
D Company Percentile Ranking - Customer Concern and Warranty Costs Benchmarking 4
Q ASQ's CMQ Certification - Training Costs and Benefits Professional Certifications and Degrees 3
S Planning and Costs to Implement ISO / IEC 27000 - Where to start? IEC 27001 - Information Security Management Systems (ISMS) 2
K AS9100 Implementation, Registration and Annual Costs to maintain Registration? AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 4
L Contract CMM Inspection Companies and Costs Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
R Development Rejection Costs in COPQ (Cost of Poor Quality) Calculations Misc. Quality Assurance and Business Systems Related Topics 6
M What are your Nonconformance Costs Based On Nonconformance and Corrective Action 1
M How many companies are required to capture Nonconformance Costs Nonconformance and Corrective Action 3
C Reducing Material Handling Costs - In-Floor Tow-Line Conveyor System Lean in Manufacturing and Service Industries 7
H Advantages and Disadvantages (costs) of Process FMEA FMEA and Control Plans 9
C Appraisal Costs - Include Plant Scale Maintenance? Misc. Quality Assurance and Business Systems Related Topics 3
P Measuring Costs of Poor Quality Quality Manager and Management Related Issues 2
S Mouse Embryo Assay and Endotoxin Testing Requirements and Costs US Food and Drug Administration (FDA) 3
Wes Bucey Broadband Speeds & Costs in the US - I feel cheated! After Work and Weekend Discussion Topics 9
P Check Fixture Costs - Simple check fixture (go/no go) that checks 3-4 points Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
M NCA-3800 Requirements and Costs - Entering the Nuclear Market Various Other Specifications, Standards, and related Requirements 15
G Costs associated with setting up new medical device QMS ISO 13485:2016 - Medical Device Quality Management Systems 4
D Visible Planning & Barashi for Quality and Costs Design and Development of Products and Processes 2
Proud Liberal ISO 14001 and TS 16949 Implementation and Annual Costs Registrars and Notified Bodies 3
Jen Kirley Slaying Workplace Safety Costs The Reading Room 4
Similar threads


















































Top Bottom