Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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

What's in it for you

Triangle

to be completed
Bill of Materialsto be completed
Margin per Hourto be completed


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



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

Find out what are the main Raw Material(s) consumed by a given Finished Product range  tbc

Find out what are the main Raw Materials for a given Business Unit tbc

Access Bill of Materials with detailed view of Activities (Utilities and Fixed Costs) tbc

Analyze Integrated Contribution Margin / machine hour  tbc




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

Source NameContent used in the dashboard / Filters / Period

SAP BW

QVSBS_BW_QRY_MVCOPA01_0004

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

QVSBS_QRY_MVCOPA06_0001

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

QVNVSC_BW_QRY_MPR_IC001_0065

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

BW_QRY_MV_SPD01_0002

Purchasing

  • Raw materials family / category

  • Current year + 3 full years

SAP BW

BW_QRY_DAFICE01_0001

Exchange rates

  • CAR3 exchange rate type
  • Current year + 3 full years

The best way to get IT support is to use the new Service One Platform.