Calculation of sales planning and gross profit planning

Roland Berger Case: Onlinestar
New answer on Apr 27, 2020
2 Answers
661 Views
Yaxin
Premium
asked on Apr 25, 2020

Hey! I would like to know why the sales planning is EUR 501.5m here? How is this calculated?

And for gross profit planning, I think we should use the sales planning number as the basis to multipy gross margin. Why do we use the EUR 590m which is a current year number?

Many thanks!

Overview of answers

Upvotes
  • Upvotes
  • Date ascending
  • Date descending
Best answer
Luca
Expert
Content Creator
replied on Apr 26, 2020
BCG |NASA |20+ interviews with 100% success rate| 120+ students coached |GMAT expert 780/800 score

Hello Yaxin,

I will try to make it clear for you. For the sales planning of the next yea, you can consider:

  • Sales of the last fiscal year = 660M€
  • Termination of production and sale of cat lavatories: -70M€ (table 3)
  • Adjustment of the product portfolio removing products <5€ : 15% * 590M€= 88.5M€ (Diagram 1)
  • Sales of next year = 660 - 70 - 88.5 = 501.5 M€

Regarding the gross profit planning, you use the 590M€ just to multiply it by the percentage that you have in diagram 1, in order to calculate the volume. It's enough not to consider the cat lavatories and the artciles <5€ to have the answer for the next year.

Does it make sense?Feel free to text me for any urther question.

Best,
Luca

Was this answer helpful?
Yaxin on Apr 26, 2020

Hey Luca! Thanks for your answer. I think it does help me understand it better. I am just wondering why we can't use 501.5 M€ as the basis for the second question to multiply it by the margin.

Luca on Apr 26, 2020

Because those margins refer to the 590M€ basis, pm me if it's still not clear

Yaxin on Apr 26, 2020

Yeah quite clear now. Thanks a lot!

Anonymous replied on Apr 27, 2020

Hi Yaxin,

I agree with Luca

Best,

André

Was this answer helpful?
4
Luca gave the best answer

Luca

Content Creator
BCG |NASA |20+ interviews with 100% success rate| 120+ students coached |GMAT expert 780/800 score
56
Meetings
2,683
Q&A Upvotes
29
Awards
19 Reviews