Francisco E. answered 08/03/14
Tutor
5
(1)
Francisco; Civil Engineering, Math., Science, Spanish, Computers.
Minimize C=5x+4y given the constraints
0<=x<=6
0<=y<=6
4x+2y<=8
2x+y>=4
0<=x<=6
0<=y<=6
4x+2y<=8
2x+y>=4
I will do this by Solver, is easy and a modern way of solving this. Anyone knowing Excel knows the tool.
Objective Cell (Min)
Cell Name Original Value Final Value
$B$10 eq 10 10
Variable Cells
Cell Name Original Value Final Value Integer
$B$11 x 2 2 Contin
$B$12 y 0 0 Contin
The answer is: the minimum value of the equation is 10
Cell Name Original Value Final Value
$B$10 eq 10 10
Variable Cells
Cell Name Original Value Final Value Integer
$B$11 x 2 2 Contin
$B$12 y 0 0 Contin
The answer is: the minimum value of the equation is 10
To obtain this the values of the variables are:
x=2
Y=0
Satisfying the following Constraints:
Cell Name Cell Value Formula Status Slack
$B$13 8 $B$13<=8 Binding 0
$B$14 4 $B$14>=4 Binding 0
$B$11 x 2 $B$11<=6 Not Binding 4
$B$11 x 2 $B$11>=0 Not Binding 2
$B$12 y 0 $B$12<=6 Not Binding 6
$B$12 y 0 $B$12>=0 Binding 0
Cell Name Cell Value Formula Status Slack
$B$13 8 $B$13<=8 Binding 0
$B$14 4 $B$14>=4 Binding 0
$B$11 x 2 $B$11<=6 Not Binding 4
$B$11 x 2 $B$11>=0 Not Binding 2
$B$12 y 0 $B$12<=6 Not Binding 6
$B$12 y 0 $B$12>=0 Binding 0
Francisco E.
08/04/14