Client Statistics Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Figures)
Line 75: Line 75:
=== Figures ===
=== Figures ===
-
=== Figure 0. Filters ===
+
==== Figure 0. Filters ====
[[File:ClientStatsReport.JPG]]
[[File:ClientStatsReport.JPG]]

Revision as of 22:29, 20 May 2010


Contents

Info

1598

CBN: Core Business Need

This report should help in defining the amount of shipments handled for specific Client Company (or group).

BR: Business Requirements

Summary

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?
  • Truck: How many CT shipments and how much total Gross weight per month for each trucking company from origin terminal to destination terminal?

Details Per Mode

  • 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

Figures

Figure 0. Filters

File:ClientStatsReport.JPG

Figure 1. Mode FCL

FCL

Figure 2. Mode LCL

File:ClientLCLStats.JPG

Figure 3. Mode Air

File:ClientAir.JPG

Figure 4. Mode Truck

File:ClientTruckStat.JPG

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

40'ft

40'hq

T.E.U

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

History

Personal tools