Heatmap

>> 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:1000px;" src="https://viewer.diagrams.net/?tags=%7B%7D&highlight=0000ff&edit=_blank&layers=1&nav=1#G1LMu8hqZXXHnsO-9eSsWs9F_l-Wh7rYSt"></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. 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



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



h. Documentation


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



View 1 - Spend Variation YTD 2021 vs 2020 RSB in M€


Spend variation in absolute value between Year Y and Year Y-1 RSB (converted with same exchange rate) available by Macro Package and Package in line, and by GBU in column

It should be looking at with ZBB filter = "Yes"

Possibilty to look at the values YTD (year-to-date), QTD (quarter-to-date) or for the month (the current one)




View 2 - Spend Variation YTD 2021 vs 2020 RSB in %


Spend variation in % between Year Y and Year Y-1 RSB (converted with same exchange rate) available by Macro Package and Package in line, and by GBU in column

It should be looking at with ZBB filter = "Yes"

Possibilty to look at the values YTD (year-to-date), QTD (quarter-to-date) or for the month (the current one)



View 3 - Speed of Spend Reduction by Macro Package of Q1 2021


Delta in MEUR = the savings of the current quarter by Macro Package

Q1 2021 vs Q1 2020 RSB = comparison with the savings done in the same quarter of the previous year RSB 

Q4 2020 vs Q4 2019 RSB = comparison of the previous quarter with the savings done in the same previous quarter of the previous year RSB 

Acceleration vs Q4 : 

  • If %(Current Quarter vs Same Quarter Y-1 RSB) > %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ
  • If %(Current Quarter vs Same Quarter Y-1 RSB) < %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ
  • If %(Current Quarter vs Same Quarter Y-1 RSB) = %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ- Tolerance (-2%; 2%)




View 4 - Speed of Spend Reduction by Package of Q1 2021


Delta in MEUR = the savings of the current quarter by Package

Q1 2021 vs Q1 2020 RSB = comparison with the savings done in the same quarter of the previous year RSB 

Q4 2020 vs Q4 2019 RSB = comparison of the previous quarter with the savings done in the same previous quarter of the previous year RSB 

Acceleration vs Q4 : 

  • If %(Current Quarter vs Same Quarter Y-1 RSB) > %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ
  • If %(Current Quarter vs Same Quarter Y-1 RSB) < %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ
  • If %(Current Quarter vs Same Quarter Y-1 RSB) = %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ- Tolerance (-2%; 2%)