question archive Royal Manufacturing, Inc
Subject:AccountingPrice:2.84 Bought3
Royal Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. A traditional costing income statement for the most recent period is shown: Income Statement Sales $2,100,000 Cost of goods sold 1,600,000 Gross margin 500,000 Selling and administrative expenses 550,000 Net operating loss ... $ (50,000) Royal produced and sold 70,000 units of B300 at a price of $20 per unit and 17,500 units of T500 at a price of $40 per unit. The company's traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company's two product lines is shown below: Direct materials Direct labor ..... Manufacturing overhead Cost of goods sold B300 T500 Total $436,300 $251,700 $ 688,000 $200,000 $104,000 304,000 608,000 $1,600,000 The company has created an activity-based costing system to evaluate the profitability of its products. Royal ABC implementation team concluded that $50,000 and $100,000 of the company's advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization- sustaining in nature. The ABC team also distributed the company's manufacturing overhead to four activities as shown: Manufacturing Activity Activity Cost Pool (and Activity Measure) Overhead B300 T500 Total Machining (machine-hours).. $213,500 90,000 62,500 152,500 Setups (setup hours) 157,500 75 300 375 Product-sustaining (number of products) 120,000 1 1 2 Other (organization-sustaining costs) 117,000 NA NA NA Total manufacturing overhead cost. $608,000 Required: 1. compute the product margins for the B300 and T500 under the company's traditional costing system. compute the product margins for B300 and T500 under the activity-based costing system. prepare a quantitative comparison of the traditional and activity-based cost assignments. Explain why the traditional and activity-based cost assignments differ. 2. 3.
1 - Traditional costing
Manufacturing Overhead = 608000
Direct labor = 304000
Overhead Rate = 608000 / 304000 = 2
To B300 = 2 * 200000 = 400000
To T500 = 2 * 104000 = 208000
B300 |
T500 |
Total |
|
Units |
70000 |
17500 |
|
Selling Price |
20 |
40 |
|
Sales |
1400000 |
700000 |
2100000 |
Less: Cost of Goods Sold |
|||
Direct materials |
436300 |
251700 |
688000 |
Direct labor |
200000 |
104000 |
304000 |
Manufacturing Overhead |
400000 |
208000 |
608000 |
Total Cost of Goods Sold |
1036300 |
563700 |
1600000 |
Product margin |
363700 |
136300 |
500000 |
2 - Activity based costing
Activity rate
Activity Cost Pool (and Activity Measure) |
Manufacturing Overhead |
Activity total |
Activity rate |
Machining (machine-hours) |
213500 |
152500 |
1.4 |
Setups (setup hours) |
157500 |
375 |
420 |
Product-sustaining (number of products) |
120000 |
2 |
60000 |
Other (organization-sustaining costs) |
117000 |
NA |
|
Total manufacturing overhead cost |
608000 |
Allocation
Activity Cost Pool (and Activity Measure) |
B300 - used |
Allocated to B300 (Activity rate * B300 - used ) |
T500 - used |
Allocated to T500 (Activity rate * T500-used ) |
Machining (machine-hours) |
90000 |
126000 |
62500 |
87500 |
Setups (setup hours) |
75 |
31500 |
300 |
126000 |
Product-sustaining (number of products) |
1 |
60000 |
1 |
60000 |
Other (organization-sustaining costs) |
||||
Total manufacturing overhead cost |
217500 |
273500 |
B300 |
T500 |
Total |
|
Sales |
1400000 |
700000 |
2100000 |
Less: Cost of Goods Sold |
|||
Direct materials |
436300 |
251700 |
688000 |
Direct labor |
200000 |
104000 |
304000 |
Machining |
126000 |
87500 |
213500 |
Setups |
31500 |
126000 |
157500 |
Product-sustaining |
60000 |
60000 |
120000 |
Advertising |
50000 |
100000 |
150000 |
Total Manufacturing Overhead |
267500 |
373500 |
641000 |
Total Cost of Goods Sold |
903800 |
729200 |
1633000 |
Product margin |
496200 |
-29200 |
467000 |
3. Comparison
Traditional Cost System |
B300 |
% |
T500 |
% |
Amount |
Direct materials |
436300 |
42.10% |
251700 |
44.65% |
688000 |
Direct labor |
200000 |
19.30% |
104000 |
18.45% |
304000 |
Overhead |
400000 |
38.60% |
208000 |
36.90% |
608000 |
Total cost Assigned |
1036300 |
563700 |
|||
Selling and Admin Expenses |
550000 |
||||
Total cost |
2150000 |
Activity Based Costing System |
B300 |
% |
T500 |
% |
Amount |
Direct Cost |
|||||
Direct materials |
436300 |
48.27% |
251700 |
34.52% |
688000 |
Direct labor |
200000 |
22.13% |
104000 |
14.26% |
304000 |
Advertising |
50000 |
5.53% |
100000 |
13.71% |
150000 |
Indirect Cost: |
|||||
Machining |
126000 |
13.94% |
87500 |
12.00% |
213500 |
Setups |
31500 |
3.49% |
126000 |
17.28% |
157500 |
Product-sustaining |
60000 |
6.64% |
60000 |
8.23% |
120000 |
Total Cost Assigned to Product |
903800 |
729200 |
1633000 |
||
Cost Not Assigned |
|||||
organization-sustaining costs |
117000 |
||||
Selling Expenses |
550000 |
||||
Total Cost |
2300000 |
* The difference between the traditional method which use one cost driver and the Activity based costing method which use multiple cost drivers. Activity-based costing is a more accurate method, because it assigns overhead based on the activities that drive the overhead costs.