Estimated GM: Proof Of Concept
From UG
(Difference between revisions)
(→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 | + | === 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)