SYMPA ACADEMY

 

How has been structured the training?

1- The first part explains the construction of the BFC P/L. Several concepts need to be presented such as Master Data, closing process and Product Costing. Master Data are the static concepts used to carry out properly the closing process. Closing subsection demonstrate the dynamic use of the master data. Product costing is a sub-product but it is an important section because a big amount of the Cost of Goods Sold (COGS) is built during product costing process. 

2- The second part presents all the reports to be used to carry out performance analysis and how you can use those reports.

 

 

 

BFC P/L

 

 

 

  • Initial inventory = 0
  • Variable cost = 60
  • Fixed Cost Period = 40
  • Dep. Period = 10
  • Sales = 60%

 

 

 

BFC P/L before the implementation of SYMPA model.

  • R25460-FC period = 0
  • R25470-Non proportional Cost Absorbed = 0

Those two lines are every month equal to 0 in the BFC P/L before the implementation of SYMPA model.

FC + Dep. Period = 40 + 10 = 50

We have sold 60% => 50*60% = 30

R25490 COGS FC = 30 – Dep. = 30 – 10 = 20

R25860 Dep. Period  is a FI information available in the balance sheet. In this example, Dep. Period = 10

Let’s imagine that next month there are no sales => COGS has to be equal to 0 but  Dep. Will be still equal to 10. => COGS = 0 – Dep. = 0 – 10 = -10 It is not relevant.   

 

BFC P/L : Theory

  • R25460-FC period = 40 => In PF1 model all the costs of the period are sent to inventories.
  • R25470-Non proportional Cost Absorbed = -40 => this amount reflects the counterpart in the P/L of the balance sheet posting (inventory account). Full absorption is the model applied in PF1, so Non proportional cost absorbed corresponds to the full amount of FC period.
  • R25490-FC COGS = variable cost * sales = 40 * 60% = 24
  • R25860 Dep. Period  is a FI information available in the balance sheet. In this example, Dep. Period = 10
  • R25870 Dep. Absorbed = -10 => Full absorption is the model applied in PF1, so Dep. absorbed is the absorption of the full amount of Dep. period.
  • R25890-Dep. COGS = dep. period * sales = 10 * 60% = 6

 

BFC P/L : From theory P/L to PF1 P/L after implementation of the SYMPA model

The theoretical P/L has been not selected and implemented because the use of R25870-Dep Absorbed and R25890-Dep. COGS would have driven erroneous REBITDA calculation.

  • R25460-FC period = 40 => In PF1 model all the costs of the period are sent to inventories.
  • R25470-Non proportional Cost Absorbed =  Full absorption of FC period + full absorption of Dep. = -40 + -10 = -50.
  • R25490-FC COGS = variable cost * sales + Dep Period * sales = 40 * 60% + 10 * 60% = 24 + 6 = 30
  • R25860 Dep. Period  is a FI information available in the balance sheet. In this example, Dep. Period = 10
  • R25870 Dep. Absorbed = 0
  • R25890-Dep. COGS = 0

 

Where are the data coming from to build BFC P/L? 

In SAP, it is not possible to obtain a report that explains the origin of the costs. The split between fixed costs, variable costs and depreciation are available in BFC P/L thanks to a specific program that combines PCA + ML + FI. 

Here, you have a representation of what is used in each P/L line. 

 

SECTION 1 Construction of the P&L

 

 

Logistics Organizational Unit representing the place where either materials are produced or goods and services provided.

Identification of production and non production plants.

Use in CO:

  • Organizational Cost Centers standard hierarchy 
  • Profit Centers standard hierarchy 
  • Cost Object Hierarchy (first 2 levels in the structure) 
  • Materials: To identify the ones relevant for costing and to be updated during the Project (Accounting / Costing views). 
  • Material Ledger activation (customizing).

1 digit code identifying the country inside Solvay ERP.

Use in CO:

  • Reporting Profit Centers codification at PIF level (position before last)

It is used in the codification of the Cost Centers (=first two digits) in PF1.

The establishment code is a combination of a legal company on a site

  • SM = cy 0001 SCH
  • XR = cy 0270 Solvay Quimica, Italian in Rosignano
  • SV = cy 0306 Solvay Portugal, Prod Quim.

The codes are part of the enterprise structure and managed by Core Tables 

