Question: Solve the following two problems using EXCEL Solver and turn in the final printouts and Answer and Sensitivity Reports 1. Maximize Z = 6X1 +

Solve the following two problems using EXCEL Solver and turn in the final printouts and Answer and Sensitivity Reports

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

Subject to 2X1 + 5X2 + 7X3 <= 300

3X1 + 6X2 + 8 X3 <= 450

5X1 + 8 X2 + 3 X3 <= 500

X1 >= 0

X2 >= 0

X3 >= 0

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

Subject to X1 + 3X2 + 6X3 >= 400

2X1 + 6X2 + 4X3 >= 350

2X1 + 8 X2 + 5 X3 >= 200

X1 >= 0

X2 >= 0

X3 >= 0

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!