Defect/call log pareto

[MrClean760]

I am in charge of all customer service. The business I work for has gone from 2000 units a year to 10000 a month over the weekend. You can imagine how many people I have calling a day. The boss wants a Pareto chart with numbers of defected parts for a week, I have those numbers I just don’t know how to do this cumulative percentage...He also wants to know how many people call, email, or submit tickets online and wanted to know of which did we fix over phone, fix by sending part, couldn’t fix had to replace.

 

[etaf]

do you have the data in a spreadsheet and can you give an idea of layout
making a Parato chart is reasonably straight forward and quite a few tutorial on the web

Make Pareto chart in Excel

The tutorial explains the basics of the Pareto analysis and shows how to create a Pareto chart in Excel 2016, Excel 2013, and Excel 2010.

www.ablebits.com

Pareto Chart in Excel

This example teaches you how to create a Pareto chart in Excel. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes.

www.excel-easy.com

How is this infor collated on a spreadsheet
again reasonably straight forward to setup and create a dashboard

He also wants to know how many people call, email, or submit tickets online and wanted to know of which did we fix over phone, fix by sending part, couldn’t fix had to replace.

If you can show the layout of data captured then we can setup some formulas
Countif() countifs() sumif() sumifs() maybe key functions to use

 

[MrClean760]

I’m not at my computer right now, but I do have a picture of the spreadsheet. Would that work?

 

[etaf]

yes, can try and we can see how we get on