Booking Breakdown
Your dataset contains ~40,000 reservations for a 200-room resort hotel in Portugal, including the booking date, check-in & check-out dates, and a cancellation flag.
Your task is to calculate the resort's occupancy rate for each month in the dataset.
Occupancy rate = booked room-nights ÷ available room-nights
A guest occupies a room every night from their check-in date up to (but not including) their check-out date
Canceled reservations should not count toward occupancy
See sample logic below:
Submit your solution
What was the resort's occupancy rate in July 2016? (digits only, rounded down to the nearest percentage point))
Styled, Responsive and Ready to RollNo need to spend time changing colors and styles manually. Our component & layouts are styled out of the box Not just a UI KitPowered up with Framer's animation library and custom code componentsDark, Light and Dynamic componentsComponents will automatically adjust theme and color pallette based on your brand Responsive color stylesComponents and Layouts can easily be customized to your brand color in a few clicks 1st Feb24 layouts3rd March12 components2nd April44 componentsA Lifetime of UpdatesContinuously evolving library adjusting to the latest design trends and Framer Updates Responsive Text StylesText styles adapt to different breakpoints, avoiding the need to manually adjust MonthlyYearlyStyled ComponentsComponents & layouts are automatically styled based on your CopyCopy to ClipboardCopy, Paste, RepeatCopy and paste 100+ styled, responsive, interactive elements in two click TemplatesGet 4 custom templates worth $200+ with Pro. View Templates DesktopTabletPhoneResponsiveComponents will automatically adjust to the screen size that they are pasted into
Check back soon for the full solution video & tutorial from Maven instructors
