CK model for Rates DB Ocean (requirements)

From UG

Revision as of 21:09, 27 July 2011 (edit) Tracie (Talk | contribs) (→US-FE spreadsheet) ← Older edit		Current revision as of 16:05, 15 August 2011 (edit) (undo) Tracie (Talk | contribs) (→Current Business Process)
(12 intermediate revisions not shown)
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.
		+	These spreadsheet are all in different formats.
		+
		+	Each spreadsheet is being updated by difference offices.
		+	*EU-FE is handled by the Europe offices.
		+	*EU-US is handled by the New York office
		+	*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==		==Examples==
Line 56:		Line 69:
	===FE-US spreadsheet===		===FE-US spreadsheet===
-	'''Rate or Data tab - colums A - U'''	+	'''Rate or Data tab - columns A - U'''
	[[File:FE - US Columns A - U.JPG]]		[[File:FE - US Columns A - U.JPG]]
-	'''Rate or Data tab - colums V - AG'''	+	'''Rate or Data tab - columns V - AG'''
	[[File:FE-US Columns V - AG.JPG]]		[[File:FE-US Columns V - AG.JPG]]
Line 67:		Line 80:
-	'''Surcharge Tab column A - R'''	+	'''Surcharge Tab columns A - R'''
	[[File:FE-US Surcharges column A - R.JPG]]		[[File:FE-US Surcharges column A - R.JPG]]
-	'''Surcharge Tab column S - AI'''	+	'''Surcharge Tab columns S - AI'''
	[[File:FE-US Surcharges column S - AI.JPG]]		[[File:FE-US Surcharges column S - AI.JPG]]
-	'''Surcharge Tab column AJ - AR'''	+	'''Surcharge Tab columns AJ - AR'''
	[[File:FE-US Surcharges column AJ-AR.JPG]]		[[File:FE-US Surcharges column AJ-AR.JPG]]
		+
		+
	===FE-EU spreadsheet===		===FE-EU spreadsheet===
Line 88:		Line 103:
	[[File:FE-EU Pivot Table updated.JPG]]		[[File:FE-EU Pivot Table updated.JPG]]
		+
		+
	===EU-FE spreadsheet===		===EU-FE spreadsheet===
-	'''Rate or Data tab - colums A - P'''	+	'''Rate or Data tab - columns A - P'''
	[[File:EU-FE Columns A-P updated.JPG]]		[[File:EU-FE Columns A-P updated.JPG]]
-	'''Rate or Data tab - colums P - V'''	+	'''Rate or Data tab - columns P - V'''
	[[File:EU-FE - columns P - V.JPG]]		[[File:EU-FE - columns P - V.JPG]]
Line 102:		Line 119:
	[[File:EU-FE Pivot table updated1.JPG]]		[[File:EU-FE Pivot table updated1.JPG]]
		+
		+
	===EU-US spreadsheet===		===EU-US spreadsheet===
-	'''Rate or Data tab - colums A - Q'''	+	'''Rate or Data tab - columns A - Q'''
	[[File:EU - US Columns A-Q.JPG]]		[[File:EU - US Columns A-Q.JPG]]
-	'''Rate or Data tab - colums R - AH'''	+	'''Rate or Data tab - columns R - AH'''
	[[File:EU-US Columns R - AH.JPG]]		[[File:EU-US Columns R - AH.JPG]]
-	'''Rate or Data tab - colums AI - AX'''	+	'''Rate or Data tab - columns AI - AX'''
	[[File:EU-US AI - AX.JPG]]		[[File:EU-US AI - AX.JPG]]
-	'''Rate or Data tab - colums AY - BK'''	+	'''Rate or Data tab - columns AY - BK'''
	[[File:EU - US Columns AY - BK updated.JPG]]		[[File:EU - US Columns AY - BK updated.JPG]]
		+
		+	'''Pivot Table'''
		+
		+	[[File:EU-US Pivot table updated 2.JPG]]
		+
		+
	===US-FE spreadsheet===		===US-FE spreadsheet===
-	'''Rate or Data tab - colums A - R'''	+	'''Rate or Data tab - columns A - R'''
	[[File:US - FE Columns A - R.JPG]]		[[File:US - FE Columns A - R.JPG]]
