Challenge #48: Calculating Distribution Priority

[TonyA]

Here's my solution.

[T_Willins]

Mine is a little more complex as I recycled and slightly modified my macro from Challenge 14.  Recycling is good, right?

Spoiler

 

Spoiler

 

[Thableaus]

Challenge #48, done.

Spoiler

I hate to do supply calculations :(

Cheers,

[Verakso]

This was a though one!

Spoiler

Well  not the spatial part, that one I managed to do rather quickly
The Spatial & Ranking part
Is was the three specific answers that got me here.
I could not get my calculations done in the same way so I had to peek at the solution several times for this, but I think i get the point now.

Therefore the rest is pretty much the same as the original solution,
The answersI actually at one point considered to use the Optimization Macro since it has been used in another challenge, but as it turned our, that was not needed here,

On my way to Lhotse Face

/Verakso

[Eleonora]

Hi all,

This challenge puzzled me. Don't we need locations of the three warehouses to be able to solve it? I don't see them in the starter file.

Would really appreciate someone's reply!

[RobertoEstrada]

I did all the calculations of supply before doing the calculations for each answer. Different paths but the same result.

[dillon_bok]

Spoiler