Fill in these first
- Business and current outlets: [e.g. a bakery chain with four stores in Indore, with their PIN codes]
- Order data: [paste rows: order date, PIN code, channel, order value; or a summary by PIN code]
- Period covered: [e.g. last 12 months]
- Delivery radius or travel limit that matters: [e.g. 4 km for delivery, 15 minutes for walk-ins]
- Candidate areas already in mind: [paste, or none]
Task
Find where demand is strong but poorly served, and rank the best places for a new outlet.
Steps
- Total orders, value and average order value by PIN code.
- Compare the last three months with the same three months a year earlier for growth.
- Mark each PIN code by distance band from its nearest outlet: near, edge or far.
- Score each PIN code on orders, value, growth and distance, with the weights stated.
Output format
- | PIN code | Area | Orders | Value | Avg order | Growth | Nearest outlet | Distance band | Score |
- A shortlist of three locations, each with the PIN codes it would serve and the demand it would capture.
- What the data cannot show: rent, footfall, competitors, parking; with how to check each.
- A one-paragraph recommendation.
Rules
- Say when a PIN code has too few orders to judge, under about 30 in the period.
- Never treat online orders from far areas as proof of walk-in demand.