-	'''Rate or Data tab - colums S - AY'''	+	'''Rate or Data tab - columns S - AY'''
	[[File:US - FE Columns S - AY.JPG]]		[[File:US - FE Columns S - AY.JPG]]
-	'''Rate or Data tab - colums AZ - BQ'''	+	'''Rate or Data tab - columns AZ - BQ'''
	[[File:US - FE Columns AZ - BQ.JPG]]		[[File:US - FE Columns AZ - BQ.JPG]]
-	'''Rate or Data tab - colums BR - CA'''	+	'''Rate or Data tab - columns BR - CA'''
	[[File:US - FE Columns BR - CA.JPG]]		[[File:US - FE Columns BR - CA.JPG]]
	'''Pivot Table'''		'''Pivot Table'''
	[[File:US-FE Pivot table updated 2.JPG]]		[[File:US-FE Pivot table updated 2.JPG]]
		+
		+
	===US-EU spreadsheet===		===US-EU spreadsheet===
-	'''Rate or Data tab - colums A - R'''	+	'''Rate or Data tab - columns A - R'''
	[[File:US- EU Columns A - R.JPG]]		[[File:US- EU Columns A - R.JPG]]
-	'''Rate or Data tab - colums S - AJ'''	+	'''Rate or Data tab - columns S - AJ'''
	[[File:US - EU Columns S - AJ.JPG]]		[[File:US - EU Columns S - AJ.JPG]]
-	'''Rate or Data tab - colums AK - BA'''	+	'''Rate or Data tab - columns AK - BA'''
	[[File:US-EU Columns AK - BAa.JPG]]		[[File:US-EU Columns AK - BAa.JPG]]
-	'''Rate or Data tab - colums BA - BR'''	+	'''Rate or Data tab - columns BA - BR'''
	[[File:US - EU Columns BA - BR.JPG]]		[[File:US - EU Columns BA - BR.JPG]]
Line 154:		Line 181:
	== Business Requirements ==		== Business Requirements ==
		+	Ocean FCL has the same requirements as the air requirements.
	==Questions and Answer from Chikei==		==Questions and Answer from Chikei==

---

Current revision as of 16:05, 15 August 2011

Contents 1 Info 2 Glossary 3 Summary 4 Current Business Process 5 Examples 5.1 FE-US spreadsheet 5.2 FE-EU spreadsheet 5.3 EU-FE spreadsheet 5.4 EU-US spreadsheet 5.5 US-FE spreadsheet 5.6 US-EU spreadsheet 6 Business Requirements 7 Questions and Answer from Chikei

[edit] Info

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

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

Rates_DB

[edit] 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

[edit] 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)

[edit] 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.
• EU-US is handled by the New York office
• 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.

[edit] Examples

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

[edit] FE-US spreadsheet

Rate or Data tab - columns A - U

Rate or Data tab - columns V - AG

Pivot Table

Surcharge Tab columns A - R

Surcharge Tab columns S - AI

Surcharge Tab columns AJ - AR

[edit] FE-EU spreadsheet

Rate or Data tab - colums A - O

Rate or Data tab - colums P - V

Pivot Table

[edit] EU-FE spreadsheet

Rate or Data tab - columns A - P

Rate or Data tab - columns P - V

Pivot Table

[edit] EU-US spreadsheet

Rate or Data tab - columns A - Q

Rate or Data tab - columns R - AH

Rate or Data tab - columns AI - AX

Rate or Data tab - columns AY - BK

Pivot Table

[edit] US-FE spreadsheet

Rate or Data tab - columns A - R

Rate or Data tab - columns S - AY

Rate or Data tab - columns AZ - BQ

Rate or Data tab - columns BR - CA

Pivot Table

[edit] US-EU spreadsheet

Rate or Data tab - columns A - R

Rate or Data tab - columns S - AJ

Rate or Data tab - columns AK - BA

Rate or Data tab - columns BA - BR

Pivot Table

[edit] Business Requirements

Ocean FCL has the same requirements as the air requirements.

[edit] Questions and Answer from Chikei