Analysis of customer complaints at an e-commerce retailer revealed the following:   Billing errors: 1,531 Shipping errors: 940 Electronic charge errors: 691 Shipping delays: 2,989 Packing errors: 1,758   The data has been sorted for your convenience. Calculate the percent of total complaints for each category of errors. Round your answers to two decimal places.   Name Amount Percent of Total Shipping delays 2,989  % Packing errors 1,758  % Billing errors 1,531  % Shipping errors 940  % Electronic charge errors 691  %   Use the Excel Pareto template to construct a Pareto chart and choose the correct Pareto diagram. The correct Pareto diagram is  ___.                     __________________ account for the majority of customer complaints. If two of these root causes are fixed, ____________  of customer complaints will be solved.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Analysis of customer complaints at an e-commerce retailer revealed the following:

 

Billing errors: 1,531
Shipping errors: 940
Electronic charge errors: 691
Shipping delays: 2,989
Packing errors: 1,758

 

The data has been sorted for your convenience. Calculate the percent of total complaints for each category of errors. Round your answers to two decimal places.

 

Name Amount Percent of Total
Shipping delays 2,989  %
Packing errors 1,758  %
Billing errors 1,531  %
Shipping errors 940  %
Electronic charge errors 691  %

 

Use the Excel Pareto template to construct a Pareto chart and choose the correct Pareto diagram.

The correct Pareto diagram is  ___.

 

 

 

 

 

 

 

 

 

 

__________________ account for the majority of customer complaints. If two of these root causes are fixed, ____________  of customer complaints will be solved.

A.
B.
[Frequency
4000
3000
2000
1000
Frequency
4000
3000
2000
1000
Shipping Packing
delays
l…...
Billing
Shipping Electronic
errors
errors
Shipping
delays
errors
Packing
errors
charge errors
I...
Billing
errors
Shipping
errors
C.
Electronic
charge errors
D.
[Frequency
4000
3000
2000
1000
[Frequency
4000
3000
2000
-1000-
Shipping
delays
Shipping
delays
Packing
errors
Packing
errors
Billing
errors
Billing
errors
Shipping
errors
Shipping
errors
Electronic
charge errors
Electronic
charge errors
Transcribed Image Text:A. B. [Frequency 4000 3000 2000 1000 Frequency 4000 3000 2000 1000 Shipping Packing delays l…... Billing Shipping Electronic errors errors Shipping delays errors Packing errors charge errors I... Billing errors Shipping errors C. Electronic charge errors D. [Frequency 4000 3000 2000 1000 [Frequency 4000 3000 2000 -1000- Shipping delays Shipping delays Packing errors Packing errors Billing errors Billing errors Shipping errors Shipping errors Electronic charge errors Electronic charge errors
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.