Estimated GM: Proof Of Concept

From UG

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)