# 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**

## Managerial Decision Modeling Business Analytics With Spreadsheet

**ISBN:** 9781501515101

4th Edition

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