Jump to content

  • Quick Navigation




Photo
* * * * * 5 votes

Using Trend Analysis to Reduce Complaint levels

Posted by Tony-C , in Quality Management 09 October 2014 · 9,485 views

customer complaint trend analysis
Using Trend Analysis to Reduce Complaint levels

I’d like to start off my latest blog by quoting an interesting section in SQF Guidance regarding complaints:

 

‘Customer complaints provide an important measure of how well the SQF System is performing. By accurately recording customer complaint types, a supplier can objectively measure changes in their management system and show improvements in a process. Customer complaints may also show trends that have not been identified during processing and normal process control checks’.

 

‘Customer complaints may be the first record that an auditor asks to review when beginning the facility audit. Customer complaints can provide an auditor insight into the performance of the supplier’s SQF System and any trend areas that may require greater focus’.

 

The GFSI recognised standards do require auditors to take a close look at complaints, complaint levels and trends in customer complaint levels. They are a key performance indicator and are a reflection of the effectiveness of the food safety and quality management system.

 

I have been involved in many projects to improve product quality and reduce food complaint levels. One of the best tools for indicating where action for improvement needs to be applied is by analyzing your complaint data appropriately.

 

Whilst you can identify faults in your factory your customers are your 100% inspection service so respect their feedback. Whilst all of your customers will not complain when they find a problem so you will not capture all of your product faults you will however identify trends.

 

The first step is to collate all of your complaint data. Your data should then be categorised by product type, complaint type and size. Analyzing complaints by numbers alone will not give you a real picture of your performance. What you need to know is the proportion of complaints you are getting for each product. By far the most practical way of doing this is by using the sales volumes to calculate the proportion of complaints you get for each product. Some people use weight or volume such as complaints per tonne or 1000 Litres. My preference is to use complaints per million units.

 

So you analyze your complaint data product type, complaint type and size per million units. From this data you can easily spot the worst performing product lines.

 

You should then analyze the results for the worst performing products:

 

Are they all the same size?
Are they produced on the same filling machine/production line?
Is it the same type of complaint?

 

The answers to these questions will generate your corrective action plans. If products with the highest complaint levels are all the same size it could be a particular problem with that size of packaging. If it is all the same type of complaint then why are some product lines worse than others? If product from one particular production line is generating the highest number of complaints per million units then there must be a reason for this, it needs investigating. You should compare product performance and if there are significant differences you should ask the question why?

 

At this point complaint trends are useful. For example when I worked with fresh pasteurised milk sour complaints were higher in larger sized containers. The reason for this was not related to the quality of the product but the fact they took longer to consume and spent more time in and out of the fridge. Such products would be targeted for improvement projects as opposed to corrective action to remedy a problem area.

 

A few words of caution though, your analysis needs to take into consideration the comparative value of the products and the market. People are more likely to complain about higher value products. Also some retail customers are much better at reporting complaints from customers to the extent that I used to get 10 times the complaint levels from one particular retailer compared to another for exactly the same product.

 

My last tip the more data you analyze the better. In the past I have analyzed 3 years worth of data. Why? It gives a year on year performance so you can see if things have been improving or deteriorating and also it shows any effects of seasonality. For example it is not reasonable to compare summer levels of “off” complaints on a fresh product with winter levels. This is why in the Northern Hemisphere I would compare August complaint performance with the complaint levels for August in the previous year.

 

Each of our implementation packages comes with a free complaint analyser template.

 

GFSI Certification Packages

 

Appendix – Useful References

 

SQF Code:

 

2.1.5.2 Trends of customer complaint data shall be investigated and analyzed by personnel knowledgeable about the incidents.
2.1.4 Management Review (M)
2.1.4.1 The senior management shall be responsible for reviewing the SQF System and documenting the review procedure. Reviews shall include:
iv. Customer complaints and their resolution and investigation.

 

SQF 2.1.5 Implementation Guidance
Customer complaints provide an important measure of how well the SQF System is performing. By accurately recording customer complaint types, a supplier can objectively measure changes in their management system and show improvements in a process. Customer complaints may also show trends that have not been identified during processing and normal process control checks.

 

SQF 2.1.5 Auditing Guidance
Customer complaints may be the first record that an auditor asks to review when beginning the facility audit. Customer complaints can provide an auditor insight into the performance of the supplier’s SQF System and any trend areas that may require greater focus.

 

BRC Code:

 

3.10.2 Trend Analysis
Complaint data shall be analysed for significant trends and used to implement ongoing improvements to product safety, legality and quality, and to avoid recurrence.

 

BRC Guidance
3.10.2 Trend Analysis
Data on customer complaints shall be analysed so the trends may be identified. This is to help ensure that the root cause of problems is identified and improvements made to prevent recurrence so far as practicable.

 

