Challenge #65: Fulfilling Inventory Orders

[MarMu]

Fun little exercise. I thought the contraints sounded a bit unrealistic, but I guess that was in order to make it easy to solve in Alteryx. I managed to solve it with 6 tools. Probably the same solution as many other.

The constraints doesn't necessarily solve the problem to optimum, as the solution can leave SKU on stock. So I solved the challenge using to Optimization tool aswell. This guarantees an optimal solution. The only thing you need to change is the penalty/reward giving in the objective function. I gave an exponential reward to force rank assignment of orders.

Spoiler

[jssandom]

Enjoyed this one!

[Samuel_To]

Hi @JoeM,

Here is my solution.

Best Regards,

Samuel

[justynam]

My solution

[KMiller]

Solution attached.

[yurii]

Solution

Spoiler

[adams_ca]

Spoiler

[JoshuaGostick]

My solution :)

Spoiler

[payam2]

I have no idea why the first day I looked at this, it looked so confusing to me. But when I came back to it a few days later, it was all clear. I'm glad I didn't skip this one.

[jbranaum]

My Solution