Dynamic Hotel Booking Management Excel Tool

We need an Excel table to track and analyze hotel bookings efficiently. The table should include necessary formulas and data visualization to calculate key metrics such as occupancy rate, revenue, and availability.

Key Requirements:
1.Columns to Include:
*Booking ID
*Guest Name
*Check-in Date
*Check-out Date
*Room Type
*Number of Nights
*Booking Status (Booked, Checked-in, Checked-out, Canceled)
*Room Rate per Night
*Total Revenue (Formula-based)
*Payment Status (Paid, Pending)
*Special Requests (Optional)

2.Formulas Needed:
*Occupancy Rate = (Total Booked Rooms / Total Available Rooms) × 100
*Total Revenue Calculation = Room Rate × Number of Nights
*Availability Tracker: Count of available vs. booked rooms
*Average Revenue per Room = Total Revenue / Total Rooms

3.Additional Features:
*Conditional Formatting (e.g., highlight overdue payments, full occupancy)
*Dropdown Lists for Booking Status & Payment Status
*Pivot Tables & Charts for visual representation of bookings and revenue trends
*Automated Alerts for low room availability