Dashboard objectives
Designed in 2019 to replace pVelocity desktop application, this dashboard provides cost information that are usually difficult to extract from Solvay IS systems : link between Raw Materials and customers or Business Units, detailed Bill of Materials with fully Integrated Costs, and Integrated Contribution Margin per 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.
Sales volumes / value and standard Finished Product recipes (Bill of Materials) are the core queries of this dashboard → by combining both, we are able to derive an extrapolation of Raw Materials consumption figures. Hence, Raw Materials figures shown here are not actual purchasing / consumption figures (other parameters to be taken into account such as production variances, storage time...)
...
Tab
...
Triangle
...
This tab allows users to perform a wide range of analysis by navigating within the Finished Products - Customers - Raw Materials triangle.
For instance, it is possible to select a Customer and quickly find out what are the main raw materials he is indirectly buying. Such analysis would be interesting for Purchasing teams to assess the impact on Raw Material purchases if such Customer would stop buying from Solvay.
Starting from the other side, it is possible to select a Raw Material and find out what are the Finished Products (and eventually Business Units and Customers) who are consuming it. Such analysis would be interesting for Strategy / Commercial teams to assess the impact on sales if such Raw Material was not available anymore.
...
This tab allows users to see the Finished Products Bill Of Materials with integrated costs and utilities / fixed costs details.
For Finished Products that contain Intermediate Products from other Solvay plants, this dashboard provides two improvements vs. SAP itself:
- all production levels are shown, whatever the structure of the Bill of Materials in SAP. Using the Special Procurement Keys (SPK) from SAP Material Master data, this dashboard is able to display the Intermediate Product origin up to 15 levels;
- all costs shown in this dashboard are Integrated Costs, meaning that transfer margin between plants are excluded and freight / duties costs between Solvay plants are included → Integrated Costs shown here are the same costs that are used by Solvay systems to calculate the Integrated Contribution / Gross Margins.
...
The below table contains the list of all Cost Explorer indicators and where they can be found in the dashboard.
Select a dashboard tab to filter on its indicators or search for a specific indicator by typing its name.
| 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> |
Use cases
The below slides show how Cost Explorer can concretely be used in your daily job.
Click on 
button below the slides to display in full screen size.
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 | ||||||
|---|---|---|---|---|---|---|
|
Find out which Finished Product(s) / Customer(s) consume which Raw Material(s) tbc
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Access Bill of Materials with Integrated Costs and detailed view of Utilities and Fixed Costs tbc
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Analyze Integrated Contribution Margin / machine hour tbc
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Navigating in a Qlik Sense dashboard
Access here the Qlik Sense navigation tips
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
Frequently Asked Questions
xxx
Need help?
Below is the list of Novecare key users by teams and regions
...
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