Question: this is for mathematical modeing. please show all the equations used for each cell in execel. thank you here are my notes from class on

17. A retired engineer has $250,000 to invest and is willing to spend five hours per week managing her investments. Municipal bonds earn 6% per year and require no management. Real estate investments are expected to appreciate at 8% per year and require one hour of management per $100,000 invested. Blue chip stocks earn 10% per year and require 1.5 hours of management. Junk bonds earn 12% and require 2.5 hours, while grain futures earn 15% and require five hours per $100,000 invested. (a) How should the retiree invest her money in order to maximize her expected earnings? Use the five-step method and solve as a linear programming problem. xMMxRxxSxG0.06xM+0.08xR+.1x.12xJ+.15xG5ubjec+t0xM+xR+xB+xJ+xG250,000xM100,00011xR+100,0001.5xB+100,0002.5xS+100,005xGxi0,i=M,R,,J,6 Con Set up in Excel. On Maple we got 27,500,XB=125000,XG=0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
