Pierre Boyer
Process Manager RtR
Marie-Line Ardito

General Description

Gives a global view of Actual Destionation Fixed Costs using the Cost Element hierarchy or the Cost Center hierarchy
  • Actual Destination Costs Evolution Current year vs Previous year (same period) with the detailed delta of the level 2 of the Cost Element hierarchy (Fixed costs group 2) or the Cost Center hierarchy (2 Function)
  • Total Actual Destination Costs value or % vs the sum of total Costs by GBU or Function, Zone, Legal Entity, Plant, Fixed Cost Group 2 or 2 Function on the selected period
  • Trend of Actual Destination Costs value by Month or Quarter depending on the selection. A comparison with the budget is available by clicking on either "Function Costs" or "Production Costs"
Calculation 
Actual Destination
All costs which are debit/credit postings. It includes both Primary and Secondary costs (refer below table on Cost type, Cost Element & Cost Category).
Type
Cost Element Group 1
Cost Element Group 1
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
 
  
Budget - GBU
It corresponds to Plan Value V0 or V1 (budget entered on the cost centers in the ERP)
  • 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.
Budget - Function
It corresponds to the budget given by the Corporate function - manual files

Sources

Actual Destination Fixed Costs

Budget - GBUsBudget - Functions
Core query
BW_QRY_MPR_FC003_0003
BW_QRY_MPR_FC003_0003
 
QV query
QVSBS_BW_QRY_MPR_FC003_0003
QVSBS_BW_QRY_MPR_FC003_0003
Manual file given by the Corporate Funtions
Refresh frequency
Daily (from the 1st to the 10th of the month) - Last 3 months update
Daily (from the 1st to the 10th of the month) - Last 3 months update
on demand
Filters
  • 1 Organisation = ZCBS- FUNCT, ZCBS-CORPO, ZCBS-ICO, ZCBS-PROJ
  • Fixed Cost Group 1 = ZRCS-SALE, ZRCS,VSE, ZRCS-OTH, ZRCS-AC
  • 2 Function <> ECP, EACR, EPSR, ECPVSE, EDISC, ESERV
Split Plan into : Plan V0 and Plan V1
 

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
  • Finance
  • Controlling
  • Industrial
All the accesses must be validated by the
GBU Finance or Industrial Directors
Authorisations' rights per GBU or Funtion, Zone, Plant
Access form