You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 21 Next »


Excom Cost

>> Back to the Dashboard home page

 


Click on the image to see a detailed description of each view

↓





A. GBU/Function/SBS

The allocation of costs to a GBU, a function or SBS is based on the ZCBS hierarchy. 

Each cost center is assigned to a group of the hierarchy that is itself assigned to the group: GBU, Function or SBS using the mapping maintained in the file Mapping (sheet " function grouping" - column C)





B. Function


The allocation of costs to a GBU, a function or SBS is based on the ZCBS hierarchy. 

Each cost center is assigned to a group of the hierarchy that is itself assigned to a function using the mapping maintained in the file Mapping (sheet " function grouping" - column D)



C. GBU


The allocation of costs to a GBU, a function or SBS is based on the cost center master data (Business Area for PF1, Profit center for WP1) 

Some GBUs are excluded from the dashboard using the file Mapping (sheet " GBU CBS_Cluster") when the GBU is "out of scope" in column C.



View 1 - Total costs


In this view, the YTD of the current year (=1,51 G) is compared with the YTD of the previous year (1,65G). 

The currency is Euro

  • When the number is green preceded by a down arrow  ↓ costs are decreasing
  • When the number is red preceded by an up arrow  ↑  costs are increasing



View 2 - Bridge


  • Costs 2019 (A) = Costs Y-1 converted in Euro using the Year-to-date Monthly Average Rate  (Rate C) of december Y-1
  • Costs 2019 RSB (B) = Costs Y-1 converted in Euro using the Year-to-date Monthly Average Rate  (Rate C) of the current month
  • Costs 2020 (C) = Costs Y converted in Euro using the Year-to-date Monthly Average Rate  (Rate C) of the current month
  • FX (1) = (B) - (A) = Exchange rate impact
  • Inflation Labour (2) = The inflation is calculated country by contry using inflations rates filled in the file Mapping  (sheet "INFLATION LABOUR (ZRCS-10)"). It is calculated for all cost elements included in the group ZRCS-10 of the Cost element Group ZRCS-FC. 
  • Inflation Other (3) = The inflation is calculated country by contry using inflations rates filled in the file Mapping (sheet "INFLATION OTHER "). It is calculated for all cost elements excluding those in the group ZRCS-10 of the Cost element Group ZRCS-FC. 
  • Δ (4) = (C) - (A) - (1) - (2) - (3) = variance that is not explained by the exchange rate or the inflation. 



View 3 - Package Costs


A. Select a view by 

  • Macro Package
  • Package
  • Sub Package

B. Compare costs by Macro Package / Package or Subpackage. Year Y vs Year Y-1 with the same exchange rate. 




View 4 - By Period


A. Total costs by month or cumulated

B. Compare costs by month Year Y vs Year Y-1 with the same exchange rate. 



View 5 - Costs by GBU/Function


Total costs by GBU and CBS (Function)



View 6 - Costs Details


A. Create a table to detail costs mainly by

  • GBU/Function
  • Function
  • Country 
  • Macro Package / Package / Sub package

B. Detailed as in view 2



  • No labels