Catchment Rings: Counts and Revenue within a Radius
This lesson is part of the course
In this lesson
You size the Alder Falls store's primary, secondary and tertiary catchment with COUNTIFS and SUMIFS on distance and estimate its annual sales.
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