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

What is the length of pipes in your country?

Hi guys,

I tried to solve this estimation/market sizing case.
I'll show you the though my process but this question is not so easy to answer in my opinion. I would appreciate criticism! :) My country is Germany. 


My basic starting points:

  • There are pipes for sewage and water
  • There are pipes for rainwater on houses, to make it easier I will not bother with those
  • Some industries use pipes for transportation of their goods (e.g. oil) but those make up a small part of the whole pipes used and therefore I will not bother about those
  • Calculate pipes for private housing and industrial usage
  • Dont forget the connection inbetween households/industry

There is no point on a calculation based on house, since houses consist of a no. of households. Therefore it's fine to only calculate on households (hh) in the first place.

We want to calculate the m of pipes per hh in Germany and add that with the m industry pipes and add that up with No. of m used for connection hh and industry.

M of pipes per household:

  1.  No. of people in Germany * No of People per hh = No of hh in Ger ~81 Mio. : 3People = 27 Mio
  2. No of hh in Ger * m of pipes (water) per hh = m of pipes (water) in germany for all hh 27 Mio. * 10 m = 270 Mio. m
  3. HH consists of sewage and water pipes therefore take times 2: 270 Mio. m * 2 = 540 Mio. m ~ 550 Mio. m
  4. => M of pipes per hh in germany = 550 Mio. m

Calculate m of pipes for Industry:

  • No. of hh that equals a industrial building * m of pipes (water & sewage) per hh = m of pipes for industrial bulding 2,5 * 20m = 50m (2,5 since we only bother on sanitary rooms)
  • No. of hh  * relation No. of industrial building to hh = No. of industrial buildings in ger  27 Mio * (1/9) = 3 Mio. 
  • => M. of pipes in Industry = 3 Mio. * 50m = 150 Mio. m

M of connections (city, land, industry):

  • Percantage hh in cities * No. of hh * m for connection = 0,7 * 27 Mio. * 5m = 90 Mio. m (in cities we have 2,5 hh per House therefore 5 m (*2,5 = 15m) seems like a good estimation for connection houses
  • Same for Land: 0,3 * 27 Mio. 10 m = 90 Mio. m
  • Industrial: No. of Buildings * m for connection = 3 Mio * 40 m = 120 Mio m.
  • => add up = 300 Mio m.

Therefore we have 1 Billion m of pipes in germany (550+150+300).

I always used easy numbers for example. In your opinion did I simplify the case to much? Do you have a faster / easier way to make a good estimation?
E.g. I did not even bother on m for connection inbetween cities etc.

Thanks a lot
Christian

1
3.0k
12
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Deleted user
on Feb 17, 2018

I think your approach has a sound logic, however I would have clarified the question to begin with, because my interpretation here is all pipes, therefore also big conduits under roadways to transport all the sewage, fresh water, etc. Also telco lines (especially fiber) and electricity are - in part - transported in pipes both within buildings and across cities

Therefore to me the big missing piece would be km of pipes under roads in Germany. Would calculate km of roads in Germany (assume germany is a square with x and y dimensions and streets crossing each dimension at z intervals) and then assume what % of roads have under them pipes and assume how many pipes at any given time (e.g. 2 or 3 or 4 depending wether is just fresh water and grey water or also fiber and electricy) and multiply the three numbers.

Hope this helps,

Andrea

7
on Feb 17, 2018
Seems fair. I'll make a suggestion tomorrow. Thank you!
Similar Questions
Consulting
I got a take-home case from a company. It is so generic. How should I approach this?
on Sep 28, 2024
Global
6
2.0k
Top answer by
Florian
Coach
1400 5-star reviews across platforms | 600+ offers | Highest-rated case book on Amazon | Uni lecturer in US, Asia, EU
58
6 Answers
2.0k Views
+3
Consulting
A&M PEPI Associate - Case Study & Excel Exercise
on Jan 25, 2025
Global
2
2.6k
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
68
2 Answers
2.6k Views
Consulting
Corporate Strategy Analyst at Agoda how best to prepare
on Jan 14, 2025
Global
6
1.7k
Top answer by
Mattijs
Coach
Free 15m intro call | First session -50% | Bain| Hiring team | 250+ successful candidates
17
6 Answers
1.7k Views
+3
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.