Challenge #48: Calculating Distribution Priority

[nick_ceneviva]

Solution attached.  Looking at the other solutions I should have used the running total solution to simplify this as opposed to using the Multi Row formula tool.

[Natasha]

Since I am doing the challenges not in a chronological order I already encountered a very similar challenge that required to calculate items supplied. I find this one a bit more challenging as this challenge allows to make a partial fulfilment. 

Spoiler

In my solution I defaulted to my favourite multi row formula tool.

[samN]

Modified a macro from a past challenge to loop through each store by priority. Pretty fun!

[ggruccio]

Created iterative macro then answered the questions.  Fun!

[PhilipMannering]

Hopefully I've answered all three questions accurately. Solution attached.

Spoiler

[LandonG]

Solution attached.

[jasperlch]

Solution attached.

[msicak]

struggled understanding how to assess priority, but the rework was minimal. a great challenge!

Spoiler

[jamielaird]

Here's my solution.

Spoiler

[JoshKushner]

Honestly the third question is pretty confusing. couldn't get an answer to match, but I couldn't decipher the wording