Discrepancy Costs Measuring Methods - Excel spreadsheets or other methods

M

Munther J

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
 

Jen Kirley

Quality and Auditing Expert
Leader
Admin
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:
Top Bottom