community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #48: Calculating Distribution Priority

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

Alteryx Partner
Missed the answers.
Alteryx Partner
Spoiler
Solution

 

Creative Director
Creative Director

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
Community Data Engineer
Community Data Engineer

Here's a solution:

Solution.PNG

Solution!

 

Spoiler
WeeklyChallenge48.JPG
Aurora
Aurora

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 )

 

Quasar

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

Alteryx Certified Partner

Well that took longer than expected:

 

Spoiler
Weekly Challenge 48.png
Highlighted

Very similar to others

Spoiler
Capture.PNG