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,705,300 | |
| Cost of goods sold | 1,242,356 | ||
| Gross margin | 462,944 | ||
| Selling and administrative expenses | 600,000 | ||
| Net operating loss | $ | (137,056 | ) |
Hi-Tek produced and sold 60,500 units of B300 at a price of $20 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,900 | $ | 162,800 | $ | 563,700 |
| Direct labor | $ | 120,200 | $ | 42,800 | 163,000 | |
| Manufacturing overhead | 515,656 | |||||
| Cost of goods sold | $ | 1,242,356 | ||||
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 $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) | $ | 201,036 | 90,100 | 62,200 | 152,300 | |
| Setups (setup hours) | 153,120 | 78 | 270 | 348 | ||
| Product-sustaining (number of products) | 101,400 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,100 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 515,656 | ||||
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.)
|
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.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| PRODUCT MARING UNDER TRADITIONAL COSTING SYSTEM: | |||||||
| B300 | T500 | Total | |||||
| Product margin | $ 308,647 | $ 154,302 | $ 462,950 | ||||
| B300 | T500 | Total | |||||
| Product margin | $ 430,948 | $ (64,904) | $ 366,044 | ||||
| WORKINGS: | |||||||
| TRADITIONAL COSTING SYSTEM: | |||||||
| Pre-determined OH allocation rate = 515656/163000 = | 316.35% | ||||||
| . | B300 | T500 | Total | ||||
| Direct materials | $ 400,900 | $ 162,800 | $ 563,700 | ||||
| Direct labor | $ 120,200 | $ 42,800 | $ 163,000 | ||||
| Manufacturing overhead-Allocated (316.35% of Direct Labor Cost) | $ 380,253 | $ 135,398 | $ 515,651 | ||||
| Cost of goods sold | $ 901,353 | $ 340,998 | $ 1,242,351 | ||||
| Number of units | 60500 | 12700 | |||||
| Cost per unit | $ 14.90 | $ 26.85 | |||||
| Sales price per unit | $ 20.00 | $ 39.00 | |||||
| Sales revenue | $ 1,210,000 | $ 495,300 | |||||
| ABC SYSTEM: | |||||||
| ALLOCATION OF OVEHEAD: | |||||||
| CALCULATION OF ACTIVITY RATES: | |||||||
| Activity | |||||||
| Activity Cost Pool (and Activity Measure) | Manufacturing Overhead | B300 | T500 | Total | Activity Rate | ||
| Machining (machine-hours) | 201,036 | 90,100 | 62,200 | 152,300 | $ 1.32 | ||
| Setups (setup hours) | 153,120 | 78 | 270 | 348 | $ 440.00 | ||
| Product-sustaining (number of products) | 101,400 | 1 | 1 | 2 | $ 50,700.00 | ||
| Other (organization-sustaining costs) | 60,100 | NA | NA | NA | |||
| Total manufacturing overhead cost | 515,656 | ||||||
| COST OF SALES UNDER ABC: | |||||||
| . | B300 | T500 | Total | ||||
| Direct materials | $ 400,900 | $ 162,800 | $ 563,700 | ||||
| Direct labor | $ 120,200 | $ 42,800 | $ 163,000 | ||||
| Manufacturing overhead-Allocated: | |||||||
| Machining (machine-hours) | $ 118,932 | $ 82,104 | $ 201,036 | ||||
| Setups (setup hours) | $ 34,320 | $ 118,800 | $ 153,120 | ||||
| Product-sustaining (number of products) | $ 50,700 | $ 50,700 | $ 101,400 | ||||
| Manufacturing overhead-Allocated | $ 203,952 | $ 251,604 | $ 455,556 | ||||
| Advertising-Traceable | $ 54,000 | $ 103,000 | $ 157,000 | ||||
| Cost of sales under ABC | $ 779,052 | $ 560,204 | $ 1,339,256 | ||||
| Number of units | 60500 | 12700 | |||||
| Cost per unit | $ 12.88 | $ 44.11 | |||||
| Sales price per unit | $ 20.00 | $ 39.00 | |||||
| Sales revenue | $ 1,210,000 | $ 495,300 | $ 1,705,300 | ||||
| QUANTITATIVE COMPARISON: | |||||||
| B300 | T500 | Total | |||||
| % of | % of | ||||||
| Amount | Amount | Amount | |||||
| Traditional Cost System | |||||||
| Direct materials | $ 400,900 | 44.48% | % | $ 162,800 | 47.74% | % | $ 563,700 |
| Direct labor | $ 120,200 | 13.34% | % | $ 42,800 | 12.55% | % | $ 163,000 |
| Manufacturing overhead-Allocated | $ 380,253 | 42.19% | % | $ 135,398 | 39.71% | % | $ 515,651 |
| Total cost assigned to products | $ 901,353 | 100.00% | $ 340,998 | 100.00% | $ 1,242,351 | ||
| Selling and administrative expenses | $ 600,000 | ||||||
| Total cost | $ 1,842,351 | ||||||
| B300 | T500 | Total | |||||
| % of | % of | ||||||
| Amount | Total Amount | Amount | Total Amount | Amount | |||
| Activity-Based Costing System | |||||||
| Direct costs: | |||||||
| Direct materials | $ 400,900 | 51.46% | % | $ 162,800 | 29.06% | % | $ 563,700 |
| Direct labor | $ 120,200 | 15.43% | % | $ 42,800 | 7.64% | % | $ 163,000 |
| Total direct costs | $ 521,100 | 66.89% | % | $ 205,600 | 36.70% | % | $ 726,700 |
| Indirect costs: | 0.00% | 0.00% | |||||
| Machining (machine-hours) | $ 118,932 | 15.27% | % | $ 82,104 | 14.66% | % | $ 201,036 |
| Setups (setup hours) | $ 34,320 | 4.41% | % | $ 118,800 | 21.21% | % | $ 153,120 |
| Product-sustaining (number of products) | $ 50,700 | 6.51% | % | $ 50,700 | 9.05% | % | $ 101,400 |
| Advertising costs | $ 54,000 | 6.93% | $ 103,000 | 18.39% | $ 157,000 | ||
| Total cost assigned to products | $ 779,052 | 100.00% | $ 560,204 | 100.00% | $ 1,339,256 | ||
| Costs not assigned to products: | |||||||
| Other organization sustaining costs | 60,100 | ||||||
| Selling and administration = 600000-157000 = | 443,000 | ||||||
| Total cost | $ 1,842,356 | ||||||