In: Accounting
Executive Images Corporation produces two types of wooden bookends: plain and hand-carved. The following information about the production process is available:
|
Plain |
Hand-Carved |
|
|
Number produced |
120,000 |
75,000 |
|
Machine hours |
95,000 |
25,000 |
|
Inspection hours |
7,000 |
35,000 |
|
Revenues |
$4,800,000 |
$4,400,000 |
|
Direct costs |
$3,800,000 |
$3,100,000 |
Total factory overhead is $1,200,000. Of this overhead, $500,000 is related to utilities (cost driver = machine hours) and the remainder is related to quality control (cost driver = inspection hours).
A) If the Corporation uses ABC allocation method, what is the profit per unit of “Plain” bookend? Per unit of “Hand-Carved” bookend?
B) If the Corporation uses traditional method and allocates the factory overhead using machine hours, what is the profit per unit for each product?
Please show work and all equations used.
| Computation of Activity Rate | ||||||
| ACTIVITY | OVERHEAD COST | / | ACTIVITY | = | ACTIVITY RATE | |
| Utilities | $500,000.00 | / | 120000 | = | $4.17 | Per Machine hour |
| (95000+25000) | ||||||
| Qualty Control | $700,000.00 | / | 42000 | = | $16.67 | Per Inspection Hour |
| (35000+7000) | ||||||
| Computation of Profit - As per ABC-Executive Images Corporation | ||
| Plan | Hand Carved | |
| Revenue (a) | $4,800,000.00 | $4,400,000.00 |
| Total Cost | ||
| Direct Cost | $3,800,000.00 | $3,100,000.00 |
| Overhead Cost | $7,622.00 | $33,578.00 |
| Utilities | $396,150.00 | $104,250.00 |
| (95000*4.17) | (25000*4.17) | |
| Quality Control | $116,690.00 | $583,450.00 |
| (7000*16.67) | (35000*16.67) | |
| Total Cost (b) | $4,320,462.00 | $3,821,278.00 |
| Profit (c=a-b) | $479,538.00 | $578,722.00 |
| No. of Unit (d) | 120000 | 75000 |
| Profit per Unit (c/d) | $4.00 | $7.72 |
| Predetermined Overhead Rate = Estimated Overhead/ Machine Hour |
| (1200000/120000)=$10 per machine Hour |
| Computation of Profit - As per Tradition-Executive Images Corporation | ||
| Plan | Hand Carved | |
| Revenue (a) | $4,800,000.00 | $4,400,000.00 |
| Total Cost | ||
| Direct Cost | $3,800,000.00 | $3,100,000.00 |
| Overhead Cost | $950,000.00 | $250,000.00 |
| (95000*10) | (25000*10) | |
| Total Cost (b) | $4,750,000.00 | $3,350,000.00 |
| Profit (c=a-b) | $50,000.00 | $1,050,000.00 |
| No. of Unit (d) | 120000 | 75000 |
| Profit per Unit (c/d) | $0.42 | $14.00 |