Estimated GM: Proof Of Concept

From UG

(Difference between revisions)
Jump to: navigation, search
(Estimated Sales Rates Report for Air for 2011 shipments)
(SOW 0 Proof Of Concept)
Line 3: Line 3:
== SOW 0 Proof Of Concept ==
== SOW 0 Proof Of Concept ==
-
=== Estimated Client Origin Destination Triple Sales Rates Per Chargeable Kg Average Report for Jaguar 2011 Air Shipments ===
+
=== Estimated Average Sales Rates Report ===
 +
 
 +
This estimation is based on:
 +
* Client / Origin / Destination unique Triples
 +
** NOTE: Origin = country from Airport of Dept
 +
** NOTE: Dest = country from Airport of Dest
 +
* Chargeable Kg amounts
 +
* 2011 Air Shipments
 +
 
 +
'''Report Conditions:'''
 +
 
 +
Aggregate for each unique (Client / Origin / Destination) Triple with existing data from CTs that satisfy:
 +
* MOT = Air
 +
* Jan 1, 2011 < CTs with Actual Date of Dept. < Dec 31, 2011
 +
 
 +
Report output:
 +
* xls form
 +
* each line corresponds to one (Client / Origin / Destination) Triple
 +
* columns:
 +
** A Client E0
 +
** B CT# (if part of a group then this is lowest CT# in a group)
 +
** C GRP# (or print "n/a" if CT is not part of a group)
 +
** D TTl ChgW (total chargeable weight of CT or GRP in Kg)
 +
** E TTl Sales ()
 +
** Avg S/ChgW (average sales per kg: total sales in USD for CT or GRP divided by TTl ChgW)
 +
 
 +
=== Estimated vs Actual Sales Report ===
 +
 
 +
This estimation is based on:
 +
* Client / Origin / Destination Triple
 +
* Chargeable Kg
 +
* 2011 Air Shipments
 +
 
 +
Report Conditions:
 +
* MOT = Air
 +
* Jan 1, 2011 < Actual Date of Dept. < Dec 31, 2011
 +
 
 +
Report output:
 +
* xls form
 +
* each line corresponds to one CT for CTs that are not part of a group
 +
* for CTs that are part of a group we need one line per group
 +
* columns:
 +
** A Client E0
 +
** B CT# (if part of a group then this is lowest CT# in a group)
 +
** C GRP# (or print "n/a" if CT is not part of a group)
 +
** D TTl ChgW (total chargeable weight of CT or GRP in Kg)
 +
** E TTl Sales ()
 +
** Avg S/ChgW (average sales per kg: total sales in USD for CT or GRP divided by TTl ChgW)

Revision as of 17:27, 18 April 2012


SOW 0 Proof Of Concept

Estimated Average Sales Rates Report

This estimation is based on:

  • Client / Origin / Destination unique Triples
    • NOTE: Origin = country from Airport of Dept
    • NOTE: Dest = country from Airport of Dest
  • Chargeable Kg amounts
  • 2011 Air Shipments

Report Conditions:

Aggregate for each unique (Client / Origin / Destination) Triple with existing data from CTs that satisfy:

  • MOT = Air
  • Jan 1, 2011 < CTs with Actual Date of Dept. < Dec 31, 2011

Report output:

  • xls form
  • each line corresponds to one (Client / Origin / Destination) Triple
  • columns:
    • A Client E0
    • B CT# (if part of a group then this is lowest CT# in a group)
    • C GRP# (or print "n/a" if CT is not part of a group)
    • D TTl ChgW (total chargeable weight of CT or GRP in Kg)
    • E TTl Sales ()
    • Avg S/ChgW (average sales per kg: total sales in USD for CT or GRP divided by TTl ChgW)

Estimated vs Actual Sales Report

This estimation is based on:

  • Client / Origin / Destination Triple
  • Chargeable Kg
  • 2011 Air Shipments

Report Conditions:

  • MOT = Air
  • Jan 1, 2011 < Actual Date of Dept. < Dec 31, 2011

Report output:

  • xls form
  • each line corresponds to one CT for CTs that are not part of a group
  • for CTs that are part of a group we need one line per group
  • columns:
    • A Client E0
    • B CT# (if part of a group then this is lowest CT# in a group)
    • C GRP# (or print "n/a" if CT is not part of a group)
    • D TTl ChgW (total chargeable weight of CT or GRP in Kg)
    • E TTl Sales ()
    • Avg S/ChgW (average sales per kg: total sales in USD for CT or GRP divided by TTl ChgW)
Personal tools