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:

Actual Indirect Factory Wages

This represents the wages paid to workers who are not directly involved in production but support the manufacturing process.

Budgeted Amounts

Financial plans that project income, expenditures, and allocations for a specific period, often used for control and decision-making purposes.

Actual Production

The real, quantifiable amount of goods or services produced by a company within a specific period.

Fixed Factory Overhead Volume Variance

A measure used in managerial accounting to assess the difference between the budgeted and the actual volume of production, affecting fixed overhead costs.