Question: Solve the following two problems using EXCEL Solver and turn in the final printouts and Answer and Sensitivity Reports along with this sheet. 1. Maximize

Solve the following two problems using EXCEL Solver and turn in the final printouts and Answer and Sensitivity Reports along with this sheet.

1.Maximize Z = 3X1 + 4X2 + 5 X3

Subject to2X1 + 5X2 + 7X3 <= 300

3X1 + 6X2 + 8 X3 <= 450

5X1 + 8 X2 + 3 X3 <= 550

X1 >= 0

X2 >= 0

X3 >= 0

2.Minimize Z = 4X1 + 2X2 + 2X3

Subject toX1 + 3X2 + 6X3 >= 400

2X1 + 6X2 + 4X3 >= 350

2X1 + 8 X2 + 5 X3 >= 250

X1 >= 0

X2 >= 0

X3 >= 0

please get the numbers right its 300, 450, and (550) for question 1

400, 350, and (250) for question 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!