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

Compare with Current View Page History

« Previous Version 29 Next »



Package Owner (Origin Cost View)

>> Back to the  Co$ta project  home page 


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


svg-out: Sorry, the attachment was not found at the specified page!





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.




b. Period selected

This line will let you know which period is used for the variation, what you are looking at in this view.




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

You can find here further info




d. 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 (white), all costs are displayed in the dashboard
  • (B) When the button Interco is blue, only costs with a vendor Solvay are displayed
  • (C) When the button Non Interco is blue, 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.




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


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. Need Help?


If you click on the “Need Help” button, you will be directed to freshdesk platform to open a ticket. 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.




h. Documentation


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




View 1 - COSTS €


In this view, it is the YTD of the current year (330.74 MEUR) compared with the YTD of the previous year (285.6 MEUR), and the % of the variation (+15.8%) for total costs

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 - PEOPLE €


In this view, it is the YTD of the current year (330.74 MEUR) compared with the YTD of the previous year (285.6 MEUR), and the % of the variation (+15.8%) for total costs

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 3 - T&E €


You see here the YTD of the current year (768.02 KEUR) compared with the YTD of the previous year (2.46 MEUR), and the % of the variation (-68.8%) for the Package Travel & Expense, included in the Macro Package Employee Svcs

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 4 - OTHER €


You see here the YTD of the current year (169.23 MEUR) compared with the YTD of the previous year (122.58 MEUR), and the % of the variation (38.1%) for the other costs (different from People costs or T&E). It is calculated by difference between Total costs and People + T&E.

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 5 - FTE


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




View 6 - Costs Repartition (€)


A. Select a view by 

  • Macro Package
  • Package
  • Sub Package
  • etc...

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




View 7 - Top 10 Vendor Group


To see how much represents the top 10 Vendor Group (17.38 MEUR) on the total costs spend (COSTS € = 330.74 MEUR)






View 8 - Top 10 Vendors


To see how much represents the top 10 Vendors (13.13 MEUR) on the total costs spend (COSTS € = 330.74 MEUR)




View 9 - Top 10 Vendor Groups and Vendors (€)


Display Top 10 Vendor Group or Vendors

Compare costs of the year Y (in blue) with the Y-1 (in yellow)





I - Costs details





II - Labor & FTE


Link to the Budget Owner (origin cost view) where you will see the graph. But only the people who has access to people Macro Package will see it.




III - Financial Bridge


Link to the Budget Owner (origin cost view) where you will see the bridge






Package Owner (Origin Cost View)

>> Back to the  Co$ta project  home page 


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


svg-out: Sorry, the attachment was not found at the specified page!





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.




b. Period selected

This line will let you know which period is used for the variation, what you are looking at in this view.




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

You can find here further info




d. 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 (white), all costs are displayed in the dashboard
  • (B) When the button Non Interco is blue, costs invoiced by another company Solvay are excluded
  • (C) When the button Interco is blue, only costs with a vendor Solvay are displayed


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.




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


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. Need Help?


If you click on the “Need Help” button, you will be directed to freshdesk platform to open a ticket. 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.




h. Documentation


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




View 1 - COSTS €


In this view, it is the YTD of the current year (330.74 MEUR) compared with the YTD of the previous year (285.6 MEUR), and the % of the variation (+15.8%) for total costs

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 - PEOPLE €


In this view, it is the YTD of the current year (330.74 MEUR) compared with the YTD of the previous year (285.6 MEUR), and the % of the variation (+15.8%) for total costs

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 3 - T&E €


You see here the YTD of the current year (768.02 KEUR) compared with the YTD of the previous year (2.46 MEUR), and the % of the variation (-68.8%) for the Package Travel & Expense, included in the Macro Package Employee Svcs

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 4 - OTHER €


You see here the YTD of the current year (169.23 MEUR) compared with the YTD of the previous year (122.58 MEUR), and the % of the variation (38.1%) for the other costs (different from People costs or T&E). It is calculated by difference between Total costs and People + T&E.

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 5 - FTE


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




View 6 - Costs Repartition (€)


A. Select a view by 

  • Macro Package
  • Package
  • Sub Package
  • etc...

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




View 7 - Top 10 Vendor Group


To see how much represents the top 10 Vendor Group (17.38 MEUR) on the total costs spend (COSTS € = 330.74 MEUR)






View 8 - Top 10 Vendors


To see how much represents the top 10 Vendors (13.13 MEUR) on the total costs spend (COSTS € = 330.74 MEUR)




View 9 - Top 10 Vendor Groups and Vendors (€)


Display Top 10 Vendor Group or Vendors

Compare costs of the year Y (in blue) with the Y-1 (in yellow)





I - Costs details





II - Labor & FTE


Link to the Budget Owner (origin cost view) where you will see the graph. But only the people who has access to people Macro Package will see it.




III - Financial Bridge


Link to the Budget Owner (origin cost view) where you will see the bridge




  • No labels