Jump to content

  • Quick Navigation
Photo

Does Anyone Know How to Calculate Customer Satisfaction?

Share this

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

deedee_soq

    Grade - Active

  • IFSQN Active
  • 4 posts
  • 0 thanks
0
Neutral

  • Indonesia
    Indonesia

Posted 22 October 2012 - 01:07 AM

Hi group

Is anyone knows how to calculate the customer satisfaction.
Thank you for help .



Regards



deedee



D-D

    Grade - MIFSQN

  • IFSQN Member
  • 239 posts
  • 55 thanks
5
Neutral

  • Canada
    Canada
  • Gender:Male

Posted 22 October 2012 - 01:44 PM

To deedee from D-D:
I am not sure you can "calculate" it in numbers but you can track things like repeat orders, increased orders, complaints, new projects and opportunities etc to determine customer satisfaction. I guess you could assign figures to those things as rankings to make some sort of calculation if you wanted to...



Thanked by 1 Member:

Chris @ Safefood 360°

    Associate - AIFSQN

  • Corporate Sponsor
  • 104 posts
  • 51 thanks
5
Neutral

  • United States
    United States
  • Gender:Male
  • Location:New York, NY

Posted 22 October 2012 - 02:33 PM

Hi deedee

I would agree with D-D in that it's difficult to calculate true customer satisfaction without directly contacting them and asking them outright. Even then, the feedback that you receive may not always be accurate. The key is being able to know what your customer wants, and then delivering on that. Mutually agreeing on defined standards or specifications can give you the Key Performance Indicators (KPI's) that D-D described above - on time deliveries,short orders, etc....ongoing monitoring of these areas and documenting the results can provide you with quantitative data that can be reviewed to gauge customer satisfaction. (i.e. On time deliveries = 98%, Short orders < 2%,etc.)

Consumer complaints can be a good way to monitor the satisfaction of the end user of your product when the number of complaints based against the sum of your production. (X complaints per 10,000cs.)

Ultimately, it would be optimal to be able to see 100% customer satisfaction,and 0 consumer complaints. Unfortunately, we often times have to deal with real world results that aren't anywhere near that. Set realistic goals. Hold key staff members accountable. Review/follow up on results. When success is realized, set higher goals and repeat the process.

I’m interested to know if any forum members have a proven method of monitoring customer satisfaction.

-Chris



Thanked by 1 Member:

D-D

    Grade - MIFSQN

  • IFSQN Member
  • 239 posts
  • 55 thanks
5
Neutral

  • Canada
    Canada
  • Gender:Male

Posted 22 October 2012 - 05:26 PM

One other thing: some companies (especially large corporations...) think it is a good idea to come up with some sort of customer satisfaction survey and / or questionnaire. Be careful with that. Calling customers and taking up their time with this or asking them to fill out lengthy documents can quickly become a source of dis-satisfaction (I have written as much on these things myself and told "personal suppliers" like banks, insurance companies to stop calling me and take me off their survey list!).



Thanked by 1 Member:

Simon

    IFSQN...it's My Life

  • IFSQN Admin
  • 12,826 posts
  • 1363 thanks
880
Excellent

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Location:Manchester
  • Interests:Married to Michelle, Father of three boys (Oliver, Jacob and Louis). I enjoy cycling, walking and travelling, watching sport, especially football and Manchester United. Oh and I love food and beer and wine.

Posted 22 October 2012 - 06:18 PM

About ten years ago I attended a Customer Satisfaction Measurement training course conducted by The Leadership Factor. They taught a methodology for surveying customers that in a nutshell meant you ask your customers to rate a number of criteria for importance and also satisfaction, which identified the largest gaps between what the customer perceived as being important and their satisfaction. These were the'priorities for improvement' for the organization - it also led to an overall Customer Satisfaction Index (score), that could be used for setting improvement targets. I used it two or three times and found it a very simple and effective methodology.

Check out a PowerPoint of the methodology here: Why measure customer satisfaction

and their website: The Leadership Factor

If you are interested I will try and dig out an example.

Regards,
Simon


Get FREE bitesize education with IFSQN webinar recordings.
 
Download this handy excel for desktop access to over 180 Food Safety Friday's webinar recordings.
https://www.ifsqn.com/fsf/Free%20Food%20Safety%20Videos.xlsx

 
Check out IFSQN’s extensive library of FREE food safety videos
https://www.ifsqn.com/food_safety_videos.html


Thanked by 1 Member:

Simon

    IFSQN...it's My Life

  • IFSQN Admin
  • 12,826 posts
  • 1363 thanks
880
Excellent

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Location:Manchester
  • Interests:Married to Michelle, Father of three boys (Oliver, Jacob and Louis). I enjoy cycling, walking and travelling, watching sport, especially football and Manchester United. Oh and I love food and beer and wine.

Posted 25 October 2012 - 03:01 PM

I knew I'd posted the information previously, to save uploaded again see here:

Customer Satisfaction Measurement System

if you have questions just ask.

Regards,
Simon


Get FREE bitesize education with IFSQN webinar recordings.
 
Download this handy excel for desktop access to over 180 Food Safety Friday's webinar recordings.
https://www.ifsqn.com/fsf/Free%20Food%20Safety%20Videos.xlsx

 
Check out IFSQN’s extensive library of FREE food safety videos
https://www.ifsqn.com/food_safety_videos.html


Thanked by 1 Member:

williams22

    Grade - Active

  • IFSQN Active
  • 5 posts
  • 0 thanks
0
Neutral

Posted 26 October 2012 - 10:34 AM

Hi group

