Exercise 1.3. Excel Reports Revisited. Recall the problem from lecture: max z = 7:01 + 14.02 + 603 + 1024 3.15 s.t. 25 Vi1, ...,5 Download the excel solution here: Excel Solution. Use this file as the basis of your work for the rest of the exercise. Consider a variation of the problem where R is a parameter. max z = 721 + 14:22 + 6x3 + 10x4 - 325 s.t. 25 0 V i =1,...,5 1. What are the two values a and b such that for a 0 Vi= 1,...,5 1. For each value T = -100, -10, 100, solve the linear program. 2. Report for each value, which constraints are tight (this includes the 4 constraints of the problem + the 5 non-negativity constraints) at the optimal solution. Note: a non-negativity constraint it tight if the corresponding variable is 0 at the optimal solution. Man anda Tuomainan