AAA Metal Bearings Produces Two Sizes of Metal Bearings (Sold

AAA Metal Bearings produces two sizes of metal bearings (sold by the crate)-standard and heavy. The standard bearings require $200 of direct materials per unit (per crate) and the heavy bearings require $245 of direct materials per unit. The operation is mechanized and there is no direct labor. Previously AAA used a single plantwide allocation rate for manufacturing overhead, which was $1.55 per machine hour. Based on the single rate, gross profit data were as follows:
$$\begin{array} { | l | r | r | } \hline \text { Per unit } & { \text { Standard } } & { \text { Heavy } } \\\hline \text { Direct materials cost } & \$ 200.00& \$ 245.00 \\\hline \text { Direct labor cost } & \$ 0.00& \$ 0.00 \\\hline \text { Manuf overhead cost } & \$ 124.00& \$ 93.00 \\\hline \text { Total manuf cost } & \$ 324.00 & \$ 338.00 \\\hline & & \\\hline \text { Price per unit } & \$ 350.00& \$ 370.00 \\\hline \text { Gross profit per unit } &\$26.00 &\$32.00 \\\hline\end{array}$$
Although the data showed that the heavy bearings were more profitable than the standard bearings, the plant manager knew that the heavy bearings required much more processing in the metal fabrication phase than the standard bearings, and that this factor was not adequately reflected in the single allocation rate. He suspected that it was distorting the profit data. He suggested adopting an activity-based costing approach.
Working together, the engineers and accountants identified the following three manufacturing activities, and broke down the annual overhead costs as shown:
$$\begin{array} { | l | r | } \hline \text { Activities: } & \text { Estimated Cost } \\\hline \text { Metal fab } & \$ 420,000 \\\hline \text { Machine processing } & \$ 152,000 \\\hline \text { Packaging } & \$ 17,000 \\\hline & \$ 589,000 \\\hline\end{array}$$
Engineers believed that metal fabrication costs should be allocated by weight, and estimated that the plant processed 12,000 kilos of metal per year. Machine processing costs were correlated to machine hours, and the engineers estimated a total of 380,000 machine hours for the year. Packaging costs were the same for both types of products, and so they could be allocated simply by the number of units produced. The production plan provided for 4,000 units of standard and 1,000 units of heavy bearings to be produced during the year. Additional data on a per unit basis are as follows:
$\begin{array}{|l|r|r|}\hline &\text { Standard}& \text {Heavy}\\\hline \text { Kilos per unit } & 2.00 & 4.00 \\\hline \text { Machine hours per unit } & 80.00 & 60.00\\\hline\end{array}$
Using the data above, please calculate activity rates. Then, following the ABC methodology, calculate the production cost and gross profit for both product types, using the format below:
$$\begin{array} { | l | l | l | } \hline \text { Per Unit } & \text { Standard } & \text { Heavy } \\\hline \text { Direct materials } & & \\\hline \text { Metal fabrication } & & \\\hline \text { Machine processing } & & \\\hline \text { Packaging } & & \\\hline \text { Total mfg cost } & & \\\hline & & \\\hline \text { Price } & & \\\hline \text { Gross profit } & & \\\hline\end{array}$$