Implement the linear optimization model that you developed for the investment scenario in Problem 4 in Excel and use Solver to find an optimal solution.

Save the Answer and Sensitivity reports in your Excel workbook. Interpret the Solver Answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constraints.