Last Mile Hyperlocal Dashboard_case study

Hyper-local last mile performance April 2020 For Illustrative Purposes only StrategyConnect Accelerate your strategic projects and business operations With curated workforce and solutions on-demand 2020 | UAE

Executive Summary Illustrative Date: April 01 2020 – April 30 2020 Average Delivery Time Total Drivers Available Fleet Utilization Order Number, Item ID, Item Qty, Order .5k Ras al- 1k 100% 95% 85% Value (AED), Order Date Time 80% 65% 70% Apr-24 (dd/mm/yy hh:mm:ss), Order Address Umm al-Quwain Khaimah 60% (Emirate), Order Address (Region), Ajman 40% Apr-21 Apr-22 Apr-23 Order Supermarket ID Fujairah 1k 20% 1.5k 0% 30 Mins Sharjah 1.2k Dubai 10% 1k Avg. Items/ Order Abu Dhabi 1k Peak Orders (hour) # of orders per customer 3.5 250 2 15% 20% 10% UAE © StrategyConnect 2020. All rights reserved. Private & Confidential 2

2 - Time Analysis Illustrative Date: April 01 2020 – April 30 2020 Average Delivery Time TAT: Ordered-Allocated Minutes Minutes 90 30 60 30 90 50 40 60 75 Apr-22 Apr-23 Apr-24 75 Apr-22 Apr-23 Apr-24 60 60 45 45 30 43 30 15 15 20 0 0 Apr-21 Apr-21 ** Filter Option> by Emirates, Region & Supermarket ** Filter Option> by Emirates, Region & Supermarket TAT: Allocated-Fulfilled TAT: Fulfilled-Delivered Minutes 25 35 45 Minutes 30 50 45 Apr-22 Apr-23 Apr-24 Apr-22 Apr-23 Apr-24 90 90 75 75 60 60 45 45 30 43 30 15 15 0 0 10 Apr-21 Apr-21 ** Filter Option> by Emirates, Region & Supermarket ** Filter Option> by Emirates, Region & Supermarket UAE © StrategyConnect 2020. All rights reserved. Private & Confidential 3

3 - Throughput Analysis Illustrative Date: April 01 2020 – April 30 2020 No of Supermarkets Available Peak Serviceable Capacity Per Hour .5k Ras al- 1k 1000 Umm al-Quwain Khaimah 800 Ajman Fujairah 1k 600 1.5k 400 500 600 Dubai 200 200 6:00 PM 0 1k Sharjah 1.2k 9:00 AM 12:00 PM Abu Dhabi ** Filter Option> by Emirates & Region 400 3:00 PM 1k ** Drill down> Double click to individual regions Avg. Orders Delivered/ Driver Avg. # of Orders Batching Per Delivery 20 15 15 14 13 10 3 10 5 20% 0 Apr-22 Apr-23 Apr-24 Apr-21 ** Filter Option> by Emirates, Region & Supermarket ** Filter Option> by Emirates, Region & Supermarket UAE © StrategyConnect 2020. All rights reserved. Private & Confidential 4

4 - Volume Analysis Illustrative Date: April 01 2020 – April 30 2020 % volume distribution by Item SKU Min Order (hour) % volume contributed by top 10 items Packaged Food Tomato Fish & Sea Foods 10 Ramen Noodles 10 10 Fruits & 10 30 Milk 30 Vegetables Ready to Eat 10 Yoghurt 10 20 20 Meat & Poultry 1 20 20 Frozen Chicken Dairy & Eggs 5% Pasta ** Filter Option> by Emirates, Region & Supermarket ** Filter Option> by Emirates, Region & Supermarket ** Filter Option> by Emirates, Region & Supermarket # of Orders per hour %Orders Delivered within 72 Hours 100 37 80 60 40 25 35 45 43 3:00 PM 6:00 PM 20 0 <24hrs 24-48hrs 48-72hrs >72hrs 9:00 AM 12:00 PM ** Filter Option> by Emirates, Region & Supermarket ** Filter Option> by Emirates, Region & Supermarket UAE © StrategyConnect 2020. All rights reserved. Private & Confidential 5

5 - Value Analysis Illustrative Date: April 01 2020 – April 30 2020 Average Basket Size (AED) Average Item Value (AED) Avg. value ordered per customer (AED) AED 350 AED 50 ‫إ‬.‫د‬ 10% 10% AED 1000 ** Filter Option> by Emirates, Region & Supermarket ** Filter Option> by Emirates, Region & Supermarket 5% ** Filter Option> by Emirates, Region & Supermarket UAE © StrategyConnect 2020. All rights reserved. Private & Confidential 6