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

C. % 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

D. 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

E. 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.

F. 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

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

Compare costs by GBU/function Year Y (in blue) vs Year Y-1 (in yellow) with the same Exchange rate

Select the view by:

• Top 5
• All

Compare costs by MacroPackage Year Y (in blue) vs Year Y-1 (in yellow) with the same Exchange rate

Select the view by:

• Top 5
• All

Evolution of the costs month by month for Year Y (in blue) and Year Y-1 (in yellow) with the same exchange rate

Select the view :

• Costs : To see the 2 curves of both years Y and Y-1
• Variation : the delta between Y and Y-1

Give the repartition of Solvay costs by GBU, Function and SBS.

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