1. Overhead allocation rate under traditional costing system =
total manufacturing overheads*Labor cost consumed/total direct
Labor dollars
Allocated to B300 = 506*631*120,400/163,200
=$373,765
Allocated to T500 = 506,631*42,800/163,200
= $132,866
Calculation of product margin:
|
B300 |
T500 |
Sales |
1,262,100 |
512,000 |
Direct Material |
400,100 |
163,000 |
Direct Labor |
120,400 |
42,800 |
Manufacturing overhead |
373,765 |
132,866 |
Product Margin |
367,835 |
173,334 |
|
|
|
2. Using ABC
Overhead allocation = overhead cost*driver consumed/total
activity
Calculation of Product margin
|
B300 |
T500 |
Sales |
1,262,100 |
512,000 |
Direct Material |
400,100 |
163,000 |
Direct Labor |
120,400 |
42,800 |
Overheads:
|
|
|
Machining |
123,300 |
85,351 |
Set up |
31,080 |
105,000 |
Product sustaining |
50,500 |
50,500 |
Product Margin |
536,720 |
65,349 |
|
|
|
3. Quantitative comparison
|
B300 |
T500 |
Product Margin as per traditional |
367,835 |
173,334 |
As per ABC |
563,720 |
65,349 |
Difference |
(195,885) |
107,985 |