6 Calculation Method Examples
The following sections describe 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
In the following 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 is 412, 414, 419, 413
-
Cabin Steward Pool Operational Position number is 711, 706
-
Common Pool – All position except the position in the 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 an 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.