Territory Balancing: Workload per Sales Rep
This lesson is part of the course
In this lesson
You calculate the yearly workload of Maple & Rye's three wholesale reps, measure how unbalanced the territories are and test a proposed move of one border account.
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
- Haversine: Straight-Line Distance from Latitude & Longitude Locked
- Distance Matrix: Every Customer Town × Every Store Locked
- Nearest Store per Customer with MIN and INDEX/MATCH Locked
- Catchment Rings: Counts and Revenue within a Radius Locked
- Drive-Time Proxy: Circuity Factor and Speed Assumptions Locked
- Territory Balancing: Workload per Sales Rep Locked
- Huff Gravity Model: Probabilities and Market Share Locked
- New Site Selection: Weighted Scoring and a Scatter Map Locked