Rates db Ocean FCL

From UG

(Difference between revisions)
Jump to: navigation, search
(London Office)
 
(19 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Projects]]
+
[[Category:Rates DB]]
== Info ==
== Info ==
Line 7: Line 7:
== Glossary ==
== Glossary ==
-
See [[Rates DB]]
+
See also [[Rates DB]]
'''FE''' - Far East
'''FE''' - Far East
Line 22: Line 22:
'''TPEB''' - Trans Pacific east bound
'''TPEB''' - Trans Pacific east bound
 +
 +
'''TEU''' - Twenty-foot equivalent unit
 +
 +
'''FEU''' - Forty-foot equivalent unit
== Summary ==
== Summary ==
Line 47: Line 51:
=====Contracted Rates=====
=====Contracted Rates=====
 +
NY manages all of the contracted rates for:  
NY manages all of the contracted rates for:  
Line 53: Line 58:
*TAWB (Trans Atlantic West Bound)
*TAWB (Trans Atlantic West Bound)
*TAEB (Trans Atlantic East Bound)
*TAEB (Trans Atlantic East Bound)
 +
They have contracts in place with:
They have contracts in place with:
Line 63: Line 69:
*ANL, US Lines, and CMA CGM group
*ANL, US Lines, and CMA CGM group
*Cosco  
*Cosco  
 +
All Contracts are received as a word documents via email.
All Contracts are received as a word documents via email.
Line 72: Line 79:
Management Dynamics requires all contracts are received in Word documents.
Management Dynamics requires all contracts are received in Word documents.
-
Rate Explorer is the current program used to manage and research contracted rates.
+
Rate Explorer is the current program used to manage and research contracted rates.
=====Non-Contracted Rates=====
=====Non-Contracted Rates=====
ACL is one steamship line that we are using, but we have no contract with.
ACL is one steamship line that we are using, but we have no contract with.
 +
ACL is only used going to two destinations:  
ACL is only used going to two destinations:  
*Liverpool
*Liverpool
*Dublin
*Dublin
 +
ACL will send a PDF attachment via email with rates for these destinations.  These rates will be valid for 30 days.
ACL will send a PDF attachment via email with rates for these destinations.  These rates will be valid for 30 days.
Line 93: Line 102:
Rates in the London office are managed by Anshu Maddan.
Rates in the London office are managed by Anshu Maddan.
-
The London office does handle Ocean line contracts.
+
The London office does not deal with contracts.  Instead they receive quotes from the steamship lines and if the rate is agreed to, they will file the rate with the steamship line.
 +
These rates are usually updated once a month (in the beginning), but amendments can be sent at any time during the month.
-
3-      Where are these rates or contracts being maintained? - Unlike US, we dont sign contracts. We get the rates from the carrier, and these are workable we get them filed with the carrier against a quote ref number. These quotes are generally in our emails or in the common drive.  How long are these quotes valid for.  Besides saving them in the shared drive, are they added the rate sheet referred to below?  Are  these quotes updated in rate explorer?
+
They update an excel spreadsheet that is shared with Hong Kong and Paris with any rates that are FE to EU
-
These quotes are generally valid till the end of current month In certain cases specail rates can be obtained for a quarter, subject to changes in the surcharges. The rates on FE-EU tradelane are added on the rate sheet. These rates are not updated in the rate explorer. 
+
 +
All other rates are either maintained in a shared local folder, in there emails, or actual copies.
-
4-      What are the current procedures for updating and/or maintaining these rates?
+
For shipments from US to EU or from EU to US, the rates are managed by the NY office, so the London office will only search rates in Rate ExplorerLondon does not have anything added to rate explorer.
-
+
-
Imports From  Far East / Asia into UK/France/ Parts of Europe-  - We have a common rate sheet between Hongkong / London/Paris office and resp offices update the rate on resp carriers as and when the carriers change the rates. Please find one of the example email attached. London/Paris/Hongkong offices work with different carriers so we get rates on various carriers and there comparisons in the attached sheet.
+
-
+
-
Exports From  UK/France/ Parts of Europe- Far East / Asia - These are handled on case to case basis. The rates are in emails/ common drives.  
+
-
   
