Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Optimization tool (network optimization distribution centers to stores)

Highlighted
6 - Meteoroid

Hi Andrew,

 

If I am following your suggestion, those constraints are already in place, I am uploading the matrix on excel for your reference (this is the table I have on the Alteryx model).

 

With this matrix I am getting two customers being served by two DCs.

 

Could it be a glitch on the solver?

 

Best,

Rodrigo

Highlighted
6 - Meteoroid

Andrew,

 

Following with the example, how can I add the constraint?

C-1-DC_24 + C-1-DC_8 + C-1-DC_9 = 1

 

I don't know how to structure it so the Optimization tool can run.

 

Best,

Rodrigo

Highlighted
Alteryx
Alteryx

Taking a second look at your problem, I now see my previous suggestion will not work since your decision variables are integer, not binary. Scratch that idea. Perhaps you may want to re work your problem in the binary 1/0 form. If C1 will be supplied in its entirety by DC_24, there is no need to have a decision variable for the amount sent to C1 from DC24. We know the amount sent in theory should be the demand.

 

Let me know our thoughts.

Labels