Costs Detail (Expert)

>> Back to the Co$ta project home page


Access the dashboard


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

↓

<iframe frameborder="0" style="width:100%;height:1128px;" src="https://viewer.diagrams.net/?tags=%7B%7D&highlight=0000ff&edit=_blank&layers=1&nav=1#G1p6dvCXQtYsTxQzlNks5bYAFXjdDXKKiy"></iframe>


a. Costs vs budget/Y-1


You can select your target and choose the Budget or the previous Year.

In 2021, Budget is only available for the F2G scope and only by GBU or CBS Function and Macro-Package.

From 2022 you can compare vs BEF (best estimate forecast) which will be the update of the budget



b. Currency


Select EUR or local currency



c. Scope


3 scopes are available in Costa:

  • ALL : it includes all indirect spend (all costs except raw materials and utilities) / all CAPEX/OPEX/Capital leases
  • Anaplan Scope : It is the Budget scope and it is a subset of Co$ta perimeter. We want to focus the budget on fixed costs that are managed on a recurring basis: we exclude variable costs and non recurring costs
  • F2G Scope : Full for Growth scope is a subset of Anaplan scope. We exclude Internal Labor, Commission on sales and Warehouse & Log Rental



d. Interco/Non Interco


  • Non Interco: costs invoiced by an entity belonging to the group Solvay are excluded.
  • Interco: costs invoiced by an entity belonging to the group Solvay.



e. % Conso Applied / 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 (white), all costs are displayed in the dashboard
  • (B) When the button OPEX is blue, only OPEX is displayed
  • (C) When the button Capital Leases is blue, only Capital Leases are displayed


All costs posted in a WBS element or a PM order (*) with the type IM - CAPEX (Invest.)

(*) The value IM is determined in BW and assigned to the Order, if the cost in the Order is fully or partially settled to a WBS element type IM - CAPEX (Invest.).



g. Select your scope


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)



h. € / K€ / M€


By default the values are in K€, but you can choose € or M€ if you prefer



i. Need Help?


If you click on the “Need Help” button, you will be directed to Service One, to the knowledge base article explaining  how to contact the support team for Co$ta .

Don't hesitate to use it, should you require assistance or should you wish to report an issue such as some inaccuracies in the data.



j. Documentation


From Qlik Sense dashboard, you can access directly to this wiki



View 1 - Costs details Expert


Detail costs available for the following fields:

  • Macro Package
  • Package
  • Sub Package
  • GBU/Function
  • Country of the company code
  • Plant
  • Site
  • Cost Center Code 
  • Budget L1
  • Budget L2
  • Budget L3
  • Budget L4
  • Budget L5


  • Plant is more a technical concept; typically in WP1 one address one plant. But in PF1 system in one address, you can have different plants for the same site, typically split by business or family of products. For instance in Tavaux site, you may have around 7 plants belonging to different businesses but only one site.
  • Remind that the "plant" is retrieved  from the Profit Center of the Cost Centers (or the PC of the CC responsible of the WBS and Orders) . The Profit Center Master Data has a field "Department" and the plant is retrieved from there.
  • 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)

The dimensions "Budget L1" through "Budget L5" contain the 5 levels of the Anaplan Budgeting Hierarchy, that reflects the organisation of the GBUs or functions to be used to enter and approve the budget.

Budget Levels 1 corresponds to an entity (GBU or function).
Budget Levels 5 are the points of entry for the budget data and are assigned to a Budget Owner. 
Budget Levels 2, 3 & 4 are used to create intermediate hierarchy levels in the hierarchy whenever needed to reflect the organisation. Reviewers can be assigned to these levels to validate the budget coming from the levels below.

Example:
Budget L1: GBU A - Reviewer is the GBU President
Budget L2: Industrial Direction - Reviewer is the Industrial Director of GBU A
Budget L3: Industrial Direction EMEA - Reviewer is the Industrial Director of the region EMEA for GBU A
Budget L4: Site X - Reviewer is the Site Director of site X
Budget L5: Production, HSE, Maintenance departments...  Budget Owners are the respective managers of these departments on site X

Measure definition, calculation and source: Co$ta - Measures




View 2 - Performance review


Performance review: 

  • Macro Package
  • Cluster 
  • GBU / Function

Dimension definition and sources: Co$ta - Definitions



I - Package definition Book

Link to the Package definition Book 



II - Initiatives


Link to the F2G Global Initiative Tracking dashboard