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,642,900 | |
| Cost of goods sold | 1,223,872 | ||
| Gross margin | 419,028 | ||
| Selling and administrative expenses | 560,000 | ||
| Net operating loss | $ | (140,972 | ) |
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 $39 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,300 | $ | 162,000 | $ | 562,300 |
| Direct labor | $ | 121,000 | $ | 42,600 | 163,600 | |
| Manufacturing overhead | 497,972 | |||||
| Cost of goods sold | $ | 1,223,872 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $56,000 and $103,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) | $ | 202,752 | 90,700 | 62,900 | 153,600 | |
| Setups (setup hours) | 133,320 | 73 | 230 | 303 | ||
| Product-sustaining (number of products) | 101,000 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,900 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 497,972 | ||||
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.)
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.) 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.)
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 other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1. Computation of Product Margin , under Traditional Costing System | ||||||
| Traditional Costing System | ||||||
| Product Margin | ||||||
| B300 | T500 | Total $ | ||||
| Sales | 1147600 | 495300 | 1642900 | |||
| Total Costs: | ||||||
| Direct Material | 400300 | 162000 | 562300 | |||
| Direct Labour | 121000 | 42600 | 163600 | |||
| Manufacturing Overhead | 368304 | 129668 | 497972 | |||
| 889604 | 334268 | 1223872 | ||||
| Product Margin | ₹ 2,57,996 | ₹ 1,61,032 | ₹ 4,19,028 | |||
| Working notes: (i) Sales for B300 = 60,400units @$19 | ||||||
| Sales for T500 = 12,700units @$39 | ||||||
| (ii)Allocation of Manufacturing overhead on the basis of direct labour: | ||||||
| formula: (Total manufacturing overhead/Total direct labour dollars) * Direct labour | ||||||
| For B300 : (497972/163600)*121000 | ||||||
| For T500 : (497972/163600)*42600 | ||||||
| 2. Computation of Product Margin , under Activity-based Costing System | ||||||
| Traditional Costing System | ||||||
| Product Margin | ||||||
| B300 | T500 | Total $ | ||||
| Sales | 1147600 | 495300 | 1642900 | |||
| Total Costs: | ||||||
| Direct Material | 400300 | 162000 | 562300 | |||
| Direct Labour | 121000 | 42600 | 163600 | |||
| Manufacturing Overhead | 2,02,344 | 2,34,728 | 437072 | |||
| 723644 | 439328 | 1162972 | ||||
| Product Margin | $ 4,23,956 | $ 55,972 | $ 4,79,928 | |||
| Working notes: (i) Sales for B300 = 60,400units @$19 | ||||||
| Sales for T500 = 12,700units @$39 | ||||||
| (ii)Allocation of Manufacturing overhead will be done in the ratio of activities | ||||||
| Manufacturing | Activity | Manufacturing overheads amount | ||||
| Activity Cost Pool (and Activity Measure) | Overhead | B300 | T500 | B300 | T500 | |
| Machining (machine-hours) | 2,02,752 | 90,700 | 62,900 | 119724 | 83028 | |
| Setups (setup hours) | 1,33,320 | 73 | 230 | 32120 | 101200 | |
| Product-sustaining (number of products) | 1,01,000 | 1 | 1 | 50500 | 50500 | |
| Total | 4,37,072 | 2,02,344 | 2,34,728 | |||
| 3. Comparison of the traditional and activity-based cost assignments | ||||||
| B300 | T500 | Total $ | ||||
| Amount | % of Total Amount | Amount | % of Total Amount | |||
| Traditional Cost System | ||||||
| Direct Material | 400300 | 71.19% | 162000 | 28.81% | 562300 | |
| Direct Labour | 121000 | 73.96% | 42600 | 26.04% | 163600 | |
| Manufacturing Overhead | 368304 | 73.96% | 129668 | 26.04% | 497972 | |
| Total cost assigned to products | 889604 | 334268 | 1223872 | |||
| Total cost | 1223872 | |||||
| B300 | T500 | Total $ | ||||
| Amount | % of Total Amount | Amount | % of Total Amount | |||
| Activity-Based Costing System | ||||||
| Direct costs: | ||||||
| Direct Material | 400300 | 71.19% | 162000 | 28.81% | 562300 | |
| Direct Labour | 121000 | 73.96% | 42600 | 26.04% | 163600 | |
| Advertising expenses | 56000 | 35.22% | 103000 | 64.78% | 159000 | |
| Indirect costs: | ||||||
| Machining | 119724 | 59.04% | 83028 | 40.96% | 202752 | |
| Setups | 32120 | 24.09% | 101200 | 75.91% | 133320 | |
| Product-sustaining | 50500 | 50% | 50500 | 50% | 101000 | |
| Total cost assigned to products | 779644 | 542328 | 1321972 | |||
| Costs not assigned to products: | ||||||
| Selling & administrative expenses | 401000 | |||||
| other cost | 60900 | |||||
| Total cost | 1783872 | |||||