The $77M Delivery Trap: Why Uber Eats & DoorDash Drive 61% of Orders but Only 5% of Profit

Описание: In this comprehensive forensic analytics presentation, we investigate the multi-channel economics of 1,696 commercial dining venues across SkyCity Auckland, representing 2.02M monthly customer orders and $77.74M in gross consumer spend.

🚨 The Core Paradox Revealed:
While third-party delivery aggregators (Uber Eats and DoorDash) command 61.2% of total order volume, they generate merely 5.2% of the industry's net profit pool (at an anemic 0.86% net margin). Meanwhile, direct dining channels (In-Store walk-in and Self-Delivery fleets) capture 38.8% of volume, yet deliver 94.8% of all net retained profit ($7.46M/month at a 24.7% margin).

Furthermore, our forensic audit uncovers the "Full-Service Deficit": all 452 full-service restaurants in Auckland lose money on third-party delivery apps (-17.5% net loss), creating a collective $2.20M monthly drain.

Watch the complete executive briefing, forensic waterfall decomposition, and live counterfactual profit-recovery simulation.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
⏱️ CHAPTER TIMESTAMPS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
00:00 - Slide 1: Title & Strategic Context
01:26 - Slide 2: Problem Statement & The Information Void
03:13 - Slide 3: Dataset Architecture, Scope & Empirical Depth
04:52 - Slide 4: Data Pipeline, Schema Reconciliation & 9 Conservation Proofs
06:25 - Slide 5: How Our Deployed Streamlit Application Resolves the Crisis
07:39 - Slide 6: Deployed Application Modules & Decision Workflows
09:06 - Slide 7: Ecosystem Headline KPIs & Profit Divergence
10:38 - Slide 8: Revenue-to-Net Profit Waterfall & Channel Unit Economics
12:15 - Slide 9: Channel Market Share & Margin Breakdown
13:40 - Slide 10: Subregional Dynamics & Compounded Growth Modeling
15:12 - Slide 11: Cuisine Delivery Splits & Fleet Models (The Pizza Blueprint)
16:13 - Slide 12: Dining Segment Vulnerability & The Full-Service Deficit
17:27 - Slide 13: Channel Dependency Risk Engine & Calibration
18:48 - Slide 14: Interactive Profit-Recovery Scenario Simulator
20:16 - Slide 15: Phased Implementation Timeline & Stakeholder ROI
21:49 - Slide 16: Methodological Governance, Limitations & Conclusion

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
📊 KEY FINDINGS SUMMARY
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
• Aggregator Commission Leakage: Third-party apps extract $14.29M/month in commissions (nearly double the entire net profit retained by all 1,696 restaurant owners combined).
• The Pizza Blueprint: Pizza operators fulfill 45% of deliveries via internal courier fleets, saving 13% margin per order.
• Profit Recovery Levers: Migrating just 15% of aggregator orders to self-delivery recovers +$1.57M/month (+19.9% net profit expansion). A 20% statutory commission cap returns +$4.77M/month back into the local culinary economy.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ TECH STACK & METHODOLOGY
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
• Analytics Engine: Python 3.11, Pandas, NumPy, Apache Parquet
• Interactive Cockpit: Streamlit, Plotly, HTML5/CSS3 Aurora Glassmorphism
• Validation: 9 Formal Mathematical Conservation Identity Checks (100% Pass Rate)

#DataScience #BusinessAnalytics #HospitalityTech #UberEats #FoodDelivery #Streamlit #Python #ExecutiveStrategy #SkyCity