+
-
Imports/ Exports to/from US into UK/France/ Parts of Europe- These are generally handled on the contracted rates, as contracted in the US. Currently we use rate Explorer to access these. We have exceptions where in rates are obtained in UK for particular businesses, and these ae maintained in our emails only.
+
-
+
-
5-      On average, how often are these rates updated?
+
For shipments from FE to US and FE to EU they can search the rates on the spreadsheet shared with Hong Kong.
-
+
-
These rates are updated begginning of each month generally, and also, amended whenever any carrier amends there rates.
+
-
6-      How many ocean contracts are handling by your office?
+
For shipments from EU to FE they will search emails or the shared local folder.
-
a.      For what lines?
+
-
+
-
Unlike US, we dont sign contracts in UK/France.  We work with various lines depending on the tradelane they specialise in.  
+
-
7-     How are amendments handled?
+
Co-loaders rates are received and search in email exchangesLike all the other office, the London office tries to avoid using co-loaders for FCL shipments.
-
+
-
They are updated in the attached rate sheet as and they occur.   
+
-
8-      In what form are contracts received?
+
==== Paris Office====
-
a.      Can you please send me one example of each type?
+
Rates in the Paris office are handled by Inma
-
Please find Far East WB rates on MSC as attached.  Are all of the contracts received in similar format to the MSC?  There is no standard format. All shipping lines use different format, rather, every tradelane in the same shipping line use different formats as well. 
+
 +
The Paris office follows the same procedures as the London Office.
-
9-      Do we ever have the need to use a Co-loader for an FCL shipment?
+
Paris handles the quotes with
-
a.      If so what are the reasons for doing this?
+
* Evergreen
-
b.      Do we have contracts in place for this?
+
* CMA CGM
-
c.      If so how are they received/maintained?
+
* ANL on occasion
-
d.      If not how do we obtain the costs?
+
-
e.      What co-loaders do we use?
+
-
In normal circumstances we prefer not to use coloaders for FCL shipmens. Exceptionally they can be used if they have exceptionally good rates for any of our particular business. rates are maintained in the emails only.
+
These are stored in a shared drive and are usually on a case by case or shipment by shipment basis.
-
+
-
10-  Who handles quoting out sell rates for FCL shipments?
+
-
Myself in London and Inma in Paris. Do you use rate explorer to search for cost rates?  Yes
+
-
11-  How do they access the cost’s?
+
==== Hong Kong Office====
-
Attached rate sheet and rate explorer, with exceptions of Exports into Far East/Asia, where the rates are obtained case to case basis via email from carriers.  Do you also use the shared drive for cost’s?  Yes, but it is only limited to pass on the costs to the operators, so that they can check the invoices before processing.
+
 +
=====Contracted Rates=====
-
12-  Having a rate database in place for ocean FCL, In what way do you think we can improve the current procedures?
+
All of the operators in the Hong Kong office deal with rates.
-
It can expediate the whole procedure of getting the quotes out to the customer.
+
-
Eventually, when we have the rates in Cybertrax, we can get the reports, which can help us negotiate better rates with carriers.  
+
-
13-  How would you like to see this rate database maintained, who do you think would be responsible for updating it?
+
They will all contact the steamship line directly if a rate is required.
-
This requires a lot of data entry, so is agree as proposed, one common office can be incharge.
+
-
14-  What issues do you currently face with the current procedures for obtaining costs and quoting sales?
+
The Hong Kong office is currently managing shipments for
-
We need to look into different places for rates, compare and then manually do the quotes. This is time consuming and delays the quotes to the customers. 
+
* TPEB
-
15-  Please comment on any additional information you could provide to help us build this database to meet all of the user’s needs.  Any information you provide will be extremely valuable to us.
+
They have rates in place with
 +
*EMC
 +
*ANL
 +
*NYK
 +
*OOCL
 +
*MSC
 +
*APL
-
==== Hong Kong Office====
+
Sam or Peter in the Hong Kong Office are the ones who will forward the contracts to Management Dynamics to be uploaded into Rate Explorer.
 +
 
 +
Hong Kong also maintains / uses the spreadsheet shared with the Paris and London offices.
 +
 
 +
=====Non-Contracted Rates=====
 +
 
 +
If no space is available with a steamship line under an existing service contract they will contact a co-loader for a rate. 
 +
 
 +
This is usually done via email on a shipment by shipment basis.
 +
 
 +
These rates are stored with in the emails or on the local shared drive.
=== Future business process ===
=== Future business process ===
== Various types of Contracts and Tariffs And How to calculate rate from point A to point B ==
== Various types of Contracts and Tariffs And How to calculate rate from point A to point B ==

Current revision as of 11:51, 12 July 2011


Contents

[edit] Info

