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

Using Excel's PivotTable, you can count the suppliers who have a purchase amount between $15,000 and $30,000 with a quality level under 5 by grouping purchase amounts and subtotalling by quality levels.

Step-by-step explanation:

To determine how many suppliers have a purchase amount between $15,000 and $30,000 with a quality level less than 5 using a PivotTable in Excel, you would set up the table with purchase amounts grouped by increments of $15,000, and quality levels as a subcategory. After creating this PivotTable, you would be able to count the number of suppliers that fit the criteria.

This type of data analysis is crucial for understanding different aspects of a supply chain, ensuring that a company like Thompson Industries can make informed decisions regarding their suppliers based on purchase volumes and quality levels.

Answer 2

Answer: 7

Step-by-step 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