Restaurant A does 90 orders on foodpanda in the month of July 2019. The average basket...

 

  

Transcribed Image Text:

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. 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 A is $15.20. 1) Calculate Restaurant A's conversion % in June and July. Calculate the incremental month on monthly Gross Food Value. 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 July Order Vol June Gross food value July Gross food value June Commission June Order vol New customer to platform New customer Customer Rojected % Ratings Kouenbag to restaurant Restaurant A 203 180 70333 61294 25 50 80 1.6 4.5 Restaurant B 400 577 55687 72765 27% 123 169 1.9 4.1 Above are the numbers of 2 vendors in Taiwan for the month of June & July. From the information, 1) Share 2 characteristics of the restaurant A & B 2) Share 2 reasons explaining the movement of order volume from June and July for both restaurants 3) Which restaurant would you recommend for the company to invest in and why? 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. 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 A is $15.20. 1) Calculate Restaurant A's conversion % in June and July. Calculate the incremental month on monthly Gross Food Value. 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 July Order Vol June Gross food value July Gross food value June Commission June Order vol New customer to platform New customer Customer Rojected % Ratings Kouenbag to restaurant Restaurant A 203 180 70333 61294 25 50 80 1.6 4.5 Restaurant B 400 577 55687 72765 27% 123 169 1.9 4.1 Above are the numbers of 2 vendors in Taiwan for the month of June & July. From the information, 1) Share 2 characteristics of the restaurant A & B 2) Share 2 reasons explaining the movement of order volume from June and July for both restaurants 3) Which restaurant would you recommend for the company to invest in and why?

Answer rating: 100% (QA)

Answer Calculate MOM order of R... View the full answer