SOLVED

New Contributor

# Solver tool: optimization question

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