The establishment code can be displayed with PF1 - ZPRI Display table ETAB

KA03 - Display Cost Element

KAH3 - Display cost element group

 

 

 

 

 

 

 

The Result (Reporting) Profit Centers are the basis for Group reporting

All elements for BFC statement are extracted from the Profit centers (except NETV, QTV and TPT which are extracted from CO-Profitability Analysis -> CO-PA). To make this extraction work (through interfaces), all objects in CO must be assigned to a profit center;
  • Material (plant level, Costing view)
  • Cost centers
  • CO orders
  • PM orders
  • PP orders
  • Cost collectors
  • WBS
The Result Profit centers are depending on the Profit center group “CHEFCHEOPS”. These profit centers are generally assigned to all the ERP companies;
The non reporting Profit Center are in group “CHEF_CNTRL

 

 

 

The person responsible of a cost center is accountable for the elements allocated in the cost center

The companies using SRM7 for purchasing should have a SRM7 user ID (=BIP user ID) entered in this field, starting with 5, such as 50000000

To display the list of person responsible use the report PF1 - SRM Validators in cost centers

Usually the name & description of a cost center is free but in some cases there can be special needs.

An assessment cycle is used in SAP to assign all primary cost elements and secondary cost elements from a sending cost center to the receiver cost center.When you want to transfer costs from one cost center to another through an assessment cycle, sap use a secondary cost element and accumulates all the primary cost and secondary cost and send it to the receiving cost center.

A distribution cycle is used in SAP to transfer primary costs from a sender cost center to receiving controlling objects. The original cost element remains the same. 

COPA Assessment cycle assesses costs from a Cost Center to COPA Value Fields. 

 

 

 

Root cause analysis for the contribution margin readability: split building between «Variable costs» and «Fixed costs» 

 

PRG vs ML: Main Differences


  • PRG provides the product Costing at Cost Object hierarchy (Group of Materials)
  • Material Ledger Provides it at Material code Level
  • PRG provides info about Utilities consumption and other SKF
  • Material Ledger does not
  • Material Ledger is integrated and is the basis for the Cost of Good Sold.

 

SECTION 2 Usage of different reports to explain PL

Use PF1 - KE30 - Report Z1KCHEOPS to have a report of Sales (R10000) & variable logistic costs (R12910)

 

 

PF1 Data have been merged in BW – production - WBP to facilitate the analysis of GBUs using WP1 & PF1. For more details, you can visit RtR PE Reporting

Access WBP and Open a data source or workbook or go to BW - Analysis Workbook Guide for more details regarding BW

To have the P&L in BW you can use the report ZZKPL_M01_BASIC_02

 

 

 

Other reports that can be used

ReportDescription of the report

ZZKPL_M01_CONSO_01

P&L - Consolidation Report.

Not used at legal entity level but used by GBU controllers. It is set-up with the consolidation methodology used in BFC

ZZKPL_M01_CONSO_03

P&L - Consolidation Report

Integrated Margin. It considers the Margin taking in account the production cost at Origin. Only available for SpP and Soda Ash (active also for Peroxide but not validated yet with GBU controller).

 

 

 

 

With S_ALR_87013615 - Breakdown by Partner,

To have a report of R25460 - Absorption variance: Period non-proportional costs of production (excl depr) & R25860 - Absorption variance: Period non-proportional depreciation of production

Select:

  • Cost centers group : CCCCXXCC; where CCCC is company code XX the 2 digits of the division (or activity 1)
  • Cost elements group. Use the group Rules - Cost element Group XCS-ALL or its subgroups
    • XCS-FCPE  in case you want to report Period Fixed costs
    • XCS-DEPPE in case you want to report Period Depreciation

To have a report of Administrative expenses (non-functions) (R33310), Commercial expenses (R33320) & Shared service function expenses (function costs at the origin) (R33400)

Select:

 

The report will not tie with the P&L when:

  • there are direct posting in Reporting cost centers,

  • there are costs centers not using the appropriate allocation structure

 

 

 

Use the report PF1- Z1K_MATCOST_SYMPA - Prix de revient

There are PRG templates that:

  • Are provided to controllers for their scope: Entity - plant
  • There are adapted to local request.
  • Filters can be changed by controllers: eg unfilter depreciation services. Or they can add other dimension.