Estimated GM: Proof Of Concept
From UG
(Difference between revisions)
(→SOW 0 Proof Of Concept) |
(→SOW 0 Proof Of Concept) |
||
| Line 17: | Line 17: | ||
* MOT = Air | * MOT = Air | ||
* Jan 1, 2011 < CTs with Actual Date of Dept. < Dec 31, 2011 | * 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 (in USD) | ||
Report output: | Report output: | ||
| Line 22: | Line 34: | ||
* each line corresponds to one (Client / Origin / Destination) Triple | * each line corresponds to one (Client / Origin / Destination) Triple | ||
* columns: | * columns: | ||
| - | ** A Client | + | ** A Client |
| - | ** B | + | ** B Origin |
| - | ** C | + | ** C Destination |
| - | ** D | + | ** D Act Sales () |
** E TTl Sales () | ** E TTl Sales () | ||
** Avg S/ChgW (average sales per kg: total sales in USD for CT or GRP divided by TTl ChgW) | ** Avg S/ChgW (average sales per kg: total sales in USD for CT or GRP divided by TTl ChgW) | ||
Revision as of 19:55, 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
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 (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)
