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:
Objective: Allocate as much product from the 3 warehouses as possible to the 26 retail locations
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)