Estimated GM: Proof Of Concept

From UG

Revision as of 20:05, 18 April 2012 (edit) Alex (Talk | contribs) (→SOW 0 Proof Of Concept) ← Older edit		Revision as of 20:27, 18 April 2012 (edit) (undo) Alex (Talk | contribs) (→SOW 0 Proof Of Concept) Newer edit →
Line 7:		Line 7:
	This estimation is based on:		This estimation is based on:
	* Client / Origin / Destination unique Triples		* Client / Origin / Destination unique Triples
-	** NOTE: Origin = country from Airport of Dept
-	** NOTE: Dest = country from Airport of Dest
	* Chargeable Kg amounts		* Chargeable Kg amounts
	* 2011 Air Shipments		* 2011 Air Shipments

---

Revision as of 20:27, 18 April 2012

SOW 0 Proof Of Concept

Estimated Average Sales Rates Report

This estimation is based on:

• Client / Origin / Destination unique Triples
• 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

Parameters:

• Time frame for calculating estimated rates (ERTF)
  • Jan 1, 2011 < CTs with Actual Date of Dept. < June 1, 2011
• Time frame for calculating estimated sales CTs (ESTF)
  • June 2, 2011 < CTs with Actual Date of Dept. < Dec 31, 2011

Mappings:

• Client = E0
• Origin = Country from Airport of Departure
• Destination = Country from Airport of Arrival
• Act Sales = sum of all sales invoices for ERTF (in USD)

Report output:

• xls form
• each line corresponds to one (Client / Origin / Destination) Triple
• columns:
  • A Client
  • B Origin
  • C Destination
  • D Act Sales ()
  • 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)