...
...
...
...
| Anchor | ||||
|---|---|---|---|---|
|
What you will find here
| Table of Contents |
|---|
Not what you were looking for? Search more topics
| Live Search | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Budget analysis Overview
The bigger picture
KPI’s, comparing data and time frames could be set up to individualize your budget overview. This way you always see what you want.
The standard timeframe configurations are the following:
start = the first of the last month
finish = last day of the current month in one year
The standard configuration of the KPI’s shows the following figures:
Revenue
Occupancy
RevPAR
The standard settings for the series are the following:
OTB/Final CY “on the books/final current year”
YTD LY “Year to date last year”
All key figures and time frames could be set individually with the configuration options in the budget.
Time frame settings
...
As stated in the introduction you could set the time frame for your analysis individually. Therefore, you just choose the start date (from) and the end date (to).
Furthermore, it is possible to choose how the data should be displayed. The options here are: per month, per week and per day, as in the picture above.
...
Analysis options
The budget analysis tool offers a variety of filters you can use to analyse your hotel's budget performance, everything can be customised according to your needs. Check below the analysis options available.
Time frame: period of time you want to assess.
KPIs: what will be analysed.
Revenue, occupancy, rooms sold, rooms available, ADR or RevPar.
Series: time frames comparison options.
Group by: will split the available data into the selected group, adding up to the total of your selected KPI.
Hotels, segment, channels, country or room type.
Difference: calculate the difference to the selected series.
Income: define if the income showed in the table is net or gross.
Time frame
You can choose the period of time you want to assess. By default, the start date will be the first of the last month and the end will be the last day of the current month in one year. You can define the time frame by selecting:
Start date (From)
End date (To)
Time unit: day, week or month.
| Note |
|---|
Please, keep in mind that a selection of a weekly or daily |
...
KPI’s
...
With the selection of KPI’s, you could choose which one should be displayed in the budget. Just select or unselect the figures that you currently need. You can select up to 5 individual key figures that you would like to assess in the budget.
The available key figures include:
revenue (standard setting)
occupancy (standard setting)
rooms sold
rooms available
ADR
RevPAR (standard setting)
To select or unselect a key figure you just tick the boxes shown in “KPI’s”.
...
TIP: The ADR is a figure that is worth tracking as an additional standard for your personal setup. Just select it at “Metrics” to add it to your overview.
Series
...
time unit might take longer to load. |
KPIs
You can select the KPIs that will be displayed (on the top of the table) in the analysis by selecting them on the KPI dropdown, you can select up to 5 at once. The available KPIs are:
Revenue
Occupancy
Rooms sold
Rooms available
ADR (Average Daily Rate): Average rate of all sold rooms.
How to calculate it:
(Total room revenue) / (Number of all sold rooms)
RevPAR (Revenue per available room): This KPI combines occupancy and ADR to see how the hotel performed.
How to calculate it:
(total room revenue) / (total number of rooms)or(ADR) x (occupancy in %)
Series
The series are used to extend the possibilities, by comparing different time frames.
...
OTB/Final CY (OTB = ”on the books”/final current year” that indicates the current booking situation of this moment of the year)
Final LY (final result of the last year)
YTD LY (“Year to date last year” = the qualifying date showing the historic booking situation last year vs. today)
For a deeper analysis
...
, you can add the following options to your analysis:
Final 2Y
...
: final value two years ago
...
.
Final 3Y
...
: final value three years ago
...
.
YTD 2Y
...
: qualifying date comparison for the booking situation two years ago
...
YTD 3Y
...
: qualifying date comparison for the booking situation three years ago
...
New 1d
...
: shows pick up of the last day
...
New 3d
...
: shows pick up of the last three days
...
.
New 7d
...
: shows pick up of the last seven days
...
.
Goals
...
Due to the flexible settings it will be easier for you to assess periods that are more likely to occur every two or three years. An example would be Easter or a fair that is taking place every two years.
...
TIP: If you have selected many KPI’s (more than three) you could not set additional series. You could solve the situation by unselecting one of the KPI’s. This way you could display up to three KPI’s and two series at the same time.
Group by
...
There is no standard setting for the “Group By” options. However, it gives you the opportunity to select the following settings for your displayed budget:
...
Hotels (for the user operating more than one hotel with RateBoard)
...
: goals set on “Settings → Budget”.
| Note |
|---|
If you select more than 3 KPIs you won't be able to add more than 2 series. |
Group
The groups will split the available data into the selected group, adding up to the total of your selected KPIs. You can choose between the following options:
Hotels: only for the users operating more than one hotel in RateBoard.
Segments: e.g. group, business, leisure
...
Channels
...
: e.g. website, telephone, Booking.com
...
Country
...
: country of origin of your
...
guests
Room Type
...
Differences
...
The last column "Differences" can be shown or hidden (default settings).
If you decide to show it, the difference between your current and historical datas will be displayed next to the values, as in the picture below.
...
TIP 2: If you are using RateBoard with several hotels from your account you could set up your hotels to “Bundles” of your liking. How to set them up you will learn at the article about “Budget Settings”. Click here to read.
...
TIP 3: The Budget could be exported as a CSV or PDF file if you need it.
If you have any questions about the functionality, KPI’s or settings, please do not hesitate to contact your Revenue Manager at RateBoard. We are happy to help.
: the room types are the ones set in your inventory.
| Tip |
|---|
Expert tipp: If you are operating more than one hotel in RateBoard, you can set up hotel “Bundles” to make your analysis easier. |
| Info |
|---|
The analysis based on your market segments will give you valuable information about your guest and trends. |
Differences
Calculate the difference to the selected series, you can turn it on (show) or off (hide). It will be displayed after the respective series.
| Info |
|---|
Expert tipp: Especially the analysis based on your market segments will give you valuable information about your guest and trends. |
...
Income
Net values are only provided by selected PMSs partners.
ASA
Apaleo
Citadel
Ericsoft Suite5
Guestline
Hogatex
Lean
ScignoOTA
SIHOT
5Stelle
Suite8CSV
If available, you should be able to change your income between Net and Gross, this change will be reflected on the Revenue, RevPar and ADR values.
Custom presets
You can create custom presets that will save the analysis options and make it easier to get to the visualization that makes more sense to your hotel.
Create new presets
Select the filter options you want to apply.
Once you are done, click on
NEW PRESETto create a new one.Add a unique name to your preset.
Click
"SAVE".
| Note |
|---|
Every preset needs to have a unique name, otherwise the preset will not be saved. |
Access or delete presets
Once you created your presets, you can switch between them by clicking on preset option or delete a preset by clicking on the respective waste paper bin.
...
