In: Accounting
Smoky Mountain Corporation makes two types of hiking boots—the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Xtreme Pathfinder Selling price per unit $ 120.00 $ 87.00 Direct materials per unit $ 65.20 $ 51.00 Direct labor per unit $ 11.20 $ 8.00 Direct labor-hours per unit 1.4 DLHs 1.0 DLHs Estimated annual production and sales 30,000 units 65,000 units The company has a traditional costing system in which manufacturing overhead is applied to units based on direct labor-hours. Data concerning manufacturing overhead and direct labor-hours for the upcoming year appear below: Estimated total manufacturing overhead $ 2,033,000 Estimated total direct labor-hours 107,000 DLHs Required: 1. Compute the product margins for the Xtreme and the Pathfinder products under the company’s traditional costing system. 2. The company is considering replacing its traditional costing system with an activity-based costing system that would assign its manufacturing overhead to the following four activity cost pools (the Other cost pool includes organization-sustaining costs and idle capacity costs): Estimated Overhead Cost Expected Activity Activities and Activity Measures Xtreme Pathfinder Total Supporting direct labor (direct labor-hours) $ 631,300 42,000 65,000 107,000 Batch setups (setups) 876,000 410 320 730 Product sustaining (number of products) 460,000 1 1 2 Other 65,700 NA NA NA Total manufacturing overhead cost $ 2,033,000 Compute the product margins for the Xtreme and the Pathfinder products under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
| 1) | overhead rate | |||||||
| estimated MOH/estimated DLH's | ||||||||
| 2,033,000/107000 | ||||||||
| 19 | per direct labor hour | |||||||
| product margin | ||||||||
| Xtreme | pathfinder | total | ||||||
| sales | 3600000 | 5655000 | ||||||
| less:Expense | ||||||||
| Direct materials | 1956000 | 3315000 | ||||||
| Direct labor | 336000 | 520000 | ||||||
| overhead | 798000 | 1235000 | ||||||
| total cost | 3090000 | 5070000 | ||||||
| product margin | 510000 | 585000 | 1095000 | |||||
| Xtreme | pathfinder | total | ||||||
| product margin | 510000 | 585000 | 1095000 | answer | ||||
| 2) | overhead rate | oh rate | ||||||
| amount | driver | |||||||
| Activity | ||||||||
| Supporting direct labor | 631,300 | 107,000 | 5.9 | |||||
| batch setups | 876,000 | 730 | 1200 | |||||
| product sustaining | 460,000 | 2 | 230000 | |||||
| allocation of overhead and per unit cost | ||||||||
| Xtremet | Pathfinder | |||||||
| Rate | driver | OH | Rate | Driver | OH | |||
| Activity | ||||||||
| Supporting direct labor | 5.9 | 42,000 | 247800 | 5.9 | 65,000 | 383500 | ||
| batch setups | 1200 | 410 | 492000 | 1200 | 320 | 384000 | ||
| product sustaining | 230000 | 1 | 230000 | 230000 | 1 | 230000 | ||
| total overhead | 969800 | 997500 | ||||||
| product margin | ||||||||
| Xtreme | pathfinder | total | ||||||
| Selling price per unit | 3600000 | 5655000 | ||||||
| less:Expense | ||||||||
| Direct materials | 1956000 | 3315000 | ||||||
| Direct labor | 336000 | 520000 | ||||||
| total overhead | 969800 | 997500 | 1967300 | |||||
| total cost | 3261800.00 | 4832500.00 | ||||||
| product margin | 338200.00 | 822500.00 | 1160700.00 | |||||
| Xtreme | pathfinder | total | ||||||
| product margin | 338200 | 822500 | 1160700 | answer | ||||
| 3) | Xtreme | Pathfinder | total | |||||
| % of | % of | |||||||
| Amount | total amount | Amount | total amount | Amount | ||||
| Traditional Cost system | ||||||||
| Direct materials | 1956000 | 37.1% | 3315000 | 62.9% | 5271000 | |||
| direct labor | 336000 | 39.3% | 520000 | 60.7% | 856000 | |||
| manufacturing overhead | 798000 | 39.3% | 1235000 | 60.7% | 2033000 | |||
| total cost assigned to produts | 3090000 | 5070000 | 8160000 | |||||
| Xtreme | Pathfinder | total | ||||||
| % of | % of | |||||||
| Amount | total amount | Amount | total amount | Amount | ||||
| Activity based | ||||||||
| Direct materials | 1956000 | 37.1% | 3315000 | 62.9% | 5271000 | |||
| direct labor | 336000 | 39.3% | 520000 | 60.7% | 856000 | |||
| indirect costs | ||||||||
| Supporting direct labor | 247800 | 39.3% | 383500 | 60.7% | 631300 | |||
| batch setups | 492000 | 56.2% | 384000 | 43.8% | 876000 | |||
| product sustaining | 230000 | 50.0% | 230000 | 50.0% | 460000 | |||
| total cost assigned to products | 3261800 | 4832500 | 8094300 | |||||
| costs not assigned to products | ||||||||
| other | 65,700 | |||||||
| total cost. | 8160000 | |||||||