I am using a Solver function in Excel which works well, but I want to add a new constraint.
The solver tool currently manipulates the values of 100 variable cells in integers between 1 and 4 which correspond to size of product line to optimize sales within constrained space.
The constraint I want to add is: the value of these 100 cells cannot be any number between 1 and 4, but must be >= the original size value (defined by me as constant).
I.E. Product A Original Value = 2. Solver cannot assign any value to this product except 2, 3, or 4.
In simple terms I want to add a constraint saying:
"A1:A10 (variable cells) >= B1:B10 (fixed constants)
*Edit: Added workbook with example*
However when I do this solver doesn't understand it. I could add a separate constraint for A1>=B1, A2>=B2, etc., but that would be time consuming and would probably break solver.
Any ideas?
Bookmarks