Could anyone put the answer in bold and briefly explain? Thank you so much!! Sup
ID: 3227708 • Letter: C
Question
Could anyone put the answer in bold and briefly explain? Thank you so much!! Suppose a spreadsheet has the following sensitivity report: variable cells Final Reduced Objective Allowable Cell Name Allowable Value Cost Coefficient Increase Decrease $C$4 Units X 108 Produced Units Y $D$4. 25 Produced Constraints Cell Name Final valueShadow Priceconstraint RH SideAllowable Increase Allowable Decrease $E$14 Plant 1 14 184 $E$15 Plant 2 20 162 Consider the objective function coefficient on Units X Produced. If this coefficent decreases, what is the first number where the solution would change? Enter that number below. Assume everything else remains constant Answer: Next page
Explanation / Answer
Allowable Decrease for X is 22
The Objective coefficient of X is 83
The solution will change when the X goes below 83 - 22 = 61
So, the first number where the solution will change is 60