No charge 0-4 years old
Purpose of the formula: to calculate a 100% discount for children of the age ranges 1 and 2.
Condition of application: the discount is applied if, in the reservation, adults are two or more and if children of the age ranges 1 and 2 are more than zero.
Calculation to be performed: the system must deduct the accommodation charges of the children B1 and B2. Thus, it is necessary to substitute the basic charge BC (i.e. the value from the price list by person) with the value (children range 1 + children range 2).
50%discount children 5 -12 years old
Purpose of the formula: to calculate a 50% discount for children of the age range 3.
Condition of application: the discount is applied if in the reservation adults are two or more and if children of the age range 3 are more than zero.
Calculation to be performed: the system must deduct 50% of the accommodation charge calculated for B3 children. Thus, it is necessary to multiply the basic charge BC (i.e. the value from the price list by person) for the value 0, 50 and for the number of children belonging to the age range 3.
10%Discount adults on the third and fourth bed
Purpose of the formula: to calculate a 10% discount for adults who occupy the third and fourth beds.
Conditions of application: the discount is applied if adults in the reservation are more than two.
Calculation to be performed: the system must deduct 10% of the basic charge (BC) for the third and the fourth beds, according to the number of adults occupying the room.
30-euro surcharge for a double room used as a single room
Purpose of the formula: to manage the surcharge in case the room is occupied by only one person.
Condition of application: the surcharge is applied only if there is one person in the reservation.
Calculation to be performed: the system has to manage a 30-euro surcharge.
40-euros surcharge on Fridays and Saturdays for stays shorter than 3 nights
Purpose of the formula: to manage the surcharge in case of a stay that is inferior to 3 nights and includes Friday and/or Saturday.
Condition of application: the surcharge is applied only if the stay includes Friday and/or Saturday.
Calculation to be performed: the system has to manage a 40-euro surcharge on Friday and/or Saturday. Warning: in case of formulas in which it is necessary to manage a weekday, it is also necessary to create as many formulas as the week days to be taken into account.
Post your comment on this topic.