Question

1. 2-13 Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit = 2X + Y subject to the constraints 3X + 6Y ? 32 7X + Y ? 20 3X - Y ? 3 X, Y ? 0

          1. 2-13
Solve the following LP problem by using the graphical procedure
and by using Excel:
Maximize profit = 2X + Y
subject to the constraints
3X + 6Y ? 32
7X + Y ? 20
3X - Y ? 3
X, Y ? 0

Added by Jaime F.

Elementary and Intermediate Algebra

Alan S. Tussy, R. David Gustafson 5th Edition

Instant Answer

Solved by Expert Sri K

02/11/2023

Step 1

To set up the LP problem in Excel, we need to create a spreadsheet with the following columns: X, Y, Objective Function, Constraint 1, Constraint 2, Constraint 3, and Constraint 4. In the X column, enter the values for X (32, 20, 3, 0). In the Y column, enter Show more…

Show all steps

Thanks for your feedback!

please assist show steps in excel 1.2-13 Solve the following LP problem by using the graphical procedure and by using Excel Maximize profit=2X+Y subject to the constraints 3X+6Y 7X+Y 3X-Y X,Y 32 20 3 0