Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Interview Partners to connect and practice with!
Back to overview
Anonymous A
on Oct 19, 2020
Global
Question about

Can someone help me to understand the calculations?

I went through this case and found out that the calculations were strange.

Exhibit 3: DPDHL Carbon Footprint 2017the calculations are abit off.

For example, based on my calculation, the total emission should be 2.1 + 9.7 + 14.7 + 2.3 = 28.8 instead of 28.44.

Exhibit 4: Calculation Quantitative Analysis - I cant follow the logic; I think the way the author do the computation on excel was poor. Furthermore, I still managed to follow the flow, however, I couldnt get the same results.

1. How to calculate Total Emission for Road and Air?

2. How to get the Total Emission for Overseas Festivals? Should it be a basic summation of Road and Air?

Can someone enlighten me? :)

1
3.0k
12
Be the first to answer!
Nobody has responded to this question yet.
Top answer
on Nov 13, 2020

I agree that the computations in this case are completely off, however I also cannot agree with your computation.

I found the following:
- 1.5 + 0.6 = 2.1
- 5 + 4.7 = 9.7
- 14.5 + 0.1 = 14.6
- 1.5 + 0.8 = 2.3

- 2.1 + 9.7 + 14.6 + 2.3 = 28.7

I translated the other quantitative part of this case into an excel file which I cannot upload here unfortunately, so you will have to deal with this screenshot.

The numbers below should be the correct answers to the following two questions:
- What is the total amount of CO2 emissions for the festival: 31248 ton
- What percentage of the total carbon footprint of DPDHL is taken up by the festival: 0.11% (note that this percentage is calculated based on a total emission of 28.44 Mton instead of the correct 28.7 Mton. However, the difference is so small that due to rounding the percentage would still be 0.11%)

If we look at exhibit 4 we can see some strange things happening. For some reason the total emissions for the transportation over the road for the European festivals seem to magically change from 756 to 436 ton. This is simply impossible.

I hope this anwer prevents any further victims of this vague case.

Good luck practising!

3
Similar Questions
Consulting
How should I explain a change in course at university? Will it be asked of me?
on Apr 14, 2025
Global
10
3.7k
Top answer by
Alessa
Coach
xMcKinsey & Company | xBCG | +200 individual & group coachings | feel free to schedule a 15 min intro call for free
81
10 Answers
3.7k Views
+7
Consulting
Just did the Mckinsey Solve Game (January 2025) - got some questions/insights
on Apr 24, 2025
Global
5
3.9k
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
42
5 Answers
3.9k Views
+2
Consulting
Want IAPP AIGP (Artificial Intelligence Governance Professional) Exam sample Questions
on Apr 14, 2025
Global
4
2.5k
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
56
4 Answers
2.5k Views
+1
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
Thanks for your feedback! Your opinion helps us make PrepLounge even better.