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

question 27

Essay

Use the data given below to answer the following question(s).
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter (April-June). $\begin{array}{|l|l|l|l|l|l|}\hline \text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \begin{array}{c}\text { Unit } \\\text { Cost }\end{array} & \text { Units } \\\hline 5 / 6 / 2012 & \text { Steel Fork } & \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 { Steel Fork } & \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 { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \\\hline 6 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \\\hline 4 / 2 / 2012 & \text { Steel Fork } & \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 Bow1 } & \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 { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 69 \\\hline 4 / 12 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Henry } & 8.44 & 99 \\\hline 4 / 18 / 2012 & \text { Steel Fork } & \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 Bow1 } & \text { Puitoria } & \text { Mary } & 15.94 & 58 \\\hline 5 / 2 / 2012 & \text { Ceramic Bow1 } & \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\end{array}$
$\quad$ $$\begin{array} { | c | c | l | c | r | r |} \hline 4 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 4.74 & 17 \\\hline 5 / 3 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Jones } & 8.44 & 14 \\\hline 6 / 3 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Jones } & 23.44 & 97 \\\hline 4 / 17 / 2012 & \text { Cerarnic Plate } & \text { Puitoria } & \text { Audrey } & 8.44 & 31 \\\hline\end{array}$$
-Describe how to sort the data by inventory value to compute cumulative percentage of total inventory value to help the restaurateur conduct a Pareto analysis. (Assume that no damages were caused to the inventory purchased over the three months)

---

Definitions:

Visual

Relating to or using sight, pertaining to imagery or visual media.

Document

A piece of written, printed, or electronic matter that provides information or evidence or that serves as an official record.

Appendix

A supplementary material at the end of a book, document, or article, containing additional information on the topic.

Table

A piece of furniture with a flat top and one or more legs, providing a stable surface for working, eating, or storing items.