Tanner Leathers implemented a quality control and improvement program in 2009. The quality control manager, a daughter of the company€™s president, developed the following table that shows the components of quality cost as a percentage of the company€™s sales for the last five years.

Required
A. Prepare a graph (i.e., a trend graph) that shows the trend for each quality cost category. To complete the graph in Excel, use the chart wizard and select XY (scatter) graph with data points connected by lines as the chart type. You should have one graph with four separate lines. Show the percentage of sales on the vertical axis and the year on the horizontal axis.
B. What does the graph tell you about the success of Tanner Leathers€™ qualityprogram?

Internal Failure External Failure Prevention 3% 4 Detection Year 2009 2010 2011 2012 2013 9% 13% 4 2