Process Owner

Excellence Center Demand Management & Purchasing

T&E Expert

Claire Boursier

D&PS Expert

Marie-Line Ardito

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

No restrictions on scope

Target Users

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

Authorization & Rights

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 %



 

 

 

 

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels