Logistics Snapshot — B2C / B2B

Major Wins

Improved Order-to-Ship & Order-to-Delivery performance between May and June 2026.

Started regional warehouse utilization.

Started NDR calling activity.

What's Keeping Me Awake

Only 70% of orders are delivered within 5 days.

PO-to-Delivery currently under 10 days — going forward, target is under 7 days for 90% of orders.

RTO % reduction is closely linked to COD % — cutting COD share is key to driving RTO down further.

Order-to-delivery journey timeline needs improvement — overall transit time must come down.

Upcoming

Launch Dark Stores in Mumbai, Delhi, Guwahati & Kolkata.

With better inventory replication across all warehouses, we can deliver stock in under 7 days.

Decision To Be TakenBy 2028

Splitting the warehouse network into three dedicated zones — RTD, Non-RTD, and D2C.

Key Observations / My One Big Bet

Improve inventory replication Weekly → Monthly.

Implement direct factory-to-regional-warehouse dispatches.

Maintain 45 days of inventory for Star SKUs across all warehouses, covering 60–70% of sales.

What This Dashboard Covers

Warehouse Planning

Order-volume growth trajectory (Sep 2025 → Sep 2028), warehouse order-split by facility (Mar & June 2026 actual, plus projected milestones), state-wise demand & RTO projection, and coverage maps showing new warehouse/dark-store rollout by milestone.

→ Warehouse Planning in the sidebar

Dark Store Locator — Mumbai / India

Pincode-level view of dark-store service radius and region breakdowns, RTO % by pincode, click-to-locate map, date filters, and a combined multi-region Excel export.

→ Dark Store Locator in the sidebar

May vs June (2026)

Side-by-side comparison of May and June 2026 — KPIs, facility share, RTO by distance zone, delivery TAT distribution, cumulative O2S/O2D/S2D curves, payment mode & channel split, and a 6-month (Jan–Jun) snapshot trend.

→ May vs June (2026) in the sidebar

Future Plans — RTO Reduction Roadmap

NDR Address HygieneQuick Win

Remove gibberish / incomplete addresses at the time of order placing so it will reduce future RTO orders

Real-time PIN → city/state auto-fill at checkout; flag if address <20 chars or missing area/landmark

Blacklist repeat-return phone/address: >3 RTOs in 90 days → prepaid-only or manual review

D2C — Data-Driven ActionsFrom Jan–Jun Data

Dark store model for metro cities (Delhi NCR, Mumbai, Bangalore) — 4–6 hour delivery cuts RTO by 5–10% through faster fulfillment and fewer failed attempts

Prepaid incentive in top RTO states (Arunachal Pradesh (38%), Bihar (35%), Tripura (33%), Assam (31%), Jammu & Kashmir (31%)) — ₹50–100 cashback shifts COD→prepaid, drops RTO 8–12 pts

Warehouse Safety & OperationsOperational Excellence

100% VMS scanning of every order — reduces missing/mismatched product complaints

3-month inventory audit recon — physical vs system count; >0.5% gap triggers root-cause before next cycle

VMS: 1 mistake per 5,000 orders (99.98% accuracy) — picker score tracked; below threshold = retraining before solo picking

FIFO bin management — oldest stock picked first, reduces dead/expiry risk

Damaged goods quarantine zone — no defective unit back in sellable stock without QC sign-off

CCTV on all pick-pack stations, 30-day footage retention — used for wrong/missing item dispute resolution

Daily shrinkage report — >0.1% of daily throughput triggers management alert + zone investigation