Question

In: Accounting

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:

Hi-Tek Manufacturing Inc.
Income Statement
Sales $ 1,714,000
Cost of goods sold 1,231,554
Gross margin 482,446
Selling and administrative expenses 600,000
Net operating loss $ (117,554 )

Hi-Tek produced and sold 60,500 units of B300 at a price of $20 per unit and 12,600 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:

B300 T500 Total
Direct materials $ 400,700 $ 162,000 $ 562,700
Direct labor $ 120,900 $ 42,200 163,100
Manufacturing overhead 505,754
Cost of goods sold $ 1,231,554

The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $58,000 and $106,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 below:

Manufacturing
Overhead
Activity
Activity Cost Pool (and Activity Measure) B300 T500 Total
Machining (machine-hours) $ 209,304 91,000 62,900 153,900
Setups (setup hours) 135,450 75 240 315
Product-sustaining (number of products) 100,600 1 1 2
Other (organization-sustaining costs) 60,400 NA NA NA
Total manufacturing overhead cost $ 505,754

Required:

1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.

2. Compute the product margins for B300 and T500 under the activity-based costing system.

3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.

Solutions

Expert Solution

B300 T500 Total
Units 60500 12600
Sales Price 20 40
Direct Material 400700 162200 562900 Total Manufacturing OH 505754
Direct Labor 120900 42200 163100 Total Direct Labor Dollars 163100
Manufacturing OH 505754 Overhead Per Dollars 3.10
Cost of Goods Sold 1231754
1 B300 T500 1.998347107 3.349206
Sales Price 20.00 40.00 6.196640362 10.3855
Less: Direct Material 6.62 12.87
Less: Direct Labor 2.00 3.35
Less: Maufacturing OH 6.20 10.39
Product Margin 5.18 13.39
2 B300 T500 Activity Pools Amt B300 T500 Total Per Driver
Sales Price 20.00 40.00 Machining 209304 91000 62900 153900 1.36
Less: Direct Material 6.62 12.87 Setups 135450 75 240 315 430
Less: Direct Labor 2.00 3.35 Product Sustaining 100600 1 1 2 50300
Less: Maufacturing OH 3.41 18.97 Other 60400 NA NA NA
Product Margin 7.97 4.81 Total M OH 505754
Allocation: B300 T500
Machining 123760 85544
Setups 32250 103200
Product Sustaining 50300 50300
Total M OH 206310 239044
Units 60500 12600
B300 T500 Manufacturing OH 3.41 18.97
60500 12600
3
B300 T500 Total
Traditional Cost System Amount % Amount % Amount
Direct Material 4,00,700 44.70% 1,62,200 48.38% 5,62,900
Direct Labor 1,20,900 13.49% 42,200 12.59% 1,63,100
Manufacturing OH 3,74,897 41.82% 1,30,857 39.03% 5,05,754
Total Cost assigned to products 8,96,497 100.00% 3,35,257 100.00% 12,31,754
Traditional Cost System Amount % Amount % Amount
Direct Costs:
Direct Material 4,00,700 55% 1,62,200 36.58% 5,62,900
Direct Labor 1,20,900 17% 42,200 9.52% 1,63,100
Indirect Costs:
Machining 1,23,760 17% 85,544 19.29% 2,09,304
Setups 32,250 4% 1,03,200 23.27% 1,35,450
Product Sustaining 50,300 7% 50,300 11.34% 1,00,600
Total Cost assigned to products 7,27,910 100% 4,43,444 100.00% 11,71,354
Costs not assigned to products:
Others 60400
Total Cost 12,31,754

Related Solutions

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,770,300 Cost of goods sold 1,234,258 Gross margin 536,042 Selling and administrative expenses 590,000 Net operating loss $ (53,958 ) Hi-Tek produced and sold 60,300 units of B300 at a price of $21 per unit and 12,600 units of T500 at a price of $40 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,704,000 Cost of goods sold 1,222,415 Gross margin 481,585 Selling and administrative expenses 590,000 Net operating loss $ (108,415 ) Hi-Tek produced and sold 60,000 units of B300 at a price of $20 per unit and 12,600 units of T500 at a price of $40 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,776,400 Cost of goods sold 1,233,700 Gross margin 542,700 Selling and administrative expenses 550,000 Net operating loss $ (7,300 ) Hi-Tek produced and sold 60,400 units of B300 at a price of $21 per unit and 12,700 units of T500 at a price of $40 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,645,900 Cost of goods sold 1,225,174 Gross margin 420,726 Selling and administrative expenses 590,000 Net operating loss $ (169,274 ) Hi-Tek produced and sold 60,100 units of B300 at a price of $19 per unit and 12,600 units of T500 at a price of $40 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,691,400 Cost of goods sold 1,219,910 Gross margin 471,490 Selling and administrative expenses 570,000 Net operating loss $ (98,510 ) Hi-Tek produced and sold 60,000 units of B300 at a price of $20 per unit and 12,600 units of T500 at a price of $39 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,702,000 Cost of goods sold 1,218,323 Gross margin 483,677 Selling and administrative expenses 590,000 Net operating loss $ (106,323 ) Hi-Tek produced and sold 60,100 units of B300 at a price of $20 per unit and 12,500 units of T500 at a price of $40 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,699,400 Cost of goods sold 1,245,844 Gross margin 453,556 Selling and administrative expenses 640,000 Net operating loss $ (186,444 ) Hi-Tek produced and sold 60,400 units of B300 at a price of $20 per unit and 12,600 units of T500 at a price of $39 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,695,400 Cost of goods sold 1,234,000 Gross margin 461,400 Selling and administrative expenses 640,000 Net operating loss $ (178,600 ) Hi-Tek produced and sold 60,200 units of B300 at a price of $20 per unit and 12,600 units of T500 at a price of $39 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,655,600 Cost of goods sold 1,245,008 Gross margin 410,592 Selling and administrative expenses 580,000 Net operating loss $ (169,408 ) Hi-Tek produced and sold 60,400 units of B300 at a price of $19 per unit and 12,700 units of T500 at a price of $40 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,753,500 Cost of goods sold 1,239,487 Gross margin 514,013 Selling and administrative expenses 590,000 Net operating loss $ (75,987 ) Hi-Tek produced and sold 60,100 units of B300 at a price of $21 per unit and 12,600 units of T500 at a price of $39 per unit....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT