Get Active in Our Amazing Community of Over 463,000 Peers!

Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Case Partners to connect and practice with!

Calculation of sales planning and gross profit planning

Roland Berger Case: Onlinestar
New answer on Apr 27, 2020
2 Answers
1.3 k Views
Jaelyn
Proficient
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 | SDA Bocconi & Cattolica partner | GMAT expert 780/800 score | 200+ students coached

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?
Jaelyn 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

Jaelyn 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 | SDA Bocconi & Cattolica partner | GMAT expert 780/800 score | 200+ students coached
66
Meetings
3,153
Q&A Upvotes
33
Awards
5.0
20 Reviews
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
You are a true consultant! Thank you for consulting us on how to make PrepLounge even better!