You'll get access to over 3,000 product manager interview questions and answers
Recommended by over 100k members
2. Will not consider military ones
3. Considering all external conditions( weather, delays, etc) fine
Assumptions #1: Though its known that India as ~137 airports in total( but if you do not know then you can guess it)
1. India has around ~800 disctricts
2. All Metro and tier1, tier 2 cities, some tier3 have airports
mathematically: Metro & tier 1 will have 100% airport: 9 cities( bengaluru, kolkata,delhi,mumbai,chennai,hyderabad,ahmedabad,kochi,goa)
Assumption # 2 airport penetration:
Tier 2: 104 cities (70%)= 70
Tier3: ~400 cities(15%)= 60
Total airports: 70+60+9= ~140 airports
Total runways: Delhi has 4 and rest of metro and tier 1 has 2 and 1 airports, that gives us: 17 runways
rest of tier 2 and tier 3 cities airports have only 1 runway= 130 runways
Total runways in india: 130+17= 147 runways
Assumption #3: if a airplane takes 15 mins to take off, then in an hour 4 airplanes will take off from a single runway.
Total airplabes taking off in an hour = 147*5= 588 airplanes.
So in India in an hour ~600 planes are in air.
How about the approach below?
Task:
Number of aircraft in the air in a given hour. Assuming all aircraft, globally
Structure:
- Let's calculate value for commercial aircraft (hypothesis: makes up largest category of planes in air at any given point)
- We can scale-up to all aircraft with a set of broad-stroke assumptions (e.g., % share of total flight time that is commercial / GA / military)
Approach:
# of commercial aircraft in air in given hour = total # of commercial aircraft * p(air)
Note: p(air) = probability that a commercial aircraft is in the air at any given time. It is assumed constant throughout the day (though not correct, because population isn't evenly distributed around the world)
So, let's calculate:
- p(air): An average flight is probably ~4 hours long, with a turnaround time of ~2 hours. Assuming planes are 'resting' for ~6 hours overnight (e.g., because no point flying a plane back at night with no passengers), a plane is in the air for ~12 hours per day. p(air) = ~0.5
- total # of commercial aircraft active globally: # of airlines * # of aircraft / airline * % of aircraft in service
- # of airlines - roughly 3 large airlines per country, 200 countries -> ~600 airlines
- # of aircraft / airline - ~40 - very large range here from probably ~500 aircraft on top end to ~1-2 aircraft on bottom end. ~40 aircraft seems reasonable
- % of aircraft active - 80% - need to be high to keep aircraft utilised
Interestingly enough: The real answer (from real data) for commercial aircraft is ~10,000 according to Travel Land Leisure
Give me your feedback on how I would answer this Google estimation question.
Assumptions
- Will consider planes flying over India only for domestic travel only.
- Will only consider commercial passenger aircraft. Will ignore military, personal and cargo planes.
- Will assume that weather conditions are fine all over India & wouldn’t restrict or hamper any airport operations.
- India has roughly 100 airports form where domestic flight operations occur.
The Framework
- We will figure out average number of planes in an hour rather than for a particular hour.
- Average number of planes in an hour = (Sum of ( Number of planes * duration))/24.
- For eg if 2 planes fly every hour for 24hrs a 2hr journey, then the formula would be 2*2*24/24 = 4. The answer is right since we have 2 planes each hour which started their journey this hour & 2 planes which are in air which started their journey in previous hour.
Actual Calculations & Assumptions
- Let’s first work on number of planes
- Number of planes would be equal to number of runways * number of planes taking off in an hour
- For this calculation, we will divide airports into 3 categories :-
- Busy - I would say India would have around 8 busy airports. These airports would have 2 runways. These can make a plane fly every 5 minutes and work at 100% capacity.
- Intermediate - Around 30 less busy airports. These would have one runway. These can make planes fly every 10 minutes but work at say 50% capacity.
- Occasional - around 50 airports which are less busy. These would have one runway. These can make plane fly every half an hour and work at 25% capacity.
- Let’s do the calculations for flights in whole day
- Busy Airports = 8*2*(60/5)*1*24 = 4608
- Intermediate = 30*1*(60/10)*.75*24 = 2160
- Occasional = 50*1*(60/30)*.25*24 = 600
- So total number of flights taking off in a day are = 7368
- Now we have to find durations.
- Since it is tough to figure out duration individually, we will take certain assumptions basis the most common sectors of flights
- Work related travel - Most of these travels are concentrated around 6-7 big cities. The good things is that for inter-city travel within these cities the flight duration is between 2-4 hrs with 2hrs being the most common (delhi->mumbai, mumbai->bengaluru, delhi->pune etc)
- We can assume 75% of all the trips happen due to work relate travel whereas rest 25% is personal.
- Within this 75%, we can safely assume that 75% trip happens for 2hrs destinations and for the rest we can take an average
- Doing the calculations
- Number of work related flights = .75*7368 = 5526
- Number of flights with 2hr journey = 5526*.75 = 4145
- Number of flights with 3hr journey = 1381
- Personal travel
- In India, shortest flight duration is 1hr & longest duration is 6hr. But the 6hr flights are not direct. So its very safe to assume that the flights would be in 1-4hr range
- Now sake of easiness, we will take some assumptions around these durations
- For 1hr flight, the number would be less since people would prefer road transport etc. So we can safely assume that the number of trips with 1hr duration would be less and we can say roughly 10% of the personal trips would be 1hr duration
- Now we will equally divide 2&3hr trip since most of the india can be covered within that duration. $hrs flights would again be less. So we assume,
- 1hr trips- 10%
- 4hr trips - 20%
- 2hr trips - 35%
- 3hr trips - 35%
- Doing the calculations
- Number of personal trips = .25*7368 = 1842
- Number of 1hr trips = 1842*.1 = 184
- Number of 4hr trips = 1842*.2 = 368
- Number of 2hr trips = 1842 *.35 = 645
- Number of 3hr trips = 1842*.35 = 645
- Work related travel - Most of these travels are concentrated around 6-7 big cities. The good things is that for inter-city travel within these cities the flight duration is between 2-4 hrs with 2hrs being the most common (delhi->mumbai, mumbai->bengaluru, delhi->pune etc)
- Calculating the total number of hours in a day for all the flights = (4145*2)+(1381*3)+(184*1)+(368*4)+(645*2)+(645*3)=14736
- Dividing it by total number of hrs in a day = 14736/24 = 614
- Since it is tough to figure out duration individually, we will take certain assumptions basis the most common sectors of flights
So we can say that roughly ~600 planes are in air at an average every hour over India.
Note:
If we want to consider international travel, we can use the following logic.
- Roughly 8-10 airports with international flight operations
- Most of the flights will cross Indian airspace within 2-3hrs
- Using the above logic figure out the number of international planes & divide them into 2 & 3hr bucket. 80% would be in 2hr bucket.
Planes can be commercial or military. Assuming, in this case, we are referring to commercial passenger flights.
We are referring to planes flying over the US area only.
The number of planes in the air per hour = # of planes taking off per hour from airports across the US
# of planes taking off per hour from airports across the US = Sum of # of planes taking off split by large, mid, and small airports.
Planes taking off an airport = # of runways x (average planes taking off per hour)
Number of airports in the US: Large, Medium, Small
The US has 50 states. It is reasonable to assume there are 2 large/major international airports per state, 15 medium-sized airports, and 10 small airports.
Large airports have 2 runways, medium have 1 runway, small also have 1 runway
The average gap between flight take offs in:
a large airport is 5 min during, in medium 10 mins, and 30 mins in smaller
# of planes in 1 hour at:
Large Aiport = (2 runway x (60 mins/5 min) → 24 planes/hour
Medium = (1 runway x(60 mins/10)) → 6 planes /hours
Small = (1 runway x (60 mins/30) → 2 planes/hour
Number of airports
50 x 2 large airports → 100 large
50 x 15 medium → 750 medium
50 x 10 small → 500 small
The number of planes taking off per hour:
Large - (100 x 24) + Medium (750x6) + Small (500x2)
~7000 planes taking off per hour and will be in the air per hour
- Does "airplanes" include commercial, private, or military airplanes? Let's assume all of the above.
- Does "an hour" represent the average hour or a specific hour in the day? Let's assume the average hour in 2019.
- Does this include all locations on the planet? Yes.
- # of people on Earth: 7.5B (fact)
- # of people who took a flight
- # of flights per year
Type of flight | % of people taking at least one flight in 2019 | Avg flights per person flying | Average occupancy per flight | Avg flights per airplane in 2019 | % of airplanes on air on an average hour in 2019 |
Commercial (C) Military (M) Private non-commercial (PNC) | C: 5% M: % military people (extrapolating from US) * % of them taking at least one flight = 1M/300M*10% = ~0.03% PNC: .1% | C: 3 Let's discard Military and PNC due to low incidence rate. | C: 75% of Avg 200 capacity = 150 | C: 2 flights per day = ~700 flights per year | C: (2 flights per day * 2hrs) / 24 hours per day = 1/6 |
7.5 B people * 5% people who fly * 3 flights per person / 150 people per flight / 700 flights per airplane * 1/6 = ~1,800 airplanes in the air in an average hour of 2019
Sanity CheckThis number seems a low for the whole world. There are a few arbitrary numbers in the calculation that I would look into, specifically:
- "% of people who flew in 2019": this number could be a bit higher than 1 in 20. If it is 1/10, it will double the estimation.
- "nr of flights per airplane": I would guess that the airlines on average probably get more than 2 flights per day on each airplane given most flights are short distance flights (less than 3 hours).
Thanks for the question. I'd like to clarify the scope.
- Are we looking globally or just within the US? --> just U.S.
- Are we considering non-commercial flights (e.g., military, cargo)? --> just commercial
Okay great, I'm going to take a second to structure my approach to this problem.
At a high level, the equation I will use looks as follows:
total # of planes in air per hour = [# of planes taking off per hour] + [# of planes still in air per hour from previous take-offs]
# of planes taking off per hour
- I'll calculate this by using the following formula:
- [# of airports] * [# of terminals / airport] * [# gates / terminal] * [# departures/hour / gate]
- I'll segment airports into large, medium, and small
- Assumptions
- Large cities have 1 large airport each, medium cities have 2 medium airports, and small cities have 4 small airports. There are 50 large cities with > 500K population, 250 with > 100K, 500 with > 50K. Therefore there are 50 large airports, 500 medium airports, 2000 small airports.
- Rationale: in big cities / metropolitan areas you have large mega airports since population is concentrated. In smaller cities population is more spread out and so you have more airports but smaller airports.
- Large airports
- Have 5 terminals and 50 gates per terminal
- 1 departure per hour
- Medium airports
- Have 1 terminal and 5 gates per terminal
- 1 departure every 2 hours
- Small airports
- Have 1 terminal and 2 gates per terminal
- 1 departure every 4 hours
- Large cities have 1 large airport each, medium cities have 2 medium airports, and small cities have 4 small airports. There are 50 large cities with > 500K population, 250 with > 100K, 500 with > 50K. Therefore there are 50 large airports, 500 medium airports, 2000 small airports.
- This results in 1250 flights departing from large airports, 1250 from medium airports, and 1000 from small airports
- 3500 total per hour
# of planes in air from previous hours
- I'm going to assume flights are either 2 hours, 4 hours, or 6 hours
- I'll assume the mix of these flights differs by size airport
- For simplicity, I'll assume medium and small airports behave the same
- For a large airport, I will assume 25% of flights are 2 hours, 50% are 4 hours, and 25% are 6 hours
- If we map this out over 6 hours, we'll see that:
- Hour 1-2: 100% are in the air
- Hour 3-4: 75% are in the air
- Hour 5-6: 25% are in the air
- This averages out to 67% of past take-offs in the air at any given hour
- For a small aiport, I assume 40% are 2 hours, 50% are 4 hours, and 10% are 6 hours. This leads to ~50% in air at any given hour.
- I'll now multiply the total # of flighst per hour I calculated before by these %'s to see how many previous flights are still in the air.
- [67% * 1.25K] + [50% * 1.25K] + [50% * 1K] = ~800 + 625 + 500 = ~1.9K
This brings our total # of planes in the air any given hour to 3.5K + 1.9K = ~5400
Top Google interview questions
- What is your favorite product? Why?89 answers | 263k views
- How would you design a bicycle renting app for tourists?62 answers | 82.5k views
- Build a product to buy and sell antiques.54 answers | 66.8k views
- See Google PM Interview Questions
Top Estimation interview questions
- Calculate the number of queries answered by Google per second.45 answers | 78.5k views
- How do you decide how many cash registers you need for a new Walmart store?33 answers | 39.4k views
- How many dentists are there in New York?33 answers | 36.7k views
- See Estimation PM Interview Questions
Top Google interview questions
- How would you improve Google Maps?53 answers | 228k views
- A metric for a video streaming service dropped by 80%. What do you do?50 answers | 135k views
- How would you design a web search engine for children below 14 years old?36 answers | 42.9k views
- See Google PM Interview Questions
Top Estimation interview questions
- Estimate the number of Uber rides.30 answers | 51.3k views
- Estimate the number of bicycles required to start a bike sharing operation in a big city.18 answers | 15.8k views
- Estimate the number of WhatsApp chats occuring in India.14 answers | 13.3k views
- See Estimation PM Interview Questions