How to do this using excel ?
can u explain step by step using the solver function inexcel
SOLVER EXCEL Quiz Turley Tailor Inc. makes shirts, Jackets, and coats. A shirt requires 1 hour of cutting and 5 hours of sewing. A jacket requires 2 hour of cutting and 4 hours of sewing. A coat requires 4 hours of cutting and 3 hours of sewing. There are a maximum of 148 hours of labor in the cutting department each day and 105 hours in the sewing department. The maximum number of coats that can be produced is two more than the number of shirts. Hourly labor rate for sewing is $2 and for cutting is $3. Each shirt price is $126, each jacket is $137, and each coat $257. Find the number of shirts, jacket, and coats to produce the maximum profit. What is this maximum profit? Show transcribed image text SOLVER EXCEL Quiz Turley Tailor Inc. makes shirts, Jackets, and coats. A shirt requires 1 hour of cutting and 5 hours of sewing. A jacket requires 2 hour of cutting and 4 hours of sewing. A coat requires 4 hours of cutting and 3 hours of sewing. There are a maximum of 148 hours of labor in the cutting department each day and 105 hours in the sewing department. The maximum number of coats that can be produced is two more than the number of shirts. Hourly labor rate for sewing is $2 and for cutting is $3. Each shirt price is $126, each jacket is $137, and each coat $257. Find the number of shirts, jacket, and coats to produce the maximum profit. What is this maximum profit?
Expert Answer
Answer to How to do this using excel ? can u explain step by step using the solver function in excel …