Indus Insights Practice Test
Given:
i. The total number of cards that SuperCards sold this year is same as last year
ii. The fee charged by SuperCards for one of the card has increased by 20% this year while for the other card, it has been reduced by 10% as compared to last year
iii. Cost incurred to service both the cards has increased by 10% this year as compared to last year Which of the following holds true?
- What are the sources of revenue for the airport?
- What is the major source of revenue?
- What are the major factors affecting revenue?
- How to quantify different factors affecting revenue?
- What are different types of fees charged to airlines?
- What are other factors (not directly related to airport infrastructure) that will contribute to the airport revenue?
Step 1: Identify sources of revenue for airport
While attempting a guesstimate, a structured approach right from the start is essential to avoid confusion later
- To begin, you might want to imagine yourself travelling by air
- Travel to airport by a cab who then parks it --> Car Parking
- You walk inside the airport lounge and notice shops --> Rent of retail outlets
- You notice airplanes parked --> Aircraft parking charges
- Your flight takes off --> Aircraft takeoff/landing charges
- This kind of an approach is not a rule but might facilitate structured thinking and would help build an exhaustive case
- Each of these categories can be considered as separate guesstimates and then be added to estimate the overall revenue
- You may not have a lot of time, so start with the most important source first
For simplicity we will only solve two major streams: Revenue from takeoff / landing and retail outlets
- Identify factors which will contribute to revenue from takeoff/landing
- Revenue = Total units (No. Of aircrafts) X Per unit charge (Fees per landing/takeoff)
- In order to estimate the total number of aircrafts, rather than taking a random guess, first break the time span into segments as frequency of aircrafts is dependent on time
- For simplicity, lets consider that there is just one runway
- You may assume the frequency in these segments based on your experience
Time slot |
11 PM to 5 AM |
5AM to 11 AM |
11AM to 11 PM |
Frequency of flights |
20 minutes |
10 minutes |
6 minutes |
No. Of flights in an hour |
3 |
6 |
10 |
No.of flights in the slot |
18 |
36 |
120 |
Estimating the takeoff / landing fees is difficult
- Therefore, let us try to estimate the revenues from a single flight and assume a percentage of it as takeoff/landing fee
- An average aircraft has ~50 rows with ~6 seats in each row
- Price of a ticket ~INR 5,000
- Revenue from a single flight=50×6×5,000 = INR 15,00,000
- Airport development fees are usually ~5% of this amount and could be assumed to be takeoff/landing fees
- Takeoff/landing fees = 5%×15,00,000 = INR 75,000
- Total annual revenue from take-off/landing = 75,000×175×12 = INR 15,75,00,000
Step 3: Revenue from retail outlets
Calculating the revenue from retail outlets and advertisements entails the following steps:
- Assume the terminal to be rectangle with a given length and breadth
- However, most of terminal is used for passage, check-in counters, sitting arrangements, etc.
- Hence, make an assumption on the proportion of terminal area available for retail outlets
- Use a suitable rent per unit area to calculate the rent
- Annual revenue from retail outlets =
𝑇𝑒𝑟𝑚𝑖𝑛𝑎𝑙 𝑎𝑟𝑒𝑎 × 𝑃𝑟𝑜𝑝𝑜𝑟𝑡𝑖𝑜𝑛 𝑜𝑓 𝑡𝑒𝑟𝑚𝑖𝑛𝑎𝑙 𝑎𝑣𝑎𝑖𝑙𝑎𝑏𝑙𝑒 𝑓𝑜𝑟 𝑟𝑒𝑡𝑎𝑖𝑙 𝑜𝑢𝑡𝑙𝑒𝑡𝑠 × 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑠𝑖𝑧𝑒 𝑜𝑓 𝑎 𝑟𝑒𝑡𝑎𝑖𝑙 𝑜𝑢𝑡𝑙𝑒𝑡 × 𝐴𝑛𝑛𝑢𝑎𝑙 𝑟𝑒𝑛𝑡 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 𝑎𝑟𝑒𝑎
Bonus PointsThe candidate will earn bonus points by including some exclusive points in their structure such as, but not limited to:
- Mentioning other streams of revenue like advertising, paid Wi-Fi, services to the airlines etc.
- Segmenting the revenues by domestic and international travel
- Segmenting the retails outlets by space; Larger spaces like business lounges and smaller spaces like food stores etc.
- Segmenting the retails space rentals on location of the outlet in the terminal area
- Identifying and comparing different approaches to estimate the same result; For example the aircraft parking charges can also be calculated using average weight of an aircraft and parking charges per unit weight (This is how the charges are actually calculated)
- What are the sources of revenue for the airport?
- What is the major source of revenue?
- What are the major factors affecting revenue?
- How to quantify different factors affecting revenue?
- What are different types of fees charged to airlines?
- What are other factors (not directly related to airport infrastructure) that will contribute to the airport revenue?
Step 1: Identify sources of revenue for airport
While attempting a guesstimate, a structured approach right from the start is essential to avoid confusion later
- To begin, you might want to imagine yourself travelling by air
- Travel to airport by a cab who then parks it --> Car Parking
- You walk inside the airport lounge and notice shops --> Rent of retail outlets
- You notice airplanes parked --> Aircraft parking charges
- Your flight takes off --> Aircraft takeoff/landing charges
- This kind of an approach is not a rule but might facilitate structured thinking and would help build an exhaustive case
- Each of these categories can be considered as separate guesstimates and then be added to estimate the overall revenue
- You may not have a lot of time, so start with the most important source first
For simplicity we will only solve two major streams: Revenue from takeoff / landing and retail outlets
- Identify factors which will contribute to revenue from takeoff/landing
- Revenue = Total units (No. Of aircrafts) X Per unit charge (Fees per landing/takeoff)
- In order to estimate the total number of aircrafts, rather than taking a random guess, first break the time span into segments as frequency of aircrafts is dependent on time
- For simplicity, lets consider that there is just one runway
- You may assume the frequency in these segments based on your experience
Time slot |
11 PM to 5 AM |
5AM to 11 AM |
11AM to 11 PM |
Frequency of flights |
20 minutes |
10 minutes |
6 minutes |
No. Of flights in an hour |
3 |
6 |
10 |
No.of flights in the slot |
18 |
36 |
120 |
Estimating the takeoff / landing fees is difficult
- Therefore, let us try to estimate the revenues from a single flight and assume a percentage of it as takeoff/landing fee
- An average aircraft has ~50 rows with ~6 seats in each row
- Price of a ticket ~INR 5,000
- Revenue from a single flight=50×6×5,000 = INR 15,00,000
- Airport development fees are usually ~5% of this amount and could be assumed to be takeoff/landing fees
- Takeoff/landing fees = 5%×15,00,000 = INR 75,000
- Total annual revenue from take-off/landing = 75,000×175×12 = INR 15,75,00,000
Step 3: Revenue from retail outlets
Calculating the revenue from retail outlets and advertisements entails the following steps:
- Assume the terminal to be rectangle with a given length and breadth
- However, most of terminal is used for passage, check-in counters, sitting arrangements, etc.
- Hence, make an assumption on the proportion of terminal area available for retail outlets
- Use a suitable rent per unit area to calculate the rent
- Annual revenue from retail outlets =
𝑇𝑒𝑟𝑚𝑖𝑛𝑎𝑙 𝑎𝑟𝑒𝑎 × 𝑃𝑟𝑜𝑝𝑜𝑟𝑡𝑖𝑜𝑛 𝑜𝑓 𝑡𝑒𝑟𝑚𝑖𝑛𝑎𝑙 𝑎𝑣𝑎𝑖𝑙𝑎𝑏𝑙𝑒 𝑓𝑜𝑟 𝑟𝑒𝑡𝑎𝑖𝑙 𝑜𝑢𝑡𝑙𝑒𝑡𝑠 × 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑠𝑖𝑧𝑒 𝑜𝑓 𝑎 𝑟𝑒𝑡𝑎𝑖𝑙 𝑜𝑢𝑡𝑙𝑒𝑡 × 𝐴𝑛𝑛𝑢𝑎𝑙 𝑟𝑒𝑛𝑡 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 𝑎𝑟𝑒𝑎
Bonus PointsThe candidate will earn bonus points by including some exclusive points in their structure such as, but not limited to:
- Mentioning other streams of revenue like advertising, paid Wi-Fi, services to the airlines etc.
- Segmenting the revenues by domestic and international travel
- Segmenting the retails outlets by space; Larger spaces like business lounges and smaller spaces like food stores etc.
- Segmenting the retails space rentals on location of the outlet in the terminal area
- Identifying and comparing different approaches to estimate the same result; For example the aircraft parking charges can also be calculated using average weight of an aircraft and parking charges per unit weight (This is how the charges are actually calculated)