Dashboard

General Description
Displays 3 years' actual costs related to both functions and production. Easily analyse/compare costs for current year verses last 2 years. (Year or/and Quarter) By year/ quarter : with a split by All or Productions Costs Details by 2 - Function Actual Destination

Indicators

Actual Origin - Only costs on Debit postings (or Receiver Debit Postings) are included.
Actual Destination - All costs which are debit/credit postings are included.

More details: Origin only includes the Primary costs, while Destination includes both Primary and Secondary costs (refer below table on Cost type, Cost Element & Cost Category).

Type	Cost Element Group 1	Cost Element Category
Primary	ZRCS-AC Actual Fixed Costs ZRCS-OTH Others ZRCS-VSE Variable Selling Exp	01 Primary Costs/Cost-reducing revenue 03 Accrual/deferral per surcharge 04 Accrual/deferral per debit=actual 11 Revenues 12 Sales deduction 22 External settlement
Primary	ZRCS-Sale	01 Primary Costs/Cost-reducing revenue 03 Accrual/deferral per surcharge 04 Accrual/deferral per debit=actual 11 Revenues 12 Sales deduction 21 Internal settlement 22 External settlement 42 Assessment 43 Internal activity allocation
Primary	ZRCS-ACAMO Actual Depreciation	01 Primary Costs/Cost-reducing revenue 03 Accrual/deferral per surcharge 04 Accrual/deferral per debit=actual 11 Revenues 12 Sales deduction 22 External settlement
Secondary	ZRCS-ACAMO Actual Depreciation	21 Internal settlement 31 Order/project results analysis 41 Overhead rates 42 Assessment 43 Internal activity allocation 50 Project-related incoming orders: sales revenue 51 Project-related incoming orders: other revenue 52 Project-related incoming orders: costs 61 Earned value
Secondary	ZRCS-AC Actual Fixed Costs ZRCS-OTH Others ZRCS-VSE Variable Selling Exp	21 Internal settlement 31 Order/project results analysis 41 Overhead rates 42 Assessment 43 Internal activity allocation 50 Project-related incoming orders: sales revenue 51 Project-related incoming orders: other revenue 52 Project-related incoming orders: costs 61 Earned value

Plan

The Plan value corresponds to the "Budget" entered on the cost centers in the ERP.

The Plan is available in 2 versions:

V0 - Version 0: This is the Standard Cost Estimate (Max capacity)
V1 - Version 1: This is a version that can be used freely in the ERP

Note: The V0 is currently filled only for production cost centers.

Sources	Fixed Costs GBU View
Core query	BW_QRY_MPR_FC003_0003
QV query	QVSBS_BW_QRY_MPR_FC003_0003
Refresh frequency	Everyday for the first 2 weeks of the month (for the previous month data)
Filters	BFC GBU (Responsible Cost Center), Responsible Plant (Resp Cost Center)

Specific Dimensions
1 - Organisation 2 - Function 3 - Sub Function Group 4 - Sub Function Fixed Costs Group 1 Fixed Costs Group 2

Scope

The scopes cover are:

Temporal Scope: The dashboard includes the current year and previous year data only.
System Scope: not all cost centers are included. There are some restrictions:-
- Only CBS/Functions & RCS GBUs Cost Centers are included - This is because currently the necessary master data (hierarchies) are not in place for GBUs cost centers in PF1, Acetow and CICC.
- Only GBUs and CBS/Functions cost centers are included (Others are excluded via the 1 - Organisation group).
  - ENTRP - Enterprise Fixed Costs follow up are included
  - ZCBS-CORPO - Corporate Functions are included
  - ZCBS-FUNCT - Function Services are included
  - ZCBS-PROJ - Services Projects (Out of guarantee) are included
  - ZCBS-ICO - ICO Intercompany are included
- Only Fixed Costs Cost Centers are included (Filtered via the 2 - Function group)
  - ECP - Variable Costs are excluded
  - EACAR - Other Operating Expenses are excluded
  - EPSRO - Post Operating Result are excluded
  - ECPVSE - Variable Sales Expenses are excluded
  - EDISC - Discontinued are excluded
  - ESERV - Services are excluded
- Cost Elements excluded from Fixed Costs group 4
  - ZRCS-WC30 Impots prop CA are excluded
  - ZRCS-WC31 Dt. entree etrang are excluded
  - ZRCS-W41 Sale Roylty paid are excluded
  - ZRCS-WC42 Sale Roylty revn are excluded

Target Users

Finance
Controlling
Industrial

Authorization & Rights

Page tree

Dashboard

Pierre Boyer

Process Manager RtR

Marie-Line Ardito

Displays 3 years' actual costs related to both functions and production. Easily analyse/compare costs for current year verses last 2 years. (Year or/and Quarter)

By year/ quarter : with a split by All or Productions Costs

Details by 2 - Function Actual Destination

Actual Origin - Only costs on Debit postings (or Receiver Debit Postings) are included.

Actual Destination - All costs which are debit/credit postings are included.

More details: Origin only includes the Primary costs, while Destination includes both Primary and Secondary costs (refer below table on Cost type, Cost Element & Cost Category).

Type

Cost Element Group 1

Cost Element Category

