Estimated GM: Proof Of Concept
From UG
(Difference between revisions)
(→SOW 0 Proof Of Concept) |
(→SOW 0 Proof Of Concept) |
||
Line 17: | Line 17: | ||
'''Parameters''': | '''Parameters''': | ||
- | * Time frame for calculating estimated rates ( | + | * Time frame for calculating estimated rates (RTF) |
** Jan 1, 2011 < CTs with Actual Date of Dept. < June 1, 2011 | ** Jan 1, 2011 < CTs with Actual Date of Dept. < June 1, 2011 | ||
- | * Time frame for calculating estimated sales CTs | + | * Time frame for calculating estimated sales CTs and error margin(ETF) |
** June 2, 2011 < CTs with Actual Date of Dept. < Dec 31, 2011 | ** June 2, 2011 < CTs with Actual Date of Dept. < Dec 31, 2011 | ||
Line 30: | Line 30: | ||
part 2 - defining est rate for triple | part 2 - defining est rate for triple | ||
- | * D] | + | * D] RTF Sales = sum of all sales invoices for RTF (in USD) - actual |
- | * E] | + | * E] RTF ttl ChW = total chargeable weight for all CTs during RTF |
- | * F] | + | * F] Rate = estimated rate = D divided by E |
part 3 - calculating error margin for triple | part 3 - calculating error margin for triple | ||
* G] Act Sales = actual sales (for ESTF) | * G] Act Sales = actual sales (for ESTF) | ||
* H] Est Sales = estimated sales (for ESTF) | * H] Est Sales = estimated sales (for ESTF) | ||
- | * I] Error, USD | + | * I] Error, USD = G minus H |
- | * J] Error, % = error margin in % related to Actual sales | + | * J] Error, % = error margin in % related to Actual sales = (I/G)*100% |
Line 45: | Line 45: | ||
* each line corresponds to one (Client / Origin / Destination) Triple | * each line corresponds to one (Client / Origin / Destination) Triple | ||
* columns: A, B, ..., J as defined above | * columns: A, B, ..., J as defined above | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- |
Revision as of 20:45, 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 (RTF)
- Jan 1, 2011 < CTs with Actual Date of Dept. < June 1, 2011
- Time frame for calculating estimated sales CTs and error margin(ETF)
- June 2, 2011 < CTs with Actual Date of Dept. < Dec 31, 2011
Fields and Mappings:
part 1 - defining triple
- A] Client = E0
- B] Origin = Country from Airport of Departure
- C] Destination = Country from Airport of Arrival
part 2 - defining est rate for triple
- D] RTF Sales = sum of all sales invoices for RTF (in USD) - actual
- E] RTF ttl ChW = total chargeable weight for all CTs during RTF
- F] Rate = estimated rate = D divided by E
part 3 - calculating error margin for triple
- G] Act Sales = actual sales (for ESTF)
- H] Est Sales = estimated sales (for ESTF)
- I] Error, USD = G minus H
- J] Error, % = error margin in % related to Actual sales = (I/G)*100%
Report output:
- xls form
- each line corresponds to one (Client / Origin / Destination) Triple
- columns: A, B, ..., J as defined above