Thompson Industries’ supply chain manager, Xun Xu, wishes to understand the makeup of his supply base better.

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 purchases (in groups of $15,000, starting at $1), and subtotaled by quality level. Hint: To group rows by a range of values, right-click on any value in column A of the PivotTable and select Group.... How many suppliers have a purchase amount between $15,000 and $30,000 and a quality level less than 5? L01