Question: I did this problem and am not good at interpreting the sensitivity report. Could you give a detailed explanation of what the information is saying,

I did this problem and am not good at

I did this problem and am not good at interpreting the sensitivity report. Could you give a detailed explanation of what the information is saying, please?

Final Value 32.5 85.5 50 0 68 20 0 32 40 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 0 60 3.33333333 2.33333333 0 75 5 10 0 45 1.75 2.5 3.75 60 1E+30 3.75 0 10 3.33333333 2.1875 0 10 1.75 2.5 3.33333333 60 1E+30 3.33333333 0 75 2.1875 1E+30 0 45 2.5 1E+30 1.75 60 1E+30 1.75 20 10 1E+30 20 20 10 1E+30 20 0 60 5 0 75 5 15 0 45 3.75 1E+30 3.75 60 1E+30 3.75 17 0 0 0 15 5 6 Variable Cells 7 8 Cell Name 9 $B$14 Reel PG1 10 $C$14 Reel PN1 11 $D$14 Reel TG1 12 $E$14 Reel TN1 13 $F$14 Reel Pli 14 $G$14 Reel TI1 15 $H$14 Reel PG2 16 $I$14 Reel PN2 $J$14 Reel TG2 18 $K$14 Reel TN2 19 $L$14 Reel P12 20 $M$14 Reel T12 21 $N$14 Reel PG3 22 $0$14 Reel PN3 23 $P$14 Reel TG3 24 $Q$14 Reel TN3 25 26 Constraints 27 28 Cell Name 29 $R$22 June - G1 LHS 30 $R$23 July - N1 LHS 31 $R$24 August - G2 LHS 32 $R$25 June - N2 LHS 33 $R$26 July - G3 LHS 34 $R$27 August - N3 LHS 35 $R$28 Demand - P1 LHS 36 $R$29 Demand - T1 LHS 37 $R$30 Demand - P2 LHS 38 $R$31 Demand - T2 LHS 39 $R$32 Demand - P3 LHS $R$33 Demand - T3 LHS 37.5 12.5 50 0 Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 140 -7.5 140 171 29 213.8 0 250 1E+30 36.25 60 -14.1666667 60 30 29 80 -4 80 170 36.25 150 -7.5 150 25 55 31.25 0 100 1E+30 68.75 50 75 50 14.5 85.5 30 56.25 30 19.3333333 50 100 85 100 14.5 68 60 66.25 60 19.3333333 50 75 50 27.5 12.5 50 56.25 50 36.6666667 16.6666667 20 40

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!