Versions Compared

Key

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

 

Image AddedImage Removed

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

General Description

Capex Dashboard consists indicators on Budget, Capex, Capital Spend, Downpayment and Commitments of the group.

The
Capex dashboard provides "actual" status and cost of projects allowing GBUs' controllers and project managers to keep track on all projects of its movement as and when needed. The dashboard also provides a "Cash Due" information where it shows the upcoming amount that needed to be pay to suppliers in next and two months' time.
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
17 By for GBU Cost (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
  • BFC GBU = WBS Responsible GBU
  • Plant
  • Project Scale
    a: Current (Previously known as Current) - below € 1m
    b: Major (Previously known as Strategic) - above  € 10m
    c: Medium (Previously known as Normal) - between € 1m to € 10m
  • Period of Analysis
    • Year - 1
    • Year
    • Quarter
    • Month
    Currencies
    • EUR, USD, BRL, SGD, PLN, CNY, KRW, INR
    • Conversion rate : End of month
      For Budget, rate of the project creation date. If this date is empty, last know rate (M-1 Y)
      For Capital Spend and Capex, historical rate (eg. CAPEX of January 2015 ===> conversion rate end of January 2015)  
    • (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 Added
        Image Added
    • Plant (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 Added

      Then in KE53, check the "Department" field (shown as below)
      Image Added

    • 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 Added

    • 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 Added

    Period of Analysis
    • Year - 2
    • Year - 1
    • Current Year
    • Quarter
    • Month
    Year, Quarter, Month Year and Month are based on the Fiscal Period.
    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 Added

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

    Image Added

    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, Zone, Plant
    Access form