Please answer with Excel screenshots with formulas. No scratch paper please.

7.

14. Implement the linear optimization model that you developed for the investment scenario in Problem 7 on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables by substituting the optimal solution into the model constraints.7. A business student has $2,500 available from a sum- mer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next two years is given in the table. Stock A B C Price/share $12 $15 $30 Return/share $8 $7 $11 a. Identify the decision variables, objective func- tion, and constraints in simple verbal statements. b. Mathematically formulate a linear optimization model