HowTo-Input Costing Tariff-Summarize
◎Index：
1. How To: Input AP Master in AFSYS 3
2. HowTo:Input Ex. Rate Master - Costing 7
3. HowTo:Input Port Tariff Charges 8
4. HowTo:Input Transporter Tariff 12
5. HowTo: Input Storage 14
6. HowTo: Input Refeer 20
◎Function Path:
1. HowTo: Input AP Master
(Path：Finance àFinance Masters à AP Master)
2. HowTo: Input ex. rate Costing
(Path：Tariffsetup à Costing master àEx rate master – Costing)
3. HowTo: Input Port Tariff Charges
(Path：Tariff setting àCosting Master à Port Tariff Charges)
CHARGE_CODE / CHARGE_DESC / CHARGE_GROUPTLASH / Lashing / TERMINL
TOCHCV / Open/Close Hatch Covers / TERMINL
TOTHR / Terminal Other Charge / TERMINL
TSHIFT / Shift / TERMINL
TSTDCY-E / Stevedorage-CY-Export / TERMINL
TSTDCY-I / Stevedorage-CY-Import / TERMINL
TSTTK-E / Stevedorage-Tackle Export / TERMINL
TSTTK-I / Stevedorage-Tackle Import / TERMINL
TTALY / Tally / TERMINL
TWFPG / Wharfage/Cargo due /Habour Due / TERMINL
TWFRT / Waterfront / TERMINL
4. HowTo:Input Transporter Tariff
(Path：Tariff seting àCosting Master à Transporter Master)
CHARGE_CODE / CHARGE_DESC / CHARGE_GROUPTKDRAYG-LD / Transporter-TRUCK Laden / TRUCKER
TKDRAYG-MT / Transporter-TRUCK Empty / TRUCKER
5. HowTo: Input Storage
(Path：Tariff seting àCosting Master àFree Pool Master)
(Path：Equipment Control à Equipment Master àPort Free Days)
(Path：Equipment Control à Equipment Master àCharge Rate Basis)
CHARGE_CODE / CHARGE_DESC / CHARGE_GROUPYSTG-EXLDN / Export Storage - Laden / YARD
YSTG-EXMTY / Export Storage - Empty / YARD
YSTG-IMLDN / Import Storage - Laden / YARD
YSTG-IMMTY / Import Storage - Empty / YARD
YSTG-SULDN / Shut Out Storage - Laden / YARD
YSTG-SUMTY / Shut Out Storage - Empty / YARD
YSTG-TSLDN / TSP Storage - Laden / YARD
YSTG-TSMTY / TSP Storage - Empty / YARD
6. HowTo: Input Refeer
(Path：Equipment control àMarine EntryàReefer fee Inspection Master)
CHARGE_CODE / CHARGE_DESC / CHARGE_GROUPYMNTR / Reefer Expenses-Monitor / YARD
YPOWR / Power Supply / YARD
YPRECL / Reefer expense-pre cooling / YARD
YRFPTI / Reefer Expenses-PTI / YARD
1. How To: Input AP Master in AFSYS
Step 1,AP Master
Path: AFSYS àfinance àFinance Masters à AP Master
Input Creditor Code, Creditor Name, P.O.Box , Payment Type, Status, Invoice Limit Type, Credit Days,…, Swift Code, Short Name etc..
1. Payment Type= Cash, Invoice Limit Type, Credit Days,…, etc. No need input
Payment Type= Credit, Invoice Limit Type, Credit Days,…, etc. should need input
2. Creditor Code: code rule is port code + 4 seq no.
3. Swift Code: You can input reg no or ID for gov provide.
4. Short Name : Creditor Short Name
Step 2, Input Group Code
You can use 6 group codes as below, and can multiple select.
GAP_DEPOT、GAP_FEEDER、GAP_PORT、GAP_TMNL、GAP_TRUCK、GAP_YARD
Like Below, this vendor hv terminal expense and port expense business with TSL
Step 3, Input Currency and Save
You should input this company will settle which one currency with you.
Below case, this company can settle RMB and USD with you.
If you save finished, you can find out this record you input.
2. HowTo:Input Ex. Rate Master - Costing
System will check unberth date to fetch the equal or less date record .
In case of more than one records then system will take latest record.
3. HowTo:Input Port Tariff Charges
CHARGE_CODE / CHARGE_DESC / CHARGE_GROUPTLASH / Lashing / TERMINL
TOCHCV / Open/Close Hatch Covers / TERMINL
TOTHR / Terminal Other Charge / TERMINL
TSHIFT / Shift / TERMINL
TSTDCY-E / Stevedorage-CY-Export / TERMINL
TSTDCY-I / Stevedorage-CY-Import / TERMINL
TSTTK-E / Stevedorage-Tackle Export / TERMINL
TSTTK-I / Stevedorage-Tackle Import / TERMINL
TTALY / Tally / TERMINL
TWFPG / Wharfage/Cargo due /Habour Due / TERMINL
TWFRT / Waterfront / TERMINL
Port related tariff will be defined using this setup, user can define by Carrier, Port code with validity. Also they can link the supplier account to whom they need to settle the port related bills,
Charge Type :- System will bring all the expense charge codes from the BL charge master and user can identity by each type of expense. Its mandatory for defining the tariff.
Container Type: User needs to define the tariff by each container type wise, its mandatory in the above setup.
Service Type : Dropdown to select whether its Full or Empty
Activity : Dropdown to select whether the tariff is for Normal or Transshipment or Shutout
Activity Type : If its Transshipment, user needs to whether its Domestic or International
In/Out : User needs to identify whether the activity is related to Import or Export or N/A.
Shift Term : Applicable for shifting activity and user needs to identify the type of Shifting as shown below
Hazardous : User to identify Hazardous and Non Hazardous separately as shown below
OOG: User to identify OOG and Non OOG separately as shown below
Calculation Type : User needs to identify the calculation method, whether its applicable by Unit or Teu or Shift or Hour as shown below
If there is a discounted price, user can enter the original price and discount rate as shown above. System will calculate the actual price automatically.
Ex Rate Pick : User can identify the basis for exchange rate picking during calculation as shown below,
If its OOG cargo, user needs to identify the details as shown in the screen below.
Other than OOG, the above details are not mandatory.
Once the tariff is defined, user can view the details in the same screen and add additional details if required.
4. HowTo:Input Transporter Tariff
CHARGE_CODE / CHARGE_DESC / CHARGE_GROUPTKDRAYG-LD / Transporter-TRUCK Laden / TRUCKER
TKDRAYG-MT / Transporter-TRUCK Empty / TRUCKER
1. Daily Bunker Rate
User can enter the daily bunker rate as shown below, user need to maintain by agent location, currency wise what’s the bunker rate.
2. Transporter Rate Master(Cost)
User can feed each transport operator wise tariff in the screen shown below,
As requested we have the slab in the tariff details, like whether its based on Weight, Bunker, Weight and Bunker
i. Weight based
ii. Bunker Based
iii. Weight+Bunker Based
5. HowTo: Input Storage
CHARGE_CODE / CHARGE_DESC / CHARGE_GROUPYSTG-EXLDN / Export Storage - Laden / YARD
YSTG-EXMTY / Export Storage - Empty / YARD
YSTG-IMLDN / Import Storage - Laden / YARD
YSTG-IMMTY / Import Storage - Empty / YARD
YSTG-SULDN / Shut Out Storage - Laden / YARD
YSTG-SUMTY / Shut Out Storage - Empty / YARD
YSTG-TSLDN / TSP Storage - Laden / YARD
YSTG-TSMTY / TSP Storage - Empty / YARD
I. Free Pool
As shown below, user can enter the free pool setup with the Teus limit and applicable charges per Teus. User needs to link the charge code for empty storage as per the move charge setup in Equipment control.
II. Port Free Days
Port free days applicable in each port/terminal can be defined here. User needs to maintained separate move charge for laden and empty containers.
For each container type, user can define the applicable free days with the validity and also for DG and OOG, separate free days can be defined as follows.
III. Country Holidays
How to maintain the Country Holidays for Storage
This module is particularly used for the port which the Storage Calculation is based on Working day basis
Path : Equipment Control -> Equipment Master-> Country Holidays
Fig1
Insert : Press the “+” to Insert a new port-wise holiday entry
Fig2
How to maintain the Holiday Entry : The Holiday in this module user need to maintain includes not only country specific public holiday but Saturday and Sunday as well.
This is maintained by Charge Type-wise
1 Port : Get the Port code in the LOV(list of value)
2 Charge Type : of Move charge code : YSTG-.
3 Choose Week End: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday or Not Applicable.
4 User need to maintain
Fig3
IV. Storage Tariff
Storage tariff for containers will be maintained here, system has a facility to define the tariff by tiers based on the days.
Storage tariff will be maintained based on container type, COC/SOC and Service wise(FCL/LCL/EMPTY) as shown below
For DG and OOG, additional rates applicable can be easily identify based on the Type as follows,
Percentage : System will apply the percentage on the basic rate in order to calculate the additional charges applicable for DG and OOG
Factor : System will multiply the number of times on the basic rate
Fixed Amount : System has a facility to add the fixed amount applicable for DG and OOG in addition to the basic rate
The above charges to be defined for Laden and Empty storage separately, if the tariff is different for Import and Export separately. User needs to maintain different move charges codes and accordingly Equipment Move – charge link to be maintained separately.
6. HowTo: Input Refeer
Reefer inspection fee calculation needs to be incorporated in to cost calculation and the calculated figure should be reflected in E3 report
More Details
Tariff
Existing master setup needs to be modified to accept some additional fields
Basis – This should be a drop down and should contain 2 values
Per Hour
Per Shift
Hours – This field should be enabled incase if the “Basis” field selected as “Per Hour”
User will input the required number of hours like 1, 4, 8
From Time/To Time – These 2 fields should be enabled incase if the “Basis” field selected as “Per Shift”
User should be able to enter the shift as follows
From time ~ To time
01:00 ~ 08.00
08.01 ~ 16.00
16.01 ~ 24.00
Calculation
Rule : System should calculate reefer inspection fee for all reefer containers with FC move to LF move
Initial setting
Move cost link should be done with the respective container move combination as follows
From Move – FC
To Move – LF
BL Charge code – Need to select the corresponding charge code created in BL charge master for “reefer inspection fee”
Container costing generation
Based on the move cost link, system needs to read the equipment movements and needs to fetch the container details
Based on the charge code in the move cost link and the current location of the move, system needs to read the reefer inspection fee tariff and needs to fetch the correct tariff
Example 1:
Terminal : TWTXG
Basis: Hours
Hours: 1
Rate: 10
FC – 10-Jun-2013 14:00
LF – 10-Jun-2013 23:00
If the basis = Hours then find what is the respective hours updated in tariff
Suppose if the same has been updated as 1 hour then the result will be
Hours = LF date – FC date
Amount = Rate * Hours
90 = 10 * 9
If the result hours are having fraction, then round the hours to the next integer
Ex: 8 hrs 10 mins should be round off to 9 hours
Example 2:
Terminal: TWKEL
Basis: Hours
Hours: 4
Rate: 20
FC – 10-Jun-2013 14:00
LF – 10-Jun-2013 23:00
If the basis = Hours then find what is the respective hours updated in tariff
Suppose if the same has been updated as 4 hour then the result will be
Hours = LF date – FC date
Hrs1 = Hours/4
3 = 9/4 (result round off to the next value)
Amount = Rate * Hours
60 = 20 * 3
Example 3:
Terminal: TWKHH
Basis: Shift
Shift: From ~ To à Rate
01:00 ~ 08.00 à 40
08.01 ~ 16.00 à 40
16.01 ~ 24.00 à 40
FC – 10-Jun-2013 14:00
LF – 10-Jun-2013 23:00
From 14:00 to 16:00 à Shift 2 = 40
From 16.01 to 23:00 à Shift 3 = 40
Amount = No.Shift 1 * Shift 1 Rate + No.Shift 2 * Shift 2 Rate + No. Shift 3 * Shift 3 Rate
80 = 0 * 40 + 1 * 40 + 1 * 40
E3 Report generation
E3 report should reflect the reefer inspection fee based on the cost calculation (Reefer monitor 20/40 fields)
20/24