a. How much would the return on stock B have to increase in order for the optimal solution to invest full in that stock? It would need to increase by at least $ per share, which is the 1 of the 1 (Type an integer or a decimal. Do not round.) b. How much would the return on stock C have to increase in order to fully invest in that stock? It would need to increase by at least $ per share. which is the 1 of the 1 (Type an integer or a decimal. Do not rand.) A business student has $2500 available from a summer job and has identified three potential stocks in which to invest. To find an optimal solution to maximize, the Excel add-in Solver was used. The accompanying figure shows the Solver Sensitivity Report. Using only the information in the Sensitivity Report, complete parts a through c. i Click the icon to view the Solver Sensitivity Report. a. How much would the return on stock B have to increase in order for the optimal solution to invest full in that stock? X Solver Sensitivity Report It would need to increase by at least $ per share, which is the of the (Type an integer or a decimal. Do not round.) A B C D E F G H 6 Variable Cells Final Reduced Objective Allowable Allowable objective coefficient. CO - Cell Name Value Cost Coefficient Increase Decrease 9 $B$5 Shares Purchased A 217.4444444 8 1E + 30 2.2 reduced cost. 10 $C$5 Shares Purchased B 0 - 4 2 E + 30 11 $D$5 Shares Purchased C 0 - 9 10 9 1E + 30 allowable increase. 12 13 Constraints wable de 14 Fina Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $A$16 Capacity Used 2500 0.777777778 2500 E + 30 2500 Print DoneA business student has $2500 available from a summer job and has identified three potential stocks in which to invest. To find an optimal solution to maximize, the Excel add-in Solver was used. The accompanying figure shows the Solver Sensitivity Report. Using only the information in the Sensitivity Report, complete parts a through c. i Click the icon to view the Solver Sensitivity Report. a. How much would the return on stock B have to increase in order for the optimal solution to invest full in that stock? It would need to increase by at least $| per share, which is the of the (Type an integer or a decimal. Do not round.) negative value