I need to be able to substitute a new fund for one of the original funds but I think I'm not entering the constraints properly because I get the result that no solution is possible. I set up the objective cell for minimum risk and checked the non-negative box. What gets entered where in the Problem Solver boxes to generate the original solution?
I might be missing a formula for one or more of the cells. I have attached the spreadsheet solution. Besides the original solution, I need to find a solution for replacing GEF with IIF, another solution replacing GEF with TCOIF, and another solution eliminating GEF and not replacing it at all.© BrainMass Inc. brainmass.com October 10, 2019, 1:30 am ad1c9bdddf
This solution discusses how to find a minimum risk portfolio.