Solver Problem - Omis 6000 Assignment
Autor: JoJo Tongyang Zhou • November 10, 2015 • Exam • 640 Words (3 Pages) • 957 Views
OMIS 6000 Assignment #1
By
JoJo Tongyang Zhou (212445094)
Alexey Katsurbiy ( )
Diane Kouame
Mandana
Question 1
a.
We used Excel solver to solve this liner program. The result is pasted below.
Cell | Name | Original Value | Final Value | |
$H$3 | Value Min: X1+2X2 | 0 | 5 | |
Cell | Name | Original Value | Final Value | Integer |
$E$3 | Value X1 | 0 | 3 | Contin |
$F$3 | Value X2 | 0 | 1 | Contin |
The value of objective function is 5, when equals 3 and equals 1.[pic 1][pic 2]
b.
Cell | Name | Cell Value | Formula | Status | Slack |
$G$4 | X1+X4<=21 | 7 | $G$4<=21 | Not Binding | 14 |
$G$5 | 2X1+X2>=7 | 7 | $G$5>=7 | Binding | 0 |
$G$6 | 3X1+1.5X2<=21 | 10.5 | $G$6<=21 | Not Binding | 10.5 |
$G$7 | -2X1+6X2>=0 | 0 | $G$7>=0 | Binding | 0 |
As the chart listed above, the slacks for each constraint are 14, 0, 10.5 and 0.
c.
Cell | Name | Original Value | Final Value | |
$I$3 | Value Max: 5X1+2X2 | 0 | 34 | |
Cell | Name | Original Value | Final Value | Integer |
$E$3 | Value X1 | 0 | 6 | Contin |
$F$3 | Value X2 | 0 | 2 | Contin |
We created a new liner program with the new objective function Max . The optimal solution is when equals 6 and equals 2.[pic 3][pic 4][pic 5]
Question 2
Define the decision variable as follows:
number of units of component 1 from supplier 1[pic 6]
...