Consider the following problem: Min 6x1 + 9x2 ($ cost) s.t. X1+ 2x2 30 X2 > 2 X1, X2 > 0 1. Use Excel Solver to solve the problem and generate the Sensitivity Report. You need to submit your Excel worksheet for the assignment. 2. What is the optimal solution of X1? What is the optimal solution of X2? What is the value of the objective function? 3. What is the range of optimality of the coefficient of X1? Suppose the unit cost of X1 is decreased to $3. Is the current solution still optimal? What is the value of the objective function when this unit cost is decreased to $3? 4. What is the range of optimality of the coefficient of X2? How much can the unit cost of x2 be decreased without concern for the optimal solution changing? 5. What is the range of feasibility of RHS of constraint 2? What is the range of feasibility of RHS of constraint 3? 6. What is the range of feasibility of RHS of constraint 1? If RHS of constraint 1 decreases from 8 to 7, what is the impact on the value of the objective function? 7. If simultaneously the cost of X1 was reduced to $4 and the cost of x2 was reduced to $6, would the current solution remain optimal? Please answer all the above questions and submit the Excel spreadsheet containing your solver solution and sensitivity renort