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
Get step-by-step solutions from verified subject matter experts
