Linear Programming via Excel Solver
 

I have this problem with the solver and especially with the sensitivity
report, which I don't know how to fix. My target function is:

max Z = 16x1 + 16x2 +16x3 + 16x4 + 28x5 + 28x6 + 28x7 + 28x8

but the coefficient 16 is not independent from each variable. In other
terms, I have a cost vector which has the values 16 and 28 in it. And these
values are assigned as mentioned above. But when generating a sensitivity
report every coefficient of the variables is assumed to be independent from
each other. Does anybody know if and how I can block these coefficients, so
that the sensivity report doesn't assume independency?

Linear Programming via Excel Solver
 

I'm not sure what it is that you are looking for, but you can re-write this:

max Z = 16x1 + 16x2 +16x3 + 16x4 + 28x5 + 28x6 + 28x7 + 28x8

to this, with just the two values:

max Z = 16x(1 + 2 + 3 + 4) + 28x(5 + 6 + 7 + 8)

Of course, in Excel, that would be

max Z = 16*(1 + 2 + 3 + 4) + 28*(5 + 6 + 7 + 8)

Or:

max Z = 16*SUM(1,2,3,4) + 28*SUM(5,6,7,8)

or with references to cells....

HTH,
Bernie
MS Excel MVP


"Squadron" wrote in message
...
I have this problem with the solver and especially with the sensitivity
report, which I don't know how to fix. My target function is:

max Z = 16x1 + 16x2 +16x3 + 16x4 + 28x5 + 28x6 + 28x7 + 28x8

but the coefficient 16 is not independent from each variable. In other
terms, I have a cost vector which has the values 16 and 28 in it. And these
values are assigned as mentioned above. But when generating a sensitivity
report every coefficient of the variables is assumed to be independent from
each other. Does anybody know if and how I can block these coefficients, so
that the sensivity report doesn't assume independency?