Answer to Question #232387 in Algorithms for Sonal

Question

Consider the following data:

Objective function to maximize: 300 X + 700 Y

Subject to Constraints:

150 X + 100 Y <= 2800

24 X <= 400

15Y <= 60

Find an optimal solution using:

Excel solver.

Corner point solution method.

Has to be solved using excel.

Answer 1

24X≤400 ~ X≤400/24=16 2/3 =16,667;

15Y≤60 ~ Y≤4;

150X+100Y≤2800 ~ 3X+2Y≤56;

300X+700Y->max ~ 3X+7Y->max;