Challenge #48: Calculating Distribution Priority
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's a solution:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Slightly more complex answer
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 )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Very similar to others