| Info | ||
|---|---|---|
|
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"
- Filter ZCBS group 2 Function = EPRD (=production cost centers)
- 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.
| Multimedia | ||
|---|---|---|
|
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)
| Info |
|---|
In case of discrepancies go to FC - What are the main sources of discrepancies? |
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
| Info |
|---|
In case of discrepancies go to FC - What are the main sources of discrepancies? |
If there is no discrepancy you can build a report using the field you want.
Set-up a detailed report
when you have a good understanding of the report, you can add additional information in the report. You can refer to the list FC - Characteristics to have a definition of each dimension available in the report.