Candidate Sites: Distance Matrix, Nearest Depot and the Volume Each Site Serves
This lesson is part of the course
In this lesson
You read a towns × sites distance matrix, find the nearest site for every town with MIN and INDEX/MATCH, add up the volume each site would serve and measure the weighted average distance.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Demand Map: Coordinates, Volumes and the Weighted Centre of Gravity Locked
- Better Than the Centre of Gravity: Distances, Tonne-km and a Weiszfeld Step Locked
- Candidate Sites: Distance Matrix, Nearest Depot and the Volume Each Site Serves Locked
- Transport Cost: Outbound Deliveries, Inbound Trunking and Road Kilometres Locked
- Warehouse Cost: Fixed Cost per Depot, Handling per Tonne and Capacity Locked
- Service Coverage: Drive Times, the Delivery Promise and the Price of Better Service Locked
- The Inventory Effect: More Depots, More Safety Stock (the Square-Root Rule) Locked
- How Many Depots? Total Cost Curve, Service Target and the Recommendation Locked