Sébastien Willemse
 



General Description



Sheet Title Transport Contract Compliance OverviewTransport Contract Compliance Details Opportunity Assessment

KPIs 

  • Transport costs 
  • Accrual accuracy
  • Costs distribution Details
  • Total costs
  • Completion Total Costs
  • Variation Completion costs
  • Vendor Costs
  • Payload Analysis 
  • Unit Cost per distance
  • Freight Payment Info 
  • Airfreight Service Level


General Dimensions
  • GBU
  • Costs description
  • Cost category 
  • Package 
  • Sub Package 
  • BFC Group of activities
  • Completion Year Month 
  • Delivery Line
  • Departure Point 
  • Departure Country 
  • Departure Zone
  • Destination Country
  • Material
  • Packaging Material
  • Ship to 
  • Shipment Number 
  • Shipping Type 
  • Vendor 
  • Plant 
  • Flow standard 



Period of Analysis
There are 2 timelines in Log analytics dashboard:
  • Posting date (main)
  • Shipment Completion
Scope: From YTD Y-1 to YTD Y in the dashboard 
Default selection: 
  • YTD Y-1 vs YTD Y (posting date)
  • Ability to filter on Completion date in “Opportunity assessment” page
Refresh frequency: 



Currencies
  • EUR 
  • Currency rate : CAR3 ( monthly average rate )
  • Each set of cost data is associated to a Month and a Year and has a currency, the rate is to be applied depending on the month and currency of the data, regardless of the time selection active in the dashboard (ie: the rates are applied in the script and costs are displayed “as is” in the dashboard)



  • GBU Supply Chain 
  • Procurement organisation
  • SBS PSL
  • SBS Data Log
  • Transformation Center for Diagnostics


All the accesses must be validated by the Process Owner. 
No access restrictions on the perimeter.
Please request access to the dasboard using this form:
Access form