wa Module PExcel Chapter 4: Simulatix Excel Chapter 4 Hands-OX Pearson Sign in mir/takeAssignment/takeAssignment Main.do?invoker=&takeAssignmentSessionLocator&inprogress=false eBook Show Me How The total factory overhead for Bardot Marine Company is budgeted for the year at 1996,000, divided into two departments: Fabrication, $780,000, and Assembly $216,000. Bardot Marine manufactures two types of boats: speedboats and bass boats. The speedboats require one direct labor hour in Fabrication and two direct labor hours in Assembly. The bass boats require four direct labor hours in Fabrication and two direct labor hours in Assembly. Each product is budgeted for 8.000 units of production for the year. If required, round all per unit answers to the nearest cent. a. Determine the total number of budgeted direct labor hours for the year in each department Fabrication 40,000 direct labor hours Assembly 32,000 direct labor hours b. Determine the departmental factory overhead rates for both departments Fabrication 19.5 per dih Assembly 6.75 per din c. Determine the factory overhead allocated per unit for each product using the department factory overhead allocation rates. Speedboat 58.50 X per unit Bass boati 40.50 X per unit Freda Oat My W Calculate (a) For each department, multiply Number of Boat Type x Direct Labor Hours required. Add both bost hours together to obtain the total for the department (b) Total Overhead for each Department Hours calculated in Req: (a) - Departmental Rate (c) For each boat type determine the Overhead from each department by multiplying Direct Labor Hours x Rate determined in Req, (b). Then add together the overhead from both departments for each boat type to obtain overhead allocated per unit of product