Excellence Center Demand Management & Purchasing


Claire Boursier


Marie-Line Ardito


add screenshot of the dashboard with Numbers of final version in Qlik

No restrictions on scope


  • ExCom
  • Leadership team
  • Financial Directors
  • Purchasing Function
  • Controllers


All the accesses must be validated by:
Excellence Center / Purchasing
Click here for the Access form to get access to the T&E Dashboard.
Current authorizations are available on this file.



NbNameSourceCalculationComments
1
Total Spend
BW- Fixed Costs
2018 Spend = ∑Spend N-1
YTD 2019 Spend = ∑Spend Ytd N
No filter on time dimension
2
Total Spend YTD vs YTD N-1 RSB
Evolution = (∑Spend "Selection" N -∑Spend "Selection" N-1 RSB)/∑Spend "Selection" N-1 RSB
Clear indication on spend variation in EUR & in % vs previous year
3
Spend evolution (N vs N-1)
Monthly/Quarter Spend for N data
Monthly/Quarter RSB Spend for N-1 data
Dimension can be month or quarter
4
Spend per Region (%)
% of each region
Location of company not expense
5
Details and evolution per GBU and function
Trend = (∑Spend "Selection" N -∑Spend "Selection" N-1 RSB)/∑Spend "Selection" N-1 RSB
Moving average = (∑Spend last 3 months - Average Spend last 12 quarters)/Average Spend last 12 quarters in %