Dashboard objectives
Cost Explorer is a dashboard that aims at giving a simple access to cost information that are usually difficult to extract from Solvay IS systems:
- Navigation within the Raw Materials - Finished Products - Customers triangle
- Detailed finished products Bill Of Materials with all levels and utilities / fixed costs details
- Aggregation of sales and production data to calculate Integrated Contribution Margin / machine hour.
Dashboard structure and indicators
Cost Explorer pulls data from multiple sources (see “Data sources” section at the end of the page for more details) and combines them into 3 tabs.
...
Tab
...
Triangle
...
The below table contains the list of all Cost Explorer indicators and where they can be found (filters, core of the dashboard...) in the dashboard.
Search for a specific indicator by typing its name or select a dashboard tab to filter on its indicators to be completed
| HTML |
|---|
<!-- Place this tag where you want the Awesome Table Widget to render -->
<div data-type="AwesomeTableView" data-viewID="-LyDP8zGKkP09d0lBBaY"></div>
<!-- Place this within the <head> tag or just before the end of your <body> tag. -->
<script src="https://awesome-table.com/AwesomeTableInclude.js"></script> |
Navigating in a Qlik Sense dashboard
Access here the Qlik Sense navigation tips
Use cases
The below slides give you a quick idea of how Cost Explorer can be used in your daily job
Click on 
button below the slides to display in full screen size
Find out which Finished Product(s) / Customer(s) consume which Raw Material(s) tbc
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Find out what are the main Raw Material(s) consumed by a given Finished Product range tbc
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Find out what are the main Raw Materials for a given Business Unit tbc
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Access Bill of Materials with detailed view of Activities (Utilities and Fixed Costs) tbc
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Analyze Integrated Contribution Margin / machine hour tbc
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Access
This dashboard is accessible via the Qlik Sense portal. This requires you to be connected to Solvay network (in-situ or via VPN).
Access can only be restricted by GBU. There are no other restrictions (Region or Market, for instance) that can be applied.
As of now, the only GBU using this dashboard is Novecare, for employees belonging to the following teams:
- Purchasing
- Strategy & Transformation
- S&OP
- Technology development / Process improvement
- Product Stewardship
Request a Cost Explorer access for new users
Data sources
Cost Explorer sources are updated on the 9th of each month.
...
Source Type
...
SAP BW
...
Profit & Loss (P&L)
...
External sales and integrated margin by customer
WP1 (Rhodia legacy) + PF1 (Solvay legacy) systems
Current year + 3 full years
...
SAP BW
...
Integrated Costs
...
Integrated manufacturing costs : raw materials + packaging + freight / duties of intermediates transferred between Solvay plants + fixed (machine / man / amortization) costs
Current year + 3 full years
...
SAP BW
...
Production volumes
...
Value streams and assets of finished products
Current year + 3 full years
...
SAP BW
...
QV_BW_QRY_CPCSPR02_0001
Cost simulation
...
Finished products cost forecasts calculated based on raw materials cost forecasts provided by GBU purchasing teams
Current year + 3 full years
...
SAP BW
...
Purchasing
...
Raw materials family / category
Current year + 3 full years
...
Exchange rates
...
Documentation for the Novecare Cost Explorer dashboard can be found under the following Wiki link