CK model for Rates DB Ocean (requirements)

From UG

Revision as of 18:06, 27 July 2011 (edit) Tracie (Talk | contribs) (→Current Business Process) ← Older edit		Revision as of 19:28, 27 July 2011 (edit) (undo) Tracie (Talk | contribs) Newer edit →
Line 70:		Line 70:
	'''Surcharge Tab column AJ - AR'''		'''Surcharge Tab column AJ - AR'''
	[[File:FE-US Surcharges column AJ-AR.JPG]]		[[File:FE-US Surcharges column AJ-AR.JPG]]
		+
		+	===FE-EU spreadsheet===
		+
		+	File:FE-EU columns A - O.JPG
		+	File:FE - EU Columns P - V.JPG
		+	File:FE-EU Pivot table.JPG
		+
		+	===EU-FE spreadsheet===
		+	File:EU-FE Columns A-P.JPG
		+	File:EU-FE - columns P - V.JPG
		+	File:EU-FE Pivot Table.JPG
		+
		+	===EU-US spreadsheet===
		+	File:EU - US Columns A-Q.JPG
		+	File:EU-US Columns R - AH.JPG
		+	File:EU-US AI - AX.JPG
		+	File:EU - US Columns AY - BK.JPG
		+	File:EU-US Pivot Table.JPG
		+
		+	===US-FE spreadsheet===
		+	File:US - FE Columns A - R.JPG
		+	File:US - FE Columns S - AY.JPG
		+	File:US - FE Columns AZ - BQ.JPG
		+	File:US - FE Columns BR - CA.JPG
		+	File:US-FE Pivot table.JPG
		+
		+	===US-EU spreadsheet===
		+	File:US- EU Columns A - R.JPG
		+	File:US - EU Columns S - AJ.JPG
		+
		+
	== Business Requirements ==		== Business Requirements ==

---

Revision as of 19:28, 27 July 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

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

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 Rate or Data tab - colums V - AG

Pivot Table

Surcharge Tab column A - R Surcharge Tab column S - AI Surcharge Tab column AJ - AR

FE-EU spreadsheet

File:FE-EU columns A - O.JPG File:FE - EU Columns P - V.JPG File:FE-EU Pivot table.JPG

EU-FE spreadsheet

File:EU-FE Columns A-P.JPG File:EU-FE - columns P - V.JPG File:EU-FE Pivot Table.JPG

EU-US spreadsheet

File:EU - US Columns A-Q.JPG File:EU-US Columns R - AH.JPG File:EU-US AI - AX.JPG File:EU - US Columns AY - BK.JPG File:EU-US Pivot Table.JPG

US-FE spreadsheet

File:US - FE Columns A - R.JPG File:US - FE Columns S - AY.JPG File:US - FE Columns AZ - BQ.JPG File:US - FE Columns BR - CA.JPG File:US-FE Pivot table.JPG

US-EU spreadsheet

File:US- EU Columns A - R.JPG File:US - EU Columns S - AJ.JPG

Business Requirements

Questions and Answer from Chikei