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: * A retailer location can only be supplied by the nearest warehouse. * 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 challenge_48_start_file.yxmd challenge_48_solution.yxmd

Spoiler challenge_48_ehendershot_solution.yxmd

Spatial challenge to prep for Advanced Cert. Used the Multi-Row tool instead of Running Total tool. Hope I remember to use Running Total on future workflows instead. Spoiler challenge_48_solution_wc.yxmd

Solution challenge_48_start_file.yxmd

Challenge #48: Calculating Distribution Priority

GeneR

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:

A retailer location can only be supplied by the nearest warehouse.
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

challenge_48_start_file.yxmd

challenge_48_solution.yxmd

Join

Spatial Analysis

Preparation

Advanced

Intermediate

Transform

Spatial

Accepted answers

All comments

LBhat

Missed the answers.

LBhat

Spoiler

TaraM

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.

MattD

Here's a solution:

NicoleJohnson

Solution!

Spoiler

challenge_48_NicoleJohnson.yxmd

SeanAdams

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 )

challenge_48_SeanSolution.yxzp

estherb47

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

challenge_48_EHB_solution.yxmd

LordNeilLord

Well that took longer than expected:

Spoiler

challenge_48_LNL.yxmd

patrick_digan

Very similar to others

Spoiler

challenge_48_start_file.yxmd

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.

challenge_48_Ceneviva.yxmd

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.
Screen Shot 2017-11-04 at 20.35.52.png

challenge_48_Natasha.yxmd

samN

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

challenge_48.yxzp

ggruccio

Created iterative macro then answered the questions. Fun!

challenge_48_gg_finish.yxzp

philipmannering

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

Spoiler

challenge_48 - Calculating Distribution Priority.yxmd

LandonG

Solution attached.

challenge_48_start_file.yxmd

jasperlch

Solution attached.

challenge_48_JL.yxmd

msicak

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

Spoiler

challenge_48_MS.yxmd

jamielaird

Here's my solution.

Spoiler

challenge_48_solution_JL.yxmd

JoshKushner

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

challenge_48_start_file.yxmd

dsmdavid

solved!...although my distances are very slightly different

Spoiler

solved#48.yxmd

derekbelyea

Spoiler

challenge_48_JDB_AnalytixStudio.yxmd

JosephSerpis

Challenge Completed

Challenge_48_Joe_Serpis.yxmd

CHarrison

My solution

Challenge 48.yxmd

daniel_ferreira

Follow my solution file attached...

challenge_48_solved.yxmd

KOBoyle

Solution attached.

challenge_48_solution_KO.yxmd

asabau

Good practice of stock distribution!

challenge_48_stockdistributionwarehouse_file.yxmd

justynam

Solution attached

challenge_48_solution_JM.yxmd

kat

Spoiler

Challenge #48.yxmd

Laurap1228

Here is my solution:

Spoiler

challenge_48_LP.yxmd

CaraI

A few more tools than the solution, but gets to all the answers.

Spoiler

Couple notes:
Select tools after the Create Points so the Centroids are Named - just a housekeeping thing.
First Formula tools - sets the starting "Remaining Inventory" - it is possible to do this all in the Multi-Row tools, setting values for rows that don't exist to Null and then incorporating isnull() into the if then elseif, but IMO it over complicates the multi-row tool.

challenge_48_CaraI.yxmd

danilang

Nice. Spatial and analytics

Spoiler

Dan

challenge_48_solution_DL.yxmd

RashedDS

challenge_48_start_file.yxmd