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,778,300 | |
| Cost of goods sold | 1,235,069 | ||
| Gross margin | 543,231 | ||
| Selling and administrative expenses | 620,000 | ||
| Net operating loss | $ | (76,769 | ) |
Hi-Tek produced and sold 60,300 units of B300 at a price of $21 per unit and 12,800 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,100 | $ | 162,300 | $ | 562,400 |
| Direct labor | $ | 120,600 | $ | 42,800 | 163,400 | |
| Manufacturing overhead | 509,269 | |||||
| Cost of goods sold | $ | 1,235,069 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $54,000 and $107,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) | $ | 211,419 | 90,000 | 62,100 | 152,100 | |
| Setups (setup hours) | 135,450 | 71 | 230 | 301 | ||
| Product-sustaining (number of products) | 101,800 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,600 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 509,269 | ||||
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.
Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
| Required 1: |
|
Required 2:
Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
|
Required 3:
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.
| B300 | T500 | Total | |
| Selling price | 21.00 | 40.00 | |
| Units sold | 60300 | 12800 | |
| Sales | 1266300 | 512000 | 1778300 |
| Direct materials | 400100 | 162300 | 562400 |
| Direct labour | 120600 | 42800 | 163400 |
| Manufacturing overheads* | 375874 | 133395 | 509269 |
| Cost of Goods sold | 896574 | 338495 | 1235069 |
| Product Margin | 369726 | 173505 | 543231 |
| *Total manufacturing overhead $ | 509269 | ||
| Total direct labour dollars | 163400 | ||
| B300 | 509269*120600/163400 | 375874.18 | |
| T500 | 509269*42800/163400 | 133394.82 | |
2.
| B300 | T500 | Total | |
| Selling price | 21.00 | 40.00 | |
| Units sold | 60300 | 12800 | |
| Sales | 1266300 | 512000 | 1778300 |
| Direct materials | 400100 | 162300 | 562400 |
| Direct labour | 120600 | 42800 | 163400 |
| Manufacturing overheads* | 207950 | 240719 | 448669 |
| Advertising expenses | 54000 | 107000 | 161000 |
| Cost of Goods sold | 782650 | 552819 | 1335469 |
| Product Margin | 483650 | -40819 | 442831 |
| *Manufacturing overheads | ||||||
| Overhead cost $ | B300 | T500 | Total | |||
| Machining | 211419 | 90000 | 125100 | 62100 | 86319 | 152100 |
| Setups | 135450 | 71 | 31950 | 230 | 103500 | 301 |
| Product sustaining | 101800 | 1 | 50900 | 1 | 50900 | 2 |
| Other | 60600 | NA | 0 | NA | 0 | NA |
| Total manufacturing overhead cost | 509269 | 207950 | 240719 | |||
| Advertising expenses | 161000 | 54000 | 107000 | |||
| Total Overheads cost | 670269 | 261950 | 347719 | |||
3.
| B300 | T500 | Total | |||||
| % of | % of | ||||||
| Amount | Total Amount | Amount | Total Amount | Amount | |||
| Traditional Cost System | |||||||
| Direct material | 400100 | 71.1 | % | 162300 | 28.9 | % | 562400 |
| Direct labour | 120600 | 73.8 | % | 42800 | 26.2 | % | 163400 |
| Manufacturing overhead | 375874 | 73.8 | % | 133395 | 26.2 | % | 509269 |
| Total cost assigned to products | 896574 | 72.6 | % | 338495 | 27.4 | % | 1235069 |
| Selling and Administrative | 620000 | ||||||
| Total Cost | 1855069 | ||||||
| B300 | T500 | Total | |||||
| % of | % of | ||||||
| Amount | Total Amount | Amount | Total Amount | Amount | |||
| Activity Based Costing System | |||||||
| Direct Costs: | |||||||
| Direct material | 400100 | 71.1 | % | 162300 | 28.9 | % | 562400 |
| Direct labour | 120600 | 73.8 | % | 42800 | 26.2 | % | 163400 |
| Advertising expense | 54000 | 33.5 | % | 107000 | 66.5 | % | 161000 |
| Indirect Costs: | |||||||
| Machining | 125100 | 59.2 | % | 86319 | 40.8 | % | 211419 |
| Setups | 31950 | 23.6 | % | 103500 | 76.4 | % | 135450 |
| Product sustaining | 50900 | 50.0 | % | 50900 | 50.0 | % | 101800 |
| Total cost assigned to products | 782650 | 58.6 | % | 552819 | 41.4 | % | 1335469 |
| Costs not assigned to products | |||||||
| Selling and Administrative | 459000 | ||||||
| Manufacturing overheads | 60600 | ||||||
| Total Costs | 1855069 | ||||||