Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Info
iconfalse
titleProcess Owner
Pierre Boyer
Process Manager RtR
Info
iconfalse
titleD&PS Expert
Marie-Line Ardito

General Description

The Fixed Costs dashboard is dedicated to the "CBS/Functions" and the "GBUs" fixed costs follow up. It supports Managers in charge of piloting global performance on their activities and the Site, GBU, Regional Finance Controllers and the Costing Managers (support) in charge of operational reporting for themself or their team.
The Indicators measurement is taken from 2 areas :
    • Actual Origin
    • Actual Destination
Results can be shown using the Cost Center hierarchy or/and the Cost Element hierarchy
Info
iconfalse
titleTarget Users
  • Finance
  • Costing
  • Industrial
Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by the
GBU Finance or Industrial Directors
Authorisations' rights per GBU or Function, Zone, Plant
Access form   
TabsDashboardFixed CostsComparative AnalysisMy Page
4 By for GBU (By By )
  • GBU/CBS
  • Zone
  • Legal Entity
  • 2 - Function
  • Fixed Costs 2
  • Plant
Total Cost
  • Details by 2 - Functions Accruals Destination
  • Details by Fixed Costs Group 2 Accruals Destination
  • Details by Cost Centers Actual Origin
    • Page for Comparing 2 groups of data
    • free table
    General Dimensions
    • Zone (of the Legal Entity)
    • Country (of the Legal Entity)
    • Legal Entities (Legal entity/company code where the amounts are posted)
    • GBU/BU
      • Entity
      • GBU
      • BU
        The GBU and BU dimensions are defined based on the hierarchy  (KCH6N) of the profit center attached to the responsible cost center.
        Image Modified
        Image Modified
    • Plant (
    Data from RCS
    • Responsible plant):
      For the production related costs, this corresponds to the plant (physical site) where the cost was posted.
      Eg: 7822 - Belle Etolie
      For the non-production related costs (SG&A, Admin...) the plant corresponds to the GBU which supports the cost. Each GBU will have its own code.
      Eg: RE00 for Rare Earth, CS00 for Novecare
      The plant is determined by the "Department" field of the Profit Center (KE53) linked to the Cost Center.
      Eg:  In KS03, check the profit center of the cost center (as shown below image)
      Image Modified

      Then in KE53, check the "Department" field (shown as below)
      Image Modified
    For other sources (Acetow/PF1/CICC)  - This field is empty and unused.

    • Person Responsible refers to the Person who is responsible for the cost center.
    • Function Costs only available with a CBS Function authorization
    • Production Costs only available with a GBU authorization
    • All Costs (combination of Function, Production and non Production Costs)
    • Anchor
      Cost Center hierarchy
      Cost Center hierarchy
      Cost Center hierarchy
      • 1 - Organisation
      • 2 - Function
      • 3 - Sub-Function Group
      • 4 - Sub-Function Code Label
    The cost center itself can be displayed via the "Code Label"
    The "1 - Organisation" to "4 - Sub-Function" dimensions are grouping of cost centers derived from "ZCBS" Cost Center Hierarchy:

     Image Modified

    • Anchor
      Cost Element hierarchy
      Cost Element hierarchy
      Cost Element hierarchy
      • Fixed Cost Grp 1
      • Fixed Cost Grp 2
      • Fixed Cost Grp 3
      • Fixed Cost Grp 4
    The "Fixed Cost Grp 1" to "Fixed Cost Grp 4" dimensions are groupings of cost elements derived from the "ZRCS-FC" Cost Element hierarchy:

    Image Modified

    Period of Analysis
    • Year - 2
    • Year - 1
    • Current Year
    • Quarter
    • Month
    Year, Quarter, Month Year and Month are based on the Fiscal
    Period.
    AnchorCost EvolutionCost EvolutionCost Evolution By 2 Function/Fixed Cost 2 for GBU
    Waterflow chart shows the costs for past and current year with differences for each 2 Function (Cost Centers Hierarchy) or Fixed Cost Group 2 (Cost Elements Hierarchy) and with Foreign Exchange Rate Effect.
    The detailed bars can be between "2 - Function" and "Fixed Cost 2" groups by using the check box (below image).

    Image Removed

    • Actual Y-1 bar: The Actual Destination cost for the previous year.
    • 2 - Function/Fixed Cost 2 bar: This is the delta for each Function or Cost group 2 between the previous year and the current year actual destination amounts.
    • FX effect: Foreign Exchange effect. Difference in Actual Y converted using the Y-1 rate and Actual Y using the Y rate.
    • Actual Y: The Actual Destination cost for the current year.
    Note on the currency conversion: The Actual Y-1, as well as the function/fixed cost 2 bars, are converted using the rate of the last period of previous year (if all periods are selected then it's the end of December rate). The Actual Y value is converted using the last period of current year rate (if all periods selected then it's the previous month's rate).
    Example: if the data selected was January to March and current year is 2014 then, Actual Y-1 bar will use the rate of March 2013 and the Actual Y is converted using the March 2014 rate.
    Note: If you are comparing only Year To Date, make sure to select the correct months on the right "
    Period
    " menu
    .
    There is a All/Production Cost Flag which enable to show either all costs (productions, SG&A etc...) or just production. This flag is defined by the plant: all actual plants costs  (Eg: 7822) are considered production. All GBU/Function which are not (Eg: RE00, CS00...). By choosing the costs that you interested in, simply click on either "All" or "Production Costs" from the top page of the dashboard (refer below image). If you wish to see example of the page, click "Production Cost" on top.
    Image Removed AnchorTotal CostsTotal CostsTotal CostsCalculation
    By Value
    Total costs is the sum of the values by Actual Destination taken from both Cost Center hierarchy and Cost Element hierarchy.  
    By Percentage
     
    This chart only shows current year's result.
    Currencies
    • ARS, BGN, BRL, CAD, CHF, CNY, EGP, EUR, GBP, HKD, INR, JPY, KRW, MXN, NZD, PLN, RUB, SAR, SGD, THB, TRY, USD, VEF
    All amounts are copied from the ERP to the dashboard in local currency and then a currency conversion is then applied to allow conversion to any currency.
    EXCHANGE RATE : CAR3 (Cumulated Monthly Mean)
    By default the dashboard shows all amounts in EUR but it can be changed by selecting a different currency on the right menu according to user's preference.
    • The conversion from local currency to any other currencies is done as follow:
      Rate used is the Accumulated Average Monthly rate ("C" rate from PI1 SAP)
      The rate of the LAST month of the selected interval is applied to the whole period.
      • Eg: If you select 02.2014 to 06.2014, the complete value will be converted using the rate of 06.2014.
    Important clarification: The exchange rate used for a given month can change depending on the whole period you have selected!
      • Eg: The exchange rate used for the January 2014 costs will be different if you have select only January 2014 or all 2014. In the first case the conversion will be using rate at January 2014 while the latter, the conversion will use the rate of December 2014.
    Note: Some graphics include a "FX effect" element. See the graph paragraph for explanations. There is a table which shows the rates used each month including historical rates (according to selection of period).
    Displaying the used rates - The rates used can be displayed by double clicking on the following icon:

    Image Modified

    After which a table containing the exchange rates used for the month of the different foreign currencies available:

    Image Modified


    Info
    iconfalse
    titleTarget Users
    • Finance
    • Controlling
    • Industrial
    Info
    iconfalse
    titleAuthorization & Rights
    All the accesses must be validated by the
    GBU Finance or Industrial Directors
    Authorisations' rights per GBU or Function, Zone, Plant
    Access form