Make sure $to$ use excel and show the functions $in$ excel. also $be$ sure $to$ explain how $to$ get the answers and how $to$ use the solver function $soitis$ easy $is$ replicating the answers given.

$7.$ A business student has $$2,500$ available from a summer 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.

$a.$ Identify the decision variables, objective function, and constraints $in$ simple verbal statements.

$b.$ Mathematically formulate a linear optimization

model

$c.$ the Answer Report using SOLVER. Then, clearly respond $to$ the following two questions: What $is$ the optimal solution? What $is$ the resulting output $of$ the objective function $at$ the optimal solution?