In: Accounting
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,766,100 Cost of goods sold 1,228,700 Gross margin 537,400 Selling and administrative expenses 610,000 Net operating loss $ (72,600 ) 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 $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,400 $ 163,000 $ 563,400 Direct labor $ 120,600 $ 42,600 163,200 Manufacturing overhead 502,100 Cost of goods sold $ 1,228,700 The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $50,000 and $105,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) $ 210,450 90,100 62,400 152,500 Setups (setup hours) 129,150 75 240 315 Product-sustaining (number of products) 102,000 1 1 2 Other (organization-sustaining costs) 60,500 NA NA NA Total manufacturing overhead cost $ 502,100 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.
1) Overhead apportioned at traditional costing |
||||
on Direct Labor dollars: |
||||
B300 |
T500 |
Total |
||
Units produced & sold |
60100 |
12600 |
||
Sales revenue |
1262100 |
504000 |
1766100 |
|
Less:COGS: |
||||
DM |
400400 |
163000 |
563400 |
|
DL |
120600 |
42600 |
163200 |
|
Manuf. OH |
371037 |
131063 |
502100 |
|
COGS |
892037 |
336663 |
1228700 |
|
Gross Margin |
370063 |
167337 |
537400 |
|
2) Overhead apportioned at activity-based costing : |
||||
B300 |
T500 |
Total |
Ratio |
|
Units produced & sold |
60100 |
12600 |
||
Sales revenue |
1262100 |
504000 |
1766100 |
|
Less:COGS: |
||||
DM |
400400 |
163000 |
563400 |
|
DL |
120600 |
42600 |
163200 |
|
Manuf. OH: |
||||
Machining |
124338 |
86112 |
210450 |
90100/152500 : 62400/152500 |
Setups |
30750 |
98400 |
129150 |
75/315 : 240/315 |
Product-sustaining |
51000 |
51000 |
102000 |
1/2 : 1/2 |
Other |
NA |
NA |
60500 |
NA |
total Manuf OH |
206088 |
235512 |
502100 |
|
COGS |
727088 |
441112 |
1228700 |
|
Gross Margin |
535012 |
62888 |
537400 |
|
3) Quantitative comparison: |
||||
Costing method: |
||||
Traditional |
370063 |
167337 |
537400 |
|
Activity-based |
535012 |
62888 |
537400 |
|
Analysis |
More apportioned |
More apportioned |
||
under Traditional |
under activity base |