Jump to content

  • Quick Navigation
Photo

Monthly Complaint Trending

Share this

  • You cannot start a new topic
  • Please log in to reply
21 replies to this topic

HACCPCOR

    Grade - Active

  • IFSQN Associate
  • 19 posts
  • 1 thanks
0
Neutral

  • Canada
    Canada

Posted 13 December 2013 - 06:01 PM

Hi Everyone,

 

I was hoping to get some ideas from people as to how they present monthly customer complaints, in their monthly HACCP meetings.

Currently we just talk through them all with no presentation just all verbal, mainly only focusing on the most important complaints due to production, maintenance issues etc.

Would it be advisable to start presenting on charts monthly or would every 3 months be better for this.

Maybe someone else has another idea?

 

Looking forward to hearing some suggestions..

 

Thanks



Pizza&Sandwich

    Grade - MIFSQN

  • IFSQN Member
  • 113 posts
  • 15 thanks
7
Neutral

  • United States
    United States
  • Gender:Female

Posted 13 December 2013 - 06:39 PM

It largely depends on how many complaints you're getting and what type of complaints. I did my internship with a fully cooked meats facility and I was responsible for preparing the reports for the monthly co-packer meetings. These contained customer complaints related to the co-packed products as well as complaints from the facility as the products were checked every delivery. It seems like there were several categories; something like: quality-taste/texture, FM, size specification, etc. It may be worth doing charts every quarter and plan on spending a little more time to review all of the complaints, instead of just the 'important' ones. You may see some trends (depending on products) throughout the year. The reports I prepared were based on a rolling 13 months.



Thanked by 2 Members:
Anika , HACCPCOR

Mr. Incognito

    "Mostly Harmless"

  • IFSQN Fellow
  • 1,571 posts
  • 272 thanks
131
Excellent

  • Earth
    Earth
  • Gender:Male

Posted 13 December 2013 - 06:54 PM

I would advise you to be able to present trend information either verbally or on graphs.  The reason I like graphs is it may be easier to see the problem if you see it visually like that vice just listening to what someone says.

 

Studies show that people remember things better when it is brought to them in multiple senses also.

 

Plus there is so much more you can show via graph with the trends and if you have a 12 / 13 month rolling chart you can see better if any of your complaints may increase or decline during different seasons or times of the year.


____________________________________________________________________________________________________

Mr. Incognito


:tardis:

Mr. Incognito is a cool frood who can travel the width and breadth of the galaxy and still know where his towel is.

Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 20,542 posts
  • 5662 thanks
1,544
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

Posted 13 December 2013 - 08:16 PM

Dear haccpcor,

 

Product / process ?

 

So how many complaints/month are we talking about ? 1-10, 10 -50 ? Usually none ?

 

Trending capability appears to imply a lot of available nonconformities ? :smile:

Based on previous threads, company maxima may rapidly over-ride any trending ? :smile:

 

Rgds / Charles.C


Kind Regards,

 

Charles.C


mgourley

    Grade - FIFSQN

  • IFSQN Fellow
  • 1,403 posts
  • 997 thanks
274
Excellent

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 13 December 2013 - 09:36 PM

I like trend charts for some of the reasons mentioned above. It's also much easier to post charts for all relevant employees to see.

the important thing of course, is the data. It must be recorded/entered consistently. For example "014 Giant" and "Giant" may be the same thing to the person entering the data, but to a pivot table in Excel, they are two completely different things.

 

I would strongly suggest that you set up any data gathering to only accept inputs from a list that you have created. Do not let people entering the critical data free form type the data in. Your charts, and your data analysis will thank you later.

 

Marshall



Thanked by 1 Member:
HACCPCOR

Jurate

    Grade - MIFSQN

  • IFSQN Member
  • 53 posts
  • 27 thanks
1
Neutral

  • Ireland
    Ireland
  • Gender:Female
  • Location:Ireland
  • Interests:Quality, Law

Posted 18 December 2013 - 08:45 AM

Hi All,

 

I have a Customer Complaints Log Sheet on excel. I have about 20 columns in there, including Customer, product type, problem type, root cause, general cause, process category, problem type, corrective actions, date when opened, date when closed, credit notes given or not, training for the operators needed or not. I log every single complaint on this Log sheet and I am updating every day.

I have filters on the top of it and I am able to filter what ever I need and whenever I need. The most important to update it every day and to log all the updates on each of the complaint.

The Management likes it so much. Also I do the Monthly Presentation on the Power POint, which I like to do, as it is very easy when you have all the data logged on excel.

I have pies on Power Point where I show the percentage of Customer complaints by Process (production, shipping, supplier problem etc), by type of problem (technical, production, supplier caused, Administration caused) by root cause (operator error, administration error, machine problem, material problem etc.), then how many we opened per month, how many we solved and closed etc.

I think it works perfectly as I can get anything I need, weekly, monthly, yearly etc. Now I have everything logged from 2011, so I can compare 3 years data and trend them.

 

