Answered step by step
Verified Expert Solution
Link Copied!

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. For

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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. O 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 Amount % Revenue Variable Cost Semi-Variable Cost Contribution Margin Fixed Cost General and Admin Expenses Marketing Expenses EBITDA 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. O 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 Amount % Revenue Variable Cost Semi-Variable Cost Contribution Margin Fixed Cost General and Admin Expenses Marketing Expenses EBITDA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Chapters 1-30

Authors: David Haddock, John Price, Michael Farina

16th Edition

1260247902, 978-1260247909

More Books

Students also viewed these Accounting questions

Question

Describe the federal estate and gift tax system.

Answered: 1 week ago