contestada

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

Respuesta :

Preciousorekha1

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

Ver imagen Preciousorekha1

Otras preguntas