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
- 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