Access the workbook

The workbook to be used is BW_WBK_OSC_0001 - ONE SOLVAY SYENSQO - Cost center Analysis

=> Go to Analysis for Office in excel 

=> Click "Open Data Source"

Go to the tab "Role" and open the folder FC - GBU Fixed Cost

Double-click on the workbook BW_WBK_OSC_0001 - ONE SOLVAY SYENSQO - Cost center Analysis  to open it

Open the workbook

It is mandatory to enter

• the conso view (1): by default, it is recommended to enter 0
• the cost center perimeter (2): by default, it is recommended to enter 1
• Fiscal Year/Period (5): MMM.YYYY

To avoid authorization issues, enter: 

• the authorization scope (3): ECO (PO2 - BW - Authorization scopes).

It is also recommended to enter at least a GBU, a company code or a plant code (4)

It is also possible to enter:

• a target currency (7) for conversion. By default the exchange rate type is C but you can change it and replace by CAR3. (P&L - Exchange rates)

• Variable Cost (6): you can include or exclude variable costs in your report. The determination of variable costs is based on Mixed Cost Center. By default variable costs are excluded with  != X

Click "OK" 

Set-up a basic report

Production fixed costs

In this example, the aim is to build a fixed costs report for the production plant Collonges (7622) in January 2024. 

Enter in the prompt 

• Fiscal Year/Period (5): 001.2024
• Responsible Plant (4): 7622

When you start working with the workbook, you see by default

• All cost centers
• All type of postings: fixed costs, depreciation, COPA

In order to filter Production fixed costs of the site, we must

• Exclude depreciation & COPA cost elements 
• Filter production cost centers

Click the button "display" to show the "Design Panel"

1. Filter ZCBS group 2 Function = EPRD (=production cost centers)
2. Exclude cost elements groups 
   • ZSO-29993
   • ZSO-29993B
   • ZSO-IND31
   • ZSO-IND41
   • ZSO-IND42
   • ZSO-IND51

You can watch the video to see how to do it.

How to understand the report

Once you have filter the production cost centers and excluded non fixed costs cost elements, look at the total "Actual - Destination" 

It should be exactly the same amount as what you see in the P&L (KE30 - Profitability report), value field E01 Period fixed costs for the same selection (Period & plant)

If there is no discrepancy you can build a report using the field you want. 

SG&A

In this example, the aim is to build a SG&A report for the GBU Silica in Rhodia Operation (ZFR3) in January 2024. 

Enter in the prompt 

• Fiscal Year/Period (5): 001.2024
• BFC - GBU (4): SI
• Company code: ZFR3

 In order to filter SG&A costs, we must

• Exclude depreciation & COPA cost elements 
• Filter SG&A cost centers (2 Function = EADM & EMSV)

How to understand the report

Once you have filter the SG&A cost centers, look at the total "Actual - Destination" 

It should be exactly the same amount as what you see in the P&L ( KE30 - Profitability report ),

• 2 Function = EADM = value field  I25 G&A Adm.Expenses for the same selection 
• 2 Function = EMSV = value field I15 G&A Com.Expenses for the same selection

If there is no discrepancy you can build a report using the field you want.