2 Calculation Processes
The Service Charge module calculates the total Hotel Service Charge (HSC) or Beverage Service Charge (BSC) of the day, then divides by the total pool points for the day before adding each day’s calculation to obtain the voyage total.
Figure 2-1 Service Charge Overview
Table 2-1 Service Charge Dashboard Fields
Field Name | Description |
---|---|
Crew Name |
Crew name. |
External ID |
Crew external ID. |
Eligible Start Date |
Date crew member reports for duty and eligible to service charge distribution. |
Eligible End Date |
Date crew member sign-offs from his/her duty and not entitled to service charge distribution thereafter. |
Repatriation Date |
Date crew member disembarks from the cruise. |
Position |
Crew member current Operational Position. |
Hotel Service Charge |
Amount accumulated from Hotel Service Charge pool and distributed to the crew member. |
Bar Service Charge |
Amount accumulated from all the Bar Service Charge pool and distributed to the crew member. |
Paid |
A Yes/No flag indicating whether the amount is paid to the crew member through Payroll system. When a crew has HBSC payout in Payroll system, the Paid column for the crew updates to Yes. |
Mid Voyage/Home Port Repat |
Denotes the whether the crew member entitlement to service charge is calculated based on a full voyage or partial.
Example 1:
Example 2:
Example 3:
|
Days |
Days calculated from cruise start date until crew service charge eligible end date (for mid cruise repat crew) or cruise end date. The program calculates the days until current system date if the cruise is the current cruise. For example:
If the system date, eligible start date and eligible end date are same, example: 17 July, program return day count = 3 days instead of 1 day |
Premiums |
|
Date |
Posting date of premium pay. |
Premium Point |
Premium work hour (approved in T&A module) x Pay rate. The pay rate refers to the premium work hour in Payroll, Interface Paycode. |
Premium $ Calculated |
Premium Pay amount. |
Premium Code |
Premium pay code. |
Per Point Value |
Point value as of last Calculate Total. If Calculate Total has yet been processed after new premium points appear, then the point value and amount will be zero until a recalculation is perform on the voyage. |
Breakdown Calculations |
|
Pool Type |
The type of service charge pool that the crew is entitled. |
Distribute to Crew |
The calculated distribution amount from the service charge pool type to be paid to the crew member. |
Pool Total Collected |
The total amount collected by the pool. |
Point |
Service charge point per position. |
Per Point Value |
Eligible point value. |
Mid Cruise Repat |
Yes / No indicator of crew member in mid cruise repatriation. |
-
Click the Overview button to access the Service Charge Dashboard.
-
The Service Charge Dashboard window appears blank when you first open. Click Show Details to populate the information.
-
The window is divided into three (3) sections. The columns and width of these sections are adjustable by dragging the column divider.
-
If there are no HSC or BSC posting to the voyage at the time the Calculate Total button is first pressed, no crew members will appear in the list. The BSC list appears only when the BSC has been charged and not HSC or visa-versa.
Show Details
Table 2-2 Show Details Field Description
Field Name | Description |
---|---|
Pool Type |
The type of service charge pool that the crew is entitled. |
Distribute to Crew |
The calculated distributed amount from the service charge pool type to be paid to the crew member. |
Pool Total Collected |
The total amount collected by the pool. |
Point |
Service charge point per position. |
Per Point Value |
Eligible point value. |
Mid Cruise Repat |
Yes / No indicator that the crew member is mid cruise repatriation. |
- At the Service Charge Dashboard, select the voyage/segment from the drop-down list.
- Click Show Details at the ribbon bar.
- In Service Charge Dashboard, the crew member lists are shown.
- The premiums worked/booked, the total points, premium pay, type of premium, and point value of selected crew member are shown.
- The detailed breakdown of daily HSC and/or BSC of selected crew member where the information shown are by per pool type (indicates the several pool types for BSC), and per day since the calculations are made on a per-day basis with its total distributed to the crew member for the voyage.
- When highlighting a crew member, the Breakdown by Calculation shows the crew eligible type of pool and the respective pool distribution amount.
Calculate Totals
When the Calculate Total is clicked for the first time on a newly open voyage, the system automatically recalculates the previous open voyage for the final time, before closing the previous voyage and calculating the new voyage for the first time. After the previous voyage status is set to close, no further changes are allowed. Therefore, it is important to check and ensure the previous voyage that all the postings, premium points, and manual adjustments are complete.
Figure 2-2 Open Status of Prior Voyage
The date of the voyage status changes to Close becomes the Last Calculated date that appears in the Select Cruise drop-down list. Therefore, for reporting clarity it is best to maintain the last calculated date as the actual voyage or segment end date.
Figure 2-3 Segment Status
Run the Calculate Total function at any time and as often as required when the voyage is in the Open status. Clicking the Calculate Total triggers a recalculation of the daily HSC and BSC distribution for all crew members eligible for each day as long as they are not paid (see Mid-Voyage and Homeport Repats), and incorporates any additional posting, premiums, adjustments, new crew, repatriation status, and others.
The Calculate Total should be processed daily or regularly during the voyage to ensure all HSC and BSC are calculating and distributing, and correcting any arrears where necessary. Before the calculation begins, the program checks the Eligibility Start / End Date for discrepancies. At the end of the calculation, the dashboard displays all crew members with pool distribution.
Calculate Hotel Service Charge
-
Premiums posted on a day with no HSC will have zero Per Point Value, and the crew members entitled to working premiums on that particular day will not have any premium pay.
-
Premiums worked on a day with a double HSC posting would receive double-valued Per Point Value.
Calculate Bar Service Charge (BSC)
Similar to HSC, this function only calculates the BSC. The BSC calculations could fail when any of the following occurs:
-
MICROS charges posted with a MICROS employee number that is not assigned to any crew member.
-
MICROS number is assigned to a crew member whose eligibility is not within the date range of the voyage being processed.
-
The posting (POS_ORDER_EMP_NO) is not associated with any crew member ID (UXP_C_ORDER_EMP_NO) in the database.
Figure 2-4 BSC Record Failed to Process
Click the Print Preview button to preview the Failed to Process record in the report layout or print to the printer directly.