CK model for Rates DB Ocean (requirements)

From UG

(Difference between revisions)
Jump to: navigation, search
(Current Business Process)
(Current Business Process)
Line 48: Line 48:
== Current Business Process ==
== Current Business Process ==
-
The current business process for ocean FCL is similar to that of Air ( [[CK model for Rates DB Air (requirements)]] ).  The difference for ocean is that the information that is shared, is on multiple spreadsheets.   
+
The current business process for ocean FCL is similar to that of Air ( [[CK model for Rates DB Air (requirements)]] ).   
 +
 
 +
The difference for ocean is that the information that is shared, is on multiple spreadsheets.   
 +
 
 +
These spreadsheet are all in different formats.
Each spreadsheet is being updated by difference offices.
Each spreadsheet is being updated by difference offices.
-
*EU-FE is handled by Europe offices (London and Paris)
+
*EU-FE is handled by the Europe offices.
-
*EU-US is handled by the New York office (Inside Sales Team)
+
**London and Paris  
 +
*EU-US is handled by the New York office
 +
**Inside Sales Team
*FE-EU is handled by Europe offices
*FE-EU is handled by Europe offices
*FE-US is handled by the Hong Kong office
*FE-US is handled by the Hong Kong office
*US-EU is handled by the New York office
*US-EU is handled by the New York office
*US-FE is handled by the New York office
*US-FE is handled by the New York office
 +
 +
These spreadsheets are also being shared through dropbox and are still password protected.
==Examples==
==Examples==

Revision as of 16:19, 29 July 2011


Contents

Info

0002690: [Rates DB] ..... <project>

0003097: [Rates DB] Implement phase 3 (CK model for FCL)

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


For additional definitions please see Rates_DB#Glossary

Summary

The requirements for ocean FCL will be the same as the requirements covered in both:

CK model for Rates DB Air (requirements)

AND

Rates DB

Unlike Air, which has only one spreadsheet shared between offices, Ocean FCL has several spreadsheets, in different formats.

Each spreadsheet will be uploaded into the project mantis 2690 and mantis 3097 Implement phase 3 (CK model for FCL)

Current Business Process

The current business process for ocean FCL is similar to that of Air ( CK model for Rates DB Air (requirements) ).

The difference for ocean is that the information that is shared, is on multiple spreadsheets.

These spreadsheet are all in different formats.

Each spreadsheet is being updated by difference offices.

  • EU-FE is handled by the Europe offices.
    • London and Paris
  • EU-US is handled by the New York office
    • Inside Sales Team
  • FE-EU is handled by Europe offices
  • FE-US is handled by the Hong Kong office
  • US-EU is handled by the New York office
  • US-FE is handled by the New York office

These spreadsheets are also being shared through dropbox and are still password protected.

Examples

Most of the spreadsheets are to large, to take only one screen shot. So most of these will have multiple images.

FE-US spreadsheet

Rate or Data tab - colums A - U File:FE - US Columns A - U.JPG

Rate or Data tab - colums V - AG File:FE-US Columns V - AG.JPG


Pivot Table File:FE-US Pivot tablea.JPG


Surcharge Tab column A - R File:FE-US Surcharges column A - R.JPG

Surcharge Tab column S - AI File:FE-US Surcharges column S - AI.JPG

Surcharge Tab column AJ - AR File:FE-US Surcharges column AJ-AR.JPG


FE-EU spreadsheet

Rate or Data tab - colums A - O File:FE-EU columns A - O.JPG

Rate or Data tab - colums P - V File:FE - EU Columns P - V.JPG


Pivot Table

File:FE-EU Pivot Table updated.JPG


EU-FE spreadsheet

Rate or Data tab - colums A - P File:EU-FE Columns A-P updated.JPG


Rate or Data tab - colums P - V File:EU-FE - columns P - V.JPG


Pivot Table

File:EU-FE Pivot table updated1.JPG


EU-US spreadsheet

Rate or Data tab - colums A - Q File:EU - US Columns A-Q.JPG

Rate or Data tab - colums R - AH File:EU-US Columns R - AH.JPG

Rate or Data tab - colums AI - AX File:EU-US AI - AX.JPG

Rate or Data tab - colums AY - BK File:EU - US Columns AY - BK updated.JPG

Pivot Table

File:EU-US Pivot table updated 2.JPG


US-FE spreadsheet

Rate or Data tab - colums A - R File:US - FE Columns A - R.JPG

Rate or Data tab - colums S - AY File:US - FE Columns S - AY.JPG

Rate or Data tab - colums AZ - BQ File:US - FE Columns AZ - BQ.JPG

Rate or Data tab - colums BR - CA File:US - FE Columns BR - CA.JPG

Pivot Table File:US-FE Pivot table updated 2.JPG


US-EU spreadsheet

Rate or Data tab - colums A - R File:US- EU Columns A - R.JPG

Rate or Data tab - colums S - AJ File:US - EU Columns S - AJ.JPG

Rate or Data tab - colums AK - BA File:US-EU Columns AK - BAa.JPG

Rate or Data tab - colums BA - BR File:US - EU Columns BA - BR.JPG


Pivot Table File:US-EU Pivot table.JPG

Business Requirements

Questions and Answer from Chikei

Personal tools