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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #48: Calculating Distribution Priority

GeneR
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

LBhat
5 - Atom
Missed the answers.
LBhat
5 - Atom
Spoiler
Solution

 

TaraM
Alteryx
Alteryx

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
MattD
Alteryx Community Team
Alteryx Community Team

Here's a solution:

Solution.PNG

NicoleJohnson
14 - Magnetar
14 - Magnetar

Solution!

 

Spoiler
WeeklyChallenge48.JPG
SeanAdams
17 - Castor
17 - Castor

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 )

 

estherb47
15 - Aurora
15 - Aurora

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

LordNeilLord
15 - Aurora

Well that took longer than expected:

 

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

Very similar to others

Spoiler
Capture.PNG