St

arts a through c. 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 Click the icon to view the Solver Sensitivity Report. How much would the return on stock B have to increase in order for the optimal solution to invest full in that stock? would need to increase by at least $ 3 per share, which is the negative of the reduced cost ype an integer or a decimal. Do not round.) How much would the return on stock C have to increase in order to fully invest in that stock? would need to increase by at least $ 7 per share, which is the negative of the reduced cost. ype an integer or a decimal. Do not round.) Explain the value of the shadow price for the total investment constraint. If the student could borrow $1,000 at 8% a year to increase her total investment, what would you recommend and why? ince the shadow price is $0.67, every additional dollar invested will profit by $ So, an additional $1,000 would result in a gain of $ profit at a cost of $ in interest ype integers or decimals rounded to two decimal places as needed.) X Solver Sensitivity Report D Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Shares Purchased A 216.5555555 1E + 30 2.3 om C$5 Shares Purchased B 18 + 30 D$5 Shares Purchased C -7 1E + 30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $A$16 Capacity Used 1500 0.666666667 1500 1E + 30 1500 Clear all Check