Client Statistics Report

From UG

(Difference between revisions)
Jump to: navigation, search
(SD: Systems Design)
(CBN: Core Business Need)
Line 4: Line 4:
== Info ==
== Info ==
[http://mantis.jaguarfreight.com/mantis/view.php?id=1598 1598]
[http://mantis.jaguarfreight.com/mantis/view.php?id=1598 1598]
 +
 +
== CBN: Core Business Need ==
== CBN: Core Business Need ==
 +
<div style="background-color:DarkSalmon;">
 +
This report should help in defining the amount of shipments handled for specific '''Client Company (or group)'''.
This report should help in defining the amount of shipments handled for specific '''Client Company (or group)'''.
Line 11: Line 15:
This report is related to [[Carrier Statistic Report]]
This report is related to [[Carrier Statistic Report]]
-
<div style="background-color:DarkSalmon;">
+
 
 +
</div>
== BR: Business Requirements and Design Ideas ==
== BR: Business Requirements and Design Ideas ==

Revision as of 15:39, 24 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).

This report is related to Carrier Statistic Report


BR: Business Requirements and Design Ideas

BR: 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 TEU 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?

BR: 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


BR: 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

BR: 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

BR: 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

</div>

SD: Systems Design

TBD

TBD

TBD

TBD


TBD

TBD

TBD

History

m1511

http://mantis.jaguarfreight.com/mantis/view.php?id=1511

BA 1511

SA 1511

Personal tools