In: Accounting
Sultan Company uses an activity-based costing system.
At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools:
Activity Cost Pool | Activity Measure | Expected Overhead Cost |
Expected Activity | ||||
Labor-related | Direct labor-hours | $ | 317,600 | 39,700 | DLHs | ||
Purchase orders | Number of orders | $ | 9,900 | 220 | orders | ||
Parts management | Number of part types | $ | 67,890 | 93 | part types | ||
Board etching | Number of boards | $ | 76,000 | 1,900 | boards | ||
General factory | Machine-hours | $ | 237,600 | 21,600 | MHs | ||
Required:
1. Compute the activity rate for each of the activity cost pools.
2. The expected activity for the year was distributed among the company’s four products as follows:
Expected Activity | ||||||||||||
Activity Cost Pool | Product A | Product B | Product C | Product D | ||||||||
Labor-related (DLHs) | 6,300 | 23,700 | 4,600 | 5,100 | ||||||||
Purchase orders (orders) | 70 | 27 | 40 | 83 | ||||||||
Parts management (part types) | 28 | 13 | 32 | 20 | ||||||||
Board etching (boards) | 580 | 700 | 620 | 0 | ||||||||
General factory (MHs) | 3,900 | 8,900 | 3,500 | 5,300 | ||||||||
Using the ABC data, determine the total amount of overhead cost assigned to each product.
1. Compute the activity rate for each of the activity cost pools.
Activity Cost Pool | Activity Rate | |
Labor-related | per DLH | |
Purchase Orders | per order | |
Parts Management | per part type | |
Board etching | per board | |
General Factory | per MH |
2. Using the ABC data, determine the total amount of overhead cost assigned to each product.
Overhead Cost Assigned | ||||
Activity Cost Pool | Product A | Product B | Product C | Product D |
Labor-related (DLHs) | ||||
Purchase Orders (orders) | ||||
Parts Management (part types) | ||||
Board Etching (boards) | ||||
General Factory (MHs) | ||||
Total |
1. Activity rate for each of the activity cost pools [Refer working note 1]
Activity Cost Pools | Activity Rate | |
Labor-related | $8 | per DLH |
Purchase orders | $45 | per order |
Parts management | $730 | per part type |
Board etching | $40 | per board |
General factory | $11 | per MH |
.
.
2. Total amount of overhead cost assigned to each product
Activity Cost Pool |
Product A [Refer working note 2] |
Product B [Refer working note 3] |
Product C [Refer working note 4] |
Product D [Refer working note 5] |
Labor-related (DLHs) | $50,400 | $189,600 | $36,800 | $40,800 |
Purchase orders (orders) | $3,150 | $1,215 | $1,800 | $3,735 |
Parts management (part types) | $20,440 | $9,490 | $23,360 | $14,600 |
Board etching (boards) | $23,200 | $28,000 | $24,800 | $0 |
General factory (MHs) | $42,900 | $97,900 | $38,500 | $58,300 |
.
.
.
.
.
..
.