Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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 %
Step by Step Solution
★★★★★
3.44 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
PL Structure and FY2021 Budget To build the PL structure and budget you need to categorize each subcost center under the respective headers Based on the given PL structure heres an example of how you ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started