Please see the attached excel Log Sheet, where I copied all columns.

 

I hope it is helpfull.

 

Attached Files


  • Estellejooste likes this

Thanked by 13 Members:
nindann , Nina_Mic , itreatpets , DeeTeeQA , dv8dawn , Quality Ben , Nageshwar , Estellejooste , Ruhama , chu lin , jebking , oromaniv , Setanta

Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 20,542 posts
  • 5662 thanks
1,544
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

Posted 18 December 2013 - 12:31 PM

Dear Jurate,

 

Amazing. :thumbup:  I hope the remuneration is commensurate. :smile:

 

i also hope you have an equivalent system for yr internal audit checklist.

 

Or perhaps you are only responsible for Customer Complaints ?

 

Thanks for sharing.

 

Rgds / Charles.C


Kind Regards,

 

Charles.C


mehraj.udct

    Grade - AIFSQN

  • IFSQN Associate
  • 27 posts
  • 1 thanks
0
Neutral

  • Kuwait
    Kuwait

Posted 18 December 2013 - 01:48 PM

Jurate it is very informative.It would be great if you can share how you receive costumer complains. procedure for receiving customer complains .

 

 

Thanks and regards,


Edited by mehraj.udct, 18 December 2013 - 01:49 PM.


Tony-C

    Grade - FIFSQN

  • IFSQN Fellow
  • 4,223 posts
  • 1288 thanks
608
Excellent

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Location:World
  • Interests:My main interests are sports particularly football, pool, scuba diving, skiing and ten pin bowling.

Posted 18 December 2013 - 02:16 PM

I like to use a formatted 'Annual Complaints Analyser' in Excel to record complaints by type and calculate complaints per million units. This information can then be presented in whichever sort of chart you like. I happen to like the 3D one.

 

Examples here:

 

Attached File  Annual Complaints Analyser - December Complaint Entry.pdf   117.97KB   906 downloads

 

Attached File  Annual Complaints Analyser - December CPMU.pdf   121.25KB   670 downloads

 

Attached File  Annual Complaints Analyser - Annual 3D Graph.pdf   509.82KB   722 downloads

 

Regards,

 

Tony



Thanked by 5 Members:
JLewis , DeeTeeQA , mhul , Ruhama , chu lin

oromaniv

    Grade - Active

  • IFSQN Associate
  • 18 posts
  • 5 thanks
1
Neutral

  • United States
    United States

Posted 18 December 2013 - 02:24 PM

Dear Jurate,

 

Amazing. :thumbup:  I hope the remuneration is commensurate. :smile:

 

i also hope you have an equivalent system for yr internal audit checklist.

 

Or perhaps you are only responsible for Customer Complaints ?

 

Thanks for sharing.

 

Rgds / Charles.C

Charles, you are so right.

Jurate, it would be awesome if you could share internal audit checklist template. Of course if you have it)

 

Thanks for the spreadsheet for customer complaints, very helpful.

 

Regards,

Ostap



oromaniv

    Grade - Active

  • IFSQN Associate
  • 18 posts
  • 5 thanks
1
Neutral

  • United States
    United States

Posted 18 December 2013 - 02:30 PM

Folks,

Would be weekly plant walk through reports and monthly GMP checks enough to meet Internal Audit requirements for SQF leve2 recertification? 

 

Thanks in advance,

Ostap



Jurate

    Grade - MIFSQN

  • IFSQN Member
  • 53 posts
  • 27 thanks
1
Neutral

  • Ireland
    Ireland
  • Gender:Female
  • Location:Ireland
  • Interests:Quality, Law

Posted 18 December 2013 - 02:58 PM

Dear mehraj.udct,
 
Please see the Complaints Procedure attached. This procedure works perfectly for me as before that I only got pieces of information without any batch numbers or other tracebility details. Now, everybody who receives complaint by phone or email has to complete the form wich I attach to my Log Sheet. I also Hyperliking all the relevant documents to each complaint (pictures, photographs, procedures, etc.) to that excel Log Sheet, so it is realy good as you click on the complaint, you have everything in there.
 
All the Auditors are more than happy with my system.
 
Best of luck.
Regards
Jurate

Attached Files



Thanked by 7 Members:
Nina_Mic , Nageshwar , mhul , Charles.C , Ruhama , chu lin , mehraj.udct

Jurate

    Grade - MIFSQN

  • IFSQN Member
  • 53 posts
  • 27 thanks
1
Neutral

  • Ireland
    Ireland
  • Gender:Female
  • Location:Ireland
  • Interests:Quality, Law

Posted 18 December 2013 - 03:10 PM

Dear Charles.C,

 

I work with all the other Quality things, not only Customer complaints. I also have very similar Logsheet for the Supplier Problems and now I have introduced one for the INternal Problems as well, where we log all internal Problems which causes faulty Product, than I pass information to Managers (I trend the problems by departments and root causes) and we sitt and discuss weekly.

 

