Question: A sensitivity report has been provided below, outlining a problem-solving scenario. Please answer the question posed to you based on this sensitivity report. Variable Cells
A sensitivity report has been provided below, outlining a problem-solving scenario. Please answer the question posed to you based on this sensitivity report.
| Variable Cells | ||||||
| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $E$2 | Product I | 28 | 0 | 38 | 7,3 | 1E+30 |
| $E$3 | Product II | 38 | 0 | 44 | 15,9 | 73 |
| $E$4 | Product III | 60 | 0 | 82 | 1E+30 | 24,5 |
| Constraints | ||||||
| Cell | Name | Final Value | Shadow Price | Constraint R.H. Side | Allowable Increase | Allowable Decrease |
| $B$6 | Constraint I | 276 | 0,3571 | 276 | 42 | 119,1 |
| $C$6 | Constraint II | 38,3 | 0 | 7 | 37 | 1E+30 |
| $D$6 | Constraint III | 50 | 1,7857 | 50 | 10,5 | 3,63 |
| $D$8 | Constraint IV | 7,5 | 0 | 3,7 | 1E+30 | 0,13 |
| $E$5 | Constraint V | 1 | 4,5714 | 1 | 0,3 | 0,04 |
What is the result of the calculation according to the 100 percent rule when the Objective Coefficient of Product II and Product III is modified as 49,2 and 81,7, respectively?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help