Timmhart
commented
1 month ago User story
As a host, I want to view my revenue from the last month on my dashboard, so I can track my earnings and make informed decisions for future bookings.
Example mapping
- What if the host has no revenue in the past month?
- Display a message like: "No revenue data available for the selected period." Provide empty visuals (charts/graphs) and offer options to view previous months or highlight future booking opportunities.
- What if the host manages multiple properties?
- Provide a filter or tab to view revenue by individual property, with a cumulative view for overall revenue across all properties.
- What if there is a system issue retrieving the data?
- Display an error message indicating that revenue data is temporarily unavailable, and provide an option to refresh or contact support.
- What if the revenue data doesn’t align with the host’s expectations?
- Include a breakdown of deductions (e.g., service fees, taxes) and provide an option for the host to report discrepancies for review.
- What if the host wants to view revenue beyond just the last month?
- Allow the host to choose other time periods via a date picker (e.g., "Last 3 months" or "Year to date") to see more historical data.
- What if the host prefers different visualization formats?
- Offer options to switch between visualizations like bar graphs, line graphs, and pie charts for better revenue trend analysis.
Accept criteria
- [ ] The dashboard should display the total revenue for the past month, along with a comparison to the previous month.
- [ ] A breakdown of revenue by property (if multiple) should be available.
- [ ] The dashboard should show key metrics such as average daily rate, occupancy rate, and number of bookings.
- [ ] The revenue data should be downloadable as a CSV or PDF report.
- [ ] A visual graph or chart should illustrate the revenue trends for the month.
- [ ] If no revenue data is available for the selected period, the dashboard should display empty visuals (graphs/charts) with a message like "No revenue data available for the selected period."
- [ ] The empty visuals should provide an option to view revenue from previous months or highlight upcoming booking opportunities.
First phase
Second phase
KPI's per property
Other KPI's
Examples to study
Resources
Later we can add a revenue tool so the host can see in the onboarding his earning potential.
Resource property metrics: https://www.altexsoft.com/blog/revpar-occupancy-rate-adr-hotel-metrics/
Occupancy Rate Occupancy rate is measured by dividing the number of occupied rooms by the number of available rooms and multiplying by 100, showing the percentage of rooms occupied at a specific moment. For example, if you have a 10-room hotel and last night you sold 5 rooms, then the occupancy rate would be 50 percent. In further calculations we will use 0.5 which is the same as 50 percent.
ADR (Average Daily Rate) ADR is used to calculate the average rental revenue per occupied room at a given time. To find ADR, divide your total room revenue by the number of rooms sold. For example, if you sold 5 rooms out of your 10-room hotel and your total revenue was $2,000, then ADR would be $400. Obviously, it makes sense to calculate the metric only if you have different room rates, otherwise its value is pretty evident.
ALOS (Average Length of Stay) ALOS identifies the average number of nights your guests spend at your hotel and is calculated by dividing the total room nights by the total number of bookings. For example, in April the number of room nights was 200 (out of maximum 300 for a 10-room hotel), with a total of 50 bookings. Then, ALOS is 4 days.
RevPAR (Revenue per Available Room) RevPAR shows the amount of revenue generated by one room, whether booked or not. There are two ways to calculate it. You can either divide your total room revenue by the total number of available rooms OR multiply ADR by the occupancy rate. For example, selling 5 rooms out of 10 brought you $2,000, so your RevPAR equals $200 (you’re getting the same result by multiplying your ADR of $400 by the occupancy rate of 0.5.)
TRevPAR (Total Revenue per Available Room) TRevPAR is measured by dividing your total revenue (from room rental and other sources) by the total number of available rooms. This metric shows the amount of total revenue of the property per one room (if rented out seperately. For example, you have a revenue of $2,000 from the 5 booked rooms out of ten available rooms. The revenue of the restaurant is $1,000 and the revenue of the spa is $500. With the total gross revenue of $3,500, TRevPAR equals $350.
RevPAC (Revenue per Available Customer) RevPAC shows the amount of revenue per guest. To define it, divide the total revenue by the total number of property guests. You can also make the calculation including customers that do not stay at the property, but only come to use the amenities, if you have such an option for visitors. For example, you sold 3 double rooms and 2 family rooms for 4 people which brought you $2000. They ate at the restaurant for a total of $1,000 and used the spa services for $500. Besides, 16 people visited your bar, resulting in another $700. Then, your RevPAC per each of your 30 guests would come to $140.
GOPPAR (Gross Operating Profit per Available Room) GOPPAR demonstrates how much gross operating profit comes from each room. Gross operating profit is your total revenue minus gross operating expenses, and if you divide the result by the total number of available rooms, you’ll obtain your GOPPAR. For example, your total net revenue is $3,500 and your gross expenses are $1,700. So gross operating profit would be $1800. Divided by the 10 rooms, GOPPAR equals $180. If you want to see the yearly GOPPAR, you have to use the yearly values of the revenue and expenses and multiply the number of rooms by 365.
CPOR (Cost per Occupied Room) CPOR is measured by simply dividing gross operating expenses by the number of rooms sold to show how much every sold room costs you. For example, you have 5 rooms occupied and your total operating expenses are $1,700. The CPOR would be $340.
ARPAR or Adjusted RevPAR (Adjusted Revenue per Available Room) ARPAR shows how much profit each room brings you, considering variable costs (we’ve explained this figure in the GOPPAR section) and additional revenue. To calculate ARPAR, first subtract the variable costs per sold room from your ADR, add the amount of additional revenue per sold room, and then multiply the result by your occupancy rate. For example, your ADR is $400 and your occupancy is 50% with 5 rooms sold out of 10. Let’s say your variable costs are $750 (which is $150 per room) and the additional revenue is $1,500 (which is $300 per room). Then, your ARPAR would be $275.
NOI (Net Operating Income) An NOI shows whether your property is making a profit or loss. To find it you have to subtract your gross operating expenses from your total revenue. For example, you made $3,500 from room sales, restaurant, and spa. Your gross expenses are $1,700, making that day's NOI $1,800. To calculate your weekly, monthly, or yearly NOI, you have to take the corresponding total figures.