• Sebastien Willemse (inherited from Charlotte Cornemillot)
  • Peter Van den Akker
 



General Description

This dashboard is a spinoff of SCREEN logistics & packaging dashboard that enables the user to dig down into more into operational data related to the logistics volumes and spend. The dashboard is a temporary solution until the global cross transport mode TMS is in place (with own reporting capabilities).
The dashboard is divided into 3 main KPI sections as per below:


Sheet Title 
Transport Contract Compliance (Overview)
Transport Contract Compliance (Details)
Opportunity Assessment

KPIs 

Costs compliance:
  • Transport costs 
    • Total transport costs (1.1)
    • On shipment costs docs (1.2)
    • On costs centers (1.3)
  • Transport costs repartition 
    • By GBU/Region/(sub)package (1.1.1)
    • By cost category (1.6)
Accrual accuracy 
    • In % (1.5.1)
    • By dimension & over time (2.2.1)
Costs analysis:
  • Costs distribution details (2.3)
Costs (in depth):
  • Total logistics costs (4.1)
  • Logistics costs COSTA cost centers (4.1.1)
  • Outbound transport SCREEN shipment docs (4.1.2)
  • Outbound transport SCREEN shipment docs + other costs incl. leases COSTA (4.1.3)
  • Gap posting vs completion over period (4.1.4)
Payload Analysis:
  • Inland & air transport (4.2.1)
  • Ocean transport in containers (4.2.2)
Unit Cost per Distance:
  • Cost per distance in EUR/TON  (4.3)
Supplier mapping:
  • Costs mekko - vendor & Taxonomy (4.4)
Airfreight KPIs
    • Level of service (4.7)
    • Customer paid info (4.8.1 & 4.8.2)
    • Policy trigger point (4.9)


General Dimensions
  • GBU
  • Costs description
  • Cost category 
  • Package 
  • Sub Package 
  • BFC Group of activities
  • Completion 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 month: the month the invoice is registered 
  • Completion month: the month of departure of the transport
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 month 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 (Logistics) organization
  • 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 dashboard using this form:
Access form