Is anyone knows how to calculate the customer satisfaction.
Thank you for help .



Regards



deedee


Customer satisfaction is more important for brand reputation........To measure customer satisfaction we have to conduct a survey for the customers by mailing the questionnaire or in person or contact them through phone !! Posted Image




Kamwenji Njuma

    Grade - MIFSQN

  • IFSQN Member
  • 131 posts
  • 47 thanks
4
Neutral

  • Kenya
    Kenya
  • Gender:Male
  • Location:Nairobi,Kenya
  • Interests:Food safety,Quality,Hygiene and Agricultural consultancy.HACCP,BRC Food,ISO22000.ISO9001,GLOBALG.A.P,Etc

Posted 26 October 2012 - 11:46 AM

Hi,

I would go for the number of customer complaints for a given duration.

Regards,
Kamwenji



Thanked by 1 Member:

deedee_soq

    Grade - Active

  • IFSQN Active
  • 4 posts
  • 0 thanks
0
Neutral

  • Indonesia
    Indonesia

Posted 28 October 2012 - 08:54 AM

I knew I'd posted the information previously, to save uploaded again see here:

Customer Satisfaction Measurement System

if you have questions just ask.

Regards,
Simon




hi simon

Could you explain how to determine the importance score, weighting factor, satisfaction score, standard deviation, weighted score, difference imp/sat in your CSS result?


Thanks for help.



Regards



Deedee


Simon

    IFSQN...it's My Life

  • IFSQN Admin
  • 12,826 posts
  • 1363 thanks
880
Excellent

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Location:Manchester
  • Interests:Married to Michelle, Father of three boys (Oliver, Jacob and Louis). I enjoy cycling, walking and travelling, watching sport, especially football and Manchester United. Oh and I love food and beer and wine.

Posted 30 October 2012 - 07:47 PM

hi simon

Could you explain how to determine the importance score, weighting factor, satisfaction score, standard deviation, weighted score, difference imp/sat in your CSS result?

Thanks for help.

Regards
Deedee


The importance and satisfaction scores come directly from the questionnaire. The difference between the importance and satisfaction scores are the Priorities for Improvement, obviously the larger the gap between Importance and Satisfaction the bigger the priority. I will have to check the master spreadsheet for the formulas for calculating std deviation, weighted score etc.

Regards,
Simon

Get FREE bitesize education with IFSQN webinar recordings.
 
Download this handy excel for desktop access to over 180 Food Safety Friday's webinar recordings.
https://www.ifsqn.com/fsf/Free%20Food%20Safety%20Videos.xlsx

 
Check out IFSQN’s extensive library of FREE food safety videos
https://www.ifsqn.com/food_safety_videos.html


Simon

    IFSQN...it's My Life

  • IFSQN Admin
  • 12,826 posts
  • 1363 thanks
880
Excellent

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Location:Manchester
  • Interests:Married to Michelle, Father of three boys (Oliver, Jacob and Louis). I enjoy cycling, walking and travelling, watching sport, especially football and Manchester United. Oh and I love food and beer and wine.

Posted 09 November 2012 - 04:29 PM

As promised attached is the spreadsheet with equations - I highlighted wherever there is a sum.


Sorry for the delay.

Regards,
Simon

Attached Files


Get FREE bitesize education with IFSQN webinar recordings.
 
Download this handy excel for desktop access to over 180 Food Safety Friday's webinar recordings.
https://www.ifsqn.com/fsf/Free%20Food%20Safety%20Videos.xlsx

 
Check out IFSQN’s extensive library of FREE food safety videos
https://www.ifsqn.com/food_safety_videos.html


Thanked by 1 Member:

deedee_soq

    Grade - Active

  • IFSQN Active
  • 4 posts
  • 0 thanks
0
Neutral

  • Indonesia
    Indonesia

Posted 22 November 2012 - 05:10 AM

The importance and satisfaction scores come directly from the questionnaire. The difference between the importance and satisfaction scores are the Priorities for Improvement, obviously the larger the gap between Importance and Satisfaction the bigger the priority. I will have to check the master spreadsheet for the formulas for calculating std deviation, weighted score etc.

Regards,
Simon



deedee_soq

    Grade - Active

  • IFSQN Active
  • 4 posts
  • 0 thanks
0
Neutral

  • Indonesia
    Indonesia

Posted 22 November 2012 - 05:19 AM

Thank you very much Simon


Regards


Dee dee



NigelCoxon

    Grade - Active

  • IFSQN Active
  • 2 posts
  • 0 thanks
0
Neutral

  • United Kingdom
    United Kingdom

Posted 21 April 2016 - 08:24 AM

I realise this is an incredibly old post, but there's an error in Simon's spreadsheet; the figures calculated in columns BH and BI are only including partial data. They use columns J to AW, but the data extends from J to BG.



YHA123

    Grade - Active

  • IFSQN Active
  • 1 posts
  • 0 thanks
0
Neutral

  • United Kingdom
    United Kingdom

Posted 12 July 2016 - 02:10 PM

Hi Simon,

 

I don't suppose you still have the CSI Calculation spreadsheet available do you?

The link above appears to be dead :(

 

Cheers,

 

Paul



Charles.C

    Grade - FIFSQN

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

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

Posted 12 July 2016 - 02:30 PM

Hi Simon,

 

I don't suppose you still have the CSI Calculation spreadsheet available do you?

The link above appears to be dead :(

 

Cheers,

 

Paul

 

Hi Paul,

 

if you mean post 5, 11, seem to work for me.


Kind Regards,

 

Charles.C




Share this

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users