AllFreePapers.com - All Free Papers and Essays for All Students
Search

Solver Problem - Omis 6000 Assignment

Autor:   •  November 10, 2015  •  Exam  •  640 Words (3 Pages)  •  947 Views

Page 1 of 3

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]

...

Download as:   txt (5.5 Kb)   pdf (314.1 Kb)   docx (183.5 Kb)  
Continue for 2 more pages »