This screen allows the definition of price dependency formulas between the reference rate plan and any other rate plans (defined in the “Room Types and Rate Plans” screen). It has 2 sections:
1. The Control Bar
The control bar has the following options:
a. Year selection – defines the year which will be displayed in the calendar section below
b. Rate Plan selection – defines for which rate plan will the formulas be displayed and managed in the calendar below and using the “Add formula” button.
c. Shows the reference rate plan. All dependencies will be calculated based on the price of this rate plan.
d. The Add Formula button gives users the possibility to add dependency formulas. When clicked, the following popup appears:
- a. Time period selector – the formula will be applied for the arrival dates in this time period. Any existing formulas previously defined on these dates will be deleted.
- b. DOW filter – formulas can be defined only for certain DOW’s within the selected time period.
- c. Formula definition – each formula can have up to two “markups” which are summated for the final amount.
- for each “markup”, users can select if the operation is to be an addition, subtraction, multiplication, or division; then input the amount; then select if the amount is to be applied as a percentage or absolute value.
- for the first markup, a special operation is available (the “equality” operation), allowing to conveniently define the dependent price as being “equal” to the reference price (same can be achieved by “adding” a 0 value, but that would look “odd” when viewing formulas throughout the app).
- Attention: If the amount is in absolute value, a selection if the amount is to be applied per person (or not) is displayed.
- d. Formula preview – displays the mathematical calculation that will be applied based on the “markups” defined above.
f. The “SEND” button – once formulas are defined, the system will apply the new formulas immediately and as such, the “SEND” button will become active. More info can be found on “The SEND Button” page.
2. The Calendar
The calendar section displays the existing formulas for the selected year and rate plan.
The arrival dates are grouped in months; each cell shows the formula for the respective arrival date.
The background of each cell is color-coded to highlight the day type (season or event category) for the respective arrival date:
If the formula was defined “per person”, the calendar will display it:
Clicking on any cell will show the Edit Formula popup which is exactly the same as the “Add Formula” popup (described above).