Challenge #14: Warehouse Distribution

[jevon]

Wanted to take the opportunity to practice iterative macros, took a while but got there in the end.

Spoiler

[kbwissi]

Very similar solution to the one posted. This one was fun!

[Wouter]

Unfortunately i didn't figure it out with an iterative macro, but this works as well:

Spoiler

[Ruud]

I don't need no stinkin' macro!

Spoiler

[dharini]

I haven't built any macros yet, so this solution doesn't have one. 

[MarMu]

Cool challenge. I went in a different direction for solving this weeks challenge than the obvious iterative macro.

This is a simple IP optimization problem that can be solved with the Optimization-tool in the Prescriptive section of the tool palette

With a bit of data wrangling to match the expected constraint format, it is actually quite simple to run.

Spoiler

[tammybrown_tds]

My solution.  I didn't use a macro....got stuck so I wanted to see what the published solution said.  The published solution is for the wrong challenge.

Oh well...what I have works great as a non-macro solution.  And relatively easy, so I'm not sure that a macro would have been more efficient.

[kat]

Spoiler

[willstom1]

Here is my solution:

Spoiler