Acrobat Pro DC (32-bit) elp ment 2 Acco... x 1 Microsoft Excel File Edit View Insert Format Tools Data Window Help BIURE 75% 4 4 $ %1 Euro H10 fx A B D E F Demand Selling Next Year Price per Direct Direct 1 Product (units) Unit Materials Labor 2 Debbie 50,000 $13.50 $4.30 $3.20 3 Trish 4 Sarah 42,000 $5.50 $1.10 $2.00 35,000 $21.00 $6.44 $5.60 5 Mike 40,000 $10.00 $2.00 $4.00 6 Sewing kit 325,000 $8.00 $3.20 $1.60 7 KSheet1 Sheet2 Sheet3/ The following additional information is available: a. The company's plant has a capacity of 130,000 direct labor-hours per year on a single-shift basis. The company's present employees and equipment can produce all five products. b. The direct labor rate of $8 per hour is expected to remain unchanged during the coming year. c. Fixed costs total $520,000 per year. Variable overhead costs are $2 per direct labor-hour. d. All of the company's nonmanufacturing costs are fixed. Required: 1. Determine the contribution margin per direct labor-hour expended on each product (Note: Unit contribution margin selling price per unit variable expenses per unit (both variable manufacturing and non-manufacturing costs)). 2. Prepare a schedule showing the optimum production plan for next year. 3. Assume again that the company does not want to reduce sales of any product. Identify ways in which the company could obtain the additional output. IA ASUS ZenBook