In: Accounting
total factory overhead for Bardot Marine Company is budgeted for the year at $778,050, divided into four activities: fabrication, $357,000; assembly, $147,000; setup, $148,050; and inspection, $126,000. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows:
Fabrication | Assembly | Setup | Inspection | |||||
Speedboat | 5,250 | dlh | 15,750 | dlh | 38 | setups | 66 | inspections |
Bass boat | 15,750 | 5,250 | 277 | 459 | ||||
21,000 | dlh | 21,000 | dlh | 315 | setups | 525 | inspections |
Each product is budgeted for 3,500 units of production for the year.
a. Determine the activity rates for each activity.
Fabrication | $ per direct labor hour |
Assembly | $ per direct labor hour |
Setup | $ per setup |
Inspection | $ per inspection |
b. Determine the activity-based factory overhead per unit for each product. Round to the nearest whole dollar.
Speedboat | $ per unit |
Bass boat | $ per unit |
Fabrication | 357,000.0 | Fabrication | Assembly | Setup | Inspection | ||||||
Assembly | 147,000.0 | Activity Base | DLH | DLH | Setups | Inspections | |||||
Setup | 148,050.0 | Speedboat | 5,250.0 | 15,750.0 | 38.0 | 66.0 | |||||
Inspection | 126,000.0 | Bass boat | 15,750.0 | 5,250.0 | 277.0 | 459.0 | |||||
Budgeted Total Overhead | 778,050.0 | Total Allocation | 21,000.0 | 21,000.0 | 315.0 | 525.0 | |||||
A | A | B | A/B | ||||||||
Budgeted OH | Activity Base | Activity Rate | |||||||||
Fabrication | 357,000.0 | 21,000.0 | 17.00 | Per DLH | |||||||
Assembly | 147,000.0 | 21,000.0 | 7.00 | Per DLH | |||||||
Setup | 148,050.0 | 315.0 | 470.00 | Per Setups | |||||||
Inspection | 126,000.0 | 525.0 | 240.00 | Per Inspection | |||||||
B | Allocation to Products: | Activity Usage | Allocation (Activity Usage*Activity Rate) | ||||||||
Activity Rate | Speedboat | Bass boat | Speedboat | Bass boat | |||||||
Fabrication | 17.0 | 5,250.0 | 15,750.0 | 89,250.0 | 267,750.0 | ||||||
Assembly | 7.0 | 15,750.0 | 5,250.0 | 110,250.0 | 36,750.0 | ||||||
Setup | 470.0 | 38.0 | 277.0 | 17,860.0 | 130,190.0 | ||||||
Inspection | 240.0 | 66.0 | 459.0 | 15,840.0 | 110,160.0 | ||||||
Total Overhead | 233,200.0 | 544,850.0 | |||||||||
Units | 3,500.00 | 3,500.00 | |||||||||
OH PU | 67 | 156 | |||||||||