$1\mathrm{.}3$ Evaluate solutions and implications using appropriate tools and technology

A Dunking franchise in Corpus Christi, Texas is concern because it has low sales when compared with other shop in locations with similar characteristics. The manager conducts a survey on the customers complains that causes them not to return,. The following list of complains is compiled.

Complain

Number of complains

A

Lack of parking

$36$

B

In shop wait is too long

$162$

C

Drive thru wait is too long

$231$

D

Order in drive thru problematic because employees misheard

$26$

E

Table was not clean

$5$

F

Dirty restroom

$16$

G

Donut variety ordered by client was not available

$22$

H

Coffee variety ordered by client was not available

$75$

I

No table available

$15$

J

Menu was confusing

$21$

Use a Pareto chart to identify the $$vital few$$ complains causing customers not to return to this Dunking location Hint. Review Chapter $2.$ Use Excel creating a table with the data provided, order it and then use Insert$/$Charts$/$Recommended Charts to create a Bar chart with cumulative percentage$)$