Consider the linear programming formulation below. Maximize profit = 50X + 42Y subject to the constraints 5X

Question:

Consider the linear programming formulation below.

Maximize profit = 50X + 42Y

subject to the constraints


5X − 4Y ≤ 200
X ≤ 60
Y ≥ 10
X, Y ≥ 0


(a) Try to solve the problem in Excel. What error message do you get?

(b) Add a single constraint that would eliminate the error message. What constraint did you add, and what is the value of the optimal solution?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling Business Analytics With Spreadsheet

ISBN: 9781501515101

4th Edition

Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson

Question Posted: