Mar 02 2022 03:04 AM
Hi,
I have what seems to be a normal optimization problem, but I can't find a way to avoid circular references.
I would like to optimize the quantities X and Y (i.e. I want to determine B11 and B12, marked in green) of a certain product so that the total output of both products, i.e. sumproduct (D5:D6;B11:B12), is maximized.
Each product requires a given number of liters of oil and technician hours (B5:C6).
There are several input fields (all marked in blue) which can be changed: output per unit X and Y, total liters of oil available, total hours of technicians available and sum of quantities for X and Y.
When using the solver tool to maximize the total output, i.e. sumproduct (D5:D6;B11:B12), with the constraints for oil (G4=B5*B11+B6*B12), hours (G5=C5*B11+C6*B12) and quantity X + Y (G6=B11+B12), I can't seem to avoid circular references in defining X and Y.
I am helpful for every hint to solve the question.
Thanks
SJ
Mar 02 2022 09:31 AM
Solutionthe question has been solved.