Can someone help me create two P&L's for this case? (From Deloitte's website)

TR asked on Oct 06, 2018

Using the provided data, model a P&L for both business model options (Model A and Model B) for year one. Calculate operating profit (ignore interest, taxes, and depreciation) and round dollar amounts to the nearest $100K. Deloitte Case Interview


2 answers

  • Upvotes
  • Date ascending
  • Date descending
Best Answer
Kay replied on Oct 06, 2018
Preparing for McKinsey interviews.

Hi TR!

So, this looks quite intimidating but actually it not very difficult to do - you just need to break the information down.

I'm not sure about the format they want your answer presented in, but if this is a P&L statement here is how I would format the information:

All revenue and cost streams form the headings for the rows (group revenue together first, then add a totals row, then list the costs below and a total row for costs below, and finally a profit column at the bottom), the four different carriers as column headings (and a totals column at the end). Then start filling in.

Your revenue streams are: Post-paid phone commission, accessories commision (per attachment, so multiply by attachment rate per phone), average price.

Your costs are: marketing, distribution/storage, overhead, kiosk rent, employee/staffing.

Separate them for the two type of plans (I am assuming this is what they refer to when asking for two business model options).

The last step is to fill in your worksheet(s). You'll need to use different graphs for the different costs/revenues, but overall doesn't look difficult - just a fair amount of work.

Good luck! Any more questions, just ask.

Thank you! — TR on Oct 07, 2018

replied on Oct 08, 2018
Experienced strategy consultant, now running own consulting business
Book a coaching with Elias

2 Meetings

290 Q&A Upvotes

USD 149 / Coaching

Model A is the model for carrier 1

Model B is Carriers 2-4

Ah, you’re right! That makes sense. — Kay on Oct 08, 2018

Related case(s)

Deloitte Consulting case: Footloose

Solved 50.8k times
4.5 5 12499
| Rating: (4.5 / 5.0)

Duraflex is a German footwear company with annual men’s footwear sales of approximately €1 b. They have always relied on the boot market for the majority of their volume. In this market they compete with three other major competitors. In the fall of 2013, Badger – one of Duraflex’s competitiors – ... Open whole case