Quality Costs, Excel LO7
Tanner Leathers implemented a quality control and improvement program in 2012. The quality control manager, a daughter of the company’s president, developed the following table, which shows the components of quality cost as a percentage of the company’s sales for the last five years:
A.Prepare a 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’s quality program?