Client Statistics Report
From UG
(Difference between revisions)
(→Sort By Definitions) |
|||
| Line 30: | Line 30: | ||
* '''Truck''': How many CT shipments and how much total Gross weight per month for each trucking company from origin terminal to destination terminal? | * '''Truck''': How many CT shipments and how much total Gross weight per month for each trucking company from origin terminal to destination terminal? | ||
| + | === Details === | ||
| - | + | * Totals are per month based on Actual Collection Date | |
| - | + | ||
| - | + | ||
| - | * | + | |
| - | + | ||
| - | + | ||
'''MOT = FCL''' | '''MOT = FCL''' | ||
| Line 93: | Line 89: | ||
[[File:ClientTruckStat.JPG]] | [[File:ClientTruckStat.JPG]] | ||
| - | ==== | + | ==== Output ==== |
| - | * | + | * spreadsheet only |
| - | * Spreadsheet tabs: | + | * Spreadsheet tabs: one tab per mode |
* Spreadsheet consists of Header, Body, and footer | * Spreadsheet consists of Header, Body, and footer | ||
* Header: | * Header: | ||
| Line 191: | Line 187: | ||
:* sum up result per column per location country from to location country to | :* sum up result per column per location country from to location country to | ||
| - | + | ||
| - | + | ||
| - | + | ||
== History == | == History == | ||
| - | |||
Revision as of 22:23, 20 May 2010
Contents |
Info
CBN: Core Business Need
This report should help in defining the amount of shipments handled for specific Client Company (or group).
BR: Business Requirements
For specific Client Company (or group) this report should help to answer these basic questions:
- FCL:
- How many containers with different types and sizes with T.E.U. per month from each origin terminal to each destination terminal?
- LCL:
- How many CT shipments
- How much total of gross weight
- Total in cbm per month for each LCL shipment from each origin terminal to each destination terminal each month
- Air:
- How many CT shipments
- How much chargeable weight
- and average weight per month
- for each airline
- from origin terminal to destination terminal?
- for each airline
- Truck: How many CT shipments and how much total Gross weight per month for each trucking company from origin terminal to destination terminal?
Details
- Totals are per month based on Actual Collection Date
MOT = FCL
- Total containers with each combination between types and sizes listed below
- 20 ft (include all types)
- 40 ft (include all types except HQ)
- 40 hq (40 hq only)
- 45 ft (include all types)
- T.E.U (Twenty Equivalent Unit: 20 ft = 1 Equivalent)
- NOTE: 1 40 ft/hq or 45 ft = 2 T.E.U
- Total of each column
- Mapped to ContTab.size and ContTab.Type (15 cases to fit in 4 categories)
MOT = LCL
- Total CT shipments
- Total Gross weight
- Total in cbm
- Average weight
- Total of weight/number of CT shipments
- Total of each column
- Mapped to ContTab.Table A. GrandTotal.Ttl G kg (2 decimal places)
- Mapped to ContTab.Table B. Total (in cbm)
MOT = AIR
- Total CT shipments
- Total chargeable weight
- Average weight
- Total of weight/number of CT shipments
- Total of each column
- Mapped to ExpTab.17b: Chargeable weight
MOT = Truck
- Total CT shipments
- Total Gross weight
- Average weight
- Total of weight/number of CT shipments
- Total of each column
- Mapped to ContTab.Table A. GrandTotal.Ttl G kg
UI example
Output
Figure 1. Mode FCL
Figure 2. Mode LCL
Figure 3. Mode Air
Figure 4. Mode Truck
Output
- spreadsheet only
- Spreadsheet tabs: one tab per mode
- Spreadsheet consists of Header, Body, and footer
- Header:
- Report name
- Date time stamp
- Criteria(list of filters selected)
- Jaguar Logo
- Body:(general info)
- consists of sections: separately by from country to country
- Each section label from country -> country
- In case there is sub-section, list subsection such as Airline,...etc
- Figure 1: refer an example of one section
- Many sections should be separated by one row
- Table consists of columns. See #Column Definitions below
- Footer:
- There is no footer
Columns Definitions
MOT: FCL
Origin Terminal
- location that shipment is moved from (port)
Destination Terminal
- location that shipment is moved to (port)
Month
- Report by monthly (Jan - Dec); depend on Month filter is selected
20'ft
- summary count() for that particular size and types: See #Hard Coded Conditions
40'ft
- summary count() for that particular size and types: See #Hard Coded Conditions
40'hq
- summary count() for that particular size and types: See #Hard Coded Conditions
T.E.U
- summary calculation for that particular size and types: See #Hard Coded Conditions
Total with label (country -> country)
- sum up result per column per "location country from" to "location country to"
MOT: LCL
Origin Terminal
- location that shipment is moved from (port)
Destination Terminal
- location that shipment is moved to (port)
Month
- Report by monthly (Jan - Dec); depend on Month filter is selected
CT
- summary shipments count()
Gross weight
- summary gross weight count()
cbm
- summary cbm count()
Avg weight
- summary calculation: Total of gross weight/number of CT shipments count()
Total with label (country -> country)
- sum up result per column per location country from to location country to
MOT: AIR
Origin Terminal
- location that shipment is moved from (port)
Destination Terminal
- location that shipment is moved to (port)
Month
- Report by monthly (Jan - Dec); depend on Month filter is selected
Airline (make it Italic & blue)
- Airlines that moves shipment from one location to the other location within from (port) to (port) country
CT
- summary shipments count()
Chg weight
- summary chargeable weight count()
Avg weight
- summary calculation: Total of chargeable weight/number of CT shipments count()
Total (make it Italic)
- sum up result per column for each airline
Total with label (country -> country)
- sum up result per column per location country from to location country to
MOT: TRUCK
Origin Terminal
- location that shipment is moved from (port)
Destination Terminal
- location that shipment is moved to (port)
Month
- Report by monthly (Jan - Dec); depend on Month filter is selected
CT
- summary shipments count()
Gross weight
- summary gross weight count()
Avg weight
- summary calculation: Total of gross weight/number of CT shipments count()
Total
- sum up result per column per location country from to location country to
