#2) Solve the following LP by using Excel. State the Optimal Solution and the Objective Function Value.

Maximize profit = 6X + 5Y

Subject to: 4X + 2Y 40

3X + 5Y 30

X 7

2X - Y 4

X, Y 0

#3) Solve the following LP by using Excel. State the Optimal Solution and the Objective Function Value.

Minimize cost = 6X + 5Y

Subject to: 5X + 3Y 40

4X + 5Y 36

X - Y 0

2X 6

X, Y 0

#4) Solve the following LP by using Excel. State the Optimal Solution and the Objective Function Value.

Maximize profit = 910X + 1000Y

Subject to: 18X + 20Y 1,200

360X + 400Y 30,000

X, Y 0

#5) Solve the following LP by using Excel. State the Optimal Solution and the Objective Function Value.

Maximize profit = 90A + 85B

Subject to: 125A + 100B 24,500

25A + 30B 6,000

A - 5B 0

A, B 0