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

Compare with Current View Page History

« Previous Version 42 Next »



Excom (Origin Cost View)

>> Back to the  Co$ta project  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.



D. BSA Group


BSA means Business Support Activities. In July 2020, there are 5 BSA:

  • Finance
  • Human Resources
  • Purchasing
  • R&I
  • Industrial

The documentation about the determination of the each BSA is available here: BSA Report



E. % Conso Applied / All entities at 100%


When you select %_Conso_Applied to display the results of operations of the concerned legal entities after applying the consolidation (integration) rate relevant for these entities.

So for instance, for a JV integrated at 50%, the costs are 50% of the original company's figures



F. OPEX/CAPEX/Leases


By default only OPEX are displayed in the dashboard but it is possible to display all costs including CAPEX (Capital Expenditure) & Capital Leases

  • (A) When all buttons CAPEX-Invest/Capital Leases/OPEX have the same color (green or white), all costs are displayed in the dashboard
  • (B) When the button OPEX is green, only OPEX is displayed
  • (C) When the button Capital Leases is green, only Capital Leases are displayed


Definition of CAPEX-Invest

All costs posted in a WBS element or a PM order with the following type:

  • WBS Element type: IM - CAPEX (Invest.)
  • CO Order - Type: Z**I in PF1 & ZPM6 in WP1




G. Interco/Non Interco


By default all costs are reported in the dashboard but it is possible to exclude costs invoiced by another company Solvay:

  • (A) When both buttons Interco/Non Interco have the same color (green or white), all costs are displayed in the dashboard
  • (B) When the button Interco is green, only costs with a vendor Solvay are displayed
  • (C) When the button Non Interco is green, costs invoiced by another company Solvay are excluded


Definition of Interco

Interco: costs invoiced by an entity belonging to the group Solvay.

It is based on the attribute "Intercompany Flag" of the master data "Vendor".

When "Intercompany flag" = Yes, then the vendor is considered as Interco.



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 - FTE & Headcounts


A FTE = Hours worked by one person on a full-time basis (source HR)



View 3 - Costs (€) by GBU/Function


Total costs by GBU and CBS (Function)

A. Select costs of the year Y (Costs 2020) of compare the year Y with the year Y-1 (YoY RSB)



View 4 - Bridge


  • Costs Y-1 (A) = Exchange rate “CAR3” Y-1 (monthly average rate) is applied to corresponding months data Y-1.
  • Costs Y-1 RSB (B) = Exchange rate “CAR3” Y (monthly average rate) is applied to corresponding months data Y-1.
  • Costs 2020 (C) = Exchange rate “CAR3” Y (monthly average rate) is applied to corresponding months data Y.
  • 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 5 - 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 6 - By Period


A. Total costs by month or cumulated

B. Select costs by month or by quarter

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



View 7 - People Costs & FTE Evolution

A. Costs of the Macro Package = People by months

B. FTE by month



View 8 - Costs Details


A. Create a table to detail costs mainly by

  • GBU/Function
  • Macro Package / Package / Sub package
  • Country of the company code
  • Plant
  • Site

Site

The Site is an attribute of the Plant C_PLANT and is loaded in WBP directly by PSL Data team using a Webdynpro created for that purpose - Plant; the texts of the Plant Site (P) are loaded via another Webdynpro - Site(T)

B. Detailed as in view 3 - Bridge



  • No labels