Vessel Operation Expense – E1

Overview

System provides a facility to capture the Vessel related tariff details and calculate the vessel related expenses based on the TDR data capturing.

  1. Tariff Setup

User can enter the Vessel related tariff’s with various calculation parameters as shown below. For each type of expense, user can define the various conditions and formula where by system will calculate the expenses dynamically.

System also has the facility to calculate the additional surcharges to be applied for Night, Holidays and due to other whether conditions.

For example for the Pilotage at AEJEA, it’s based on the Vessel GT and it has various slabs as per the sample tariff

User can define the slabs using the ‘Condition description’ as shown below. TDR table columns will be used, which will validate various conditions as per TDR data entry. Details of the TDR table column details provided in the annexture.

For example Tug hire at AEJEA, it’s based on the Tugs hired time and the rate to multiplied based on the tugs hired.

User can define dynamically such calculation using the formula which will drive the number of Units as shown below.

Similarly if any fixed charges are there based on the vessel call it can be defined in this setup without specifying any conditions and formula.

Also system can capture the surcharges for Night, Holiday and based on whether. For example at TWTXG. Pilotage charges applicable as follows,

The above pilotage is based on Vessel GT, DFI and some formula. Also surcharge applicable for Night which will be defined as follows,

Surcharges will be defined as follows,

For sunrise and sunset, system will pick the time from Sunrise and Sunset as defined below,

Supplier Tax Setup:

System has a facility to link the applicable taxes separately, like BL charges tax for AR.User can define the applicable taxes using Tax code master AP as shown below.

Cost Charge with the Tax Link – AP

User can link the applicable tax codes with the cost charge codes as shown below,

The above tax link will be applicable for all costing charges, wherever there is tax is applicable user can link the respective tax code.

  1. Report Setup for Vessel Operation Expenses(E1).

User can define a report setup and link all the possible cost charge codes as shown below. User can also mention the order in which the charge codes to appear in the report. For example, for E1 reports there are various charges applicable. All such charges can be grouped under one report type as shown below.

Also for each cost charge code, system will pick the corresponding GL account from the BL Charge link with Multiple GL account. System will pick this account as per the principal books and display in the report. Please refer the sample report,

  1. Report Generation

Based on the TDR data and Tariff, system will calculate all applicable charges at the time report generation and it will spool the data in a excel file as shown below.

Double the excel file, system will open the report and show in MS Excel as shown below.

AEJEA Output:

TWTXG Output:

  1. Annexture
  1. TDR Entry used for calculating Vessel expenses at AEJEA
  1. TWTXG

NOTE: All E1 – E4 reports will be configured with the help of IT Support(ID and TSL IT)

-------