Versions Compared

Old Version 4

changes.mady.by.user Rachdi, Donia

Saved on

compared with

New Version Current

changes.mady.by.user Rachdi, Donia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
 

Image Added

Info
iconfalse
titleProcess OwnerBusiness Application Owners
Syensqo: Xiao Lyu, Mark Rushton
   Solvay: Christian Backaert
Names
 
Info
iconfalse
titleD&PS Expert
Marie-Line Ardito

General Description

n KPIs

covering the Value Chain

description
CashCostCustomer Experience
  • Spend by Valuation Class
  • Spend by domain
  • OEE & Utilization Rate

  

General Dimensions
  • GBU
  • Group of Activity
  • Activity (=BFC market)
  • Region (Zone)
  • Plant
Period of Analysis
The dashboard displays complete months of data, so Month M-1
Data Product Owner
Donia Rachdi 



General Description

In the context of the continuous improvement programs to better serve our customers and improve our performance, the End-To-End Value Chain dashboard brings a comprehensive view of the Value Chain through the most significant Key Performance Indicators, from materials sourcing to delivery and payment collection.
Monitoring all the GBUs into one single portal enhances collaboration and convergence with one performance language. Besides, direct links to the dedicated Domain Dashboards allow you to drill down and get more details. Use the Request Access Form link on the top right page if necessary.

Split into 4 categories: Source, Plan, Make, Deliver, check the trend of the cross-functional and multi-GBUs performance over 12 rolling months, until the last completed previous month (M-1).

This dashboard as a collection of main performance KPIs that are created through specific dashboards. So for enhanced analytics, you may need to request access to a specific dashboards (reference under each chart)
For a quick and highlevel overview, have a look at the Summary sheet to retrieve all your KPIs and their evolution, with the value of month M-1 compared to month M-2 by default.
Note: all KPIs don't have the same update availability. After the 1st of the month, the indicators with a mention below will be refreshed later. Please refer to the Refresh frequency frame.

In the My Report sheet, use the available Dimensions and Measures to create personalized insights.
Info
iconfalse
titleTarget Users
  • COMEX
  • GBUs Presidents and Management
  • GBUs Directors
  • Supply Chain Family
Info
iconfalse
titleAuthorization & Rights
Request access using Service One => "Corporate Dashboard Access Request Form" / Select the "Corporate" Category


Approvers:
Syensqo E2E VC Dashboard: Mark Rushton + Mathieu Pourque
Solvay E2E VC Dashboard: Sonali Desale + Christian Backaert




DimensionsPeriod of AnalysisRefresh frequencyCurrencies
  • GBU
  • Group of Activity (=BU)
  • Activity (=Market)
  • Region (=Zone)
  • Plant
2 new business concepts which completion is managed by each GBU
  • Product Line (E2E)
  • Archetype (set to « not-assigned » in SAP for all GBUs)
For Industrial KPIs only
  • Workcenter
    (= Production Asset)
12 rolling months (to M-1)

Exceptions:

  • Orderbook board displays the current month
except for the orderbook that displays the current months
  • + 60 days = Month M AND Month M+1 AND Month M+2
Note
titleNotes In Dashboard Tab
AnchorCapexCapexCapex (YTD)
It’s the amount paid during the current year. Amount is without tax.
AnchorCapspendCapspendCapspend (YTD)
It’s the actual costs for the current year. Amount is without tax.
AnchorCommitmentsCommitmentsCommitments (YTD)
It’s the current amount of the purchase requests and orders not yet received. Amount is without tax.
AnchorTotal Projects without BudgetTotal Projects without BudgetTotal Projects without Budget

Image Removed

This indicated the number of projects with movement during the selected period which are without Budget and percentage of these projects against total number of projects with movement during the selected period. By double clicking on this box in the dashboard, you will be able to see the list of projects that are without budget.
  • Working Capital that displays 12 rolling months + the current month
  • Production Capacity Utilization displays 13 rolling months + 3 next months
Daily refresh
Exceptions:
  • DPO: 1st weekend of the month
  • DOS: on the 13th of the month
  • DSO: definitive on the 7th of the month
  • Financial Working Capital: after 10 working days 
  • Forecast Accuracy: on the 7th of the month
  • Supplier Delivery On Time: 1st & 5th & 26th 
E2E VC Dashboard = EUR
Conversion rate : see each indicator details
SOURCEPLANMAKEDELIVER
  • Supplier Delivery On Time
  • DPO
  • Forecast Accuracy
  • Inventory DOS
  • Inventory SMOG
  • Working Capital (Supply Chain)
  • Financial Working Capital
  • Production Capacity Utilization
  • Production Plan Adherence
  • External Sales, Forecast and Budget
  • Orderbook (ext sales)
  • DSO (Receivables)
  • Complaints by Orderlines
  • OTIF Customer
  • OTIF Depature Plant
  • Direct Spend Trend and Repartition
  • Indirect Spend Trend and Repartition
Videos
1st release: Watch the introduction video of the release of April 2020
2nd release: Watch the presentation of the release of August 2020 here
AnchorTotal projects BudgetTotal projects BudgetTotal projects > Budget

Image Removed

This indicates the total number of projects with movement during the selected period exceed Budget and percentages of these projects against total number of projects with movement during the selected period. By double clicking on this box in the dashboard, you will be able to see the list of projects that are over budget.
AnchorTotal projects LateTotal projects LateTotal projects "Late"

Image Removed

This indicates the number of projects with movement during the period that exceed the initial planned completion date and the percentage of these projects against total number of projects. By double clicking on this box in the dashboard, you will be able to see the list of projects that are late.
AnchorTotal projects InactiveTotal projects InactiveTotal projects "Inactive"

Image Removed

This indicates the number of projects that are inactive for more than 6 months and percentage of these projects against total number of projects. By double clicking on this box in the dashboard, you will be able to see the list of projects that are inactive.
Currencies
  • EUR, USD, BRL, SGD, PLN, CNY, KRW, INR
  • Conversion rate : End of month
    For Budget, rate of the project creation date. If this date is empty, last know rate (M-1 Y)
    For Capital Spend and Capex, historical rate (eg. CAPEX of January 2015 ===> conversion rate end of January 2015)  
Info
iconfalse
titleTarget Users
  • COMEX
  • d
  • d
  • d
Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by the
Authorisations' rights per GBU, Zone, Plant
Access form   
Info
iconfalse
titleCAPEX Management
CAPEX 01 Procedure