Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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$23Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started