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:

Issued Shares

Represents the total number of shares that have been allocated by a corporation and are held by shareholders, including both public investors and company officers or insiders.

Stockholders' Equity

The remaining stake in a company's assets once all debts are subtracted, indicating the shareholders' ownership claim.

Authorized Shares

The maximum number of shares that a corporation is legally allowed to issue, as specified in its charter.

Common Stock

A form of corporate equity ownership, a type of security that represents ownership in a corporation and entitles the shareholder to vote on corporate matters.

Related Questions