Rates db Ocean FCL

From UG

(Difference between revisions)
Jump to: navigation, search
 
(35 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Projects]]
+
[[Category:Rates DB]]
== Info ==
== Info ==
-
* mantis# 0002894: [Rates DB] Implement phase1 for MOT Air
+
* 0002962: [Rates DB] Implement phase2 for MOT Ocean FCL and LCL
 +
* [[Rates DB]]
 +
* [[Rates DB Air]]
-
See also:  http://ct.jaguarfreight.com/wiki/Rates_DB
+
== Glossary ==
 +
See also [[Rates DB]]
-
== Glossary ==
+
'''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
== Summary ==
== Summary ==
Line 27: Line 46:
=== Current business process ===
=== Current business process ===
 +
====NY Office====
-
=== Future business process ===
+
Like air rate management, research, and quoting is handled by the Isales team.
 +
=====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.
 +
 +
=====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.
 +
 +
====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.
 +
 +
==== 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.
 +
 +
==== Hong Kong Office====
 +
 +
=====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.
 +
 +
=====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 ===
== 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