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

question 86

Essay

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.