In: Accounting
Hamilton Manufacturing Company | ||
Direct materials | 175,000 | |
Materials handling | 35,000 | |
Grinding | 300,000 | |
Polishing | 100,000 | |
Product Modification | 500,000 | |
Providing Power | 225,000 | |
System Calibration | 400,000 | |
Machine Hours | 37,500 | units |
Direct Labor Hours | 15,000 | |
Engineering hours | 1,200 | |
Batches | 200 | |
Materials handling based on direct material cost | ||
Grinding based on machine hours | ||
Polishing based on machine hours | ||
Product Modification based on engineering hours | ||
Providing Power based on direct labor hours | ||
System Calibration based on batches | ||
Job 231 | ||
Completed | 1,675 | units |
Direct Materials | 18,500 | |
Direct labor hours | 350 | |
Machine hours | 755 | |
Engineering hours | 245 | |
Batches | 35 | |
Using the ABC Method find the activity overhead rates. | ||
Once you have those activity rates find the total cost of Job 231 including materials and the cost per unit |
A. Computation of activity overhead rates :- | ||||||
Activity cost pool | Activity measures (Cost Drivers) | Estimated Overhead Cost | Expected Activity | Activity rate | ||
Total | ||||||
a | b | c | f | g = c/f | ||
Materials handling | Direct material cost | $ 35,000 | 175,000 | $ 0.20 | $ of Direct material cost | |
Grinding | Machine hours | $ 300,000 | 37,500 | $ 8.00 | per machine hour | |
Polishing | Machine hours | $ 100,000 | 37,500 | $ 2.67 | per machine hour | |
Product Modification | Engineering hours | $ 500,000 | 1,200 | $ 416.67 | per Engineering hour | |
Providing Power | Direct labor hours | $ 225,000 | 15,000 | $ 15.00 | per Direct labor hour | |
System Calibration | Batches | $ 400,000 | 200 | $ 2,000.00 | per batch | |
Total Cost | $ 1,560,000 | |||||
B. Computation of the total cost of Job 231 including materials and the cost per unit:- | ||||||
Overhead Assigned | Activity Driver | Activity rate | Total Overhead Cost | |||
a | b | c | d = b×c | |||
Job 231 | ||||||
Materials handling | 18,500 | Direct material cost | $ 0.20 | $ 3,700 | ||
Grinding | 755 | Machine hours | $ 8.00 | $ 6,040 | ||
Polishing | 755 | Machine hours | $ 2.67 | $ 2,013 | ||
Product Modification | 245 | Engineering hours | $ 416.67 | $ 102,083 | ||
Providing Power | 350 | Direct labor hours | $ 15.00 | $ 5,250 | ||
System Calibration | 35 | Batches | $ 2,000.00 | $ 70,000 | ||
Total | $ 189,087 | |||||
Job 231 | ||||||
No. of units completed | 1675 | |||||
Total | Per Unit | |||||
Direct Material Cost | $ 18,500 | $ 11.04 | ||||
Overhead Cost | $ 189,087 | $ 112.89 | ||||
Total Cost | $ 207,587 | $ 123.93 |
Feel free to ask any clarification, if required. Please provide feedback by thumbs up, if satisfied. It will be highly appreciated. Thank you.