Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution attached.
Solution
My solution is quite simple. I use the 'Create Point' tool to convert longitude and latitude for stores and warehouses into spatial objects. After this, I find the shortest distance between store and warehouse for each item. I then get the total distance by multiplying the 'Assigned' (number of units per item) by the shortest distance.
First spatial challenge!