X PB WIX WIX WIX WIX Q + C https://v2.cengagenow.com/ilrn/takeAssi... A> Q FINAL EXAM Direct Labor Cost Budget 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 follows: Junior Pro Striker Production budget 9,100 units 4,800 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.25 hours per unit 0.60 hours per unit Pro Striker 0.35 hours per unit 0.70 hours per unit The direct labor rate for each department is as follows: Forming Department $20.00 per hour Assembly Department $13.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 1 60 F Mostly cloudy Search - 8 0 1 62 4 O F1 4X F2 4' F3 (4') FA DI F5 PrisonFE Home End F10 PgUP FI Pgon F17 @ #F % W N 4 6 8 O Q W E R T Y U O P A S D F G H K Z X B N MX PB WIX WIX WIX WIX https://v2.cengagenow.com/ilrn/takeAssi.. A Q 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 Time Remaining: 2:25:44 Email Instructor Submit Test for Grading 1 60"F Search - 8 0 1 604 Mostly cloudy X F2 4' F3 (') F4 DII FS Prison Home PgUP FI PgDO F1Z ESC End Fi F1 @ # % V 4 15 6 8 O N P W E R T Y U O S D F G H K " . . . Z X B N M