Question: Solve the following problem in Excel:Max Z = 8 x1 + 6 x2s.t. x1 + x2 82 x1 + x2 10Create the sensitivity report.1.Check to

Solve the following problem in Excel:Max Z = 8 x1 + 6 x2s.t. x1 + x2 82 x1 + x2 10Create the sensitivity report.1.Check to make sure you got the right solution: x1 = 2; x2 = 6A)Got it! B)If you didnt get the right answer, go back and do it again until you do. [And dont pick this answer its wrong!]2.The objective function value at the optimal solution is: A)52B)Something else3.OK, here come the more difficult questions about sensitivity ranges,etc. A)[acknowledged]4.The sensitivity range for the objective function coefficient on x1 is: 6 c1 12A)TrueB)False5.The sensitivity range for the objective function coefficient on x2 is: 4 c2 8A)TrueB)False6.The sensitivity range for the RHS of constraint 1 is: 5 q1 10A)TrueB)False7.The sensitivity range for the RHS of constraint 2 is: 8 q2 16A)TrueB)False8.By how much will the objective function change if the righthand side of the first constraint is relaxed by 1 to 9. That is, the first constraint becomes x1 + x2 9.[NOTE: you could resolve the problem if you wish, but the answer can easilybe found in the Sensitivity Report]A)The objective function value increases by 3B)The objective function value increases by 4C)The objective function value decreases by 4

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 General Management Questions!