[Expert solver] Assignment problem

[John1978]

Hello everybody,

I'm working on a basic assignment problem with the solver. I would like to assign a customer to our company's office. So, I would like to minimize the transportation costs between these two locations. I have no difficulties in accomplishing this.

but if the distance between the two locations is >= 700km we have to take the plane if not the truck. I have trouble translating this information into excel.

I absolutely want to keep my model linear and not use the "if" function.
















Thanks a lot for your help
John

 

[pgc01]

Hi John
Welcome to the board

Did you try:

(distance < 700)*(train cost) + (distance >= 700) * (plane cost)