Thompson Industries’ supply chain manager, Xun Xu, wishes to better understand the quality and on-time performance of his supply base. He suggests that you, using the data in Figure G.5, use Excel to create a PivotTable that displays the number of suppliers, grouped by quality level (sorted largest-tosmallest), and subtotaled by percentage of on-time shipments

(but only for suppliers with more than 50% on-time shipments).

Show values as % of Column Total. What value appears in the cell for 100% on-time shipping percentage and quality level of 3? L01