Linear optimization setup

Ashish

Hi,

I am trying to set up a Linear optimization solution in Alteryx using the optimization tool in Prescriptive, but I am not getting the desired results (no solution).

I do have the problem definition and solution in the attached excel, however I am not sure if I am setting it up right in Alteryx (attached workflow).

Any help is appreciated.

Thanks,

Ashish

Office Allocation_Optimization.xlsx

Office Allocation.yxmd

SydneyF

Hi @Ashish

To add the Employee constraint, simply add the Employee matrix to the "A" input", as you had done in your original configuration. The difference from your original configuration is that you only want 1's and Nulls in the matrix. The 1's represent a combination meeting a criteria (office 1 or Employee 1). 

And add the Employee == 1 constraint to the "B" input. All Employees should be set to ==1, as you want to be sure that each gets assigned once, and only once, again, as you had done in your original configuration. 

Please be sure to check that the order of your constrains in the "A" input left to right matches the order of your constraints in the "B" input. 

This configuration produces your expected result, where each employee is assigned to only one office. 

Do the configurations of the Optimization Tool inputs make sense? Are there any further questions I can help you with? Please let me know!

Thanks!