The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of concentrate each week. The company has just received orders of 10 tons from Miami for the coming week, 15 tons for Orlando, and 10 tons for Tallahassee. The cost per ton for supplying each of the distributors from each of the processing plants is shown in the following table.

Miami

Orlando

Tallahassee

Eustis

$260

$220

$290

Clemont

$230

$240

$310

The model has been done and after solving the problem, sensitivity analysis is given in below table:

Adjustable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

$C$10

Eustis Miami

0

50

260

1E+30

50

$D$10

Eustis Orlando

10

0

220

20

0

$E$10

Eustis Tallahassee

10

0

290

0

310

$C$11

Clermont Miami

10

0

230

50

230

$D$11

Clermont Orlando

5

0

240

0

20

$E$11

Clermont Tallahassee

0

0

310

1E+30

0

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

$C$12

Shipped Miami

10

230

10

5

10

$D$12

Shipped Orlando

15

240

15

5

5

$E$12

Shipped Tallahassee

10

310

10

5

5

$F$10

Eustis Used

20

-20

20

5

5

$F$11

Clermont Used

15

0

20

1E+30

5

Assessment Tasks:

Considering sensitivity analysis table answer all 5 questions below.

1.If the objective function for Eustis Miami decreases by 10 points what would be the impact on the optimal solution? (6 marks)

2.Which constraints are binding? Why?(6 marks)

3.Should the company increase shipped Tallahassee? If so what would be the impact on the optimal solution?(6 marks)

4.If the company increased Eustis used R.H. side by 1 unit, what would be the impact on the optimal solution?(6 marks)

5.Is the company able to increase shipped Miami more than 5 units to maximise the profit?(6 marks)