Question: PLEASE ANSWER Please give a brief analysis of this sensitivity report in the form of a paragraph. Thank you. Variable Cells Final Value Reduced Cost

PLEASE ANSWER

PLEASE ANSWER Please give a brief analysis of this sensitivity report inthe form of a paragraph. Thank you. Variable Cells Final Value ReducedPlease give a brief analysis of this sensitivity report in the form of a paragraph. Thank you.

Variable Cells Final Value Reduced Cost Cell Name 0 $B$21 Regular 0 $C$21 Deluxe 30000 $D$21 Holiday 0 Objective Coefficient 0,609 0,922 1,143 Allowable Allowable Increase Decrease 0,0825 0,148 0,296 0,0076 0,0095 1,0E+30 0 -0,0095 Constraints Final Value Shadow Price Cell Name 2,96 0 $E$23 Almond $E$24 Brazil $E$25 Filbert $E$26 Pecan $E$27 Walnut 6000 6000 6000 6000 6000 Constraint Allowable Allowable R.H. Side Increase Decrease 6000 500 7500 1,0E+30 1500 7500 1,0E+30 1500 6000 0 750 7500 1,0E+30 1500 0 1,65 0 Objective Cell (Max) Cell Name Final Value Original Value 26807 $E$22 Obj. 27660 Variable Cells Cell Name Original Value 10.000 $B$21 Regular $C$21 Deluxe $D$21 Holiday Final Value Integer O Contin 30000 Contin O Contin 18750 3000 Constraints Cell Name Status Slack 0 1500 $E$23 Almond $E$24 Brazil $E$25 Filbert $E$26 Pecan $E$27 Walnut Cell Value Formula 6000 $E$23

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 Finance Questions!