E
ExcelProactive
I would really appreciate if somebody could help on this one
How to set a constrain in a Solver model so that the chosen value is part of a given list of values within a range
On the table below, the QTYs are fixed but the rates can be chosen from different suppliers (sup1, sup2, etc). And the goal is to get the minimum Total (Sum of quantities time rates) so that one can know what supplier is offering the most convenient price
Example
QTY RATE list of rates available
sup1 sup2 sup3
qty1 rate1 100 145 150
qty2 rate2 76 45 8
qty3 rate3 34 23 56
.... ..
Sum of qty's times rate'
Thanks a lot in advance for your time and tips.
How to set a constrain in a Solver model so that the chosen value is part of a given list of values within a range
On the table below, the QTYs are fixed but the rates can be chosen from different suppliers (sup1, sup2, etc). And the goal is to get the minimum Total (Sum of quantities time rates) so that one can know what supplier is offering the most convenient price
Example
QTY RATE list of rates available
sup1 sup2 sup3
qty1 rate1 100 145 150
qty2 rate2 76 45 8
qty3 rate3 34 23 56
.... ..
Sum of qty's times rate'
Thanks a lot in advance for your time and tips.