Solved

Use the Data Given Below to Answer the Following Question

question 83

Multiple Choice

Use the data given below to answer the following question.
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter April-June) . $\begin{array}{|c|c|c|c|r|r|}\hline\text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\text { Units }} \\\hline 5 / 6 / 2012 & \text { SteelFork } & \text { Antasia } & \text { Peter } & 5.44 & 98 \\\hline 4 / 7 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Kane } & 23.44 & 53 \\\hline 5 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 39 \\\hline 6 / 10 / 2012 & \text { Silver Spoon } & \text { Puitoria } & \text { Gerry } & 23.44 & 30\\\hline 6 / 22 / 2012 & \text { SteelFork } & \text { Almeco } & \text { Sarah } & 6.44 & 59 \\\hline 5 / 17 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 63 \\\hline 4 / 25 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \\\hline 6 / 1 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \\\hline 4 / 2 / 2012 & \text { SteelFork } & \text { Almeco } & \text { Thomas } & 5.44 & 35 \\\hline 5 / 27 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 12.44 & 63 \\\hline 6 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Mary } & 8.44 & 93 \\\hline 4 / 30 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Henry } & 5.44 & 32 \\\hline 5 / 11 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Philip } & 23.44 & 84 \\\hline 6 / 18 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 8.44 & 38 \\\hline 5 / 9 / 2012 & \text { Glass Bottle } & \text { Puitoria } & \text { Simson } & 128.45 & 5 \\\hline 5 / 30 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 19.44 & 19 \\\hline 6 / 6 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Mary } & 12.44 & 31 \\\hline 4 / 3 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Peter } & 12.44 & 67 \\\hline 6 / 26 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Philip } & 23.44 & 18\\\hline 4 / 23 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 8.44 & 99 \\\hline 4 / 29 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Simson } & 4.74 & 70 \\\hline 4 / 4 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Philip } & 19.44 & 77 \\\hline 6 / 15 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 49 \\\hline 6 / 25 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Simson } & 18.45 & 90 \\\hline 5 / 23 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 7 \\\hline 6 / 28 / 2012 & \text { Ceramic Plate } & \text { Almeco } & \text { Sarah } & 23.44 & 10 \\\hline 5 / 25 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Jones } & 8.44 & 53 \\\hline 5 / 1 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Audrev } & 5.44 & 69\\\hline\end{array}$
$\quad$ $\begin{array}{|c|c|c|c|r|r|}\hline\text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\text { Units }} \\\hline 4 / 12 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Henry } & 8.44 & 99 \\\hline 4 / 18 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Gerry } & 4.74 & 56 \\\hline 6 / 30 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 83 \\\hline 5 / 19 / 2012 & \text { Glass Bottle } & \text { Puitoria } & \text { Kane } & 128.45 & 8 \\\hline 4 / 16 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 8.44 & 65 \\\hline 6 / 4 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Mary } & 15.94 & 58 \\\hline 5 / 2 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 27.4 & 45 \\\hline 4 / 19 / 2012 & \text { Glass Bottle } & \text { Almeco } & \text { Sarah } & 278.45 & 6 \\\hline 6 / 11 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Gerry } & 4.74 & 10 \\\hline 5 / 31 / 2012 & \text { Silver Spoon } & \text { Almeco } & \text { Sarah } & 5.44 & 79 \\\hline 6 / 2 / 2012 & \text { Ceramic Plate } & \text { Almeco } & \text { Thomas } & 23.44 & 60 \\\hline 4 / 13 / 2012 & \text { SteelFork } & \text { Puitoria } & \text { Audrey } & 4.74 & 17 \\\hline 5 / 3 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Jones } & 8.44 & 14 \\\hline 6 / 3 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Jones } & 23.44 & 97 \\\hline 4 / 17 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Audrey } & 8.44 & 31 \\\hline\end{array}$
-The Excel 2010 function computes the kth percentile of data in the range specified in the array field, where k is in the range 0 to 1, inclusive.

Definitions:

Market Price

The current price at which an asset or service can be bought or sold on the open market.

Reasonable Opportunity

An equitable chance or fair circumstance that allows an individual to perform an action or fulfill an obligation.

Inspect

To look at something or someone carefully in order to detect flaws, errors, or compliance with standards.

Rightfully Rejects

A term referring to the legal right of a party to refuse acceptance of goods or services that do not meet the agreed-upon specifications or contract terms.