Business Case Orders & basket size Restaurant A does 90 orders on foodpanda in the month of July 2019. The average basket size of Restaurant A is $18.30. From the time it is on FP till July 2020., this restaurant increases its orders by 10% month on month. From July 2019 to July 2020 restaurant A makes 25% more Gross Food Value on GrabFood than Foodpanda. Restaurant A pays $12,621.5 to GF for commission revenue. 1) On an excel sheet/google sheet, -show how you would calculate the MoM order number of restaurant A on foodpanda -show how you would calculate the total GFV restaurant A made on both foodpanda and Grabfood from July 2019 to July 2020 - The commission % Grabfood is charging restaurant A. 2) List down 3 ways that you would grow the basket size and gross food value of Restaurant A. Traffic & conversion In June, Restaurant A attracted 1000 views on their landing page. However, between landing to the menu, payment and eventually checkout, Restaurant A does 76 orders. In July, Restaurant A attracted 124% of the sessions it attracted in June. However, the total order number in July went up by 100%. The basket size of Restaurant Als $15.20. 1) Calculate Restaurant A's conversion % in June and July. Calculate the incremental month on monthly Gross Food Value. I 2) What could be 2 possible reasons for the changes between June & July in Sessions count conversion % Order count -Gross Food Value Vendor operational and business numbers Business Case Orders & basket size Restaurant A does 90 orders on foodpanda in the month of July 2019. The average basket size of Restaurant A is $18.30. From the time it is on FP till July 2020., this restaurant increases its orders by 10% month on month. From July 2019 to July 2020 restaurant A makes 25% more Gross Food Value on GrabFood than Foodpanda. Restaurant A pays $12,621.5 to GF for commission revenue. 1) On an excel sheet/google sheet, -show how you would calculate the MoM order number of restaurant A on foodpanda -show how you would calculate the total GFV restaurant A made on both foodpanda and Grabfood from July 2019 to July 2020 - The commission % Grabfood is charging restaurant A. 2) List down 3 ways that you would grow the basket size and gross food value of Restaurant A. Traffic & conversion In June, Restaurant A attracted 1000 views on their landing page. However, between landing to the menu, payment and eventually checkout, Restaurant A does 76 orders. In July, Restaurant A attracted 124% of the sessions it attracted in June. However, the total order number in July went up by 100%. The basket size of Restaurant Als $15.20. 1) Calculate Restaurant A's conversion % in June and July. Calculate the incremental month on monthly Gross Food Value. I 2) What could be 2 possible reasons for the changes between June & July in Sessions count conversion % Order count -Gross Food Value Vendor operational and business numbers