Direct Labor Cost Budget sen Pines Company manufactures two types of tennis rackets, the Junior and Pro Striker models. The production budget for March for the two rackets is as follows: Junior Pro Striker Production budget 7,100 units 5.000 units Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racketare estimated as follows: Forming Department Assembly Department Junior 0:20 hours per unit 0.40 hours per unit Pro Striker 0.35 hours per unit 0.75 hours per unit The direct inborrate for each department is as follows $22.00 per hour Forming Department Assembly Department $10.00 per hour This information has been collected in the Microsoft Excel Online file. Open the spreadsheet perform the required analysis, and input your answers in the question below. 10 X Open spreadsheet Prepare the direct labor cost budget for March. Round your answers for an hourly rate to two decimal places, Enter all amounts as positive numbers, SEA PINES COMPANY Direct Labor Cost Budget For the Month Ending March 31 Forming Department Assembly Department Total Hours required for production CURSOS Forming Department 0.20 hours per unit Assembly Department 0.40 hours per unit Junior Pro Striker 0.35 hours per unit 0.75 hours per unit The direct labor rate for each department is as follower Forming Department $22.00 per hour Assembly Department $10.00 per hour The information has been collected in the Microsoft Excel Ontinel Open the spreadsheet, perform the required analysis, and input your answers in the question below X THI Open spreadsheet Prepare the direct labor cost budget for March. Round your answers for an hourly rate to two decimal places. Enter all amounts as positive numbers. SEA PINES COMPANY Direct Labor Cost Budget For the Month Ending March 31 Forming Department Assembly Department Total Hours required for production Junior Pro Striker Total Hourly rate Total direct labor cost Previous Next