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 \begin{array}{c}
\text { Order } \
\text { Date }
\end{array} & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\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 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 { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 69\
\hline
\end{array}\)
$\quad$
$\quad$ \(\begin{array}{|c|c|c|c|r|r|}
\hline\begin{array}{c}
\text { Order } \
\text { Date }
\end{array} & \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 { 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 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 { Steel Fork } & \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}\)
-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)

Question

Quizplus · Accepted Answer

The Answer of 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 \begin{array}{c}
\text { Order } \
\text { Date }
\end{array} & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & {\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 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 { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 69\
\hline
\end{array}\)
$\quad$
$\quad$ \(\begin{array}{|c|c|c|c|r|r|}
\hline\begin{array}{c}
\text { Order } \
\text { Date }
\end{array} & \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 { 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 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 { Steel Fork } & \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}\)
-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)

Use the Data Given Below to Answer the Following Question