1. Data Analysis 2 . Reservation Planning
Budget: ₹1,500 – ₹12,500 INR
1. Data Analysis
Your job is to analyze this data, prepare charts and visualizations to highlight trends and generate any
insights. Analyze the dates / data carefully as there are overlapping dates. There is no right or wrong
answer – we just want to evaluate your analytical thought process. Examples of insights include:
People who book X night-stay book Y nights in advance
The average rate paid per booking over the months
The average length of reservation per month
The rate paid per listing type
Add any relevant plots that will help explain your insights better to the company management
You can come up with more interesting insights from the trends as well
## Only Python is required ## Jupyter IDE
This is a Supply / Demand Planning exercise to assess your quantitative logic & analytical skills. The
objective of this problem is to find the total Number of Rooms needed to meet the customer bookings.
1) Check Reservation Planning. It has a list of all the resort reservations we have made in 2021.
2) This is a supply vs demand PLANNING exercise. There are few important concepts to consider and
understand for this exercise:
a) DEMAND: this is the requirement of rooms from clients and is marked as "Bookings" in the sheet.
The sheet lists online bookings with check in and check out dates.
b) SUPPLY: we must ensure that there is enough availability of each room type to meet the booking
/ demand. YOUR job is to ensure that our supply meets the current client demand so that no client
goes without a room.
c) OBJECTIVE: Through this planning exercise, you must ensure that OUR SUPPLY
i) FULLY meets the demand from clients (there's NO SHORTAGE AT ANY TIME),
ii) EXACTLY meets the demand (meaning, there is NO Wastage, and NO Excess Rooms are
arranged if not needed).
iii) Supply & demand should match each other as closely as possible, no more, no less.
d) Other important things to consider:
i) Different room sizes and categories are mentioned in the sheet – so the final results should
be per room type
ii) Can you consider that continuous requirement of similar room categories (e.g. Studio Parlor
or Studio Double etc.) can be clubbed into a single supply profile? This could make our
planning for Supply easier as we can block a single large supply instead of multiple shorter
supplies.
e) For example, when planning the SUPPLY, keep in mind that the Rooms can be booked over
multiple dates and be clubbed together to optimize (e.g. if there are 2 separate bookings from
Mar1-3 and 5-6, we can book SUPPLY as a single booking from Mar1-6
f) If you are missing any info, just make assumptions and note it down. We are more interested in
seeing your logic & quantitative ability to find a solution
3) Column A-C in the sheet mentions the dates & type of the room that has been booked by clients (i.e.
this is the DEMAND from the clients).
4) FINAL DELIVERABLE: Figure out how many rooms are needed and of what room types to match the
DEMAND profile
Inputs: Demand profile is provided in excel sheet
Output Needed: Supply (number of rooms and types of rooms)
5) Try to demonstrate the above results, a supply and demand profile versus time, graphically i.e.
through an excel plot (x axis - time/date, y-axis - demand & supply profiles as separate curves). These
are your recommendations to the Company Management and thorough work will be appreciated.
Your job is to analyze this data, prepare charts and visualizations to highlight trends and generate any
insights. Analyze the dates / data carefully as there are overlapping dates. There is no right or wrong
answer – we just want to evaluate your analytical thought process. Examples of insights include:
People who book X night-stay book Y nights in advance
The average rate paid per booking over the months
The average length of reservation per month
The rate paid per listing type
Add any relevant plots that will help explain your insights better to the company management
You can come up with more interesting insights from the trends as well
## Only Python is required ## Jupyter IDE
This is a Supply / Demand Planning exercise to assess your quantitative logic & analytical skills. The
objective of this problem is to find the total Number of Rooms needed to meet the customer bookings.
1) Check Reservation Planning. It has a list of all the resort reservations we have made in 2021.
2) This is a supply vs demand PLANNING exercise. There are few important concepts to consider and
understand for this exercise:
a) DEMAND: this is the requirement of rooms from clients and is marked as "Bookings" in the sheet.
The sheet lists online bookings with check in and check out dates.
b) SUPPLY: we must ensure that there is enough availability of each room type to meet the booking
/ demand. YOUR job is to ensure that our supply meets the current client demand so that no client
goes without a room.
c) OBJECTIVE: Through this planning exercise, you must ensure that OUR SUPPLY
i) FULLY meets the demand from clients (there's NO SHORTAGE AT ANY TIME),
ii) EXACTLY meets the demand (meaning, there is NO Wastage, and NO Excess Rooms are
arranged if not needed).
iii) Supply & demand should match each other as closely as possible, no more, no less.
d) Other important things to consider:
i) Different room sizes and categories are mentioned in the sheet – so the final results should
be per room type
ii) Can you consider that continuous requirement of similar room categories (e.g. Studio Parlor
or Studio Double etc.) can be clubbed into a single supply profile? This could make our
planning for Supply easier as we can block a single large supply instead of multiple shorter
supplies.
e) For example, when planning the SUPPLY, keep in mind that the Rooms can be booked over
multiple dates and be clubbed together to optimize (e.g. if there are 2 separate bookings from
Mar1-3 and 5-6, we can book SUPPLY as a single booking from Mar1-6
f) If you are missing any info, just make assumptions and note it down. We are more interested in
seeing your logic & quantitative ability to find a solution
3) Column A-C in the sheet mentions the dates & type of the room that has been booked by clients (i.e.
this is the DEMAND from the clients).
4) FINAL DELIVERABLE: Figure out how many rooms are needed and of what room types to match the
DEMAND profile
Inputs: Demand profile is provided in excel sheet
Output Needed: Supply (number of rooms and types of rooms)
5) Try to demonstrate the above results, a supply and demand profile versus time, graphically i.e.
through an excel plot (x axis - time/date, y-axis - demand & supply profiles as separate curves). These
are your recommendations to the Company Management and thorough work will be appreciated.