Question

Thompson​ Industries' supply chain​ manager, Xun​ Xu, wishes to understand the makeup of his supply base better. He suggests that​ you, using the data provided​ below, 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 comma 000 and ​$30 comma 000 and a quality level less than 5​? LOADING... Click the icon to view the Thompson​ Industries' supplier file. nothing ​supplier(s) has(have) a purchase amount between ​$15 comma 000 and ​$30 comma 000 and a quality level less than 5 ​(enter your response as a

Answer 1

Answer: 7

Explanation:

By analyzing the above data in the question, we can see that the following suppliers have a quality level less than 5.

• ABC
• Perkins Plastics
• Jones Aluminum and Cooper
• Ricks wrought Iron
• Penelopes Paper Products
• Anthony
• Smart
• Watson's
• Impenetrable
• Suzy

Now we would analyze the above data, we can see that the following suppliers have a purchase amount between 15k and 30K.

• Cowboy
• Everything
• Jones
• Rick
• Penelope
• Anthony
• Watson's
• Impenetrable
• Suzy

Now, we want the suppliers who fulfill both these criteria are :-

Jones

Rick

Penelope

Watson's

Impenetrable

Suzy

⇒ Anthony

So, the answer is 7.

[NOTE]: Attached is the data provided to solve this question as the problem seems incomplete in the question.

cheers i hope this helps!!!1