Linear Programming via Excel Solver

[Squadron]

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?

 

[Bernie Deitrick]

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