Estimated GM: Proof Of Concept

From UG

Revision as of 20:48, 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

SOW 2