ALGO Direct Labor Cost Budget ALGO Sea 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 follow ALGO ALGO Junior Pro Striker Production budget 7.100 units 5,200 units Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racket are 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.65 hours per unit The direct labor rate for each department is as follows: Forming Department $18.00 per hour 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. 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 Enemine met Ambient T Previous Next All work saved Emal structor Submit Test for Grading MUSEUILL 4.10 NOUPS per unit Pro Striker 0.35 hours per unit 0.65 hours per unit The direct labor rate for each department is as follows: Forming Department $18,00 per hour 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. THHH. Open spreadsheet Prepare the direct labor cost, budpet 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 > All work saved Emainstructor Submit Test for Grading