I dont think that my Internal Auditing System is good enogh. I have a Procedure, annual Plan and the documentation for the Auditors completion (non conformances report). Everythink comes back to me and I make sure the corrective actions is taken before close it off.

 

Does anyone know a better system?

 

Regards, Jurate



mehraj.udct

    Grade - AIFSQN

  • IFSQN Associate
  • 27 posts
  • 1 thanks
0
Neutral

  • Kuwait
    Kuwait

Posted 19 December 2013 - 07:00 AM

Dear Jurate,

 

Thank you so much for sharing the customer complain procedure.

 

Is it possible for you to share  Goods Return Sheet (242)  and Material in Quarantine Log Sheet (220) as mentioned in the procedure.

 

Thanks and regards,



Jurate

    Grade - MIFSQN

  • IFSQN Member
  • 53 posts
  • 27 thanks
1
Neutral

  • Ireland
    Ireland
  • Gender:Female
  • Location:Ireland
  • Interests:Quality, Law

Posted 19 December 2013 - 09:09 AM

Dear mehraj.udct

The Form 240 is compiled from the main few columns from the Form 241 (Complaints Log Sheet). Just take the Most important columns which you need to Log the Complaint: Date, Customer, Design, Batch number, Problem, Quantity of rejected/affected material. When you get this completed you will be able to copy and paste into your Logsheet and start investigation of the root cause etc and continue to update your Log. 

 

The Material in the Quarantine - very simple excel Log as well, where I Have columns: Customer, design, date, problem, quantity, Location, disposition, actions required by:, comments.

 

Hope it helps, 

Regards,

Jurate



Thanked by 1 Member:
mehraj.udct

matheusdb

    Grade - Active

  • IFSQN Associate
  • 16 posts
  • 0 thanks
0
Neutral

  • Mozambique
    Mozambique
  • Gender:Male

Posted 15 January 2014 - 10:56 AM

Tks Jurete!



Ruhama

    Grade - AIFSQN

  • IFSQN Associate
  • 49 posts
  • 9 thanks
2
Neutral

  • Lesotho
    Lesotho
  • Gender:Female
  • Location:Katse Dam, Lesotho
  • Interests:I love God, I like Food Safety and Quality, I like watching Tyler Perry's Movies. Auditing and customers visits interests me a lot.

Posted 15 January 2014 - 11:43 AM

I am very glad I about the information I got from this, I am just got the new position of Quality Assurance Coordinator. our company is FSSC 22000 Certificate so I did not have this procedure in place.

 

Thanks


Regards

Ruhama Thooko

Quality Assurance Coordinator

Highlands Trout (Pty) Ltd

Jehova Jire

 


Asanele

    Grade - Active

  • IFSQN Active
  • 24 posts
  • 2 thanks
1
Neutral

  • South Africa
    South Africa

Posted 01 April 2016 - 07:46 AM

i was audited by supplier on a BRC system. there is a finding that does not make a sense. i only had one compliant for the past five years now they made a finding that we must do a monthly complaint trending. how can i do this



Tony-C

    Grade - FIFSQN

  • IFSQN Fellow
  • 4,223 posts
  • 1288 thanks
608
Excellent

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Location:World
  • Interests:My main interests are sports particularly football, pool, scuba diving, skiing and ten pin bowling.

Posted 01 April 2016 - 11:18 AM

i was audited by supplier on a BRC system. there is a finding that does not make a sense. i only had one compliant for the past five years now they made a finding that we must do a monthly complaint trending. how can i do this

 

Hi Asanele,

 

:welcome:

 

Pathetic finding from your supplier.

 

Send them this monthly trend analysis I've done for you:

000000000000
000000000000
000000000000
000000000000
000000001000

 

;)

 

Kind regards,

 

Tony


  • JohnWheat likes this

Thanked by 2 Members:
DeeTeeQA , Asanele

Asanele

    Grade - Active

  • IFSQN Active
  • 24 posts
  • 2 thanks
1
Neutral

  • South Africa
    South Africa

Posted 01 April 2016 - 12:07 PM

Thanks Tony i thought as much, i reserve my comment on this :surprise:



mgourley

    Grade - FIFSQN

  • IFSQN Fellow
  • 1,403 posts
  • 997 thanks
274
Excellent

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 02 April 2016 - 12:25 AM

This is quite a bit like when I was asked to provide a trend of internal rodent trap catches.
I printed out a bar chart that showed X and Y axis with no data. Because that was what the data was.

 

Silly auditors.

 

Marshall



Shaik88

    Grade - Active

  • IFSQN Active
  • 6 posts
  • 0 thanks
0
Neutral

  • India
    India

Posted 23 October 2018 - 09:57 PM

I would advise you to prepare Food Safety Risks efficiency report and include customer complaints and represent with graphs in Excel.





Share this

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users