Auckland Restaurant Market Analyser
This project examines the impact of different ordering channels, such as Uber Eats, DoorDash, self-delivery, and in-store sales, on restaurant profitability in Auckland, utilising a synthetic dataset of 1,696 restaurants. From average order values to delivery costs, the analysis reveals surprising insights, including that self-delivery can often outperform third-party apps in net profit.
Go To Simulation
Introduction:
Restaurants in Auckland face a complex landscape of ordering channels: third-party delivery apps like Uber Eats, Door Dash and Hungry Panda and traditional in-store sales. The self-delivery channel is rarely used by any restaurant. Understanding how each channel impacts profitability, operating costs, and overall financial health is critical for business decisions. To explore this, we have created fully synthetic dataset of 1696 fictional Auckland restaurants based on data collected from industry journals, capturing key metrics such as monthly orders, average order values, channel splits, COGS, OPEX, commissions, and delivery costs. Descriptive statistics show wide variation in order volumes and revenue across channels, highlighting the diversity of restaurant operations in the region. Each variable captures a unique aspect of restaurant operations, from order volumes across channels to revenue cost structures and delivery logistics.
Key highlights from descriptive statistics include:
- Order Volumes: Monthly orders range from 441 to 2,337, with Uber Eats consistently leading channel share (48%), followed by DoorDash (26%) and Self-Delivery (25%).
- Revenue & Profit: Average AOV is $38.50. In-store and self-delivery channels show higher variance in net profit, including some restaurants with negative profits under stress scenarios.
- Cost Structure: COGS rates range from 20% to 40%, OPEX from 20 to 55%, and third-party commissions from 27% to 33%, reflecting realistic operational overhead.
Delivery Metrics: Average delivery radius is ~10.5 km; petrol-based delivery costs vary ~$0.89–$5.31 per order, with stress scenarios and EV adoption impacting profitability significantly.
This summary sets the stage for deeper channel analysis, stress testing, and** “what-if”** scenario simulations to uncover profitability patterns and operational resilience.
Project Narrative:
Our approach involved simulating realistic operational and financial data for restaurants using probabilistic distributions informed by industry benchmarks. We performed exploratory data analysis to understand channel performance; built stress test scenarios to examine resilience under adverse conditions (e.g., high OPEX, rising delivery costs); and modelled delivery cost variations, including EV adoption scenarios. One unique angle was comparing net profits across channels under stress, revealing that self-delivery can often yield higher margins than expected, a surprising insight given the volume-driven dominance of third-party apps.
The AOV (Average Order Value) is tightly controlled within the range of $29.79 to $47.23.
However, the range check just uncovered a massive disparity in your synthetic logic regarding net profit versus in-store share.
Key Observation:
- The third party “Delivery Trap”: 31.7% (538 out of 1,696 restaurants) is losing money on Uber Eats. Third-party delivery apps provide stable, low-margin profits, while self-delivery and in-store operations show higher variance but potentially greater profitability.
- Operational costs matter; rising OPEX or delivery expenses can quickly turn profitable channels into loss-making ones. Stress testing highlights which restaurants and segments are most vulnerable.
- Stress tests and “what-if” scenarios provide actionable insights into financial resilience, helping restaurant owners anticipate risk under changing market conditions.
Watch this space for more deep dives into Auckland restaurant economics, channel strategy simulations, and actionable insights for restaurateurs.
Check out our interactive simulation, where you can experiment with different scenarios to explore profitability and strategy:
(https://orderflow-simulation.pages.dev)