will upvote

For question 4(a), implement the following linear programming (LP) problem and solve it. For questions 4(b)4(e), without solving the LP problem again, answer the questions based on the Sensitivity Report obtained from the implementation in question 4(a). (a) Implement the LP model in a spreadsheet. Solve the problem using the solver in Excel. Save your solution with the report as "Q4.xI5 x" and upload it in the box provided (see illustration below). [2 points] (b) How small can the coefficient of X3 in the objective function be without the necessity to change the optimal solution? [1 point] (c) Determine the optimal objective function value if the RHS value of the first constraint decreases to 2 . [1 point] (d) Will the current solution remains optimal if the objective function's coefficient of X1 is decreased by 0.5 and the coefficient of X3 is increased by 1.5 at the same time? Justify your answer. [2 points]