[edit] Glossary

See also Rates DB

FE - Far East

EU - European Union

US - United States

TAWB - Trans Atlantic west bound

TAEB - Trans Atlantic east bound

TPWB - Trans Pacific west bound

TPEB - Trans Pacific east bound

TEU - Twenty-foot equivalent unit

FEU - Forty-foot equivalent unit

[edit] Summary

What are we trying to achieve? What are the main goals of this module?

[edit] Core need

See Rates DB.

[edit] Core functionality

See Rates DB.

[edit] Detailed Requirements and Related Information

[edit] Charge codes related to Rates db Ocean FCL

[edit] Current business process

[edit] NY Office

Like air rate management, research, and quoting is handled by the Isales team.

[edit] Contracted Rates

NY manages all of the contracted rates for:

  • TPWB (Trans Pacific West Bound)
  • TAWB (Trans Atlantic West Bound)
  • TAEB (Trans Atlantic East Bound)


They have contracts in place with:

  • NYK (Nippon Yusen Kaisha)
  • OOCL (Orient Overseas Container Line)
  • Yang Ming
  • Evergreen
  • APL (American President Lines)
  • ANL, US Lines, and CMA CGM group
  • Cosco


All Contracts are received as a word documents via email.

When they are received, they are reviewed and if necessary negotiated. Once agreed upon, the contract is signed and filed with the steamship line.

Once the rate has been filed with the steamship line, the ISales department will forward this on to Management Dynamics to be entered into Rate Explorer.

Management Dynamics requires all contracts are received in Word documents.

Rate Explorer is the current program used to manage and research contracted rates.

[edit] Non-Contracted Rates

ACL is one steamship line that we are using, but we have no contract with.


ACL is only used going to two destinations:

  • Liverpool
  • Dublin


ACL will send a PDF attachment via email with rates for these destinations. These rates will be valid for 30 days.

This PDF will be used to determine the cost's within the 30 days of receiving it. If it is past the 30 days, the ISales team will email ACL for updated rates.

Occasionally a co-loader will be used for FCL shipments. This is not the preferred way, but sometimes they will be able to provide space on a vessel that we cannot book with the steamship line or offer lower rates then the steamship line.

They will email the co-loader for a rate or search the co-loaders website. The co-loader will email back with the rate listed in the email. Like spot rates for air shipments, this rate will be valid only for the specific shipment it is requested for.

[edit] London Office

Rates in the London office are managed by Anshu Maddan.

The London office does not deal with contracts. Instead they receive quotes from the steamship lines and if the rate is agreed to, they will file the rate with the steamship line.

These rates are usually updated once a month (in the beginning), but amendments can be sent at any time during the month.

They update an excel spreadsheet that is shared with Hong Kong and Paris with any rates that are FE to EU

All other rates are either maintained in a shared local folder, in there emails, or actual copies.

For shipments from US to EU or from EU to US, the rates are managed by the NY office, so the London office will only search rates in Rate Explorer. London does not have anything added to rate explorer.

For shipments from FE to US and FE to EU they can search the rates on the spreadsheet shared with Hong Kong.

For shipments from EU to FE they will search emails or the shared local folder.

Co-loaders rates are received and search in email exchanges. Like all the other office, the London office tries to avoid using co-loaders for FCL shipments.

[edit] Paris Office

Rates in the Paris office are handled by Inma

The Paris office follows the same procedures as the London Office.

Paris handles the quotes with

  • Evergreen
  • CMA CGM
  • ANL on occasion

These are stored in a shared drive and are usually on a case by case or shipment by shipment basis.

[edit] Hong Kong Office

[edit] Contracted Rates

All of the operators in the Hong Kong office deal with rates.

They will all contact the steamship line directly if a rate is required.

The Hong Kong office is currently managing shipments for

  • TPEB

They have rates in place with

  • EMC
  • ANL
  • NYK
  • OOCL
  • MSC
  • APL

Sam or Peter in the Hong Kong Office are the ones who will forward the contracts to Management Dynamics to be uploaded into Rate Explorer.

Hong Kong also maintains / uses the spreadsheet shared with the Paris and London offices.

[edit] Non-Contracted Rates

If no space is available with a steamship line under an existing service contract they will contact a co-loader for a rate.

This is usually done via email on a shipment by shipment basis.

These rates are stored with in the emails or on the local shared drive.

[edit] Future business process

[edit] Various types of Contracts and Tariffs And How to calculate rate from point A to point B

Personal tools