This is made to order for Solver:
A B C D E F G H 1 x y z 2 0.0360 0.3819 0.5821 3Set Cell to value 4 1.0000 1D4: =x + y + z 5 6Constraints >= <= 7 0.9651 0.90 1.00D7: =x + y + 0.94*z 8 0.7323 0.60 0.75D8: =x + y + 0.54*z 9 0.4718 0.40 0.55D9: =x + 0.664*y + 0.313*z 10 0.2680 0.20 0.35D10: =x + 0.26*y + 0.228*z 11 0.1461 0.12 0.22D11: =0.736*x + 0.176*y + 0.09*z 12 0.0516 0.05 0.10D12: =0.401*x + 0.05*y + 0.031*z
See http://www.solver.com/learn-how-use-...0-CF21bsfD_BwE or the many other resources on Frontline's web site.
Bookmarks