IFS Food:

 

5.8 Management of complaints from authorities and customers
5.8.3 Complaints shall be analysed with a view to implementing preventive actions which avoid the recurrence of the nonconformity.
5.8.4 The results of complaint data analysis shall be made available to the relevant responsible persons and to the senior management.

 

ISO 22000:

 

Is less specific but implies analysis in:
8.4.3 Analysis of results of verification activities
The food safety team shall analyse the results of verification activities, including the results of the internal audits (see 8.4.1) and external audits. The analysis shall be carried out in order:
c) to identify trends which indicate a higher incidence of potentially unsafe products,



  • 5



Great tips Tony...thank you!

    • 0

This is spot on...Every time I was thinking...well what about this?...you mention it on the following paragraphs...Kudos

    • 0

Sounds good. We are currently undertaking SQF certification. Yes, I have started an analyses of complaints. Cheers  Dr Eugene JOnes

    • 0

Really useful and practical advice.

Please forward a copy of your complaint analyser template to me.
 

    • 0
Photo
Tomato Country Girl
Oct 16 2014 10:39 AM

Great article, love to see more like this.  Please forward a copy of your complaint analyser template to me.  Regards,

    • 0
Photo
Taste Maker
Oct 16 2014 11:48 AM

Tony,

 

Good afternoon, good job on the product complaint post. I am in the process of doing a HACCP review and this will help with the organizational part. Yes indeed, the complaints definitely highlight what area (s) need attention. By the way, could you send me a template please?

 

Regards,

 

Taste Maker

Memphis, TN

    • 0

Thank you Tony for all this info. I never fail to learn from this site and I tell everyone in the food industry including our auditor who didn't know about it to join up. I would love it if you could send me the complaint template. once again thank you

    • 0

I have removed email addresses from some posts to prevent members from getting spam. You will receive the analyzer by PM via the website

 

Regards,

 

Tony

    • 1

It's great article .. such an enlightment...

thanks Tony

    • 0

Great article, just in time for me as I just start to try to find some trends in customer complaints. Thank you very much.

    • 0

Good Job , Kindly forward a copy of your complaint analyser template to me.  Regards,

Yasser Mohamed Abd El-Maged

    • 0

Hi hid your email Yasser as if left on here you will get spam.

I have passed Tony your email address via private message and he will send you the information.

    • 0

Thank You Tony C

 

Very good blog! I have already shared with 2 of my colleagues. Could you please upload the referenced complaints analyser.

Regards

Flopeart

    • 0

Nice blog

    • 0

Very good material, thank you!  Could you please forward a copy of your complaint analyser template to me.  Regards,

    • 0

Great advices, especially to compile data from previous year. Thanks!

    • 0

Hi Tony..

Can you please forward me the template.. thanks in advance.

 

Kind Regards

    • 0

Hi Tony,

 

Thaks for this I have found it very useful. Could you please forward me the complaint analyser template to have a look at. Thanks in advance.

    • 0

Hi Tony,

 

Could I please get a copy of your compliant template? Thanks in advance,,

    • 0
Photo
Mohammed Ashmawy
Feb 18 2015 08:36 AM

thanks

    • 0

Thank you, Tony, for the great material. Please send me a copy of your complaint analyser template.

 

Thanks again.

    • 0

Could you please send me a copy.  Thank you

    • 0
Thanks Tony! Great information.
Could you send me a copy of the Complaint Analyzer Template also.
    • 0
Photo
sandraagustina
Apr 10 2015 06:05 AM

Thanks Tony; it is a very useful information.

Could you please send me a copy of the complaint analyser template?

Thanks

Sandra

    • 0

Thank you for this article, Tony! Very helpful to know for an upcoming audit and share with my team. May I have a copy of your complaint analyser? Thank you!

    • 0

Thank you for the blog - interesting.

Please send a copy of your template.

Thanks in advance

Rgds

moskito

    • 0
Photo
Sifiela@2806
Aug 13 2015 12:36 PM

Dear Tony

 

Thank you for the advice. Will you kindly send me also a copy of the template. I am also looking for a BRC IoP internal audit template. albertus@zibo.co.za

 

Thanks Albertusd

    • 0
Photo
Sifiela@2806
Aug 13 2015 12:36 PM

Dear Tony

 

Thank you for the advice. Will you kindly send me also a copy of the template. I am also looking for a BRC IoP internal audit template. albertus@zibo.co.za

 

Thanks Albertus

    • 0
Very good post, thank you
Please send me a copy of your template :)
    • 0

great post.

Can I please get a copy of your analysis template? thanks!

    • 0

February 2017

M T W T F S S
  12345
6789101112
13141516171819
202122 23 242526
2728     

Recent Comments

0 user(s) viewing

0 members, 0 guests, 0 anonymous users