expert
Expert with best answer

Andrea

100% Recommendation Rate

129 Meetings

785 Q&A Upvotes

USD 269 / Coaching

1

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

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 answer

  • Upvotes
  • Date ascending
  • Date descending
Best Answer
Book a coaching with Andrea

100% Recommendation Rate

129 Meetings

785 Q&A Upvotes

USD 269 / Coaching

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

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

Seems fair. I'll make a suggestion tomorrow. Thank you! — Christian on Feb 17, 2018 (edited)

Related BootCamp article(s)

Important Facts

It's essential to know some key figures regarding geographies, population, economies for your case interviews. We summarized them for you here.

1 Q&A

Case Studies

The case study is the most important element of the case interview, which you'll have to nail in order to get into strategic consulting. Here you can learn the specific skills and concepts necessary to solve them.

Market Sizing

Market Sizing Questions are used to test your quantitative & reasoning skills. Learn more on how interviewers evaluate your given answer!

2 Q&As

Related case(s)

Oliver Wyman case: Full Electrons Ahead

Solved 79.8k times
Oliver Wyman case: Full Electrons Ahead Your client, large automotive OEM WyCar, has developed its first fully electric vehicle (EV) and introduced it as a pilot on the Austrian market last year. However, sales have been far below the expected numbers. The management has engaged you to support them in understanding the reasons and advise them on how to adjust the product offering.
4.6 5 5654
| Rating: (4.6 / 5.0)

Your client, large automotive OEM WyCar, has developed its first fully electric vehicle (EV) and introduced it as a pilot on the Austrian market last year. However, sales have been far below the expected numbers. The management has engaged you to support them in understanding the reasons and advise ... Open whole case

Bain Case: Old Winery

Solved 52.9k times
Bain Case: Old Winery You have inherited the “Old Winery” from your grandfather, a winery which has been family owned for five generations and can be dated back to the 16th century. Half of the eleven hectares are used to grow white grapes, the other half to grow red grapes. They are grown in the conventional way, i.e. they are not organically farmed and certified. The vine stocks are in a good condition regarding age and care. Overall, only ¼ of the harvest is made into wine by the winery itself; the rest is sold. Your grandfather never wanted to change the image of the winery and left the managerial and administrative task to a young and energetic wine-maker. Due to the not so well-known brand , the demand for the “Old Winery” wine is currently rather low. You do not intent to run the winery operatively, given your limited knowledge of wine making, but find the idea of owning a winery exciting. Your plan is to give the winery some fresh impetus.
4.4 5 1381
| Rating: (4.4 / 5.0)

You have inherited the “Old Winery” from your grandfather, a winery which has been family owned for five generations and can be dated back to the 16th century. Half of the eleven hectares are used to grow white grapes, the other half to grow red grapes. They are grown in the conventional way, i.e. ... Open whole case

Roland Berger Case: Onlinestar

Solved 35.4k times
Roland Berger Case: Onlinestar Onlinestar, an online retailer of furniture and garden products (core business), has grown significantly in recent years as a result of an expansion of its product portfolio. The company mainly imports goods from Chinese manufacturers but also operates its own production of cat lavatories (special business) in Eastern Europe. The company sells its goods via Amazon and ebay, and recently via an online shop on its website. Despite this development, the financial ratios have deteriorated in recent years. In particular, gross profit margin decreased significantly. Combined with a significant increase in shipping costs, this led to a negative result for the first time in the recently ended fiscal year and a resulting strained financial situation. Against the background of expected stagnating sales for the current financial year, short-term action is required. The board of Onlinestar asks you for an analysis of the reasons for the negative result as well as a derived recommendation for action. As a consultant, you should bring in your knowledge in online trading and develop solutions. In addition, the management board would like to receive a sales and gross profit plan from you for the current financial year.
4.3 5 747
| Rating: (4.3 / 5.0)

Onlinestar, an online retailer of furniture and garden products (core business), has grown significantly in recent years as a result of an expansion of its product portfolio. The company mainly imports goods from Chinese manufacturers but also operates its own production of cat lavatories (special b ... Open whole case

TKMC Case: Elevators

Solved 17.0k times
TKMC Case: Elevators Your customer is the market leader in the North American elevator service business. This is divided into the areas of elevator construction, elevator modernization and service. The customer has a particularly strong branch network in medium-sized cities and would now like to expand its business in bigger city centers. His next target is Manhattan and he wonders how big the potential is.
4.2 5 1259
| Rating: (4.2 / 5.0)

Your customer is the market leader in the North American elevator service business. This is divided into the areas of elevator construction, elevator modernization and service. The customer has a particularly strong branch network in medium-sized cities and would now like to expand its business in ... Open whole case

DB MC Case: Einstieg in das internationale Fernbusgeschäft

Solved 5.2k times
DB MC Case: Einstieg in das internationale Fernbusgeschäft Für Unternehmen ergeben sich durch die Digitalisierung neue Chancen und Risiken. Neue Märkte mit großem Potenzial können erschlossen werden – gleichzeitig erhöhen Wettbewerber den Konkurrenzdruck. KMUs, Start-ups und Konzerne bringen unterschiedliche Kompetenzen und finanzielle Möglichkeiten mit. Erst vor wenigen Jahren ist ein Start-up mit Know-how im Online-Vertrieb nach der Änderung des Personenbeförderungsgesetzes in den deutschen Fernbusmarkt eingetreten, welches schnell ein großes Netzwerk an Subunternehmen aufgebaut und damit große Marktanteile gewonnen hat. Dies hatte erheblichen Einfluss auf das Kerngeschäft der Deutschen Bahn. Mit dem Ziel Synergien zu nutzen und die Bedürfnisse des Kunden ganzheitlich zu erfüllen, konzentriert sich die Deutsche Bahn nicht allein auf ihre bisherigen Geschäftsmodelle, sondern kooperiert mit anderen „Mobility-Unternehmen“. Von Ihrem Kunden aus dem Topmanagement wurden Sie als Consultant von DB Management Consulting beauftragt, einen Business Case zu bewerten und zu prüfen, ob die Deutsche Bahn ihr bisheriges Geschäftsmodell öffnen sollte, um durch die Kooperation mit einem etablierten mittelständischen Busunternehmen in das internationale Fernbusgeschäft einzusteigen. Die Deutsche Bahn bietet bereits wenige internationale Verbindungen der Marke „IC Bus“ an, jedoch hat die DB-Tochter in der Vergangenheit große Marktanteile verloren. Im Rahmen der Einführung soll dem Kunden zunächst die Verbindung Hamburg – Lund (Schweden) ohne Zwischenstopp in 7 Stunden angeboten werden. Die Distanz zwischen Lund und Hamburg liegt bei 385 km. Bei erfolgreichem Start ist ein schnelles Roll-out auf andere internationale sowie deutschlandweite Strecken geplant. Im Fokus stehen die Erhöhung des Marktanteils, die Bewertung der Nachfrage des Kunden, der Kosten und Erlöse sowie das prognostizierbare Wachstum im Fernbusmarkt.
4.3 5 114
| Rating: (4.3 / 5.0)

Für Unternehmen ergeben sich durch die Digitalisierung neue Chancen und Risiken. Neue Märkte mit großem Potenzial können erschlossen werden – gleichzeitig erhöhen Wettbewerber den Konkurrenzdruck. KMUs, Start-ups und Konzerne bringen unterschiedliche Kompetenzen und finanzielle Möglichkeiten mit. Er ... Open whole case