Case Illustration Pop Meals is Southeast Asia's fastest growing omnichannel food brand, currently operating through...

 
   
 

Transcribed Image Text:

Case Illustration • Pop Meals is Southeast Asia's fastest growing omnichannel food brand, currently operating through mix model of online delivery, pick-up and app-driven dine-in. • For FY2021, Pop Meals has ambitious goal to open 60 new outlets in Malaysia by the end of the year and hitting EBITDA of 25%. YTD (Jan-April) we have opened 15 outlets. ● COVID effect is still seen, with fluctuations numbers of cases and varying degree of movement restrictions imposed by the government. Your mission as Financial Analyst Build PnL structure and FY2021 budget based on your understanding of the business. Categorise each sub of cost centres under the respective header provided in Appendix 1. Highlight 3 WCGW (What Could Go Wrong) areas from the respective cost centres above. Model revenue in 3 scenarios: 1) strict lockdown (no dine-in allowed, no inter-district traveling allowed), 2) CMCO (dine-in allowed at 50% capacity), and 3) RMCO (dine-in allowed at 100% capacity). Any other PnL line item could be held constant. Use excel file to build the model structure and any other data assumptions. ● ● ● Prepare the analysis and reason behind your numbers. Present the P&L to Finance Manager. Golden Rule to Follow You may utilise additional resources publicly available like our app/website/ outlet to understand menu offering, pricing, and payments infrastructure, any other components of our financials (loyalties, wallet, etc). Final projected EBITDA of 25% can not be changed. No hard-coding. Formularise the deliverables. Explain the reasoning behind your assumptions with notes if necessary. No actual absolute numbers are required; you may utilise industry-average as benchmark of % of those costs. Only PnL model is required. Present your finding in 2 files: 1 excel file, 1 PPT file (maximum 5 slides including cover page, WCGW areas, summarised revenue, summarised PnL, recommendation) Appendix 1: PnL Structure PnL Line Item Revenue Variable Cost Semi-Variable Cost Contribution Margin Fixed Cost General and Admin Expenses Marketing Expenses EBITDA Amount % Case Illustration • Pop Meals is Southeast Asia's fastest growing omnichannel food brand, currently operating through mix model of online delivery, pick-up and app-driven dine-in. • For FY2021, Pop Meals has ambitious goal to open 60 new outlets in Malaysia by the end of the year and hitting EBITDA of 25%. YTD (Jan-April) we have opened 15 outlets. ● COVID effect is still seen, with fluctuations numbers of cases and varying degree of movement restrictions imposed by the government. Your mission as Financial Analyst Build PnL structure and FY2021 budget based on your understanding of the business. Categorise each sub of cost centres under the respective header provided in Appendix 1. Highlight 3 WCGW (What Could Go Wrong) areas from the respective cost centres above. Model revenue in 3 scenarios: 1) strict lockdown (no dine-in allowed, no inter-district traveling allowed), 2) CMCO (dine-in allowed at 50% capacity), and 3) RMCO (dine-in allowed at 100% capacity). Any other PnL line item could be held constant. Use excel file to build the model structure and any other data assumptions. ● ● ● Prepare the analysis and reason behind your numbers. Present the P&L to Finance Manager. Golden Rule to Follow You may utilise additional resources publicly available like our app/website/ outlet to understand menu offering, pricing, and payments infrastructure, any other components of our financials (loyalties, wallet, etc). Final projected EBITDA of 25% can not be changed. No hard-coding. Formularise the deliverables. Explain the reasoning behind your assumptions with notes if necessary. No actual absolute numbers are required; you may utilise industry-average as benchmark of % of those costs. Only PnL model is required. Present your finding in 2 files: 1 excel file, 1 PPT file (maximum 5 slides including cover page, WCGW areas, summarised revenue, summarised PnL, recommendation) Appendix 1: PnL Structure PnL Line Item Revenue Variable Cost Semi-Variable Cost Contribution Margin Fixed Cost General and Admin Expenses Marketing Expenses EBITDA Amount % Case Illustration • Pop Meals is Southeast Asia's fastest growing omnichannel food brand, currently operating through mix model of online delivery, pick-up and app-driven dine-in. • For FY2021, Pop Meals has ambitious goal to open 60 new outlets in Malaysia by the end of the year and hitting EBITDA of 25%. YTD (Jan-April) we have opened 15 outlets. ● COVID effect is still seen, with fluctuations numbers of cases and varying degree of movement restrictions imposed by the government. Your mission as Financial Analyst Build PnL structure and FY2021 budget based on your understanding of the business. Categorise each sub of cost centres under the respective header provided in Appendix 1. Highlight 3 WCGW (What Could Go Wrong) areas from the respective cost centres above. Model revenue in 3 scenarios: 1) strict lockdown (no dine-in allowed, no inter-district traveling allowed), 2) CMCO (dine-in allowed at 50% capacity), and 3) RMCO (dine-in allowed at 100% capacity). Any other PnL line item could be held constant. Use excel file to build the model structure and any other data assumptions. ● ● ● Prepare the analysis and reason behind your numbers. Present the P&L to Finance Manager. Golden Rule to Follow You may utilise additional resources publicly available like our app/website/ outlet to understand menu offering, pricing, and payments infrastructure, any other components of our financials (loyalties, wallet, etc). Final projected EBITDA of 25% can not be changed. No hard-coding. Formularise the deliverables. Explain the reasoning behind your assumptions with notes if necessary. No actual absolute numbers are required; you may utilise industry-average as benchmark of % of those costs. Only PnL model is required. Present your finding in 2 files: 1 excel file, 1 PPT file (maximum 5 slides including cover page, WCGW areas, summarised revenue, summarised PnL, recommendation) Appendix 1: PnL Structure PnL Line Item Revenue Variable Cost Semi-Variable Cost Contribution Margin Fixed Cost General and Admin Expenses Marketing Expenses EBITDA Amount % Case Illustration • Pop Meals is Southeast Asia's fastest growing omnichannel food brand, currently operating through mix model of online delivery, pick-up and app-driven dine-in. • For FY2021, Pop Meals has ambitious goal to open 60 new outlets in Malaysia by the end of the year and hitting EBITDA of 25%. YTD (Jan-April) we have opened 15 outlets. ● COVID effect is still seen, with fluctuations numbers of cases and varying degree of movement restrictions imposed by the government. Your mission as Financial Analyst Build PnL structure and FY2021 budget based on your understanding of the business. Categorise each sub of cost centres under the respective header provided in Appendix 1. Highlight 3 WCGW (What Could Go Wrong) areas from the respective cost centres above. Model revenue in 3 scenarios: 1) strict lockdown (no dine-in allowed, no inter-district traveling allowed), 2) CMCO (dine-in allowed at 50% capacity), and 3) RMCO (dine-in allowed at 100% capacity). Any other PnL line item could be held constant. Use excel file to build the model structure and any other data assumptions. ● ● ● Prepare the analysis and reason behind your numbers. Present the P&L to Finance Manager. Golden Rule to Follow You may utilise additional resources publicly available like our app/website/ outlet to understand menu offering, pricing, and payments infrastructure, any other components of our financials (loyalties, wallet, etc). Final projected EBITDA of 25% can not be changed. No hard-coding. Formularise the deliverables. Explain the reasoning behind your assumptions with notes if necessary. No actual absolute numbers are required; you may utilise industry-average as benchmark of % of those costs. Only PnL model is required. Present your finding in 2 files: 1 excel file, 1 PPT file (maximum 5 slides including cover page, WCGW areas, summarised revenue, summarised PnL, recommendation) Appendix 1: PnL Structure PnL Line Item Revenue Variable Cost Semi-Variable Cost Contribution Margin Fixed Cost General and Admin Expenses Marketing Expenses EBITDA Amount %

Answer rating: 100% (QA)

To address this task Ill guide you through the steps required to build the PL model categorize cost centers highlight potential risks model revenue in ... View the full answer