answer question 7 a-e using the given information

7.

A) If the unit profit of X₂ increased from 5 to 7, can you tell what will be the optimal solution for X₁ and X₂ and

calculate the optimal value of the objective function (P*)?

Yes ( ) No ( )

If yes, X₁^* = ( ), X₂^* = ( ), P* = ( )

B) If the unit profit of X₁ decreased from 7 to 6 and the unit profit of X₂ increased from 5 to 6 at the same time,

can you tell what will be the optimal solution for X₁ and X₂ and calculate the optimal value of the objective

function (P*)?

Yes ( ) No ( )

If yes, X₁^* = ( ), X₂^* = ( ), P* = ( )

C) If the available production time decreased from 2200 units to 2100, can you tell what will be the

optimal solution for X₁ and X₂? Can you tell what will be the optimal value of the objective function?

Optimal solution for X₁ and X₂? Optimal value of the objective function?

Yes ( ) No ( ) Yes ( ) No ( )

If yes, X₁^* = ( ), X₂^* = ( ) If yes, P* = ( )

D) If the available plastic increased from 1200 to 1250 units and the available production time decreased

from 2200 to 2150 units, can you tell what will be the optimal solution for X₁ and X₂? Can you tell what will

be the optimal value of the objective function?

Optimal solution for X₁ and X₂? Optimal value of the objective function?

Yes ( ) No ( ) Yes ( ) No ( )

If yes, X₁^* = ( ), X₂^* = ( ) If yes, P* = ( )

e) If the available plastic increased from 1200 to 1210 units and the available total increased

from 800 to 1000, can you tell what will be the optimal solution for X₁ and X₂? Can you tell what will

be the optimal value of the objective function?

Optimal solution for X₁ and X₂? Optimal value of the objective function?

Yes ( ) No ( ) Yes ( ) No ( )

If yes, X₁^* = ( ), X₂^* = ( ) If yes, P* = (

Microsoft Excel Answer Report Target Cell (Max) Cell Name Final Value Original Value 51 $D$6 Profit Total (A??) Adjustable Cells Cell Name Final Value $B$5 Quant X1 $C$5 Quant X2 Original Value 3 (B ??) 520 160 Constraints Cell Name $D$8 Plastic Total $D$9 Time Total $D$1 Total Total Cell Value Formula Status Slack 1200 SD$8=0 Not Binding 160 $C$5>=0 Not Binding $B$5 Quant X1 520 $C$5 Quant X2 160 Microsoft Excel Sensitivity Report Worksheet: [LPGalaxy.xls]Sheet1 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Quantity X15200 3 3.25 $C$5 Quantity X2 1 60 5 4 .3 1.5 Constraints Cell Name $D$8 Plastic $D$9 Production Time $D$1 Total Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 1200 2.6 1200 64 (F ??) 0.6 2200 600 150 680 360 0 0 8001E+30 4501E+30 120 90 $D$1 Mix