Customer returns are a problem in the Alert Company. The company sells battery operated emergency weather alert radios.

Customers were queried by sales personnel when goods were returned about the reasons for the returns. The product is produced outside the U$.$S$.$

Below is the following information that was collected from customers.

Type of Complaint Number of Complaints

Did not perform as expected $26$

Found item cheaper elsewhere $114$

Instructions too complicated $57$

Instruction wording unclear $79$

Missing parts$/$manual $12$

Changed mind $15$

Used too many batteries too quickly $29$

Did not like $17$

Other $10$

Required:

$1.$ Develop a table that is set up largest to smallest number of complaints, the percentage of complaints in each category, and the cumulative percentage in each category.

$2.$ Prepare a Pareto Chart.

$3.$ What actions would you suggest Alert company take to resolve the customer complaint? Include in your discussion, the type of complaints that company should focus on resolving. Why?