Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #48: Calculating Distribution Priority

Highlighted
Alteryx Alumni (Retired)

The link to last week’s challenge is HERE.

 

Use Case:  There are 3 warehouses across the US that supply 26 retail locations. The retailers have products/items that are in high demand and, as a result, out of supply within their stores.

 

Your job as a distribution manager is to allocate as much product from the warehouses as possible, but there are a few constraints:

 

  1. A retailer location can only be supplied by the nearest warehouse.
  2. Prioritization of product allocation across retailers is dependent on required product/item need at the location. For example, is there higher priority where there is the highest required?

 

Objective:  Allocate as much product from the 3 warehouses as possible to the 26 retail locations

Highlighted
Alteryx Partner
Missed the answers.
Highlighted
Alteryx Partner
Spoiler
Solution

 

Highlighted
Ravenclaw

Nice work @LBhat! I moved your solution image into a spoiler tag so as not to give it away! I think this was the fastest solution turn around we've had to a weekly exercise.

Tara McCoy
Highlighted
Alteryx Community Team
Alteryx Community Team

Here's a solution:

Solution.PNG

Highlighted
14 - Magnetar
14 - Magnetar

Solution!

 

Spoiler
WeeklyChallenge48.JPG
Highlighted
16 - Nebula
16 - Nebula

Slightly more complex answer

Spoiler

uses an iterative macro to do the supply levelling
the iterative macro makes this very easy - just take the highest priority demand line for any given warehouse and product and fulfil that line - then iterate the remainder (repeat)

But it was good to see the two alternatives ( the running total version from @MattD @LBhat and @TaraM - and the unfilfilled demand version from @NicoleJohnson )

 

Highlighted
14 - Magnetar
14 - Magnetar

similar approach to others, with the individual tools (to make it different than the iterative macro exercise)

Highlighted
Alteryx Certified Partner

Well that took longer than expected:

 

Spoiler
Weekly Challenge 48.png
Highlighted
16 - Nebula
16 - Nebula

Very similar to others

Spoiler
Capture.PNG