Part 1: Understanding the idea
Imagine you live in a neighbourhood and want to buy groceries.
There are several supermarkets nearby. Some are large, some are small. Some are close, some are further away.
When choosing where to shop, most people think about two main things.
Store attractiveness
Large supermarkets often attract more customers because they offer more products, wider variety, and sometimes lower prices.
Distance
People generally prefer shops that are closer to them. Travelling further requires more time and effort.
A simple example
Suppose people in a neighbourhood spend £10,000 per week on groceries.
Nearby there are three stores:
| Store | Size | Distance |
|---|---|---|
| Tesco | very large | 2 km |
| Aldi | medium | 1 km |
| Sainsbury’s | large | 3 km |
Even though Tesco is the biggest store, Aldi is much closer. This means Aldi might still attract many customers.
Instead of assuming everyone goes to one store, the spatial interaction model assumes that spending is shared between all stores depending on their attractiveness and distance.
Example distribution:
| Store | Spending received |
|---|---|
| Tesco | £4800 |
| Aldi | £3300 |
| Sainsbury’s | £1900 |
Part 2: Key components of the model
To estimate how spending is distributed, the model needs three types of information.
1 Demand
Demand represents the total spending from each residential area.
Example:
| Postal sector | Weekly grocery spending |
|---|---|
| LS1 | £10,000 |
| LS2 | £8,000 |
| LS3 | £12,000 |
This represents the origin of spending.
2 Store attractiveness
Stores are not equally attractive.
Larger stores usually attract more customers.
In this practical, attractiveness is represented by floorspace.
Example:
| Store | Floorspace |
|---|---|
| Tesco | 5000 m² |
| Aldi | 2000 m² |
| Sainsbury’s | 3000 m² |
3 Distance
Customers are more likely to shop at stores that are nearby.
Distances are measured between postal sector centres and store locations using their coordinates.
Part 3: How the model works conceptually
The model works in three steps.
Step 1: Calculate store attraction
A store becomes more attractive when it is larger and closer.
Step 2: Compare all stores
For each residential area, the model compares the attraction of every store.
Step 3: Allocate spending
Total spending from each area is divided between the stores according to these attraction levels.
Part 4: Mathematical version of the model
Once the logic is understood, we can express the model mathematically.
Variables
- i = residential zone
- j = store
| Symbol | Meaning |
|---|---|
| total expenditure from zone | |
| attractiveness of store | |
| distance between zone and store | |
| distance decay parameter |
Distance decay
Distance influence is represented by
In this exercise
Store attraction
The attraction of store for zone is:
Spatial interaction model
represents spending flowing from zone to store .
Balancing factor
The model can also be written as
This ensures
meaning all spending from each zone is allocated across stores.
Part 5: How the Excel model implements this
Distance sheet
Calculates distances between zones and stores ().
Calc sheet
Calculates and the balancing factor .
Flows sheet
Calculates final retail flows:
Key idea
The spatial interaction model predicts where people shop based on:
- how attractive stores are
- how far away they are Bigger and closer stores attract more spending, while smaller and distant stores attract less.
Questions to think about
The model is useful because it is simple, but that simplicity also hides assumptions. When interpreting the results, it is worth asking:
- Is the way distance is calculated reasonable? Straight-line distance is easy to compute, but real shopping journeys follow roads, public transport routes, and everyday travel patterns.
- Are people living near the edge of a postal sector also influenced by stores just across the boundary? Administrative zones are convenient for analysis, but people do not make decisions based on those boundaries.
- Does floorspace capture attractiveness well enough? Larger stores often offer more choice, but price, brand, parking, product quality, and opening hours may also shape behaviour.
- Do all customers respond to distance in the same way? Some people may be highly sensitive to travel time, while others are willing to travel further for a preferred store.
- Is one distance-decay parameter appropriate for every place? Dense urban areas and more rural areas may show very different travel behaviour.
- Are there stores that should not be treated as direct competitors? For example, a premium supermarket and a discount supermarket may attract overlapping but not identical customer groups.
- Does the model assume shopping demand is fixed? In reality, the opening of a new store may change how much people buy, not just where they buy it.