Question: Considering the following excel sensitivity report: Variable Cells table [ [ Cell , Name, table [ [ Final ] , [ Value ]

Considering the following excel sensitivity report:
Variable Cells
\table[[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[SBS12 Product 1=,0,-1,10,1,1E+30,],[SB$13 Product 2=,30.64516129,0,12,46.5,3.1,],[SBS14 Product =,0,-1,11,1,1E+30,],[SBS15 Product 4=,12.09677419,0,13,6.2,1.291666667,]]
Constraints
\table[[Cell,Name,\table[[Final],[Value]],\table[[Shadow],[Price]],\table[[Constraint],[R.H. Side]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[SHS6,Process 1(hrs) Usage,225.8064516,0,600,1E+30,374.1935484],[SHS7,Process 2(hrs) Usage,268.5483871,0,500,1E+30,231.4516129],[SHS8,Process 3(hrs) Usage,300,0.5,300,150,237.5],[SHS9,Process 4(hrs) Usage,250,1.5,250,281.372549,83.33333333]]
Which one of the following values of the second objective function coefficient (c2) would generate a different optimal solution (remember: all of the other variables remain the same)?
8
9
13
14
None of the above
 Considering the following excel sensitivity report: Variable Cells \table[[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[SBS12 Product 1=,0,-1,10,1,1E+30,],[SB$13

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!