DELTA HQ

To ensure that your Rate configuration in Rates V2 is accurate and meets your expectations, you can check Delta PMS Rate V2 calculation using detailed formula on this article.

The following formulas calculate rates from <code>add-on</code>, <code>adjustment by guest</code> in percentage and <code>adjustment by night stay</code>. You can remove if the rate does not include those three items and just multiply the <code>adjustment by guest</code> with <code>number of nights</code> if the value type is amount.

Formula when the adjustment using Percentage type value:

(<code>Total {n} night stays</code> + <code>Add-on value</code>) + (<code>Total {n} night stays</code> X <code>Adjustment by Guest</code>) - <code>Adjustment by Night Stay</code>

<code>Total {n} night stays</code>: The sum of total night stays that value {n} is how many nights count

<code>Add-on value</code>: Retrieved from the add-on value that already set.

<code>Adjustment by Guest</code>: Retrieved from the Price Adjustment by number of guest that set on Base Rate

<code>Adjustment by Night Stay</code>: Retrieved from the Price Adjustment by number of nights that set on Base Rate

Package with Service Unit Per Booking (<code>Total {n} night stays</code> + <code>Add-on Value</code>) + [(<code>Total {n} night stays</code> + <code>Add-on Value</code>) X <code>Adjustment by Guest</code>] + <code>Package Service Price</code> - <code>Adjustment by Night Stay</code> ​

Package with Service Unit Per Night (<code>Total {n} night stays</code> + <code>Add-on Value</code>) + (<code>Package Service Price</code> X <code>Number of Nights</code>) + (<code>Total {n} night stays</code> X <code>Adjustment by Guest</code>) - <code>Adjustment by Night Stay</code> ​

Package with Service Unit Per Guest (<code>Total {n} night stays</code> + <code>Add-on Value</code>) + (<code>Package Service Price</code> X <code>Number of Guest</code> X <code>Number of Nights</code>) + (<code>Total {n} night stays</code> X <code>Adjustment by Guest</code>) - <code>Adjustment by Night Stay</code>

1. Package with Service Unit Per Booking (<code>Total {n} night stays</code> + <code>Add-on Value</code>) + [(<code>Total {n} night stays</code> + <code>Add-on Value</code>) X <code>Adjustment by Guest</code>] + <code>Package Service Price</code> - <code>Adjustment by Night Stay</code> ​
2. Package with Service Unit Per Night (<code>Total {n} night stays</code> + <code>Add-on Value</code>) + (<code>Package Service Price</code> X <code>Number of Nights</code>) + (<code>Total {n} night stays</code> X <code>Adjustment by Guest</code>) - <code>Adjustment by Night Stay</code> ​
3. Package with Service Unit Per Guest (<code>Total {n} night stays</code> + <code>Add-on Value</code>) + (<code>Package Service Price</code> X <code>Number of Guest</code> X <code>Number of Nights</code>) + (<code>Total {n} night stays</code> X <code>Adjustment by Guest</code>) - <code>Adjustment by Night Stay</code>

To help you understand the provided formula, Delta has included example cases and applied formulas in this spreadsheet.

Calculation formulas and examples with booking cases to understand and check your Rate Calculation.

Understanding Booking Amount with Rates V2: A Calculation Examples with Cases

The following formulas calculate rates from `add-on`, `adjustment by guest` in percentage and `adjustment by night stay`. You can remove if the rate does not include those three items and just multiply the `adjustment by guest` with `number of nights` if the value type is amount.

Base Rate Calculation

Package Rate Calculation

Understanding Booking Amount with Rates V2: A Calculation Examples with Cases

The following formulas calculate rates from add-on, adjustment by guest in percentage and adjustment by night stay. You can remove if the rate does not include those three items and just multiply the adjustment by guest with number of nights if the value type is amount.

Base Rate Calculation

Package Rate Calculation

The following formulas calculate rates from `add-on`, `adjustment by guest` in percentage and `adjustment by night stay`. You can remove if the rate does not include those three items and just multiply the `adjustment by guest` with `number of nights` if the value type is amount.