a.

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.

Image Removed

 To be investigated

ERROR € 

It is a technical destination type that we apply when as result of the algorithm, the difference between Origin and Destination is >150%. In that case we do not apply the algorithm, we apply a single rule Origin = Destination . This means that we do not know the real destination type (P&L, Capex, ...)

Non ERP €

It is the value that has been upload manually for the origin view of Non ERP entities  as i n the destination view, Destination = Origin. There is no assignment to destination type (PL, Capex or other destination).

We created this technical destination type (NERP) to have it under control.  Next step would be to  create a new manual upload method that provide also the destination information for NERP.

Image Added

b. Origin GBU

c

. Currency

Image RemovedImage Added

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

Image Removed

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.

Image Removed

 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 .

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.

g. Documentation

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

Image Removed

Link to the view Costs Detail (table)

Image Removed.

Image Modified

In this view, it is the YTD of the current year at destination (3302.74 MEUR63 BEUR) compared with the YTD of the previous year (2852.6 MEUR739 BEUR), and the % of the variation (+15-3.8%6%) 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

Image RemovedImage Added

View 2 -

PL IMPACT €

In this view, it is the YTD of the current year (330.74 MEURof P&L destination costs (2.07 BEUR) compared with the YTD of the previous year (2851.6 MEUR989 BEUR), and the % of the variation (+154.8%5%) for total P&L 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

Image RemovedImage Added

View 3 -

CAPEX €

You see here the YTD of the current year of the CAPEX destination costs (768196.02 KEUR27 MEUR) compared with the YTD of the previous year (2205.46 19 MEUR), and the % of the variation (-684.8%) for the Package Travel & Expense, included in the Macro Package Employee Svcs3%) for Capex costs.  The costs are capitalized via projects WBS.

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

Image RemovedImage Added

View 4 -

 REINVOICING €

You see here the YTD of the current year (169139.23 51 MEUR) compared with the YTD of the previous year (122186.58 57 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-25.2%) of the invoicing flows (net between In and out) of the perimeter selected to other companies (Interco or external).

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

Image RemovedImage Added

View 5 -

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

Image Removed

CAPITAL LEASE €

You see here the YTD of the current year (45.94 MEUR) compared with the YTD of the previous year (47.05 MEUR), and the % of the variation (-2.4%) for capital lease expenses (IFR16) in balance sheet

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

Image Added

You see here the YTD of the current year (54.73 MEUR) compared with the YTD of the previous year (44.71 MEUR), and the % of the variation (22.4%) for stocks. It is the cost that is allocated to the Variable Cost component of the finished good produced (before they are sold).

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

Image Added

You see here the YTD of the current year (84.81 MEUR) compared with the YTD of the previous year (68.09 MEUR), and the % of the variation (24.5%) for costs that are settle in Balance Sheet account (GL account)

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

Image Added

You have in this bridge the variation between the current period vs the previous period declined by delta of:

• macro packages 
• assignment type : Reinvoicing, Capex, Capital Lease, Stock, Balance sheet, Non ERP, Error

You can see it for one month, one quarter, YTD. It depends of the selection/ filter you do.

Image Added                         

You can see in the graph the cost repartition (blue bars) vs previous period (yellow strait).

You have different dimensions available in the axis of the graph.

In vertical axis, you can select different dimensions:

• Macro package
• Country of Company
• Plant
• Package
• BFC Activity 1
• 3-Sub Function Grouping
• Origin GBU
• Destination GBU
• Budget owner hierarchy (L1 to L5)
• Legal entity
• Site

In horizontal axis, you can select the destination type :

• Total costs
• PL Impact
• Capex
• Reinvoicing
• Capital Lease
• Stock
• Balance Sheet
• Non ERP
• Error

Image Added 

Image Added Image Added

You can see in the graph the evolution month after month (or quarter) of the current period (blue bars) vs previous period (yellow bars). Or if you prefer you can see the variation between the current and the previous periods.

In vertical axis, you can select the destination type :

• Total costs
• PL Impact
• Capex
• Reinvoicing
• Capital Lease
• Stock
• Balance Sheet
• Non ERP
• Error

In horizontal axis, you can select the evolution by month or by quarter.

                Image Added                 Image Added

Image Added

Image Added

View 11 - Table : Macro Package by destination type and BFC headings

You can see in this table different dimensions related to destintation for the current period.

In line, you can have the macro packages, the BFC Heading code or the BFC Heading Grouping. You can change the order.

In column, you have the destination type starting with the Total Costs and the details after : 

• PL Impact
• Capex
• Reinvoicing
• Capital Lease
• Stock
• Balance Sheet
• Non ERP
• Error

Image Added

In this table, you can see by Origin GBU, the destination GBU for the current period.

In column, you have the destination type starting with the Total Costs and the details after : 

• PL Impact
• Capex
• Reinvoicing
• Capital Lease
• Stock
• Balance Sheet
• Non ERP
• Error

Image Added

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

Image Removed

A. Costs of the Macro Package = People by months

B. FTE by month

Image Removed