Formula to calculate fixed service price
For fixed services where the price applies to the whole group (e.g. Car, Guide, Boat,...)
If there are children in the group, the system will apply a separate pricing logic based on that Supplier's pricing policy for children, in order to calculate the most accurate cost for each member of the group.
Formula as below:
Convention:
- T: Total fixed service cost
- A: Total adults in the group
- C1: 1st group of children
- D1: Percentage of the price of a child in group 1 compared to the price of an adult according to the policy of that Service Supplier (Example: For a group of 5-7 years old, the price for 1 child = 50% of the price of 1 adult, .. )
- C2: 2nd group of children
- D2: Percentage of the price of a child in group 2 compared to the price of an adult according to the policy of that service (For example: For a group of 10 - 15 years old, the price of 1 child = 70% of the price of 1 adult, ..)
- Cn: The nth group of children
- Dn: Percentage of the price for children in group n compared to the adult price according to that Service Provider's policy
Then:
- Cost for 01 adult: E = T / (A + C1 * D1 + C2 * D2 +....+ Cn * Dn)
- Cost for 01 child in 1st group = E * D1
- Cost for 01 child in 2nd group = E * D2
- Cost for 01 child in nth group = E * Dn
Example: Car Service
- Total cost of 16-seat car: T = 3.000.000đ
- Total adults in the group: A = 8
- 1st group of children: C1 = 3
- Percentage of prices for children in group 1 compared to adult prices: D1 = 30%
- 2nd group of children: C2 = 1
- Percentage of prices for children in group 2 compared to adult prices: D2 = 50%
==> Cost for 01 adult: E = T / (A + C1 * D1 + C2 * D2 +....+ Cn * Dn) = 3.000.000 / (8 + 3 * 30% + 1 * 50%) = 319.149 đ
Cost for 01 child in 1st group: E * D1 = 319.149 * 30% = 95.745 đ
Cost for 01 child in 2nd group: E * D2 = 319.149 * 50% = 159.574 đ
(*) This price calculation logic is applied in the booking and quote area, when there is an exact number of tour guests
Update: 01/2023
