Challenge #14: Warehouse Distribution

[snbandi]

These are the real life challenging type problems. 

[JWAJ]

I did not go the macro path. i  used summarize to find the highest priority by item and used the multi row tool to assign to each store by item. finally i used a formula to adjust negative assigned values.

Spoiler

 

[AGilbert]

A change in mindset but macros are not as intimidating as I thought. 

Spoiler

[fmilliren]

Still struggling with iterative Macro's so I used the running total tool, plus I added a few error checks to make sure stores didn't have items not available, no items were unstocked, all items were in the warehouse and all warehouse items were stocked.

Spoiler

[usmanbashir]

Used more tools that I would have liked.

Spoiler

 

[Dev73]

my without macro solution 

Spoiler

[sknman92]

Spoiler

my solution 

[danbostrom]

Once regular and once with a batch macro for practice

[aatalai]

no macro used running total

[Bobbyt23]

Didn't go for the iterative macro version of this but enjoyed the exercise.