Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) |
Maximize Z | = | 2X + 4Y. | |
6X + 17Y | ? | 76 | Resource A |
2X + 3Y | ? | 20 | Resource B |
Y | ? | 18 | Resource C |
Decision for X | |
Decision for Y | |
Total profit | $ |
Resources Used | |
Resource A | |
Resource B | |
Resource C | |
Below is the LP Formulation -
Objective Function - Maximize Z = 2X+4Y
s.t. constraints -
6X+17Y <=76 --> Resource A
2X+3Y <=20 --> Resource B
Y<=18 --> Resource C
X,Y >=0
The maximum value is 22.
Below is the solver solution -
Get Answers For Free
Most questions answered within 1 hours.