Question: I need to use Solver to solve this problem but I am inputting something wrong. It will not give me my answer! What am I


I need to use Solver to solve this problem but I am inputting something wrong. It will not give me my answer! What am I inputting wrong in solver / in my model?
Problem #2 (problem #30 in chapter 2) A financial advisor at Diehl Investments identified two companies that are likely candidates for a takeover in the near future. Eastern Cable is a leading manufacturer of flexible cable systems used in the construction industry, and ComSwitch is a new firm specializing in digital switching systems. Eastern Cable is currently trading for $40 per share, and ComSwitch is currently trading for $25 per share. If the takeovers occur, the financial advisor estimates that the price of Eastern Cable will go to $55 per share and ComSwitch will go to $43 per share. At this point in time, the financial advisor has identified Com Switch as the higher risk alternative. Assume that a client indicated a willingness to invest a maximum of $50,000 in the two companies. The client wants to invest at least $15,000 in Eastern Cable and at least $10,000 in ComSwitch. Because of the higher risk associated with ComSwitch, the financial advisor has recommended that at most $25,000 should be invested in ComSwitch (a) Formulate a linear programming (LP) model that can be used to determine the number of shares of Eastern Cable and the number of shares of Com Switch that will meet the investment constraints and maximize the total return for the investment. (b) Solve the problem graphically (clearly show the feasible region and the profit line). i. What is the optimal solution (i.e. how many shares of each company should client invest in and what is the resulting profit?) Page 1 OIM 310 HW2 LP Models: Solving graphically & with Excel ii. Briefly explain how you determined the optimal solution. iii. Which constraints are binding and which are non-binding? Explain why and what it means in terms of use of resources. (c) Solve the LP with the Excel Solver and verify your answers to questions in part (b) Excel-Template-for-Solver-2 o. Home AutoSave OFF A E S5 = Insert Draw Page Layout Formulas Data Review View EL T 7 Solver Parameters clear Data Analysis All Sort Filter Reappl Adva Advanc Set Objective: $G$15 Solver L LS Get External Refresh Data All A x 18. Connections Properties Stocks Geography Edit Links fx DE F Diehl Investments Optimal Share Mix To: Max Min Value Of: D By Changing Variable Cells: $C$15:$D$15 Eastern Cable $15.00 ComSwitch $18.00 Unit Profit Add Subject to the Constraints: $E$10 = $G$8 $E$9 >= $G$9 Resource Used 0 Change Resources Used per Unit Produced 40 2 5 400 0 25 0 25 Resource Available 50000 15000 10000 25000 Max Investment E Minimum C Minimum C Maximum Unused Recrouces 50000 15000 10000 25000 O Delete 0 Reset All Load/Save Product C Product E O Total Profit i $0.00 Make Unconstrained variables Non-Negative Units Produced Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non- smooth. Close SolveStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
