Fixed Costs Dashboard

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

• Plant (Data from RCS):
  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)
  
  
  Then in KE53, check the "Department" field (shown as below)
  
  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

• Production Costs

• All Costs (combination of Function and Production Costs)

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

• Cost Element hierarchy

  • Grp 1

  • Grp 2

  • Grp 3

  • Grp 4

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

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).

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

This chart only shows current year's result.

By Value

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.

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:

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