10 replies to this topic

[GemmaZA]

Hi All,

I would like to make a graph of some sort to demonstrate to everyone within production how well they are doing on a monthly/weekly basis after the audits. I currently conduct a thorough monthly hygiene audit which would be great to demonstrate to them via a graph/pie chart of some sort so they can all understand it.

However I am really struggling on how to put it together, should I just set it as percentage of how many non conformances were found against how many checks were done (so 5 NC's out of 30 sections) for that one month and demonstrate it on a pie chart?

Or

Do I put a bar chart together and add each month to the sheet so they can see how many non conformances they are recieving each month?



I just like the look of the pie. I am hoping that some of you do this within your own operations, I think it will be interesting for the packing team to see not just the supervisors.

Any help gladly recieved

[Zeeshan]

Hi All,

I would like to make a graph of some sort to demonstrate to everyone within production how well they are doing on a monthly/weekly basis after the audits. I currently conduct a thorough monthly hygiene audit which would be great to demonstrate to them via a graph/pie chart of some sort so they can all understand it.

However I am really struggling on how to put it together, should I just set it as percentage of how many non conformances were found against how many checks were done (so 5 NC's out of 30 sections) for that one month and demonstrate it on a pie chart?

Or

Do I put a bar chart together and add each month to the sheet so they can see how many non conformances they are recieving each month?



I just like the look of the pie. I am hoping that some of you do this within your own operations, I think it will be interesting for the packing team to see not just the supervisors.

Any help gladly recieved

Dear Gemma

IMO, bar chart is more suitable for easy understanding of trend of data. Especially Pareto-Style bar chart more clearly illustrate the areas needed to be focused.

Another suggestion is that you should consider to categorize your nonconformities according to their importance w.r.t. food safety and quality and then make those categories as reference to measure nonconformities identified in each area. Just to convey a message that 'A' department has 2 NC's and 'B' also has 2 is not an effective activity. Until and unless you do not associate the weight of importance to each NC the numbers have no value IMHO.

For example you may have some categories of NC's including following.
1- Dirty/Potentially unsafe Areas or Food Contact Surfaces.
2- Improper identification and placement of material.
3- Improper use of hair nets
4- Dirty Uniforms.

Now it make sense to say that 'A' department has 2 NC's belong to category 1&2 respectively. (Which should be easily depictable through graph) and department 'B' has 2 NC's belong to categories 3&4 respectively . Definitely despite of on same scale of number of NC's, 2 NC's of department 'A' are more severe than 2 NC's of department 'B'. Also during next audit you have a solid basis to measure the improvement in the trend in particular area.

In short, sorting out and depicting data in such a way not only convey you message more effectively down the level but also helps you to monitor the trend of improvement in future.

Hope it helps!
Regards:
M.Zeeshan

[GemmaZA]

Dear Gemma

IMO, bar chart is more suitable for easy understanding of trend of data. Especially Pareto-Style bar chart more clearly illustrate the areas needed to be focused.

Another suggestion is that you should consider to categorize your nonconformities according to their importance w.r.t. food safety and quality and then make those categories as reference to measure nonconformities identified in each area. Just to convey a message that 'A' department has 2 NC's and 'B' also has 2 is not an effective activity. Until and unless you do not associate the weight of importance to each NC the numbers have no value IMHO.

For example you may have some categories of NC's including following.
1- Dirty/Potentially unsafe Areas or Food Contact Surfaces.
2- Improper identification and placement of material.
3- Improper use of hair nets
4- Dirty Uniforms.

Now it make sense to say that 'A' department has 2 NC's belong to category 1&2 respectively. (Which should be easily depictable through graph) and department 'B' has 2 NC's belong to categories 3&4 respectively . Definitely despite of on same scale of number of NC's, 2 NC's of department 'A' are more severe than 2 NC's of department 'B'. Also during next audit you have a solid basis to measure the improvement in the trend in particular area.

In short, sorting out and depicting data in such a way not only convey you message more effectively down the level but also helps you to monitor the trend of improvement in future.

Hope it helps!
Regards:
M.Zeeshan

Wow thank you very much! I will try and put your training on this subject into practice and see what my feedback from production is.

Thanks again for my tutorial

[Simon]

If you use a standard such as BRC you can arrange your audit schedule and audit checklist as per the clauses of the standard. If it is all on a spreadsheet you can log the number of NCR's found and this could be turned into some sort of bar chart or pareto chart. The benefit of this is you are always verifying your system and preparing for audit. I can post an example later, probably better.

[GemmaZA]

If you use a standard such as BRC you can arrange your audit schedule and audit checklist as per the clauses of the standard. If it is all on a spreadsheet you can log the number of NCR's found and this could be turned into some sort of bar chart or pareto chart. The benefit of this is you are always verifying your system and preparing for audit. I can post an example later, probably better.

Sounds good thanks Simon!

[Simon]

Here is an example once on a spreadsheet, reporting trends etc. becomes easy.

Attached Files

•  BRC Packaging Audit System Example.xls   162.5KB   172 downloads

[GemmaZA]

Very good! Thanks again Simon!!

[GemmaZA]

Oh Simon,

Just a quick question, did you do a risk assessment to determine the frequency of your internal audits?

Gem

[Simon]

Oh Simon,

Just a quick question, did you do a risk assessment to determine the frequency of your internal audits?

Gem

Yes based on previous internal and external audit results. In general audit more the things related to the HACCP, factory floor and personnel.

[Tony-C]

Here is an example once on a spreadsheet, reporting trends etc. becomes easy.

A useful template Simon

I like to see a % compliance (or similar measure of how much is right rather than how many things are wrong) reported as well

Regards,

Tony

[Simon]

A useful template Simon

I like to see a % compliance (or similar measure of how much is right rather than how many things are wrong) reported as well

Regards,

Tony

Wow thanks Tony, if it passes your test it must be good. Only one opportunity for improvement, which I actually agree with.