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:

Union Suppression

Efforts or strategies aimed at weakening, regulating, or eliminating labor unions and their influence on workers and workplace conditions.

Strike Replacements

Workers who are hired to fill the positions of striking workers during a labor strike, often controversial as they can undermine the effectiveness of the strike.

Ethical Perspective

A viewpoint or approach considering what is morally right or wrong in the context of decision-making or behavior.

Utility

In economics, utility refers to the satisfaction or benefit derived by consumers from consuming goods or services.

Related Questions