Elbert Manufacturing Has Recently Installed an Activity-Based Relational Data Base

question 58

Essay

Elbert Manufacturing has recently installed an activity-based relational data base.Using the information contained in the activity relational table,the following pool rates were computed:
$$\begin{array} { l l } \$ 400 & \text { per purchase order } \\\$ 24 & \text { per machine hour, Process R } \\\$ 30 & \text { per machine hour, Process S } \\\$ 80 & \text { per enpineering hour } \\\$ 4 & \text { per packing order } \\\$ 200 & \text { per square metre }\end{array}$$ Two products are produced by Elbert: Regular and Super.Each product has an area in the plant that is dedicated to its production.The plant has two manufacturing processes,the regular process (Process R)and the super process (Process S).Other processes include engineering,product handling,and procurement.The product relational table for Elbert is as follows:
$$\begin{array}{l}\text { Regular Praduct: }\\\begin{array} { l l c } { \text { Activit Driver \# and Name } } & \text { Activity Ustape } \\\hline 1 \quad \text { Units } & 800,000 \\2 \quad \text { Purchase orders } & 1,000 \\3 \quad \text { Machine hours } & 320,000 \\4 \quad \text { Engineering hours } & 5,000 \\5 \quad \text { Packing orders } & 400,000 \\6 \quad \text { Square metres } & 6,000 \end{array}\end{array}$$ $$\begin{array} { l } \text { Super Praduct: } \\\begin{array} { c l r } \text { Activit Driver \# and Name } & \text { Activity Ustage } \\\hline 1 \quad \text { Units } & 100,000 \\2 \quad \text { Purchase arders } & 500 \\3 \quad \text { Machine hours } & 40,000 \\4 \quad \text { Enpineering hours } & 6,000 \\5 \quad \text { Packing arders } & 100,000 \\6 \quad \text { Square metres } & 4,000\end{array} \end{array}$$
a.Identify two different concatenated keys.What is the purpose of concatenated keys?
b.Using the pool rates and the information from the product relational table,calculate the unit overhead cost for each product.
c.Does the product relational table indicate how many activities are in each pool? Is this necessary for product costing? Explain.

---

Definitions:

America Invents Act

A U.S. law passed in 2011 aimed at modernizing the American patent system, notably changing from a first-to-invent to a first-to-file system for patent applications.

First to Invent

A principle where the right to a patent for an invention is determined by being the first person to have conceived of the invention, rather than the first to file a patent application.

Patent Law

A legal framework that gives inventors exclusive rights to their inventions for a certain period of time.

Economic and Social Council

is a principal organ of the United Nations, responsible for coordinating the economic, social, and related work of 15 UN specialized agencies, commissions, and five regional commissions.