In: Operations Management
L.P.? Model: Minimize Z equals = 15 15X plus + 15 15Y Subject? to: 7 7X plus + 11 11Y greater than or equals ? 88 88 ?(C1?) 16 16X plus + 4 4Y greater than or equals ? 64 64 ?(C2?) ?X,Y greater than or equals ?0 On the graph on? right, constraints C1 and C2 have been drawn.?? Using the point drawing tool?, plot all the corner points for the feasible area. The optimum solution? is: X? = nothing ?(round your response to two decimal? places). Y? = nothing ?(round your response to two decimal? places).
1. Firstly, we set all the required conditions in excel as below:
2. Then we use the excel add in SOLVER and set all the conditions as required
3. After setting in all the conditions, we get the solver output
4. The Final Output :
Z = 132.9
with X = 2.4 & y = 6.5