Examlex

Solved

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).  Order Date  Item  Region  Supplier  Unit  Cost  Units 5/6/2012 Steel Fork  Antasia  Peter 5.44984/7/2012 Ceramic Plate  Puitoria  Kane 23.44535/13/2012 Steel Fork  Puitoria  Jones 8.44396/10/2012 Silver Spoon  Puitoria  Gerry 23.44306/22/2012 Steel Fork  Almeco  Sarah 6.44595/17/2012 Ceramic Plate  Antasia  Peter 8.44634/25/2012 Steel Fork  Puitoria  Audrey 5.44786/1/2012 Steel Fork  Puitoria  Jones 8.44934/2/2012 Steel Fork  Almeco  Thomas 5.44355/27/2012 Ceramic Plate  Antasia  Peter 12.44636/13/2012 Steel Fork  Puitoria  Mary 8.44934/30/2012 Ceramic Plate  Antasia  Henry 5.44325/11/2012 Ceramic Plate  Antasia  Philip 23.44846/18/2012 Steel Fork  Antasia  Peter 8.44385/9/2012 Glass Bottle  Puitoria  Simson 128.4555/30/2012 Ceramic Bow1  Antasia  Peter 19.44196/6/2012 Ceramic Plate  Puitoria  Mary 12.44314/3/2012 Silver Spoon  Antasia  Peter 12.44676/26/2012 Silver Spoon  Antasia  Philip 23.44184/23/2012 Ceramic Bowl  Puitoria  Kane 8.44994/29/2012 Steel Fork  Puitoria  Simson 4.74704/4/2012 Ceramic Bowl  Antasia  Philip 19.44776/15/2012 Ceramic Plate  Puitoria  Gerry 12.44496/25/2012 Ceramic Plate  Puitoria  Simson 18.45905/23/2012 Ceramic Plate  Antasia  Peter 8.4476/28/2012 Ceramic Plate  Almeco  Sarah 23.44105/25/2012 Ceramic Bowl  Puitoria  Jones 8.44535/1/2012 Steel Fork  Puitoria  Audrey 5.44694/12/2012 Silver Spoon  Antasia  Henry 8.44994/18/2012 Steel Fork  Puitoria  Gerry 4.74566/30/2012 Ceramic Plate  Puitoria  Gerry 12.44835/19/2012 Glass Bottle  Puitoria  Kane 128.4584/16/2012 Ceramic Bowl  Antasia  Peter 8.44656/4/2012 Ceramic Bow1  Puitoria  Mary 15.94585/2/2012 Ceramic Bow1  Puitoria  Kane 27.4454/19/2012 Glass Bottle  Almeco  Sarah 278.4566/11/2012 Steel Fork  Puitoria  Gerry 4.74105/31/2012 Silver Spoon  Almeco  Sarah 5.44796/2/2012 Ceramic Plate  Almeco  Thomas 23.4460\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 4/13/2012 Steel Fork  Puitoria  Audrey 4.74175/3/2012 Cerarnic Plate  Puitoria  Jones 8.44146/3/2012 Cerarnic Plate  Puitoria  Jones 23.44974/17/2012 Cerarnic Plate  Puitoria  Audrey 8.4431\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:

Occupations

Jobs or professions that individuals engage in to earn a living.

Russia

The largest country in the world by area, spanning Eastern Europe and Northern Asia, known for its rich history, cultural heritage, and as a major global power.

Canada

A country in North America known for its vast landscapes, multicultural cities, and bilingual French and English heritage.

Earnings

Earnings refer to the amount of money an individual makes from work or investments, often considered as a measure of financial success or economic contribution.

Related Questions