Essay About Diane Kouamemandana Question 1A.We And Solver Problem

Solver Problem – Omis 6000 Assignment
OMIS 6000 Assignment #1ByJoJo Tongyang Zhou (212445094)Alexey Katsurbiy ( )Diane KouameMandana Question 1a.We used Excel solver to solve this liner program. The result is pasted below.CellNameOriginal ValueFinal Value$H$3Value Min: X1+2X205CellNameOriginal ValueFinal ValueInteger$E$3Value X103Contin$F$3Value X201ContinThe value of objective function is 5, when equals 3 and  equals 1.[pic 1][pic 2]b.CellNameCell ValueFormulaStatusSlack$G$4X1+X4<=217$G$4<=21Not Binding14$G$52X1+X2>=77$G$5>=7Binding0$G$63X1+1.5X2<=2110.5$G$6<=21Not Binding10.5$G$7-2X1+6X2>=00$G$7>=0Binding0As the chart listed above, the slacks for each constraint are 14, 0, 10.5 and 0.c.CellNameOriginal ValueFinal Value$I$3Value Max: 5X1+2X2034CellNameOriginal ValueFinal ValueInteger$E$3Value X106Contin$F$3Value X202ContinWe 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 2Define the decision variable as follows:number of units of component 1 from supplier 1[pic 6]