I need solutions for a, b, c and d please!!!

Q2. [9] We obtained the following sensitivity report from Excel SOLVER. Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$5 Time spent on: Regular 50 0 1.25 1E+30 $C$5 Time spent on: New 30 o 1 0.25 Allowable Decrease 0.25 3.08 Constraints Cell $D$9 $D$10 $D$11 Name Service time Cash Flow New customer contact Final Value 80 1440 0 Shadow Price 1.156 0 -0.0156 Constraint R.H. Side 80 864 0 Allowable Increase 1E+30 576 576 Allowable Decrease 32 1E+30 480 (a) [2] What is the optimal solution and the corresponding objective value? We assume that x and y are defined same as the previous question Q1. x? y? Objective value? (Answer it with 1 decimal-point number.) (b) [2] What happens if the maximum hours of technician time changes from 80 hours to 70 hours? Is it in the allowable range of change? Is there any change in the optimal solution? What will be the new optimal objective value? (Answer it to the nearest integer.) (c) [2] What happens if the minimum cash flow requirements per technician changes from $864 to $1000? What is the maximum allowable increase of RHS in this constraint? Is there any change in the optimal solution? 3 What will be the new optimal objective value? (Answer it to the nearest integer.) (d) [3] Suppose that we think the time to serve the regular customer is longer than the new customer, (that is, 75 minutes on the average). From the original question in Q1 and the sensitivity report, answer the following questions: What is the objective coefficient of x in this case? What is the objective coefficient of y in this case? 3 Is this change in the allowable range? Which point is the optimal from the graph in QI? What will be the new optimal objective value? Answer it to the nearest integer. Q2. [9] We obtained the following sensitivity report from Excel SOLVER. Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$5 Time spent on: Regular 50 0 1.25 1E+30 $C$5 Time spent on: New 30 o 1 0.25 Allowable Decrease 0.25 3.08 Constraints Cell $D$9 $D$10 $D$11 Name Service time Cash Flow New customer contact Final Value 80 1440 0 Shadow Price 1.156 0 -0.0156 Constraint R.H. Side 80 864 0 Allowable Increase 1E+30 576 576 Allowable Decrease 32 1E+30 480 (a) [2] What is the optimal solution and the corresponding objective value? We assume that x and y are defined same as the previous question Q1. x? y? Objective value? (Answer it with 1 decimal-point number.) (b) [2] What happens if the maximum hours of technician time changes from 80 hours to 70 hours? Is it in the allowable range of change? Is there any change in the optimal solution? What will be the new optimal objective value? (Answer it to the nearest integer.) (c) [2] What happens if the minimum cash flow requirements per technician changes from $864 to $1000? What is the maximum allowable increase of RHS in this constraint? Is there any change in the optimal solution? 3 What will be the new optimal objective value? (Answer it to the nearest integer.) (d) [3] Suppose that we think the time to serve the regular customer is longer than the new customer, (that is, 75 minutes on the average). From the original question in Q1 and the sensitivity report, answer the following questions: What is the objective coefficient of x in this case? What is the objective coefficient of y in this case? 3 Is this change in the allowable range? Which point is the optimal from the graph in QI? What will be the new optimal objective value? Answer it to the nearest integer