In excel please 6. Tucker, Inc., produces high-quality suits and sport coats for men. Each suit requires1.2 hours of cutting time and 0.7 hours of sewing time, uses 6 yards of material, and pro-vides a profit contribution of $190. Each sport coat requires 0.8 hours of cutting time and0.6 hours of sewing time, uses 4 yards of material, and provides a profit contribution of$150. For the coming week, 200 hours of cutting time, 180 hours of sewing time, and1200 yards of fabric are available. Additional cutting and sewing time can be obtainedby scheduling overtime for these operations. Each hour of overtime for the cutting opera-tion increases the hourly cost by $15, and each hour of overtime for the sewing operationincreases the hourly cost by $10. A maximum of 100 hours of overtime can be scheduled.Marketing requirements specify a minimum production of 100 suits and 75 sport coats. LetS = number of suits producednumber of sport coats producedDI = hours of overtime for the cutting operation%3DSC%3DD2 = hours of overtime for the sewing operation%3DThe computer solution is shown in Figure 3.19.a. What is the optimal solution, and what is the total profit? What is the plan for the useof overtime?

Name: In excel please 6. Tucker, Inc., produces high-quality suits and sport
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: In excel please 6. Tucker, Inc., produces high-quality suits and sport coats for men. Each suit requires1.2 hours of cutting time and 0.7 hours of sewing time, uses 6 yards of material, and pro-vides a profit contribution of $190. Each sport coat req