Examlex

Solved

Use the Data Given Below to Answer the Following Question(s)

question 17

Multiple Choice

Use the data given below to answer the following question(s) .
Following is the Sales database of Pointler's Inc., a manufacturer of clothing material.  Item  Type  Item ID Region  Buyer  Unit  Cost ($)  Units  Denim  D101  Quintasia  Peter 9.79101 Cotton  C101  Prioland  Kane 27.7956 Denim  D102  Prioland  Jones 12.7942 Leather  L101  Prioland  Gerry 27.7933 Denim  D103  Dygertia  Sarah 10.7962 Cotton  C102  Quintasia  Peter 12.7966 Denim  D101  Prioland  Audrey 9.7981 Denim  D102  Prioland  Jones 12.7996 Denim  D101  Dygertia  Thomas 9.7938 Cotton  C103  Quintasia  Peter 16.7966 Denim  D102  Prioland  Mary 12.7996 Cotton  C105  Quintasia  Henry 9.7935 Cotton  C101  Quintasia  Philip 27.7987 Denim  D102  Quintasia  Peter 12.7941 Jute  J101  Prioland  Simson 132.8 8  Fur  F101  Quintasia  Peter 23.7922 Cotton  C103  Prioland  Mary 16.7934 Leather  L102  Quintasia  Peter 16.7970 Leather  L101  Quintasia  Philip 27.7921 Fur  F102  Prioland  Kane 12.79102 Denim  D104  Prioland  Simson 9.0973 Fur  F101  Quintasia  Philip 23.7980 Cotton  C103  Prioland  Gerry 16.7952 Cotton  C104  Prioland  Simson 22.893 Cotton  C101  Quintasia  Peter 12.7910\begin{array}{|l|l|l|l|l|l|}\hline \begin{array}{l}\text { Item } \\\text { Type }\end{array} & \text { Item } \mathrm{ID} & \text { Region } & \text { Buyer } & \begin{array}{l}\text { Unit } \\\text { Cost } \\(\$) \end{array} & \text { Units } \\\hline \text { Denim } & \text { D101 } & \text { Quintasia } & \text { Peter } & 9.79 & 101 \\\hline \text { Cotton } & \text { C101 } & \text { Prioland } & \text { Kane } & 27.79 & 56 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Jones } & 12.79 & 42 \\\hline \text { Leather } & \text { L101 } & \text { Prioland } & \text { Gerry } & 27.79 & 33 \\\hline \text { Denim } & \text { D103 } & \text { Dygertia } & \text { Sarah } & 10.79 & 62 \\\hline \text { Cotton } & \text { C102 } & \text { Quintasia } & \text { Peter } & 12.79 & 66 \\\hline \text { Denim } & \text { D101 } & \text { Prioland } & \text { Audrey } & 9.79 & 81 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Jones } & 12.79 & 96 \\\hline \text { Denim } & \text { D101 } & \text { Dygertia } & \text { Thomas } & 9.79 & 38 \\\hline \text { Cotton } & \text { C103 } & \text { Quintasia } & \text { Peter } & 16.79 & 66 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Mary } & 12.79 & 96 \\\hline \text { Cotton } & \text { C105 } & \text { Quintasia } & \text { Henry } & 9.79 & 35 \\\hline \text { Cotton } & \text { C101 } & \text { Quintasia } & \text { Philip } & 27.79 & 87 \\\hline \text { Denim } & \text { D102 } & \text { Quintasia } & \text { Peter } & 12.79 & 41 \\\hline \text { Jute } & \text { J101 } & \text { Prioland } & \text { Simson } & 132.8 & \text { 8 } \\\hline \text { Fur } & \text { F101 } & \text { Quintasia } & \text { Peter } & 23.79 & 22 \\\hline \text { Cotton } & \text { C103 } & \text { Prioland } & \text { Mary } & 16.79 & 34 \\\hline \text { Leather } & \text { L102 } & \text { Quintasia } & \text { Peter } & 16.79 & 70 \\\hline \text { Leather } & \text { L101 } & \text { Quintasia } & \text { Philip } & 27.79 & 21 \\\hline \text { Fur } & \text { F102 } & \text { Prioland } & \text { Kane } & 12.79 & 102 \\\hline \text { Denim } & \text { D104 } & \text { Prioland } & \text { Simson } & 9.09 & 73 \\\hline \text { Fur } & \text { F101 } & \text { Quintasia } & \text { Philip } & 23.79 & 80 \\\hline \text { Cotton } & \text { C103 } & \text { Prioland } & \text { Gerry } & 16.79 & 52 \\\hline \text { Cotton } & \text { C104 } & \text { Prioland } & \text { Simson } & 22.8 & 93 \\\hline \text { Cotton } & \text { C101 } & \text { Quintasia } & \text { Peter } & 12.79 & 10 \\\hline\end{array}
-Use Excel to identify the buyer who made the highest single purchase of cotton (in terms of sales revenue for Pointler's Inc.) in Quintasia.


Definitions:

MRP

Material Requirements Planning, a planning and inventory control system used to manage manufacturing processes.

Purely Competitive

A market structure characterized by many buyers and sellers, where each seller offers a homogeneous product and no single buyer or seller can influence the market price.

Labor Demand Schedule

A table or graph showing the quantity of labor that employers are willing to hire at different wage rates.

Profit-maximizing Combination

The selection of production inputs, price, and output levels that allow a firm to achieve the maximum possible profit.

Related Questions