| HideElements | ||||||
|---|---|---|---|---|---|---|
|
Click on the image to see a detailed description of each view
↓
| SVG Out | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
The body area can be used to replace links in the SVG and to add tool tips to them. Please read the SVG Out documentation for details. |
| Hide If | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
A. Packages
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)
| HTML |
|---|
<iframe frameborder="0" style="width:100%;height:600px;" src="https://viewer.diagrams.net/?tags=%7B%7D&highlight=0000ff&edit=_blank&layers=1&nav=1#G1yxxh1CTKzQ-SH8627YNyopxIw3ALY5R-"></iframe> |
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
a. Costs vs budget/Y-1
You can select your target and choose the Budget or the previous Year.
b. Currency
Select EUR or local 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
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
| Info | ||
|---|---|---|
| ||
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 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
In this view, it is the YTD of the current year (330.74 MEUR)
View 1. Total Costs
In this view, the YTD of the current year (=1,51 G) is compared with the YTD of the previous year (1,65G). 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 ↓ arrow ↓ costs are decreasing
- When the number is red preceded by an up arrow ↑ costs arrow ↑ costs are increasing
- Costs 2019 (A) = Costs Y-1 converted in Euro using the Year-to-date Monthly Average Rate (Rate C) of december Y-1
- Costs 2019 RSB (B) = Costs Y-1 converted in Euro using the Year-to-date Monthly Average Rate (Rate C) of the current month
- Costs 2020 (C) = Costs Y converted in Euro using the Year-to-date Monthly Average Rate (Rate C) of the current month
- FX (1) = (B) - (A) = Exchange rate impact
- Inflation Labour (2) = The inflation is calculated country by contry 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 contry 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.
Costs industrial take to account costs of the macro packages Industrial maintenance, Industrial operations, Environmental and Engineering.
In this view, it is the YTD of the current year (739.91 MEUR) compared with the YTD of the previous year (652.45 MEUR), and the % of the variation (+13.4%) for costs industrial.
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 - COSTS NON-INDUSTRIAL €
Costs non-industrial take to account costs of the macro packages: People, Communication, Consulting Services, Facility, Financial Services, Human Ressources Services, IT and Telecom, Legal Services, Mobility and Meetings, Non Purchasing, R&I Services and Goods.
In this view, it is the YTD of the current year (573.37 MEUR) compared with the YTD of the previous year (537.46 MEUR), and the % of the variation (+6.7%) for costs non-industrial.
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
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 4. By Period
A. Total costs by month or cumulated
B. Compare costs by month Year Y vs Year Y-1 with the same exchange rate.
View 5. Costs Details (€)
A. Create a table to detail costs mainly by
- GBU/Function
- Function
- Country
- Macro Package / Package / Sub package
B. Detailed as in view 2
To see how much represents the top 10 Vendor Group (17.38 MEUR) on the total costs spend (COSTS € = 330.74 MEUR)
View 6 - Top 10 Vendors
To see how much represents the top 10 Vendors (13.13 MEUR) on the total costs spend (COSTS € = 330.74 MEUR)
Display Top 10 Vendor Group or Vendors
Compare costs of the year Y (in blue) with the Y-1 (in yellow)
I - Initiatives
Link to the F2G Global Initiative Tracking dashboard
II - Package definition Book
Link to the Package definition Book
Link to the view Costs Detail (table)
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.
Link to the Budget Owner (origin cost view) where you will see the bridge
View 6. Top 10 Vendors
Display Top 10 Vendors
View 7. Vendors
A. Search a vendor in the listbox
B. Display costs by vendors for 2020 & 2019
