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 $ 121.00 $ 86.00 Direct materials per unit $ 65.30 $ 52.00 Direct labor per unit $ 13.50 $ 9.00 Direct labor-hours per unit 1.5 DLHs 1.0 DLHs Estimated annual production and sales 31,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,230,000 Estimated total direct labor-hours 111,500 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) $ 724,750 46,500 65,000 111,500 Batch setups (setups) 975,000 420 330 750 Product sustaining (number of products) 470,000 1 1 2 Other 60,250 NA NA NA Total manufacturing overhead cost $ 2,230,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.
Answer:-
1 | ||||
Product margin under traditional system is | ||||
Xtreme | Pathfinder | Total | ||
A | No. of units | 31,000 | 65,000 | 96,000 |
B | Sale price per unit | 121 | 86 | |
C=A*B | Sale Value | 3,751,000 | 5,590,000 | 9,341,000 |
D | Direct Material | 2,024,300 | 3,380,000 | 5,404,300 |
E | Direct Labor | 418,500 | 585,000 | 1,003,500 |
F=D+E | Total Direct Costs | 2,442,800 | 3,965,000 | 6,407,800 |
G | Manufacturing Overhead | 930,000 | 1,300,000 | 2,230,000 |
H =F+G | Total Product Cost | 3,372,800 | 5,265,000 | 8,637,800 |
I=C-H | Product Margin | 378,200 | 325,000 | 703,200 |
2 |
|||||||
Product Margin under ABC system is | |||||||
Xtreme | Pathfinder | Total | |||||
A | No. of units | 31,000 | 65,000 | 96,000 | |||
B | Sale price per unit | 121 | 86 | ||||
C=A*B | Sale Value | 3,751,000 | 5,590,000 | 9,341,000 | |||
D | Direct Material | 2,024,300 | 3,380,000 | 5,404,300 | |||
E | Direct Labor | 418,500 | 585,000 | 1,003,500 | |||
F=D+E | Total Direct Costs | 2,442,800 | 3,965,000 | 6,407,800 | |||
G | Manufacturing Overhead (ABC) | 1,083,250 | 1,086,500 | 2,169,750 | |||
H =F+G | Total Product Cost | 3,526,050 | 5,051,500 | 8,577,550 | |||
I=C-H | Product Margin | 224,950 | 538,500 | 763,450 | |||
Activity | Activity Cost Pool | Cost driver | Xtreme | Calculation | Pathfinder | Calculation | |
Supporting direct labour | $724,750 | Direct labour hours | 302,250 | 46500/111500*724750 | 422,500 | 65000/111500*724750 | |
Batch setups | $975,000 | Setup hours | 546,000 | 420/750*975000 | 429,000 | 330/750*975000 | |
Product Sustaining | $470,000 | No. of products | 235,000 | 1/2*470000 | 235,000 | 1/2*470000 | |
Total | $2,169,750 | $1,083,250 | $1,086,500 |
3 |
|||||
Comparison of traditional and activity-based cost assignment is as follows: | |||||
Traditional Cost system | |||||
Xtreme | Pathfinder | Total | |||
Amount | % of total amount | Amount | % of total amount | Amount | |
Direct material | 2,024,300 | 60% | 3,380,000 | 64% | 5,404,300 |
Direct labour | 418,500 | 12% | 585,000 | 11% | 1,003,500 |
Manufacturing overhead | 930,000 | 28% | 1,300,000 | 25% | 2,230,000 |
Total cost assigned to products | 3,372,800 | 5,265,000 | 8,637,800 | ||
Activity Based Costing System | |||||
Xtreme | Pathfinder | Total | |||
Amount | % of total amount | Amount | % of total amount | Amount | |
Activity Based Costing System | |||||
Direct Costs | |||||
Direct material | 2,024,300 | 57% | 3,380,000 | 67% | 5,404,300 |
Direct labour | 418,500 | 12% | 585,000 | 12% | 1,003,500 |
Indirect Costs | |||||
Supporting direct labour | 302,250 | 9% | 422,500 | 8% | 724,750 |
Batch setups | 546,000 | 15% | 429,000 | 8% | 975,000 |
Product Sustaining | 235,000 | 7% | 235,000 | 5% | 470,000 |
Total Cost assigned to products | 3,526,050 | 100% | 5,051,500 | 100% | 8,577,550 |
Costs not assigned to products | |||||
Other | 60,250 | ||||
Total Costs | 8,637,800 |
if you have any query please ask me in comment box i am here to helps you don't give direct Thumbs down.if you satisfied my work give Thumbs UP
*******THANK YOU********