Forum Discussion

mattycorr's avatar
mattycorr
Copper Contributor
Feb 26, 2018

Excel 2016 LP Solver Supplier selection problem

I have three different suppliers for four different for different products.

How do I put the fixed costs into the excel so that the solver's binary variables will be correct?

 

My problem is that the fixed costs occur only once but in the constraints there can't be less cells on either side than there is on the other and if I have binary variables for the fixed costs per product the answer will be incorrect.

No RepliesBe the first to reply

Resources