How are prices calculated in each pro-rata setting?

This setting comes into action if you have a guest book a stay for dates that cross-over two price bands within your Price Planner:
Use the following calculation (example booking is 7 nights):
4 nights fall within the first price band of £1000 (1000 / 7 = 142.86 (the daily rate) x 4 nights = £571.42)
3 nights fall within the second price band of £2000 (2000 / 7 = 285.71 (the daily rate) x 3 nights = £857.14)
TOTAL FOR 7 NIGHTS 857.14 + 571.42 = £1428.57
Entire calculation: ((1000/7)*4)+((2000/7)*3)
For stays of more than 7 nights (example booking is 10 nights):
Use the above calculation to work out the 7 night price and then use that solution in the following calculation to work out the remaining 3 nights:
7 night price previously calculated/7 x 3 nights e.g. (£1428.57/7 = £204.08 (the daily rate) x 3 nights = £612.24)
TOTAL FOR 10 NIGHT STAY 1428.57 + 612.24 = £2040.81
Entire calculation: ((1000/7)*4)+((2000/7)*3)+((1428.57/7)*3)

This setting also comes into action if your have a guest book dates that cross-over two price bands within your Price Planner:
Use the following calculation (example booking is 10 nights):
Firstly you need to calculate the week price from from the 14th May:
4 nights fall within the first price band of £1000 (1000 / 7 = 142.86 (the daily rate) x 4 nights = £571.42)
3 nights fall within the second price band of £2000 (2000 / 7 = 285.71 (the daily rate) x 3 nights = £857.14)
TOTAL FOR 7 NIGHTS 857.14 + 571.42 = £1428.57
Next find the cost for the additional 3 nights within the £2000 price band (2000 / 7 = 285.71 (the daily rate) x 3 = £857.14
TOTAL FOR 10 NIGHT STAY 857.14 + 1428.57 = £2285.71
Entire calculation: ((1000/7)*4)+((2000/7)*6)

This setting also comes into action if your have a guest book dates that cross-over two price bands within your Price Planner.
Example calculation of 4 nights:


2 nights fall within the first price band so we take the 4 night price of £400 and divide it by 4 (the length of stay) = £100 (the daily rate) x 2 nights e.g. (400/4)*2 = £200
2 nights fall within the second price band with a 4 night price of £500 so again using the above calculation we have (500/4)*2 = £250
TOTAL FOR 4 NIGHTS £200 + 250 = £450.00
Entire calculation: ((400/4)*2)+((500/4)*2)
Note: If the stay includes a Friday or Saturday overnight then you should use your weekend price for the calculation
0 Comments
How can we make this page better for you?