I am currently trying to use Solver to help optimize some water pump usage.
I have three locations where these pumps are located. If the water demand
can be met by two sites alone i would prefer to only use those two sites not
the three.
For instance
Site A - 100gpm
Site B - 100 gpm
Site C - 100gpm
I need 175 gpm so solver would tell me 100% use on Site A, 75% use on Site B
and 0% on site C.
Currently Solver is giving me Site A =58.33%, B=58.33%, and C=58.33%
So is there i way i can do this?