6 Calculation Method Examples
Below sections describes the calculation and the distribution example of HSB/BSC.
Cash Payment Order Calculation
-
At Service Charge Pool Calculation, create the new debit department for CPO posting.
-
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. This figure shows the Service Charge Pool Calculation window.](img/service_charge_pool_calc.png)
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%).
-
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.
-
Dining Room Pool
-
Cabin Steward Room Pool
-
Common Pool
-
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
-
-
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
-
-
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