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 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 M DI ST 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? Business Case Orders & basket size I 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. June Commission June Order vol July Gross food value July Order Vol Commission Rejected June Gross food value Ratinge Now Customer to platform Customer frequency New customer to restaurant Restaurant 203 180 70333 61294 25 50 BO 1.6 2 45 Restaurant B 400 577 55687 72765 27% 123 169 1.9 5 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? 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 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 M DI ST 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? Business Case Orders & basket size I 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. June Commission June Order vol July Gross food value July Order Vol Commission Rejected June Gross food value Ratinge Now Customer to platform Customer frequency New customer to restaurant Restaurant 203 180 70333 61294 25 50 BO 1.6 2 45 Restaurant B 400 577 55687 72765 27% 123 169 1.9 5 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