Excel Manufacturing Has an Activity-Based Costing System with Three Activity

Excel Manufacturing has an activity-based costing system with three activity cost pools-Machining,Batch Setup,and Other.The company's overhead costs have already been allocated to the cost pools and total $28,000 for the Machining cost pool,$13,800 for the Batch Setup cost pool,and $27,200 for the Other cost pool.Costs in the Machining cost pool are assigned to products based on machine-hours (MHs)and costs in the Batch Setup cost pool are assigned to products based on the number of batches.Costs in the Other cost pool are not assigned to products.Data concerning the two products and the company's costs appear below:
$$\begin{array} { | l | r | r | } \hline & \text { MHs } & \text { Batches } \\\hline \text { Product A. } & 5,200 & 500 \\\hline \text { Product B } &\underline{ 14,800 }& \underline{500 }\\\hline \text { Total } & 20,000 & 1,000 \\\hline\end{array}$$
$$\begin{array} { | l | r | r | } \hline & \text { Product } A & \text { Product B } \\\hline \text { Sales (total) } & \$ 124,300 & \$ 166,000 \\\hline \text { Direct materials } & \$ 53,100 & \$ 71,500 \\\text { (total) } \\\hline \text { Direct labor (total) } & \$ 54,000 & \$ 56,600 \\\hline\end{array}$$
Required:
a.Calculate activity rates for each activity cost pool using activity-based costing.b.Determine the amount of overhead cost that would be assigned to each product using activity-based costing.c.Determine the product margins for each product using activity-based costing.

Correct Answer:

Verified

a.Computation of activity rates:
\[\beg ...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

View Full Answer For Free