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 | $ | 125.00 | $ | 91.00 | ||
| Direct materials per unit | $ | 64.20 | $ | 55.00 | ||
| Direct labor per unit | $ | 16.00 | $ | 10.00 | ||
| Direct labor-hours per unit | 1.6 | DLHs | 1.0 | DLHs | ||
| Estimated annual production and sales | 25,000 | units | 71,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,331,000 | ||
| Estimated total direct labor-hours | 111,000 | DLHs | ||
Required:
1. Compute the product margins for the Xtreme and the Pathfinder products under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
|
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) | $ | 888,000 | 40,000 | 71,000 | 111,000 | |
| Batch setups (setups) | 583,000 | 310 | 220 | 530 | ||
| Product sustaining (number of products) | 780,000 | 1 | 1 | 2 | ||
| Other | 80,000 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 2,331,000 | ||||
2. Compute the product margins for the Xtreme and the Pathfinder products under the activity-based costing system. (Round your intermediate calculations to 2 decimal places.)
|
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Answer 1. | |||||
| Predetermined Overhead Rate = $2,331,000 / 111,000 Lab. Hrs | |||||
| Predetermined Overhead Rate = $21 per DLH | |||||
| Statement Showing Product Margin | |||||
| Under Traditional Costing System | |||||
| Xtreme | Pathfinder | Total | |||
| Sales in Unit | 25000 | 71000 | |||
| SP per Unit | $125 | $91 | |||
| Sales in $ | 3,125,000 | 6,461,000 | 9,586,000 | ||
| Less: Cost of Goods Sold | |||||
| Direct material | 1,605,000 | 3,905,000 | 5,510,000 | ||
| Direct Labour | 400,000 | 710,000 | 1,110,000 | ||
| Manufacturing Overhead | 840,000 | 1,491,000 | 2,331,000 | ||
| Cost of goods Sold | 2,845,000 | 6,106,000 | 8,951,000 | ||
| Gross / Product Margin | 280,000 | 355,000 | 635,000 | ||
| Answer 2. | |||||
| Activity Cost Pool | Estimated Overhead | Expected use of Cost Drivers | Activity-Based Overhead rate | ||
| Supporting Direct Labor | 888,000 | 111,000 | 8 | per DLH | |
| Batch Setups | 583,000 | 530 | 1,100 | per setup | |
| Product Sustaining | 780,000 | 2 | 390,000 | per product | |
| others | 80,000 | NA | NA | ||
| Total Overhead | 2,331,000 | ||||
| Alocation of Overhead Cost | |||||
| Under ABC | |||||
| Particulars | Hiking Boots | Total | |||
| Xtreme | Pathfinder | ||||
| Supporting Direct Labor | 320,000 | 568,000 | 888,000 | ||
| Batch Setups | 341,000 | 242,000 | 583,000 | ||
| Product Sustaining | 390,000 | 390,000 | 780,000 | ||
| Total | 1,051,000 | 1,200,000 | 2,251,000 | ||
| Statement Showing Product Margin | |||||
| Under ABC | |||||
| Xtreme | Pathfinder | Total | |||
| Sales in Unit | 25000 | 71000 | |||
| SP per Unit | 125 | 91 | |||
| Sales in $ | 3,125,000 | 6,461,000 | 9,586,000 | ||
| Less: Cost of Goods Sold | |||||
| Direct material | 1,605,000 | 3,905,000 | 5,510,000 | ||
| Direct Labour | 400,000 | 710,000 | 1,110,000 | ||
| Manufacturing Overhead | 1,051,000 | 1,200,000 | 2,251,000 | ||
| Cost of goods Sold | 3,056,000 | 5,815,000 | 8,871,000 | ||
| Product Margin | 69,000 | 646,000 | 715,000 | ||
| Non Traceable Other Manufacturing Exp. | 80,000 | ||||
| Net Operating Profit / (Loss) | 635,000 | ||||
| Answer 3. | |||||
| Xtreme | Pathfinder | Total | |||
| Amt | % of Total Amt. | % of Total Amt. | Amount | ||
| Traditional Cost System | |||||
| Direct material | 1,605,000 | 29.13% | 3,905,000 | 70.87% | 5,510,000 |
| Direct Labour | 400,000 | 36.04% | 710,000 | 63.96% | 1,110,000 |
| Manufacturing Overhead | 840,000 | 36.04% | 1,491,000 | 63.96% | 2,331,000 |
| Total Cost Assigned to product | 2,845,000 | 6,106,000 | 8,951,000 | ||
| Xtreme | Pathfinder | Total | |||
| Amt | % of Total Amt. | % of Total Amt. | Amount | ||
| Activity Based Costing | |||||
| Direct Costs | |||||
| Direct material | 1,605,000 | 29.13% | 3,905,000 | 70.87% | 5,510,000 |
| Direct Labour | 400,000 | 36.04% | 710,000 | 63.96% | 1,110,000 |
| Indirect Costs | |||||
| Supporting Direct Labor | 320,000 | 36.04% | 568000 | 63.96% | 888,000 |
| Batch Setups | 341000 | 58.49% | 242000 | 41.51% | 583,000 |
| Product Sustaining | 390000 | 50.00% | 390000 | 50.00% | 780,000 |
| Total Cost assigned to products | 3,056,000 | 5,815,000 | 8,871,000 | ||
| Costs not assigned to products | |||||
| Non Traceable Other Manufacturing Exp. | 80,000 | ||||
| Net Operating Profit / (Loss) | 8,951,000 | ||||