Assume that you have just built a linear programming problem model, executed it using Excel Solver, and obtained the sensitivity

report given below. The case is a maximization problem. Please answer the questions according to the sensitivity report given below.

a$.$ Explain the optimal solution $($Values of the decision variables and the total cost$).[5$ marks$]$

b$.$ Explain the reduced cost of Frame $4.[5$ marks$]$

Answer the What$-$If questions and provide all the details you used. If it is available, provide also $Z$ value changes.

c$.$ What$-$If the objective coefficient of "Product $2"$ is $4?[5$ marks$]$

d$.$ What$-$If the objective coefficient of "Product $4"$ is $1?[5$ marks$]$

e$.$ What$-$If the RHS value of the "Labor" constraint is $2500?[5$ marks$]$

f$.$ What$-$If the RHS value of the "Plastic" constraint is $7500?[5$ marks$]$