Question

Consider the following linear programming problem.

Maximize        6X1 + 4X2

Subject to:

                        X1 + 2X2 ≤ 16

                        3X1 + 2X2 ≤ 24

                        X1  ≥ 2

                        X1, X2 ≥ 0

Use Excel Solver to find the optimal values of X1 and X2. In other words, your decision variables:

	a.	(10, 0)
	b.	(12, 2)
	c.	(7, 5)
	d.	(0, 10)

Answer 1

Putting the Equation in Excel:

Solver Parameters:

Optimal Solution:

Answer is: X1 = 8; X2 = 0

Given options, none of them are correct.

None of the options get fit with constraint 3X1 + 2X2 <= 24

For a (10,0): 30 is not less than 24

For b (12,2): 36 is not less than 24

For c (7,5): 31 is not less than 24

For d (0, 10): Constraint X1 + 2X2 <= 16 doesn’t fit as 20 is not less than 16

Hence answer should be none of the given options.

********

IF YOU HAVE ANY DOUBT, KINDLY COMMENT. I WOULD LOVE TO HELP YOU!!!

IF YOU LIKE THE ANSWER, PLEASE GIVE AN UP-VOTE OR THUMB UP. THIS WILL ENCOURAGE ME TO ANSWER MORE!!