Question: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Type A x 4 0 5 4 2 Type B y

Variable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

Type A

x

4

0

5

4

2

Type B

y

0

-3.5

3

2

1E+30

Type C

z

3

0

5

6

2

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

Hours

1

15

1

15

12

8

Plastic

2

20

0

30

1E+30

30

Cotton

3

70

2

70

40

55

Calculate the optimal value of the objective function if the coefficient of "x" changes to 4 and the coefficient of "y" changes to 3.5.

Hint: Since it is proposing a simultaneous change (more than one change at a time), we have to check the 100% rule.

**Enter the number only**

**Do not use any words or symbols**

2.

Variable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

Type A

x

9

0

6

4

2

Type B

y

0

-3.5

3

2

1E+30

Type C

z

3

0

6

6

2

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

Hours

1

15

1

15

12

8

Plastic

2

20

0

30

1E+30

30

Cotton

3

70

2

70

40

55

How much will the objective function improve if we add the Cotton amount by 30 more and 50 more units?

Select one:

a. We will not be able to tell since the proposed changes are outside the allowable increase or decrease

b. Up to $40 increase or $55 decrease when the changes are in the allowable ranges, but we cannot tell the exact amount of improvement.

c. Not able to say for 30 units increase, but $100 improvement for 50 units increase

d. $60 improvement for 30 units increase, not able to tell for 50 units increase

3.

Variable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

Type A

x

9

0

6

4

2

Type B

y

0

-3.5

3

2

1E+30

Type C

z

3

0

6

6

2

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

Hours

1

15

1

15

12

8

Plastic

2

20

0

30

1E+30

30

Cotton

3

70

2

70

40

55

What constraints are binding?

Select one:

a. Cotton and Hours are binding

b. Plastic is the only binding constraint

c. Type A and type C are binding

d. Cotton and Plastic are binding

e. Type B is binding

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!