The Excel workbook C$08$ Problem Data provides data on quality losses at Nosoco Paper Mill. Find the percentage of cost for each category, and the cumulative percentages when the categories are sorted by decreasing costs.

$9$a$.$ Construct an appropriate Excel chart to analyze the data. Your chart should include a column for Category, Cost Percent, and Cumulative Percent $($see below for model$).$ Create a histogram of the chart to determine what actions management should take.

$9$b$.$ What conclusions do you reach, and, what actions should management take?

Sorted by cost:

Category Cost Percent Cumulative $\%$

Rejected paper $$375,000$

Customer complaints $$103,000$

Odd lot $$66,000$

Wasted materials $$31,000$

Downtime $$30,000$

Inspection $$25,000$

Testing costs $$15,000$

Quality improvement training $$10,000100\mathrm{.}00\%$

Total Costs $$655,000$