# (Solved) : Using Excel U Explain Step Step Using Solver Function Excel Q42720239 . . .

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?

Answer to How to do this using excel ? can u explain step by step using the solver function in excel …

We are the best freelance writing portal. Looking for online writing, editing or proofreading jobs? We have plenty of writing assignments to handle.