6 Calculation Method Examples

Below sections describes the calculation and the distribution example of HSB/BSC.

Cash Payment Order Calculation

Cash Payment Order (CPO) is an exempted service charge fee for credit card fees deduction on Hotel and Bar Service Charge.

  1. At Service Charge Pool Calculation, create the new debit department for CPO posting.

  2. Define the percentage to distribute in Pool Calculation, Eligible Department setup under the same Pool Distribution type.

Figure 6-1 Service Charge Pool Calculation


This figure shows the Service Charge Pool Calculation window.

In below example, the Cash Payment Order department = 99.25%. Amount collected only calculates the provision fees of 0.75%. The exempted credit card fees of 2% (100% - 0.25%).

Here are the scenario:

  • Amount collected from Hotel Service Charge department = $20798.66 (posting $21386.8 x 97.25%)

  • Amount collected from CPO department = $526.03 (posting $530 x 99.25%)

  • Total Amount collected for pool distribution = $21324.69

Distribution by Point Ratio

The Distribution by Point Ratio method is applicable to Hotel Service Charge. The amount collected is allocated proportionately based on the total points per pool.

In the following example, the Hotel Service Charge is broken down into three different Pool:

  • Dining Room Pool

  • Cabin Steward Room Pool

  • Common Pool

  1. At the Pool Distribution setup, set up the Dining Pool and select the Operational Position. For example:

    • Dining Room Pool Operational Position number are 412, 414, 419, 413

    • Cabin Steward Pool Operational Position number are 711, 706

    • Common Pool – All position except position in Dining Room Pool and Cabin Steward Pool

  2. In Pool Calculation setup, select the Distribution Method “By Point Ratio” and select the corresponding distribution pool in Pool Type 1/2/3. Get the pool amount from eligible department.

    • Total Posting on cruise day 01/01/2011 = $22297

    • Amount collected on Hotel Service Charge department 97.25% = $21683.8325

Get total point of each pool.

  • Total Points in Dining Room Pool = 35465.6

  • Total Points in Cabin Steward Pool = 235.9

  • Total Points in Common Pool = 49410.1

  • Total Points = 85111.6

Get the per point value and distribute to the pool.

[Total HSC amount collected / Total points of 3 pool] x Total Point in Pool

  • For Dining Room Pool Distribution: $21683.8325 / 85111.6 x 35465.6 = 9035.55

  • For Cabin Steward Pool Distribution: $21683.8325 / 85111.6 x 235.9 = 60.10

  • For Common Pool Distribution: $21683.8325 / 85111.6 x 49410.1 = 12588.1822

Distribute to crew with point ratio calculation

[Total Points Distributed / Total Point in Pool] x Point of individual crew

  • For crew in Dining Room: 9035.55 / 35465.6 x 453.7 = $115.59

  • For crew in Cabin Steward Pool: 60.10 / 235.9 x 73.4 = $18.7

  • For crew in Common Pool: 12588.1822 / 49410.1 x 245.5 = $62.55