Primary

ZRCS-AC Actual Fixed CostsZRCS-OTH OthersZRCS-VSE Variable Selling Exp

01 Primary Costs/Cost-reducing revenue03 Accrual/deferral per surcharge04 Accrual/deferral per debit=actual11 Revenues12 Sales deduction22 External settlement

Primary

ZRCS-Sale

01 Primary Costs/Cost-reducing revenue03 Accrual/deferral per surcharge04 Accrual/deferral per debit=actual11 Revenues12 Sales deduction21 Internal settlement22 External settlement42 Assessment43 Internal activity allocation

Primary

ZRCS-ACAMO Actual Depreciation

01 Primary Costs/Cost-reducing revenue03 Accrual/deferral per surcharge04 Accrual/deferral per debit=actual11 Revenues12 Sales deduction22 External settlement

Secondary

ZRCS-ACAMO Actual Depreciation

21 Internal settlement31 Order/project results analysis41 Overhead rates42 Assessment43 Internal activity allocation50 Project-related incoming orders: sales revenue51 Project-related incoming orders: other revenue52 Project-related incoming orders: costs61 Earned value

Secondary

ZRCS-AC Actual Fixed CostsZRCS-OTH OthersZRCS-VSE Variable Selling Exp

21 Internal settlement31 Order/project results analysis41 Overhead rates42 Assessment43 Internal activity allocation50 Project-related incoming orders: sales revenue51 Project-related incoming orders: other revenue52 Project-related incoming orders: costs61 Earned value

Plan

The Plan value corresponds to the "Budget" entered on the cost centers in the ERP.

The Plan is available in 2 versions:

V0 - Version 0: This is the Standard Cost Estimate (Max capacity)

V1 - Version 1: This is a version that can be used freely in the ERP

Note: The V0 is currently filled only for production cost centers.

Core query

BW_QRY_MPR_FC003_0003

QV query

QVSBS_BW_QRY_MPR_FC003_0003

Refresh frequency

Everyday for the first 2 weeks of the month (for the previous month data)

Filters

BFC GBU (Responsible Cost Center), Responsible Plant (Resp Cost Center)

1 - Organisation

2 - Function

3 - Sub Function Group

4 - Sub Function

Fixed Costs Group 1

Fixed Costs Group 2

The scopes cover are:

Temporal Scope: The dashboard includes the current year and previous year data only.

System Scope: not all cost centers are included. There are some restrictions:-

Only CBS/Functions & RCS GBUs Cost Centers are included - This is because currently the necessary master data (hierarchies) are not in place for GBUs cost centers in PF1, Acetow and CICC.

Only GBUs and CBS/Functions cost centers are included (Others are excluded via the 1 - Organisation group).

ENTRP - Enterprise Fixed Costs follow up are included

ZCBS-CORPO - Corporate Functions are included

ZCBS-FUNCT - Function Services are included

ZCBS-PROJ - Services Projects (Out of guarantee) are included

ZCBS-ICO - ICO Intercompany are included

Only Fixed Costs Cost Centers are included (Filtered via the 2 - Function group)

ECP - Variable Costs are excluded

EACAR - Other Operating Expenses are excluded

EPSRO - Post Operating Result are excluded

ECPVSE - Variable Sales Expenses are excluded

EDISC - Discontinued are excluded

ESERV - Services are excluded

Cost Elements excluded from Fixed Costs group 4

ZRCS-WC30 Impots prop CA are excluded

ZRCS-WC31 Dt. entree etrang are excluded

ZRCS-W41 Sale Roylty paid are excluded

ZRCS-WC42 Sale Roylty revn are excluded

Finance

Controlling

Industrial

All the accesses must be validated by the

GBU Finance or Industrial Directors

Authorisations' rights per GBU, Zone, Plant

Access form

ZRCS-AC Actual Fixed Costs
ZRCS-OTH Others
ZRCS-VSE Variable Selling Exp

01 Primary Costs/Cost-reducing revenue
03 Accrual/deferral per surcharge
04 Accrual/deferral per debit=actual
11 Revenues
12 Sales deduction
22 External settlement

01 Primary Costs/Cost-reducing revenue
03 Accrual/deferral per surcharge
04 Accrual/deferral per debit=actual
11 Revenues
12 Sales deduction
21 Internal settlement
22 External settlement
42 Assessment
43 Internal activity allocation

01 Primary Costs/Cost-reducing revenue
03 Accrual/deferral per surcharge
04 Accrual/deferral per debit=actual
11 Revenues
12 Sales deduction
22 External settlement

21 Internal settlement
31 Order/project results analysis
41 Overhead rates
42 Assessment
43 Internal activity allocation
50 Project-related incoming orders: sales revenue
51 Project-related incoming orders: other revenue
52 Project-related incoming orders: costs
61 Earned value

ZRCS-AC Actual Fixed Costs
ZRCS-OTH Others
ZRCS-VSE Variable Selling Exp

21 Internal settlement
31 Order/project results analysis
41 Overhead rates
42 Assessment
43 Internal activity allocation
50 Project-related incoming orders: sales revenue
51 Project-related incoming orders: other revenue
52 Project-related incoming orders: costs
61 Earned value