In: Accounting
Calculating Activity-Based Costing Overhead Rates
1. Calculate the cost per unit of activity driver for
each activity cost category.
Setup $_____
Production scheduling $______
Production engineering $______
Supervision $_______
Machine maintenance $______
2. Calculate the cost of Job 845 using ABC to assign the overhead costs.
$______
3. Calculate the cost of Job 845 using the plantwide
overhead rate based on machine hours. (Round your answer to the
nearest dollar.)
$_____
A food company had the following activities and costs:
| Setup (1,000 setup hours) | $118,000 | 
| Production scheduling (400 batches) | 60,000 | 
| Production engineering (60 change orders) | 150,000 | 
| Supervision (2,000 direct labor hours) | 46,000 | 
| Machine maintenance (12,000 machine hours) | 60,000 | 
| Total activity costs | $434,000 | 
The following additional data were provided for Job 845:
| Direct materials costs | $7,000 | 
| Direct labor cost (5 Milling direct labor hours; 35 Finishing direct labor hours)  | 
$1,000 | 
| Setup hours | 5 hours | 
| Production scheduling | 1 batch | 
| Machine hours used (25 Milling machine hours; 5 Finishing machine hours)  | 
30 hours | 
| Production engineering | 3 change orders | 
1. Calculate the cost per unit of activity driver for each activity cost category.
| Setup (118000/1000) | 118 per setup | 
| Production scheduling (60000/400) | 150 per batch | 
| Production engineering (150000/60) | 2500 per change order | 
| Supervision (46000/2000) | 23 per direct labour hour | 
| Machine maintenance (60000/12000) | 5 per machine hour | 
2. Calculate the cost of Job 845 using ABC to assign the overhead costs.
| Direct material cost | 7000 | 
| Direct labour cost | 1000 | 
| Setup cost (118*5) | 590 | 
| Production scheduling (150*1) | 150 | 
| Production scheduling (2500*3) | 7500 | 
| Supervision (23*40) | 920 | 
| Machine maintenance (5*30) | 150 | 
| Total job cost | 17310 | 
3. Calculate the cost of Job 845 using the plantwide overhead rate based on machine hours. (Round your answer to the nearest dollar.)
Overhead rate = 434000/12000 = 36.167 per machine hour
| Direct material | 7000 | 
| Direct labour | 1000 | 
| Overhead cost | 1085 | 
| Total job cost | 9085 |