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.

N.B. Not available in 2021 but next year you will be able to compare vs BEF (best estimate forecast) which will be the update of the budget

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

You can find here further info

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

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

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

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

i. Documentation

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

Link to the view Costs Detail (table)

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)

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. 

• 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 country 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 country 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. 

A. Costs of the Macro Package = People by months

B. FTE by month