microsoft Excel Solver. highlight answer

Solve the following problem in Excel: Max Z = 8 x1 + 6 x2 s.t. x1 + x2 58 2 x1 + x2 5 10 Create the sensitivity report. 1. Check to make sure you got the right solution: x1 = 2; x2 = 6 A) Got it! B) If you didn't get the right answer, go back and do it again until you do. (And don't pick this answer - it's wrong!) 2. The objective function value at the optimal solution is: A) 52 B) Something else 3. OK, here come the more difficult questions about sensitivity ranges, etc. A) (acknowledged] 4. The sensitivity range for the objective function coefficient on xl is: 6 s c1 s 12 A) True B) False 5. The sensitivity range for the objective function coefficient on X2 is: 45 c258 A) True B) False 6. The sensitivity range for the RHS of constraint 1 is: 5 sq1 s 10 A) True B) False 7. The sensitivity range for the RHS of constraint 2 is: 8 592 s 16 A) True B) False 8. 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 59. [NOTE: you could resolve the problem if you wish, but the answer can easily be found in the Sensitivity Report] A) The objective function value increases by 3 B) The objective function value increases by 4 C) The objective function value decreases by 4