answer these using information given

3. A) Calculate the range of optimality for the unit profit of both X1 and X2 in the objective function.

B) explain what the range of optimality for the unit profit of X1 means to the business.

C) Calculate the range of feasibility for each of the resources (constraints).

D)explain what the range of feasibility for plastic means to the business

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