I need the Assembly Department and Total

Assembly Department

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 racket is as follows: Junior Pro Striker Production budget 8,800 units 5,300 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.60 hours per unit 0.35 hours per unit The direct labor rate for each department is as follows: Pro Striker 0.60 hours per unit Forming Department $25.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. 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 1,760 Pro Striker 1.855 Total 3,615 Hourly rate 25 Total direct labor cost 90,375